PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB
PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB
11th Edition
ISBN: 9780135226742
Author: HEIZER
Publisher: PEARSON
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 13, Problem 17P

a)

Summary Introduction

To determine: The optimal plan using the transportation method.

Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.

a)

Expert Solution
Check Mark

Answer to Problem 17P

The optimal plan using the transportation method has been developed.

Explanation of Solution

Given information:

The following information has been given:

Quarter Forecast (units) Regular time Overtime Subcontract
1 500 400 80 100
2 750 400 80 100
3 900 800 160 100
4 450 400 80 100

Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.

Develop optimal plan using transportation model:

Develop cost matrix:

Cost matrix Quarter 1 Quarter 2 Quarter 3 Quarter 4 Ending inventory Supply
Beginning inventory 0.2 0.4 0.6 0.8 1 250
Regular time 1 1 1.2 1.4 1.6 1.8 400
Over time 1 1.5 1.7 1.9 2.1 2.3 80
Subcontract 1 2 2.2 2.4 2.6 2.8 100
Regular time 1 1.5 1 1.2 1.4 1.6 400
Over time 1 2 1.5 1.7 1.9 2.1 80
Subcontract 1 2.5 2 2.2 2.4 2.6 100
Regular time 1 2 1.5 1 1.2 1.4 400
Over time 1 2.5 2 1.5 1.7 1.9 80
Subcontract 1 3 2.5 2 2.2 2.4 100
Regular time 1 2.5 2 1.5 1 1.2 400
Over time 1 3 2.5 2 1.5 1.7 80
Subcontract 1 3.5 3 2.5 2 2.2 100
Demand 500 750 900 450 2570
2600

Excel worksheet to generate the above table:

PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB, Chapter 13, Problem 17P , additional homework tip  1

Develop optimal plan:

Optimal plan Quarter 1 Quarter 2 Quarter 3 Quarter 4 Ending inventory Dummy
Beginning inventory 100 150
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 800
Over time 1 40 100 20
Subcontract 1 100
Regular time 1 400
Over time 1 50 30
Subcontract 1 100
Demand 500 750 900 450

The given demand and supply should be separated and the remaining supply and demand should be used as a dummy value.

b)

Summary Introduction

To determine: The total cost of the optimal plan.

Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.

b)

Expert Solution
Check Mark

Answer to Problem 17P

The optimal cost of the plan is $2,641.

Explanation of Solution

Given information:

The following information has been given:

Quarter Forecast (units) Regular time Overtime Subcontract
1 500 400 80 100
2 750 400 80 100
3 900 800 160 100
4 450 400 80 100

Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.

Develop optimal plan using transportation model:

Develop cost matrix:

Cost matrix Quarter 1 Quarter 2 Quarter 3 Quarter 4 Ending inventory Supply
Beginning inventory 0.2 0.4 0.6 0.8 1 250
Regular time 1 1 1.2 1.4 1.6 1.8 400
Over time 1 1.5 1.7 1.9 2.1 2.3 80
Subcontract 1 2 2.2 2.4 2.6 2.8 100
Regular time 1 1.5 1 1.2 1.4 1.6 400
Over time 1 2 1.5 1.7 1.9 2.1 80
Subcontract 1 2.5 2 2.2 2.4 2.6 100
Regular time 1 2 1.5 1 1.2 1.4 400
Over time 1 2.5 2 1.5 1.7 1.9 80
Subcontract 1 3 2.5 2 2.2 2.4 100
Regular time 1 2.5 2 1.5 1 1.2 400
Over time 1 3 2.5 2 1.5 1.7 80
Subcontract 1 3.5 3 2.5 2 2.2 100
Demand 500 750 900 450 2570
2600

Excel worksheet to generate the above table:

PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB, Chapter 13, Problem 17P , additional homework tip  2

Develop optimal plan:

Optimal plan Quarter 1 Quarter 2 Quarter 3 Quarter 4 Ending inventory Dummy
Beginning inventory 100 150
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 800
Over time 1 40 100 20
Subcontract 1 100
Regular time 1 400
Over time 1 50 30
Subcontract 1 100
Demand 500 750 900 450

The given demand and supply should be splitted and the remaining supply and demand should be used as a dummy value.

Calculate the total optimal cost:

It is calculated by adding the multiple of values in the optimal plan table and the value in the cost matrix to the respective value.

