A net requirements plan for items. Introduction: Net requirements plan: The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 14, Problem 12P

a)

Summary Introduction

To develop: A net requirements plan for items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

a)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 1

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100		50		150
Scheduled receipt
On hand (100)							100		0		0
Net requirement							0		50		150
Planned order receipt									50		150
Planned order release							50		150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100	100	50	50	150
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							50	100	50	50	150
Planned order receipt							50	100	50	50	150
Planned order release					50	100	50	50	150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 50 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50		150
Scheduled receipt
On hand (50)							50		0
Net requirement									150
Planned order receipt									150
Planned order release								150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 500. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 150 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50	100	150
Scheduled receipt
On hand (75)							75	25	0
Net requirement							0	75	150
Planned order receipt								75	150
Planned order release						75	150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release				75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release					75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

b)

Summary Introduction

To develop: A net requirements plan for all items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

b)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 2

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item
2 assemblies for item B, C and F.

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200		100		300
Scheduled receipt
On hand (100)							100		0		0
Net requirement							100		100		300
Planned order receipt							100		100		300
Planned order release					100		100		300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 100. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200	200	100	100	300
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							150	200	100	100	300
Planned order receipt							150	200	100	100	300
Planned order release					150	200	100	100	300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 200 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 100 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements						100		100		300
Scheduled receipt
On hand (50)						50		0		0
Net requirement						50		100		300
Planned order receipt						50		100		300
Planned order release					50		100		300

Week 6:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 6.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 8:

The gross requirement is 300 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 10.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					100		100	100	300
Scheduled receipt
On hand (75)					75		0	0	0
Net requirement					25		100	100	300
Planned order receipt					25		100	100	300
Planned order release			25		100	100	300

Week 5:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 25. The lead time is 2 weeks. Therefore, the planned order release will be 25 in week 3 which will be the planned order receipt in week 5.

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					300	400	200	300	600
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					225	400	200	300	600
Planned order receipt					225	400	200	300	600
Planned order release			225	400	200	300	600

Week 5:

The gross requirement is 300 (2 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 225. The lead time is 2 weeks. Therefore, the planned order release will be 225 in week 3 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 400 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 2 weeks. Therefore, the planned order release will be 400 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 200 (2 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 300 (2 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 600 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 600. The lead time is 2 weeks. Therefore, the planned order release will be 600 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					150	200	100	150	300
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					75	200	100	150	300
Planned order receipt					75	200	100	150	300
Planned order release				75	200	100	150	300

Week 5:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 200 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 100 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 150 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 8 which will be the planned order receipt in week 9.

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

Accounting problem

Government's new plan to shift cargo from roads back to rail 26TH JANUARY 2024 Government is seeking to finalise a plan aimed at improving its rail network and move cargo away from a billion rand per day to its logistics crises, government has said an urgentturnaround is needed to improve its 31 000km locomotive network as more and more cargo moves from rail to trucks. The Department of Transport (DoT) hosted a discussion with industry stakeholders regarding the Freight Road to Rail Migration Plan on Thursday - the latest development in the wake of President Cyril Ramphosa forming the National Logistics Crisis Committee last year. Transnet, the South African National Roads Agency (Sanral) and private sector companies were all in attendance. The Freight Road to Rail Migration Plan is part of government's strategies to improve the country's ongoing logistics crises. In October last year, the government unveiled its Freight Logistics Roadmap to improve the ports and rail networks and…

Assess what led to such logistical inefficiencies / collapse of a previously world class freight network

Answer 2

Question

Chapter 14, Problem 12P

a)

Summary Introduction

To develop: A net requirements plan for items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

a)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 1

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100		50		150
Scheduled receipt
On hand (100)							100		0		0
Net requirement							0		50		150
Planned order receipt									50		150
Planned order release							50		150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100	100	50	50	150
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							50	100	50	50	150
Planned order receipt							50	100	50	50	150
Planned order release					50	100	50	50	150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 50 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50		150
Scheduled receipt
On hand (50)							50		0
Net requirement									150
Planned order receipt									150
Planned order release								150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 500. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 150 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50	100	150
Scheduled receipt
On hand (75)							75	25	0
Net requirement							0	75	150
Planned order receipt								75	150
Planned order release						75	150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release				75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release					75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

b)

