Crude Oil Supply: 1193369

Crude oil Supply
Refinery costs and yields
Location, Crude, ProcessUnits SuppliedCost of Crude oilInbound Shipping costRefining costTotal costOutput Yield
AustraliaGasolineDistillate
Brunei Crude, Low (BLA)108049.65$7,347,376.52$449,486.56$207,455.34$8,004,318.4227984.8674338.16
Brunei Crude, High (BHA)15596.82$1,060,584.07$64,882.79$69,873.77$1,195,340.645692.848936.98
Iran Crude, Low (ILA)0.00$0.00$0.00$0.00$0.000.000.00
Iran Crude, High (IHA)76353.52$4,581,211.24$757,426.92$366,496.90$5,705,135.0623822.3046422.94
Japan0.00
Brunei Crude, Low (BLJ)25144.37$1,709,816.87$96,554.36$64,369.58$1,870,740.816512.3917299.32
Brunei Crude, High (BHJ)11209.15$762,222.53$43,043.15$60,977.80$866,243.493923.206590.98
Iran Crude, Low (ILJ)30960.87$1,857,651.97$292,270.58$99,074.77$2,248,997.325758.7222663.35
Iran Crude, High (IHJ)52685.61$3,161,136.79$497,352.19$328,758.23$3,987,247.2015805.6839332665.08013
Constraints
Input Supply
Iran160000<=350000
Brunei160000=160000
Input Demand
Australia200000.00>=200000
Japan120000.00>=120000
Output supply
Gasoline89500.00>=89500
Distillate208916.82>=199500
Marketing operations
Area2009 Demand
GasolineDistilate
Australia3600084000
Japan1200048000
Philippines2000032000
New Zealand2150035500
Total89500199500
Surplus from the refineries after supplying their area
Area2009 Demand
GasolineDistilate
Australia21500.0045698.08
Japan20000.0031218.74
Cost of supplying gasoline and Distillate
RefineryUnits suppliedShipment cost
New ZealandPhilippinesNew ZealandPhilippines
Gasoline21500.000.00$34,400.00$0.00
Distilate35500.0010198.08$56,800.00$24,475.40
Gasoline0.0020000.00$0.00$64,000.00
Distilate0.0021801.92$0.00$69,766.13
Constraint
Supply of Gasoline from
Australia21500.00<=21500.00
Japan20000.00<=20000.00
Supply of Distilate from
Australia45698.08<=45698.08
Japan21801.92<=31218.74
Supply to
Gasoline
New Zealand21500.00>=21500.00
Philipines20000.00>=20000.00
Distilate
New Zealand35500.00>=35500.00
Philipines32000.00>=32000.00
United States Supply
United States Supply
Shipment of distillate from the US toUnits suppliedShipment costPurchase cost
New Zealand0$0.00$0.00
Philippines0.00$0.00$0.00
Constraint
Supplu from US0<=68000
Tanker operations
Tankers ferrying crude oil
AustraliaJapanAustraliaJapan
Iran9.169.20Iran76353.5283646.48
Brunei6.181.64Brunei123646.4836353.52
Tankers ferrying output
New ZealndPhilippinesNew ZealandPhilippines
Australia0.570.20Australia57000.0010198.08
Japan0.000.42Japan0.0041801.92
USA0.000.00USA0.000.00
Number of tankers used27.37
Available Tankers26.40
Hired tankers0.97
Cost  of hiring tankers$49,855.92
Constriant
Iran to Australia76353.52=76353.52
Iran to Japan83646.48=83646.48
Borneo to Australia123646.48=123646.48
Borneo to Japan36353.52=36353.52
Australia to New Zealand57000.00=57000.00
Australia to Phillipines10198.08=10198.08
Japan to New Zealand0.00=0.00
Japan to Phillipines41801.92=41801.92
USA to New Zealand0.00=0.00
USA to Philipines0.00=0.00
Objective Funstion
Minimise Total Cost$24,177,320.40
A)
Bucket 1
Device100 MB1000 MB3000 MB5000 MB7000 MB10,000 MB
No of units 01867879176770
Storage capacity0186700026370008800005390000
Unit cost ($)$6.50$10.00$20.00$30.00$40.00$55.00
Purchase cost$0.00$18,670.00$17,580.00$5,280.00$3,080.00$0.00
Bucket 2
Device100 MB1000 MB3000 MB5000 MB7000 MB10000 MB
No of units 01770000231
Storage capacity017700000002310000
Unit cost ($)$6.50$10.00$20.00$30.00$40.00$55.00
Purchase cost$0.00$17,700.00$0.00$0.00$0.00$12,705.00
Constraints
Total devices5000>=5000
Total storage capacity10003000>=1250000
Bucket 12999<=3000
Bucket 22001<=3000
Average cost per MB$0.0075<=$0.0075
Objective
Min Total Cost$75,015.00
B) (i)
Bucket 1
Device100 MB1000 MB3000 MB5000 MB7000 MB10,000 MB
No of units 0147901081080333
Storage capacity01479000054000075600003330000
Unit cost ($)$6.50$10.00$20.00$30.00$40.00$55.00
Purchase cost$0.00$14,790.00$0.00$3,240.00$43,200.00$18,315.00
Bucket 2
Device100 MB1000 MB3000 MB5000 MB7000 MB10000 MB
No of units 002108482589
Storage capacity00600054200005775000890000
Unit cost ($)$6.50$10.00$20.00$30.00$40.00$55.00
Purchase cost$0.00$0.00$40.00$32,520.00$33,000.00$4,895.00
Constraints
Total devices5000>=5000
Total storage capacity25000000>=1250000
Bucket 13000<=3000
Bucket 22000<=3000
Average cost per MB$0.0060<=$0.0060
Objective
Min Total Cost$150,000.00
B) (ii)
Bucket 1
Device100 MB1000 MB3000 MB5000 MB7000 MB10,000 MB
No of units 010626674103771
Storage capacity0106200020010002050000263900010000
Unit cost ($)$6.50$10.00$20.00$30.00$40.00$55.00
Purchase cost$0.00$10,620.00$13,340.00$12,300.00$15,080.00$55.00
Bucket 2
Device100 MB1000 MB3000 MB5000 MB7000 MB10000 MB
No of units 00227500208
Storage capacity006825000002080000
Unit cost ($)$6.50$10.00$20.00$30.00$40.00$55.00
Purchase cost$0.00$0.00$45,500.00$0.00$0.00$11,440.00
Constraints
Total devices5000>=5000
Total storage capacity16667000>=1250000
Bucket 12517<=3000
Bucket 22483<=3000
Average cost per MB$0.0065<=$0.0065
Objective
Min Total Cost$108,335.00