Operations Management (Comp. Instructor's Edition)
Operations Management (Comp. Instructor's Edition)
13th Edition
ISBN: 9781259948237
Author: Stevenson
Publisher: MCG
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 11, Problem 4P

a. Given the following forecast and steady regular output of 550 every month, what total cost would result if overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month? Unit costs are:

Regular output = $20

Overtime = $30

Subcontract = $25

Average Inventory = $10

Backlog = $18

Chapter 11, Problem 4P, a. Given the following forecast and steady regular output of 550 every month, what total cost would

b. Suppose now that backlogs are not allowed. Modify your plan from part a to accommodate that new condition as economically as possible. The limits on overtime and subcontracting remain the same.

a)

Expert Solution
Check Mark
Summary Introduction

To compute: The total cost of the aggregate plan with backlog

Introduction:The aggregate plan is the output of sales and operations planning. The major concern of aggregate planning is the production time and quantity for the intermediate future. Aggregate planning would encompass a time prospect of approximately 3 to 18 months.

Answer to Problem 4P

The total cost for the aggregate plan is $70,800 (without considering overtime and subcontract).

Explanation of Solution

Given information:

Regular output is $20, overtime is $30, subcontract is $25, carrying cost is $10, backorder cost is $18, regular production is 550 units per month, maximum overtime unit is of 40 units, and maximum subcontract unit is 10 units.

In addition to this, the following information is given:

Month 1 2 3 4 5 6
Forecast 540 540 570 590 600 580

Determine the aggregate plan to compute total cost (without overtime and subcontracting units):

Month 1 2 3 4 5 6 Total
Forecast 540 540 570 590 600 580 3,420
Output
Regular 550 550 550 550 550 550 3,300
Part-time
Overtime
Subcontract
Difference 10 10 -20 -40 -50 -30 -120
Inventory
Beginning 0 10 20 0 0 0 0
Ending 10 20 0 0 0 0 0
Average 5 15 10 0 0 0 0
Backlog 0 0 0 40 90 120 250
Costs
Regular 20 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $66,000
Part-time
Overtime 30 $0 $0 $0 $0 $0 $0 $0
Subcontract 25 $0 $0 $0 $0 $0 $0 $0
Hire/Layoff
Inventory 10 $50 $150 $100 $0 $0 $0 $300
Backorders 18 0 0 0 720 1620 2160 $4,518
$11,050 $11,150 $11,100 $11,720 $12,620 $13,160 $70,800

Supporting calculation:

Forecast and regular time units were given.

Calculate the difference for the month of 1:

It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 10units.

Difference=OutputForecast=(Regular+Overtime+Subcontract)Forecast=(550+0+0)540=10

Calculate the difference for the month of 2:

It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 10 units.

Difference=OutputForecast=(Regular+Overtime+Subcontract)Forecast=(550+0+0)540=10

Calculate the difference for the month of 3:

It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is -20 units.

Difference=OutputForecast=(Regular+Overtime+Subcontract)Forecast=(550+0+0)570=20

Note: The calculation repeats for all the months.

Backlogs:

As the values of difference between output and forecast are negative, there would be backlogs.

Backlogs for first three months:

It is number of units required in the month. As the differences are non-negative values, the backlog would begin from 4th month. Hence, the backlog for 1st, 2nd, and 3rd month would be0 units.

Backlogs for the month of 4:

It is number of units required in the month. It is calculated by adding the backlog of previous month and the difference between output and forecast of current month. Hence, the backlog is 40 units.

Backlogs=Backlog of previous month+Difference between output and forecast=0+40=40

Backlogs for the month of 5:

It is number of units required in the month. It is calculated by adding the backlog of previous month and the difference between output and forecast of current month (without considering the negative sign). Hence, the backlog is 90 units.

Backlogs=Backlog of previous month+Difference between output and forecast=40+50=90

Note: The calculation repeats for all the months.

Beginning inventory:

The initial inventory is given as 0. For the remaining months, ending inventory of previous month would be the beginning inventory of present month.

Ending inventory for 1st month:

Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 10 units.

Ending inventory=Beginning inventory of January+Difference between output and forecast=0+10=10

Ending inventory for 2nd month:

Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 20 units.

Ending inventory=Beginning inventory of February+Difference between output and forecast=10+10=20

Ending inventory for 3rd month:

Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 0 units.

Ending inventory=Beginning inventory of March+Difference between output and forecast=2020=0

Note: The calculation repeats for all the months.

Average inventory for 1st month:

It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 10 units.

Average inventory=Beginning inventory+Ending inventory2=0+102=5

Average inventory for 2nd month:

It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 15 units.

Average inventory=Beginning inventory+Ending inventory2=10+202=15

Average inventory for 3rd month:

It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 10 units.

Average inventory=Beginning inventory+Ending inventory2=20+02=10

Note: The calculation repeats for all the months.

Calculate the regular time cost for the 1st month:

Regular time cost per unit is given as $20 and regular time unit is given as 550. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $11,000.

Regular time cost=Regular time cost per unit×Regular time units=$20×550=$11,000

Calculate the regular time cost for the 2nd month:

Regular time cost per unit is given as $20 and regular time unit is given as 550. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $11,000.

Regular time cost=Regular time cost per unit×Regular time units=$20×550=$11,000

Calculate the regular time cost for the 3rdmonth:

Regular time cost per unit is given as $20 and regular time unit is given as 550. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $11,000.

Regular time cost=Regular time cost per unit×Regular time units=$20×550=$11,000

Note: The calculation repeats for all the months.

Calculate the total regular time cost:

It is calculated by adding the regular time cost of all the months.

Total regular time cost=Regular time of all the months=$11,000+$11,000+$11,000+$11,000+$11,000+$11,000=$66,000

Hence, the total regular time cost is $66,000.

Calculate the overtime cost for the 1st month:

Overtime cost per unit is given as $30 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.

Overtime cost=Overtime cost per unit×Overtime units=$30×0=$0

Calculate the overtime cost for the 2nd month:

Overtime cost per unit is given as $30 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.

Overtime cost=Overtime cost per unit×Overtime units=$30×0=$0

Calculate the overtime cost for the 3rd month:

Overtime cost per unit is given as $30 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.

Overtime cost=Overtime cost per unit×Overtime units=$30×0=$0

Note: The calculation repeats for all the months.

Calculate the total overtime cost:

It is calculated by adding the overtime cost of all the months.

Total overtime cost=Overtime of all the months=$0+$0+$0+$0+$0+$0=$0

Hence, the total overtime cost is $0.

Calculate the subcontract cost for 1st month:

Subcontract cost per unit is given as $25 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.

Subcontract cost=Subcontract cost per unit×Subcontract units=$25×0=$0

Calculate the subcontract cost for 2nd month:

Subcontract cost per unit is given as $25 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.

Subcontract cost=Subcontract cost per unit×Subcontract units=$25×0=$0

Calculate the subcontract cost for 3rd month:

Subcontract cost per unit is given as $25 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.

Subcontract cost=Subcontract cost per unit×Subcontract units=$25×0=$0

Note: The calculation repeats for all the months.

Calculate the total subcontract cost:

It is calculated by adding the subcontract cost of all the months.

Total subcontract cost=Subcontract of all the months=$0+$0+$0+$0+$0+$0=$0

Hence, the total subcontract cost is $0.

Calculate the inventory cost for 1st month:

It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $50.

Inventory cost=Inventory cost per unit×Average inventory=$10×5=$50

Calculate the inventory cost for 2nd month:

It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $150.

Inventory cost=Inventory cost per unit×Average inventory=$10×15=$150

Calculate the inventory cost for 3rd month:

It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $100.

Inventory cost=Inventory cost per unit×Average inventory=$10×10=$100

Calculate the total inventory cost:

It is calculated by adding the inventory cost of all the months.

Total inventory cost=Inventory cost of all the months=$50+$150+$100+$0+$0+$0=$300

Hence, the total inventory cost is $300.

Calculate the backorder cost for first three months:

As there are no backlogs for first three months, there would not be backorder cost.

Calculate the backorder cost for 4th month:

It is calculated by multiplying the backorder cost and the backlog. Hence, the backorder cost is $720.

Backorder cost=Backorder cost per unit×Backlogs=$18×40=$720

Calculate the backorder cost for 5th month:

It is calculated by multiplying the backorder cost and the backlog. Hence, the backorder cost is $1,620.

Backorder cost=Backorder cost per unit×Backlogs=$18×90=$1,620

Note: The calculation repeats for all the months.

Calculate the total backorder cost:

It is calculated by adding the backorder cost of all the months.

Total backorder cost=Backorder cost of all the months=$0+$0+$0+$720+$1,620+$2,160=$4,500

Hence, the total backorder cost is $4,500.

Calculate the total cost of the plan:

It is calculated by adding the total regular time cost, overtime cost, subcontract cost, and inventory cost.

Total cost of the plan=(Total regular time cost+Total overtime cost+Total subcontract cost+Total inventory cost+Total backorder cost)=$66,000+$0+$0+$300+$4,500=$70,800

Hence, the total cost of the plan is $70,800.

b)

