Excel contains a feature called Solver that does a fine job of not-too-large
linear programming problems.
If you model is very big and the need is real (not just academic exercise)
visit www.weloveasparagus.co.uk to learn about their applications
best wishes
--
Bernard Liengme
Microsoft Excel MVP