Working Group Status Quo Forecasts June 2018 Agenda Review of - - PowerPoint PPT Presentation

working group
SMART_READER_LITE
LIVE PREVIEW

Working Group Status Quo Forecasts June 2018 Agenda Review of - - PowerPoint PPT Presentation

Central Iowa Regional Water Working Group Status Quo Forecasts June 2018 Agenda Review of Phase 2 Objectives Overview of Long-Range Regional Demand Overview of Long-Range Regional Capacity Investments Status Quo Forecasts Des


slide-1
SLIDE 1

Status Quo Forecasts

June 2018

Central Iowa Regional Water Working Group

slide-2
SLIDE 2

Page 2 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Agenda

 Review of Phase 2 Objectives  Overview of Long-Range Regional Demand  Overview of Long-Range Regional Capacity Investments  Status Quo Forecasts – Des Moines Water Works – Total Service and Wholesale – Producers  Next Steps

slide-3
SLIDE 3

Page 3 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Your Team

Melanie Hobart David Gordon Jason Mumm Andy Baker Brooke Tacia

slide-4
SLIDE 4

Review of Phase 2 Objectives

slide-5
SLIDE 5

Page 5 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Phase 2 is a Business Case Evaluation

5

What are the costs of producing with the current structures and approaches? What is the expected cost of producing assuming the presence

  • f a regional Authority?

Question 1 Question 2

BIG

QUESTIONS

ANSWERS

PHASE 2

slide-6
SLIDE 6

Page 6 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Quantify the Net Costs/Benefits

$2.00 $2.50 $3.00 $3.50 $4.00 $4.50 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 $ per 1,000 Gallons

  • Avg. Cost per 1,000 Gallons- Community X

Regional case Status Quo case The difference between the total average cost per unit of production defines the net cost or benefit in the business case

ILLUSTRATION ONLY

slide-7
SLIDE 7

Page 7 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Before we Begin…

 This is a business case evaluation – Our goal is to help you make an evidence-based decision on regionalizing – We have immersed ourselves in the details so you won’t have to  Things you should watch out for: – Consider all the facts, be aware of confirmation bias – Understand the difference between “accurate” , “precise” , and “material’ – The answers will come, but patience is necessary  How we will handle questions

slide-8
SLIDE 8

Long-Range Regional Demand

slide-9
SLIDE 9

Page 9 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Demands by Customer Type

 We are using the below customer types in our analysis

9

Producers Potential Producers Total Service* Wholesale DMWW Ankeny Polk County Bondurant Altoona Urbandale Windsor Heights Clive Polk City Waukee Pleasant Hill Johnston WDMWW Runnells Norwalk Grimes Cumming Warren Alleman Xenia Berwick

*Note: Total service customer demands are consolidated with DMWW in our forecast

slide-10
SLIDE 10

Page 10 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Our Forecast of Regional Demand

 Base data source is the Long Range Plan  Added / Subtracted the adjustments requested by members  Extended the forecast to 2060 using trend analyses for each member – The LRP only goes to 2040 – Our forecast goes to 2060

10

slide-11
SLIDE 11

Page 11 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Adjustments to the LRP Demands

 We asked members to provide us with their adjustments to the demand forecast presented in the Long Range Plan

Member Changed Avg. Day Changed Max. Day Bondurant Yes Yes Clive Yes Yes Norwalk Yes Yes Warren Yes No Grimes Yes Yes The sum of all changes results in an increase of 3% by 2040; an increase of 7% to the extended forecast to 2060

slide-12
SLIDE 12

Page 12 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Average-Day Demand by Customer Type

12

Despite some differences among individual demand levels, our total regional forecast matches the LRP very closely

20 40 60 80 100 120 140 2015 2020 2025 2030 2035 2040 2045 2050 2055 2060

  • Avg. Daily Demand (MGD)

Producers Potential Producers Total Service Customers Wholesale Long Range Plan Forecast

slide-13
SLIDE 13

