Manager T. C. Downs of Plum Engines, a producer of lawn mowers 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 135 engines per month. Regular output has a cost of $60 per engine. The beginning inventory is zero engines. Overtime has a cost of $100 per engine. a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $2 per engine per month. Backlog cost is $120 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.)

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
icon
Concept explainers
Topic Video
Question

Manager T. C. Downs of Plum Engines, a producer of lawn mowers 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 135 engines per month. Regular output has a cost of $60 per engine. The beginning inventory is zero engines. Overtime has a cost of $100 per engine.

a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.)

b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $2 per engine per month. Backlog cost is $120 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.)

Manager T. C. Downs of Plum Engines, a producer of lawn mowers 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 135 engines per month. Regular
output has a cost of $60 per engine. The beginning inventory is zero engines. Overtime has a cost of $100 per engine.
Month
2
3
6
7
8
Total
Forecast
125
135
143
120
125
125
140
135
1,048
a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regular production can be less than
regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever
required.)
Period
1
2
3
4
6
7
8
Total
Forecast
125
135
143
120
125
125
140
135
1,048
Output
Regular
Overtime
Output - Forecast
Costs
Output
Regular
Overtime
Total
Transcribed Image Text:Manager T. C. Downs of Plum Engines, a producer of lawn mowers 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 135 engines per month. Regular output has a cost of $60 per engine. The beginning inventory is zero engines. Overtime has a cost of $100 per engine. Month 2 3 6 7 8 Total Forecast 125 135 143 120 125 125 140 135 1,048 a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever required.) Period 1 2 3 4 6 7 8 Total Forecast 125 135 143 120 125 125 140 135 1,048 Output Regular Overtime Output - Forecast Costs Output Regular Overtime Total
b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $2 per engine per month.
Backlog cost is $120 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.)
Period
1
4
8.
Total
Forecast
125
135
143
120
125
125
140
135
1,048
Output
Regular
Output - Forecast
Inventory
Beginning
Ending
Average
Backlog
Costs
Output
Regular
Inventory
Backorder
Total
Transcribed Image Text:b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $2 per engine per month. Backlog cost is $120 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.) Period 1 4 8. Total Forecast 125 135 143 120 125 125 140 135 1,048 Output Regular Output - Forecast Inventory Beginning Ending Average Backlog Costs Output Regular Inventory Backorder Total
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Inventory management
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
  • 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.