In the​ past, Peter​ Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2​ years, 220 and 250​, respectively were sold in​ fall, 360 and 300 in​ winter, 150 and 160 in​ spring, and 320 and 440 in summer. With a major expansion​ planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next​ year's projected​ sales, the demand for each season is going to be ​(enter your responses as whole​ numbers):   Season Demand Fall __________

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

4. 

In the​ past, Peter​ Kelle's tire dealership in Baton Rouge sold an average of
1,100
radials each year. In the past 2​ years,
220
and
250​,
respectively were sold in​ fall,
360
and
300
in​ winter,
150
and
160
in​ spring, and
320
and
440
in summer. With a major expansion​ planned, Kelle projects sales next year to increase to
1,300
radials.
Part 2
Based on next​ year's projected​ sales, the demand for each season is going to be ​(enter your responses as whole​ numbers):
 
Season
Demand
Fall
__________
Expert Solution
Step 1

Average = 1100

Projected sales = 1300

Future Sale(F)= 1300/1100 = 1.18

 

  Average demand(D) F Demandforeachseason
Fall (220+250)/2 = 235 1.18 235*1.18 = 277.72
Winter (360+300)/2 =330 1.18 330*1.18 = 389.4
Spring (150+160)/2 = 155 1.18 155*1.18 = 182.9
Summer (320+440)/2 = 380 1.18 380*1.18 = 448.4
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar 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.