Page 13 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Maximum-Day Demand by Customer Type

Our forecast of max-day demand uses the same factors as the LRP and achieves similar results

50 100 150 200 250 300 2015 2020 2025 2030 2035 2040 2045 2050 2055 2060 Max Day Demand (MG) Producers Potential Producers Total Service Customers Wholesale Long Range Plan Forecast

slide-14
SLIDE 14

Page 14 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Max-Day Demand vs. Current Capacity

The region will need additional capacity as early as 2021 and needs to add at least 131 MGD in the long term How does ASR factor into this graphic? I don’t see it accounted for in the “Capacity” tab in the linked file

50 100 150 200 250 300 2015 2020 2025 2030 2035 2040 2045 2050 2055 2060 Max Day Demand (MG) Producers Potential Producers Total Service Customers Wholesale Existing Capacity

slide-15
SLIDE 15

Long-Range Capacity and Investments

slide-16
SLIDE 16

Page 16 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Our Forecast of Capacity and its Cost

 Base data sources included: – Long Range Plan – Urbandale Plan (Water Treatment & Supply Prelim. Engineering Rpt.) – West Des Moines Plan (Joint Waukee/WDM Study)  Input from individual members was used, if: – The information was verifiable – Had reasonable timing and cost data  We made assumptions about additional expansion – When forecasted demand > available capacity (i.e., supply) – Applied a set of business logic (see next)

16

slide-17
SLIDE 17

Page 17 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Business Logic for Capacity Gaps

Before 2040? Demand < Supply Optimize existing resources based on lowest cost Construct minimum capacity value * Already buys at w/ Storage rate? Meet demand with more purchases from DMWW

yes no

Demand < Supply

yes no yes no

Construct minimum capacity value *

yes no

* Minimum capacity value: sufficient capacity to meet next 5 years of forecasted max-day demand; at average cost per MGD adjusted for cost escalation (inflation) based on the most recent expansion cost within the regional model.

Note: Logic applies only to

  • producers. Others meet their

supply needs by purchasing from DMWW at applicable rate at that time.

slide-18
SLIDE 18

18

Regional Capacity Forecast

50 100 150 200 250 300 2015 2020 2025 2030 2035 2040 2045 2050 2055 2060 Capacity (MGD) DMWW Existing Other Producer Existing DMWW Expansion Other Producer Expansion ASR Wells Existing ASR Wells Expansion System MDD

The needs of the region are met through individual efforts of water producing agencies

slide-19
SLIDE 19

Page 19 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Regional Capacity Investments to 2060

19

Responsible Agency Capacity Added Estimated Cost Des Moines Water Works 99.5 MGD $679.8M West Des Moines WW 7.5 MGD $25.8M Urbandale 8.0 MGD $67.5M Waukee 7.5 MGD $25.8M Grimes 12.2 MGD $77.8M Ankeny 2.5 MGD $4.9M Total 137.2 MGD $881.7M In total the region will add 138 MGD at an estimated cost of $882 million (2018 dollars)

slide-20
SLIDE 20

20

Regional Capacity Investment Costs

$492.01 $645.09 $751.39 $881.73 $- $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 20 40 60 80 100 120 140 160

Total Capacity Investment (Millions $)

Capacity (MGD) Total New Capacity (MGD) Cumulative New Investment (2018$)

Year Capacity Added (Total) $ / MGD 2032 74 MGD $6.65 2041 27 MGD (101 MGD) $5.67 2046 16 MGD (117 MGD) $6.63 2052 20 MGD (137 MGD) $6.54 DRAFT – PRELIMINARY RESULTS

slide-21
SLIDE 21

Status Quo Forecasts

21

slide-22
SLIDE 22

Page 22 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Key Term: Average Cost per Unit

Total Annual Cost Units of Water Delivered = Avg. Cost per Unit “Total Annual Cost” – the sum of all operating and capital costs incurred to produce the water in relevant period. “Units of Water Delivered” – the sum of all gallons of water delivered to customers during the same period.

