Concept explainers
Dwayne Cole, owner of a Florida firm that manufactures display cabinets, develops an 8-month aggregate plan. Demand and capacity (in units) are
The cost of producing each unit is $1,000 on regular time, $1,300 on overtime, and $1,800 on a subcontract. Inventory carrying cost is $200 per unit per month. There is no beginning or ending inventory in stock, and no backorders are permitted from period to period.
Let the production (workforce) vary by using regular time first, then overtime, and then subcontracting.
a) Set up a production plan that minimizes cost by producing exactly what the demand is each month. This plan allows no backorders or inventory. What is this plan’s cost?
b) Through better planning, regular time production can be set at exactly the same amount, 275 units, per month. If demand cannot be met there is no cost assigned to shortages and they will not be filled. Does this alter the solution?
c) If overtime costs per unit rise from $1,300 to $1,400, will your answer to (a) change? What if overtime costs then fall to $1,200?
a)
To determine: The total cost of the plan.
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 19P
The total cost of the plan is $2,608,300.
Explanation of Solution
Given information:
Regular time cost per unit is given as $1,000, overtime cost is $1,300, and subcontract cost is $1,800 per unit. The capacity and demand are given as follows:
Month | Demand | Regular time capacity | Overtime capacity | Subcontract capacity |
Initial | 0 | 0 | 0 | 0 |
January | 255 | 235 | 20 | 12 |
February | 294 | 255 | 24 | 16 |
March | 321 | 290 | 26 | 15 |
April | 301 | 300 | 24 | 17 |
May | 330 | 300 | 30 | 17 |
June | 320 | 290 | 28 | 19 |
July | 345 | 300 | 30 | 19 |
August | 340 | 290 | 30 | 20 |
Calculate the total cost:
Table 1
Working note:
Demand, regular time capacity, overtime capacity, and subcontract capacity are given.
Determine regular time, overtime, and subcontract units for the month of January:
It is given that the demand for the month of January is 255 units. 235 units would be produced in the regular time (as the regular time capacity is 235). Remaining 20 units would be produced in the overtime (as the overtime capacity is 20). Hence, regular time unit is 235 units and overtime unit is 20 units.
Determine regular time, overtime, and subcontract units for the month of February:
It is given that the demand for the month of February is 294 units. 255 units would be produced in the regular time (as the regular time capacity is 255). From the remaining 39 units, 24 units would be produced in the overtime (as the overtime capacity is 24) and 15 units would be produced using subcontract (as the subcontract capacity is 16). Hence, regular time unit is 255 units, overtime unit is 24 units, and subcontract unit is 15 units.
Determine regular time, overtime, and subcontract units for the month of March:
It is given that the demand for the month of March is 321 units. 290 units would be produced in the regular time (as the regular time capacity is 290). From the remaining 31 units, 26 units would be produced in the overtime (as the overtime capacity is 26) and 5 units would be produced using subcontract (as the subcontract capacity is 15). Hence, regular time unit is 290 units, overtime unit is 26 units, and subcontract unit is 5 units.
Note: The procedure continues for all months.
Increase or decrease for the month of January:
There would be no increase or decrease for the month of January as there is no period compare.
Increase or decrease for the month of February:
Production in the month of January is 235 units and production in the month of February is 255 units. There is an increase of 20 units. Hence, there would be 20 units increase in February.
Increase or decrease for the month of March:
Production in the month of February is 255 units and production in the month of March is 290 units. There is an increase of 35 units. Hence, there would be 35 units increase in March.
Increase or decrease for the month of April:
Production in the month of March is 290 units and production in the month of April is 300 units. There is an increase of 10 units. Hence, there would be 10 units increase in April.
Increase or decrease for the month of May:
Production in the month of April is 300 units and production in the month of May is 300 units. As there is no change in the production units, there would not be any increase or decrease.
Increase or decrease for the month of June:
Production in the month of May is 300 units and production in the month of June is 290 units. There is a decrease of 10 units. Hence, there would be 10 units decrease in June.
Increase or decrease for the month of July:
Production in the month of June is 290 units and production in the month of July is 300 units. There is an increase of 10 units. Hence, there would be 10 units increase in July.
Increase or decrease for the month of August:
Production in the month of July is 300 units and production in the month of August is 290 units. There is a decrease of 10 units. Hence, there would be 10 units decrease in August.
Summary of the table:
Type | Units | Cost |
Regular time | 2,260 | $2,260,000 |
Overtime | 189 | $245,700 |
Subcontract | 57 | $102,600 |
Holding | 0 | 0 |
Shortage | 0 | 0 |
Increase | 75 | 0 |
Decrease | 20 | 0 |
$2,608,300 |
Table 2
Working note:
Total units of regular time, overtime, subcontract, shortage, holding, increase, and decrease were calculated in theTable 1.
Calculate the regular time cost:
Regular time cost is calculated by multiplying regular time unit and the given regular time cost per unit. Hence, the regular time cost is $2,260,000.
Calculate the overtime cost:
Overtime cost is calculated by multiplying overtime unit and the given overtime cost per unit. Hence, the overtime cost is $245,700.
Calculate the subcontract cost:
Subcontract cost is calculated by multiplying subcontract unit and the given subcontract cost per unit. Hence, the subcontract cost is $102,600.
Calculate the increase and decrease cost:
As there is no increase or decrease cost per unit, it would remain 0.
Calculate the total cost:
Total cost is calculated by adding regular time cost, overtime cost, subcontract cost, holding cost, shortage cost, increase cost, and decrease cost.
Hence, the total cost of the plan is $2,608,300.
b)
To determine: The total cost of the plan.
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 19P
The total cost of the plan is $2,585,100.
Explanation of Solution
Given information:
Regular time cost per unit is given as $1,000, overtime cost is $1,300, and subcontract cost is $1,800 per unit. The capacity and demand are given as follows:
Month | Demand | Regular time capacity | Overtime capacity | Subcontract capacity |
Initial | 0 | 0 | 0 | 0 |
January | 255 | 275 | 20 | 12 |
February | 294 | 275 | 24 | 16 |
March | 321 | 275 | 26 | 15 |
April | 301 | 275 | 24 | 17 |
May | 330 | 275 | 30 | 17 |
June | 320 | 275 | 28 | 19 |
July | 345 | 275 | 30 | 19 |
August | 340 | 275 | 30 | 20 |
Calculate the total cost:
Table 3
Working note:
Demand, regular time capacity, overtime capacity, and subcontract capacity are given.
Determine regular time, overtime, and subcontract units for the month of January:
It is given that the demand for the month of January is 255 units. Whole 255 units would be produced in the regular time (as the regular time capacity is 275). Hence, regular time unit is 255 units.
Determine regular time, overtime, and subcontract units for the month of February:
It is given that the demand for the month of February is 294 units. 275 units would be produced in the regular time (as the regular time capacity is 275). Remaining 19 units would be produced in the overtime (as the overtime capacity is 24). Hence, regular time unit is 275 units and overtime unit is 19 units.
Determine regular time, overtime, and subcontract units for the month of March:
It is given that the demand for the month of March is 321 units. 275 units would be produced in the regular time (as the regular time capacity is 290). From the remaining 46 units, 26 units would be produced in the overtime (as the overtime capacity is 26) and 15 units would be produced using subcontract (as the subcontract capacity is 15). Hence, regular time unit is 275 units, overtime unit is 26 units, and subcontract unit is 15 units. Remaining 5 units is a shortage.
Note: The procedure continues for all months.
Increase or decrease for the month of January:
There would be no increase or decrease for the month of January as there is no period compare.
Increase or decrease for the month of February:
Production in the month of January is 255 units and production in the month of February is 275 units. There is an increase of 20 units. Hence, there would be 20 units increase in February.
Increase or decrease from the month of March to August:
As the production for regular time remains the same, there would be no increase or decrease from the month of March to August.
Summary of the table:
Type | Units | Cost |
Regular time | 2,180 | $2,180,000 |
Overtime | 187 | $243,100 |
Subcontract | 90 | $162,000 |
Holding | 0 | 0 |
Shortage | 49 | 0 |
Increase | 20 | 0 |
Decrease | 0 | |
$2,585,100 |
Table 4
Working note:
Total units of regular time, overtime, subcontract, shortage, holding, increase, and decrease were calculated in theTable 3.
Calculate the regular time cost:
Regular time cost is calculated by multiplying regular time unit and the given regular time cost per unit. Hence, the regular time cost is $2,180,000.
Calculate the overtime cost:
Overtime cost is calculated by multiplying overtime unit and the given overtime cost per unit. Hence, the overtime cost is $243,100.
Calculate the subcontract cost:
Subcontract cost is calculated by multiplying subcontract unit and the given subcontract cost per unit. Hence, the subcontract cost is $162,000.
Calculate the increase and decrease cost:
As there is no increase or decrease cost per unit, it would remain 0.
Calculate the total cost:
Total cost is calculated by adding regular time cost, overtime cost, subcontract cost, holding cost, shortage cost, increase cost, and decrease cost.
Hence, the total cost of the plan is $2,585,100.
c)
To determine: The total cost of the plan, if the overtime increased to $1,400.
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 19P
The total cost of the plan is $2,627,200.
Explanation of Solution
Given information:
Regular time cost per unit is given as $1,000, overtime cost is $1,400, and subcontract cost is $1,800 per unit. The capacity and demand are given as follows:
Month | Demand | Regular time capacity | Overtime capacity | Subcontract capacity |
Initial | 0 | 0 | 0 | 0 |
January | 255 | 235 | 20 | 12 |
February | 294 | 255 | 24 | 16 |
March | 321 | 290 | 26 | 15 |
April | 301 | 300 | 24 | 17 |
May | 330 | 300 | 30 | 17 |
June | 320 | 290 | 28 | 19 |
July | 345 | 300 | 30 | 19 |
August | 340 | 290 | 30 | 20 |
Calculate the total cost:
Table 5
Working note:
Demand, regular time capacity, overtime capacity, and subcontract capacity are given.
Determine regular time, overtime, and subcontract units for the month of January:
It is given that the demand for the month of January is 255 units. 235 units would be produced in the regular time (as the regular time capacity is 235). Remaining 20 units would be produced in the overtime (as the overtime capacity is 20). Hence, regular time unit is 235 units and overtime unit is 20 units.
Determine regular time, overtime, and subcontract units for the month of February:
It is given that the demand for the month of February is 294 units. 255 units would be produced in the regular time (as the regular time capacity is 255). From the remaining 39 units, 24 units would be produced in the overtime (as the overtime capacity is 24) and 15 units would be produced using subcontract (as the subcontract capacity is 16). Hence, regular time unit is 255 units, overtime unit is 24 units, and subcontract unit is 15 units.
Determine regular time, overtime, and subcontract units for the month of March:
It is given that the demand for the month of March is 321 units. 290 units would be produced in the regular time (as the regular time capacity is 290). From the remaining 31 units, 26 units would be produced in the overtime (as the overtime capacity is 26) and 5 units would be produced using subcontract (as the subcontract capacity is 15). Hence, regular time unit is 290 units, overtime unit is 26 units, and subcontract unit is 5 units.
Note: The procedure continues for all months.
Increase or decrease for the month of January:
There would be no increase or decrease for the month of January as there is no period compare.
Increase or decrease for the month of February:
Production in the month of January is 235 units and production in the month of February is 255 units. There is an increase of 20 units. Hence, there would be 20 units increase in February.
Increase or decrease for the month of March:
Production in the month of February is 255 units and production in the month of March is 290 units. There is an increase of 35 units. Hence, there would be 35 units increase in March.
Increase or decrease for the month of April:
Production in the month of March is 290 units and production in the month of April is 300 units. There is an increase of 10 units. Hence, there would be 10 units increase in April.
Increase or decrease for the month of May:
Production in the month of April is 300 units and production in the month of May is 300 units. As there is no change in the production units, there would not be any increase or decrease.
Increase or decrease for the month of June:
Production in the month of May is 300 units and production in the month of June is 290 units. There is a decrease of 10 units. Hence, there would be 10 units decrease in June.
Increase or decrease for the month of July:
Production in the month of June is 290 units and production in the month of July is 300 units. There is an increase of 10 units. Hence, there would be 10 units increase in July.
Increase or decrease for the month of August:
Production in the month of July is 300 units and production in the month of August is 290 units. There is a decrease of 10 units. Hence, there would be 10 units decrease in August.
Calculate the total cost if the overtime cost per unit increased to $1,400:
Type | Units | Cost |
Regular time | 2,260 | $2,260,000 |
Overtime | 189 | $264,600 |
Subcontract | 57 | $102,600 |
Holding | 0 | 0 |
Shortage | 0 | 0 |
Increase | 75 | 0 |
Decrease | 20 | 0 |
$2,627,200 |
Table 6
Working note:
Total units of regular time, overtime, subcontract, shortage, holding, increase, and decrease were calculated in theTable 5.
Calculate the regular time cost:
Regular time cost is calculated by multiplying regular time unit and the given regular time cost per unit. Hence, the regular time cost is $2,260,000.
Calculate the overtime cost:
Overtime cost is calculated by multiplying overtime unit and the given overtime cost per unit. Hence, the overtime cost is $264,600.
Calculate the subcontract cost:
Subcontract cost is calculated by multiplying subcontract unit and the given subcontract cost per unit. Hence, the subcontract cost is $102,600.
Calculate the increase and decrease cost:
As there is no increase or decrease cost per unit, it would remain 0.
Calculate the total cost:
Total cost is calculated by adding regular time cost, overtime cost, subcontract cost, holding cost, shortage cost, increase cost, and decrease cost.
Hence, the total cost of the plan is $2,627,200.
Calculate the total cost if the overtime cost per unit increased to $1,200:
Type | Units | Cost |
Regular time | 2,260 | $2,260,000 |
Overtime | 189 | $226,800 |
Subcontract | 57 | $102,600 |
Holding | 0 | 0 |
Shortage | 0 | 0 |
Increase | 75 | 0 |
Decrease | 20 | 0 |
$2,589,400 |
Table 7
Working note:
Total units of regular time, overtime, subcontract, shortage, holding, increase, and decrease were calculated in theTable 6.
Calculate the regular time cost:
Regular time cost is calculated by multiplying regular time unit and the given regular time cost per unit. Hence, the regular time cost is $2,260,000.
Calculate the overtime cost:
Overtime cost is calculated by multiplying overtime unit and the given overtime cost per unit. Hence, the overtime cost is $264,600.
Calculate the subcontract cost:
Subcontract cost is calculated by multiplying subcontract unit and the given subcontract cost per unit. Hence, the subcontract cost is $102,600.
Calculate the increase and decrease cost:
As there is no increase or decrease cost per unit, it would remain 0.
Calculate the total cost:
Total cost is calculated by adding regular time cost, overtime cost, subcontract cost, holding cost, shortage cost, increase cost, and decrease cost.
Hence, the total cost of the plan is $2,589,400.
Want to see more full solutions like this?
Chapter 13 Solutions
Principles Of Operations Management
- Jerusalem Medical Ltd., an Israeli producer of portable kidney dialysis units and other medical products, develops a 4-month aggregate plan. Demand and capacity (in units) are forecast as follows: Capacity Source Month 1 Month 2 Month 3 Month 4 Labor Regular time 245 265 280 300 Overtime 15 24 26 22 Subcontract 14 17 20 15 Demand 260 306 316 305 The cost of producing each dialysis unit is $875 on regular time, $1,310 on overtime, and $1,500 on a subcontract. Inventory carrying cost is $100 per unit per month. There is to be no beginning or ending inventory in stock and backorders are not permitted. Minimizing cost using the transportation method, the optimal cost is $nothing (enter your response as a whole number).arrow_forwardJerusalem Medical Ltd., an Israeli producer of portable kidney dialysis units and other medical products, develops a 4-month aggregate plan. Demand and capacity (in units) are forecast as follows: Capacity Source Month 1 Month 2 Month 3 Month 4 Labor Regular time 245 265 300 300 Overtime 15 24 26 22 Subcontract 14 15 13 15 Demand 260 304 331 305 The cost of producing each dialysis unit is $875 on regular time, $1310 on overtime, and $1500 on a subcontract. Inventory carrying cost is $100 per unit per month. There is to be no beginning or ending inventory in stock and backorders are not permitted. Minimizing cost using the transportation method, the optimal cost is ???$ (enter your response as a whole number).arrow_forwardHow is it possible for you to solve the Aggregate Planning problem?arrow_forward
- . Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must developan aggregate plan given the forecast for engine demand shown in the table. The department has aregular output capacity of 130 engines per month. Regular output has a cost of $60 per engine. Thebeginning inventory is zero engines. Overtime has a cost of $90 per engine.a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regularproduction can be less than regular capacity. b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carryingcost is $2 per engine per month. Backlog cost is $90 per engine per month. There should not bea backlog in the last month.MONTH1 2 3 4 5 6 7 8 TotalForecast 120 135 140 120 125 125 140 135 1,040arrow_forwardList the capacity options and demand options of aggregate planning and explain the difference between them. Which strategy or model always gives the aggregate plan with the minimum total cost?arrow_forwardSpectrum Hair Salon is considering expanding itsbusiness, as it is experiencing a large growth. Th e question iswhether it should expand with a bigger facility than needed,hoping that demand will catch up, or with a small facility,knowing that it will need to reconsider expanding in three years.Th e management at Spectrum has estimated the followingchances for demand:• Th e likelihood of demand being high is 0.70.• Th e likelihood of demand being low is 0.30.Estimated profi ts for each alternative are as follows:• Large expansion has an estimated profi tability of either$100,000 or $70,000, depending on whether demand turnsout to be high or low.• Small expansion has a profi tability of $50,000, assuming thatdemand is low.• Small expansion with an occurrence of high demand wouldrequire considering whether to expand further. If thebusiness expands at this point, the profi tability is expected tobe $90,000. If it does not expand further, the profi tability isexpected to be $60,000.Draw a…arrow_forward
- Spectrum Hair Salon is considering expanding itsbusiness, as it is experiencing a large growth. Th e question iswhether it should expand with a bigger facility than needed,hoping that demand will catch up, or with a small facility,knowing that it will need to reconsider expanding in three years.Th e management at Spectrum has estimated the followingchances for demand:• Th e likelihood of demand being high is 0.70.• Th e likelihood of demand being low is 0.30.Estimated profi ts for each alternative are as follows:• Large expansion has an estimated profi tability of either$100,000 or $70,000, depending on whether demand turnsout to be high or low.• Small expansion has a profi tability of $50,000, assuming thatdemand is low.• Small expansion with an occurrence of high demand wouldrequire considering whether to expand further. If thebusiness expands at this point, the profi tability is expected tobe $90,000. If it does not expand further, the profi tability isexpected to be $60,000.arrow_forward3) Gang Aft Agley, a manufacturing company, faces the aggregate planning problem shown in the table below. Cost of regular production is $5 per unit, the cost of producing the same unit on overtime is $7, the cost of subcontracting is $8 per unit, and the cost of carrying a unit in inventory from one month to the next is $2. January February March April May Forecast 500 750 1200 650 300 Beginning Inventory 100 Regular Time Overtime Subcontracting Ending Inventory The labor contract at the plant prohibits both overtime and subcontracting output to exceed 300 units in any five month window. The plant capacity is 500 units per month produced using two shifts, regardless of the number of days in a month. By policy, management wants to avoid stockouts. Formulate the aggregate plan using linear programming and solve it using Solver.arrow_forwardProblem 11-11 (Static) A manager is attempting to put together an aggregate plan for the coming nine months. She has obtained a forecast of expected demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in periods 3 and 4, and again in period 8, as can be seen from the following forecasts. Period 1 2 3 4 5 6 7 8 9 Total Forecast 190 230 260 280 210 170 160 260 180 1,940 The department now has 20 full-time employees, each of whom produces 10 units of output per period at a cost of $6 per unit. Beginning inventory for period 1 is zero. Inventory carrying cost is $5 per unit per period, and backlog cost is $10 per unit per period. The manager has decided to use part-time workers to assist during seasonal peaks. The cost per unit, including hiring and training, is $11. The output rate is 10 units per worker per period for all workers. A maximum of 10 part-time workers can be used, and the same number of part-time workers…arrow_forward
- Mick Karra is the manager of MCZ Drilling products which produces a variety of especially valves for oil field equipment. Recent activity in the oil fields has cause demand to increase drastically, and a decision has been made to open a new manufacturing facility. Three locations are being considered, and the size of the facility would not be the same in each location Thus, overtime might be necessary at times. The folowing table gives the total monthly cost (in 1000s) for each possible location under each demand posibility. The probabilities for the demand levels have been determined to be 20% for low demand, 30% for medium demand, and 50% for high demand Demand is Low Demand is medium Demand is High Ardmore, OK 85 110 150 Sweetwater, TX 90 100 120 Lake Charles, LA 110 120 130 (a) Which location would be selected based on the optimistic criterion? (b) which location would be selected based on the pessimistic criterion? (c) which location would be selected based on the…arrow_forward3. What information is necessary for an operations manager to create the aggregate plan? List the capacity options and demand options of aggregate planning and explain the difference between them. Which strategy or model always gives the aggregate plan with the minimum total cost?arrow_forwardThe successful cat food company "El gato gordo" supplies food to most of the wholesale veterinary stores in the country. Currently, they are working on the production planning for October 2020, to be delivered at the end of that month. Based on historical information from past years, they have concluded that a production of 11,500 bags will be sufficient to meet their demands. For the month of October, the company will work 22 days, Monday through Friday, in two shifts: 7 a.m. to 4 p.m., and 4 p.m. to 12 a.m., considering one hour of lunch in each shift. Determine the takt time in terms of production per hour and per minute.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.