George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: Year Season 2 3 4 Winter 1,400 1,200 1,000 960 Spring 1,500 1,440 1,620 1,540 Summer 1,000 2,140 2,020 1,960 Fall 680 810 690 500 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 multiplicative seasonal model, the demand level for George's sailboats in the spring of year 5 will be sailboats (enter a whole number).

George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: Year Season 2 3 4 Winter 1,400 1,200 1,000 960 Spring 1,500 1,440 1,620 1,540 Summer 1,000 2,140 2,020 1,960 Fall 680 810 690 500 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 multiplicative seasonal model, the demand level for George's sailboats in the spring of year 5 will be sailboats (enter a whole number).

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 Fieldale Dairy produces cheese, which it sells to su-permarkets and food processing companies. Because of concerns about cholesterol and fat in cheese, the companyhas seen demand for its products decline during the pastdecade. It is now considering introducing some alternativelow-fat dairy products and wants to determine how much available plant capacity it will have next year. The com-pany has developed an exponential smoothing forecast with 0.40 to forecast cheese. The actual demand andthe forecasts from its model are shown as follows: Assess the accuracy of the forecast model using MAD and cu-mulative error, and determine if the forecast error reflects bias using a tracking signal and 3 MAD control limits. If the ex-ponential smoothing forecast model is biased, determine if a linear trend model would provide a more accurate forecast.
Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
1. The following data table shows attendance in the class. Week 5 No. of Students 58 6 7 60 62 59 1 50 2 3 4 55 48 Estimate the attendance in the 8th week using a. Exponential smoothing assuming alpha=0.1 and forecast for 7th week was 58.
part b)
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)
Compile a forecast for sales in Q1, Q2, Q3, and Q4 for 2013.
The following table contains sales data for the last eight periods. Forecast the sales for period 9 using a moving average forecast of 3 periods. Period Sales Period Sales 1 24 5 79 2 48 6 69 3 56 7 56 4 69 8 22 a. 61 b. 54 c. 49 d. 68
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
What is the seasonal relative for the summer? (Please keep 3 decimal places for your answer)