Solving linear programming problems in a spreadsheet yields equations for maximizing business profits. ... Excel's Solver add-in provides a simple way to solve problems involving such formulas.