slide-23
SLIDE 23

Page 23 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Example: Average Cost per Unit

 Community A has two water treatment facilities. The cost of operating plant

  • No. 1 (10MGD plant) is $5m and the cost of operating plant No. 2 (14 MGD

plant) is $4m. The annualized capital cost is $2m and $4m for Plant No. 1 and 2, respectively. Plant No. 1 delivered 3.65 billion gallons, and Plant No. 2 delivered 2.92 billion gallons. What’s the total average cost per unit for Community A?

Cost Plant 1 Plant 2 Total

O&M $5m $3m $8m Capital $2m $4m $6m Total $7m $7m $14m Water Delivery 3.65 2.92 6.57

  • Avg. Cost per

1,000 Gallons $1.91 $2.40 $2.13

slide-24
SLIDE 24

24

Capital Costs

Capital costs are the those costs incurred to acquire assets, including the costs of capital used, and investments to maintain, preserve, and extend the assets’ lives.

Activity Cost Period Purchased an asset $20M 1 Extended asset life $5M 6 Repaired the asset $2M 10 Expanded capacity $10M 12

Question: how much capital cost in year 8?

DRAFT – PRELIMINARY RESULTS

slide-25
SLIDE 25

$1.9M

total

25

Quantifying Capital Costs in Forecasts

Activity Cost Period Useful Life Annual Cost Purchased an asset $20M 1 40 $500,000 Extended asset life 5M 6 40 125,000 Total $25M $625,000 Activity Original Cost Acc. Depreciation Balance in Year 8 Purchased an asset $20M $4M $16M Extended asset life 5M 0.25M 4.75M Total $25M $4.25M $20.75M Cost of Capital X 6% $ Cost of Capital $1.25M

Step 1: Amortize the Asset Investments Step 2: Recognition of Cost of Capital

DRAFT – PRELIMINARY RESULTS

slide-26
SLIDE 26

26

FAQ on Capital Costs

Q: What if all the investments are paid in cash? Aren’t annual capital costs zero then? A: The best way to recognize capital costs is to match the portion of the investment used in the year (period) in which the water is produced. Q: If we pay for assets in cash with no debt financing, aren’t the costs of capital zero? A: The best way to recognize the cost of capital for making an economic decision is to assign cost to all capital used, including the retained earnings (i.e. equity, or cash reserve) of the utility. Q: We don’t charge customers for use of our cash reserves, so why include those “imaginary costs” in your forecast? A: The costs are not imaginary. Customers were charged when they paid rates above and beyond annual costs. There is an economic cost with that source of capital just like there is for any source of capital. DRAFT – PRELIMINARY RESULTS

slide-27
SLIDE 27

Des Moines Water Works and Total Service Customers

slide-28
SLIDE 28

Page 28 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Des Moines Water Works

 DMWW’s Long Range Plan calls for increasing capacity levels to meet regional demands with important exceptions – If Urbandale constructs capacity, DMWW plan changes – We have also assumed that when WDM/Waukee constructs that the DMWW plan would also change – Both cause a change in timing for DMWW planned additions to capacity  DMWW sets prices for all retail, total service, and wholesale (including purchased capacity) deliveries – We followed existing DMWW cost-of-service methodologies – Those forecasts are linked to all others  Total Service customers are those communities served under contract with DMWW and will continue receiving that service

28

slide-29
SLIDE 29

Page 29 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Demands Met by DMWW Facilities

  • 5.0

10.0 15.0 20.0 25.0 30.0 35.0 2016 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Billions of Gallons City Retail Wholesale & Purchased Capacity Total Service Customers

WDM/Waukee plant Urbandale plant

slide-30
SLIDE 30

Page 30 FCS GROUP

DRAFT – PRELIMINARY RESULTS

DMWW – Avg. Costs

$6.81 $5.76 $- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Purchased Capacity Rate Wholesale with Storage Rate City Retail

