[fireant911]

kycarguy 935,
ChkbookMechanic is indeed correct about setting up the contraint equations. I realize that your assignment is to, in part, write the linear programming model; however, EXCEL has the little-used capability of setting up and solving some rather complex linear programming models. This feature is called Solver. The instructions accompanying this feature are, in my opinion, inadequate yet it is a pretty robust tool. If nothing else, it can serve as a mechanism to set up your constraints (which is essentially the most important part of the assignment). This Solver can handle 100 constraints therefore your assignment can be easy mastered and a solution found.

As a side note, I taught Cost Analysis at the university and I always incorporated EXCEL's Solver as part of the class - in my opinion, it is EXCEL's best kept secret. If interested, I can send you a problem that I used in class along with a detailed walkthrough of setting up this same problem.