• Author / Uploaded
• Nirav Parikh

• Categories
• Matemáticas
• Business

Citation preview

Microsoft Excel 12.0 Answer Report Worksheet: [chase manhattan bank FINAL.xls]Sheet1 Report Created: 23-08-2010 23:01:53

Target Cell (Min) Cell Name $AA$2 MINIMIZE

Adjustable Cell $B$16 $C$16 $D$16 $E$16 $F$16 $G$16 $H$16 $I$16 $J$16 $K$16 $L$16 $M$16 $N$16 $O$16 $P$16 $Q$16 $R$16 $S$16 $T$16 $U$16 $V$16 $W$16 $X$16 $Y$16 $Z$16

Original Value 3099.26

Final Value 3099.26

Original Value 20 9 0 0 0 0 0 0 0 0 0 9 3 0 0 12 0 0 0 3 0 0 5 0 0

Final Value

Cells

Constraints Cell $AA$3 $AA$4 $AA$5 $AA$6

Name SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE SOLUTION VALUE

Name CONSTRAINT 1 CONSTRAINT 2 CONSTRAINT 3 CONSTRAINT 4

F0 F1 F2 A B C D E F G H I J K L M N O P Q R S T U V

Cell Value

Formula 29 $AA$3>=$AC$3 29 $AA$4>=$AC$4 26 $AA$5>=$AC$5 41 $AA$6>=$AC$6

20 9 0 0 0 0 0 0 0 0 0 9 3 0 0 15 0 0 0 0 0 0 5 0 0

Status Not Binding Not Binding Binding Not Binding

$AA$7 $AA$8 $AA$9 $AA$10 $AA$11 $AA$12 $AA$13

CONSTRAINT CONSTRAINT CONSTRAINT CONSTRAINT CONSTRAINT CONSTRAINT CONSTRAINT

5 6 7 8 9 10 11

55 $AA$7>=$AC$7 60 $AA$8>=$AC$8 51 $AA$9>=$AC$9 34 $AA$10>=$AC$10 14 $AA$11>=$AC$11 9 $AA$12>=$AC$12 128 $AA$13= >= >= >= >= >= >= >= >= >= = >= >= >= >= >= >= >= >= >= = 29 >= 26.5 >= 41.5 >= 56 >= 61 >= 52 >= 34 >= 14 >= 9 >= 131 = >= >= >= >= >= >= >= >= >= = >= >= >= >= >= >= >= >= = >= >= >= >= >= >= >= >= = >= >= >= >= >= >= >= >= = >= >= >= >= >= >= >= >= = >= >= >= >= >= >= >= >= = >= >= >= >= >= >= >= >=