311 HW 3

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

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

View Full Document Right Arrow Icon
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)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Fuel A Fuel B Total Changi ng Cells 1000 2000 Cost $1.20
Background image of page 2
Background image of page 3
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

This note was uploaded on 04/16/2008 for the course BUAD 311 taught by Professor Vaitsos during the Spring '07 term at USC.

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 Right Arrow Icon
Ask a homework question - tutors are online