Docstoc

xls

Document Sample
xls Powered By Docstoc
					Microsoft Excel 12.0 Answer Report
Worksheet: [701-DeadLP.xlsx]Sheet1
Report Created: 10/21/2008 9:08:58 PM


Target Cell (Max)
    Cell      Name    Original Value Final Value
   $F$3 MAX                     1450        3130



Adjustable Cells
    Cell     Name     Original Value Final Value
  $D$4 Sweatshirts                 10          44
  $E$4 Tshirts                     50          90



Constraints
   Cell     Name        Cell Value        Formula   Status   Slack
  $F$7 Time                          56 $F$7<=$H$7 Binding       0
  $F$8 Space                         40 $F$8<=$H$8 Binding       0
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [701-DeadLP.xlsx]Sheet1
Report Created: 10/21/2008 9:08:58 PM


Adjustable Cells
                       Final Reduced Objective Allowable Allowable
   Cell   Name         Value   Cost   Coefficient Increase Decrease
  $D$4 Sweatshirts        44        0          20      42.5      7.5
  $E$4 Tshirts            90        0          25        15       17

Constraints
                       Final Shadow Constraint Allowable Allowable
   Cell   Name         Value  Price   R.H. Side  Increase Decrease
  $F$7 Time               56     42.5         56        44       36
  $F$8 Space              40    18.75         40        72     17.6
Microsoft Excel 12.0 Limits Report
Worksheet: [701-DeadLP.xlsx]Limits Report 1
Report Created: 10/21/2008 9:08:58 PM



         Target
   Cell  Name         Value
  $F$3 MAX             3130



        Adjustable              Lower Target    Upper Target
   Cell   Name        Value      Limit Result   Limit Result
  $D$4 Sweatshirts       44           0 2250       44 3130
  $E$4 Tshirts           90           0  880       90 3130
Microsoft Excel 12.0 Answer Report
Worksheet: [701-DeadLP.xlsx]Sheet1
Report Created: 10/21/2008 9:23:11 PM


Target Cell (Max)
    Cell      Name    Original Value Final Value
   $G$3 MAX                     3130        3130



Adjustable Cells
    Cell     Name     Original Value Final Value
  $D$4 Sweatshirts                 44          44
  $E$4 Tshirts                     90          90
  $F$4 Ponchos                      0           0



Constraints
   Cell     Name        Cell Value        Formula   Status   Slack
  $G$7 Time                          56 $G$7<=$I$7 Binding       0
  $G$8 Space                         40 $G$8<=$I$8 Binding       0
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [701-DeadLP.xlsx]Sheet1
Report Created: 10/21/2008 9:23:11 PM


Adjustable Cells
                       Final Reduced    Objective    Allowable Allowable
   Cell   Name         Value   Cost     Coefficient   Increase Decrease
  $D$4 Sweatshirts        44         0            20       42.5       7.5
  $E$4 Tshirts            90         0            25         15       17
  $F$4 Ponchos             0    -19.25 5.000000001        19.25    1E+30

Constraints
                       Final Shadow       Constraint Allowable Allowable
   Cell   Name         Value  Price        R.H. Side   Increase Decrease
  $G$7 Time               56     42.5               56        44       36
  $G$8 Space              40    18.75               40        72     17.6
        Sweatshirts        Tshirts         Ponchos
MAX                   20             25              5   3130
                      44             90              0

s.t.
Time             0.25                0.5        0.35       56   <=   56
Space             0.5                0.2         0.5       40   <=   40
                    1                  0                   44   >=    0
                    0                  1                   90   >=    0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:3/15/2013
language:Unknown
pages:6