Loading...
HomeMy WebLinkAboutItem 4City of Lakeville Administration Memorandum To: Mayor and City Council From: Justin Miller, City Administrator Date: June 22, 2020 Subject: Dakota Communications Center (DCC) Governance At the previous City Council work session, there was a request to update the council on the Dakota Communications Center (DCC) financing and governance model. Attached to this report is the draft 2021 DCC budget. Due to COVID related concerns and remote meeting issues, the DCC Board of Directors will not be approving this budget until later this summer, so the final numbers may change somewhat. Over the past several years, the member cities (all Dakota County cities) have been requesting that Dakota County take a more active role in the financing/operational management of the DCC. Recently, the DCC Board of Directors formed a committee to address this concern. Both myself (Executive Committee) and Councilmember Volk (as the city’s DCC representative) were named to this committee. The committee has met once and will be meeting again on the morning of June 22nd, so we will have an update at the council’s work session. Dakota Communications Center 2021 PROPOSED BUDGET   To: Board of Directors    The Dakota Communications Center’s 2021 budget was developed with regard to the  Board of Director’s desire to provide a high level of service while remaining fiscally  responsible. Working with our Public Safety Partners and taking into account industry  standards and best practices, the staff is committed to continual evaluation and  improvement.     Major Initiatives   The following items are new to the budget in 2021 and reflect the desire  to improve services while being fiscally responsible.    The Vesta 911 phone system in place at the DCC since 2015 is in need of a  hardware refresh. This will extend the life of the system an additional 5 years.    The Equature Recording system is also in need of a hardware refresh which will  also extend the life of the system. These systems are likely to make some  advancements in the coming years in response to NG911. Extending the life of the  current system will allow systems to mature before considering a wholesale  replacement.    The addition of a LaserFiche system will help automate and streamline our current  manual document management. Working with LOGIS will be much more  economical than doing this on our own.      Member Fees   The proposed 2021 budget is premised on an $9.5 million member fee  assessment which is a 2.9% increase over the 2020 membership fee.   The 2.9% increase  reflects additional enhanced services, mandated technology and salary increases.  The fee  is assessed to member agencies based on a 3‐year average of actual CAD calls.   The  assessment increase or decrease may, therefore, vary between agencies depending on  the number of actual calls.     Cost of Service    The primary expenses financed with member fees are personnel (68%),  operating costs such as technology support and facilities maintenance (27%) and long‐ term equipment acquisitions and  replacements (5%).  The DCC staffing levels are proposing to  add a .5 FTE Dispatcher in 2021 bringing  the number of dispatchers to 53.5.  Staffing needs due to call load and  changing technology continues to be re‐ evaluated. The most significant factor  affecting near‐term cost adjustments are  those related to wages and benefits.  Prudent long‐term financial planning has been an enduring priority which enables the DCC  to have reasonable member fees.   This is exemplified by the 10‐year plan which is  projecting no member fee increase for equipment acquisition and replacement for the  foreseeable future.    Acknowledgements   I would like to express my sincere appreciation to the Executive  Committee and the Board of Directors for their support. Special thanks to Logan Martin,  Matt Smith and Melanie Mesko‐Lee for their review and input. A sincere thanks to Jerilyn  Erickson and David Lang from the Lakeville Finance Department for all of their efforts  throughout the year on the Dakota Communications Center financial matters.    Recommendation   The DCC staff recommends approval of the budget as provided  herein.     Respectfully submitted,     Tom Folie Personnel 7,234,174         68% Other 2,843,009         27% Equipment 573,000             5% 10,650,183        PERSONNEL  $7,234,174  68% OTHER  $2,843,009   27% EQUIPMENT  $573,000 5%  Cost of Services 1 BUDGET OVERVIEW    The budget is organized into separate funds in order to properly account for  organizational business activities and long‐term capital replacement in addition to serving  as a financial report to demonstrate that membership fees are being effectively managed.    The funds are as follows:     General Fund.  The General Fund accounts for the overall operations of the DCC.     Capital Projects Fund.  The Capital Projects Fund accounts for expenditures  related to equipment acquisitions and replacements.    A consolidated statement of revenues, expenditures and changes in fund balance for the  coming year is as follows:    Capital General Projects Fund Fund Total Revenues Member fees 9,126,112$ 394,700$    9,520,812$  Other 645,859      26,600        672,459            Total revenues 9,771,971   421,300      10,193,271  Expenditures Personnel 7,234,174    ‐              7,234,174    Commodities 22,293         ‐              22,293         Contractual 2,820,716    ‐              2,820,716    Capital outlay ‐              573,000      573,000            Total expenditures 10,077,183 573,000      10,650,183  Net changes (305,212)     (151,700)     (456,912)      Beginning fund balance 1,391,595   1,611,468   3,003,063    Fund balance ‐ unassigned 1,086,383$ 1,459,768$ 2,546,151$  10.8%Fund balance  as % of expenditures Proposed 2021 Budget Statement of Revenues, Expenditures and Changes in  Fund Balance      2 General Fund    Member fees are proposed to increase for the coming year, primarily in response to  increase personnel costs; legal fees; website redesign; contractual maintenance  agreements and LOGIS. The proposed 2021 budget is $10,077,183 which is a $305,530  increase when compared to the 2020 Adopted Budget.      Adopted Proposed Increase 2020 2021 (decrease) Revenues Member fees 8,860,303$   9,126,112$      265,809$     Other 642,869        645,859           2,990                Total revenues 9,503,172     9,771,971        268,799       Expenditures Personnel 7,081,513     7,234,174        152,661       Commodities 21,954          22,293             339              Contractual 2,668,186     2,820,716        152,530            Total expenditures 9,771,653     10,077,183      305,530       Net changes (268,481)$     (305,212)$        (36,731)$          Revenues      Membership fees provide the majority (93%) of the resources for financing operations.  Other General Fund revenues are comprised on State aids (911 fees), MTNS partnership  revenues, LMCIT rebates and interest revenues.   911 fee revenue provided by State of  Minnesota are projected to remain unchanged due to the State’s distribution formula.  Interest rates, MTNS partnership revenues and LMCIT rebates are anticipated to remain  stable.    Expenditures    Personnel.  The DCC Board has authorized 66 personnel positions of which 53 are  dispatchers. The proposed budget includes adding one additional supervisor mid‐year for  2021. The proposed budget also takes into consideration step increases based on current  union contracts and non‐union personnel policies which are related to resignations and  retirements.  The collective bargaining contracts expire December 31, 2021.    Non‐personnel costs.    Non‐personnel expenses ($2.84 million) are comprised of facility  lease payments, equipment and building maintenance, utilities, technology support and  other related costs. Non‐personnel costs are projected to increase by $153,000 when  compared to the adopted 2020 budget.  3     Fund Balance      The Dakota Communications Center Fund Balance policy states: “The Dakota  Communications Center will endeavor to maintain an unassigned fund balance  equivalent to 8.3% ‐ 14.0% of total annual operating expenses to provide adequate  working capital for operations and reserves for unanticipated events in order to avoid  short term borrowing.”      The proposed General Fund budget has an ending fund balance which is within the  guidelines of the Fund Balance policy.    2021 Proposed Revenues 9,771,971$       Expenditures (10,077,183)           Net increase/(decrease) (305,212)           Fund balance January 1 1,824,316         Non‐spendable and assigned (432,721)$         Fund balance December 31 1,086,383$       Fund balance as a % of  expenditures 10.8%                        4   Capital Projects Fund    The primary purpose of the Capital Projects Fund is to provide for acquisition and  replacement of equipment which are financed with member fees.      The Dakota Communications Center has established a firm foundation for long term  financing of equipment acquisitions and replacements. Therefore, member fees are  projected to remain at $394,000 per year.     Proposed 2021 capital outlay acquisitions are as follows:   2021 E911 Telephone Backbone System 500,000$      CAD PC's  and Monitors  24,000          Laserfiche Scanner 5,500            Computer Replacements 13,500          Office Furniture Replacement 21,000          Conference Room Chairs (10) 9,000                 Total Capital Projects  Expenditures 573,000$             5 Membership Fees    The 2021 membership fees are proposed to be $9,520,811 which is a 2.9% increase over  2020.  The member fees are allocated based on the 3‐year average of CAD incidents and  covers both general operations as well as capital acquisitions.    Allocation %TOTAL Apple Valley 10.84%1,032,170       (1,517)           Burnsville 13.41%1,276,684       (12,845)         Dakota County 7.50%714,315          18,259           Eagan 16.14%1,536,997       82,928           Farmington 3.45%328,380          23,863           Hastings 5.55%528,513          5,720             Inver Grove Heights 8.85%842,716          66,199           Lakeville 12.72%1,210,904       8,412             Mendota  Heights 2.97%283,084          32,613               Miesville 0.03%2,677              95                      Randolph Hampton 0.05%5,032              295                Rosemount 4.60%438,416          7,853             South Saint Paul 7.19%684,252          24,658           West Saint Paul 6.69%636,671          9,273                  Total 100.00% 9,520,811$     265,806$       2021 Member Fees Increase/ (decrease)   The member fee represents an average cost of $28.31 per CAD incident.      Operational Forecast    Staff has incorporated a projection of operational costs for years 2022‐2025 based on  conservative inflationary assumptions.  The 2021 projection reflects the addition of .5 FTE  dispatcher.          6 Supporting Information    The following documents provide supporting information for the 2021 proposed  budget:    1) General Fund Budget Summary (including 2022‐2025 projections)  2) Authorized Staffing Plan  3) Capital Improvement Plan (2021‐2030)  4) Member Allocation  5) 2021 Member Fees  2018 20192020 20202021 2022 2023 2024 2025ActualActualAdoptedEstimateProposedEstimateEstimateEstimateEstimateRevenues4490 JPA Membership Fees 8,368,563$ 8,686,572$ 8,860,303$ 8,860,303$ 9,126,112$ 9,308,634$ 9,494,807$ 9,494,807$ 9,494,807$ JPA Membership Fees - REBATED - - - (372,925) - - - - - 4258 Annual 911 Fees 581,696 581,696 581,696 581,696 581,696 581,696 581,696 581,696 581,696 4910 Interest on Investments 15,457 141,773 17,059 18,020 25,050 21,773 54,530 46,213 40,559 4280 Grants and other income 22,318 18,262 21,113 19,613 19,613 11,613 11,863 12,119 12,382 5026 LMCIT rebate 1,844 1,752 5,000 1,500 1,500 1,538 1,576 1,615 1,655 4495 MTNS Partnership Income18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 Total Revenues9,007,878 9,448,055 9,503,172 9,126,207 9,771,971 9,943,254 10,162,472 10,154,450 10,149,099 ExpendituresPersonnel Services6012 Salaries - Regular 4,177,705 4,388,212 4,921,638 4,850,866 5,147,105 5,246,325 5,419,483 5,554,970 5,693,844 6015 Overtime 560,717 590,450 408,842 410,821 416,174 425,364 435,999 446,899 458,071 6041 Pera 348,418 368,321 400,406 394,449 417,068 426,306 436,964 447,888 459,085 6044 Fica 349,369 366,589 408,541 402,519 425,591 434,832 445,703 456,846 468,267 6051 Hospitalization Insurance 627,934 648,347 749,313 677,943 747,367 826,961 847,635 868,826 890,547 6052 Life and Disability 1,304 2,088 2,076 2,259 2,058 2,435 2,496 2,558 2,622 6053 Long Term Disability 11,838 11,817 12,517 12,076 12,364 12,961 13,285 13,617 13,957 6054 Dental 30,027 31,773 33,782 29,340 34,056 35,680 36,572 37,486 38,423 6055 Workers Compensation Insurance 24,405 27,931 31,598 30,105 32,391 33,018 33,843 34,689 35,556 6057 Unemployment - 1,534 - - - - - - - 6058 Contingency- - 112,800 - - - - - - Total Personnel Services6,131,717 6,437,062 7,081,513 6,810,378 7,234,174 7,443,882 7,671,980 7,863,779 8,060,372 Commodities6120 Operating Supplies 8,779 9,962 12,630 12,630 12,969 13,229 13,514 13,805 14,103 6140 Clothing 3,247 3,935 3,399 3,399 3,399 3,467 3,536 3,607 3,679 6180 Computer Supplies3,300 4,381 5,925 5,925 5,925 6,044 6,165 6,288 6,414 Total Commodities15,326 18,278 21,954 21,954 22,293 22,740 23,215 23,700 24,196 Dakota Communications CenterGeneral Fund BudgetPage 7 2018 20192020 20202021 2022 2023 2024 2025ActualActualAdoptedEstimateProposedEstimateEstimateEstimateEstimateDakota Communications CenterGeneral Fund BudgetOther Contractual6210 Professional Services 83,088 51,202 55,900 53,307 57,171 51,349 51,938 52,539 53,152 6211 Legal Services 2,590 10,460 9,000 14,000 27,200 24,400 28,308 25,224 29,148 6214 Fiscal Agent 68,352 69,984 71,400 71,448 73,590 75,062 76,563 78,094 79,656 6218 Bank Charges 215 284 392 350 350 357 364 371 378 6221 Audit 10,500 11,500 11,050 12,000 12,500 12,750 13,005 13,265 13,530 6234 Use of Personal Auto 2,375 1,536 3,100 2,000 2,000 2,040 2,081 2,123 2,165 6252 Print Public Information 2,865 3,395 4,100 4,100 4,220 4,304 4,390 4,478 4,567 6261 General Liability Insurance 29,877 31,031 31,186 30,402 31,822 32,458 33,108 33,770 34,446 6276 Telephone 39,219 40,457 42,110 41,000 42,110 42,952 43,811 44,687 45,581 6277 Postage 143 774 450 450 450 450 450 450 450 6280 Other Contractual 60,800 58,420 60,500 62,800 82,764 65,007 66,295 67,609 68,949 6282 Contract Equipment Maintenance 172,641 189,519 206,029 195,029 235,773 235,864 239,831 244,407 35,972 6283 Contract Building Maintenance 372,126 374,066 380,702 392,000 401,525 399,556 407,747 416,102 424,624 6288 Contract Data Processing 905,605 950,303 988,925 987,182 1,032,073 1,052,715 1,073,769 1,095,244 1,117,147 6289 Radio Fees 36,623 36,630 49,085 49,070 55,206 56,310 57,436 58,585 59,757 6290 Equipment Rental 3,785 4,445 4,092 4,342 4,553 4,106 4,226 4,317 4,410 6291 Building Lease 715,500 715,500 715,500 715,500 715,500 473,800 - - - 6311 Schools and Conferences 24,902 39,293 32,640 39,330 39,330 39,293 39,959 40,818 41,694 6312 Business Meetings & Expenses 188 141 400 350 350 350 350 350 350 6313 Dues and Subscriptions979 1,778 1,625 2,163 2,229 2,273 2,319 2,365 2,412 Total Other Charges and Services2,532,373 2,590,717 2,668,186 2,676,822 2,820,716 2,575,396 2,145,950 2,184,798 2,018,389 Total Expenditures 8,679,416 9,046,057 9,771,653 9,509,155 10,077,183 10,042,018 9,841,145 10,072,277 10,102,957 Other Financing Sources/(Uses)Principal Maturities (263,466) - - - - - - - - Interest(4,299) - - - - - - - - Total Other Financing Sources (Uses)(267,765) - - - - - - - - Net change in fund balance 60,697 401,998 (268,481) (382,947) (305,212) (98,765) 321,327 82,174 46,142 Fund balance refund - - - - - - - Fund balance January 1 1,744,569 1,805,266 1,493,732 2,207,264 1,824,316 1,519,104 1,420,339 1,741,666 1,823,840 Non-spendable and Assigned(627,915) (567,891) (522,673) (489,236) (432,721) (443,539) (454,628) (465,993) (477,643) Unreserved fund balance - December 311,177,351$ 1,639,373$ 702,578$ 1,335,080$ 1,086,383$ 976,800$ 1,287,038$ 1,357,846$ 1,392,339$ Total expenditures (Net) 8,947,181 9,046,057 9,771,653 9,509,155 10,077,183 10,042,018 9,841,145 10,072,277 10,102,957 Unreserved fund balance ratio 13.2% 18.1% 7.2% 14.0% 10.8% 9.7% 13.1% 13.5% 13.8%Fund Balance Expected Per Policy (1/12th of the annual expenditures) 792,430 839,765 836,835 820,095 839,356 841,913 Over/(Short) of minimum 8.3% 542,650 246,617 139,965 466,943 518,490 550,426 Over/(Short) of maximum 14% 3,798 (324,423) (429,083) (90,722) (52,272) (22,075) Page 8 2018 20192020 20202021 2022 2023 2024 2025ActualActualAdoptedEstimateProposedEstimateEstimateEstimateEstimateDakota Communications CenterGeneral Fund BudgetSUMMARY:Personnel 6,131,717$ 6,437,062$ 7,081,513$ 6,810,378$ 7,234,174$ 7,443,882$ 7,671,980$ 7,863,779$ 8,060,372$ Change from prior year 105,386 305,345 949,796 373,316 423,796 209,708 228,098 191,799 196,593 Percentage Change from prior year 1.7% 5.0% 15.5% 6.1% 6.2% 2.9% 3.1% 2.5% 2.5%Commodites 15,326 18,278 21,954 21,954 22,293 22,740 23,215 23,700 24,196 Change from prior year (8) 2,952 6,628 3,676 339 447 475 485 496 Percentage Change from prior year -0.1% 19.3% 43.2% 24.0% 1.5% 2.0% 2.1% 2.1% 2.1%Other Contractual 2,532,373 2,590,717 2,668,186 2,676,822 2,820,716 2,575,396 2,145,950 2,184,798 2,018,389 Change from prior year 116,512 58,344 135,813 86,105 143,893 (245,320) (429,446) 38,848 (166,409) Percentage Change from prior year 4.8% 2.3% 5.4% 3.4% 5.4% -8.7% -16.7% 1.8% -7.6%Total Expenditures 8,679,416 9,046,057 9,771,653 9,509,155 10,077,183 10,042,018 9,841,145 10,072,277 10,102,957 Change from prior year 221,890 366,641 1,092,237 463,097 568,029 (35,165) (200,874) 231,132 30,680 Percentage Change from prior year 2.6% 4.2% 12.6% 5.3% 6.0% -0.3% -2.0% 2.3% 0.3%Page 9 2019 2020 2021 2022 2023 2024 Position Titles Dispatch Operations Dispatchers 53.0 53.0 53.5 54.0 54.5 55.0 Shift Supervisors (incl Training/Cad Sup.) 7.0 8.0 8.0 8.0 8.0 8.0 Total operations 60.0 61.0 61.5 62.0 62.5 63.0 Admin & Technical Support Operations Director 1.0 1.0 1.0 1.0 1.0 1.0 Executive Director 1.0 1.0 1.0 1.0 1.0 1.0 HR Coordinator/Executive Assistant 1.0 1.0 1.0 1.0 1.0 1.0 Technical Support 2.0 2.0 2.0 2.0 2.0 2.0 Total administrative and technical 5.0 5.0 5.0 5.0 5.0 5.0 Total staffing (f.t.e.) 65.0 66.0 66.5 67.0 67.5 68.0 Dakota Communication Center Authorized Staffing Plan Full time equivalents Page 10 Capital Improvement PlanTen Year PlanActual Actual 2020 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030Item20182019AdoptedEstimateProposedEstimateEstimateEstimateEstimateEstimateEstimateEstimateEstimateEstimateRevenuesMember assessment 394,700 394,700 394,700 394,700 394,700 394,700 394,700 394,700 394,700 394,700 394,700 394,700 394,700 394,700 Sale of Assets 1,572 4,200 - - - - - - - - - - - - Debt - - - - - - - - 1,200,000 3,000,000 - - - Interest on Investments 28,741 32,208 12,700 26,600 26,600 28,400 34,600 37,600 41,100 42,000 40,800 33,100 25,600 27,600 Total revenues 425,013 431,108 407,400 421,300 421,300 423,100 429,300 432,300 435,800 1,636,700 3,435,500 427,800 420,300 422,300 ExpendituresCAD Equipment:CAD Replacement -LOGIS - - - - - - - - - 3,000,000 - - - CAD Replacement - LOGIS (refund)CAD PC's and Monitors 20,309 18,183 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 25,000 25,000 25,000 Video Display Panels - - - - - - - - - - - - - CAD Backup Laptops (12) - 15,828 - - - - - 24,000 - - - - 24,000 - CAD Integration to TriTech - - - - - - - - - - - - - Dispatching:23 Dispatch Radio Consoles - - - - - - - - 1,897,650 - - - - Logging telephone/Radio recorder - - - - - - 342,000 - - - 350,000 - - Fire Alerting Control System 567,103 7,460 - - - - - - - - - - - - 23 Dispatch Work Stations 3,985 - - - - - - - - - 325,000 - - Dispatch Chairs - - - - - 29,000 - - - - - - - Touch Screen Monitors 23 - - - - 24,000 - - - - 24,000 - - - Dispatch Desktop Radios (2) - - - - - - - - - 9,000 - - - Emergency Fire Dispatching - 54,400 - 38,400 - - - - - - - - - - Data Display Wall - 230,000 200,000 - - - - - - 125,000 - - - Telephone Systems:E911 Telephone Backbone system - - - 500,000 - - - - - - 520,000 - - Text-to-911 31,337 - - - - - - - - - - - - Abandonment Device Switch (Centurylink)13,800 - - - - - - - - - - - - Antenna/Radios:Radios - handheld-desktop control - - - - - - - - - - 90,000 - - RAD - 5,000 5,000 - - - - - - - - 10,000 - Antenna Replacements - 7,172 - - - - - - - - - - - - Antenna Upgrades - - - - - - - - - - - - - VHF Welch Site - - - - - - - - - - - - - Information Technology:Cisco 3750 series switch (3) - 26,087 - - - - - 20,000 - - - - 21,000 - Cisco ASA 5520 (2) Firewall - 625 - - - - - 12,000 - - - - 12,900 - WiFi Devices and Controller - 781 - - - - - 3,000 - - - - 3,100 - Exchange & File Servers - 10,435 - - - - - - - - - - - - Fiber expansion - - - - - - - - - - - - - Servers for Active Directory & Exchange 2,235 - - - 11,000 - - - 11,000 - - - - NEW - Scanner for Laserfiche5,500 Page 11 Capital Improvement PlanTen Year PlanActual Actual 2020 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030Item20182019AdoptedEstimateProposedEstimateEstimateEstimateEstimateEstimateEstimateEstimateEstimateEstimateAdministrative:Supervisory Office Desktop PCs (4) 1,869 4,080 2,000 2,000 2,000 6,000 - 2,000 6,000 - 2,000 6,000 - - Tech support Laptop PCs (2) 3,737 - - 4,000 - - 4,000 - - 4,000 - - - Admin Area Laptop/PCs (3) 7,323 - - 7,500 - - 7,500 - - 7,500 - - - Admin Area Phones 3,456 836 1,000 1,000 - - - - - - - - 20,000 - Building Furniture/Other:Training Room Tables (20 & Chairs (40) 8,109 - - - - - - - - 25,000 - - - Training Room Chairs (40) - - - - - - - - - - - - - Excercise Equipment- 5 pieces - 2,500 - - - 2,500 - - 3,000 - - - 3,000 - Training room projector-ceiling mount - - - - - - - - - - - - - Breakroom Furniture - New (4 tables/16 chrs) - - - - - 8,000 - - - - - - - Office Furniture21,000 Lobby Furniture - (4 chairs) - - - - - 6,000 - - - - - - - Conference tables, Glass Covers & Chairs - - - 9,000 - 5,000 - - - - - - - Workstations - 381,153 - - - - - - - - - - - Debt Repayment - - - - - - - - - 60,000 148,200 137,300 327,300 - - - - - - - - - - - - - - Total expenditures 649,463 543,340 262,000 270,400 573,000 67,500 72,000 438,500 33,000 1,932,650 3,280,500 1,464,200 256,300 352,300 Net increase or (decrease) (224,450) (112,232) 145,400 150,900 (151,700) 355,600 357,300 (6,200) 402,800 (295,950) 155,000 (1,036,400) 164,000 70,000 Fund Balance, January 1 1,685,018 1,460,568 1,017,918 1,460,568 1,611,468 1,459,768 1,815,368 2,172,668 2,166,468 2,569,268 2,273,318 2,428,318 1,391,918 1,555,918 Fund Balance December 311,460,568 1,348,336 1,163,318 1,611,468 1,459,768 1,815,368 2,172,668 2,166,468 2,569,268 2,273,318 2,428,318 1,391,918 1,555,918 1,625,918 - - Page 12 2017 2020 Member Total % Total % Total %Allocation Apple Valley 36,579 11.25% 36,622 10.82% 36,083 10.45%10.84% Burnsville 46,283 14.24% 44,955 13.28% 43,877 12.71%13.41% Dakota County 24,094 7.41% 26,001 7.68% 25,598 7.42%7.50% Eagan 50,288 15.47% 54,099 15.98% 58,615 16.98%16.14% Farmington 10,433 3.21% 11,699 3.46% 12,710 3.68%3.45% Hastings 18,914 5.82% 17,864 5.28% 19,186 5.56%5.55% Inver Grove Hts 30,098 9.26% 30,438 8.99% 28,664 8.30%8.85% Lakeville 38,561 11.86% 43,769 12.93% 46,132 13.36%12.72% Mendota Hts 8,597 2.64% 10,771 3.18% 10,679 3.09%2.97% Miesville 102 0.03% 97 0.03% 84 0.02%0.03% Randolph Hampton 175 0.05% 173 0.05% 185 0.05%0.05% Rosemount 14,603 4.49% 15,685 4.63% 16,186 4.69%4.60% South St. Paul 24,138 7.43% 24,180 7.14% 24,138 6.99%7.19% West St. Paul 22,183 6.82% 22,184 6.55% 23,074 6.68%6.69% Total 325,048 100.0% 338,537 100.0% 345,211 100.0%100.0% Percent Change in CAD Events 4.1% 2.0% 2019 2020 2021 Member Apple Valley 11.01% 11.17% 10.84% -0.33% Burnsville 14.46% 13.93% 13.41% -0.52% Dakota County 7.69% 7.52% 7.50% -0.02% Eagan 14.99% 15.71% 16.14% 0.43% Farmington 3.31% 3.29% 3.45% 0.16% Hastings 6.09% 5.65% 5.55% -0.10% Inver Grove Hts 7.59% 8.39% 8.85% 0.46% Lakeville 13.40% 12.99% 12.72% -0.27% Mendota Hts 2.37% 2.71% 2.97% 0.27% Miesville 0.03% 0.03% 0.03% 0.00% Randolph Hampton 0.05% 0.05% 0.05% 0.00% Rosemount 4.85% 4.65% 4.60% -0.05% South St. Paul 6.98% 7.13% 7.19% 0.06% West St. Paul 7.18% 6.78% 6.69% -0.09% Total 100.0% 100.0% 100.0%0.0% Formula: ( + Year 1 CAD % + Year 2 CAD % + Year 3 CAD %) ÷ 3 = Member allocation Allocation Allocation of Member Fees 2018 2019 % change CAD Events Page 13 Capital General Projects %Fund Fund TOTAL Apple Valley 11.17%989,603 44,084 1,033,687 Burnsville 13.93%1,234,534 54,995 1,289,529 Dakota County 7.52%666,371 29,685 696,056 Eagan 15.71%1,392,057 62,012 1,454,069 Farmington 3.29%291,530 12,987 304,517 Hastings 5.65%500,497 22,296 522,793 Inver Grove Heights 8.39%743,401 33,116 776,517 Lakeville 12.99%1,151,207 51,285 1,202,492 Mendota Heights 2.71%239,789 10,682 250,471 Miesville 0.03%2,472 110 2,582 Randolph Hampton 0.05%4,535 202 4,737 Rosemount 4.65%412,201 18,362 430,563 South Saint Paul 7.13%631,464 28,130 659,594 West Saint Paul 6.78%600,641 26,757 627,398 100.00%8,860,303$ 394,700$ 9,255,005$ Proposed Capital General Projects Percentage %Fund Fund TOTAL Change Apple Valley 10.84%989,380 42,790 1,032,170 (1,517) -0.15% Burnsville 13.41%1,223,757 52,927 1,276,684 (12,845) -1.00% Dakota County 7.50%684,702 29,613 714,315 18,259 2.62% Eagan 16.14%1,473,278 63,719 1,536,997 82,928 5.70% Farmington 3.45%314,766 13,614 328,380 23,863 7.84% Hastings 5.55%506,603 21,910 528,513 5,720 1.09% Inver Grove Heights 8.85%807,780 34,936 842,716 66,199 8.53% Lakeville 12.72%1,160,702 50,202 1,210,904 8,412 0.70% Mendota Heights 2.97%271,348 11,736 283,084 32,613 13.02% Miesville 0.03%2,566 111 2,677 95 3.68% Randolph Hampton 0.05%4,823 209 5,032 295 6.23% Rosemount 4.60%420,241 18,175 438,416 7,853 1.82% South Saint Paul 7.19%655,885 28,367 684,252 24,658 3.74% West Saint Paul 6.69%610,277 26,394 636,671 9,273 1.48% 100.00%9,126,112$ 394,700$ 9,520,811$ 265,806$ 2.87% 3.00% 0.00% 2.87% Increase/ (decrease) 2021 Member Fees 2020 Member Fees Dakota Communications Center Member Fees Page 14 Dakota Communications Center Member Fees Proposed Capital General Projects Percentage %Fund Fund TOTAL Change Apple Valley 10.84%1,009,167 42,790 1,051,957 19,787 1.92% Burnsville 13.41%1,248,233 52,927 1,301,160 24,476 1.92% Dakota County 7.50%698,396 29,613 728,009 13,694 1.92% Eagan 16.14%1,502,744 63,719 1,566,463 29,466 1.92% Farmington 3.45%321,062 13,614 334,676 6,296 1.92% Hastings 5.55%516,735 21,910 538,645 10,132 1.92% Inver Grove Heights 8.85%823,936 34,936 858,872 16,156 1.92% Lakeville 12.72%1,183,917 50,200 1,234,117 23,213 1.92% Mendota Heights 2.97%276,775 11,736 288,511 5,427 1.92% Miesville 0.03%2,618 111 2,729 52 1.94% Randolph Hampton 0.05%4,919 209 5,128 96 1.90% Rosemount 4.60%428,646 18,175 446,821 8,405 1.92% South Saint Paul 7.19%669,003 28,367 697,370 13,118 1.92% West Saint Paul 6.69%622,483 26,394 648,877 12,206 1.92% 100.00%9,308,634$ 394,700$ 9,703,334$ 182,523$ 1.92% 2.00% 0.00% 1.92% Proposed Capital General Projects Percentage %Fund Fund TOTAL Change Apple Valley 10.84%1,029,351 42,790 1,072,141 20,184 1.92% Burnsville 13.41%1,273,197 52,927 1,326,124 24,964 1.92% Dakota County 7.50%712,364 29,613 741,977 13,968 1.92% Eagan 16.14%1,532,799 63,719 1,596,518 30,055 1.92% Farmington 3.45%327,483 13,614 341,097 6,421 1.92% Hastings 5.55%527,070 21,910 548,980 10,335 1.92% Inver Grove Heights 8.85%840,415 34,936 875,351 16,479 1.92% Lakeville 12.72%1,207,596 50,200 1,257,796 23,679 1.92% Mendota Heights 2.97%282,310 11,736 294,046 5,535 1.92% Miesville 0.03%2,670 111 2,781 52 1.91% Randolph Hampton 0.05%5,017 209 5,226 98 1.91% Rosemount 4.60%437,219 18,175 455,394 8,573 1.92% South Saint Paul 7.19%682,383 28,367 710,750 13,380 1.92% West Saint Paul 6.69%634,932 26,394 661,326 12,449 1.92% 100.00%9,494,807$ 394,700$ 9,889,506$ 186,172$ 1.92% 2.00% 0.00% 1.92% Increase/ (decrease) 2023 Member Fees (decrease) Increase/ 2022 Member Fees Page 15 Dakota Communications Center Member Fees Proposed Capital General Projects Percentage %Fund Fund TOTAL Change Apple Valley 10.84%1,029,351 42,790 1,072,141 - 0.00% Burnsville 13.41%1,273,197 52,927 1,326,124 - 0.00% Dakota County 7.50%712,364 29,613 741,977 - 0.00% Eagan 16.14%1,532,799 63,719 1,596,518 - 0.00% Farmington 3.45%327,483 13,614 341,097 - 0.00% Hastings 5.55%527,070 21,910 548,980 - 0.00% Inver Grove Heights 8.85%840,415 34,936 875,351 - 0.00% Lakeville 12.72%1,207,596 50,200 1,257,796 - 0.00% Mendota Heights 2.97%282,310 11,736 294,046 - 0.00% Miesville 0.03%2,670 111 2,781 - 0.00% Randolph Hampton 0.05%5,017 209 5,226 - 0.00% Rosemount 4.60%437,219 18,175 455,394 - 0.00% South Saint Paul 7.19%682,383 28,367 710,750 - 0.00% West Saint Paul 6.69%634,932 26,394 661,326 - 0.00% 100.00%9,494,807$ 394,700$ 9,889,506$ -$ 0.00% 0.00% 0.00% 0.00% Proposed Capital General Projects Increase/ Percentage %Fund Fund TOTAL (decrease)Change Apple Valley 10.84%1,029,351 42,790 1,072,141 - 0.00% Burnsville 13.41%1,273,197 52,927 1,326,124 - 0.00% Dakota County 7.50%712,364 29,613 741,977 - 0.00% Eagan 16.14%1,532,799 63,719 1,596,518 - 0.00% Farmington 3.45%327,483 13,614 341,097 - 0.00% Hastings 5.55%527,070 21,910 548,980 - 0.00% Inver Grove Heights 8.85%840,415 34,936 875,351 - 0.00% Lakeville 12.72%1,207,596 50,200 1,257,796 - 0.00% Mendota Heights 2.97%282,310 11,736 294,046 - 0.00% Miesville 0.03%2,670 111 2,781 - 0.00% Randolph Hampton 0.05%5,017 209 5,226 - 0.00% Rosemount 4.60%437,219 18,175 455,394 - 0.00% South Saint Paul 7.19%682,383 28,367 710,750 - 0.00% West Saint Paul 6.69%634,932 26,394 661,326 - 0.00% 100.00%9,494,807$ 394,700$ 9,889,506$ -$ 0.00% 0.00% 0.00% 0.00% 2025 Member Fees (decrease) Increase/ 2024 Member Fees Page 16