A significant assumption at this point is that the purchased capacity rate would end at the expiration of the contracts, to be replaced by the wholesale rate

15% reduction

slide-31
SLIDE 31

Page 31 FCS GROUP

DRAFT – PRELIMINARY RESULTS

DMWW – Avg. Costs

4.33 5.59 $- $1 $2 $3 $4 $5 $6 $7 $8 $9 $10 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Regional Average City Retail DMWW System Avg

Average cost per unit for Des Moines deliveries jumps 30% even while the avg. cost of wholesale service decreases.

slide-32
SLIDE 32

Page 32 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Total Service Avg. Costs per Unit

$- $2 $4 $6 $8 $10 $12 $14 $16 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Polk County Windsor Heights Warren County Pleasant Hill Runnells Cumming Alleman PCRWD#1 Berwick

Differences in rates for Total Service customers depend on multiple factors including peaking factors and fire protection needs – all of which we have included in our model

slide-33
SLIDE 33

Wholesale

slide-34
SLIDE 34

Page 34 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Wholesale Customers

 Wholesale customers are those communities who – Do not own physical production now – Have not announced any plans for owning production in the future – Currently buy from DMWW at either purchased capacity or wholesale rate  Wholesale communities meet all demands by purchasing from DMWW – Before 2040 – maximize purchased capacity, if any, and buy remainder at full wholesale rate – Expiration of purchased capacity agreements effectively merges the purchased capacity and full wholesale rates

slide-35
SLIDE 35

Page 35 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Wholesale Avg. Cost per Unit

$- $2 $4 $6 $8 $10 $12 Water Cost ($/kgal) Bondurant Clive Johnston Norwalk Warren Xenia

Differences in average cost up to 2040 are the result of different mixes of purchased capacity and wholesale rates unique to each community.

slide-36
SLIDE 36

Producers & Potential Producers

36

slide-37
SLIDE 37

Page 37 FCS GROUP

DRAFT – PRELIMINARY RESULTS

The Producers

 Producers are those communities who – Already own their own physical water production infrastructure, or – Have verified plans to own such production in the future  Producers face a different set of economic choices in the future than other communities – Given a portfolio of known costs for different sources – Select the least expensive method of producing first, the next most expensive second, and so forth until all demands are satisfied  How we modeled these decisions? – New plant timing based on avoiding wholesale w/ storage rate – Then, each period, select the source with the lowest variable cost per unit – Maximize that supply until exhausted before selecting the next most expensive

37

slide-38
SLIDE 38

Page 38 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Urbandale – Variable Costs by Supply Source

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Purchased Capacity Wholesale with Storage Variable Planned Local Production

  • Approx. 2035: Urbandale max –day demands will

exceed its purchased capacity prompting construction of its own production

slide-39
SLIDE 39

Page 39 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Urbandale – Full Cost by Supply Source

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Purchased Capacity Wholesale with Storage Variable Planned Local Production Total Planned Local Production

The amortized capital cost and fixed operating costs of Planned Local Production raise the total cost above the forecast Purchased Capacity rate, but still below the Wholesale with Storage rate.

slide-40
SLIDE 40

Page 40 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Urbandale – Usage by Source

40

500 1,000 1,500 2,000 2,500 3,000 3,500 4,000 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Future Local Production Purchased Capacity Wholesale with Storage

Once local production is available, it becomes the preferred source due to lower cost But local production is not sufficient to meet all demands, so some supply is purchased at wholesale rate

slide-41
SLIDE 41

Page 41 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Urbandale – Total Avg. Cost per Unit

$3.19 $5.39 $- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Wholesale with Storage Total Cost of Water ($/kgal)

Shifting to local production increases avg. cost per unit due to increase in fixed cost – but avg. cost is still less than it would be otherwise.

slide-42
SLIDE 42

Page 42 FCS GROUP

DRAFT – PRELIMINARY RESULTS

