Question: Tom owns a paint store, and must determine how much paint to buy. Tom stocks 3 colors of paint, yellow, slate and red. The cost per gallon (for Tom) for each color is:

Tom has a budget of $2,000 for paint. Tom sells yellow for $3.00 per gallon, slate for $2.50 per gallon, and red for $1.75 per gallon. Maximum customer demand is estimated to be 400 gallons yellow, 500 gallons of slate, and 300 gallons of red. The store has a capacity to stock 1,000 gallons of paint; Tom wants to stock up completely. Determine the number of gallons of each brand of beer to order so as to maximize profit.

a. Formulate a linear programming model for this problem (written in a format similar to the way Problems A and B were presented).

b. Solve this problem by using MS Excel & Solver.