The production planner for a private label soft drink maker is planning the production of two soft drinks: root beer (R) and sassafras soda (S). Two resources are constrained: production time (T), of which she has at most 15 hours per day; and carbonated water (W), of which she can get at most 1,200 gallons per day. A case of root beer requires 4 minutes of time and 5 gallons of water to produce, while a case of sassafras soda requires 3 minutes of time and 5 gallons of water. Profits for the root beer are $5.00 per case, and profits for the sassafras soda are $4.00 per case.
(1) Formulate an LP problem?
(2) Solve the LP problem by using excel solver?