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
Yu Amy Xia bas developed a specialized airtightvacuum bag to extend the freshness of seafood shipped to restaurants.She has put together the following demand cost data:                                                                            You decides that the initial inventory of 250 units will incur the$0.20/unit cost from each prior quarter (unlike the situation inmost other companies, where a 0 unit cost is assigned).a) Find the optimal pla n using the transportation method.b) What is the cost of the plan?c) Does any regula r time capacity go unused? If so, how much in which periods?b) What is the extent of backordering in units and dollars?
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?
Jose Martinez of El Paso has developed a polishedstainless steel tortilla machine that makes it a "showpiece" fordisplay in Mexican restaurants. He needs to develop a 5-monthaggregate plan. His forecast of capacity and demand follows:                                                                    Assume that backorders a re not permitted. Using the transportationmethod, what is the total cost of the optimal plan?
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
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
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
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY