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, 21.06.2019 16:30

You are opening a new store and must project in your business plan the amount of inventory shrinkage. you have forecasted $1,200,000 in sales for the first year. assuming your shrinkage will be 5%, the high end of the national average, calculate the projected annual shrinkage for your business plan. you are opening a new store and must project in your business plan the amount of inventory shrinkage. you have forecasted $1,200,000 in sales for the first year. assuming your shrinkage will be 5%, the high end of the national average, calculate the projected annual shrinkage for your business plan.

Answers: 3

Answer

Business, 22.06.2019 20:40

David consumes two things: gasoline (g) and bread (b). david's utility function is u(g, b) = 10g^0.25 b^0.75. use the lagrange technique to solve for david's optimal choices of gasoline and bread as a function of the price of gasoline, p_g, the price of bread, p_b, and his income m. with recent decrease in the price of gasoline (maybe due to external shock such as shale gas production) does david increase his consumption of gasoline? for david, how does partial differential g/partial differential p_g depend on his income m? that is, how does david's change in gasoline consumption due to an increase in the price of gasoline depend on his income level? to answer these questions, find the cross-partial derivative, |partial differential^2 g/partial differential m partial differential p_g.

Answers: 1

Answer

Business, 22.06.2019 21:20

Rediger inc., a manufacturing corporation, has provided the following data for the month of june. the balance in the work in process inventory account was $28,000 at the beginning of the month and $20,000 at the end of the month. during the month, the corporation incurred direct materials cost of $56,200 and direct labor cost of $29,800. the actual manufacturing overhead cost incurred was $53,600. the manufacturing overhead cost applied to work in process was $52,200. the cost of goods manufactured for june was:

Answers: 2

Answer

Business, 22.06.2019 22:30

When the price is the equilibrium price, we would expect there to be a causing the market to put pressure on the price until it went back to the equilibrium price. a. above; surplus; upward b. above; shortage; downward c. below; surplus; upward d. below; shortage; downward e. above; surplus; downward?

Answers: 2

Answer

You know the right answer?

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

Questions