"ormulas Data Review View Analytic X Calibri (Body) 11 A A == v Paste BIU V a. Av K16 x fox A B D E F G 1 The supervisor of a manufacturing plant is trying to determine how many of two parts, Part X and Part Y, are to be produced per day 2 Each part must be processed in three sections of the plant. The time required for the production along with the profit contribution 3 for each part are given in the following table. No more than 60 units of Part X and up to 70 units of Part Y can be produced per day. 4 The company already has orders for 30 units of Part Ythat must be satisfied. 5 Develop a linear programming model and solve the model to determine the optimal production quantities of Parts X and Y. 6 7 8 Time required (Minutes/Unit) 9 Section 1 Section 2 Section 3 Profit/Unit 10 Part X 50 30 18 $2 24 30 11 Part Y 80 45 22 $3 Available time 3600 12 (minutes) 2500 1200 13 14 15 16 17 HH n DIN