Attachment 7 - LPG Deliveries (MFH).xlsx

XLSX spreadsheet 60 KB Posted

Attached to
Notice of Opportunity (NOO) for Energy Savings Performance Contract (ESPC) - Royal Air Force Mildenhall, United Kingdom
Solicitation number
SP060425R0400
Issued by

About this file

This document appears to be an attachment containing detailed records of LPG (Liquefied Petroleum Gas) deliveries to Mildenhall Housing in the United Kingdom over several fiscal years. The records include information such as the delivery date, quantity, price, and cost for each delivery. The document provides a comprehensive history of the LPG usage and costs for this location from FY17 through FY24.

The related federal contract opportunity is a Notice of Opportunity (NOO) for an Energy Savings Performance Contract (ESPC) at Royal Air Force Mildenhall in the United Kingdom. This ESPC opportunity will utilize the Department of Energy (DOE) Super ESPC Indefinite-Delivery/Indefinite-Quantity (IDIQ) contract vehicle. The ESCO will be responsible for financing, developing, and implementing energy conservation measures (ECMs) at the location, with the government paying for the services and debt service from the annual cost savings generated by the project. Responses are due by November 22, 2024.

View the file

Other files

Show all 20

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

FY17

DateControl No.CardholderInvoice no.VendorDescriptionTonne/LitrePrice(£)Exchange RatePrice ($)DEL DATECumulative SpendBalanceAccess Statement MonthUS Bank RateGroup ChargeMonthly Total (Litres)Monthly Total (Gallons)
4-Oct-1617K008GILL28462146CALORMILDENHALL HOUSING ROOM 38 BLDG 44395381,592.851.32,069.3330-Sep-1636,287.94833,987.7216-Oct$2,069.3395382520
9-Nov-1617K015GILL28562203CALORMILDENHALL HOUSING ROOM 38 BLDG 443132162,385.491.273,024.1428-Oct-1672,054.37798,221.2916-Nov$11,272.56132163491
4-Jan-1717K021HAZELETT28674061CALORMILDENHALL HOUSING ROOM 38 BLDG 44365211,358.981.251,695.7830-Nov-1697,461.09772,814.5717-Jan$26,620.48
4-Jan-1717K022HAZELETT28605488CALORMILDENHALL HOUSING ROOM 38 BLDG 443-9406-1,697.781.25-2,118.5529-Nov-1695,342.54774,933.1217-Jan$26,620.48
13-Jan-1717K036HAZELETT28676677CALORMILDENHALL HOUSING ROOM 38 BLDG 443241584,887.161.246,039.145-Dec-16182,240.99688,034.6717-Jan$54,802.97
13-Jan-1717K037HAZELETT28701019CALORMILDENHALL HOUSING ROOM 38 BLDG 444230014,653.101.245,749.9010-Dec-16187,990.90682,284.7617-Jan$54,802.97
13-Jan-1717K038HAZELETT28730041CALORMILDENHALL HOUSING ROOM 38 BLDG 445148353,001.121.243,708.5321-Dec-16191,699.42678,576.2417-Jan$54,802.97
13-Jan-1717K039HAZELETT28732772CALORMILDENHALL HOUSING ROOM 38 BLDG 446-4824-975.91.24-1,205.9321-Dec-16190,493.49679,782.1717-Jan$54,802.97
13-Jan-1717K040HAZELETT28732772CALORMILDENHALL HOUSING ROOM 38 BLDG 447-7654-1,548.401.24-1,913.3821-Dec-16188,580.11681,695.5517-Jan$54,802.974663112319
15-Feb-1717K070HAZELETT28853558CALORMILDENHALL HOUSING ROOM 38 BLDG 443210034,685.771.265,908.1218-Jan-17366,897.32503,378.3417-Feb$25,816.18210035548
3-Apr-1717K087HAZELETT28956199CALORMILDENHALL HOUSING ROOM 38 BLDG 443325508,049.621.2710,213.6214-Feb-17478,635.21391,640.4517-Apr$56,060.65
3-Apr-1717K088HAZELETTCALORMILDENHALL HOUSING ROOM 38 BLDG 44385542,115.401.272,684.0928-Feb-17481,319.30388,956.3617-Apr$56,060.654110410859
28-Apr-1717K111HAZELETT29083978CALORMILDENHALL HOUSING ROOM 38 BLDG 443154063,575.731.314,683.6324-Mar-17579,511.68290,763.9817-May$32,454.34154064070
6-Jun-1717K127HAZELETT29137172CALORMILDENHALL HOUSING ROOM 38 BLDG 44350471,049.781.311,373.135-Apr-17633,715.29236,560.3717-Jun$18,054.46
6-Jun-1717K128HAZELETT29165138CALORMILDENHALL HOUSING ROOM 38 BLDG 4433525733.21.31959.0415-Apr-17634,674.33235,601.3317-Jun$18,054.46
10-Jun-1717K144HAZELETT29330152CALORMILDENHALL HOUSING ROOM 38 BLDG 443180013,544.401.314,636.1530-May-17683,675.69186,599.9717-Jun$22,093.62
12-Jun-1717K150STITES24051600CALORMILDENHALL HOUSING ROOM 38 BLDG 4433165014,843.851.2919,146.2131-Jan-13712,697.38157,578.2817-Jun$19,146.215822315381
23-Aug-1717K173HAZELETT29437841CALORMILDENHALL HOUSING ROOM 38 BLDG 44375001,429.501.41,853.2111-Jul-17768,479.59101,796.07Sep75001981
21262156169
58223
11-Oct-1717K181Hazelett29559793CALORMILDENHALL HOUSING ROOM 38 BDG 44351101,104.781.41,476.88August24,290.801,001,209.20Oct
TOTAL51101,104.78

