Loading...
Item 1. 2023 Budget, Tax Levy and Capital Improvement Plan ReviewCity of Otsego│13400 90th Street NE, Otsego, MN 55330│Tel. (763) 441‐4414 Fax (763) 441‐9163  TO:   Mayor and City Council  FROM:   Adam Flaherty, City Administrator & Finance Director  DATE:   October 10, 2022  SUBJECT:  Budget Meeting #8  On Monday, Council and staff will begin the review of the 2023‐2032 Capital Improvement Plan.   It should be noted that inclusion of a certain item within the Capital Improvement Plan does not  commit final approval by the City Council. Rather, it directs City staff to plan towards and gather  necessary information for an educated final approval on each respective item. Each individual item  is planned, researched, and brought back to the City Council for final approval when the respective  purchase is ready to move forward. I have developed an outline of discussion topics below.   Fleet Vehicles and Equipment CIP  The City has established Fund #206 – Capital Equipment Revolving. The purpose of this fund is to  provide funds and to account for the expenditure of such funds for costs associated with the  replacement of capital equipment, most significantly the City’s machinery and vehicle fleet.  City staff has prepared recommendations for 2023 purchases, which include both replacements of  and additions to the City’s machinery and vehicle fleet. City staff has also prepared a projected  replacement plan through 2032, which covers the entire Capital Improvement Plan period.  City staff presented this information to the Public Works Sub‐Committee on August 17th.  Materials for Review and Discussion  1)Capital Equipment Revolving – Capital Improvement Plan – 2023 Details 2)Comprehensive Machinery and Vehicle Addition & Replacement Schedules a.Building Safety b.Parks Maintenance c.Streets Maintenance d.Water and Sanitary Sewer Utilities 3)Financial Cash Flow ‐ Fund #206 – Capital Equipment Revolving Item 1. City of Otsego│13400 90th Street NE, Otsego, MN 55330│Tel. (763) 441‐4414 Fax (763) 441‐9163  Pavement Management CIP  The City has established Fund #201 – Pavement Management. The purpose of this fund is to  provide funds and to account for the expenditure of such funds for costs associated with the City’s  street maintenance and replacement plan, including fog & seal coating, crack filling, paint striping,  patching, micro‐surface, overlay and reconstruction.    The City Engineer and Street Operations Manager have prepared recommendations for those  streets to be included in the Street Maintenance Program each year based on the age and  condition of the City streets.    When a street’s condition has degraded to a condition where the Street Management Program is  no longer an effective measure of maintenance, it is placed into our Preventative Maintenance list.   Streets on this list will typically not receive any type of maintenance other than patching as failures  develop.      Each section of street is given an annual PCI rating from 0‐100 and once a street is given a low  enough rating it is placed on a watch list.  Once on this watch list, staff will determine what type  renewal process the street shall receive, in most cases an overlay, reclaim or complete  reconstruction.  These recommendations will then be added to the CIP for ultimate approval from  the Council.    Materials for Review and Discussion  1) Pavement Management – Capital Improvement Plan – Summary  2) Street Maintenance Cost Summary  3) 2023 Street Maintenance Map  4) Street Renewal Cost Summary  5) 2022 Pavement Conditions Rating Index Map  6) 2023 to 2032 Street Renewal Projects Map  7) Financial Cash Flow – Fund #201 – Pavement Management    Staff will review source and use cash flow projections with the City Council and further discuss  recommendations on how to continue to provide adequate funding for all future street  maintenance and renewal projects.    General Fund Budget  City staff continues to review the expenditure budgets that were presented during previous  budget meetings for any necessary revisions. Those budget revisions will be reviewed with the City  Council at an upcoming budget meeting and prior to final budget adoption.     Property Tax Levy  The City Council approved a preliminary property tax levy of $9,330,023 in September. There have  been no changes to the property tax levy since that approval.          City of Otsego│13400 90th Street NE, Otsego, MN 55330│Tel. (763) 441‐4414 Fax (763) 441‐9163  Next Meetings  The schedule for the remaining budget meetings is as follows:    1) October 24th – N/A, there will be no budget discussions at this meeting.  2) November 14th – Parks and Trails CIP; Information Technology CIP; Capital Improvements  CIP; and Buildings and Property Maintenance CIP.  3) November 28th – Public Utility Operating Budgets and CIP.  4) December 12th – Truth in Taxation Public Meeting.    Staff would be seeking direction from the City Council on whether any additional review topics or  budget meetings are necessary, or if the City Council concurs with what has been presented and  reviewed thus far.    Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Replacement of a 2006 SUV. Project #FLEET-23-01 Justification City staff is recommending to replace BD#20 with a compact SUV similar to the vehicle that was purchased for the Building Department in 2020. The 2006 Explorer has more than 130 thousand miles on it, and would be added to the Reserve Fleet and utilized by the Building Department and City Call as an additional vehicle for building inspections and general transportation. Useful Life Project Name Compact SUV Category Vehicles Type Vehicles Contact City Administrator Department Fleet Total2023 2024 2025 2026 2027Expenditures 29,05829,058Vehicles 29,058 29,058Total Total2023 2024 2025 2026 2027Funding Sources 29,05829,058206 - Capital Equipment Revolving 29,058 29,058Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Replacement of a 2013 pickup. Project #FLEET-23-02 Justification This vehicle is being recommended to be added to the City's reserve fleet but will stay in day to day use within the department. The daily driver pickups like these in a 10 year replacement cycle for budgeting and planning purposes. It is the intent to keep this vehicle and add it to the reserve fleet of three vehicles to assure that staff have addequate transportation. The pickup being purchased will take the place of the 3/4 pickup used by the Street Operations Manager, which will be re-assigned within the Streets department for better day-to-day usage. Useful Life Project Name 1/2 Ton Extended Cab Pickup Category Vehicles Type Vehicles Contact Street Operations Manager Department Fleet Total2023 2024 2025 2026 2027Expenditures 42,23542,235Vehicles 42,235 42,235Total Total2023 2024 2025 2026 2027Funding Sources 42,23542,235206 - Capital Equipment Revolving 42,235 42,235Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Addition of a street sweeper. Project #FLEET-23-03 Justification Staff is making the recommendation to add a new Elgin Pelican street sweeper. The current street sweeper is a 2007 model year and was purchased used in 2011 from Macqueen Equipment for $77,484. Staff have been renting an additional street sweeper for about a month for the last couple of years and running them both in our spring street sweeping operations. Sweepers are notoriously known for being maintenance nightmares and require a huge amount of maintenance and ours has needed some costly repairs in the last couple of years. Staff feels that it is in the city's best interest to purchase a new Elgin Pelican so we can continue to use similar main and gutter brooms for the sweepers in addition to having many of the same operating systems . Useful Life Project Name Street Sweeper Category Vehicles Type Vehicles Contact Street Operations Manager Department Fleet Total2023 2024 2025 2026 2027Expenditures 272,563272,563Vehicles 272,563 272,563Total Total2023 2024 2025 2026 2027Funding Sources 272,563272,563206 - Capital Equipment Revolving 272,563 272,563Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Replacement of a 2013 pickup. Project #FLEET-23-04 Justification The Parks and Recreation Department is replacing a 1 ton GMC pickup with a Ford 3/4 ton pickup. The current GMC is a regular cab pickup with a plow package. We are suggesting a replacement with a 3/4 ton pickup that is an extended cab equipped with plow package. Extended cab pickups allow for additional staff transport. The Ford F-250 will allow us to do all the necessary work and have a smoother ride while also achieving better gas milage, helping us meet or sustainability goals. Useful Life Project Name 3/4 Ton Extended Cab Pickup Category Vehicles Type Vehicles Contact Park & Recreation Director Department Fleet Total2023 2024 2025 2026 2027Expenditures 58,00058,000Vehicles 58,000 58,000Total Total2023 2024 2025 2026 2027Funding Sources 58,00058,000206 - Capital Equipment Revolving 58,000 58,000Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Replacement of a 2013 pickup. Project #FLEET-23-05 Justification The Parks and Recreation Department is replacing a 2013 Ford 1/2 ton extended cab pickup with a 2023 Ford 1/2 ton pickup set up the exact same. This vehicle allows for the Parks Department to perform routine maintenance while achieving the goal of being more sustainable with the better gas-milage achieved by a 1/2 ton pickup. The plan for #10 would be put into the reserve fleet until the need for additional vehicles has been met. Useful Life Project Name 1/2 Ton Extended Cab Pickup Category Vehicles Type Vehicles Contact Park & Recreation Director Department Fleet Total2023 2024 2025 2026 2027Expenditures 42,23542,235Vehicles 42,235 42,235Total Total2023 2024 2025 2026 2027Funding Sources 42,23542,235206 - Capital Equipment Revolving 42,235 42,235Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Addition of a utility vehicle. Project #FLEET-23-06 Justification The Parks and Recreation Department is requesting a multi-purpose utility vehicle for summer and winter use. In the summer months staff would use the utility vehicle for trash removal, trimming boulevards, trimming trees, and general maintenance. This machine would give staff the ability to use in place of pickup since it is a street legal utility vehicle. Staff would be able to use the utility vehicle in our more natural areas for tree trimming and prairie management. In winter it would allow for tree trimming operations in areas pickups could not reach. Useful Life Project Name Utility Vehicle Category Equipment Type Equipment Contact Park & Recreation Director Department Fleet Total2023 2024 2025 2026 2027Expenditures 31,50031,500Equipment 31,500 31,500Total Total2023 2024 2025 2026 2027Funding Sources 31,50031,500206 - Capital Equipment Revolving 31,500 31,500Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Addition of a zero-turn mower. Project #FLEET-23-07 Justification The Parks and Recreation Department is requesting an additional zero turn mower to help with department mowing efficiencies. Staff is recommending a John Deere Z997R machine to account additional mowing due to growing trail miles per year. This machine will be specifically used to help with the boulevards. It will be set up with a rear discharge deck so it will not discharge clippings on the road or trail. It will also come in handy to mow the round about approaches on County Road 39/42. It will be a 72" cut, 37.4 diesel powered engine. Useful Life Project Name Zero Turn Mower Category Equipment Type Equipment Contact Park & Recreation Director Department Fleet Total2023 2024 2025 2026 2027Expenditures 27,50027,500Equipment 27,500 27,500Total Total2023 2024 2025 2026 2027Funding Sources 27,50027,500206 - Capital Equipment Revolving 27,500 27,500Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Replacement of a 2013 pickup. Project #FLEET-23-08 Justification This is a replacement vehicle for the Utility Department remaining consistent with department needs and 10 year vision. The expanding service areas, growing customer base, meter responsibilities and plowing requires vehicle capabilites to meet service needs of the community. Useful Life Project Name 3/4 Ton Extended Cab Pickup Category Vehicles Type Vehicles Contact Utility Operations Manager Department Fleet Total2023 2024 2025 2026 2027Expenditures 58,00058,000Vehicles 58,000 58,000Total Total2023 2024 2025 2026 2027Funding Sources 14,50014,500601 - Water Utility 43,50043,500602 - Sanitary Sewer Utility 58,000 58,000Total Capital Improvement Plan City of Otsego, Minnesota 2023 2027thru Description Addition of a one-ton utility body truck. Project #FLEET-23-09 Justification The Utility Department maintains five trucks and one reserve for eight full time employees and seasonal staff. The expanding service areas, growing customer base requires vehicles to meet service needs of the community. The recommended vehicle is a F350 with utility body. This specific configuration expidites customer responses and is equiped to support various onsite services. This is the second utility body truck for the department. Useful Life Project Name 1 Ton Utility Body Truck Category Vehicles Type Vehicles Contact Utility Operations Manager Department Fleet Total2023 2024 2025 2026 2027Expenditures 68,50068,500Vehicles 68,500 68,500Total Total2023 2024 2025 2026 2027Funding Sources 17,12517,125601 - Water Utility 51,37551,375602 - Sanitary Sewer Utility 68,500 68,500Total Capital Improvement PlanCity of Otsego, MinnesotaPROJECTS BY FUNDING SOURCE2023 2032thruTotal2023 2024 2025 2026 2027Source2028 2029 2030 2031 2032 #206 - Capital Equipment Revolving29,05829,058Compact SUVFLEET-23-0142,23542,2351/2 Ton Extended Cab PickupFLEET-23-02272,563272,563Street SweeperFLEET-23-0358,00058,0003/4 Ton Extended Cab PickupFLEET-23-0442,23542,2351/2 Ton Extended Cab PickupFLEET-23-0531,50031,500Utility VehicleFLEET-23-0627,50027,500Zero Turn MowerFLEET-23-076,415,899761,466 972,867 1,010,237 634,723736,216 474,965 286,191 935,888603,3462024-2032 Future Fleet PurchasesFLEET-24-32206 - Capital Equipment Revolving Total6,918,990503,091 761,466 972,867 1,010,237 634,723 736,216 474,965 286,191 935,888 603,346601 - Water Utility14,50014,5003/4 Ton Extended Cab PickupFLEET-23-0817,12517,1251 Ton Utility Body TruckFLEET-23-09601 - Water Utility Total31,62531,625602 - Sanitary Sewer Utility43,50043,5003/4 Ton Extended Cab PickupFLEET-23-0851,37551,3751 Ton Utility Body TruckFLEET-23-09602 - Sanitary Sewer Utility Total94,87594,875629,591 761,466 972,867 1,010,237 634,7237,045,490GRAND TOTAL736,216 474,965 286,191 935,888 603,346 BeginningInflated Staff Estimated Estimated Estimated AccumulatedAcquisition Acquisition Replacement Replacement Replacement Annual Replacement Inflated Annual Funds 2023 20242025 2026 2027 2028 2029 2030 2031 2032Item NumberItem Description Year Cost Year Inflation Cost Cost Payment Year Cost PaymentSTINGBD20 2006 Ford Explorer2006 20,153              2024 4.00% n/a 30,220                   1,679                    2034 44,733                 4,473                   ‐                  1,679          1,679         4,473           4,473           4,473           4,473         4,473         4,473         4,473         4,473        BD83 2020 Ford Escape 2020 24,907              2030 4.00% 36,868                   n/a 3,687                    2040 54,574                 5,457                   ‐                  3,687          3,687          3,687            3,687            3,687            3,687          3,687          3,687         5,457         5,457        ‐                  5,366          5,366          8,160            8,160            8,160            8,160          8,160          8,160          9,930          9,930         TURE ADDITIONSn/a Compact SUV 2023 29,058              2033 4.00% 43,013                   4,301                    ‐                 4,301         4,301           4,301           4,301           4,301         4,301         4,301         4,301         4,301        ‐                    ‐                    4,301            4,301            4,301            4,301            4,301            4,301            4,301            4,301            4,301           ANNUAL REPLACEMENT TAX LEVY5,366            9,667            12,461         12,461         12,461         12,461         12,461         12,461         14,231         14,231        Secondary ReplacementY:\Budget\2023\Capital Improvement Plan\Fleet\Fleet Vehicles & Equipment Funding (Buildings)BUILDINGS BeginningInflated Staff Estimated Estimated Estimated AccumulatedAcquisition Acquisition Replacement Replacement Replacement Annual Replacement Inflated Annual Funds 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032Item Description Year Cost Year Inflation Cost Cost Payment Year Cost Payment2013 GMC Sierra 1 Ton Pickup2013 31,985             2023 4.00% 47,346                  58,000                  4,735                   2033 85,854                8,585                  ‐                  4,735        8,585        8,585         8,585          8,585          8,585         8,585        8,585        8,585        8,585       2013 Ford F‐150 Extended Cab 2013 25,600             2023 4.00% 37,894                  42,235                  3,789                   2033 62,518                6,252                  ‐                  3,789        6,252        6,252         6,252          6,252          6,252         6,252        6,252        6,252        6,252       2014 Dump Box Trailer2014 12,000             2024 4.00% 17,763                  16,200                  1,776                   2034 26,293                2,629                  ‐                  1,776         1,776        2,629         2,629          2,629          2,629         2,629        2,629        2,629        2,629       2016 Ford F‐250 Extended Cab 2016 40,000             2026 4.00% 59,210                  54,000                  5,921                   2036 87,645                8,764                  ‐                  5,921         5,921         5,921          5,921          8,764          8,764         8,764        8,764        8,764        8,764       2016 John Deere Z930M Mower2016 9,862                2026 4.00% 14,598                  13,314                  1,460                   2036 21,609                2,161                  ‐                  1,460         1,460         1,460          1,460          2,161          2,161         2,161        2,161        2,161        2,161       2017 Ford F‐250 Crew Cab 2017 32,473             2027 4.00% 48,068                  43,839                  4,807                   2037 71,152                7,115                  ‐                  4,807         4,807         4,807          4,807           4,807          7,115         7,115        7,115        7,115        7,115       2018 Ventrac 4500Z Mower2018 52,637             2028 4.00% 77,916                  63,164                  7,792                   2038 115,334              11,533                ‐                  7,792         7,792         7,792          7,792           7,792           7,792         11,533      11,533      11,533      11,533     2018 Toro 5910 Wide Area Mower2018 103,592           2028 4.00% 153,341                139,849                15,334                 2038 226,983              22,698                ‐                  15,334       15,334       15,334        15,334         15,334         15,334       22,698      22,698      22,698      22,698     2018 Felling FT16‐2 Trailer2018 16,513             2028 4.00% 24,443                  22,293                  2,444                   2038 36,182                3,618                  ‐                  2,444         2,444         2,444          2,444           2,444           2,444         3,618        3,618        3,618        3,618       2019 Ford F‐350 Dump Truck2019 41,241             2029 4.00% 61,047                  55,675                  6,105                   2039 90,364                9,036                  ‐                  6,105         6,105         6,105          6,105           6,105           6,105          6,105        9,036        9,036        9,036       2019 John Deere Pro Gator2019 36,110             2029 4.00% 53,452                  48,749                  5,345                   2039 79,121                7,912                  ‐                  5,345         5,345         5,345          5,345           5,345           5,345          5,345        7,912        7,912        7,912       2019 Kromer Field Painter/Groomer2019 22,500             2029 4.00% 33,305                  30,375                  3,331                   2039 49,300                4,930                  ‐                  3,331         3,331         3,331          3,331           3,331           3,331          3,331        4,930        4,930        4,930       2020 Toro Air Blower2020 7,621                2030 4.00% 11,281                  10,288                  1,128                   2040 16,699                1,670                  ‐                  1,128         1,128         1,128          1,128           1,128           1,128          1,128         1,128        1,670        1,670       2020 John Deere Z925A Mower2020 10,200             2030 4.00% 15,098                  13,769                  1,510                   2040 22,349                2,235                  ‐                  1,510         1,510         1,510          1,510           1,510           1,510          1,510         1,510        2,235        2,235       2021 Bobcat Toolcat UTV2021 59,604             2031 4.00% 88,228                  80,460                  8,823                   2041 130,599              13,060                ‐                  8,823         8,823         8,823          8,823           8,823           8,823          8,823         8,823         8,823        13,060     2020 John Deere Z925A Mower2021 10,112             2031 4.00% 14,969                  13,769                  1,497                   2041 22,158                2,216                  ‐                  1,497         1,497         1,497          1,497           1,497           1,497          1,497         1,497         1,497        2,216       ‐                  75,797       82,110       82,963        82,963         86,507         88,815        101,094     108,191     109,458     114,414    UTV 2023 31,500             2033 4.00% 46,628                  4,663                   ‐                 4,663        4,663         4,663          4,663          4,663         4,663        4,663        4,663        4,663       Zero Turn Lawn Mower2023 27,500             2033 4.00% 40,707                  4,071                   ‐                 4,071        4,071         4,071          4,071          4,071         4,071        4,071        4,071        4,071       5000 Series Tractor  2024 78,000             2034 4.00% 115,459                11,546                 ‐                 11,546       11,546        11,546        11,546       11,546      11,546      11,546      11,546     3/4 Ton Extended Cab Pickup2025 61,000             2035 4.00% 90,295                  9,029                   ‐                 9,029          9,029          9,029         9,029        9,029        9,029        9,029       Track Skid Loader2027 63,654             2037 4.00% 94,223                  9,422                   ‐                 9,422         9,422        9,422        9,422        9,422       ‐                    ‐                    8,734           20,280         29,309         29,309         38,731         38,731         38,731         38,731         38,731        ANNUAL REPLACEMENT TAX LEVY75,797         90,844         103,243       112,272       115,816       127,546       139,825       146,922       148,189       153,145      Secondary ReplacementY:\Budget\2023\Capital Improvement Plan\Fleet\Fleet Vehicles & Equipment Funding (Parks)PARKS BeginningInflated Staff Estimated Estimated Estimated AccumulatedAcquisition Acquisition Replacement Replacement Replacement Annual Replacement Inflated Annual Funds 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032Item Number Item Description Year Cost Year Inflation Cost Cost PaymentYear Cost PaymentSTINGPW7 2012 Ford F350 Pickup s/plow 2012 34,516             2024 4.00% 55,261                  56,000                 4,605                  2034 81,800                8,180                  ‐                  4,605         4,605         8,180          8,180          8,180          8,180        8,180        8,180        8,180        8,180       PW52 2013 Ford F150  extended cab 4 X 4 2013 25,600             2024 4.00% 39,410                  35,000                 3,583                  2034 58,336                5,834                  ‐                  3,583         3,583         5,834          5,834          5,834          5,834        5,834        5,834        5,834        5,834       PW20 Atlas Copco Air Compressor 2011 10,270             2024 4.00% 17,100                  13,864                 1,315                  2034 25,313                2,531                  ‐                  1,315         1,315         2,531          2,531          2,531          2,531        2,531        2,531        2,531        2,531       PW42 2002 Sterling Single Axel Plow Truck 2002 46,520             2024 4.00% 230,000                230,000               10,455                2039 414,217              27,614                ‐                  10,455       10,455       27,614        27,614        27,614        27,614      27,614      27,614      27,614      27,614     PW2 2014 Kubota RTV‐X1120D Utility Vehicle 2014 9,857               2024 4.00% 14,591                  13,307                 1,459                  2034 21,598                2,160                  ‐                  1,459         1,459         2,160          2,160          2,160          2,160        2,160        2,160        2,160        2,160       PW23 2004 WRT Rubber Tire Roller2006 12,500             2024 4.00% 25,323                  33,000                 1,407                  2034 37,484                3,748                  ‐                  1,407         1,407         3,748          3,748          3,748          3,748        3,748        3,748        3,748        3,748       PW1 2007 Elgin Street Sweeper2011 77,484             2025 4.00% 300,000                300,000               21,429                2040 540,283              36,019                ‐                  21,429       21,429        21,429        36,019        36,019        36,019      36,019      36,019      36,019      36,019     PW8 2010 CAT 305c Excavator 2010 55,286             2025 4.00% 99,567                  74,636                 6,638                  2040 179,314              11,954                ‐                  6,638         6,638          6,638          11,954        11,954        11,954      11,954      11,954      11,954      11,954     PW39 2008 Sterling L8500 Dump Truck, Plow 2008 68,028             2025 4.00% 238,000                238,000               14,000                2040 428,625              28,575                ‐                  14,000       14,000        14,000        28,575        28,575        28,575      28,575      28,575      28,575      28,575     PW24 2014 Larue D35 Snowblower 2014 87,646             2025 4.00% 134,927                118,322               12,266                2035 199,725              19,972                ‐                  12,266       12,266        12,266        19,972        19,972        19,972      19,972      19,972      19,972      19,972     PW4 2015 Ford F‐350 One ton dump 2015 52,946             2025 4.00% 78,373                  71,477                 7,837                  2035 116,011              11,601                ‐                  7,837         7,837          7,837          11,601        11,601        11,601      11,601      11,601      11,601      11,601     PW54 2016 Ford F‐350 One ton dump 2016 52,946             2026 4.00% 78,373                  71,477                 7,837                  2036 116,011              11,601                ‐                  7,837         7,837          7,837           7,837          11,601        11,601      11,601      11,601      11,601      11,601     PW43 2010 Mack GU713 Tandem Dump Truck,Plow 2010 197,609           2026 4.00% 370,118                275,000               23,132                2041 666,562              44,437                ‐                  23,132       23,132        23,132         23,132        44,437        44,437      44,437      44,437      44,437      44,437     PW17 2017 Ford F250 P/U 2017 24,996             2027 4.00% 37,000                  33,745                 3,700                  2037 54,769                5,477                  ‐                  3,700         3,700          3,700           3,700           3,700         5,477        5,477        5,477        5,477        5,477       PW5 2001 CAT 143H Grader 2013 116,226           2027 4.00% 201,266                200,000               14,376                2042 362,468              24,165                ‐                  14,376       14,376        14,376         14,376         14,376        24,165      24,165      24,165      24,165      24,165     PW36 2017 John Deere 4066R 2017 41,608             2027 4.00% 61,590                  56,171                 6,159                  2037 91,168                9,117                  ‐                  6,159         6,159          6,159           6,159           6,159         9,117        9,117        9,117        9,117        9,117       PW16 2017 Bomag BW90AD Asphalt Roller 2017 29,200             2027 4.00% 43,223                  39,420                 4,322                  2037 63,981                6,398                  ‐                  4,322         4,322          4,322           4,322           4,322         6,398        6,398        6,398        6,398        6,398       PW14 2018 CAT 259D Track Skid Loader 2018 59,124             2028 4.00% 87,518                  79,817                 8,752                  2038 129,548              12,955                ‐                  8,752         8,752          8,752           8,752           8,752          8,752        12,955      12,955      12,955      12,955     PW58 2018 Bermeer BC1000XL Chipper 2018 29,356             2028 4.00% 43,454                  39,631                 4,345                  2038 64,323                6,432                  ‐                  4,345         4,345          4,345           4,345           4,345          4,345        6,432        6,432        6,432        6,432       PW19 2018 Vermac Traffic Information Trailer 2018 16,475             2028 4.00% 24,387                  22,241                 2,439                  2038 36,099                3,610                  ‐                  2,439         2,439          2,439           2,439           2,439          2,439        3,610        3,610        3,610        3,610       PW63 2018 Ford F‐250 Extended Cab 4X4 2018 29,632             2028 4.00% 43,863                  40,003                 4,386                  2038 64,927                6,493                  ‐                  4,386         4,386          4,386           4,386           4,386          4,386        6,493        6,493        6,493        6,493       PW70 2016 Cimline Tack Trailer 2019 12,000             2029 4.00% 17,763                  16,200                 1,776                  2039 26,293                2,629                  ‐                  1,776         1,776          1,776           1,776           1,776          1,776         1,776        2,629        2,629        2,629       PW69 2019 Stepp Hot Box2019 63,733             2029 4.00% 94,340                  86,040                 9,434                  2039 139,647              13,965                ‐                  9,434         9,434          9,434           9,434           9,434          9,434         9,434        13,965      13,965      13,965     PW85 Floor Scrubber2020 15,500             2030 4.00% 22,944                  20,925                 2,294                  2040 33,962                3,396                  ‐                  2,294         2,294          2,294           2,294           2,294          2,294         2,294         2,294        3,396        3,396       PW30 2016 Mack GU712 Single Axle Rolloff2016 219,430           2031 4.00% 395,181                310,000               26,345                2046 711,699              47,447                ‐                  26,345       26,345        26,345         26,345         26,345         26,345       26,345       26,345       26,345      47,447     PW11 2016 Mack GU713 Tandem Axle 2016 212,161           2031 4.00% 382,090                300,000               25,473                2046 688,122              45,875                ‐                  25,473       25,473        25,473         25,473         25,473         25,473       25,473       25,473       25,473      45,875     PW21 2017 CAT 926M Front End Loader 2017 171,110           2032 4.00% 308,159                255,000               20,544                2047 554,978              36,999                ‐                  20,544       20,544        20,544         20,544         20,544         20,544       20,544       20,544       20,544       20,544      PW96 Asphalt Mill 2022 19,866             2032 4.00% 29,407                  32,000                 2,941                  2042 43,529                4,353                  ‐                  2,941         2,941          2,941           2,941           2,941          2,941         2,941         2,941         2,941         2,941        PW98 Traffic Management Sign 2022 16,520             2032 4.00% 24,454                  26,000                 2,445                  2042 36,197                3,620                  ‐                  2,445         2,445          2,445           2,445           2,445          2,445         2,445         2,445         2,445         2,445        PW61 2018 F550 Boom/Sign Truck 2018 114,442           2033 4.00% 206,104                154,000               13,740                2043 305,084              30,508                ‐                  13,740       13,740        13,740         13,740         13,740         13,740       13,740       13,740       13,740       13,740      PW68 2019 Mack GU712 Single Axle Rolloff2019 215,058           2034 4.00% 387,307                325,000               25,820                2049 697,519              46,501                ‐                  25,820       25,820        25,820         25,820         25,820         25,820       25,820       25,820       25,820       25,820      PW67 2019 JD 6130M tractor, mowers, broom, hitch/plow 2019 146,218           2034 4.00% 263,330                205,000               17,555                2044 389,793              38,979                ‐                  17,555       17,555        17,555         17,555         17,555         17,555       17,555       17,555       17,555       17,555      PW84 2020 Mack Roll of truck 2020 270,322           2035 4.00% 486,835                364,935               32,456                2050 876,762              58,451                ‐                  32,456       32,456        32,456         32,456         32,456         32,456       32,456       32,456       32,456       32,456      PW80 Hydraulic Shouldering Machine 2020 9,957               2035 4.00% 17,932                  13,442                 1,195                  2045 26,544                2,654                  ‐                  1,195         1,195          1,195           1,195           1,195          1,195         1,195         1,195         1,195         1,195        PW89 Snow Blower for 6000 Series Tractor 2020 18,584             2035 4.00% 33,469                  31,000                 2,231                  2045 49,542                4,954                  ‐                  2,231         2,231          2,231           2,231           2,231          2,231         2,231         2,231         2,231         2,231        PW92 2021 CAT 910 Loader 2021 134,073           2036 4.00% 241,458                190,000               16,097                2051 434,852              28,990                ‐                  16,097       16,097        16,097         16,097         16,097         16,097       16,097       16,097       16,097       16,097      PW97 2021 Mack GJ713 Tandem Axle 2021 249,307           2036 4.00% 448,988                350,000               29,933                2051 808,602              53,907                ‐                  29,933       29,933        29,933         29,933         29,933         29,933       29,933       29,933       29,933       29,933      PW95 2022 Midsota Skid Loader Trailer 2022 11,648             2036 4.00% 20,171                  16,000                 1,441                  2046 29,857                2,986                  ‐                  1,441         1,441          1,441           1,441           1,441          1,441         1,441         1,441         1,441         1,441        ‐                  396,162     396,162      423,405       469,356       494,425       511,025     520,593     525,977     527,079     568,583    DITIONSn/a Half‐Ton Light Duty Pickup 2023 42,235             2033 4.00% 62,518                  6,252                  ‐                 6,252         6,252          6,252          6,252          6,252        6,252        6,252        6,252        6,252       n/a Street Sweeper2023 272,563           2038 4.00% 490,871                32,725                ‐                 32,725       32,725        32,725        32,725        32,725      32,725      32,725      32,725      32,725     n/a Water tanker truck2024 100,000           2039 4.00% 180,094                12,006                ‐                 12,006        12,006        12,006        12,006      12,006      12,006      12,006      12,006     n/a Three‐Quarter Ton Pickup w/ Plow Equipment 2025 61,000             2035 4.00% 90,295                  9,029                  ‐                 9,029          9,029          9,029        9,029        9,029        9,029        9,029       n/a 6000 Series John Deere tractor,plow,mowing2028 160,000           2038 4.00% 236,839                23,684                ‐                 23,684      23,684      23,684      23,684     n/a S/A Dump Body Plow Truck 2029 215,058           2044 4.00% 387,307                25,820                ‐                 25,820      25,820      25,820     ‐                  ‐                  38,977        50,983         60,012         60,012         60,012       83,696       109,516     109,516     109,516    ANNUAL REPLACEMENT TAX LEVY396,162     435,139      474,388       529,368       554,437       571,037     604,289     635,493     636,595     678,099    Secondary ReplacementY:\Budget\2023\Capital Improvement Plan\Fleet\Fleet Vehicles & Equipment Funding (Streets)STREETS BeginningInflated Staff Estimated Estimated Estimated AccumulatedAcquisition Acquisition Replacement Replacement Replacement Annual Replacement Inflated Annual Funds 2023 20242025 2026 2027 2028 2029 2030 2031 2032Item NumberItem Description Year Cost Year Inflation Cost Cost Payment Year Cost PaymentSTINGPW12 2013 Ford F‐250 Extended Cab ‐ E2013 22,300               2023 4.00% 58,000               58,000              5,800               2033 85,854             8,585               ‐                   5,800         8,585         8,585           8,585           8,585           8,585         8,585         8,585         8,585         8,585        PW77 2000 Olympain Portable Generator Trailer2000 60,000               2024 4.00% 153,798             145,000            6,408               2044 336,991           16,850             ‐                   6,408          6,408         16,850         16,850         16,850         16,850       16,850       16,850       16,850       16,850      PW44 2010 Mack GU713 Jet Vac Truck2010 260,514             2026 4.00% 487,938             600,000            30,496             2041 878,748           58,583             ‐                   30,496        30,496        30,496          30,496         58,583         58,583       58,583       58,583       58,583       58,583      PW78 1999 KatoLight John Deere Portable Generator1999 60,000               2027 4.00% 179,922             160,000            6,426               2047 394,232           19,712             ‐                   6,426          6,426          6,426            6,426            6,426           19,712       19,712       19,712       19,712       19,712      PW57 2017 Ford F‐250 Extended Cab Pickup ‐ CD2017 42,390               2028 4.00% 65,257               62,000              5,932               2038 96,597             9,660               ‐                   5,932          5,932          5,932            5,932            5,932            5,932         9,660         9,660         9,660         9,660        PW18 2016 Ford F‐250 Extended Cab Pickup ‐ WW2016 35,000               2028 4.00% 56,036               62,000              4,670               2038 82,947             8,295               ‐                   4,670          4,670          4,670            4,670            4,670            4,670         8,295         8,295         8,295         8,295        PW94 2007 Mack Tandem 2022 85,404               2030 4.00% 200,000             200,000            25,000             2045 360,189           24,013             ‐                   25,000        25,000        25,000          25,000          25,000          25,000        25,000        25,000       24,013       24,013      PW52 2020 Ford F‐250 Extended Cab Pickup ‐ W2020 36,000               2031 4.00% 55,420               65,000              5,038               2041 82,036             8,204               ‐                   5,038          5,038          5,038            5,038            5,038            5,038          5,038          5,038          5,038         8,204        PW62 2015 F750 Crane Truck2018 134,000             2033 4.00% 241,326             200,000            16,088             2048 434,615           28,974             ‐                   16,088        16,088        16,088          16,088          16,088          16,088        16,088        16,088        16,088        16,088       PW86 2021 CAT 299D Skid2021 87,150               2036 4.00% 156,952             200,000            10,463             2051 282,662           18,844             ‐                   10,463        10,463        10,463          10,463          10,463          10,463        10,463        10,463        10,463        10,463       PW88 2021 Ford F350  Ext Cab w Utility Body ‐ E2021 51,252               2036 4.00% 92,301               ‐                         6,153               2051 166,229           11,082             ‐                   6,153          6,153          6,153            6,153            6,153            6,153          6,153          6,153          6,153          6,153         PW ???? Tanker Truck 2022 221,409             2037 4.00% 398,745             ‐                         26,583             2052 718,117           47,874             ‐                   26,583        26,583        26,583          26,583          26,583          26,583        26,583        26,583        26,583        26,583       ‐                   149,057     151,842     162,284       162,284       190,371       203,657     211,010     211,010     210,023     213,189    DITIONSn/a Portable Generator Trailer 2023 138,000             2043 4.00% 302,375             15,119             ‐                  15,119       15,119         15,119         15,119         15,119       15,119       15,119       15,119       15,119      n/a Utility Body Truck ‐ 1 Ton Extended Cab ‐ WW 2023 68,500               2038 4.00% 123,365             8,224               ‐                  8,224         8,224           8,224           8,224           8,224         8,224         8,224         8,224         8,224        n/a Utility Body Truck ‐ 1 Ton Extended Cab ‐ CD 2024 60,000               2039 4.00% 108,057             7,204               ‐                  7,204           7,204           7,204           7,204         7,204         7,204         7,204         7,204        n/a Kubota Utility Vehicle 2025 14,000               2035 4.00% 20,723               2,072               ‐                  2,072           2,072           2,072         2,072         2,072         2,072         2,072        n/a Utility Body Truck ‐ 1 Ton Extended Cab ‐ W 2025 62,000               2040 4.00% 111,658             7,444               ‐                  7,444           7,444           7,444         7,444         7,444         7,444         7,444        n/a Mack Tandem 2026 160,000             2041 4.00% 288,151             19,210             ‐                  19,210         19,210       19,210       19,210       19,210       19,210      n/a Utility Body Truck ‐ 1 Ton Extended Cab ‐ CD 2028 64,000               2043 4.00% 115,260             7,684               ‐                  7,684         7,684         7,684         7,684        n/a Locate Consideration 2030 62,000               2040 4.00% 91,775               9,178               ‐                  9,178         9,178        n/a Locate Consideration 2030 62,000               2040 4.00% 91,775               9,178               ‐                  9,178         9,178        ‐                   ‐                   23,343        30,547          40,063          59,273          59,273        66,957        66,957        85,313        85,313       ANNUAL REPLACEMENT BUDGET149,057     175,185     192,831       202,347       249,644       262,930     277,967     277,967     295,336     298,502    Secondary ReplacementY:\Budget\2023\Capital Improvement Plan\Fleet\Fleet Vehicles & Equipment Funding (Utilities)UTILITY City of OtsegoCapital Equipment Revolving FundCash Flow SummaryRevised: October 6, 2022 47.49% 13.48% 10.14% 9.39% 8.86% 4.46% 6.22% 3.70% 2.00% 4.53%Actual Forecast2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032RevenuesProperty Taxes 300,000$              320,000$              ‐$                           ‐$                           ‐$                          ‐$                          ‐$                          ‐$                          ‐$                           ‐$                           ‐$                          ‐$                         Property Taxes (Building) ‐                             ‐                             5,366                     9,667                     12,461                12,461                12,461                12,461                12,461                12,461                  14,231                 14,231               Property Taxes (Streets) ‐                             ‐                             396,162                435,139                474,388              529,368              554,437              571,037              604,289              635,493                636,595                678,099             Property Taxes (Parks) ‐                             ‐                             75,797                  90,844                  103,243              112,272              115,816              127,546              139,825              146,922                148,189                153,145             Investment Interest (2,310)                   ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Sales of Fixed Assets ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Sales of Fixed Assets (Est.) 40,000                  ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Utility Fund Contributions ‐                             ‐                             149,057                175,185                192,831              202,347              249,644              262,930              277,967              277,967                295,336                298,502             Transfers In ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Total 337,690                320,000                626,382                710,835                782,923              856,448              932,358              973,974              1,034,542           1,072,843             1,094,351             1,143,977          ExpensesCapital Outlay ‐ Building ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Replacement CIP ‐ Buildings ‐                             ‐                             ‐                             30,220                  ‐                           ‐                           ‐                           ‐                           ‐                            36,868                  ‐                            ‐                          Additions CIP ‐ Buildings ‐                             ‐                             29,058                  ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Capital Outlay ‐ Streets 300,228                48,034                  ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Replacement CIP ‐ Streets ‐                             ‐                             ‐                             381,685                850,867              448,491              343,079              199,222              112,103              22,944                  777,271                362,020             Additions CIP ‐ Streets ‐                             ‐                             314,798                100,000                61,000                ‐                           ‐                           160,000              215,058              ‐                             ‐                            ‐                          Capital Outlay ‐ Parks 69,716                  ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Replacement CIP ‐ Parks ‐                             ‐                             100,235                17,763                  ‐                           73,808                48,068                255,700              147,804              26,379                  103,197                ‐                          Additions CIP ‐ Parks ‐                             ‐                             59,000                  78,000                  61,000                ‐                           63,654                ‐                           ‐                            ‐                             ‐                            ‐                          Replacement CIP ‐ Utilities ‐                             ‐                             ‐                             153,798                ‐                           487,938              179,922              121,294              ‐                            200,000                55,420                 241,326             Transfers Out ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Total 369,944                48,034                  503,091                761,466                972,867              1,010,237           634,723              736,216              474,965              286,191                935,888                603,346             Cash Balance ‐ Beginning390,669                358,415                630,381                753,672                703,041              513,097              359,308              656,943              894,701              1,454,278             2,240,930             2,399,393          Balance Sheet EffectsRevenues 337,690                320,000                626,382                710,835                782,923              856,448              932,358              973,974              1,034,542           1,072,843             1,094,351             1,143,977          Expenditures (369,944)               (48,034)                 (503,091)               (761,466)               (972,867)             (1,010,237)          (634,723)             (736,216)             (474,965)             (286,191)               (935,888)               (603,346)            Cash Balance ‐ Ending 358,415$              630,381$              753,672$              703,041$              513,097$             359,308$             656,943$             894,701$             1,454,278$          2,240,930$           2,399,393$           2,940,024$         Cash Balance ‐ % of Next Year Capital746% 125%99% 72% 51% 57% 89%188% 508% 239% 398%Projection ‐ Capital Improvement PlanY:\Budget\2023\Cash Flows\Capital Funds206-Capital Equipment Capital Improvement PlanCity of Otsego, MinnesotaPROJECTS BY FUNDING SOURCE2023 2032thruTotal2023 2024 2025 2026 2027Source2028 2029 2030 2031 2032 #201 - Pavement Management1,084,1511,084,151Street Maintenance - 2023STREET-23-011,186,8871,186,887Street Renewals - 2023STREET-23-029,582,215721,922 1,127,148 811,629 1,333,762788,695 923,236 1,070,057 1,124,3841,681,382Street Maintenance - 2024 to 2032STREET-24-029,660,2401,925,890 3,180,709 2,615,648 1,937,993Street Renewals - 2024 to 2032STREET-24-03201 - Pavement Management Total21,513,4932,271,038 721,922 3,053,038811,629 4,514,471 788,695 3,538,884 1,070,057 3,062,377 1,681,3822,271,038 721,922 3,053,038 811,629 4,514,47121,513,493GRAND TOTAL788,695 3,538,884 1,070,057 3,062,377 1,681,382 ¯ 456738456738 456738 456742 456742 456742 456742 456736 456739 456739456739 456719 456719 §¨¦9 4 456737 456718 EF137 EF137 10195TH 60TH 85TH 94 70TH 80TH KADLERO DEANRIV E RPAGEPARRISHMACIVER83RDNASHUA 53RDLABEAUX65THQUEENSJABER75TH 78THMASON 77THQUAM91ST PARKMCALLISTER90TH QUADAYJALGERPACKARDMARLOWE96TH89TH OHLANDOGRENJASON O BRIAN10 1S T 61ST 88TH 87TH RAWLINGS7 2 N D73RD KALDERNABERQUIN82ND 74TH 71ST 81ST OAKWOOD92ND PARELL54TH 58TH 59THKAGAN76TH JANDELJAMES LANDER62ND 84TH NEEDHAMRAMIERKAHLER93RD 105TH67TH 94TH QUALEPALMGREN63RDLARGE103RD OGDEN51ST97TH RANDOLPHMARTIN FARMSODELLKITTREDGE O DAY SERVICE LYDIAMARSHALL99TH OCHOA6 9 T H NELMARKQUI GLEY68TH 56 TH 52NDQ UIL L E YKALLANDMARXPADGETTNAPIERNADALANASONKALENDA79TH L A M B E R T LANNONMACKENZIEKAEDI NG57THLAMONTLASALLER A DF OR D75TH LACHMAN64THJANSEN RATHBUN55THPARKINGTON66TH M A C L Y N N QUAKERMARQUETTENAUGHTOR PARQUETO DELLPARSONOR G E N MACKENIZIE MARTINKAHL88TH PARISODAYLANDAULANGLEYPINNACLELARABEE Q U A N T R E L L E QUARRYQUAIL QUENROERASPBERRYPALISADESMACLARENR A M S L U N DMANCHESTERO'DELLPADREKAISERKEADING77TH 77TH PARELLNASHUAO DAY87TH OGRENO DELLLAMBERT ODAYO C H O AKAISERK A G A N MARX PALI SADES6 5 T H 7 2 N D 56THQUADAYOGDEN65TH 74TH 62ND 74TH OAKWOODPAGEKAHLER JABER66TH 90TH 78TH 77THO DAYQUAM87TH 59TH 58TH 62ND 85TH MARLOWE79TH PARKPACKARD83RD PARELLJALGERNABERRAMIER74TH 73RD 67TH 9 6 T H 88TH 79TH 5 7 T H 71 ST 84TH88TH 7 3 R D 71ST83RD 71ST 81ST 69TH O DELL75TH KALLAND72ND74TH 75TH78TH 73RDLANDAU 76TH SERVICE62ND PACKARD92ND PARSON67TH OCHOA71ST71ST PARRISHOAKWOOD77TH JANSEN OGR E N96TH 77TH PACKARD85TH OH L A N DLANDERPARK 73 RD75THMARLOWE QUILLEYO DAY7 2 N D 80TH 81ST 9 2 N D93RD 95TH 78TH 73RD MA R LO W E 62ND 85TH 62ND 78THO BRIAN93RD 79TH JAMES ODELL54TH87TH 75TH 77TH 72ND76 TH75TH 7 7 T H 91ST 90TH 9 2 N D MASON90THLARGE O BRIAN56TH PADGETT 71ST 88TH 71ST70TH 94 81ST 76THPALMGREN89TH L A RGE 76TH 95TH 78TH 77TH P AR E L L 74TH OCHOA87TH ODELL93RD LANGLEY93RD 62NDPARQUET81ST70TH 94TH M A S O N 83RD 76TH 82ND 96TH 87TH 67TH 76TH 71 ST 81ST QUEENS89TH SERVICE 79TH KALLAND59THQUADAY60THPARKINGTON 54TH 9 2 N D 82ND 72ND89TH83RD91ST 72ND88TH 92ND 75TH 71ST 65TH71ST67TH96TH 84TH KAHLER 89TH 10191ST MACKENZIE QUADAYRIVER78TH 73RD 60TH 72 N D 83RD 75TH 72ND OCHOA 90TH 96TH 76TH 87TH 97TH 78TH SERVICE PCI RATING MAP-2022 K:\GIS\Projects\Municipal\OTSEGO\OT387 (Streets)\2022\OT387-2022 PCI Rating Map.mxd Legend NO RATING 33 - 40 41 - 50 51 - 60 61 - 70 71 - 80 81 - 83 84 - 87 88 - 91 92 - 95 96 - 100 July 27th, 2022 City of OtsegoPavement Management FundCash Flow SummaryRevised: October 6, 2022 10.53% 4.76% 0.00% ‐9.09% ‐10.00% ‐11.11% ‐12.50% ‐14.29% ‐16.67% ‐20.00% ‐25.00% ‐33.33%Actual Forecast2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032RevenuesProperty Taxes 1,050,000$           1,100,000$           1,100,000$           1,000,000$           900,000$             800,000$             700,000$             600,000$             500,000$             400,000$              300,000$              200,000$            Intergovernmental (MSA) 272,126                291,478                303,028                304,543                306,066              307,596              309,134              310,680              312,233              313,794                315,363                316,940             Intergovernmental (LGA) ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Franchise Fees (Residential) ‐                             ‐                             685,632                685,632                685,632              685,632              685,632              685,632              685,632              685,632                685,632                685,632             Franchise Fees (Commercial) ‐                             ‐                             101,640                101,640                101,640              101,640              101,640              101,640              101,640              101,640                101,640                101,640             Franchise Fees (New Growth) ‐                             ‐                             9,600                     19,200                  28,800                38,400                48,000                57,600                67,200                76,800                  86,400                 96,000               Special Assessments (Actual) 58,945                  ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Special Assessments (Levied) ‐                             24,590                  23,270                  19,937                  19,375                14,085                9,716                   1,863                   1,822                   1,782                     1,741                    ‐                          Special Assessments (Future) ‐                             ‐                             14,906                  40,824                  39,874                82,506                80,550                78,595                76,639                97,822                  95,333                 97,244               Investment Interest (46,129)                 ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Refunds & Reimbursements 102,461                ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Debt Issuance ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Transfers In ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Total 1,437,403             1,416,068             2,238,076             2,171,776             2,081,387           2,029,859           1,934,672           1,836,010           1,745,166           1,677,470             1,586,109             1,497,456          ExpensesEngineering 85,348                  ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Other Charges & Services 4,729                     ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Capital Outlay 1,115,876             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Capital Outlay (CIP‐Maintenance) ‐                             984,422                1,084,151             721,922                1,127,148           811,629              1,333,762           788,695              923,236              1,070,057             1,124,384             1,681,382          Capital Outlay (CIP‐Renewal) ‐                             895,304                1,186,887             ‐                             1,925,890           ‐                           ‐                           ‐                           2,246,659           ‐                             788,061                ‐                          Capital Outlay (CIP‐MSA) ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           3,180,709           ‐                           368,989              ‐                             1,149,932             ‐                          Transfers Out ‐                             ‐                             ‐                             ‐                             ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             ‐                            ‐                          Total 1,205,953             1,879,726             2,271,038             721,922                3,053,038           811,629              4,514,471           788,695              3,538,884           1,070,057             3,062,377             1,681,382          Cash Balance ‐ Beginning5,304,220             5,682,063             5,218,405             5,185,443             6,635,297           5,663,646           6,881,876           4,302,077           5,349,392           3,555,674             4,163,088             2,686,820          Balance Sheet Effects 146,393               Revenues 1,437,403             1,416,068             2,238,076             2,171,776             2,081,387           2,029,859           1,934,672           1,836,010           1,745,166           1,677,470             1,586,109             1,497,456          Expenditures (1,205,953)            (1,879,726)            (2,271,038)           (721,922)               (3,053,038)          (811,629)             (4,514,471)          (788,695)             (3,538,884)          (1,070,057)            (3,062,377)            (1,681,382)         Cash Balance ‐ Ending 5,682,063$           5,218,405$           5,185,443$           6,635,297$           5,663,646$          6,881,876$          4,302,077$          5,349,392$          3,555,674$          4,163,088$           2,686,820$           2,502,894$         Cash Balance ‐ % of Next Year Capital302% 230% 718% 217% 698% 152% 545% 151% 332% 136% 160%Projection ‐ Capital Improvement PlanY:\Budget\2023\Cash Flows\Capital Funds201-Pavement Management