b. Which component will show in an Exception Report? Why?

c. Should you expedite this component? Why?

d. If expediting is unsuccessful, how will this affect the Projected Order Receipt and projected deliveries of the Z-Wrench?

4. Atlas Wrench Company was having problem with the sensitivity of its MRP system. The following records are typical of its planning system. The two records are for the Z-Wrench and for one of its component, the Z-Shaft. 3 2 201 4 1 5 3 6 45 5 | | | Z-Wrench 1 Gross Requirements | 2 | Schedule Receipt Proj. Avail. Balance 26 24 Proj. Order Receipt 0 Proj. Order Release 5 POQ = 3 weeks; LT = 2 weeks: SS = 0 units 0 4 0 4 5 3 10 0 45 0 45 2 0 3 0 456 45 0 0 Z-Shaft Gross Requirements 1 5 Schedule Receipt Proj. Avail. Balance 3 3 Proj. Order Receipt 1 0 Proj. Order Release 42 POQ = 3 weeks; LT = 3 weeks: SS = 0 units 3 0 3 0 0 42 0 0 0 0 a. Assume that week no.1 was executed as planned, a customer dropped an order of one (1) unit for the 2nd week, and a new customer order for 5 units was requested for week no. 7. Use the following spreadsheets to develop the MRP records for the 2nd week, and to answer the following questions. Week Z-Wrench Gross Requirements Scheduled Receipts Proj. Avail. Bal. P.O Receipt P.O. Release PQO=3 weeks; LT-2 weeks; SS=0 units Z-Shalft Gross Requirements Scheduled Receipts Proj. Avail. Bal. P.O Receipt P.O. Release PQO=3 weeks; LT-3 weeks; SS=0 units 4. Atlas Wrench Company was having problem with the sensitivity of its MRP system. The following records are typical of its planning system. The two records are for the Z-Wrench and for one of its component, the Z-Shaft. 3 2 201 4 1 5 3 6 45 5 | | | Z-Wrench 1 Gross Requirements | 2 | Schedule Receipt Proj. Avail. Balance 26 24 Proj. Order Receipt 0 Proj. Order Release 5 POQ = 3 weeks; LT = 2 weeks: SS = 0 units 0 4 0 4 5 3 10 0 45 0 45 2 0 3 0 456 45 0 0 Z-Shaft Gross Requirements 1 5 Schedule Receipt Proj. Avail. Balance 3 3 Proj. Order Receipt 1 0 Proj. Order Release 42 POQ = 3 weeks; LT = 3 weeks: SS = 0 units 3 0 3 0 0 42 0 0 0 0 a. Assume that week no.1 was executed as planned, a customer dropped an order of one (1) unit for the 2nd week, and a new customer order for 5 units was requested for week no. 7. Use the following spreadsheets to develop the MRP records for the 2nd week, and to answer the following questions. Week Z-Wrench Gross Requirements Scheduled Receipts Proj. Avail. Bal. P.O Receipt P.O. Release PQO=3 weeks; LT-2 weeks; SS=0 units Z-Shalft Gross Requirements Scheduled Receipts Proj. Avail. Bal. P.O Receipt P.O. Release PQO=3 weeks; LT-3 weeks; SS=0 units