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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!