Question: pls work or formula on excel The data is from problem 1 at the end of chapter 8. Beyond Tea Inc. wants to forecast sales

pls work or formula on excel
pls work or formula on excel The data is from
The data is from problem 1 at the end of chapter 8. Beyond Tea Inc. wants to forecast sales of its menthol green tea. Sales data from the past 10 months: Month 1 2 3 sales (lbs) 5 8 15 5 6 7 8 9 10 18 20 19 17 18 19 21 In an Excel file, answer the following questions. Make sure you answer each question in a different worksheet. For example, question 1 in sheet 1, question 2 in sheet 2, etc. a. Compute a 2-month moving average demand forecast for the month 3 to 10. Calculate MAD, MAPD and MSE. b. Compute the optimal 2-month weighted moving average demand forecast for the month 3 to 10. Calculate MAD, MAPD and MSE. c. Assume the demand forecast for month 1 is equal to the actual demand, 5. Compute the optimal exponentially smoothed demand forecast for the remaining 9 months. Calculate MAD. MAPD and MSE. d. Assume the demand forecast for month 1 is 5 and the trend is 0. Compute the optimal double exponentially smoothed demand forecast for the remaining months. Calculate MAD, MAPD and MSE. e. Compute linear trend line demand forecast for month 1 through 10. Calculate MAD, MAPD and MSE. f. Compare the five forecasting methods by using MAD, MAPD and MSE and indicate which method is the best fit for the data based on MAD, MAPD (or MAPE), and MSE, respectively

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!