
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
Operations Management (Comp. Instructor's Edition)
- In addition to the Amazon case study you provided, I'm curious if you've encountered other examples of companies successfully applying Little's Law to enhance their supply chain risk management practices. For instance, have you seen organizations use queuing theory to assess the potential ripple effects of disruptions, stress-test their contingency plans, or identify critical control points that require heightened monitoring and agility? Please provide a referencearrow_forwardSam's Pet Hotel operates 48 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag The following information is available about these bags: > Demand 85 bags/week >Order cost $60.00/order > Annual holding cost = 35 percent of cost > Desired cycle-service level 80 percent > Lead time = 4 weeks (24 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 85 bags is incorrect and actual demand averages only 65 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)arrow_forwardOsprey Sports stocks everything that a musky fisherman could want in the Great North Woods. A particular musky lure has been very popular with local fishermen as well as those who buy lures on the Internet from Osprey Sports. The cost to place orders with the supplier is $3030/order; the demand averages 55 lures per day, with a standard deviation of 11 lure; and the inventory holding cost is $1.001.00/lure/year. The lead time form the supplier is 1010 days, with a standard deviation of 33 days. It is important to maintain a 9898 percent cycle-service level to properly balance service with inventory holding costs. Osprey Sports is open 350 days a year to allow the owners the opportunity to fish for muskies during the prime season. The owners want to use a continuous review inventory system for this item. Refer to the standard normal table LOADING... for z-values. Part 2 a. What order quantity should be used? enter your response here lures. (Enter your response rounded to the…arrow_forward
- 9. Research Methodology Fully explain the Quantitative research methodology that and add in the following sub-sections: . Data Collection • Data Analysisarrow_forwardRuby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 40 units and is valued at $80 per unit. Inbound shipments from vendor 1 will average 340 units with an average lead time (including ordering delays and transit time) of 2 weeks. Inbound shipments from vendor 2 will average 550 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a 2-week supply of inventory as safety stock and no anticipation inventory. a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $ (Enter your response as a whole number.)arrow_forwardThe Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage 1 3,000 2 3 4 4,000 3,450 3,850 5 3,800 a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = ☐ miles (round your response to the nearest whole number). miles (round your response to one decimal place). (Hint: You will have only 3 years of The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60 = matched data.) d) Using…arrow_forward
- Task time estimates for the modification of an assembly line at Jim Goodale's Carbondale, Illinois, factory are as follows: B D G Time Activity (in hours) Immediate Predecessor(s) A 5.0 B 7.5 C 5.0 A DEFC 8.0 B, C 4.5 Figure 2 A B, C 7.7 D G 5.0 E, F This exercise contains only part a. a) The correct precedence diagram for the project is shown in 目 F B Figure 3 A E B E ☑ D Farrow_forwardDave Fletcher was able to determine the activity times for constructing his laser scanning machine. Fletcher would like to determine ES, EF, LS, LF, and slack for each activity. The total project completion time and the critical path should also be determined. Here are the activity times: Activity Time (weeks) Immediate Predecessor(s) Activity Time (weeks) Immediate Predecessor(s) A 6 E 3 B B 8 F 6 B C 3 A G 11 C, E D 1 A H 7 D, F Dave's earliest start (ES) and earliest finish (EF) are: Activity ES .EF A 0 6 B 0 8 C 3 9 D 6 E F 8 G 22 H 21 Dave's latest start (LS) and latest finish (LF) are: Activity LS LF H 15 G 11 F 9arrow_forwardThere are multiple ways a company can enter a foreign market. Explore two possibilities such as exporting, foreign direct investment, and collaborations (joint ventures, alliances, licensing, franchising), and evaluate the pros and cons of each method. Which types of products and services would be appropriate for each market entry method?arrow_forward
- 01,3 ☐ Question 3 Scenario 9.3 4 pts The Talbot Company uses electrical assemblies to produce an array of small appliances. One of its high cost/high volume assemblies, the XO-01, has an estimated annual demand of 8,000 units. Talbot estimates the cost to place an order is $50, and the holding cost for each assembly is $20 per year. The company operates 250 days per year. Use the information in Scenario 9.3. What is the annual inventory holding cost if Talbot orders using the EOQ quantity? O less than or equal to $1,500 Ogreater than $4,000 but less than or equal to $6,500 O greater than $6,500 O greater than $1,500 but less than or equal to $4,000 Nextarrow_forwardAnalyze Walmart Inc. operations and conducting a strengths, weaknesses, opportunities, and threats (SWOT) analysis. Pay attention to Walmart Inc. strengths and opportunities to come up with a social cause that meshes well with them. Focusing on areas where Walmart Inc. excels and then finding a social cause that can benefit from Walmart Inc. strengths can also ultimately help Consider how shareholder and stakeholder theories of ethics will impact the selection of a target social cause for Walmart Inc to pursue. What responsibility does Walmart Inc. owe to its stockholders and stakeholders? Will pursuing a social responsibility program detract from the responsibilities to these two groups? Any program that is implement will redirect resources toward the social cause and away from the stockholders and stakeholders. Is it ethical? Walmart Inc SWOT analysis. Justify each item of the analysis. Evaluate the ethical implications of pursuing a social responsibility program in terms of the…arrow_forwardDetail Instructions Consider the following activities, activity times and precedence relations for a hypothetical Athletic Club Building project. Activity Activity Description Normal Time (weeks) Immediate Predecessors A Form project team 9 B Prepare renovation plans 12 A C Demolish interior space 10 B D Upgrade utility systems 20 A E Select equipment, furniture & 10 B fixtures F Hire Staff 10 A G Renovate building 30 B,C H Purchase equipment, furniture & 26 E fixtures Install equipment, furniture & 4 D.G.H fixtures 3 FI J Train staffarrow_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,

