USVI Public Records

Document text

U.S. Virgin Islands Water and Power Authority Preliminary Draft - Work in Process / Subject to Material Change Information contained herein has not been independently verified and is subject to material change based on continuing review. Accordingly, the information contained herein is not intended to be and should not be relied upon by any third party or as legal, auditing, or accounting advice. The attached preliminary cash flow tool and their accompanying analyses, assumptions and underlying data are the product of U.S. Virgin Islands Water and Power Authority ("WAPA") and its management (“Management”) and consist of information obtained solely from WAPA. With respect to prospective financial information relative to WAPA, there has not been any examination, compilation or application of agreed upon procedures to such information in accordance with attestation standards established by the AICPA. Consequently, no assurance of any kind is given with respect to, or on, the information presented. It is WAPA’s responsibility to make its own decision based on the information available to it. Management has the knowledge, experience and ability to form its own conclusions related to WAPA's cash flow forecast. There will usually be differences between forecasted and actual results because events and circumstances frequently do not occur as expected and those differences may be material. As a result, no responsibility for the achievement of forecasted results is made. Accordingly, reliance on this report is prohibited by any third party as the projected financial information contained herein is subject to material change and may not reflect actual results. Many of numbers set forth herein are estimates or based on assumptions which are subject to change. Such changes may be material and can materially affect the calculation of other amounts reflected herein. Preliminary Draft - Subject to Material Change 1 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 1: LEAC Rate Current As Approved Proposed LEAC Line # Apr-Jun 2023 Apr-Jun 2024 Sales 1 Total Sales Forecast (MWh) 152,231 134,619 Costs to be Recovered ($) 2 Current Fuel Cost Portion of LEAC 25,314,289 $ 41,160,287 $ Other Charges 3 PSC Regulatory Costs 42,000 42,000 4 Renewable Energy Costs 343,176 802,032 5 Water System Billings to Electric 441,934 538,147 6 Plant Repair RO Contract 61,394 64,003 7 Total Other Charges 888,503 1,446,182 8 Total Costs to be Recovered (Line 2+7) 26,202,791 $ 42,606,468 $ LEAC Rate Calculation (¢/kWh) 9 Current Fuel Cost Portion of LEAC 16.63 30.58 Other Charges 10 PSC Regulatory Costs 0.03 0.03 11 Renewable Energy Costs 0.23 0.60 12 Ultra Pure Water Charge 0.29 0.40 13 Plant Repair RO Contract 0.04 0.05 14 Total Other Charges 0.58 1.07 15 PSC Rate Adjustment 5.01 0.00 16 Total LEAC Rate (Line 9+14+15) 22.22 31.65 Preliminary Draft - Subject to Material Change 2 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 2: Comparison of Rate Change Current As Approved Proposed LEAC Cross Reference Line # Apr-Jun 2023 Apr-Jun 2024 WS # Line # LEAC Rate Summary (¢/kWh) LEAC Rate 1 Current Fuel Costs 16.63 30.58 1 9 2 All Other 0.58 1.07 1 14 PSC Rate Adjustment 5.01 - 3 Total LEAC 22.22 31.65 1 16 Energy Volumes 4 Total Sales Forecast 152,231 134,619 1 1 5 % Change vs. Currently Approved (11.6%) Average Thermal Heat Rates (BTU/kWh) 6 Plant 12,095 14,716 7 % Change vs. Currently Approved 21.7% Fuel Cost and Mix 8 No. 2 Oil Average Price Delivered ($/gal) 2.44 $ 3.00 $ 9 % Change vs. Currently Approved 23.0% 10 LPG Average Price Delivered ($/gal) 1.10 $ 1.38 $ 11 % Change vs. Currently Approved 25.7% Fuel Mix (MMBTU) 12 No. 2 Oil 33.1% 11.3% 13 LPG 66.9% 88.7% Preliminary Draft - Subject to Material Change 3 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 3: Consumer Retail Rate Impact Line # Rate Class Residential Commercial Large Power 1 Average Monthly Usage (kWh) 400 1,200 25,000 2 Change in LEAC Rate (¢/kWh) 9.43 9.43 9.43 3 Impact to Bill (Monthly) 38 $ 113 $ 2,357 $ Avg. Monthly Usage (kWh) Change in LEAC Rate (¢/kWh) Impact to Bill 4 200 9.43 18.85 $ 5 400 9.43 37.71 $ 6 600 9.43 56.56 $ 7 800 9.43 75.42 $ 8 1,000 9.43 94.27 $ 9 1,200 9.43 113.12 $ 10 1,400 9.43 131.98 $ 11 1,600 9.43 150.83 $ 12 1,800 9.43 169.69 $ 13 2,000 9.43 188.54 $ Preliminary Draft - Subject to Material Change 4 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 4: Comparison of Fuel Parameters Current As Approved Proposed LEAC Cross Reference Line # Apr-Jun 2203 Apr-Jun 2024 WS # Line # Fuel Consumption 1 No. 2 Oil (MMBTU) 644,397 248,786 2 LPG (MMBTU) 1,301,637 1,946,500 3 Total Consumption (MMBTU) (Line 1+2) 1,946,034 2,195,286 4 No. 2 Oil Heat Content 141,000 141,000 5 LPG Heat Content 91,500 91,500 6 No. 2 Oil Gallons - Line 1/4 4,570,191 1,764,439 7 LPG Gallons - Line 2/5 14,225,541 21,273,223 8 Total Gallons Required (Line 6+7) 18,795,732 23,037,663 Fuel Mix (MMBTU) 9 No. 2 Oil 33.1% 11.3% 2 12 10 LPG 66.9% 88.7% 2 13 11 Plant Heat Rate (BTU/kWh) 12,095 14,716 2 6 Fuel Prices ($/Gal) 12 No. 2 Oil - Delivered 2.44 $ 3.00 $ 2 8 13 LPG - Delivered 1.10 1.38 2 10 14 Weighted Average - Delivered 1.54 $ 1.57 $ Fuel Costs ($) 15 No. 2 Oil - Delivered 10,756,396 $ 5,292,096 $ 16 LPG - Delivered 15,666,067 29,419,578 17 Urea - - 18 Forced Outage Reserve Adder - 5,658,003 19 Spinning Reserve Adder - 2,256,259 20 Total (Sum Line 15-19) 26,422,463 $ 42,625,936 $ 21 Less: Energy Charges to Water Department (1,108,175) $ (1,465,650) $ 22 Current Fuel Cost to be Recovered (Line 20+21) 25,314,289 $ 41,160,287 $ 1 2 Preliminary Draft - Subject to Material Change 5 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 5: Production Costing and Fuel Cost Summary Line # St. Thomas Month Fuel Consumption (Gal) Delivered Fuel Cost ($/Gal) Fuel Cost ($) Total Generation (MWh) Total Renewable Generation (MWh) LPG No. 2 Oil LPG No. 2 Oil LPG No. 2 Oil Urea Forced Outage Reserve (16.3%) Spinning Reserve (6.5%) 1 Apr-24 3,981,648 919,663 1.38 $ 3.01 $ 5,507,933 $ 2,770,668 $ - $ 1,349,412 $ 538,109 $ 34,917 929 2 May-24 4,145,747 74,271 1.38 $ 2.99 $ 5,728,054 $ 222,085 $ - $ 969,873 $ 386,759 $ 26,109 934 3 Jun-24 4,093,825 770,505 1.38 $ 2.98 $ 5,664,831 $ 2,299,342 $ - $ 1,298,160 $ 517,671 $ 31,235 890 7 Total 12,221,220 1,764,439 1.38 $ 3.00 $ 16,900,818 $ 5,292,096 $ - $ 3,617,445 $ 1,442,539 $ 92,261 2,753 St. Croix Month Fuel Consumption (Gal) Delivered Fuel Cost ($/Gal) Fuel Cost ($) Total Generation (MWh) Total Renewable Generation (MWh) LPG No. 2 Oil LPG No. 2 Oil LPG No. 2 Oil Urea Forced Outage Reserve (16.3%) Spinning Reserve (6.5%) 8 Apr-24 3,314,015 0 1.38 $ - $ 4,584,376 $ - $ - $ 747,253 $ 297,984 $ 23,391 732 9 May-24 2,671,530 0 1.38 $ - $ 3,691,174 $ - $ - $ 601,661 $ 239,926 $ 17,423 640 10 Jun-24 3,066,458 0 1.38 $ - $ 4,243,211 $ - $ - $ 691,643 $ 275,809 $ 20,880 649 14 Total 9,052,003 0 1.38 $ - $ 12,518,760 $ - $ - $ 2,040,558 $ 813,719 $ 61,695 2,021 Preliminary Draft - Subject to Material Change 6 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 6: Billing Forecast (Net-to-Gross Reconciliation) Line # Apr-24 May-24 Jun-24 3-Month Total St. Thomas (MWh) 1 Total Sales Forecast 31,001 22,890 27,656 81,548 2 Renewables Generation 929 934 890 2,753 3 Thermal Sales Forecast (Line 1-2) 30,072 21,956 26,766 78,795 4 Line Loss Assumption As Stipulated 6.6% 6.6% 6.6% 6.6% 5 Add: Thermal Line Loss As Stipulated 2,125 1,551 1,891 5,568 6 Sales Required from Thermal Generation (Line 3+5) 32,197 23,508 28,658 84,363 7 Allowable Plant Use Assumption As Stipulated 2.5% 2.5% 2.5% 2.5% 8 Add: Thermal Allowable Plant Use As Stiuplated 826 603 735 2,163 9 Add: RO Consumption Not Billed 965 1,065 953 2,982 10 Total Thermal Generation Required (Line 6+8+9) 33,988 25,175 30,345 89,508 11 Total Generation (Line 2+9) 34,917 26,109 31,235 92,261 St. Croix (MWh) 12 Total Sales Forecast 20,260 14,810 18,002 53,072 13 Renewables Generation 732 640 649 2,021 14 Thermal Sales Forecast (Line 11-12) 19,528 14,170 17,353 51,051 15 Line Loss Assumption As Stipulated 6.6% 6.6% 6.6% 6.6% 16 Add: Thermal Line Loss As Stipulated 1,380 1,001 1,226 3,607 17 Sales Required from Thermal Generation (Line 13+15) 20,908 15,171 18,580 54,658 18 Allowable Plant Use Assumption As Stipulated 2.5% 2.5% 2.5% 2.5% 19 Add: Thermal Allowable Plant Use As Stipulated 536 389 476 1,401 20 Add: RO Consumption Not Billed 1,216 1,223 1,175 3,614 21 Total Thermal Generation Required (Line 16+18+19) 22,659 16,783 20,231 59,674 22 Total Generation (Line 12+19) 23,391 17,423 20,880 61,695 Preliminary Draft - Subject to Material Change 7 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 7: Renewable Power & Energy Forecast Cross Reference Line # St. Thomas WS # Line # Unit Renewable Capacity (MW) Trailing Six Months Generation (MWh) Proposed Period Generation (MWh) 1 Bovoni Landfill 0 2 Port Authority (Cyril E King Airport) 0 3 Donoe Solar (BMR) 2,753 4 Cruz Bay, STJ Solar 0 5 PV Street Lights 0 6 Total Renewable Energy 2,753 6 2 St. Croix Unit Renewable Capacity (MW) Trailing Six Months Generation (MWh) Proposed Period Generation (MWh) 7 Spanish Town Solar Farm 2,021 8 Adventure Solar 0 9 Henry Rohlsen Airport Solar 0 10 Longford Wind Farm 0 11 PV Street Lights 0 12 Total Renewable Energy 2,021 6 13 Preliminary Draft - Subject to Material Change 8 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 8: Thermal Power and Energy Forecast Current As Approved Proposed LEAC Cross Reference Line # Apr-Jun 2023 Apr-Jun 2024 WS # Line # St. Thomas (MWh) 1 Total Energy Requirement for Billings (WS 6) 92,261 92,261 6 11 2 Less: Renewable Generation (WS 7) (2,753) (2,753) 7 6 3 Total Thermal Power & Energy Forecast (Line 1-2) 89,508 89,508 6 10 St. Croix (MWh) 4 Total Energy Requirement for Billings (WS 6) 61,695 61,695 6 22 5 Less: Renewable Generation (WS 7) (2,021) (2,021) 7 12 6 Total Thermal Power & Energy Forecast (Line 4-5) 59,674 59,674 6 21 Preliminary Draft - Subject to Material Change 9 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 9b: Production Costing Outputs - Island Totals Line # Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 3-Month Total Cross Reference WS # Line # St. Thomas Total 1 LPG Generation (MWh) 26,062 24,595 24,308 - - - 74,964 2 No. 2 Oil Generation (MWh) 7,926 580 6,038 - - - 14,543 3 Total Thermal Generation (MWh) 33,988 25,175 30,345 - - - 89,508 6 10 4 LPG Consumption (MMBTU) 364,321 379,336 374,585 - - - 1,118,242 5 No. 2 Oil Consumption (MMBTU) 129,672 10,472 108,641 - - - 248,786 6 Total Consumption (MMBTU) 493,993 389,808 483,226 - - - 1,367,028 7 LPG Heat Content 91,500 91,500 91,500 91,500 91,500 91,500 91,500 8 No. 2 Oil Heat Content 141,000 141,000 141,000 141,000 141,000 141,000 141,000 9 LPG Gallons Required - Line 4/7 3,981,648 4,145,747 4,093,825 0 0 0 12,221,220 10 No. 2 Oil Gallons Required - Line 5/8 919,663 74,271 770,505 0 0 0 1,764,439 11 LPG Avg. Price Delivered 1.38 $ 1.38 $ 1.38 $ 1.38 $ 2 10 12 No. 2 Oil Avg. Price Delivered 3.01 2.99 2.98 3.00 2 8 13 LPG Total Cost - Line 9*11 5,507,933 $ 5,728,054 $ 5,664,831 $ - $ - $ - $ 16,900,818 $ 5 7 14 No. 2 Oil Total Cost - Line 10*12 2,770,668 222,085 2,299,342 - - - 5,292,096 5 7 15 Urea Total Cost - - - - - - - 5 7 16 Forced Outage Reserve Adder (7.5%) 1,349,412 969,873 1,298,160 - - - 3,617,445 5 7 17 Spinning Reserve Adder (0.5%) 538,109 386,759 517,671 - - - 1,442,539 5 7 18 Total Fuel Cost - Sum Lines 13-17 10,166,123 $ 7,306,771 $ 9,780,005 $ - $ - $ - $ 27,252,899 $ 19 System Heat Rate (BTU/kWh) - Line 6/3 14,535 15,484 15,924 15,273 St. Croix Total 20 LPG Generation (MWh) 22,659 16,783 20,231 - - - 59,674 21 No. 2 Oil Generation (MWh) - - - - - - - 22 Total Thermal Generation (MWh) 22,659 16,783 20,231 - - - 59,674 6 21 23 LPG Consumption (MMBTU) 303,232 244,445 280,581 - - - 828,258 24 No. 2 Oil Consumption (MMBTU) - - - - - - - 25 Total Consumption (MMBTU) 303,232 244,445 280,581 - - - 828,258 26 LPG Heat Content 91,500 91,500 91,500 91,500 91,500 91,500 91,500 27 No. 2 Oil Heat Content 141,000 141,000 141,000 141,000 141,000 141,000 141,000 28 LPG Gallons Required - Line 23/26 3,314,015 2,671,530 3,066,458 0 0 0 9,052,003 29 No. 2 Oil Gallons Required - Line 24/27 0 0 0 0 0 0 0 30 LPG Avg. Price Delivered 1.38 $ 1.38 $ 1.38 $ 1.38 $ 2 10 31 No. 2 Oil Avg. Price Delivered 3.01 2.99 2.98 3.00 2 8 32 LPG Total Cost - Line 28*30 4,584,376 $ 3,691,174 $ 4,243,211 $ - $ - $ - $ 12,518,760 $ 5 14 33 No. 2 Oil Total Cost - Line 29*31 - - - - - - - 5 14 34 Urea Total Cost - - - - - - - 5 14 35 Forced Outage Reserve Adder (7.5%) 747,253 601,661 691,643 - - - 2,040,558 5 14 36 Spinning Reserve Adder (0.5%) 297,984 239,926 275,809 - - - 813,719 5 14 37 Total Fuel Cost - Sum Lines 32-36 5,629,614 $ 4,532,761 $ 5,210,663 $ - $ - $ - $ 15,373,038 $ 38 System Heat Rate (BTU/kWh) - Line 25/22 13,382 14,565 13,869 13,880 Preliminary Draft - Subject to Material Change 10 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 9c: Production Costing Outputs - St. Thomas by Unit Line # Unit Fuel Type Resource Dispatch Mode Apr-24 May-24 Jun-24 Generation (MWH) 1 Unit 14 Diesel OUT 0 0 0 2 Unit 15 Diesel OUT 0 0 0 3 Unit 23 Diesel ECON 0 0 0 4 Unit 27 Diesel ECON 7,926 580 6,038 5 Unit 15 LPG ECON 10,879 8,943 9,125 6 Unit 27 LPG OUT 0 0 0 7 Wartsila 1 LPG ECON 5,061 5,230 5,061 8 Wartsila 2 LPG ECON 5,061 5,230 5,061 9 Wartsila 3 LPG ECON 5,061 5,193 5,061 10 Wartsila 4 LPG ECON 0 0 0 11 Wartsila 5 LPG ECON 0 0 0 12 Wartsila 6 LPG ECON 0 0 0 13 Wartsila 7 LPG ECON 0 0 0 14 Wartsila 4 Diesel ECON 0 0 0 15 Wartsila 5 Diesel ECON 0 0 0 16 Wartsila 6 Diesel ECON 0 0 0 17 Wartsila 7 Diesel ECON 0 0 0 18 Bovoni Landfill Wind and Solar Renewable Fixed (Renewable) 0 0 0 19 Cyril E King Airport Renewable Fixed (Renewable) 0 0 0 20 Donoe Solar Renewable Fixed (Renewable) 929 934 890 21 Cruz Bay Renewable Fixed (Renewable) 0 0 0 22 Total Generation - No. 2 / LPG 33,988 25,175 30,345 23 Total Generation - All 34,917 26,109 31,235 Consumption (MMBTU) 24 Unit 14 Diesel OUT 0 0 0 25 Unit 15 Diesel ECON 0 0 0 26 Unit 23 Diesel ECON 0 0 0 27 Unit 27 Diesel ECON 129,672 10,472 108,641 28 Unit 15 LPG ECON 220,845 231,380 231,109 29 Unit 27 LPG OUT 0 0 0 30 Wartsila 1 LPG ECON 47,825 49,419 47,825 31 Wartsila 2 LPG ECON 47,825 49,419 47,825 32 Wartsila 3 LPG ECON 47,825 49,116 47,825 33 Wartsila 4 LPG OUT 0 0 0 34 Wartsila 5 LPG OUT 0 0 0 35 Wartsila 6 LPG OUT 0 0 0 36 Wartsila 7 LPG OUT 0 0 0 37 Wartsila 4 Diesel OUT 0 0 0 38 Wartsila 5 Diesel OUT 0 0 0 39 Wartsila 6 Diesel OUT 0 0 0 40 Wartsila 7 Diesel OUT 0 0 0 41 Total Consumption - LPG LPG 364,321 379,336 374,585 42 Total Consumption - Diesel Diesel 129,672 10,472 108,641 Preliminary Draft - Subject to Material Change 11 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 9c: Production Costing Outputs - St. Thomas by Unit Line # Unit Fuel Type Resource Dispatch Mode Apr-24 May-24 Jun-24 Heat Rate (BTU/KWH) 43 Unit 14 Diesel OUT 0 0 0 44 Unit 15 Diesel OUT 0 0 0 45 Unit 23 Diesel ECON 46 Unit 27 Diesel ECON 16,361 18,056 17,994 47 Unit 15 LPG ECON 20,299 25,874 25,327 48 Unit 27 LPG OUT 0 0 0 49 Wartsila 1 LPG ECON 9,450 9,450 9,450 50 Wartsila 2 LPG ECON 9,450 9,450 9,450 51 Wartsila 3 LPG ECON 9,450 9,458 9,450 52 Wartsila 4 LPG OUT 53 Wartsila 5 LPG OUT 54 Wartsila 6 LPG OUT 55 Wartsila 7 LPG OUT 56 Wartsila 4 Diesel OUT 57 Wartsila 5 Diesel OUT 58 Wartsila 6 Diesel OUT 59 Wartsila 7 Diesel OUT 60 STT Total Heat Rate - (Lines 45+46)/24 14,535 15,484 15,924 Preliminary Draft - Subject to Material Change 12 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 9d: Production Costing Outputs - St. Croix by Unit Line # Unit Fuel Type Resource Dispatch Mode Apr-24 May-24 Jun-24 Generation (MWH) 1 Unit 20 Diesel ECON 0 0 0 2 Unit 17 Diesel OUT 0 0 0 3 Unit 19 Diesel ECON 0 0 0 4 Unit 20 LPG ECON 8,407 4,122 6,037 5 Unit 17 LPG ECON 0 0 0 6 Aggreko 1 LPG ECON 792 703 789 7 Aggreko 2 LPG ECON 792 703 789 8 Aggreko 3 LPG ECON 792 703 789 9 Aggreko 4 LPG ECON 792 703 789 10 Aggreko 5 LPG ECON 792 703 789 11 Aggreko 6 LPG ECON 792 703 789 12 Aggreko 7 LPG ECON 792 703 789 13 Aggreko 8 LPG ECON 792 703 789 14 Aggreko 9 LPG ECON 792 703 789 15 Aggreko 10 LPG ECON 792 703 789 16 Aggreko 11 LPG ECON 792 703 789 17 Aggreko 12 LPG ECON 792 703 789 18 Aggreko 13 LPG ECON 792 703 789 19 Aggreko 14 LPG ECON 792 703 789 20 Aggreko 15 LPG ECON 792 703 789 21 Aggreko 16 LPG ECON 792 703 789 22 Aggreko 17 LPG ECON 792 703 789 23 Aggreko 18 LPG OUT 792 703 789 24 Rice 1 LPG OUT 0 0 0 25 Rice 2 LPG OUT 0 0 0 26 Rice 3 LPG OUT 0 0 0 27 Rice 4 LPG OUT 0 0 0 28 Rice 1 Diesel OUT 0 0 0 29 Rice 2 Diesel OUT 0 0 0 30 Rice 3 Diesel OUT 0 0 0 31 Rice 4 Diesel OUT 0 0 0 32 Spanish Town Solar Farm Renewable Fixed (Renewable) 732 640 649 33 Adventure Solar Renewable Fixed (Renewable) 0 0 0 34 Henry Rohlsen Airport Solar Renewable Fixed (Renewable) 0 0 0 35 Longford Wind Farm Renewable Fixed (Renewable) 0 0 0 36 Total Generation - No. 2 / LPG 22,659 16,783 20,231 37 Total Generation - All 23,391 17,423 20,880 Consumption (MMBTU) 38 Unit 20 Diesel ECON 0 0 0 39 Unit 17 Diesel OUT 0 0 0 40 Unit 19 Diesel ECON 0 0 0 41 Unit 20 LPG ECON 163,174 119,720 141,086 42 Unit 17 LPG ECON 0 0 0 43 Aggreko 1 LPG ECON 7,781 6,929 7,750 44 Aggreko 2 LPG ECON 7,781 6,929 7,750 45 Aggreko 3 LPG ECON 7,781 6,929 7,750 46 Aggreko 4 LPG ECON 7,781 6,929 7,750 47 Aggreko 5 LPG ECON 7,781 6,929 7,750 48 Aggreko 6 LPG ECON 7,781 6,929 7,750 49 Aggreko 7 LPG ECON 7,781 6,929 7,750 50 Aggreko 8 LPG ECON 7,781 6,929 7,750 51 Aggreko 9 LPG ECON 7,781 6,929 7,750 52 Aggreko 10 LPG ECON 7,781 6,929 7,750 53 Aggreko 11 LPG ECON 7,781 6,929 7,750 54 Aggreko 12 LPG ECON 7,781 6,929 7,750 55 Aggreko 13 LPG ECON 7,781 6,929 7,750 56 Aggreko 14 LPG ECON 7,781 6,929 7,750 57 Aggreko 15 LPG ECON 7,781 6,929 7,750 58 Aggreko 16 LPG ECON 7,781 6,929 7,750 59 Aggreko 17 LPG ECON 7,781 6,929 7,750 60 Aggreko 18 LPG OUT 7,781 6,929 7,750 61 Rice 1 LPG OUT 0 0 0 62 Rice 2 LPG OUT 0 0 0 63 Rice 3 LPG OUT 0 0 0 64 Rice 4 LPG OUT 0 0 0 65 Rice 1 Diesel OUT 0 0 0 66 Rice 2 Diesel OUT 0 0 0 67 Rice 3 Diesel OUT 0 0 0 68 Rice 4 Diesel OUT 0 0 0 69 Total Consumption - LPG LPG 303,232 244,445 280,581 70 Total Consumption - Diesel DIesel 0 0 0 Preliminary Draft - Subject to Material Change 13 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 9d: Production Costing Outputs - St. Croix by Unit Line # Unit Fuel Type Resource Dispatch Mode Apr-24 May-24 Jun-24 Heat Rate (BTU/KWH) 71 Unit 20 Diesel ECON 0 0 0 72 Unit 17 Diesel OUT 0 0 0 73 Unit 19 Diesel ECON 0 0 0 74 Unit 20 LPG ECON 19,409 29,041 23,369 75 Unit 17 LPG ECON 76 Aggreko 1 LPG ECON 9,827 9,851 9,828 77 Aggreko 2 LPG ECON 9,827 9,851 9,828 78 Aggreko 3 LPG ECON 9,827 9,851 9,828 79 Aggreko 4 LPG ECON 9,827 9,851 9,828 80 Aggreko 5 LPG ECON 9,827 9,851 9,828 81 Aggreko 6 LPG ECON 9,827 9,851 9,828 82 Aggreko 7 LPG ECON 9,827 9,851 9,828 83 Aggreko 8 LPG ECON 9,827 9,851 9,828 84 Aggreko 9 LPG ECON 9,827 9,851 9,828 85 Aggreko 10 LPG ECON 9,827 9,851 9,828 86 Aggreko 11 LPG ECON 9,827 9,851 9,828 87 Aggreko 12 LPG ECON 9,827 9,851 9,828 88 Aggreko 13 LPG ECON 9,827 9,851 9,828 89 Aggreko 14 LPG ECON 9,827 9,851 9,828 90 Aggreko 15 LPG ECON 9,827 9,851 9,828 91 Aggreko 16 LPG ECON 9,827 9,851 9,828 92 Aggreko 17 LPG ECON 9,827 9,851 9,828 93 Aggreko 18 LPG OUT 9,827 9,851 9,828 94 Rice 1 LPG OUT 0 0 0 95 Rice 2 LPG OUT 0 0 0 96 Rice 3 LPG OUT 0 0 0 97 Rice 4 LPG OUT 0 0 0 98 Rice 1 Diesel OUT 0 0 0 99 Rice 2 Diesel OUT 0 0 0 100 Rice 3 Diesel OUT 0 0 0 101 Rice 4 Diesel OUT 0 0 0 102 STX Total Heat Rate - (Lines 69+70)/36 13,382 14,565 13,869 Preliminary Draft - Subject to Material Change 14 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 10: Ultra Pure Water Charges Current As Approved Proposed LEAC Cross Reference Line # Apr-Jun 2023 Apr-Jun 2024 WS # Line # Ultra Pure Water Charge - Island Totals 1 St. Thomas 322,540 $ 307,755 2 St. Croix 119,394 101,178 3 Total 441,934 $ 408,933 $ 4 Plant Repair RO Contract (STT Only) 61,394 $ 64,003 $ 1 6 Ultra Pure Water Charge - kgal 5 STT 32,200 31,500 6 STX 12,880 12,600 7 Total kgal 45,080 44,100 Ultra Pure Water Charge - Cost per kgal 8 STT 10.02 $ 9.77 $ 9 STX 9.27 8.03 10 Weighted Average Cost per kgal 9.80 $ 9.27 $ RO Energy Consumed (kWh) 11 STT 2,241,834 2,775,872 12 STX 3,184,590 3,321,125 13 Total 5,426,423 6,096,997 Preliminary Draft - Subject to Material Change 15 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 11: Other Eligible LEAC Costs Current As Approved Proposed LEAC Cross Reference Line # Apr-Jun 2023 Apr-Jun 2024 WS # Line # Other Eligible LEAC Costs 1 PSC Regulatory Costs 42,000 $ 42,000 $ 1 3 2 Renewable Energy Costs 343,176 802,032 1 4 3 Water System Billings to Electric 441,934 538,147 1 5 4 Plant Repair RO Contract 61,394 64,003 1 6 5 Total Other Charges 888,503 $ 1,446,182 $ 1 7 Preliminary Draft - Subject to Material Change 16 of 17 1/11/2024 10:10 AM U.S. Virgin Islands Water and Power Authority Worksheet 12: Fuel Futures Pricing Forecast Line # Apr-24 May-24 Jun-24 LPG 7-Day Sample (Unhedged) 1 1/8/2024 0.67 0.67 0.67 2 - - - 3 - - - 4 - - - 5 - - - 6 - - - 7 - - - 8 Avg. Spot Price (per Gal) 0.67 $ 0.67 $ 0.67 $ 9 Delivery 0.71 0.71 0.71 10 Total Price per Gallon (Line 8+9) 1.38 $ 1.38 $ 1.38 $ No. 2 Oil 7-Day Sample (Unhedged) 11 1/8/2024 2.42 2.40 2.39 12 - - - 13 - - - 14 - - - 15 - - - 16 - - - 17 - - - 18 Avg. Spot Price (per Gal) 2.42 $ 2.40 $ 2.39 $ 19 Delivery 0.595 0.595 0.595 20 Total Price per Gallon (Line 18+19) 3.01 $ 2.99 $ 2.98 $ Preliminary Draft - Subject to Material Change 17 of 17 1/11/2024 10:10 AM