Loading...
HomeMy WebLinkAboutCity Council Packet 09-21-2021 SpecialCity Council 1 of 1 September 21, 2021 CITY OF PLYMOUTH AGENDA Special City Council September 21, 2021, 5:00 PM 1. CALL TO ORDER 2. TOPICS 2.1 2022 Budget Overview Electronic Budget Binder 2.2 Set future Study Sessions September October November December January February 3. ADJOURN 1 Special City Council September 21, 2021 Agenda Number:2.1 To:Dave Callister, City Manager Prepared by:Julie McMackins, Supervising Accountant Reviewed by:Maria Solano, Deputy City Manager Item:2022 Budget Overview 1. Action Requested: Review budget materials and provide staff direction for the preliminary 2022 property tax levy (to be considered on September 28). 2. Background: City staff is privileged to present the proposed 2022 City of Plymouth General Fund and Special Revenue Funds Budgets. This is the first year of the 2022/2023 Biennial Budget. During the first two scheduled budget meetings, the primary focus by staff and Council will be reviewing the General Fund, Special Revenue Funds and Capital Improvement Plan to prepare for the levy adoption on September 28. Council will receive the Enterprise Funds and Internal Service Funds materials on October 11 to prepare for the budget meetings in October and November. The budget is one of the most important policy documents adopted by City Council because it sets priorities and serves as a work plan for the coming year. As shown in the attached calendar, the City Council and staff will spend significant time reviewing the budget between now and adoption of the final levy on December 14. Resident input is welcomed during this process and both formal and informal opportunities are available. The City Manager and budget team held meetings with each department to review line item detail. As a result of these meetings, staff has developed a preliminary budget that meets the organization’s service demands at a proposed levy increase of 7.92%. The proposed levy consists of an increase of 4.46% for the levy base and an increase of 3.46% for special levies. The special levies calculation includes the full levy for the Plymouth Community Center bonds, a partial year levy for the Fire Stations bonds and paying off the 2012A Public Safety refunding bonds in 2022. The General Fund expenditure budget increased 4.6% over 2021. Personal Services increased 5.3% including 1.8 new General Fund positions, cost of living adjustments, and step increases for existing positions. The new positions include .5 Parks Maintenance Worker, .8 Community Center Maintenance Supervisor, .6 Community Center Activity Coordinator and a .1 allocation decrease to the Engineering Services Manager. 2 The Special Revenue Funds expenditure budgets increased 2.1% over 2021. Personal Services increased 7.4% including .6 allocation adjustment to positions, cost of living adjustments, and step increases for existing positions. Personal Services along with the purchase of an electronic sign at the Northwest Greenway contributed to the increase in expenditures. The residential market value increased approximately 4.3%. New construction continues to be strong and accounts for 1.5% of the total market value increase. This new growth will help ease the tax impact to residents. The tax impact on an average residential home ($425,000) is $68.58 in 2022. The tax impact on a $1M commercial property and on a $5M commercial property is $132.62 and $1,201.81, respectively. 3. Budget Impact: Staff will update the budget further after Council discussion on September 21 and in its upcoming study sessions. The preliminary levy is set to be presented on September 28 and the final adoption is planned for December 14. 4. Attachments: Electronic Budget Binder 3 City of Plymouth Proposed 2022/2023 Biennial Budget 4 1 ‐ Calendar & Memo    13 ‐ Capital Improvement Plan – Project Changes  2 ‐ Budget ‐ General Fund – Summary by Category    14 ‐ * Budget – Enterprise & Internal Service Funds –  Summary by Category  3 ‐ Budget ‐ General Fund – Summary by Department    15 ‐ * Budget ‐ Enterprise & Internal Service Funds –  Summary by Fund  4 ‐ Budget ‐ General Fund – Budget Detail    16 ‐ * Budget ‐ Enterprise & Internal Service Funds –  Budget Detail  5 ‐ Personnel – General Fund    17 ‐ * Capital Improvement Plan – Projects by  Department  6 ‐ Budget ‐ Special Revenue Funds – Summary by  Category    18 ‐ * Capital Improvement Plan – Projects by Funding  Source  7 ‐ Budget ‐ Special Revenue Funds – Summary by Fund    19 ‐ * Capital Improvement Plan – Project Changes  8 ‐ Budget ‐ Special Revenue Funds – Budget Detail    20 ‐ * Personnel – Enterprise & Internal Service Funds  9 ‐ Personnel – Special Revenue Funds    21 ‐ * Overall Budget ‐ All Funds – Summary by  Category  10 ‐ Other ‐ Levy    22 ‐ * Overall Budget ‐ All Funds – Summary by Fund  11 ‐ Capital Improvement Plan – Projects by Department    23 ‐ * Personnel – All Funds  12 ‐ Capital Improvement Plan – Projects by Funding  Source    24 ‐ * Allocations   * Materials provided prior to meeting #4 5 Budget Calendar 2022 – 2023 Biennial Budget Preparation & 10-yr Capital Improvement Plan DATE EVENT  May 17, 2021 Departments receive budget instruction  May – June 2021  Departments prepare budgets  May 24, 2021 Personnel changes submitted to HR  June 7, 2021  HR submits personnel changes to Finance  June 22, 2021 Council Study Session – Budget Goals  June 23, 2021  Finance completes personnel changes in budget system  July 12, 2021 Departmental budgets submitted to Finance  July 26 – Aug 6, 2021  Department meetings  August 10, 2021 Council regular session (Financial Overview) & Audit presentation  September 1, 2021 Council receives budget materials for budget meeting #1  September 14, 2021 Council study session – Levy Impacted Funds & related CIP (General & Special Revenue) (Mtg #1)  September 21, 2021 Council Study Session – Levy Impacted Funds & related CIP (General & Special Revenue) (Mtg #2)   (if needed)  September 28, 2021 Council adopts preliminary levies & budget (Budget Meeting #3)  October 11, 2021  Council receives budget materials and utility study for Budget Meeting #4  October 26, 2021 Council Study Session Enterprise Funds Budget with Utility Study and related CIP (Meeting #4)  November 9, 2021 Council Study Session Internal Service Funds Budget Review and related CIP (Meeting #5)   November 17, 2021 Planning commission public hearing  November 23, 2021 Council Study Session (Budget meeting #6) (If needed)  December 14, 2021 Budget Public Hearing ‐ CIP, Budget, Levy, & Utility Rates Adoption  December 27, 2021  Levy is certified with Hennepin County  Page 1 6 Special City Council September 14, 2021 Agenda Number:2.1 To:Dave Callister, City Manager Prepared by:Julie McMackins, Supervising Accountant Reviewed by:Maria Solano, Deputy City Manager Item:2022 Budget Overview 1. Action Requested: Review budget materials and provide staff direction for the preliminary 2022 property tax levy (to be considered on September 28). 2. Background: City staff is privileged to present the proposed 2022 City of Plymouth General Fund and Special Revenue Funds Budgets. This is the first year of the 2022/2023 Biennial Budget. During the first two scheduled budget meetings, the primary focus by staff and Council will be reviewing the General Fund and Special Revenue Funds and Capital Improvement Plan to prepare for the levy adoption on September 28. Council will receive the Enterprise Funds and Internal Service Funds materials on October 11 to prepare for the budget meetings in October and November. The budget is one of the most important policy documents adopted by City Council because it sets priorities and serves as a work plan for the coming year. As shown in the attached calendar, the City Council and staff will spend significant time reviewing the budget between now and adoption of the final levy on December 14. Resident input is welcomed during this process and both formal and informal opportunities are available. The City Manager and budget team held meetings with each department to review line item detail. As a result of these meetings, staff has developed a preliminary budget that meets the organization’s service demands at a proposed levy increase of 7.92%. The proposed levy consists of an increase of 4.46% for the levy base and an increase of 3.46% for special levies. The special levies calculation includes the full levy for the Plymouth Community Center bonds, a partial year levy for the Fire Stations bonds and paying off the 2012A Public Safety refunding bonds in 2022. The General Fund expenditure budget increased 4.6% over 2021. Personal Services increased 5.3% including 1.8 new General Fund positions, cost of living adjustments, and step increases for existing positions. The new positions include .5 Parks Maintenance Worker, .8 Community Center Maintenance Supervisor, .6 Community Center Activity Coordinator and a .1 allocation decrease to the Engineering Services Manager. Page 2 7 The Special Revenue Funds expenditure budgets increased 2.1% over 2021. Personal Services increased 7.4% including .6 allocation adjustment to positions, cost of living adjustments, and step increases for existing positions. Personal Services along with the purchase of an electronic sign at the Northwest Greenway contributed to the increase in expenditures. The residential market value increased approximately 4.3%. New construction continues to be strong and accounts for 1.5% of the total market value increase. This new growth will help ease the tax impact to residents. The tax impact on an average residential home ($425,000) is $68.58 in 2022. The tax impact on a $1M commercial property and on a $5M commercial property is $132.62 and $1,201.81, respectively. 3. Budget Impact: Staff will update the budget further after Council discussion on September 14 and in its upcoming study sessions. The preliminary levy is set to be presented on September 28 and the final adoption is planned for December 14. 4. Attachments: Page 3 8 Account CategoryActual2018Actual2019Actual2020Budget Amended2021Budget Proposed2022Budget Amended - Proposed Variance %2021-2022Budget Proposed - Proposed Variance %2022-2023General Property Taxes 27,836,128 29,623,326 31,473,326 33,598,337 35,851,7796.7%4.5%Permits and Licenses4,441,208 4,960,591 3,947,566 3,717,130 3,699,480-0.5%0.0%Intergovernmental2,926,320 3,950,320 7,590,014 2,828,828 2,892,3062.2%3.8%Charges for Services1,484,953 1,430,616 1,329,916 1,585,702 1,820,13614.8%29.0%Billings to Departments1,704,140 2,031,920 1,826,808 2,102,569 1,819,596-13.5%14.6%Fines & Forfeitures520,206 538,654 321,938 513,000 415,000-19.1%0.0%Special Assessments19,85617,0896,713 10,00010,0000.0%0.0%Contributions & Donations - Operating88,87599,72585,873 7,3006,300-13.7%0.0%Interest Income264,307 563,728533,541 200,400 215,5007.5%0.0%Other255,560 187,14959,554 96,40032,600-66.2%11.7%Transfers In310,927 196,424 276,698 250,000 193,000-22.8%-27.5%$39,852,479 $43,599,543 $47,451,948 $44,909,666 $46,955,6974.6%5.2%Personal Services24,136,316 25,514,449 26,798,852 28,807,119 30,322,1385.3%5.5%Materials and Supplies1,185,567 1,309,337 1,341,288 1,344,156 1,219,506-9.3%2.7%Employee Development & Meetings322,349 371,586 249,648 364,795 439,49520.5%-0.3%Dues & Subscriptions126,547 162,120 143,593 152,414 255,88867.9%16.0%Contractual Services4,275,214 5,172,970 5,436,539 5,345,196 5,681,7046.3%2.1%Equipment114,80635,153 118,189 118,400 125,9006.3%-8.7%Capital Improvements201,504 212,755 172,203--0.0%0.0%Allocations6,956,008 7,190,914 7,230,656 7,398,900 7,619,0193.0%2.8%Transfers Out626,917 1,119,198 3,614,972 202,500 149,500-26.2%35.5%Other Expense1,056,638 1,781,161 1,798,463 1,176,186 1,142,547-2.9%29.8%$39,001,866 $42,869,643 $46,904,404 $44,909,666 $46,955,6974.6%5.2%9500202,50099001,482,747Total$49,419,101114,9008100-90007,829,7264900140,000Total$49,419,101Expenses600031,998,83061001,252,7066500438,3956700296,71370005,802,58480006,3004700215,500480036,400 Revenues400037,459,30441003,699,48042003,003,06343002,348,47043802,085,5844400415,000450010,0004600City of Plymouth2022 Adopted BudgetBudget by CategoryBudget Proposed2023Page 49 Department Actual 2020 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Budget Variance $ 2022-2023 Budget Variance % 2022-2023 Revenue City Administration 34,135,333 35,177,108 37,440,111 39,087,458 2,263,003 6.43 %1,647,347 4.40 % Administrative Services 372,203 336,480 387,230 338,030 50,750 15.08 %(49,200)(12.71 %) Community Development 3,896,890 3,485,150 3,465,250 3,465,250 (19,900)(.57 %)-0.00 % Parks and Recreation 711,175 336,200 589,500 1,111,000 253,300 75.34 %521,500 88.46 % Police 4,078,843 2,063,828 1,959,400 1,974,484 (104,428)(5.06 %)15,084 .77 % Emergency Management 45,763 ----0.00 %-0.00 % Fire 1,466,757 616,900 571,306 636,979 (45,594)(7.39 %)65,673 11.50 % Public Works 2,744,984 2,894,000 2,542,900 2,805,900 (351,100)(12.13 %)263,000 10.34 % Total $47,451,948 $44,909,666 $46,955,697 $49,419,101 $2,046,031 4.56 %$2,463,404 5.25 % City of Plymouth 2022/2023 Biennial Budget Summary General Fund Budgeted Revenues and Expenditures by Department Page 5 10 Department Actual 2020 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Budget Variance $ 2022-2023 Budget Variance % 2022-2023 Expenses City Administration 6,278,635 2,673,920 2,799,271 3,251,672 125,351 4.69 %452,401 16.16 % Administrative Services 3,757,405 3,646,648 3,920,728 3,908,144 274,080 7.52 %(12,584)(.32 %) Community Development 2,730,144 2,813,112 2,887,512 2,997,064 74,400 2.64 %109,552 3.79 % Parks and Recreation 6,922,032 7,080,692 7,556,943 8,137,497 476,251 6.73 %580,554 7.68 % Police 15,710,767 16,104,662 16,686,218 17,318,003 581,556 3.61 %631,785 3.79 % Emergency Management 88,537 74,907 75,501 76,113 594 .79 %612 .81 % Fire 5,494,939 5,988,810 6,274,854 6,672,486 286,044 4.78 %397,632 6.34 % Public Works 5,921,944 6,526,915 6,754,670 7,058,122 227,755 3.49 %303,452 4.49 % Total $46,904,404 $44,909,666 $46,955,697 $49,419,101 $2,046,031 4.56 %$2,463,404 5.25 % City of Plymouth 2022/2023 Biennial Budget Summary General Fund Budgeted Revenues and Expenditures by Department Page 6 11 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4000.100 - Taxes - Property $29,623,326 $31,473,326 $17,380,496 $33,598,337 $35,851,779 $37,459,304 $2,253,442 6.71 % 4200 - Intergovern- Federal - Operating -11,224 -----0.00 % 4230.100 - Intergovern-State-Operating - Mkt Value Credit (HACA) 298 289 -----0.00 % 4350.119 - General Services - Antennae Charges 169,238 179,433 169,373 183,702 203,736 210,570 20,034 10.91 % 4355 - Developer Fees -5,994 4,451 -5,000 5,000 5,000 100.00 % 4380.300 - Allocation Charges - General Fund Administrative 1,036,475 1,036,475 711,713 1,067,569 1,099,596 1,132,584 32,027 3.00 % 4500 - Special Assessments 8,551 ------0.00 % 4600 - Contributions - Operating -750 -----0.00 % 4700.100 - Interest Income - Investments 527,471 522,528 (6,773)170,000 190,000 190,000 20,000 11.76 % 4700.150 - Interest Income - Operating Account 24,415 3,091 137 10,000 5,000 5,000 (5,000)(50.00 %) 4700.200 - Interest Income - Special Assessments 673 ------0.00 % 4700.250 - Interest Income - Delinquent Property Taxes 11,170 7,288 19,086 20,000 20,000 20,000 -0.00 % 4800 - Other Revenues 36,714 34 391 50,000 --(50,000)(100.00 %) 4801 - Administrative Fee ---12,500 --(12,500)(100.00 %) 4807 - Refunds & Reimbursements -810 -----0.00 % Total $31,438,331 $33,241,242 $18,278,873 $35,112,108 $37,375,111 $39,022,458 $2,263,003 6.45 % Expenses 6000 - Salaries $1,383 $5,121 -----0.00 % 6000.100 - Salaries - Regular 331,375 337,352 184,389 353,378 338,829 356,427 (14,549)(4.12 %) 6000.200 - Salaries - Temporary ---17,687 17,795 18,325 108 .61 % 6020.100 - Overtime/Comp Time --757 ----0.00 % 6050 - Benefits 210 776 -----0.00 % 6050.100 - Benefits - Social Security 16,564 16,456 11,720 15,791 15,797 15,830 6 .04 % 6050.101 - Benefits - Medicare 4,896 4,952 2,743 5,415 5,205 5,469 (210)(3.88 %) 6050.200 - Benefits - PERA 11,220 11,863 3,984 27,830 26,747 28,106 (1,083)(3.89 %) 6050.201 - Benefits - Deferred Compensation 13,633 13,438 8,941 ----0.00 % 6050.550 - Benefits - Cell Phone Allowance 1,205 1,160 430 1,200 1,200 1,200 -0.00 % 6050.570 - Benefits - Car Allowance 1,205 1,160 430 1,200 1,200 1,200 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 25,832 19,479 12,672 20,733 39,526 45,030 18,793 90.64 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - City Manager Page 7 12 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6060.500 - Medical Insurance - Cash Out to VEBA -25,403 3,169 ----0.00 % 6070.100 - Dental Insurance - Employer Contribution 1,264 1,160 313 1,260 1,260 1,323 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 1,060 1,076 520 1,058 1,066 1,066 8 .76 % 6100 - Office Supplies 907 967 607 2,500 1,500 1,500 (1,000)(40.00 %) 6120 - Operating Supplies -7,452 -----0.00 % 6500 - Employee Development 270 ------0.00 % 6500.100 - Employee Development - Training 13,613 731 1,391 8,000 8,000 8,000 -0.00 % 6550 - Mileage & Parking Reimbursement 911 565 232 1,000 1,000 1,000 -0.00 % 6600 - Meetings 2,021 349 56 2,000 2,000 2,000 -0.00 % 6700 - Dues & Subscriptions 5,063 1,483 363 3,500 3,500 3,500 -0.00 % 6700.100 - Dues & Subscriptions - MN League of Cities 33,991 34,818 -34,000 35,500 35,500 1,500 4.41 % 6700.101 - Dues & Subscriptions - Metro Cities 14,296 -14,240 14,704 14,338 14,338 (366)(2.49 %) 6700.102 - Dues & Subscriptions - Municipal Legislative Comm 10,500 -10,500 10,500 10,500 10,500 -0.00 % 6700.103 - Dues & Subscriptions - Suburban Rate Authority 7,232 7,376 7,376 6,800 6,800 6,800 -0.00 % 6700.107 - Dues & Subscriptions 597 614 -600 600 600 -0.00 % 6700.108 - Dues & Subscriptions - Wright County Hwy 55 Coalition 250 250 -250 250 250 -0.00 % 7003 - Legal 113,100 145,767 74,579 110,000 110,000 110,000 -0.00 % 7003.100 - Legal - Retainer 284,952 284,952 159,876 314,800 320,000 320,000 5,200 1.65 % 7003.101 - Legal - Criminal Prosecution 14,062 8,996 3,999 20,000 20,000 20,000 -0.00 % 7003.102 - Legal - Lobbying 38,000 38,000 26,667 40,000 42,000 42,000 2,000 5.00 % 7006 - Medical Fees 213 ------0.00 % 7100 - Communications 4,656 1,525 4,492 ----0.00 % 7100.100 - Communications - Postage 839 1,186 486 2,500 2,500 2,500 -0.00 % 7200 - Printing & Publishing 2,850 ------0.00 % 8930 - Special Assessments 10,774 174,346 800 --230,000 -0.00 %2023: Assessments for City Center Project: PIC - $100,000 Hilde - $20,000 City Hall/Public Safety - $80,000 PCC/Fieldhouse - $30,000 City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - City Manager Page 8 13 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 9000.101 - Allocations - Information Technology 21,840 21,840 14,997 22,495 23,170 23,865 675 3.00 % 9000.102 - Allocations - Facilities Management 39,485 39,485 27,113 40,670 41,890 43,147 1,220 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 790 1,482 415 622 904 917 282 45.34 % 9500.400 - Transfers Out - General Capital Projects 884,091 2,924,887 -----0.00 % 9500.620 - Transfers Out - Information Technology 33,373 ------0.00 % 9500.660 - Transfers Out - Resource Planning -25,245 -----0.00 % 9900 - Miscellaneous 58 753 68 ----0.00 % 9917 - Bad Debt -------0.00 % 9918 - Contingency 6,178 12,876 34,649 301,439 250,000 350,000 (51,439)(17.06 %) 9920.100 - Bank Fees - Credit Card --25 25 25 25 -0.00 % 9920.150 - Bank Fees - PSN 83 24 16 100 100 100 -0.00 % 9920.160 - Bank Fees - Operating Acct 1,632 1,572 666 1,700 1,200 1,200 (500)(29.41 %) 9920.170 - Bank Fees - Investments 388 458 183 400 400 400 -0.00 % Total $1,956,860 $4,177,397 $613,863 $1,384,157 $1,344,802 $1,702,118 ($39,355)(2.84 %) City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - City Manager Page 9 14 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$5,368 -----0.00 % 4807 - Refunds & Reimbursements 105 ------0.00 % 4900.100 - Transfers In - General -757 -----0.00 % 4900.240 - Transfers In - Lawful Gambling 59,427 39,605 -65,000 65,000 65,000 -0.00 % Total $59,532 $45,730 -$65,000 $65,000 $65,000 -0.00 % Expenses 6000.100 - Salaries - Regular $80,553 $81,978 $49,375 $84,438 $84,642 $86,097 $204 .24 % 6050.100 - Benefits - Social Security ---1,072 1,074 1,106 2 .19 % 6050.101 - Benefits - Medicare 1,211 1,232 741 1,268 1,271 1,292 3 .24 % 6050.200 - Benefits - PERA 4,027 4,099 2,469 4,222 4,233 4,305 11 .26 % 6050.550 - Benefits - Cell Phone Allowance 1,200 1,200 700 1,200 1,200 1,200 -0.00 % 6050.560 - Benefits - IPAD allowance 1,750 1,800 1,050 1,800 1,800 1,800 -0.00 % 6100 - Office Supplies 1,361 242 33 800 800 800 -0.00 % 6500 - Employee Development 600 ------0.00 % 6500.100 - Employee Development - Training 1,331 550 95 5,600 5,600 5,600 -0.00 % 6600 - Meetings 8,685 4,931 2,181 6,300 6,300 6,300 -0.00 % 6700 - Dues & Subscriptions -27,631 -----0.00 % 7000 - Professional Services 4,380 5,328 3,241 4,000 5,000 5,000 1,000 25.00 % 7200 - Printing & Publishing 1,735 1,202 934 2,000 2,000 2,000 -0.00 % 9000.101 - Allocations - Information Technology 39,874 39,874 27,380 41,070 42,302 43,571 1,232 3.00 % 9000.102 - Allocations - Facilities Management 63,502 63,502 43,605 65,407 67,369 69,390 1,962 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 2,103 4,939 1,063 1,594 2,560 2,608 966 60.60 % 9906 - Donations & Contributions 15,000 -15,000 15,000 15,000 15,000 -0.00 % 9906.100 - Donations & Contributions - Music In Plymouth 30,000 8,320 32,000 32,000 32,000 32,000 -0.00 % 9906.101 - Donations & Contributions - Social Services 109,702 124,702 109,702 109,072 109,072 109,072 -0.00 % Total $367,015 $371,531 $289,568 $376,843 $382,223 $387,141 $5,380 1.43 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - Mayor and Council Page 10 15 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$768,286 -----0.00 % 4230.500 - Intergovern-State-Operating - Pass-Through 900,000 ------0.00 % 4350.123 - General Services - Application Fees 5,000 ------0.00 % 4600 - Contributions - Operating 80,000 80,000 -----0.00 % Total $985,000 $848,286 -----0.00 % Expenses 6000 - Salaries $2,179 $11,133 -----0.00 % 6000.100 - Salaries - Regular 130,538 138,070 91,232 174,341 174,232 180,828 (109)(.06 %) 6000.200 - Salaries - Temporary 2,506 ------0.00 % 6050 - Benefits 330 1,687 -----0.00 % 6050.100 - Benefits - Social Security 7,597 8,223 5,407 9,304 9,064 9,201 (240)(2.58 %) 6050.101 - Benefits - Medicare 1,777 1,923 1,265 2,563 2,562 2,657 (1)(.04 %) 6050.200 - Benefits - PERA 9,978 10,341 6,842 13,075 13,068 13,562 (7)(.05 %) 6050.550 - Benefits - Cell Phone Allowance 1,205 1,160 780 1,200 1,200 1,200 -0.00 % 6050.570 - Benefits - Car Allowance 1,205 1,160 780 1,200 1,200 1,200 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 14,107 14,038 9,795 23,318 28,036 31,397 4,718 20.23 % 6070.100 - Dental Insurance - Employer Contribution ---1,260 1,260 1,323 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 435 455 299 619 627 627 8 1.29 % 6140 - Miscellaneous Supplies 450 --500 500 500 -0.00 % 6500 - Employee Development 295 ------0.00 % 6500.100 - Employee Development - Training -32 -3,000 3,000 3,000 -0.00 % 6550 - Mileage & Parking Reimbursement 63 24 -500 500 500 -0.00 % 6600 - Meetings 1,873 50 -1,500 1,500 1,500 -0.00 % 6700 - Dues & Subscriptions 1,291 1,178 1,436 5,000 5,000 5,000 -0.00 % 7000 - Professional Services 14,903 96,684 15,863 20,000 23,500 23,500 3,500 17.50 %2022: Additional $3,500 for Catalyst data providing up to minute information on for sale and for lease buildings 7003 - Legal 2,085 ------0.00 % 7200 - Printing & Publishing 10 150 -500 500 500 -0.00 % 9000.101 - Allocations - Information Technology 10,287 10,287 7,064 10,596 10,914 11,241 318 3.00 % 9000.102 - Allocations - Facilities Management 4,270 4,270 2,932 4,398 4,530 4,666 132 3.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - Economic Development Page 11 16 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 9000.110 - Allocations - Risk Mgmt - OH, Premium 468 894 287 431 573 579 142 32.95 % 9000.111 - Allocations - Risk Mgmt - Claims ----72 72 72 100.00 % 9911 - Grant Awards -728,300 -----0.00 % 9918 - Contingency ---5,000 5,000 5,000 -0.00 % 9950 - Grant & Award Fiscal Agent Pass- Through 900,000 ------0.00 % Total $1,107,852 $1,030,058 $143,982 $278,305 $286,838 $298,053 $8,533 3.07 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - Economic Development Page 12 17 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$19 -----0.00 % 4230.101 - Intergovern-State-Operating - PERA 46,993 ------0.00 % 4807 - Refunds & Reimbursements 4,850 -215 ----0.00 % 4900.100 - Transfers In - General -56 -----0.00 % Total $51,843 $75 $215 ----0.00 % Expenses 6000 - Salaries $2,917 $17,477 -----0.00 % 6000.100 - Salaries - Regular 371,338 386,167 285,263 495,881 525,937 544,344 30,056 6.06 % 6010 - Salary Vacancies ---(200,000)(200,000)(200,000)-0.00 % 6020.100 - Overtime/Comp Time ---260 260 260 -0.00 % 6030.100 - Other Pay - Comp Time (188)------0.00 % 6050 - Benefits 413 2,571 -----0.00 % 6050.100 - Benefits - Social Security 22,065 21,778 15,904 29,019 29,512 30,339 493 1.70 % 6050.101 - Benefits - Medicare 5,173 5,199 3,720 7,216 7,648 7,915 432 5.99 % 6050.200 - Benefits - PERA 27,850 28,928 21,395 37,212 39,465 40,845 2,253 6.05 % 6050.550 - Benefits - Cell Phone Allowance 1,205 1,160 780 1,200 1,200 1,200 -0.00 % 6050.560 - Benefits - IPAD allowance 300 175 -300 --(300)(100.00 %) 6050.800 - Benefits - Years of Service Award 2,600 8,500 -5,550 7,750 9,880 2,200 39.64 % 6060.100 - Medical Insurance - Employer Contribution 48,219 54,656 43,499 72,535 83,817 94,075 11,282 15.55 % 6070.100 - Dental Insurance - Employer Contribution 3,628 1,700 914 3,780 1,681 1,765 (2,099)(55.53 %) 6080.100 - Group Life Insurance - Employer Contribution 904 925 717 1,482 1,507 1,532 25 1.69 % 6100 - Office Supplies 569 294 190 1,000 2,000 2,000 1,000 100.00 %2022: includes $1k for DEI 6500.100 - Employee Development - Training 3,626 2,623 375 5,000 7,000 7,000 2,000 40.00 %2022: includes $2K for DEI 6500.101 - Employee Development - City Wide Training 15,160 11,640 8,546 15,000 20,000 20,000 5,000 33.33 %2022: includes $5K for DEI speakers, facilitators 6500.103 - Employee Development - EE Recognition 10,970 7,637 968 6,350 6,650 6,650 300 4.72 % 6550 - Mileage & Parking Reimbursement 20 --200 400 400 200 100.00 %2022: includes $200 for DEI 6700 - Dues & Subscriptions 950 822 878 985 3,500 3,500 2,515 255.33 %2022: includes $2500 for GARE (Edina, MTKA, SLP, GV. Henn County, Richfield, BC, STP, MPLS) 6700.109 - Dues & Subscriptions - Software ----85,000 125,000 85,000 100.00 %2022: HRIS software 7000 - Professional Services 34,982 43,784 21,849 44,550 48,700 52,200 4,150 9.32 %2022: includes $4K for DEI translation services 7006 - Medical Fees 16,721 14,832 14,035 16,700 18,075 18,075 1,375 8.23 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - Human Resources Page 13 18 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7007 - Drug and Alcohol Testing 2,864 3,809 2,045 2,300 4,300 4,300 2,000 86.96 %2022: Required to increase testing from 25% of employees per quarter to 50%. 7100.100 - Communications - Postage 352 393 10 350 --(350)(100.00 %) 7200 - Printing & Publishing 2,308 1,661 2,524 3,800 4,000 4,000 200 5.26 %2022: includes $200 for DEI 8000 - Non-Cap Equip (< 5K)--1,969 ----0.00 % 9000.101 - Allocations - Information Technology 51,644 51,644 35,462 53,193 54,789 56,433 1,596 3.00 % 9000.102 - Allocations - Facilities Management 12,695 12,695 8,717 13,076 13,468 13,872 392 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 1,231 2,731 651 976 1,499 1,525 523 53.59 % 9500.620 - Transfers Out - Information Technology --490 ----0.00 % 9900 - Miscellaneous 450 75 -----0.00 % 9919 - Administration Fees 15,192 15,773 9,236 16,700 17,250 17,250 550 3.29 % Total $656,158 $699,648 $480,135 $634,615 $785,408 $864,360 $150,793 23.76 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures City Administration - Human Resources Page 14 19 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$14,217 -----0.00 % 4900.660 - Transfers In - Resource Planning 5,635 --35,000 35,000 35,000 -0.00 % Total $5,635 $14,217 -$35,000 $35,000 $35,000 -0.00 % Expenses 6000 - Salaries $5,787 $3,760 -----0.00 % 6000.100 - Salaries - Regular 278,430 315,055 193,701 360,840 355,214 378,460 (5,626)(1.56 %) 6000.200 - Salaries - Temporary 10,727 521 -----0.00 % 6050 - Benefits 877 570 -----0.00 % 6050.100 - Benefits - Social Security 18,088 19,722 11,820 22,670 22,321 23,686 (349)(1.54 %) 6050.101 - Benefits - Medicare 4,230 4,613 2,764 5,301 5,221 5,557 (80)(1.51 %) 6050.200 - Benefits - PERA 20,882 23,577 14,528 27,062 26,641 28,384 (421)(1.56 %) 6050.550 - Benefits - Cell Phone Allowance 3,615 3,950 2,670 4,800 4,800 4,800 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 32,092 35,929 53,754 51,063 57,056 61,860 5,993 11.74 % 6070.100 - Dental Insurance - Employer Contribution 1,191 1,303 842 2,523 2,523 2,649 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 999 1,064 632 1,343 1,311 1,369 (32)(2.38 %) 6100 - Office Supplies 1,154 1,321 101 2,000 2,000 2,000 -0.00 % 6500 - Employee Development --113 ----0.00 % 6500.100 - Employee Development - Training 5,891 365 95 6,700 6,700 6,700 -0.00 % 6700 - Dues & Subscriptions 8,736 6,712 4,460 7,300 7,300 7,300 -0.00 % 7000 - Professional Services 3,482 15,548 475 10,000 10,000 10,000 -0.00 % 7100.100 - Communications - Postage 30,237 29,715 23,667 36,500 37,500 37,500 1,000 2.74 % 7100.105 - Communications - Community Identity 3,411 580 -3,300 3,300 3,300 -0.00 % 7200 - Printing & Publishing 671 372 130 4,500 4,500 4,500 -0.00 % 7200.100 - Printing & Publishing - Plymouth News 24,530 19,827 25,308 32,000 34,000 34,000 2,000 6.25 % 7500.202 - Repair & Maint Services - Equipment Maint 5,795 6,374 175 6,300 6,300 6,300 -0.00 % 8000 - Non-Cap Equip (< 5K)5,635 951 836 10,000 10,000 10,000 -0.00 % 9000.101 - Allocations - Information Technology 41,369 41,369 28,407 42,610 43,888 45,205 1,278 3.00 % 9000.102 - Allocations - Facilities Management 7,920 7,920 5,439 8,158 8,403 8,655 245 3.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Administrative Services - Communication Services Page 15 20 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 9000.110 - Allocations - Risk Mgmt - OH, Premium 1,013 2,176 587 880 1,569 1,596 689 78.30 % 9900 - Miscellaneous -224 -----0.00 % Total $516,762 $543,519 $370,503 $645,850 $650,547 $683,821 $4,697 .73 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Administrative Services - Communication Services Page 16 21 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4100.200 - Licenses - Tobacco $9,900 $10,575 $425 $10,500 $10,500 $10,500 -0.00 % 4100.500 - Licenses - Liquor 236,623 118,061 179,265 234,620 234,620 234,620 -0.00 % 4100.740 - Licenses - Target & Trap Shooting 110 110 -110 110 110 -0.00 % 4100.750 - Licenses - Fireworks 100 1,100 1,200 1,000 1,000 1,000 -0.00 % 4100.800 - Licenses - Amusement 300 300 (300)450 --(450)(100.00 %) 4100.850 - Licenses - Peddler 17,370 4,200 11,340 13,000 13,000 13,000 -0.00 % 4100.900 - Licenses - Massage 15,179 14,168 12,869 15,000 15,000 15,000 -0.00 % 4200 - Intergovern- Federal - Operating -73,362 -----0.00 % 4230 - Intergovern-State-Operating -33,175 -----0.00 % 4800 - Other Revenues -25 -----0.00 % 4807 - Refunds & Reimbursements 2,083 --1,900 -3,800 (1,900)(100.00 %)2023: Reimbursement for use of election equipment 4900.100 - Transfers In - General -27,218 -----0.00 % 4900.660 - Transfers In - Resource Planning -53,000 --53,000 -53,000 100.00 % Total $281,665 $335,293 $204,799 $276,580 $327,230 $278,030 $50,650 18.31 % Expenses 6000 - Salaries $1,482 $8,970 -----0.00 % 6000.100 - Salaries - Regular 286,191 299,350 190,691 305,602 313,606 322,020 8,004 2.62 % 6000.200 - Salaries - Temporary 3,312 123,067 -5,037 130,830 1,500 125,793 2,497.38 % 6020.100 - Overtime/Comp Time -17,787 --5,000 -5,000 100.00 % 6030.100 - Other Pay - Comp Time (185)------0.00 % 6050 - Benefits 197 1,359 -----0.00 % 6050.100 - Benefits - Social Security 18,084 22,342 11,707 19,333 27,267 20,134 7,934 41.04 % 6050.101 - Benefits - Medicare 4,229 5,225 2,738 4,520 6,535 4,708 2,015 44.58 % 6050.200 - Benefits - PERA 21,464 23,785 14,302 23,184 23,894 24,150 710 3.06 % 6050.550 - Benefits - Cell Phone Allowance 1,205 1,160 680 1,200 1,200 1,200 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 36,346 36,142 48,959 38,802 41,028 44,031 2,226 5.74 % 6070.100 - Dental Insurance - Employer Contribution 4,190 3,867 2,500 4,201 4,201 4,411 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 615 626 372 726 740 751 14 1.93 % 6100 - Office Supplies 361 25,206 88 500 7,500 500 7,000 1,400.00 %2023: Election supplies 6500.100 - Employee Development - Training 4,599 -955 4,000 4,000 4,000 -0.00 % 6550 - Mileage & Parking Reimbursement 226 -53 200 300 200 100 50.00 % 6600 - Meetings -2,399 --2,000 -2,000 100.00 % 6700 - Dues & Subscriptions 4,516 21,886 3,557 19,300 19,300 19,300 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Administrative Services - City Clerk Page 17 22 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6700.109 - Dues & Subscriptions - Software 13,000 6,542 2,034 -6,500 6,500 6,500 100.00 % 7000 - Professional Services -15,000 --35,000 -35,000 100.00 %2023: Additional $20,000 for Redistricting 7013 - Record Retention 2,503 --5,000 5,000 5,000 -0.00 % 7100.100 - Communications - Postage 134 5,428 186 -10,500 -10,500 100.00 % 7200 - Printing & Publishing 3,342 5,041 -100 6,100 100 6,000 6,000.00 % 7500.202 - Repair & Maint Services - Equipment Maint 9,722 10,235 11,542 11,000 11,000 --0.00 % 7600 - Rentals -13,149 --8,000 -8,000 100.00 %2022: Polling locations, tent for ballot drop-off, signage 8000 - Non-Cap Equip (< 5K)--1,363 ----0.00 % 9000.101 - Allocations - Information Technology 73,903 73,903 50,747 76,120 78,404 80,756 2,284 3.00 % 9000.102 - Allocations - Facilities Management 5,739 5,739 3,941 5,911 6,088 6,271 177 2.99 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 2,134 3,087 691 1,036 1,978 2,013 942 90.93 % 9000.111 - Allocations - Risk Mgmt - Claims 451 ------0.00 % 9500.620 - Transfers Out - Information Technology --982 ----0.00 % 9500.660 - Transfers Out - Resource Planning 51,000 -53,000 53,000 -53,000 (53,000)(100.00 %) 9920.100 - Bank Fees - Credit Card 510 507 221 500 500 500 -0.00 % 9920.150 - Bank Fees - PSN --1 ----0.00 % 9925 - Recognition Events 1,271 --1,500 1,500 1,500 -0.00 % Total $550,541 $731,801 $401,309 $580,772 $757,971 $602,545 $177,199 30.51 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Administrative Services - City Clerk Page 18 23 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$482 $18 ----0.00 % 4500.200 - Special Assessments - County Fees 8,539 6,713 -10,000 10,000 10,000 -0.00 % 4700.200 - Interest Income - Special Assessments -634 -400 500 500 100 25.00 % 4800 - Other Revenues 3,181 4,700 1,533 2,000 2,000 2,000 -0.00 % 4801 - Administrative Fee 77 10,150 1 12,500 12,500 12,500 -0.00 % 4900.100 - Transfers In - General -13 -----0.00 % Total $11,797 $22,692 $1,552 $24,900 $25,000 $25,000 $100 .40 % Expenses 6000 - Salaries $10,024 $7,490 -----0.00 % 6000.100 - Salaries - Regular 692,340 628,010 441,139 768,969 770,046 806,030 1,077 .14 % 6000.200 - Salaries - Temporary 9,444 39,107 37,371 13,941 22,310 22,980 8,369 60.03 % 6020.100 - Overtime/Comp Time 1,190 1,903 2,351 1,500 1,500 1,500 -0.00 % 6030.100 - Other Pay - Comp Time 26 ------0.00 % 6050 - Benefits 1,522 1,135 -----0.00 % 6050.100 - Benefits - Social Security 41,524 39,681 28,327 47,801 49,292 50,968 1,491 3.12 % 6050.101 - Benefits - Medicare 9,711 9,280 6,625 11,391 11,528 12,060 137 1.20 % 6050.200 - Benefits - PERA 52,646 50,127 34,737 58,831 59,540 62,290 709 1.21 % 6050.550 - Benefits - Cell Phone Allowance 1,205 1,160 580 1,200 1,200 1,200 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 83,342 72,471 54,413 101,740 125,318 137,427 23,578 23.17 % 6070.100 - Dental Insurance - Employer Contribution 6,666 5,799 3,833 7,560 7,981 8,380 421 5.57 % 6080.100 - Group Life Insurance - Employer Contribution 1,520 1,267 893 1,899 1,868 1,926 (31)(1.63 %) 6100 - Office Supplies 1,568 2,739 231 2,500 2,500 2,500 -0.00 % 6500 - Employee Development 298 ------0.00 % 6500.100 - Employee Development - Training 3,164 1,275 385 4,000 4,000 4,000 -0.00 % 6550 - Mileage & Parking Reimbursement 139 99 23 100 100 100 -0.00 % 6700 - Dues & Subscriptions 945 838 210 1,200 1,200 1,200 -0.00 % 7000 - Professional Services 12,840 22,705 5,594 10,000 10,000 10,000 -0.00 % 7004 - Audit Fees 28,208 28,352 28,885 30,000 30,000 30,000 -0.00 % 7100.100 - Communications - Postage 10,251 8,516 3,830 10,500 10,500 10,500 -0.00 % 7200 - Printing & Publishing 4,111 3,779 1,112 5,000 5,000 5,000 -0.00 % 7200.102 - Printing & Publishing - Truth In Taxation Notices 5,743 5,834 -5,800 5,800 5,800 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Administrative Services - Finance Page 19 24 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7500.201 - Repair & Maint Services - Departmental Software Maint 102 291 -----0.00 % 7500.202 - Repair & Maint Services - Equipment Maint 461 395 450 500 500 500 -0.00 % 8000 - Non-Cap Equip (< 5K)1,520 1,568 456 ----0.00 % 9000.101 - Allocations - Information Technology 115,716 115,716 79,458 119,187 122,763 126,446 3,576 3.00 % 9000.102 - Allocations - Facilities Management 29,804 29,804 20,465 30,698 31,619 32,568 921 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 2,823 5,747 1,214 1,821 3,077 3,135 1,256 68.97 % 9900 - Miscellaneous 18 146 -----0.00 % 9900.100 - Miscellaneous - Cash Over/Short 22 1 5 ----0.00 % 9913 - Licenses, Permits & Registrations 275 1,277 1,104 ----0.00 % 9919 - Administration Fees 7,728 6,625 5,429 10,000 10,000 10,000 -0.00 % 9920.100 - Bank Fees - Credit Card 1 677 -25 25 25 -0.00 % Total $1,136,894 $1,093,813 $759,121 $1,246,163 $1,287,667 $1,346,535 $41,504 3.33 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Administrative Services - Finance Page 20 25 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7000 - Professional Services $1,323,771 $1,365,833 $95,833 $1,150,000 $1,200,000 $1,250,000 $50,000 4.35 % 7100.100 - Communications - Postage 402 380 132 1,000 1,000 1,000 -0.00 % 7500.200 - Repair & Maint Services - Software 61 55 10 200 200 200 -0.00 % 9000.101 - Allocations - Information Technology 10,525 10,525 7,227 10,841 11,166 11,501 325 3.00 % 9000.102 - Allocations - Facilities Management 11,478 11,478 7,881 11,822 12,177 12,542 355 3.00 % Total $1,346,237 $1,388,272 $111,085 $1,173,863 $1,224,543 $1,275,243 $50,680 4.32 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Administrative Services - Assessing Page 21 26 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4100.860 - Licenses - Sign Contractor $2,250 $2,475 $1,950 $3,000 $3,100 $3,100 $100 3.33 % Total $2,250 $2,475 $1,950 $3,000 $3,100 $3,100 $100 3.33 % Expenses 6000 - Salaries $2,685 $4,622 -----0.00 % 6000.100 - Salaries - Regular 336,338 364,543 237,933 372,287 381,994 392,043 9,707 2.61 % 6030.100 - Other Pay - Comp Time 182 ------0.00 % 6050 - Benefits 434 700 -----0.00 % 6050.100 - Benefits - Social Security 19,895 21,364 14,351 21,943 22,438 22,935 495 2.26 % 6050.101 - Benefits - Medicare 4,809 5,194 3,356 5,412 5,551 5,697 139 2.57 % 6050.200 - Benefits - PERA 25,225 27,201 17,845 27,922 28,651 29,402 729 2.61 % 6050.550 - Benefits - Cell Phone Allowance 482 464 312 480 480 480 -0.00 % 6050.570 - Benefits - Car Allowance 482 464 312 480 480 480 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 41,720 42,286 30,854 47,382 52,106 56,385 4,724 9.97 % 6070.100 - Dental Insurance - Employer Contribution 3,765 3,501 2,354 3,803 3,803 3,993 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 653 663 425 723 741 745 18 2.49 % 6100 - Office Supplies 1,227 930 584 1,250 1,250 1,250 -0.00 % 6500.100 - Employee Development - Training 22 32 -1,500 --(1,500)(100.00 %) 6700 - Dues & Subscriptions 140 --125 -125 (125)(100.00 %)2023: Notary renewal 7000 - Professional Services 210 ------0.00 % 7200 - Printing & Publishing 97 --50 -50 (50)(100.00 %)2023: Notary renewal 7500.201 - Repair & Maint Services - Departmental Software Maint --68 ----0.00 % 9000.101 - Allocations - Information Technology 56,099 56,099 38,521 57,782 59,515 61,300 1,733 3.00 % 9000.102 - Allocations - Facilities Management 12,442 12,442 8,543 12,815 13,199 13,595 384 3.00 % 9000.107 - Allocations - Central Equipment 1,608 1,608 1,104 1,656 1,706 1,757 50 3.02 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 1,490 3,485 773 1,160 1,814 1,846 654 56.38 % 9000.111 - Allocations - Risk Mgmt - Claims 206 ------0.00 % 9900.100 - Miscellaneous - Cash Over/Short -(100)(50)----0.00 % 9920.100 - Bank Fees - Credit Card 3 32 -----0.00 % Total $510,216 $545,531 $357,287 $556,770 $573,728 $592,083 $16,958 3.05 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Community Development - CD Administration and Support Page 22 27 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4150.950 - Permits - Chickens --$800 ----0.00 % 4200 - Intergovern- Federal - Operating -3,416 -----0.00 % 4350.100 - General Services - Photocopies 12 ------0.00 % 4350.101 - General Services - Maps & Ordinances 55 ------0.00 % 4350.123 - General Services - Application Fees 26,070 18,740 25,480 25,000 25,000 25,000 -0.00 % 4350.130 - General Services - Development Sign Fee 545 2,380 3,470 ----0.00 % 4355 - Developer Fees -70,924 27,360 35,000 30,000 30,000 (5,000)(14.29 %) 4360.116 - Items for Resale - Buffer Signs 606 1,222 136 ----0.00 % 4800 - Other Revenues -5,536 2,734 ----0.00 % 4801 - Administrative Fee 34,510 ------0.00 % 4900.100 - Transfers In - General -11 -----0.00 % Total $61,798 $102,230 $59,981 $60,000 $55,000 $55,000 ($5,000)(8.33 %) Expenses 6000 - Salaries $4,250 ($22,597)-----0.00 % 6000.100 - Salaries - Regular 478,662 468,430 238,270 502,396 498,470 518,118 (3,926)(.78 %) 6000.200 - Salaries - Temporary 7,466 ------0.00 % 6020.100 - Overtime/Comp Time 2,669 4,048 6,245 8,000 8,000 8,000 -0.00 % 6030.100 - Other Pay - Comp Time 3,232 ------0.00 % 6050 - Benefits 644 (3,423)-----0.00 % 6050.100 - Benefits - Social Security 27,870 27,088 13,939 29,675 30,156 30,725 481 1.62 % 6050.101 - Benefits - Medicare 6,674 6,532 3,260 7,415 7,358 7,642 (57)(.77 %) 6050.200 - Benefits - PERA 36,424 34,920 18,274 38,279 37,986 39,458 (293)(.77 %) 6050.550 - Benefits - Cell Phone Allowance 482 464 312 480 480 480 -0.00 % 6050.570 - Benefits - Car Allowance 482 464 312 480 480 480 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 55,574 44,997 26,279 53,351 68,014 75,805 14,663 27.48 % 6070.100 - Dental Insurance - Employer Contribution 457 1,441 780 1,681 2,520 2,646 839 49.91 % 6080.100 - Group Life Insurance - Employer Contribution 871 767 292 1,006 963 994 (43)(4.27 %) 6100 - Office Supplies 1,223 18 -1,000 1,000 1,000 -0.00 % 6500 - Employee Development 165 ------0.00 % 6500.100 - Employee Development - Training 5,165 4,237 657 7,000 7,000 7,000 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Community Development - Planning Page 23 28 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6550 - Mileage & Parking Reimbursement ---100 100 100 -0.00 % 6700 - Dues & Subscriptions 3,296 3,537 374 3,500 3,500 3,500 -0.00 % 7000 - Professional Services 3,669 60,446 8,775 10,000 10,000 10,000 -0.00 % 7100.100 - Communications - Postage 2,253 2,435 1,874 2,500 2,500 2,500 -0.00 % 7200 - Printing & Publishing 1,794 1,226 1,279 2,000 2,000 2,000 -0.00 % 9000.101 - Allocations - Information Technology 38,730 38,730 26,595 39,892 41,089 42,322 1,197 3.00 % 9000.102 - Allocations - Facilities Management 22,911 22,911 15,732 23,598 24,306 25,035 708 3.00 % 9000.107 - Allocations - Central Equipment 4,824 4,824 3,313 4,969 5,118 5,272 149 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 1,394 3,142 753 1,129 1,367 1,390 238 21.08 % 9500.660 - Transfers Out - Resource Planning 15,000 15,000 15,000 15,000 15,000 15,000 -0.00 % 9920.100 - Bank Fees - Credit Card 31 2 1 100 100 50 -0.00 % Total $726,212 $719,638 $382,315 $753,551 $767,507 $799,517 $13,956 1.85 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Community Development - Planning Page 24 29 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4100.700 - Licenses - Rental Dwelling $159,220 $140,985 $71,315 $150,000 $150,000 $150,000 -0.00 % 4150 - Permits 1,678 388 60 5,000 5,000 5,000 -0.00 % 4150.100 - Permits - Building 2,186,152 1,910,204 1,222,632 1,575,000 1,575,000 1,575,000 -0.00 % 4150.200 - Permits - Plumbing 341,649 287,811 302,886 237,500 237,500 237,500 -0.00 % 4150.300 - Permits - Mechanical Permits 437,049 354,045 234,927 285,000 285,000 285,000 -0.00 % 4150.350 - Permits - Electrical 362,361 261,525 179,622 299,250 299,250 299,250 -0.00 % 4150.410 - Permits - Water/Sewer 48,229 35,182 17,064 32,400 32,400 32,400 -0.00 % 4150.500 - Permits - Fire Protection 88,814 58,431 27,611 80,000 65,000 65,000 (15,000)(18.75 %) 4150.600 - Permits - Plan Checking 1,026,916 725,935 445,762 747,000 747,000 747,000 -0.00 % 4150.700 - Permits - Sign & Billboard 10,890 8,090 5,790 9,000 9,000 9,000 -0.00 % 4200 - Intergovern- Federal - Operating -3,584 -----0.00 % 4270 - Intergovern-Local-Operating -3,479 5,889 ----0.00 % 4800 - Other Revenues 3,088 2,526 1,581 2,000 2,000 2,000 -0.00 % Total $4,666,047 $3,792,186 $2,515,140 $3,422,150 $3,407,150 $3,407,150 ($15,000)(.44 %) Expenses 6000 - Salaries $12,028 $2,652 -----0.00 %2022: Temp salaries: electrical inspector 6000.100 - Salaries - Regular 880,083 897,277 547,287 939,669 969,856 1,004,916 30,187 3.21 % 6000.200 - Salaries - Temporary 15,893 11,502 2,732 12,485 15,000 15,445 2,515 20.14 % 6020.100 - Overtime/Comp Time --458 ----0.00 % 6050 - Benefits 1,822 402 -----0.00 % 6050.100 - Benefits - Social Security 54,226 54,832 33,018 58,687 60,353 62,117 1,666 2.84 % 6050.101 - Benefits - Medicare 12,682 12,824 7,722 13,836 14,322 14,833 486 3.51 % 6050.200 - Benefits - PERA 66,196 66,529 41,169 71,414 73,863 76,526 2,449 3.43 % 6050.550 - Benefits - Cell Phone Allowance 2,169 2,196 1,716 2,160 2,640 2,640 480 22.22 % 6060.100 - Medical Insurance - Employer Contribution 132,944 111,442 73,008 123,742 142,840 156,713 19,098 15.43 % 6070.100 - Dental Insurance - Employer Contribution 7,242 6,382 3,122 7,563 6,303 6,618 (1,260)(16.66 %) 6080.100 - Group Life Insurance - Employer Contribution 1,113 1,123 687 1,313 1,360 1,379 47 3.58 % 6100 - Office Supplies 1,092 1,393 200 2,500 2,500 2,500 -0.00 % 6120.102 - Operating Supplies - Motor Fuels & Lubricants -228 -----0.00 % 6140 - Miscellaneous Supplies -155 -----0.00 % 6140.101 - Miscellaneous Supplies - Clothing -1,644 163 1,000 1,750 1,750 750 75.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Community Development - Inspections Page 25 30 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6140.102 - Miscellaneous Supplies - Safety Equipment 180 321 64 400 400 400 -0.00 % 6500.100 - Employee Development - Training 2,231 5,499 1,805 8,500 10,975 10,975 2,475 29.12 %2022: Same training amount as 2020. Add $2,500 for Building Official ICC National Conference (See 2019). 2023: Same training amount as 2021. Add $2,500 for Building Official ICC National Conference (See 2019). 6550 - Mileage & Parking Reimbursement 63 ------0.00 % 6700 - Dues & Subscriptions 840 990 73 1,500 1,500 1,500 -0.00 % 7000 - Professional Services 4,596 128 --200 -200 100.00 %2022: Add computer mount to 4008. 7010 - Contractual Plan Checking 2,000 ------0.00 % 7100.100 - Communications - Postage 5,378 2,202 1,278 6,000 3,000 3,000 (3,000)(50.00 %) 7200 - Printing & Publishing 126 5,462 -3,150 3,650 3,650 500 15.87 % 7500.201 - Repair & Maint Services - Departmental Software Maint -62 -----0.00 % 7500.202 - Repair & Maint Services - Equipment Maint -232 -----0.00 % 8000 - Non-Cap Equip (< 5K)1,727 1,767 107 400 400 400 -0.00 % 9000.101 - Allocations - Information Technology 93,121 93,121 63,943 95,914 82,369 84,840 (13,545)(14.12 %) 9000.102 - Allocations - Facilities Management 29,842 29,842 20,491 30,737 27,276 28,094 (3,461)(11.26 %) 9000.107 - Allocations - Central Equipment 62,553 62,553 42,953 64,430 46,185 47,570 (18,245)(28.32 %) 9000.110 - Allocations - Risk Mgmt - OH, Premium 5,930 8,055 2,739 4,109 4,135 4,198 26 .63 % 9000.111 - Allocations - Risk Mgmt - Claims 281 8,841 1,888 2,832 --(2,832)(100.00 %) 9900 - Miscellaneous 21 ------0.00 % 9900.100 - Miscellaneous - Cash Over/Short -------0.00 % 9917 - Bad Debt -166 -----0.00 % 9920.100 - Bank Fees - Credit Card 31,203 74,993 36,431 50,000 75,000 75,000 25,000 50.00 % 9920.150 - Bank Fees - PSN 374 164 62 450 400 400 (50)(11.11 %) Total $1,427,957 $1,464,976 $883,116 $1,502,791 $1,546,277 $1,605,464 $43,486 2.89 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Community Development - Inspections Page 26 31 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$4,532 -----0.00 % 4600 - Contributions - Operating 975 --1,200 1,300 1,300 100 8.33 % Total $975 $4,532 -$1,200 $1,300 $1,300 $100 8.33 % Expenses 6000 - Salaries $7,648 $3,330 -----0.00 %2022: Temp salaries: market adj (offset by revenue) and 1/3 of temp program coordinator position 6000.100 - Salaries - Regular 400,373 414,955 268,905 423,536 433,899 447,159 10,363 2.45 % 6000.200 - Salaries - Temporary 7,761 9,064 5,019 8,323 15,350 15,811 7,027 84.43 % 6050 - Benefits 1,159 504 -----0.00 % 6050.100 - Benefits - Social Security 23,772 24,429 17,149 23,458 24,139 24,523 681 2.90 % 6050.101 - Benefits - Medicare 5,943 6,183 4,011 6,314 6,565 6,763 251 3.98 % 6050.200 - Benefits - PERA 30,610 31,800 20,464 32,390 33,693 34,724 1,303 4.02 % 6050.550 - Benefits - Cell Phone Allowance 2,350 2,262 1,491 2,340 2,340 2,340 -0.00 % 6050.560 - Benefits - IPAD allowance 440 ------0.00 % 6050.570 - Benefits - Car Allowance 1,205 1,160 780 1,200 1,200 1,200 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 38,172 40,518 27,938 43,649 46,735 50,652 3,086 7.07 % 6070.100 - Dental Insurance - Employer Contribution 2,423 2,284 1,536 2,481 2,670 2,802 189 7.62 % 6080.100 - Group Life Insurance - Employer Contribution 1,039 1,065 678 1,175 1,183 1,192 8 .68 % 6100 - Office Supplies 2,316 2,992 1,544 2,400 2,800 2,900 400 16.67 %2022: 2019 actual $2300- Increase added for additional staff 6120 - Operating Supplies 3,262 10,177 485 3,100 4,200 4,700 1,100 35.48 %2022: 2019 actual $2300-Increase for additional department supplies -------------------- 2022: Volunteer program supplies 2023: Volunteer program supplies 6140.101 - Miscellaneous Supplies - Clothing ---50 100 100 50 100.00 % 6500.100 - Employee Development - Training 3,139 2,221 -4,300 700 700 (3,600)(83.72 %) 6550 - Mileage & Parking Reimbursement 93 9 -100 75 75 (25)(25.00 %) 6600 - Meetings 160 ------0.00 % 6700 - Dues & Subscriptions 2,366 2,016 831 2,400 2,450 2,450 50 2.08 %2022: 2019 actual $2300-Movie and Music License, MRPA Membership 2023: Movie and Music License, MRPA Membership -------------------- 2022: Dues for professional organization 2023: Dues for professional organization 7000 - Professional Services 13,988 10,201 1,170 16,300 17,300 17,300 1,000 6.13 %2022: 2019 actual $12,000-Consultants 2023: Consultants 7100.100 - Communications - Postage 565 262 346 600 7,700 7,700 7,100 1,183.33 %2022: Increase to support additional staff attending MRPA conference City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Parks & Rec Admin Page 27 32 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7200 - Printing & Publishing 41 -256 ----0.00 % 8000 - Non-Cap Equip (< 5K)1,236 1,480 -----0.00 % 9000.101 - Allocations - Information Technology 34,608 34,608 23,764 35,646 36,716 37,817 1,070 3.00 % 9000.102 - Allocations - Facilities Management 41,281 41,281 28,346 42,519 43,795 45,108 1,276 3.00 % 9000.107 - Allocations - Central Equipment 6,837 6,837 4,695 7,042 7,253 7,471 211 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 1,408 2,762 655 982 1,516 1,543 534 54.38 % 9500.620 - Transfers Out - Information Technology --132 ----0.00 % 9904 - Real Estate Taxes 1 ------0.00 % 9925 - Recognition Events 7,285 2,844 -7,500 7,500 7,500 -0.00 %2022: Volunteer Recognition Event 2023: Volunteer Recognition Event Total $641,481 $655,244 $410,195 $667,805 $699,879 $722,530 $32,074 4.80 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Parks & Rec Admin Page 28 33 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4150 - Permits $100 $100 $125 -$100 $100 $100 100.00 % 4200 - Intergovern- Federal - Operating -437,998 3,543 ----0.00 % 4320 - Rental Fees 102,016 60,019 300 103,000 73,000 73,000 (30,000)(29.13 %)2022: 30K reduction of assn cost recovery fees due to termination of school district JPA 2023: 30K reduction of assn cost recovery fees due to termination of school district JPA 4350.106 - General Services - Weeds 1,936 2,599 750 1,500 2,000 2,000 500 33.33 %2022: Forced cuts noxious and invasives 2023: Forced cuts noxious and invasives 4350.107 - General Services - Tree Removal 2,784 2,966 900 5,000 5,000 5,000 -0.00 %2022: Forced cuts & impending EAB 2023: Forced cuts & impending EAB 4600 - Contributions - Operating 750 ------0.00 % 4800 - Other Revenues 222 ------0.00 % 4801 - Administrative Fee 1,329 200 600 1,000 1,000 1,000 -0.00 % 4807 - Refunds & Reimbursements 3,046 2,425 419 2,000 2,500 2,500 500 25.00 % 4807.103-Refunds & Reimbursements-Utility Reimbursement 1,715 1,308 1,663 1,500 1,500 1,500 -0.00 % 4900.100 - Transfers In - General -102,164 -----0.00 % 4900.400 - Transfers In - General Capital Projects --101,230 ----0.00 % Total $113,899 $609,778 $109,530 $114,000 $85,100 $85,100 ($28,900)(25.35 %) Expenses 6000 - Salaries $9,618 $9,315 -----0.00 %2022: Regular salaries: reclass for proj coord and new .5 FTE for mtce worker to make split position full-time. OT/comp: increase due to new union contract provision. 6000.100 - Salaries - Regular 1,603,612 1,705,109 1,098,220 1,752,157 1,822,780 1,891,312 70,623 4.03 % 6000.200 - Salaries - Temporary 283,943 190,507 160,468 341,700 330,670 337,960 (11,030)(3.23 %) 6020.100 - Overtime/Comp Time 48,055 25,481 21,423 37,000 42,000 42,000 5,000 13.51 % 6030.100 - Other Pay - Comp Time 1,042 ------0.00 % 6030.200 - Other Pay - Premium Pay 3,250 1,750 940 4,000 4,000 4,000 -0.00 % 6030.300 - Other Pay - Equipment Pay 355 398 214 500 500 500 -0.00 % 6050 - Benefits 1,455 1,411 -----0.00 % 6050.100 - Benefits - Social Security 116,939 116,122 77,658 132,558 136,491 141,092 3,933 2.97 % 6050.101 - Benefits - Medicare 27,349 27,158 18,162 31,083 32,024 33,122 941 3.03 % 6050.200 - Benefits - PERA 139,876 134,975 88,587 160,147 160,360 165,901 213 .13 % 6050.302 - Benefits - Unemployment 23,843 16,099 -30,000 30,000 30,000 -0.00 % 6050.550 - Benefits - Cell Phone Allowance 8,535 8,454 5,329 8,508 8,748 8,748 240 2.82 % 6050.560 - Benefits - IPAD allowance 110 ------0.00 % 6060.100 - Medical Insurance - Employer Contribution 253,780 252,552 162,794 277,567 286,183 313,321 8,616 3.10 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Parks & Forestry Page 29 34 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6070.100 - Dental Insurance - Employer Contribution 13,247 13,281 8,711 14,290 15,361 16,128 1,071 7.49 % 6080.100 - Group Life Insurance - Employer Contribution 2,672 2,761 1,727 2,961 3,065 3,101 104 3.51 % 6100 - Office Supplies 1,278 1,021 445 2,200 1,500 1,500 (700)(31.82 %)2022: $700 reduction 6120 - Operating Supplies 168,663 176,982 69,027 174,000 170,000 175,000 (4,000)(2.30 %)2022: Tools, hardware, tables, aglime, nets, paint, general maintenance supplies. JPA cuts 2023: Tools, hardware, tables, aglime, nets, paint, general maintenance supplies. 6120.102 - Operating Supplies - Motor Fuels & Lubricants 1,460 1,182 -----0.00 % 6120.103 - Operating Supplies - Janitorial -321 -----0.00 % 6120.108 - Operating Supplies - Twin City Tree Trust 3,473 6,936 2,986 6,000 6,000 6,000 -0.00 %2022: Youth work program 2023: Youth work program 6130 - Repair & Maint Supplies -360 -----0.00 % 6130.101 - Repair & Maint Supplies - Horticulture 77,267 86,577 36,292 85,000 87,000 91,000 2,000 2.35 %2022: Plants, fertilizer, grass, sod, irrigation repairs, soils. JPA cuts 2023: Plants, fertilizer, grass, sod, irrigation repairs, soils 6130.102 - Repair & Maint Supplies - Traffic & Park Signs 7,114 12,677 3,682 8,000 7,000 7,500 (1,000)(12.50 %)2022: $1K reduction. Boundary markers, park and trail signs, wayfinding signage 2023: Boundary markers, park and trail signs, wayfinding signage 6130.103 - Repair & Maint Supplies - Invasive Control 97,223 34,513 20,921 73,000 30,000 31,000 (43,000)(58.90 %)2022: $25K EAB treatments, $5k general invasive treatments. $48k ICWC 2 day crew re-coded to 7000 2023: $25K EAB treatments, $6K general invasive treatments. 6130.107 - Repair & Maint Supplies - Concrete & Asphalt 66,626 118,918 43,531 103,000 --(103,000)(100.00 %)2022: $103K moved to 7500.107 6130.118 - Repair & Maint Supplies - Playstructure Repair Parts 20,534 28,636 7,307 25,000 26,000 27,000 1,000 4.00 %2022: Playground parts, engineered wood fiber 2023: Playground parts, engineered wood fiber 6140.101 - Miscellaneous Supplies - Clothing 381 2,383 118 1,800 1,800 1,800 -0.00 %2022: High visibility shirts in lieu of uniform shirts 2023: High visibility shirts in lieu of uniform shirts 6140.102 - Miscellaneous Supplies - Safety Equipment 15,297 16,992 5,537 13,000 14,000 15,000 1,000 7.69 %2022: Personal protection equipment. Glasses, helmets, chaps, vests, hearing protection 2023: Personal protection equipment. Glasses, helmets, chaps, vests, hearing protection 6500.100 - Employee Development - Training 13,218 3,035 3,194 13,000 15,000 16,000 2,000 15.38 %2022: Safety training, education, certifications, professional conferences for 26 staff 2023: Safety training, education, certifications, professional conferences for 26 staff 6550 - Mileage & Parking Reimbursement 18 --250 250 250 -0.00 % 6600 - Meetings 328 20 35 500 500 500 -0.00 %2022: Volunteer refreshments, annual team safety meeting 2023: Volunteer, refreshments, annual team safety meeting 6700 - Dues & Subscriptions 1,084 1,034 448 1,500 1,600 1,600 100 6.67 %2022: Association membership fees 2023: Association membership fees City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Parks & Forestry Page 30 35 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6700.109 - Dues & Subscriptions - Software --3,658 -2,500 2,700 2,500 100.00 %2022: Robot athletic field painter software update fees 2023: Robot athletic field painter software update fees 7000 - Professional Services 107,781 96,645 63,380 80,000 131,000 133,000 51,000 63.75 %2022: ICWC 4 day crew (trees), ICWC 2 day crew (invasives), Cartegraph, boundary survey crews, architects. +48k ICWC 2 day moved from 6130.103 2023: ICWC 4 day crew (trees), ICWC 2 day crew (invasives), Cartegraph, boundary survey crews, architects. 7016 - Animal Control 9,010 4,955 5,621 8,000 9,000 10,000 1,000 12.50 %2022: USDA & DNR wildlife control 2023: USDA & DNR wildlife control 7017 - Laundered Uniforms 3,514 4,044 2,542 4,200 4,500 4,500 300 7.14 %2022: Uniform laundry service 2023: Uniform laundry service 7100.100 - Communications - Postage 296 725 307 1,000 1,000 1,000 -0.00 % 7100.102 - Communications - Data Communications 2,426 435 695 ----0.00 % 7100.104 - Communications - Mobile Telephone -2,370 4,550 ----0.00 % 7200 - Printing & Publishing 266 48 467 400 400 400 -0.00 %2022: Brochures, ads 2023: Brochures, ads 7400.102 - Utilities - Natural Gas 16,718 16,376 10,809 20,000 21,000 22,000 1,000 5.00 % 7400.103 - Utilities - Water & Sewer 65,340 82,353 42,983 73,000 73,000 76,000 -0.00 %2022: Budget remains the same due to discontinued JPA with the school district 7400.104 - Utilities - Solid Waste 22,212 25,685 13,975 25,000 25,000 27,000 -0.00 %2022: Budget remains the same due to discontinued JPA with the school district 7400.108 - Utilities - Electric 152,740 137,635 83,222 156,000 145,000 148,000 (11,000)(7.05 %)2022: Budget reduced due to discontinued JPA with the school district 7500 - Repair & Maint Services 59,420 39,947 13,160 55,000 57,000 58,000 2,000 3.64 %2022: Contracted plumbing, irrigation, fountains, painting, other skilled trades 2023: Contracted plumbing, irrigation, fountains, painting, other skilled trades 7500.101 - Repair & Maint Services - Lawn Maint 138,375 140,934 122,811 143,000 115,000 118,000 (28,000)(19.58 %)2022: $28K reduction with JPA. Contracted mowing services, and turfgrass management 2023: Contracted mowing services and turfgrass management 7500.102 - Repair & Maint Services - Weed Control 55,100 115,062 48,078 84,000 86,000 89,000 2,000 2.38 %2022: Contracted aquatic weed control, rough cut mowing, forced weeds, invasives, native areas, prairies, wetlands 2023: Contracted aquatic weed control, rough cut mowing, forced weeds, invasives, native areas, prairies, wetlands 7500.104 - Repair & Maint Services - Electrical 24,832 30,913 4,308 20,000 30,000 31,000 10,000 50.00 %2022: $10K increase due to aging electrical systems and increased repairs & maintenance. Contracted electrical services for scoreboards, lights, athletic field transformers 2023: Contracted electrical services for scoreboards, lights, athletic field transformers City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Parks & Forestry Page 31 36 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7500.107 - Repair & Maint Services - Asphalt/Concrete 27,235 --22,000 203,000 211,000 181,000 822.73 %2022: Crack sealing and fog sealing parking lots, sport court repairs and refurbishing, trail patching and repairs, concrete curbs and flat work, sand, conbit, base materials. $103K from 6130.107 $72K from 7500.109 2023: Crack sealing and fog sealing parking lots, sport court repairs and refurbishing, trail patching and repairs, concrete curbs and flat work, sand, conbit, base materials. 7500.109 - Repair & Maint Services - Seal Coating 62,425 8,841 13,100 72,000 --(72,000)(100.00 %)2022: $72K re-coded to 7500.107 7500.114 - Repair & Maint Services - Retaining Walls/Guard Rails/Fence 21,360 25,126 6,672 32,000 33,000 34,000 1,000 3.13 % 7500.130 - Repair & Maint Services - Building Maint 32,913 171,207 27,301 22,500 32,000 32,000 9,500 42.22 %2022: Contract windows, doors, HVAC, interior building systems 2023: Contract windows, doors, HVAC, interior building systems 7500.135 - Repair & Maint Services - Building Security 48 ------0.00 % 7500.143 - Repair & Maint Services - Median Maint 27,930 29,876 29,642 25,000 26,000 27,000 1,000 4.00 %2022: Contract mowing, weed control, plants, traffic control 2023: Contract mowing, weed control, plants, traffic control 7500.200 - Repair & Maint Services - Software 2,840 ------0.00 % 7500.201 - Repair & Maint Services - Departmental Software Maint -630 -----0.00 % 7500.202 - Repair & Maint Services - Equipment Maint 2,290 3,976 -----0.00 % 7500.300 - Repair & Maint Services - Tree Maintenance 147,612 135,760 109,862 145,000 150,000 154,000 5,000 3.45 %2022: Contract tree maintenance - impending EAB 2023: Contract tree maintenance 7500.302 - Repair & Maint Services - Forced Tree Removal 6,316 1,810 -10,000 10,000 10,000 -0.00 %2022: Contract forced tree removals, EAB 2023: Contract forced tree removals, EAB 7500.304 - Repair & Maint Services - Tree Grinding 10,000 13,700 -10,000 15,000 17,000 5,000 50.00 %2022: Park & blvd. tree grinding contribution for yard waste 2023: Park & blvd. tree grinding contribution for yard waste 7600 - Rentals 1,109 443 119 3,000 23,000 24,000 20,000 666.67 %2022: $3K specialty equipment rental. $20K front end loader rental for snow removal (Lots, PCC larger lot & trails) 2023: $4K specialty equipment rental. $20K front end loader rental for snow removal (Lots, PCC larger lot & trails) 7600.100 - Rentals - Portable Toilets 78,410 64,363 52,951 85,000 84,000 87,000 (1,000)(1.18 %)2022: ADA units and cleaning, more units in additional parks. JPA cuts. 8000 - Non-Cap Equip (< 5K)4,793 35,314 4,293 8,000 10,000 11,000 2,000 25.00 %2022: Hand tools, pumps, small equipment 2023: Hand tools, pumps, small equipment 8050 - Cap Equip ($5K - $25K)6,800 12,202 -----0.00 % 8100.300 - Capital Outlay (> 5K) - Buildings -145,594 101,230 ----0.00 % 8100.400 - Capital Outlay (> 5K) - Improv Other Than Buildings -11,714 -----0.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Parks & Forestry Page 32 37 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 8100.500 - Capital Outlay (> 5K) - Machinery & Equipment -------0.00 % 9000.101 - Allocations - Information Technology 134,179 134,179 92,136 138,204 142,350 146,621 4,146 3.00 % 9000.102 - Allocations - Facilities Management 146,237 146,237 100,416 150,624 155,143 159,797 4,519 3.00 % 9000.107 - Allocations - Central Equipment 666,884 666,884 457,927 686,891 707,498 728,723 20,607 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 92,521 144,429 97,523 146,284 188,297 188,488 42,013 28.72 % 9000.111 - Allocations - Risk Mgmt - Claims 31,517 61,327 58,791 88,187 23,859 23,859 (64,328)(72.94 %) 9500.400 - Transfers Out - General Capital Projects -101,230 -----0.00 % 9500.620 - Transfers Out - Information Technology --1,963 ----0.00 % 9913 - Licenses, Permits & Registrations -330 -----0.00 % 9920.100 - Bank Fees - Credit Card ---75 75 75 -0.00 % Total $5,173,091 $5,610,261 $3,412,248 $5,613,086 $5,736,454 $5,936,498 $123,368 2.20 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Parks & Forestry Page 33 38 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$28,804 -----0.00 % 4230 - Intergovern-State-Operating 5,000 3,750 250 5,000 5,000 5,000 -0.00 %2022: Grants for Historical Museum 2023: Grants for Historical Museum 4310 - Program Fees 4,891 3,166 1,994 5,000 200,000 275,000 195,000 3,900.00 %2022: Indoor playground admission fees 2023: projecting an increase due awareness of facility 4320 - Rental Fees 9,482 2,482 2,787 9,500 3,000 7,000 (6,500)(68.42 %)2022: Garden Photo fees, previous years this line also included AV fee but AV fees are now included with room rental 2023: projecting an increase of garden after construction and awareness of amenities 4320.104 - Rental Fees - Millennium Garden 15,300 8,005 7,690 16,000 8,500 13,000 (7,500)(46.88 %)2022: Anticipating less rentals in 2022 due to construction 4320.200 - Rental Fees - Meeting Rooms 125,406 36,040 24,954 127,000 204,000 581,000 77,000 60.63 %2022: Includes ballroom, meeting rooms, theater, green rooms, senior rooms, and party rooms. Party room rentals start January 2022 and all other rooms start July 2022 2023: Includes ballroom, meeting rooms, theater, green rooms, senior rooms, and party rooms. 4320.202 - Rental Fees - Catering Rebate 56,897 12,560 6,665 57,000 30,000 90,000 (27,000)(47.37 %)2022: Revenue can vary on size and types of events. Events will start in July 2022 2023: Revenue can vary on size and type of events. 4320.203 - Rental Fees - Rental Chair Rebate 1,411 295 522 1,500 1,500 2,000 -0.00 %2022: Revenue largely impacted by size of outdoor ceremonies 2023: Revenue largely impacted by size of outdoor ceremonies 4320.204 - Rental Fees - Gymnasium ----50,000 50,000 50,000 100.00 %2022: new revenue code for 2022 for gym rentals 4350.108 - General Services - Advertisements 840 840 --1,000 1,500 1,000 100.00 %2022: wedding vendors preferred lists 2023: wedding vendor preferred lists 4800.400 -Other Revenues - Commissions 72 25 2 -100 100 100 100.00 %2022: ATM commission 2023: ATM commission 4807 - Refunds & Reimbursements 1,409 635 1,944 ----0.00 % 4809 - Sales of Equipment (non-asset)-263 4,157 ----0.00 % Total $220,708 $96,864 $50,964 $221,000 $503,100 $1,024,600 $282,100 127.65 % Expenses 6000 - Salaries ($353)($2,362)-----0.00 %2022: Regular salaries: +2 FTEs (activity ctr coord & mtce supv beginning June 2022). Temp salaries: market adjustment (offset by revenue) 6000.100 - Salaries - Regular 278,606 291,584 218,424 360,358 474,968 572,622 114,610 31.80 % 6000.200 - Salaries - Temporary 63,385 61,649 32,228 60,596 160,287 250,638 99,691 164.52 % 6020.100 - Overtime/Comp Time 239 345 4 250 950 950 700 280.00 % 6030.100 - Other Pay - Comp Time 39 ------0.00 % 6050 - Benefits (48)(358)-----0.00 % 6050.100 - Benefits - Social Security 20,624 21,487 15,090 26,206 36,996 43,079 10,790 41.17 % 6050.101 - Benefits - Medicare 4,823 5,025 3,529 6,128 9,259 11,992 3,131 51.09 % 6050.200 - Benefits - PERA 24,129 25,538 17,216 29,784 47,718 61,818 17,934 60.21 % 6050.302 - Benefits - Unemployment ---1,500 1,500 1,500 -0.00 % 6050.550 - Benefits - Cell Phone Allowance 1,494 1,312 895 1,488 2,280 2,760 792 53.23 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Plymouth Community Center Page 34 39 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6060.100 - Medical Insurance - Employer Contribution 35,013 32,648 26,143 56,017 84,590 113,981 28,573 51.01 % 6070.100 - Dental Insurance - Employer Contribution 2,484 2,247 1,654 3,887 5,399 6,992 1,512 38.90 % 6080.100 - Group Life Insurance - Employer Contribution 620 627 452 873 1,257 1,391 384 43.99 % 6100 - Office Supplies 1,214 1,055 440 1,100 2,000 2,000 900 81.82 % 6120 - Operating Supplies 8,047 9,573 1,633 9,000 10,000 15,000 1,000 11.11 %2022: general building supplies 2023: general building supplies 6140.100 - Miscellaneous Supplies - Medical ----400 500 400 100.00 %2022: First aid kits 2023: First aid kits 6140.101 - Miscellaneous Supplies - Clothing 140 327 280 400 3,500 3,500 3,100 775.00 %2022: staff uniforms 2023: staff uniforms 6500.100 - Employee Development - Training 855 300 -1,000 5,000 5,000 4,000 400.00 %2022: increase due to additional FTE's 2023: increase due to additional FTE's 6700 - Dues & Subscriptions 477 439 17 500 6,000 6,500 5,500 1,100.00 %2022: increase due to event planning management subscription and interactive software for indoor playground. Also includes marketing, MRPA, Costco 2023: increase due to event planning management subscription and interactive software for indoor playground. This also includes marketing, MRPA, and Costco 7000 - Professional Services 4,000 --4,000 --(4,000)(100.00 %)2022: moved to Facilities budget 2023: moved to Facilities budget 7004 - Audit Fees 832 806 864 900 1,500 1,500 600 66.67 % 7100.100 - Communications - Postage 735 322 182 750 750 1,100 -0.00 % 7200 - Printing & Publishing 458 461 -600 2,000 2,500 1,400 233.33 %2022: New brochures for birthday parties, playground, and events 2023: New brochures for birthday parties, playground, and events 7400.102 - Utilities - Natural Gas 13,483 13,239 9,813 16,000 23,000 45,000 7,000 43.75 %2023: full year with increased sq. footage 7400.103 - Utilities - Water & Sewer 11,858 11,138 5,065 12,500 22,000 42,900 9,500 76.00 %2023: full year with increased sq footage 7400.104 - Utilities - Solid Waste 804 --800 1,250 1,375 450 56.25 %2023: full year with increased sq. footage 7400.108 - Utilities - Electric 29,069 23,752 16,881 32,000 52,000 101,200 20,000 62.50 %2023: full year with increased sq. footage 7500.130 - Repair & Maint Services - Building Maint 21,795 14,506 6,273 23,000 10,000 10,000 (13,000)(56.52 %)2022: decreased from previous years with many services moved to Facilities budget. 2023: decreased from previous years with many services moved to Facilities budget. 8000 - Non-Cap Equip (< 5K)10,793 16,368 280 5,000 2,000 10,000 (3,000)(60.00 %)2022: PCC still under construction and should not need any equipment 2023: replacement of vacuums 9000.101 - Allocations - Information Technology 67,088 67,088 46,067 69,101 71,174 73,309 2,073 3.00 % 9000.102 - Allocations - Facilities Management 39,025 39,025 26,797 40,196 58,402 59,644 18,206 45.29 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Plymouth Community Center Page 35 40 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 9000.110 - Allocations - Risk Mgmt - OH, Premium 8,150 7,034 2,966 4,449 5,830 5,868 1,381 31.04 % 9000.111 - Allocations - Risk Mgmt - Claims 909 -13,079 19,618 --(19,618)(100.00 %) 9900.100 - Miscellaneous - Cash Over/Short (7)22 -----0.00 % 9907 - Historical Society 6,046 4,914 2,025 3,000 10,000 10,000 7,000 233.33 %2022: increased from previous years for more programming and supplies needed for operating museum hours 2023: increased from previous years for more programming and supplies needed for operating museum hours 9913 - Licenses, Permits & Registrations 2,629 3,527 2,220 3,200 3,500 3,750 300 9.38 %2022: licenses for kitchen 2023: licenses for kitchen 9920 - Bank Fees ----100 100 100 100.00 % 9920.100 - Bank Fees - Credit Card 5,319 2,862 1,623 5,500 5,000 10,000 (500)(9.09 %)2023: anticipating more credit card charges with expansion 9920.150 - Bank Fees - PSN 72 27 6 100 --(100)(100.00 %) Total $664,849 $656,526 $452,145 $799,801 $1,120,610 $1,478,469 $320,809 40.11 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Parks and Recreation - Plymouth Community Center Page 36 41 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4100.300 - Licenses - Pet $1,130 $2,172 $950 $1,000 $1,000 $1,000 -0.00 % 4100.600 - Licenses - Investigation Fee 9,300 8,200 2,025 14,000 12,000 12,000 (2,000)(14.29 %)2022: Decrease of $2,000 due to 5-year average reduction in investigation fees 4100.710 - Licenses - Hotel 1,388 1,200 1,500 1,400 1,400 1,400 -0.00 % 4200 - Intergovern- Federal - Operating -5,853 150 ----0.00 % 4230.103 - Intergovern-State-Operating - Police State Aid 706,811 741,119 -665,000 700,000 700,000 35,000 5.26 %2022: Increase police state aid revenue by $35,000 based on state projections 4230.106 - Intergovern-State-Operating - Police Training Reimb 76,552 74,332 81,399 76,000 76,000 76,000 -0.00 % 4270 - Intergovern-Local-Operating --1,400 ----0.00 % 4270.100 - Intergovern-Local-Operating - School Liaison 542,961 160,847 368,552 553,790 502,790 517,874 (51,000)(9.21 %)2022: Decrease in revenue due to change in RSD contract rate changes (reduction of $17,000 for each of the 3 Robbinsdale SROs--$51,000 total). 2023: Increase by 3% for 2023 for salary increase. 4350 - General Services 2,810 2,630 2,232 2,000 2,000 2,000 -0.00 % 4350.102 - General Services - Alarm Fees 37,450 24,063 24,175 35,000 35,000 35,000 -0.00 % 4350.103 - General Services - Accident Reports 2,095 969 744 1,500 1,500 1,500 -0.00 % 4350.105 - General Services - Towing 1,565 1,385 850 2,000 2,000 2,000 -0.00 % 4410 - Court Fines 520,860 305,181 207,763 500,000 400,000 400,000 (100,000)(20.00 %)2022: Decrease of $100,000 in court fine revenue based on court system changes. 4420 - Animal Impound Fees 8,594 3,157 2,139 7,000 7,000 7,000 -0.00 % 4430 - Liquor/Tobacco Violations 5,500 9,000 3,000 5,000 5,000 5,000 -0.00 % 4600 - Contributions - Operating 7,400 3,000 600 5,100 4,000 4,000 (1,100)(21.57 %) 4800 - Other Revenues 6,817 15 479 1,000 1,000 1,000 -0.00 % 4807 - Refunds & Reimbursements 1,379 8,365 116 ----0.00 % 4900.100 - Transfers In - General -112 -----0.00 % 4900.660 - Transfers In - Resource Planning -7 -----0.00 % Total $1,932,611 $1,351,606 $698,074 $1,869,790 $1,750,690 $1,765,774 ($119,100)(6.37 %) Expenses 6000 - Salaries $17,917 ($3,924)-----0.00 % 6000.100 - Salaries - Regular 1,124,345 1,122,841 712,932 1,142,884 1,153,386 1,193,523 10,502 .92 % 6000.200 - Salaries - Temporary 77,331 78,449 50,684 88,755 91,419 94,154 2,664 3.00 % 6020.100 - Overtime/Comp Time 1,504 106 82 5,200 2,500 2,500 (2,700)(51.92 %) 6020.400 - Overtime - Contractual ---2,000 2,000 2,000 -0.00 % 6030.100 - Other Pay - Comp Time (1,478)------0.00 % 6050 - Benefits 3,647 800 -----0.00 % 6050.100 - Benefits - Social Security 38,796 38,776 25,438 40,877 41,968 43,080 1,091 2.67 % 6050.101 - Benefits - Medicare 16,722 16,756 10,671 18,091 18,248 18,870 157 .87 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Administration Page 37 42 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6050.200 - Benefits - PERA 135,978 139,294 88,493 145,487 145,345 150,903 (142)(.10 %) 6050.500 - Benefits - Clothing Allowance 4,000 4,100 3,688 4,200 4,300 4,400 100 2.38 % 6050.550 - Benefits - Cell Phone Allowance 4,820 4,540 2,970 4,800 4,800 4,800 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 148,334 193,708 156,808 150,143 166,793 184,524 16,650 11.09 % 6060.500 - Medical Insurance - Cash Out to VEBA -2,773 -----0.00 % 6070.100 - Dental Insurance - Employer Contribution 6,308 6,442 4,401 7,563 7,563 7,941 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 2,675 2,623 1,671 2,958 3,012 3,028 54 1.83 % 6100 - Office Supplies 9,080 2,856 974 8,000 8,000 8,000 -0.00 % 6120 - Operating Supplies 591 161 183 ----0.00 % 6120.101 - Operating Supplies - Public Ed & Outreach Prj -7 -----0.00 % 6120.104 - Operating Supplies - Shooting Range 6,405 1,908 529 6,000 6,000 6,000 -0.00 % 6120.109 - Operating Supplies - Community Education -67 -----0.00 % 6120.122 - Operating Supplies - Reserve Program 4,053 5,890 3,338 6,000 6,000 6,000 -0.00 % 6120.123 - Operating Supplies - Explorer Program 8,063 6,647 -12,000 8,000 8,000 (4,000)(33.33 %) 6120.128 - Operating Supplies - Property Room 3,049 2,800 1,426 4,000 4,000 4,000 -0.00 % 6140.101 - Miscellaneous Supplies - Clothing -199 -----0.00 % 6140.104 - Miscellaneous Supplies - Chaplain/Sr Corp 82 ------0.00 % 6500 - Employee Development 186 ------0.00 % 6500.100 - Employee Development - Training 112,443 76,156 40,604 96,000 110,000 110,000 14,000 14.58 %2022: Increase of $14,000 to cover the cost of unfunded training requirements dictated by legislative mandate. 6500.103 - Employee Development - EE Recognition 4,532 8,996 2,270 11,000 12,000 12,000 1,000 9.09 %2022: Increase $1,000 for employee recognition event due to increase in catering costs 6500.105 - Employee Development - Shooting Range Training 49,300 50,800 51,600 50,000 70,000 70,000 20,000 40.00 %2022: Increase of $20,000 due to large shooting range facility expansion, including reality-based training options, state of the art classrooms, and outdoor trainings. All of the needed training will be able to be done at the facility after it is built. 6500.200 - Employee Development - Wellness 10,401 2,230 150 16,000 16,000 16,000 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Administration Page 38 43 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6550 - Mileage & Parking Reimbursement 933 211 -250 250 250 -0.00 % 6700 - Dues & Subscriptions 7,743 5,833 3,658 7,500 7,500 7,500 -0.00 % 7000 - Professional Services 65,825 85,251 46,661 74,476 73,100 69,100 (1,376)(1.85 %)2022: Decrease in $35,376 due to moving software costs to IT allocations. Increase of $4,000 for 2022 only for the BWC audit. 7008 - Veterinary Fees 129 115 -1,000 500 500 (500)(50.00 %)2022: Decrease by $500 due to 5-year average 7016 - Animal Control 25,211 18,500 12,606 26,000 26,000 26,000 -0.00 % 7100.100 - Communications - Postage 4,623 4,001 2,163 4,000 4,500 4,500 500 12.50 %2022: Increase $500 for an increase in number of data requests and BWC video. 7100.104 - Communications - Mobile Telephone -357 980 ----0.00 % 7200 - Printing & Publishing 617 1,221 326 1,000 1,000 1,000 -0.00 % 7500.201 - Repair & Maint Services - Departmental Software Maint --263 ----0.00 % 7500.202 - Repair & Maint Services - Equipment Maint -435 -1,500 1,500 1,500 -0.00 % 8000 - Non-Cap Equip (< 5K)1,154 5,018 633 5,000 5,000 5,000 -0.00 % 9000.101 - Allocations - Information Technology 186,314 186,314 127,935 191,903 197,660 203,590 5,757 3.00 %2022: Software subscriptions and maintenance moved to IT allocation. Increasefor Verizon Air Cards (add 2 air cards and netmotion licenses for Admin Mngr. and Inv Tech) 9000.102 - Allocations - Facilities Management 263,885 263,885 181,201 271,802 279,956 288,355 8,154 3.00 % 9000.107 - Allocations - Central Equipment 4,067 4,067 2,793 4,189 4,315 4,444 126 3.01 % 9000.109 - Allocations - 800 MHz Radios 70,000 70,000 70,000 70,000 70,000 70,000 -0.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 34,918 83,161 12,208 18,312 41,196 41,858 22,884 124.97 % 9000.111 - Allocations - Risk Mgmt - Claims 225,053 143,868 39,185 58,777 116,656 116,656 57,879 98.47 % 9500.660 - Transfers Out - Resource Planning -146 -----0.00 % 9900 - Miscellaneous 50 ------0.00 % 9901 - Care of Prisoners 1,783 ------0.00 % 9906 - Donations & Contributions -3,000 -----0.00 % 9920.100 - Bank Fees - Credit Card 243 96 434 200 200 200 -0.00 % 9920.150 - Bank Fees - PSN -------0.00 % Total $2,681,634 $2,641,480 $1,659,958 $2,557,867 $2,710,667 $2,790,176 $152,800 5.97 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Administration Page 39 44 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$2,507,294 $1,259 ----0.00 % 4230.104 - Intergovern-State-Operating - Disabled Officer Reimb -11,787 10,958 14,580 12,000 12,000 (2,580)(17.70 %)2022: Reduce to $12,000 based on 5 year trends 4250 - Intergovern-County-Operating 13,065 ------0.00 % 4270 - Intergovern-Local-Operating 16,920 ------0.00 % 4350.104 - General Services - Police Services 108,817 61,040 65,384 98,000 98,000 98,000 -0.00 % 4400 - General Fines & Forfeitures 3,700 4,600 3,700 1,000 3,000 3,000 2,000 200.00 %2022: Increase by $2,000 based on 5 year trend 4600 - Contributions - Operating 10,600 2,123 20,072 1,000 1,000 1,000 -0.00 % 4800 - Other Revenues 400 ------0.00 % 4807 - Refunds & Reimbursements 823 306 9 ----0.00 % 4900.100 - Transfers In - General -3,887 -----0.00 % Total $154,325 $2,591,039 $101,382 $114,580 $114,000 $114,000 ($580)(.51 %) Expenses 6000 - Salaries $16,408 $70,303 -----0.00 %2022: OT/comp: increase due to new union contract provision. OT/holiday: increase to align with history. 6000.100 - Salaries - Regular 5,142,147 5,332,862 3,360,000 5,612,476 5,759,888 5,993,871 147,412 2.63 % 6000.200 - Salaries - Temporary 9,514 25,839 4,885 39,103 40,289 41,495 1,186 3.03 % 6000.300 - Salaries - Court Time - Stand by 8,791 4,387 3,157 7,507 7,507 7,507 -0.00 % 6020.100 - Overtime/Comp Time 172,416 124,591 123,867 168,300 178,300 178,300 10,000 5.94 % 6020.200 - Overtime - Court Time - Court appearance 11,309 6,695 3,797 15,000 15,000 15,000 -0.00 % 6020.300 - Overtime - Holiday 46,384 44,283 20,309 33,000 48,000 48,000 15,000 45.45 % 6020.400 - Overtime - Contractual 102,351 42,791 55,318 65,000 65,000 65,000 -0.00 % 6030.100 - Other Pay - Comp Time 10,767 ------0.00 % 6050 - Benefits 8,112 17,923 -----0.00 % 6050.100 - Benefits - Social Security 16,041 19,757 11,929 21,982 22,532 23,622 550 2.50 % 6050.101 - Benefits - Medicare 77,887 78,598 50,703 87,060 89,604 93,034 2,544 2.92 % 6050.200 - Benefits - PERA 905,969 950,536 611,418 1,012,587 1,042,395 1,082,130 29,808 2.94 % 6050.500 - Benefits - Clothing Allowance 53,457 59,744 55,736 59,891 61,853 63,245 1,962 3.28 % 6050.550 - Benefits - Cell Phone Allowance 3,424 3,615 2,098 3,300 3,300 3,300 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 660,808 641,859 415,930 702,811 751,161 824,496 48,350 6.88 % 6060.400 - Medical Insurance - Disabled Officer 58,650 61,559 53,097 52,572 64,888 68,541 12,316 23.43 % 6070.100 - Dental Insurance - Employer Contribution 33,903 28,679 19,745 32,257 33,938 35,634 1,681 5.21 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Patrol Page 40 45 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6080.100 - Group Life Insurance - Employer Contribution 10,311 10,260 6,389 11,422 11,850 11,868 428 3.75 % 6100 - Office Supplies -2,399 2,692 ----0.00 % 6120 - Operating Supplies -301 51 300 1,800 1,800 1,500 500.00 %2022: Increase by $1500 for UAV batteries. 6120.106 - Operating Supplies - Ammunition 21,089 10,562 20,663 22,720 22,720 22,720 -0.00 % 6120.121 - Operating Supplies - SWAT Team 22,580 9,511 9,063 12,000 14,000 14,000 2,000 16.67 %2022: New line item for Negotiations Team 6120.126 - Operating Supplies - K9 Unit 4,100 5,274 27,072 7,600 8,000 8,000 400 5.26 %2022: Increase $400 due to an increase in food cost. 6120.129 - Operating Supplies - Training 4,999 4,873 -5,000 5,000 5,000 -0.00 % 6120.130 - Operating Supplies - CSO 4,904 853 803 4,000 4,000 4,000 -0.00 % 6140.100 - Miscellaneous Supplies - Medical 3,773 11,890 6,318 6,000 6,500 6,500 500 8.33 %2022: Increase by $500 for phlebotomy supplies 6140.101 - Miscellaneous Supplies - Clothing 6,171 6,566 9,035 8,250 11,150 11,150 2,900 35.15 %2022: Increase by $3,000 for uniform allowance per contract (budgeting for 2 new officers a year) 6140.102 - Miscellaneous Supplies - Safety Equipment 1,561 14,314 2,909 3,000 3,000 3,000 -0.00 % 6500.100 - Employee Development - Training 17,589 8,320 7,765 15,500 23,500 23,500 8,000 51.61 %2022: Increase $2,000 for catch-up training due to lack of training during the pandemic -------------------- 2022: New line item for Negotiations Team 6550 - Mileage & Parking Reimbursement --17 50 50 50 -0.00 % 6600 - Meetings -142 168 750 750 750 -0.00 % 6700 - Dues & Subscriptions 270 1,632 370 800 800 800 -0.00 % 7000 - Professional Services -220 -----0.00 % 7008 - Veterinary Fees 10,572 3,722 123 5,000 5,000 5,000 -0.00 % 7100 - Communications --36 ----0.00 % 7100.100 - Communications - Postage -18 -----0.00 % 7100.102 - Communications - Data Communications 385 ------0.00 % 7500.202 - Repair & Maint Services - Equipment Maint 66,808 74,977 43,917 135,447 82,000 82,000 (53,447)(39.46 %)2022: Decrease to $82,000 due to 5 year trend for MDCs and radio repairs 7600 - Rentals ---1,000 1,000 1,000 -0.00 % 8000 - Non-Cap Equip (< 5K)9,211 14,232 12,368 16,000 16,000 16,000 -0.00 % 8100.500 - Capital Outlay (> 5K) - Machinery & Equipment 14,514 -728 ----0.00 % 9000.101 - Allocations - Information Technology 393,128 393,128 269,948 404,922 417,069 429,581 12,147 3.00 % 9000.102 - Allocations - Facilities Management 186,608 186,608 128,137 192,206 197,972 203,911 5,766 3.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Patrol Page 41 46 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 9000.107 - Allocations - Central Equipment 586,683 586,683 402,855 604,283 622,411 641,083 18,128 3.00 % 9500.100 - Transfers Out - General -145,672 -----0.00 % 9500.200 - Transfers Out - Recreation -5,488 -----0.00 % 9500.220 - Transfers Out - Transit System -3,884 -----0.00 % 9500.540 - Transfers Out - Ice Center -22,063 -----0.00 % 9500.610 - Transfers Out - Public Facilities -24,100 -----0.00 % 9500.620 - Transfers Out - Information Technology -172,813 -----0.00 % 9500.660 - Transfers Out - Resource Planning 39,500 39,500 39,500 39,500 39,500 39,500 -0.00 % 9900 - Miscellaneous 601 805 -----0.00 % 9901 - Care of Prisoners 29,800 6,437 4,110 55,000 35,000 35,000 (20,000)(36.36 %)2022: Decrease by $20,000 based on trend and decrease in HC Attorney charging 9902 - Booking of Prisoners 47,224 37,308 19,871 50,000 50,000 50,000 -0.00 % Total $8,820,722 $9,318,574 $5,806,896 $9,513,596 $9,762,727 $10,159,388 $249,131 2.62 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Patrol Page 42 47 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$36,675 -----0.00 % 4230 - Intergovern-State-Operating -6,618 -----0.00 % 4350.104 - General Services - Police Services 6,408 34,285 20,447 25,000 25,000 25,000 -0.00 % 4360.105 - Items for Resale - Caps & Apparel 115 -220 ----0.00 % 4800 - Other Revenues 4 ------0.00 % 4807 - Refunds & Reimbursements 30 1 69 ----0.00 % 4900.660 - Transfers In - Resource Planning 26,791 14,811 -----0.00 % Total $33,349 $92,389 $20,736 $25,000 $25,000 $25,000 -0.00 % Expenses 6000 - Salaries $14,237 $51,816 -----0.00 %2022: OT/comp: increase due to new union contract provision 6000.100 - Salaries - Regular 2,283,636 2,313,163 1,565,730 2,524,096 2,592,136 2,678,850 68,040 2.70 % 6000.200 - Salaries - Temporary 1,588 ------0.00 % 6000.300 - Salaries - Court Time - Stand by -640 769 ----0.00 % 6020.100 - Overtime/Comp Time 68,344 57,252 49,611 74,000 111,000 111,000 37,000 50.00 % 6020.200 - Overtime - Court Time - Court appearance --445 500 500 500 -0.00 % 6020.300 - Overtime - Holiday 1,443 2,717 1,449 1,000 3,500 3,500 2,500 250.00 % 6030.100 - Other Pay - Comp Time 7,509 ------0.00 % 6050 - Benefits 5,140 12,011 -----0.00 % 6050.100 - Benefits - Social Security 12,500 13,788 8,908 18,523 18,995 19,838 472 2.55 % 6050.101 - Benefits - Medicare 32,892 33,260 22,811 38,360 39,960 41,222 1,600 4.17 % 6050.200 - Benefits - PERA 378,734 396,129 270,933 429,706 447,965 461,926 18,259 4.25 % 6050.500 - Benefits - Clothing Allowance 21,730 21,236 22,792 22,789 23,322 23,855 533 2.34 % 6050.550 - Benefits - Cell Phone Allowance 23,221 21,735 16,493 23,100 25,500 25,500 2,400 10.39 % 6060.100 - Medical Insurance - Employer Contribution 307,561 278,720 195,348 333,310 357,935 396,630 24,625 7.39 % 6070.100 - Dental Insurance - Employer Contribution 10,551 11,935 9,396 15,229 16,489 17,313 1,260 8.27 % 6080.100 - Group Life Insurance - Employer Contribution 4,211 4,202 2,769 4,912 5,090 5,096 178 3.62 % 6100 - Office Supplies --34 ----0.00 % 6120.102 - Operating Supplies - Motor Fuels & Lubricants 5,769 2,791 -6,000 6,000 6,000 -0.00 % 6120.109 - Operating Supplies - Community Education 13,430 6,503 8,026 14,000 14,000 14,000 -0.00 % 6120.110 - Operating Supplies - DARE Program 12,810 610 -15,000 15,000 15,000 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Services Page 43 48 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6120.117 - Operating Supplies - CFMH Program 732 --1,500 1,500 1,500 -0.00 % 6140.101 - Miscellaneous Supplies - Clothing 150 ------0.00 % 6140.104 - Miscellaneous Supplies - Chaplain/Sr Corp 144 361 121 700 700 700 -0.00 % 7000 - Professional Services 23,909 28,093 29,891 30,409 20,009 20,009 (10,400)(34.20 %)2022: Decrease of $11,100 moving 7000 software items (3SI, CovertTracker, Rapid, Clear) to IT Allocation. Increase by $700 for an increase in Cornerhouse fees. 7200 - Printing & Publishing 25 ------0.00 % 7500.142 - Repair & Maint Services - SIU 44 176 175 2,000 2,000 2,000 -0.00 % 7500.201 - Repair & Maint Services - Departmental Software Maint -7,974 -----0.00 % 7500.202 - Repair & Maint Services - Equipment Maint 5,377 4,827 -1,600 1,600 1,600 -0.00 % 8000 - Non-Cap Equip (< 5K)4,116 13,748 10,596 4,500 10,000 10,000 5,500 122.22 %2022: Increase $5,500 due to costs for forensics and crime analyst costs 8000.110 - Non-Cap Equip (< 5K) - SIU 4,500 1,602 2,143 4,000 4,000 4,000 -0.00 % 9000.101 - Allocations - Information Technology 228,560 228,560 156,945 235,417 242,480 249,754 7,063 3.00 %2022: Software subscriptions and maintenance moved to IT allocation (3SI, CovertTracker, Rapid, Clear) and add Airdata. 9000.102 - Allocations - Facilities Management 78,854 78,854 54,147 81,220 83,657 86,167 2,437 3.00 % 9000.107 - Allocations - Central Equipment 94,049 94,049 64,580 96,870 99,776 102,769 2,906 3.00 % 9500.620 - Transfers Out - Information Technology 140 ------0.00 % Total $3,645,906 $3,686,753 $2,494,111 $3,978,741 $4,143,114 $4,298,729 $164,373 4.13 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Services Page 44 49 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating $49,053 $42,284 $76,060 $42,540 $53,621 $53,621 $11,081 26.05 % 4230 - Intergovern-State-Operating 14,772 1,525 20,407 11,918 16,089 16,089 4,171 35.00 % Total $63,825 $43,809 $96,467 $54,458 $69,710 $69,710 $15,252 28.01 % Expenses 6000 - Salaries -------0.00 %2022: OT/comp: increase to align with history 6000.100 - Salaries - Regular --42,750 ----0.00 % 6020.100 - Overtime/Comp Time 33,202 35,678 22,411 25,700 38,500 38,500 12,800 49.81 % 6020.300 - Overtime - Holiday --92 ----0.00 % 6050.101 - Benefits - Medicare 475 514 913 373 559 559 186 49.87 % 6050.200 - Benefits - PERA 5,634 6,313 11,550 4,549 6,815 6,815 2,266 49.81 % 6140.102 - Miscellaneous Supplies - Safety Equipment 10,807 21,456 11,868 23,836 23,836 23,836 -0.00 % 6500.100 - Employee Development - Training 4,970 ------0.00 % Total $55,088 $63,960 $89,581 $54,458 $69,710 $69,710 $15,252 28.01 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Police - PD Grants Page 45 50 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$40,565 $2,072 ----0.00 % 4807 - Refunds & Reimbursements 795 244 1 ----0.00 % 4900.100 - Transfers In - General -4,954 -----0.00 % Total $795 $45,763 $2,073 ----0.00 % Expenses 6100 - Office Supplies ---$500 $500 $500 -0.00 % 6120 - Operating Supplies -32,253 -----0.00 % 6120.101 - Operating Supplies - Public Ed & Outreach Prj ---600 600 600 -0.00 % 6140.104 - Miscellaneous Supplies - Chaplain/Sr Corp 135 3,472 417 4,000 4,000 4,000 -0.00 % 6500.100 - Employee Development - Training 4,771 279 3,660 5,500 5,500 5,500 -0.00 % 6700 - Dues & Subscriptions 35,300 7,310 17,500 21,500 21,500 21,500 -0.00 % 7000 - Professional Services ---1,000 1,000 1,000 -0.00 % 7400.108 - Utilities - Electric 2,098 2,086 1,819 2,000 2,000 2,000 -0.00 % 7500 - Repair & Maint Services 12,773 8,303 4,497 10,000 10,000 10,000 -0.00 % 7500.202 - Repair & Maint Services - Equipment Maint 23,085 4,184 614 ----0.00 % 8000 - Non-Cap Equip (< 5K)2,358 6,420 3,637 5,000 5,000 5,000 -0.00 % 9000.101 - Allocations - Information Technology 16,475 16,475 11,313 16,969 17,478 18,002 509 3.00 % 9000.102 - Allocations - Facilities Management 2,755 2,755 1,892 2,838 2,923 3,011 85 3.00 % 9500.660 - Transfers Out - Resource Planning 5,000 5,000 5,000 5,000 5,000 5,000 -0.00 % Total $104,750 $88,537 $50,348 $74,907 $75,501 $76,113 $594 .79 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Emergency Management - Emergency Management Page 46 51 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4150.900 - Permits - Burning Permit $200 $200 $700 $900 $500 $500 ($400)(44.44 %)2022: Decrease due to less fire permits being applied for 4200 - Intergovern- Federal - Operating -811,150 6,246 ----0.00 % 4230 - Intergovern-State-Operating 59,080 10,596 78,379 15,000 15,000 75,000 -0.00 %2023: Increase due to the second year biennium redistribution from the state. 4230.104 - Intergovern-State-Operating - Disabled Officer Reimb ----2,000 2,000 2,000 100.00 %2022: State reimbursement for disabled officer benefit 2023: State reimbursement for disabled officer benefit 4230.105 - Intergovern-State-Operating - Fire State Aid 543,606 578,032 5,000 505,000 510,000 515,000 5,000 .99 %2022: Increase due to rising tax base 2023: Increase due to rising tax base 4240 - Intergovern-State-Capital 4,031 ------0.00 % 4350.102 - General Services - Alarm Fees 6,325 2,375 1,300 6,000 4,000 4,000 (2,000)(33.33 %)2022: Decrease due to increased customer service drive that minimizes punitive fines. 4600 - Contributions - Operating --14,484 ----0.00 % 4807 - Refunds & Reimbursements 476 3,154 2,075 ----0.00 % 4900.100 - Transfers In - General -4,722 -----0.00 % 4900.660 - Transfers In - Resource Planning --37,809 ----0.00 % Total $613,718 $1,410,229 $145,992 $526,900 $531,500 $596,500 $4,600 .87 % Expenses 6000 - Salaries $43,405 $44,775 -----0.00 % 6000.100 - Salaries - Regular 1,506,816 1,956,475 1,445,526 2,346,157 2,479,207 2,744,079 133,050 5.67 % 6000.200 - Salaries - Temporary 402,629 401,145 233,552 342,283 373,955 337,158 31,672 9.25 % 6020.100 - Overtime/Comp Time 36,920 53,411 44,505 35,000 56,280 56,280 21,280 60.80 % 6020.300 - Overtime - Holiday 7,550 13,195 7,096 20,000 17,517 17,517 (2,483)(12.42 %) 6030.100 - Other Pay - Comp Time (618)------0.00 % 6050 - Benefits 8,683 9,549 -----0.00 % 6050.100 - Benefits - Social Security 39,213 41,415 25,166 39,788 42,340 49,311 2,552 6.41 % 6050.101 - Benefits - Medicare 27,821 34,298 24,215 39,867 42,548 45,849 2,681 6.72 % 6050.200 - Benefits - PERA 240,568 326,203 246,249 394,459 420,490 466,536 26,031 6.60 % 6050.302 - Benefits - Unemployment 939 ---1,000 1,000 1,000 100.00 % 6050.550 - Benefits - Cell Phone Allowance 6,025 5,200 3,900 6,000 7,200 7,200 1,200 20.00 % 6060.100 - Medical Insurance - Employer Contribution 171,227 222,138 174,333 304,458 315,878 401,910 11,420 3.75 % 6060.400 - Medical Insurance - Disabled Officer ----10,000 11,000 10,000 100.00 % 6070.100 - Dental Insurance - Employer Contribution 10,628 11,013 8,044 16,389 13,448 18,089 (2,941)(17.94 %) 6080.100 - Group Life Insurance - Employer Contribution 2,856 3,448 2,384 4,332 4,450 4,782 118 2.72 % 6100 - Office Supplies 2,407 888 1,430 3,000 2,000 2,000 (1,000)(33.33 %)2022: Decrease based on past actual expenses City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Fire - Fire Operations Page 47 52 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6120 - Operating Supplies -209 739 ----0.00 % 6120.100 - Operating Supplies - Photography 160 170 -500 500 500 -0.00 % 6120.101 - Operating Supplies - Public Ed & Outreach Prj 4,360 4,134 3,126 6,500 6,500 6,500 -0.00 % 6120.102 - Operating Supplies - Motor Fuels & Lubricants ----4,000 4,000 4,000 100.00 % 6120.103 - Operating Supplies - Janitorial 592 1,897 742 1,500 2,000 2,000 500 33.33 %2022: Increase based on past actual expenses 6120.105 - Operating Supplies - Fire Fighting 13,335 99,068 18,955 26,700 28,000 30,000 1,300 4.87 %2022: Increase due to increased EMS supply costs 2023: Increase due to increased EMS supply costs 6130 - Repair & Maint Supplies 652 124 -----0.00 % 6130.100 - Repair & Maint Supplies - Equipment Parts 11,749 9,120 15,609 9,000 18,000 18,000 9,000 100.00 %2022: Increased repair cost to appropriately maintain functioning fleet and equipment 6140.101 - Miscellaneous Supplies - Clothing 36,512 21,979 16,524 44,650 42,000 42,000 (2,650)(5.94 %)2022: Decrease based on decrease in the number personnel on the department 6140.102 - Miscellaneous Supplies - Safety Equipment 48,639 53,214 34,145 70,000 70,000 70,000 -0.00 %2022: Turnout gear 6500.100 - Employee Development - Training 39,756 37,418 23,879 42,000 57,250 57,250 15,250 36.31 %2022: Increase based on department training needs 6500.103 - Employee Development - EE Recognition 4,825 4,313 34 4,245 5,245 5,245 1,000 23.56 %2022: Increase for more inclusive and professional recognition of employees 6550 - Mileage & Parking Reimbursement 477 20 129 500 500 500 -0.00 % 6600 - Meetings -606 756 -1,000 1,000 1,000 100.00 %2022: New line item for department due to need to purchase food for CISM and long events 6700 - Dues & Subscriptions 3,587 5,468 1,765 5,250 5,500 5,500 250 4.76 %2022: Increase to better reflect actual past expenses 7000 - Professional Services 19,065 6,350 -2,000 13,000 2,000 11,000 550.00 %2022: Increase due to an anticipated need to add an EMS module to our RMS 2023: Decrease to normal anticipated need 7006 - Medical Fees 7,863 10,849 6,947 17,200 17,200 17,200 -0.00 % 7017 - Laundered Uniforms -46 156 -600 600 600 100.00 %2022: Increase due to fire technician uniform cleaning cost as well as cleaning of officers class A uniform once a year. 7100.100 - Communications - Postage 268 1,514 547 600 600 600 -0.00 % 7100.104 - Communications - Mobile Telephone 497 440 328 200 --(200)(100.00 %)2022: Decrease as this ongoing cost will shift to IT allocation 7200 - Printing & Publishing 122 364 89 -1,000 1,000 1,000 100.00 %2022: Increase for recruitment materials 7400.102 - Utilities - Natural Gas 18,449 16,226 11,116 19,000 --(19,000)(100.00 %) 7400.103 - Utilities - Water & Sewer 7,745 8,346 3,590 9,000 --(9,000)(100.00 %) 7400.104 - Utilities - Solid Waste 1,532 -198 1,500 --(1,500)(100.00 %) 7400.108 - Utilities - Electric 23,826 25,606 13,807 24,500 --(24,500)(100.00 %) City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Fire - Fire Operations Page 48 53 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7500.129 - Repair & Maint Services - Static Testing 12,626 16,716 14,795 14,730 15,170 15,625 440 2.99 %2022: Increased for 3% inflation 2023: Increased for 3% inflation 7500.202 - Repair & Maint Services - Equipment Maint 9,871 12,264 9,962 9,000 9,000 9,000 -0.00 % 7500.203 - Repair & Maint Services - Turn Out Gear Repair 14,111 8,831 5,369 15,400 20,000 20,000 4,600 29.87 %2022: Increase for replacement schedule change to allow for two sets of gear for each firefighter. 7500.204 - Repair & Maint Services - Hennepin County Radio Fees 23,465 24,701 15,742 28,500 29,500 34,000 1,000 3.51 %2022: Increase due to normal inflation of costs from Hennepin Radio 2023: Increase due to normal inflation costs from Hennepin Radio and fees for new station alerting system 7600 - Rentals 721 860 1,145 1,000 1,000 1,000 -0.00 % 8000 - Non-Cap Equip (< 5K)22,480 11,693 35,681 33,000 53,000 33,000 20,000 60.61 %2022: Increase for one year to cover unanticipated expenses related to station projects 2023: Decrease after one year increase to normal needs 8050 - Cap Equip ($5K - $25K)--16,310 ----0.00 % 8100.300 - Capital Outlay (> 5K) - Buildings -------0.00 % 8100.500 - Capital Outlay (> 5K) - Machinery & Equipment 31,924 ------0.00 % 9000.101 - Allocations - Information Technology 240,482 240,482 165,131 247,696 271,549 279,696 23,853 9.63 % 9000.102 - Allocations - Facilities Management 395,359 395,359 271,480 407,220 423,821 436,536 16,601 4.08 % 9000.107 - Allocations - Central Equipment 528,706 528,706 363,045 544,567 616,107 634,590 71,540 13.14 % 9000.109 - Allocations - 800 MHz Radios 28,500 28,500 28,500 28,500 85,000 85,000 56,500 198.25 %2022: Increase to allow for scheduled radio replacement in 2026 9000.110 - Allocations - Risk Mgmt - OH, Premium 11,111 28,046 10,987 16,481 22,380 22,641 5,899 35.79 % 9000.111 - Allocations - Risk Mgmt - Claims 37,473 9,765 75,959 113,939 29,313 29,313 (84,626)(74.27 %) 9500.400 - Transfers Out - General Capital Projects -1,271 -----0.00 % 9500.620 - Transfers Out - Information Technology 140 799 -----0.00 % 9500.660 - Transfers Out - Resource Planning 90,000 127,809 90,000 90,000 90,000 90,000 -0.00 % 9906 - Donations & Contributions 546,713 581,103 8,072 505,000 510,000 515,000 5,000 .99 %2022: Increase for anticipated raise in tax base to be redistributed to relief association 2023: Increase for anticipated raise in tax base to be redistributed to relief association 9920.100 - Bank Fees - Credit Card 2 4 2 ----0.00 % Total $4,744,766 $5,447,544 $3,481,761 $5,891,611 $6,235,048 $6,632,007 $343,437 5.83 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Fire - Fire Operations Page 49 54 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$7 -----0.00 % 4230.200 - Intergovern-State-Operating - Haz Mat Grant (RAD) 44,511 56,522 27,989 90,000 39,806 40,479 (50,194)(55.77 %) Total $44,511 $56,529 $27,989 $90,000 $39,806 $40,479 ($50,194)(55.77 %) Expenses 6000.100 - Salaries - Regular $954 $408 $966 ----0.00 % 6000.200 - Salaries - Temporary 7,034 4,793 7,836 20,198 20,805 21,430 607 3.01 % 6020.100 - Overtime/Comp Time 3,469 879 4,233 2,000 2,000 2,000 -0.00 % 6050.100 - Benefits - Social Security 436 294 486 1,252 1,290 1,329 38 3.04 % 6050.101 - Benefits - Medicare 166 87 188 322 331 340 9 2.80 % 6050.200 - Benefits - PERA 750 228 920 354 354 354 -0.00 % 6100 - Office Supplies --8 ----0.00 % 6120.102 - Operating Supplies - Motor Fuels & Lubricants ---8,000 4,000 4,000 (4,000)(50.00 %) 6120.105 - Operating Supplies - Fire Fighting ---1,000 1,000 1,000 -0.00 % 6130.100 - Repair & Maint Supplies - Equipment Parts -67 -----0.00 % 6140.101 - Miscellaneous Supplies - Clothing 610 --2,500 2,500 2,500 -0.00 % 6500 - Employee Development --147 ----0.00 % 6500.100 - Employee Development - Training 1,017 -243 1,000 1,000 1,000 -0.00 % 7100.100 - Communications - Postage ---724 --(724)(100.00 %) 7500.202 - Repair & Maint Services - Equipment Maint 3,228 4,762 2,077 4,000 5,000 5,000 1,000 25.00 %2022: Increased based on historical actual expenditures 7500.204 - Repair & Maint Services - Hennepin County Radio Fees 2,052 2,238 2,892 3,000 --(3,000)(100.00 %) 8000 - Non-Cap Equip (< 5K)--277 18,000 1,000 1,000 (17,000)(94.44 %) 9000.107 - Allocations - Central Equipment 33,015 33,015 22,670 34,005 --(34,005)(100.00 %) 9000.110 - Allocations - Risk Mgmt - OH, Premium 908 624 563 844 526 526 (318)(37.68 %) Total $53,638 $47,396 $43,506 $97,199 $39,806 $40,479 ($57,393)(59.05 %) City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Fire - Fire REP (RAD) Page 50 55 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$97,822 -----0.00 % 4230.102 - Intergovern-State-Operating - MSA Maint 926,666 1,014,012 930,072 850,000 960,000 990,000 110,000 12.94 % 4270 - Intergovern-Local-Operating -990 -----0.00 % 4330.500 - Utility Charges - Street Lighting 735,156 743,731 413,311 750,000 750,000 750,000 -0.00 % 4330.800 - Utility Charges - Penalties 5,770 4,173 3,325 7,000 7,000 7,000 -0.00 % 4350.113 - General Services - Grave Openings 265 305 110 -300 300 300 100.00 % 4355 - Developer Fees -1,355 443 4,000 2,000 2,000 (2,000)(50.00 %) 4800 - Other Revenues 5 3 -----0.00 % 4801 - Administrative Fee 7 ------0.00 % 4807 - Refunds & Reimbursements 25,283 18,831 2,702 10,000 10,000 10,000 -0.00 % 4900.100 - Transfers In - General -1,777 -----0.00 % 4900.413 - Transfers In - Improvement Project Construction 104,571 23,602 -150,000 40,000 40,000 (110,000)(73.33 %) Total $1,797,722 $1,906,601 $1,349,963 $1,771,000 $1,769,300 $1,799,300 ($1,700)(.10 %) Expenses 6000 - Salaries $18,191 ($3,543)-----0.00 %2023: Regular salaries: requested new mtce worker position in 2023 6000.100 - Salaries - Regular 1,088,957 1,185,443 784,676 1,274,969 1,282,607 1,402,291 7,638 .60 % 6000.200 - Salaries - Temporary 16,544 36,472 21,307 41,366 43,005 43,875 1,639 3.96 % 6020.100 - Overtime/Comp Time 114,264 82,912 27,316 120,000 120,000 120,000 -0.00 % 6030.100 - Other Pay - Comp Time (3,290)------0.00 % 6030.200 - Other Pay - Premium Pay 3,555 2,680 1,050 4,000 4,000 4,000 -0.00 % 6030.300 - Other Pay - Equipment Pay 1,836 839 776 2,300 2,300 2,300 -0.00 % 6050 - Benefits 2,223 (537)-----0.00 % 6050.100 - Benefits - Social Security 72,451 77,334 49,657 89,275 89,794 97,100 519 .58 % 6050.101 - Benefits - Medicare 16,973 18,125 11,613 21,021 21,191 22,934 170 .81 % 6050.200 - Benefits - PERA 90,694 96,702 58,654 108,193 108,897 117,933 704 .65 % 6050.550 - Benefits - Cell Phone Allowance 7,197 7,886 5,184 7,320 9,120 9,120 1,800 24.59 % 6050.570 - Benefits - Car Allowance 241 232 156 240 240 240 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 187,088 195,043 125,334 224,850 248,147 295,872 23,297 10.36 % 6060.500 - Medical Insurance - Cash Out to VEBA -51 -----0.00 % 6070.100 - Dental Insurance - Employer Contribution 9,508 8,764 6,090 10,652 10,863 12,727 211 1.98 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Public Works - Street Maintenance Page 51 56 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6080.100 - Group Life Insurance - Employer Contribution 1,799 1,894 1,178 1,878 1,948 2,048 70 3.73 % 6100 - Office Supplies 837 275 128 500 900 900 400 80.00 % 6120.102 - Operating Supplies - Motor Fuels & Lubricants 1,096 318 303 2,200 2,200 2,200 -0.00 % 6130 - Repair & Maint Supplies 16 ------0.00 % 6130.100 - Repair & Maint Supplies - Equipment Parts 3,015 5,428 1,519 5,400 5,400 5,400 -0.00 % 6130.101 - Repair & Maint Supplies - Horticulture 1,597 1,742 2,016 3,100 3,100 3,100 -0.00 % 6130.102 - Repair & Maint Supplies - Traffic & Park Signs 29,367 51,744 30,233 34,000 34,000 34,000 -0.00 % 6130.104 - Repair & Maint Supplies - Sand and Gravel 182 --5,000 3,000 3,000 (2,000)(40.00 %) 6130.105 - Repair & Maint Supplies - Paint 385 737 365 2,500 500 500 (2,000)(80.00 %)2022: Decreased to align with history. 6130.106 - Repair & Maint Supplies - Lumber 3,483 729 52 600 1,000 1,000 400 66.67 % 6130.107 - Repair & Maint Supplies - Concrete & Asphalt 87,345 84,952 31,672 100,000 100,000 100,000 -0.00 % 6130.108 - Repair & Maint Supplies - Concrete Disposal 293 --500 500 500 -0.00 % 6130.111 - Repair & Maint Supplies - Chemicals 409,649 277,668 92,161 300,000 300,000 320,000 -0.00 %2023: Material cost increase. 6130.120 - Repair & Maint Supplies - Mailbox Repairs 14,947 6,489 2,071 10,000 10,000 10,000 -0.00 % 6130.121 - Repair & Maint Supplies - Sprinkler Head Repairs ---1,500 1,500 1,500 -0.00 % 6140 - Miscellaneous Supplies -10 -----0.00 % 6140.101 - Miscellaneous Supplies - Clothing 1,252 3,012 339 1,100 2,000 2,000 900 81.82 % 6140.102 - Miscellaneous Supplies - Safety Equipment 6,188 6,165 1,740 6,400 6,400 6,400 -0.00 % 6500.100 - Employee Development - Training 7,255 3,931 2,538 5,000 5,000 5,000 -0.00 % 6550 - Mileage & Parking Reimbursement -23 -----0.00 % 6700 - Dues & Subscriptions 3,380 250 -200 250 250 50 25.00 % 7000 - Professional Services 4,584 9,761 5,751 8,000 10,000 10,000 2,000 25.00 % 7017 - Laundered Uniforms 3,779 4,043 2,307 4,200 4,500 4,500 300 7.14 % 7100.100 - Communications - Postage 12 11 478 160 100 100 (60)(37.50 %) City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Public Works - Street Maintenance Page 52 57 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7100.102 - Communications - Data Communications 6,524 --2,000 --(2,000)(100.00 %) 7100.104 - Communications - Mobile Telephone -120 160 ----0.00 % 7200 - Printing & Publishing -225 -500 500 500 -0.00 % 7400.101 - Utilities - Traffic Lights 55,351 50,486 34,229 60,000 60,000 60,000 -0.00 % 7400.102 - Utilities - Natural Gas 7,732 5,495 3,795 8,000 8,000 8,000 -0.00 % 7400.108 - Utilities - Electric 9,098 13,007 5,329 10,500 10,500 10,500 -0.00 % 7400.109 - Utilities Street Lights - Billable 641,102 695,984 370,697 680,000 700,000 700,000 20,000 2.94 % 7400.110 - Utilities Street Lights - Nonbillable 45,015 50,363 24,215 48,000 50,000 50,000 2,000 4.17 % 7500.108 - Repair & Maint Services - Snow Plowing 341,157 238,055 109,038 418,500 418,500 418,500 -0.00 % 7500.110 - Repair & Maint Services - Street Striping 47,375 112,751 58,331 100,000 125,000 125,000 25,000 25.00 % 7500.114 - Repair & Maint Services - Retaining Walls/Guard Rails/Fence 2,269 1,701 16 10,000 10,000 10,000 -0.00 % 7500.134 - Repair & Maint Services - Crack Sealing 160,346 124,753 16,995 200,000 200,000 200,000 -0.00 % 7500.140 - Repair & Maint Services - Traffic Signals 27,392 43,641 18,954 40,000 40,000 40,000 -0.00 % 7500.146 - Repair & Maint Services - Fog Sealing 76,285 98,100 47,143 150,000 150,000 150,000 -0.00 % 7500.149 - Repair & Maint Services - Bridge Maint ----50,000 50,000 50,000 100.00 %2022: Bridge maintenance to decks, rails, etc. 7500.200 - Repair & Maint Services - Software 125 ------0.00 % 7500.201 - Repair & Maint Services - Departmental Software Maint ---1,000 --(1,000)(100.00 %) 7500.202 - Repair & Maint Services - Equipment Maint 2,287 1,541 157 1,500 3,000 3,000 1,500 100.00 %2022: Increase to align with history. 7500.304 - Repair & Maint Services - Tree Grinding 17,739 ------0.00 % 7600 - Rentals 3,733 2,481 (748)3,000 3,000 3,000 -0.00 % 8000 - Non-Cap Equip (< 5K)8,130 7,423 4,517 7,000 7,000 7,000 -0.00 % 8100.500 - Capital Outlay (> 5K) - Machinery & Equipment 58,146 2,693 -----0.00 % 9000.101 - Allocations - Information Technology 39,059 39,059 26,821 40,231 41,438 42,681 1,207 3.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Public Works - Street Maintenance Page 53 58 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 9000.102 - Allocations - Facilities Management 153,639 153,639 105,499 158,248 162,995 167,885 4,747 3.00 % 9000.107 - Allocations - Central Equipment 992,646 992,646 681,617 1,022,425 1,053,098 1,084,691 30,673 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium (19,270)28,613 13,329 19,993 (5,706)(5,577)(25,699)(128.54 %) 9000.111 - Allocations - Risk Mgmt - Claims 68,320 6,713 18,671 28,007 30,943 30,943 2,936 10.48 % 9500.620 - Transfers Out - Information Technology 955 65 132 ----0.00 % 9917 - Bad Debt 29 13 -----0.00 % 9920.100 - Bank Fees - Credit Card 1,955 2,673 1,632 2,100 3,000 3,000 900 42.86 % 9920.150 - Bank Fees - PSN 502 500 267 500 500 500 -0.00 % Total $4,954,531 $4,840,327 $2,807,461 $5,407,928 $5,554,230 $5,800,413 $146,302 2.71 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Public Works - Street Maintenance Page 54 59 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4150 - Permits $2,878 ------0.00 % 4150.600 - Permits - Plan Checking 160 558 940 500 500 500 -0.00 % 4150.750 - Permits - Grading 646 1,551 3,063 1,500 1,500 1,500 -0.00 % 4200 - Intergovern- Federal - Operating --62 ----0.00 % 4350.123 - General Services - Application Fees -1,500 900 -1,000 1,000 1,000 100.00 %2022: Developer Funded Studies 4350.128 - General Services - Encroachment Fees 1,350 450 1,800 1,000 600 600 (400)(40.00 %) 4355 - Developer Fees -43,991 29,386 85,000 50,000 50,000 (35,000)(41.18 %) 4380.301 - Allocation Charges - Project Administrative Fee 995,445 790,333 -1,035,000 720,000 953,000 (315,000)(30.43 %) 4801 - Administrative Fee 43,880 ------0.00 % 4805 - Gain (Loss) of Capital Asset 3,600 ------0.00 % 4807 - Refunds & Reimbursements 11,249 ------0.00 % Total $1,059,207 $838,383 $36,150 $1,123,000 $773,600 $1,006,600 ($349,400)(31.11 %) Expenses 6000 - Salaries $8,314 $23,418 -----0.00 %2022: Temp salaries: increase due to adding second engineering intern. OT/comp: increase to align with history and new union contract provisions. 6000.100 - Salaries - Regular 463,194 587,842 433,008 683,533 708,577 733,058 25,044 3.66 % 6000.200 - Salaries - Temporary 27,774 13,702 8,206 17,687 35,590 36,650 17,903 101.22 % 6020.100 - Overtime/Comp Time 25,117 25,187 31,950 17,500 29,300 29,300 11,800 67.43 % 6030.100 - Other Pay - Comp Time 727 ------0.00 % 6050 - Benefits 1,370 3,548 -----0.00 % 6050.100 - Benefits - Social Security 31,418 38,084 28,802 42,564 45,292 46,147 2,728 6.41 % 6050.101 - Benefits - Medicare 7,462 9,063 6,736 10,506 11,305 11,677 799 7.61 % 6050.200 - Benefits - PERA 36,906 45,819 34,872 53,907 58,012 59,926 4,105 7.61 % 6050.550 - Benefits - Cell Phone Allowance 3,673 4,969 3,410 4,716 5,316 5,316 600 12.72 % 6050.570 - Benefits - Car Allowance 964 928 624 960 960 960 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 54,095 67,697 53,802 85,035 91,290 100,036 6,255 7.36 % 6060.500 - Medical Insurance - Cash Out to VEBA -204 -----0.00 % 6070.100 - Dental Insurance - Employer Contribution 2,125 3,063 2,068 4,436 3,365 3,534 (1,071)(24.14 %) 6080.100 - Group Life Insurance - Employer Contribution 915 1,140 876 1,585 1,611 1,626 26 1.64 % 6100 - Office Supplies 1,153 394 489 1,000 1,000 1,000 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Public Works - Engineering Page 55 60 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6120.102 - Operating Supplies - Motor Fuels & Lubricants 495 1,266 -500 500 500 -0.00 % 6120.112 - Operating Supplies - Survey 156 230 859 2,500 2,500 2,500 -0.00 % 6140.101 - Miscellaneous Supplies - Clothing -205 48 -200 200 200 100.00 % 6500.100 - Employee Development - Training 13,907 7,570 2,607 11,000 12,500 12,500 1,500 13.64 % 6550 - Mileage & Parking Reimbursement 10 8 113 300 300 300 -0.00 % 6700 - Dues & Subscriptions 2,271 1,001 292 3,500 3,500 3,500 -0.00 % 6700.109 - Dues & Subscriptions - Software -3,931 -----0.00 % 7000 - Professional Services 120,313 83,282 1,678 10,000 10,000 10,000 -0.00 % 7001 - Consulting Engineer 4,541 4,695 5,284 10,000 15,000 30,000 5,000 50.00 %2022: Traffic Engineering Support 2023: 4-Year State Traffic Counts 7100.100 - Communications - Postage 2,686 1,382 256 2,000 2,500 2,500 500 25.00 %2022: Increase to align with history. 7100.102 - Communications - Data Communications 360 5 -----0.00 % 7100.104 - Communications - Mobile Telephone -937 -----0.00 % 7200 - Printing & Publishing 212 174 684 600 300 300 (300)(50.00 %)2022: Decrease to align with history. 7500.200 - Repair & Maint Services - Software 686 1,250 -----0.00 % 7500.201 - Repair & Maint Services - Departmental Software Maint 72 343 1,636 ----0.00 % 7500.202 - Repair & Maint Services - Equipment Maint 219 960 -----0.00 % 8000 - Non-Cap Equip (< 5K)(42,500)605 1,941 2,500 2,500 2,500 -0.00 % 8100.500 - Capital Outlay (> 5K) - Machinery & Equipment 101,371 ------0.00 % 9000.101 - Allocations - Information Technology 89,140 89,140 61,209 91,814 94,568 97,405 2,754 3.00 % 9000.102 - Allocations - Facilities Management 37,763 37,763 25,931 38,896 40,063 41,265 1,167 3.00 % 9000.107 - Allocations - Central Equipment 17,750 17,750 12,189 18,283 18,831 19,396 548 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 2,897 3,978 2,531 3,797 5,460 5,513 1,663 43.80 % 9000.111 - Allocations - Risk Mgmt - Claims 8,928 -(88)(132)--132 (100.00 %) 9920.100 - Bank Fees - Credit Card -84 54 -100 100 100 100.00 % Total $1,026,485 $1,081,617 $722,066 $1,118,987 $1,200,440 $1,257,709 $81,453 7.28 % City of Plymouth 2022/2023 Biennial Budget Detail General Fund - Budgeted Revenues and Expenditures Public Works - Engineering Page 56 61 2019 Amended FTE 2020 Adopted FTE 2021 Amended FTE 2022 Adopted FTE 2023 Concept FTE 2.0 2.0 2.0 2.0 2.0 1.5 1.5 1.5 1.5 1.5 3.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 3.8 3.8 4.8 4.8 4.8 9.0 9.0 9.0 9.0 9.0 0.0 0.0 0.0 0.0 0.0 4.8 4.8 4.8 4.8 4.8 4.4 4.4 4.4 4.4 4.4 10.0 10.0 10.0 10.0 10.0 4.9 3.9 3.9 3.9 3.9 21.9 23.9 23.9 24.4 24.4 4.0 4.3 5.1 6.5 7.5 13.3 12.8 11.8 11.8 11.8 59.8 59.8 59.8 59.8 59.8 22.8 23.1 25.1 25.1 25.1 21.5 24.5 27.5 27.5 30.0 0.0 0.0 0.0 0.0 0.0 18.0 18.0 18.0 18.0 19.0 6.8 6.9 6.9 6.8 6.8 215.2 220.3 226.2 228.0 232.5 Fire Duty Crew Street Maintenance Engineering PD Administration PD Patrol PD Services Fire Operations Parks & Rec Admin Parks & Forestry Plymouth Community Center CD Administration and Support Planning Inspections City Clerk Human Resources Finance Assessing City of Plymouth 2022 Adopted Budget FTE Summary by Division Division City Manager Economic Development Communication Services Page 57 62 Account CategoryActual2018Actual2019Actual2020Budget Amended2021Budget Proposed2022Budget Amended - Proposed Variance %2021-2022Budget Proposed - Proposed Variance %2022-2023General Property Taxes 1,219,089 1,246,879 1,300,935 1,345,649 1,394,7273.6%4.3%Intergovernmental8,187,533 8,236,479 10,108,077 8,349,864 8,902,6566.6%1.8%Charges for Services2,524,633 2,590,038 996,679 2,516,180 2,302,170-8.5%13.1%Contributions & Donations - Operating20,63325,66218,250 15,00018,00020.0%3.0%Interest Income191,724 478,562480,542 136,400 118,000-13.5%0.1%Other54,15045,380 3,919,918 23,70026,50011.8%6.7%Transfers In--9,372 209,334 100,000-52.2% 441.1%$12,197,762 $12,623,000 $16,833,774 $12,596,127 $12,862,0532.1%7.5%Personal Services1,796,143 1,785,584 1,827,213 2,106,603 2,262,2317.4%5.1%Materials and Supplies623,681 544,851 300,798 634,718 562,100-11.4%2.5%Employee Development & Meetings8,5418,7524,533 18,05022,60025.2%-13.9%Dues & Subscriptions12,13214,03717,747 14,50017,50020.7%0.0%Contractual Services4,808,667 5,054,515 4,290,240 5,948,075 5,666,206-4.7%1.0%Equipment72,57032,94933,087 124,50084,500-32.1%23.8%Capital Improvements25,080- 359,136- 100,000100.0% 900.0%Allocations219,455 224,871 245,096 216,575 237,0819.5%2.9%Transfers Out856,588 240,000 215,000 333,090 354,8646.5%0.8%Other Expense3,075,328 3,159,471 7,299,564 3,200,016 3,554,97111.1%-4.3%$11,498,185 $11,065,031 $14,592,412 $12,596,127 $12,862,0532.1%7.5%Total$13,824,2539000243,8959500357,69699003,403,681$13,824,253Expenses60002,377,6216100576,200650019,450670017,50070005,723,5758000104,63581001,000,000 Revenues40001,454,19742009,059,15043002,604,874460018,5404700118,100480028,2854900541,107TotalCity of Plymouth2022 Adopted BudgetBudget by CategoryBudget Proposed2023Page 5863 Fund Actual 2020 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Budget Variance $ 2022-2023 Budget Variance % 2022-2023 Revenue Recreation Fund 1,529,459 2,148,792 2,462,944 2,466,862 314,152 14.62 %3,918 .16 % Transit System 6,960,735 6,361,616 6,018,000 6,950,902 (343,616)(5.40 %)932,902 15.50 % Community Dev Block Grant (CDBG) 567,932 432,675 373,263 353,602 (59,412)(13.73 %)(19,661)(5.27 %) HRA Section 8 3,190,299 3,005,539 3,308,856 3,332,555 303,317 10.09 %23,699 .72 % HRA General 4,585,350 647,505 698,990 720,332 51,485 7.95 %21,342 3.05 % Total $16,833,774 $12,596,127 $12,862,053 $13,824,253 $265,926 2.11 %$962,200 7.48 % City of Plymouth 2022/2023 Biennial Budget Summary Budgeted Revenues and Expenditures by Fund Page 59 64 Fund Actual 2020 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Budget Variance $ 2022-2023 Budget Variance % 2022-2023 Expenses Recreation Fund 1,670,783 2,148,792 2,462,944 2,466,862 314,152 14.62 %3,918 .16 % Transit System 4,383,955 6,361,616 6,018,000 6,950,902 (343,616)(5.40 %)932,902 15.50 % Community Dev Block Grant (CDBG) 546,821 432,675 373,263 353,602 (59,412)(13.73 %)(19,661)(5.27 %) HRA Section 8 3,155,116 3,005,539 3,308,856 3,332,555 303,317 10.09 %23,699 .72 % HRA General 4,835,738 647,505 698,990 720,332 51,485 7.95 %21,342 3.05 % Total $14,592,412 $12,596,127 $12,862,053 $13,824,253 $265,926 2.11 %$962,200 7.48 % City of Plymouth 2022/2023 Biennial Budget Summary Budgeted Revenues and Expenditures by Fund Page 60 65 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4000.100 - Taxes - Property $662,089 $700,378 $381,624 $738,832 $775,774 $814,563 $36,942 5.00 %2022: 5% Increase to assist with benefit and allocation increase 2023: 5% Increase to assist with benefit and allocation increase 4200 - Intergovern- Federal - Operating -94,967 -----0.00 % 4230.100 - Intergovern-State-Operating - Mkt Value Credit (HACA) 7 6 -----0.00 % 4310.100 - Program Fees - Recreation 1,303,553 648,902 713,392 1,210,428 1,439,770 1,500,057 229,342 18.95 %2022: Increase for 7 months due to PCC project completion in June 2023: Increase for full year due to PCC Expansion 4310.101 - Program Fees - Subsidized Recreation 91 17 -----0.00 % 4320.100 - Rental Fees - Recreation 71,114 30,817 28,891 80,000 85,000 88,000 5,000 6.25 %2022: Fee increase and NWG Pavilion added for rentals 2023: 3% increase from 2022 projections 4360.105 - Items for Resale - Caps & Apparel 12,169 121 2,903 12,181 13,900 14,317 1,719 14.11 %2022: Fees for dance costumes and items for resale offset with expenses from line item 6120.125 2023: Fees for dance costumes and items for resale offset with expenses from line item 6120.125 4600 - Contributions - Operating 25,662 18,250 2,580 15,000 18,000 18,540 3,000 20.00 %2022: Variable amount for Sponsorships-not guaranteed revenue source 2023: Variable amount for Sponsorships-not guaranteed revenue source 4700.100 - Interest Income - Investments 30,663 25,251 (3,083)5,200 20,000 20,600 14,800 284.62 % 4700.150 - Interest Income - Operating Account 1,368 187 8 800 1,000 1,000 200 25.00 % 4800 - Other Revenues 1,976 38 130 ----0.00 % 4800.400 -Other Revenues - Commissions 675 --1,200 1,000 1,030 (200)(16.67 %)2022: Fees received for commissions on food trucks at events 2023: Fees received for commissions on food trucks at events 4801 - Administrative Fee 8,094 5,038 6,605 9,000 8,500 8,755 (500)(5.56 %)2022: Fees for program cancellations/transfers 2023: Fees for program cancellations/transfers 4807 - Refunds & Reimbursements 141 -4 ----0.00 % 4900 - Transfers In ---76,151 100,000 -23,849 31.32 % 4900.100 - Transfers In - General -5,488 -----0.00 % Total $2,117,600 $1,529,459 $1,133,053 $2,148,792 $2,462,944 $2,466,862 $314,152 14.62 % Expenses 6000 - Salaries ($10,584)$14,607 -----0.00 %2022: Temp salaries: market adj (offset by revenue) and 2/3 temp program coord position 6000.100 - Salaries - Regular 624,202 653,840 473,590 792,136 876,251 909,078 84,115 10.62 % 6000.200 - Salaries - Temporary 292,659 235,628 226,469 321,570 357,292 391,336 35,722 11.11 % 6020.100 - Overtime/Comp Time ---200 200 200 -0.00 % 6050 - Benefits (1,604)2,213 -----0.00 % 6050.100 - Benefits - Social Security 55,067 54,051 42,481 69,328 76,757 80,909 7,429 10.72 % 6050.101 - Benefits - Medicare 12,878 12,641 9,935 16,215 17,951 18,921 1,736 10.71 % City of Plymouth 2022/2023 Biennial Budget Detail Recreation Fund - Budgeted Revenues and Expenditures Recreation Fund Page 61 66 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6050.200 - Benefits - PERA 51,300 56,232 38,348 67,663 70,543 73,052 2,880 4.26 % 6050.302 - Benefits - Unemployment 1,606 234 -2,000 2,000 2,000 -0.00 % 6050.550 - Benefits - Cell Phone Allowance 3,394 3,488 2,544 4,320 4,320 4,320 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 101,958 79,275 56,429 99,878 104,047 113,362 4,169 4.17 % 6070.100 - Dental Insurance - Employer Contribution 5,201 5,743 4,062 7,434 7,016 7,367 (418)(5.62 %) 6080.100 - Group Life Insurance - Employer Contribution 2,060 2,082 1,497 2,993 3,078 3,152 85 2.84 % 6100 - Office Supplies 687 576 471 1,000 1,000 1,000 -0.00 %2022: Office Supplies as needed 2023: Office Supplies as needed 6120 - Operating Supplies 44,299 64,103 38,260 39,000 45,000 45,000 6,000 15.38 %2022: Increase to support additional program supplies due to the PCC expansion 2023: Program Operating supplies 6120.125 - Operating Supplies - Resale 13,445 5,397 4,046 11,380 13,500 13,500 2,120 18.63 %2022: Increase to support additional expenses for dance uniforms bought-supported by revenue line item 4360.105 2023: Dance uniforms 6140 - Miscellaneous Supplies 442 18 -----0.00 % 6140.101 - Miscellaneous Supplies - Clothing 19,974 13,914 7,628 17,517 20,900 21,000 3,383 19.31 %2022: Increase to support 2019 actuals and additional PCC programs 2023: Increase to support 2019 actuals and additional PCC programs 6500.100 - Employee Development - Training 3,999 1,923 679 7,000 10,000 7,500 3,000 42.86 %2022: Increase to support additional staff (3 full time staff). Training for 13 full-time employees. MRPA- outstate in 2022 2023: MRPA-Instate in 2023 6550 - Mileage & Parking Reimbursement 80 48 317 500 550 550 50 10.00 % 6700 - Dues & Subscriptions 3,716 3,261 752 2,000 4,000 4,000 2,000 100.00 %2022: Movie and Music License, MRPA Membership, Online Brochure subscription 2023: Movie and Music License, MRPA Membership, Online Brochure subscription 7000 - Professional Services 454,715 172,024 242,049 380,000 427,606 440,435 47,606 12.53 %2022: Increase to support programs, special events and PCC expansion 2023: 3% increase form 2022 7050 - External Program Registrations 1,471 1,473 5,010 2,295 2,000 2,000 (295)(12.85 %)2022: Registrations for American RedCross, State Softball, Basketball and Tennis 2023: Registrations for American RedCross, State Softball, Basketball and Tennis 7100.100 - Communications - Postage 18,325 22,379 9,170 18,000 23,000 23,690 5,000 27.78 %2022: Brochure Postage to reflect 2020 actuals 2023: Brochure Postage-3% Increase from 2022 7100.104 - Communications - Mobile Telephone --240 ----0.00 % 7200 - Printing & Publishing 1,734 2,901 1,696 2,000 3,200 3,296 1,200 60.00 %2022: Increase to support program and special event printing and publishing 2023: 3% increase from 2022 to support program and special event printing and publishing City of Plymouth 2022/2023 Biennial Budget Detail Recreation Fund - Budgeted Revenues and Expenditures Recreation Fund Page 62 67 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7200.101 - Printing & Publishing - Recreation Handbook 44,250 53,836 22,850 46,000 54,000 55,620 8,000 17.39 %2022: Printing of 3 activity brochures. Brochures are now 90+ pages due to additional program offerings. 2023: Printing of 3 activity brochures. Brochures are now 90+ pages due to additional program offerings. 7500.201 - Repair & Maint Services - Departmental Software Maint -56 -----0.00 % 7500.202 - Repair & Maint Services - Equipment Maint -770 -300 300 309 -0.00 %2022: Expense as needed for sound system maintenence 2023: Expense as needed for sound system maintenence 7600 - Rentals 89,603 63,451 21,676 90,000 92,500 95,275 2,500 2.78 %2022: Program and event rentals (buses, tickets for programs, portable restrooms, etc) 2023: Program and event rentals (buses, tickets for programs, portable restrooms, etc) 8000 - Non-Cap Equip (< 5K)429 21,223 5,123 4,500 4,500 4,635 -0.00 %2022: Program/special event equipment 2023: Program/special event equipment 8100 - Capital Outlay (> 5K)-------0.00 %2022: Capital is for an electronic reader board at Northwest Greenway 8100.500 - Capital Outlay (> 5K) - Machinery & Equipment ----100,000 -100,000 100.00 % 9000.101 - Allocations - Information Technology 76,430 76,430 52,482 78,723 81,085 83,518 2,362 3.00 % 9000.102 - Allocations - Facilities Management 12,442 12,442 8,543 12,815 13,199 13,595 384 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 5,646 12,877 2,519 3,778 5,282 5,385 1,504 39.81 % 9000.111 - Allocations - Risk Mgmt - Claims 2,754 84 3,365 5,047 167 167 (4,880)(96.69 %) 9900.100 - Miscellaneous - Cash Over/Short -19 -----0.00 % 9903 - Scholarships 7,818 2,981 6,588 9,000 8,500 8,500 (500)(5.56 %)2022: Scholarship program for low-income households 2023: Scholarship program for low-income households 9920.100 - Bank Fees - Credit Card 31,869 18,450 19,488 34,000 33,000 33,990 (1,000)(2.94 %)2022: Increase for additional program registrations online 2023: Increase for additional program registrations online 9920.150 - Bank Fees - PSN 58 37 22 75 75 75 -0.00 % 9920.160 - Bank Fees - Operating Acct 89 60 34 100 100 100 -0.00 % 9920.170 - Bank Fees - Investments 24 18 9 25 25 25 -0.00 % Total $1,972,436 $1,670,783 $1,308,373 $2,148,792 $2,462,944 $2,466,862 $314,152 14.62 % City of Plymouth 2022/2023 Biennial Budget Detail Recreation Fund - Budgeted Revenues and Expenditures Recreation Fund Page 63 68 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$1,192,311 -----0.00 % 4230 - Intergovern-State-Operating 4,971,175 5,070,377 3,449,510 4,952,146 5,229,000 5,385,000 276,854 5.59 %2022: Based on MVTS 2021 Forecast 2023: Based on MVTS 2021 Forecast 4350.120 - General Services - Transit Fares 1,153,174 286,356 80,472 1,142,471 692,000 923,000 (450,471)(39.43 %)2022: 60% of Pre-Covid Revenue 2023: 80% of Pre-Covid Revenue 4350.129 - General Services Dial-A-Ride Ticket Sales 40,038 18,807 15,180 61,200 24,000 32,000 (37,200)(60.78 %)2022: 60% of Pre-Covid Revenue 2023: 80% of Pre-Covid Revenue 4355 - Developer Fees --256 ----0.00 % 4700.100 - Interest Income - Investments 353,787 384,551 (38,731)100,000 70,000 70,000 (30,000)(30.00 %) 4700.150 - Interest Income - Operating Account 15,425 2,522 118 5,000 3,000 3,000 (2,000)(40.00 %) 4807 - Refunds & Reimbursements 858 1,926 -----0.00 % 4900 - Transfers In ---100,799 --(100,799)(100.00 %) 4900.050 - Transfers In - Reserves -----537,902 -0.00 % 4900.100 - Transfers In - General -3,884 -----0.00 % Total $6,534,457 $6,960,735 $3,506,806 $6,361,616 $6,018,000 $6,950,902 ($343,616)(5.40 %) Expenses 6000 - Salaries $857 $3,047 -----0.00 % 6000.100 - Salaries - Regular 101,259 107,216 74,291 110,833 113,749 117,165 2,916 2.63 % 6000.200 - Salaries - Temporary 9,086 6,003 3,707 12,485 9,000 9,000 (3,485)(27.91 %) 6050 - Benefits 130 462 -----0.00 % 6050.100 - Benefits - Social Security 6,493 6,677 4,571 7,720 7,685 7,897 (35)(.45 %) 6050.101 - Benefits - Medicare 1,519 1,562 1,819 1,805 1,798 1,847 (7)(.39 %) 6050.200 - Benefits - PERA 8,276 8,478 5,850 9,248 9,206 9,462 (42)(.45 %) 6050.550 - Benefits - Cell Phone Allowance 1,205 1,160 803 1,200 1,200 1,200 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 14,107 14,038 10,011 15,069 16,965 19,278 1,896 12.58 % 6070.100 - Dental Insurance - Employer Contribution --8 ----0.00 % 6080.100 - Group Life Insurance - Employer Contribution 356 372 255 456 458 469 2 .44 % 6100 - Office Supplies ---800 800 800 -0.00 % 6120 - Operating Supplies -830 -----0.00 % 6120.102 - Operating Supplies - Motor Fuels & Lubricants 465,352 215,207 132,394 563,921 480,000 494,000 (83,921)(14.88 %) 6120.103 - Operating Supplies - Janitorial 252 ------0.00 % City of Plymouth 2022/2023 Biennial Budget Detail Transit System - Budgeted Revenues and Expenditures Transit System Page 64 69 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6130.119 - Repair & Maint Supplies - Recharges 43 ------0.00 % 6500.100 - Employee Development - Training 1,556 200 -3,500 4,000 4,000 500 14.29 % 6550 - Mileage & Parking Reimbursement 168 --600 1,000 1,000 400 66.67 % 6600 - Meetings 99 --350 1,000 350 650 185.71 % 6700 - Dues & Subscriptions 9,500 9,500 9,500 11,000 12,000 12,000 1,000 9.09 % 7000 - Professional Services -13,001 129,424 135,000 150,000 20,000 15,000 11.11 %2022: Route Planning Study 7003 - Legal 842 1,286 4,107 1,500 2,000 2,000 500 33.33 % 7015 - Transit Services 4,218,472 3,663,117 2,180,465 4,830,486 4,567,000 4,704,000 (263,486)(5.45 %)2022: 2019 Actual cost + 8% for rate increase and anticipated revenue hours increase. 2023: 2022+3% increase. 7015.100 - Transit Services - Special Events/Public Outreach 1,773 1,262 5,285 5,000 5,000 5,000 -0.00 % 7100.100 - Communications - Postage 7 122 5 50 50 50 -0.00 % 7100.102 - Communications - Data Communications 1,110 --15,000 --(15,000)(100.00 %)2022: Included in IT Allocation 7100.104 - Communications - Mobile Telephone -1,440 -----0.00 % 7200 - Printing & Publishing 2,041 4,006 2,371 6,365 8,000 8,000 1,635 25.69 % 7400.102 - Utilities - Natural Gas 560 546 367 700 1,000 1,000 300 42.86 % 7400.103 - Utilities - Water & Sewer 2,374 2,308 637 2,500 3,000 3,000 500 20.00 % 7400.108 - Utilities - Electric 20,607 18,539 12,021 22,000 22,000 22,000 -0.00 % 7500 - Repair & Maint Services 3,300 3,600 1,635 ----0.00 % 7500.118 - Repair & Maint Services - Janitorial Services 4,730 -1,932 -3,500 3,500 3,500 100.00 % 7500.130 - Repair & Maint Services - Building Maint 24,246 ------0.00 % 7500.132 - Repair & Maint Services - Transit Facility 42,475 91,382 52,473 200,000 100,000 100,000 (100,000)(50.00 %) 7500.135 - Repair & Maint Services - Building Security 948 ------0.00 % 7500.139 - Repair & Maint Services - Facility Improvements 541 ------0.00 % 7500.200 - Repair & Maint Services - Software 23,491 28,573 20,000 60,000 60,000 75,000 -0.00 %2022: New Dial-a-Ride Software & Adding 2 buses. 7500.202 - Repair & Maint Services - Equipment Maint 2,022 -525 8,000 4,500 4,500 (3,500)(43.75 %) 7600 - Rentals 65,976 67,851 57,830 76,000 80,000 90,000 4,000 5.26 % City of Plymouth 2022/2023 Biennial Budget Detail Transit System - Budgeted Revenues and Expenditures Transit System Page 65 70 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 8000 - Non-Cap Equip (< 5K)30,583 7,186 628 120,000 80,000 100,000 (40,000)(33.33 %) 8100 - Capital Outlay (> 5K)-------0.00 %2023: HWY 55 underpass at Station 73 8100.100 - Capital Outlay (> 5K) - Land --6,892,804 ----0.00 % 8100.300 - Capital Outlay (> 5K) - Buildings -18,000 -----0.00 % 8100.800 - Capital Outlay (> 5K) - Construction Projects -----1,000,000 -0.00 % 9000.101 - Allocations - Information Technology 41,208 41,208 28,296 42,444 43,717 45,029 1,273 3.00 % 9000.102 - Allocations - Facilities Management 1,377 1,377 945 1,418 1,461 1,505 43 3.03 % 9000.103 - Allocations - General Fund Administrative 27,198 27,198 18,676 28,014 28,854 29,720 840 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 3,991 4,039 3,004 4,506 5,997 6,005 1,491 33.09 % 9918 - Contingency -11,220 -62,171 190,935 50,000 128,764 207.11 % 9919 - Administration Fees 1,643 605 936 -650 650 650 100.00 % 9920.100 - Bank Fees - Credit Card 64 34 1 100 100 100 -0.00 % 9920.150 - Bank Fees - PSN 51 19 10 75 75 75 -0.00 % 9920.160 - Bank Fees - Operating Acct 963 995 454 1,000 1,000 1,000 -0.00 % 9920.170 - Bank Fees - Investments 261 291 123 300 300 300 -0.00 % Total $5,143,113 $4,383,955 $9,658,161 $6,361,616 $6,018,000 $6,950,902 ($343,616)(5.40 %) City of Plymouth 2022/2023 Biennial Budget Detail Transit System - Budgeted Revenues and Expenditures Transit System Page 66 71 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4000.100 - Taxes - Property $6,387 $6,560 $3,469 $6,712 $7,963 $8,302 $1,251 18.64 % 4200.200 - Intergovern- Federal - Operating - CDBG 270,483 422,622 198,344 375,163 295,000 295,000 (80,163)(21.37 %) 4200.210 - Intergovern- Federal - Operating - REHAB Loan Repayment 45,857 43,685 -30,000 30,000 30,000 -0.00 % 4200.211 - Intergovern- Federal - Operating - FTHB Loan Repayment 29,169 93,131 24,643 20,000 40,000 20,000 20,000 100.00 % 4230.100 - Intergovern-State-Operating - Mkt Value Credit (HACA) -------0.00 % 4700.100 - Interest Income - Investments 2,934 1,923 (490)750 250 250 (500)(66.67 %) 4700.150 - Interest Income - Operating Account 100 11 -50 50 50 -0.00 % Total $354,931 $567,932 $225,966 $432,675 $373,263 $353,602 ($59,412)(13.73 %) Expenses 6000 - Salaries $623 $2,278 -----0.00 % 6000.100 - Salaries - Regular 46,967 36,127 24,209 37,759 36,750 39,722 (1,009)(2.67 %) 6050 - Benefits 94 345 -----0.00 % 6050.100 - Benefits - Social Security 2,898 2,215 1,500 2,340 2,278 2,463 (62)(2.65 %) 6050.101 - Benefits - Medicare 678 518 351 548 533 575 (15)(2.74 %) 6050.200 - Benefits - PERA 3,513 2,710 1,558 2,832 2,757 2,980 (75)(2.65 %) 6060.100 - Medical Insurance - Employer Contribution 3,372 5,340 2,661 5,760 6,132 6,633 372 6.46 % 6070.100 - Dental Insurance - Employer Contribution 76 194 80 210 210 220 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 43 41 23 45 47 47 2 4.44 % 6100 - Office Supplies 162 68 -300 300 300 -0.00 % 6500.100 - Employee Development - Training 1,227 1,296 (1,140)1,500 1,500 1,500 -0.00 % 6550 - Mileage & Parking Reimbursement 12 --150 100 100 (50)(33.33 %) 6700 - Dues & Subscriptions --120 ----0.00 % 7000 - Professional Services -92 46 2,300 1,700 1,300 (600)(26.09 %) 7003 - Legal 1,388 941 155 1,500 1,500 1,500 -0.00 % 7004 - Audit Fees 3,230 3,307 3,370 3,500 3,500 3,500 -0.00 % 7100.100 - Communications - Postage 285 174 180 500 250 250 (250)(50.00 %) 7200 - Printing & Publishing 159 81 127 100 100 100 -0.00 % 8000 - Non-Cap Equip (< 5K)1,068 ------0.00 % City of Plymouth 2022/2023 Biennial Budget Detail Community Dev Block Grant (CDBG) - Budgeted Revenues and Expenditures Community Dev Block Grant (CDBG) Page 67 72 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 9000.101 - Allocations - Information Technology 3,712 3,712 2,549 3,823 3,938 4,056 115 3.01 % 9000.102 - Allocations - Facilities Management 1,377 1,377 945 1,418 1,461 1,505 43 3.03 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 332 449 220 330 406 410 76 23.03 % 9000.111 - Allocations - Risk Mgmt - Claims 1,033 ------0.00 % 9910 - Housing Loans 180,617 256,662 157,766 200,235 30,259 59,472 (169,976)(84.89 %) 9911 - Grant Awards 149,604 228,886 131,839 167,500 279,517 226,944 112,017 66.88 % 9919 - Administration Fees --3,780 ----0.00 % 9920.100 - Bank Fees - Credit Card -------0.00 % 9920.150 - Bank Fees - PSN -------0.00 % 9920.160 - Bank Fees - Operating Acct 6 6 2 15 15 15 -0.00 % 9920.170 - Bank Fees - Investments 1 2 -10 10 10 -0.00 % Total $402,478 $546,821 $330,342 $432,675 $373,263 $353,602 ($59,412)(13.73 %) City of Plymouth 2022/2023 Biennial Budget Detail Community Dev Block Grant (CDBG) - Budgeted Revenues and Expenditures Community Dev Block Grant (CDBG) Page 68 73 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4200 - Intergovern- Federal - Operating -$2,728 -----0.00 % 4200.101 - Intergovern- Federal - Operating - Section 8 - HUD Direct 1,680,673 1,859,508 1,267,024 1,715,000 1,971,678 1,987,750 256,678 14.97 % 4200.106 - Intergovern- Federal - Operating - Section 8 - Mainstream Vouchers 82,270 105,014 72,368 91,000 116,500 117,000 25,500 28.02 % 4200.107 - Intergovern- Federal - Operating - Section 8 - Fraud Recovery 9,388 5,256 4,953 2,000 3,500 1,500 1,500 75.00 % 4200.109 - Intergovern- Federal - Operating - HUD Direct Administration 198,371 211,181 163,710 184,000 246,003 246,100 62,003 33.70 % 4200.111 - Intergovern- Federal - Operating - Mainstream Administration 12,632 15,046 11,042 14,000 17,100 17,100 3,100 22.14 % 4200.112 - Intergovern- Federal - Operating - Section 8 - VASH Vouchers -30,883 10,295 37,000 --(37,000)(100.00 %)2022: No longer separate funding. Receive VASH funding with the HUD Direct - 4200.101 4270.300 - Intergovern-Local-Operating Section 8 - Rent Port 876,594 888,103 601,630 872,000 900,000 900,000 28,000 3.21 % 4270.301 - Intergovern-Local-Operating Section 8 - Admin Port 59,854 72,453 40,018 57,555 53,875 59,700 (3,680)(6.39 %) 4700.150 - Interest Income - Operating Account 871 127 7 600 200 200 (400)(66.67 %) 4900.050 - Transfers In - Reserves ---32,384 -3,205 (32,384)(100.00 %) Total $2,920,653 $3,190,299 $2,171,048 $3,005,539 $3,308,856 $3,332,555 $303,317 10.09 % Expenses 6000 - Salaries ($1,842)$549 -----0.00 % 6000.100 - Salaries - Regular 177,264 186,402 126,401 189,497 195,182 200,438 5,685 3.00 % 6050 - Benefits (279)83 -----0.00 % 6050.100 - Benefits - Social Security 10,540 11,105 7,125 11,749 12,101 12,426 352 3.00 % 6050.101 - Benefits - Medicare 2,465 2,597 1,666 2,749 2,830 2,905 81 2.95 % 6050.200 - Benefits - PERA 13,295 13,980 9,480 14,212 14,639 15,033 427 3.00 % 6060.100 - Medical Insurance - Employer Contribution 22,769 25,725 20,129 27,653 36,933 41,086 9,280 33.56 % 6070.100 - Dental Insurance - Employer Contribution 2,167 1,991 573 2,185 925 971 (1,260)(57.67 %) 6080.100 - Group Life Insurance - Employer Contribution 303 308 197 350 360 363 10 2.86 % 6100 - Office Supplies -660 -100 100 100 -0.00 % 6500 - Employee Development 695 ------0.00 % 6500.100 - Employee Development - Training 642 --1,000 1,000 1,000 -0.00 % 6550 - Mileage & Parking Reimbursement ---150 150 150 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail HRA Section 8 - Budgeted Revenues and Expenditures HRA Section 8 Page 69 74 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 6700 - Dues & Subscriptions -344 -500 500 500 -0.00 % 6700.109 - Dues & Subscriptions - Software -3,351 2,015 ----0.00 %2022: CARES Act covered these expenses 7000 - Professional Services 575 13,795 17,888 3,000 3,500 3,500 500 16.67 %2022: 2020 and 2021 expenses were high due to Covid and CARES act funding. 7003 - Legal ---500 500 500 -0.00 % 7004 - Audit Fees 7,374 8,039 8,181 8,500 8,500 8,750 -0.00 % 7005 - Accounting 3,240 3,300 2,240 3,750 3,500 3,750 (250)(6.67 %) 7100.100 - Communications - Postage 1,710 1,946 825 3,750 3,250 3,500 (500)(13.33 %) 7200 - Printing & Publishing 54 48 48 500 500 500 -0.00 % 8000 - Non-Cap Equip (< 5K)-1,676 -----0.00 % 9000.101 - Allocations - Information Technology 19,129 19,129 13,135 19,703 20,294 20,903 591 3.00 % 9000.102 - Allocations - Facilities Management 1,836 1,836 1,261 1,891 1,948 2,006 57 3.01 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 817 1,626 443 665 1,003 1,018 338 50.83 % 9000.111 - Allocations - Risk Mgmt - Claims ----1,006 1,006 1,006 100.00 % 9908.100 - Section 8 Fees - Project Based 161,761 165,293 107,888 163,000 158,000 159,000 (5,000)(3.07 %) 9908.102 - Section 8 Fees - Port-Out Rent Assist 95,563 89,266 104,192 103,000 169,000 170,000 66,000 64.08 % 9908.103 - Section 8 Fees - Port-Out Admin Fee 11,051 11,018 9,504 12,000 15,500 16,000 3,500 29.17 % 9908.104 - Section 8 Fees - Port-In Vouchers 876,594 888,103 602,364 872,000 900,000 900,000 28,000 3.21 % 9908.105 - Section 8 Fees - Mainstream M/C 108,828 115,258 76,268 112,000 117,500 118,000 5,500 4.91 % 9908.106 - Section 8 Fees - Mainstream M5 (HUD) 88,119 99,165 73,160 91,000 116,500 117,000 25,500 28.02 % 9908.107 - Section 8 Fees - Rental Vouchers 1,321,118 1,434,212 957,146 1,283,000 1,453,000 1,460,000 170,000 13.25 % 9908.108 - Section 8 Fees - Enhanced Rental 42,966 36,264 22,389 40,000 34,500 35,000 (5,500)(13.75 %) 9908.112 - Section 8 Fees - VASH Vouchers -17,481 17,778 37,000 36,000 37,000 (1,000)(2.70 %) 9911 - Grant Awards -500 11,500 ----0.00 % 9920 - Bank Fees ----135 150 135 100.00 % 9920.100 - Bank Fees - Credit Card 35 12 -50 --(50)(100.00 %) 9920.150 - Bank Fees - PSN 3 1 1 10 --(10)(100.00 %) 9920.160 - Bank Fees - Operating Acct 52 53 29 75 --(75)(100.00 %) Total $2,968,843 $3,155,116 $2,193,823 $3,005,539 $3,308,856 $3,332,555 $303,317 10.09 % City of Plymouth 2022/2023 Biennial Budget Detail HRA Section 8 - Budgeted Revenues and Expenditures HRA Section 8 Page 70 75 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Revenue 4000.100 - Taxes - Property $578,403 $593,997 $310,545 $600,105 $610,990 $631,332 $10,885 1.81 % 4200 - Intergovern- Federal - Operating -800 -----0.00 % 4230.100 - Intergovern-State-Operating - Mkt Value Credit (HACA) 6 5 -----0.00 % 4290 - Intergovern-Other --500,000 ----0.00 % 4320 - Rental Fees 9,900 11,500 13,000 9,900 47,500 47,500 37,600 379.80 %2022: Increased rent due to 3 additional rental properties 4355 - Developer Fees -160 6,600 ----0.00 % 4620 - Contributions - Capital --15,295 ----0.00 % 4700.100 - Interest Income - Investments 66,581 62,263 (4,704)19,000 20,000 20,000 1,000 5.26 % 4700.150 - Interest Income - Operating Account 2,695 425 14 1,000 500 500 (500)(50.00 %) 4700.300 - Interest Income - Notes 4,139 3,283 -4,000 3,000 2,500 (1,000)(25.00 %)2022: TIF 1-2 Interfund Loan 4800 - Other Revenues -3,840,900 1,248,497 ----0.00 % 4801 - Administrative Fee 20,376 ------0.00 % 4820 - Loan Repayments 13,260 72,017 -13,500 17,000 18,500 3,500 25.93 %2022: TIF 1-2 Interfund Loan principal Total $695,359 $4,585,350 $2,089,246 $647,505 $698,990 $720,332 $51,485 7.95 % Expenses 6000 - Salaries $5,485 $5,809 -----0.00 %2022: Regular salaries: possible grade reclasses 6000.100 - Salaries - Regular 172,523 209,686 136,661 214,126 217,760 226,164 3,634 1.70 % 6050 - Benefits 831 880 -----0.00 % 6050.100 - Benefits - Social Security 10,371 12,676 8,480 12,750 12,729 12,961 (21)(.16 %) 6050.101 - Benefits - Medicare 2,504 3,063 1,983 3,129 3,182 3,305 53 1.69 % 6050.200 - Benefits - PERA 12,930 15,657 9,992 16,060 16,331 16,960 271 1.69 % 6050.550 - Benefits - Cell Phone Allowance 1,446 1,392 936 1,440 1,440 1,440 -0.00 % 6050.570 - Benefits - Car Allowance 241 232 156 240 240 240 -0.00 % 6060.100 - Medical Insurance - Employer Contribution 10,621 13,989 8,781 15,892 16,827 18,040 935 5.88 % 6070.100 - Dental Insurance - Employer Contribution 1,656 1,643 1,055 1,786 1,786 1,876 -0.00 % 6080.100 - Group Life Insurance - Employer Contribution 604 631 404 738 743 758 5 .68 % 6100 - Office Supplies 196 -63 500 500 500 -0.00 % 6130 - Repair & Maint Supplies -25 370 200 --(200)(100.00 %) 6500.100 - Employee Development - Training 274 1,065 15 3,200 3,200 3,200 -0.00 % 6550 - Mileage & Parking Reimbursement ---100 100 100 -0.00 % 6700 - Dues & Subscriptions 821 1,291 75 1,000 1,000 1,000 -0.00 % City of Plymouth 2022/2023 Biennial Budget Detail HRA General - Budgeted Revenues and Expenditures HRA General Page 71 76 Account Number - Description Actual 2019 Actual 2020 Actual August YTD 2021 Budget Amended 2021 Budget Proposed 2022 Budget Proposed 2023 Budget Variance $ 2021-2022 Budget Variance % 2021-2022 Comments Expenses 7000 - Professional Services 4,170 22,293 27,797 5,000 10,000 10,000 5,000 100.00 % 7000.300 - Professional Services - Architectural Design Program 150 600 500 1,000 1,000 1,000 -0.00 % 7003 - Legal 1,791 8,504 5,534 5,229 6,000 6,000 771 14.74 % 7004 - Audit Fees 1,846 1,892 1,928 2,000 2,000 2,000 -0.00 % 7100.100 - Communications - Postage ---750 750 750 -0.00 % 7200 - Printing & Publishing ---1,000 1,000 1,000 -0.00 % 7500 - Repair & Maint Services 2,931 11,306 10,612 4,000 10,000 17,000 6,000 150.00 %2022: Replace Counter top and gutters - 3315 Garland Ln -------------------- 2022: Replace gutters - 3325 Garland Ln 8000 - Non-Cap Equip (< 5K)868 3,002 -----0.00 % 8100 - Capital Outlay (> 5K)--5,979 ----0.00 % 8100.100 - Capital Outlay (> 5K) - Land -152,553 -----0.00 % 8100.300 - Capital Outlay (> 5K) - Buildings -188,583 108,725 ----0.00 % 9000.101 - Allocations - Information Technology 12,236 12,236 8,402 12,603 12,981 13,370 378 3.00 % 9000.102 - Allocations - Facilities Management 12,626 12,626 8,670 13,005 13,395 13,797 390 3.00 % 9000.110 - Allocations - Risk Mgmt - OH, Premium 727 1,450 (9,072)(13,608)887 900 14,495 (106.52 %) 9000.111 - Allocations - Risk Mgmt - Claims -15,000 -----0.00 % 9500.050 - Transfers Out - Reserves ---35,090 49,864 47,696 14,774 42.10 % 9500.850 - Transfers Out - Plymouth Town Square 185,000 175,000 -258,000 260,000 260,000 2,000 .78 % 9500.851 - Transfers Out - Vicksburg Crossing 55,000 40,000 -40,000 45,000 50,000 5,000 12.50 % 9900 - Miscellaneous 80,050 3,922,450 1,248,547 ----0.00 % 9904 - Real Estate Taxes --3,683 ----0.00 % 9911 - Grant Awards --501,610 12,000 10,000 10,000 (2,000)(16.67 %)2022: HCV damage incentive & new landlord incentive program 2023: HCV damage incentive & new landlord incentive program 9920.100 - Bank Fees - Credit Card -9 117 ----0.00 % 9920.150 - Bank Fees - PSN 9 4 2 25 25 25 -0.00 % 9920.160 - Bank Fees - Operating Acct 163 148 58 200 200 200 -0.00 % 9920.170 - Bank Fees - Investments 45 44 16 50 50 50 -0.00 % 9930 - Loans 46 -20,601 ----0.00 % Total $578,162 $4,835,738 $2,112,678 $647,505 $698,990 $720,332 $51,485 7.95 % City of Plymouth 2022/2023 Biennial Budget Detail HRA General - Budgeted Revenues and Expenditures HRA General Page 72 77 2019 Amended FTE 2020 Adopted FTE 2021 Amended FTE 2022 Adopted FTE 2023 Concept FTE 4.7 4.7 4.7 4.7 4.7 7.5 8.3 9.3 9.9 9.9 1.0 1.0 1.0 1.0 1.0 13.2 14.0 15.0 15.6 15.6 Transit Recreation Housing and Redevelopment City of Plymouth 2022 Adopted Budget FTE Summary by Division Division Page 73 78 CITY OF PLYMOUTH PROPERTY TAX LEVIESLevy Type2016% Increase / Decrease over 20152017% Increase / Decrease over 2016 2018% Increase / Decrease over 2017 2019% Increase / Decrease over 20182020% Increase / Decrease over 2019Proposed 2021% Increase / Decrease over 20202022% Increase / Decrease over 20212023% Increase / Decrease over 2022Levy BaseGeneral Fund Base 25,278,3733.83%26,691,7535.59%28,113,0585.32%29,958,3246.56%31,594,8575.46%33,598,3376.34%35,851,7796.71%37,459,3044.48%Street Reconstruction 2,964,7272.00%3,024,0212.00%2,584,501‐14.53%2,636,1912.00%2,662,5531.00%2,689,1791.00%2,769,8543.00%2,852,9503.00%Recreation Fund 601,6655.19%631,6744.99%650,6243.00%670,1433.00%703,6505.00%738,8325.00%775,7745.00%814,5635.00%Park Replacement 353,6322.00%360,7052.00%871,526141.62%888,9572.00%906,7362.00%924,8702.00%952,6163.00%981,1953.00%Capital Improvement Fund 419,4632.00%427,8532.00%440,6883.00%449,5012.00%458,4912.00%467,6612.00%481,6913.00%496,1423.00%Total Levy Base 29,617,860 3.62% 31,136,006 5.13% 32,660,397 4.90% 34,603,116 5.95% 36,326,287 4.98% 38,418,879 5.76% 40,831,714 6.28% 42,604,153 4.34%Special LeviesGO 2012A  (2004A) Public Safety 563,903‐0.37%561,488‐0.43%569,2581.38%571,1480.33%572,5650.25%573,5100.17%2015A Open Space  261,52274.35%268,3472.61%269,7120.51%265,722‐1.48%272,2322.45%271,182‐0.39%264,725‐2.38%268,7671.53%2020A Plymouth Community Center 910,0001,506,73565.58%2,270,88950.72%2,267,392‐0.15%2021A Fire Stations669,3951,353,083102.14%Total Special Levies1,093,766 ‐11.11%1,097,4410.34% 1,105,683 0.75% 836,870 ‐24.31% 1,754,797 109.69% 2,351,427 34.00% 3,205,009 36.30% 3,889,242 21.35%TOTAL CITY LEVY30,711,626 3.01% 32,233,447 4.96% 33,766,080 4.75% 35,439,986 4.96% 38,081,084 7.45% 40,770,306 7.06% 44,036,723 8.01% 46,493,395 5.58%HRA Levy561,2771.81%571,3791.80%580,5191.60%590,5281.72%602,3392.00%606,8170.74%618,9532.00%639,6343.34%TOTAL LEVY$31,272,903 2.99% $32,804,826 4.90% $34,346,599 4.70% $36,030,514 4.90% $38,683,423 7.36% $41,377,123 6.96% $44,655,676 7.92% $47,133,029 5.55%8/30/2021Page 7479 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ADMINISTRATIVE SERVICES Information Technology IT-20-0003 Cisco UCS Compute Hardware 2020 39,300 39,300 0 0 0 0 0 0 0 0 78,600 IT-20-0004 Cohesity Backup 2020 34,716 34,716 0 0 0 0 0 0 0 0 69,432 Total: Information Technology $74,016 $74,016 $0 $0 $0 $0 $0 $0 $0 $0 $148,032 TOTAL: ADMINISTRATIVE SERVICES $74,016 $74,016 $0 $0 $0 $0 $0 $0 $0 $0 $148,032 GRAND TOTAL $74,016 $74,016 $0 $0 $0 $0 $0 $0 $0 $0 $148,032 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Department Page 75 80 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total CITY ADMINISTRATION Human Resources CA-22-0001 HRIS System 2022 40,000 0 0 0 0 0 0 0 0 0 40,000 Total: Human Resources $40,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40,000 TOTAL: CITY ADMINISTRATION $40,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40,000 GRAND TOTAL $40,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Department Page 76 81 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total PARKS AND RECREATION Parks & Rec Admin PR-07-0005 Replace Irrigation Systems 2003 0 0 0 400,000 275,000 0 0 0 0 400,000 1,075,000 PR-13-0001 Neighborhood Parks 2012 0 500,000 0 700,000 300,000 400,000 300,000 0 0 0 2,200,000 PR-14-0003 Replace Miscellaneous Boardwalks 2010 125,000 350,000 225,000 0 150,000 0 0 150,000 0 0 1,000,000 PR-14-0004 Tennis Court Repair 2012 0 0 0 0 0 0 0 0 475,000 0 475,000 PR-14-0005 Northwest Greenway 2012 0 0 1,850,000 0 0 1,700,000 0 0 0 0 3,550,000 PR-15-0002 Parking Lot Repair/Replacement 2012 800,000 1,100,000 0 0 0 0 0 0 0 0 1,900,000 PR-16-0002 Park Lighting 2016 0 250,000 0 0 175,000 0 480,000 0 0 0 905,000 PR-20-0001 Playfield Land Development 2016 0 0 5,300,000 0 0 0 0 0 0 0 5,300,000 PR-22-0001 Asset Renovation/Replacement 2022 100,000 0 100,000 0 0 0 0 0 0 0 200,000 PR-29-0001 Outdoor Artificial Turf 2020 0 0 0 0 0 0 0 1,200,000 0 0 1,200,000 PR-XX-9001 New Trails 2003 275,000 360,000 150,000 650,000 0 0 0 0 0 0 1,435,000 PR-XX-9002 Trail Repair 2003 400,000 400,000 500,000 400,000 500,000 500,000 600,000 500,000 500,000 500,000 4,800,000 PR-XX-9003 Playground Replacement or Renovation 2006 270,000 250,000 500,000 270,000 300,000 400,000 350,000 375,000 350,000 350,000 3,415,000 PR-XX-9004 Miscellaneous Park Improvements 2006 110,000 125,000 0 200,000 175,000 0 150,000 0 150,000 150,000 1,060,000 PR-XX-9005 Park Amenities & Facilities 2020 500,000 0 0 0 0 0 0 200,000 0 0 700,000 PR-XX-9006 Land Acquisition 2020 300,000 300,000 300,000 300,000 300,000 300,000 0 0 0 0 1,800,000 PR-XX-9007 Park Building Repair/Renovation 2020 0 0 0 0 0 1,300,000 0 1,000,000 0 100,000 2,400,000 REC-22-0001 Electronic Sign 2020 100,000 0 110,000 0 0 0 0 0 0 0 210,000 Total: Parks & Rec Admin $2,980,000 $3,635,000 $9,035,000 $2,920,000 $2,175,000 $4,600,000 $1,880,000 $3,425,000 $1,475,000 $1,500,000 $33,625,000 TOTAL: PARKS AND RECREATION $2,980,000 $3,635,000 $9,035,000 $2,920,000 $2,175,000 $4,600,000 $1,880,000 $3,425,000 $1,475,000 $1,500,000 $33,625,000 GRAND TOTAL $2,980,000 $3,635,000 $9,035,000 $2,920,000 $2,175,000 $4,600,000 $1,880,000 $3,425,000 $1,475,000 $1,500,000 $33,625,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Department Page 77 82 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total PUBLIC WORKS Street Maintenance ST-12-0002 Nathan Lane & CR 10 Intersection 2008 0 0 0 500,000 0 0 0 0 0 0 500,000 ST-17-0002 Hamel Road Frontage Road Connection 2016 0 1,600,000 0 0 0 0 0 0 0 0 1,600,000 ST-17-0003 54th Avenue from Peony Lane to CSAH 101 2016 0 0 0 0 250,000 3,000,000 0 0 0 0 3,250,000 ST-20-0001 Juneau Lane from Hampton Hills to 59th Avenue 2016 0 0 0 0 0 0 0 500,000 2,400,000 0 2,900,000 ST-20-0002 CR 9 at TH 169 Bridge Replacement 2019 0 1,150,000 0 0 0 0 0 0 0 0 1,150,000 ST-20-0003 36th Ave from Pilgrim Ln to TH 169 2020 0 0 500,000 5,500,000 0 0 0 0 0 0 6,000,000 ST-21-0003 CSAH 101 & CR 47 Intersection Improvements 2021 200,000 0 0 0 0 0 0 0 0 0 200,000 ST-22-0001 CR 47 Reconstruction - Phase 1 (CR 101 to Peony) 2020 9,000,000 0 0 0 0 0 0 0 0 0 9,000,000 ST-22-0002 Comstock & Schmidt Lake Intersection Improvements 2022 650,000 0 0 0 0 0 0 0 0 0 650,000 ST-23-0001 City Center Roadways Rehabilitation 2020 150,000 6,775,000 7,175,000 0 0 0 0 0 0 0 14,100,000 ST-23-0002 CR 47 Reconstruction - Phase 2 (Peony to Vicksburg) 2022 300,000 7,200,000 0 0 0 0 0 0 0 0 7,500,000 ST-23-0003 Hwy 55 Underpass at Station 73 2022 0 6,500,000 5,000,000 0 0 0 0 0 0 0 11,500,000 ST-23-0004 Hwy 55 Pavement Preservation Project 2022 0 100,000 100,000 0 0 0 0 0 0 0 200,000 ST-23-0005 Lancaster & Pilgrim Intersection and Stormwater Improvements 2022 0 1,400,000 0 0 0 0 0 0 0 0 1,400,000 ST-24-0001 Hwy 55 at Vicksburg Lane Signal Replacement Project 2020 0 0 295,000 0 0 0 0 0 0 0 295,000 ST-24-0002 CR 47 Reconstruction - Phase 3 (Vicksburg to CR 61) 2022 0 0 13,500,000 0 0 0 0 0 0 0 13,500,000 ST-25-0002 36th Ave at TH 169 Bridge Replacement 2021 0 0 500,000 0 0 0 0 0 0 0 500,000 ST-XX-9001 Annual Street Reconstruction 2012 5,850,000 5,900,000 4,100,000 3,350,000 4,750,000 3,650,000 8,750,000 8,750,000 8,750,000 8,750,000 62,600,000 ST-XX-9002 Mill & Overlay Projects 2005 1,150,000 2,300,000 1,200,000 1,400,000 1,800,000 1,300,000 1,300,000 1,350,000 1,350,000 1,350,000 14,500,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Department Page 78 83 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ST-XX-9003 Replace Retaining Walls 2005 130,000 100,000 100,000 115,000 115,000 115,000 115,000 115,000 130,000 130,000 1,165,000 ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 3,200,000 4,700,000 3,900,000 4,150,000 3,200,000 3,300,000 5,400,000 4,000,000 4,000,000 4,200,000 40,050,000 ST-XX-9006 Traffic Signal Improvements 2020 0 0 50,000 300,000 50,000 50,000 0 50,000 300,000 0 800,000 ST-XX-9007 Concrete Sidewalk Replacement 2007 75,000 75,000 0 0 300,000 0 0 75,000 75,000 75,000 675,000 ST-XX-9008 Crash Reduction & Safety Improvement Project 2021 100,000 100,000 0 0 0 0 0 0 0 0 200,000 Total: Street Maintenance $20,805,000 $37,900,000 $36,420,000 $15,315,000 $10,465,000 $11,415,000 $15,565,000 $14,840,000 $17,005,000 $14,505,000 $194,235,000 TOTAL: PUBLIC WORKS $20,805,000 $37,900,000 $36,420,000 $15,315,000 $10,465,000 $11,415,000 $15,565,000 $14,840,000 $17,005,000 $14,505,000 $194,235,000 GRAND TOTAL $20,805,000 $37,900,000 $36,420,000 $15,315,000 $10,465,000 $11,415,000 $15,565,000 $14,840,000 $17,005,000 $14,505,000 $194,235,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Department Page 79 84 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total IT Systems IT-20-0003 Cisco UCS Compute Hardware 2020 39,300 39,300 0 0 0 0 0 0 0 0 78,600 IT-20-0004 Cohesity Backup 2020 34,716 34,716 0 0 0 0 0 0 0 0 69,432 Total: IT Systems $74,016 $74,016 $0 $0 $0 $0 $0 $0 $0 $0 $148,032 GRAND TOTAL $74,016 $74,016 $0 $0 $0 $0 $0 $0 $0 $0 $148,032 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 80 85 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Surplus Reserve CA-22-0001 HRIS System 2022 40,000 0 0 0 0 0 0 0 0 0 40,000 Total: Surplus Reserve $40,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40,000 GRAND TOTAL $40,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 81 86 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Other Agency PR-15-0002 Parking Lot Repair/Replacement 2012 0 200,000 0 0 0 0 0 0 0 0 200,000 Total: Other Agency $0 $200,000 $0 $0 $0 $0 $0 $0 $0 $0 $200,000 Park Const Dedication Fees Fund PR-13-0001 Neighborhood Parks 2012 0 500,000 0 700,000 300,000 400,000 300,000 0 0 0 2,200,000 PR-14-0005 Northwest Greenway 2012 0 0 1,850,000 0 0 1,700,000 0 0 0 0 3,550,000 PR-15-0002 Parking Lot Repair/Replacement 2012 0 200,000 0 0 0 0 0 0 0 0 200,000 PR-16-0002 Park Lighting 2016 0 250,000 0 0 175,000 0 0 0 0 0 425,000 PR-20-0001 Playfield Land Development 2016 0 0 5,300,000 0 0 0 0 0 0 0 5,300,000 PR-29-0001 Outdoor Artificial Turf 2020 0 0 0 0 0 0 0 1,200,000 0 0 1,200,000 PR-XX-9001 New Trails 2003 275,000 360,000 150,000 650,000 0 0 0 0 0 0 1,435,000 PR-XX-9005 Park Amenities & Facilities 2020 500,000 0 0 0 0 0 0 200,000 0 0 700,000 PR-XX-9006 Land Acquisition 2020 300,000 300,000 300,000 300,000 300,000 300,000 0 0 0 0 1,800,000 Total: Park Const Dedication Fees Fund $1,075,000 $1,610,000 $7,600,000 $1,650,000 $775,000 $2,400,000 $300,000 $1,400,000 $0 $0 $16,810,000 Park Replacement Fund PR-07-0005 Replace Irrigation Systems 2003 0 0 0 400,000 275,000 0 0 0 0 400,000 1,075,000 PR-14-0003 Replace Miscellaneous Boardwalks 2010 125,000 350,000 225,000 0 150,000 0 0 150,000 0 0 1,000,000 PR-14-0004 Tennis Court Repair 2012 0 0 0 0 0 0 0 0 475,000 0 475,000 PR-15-0002 Parking Lot Repair/Replacement 2012 800,000 700,000 0 0 0 0 0 0 0 0 1,500,000 PR-16-0002 Park Lighting 2016 0 0 0 0 0 0 480,000 0 0 0 480,000 PR-22-0001 Asset Renovation/Replacement 2022 100,000 0 100,000 0 0 0 0 0 0 0 200,000 PR-XX-9002 Trail Repair 2003 400,000 400,000 500,000 400,000 500,000 500,000 600,000 500,000 500,000 500,000 4,800,000 PR-XX-9003 Playground Replacement or Renovation 2006 270,000 250,000 500,000 270,000 300,000 400,000 350,000 375,000 350,000 350,000 3,415,000 PR-XX-9004 Miscellaneous Park Improvements 2006 110,000 125,000 0 200,000 175,000 0 150,000 0 150,000 150,000 1,060,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 82 87 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total PR-XX-9007 Park Building Repair/Renovation 2020 0 0 0 0 0 1,300,000 0 1,000,000 0 100,000 2,400,000 Total: Park Replacement Fund $1,805,000 $1,825,000 $1,325,000 $1,270,000 $1,400,000 $2,200,000 $1,580,000 $2,025,000 $1,475,000 $1,500,000 $16,405,000 Rec - Admin REC-22-0001 Electronic Sign 2020 100,000 0 110,000 0 0 0 0 0 0 0 210,000 Total: Rec - Admin $100,000 $0 $110,000 $0 $0 $0 $0 $0 $0 $0 $210,000 GRAND TOTAL $2,980,000 $3,635,000 $9,035,000 $2,920,000 $2,175,000 $4,600,000 $1,880,000 $3,425,000 $1,475,000 $1,500,000 $33,625,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 83 88 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Bonds ST-23-0002 CR 47 Reconstruction - Phase 2 (Peony to Vicksburg) 2022 0 6,500,000 0 0 0 0 0 0 0 0 6,500,000 ST-24-0002 CR 47 Reconstruction - Phase 3 (Vicksburg to CR 61) 2022 0 0 13,500,000 0 0 0 0 0 0 0 13,500,000 Total: Bonds $0 $6,500,000 $13,500,000 $0 $0 $0 $0 $0 $0 $0 $20,000,000 Hennepin County ST-22-0001 CR 47 Reconstruction - Phase 1 (CR 101 to Peony) 2020 5,000,000 0 0 0 0 0 0 0 0 0 5,000,000 Total: Hennepin County $5,000,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,000,000 Minnesota State Aid Fund ST-17-0003 54th Avenue from Peony Lane to CSAH 101 2016 0 0 0 0 250,000 1,900,000 0 0 0 0 2,150,000 ST-20-0002 CR 9 at TH 169 Bridge Replacement 2019 0 540,000 0 0 0 0 0 0 0 0 540,000 ST-20-0003 36th Ave from Pilgrim Ln to TH 169 2020 0 0 500,000 2,250,000 0 0 0 0 0 0 2,750,000 ST-22-0001 CR 47 Reconstruction - Phase 1 (CR 101 to Peony) 2020 2,300,000 0 0 0 0 0 0 0 0 0 2,300,000 ST-23-0001 City Center Roadways Rehabilitation 2020 0 1,200,000 1,200,000 0 0 0 0 0 0 0 2,400,000 ST-24-0001 Hwy 55 at Vicksburg Lane Signal Replacement Project 2020 0 0 295,000 0 0 0 0 0 0 0 295,000 ST-25-0002 36th Ave at TH 169 Bridge Replacement 2021 0 0 500,000 0 0 0 0 0 0 0 500,000 ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 2,675,000 2,400,000 2,000,000 440,000 2,000,000 2,400,000 4,000,000 2,250,000 2,250,000 2,250,000 22,665,000 ST-XX-9006 Traffic Signal Improvements 2020 0 0 0 300,000 0 50,000 0 0 300,000 0 650,000 Total: Minnesota State Aid Fund $4,975,000 $4,140,000 $4,495,000 $2,990,000 $2,250,000 $4,350,000 $4,000,000 $2,250,000 $2,550,000 $2,250,000 $34,250,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 84 89 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Other Agency ST-22-0002 Comstock & Schmidt Lake Intersection Improvements 2022 450,000 0 0 0 0 0 0 0 0 0 450,000 Total: Other Agency $450,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $450,000 Other Governmental Agency ST-17-0002 Hamel Road Frontage Road Connection 2016 0 710,000 0 0 0 0 0 0 0 0 710,000 ST-23-0003 Hwy 55 Underpass at Station 73 2022 0 5,500,000 4,000,000 0 0 0 0 0 0 0 9,500,000 Total: Other Governmental Agency $0 $6,210,000 $4,000,000 $0 $0 $0 $0 $0 $0 $0 $10,210,000 Park Replacement Fund ST-20-0002 CR 9 at TH 169 Bridge Replacement 2019 0 60,000 0 0 0 0 0 0 0 0 60,000 Total: Park Replacement Fund $0 $60,000 $0 $0 $0 $0 $0 $0 $0 $0 $60,000 Sewer - Admin ST-17-0002 Hamel Road Frontage Road Connection 2016 0 50,000 0 0 0 0 0 0 0 0 50,000 ST-20-0001 Juneau Lane from Hampton Hills to 59th Avenue 2016 0 0 0 0 0 0 0 0 10,000 0 10,000 ST-20-0002 CR 9 at TH 169 Bridge Replacement 2019 0 150,000 0 0 0 0 0 0 0 0 150,000 ST-XX-9001 Annual Street Reconstruction 2012 50,000 50,000 60,000 40,000 50,000 100,000 75,000 100,000 100,000 100,000 725,000 ST-XX-9002 Mill & Overlay Projects 2005 70,000 150,000 80,000 90,000 120,000 80,000 80,000 90,000 90,000 90,000 940,000 ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 50,000 50,000 50,000 60,000 60,000 60,000 60,000 60,000 60,000 70,000 580,000 Total: Sewer - Admin $170,000 $450,000 $190,000 $190,000 $230,000 $240,000 $215,000 $250,000 $260,000 $260,000 $2,455,000 Special Assessments ST-17-0002 Hamel Road Frontage Road Connection 2016 0 500,000 0 0 0 0 0 0 0 0 500,000 ST-17-0003 54th Avenue from Peony Lane to CSAH 101 2016 0 0 0 0 0 1,100,000 0 0 0 0 1,100,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 85 90 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ST-20-0001 Juneau Lane from Hampton Hills to 59th Avenue 2016 0 0 0 0 0 0 0 0 200,000 0 200,000 ST-23-0001 City Center Roadways Rehabilitation 2020 0 1,500,000 500,000 0 0 0 0 0 0 0 2,000,000 ST-XX-9001 Annual Street Reconstruction 2012 1,000,000 910,000 900,000 750,000 1,100,000 800,000 1,700,000 1,700,000 1,700,000 1,700,000 12,260,000 ST-XX-9002 Mill & Overlay Projects 2005 180,000 350,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 2,530,000 ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 300,000 700,000 300,000 300,000 250,000 250,000 400,000 300,000 300,000 300,000 3,400,000 Total: Special Assessments $1,480,000 $3,960,000 $1,950,000 $1,300,000 $1,600,000 $2,400,000 $2,350,000 $2,250,000 $2,450,000 $2,250,000 $21,990,000 Street Reconstruction Fund ST-17-0002 Hamel Road Frontage Road Connection 2016 0 290,000 0 0 0 0 0 0 0 0 290,000 ST-20-0001 Juneau Lane from Hampton Hills to 59th Avenue 2016 0 0 0 0 0 0 0 500,000 1,780,000 0 2,280,000 ST-20-0003 36th Ave from Pilgrim Ln to TH 169 2020 0 0 0 2,450,000 0 0 0 0 0 0 2,450,000 ST-21-0003 CSAH 101 & CR 47 Intersection Improvements 2021 200,000 0 0 0 0 0 0 0 0 0 200,000 ST-22-0001 CR 47 Reconstruction - Phase 1 (CR 101 to Peony) 2020 1,600,000 0 0 0 0 0 0 0 0 0 1,600,000 ST-22-0002 Comstock & Schmidt Lake Intersection Improvements 2022 200,000 0 0 0 0 0 0 0 0 0 200,000 ST-23-0001 City Center Roadways Rehabilitation 2020 150,000 2,750,000 2,000,000 0 0 0 0 0 0 0 4,900,000 ST-23-0002 CR 47 Reconstruction - Phase 2 (Peony to Vicksburg) 2022 300,000 700,000 0 0 0 0 0 0 0 0 1,000,000 ST-23-0004 Hwy 55 Pavement Preservation Project 2022 0 100,000 100,000 0 0 0 0 0 0 0 200,000 ST-23-0005 Lancaster & Pilgrim Intersection and Stormwater Improvements 2022 0 100,000 0 0 0 0 0 0 0 0 100,000 ST-XX-9001 Annual Street Reconstruction 2012 3,320,000 3,360,000 2,070,000 1,670,000 2,300,000 1,750,000 4,675,000 5,030,000 4,530,000 4,530,000 33,235,000 ST-XX-9002 Mill & Overlay Projects 2005 782,000 1,465,000 740,000 830,000 1,100,000 740,000 740,000 775,000 775,000 775,000 8,722,000 ST-XX-9003 Replace Retaining Walls 2005 130,000 100,000 100,000 115,000 115,000 115,000 115,000 115,000 130,000 130,000 1,165,000 ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 0 1,375,000 1,375,000 3,100,000 640,000 340,000 640,000 1,090,000 1,090,000 1,230,000 10,880,000 ST-XX-9006 Traffic Signal Improvements 2020 0 0 50,000 0 50,000 0 0 50,000 0 0 150,000 ST-XX-9007 Concrete Sidewalk Replacement 2007 75,000 75,000 0 0 300,000 0 0 75,000 75,000 75,000 675,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 86 91 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ST-XX-9008 Crash Reduction & Safety Improvement Project 2021 100,000 100,000 0 0 0 0 0 0 0 0 200,000 Total: Street Reconstruction Fund $6,857,000 $10,415,000 $6,435,000 $8,165,000 $4,505,000 $2,945,000 $6,170,000 $7,635,000 $8,380,000 $6,740,000 $68,247,000 Transit - Admin ST-23-0003 Hwy 55 Underpass at Station 73 2022 0 1,000,000 1,000,000 0 0 0 0 0 0 0 2,000,000 Total: Transit - Admin $0 $1,000,000 $1,000,000 $0 $0 $0 $0 $0 $0 $0 $2,000,000 Unidentified ST-12-0002 Nathan Lane & CR 10 Intersection 2008 0 0 0 500,000 0 0 0 0 0 0 500,000 ST-23-0001 City Center Roadways Rehabilitation 2020 0 825,000 3,225,000 0 0 0 0 0 0 0 4,050,000 Total: Unidentified $0 $825,000 $3,225,000 $500,000 $0 $0 $0 $0 $0 $0 $4,550,000 Water - Admin ST-17-0002 Hamel Road Frontage Road Connection 2016 0 50,000 0 0 0 0 0 0 0 0 50,000 ST-20-0001 Juneau Lane from Hampton Hills to 59th Avenue 2016 0 0 0 0 0 0 0 0 310,000 0 310,000 ST-20-0002 CR 9 at TH 169 Bridge Replacement 2019 0 150,000 0 0 0 0 0 0 0 0 150,000 ST-20-0003 36th Ave from Pilgrim Ln to TH 169 2020 0 0 0 500,000 0 0 0 0 0 0 500,000 ST-22-0001 CR 47 Reconstruction - Phase 1 (CR 101 to Peony) 2020 100,000 0 0 0 0 0 0 0 0 0 100,000 ST-XX-9001 Annual Street Reconstruction 2012 1,400,000 1,500,000 1,000,000 800,000 1,200,000 900,000 2,200,000 1,800,000 2,300,000 2,300,000 15,400,000 ST-XX-9002 Mill & Overlay Projects 2005 100,000 300,000 100,000 200,000 300,000 200,000 200,000 200,000 200,000 200,000 2,000,000 ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 100,000 100,000 100,000 150,000 150,000 150,000 175,000 175,000 175,000 200,000 1,475,000 Total: Water - Admin $1,700,000 $2,100,000 $1,200,000 $1,650,000 $1,650,000 $1,250,000 $2,575,000 $2,175,000 $2,985,000 $2,700,000 $19,985,000 Water Resources - Admin ST-20-0001 Juneau Lane from Hampton Hills to 59th Avenue 2016 0 0 0 0 0 0 0 0 100,000 0 100,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 87 92 Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ST-20-0002 CR 9 at TH 169 Bridge Replacement 2019 0 250,000 0 0 0 0 0 0 0 0 250,000 ST-20-0003 36th Ave from Pilgrim Ln to TH 169 2020 0 0 0 300,000 0 0 0 0 0 0 300,000 ST-23-0001 City Center Roadways Rehabilitation 2020 0 500,000 250,000 0 0 0 0 0 0 0 750,000 ST-23-0005 Lancaster & Pilgrim Intersection and Stormwater Improvements 2022 0 500,000 0 0 0 0 0 0 0 0 500,000 ST-XX-9001 Annual Street Reconstruction 2012 80,000 80,000 70,000 90,000 100,000 100,000 100,000 120,000 120,000 120,000 980,000 ST-XX-9002 Mill & Overlay Projects 2005 18,000 35,000 30,000 30,000 30,000 30,000 30,000 35,000 35,000 35,000 308,000 ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 75,000 75,000 75,000 100,000 100,000 100,000 125,000 125,000 125,000 150,000 1,050,000 Total: Water Resources - Admin $173,000 $1,440,000 $425,000 $520,000 $230,000 $230,000 $255,000 $280,000 $380,000 $305,000 $4,238,000 Watershed District ST-23-0005 Lancaster & Pilgrim Intersection and Stormwater Improvements 2022 0 800,000 0 0 0 0 0 0 0 0 800,000 Total: Watershed District $0 $800,000 $0 $0 $0 $0 $0 $0 $0 $0 $800,000 GRAND TOTAL $20,805,000 $37,900,000 $36,420,000 $15,315,000 $10,465,000 $11,415,000 $15,565,000 $14,840,000 $17,005,000 $14,505,000 $194,235,000 City of Plymouth Capital Improvement Plan 2022-2031 Projects by Funding Source Page 88 93 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ADMINISTRATIVE SERVICES Information Technology IT-17-0007 Switch Upgrades 2017 Previously Approved Budget Existing 30,000 0 0 0 0 0 0 0 0 0 30,000 Department Final Existing 0 0 0 0 0 0 0 0 0 0 0 Change (30,000) 0 0 0 0 0 0 0 0 0 (30,000) IT Systems (30,000)0 0 0 0 0 0 0 0 0 (30,000) Change Activity Project fell below the requirement to be included in the CIP. Grand Total of CIP (Changed/Unchanged) Budget Stage 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Previously Approved Budget 104,016 74,016 0 0 0 0 0 0 0 0 178,032 Department Final 74,016 74,016 0 0 0 0 0 0 0 0 148,032 Change (30,000) 0 0 0 0 0 0 0 0 0 (30,000) Total Net Change In Funding Sources 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total IT Systems (30,000) 0 0 0 0 0 0 0 0 0 (30,000) Change (30,000) 0 0 0 0 0 0 0 0 0 (30,000) City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 89 94 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total CITY ADMINISTRATION Human Resources CA-22-0001 HRIS System 2022 Department Final New 40,000 0 0 0 0 0 0 0 0 0 40,000 Change 40,000 0 0 0 0 0 0 0 0 0 40,000 Surplus Reserve 40,000 0 0 0 0 0 0 0 0 0 40,000 Change Activity Purchase HRIS system Grand Total of CIP (Changed/Unchanged) Budget Stage 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Previously Approved Budget 0 0 0 0 0 0 0 0 0 0 0 Department Final 40,000 0 0 0 0 0 0 0 0 0 40,000 Change 40,000 0 0 0 0 0 0 0 0 0 40,000 Total Net Change In Funding Sources 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Surplus Reserve 40,000 0 0 0 0 0 0 0 0 0 40,000 Change 40,000 0 0 0 0 0 0 0 0 0 40,000 City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 90 95 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total PARKS AND RECREATION Parks & Rec Admin PR-07-0005 Replace Irrigation Systems 2003 Previously Approved Budget Existing 375,000 252,000 0 0 250,000 0 300,000 0 400,000 0 1,577,000 Department Final Existing 0 0 0 400,000 275,000 0 0 0 0 400,000 1,075,000 Change (375,000)(252,000) 0 400,000 25,000 0 (300,000) 0 (400,000) 400,000 (502,000) Park Replacement Fund (375,000)(252,000)0 400,000 25,000 0 (300,000) 0 (400,000) 400,000 (502,000) Change Activity Adjust years and cost of irrigation replacement. PR-13-0001 Neighborhood Parks 2012 Previously Approved Budget Existing 0 500,000 0 0 300,000 400,000 300,000 0 700,000 0 2,200,000 Department Final Existing 0 500,000 0 700,000 300,000 400,000 300,000 0 0 0 2,200,000 Change 0 0 0 700,000 0 0 0 0 (700,000) 0 0 Park Const Dedication Fees Fund 0 0 0 700,000 0 0 0 0 (399,000) 0 301,000 Unidentified 0 0 0 0 0 0 0 0 (301,000) 0 (301,000) Change Activity Moved Schmidt Woods to 2025. PR-14-0003 Replace Miscellaneous Boardwalks 2010 Previously Approved Budget Existing 125,000 275,000 225,000 75,000 150,000 0 0 150,000 0 0 1,000,000 Department Final Existing 125,000 350,000 225,000 0 150,000 0 0 150,000 0 0 1,000,000 Change 0 75,000 0 (75,000) 0 0 0 0 0 0 0 Park Replacement Fund 0 75,000 0 (75,000)0 0 0 0 0 0 0 Change Activity Adjusted timing & cost of Lake Camelot Boardwalks to align with CR47 improvements PR-14-0004 Tennis Court Repair 2012 Previously Approved Budget Existing 0 0 0 0 0 0 400,000 0 475,000 0 875,000 Department Final Existing 0 0 0 0 0 0 0 0 475,000 0 475,000 Change 0 0 0 0 0 0 (400,000) 0 0 0 (400,000) Park Replacement Fund 0 0 0 0 0 0 (316,000) 0 130,000 0 (186,000) Unidentified 0 0 0 0 0 0 (84,000) 0 (130,000) 0 (214,000) Change Activity City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 91 96 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total PR-15-0002 Parking Lot Repair/Replacement 2012 Previously Approved Budget Existing 0 400,000 0 500,000 100,000 0 100,000 0 0 0 1,100,000 Department Final Existing 800,000 1,100,000 0 0 0 0 0 0 0 0 1,900,000 Change 800,000 700,000 0 (500,000)(100,000) 0 (100,000) 0 0 0 800,000 Park Const Dedication Fees Fund 0 200,000 0 0 0 0 0 0 0 0 200,000 Park Replacement Fund 800,000 500,000 0 (500,000)(100,000) 0 (100,000) 0 0 0 600,000 Change Activity Adjusted timing and costs. PR-16-0002 Park Lighting 2016 Previously Approved Budget Existing 0 0 0 0 0 0 0 0 0 0 0 Department Final Existing 0 250,000 0 0 175,000 0 480,000 0 0 0 905,000 Change 0 250,000 0 0 175,000 0 480,000 0 0 0 905,000 Park Const Dedication Fees Fund 0 250,000 0 0 175,000 0 0 0 0 0 425,000 Park Replacement Fund 0 0 0 0 0 0 480,000 0 0 0 480,000 Change Activity Added projects PR-22-0001 Asset Renovation/Replacement 2022 Department Final New 100,000 0 100,000 0 0 0 0 0 0 0 200,000 Change 100,000 0 100,000 0 0 0 0 0 0 0 200,000 Park Replacement Fund 100,000 0 100,000 0 0 0 0 0 0 0 200,000 Change Activity Termination of JPA PR-XX-9001 New Trails 2003 Previously Approved Budget Existing 275,000 300,000 0 550,000 0 0 0 0 0 0 1,125,000 Department Final Existing 275,000 360,000 150,000 650,000 0 0 0 0 0 0 1,435,000 Change 0 60,000 150,000 100,000 0 0 0 0 0 0 310,000 Park Const Dedication Fees Fund 0 60,000 150,000 151,000 0 0 0 0 0 0 361,000 Unidentified 0 0 0 (51,000)0 0 0 0 0 0 (51,000) Change Activity Adjusted projects, added new trails and updated costs PR-XX-9002 Trail Repair 2003 Previously Approved Budget Existing 400,000 400,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 0 4,300,000 City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 92 97 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Department Final Existing 400,000 400,000 500,000 400,000 500,000 500,000 600,000 500,000 500,000 500,000 4,800,000 Change 0 0 0 (100,000) 0 0 100,000 0 0 500,000 500,000 Park Replacement Fund 0 0 0 (100,000)292,000 0 600,000 0 500,000 500,000 1,792,000 Unidentified 0 0 0 0 (292,000) 0 (500,000) 0 (500,000) 0 (1,292,000) Change Activity Updated project costs PR-XX-9003 Playground Replacement or Renovation 2006 Previously Approved Budget Existing 270,000 250,000 500,000 270,000 300,000 400,000 350,000 375,000 350,000 0 3,065,000 Department Final Existing 270,000 250,000 500,000 270,000 300,000 400,000 350,000 375,000 350,000 350,000 3,415,000 Change 0 0 0 0 0 0 0 0 0 350,000 350,000 Park Replacement Fund 0 0 0 0 0 0 0 0 0 350,000 350,000 Change Activity PR-XX-9004 Miscellaneous Park Improvements 2006 Previously Approved Budget Existing 100,000 0 0 200,000 150,000 0 150,000 0 200,000 0 800,000 Department Final Existing 110,000 125,000 0 200,000 175,000 0 150,000 0 150,000 150,000 1,060,000 Change 10,000 125,000 0 0 25,000 0 0 0 (50,000) 150,000 260,000 Park Replacement Fund 10,000 125,000 0 0 25,000 0 0 0 (50,000) 150,000 260,000 Change Activity Updated timing and costs of projects PR-XX-9005 Park Amenities & Facilities 2020 Previously Approved Budget Existing 0 0 0 0 0 0 0 200,000 0 0 200,000 Department Final Existing 500,000 0 0 0 0 0 0 200,000 0 0 700,000 Change 500,000 0 0 0 0 0 0 0 0 0 500,000 Park Const Dedication Fees Fund 500,000 0 0 0 0 0 0 0 0 0 500,000 Change Activity City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 93 98 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total PR-XX-9007 Park Building Repair/Renovation 2020 Previously Approved Budget Existing 0 0 0 0 0 1,300,000 0 1,000,000 0 0 2,300,000 Department Final Existing 0 0 0 0 0 1,300,000 0 1,000,000 0 100,000 2,400,000 Change 0 0 0 0 0 0 0 0 0 100,000 100,000 Park Replacement Fund 0 0 0 0 0 1,019,000 0 779,000 0 100,000 1,898,000 Unidentified 0 0 0 0 0 (1,019,000) 0 (779,000) 0 0 (1,798,000) Change Activity Added Hilde Roof and Misc. Repairs for 2031 REC-22-0001 Electronic Sign 2020 Previously Approved Budget Existing 100,000 0 0 0 0 0 0 0 0 0 100,000 Department Final Existing 100,000 0 110,000 0 0 0 0 0 0 0 210,000 Change 0 0 110,000 0 0 0 0 0 0 0 110,000 Rec - Admin 0 0 110,000 0 0 0 0 0 0 0 110,000 Change Activity Added NWG and adjusted Plymouth Creek Playfield Grand Total of CIP (Changed/Unchanged) Budget Stage 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Previously Approved Budget 1,945,000 2,677,000 8,675,000 2,395,000 2,050,000 4,600,000 2,100,000 3,425,000 2,625,000 0 30,492,000 Department Final 2,980,000 3,635,000 9,035,000 2,920,000 2,175,000 4,600,000 1,880,000 3,425,000 1,475,000 1,500,000 33,625,000 Change 1,035,000 958,000 360,000 525,000 125,000 0 (220,000) 0 (1,150,000) 1,500,000 3,133,000 Total Net Change In Funding Sources 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Park Const Dedication Fees Fund 500,000 510,000 150,000 851,000 175,000 0 0 714,420 (399,000) 0 2,501,420 Park Replacement Fund 535,000 448,000 100,000 (275,000) 242,000 1,019,000 364,000 779,000 180,000 1,500,000 4,892,000 Rec - Admin 0 0 110,000 0 0 0 0 0 0 0 110,000 Unidentified 0 0 0 (51,000)(292,000)(1,019,000)(584,000)(1,493,420)(931,000) 0 (4,370,420) Change 1,035,000 958,000 360,000 525,000 125,000 0 (220,000) 0 (1,150,000) 1,500,000 3,133,000 City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 94 99 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total PUBLIC WORKS Street Maintenance ST-17-0002 Hamel Road Frontage Road Connection 2016 Previously Approved Budget New 0 0 0 0 0 0 0 0 0 0 0 Department Final Existing 0 1,600,000 0 0 0 0 0 0 0 0 1,600,000 Change 0 1,600,000 0 0 0 0 0 0 0 0 1,600,000 Other Governmental Agency 0 710,000 0 0 0 0 0 0 0 0 710,000 Sewer - Admin 0 50,000 0 0 0 0 0 0 0 0 50,000 Special Assessments 0 500,000 0 0 0 0 0 0 0 0 500,000 Street Reconstruction Fund 0 290,000 0 0 0 0 0 0 0 0 290,000 Water - Admin 0 50,000 0 0 0 0 0 0 0 0 50,000 Change Activity Carryover project: grant/development driven ST-20-0002 CR 9 at TH 169 Bridge Replacement 2019 Previously Approved Budget Existing 0 1,500,000 0 0 0 0 0 0 0 0 1,500,000 Department Final Existing 0 1,150,000 0 0 0 0 0 0 0 0 1,150,000 Change 0 (350,000) 0 0 0 0 0 0 0 0 (350,000) Minnesota State Aid Fund 0 (460,000)0 0 0 0 0 0 0 0 (460,000) Park Replacement Fund 0 60,000 0 0 0 0 0 0 0 0 60,000 Sewer - Admin 0 50,000 0 0 0 0 0 0 0 0 50,000 Water - Admin 0 (150,000)0 0 0 0 0 0 0 0 (150,000) Water Resources - Admin 0 150,000 0 0 0 0 0 0 0 0 150,000 Change Activity Updated per MNDOT layout City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 95 100 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ST-21-0003 CSAH 101 & CR 47 Intersection Improvements 2021 Previously Approved Budget New 0 0 0 0 0 0 0 0 0 0 0 Department Final Existing 200,000 0 0 0 0 0 0 0 0 0 200,000 Change 200,000 0 0 0 0 0 0 0 0 0 200,000 Street Reconstruction Fund 200,000 0 0 0 0 0 0 0 0 0 200,000 Change Activity Carryover project: Medina lead project ST-22-0001 CR 47 Reconstruction - Phase 1 (CR 101 to Peony)2020 Previously Approved Budget New 28,000,000 0 0 0 0 0 0 0 0 0 28,000,000 Department Final Existing 9,000,000 0 0 0 0 0 0 0 0 0 9,000,000 Change (19,000,000) 0 0 0 0 0 0 0 0 0 (19,000,000) Hennepin County 5,000,000 0 0 0 0 0 0 0 0 0 5,000,000 Minnesota State Aid Fund 2,300,000 0 0 0 0 0 0 0 0 0 2,300,000 Street Reconstruction Fund 1,600,000 0 0 0 0 0 0 0 0 0 1,600,000 Unidentified (28,000,000)0 0 0 0 0 0 0 0 0 (28,000,000) Water - Admin 100,000 0 0 0 0 0 0 0 0 0 100,000 Change Activity Separated into phases per preliminary design ST-22-0002 Comstock & Schmidt Lake Intersection Improvements 2022 Department Final New 650,000 0 0 0 0 0 0 0 0 0 650,000 Change 650,000 0 0 0 0 0 0 0 0 0 650,000 Other Agency 450,000 0 0 0 0 0 0 0 0 0 450,000 Street Reconstruction Fund 200,000 0 0 0 0 0 0 0 0 0 200,000 Change Activity Safety improvement project ST-23-0001 City Center Roadways Rehabilitation 2020 Department Final New 150,000 6,775,000 7,175,000 0 0 0 0 0 0 0 14,100,000 Change 150,000 6,775,000 7,175,000 0 0 0 0 0 0 0 14,100,000 Minnesota State Aid Fund 0 1,200,000 1,200,000 0 0 0 0 0 0 0 2,400,000 Special Assessments 0 1,500,000 500,000 0 0 0 0 0 0 0 2,000,000 City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 96 101 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Street Reconstruction Fund 150,000 2,750,000 2,000,000 0 0 0 0 0 0 0 4,900,000 Unidentified 0 825,000 3,225,000 0 0 0 0 0 0 0 4,050,000 Water Resources - Admin 0 500,000 250,000 0 0 0 0 0 0 0 750,000 Change Activity Pavement preservation and City Center 2.0 improvements ST-23-0002 CR 47 Reconstruction - Phase 2 (Peony to Vicksburg)2022 Department Final New 300,000 7,200,000 0 0 0 0 0 0 0 0 7,500,000 Change 300,000 7,200,000 0 0 0 0 0 0 0 0 7,500,000 Bonds 0 6,500,000 0 0 0 0 0 0 0 0 6,500,000 Street Reconstruction Fund 300,000 700,000 0 0 0 0 0 0 0 0 1,000,000 Change Activity Phase 2 per preliminary design ST-23-0003 Hwy 55 Underpass at Station 73 2022 Department Final New 0 6,500,000 5,000,000 0 0 0 0 0 0 0 11,500,000 Change 0 6,500,000 5,000,000 0 0 0 0 0 0 0 11,500,000 Other Governmental Agency 0 5,500,000 4,000,000 0 0 0 0 0 0 0 9,500,000 Transit - Admin 0 1,000,000 1,000,000 0 0 0 0 0 0 0 2,000,000 Change Activity New project ST-23-0004 Hwy 55 Pavement Preservation Project 2022 Department Final New 0 100,000 100,000 0 0 0 0 0 0 0 200,000 Change 0 100,000 100,000 0 0 0 0 0 0 0 200,000 Street Reconstruction Fund 0 100,000 100,000 0 0 0 0 0 0 0 200,000 Change Activity New project City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 97 102 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ST-23-0005 Lancaster & Pilgrim Intersection and Stormwater Improvements 2022 Department Final New 0 1,400,000 0 0 0 0 0 0 0 0 1,400,000 Change 0 1,400,000 0 0 0 0 0 0 0 0 1,400,000 Street Reconstruction Fund 0 100,000 0 0 0 0 0 0 0 0 100,000 Water Resources - Admin 0 500,000 0 0 0 0 0 0 0 0 500,000 Watershed District 0 800,000 0 0 0 0 0 0 0 0 800,000 Change Activity New project with Four Seasons Mall redevelopment ST-24-0002 CR 47 Reconstruction - Phase 3 (Vicksburg to CR 61)2022 Department Final New 0 0 13,500,000 0 0 0 0 0 0 0 13,500,000 Change 0 0 13,500,000 0 0 0 0 0 0 0 13,500,000 Bonds 0 0 13,500,000 0 0 0 0 0 0 0 13,500,000 Change Activity Phase 3 per preliminary design ST-25-0002 36th Ave at TH 169 Bridge Replacement 2021 Previously Approved Budget New 0 0 0 500,000 0 0 0 0 0 0 500,000 Department Final Existing 0 0 500,000 0 0 0 0 0 0 0 500,000 Change 0 0 500,000 (500,000) 0 0 0 0 0 0 0 Minnesota State Aid Fund 0 0 500,000 (500,000)0 0 0 0 0 0 0 Change Activity MNDOT project City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 98 103 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total ST-XX-9001 Annual Street Reconstruction 2012 Previously Approved Budget Existing 5,850,000 5,900,000 4,100,000 3,350,000 4,750,000 3,650,000 8,750,000 8,750,000 8,750,000 0 53,850,000 Department Final Existing 5,850,000 5,900,000 4,100,000 3,350,000 4,750,000 3,650,000 8,750,000 8,750,000 8,750,000 8,750,000 62,600,000 Change 0 0 0 0 0 0 0 0 0 8,750,000 8,750,000 Sewer - Admin 0 0 0 0 0 0 0 0 0 100,000 100,000 Special Assessments 20,000 (390,000)0 0 0 0 0 0 0 1,700,000 1,330,000 Street Reconstruction Fund (20,000)390,000 0 0 0 0 0 0 0 4,530,000 4,900,000 Water - Admin 0 0 0 0 0 0 0 0 0 2,300,000 2,300,000 Water Resources - Admin 0 0 0 0 0 0 0 0 0 120,000 120,000 Change Activity Added 2031 projects ST-XX-9002 Mill & Overlay Projects 2005 Previously Approved Budget Existing 1,150,000 2,300,000 1,200,000 1,400,000 1,800,000 1,300,000 1,300,000 1,350,000 1,350,000 0 13,150,000 Department Final Existing 1,150,000 2,300,000 1,200,000 1,400,000 1,800,000 1,300,000 1,300,000 1,350,000 1,350,000 1,350,000 14,500,000 Change 0 0 0 0 0 0 0 0 0 1,350,000 1,350,000 Sewer - Admin 0 0 0 0 0 0 0 0 0 90,000 90,000 Special Assessments 0 100,000 0 0 0 0 0 0 0 250,000 350,000 Street Reconstruction Fund 0 (100,000)0 0 0 0 0 0 0 775,000 675,000 Water - Admin 0 0 0 0 0 0 0 0 0 200,000 200,000 Water Resources - Admin 0 0 0 0 0 0 0 0 0 35,000 35,000 Change Activity Added 2031 projects ST-XX-9003 Replace Retaining Walls 2005 Previously Approved Budget Existing 130,000 100,000 100,000 115,000 115,000 115,000 115,000 115,000 130,000 0 1,035,000 Department Final Existing 130,000 100,000 100,000 115,000 115,000 115,000 115,000 115,000 130,000 130,000 1,165,000 Change 0 0 0 0 0 0 0 0 0 130,000 130,000 Street Reconstruction Fund 0 0 0 0 0 0 0 0 0 130,000 130,000 Change Activity Added 2031 projects ST-XX-9005 Full Depth Reclamation (FDR) Project 2019 Previously Approved Budget Existing 3,200,000 4,700,000 3,900,000 4,150,000 3,200,000 3,300,000 5,400,000 4,000,000 4,000,000 0 35,850,000 Department Final Existing 3,200,000 4,700,000 3,900,000 4,150,000 3,200,000 3,300,000 5,400,000 4,000,000 4,000,000 4,200,000 40,050,000 City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 99 104 Department / Division / Budget Stage Project Status Year Identified 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Change 0 0 0 0 0 0 0 0 0 4,200,000 4,200,000 Minnesota State Aid Fund 200,000 (350,000)0 0 0 0 0 0 0 2,250,000 2,100,000 Sewer - Admin 0 0 0 0 0 0 0 0 0 70,000 70,000 Special Assessments (200,000)350,000 0 0 0 0 0 0 0 300,000 450,000 Street Reconstruction Fund 0 0 0 0 0 0 0 0 0 1,230,000 1,230,000 Water - Admin 0 0 0 0 0 0 0 0 0 200,000 200,000 Water Resources - Admin 0 0 0 0 0 0 0 0 0 150,000 150,000 Change Activity Added 2031 projects ST-XX-9007 Concrete Sidewalk Replacement 2007 Previously Approved Budget Existing 75,000 75,000 100,000 100,000 100,000 150,000 150,000 150,000 150,000 0 1,050,000 Department Final Existing 75,000 75,000 0 0 300,000 0 0 75,000 75,000 75,000 675,000 Change 0 0 (100,000)(100,000) 200,000 (150,000)(150,000)(75,000)(75,000) 75,000 (375,000) Street Reconstruction Fund 0 0 (100,000)(100,000)200,000 (150,000)(150,000)(75,000)(75,000) 75,000 (375,000) Change Activity Update per sidewalk ratings Grand Total of CIP (Changed/Unchanged) Budget Stage 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Previously Approved Budget 38,505,000 14,675,000 10,245,000 15,915,000 10,265,000 11,565,000 15,715,000 14,915,000 17,080,000 0 148,880,000 Department Final 20,805,000 37,900,000 36,420,000 15,315,000 10,465,000 11,415,000 15,565,000 14,840,000 17,005,000 14,505,000 194,235,000 Change (17,700,000) 23,225,000 26,175,000 (600,000) 200,000 (150,000)(150,000)(75,000)(75,000) 14,505,000 45,355,000 City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 100 105 Total Net Change In Funding Sources 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Total Bonds 0 6,500,000 13,500,000 0 0 0 0 0 0 0 20,000,000 Hennepin County 5,000,000 0 0 0 0 0 0 0 0 0 5,000,000 Minnesota State Aid Fund 2,500,000 390,000 2,200,000 1,750,000 0 0 0 0 0 2,250,000 9,090,000 Other Agency 450,000 0 0 0 0 0 0 0 0 0 450,000 Other Governmental Agency 0 6,210,000 4,000,000 0 0 0 0 0 0 0 10,210,000 Park Replacement Fund 0 60,000 0 0 0 0 0 0 0 0 60,000 Sewer - Admin 0 100,000 0 0 0 0 0 0 0 260,000 360,000 Special Assessments (180,000) 2,060,000 500,000 0 0 0 0 0 0 2,250,000 4,630,000 Street Reconstruction Fund 2,430,000 4,230,000 2,000,000 2,350,000 200,000 (150,000)(150,000)(75,000)(75,000) 6,740,000 17,500,000 Transit - Admin 0 1,000,000 1,000,000 0 0 0 0 0 0 0 2,000,000 Unidentified (28,000,000) 825,000 2,725,000 (5,500,000) 0 0 0 0 0 0 (29,950,000) Water - Admin 100,000 (100,000) 0 500,000 0 0 0 0 0 2,700,000 3,200,000 Water Resources - Admin 0 1,150,000 250,000 300,000 0 0 0 0 0 305,000 2,005,000 Watershed District 0 800,000 0 0 0 0 0 0 0 0 800,000 Change (17,700,000) 23,225,000 26,175,000 (600,000) 200,000 (150,000)(150,000)(75,000)(75,000) 14,505,000 45,355,000 City of Plymouth Capital Improvement Plan 2022-2031 Project Change Report Page 101 106 Special City Council September 21, 2021 Agenda Number:2.2 To:Dave Callister, City Manager Prepared by:Amy Gottschalk, Office Support Representative Reviewed by:Maria Solano, Deputy City Manager Item:Set future Study Sessions 1. Action Requested: Schedule Study Sessions and/or add topics as desired. Calendars are attached to assist with scheduling. 2. Background: Pending Study Session topics (at least three Council members have approved the following study items on the list): Pick-up Lane Discussion Staff requests for Study Session topics and/or changes: -Add review Board and Commission applications to the November 23 study session -Board and Commission interviews on December 7 at 5:00 p.m. 3. Budget Impact: N/A 4. Attachments: September October November December January February 107 SUN MON TUE WED THU FRI SAT 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 September 2021 3400 Plymouth Boulevard Plymouth, MN 55447 OFFICIAL CITY CALENDAR 763-509-5080 plymouthmn.gov SUN TUES MON WED THUR FRI SAT CHANGES ARE MADE IN RED LABOR DAY CITY OFFICES CLOSED 5:00 PM SPECIAL COUNCIL MEETING Budget Study Session Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers 5:00 PM SPECIAL COUNCIL MEETING County Road 73 small area study/ Comstock Lane and Schmidt Lake Road Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers 2 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM PARK & REC ADVISORY COMMISSION MEETING Council Chambers 7:00 PM ENVIRONMENTAL QUALITY COMMITTEE MEETING Medicine Lake Room 7:00 PM HOUSING AND REDEVELOPMENT AUTHORITY MEETING Medicine Lake Room 5:00 PM SPECIAL COUNCIL MEETING Budget Study Session Medicine Lake Room 108 SUN MON TUE WED THU FRI SAT 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 October 2021 3400 Plymouth Boulevard Plymouth, MN 55447 OFFICIAL CITY CALENDAR 763-509-5080 plymouthmn.gov 5:30 PM SPECIAL COUNCIL MEETING Environmental Update/Alcohol in Parks/Convention and Visitors Bureau Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers SUN TUES MON WED THUR FRI SAT 5:00 PM SPECIAL COUNCIL MEETING Budget Study Session Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers CHANGES ARE NOTED IN RED CHA 31 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM ENVIRONMENTAL QUALITY COMMITTEE MEETING Medicine Lake Room 7:00 PM HOUSING AND REDEVELOPMENT AUTHORITY MEETING Council Chambers 109 SUN MON TUE WED THU FRI SAT 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 November 2021 3400 Plymouth Boulevard Plymouth, MN 55447 OFFICIAL CITY CALENDAR 763-509-5080 plymouthmn.gov 5:00 PM SPECIAL COUNCIL MEETING Budget Study Session Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers THANKSGIVING HOLIDAY 5:00 PM SPECIAL COUNCIL MEETING Budget Study Session (if needed) Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers SUN TUES MON THUR FRI SAT THANKSGIVING HOLIDAY CITY OFFICES CLOSED CITY OFFICES CLOSED VETERANS DAY CITY OFFICES CLOSED PLYMOUTH ARTS FAIR City Hall PLYMOUTH ARTS FAIR City Hall 7:00 PM PARK & REC ADVISORY COMMISSION MEETING Council Chambers WED 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM ENVIRONMENTAL QUALITY COMMITTEE MEETING Medicine Lake Room 7:00 PM HOUSING AND REDEVELOPMENT AUTHORITY MEETING Medicine Lake Room PLYMOUTH ARTS FAIR City Hall 110 SUN MON TUE WED THU FRI SAT 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 December 2021 3400 Plymouth Boulevard Plymouth, MN 55447 OFFICIAL CITY CALENDAR 763-509-5080 plymouthmn.gov 5:00 PM SPECIAL COUNCIL MEETING Review Four Seasons Mall Development Proposals Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers SUN TUES MON WED THUR FRI SAT CHRISTMAS EVE CITY OFFICES CLOSED 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM ENVIRONMENTAL QUALITY COMMITTEE MEETING Council Chambers 7:00 PM CHARTER COMMISSION ANNUAL MEETING Medicine Lake Room 7:00 PM HOUSING AND REDEVELOPMENT AUTHORITY MEETING Medicine Lake Room 111 SUN MON TUE WED THU FRI SAT 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 MARTIN LUTHER KING JR. BIRTHDAY CITY OFFICES CLOSED 18 19 20 21 22 23 24 25 26 27 28 29 January 2022 3400 Plymouth Boulevard Plymouth, MN 55447 OFFICIAL CITY CALENDAR 763-509-5080 plymouthmn.gov 7:00 PM PLANNING COMMISSION MEETING Council Chambers SUN TUES MON WED THUR FRI SAT CHANGES ARE NOTED IN RED 7:00 PM REGULAR COUNCIL MEETING Council Chambers 7:00 PM ENVIRONMENTAL QUALITY COMMITTEE MEETING Council Chambers 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM PARK & REC ADVISORY COMMISSION MEETING Council Chambers 30 7:00 PM HOUSING AND REDEVELOPMENT AUTHORITY MEETING Council Chambers 31 5:00 PM SPECIAL COUNCIL MEETING Developer Interviews for Four Seasons Mall Redevelopment Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers NEW YEAR’S DAY OBSERVED CITY OFFICES CLOSED 112 SUN MON TUE WED THU FRI SAT 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1 18 19 20 21 22 23 24 25 26 27 28 SUN TUES MON WED THUR FRI SAT February 2022 3400 Plymouth Boulevard Plymouth, MN 55447 OFFICIAL CITY CALENDAR 763-509-5080 plymouthmn.gov 7:00 PM REGULAR COUNCIL MEETING Council Chambers PRESIDENTS DAY CITY OFFICES CLOSED 5:00 PM SPECIAL COUNCIL MEETING Water System Extension Request with Medicine Lake City Council Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM PLANNING COMMISSION MEETING Council Chambers 7:00 PM ENVIRONMENTAL QUALITY COMMITTEE MEETING Council Chambers 7:00 PM PARK & REC ADVISORY COMMISSION MEETING Council Chambers 7:00 PM HOUSING AND REDEVELOPMENT AUTHORITY MEETING Council Chambers 113