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 14 weeks, and wants to forecast what sales will be in the upcoming week (week 15).
Construct both a weighted moving average and a linear trend forecast. For the weighted moving average, use the previous three periods, with weights of .60 for the most recent previous period, .30 for the second most recent previous period, and .10 for the third most recent previous period. For each technique, provide the forecasted values for both week 15 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.
 Use the data in the Excel file for this assignment. These

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!