Compute the total cost for each aggregate plan using these unit costs: Regular output = $40 Overtime = $50 Subcontract = $60 Average Balance Inventory = $10 a. b. c . (Refer to part b ) After complaints from some workers about working overtime every month during the first half of the year, the manager is now considering adding some temporary workers for the second half of the year, which would increase regular output to a steady 350 units a month, not using any overtime, and using subcontracting to make up needed output. Determine the total cost of that plan.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 11, Problem 1P

Compute the total cost for each aggregate plan using these unit costs:

Regular output = $40

Overtime = $50

Subcontract = $60

Average Balance Inventory = $10

a. Chapter 11, Problem 1P, Compute the total cost for each aggregate plan using these unit costs: Regular output = 40 Overtime , example 1

b. Chapter 11, Problem 1P, Compute the total cost for each aggregate plan using these unit costs: Regular output = 40 Overtime , example 2

c. (Refer to part b) After complaints from some workers about working overtime every month during the first half of the year, the manager is now considering adding some temporary workers for the second half of the year, which would increase regular output to a steady 350 units a month, not using any overtime, and using subcontracting to make up needed output. Determine the total cost of that plan.

a)

Expert Solution

Summary Introduction

To compute: The total cost for each aggregate plan

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

The total cost for the aggregate plan is $78,600.

Explanation of Solution

Given information:

Regular output is $40, overtime is $50, subcontract is $60, and average balance inventory is $10.

In addition to this, the following information is given:

Month	January	February	March	April	May	June
Forecast	300	320	320	340	320	320
Regular	300	300	300	300	300	300
Overtime	20	20	20	20	20	20
Subcontract	0	0	0	0	0	0

Determine the aggregate plan to compute total cost:

Month		January	February	March	April	May	June	Total
Forecast		300	320	320	340	320	320	1,920
Output
Regular		300	300	300	300	300	300	1,800
Part-time
Overtime		20	20	20	20	20	20	120
Subcontract		0	0	0	0	0	0	0
Difference		20	0	0	-20	0	0	0
Inventory
Beginning		0	20	20	20	0	0	60
Ending		20	20	20	0	0	0	60
Average		10	20	20	10	0	0	60
Backlog		0	0	0	0	0	0	0
Costs
Regular	40	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$72,000
Part-time
Overtime	50	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$6,000
Subcontract	60	$0	$0	$0	$0	$0	$0	$0
Hire/Layoff
Inventory	10	$100	$200	$200	$100	$0	$0	$600
Backorders		$0	$0	$0	$0	$0	$0	$0
		$13,100	$13,200	$13,200	$13,100	$13,000	$13,000	$78,600

Supporting calculation:

Forecast, regular time units, overtime, and subcontract units were given.

Calculate the difference of month January:

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=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+0)−300=20$

Calculate the difference of month February:

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 0 units.

$Difference=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+0)−320=0$

Calculate the difference of month March:

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 0 units.

$Difference=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+0)−320=0$

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 the month of January:

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 January+Difference between output and forecast]=0+20=20$

Ending inventory for the month of February:

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]=20+0=20$

Ending inventory for the month of March:

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 March+Difference between output and forecast=20+0=20$

Note: The calculation repeats for all the months.

Average inventory for the month of January:

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+202=10$

Average inventory for the month of February:

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

$Average inventory=Beginning inventory+Ending inventory2=20+202=20$

Average inventory for the month of March:

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

$Average inventory=Beginning inventory+Ending inventory2=20+202=20$

Note: The calculation repeats for all the months.

Calculate the regular time cost for the month of January:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,000$

Calculate the regular time cost for the month of February:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,000$

Calculate the regular time cost for the month of March:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,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=$12,000+$12,000+$12,000+$12,000+$12,000+$12,000=$72,000$

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

Calculate the overtime cost for the month of January:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

Calculate the overtime cost for the month of February:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

Calculate the overtime cost for the month of March:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

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=$1,000+$1,000+$1,000+$1,000+$1,000+$1,000=$6,000$

Hence, the total overtime cost is $6,000.

Calculate the subcontract cost for the month of January:

Subcontract cost per unit is given as $60 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=$60×0=$0$

Calculate the subcontract cost for the month of February:

Subcontract cost per unit is given as $60 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=$60×0=$0$

Calculate the subcontract cost for the month of March:

Subcontract cost per unit is given as $60 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=$60×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 the month of January:

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 inventory cost for the month of February:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×20=$200$

Calculate the inventory cost for the month of March:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×20=$200$

