Solving linear programming problems in a spreadsheet yields equations for maximizing business profits. ... Select the variable names, and one column to the right of these names.

One way to solve them is to manipulate one equation and define one variable in terms of the other two. For example, 0 c + 1 r + 2 g = 10 turns into r = 10 – 2 g . Substitute that value for r in the ...