Question: Use the data in the Excel file for this question. A commercial bakery has recorded demand for Cupcakes. So far, the restaurant has been selling
Use the data in the Excel file for this question. A commercial bakery has recorded demand for Cupcakes. So far, the restaurant has been selling the item for 10 days and wants to forecast the demand on an upcoming day (day 11). Fill out the answer and upload your work.
b. Calculate the Mean absolute deviation (MAD) for both nave (nave forecast with stable time series) and a moving average forecast based on previous days' forecasts.
| c. Based on results in b, please state which forecasting technique (nave? or moving average?) seems to work better for the data.
|
Needed to to find answer:
| Period | Demand |
| 1 | 45 |
| 2 | 26 |
| 3 | 27 |
| 4 | 23 |
| 5 | 22 |
| 6 | 28 |
| 7 | 29 |
| 8 | 20 |
| 9 | 14 |
| 10 | 18 |
| 11 | ??? |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
