• Using the MPS record created in Question 1 and shown below, as well as the Bill of Materials (BOM) shown below, complete the two MRP records by filling in the yellow cells.
• If the answer is zero (0), enter a 0 in the cell.
• Remember, FOQ is Fixed Order Quantity and L4L is Lot for Lot.
• SHOW YOUR WORK! I need to see the MRP chart, and show how you got each number if you want partial credit. Otherwise, if a number is wrong it is wrong!

MPS Record and Bill of Materials (BOM):

For every (1) Item A you need (1) Item D and (4) Item E.

A (1)

D (1) E (4)

LT = 3 weeks LT= 2 weeks

Item: A Lot Sizing Rule: FOQ = 100 Lead time: 1 week Beginning Inventory: 80
Week	1	2	3	4	5	6	7	8	9	10	11	12
Gross Requirements	25	25	25	25	30	30	30	30	35	35	35	35
Projected On Hand (80)	55	30	5	80	50	20	90	60	25	90	55	20
Planned Orders (MPS)	0	0	100	0	0	100	0	0	100	0	0	0

Complete These Two MRP Records:

Item: D Lot Sizing Rule: FOQ = 144 Lead Time: 3 weeks Parent: A Beginning Inventory: 120
Week	1	2	3	4	5	6	7	8	9	10	11	12
Gross Requirements	0	0	100	0	0	100	0	0	100	0	0	0
Scheduled Receipts	0	0	0	0	0	0	0	0	0	0	0	0
Projected On Hand (120)
Planned Orders (MRP)
Planned Order Releases (MRP Release Date)

Item: E Lot Sizing Rule: L4L Lead Time: 2 weeks Parent: A Beginning Inventory: 0
Week	1	2	3	4	5	6	7	8	9	10	11	12
Gross Requirements	0	0	400	0	0	400	0	0	400	0	0	0
Scheduled Receipts	0	0	0	0	0	0	0	0	0	0	0	0
Projected On Hand (120)
Planned Orders (MRP)
Planned Order Releases (MRP Release Date)