Please answer second part of problem that is marked with * . Please answer in excel format with formulas showing. If possible can you send this one to Abhishek. I updated the table to show the 17 units at start of week 1and the 32 required in week 9 but im not sure if thats correct. Also, I don't know how to put the demand for 5 units in week 1 into the table.

2. Complete the following MRP time-phased record: Toaster Week 1 2 3 4 5 6 7 8 Gross Requirements 10 34 25 35 37 20 39 25 Scheduled Receipts 03200000 Projected Available Balance 3217/5 40 5 18 489 34 Planned Order Release 50 o so so oso ool Q = 50, LT = 2, SS = 5 * The following events occurred during week 1: - Actual demand during week I was only 5 units - A cycle count of on-hand units showed 17 units at the start of week 1 - Marketing forecasted that 32 toasters would be required in week 9 Update the record below after rolling through time. Toaster Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q = 50, LT = 2, SS = 5 2 3 4 5 6 7 8 9 34 25 35.37 20 39 25 32 32 32 77