Operations Management
Operations Management
13th Edition
ISBN: 9781259667473
Author: William J Stevenson
Publisher: McGraw-Hill Education
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
The annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200 per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk ordering as given below. Can the manager reduce his costs by taking advantage of either of these discounts? Recommend the best ordering policy for the store. Order size Unit cost (Rs.) 1 – 49 pcs. 20.00 50 – 149 pcs. 19.50 150 – 299 pcs. 19.00 300 pcs. or more 18.00
Help answer showing level work and formulas
I need to forecast using a 3-Period-Moving-Average-Monthly forecasting model which I did but then I need to   use my forecast numbers to generate a Master Production Schedule (MPS)  I have to Start with actual sales (my own test data numbers) for August-2022 Oct-2022 i need to create MPS to supply demand starting November-2022  April 2023  I just added numbers without applying formulas to the mps on the right side of the spreadsheet because I do not know how to do it. The second image is the example of what it should look like. Thank You.

Chapter 11 Solutions

Operations Management

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
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