
Concept explainers
a)
To evaluate: Plan D
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.
a)

Answer to Problem 6P
Plan D has been evaluated. The total cost of plan D is $128,000.
Explanation of Solution
Given information:
The production for all the months is 1,600 units. Overtime cost is $50 per unit. The maximum allowable inventor in the warehouse is 400 units or less. The demand requirement from period 0 to 8 is as follows:
Period | Expected demand |
0 | 0 |
1 | 1,400 |
2 | 1,600 |
3 | 1,800 |
4 | 1,800 |
5 | 2,200 |
6 | 2,200 |
7 | 1,800 |
8 | 1,800 |
Evaluate the cost of the plan:
Plan D | ||||||
Period | Demand | Production | Overtime (units) | Ending inventory | Stock-outs (units) | Extra cost |
0 | 200 | |||||
1 | 1,400 | 1,600 | - | 400 | $8,000 | |
2 | 1,600 | 1,600 | - | 400 | $8,000 | |
3 | 1,800 | 1,600 | - | 200 | $4,000 | |
4 | 1,800 | 1,600 | - | - | $0 | |
5 | 2,200 | 1,600 | 320 | - | 280 | $44,000 |
6 | 2,200 | 1,600 | 320 | - | 280 | $44,000 |
7 | 1,800 | 1,600 | 200 | - | $10,000 | |
8 | 1,800 | 1,600 | 200 | - | $10,000 | |
Total | 14,600 | 1,040 | 1,000 | $128,000 |
Note: Production is given as 1,600 units. The ending inventory for December is given as 200 units. If the production is more than or equal to the demand, then there would be inventory. If the demand is more, then there would be stock out. Maximum overtime units allowed is 320 units (20% of production)
Calculate the ending inventory or stock-out for Period 1:
It is calculated by adding the production and ending inventory of the previous month and subtracting the result from the demand. The ending inventory for Period 1 is 400.
Calculate the ending inventory or stock-out for Period 2:
It is calculated by adding the production and ending inventory of the previous month and subtracting the result from the demand. The ending inventory for Period 2 is 400.
Calculate the ending inventory or stock-out for Period 3:
It is calculated by adding the production and ending inventory of the previous month and subtracting the result from the demand. The ending inventory for Period 3 is 200.
Calculate the ending inventory or stock-out for Period 4:
It is calculated by adding the production and ending inventory of the previous month and subtracting the result from the demand. The ending inventory for Period 4 is 0.
Calculate the ending inventory or stock-out for Period 5:
As the demand is more than the production, there would be a stock-out.
It is calculated by subtracting the production from the demand. The result should then be subtracted from the overtime units. Hence, the stock-out units for Period 5 is 280 units.
Calculate the ending inventory or stock-out for Period 6:
As the demand is more than the production, there would be a stock-out.
It is calculated by subtracting the production from the demand. The result should then be subtracted from the overtime units. Hence, the stock-out units for Period 6 is 280 units.
Calculate the ending inventory or stock-out for Period 7:
It is calculated by subtracting the production from the demand. The result should then be subtracted from the overtime units. Hence, the stock-out units for Period 7 is 0 units.
Note: Overtime units of 320 units would lead to a negative value. Hence, it was taken as 200 units.
Calculate the ending inventory or stock-out for Period 8:
It is calculated by subtracting the production from the demand. The result should then be subtracted from the overtime units. Hence, the stock-out units for Period 8 is 0 units.
Note: Overtime units of 320 units would lead to negative value. Hence, it was taken as 200 units.
Calculate the extra cost for Period 1:
It is calculated by multiplying the extra inventory units and inventory holding cost. The inventory holding cost is given as $20 per unit. Hence, the extra cost for period 1 is $8,000
Calculate the extra cost for Period 2:
It is calculated by multiplying the extra inventory units and inventory holding cost. Inventory holding cost is given as $20 per unit. Hence, the extra cost for period 2 is $8,000
Calculate the extra cost for Period 3:
It is calculated by multiplying the extra inventory units and inventory holding cost. Inventory holding cost is given as $20 per unit. Hence, the extra cost for period 3 is $4,000
Calculate the extra cost for Period 4:
As there are no overtime units, ending inventory units, or stock-out units, there would not be any extra costs.
Calculate the extra cost for Period 5:
It is calculated by adding the product of overtime units and inventory holding overtime cost per unit, and the product of stock-out units and stock-out cost per unit. Stock-out cost is given as $100 per unit and overtime cost is given as $50 per unit. Hence, the extra cost for period 5 is $44,000
Calculate the extra cost for Period 6:
It is calculated by adding the product of overtime units and inventory holding overtime cost per unit, and the product of stock-out units and stock-out cost per unit. Stock-out cost is given as $100 per unit and overtime cost is given as $50 per unit. Hence, the extra cost for period 6 is $44,000
Calculate the extra cost for Period 7:
It is calculated by adding the product of overtime units and inventory holding overtime cost per unit, and the product of stock-out units and stock-out cost per unit. Stock-out cost is given as $100 per unit and overtime cost is given as $50 per unit. Hence, the extra cost for period 7 is $10,000
Calculate the extra cost for Period 8:
It is calculated by adding the product of overtime units and inventory holding overtime cost per unit, and the product of stock-out units and stock-out cost per unit. Stock-out cost is given as $100 per unit and overtime cost is given as $50 per unit. Hence, the extra cost for period 8 is $10,000
Calculate the total cost of Plan D:
It is calculated by adding the extra costs of all the periods.
Hence, the total cost for Plan D is $128,000.
b)
To determine: Plan E
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.
b)