Note: The calculation repeats for all the months.

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=$100+$200+$200+$100+$0+$0=$600$

Hence, the total inventory cost is $600.

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)=$72,000+$6,000+$0+$600=$78,600$

Hence, the total cost of the plan is $78,600.

b)

Expert Solution

Summary Introduction

To compute: The total cost for each aggregate plan.

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

The total cost for the aggregate plan is $95,500.

Explanation of Solution

Given information:

Regular output is $40, overtime is $50, subcontract is $60, and average balance inventory is $10.

In addition to this, the following information is given:

Month	July	August	September	October	November	December
Forecast	320	340	360	380	400	400
Regular	300	300	300	300	300	300
Overtime	20	20	20	20	30	30
Subcontract	20	30	40	40	60	70

Determine the aggregate plan to compute total cost:

Month		July	August	September	October	November	December	Total
Forecast		320	340	360	380	400	400	2,200
Output
Regular		300	300	300	300	300	300	1,800
Part-time
Overtime		20	20	20	20	30	30	140
Subcontract		20	30	40	40	60	70	260
Difference		20	10	0	-20	-10	0	0
Inventory
Beginning		0	20	30	30	10	0	90
Ending		20	30	30	10	0	0	90
Average		10	25	30	20	5	0	90
Backlog		0	0	0	0	0	0	0
Costs
Regular	40	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$72,000
Part-time
Overtime	50	$1,000	$1,000	$1,000	$1,000	$1,500	$1,500	$7,000
Subcontract	60	$1,200	$1,800	$2,400	$2,400	$3,600	$4,200	$15,600
Hire/Layoff
Inventory	10	$100	$250	$300	$200	$50	$0	$900
Backorders
		$14,300	$15,050	$15,700	$15,600	$17,150	$17,700	$95,500

Supporting calculation:

Forecast, regular time units, overtime, and subcontract units were given.

Calculate the difference of month July:

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=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+20)−320=20$

Calculate the difference of month August:

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=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+30)−340=10$

Calculate the difference of month September:

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 0 units.

$Difference=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+40)−360=0$

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 the month of July:

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 July+Difference between output and forecast=0+20=20$

Ending inventory for the month of August:

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 August+Difference between output and forecast=20+10=30$

Ending inventory for the month of September:

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 September+Difference between output and forecast=30+0=30$

Note: The calculation repeats for all the months.

Average inventory for the month of July:

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+202=10$

Average inventory for the month of August:

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

$Average inventory=Beginning inventory+Ending inventory2=20+302=25$

Average inventory for the month of September:

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

$Average inventory=Beginning inventory+Ending inventory2=30+302=30$

Note: The calculation repeats for all the months.

Calculate the regular time cost for the month of July:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,000$

Calculate the regular time cost for the month of August:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,000$

Calculate the regular time cost for the month of September:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,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=$12,000+$12,000+$12,000+$12,000+$12,000+$12,000=$72,000$

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

Calculate the overtime cost for the month of July:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

Calculate the overtime cost for the month of August:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

Calculate the overtime cost for the month of September:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

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=$1,000+$1,000+$1,000+$1,000+$1,000+$1,000=$6,000$

Hence, the total overtime cost is $6,000.

Calculate the subcontract cost for the month of July:

Subcontract cost per unit is given as $60 and subcontract unit is given as 20. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $1,200.

$Subcontract cost=Subcontract cost per unit×Subcontract units=$60×20=$1,200$

Calculate the subcontract cost for the month of August:

Subcontract cost per unit is given as $60 and subcontract unit is given as 30. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $1,800.

$Subcontract cost=Subcontract cost per unit×Subcontract units=$60×30=$1,800$

Calculate the subcontract cost for the month of September:

Subcontract cost per unit is given as $60 and subcontract unit is given as 40. Subcontract cost is calculated by multiplying subcontract unit and subcontract cost per unit. Hence, the subcontract cost is $2,400.

$Subcontract cost=Subcontract cost per unit×Subcontract units=$60×40=$2,400$

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=$1,200+$1,800+$2,400+$2,400+$3,600+$4,200=$15,600$

Hence, the total subcontract cost is $15,600.

Calculate the inventory cost for the month of July:

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 inventory cost for the month of August:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×25=$250$

Calculate the inventory cost for the month of September:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×30=$300$

Note: The calculation repeats for all the months.

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=$100+$250+$300+$200+$50+$0=$900$

Hence, the total inventory cost is $900.

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)=$72,000+$6,000+$15,600+$900=$95,500$

