chandler by shitingting

VIEWS: 0 PAGES: 2

									                         ae5df485-01df-4ad0-ad9d-91773c99bf3a.xls




                 A               B            C             D       E          F
1    Chandler Blending Problem
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                  2500       2500          5000 <=                   5000
18 Crude oil 2                  1500       8500        10000 <=                   10000
19 Barrels sold                 4000      11000
20
21   Constraints on quality
22                             Gasoline Heating oil
   Quality "points"
23 obtained                      32500        67500
24                                  >=           >=
     Quality "points"
25   required                    32000        66000
26
27   Profit summary
28                             Gasoline Heating oil
29   Profit/barrel              $24.80    $19.90
30
31   Total profit             $318,100




                                         Values
                                                             ae5df485-01df-4ad0-ad9d-91773c99bf3a.xls




                     A                                   B                                        C                              D         E             F
1    Chandler Blending Problem
2
3    Monetary inputs                                             Gasoline                                   Heating oil
4    Selling price/barrel           25                                      20
5    Advertising cost/barrel        0.2                                     0.1
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                                                                                              Decision Variables,
12                                                               Gasoline                                   Heating oil                        >= 0
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                      2500                                    2500                                          =SUM(B17:C17) <= 5000
18 Crude oil 2                      1500                                    8500                                          =SUM(B18:C18) <= 10000
19 Barrels sold                     =SUM(B17:B18)                           =SUM(C17:C18)
20
21   Constraints on quality                                                                                                                    Constraints
22                                                               Gasoline                                   Heating oil
     Quality "points" obtained
23                                  =SUMPRODUCT(B17:B18,$B$8:$B$9) =SUMPRODUCT(C17:C18,$B$8:$B$9)
24                                                                >=                             >=
     Quality "points" required
25                                  =B13*B19                                =C13*C19
26
27   Profit summary
28                                                               Gasoline                                   Heating oil
29   Profit/barrel                  =B4-B5                                  =C4-C5
30
31   Total profit                   =SUMPRODUCT(B19:C19,B29:C29)
32
33                                                                                                      Objective, Max




                                                                            Formulas

								
To top