Prepare a material requirements plan for component D.D can only be ordered in whole cases (50 units per case). One case of Dis automatically received every other week, beginning in week 1 (.e., weeks 1,3,5,7). Also, there are 30 units of B and 20 units of D now on hand. Lead times for all items are a function of quantity: one week for up to 100 units, two weeks for 101 to 200 units, three weeks for 201 to 300 units, and four weeks for 301 or more units. (Leave no cells blank - be certain to enter "o" wherever required.) Bog. Inv. 2 3 5 6 B Part D Gross requirements Scheduled receipts On hand Net requirements Planned-order receipt Planned-order release