OPERATIONS MANAGEMENT W/ CNCT+
OPERATIONS MANAGEMENT W/ CNCT+
12th Edition
ISBN: 9781259574931
Author: Stevenson
Publisher: MCG CUSTOM
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
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely.
Southeast Soda​ Pop, Inc., has a new fruit drink for which it has high hopes. John​ Mittenthal, the production​ planner, has assembled the following cost data and demand​ forecast:   demand forecast.                 Quarter Forecast 1 1,900 2 1,200 3 1,600 4 800 ​Costs/Other Data Previous​ quarter's output=1,200 cases Beginning inventory=0 cases Stockout cost of backorders=​$160 per case Inventory holding cost=​$40 per case at end of quarter Hiring employees=​$35 per case Terminating employees=​$80 per case Subcontracting cost=​$65 per case Unit cost on regular time=​$30 per case Overtime cost=​$20 extra per case Capacity on regular time=1,900 cases per quarter John's job is to develop an aggregate plan. The three initial options he wants to evaluate​ are:   • Plan A​: a strategy that hires and fires personnel as necessary to meet the forecast. • Plan B​: a level strategy. • Plan C​: a level strategy that…
A Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current workforce of 100 staff can produce 1500 cases of pizzas per month. (a) Prepare a production plan that keeps the output level. How much warehouse space would the company need for this plan? (b) Prepare a demand chase plan. What implications would this have for staffing levels, assuming that the maximum amount of overtime would result in production levels of only 10 per cent greater than normal working hours?   Table 1 demand forecast Month                            Demand (cases per month) January                                                600 February                                              800 March                                                 1000 April                                                     1500 May                                                     2000 June                                                     1700 July…

Chapter 11 Solutions

OPERATIONS MANAGEMENT W/ CNCT+

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