Summary Introduction

To develop: A net requirements plan for all items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

b)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 2

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item
2 assemblies for item B, C and F.

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200		100		300
Scheduled receipt
On hand (100)							100		0		0
Net requirement							100		100		300
Planned order receipt							100		100		300
Planned order release					100		100		300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 100. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200	200	100	100	300
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							150	200	100	100	300
Planned order receipt							150	200	100	100	300
Planned order release					150	200	100	100	300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 200 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 100 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements						100		100		300
Scheduled receipt
On hand (50)						50		0		0
Net requirement						50		100		300
Planned order receipt						50		100		300
Planned order release					50		100		300

Week 6:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 6.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 8:

The gross requirement is 300 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 10.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					100		100	100	300
Scheduled receipt
On hand (75)					75		0	0	0
Net requirement					25		100	100	300
Planned order receipt					25		100	100	300
Planned order release			25		100	100	300

Week 5:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 25. The lead time is 2 weeks. Therefore, the planned order release will be 25 in week 3 which will be the planned order receipt in week 5.

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					300	400	200	300	600
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					225	400	200	300	600
Planned order receipt					225	400	200	300	600
Planned order release			225	400	200	300	600

Week 5:

The gross requirement is 300 (2 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 225. The lead time is 2 weeks. Therefore, the planned order release will be 225 in week 3 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 400 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 2 weeks. Therefore, the planned order release will be 400 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 200 (2 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 300 (2 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 600 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 600. The lead time is 2 weeks. Therefore, the planned order release will be 600 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					150	200	100	150	300
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					75	200	100	150	300
Planned order receipt					75	200	100	150	300
Planned order release				75	200	100	150	300

Week 5:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 200 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 100 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 150 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 8 which will be the planned order receipt in week 9.

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!

Answer 3

Question

Chapter 14, Problem 12P

a)

Summary Introduction

To develop: A net requirements plan for items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

a)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 1

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100		50		150
Scheduled receipt
On hand (100)							100		0		0
Net requirement							0		50		150
Planned order receipt									50		150
Planned order release							50		150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100	100	50	50	150
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							50	100	50	50	150
Planned order receipt							50	100	50	50	150
Planned order release					50	100	50	50	150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 50 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50		150
Scheduled receipt
On hand (50)							50		0
Net requirement									150
Planned order receipt									150
Planned order release								150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 500. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 150 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50	100	150
Scheduled receipt
On hand (75)							75	25	0
Net requirement							0	75	150
Planned order receipt								75	150
Planned order release						75	150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release				75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release					75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

b)

Summary Introduction

To develop: A net requirements plan for all items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

b)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 2

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item
2 assemblies for item B, C and F.

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200		100		300
Scheduled receipt
On hand (100)							100		0		0
Net requirement							100		100		300
Planned order receipt							100		100		300
Planned order release					100		100		300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 100. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200	200	100	100	300
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							150	200	100	100	300
Planned order receipt							150	200	100	100	300
Planned order release					150	200	100	100	300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 200 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 100 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements						100		100		300
Scheduled receipt
On hand (50)						50		0		0
Net requirement						50		100		300
Planned order receipt						50		100		300
Planned order release					50		100		300

Week 6:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 6.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 8:

The gross requirement is 300 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 10.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					100		100	100	300
Scheduled receipt
On hand (75)					75		0	0	0
Net requirement					25		100	100	300
Planned order receipt					25		100	100	300
Planned order release			25		100	100	300

Week 5:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 25. The lead time is 2 weeks. Therefore, the planned order release will be 25 in week 3 which will be the planned order receipt in week 5.

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					300	400	200	300	600
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					225	400	200	300	600
Planned order receipt					225	400	200	300	600
Planned order release			225	400	200	300	600

