Submit homework for the following Problems 7-16, 7-17, 7-18, 7-19, and 7-36. Not

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 input cells in blue and all outputs in green. Build all formulas in the Excel worksheet so that all outputs are automatically calculated based on the input variables. Sample problems including correct formatting will be completed in the weekly (online) classroom session. To make the best use of the classroom session you should attempt all the homework problems prior to the classroom session so you can ask very specific questions to help you complete the homework. This homework will address the learning objectives of applying the proper tools to solve LP problems using the graphical method as well as demonstrating situations where special issues in LP such as infeasibility, unboundedness, redundancy, and alternative optimal solutions may apply.