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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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

What is Bitcoin? How important is it to businesses and individuals? How does it cause environmental damage and is that damage worth continued uses of Bitcoin? Read the following articles to help answer these questions: United Nations University. (2023, October 24). UN study reveals the hidden environmental impacts of bitcoin: Carbon is not the only harmful by-product. https://unu.edu/press-release/un-study-reveals-hidden-environmental-impacts-bitcoin-carbon-not-only-harmful-product#:~:text=Bitcoin%2C%20the%20most%20popular%20cryptocurrency,the%20worldwide%20Bitcoin%20mining%20network. Salam, E. (2023, April 26). Bitcoin is terrible for the environment – can it ever go green? The Guardian. https://www.theguardian.com/technology/2023/apr/26/bitcoin-mining-climate-crisis-environmental-impact

419 X .com/courses/1546/assignments/49499?module_item_id=111573 Unlimited Attempts Allowed ✓ Details Directions: Record a video of yourself giving a business presentation. Imagine you are tasked with researching a professional development topic on business communication for 40 coworkers. You are then expected to give a 4 - 5 minute presentation on the topic. Choose any topic related to business communication, such as intercultural communication, effective leadership, professional writing, etc. Research the topic and prepare a 4 - 5 minute presentation that could be given over video conference call (such as Zoom). You may use visual aids if you choose. Upload a video file of your presentation. Provide all needed citations. Requirements: 4-5 minutes long Contains visual and audio Create your own work; do not plagiarize Cite your sources using APA citations Choose a submission type T

acts Container chips (s 150 cussion: Conflict X + e.com/courses/1546/discussion_topics/15722?module_item_id=111559 24 Winter > Discussions > Week 8 Discussion: Conflict 时☆ 26 Replies, 26 Unread Week 8 Discussion: Conflict Write a 200 - 300 word discussion post based on the prompt below. Reply to at least one other student in 50 - 100 words. Can you think of a time when a conflict led to a new opportunity, better understanding, or other positive result? If not, think of a past conflict and imagine a positive outcome. Discuss the impact of this conflict on your workplace relationships, productivity, and innovation. Source: Business Communication for Success. (2015). University of Minnesota Libraries Publishing. Attribution-NonCommerical-ShareAlike. Edit View Insert Format Tools Table 12ptv Paragraph BIUA T2

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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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:

EBK PRINCIPLES OF OPERATIONS MANAGEMENT, 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.