Docstoc

blending

Document Sample
blending Powered By Docstoc
					                     A              B              C              D         E          F
1    Chandler Blending Problem (nonoptimal solution)
2
3 Monetary inputs                  Gasoline     Heating oil
4 Selling price/barrel              $25.00        $20.00
5 Advertising cost/barrel            $0.20         $0.10
6
 7   Quality level per barrel of crudes
 8   Crude oil 1                          10
 9   Crude oil 2                           5
10
11   Required quality level per barrel of product
12                                 Gasoline    Heating oil
13                                         8            6
14
15   Blending plan (barrels of crudes in each product)
16                                Gasoline    Heating oil     Barrels used      Barrels available
17   Crude oil 1                          0        3000               3000 <=              5000
18   Crude oil 2                      5000             0              5000 <=             10000
19   Barrels sold                     5000         3000
20
21   Constraints on quality
22                                 Gasoline     Heating oil
23   Quality "points" obtained       25000         30000
24                                       >=            >=
25   Quality "points" required       40000         18000
26
27   Profit summary
28                                 Gasoline     Heating oil
29   Profit/barrel                  $24.80        $19.90
30
31   Total profit                 $183,700




                                             Exhibit 6
                     A              B              C              D         E          F
1    Chandler Blending Problem (optimal solution)
2
3 Monetary inputs                  Gasoline     Heating oil
4 Selling price/barrel              $25.00        $20.00
5 Advertising cost/barrel            $0.20         $0.10
6
 7   Quality level per barrel of crudes
 8   Crude oil 1                          10
 9   Crude oil 2                           5
10
11   Required quality level per barrel of product
12                                 Gasoline    Heating oil
13                                         8            6
14
15   Blending plan (barrels of crudes in each product)
16                                Gasoline    Heating oil     Barrels used      Barrels available
17   Crude oil 1                      3000         2000               5000 <=              5000
18   Crude oil 2                      2000         8000             10000 <=              10000
19   Barrels sold                     5000        10000
20
21   Constraints on quality
22                                 Gasoline     Heating oil
23   Quality "points" obtained       40000         60000
24                                       >=            >=
25   Quality "points" required       40000         60000
26
27   Profit summary
28                                 Gasoline     Heating oil
29   Profit/barrel                  $24.80        $19.90
30
31   Total profit                 $323,000




                                             Exhibit 6
                                                SensitivityReport


Changing Cells
                                                Final Reduced Objective     Allowable    Allowable
   Cell                 Name                    Value   Cost   Coefficient   Increase    Decrease
  $B$17   Crude oil 1 Gasoline                   3000        0        24.8 58.16666667 8.166666667
  $C$17   Crude oil 1 Heating oil                2000        0        19.9 8.166666667 58.16666667
  $B$18   Crude oil 2 Gasoline                   2000        0        24.8        87.25        6.125
  $C$18   Crude oil 2 Heating oil                8000        0        19.9        6.125 14.54166667

Constraints
                                                Final Shadow Constraint      Allowable   Allowable
   Cell                   Name                  Value  Price    R.H. Side    Increase    Decrease
  $D$17   Crude oil 1 Barrels used               5000      29.7       5000        10000        2500
  $D$18   Crude oil 2 Barrels used              10000    17.45       10000        10000 6666.666667
  $B$23   Quality points obtained Gasoline      40000     -2.45          0         5000       20000
  $C$23   Quality points obtained Heating oil   60000     -2.45          0        10000 6666.666667




                                                    Page 3

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:10/14/2011
language:English
pages:3