Question 1 (25 marks) You are working for a pharmaceutical company and they have just produced a new wonder drug, Cureitall, which is administered in 4mg doses. The BOM for a dose of Cureitall is as follows: Cureitall (4 mg) Compound X (2 mg) Compound Y (1 mg) Compound Z (1 mg) Chemical A (1mg) Chemical B (1 mg) Chemical A (0.5 mg) Chemical C (0.5mg) Chemical C (0.5mg) Chemical D (0.5 mg) Complete the MRP records for Cureitall using the following information: The MPS has been converted from doses to milligrams to make planning easier - 4,250 doses = 17,000 mg. As a start the requirements for Compound X are in the ratio of 2:1 2mg required for each dose - hence to make 17,000 mg of Cureitall then 8,500 mg of Compound X are required. Note: your final calculations are to be submitted using the templates provided. + Cureitall (4mg = 1 dose) Week: 1 2 3 4 5 6 7 MPS due date 0 0 17,000 0 0 14,000 LT (weeks): 1 Start mixing 17,000 14,000 Week: 1 2 3 4 5 6 7 Compound X Required (mg) Gross requirements LT (weeks): 1 Scheduled receipts Projected ending inventory: 1,500 Net requirements Min. order: 20000 Planned receipts Planned orders Compound Y Week: 1 2 3 4 5 6 7 Required (mg) Gross requirements LT (weeks): 1 Scheduled receipts Projected ending inventory: 1,000 Net requirements Min. order: 5000 Planned receipts Planned orders Compound Z Week: 1 2 3 4 5 6 7 Required (mg) LT (weeks): Gross requirements 1 Scheduled receipts 200 Projected ending inventory: 0 Net requirements Min. order: 1 Planned receipts Planned orders Chemical A Required (mg) Week: 1 2 3 4 5 6 7 Gross requirements LT (weeks): 1 Scheduled receipts Projected ending inventory: 500 Net requirements Min. order: 9500 Planned receipts Planned orders Chemical B Week: 1 2 3 4 5 6 7 Required (mg) Gross requirements LT (weeks): 1 Scheduled receipts Projected ending inventory: 0 Net requirements Min. order: 4000 Planned receipts Planned orders Chemical C Week: 1 2 3 4 5 6 7 Required (mg) Gross requirements LT (weeks): 1 Scheduled receipts Projected ending inventory: 0 Net requirements Min. order: 2000 Planned receipts Planned orders Week: 1 2 3 4 5 6 7 Chemical D Required (mg) Gross requirements LT (weeks): 1 Scheduled receipts Projected ending inventory: 3,000 Net requirements Min. order: 1 Planned receipts Planned orders