Question: Instructions- please show step by step! All work must be done in Excel. Each problem must be done on a separate sheet. Label the sheet

Instructions- please show step by step!

All work must be done in Excel.
Each problem must be done on a separate sheet. Label the sheet appropriately.
o Clearly indicate which sub-question is being answered
Show formulas for all calculations.
Instructions- please show step by step! All work
Instructions- please show step by step! All work
Problem-2 (30 pts) Daily sales volume for Nilgiris Convenience Store is provided in the tab Niligiris Convenience. a. Starting Day 11, the store wants to use exponential smoothing to forecast the next day's sales volume. But what value of a should it use? It is considering three values: 0.2, 0.5, and 0.9. Select the appropriate value of a by calculating forecasts for days 2 through 10 with each of these values and calculating the Mean Absolute Percent Error (MAPE). Assume in each case that the forecast for Day 1 was $300. (15 pts) b. The store sees an increasing trend in the data and decides to use a linear trend for forecasting. What is the trend equation for this data? (5 pts) c. Using the trend equation calculate forecasts for days 2 through 10. Calculate the MAPE of this set of forecasts. (8 pts) d. Compare the MAPE of the best a in (a) with the MAPE in (c). Which method would you prefer? (2 pts) Sales Day 1 $277 2 $661 3 $556 $678 4 5 $585 6 $619 7 $829 8 $780 9 $951 $847 10

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!