18 A D E F H 1 M 0 G 1 Problem 1. In the following MRP planning schedule for item indicate the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. Lead time one week 4 week number S Item 0 1 2 3 5 Gross requirements 75 50 70 7 On-hand 40 Net requirements Planned order receipt 10 Planned order release 11 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarters, the second most recent 25, and the third 25. Do the problem using quarters, as 12 opposed to forecasting separate months. 13 14 week number Insert your formula in these te week num 35 Item 1 2 5 cells. Remember that all formulas Item 1 2 16 Gross requirements 75 50 70 begin with a Gross requirements 75 17 On-hand 40 0 0 0 Onhand 40 Net requirements 50 70 Net requirements Panned order receipt 50 70 Planned order recept 20 Planned order relea 50 70 Planned order release 21 4 0 0 21 24 25 26 27 29 10 31 33 Chapter Problemi Probleme