4.27 Mark Cotteleer owns a company that manufactures sail- boats. Actual demand for Mark's sailboats during each season in 2004 through 2007 was as follows: Year Season 2004 2005 2006 2007 Winter 1,400 1,200 1,000 900 1,400 2,100 1.600 1,500 Spring Summer 1,500 1,000 2.000 1,900 Fall 600 750 650 500 Mark has forecasted that annual demand for his sailboats in 2009 will equal 5,600 sailboats. Based on this data and the multiplicative seasonal model, what will the demand level be for Mark's sailboats in the spring of 2009?
4.27 Mark Cotteleer owns a company that manufactures sail- boats. Actual demand for Mark's sailboats during each season in 2004 through 2007 was as follows: Year Season 2004 2005 2006 2007 Winter 1,400 1,200 1,000 900 1,400 2,100 1.600 1,500 Spring Summer 1,500 1,000 2.000 1,900 Fall 600 750 650 500 Mark has forecasted that annual demand for his sailboats in 2009 will equal 5,600 sailboats. Based on this data and the multiplicative seasonal model, what will the demand level be for Mark's sailboats in the spring of 2009?
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...
Related questions
Question
Question 4.27

Transcribed Image Text:### Sailboat Demand Analysis
**Table 1: Seasonal Demand for Sailboats (2004-2007)**
| Season | Year | 2004 | 2005 | 2006 | 2007 |
|--------|------|------|------|------|------|
| Winter | | 1,400| 1,200| 1,000| 900 |
| Spring | | 1,500| 1,400| 1,600| 1,500|
| Summer | | 1,000| 2,100| 2,000| 1,900|
| Fall | | 600 | 750 | 650 | 500 |
---
**Demand Summary:**
- **Winter**: The demand decreases steadily from 1,400 units in 2004 to 900 units in 2007.
- **Spring**: Fairly consistent demand with a slight increase in 2006.
- **Summer**: Substantial increase in 2005, followed by a slight decline by 2007.
- **Fall**: Peaks in 2005, then declines steadily.
**Forecast for 2009:**
Mark has predicted that the total annual demand for his sailboats in 2009 will be 5,600 sailboats. Using a multiplicative seasonal model, he needs to determine the demand for spring 2009.
---
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
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
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


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.