1)Homework problems are
listed in file “mat540 hw wk7”.
2)Download the homework
template Excel file “Hw7_2015_Fall_Template”.
Do not insert or remove columns or rows. You must use this template for your
homework. Other templates will not be
3)You are required to use
the Excel Solver to solve the LP problems and generate the “Sensitivity
Analysis Report”. Please see the video
“Installing Solver” in Week 6 Instructor Insights for the procedure of Solver
installation. The videos “Beaver Creek
Sensitivity Analysis” in the Instructor Insights explain how to generate and
analyze the sensitivity reports.
Do the homework and enter your answers in the
cells highlighted in yellow. I will
grade only answers in the cells highlighted in yellow. You must show how you obtain the answers
using embedded Excel formula.