EXERCISE 9 - FORECASTINGQuestion 1The following data summarizes the historical demand for a product:ActualMonthDemandMarch20April25May40JuneJulyAugust353045i.Use a four-period moving average to determine the forecasted demand for July, August,and September.If the forecasted demand for June, July, and August is 32, 38 and 42, respectively, whatis MAD?If the forecasted demand for June, July, and August is 32, 38 and 42, respectively, whatis MSE?ii.iii.iv.If the forecasted demand for June, July, and August is 32, 38 and 42, respectively, whatis MAPD?

Given- Month Actual Demand March 20 April 25 May 40 June 35 July 30 August 45

Answered: EXERCISE 9 - FORECASTING Question 1 The…

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

Two different forecasting models were used to forecastsales of a popular soda on a college campus. Actual demand andthe two sets of forecasts are shown. Use MAD to explain whichmethod provided a better forecast.
Step 1 of 4: Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place. Step 2 of 4: Determine the three-period weighted moving average for the next time period with weights of 33 (most recent), 22 (second latest time period), and 11 (oldest time period). If necessary, round your answer to one decimal place. Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.500.50. If necessary, round your answer to one decimal place. Step 4 of 4: Which forecasting method is best and why?
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 20 2 20 Week 1 Demand 20 Forecast 20.0 3 29 4 37 4 37 5 24 2 3 29 20 6 30 7 8 37 24 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): 5 6 30 24 7 37 9 24 8 24 10 28 9 24 10 28
2. An operation specialist used two forecast methods to forecast demand for a certain word processing software package. Actual demand and his corresponding predictions are shown below: Month Sales Forecast A Forecast B January 60 February 25 60 March 54 50 42 April 36 30 55 May 45 45 35 June 60 20 Which forecast method would you recommend if using MAD as the accuracy measurement? Select one: a. Forecast A b. Forecast B c. No preference.
Use simple exponential smoothing with a -0.8 to forecast electric scooter sales at Guelph- Humber Inc. for July. Assume that the forecast for May was for 45 electric scooters. Round your answer to 1 decimal Electric Scooter Sales Month May 42 June 47 July 45 August 40 Weekly demand for medical masks for the last five weeks at Chopper Drug Store has been as follows: 92, 96, 100, 100 and 102 (listed from the oldest to most recent). Suppose a naive forecast was used to forecast demand. What would the MAD be for this situation? Enrollment in a particular Yoga class at Guelph Fitness Centre for the last five months has been 80, 86, 88, 88 and 90(listed from the oldest to most recent). Suppose a two-month mov average was used to forecast enrollment. What would the MSE be for this situation?
A forecast for the first six months of the year revealed a tendency to underpredict the actual demand for the revitalized Hubig’s Pies plant in the Marigny. Month Actual Forecast January 675 600 February 720 700 March 640 620 April 510 495 May 480 410 June 565 535 What is the mean squared error of this forecast? a. 1,694 b. 1,873 c. 2,075 d. 1,469
The following table shows predicted product demand using your particular forecasting method along with the actual demand that occurred: FORECAST ACTUAL 1,480 1,530 1,380 1,480 1,680 1,580 1,730 1,780 1,630 1,680 Compute the tracking signal using the mean absolute deviation and running sum of forecast errors. Note: Negative values should be indicated by a minus sign. Round your "Mean Absolute Deviation", "Tracking Signal" to 2 decimal places and all other answers to the nearest whole number. Period Forecast Actual Deviation RSFE Absolute Deviation Sum of Absolute MAD TS Deviation 1 1,480 1,530 -50 -50 50 50 50.00 -1.00 2 1,380 1,480 -100 -150 100 150 75.00 -2.00 3 1,680 1,580 100 -50 100 250 83.33 -0.60 4 1,730 1,630 100 50 100 350 87.50 0.57 5 1,780 1,680 100 150 100 450 90.00 1.67
A recently introduced product has a positive trend in sales. The product’s sales have increased in each of its first eight weeks on the market. The forecast for week 6 was 1,325 (F6 = 1,325), with A6 = 1,283 and T6 = 42. Using smoothing components α = 0.20 and β = 0.30, develop forecasts for weeks 7 and 8.
One forecasting model was used to forecast demand for a product. The forecasts and the demand are shown in the table below. Use two decimals in your answer. Actual Forecast 1 40 41 2 35 38 3 38 35 4 33 30 The Mean Absolute Deviation (MAD) is O 0.5 2.5 O 1.48 7.01
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two moving average forecasting methods to see which one was better over this period. Month Actual Demand Jan 120 Feb 140 March 160 April 180 May 170 June 190 July 150 August 160 September 170 a. Forecast April through September using a three-month moving average and calculate MAD for the forecasts. b. Forecast May through September using a four-month moving average and calculate MAD for the forecasts.
The Toro Cutlery Company has collected monthly sales information below: MONTH January February March April The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): 87667 Forecast (January, 4-month MA): 72500 Forecast (January, 5-month MA): 69600 b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearest whole number. SALES 25,000 18,000 43,000 110,000 MONTH May June July August SALES MONTH 84,000 September 28,000 October 97,000 November 58,000 December SALES 27,000 105,000 82,000 76,000
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS