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
- Use the bond term's below to answer the question Maturity 7 years Coupon Rate 4% Face...
- What experience have you had with Organization Development or with Change Management? Describe the organization, the...
- 1. Renfro Rentals has issued bonds that have a 12% coupon rate, payable semiannually. The bonds...
- Given an array of positive integers a, your task is to calculate the sum of every...
- Define “culture.” Software is defined by the Merriam-Webster Dictionary as "the programs that run on a...
- In humans, hypotrichosis (sparse body hair) is a rare autosomal recessive condition. Let h = hypotrichosis...
- Increase all of the listing prices by 5% for all listings under $500,000 and 10% for...
ADVERTISEMENT