{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# estradaHW9.7 - HartmanCompany a Letx1= x2= Max 30x1 15x2...

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

Hartman Company a. Let x1 = units of product 1 produced x2 = units of product 2 produced Max 30x1 + 15x2 s.t. x1 + .35x2 < = 100 .3x1 + .2x2 <= 36 .2x1 + .5x2 <= 50 x1 x2 77.89 63.16 Max Profit 30 15 3284.21 A 1 0.35 100.00 100 B 0.3 0.2 36.00 36 C 0.2 0.5 47.16 50 b. Schedule ovetime for A and B. (See Sensitivity Report) A = \$15.79 B = \$47.37

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book2]CH4 #2 a.b. Report Created: 9/12/2010 6:25:27 PM Adjustable Cells Final Reduced Cell Name Value Gradient \$C\$11 x1 77.89 0.00 \$D\$11 x2 63.16 0.00 Constraints Final Lagrange Cell Name Value Multiplier \$E\$14 A 100.00 15.79 \$E\$15 B 36.00 47.37 \$E\$16 C 47.16 0.00
G. Kunz and Sons Inc x1 = units of product 1 x2 = units of product 2 b1 = labor-hours Dept. A b2 = labor-hours Dept. B Max 25x1 + 20x2+0b1+0b2 s.t 6x1 + 8x2-b1=0 12x1+10x2-b2=0 b1+b2<=900 x1 x2 b1 b2 Total 50 0 300 600 Cost 25 20 0 0 1250 A 6 8 -1 0 0 B 12 10 -1 0 0 Total Hrs 1 1 900 900

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

View Full Document
Shore Financial Services A. MAX  0.1S+0.03B+0.04M+0.01C S.T. 1S+1B+1M+1C=1 0.8S+0.2B+0.3M<0.4 1S<0.75  -1B+1M>0  1C>0.1  1C<0.3 S B M C 0.409 0.145 0.145 0.300 MAX RETURN 0.1 0.03 0.04 0.01 0.054 RETURN 1 1 1 1 1 1 RISK 0.8 0.2 0.3 0.4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 12

estradaHW9.7 - HartmanCompany a Letx1= x2= Max 30x1 15x2...

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

View Full Document
Ask a homework question - tutors are online