it must be in excel

Linear Programming Project 10 Points Due date: October 29, 2020 Parameters: All projects must be typed, can work in groups of no more than three, and all projects are given to me via the Assignments folder in D2L. Problem: A manufacturer produces four parts: XJ201, XM897, TR29, and BR788. The net profits per unit are $9, $12, S15, and $11 respectively. The products are each processed in the wiring and drilling departments then go to assembly. The final step in the plant is a final inspection. The time in minutes spent at each of the four departments is listed in the following table: Part A Requirements: 1) Give a typed formulation with decision variables clearly defined and all constraints clearly defined. (2 pts) 2) Solve the formulation in solver and save the Sensitivity Report. (2 pts) 3) Using Sensitivity Analysis: If sales can increase the quantity of the firm contract for XM897 to 110 units, should the operations manager allow the increase? Justify your answer. (1 pt) 4) Using Sensitivity Analysis: A local college student offers to work in any of the four departments for a maximum of 8 hours and is willing to work for $8.00/hour. Should the operations manager hire the college student? If so, how many hours should the college student work in each department? How much will profits increase?(1 pt) Part B The marketing department has set two additional production requirements: 1) Production of TR29 can be no more than one-third of the total production of all four products. 2) The production of BR788 has to be exactly twice as great as the production of XM897 Requirements: 1) Give a typed formulation with decision variables clearly defined and all constraints clearly defined. (2 pts) 2) Solve the formulation in solver. (2 pts) Linear Programming Project 10 Points Due date: October 29, 2020 Parameters: All projects must be typed, can work in groups of no more than three, and all projects are given to me via the Assignments folder in D2L. Problem: A manufacturer produces four parts: XJ201, XM897, TR29, and BR788. The net profits per unit are $9, $12, S15, and $11 respectively. The products are each processed in the wiring and drilling departments then go to assembly. The final step in the plant is a final inspection. The time in minutes spent at each of the four departments is listed in the following table: Part A Requirements: 1) Give a typed formulation with decision variables clearly defined and all constraints clearly defined. (2 pts) 2) Solve the formulation in solver and save the Sensitivity Report. (2 pts) 3) Using Sensitivity Analysis: If sales can increase the quantity of the firm contract for XM897 to 110 units, should the operations manager allow the increase? Justify your answer. (1 pt) 4) Using Sensitivity Analysis: A local college student offers to work in any of the four departments for a maximum of 8 hours and is willing to work for $8.00/hour. Should the operations manager hire the college student? If so, how many hours should the college student work in each department? How much will profits increase?(1 pt) Part B The marketing department has set two additional production requirements: 1) Production of TR29 can be no more than one-third of the total production of all four products. 2) The production of BR788 has to be exactly twice as great as the production of XM897 Requirements: 1) Give a typed formulation with decision variables clearly defined and all constraints clearly defined. (2 pts) 2) Solve the formulation in solver. (2 pts)