Expert Solution
Check Mark
Summary Introduction

To compute: The total cost of the aggregate plan if the backlog is not allowed

Introduction:The aggregate plan is the output of sales and operations planning. The major concern of aggregate planning is the production time and quantity for the intermediate future. Aggregate planning would encompass a time prospect of approximately 3 to 18 months.

Answer to Problem 4P

The total cost for the aggregate plan is $69,750 (considering overtime and subcontract).

Explanation of Solution

Given information:

Regular output is $20, overtime is $30, subcontract is $25, carrying cost is $10, backorder cost is $18, regular production is 550 units per month, maximum overtime unit is of 40 units, and maximum subcontract unit is 10 units.

In addition to this, the following information is given:

Month 1 2 3 4 5 6
Forecast 540 540 570 590 600 580

Determine the total cost of the plan (considering overtime and subcontract):

Month 1 2 3 4 5 6 Total
Forecast 540 540 570 590 600 580 3,420
Output
Regular 550 550 550 550 550 550 3,300
Part-time
Overtime 30 40 20 90
Subcontract 10 10 10 30
Difference 10 10 -20 0 0 0 0
Inventory
Beginning 0 10 20 0 0 0 30
Ending 10 20 0 0 0 0 30
Average 5 15 10 0 0 0 30
Backlog 0 0 0 0 0 0 0
Costs
Regular 20 $11,000 $11,000 $11,000 $11,000 $11,000 $11,000 $66,000
Part-time
Overtime 30 $0 $0 $0 $900 $1,200 $600 $2,700
Subcontract 25 $0 $0 $0 $250 $250 $250 $750
Hire/Layoff
Inventory 10 $50 $150 $100 $0 $0 $0 $300
Backorders 18 0 0 0 0 0 0 $0
$11,050 $11,150 $11,100 $12,150 $12,450 $11,850 $69,750