FY18

DateControl No.CardholderInvoice no.VendorDescriptionTonne/LitrePrice(£)Exchange RatePrice ($)DEL DATEPrice per litre
29-Nov-1718K009Hazelett26921032CALORMILDENHALL HOUSING ROOM 38 BDG 443150113,937.391.45,348.63October
TOTAL150115,348.630.36
22-Dec-1718K023Hazelett27235355CALORMILDENHALL HOUSING ROOM 38 BDG 443100032,681.801.43,629.20November
22-Dec-1718K024Hazelett27121309CALORMILDENHALL HOUSING ROOM 38 BDG 443100092,683.411.43,631.37November
TOTAL200127,260.570.36
12-Feb-1818K042Hazelett29892275CALORMILDENHALL HOUSING ROOM 38 BDG 443115103,223.951.454,518.81December
12-Feb-1818K043Hazelett29925787CALORMILDENHALL HOUSING ROOM 38 BDG 44385112,383.931.453,341.41December
TOTAL200217860.220.39
12-Feb-1818K068Hazelett30017776CALORMILDENHALL HOUSING ROOM 38 BDG 443220045,936.681.458,321.07January
12-Feb-1818K069Hazelett30125445CALORMILDENHALL HOUSING ROOM 38 BDG 44380062,160.021.453,027.57January
TOTAL3001011348.640.38
13-Apr-1818K088Hazelett30154877CALORMILDENHALL HOUSING ROOM 38 BDG 443190034,534.121.456,456.40February
TOTAL190036,456.400.34
13-Apr-1818K106Hazelett30241324CALORMILDENHALL HOUSING ROOM 38 BDG 443150043,339.891.452,078.10March
13-Apr-1818K107Hazelett30295956CALORMILDENHALL HOUSING ROOM 38 BDG 443100042,226.891.452,048.64March
13-Apr-1818K108Hazelett30308847CALORMILDENHALL HOUSING ROOM 38 BDG 443167953,738.571.455,379.83March
TOTAL418039506.570.23
18K12330364365CALORMILDENHALL HOUSING ROOM 38 BDG 44367001,524.921.452,078.10April
18K12430434429CALORMILDENHALL HOUSING ROOM 38 BDG 44366051,503.301.452,048.64April
TOTAL133054126.740.31
18K13730526141CALORMILDENHALL HOUSING ROOM 38 BDG 44381861,904.061.452,541.70May
TOTAL81862,541.700.31
18K154Hazelett1377026CALORMILDENHALL HOUSING ROOM 38 BDG 443100052,679.341.453,526.01Jul
TOTAL100053,526.010.35
0.34Average
Total17735657,975.48

