2. The supervisor of a production company is trying to determine the number of two assembling parts, Pan X and Pan Y to be produced per day in three different 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 Section 3 Prot/Unit Partx 50 30 18 $2 PartY 80 45 22 $3 Available time (minutes) 3600 2500 1200 Each part made (X and Y) must be processed in each of the three sections. No more than 60 units of Part X can be produced, but 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 satised. 1. Develop a linear programming model for this problem. (Excel only- do not turn in. Only use your model to solve and record answers to questions below. The le LP Template is provided with the exam.) 2. What is the optimal solution in terms of the objective function AND the decision variables? 3. What are all of the constraints for this model? Are any of the constraints redundant? Briey explain. 4. If more time could be made available for section 2, how much would it be worth? Explain briey