Unformatted text preview: permitted in the formulas for these products. The allowable percentages, along with the revenue and cost data, are given the table below. INGREDIENT SALES PRICE PER LITER SAUCE A B $ Spicy Diablo a least 25% at least 50% 5.35 Mild Red Baron at most 75% * 4.85 Cost per liter $1.60 $2.59 *No explicit maximum or minimum percentage. Up to 40 liters of A and 30 liters of B could be purchased. RJCK can sell as much of these sauces as it produces. The objective is to maximize the net revenue from the sale of the sauces. For EACH of the problem above make sure to: a. Formulate the algebraic LP formulation b. Find the optimal solution using Solver. (Provide a printout of the Answer report and the Excel spreadsheet formulation). Fall 2010 Page 1...
View
Full Document
 Fall '05
 EL
 Mild Red Baron, RJCK Inc.

Click to edit the document details