Please do it fast. Please do all questions especially the last part " The product tree (Bill of Materials) for Product Y is shown below"

thank you

Business Background: Company A makes two types of product, X and Y. The following is the 6 months forecast demand for X and y The capacity information of Product Y is listed below. Regular Capacity - 140 unit per month Product Regular Cost - 5600 per unit. December Month Demand Product Y July 100 August 110 September 120 October 140 November 100 OT Capacity-40 unit per month 100 OT Cost - 5760 per unit Month Demand July 140 August 150 September 180 October 170 November 140 December 140 Subcontract Capacity - 50 unit per month Subcontract Cost - $960 per unit Holding Cost - $220 per unit per month Company A uses P chart to track operation performance. The p chart of each products is shown below (p stands for the proportion of defects; this include both regular production and of production). The defect product will be scrapped. Backlog - NOT allowed. P Chart for X With the above information, establish the Aggregate plan for the following three options 1. Option 1, use regular, ot and subcontract to satisfy all the demand. 2. Option 2, use regular, OT and inventory to satisfy all the demand. 2, 3. Option 3, use regular, OT, subcontractor and inventory to satisfy all the demand. 0.0580 0.0560 The product tree (Bill of Materials) for Product Y is shown below: 00540 0.05.20 0.0500 0.0480 0.0460 0.000 P-Y 0.0420 A(2 B(4 C3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 PCenter UCL CL K(2 KES K5 P Chart for Y C (3 D (3 0.0680 0.0560 0.0640 0.0520 K(2 K2 0.0500 OLOS 80 0.05 60 OLOS 40 0.05 20 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 9 Construct the ERP plan of July and August for Product Y, use the best option from Question 3 with the following assumptions: 1. Assume there are 4 weeks for each month. 2. The lead time for each level is ONE week. 3. There is no inventory on hand. 4. Product Y are needed in beginning of Week 4 and Week 8. P-Center UCLLCL