A store has the following demand figures for the last five years:Year Demand1100021500312004160051400What is the exponential smoothing forecast for year 3? Use alpha = 0.2 and a forecast for year 1 of 1200. (round to nearestinteger)

Formulae used: For Exponential Smoothing Forecast: Ft =α At-1 + (1-α)Ft-1WhereFt-1= forecast for…

Answered: A store has the following demand…

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

Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200
The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: YEAR CASES OF MERLOT WINE 1 270 2 356 3 398 4 456 5 358 6 500 7 410 8 376 Using an exponential smoothing model with an alpha value of 0.20, estimate the smoothed value calculated as of the end of year 8. Use the average demand for years 1 through 3 as your initial forecast for year 4, and then smooth the forecast forward to year 8. Note: Round your intermediate calculations and final answer to the nearest whole number.
Help Saved Mary, Susan, and Sarah are running a beach boutique on the board walk of Ocean City. Their favorite product is a red lifeguard hoody. Mary believes it will sell 318 times next season. Susan forecasts sales of 518, and Sarah forecasts 199. What would be the result of a simple forecast combination? (Round to two decimal places)
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
Below is a table containing data on product demand for the most recent three months along with the forecasts that had been made for those three previous months. Calculate the MAE (or MAD). Month Demand Forecast 1 308 310 2 388 390 3 344 342
Assume Sandra's forecasted ADR for the night is $1600.99. What would be her estimated total room revenue for this day? ADR = Total room revenue / Number of rooms sold
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Year Forecast (000) 1 2 4.00 7.00 1 5.00 3 5.00 Registrations (000) a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (a) of 0.40 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place): 2 3 4.6 5.56 4 4.00 4 5.34 11 9 10 7 8 6 5 9.00 9.00 6.00 10.00 13.00 14.00 12.00 5 4.80 6 7 6.48 7.49 8 6.89 9 8.14 10 10.08 11 11.64 12 11.79 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (a) = 0.40 and a starting forecast of F₁ = 5.00) is response to one decimal place). registrations (round your
Professor Very Busy needs to allocate time next week to include time for office hours. He needs to forecast the number of students who will seek appointments. He has gathered the following data: Week 6 weeks ago 5 weeks ago 4 weeks ago 3 weeks ago 2 weeks ago Last week # Students 83 110 95 80 65 50 What is this week's forecast using trend-adjusted (double) smoothing with alpha = .5 and beta = .1, if the forecast for last week was 65, the forecast for two weeks ago was 75, and the trend estimate for last week's forecast was -5? 49.3 78.7 51.3 50.6 65.4
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
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)
Use simple exponential smoothing with a=0.6 to forecast chargers sales for February through May. Assume that the forecast for January was 24 chargers. *** Month January Charger Sales 42 February 33 March 28 April 59 May ? a) What will be the forecast for May? b) Calculate the MSE.

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

A store has the following demand figures for the last five years: Year Demand 1 1000 2 1500 3 1200 4 1600 1400 5 What is the exponential smoothing forecast for year 3? Use alpha = 0.2 and a forecast for year 1 of 1200. (round to nearest integer)