Read how to enable Solver (and the Analysis Tool Pack).
- Microsoft. (2018). Load the solver add-in in Excel (Links to an external site.). 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). Optimization methods in management science/operations research (Links to an external site.). 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.