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
Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+)
- answer needed with step by step explanarrow_forwardPlease assist with the following questionsarrow_forwardThe planner at a company that makes garden tractors is about to prepare an aggregate production plan that will cover the next 6 months. She has collected the following information: Month Demand Forecast Above the available capacity through permanent workforce 1 1,000 2 1,000 3 2,000 4 3,000 5 4,000 6 1,000 Total: 12,000 Production per month = 20 units per worker Initial inventory = 500 units Desired ending inventory (at the end of month 6) = 0 units Cost: Hire cost = $500 per temporary worker Inventory = $10 per tractor per month Backorder = $150 per tractor per month The optimum aggregate plan is: Month 1 2 3 4 5 6 Total Forecast Demand above regular capacity 1,000 1,000 2,000 3,000 4,000 1,000 12,000 # of temporary workers required 50 50 100 150 200 50 Temp. Workers hired 25 25 50 75 0 0 Temp. workers laid off 0…arrow_forward
- 10:44 O 3 all 29% د. اسماء الرحبي ي 18 April, 10:44 am Level Capacity Production Plan Problem o Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a steady regular output capacity of 130 engines per month. Regular output has a cost of $60 per engine. The beginning inventory is zero engines. Overtime has a cost of $90 per engine. o Develop a Level capacity plan and compute the total cost of Ending Inventory. MONTH 1 4 8 Forecast 120 135 140 120 125 125 140 135arrow_forwardProblem #2- Brown Manufacturing-Modified, from textbook page #198 If the annual demand is reduced to 8,000 units, the set-up costs increased to $120, inventory carrying cost increased to $0.60 per unit per year and the demand during the production period is maintained at 60 units per day and 80 units can be manufactured daily, calculate а. The optimum production quantity (Q*) per production run (or per production lot). b. ( ne length of each production run. с. ( The number of production runs per year. Page 2 of 4 Scanned with CamScannerarrow_forwardHill’s operations manager (see Problems 13.3 through13.5) is also considering two mixed strategies for January–August: Produce in overtime or subcontracting only when there isno inventory.◆ Plan D: Keep the current workforce stable at producing1,600 units per month. Permit a maximum of 20% overtime atan additional cost of $50 per unit. A warehouse now constrainsthe maximum allowable inventory on hand to 400 units or less.◆ Plan E: Keep the current workforce, which is producing 1,600units per month, and subcontract to meet the rest of the demand.Evaluate plans D and E and make a recommendation.arrow_forward
- Can you assist me with Question 11.11 Thank you kindlyarrow_forwardConsuelo Chua, Inc., is a Columbian disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the following data. There are 8 hours of production per day. Holding cost Subcontracting Regular-time labor Overtime labor Hiring cost Layoff cost Costs $8/disk drive/Month $80/disk drive Month $12/hour $18/hour (above 8 hours) $40/worker $80/worker 0 June 1 July 2 August 3 September 4 October 5 November 6 Doramhar What will each of the two following strategies cost? a) Vary the workforce so that production approximates demand. Chua had eight workers on board in June. (Enter all responses as whole numbers). Demand* Fill in the table below. (Enter all responses as whole numbers. In the hire/layoff column, use positive numbers for hires-plus signs omitted; negative numbers for layoffs.) 400 500 550 700 800 700 Current workforce (June) Labor-hours/disk drive Workdays/month Beginning Inventory 150 Other Data 20 days Beginning Inventory 150 disk…arrow_forwardAfter researching revenue (yield) management in airlines,describe how the Magic system differs from that of Americanor other airline carriers.arrow_forward
- Southeastern Oklahoma State University's businessprogram has the facilities and faculty to handle an enrollmentof 2,000 new students per semester. However, in an effortto limit class sizes to a "reasonable" level (under 200, generally),Southeastern's dean, Holly Lutze, placed a ceiling on enrollmentof I ,500 new students. Although there was ample demand forbusiness courses last semester, conflicting schedules allowed onlyI ,450 new students to take business courses. What are the utilizationand efficiency of this system?arrow_forwardWhat are demand forecasting and capacity strategy? Give an example of demand forecasting for a business.arrow_forwardJose Martinez of El Paso had developed a polished stainless-steel tortilla machine that makes it a “showpiece” for display in Mexican restaurants. He needs to develop a 5-month aggregate plan. His forecast of capacity and demand follows: Month 1 2 3 4 5 Demand 150 160 130 200 210 Regular capacity 150 150 150 150 150 Overtime capacity 20 20 10 10 10 Subcontracting: 100 units available over the 5-month period (NOT 100 units each month) Beginning inventory: 0 units Ending inventory required at the last month (i.e. month 5): 20 units. Costs Regular-time cost per unit $100 Overtime cost per unit $125 Subcontracting cost per unit $135 Inventory holding cost per unit per month $3 Assume that backorders are not permitted. a) Find an aggregate production plan using the intuitive lowest cost approach. (i.e. Develop an aggregate plan using the transportation method). b) State the corresponding…arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.