West Des Moines – Variable Cost by Supply Source

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Purchased Capacity Wholesale with Storage Variable Existing Local Production Variable Planned Local Production

Joint WDM/Waukee plant comes online in 2020 because that timing avoids moving WDM into the wholesale w/ storage rate.

slide-43
SLIDE 43

Page 43 FCS GROUP

DRAFT – PRELIMINARY RESULTS

West Des Moines – Full Cost by Supply Source

The amortized capital cost and fixed operating costs of Local Production raise the total cost above the forecast Purchased Capacity rate, but still below the Wholesale with Storage rate.

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Purchased Capacity Wholesale with Storage Variable Existing Local Production Variable Planned Local Production Total Cost of All Local Production

slide-44
SLIDE 44

Page 44 FCS GROUP

DRAFT – PRELIMINARY RESULTS

West Des Moines – Usage by Source

1,000 2,000 3,000 4,000 5,000 6,000 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Future Local Production Existing Local Production Purchased Capacity Wholesale with Storage

Local production cannot serve certain pressure zones; this demand assumed to be met by wholesale purchases

slide-45
SLIDE 45

Page 45 FCS GROUP

DRAFT – PRELIMINARY RESULTS

West Des Moines – Total Avg. Cost per Unit

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Wholesale with Storage Total Cost of Water ($/kgal)

slide-46
SLIDE 46

Page 46 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Waukee – Full Cost by Supply Source

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Purchased Capacity Wholesale with Storage Variable Planned Local Production Total Planned Local Production

The amortized capital cost and fixed operating costs of Local Production raise the total cost above the forecast Purchased Capacity rate, but still below the Wholesale with Storage rate.

slide-47
SLIDE 47

Page 47 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Waukee – Usage by Source

500 1,000 1,500 2,000 2,500 3,000 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Future Local Production Purchased Capacity Wholesale with Storage

The joint WMD/Waukee plant goes into operation in 2020 based on timing driven by WDM, but after it’s built, Waukee maximizes its share of the capacity

slide-48
SLIDE 48

Page 48 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Waukee – Total Avg. Cost per Unit

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Wholesale with Storage Total Cost of Water ($/kgal)

slide-49
SLIDE 49

Page 49 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Ankeny – Usage by Source

1,000 2,000 3,000 4,000 5,000 6,000 7,000 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Purchased Capacity Wholesale with Storage

slide-50
SLIDE 50

Page 50 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Ankeny –Total Avg. Cost per Unit

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Wholesale with Storage Total Cost of Water ($/kgal)

Up until 2040, the operation of Ankeny’s ASR wells saves them money, but after 2040 there is no incentive to avoid the wholesale rate and the operating costs are extra

slide-51
SLIDE 51

Page 51 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Grimes – Usage by Source

500 1,000 1,500 2,000 2,500 3,000 3,500 4,000 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Future Local Production Existing Local Production Purchased Capacity Wholesale with Storage

Grimes is an exception to our normal business logic because Grimes has made it clear that it will continue with its own production unless a regional model is adopted

slide-52
SLIDE 52

Page 52 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Grimes – Total Avg. Cost per Unit

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Wholesale with Storage Total Cost of Water ($/kgal)

slide-53
SLIDE 53

Page 53 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Polk City – Usage by Source

50 100 150 200 250 300 350 400 450 500 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Existing Local Production Purchased Capacity Wholesale with Storage

Local production capacity is taken out of service around 2034 according to statements made in the LRP; they then purchase from DMWW to meet demands

slide-54
SLIDE 54

Page 54 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Polk City – Total Avg. Cost per Unit

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Wholesale with Storage Total Cost of Water ($/kgal)

slide-55
SLIDE 55

Page 55 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Altoona – Usage by Source

500 1,000 1,500 2,000 2,500 3,000 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Future Local Production Existing Local Production Purchased Capacity Wholesale with Storage

Altoona has its own production capacity and has said they would build more if it made sense to do so, but based on our evaluation there would not be a business case for it

