Problem 4: MRP Calculations (9 points) The low-level coded BOM is shown in the attached Excel file along with a template to complete for parts A, B and C. The on hand (OH), lead time (LT), safety stock (SS), and production lot size (Q) are shown for each item. Marketing has a gross requirement for 100 part A in week 8. There are scheduled receipts of 50 B in week 1 and 200 C in week 2. a) Complete the sections highlighted in yellow on the template for part A. (3 points) b) Complete the sections highlighted in yellow on the template for part B. (3 points) c) Complete the sections highlighted in yellow on the template for part C. (3 points) Problem 4: Complete the sections highlighted in yellow for parts A, B and C Low-Level Coded BOM: Level 0: Level 1: B(3) Level 2: C(2) C(1) Part: A Week OH - 20 LT-3 weeks SS-0 Q-Lot-for-lot Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Part: B OH - 10 LT-2 weeks SS-0 Q-500 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Part: Week 60 OH-400 LT-1 week SS-100 0 - 200 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release