Answer to Problem 6P
Plan E has been evaluated. The total cost of Plan E is $140,000.
Explanation of Solution
Given information:
Production for all the months is 1,600 units. Overtime cost is $50 per unit. Maximum allowable inventor in the warehouse is 400 units or less. Demand requirement from period 0 to 8 is as follows:
Period | Expected demand |
0 | 0 |
1 | 1,400 |
2 | 1,600 |
3 | 1,800 |
4 | 1,800 |
5 | 2,200 |
6 | 2,200 |
7 | 1,800 |
8 | 1,800 |
Evaluate the cost of the plan:
Plan E | |||||
Period | Demand | Production | Subcontract (units) | Ending inventory | Extra cost |
0 | 200 | ||||
1 | 1,400 | 1,600 | - | 400 | $8,000 |
2 | 1,600 | 1,600 | - | 400 | $8,000 |
3 | 1,800 | 1,600 | - | 200 | $4,000 |
4 | 1,800 | 1,600 | - | - | $0 |
5 | 2,200 | 1,600 | 600 | - | $45,000 |
6 | 2,200 | 1,600 | 600 | - | $45,000 |
7 | 1,800 | 1,600 | 200 | - | $15,000 |
8 | 1,800 | 1,600 | 200 | - | $15,000 |
Total | 14,600 | 1,600 | 1,000 | $140,000 |
Note: Production is given as 1,600 units. The ending inventory for December is given as 200 units. If the production is more than or equal to the demand, then there would be inventory. If the demand is more, then there would be subcontract.
Calculate the ending inventory or subcontract for Period 1:
It is calculated by adding the production and ending inventory of previous month and subtracting the demand from the result. The ending inventory for Period 1 is 400.
Calculate the ending inventory or subcontract for Period 2:
It is calculated by adding the production and ending inventory of previous month and subtracting the demand from the result. The ending inventory for Period 2 is 400.
Calculate the ending inventory or subcontract for Period 3:
It is calculated by adding the production and ending inventory of previous month and subtracting the demand from the result. The ending inventory for Period 3 is 200.
Calculate the ending inventory or subcontract for Period 4:
It is calculated by adding the production and ending inventory of previous month and subtracting the demand from the result. The ending inventory for Period 4 is 0.
Calculate the ending inventory or subcontract for Period 5:
As the demand is more than the production, there would be a subcontract.
It is calculated by subtracting the production from the demand. Hence, the subcontract units for Period 5 is 600 units.
Calculate the ending inventory or subcontract for Period 6:
As the demand is more than the production, there would be a subcontract.
It is calculated by subtracting the production from the demand. Hence, the subcontract units for Period 6 is 600 units.
Calculate the ending inventory or subcontract for Period 7:
It is calculated by subtracting the production from the demand. The result should then be subtracted from the overtime units. Hence, the subcontract units for Period 7 is 200 units.
Calculate the ending inventory or subcontract for Period 8:
It is calculated by subtracting the production from the demand. The result should then be subtracted from the overtime units. Hence, the subcontract units for Period 8 is 0 units.
Calculate the extra cost for Period 1:
It is calculated by multiplying the extra inventory units and inventory holding cost. Inventory holding cost is given as $20 per unit. Hence, the extra cost for period 1 is $8,000
Calculate the extra cost for Period 2:
It is calculated by multiplying the extra inventory units and inventory holding cost. Inventory holding cost is given as $20 per unit. Hence, the extra cost for period 2 is $8,000
Calculate the extra cost for Period 3:
It is calculated by multiplying the extra inventory units and inventory holding cost. Inventory holding cost is given as $20 per unit. Hence, the extra cost for period 3 is $4,000
Calculate the extra cost for Period 4:
As there are no overtime units, ending inventory units, and subcontract units, there would not be extra costs.
Calculate the extra cost for Period 5:
It is calculated by multiplying the subcontract units and subcontract cost per unit. Subcontract cost is given as $75 per unit. Hence, the extra cost for period 5 is $45,000
Calculate the extra cost for Period 6:
It is calculated by multiplying the subcontract units and subcontract cost per unit. Subcontract cost is given as $75 per unit. Hence, the extra cost for period 6 is $45,000
Calculate the extra cost for Period 7:
It is calculated by multiplying the subcontract units and subcontract cost per unit. Subcontract cost is given as $75 per unit. Hence, the extra cost for period 7 is $15,000
Calculate the extra cost for Period 8:
It is calculated by multiplying the subcontract units and subcontract cost per unit. Subcontract cost is given as $75 per unit. Hence, the extra cost for period 8 is $15,000
Calculate the total cost of Plan E:
It is calculated by adding the extra costs of all the periods.
Hence, the total cost for Plan E is $140,000.
The total cost for Plan D is preferable when compared with Plan E. However, Plan C, with the total cost of $86,000 is preferable over other plans.
Want to see more full solutions like this?
Chapter 13 Solutions
Principles Of Operations Management
- Prepare a graph of the monthly forecasts and average forecast demand for Chicago Paint Corp., a manufacturer of specialized paint for artists. Compute the demand per day for each month (round your responses to one decimal place). Month B Production Days Demand Forecast Demand per Day January 21 950 February 19 1,150 March 21 1,150 April 20 1,250 May 23 1,200 June 22 1,000' July 20 1,350 August 21 1,250 September 21 1,050 October 21 1,050 November 21 December 225 950 19 850arrow_forwardThe president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 2,300 January 1,500 May February 1,700 June 2,100 March April 1,700 1,700 July August 1,900 1,500 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement = units. (Enter your response as a whole number.) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in the table below (enter your responses as whole numbers). Ending E Period…arrow_forwardMention four early warning indicators that a business may be at risk.arrow_forward
- 1. Define risk management and explain its importance in a small business. 2. Describe three types of risks commonly faced by entrepreneurs. 3. Explain the purpose of a risk register. 4. List and briefly describe four risk response strategies. (5 marks) (6 marks) (4 marks) (8 marks) 5. Explain how social media can pose a risk to small businesses. (5 marks) 6. Identify and describe any four hazard-based risks. (8 marks) 7. Mention four early warning indicators that a business may be at risk. (4 marks)arrow_forwardState whether each of the following statements is TRUE or FALSE. 1. Risk management involves identifying, analysing, and mitigating risks. 2. Hazard risks include interest rate fluctuations. 3. Entrepreneurs should avoid all forms of risks. 4. SWOT analysis is a tool for risk identification. 5. Scenario building helps visualise risk responses. 6. Risk appetite defines how much risk an organisation is willing to accept. 7. Diversification is a risk reduction strategy. 8. A risk management framework must align with business goals. 9. Political risk is only relevant in unstable countries. 10. All risks can be eliminated through insurance.arrow_forward9. A hazard-based risk includes A. Political instability B. Ergonomic issues C. Market demand D. Taxation changesarrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,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 Learning
- Foundations of Business (MindTap Course List)MarketingISBN:9781337386920Author:William M. Pride, Robert J. Hughes, Jack R. KapoorPublisher:Cengage Learning


