This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 02/13/2011 for the course ADM 2302 taught by Professor El during the Fall '05 term at University of Ottawa.
 Fall '05
 EL

Click to edit the document details