Question: Historical demand for a product is attached below. a) Using a three-month moving average, the July forecast is [ Select A.) 15, B.) 13, C.)
Historical demand for a product is attached below.
a) Using a three-month moving average, the July forecast is [ Select A.) 15, B.) 13, C.) 14, D.) 12 ].
b) Using single exponential smoothing with =0.2 and a June forecast 13, the July forecast is [ Select A.) 14, B.) 15, C.) 12, D.) 13 ].
c) Using simple linear regression analysis, the regression equation for the preceding demand data is Y = [ Select A.) 11.8, B.) 0.63, C.) 0.77, D.) 10.8 ] + [ Select A.) 11.8, B.) 0.63, C.) 0.77 D.) 10.8 ] x.
d) Using the regression equation in the last part, the July forecast is [ Select A.) 16.2, B.) 13.5, C.) 15.2 D.) 76.4].
| Demand | |
| January | 12 |
| February | 11 |
| March | 15 |
| April | 12 |
| May | 16 |
| June | 15 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
