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.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 13, Problem 6P

a)

Summary Introduction

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)

Expert Solution

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.

Ending inventory=(Production+Ending inventory of previous month)−Demand=(1,600+200)−1,400=1,800−1,400=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.

Ending inventory=(Production+Ending inventory)−Demand=(1,600+400)−1,600=2,000−1,600=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.

Ending inventory=(Production+Ending inventory)−Demand=(1,600+400)−1,800=2,000−1,800=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.

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

Stock-out=(Demand−Production)−Overtime unit=(2,200−1,600)−320=600−320=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.

Stock-out=(Demand−Production)−Overtime unit=(2,200−1,600)−320=600−320=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.

Stock-out=(Demand−Production)−Overtime unit=(1,800−1,600)−200=200−200=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.

Stock-out=(Demand−Production)−Overtime unit=(1,800−1,600)−200=200−200=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

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

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

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

Extra cost=(Overtime unit×Overtime cost per unit)+(Stock-out units×Stock-out cost per unit)=(320×$50)+(280×$100)=$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

Extra cost=(Overtime unit×Overtime cost per unit)+(Stock-out units×Stock-out cost per unit)=(320×$50)+(280×$100)=$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

Extra cost=(Overtime unit×Overtime cost per unit)=(200×$50)=$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

Extra cost=(Overtime unit×Overtime cost per unit)=(200×$50)=$10,000

Calculate the total cost of Plan D:

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

Total cost=Extra costs of all periods=$8,000+$8,000+$4,000+$0+$44,000+$44,000+$10,000+$10,000=$128,000

Hence, the total cost for Plan D is $128,000.

b)

Summary Introduction

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)

Expert Solution

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.

Ending inventory=(Production+Ending inventory of previous month)−Demand=(1,600+200)−1,400=1,800−1,400=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.

Ending inventory=(Production+Ending inventory)−Demand=(1,600+400)−1,600=2,000−1,600=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.

Ending inventory=(Production+Ending inventory)−Demand=(1,600+400)−1,800=2,000−1,800=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.

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

Stock-out=(Demand−Production)=(2,200−1,600)=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.

Stock-out=(Demand−Production)=(2,200−1,600)=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.

Stock-out=(Demand−Production)=(1,800−1,600)=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.

Stock-out=(Demand−Production)=(1,800−1,600)=200 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

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

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

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

Extra cost=(Subcontract units×Subcontract cost per unit)=(600×$75)=$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

Extra cost=(Subcontract units×Subcontract cost per unit)=(600×$75)=$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

Extra cost=(Subcontract units×Subcontract cost per unit)=(200×$75)=$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

Extra cost=(Subcontract units×Subcontract cost per unit)=(200×$75)=$15,000

Calculate the total cost of Plan E:

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

Total cost=Extra costs of all periods=$8,000+$8,000+$4,000+$0+$45,000+$45,000+$15,000+$15,000=$140,000

Hence, the total cost for Plan E is $140,000.

Conclusion

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?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

1. Strategic Predispositions of MNEsChapter 8 outlines four strategic predispositions—ethnocentric, polycentric, regiocentric, and geocentric. a. Define each orientation and explain how it shapes an MNE’s approach to market entry, integration, and control. b. Provide a real or hypothetical example of a firm (e.g., IKEA, Samsung) for each orientation, justifying why that orientation fits based on its structure and policies. c. Evaluate the potential benefits and downsides of each orientation for international competitiveness and global performance. 2. External and Internal Analysis in Strategy FormulationChapter 8 emphasizes the importance of external environmental assessment (macro and industry-level forces) and internal resource evaluation when crafting a multinational strategy. a. Describe key elements of external assessment (e.g., market size, political risk, competition) and internal evaluation (e.g., firm capabilities, value-chain strengths). b. Choose an MNE (real or…

1. Structural Arrangements for Global Integration vs Local ResponsivenessChapter 9 explains how MNEs structure their organizations to balance global efficiency and local responsiveness. a. Describe the main organizational structures covered (e.g., international division, global product division, geographic/regional division, matrix, transnational). b. Choose one global MNE (real or hypothetical) and argue which structure (or hybrid) best suits its strategy—taking into account industry, scale, and diversity of markets. c. Discuss two key challenges this MNE might face under that structure (e.g., coordination complexity, role ambiguity), and recommend how to address them. 2. Control Mechanisms & Coordination in MNEsEffective international organization also relies on control systems and coordination processes. a. Define and contrast different control mechanisms (e.g., output controls, process controls, cultural/values-based controls) as presented in the chapter. b. Provide…

3. Overcoming Negotiation Challenges:Describe two common challenges negotiators face during the planning phase. How can these challenges be anticipated and effectively addressed? 4. Strategic Planning in Practice:Think of a past negotiation experience (real or hypothetical). How would applying the principles of strategic negotiation planning from this chapter have improved the outcome? 5. Chapter Summary Reflection:Summarize the major insights from Chapter 4. How does strategic planning enhance a negotiator’s ability to stay focused and adaptable during complex negotiations?

Answer 2

Question

Chapter 13, Problem 6P

a)

Summary Introduction

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)

Expert Solution

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