Use Excel and do not copy others answer, thank you.

15. Lal Inc. manufactures two grades of steel pipes: Standard and Stainless. There is unlimited demand for both of these types in market. Each type of pipe has to go through four processes: heat treating, molding, smearing, and finishing. The table below shows Profit is $400 per pallet for standard and $500 per pallet for stainless. HEAT TREATING MOLDING SMEARING FINISHING 96 minutes 4 hours 80 minutes 10 hours STANDARD IPALLET) STAINLESS (PALLET) CAPACITY (HOURS) 146 minutes 6 hours 240 minutes 8 hours | 32 1920 60 3600 32 1920 28 1680 a. Formulate an LP to maximize the total profit. b. Create a spreadsheet model of your LP and use Solver to find the optimal solu- tion. Attach your spreadsheet model and sensitivity reports to your homework. What is the optimal solution? What is the maximum total profit? c. How much excess capacity does Lal have for each process? Heat treating: Molding: Smearing Finishing: Use your sensitivity reports only without resolving to answer parts d and e. Consider each question independent of the other. d. The price of a pallet of stainless pipe has dropped by $100 due to a glut in the market. Will the production plan change? How will this affect the total profit? e. The price of a pallet of standard pipe has dropped by $100 due to a glut in the market. Will the production plan change? How will this affect the total profit