Question: table [ [ MONTH , SALES ] , [ January , 2 0 ] , [ February , 2 1 ] , [ March

\table[[MONTH,SALES],[January,20],[February,21],[March,15],[April,14],[May,13],[June,16],[July,17],[August,18],[September,20],[October,20],[November,21],[December,23]]
a) Plot the monthly sales data.
b) Forecast January sales using each of the following:
i) Naive method.
ii) A 3-month moving average.
iii) A 6-month weighted average using .1,.1,.1,.2,.2, and .3. with the heaviest weights applied to the most recent months.
iv) Exponential smoothing using an =.3 and a September forecast of 18.
v) A trend projection.
c) With the data given, which method would allow you to forecast next March's sales? PX (MyLab Operations Management also includes a shorter (brief) version of this problem.)
 \table[[MONTH,SALES],[January,20],[February,21],[March,15],[April,14],[May,13],[June,16],[July,17],[August,18],[September,20],[October,20],[November,21],[December,23]] a) Plot the monthly sales data. b) Forecast January sales

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!