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...
icon
Related questions
Question

Q30

The following data show the quarterly sales of a major auto manufacturer for the years 1 through 3. Use multiplicative
method to answer the following questions.
Year
Quarter
Sales
160
2
180
3
190
4
170
1
200
2
210
3
260
4
230
3
1
210
2
240
290
260
3
4
26. The equation for the trend line of yearly sales is F, = 567 + 150t. What is the prediction for the sales in year 4?
<1000
b.
Between 1000 and 1100
a.
Between 1100 and 1200
d. >1200
с.
27. What is the seasonal index for quarter 4 in year 1?
a.
<0.8
b.
Between 0.8 and 0.9
с.
Between 0.9 and 1.0
d. >1.0
28. What is the average seasonal index for quarter 1?
<0.8
b. Between 0.8 and 0.9
Between 0.9 and 1.0
a.
с.
d. >1.0
29. What is the sales forecast for quarter 1 in Year 4?
a.
<230
b. Between 230 and 240
с.
Between 240 and 250
d. >250
30. What is the sales forecast for quarter 3 in Year 4?
a.
<300
b.
Between 300 and 320
Between 320 and 340
d. >340
с.
2.
Transcribed Image Text:The following data show the quarterly sales of a major auto manufacturer for the years 1 through 3. Use multiplicative method to answer the following questions. Year Quarter Sales 160 2 180 3 190 4 170 1 200 2 210 3 260 4 230 3 1 210 2 240 290 260 3 4 26. The equation for the trend line of yearly sales is F, = 567 + 150t. What is the prediction for the sales in year 4? <1000 b. Between 1000 and 1100 a. Between 1100 and 1200 d. >1200 с. 27. What is the seasonal index for quarter 4 in year 1? a. <0.8 b. Between 0.8 and 0.9 с. Between 0.9 and 1.0 d. >1.0 28. What is the average seasonal index for quarter 1? <0.8 b. Between 0.8 and 0.9 Between 0.9 and 1.0 a. с. d. >1.0 29. What is the sales forecast for quarter 1 in Year 4? a. <230 b. Between 230 and 240 с. Between 240 and 250 d. >250 30. What is the sales forecast for quarter 3 in Year 4? a. <300 b. Between 300 and 320 Between 320 and 340 d. >340 с. 2.
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.