Week 5:

The gross requirement is 300 (2 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 225. The lead time is 2 weeks. Therefore, the planned order release will be 225 in week 3 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 400 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 2 weeks. Therefore, the planned order release will be 400 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 200 (2 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 300 (2 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 600 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 600. The lead time is 2 weeks. Therefore, the planned order release will be 600 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					150	200	100	150	300
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					75	200	100	150	300
Planned order receipt					75	200	100	150	300
Planned order release				75	200	100	150	300

Week 5:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 200 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 100 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 150 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 8 which will be the planned order receipt in week 9.

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!

Answer 4

Question

Chapter 14, Problem 12P

a)

Summary Introduction

To develop: A net requirements plan for items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

a)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 1

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100		50		150
Scheduled receipt
On hand (100)							100		0		0
Net requirement							0		50		150
Planned order receipt									50		150
Planned order release							50		150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100	100	50	50	150
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							50	100	50	50	150
Planned order receipt							50	100	50	50	150
Planned order release					50	100	50	50	150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 50 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50		150
Scheduled receipt
On hand (50)							50		0
Net requirement									150
Planned order receipt									150
Planned order release								150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 500. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 150 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50	100	150
Scheduled receipt
On hand (75)							75	25	0
Net requirement							0	75	150
Planned order receipt								75	150
Planned order release						75	150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release				75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release					75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

b)

Summary Introduction

To develop: A net requirements plan for all items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

b)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 2

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item
2 assemblies for item B, C and F.

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200		100		300
Scheduled receipt
On hand (100)							100		0		0
Net requirement							100		100		300
Planned order receipt							100		100		300
Planned order release					100		100		300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 100. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200	200	100	100	300
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							150	200	100	100	300
Planned order receipt							150	200	100	100	300
Planned order release					150	200	100	100	300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 200 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 100 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements						100		100		300
Scheduled receipt
On hand (50)						50		0		0
Net requirement						50		100		300
Planned order receipt						50		100		300
Planned order release					50		100		300

Week 6:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 6.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 8:

The gross requirement is 300 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 10.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					100		100	100	300
Scheduled receipt
On hand (75)					75		0	0	0
Net requirement					25		100	100	300
Planned order receipt					25		100	100	300
Planned order release			25		100	100	300

Week 5:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 25. The lead time is 2 weeks. Therefore, the planned order release will be 25 in week 3 which will be the planned order receipt in week 5.

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					300	400	200	300	600
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					225	400	200	300	600
Planned order receipt					225	400	200	300	600
Planned order release			225	400	200	300	600

Week 5:

The gross requirement is 300 (2 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 225. The lead time is 2 weeks. Therefore, the planned order release will be 225 in week 3 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 400 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 2 weeks. Therefore, the planned order release will be 400 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 200 (2 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 300 (2 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 600 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 600. The lead time is 2 weeks. Therefore, the planned order release will be 600 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					150	200	100	150	300
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					75	200	100	150	300
Planned order receipt					75	200	100	150	300
Planned order release				75	200	100	150	300

Week 5:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 200 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 100 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 150 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 8 which will be the planned order receipt in week 9.

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!

Answer 5

Chapter 14, Problem 12P

a)

Summary Introduction

To develop: A net requirements plan for items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

a)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 1

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100		50		150
Scheduled receipt
On hand (100)							100		0		0
Net requirement							0		50		150
Planned order receipt									50		150
Planned order release							50		150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100	100	50	50	150
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							50	100	50	50	150
Planned order receipt							50	100	50	50	150
Planned order release					50	100	50	50	150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 50 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50		150
Scheduled receipt
On hand (50)							50		0
Net requirement									150
Planned order receipt									150
Planned order release								150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 500. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 150 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50	100	150
Scheduled receipt
On hand (75)							75	25	0
Net requirement							0	75	150
Planned order receipt								75	150
Planned order release						75	150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release				75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release					75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

b)

