Question
In: Advanced Math
Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year...
Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year 6 using the 3-period moving average and 4-period moving average. Evaluate the bias, TS, MAD, MAPE and MSE. Evaluate the quality of the forecast
|
Sales |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
JAN |
2000 |
3000 |
2000 |
5000 |
5000 |
|
FEB |
3000 |
4000 |
5000 |
4000 |
2000 |
|
MAR |
3000 |
3000 |
5000 |
4000 |
3000 |
|
APR |
3000 |
5000 |
3000 |
2000 |
2000 |
|
MAY |
4000 |
5000 |
4000 |
5000 |
7000 |
|
JUN |
6000 |
8000 |
6000 |
7000 |
6000 |
|
JUL |
7000 |
3000 |
7000 |
10000 |
8000 |
|
AUG |
6000 |
8000 |
10000 |
14000 |
10000 |
|
SEP |
10000 |
12000 |
15000 |
16000 |
20000 |
|
OCT |
12000 |
12000 |
15000 |
16000 |
20000 |
|
NOV |
14000 |
16000 |
18000 |
20000 |
22000 |
|
DEC |
8000 |
10000 |
8000 |
12000 |
8000 |
|
Total |
78000 |
89000 |
98000 |
115000 |
113000 |
Solutions
Colby Messinger answered 1 year agoRelated Solutions
The 2018 Balance Sheet for ABC Corporation is shown below: Assets &nb
The 2018 Balance Sheet for ABC Corporation is shown below:
Assets
Liabilities
Cash
$10,000
Accounts
Payable
$ 8,000
Accounts Receivable
20,000
Accruals
2,000
Inventory
40,000
Total Current
Liabilities
$10,000
Total Current Assets
$70,000
Bonds
$30,000
Net Fixed
Assets
$150,000
Total
Liabilities
$40,000
Owners
Equity
Common
Stock
$100,000
Retained
Earnings
80,000
Total
Assets
$220,000
Total Liabilities & Owners Equity $220,000
The firm is currently operating at 100% capacity
with sales of $100,000. Management believes that...
In ABC City, the average demand of SMART PHONES is 600 units. The May monthly index is 1.5. what is the seasonally adjusted sales forecast for May?
In ABC City, the average demand of SMART PHONES is 600
units. The May monthly index is 1.5. what is the seasonally
adjusted sales forecast for May?A.1200 unitsB.400 unitsC.900 unitsD.No sufficient data to calculate
Q6: Calculation of ABC stock's beta. Below are 16 monthly ·percentage returns of ABC stock and...
Q6: Calculation of ABC stock's beta. Below are 16 monthly
·percentage returns of ABC stock and of the index.
Calculation of Beta
Column1
Column2
Month
ABC stock return
Index return
1
-13.38
2.52
2
16.79
5.45
3
-1.67
0.76
4
-3.46
2.36
5
10.22
8.56
6
7.13
8.67
7
6.71
10.8
8
7.84
3.33
9
2.15
-5.07
10
7.95
7.1
11
-8.05
-11.57
12
7.68
4.65
13
4.75
14.59
14
7.55
2.66
15
-2.36
3.81
16
4.98
7.99
a. Calculate...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown
below:
Powell Panther Corporation: Income Statements for Year
Ending December 31 (Millions of Dollars)
2019
2018
Sales
$
3,300.0
$
3,000.0
Operating costs excluding depreciation and amortization
2,475.0
2,550.0
EBITDA
$
825.0
$
450.0
Depreciation and amortization
86.0
66.0
Earnings before interest and taxes (EBIT)
$
739.0
$
384.0
Interest
72.6
66.0
Earnings before taxes (EBT)
$
666.4
$
318.0
Taxes (25%)
266.6
127.2
Net income
$
399.8
$
190.8
Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown
below:
Powell Panther Corporation: Income Statements for Year
Ending December 31 (Millions of Dollars)
2019
2018
Sales
$
3,190.0
$
2,900.0
Operating costs excluding depreciation and amortization
2,712.0
2,465.0
EBITDA
$
478.0
$
435.0
Depreciation and amortization
73.0
64.0
Earnings before interest and taxes (EBIT)
$
405.0
$
371.0
Interest
70.2
63.8
Earnings before taxes (EBT)
$
334.8
$
307.2
Taxes (25%)
133.9
122.9
Net income
$
200.9
$
184.3
Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown
below:
Powell Panther Corporation: Income Statements for Year
Ending December 31 (Millions of Dollars)
2019
2018
Sales
$
3,105.0
$
2,700.0
Operating costs excluding depreciation and amortization
2,562.0
2,295.0
EBITDA
$
543.0
$
405.0
Depreciation and amortization
81.0
65.0
Earnings before interest and taxes (EBIT)
$
462.0
$
340.0
Interest
68.3
59.4
Earnings before taxes (EBT)
$
393.7
$
280.6
Taxes (25%)
157.5
112.2
Net income
$
236.2
$
168.4
Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown
below:
Powell Panther Corporation: Income Statements for Year
Ending December 31 (Millions of Dollars)
2019
2018
Sales
$
3,480.0
$
2,900.0
Operating costs excluding depreciation and amortization
2,871.0
2,465.0
EBITDA
$
609.0
$
435.0
Depreciation and amortization
109.0
84.0
Earnings before interest and taxes (EBIT)
$
500.0
$
351.0
Interest
76.6
63.8
Earnings before taxes (EBT)
$
423.4
$
287.2
Taxes (25%)
169.4
114.9
Net income
$
254.0
$
172.3
Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown
below:
Powell Panther Corporation: Income Statements for Year
Ending December 31 (Millions of Dollars)
2019
2018
Sales
$
2,420.0
$
2,200.0
Operating costs excluding depreciation and amortization
1,997.0
1,870.0
EBITDA
$
423.0
$
330.0
Depreciation and amortization
48.0
44.0
Earnings before interest and taxes (EBIT)
$
375.0
$
286.0
Interest
53.2
48.4
Earnings before taxes (EBT)
$
321.8
$
237.6
Taxes (25%)
128.7
95.0
Net income
$
193.1
$
142.6
Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown
below:
Powell Panther Corporation: Income Statements for Year
Ending December 31 (Millions of Dollars)
2019
2018
Sales
$
1,440.0
$
1,200.0
Operating costs excluding depreciation and amortization
1,116.0
1,020.0
EBITDA
$
324.0
$
180.0
Depreciation and amortization
42.0
32.0
Earnings before interest and taxes (EBIT)
$
282.0
$
148.0
Interest
31.7
26.4
Earnings before taxes (EBT)
$
250.3
$
121.6
Taxes (25%)
100.1
48.6
Net income
$
150.2
$
73.0
Common dividends...
Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year...
Financial information for Powell Panther Corporation is shown
below:
Powell Panther Corporation: Income Statements for Year
Ending December 31 (Millions of Dollars)
2019
2018
Sales
$
3,480.0
$
2,900.0
Operating costs excluding depreciation and amortization
2,610.0
2,465.0
EBITDA
$
870.0
$
435.0
Depreciation and amortization
96.0
87.0
Earnings before interest and taxes (EBIT)
$
774.0
$
348.0
Interest
76.6
63.8
Earnings before taxes (EBT)
$
697.4
$
284.2
Taxes (25%)
279.0
113.7
Net income
$
418.4
$
170.5
Common dividends...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Discuss the significance of a proposal What elements do you think are needed for the proposal...
- 1) Given the following equations: QD = 5,000 + 0.5 I + 0.2 A -...
- How has the Supreme Court's Citizens United decision changed campaigns in America? (long answer is appreciated...
- You are a Derivatives Trader at a major Broker-Dealer. At the end of the week you...
- What are the two reasons that limit the ability of correlational studies to provide information on...
- Suppose that 20 monthly payments of $100 each are followed by 30 monthly payments of $200...
- D. Explain what it means for recommendations to be specific and actionable. E. Discuss how charts...
ADVERTISEMENT