Supporting calculation:

Forecast and regular time units are given. It is given maximum units of overtime is 20 units and maximum subcontract unit is 10 units. The added units should make the difference from a negative value to 0.

Calculate the difference for the month of 1:

It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 10 units.

Difference=OutputForecast=(Regular+Overtime+Subcontract)Forecast=(550+0+0)540=10

Calculate the difference for the month of 2:

It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is 10 units.

Difference=OutputForecast=(Regular+Overtime+Subcontract)Forecast=(550+0+0)540=10

Calculate the difference for the month of 3:

It is the calculation of difference between forecast and output. Hence, it can be calculated by subtracting the forecast from the output. Hence, the difference is -20 units.

Difference=OutputForecast=(Regular+Overtime+Subcontract)Forecast=(550+0+0)570=20

Note: The calculation repeats for all the months.

Beginning inventory:

The initial inventory is given as 0. For the remaining months, ending inventory of previous month would be the beginning inventory of present month.

Ending inventory for 1st month:

Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 10 units.

Ending inventory=Beginning inventory of January+Difference between output and forecast=0+10=10

Ending inventory for 2nd month:

Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 20 units.

Ending inventory=Beginning inventory of February+Difference between output and forecast=10+10=20

Ending inventory for 3rd month:

Ending inventory can be determined by adding the beginning inventory and difference between output and forecast. Hence, the ending inventory is 0 units.

Ending inventory=Beginning inventory of March+Difference between output and forecast=2020=0

Note: The calculation repeats for all the months.

Average inventory for 1st month:

It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 10 units.

Average inventory=Beginning inventory+Ending inventory2=0+102=5

Average inventory for 2nd month:

It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 15 units.

Average inventory=Beginning inventory+Ending inventory2=10+202=15

Average inventory for 3rd month:

It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 10 units.

Average inventory=Beginning inventory+Ending inventory2=20+02=10

Note: The calculation repeats for all the months.

Calculate the regular time cost for the 1st month:

Regular time cost per unit is given as $20 and regular time unit is given as 550. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $11,000.

Regular time cost=Regular time cost per unit×Regular time units=$20×550=$11,000

Calculate the regular time cost for the 2nd month:

Regular time cost per unit is given as $20 and regular time unit is given as 550. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $11,000.

Regular time cost=Regular time cost per unit×Regular time units=$20×550=$11,000

Calculate the regular time cost for the 3rdmonth:

Regular time cost per unit is given as $20 and regular time unit is given as 550. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $11,000.

Regular time cost=Regular time cost per unit×Regular time units=$20×550=$11,000

Note: The calculation repeats for all the months.

Calculate the total regular time cost:

It is calculated by adding the regular time cost of all the months.

Total regular time cost=Regular time of all the months=$11,000+$11,000+$11,000+$11,000+$11,000+$11,000=$66,000

Hence, the total regular time cost is $66,000.

Calculate the overtime cost for 1st month:

Overtime cost per unit is given as $30 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.

Overtime cost=Overtime cost per unit×Overtime units=$30×0=$0

Calculate the overtime cost for the 2nd month:

Overtime cost per unit is given as $30 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.