Total optimal cost=[(100×0.2)+(400×1)+(150×0.4)+(80×1.7)+(400×1)+(80×1.5)+(40×2)+(800×1)+(100×1.5)+(400×1)+(50×1.5)]=20+400+60+136+400+120+80+800+150+400+75=$2,641

Hence, the total optimal cost is $2,641.

c)

Summary Introduction

To determine: The number of units remained unused in regular time capacity.

Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.

c)

Expert Solution
Check Mark

Answer to Problem 17P

No, the regular time capacity remains unused.

Explanation of Solution

Given information:

The following information has been given:

Quarter Forecast (units) Regular time Overtime Subcontract
1 500 400 80 100
2 750 400 80 100
3 900 800 160 100
4 450 400 80 100

Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.

Develop optimal plan:

Optimal plan Quarter 1 Quarter 2 Quarter 3 Quarter 4 Ending inventory Dummy
Beginning inventory 100 150
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 800
Over time 1 40 100 20
Subcontract 1 100
Regular time 1 400
Over time 1 50 30
Subcontract 1 100
Demand 500 750 900 450

The given demand and supply should be separated and the remaining supply and demand should be used as a dummy value.

Determine whether the regular time capacity remain unused:

From the above table, it is clear that no regular time capacity remains unused. All the regular time capacity has been used in respective quarters.

d)

Summary Introduction

To determine: The extent of backordering in units and dollars.

Introduction: Aggregate planning using transportation method helps to attain minimum cost using the optimal plan. The major advantage of transportation method is to achieve the optimal solution using optimal plans.

d)

Expert Solution
Check Mark

Answer to Problem 17P

The total unit of the backordered is 40 units and the total cost of producing the backorders are $20.

Explanation of Solution

Given information:

The following information has been given:

Quarter Forecast (units) Regular time Overtime Subcontract
1 500 400 80 100
2 750 400 80 100
3 900 800 160 100
4 450 400 80 100

Initial inventory is given as 250 units, regular time cost is $1 per unit, overtime cost is $1.50 per unit, and subcontract cost is $2 per unit. Carrying cost is given as $0.5 per unit per quarter and backorder cost is $0.5 per unit per quarter. Initial inventory would incur $0.2 per unit.

Develop optimal plan:

Optimal plan Quarter 1 Quarter 2 Quarter 3 Quarter 4 Ending inventory Dummy
Beginning inventory 100 150
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 400
Over time 1 80
Subcontract 1 100
Regular time 1 800
Over time 1 40 100 20
Subcontract 1 100
Regular time 1 400
Over time 1 50 30
Subcontract 1 100
Demand 500 750 900 450

The given demand and supply should be separated and the remaining supply and demand should be used as a dummy value.

Determine the extent backordering in units and dollars:

The colored cell is the only cell in the optimal plan, which is used for backordering. Hence, the backordering in units is 40 units. It is given that backorder cost is $0.50 per unit per quarter.

Extent of backorder in dollars=Number of backorder units×Backorder cost per unit=40 units×$0.50=$20

Hence, the total unit backordered is 40 units and the total costs of producing the backorders are $20.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Negotiators can gain several benefits from using the strategy of multiple equivalent simultaneous offers. By offering multiple options it reduces the chance of rejection. It also improves the chances of reaching reaching an agreement. By presenting multiple offers, it shows you are flexible.  agree with the post
Negotiators can gain several benefits from using the strategy of multiple equivalent simultaneous offers. By offering multiple options it reduces the chance of rejection. It also improves the chances of reaching reaching an agreement. By presenting multiple offers, it shows you are flexible.  disagree with this post or add on to the post
The strategy of Multiple Equivalent Simultaneous Offers involves presenting several equally valuable options to the other party during negotiations. This approach benefits negotiators by creating flexibility and increasing the chances of finding a mutually agreeable solution. By offering multiple options, negotiators show that they are open to compromise, which can build trust and make the negotiation process smoother. It also helps avoid getting stuck on one issue, as the other party can choose from several alternatives that meet their needs. In my experience, using MESOs in a work negotiation helped both parties reach an agreement more quickly because each option was carefully thought out to address different needs, and this made it easier for us to settle on one that worked for both sides. This strategy can also reveal what is most important to the other party, helping negotiators understand their priorities better. agree or disagree with the post
Knowledge Booster
Background pattern image
Operations 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
  • Text book image
    MARKETING 2018
    Marketing
    ISBN:9780357033753
    Author:Pride
    Publisher:CENGAGE L
    Text book image
    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
    Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
  • Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
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
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY