12.2. The manager of the I-85 Carpet Outlet needs to be able toforecast accurately the demand for Soft Shag carpet (its biggestseller). If the manager does not order enough carpet from the carpetmill, customers will buy their carpets from one of the outlet's manycompetitors. The manager has collected the following demand datafor the past eight months:Demand for Soft ShagCarpet (1000 yd)MonthALEni bno1106.4.8146.1079.8.12a. Compute a three-month moving average forecast for months 4through 9.b. Compute a weighted three-month moving average forecast formonths 4 through 9. Assign weights of .55, .33, and .12 to themonths in sequence, starting with the most recent month.c. Compare the two forecasts using MAD. Which forecastappears to be more accurate?3.

Answered: 12.2. The manager of the I-85 Carpet…

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

8.6 Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing constant is 0.2, and the old forecast for month 1 is 245. Month 1 2 3 4 5 6 LO Actual Demand 260 230 225 245 250 Forecast Demand
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: 1 3,000 2 3,950 3 3,400 Year Mileage a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the nearest whole number). 4 3,750 5 3,750
The K&R Camera shop sells all the latest cameras and accessories. To meet customer demand, the manager must forecast demand for items she sells. Lately the XR-42S zoom lens has been very popular. Recent monthly demand for this item has been as shown: Number of Lenses Month Sold 1 12 17 2 3 4 15 20 18 23 6.
The demand data for Double T Computer Services appears below. The company wants you to forecast the demand for period 4. What is your forecast using the least squares method? Period Demand 1 37 2 40 3 40
12.7 The Intrepid mutual fund of growth stocks has had the following average monthly price for the past 10 months. Month 1 2 3 4 5 6 7 8 9 10 Fund Price 62.7 63.9 68.0 66.4 67.2 65.8 68.2 69.3 67.2 70.1 Compute the exponentially smoothed forecast with a = 0.40, the adjusted exponentially smoothed forecast with a = 0.40 and ß = 0.30, and the linear trend line forecast. Compare the accuracy of the three forecasts using cumulative error and MAD, and indicate which forecast appears to be most accurate.
Given: Year Demand 1 7 2 9 3 5 4 9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows Year Mileage 1 3,100 2 4,000 3 3,450 4 3,850 5 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = 108.3 miles (round your response to one decimal place). (Hint. You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = miles (round your response to the nearest whole number)
Using exponential smoothing with alpha = .2, and assuming the forecast for period 11 was 80, what would the forecast for period 14 be?
Use the following data to determine the tracking signal for period 4. Actual Forecast 10 16 23 16 50 49 63 59 108 106 122 118 a. 1.333 b. 1.108 c. 0.742 d. 0.429
QWE Inn has recorded the following number of rooms sold for the first quarter of the year: January 2100 February 2500 March 2550 What is the 3-month moving average forecast of rooms sold equal to for the month April?
A ski resort has recorded its recent sales as follows (in $$). Season 2 years ago Last year This year Spring 700 950 900 Summer 450 500 400 Fall 1,150 1,100 1,350 Winter 1,400 1,500 1,600 The resort estimated that the annual demand for the next year will be 4,800. What would be the forecast for next Fall? Answer: _______
b5 need urgent in 15 minutes

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