Product QC238 is only stocked at the Manufacturing Company's Irish Depot and at the company's plant warehouse in the France. Product QC23B is manufactured at the firms France plant using 20 units of Quantum B per unit of Product QC23B. The sales director has forecast product sales from the Irish Depot to be 380 units per week. Complete the Materials Requirement Plan Record for Quantum B as well as the DRP records for Product QC23B at the Irish warehouse and the French Plant, There is a fixed batch order quantity of 60, batches are ordered/supplied to match forecast demand. Use following information to complete this question Week 1 2 3 4 5 6 7 00 8 Product QC23B Irish Warehouse Forecast requirements In Transit Projected 86 available balance Planned Shipments Q = 60, SS = 127 units, LT=2 Weeks Week 5 1 2 3 4 6 7 8 Product QC238 France Plant Gross requirements Scheduled Receipts Projected 560 available balance Planned Order Release Q = 60, SS = 50 units, LT = 1 Weeks Week 5 3 4 6 7 8 Quantum 8 12 Gross requirements Scheduled Receipts 4480 Projected 3200 available balance Planned Order Release Q = 320, SS = 120 units, LT 1 Weeks