Problem 1

1. Suppose we make personal drones with the following bill-of-material: Drone Motors (6) Frame Propellers Batteries (2) Mounting screw a. Complete the following MRP record for the Level 0 finished drone with lead time = 1 week and minimum lot size of 200 units (6) Week 1 2 3 4 5 6 0 0 0 180 220 260 Gross Requirements Scheduled Receipts Projected ending inventory: 60 Net requirements Planned Receipts Planned orders b. Complete the following Level 1 MRP record for frames with lead time = 3 wks and minimum lot sizes are 500 units (6) 1 2 3 4 4 5 6 500 Week Gross Requirements Scheduled Receipts Projected ending inventory: 0 Net requirements Planned Receipts Planned orders c. Complete the following Level 2 MRP record for batteries with lead time = 1 week and minimum order boxes of 100 units each (6) Week 1 2 3 4 5 6 100 Gross Requirements Scheduled Receipts Projected ending inventory: 70 Net requirements Planned Receipts Planned orders d. Complete the following Level 1 MRP record for motors with lead time = 1 week and minimum order of 2000 units each (6) Week 1 2 3 4 5 6 Gross Requirements Scheduled Receipts Projected ending inventory: 500 Net requirements Planned Receipts Planned orders 1 e. Complete the following Level 2 MRP record for propellers with lead time week and minimum order of boxes of 500 each (6) 1 2 3 4 5 6 Week Gross Requirements Scheduled Receipts Projected ending inventory: 300 Net requirements Planned Receipts Planned orders f. If propellers had a safety stock of 200, would this change our calculations in part e? Why or why not? (1) g. MRP is capacity dependent, that is, MRP will not suggest an assembly schedule that is infeasible (T/F) (1) h. MRP should be used for only parts with short lead times (T/F). (1) i. If mounting screws took 5 weeks to arrive after an order is placed, what is the minimum number of weeks needed in the MRP planning horizon? (1)