• 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):

  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

  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
  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)

  Complete These Two MRP Records:

  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
  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)