1. Formulate and solve this problem as a Linear Programme in Excel.
2. Solve the integer form and the LP relaxation. Produce the sensitivity report for the LP
relaxation.
3. Using the above output, analyse the above case and write a report for Lisa Rodriguez
advising her how she should spend her money. The report should include:
• Statement of the recommended solution.
• Detailed Discussion of the interpretation of the sensitivity report.
• Discussion of assumptions made in applying Linear Programming to Lisa’ problem.
• Formulation of the Linear Programming problem. Additionally, you should provide the
rationale behind the strategy followed to formulating the mathematical programming
model.
• Screenshots of the Excel spreadsheet model.
• Extended analysis that would be useful to Lisa followed by more general suggestions,
including a statement of requirements to carry out the extended analysis. Specifically you should also make suggestions on how this project could be properly expanded to
potentially accommodate other equally important needs.