Hence, the total cost of the plan is $95,500.

c)

Expert Solution

Summary Introduction

To compute: The total cost for each aggregate plan.

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

The total cost for the aggregate plan is $91,000.

Explanation of Solution

Given information:

Regular output is $40, overtime is $50, subcontract is $60, and average balance inventory is $10.

In addition to this, the following information is given:

Month	July	August	September	October	November	December
Forecast	320	340	360	380	400	400
Regular	350	350	350	350	350	350
Overtime	0	0	0	0	0	0

It is given that subcontract can be used whenever necessary.

Determine the aggregate plan to compute total cost:

Month		July	August	September	October	November	December	Total
Forecast		320	340	360	380	400	400	2,200
Output
Regular		350	350	350	350	350	350	2,100
Part-time
Overtime
Subcontract						50	50
Difference		30	10	-10	-30	0	0	0
Inventory
Beginning		0	30	40	30	0	0	100
Ending		30	40	30	0	0	0	100
Average		15	35	35	15	0	0	100
Backlog		0	0	0	0	0	0	0
Costs
Regular	40	$14,000	$14,000	$14,000	$14,000	$14,000	$14,000	$84,000
Part-time
Overtime	50	$0	$0	$0	$0	$0	$0	$0
Subcontract	60	$0	$0	$0	$0	$3,000	$3,000	$6,000
Hire/Layoff
Inventory	10	$150	$350	$350	$150	$0	$0	$1,000
Backorders		0	0	0	0	0	0	0
		$14,150	$14,350	$14,350	$14,150	$17,000	$17,000	$91,000

Supporting calculation:

Forecast, regular time units, overtime, and subcontract units were given.

Calculate the difference of month July:

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 30 units.

$Difference=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(350+0+0)−320=30$

Calculate the difference of month August:

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=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(350+0+0)−340=10$

Calculate the difference of month September:

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=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(350+0+0)−360=−10$

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 the month of July:

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

$Ending inventory=Beginning inventory of July+Difference between output and forecast=0+30=30$

Ending inventory for the month of August:

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

$Ending inventory=Beginning inventory of August+Difference between output and forecast=30+10=40$

Ending inventory for the month of September:

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 September+Difference between output and forecast=40+(−10)=30$

Note: The calculation repeats for all the months.

Average inventory for the month of July:

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=0+302=15$

Average inventory for the month of August:

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

$Average inventory=Beginning inventory+Ending inventory2=30+402=35$

Average inventory for the month of September:

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

$Average inventory=Beginning inventory+Ending inventory2=40+302=35$

Note: The calculation repeats for all the months.

Calculate the regular time cost for the month of July:

Regular time cost per unit is given as $40 and regular time unit is given as 350. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $14,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×350=$14,000$

Calculate the regular time cost for the month of August:

Regular time cost per unit is given as $40 and regular time unit is given as 350. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $14,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×350=$14,000$

Calculate the regular time cost for the month of September:

Regular time cost per unit is given as $40 and regular time unit is given as 350. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $14,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×350=$14,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=$14,000+$14,000+$14,000+$14,000+$14,000+$14,000=$84,000$

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

Calculate the overtime cost for the month of July:

Overtime cost per unit is given as $50 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=$50×20=$0$

Calculate the overtime cost for the month of August:

Overtime cost per unit is given as $50 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=$50×20=$0$

Calculate the overtime cost for the month of September:

Overtime cost per unit is given as $50 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=$50×20=$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 the month of July:

Subcontract cost per unit is given as $60 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=$60×0=$0$

Calculate the subcontract cost for the month of August:

Subcontract cost per unit is given as $60 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=$60×0=$0$

Calculate the subcontract cost for the month of September:

Subcontract cost per unit is given as $60 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=$60×0=$0$

Note: The calculation repeats for all the months. As there are backlogs in the month of November and December, there would be 50 units of subcontracting in those 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+$3,000+$3,000=$6,000$

Hence, the total subcontract cost is $15,600.

Calculate the inventory cost for the month of July:

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 the month of August:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×35=$350$

Calculate the inventory cost for the month of September:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×35=$350$

Note: The calculation repeats for all the months.

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=$150+$350+$350+$150+$50+$0=$1,000$

Hence, the total inventory cost is $1,000.

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)=$84,000+$0+$6,000+$1,000=$91,000$

