Business, 26.01.2022 14:00 katherineweightman

Your Manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. MONTHACTUAL
DEMAND
163
266
368
469
570
672
773
873
973
1076
1185
1280
a) Calculate the simple three-moving average forecast for periods 4-12.
b) Calculate the weighted three-moving average using the following sets of weights :
1) 0.50, 0.30, and 0.20 for periods 4-12.
2) 0.40, 0.35, and 0.25 for periods 4-12.
3) 0.60, 0.25, and 0.15 for periods 4-12.
c) Calculate the single exponential smoothing forecast for periods 2-12 using the following information:
1) Initial forecast (F1) of 61 and an alpha of 0.10.
2) Initial forecast (F1) of 61 and an alpha of 0.20.
3) Initial forecast (F1) of 61 and an alpha of 0.30.
d) Calculate the forecast for periods 4-12 using simple linear regression using Excel.
e) Calculate the mean absolute deviation (MAD) and Mean square error (MSE) for all the previous forecasts made by each technique for the periods 4-12. Which forecasting method do you recommend to use?

Answers: 3

Show answers

Another question on Business

Business, 22.06.2019 06:40

10. which of the following is true regarding preretirement inflation? a. defined-benefit plans provide more inflation protection than defined-contribution plans. b. because of preretirement inflation, possible investment-related growth is increased for defined-contribution plans. c. all types of benefits are designed to cope with preretirement inflation. d. preretirement inflation is generally reflected in the increase in an employee's compensation level over a working career.

Answers: 3

Answer

Business, 22.06.2019 19:10

Below are the steps in the measurement process of external transactions. arrange them from first (1) to last (6). event step post transactions to the general ledger. assess whether the transaction results in a debit or credit to account balances. use source documents to identify accounts affected by an external transaction. analyze the impact of the transaction on the accounting equation. prepare a trial balance. record the transaction in a journal using debits and credits.

Answers: 3

Answer

Business, 22.06.2019 20:40

Which of the following is true concerning the 5/5 lapse rule? a) the 5/5 lapse rule deems that a taxable gift has been made where a power to withdraw in excess of $5,000 or five percent of the trust assets is lapsed by the powerholder. b) the 5/5 lapse rule only comes into play with a single beneficiary trust. c) amounts that lapse under the 5/5 lapse rule qualify for the annual exclusion. d) gifts over the 5/5 lapse rule do not have to be disclosed on a gift tax return.

Answers: 1

Answer

Business, 22.06.2019 21:30

Sunset foods relies on a highly centralized functional structure to ensure consistency in the quality and taste of its products and to drive down costs via process innovations. however, as a consequence of its highly compartmentalized structure, the firm has found it difficult to transfer information and ideas from one department to the next. with the launch of its new line of breakfast foods coming up, how can sunset improve its ability to collaborate without sacrificing the benefits of its current structure

Answers: 1

Answer

You know the right answer?

Your Manager is trying to determine what forecasting method to use. Based upon the following histori...

Questions

Business, 29.08.2019 13:10

Team planning is most effective when the group leader develops the overall plan and then solicits feedback from the group....