
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)
- How can HR proactively help ensure that other departments are operating in a legally acceptable manner? Answers Deliver interdepartmental training on legal compliance and requirements. Discuss potential sources of risk with an attorney and create a plan to respond to lawsuits. Ensure that all HR members are watching the conduct of other departments and report infractions to the head of HR. Record improper conduct from various employees throughout the organization and pursue disciplinary measures.arrow_forwardCan you guys help me with this? Thank you! Project is Terminal 1 at JFK International Airport Question: Risk management content: Discuss a major risk management event that affected the project (Keep this content about 2 minute talking and please provide actual sources that you have the information to go over this)arrow_forwarduse the screenshot to find the anwser to this If the project finishes within 27 weeks of its start, the project manager receives a $500 bonus. What is the probability of a $500 bonus? Note: Round z-value to 2 decimal places, and probability to 4 decimal places.arrow_forward
- Scan To Pay Log into your own Lightning UPI account of supporting app and scan QR code below to pay! ✰ BINANCEarrow_forwardTo help with preparations, a couple has devised a project network to describe the activities that must be completed by their wedding date. Start A Ꭰ F B E The following table lists the activity time estimates (in weeks) for each activity. Optimistic Most Probable Activity Pessimistic A 4 5 6 B 2.5 3 3.5 C 5 6 7 D 5 5.5 9 E 5 7 9 F 2 3 4 G 7 9 11 H 5 6 13 H Finish Based only on the critical path, what is the estimated probability that the project will be completed within the given time frame? (Round your answers to four decimal places.) (a) Within 19 weeks? (b) Within 21 weeks? (c) Within 25 weeks?arrow_forwardYou may need to use the appropriate technology to answer this question. Mueller Associates is a urban planning firm that is designing a new public park in an Omaha suburb. Coordination of the architect and subcontractors will require a major effort to meet the 46-week completion date requested by the owner. The Mueller project manager prepared the following project network. B H Start A C G Finish E Estimates of the optimistic, most probable, and pessimistic times (in weeks) for the activities are as follows. Activity Optimistic Most Probable Pessimistic A 4 12 B 6 7 8 C 6 18 D 3 5 7 E 6 9 18 F 5 8 17 G 10 15 20 H 5 13 (a) Find the critical path. (Enter your answers as a comma-separated list.) (b) What is the expected project completion time (in weeks)? weeks i (c) Based only on the critical path, what is the estimated probability the project can be completed in 46 weeks as requested by the owner? (Round your answer to four decimal places.) (d) Based only on the critical path, what is…arrow_forward
- Bridge City Developers is coordinating the construction of an office complex. As part of the planning process, the company generated the following activity list. Draw a project network that can be used to assist in the scheduling of the project activities. Activity Immediate Predecessor ABC E FGH ] A, B A, B D E с с F, G, H, I A E Start B D A E Start B D H H E A E Finish Start D F J Finish Start B D F Finish Finish C H I Harrow_forwardHow can mindfulness be combined with cognitive reframing to build emotional regulation and mental flexibility? What is the strategy for maintaining mental well-being to improve through deliberate practice? How to engage in practices that help regulate emotions and build resilience?arrow_forward• We Are HIRING Salesforce Developer (2 - 4 Years) @ Cloudodyssey It Solutions Requirement : Appropriate knowledge on Salesforce standard objects Leads, Account, Contacts, Opportunity, Products, Lead process, Sales process, is required. • Hands-on experience in Salesforce Experience Cloud, Sales Cloud and Lightning. • • Hands experience with Salesforce development, administration, system integrations, Lightning Design System, and bug fixes. Experience in configuration, integration, APIs creation, testing and deployment of Salesforce.com functionality. Eloquent verbal and written communication skills. • Familiar with Agile framework. Work Location: Bangalore SUBMIT YOUR CV hello@cloudodyssey.coarrow_forward
- Agree or disagree with post On the surface, the numbers in financial statements do present a snapshot of a company's financial position and performance. However, just looking at the raw numbers often doesn't tell the whole story or reveal underlying trends and relationships that are crucial for making informed decisions. Think of it like looking at individual pieces of a puzzle. Each number is a piece, providing some information. But to see the complete picture – the company's overall financial health, its performance over time, how it compares to its peers, and its potential future – you need to assemble those pieces using different analytical tools. For example: Horizontal analysis helps us understand how specific financial statement items have changed over multiple periods. Is revenue growing? Are expenses increasing at a faster rate than sales? This reveals trends that a single year's numbers wouldn't show. Vertical analysis allows us to see the relative size of each item within…arrow_forwardWhat can you do in response to an insulting offer?arrow_forwardAgree or disagree with post If someone hits you with an insulting offer, the first thing to do is not take it personally. It’s normal to feel a little offended, but blowing up or shutting down won’t help your case. Better move is to stay calm and treat it like a misunderstanding or just the first step in the conversation. That way, you keep things respectful but still let them know the offer doesn’t sit right with you. It also helps to back up your response with facts. Bring in things like your experience, numbers, or any specific results you delivered. That can shift the conversation away from feelings and toward the value you bring. Agree or disagree with postarrow_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,

