The URL can be used to link to this page

Home My WebLink About20221223_Veolia to Staff Attachment - Response to No. 95.pdfVEO-W-22-02 IPUC DR 95 Page 1 of 2 VEOLIA WATER IDAHO, INC. CASE VEO-W-22-02 THIRD PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/Sponsoring Witness: Wilson REQUEST NO. 95: Please provide the source documents and calculations related to the projected fuel prices reflected in the Test Year at $4.68 per gallon for gasoline and $5.19 per gallon for diesel. In addition, please provide the calculations supporting the fuel consumption. RESPONSE NO. 95: The projected fuel prices were established using the September 1st, 2022 AAA Fuel Price Chart (https://gasprices.aaa.com/). The Company used the Boise City “Current Avg.” on that date. See chart on page 2 under Boise City. Fuel Consumption Calculation (see Attachment for further details): 5,813 gallons – Monthly average of total fuel usage YTD August 2022 69,756 gallons – Forecasted 2022 total fuel usage (5,813 monthly avg x 12) 73,593 gallons – Projected Test Year total fuel usage using 69,756 gallons plus 5.5% (5.5% is the forecasted increase in usage based on the percent increase from 2021 fuel usage total to 2022 forecasted total. The Company has additional vehicles for head count increases and expanded territory with the acquisition of Eagle Water Co. and continued customer growth system wide.) $276,614 – 59,169 regular fuel gallons x $4.675 (average AAA regular fuel price per chart on page 2) (59,169 gallons = 73,593 Test Year projected gallons x 80.4%, which is the allocation percent of the August YTD fuel usage split between regular and diesel) $74,876 – 14,424 diesel fuel gallons x $5.191 (average AAA diesel fuel price per chart on page 2) (14,424 gallons = 73,593 Test Year projected gallons x 19.6%, which is the allocation percent of the August YTD fuel usage split between regular and diesel) $351,490 – Total Test Year projected fuel costs VEO-W-22-02 IPUC DR 95 Page 2 of 2 VEO-W-22-02IPUC DR 95AttachmentPage 1 of 1 Journal Acct Cost Element DepaMonetary Amount Date Vendor Name Reference JE Month JE Year Total Fuel Usage Voucher Invoice #Year CE Description Average PriceAP0024110150645000682003100$19,965.56 2021-12-29 ELEMENT FLEET CORPORATION 00125364 1 2022 5,470 00125364 0009207686 2022 Vehicles:Gasoline $3.65AP0024531550645000682003100$16,141.13 2022-02-04 ELEMENT FLEET CORPORATION 00125672 2 2022 4,474 00125672 0009264887 2022 Vehicles:Gasoline $3.61AP0024803250645000682003100$20,423.00 2022-03-02 ELEMENT FLEET CORPORATION 00125928 3 2022 5,653 00125928 0009321740 2022 Vehicles:Gasoline $3.61AP0025144050645000682003100$29,647.82 2022-04-08 ELEMENT FLEET CORPORATION 00126300 4 2022 7,440 00126300 0009379269 2022 Vehicles:Gasoline $3.98AP0025449550645000682003100$26,463.43 2022-05-06 ELEMENT FLEET CORPORATION 00126732 5 2022 5,797 00126732 0009436852 2022 Vehicles:Gasoline $4.57AP0025778550645000682003100$24,278.18 2022-06-07 ELEMENT FLEET CORPORATION 00127065 6 2022 5,223 00127065 0009494717 2022 Vehicles:Gasoline $4.65AP0026058450645000682003100$30,552.12 2022-07-05 ELEMENT FLEET CORPORATION 00127406 7 2022 6,225 00127406 0009552804 2022 Vehicles:Gasoline $4.91AP0026058450645000682003100$30,169.26 2022-08-29 ELEMENT FLEET CORPORATION 00128000 8 2022 6,229 00128000 0009612053 2022 Vehicles:Gasoline $4.84$197,640.50 2022 YTD TOTAL 46,511 2022 MNTH/AVG 5,813 $4.232022 PROJECTED TOTAL 69,756 Projected Growth %5.5%Test Year Projected Fuel Usage 73,593 AP00200966 50645000 682003 100 $10,520.92 2021-01-04 ELEMENT FLEET CORPORATION 00121053 1 2021 4,830 00121053 0008551582 2021 Vehicles:Gasoline $2.18AP0020457350645000682003100$11,151.68 2021-02-04 ELEMENT FLEET CORPORATION 00121415 2 2021 4,965 00121415 0008604150 2021 Vehicles:Gasoline $2.25AP0020838250645000682003100$12,987.34 2021-03-11 ELEMENT FLEET CORPORATION 00121765 3 2021 5,164 00121765 0008656684 2021 Vehicles:Gasoline $2.51AP0021120050645000682003100$15,679.78 2021-04-01 ELEMENT FLEET CORPORATION 00122101 4 2021 5,639 00122101 0008708988 2021 Vehicles:Gasoline $2.78AP0021520450645000682003100$21,290.40 2021-05-05 ELEMENT FLEET CORPORATION 00122485 5 2021 6,569 00122485 0008763177 2021 Vehicles:Gasoline $3.24AP0021864850645000682003100$17,152.30 2021-06-04 ELEMENT FLEET CORPORATION 00122882 6 2021 5,236 00122882 0008816796 2021 Vehicles:Gasoline $3.28AP0022936050645000682003100$16,900.41 2021-09-09 ELEMENT FLEET CORPORATION 00123187 7 2021 5,186 00123187 0008870200 2021 Vehicles:Gasoline $3.26AP0022576950645000682003100$24,244.54 2021-08-01 ELEMENT FLEET CORPORATION 00123547 8 2021 6,812 00123547 0008926252 2021 Vehicles:Gasoline $3.56AP0022909350645000682003100$21,454.36 2021-09-03 ELEMENT FLEET CORPORATION 00123928 9 2021 5,549 00123928 0008981312 2021 Vehicles:Gasoline $3.87AP0023250950645000682003100$23,943.53 2021-10-06 ELEMENT FLEET CORPORATION 00124361 10 2021 6,401 00124361 0009037579 2021 Vehicles:Gasoline $3.74 AP00235380 50645000 682003 100 $18,507.76 2021-11-02 ELEMENT FLEET CORPORATION 00124638 11 2021 4,883 00124638 0009093544 2021 Vehicles:Gasoline $3.79AP0023871950645000682003100$18,963.34 2021-12-03 ELEMENT FLEET CORPORATION 00124990 12 2021 4,896 00124990 0009150255 2021 Vehicles:Gasoline $3.87$212,796.36 2021 TOTAL 66,130 2021 MNTH/AVG 5,511 $3.19 Client #Fuel Transaction Type Category Description Units Number of Gallons %Gallons - YTD 2022 127 2524 48,699.78 100.00%