Solver (and the Analysis Tool Pack)
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=USComplete 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.pdfUse Excel file with the worked solution.