Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: 1 2 3 8 9 10 11 Year Registrations (000) 4 6 4 What is the MAD? 2.54 5 6 7 5 10 8 7 9 12 14 15 a. Develop a 3-year moving average to forecast registrations from year 4 to year 12. What is the forecast? 13.67 b. Estimate demand again for years 4 to 12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1. What is the forecast? [Select] What is the MAD? [Select] c. Use exponential smoothing with (a = .47), assume the initial period forecast is 5. What is the forecast for the next period? [Select] ✓ What is the MAD? [Select] d. Based on Error Analysis, which of the forecasting methods seems better? [Select]

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: 1 2 3 8 9 10 11 Year Registrations (000) 4 6 4 What is the MAD? 2.54 5 6 7 5 10 8 7 9 12 14 15 a. Develop a 3-year moving average to forecast registrations from year 4 to year 12. What is the forecast? 13.67 b. Estimate demand again for years 4 to 12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1. What is the forecast? [Select] What is the MAD? [Select] c. Use exponential smoothing with (a = .47), assume the initial period forecast is 5. What is the forecast for the next period? [Select] ✓ What is the MAD? [Select] d. Based on Error Analysis, which of the forecasting methods seems better? [Select]

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

c5 need urgent in 15 minutes
Given below are the demands of a certain product over the past 10 weeks. Week | 1 2 3 4 | 5 67|89 | 10 Demand 50 64 66 68 67 63 69 67 65 66 (a) Forecast the demand for the 13th week using the following techniques: i. 3- week weighted moving average with weights 0.2, 0.3, and 0.5 ii. Exponential smoothing with a smoothing constant equal to 0.85 ii. Adjusted exponential smoothing with a smoothing constant equal to 0.85 and smoothing constant for trend equal to 0.65 (b) Compute for the accuracy of each model using the mean squared error. Based on the computed MSE, what is the best forecasting technique for this time series?
b3 need urgent in 15 minutes
How can we monitor and control forecast in our interior designing business. Please provide with a relative example
What are the disadvantages and advantages of moving average technique and simple exponential smoothing?
forgiven product demand the time series trying equation is 53.3+2.1 X what is your forecast demand for period six?
OQ6
Rosa's Italian restaurant wants to develop forecasts of daily demand for the next week. The restaurant is closed on Mondays and experiences a seasonal pattern for the other six days of the week. Mario, the manager, has collected information on the number of customers served each day for the past two weeks. If Mario expects total demand for next week to be around 336, what is the forecast for each day of nvext week? (Round intermediate colculations to 4 decimal places, eg. 1.2645 and final answers to 1 decimal place, es 15.2) Number of custooers Day Week 1 Week 2 Tuesdav 45 47 Wednesday 34 28 Thursday 44 31 Friday 92 107 Saturday 104 94 Sunday 55 79 Forecast Day Tuesday
Demand at Nature Trails Ski Resort has a seasonal pattern.Demand is highest during the winter, as this is the peak ski season.However, there is some ski demand in the spring and even fallmonths. Th e summer months can also be busy as visitors oft encome for summer vacation to go hiking on the mountain trails.Th e owner of Nature Trails would like to make a forecast for eachseason of the next year. Total annual demand has been estimatedat 4000 visitors. Given the last two years of historical data, what isthe forecast for each season of the next year?
Week 1 2 4 Forecast Method 1 0.90 1.05 0.97 1.22 Actual Demand 0.72 1.05 1.00 0.97 Week 1 2 3 4 Forecast Method 2 0.82 1.19 0.90 1.17 Actual Demand 0.72 1.05 1.00 0.97 0 The MAD for Method 1 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 1 = thousand gallons (round your response to three decimal places). The MAD for Method 2 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 2 = thousand gallons (round your response to three decimal places).
part b)
A store’s demand figures are given in the table. According to this, what is the linear regression forecast for Week 12?