Attachment 6 - Calor Deliveries (Main Base).xlsx
XLSX spreadsheet 91 KB Posted
- Solicitation number
- SP060425R0400
- Issued by
-
Defense Logistics Agency Energy
About this file
This document is an attachment detailing historical deliveries and costs for a federal contract for propane fuel in the United Kingdom. The attachment covers multiple fiscal years from FY17 to FY24, providing information on the location, quantity, unit price, and total cost for each delivery.
The key details include:
- The contract is for propane fuel deliveries to various locations at Royal Air Force Mildenhall in the United Kingdom, including shopping malls, coin-operated laundries, enlisted clubs, and fire training facilities.
- The contract is funded annually with a total of $50,000 per fiscal year, except for FY22 which had a higher original load of $132,950.
- Delivery unit prices range from $0.18 to $0.41 per liter over the covered period, with the price per liter increasing over time.
- The total annual liters delivered and associated costs vary, ranging from a high of 124,123 liters ($40,682) in FY17 to a low of 69,294 liters ($23,226) projected for FY24.
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
FY 17
| CTLBC/1854 (FLOGAS) | |||||||||||||||||
| CALL NO | Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | REMAINING FUNDS $'S | REMAINING FUNDS £'S | Approved For Payment Date | Remitance Advice Payment Voucher | FLOGAS Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre |
| Original Load | 0.00 | 0 | $48,000.00 | 30,000.00 | |||||||||||||
| MD 01 | 17-Oct-16 | 1825855 | Shopping Mall | £ 0.1759 | 5,982 | £1,052.23 | $1,625.57 | $46,374.43 | 28,947.77 | 16-Nov-16 | 2632219 | ||||||
| MD 02 | 17-Oct-16 | 1825854 | Coin Op Laundry | £ 0.1759 | 8,338 | £1,466.65 | $2,265.80 | $44,108.62 | 27,481.11 | 16-Nov-16 | 2632205 | 14320 | 2,519 | 3,891 | £ 0.1759 | $0.22 | |
| MD 03 | 24-Nov-16 | 1826185 | Shopping Mall | £ 0.2046 | 4,543 | £929.50 | $1,435.96 | $42,672.66 | 26,551.61 | 06-Jan-17 | 2756250 | ||||||
| MD 04 | 24-Nov-16 | 1826184 | Coin Op Laundry | £ 0.2046 | 7,837 | £1,603.45 | $2,477.14 | $40,195.53 | 24,948.16 | 06-Jan-17 | 2751726 | 12380 | 2,533 | 3,913 | £ 0.2046 | $0.25 | |
| MD 05 | 4-Jan-17 | 1983017 | Coin Op Laundry | £ 0.2190 | 8,429 | £1,845.95 | $2,851.77 | $37,343.76 | 23,102.21 | 01-Feb-17 | 2875584 | ||||||
| MD 06 | 4-Jan-17 | 1983018 | Shopping Mall | £ 0.2190 | 5,086 | £1,113.83 | $1,720.74 | $35,623.02 | 21,988.38 | 01-Feb-17 | 2878871 | 13515 | 2,960 | 4,573 | £ 0.2190 | $0.27 | |
| MD 07 | 21-Feb-17 | 0895578 | Shopping Mall | £ 0.2461 | 6,049 | £1,488.66 | $2,299.80 | $33,323.22 | 20,499.72 | 17-Mar-17 | 3013533 | ||||||
| MD 08 | 21-Feb-17 | 0895579 | Coin Op Laundry | £ 0.2461 | 8,681 | £2,136.39 | $3,300.47 | $30,022.75 | 18,363.33 | 17-Mar-17 | 3013516 | 14730 | 3,625 | 5,600 | £ 0.2461 | $0.30 | |
| MD 09 | 20-Mar-17 | 0895778 | Coin Op Laundry | £ 0.2304 | 6,352 | £1,463.50 | $2,260.93 | $27,761.82 | 16,899.83 | 19-May-17 | 3092336 | ||||||
| MD 10 | 20-Mar-17 | 0895779 | Shopping Mall | £ 0.2304 | 3,531 | £813.54 | $1,256.82 | $26,504.99 | 16,086.28 | 19-May-17 | 3092351 | 9883 | 2,277 | 3,518 | £ 0.2304 | $0.29 | |
| MD 11 | 2-May-17 | 0896196 | Coin Op Laundry | £ 0.1950 | 8,261 | £1,610.90 | $2,488.64 | $24,016.36 | 14,475.39 | 19-May-17 | 3171823 | ||||||
| MD 12 | 2-May-17 | 0896197 | Shopping Mall | £ 0.1950 | 3,342 | £651.69 | $1,006.78 | $23,009.57 | 13,823.70 | 19-May-17 | 3178582 | ||||||
| MD 13 | 29-May-17 | 0896361 | Shopping Mall | £ 0.1950 | 4,735 | £923.33 | $1,426.43 | $21,583.15 | 12,900.37 | 29-Jun-17 | 3246867 | ||||||
| MD 14 | 29-May-17 | 0896360 | Fire Trainer | £ 0.1950 | 4,522 | £881.79 | $1,362.26 | $20,220.89 | 12,018.58 | 29-Jun-17 | 3221792 | 20,860 | 4,068 | 6,284 | £ 0.1950 | $0.24 | |
| MD 15 | 14-Jun-17 | 0896360 | Coin Op Laundry | £ 0.2014 | 6,695 | £1,348.37 | $2,083.07 | $18,137.82 | 10,670.21 | 21-Aug-17 | 3276749 | 6695 | 1,348 | 2,083 | £ 0.2014 | $0.25 | |
| MD 16 | 6-Jul-17 | 1983611 | Shopping Mall | £ 0.1887 | 3,754 | £708.38 | $1,094.36 | $17,043.46 | 9,961.83 | 21-Aug-17 | 3297091 | ||||||
| MD 17 | 6-Jul-17 | 1983610 | Enlisted Club | £ 0.1887 | 1,101 | £207.76 | $320.96 | $16,722.50 | 9,754.07 | 21-Aug-17 | 3342808 | ||||||
| MD 18 | 25-Jul-17 | 1984081 | Coin Op Laundry | £ 0.1887 | 6,845 | £1,291.65 | $1,995.44 | $14,727.05 | 8,462.42 | 21-Aug-17 | 3362384 | 11,700 | 2,208 | 3,411 | £ 0.1887 | $0.23 | |
| MD 19 | 11-Sep-17 | 1984358 | Coin Op Laundry | £ 0.2393 | 8,316 | £1,990.02 | $3,074.34 | $11,652.71 | 6,472.40 | 10-Oct-17 | 3446961 | ||||||
| MD 20 | 11-Sep-17 | 1984357 | Fire Trainer | £ 0.2393 | 4,622 | £1,106.04 | $1,708.70 | $9,944.01 | 5,366.36 | 10-Oct-17 | 1653510 | ||||||
| MD 21 | 11-Sep-17 | 1984359 | Shopping Mall | £ 0.2393 | 7,102 | £1,699.51 | $2,625.53 | $7,318.47 | 3,666.85 | 10-Oct-17 | 3479223 | 20,040 | 4,796 | 7,409 | £ 0.2393 | $0.30 | |
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | 0.26 | |||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | 124,123 | 40,682 | ||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| £ 0.2014 | 0 | £0.00 | $0.00 | $7,318.47 | 3,666.85 | ||||||||||||
| THIS SPREADSHEET DOES NOT INCLUDE THE 2% PAID TO THE MOD | GREEN TEXT SIGNIFIES APPROVED FOR PAYMENT |
FY 18
| CTLBC/1854 (FLOGAS) Oct '17 to May '18 (CALOR 42345007) Jun-Sep '18 | |||||||||||||||||
| CALL NO | Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | REMAINING FUNDS $'S | REMAINING FUNDS £'S | Approved For Payment Date | Remitance Advice Payment Voucher | Calor Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre |
| Original Load | 0.00 | 0 | $50,000.00 | 40,360.00 | |||||||||||||
| ME01 | 17-Oct-17 | 076528 | Shopping Mall | £ 0.2610 | 3,841 | £1,002.50 | $1,241.95 | $48,758.05 | 39,357.50 | 04-Dec-17 | 3560381 | ||||||
| ME02 | 17-Oct-17 | 076529 | Coin Op Laundry | £ 0.2610 | 6,347 | £1,656.57 | $2,052.24 | $46,705.81 | 37,700.93 | 04-Dec-17 | 3552370 | ||||||
| ME03 | 17-Oct-17 | 076527 | Enlisted Club | £ 0.2610 | 499 | £130.24 | $161.35 | $46,544.47 | 37,570.69 | 04-Dec-17 | 3560386 | 10,687 | 2,789 | 3,456 | £ 0.2610 | $0.323 | |
| ME04 | 22-Nov-17 | 076187 | Coin Op Laundry | £ 0.2664 | 5,812 | £1,548.32 | $1,918.13 | $44,626.33 | 36,022.38 | 04-Dec-17 | 3646057 | ||||||
| ME05 | 22-Nov-17 | 076188 | Shopping Mall | £ 0.2664 | 4,110 | £1,094.90 | $1,356.42 | $43,269.91 | 34,927.47 | 04-Dec-17 | 3651939 | 9,922 | 2,643 | 3,275 | £ 0.2664 | $0.330 | |
| ME06 | 10-Jan-18 | 078230 | Fire Trainer | £ 0.3300 | 3,551 | £1,171.83 | $1,451.72 | $41,818.19 | 33,755.64 | 03-Mar-18 | 3655718 | ||||||
| ME07 | 10-Jan-18 | 078233 | Shopping Mall | £ 0.3300 | 3,947 | £1,302.51 | $1,613.61 | $40,204.57 | 32,453.13 | 17-Mar-18 | 3985309 | ||||||
| ME08 | 10-Jan-18 | 078232 | Enlisted Club | £ 0.3300 | 461 | £152.13 | $188.47 | $40,016.11 | 32,301.00 | 17-Mar-18 | 3985287 | ||||||
| ME09 | 10-Jan-18 | 078231 | Coin Op Laundry | £ 0.3300 | 6,684 | £2,205.72 | $2,732.56 | $37,283.55 | 30,095.28 | 03-Mar-18 | 3773812 | 14,643 | 4,832 | 5,986 | £ 0.3300 | $0.409 | |
| ME10 | 13-Mar-18 | 209866 | Shopping Mall | £ 0.3300 | 4,016 | £1,325.28 | $1,641.82 | $35,641.73 | 28,770.00 | 09-May-18 | 3909450 | ||||||
| ME11 | 13-Mar-18 | 209867 | Coin Op Laundry | £ 0.3300 | 8,170 | £2,696.10 | $3,340.06 | $32,301.66 | 26,073.90 | 09-May-18 | 3910971 | 12,186 | 4,021 | 4,982 | £ 0.3300 | $0.409 | |
| ME12 | 16-Apr-18 | 208060 | Shopping Mall | £ 0.3300 | 2,000 | £660.00 | $817.64 | $31,484.02 | 25,413.90 | 09-May-18 | 3996035 | ||||||
| ME13 | 16-Apr-18 | 208059 | Fire Trainer | £ 0.3300 | 1,727 | £569.91 | $706.03 | $30,777.99 | 24,843.99 | 09-May-18 | 4014235 | ||||||
| ME14 | 26-Apr-18 | 208832 | Shopping Mall | £ 0.3300 | 6,991 | £2,307.03 | $2,858.06 | $27,919.92 | 22,536.96 | 09-May-18 | 4072552 | ||||||
| ME15 | 26-Apr-18 | 208833 | Enlisted Club | £ 0.3300 | 627 | £206.91 | $256.33 | $27,663.59 | 22,330.05 | 09-May-18 | 4072083 | 11,345 | 3,744 | 4,638 | £ 0.3300 | $0.409 | |
| ME16 | 14-May-18 | 000000 | Coin Op Laundry | £ 0.3300 | 8,789 | £2,900.37 | $3,593.12 | $24,070.47 | 19,429.68 | 28-Jun-18 | 4098304 | ||||||
| ME17 | 14-May-18 | 000000 | Fire Trainer | £ 0.3300 | 2,837 | £936.21 | $1,159.82 | $22,910.64 | 18,493.47 | 28-Jun-18 | 4118884 | 11,626 | 3,837 | 4,753 | £ 0.3300 | $0.409 | |
| MF01 | 28-Jun-18 | 292053 | Shopping Mall | £ 0.2487 | 2,031 | £505.11 | $625.76 | $49,374.24 | 39,854.89 | 22-Sep-18 | 30728353 | ||||||
| MF02 | 28-Jun-18 | 292597 | Enlisted Club | £ 0.2487 | 632 | £157.18 | $194.72 | $49,179.52 | 39,697.71 | 22-Sep-18 | 30728357 | ||||||
| MF03 | 28-Jun-18 | 256120 | Officers Club | £ 0.2487 | 312 | £77.59 | $96.13 | $49,083.40 | 39,620.12 | 22-Sep-18 | 30728359 | ||||||
| MF04 | 28-Jun-18 | 291964 | Coin Op Laundry | £ 0.2487 | 7,750 | £1,927.43 | $2,387.79 | $46,695.61 | 37,692.69 | 22-Sep-18 | 30728355 | ||||||
| MF05 | 28-Jun-18 | 292184 | Fire Trainer | £ 0.2487 | 2,910 | £723.72 | $896.58 | $45,799.03 | 36,968.98 | 22-Sep-18 | 30728349 | ||||||
| MF06 | 29-Jun-18 | 292184 | Fire Trainer | £ 0.2487 | 3,328 | £827.67 | $1,025.36 | $44,773.66 | 36,141.30 | 22-Sep-18 | 30728350 | 16,963 | 4,219 | 5,226 | £ 0.2487 | $0.308 | |
| MF07 | 31-Jul-18 | 28890298 | Shopping Mall | £ 0.2518 | 2,210 | £556.48 | $689.39 | $44,084.27 | 35,584.82 | 22-Sep-18 | 30776421 | ||||||
| MF08 | 31-Jul-18 | 28902250 | Coin Op Laundry | £ 0.2518 | 3,636 | £915.54 | $1,134.22 | $42,950.05 | 34,669.28 | 22-Sep-18 | 30776423 | 5,846 | 1,472 | 1,824 | £ 0.2518 | $0.312 | |
| MF09 | 24-Sep-18 | 29260487 | Fire Trainer | £ 0.2767 | 4,002 | £1,107.35 | $1,371.85 | $41,578.20 | 33,561.93 | 17-Nov-18 | 30886856 | ||||||
| MF10 | 24-Sep-18 | 29260486 | Coin Op Laundry | £ 0.2767 | 8,114 | £2,245.14 | $2,781.40 | $38,796.81 | 31,316.78 | 17-Nov-18 | 30886857 | 12,116 | 3,352 | 4,153 | £ 0.2767 | $0.343 | |
| MF11 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF12 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | 93,148 | 33,311 | |||||||||
| MF13 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF14 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF15 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF16 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF17 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF18 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF19 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF20 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 21 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 22 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 23 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 24 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 25 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 26 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 27 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 28 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 29 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 30 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 31 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 32 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 33 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 34 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 35 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 36 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 37 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 38 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| MF 39 | £ 0.2518 | 0 | £0.00 | $0.00 | $38,796.81 | 31,316.78 | |||||||||||
| THIS SPREADSHEET DOES NOT INCLUDE THE 2% PAID TO THE MOD |
FY 19
| (CALOR RM3801) FY19 | |||||||||||||||||
| CALL NO | Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | REMAINING FUNDS $'S | REMAINING FUNDS £'S | Approved For Payment Date | Remitance Advice Payment Voucher | Calor Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre |
| Original Load | 0.00 | 0 | $50,000.00 | 40,360.00 | |||||||||||||
| MG01 | 10-Oct-18 | 29063595 | Shopping Mall | £ 0.2867 | 5,520 | £1,582.58 | $2,068.47 | $47,931.53 | 38,777.42 | 17-Nov-18 | 30941328 | 5,520 | 1,583 | 2,068 | £0.287 | $0.375 | |
| MG02 | 16-Nov-18 | 29381474 | Shopping Mall | £ 0.2467 | 3,798 | £936.97 | $1,224.63 | $46,706.90 | 37,840.45 | 24-Nov-18 | 31075437 | ||||||
| MG03 | 16-Nov-18 | 29286590 | Coin Op Laundry | £ 0.2467 | 9,746 | £2,404.34 | $3,142.51 | $43,564.39 | 35,436.11 | 24-Nov-18 | 31075438 | 13,544 | 3,341 | 4,367 | £0.247 | $0.322 | |
| MG04 | 13-Dec-18 | 29623214 | Shopping Mall | £ 0.2041 | 3,007 | £613.73 | $802.15 | $42,762.23 | 34,822.38 | 12-Feb-19 | 31174956 | ||||||
| MG05 | 13-Dec-18 | 29623213 | Coin Op Laundry | £ 0.2041 | 5,793 | £1,182.35 | $1,545.36 | $41,216.88 | 33,640.03 | 12-Feb-19 | 31174957 | 8,800 | 1,796 | 2,348 | £0.204 | $0.267 | |
| MG06 | 12-Feb-19 | 29804051 | Shopping Mall | £ 0.2070 | 6,998 | £1,448.59 | $1,893.33 | $39,323.55 | 32,191.45 | 26-Mar-19 | 31408129 | ||||||
| MG07 | 12-Feb-19 | 29804052 | Coin Op Laundry | £ 0.2070 | 10,655 | £2,205.59 | $2,882.74 | $36,440.81 | 29,985.86 | 26-Mar-19 | 31408130 | 17,653 | 3,654 | 4,776 | £0.207 | $0.271 | |
| MG08 | 25-Mar-19 | 30216418 | Shopping Mall | £ 0.2111 | 4,592 | £969.37 | $1,266.99 | $35,173.82 | 29,016.49 | 18-Apr-19 | 31538345 | ||||||
| MG09 | 25-Mar-19 | 30216416 | Coin Op Laundry | £ 0.2111 | 6,915 | £1,459.76 | $1,907.93 | $33,265.89 | 27,556.73 | 18-Apr-19 | 31538346 | ||||||
| MG10 | 26-Mar-19 | 29286589 | Fire Trainer | £ 0.2111 | 5,986 | £1,263.64 | $1,651.61 | $31,614.28 | 26,293.09 | 15-May-19 | 31544410 | 17,493 | 3,693 | 4,827 | £0.211 | $0.276 | |
| MG11 | 30-Apr-19 | 30452895 | Shopping Mall | £ 0.2064 | 3,843 | £793.20 | $1,036.72 | $30,577.56 | 25,499.89 | 15-May-19 | 31700522 | ||||||
| MG12 | 30-Apr-19 | 30452894 | Coin Op Laundry | £ 0.2064 | 5,630 | £1,162.03 | $1,518.80 | $29,058.76 | 24,337.86 | 15-May-19 | 31700523 | ||||||
| MG13 | 30-Apr-19 | 30460521 | Fire Trainer | £ 0.2064 | 4,740 | £978.34 | $1,278.70 | $27,780.06 | 23,359.52 | 15-May-19 | 31700521 | 14,213 | 2,934 | 3,834 | £0.206 | $0.270 | |
| MG14 | 1-Jul-19 | 30719829 | Coin Op Laundry | £ 0.1822 | 8,001 | £1,457.78 | $1,905.35 | $25,874.71 | 21,901.74 | 20-Jul-19 | 31870611 | ||||||
| MG15 | 1-Jul-19 | 30719830 | Shopping Mall | £ 0.1822 | 4,989 | £909.00 | $1,188.07 | $24,686.64 | 20,992.75 | 20-Jul-19 | 31870610 | 12,990 | 2,367 | 3,093 | £0.182 | $0.238 | |
| MG16 | 3-Sep-19 | 31010442 | Shopping Mall | £ 0.1657 | 5,726 | £948.80 | $1,240.10 | $23,446.54 | 20,043.95 | 28-Sep-19 | 32047628 | ||||||
| MG17 | 3-Sep-19 | 31010441 | Coin Op Laundry | £ 0.1657 | 8,432 | £1,397.18 | $1,826.14 | $21,620.40 | 18,646.77 | 28-Sep-19 | 32047629 | 14,158 | 2,346 | 3,066 | £0.166 | $0.217 | |
| MG18 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG19 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | Total | ||||||||||
| MG20 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG21 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | 104,371 | 28,380 | |||||||||
| MG22 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG23 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG24 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG25 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG26 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG27 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG28 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG29 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG30 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG31 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG32 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG33 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG34 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG35 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG36 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG37 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG38 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| MG39 | £ 0.1822 | 0 | £0.00 | $0.00 | $21,620.40 | 18,646.77 | |||||||||||
| THIS SPREADSHEET DOES NOT INCLUDE THE 2% PAID TO THE MOD |
FY 20
| (CALOR RM3801) FY20 | |||||||||||||||||
| CALL NO | Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | REMAINING FUNDS $'S | REMAINING FUNDS £'S | Approved For Payment Date | Remitance Advice Payment Voucher | Calor Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre |
| Original Load | 0.00 | 0 | $50,000.00 | 40,360.00 | |||||||||||||
| MH01 | 18-Oct-19 | 31301944 | Coin Op Laundry | £ 0.1795 | 9,245 | £1,659.48 | $2,179.51 | $47,820.49 | 38,700.52 | 16-Nov-19 | 32183451 | ||||||
| MH02 | 18-Oct-19 | 31301943 | Shopping Mall | £ 0.1795 | 6,166 | £1,106.80 | $1,453.63 | $46,366.86 | 37,593.73 | 16-Nov-19 | 32183450 | ||||||
| MH03 | 30-Oct-19 | 28890550 | Enlisted Club | £ 0.1795 | 1,584 | £284.33 | $373.43 | $45,993.43 | 37,309.40 | 16-Nov-19 | 32233644 | 16,995 | £3,051 | $4,007 | £0.180 | $0.236 | |
| MH04 | 19-Nov-19 | 31647239 | Fire Trainer | £ 0.1936 | 3,004 | £581.57 | $763.82 | $45,229.61 | 36,727.82 | 10-Dec-19 | 32283307 | 3,004 | £582 | $764 | £0.194 | $0.254 | |
| MH05 | 13-Dec-19 | 31648599 | Shopping Mall | £ 0.2074 | 6,270 | £1,300.40 | $1,707.90 | $43,521.70 | 35,427.43 | 14-Jan-20 | 32377948 | ||||||
| MH06 | 13-Dec-19 | 31648635 | Coin Op Laundry | £ 0.2074 | 8,684 | £1,801.06 | $2,365.46 | $41,156.24 | 33,626.36 | 14-Jan-20 | 32377949 | ||||||
| MH07 | 20-Dec-19 | 31715558 | Fire Trainer | £ 0.2074 | 5,974 | £1,239.01 | $1,627.28 | $39,528.97 | 32,387.36 | 14-Jan-19 | 32393836 | 20,928 | £4,340 | $5,701 | £0.207 | $0.272 | |
| MH08 | 10-Jan-20 | 31881225 | shopping Mall | £ 0.2300 | 3,299 | £758.77 | $996.55 | $38,532.42 | 31,628.59 | 03-Mar-20 | 32466479 | ||||||
| MH09 | 10-Jan-20 | 31881226 | Coin Op Laundry | £ 0.2300 | 5,333 | £1,226.59 | $1,610.97 | $36,921.46 | 30,402.00 | 03-Mar-20 | 32466480 | 8,632 | £1,985 | $2,608 | £0.230 | $0.302 | |
| MH10 | 28-Feb-20 | 32032728 | Coin Op Laundry | £ 0.1835 | 5,384 | £987.96 | $1,297.56 | $35,623.89 | 29,414.03 | 17-Apr-20 | 32674798 | ||||||
| MH11 | 28-Feb-20 | 32032729 | Shopping Mall | £ 0.1835 | 4,377 | £803.18 | $1,054.87 | $34,569.02 | 28,610.85 | 17-Apr-20 | 32674797 | 9,761 | £1,791 | $2,352 | £0.184 | $0.241 | |
| MH12 | 8-Apr-20 | 32379092 | Coin Op Laundry | £ 0.1118 | 8,804 | £984.29 | $1,292.73 | $33,276.29 | 27,626.57 | 17-Apr-20 | 32794830 | 8,804 | £984 | $1,293 | £0.112 | $0.147 | |
| MH13 | 8-May-20 | 32756884 | Coin Op Laundry | £ 0.1313 | 1,122 | £147.32 | $193.48 | $33,082.80 | 27,479.25 | 23-Jun-20 | 32902316 | ||||||
| MH14 | 8-May-20 | 32379091 | Shopping Mall | £ 0.1313 | 6,027 | £791.35 | $1,039.33 | $32,043.47 | 26,687.90 | 23-Jun-20 | 32902315 | 7,149 | £939 | $1,233 | £0.131 | $0.172 | |
| MH15 | 24-Jun-20 | 32591215 | Coin Op Laundry | £ 0.1520 | 4,692 | £713.18 | $936.67 | $31,106.80 | 25,974.72 | 05-Aug-20 | 32989284 | ||||||
| MH16 | 24-Jun-20 | 32760261 | Shopping Mall | £ 0.1520 | 3,080 | £468.16 | $614.87 | $30,491.93 | 25,506.56 | 5-Aug-20 | 32989283 | 7,772 | £1,181 | $1,552 | £0.152 | $0.200 | |
| MH17 | 19-Aug-20 | 32906432 | Shopping Mall | £ 0.1595 | 3,525 | £562.24 | $738.43 | $29,753.51 | 24,944.32 | 8-Sep-20 | 33152230 | ||||||
| MH18 | 19-Aug-20 | 33107558 | Coin Op Laundry | £ 0.1595 | 5,899 | £940.89 | $1,235.74 | $28,517.77 | 24,003.43 | 8-Sep-20 | 33152231 | 9,424 | £1,503 | $1,974 | £0.160 | $0.209 | |
| MH19 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH20 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH21 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH22 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH23 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | 92,469 | 21,482 | |||||||||
| MH24 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH25 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH26 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH27 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH28 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH29 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH30 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH31 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH32 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH33 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH34 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH35 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH36 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH37 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH38 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| MH39 | £ 0.1795 | 0 | £0.00 | $0.00 | $28,517.77 | 24,003.43 | |||||||||||
| THIS SPREADSHEET DOES NOT INCLUDE THE 2% PAID TO THE MOD |
FY 21
| (CALOR RM3801) FY21 | |||||||||||||||||
| CALL NO | Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | REMAINING FUNDS $'S | REMAINING FUNDS £'S | Approved For Payment Date | Remitance Advice Payment Voucher | Calor Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre |
| Original Load | 0.00 | 0 | $50,000.00 | 40,360.00 | |||||||||||||
| MI01 | OCT | 33366347 | Coin Op Laundry | £ 0.1770 | 5,886 | £1,041.82 | $1,301.95 | $48,698.05 | 39,318.18 | 03-Nov-20 | 33293329 | ||||||
| MI02 | OCT | 3336346 | Shopping Mall | £ 0.1770 | 4,614 | £816.68 | $1,020.59 | $47,677.46 | 38,501.50 | 03-Nov-20 | 33293328 | 10,500 | £1,859 | $2,323 | £0.177 | $0.221 | |
| MH03 | NOV | 33512852 | Shopping Mall | £ 0.1856 | 2,923 | £542.51 | $677.97 | $46,999.49 | 37,958.99 | 20-Nov-20 | 33385127 | ||||||
| MH04 | NOV | 31917979 | Fire Trainer | £ 0.1856 | 5,123 | £950.83 | $1,188.24 | $45,811.25 | 37,008.16 | 25-Jan-21 | 33432624 | 8,046 | £1,493 | $1,866 | £0.186 | $0.232 | |
| MH05 | JAN | 33146943 | Shopping Mall | £ 0.2243 | 6,452 | £1,447.18 | $1,808.53 | $44,002.72 | 35,560.98 | rejected |
JEFFERY, DARREN L GB USAF USAFE 100 CES/CEOES: JEFFERY, DARREN L GB USAF USAFE 100 CES/CEOES:
Discrepancy beetween the DIO Framwork and Calors PPL figures. Raised the issue with DIO - awaiting correction. Roy Garnham paid the invoice without Mildenhall approval.
Calor - 0.2243
| DIO - 0.2245 | paid by Roy | 33589759 | *No deliveries in December | ||||||||
| MH06 | JAN | 33146944 | Coin Op Laundry | £ 0.2243 | 9,175 | £2,057.95 | $2,571.80 | $41,430.93 | 33,503.03 | rejected |
JEFFERY, DARREN L GB USAF USAFE 100 CES/CEOES: JEFFERY, DARREN L GB USAF USAFE 100 CES/CEOES:
Discrepancy beetween the DIO Framwork and Calors PPL figures. Raised the issue with DIO - awaiting correction. Roy Garnham paid the invoice without Mildenhall approval.
Calor - 0.2243
| DIO - 0.2245 | paid by Roy | 33589760 | 15,627 | £3,505 | $4,380 | £0.224 | $0.280 | |||||||||||
| MH07 | FEB | 33861812 | Shopping Mall | £ 0.2235 | 5,300 | £1,184.55 | $1,480.32 | $39,950.61 | 32,318.48 | 07-Apr-21 | 33796434 | |||||||
| MH08 | FEB | 33606283 | Fire Trainer | £ 0.2235 | 3,930 | £878.36 | $1,097.67 | $38,852.94 | 31,440.12 | 07-Apr-21 | 33796433 | |||||||
| MH09 | FEB | 33861819 | Coin Op Laundry | £ 0.2235 | 5,280 | £1,180.08 | $1,474.73 | $37,378.21 | 30,260.04 | 07-Apr-21 | 33793325 | 14,510 | £3,243 | $4,053 | £0.224 | $0.279 | ||
| MH10 | APR | 34189212 | Shopping Mall | £ 0.2286 | 5,935 | £1,356.74 | $1,695.50 | $35,682.70 | 28,903.30 | 15-May-21 | 33976521 | *No deliveries in March | ||||||
| MH11 | APR | 34184921 | Coin Op Laundry | £ 0.2286 | 2,474 | £565.56 | $706.77 | $34,975.94 | 28,337.74 | 15-May-21 | 33976522 | 8,409 | £1,922 | $2,402 | £0.229 | $0.286 | ||
| MI12 | JUN | 34710148 | Shopping Mall | £ 0.2229 | 4,602 | £1,025.79 | $1,281.91 | $33,694.02 | 27,311.96 | 07-Jul-21 | 34104222 | *No deliveries in May | ||||||
| MI13 | JUN | 34710149 | Coin Op Laundry | £ 0.2229 | 8,001 | £1,783.42 | $2,228.72 | $31,465.30 | 25,528.54 | 07-Jul-21 | 34104223 | |||||||
| MI14 | JUN | 341892211 | Fire Trainer | £ 0.2229 | 2,361 | £526.27 | $657.67 | $30,807.63 | 25,002.27 | 07-Jul-21 | 34113787 | 14,964 | £3,335 | $4,168 | £0.223 | $0.279 | ||
| MI15 | JUL | 34836262 | Coin Op Laundry | £ 0.2622 | 4,932 | £1,293.17 | $1,616.06 | $29,191.57 | 23,709.10 | 09-Aug-21 | 34182606 | |||||||
| MI16 | JUL | 34780252 | Shopping Mall | £ 0.2622 | 4,963 | £1,301.30 | $1,626.22 | $27,565.36 | 22,407.80 | 9-Aug-21 | 34237666 | 9,895 | £2,594 | $3,242 | £0.262 | $0.328 | ||
| MH17 | AUG | 35147999 | Coin Op Laundry | £ 0.2740 | 4,330 | £1,186.42 | $1,482.65 | $26,082.70 | 21,221.38 | 15-Sep-21 | 34291145 | |||||||
| MH18 | AUG | 35189614 | Shopping Mall | £ 0.2740 | 3,223 | £883.10 | $1,103.60 | $24,979.10 | 20,338.28 | 15-Sep-21 | 34303246 | 7,553 | £2,070 | $2,586 | £0.274 | $0.342 | ||
| MH19 | SEP | 35416927 | Fire Trainer | £ 0.2788 | 1,895 | £528.33 | $660.24 | $24,318.86 | 19,809.95 | 7-Oct-21 | 34407011 | |||||||
| MH20 | SEP | 35446866 | Shopping Mall | £ 0.2788 | 3,812 | £1,062.79 | $1,328.15 | $22,990.71 | 18,747.17 | 7-Oct-21 | 34407012 | |||||||
| MH21 | SEP | 35446868 | Coin Op Laundry | £ 0.2788 | 4,088 | £1,139.73 | $1,424.31 | $21,566.40 | 17,607.43 | 7-Oct-21 | 34407013 | 9,795 | £2,731 | $3,413 | £0.279 | $0.348 | ||
| MH22 | ||||||||||||||||||
| MH23 | 99,299 | $28,434 | $44,925.09 | |||||||||||||||
| MH24 | ||||||||||||||||||
| MH25 | ||||||||||||||||||
| MH26 | ||||||||||||||||||
| MH27 | $2.29 | |||||||||||||||||
| MH28 | ||||||||||||||||||
| MH29 | ||||||||||||||||||
| MH30 | ||||||||||||||||||
| MH31 | ||||||||||||||||||
| MH32 | ||||||||||||||||||
| MH33 | ||||||||||||||||||
| MH34 | ||||||||||||||||||
| MH35 | ||||||||||||||||||
| MH36 | ||||||||||||||||||
| MH37 | ||||||||||||||||||
| MH38 | ||||||||||||||||||
| MH39 | ||||||||||||||||||
| THIS SPREADSHEET DOES NOT INCLUDE THE 2% PAID TO THE MOD |
| Order Number | Invoice Number | Actual Ship | Deliver To | Sold To | Description 1 | Quantity | UOM | Unit Price |
| 34184921 | 33976522 | 23/04/2021 | 42088872 | 42345007 | BULK PROPANE | 2,474 | LT | 0.2286 |
| 34189212 | 33976521 | 23/04/2021 | 42080977 | 42345007 | BULK PROPANE | 5,935 | LT | 0.2286 |
FY 22
| (CALOR RM3801) FY22 | ||||||||||||||||||
| CALL NO | Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | REMAINING FUNDS $'S | REMAINING FUNDS £'S | Approved For Payment Date | Remitance Advice Payment Voucher | Calor Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre | |
| Original Load | 0 | $132,950.00 | 100,000.00 | |||||||||||||||
| MJ01 | DEC | 34522315 | SHOPPING MALL | £ 0.3177 | 7,390 | £2,347.80 | $2,993.50 | $129,956.50 | 97,652.20 | 16-Dec-21 | 34597462 | |||||||
| MJ02 | DEC | 34836263 | COIN OP LAUNDRY | £ 0.3177 | 9,927 | £3,153.81 | $4,021.18 | $125,935.32 | 94,498.39 | 16-Dec-21 | 34611859 | 17,317 | £5,502 | $7,015 | £0.318 | $0.405 | ||
| MJ03 | FEB | 36098303 | SHOPPING MALL | £ 0.3054 | 6,937 | £2,118.56 | $2,701.21 | $123,234.11 | 92,379.83 | 24-Feb-22 | 34799389 | |||||||
| MJ04 | FEB | 36825940 | COIN OP LAUNDRY | £ 0.3054 | 8,743 | £2,670.11 | $3,404.45 | $119,829.66 | 89,709.72 | 24-Feb-22 | 34831239 | 15,680 | £4,789 | $6,106 | £0.305 | $0.389 | ||
| MJ05 | APR | 36152650 | COIN OP LAUNDRY | £ 0.3937 | 8,878 | £3,495.27 | $4,456.55 | $115,373.11 | 86,214.45 | 16-May-22 | 34994505 | |||||||
| MJ06 | APR | 37468368 | SHOPPING MALL | £ 0.3937 | 8,101 | £3,189.36 | $4,066.51 | $111,306.60 | 83,025.08 | 16-May-22 | 35039725 | 16,979 | £6,685 | $8,523 | £0.394 | $0.502 | ||
| MJ07 | MAY | 37495783 | SHOPPING MALL | £ 0.3590 | 3,564 | £1,279.48 | $1,631.36 | $109,675.24 | 81,745.61 | 29-Jun-22 | 35132085 | 3,564 | £1,279 | $1,631 | £0.359 | $0.458 | ||
| MJ08 | JUN | 37377037 | COIN OP LAUNDRY | £ 0.3698 | 5,369 | £1,985.46 | $2,531.50 | $107,143.74 | 79,760.15 | 29-Jun-22 | 35194677 | |||||||
| MJ09 | JUN | 35487922 | FIRE TRAINER | £ 0.3698 | 3,322 | £1,228.48 | $1,566.33 | $105,577.41 | 78,531.68 | 29-Jun-22 | 35194676 | |||||||
| MJ10 | JUN | 35143344 | ENLISTED CLUB | £ 0.3698 | 1,361 | £503.30 | $641.72 | $104,935.69 | 78,028.38 | 29-Jun-22 | 35222081 | 10,052 | £3,717 | $4,740 | £0.370 | $0.472 | No deliveries in July | |
| MJ11 | AUG | 37808877 | SHOPPING MALL | £ 0.3398 | 5,559 | £1,890.06 | $2,409.87 | $102,525.82 | 76,138.32 | 07-Sep-22 | 35373532 | |||||||
| MJ12 | AUG | 37846443 | COIN OP LAUNDRY | £ 0.3398 | 2,661 | £904.74 | $1,153.56 | $101,372.26 | 75,233.58 | 07-Sep-22 | 35396159 | 8,220 | £2,795 | $3,563 | £0.340 | $0.434 | ||
| MJ13 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | No deliveries in September | |||||||||||
| MJ14 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ15 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | 71,812 | 31,578 | ||||||||||
| MJ16 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ17 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ18 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ19 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ20 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ21 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ22 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ23 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ24 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ25 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ26 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ27 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ28 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ29 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ30 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ31 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ32 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| MJ33 | £ 0.3054 | 0 | £0.00 | $0.00 | $101,372.26 | 75,233.58 | ||||||||||||
| THIS SPREADSHEET DOES NOT INCLUDE THE 2% PAID TO THE MOD |
FY 23
| Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | Calor Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre | Exch. Rate | ||
| Original Load | 0 | 0.7200 | Oct '22 | ||||||||||||
| OCTOBER | 38855159 | FIRE TRAINER | £ 0.3089 | 4,114 | £1,270.81 | $1,765.02 | 35515494 | Exchange Rate | 0.7922 | Feb'23 | |||||
| OCTOBER | 38510460 | COIN OP LAUNDRY | £ 0.3089 | 6,397 | £1,976.03 | $2,744.49 | 35515455 | ||||||||
| OCTOBER | 38401340 | SHOPPING MALL | £ 0.3089 | 4,211 | £1,300.78 | $1,806.64 | 35553085 | 14,722 | £4,548 | 6,316.15 | £0.309 | $0.429 | |||
| DECEMBER | 39516507 | COIN OP LAUNDRY | £ 0.3110 | 5057 | 1572.73 | $2,184.35 | 35713014 | 5,057 | £1,573 | 2,184.35 | £0.311 | $0.432 | |||
| JANUARY | 39369557 | COIN OP LAUNDRY | £ 0.2864 | 6,126 | £1,754.49 | $2,436.79 | 35759173 | ||||||||
| JANUARY | 38981126 | SHOPPING MALL | £ 0.2864 | 7,781 | £2,228.48 | $3,095.11 | 35759172 | 13,907 | £3,983 | 5,531.90 | £0.286 | $0.398 | |||
| MARCH | 39651543 | COIN OP LAUNDRY | £ 0.3338 | 11,218 | £3,744.57 | $4,726.80 | 35759173 | ||||||||
| MARCH | 602175F88 | SHOPPING MALL | £ 0.3338 | 6,355 | £2,121.30 | $2,677.73 | 35759172 | 17,573 | £5,866 | 7,404.53 | £0.334 | $0.421 | |||
| APRIL | 39651544 | SHOPPING MALL | £ 0.2691 | 3,430 | £923.01 | $1,165.13 | 36120490 | ||||||||
| APRIL | 60153571 | COIN OP LAUNDRY | £ 0.2691 | 6,529 | £1,756.95 | $2,217.82 | 36120491 | 9,959 | £2,680 | 3,382.94 | £0.269 | $0.340 | |||
| MAY | FIRE TRAINER | £ 0.2604 | 3080 | £802.03 | $1,012.41 | ||||||||||
| MAY | COIN OP LAUNDRY | £ 0.2604 | 4861 | £1,265.80 | $1,597.83 | 7,941 | £2,068 | 2,610.24 | £0.260 | $0.329 | |||||
| JUNE | SHOPPING MALL | £ 0.2333 | 4075.000433 | £950.70 | $1,200.08 | ||||||||||
| JUNE | FIRE TRAINER | £ 0.2333 | 5206 | £1,214.56 | $1,533.15 | ||||||||||
| JUNE | COIN OP LAUNDRY | £ 0.2333 | 2481 | £578.82 | $730.65 | 11,762 | £2,744 | 3,463.87 | £0.233 | $0.294 | |||||
| JULY | SHOPPING MALL | £ 0.2286 | 2614.000126 | £597.56 | $754.31 | 2,614 | £598 | 754.31 | £0.229 | $0.289 | |||||
| AUGUST | COIN OP LAUNDRY | £ 0.2550 | 5279 | £1,346.15 | $1,699.25 | 5,279 | £1,346 | 1,699.25 | £0.255 | $0.322 | |||||
| SEPTEMBER | 91100023 | FIRE TRAINER | £ 0.2903 | 5,500 | £1,596.65 | $2,015.46 | |||||||||
| SEPTEMBER | 91109968 | COIN OP LAUNDRY | £ 0.2903 | 4,832 | £1,402.73 | $1,770.68 | |||||||||
| SEPTEMBER | 91114127 | SHOPPING MALL | £ 0.2903 | 6,748 | £1,958.94 | $2,472.78 | 17,080 | £4,958 | 6,258.92 | £0.290 | $0.366 | ||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | 105,894 | 39,606 | ||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 | ||||||||||||
| £ 0.3054 | 0 | £0.00 | $0.00 |
FY 24
| Delivery Date | Delivery Ticket Number | LOCATION | UNIT £'S per LTR | QUANTITY LITRES | TOTAL COST £'S | CONVERTED to DOLLARS | Calor Invoice No | Total Litres | TOTAL COST £'S | TOTAL COST $'S | £'S Per Litre | $'S Per Litre | Exch. Rate | ||
| Original Load | 0 | 0.8502 | Oct '23 | ||||||||||||
| No Deliveries For October | 1.0091 | Jul '24 | |||||||||||||
| NOVEMBER | 1000446194 | Shopping Mall | £ 0.2953 | 4,676 | £1,380.82 | $1,624.12 | 90923308 | 4,676 | £1,380.82 | 1,624.12 | £0.295 | $0.347 | Rejected by DJ | ||
| DECEMBER | Coin Op Laundry | £ 0.2626 | 12,188 | £3,200.57 | $3,764.49 | 91194899 | 12,188 | £3,200.57 | 3,764.49 | £0.263 | $0.309 | Rejected by DJ | |||
| No Deliveries For January | |||||||||||||||
| FEBRUARY | 1000759808 | Shopping Mall | £ 0.2914 | 8,152 | £2,375.49 | $2,794.04 | 91351549 | ||||||||
| FEBRUARY | 1000855051 | Coin Op Laundry | £ 0.2914 | 8,337 | £2,429.40 | $2,857.45 | 91452322 | 16,489 | £4,805 | 5,651.49 | £0.291 | $0.343 | |||
| MAY | 1000859892 | Coin Op Laundry | £ 0.2997 | 8,722 | £2,613.98 | $3,074.55 | 91762299 | ||||||||
| MAY | 1000810552 | Shopping Mall | £ 0.2997 | 6,801 | £2,038.26 | $2,397.39 | 91762301 | 15,523 | £4,652 | 5,471.94 | £0.300 | $0.353 | |||
| JUNE | 1001018189 | Coin Op Laundry | £ 0.2923 | 6,750 | £1,973.03 | $2,320.67 | 91983285 | ||||||||
| JUNE | 1000390874 | Fire Trainer | £ 0.2923 | 4,612 | £1,382.22 | $1,625.76 | 91983286 | 11,362 | £3,355 | 3,946.42 | £0.295 | $0.344 | |||
| JULY | 1001123652 | Shopping Mall | £ 0.3008 | 3,096 | £931.28 | $922.88 | 3,096 | £931.28 | 922.88 | £0.301 | $0.354 | ||||
| AUG | 1001115022 | Coin Op Laundry | £ 0.3123 | 5960 | £1,861.31 | $1,844.52 | 5,960 | £1,861 | 1,844.52 | £0.312 | $0.309 |
| Annual Totals | ||||||
| 69,294 | £20,186.36 | $ 23,225.85 | ||||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 | |||
| £ 0.3054 | 0 | £0.00 | $0.00 |
Annual Totals
| Total Litres | Total US Gals | % increase/decrease | MMBtu | Total Dollars | % increase/decrease | |
| FY17 | 124,123 | 32,790 | 3,131 | $40,682 | ||
| FY18 | 93,148 | 24,607 | -24.96% | 2,350 | $33,311 | -18.12% |
| FY19 | 104,371 | 27,572 | 12.05% | 2,633 | $28,380 | -14.80% |
| FY20 | 92,469 | 24,428 | -11.40% | 2,333 | $21,482 | -24.30% |
| FY21 | 99,299 | 26,232 | 7.39% | 2,505 | $28,434 | 32.36% |
| FY22 | 71,812 | 18,971 | -27.68% | 1,812 | $31,578 | 11.06% |
| FY23 | 105,894 | 27,974 | 47.46% | 2,672 | $39,606 | 25.43% |
| FY24 | 69,294 | 18,306 | -34.56% | 1,748 | $23,226 | -41.36% |
File details come from the government source that posted it. Updated .