FY19

Control No.CardholderInvoice no.VendorDescriptionTonne/LitrePrice(£)Exchange RatePrice ($)DEL DATEPrice per litre
19K011WILLIAMS31030572CalorMILDENHALL10,0163,031.841.43,869.51October0.39
TOTAL10,0163,869.51
19K025WILLIAMS31039965CALORMILDENHALL14,0163,682.001.44,710.68November0.34
TOTAL14,0164,710.68
19K040WILLIAMS31145637CALORMILDENHALL19,0274,187.841.45,511.07December0.29
TOTAL19,0275,511.07
19K05631318414CALORMILDENHALL20,0014,416.221.45884.18January0.29
TOTAL20,0015,884.18
19K07131395867CALORMILDENHALL20,0144,463.121.45846.17February0.29
19K07231444780CALORMILDENHALL26,0165,801.571.47599.39
TOTAL46,03013,445.56
19K086WILLIAMS31538832CALORMILDENHALL18,1694,126.181.45,491.51March0.30
TOTAL18,1695,491.51
19K098CALORMILDENHALL19,1514,259.181.45,396.18April0.28
TOTAL19,1515,396.18
31941304CALORMILDENHALL7,4001,466.681.42,053.35July0.28
TOTAL7,4002,053.35

Total 153,810 46,362

FY20

Order NumberInvoice NumberActual ShipDeliver ToSold ToShip ToDescription 1QuantityUOMInvoice AmountUnit PriceTotal LitresTOTAL COST £'STOTAL COST $'S$'S Per Litre
3154201232233779OCTOBER1377026441855611377026BULK PROPANE8,713LT£1,563.980.1795
3113085832192745OCTOBER1377026441855611377026BULK PROPANE3,923LT£704.180.179512,636£2,268.16$2,978.93$0.236
3169963532283476NOVEMBER1377026441855611377026BULK PROPANE27,003LT5,227.780.1936
3170491932293200NOVEMBER1377026441855611377026BULK PROPANE13,787LT2,669.160.193640,790£7,896.94$10,371.60$0.254
3188024332393994DECEMBER1377026441855611377026BULK PROPANE18,704LT3,879.210.207418,704£3,879.21$5,094.84$0.272
3191797832466654JANUARY1377026441855611377026BULK PROPANE16,709LT3,843.070.23
3203273032577565JANUARY1377026441855611377026BULK PROPANE18,511LT4,257.530.2335,220£8,100.60$10,639.09$0.302
3221090532674852FEBRUARY1377026441855611377026BULK PROPANE20,006LT3,671.100.183520,006£3,671.10$4,821.51$0.241
3237909332794967APRIL1377026441855611377026BULK PROPANE8,028LT897.530.11188,028£897.53$1,178.79$0.147
3275688532902389MAY1377026441855611377026BULK PROPANE12,014LT1,577.440.1313
3259121832892678MAY1377026441855611377026BULK PROPANE10,104LT1,326.660.131322,118£2,904.10$3,814.16$0.172
3286910932985660JUNE1377026441855611377026BULK PROPANE12,439LT1,890.730.152
3276026332967720JUNE1377026441855611377026BULK PROPANE5,756LT874.910.15218,195£2,765.64$3,632.31$0.200
3290643133192430SEPTEMBER1377026441855611377026BULK PROPANE12,269LT2,056.280.167612,2692056.282,700.66$0.220
Total187,96645,232

FY21

