1. Complete the following MRP time-phased record: a) Pizza Week 1 2 3 4 5 6 7 Gross Requirements 10 38 25 39 41 20 43 25 Scheduled Receipts 72 Projected Available Balance 36 Planned Order Release Q = 50, LT = 2, SS = 5 The following events occurred during week 1: - Actual demand during week 1 was only 5 units - A cycle count of on-hand units showed 43 units at the start of week 1 - Marketing forecasted that 36 Pizza would be required in week 9 Update the record below after rolling through time. Pizza Week 2 C 7 9 Gross Requirements 25 39 20 43 25 Scheduled Receipts 12 Projected Available Balance Planned Order Release Q = 50, LT = 2, SS = 5