4) 39.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. Each part must be processed in three sections of the plant. The time required for the production along with the profit contribution for each part are given in the following table. Time required (Minutes/Unit) Section 1 Section 2 50 30 8045 Section 3 18 Profit/Unit $2 $3 Part X Part Y Available time (minutes) No more than 60 units of Part X and up to 70 units of Part Y can be produced per day. The company already has orders for 30 units of Part Y that must be satisfied. 3600 2500 1200 a. Develop a linear programming model and solve the model with SOLVER to determine the optimal production quantities of Parts X and Y. b. If more time could be made available in Section 2, how much would the profit increase? (Hint: Generate Answer Report)