Complete the following MRP time-phased record X=36 Toaster Week Gross Requiremen
ID: 382534 • Letter: C
Question
Complete the following MRP time-phased record X=36 Toaster Week Gross Requirements Scheduled Receipts Proiected Available Balance Planned Order Release 4 10 2X25 3+X 5+X207+X25 Q=50, LT = 2, SS = 5 The following events occurred during week 1: - Actual demand during week 1 was only 5 units - A cvcle count of on-hand units showed 17 units at the start of week 1 - Marketing forecasted that X toasters would be required in week 9 Update the record below after rolling through time Toaster Week Gross Requirements Scheduled Receipts Proiected Available Balance Planned Order Release 2 9 24X 25 3+X5+X 20 7+X25 Q=50, LT = 2, SS = 5Explanation / Answer
Projected available balance (PAB) = Previous week PAB + Scheduled receipts + Planned Order release of 2 weeks earlier (Considering 2 weeks lead time)
Safety stock is 5, therefore PAB in every week must be at least 5.
Completed MRP time-phased record follows
Considering the events of week 1,
Projected available balance at the start of week 2 = 17 - 5 = 12
An order for 50 units was released in week 1, therefore scheduled receipts in week 3 = 50
Demand of week 9 is 36
Revised MRP record follows
Week 1 2 3 4 5 6 7 8 Gross requirements 10 38 25 39 41 20 43 25 Scheduled Receipts 36 Projected Available Balance 36 26 24 49 10 19 49 6 31 Planned Order Release 50 50 50 50