City Council

MURFREESBORO CITY COUNCIL and PLANNING COMMISSION Joint Meeting Regular Workshop Agenda Murfreesboro Municipal Airport – Community Room January 13, 2021 – 11:30 AM Workshop Items 1. FY21 Mid-Year Budget Review (Administration) 2. November Dashboard Information (Administration) 3. 2020 Sanitary Sewer Allocation Report (Water Resources) 4. Discussion of Land Use Planning (Planning) Licensing Payment of Statements Adjournment  COUNCIL COMMUNICATION Meeting Date: 01/13/2021 Item Title: FY21 Mid-Year Budget Review Department: Administration Presented by: Erin Tucker, Budget Director Summary FY21 Mid-Year Budget Review Background Information The General Fund mid-year budget review will be presented to Council. Council Priorities Served Responsible budgeting Communication of budget-to-actual results is necessary for City Council to make informed decisions. Fiscal Impacts None  COUNCIL COMMUNICATION Meeting Date: 01/13/2021 Item Title: November 2020 Dashboard Department: Administration Presented by: Erin Tucker, Budget Director Summary November 2020 Dashboard packet Background Information November’s dashboard information includes relevant Financial, Building & Codes, Risk Management and Construction data. Council Priorities Served Responsible budgeting Providing Council with assessible financial information on a regular basis assists in critical decision-making about the fiscal affairs of the City. Fiscal Impacts None Attachments: 1. November 2020 Dashboard 2. City Schools November Dashboard  NOVEMBER DASHBOARD Property Tax 70,000,000 59,082,540 60,754,768 60,000,000 50,000,000 40,471,043 41,492,474 38,373,972 36,621,670 40,000,000 30,000,000 20,000,000 10,000,000 - FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 Property Tax notices were mailed in early October. The FY21 Tax Roll reflects a 2.86% increase over FY20. Collections are running about 1% over FY20 thru November. LOCAL SALES TAX REVISED BUDGET vs ACTUAL 5 60 Millions 5 Millions 50 4 4 40 Cumulative Total 3 Monthly Total 3 30 2 20 2 1 10 1 - 0 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY21 Budget FY21 Actual FY 21 Cumulative FY 20 Cumulative Initial estimates for the COVID-19 impact on Local Sales Tax indicated a 55% decrease as compared to FY20 through the first quarter of FY21. Instead, collections for July exceeded, rather than lagged, FY20. City Council approved a budget amendment in early October to reflect this shift. The chart above reflects this revised budget. FY21 cumulative collections through November reflect an 8% increase over FY20 collections. This information reflects a 2-month lag – the collections are for September 2020 taxes. Barring any future shut-downs or significant economic downturns, this trend is expected to continue. STATE SALES TAX REVISED BUDGET vs ACTUAL 1,200 12 Thousands Millions 1,000 10 800 8 Monthly Total Cumulative Total 600 6 400 4 200 2 - 0 JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY21 Budget FY21 Actual FY 21 Cumulative FY 20 Cumulative State Sales Tax was also budgeted at a 55% loss as compared to the first quarter of FY20 but instead realized growth. The October budget amendment to this revenue source is reflected in this chart. Cumulatively, State Sales Tax is up 4.7% over FY20. This information reflects a 2-month lag – the collections are for September 2020 taxes. Again, barring any future shut-downs or significant economic downturns, this trend is expected to continue.  % of Total Current Month Collections Business Tax - Gross Receipts Tax, 5.75% State Street Aid - Gas Tax , 19.49% TVA Gross Receipts, 17.57% State Sales Tax, 50.10% Mixed Drink Tax, 5.75% Telecom Sales Tax, 0.33% Gas Tax Allocation, 1.02% Sales Tax made up over 50% of the State Shared collections for November, while the State Street Aid Gas Tax (restricted to road improvements) made up an additional 19.5%. Quarterly TVA Gross Receipts accounted for 17.6% of the November collections, which is down 7% compared to last year. Business License Taxes and Mixed Drink made up an additional 11.5% of the State Revenue Distributions for November.  State Revenue Collections 3.50 25 Millions Millions 3.00 20 2.50 15 Total Collections 2.00 1.50 10 1.00 5 0.50 0.00 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNE FY20 Actual FY21 Actual FY20 Cumulative FY21 Cumulative Overall, State Shared Revenue collections showed a 12.6% increase over last year’s State Shared revenues thru November. September & October showed slight decreases related to Mixed Drink Tax and State Street Aid Gas Tax. Mixed Drink Tax and State Street Aid Gas Tax are down for the year. Both revenues have been impacted by the COVID- 19 pandemic. Mixed Drink was down each month through September but showed 5% growth in October and flat results in November. Overall, it is down 9.8% for the year as compared to FY20. The October budget amendment reflected an 8% drop in this revenue as compared to last year. This revenue source will be monitored and adjusted further if necessary. State Street Aid Gas Tax was flat in November and down 4.3% cumulatively for the year as compared to last year. These revenues are restricted and can only be spent on eligible roadway maintenance and construction projects. Spending of these restricted funds will be adjusted accordingly.  HOTEL/MOTEL BUDGET vs. ACTUAL 250 1.80 Thousands 1.60 Millions 200 1.40 1.20 150 1.00 0.80 100 0.60 0.40 50 0.20 - - JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUN FY21 Budget Based on 5 yr Average Actual Budgeted Cumulative Actual Cumulative The Hotel/Motel Tax rate doubled in FY20 from 2.5% to 5%. The November remittance, for October taxes, showed a 37% decrease over last year’s reported occupancy and an 16% increase from this year’s budget. This trend is expected to continue due to the COVID-19 impact on tourism.  Salaries & Benefits 14,000,000 90,000,000 80,000,000 12,000,000 70,000,000 10,000,000 60,000,000 8,000,000 50,000,000 6,000,000 40,000,000 30,000,000 4,000,000 20,000,000 2,000,000 10,000,000 - - JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY 21 Budget FY 21 Actual FY 21 Cumulative FY 20 Cumulative Effective 3/19/20, a hiring freeze was implemented through October with only critical vacancies being filled. As a result, Salaries & Benefits were trending under budget due to unfilled vacancies within the City through November. As of 11/30/20, there were 950 filled full-time positions and 67 vacancies – which is up from 59 vacancies in October. This is inclusive of the additional positions approved in the October budget amendment. Police had 32 open positions at the end of November, including 21 sworn officer positions and 8 emergency communications staff. Fire had 11 open positions as compared to 12 vacancies in October.  Schools Transfer 700,000 9,000,000 8,000,000 600,000 7,000,000 500,000 6,000,000 400,000 5,000,000 300,000 4,000,000 3,000,000 200,000 2,000,000 100,000 1,000,000 - - JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY 21 Budget FY 21 Actual FY 21 Cumulative FY 20 Cumulative Budgeted Transfers to City Schools is budgeted at $7.885M. This transfer is made in monthly increments evenly distributed throughout the year. Debt Service Transfer 30,000,000 45,000,000 40,000,000 25,000,000 35,000,000 20,000,000 30,000,000 25,000,000 15,000,000 20,000,000 10,000,000 15,000,000 10,000,000 5,000,000 5,000,000 - - JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY 21 Budget FY 21 Actual FY 21 Cumulative FY 20 Cumulative The budgeted Debt Service Transfer decreased by $3.3M in FY21. This is due to debt payoff ($2.8M), refinanced debt (with budgeted savings of $236,600) and no new debt service scheduled for FY21.  Repairs & Maintenance 3,000,000 12,000,000 2,500,000 10,000,000 2,000,000 8,000,000 1,500,000 6,000,000 1,000,000 4,000,000 500,000 2,000,000 - - JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY 21 Budget FY 21 Actual FY 21 Cumulative FY 20 Cumulative Repairs & Maintenance make up 7% of General Fund budgeted expenses. This includes maintenance of software ($1.2M), fleet services ($2.7M), and Police R&M for radios, mobile data terminals, etc. ($1.4M). State Street Aid R&M of streets, markings and right of way totals $4.4M. These expenses are seasonal and fluctuate depending on contract timing and timing of repairs. This was trending 30% under budget and 41% less than FY20 through November. Utilities 900,000 5,000,000 800,000 4,500,000 4,000,000 700,000 3,500,000 600,000 3,000,000 500,000 2,500,000 400,000 2,000,000 300,000 1,500,000 200,000 1,000,000 100,000 500,000 - - JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY 21 Budget FY 21 Actual FY 21 Cumulative FY 20 Cumulative Utilities were budgeted to stay relatively flat in FY21 as compared to FY20 and were running 20% under budget for the year through November. Fixed Assets 6,000,000 8,000,000 7,000,000 5,000,000 6,000,000 4,000,000 5,000,000 3,000,000 4,000,000 3,000,000 2,000,000 2,000,000 1,000,000 1,000,000 - - JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN FY 21 Budget FY 21 Actual FY 21 Cumulative FY 20 Cumulative $17M budgeted for Fixed Assets in FY 21 includes: • $9.25M in Infrastructure for grant funded road construction • $1.5M – Siegel Soccer Park building • $1.38M – public safety equipment • $1.4M – Transit Facility • $1.1M – Rover bus replacement (grant funded portion) • $700k – Fire apparatus replacement • $358k software & computer hardware • $98k Recreation equipment Timing on spending in Fixed Assets is also seasonal and can fluctuate based on the construction schedules and delivery of equipment. Through November, fixed asset spending was down 82% as compared to last year due to the City-wide non-essential spending freeze and timing of road construction projects funded through the Infrastructure Department.  NOVEMBER SAFETY REPORT Overall, for the City, total incidents showed a 26% decrease over the same time period last year. The City is showing 14 possible COVID-19 related Workers Compensation claims. A claim is filed when an employee states that they may have been exposed to COVID-19 as part of their job duties. This is not a measure of COVID-19 testing. COVID-19 testing results will not be a part of this report. WORKERS’ COMPENSATION  BUILDING & CODES New Dwelling Units (Single Family, Townhomes & Apartments) 300 2,500 250 2,000 200 1,500 150 1,000 100 500 50 0 0 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNE New Permits Cumulative FY 21 Cumulative FY 20 Dwelling permits for November dropped 32% as compared to last year. This is consistent with expectations surrounding the COVID-19 pandemic. Total Permits (all types) 1,400 14,000 1,200 12,000 1,000 10,000 800 8,000 600 6,000 400 4,000 200 2,000 - - JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNE FY 21 Total Permits Cumulative FY 21 Cumulative FY 20 Total permits were trending up over last year by 8.4% through November.  425,000 Revenues 4,300,000 3,900,000 400,000 3,500,000 375,000 3,100,000 2,700,000 350,000 2,300,000 325,000 1,900,000 300,000 1,500,000 1,100,000 275,000 700,000 250,000 300,000 JUL AUG SEPT OCT NOV DEC JAN FEB MAR APR MAY JUNE FY 21 Monthly Revenues FY 21 Cumulative Revenues FY 20 Cumulative Revenues The Building & Codes revenues’ budget reflects a 12.6% drop from FY20 revenues. November Building & Code revenues are down by 25% as compared to last year and cumulative results show a 4.6% drop as compared to last year.  DECEMBER 10, 2020 Project Tracking Project Cost (including approved Change Orders) Billed to Date (Construction Only) Project Days (including approved Change Orders) Days Used $18,000,000.00 1,400 $16,000,000.00 1,200 $14,000,000.00 1,000 $12,000,000.00 800 $10,000,000.00 $8,000,000.00 600 $6,000,000.00 400 $4,000,000.00 200 $2,000,000.00 $0.00 0 Bradyville Pike Cherry Lane Phase II Cherry Lane Phase III Jones Boulevard Improvements Middle Tennessee Boulevard Robert Rose Right Turn Lane Rucker Lane Widening Stones River Greenway Phase IV Pareto Chart for Cumulative Percent of Annual Costs across all Cost Centers is in cells B2 through E3. Project Limits Project Cost (including Billed to Date Project Days (including Today / Substantial Project Name From To Distance approved Change Orders) (Construction Only) approved Change Orders) Days Used Percent Days Completion N.T.P. Bradyville Pike SE Broad St S Rutherford Blvd 2.10 Miles $10,570,000 (Est Cost) $0.00 0 0 0% Cherry Lane Phase II Siegel Soccer Park Sulphur Springs Road 1.73 Miles $13,800,000 (Est Cost) $0.00 0 0 0% Cherry Lane Phase III Broad Street Memorial Blvd (231) 1.10 Miles $46,000,000 (Est Cost) $0.00 0 0 0% Jones Boulevard Improvements Medical Center Parkway Clark Boulevard 0.54 Mile $3,419,212 (Est Cost) $0.00 0 0 0% Middle Tennessee Boulevard East Main Street Greenland Drive 0.8 Mile $15,986,859 $15,550,141 945 1148 121% 3/4/2019 1/11/2016 Robert Rose Right Turn Lane Robert Rose Thompson Lane 0.14 Mile $1,208,196 $903,668.18 150 235 157% 11/20/2020 3/30/2020 Rucker Lane Widening Highway 96 (Franklin Road) Veterans Parkway 2.5 Miles $13,200,000 (Est Cost) $0.00 0 0 0% Stones River Greenway Phase IV Barfield Road Barfield Crescent Park 2.65 Miles $6,107,820 $5,624,152 730 911 125% 3/10/2020 9/11/2017 Total $110,292,087 $22,077,961 DECEMBER 10, 2020 Project Project Status / Comments Cherry Lane Phase II Alignment study for final environmental study ongoing. ROW legal documents being drafted by consultant. Cherry Lane Phase III Bridge plans have been revised to include lighting, second round of reviews are being done by the City. Mercury Blvd Sidewalk Received Notice to Proceed from TDOT on 12/9/2020. Working on advertisement for bids. Middle Tennessee Boulevard Working on close out documentation. Robert Rose Drive Substantial completion on 11/20/2020. Punchlist has been completed. Working on final pay application and summary change order. Rucker Lane Widening Bid 3/10/20, with Rogers Group being the apparent low bidder. Project on hold till further notice. Stones River Greenway Phase IV Final Summary Change scheduled to go for Council approval on 12/17/2020. Project ROW Updates Bradyville Pike 17% of ROW Acquisition completed Cherry Lane Phase II On hold; under environmental review Cherry Lane Phase III Vendor selection pending Jones Blvd 87% ROW Acquisition completed  PROJECT DEVELOPMENT NOVEMBER DASHBOARD Project Tracking Ending Date 11/30/2020 Project Cost (including approved Change Orders) Billed to Date Project Days (including approved Change Orders) Days Used $7,000,000 400 350 $6,000,000 300 $5,000,000 250 $4,000,000 200 $3,000,000 150 $2,000,000 100 $1,000,000 50 $0 0 Murfreesboro Municipal Airport Terminal Fire & Rescue Station #11 Police C.I.D Building Renovation Siegel Soccer Renovations (Indoor Soccer Facility) Doug Young K9 Outdoor Training Replacement Hangar #1 Pareto Chart for Cumulative Percent of Annual Costs across all Cost Centers is in cells B2 through E3. Project Limits Project Cost (including Project Days (including Project Name Start Date Delivery Method Completion approved Change Billed to Date approved Change Days Used Percent Days Status Orders) Orders) Finishing AV install and Murfreesboro Municipal Airport Terminal 4/17/2019 Design Build 4/17/2020 $5,901,970 $5,810,624 366 366 100% Punchlist Fire & Rescue Station #11 7/2/2019 Hard Bid 6/16/2020 $4,460,869 $4,341,123 350 350 100% Complete Partitions and Accessories Police C.I.D Building Renovation 4/15/2020 Hard Bid 10/5/2020 $177,785 $183,929 183 199 109% Remaining Siegel Soccer Renovations (Indoor Soccer Facility) 4/23/2020 Hard Bid HOLD $776,800 $0 N/A N/A N/A On Hold Doug Young K9 Outdoor Training 4/1/2020 Hard Bid 10/5/2020 $403,868 $359,221 187 187 100% Completing Punch list Replacement Hangar #1 11/1/2020 Design Build IN DESIGN $4,200,000 $136,962 N/A N/A N/A DD Drawing Markups Total $15,921,292 $10,831,858  COUNCIL COMMUNICATION Meeting Date: 1/13/2021 Item Title: October 2020 MCS Cash Flow Statement and Revenue and Expenditure Budget Comparison Reports Department: Murfreesboro City Schools Presented by: Michael Smith Requested Council Action: Ordinance ☐ Resolution ☐ Motion ☐ Direction ☐ Information ☒ Summary FY21 Cash Flow Statement (November 2020) FY21 Revenue and Expenditure Budget Comparison Reports (November 2020) Background Information The State has recommended the Schools provide a Cash Flow Statement to the City Council on a monthly basis to indicate enough cash reserves are forecasted to be available to pay monthly expenses. We also will be including Revenue and Expenditure Budget Comparison Reports, that is provided to the Murfreesboro City School Board each month. This information will be included in the Wednesday agenda each month. A formal presentation will not be made each month, however there will be an opportunity for questions and comments. Council Priorities Served Strong and Sustainable Financial and Economic Health Fiscal Impact None Attachments November 2020 MCS Cash Flow Statement November 2020 MCS Revenue and Expenditure Budget Comparison Reports  FY21 GENERAL PURPOSE CITY SCHOOL FUND Cash Flow Forecast Schedule ** FY 2021 General Purpose School Fund JUL (Actual) AUG (Actual) SEP (Actual) OCT (Actual) NOV (Actual) DEC JAN FEB MAR APR MAY JUN TOTAL Cash Receipts $ 2,290,232 $ 7,453,453 $ 7,467,751 $ 7,180,912 $ 9,155,560 $ 7,525,585 $ 9,983,188 $ 12,016,970 $ 11,958,856 $ 7,896,436 $ 3,776,647 $ 8,041,844 $ 94,747,435 Loan Proceeds - - - - - - - - - - - - - Total Cash Inflows 2,290,232 7,453,453 7,467,751 7,180,912 9,155,560 7,525,585 9,983,188 12,016,970 11,958,856 7,896,436 3,776,647 8,041,844 94,747,435 Beg Cash Bal 12,290,223 7,368,199 7,455,385 7,445,676 6,234,976 6,997,059 5,930,495 8,332,226 13,131,635 17,615,666 18,276,048 14,973,879 Available Cash 14,580,454 14,821,652 14,923,137 14,626,588 15,390,536 14,522,644 15,913,684 20,349,196 25,090,492 25,512,102 22,052,695 23,015,724 Cash Payments $ 7,180,275 $ 7,334,286 $ 7,445,481 $ 8,359,633 $ 8,361,496 $ 8,560,169 $ 7,549,477 $ 7,185,581 $ 7,442,846 $ 7,204,074 $ 7,046,836 $ 10,124,859 93,795,013 Debt Service 31,980 31,980 31,980 31,980 31,980 31,980 31,980 31,980 31,980 31,980 31,980 57,420 409,200 Transfers Out - - - - - - - - - - - - - Total Cash Outflows 7,212,255 7,366,266 7,477,461 8,391,613 8,393,476 8,592,149 7,581,457 7,217,561 7,474,826 7,236,054 7,078,816 10,182,279 94,204,213 Ending Balance 7,368,199 7,455,385 7,445,676 6,234,976 6,997,059 5,930,495 8,332,226 13,131,635 17,615,666 18,276,048 14,973,879 12,833,445 Cash Inflows - Outflows $ (4,922,024) $ 87,186 $ (9,709) $ (1,210,700) $ 762,083 $ (1,066,564) $ 2,401,731 $ 4,799,409 $ 4,484,030 $ 660,382 $ (3,302,169) $ (2,140,435) $ 543,222 **Amounts are estimated and taken from prior year amounts unless otherwise indicated. Cash Flow Forecast 14,000,000 20,000,000 18,000,000 12,000,000 16,000,000 10,000,000 14,000,000 12,000,000 8,000,000 10,000,000 6,000,000 8,000,000 4,000,000 6,000,000 4,000,000 2,000,000 2,000,000 ‐ ‐ JUL (Actual) AUG (Actual) SEP (Actual) OCT (Actual) NOV (Actual) DEC JAN FEB MAR APR MAY JUN Total Cash Inflows Total Cash Outflows Ending Balance  YEAR-TO-DATE REVENUE COMPARISON November 2020 PAGE 1 2019-20 2020-21 2019-20 2019-20 OVR/(UNDR) 2019-20 2020-21 2020-21 OVR/(UNDR) 2020-21 BUDGET CLASS. BUDGET YTD REV. BUDGET % BUDGET YTD REV. BUDGET % 1 40110-Current Prop. Tax 14,308,810 969,456 (13,339,354) 6.8% 15,312,150 1,149,565 (14,162,585) 7.5% 2 40210-Local Option Sales Tax 11,843,830 3,928,684 (7,915,146) 33.2% 12,330,550 3,275,868 (9,054,682) 26.6% 3 40000-41110-Other County Rev 1,830,000 605,512 (1,224,488) 33.1% 1,850,000 705,762 (1,144,238) 38.1% 4 44000-Other Local Revenue 594,500 152,029 (442,471) 25.6% 688,941 231,381 (457,560) 33.6% 5 46511-Basic Educ. Program 46,301,465 18,039,200 (28,262,265) 39.0% 48,350,000 18,718,000 (29,632,000) 38.7% 6 46512-BEP ARRA - - - N/A - - - N/A 7 46530-Energy Efficient Sch - - - N/A - - - N/A 8 46615-Ext. Contract-ARRA - - - N/A - - - N/A 9 46990-Other State Funds 370,600 104,777 (265,824) 28.3% 217,600 102,801 (114,799) 47.2% 10 46592-CONNECT TEN ARRA - - - N/A - - - N/A 11 46595-Family Resource ARRA - - - N/A - - - N/A 12 46595-SSMS ARRA - - - N/A - - - N/A 13 46981-Safe Schools - - - N/A 262,503 - - N/A 14 47000- Federal Funds 1,109,977 66,786 (1,043,191) 6.0% 1,122,125 278,090 (844,035) N/A 15 49100-49800 Bond & City Transfers - - - N/A - - - N/A 16 49810-Approp./City Gen. Fund 7,885,103 3,285,460 (4,599,643) 41.7% 7,885,103 3,285,460 (4,599,643) 41.7% 17 49820-Operating Transfers 1,300,000 - (1,300,000) N/A - - - N/A TOTALS $ 85,544,285 $27,151,903 $ (58,392,382) 31.7% $88,018,972.00 $ 27,746,927 $ (60,272,045) 31.5%  YEAR-TO-DATE EXPENDITURE COMPARISON November 2020 PAGE 1 2019-20 2020-21 2019-20 2019-20 OVR/(UNDR) 2019-20 2020-21 2020-21 OVR/(UNDR) 2020-21 BUDGET CLASS. BUDGET YTD EXP. BUDGET % BUDGET YTD EXP. BUDGET % 1 71100-Reg. Instruction 46,539,548 16,258,534 (30,281,014) 34.9% 48,863,591 16,495,486 (32,368,105) 33.8% 2 71200-Sp. Ed. Instruction 9,147,978 3,037,575 (6,110,403) 33.2% 9,646,900 3,081,012 (6,565,888) 31.9% 3 71400-Student Body Ed. - - - N/A - - - N/A 4 72110-Attendance 167,489 78,611 (88,878) 46.9% 157,489 50,098 (107,391) 31.8% 5 72120-Health Services 951,390 333,614 (617,776) 35.1% 948,039 346,493 (601,546) 36.5% 6 72130-Guidance 2,667,036 1,007,312 (1,659,724) 37.8% 2,601,101 988,386 (1,612,715) 38.0% 7 72210-Reg. Instr. Support 2,130,181 849,449 (1,280,732) 39.9% 2,225,349 876,177 (1,349,172) 39.4% 8 72220-Sp. Ed. Support 1,793,880 623,034 (1,170,846) 34.7% 1,841,650 577,705 (1,263,945) 31.4% 9 72250-Technology 1,793,131 857,295 (935,836) 47.8% 1,938,863 984,710 (954,153) 50.8% 10 72310-Bd. Of Education 1,525,937 715,994 (809,943) 46.9% 1,492,877 710,688 (782,189) 47.6% 11 72320-Office of Supt. 381,240 165,841 (215,399) 43.5% 388,039 89,019 (299,020) 22.9% 12 72410-Office of Principal 4,663,756 1,732,655 (2,931,101) 37.2% 4,717,965 1,738,666 (2,979,299) 36.9% 13 72510-Fiscal Services 579,593 265,346 (314,247) 45.8% 470,480 241,150 (229,330) 51.3% 14 72520-Personnel Services 428,543 161,826 (266,717) 37.8% 587,033 240,488 (346,545) 41.0% 15 72610-Oper. Of Plant 6,051,082 2,060,235 (3,990,847) 34.0% 6,304,017 2,018,951 (4,285,066) 32.0% 16 72620-Maint. Of Plant 2,724,053 881,262 (1,842,791) 32.4% 2,732,833 772,775 (1,960,058) 28.3% 17 72710-Pupil Transp. 3,230,544 1,287,409 (1,943,135) 39.9% 3,578,755 1,170,520 (2,408,235) 32.7% 18 73300-Community Service 540,533 180,210 (360,323) 33.3% 557,708 167,399 (390,309) 30.0% 19 73400-Early Childhood Educ. 1,251,966 393,343 (858,623) 31.4% 1,162,684 392,066 (770,618) 33.7% 20 76100-Reg. Cap. Outlay 1,505,500 43,103 (1,462,397) 2.9% 130,000 26,865 (103,135) 20.7% 21 82130-Education Debt Serv. - - N/A - - - N/A 22 99100-Operating Transfers 413,105 159,900 (253,205) 38.7% 409,200 159,900 (249,300) 39.1% TOTALS 88,486,485 31,092,549 $ (57,393,936) 35.1% 90,754,573 31,128,553 $ (59,626,020) 34.3%  COMPARISON OF BUDGET TOTALS July 1, 2020 Through November 30, 2020 TOTAL INCOME 7/1/20 - 10/30/20 $ 27,746,927 TOTAL EXPENSES 7/1/20 - 10/30/20 31,128,553 NET INCOME 10/30/20 $ (3,381,626) .  COUNCIL COMMUNICATION Meeting Date: 01/13/2021 Item Title: 2020 Sanitary Sewer Allocation Report Department: Water Resources Presented by: Darren Gore Summary Presentation of Annual Sewer Allocation Report. Background Information Sanitary Sewer Allocation Ordinance enacted on 12/5/2019 requires an annual report of the current sewer system capacity be approved by the Water Resources Board and presented to Council. Board approval is pending; however, presenting a draft report at the January 2020 workshop is helpful in developing the report and will be instrumental in assisting the discussion during the joint meeting of Council and the Planning Commission. The model breaks the City down into 18 watersheds or basins in which MWRD continuously monitors sewage flow throughout the year. The following measures were used to determine the available sanitary sewer connections per basin: • Current or “as-is” wet weather measured flows through the basins were compared to the maximum conveyance capacity of the basins’ sanitary sewer pipelines (e.g., interceptors). • Remaining capacity was divided by the average wet weather daily flow a sewer connection consumes in the collection system. A connection is defined as an apartment, townhome, single-family home, commercial establishment, food service establishment or retail shop. • Previously approved and outstanding sewer connections, referenced as “committed,” since 2015 were deducted from the remaining capacity to determine available capacity. • $38.9M in planned sewer system upgrades were incorporated into the “to be” condition to determine an increase in 15% available future connections are available once the upgrades are completed. A summary of the “as-is” as follows: 122,994 System connection capacity -74,968 Current connections1 = 61% 48,026 Total connections currently available = 39% -8,295 Committed future connections = 7% 39,731 Total uncommitted connections available = 32% A summary of the “to-be” results are as follows: 141,264 System connection capacity -74,968 Current connections (system as-is). = 53% 66,296 Total connections currently available = 47% -8,295 Committed future connections = 6% 58,001 Total uncommitted connection = 41% The WRRF has the ability to handle the hydraulic flows with the increase in connections (given its own upgrades) but will be marginal in meeting some discharge permit limits into the WFSR. There are still several areas where sewer connections will be constricted. A lot of sewer connection capacity is centralized to the City and will not support extending sewer into the City’s urban growth boundary. Council Priorities Served Safe and Livable Neighborhoods Promote and protect public health and safety by properly collecting and treating sanitary sewer. Strong and Sustainable Financial and Economic Health Enhance the economy by establishing reasonable, orderly, equitable and effective means to allocate wastewater collection capacity. Excellent Services with a Focus on Customer Service Assist in uniform and balanced future development to serve the needs of the community. 1 Note: 25,477 (34%) of the current available connections are apartments. 2 Fiscal Impacts There are no fiscal impacts to managing the “as-is” or current sanitary sewer collection system; however, upgrading the system to convey 15% more sewage will cost $38.9M in upgrades. These upgrades are accounted for in MWRD’s 5-yr CIP plan and may be funded with cash reserves or a combination of cash reserves and debt service. 3