Question: Using the dataset below, make forecasts by three methods: 2-quarter moving average, 3- quarter moving average, and exponential smoothing. 8 Quarter 1 2 3 4

Using the dataset below, make forecasts by three methods: 2-quarter moving average, 3- quarter moving average, and exponential smoothing. 8 Quarter 1 2 3 4 5 6 7 Demand 25 27 26 21 27 26 22 25 Direction --- Record the following steps. No need for a webcam. 1. Type the data in Excel 2. Run the exponential smoothing method with 1. forecasts for quarters 13, 14, and 15, and 2. performance statistics. 3. On a separate worksheet, run 2-quarter moving average through quarters 13, 14, and 15. 4. Calculate Errors, Absolute Errors, Absolute Percentage Errors, Squared 5. Calculate Bias, MAE, MAPE, and RMSE 6. Calculate Lower Limits and Upper Limits for the forecasts. 7. Name the worksheet: 2Qtr MA 8. Duplicate the worksheet and rename it 3Qtr MA. 9. Update the model in the copied worksheet to the 3-quarter moving average. 10. Type the cell address (for example, B25) for each question below in the Excel file. 1. Forecasts for Q13, Q14, and Q15 by Exponential smoothing are in cells___ and respectively. 2. Forecasts for Q13, Q14, and Q15 by 2-quarter moving average are in cells and respectively. 3. Forecasts for Q13, Q14, and Q15 by 3-quarter moving average are in cells and 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!

Case Study- Furnmart Inc. Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does not have the financial resources to hold high...

Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does not have the financial resources to hold high levels of inventory, and...

Hello-I just don'y understand the last three questions please (6-7-8) Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does...

Hello-I just need help with the last 2 questions (7-8) Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does not have the...

The company does not have the financial resources to hold high levels of inventory, and therefore manufactures its furniture per sale orders. This strategy causes long delivery times (4-5 weeks) and...

Case Study- Furnmart Inc. Furnmart Inc is a medium-size Ontario Company, which supplies office furniture to different shops in the GTA. The company does not have the financial resources to hold high...

32. (26 points) Historical demand for Peeps is as displayed in the table. dnua Apl |3 ] -'- | a4 | June | 53 | July | 67 | | September | 96 | (1) (14 points) Please make forecast, based on historical...

Almo Company manufactures and sells adjustable canopies that attach to motor homes and trailers. The market covers both new unit purchases as well as replacement canopies. Almo developed its 2010...

Penguin Corporation acquired a 60% interest in Squid Corporation on January 1, 2014, at a cost equal to 60% of the book value of Squid's net assets. At the time of the acquisition, the book values of...

Governmental activities are to be classified as governmental or enterprise wide

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...