311 HW 3

# 311 HW 3 - \$0.90 \$3,000.00 Constra int Equation Resource s...

This preview shows pages 1–3. Sign up to view the full content.

With the following constraints: With the following constraints: With the following constraints: 1. a) Profit = Max(\$1*Regular + \$3*Premium): Regul ar Premi um Total Changi ng Cells 0 15 Profit \$1.00 \$3.00 \$45.00 Regul ar Premi um Resource s Used Dough 1 1 15 <= 24 Chips 10 20 300 <= 300 b) See attached sheet c) Revenue is maximized by making 15 deluxe cookies and 0 regular cookies. Any other choice would yield less revenue, but would utilize more resources. For example, making 14 premium and 2 regular cookies would yield \$44 using 16 units of dough and the same amount of chips. 2. Graph is attached. The feasibility region changes. The max revenue is now \$60. Unlike the last problem however, the \$60 can be obtained in many different ways. It could be obtained by making 15 premium and 0 regular, as before, or one could make up to 18 regular and 6 premium, or anything in between as long as it falls within the constraints. 3. Excel Linear Program based on the equation Min(\$1.20*FuelA + \$0.90*FuelB)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Fuel A Fuel B Total Changi ng Cells 1000 2000 Cost \$1.20
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$0.90 \$3,000.00 Constra int Equation Resource s Used Minimu m Fuel FuelA+FuelB >= 3000 3000 > = 3000 Maximu m Fuel FuelA+FuelB <= 4000 3000 < = 4000 Fuel A Fuel A <= 2000 1000 < = 2000 Fuel B Fuel B <= 4000 2000 < = 4000 Octanag e (90*FuelA+75*FuelB)/ (FuelA+FuelB) 80 > = 80 b. Solved using book’s version of Excel. We must use 1000 gallons of fuel A and 2000 gallons of Fuel B. The answer& sensibility reports are attached at the end. 4. Excel Linear Program based on the equation Max(\$2000*Corn+\$2500*Soy+ \$3000*Wheat): Corn Soy Wheat Total Changi ng Cells 700 100 Cost \$2,000.0 \$2,500.00 \$3,000.00 \$1,650,000.00 Constra int Equation Resource s Used Total Land Corn+Soy+Wheat <= 900 800 <= 900 Labor .1*Corn + .3*Soy + .2*Wheat <= 100 100 <= 100 Fertiliz er .2*Corn + .1*Soy + .4*Wheat <= 150 150 <= 150 b) the excel answer & sensibility reports are attached at the end. c) The shadow price is \$0, because Land is NOT a constraint in this model....
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

311 HW 3 - \$0.90 \$3,000.00 Constra int Equation Resource s...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online