
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
EBK PRINCIPLES OF OPERATIONS MANAGEMENT
- Currently a company that designs Web sites has five customers in its backlog. The time since the order arrived, processing time, and promised due dates are given in the following table. The customers are ready to be scheduled today, which is the start of day 190. Time Since Order Arrived Customer (days ago) Processing Time (days) Due Date (days from now) A 3 24 58 B 2 32 100 с 10 20 26 D E 8 6 12 28 50 66 a. Develop separate schedules by using the FCFS and EDD rules. Compare the schedules on the basis of average flow time and average days past due. Using the FCFS (first come, first served) decision rule for sequencing the customers, the order is: Sequence Customer 1 2 3 4 5arrow_forwardThe Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in gallons) for the next four quarters are 60,000, 90,000, 90,000, and 140,000 respectively. A level workforce is desired, relying only on anticipation inventory as a supply option. Stockouts and backorders are to be avoided, as are overtime and undertime. a. Determine the quarterly production rate required to meet total demand for the year, and minimize the anticipation inventory that would be left over at the end of the year. Beginning inventory is 0. The quarterly production rate is ☐ gallons. (Enter your response as an integer.)arrow_forwardHow would you design an operations plan and schedule for a new product/service? What factors would you consider and what challenges would you anticipate? Why are these factors and challenges relevant and how would you address them?arrow_forward
- You are the newly appointed CEO of TechSouth, a South African multinational technology company based in Cape Town. TechSouth specialises in manufacturing smartphones, laptops, and smart home devices. The company has a significant presence in the African market and has recently expanded into Europe and Asia. However, TechSouth is facing several critical challenges:· Declining Market Share - Over the past three years, TechSouth has lost considerable market share to both localcompetitors and international giants like Samsung and Apple. The company's products are perceived as outdated and lacking innovation.· Employee Engagement Issues - Recent employee surveys indicate low morale and engagement levels, particularly among the younger workforce, leading to high turnover rates. Many employees feel disconnected from the company's vision and mission.· Siloed Departments - The organizational structure at TechSouth is highly siloed, with departments operatingindependently rather than…arrow_forwardWhat is the best way to manage emotions and thoughts? How to work through Emotions and thoughts?arrow_forwardWhat are the emotions or stressful thoughts? What are the differences between them? How can we work through the emotions or stressful thoughts? How can we avoid or prevent emotions or stressful thoughts from happening or occurring? What are the obstacles?arrow_forward
- Main Challenges at TechInnovateStrategic DirectionTechInnovate's board of directors is pushing for a more aggressive expansion into emerging markets, particularly in Africaand Southeast Asia. However, there's internal disagreement about whether to focus on these new markets or consolidatetheir position in existing ones. Sarah Chen favors rapid expansion, while some senior executives advocate for a morecautious approach.Ethical ConcernsThe company's AI algorithms have come under scrutiny for potential biases, particularly in facial recognition technology.There are concerns that these biases disproportionately affect minority groups. Some employees have voiced ethicalconcerns about selling this technology to law enforcement agencies without addressing these issues.Team Leadership and DiversityTechInnovate's leadership team is predominantly male and Western, despite its global presence. There's growing pressurefrom employees and some board members to diversify the leadership team to…arrow_forwardSarah Anderson, the Marketing Manager at Exeter Township's Cultural Center, is conducting research on the attendance history for cultural events in the area over the past ten years. The following data has been collected on the number of attendees who registered for events at the cultural center. Year Number of Attendees 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 You have been hired as a consultant to assist in implementing a forecasting system that utilizes various forecasting techniques to predict attendance for Year 11. a) Calculate the Three-Period Simple Moving Average b) Calculate the Three-Period Weighted Moving Average (weights: 50%, 30%, and 20%; use 50% for the most recent period, 30% for the next most recent, and 20% for the oldest) c) Apply Exponential Smoothing with the smoothing constant alpha = 0.2. d) Perform a Simple Linear Regression analysis and provide the adjusted…arrow_forwardRuby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 70 units and is valued at $90 per unit. Inbound shipments from vendor 1 will average 390 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 2 weeksweeks. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. Part 2 a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $enter your response here.arrow_forward
- Sam's Pet Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: > Demand 75 bags/week > Order cost = $52.00/order > Annual holding cost = 20 percent of cost > Desired cycle-service level = 80 percent >Lead time = 5 weeks (30 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)arrow_forwardYellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 2,250 rolls. The cost per roll is $625, and the annual holding cost is 20 percent of the cost. Each order costs $75. a. How many rolls should Yellow Press order at a time? Yellow Press should order rolls at a time. (Enter your response rounded to the nearest whole number.)arrow_forwardPlease help with only the one I circled! I solved the others :)arrow_forward
- MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPractical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Purchasing 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