Overtime cost=Overtime cost per unit×Overtime units=$30×0=$0

Calculate the overtime cost for the 3rd month:

Overtime cost per unit is given as $30 and overtime unit is given as 0. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $0.

Overtime cost=Overtime cost per unit×Overtime units=$30×0=$0

Calculate the overtime cost for the 4th month:

Overtime cost per unit is given as $30 and overtime unit is given as 30. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $900.

Overtime cost=Overtime cost per unit×Overtime units=$30×30=$900

Note: The calculation repeats for all the months.

Calculate the total overtime cost:

It is calculated by adding the overtime cost of all the months.

Total overtime cost=Overtime of all the months=$0+$0+$0+$900+$1,200+$600=$2,700

Hence, the total overtime cost is $2,700.

Calculate the subcontract cost for 1st month:

Subcontract cost per unit is given as $25 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.

Subcontract cost=Subcontract cost per unit×Subcontract units=$25×0=$0

Calculate the subcontract cost for 2nd month:

Subcontract cost per unit is given as $25 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.

Subcontract cost=Subcontract cost per unit×Subcontract units=$25×0=$0

Calculate the subcontract cost for 3rd month:

Subcontract cost per unit is given as $25 and subcontract unit is given as 0. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $0.

Subcontract cost=Subcontract cost per unit×Subcontract units=$25×0=$0

Calculate the subcontract cost for 3rd month:

Subcontract cost per unit is given as $25 and subcontract unit is given as 10. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $250.

Subcontract cost=Subcontract cost per unit×Subcontract units=$25×10=$250

Note: The calculation repeats for all the months.

Calculate the total subcontract cost:

It is calculated by adding the subcontract cost of all the months.

Total subcontract cost=Subcontract of all the months=$0+$0+$0+$250+$250+$250=$0

Hence, the total subcontract cost is $0.

Calculate the inventory cost for 1st month:

It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $50.

Inventory cost=Inventory cost per unit×Average inventory=$10×5=$50

Calculate the inventory cost for 2nd month:

It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $150.

Inventory cost=Inventory cost per unit×Average inventory=$10×15=$150

Calculate the inventory cost for 3rd month:

It is calculated by average balance inventory cost and the average inventory units. Hence, the inventory cost is $100.

Inventory cost=Inventory cost per unit×Average inventory=$10×10=$100

Calculate the total inventory cost:

It is calculated by adding the inventory cost of all the months.

Total inventory cost=Inventory cost of all the months=$50+$150+$100+$0+$0+$0=$300

Hence, the total inventory cost is $300.

Calculate the total cost of the plan:

It is calculated by adding the total regular time cost, overtime cost, subcontract cost, and inventory cost.

Total cost of the plan=(Total regular time cost+Total overtime cost+Total subcontract cost+Total inventory cost)=$66,000+$2,700+$750+$300=$69,750

Hence, the total cost of the plan is $69,750.

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
問題2 Production system design involves determining the arrangement of workstations and the... O allocation of resources to workstations design of the process O production schedule all of the above
Elaborate on the need for and the benefits of an effective supply chain management (SCM) system in the context of a globalized and networked economy. In your answer, explain how organizations like Dell and Hewlett-Packard leverage supply chain networks to maintain competitiveness, and analyse the impact of globalization, technological advancements, and business environment changes on supply chain structures. Additionally, evaluate the key components of SCM, including distribution network configuration, inventory management, and cash-flow management, and discuss how these components contribute to creating an effective and integrated supply chain. (15) 3.2. Critically evaluate the requirements for effective inventory management within an organization. In your answer, discuss the importance of inventory accounting systems, the role of cost information (holding, ordering, and shortage costs), and the significance of classification systems like ABC analysis. Additionally, analyse how…
Assess the role of EDI in ensuring supply chain security and data integrity. How does EDI contribute to reducing vulnerabilities in supply chain operations, and what best practices should organizations adopt to maintain a secure and reliable EDI system? (10) 1.3. Examine how the adoption of modern EDI systems influences the strategic decision-making process in supply chain management. How does EDI provide supply chain managers with actionable insights, and what are the implications of these insights for long-term supply chain planning? (10) 1.4. Evaluate the potential challenges and risks associated with the modernization of EDI systems in supply chain management. How can organizations effectively manage these challenges to ensure successful EDI implementation and ongoing optimization? (10)

Chapter 11 Solutions

Operations Management (Comp. Instructor's Edition)

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
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
    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 2018
    Marketing
    ISBN:9780357033753
    Author:Pride
    Publisher:CENGAGE L
    Text book image
    Principles of Management
    Management
    ISBN:9780998625768
    Author:OpenStax
    Publisher:OpenStax College
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
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 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY