The URL can be used to link to this page

Home My WebLink AboutSpecial Council Workshop Minutes 08.30.2021MINUTES CITY OF LAUREL SPECIAL CITY COUNCIL WORKSHOP MONDAY, AUGUST 30, 2021 A Council Workshop was held in Council Chambers and called to order by Mayor Tom Nelson at 6:31 p.m. on August 30, 2021. COUNCIL MEMBERS PRESENT: _ Emelie Eaton _x Heidi Sparks x Bruce McGee x Richard Herr x Scot Stokes x Iry Wilke x Richard Klose Don Nelson Kurt Markegard, Public Works Director Nick Altonaga, Planning Director Stan Langve, Police Chief Jean Kerr, City Judge Fran Schweigert, 316 Union President Public Input: There were none. General Items Executive Review 1. Review FY 2022 Budget The attached draft budget was reviewed. Nick Altonaga, Planning Director, stated there was one change to his budget from the last meeting. Municity was added; it will also integrate with LaserFiche. The initial cost is $57k, the maintenance fee going forward will be $9k per year. Kurt Markegard, Public Works Director, briefly reviewed all the proposed changes with his budgets. A Council Member noted that at Budget/Finance Committee, they had a request for garbage cans. It was clarified that those were purchased some time ago and were supposed to be delivered before the 4`h of July. They did not make it. The last update they heard was those garbage cans are still sitting in Colorado. They purchase approximately 50 cars each spring. The City has about 1500 to 2000 cans around town. Cans recently doubled in price. Manufacturers are having an issue keeping up with supply. Staff is trying to buy products made in the USA. When crews replaced the line on W. 12`h Street, it had a casting date of 1935. Jean Kerr, Judge, noticed that CARES funds were being spent in the FAP. Most of those funds have been budgeted for. She asked for consideration that the Court be moved to a larger space. If Count were moved into Council Chambers, it would need some updating to work for them. Council asked if this budget was balanced. Mayor Nelson clarified that he is required by law to present a balanced budget. Council asked if they could start looking at next year's budget at the end of September. Council noted they are nervous about next year's budget. It is such a short period of time to try and wrap their brains around the budget. The Pool has been budgeted to be opened this year. Council Issues Other Items Review of Draft Council Agendas Attendance at Upcoming Council Meeting Announcements LURA had a meeting to remove the contentious items from the LURA grants. Those items will be coming back to Council. Emergency Services Committee is scheduled to meet on August 31, 2021, at 6:00 p.m. in Council Chambers. Park Board is scheduled to meet on September 2, 2021, at 5:30 p.m. in Council Conference Room. A dog waste station will be installed at Lion's Park, paid for by the Lions. More garbage cans will be available as well. Kids Kingdom has met its fundraising goal and can now order new playground equipment. A Local dealership wrote a check for $25k to move this project forward. The council workshop adjourned at 7:55 p.m. Respectfully tted, Brittney Moorm Administrative Assistant NOTE: This meeting is open to the public. This meeting is for information and discussion of the Council for the listed workshop agenda items. CITY OF LAUREL, MONTANA TAX LEVY REQUIREMENTS SCHEDULE NON -VOTED LEVIES Assessed/Market Valuation: 632,291,718 (3)T t Taxable Valuation Less o «,.=yvn=...ems must equal Column (8) Total Resources TIF Incremental Value: 8,810,057 1 Mill Yield510): 8,810 'Column Fiscal Year: 2021-2022 Page No. .. • ....... -n negative, appropriation exceed the revenues TOM? Requirements compared to Tatal Resources 0 'if other than zero budget is not balanced NOTE: atoll Cash Reserves (a)acountyifund may notexceedoneffiW(33%)ofthemtalamount appmpmted and Mhomedto be agent Mmthefund dudngthe current Osaalyeagand Per MCA. 7-6aa34 (b)a chys or town'shsrd may net exceed ono-half(SM)of the total amount appmpmted and authamed to be spentfrom the fund during the current fusel year. 6e o «,.=yvn=...ems must equal Column (8) Total Resources (till (2) 131.111-17) (el Isl (61.1o."il pl•161H61 10•IaH14 !61•(61+pq nsp[aHaWTI 'should equal Cash -should Budgeted column (8) Available Property equal Estimated Fund Cash Total (Lesscurrent Non Tax Tax Total calumn(3) Total Mill Ending Cash # Fund Name Appropriations Reserve Requirements liabilities) Revenues Revenues Revenues Resources levy Balance 1000 GENERAL 4,849,877 1,011,902 5,861,779 1,816,477 3,378,033 667,269 4,045,302 5,861,779 75.74 1,011,902 21% RESERVES 0 COMPREHENSIVE 0 0 0 2190 INSURANCE 116,592 29,634 146,226 19,784 12,000 114,442 126,442 146,226 12.99 29,634 25% RESERVES 0 2220 LIBRARY 278,707 6,451 285,158 _ 7,795 1,610 275,753 0 277,363 0 285,158 31.30 0 6,451 2% RESERVES 0 2370 PERS 107,905 19,816 127,721 19,759 7,000 100,963 0 107,963 0 127,721 31.46 0 19,816 18% RESERVES 0 EMPLOYER 0 0 0 CONTRIBUTION GROUP 2371 HEALTH 210,000 54,784 264,784 53,584 35,000 176,200 211,200 264,784 20.00 54,784 26% RESERVES 0 7120 FIRE DISABILITY 57,048 0 57,048 3,308 18,500 35,240 0 53,740 0 57,048 4.00 0 0 p 0 0 0 TOTAL 5,620,129 3,122,587 6,742,7166 1,920,706 Qefal Foonn,uc mmna..a,,. r..«,• � v 3,452,343 1,369,867 0 4,822,010 p 6,742,736 155.49 p 1,122,587 .. • ....... -n negative, appropriation exceed the revenues TOM? Requirements compared to Tatal Resources 0 'if other than zero budget is not balanced NOTE: atoll Cash Reserves (a)acountyifund may notexceedoneffiW(33%)ofthemtalamount appmpmted and Mhomedto be agent Mmthefund dudngthe current Osaalyeagand Per MCA. 7-6aa34 (b)a chys or town'shsrd may net exceed ono-half(SM)of the total amount appmpmted and authamed to be spentfrom the fund during the current fusel year. 6e fill, �� mlims -2- 08/29/21 CITY OF LAUREL Page: 1 of 3 13:41:37 Revenue Budget Report -- Multiyear Actuals Report 1D: 825DB For the Year: 2021 - 2022 993,706 731,301 649,543 629,622 Current B Prelim. Budget Final \ Old --------------- Actuals ----------------- Budget Rec. Budget Change Budget Budget Account 17-18 18-19 19-20 ..._"--------- -------------- ---------------------------------------- 20-21 20-21 20-21 ---------- ---- 21-22 ---------- 21-22 21-22 -------------------- 21-22 ------ 1000 GENERAL 310000 TAXES 311010 Real Property Taxes 1,001,757 993,706 731,301 649,543 629,622 1034 653,954 653,954 1031 311020 Personal Property Taxes 12,844 22,203 13,993 13,052 12,850 1024 13,315 13,315 103% 312000 P a l on Delinquent Taxes 3,784 21500 1,847 2,998 11500 200% 1,500 11500 100% 314140 Local Option Tax 91,863 100,657 96,712 103,289 91,500 113% 91,500 91,500 100% Group: 1,110,248 1,119,074 843,853 768,882 735,472 1055 760,269 0 760,269 103% 32000D LICENSES AND PERMITS 322011 Liquor Licenses 31654 3,654 2,842 4,095 3,500 117% 3,500 31500 100% 322012 Beer s Wine Licenses 3,800 4,100 3,400 2,800 3,500 801 2,500 2,500 71t 322021 Business Inspections 32,775 34,894 27,000 36,013 32,000 113% 32,000 32,000 100% 322022 Utilities 600 600 900 938 600 156% 600 60D IOOt 322023 Pew. Brokers 5 0 0% 0 0% 322024 3 Apartments 30 30 30 30 30 100% 30 30 100% 322025 4 Apartments 440 440 240 520 400 1308 400 400 loot 322026 5 Apartments or More 1,500 1,350 825 1,125 1, SOD 75% 1,000 1,000 66% 322027 Amusement Machines 350 400 350 450 350 129% 45D 450 1281 322028 Live Music 100 150 150 150 150 100% 150 150 100% 32203D Franchise Fees 73,541 79,941 73,025 83,616 72,000 116% 80,000 80,000 lilt 323011 Building Permits 40,634 52,096 40,892 61,668 45,000 137% 45,000 45,000 100% 323012 Demolition Permit 90 315 180 205 200 103% 200 200 1001 323013 Plumbing 45 50 0 0% 0 O% 323014 Bldg Plan Review 7,267 10,758 7,962 14,508 9,000 161% 9,000 91000 100% 323030 Dog Licenses 4,056 4,274 4,292 2,015 41000 50% 2,000 21000 50% 323051 Right -of -Way Permits 895 675 1,135 1,270 800 159% 800 800 loot 323053 Sign Permit 246 016 2,443 500 4891 1,500 1,500 300% 323054 Flood Plain Permit 50 0 ^•4 50 50 .....1 323055 Special Events Permits 320 150 50 50 150 33% 50 50 33% Group: 170,102 194,073 164,141 211,946 173,680 122% 179,230 0 179,230 103% 330000 INTERGOVERNMENTAL REVENUES 331026 Department of Justice 9,089 3,935 0 "`% 0 0% 331027 US TREASURY DEA OVERTIME 1,246 0 ••`t 1,000 11000 .....t 331100 Flood Control Grant 599,267 1,355,723 0 •••% 0 Ot 331178 DUI Task Force 2,560 2,728 1,429 1,500 95% 1,200 1,200 80% 332010 Federal Equitable Shared 5,869 0 O% 0 O% 334100 Library Aid Grant 8,467 9,258 0 04 0 0% 334200 GASB 68/Public Safety 222,626 215,146 ,0 0% 0 0% 334300 GASB 68/Public Wrks State 7,535 6,306 0 OB 0 O% 334600 GASB 68/Culture and per. 4,325 51156 0 01 0 0% 335075 Poker/Keno/Bingo -40 0 Ot 0 O% 335110 Live Card Game Table 150 175 150 150 0% 0 O% 335120 Gambling Machine Permits 24,150 26,076 22,400 24,775 22,000 113* 20,000 20,000 90% 335230 HB124 Entitlement 879,799 896,555 993,693 769,700 1,026,277 75% 1,041,098 1,041,098 IOlt 336020 On Behalf, Payments 220,700 0 OR 0 0% Group: 1,133,228 1,174,848 1,854,064 2,156,816 1,049,927 205% 1,063,298 0 1,063,298 101t -3- 08/29/21 CITY OF LAUREL Page: 2 of 3 13:41,37 Revenue Budget Report -- MuWYear Actuals Report tD: B250B NSF Check Charges For the Year: 2021 - 2022 810 570 11000 578 Current % Prelim. Budget Final % Old ---------------- Actuals -------.--------- Budget Rec. Budget Change Budget Budget Account 17-18 18-19 19-20 --------------------------------------- ----------- ----- -------- 20-21 20-21 20-21 ------- ---------- ---- 21-22 ---------- 21-22 21-22 -------------------- 21-22 ------ 1000 GENERAL, .340000 CHARGES FOR SERVICES 341012 NSF Check Charges 803 967 810 570 11000 578 500 341020 Administrative Services 275,652 275,652 310,101 284,260 310,101 92% 280,000 341022 Light District 13 0 0% 130,116 342010 Law Enforcement 40 288 0 0% 342014 SRO Program - School 112,472 88,957 77,712 129,483 O% 130,116 342015 Finger Printing Service 2,760 4,295 5,215 2,500 3,500 71% 2,500 342016 Report Copy Service 2,309 2,860 1.770 2,820 11500 188% 2,500 342017 Vehicle Impound Fee 130 100 0% 100 342020 Fire District 15 16,086 16,568 17,065 17,577 17,577 100% 19,784 342021 Fire District 47 164,786 140,051 140,051 140,000 0% 140,000 342022 Fire District B8 6,788 61991. 7,201 7,417 7,417 100% 7,640 342023 Fire District - A A 4,705 4,799 4,895 4,993 4,993 ]ODS 5,195 342024 Fire Service Are. 86,031 88,619 91,277 105,327 94,015 112% 96,836 342025 Rural Grass Fire 10,817 10,980 11,145 11,000 0% 11,DOD 342026 Yellowstone Trent Cntr 9,694 9,888 10,086 10,287 10,287 1001 10,493 342028 Fire Inspections 450 1,125 325 445 700 64% 450 342029 Fire Contract - CHS 91500 91500 91500 4,750 9,500 501 91500 342049 Ambulance Collection 31500 1,723 5 11500 D% 1,000 342050 Ambulance Services 189,909 188,670 245,597 392,597 215,000 1831 350,000 342051 Yrly Medicaid 13,432 6,777 18,373 13,626 7,000 195% 7,500 343320 Sale of Cemetery Plots 6,108 3,823 4,015 5,075 4,000 127% 4,000 343340 Opening and Closing 10,785 11,930 8,515 61090 10,000 61% 5,000 344010 Animal Control Impound 2,345 2,145 11680 1,D85 2,000 54% 11000. 346030 Swimming Pool Fees 81680 11,009 61lll 0 0% 346035 Picnic Shelter Fees 11680 1,810 640 1,930 500 386% 1,500 346070 Library Fines 57 68 0 0% 346075 Library Card Fees 25 0 0% 346076 Library Copy Fees 675 270 98 0 O% Group: 940,175 889,895 972,187 861,349 981,173 88% 1,216,730 350000 Fines and Forfeitures 351000 City Court 113,906 102,578 116,143 134,874 110,000 123% 130,000 _ 351030 Court Surcharge 9,632 8,594 81010 7,349 8,500 86% 7,000 _ 351031 Restitution to City 704 65 553 150 369% 150 _ 351035 Crime Victims - Court 144 124 130 126 125 101* 125 _ Group: 124,386 111,361 124,283 142,902 118,775 120% 137,275 360000 Miscellaneous Revenue 360000 Miscellaneous Revenue 6,545 9,054 91595 15,705 3,500 449% 3,000 _ 361000 Rents/Leases 16,710 16,650 20,650 17,000 16,500 103% 16,500 _ 362000 Other Miscellaneous -1,742 6,382 338,052 377,000 90% 184,000 _ Lion's Family Park $92,000 - Lion's Club 830,000 - Community Foundation 862,000 - Department of Justice League H 500 50% 280,000 90% 13D.116 --% D O% 130,116 100% 2,500 71% 2,500 166% 100 100% 19,784 112% 140,000 100% 7,640 103% 5,195 104% 96,836 103% 11,000 IDO% 10,493 102% 450 641 9,500 100% 1,000 66% 350,000 162* 7,500 107% 4,000 100% 5,000 50% 1,000 501 _ 0 0% 1,500 3001 0 O% 0 01 0 0% 0 1,216, 730 124% 130,000 118% 7,000 82% 150 100% 125 100% 0 137,275 115% 3,000 85% 16,500 100* 184,000 48% 08/29/21 CITY OF LAUREL Library Donations 955 Page: 3 of 3 365002 13:41:37 Revenue Budget Report -- MultiYear Actuals 5,969 Report TO: B250B 365003 For the Year: 2021 - 2022 305 365004 Ambulance Donations 2,500 Current \ Prelim. Budget Final % Old ---------------- Actuals ----------------- Budget Ree. Budget Change Budget Badger Account 17-18 18-19 19-20 20-21 ------------------------ ------ __.-------- -------------------- ---------- 20-21 20-21 ----- ------ ---- 21-22 ---------- 21-22 21-22 ---------- ---------- 21-22 --_--- 1000 GENERAL 365001 Library Donations 955 80 365002 Fire Department Donations 5,969 2,750 365003 Police Dept. Donations 39 305 365004 Ambulance Donations 2,500 6,500 365005 Park Dedication/Donation 4,210 2,850 .....% Group: 36,928 36,447 370000 Investment and Royalty Earnings 11000 `•"`1 371010 Investment Earnings 4,350 7,963 Group: 4,350 7,963 380000 Other Financing Soucces 850 0 0% 0 O\ 2,350 4,300 0 •••\ 4,000 4,000 .....% 52,888 0 •••\ 5,000 51000 .....% 2,062 300 0 "•1 1,000 11000 `•"`1 750 900 0 +"1 1,000 1,000 •`••+6 42,639 429,145 397,000 108% 214,500 0 214,500 542 6,178 1,072 3, GOD 36% 1,000 1,000 33% 6,178 1,072 3,000 36% 1,000 0 1,000 33% 391050 Inception of Capital 40,919 29,099 0 0% 382020 Compensation for Loss of 68,852 0 0% 383000 Interfund Operating 26,000 26,000 26,000 23,833 26,000 92% 23,000 383003 Transfer-Permis. Med. 201,654 245,778 205,564 200,000 200,000 100% 240,000 383004 Transfer -Group Health 190,727 200,000 199,751 207,000 207,000 100% 210,000 383007 Transfer in From Federal 23,091 21,167 0 0% Group: 482,391 561,797 460,414 430,833 433,000 99% 473,000 Fund: 4, OD 1, 808 4,095,458 4,467,759 5,002,945 3,892,027 129% 4,045,302 Grand Total: 4,001,808 4,095,458 4,467,759 5,002,945 3,892,027 4,045,302 -5- 0 0% 0 0% 23,000 88% 240,000 120\ 210,000 IDI% 0 O1 0 473,000 109% 0 4,045,302 103% 0 4,045,302 rJ 08/29/21 CITY OF LAUREL Page: l of 25 13:47:30 Expenditure Budget by Org Report Multi Year Actuals Report ID: BP40A1 For the Year: 2021 - 2022 100 GENERAL FUND Current 1 Prelim. Budget Final 1 Old ---------------- Acbusle ----------------- Budget Exp. Budget Changes Budget Budget Account Object ________________________________ 17-.18 __________ 18-19 __________ 19-20 20-21 20-2.1. 20-21 21-22 21-22 21-22 21-22 1000 GENERAL __________ __________ __________ ____ __________ __________ __________ ------ 410580 Data Processing 220 Operating Supplies 598 0 0% 0 0% 355 Data Processing Services 999 1.334 2,639 2,639 3,000 881 4,000 4,000 133% 397 Contracted Services 9,092 22,030 2,550 8,930 5,000 179! 61500 6,500 130% Account: 10,689 23,364 5,189 11,569 8,000 145% 10,500 0 10,500 131% 410600 Elections 350 Professional Services 1,779 3,217 3,500 O% 3,500 3,500 100% Account: 1,179 3,217 3,500 O% 3,500 0 3,500 loot 470330 Contribution to Economic Development 356 Consultant's Services 2,226 2,232 2,246 2,259 3,000 75% 31000 3,000 100% Account: 2,226 2,232 2,246 2,259 3,000 75% 3,000 0 3.000 100% 4704DO Planning 335 Memberships 6 Dues 469 469 469 469 500 94% 500 500 100% 350 Professional Services 3,137 0 ...% 48,100 48,100 .....% General Fund portion of DIP Account: 469 469 469 3.606 500 721% 48,600 0 48,600 9720% 480300 Air Quality Control 791 Air Pollution Control 2,316 2,316 579 2,500 0% 2,500 2,500 loot Account: 2.316 21316 579 21500 0% 2,500 0 2,500 100% 510000 Miscellaneous 195 Retirement Benefits 107 0 Ot 0 01 220 operating Supplies 31 0 0% 0 0% Account: 138 0 ...1 0 0 0 0% 510100 Special Assessments 540 Special Assessments 2,071 1,943 3,655 2,991 4,000 751 4,000 4,000 loot Account: 2,071 1,943 3,655 2,991 4,000 75% 4,000 0 41000 100% 510200 Judgements and Losses 811 Liability Deductibles 1,500 3,000 7,000 0% 71000 7,000 100% Account: 1,500 3,000 71000 0% 7,000 0 7,000 1001 521100 Other Financing Uses - Retirement 195 Retirement Benefits 107 0 0% 0 0% 200 Supplies ,500 Ot 5DO 50D 100% 220 Operating Supplies 31 0 O% 0 01 Account: 138 500 0% 500 0 500 1001 Fund: 19,826 31,824 18,355 20,425 29,000 70% 79,6DO 0 79,600 2745 Org.: 19,826 31,824 18,355 20,425 29,000 70% 79,600 0 79,600 2741 08/29/21 CITY OF LAUREL Page: 2 of 25 13:47:30 Expenditure Budget by Org Report -- Multiyear Actuals Report ID: B240A1 For the Year: 2021 - 2022 110 CITY COUNCIL Current % Prelim. Budget Final c Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-l8 ---------- 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 1000 GENERAL -------------------- ---------- ---------- ---- ---------- ----- ----- ---------- ------ 410100 Legislative Services 110 Salaries and Wages 30,188 30,514 45,336 46,036 46,500 990 46,500 46,500 1001 Increased by 2% per budget worksheet provided (BL) 138 Vision Insurance 7 0 01 0 Ot 139 Dental Insurance 37 0 0% 0 0% 142 Workers' Compensation 117 134 194 253 200 127% 270 270 135% 143 Health Insurance 804 0 0% 0 0% 144 Life Insurance 141 128 124 120 195 62% 192 192 98% 145 FICA 2,309 2,334 3,468 31521 3,600 98% 3,630 3,630 101% 220 Operating Supplies 408 278 344 2,548 500 510% 2,100 2,100 420% Increased by $1,600 per budget document provided (BLI 300 Purchased Services 400 O% 0 0% 312 Networking Fees 852 2,041 5,466 51672 5,500 103% 51500 5.500 100% 335 Memberships a Dues 4,063 4,163 2,652 2,645 2.500 106% 21500 2,500 100% 337 Advertising 26 100 0% 100 100 loot 356 Consultant's Services 250 0% 250 250 100% 362 Office Machinery s Equip. 11800 11000 0% 1,000 11000 100% 370 Travel 616 11412 28 2,530 0% 2,850 2,850 113% Increased by $320 per budget document provided (8L) 380 Training Services 1.032 625 75 495 1,230 40% 1,230 1,230 100% Account: 42,374 41,629 57,713 61,290 64,505 95% 66,122 0 66,122 1021 Fund: 42,374 41,629 57,713 61.290 64,505 95% 66,122 0 66,122 102% Orgn: 42.374 41,629 57,713 61,290 64,505 95% 66,122 0 66,122 102% 12 08/29/21 CITY OF LAUREL page: 3 of 25 13:47:30 Expenditure Budget by Org Report -- MultlYear Actuals Report ID: B24GAl For the Year: 2D21 - 2022 120 MAYOR Current k Prelim. Budget Final 9 Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object 17-18 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 -------------------------------- 1000 GENERAL -------------------- ---------- ---------- --------"- ---- ---------- ---------- ---------- ------ 410200 Executive 'Services 110 Salaries and Wages 10,387 11,015 27,203 27,846 27,646 1006 27,850 27,850 1008 138 Vision Insurance 34 82 84 86 90 964 86 86 964 139 Dental Insurance 187 448 448 418 448 93% 540 540 1219 142 Workers' Compensation 40 49 117 153 120 128E 160 160 1334 143 Health Insurance 4,018 9,372 9,874 10,415 10,415 100E 30,415 10,415 1009 144 Life Insurance 18 24 24 24 24 100E 24 24 1008 145 FICA 795 047 2,081 2,130 2,135 1001 2,135 2,135 100E 220 Operating Supplies 2,213 1,025 677 706 795 894 800 800 1018 Increased by $5 311 Postage 0 at 500 500 •••••4 312 Networking Fees 217 929 2,587 2,830 2,600 1091 2,800 2,800 108E Increased by $200 335 Memberships 4 Dues 212 750 OE 700 700 939 Decreased by $50 343 Cellular Telephone 1,340 1,432 1,308 600 1,500 409 11500 1,500 100E 356 Consultant's Services 1,500 150 3,300 2,500 1329 4,000 4,000 160E Increased by $1,500 370 Travel 684 1,741 28 0 08 50D 500 •'•••E Increased by $500 380 Training Services 380 432 195 250 500 504 500 500 1001 392 Administrative Services 11365 0 •••E 0 W Account: 22,025 27,606 44.626 $0,123 49,723 1019 52,510 0 52,510 105E Fund: 22,025 27,606 44,626 50,123 49,723 101E 52,510 0 52,510 1051 Orgn: 22,025 27,606 44,626 50.123 49,723 101E 52,510 0 52,510 1054 M 08/29/21 CITY OF LAUREL page: 4 of 25 13:47:30 Expenditure Budget by Org Report -- Multiyear Actuals Report. ID: B240A1 For the Year: 2021 - 2022 121 ADMIN ASST TO MAYOR Current 1 Prelim. Budget Final 1 Old ---------------- Actuals ----------------- Budget Exp, Budget Changes Budget Budget Account Object -------------------------------- 17-18 18-19 19-20 20-21 -------------------- 20-21 20-21 21-22 21-22 21-22 21-22 1000 GENERAL -------------------- ---------- ---- ---------- ---------- ---------- ------ 410200 Executive Services 110 Salaries and Wages 0 01 33,280 33,280 "••'9 111 Overtime 0 Ot 480 480 •••••1 141 Unemployment Insurance 0 01 120 120 ....1 142 Workers' Compensation 0 01 915 915 •••••1 143 Health Insurance 0 01 13,200 13,200 ... —% 144 Life Insurance 0 01 72 12 .....1 145 FICA 0 01 2,550 2,550 ^•^^•1 194 Flex Medical. 0 08 600 600 ...1 220 Operating Supplies 1,394 2,000 701 2,000 21000 1009 231 Gas, Oil, Diesel Fuel, Gr 0 01 100 100 •••"9 335 Memberships S Dues 0 01 200 200 •••••1 370 Travel 0 0% 200 200 1•••`9 380 Training Services 0 01 200 200 ••••^9 Account: 1,394 2,000 701 53,917 0 53,917 26951 Fund: 1,394 2,000 701 53,917 0 53,917 26951 Orgn: 1,394 2,000 7D1 $3,917 0 53,917 26951 08/29/21 CITY OF LAUREL Page: 5 of 25 13:47:30 Expenditure Budget by Org Report -^ MultiYear Actuals Report I0: 0240A1 For the Year: 2021 - 2022 122 CHIEF ADMINISTRATIVE OFFICER Current t Prelim. Budget Final 1 Old -^-------------- Aotoata ----------------- Dodger Exp. Budget Changes Budget Budget Account Object 17-18 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 ________________________________ 1000 GENERAL __________ __________ __________ ____________________ ____ __________ __________ __________ 410200 Executive Services 110 Salaries and Wages 17,742 28,431 0 0% 0 0E 138 Vision Insurance 13 0 at 0 0% 139 Dental Insurance 74 0 Be 0 OE 141 Unemployment Insurance 44 99 0 0E 0 Ot 142 Workers' Compensation 68 125 0 Ot 0 04 143 Health Insurance 11591 3.630 0 of 0 OB 144 Life Insurance 12 20 0 OB 0 0% 145 FICA 1,327 1,937 0 0% 0 OE 148 rCMA Retirement 364 0 08 0 Ot 194 Flex MedicaL 165 0 Ot 0 03 220 Operating Supplies 1,234 5,526 2,311 4 0 '•`t 0 Ot 231 Gas, 011, Diesel Fuel, Gr 561 0 at 0 at 311 Postage 383 0 OE a Ot 312 Networking Fees 348 2,011 2,587 395 0 "•t 0 at 335 Memberships 6 Dues 851 11116 0 at 0 OB 337 Advertising 3,935 0 Ot 0 Ot 343 Cellular Ielephone 1,496 2,469 1,365 94 0 •••t 0 Ot 356 Consultant's Services 500 50 13,253 2,468 0 ...t 0 at 370 Travel 1,829 1,600 11982 0 0E 0 OE 380 Training Services 155 1.848 0 08 0 at Account: 31,748 49,806 21,498 2,961 0 ...E 0 0 0 06 420100 Lav Enforcement Services 370 Travel 3 0 OE 0 at Account: 3 0 •••E 0 0 0 0% Fund: 31,751 49.806 21,498 2,961 0 '••E 0 0 0 06 Oren: 31,751 49,806 21,498 2,961 0 •••t 0 0 0 Ot -11- 08/29/21 CITY OF LAUREL 13:47:30 Expenditure Budget by Org Report -- Multi Year Actuals For the Year: 2021 - 2022 73,714 73,351 130 CITY COURT 79,564 80,000 99% 90,100 90,100 113% Current % Prelim, ---------------- Actuals ----------------- Budget Exp. Budget Account Object '-------------------------'---- 17-18 18-19 19-20 20-21 -------------------------- ---------- 20-21 ---------- 20-21 ---- 21-22 ------- 1000 GENERAL 410300 Judicial Services IIB Salaries and Wages 42,584 42,656 42,846 43,079 43,106 100% Increased wage per Resolution RIS -51 IBLI 138 Vision Insurance 8t 82 84 86 90 961 139 Dental Insurance 448 448 448 418 448 938 142 Workers' Compensation 164 187 184 237 180 1321 143 Health Insurance 9,642 9,372 9,922 10,463 10,415 100% 144 Life Insurance 72 72 72 72 72 1001 145 FICA 3,199 3,204 3,217 3,232 3,300 98% 200 Supplies 75 0 0% 210 Office Supplies 6 Materia 2,439 958 2,559 1,481 2,000 74% 220 Operating Supplies 1,585 3,298 11936 1,828 1,100 1668 Increased by $900 per Judge's request 252 Map and Code Books 425 1,000 439 300 Purchased Services 222 25 1,173 180 400 45% 311 Postage 1,477 454 1,529 1,318 1,600 821 312 Networking Fees 4,510 6,332 1,888 1,677 7,000 24% Decreased by $3,000 per Judge's request 321 Printing, Forms, etc. 471 739 829 650 128% Increased by $350 per Judge's request 322 Books/Catalogs, etc. 726 810 798 489 0 ••9 335 Memberships c Dues 320 270 350 350 400 88% 343 Cellular Telephone 220 0 ••�% Increased by 5200 per Judge's request 360 Repair 6 Maintenance Sery 27 750 0% 370 Travel 1,436 2,099 2,262 1,298 2,500 52t Increased by $2,600 for cost to attend New Orleans training per Judge's request 380 Training Services 969 500 580 11000 58% 394 Jury and Witness Fees 1,265 631 262 383 11000 38% - 397 Contracted Services 1.300 203 116 25 116 22% Reduced by $16 per Judge's request Account: 72,514 72,072 70,412 68,670 77,127 89% 43,360 90 540 250 10,415 72 3,320 2,000 2,000 1,000 400 1,600 4,000 1;000 400 200 750 5, 100 1,000 100 77,597 Page: 6 of 25 Report 10: B240A1 Budget Final % Old Changes Budget Budget 21-22 21-22 21-22 --------- ---------- ------ 43.360 101% 90 100% 540 121E 250 139% 10,415 1001 72 100% 3,320 1011 0 0% 2,000 100% 2,000 182% 1,000 100% 400 100% 1,600 1001 4,000 57% 1,000 154% 0 01 400 100% 200 •••••1 750 loot 5,100 204% 1,000 100% 0 0% 100 86% 0 77,597 100% 410360 City/Municipal Court 110 Salaries and Wages 73,714 73,351 78,613 79,564 80,000 99% 90,100 90,100 113% III Overtime 800 0% 800 800 1001 138 vision Insurance 21 84 86 90 96% 90 90 100% 139 Dental Insurance 529 509 448 418 448 93% 540 540 121% 141 Unemployment Insurance 184 257 118 199 200 100% 320 320 160% 142 Workers' Compensation 839 950 1,002 784 980 80% 2,490 2,490 250 143 Health Insurance 19,814 19,274 20,328 23,687 23,800 100% 23,615 23,615 99% 144 Life Insurance 144 144 144 144 144 100% 144 144 100% 145 FICA 4,928 4,984 5,433 5,605 6,110 92% 7,000 7,000 115% 194 Flex Medical 694 11075 1,075 1,050 0% 1,300 1,300 124% 335 Memberships 6 Dues 70 70 70 100 O% 100 100 100% 339 Certification Renewal 75 0 '••1 75 75 .....I Increased to $75 per the Judge's request -12- 00/29/21 CITY OF LAUREL 13:47:30 Expenditure Budget by Org Report -- MultlYeaa Aotu4Is For the Year: 2021 - 2022 130 CITY COURT Current % Prelim, ^--------------- Aetuelo----------------- Budget Exp. Budget Account Object 17-18. 18-19 19-20 20-21 20-21 20-21 21-22 ----------------------------- ---------- -- -------- -------------------- ^--------- ---- ---------- 370 Travel 1,671 882 981 11900 0% 7,100 Increased by $5,200 for travel to New Orleans for training per the Judge's request 380 Training Services 103 500 500 300 167% Account: 102,690 IO1,517 108,796 til,062 115,922 96% 133,674 Fund: 175,204 173.$89 179,208 179,732 193,049 93% 211,271 Orgn: 175,204 173,589 179,208 179,732 193,049 93% 211,271 13- Page: 7 of 25 Report I0: 0240AI Budget Final % Old Changes Budget Budget 21-22 21-22 21-22 --------- ---------- ------ ,100 374% _ 0 0% 0 133,674 115% 0 211,271 109% 0 211.271 109% 08/29/21 CITY OF LAUREL Page: 8 of 25 13:49:30 Expenditure Budget by Org Report -- MultlYear Actuals Report It: B240A1 For the Year: 2021 -2072 130 CITY CLERK Current h prelim. Budget Final % Old --------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object ------------ ------------------- 17-18 ---------- 18-19 19-20 20-21 20-21 2D-21 21-22 21-22 21-22 21-22 1000 GENERAL ---------- -------------------- ---------- ---- ---------- ---------- ---------- ------ 410500 Financial Services 110 Salaries and Wages 125,217 113,162 115,658 103.764 102,100 102% 107,500 107,500 1051 Increased wages by 3% per Mayor 111 Overtime 384 22 900 0% 900 900 100% 138 Vision Insurance 191 164 178 165 150 110% 355 355 237% 139 Dental Insurance 1,407 1.304 1,306 1.097 1,080 102% 2,380 2,380 220% 141 Unemployment Insurance 302 397 174 259 260 100% 380 380 146% 142 Workers' Compensation 1,228 1,294 1,294 929 1,260 74% 3,000 3,000 238E 143 Health Insurance 28,870 25,862 26,550 23,034 23.700 97% 13, 25D 13,250 56t 144 Life Insurance 216 199 194 166 165 IDI% 164 164 99% 145 FICA 91170 8,566 8.761 7,840 71880 99% 8,290 8,290 105% 194 Flex Medical 11670 1,380 1,567 1,365 0% 1,362 1,362 10D% 210 Office Supplies 6 Materia 3,367 41085 4,964 3,195 8,000 40% 8,000 8100D 100% 220 Operating Supplies 9,042 10,620 10,299 10,'160 10,000 108% 10,000 10.000 100% 311 Postage 4,864 4,161 3,956 4,128 8,000 521 81000 81000 100E 312 Networking Fees 2,131 3,532 6,002 5,016 6,200 81% 6.200 6,200 100% 322 Books/Catalogs, etc. 681 350 1,000 0% 1.000 11000 100% 335 Memberships 6 Dues 594 395 440 342 1,00D 34% 1,000 11000 100% 337 Advertising I15B2 332 207 373 800 47% 800 800 loot 343 Cellular Telephone 480 480 480 1,467 500 2931 500 500 loot 353 Accounting and Auditing 29,375 37,150 36,170 42,580 36,000 118E 40,000 40,000 Illi Increased by $4,000 355 Data Processing Services 1,310 197 11500 0% 11500 1,500 100% 356 Consultant's Services 735 1.200 1,500 0% 11500 11500 100% 362 Office Machinery 6 Equip. 1,663 2,099 750 145 2.500 6% 2,500 2,500 100E 370 Travel 736 21218 25 274 0 •••1 3,000 3,000 .....% 380 Training Services 21188 792 345 842 2,000 42% 3,000 3,000 150% 393 Recording Documents 20 14 200 Ot 200 200 100% 397 Contracted Services 29,707 29,528 29,981 30,013 30,000 100E 32,000 32,000 107E 530 Rent 669 735 861 946 1,000 95% 1.500 1,500 150% Increased by 6500 due to increased records storage at Baker 946 Computer Eq/Software 0 0% 28,000 28,000 .....% Upgrade to Laserfiche Account: 257,779 250,494 250,526 237,335 249,060 95% 286,281 0 286,281 114% Fund: 257,779 250,494 250,526 237,335 249.060 95% 286,281 0 286,281 1141 „Orgn: 257,779 250,494 250,526 237,335 249,060 95% 286,281 0 286,281 114% -14- 08/29/21 CITY OF LAUREL 13:41:30 Expenditure Budget by Org Report -- Multiyear Actuals For the Year: 2021 - 2022 170 CIIY ATTORNEY -15- Page: 9 of 25 Report 10: B240A1 Budget Final % Old Changes Budget Budget 21-22 21-22 21-22 36,000 103% 295 100% 1,650 .....% 205 236% 205 1411 9,100 98% 72 100% 2,800 105% 0 It 0 O% 1,500 100% 3,200 100% 0 0% 4,000 100% 600 100% 1,000 100% 500 100% 69,200 I00% 0 128,327 102% 0 128.327 102% 0 128,327 102% Current % Prelim. ---------------- Actuals ----------------.. Budget Exp. Budget Account Object -------------------------------- 17-18 ---------- 18-19 19-20 20-21 20-21 20-21 21-22 1000 GENERAL ---------- ---------- ---------- ---------- ---- ---------- 411100 Legal Services 110 Salaries and Wages 33,875 34,387 34,293 34,991 34,785 100% 36,000 Increased wage by 3% per the Mayor 138 Vision Insurance 279 280 288 293 295 99% 295 139 Centel Insurance 1,371 1,371 1,371 11280 0 •"% 1,650 141 Unemployment Insurance 82 115 51 B7 87 100% 205 142 Workers' Compensation 127 145 146 191 145 132% 205 143 Health Insurance 7,534 61988 8,514 9,325 9,300 100% 9,100 144 Life Insurance 72 72 72 72 72 100% 72 145 FICA 2,500 2,523 2,602 2,662 2,665 1001 2,800 194 Flex Medical, 250 0 0% 210 Office Supplies b Materia 1,750 0 O% 220 Operating Supplies 11015 847 1,589 147 1,500 10% 1,500 312 Networking Fees 611 2,940 2,830 3,200 BB% 3,200 337 Advertising 229 0 O% 338 Code Review and Audit 1,980 1,237 1,229 11516 4,000 38% 4,000 343 Cellular Telephone 459 600 77% 600 370 Travel 2,238 222 1,000 0% 1,000 380 Training Services 250 195 500 0% 500 397 Contracted Services 55,000 56,626 64,049 67,200 67,200 100% 67,200 Account: 106,323 105,674 119,318 120,853 125.349 96% 128,327 Fund: 106,323 105,674 119,318 120,853 125.349 96% 128,327 Orgn: 106,323 105,674 119,318 120,853 125,349 96% 128,327 -15- Page: 9 of 25 Report 10: B240A1 Budget Final % Old Changes Budget Budget 21-22 21-22 21-22 36,000 103% 295 100% 1,650 .....% 205 236% 205 1411 9,100 98% 72 100% 2,800 105% 0 It 0 O% 1,500 100% 3,200 100% 0 0% 4,000 100% 600 100% 1,000 100% 500 100% 69,200 I00% 0 128,327 102% 0 128.327 102% 0 128,327 102% 08/29/21 13:47:30 180 CITY HALL CITY OF LAUREL page: 10 of 25 Expenditure Budget by Org Report -- MultiYear Actuals Report ID: B240A1 For the Year: 2021 - 2022 -16- Current % Prelim. Budget Final % Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-18 ---------- 18-19 19-20 20-21 20-21 2.0-21 21-22 21-22 21-22 21-22 -000 GENERAL --------- - ---------- ---------- ---------- ---- ---------- ---------" ---------- ------ 411200 Facilities Administration 110 Salaries. and Wages 51119 5,266 5,505 3,040 5,500 55% 5,600 5,600 102% 138 Viston Insurance 26 26 26 218 27 807% 27 27 1001 1.39 Dental insurance 140 140 140 24 145 17% 110 170 117% 141 Unemployment Insurance 13 19 29 8 15 53% 20 20 133% 142 Workers$ Compensation 265 311 319 126 305 41% 70 70 23% 143 Health Insurance 3,022 2,803 3,239 2,134 3,150 68% 3,150 3,150 100% 144 Life Insurance 13 7 7 3 8 381 8 B 100% 145 FICA 392 403 421 233 420 55% 425 425 101% 146 PERS -77 0 0% 0 Ot 194 Flex Medical, 78 57 91 95 0% 95 95 100% 200 Supplies 270 0 O% 0 at 220 Operating Supplies 13,430 10,628 81170 15,858 10,000 159% 15,000 15,000 150% leer eaaxd by $5,000 332 Internet Access Fees 100 0 0% 0 0% 337 Advertising 163 0 0% 0 Ot 341 Electric Utility Services 7,817 71588 7,349 7,330 10,000 73% 10,000 10,000 100% 344 Gas Utility Service 2,731 2,938 2,672 2,538 3,500 73% 31500 3,500 100% 345 Telephone 13,380 14,489 13,612 6,697 17,000 39% 10,000 10,000 59% Reduced by 67,000 350 Professional Services 216 10,357 20.048 11,610 11000 •••% 5,000 51000 5001 Increased by $4,000 361 Motor Vehicle Repair 6 Ma 0 0% 100 100 `.•••1 Added for the Ford Escape oil changes 366 Building Maintenance 2,720 85,542 5,674 3,047 10,000 30t 10,000 10,000 100% 397 Contracted Services 3,256 8,647 7,360 8.582 7,000 1231 10,000 10,000 143% Increased by $3,000 for Municode Meetings and annual WebHosting fees 398 Janitorial Service 9,300 18,000 52% 0 Ot 921 Administrative Buildings 51198 0 Ot 0 Ot 943 Vehicle(s) 25,194 0 ^•% 0 Ot Account: 52,988 149,307 79,860 95,942 86,165 lilt 73,165 0 73,165 84% Fund: 52,988 149,307 79,860 95,942 86,165 lilt 73,165 0 73,165 84% Orge: 52,988 149,307 79,860 95,942 86,165 lilt 73,165 0 73,165 84% -16- 08/29/21 CITY OF LAUREL Page: 11 of 25 13:41:30 Expenditure Budget by Org Report •- Multi Year. Actuals Report to: B24DA1 For the Year: 2021 - 2022 200 POLICE DEPARTMENT Current % Prelim. Budget Final % Old ---- --- --------- ACLuals ----------------- Budget Exp, Budget Changes Budget Budget Account Object ------------------------------------------ 17-18 18-19 19-20 20-21 20-21 2.0-21 21-22 21-22 21-22 21-22 LOUD GENERAL ---------- -------------------- -----.----- ---- ---------- ---------- "--------- ----- 420100 Lav Enforcement Services IIB Salaries and Wages 139,915 760,582 745,209 816,997 808,000 101% 835,000 835,000 103% III Overtime 45,650 34,621 58,330 58,700 67,500 87% 67,500 67,500 100% 138 Vision Insurance 113 757 849 950 950 100% 11030 11030 108% 139 Dental Insurance 3,954 4,140 4,5)3 4,640 4,950 94% 6,450 6,450 I30t 141 Unemployment Insurance 2,396 3,036 1,317 2,249 2,200 102% 3,150 3,150 143% 142 Workers' Compensation 34,774 40,148 39,711 36,097 42,400 85% 26,650 26,650 63% 143 Health Insurance 132,212 123,793 134,800 152,222 152,500 300% 150,ODD 150,000 98% 144 Life Insurance 924 888 942 11008 1,008 100% 11008 11008 loot 145 FICA 13,230 8,771 11,223 12,257 12,700 97% 13,050 13,050 103% 147 MPORS 99,746 103,193 100,540 ILO1620 116,550 951 120,000 120,000 103% 194 Flex MedicaL 929 420 600 1,200 0% 1,200 1,200 100% 210 Office Supplies 6 materia 11119 4,150 2,039 11601 1,800 89% 1,800 1,800 100% 220 Operating Supplies 8,446 23,689 19,065 14,069 12,000 117% 16,000 16,000 133% Increased by $4,000 per Chief due to weapons qualifications/ammo 231 Gas, Oil, Diesel Fuel, or 14,946 16,029 18,033 21,192 20,000 106% 20,000 20,000 100% 239 Tires/Tubes/Chains 1,326 1,962 1,275 11869 2,500 75% 2,500 2,500 100% 311 Postage 400 547 546 944 400 236% 1,300 1,300 325% Increased by $900 per Chief 312 Networking Fees 2,590 4,369 11,124 12,464 9,100 137% 11,000 11,000 121% Increased by $1,900 due to upgraded system 316 Radio Services 274 1,500 0% 0 D% 335 Memberships c Dues 947 11126 11091 11071 1,000 107% 11000 1,000 100% 337 Advertising 181 174 2,239 150 0% 3,000 3,000 2000% Increased by $2,850 per Chief 343 Cellular Telephone 3,089 5,572 4,279 4,577 4,200 109% 4,200 4,200 100% 347 ]owing 150 310 200 250 80% 250 250 100% 350 Professional Services 1,050 2,550 11500 3,000 Ot 3,000 3,000 100% 351 Medical, Dental, Veterina 972 3,393 752 1,183 1,000 118% 11000 1,000 100% 355 Data Processing Services 4,890 7, 05D 66 41600 0% 4,600 4,600 100% 361 Motor Vehicle Repair 6 Me 6.378 8,538 8,998 16,979 10,000 170% 10,000 10,000 loot 362 Office Machinery 6 Equip. 4,178 3,280 45 701 600 117% 600 600 loot 370 Travel 2,927 3,420 2,225 5,389 3,000 180% 3,000 3,000 100% 380 Training Services 3,045 11,246 19,605 10,000 196% 20,290 20,290 203% Increased by $10,290 in order to pay the Police Reserves $75 monthly 397 Contracted Services 4,800 9,767 13,411 17,667 12,000 147% 17,000 17,000 142% Increased by $5,000 per the Chief 940 Machinery 6 Equipment 29,099 0 0% 0 0% 943 Vehicles) 40.919 33,715 0 •••% 58,376 58,376 .....I For the payment of new police vehicle approved in previous fiscal year. Account: 1,174,025 1,179,320 1,225.067 1,348,966 1,307,058 ID3% 1,403,954 0 1,403,954 107% 420131 Reserve and Auxiliary 380 Training Services 8,783 6,263 0 0% 0 0% Are ount: 8,783 6,261 0 •••t 0 0 0 0% -17- 08/29/21 CITY Of LAUREL Pago: 12 or 25 13:41:30 Expenditure Budget by 019 Report -- Multiyear Actuals Report ID: B240A1 For the Year: 2021 - 2022 200 POLICE DEPARTMENT Account Object 420150 Communications 110 Salaries and Wages III overtime 138 Vision Insurance 139 Dental Insurance 141 Unemployment Insurance 142 Workers' Compensation 143 Health Insurance 144 Life Insurance 145 FICA Current % Prelim. -------------- Actuals ----------------- Budget Ex, Budget 11-18 18-19 19-20 20-21 20-21 20-21 21-22 ------- ---------- ---------- ---------- ---------- ---- ---------- 251,510 241,356 299,200 301,616 299,800 101% 310,000 9,311 22,317 17,142 12,307 10,000 123% 10,000 38D 341 400 429 430 100% 450 2,018 1,794 21055 2,023 2.,200 92% 2,625 646 937 474 785 775 1011 1,120 11,559 13,399 15,677 13,017 15,000 87% 91500 59,647 52,835 61,860 66,817 69,000 97% 66,700 408 372 414 410 432 95% 450 17,897 18,828 22,307 21,955 23,700 93% 24,500 Account: 353,384 358,179 419,529 419,359 421,337 100% 425,345 440600 Animal Control Services 110 Salaries and Wages 111 overtime 138 Vision Insurance 139 Dental Insurance 141 Unemployment Insurance 142 Workers' Compensation 143 Health Insurance 144 Life Insurance 145 FICA 194 Flex Medical. 220 Operating Supplies 267 23 226 Clothing and Uniforms 231 Gas, Oil, Diesel Fuel, Ge 239 Tires/Tubes/Chains 316 Radio Services New radio for the Animal Control/Code Enforcement vehicle 366 Building Maintenance 228 116 232 116 Account: 495 139 232 116 0 0% 0 0% 0 0% 0 0% 0 0% 0 o% 0 0% 0 Ot 0 O% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 ...1 0 ...% 40,310 1,000 86 540 150 1,200 10,450 72 3, 100 600 1,200 1,200 3,000 500 2,000 65,408 490000 Debt Service 610 Principal 14,442 12,853 13,624 0 0% 620 Interest 1,589 818 0 0% Account: 14,442 14,442 14,442 0 •'•% 0 Fund: 1,551,129 1,558,343 1,659,270 1,768,441 1,728,395 102& 1,894,707 Orgn: 1,551,129 1,558,343 1,659,270 1,768,441 1,728,395 102% 1,894,707 M Budget Final % Old Changes Budget Budget 21-22 21-22 21-22 --------- ---------- ------ 310,000 103% 10,000 IOD% 450 105% 2,625 119% 1,120 145% 9,500 63% 66,700 97% 450 104% 24,500 1031 0 425,345 IOD% 40,310 .....% 11000 .... 1% 86 •••••1 540 •••••1 150 •••••& 1,200 .....% 10,450 .... It 72 .... 11 3,100 ••^•t 600 '••••k 1,200 •••••% 1,200 ... 11% 3,000 •••••t 500 •••'•& 2,000 •••••a 0 0% 0 65,408 .....% 0 O1 0 0% 0 0 O% 0 1,894,707 109% 0 1,894, 707 109% 00/29/21 13:47:30 230 FAP Account Object L000 GENERAL 420120 Facilities 110 Salaries and Wages 138 Vision Insurance 139 Dental Insurance 141 Unemployment Insurance 142 workers' compensation 143 Health Insurance 144 Life Insurance 145 FICA 146 PERS 194 Flex MedicaL 220 Operating Supplies 336 Public Relations 341 Electric Utility Services 344 Gas Utility Service 345 Telephone 366 Building Maintenance 397 Contracted Services Account: CITY OF LAUREL Paget L3 of 25 Expenditure Budget by Org Report -- Multi Year Actuals Report ID: B240A1 For the Year: 2021 - 2022 Current % Prelim. Budget Final % Old -------------- Actuals ----------------- Budget Exp, Budget Change. Budget Budget 17-18 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 -------- ---------- ---------- ---------- ---------- ----------------------------------- ------ 8,628 8,876 91278 5,125 9,225 56% 9,400 43 43 45 19 50 381 50 236 236 236 102 240 43% 300 22 31 14 13 25 521 33 447 524 539 212 515 41% 120 5,093 4,724 4,996 2,196 5,300 41% 51300 22 13 13 5 13 38% 13 660 679 710 392 710 55% 720 59 0 0% 132 97 153 160 0% 160 2,571 2,201 4,261 2,793 3,000 93% 3,000 280 0 O% 24,912 21,835 23,376 23,439 2B4O00 84% 28,000 10,199 9,366 8,871 8,229 12,000 69% 12,000 81188 8,253 8,429 6,894 11,000 63% 11,000 8,548 6,272 16,038 29,169 20,000 146% 20,000 2,400 2,400 1,670 942 2,400 39% 2,400 72,381 65,609 78,629 79,530 92,638 86% 92,496 Fund: 72,381 65,609 78,629 79,530 92,638 86% 92,496 Orgn: 72,381 65,609 78,629 79,530 92,638 86% 92,496 -19- 9,400 102% 50 1006 300 125% 33 132% 120 23% 5,300 100% 13 100% 720 tole 0 01 160 100% 3,000 100% 0 o% 28,000 100% 12,000 300% 11,000 100% 20,000 100% 2,400 1001 0 92,496 99% 0 92,496 99% 0 92,496 99% 08/29/21 CITY OF LAUREL Page: 14 of 25 13:47:30 Expenditure Budget by Org Report -- MultiYear Actuals RePOiL ID: B240AL For the Yoar: 2021 - 2D22 240 FIRE DEPARTMENT Current % Prelim. Budget Final \ Old ---------------- Actuals --------------- Budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-18 -------------------- 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 1000 GENERAL ---------- ---------- ---------- ---- ---------- ---------- ---------- ------ 420400 Fire Protection b Control 110 Salaries and Wages 96,123 94,344 93,172 97,492 116,200 84% 122,200 122,200 3054 Increased by $6,000 per the Fire Chief 141. Unemployment Insurance 240 331 140 244 300 81% 430 430 143% 142 Workers' Compensation 3,328 3,745 6,168 6,105 4,550 134% 4,800 4,800 105% 144 Life Insurance 922 892 820 792 1,100 72% 1,100 11100 100t 145 FICA 7,428 7,225 7,126 7,458 8,900 84% 9,400 91400 106% 190 Other Personal Services 51040 4,590 4,590 4,590 5,000 921 400 400 8% 210 Office Supplies a Materia 1,617 1,557 1,002 514 11000 51% 1,000 11000 1001 217 Fire Investigation 120 1,286 1,000 2,976 4,000 741 4,000 4,000 100% 220 Operating Supplies 16,671 11,207 26,176 32,354 34,000 95% 34,000 34,000 100% 223 Meals/Food 3,230 3,121 3,744 4,239 5,800 73% 6,880 61880 119% Increase meal pay from $5.00/ firefighLer/ month to $7.00/ firefighter/ month. Based on 45 firefighters per Fire Chief 226 Clothing and Uniforms 30,104 21,514 32,835 24,820 33,000 75% 33,000 33,000 100% 231 Gas, Oil, Diesel Fuel, Gr 8,260 8,827 7,276 11,851 9,500 125% 10,000 10,000 105% Increased by 8500 232 Motor Vehicle Parts 6,503 8,522 6,181 6,539 9,500 69% 91500 91500 100% 233 Machinery a Equipment Par 2,816 5,341 7,002 10,869 9,500 114% 10,000 10,000 105` Increased by 6500 239 Tires/Tubes/Cbains 3,927 4,879 71159 5,000 143% 5,000 51000 100% 241 Consumable Tools 882 228 722 788 500 158% 700 700 140% Increased by $200 261 Photo Supplies 458 662 665 1,300 51% 1,300 1,300 100% 300 Purchased Services 515 1,783 21000 89% 2,500 2,500 125% Increased by 8500 311 Postage 19 3 2 0 •••i 0 01 312 Networking Fees 3,126 3,547 8,709 61708 4,000 168% 4,000 4,000 100% 316 Radio Services 10,094 6,308 1,223 51860 6,500 901 6,500 6,500 3006 335 Memberships a Dues 330 1,313 155 964 I, ODD 96% 1,000 1,000 100% 336 Public Relations 2,480 2,356 1,961 546 3,200 17% 3,200 3,200 30D% 337 Advertising 116 78 D ...1 0 0% 343 Cellular Telephone 6,655 5,170 4,783 907 5,500 16% 5,500 5,500 100% 350 Professional Services 1,832 1,420 1,174 275 1,500 18% 1,500 1,500 100% 351 Medical, Dental, Veterina 379 329 1,516 1,000 152% 11000 11000 100% 355 Data Processing Services 50 412 400 312 500 62% 500 500 100% 360 Repair 6 Maintenance Sery 220 2,212 0 •••\ 0 0% 361 Motor Vehicle Repair a Me 5,578 51958 14,074 7,332 6,500 113% 6,500 6,500 100% 369 Other Repair a Maine Sets, 8,896 8,447 10,682 6,727 10,000 67% 101000 10,000 100% 370 Travel 2,931 . 492 377 0 O% 0 01 371 Safety Program 4,483 2,017 11,541 81731 7,000 125% 7,000 7,000 100% 380 Training Services 3,396 1,240 913 4,195 6,000 70% 6,000 6,000 100% 397 Contracted Services 401 536 696 520 500 104% 500 500 IOD\ 732 Purchases from Donations/ 3,474 0 0% 0 O% 943 Vehicle(s) 81900 0 0% 79,950 79,950 `••"8 Command Vehicle $79,950 Account: 234,270 216,846 272,889 268,143 304,350 88% 389,360 0 389,360 1271 -20- 08/29/21 CITY OF LAUREL Page: 15 of 25 13:47:30 Expenditure Budget by Org Report -- Multiyear ACteala Report ID: 8240A1 For the Year: 2021 - 2022 240 FIRE DEPARTMENT Current 1 Prelim. Budget Final 1 Old -----------^---- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object 17-18 18-19 19-20 20-21 20-21 20-21 21-22 2.1-22 21-22 21-22 -------------------------------- ------------- ---------------------------------------- ----------------"----------------- ------ 490000 Debt Service 610 Principal 44,733 45,437 22,994 23,282 23,290 100% 48,575 48,575 2094 $23,574.58 Principal payment for SCOA Gear $25,000.00 Principal payment for New Brush Truck (approx) 620 Interest 2,501 3,643 2,558 883 1,325 671 15,486 15,406 11699 $486.35 Interest payment for SCM Gear $15,000.00 Interest payment for New Brush Truck (approx) Account: 47,234 49,080 25,552 24,165 24,615 981 64,061 0 64,061 2601 521000 Interfund Operating Transfers Out 820 Transfers to Other Funds 1,848 1,848 15,446 18,198 04 0 01 Account: 1,848 1,848 15,446 18,198 01 0 0 0 01 Fund: 283,352 267,774 313,887 292,308 347,163 848 453,421 0 453,421 1309 Orgn: 283,352 267,774 313,887 292,308 347,163 649 453,421 0 453,421 1301 21- 08/29/21 CITY OF LAUREL Page: 16 of 25 13:49:30 Expenditure Budget by 019 Report -- MultlYear Actuals Report ID: 9240A1 For the Year: 2021 - 2022 250 FIRE INSPECTIONS Current t Prelim. Budgat Final % Old ---------------- Actuals ----------------- Budget Exp, budget Changes budget Budget Account Object -------------------------------- 17-18 ---------- IE -19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22. 1000 GENERAL -------------------- ---------- ---------- ---- ---------- ---------- ---------- ------ 420500 Protective Inspections 110 Salaries and Wages 12,400 11,759 11,586 8,929 5,000 179% 15,650 15,650 313% Ill Overtime 60 19 7 11 500 2% 500 500 100% 138 Vision insurance 24 23 20 14 10 140% 26 26 260% 139 Dental Insurance 133 125 IID 71 50 142% 165 165 3301 141 Unemployment Insurance 31 41 17 22 15 147% 6D 60 400% 142 Workers' Compensation 48 52 50 49 25 196% 100 100 400% 143 Health Insurance 2,861 2,619 2,416 1,771 11050 169% 3,150 3,150 3001 144 Life Insurance 21 20 18 12 30 120% 25 25 250% 145 FICA 953 901 887 684 425 161% 1,240 1,240 292% 194 Flex Medical, 125 60 0% 180 180 300% 210 Office Supplies 6 Materia 457 91 110 29 700 4% 70D 700 100% 220 Operating Supplies 140 501 150 500 30% 500 500 100% 231 Gas, Oil, Diesel Fuel, or 92 27 70D O% 700 700 100% 300 Purchased Services 350 O% 350 350 100% 343 Cellular Telephone 728 375 278 276 350 79% 350 350 loot 370 Travel 180 400 0% 400 400 100% 380 Training Services 1,595 850 O% 850 850 100% 397 Contracted Services 100 O% 100 100 loot Account: 19,583 16,317 16,000 12,018 11.095 108% 25,046 0 25,046 225% Fund: 19,583 16,317 16.000 12,018 11,095 lost 25,046 0 25,046 225% Orgn: 19,583 16,317 16,000 12,018 11,095 108% 25,046 0 25,046 2251 22- 08/29/21 13:47:30 253 BU16DING DEPARTMENT Account Object LOIN) GENERAL 420500 Protective Inspections 110 Salaries and Wages 111 Overtime 138 Vision Insurance 139 Dental Insurance 141 Unemployment Insurance 142 Workers' Compensation 143 Health Insurance 144 Life Insurance 145 FICA 194 Flex MedicaL 220 Operating Supplies 231 Gas, Oil, Diesel Fuel, Or 240 Other Repair 6 Maintenanc 300 Purchased Services 312 Networking Fees 335 Memberships 6 Dues 337 Advertising 343 Cellular Telephone 370 Travel 380 Training Services 397 Contracted Services 946 Computer Eq/Software Municity Software Account: Fund: CITY OF LAUREL page: 17 of 25 Expenditure Budget by Org Report -- Multiyear AOLuals Report 10: 8240A1 For the Year: 2021 - 2022 Current % Prollm. Budget Final 6 Old -------------- Actuals ----------------- Budget Exp, Budget Changes Budget Budget 17-18 18-19 L9-20 20-21 -------- -------- ---------------------- 20-21 ..---..._---- 20-21 ---- 21-22 ---------- 21-22 21-22 21-22 ---------- ---------- ------- 33,605 33,640 31,857 13,373 51000 2675 36,490 60 L9 9 600 2% 600 65 64 58 17 10 1701 60 357 349 311 86 50 172% 380 84 118 48 33 15 220% 130 130 148 136 67 25 268% 210 7,682 7,091 6,649 1,268 1,050 1211. 7,300 57 56 50 15 10 150% 55 2,575 2,575 2,437 1,024 450 228% 2,840 125 60 0% 420 11280 232 L,062 2,257 1,200 188% 1,200 65 39 47 1,000 5% 1,000 303 70 1,300 0% 1,300 750 0% 750 217 831 2,587 2,830 2,600 109% 3,000 893 393 844 524 500 105% 1,000 26 78 0 ••`% 100 1,910 1,310 1,438 645 1,500 43% 1,500 1,033 359 11000 0% 1,500 1,373 65 90 64 I'l00 66 1,300, 262 0 0% 0 0% 26,000 51,886 47,440 47,702 22,337 18,220 123% 86,935 51,886 47,440 47,702 22,337 18,220 123% 86,935 Orgn: 51,886 47,440 47,702 22,337 18,220 123% 86,935 36,490 7301 600 100% 60 600% 380 7601 130 8678 210 840% 7,300 695% 55 5504 2,840 63I% 420 700% 1,200 100% 1,000 100% 1,300 100% 750 100% 3,000 115% 1,000 200% 100 ....% 1,500 100% 1,500 L501 L,100 lout 0 Ot 26,000 ...% 0 86,935 477% 0 86,935 477% 0 86,935 477% 08/29/21 13:47:30 255 CODE ENFORCEMENT/SAFETY Account Object 1000 GENERAL 420130 City Safety Administration 110 Salaries and Wages III Overtime 138 Vision Insurance 139 Dental Insurance 141 Unemployment Insurance 142 Workers' Compensation 143 Health Insurance 144 Life Insurance 145 FICA 194 Flex MedicaL 220 Operating Supplies 370 Travel 380 Training Services Account: 420500 Protective Inspections 110 Salaries and Wages ill Overtime 138 Vision Insurance 139 Dental Insurance 141 Unemployment Insurance 142 Workers' Compensation 143 Health Insurance 144 Life Insurance 145 FICA 194 Flex Medical, 220 Operating Supplies 231 Gas, Oil, Diesel Fuel, Or 300 Purchased Services 312 Networking Fees 343 Cellular Telephone 380 Training Services Account: CITY OP LAUREL Page; 18 of 25 Expenditure Budget by Org Report -- MultiYeer ACLuaI5 Report ID: B240AL For the Year: 2021 - 2022 Fund: 36,755 32,842 52,922 62,975 61,900 102% 0 0 0 0% Orgn: 36,755 32,842 52,922 62,975 . 61,900 1021 0 0 0 0% -24- Current % prelim. Budget Final % Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget 17-18 ---------- 18-19 ---------- ---------- 19-20 20-21 ---------- 20-21 ---------- 20-21 ---- 21-22 ---------- 21-22 ---------- 21-22 ------ ---- 21-22 ------ 11,222 11,138 25,626 37,118 5,000 742% 0 0% 60 19 58 76 300 251 0 D% 22 15 47 64 10 640% 0 01 121 117 249 309 50 618% 0 0% 28 39 39 93 20 465% 0 0% 43 49 110 204 25 8161 0 01 2,604 2,462 5,494 7,690 1,050 732% 0 0% 19 25 40 54 10 540% 0 0% 863 854 1,965 2,845 405 702% D 0% 125 60 0% 0 0% 1,874 529 2,042 629 2,000 31% 0 0% 1,379 405 800 O% 0 0% 940 100 800 0% D 0% 19,175 15,777 35,770 49,082 10,530 466% 0 0 0 0% 11,513 11,284 9,967 7,238 34,700 21% 0 0% 60 19 7 10 300 3% 0 0% 22 22 18 12 60 20% 0 0% 124 119 96 58 320 18% 0 0% 29 39 15 18 20 90t 0 of 45 50 43 40 145 28% 0 0% 2,667 2,499 2,119 1,458 7,300 20% 0 0% 20 19 15 IO 55 16% 0 0% 885 864 763 555 2,700 21% 0 0% 125 420 O% 0 0% 837 612 648 767 700 110% 0 0% 112 120 39 42 600 7% 0 0% 30 250 0% 0 0% 348 918 2,934 3,409 3,000 114% 0 0% 860 375 458 276 500 551 0 0% 58 300 01 0 0% 17,580 17,065 17,152 13,893 51,370 27% 0 0 0 0% Fund: 36,755 32,842 52,922 62,975 61,900 102% 0 0 0 0% Orgn: 36,755 32,842 52,922 62,975 . 61,900 1021 0 0 0 0% -24- 08/29/21 CITY OF LAUREL 420730 Emergency Medical Services 13;47:30 Expenditure Budget by Org Report -- Multiyear Actuals 106,907 81,339 For the Year: 2021 - 2022 270 AMBULANCE 138 Vision Insurance 197 139 Dental Insurance Current 1 Prelim. 418 ---------------- Actuals ----------------- Budget Exp. Budget Account 'Object '---'------------------------- 17-18 18-19 19-20 20-21 ---------- ---------- ---------- ---------- 20-21 --------- 20-21 ---- 21-22 ------- 1000 GENERAL 420730 Emergency Medical Services (Ambulance) 110 Salaries and Wages 106,907 81,339 151,767 Ill Overtime 25,337 138 Vision Insurance 197 139 Dental Insurance 1,007 141 Unemployment Insurance 418 441 361 142 Workers' Compensation 3,734 3,226 11,166 143 Health Insurance 23,990 144 Life Insurance 474 402 564 145 FICA 81105 6,215 13,552 194 Flex MedicaL 731 210 Office Supplies 6 Materia 588 376 682 220 Operating Supplies 4,441 7,398 23,888 222 Laboratory 6 Medical Supp 25,493 16,243 35,572 Increased by $5,000 per Ambulance Director's request 226 Clothing and Uniforms 2,781 2,602 4,314 229 Other Operating Supplies 12,225 233 Gas, Oil, Diesel Fuel, Or 5,248 51885 6,817 232 Motor Vehicle Parts 1,073 4,169 3,657 239 Tires/Tubes/Chains 12 1,425 Increased by $500 per Ambulance Director's Request 311 Postage 8 312 Networking Fees 3,503 2,397 4,878 316 Radio Services 119 2,939 335 Memberships 0 Dues 336 Public Relations 1,228 683 381 Increased by $500 per Ambulance Director's request 343 Cellular Telephone 31016 3,471 3,971 350 Professional Services 1,250 2,567 S,D03 Medical Director's fee 351 Medical, Dental, Veterina 91 ISE 360 Repair 6 Maintenance Sery 527 201 3,024 361 Motor Vehicle Repair 6 Me 746 1,374 1,514 369 Other Repair 6 Maint Sery 723 115 10,460 370 Travel 1,935 292 380 Training Services 4,597 3,697 3,471 397 Contracted Services 24,674 20,356 32,054 732 Purchases from Donations/ 3,070 2,795 940 Machinery a Equipment 7,000 943 Vehicle(s) Match for new ambulance 946 Computer Eq/Software 17,789 948 Medical Equipment 85,060 4,978 Account: 204,622 258,837 407,738 -25- 258,2.63 14.623 464 2,283 684 17,002 56,413 680 20,876 269 4,345 38,296 9.004 7,097 679 1,737 56 4,550 176 1,513 4,550 5,000 111 7,872 80 7,757 46,376 3,706 539 190,243 705,234 315,000 82.1 15,000 97% 450 103% 2,250 101% 825 83% 21,200 60% 65,300 86% 435 156% 25,000 84% 3,600 0% 800 34% 5,000 871 25,000 153% 330,700 15,000 515 3,225 1,210 20,300 65,300 435 26,444 3,600 800 5,000 30,000 3,000 300% 3,000 0 02 71000 101% 7,000 5,000 14% 5,000 1,000 192% 1,500 2.5 264% 25 5,000 916 51000 1,000 0% 1,000 3,000 6% 3,000 1,500 101% 2,000 4,500 101% 4,500 3,000 167% 5,000 800 0% 800, 3,000 4% 3,000 8,000 98% 8,000 1,000 8% 1,000 0 0% 3,000 5,000 155% 5,000 30,000 355% 40,000 - 0 0% o `% 0 w , 17,500 - 0 -% 0 ...% _ 561,685 126% 617,854 Page: 19 Of 25 Report 10: B240A1 Budget Final % Old Changes Budget budget 21-22 21-22 21-22 ------------------- ------ 330,700 1051 15,000 100% 515 114% 3,225 1430 1,210 147% 20,300 961 65,300 100% 435 100% 26,444 106% 3,600 100% 800 100% 5,000 100% 30,000 120% 3,000 100% 0 01 7,000 100% 5,000 100% 1,500 150% 25 100% 5,000 100% 1,000 100% 3,000 100% 2,000 133% 4,500 100% 5,000 1671 800 100% 3,000 100% 8,000 100% 1,000 100% 3,000 •••••% 5,000 100% 40,000 133% 0 o% 0 0% 17,500 !`•^% D 0% 0 0% 0 617,854 110% 08/29/21 CITY OF LAUREL Page; 20 of 25 13:44:30 Expenditure Budget by Org Report -- MultiYear Actuals Report IN 8240Al For the Year: 2021 - 2022 270 AMBULANCE Currant \ Prelim. Budget Flnal \ Old ---------------- Actuals ----------------- Butlget Exp. Budget Changes Budget Budget Account Object ________________________________ 11-18 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 430730 Source of Supply __________ __________ __________ ----- _____--___ ____ ---------- _.. ----- ---------- ------ 312 Necworkinq Fee$ 262 0 0\ 0 01 Account: 262 0 '••\ 0 0 0 0\ 490000 Debt Service 610 Principal 22,691 22,691 1001 11,345 11,345 50\ Final FAP loan payment 620 Interest 3,616 2,765 11915 11064 1,064 1001 213 213 20% Final interest payment on FAP loan Account: 3,616 2,765 1,915 23,755 23,755 1001 11,558 0 11,558 48t Fund: 208,500 261,602 409,653 728,989 585,440 1258 629,412 0 629,412 107\ Orgn: 208,500 261,602 409,653 728,989 585,440 125\ 629,412 0 629,412 1079 26- 08/29/21 13:47:30 340 CITY SHOP Account Object -------------------------------- 1000 GENERAL 430200 Road 6 Street Services 366 Building Maintenance Account: CITY OF LAUREL Page: 21 of 25 Expenditure Budget by Orq Report -- Multi Year Actuals Report ID: B240A1 For the Year: 2021 - 2022 Current It Prelim. Budget Final % Old ---^---------- Accuals----------------- Budget Exp. Budget Changes Budget Budget 17-18 10-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 --^----- ---------- ----"----- ---------- ---------- ---------------------------------- ------ 212 0 0% 0 0% 212 0 "`% 0 0 0 01 430220 Facllle les 110 Salaries and Wages 6,300 6,490 6,383 5,558 6,700 83% 6,850 61850 102% Ill Overtime 1 3 37 100 37% 100 100 100% 138 Vision Insurance 14 24 18 12 20 60% 20 20 100% 139 Dental Insurance 101 133 95 56 100 56% 120 120 1208 141 Unemployment Insurance 17 23 30 14 20 70% 25 25 125t 142 Workers' Compensation 213 244 226 148 250 59% 110 110 491 143 Health Insurance 2,105 2,380 2,043 1,285 2,250 574 2,250 2,250 100t 144 Life Insurance 12 12 8 6 20 30% 20 20 100% 145 FICA 477 492 487 426 550 77% 550 550 100% 194 Flex Medical. 69 49 70 84 0% BS 85 101% 220 Operating Supplies 6,843 4,813 7,013 7,929 7,600 104% 71600 71600 100% 226 Clothing and Uniforms 169 0 `••% 170 170 `•"`% 233 Machinery a Equipment Par 702 29 1,171 500 2349 500 500 100% 312 Networking Fees 294 11125 3,983 5,324 4,000 1334 5,500 5,500 138% 335 Memberships 5 Dues 680 620 563 530 700 76% 700 700 100% 341 Electric Utility Services 8,717 LO, 103 12,310 11.831 10,500 113% 12,000 12,000 IL4% 343 Cellular Telephone 466 725 642 563 650 87% 650 650 100% 344 Gas Utility Service 9,224 8,238 71291 6,478 8,500 76% 81500 81500 100% 345 Telephone 538 642 662 71L 850 84% 850 850 100% 350 Professional Services 84 178 140 473 350 135% 350 350 100% 351 Medical, Dental, Veterina 105 205 250 300 O% 300 300 100% 366 Building Maintenance 425 3,129 8,813 9,517 4,000 238% 51000 5,000 125% Account: 37,386 39,626 51,039 52,238 48,044 109% 52,250 0 52,250 108% Fund: 37,386 39,626 51,251 52,238 48,044 109% 52,250 0 52,250 108% Orge: 37,386 39,626 51,251 52,238 48,044 109% 52,250 0 52,250 108% MA 08/29/21 CITY OF LAUREL Page: 22 of 25 13:4730 Expenditure Budget by Org Report -- Multiyear Actuals Report ID: U40A1 For the Year: 2021 - 2022 350 CEMETERY Current % Prelim. Budget Final E Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget budget Account Object -------------------------------- 17-18 ---------- 18-19 19-20 20-21 20-21 20-21 21-12 21-22 21-22 21-22 1000 GENERAL -------------------- ----------. ---------- ----- --------'-- ----"----- ---------- ------ 430900 Cemetery Services 110 Salaries and Wages 55,114 56,968 56,013 53,000 64,000 83t 65,100 65,100 102% 111 Overtime 330 2,163 391 135 1,000 14% 11000 1,000 loot 138 Vision Insurance 12 9 15 17 20 85% 60 60 300E 139 Dental Insurance 387 375 359 210 380 55% 40D 400 105% 141 Unemployment Insurance 139 207 85 134 165 81% 235 235 142% 142 Workers' Compensation 3,484 4,192 3,943 3,339 4,410 76% 3,300 3,300 751 143 Health Insurance 11,391 11,118 11,155 81968 11,600 77% 11,600 11,600 100% 144 Life Insurance 77 83 66 50 75 671 75 75 100% 145 FICA 3,952 4,261 4,038 3,792 51000 76% 51100 5,100 102% 194 Flex Medical 487 604 594 618 Ot 670 670 108% 220 Operating Supplies 5,408 3,884 2,099 2,530 4,700 54% 4,700 4,700 100% 223 Meals/Food 35 0 Ot 0 at 226 Clothing and Uniforms 250 500 50% 500 500 100% 231 Gas, Oil, Diesel Fuel, Gr 4,785 4,849 4,484 2,843 4,000 71% 4,000 41000 100% 233 Machinery 6 Equipment Par 8,972 3,327 1,772 2,832 2,000 142% 2,000 2,000 100% 239 Tires/Tubes/Chains 13 20 13 1,000 It 1,000 11000 100% 337 Advertising 167 259 202 167 400 42t 400 400 100% 350 Professional Services 300 O% 300 300 100% 351 Medical, Dental, Veterina 100 100 300 33% 351 351 117% 365 Tree Pruning/Grounds Mein 349 21000 O% 21000 2,000 100% 397 Contracted Services 32 72 32 40 100 40% 100 100 100: 900 Capital Outlay 0 at 18,000 18,000 „,^% Cemetery Kiosk Account: 94,785 92,720 85,368 78,420 102,568 761 120,891 0 120,891 117% 430920 Facilities 341 Electric Utility Services 2,081 2,506 2,205 2,430 31500 69% 3,500 3,500 1001 344 Gas Utility Service 771 777 782 854 1,000 85% 11000 1,000 100E 366 Building Maintenance 2,000 O% 2,000 2,000 100% Account: 2,852 3,283 2,987 3,284 6,500 51% 6,500 0 61500 1008 Fund: 97,637 96,003 88,355 81,704 109,068 75% 127,391 0 127,391 116% Orgn: 97,637 96,003 88,355 81, 7D4 109,068 75% 127,391 0 127,391 116% i 08/29/21 CITY OF LAUREL Page: 23 of 25 13:41:30 Expenditure Budget by Org Report -- MultiYear Actuals Report 10: 8240A1 For the Year: 2021 - 2022 370 PARKS Current B Prelim. Budget Final 1 Old ---------------- Acteals ----------------- budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-10 ---------- 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 1000 GENERAL ---------- ------------ --------- ---------- ---- --------- ' ---------- ---------- ------ 460430 Parks 110 Salaries and Wages 60,312 63,633 95,074 61.914 66,400 93% 67,900 67,900 102% Ill Overtime 37 54 159 267 1,731 15% 1,731 1,731 100% 138 Vision Insurance 13 11 87 12 15 80% 20 20 133% 139 Dental Insurance 93 75 472 109 70 156% 85 85 121% 141 Unemployment Insurance 150 222 143 155 175 89% 245 245 140% 142 Workers' Compensation 4,075 4,096 7,361 4,055 5,000 BIC 3,500 3,500 70% 143 Health Insurance ID, 418 10,222 19,132 10,342 10,200 101% 10,500 10,500 103% 144 Life Insurance 59 60 124 65 60 108% 60 60 100% 145 FICA 4,140 4,437 6,804 4,216 5,250 804 51350 5,350 102% 194 Flex Medical. 374 466 456 480 0% 520 520 108% 212 Trees, Shrubs, etc. 900 325 2,249 2,000 112% 2,000 2,000 100% 220 Operating Supplies 10,828 10,063 6,162 5,711 12,500 46% 10,000 10,000 80% 226 Clothing and Uniforms 250 2,000 13% 2,000 2.000 100% 231 Gas, Oil, Diesel Fuel, Gr 5,373 5,282 3,066 2,541 8,800 291 8,800 8,800 100% 233 Machinery 6 Equipment Par 1,732 3,032 2,519 3,312 4,000 831 4,000 4,000 100% 239 Tires/Tubes/Chains 925 1,138 635 25 1,000 3% 11000 1,000 100% 312 Netvorking Fees 217 220 154 500 0% 500 500 100% 336 Public Relations 1,351 95 3,000 3% 3,000 3,000 100% 337 Advertising 177 89 137 671 150 447% 800 800 533% 341 Electric Utility Services 487 518 514 975 2,000 49% 2,000 2,000 100% 343 Cellular Telephone 780 641 175 155 700 22% 700 700 100% 344 Gas Utility Service 289 146 1.415 300 472% 2,000 2,000 667% 350 Professional Services 344 28,006 300 '••% 300 300 100% 351 Medical, Dental, Veterina 310 370 105 105 300 35% 300 300 100% 360 Repair a Maintenance Sery 229 21000 0% 2,000 21000 100% 365 Tree Pruning/Grounds Main 5,600 2,490 8,400 11,600 01 11,600 11,600 100% 366 Building Maintenance 164 6,094 3,461 819 11,850 7% 11,850 11,850 100% 370 Travel 448 11000 0% 1,000 1,000 100% 380 Training Services 348 1,000 0% 1,00D 1,000 IDD% 397 Contracted Services 120 208 212 2,066 1,000 207% 11000 1,000 100% 452 Gravel and $antl 1,467 1,500 0% 1,500 1,500 100% 732 Purchases from Donations/ 31010 0 0% 0 0% 950 Park Development 19,699 49,032 313,054 377,000 831 170,OD0 170,000 45% Lion's Perk Dock, Trail, and Pond Account: 109,683 138,809 205,053 442,584 533,881 83% 327,261 0 327,261 61% 460445 Swimning Pools 110 Salaries and Wages 1,362 1,425 1,468 226 0 •••% 1,500 1,500 .....% 111 Overtime 0 OB 500 500 '••••6 138 Vision Insurance 1 2 2 0 0% 2 2 •••••% 139 Dental Insurance 10 9 9 1 0 ••4 17 17 •••••1 141 Unemployment Insurance 3 5 2 1 0 ++•% 10 IO •`•"1 142 Workers' Compensation 5 6 6 1 0 ••`% 45 45 .....1 143 Health Insurance 193 188 198 26 0 `••% 200 200 •••••% 144 Life Insurance 1 l 1 0 0% 5 5 •••`•% 145 FICA 103 108 111 17 0 ••4 151 151 •••••% -29- 00/29/21 CITY OF WUREL Page: 24 of 25 13:47:30 Expenditure Budget by Org Report -- MultiYear Actuals Report to: 3240A1 For the Year: 2021 - 2022 370 PARKS Current % Prelim Budget Exp. Budget 20-21. 20-21 21-22 0 0% ---------------- Actuals - ---------------- 00 Account Object ------------------------------ 17-18 18-19 19-20 20-21 194 Flex ModlcaL ---------- 9 ---------- 10 ---------- 12 --------- 200 Supplies 68 43% 2,000 11000 220 Operating Supplies 1,080 522 152 0 221 Chemicals 4,179 4,163 2,276 233 Machinery b Equipment Par 162 339 Certification Renewal 200 200 200 200 341 Electric Utility Services 2,210 2,455 1.767 853 345 Telephone 576 702 687 729 366 Building Maintenance 354 150 125 380 Training Services 295 137 397 Contracted Services 47,950 45,608 29,408 10 Estimate for contract with YMCA Account: 58,599 55,691 36,586 2,064 Current % Prelim Budget Exp. Budget 20-21. 20-21 21-22 0 0% 35 0 00 0 09 500 0 0% 5,000 0 o% 500 0 `••\ 200 2,000 43% 2,000 11000 731 11000 200 0% 200 0 08 500 0 •••% 50,000 3,200 65% 62,365 Fund: 16B,282 194,500 241,639 444,648 537,081 83% 389,626 Oren: 168,282 194,500 241,639 444,648 537,881 83% 389,626 -30- Budget Final % Old Changes Budget Budget 21-22 21.22 21-22 35 •••••\ 0 0% 500 •••^% 51000 •••••1 500 .....% 200 .....\ 2,000 loot 1,000 1001 200 100% 500 •••••1 50,000 -... % 0 62,365 1948% 0 389,626 72% 0 389,626 72% 08/24/21 CITY OF LAUREL Page: 25 of 25 13:47:30 Expenditure Budget by Org Report -- Multiyear ACLuals Report ID; B240A1 For the Year: 2021 - 2022 900 TRANSFER Current 1 Prelim. Budget Final \ old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object 17-18 18-19 19-20 20-21 20-21 20-21 21-22 2L-22 21-22 21-22 ----------------- --------------- ---------------------------------------------- --------------------------------- ------ 1000 GENERAL 521000 Interfund Operating Transfers Out 820 Transfers to Other Funds 171,683 151,875 161,924 0 D% 147,400 147,400 .....1 $140,000 transfer to CIP fund 57,400 transfer to Transit program 821 Grant Match Transfer 2,500 2,500 2,500 6,783 7,400 928 0 at Account: 174,183 154,375 164,424 6,783 7,400 92% 147,400 0 147,400 1991% Fund: 174,183 154,375 164,424 6,783 7,400 92% 147,400 0 147,400 1991% Orgn: 174,183 154,375 164,424 6,783 7,400 92% 147,400 0 147,400 1991% Grand Total: 3,409,344 3,564,360 3,894,836 4,322,026 4,345,295 4,849,877 0 4,849,877 -31- 10'i 13 i ko, ; WA -32- 08/27/21 CITY OF LAUREL Page: 1 of 1 12:39:14 Revenue Budget Report -- Multiyear Actuals Report I0: B250B For the Year: 2021 - 2022 Current % Prelim. Budget Final % Old ----------- ----- Actuals ----------------- Budget Rec. Budget Change Budget Budget Account 17-18 ------------------------------- ---------- 18-19 19-2D ---------- '--------- 20-21 ---------- 20-21 -------- 20-21 21-22 ---------- 21-22 ---------- 21-22 ---------- 21-22 ------ 2220 LIBRARY 310000 TAXES 313010 Real Property 'faxes 222,167 232,612 226,146 103E 270,278 270,278 119% 311020 Personal Property Taxes 3,275 4,359 4,616 94% 5,475 5,475 116% Group: 225,442 236,971 230,762 103E 275,753 0 275,753 119% 330000 INTERGOVERNMENTAL REVENUES 331100 Flood Control Grant 26,003 0 •.,% 0 0% Group: 26,003 0 ••^E 0 0 0 0% 340000 CHARGES FOR SERVICES 346076 Library Copy Fees 608 1,170 600 195% 600 600 100% Group: 608 11170 600 195% 600 0 600 100E 360000 Miscellaneous Revenue 360000 Miscellaneous Revenue 230 64,400 0% 200 200 0% 365001 Library Donations 2,935 800 367% 800 800 100% Group: 3,165 65,200 5% 1,000 0 11000 1% 370000 Investment and Royalty Earnings 371010 Investment Earnings 2 O ^••E 10 10 •••^% Group: 2 0 '•^% t0 0 1.0 '•••"E 380000 Other Financing Sources 383000 Interfund Operating 13,598 0 0% 0 0% Group: 13,598 0 0% D 0 0 0% Fund: 239,648 267,311 296,562 901 277,363 0 277,363 93E Grand Total: 239,648 267,311 296,562 277,363 0 277,363 33- -34- 08/22/21 CITY OF LAUREL page: I of 1 11:42:42 Expenditure Budget by Org Report -- Multiyear Actuals Report 1D: B240A1 For the Year: 2021 - 2022 360 LIBRARY Current 1 Prollm. Budget Final 1 Old ---------------- Actual- ----------------- Budget Exp. Budget Changes Budget Budget Account Object ___ _______________________ 17-18 18-19 /9-20 __________ 20-21 20-21 20-21 21-22 21-22 21-22 21-22 2220 LIBRARY __________ __________ __________ __________ ____ __________ __________ __________ ------ 460100 Library Services 110 Salaries and Wages 139,973 167,342 169,262 991 179,448 179.448 106% 138 Vision Insurance 280 171 343 50% 343 343 100% 139 Dental Insurance 1,695 1,332 1,719 771 2,065 2,065 120% 141 Unemployment Insurance 210 418 280 149% 394 394 1416 142 Workers' Compensation 1,336 1,393 1,625 861 1,723 1,723 106% 143 Health Insurance 29,243 31,244 31,237 100% 31,237 31,237 1001 144 Life Insurance 192 192 367 52% 432 432 118% 145 FICA 10,702 12,768 13,033 98% 13,818 13,818 106% 146 PERS 10,937 13,048 14,557 90% 15,433 15,433 106% 194 Flex Medical, 1,000 2,406 O% 2,568 2,568 107% 210 Office Supplies 6 Materia 2,882 1,513 2,750 55% 500 500 18% 216 Computer/Printer Supplies 2,051 193 1,500 13% 250 250 17% 311 Postage 99 15 225 7% 100 100 44% 312 Networking Fees 852 11700 O% 500 500 29% 322 Books/Catalogs, etc. 12,024 9,022 25,000 36% 51000 5,000 20% 328 Data Base Subscriptions 1.341 1,749 2,500 70% 1,450 1,450 58% 332 Internet Access Fees 2,026 1,087 1,950 56% 1,200 11200 62% 333 Subscriptions -Newspapers 796 324 1,000 32% 400 400 401 335 Memberships 6 Dues 269 500 0% 15D 150 30% 337 Advertising 175 222 150 148% 50 50 33% 343 Cellular Telephone 150 O% 0 01 370 Travel 2,045 31000 0% 500 500 17% 397 Contracted Services 201 330 550 60% 250 250 458 511 Insurance on Bldgs/Imprvm 1,133 1,240 11241 100% 1,335 1,335 108% 513 Liability 5,010 4,628 4,630 100% 7,361 7,361 159% Account: 226,472 248,231 281,675 88% 266,507 0 266,507 94% 460120 Facilities 220 Operating Supplies 1,024 699 850 82% 200 200 24% 341 Electric Utility Services 3,142 2,908 3,000 97% 3,000 3,000 100% 344 Gas Utility Service 983 11090 11000 109% 1,000 11000 100% 345 Telephone 1,349 110 1,000 11% 600 600 60% 365 Tree Pruning/Grounds Main 250 O% 550 550 2201 366 Building Maintenance 804 203 800 25% 400 400 50% 398 Janitorial Service 281 296 500 591 200 200 40% 399 other Contracted Services 51553 6,020 6,500 93% 6,250 6,250 96% Account: 13,136 11,326 13,900 81% 12,200 0 12,200 87% Fund: 239,608 259,557 295,575 881 278,707 0 278,707 94% Orgn: 239,608 259,557 295,575 88% 278,707 0 278,707 94% Grand Total: 239,608 259,557 295,575 278,707 0 278,707 -35- W 1 11111 !l :111 !, BEER' -36- 08/27/21 CITY OF LAUREL Page: 1 of 1 14:22:19 Revenue Budget Report -- Multiyear Actuals Report ID: 82508 For the Year: 2D21 - 2022 Current t Prelim. Budget Final 1 Old ---------- ---- -- Actuals ----------------- Budget S.C. Budget Change Budget Budget Account ____________________ 17-16 --- --- __ 18-19 ---------- 19-20 _-___ ----- 20-21 _---- 20-21 __________ 20-21 __-_ 21-22 ---------- 21-22 ---------- 21-22 ---------_ 21-22 _-___- 2250 PLANNING 330000 INTERGOVERNMENTAL REVENUES 331010 CDBG 7,596 0 O6 0 01 Group: 7,596 0 OB 0 0 0 OB 340000 CHARGES FOR SERVICES 341071 Plat Review Fee 11900 2,220 1,200 31550 2,000 17B% 21000 2,000 1008 341072 Zone Change Fee 450 0 •••t 200 200 '•"'1 341073 Annexation Fee 1,089 1,077 11000 1086 11000 1.000 1008 341074 Home Occupation Fee 300 450 225 150 300 5D% 200 200 66% 341075 Special Review Fee 325 325 910 3,842 500 7681 11500 1.500 3006 341076 Variance Fee 2,900 2,750 2,000 1381 2,000 2,000 1008 341077 TEMPORARY USE PERMIT 100 OB 100 100 1001 341081 Subdivision Application 600 2,600 6,850 2,973 3,000 991 3,000 3,000 1008 341090 CNTY Share-C/C Planning 57,122 160,316 97,695 92,290 93,000 99% 99,050 99,050 106% 341284 Conditional Use Permit 2,750 0 •••1 11000 1,000 ••"•1 Group: 60,247 167,000 109,780 109,834 101,900 1081 110,050 0 110,050 1071 360000 Miscellaneous Revenue 360000 Miscellaneous Revenue 4,361 0 Ot 0 09 Group: 4,361 0 Ot 0 0 0 01 370000 Investment and Royalty Earnings 371010 Investment Earnings 37 131 38 0 09 0 OE Group: 37 131 38 0 01 0 0 0 06 380000 Other Financing Sources 383000 Interfund Operating 20,683 6,000 15,000 0 01 0 Ot 383003 Transfer-Permis. Ned. 61017 0 OS 0 OB Group: 26,700 6,000 15,000 0 01 0 0 0 OB Fund: 94,580 173,131 129,179 109,834 101,900 1086 110,050 0 110,050 1076 Grand Total: 94,580 173,.131 129,179 109,834 .101,900 110,050 0 110,050 -37- All Ilk ill ir III` .,1711illi No 08129/21 CITY OF LAUREL page: 1 0f 2 20:02:17 Expenditure Budget by Org Report -- MulLIYear Atawald Report W: 0240A1 For the Year: 2021 - 2022 380 CITY/COUNTY PLANNING Current % Prelim. Budget Final % Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object --------------------- ---- _------- 17-18 ---------- 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 2250 PLANNING -------------------- ---------- -- '------- ---- -- ------- ---------- ------- "-- ------ 411000 Planning s Research Services 110 Salaries and Wages 79.211 112,435 50,053 29,746 24,825 1206 25,100 25,700 1041 138 Vision Insurance 86 73 86 41 40 103% 40 40 100% 139 Dental Insurance 472 388 470 203 200 102% 240 240 120% 141 Unemployment Insurance 114 123 75 74 65 114E 90 90 138% 142 Workers' Compensation 184 164 225 157 125 126% 145 145 1160 143 Health Insurance 10,164 7,863 9,894 4,998 41600 109% 4,585 4,585 100% 144 Life Insurance 76 57 74 35 35 100% 35 35 1006 145 FICA 3,487 2,694 3,829 2,276 2,000 114% 1,960 1,960 98% 146 PERS 3,849 2,721 4,339 2,609 ' 2,180 1200 2,275 2,275 104% 194 Flex MedicaL 11 15 4 264 0% 265 265 100% 210 Office Supplies 6 Materia 1,750 29 0 "`t 0 0% 220 Operating Supplies 670 4,719 384 306 1,000 31% 11000 11000 1000 231 Gas, 011, Diesel Fuel, Gr 221 62 89 25 300 81 300 300 100% 311 Postage 305 251 93 1, I08 1.,500 74% 1,500 11500 100% 312 Networking Fees 217 1.191 2,996 2,830 3,500 81% 3,000 3,000 86% Reduced by $500 335 Memberships s Dues 339 515 60 99 11000 10% 1,000 1,000 100% 337 Advertising 4,302 9,213 424 2,614 1,500 174% 2,000 2,000 133% Increased by $500 due to increased public hearings 343 Cellular Telephone 1,338 2,145 1,675 1,133 21500 45% 1.500 1,500 60% Reduced by $1,000 350 Professional Services 667 667 28,760 36,652 5,000 733% 10.000 10,000 200% lncreasetl by $5,000 356 Consultant's Services 11500 0% 0 0% Reduced by $1,500 357 Growth Management Plan 26,541 14,267 43,459 33% 0 Ot 370 Travel 220 2,082 11500 0% 1,500 11500 100% 380 Training Services 195 555 21000 0% 2,000 2,000 100% 397 Contracted Services 379 426 7,638 1,228 1,000 123% 1,500 11500 150% Increased by $500. Copier contract 513 Liability 906 1,228 1,579 1,459 1,460 100% 1,460 1,460 100% 946 Computer Eq/Software 0 O% 26,000 26,000 .....% Municity Software Account: 107,413 146,950 143,675 101,889 101,553 100% 88,095 0 88,095 86% Fund: 107,413 146,950 143,675 101,889 101,553 100% 88,095 0 88,095 86% Orgn: 107,413 146,950 143,675 101,889" 101,553 100% 88.095 0 88,095 86% -39- 08/29/21 CITY OF LAUREL Page: 2 of 2 20:02,7 Expenditure Budget by Org Report -- Multiyear Actuals Report I0: O24OA1 For the Year: 2021 - 2022 900 TRANSFER Current t Prelim. Budget Final 1 Old ---------------- Actuals ----------------- Budget Exp. Budget Changos Budget Budget Account Object 11-18 18-19 19-20 20-21 20-21 2.0-21 21-22 21-22 21-22 21-22 -------------------------------- -'-------- ----- ----------------------------------- -----------------------'--- -------- ------ 2250 PLANNING 521000 Interfund Operating Transfers Out 392 Administrative Services 7,931 7,931 12.341 11,312 0 ...t 12,341 12,341 .....1 Account: 7,931 7,931 12.341 11,312 0 ^•9 12,341 0 12,341 •••`•5 Fund: 7.931 7,931 12,341 11,312 0 '••0 12,341 0 12,341 •^•"8 Orgn: 7,931 7,931 12,341 11,312 0 ^••9 12,341 0 12,341 '••••1 Grand Total: 115,344 154,881 156,016 113,201 101.553 100,436 0 100,436 40- Kill I moll"ll AAA 41- 08/27/21 CITY OF LAUREL Page: 1 of 1 14:52:23 Revenue Budget Report -- MultiYeau Actuals Report ID: 32500 For the Year: 2D21 - 2022 Current % Prelim. Budget Final t Old ---------------- Actuals ----------------- Budget Res. Budget Change Budget Budget Account -------------- _______------ 17-18 __________ 18-19 __________ 19-20 ---- __---- ------ 20-21 _-- 20-21 ---------- 20-21 ___- 21-22 ----------- 21-22 ----__-_-- 21-22 ---------- 21-22 ------ 2310 TAX INCREMENT-Buaineae Dist. 310000 TAXES 311010 Real Property Taxes 624,255 670,291 596,138 718,738 596,138 121% 675,218 675,218 113% 311020 Personal Property Taxes 451 29,456 17,713 37,213 17,713 210% 32,218 32,218 1811 Group: 624,706 699,747 613,851 755,951 613,851 123% 707,436 0 707,436 1151 330000 INTERGOVERNMENTAL REVENUES 335230 HB124 Entitlement 72,175 72,175 72,175 72,175 72,175 100% 72,175 72,175 100% Group: 72,175 72,175 72,175 72,175 72,175 1001 72,175 0 72,175 300% 360000 Miscellaneous Revenue 360000 Miscellaneous Revenue 900 0 O% 0 0% 36304D Penalty 6 Interest 21106 2,208 1,235 2,705 1,235 219% 11200 1,200 97% 365020 Private Grants 3,000 0 0% 0 0% Group: 61006 2,208 1,235 2,705 1,235 219% 1,200 0 1,200 97% 370000 Investment and Royalty Earnings 371010 Investment Earnings 61053 15,681 17,486 2,828 3,000 94% 3,000 31000 loot Group: 6,053 15,681 17,486 2,828 3,000 94% 3,000 0 3,000 100% 380000 Other Financing Sources 381006 Loan/Note Proceeds 195,000 0 Ot 0 0% 381025 TIF District BOND 3,055,000 0 0% 0 0% Group: 195,000 3,055,000 0 0% 0 0 0 0% Fund: 903,940 789,811 3,759,747 833,659 690,261 121% 783,811 0 783,811 113% Grand Total: 903,940 789,811 3,759,741 833,659 690,261 783,811 0 783,811 -42- -43- 08/22/21 CITY OF LAUREL Page: I of 2 15:42:13 Expenditure Budget Report -- Multiyear Actuals Report IU: B240B For the Year: 2021 - 2022 Current % Prelim. Budget Final % Old ---------------- Artesia ----------------- Budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-18 ---------- 18-19 ---------- 19-20 ---------- 20-21 ---------- 20-21 ---------- 20-21 ---- 21-22 ---------- 21-22 ---------- 21-22 ---------- 21-22 ---_-- 2310 TAX INCREMENT -Business Dist. 411850 Special Projects 110 Salaries and Wages 11,622 14,029 14,200 991 18,710 18,710 132E 138 Vision Insurance 18 21 21 100E 28 28 1331 139 Dental Insurance 93 105 112 90 175 125 156E 141 unemployment Insurance 1B 35 36 97% 66 66 183E 142 Workers' Compensation 50 78 60 130E 106 106 177E 143 Health Insurance 2,059 2,604 2,610 100E 3,335 3,335 128E 144 Life Insurance IS IB 20 90% 24 24 120E 145 FICA 889 1,077 11090 99% 1,435 1,435 132E 146 PERS 1,008 1,235 1,250 99E 1,660 1,660 133% 194 Flex MedicaL 150 0% 192 192 128% 220 Operating Supplies 1,000 Ot 1,000 11000 1001 223 Meals/Food 221 24 500 Ot 0 0% 337 Advertising 322 291 50 700 0% 700 700 100% 350 Professional Services 26,511 0 0% 0 01 370 Travel 1,500 01 1,500 1,500 100% 380 Training Services 1,500 0% 1,500 1,500 loot 700 Grants, Contributions a 1 109,222 0 01 0 0% 735 TIFD Large Grant 199,191 225,000 89% 275,000 275,000 122% 736 'TIFD Small Grant 26,289 50,000 53% 50,000 50,000 100E 737 TIFD Facade Grant 16,575 15,000 111% 15,000 15,000 100% 738 TIFD Technical Assistance 5,029 15,000 341 15,000 15,000 L00t 901 MISC CAPITAL PROJECTS 362,134 77,000 0 0% 21000,000 21000,000 .....% 931 Roads, Streets 6 Parking 58,595 2,188,594 1,116,682 2,886,986 39E 0 0% Account: 503,460 135,910 2,204,416 1,383,018 3,216,735 43% 2,385,431 0 2,385,431 74% 430200 Read 6 Street Services 350 Professional Services 32,000 0 0% 0 0% Account: 32,000 0 •••1 0 0 0 0% 470300 Ccomonic Development 350 Professional Services 24,979 0 0E 0 0% 700 Grants, Contributions 6 1 139,625 0 0% 0 Ot Account: 164,604 0 •••E 0 0 0 at 490000 Debt Service 610 Principal 68,320 108,004 0 ••`1 82,685 B2,685 .....% 620 Interest 3,265 1,399 21,799 72,236 0 •••% 97,559 97,554 •••••Y Aecount: 3,265 11399 90,119 180,240 0 •••t 180,239 0 180,239 •••••% 521000 Interfund Operating Transfers Out 820 Transfers to Other Funds 31,500 12,000. 6,000 5,500 6,000 92% 6,000 61000 100E Account: 31,500 12,000 6,000 51500 6,000 92% 6,000 0 6,000 100% Fund: 538,225 313,913 2,332,535 1,568,758 3,222,235 49% 2,571,670 0 2,571,670 80% t Grand Total: 538,225 313,913 2,332,535 1,568,758 3,222,735 2,571,670 0 2,571,670 City of Laurel 2021-2022 Enterprise Funds - Summary Schedule Fund # 5210 5310 5410 Fund Name Water 44.'1%.Resexvcs Sewer l9 2 %e 6s¢WtS Solid Waste 4-1.�f5e 2eservts (1) Appropriation $ 7,819,524.00 $ $ 4,397,632.00 $ $ 1,156,128.00 $ (2) Budgeted Cash Reserve 3,496,818.33 835,181.86 552,189.91 (3)—(I)+(2) Total Requirements $ 11,316,342.33 $ 5,232,813.86 $ 1,708,317.91 (4) Cash Available (Less current liabilities ) $ 8,072,042.33 $ 3,257,458.86 $ 825,784.9] (5) Total Non -Tax Revenues (6)=(4)+(5) Total Resources $ 3,244,300.00 $ 11,316,342.33 $ 1,975 355.00 $ 5,232,813.86 $ 882,533.00 $ 1,708,317.91 TOTAL $ ]3,373,284.00 $ 4,884,]90.10 $ ]8,257,474.10 $ 12,155,286.10 $ 6,102,188.00 $ 18,257,474.10 -45- ra. 08/29/21 CITY OF LAUREL page: 1 of 1 14:26:11 Revenue Budget Report -- Multiyear Actuals Report 10: 82508 For the Year; 2021 - 2022 Current 1 Prelim. Budget Final 1 Old ---------------- Actuals ----------------- Budget Ree. Budget Change Budget Budget -----------^-"- Account ----------- 17-18 ---------- 18-19 -----"---- 19-20 -- ------- 20-21 ---,------ 20-21 ---------- 20-21 ---- 21-22 ---------- 21-22 ---------- 21-22 ---------- 21-22 ------ 5210 WATER 330000 INTERGOVERNMENTAL REVENUES 331096 ONRC Grant 125,000 0 01 0 0\ 331097 TSEP Grant 500,000 12,500 0 "•\ 0 0\ 331100 Flood Control Grant 2,355 0 •"\ 0 0\ Group: 625,000 14,855 0 •'•1 0 0 0 Da 340000 CHARGES FOR SERVICES 343020 Water Revenues - Cap 336,346 337,514 345,733 348,908 332,000 1051 332,000 332,000 100\ 343021 Metered Water Sales 3,092,345 2,983,487 2,767,397 3,120,524 2,750.000 1131 2,850,000 2,850,000 103\ 343024 Sales of Water Supplies 11700 3,334 7,413 1,263 3,000 421 1,500 11500 501 343027 Miscellaneous Water 2,200 3,800 2,562 1,641 2,000 821 2,000 2,000 1001 341029 Water Line 1ns. 32,058 32,061 32,332 32,452 31,000 105\ 31,000 31,000 1001 343033 System Devlpmt Fee 1.8,855 74,355 23,370 25,395 18,000 1411 20,000 20,000 111\ Group: 3,483,504 3,434,551 3,178,807 3,530,183 3.136,000 113\ 3,236,500 0 3,236,500 103\ 360000 Miscellaneous Revenue 360000 Miscellaneous Revenue 584 0 01 0 01 363040 Penalty 6 Interest 6 8 8 13 0 ••`t 0 Ot Group: 590 8 8 13 0 '••\ 0 0 0 O\ 370000 Investment and Royalty Earnings 371010 Investment Earnings 17,350 16,996 22,632 4,327 8,000 541 4,000 4,000 50\ 371011 System Devel. Int. 4,068 5,233 41855 613 3,000 22t 500 50D 161 371013 Bond Sinking Int. 4,160 12,215 769 108 200 541 100 100 50\ 371014 Capital Projects Int. 16,709 32,743 24,739 3,716 3,000 1241 31000 3,000 1001 371015 DNRC Bond Sinking Inc, 1,129 2,761 3,124 409 200 205\ 200 200 1001 371016 Capital Int/Yearly Replac 1 1 1 0 0\ 0 01 373050 TIFD Prinicipal -1,056 0 01 0 09 373060 TIFD Interest 3,079 1,399 0 01 0 0\ Group: 45,440 71,348 56,120 9,233 14,400 641 7,800 0 7,800 541 3800DO Other Financing Sources 382010 Sale of Fixed Asset -227,237 0 0\ 0 01 383000 Interfund Operating 1,347 72,972 0 01 0 0\ Group: 1,347 -227,237 72,972 _ 0 0\ 0 ,.0 0 01 Fund; 3,530,881 3,903,670 3,307,907 3,554,284 3,150,400 1131 3,244,300 0 3,244,300 102\ Grand Total: 3,530,881 3,903,670 3,307,907 3,554,284 3,150,400 3,244,300 0 3,244,300 -47- 9• 08/29/21 CITY OF LAUREL Page: I of 2 16:58:46 Expenditure Budget by org Report -- Multiyear Actuals Report to: 8240A1 For the Year: 2021 - 2022 $00 WATER PLANT Current % Prelim. Budget Final 1 Old ---------------- Actuals ---------------- Budget Exp• Budqu% Change. Budget Budget Account Object ------------------------------------------ 17-18 18-15 ---------- 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 5210 WATER ---------- ---------- --------- - ---- ---------- ---------- ---------- ------ 430540 Purification and Treatment 110 Salaries and Wages 433,313 456,808 424,797 438,247 475,430 92% 447,295 447,295 941 Ill Overtime 4,120 7,109 2,256 1,127 15,800 71 15,800 15,800 100% 138 Vision Insurance 399 408 488 533 525 102% 600 600 114% 139 Dental Insurance 2,840 3,183 3,489 2.,981 3,660 81% 4,065 4,065 lilt 141 Unemployment insurance 11089 1,663 649 1.098 725 151% 1,625 1,625 2241 142 Workers' Compensation 18,969 23,164 21,676 16,348 18,350 89% 7,250 7,250 40% 143 health Insurance 79,182 72,327 60,487 72,953 88,500 82% 76,735 76,735 871 144 Life Insurance 558 560 545 515 575 90% 550 550 96% 145 FICA 32,190 35,850 33,021 33,567 36,800 91% 35,450 35,450 96% 146 PERS 108,592 89,817 37,229 38,208 41,300 93% 41,300 41,300 100% 148 ICMA Retirement 354 0 01 0 0% 194 Flex Medical 2,198 2,998 2,975 4,800 0% 4,835 4,835 1018 220 Operating Supplies 51 Boa 5,452 11,370 13,002 10,000 130% 12,000 12,000 120% Increased by $2,000 per Public Works Director request 221 Chemicals 46,467 82,441 52,936 98,179 125,000 79% 125,000 125,000 100% 222 Laboratory d Medical Supp 2,409 582 11,490 2,112 81000 26% 8,000 8,000 100% 226 Clothing and Uniforms 144 72 1,029 500 206% 11000 1,000 200% Increased for boot allowance change 231 Gas, Oil, Diesel Fuel, Or 1,494 11059 745 4,016 3,500 115% 4,000 4,000 114% Increased by $500 per Public Works Director request 232 Motor Vehicle Parts 761 135 161 3,851 1,000 385% 51000 51000 500% Increased by $4,000 per Public Works Director request 233 Machinery a Equipment Par 7,128 7,074 7,670 16,021 13,000 123% 16,000 16,000 123% Increased by $3,000 per Public Works Director request 241 Consumable Tools 145 190 291 3,000 10% 3,000 31000 100% 263 Safety Supplies 2,598 133 824 63 81000 11 8,000 81000 100% 312 Networking Fees 524 2,067 2,822 2,100 130 5,000 5,000 238% Increased by $2,900 per Public Works Director request 335 Memberships 6 Dues 2,005 550 309 668 1,500 451 1,500 11500 100% 337 Advertising 677 564 364 378 2,500 15% 2,500 21500 100% 339 Certification Renewal 356 287 321 461 2,000 23% 2,000 2,000 100% 341 Electric Utility Services 142,647 144,999 154,147 151,232 200,000 76% 200,000 200,000 100% 343 Cellular Telephone 1,184 677 405 270 1,200 231 1,200 1,200 100% 344 Gas Utility Service 16,705 16,435 21,482 15,891 30,000 531 30,000 30,000 100% 345 Telephone 2,871 3,139 3,355 836 3,500 24% 0 0% Decreased by $3,500 per Public Works Director request 349 Quality Testing 5,961 6,140 6,171 7,477 10,000 75% 10,000 10,000 100% 350 Professional Services 8,681 6,330 45,069 12,940 15,000 86% 15,000 15,000 100% 351 Medical, Dental, Veterina 742 665 185 743 1,000 74% 1,000 1,000 100% 355 Data Processing Services 393 2,000 0% 2,000 2,000 100% 364 Water/Sewer Struct. 6 Equ 15,071 7,069 13,641 52,996 350,000 15% 350,000 350,000 1001 366 Building Maintenance 2,533 2,854 328 3,087 51000 62% 50,000 50,000 10001 Increased by $45,000 per Public Works Director request 370 Travel 1,330 393 990 4,000 0% 4,000 4,000 100% 380 Training Services 1,001 1,371 811 628 3,OOD 21% 3,000 3,000 100% 397 Contracted Services 2,036 1,429 854 5,955 2,200 271% 7,000 1,000 3181 Increased by $4,800 per Public Works Director request la 08/29/21 CITY OF LAUREL Page: 2 of 2 16:58:46 Expenditure Budget by Org Report -- Multiyear Actuals Report ID: B24DA1 For the Year: 2021 - 2022 500 WATER PLANT Current % Prelim. Budget Final G Old -----^-------- Actual. ---- ---------- Budget Exp. Budget Changes Budget Budget Account Object -------------"------------------ 17-18 ---------- 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 511 Insurance on Bldgs/Imprvm 71888 -------------------- 8,317 8,658 ---------- 9,499 ---------- 91500 ---- 1001 ---------- 91500 ---"------ ---------- 9,500 ------ 1001 513 Liability 10,767 14,585 18,755 17,326 17,330 100% 17,330 17,330 1001 514 Vehicle/Equipment Insuran 258 289 308 324 325 100% 325 325 100% 519 Pollution Insurance 500 0% 500 500 1001 533 Machinery 6 Cqipment Rent 3.122 2,089 3,803 5,110 30,000 17% 30,000 30,000 L00% 544 Discharge Permit Fee 1,500 2,625 2,625 1,125 6,000 19% 3,000 3,000 50t Decreased by 83,000 per Public Works Director request 900 Capital Outlay 41,089 0 ••'% 0 0% 911 Drying Beds/Sed Basins 5,354 D ...1 0 04 920 Buildings 9,396 380,000 2% 0 0% 925 Water Intake Structure 2,000,000 0% 0 0% 930 Improvements Other than B 0 0% 700,000 700,000 .....% Lift Well replacement 940 Machinery 6 Equipment 841 200,000 Ot 300,000 300,000 150% Purchase of new Dredge 946 Computer Eq/Software 0 0% 560,000 560,000 .....% Wonderware Software Upgrade - $60,000 Upgrade two (5) Pregramable Logic Controllers - $500,000 Account: 978,546 1,012,094 957,738 1,090,569 4,137,120 26% 3. 122,360 0 3,122,360 75% 430550 Transmission s Distribution 220 Operating Supplies 40 0 O% 0 0% Account: 40 0 •• 0 0 0 0% 490000 Debt Service 610 Principal -1.180 854,000 386,000 221% 205,000 205,000 53% Principal Payment on SED Basin Loan 620 Interest 36,722 23,326 128,898 128,514 129.396 99% 109,500 109,500 85% Interest Payment on SED Basin Loan Account: 36,722 23,326 127,718 982,514 515.396 191t 314,500 0 314,500 61% 510400 Depreciation 830 Deprec-Closed to Retained 774,297 763,380 890,204 750,000 0% 750,000 750,000 100% Account: 774,297 763,380 890,204 750,000 0% 750,000 0 750,000 100% Fund: 1,789,605 1, 798, B00 1,975,660 2,073,083 5,402,516 381 4,186,860 0 4,186,860 77% Orgo: 1,789,605 1,798,800 1,975,660 2,073,083 5,402,516 38t 4,186,860 0 4,186,860 77% Grand Total: 1,789,605 1,798,800 1,975,660 2,073,083 5,402,516 4,186,860 0 4,186,860 -50- 08/29/21 CITY OF LAUREL Page: 1 of 3 17:05:29 Expenditure Budget by Org Report -- MultiYear Actuals Report lot B240At For the Year: 2021 - 2022 540 WATER SYSTEM Current 1 Prelim. Budget Final 1 Old ------------- Actuals ---------------- Budget Exp. Budget Changes Budget Budget Account Object ------------------------------------------ 17-18 18-19 -------------------- 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 5210 WATER ---------- ---------- "--- ---------- ---------- ---------- ----- 430540 Purification and Treatment 220 Operating Supplies 13 0 OB 0 0% Account: 13 0 "'t 0 0 0 0% 430550 Transmission b Distribution 110 Salaries and Wages 153,752 153,677 142,640 123,036 177,200 69t 190,705 190,705 108% 111 Overtime 2,891 1,739 1,440 2,716 3,060 89% 3,060 3,060 loot 138 Vision Insurance 76 93 257 166 252 66% 160 160 63% 139 Dental Insurance 1,476 1,426 1,492 935 1,680 56% 1,050 11050 63% 141 Unemployment Insurance 389 524 242 315 275 115% 680 680 247% 142 Workers' Compensation 8,683 9,382 10,066 51979 11,600 52% 8,350 8,350 72% 143 Health Insurance 28,277 25,837, 25,725 23,415 35,700 661 41,350 41,350 116% 144 Life Insurance 211 202 191 163 269 61% 260 260 971 145 FICA 11,741 11,309 12,248 9,502 13,900 68% 14,825 14,825 1071 146 PERS 12,858 12,789 13,968 11,018 15,700 70% 17,190 17,190 109% 194 Flex Medical 1,355 2,031 1,407 1,720 0% 2,305 2,305 1344 220 Operating Supplies 7,573 81816 12,485 27,068 26,000 104% 26,000 26,000 100% 226 Clothing and Uniforms 135 150 548 500 110% 500 500 100% 230 Repair a Maintenance Supp 63 6,612 0 •'•% 10,000 10,000 .....% Increased by 410,000 231 Gas, Oil, Diesel Fuel, Gr 9,513 8,397 6,251 4,974 15,000 33% 15,000 15,000 100% 232 Motor Vehicle Parts 4,115 2,481 655 3,716 4,000 93% 5,000 5,000 125% Increased by $1,000 per Public Works Director request 233 Machinery a Equipment Par 30,898 33,928 46,144 7,395 30,000 25% 30,000 30,000 loot 239 Tires/Tubes/Chains 17 250 3,000 0% 3,000 3,000 100% 241 Consumable Tools 323 723 705 568 2,000 28% 2,000 2,000 100% 263 Safety Supplies 227 74 1,323 2,000 66% 2,000 2,000 100% 311 Postage 3,374 3,265 3,305 3,366 5,000 67% 5,000 51000 100% 312 Networking Fees 340 474 230 11000 OB 1,000 11000 100% 337 Advertising 530 507 1,500 341 1,500 11500 100% 339 Certification Renewal 260 160 434 90 11000 9% 11000 11000 100% 341 Electric Utility Services 9,040 8,454 81905 8,005 15,600 Sit 15,600 15,600 100% 343 Cellular Telephone 577 713 1,232 748 2,000 37% 2,000 2,000 loot 350 Professional Services 15,659 667 912 33,894 20,000 169% 20,000 20,000 100% 351 Medical, Dental, Veterina 598 205 361 405 600 68% 600 600 100% 355 Data Processing Services 1,400 1,615 2,050 200 21500 It 2,500 2,500 1001 360 Repair 6 Maintenance Sery 115 288 25 15,000 O% 15,000 15400 100% 367 Water/Sewer Lines Repair 28,937 25,504 29,497 33,865 50,000 68% 50,000 50,000 loot 368 Curb. Box Repair/Replace 9,952 111800 71952 16,234 25,000 651 25,000 25,000 100% 370 Travel 1,530 2,797 531 842 3,000 281 31000 3,000 100% 380 Training Services 5,117 1,352 1,936 -320 5,000 -61 5,000 5,000 100% 397 Contracted Services 1,197 30,482 59,076 1.671 2,000 84% 101000 10,000 5001 Increased by $8,000 per Public Works Director request 452 Gravel and Sand 2,235 2,958 71000 Ot 7,000 7,000 3001 511 Insurance on Bldgs/Imprvm 5,259 5,545 5,772 6,320 6,350 100% 6,350 6,350 100% 513 Liability 4,324 5,858 7,533 61959 6,960 100% 6,960 6,960 1001 514 Vehicle/Equipment Insuran 588 658 1 701 738 740 100% 740 740 100% -51- 06/29/21 CITY OF LAUREL 17:05:29 Expanditure Budget by Org Report -- Multiyear Actuals For the Year: 2021 - 2022 540 WATER SYSTEM Currant % Frail.. ---------------- Actuals --------------- Budget Exp, Budget Account Object 11-18 18-19 19-20 20-21 20-21 20-21 21-22 -------------------------------- ------------------ ---------- --------- ---------- ---- ---------- 530 Rent 181,889 181,889 L81,889 166,732 182,000 92% 182,000 532 Land Rental/Easements 6,752 11,145 11,642 5,470 11,800 46% 11,800 533 Machinery b Eqipment Rent 1,000 at 1,000 540 Special Assessments 4,259 4,500 0% 4,500 543 Service Connection Fee 51506 51606 51606 5,594 6,000 93% 6,000 811 Liability Deductibles 1,285 0 •••% 901 MISC CAPITAL PROJECTS 447 0 ...% 1,000,000 Waterline valve replacement Waterline replacement In conjunction with street projects 938 Replace Water/Sewer Line 217,188 0 ...% 1,200,000 Yellowstone Waterline Crossing - $300,000 5th Ave Waterline Reroute - $900,000 945 Backhoe 165,500 150,000 110% 949 Jet Hodder 25,000 0% 75,000 251 of the Purchase of new Jet Redder - $300,000 962 Utility Map Upgrade 140 0 •••% Account: 563,449 575,057 607,148 905,354 894,406 101% 3,031,985 430551 Murray Heights Subdivision - Booster Station 220 Operating Supplies 42 56 1,000 6% 1,000 233 Machinery a Equipment Par 1,045 340 1,000 0% 11000, 241 consumable Tools 500 0% 500, 341 Electric Utility Services 8,398 8,521 7,627 8,642 10,000 86% 10,000 344 Gas Utility Service 353 377 210 251 1,200 21% 11200 360 Repair c Maintenance Sere 11186 1,385 1,984 3,646 5,000 73% 5,000 . 366 Building Maintenance 412 767 5,000 151 51000 Account: 9,937 11,370 10,573 13,362 23,700 56% 23,700 430552 Water Reservoir 0% 500 500 220 Operating Supplies 800 0% 800 341 Electric Utility Services 932 917 99'. 364 Water/Sever Struct. 6 Ego 100% 5,552 3,89`. 452 Gravel and Sand 1,170 100% 340 1,000 Increased by $2,500 per Public Works Director request 1,000 920 Buildings 13,800 50% 13,800 0 13,800 Payments to Osseo and RLJ for painting of the reservior Retaining wall repairs, and maintenance Account: 2,102 977 4,890 430553 Elena Booster Station 220 Operating Supplies . 231 Gas, Oil, Diesel Fuel, Or 233 Machinery 6 Equipment Par 533 340 341 Electric Utility Services 4,374 5,231 5,047 350 Professional Services 565 818 554 Account: 4,939 61582 5,941 -52- 15 500 3% 500 948 1,400 68% 1,400 10,000 Ot 10,000 0 0% 2,500 17,447 1,380,000 1% 300,000 18,410 1,391,900 1% 314,400 Page: 2 of 3 Report L0: 0240A1 Budget Final % Old Changes Budget Budget 21-22 21-22 21-22 --------- ---------- ------ 182,000 100% 11,800 100% ,000 100% 4,500 100% 6,000 1001 0 0% 110001061 •••••t 1,200,000 •••••t 0 0% 75,000 300% 0 0% 0 3,031,985 338% 1,000 100% 1,000 1001 500 100% 10,000 100% L, 200 100% 5,000 100% 5,000 100% 0 23,700 100% 50D 1001 1,400 100% 10,000 100% 2,501 •••••1 300,000 22% 0 314,400 22% 500 0% 500 500 100% 800 0% 800 800 100% 964 2,500 39% 2,500 2,500 100% 5,552 9,000 62% 9,000 9,000 100% 340 1,000 34%, 11000 1,000 100% 6,856 13,800 50% 13,800 0 13,800 100% 08/29/21 CITY OF LAUREL 17:05:29 Expenditure Budget by Org Report - MultiYear Actuals For the Year: 2021 - 2022 540 WATER SYSTEM Current % Prelim. -------------^-- Actuala---- ----------- Budget Exp. Budget Account Object 17-18 16-19 19-20 20-21 20-21 20-2.1 21-22 --------------- ---------- -------------------- -------------------- ---- ---------- 490000 Debt Service 610 Principal 83,000 83,000 loot 85,000 Principal payment on Intake Loan 620 Interest 42,500 42,500 42,000 39,988 39,988 1001 37,900 Interest payment for Intake Loan Account: 42,500 42,500 42,000 122,988 122,988 1001 122,900 Fund: 622,940 636,486 670,552 1,066,970 2,446,794 44% 3,506,785 Orgn: 622,940 636,486 670,552 1,066,970 2,446,794 44% 3,506,785 Grand Total: 622,940 636,486 670,552 1,066,970 2,446,794 3,506,785 -53- Page: 3 of 3 Report I0: B240A1 Budget Final % Old Changes Budget Budget 21-22 21-22 21-22 _ 85,000 102% 31,900 95% 0 122,900 99% 0 3,506,785 143% 0 3,506,785 143% 0 3,506,785 08/28/21 CITY OF LAUREL Page: I of l 18:32:32 Expenditure Budget by Org Report -- MultiYear Actuals Report I0: B240AI For the Year: 2021 - 2022 900 TRANSFER Current 1 Prelim. Budget Final t Old ---------------- Actuals ----------- Budget Exp. Budget Changes Budget Budget Account Object I7-18 I8-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 ------------------------------------------------------------------------------- ---------------------------------- ------ 5210 WAIER 430500 Water Utilities 392 Administrative services 111.286 111,286 120,879 110,806 120,880 921 120,979 120,819 1001 Account: 111,286 111,286 120,879 110,806 120.880 924 120,879 0 120,879 991 521000 Interfund Operating Transfers Out 820 Transfers to Other Funds 51000 5,000 5,000 4,583 5,000 926 5,000 51000 1001 Account: 5,000 5.000 5,000 4,583 5,000 921 5,000 0 51000 1009 Fund: 116.286 116,286 125,879 115,389 125.880 921 125,819 0 125.879 991 Orgn: 116,286 116.286 125,879 115,389 125,880 921 125,819 0 125.879 99t Grand Total: 116,286 116,286 125,879 115,389 125,880 125,879 0 125,879 -54- -55- 08/29/21 CITY OF LAUREL Page: 1 of 1 18:41:08 Revenue Budget Report -- Multiyear Actuals Report ID: B250B For the Year: 2021 - 2022 Current % Prelim. Budget Final % Old --------- ------ Actuals ----------------- Budget Has. Budget Change Budget Budget Account ._..-------------------------„__ 17-18 __________ 18-19 __________ 19-20 ---------- 20-21 ------ ---- 20-21 _-------- 20-21 ____ 21-22 ---------- 21-22 ---------- 21-22 ---------- 21-22 ------ 5310 SEWER 330000 INTERGOVERNMENTAL REVENUES 331100 Flood Control Grant 869 0 ...1 0 0% Group: 869 0 •"! 0 0 0 0% 340000 CHARGES FOR SERVICES 343031 Sewer Charges 1,558,048 1,554,200 1,560,642 1,587,354 1,550,645 102% 1,550,645 1,550,645 1004 343033 System DeVlpmt Fee 18,780 48,570 17,580 16,930 17,500 97% 16,500 16,500 94% 343034 Treatment Facilities 369,370 371,830 379,830 383,399 379,850 101% 379,850 379,850 100% 343036 Miscellaneous Sewer 28,441 22,505 33,044 47,760 25,000 191% 25,000 25.000 100% Group: 1,974,639 1,997,105 1,991,096 2,035,443 1,972,995 103% 1,971,995 0 1,971,995 99% 360000 Miscellaneous Revenue 363040 Penalty a Interest 8 8 10 13 0 ...% 10 10 •••''% Group: 8 8 10 13 0 •'•e 10 0 30 •••••% 370000 investment and Royalty Earnings 371010 Investment Earnings 3,470 5,238 2,839 325 2,500 13% 300 300 12% 371011 System Devel. Int. 2,966 4,992 3,684 508 2,000 25% 500 500 254 371013 Bend Sinking Int. 2,396 708 6B6 91 250 361 50 50 201 371015 DNRC Bona Sinking Inc. 3,121 51679 4,969 651 2,000 33% 500 500 25% 371016 Capital Int/Yearly Replac 14,335 27,891 15,888 2,219 5,000 44% 2,000 21000 40% 373060 TIFD Interest 1,242 0 0% 0 0% Group: 27,530 45,508 28,066 3,794 11,750 32% 3,350 0 3,350 28% 380000 Other Financing Sources 382010 Sale of Fixed Asset 2,500 0 O% 0 Be Group: 2,500 0 0% 0 0 0 0% Fund: 2,002,177 2,045,121 2,019,172 2,040,119 1,984,745 103% 1,975,355 0 1,975,355 99% Grand Total: 2,002,177 2,045,121 2,019,172 2,040,119 1,984,745 1,975,355 0 1,975,355 -56- 010-1141�11 -11 A."MM00,31 M), �i INA 08/29/21 CITY OF LAUREL Page: I of 2 18:34:12 Expenditure Budget by Org Report -- MultiYeer Actuals Report 1D: B240A1 For the Year; 2021 - 2022 600 SEWER PLANT Current 1 Prollm. Budget Final 1 Old ---------------- ACLual9 ----------------- Budget Exp. Budget Changes Budget Budget Account Object ------------------------------------------ 17-18 18-19 ---------- 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 5310 SEWER -------- ------------ ---------- ---- ---------- ---------- ---------- --_...-- 430640 Treatment and Disposal 110 Salaries and Wages 282,222 258,260 271,779 271,043 299,000 912 300,000 300,000 1001 111 Overtime 5,672 12.,852 8,731 7,895 11,152 71% 11,152 11,152 1001 138 Vision Insurance 190 176 291 298 320 931 250 250 781 139 Dental Insurance 1,375 1,409 1,826 1,528 2,120 72E 2,300 2,300 1088 141. Unemployment Insurance 720 935 423 697 470 1481 1,060 1,060 226E 142 Workers' Compensation 12,443 12,334 14,775 12,205 1,430 8531 3,850 3,850 269E 143 Health Insurance 50,762 41,454 53,921 50,549 55,800 911 55,950 55,950 100E 144 Life Insurance 366 311 352 331 410 811 370 370 901 145 FICA 21,013 19,782 21,086 20,991 23,900 889 23,115 23,115 971 146 PERS 50,227 5,254 24,327 24,390 26,900 911 26,810 26,810 100E 148 ICMA Retirement 221 0 0E 0 01 194 Flex Medical 2,083 2,870 1,514 2,870 OE 3,265 3,265 114E 220 Operating Supplies 5,769 7,261 9,176 13,139 10,000 131E 15,000 15,000 150E rncressed by $5,000 per Public Works Director request 221 Chemicals 51085 9,437 20,700 28,257 25,000 113E 35,000 35,000 140E Increased by $10,000 per Public Works Director request 222 Laboratory a Medical Supp 91951 10,594 10,127 8,353 14,000 608 14,000 14,000 100E 226 Clothing and Uniforms 214 112 72 765 800 961 800 800 100E 231 Gas, 011, Diesel Fuel, Gr 2,657 3,306 21313 5,486 9,000 619 91000 9,000 100E 232 Motor Vehicle Parts 28 163 125 686 800 869 1,500 11500 1881 Increased by 8700 per Public Works Director request 233 Machinery 6 Equipment Par 19,366 9,993 10,316 24,883 50,000 So% 50,000 50,000 1009 241 Consumable Tools 130 44 86 11096 500 219E 1,500 1,500 3001 Increased by $1,000 per Public Works Director request 263 Safety Supplies 388 258 626 1,448 4,000 369 4,000 4,000 1001 300 Purchased Services 225 220 154 2,000 01 2,000 21000 loot 312 Networking Fees 524 2,087 3,135 2,100 1499 5,000 5,000 238E rncreased by 52,900 per Public Works Director request 337 Advertising 11000 0E 11000 11000 100E 339 Certification Renewal 252 422 252 252 800 321 800 800 1001 341 Electric Utility Services 67,480 70,615 70,582 75,320 90,000 841 100,000 100,000 111E Increased by 810,000 per Public Works Director request 343 Cellular Telephone 66 62 405 251 600 421 600 600 100E 344 Gas Utility Service 14,301 13,519 14,530 16,813 20,000 84E 20,000 20,000 100E 345 Telephone 2,617 21912 3,121 1,599 3,500 461 3,500 3,500 100E 349 Quality Testing 6,311 9,710 13,506 7,112 20,000 361 20,000 20,000 100E 350 Professional Services 2,775 1,874 750 5,456 10,000 551 10,000 10,000 100E 351 Medical, Dental, Veterina 125 310 260 633 400 158E 500 500 125E Increasetl by $100 per Public Works Director request 355 Data Processing Services 33 61000 01 6,000 6,000 100E 360 Repair c Maintenance Sery 2,216 6,411 2,967 364 10,000 41 10,000 10,000 1001 364 Water/Sewer Struct. a Equ 5,417 14,066 13,950 27,654 50,000 55E 50,000 50,000 100E 366 Building Maintenance 537 562 1,180 5,516 10,000 55E 50,000 50,000 500E Increasetl by 840,000 per Public Works Director request 370 Travel 353 972 1,203 531 5,000 111 5,000 51000 100E 380 Training Services 2,771 351 546 456 51000 99 5,000 51000 1001 i D8/29/21 CITY OF LAUREL Page: 2 of 2 18:34:12 Expenditure Budget by Org Report -- MultiYear Actuals Report ID: B240A1 For the Year: 2021 - 2022 600 SEWER PLANT Current % Prelim. Budget Final B Old ---------------- Actuals ----------------- Budget Exp. Budget Changos Budget Budget Account Object ---"---------------------------- 17-18 ---------- 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 391 Dumping Fees 2,424 ---------- 12,944 -------------------- 23,518 18,423 ---------- 25,000 ---- 74% ---------- 30,000 ---------- ---------- 30,000 ------ L20% Increased by $5,000 per Public Works Director request 397 Contracted Services 472 1,249 1,016 4,839 11700 2851 51000 5,000 294% Increased by $3,300 per Public Works Director request 511 Insurance on Bldgs/Imprvm 3,244 3,420 3,560 3,898 31900 100% 3,900 31900 100% 513 Liability 7,252 9,824 12,632 11,670 11,670 1001 11,670 11,670 1001 514 Vehicle/Equipment Insuran 119 133 142 149 150 99% 150 150 100E 533 Machinery 6 Eqipment Rent 69 0 0% 0 0% 544 Discharge Permit Fee 4,357 8,595 8,036 81511 8,800 97% 8,800 8,800 100% 901 MISC CAPITAL PROJECTS 0 01 235,000 235,000 .....t Screw Pump B Replacement 940 Machinery 6 Equipment 20,054 20,000 100% 260,000 260,000 1300% New Skid Steer - $60,000 New Roll Off Truck - $200,000 946 Computer Eq/Software 0 0% 760,000 760,000 ^"'1 Wonderware Upgrade - $60,000 Upgrade Seven 171 Programable Logic Controllers - 8700,000 Account: 594,265 555,535 627,069 686,678 846,092 81% 2,162,842 0 2,162,842 255% 490000 Debt Service 620 Interest 124 51 0 01 0 01 Account: 124 51 0 "•1 0 0 0 0% 510400 Depreciation 830 Deprec-Closed to Retained 504,050 507,013 565,200 555,715 01 575,000 575,000 103% Account: 504,050 507,013 565,200 555,715 0% 575,000 0 575,000 103% Fund: 1,098,439 1,062,599 1,192,269 686,678 1,401,807 49% 2,737,842 0 2,737,842 195% Orqn: 1,098,439 1,062,599 1,192,269 686,678 1,401,807 49% 2,737,842 0 2,737,842 195% Grand Total: 1,098,439 1,062,599 1,192,269 686,678 1,401,807 2,737,842 0 2,737,842 59- 08/29/21 CITY OF LAUREL page: 1 Of 3 18;35:09 Expenditure Budget by Oro Report -- Multilear Actuals Report I0: 8240A1 For the Year: 2021 - 2022 630 SEWER SYSTEM Current % Prelim. Budget Final 1 Old ---------------- Actuals ---- ------ Budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-18 ---------- 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 5310 SEWER ---------- -------------------- -----"'---- ---- ---------- ---------- ---------- ------ 430630 Collection 6 Transmission 110 Salaries and Wages 102,407 114,003 97,540 92,661 104,700 89% 11G,850 116,850 1121 111 Overtime 962 586 489 1,024 6,074 11% 6,075 6,075 100% 138 Vision Insurance 76 86 150 116 170 68% 120 120 71% 139 Dental Insurance 947 929 952 688 11115 62% 890 890 80t 141 Unemployment Insurance 250 351 157 234 170 138% 435 435 256% 142 Workers' Compensation 4,899 5,518 5,704 4,106 6,300 651 4,800 4,800 76% 143 Health Insurance 17,580 16,388 17,555 17,487 19,200 91% 23,160 23,160 121% 144 Life Insurance 139 137 132 120 152 79% I55 155 102% 145 FICA 7,596 7,603 7,962 71090 8,530 83% 9,405 9,405 110% 146 PERS 8,343 81550 9,043 8,184 9,610 85% 10,905 10,905 113% 194 Flex MedicaL 668 874 677 1.165 0% 1,330 1,330 114% 220 Operating Supplies 570 2,216 2,455 11809 5,000 36% 51000 51000 100% 221 Chemicals 491 2,000 0% 2,000 21000 100% 226 Clothing and Uniforms 174 500 351 500 500 100% 230 Repair 6 Maintenance Supp 554 340 2,450 2,000 123% 3,000 3,000 150% Increased by $1,000 per Public Works Director request 231 Gas, Oil, Diesel Fuel, Or 5,104 61596 3,884 3,145 71000 45% 7,000 7,000 100% 232 Motor Vehicle Parts 336 39 96 21500 01 21500 2,500 100% 233 Machinery a Equipment Par 7,820 9,679 5,467 2,237 7,000 32% 7,000 7,000 100% 239 Tires/Tubes/Chains 17 250 3,000 O% 3,000 3,000 100% 241 Consumable Tools 728 1,000 73% 1.000 1,000 loot 263 Safety Supplies 636 1,087 2,000 0% 2.,000 21000 loot 311 Postage 3,143 3,039 3,083 3,121 4.000 78% 4,000 4,000 100% 337 Advertising 1,000 O% 1,000 1,000 1001 339 Certification Renewal 800 O% 800 800 IOD% 343 Cellular Telephone 119 568 400 600 67% 600 600 100% 350 Professional Services 41968 2.222 3,687 22,615 30,000 75% 30,000 30,000 100% 351 Medical. Dental. Veterina 56 500 O% 500 500 100% 355 Data Processing Services 11000 0% 11000 1,000 1001 364 Water/Sewer Street. 6 Equ 10,462 23,534 25,644 148 1001000 O% 100,000 100,000 loot 367 Water/Sewer Lines Repair 6,315 197 940 30,000 Ot 30,000 30,000 100% 370 Travel 10 416 3,000 0% 3,000 3,000 100% 380 Training Services 104 351 84 1,000 at 1,000 1,000 100% 397 Contracted Services 1,093 1,166 2,271 1,451 1, 50D 97% 1,500 1,500 1001 511 Insurance on Bldgs/Imprvm 123 130 135 148 150 99% 150 150 100% 513 Liability 2,463 3,337 4,291 3,964 41000 99% 4,000 4,000 100% 514 Vehicle/Equipment Iateran 1,172 1,312 1,398 1,472 1,475 100% 1,475 1,475 t00% 530 Rent 178,284 178,284 178,284 163,427 178,284 92% 178,284 178,284 100% 532 Land Rental/Easements 399 420 444 370 500 74% 500 500 1001 533 Machinery 6 Eqipment Rent 500 0 0% 0 0% 811 Liability Deductibles 4,000 Ot 4,000 4,000 100% 901 MISC CAPITAL PROJECTS 447 0 ^`1 0 O% 938 Replace Water/Sewer Line 25,808 0 ...% 175,000 175,000 .....% Lindy Lane Sewer Line replacement 940 Machinery 6 Equipment 71,900 0 0% 0 0% 949 Jet Redder 0 O% 225,000 225,000 .....% 75% of new Jet Rudder purchase M 08/29/21 CITY OF LAUREL Page: 2 of 3 18:35:09 Expenditure Budget by Org Report -- MultlYear Actuals Report to: B24OAl For the Year: 2021 - 2022 630 SEWER SYSTEM Current % Prelim. Budget Final t Old --------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object ------------------------------- 17-18 18-19 19-20 2D-21 20-21 20-21 21-22 21-22 21-22 21-22 962 Utility Map Upgrade ---------- ---------- ---------- ---------- 140 ---------- 0 ---- •••% ---------- ---------- --------- 0 ------ 0% Account: 368,330 460,092 374,752 365,848 550,995 66% 968,934 0 968.934 175% 430631 Elm Lift Station 220 Operating Supplies i5 50D at 500 500 100% 221 Chemicals 4,925 2,000 Ot 2,000 2.000 100% 231 Gas, 011, Diesel Fuel, Gr 603 621 621 1,500 at 11500 11500 loot 233 Machinery 6 Equipment Par 742 340 7,155 1,049 11000 105% 1.000 11000 100% 341 Electric Utility Services 2,688 3,001 3,426 3,719 5,000 74% 5,000 51000 100% 345 Telephone 531 -18 0 O1 0 OE 360 Repair c Maintenance Sery 61068 1,000 607% 1,000 11000 300% 364 Water/Sewer Struct. a Equ 7,171 892 2,728 19.848 40,000 50% 40,000 40,000 100% M2S Remediation Improvements Account: 11,735 4,836 18,870 30,684 51,000 601 51,000 D 51.000 1001 430632 Village Lift Station 220 Operating Supplies 70 500 0% 500 500 100% 221 Chemicals 6 10,000 0% 10,000 10,000 100% 231 Gas, Oil, Diesel Fuel, Gr 348 450 500 0% 500 500 100% 233 Machinery a Equipment Par 2.294 2.374 1,417 11109 2,500 44% 2,500 2,500 1001 341 Electric Utility Services 1,867 11780 2,221 2,461 5,000 49% 5,000 5.000 100% 344 Gas Utility Service 184 201 205 -397 11000 -40% 11000 1,000 loot 345 Telephone 564 573 643 676 800 85% 800 800 100E 360 Repair 6 Maintenance Sery 430 1.000 43% 1,000 1,000 loot 364 Water/Sever Struct. a Equ 3,681 2,750 430 715 8,000 9% 8.000 8.000 100% 930 Improvements Other than 8 5.990 1.150.000 1% 0 0% Account: 91008 1,618 5,372 10,984 1.179,300 11 29,300 0 29,300 2% 430633 Walmart Lift Station 220 Operating Supplies 500 0% 500 500 100% 221 Chemicals 800 0% 800 800 100% 231 Gas, 011, Diesel Fuel, Gr 584 892 547 1,500 D% 11500 1,500 100% 233 Machinery a Equipment Par 340 340 529 910 1,000 91% 1,000 11000 100% 341 Electric Utility Services 843 832 839 783 1,500 52% 1,500 11500 100% 360 Repair a Maintenance Sery 340 1,000 34% 1,000 11000 100% 364 Water/Sewer Struct. a Equ 194 156 11000 0% 1,000 11000 1001 Account: 1.767 2,258 2,071 2,033 7,300 281 7,300 0 7,300 100% 490000 Debt Service 610 Principal 526,000 368,000 1431 362,000 362.000 98% Principal Payments for: SRF - 11265 $40,000 SRF - 06143 583,000 SRF - 14330 $179,000 SRF - 15360 $60,000 620 interest 200,009 190,489 180,930 170,976 171,066 100% 159,791 159,791 931 Interest payments for: SRF - 11265 $11,820 SRF - 06143 $7,256.25 SRF - 14330'875,015 SRF - 15360 $65,700 -61- 08/29/21 CITY OF LAUREL Page: 3 of 3 18:35:09 Expenditure Budget by Org Report -- Multiyear Actuals Rapers 1b: B240A1 Far the Year: 2021 - 2022 630 SEWER SYSTEM Current 4 Prelim. Budget Final 1 Did ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object 17-18 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 ------------------------------------------------------------------------------- ---------------------------------- ------ Account: 200,009 190,489 180,930 696,976 539,066 1294 521.791 0 521,791 961 Fund: 590,849 665,353 581,995 1,106,525 2,327,661 481 1,578,325 0 1,578,325 671 Orgn: 590,849 665,353 581,995 1,106,525 2,327,661 481 1,578,325 0 1,578,325 674 Grand Total: 590,849 665,353 581,995 1,106,525 2,327,661 1,578,325 0 1,578,325 -62- 08/29/21 CITY OF LAUREL page: l of I 18:36:09 Expenditure Budget by Org Report -- MultlYear Actuals Report 10: B240A1 For the Year: 2021 - 2022 900 TRANSFER Current 1 Prelim. Budget Final 1 Old ----------- ---Actuals ----------- ----- Budgat Exp, Budget Changes Budget Budget Account Object 17-18 18-19 19-20 2U-21 20-21 20-21 21-22 21-22 21-22 21-22 ________________________________ __m-_----- ---------- _.__------ ------ --- ---------- _------------- ---------- _-------- ------ 5310 SEWER 430600 Sower Utilities 392 Administrative Services 77,274 77,274 76,464 70,092 76.465 928 76.465 76,465 1001 Account: 77,274 77,274 76,464 70,092 76,465 921 76.465 0 76,465 100% 521000 Interfund Operating Transfers Out 820 Transfers to Other Funds 5,000 51000 51000 4,583 51000 928 5,000 51000 1001 Account: 5.000 5,000 5,000 4,583 5,000 925 5,000 0 51000 1001 Fund: 82,274 82,274 81,464 74,675 81,465 921 81,465 0 81.465 1008 Orgn: 82,274 82,274 81,464 74,675 81,465 921 81.465 0 81,465 1009 Grand Total: 82,274 82,274 81.464 74,675 81,465 81,465 0 81,465 63- AI � r 1 � � 1. ��1 08/29/21 CITY OF LAUREL Page: 1 of 1 18:43:25 Revenue Budget Report -- MultlYear Actuate Report t0: B250B For the Year: 2021 - 2022 Currant B Prelim. Budget Final % Old ---------------- Actuate ----------------- Budget Red. Budget Change Budget Budget Account ------------- .------------------ 17-10 ---------- 18-19 ------------- 19-20 ------ --------- 20-21 ' 20-21 ---------- 20-21 "--- 21-22 ---------- 21-22 ---------- 21-22 -------- -- 21-22 ----- 5410 SOLID WASTE 330000 INTERGOVERNMENTAL REVENUES 331100 Flood Control Grant 910 0 "•% 0 08 Group: 910 0 •••1 0 0 0 0% 340000 CHARGES FOR SERVICES 343041 Garbage Collection 806,101 815,226 847,675 837,155 845,000 99% 825,000 825,000 97% 343044 Container Site Rev/Dump 25,045 23,450 19,890 21,749 20,000 109% 20,000 20,000 100% 343045 Container Hauling Fee 29,157 40,251 31,564 37,300 25,000 1491 25,000 25,000 1001 343046 Mlsc Garbage Revenues 2 10 157 2,373 25 •••1 25 25 100% Group: 860,375 878,937 899,286 898,577 890,025 101% 870,025 0 870,025 97% 370000 Investment and Royalty Earnings 371010 Investment Earnings 5,625 8,224 6,944 974 2,500 39% 950 950 38% 373051 Principle on FAP Loan 22,691 22,500 101% 11,345 11,345 50% 373061 Interest on FAP Loan 3,616 2,765 1,915 1,064 2,500 43% 213 213 8% Group: 9,241 10,989 81859 24,729 27,500 90% 12,508 0 12,508 45% Fund: 869,616 889,926 908,145 924,216 917,525 101% 882,533 0 882,533 96% Grand Total: 869,616 889,926 908,145 924,216 917,525 882,533 0 882,533 -65- � �•� ud.�� a �� t ' %� �� ' � � � { / � � ice' 08/29/21 CITY OF LAUREL Page: 1 of 3 19:54:14 Expenditure Budget by Org Report -- Multiyear Actuals Report 1D: 3240A1 For the Year: 2D21 - 2022 700 SOLID WASTE Current 1 Prelim. Butlget Final \ Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-18 18-19 19-20 20-21 20-21 20-21 21-22 21-22 21-22 21-22 5410 SOLID WASTE ---------- ---------- ---------- ---------- ---------- ---- ---------- ---------- ---------- ------ 430830 Collection 110 Salaries and Wages 187,680 202,936 175.561 184,522 208,000 89% 200,310 200,310 96% III Overtime 1,539 2,637 681 3,294 4,000 82% 4,000 4, DOD 100% 138 Vision Insurance 162 173 192 278 250 111% 230 230 92% 139 Dental Insurance 11495 11514 1,547 1,654 1,800 92% 2,135 2,135 119% 141 Unemployment Insurance 471 697 265 469 350 134% 720 720 206% 142 Workers' Compensation 10,249 12,178 10,683 9,587 13,500 711 8,530 81530 63t 143 Health Insurance 36,796 46,766 -53 35,978 42,700 84% 40,800 40,800 96% 144 Life Insurance 261 268 235 248 310 80% 280 280 90% 145 FICA 13.973 14,793 13,233 14,252 16,500 86% 15,630 15,530 95% 146 PERS 62,458 36,131 15,315 16,360 19.000 86% 18,130 18,130 951 148 ICHA Retirement 88 0 0% 0 0% 194 Flex McdicaL 974 1,664 1,189 2,330 01 2,445 2,445 105% 220 operating Supplies 4,074 51921 3,228 3,661 8,000 46% 81000 8,000 100% 225 Clothing and Uniforms 224 1,119 1,000 1121 1,200 1,200 120% Increased by 5200 due to boot program 228 Solid Waste Containers 21,389 18,363 19,125 25,871 30,000 86% 30, DOB 30,000 100% 231 Gas, Oil, Diesel Fuel, Gr 37,381 39,767 36,172 36,378 55,000 66% 55,000 55,000 100% 233 Machinery a Equipment Par 15,463 16,658 24,568 32,737 20,000 164% 30,000 30,000 1501 Increased by 510,000 237 Basin Repairs 61 0 0E 0 0% 239 Tires/Tubes/Chains 7,453 4,034 8,043 13,996 10,000 140t 10,000 10,000 1001 263 Safety Supplies 195 2,500 01 2,500 2,500 1001 311 Postage 3,143 3,039 3,028 3,121 4,000 78% 4,000 4,000 toot 312 Networking Fees 524 2,087 2,661 3,000 89% 3.000 3,000 1001 332 Internet Access Fees 225 220 154 300 Ot 300 300 100% 337 Advertising 125 530 1,422 1,000 142% 11000 1,000 1001 343 Cellular Telephone 1.978 1,963 568 401 2,000 20% 2,000 2,000 100% 350 Professional Services 1.000 100 890 11000 89% 1.000 1,000 1001 351 Medical, Dental, Veterina 410 445 385 929 400 2321 400 40D 100% 355 Data Processing Services 191 1.500 Ot 11500 11500 100% 361 Motor Vehicle Repair 6 Me 4,499 10,767 16,667 26,725 20,000 134% 30,000 30,000 150% Increased by 810,000 366 Building Maintenance 0 Ot 25,000 25,000 ...-% Work to be done at the Container Site 397 Contracted Services 999 11055 1,193 1,752 1,500 117% 2,000 2,000 133% Increased by $1,000 511 Insurance on Bldgs/Imprvm 0 01 58 58 •••••\ 513 Liability 4,117 5,577 1,171 6,625 6,625 100% 6,625 6.625 lull% 514 Vehicle/Equipment Insuran 4,127. 4,622 4,923 5,185 5,190 100% 5,190 5,190 100% Oil Liability Deductibles 5,384 0 01 0 0% Account: 428,264 433,132 346, 69D 430,115 481,755 89% 511,983 0 511,983 106% 430840 Disposal 110 Salaries and Wages 112,302 118,423 88,046 88,185 124,500 71% 88,825 88,825 71% III Overtime 1,268 2,345 326 2,961 4,000 74% 41000 4,000 X00% 138 Vision Insurance 101 109 97 148 150 99% 130 130 87% -67- 08/29/21 CITY OF LAUREL Page: 2 of 3 19t54t14 Expenditure Budget by Org Report -- MultlYear Actuals Report 1D: B240Al For the Year: 2021 - 2022 700 SOLID WASTE Currant % Prelim, Budget Final t Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budget Budget Account Object -------------------------------- 17-18 ---------- 18-19 ---------- 19-20 20-21 20-21 20-21 21-22 21-2.2 21-22 21-22 139 Dental Insurance 794 826 ---------- 716 ---------- 873 ---------- 970 ---- 90% ---------- 995 ---------- --------- 995 ------ 1031 141 Unemployment Insurance 284 418 133 228 200 114% 325 325 163% 142 Workers' Compensation 6,715 8,032 5.559 4,999 9,000 56% 3,915 3,915 44% 143 Health Insurance 2.2,909 22,690 161885 16,626 26,500 63% 17,100 17, too 65% 144 Life Insurance 157 161 115 113 190 591 120 120 63% 145 FICA 8,295 8,812 6,569 6,935 9,900 70% 7,115 7, t15 72% 146 PERS 9,395 9,945 7,747 7,920 11,2UU '11% 8,240 8,240 74% 194 Flex Medical. 581 1,114 1,003 11410 0% 1,025 1,025 73% 220 Operating Supplies 2,270 4,405 31109 5,840 3,000 195% 4,500 4,500 150% Increased by $1,500 231 Gas, Oil, Diesel Fuel. Gr 11,263 13,628 12,795 12,656 20,000 63% 20,000 20,000 100% 233 Machinery 6 Equipment Par 11,667 4,448 12,570 15,523 20.000 78% 20,000 20,000 100% 239 Tires/Tubes/Chains 1,701 3.159 3,427 260 6.000 4% 6,000 6,000 100% 263 Safety Supplies 2,50D 01 2.500 2,500 100% 340 Utility Services 139 0 O% 0 0% 341 Electric Utility Services 11188 11199 1,536 1.451 11800 Bit 1,800 1.800 100% 343 Cellular Telephone 262 159 31 600 at 600 600 loot 350 Professional Services 890 0 •••% 0 0% 351 Medical, Dental, Veterina 500 O% 500 500 100% 361 Motor Vehicle Repair a Ma 11289 168 5,000 31 5,000 5.000 loot 391 Dumping Fees 169,004 154,028 179,996 204,945 200,000 102% 250,000 250, ODD 125% Increased by 850,000 513 Liability 2,542 3,443 4,428 4,090 4,100 100% 4,100 4,100 1001 934 Containers 17,000 O% 17,000 17, DOD 100% New Rolloff Container 943 Vehicle(s) 60,000 0% 0 0% Account: 362.837 357,344 346,377 374.811 528,520 71% 463,790 0 463,790 871 490000 Debt Service 610 Principal 0 O% 41,152 41,152 •••••% Payments for new garbage truck 620 Interest 0 0% 4,620 4,620 .....% Interest on new garbage truck Account: 0 •••t 45,772 0 45,772 •••••% 510400 Depreciation 830 Deprec-Closed to Retained 55,642 78,525 55.187 65,000 0% 70, DOD 70,000 108% Account: 55,642 78,525 55,187 65,000 01 70,000 0 70,000 107% Fundt 846,743 869.001 748,254 804,926 1,075,275 75% 1,091,545 0 1,091,545 101%. Orgn: 846,743 869,001 74B, 254 804,926 1,075.275 75% 1,091,545 0 1,091,545 101% OB/29/21 CITY OF LAUREL Page: 3 of 3 19:54:14 Expenditure Budget by Org Report -- MultlYear Actuals Report 10: B240A1 For the Year: 2021 - 2022 900 TRANSFER Current 1 Prelim. Budget Final t Old ---------------- Actuals ----------------- Budget Exp. Budget Changes Budgot Budgat Account Object 17-18 18-19 19-20 20-21 20-21 20-21 2L-22 2L-22 21-22 21-22 --------------------------------------------------------------------------------- -------------------------------- ------ 5410 SOLID WASTE 410800 Solid Waste Services 392 Administrative Services 51,612 51,612 59,583 54,618 59,503 921 59.583 59,583 100% Account: 51,612 51,612 59,583 54,618 59,583 92% 59,583 0 59,583 300% 521000 Interfund Operating Transfers Out 820 Transfers to Other Funds 5,000 51000 5,000 4,583 51000 921 51000 5,000 toot Account: 5,000 5,000 5,000 4,583 5.000 92% 5,000 0 5,000 100% Fund: 56,612 56,612 64,583 59.201 64,583 921 64,583 0 64,583 100% Orgn: 56,612 56.612 64,583 59,201 64,583 921 64,583 0 64,563 100% Grand Total: 903,355 925,613 812,837 864,127 1,139,858 I.156,128 0 1,156,128