Order NumberInvoice NumberActual ShipShip ToDescription 1QuantityUOMInvoice AmountUnit PriceTotal LitresTOTAL COST £'STOTAL COST $'S$'S Per Litre
3320603133293439OCTOBERMFHBULK PROPANE10,730LT1,899.21£0.17710,730£1,899.21$2,373.42$0.221Exchange Rate0.8002
3337582833385474NOVEMBERMFHBULK PROPANE11,457LT2,126.42£0.18611,457£2,126.42£2,657.36$0.232
3366543333514195DECEMBERMFHBULK PROPANE15,935LT3,011.72£0.189
3351691933478420DECEMBERMFHBULK PROPANE14,004LT2,646.76£0.18929,939£5,658.48$7,071.33$0.236
3389800533657578JANUARYMFHBULK PROPANE12,072LT2,707.75£0.224
3386181833608267JANUARYMFHBULK PROPANE15,300LT3,431.79£0.224
3373740633579637JANUARYMFHBULK PROPANE15,002LT3,364.95£0.22442,374£9,504.49$11,877.64$0.280
3404877533753873FEBRUARYMFHBULK PROPANE16,552LT3,699.370.2235
3398213333703785FEBRUARYMFHBULK PROPANE6,801LT1,520.020.223523,353£5,219.39$6,522.61$0.279117,853
3428449333860657MARCHMFHBULK PROPANE3,929LT969.280.2467Avg Unit Rate
3422008033848543MARCHMFHBULK PROPANE11,508LT2,839.020.2467$0.28
3413287933813184MARCHMFHBULK PROPANE9,932LT2,450.220.246725,369£6,258.52$7,821.19$0.308
3448153933961235APRILMFHBULK PROPANE4,922LT£1,125.170.2286
3452231434013882APRILMFHBULK PROPANE5,715LT£1,306.450.228610,637£2,431.62$3,038.76$0.286
3457329234039404MAYMFHBULK PROPANE6,392LT£1,410.080.2206
3464772034093464MAYMFHBULK PROPANE4,047LT£892.770.220610,439£2,302.84$2,877.83$0.276
3473701234129151JUNEMFHBULK PROPANE3,539LT£788.840.22293,539£788.84$985.80$0.279
3452231634182606JULYMFHBULK PROPANE4,932LT1,293.170.2622
3497161434237666JULYMFHBULK PROPANE4,963LT1,301.300.26229,895£2,594.47$3,242.28$0.328
3514736034291190AUGUSTMFHBULK PROPANE3,260LT£893.240.2743,260£893.24$1,116.27$0.342
3519694934356567SEPTEMBER44185561BULK PROPANE3,601LT1,003.96£0.27883,601£1,003.96$1,254.64$0.348
Total184,59350,839$80,326

US Gal 48764

FY22

Order NumberInvoice NumberActual ShipShip ToDescription 1QuantityUOMInvoice AmountUnit PriceTotal LitresTOTAL COST £'STOTAL COST $'S$'S Per Litre
No DeliveriesOCTOBERMFHBULK PROPANELTERROR:#DIV/0!0£0.00$0.00ERROR:#DIV/0!Exchange Rate0.7843
3580432334514145NOVEMBERMFHBULK PROPANE14,002LT£4,829£0.3449
3582526734529268NOVEMBERMFHBULK PROPANE1,014LT£350£0.3449
3588741434555511NOVEMBERMFHBULK PROPANE10,013LT£3,453£0.344925,029£8,632.50$11,0070.440
3619725034628845DECEMBERMFHBULK PROPANE23,165LT£7,359.52£0.317723,165£7,359.52$9,3840.405
3622080134687541JANUARYMFHBULK PROPANE11,730LT£3,530.73£0.3010
3637879834744039JANUARYMFHBULK PROPANE11,730LT£3,530.73£0.301023,460£7,061.46$9,003.520.384
3653475834799668FEBRUARYMFHBULK PROPANE9,607LT£2,933.98£0.3054
3671200234831360FEBRUARYMFHBULK PROPANE12,277LT£3,749.40£0.305421,884£6,683.38$8,521.46$0.389
3683363234888547MARCHMFHBULK PROPANE11,231LT£3,903.90£0.3476
3698660134913387MARCHMFHBULK PROPANE5,005LT£1,739.74£0.347616,236£5,643.64$7,195.77$0.443
3731695234986730APRILMFHBULK PROPANE3598LT£1,416.53£0.3937
3725278034994600APRILMFHBULK PROPANE5955LT£2,344.48£0.39379,553£3,761.02$4,795.38$0.502
MAYMFHBULK PROPANE6,639LT£2,383.40£0.3590
MAYMFHBULK PROPANE5,003LT£1,796.08£0.359011,642£4,179.48$5,328.93$0.458No deliveries in June
JULYMFHBULK PROPANE3,157LT£1,131.47£0.35843,157£1,131.47$1,442.65$0.457
3846047235425719AUGUSTMFHBULK PROPANE1,009LT£343.06£0.34001,009£343.06$437.41$0.434
38553824SEPTEMBERMFHBULK PROPANE5,126LT1741.81£0.33985,126£1,741.81$2,220.85$0.433
Total140,261$59,336
US Gal37,053
MMBtu3390.352143618

