Complete the following problems from the text using Microsoft Excel and Excel Solver:
- Problem 5.6 on page 190
- Problem 5.10, parts a, b, c, and f on page 194
- Problem 5.11, parts a, c, and e on page 194
- Problem 5.17 on page 195
- Problem 5.20 on page 196
You will be expected to submit a single fully functional, and clearly labeled Excel file that uses a separate spreadsheet for each problem. For each problem, you will be expected to submit a complete copy of your original work, including the complete linear programming model, your work in Excelâ€™s solver. No credit will be awarded for work that is not completed using Excel and Excelâ€™s solver, for which your Excel worksheet is not fully interactive, or for which your work shown is incomplete. If it is a graphing problem, you need to create the graph on the Excel spreadsheet.