Jose Martinez of El Paso had developed a polished stainless-steel tortilla machine that makes it a “showpiece” for display in Mexican restaurants.  He needs to develop a 5-month aggregate plan.  His forecast of capacity and demand follows:   Month   1 2 3 4 5 Demand 150 160 130 200 210 Regular capacity 150 150 150 150 150 Overtime capacity 20 20 10 10 10 Subcontracting: 100 units available over the 5-month period (NOT 100 units each month) Beginning inventory: 0 units Ending inventory required at the last month (i.e. month 5): 20 units. Costs   Regular-time cost per unit $100 Overtime cost per unit $125 Subcontracting cost per unit $135 Inventory holding cost per unit per month $3 Assume that backorders are not permitted. a) Find an aggregate production plan using the intuitive lowest cost approach. (i.e. Develop an aggregate plan using the transportation method). b) State the corresponding aggregate schedule plan and its total costs? c) What is the ending inventory at month 2, month 3, and month 4?

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

Jose Martinez of El Paso had developed a polished stainless-steel tortilla machine that makes it a “showpiece” for display in Mexican restaurants.  He needs to develop a 5-month aggregate plan.  His forecast of capacity and demand follows:

 

Month

 

1

2

3

4

5

Demand

150

160

130

200

210

Regular capacity

150

150

150

150

150

Overtime capacity

20

20

10

10

10

Subcontracting: 100 units available over the 5-month period (NOT 100 units each month)

Beginning inventory: 0 units

Ending inventory required at the last month (i.e. month 5): 20 units.

Costs

 

Regular-time cost per unit

$100

Overtime cost per unit

$125

Subcontracting cost per unit

$135

Inventory holding cost per unit per month

$3

Assume that backorders are not permitted.

a) Find an aggregate production plan using the intuitive lowest cost approach. (i.e. Develop an aggregate plan using the transportation method).

b) State the corresponding aggregate schedule plan and its total costs?

c) What is the ending inventory at month 2, month 3, and month 4?

Note:-

  • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
  • Answer completely.
  • You will get up vote for sure.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

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