LP Solver template (case of two decision variables) 2 STEP 1 - Set up spreadsheet Follow instructions shown below 5 Variables x 1 x 2 6 0 0 Solver will place optimum values of decision variables here, once a solution is found 8 Parameters x 1 x 2 9 Objective function (e.g. profit) Enter all relevant parameter values into pink cells in this section 10 Resource 1 11 Resource 2 12 Add more rows and information for other constrained resources as needed 13 14 Objective function 15 E.g. Profit/Revenue 0 Solver will place the optimum value of the objective function here, once a solution is found 16 17 Constraints LHS RHS 18 Resource 1 = O O 22 A 23 These are for reference only; change >= to