In Excel 2010, 2011, and 2013, make sure the solving method is set to Simplex LP. Simplex LP is appropriate for this problem, because this problem is linear (the “L” in LP stands for linear).

Excel's MOD function doesn't have to be used to return a value—it can also be used to determine which cells should be formatted through conditional formatting.

As the title suggests, I have a problem in which I need to formulate an LP model. I'm supposed to work in Excel and use the Solver Add-in feature.I've done several other problems already, but this ...