Manager T. C. Downs of Plum Engines, a producer of lawnmowers and leaf blowers, must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a regular output capacity of 105 engines per month. Regular output has a cost of S65 per engine. The beginning inventory is zero engines. Overtime has a cost of $120 per engine. Month Total Forecast 95 100 115 400 Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $3 per engine per month. Backlog cost is $100 per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand Assume that using overtime is not an option. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round average inventory row, Inventory cost row, and Total row values to 1 decimal. Do not write the Dollar sign ($)

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
QUESTION 1
Manager T. C. Downs of Plum Engines, a producer of lawnmowers and leaf blowers, must develop an aggregate plan given the forecast for engine
demand shown in the table. The department has a regular output capacity of 105 engines per month. Regular output has a cost of $65 per engine. The
beginning inventory is zero engines. Overtime has a cost of $120 per engine.
Month
Total
Forecast
95
100
115
400
Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $3 per engine per month. Backlog cost is $100
per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand
Assume that using overtime is not an option.
(Negative amounts should be indicated by a minus sign. Leave no celis blank - be certain to enter "0" wherever required. Round average
inventory row, Inventory cost row, and Total row values to 1 decimal. Do not write the Dollar sign (S))
Transcribed Image Text:QUESTION 1 Manager T. C. Downs of Plum Engines, a producer of lawnmowers and leaf blowers, must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a regular output capacity of 105 engines per month. Regular output has a cost of $65 per engine. The beginning inventory is zero engines. Overtime has a cost of $120 per engine. Month Total Forecast 95 100 115 400 Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $3 per engine per month. Backlog cost is $100 per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand Assume that using overtime is not an option. (Negative amounts should be indicated by a minus sign. Leave no celis blank - be certain to enter "0" wherever required. Round average inventory row, Inventory cost row, and Total row values to 1 decimal. Do not write the Dollar sign (S))
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 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.