Please provide answer in excel format.

2. Bob Stahl, the distribution manager at Forbes Industries, is considering using error addback for his DRP system. To evaluate its use, he compiled data for three periods on a sample product, the Scarlet Tiara. The initial DRP record is given here: Week 1 2 3 4 5 Forecast Requirements 30 30 30 30 30 In Transit | 60 Projected Available Balance 40 1040 1040 Planned Shipments 60 Q=60, LT = 1, ss = 10 a. Develop the DRP records above for periods two through four given demands of 34, 35, and 37 in periods one, two, and three. b. Complete the same records using the error addback method. What differences occur? 60 2. Bob Stahl, the distribution manager at Forbes Industries, is considering using error addback for his DRP system. To evaluate its use, he compiled data for three periods on a sample product, the Scarlet Tiara. The initial DRP record is given here: Week 1 2 3 4 5 Forecast Requirements 30 30 30 30 30 In Transit | 60 Projected Available Balance 40 1040 1040 Planned Shipments 60 Q=60, LT = 1, ss = 10 a. Develop the DRP records above for periods two through four given demands of 34, 35, and 37 in periods one, two, and three. b. Complete the same records using the error addback method. What differences occur? 60