McCormick by hedongchenchen

VIEWS: 1 PAGES: 4

									        A            B         C              D          E        F     G       H         I       J
1    McCormick Manufacturing Company
2
3                Labor Hrs. per Unit
4      Dept.        P1         P2     Hrs. Avail.
5       1             0.65       0.95     6500.00
6       2             0.45       0.85     6000.00
7       3             1.00       0.70     7000.00
8       4             0.15       0.30     1400.00
9
10 Profit/Unit       10.00         9.00
11
12
13   Model
14
15
16 Production Schedule                                                      Labor Hours
17     P1        P2                                                    Used           Available Slack
18    5743.59 1794.87                     Max Profit   73589.74       5438.46   <=      6500.00 1061.54
19                                                                    4110.26   <=      6000.00 1889.74
20                                                                    7000.00   <=      7000.00    0.00
21                                                                    1400.00   <=      1400.00    0.00
Adjustable Cells
                             Final Reduced Objective      Allowable     Allowable
   Cell            Name      Value   Cost   Coefficient   Increase      Decrease
  $A$18 P1                  5743.59    0.00          10         2.86            5.5
  $B$18 P2                  1794.87    0.00           9           11              2

Constraints
                             Final Shadow Constraint      Allowable     Allowable
   Cell        Name          Value  Price   R.H. Side     Increase      Decrease
  $G$18   Max Profit Used   5438.46    0.00       6500         1E+30        1061.54
  $G$19   Used              4110.26    0.00       6000         1E+30        1889.74
  $G$20   Used              7000.00    8.46       7000        2333.33       3733.33
  $G$21   Used              1400.00   10.26       1400         418.18           350
         A              B            C          D           E         F        G             H          I          J         K
1    McCormick Manufacturing Company
2
3                   Labor Hrs. per Unit                                                 Max Hrs.
4       Dept.          P1        P2     Hrs. Avail.                           Dept.    Transferable
5        1              0.65      0.95       6500.00                           1              400.00
6        2              0.45      0.85       6000.00                           2              800.00
7        3              1.00      0.70       7000.00                           3              100.00
8        4              0.15      0.30       1400.00                           4              200.00
9
10    Profit/Unit       10.00         9.00
11
12
13   Model
14
15
16    Production Schedule                                                                        Labor Hours
17       P1          P2                                                               Used                     Available   Slack
18       6824.86 1751.41                     Max Profit   84011.30                           6100.00   <=        6100.00      0.00
19                                                                                           4559.89   <=        5200.00   640.11
20                                                                                           8050.85   <=        8050.85      0.00
21                                                                                           1549.15   <=        1549.15      0.00
22
23                                 TRANSFER MATRIX                                         Max
24    From/To           1            2       3              4        Total               Transfer
25       1                            0.00   400.00                  400.00    <=             400.00
26       2                                   650.85         149.15   800.00    <=             800.00
27       3                                                    0.00     0.00    <=             100.00
28       4                  0.00      0.00                             0.00    <=             200.00
29     Total                0.00      0.00      1050.85     149.15
Adjustable Cells
                           Final Reduced Objective       Allowable     Allowable
   Cell            Name    Value   Cost    Coefficient   Increase      Decrease
  $A$18   P1              6824.86     0.00          10          0.35          1.69
  $B$18   P2              1751.41     0.00           9          1.83          0.30
  $C$25   P2                 0.00    -8.25           0          8.25        1E+30
  $D$25   Max Profit       400.00     0.00           0        1E+30           7.46
  $D$26   Max Profit       650.85     0.00           0             0          4.78
  $E$26                    149.15     0.00           0          4.78             0
  $E$27                      0.00     0.00           0             0        1E+30
  $B$28   TRANSFER MATRIX    0.00    -7.46           0          7.46        1E+30
  $C$28   P2                 0.00    -8.25           0          8.25        1E+30

Constraints
                             Final Shadow Constraint     Allowable     Allowable
   Cell            Name      Value  Price   R.H. Side    Increase      Decrease
  $F$25   Total              400.00    7.46        400        266.67           400
  $F$26   Total              800.00    8.25        800        892.13        581.82
  $F$27   Total                0.00    0.00        100        1E+30            100
  $F$28   Total                0.00    0.00        200        1E+30            200
  $H$18   Max Profit Used   6100.00    0.79          0        536.97        338.46
  $H$19   Used              4559.89    0.00          0        1E+30         640.11
  $H$20   Used              8050.85    8.25          0       1192.31          2266
  $H$21   Used              1549.15    8.25          0        133.33        581.82

								
To top