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. 

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"