FY23

Order NumberInvoice NumberActual ShipShip ToDescription 1QuantityUOMInvoice AmountUnit PriceTotal LitresTOTAL COST £'STOTAL COST $'S$'S Per Litre
35599116NOVEMBERMFHBULK PROPANE11,884LT3,758.91£0.316Exchange Rate0.7200Oct '22
35632948NOVEMBERMFHBULK PROPANE11,645LT£3,683£0.3160.7922Feb'23
35671362NOVEMBERMFHBULK PROPANE6,551LT£2,072£0.31630,080£9,514.30$13,214.310.439
35684528DECEMBERMFHBULK PROPANE6794LT2112.93£0.311
35696046DECEMBERMFHBULK PROPANE8687LT2701.66£0.311
35751505DECEMBERMFHBULK PROPANE9079LT2823.57£0.31124,560£7,638.16$10,608.560.432
35783663JANUARYMFHBULK PROPANE12,538LT£3,590.88£0.2864
35835630JANUARYMFHBULK PROPANE5,588LT£1,600.40£0.286418,126£5,191.28$7,210.110.398
35878012FEBRUARYMFHBULK PROPANE12565LT£4,582.46£0.365
35912561FEBRUARYMFHBULK PROPANE11496LT£4,192.59£0.365
35925940FEBRUARYMFHBULK PROPANE7591LT£2,768.44£0.36531,652£11,543.49$14,571.430.460
35975427MARCHMFHBULK PROPANE7115LT£2,374.99£0.334
36021340MARCHMFHBULK PROPANE3914LT£1,306.49£0.334
36061713MARCHMFHBULK PROPANE2595LT£866.21£0.334
36005885MARCHMFHBULK PROPANE8772LT£2,928.09£0.33422,396£7,475.78$9,436.730.421
APRILMFHBULK PROPANE6,508LT£1,751.30£0.2691
APRILMFHBULK PROPANE7,840LT£2,109.74£0.269114,348£3,861.04$4,873.820.340
MAYMFHBULK PROPANE2,668LT£694.75£0.26047,840£694.75$876.990.329
JUNEMFHBULK PROPANE6,829LT£1,593.21£0.2333
JUNEMFHBULK PROPANE2,292LT£534.72£0.23339,121£2,127.93$2,686.100.294£0.2333
JULYMFHBULK PROPANE3,257LT£744.55£0.22863,257£744.55$939.850.289£0.2286
AUGUSTMFHBULK PROPANE4,962LT£1,265.31£0.25504,962£1,265.31$1,597.210.322£0.2550
7003302891103697SEPTEMBERMFHBULK PROPANE2,808LT£815.16£0.2903
7003380691114170SEPTEMBERMFHBULK PROPANE3,329LT£966.41£0.29036,137£1,781.57$2,248.890.366£0.2903
Total172,479$68,264.00

US Gal 45564

FY24

