officeStar is company that produces office water coolers .The company wishes to implement an MRP system for one of its products , identified as the modle C10 cooler . The montly sales for this water cooler for the past 10 months are given in table 1
|
Month
|
May
|
June
|
July
|
Aug
|
Sept
|
OCt
|
Nov
|
Dec
|
jan
|
feb
|
|
Sales of volume
|
150
|
185
|
320
|
317
|
400
|
500
|
360
|
210
|
480
|
300
|
a - forecast the demand for march (the next month ) using the following
- A three month moving avege
- Naive method
- Aweighted moving averge using 0.60 febreuary ; 0.25 for january; and 0.15 for week december
b- calculate the mean absolute percent ( MSE) for each of the above methods
which methods seems the most appropriate?