Question: Use the data in the Excel file for this assignment. These data represent sales ( in units ) of a new dessert item recently added
Use the data in the Excel file for this assignment. These data represent sales in units of a new
dessert item recently added to a restaurant's menu. So far, the restaurant has been selling the
item for weeks and wants to forecast what sales will be in the upcoming week week
Construct both a nave nave forecast with stable timeseries and moving average forecast.
For the moving average forecast, average the previous five periods. For each technique, provide
the forecasted values for both week as well as all of the previous weeks that the technique will
allow. Calculate the errors and MAD and MAPE. Based on these metrics, state which forecasting
technique seems to work better for these data.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
