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	10	40	10	40		10		40
Planned Shipments			60			60

Q = 60, LT = 1, ss = 10

1. Develop the DRP records above for periods two through four given demands of 37, 39, and 40 in periods one, two, and three. All answers in Excel with formulas
2. Complete the same records using the error addback method. What differences occur? All answers in Excel with formulas

(all information provided to compute the problem is accurate)