these problems must be solved using both the graphical and solver methods. Homework instructions: Complete the homework problems identified above in Excel. Put each problem on a separate worksheet (tab). Restate the homework problem at the top of each worksheet. Code all input cells in blue and all outputs in green. Build all formulas in…

Submit homework for the following Problems 7-16, 7-17, 7-18, 7-19, and 7-36. Note these problems must be solved using both the graphical and solver methods. Homework instructions: Complete the homework problems identified above in Excel. Put each problem on a separate worksheet (tab). Restate the homework problem at the top of each worksheet. Code all…