Complete the following MRP record. Note that the minimum order quantity is 200. What is the average ending inventory over the six weeks? Click the icon to view the MRP record. Complete the material requirements plan (enter your responses as whole numbers). 1 2 3 5 6 Week ***B3*** LT(weeks) = 1 350 300 200 200 350 Gross requirements Scheduled receipts Projected ending inventory: 200 Net requirements OD Min. order = 200 Planned receipts Complete the following master schedule record. B Click the icon to view the master schedule record. Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 190 Week 2 3 Forecasted demand 260 310 Booked orders 240 345 Projected ending inventory Master production schedule 850 4 200 310 5 400 140 6 400 305 7 260 295 8 280 250 9 400 215 27 480 750 590 More Info 7 8 On-hand inventory at end of week 1: 190 Week 2 3 Forecasted demand 260 310 Booked orders 240 345 Projected ending inventory Master production schedule 850 Available to promise 4 200 310 5 400 140 6 400 305 260 295 280 250 400 215 480 750 590 125