Hence, the total cost of the plan is $91,000.

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: A waiting line model solver computer package is needed to answer these questions. The Kolkmeyer Manufacturing Company uses a group of six identical machines, each of which operates an average of 23 hours between breakdowns. With randomly occurring breakdowns, the Poisson probability distribution is used to describe the machine breakdown arrival process. One person from the maintenance department provides the single-server repair service for the six machines. Management is now considering adding two machines to its manufacturing operation. This addition will bring the number of machines to eight. The president of Kolkmeyer asked for a study of the need to add a second employee to the repair operation. The service rate for each individual assigned to the repair operation is 0.40 machines per hour. (a) Compute the operating characteristics if the company retains the single-employee repair operation. (Round your answers to four decimal places. Report time in hours.) La = L = Wa W = h…

Burger Dome sells hamburgers, cheeseburgers, french fries, soft drinks, and milk shakes, as well as a limited number of specialty items and dessert selections. Although Burger Dome would like to serve each customer immediately, at times more customers arrive than can be handled by the Burger Dome food service staff. Thus, customers wait in line to place and receive their orders. Burger Dome analyzed data on customer arrivals and concluded that the arrival rate is 40 customers per hour. Burger Dome also studied the order-filling process and found that a single employee can process an average of 56 customer orders per hour. Burger Dome is concerned that the methods currently used to serve customers are resulting in excessive waiting times and a possible loss of sales. Management wants to conduct a waiting line study to help determine the best approach to reduce waiting times and improve service. Suppose Burger Dome establishes two servers but arranges the restaurant layout so that an…

Agan Interior Design provides home and office decorating assistance to its customers. In normal operation, an average of 2.6 customers arrive each hour. One design consultant is available to answer customer questions and make product recommendations. The consultant averages 10 minutes with each customer. (a) Compute the operating characteristics of the customer waiting line, assuming Poisson arrivals and exponential service times. (Round your answers to four decimal places. Report time in hours.) λ= μ = = L = Wa W = P. W h (b) Service goals dictate that an arriving customer should not wait for service more than an average of 5 minutes. Is this goal being met? (Round your answer to one decimal place.) W₁ (in minutes) = min, which is ---Select--- than the desired wait time, so the goal ---Select--- met. What action do you recommend? (Select all that apply.) Hire another consultant. Increase the hours of operation. Decrease the mean service rate. Increase the mean service rate. There is…

Answer 2

Textbook Question

Chapter 11, Problem 1P

Compute the total cost for each aggregate plan using these unit costs:

Regular output = $40

Overtime = $50

Subcontract = $60

Average Balance Inventory = $10

a. Chapter 11, Problem 1P, Compute the total cost for each aggregate plan using these unit costs: Regular output = 40 Overtime , example 1

b. Chapter 11, Problem 1P, Compute the total cost for each aggregate plan using these unit costs: Regular output = 40 Overtime , example 2

c. (Refer to part b) After complaints from some workers about working overtime every month during the first half of the year, the manager is now considering adding some temporary workers for the second half of the year, which would increase regular output to a steady 350 units a month, not using any overtime, and using subcontracting to make up needed output. Determine the total cost of that plan.

a)

Expert Solution

Summary Introduction

To compute: The total cost for each aggregate plan

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

The total cost for the aggregate plan is $78,600.

Explanation of Solution

Given information:

Regular output is $40, overtime is $50, subcontract is $60, and average balance inventory is $10.

In addition to this, the following information is given:

Month	January	February	March	April	May	June
Forecast	300	320	320	340	320	320
Regular	300	300	300	300	300	300
Overtime	20	20	20	20	20	20
Subcontract	0	0	0	0	0	0

Determine the aggregate plan to compute total cost:

Month		January	February	March	April	May	June	Total
Forecast		300	320	320	340	320	320	1,920
Output
Regular		300	300	300	300	300	300	1,800
Part-time
Overtime		20	20	20	20	20	20	120
Subcontract		0	0	0	0	0	0	0
Difference		20	0	0	-20	0	0	0
Inventory
Beginning		0	20	20	20	0	0	60
Ending		20	20	20	0	0	0	60
Average		10	20	20	10	0	0	60
Backlog		0	0	0	0	0	0	0
Costs
Regular	40	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$72,000
Part-time
Overtime	50	$1,000	$1,000	$1,000	$1,000	$1,000	$1,000	$6,000
Subcontract	60	$0	$0	$0	$0	$0	$0	$0
Hire/Layoff
Inventory	10	$100	$200	$200	$100	$0	$0	$600
Backorders		$0	$0	$0	$0	$0	$0	$0
		$13,100	$13,200	$13,200	$13,100	$13,000	$13,000	$78,600