Summary Introduction

To develop: A net requirements plan for all items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

b)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 2

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item
2 assemblies for item B, C and F.

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200		100		300
Scheduled receipt
On hand (100)							100		0		0
Net requirement							100		100		300
Planned order receipt							100		100		300
Planned order release					100		100		300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 100. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200	200	100	100	300
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							150	200	100	100	300
Planned order receipt							150	200	100	100	300
Planned order release					150	200	100	100	300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 200 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 100 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements						100		100		300
Scheduled receipt
On hand (50)						50		0		0
Net requirement						50		100		300
Planned order receipt						50		100		300
Planned order release					50		100		300

Week 6:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 6.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 8:

The gross requirement is 300 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 10.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					100		100	100	300
Scheduled receipt
On hand (75)					75		0	0	0
Net requirement					25		100	100	300
Planned order receipt					25		100	100	300
Planned order release			25		100	100	300

Week 5:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 25. The lead time is 2 weeks. Therefore, the planned order release will be 25 in week 3 which will be the planned order receipt in week 5.

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					300	400	200	300	600
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					225	400	200	300	600
Planned order receipt					225	400	200	300	600
Planned order release			225	400	200	300	600

Week 5:

The gross requirement is 300 (2 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 225. The lead time is 2 weeks. Therefore, the planned order release will be 225 in week 3 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 400 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 2 weeks. Therefore, the planned order release will be 400 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 200 (2 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 300 (2 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 600 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 600. The lead time is 2 weeks. Therefore, the planned order release will be 600 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					150	200	100	150	300
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					75	200	100	150	300
Planned order receipt					75	200	100	150	300
Planned order release				75	200	100	150	300

Week 5:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 200 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 100 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 150 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 8 which will be the planned order receipt in week 9.

Answer 6

Chapter 14, Problem 12P

a)

Summary Introduction

To develop: A net requirements plan for items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

a)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 1

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100		50		150
Scheduled receipt
On hand (100)							100		0		0
Net requirement							0		50		150
Planned order receipt									50		150
Planned order release							50		150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100	100	50	50	150
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							50	100	50	50	150
Planned order receipt							50	100	50	50	150
Planned order release					50	100	50	50	150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 50 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50		150
Scheduled receipt
On hand (50)							50		0
Net requirement									150
Planned order receipt									150
Planned order release								150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 500. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 150 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50	100	150
Scheduled receipt
On hand (75)							75	25	0
Net requirement							0	75	150
Planned order receipt								75	150
Planned order release						75	150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release				75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release					75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Answer 7

Chapter 14, Problem 12P

a)

Summary Introduction

To develop: A net requirements plan for items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

Answer 8

a)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 1

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100		50		150
Scheduled receipt
On hand (100)							100		0		0
Net requirement							0		50		150
Planned order receipt									50		150
Planned order release							50		150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							100	100	50	50	150
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							50	100	50	50	150
Planned order receipt							50	100	50	50	150
Planned order release					50	100	50	50	150

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 50 (1 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 50 (1 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 150 (1 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50		150
Scheduled receipt
On hand (50)							50		0
Net requirement									150
Planned order receipt									150
Planned order release								150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 500. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 9:

The gross requirement is 150 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							50	100	150
Scheduled receipt
On hand (75)							75	25	0
Net requirement							0	75	150
Planned order receipt								75	150
Planned order release						75	150

Week 7:

The gross requirement is 50 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release				75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 2 weeks. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					50	100	50	100	150
Scheduled receipt
On hand (75)					75	25	0	0	0
Net requirement					0	75	50	100	150
Planned order receipt						75	50	100	150
Planned order release					75	50	100	150

Week 5:

The gross requirement is 50 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 6:

The gross requirement is 100 (1 assembly) derived from planned order release of C. The on hand inventory is 25. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 50 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 8 which will be the planned order receipt in week 9.

Answer 9

a)

Expert Solution

Answer 10

a)

Expert Solution

Answer 11

Expert Solution

Answer 12

b)

