
Concept explainers
a. Given the following
Regular output = $20
Overtime = $30
Subcontract = $25
Average Inventory = $10
Backlog = $18
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)

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
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.
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.
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.
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 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.
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 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 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.
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 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 for 3rd month:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 10 units.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Calculate the total inventory cost:
It is calculated by adding the inventory cost of all the months.
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.
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.
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.
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.
Hence, the total cost of the plan is $70,800.
b)

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
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.
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.
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.
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 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 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.
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 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 for 3rd month:
It is calculated by taking an average of beginning inventory and ending inventory. Hence, the average inventory is 10 units.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Calculate the total inventory cost:
It is calculated by adding the inventory cost of all the months.
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.
Hence, the total cost of the plan is $69,750.
Want to see more full solutions like this?
Chapter 11 Solutions
EBK OPERATIONS MANAGEMENT
- Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it. Customer orders (committed) are as follows: Week Customer Orders 1 2 36 28 4 1 Use a production lot size of 85 units and no beginning inventory. Note: In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required. June July 1 2 3 4 5 8 7 8 Forecast 60 60 60 60 60 60 60 60 Customer Orders 38 28 4 1 0 0 0 0 Projected On-Hand Inventory MPS ATParrow_forwardSales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 Forecast 21.0 21 21 24 31 28 29 32 28 26.50 b) For the forecast developed using exponential smoothing (a = 0.50 and initial forecast 21.0), the MAD = |||||sales (round your response to two decimal places).arrow_forwardSales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 2 3 4 5 6 7 8 9 10 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 Demand 21 21 27 38 Forecast 21.0 ☐ G ☐ ☐ 6 7 25 30 35 ∞ ☐ 8 9 10 24 25 30arrow_forward
- Each machine costs $3 Million. Building the room with all its attendant safety protection and other ancillary costs increases the spending by an additional $2.0 million dollars per MRI suite. Each machine can perform 2000 scans per year. Each reading of an MRI scan by a radiologist, along with other per-scan-related costs, is $500 per scan. The machine will last five years. Don’t worry about discount rates for this problem Graph the total costs over 5 years as a function of sales for 0-3000 patients annually. Hint: you may need to add a second MRI at some point. Suppose that you want to make a profit of $500 per scan at a target volume of 1000 patients per year, and you purchase only one machine. Superimpose the total revenue curve on top of the total cost curve in (1).arrow_forwardI need the answer to requirement C.arrow_forwardImagine you are Susan Kim and are faced with a difficult choice to either follow the orders she was given, or refusing to do so. Using each lens determine what the ethical response would be. Suppot your answer with materials from readings and lectures. For example, using Universalism what would the ethical response be? Do the same for all four lenses.arrow_forward
- Answer all these questions, selecting any company of your choice. Choose a specific type of food company. Select a specific product. Develop all the inputs that are part of the process. Develop the transformation process in a graphic (diagram, etc.). Develop all the outputs or finished products that are part of the process. Describe all the processes involved in one line of production in any manufacturing facility. Also describing how good management is the center of any part of a production company.arrow_forwardUsing exponential smoothing with α =0.2, forecast the demand for The initial forecast for January is 2000 tons. Calculate the capacity utilization for June, July and Discuss the implications of underutilized or over utilized capacity for Green Harvestarrow_forwardIn organizational development when results are improving but relationships are declining, what leadership style is appropriate? directing delegating supporting coachingarrow_forward
- What is the first thing a leader should do when moving through a cultural change? conduct an assessment comparing the practices to other high-performing organizations learn about the current organizational culture continue to monitor key metrics define expectationsarrow_forwardThe third change leadership strategy, Collaborate on Implementation, is designed to address what type of concerns? impact concerns personal concerns refinement concerns collaboration concernsarrow_forwardIf team members are concerned with specifics such as their tasks, contingency plans, resources, and timeline, what concerns do they have? implementation concerns impact concerns refinement concerns personal concernsarrow_forward
- MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPurchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningPractical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,

