George Kypansis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as followsYearPSeasonWinterSpringSummerFall11.4001,5201,00064021,2001,4202,10077031,0001,6202,02065049001,5801,960560George has forecasted that annual demand for his sailboats in year 5 will equal 6.500 sailboatsBased 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 aintermediate calculations to two decimal places)

Seasonal index uses for analysis the how particular season through cycle compare with average…

Answered: George Kypass 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

part b
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a 3-year moving average to forecast demand?
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
Show your complete solution
Using exponential smoothing with alpha = .2, and assuming the forecast for period 11 was 80, what would the forecast for period 14 be?
The following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 700 3 810 4 800 5 900 6. 700 7 i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month Wt. Moving Average (weights: 0.2, 0.3, 0.5) for months 4, 5, 6 & 7? iii. Calculate an exponential smoothing forecast for the given data with an alpha of 0.1 for months 2, 3, 4, 5, 6 & 7. Assume a forecast of 650 for month 1. Show the formula and working method.
The manager of XYZ carpet cleaning company needs a weekly forecast of the number of customers expected next year. The carpet cleaning business is seasonal with the following weekly demand data from the past 2 years Week 1 in Year 1 Demand=102 Week 1 in Year 2 Demand=114 Year 1 Demand=10608 Year 2 Demand=10708 Q8a) Calculate the seasonal factor for Week 1 Q8b) Calculate the demand in the first week in the third year ( knowing that Year 3 Forecasted Demand is11779)
A bakery called Sweet Treats operates in a busy downtown area. It is trying to decide whether to add another oven to its kitchen next year. The number of cakes baked over the last four quarters are as follows: Q1 = 950, Q2 = 1,100, Q3 = 1,050, and Q4 = 1,200 cakes. The forecast for cakes baked in the second quarter was 1,000 cakes. a) What is the forecast for the fifth quarter using exponential smoothing with a = 0.15? b) Given only what you learned in a, should the bakery add another oven?
Matrix uses simple exponential smoothing with S.F = 0.6 to forecast demand. The forecast for the week of Nov 1 was 350 units, whereas the actual demand turned out to be 400 units. Forecast the demand for the week of Nov 8 to week Nov 22 Week Actual Demand Forecast Nov 01 350 400 Nov 08 460 430 Nov 15 501 448 Nov 22 495 479.8 Element of Competency Determine the quantity of raw materials and other products order.
Compile a forecast for sales in Q1, Q2, Q3, and Q4 for 2013.
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year 1 2 3 4 5 Sales 460 502 520 575 575 a) Forecasted sales for year 6 using the trend projection (linear regression) method are sales (round your response to one decimal place).
Assume today's date is 12/31/2023. Actual sales and forecast for 2023 are given below. Actual Forecast 2023 72.4 66.9 59.5 61.2 260 2023 69 67 Q3 61 Q4 59 Total 256 Obtain the MAD Q1 Q2 7.2 1.8 -1

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