Summary Introduction

To develop: A net requirements plan for all items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

b)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 2

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item
2 assemblies for item B, C and F.

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200		100		300
Scheduled receipt
On hand (100)							100		0		0
Net requirement							100		100		300
Planned order receipt							100		100		300
Planned order release					100		100		300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 100. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200	200	100	100	300
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							150	200	100	100	300
Planned order receipt							150	200	100	100	300
Planned order release					150	200	100	100	300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 200 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 100 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements						100		100		300
Scheduled receipt
On hand (50)						50		0		0
Net requirement						50		100		300
Planned order receipt						50		100		300
Planned order release					50		100		300

Week 6:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 6.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 8:

The gross requirement is 300 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 10.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					100		100	100	300
Scheduled receipt
On hand (75)					75		0	0	0
Net requirement					25		100	100	300
Planned order receipt					25		100	100	300
Planned order release			25		100	100	300

Week 5:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 25. The lead time is 2 weeks. Therefore, the planned order release will be 25 in week 3 which will be the planned order receipt in week 5.

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					300	400	200	300	600
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					225	400	200	300	600
Planned order receipt					225	400	200	300	600
Planned order release			225	400	200	300	600

Week 5:

The gross requirement is 300 (2 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 225. The lead time is 2 weeks. Therefore, the planned order release will be 225 in week 3 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 400 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 2 weeks. Therefore, the planned order release will be 400 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 200 (2 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 300 (2 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 600 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 600. The lead time is 2 weeks. Therefore, the planned order release will be 600 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					150	200	100	150	300
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					75	200	100	150	300
Planned order receipt					75	200	100	150	300
Planned order release				75	200	100	150	300

Week 5:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 200 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 100 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 150 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 8 which will be the planned order receipt in week 9.

Answer 13

b)

Summary Introduction

To develop: A net requirements plan for all items.

Introduction:

Net requirements plan:

The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.

Answer 14

b)

Expert Solution

Explanation of Solution

Given information:

Product structure:

Pearson eText Principles of Operations Management: Sustainability and Supply Chain Management -- Instant Access (Pearson+), Chapter 14, Problem 12P , additional homework tip 2

Period	8	9	10	11	12
Gross requirements: A	100		50		150
Gross requirements: H		100		50

Inventory and lead time:

Item	A	B	C	D	E	F	G	H	J	K
Lead time	1	2	2	1	2	2	1	1	2	2
On hand	0	100	50	50	75	75	75	0	100	100

1 assembly for each item
2 assemblies for item B, C and F.

Item A:

	Week
Item A	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50		150
Scheduled receipt
On hand (0)								0		0		0
Net requirement								100		50		150
Planned order receipt								100		50		150
Planned order release							100		50		150

Week 8:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 10:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 10.

Week 12:

The gross requirement is 150 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 11 which will be the planned order receipt in week 12.

Item H:

	Week
Item H	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements									100		50
Scheduled receipt
On hand (0)									0		0
Net requirement									100		50
Planned order receipt									100		50
Planned order release								100		50

Week 9:

The gross requirement is 100 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 1000. The lead time is 1 week. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 50 (1 assembly). The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 9 which will be the planned order receipt in week 11.

Item B:

	Week
Item B	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200		100		300
Scheduled receipt
On hand (100)							100		0		0
Net requirement							100		100		300
Planned order receipt							100		100		300
Planned order release					100		100		300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 100. Hence, the net requirement is 100. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item C:

	Week
Item C	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements							200	200	100	100	300
Scheduled receipt
On hand (50)							50	0	0	0	0
Net requirement							150	200	100	100	300
Planned order receipt							150	200	100	100	300
Planned order release					150	200	100	100	300

Week 7:

The gross requirement is 200 (2 assembly) derived from planned order release of A. The on hand inventory is 50. Hence, the net requirement is 150. The lead time is 2 weeks. Therefore, the planned order release will be 150 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 200 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 100 (2 assembly) derived from the planned order release of A. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 9.

Week 10:

The gross requirement is 100 (2 assembly) derived from planned order release of H. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 8 which will be the planned order receipt in week 10.

Week 11:

The gross requirement is 300 (2 assembly) derived from planned order release of A. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 11.

Item J:

	Week
Item J	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt								0		50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item K:

	Week
Item K	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements								100		50
Scheduled receipt
On hand (100)								100		0
Net requirement								0		50
Planned order receipt										50
Planned order release								50

Week 8:

The gross requirement is 100 (1 assembly) derived from planned order release of H. The on hand inventory is 100. Hence, the net requirement is 0. Therefore, there will be no planned order release.

Week 10:

The gross requirement is 50 (1 assembly) derived from the planned order release of H. The on hand inventory is 0. Hence, the net requirement is 50. The lead time is 2 weeks. Therefore, the planned order release will be 50 in week 8 which will be the planned order receipt in week 10.

Item D:

	Week
Item D	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements						100		100		300
Scheduled receipt
On hand (50)						50		0		0
Net requirement						50		100		300
Planned order receipt						50		100		300
Planned order release					50		100		300

Week 6:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 50. Hence, the net requirement is 50. The lead time is 1 week. Therefore, the planned order release will be 50 in week 5 which will be the planned order receipt in week 6.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 7 which will be the planned order receipt in week 8.

Week 8:

The gross requirement is 300 (1 assembly) derived from the planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 9 which will be the planned order receipt in week 10.

Item E:

	Week
Item E	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					100		100	100	300
Scheduled receipt
On hand (75)					75		0	0	0
Net requirement					25		100	100	300
Planned order receipt					25		100	100	300
Planned order release			25		100	100	300

Week 5:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 75. Hence, the net requirement is 25. The lead time is 2 weeks. Therefore, the planned order release will be 25 in week 3 which will be the planned order receipt in week 5.

Week 7:

The gross requirement is 100 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 100 (1 assembly) derived from the planned order release of J and K. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of B. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 7 which will be the planned order receipt in week 9.

Item F:

	Week
Item F	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					300	400	200	300	600
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					225	400	200	300	600
Planned order receipt					225	400	200	300	600
Planned order release			225	400	200	300	600

Week 5:

The gross requirement is 300 (2 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 225. The lead time is 2 weeks. Therefore, the planned order release will be 225 in week 3 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 400 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 2 weeks. Therefore, the planned order release will be 400 in week 4 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 200 (2 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 300 (2 assembly) derived from planned order release of C and J. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 2 weeks. Therefore, the planned order release will be 300 in week 6 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 600 (2 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 600. The lead time is 2 weeks. Therefore, the planned order release will be 600 in week 7 which will be the planned order receipt in week 9.

Item G:

	Week
Item G	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements					150	200	100	150	300
Scheduled receipt
On hand (75)					75	0	0	0	0
Net requirement					75	200	100	150	300
Planned order receipt					75	200	100	150	300
Planned order release				75	200	100	150	300

Week 5:

The gross requirement is 150 (1 assembly) derived from planned order release of C. The on hand inventory is 75. Hence, the net requirement is 75. The lead time is 1 week. Therefore, the planned order release will be 75 in week 4 which will be the planned order receipt in week 5.

Week 6:

The gross requirement is 200 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 5 which will be the planned order receipt in week 6.

Week 7:

The gross requirement is 100 (1 assembly) derived from the planned order release of C. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 7.

Week 8:

The gross requirement is 150 (1 assembly) derived from planned order release of C and K. The on hand inventory is 0. Hence, the net requirement is 150. The lead time is 1 week. Therefore, the planned order release will be 150 in week 7 which will be the planned order receipt in week 8.

Week 9:

The gross requirement is 300 (1 assembly) derived from planned order release of C. The on hand inventory is 0. Hence, the net requirement is 300. The lead time is 1 week. Therefore, the planned order release will be 300 in week 8 which will be the planned order receipt in week 9.