George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows:SeasonYear1234Winter1,4001,2801,080960Spring1,5601,4001,6401,500SummerFall1,0202,1002,0402,000600770690560George has forecasted that annual demand for his sailboats in year 5 will equal 6,500 sailboats.Based on the given data and using the seasonal model, the demand level for George's sailboats in the spring of year 5 will be 1810 sailboats (enter your final answer as a whole number andround all intermediate calculations to two decimal places).

Approach to solving the question: Detailed explanation: The demand level for George's sailboats in…

Answered: George Kyparisis owns a company that…

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

Dave's Bar-B-Q operated a moble kitchen that serviced construction sitos, office buildings, and public parks. Beginning in June, snow cones were added to the menu. The weekly sales figures for June of the previous year are given in the following chart Forecast (alpha=0.3) 5.0 Week Sales 4. 4.7 3 4 Use exponential smoothing, a smoothing coefficient of 0.3, to forecast demand for the third week of June. O A. 4.7 O B. 6.4 OC. 5.1 OD. 4.0
The following table shows the actual demand observed over the last 11 years: Year Demand 1 7 Year Forecast 2 8 2 3 4 3 4 10 4 Using exponential smoothing with a = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). 3 2 4 5 6 T 8 9 Year 1 Forecast 6.0 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers) 5 12 5 6 7 6 7 8 11 14 7 8 9 10 9 10 10 10 13 11 11 11 8 12 12
George Kypansis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows Year P Season Winter Spring Summer Fall 1 1.400 1,520 1,000 640 2 1,200 1,420 2,100 770 3 1,000 1,620 2,020 650 4 900 1,580 1,960 560 George has forecasted that annual demand for his sailboats in year 5 will equal 6.500 sailboats Based on the given data and using the seasonal model, the demand level for George's salboats in the spring of year 5 will be sailboats (enter your final answer as a whole number and round a intermediate calculations to two decimal places)
Problem 18-3 (Algo) Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. Last year This year JAN 150 170 FEB MAR 170 190 190 APR MAY 235 225 175 245 270 Forecast for the third quarter JUN 250 215 SEP 175 AUG JUL 195 185 OCT 250 ▸ NOV DEC 275 295
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?
68 is incorrect
George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: Season Winter Spring Summer Fall 1 1,440 1,560 1,040 640 2 1,280 1,440 2,120 750 Year 3 1,080 1,620 2,020 650 4 920 1,500 1,960 560 George has forecasted that annual demand for his sailboats in year 5 will equal 6,000 sailboats. Based on the given data and using the seasonal model, the demand level for George's sailboats in the spring of year 5 will be sailboats (enter your final answer as a whole number and round all intermediate calculations to two decimal places). ib the ng a rom E
part b
10. Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 4 months were as follows: Month Price Per Chip January $1.85 February $1.61 March $1.63 April $1.83 This exercise contains only parts a, b, and c. Part 2 a) Using a 2-month moving average, calculate the forecast for March and April (round your responses to two decimal places). Month Mar Apr Forecast $________ $________
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
The dean of a school of business is forecasting total student enrollment for this year's summer session classes based on the following historical data: Year Enrollment Four years ago 2000 Three years ago 2200 Two years ago 2800 Last year 3000 What is this year's forecast using a three-year simple moving average? a. 2,600 b. 2,400 c. 2,667 d. 2,500 e. 2,333

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