Develop a material requirements plan that will yield 100

Question

Given the following information, develop a material requirements plan (MRP) that will yield 100 units of product A at the start of week 8. You need to fill out the matrices on the second page to answer the questions.

Item	Inventory On-Hand	Lead Time	Order Quantity
A	20	1	lot-for-lot
B	30	1	lot-for-lot
C	10	1	lot-for-lot
D	15	1	250
E	5	2	100

 1. What is the MPS (master production schedule) for the final product A?

2. What is the planned order release for item B?

3. What is the planned order release for item C?

4. What is the planned order release for item D?

5. What is the planned order release for item E?

MPS(Master Schedule) Week Number	Beg. Inv.	1	2	3	4	5	6	7	8
Quantity
Gross requirements (A)
Scheduled receipts
On hand
Net requirements
Planned-order receipts
Planned-order releases
Gross requirements (B)
Scheduled receipts
On hand
Net requirements
Planned-order receipts
Planned-order releases
Gross requirements (C)
Scheduled receipts
On hand
Net requirements
Planned-order receipts
Planned-order releases
Gross requirements (D)
Scheduled receipts
On hand
Net requirements
Planned-order receipts
Planned-order releases
Gross requirements (E)
Scheduled receipts
On hand
Net requirements
Planned-order receipts
Planned-order releases