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.

1. Complete the sections highlighted in yellow on the template for part A. (3 points)
2. Complete the sections highlighted in yellow on the template for part B. (3 points)
3. Complete the sections highlighted in yellow on the template for part C. (3 points)

Below I am providing you with the MRP template that must be filled out and used for this problem.

Problem 4: Complete the sections highlighted in yellow for parts A, B and C Low-Level Coded BOM: Level O: Level 1: B(3) Level 2: C(2) C(1) Part: A Week 4 2 3 5 6 7 100 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 1 2 3 Week 4 5 6 7 OH = 10 LT = 2 weeks 50 SS = 0 Q = 500 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Part: C 1 Week 21 31 41 5161 1 & OH = 400 LT = 1 week 200 SS = 100 Q = 200 Gross requirements Scheduled receipts 1 Projected available balance Net requirements Planned order receipt Planned order release