In: Operations Management
PROBLEM 1:
Sales records for the last six quarters for Howard Bakery which is
famous for its multi-grain bread are given below: (Sales data are
in thousands of pounds, but ignore the last three zeros for ease of
computation.)
Quarter Sales ($)
successive quarter.
Formulae to be used:
Error = Actual- Forecast
CFE= Sum of errors
a.
t | Actual, At | 3 period moving average forecast, | Error= Actual- Forecast |
q1 | 240 | ||
q2 | 260 | ||
q3 | 300 | ||
q4 | 280 | 266.67 | 13.3 |
q1 | 320 | 280.00 | 40.0 |
q2 | 360 | 300.00 | 60.0 |
q3 | 320.00 | ||
113.33 | |||
CFE |
b.
t | Actual, At | Forecast weighted moving average(wts 0.6, 0.3,0.1) | Error= Actual- Forecast |
q1 | 240 | ||
q2 | 260 | ||
q3 | 300 | ||
q4 | 280 | 282.00 | -2.0 |
q1 | 320 | 284.00 | 36.0 |
q2 | 360 | 306.00 | 54.0 |
q3 | 340.00 | ||
88.00 | |||
CFE |
c. Weighted moving average forecast is better than moving average forecast because its CFE is less than the other.