The aim of this video is to demonstrate how to use Excel solver to solve mathematical models to optimality. The video includes the formulation of the Weighted Set Cover Problem to Opening Coffee Shops and presents the steps to find the optimal solution. It also organizes the spreadsheet in a way that the data and the solution found by the solver is readable.
Please feel free to visit my website at and contact me if you have any comments or questions.
