Question 1 (25 marks) You are working for a pharmaceutical company and they have just produced...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
A student completed 5 assessments to evaluate their stress levels; however, you were only provided 4 scores: 23, 29, 31, 36. If know the median score was 31, what is the missing score
-
n 1) Suppose X1, X2, ..., X is a random sample from the GAM (, 1) distribution which has probability density function: x-1e-x f(x; ) = (a) for x > 0. Calculate the score and information functions for...
-
Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...
-
The regression of the X and Y equation is Y = 48.32 -2.105X, What is the slope of the data.
-
Why might a spreadsheet be helpful when completing the statement of cash flows?
-
Zaid decides to form a band. He needs a bass player, a guitarist, a keyboard player and a drummer. He invites applications and gets 6 bass players, 8 guitarists, 4 keyboard players and 3 drummers....
-
How is the contribution margin per unit used?
-
PowerTap Utilities is planning to issue bonds with a face value of $1,000,000 and a coupon rate of 10 percent. The bonds mature in 10 years and pay interest semiannually every June 30 and December...
-
Projected legal fees is an example of which element? Question 1Answer a. Factory overhead b. Production budget c. Sales and administrative expense budget d. Direct labor budget
-
Begna Chemicals has projected sales of its product for the next year on a quarterly basis as follows: Quarter Sales (units) 1 st 600 2 nd 900 3 rd 1200 4 th 720 The finished product requires 4 liters...
-
Match the professional with the appropriate client need. Question 1 options: Discount Broker Insurance Agent Certified Financial Planner Registered Investment Advisor 1. James wants ongoing support...
-
A circular object is pushed into a v-shaped slot by a force F as shown in the figure below. The weight of the object is negligible compared to the external force. The v-shaped slot consists of two...
-
Discuss the relationship between the yield curve and swap curve in 2016 and today. Think about the following strategy: [1] Borrow at LIBOR [2] buy a government bond [3] enter a swap to pay fixed, and...
-
Can you elaborate on the concept of ecosystem services and their role in underpinning sustainable practices in agriculture, forestry, and fisheries, especially in the context of balancing economic...
-
i need help solving the error coding below, i use programing language c# please provide steps of how you fixed these problems, showed how you fixed them, and making sure the code runs fine thank you,...
-
Jay is an employee and 15% shareholder of Rick's Welding Shop Ltd. (Rick's). During the 20X7 calendar year, Jay was having cash flow problems. Rick gave Jay a loan of $5,000 on May 1, 20X7 to help...
-
Repeat the previous problem, but close the positions on September 20. Use the spreadsheet to find the profits for the possible stock prices on September 20. Generate a graph and use it to identify...
-
Which of the following statements is true? a. Encrypting data is sufficient to protect confidentiality and privacy. b. Cookies are text files that only store information and cannot do anything. c. A...
-
Which of the following is designed to identify entry of a nonexistent customer account number? a. sequence check c. completeness check b. field check d. validity check
-
A batch total that is calculated by summing the part numbers sold in a batch of 50 sales invoices is called a a. financial total c. record count b. hash total d. part count
Study smarter with the SolutionInn App