15 Review View Help Question 2 (MRP, 30 points total) For the item (Item A) described below, answer the following questions: Item A is the final product. One unit of A requires one unit of B, one unit of C and one unit of D. One unit of D requires two units of E and one unit of F . (a) (6 points) Generate the relevant Bill of Material (BOM) diagram using the information above. Show LLCs (Low level codes) and other necessary details. Period 1 2 3 4 5 6 7 8 Demand (A) 21 25 75 30 35 80 75 19 Item Lead Time Lot Sizing Rule Amount on Hand Scheduled Receipt Arrival on week 60 A 70 3 1 L4L 50 1 D Multiples of 30 E 100 100 2 1 Multiples of 50 SLN - Protected View - Saved to this PC- O Search ilings Review View Help (b) (24 points, 8 points each) Generate the MRP output for items A, D and E, using the BOMs you identified in part (a), and the following demand and inventory data. Use the MRP record tables provided in the following page. 4. Period 1 2 3 4 5 6 7 8 Item Gross Requirements A Scheduled receipts On hand from prior period LT- Net requirements Time-phased Net Req. Planned order releases Q- Planned order delivery Period 1 2 3 4 5 6 7 8 Item Gross Requirements D Scheduled receipts Protected View - Saved to this PC- O Search Review View Help Planned order releases Q= Planned order delivery Period 1 2 3 4 5 6 7 8 Item Gross Requirements D Scheduled receipts On hand from prior period LT= Net requirements Time-phased Net Req. Q= Planned order releases Planned order delivery Focus Protected View - Saved to this PC Search 5 Review View Help 5 Period 1 2 3 4 5 6 7 8 Gross Requirements Item E Scheduled receipts On hand from prior period Net requirements LT= Time-phased Net Req. Planned order releases Planned order delivery Droo