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 2 years 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
- Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 &nb
- In a two – story building, an exterior column is to be designed for a service...
- Explain the use of neural networking modeling in predictive analytics. Discuss a real-life example of where...
- Boarder line and antisocial disorder are perhaps the most research personality disorder.What are the most common...
- Read at least 2 academically reviewed articles and Write an annotated bibliography paper on Master Budgeting
- Why normalization and referential integrity are important principles when designing relational databases?
- Respond to the following in a minimum of 175 words: Discuss what elements should be present...
ADVERTISEMENT