slide-56
SLIDE 56

Page 56 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Altoona – Total Avg. Cost per Unit

$- $2 $4 $6 $8 $10 $12 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Wholesale with Storage Total Cost of Water ($/kgal)

slide-57
SLIDE 57

Page 57 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Producers - Observations

 Expiration of the purchased capacity contracts will force individual economic decisions  As these producers change the way they use the DMWW sources: – It shifts DMWW from a base load source with relatively high avg. daily demand – To a peaking source with low to no avg. daily demand  Implications of shifting loads include stranded capacity with matching stranded fixed costs – It means the costs absorbed by DMWW retail and TS customers are likely to increase in order to support the stranded capacity

slide-58
SLIDE 58

Regional Totals

slide-59
SLIDE 59

Page 59 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Regional Avg. Cost of Production

$- $1 $2 $3 $4 $5 $6 $7 $8 $9 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Water Cost ($/kgal) Regional Average

slide-60
SLIDE 60

Page 60 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Regional Avg. Compared to Others

$0.00 $1.00 $2.00 $3.00 $4.00 $5.00 $6.00 $7.00 $8.00 $9.00 $10.00 2020 2025 2030 2035 2040 2045 2050 2055 2060 $ per Kgal Regional Average Des Moines Inside Retail Wholesale w/ Storage Waukee Urbandale West Des Moines

slide-61
SLIDE 61

Take-Aways from This Analysis

slide-62
SLIDE 62

Page 62 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Regional Opportunities

 Coordination of regional investments to minimize capacity costs  Consolidation of regional base loads to maximize scale and avoid stranded investments  Improvement to the regional cost-sharing formulas

62

slide-63
SLIDE 63

Page 63 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Coordination of Regional Investments

 Urbandale’s lower-cost facility constructed around 2034 +/- because that’s what makes the most sense in their individual case – but region could benefit sooner  West Des Moines’ does not appear to be able to use the full capacity of both its existing and proposed plants – but that capacity could be used regionally

63

Total regional costs could possibly be reduced with additional coordination of capacity expansions at a regional level

slide-64
SLIDE 64

Page 64 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Consolidation of Base Loads

500 1,000 1,500 2,000 2,500 3,000 3,500 4,000 2018 2020 2022 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 2046 2048 2050 2052 2054 2056 2058 2060 Annual Demand (MG) Future Local Production Purchased Capacity Wholesale with Storage For example, Urbandale will move up to 8 MGD of base load from DMWW to its own plant; reduces demand by 3 billion gallons per year – that’s $5.8 million in costs that others need to absorb

E.g. Urbandale Forecasted Water Usage by Source

slide-65
SLIDE 65

Page 65 FCS GROUP

DRAFT – PRELIMINARY RESULTS

Improve Regional Cost-Sharing

This is normal and reflects the investments in the system, but it would not work as well for a joint

  • wnership model; a regional model should produce a standard (blended) rate for avg. and max-day

demand, with explicit credits for cash and asset contributions. $0.00 $1.00 $2.00 $3.00 $4.00 $5.00 $6.00 $7.00 $8.00 $9.00 $10.00 2020 2025 2030 2035 2040 2045 2050 2055 2060 Des Moines Inside Retail Wholesale w/ Storage Purchased Capacity

Wholesale rate is up to 40% more than the DM retail rate The DM retail rate is up to 70% higher than the current purchased cap. rate

slide-66
SLIDE 66

Next Steps

slide-67
SLIDE 67

Page 67 FCS GROUP

DRAFT – PRELIMINARY RESULTS

The Steps to Get to the Answers

Status Quo Forecasts Future Cost Sharing Plan Authority Forecasts June 27 July 30 August 27

How much can each community expect to pay for produced water based on today’s production functions? How will future costs be shared if the Authority assumes responsibility for rate setting and regional water production? How much can each community expect to pay for produced water assuming the Authority is responsible for all delivery?