Question: table [ [ , Demand ] , [ January , 1 2 ] , [ February , 1 1 ] , [ March ,

\table[[,Demand],[January,12],[February,11],[March,15],[April,12],[May,16],[June,15]]
a. Using a weighted moving average with weights of 0.60,0.30, and 0.10, find the July forecast.
b. Using a simple 3-month moving average, find the July forecast.
c. Using single exponential smoothing with a=0.2 and a June forecast ~~13, find the July forecast. Make whatever assumptions you wish.
d. Using simple linear regression analysis, calculate the regression equation for the demand data.
e. Using the regression equation in d, calculate the forecast for July.
 \table[[,Demand],[January,12],[February,11],[March,15],[April,12],[May,16],[June,15]] a. Using a weighted moving average with weights of 0.60,0.30,

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!