George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past fourseasons was as follows:YearSeason2341,4001,5001,0001,0001,600Winter1,200960Spring1,4401,500Summer2,1202,0402,000Fall680810650520George 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 5will be 1775 sailboats (enter a whole number).

Find the given details below: Given details: Year Season 1 2 3 4 Winter 1400 1200 1000…

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

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 $________ $________
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
Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α = 0.5) and 3-year moving average to forecast it. Please fill the blanks above and write your processes below. What are the mean absolute deviations (MADs) of the two methods? Which method will you choose based on the results?
part b)
Income at the law firm of Smith and Jones for the period February to July was as follows: Month February March April May June July Income (in $ thousand) 90.0 91.5 96.0 85.4 92.2 96.0 Assume that the initial forecast for February is $85,000 and the initial trend adjustment is 0. The smoothing constants selected are a = 0.1 and ß = 0.2. Using trend-adjusted exponential smoothing, the forecast for the law firm's August income =O thousand dollars (round your response to two decimal places).
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?
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