Order NumberInvoice NumberActual ShipShip ToDescription 1QuantityUOMInvoice AmountUnit Price ( £'S)Total LitresTOTAL COST £'STOTAL COST $'S$'S Per Litre
OCTOBERMFHBULK PROPANE0LT£0.00ERROR:#DIV/0!No DeliveriesExchange Rate0.8502Oct '23
NOVEMBERMFHBULK PROPANE10,021LT£3,241.790.32351.0091Jun '24
NOVEMBERMFHBULK PROPANE2,652LT£857.920.3235
NOVEMBERMFHBULK PROPANE10,003LT£3,235.970.3235
NOVEMBERMFHBULK PROPANE6,730LT£2,177.160.323529,406£9,512.84$11,188.94$0.380
100060589391075975DECEMBERMFHBULK PROPANE1,164LT£360.370.3096
100061612491091392DECEMBERMFHBULK PROPANE10,125LT£3,134.700.3096
100065057791108077DECEMBERMFHBULK PROPANE6,000LT£1,857.600.3096
100066589591119326DECEMBERMFHBULK PROPANE6,550LT£2,027.880.309623,839£7,380.55$8,680.96$0.364
100067960391196176JANUARYMFHBULK PROPANE3,039LT£904.710.2977
100070229091212391JANUARYMFHBULK PROPANE6,794LT£2,022.570.2977
100072604091229677JANUARYMFHBULK PROPANE6,867LT£2,044.310.2977
100075302191269182JANUARYMFHBULK PROPANE6,109LT£1,818.650.2977
100075985491334390JANUARYMFHBULK PROPANE8,999LT£2,679.000.297731,808£9,469.24$11,137.66$0.350
FEBRUARYMFHBULK PROPANE2776LT£808.930.2914
FEBRUARYMFHBULK PROPANE9,771LT£2,847.270.291412,547£3,656.20$4,300.40$0.343
MARCHMFHBULK PROPANE10854LT£3,319.150.3058
MARCHMFHBULK PROPANE6,794LT£2,077.610.305817,648£5,396.76$6,347.64$0.360
APRILMFHBULK PROPANE7,469LT£2,269.080.3038
APRILMFHBULK PROPANE6,104LT£1,854.400.303813,573£4,123.48$4,850.01$0.357
100107879491943688JUNMFHBULK PROPANE15,075LT£4,406.420.292315,075£4,406.42$5,182.80$0.344
100108977092047718JULYMFHBULK PROPANE4,120LT£1,239.300.30084,120£1,239.30$1,228.12$0.298
100119784992241211AUGMFHBULK PROPANE6202LT£1,936.880.31236,202£1,936.88$1,919.41$0.309
0.31870$0.00$0.3158154,218£47,122$54,836
ERROR:#DIV/0!
ERROR:#DIV/0!
ERROR:#DIV/0!

ERROR:#DIV/0!

Total 50,683 $18,291

US Gal 13389

Annual Totals

Total LitresTotal US GalsIncrease/decreaseCubic MeterskWhMMBtuTotal DollarsIncrease/decreasem3 per houseCost per houseCost per monthkWh per yearkWh per monthCost per kWh
FY17212,62156,169156,5951,467,0855,3642,65424,8662,072
Fy18177,35646,852-16.59%130,6231,223,7564,474$57,9752,214$982.64$81.8920,7421,728$0.0474
FY19153,81040,632-13.28%113,2811,061,2893,880$46,362-20.03%1,920$785.80$65.4817,9881,499$0.0437
FY20187,96649,65522.21%138,4371,296,9654,742$45,232-2.44%2,346$766.64$63.8921,9821,832$0.0349
FY21184,59348,764-1.79%135,9531,273,6924,657$50,83912.40%2,304$861.68$71.8121,5881,799$0.0399
FY22140,26137,053-24.02%103,302967,8013,539$59,33616.71%1,751$1,005.70$83.8116,4031,367$0.0613
FY23172,47945,56422.97%127,0311,190,1054,351$68,26415.05%2,153$1,157.02$96.4220,1711,681$0.0574
FY24154,21840,740-10.59%113,5821,064,1043,891$54,836-19.67%1,925$929.42$77.4518,0361,503$0.0515
*Based on 59 AMQs in Lincoln Housing area

File details come from the government source that posted it. Updated .