Cities Index.
Exp Summary 12.31.21 - General Fund

Corona City Council
February 2, 2022

Document
Exp Summary 12.31.21 - General Fund
Meeting
February 2, 2022
Body
Corona City Council
Original file
21.6 MB
Text extracted from the city's file for reading and search. Open the original on corona.legistar1.com. That file is the official record.

Ledger: GL CONSOLIDATED EXPENDITURE REPORT-BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD : Encumbrances (Over)/Under Used
110 GENERAL FUND
00 NOT APPLICABLE

SALARIES-BENEFITS
41110 CONTRACTUAL OBLIGATION 0.00 0.00 110.25 0.00 ((110.25) 0.00 41300 OVERTIME 0.00 61.37 2,420.31 0.00 (2,420.31) 0.00 41920 MEDICARE 0.00 1.80 74.44 0.00 (74.44) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.03 1.28 0.00 (1.28) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 63.20 2,606.28 0.00 (2,606.28) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 20,644,430.27 0.00 0.00 0.00 20,644,430.27 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 2,175.92 5,085.02 6,751.88 (11,836.90) 0.00 42028 SCBA BREATHING APPARATUS 0.00 0.00 0.00 67,540.35 (67,540.35) 0.00 42033 CONSTRUCTION MATERIALS 0.00 0.00 409.45 0.00 (409.45) 0.00 42055 COMPUTER EQUIPMENT & 188,187.45 0.00 79.95 233,717.45 (45,609.95) 124.23 42200 ADVERTISING EXPENSE 0.00 0.00 743.93 0.00 (743.93) 0.00 42300 WIRELESS COMMUNICATION 0.00 0.00 1,218.41 0.00 (1,218.41) 0.00 42305 PBLC SFTY RADIO COMMUNICATION 26,160.00 321,578.17 349,655.08 5,582.00 (329,077.08) 1,357.93 42320 POSTAGE & SHIPPING 0.00 0.00 341.33 0.00 (341.33) 0.00 42350 PROGRAM EXPENDITURES 0.00 47,613.50 47,758.50 0.00 (47,758.50) 0.00 42700 OTHER EQUIPMENT RENTAL 335.19 0.00 0.00 335.19 0.00 100.00 42800 EQUIPMENT MAINTENANCE 1,885.81 5,052.49 5,052.49 0.00 (3,166.68) 267.92 42813 MTCE & REPAIR - EQUIP & FAC 0.00 15,337.00 48,043.00 120,277.59 (168,320.59) 0.00 42900 PROF. & CONT. SVCS 598,017.41 29,535.89 185,849.19 756,171.18 (344,002.96) 157.52 43300 CONSTRUCTION CONTRACTS 191,767.42 78,378.08 457,787.22 164,051.47 (430,071.27) 324.26 43301 CAPITAL IMPROVEMENTS 2,350.00 0.00 2,350.00 438,289.38 (438,289.38) 18,750.61 43500 BOOKS 0.00 1,455.27 2,329.26 1,923.48 (4,252.74) 0.00 43501 CHILDREN'S BOOKS 0.00 0.00 0.00 400.00 (400.00) 0.00 43727 INSPECTION 2,424.43 0.00 1,612.00 28,270.00 (27,457.57) 1,232.53 TOTAL FOR SERVICES-SUPPLIES 21,655,557.98 501,126.32 1,108,314.83 1,823,309.97 18,723,933.18 13.53

CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 146,562.50 1,591,470.61 (1,738,033.11) 0.00 45200 MACHINERY, EQUIPMENT, & FIXTUR 116,096.42 77,700.00 77,700.00 98,377.87 (59,981.45) 151.66 45400 LAND 0.00 0.00 100,000.00 0.00 (100,000.00) 0.00
TOTAL FOR CAPITAL OUTLAY 116,096.42 77,700.00 324,262.50 1,689,848.48 (1,898,014.56) 1,734.86 TOTAL FOR NOT APPLICABLE 21,771,654.40 578,889.52 1,435,183.61 3,513,158.45 16,823,312.34 22.72 10 CITY COUNCIL

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 48,000.00 4,000.00 24,000.00 0.00 24,000.00 50.00 41510 PST DEFERRED COMPENSATION 124.80 10.40 62.40 0.00 62.40 50.00 41910 PERS-NORMAL 4,373.76 364.48 2,186.88 0.00 2,186.88 50.00 User: KIMS Page: 1 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41912 PERS-UNFUNDED 14,771.00 0.00 3,819.69 0.00 10,951.31 25.85 41920 MEDICARE 2,104.18 167.01 1,001.67 0.00 1,102.51 47.60 41931 WORKERS COMP 960.00 80.00 480.00 0.00 480.00 50.00 41940 HEALTH INSURANCE 34,811.04 2,609.27 16,841.82 0.00 17,969.22 48.38 41946 LIFE INSURANCE 330.00 27.60 165.60 0.00 164.40 50.18 TOTAL FOR SALARIES-BENEFITS 105,474.78 7,258.76 48,558.06 0.00 56,916.72 46.03

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 2,000.00 0.00 512.99 0.00 1,487.01 25.64 42220 PROMOTIONAL/PUBLIC OUTREACH 3,500.00 0.00 0.00 0.00 3,500.00 0.00 42300 WIRELESS COMMUNICATION 3,500.00 486.63 2,165.68 0.00 1,334.32 61.87 42320 POSTAGE & SHIPPING 100.00 5.57 36.75 0.00 63.25 36.75 42340 OFFICE SUPPLIES 850.00 0.00 91.04 0.00 758.96 10.71 42345 FIRST AID KIT SUPPLIES 50.00 0.00 0.00 0.00 50.00 0.00 42350 PROGRAM EXPENDITURES 7,000.00 422.39 5,847.65 0.00 1,152.35 83.53 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 0.00 0.00 500.00 0.00 42800 EQUIPMENT MAINTENANCE 500.00 0.00 1,643.37 0.00 (1,143.37) 328.67 42900 PROF. & CONT. SVCS 5,000.00 0.00 0.00 0.00 5,000.00 0.00 43100 MEMBERSHIP & DUES 1,650.00 0.00 0.00 0.00 1,650.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 12,000.00 0.00 2,000.31 0.00 9,999.69 16.66 TOTAL FOR SERVICES-SUPPLIES 36,650.00 914.59 12,297.79 0.00 24,352.21 33.55 TOTAL FOR CITY COUNCIL 142,124.78 8,173.35 60,855.85 0.00 81,268.93 42.81 11 CITY MANAGER'S OFFICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,710,407.97 152,876.11 642,091.69 0.00 1,068,316.28 37.54 41110 CONTRACTUAL OBLIGATION 0.00 0.00 13.49 0.00 (13.49) 0.00 41141 SP COMP-BILINGUAL 13,868.00 1,339.65 5,868.94 0.00 7,999.06 42.32 41200 TEMPORARY EMPLOYEES 82,913.20 3,278.40 18,124.29 0.00 64,788.91 21.85 41300 OVERTIME 7,500.00 505.73 5,144.27 0.00 2,355.73 68.59 41410 AUTO ALLOWANCE 17,280.00 1,329.24 5,823.34 0.00 11,456.66 33.69 41500 DEFERRED COMPENSATION MATCH 11,400.00 650.00 4,350.00 0.00 7,050.00 38.15 41510 PST DEFERRED COMPENSATION 333.40 17.64 115.18 0.00 218.22 34.54 41520 TIERED EMP DEF COMPENSATION 3,600.00 1,050.00 2,100.00 0.00 1,500.00 58.33 41530 TIERED RHS BENEFIT 3,600.00 1,050.00 2,100.00 0.00 1,500.00 58.33 41600 LONGEVITY 7,800.00 0.00 7,800.00 0.00 0.00 100.00 41630 ONE TIME MOU PAYMENTS 24,440.84 0.00 24,440.84 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 5,000.00 368.52 1,169.42 0.00 3,830.58 23.38 41700 ANNUAL LEAVE BUYBACK 13,029.00 0.00 13,028.32 0.00 0.68 99.99 41710 ANNUAL LEAVE OVER MAX 2,570.00 0.00 0.00 0.00 2,570.00 0.00 41910 PERS-NORMAL 199,642.48 15,598.88 64,844.51 0.00 134,797.97 32.48 User: KIMS Page: 2 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41912 PERS-UNFUNDED 335,571.00 0.00 86,779.11 0.00 248,791.89 25.86 41920 MEDICARE 56,278.35 5,010.21 21,813.91 0.00 34,464.44 38.76 41929 SHORT TERM DISABILITY 5,473.30 489.19 2,054.65 0.00 3,418.65 37.53 41930 LONG TERM DISABILITY 11,630.78 1,039.57 4,366.26 0.00 7,264.52 37.54 41931 WORKERS COMP 36,143.62 3,073.33 12,899.55 0.00 23,244.07 35.68 41932 STATE UNEMPLOYMENT INSURANCE 953.50 80.07 361.40 0.00 592.10 37.90 41940 HEALTH INSURANCE 208,717.13 13,027.02 78,270.93 0.00 130,446.20 37.50 41945 OPT OUT HEALTH INSURANCE 30,000.00 1,950.00 10,350.00 0.00 19,650.00 34.50 41946 LIFE INSURANCE 14,196.39 1,268.89 5,329.40 0.00 8,866.99 37.54 41996 VACANCY FACTOR (117,552.00) 0.00 0.00 0.00 (117,552.00) 0.00 41997 BUDGETARY/PAYROLL (2,627.00) 0.00 0.00 0.00 (2,627.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,682,169.96 204,002.45 1,019,239.50 0.00 1,662,930.46 38.00

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 12,433.78 701.73 1,796.13 0.00 10,637.65 14.44 42012 AUDIO VISUAL 500.00 0.00 466.42 0.00 33.58 93.28
42020 MINOR EQUIPMENT & FURNITURE 2,000.00 1,525.64 1,787.91 0.00 212.09 89.39 42055 COMPUTER EQUIPMENT & 6,500.00 0.00 28.81 0.00 6,471.19 0.44 42200 ADVERTISING EXPENSE 6,300.00 490.87 1,182.20 0.00 5,117.80 18.76 42220 PROMOTIONAL/PUBLIC OUTREACH 24,499.00 0.00 7,347.39 138.94 17,012.67 30.55 42300 WIRELESS COMMUNICATION 12,520.00 221.46 1,176.15 0.00 11,343.85 9.39 42320 POSTAGE & SHIPPING 2,700.00 149.89 638.75 0.00 2,061.25 23.65 42340 OFFICE SUPPLIES 7,816.00 32.56 1,235.72 0.00 6,580.28 15.81 42345 FIRST AID KIT SUPPLIES 350.00 0.00 39.35 0.00 310.65 11.24 42350 PROGRAM EXPENDITURES 22,610.00 1,098.29 13,468.31 9,647.19 (505.50) 102.23 42360 CLEANING/JANITORIAL SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42710 MILEAGE/VEHICLE EXP REIMB 1,350.00 0.00 0.00 0.00 1,350.00 0.00 42800 EQUIPMENT MAINTENANCE 5,000.00 50.70 3,224.22 0.00 1,775.78 64.48 42813 MICE & REPAIR - EQUIP & FAC 0.00 0.00 2,458.00 22,542.00 (25,000.00) 0.00 42900 PROF. & CONT. SVCS 3,126,117.79 253,811.73 593,714.99 1,269,722.06 1,262,680.74 59.60 43100 MEMBERSHIP & DUES 89,264.00 0.00 21,895.33 0.00 67,368.67 24.52 43200 CONFERENCE, TRAINING & TRAVEL 22,950.00 325.00 1,160.00 0.00 21,790.00 5.05 43722 PREVENTION & MAINTENANCE 0.00 0.00 308.06 691.94 (1,000.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 3,343,010.57 258,407.87 651,927.74 1,302,742.13 1,388,340.70 58.47 TOTAL FOR CITY MANAGER'S OFFICE 6,025,180.53 462,410.32 1,671,167.24 1,302,742.13 3,051,271.16 49.35 12 TREASURER

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,400.00 200.00 1,200.00 0.00 1,200.00 50.00 41500 DEFERRED COMPENSATION MATCH 1,900.00 461.60 821.20 0.00 1,078.80 43.22 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 300.00 0.00 300.00 50.00 User: KIMS Page: 3 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41910 PERS-NORMAL 273.36 22.78 136.68 0.00 136.68 50.00 41912 PERS-UNFUNDED 739.00 0.00 190.98 0.00 548.02 25.84 41920 MEDICARE 416.01 46.52 204.21 0.00 211.80 49.08
41931 WORKERS COMP 48.00 4.00 24.00 0.00 24.00 50.00
41940 HEALTH INSURANCE 9,240.00 770.00 4,620.00 0.00 4,620.00 50.00 41946 LIFE INSURANCE 66.00 5.50 33.00 0.00 33.00 50.00
TOTAL FOR SALARIES-BENEFITS 15,682.37 1,660.40 7,530.07 0.00 8,152.30 48.01 TOTAL FOR TREASURER 15,682.37 1,660.40 7,530.07 0.00 8,152.30 48.01 13 DEBT SERVICE

SERVICES-SUPPLIES
42500 RENTS & LEASES 4,243,273.00 0.00 2,812,679.87 0.00 1,430,593.13 66.28 42900 PROF. & CONT. SVCS 1,500.00 0.00 5,200.00 0.00 (3,700.00) 346.66 TOTAL FOR SERVICES-SUPPLIES 4,244,773.00 0.00 2,817,879.87 0.00 1,426,893.13 66.38 TOTAL FOR DEBT SERVICE 4,244,773.00 0.00 2,817,879.87 0.00 1,426,893.13 66.38 15 ADMIN SERVICES-HUMAN

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,101,448.67 82,244.98 359,549.83 0.00 741,898.84 32.64 41103 OUT OF CLASS PAY 0.00 400.32 867.36 0.00 (867.36) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 33.32 0.00 (33.32) 0.00 41140 FINAL LEAVE 0.00 0.00 21,408.99 0.00 (21,408.99) 0.00 41200 TEMPORARY EMPLOYEES 0.00 0.00 145.73 0.00 (145.73) 0.00 41300 OVERTIME 5,200.00 0.00 841.52 0.00 4,358.48 16.18 41500 DEFERRED COMPENSATION MATCH 9,500.00 438.52 1,500.04 0.00 7,999.96 15.78 41510 PST DEFERRED COMPENSATION 0.00 0.00 1.89 0.00 (1.89) 0.00 41520 TIERED EMP DEF COMPENSATION 3,000.00 600.00 1,200.00 0.00 1,800.00 40.00 41530 TIERED RHS BENEFIT 3,000.00 600.00 1,200.00 0.00 1,800.00 40.00 41600 LONGEVITY 6,000.00 0.00 6,200.00 0.00 (200.00) 103.33 41630 ONE TIME MOU PAYMENTS 15,370.71 0.00 15,370.71 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 13,281.00 0.00 13,564.88 0.00 (283.88) 102.13 41710 ANNUAL LEAVE OVER MAX 11,897.00 0.00 0.00 0.00 11,897.00 0.00 41910 PERS-NORMAL 126,138.41 9,367.69 41,658.82 0.00 84,479.59 33.02 41912 PERS-UNFUNDED 236,578.00 0.00 61,179.45 0.00 175,398.55 25.86 41920 MEDICARE 35,488.10 2,454.98 12,446.89 0.00 23,041.21 35.07 41929 SHORT TERM DISABILITY 3,524.64 263.23 1,150.72 0.00 2,373.92 32.64 41930 LONG TERM DISABILITY 7,489.85 559.26 2,444.99 0.00 5,044.86 32.64 41931 WORKERS COMP 22,028.97 1,610.42 6,993.21 0.00 15,035.76 31.74 41932 STATE UNEMPLOYMENT INSURANCE 581.15 41.37 211.35 0.00 369.80 36.36 41940 HEALTH INSURANCE 194,222.83 8,925.94 49,009.25 0.00 145,213.58 25.23 41945 OPT OUT HEALTH INSURANCE 21,000.00 1,000.00 9,500.00 0.00 11,500.00 45.23 User: KIMS Page: 4 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD : Encumbrances (Over)/Under Used
41946 LIFE INSURANCE 9,142.03 682.63 2,984.28 0.00 6,157.75 32.64 41996 VACANCY FACTOR (82,141.00) 0.00 0.00 0.00 (82,141.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,742,750.36 109,189.34 609,463.23 0.00 1,133,287.13 34.97

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 3,500.00 2,226.46 2,226.46 0.00 1,273.54 63.61 42034 SAFETY MATERIALS/CONSTRUCTION 3,920.00 0.00 0.00 0.00 3,920.00 0.00 42055 COMPUTER EQUIPMENT & 10,768.00 0.00 205.64 0.00 10,562.36 1.90 42100 UNIFORM EXPENSE 0.00 0.00 12,728.92 12,271.08 (25,000.00) 0.00 42101 SAFETY SHOES - MOU ITEM 350.00 20,368.45 20,368.45 0.00 (20,018.45) 5,819.55 42200 ADVERTISING EXPENSE 3,100.00 0.00 250.93 0.00 2,849.07 8.09 42300 WIRELESS COMMUNICATION 1,320.00 51.35 392.76 0.00 927.24 29.75 42320 POSTAGE & SHIPPING 900.00 139.33 342.56 0.00 557.44 38.06 42340 OFFICE SUPPLIES 10,000.00 60.88 1,346.34 0.00 8,653.66 13.46 42345 FIRST AID KIT SUPPLIES 120.00 0.00 4.01 0.00 115.99 3.34 42350 PROGRAM EXPENDITURES 1,000.00 30.00 334.72 0.00 665.28 33.47 42800 EQUIPMENT MAINTENANCE 6,000.00 0.00 0.00 0.00 6,000.00 0.00 42900 PROF. & CONT. SVCS 300,608.00 10,881.42 46,471.09 164,028.24 90,108.67 70.02 43041 MANDATED SAFETY TRAINING 162,200.00 1,425.00 71,145.00 95,655.00 (4,600.00) 102.83 43100 MEMBERSHIP & DUES 5,680.00 0.00 99.99 0.00 5,580.01 1.76 43110 EMPLOYEE ENGAGEMENT 15,000.00 230.92 388.12 0.00 14,611.88 2.58 43200 CONFERENCE, TRAINING & TRAVEL 11,795.00 0.00 110.75 0.00 11,684.25 0.93 43400 LEGAL SERVICES-SPECIAL COUNSEL 262,141.00 12,996.00 75,354.00 168,270.00 18,517.00 92.93 TOTAL FOR SERVICES-SUPPLIES 798,402.00 48,409.81 231,769.74 440,224.32 126,407.94 84.16 TOTAL FOR ADMIN SERVICES-HUMAN 2,541,152.36 157,599.15 841,232.97 440,224.32 1,259,695.07 50.42 16 GENERAL GOVERNMENT

SALARIES-BENEFITS
41140 FINAL LEAVE 300,000.00 0.00 0.00 0.00 300,000.00 0.00 41650 EMPLOYEE EXPENSE 0.00 4,530.89 4,530.89 0.00 (4,530.89) 0.00 41910 PERS-NORMAL 450,000.00 352,640.28 355,493.57 0.00 94,506.43 78.99 41920 MEDICARE 200.00 14.16 69.14 0.00 130.86 34.57
41921 RETIREES MEDICARE REIMB 535,000.00 17,530.15 73,310.85 0.00 461,689.15 13.70 41929 SHORT TERM DISABILITY 0.00 2.36 2.36 0.00 (2.36) 0.00 41931 WORKERS COMP 0.00 0.00 (0.11) 0.00 0.11 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.21 1.25 0.00 (1.25) 0.00 41940 HEALTH INSURANCE 0.00 0.00 199.81 0.00 (199.81) 0.00 41941 RETIREES HEALTH INSURANCE/OPE 6,659,340.00 517,133.46 3,156,585.44 0.00 3,502,754.56 47.40 41942 RETIREES LIFE INSURANCE 26,000.00 2,051.50 12,347.50 0.00 13,652.50 47.49 41944 RETIREE FLEX SPENDING PLAN 135,000.00 40,248.02 40,248.02 0.00 94,751.98 29.81 41947 RETIREE HRA 130,000.00 0.00 0.00 0.00 130,000.00 0.00 User: KIMS Page: 5 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41997 BUDGETARY/PAYROLL 571,157.00 0.00 0.00 0.00 571,157.00 0.00 TOTAL FOR SALARIES-BENEFITS 8,806,697.00 934,151.03 3,642,788.72 0.00 5,163,908.28 41.36

SERVICES-SUPPLIES
42310 PHONES, FAX, ISDN LINES 30,000.00 2,613.17 15,360.65 0.00 14,639.35 51.20 42330 PHONES,FAX-INDIRECT DEPT 5,060.00 318.28 2,117.24 0.00 2,942.76 41.84 42350 PROGRAM EXPENDITURES 10,000.00 0.00 (2,459.04) 0.00 12,459.04 (24.59) 42380 GEN BENEFIT_CITYWIDE EXPENSE 130,624.00 0.00 0.00 0.00 130,624.00 0.00 42410 ELECTRIC UTILITY 1,734,705.00 162,954.38 1,079,521.55 0.00 655,183.45 62.23 42420 NATURAL GAS UTILITY 86,000.00 13,307.35 46,694.41 0.00 39,305.59 54.29 42430 WATER UTILITY 728,000.00 47,781.50 478,729.80 0.00 249,270.20 65.75 42435 RECYCLED WATER UTILITY 886,200.00 45,791.39 496,408.60 0.00 389,791.40 56.01 42600 MOTOR POOL RENTAL 17,116.00 17,116.00 17,116.00 0.00 0.00 100.00 42900 PROF. & CONT. SVCS 195,500.00 47,753.03 132,704.73 80,444.63 (17,649.36) 109.02 42902 CUST CREDIT CRD PROCESSING FEE 160,000.00 16,565.84 124,063.89 0.00 35,936.11 77.53 42960 INDIRECT SPEC DST COUNTY ADMIN 810,880.00 0.00 0.00 0.00 810,880.00 0.00 43010 INSURANCE PREMIUMS 1,740,636.00 0.00 0.00 0.00 1,740,636.00 0.00 43100 MEMBERSHIP & DUES 12,000.00 0.00 0.00 0.00 12,000.00 0.00 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 7,316.60 7,316.60 0.00 (7,316.60) 0.00 44200 BAD DEBTS EXPENSE 1,200.00 0.00 0.00 0.00 1,200.00 0.00 44613 INTERNAL SVC CHRG-WAREHOUSE 93,873.00 23,468.25 46,936.50 0.00 46,936.50 50.00 44614 INTERNAL SVC CHRG-INFO TECH 8,340,166.00 2,085,041.50 4,170,083.00 0.00 4,170,083.00 50.00 TOTAL FOR SERVICES-SUPPLIES 14,981,960.00 2,470,027.29 6,614,593.93 80,444.63 8,286,921.44 44.68

SERVICES-SUPPLIES
43907 LOSS ON SA CITY ADMIN LOAN PYM 0.00 0.00 526,625.31 0.00 (526,625.31) 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 526,625.31 0.00 (526,625.31) 0.00 TOTAL FOR GENERAL GOVERNMENT 23,788,657.00 3,404,178.32 10,784,007.96 80,444.63 12,924,204.41 45.67 17 INFORMATION TECHNOLOGY

SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR INFORMATION TECHNOLOGY 0.00 0.00 0.00 0.00 0.00 0.00 18 ADMIN SERVICES-FINANCE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,275,262.79 177,325.29 814,287.44 0.00 1,460,975.35 35.78 41103 OUT OF CLASS PAY 0.00 381.44 381.44 0.00 (381.44) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 57.02 353.49 0.00 (353.49) 0.00 41140 FINAL LEAVE 0.00 8,742.95 20,413.66 0.00 (20,413.66) 0.00 41141 SP COMP-BILINGUAL 10,694.88 1,234.05 5,406.32 0.00 5,288.56 50.55 41200 TEMPORARY EMPLOYEES 41,248.42 2,929.08 17,629.05 0.00 23,619.37 42.73 User: KIMS Page: 6 Current Date: 01/21/2022
Report: GLREREES Consolidated Expenditure Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41300 OVERTIME 22,011.16 2,048.12 7,921.14 0.00 14,090.02 35.98 41500 DEFERRED COMPENSATION MATCH 22,500.00 2,975.00 4,865.00 0.00 17,635.00 21.62 41510 PST DEFERRED COMPENSATION 270.12 0.00 0.00 0.00 270.12 0.00 41520 TIERED EMP DEF COMPENSATION 8,400.00 1,800.00 3,750.00 0.00 4,650.00 44.64 41530 TIERED RHS BENEFIT 6,000.00 1,400.00 2,850.00 0.00 3,150.00 47.50 41600 LONGEVITY 33,230.28 847.23 23,875.05 0.00 9,355.23 71.84 41630 ONE TIME MOU PAYMENTS 34,206.07 0.00 34,206.07 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 2,500.00 3,034.41 2,712.47 0.00 (212.47) 108.49 41700 ANNUAL LEAVE BUYBACK 52,685.00 0.00 44,594.88 0.00 8,090.12 84.64 41710 ANNUAL LEAVE OVER MAX 13,328.00 0.00 0.00 0.00 13,328.00 0.00 41910 PERS-NORMAL 266,459.14 20,830.39 98,100.23 0.00 168,358.91 36.81 41912 PERS-UNFUNDED 608,953.00 0.00 155,923.20 0.00 453,029.80 25.60 41920 MEDICARE 77,568.76 5,964.77 29,629.62 0.00 47,939.14 38.19 41929 SHORT TERM DISABILITY 7,280.05 567.61 2,606.60 0.00 4,673.45 35.80 41930 LONG TERM DISABILITY 15,470.12 1,206.35 5,539.66 0.00 9,930.46 35.80 41931 WORKERS COMP 46,769.84 3,552.29 16,268.65 0.00 30,501.19 34.78 41932 STATE UNEMPLOYMENT INSURANCE 1,283.53 99.69 504.36 0.00 779.17 39.29 41940 HEALTH INSURANCE 366,723.85 17,741.20 107,569.85 0.00 259,154.00 29.33 41945 OPT OUT HEALTH INSURANCE 90,000.00 7,860.00 52,410.00 0.00 37,590.00 58.23 41946 LIFE INSURANCE 18,882.64 1,472.54 6,761.85 0.00 12,120.79 35.80 41996 VACANCY FACTOR (89,975.00) 0.00 0.00 0.00 (89,975.00) 0.00 TOTAL FOR SALARIES-BENEFITS 3,931,752.65 262,069.43 1,458,560.03 0.00 2,473,192.62 37.09

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 300.00 0.00 0.00 0.00 300.00 0.00
42020 MINOR EQUIPMENT & FURNITURE 1,000.00 23.91 23.91 0.00 976.09 2.39 42055 COMPUTER EQUIPMENT & 5,000.00 559.64 3,412.20 0.00 1,587.80 68.24 42200 ADVERTISING EXPENSE 300.00 0.00 0.00 0.00 300.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 150.00 0.00 0.00 0.00 150.00 0.00 42300 WIRELESS COMMUNICATION 350.00 0.00 0.00 0.00 350.00 0.00 42320 POSTAGE & SHIPPING 3,800.00 306.83 1,778.48 0.00 2,021.52 46.80 42340 OFFICE SUPPLIES 3,200.00 0.00 1,478.30 0.00 1,721.70 46.19 42345 FIRST AID KIT SUPPLIES 50.00 0.00 8.18 0.00 41.82 16.36 42350 PROGRAM EXPENDITURES 5,250.00 934.31 2,463.38 0.00 2,786.62 46.92 42710 MILEAGE/VEHICLE EXP REIMB 200.00 0.00 0.00 0.00 200.00 0.00 42800 EQUIPMENT MAINTENANCE 5,000.00 0.00 0.00 0.00 5,000.00 0.00 42900 PROF. & CONT. SVCS 663,995.00 43,676.40 174,202.91 408,950.26 80,841.83 87.82 43100 MEMBERSHIP & DUES 4,685.00 280.00 2,395.00 0.00 2,290.00 51.12 43200 CONFERENCE, TRAINING & TRAVEL 10,500.00 1,090.00 1,760.00 0.00 8,740.00 16.76 43500 BOOKS 450.00 0.00 0.00 0.00 450.00 0.00
43724 OUTSIDE SERVICES - LABOR 38,275.00 21,179.38 71,959.48 135,965.52 (169,650.00) 543.23 User: KIMS Page: 7 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD • Encumbrances (Over)/Under Used
TOTAL FOR SERVICES-SUPPLIES 742,505.00 68,050.47 259,481.84 544,915.78 (61,892.62) 108.33 TOTAL FOR ADMIN SERVICES-FINANCE 4,674,257.65 330,119.90 1,718,041.87 544,915.78 2,411,300.00 48.41 19 ECONOMIC DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 463,866.40 46,758.99 219,982.16 0.00 243,884.24 47.42 41141 SP COMP-BILINGUAL 7,740.00 893.10 3,912.63 0.00 3,827.37 50.55 41200 TEMPORARY EMPLOYEES 16,761.58 934.19 6,819.56 0.00 9,942.02 40.68 41410 AUTO ALLOWANCE 5,760.00 664.62 2,911.67 0.00 2,848.33 50.54 41500 DEFERRED COMPENSATION MATCH 1,900.00 0.00 0.00 0.00 1,900.00 0.00 41510 PST DEFERRED COMPENSATION 217.90 12.15 88.66 0.00 129.24 40.68 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 300.00 0.00 300.00 50.00 41530 TIERED RHS BENEFIT 600.00 150.00 300.00 0.00 300.00 50.00 41600 LONGEVITY 1,400.00 0.00 1,400.00 0.00 0.00 100.00 41630 ONE TIME MOU PAYMENTS 9,025.36 0.00 9,025.36 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 6,475.00 0.00 0.00 0.00 6,475.00 0.00 41910 PERS-NORMAL 53,875.43 5,427.56 25,661.05 0.00 28,214.38 47.63 41912 PERS-UNFUNDED 73,521.00 0.00 19,012.62 0.00 54,508.38 25.86 41920 MEDICARE 14,995.75 1,426.64 7,010.32 0.00 7,985.43 46.74 41929 SHORT TERM DISABILITY 1,484.37 149.65 705.20 0.00 779.17 47.50 41930 LONG TERM DISABILITY 3,154.29 317.93 1,498.13 0.00 1,656.16 47.49 41931 WORKERS COMP 9,767.36 937.67 4,418.10 0.00 5,349.26 45.23 41932 STATE UNEMPLOYMENT INSURANCE 252.27 24.63 121.90 0.00 130.37 48.32 41940 HEALTH INSURANCE 63,774.64 3,379.16 21,631.01 0.00 42,143.63 33.91 41945 OPT OUT HEALTH INSURANCE 0.00 1,000.00 6,000.00 0.00 (6,000.00) 0.00 41946 LIFE INSURANCE 3,850.09 388.08 1,828.70 0.00 2,021.39 47.49 TOTAL FOR SALARIES-BENEFITS 739,021.44 62,614.37 332,627.07 0.00 406,394.37 45.00

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 63,640.00 1,393.90 7,929.29 0.00 55,710.71 12.45 42020 MINOR EQUIPMENT & FURNITURE 3,000.00 0.00 107.74 0.00 2,892.26 3.59 42055 COMPUTER EQUIPMENT & 26,000.00 0.00 1,947.48 0.00 24,052.52 7.49 42220 PROMOTIONAL/PUBLIC OUTREACH 22,000.00 263.78 1,205.34 0.00 20,794.66 5.47 42300 WIRELESS COMMUNICATION 2,600.00 182.70 921.83 0.00 1,678.17 35.45 42320 POSTAGE & SHIPPING 200.00 0.00 31.11 0.00 168.89 15.55 42340 OFFICE SUPPLIES 3,000.00 0.00 688.92 0.00 2,311.08 22.96 42345 FIRST AID KIT SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42350 PROGRAM EXPENDITURES 1,500.00 0.00 164.44 0.00 1,335.56 10.96 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 0.00 0.00 500.00 0.00 42800 EQUIPMENT MAINTENANCE 400.00 0.00 6,600.44 0.00 (6,200.44) 1,650.11 42900 PROF. & CONT. SVCS 476,823.24 155,198.95 253,713.69 186,834.55 36,275.00 92.39 User: KIMS Page: 8 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
43100 MEMBERSHIP & DUES 17,680.00 0.00 2,354.10 0.00 15,325.90 13.31 43200 CONFERENCE, TRAINING & TRAVEL 30,540.00 0.00 158.67 0.00 30,381.33 0.51 TOTAL FOR SERVICES-SUPPLIES 647,983.24 157,039.33 275,823.05 186,834.55 185,325.64 71.39 TOTAL FOR ECONOMIC DEVELOPMENT 1,387,004.68 219,653.70 608,450.12 186,834.55 591,720.01 57.33 20 LEGAL AND RISK MANAGEMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 924,907.77 106,895.54 465,705.35 0.00 459,202.42 50.35 41141 SP COMP-BILINGUAL 3,870.00 446.55 1,956.31 0.00 1,913.69 50.55 41200 TEMPORARY EMPLOYEES 25,982.95 712.54 7,769.06 0.00 18,213.89 29.90 41410 AUTO ALLOWANCE 17,280.00 1,993.86 8,735.01 0.00 8,544.99 50.54 41500 DEFERRED COMPENSATION MATCH 9,500.00 525.00 975.00 0.00 8,525.00 10.26 41510 PST DEFERRED COMPENSATION 337.77 9.26 100.99 0.00 236.78 29.89 41520 TIERED EMP DEF COMPENSATION 3,000.00 750.00 1,500.00 0.00 1,500.00 50.00 41530 TIERED RHS BENEFIT 3,000.00 750.00 1,500.00 0.00 1,500.00 50.00 41600 LONGEVITY 7,000.00 0.00 7,000.00 0.00 0.00 100.00 41630 ONE TIME MOU PAYMENTS 18,395.33 0.00 18,395.33 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 52,603.00 0.00 52,601.68 0.00 1.32 99.99 41710 ANNUAL LEAVE OVER MAX 17,299.00 0.00 0.00 0.00 17,299.00 0.00 41910 PERS-NORMAL 106,585.09 12,226.26 54,063.90 0.00 52,521.19 50.72 41912 PERS-UNFUNDED 282,890.00 0.00 73,155.93 0.00 209,734.07 25.86 41920 MEDICARE 32,563.03 3,766.84 18,274.05 0.00 14,288.98 56.11 41929 SHORT TERM DISABILITY 2,959.71 342.07 1,490.24 0.00 1,469.47 50.35 41930 LONG TERM DISABILITY 6,289.37 726.87 3,166.74 0.00 3,122.63 50.35 41931 WORKERS COMP 17,063.93 2,114.81 9,261.28 0.00 7,802.65 54.27 41932 STATE UNEMPLOYMENT INSURANCE 537.02 55.86 285.56 0.00 251.46 53.17 41940 HEALTH INSURANCE 71,021.73 4,939.28 30,591.95 0.00 40,429.78 43.07 41945 OPT OUT HEALTH INSURANCE 24,000.00 2,000.00 12,000.00 0.00 12,000.00 50.00 41946 LIFE INSURANCE 7,676.74 887.23 3,865.27 0.00 3,811.47 50.35 TOTAL FOR SALARIES-BENEFITS 1,634,762.44 139,141.97 772,393.65 0.00 862,368.79 47.24

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 247.97 0.00 (247.97) 0.00 42055 COMPUTER EQUIPMENT & 4,180.00 0.00 0.00 0.00 4,180.00 0.00 42300 WIRELESS COMMUNICATION 1,400.00 315.56 1,012.86 0.00 387.14 72.34 42320 POSTAGE & SHIPPING 500.00 0.00 70.31 0.00 429.69 14.06 42340 OFFICE SUPPLIES 5,600.00 0.00 359.30 0.00 5,240.70 6.41 42345 FIRST AID KIT SUPPLIES 120.00 0.00 19.90 0.00 100.10 16.58 42710 MILEAGE/VEHICLE EXP REIMB 100.00 0.00 0.00 0.00 100.00 0.00 42900 PROF. & CONT. SVCS 0.00 36.00 108.00 0.00 (108.00) 0.00 43100 MEMBERSHIP & DUES 2,706.00 1,665.00 1,665.00 0.00 1,041.00 61.52 User: KIMS 9 Current Date: 01/21/2022
Report: GLREREES_ Consolidated Expenditurs: Repoe: Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
43200 CONFERENCE, TRAINING & TRAVEL 5,036.00 0.00 (597.00) 0.00 5,633.00 (11.85) 43400 LEGAL SERVICES-SPECIAL COUNSEL 93,900.00 14,869.17 46,851.28 24,054.00 22,994.72 75.51 43410 LEGAL RESEARCH 10,484.00 832.00 5,488.51 5,293.00 (297.51) 102.83 43430 LITIGATION EXPENSE 22,000.00 11.00 1,897.67 68,176.35 (48,074.02) 318.51 TOTAL FOR SERVICES-SUPPLIES 146,026.00 17,728.73 57,123.80 97,523.35 (8,621.15) 105.90 TOTAL FOR LEGAL AND RISK MANAGEMENT1,780,788.44 156,870.70 829,517.45 97.523.35 853,747.64 52.05 21 COMMUNITY DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,507,439.10 211,213.69 815,298.62 0.00 1,692,140.48 32.51 41110 CONTRACTUAL OBLIGATION 0.00 62.43 502.23 0.00 (502.23) 0.00 41140 FINAL LEAVE 0.00 0.00 4,595.93 0.00 (4,595.93) 0.00 41141 SP COMP-BILINGUAL 26,096.71 2,254.77 9,418.86 0.00 16,677.85 36.09 41200 TEMPORARY EMPLOYEES 0.00 0.00 44.23 0.00 (44.23) 0.00 41300 OVERTIME 9,610.05 1,449.03 4,920.85 0.00 4,689.20 51.20 41410 AUTO ALLOWANCE 5,068.80 584.88 2,562.33 0.00 2,506.47 50.55 41500 DEFERRED COMPENSATION MATCH 11,562.00 772.48 2,100.96 0.00 9,461.04 18.17 41520 TIERED EMP DEF COMPENSATION 4,800.00 1,260.00 2,490.00 0.00 2,310.00 51.87 41530 TIERED RHS BENEFIT 2,760.00 710.00 1,410.00 0.00 1,350.00 51.08 41600 LONGEVITY 20,812.81 1,016.54 16,923.41 0.00 3,889.40 81.31 41630 ONE TIME MOU PAYMENTS 33,181.21 0.00 33,181.21 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 48,985.68 0.00 46,034.27 0.00 2,951.41 93.97 41710 ANNUAL LEAVE OVER MAX 15,950.00 0.00 0.00 0.00 15,950.00 0.00 41910 PERS-NORMAL 291,459.04 24,429.85 95,791.63 0.00 195,667.41 32.86 41912 PERS-UNFUNDED 485,644.00 0.00 125,588.43 0.00 360,055.57 25.86 41920 MEDICARE 82,652.83 6,761.34 28,977.78 0.00 53,675.05 35.05 41929 SHORT TERM DISABILITY 8,046.90 698.72 2,734.76 0.00 5,312.14 33.98 41930 LONG TERM DISABILITY 17,100.79 1,484.75 5,811.21 0.00 11,289.58 33.98 41931 WORKERS COMP 50,943.43 4,215.85 16,211.17 0.00 34,732.26 31.82 41932 STATE UNEMPLOYMENT INSURANCE 1,370.35 111.93 487.39 0.00 882.96 35.56 41940 HEALTH INSURANCE 394,823.19 16,622.18 86,627.51 0.00 308,195.68 21.94 41945 OPT OUT HEALTH INSURANCE 84,300.00 7,549.53 45,368.33 0.00 38,931.67 53.81 41946 LIFE INSURANCE 20,872.72 1,812.35 7,093.57 0.00 13,779.15 33.98 41996 VACANCY FACTOR (213,786.00) 0.00 0.00 0.00 (213,786.00) 0.00 41997 BUDGETARY/PAYROLL 5,539.00 0.00 0.00 0.00 5,539.00 0.00 TOTAL FOR SALARIES-BENEFITS 3,915,232.61 283,010.32 1,354,174.68 0.00 2,561,057.93 34.58

SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,750.00 450.00 1,350.00 0.00 4,400.00 23.47 42010 SUBSCRIPTIONS 634.00 0.00 119.97 0.00 514.03 18.92 42011 SCAN/MICROFIL/MAPPING SVCS 25,000.00 0.00 1,866.82 0.00 23,133.18 7.46 User: KIMS Page: 10 Current Date: 01/21/2022
Report: GLREREES Consolidated Expenditure Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
42014 ELECTRONIC INFO RESOURCES 1,800.00 0.00 0.00 0.00 1,800.00 0.00 42020 MINOR EQUIPMENT & FURNITURE 5,720.00 93.87 5,045.70 0.00 674.30 88.21 42034 SAFETY MATERIALS/CONSTRUCTION 150.00 0.00 0.00 0.00 150.00 0.00 42055 COMPUTER EQUIPMENT & 16,270.00 47.24 6,375.72 0.00 9,894.28 39.18 42100 UNIFORM EXPENSE 3,750.00 115.28 897.62 0.00 2,852.38 23.93 42101 SAFETY SHOES - MOU ITEM 3,202.50 0.00 168.12 0.00 3,034.38 5.24 42200 ADVERTISING EXPENSE 3,400.00 508.86 2,163.94 0.00 1,236.06 63.64 42300 WIRELESS COMMUNICATION 17,486.00 1,121.48 5,125.26 0.00 12,360.74 29.31 42310 PHONES, FAX, ISDN LINES 1,200.00 112.97 564.85 0.00 635.15 47.07 42320 POSTAGE & SHIPPING 12,050.00 1,010.49 2,737.08 0.00 9,312.92 22.71 42340 OFFICE SUPPLIES 10,000.00 54.76 2,088.90 0.00 7,911.10 20.88 42345 FIRST AID KIT SUPPLIES 150.00 0.00 40.32 0.00 109.68 26.88 42350 PROGRAM EXPENDITURES 15,025.00 565.66 4,595.24 0.00 10,429.76 30.58 42360 CLEANING/JANITORIAL SUPPLIES 124.20 0.00 0.00 0.00 124.20 0.00 42410 ELECTRIC UTILITY 1,200.00 126.18 528.98 0.00 671.02 44.08 42420 NATURAL GAS UTILITY 2,400.00 142.54 591.13 0.00 1,808.87 24.63 42430 WATER UTILITY 10,000.00 737.74 4,803.49 0.00 5,196.51 48.03 42600 MOTOR POOL RENTAL 83,551.00 45,075.00 45,075.00 0.00 38,476.00 53.94 42710 MILEAGE/VEHICLE EXP REIMB 720.00 0.00 0.00 0.00 720.00 0.00 42800 EQUIPMENT MAINTENANCE 14,300.00 0.00 0.00 0.00 14,300.00 0.00 42811 MAINTENANCE & OPERATING 17,500.00 700.00 4,228.70 19,271.30 (6,000.00) 134.28 42900 PROF. & CONT. SVCS 1,554,196.88 133,265.32 423,766.40 221,030.44 909,400.04 41.48 42906 OTHER GOVT AGENCY FEES 30,000.00 0.00 32,335.16 0.00 (2,335.16) 107.78 43100 MEMBERSHIP & DUES 7,933.00 234.58 926.16 0.00 7,006.84 11.67 43200 CONFERENCE, TRAINING & TRAVEL 12,100.00 260.50 1,717.50 0.00 10,382.50 14.19 43500 BOOKS 650.00 0.00 551.18 0.00 98.82 84.79
TOTAL FOR SERVICES-SUPPLIES 1,856,262.58 184,622.47 547,663.24 240,301.74 1,068,297.60 42.44 TOTAL FOR COMMUNITY DEVELOPMENT DE,771,495.19 467,632.79 1,901,837.92 240,301.74 3,629,355.53 37.11 30 FIRE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 10,209,549.20 1,172,020.44 5,112,821.56 0.00 5,096,727.64 50.07 41101 SPECIAL ASSIGNMENT PAY 0.00 24.51 (173.34) 0.00 173.34 0.00 41140 FINAL LEAVE 0.00 60,374.42 65,664.26 0.00 (65,664.26) 0.00 41141 SP COMP-BILINGUAL 76,274.92 6,360.48 27,864.96 0.00 48,409.96 36.53 41149 SP COMP-PARAMEDIC COI COORD 5,979.96 690.00 3,022.86 0.00 2,957.10 50.54 41150 SP COMP-HAZRDOUS PAY 96,883.56 8,548.41 37,387.56 0.00 59,496.00 38.59 41151 SP COMP-SECONDARY MEDIC 140,530.01 15,853.23 66,814.62 0.00 73,715.39 47.54 41153 SP COMP-ACTING FIRE ENG 0.00 37.50 1,076.51 0.00 (1,076.51) 0.00 41154 SP COMP-ACTING FIRE CAPT 0.00 44.03 137.43 0.00 (137.43) 0.00 41155 SP COMP-ACTING BATTALION CHIEF 0.00 75.96 651.82 0.00 (651.82) 0.00 User: KIMS Page: 11 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41200 TEMPORARY EMPLOYEES 264,953.83 5,704.28 27,060.05 0.00 237,893.78 10.21 41300 OVERTIME 973,157.00 12,132.99 790,495.39 0.00 182,661.61 81.22 41310 OVERTIME - FLSA 170,810.53 115,666.02 574,954.48 0.00 (404,143.95) 336.60 41330 CONSTANT STAFF LEVELS-OT FIRE 4,950,000.00 632,457.70 2,963,722.08 0.00 1,986,277.92 59.87 41350 OVERTIME - TRAINING 532,300.00 25,586.43 83,339.42 0.00 448,960.58 15.65 41400 SPECIAL DUTY PAY 22,000.00 1,749.43 8,263.93 0.00 13,736.07 37.56 41420 FIRE HOLIDAY PAY 338,742.49 189,391.27 287,080.87 0.00 51,661.62 84.74 41500 DEFERRED COMPENSATION MATCH 4,800.00 25.00 175.00 0.00 4,625.00 3.64 41510 PST DEFERRED COMPENSATION 2,920.42 38.90 203.00 0.00 2,717.42 6.95 41520 TIERED EMP DEF COMPENSATION 2,400.00 600.00 1,200.00 0.00 1,200.00 50.00 41530 TIERED RHS BENEFIT 396,600.00 97,275.00 194,817.86 0.00 201,782.14 49.12 41600 LONGEVITY 304,563.96 35,021.07 156,147.91 0.00 148,416.05 51.26 41630 ONE TIME MOU PAYMENTS 11,220.80 0.00 11,220.80 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 115,523.00 7,480.72 21,379.53 0.00 94,143.47 18.50 41700 ANNUAL LEAVE BUYBACK 24,670.00 0.00 36,990.15 0.00 (12,320.15) 149.93 41710 ANNUAL LEAVE OVER MAX 67,906.00 0.00 0.00 0.00 67,906.00 0.00 41800 UNIFORM ALLOWANCE 4,040.00 1,010.00 2,020.00 0.00 2,020.00 50.00 41910 PERS-NORMAL 2,385,548.72 300,441.54 1,203,848.63 0.00 1,181,700.09 50.46 41912 PERS-UNFUNDED 4,185,499.00 0.00 1,098,087.18 0.00 3,087,411.82 26.23 41920 MEDICARE 377,047.41 36,687.81 166,477.03 0.00 210,570.38 44.15 41929 SHORT TERM DISABILITY 32,671.15 3,740.96 16,378.43 0.00 16,292.72 50.13 41930 LONG TERM DISABILITY 69,426.22 7,949.10 34,801.58 0.00 34,624.64 50.12 41931 WORKERS COMP 599,644.27 75,420.36 298,376.43 0.00 301,267.84 49.75 41932 STATE UNEMPLOYMENT INSURANCE 8,960.32 1,136.90 5,115.15 0.00 3,845.17 57.08 41940 HEALTH INSURANCE 1,343,964.09 114,101.18 670,074.55 0.00 673,889.54 49.85 41945 OPT OUT HEALTH INSURANCE 266,400.00 14,200.00 94,750.00 0.00 171,650.00 35.56 41946 LIFE INSURANCE 84,740.84 9,703.17 42,481.19 0.00 42,259.65 50.13 41950 MEDICAL DIFFERENCE 0.00 0.00 5,064.88 0.00 (5,064.88) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 1,511.64 7,027.26 0.00 (7,027.26) 0.00 41996 VACANCY FACTOR (173,127.00) 0.00 0.00 0.00 (173,127.00) 0.00 41997 BUDGETARY/PAYROLL (81,780.00) 0.00 0.00 0.00 (81,780.00) 0.00 TOTAL FOR SALARIES-BENEFITS 27,814,820.70 2,953,060.45 14,116,821.02 0.00 13,697,999.68 50.75

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 2,300.00 0.00 255.54 5,000.00 (2,955.54) 228.50 42020 MINOR EQUIPMENT & FURNITURE 338,003.29 2,267.32 38,966.61 59,064.83 239,971.85 29.00 42025 HOSE AND APPLIANCE 37,488.67 0.00 314.92 12,473.67 24,700.08 34.11 42026 HAZMAT EQUIPMENT 15,000.00 0.00 279.61 0.00 14,720.39 1.86 42027 TECHNICAL RESCUE EQUIPMENT 20,000.00 496.15 5,396.97 3,684.45 10,918.58 45.40 42028 SCBA BREATHING APPARATUS 25,000.00 5,521.64 5,658.68 14,461.90 4,879.42 80.48 42033 CONSTRUCTION MATERIALS 0.00 0.00 266.19 0.00 (266.19) 0.00 User: KIMS Page: 12 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
42034 SAFETY MATERIALS/CONSTRUCTION 5,000.00 0.00 0.00 0.00 5,000.00 0.00 42055 COMPUTER EQUIPMENT & 10,500.00 217.49 6,728.26 0.00 3,771.74 64.07 42100 UNIFORM EXPENSE 35,300.00 2,529.77 27,767.09 3,000.00 4,532.91 87.15 42101 SAFETY SHOES - MOU ITEM 1,400.00 0.00 0.00 0.00 1,400.00 0.00 42105 PROTECTIVE CLOTHING 280,780.00 10,826.83 16,269.78 49,373.84 215,136.38 23.37 42110 EMS SUPPLIES 208,000.00 7,854.65 43,107.26 29,266.34 135,626.40 34.79 42300 WIRELESS COMMUNICATION 54,500.00 3,840.68 22,529.28 0.00 31,970.72 41.33 42305 PBLC SFTY RADIO COMMUNICATION 6,900.00 81.06 1,061.61 0.00 5,838.39 15.38 42310 PHONES, FAX, ISDN LINES 10,000.00 502.78 2,975.69 0.00 7,024.317 29.75 42320 POSTAGE & SHIPPING 2,000.00 184.09 511.36 0.00 1,488.64 25.56 42340 OFFICE SUPPLIES 9,200.00 43.43 2,065.69 0.00 7,134.31 22.45 42350 PROGRAM EXPENDITURES 71,349.00 4,028.69 16,376.36 0.00 54,972.64 22.95 42360 CLEANING/JANITORIAL SUPPLIES 26,600.00 395.58 11,785.55 0.00 14,814.45 44.30 42441 UNLEADED FUEL 0.00 0.00 126.06 0.00 (126.06) 0.00 42600 MOTOR POOL RENTAL 1,451,825.00 1,413,526.00 1,413,526.00 0.00 38,299.00 97.36 42605 RETAINED VEHICLE EXPENSE 4,937.00 4,937.00 4,937.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 13,200.00 4,887.30 9,229.91 0.00 3,970.09 69.92 42640 MDC RENTAL RATES 56,240.00 38,540.00 38,540.00 0.00 17,700.00 68.52 42700 OTHER EQUIPMENT RENTAL 2,000.00 0.00 963.90 0.00 1,036.10 48.19 42710 MILEAGE/VEHICLE EXP REIMB 200.00 0.00 531.10 0.00 (331.10) 265.55 42800 EQUIPMENT MAINTENANCE 8,500.00 854.85 5,506.77 427.05 2,566.18 69.80 42810 BUILDING MAINTENANCE 78,676.86 22,236.50 64,881.42 6,363.53 7,431.91 90.55 42900 PROF. & CONT. SVCS 381,681.32 29,716.47 111,017.58 136,405.91 134,257.83 64.82 42907 EMS SUBSCRIPTION ADMIN 60,000.00 0.00 0.00 0.00 60,000.00 0.00 43100 MEMBERSHIP & DUES 4,650.00 324.00 6,636.91 0.00 (1,986.91) 142.72 43200 CONFERENCE, TRAINING & TRAVEL 74,400.00 2,231.34 34,384.19 12,200.00 27,815.81 62.61 43500 BOOKS 1,500.00 0.00 113.95 0.00 1,386.05 7.59
43600 DISASTER PREPAREDNESS 4,000.00 0.00 0.00 0.00 4,000.00 0.00 43716 JOB REQ CERTIFICATES & LICENSE 2,750.00 0.00 1,319.00 0.00 1,431.00 47.96 TOTAL FOR SERVICES-SUPPLIES 3,303,881.14 1,556,043.62 1,894,030.24 331,721.52 1,078,129.38 67.36

CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 68,097.00 0.00 68,728.90 0.00 (631.90) 100.92 TOTAL FOR CAPITAL OUTLAY 68,097.00 0.00 68,728.90 0.00 (631.90) 100.92 TOTAL FOR FIRE 31,186,798.84 4,509,104.07 16,079,580.16 331,721.52 14,775,497.16 52.62 32 POLICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 21,445,235.00 2,203,294.59 9,495,247.36 0.00 11,949,987.64 44.27 41101 SPECIAL ASSIGNMENT PAY 0.00 439.61 1,477.73 0.00 (1,477.73) 0.00 41102 SHIFT DIFFERENTIAL 132,912.00 14,616.36 68,266.05 0.00 64,645.95 51.36 User: KIMS Page: 13 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD : Encumbrances (Over)/Under Used
41103 OUT OF CLASS PAY 0.00 828.48 828.48 0.00 (828.48) 0.00 41105 INCENTIVE PAY PROGRAM 0.00 2,500.00 32,500.00 0.00 (32,500.00) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 1,461.11 5,926.07 0.00 (5,926.07) 0.00 41140 FINAL LEAVE 0.00 136,903.04 240,111.73 0.00 (240,111.73) 0.00 41141 SP COMP-BILINGUAL 189,967.41 21,629.67 98,120.78 0.00 91,846.63 51.65 41142 SP COMP-EMD PAY 78,969.12 6,189.98 28,181.91 0.00 50,787.21 35.68 41143 SP COMP-CGEA TRAINING OFFICER 2,899.92 252.69 1,539.27 0.00 1,360.65 53.07 41144 SP COMP-LEAD ANIMAL CTRL 2,630.04 303.48 1,329.53 0.00 1,300.51 50.55 41145 SP COMP-LEAD RECORDS TECH 8,659.92 999.24 4,377.62 0.00 4,282.30 50.55 41157 SP COMP-ACCIDENT INVESTIGATION 4,906.59 582.86 2,380.30 0.00 2,526.29 48.51 41158 SP COMP-MOTOR OFFICER 34,346.10 3,573.94 17,629.45 0.00 16,716.65 51.32 41159 SP COMP-INTERMEDIATE POST 425,123.68 45,447.82 214,821.43 0.00 210,302.25 50.53 41160 SP COMP-ADVANCED POST 615,837.88 66,693.05 314,911.93 0.00 300,925.95 51.13 41161 SP COMP-SUPERVISOR POST 16,748.64 2,573.40 11,455.73 0.00 5,292.91 68.39 41162 SP COMP-MGMT POST 27,914.41 3,279.33 12,563.85 0.00 15,350.56 45.00 41164 SP COMP-CANINE PAY 15,351.83 3,554.64 14,870.53 0.00 481.30 96.86 41165 SP COMP-SCHOOL RESOURCE OFFCR 14,560.61 2,338.09 10,787.66 0.00 3,772.95 74.08 41166 SP COMP-INVESTIGATIVE UNIT 37,363.84 5,184.78 23,671.04 0.00 13,692.80 63.35 41167 SP COMP-TRAFFIC CPL/SGT 11,808.85 786.84 4,305.94 0.00 7,502.91 36.46 41168 SP COMP-RELIEF WATCH CMND 12,927.77 2,451.38 10,913.79 0.00 2,013.98 84.42 41169 SP COMP-SPEC ENFORC TEAM 15,100.91 0.00 881.97 0.00 14,218.94 5.84 41171 SP COMP-SR DETECTIVE 47,589.68 3,260.42 17,660.58 0.00 29,929.10 37.11 41172 SP COMP-COMMERCIAL 4,906.59 575.58 2,248.65 0.00 2,657.94 45.82 41173 SP COMP-PACT TEAM 5,157.51 1,168.64 5,475.25 0.00 (317.74) 106.16 41174 SP COMP-PERSONNEL OFFICER 5,157.51 1,792.38 7,574.31 0.00 (2,416.80) 146.85 41176 SP COMP-DETECTIVE SGT 20,870.95 2,397.86 11,922.30 0.00 8,948.65 57.12 41177 SP COMP-PROFESSIONAL STND UNIT 6,173.81 691.14 3,275.06 0.00 2,898.75 53.04 41178 SP COMP-PERSONNEL & TRAINING 6,651.34 808.15 3,966.22 0.00 2,685.12 59.63 41179 SP COMP-TRAINING OFFICER 4,906.59 4,104.75 18,146.94 0.00 (13,240.35) 369.84 41180 SP COMP-YOUTH DIVERSION 18,590.42 1,352.01 5,445.38 0.00 13,145.04 29.29 41181 SP COMP-POLICE SUPPORT SVCS 7,922.39 0.00 0.00 0.00 7,922.39 0.00 41182 SP COMP-TACTICAL FLIGHT OFFCR 4,906.59 0.00 28.01 0.00 4,878.58 0.57 41183 SP COMP-HOPE-HMLS OUTRCH & 19,566.67 2,358.03 10,869.43 0.00 8,697.24 55.55 41184 SP COMP-FLEX TEAM OFFICER/CORP 16,462.93 2,629.89 12,150.15 0.00 4,312.78 73.80 41200 TEMPORARY EMPLOYEES 621,934.53 21,602.95 115,091.73 0.00 506,842.80 18.50 41300 OVERTIME 2,152,936.57 565,449.10 1,834,133.77 0.00 318,802.80 85.19 41320 COMP TIME 475,815.00 68,482.44 386,497.15 0.00 89,317.85 81.22 41400 SPECIAL DUTY PAY 100,520.00 12,188.30 50,048.88 0.00 50,471.12 49.78 41500 DEFERRED COMPENSATION MATCH 35,000.00 1,690.00 4,015.00 0.00 30,985.00 11.47 41510 PST DEFERRED COMPENSATION 5,864.77 199.86 965.69 0.00 4,899.08 16.46 User: KIMS Page: 14 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to XTD Encumbrances (Over)/Under Used
41520 TIERED EMP DEF COMPENSATION 21,000.00 4,800.00 9,750.00 0.00 11,250.00 46.42 41530 TIERED RHS BENEFIT 667,750.00 155,637.50 306,503.57 0.00 361,246.43 45.90 41600 LONGEVITY 599,552.56 1,614.17 611,645.15 0.00 (12,092.59) 102.01 41601 MARKSMANSHIP 67,725.00 15,198.75 30,502.50 0.00 37,222.50 45.03 41630 ONE TIME MOU PAYMENTS 86,129.85 0.00 86,129.85 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 44,134.00 1,751.00 10,676.96 0.00 33,457.04 24.19 41700 ANNUAL LEAVE BUYBACK 439,206.00 0.00 433,813.31 0.00 5,392.69 98.77 41710 ANNUAL LEAVE OVER MAX 89,718.00 0.00 0.00 0.00 89,718.00 0.00 41800 UNIFORM ALLOWANCE 573,460.00 132,615.00 264,370.00 0.00 309,090.00 46.10 41910 PERS-NORMAL 5,075,090.37 566,998.77 2,460,492.57 0.00 2,614,597.80 48.48 41912 PERS-UNFUNDED 7,770,253.00 0.00 2,009,402.46 0.00 5,760,850.54 25.86 41920 MEDICARE 849,431.11 104,718.23 444,791.12 0.00 404,639.99 52.36 41929 SHORT TERM DISABILITY 68,634.92 7,285.59 31,555.71 0.00 37,079.21 45.97 41930 LONG TERM DISABILITY 145,848.68 67,108.51 94,274.56 0.00 51,574.12 64.63 41931 WORKERS COMP 1,217,929.72 127,732.27 549,060.88 0.00 668,868.84 45.08 41932 STATE UNEMPLOYMENT INSURANCE 14,447.95 1,766.34 7,588.60 0.00 6,859.35 52.52 41940 HEALTH INSURANCE 2,805,361.28 184,298.18 1,109,997.44 0.00 1,695,363.84 39.56 41945 OPT OUT HEALTH INSURANCE 675,570.00 56,847.50 334,710.00 0.00 340,860.00 49.54 41946 LIFE INSURANCE 178,020.93 18,897.15 81,847.87 0.00 96,173.06 45.97 41950 MEDICAL DIFFERENCE 0.00 188.54 2,602.60 0.00 (2,602.60) 0.00 41996 VACANCY FACTOR (566,495.00) 0.00 0.00 0.00 (566,495.00) 0.00 41997 BUDGETARY/PAYROLL (23,632.43) 0.00 0.00 0.00 (23,632.43) 0.00 41999 PAYROLL SUSPENSE 0.00 50,862.37 222,947.77 0.00 (222,947.77) 0.00 TOTAL FOR SALARIES-BENEFITS 47,453,334.31 4,714,955.75 22,209,277.57 0.00 25,244,056.74 46.80

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 1,157.00 0.00 264.95 0.00 892.05 22.89 42020 MINOR EQUIPMENT & FURNITURE 149,320.73 27,691.51 64,595.80 15,332.66 69,392.27 53.52 42033 CONSTRUCTION MATERIALS 0.00 0.00 247.74 0.00 (247.74) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 250.00 58.10 314.26 0.00 (64.26) 125.70 42055 COMPUTER EQUIPMENT & 16,990.00 1,929.88 29,685.50 0.00 (12,695.50) 174.72 42100 UNIFORM EXPENSE 47,800.00 14,235.71 36,102.14 9,619.43 2,078.43 95.65 42101 SAFETY SHOES - MOU ITEM 11,200.00 0.00 0.00 0.00 11,200.00 0.00 42105 PROTECTIVE CLOTHING 49,705.50 7,712.20 35,308.01 0.00 14,397.49 71.03 42300 WIRELESS COMMUNICATION 63,400.00 (1,138.52) 27,655.93 0.00 35,744.07 43.62 42305 PBLC SFTY RADIO COMMUNICATION 163,563.00 0.00 0.00 0.00 163,563.00 0.00 42310 PHONES, FAX, ISDN LINES 37,290.00 2,680.60 16,257.09 0.00 21,032.91 43.59 42320 POSTAGE & SHIPPING 27,295.00 1,068.88 6,640.56 0.00 20,654.44 24.32 42340 OFFICE SUPPLIES 53,850.00 181.47 11,557.79 0.00 42,292.21 21.46 42345 FIRST AID KIT SUPPLIES 0.00 0.00 37.42 0.00 (37.42) 0.00 42350 PROGRAM EXPENDITURES 265,881.10 23,617.50 105,329.80 108,867.00 51,684.30 80.56 User: KIMS Page: 15 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
42360 CLEANING/JANITORIAL SUPPLIES 15,500.00 1,323.47 6,355.42 0.00 9,144.58 41.00 42410 ELECTRIC UTILITY 5,000.00 16.36 1,115.48 0.00 3,884.52 22.30 42441 UNLEADED FUEL 0.00 0.00 23.72 0.00 (23.72) 0.00
42442 DIESEL FUEL 0.00 0.00 20.60 0.00 (20.60) 0.00
42500 RENTS & LEASES 1.00 0.00 0.00 0.00 1.00 0.00
42600 MOTOR POOL RENTAL 1,654,480.00 1,642,485.00 1,642,485.00 0.00 11,995.00 99.27 42605 RETAINED VEHICLE EXPENSE 42,471.00 42,471.00 42,471.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 7,249.00 0.00 0.00 0.00 7,249.00 0.00 42640 MDC RENTAL RATES 139,580.00 139,580.00 139,580.00 0.00 0.00 100.00 42800 EQUIPMENT MAINTENANCE 117,390.43 375.16 70,956.61 2,269.59 44,164.23 62.37 42810 BUILDING MAINTENANCE 24,700.00 3,324.58 10,813.08 0.00 13,886.92 43.77 42813 MTCE & REPAIR - EQUIP & FAC 0.00 0.00 2.36 0.00 (2.36) 0.00 42900 PROF. & CONT. SVCS 1,214,414.81 31,074.86 596,071.42 393,987.36 224,356.03 81.52 42905 SPECIAL INVESTIGATIONS 9,070.00 1,700.65 4,720.29 0.00 4,349.71 52.04 43100 MEMBERSHIP & DUES 12,424.00 0.00 2,590.00 0.00 9,834.00 20.84 43200 CONFERENCE, TRAINING & TRAVEL 65,480.00 14,116.11 62,694.41 0.00 2,785.59 95.74 43220 P.O.S.T. CONFERENCE & TRAINING 69,494.00 10,934.63 74,285.60 0.00 (4,791.60) 106.89 43500 BOOKS 1,070.00 0.00 0.00 0.00 1,070.00 0.00
43715 REGULATORY PERMIT & USE FEES 705.00 0.00 0.00 0.00 705.00 0.00 TOTAL FOR SERVICES-SUPPLIES 4,266,731.57 1,965,439.15 2,988,181.98 530,076.04 748,473.55 82.45

CAPITAL OUTLAY
45100 LICENSED VEHICLES 77,000.00 0.00 0.00 0.00 77,000.00 0.00 TOTAL FOR CAPITAL OUTLAY 77,000.00 0.00 0.00 0.00 77,000.00 0.00 TOTAL FOR POLICE 51,797,065.88 6,680,394.90 25,197,459.55 530,076.04 26,069,530.29 49.66 39 PUBLIC WORKS

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,537,818.30 118,654.74 517,326.47 0.00 1,020,491.83 33.64 41101 SPECIAL ASSIGNMENT PAY 0.00 401.90 401.90 0.00 (401.90) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 912.86 0.00 (912.86) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 39.95 1,677.47 0.00 (1,677.47) 0.00 41140 FINAL LEAVE 0.00 0.00 34,496.03 0.00 (34,496.03) 0.00 41141 SP COMP-BILINGUAL 9,518.88 813.78 2,068.35 0.00 7,450.53 21.72 41200 TEMPORARY EMPLOYEES 111,700.65 8,522.66 22,956.68 0.00 88,743.97 20.55 41300 OVERTIME 47,600.00 9,261.38 40,991.55 0.00 6,608.45 86.11 41400 SPECIAL DUTY PAY 21,910.00 2,905.18 16,882.31 0.00 5,027.69 77.05 41410 AUTO ALLOWANCE 2,534.40 292.43 1,288.05 0.00 1,246.35 50.82 41500 DEFERRED COMPENSATION MATCH 8,058.00 0.00 1,092.91 0.00 6,965.09 13.56 41510 PST DEFERRED COMPENSATION 702.84 18.99 79.71 0.00 623.13 11.34 41520 TIERED EMP DEF COMPENSATION 3,858.00 735.00 1,702.89 0.00 2,155.11 44.13 User: KIMS Page: 16 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD : Encumbrances (Over)/Under Used
41530 TIERED RHS BENEFIT 2,466.00 552.00 1,169.63 0.00 1,296.37 47.43 41600 LONGEVITY 7,789.41 186.01 6,690.92 0.00 1,098.49 85.89 41630 ONE TIME MOU PAYMENTS 19,076.73 0.00 19,076.73 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 10,124.35 0.00 10,123.65 0.00 0.70 99.99 41710 ANNUAL LEAVE OVER MAX 1,404.00 0.00 0.00 0.00 1,404.00 0.00 41910 PERS-NORMAL 177,124.05 13,793.01 60,214.51 0.00 116,909.54 33.99 41912 PERS-UNFUNDED 376,140.00 0.00 97,270.47 0.00 278,869.53 25.86 41920 MEDICARE 52,513.42 4,099.87 19,924.14 0.00 32,589.28 37.94 41929 SHORT TERM DISABILITY 4,920.91 387.79 1,692.53 0.00 3,228.38 34.39 41930 LONG TERM DISABILITY 10,456.93 824.15 3,600.92 0.00 6,856.01 34.43 41931 WORKERS COMP 33,203.75 2,549.93 10,678.38 0.00 22,525.37 32.16 41932 STATE UNEMPLOYMENT INSURANCE 899.89 72.03 345.98 0.00 553.91 38.44 41940 HEALTH INSURANCE 277,310.89 12,052.84 72,154.73 0.00 205,156.16 26.01 41945 OPT OUT HEALTH INSURANCE 30,900.00 3,103.75 21,091.33 0.00 9,808.67 68.25 41946 LIFE INSURANCE 12,763.62 1,005.96 4,395.29 0.00 8,368.33 34.43 41996 VACANCY FACTOR (141,951.00) 0.00 0.00 0.00 (141,951.00) 0.00 41997 BUDGETARY/PAYROLL (73,978.00) 0.00 0.00 0.00 (73,978.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,544,866.02 180,273.35 970,306.39 0.00 1,574,559.63 38.12

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 3,800.00 0.00 4,279.00 0.00 (479.00) 112.60 42033 CONSTRUCTION MATERIALS 0.00 0.00 106.30 0.00 (106.30) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 450.00 0.00 524.34 0.00 (74.34) 116.52 42055 COMPUTER EQUIPMENT & 9,550.00 3,126.29 3,126.29 0.00 6,423.71 32.73 42100 UNIFORM EXPENSE 300.00 0.00 0.00 0.00 300.00 0.00 42101 SAFETY SHOES - MOU ITEM 4,609.63 0.00 0.00 0.00 4,609.63 0.00 42300 WIRELESS COMMUNICATION 7,350.00 1,039.53 4,787.18 0.00 2,562.82 65.13 42320 POSTAGE & SHIPPING 600.00 14.68 524.02 0.00 75.98 87.33 42340 OFFICE SUPPLIES 7,900.00 1,488.00 3,206.94 0.00 4,693.06 40.59 42345 FIRST AID KIT SUPPLIES 200.00 0.00 8.20 0.00 191.80 4.10 42350 PROGRAM EXPENDITURES 6,200.00 341.87 710.99 0.00 5,489.01 11.46 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 16.10 0.00 (16.10) 0.00 42435 RECYCLED WATER UTILITY 0.00 0.00 10.85 0.00 (10.85) 0.00 42600 MOTOR POOL RENTAL 48,083.25 48,083.25 48,083.25 0.00 0.00 100.00 42710 MILEAGE/VEHICLE EXP REIMB 1,650.00 0.00 18.95 0.00 1,631.05 1.14 42800 EQUIPMENT MAINTENANCE 13,800.00 0.00 0.00 0.00 13,800.00 0.00 42900 PROF. & CONT. SVCS 319,863.71 66.00 11,651.34 146,025.77 162,186.60 49.29 43100 MEMBERSHIP & DUES 1,400.00 14.13 1,039.78 0.00 360.22 74.27 43200 CONFERENCE, TRAINING & TRAVEL 6,900.00 1,118.80 2,695.70 0.00 4,204.30 39.06 43724 OUTSIDE SERVICES - LABOR 536,218.00 112,875.00 186,071.70 107,798.22 242,348.08 54.80 43727 INSPECTION 661,111.25 64,106.00 82,765.49 120,691.25 457,654.51 30.77 User: KIMS Page: 17 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
TOTAL FOR SERVICES-SUPPLIES 1,629,985.84 232,273.55 349,626.42 374,515.24 905,844.18 44.42 TOTAL FOR PUBLIC WORKS 4,174,851.86 412,546.90 1,319,932.81 374,515.24 2,480,403.81 40.58 41 MAINTENANCE SERVICES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,249,840.86 124,432.16 532,439.43 0.00 717,401.43 42.60 41103 OUT OF CLASS PAY 0.00 1,267.04 1,267.04 0.00 (1,267.04) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 1,034.61 3,640.58 0.00 (3,640.58) 0.00 41140 FINAL LEAVE 0.00 0.00 2,802.59 0.00 (2,802.59) 0.00 41141 SP COMP-BILINGUAL 3,981.63 459.42 2,012.70 0.00 1,968.93 50.54 41200 TEMPORARY EMPLOYEES 18,276.96 0.00 209.93 0.00 17,367.03 4.97 41300 OVERTIME 155,959.00 19,956.42 73,516.47 0.00 82,442.53 47.13 41320 COMP TIME 0.00 375.27 3,319.15 0.00 (3,319.15) 0.00 41400 SPECIAL DUTY PAY 34,498.00 7,898.12 28,086.97 0.00 6,411.03 81.41 41410 AUTO ALLOWANCE 1,210.80 86.40 378.51 0.00 832.29 31.26 41500 DEFERRED COMPENSATION MATCH 8,009.00 276.98 786.14 0.00 7,222.86 9.81 41510 PST DEFERRED COMPENSATION 0.00 0.00 11.83 0.00 (11.83) 0.00 41520 TIERED EMP DEF COMPENSATION 5,736.00 1,434.00 2,868.00 0.00 2,868.00 50.00 41530 TIERED RHS BENEFIT 2,424.00 606.00 1,212.00 0.00 1,212.00 50.00 41600 LONGEVITY 13,086.96 357.36 11,489.20 0.00 1,597.76 87.79 41630 ONE TIME MOU PAYMENTS 23,737.89 0.00 23,737.89 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 21,659.37 0.00 21,673.34 0.00 (13.97) 100.06 41710 ANNUAL LEAVE OVER MAX 6,534.00 0.00 0.00 0.00 6,534.00 0.00 41910 PERS-NORMAL 146,771.50 15,438.39 63,459.97 0.00 83,311.53 43.23 41912 PERS-UNFUNDED 355,246.00 0.00 91,867.32 0.00 263,378.68 25.86 41920 MEDICARE 47,571.79 4,740.91 21,489.13 0.00 26,082.66 45.17 41929 SHORT TERM DISABILITY 3,999.49 398.87 1,706.67 0.00 2,292.82 42.67 41930 LONG TERM DISABILITY 8,498.92 847.73 3,625.45 0.00 4,873.47 42.65 41931 WORKERS COMP 26,417.55 2,548.25 10,735.66 0.00 15,681.89 40.63 41932 STATE UNEMPLOYMENT INSURANCE 788.59 80.04 365.20 0.00 423.39 46.31 41940 HEALTH INSURANCE 273,317.77 16,635.62 97,511.38 0.00 175,806.39 35.67 41945 OPT OUT HEALTH INSURANCE 54,912.00 6,245.98 32,475.85 0.00 22,436.15 59.14 41946 LIFE INSURANCE 10,373.67 1,034.76 4,424.98 0.00 5,948.69 42.65 41996 VACANCY FACTOR (57,676.00) 0.00 0.00 0.00 (57,676.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,415,175.75 206,154.33 1,037,813.38 0.00 1,377,362.37 42.97

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 13,000.00 732.76 8,533.51 2,500.00 1,966.49 84.87 42033 CONSTRUCTION MATERIALS 166,650.00 13,427.21 75,689.14 64,564.66 26,396.20 84.16 42034 SAFETY MATERIALS/CONSTRUCTION 8,500.00 1,051.60 5,244.56 1,000.00 2,255.44 73.46 42055 COMPUTER EQUIPMENT & 3,365.00 3,136.09 5,401.15 0.00 (2,036.15) 160.50 User: KIMS Page: 18 Current Date: 01/21/2022
Report: GLEREES Consolidated Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
42100 UNIFORM EXPENSE 9,694.00 (29,814.70) 3,286.17 0.00 6,407.83 33.89 42101 SAFETY SHOES - MOU ITEM 3,101.00 0.00 0.00 0.00 3,101.00 0.00 42200 ADVERTISING EXPENSE 1,200.00 570.54 1,084.54 2,155.25 (2,039.79) 269.98 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 0.00 0.00 4,349.94 (4,349.94) 0.00 42300 WIRELESS COMMUNICATION 13,125.00 1,121.59 5,621.16 0.00 7,503.84 42.82 42310 PHONES, FAX, ISDN LINES 5,298.00 383.60 2,312.97 0.00 2,985.03 43.65 42320 POSTAGE & SHIPPING 151.00 0.00 0.00 0.00 151.00 0.00 42340 OFFICE SUPPLIES 200.00 8.83 124.49 0.00 75.51 62.24 42345 FIRST AID KIT SUPPLIES 547.00 0.00 107.08 0.00 439.92 19.57 42350 PROGRAM EXPENDITURES 13,389.00 3,006.43 7,035.96 0.00 6,353.04 52.55 42360 CLEANING/JANITORIAL SUPPLIES 500.00 0.00 0.00 0.00 500.00 0.00 42440 GASOLINE 1,479.00 0.00 0.00 0.00 1,479.00 0.00
42441 UNLEADED FUEL 1,500.00 0.00 926.74 0.00 573.26 61.78 42442 DIESEL FUEL 500.00 0.00 119.95 0.00 380.05 23.99
42600 MOTOR POOL RENTAL 406,103.50 402,415.50 402,415.50 0.00 3,688.00 99.09 42605 RETAINED VEHICLE EXPENSE 11,100.00 11,100.00 11,100.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 1,798.00 0.00 0.00 0.00 1,798.00 0.00 42700 OTHER EQUIPMENT RENTAL 5,745.72 76.09 856.73 4,015.99 873.00 84.80 42710 MILEAGE/VEHICLE EXP REIMB 3,126.00 43.02 198.24 0.00 2,927.76 6.34 42810 BUILDING MAINTENANCE 0.00 0.00 9,153.06 0.00 (9,153.06) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 508,189.50 30,108.14 128,087.14 238,451.12 141,651.24 72.12 42815 SCADA MAINTENANCE 0.00 0.00 360.29 0.00 (360.29) 0.00 42816 MOWING/LANDSCAPE CONTRACTS 79,896.00 950.00 15,520.00 9,030.50 55,345.50 30.72 42822 VANDALISM 13,000.00 0.00 1,958.00 13,000.00 (1,958.00) 115.06 42900 PROF. & CONT. SVCS 1,511,639.00 96,845.01 516,964.72 507,405.92 487,268.36 67.76 42960 INDIRECT SPEC DST COUNTY ADMIN 149,134.00 0.00 0.00 0.00 149,134.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 5,000.00 1,052.18 1,052.18 0.00 3,947.82 21.04 43715 REGULATORY PERMIT & USE FEES 11,919.00 1,165.48 3,915.45 1,000.00 7,003.55 41.24 43716 JOB REQ CERTIFICATES & LICENSE 5,058.00 0.00 0.00 0.00 5,058.00 0.00 43722 PREVENTION & MAINTENANCE 252,562.67 1,631.00 35,232.46 143,055.40 74,274.81 70.59 43726 PROJECT MANAGEMENT 0.00 64.80 388.80 0.00 (388.80) 0.00 TOTAL FOR SERVICES-SUPPLIES 3,206,470.39 539,075.17 1,242,689.99 990,528.78 973,251.62 69.64

CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 8,657.00 0.00 0.00 7,930.40 726.60 91.60 TOTAL FOR CAPITAL OUTLAY 8,657.00 0.00 0.00 7,930.40 726.60 91.60 TOTAL FOR MAINTENANCE SERVICES 5,630,303.14 745,229.50 2,280,503.37 998,459.18 2,351,340.59 58.23 47 COMMUNITY SERVICES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,074,196.31 196,006.93 773,272.84 0.00 1,300,923.47 37.28 User: KIMS Page: 19 Current Date: 01/21/2022
Report: GLREREE5 Consolidated Expenditure Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41141 SP COMP-BILINGUAL 11,374.80 1,312.50 5,187.50 0.00 6,187.30 45.60 41200 TEMPORARY EMPLOYEES 1,919,812.91 127,121.43 717,901.99 0.00 1,201,910.92 37.39 41300 OVERTIME 1,800.00 0.00 1,346.44 0.00 453.56 74.80 41400 SPECIAL DUTY PAY 1,460.00 380.73 1,731.98 0.00 (271.98) 118.62 41410 AUTO ALLOWANCE 4,896.00 564.93 2,474.93 0.00 2,421.07 50.55 41500 DEFERRED COMPENSATION MATCH 8,362.96 1,145.00 2,255.00 0.00 6,107.96 26.96 41510 PST DEFERRED COMPENSATION 20,302.56 1,400.91 7,912.79 0.00 12,389.77 38.97 41520 TIERED EMP DEF COMPENSATION 4,948.67 1,350.00 2,700.00 0.00 2,248.67 54.56 41530 TIERED RHS BENEFIT 3,351.20 850.00 1,700.00 0.00 1,651.20 50.72 41600 LONGEVITY 9,000.00 0.00 2,000.00 0.00 0.00 100.00 41630 ONE TIME MOU PAYMENTS 30,028.65 0.00 30,028.65 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 2,500.00 0.00 0.00 0.00 2,500.00 0.00 41700 ANNUAL LEAVE BUYBACK 27,801.00 0.00 19,206.71 0.00 8,594.29 69.08 41710 ANNUAL LEAVE OVER MAX 11,321.00 0.00 0.00 0.00 11,321.00 0.00 41910 PERS-NORMAL 291,142.32 23,768.07 101,405.51 0.00 189,736.81 34.83 41912 PERS-UNFUNDED 454,279.00 0.00 117,477.30 0.00 336,801.70 25.86 41920 MEDICARE 94,266.88 7,858.52 35,840.13 0.00 58,426.75 38.01 41929 SHORT TERM DISABILITY 6,678.61 627.75 2,477.78 0.00 4,200.83 37.10 41930 LONG TERM DISABILITY 10,816.59 1,333.84 5,264.94 0.00 5,551.65 48.67 41931 WORKERS COMP 78,903.65 6,416.03 29,573.81 0.00 49,329.84 37.48 41932 STATE UNEMPLOYMENT INSURANCE 2,041.47 164.37 788.53 0.00 1,252.94 38.62 41940 HEALTH INSURANCE 332,281.03 17,084.22 90,635.76 0.00 241,645.27 27.27 41945 OPT OUT HEALTH INSURANCE 61,650.00 4,200.00 23,762.50 0.00 37,887.50 38.54 41946 LIFE INSURANCE 17,342.41 1,628.14 6,426.40 0.00 10,916.01 37.05 41996 VACANCY FACTOR (193,885.00) 0.00 0.00 0.00 (193,885.00) 0.00 41997 BUDGETARY/PAYROLL (14,475.00) 0.00 0.00 0.00 (14,475.00) 0.00 TOTAL FOR SALARIES-BENEFITS 5,272,198.02 393,213.37 1,988,371.49 0.00 3,283,826.53 37.71

SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,400.00 150.00 1,300.00 0.00 4,100.00 24.07 42010 SUBSCRIPTIONS 6,587.00 1,107.06 3,737.75 0.00 2,849.25 56.74 42012 AUDIO VISUAL 6,000.00 6,000.00 6,000.00 0.00 0.00 100.00 42014 ELECTRONIC INFO RESOURCES 21,432.22 1,071.45 3,025.66 8,928.55 9,478.01 55.77 42020 MINOR EQUIPMENT & FURNITURE 21,150.10 15,456.59 22,632.73 0.00 (1,482.63) 107.01 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 210.10 708.20 0.00 (708.20) 0.00 42055 COMPUTER EQUIPMENT & 7,700.00 478.90 4,217.11 0.00 3,482.89 54.76 42100 UNIFORM EXPENSE 9,750.00 46.41 1,897.40 0.00 7,852.60 19.46 42200 ADVERTISING EXPENSE 0.00 0.00 194.52 0.00 (194.52) 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 4,000.00 756.98 2,734.54 0.00 1,265.46 68.36 42300 WIRELESS COMMUNICATION 13,224.00 1,387.28 7,090.68 0.00 6,133.32 53.61 42310 PHONES, FAX, ISDN LINES 2,500.00 169.36 1,020.56 0.00 1,479.44 40.82 User: KIMS Page: 20 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
42320 POSTAGE & SHIPPING 26,800.00 488.62 17,017.63 0.00 9,782.37 63.49 42340 OFFICE SUPPLIES 14,330.00 335.38 5,372.07 0.00 8,957.93 37.48 42345 FIRST AID KIT SUPPLIES 1,855.00 0.00 59.81 0.00 1,795.19 3.22 42350 PROGRAM EXPENDITURES 287,693.25 9,234.32 141,620.78 0.00 146,072.47 49.22 42441 UNLEADED FUEL 1,825.00 0.00 189.85 0.00 1,635.15 10.40 42630 PARTS/LABOR ON CITY VEHICLES 700.00 0.00 0.00 0.00 700.00 0.00 42700 OTHER EQUIPMENT RENTAL 8,200.00 0.00 7,144.53 0.00 1,055.47 87.12 42710 MILEAGE/VEHICLE EXP REIMB 0.00 67.31 147.34 0.00 (147.34) 0.00 42800 EQUIPMENT MAINTENANCE 22,956.00 0.00 0.00 12,656.00 10,300.00 55.13 42810 BUILDING MAINTENANCE 2,500.00 0.00 88.96 0.00 2,411.04 3.55 42813 MTCE & REPAIR - EQUIP & FAC 13,000.00 0.00 1,585.96 0.00 11,414.04 12.19 42900 PROF. & CONT. SVCS 514,739.56 71,748.86 324,398.87 95,265.79 95,074.90 81.52 43000 INSURANCE & SURETY BONDS 8,500.00 0.00 6,555.00 0.00 1,945.00 77.11 43100 MEMBERSHIP & DUES 8,989.00 594.66 2,795.66 0.00 6,193.34 31.10 43200 CONFERENCE, TRAINING & TRAVEL 33,755.00 4,120.78 9,193.71 10,777.10 13,784.19 59.16 43500 BOOKS (5,000.00) 11,743.35 12,617.92 3,613.87 (21,231.79) (324.63) 43501 CHILDREN'S BOOKS 30,000.00 8,385.22 10,723.86 11,276.14 8,000.00 73.33 43505 PASSPORT EXPENSES 31,675.00 2,104.94 6,350.86 400.00 24,924.14 21.31 TOTAL FOR SERVICES-SUPPLIES 1,100,261.13 135,657.57 600,421.96 142,917.45 356,921.72 67.56

CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 1,500.00 0.00 (1,500.00) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 1,500.00 0.00 (1,500.00) 0.00 TOTAL FOR COMMUNITY SERVICES 6,372,459.15 528,870.94 2,590,293.45 142,917.45 3,639,248.25 42.89 65 PARK MAINTENANCE/LMD

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 934,056.10 81,132.26 338,341.69 0.00 595,714.41 36.22 41110 CONTRACTUAL OBLIGATION 0.00 946.48 6,012.92 0.00 (6,012.92) 0.00 41141 SP COMP-BILINGUAL 13,649.96 1,575.00 4,212.50 0.00 9,437.46 30.86 41200 TEMPORARY EMPLOYEES 210,056.86 5,272.28 23,895.43 0.00 186,161.43 11.37 41300 OVERTIME 125,868.00 22,374.43 89,661.16 0.00 36,206.84 71.23 41320 COMP TIME 0.00 512.07 2,892.36 0.00 (2,892.36) 0.00 41400 SPECIAL DUTY PAY 4,956.00 4,324.24 18,800.42 0.00 (13,844.42) 379.34 41410 AUTO ALLOWANCE 864.00 99.69 436.74 0.00 427.26 50.54 41500 DEFERRED COMPENSATION MATCH 5,637.04 0.00 600.00 0.00 5,037.04 10.64 41510 PST DEFERRED COMPENSATION 1,369.44 68.54 310.60 0.00 1,058.84 22.68 41520 TIERED EMP DEF COMPENSATION 3,451.33 750.00 1,500.00 0.00 1,951.33 43.46 41530 TIERED RHS BENEFIT 1,448.80 350.00 700.00 0.00 748.80 48.31 41600 LONGEVITY 3,300.00 0.00 3,100.00 0.00 200.00 93.93 41630 ONE TIME MOU PAYMENTS 14,036.32 0.00 14,036.32 0.00 0.00 100.00 User: KIMS Page: 21 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41700 ANNUAL LEAVE BUYBACK 17,825.00 0.00 15,498.70 0.00 2,326.30 86.94 41710 ANNUAL LEAVE OVER MAX 2,584.00 0.00 0.00 0.00 2,584.00 0.00 41910 PERS-NORMAL 118,833.06 9,881.79 40,301.21 0.00 78,531.85 33.91 41912 PERS-UNFUNDED 195,567.00 0.00 50,573.94 0.00 144,993.06 25.86 41920 MEDICARE 38,818.05 3,414.94 15,305.82 0.00 23,512.23 39.42 41929 SHORT TERM DISABILITY 3,145.57 259.60 1,082.60 0.00 2,062.97 34.41 41930 LONG TERM DISABILITY 10,059.78 551.67 2,300.59 0.00 7,759.19 22.86 41931 WORKERS COMP 23,694.15 1,785.71 7,390.73 0.00 16,303.42 31.19 41932 STATE UNEMPLOYMENT INSURANCE 678.17 59.48 267.57 0.00 410.60 39.45 41940 HEALTH INSURANCE 180,453.41 10,225.84 57,434.42 0.00 123,018.99 31.82 41945 OPT OUT HEALTH INSURANCE 46,350.00 3,750.00 22,837.50 0.00 23,512.50 49.27 41946 LIFE INSURANCE 8,139.04 673.46 2,808.44 0.00 5,330.60 34.50 41996 VACANCY FACTOR (124,269.00) 0.00 0.00 0.00 (124,269.00) 0.00 41997 BUDGETARY/PAYROLL (13,250.00) 0.00 0.00 0.00 (13,250.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,827,322.08 148,007.48 720,301.66 0.00 1,107,020.42 39.41

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 17,435.70 12,661.68 22,949.32 0.00 (5,513.62) 131.62 42033 CONSTRUCTION MATERIALS 205,240.00 24,237.50 169,893.16 188,871.65 (153,524.81) 174.80 42034 SAFETY MATERIALS/CONSTRUCTION 1,000.00 472.60 4,145.69 0.00 (3,145.69) 414.56 42055 COMPUTER EQUIPMENT & 147.00 438.21 2,236.85 0.00 (2,089.85) 1,521.66 42100 UNIFORM EXPENSE 5,764.00 655.65 3,226.00 0.00 2,538.00 55.96 42101 SAFETY SHOES - MOU ITEM 2,975.00 0.00 0.00 0.00 2,975.00 0.00 42200 ADVERTISING EXPENSE 300.00 0.00 1,655.08 0.00 (1,355.08) 551.69 42300 WIRELESS COMMUNICATION 4,275.00 1,306.50 5,508.29 0.00 (1,233.29) 128.84 42310 PHONES, FAX, ISDN LINES 2,699.00 929.47 6,026.18 0.00 (3,327.18) 223.27 42320 POSTAGE & SHIPPING 50.00 0.00 0.00 0.00 50.00 0.00 42340 OFFICE SUPPLIES 1,000.00 28.88 240.95 0.00 759.05 24.09 42350 PROGRAM EXPENDITURES 46,305.00 4,211.49 18,761.40 36,736.94 (9,193.34) 119.85 42430 WATER UTILITY 0.00 747.61 2,576.45 0.00 (2,576.45) 0.00 42435 RECYCLED WATER UTILITY 0.00 38.12 347.08 0.00 (347.08) 0.00 42441 UNLEADED FUEL 2,244.00 0.00 1,273.91 0.00 970.09 56.76 42500 RENTS & LEASES 3,800.00 0.00 0.00 0.00 3,800.00 0.00 42600 MOTOR POOL RENTAL 98,841.00 98,841.00 98,841.00 0.00 0.00 100.00 42605 RETAINED VEHICLE EXPENSE 11,765.00 11,765.00 11,765.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 2,900.00 0.00 0.00 0.00 2,900.00 0.00 42700 OTHER EQUIPMENT RENTAL 24,500.00 0.00 4,642.17 30,357.83 (10,500.00) 142.85 42811 MAINTENANCE & OPERATING 300,000.00 0.00 12,769.31 0.00 287,230.69 4.25 42813 MTCE & REPAIR - EQUIP & FAC 362,154.55 64,113.27 262,871.63 322,423.12 (223,140.20) 161.61 42815 SCADA MAINTENANCE 4,000.00 0.00 0.00 0.00 4,000.00 0.00 42816 MOWING/LANDSCAPE CONTRACTS 1,613,763.93 162,979.04 674,629.89 1,001,842.95 (62,708.91) 103.88 User: KIMS Page: 22 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
42819 GRAFFITI REMOVAL 10,135.00 30,391.72 77,842.37 72,287.50 (139,994.87) 1,481.30 42821 TREE MAINTENANCE 995,621.65 131,375.05 357,373.60 472,231.05 166,017.00 83.32 42900 PROF. & CONT. SVCS 526,092.71 36,827.89 143,885.06 47,657.57 334,550.08 36.40 42910 REFUSE DISPOSAL 0.00 148.12 588.61 0.00 (588.61) 0.00 43200 CONFERENCE, TRAINING & TRAVEL 2,500.00 0.00 636.00 0.00 1,864.00 25.44 43715 REGULATORY PERMIT & USE FEES 1,856.00 336.00 1,554.00 0.00 302.00 83.72 43716 JOB REQ CERTIFICATES & LICENSE 1,200.00 0.00 0.00 0.00 1,200.00 0.00 43722 PREVENTION & MAINTENANCE 231,171.27 22,219.20 91,977.01 131,782.68 7,411.58 96.79 TOTAL FOR SERVICES-SUPPLIES 4,479,735.81 604,724.00 1,978,216.01 2,304,191.29 197,328.51 95.59

CAPITAL OUTLAY
45100 LICENSED VEHICLES 25,775.00 0.00 0.00 0.00 25,775.00 0.00 TOTAL FOR CAPITAL OUTLAY 25,775.00 0.00 0.00 0.00 25,775.00 0.00 TOTAL FOR PARK MAINTENANCE/LMD 6,332,832.89 752,731.48 2,698,517.67 2,304,191.29 1,330,123.93 78.99 FUN 110 177,637,082.16 19,416,065.94 72,841,991.94 11,088,025.67 93,707,064.55 47.24 User: KIMS Page: 23 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD • Encumbrances (Over)/Under Used
232 CIVIC CENTER
00 NOT APPLICABLE

SALARIES-BENEFITS
41300 OVERTIME 0.00 99.33 222.41 0.00 (222.41) 0.00
41920 MEDICARE 0.00 2.92 6.52 0.00 (6.52) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.05 0.11 0.00 (0.11) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 102.30 229.04 0.00 (229.04) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 352,730.63 0.00 0.00 0.00 352,730.63 0.00 43301 CAPITAL IMPROVEMENTS 41,240.00 0.00 0.00 41,240.00 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 393,970.63 0.00 0.00 41,240.00 352,730.63 10.46 TOTAL FOR NOT APPLICABLE 393,970.63 102.30 229.04 41,240.00 352,501.59 10.52 41 MAINTENANCE SERVICES

SERVICES-SUPPLIES
42033 CONSTRUCTION MATERIALS 3,900.00 60.54 602.13 4,906.00 (1,608.13) 141.23 42410 ELECTRIC UTILITY 60,000.00 3,113.87 30,759.61 0.00 29,240.39 51.26 42420 NATURAL GAS UTILITY 1,040.00 112.51 199.20 0.00 840.80 19.15 42430 WATER UTILITY 22,680.00 1,097.92 8,941.02 0.00 13,738.98 39.42 42813 MTCE & REPAIR - EQUIP & FAC 22,487.99 18,590.79 21,830.79 32,272.20 (31,615.00) 240.58 42822 VANDALISM 1,000.00 0.00 0.00 1,000.00 0.00 100.00 42900 PROF. & CONT. SVCS 35,752.00 2,728.27 14,941.63 534.00 20,276.37 43.28 43715 REGULATORY PERMIT & USE FEES 230.00 0.00 164.83 0.00 65.17 71.66 43722 PREVENTION & MAINTENANCE 13,191.70 185.00 3,398.79 2,752.96 7,039.95 46.63 TOTAL FOR SERVICES-SUPPLIES 160,281.69 25,888.90 80,838.00 41,465.16 37,978.53 76.30 TOTAL FOR MAINTENANCE SERVICES 160,281.69 25,888.90 80,838.00 41,465.16 37,978.53 76.30 FUN 232 554,252.32 25,991.20 81,067.04 82,705.16 390,480.12 29.54 User: KIMS Page: 24 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:13:17 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to MYTD Encumbrances (Overy/Under Used
GRAND TOTAL 178,191,334.48 19.142,057.14 72,923,058.98 11,170,730.83 94,097,544.67 47.19 User: KIMS Page: 25 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:13:17

← All documents from this meeting