5-15 Develop a 4-month moving average forecast for WallaceGarden Supply, and compute the MAD. A 3-month moving averageforecast was developed in the section on moving averages inTable 5.2 0. ΜΟΝTΗACTUAL SHED SALES3-MONTH MOVING AVERAGEJanuary10February12-March13April16(10 + 12 + 13)/3 = 11.67Мay19(12 + 13 + 16)/3 = 13.67June23(13 + 16 + 19)/3 = 16.00July26(16 + 19 + 23)/3 = 19.33August30(19 + 23 + 26)/3 = 22.67September28(23 + 26 + 30)/3 = 26.33October18(26 + 30 + 28)/3 = 28.00November16(30 + 28 + 18)/3 = 25.33%3DDecember14(28 + 18 + 16)/3 = 20.67January(18 + 16 + 14)/3 = 16.00Table 5.2 Wallace Garden Supply Shed Sales

Answered: Image /qna-images/answer/264efe00-0ee6-4b9c-a4b9-f40aa9b63fa7.jpg

Answered: 5-15 Develop a 4-month moving average…

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

The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: a) Forecast the number of disk drives to be made next year, using linear regression.b) Compute the mean squared error (MSE) when using linear regression.c) Compute the mean absolute percent error {MAPE).
FORECASTING- EXPONENTIAL SMOOTHING QUESTION 3 PERIOD АCTUAL 1 42 2 40 3 43 4 40 5 41 39 7 46 8 44 9. 45 10 38 11 40 12 a) Consider exponential smoothing forecasts using smoothing constants (a) 0.1 and 0.4
Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361 What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?
1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows. Auto Week Demand 1 9. 2 11 3 8 4 12 5 10 13 7 7 8. 12 Develop a 3-week moving average forecast for Weeks 4 through 9 a Develop a 3-week weighted average forecast for weeks 4 through 9 with weights of d. What is the Naïve forecast for Week 9?
Forecasting Historical records show the past ten Hood Lacrosse games having the following attendance:5348, 7814, 6515, 5785, 5984, 6522, 6286, 5581, 6714, 7347Assuming no seasonal component, what should the concessions staff use as an estimate for thenext game? Please use a four-period moving average for this forecast. please use excel for solving
Use the sales data in the table ( attached Image) and apply the same forecast method when α = 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, and 1. What is the best value for α? What does the best value of α indicate or show in regards to the forecast model? (Hint: Use Microsoft Excel to solve the question)
Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average and exponential smoothing methods to forecast the demand for Week 17.Assume the following:Simple moving average method: two-week moving averageSingle exponential smoothing method: assume the 1st week forecast is 333 and α=0.65.Include the MSE, MAD and MAPE in your calculations. Based on your results, recommend which method should be used and give reasons to support your recommendation. Week Demand (Number of calls) 1 300 2 360 3 410 4 289 5 279 6 302 7 376 8 329 9 248 10 322 11 503 12 511 13 399 14 402 15 380 16 469
Need help with the forecast for year 10. Linear trend line
b4 need urgent in 15 minutes
Please solve this
Using naïve method to make a forecast involving data with trend, the forecasted sales volume for week 4 must be ________ units if the actual sales are 500, 510, and 508 in weeks 1, 2, & 3, respectively: * o 506 o 508 o 510 o 500
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.

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

5-15 Develop a 4-month moving average forecast for Wallace Garden Supply, and compute the MAD. A 3-month moving average forecast was developed in the section on moving averages in Table 5.2 iO,