Video 2: Using Excel Solver to Solve a Given Mathematical Model

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 used in Excel solver to find the optimal solution. It also organizes the spreadsheet in a way that the data and the solution found by the solver are readable. You can view where to enter what kind of constraints (i.e., >=, <=, or =) and decision variables (binary, integer, or continuous) are in the model. After watching it, please go to the survey form below, and rate this video and leave your comments.