Read how to enable Solver (and the Analysis Tool Pack).
- Microsoft. (2018). . Retrieved from https://support.office.com/en-us/article/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca?ui=en-US&rs=en-US&ad=US
Complete the example (not the practice problem at the end).
- Massachusetts Institute of Technology. (2013). . Excel Techniques. Retrieved from https://ocw.mit.edu/courses/sloan-school-of-management/15-053-optimization-methods-in-management-science-spring-2013/tutorials/MIT15_053S13_tut03.pdf
Submit your Excel file with the worked solution.