Problem B: Using the information in the table provided: (1) complete the inventory record as it...

Transcribed Image Text:

Problem B: Using the information in the table provided: (1) complete the inventory record as it would appear at the beginning of week 1; and (2) complete the inventory record as it would appear at the beginning of week 2 after all exception messages have been implemented. Scheduled receipt M1= 75 units Scheduled receipt M2= 75 units Planned lead time Minimum order quantity = 7 weeks = 75 units Week 1 2 3 4 5 6 7 Gross reqs 20 25 30 35 21 22 Sched recpts 8 9 10 15 30 M2 Proj avail bal 85 Planned ord rel Actual Week 1 Events: a. The cancellation of a customer order changed the gross requirement from period 5 to zero. b. An unexpected customer order changed the gross requirement in week 3 to 32 units. c. Gross requirements for week 9 were projected to be 50 units. d. 25 units were issued from stock. e. An inventory count resulted in an adjustment of -5 units to the inventory balance f. Gross requirements for week 10 were projected to be 32 units Note: You can use either the workspace below or a blank MRP sheet posted on Canvas for this problem. 1 2 3 4 5 6 7 8 9 10 Gross requirements Scheduled receipts Proj avail balance Planned order release Gross requirements Scheduled receipts Proj avail balance Planned order release Gross requirements Scheduled receipts Proj avail balance Planned order release 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 16 7 8 9 10 Problem B: Using the information in the table provided: (1) complete the inventory record as it would appear at the beginning of week 1; and (2) complete the inventory record as it would appear at the beginning of week 2 after all exception messages have been implemented. Scheduled receipt M1= 75 units Scheduled receipt M2= 75 units Planned lead time Minimum order quantity = 7 weeks = 75 units Week 1 2 3 4 5 6 7 Gross reqs 20 25 30 35 21 22 Sched recpts 8 9 10 15 30 M2 Proj avail bal 85 Planned ord rel Actual Week 1 Events: a. The cancellation of a customer order changed the gross requirement from period 5 to zero. b. An unexpected customer order changed the gross requirement in week 3 to 32 units. c. Gross requirements for week 9 were projected to be 50 units. d. 25 units were issued from stock. e. An inventory count resulted in an adjustment of -5 units to the inventory balance f. Gross requirements for week 10 were projected to be 32 units Note: You can use either the workspace below or a blank MRP sheet posted on Canvas for this problem. 1 2 3 4 5 6 7 8 9 10 Gross requirements Scheduled receipts Proj avail balance Planned order release Gross requirements Scheduled receipts Proj avail balance Planned order release Gross requirements Scheduled receipts Proj avail balance Planned order release 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 16 7 8 9 10