Please answer Question #2 for this question! I will give thumbs up! Thank you very much!

MGMT 366 - Operations Management Assignment #3 Total: 15% (Question 1 = 10% & Question 2 = 5%) 1. Consider the bill of material for Product S and the data given in the following table. The gross requirements for S are 100 units in week 7. Develop the Net Requirement Plan tables for each item for a 7-week planning period. Use the lot-for-lot lot-sizing rule. Level 0 Product Structure for Product S S 1 T(1) U(2) 2 V(1) W(2) X(1) Y(2) Z(3) Item S T U V w Y Z Lead Time Quantity on Hand 2 20 1 20 2 40 2 30 3 30 1 25 2 240 1 40 Time-Phased Structure V W T X S Y U z CH 2 3 1 4 Week 1 6 5 7 Net Requirement Plan table for S: Week 3 4 Lead Time (weeks) 1 2 5 6 8 Item S On hand Gross reg 7 1100 20 80 80 Net red 2 Order receipt Order release 80 2. Jack Ma, president of Alibaba Manufacturing Corp., wants to create a portfolio of suppliers for the motors used in the company's products that will represent a reasonable balance between costs and risks. Based on historical data, Jack estimates that the probability of a "super-event that would negatively impact all suppliers simultaneously to be 0.8%, and the "unique-event" risk for any potential suppliers to be 4%. Estimating the marginal costs of maintaining a supplier to be $5,000 and the financial loss incurred if a disaster caused all suppliers to be down simultaneously is $1,000,000. How many suppliers should Jack use? There are up to 3 similar suppliers available. If recent events suggests that the probability of "super-events has increased to 50%, how many suppliers are needed now? Note: Show all calculations