Develop an MRP record, similar to the one in Figure 4-17, for wheat germ for the five weeks of January. Wheat germ must be ordered in bulk-container quantities, so the planned orders must be in multiples of 2,000 pounds. Use a lead time of one week and an initial on-hand inventory of 3,184 pounds; assume that an order of 8,000 pounds is scheduled for receipt during Week 1. Are there any weeks when you, as a planner, would consider placing an order above or below the minimum required? Why? (Assume that there are no problems with storage capacity or shelf life.)

Oats Lead time = 2 weeks Week 1 Week 2 Week 3 MPS NRG-A 984 984 984 (cases) NRG-B 422 422 422 MPS NRG-A 142 142 142 (500 lb. batches) NRG-B 61 61 61 Gross requirements (lb) 57,850 57,850 57,850 Scheduled receipts 44,000 44,000 Planned receipts 88,000 On hand 29,650 15,800 1,950 32,100 Planned orders 88,000 44.000 44,000 Source Line: Course Technology/Cengage Learning. FIGURE 4-17 The MRP record for oats in NRG bars, Weeks 1 through 5 Week 4 984 422 142 61 57,850 44,000 18,250 - Week 5 1037 444 149 64 60,700 44,000 1,550