Loading...
HomeMy WebLinkAboutSanitary Sewer Cooperative AgreementSTAFF REPORT DATE: September 14, 2021 DISCUSSION AGENDA ITEM: Oakdale Sewer Service Agreement TO: Mayor and Council SUBMITTED BY: Kristina Handt, City Administrator BACKGROUND: The City of Lake Elmo has been working with Oakdale to establish a sanitary sewer connection to Oakdale to serve the 180 acres located along Ideal Avenue and County State Aid Highway 14 (CSAH 14). The general terms of the agreement are outlined in the October 2020 letter from the City of Oakdale (attached). At the August 17th meeting, council approved a cooperative agreement for the construction of the lift station. This agreement was approved by Oakdale the following week along with the sewer service agreement contingent upon Lake Elmo approving the sewer service agreement. Last fall Oakdale contracted with SEH to review their system capacity for serving the 180 acres in Lake Elmo. That study found that the lift station would need to increase in size but that no other capital improvements would be needed at this time. Using the information from that study and the flows engineering used in the master plan process in early 2020 for the 180 acres, Oakdale also contracted with Baker Tily to do a cost allocation analysis to arrive at charges for Lake Elmo. ISSUE BEFORE COUNCIL: What questions does the council have about the sewer service agreement? PROPOSAL DETAILS/ANALYSIS: Included in your packet is the sewer service agreement. This governs the costs to Lake Elmo for Oakdale providing sewer to the 180 acres on Ideal Ave. The agreement includes two exhibits. Exhibit A-Lake Elmo Sewer Cost Allocation Concept which has Lake Elmo paying for a pro-rated portion of Oakdale’s sewer administration, lift station maintenance and collection system maintenance costs. Exhibit B-Sewer Cost Allocation to Serve 180 Acres is a spreadsheet where the pertinent data is entered each year to calculate the charges. Nick Dragisich from Baker Tily will be at the meeting to answer any questions council has about the cost allocation method. Following this meeting, the intention is to place the agreement on the agenda for the September 21st meeting. It’s important that work begin on the lift station design this month in order to be ready for construction to begin in the spring/summer of 2022. FISCAL IMPACT: To be determined based upon usage and expenses. ATTACHMENTS: • October 2020 Oakdale Sewer Letter • Sewer Service Agreement • Lake Elmo Sewer Cost Allocation Concept • Sewer Cost Allocation to Serve 180 Acres 1 DOCSOPEN\AK110\20\713604.v4-7/6/21 COOPERATIVE SERVICE AGREEMENT BETWEEN THE CITY OF OAKDALE AND THE CITY OF LAKE ELMO FOR THE COSTS ASSOCIATED WITH PROVIDING SANITARY SEWER SERVICES This COOPERATIVE SERVICE AGREEMENT (“the Agreement”), is made and entered into this ___ day of ________________, 2021 (the “Effective Date”), by and between the City of Oakdale (“Oakdale”), a Minnesota municipal corporation, and the City of Lake Elmo (“Lake Elmo”), a Minnesota municipal corporation. RECITALS WHEREAS, Lake Elmo has requested, by mutual agreement with Oakdale, to add future sanitary sewer flows from 180-acres of undeveloped land (“Property”) in Lake Elmo near Ideal Avenue and County Road 14, which is proposed to be developed with industrial, commercial, and residential uses; and WHEREAS, the sewage from the Property would flow to Oakdale’s existing Lift Station 6 located at Ideal Avenue and Stillwater Boulevard in Oakdale’s Sewer District 8, which then flows by gravity through Oakdale’s Sewer Districts 9, 11, 7, 12, 15, and 17; and WHEREAS, prior to adding such future sanitary sewer flows, Oakdale intends to make improvements to its sanitary sewer system on Stillwater Boulevard, including relocation of Lift Station 6 and improvements to related pumps, wet wells, force mains, and other sanitary sewer infrastructure (“Project”); and WHEREAS, Oakdale and Lake Elmo intend to enter into a cooperative agreement to facilitate Oakdale’s construction of the Project and Oakdale and Lake Elmo’s share in the costs of the Project; and WHEREAS, Oakdale and Lake Elmo also intend to enter into this separate Agreement to administer the ongoing obligations related to the Project, including to establish certain responsibilities and charges for Lake Elmo to pay to Oakdale for such future sanitary sewer flows. NOW THEREFORE, Oakdale and Lake Elmo agree as follows: AGREEMENT 1. PURPOSE The purpose of this Agreement is set forth in the above recitals, which are incorporated by reference as if fully set forth herein, and shall consist of this Agreement and Exhibit A (“Lake Elmo Sewer Cost Allocation Concept) and Exhibit B (“Sewer Cost Allocation to Serve 180 Acres”). 2 DOCSOPEN\AK110\20\713604.v4-7/6/21 2. SANITARY SEWER SERVICE Oakdale agrees to allow Lake Elmo to connect to Oakdale’s sanitary sewer system upon completion of the Project in order to allow Lake Elmo to provide sanitary sewer service to the Property. 3. COST PARTICIPATION AND ESTIMATED CHARGES AND ADJUSTMENTS Lake Elmo shall be responsible for payment of an annual charge to Oakdale for adding future sanitary sewer flows related to the Property. Lake Elmo shall also be responsible for the payment of any annual “true-up” adjustment to Oakdale. The estimated charges and adjustment attributable to Lake Elmo and payable to Oakdale are as set forth in Exhibit A of this Agreement. The charges and annual adjustment listed in Exhibit A are merely estimates and a final reconciliation of such charges and adjustments below shall be completed annually as set forth in Section 4. 4. PAYMENT A. Upon completion of the Project, Oakdale shall update Exhibit A to conform the Exhibit to the estimated annual charge. B. Each year, Oakdale shall examine sanitary sewer flows related to the Property and invoice Lake Elmo for the charge. C. Lake Elmo shall pay one hundred percent (100%) of an invoice amount within thirty (30) days of receipt. 5. MAINTENANCE Oakdale and Lake Elmo shall properly maintain its sanitary sewer systems according to state law to provide the Property with sanitary sewer service. Upon notification of a possible issue with sanitary sewer service related to this Project, both parties shall immediately inspect their respective sanitary sewer systems to determine the cause of the issue and any required maintenance. Each party shall be responsible for their own maintenance costs regardless of the cause of the issue. 6. INDEMNIFICATION A. Oakdale agrees that it will defend, indemnify, and hold harmless Lake Elmo against any and all liability, loss, damages, costs, and expenses which Lake Elmo may hereafter sustain, incur, or be required to pay by reason of any negligent act by the Oakdale, its agents, officials, officers, or employees during the performance of this Agreement. B. Lake Elmo agrees that it will defend, indemnify, and hold harmless the Oakdale against any and all liability, loss, damages, costs, and expenses which Oakdale may hereafter sustain, incur, or be required to pay by reason of any negligent act by Lake Elmo, its 3 DOCSOPEN\AK110\20\713604.v4-7/6/21 agents, officials, officers, or employees during the performance of this agreement. C. To the fullest extent permitted by law, actions by the parties to this Agreement are intended to be and shall be construed as a “cooperative activity.” It is the intent of the parties that they shall be deemed a “single governmental unit” for the purposes of liability, as set forth in Minnesota Statutes, Section 471.59, subdivision 1a (b). The parties to this Agreement are not liable for the acts or omissions of another party to this Agreement except to the extent they have agreed in writing to be responsible for the acts or omissions of the other parties as provided for in Minnesota Statutes, Section 471.59, subdivision 1a. D. Each party’s liability shall be governed by the provisions of Minnesota Statutes, Chapter 466 and other applicable law. The parties agree that liability under this Agreement is controlled by Minnesota Statutes, Section 471.59, subdivision 1a and that the total liability for the parties shall not exceed the limits on governmental liability for a single unit of government as specified in Minnesota Statutes, Section 466.04, subdivision 1(a). 7. DATA PRACTICES All data collected, created, received, maintained, disseminated, or used for any purposes in the course of this Agreement is governed by the Minnesota Government Data Practices Act, Minnesota Statutes Section 13.01, et seq. or any other applicable state statutes and state rules adopted to implement the Act, as well as state statutes and federal regulations on data privacy. 8. SEVERABILITY In the event that any provision of this Agreement shall be held invalid, illegal, or unenforceable by any court of competent jurisdiction, such holding shall pertain only to such provision and shall not invalidate or render unenforceable any other provision of this Agreement. 9. TERM AND TERMINATION This Agreement is effective as of the Effective Date indicated above and shall terminate upon thirty days’ notice by either party or upon mutual agreement of the parties. 10. NOTICES Any notice or correspondence to be given under this Agreement shall be deemed to be given if delivered personally or by mailed postage prepaid, certified mail, return receipt requested: 4 DOCSOPEN\AK110\20\713604.v4-7/6/21 (a) as to Oakdale: City of Oakdale 1584 Hadley Avenue North Oakdale, MN 55128 (b) as to Lake Elmo: City of Lake Elmo 3800 Laverne Ave N Lake Elmo, MN 55042 5 DOCSOPEN\AK110\20\713604.v4-7/6/21 IN WITNESS WHEREOF, the parties have caused this Agreement to be duly executed as of the Effective Date. OAKDALE CITY OF LAKE ELMO Paul Reinke, Mayor Charles Cadenhead, Mayor Date Date Christina Volkers, City Administrator Kristina Handt, City Administrator Date Date A-1 DOCSOPEN\AK110\20\713604.v4-7/6/21 EXHIBIT A Lake Elmo Sewer Cost Allocation Concept [TO BE ADDED] EXHIBIT B Sewer cost Allocation to Serve 180 Acres [TO BE ADDED] 1 Lake Elmo Sewer Connection From SHE Memo: • 200 – 300 peak GPM • Flow routing (SHE memo)) o Lift station 6 within Sewer District 8 o Gravity flow to Sewer Districts 9, 11, 7, 12, 15, and 17 to MCES interceptor o 2,700 feet of 10-inch force main from Lift Station 6 to 12-inch gravity sanitary sewer o District 12 has lift station all other are gravity o New lift station 6 cost $893,000 • Capacity of each district (page 2 of SEH memo) • Sewer flow MGD in each district (2020 volumes on page 2 of SHE memo) Potential allocation method: • Sewer Administration o Personnel service- $/million gallons flow based on previous year or projected flow with true up o Materials and Supplies - $/million gallons flow based on previous year or projected flow with true up o Contractual services excluding MCWW Sewer Charges- $/million gallons flow based on previous year or projected flow with true up o MWCC Sewer Charges - $/million gallons flow based on previous year or projected flow with true up o Capital and other –  Need detail on Rental Building to determine allocation basis  Depreciation – should only use depreciation on assets used by Lake Elmo then base allocation on $/million gallons flow based on previous year or projected flow with true up  Transfers – are these to the Utility System Replacement Fund? Probably no allocation if we allocate depreciation expenses  Refunds – need detail on where these go (customer refunds?) to determine allocation basis • Maintenance Lift stations – if there is a cost breakdown by lift station available, base allocation of $/million gallons flow based on previous year or projected flow with true up for the two lift stations Lake Elmo flow will pass through. If not, $/million gallons flow based on previous year or projected flow with true up • Collection system maintenance – Preferred method would be cost per inch-miles of pipe $/million gallons flow based on previous year or projected flow with true up if we can identify the inch-miles of pipe Lake Elmo flow will utilize otherwise base it on $/million gallons flow based on previous year or projected flow with true up. Data needs depending on allocations: • Lift station 12 capacity • Length and size of sewer mains by district for all districts (CAFR says 107 miles) • Length and size of sewer mains routing Lake Elmo flow • Peaking factor for each district 2 • MCES sewer charge rate • Depreciation schedule for assets o Sewer mains o Lift stations o Other Summary Actual Actual Adopted Adopted Personnel Services 2018 2019 2020 2021 725 5 550 4100 Wages-Regular 141,474$ 152,099$ 171,588$ 400,000$ 725 5 550 4100 Leave Time 43,662$ 45,077$ 47,200$ -$ 725 5 550 4111 Wages-Overtime 12,952$ 10,014$ 1,607$ 15,000$ 725 5 550 4115 Wages-Part Time -$ -$ 750$ -$ 725 5 550 4120 Wages-Temporary 2,919$ 3,224$ -$ -$ 725 5 550 4140 Employer PERA 14,535$ 15,841$ 14,219$ 23,500$ 725 5 550 4145 Employer FICA 14,711$ 15,669$ 15,103$ 24,500$ 725 5 550 4150 Employer Insurance 58,652$ 62,229$ 68,000$ 66,100$ 725 5 550 4154 Workmen’s Compensation In 46,970$ 49,685$ 62,500$ 62,500$ 725 5 550 4168 Standby Pay 6,555$ 7,721$ 7,500$ -$ Personnel Services 342,430$ 361,559$ 388,467$ 591,600$ Materials and Supplies 725 5 550 4200 Office Supplies 280$ 303$ 250$ -$ 725 5 550 4209 In House Copying 42$ -$ 550$ -$ 725 5 550 4210 Printing, Binding & Copying 485$ 310$ 700$ -$ 725 5 550 4211 Operating Supplies 3,056$ 1,928$ 3,000$ 4,000$ 725 5 550 4230 Uniforms & Clothing 5,327$ 5,299$ 6,000$ 6,000$ 725 5 550 4240 Repair & Maintenance Supp 45,100$ 41,700$ 37,700$ 45,000$ 725 5 550 4241 Equipment Parts 964$ 1,303$ 4,000$ -$ 725 5 550 4250 Small Tools 1,051$ 2,008$ 3,750$ 32,500$ Materials and Supplies 56,305$ 52,851$ 55,950$ 87,500$ Contractual Services 725 5 550 4300 Professional Services 11,500$ 10,500$ 18,000$ 80,000$ 725 5 550 4301 Other Contractual Service 68,584$ 50,212$ 65,000$ 2,500$ 725 5 550 4307 Charges from General 525,000$ 525,000$ 525,000$ 575,000$ 725 5 550 4324 License & Permits Fees -$ -$ 450$ -$ 725 5 550 4330 Postage & Meter Fees 4,621$ 4,618$ 5,000$ 5,000$ 725 5 550 4331 Telephone 6601 6,601$ 5,912$ 5,000$ 5,000$ 725 5 550 4332 Radio Services 1,782$ 1,841$ 336$ 2,000$ 725 5 550 4340 Travel Expenses 251$ 187$ 500$ -$ 725 5 550 4344 Books & Publications -$ -$ 500$ 500$ 725 5 550 4345 Dues & Subscriptions 512$ 450$ 900$ 900$ 725 5 550 4346 Meeting, Conferences & Schooling 612$ 1,491$ 4,000$ 4,500$ 725 5 550 4350 Advertising -$ -$ 1,500$ -$ 725 5 550 4360 Legal & Public Notices/Ad -$ -$ 200$ -$ 725 5 550 4370 Insurance - General Liability 68,587$ 49,355$ 97,500$ 97,500$ 725 5 550 4380 Electric Service 65,093$ 59,387$ 75,000$ 65,000$ 725 5 550 4390 MWCC Sewer Charges 2,354,100$ 2,283,251$ 2,328,014$ 2,374,574$ Contractual Services 3,107,243$ 2,992,204$ 3,126,900$ 3,212,474$ Capital and Other 725 5 550 4400 Repair & Maintenance 37,726$ 49,088$ 35,000$ 45,000$ 725 5 550 4402 Repair & Maintenance Equipment -$ 292$ 3,000$ -$ 725 5 550 4510 Rental Building 75,000$ 75,000$ 75,000$ 75,000$ 725 5 550 4700 Capital Outlay Other -$ 15,345$ 15,000$ 15,000$ 725 5 550 4701 Machinery & Equipment -$ 855$ 25,000$ 5,000$ 725 5 550 4730 Depreciation 521,252$ 508,732$ 550,000$ 550,000$ 725 5 550 4900 Transfers 400,000$ 400,000$ 400,000$ 400,000$ 725 5 550 4950 Refunds 22,450$ 52,535$ -$ -$ Capital and Other 1,056,428$ 1,101,847$ 1,103,000$ 1,090,000$ Summary Total 4,562,406$ 4,508,461$ 4,674,317$ 4,981,574$ Budget 2021 Actual 2019MWCC Sewer Charge Volume (Millions of Gallons)932.16 932.16 Lake Elmo portion of MWCC Charge Volume (Millions of Gallons)43.80 43.80 Assets used by Lake Elmo Pipe Pipe Total Inch Miles of Collection Pipes 1,152 1,152 Inch miles of Collection Pipes used by Lake Elmo 105 105 Depreciation expenses excluding Lift Stations 458,991$ 417,723$ Depreciation Expenses for Lift Stations)91,009$ 91,009$ Lift Station Capacity 9,000 9,000 Capacity used by Lake Elmo 500 500 Lake Elmo Allocations Actual 2019 Sewer Administration 193,635$ Maintenance Lift Stations 12,662$ Collection system 2,471$ Subtotal Expenses 208,768$ Return on investment 8,351$ Lake Elmo Actual Allocation 217,119$ Lake Elmo Budget Allocation 2019 205,000$ True Up Amount 12,119$ Lake Elmo Allocations Budget 2021 Sewer Administration 224,424$ Maintenance Lift Stations 8,750$ Collection system 1,561$ Subtotal Expenses 234,735$ Return on investment 9,389$ Lake Elmo Allocation 244,124$ True up amount for 2019 12,119$ Total Lake Elmo Budget Allocation 2021 256,243$ Current Budget Year 2021 lake Elmo Flow Data Actual 2019 Budget 2021 Lake Elmo Peak Flow (GPM)250.00 250.00 Lake Elmo Peaking Factor 3.00 3.00 Lake Elmo Average Flow (GPM)83.33 83.33 Metropolitan Council Volume Charges Actual 2019 Budget 2021MWCC Sewer Charge Volume (Millions of Gallons)932.16 932.16 Lake Elmo portion of MWCC Charge Volume (Millions of Gallons)43.80 43.80 Collection System Data Actual 2019 Budget 2021 Total Inch-miles of Collection Pipes 1,152.00 1,152.00 Inch-miles of Collection Pipes with Lake Elmo Flow 105.00 105.00 Inch-Miles of Pipe in Districts with Lake Elmo Flow Pipe Capacity (GPM)Inch-Miles of Pipe Pipe Capacity (GPM)Inch-Miles of PipeDistrict 8 898 83.99 898 83.99 District 9 1,696 45.13 1,696 45.13 District 11 1,831 51.94 1,831 51.94 District 7 5,924 25.76 5,924 25.76 District 12 5,924 57.95 5,924 57.95 District 15 6,283 189.68 6,283 189.68 District 17 6,283 79.63 6,283 79.63 Other District - Other District - - - - Lift Station Data Actual 2019 Budget 2021 Total Lift Station Capacity (GPM)9,000 9,000 Capacity of Lift Stations used by Lake Elmo (GPM)Capacity in GPM Capacity Used by Oakdale Capacity Used by Lake Elmo Capacity in GPM Capacity Used by Oakdale Capacity Used by Lake Elmo Lift Station 6 in District 8 898 648 250 898 648 250 Lift Station 9 in District 12 5,925 5,675 250 5,925 5,675 250 Other Lift Station (specify)- - - - - - Other Lift Station (specify)- - - - - - Total Lift Stations 6,823 6,323 500 6,823 6,323 500 Lift Station Used by Lake Elmo Depreciation Actual Depreciation Expense 2019 Budget Depreciation Expense 2021 Lift Station 6 in District 8 564$ 564$ Lift Station 9 in District 12 29,454$ 29,454$ Other Lift Station (specify)-$ -$ Other Lift Station (specify)-$ -$ Total Depreciation 30,018$ 30,018$ Other Lift Station Depreciation Lift Station 1 1,693$ 1,693$ Lift Station 3 3,288$ 3,288$ Lift Station 4 24,886$ 24,886$ Lift Station 8 9,997$ 9,997$ Lift Station 10 7,040$ 7,040$ Lift Station 11 2,402$ 2,402$ Lift Station 12 837$ 837$ Lift Station 13 2,268$ 2,268$ Lift Station 14 3,070$ 3,070$ Lift Station 17 5,511$ 5,511$ Total All Lift Stations 91,009$ 91,009$ Actual 2019 Budget 2021 Return on investment rate 4.00%4.00% Actual 2019 Budget 2021 Actual 2019 Budget 2021 Sewer Administration Actual Actual Adopted Adopted Personnel Services 2018 2019 2020 2021 725 5 550 4100 Wages-Regular 72,296$ 71,137$ 64,375$ 400,000$ 725 5 550 4100 Leave Time 43,662$ 45,077$ 41,200$ 725 5 550 4111 Wages-Overtime -$ 241$ -$ 15,000$ 725 5 550 4115 Wages-Part Time -$ -$ 750$ -$ 725 5 550 4120 Wages-Temporary -$ -$ -$ -$ 725 5 550 4140 Employer PERA 8,088$ 8,540$ 7,390$ 23,500$ 725 5 550 4145 Employer FICA 8,080$ 8,260$ 8,134$ 24,500$ 725 5 550 4150 Employer Insurance 58,652$ 62,229$ 68,000$ 66,100$ 725 5 550 4154 Workmen’s Compensation In 46,970$ 49,685$ 62,500$ 62,500$ 725 5 550 4168 Standby Pay -$ -$ -$ -$ Personnel Services 237,748$ 245,169$ 252,349$ 591,600$ Materials and Supplies 725 5 550 4200 Office Supplies 280$ 303$ 250$ -$ 725 5 550 4209 In House Copying 42$ -$ 550$ -$ 725 5 550 4210 Printing, Binding & Copying 485$ 310$ 700$ -$ 725 5 550 4211 Operating Supplies 3,056$ 1,928$ 3,000$ 4,000$ 725 5 550 4230 Uniforms & Clothing 5,327$ 5,299$ 6,000$ 6,000$ 725 5 550 4240 Repair & Maintenance Supp -$ -$ 200$ -$ 725 5 550 4241 Equipment Parts -$ -$ -$ -$ 725 5 550 4250 Small Tools 1,051$ 2,008$ 3,250$ 32,500$ Materials and Supplies 10,241$ 9,848$ 13,950$ 42,500$ Contractual Services 725 5 550 4300 Professional Services 11,500$ 10,500$ 15,000$ 60,000$ 725 5 550 4301 Other Contractual Service 47,059$ 50,212$ 30,000$ -$ 725 5 550 4307 Charges from General 525,000$ 525,000$ 525,000$ 575,000$ 725 5 550 4324 License & Permits Fees -$ -$ 450$ -$ 725 5 550 4330 Postage & Meter Fees 4,621$ 4,618$ 5,000$ 5,000$ 725 5 550 4331 Telephone 6601 6,601$ 5,912$ 5,000$ 5,000$ 725 5 550 4332 Radio Services 1,782$ 1,841$ 336$ 2,000$ 725 5 550 4340 Travel Expenses 251$ 187$ 500$ -$ 725 5 550 4344 Books & Publications -$ -$ 500$ 500$ 725 5 550 4345 Dues & Subscriptions 512$ 450$ 900$ 900$ 725 5 550 4346 Meeting, Conferences & Schooling 612$ 1,491$ 4,000$ 4,500$ 725 5 550 4350 Advertising -$ -$ 1,500$ -$ 725 5 550 4360 Legal & Public Notices/Ad -$ -$ 200$ -$ 725 5 550 4370 Insurance - General Liability 68,587$ 49,355$ 97,500$ 97,500$ 725 5 550 4380 Electric Service -$ -$ -$ -$ 725 5 550 4390 MWCC Sewer Charges 2,354,100$ 2,283,251$ 2,328,014$ 2,374,574$ Contractual Services 3,020,625$ 2,932,817$ 3,013,900$ 3,124,974$ Capital and Other725 5 550 4400 Repair & Maintenance -$ -$ -$ -$ 725 5 550 4402 Repair & Maintenance Equipment -$ 171$ -$ -$ 725 5 550 4510 Rental Building 75,000$ 75,000$ 75,000$ 75,000$ 725 5 550 4700 Capital Outlay Other -$ -$ -$ -$ 725 5 550 4701 Machinery & Equipment -$ 855$ 25,000$ 5,000$ 725 5 550 4730 Depreciation 521,252$ 508,732$ 550,000$ 550,000$ 725 5 550 4900 Transfers 400,000$ 400,000$ 400,000$ 400,000$ 725 5 550 4950 Refunds 22,450$ 52,535$ -$ -$ Capital and Other 1,018,702$ 1,037,293$ 1,050,000$ 1,030,000$ Sewer Administration 4,287,316$ 4,225,127$ 4,330,199$ 4,789,074$ Budget 2021 Actual 2019MWCC Sewer Charge Volume (Millions of Gallons)932.16 932.16 Lake Elmo portion of MWCC Charge Volume (Millions of Gallons)43.80 43.80 Assets used by Lake Elmo Pipe PipeTotal Inch Miles of Collection Pipes 1,152 1,152 Inch miles of Collection Pipes used by Lake Elmo 105 105 Depreciation Expense 550,000 508,732 Depreciation expenses excluding Lift Stations 458,991$ 417,723$ Depreciation Expenses for all Lift Stations 91,009$ 91,009$ Depreciation Lift Stations Lake Elmo flow 30,018$ 30,018$ Total Lift Station Capacity (GPM)9,000 9,000 Capacity used by Lake Elmo (GPM)500 500 Lake Elmo Allocations Budget 2021 Allocation Basis Allocated Quantity Amount to be Allocated AllocationPersonnel Services % of Flow 4.70%591,600$ 27,798$ Materials and Supplies % of Flow 4.70%42,500$ 1,997$ Contractual ServicesAll except MWCC Charges % of Flow 4.70%750,400$ 35,260$ MWCC Charges % of Flow 4.70%2,374,574$ 111,576$ Subtotal Contractual Services 3,124,974$ 146,835$ Capital and OtherRepair & Maintenance Equipment % of Flow 4.70%-$ -$ Repair & Maintenance Equipment % of Flow 4.70%-$ -$ Rental Building % of Flow 4.70%75,000$ 3,524$ Capital Outlay Other % of Flow 4.70%-$ -$ Machinery & Equipment % of Flow 4.70%5,000$ 235$ Depreciation Other than Lift Stations % inch miles 9.11%458,991$ 41,835$ Depreciation Lift Stations Lake Elmo flo LS Capacity 7.33%30,018$ 2,200$ Subtotal Capital and Other 569,009$ 47,794$ Check should be 0Total Administration 5.19%4,328,083$ 224,424$ 4,789,074$ 4,789,074$ -$ Lake Elmo Allocations Actual 2019 Allocation Basis Allocated Quantity Amount to be Allocated AllocationPersonnel Services % of Flow 4.70%245,169$ 11,520$ Materials and Supplies % of Flow 4.70%9,848$ 463$ Contractual ServicesAll except MWCC Charges % of Flow 4.70%649,566$ 30,522$ MWCC Charges % of Flow 4.70%2,283,251$ 107,285$ Subtotal Contractual Services 2,932,817$ 137,806$ Capital and OtherRepair & Maintenance Equipment % of Flow 4.70%-$ -$ Repair & Maintenance Equipment % of Flow 4.70%171$ 8$ Rental Building % of Flow 4.70%75,000$ 3,524$ Capital Outlay Other % of Flow 4.70%-$ -$ Machinery & Equipment % of Flow 4.70%855$ 40$ Depreciation Other than Lift Stations % inch miles 9.11%417,723$ 38,074$ Depreciation Lift Stations Lake Elmo flo LS Capacity 7.33%30,018$ 2,200$ Subtotal Capital and Other 523,767$ 43,846$ Check should be 0Total Administration 5.22%3,711,601$ 193,635$ 4,225,127$ 4,225,127$ -$ Maintenance Lift Stations Actual Actual Adopted Adopted Personnel Services 2018 2019 2020 2021 725 5 552 4100 Wages-Regular 39,312$ 49,738$ 52,000$ -$ 725 5 552 4100 Leave Time -$ -$ 6,000$ -$ 725 5 552 4111 Wages-Overtime 3,312$ 5,601$ -$ -$ 725 5 552 4115 Wages-Part Time -$ -$ -$ -$ 725 5 552 4120 Wages-Temporary 644$ 559$ -$ -$ 725 5 552 4140 Employer PERA 3,486$ 4,683$ 4,360$ -$ 725 5 552 4145 Employer FICA 3,550$ 4,553$ 4,437$ -$ 725 5 552 4150 Employer Insurance -$ -$ -$ -$ 725 5 552 4154 Workmen’s Compensation In -$ -$ -$ -$ 725 5 552 4168 Standby Pay 6,555$ 7,721$ 7,500$ -$ Personnel Services 56,859$ 72,855$ 74,297$ -$ Materials and Supplies 725 5 552 4200 Office Supplies -$ -$ -$ -$ 725 5 552 4209 In House Copying -$ -$ -$ -$ 725 5 552 4210 Printing, Binding & Copying -$ -$ -$ -$ 725 5 552 4211 Operating Supplies -$ -$ -$ -$ 725 5 552 4230 Uniforms & Clothing -$ -$ -$ -$ 725 5 552 4240 Repair & Maintenance Supp 42,339$ 39,346$ 30,000$ 40,000$ 725 5 552 4241 Equipment Parts -$ -$ -$ -$ 725 5 552 4250 Small Tools -$ -$ 500$ -$ Materials and Supplies 42,339$ 39,346$ 30,500$ 40,000$ Contractual Services 725 5 552 4300 Professional Services -$ -$ -$ -$ 725 5 552 4301 Other Contractual Service 1,370$ -$ 5,000$ 2,500$ 725 5 552 4307 Charges from General -$ -$ -$ -$ 725 5 552 4324 License & Permits Fees -$ -$ -$ -$ 725 5 552 4330 Postage & Meter Fees -$ -$ -$ -$ 725 5 552 4331 Telephone 6601 -$ -$ -$ -$ 725 5 552 4332 Radio Services -$ -$ -$ -$ 725 5 552 4340 Travel Expenses -$ -$ -$ -$ 725 5 552 4344 Books & Publications -$ -$ -$ -$ 725 5 552 4345 Dues & Subscriptions -$ -$ -$ -$ 725 5 552 4346 Meeting, Conferences & Schooling -$ -$ -$ -$ 725 5 552 4350 Advertising -$ -$ -$ -$ 725 5 552 4360 Legal & Public Notices/Ad -$ -$ -$ -$ 725 5 552 4370 Insurance - General Liability -$ -$ -$ -$ 725 5 552 4380 Electric Service 65,093$ 59,387$ 75,000$ 65,000$ 725 5 552 4390 MWCC Sewer Charges -$ -$ -$ -$ Contractual Services 66,463$ 59,387$ 80,000$ 67,500$ Capital and Other 725 5 552 4400 Repairs & Maintenance 37,526$ 40,989$ 25,000$ 35,000$ 725 5 552 4402 Repair & Maintenance Equipment -$ -$ -$ -$ 725 5 552 4510 Rental Building -$ -$ -$ -$ 725 5 552 4700 Capital Outlay Other -$ 15,345$ 15,000$ 15,000$ 725 5 552 4701 Machinery & Equipment -$ -$ -$ -$ 725 5 552 4730 Depreciation -$ -$ -$ -$ 725 5 552 4900 Transfers -$ -$ -$ -$ 725 5 552 4950 Refunds -$ -$ -$ -$ Capital and Other 37,526$ 56,334$ 40,000$ 50,000$ Lift Station Maintenance 203,187$ 227,922$ 224,797$ 157,500$ CFS to GPM 448.833 Flow through lift stations Capacity (GPM)Oakdale Lake Elmo Capacity (GPM)Oakdale Lake ElmoLift Station 6 in District 8 898 648 250 898 648 250 Lift Station 9 in District 12 5,925 5,675 250 5,925 5,675 250 Other Lift Station (specify)- - - - - - Other Lift Station (specify)- - - - - - Total 6,823 6,323 500 6,823 6,323 500 Total Capacity of all Lift Stations 9,000 8,500 500 9,000 8,500 500 Lake Elmo Allocations Budget 2021 Allocation Basis Allocated Quantity Amount to be Allocated AllocationPersonnel Services % of Capacity 5.56%-$ -$ Materials and Supplies % of Capacity 5.56%40,000$ 2,222$ Contractual ServicesAll except MWCC Charges % of Capacity 5.56%67,500$ 3,750$ MWCC Charges % of Capacity 0.00%-$ -$ Subtotal Contractual Services 67,500$ 3,750$ Capital and Other Repair & Maintenance % of Capacity 5.56%35,000$ 1,944$ Repair & Maintenance Equipment % of Capacity 5.56%-$ -$ Rental Building % of Capacity 5.56%-$ -$ Capital Outlay Other % of Capacity 5.56%15,000$ 833$ Machinery & Equipment % of Capacity 5.56%-$ -$ Depreciation Other than Lift Stations % of Capacity 0.00%Depreciation Lift Stations % of Capacity 0.00%Subtotal Capital and Other 50,000$ 2,778$ Check should be 0Total Lift Station Maintenance 5.56%157,500$ 8,750$ 157,500$ 157,500$ -$ Actual 2019Budget 2021 Lake Elmo Allocations Actual 2019 Allocation Basis Allocated Quantity Amount to be Allocated AllocationPersonnel Services % of Capacity 5.56%72,855$ 4,048$ Materials and Supplies % of Capacity 5.56%39,346$ 2,186$ Contractual ServicesAll except MWCC Charges % of Capacity 5.56%59,387$ 3,299$ MWCC Charges % of Capacity 0.00%-$ -$ Subtotal Contractual Services 59,387$ 3,299$ Capital and OtherRepair & Maintenance % of Capacity 5.56%40,989$ 2,277$ Repair & Maintenance Equipment % of Capacity 5.56%-$ -$ Rental Building % of Capacity 5.56%-$ -$ Capital Outlay Other % of Capacity 5.56%15,345$ 853$ Machinery & Equipment % of Capacity 5.56%-$ -$ Depreciation Other than Lift Stations % of Capacity 0.00%Depreciation Lift Stations % of Capacity 0.00%Subtotal Capital and Other 56,334$ 3,130$ Check should be 0Total Lift Station Maintenance 5.56%227,922$ 12,662$ 227,922$ 227,922$ -$ Collection System Maintenance Actual Actual Adopted Adopted Personnel Services 2018 2019 2020 202172555734100Wages-Regular 29,866$ 31,224$ 55,213$ -$ 725 5 573 4100 Leave Time -$ -$ -$ -$ 725 5 573 4111 Wages-Overtime 9,640$ 4,172$ 1,607$ -$ 725 5 573 4115 Wages-Part Time -$ -$ -$ -$ 725 5 573 4120 Wages-Temporary 2,275$ 2,665$ -$ -$ 725 5 573 4140 Employer PERA 2,961$ 2,618$ 2,469$ -$ 725 5 573 4145 Employer FICA 3,081$ 2,856$ 2,532$ -$ 725 5 573 4150 Employer Insurance -$ -$ -$ -$ 725 5 573 4154 Workmen’s Compensation In -$ -$ -$ -$ 725 5 573 4168 Standby Pay -$ -$ -$ -$ Personnel Services 47,823$ 43,535$ 61,821$ -$ Materials and Supplies7255 573 4200 Office Supplies -$ -$ -$ -$ 725 5 573 4209 In House Copying -$ -$ -$ -$ 725 5 573 4210 Printing, Binding & Copying -$ -$ -$ -$ 725 5 573 4211 Operating Supplies -$ -$ -$ -$ 725 5 573 4230 Uniforms & Clothing -$ -$ -$ -$ 725 5 573 4240 Repair & Maintenance Supp 2,761$ 2,354$ 7,500$ 5,000$ 725 5 573 4241 Equipment Parts 964$ 1,303$ 4,000$ -$ 725 5 573 4250 Small Tools -$ -$ -$ -$ Materials and Supplies 3,725$ 3,657$ 11,500$ 5,000$ Contractual Services7255 573 4300 Professional Services -$ -$ 3,000$ 20,000$ 725 5 573 4301 Other Contractual Service 20,155$ -$ 30,000$ -$ 725 5 573 4307 Charges from General -$ -$ -$ -$ 725 5 573 4324 License & Permits Fees -$ -$ -$ -$ 725 5 573 4330 Postage & Meter Fees -$ -$ -$ -$ 725 5 573 4331 Telephone 6601 -$ -$ -$ -$ 725 5 573 4332 Radio Services -$ -$ -$ -$ 725 5 573 4340 Travel Expenses -$ -$ -$ -$ 725 5 573 4344 Books & Publications -$ -$ -$ -$ 725 5 573 4345 Dues & Subscriptions -$ -$ -$ -$ 725 5 573 4346 Meeting, Conferences & Schooling -$ -$ -$ -$ 725 5 573 4350 Advertising -$ -$ -$ -$ 725 5 573 4360 Legal & Public Notices/Ad -$ -$ -$ -$ 725 5 573 4370 Insurance - General Liability -$ -$ -$ -$ 725 5 573 4380 Electric Service -$ -$ -$ -$ 725 5 573 4390 MWCC Sewer Charges -$ -$ -$ -$ Contractual Services 20,155$ -$ 33,000$ 20,000$ Capital and Other725 5 552 4400 Repairs & Maintenance 200$ 8,099$ 10,000$ 10,000$ 725 5 552 4402 Repair & Maintenance Equipment -$ 121$ 3,000$ -$ 725 5 552 4510 Rental Building -$ -$ -$ -$ 725 5 552 4700 Capital Outlay Other -$ -$ -$ -$ 725 5 552 4701 Machinery & Equipment -$ -$ -$ -$ 725 5 552 4730 Depreciation -$ -$ -$ -$ 725 5 552 4900 Transfers -$ -$ -$ -$ 725 5 552 4950 Refunds -$ -$ -$ -$ Capital and Other 200$ 8,220$ 13,000$ 10,000$ Total for Collection System 71,903$ 55,412$ 119,321$ 35,000$ Sewer District Pipe Capacity (GPM)Inch Miles Percent of Total Inch Miles Percent of Capacity Pipe Capacity Inch Miles Percent of Total Inch Miles Percent of Capacity -$ District 8 898 83.99 7.3%27.84%898 83.99 7.3%27.84%-$ District 9 1,696 45.13 3.9%14.74%1,696 45.13 3.9%14.74%-$ District 11 1,831 51.94 4.5%13.65%1,831 51.94 4.5%13.65%-$ District 7 5,924 25.76 2.2%4.22%5,924 25.76 2.2%4.22%-$ District 12 5,924 57.95 5.0%4.22%5,924 57.95 5.0%4.22%-$ District 15 6,283 189.68 16.5%3.98%6,283 189.68 16.5%3.98%-$ District 17 6,283 79.63 6.9%3.98%6,283 79.63 6.9%3.98%-$ Other District - - 0.0%0.00%- - 0.0%0.00%Other District - - 0.0%0.00%- - 0.0%0.00% Capacity used by Lake Elmo 250 250 Lake Elmo Allocations Budget 2021 Allocation Basis Allocated Quantity Amount to be Allocated AllocationPersonnel Services % inch miles x % Capacity 0.00%-$ -$ Materials and Supplies % inch miles x % Capacity 4.46%5,000$ 223$ Contractual ServicesAll except MWCC Charges % inch miles x % Capacity 4.46%20,000$ 892$ MWCC Charges % inch miles x % Capacity 0.00%-$ -$ Subtotal Contractual Services 20,000$ 892$ Capital and OtherRepair & Maintenance % inch miles x % Capacity 4.46%10,000$ 446$ Repair & Maintenance Equipm % inch miles x % Capacity 0.00%-$ -$ Rental Building % inch miles x % Capacity 0.00%-$ -$ Capital Outlay Other % inch miles x % Capacity 0.00%-$ -$ Machinery & Equipment % inch miles x % Capacity 0.00%-$ -$ Depreciation Other than Lift S % inch miles x % Capacity 0.00%Depreciation Lift Stations % inch miles x % Capacity 0.00%Subtotal Capital and Other 10,000$ 446$ Check should be 0Total Collection System 4.46%35,000$ 1,561$ 35,000$ 35,000$ -$ Lake Elmo Allocations Budget 2019 Allocation Basis Allocated Quantity Amount to be Allocated AllocationPersonnel Services % inch miles x % Capacity 4.46%43,535$ 1,942$ Materials and Supplies % inch miles x % Capacity 4.46%3,657$ 163$ Contractual ServicesAll except MWCC Charges % inch miles x % Capacity 0.00%-$ -$ MWCC Charges % inch miles x % Capacity 0.00%-$ -$ Subtotal Contractual Services -$ -$ Capital and OtherRepair & Maintenance % inch miles x % Capacity 4.46%8,099$ 361$ Repair & Maintenance Equipm % inch miles x % Capacity 4.46%121$ 5$ Rental Building % inch miles x % Capacity 0.00%-$ -$ Capital Outlay Other % inch miles x % Capacity 0.00%-$ -$ Machinery & Equipment % inch miles x % Capacity 0.00%-$ -$ Depreciation Other than Lift S % inch miles x % Capacity 0.00%Depreciation Lift Stations % inch miles x % Capacity 0.00%Subtotal Capital and Other 8,220$ 367$ Check should be 0Total Collection System 4.46%55,412$ 2,471$ 55,412$ 55,412$ -$ Budget 2021 Actual 2019