EBK PRINCIPLES OF OPERATIONS MANAGEMENT
EBK PRINCIPLES OF OPERATIONS MANAGEMENT
11th Edition
ISBN: 9780135175859
Author: Munson
Publisher: VST
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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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
RECEIVING AND STORAGE ASSIGNMENTS- Dietary Mangement (Nursing Home) ASSIGNMENT: Diagram the receiving and storage areas. Use arrows to show the flow of goods as they are received and moved to storage. ASSIGNMENT:  In order to accurately understand this area, the intern should work in the receiving area to complete the following assignments and answer the following questions: Inspect the delivery and check it against the purchase Inspect the delivery against the invoice Accept order only if all quantities and quality specifications are met Check perishable items first Check temperatures of refrigerated and frozen items on arrival Look for evidence of thawing or freezer burn Randomly open cases to check contents Complete receiving records Transfer goods to appropriate storage Who checks the packing slip against the invoice? Does the facility ever use “blind” receiving where the receiving clerk checks the order against an invoice where the amounts have been blanked out and the clerk…
Purchasing, Receiving, Storage, and Inventory Instructions- Dietary management in a nursing home in ABQ NM What workers are involved in the purchasing, receiving, storage and inventory process. Complete the table below: Position Description of their job duties Date/ What did they do?                               Answer the questions below:  PURCHASING: 1. Is there a centralized purchasing department for the facility? If yes, observe someone in that department for a half day if possible, if no write N/A 2. What kinds of items are required to go out for formal bid? 3. What about capital purchases? What is the dollar amount at which an item must go on the capital rather than the operating budget? 4. Does the facility participate with a group to cooperatively purchase items? 5. Is there a Prime Vendor? If yes, how often is the contract renegotiated? 6. Is informal or open-market buying used for any items? Which ones? 7. Who orders…
Critical Incident Report- Dietary Mangement Critical incidences involve critical thinking and problem solving techniques. This exercise is the opportunity to analyze and decide on the appropriateness of the action and to determine better ways to solve problems, approach employees and get the job done. This exercise should help in doing it better the next time. As you observe or become more involved in the situations that require problem solving or critical thinking use this exercise to identify the what, who, and when and determine how the actions taken or not taken affected the outcome. You must write up two or more experiences. The summary is to include two parts: 1. Objective data of what occurred and how it occurred: 2. Analysis of what happened and what we could or would have done to make the outcome better.
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