Concept explainers
a)
To evaluate: Plan C for the given information
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 10P
The Plan C has been evaluated. The total cost of Plan C is $104,000.
Explanation of Solution
Given information:
Production for all the months is 1,300 units. Ending inventory in June is 300 units. Overtime cost is $50 per unit. Demand requirement from July to December is given as follows:
Period | Demand | Production (units) |
June | ||
July | 1,000 | 1,300 |
August | 1,200 | 1,300 |
September | 1,400 | 1,300 |
October | 1,800 | 1,300 |
November | 1,800 | 1,300 |
December | 1,800 | 1,300 |
Evaluate the cost of the plan:
Plan C | |||||
Period | Demand | Production (units) | Subcontract (units) | Ending inventory | Extra cost |
June | 300 | ||||
July | 1,000 | 1,300 | 600 | $15,000 | |
August | 1,200 | 1,300 | 700 | $17,500 | |
September | 1,400 | 1,300 | 600 | $15,000 | |
October | 1,800 | 1,300 | 100 | $2,500 | |
November | 1,800 | 1,300 | 400 | 0 | $24,000 |
December | 1,800 | 1,300 | 500 | 0 | $30,000 |
Total | $104,000 |
Note: Production is given as 1,300 units. Ending inventory for June is given as 300 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.
Calculate ending inventory or subcontract for July:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Ending inventory for July is 600.
Calculate ending inventory or subcontract for August:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Ending inventory for August is 700.
Calculate ending inventory or subcontract for September:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Ending inventory for September is 600.
Even though the demand is high, as there is enough ending inventory in previous month, there would be inventory rather than subcontract.
Calculate the ending inventory or subcontract for October:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Ending inventory for October is 100.
Even though the demand is high, as there is enough ending inventory in previous month, there would be inventory rather than subcontract.
Calculate ending inventory or subcontract for November:
As the demand is more than the production and there is no enough ending inventory, there would be subcontract.
It is calculated by adding production and ending inventory and the result should be subtracted with the demand. Hence, the subcontract units for November is 400 units.
As the value is in negative, it would be subcontract.
Calculate ending inventory or subcontract for December:
As the demand is more than the production and there is no enough ending inventory, there would be subcontract.
It is calculated by adding production and ending inventory and the result should be subtracted with the demand. Hence, the subcontract units for December is 500 units.
As the value is in negative, it would be subcontract.
Calculate extra cost for July:
It is calculated by multiplying ending inventory units and inventory holding cost. Inventory holding cost is given as $25 per unit. Hence, extra cost for July is $15,000
Calculate extra cost for August:
It is calculated by multiplying ending inventory units and inventory holding cost. Inventory holding cost is given as $25 per unit. Hence, extra cost for August is $17,500
Calculate extra cost for September:
It is calculated by multiplying ending inventory units and inventory holding cost. Inventory holding cost is given as $25 per unit. Hence, extra cost for September is $15,000
Calculate extra cost for October:
It is calculated by multiplying ending inventory units and inventory holding cost. Inventory holding cost is given as $25 per unit. Hence, extra cost for October is $2,500
Calculate extra cost for November:
It is calculated by multiplying ending inventory units and inventory holding cost. Inventory holding cost is given as $60 per unit. Hence, extra cost for November is $24,000
Calculate extra cost for December:
It is calculated by multiplying ending inventory units and inventory holding cost. Inventory holding cost is given as $60 per unit. Hence, extra cost for December is $30,000
Calculate total cost of Plan C:
It is calculated by adding the extra costs of all the periods.
Hence, the total cost for Plan C is $104,000.
b)
To determine: Evaluate plan D for the given information
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 10P
The Plan D has been evaluated. The total cost of Plan D is $93,800.
Explanation of Solution
Given information:
Production for all the months is 1,300 units. Ending inventory in June is 300 units. Overtime cost is $50 per unit. Demand requirement from July to December is given as follows:
Period | Demand | Production (units) |
June | ||
July | 1,000 | 1,300 |
August | 1,200 | 1,300 |
September | 1,400 | 1,300 |
October | 1,800 | 1,300 |
November | 1,800 | 1,300 |
December | 1,800 | 1,300 |
Evaluate the cost of the plan:
Plan D | |||||||
Period | Demand | Regular production (units) | Overtime production (units) | Ending inventory | Sub-contract (units) | Idle time (units) | Extra cost |
June | |||||||
July | 1,000 | 1,300 | 180 | 120 | $11,700 | ||
August | 1,200 | 1,300 | 180 | 100 | $10,500 | ||
September | 1,400 | 1,300 | 80 | $2,000 | |||
October | 1,800 | 1,300 | 260 | 0 | 160 | $20,000 | |
November | 1,800 | 1,300 | 260 | 0 | 240 | $24,800 | |
December | 1,800 | 1,300 | 260 | 0 | 240 | $24,800 | |
Total | $93,800 |
Note: Production is given as 1,300 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 260 units (20% of production)
Calculate ending inventory or subcontract for July:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Ending inventory for July is 180.
It is given that the ending inventory should not exceed 180 units. Hence, the ending inventory would be 180 units and remaining units of 300 (120 units) would be in idle time.
Calculate ending inventory or subcontract for August:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Ending inventory for August is 180.
It is given that the ending inventory should not exceed 180 units. Hence, the ending inventory would be 180 units and remaining units of 280 (100 units) would be in idle time.
Calculate ending inventory or subcontract for September:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Ending inventory for September is 80.
Calculate the ending inventory or subcontract for October:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Subcontract for October is 160.
As the value is in negative, it would be subcontract. Overtime production should not exceed 260 units. Hence, 260 units would be production in overtime production and 160 units (remaining from 420) would be produced in subcontract.
Calculate the ending inventory or subcontract for November:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Subcontract for November is 240.
As the value is in negative, it would be subcontract. Overtime production should not exceed 260 units. Hence, 260 units would be production in overtime production and 240 units (remaining from 500) would be produced in subcontract.
Calculate the ending inventory or subcontract for December:
It is calculated by adding the production and ending inventory of previous month and subtract the result from the demand. Subcontract for December is 240.
As the value is in negative, it would be subcontract. Overtime production should not exceed 260 units. Hence, 260 units would be production in overtime production and 240 units (remaining from 500) would be produced in subcontract.
Calculate extra cost for July:
It is calculated by adding the multiple of ending inventory units and inventory holding cost and the multiple of idle time and idle time cost. Inventory holding cost is given as $25 per unit and idle time per unit is $60. Hence, extra cost for July is $11,700.
Calculate extra cost for August:
It is calculated by adding the multiple of ending inventory units and inventory holding cost and the multiple of idle time and idle time cost. Inventory holding cost is given as $25 per unit and idle time per unit is $60. Hence, extra cost for August is $10,500.
Calculate extra cost for September:
It is calculated by adding the multiple of ending inventory units and inventory holding cost and the multiple of idle time and idle time cost. Inventory holding cost is given as $25 per unit and idle time per unit is $60. Hence, extra cost for September is $2,000.
Calculate extra cost for October:
It is calculated by adding the multiple of overtime units and overtime cost per unit and subcontract units and subcontract cost per unit. Overtime cost per unit is $40 per unit and subcontract cost is $60 per unit. Hence, extra cost for October is $20,000.
Calculate extra cost for November:
It is calculated by adding the multiple of overtime units and overtime cost per unit and subcontract units and subcontract cost per unit. Overtime cost per unit is $40 per unit and subcontract cost is $60 per unit. Hence, extra cost for November is $24,800.
Calculate extra cost for December:
It is calculated by adding the multiple of overtime units and overtime cost per unit and subcontract units and subcontract cost per unit. Overtime cost per unit is $40 per unit and subcontract cost is $60 per unit. Hence, extra cost for December is $24,800.
Calculate 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 $93,800.
Total cost for Plan D is preferable when compare with Plan C. However, Plan D with the total cost of $93,800 is preferable than other plans.
Want to see more full solutions like this?
Chapter 13 Solutions
Principles Of Operations Management
- Develop a chase aggregate plan for Draper using apermanent workforce of 12 employees supplemented by overtime.All demand must be met each period.(a) Show what would happen if this plan were implemented.(b) Calculate the costs associated with this plan.(c) Evaluate the plan in terms of cost, customer service,operations, and human resources.arrow_forwardGiven the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time and overtime, and backorders. The plan must wind up with no units in ending inventory in Period 6. Regular time capacity is 160 units per month. There are 10 units backlogged from before. Overtime cost is $30 per unit, backorder cost is $20 per unit, inventory holding cost is $5 per unit, regular time cost of $20 per unit, and beginning inventory is zero. Month Forecast 1 180 2 170 3 140 4 150 5 130 6 150 a. Prepare an aggregate plan with inventory and backlog allowed. Overtime and subcontracting are not allowed.b. Prepare an aggregate plan if the management decided to switch to…arrow_forwardSoutheast Soda Pop, Inc., has a new fruit drink forwhich it has high hopes. John Mitten thai, the production planner,has assembled the fo llowing cost data and demand forecast: John's job is to develop an aggregate plan. The three initialoptions he wants to evaluate are:• Plan A: a strategy that hires and fires personnel as necessaryto meet the forecast.• Plan B: a level strategy.• Plan C: a level strategy that produces 1,200 cases per quarterand meets the fo recast demand with inventory and subcontracting.a) Which strategy is the lowest-cost plan?b) If you are John's boss, the VP for operations, which p lan doyou implement and why?arrow_forward
- Mavis and John have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. John has years of food processing experience, and Mavis has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. John and Mavis has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above scenario: Should…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_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.arrow_forward
- Jose 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_forwardA. When the required labor skill is high, it is generally best to pursue which aggregate planning strategy? a. Hybrid - combination of level and chase b. Chase c. Level d. Low job discretion B. If labor turnover is high, it is generally best to pursue which aggregate planning strategy? a. Chase b. Low job discretion c. Hybrid - combination of level and chase d. Levelarrow_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_forward
- How does aggregate planning in service differ fromaggregate planning in manufacturing?arrow_forwardWhat are major limitations of using the tra nspo rtation method for aggregate planning?arrow_forwardFrom Chapter 13: Aggregate Plan Q2) Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 1500 units 1 1400 Beginning inventory 200 units 2 1000 Stockout cost $50 per unit 3 1500 Inventory holding cost $8 per unit at end of quarter 4 1300 Hiring workers $5 per unit Laying off workers $10 per unit Unit cost $30 per unit Overtime $10 extra per unit Which of the following production plans is better: Plan A—chase demand by hiring and layoffs; or Plan B—produce at a constant rate of 1200 and obtain the remainder from overtime? Finish the calculation. Plan A: Eagle Fabrication Solution Demand Regular Time Capacity Regular Time Production Hire Fire Initial Inventory Period 1 1,400 1200 Period 2 1,000…arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing