Problem 2 (20 points) Consider the following requirements for a certain product. 1 2 3 4 5 6 7 Period Gross requirements con 0 50 0 10 40 20 30 Beginning inventory = 20 units Setup cost = $100 per setup Lead time = 1 week Holding cost = $1 per unit per week Lot size = 62 units a) Develop the MRP table by filling the below table b) Calculate total inventory costs for the eight weeks. Week 0 1 2 3 4 5 6 7 8 00 Gross requirement Scheduled receipts On Hand Inventory Net Requirement Planned receipts Planned orders