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

a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z,70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units ofcomponent C in week 4. Lead times are two weeks for Z and B, and one week for the other components. Lot-for-lot ordering will be used for all items b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and areexpected to arrive in week 4. Lead times are two weeks for E and C, and one week for the othercomponents. Assume lot-for-lot ordering except for D, where multiples of 40 must be used.

Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the startof week 8. There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are inproduction and will be completed by the start of week 2. Lot-for-lot ordering will be used for all items.

Please Simply fill out the chart answering the question

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.