Supporting calculation:

Forecast, regular time units, overtime, and subcontract units were given.

Calculate the difference of month January:

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=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+0)−300=20$

Calculate the difference of month February:

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 0 units.

$Difference=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+0)−320=0$

Calculate the difference of month March:

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 0 units.

$Difference=Output−Forecast=(Regular+Overtime+Subcontract)−Forecast=(300+20+0)−320=0$

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 the month of January:

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 January+Difference between output and forecast]=0+20=20$

Ending inventory for the month of February:

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]=20+0=20$

Ending inventory for the month of March:

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 March+Difference between output and forecast=20+0=20$

Note: The calculation repeats for all the months.

Average inventory for the month of January:

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+202=10$

Average inventory for the month of February:

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

$Average inventory=Beginning inventory+Ending inventory2=20+202=20$

Average inventory for the month of March:

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

$Average inventory=Beginning inventory+Ending inventory2=20+202=20$

Note: The calculation repeats for all the months.

Calculate the regular time cost for the month of January:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,000$

Calculate the regular time cost for the month of February:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,000$

Calculate the regular time cost for the month of March:

Regular time cost per unit is given as $40 and regular time unit is given as 300. Regular time cost is calculated by multiplying regular time unit and regular time cost per unit. Hence, the regular time cost is $12,000.

$Regular time cost=Regular time cost per unit×Regular time units=$40×300=$12,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=$12,000+$12,000+$12,000+$12,000+$12,000+$12,000=$72,000$

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

Calculate the overtime cost for the month of January:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

Calculate the overtime cost for the month of February:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

Calculate the overtime cost for the month of March:

Overtime cost per unit is given as $50 and overtime unit is given as 20. Overtime cost is calculated by multiplying overtime unit and overtime cost per unit. Hence, the overtime cost is $1,000.

$Overtime cost=Overtime cost per unit×Overtime units=$50×20=$1,000$

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=$1,000+$1,000+$1,000+$1,000+$1,000+$1,000=$6,000$

Hence, the total overtime cost is $6,000.

Calculate the subcontract cost for the month of January:

Subcontract cost per unit is given as $60 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=$60×0=$0$

Calculate the subcontract cost for the month of February:

Subcontract cost per unit is given as $60 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=$60×0=$0$

Calculate the subcontract cost for the month of March:

Subcontract cost per unit is given as $60 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=$60×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 the month of January:

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 inventory cost for the month of February:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×20=$200$

Calculate the inventory cost for the month of March:

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

$Inventory cost=Inventory cost per unit×Average inventory=$10×20=$200$

Note: The calculation repeats for all the months.

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=$100+$200+$200+$100+$0+$0=$600$

Hence, the total inventory cost is $600.

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)=$72,000+$6,000+$0+$600=$78,600$

Hence, the total cost of the plan is $78,600.

b)

Expert Solution

Summary Introduction

To compute: The total cost for each aggregate plan.

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

The total cost for the aggregate plan is $95,500.

Explanation of Solution

Given information:

Regular output is $40, overtime is $50, subcontract is $60, and average balance inventory is $10.

In addition to this, the following information is given:

Month	July	August	September	October	November	December
Forecast	320	340	360	380	400	400
Regular	300	300	300	300	300	300
Overtime	20	20	20	20	30	30
Subcontract	20	30	40	40	60	70

Determine the aggregate plan to compute total cost:

Month		July	August	September	October	November	December	Total
Forecast		320	340	360	380	400	400	2,200
Output
Regular		300	300	300	300	300	300	1,800
Part-time
Overtime		20	20	20	20	30	30	140
Subcontract		20	30	40	40	60	70	260
Difference		20	10	0	-20	-10	0	0
Inventory
Beginning		0	20	30	30	10	0	90
Ending		20	30	30	10	0	0	90
Average		10	25	30	20	5	0	90
Backlog		0	0	0	0	0	0	0
Costs
Regular	40	$12,000	$12,000	$12,000	$12,000	$12,000	$12,000	$72,000
Part-time
Overtime	50	$1,000	$1,000	$1,000	$1,000	$1,500	$1,500	$7,000
Subcontract	60	$1,200	$1,800	$2,400	$2,400	$3,600	$4,200	$15,600
Hire/Layoff
Inventory	10	$100	$250	$300	$200	$50	$0	$900
Backorders
		$14,300	$15,050	$15,700	$15,600	$17,150	$17,700	$95,500