EBK PRINCIPLES OF OPERATIONS MANAGEMENT
EBK PRINCIPLES OF OPERATIONS MANAGEMENT
11th Edition
ISBN: 9780135175859
Author: Munson
Publisher: VST
bartleby

Concept explainers

Question
Book Icon
Chapter 13, Problem 10P

a)

Summary Introduction

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)

Expert Solution
Check Mark

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.

Ending inventory=(Production+Ending inventory of previous month)Demand=(1,300+300)1,000=1,6001,000=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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+600)1,200=1,9001,200=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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+700)1,400=2,0001,400=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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+600)1,800=1,9001,800=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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+100)1,800=1,4001,800=400

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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+0)1,800=1,3001,800=500

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

Extra cost=Ending inventory×Inventory holding cost per unit=600×$25=$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

Extra cost=Ending inventory×Inventory holding cost per unit=700×$25=$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

Extra cost=Ending inventory×Inventory holding cost per unit=600×$25=$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

Extra cost=Ending inventory×Inventory holding cost per unit=100×$25=$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

Extra cost=Subcontract×Subcontract cost per unit=400×$60=$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

Extra cost=Subcontract×Subcontract cost per unit=500×$60=$30,000

Calculate total cost of Plan C:

It is calculated by adding the extra costs of all the periods.

Total cost=Extra costs of all periods=$15,000+$17,500+$15,000+$2,500+$24,000+$30,000=$104,000

Hence, the total cost for Plan C is $104,000.

b)

Summary Introduction

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)

Expert Solution
Check Mark

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.

Ending inventory=ProductionDemand=1,3001,000=300

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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+180)1,200=1,4801,200=280

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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+180)1,400=1,4801,400=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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+80)1,800=1,3801,800=420

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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+0)1,800=1,3001,800=500

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.

Ending inventory=(Production+Ending inventory)Demand=(1,300+0)1,800=1,3001,800=500

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.

Extra cost=(Ending inventory×Inventory holding cost per unit)+(Idle time×Idle time cost)=(180×$25)+(120×$60)=$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.

Extra cost=(Ending inventory×Inventory holding cost per unit)+(Idle time×Idle time cost)=(180×$25)+(100×$60)=$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.

Extra cost=(Ending inventory×Inventory holding cost per unit)+(Idle time×Idle time cost)=(80×$25)+(0)=$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.

Extra cost=(Overtime units×Overtime cost per unit)+(Subcontract units×Subcontract cost per unit)=(260×$40)+(160×$60)=$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.

Extra cost=(Overtime units×Overtime cost per unit)+(Subcontract units×Subcontract cost per unit)=(260×$40)+(240×$60)=$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.

Extra cost=(Overtime units×Overtime cost per unit)+(Subcontract units×Subcontract cost per unit)=(260×$40)+(240×$60)=$24,800

Calculate total cost of Plan D:

It is calculated by adding the extra costs of all the periods.

Total cost=Extra costs of all periods=$11,700+$10,500+$2,000+$20,000+$24,800+$24,800=$93,800

Hence, the total cost for Plan D is $93,800.

Conclusion

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?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Do the inherent differences between private and public sector objectives—profit versus publicgood—render private sector category management practices unsuitable for public sectorpurchasing, where open tendering is the norm?You have now undergone the Category Management classes and your superiors have requestedfor your input on how to integrate some of the learnings into the public sector policy. Discuss and elaborate what are the activities and governance you would introduce in yourrecommendations without violating the principle of transparency and accountability withinyour organisation. This is based on Singapore context. Pls provide a draft with explanation, examples and useful links for learning purposes. Citations will be good too. This is a module in SUSS called category management and supplier evaluation
provide scholarly answers for what risk was associated with the Citibank bank loosing 50 million in August 2020
Conclusion: The report recommendations and broad conclusion to the essay. TOTAL 5 100
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
Text book image
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning