Cities Index.
Exp Summary 06.30.23 - General Fund

Corona City Council
August 2, 2023

Document
Exp Summary 06.30.23 - General Fund
Meeting
August 2, 2023
Body
Corona City Council
Original file
139 KB
Text extracted from the city's file for reading and search. Open the original on corona.legistar1.com. That file is the official record.

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
110 GENERAL FUND
00 NOT APPLICABLE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 1,850.78 16,208.14 0.00 (16,208.14) 0.00 41151 SP COMP-SECONDARY MEDIC 0.00 0.00 23.22 0.00 (23.22) 0.00 41300 OVERTIME 0.00 0.00 9,167.08 0.00 (9,167.08) 0.00
41330 CONSTANT STAFF LEVELS-OT FIRE 0.00 0.00 1,011.55 0.00 (1,011.55) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 6.57 0.00 (6.57) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 6.57 0.00 (6.57) 0.00 41600 LONGEVITY 0.00 0.00 73.09 0.00 (73.09) 0.00
41910 PERS-NORMAL 0.00 201.37 1,776.98 0.00 (1,776.98) 0.00 41920 MEDICARE 0.00 54.88 746.67 0.00 (746.67) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 9.99 0.00 (9.99) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 16.58 0.00 (16.58) 0.00 41931 WORKERS COMP 0.00 37.00 324.24 0.00 (324.24) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.90 13.36 0.00 (13.36) 0.00 41940 HEALTH INSURANCE 0.00 0.00 772.53 0.00 (772.53) 0.00 41946 LIFE INSURANCE 0.00 0.00 20.26 0.00 (20.26) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 10.89 0.00 (10.89) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 2,144.93 30,187.72 0.00 (30,187.72) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 12,735,680.46 0.00 0.00 0.00 12,735,680.46 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 44,518.46 0.00 (44,518.46) 0.00 42033 CONSTRUCTION MATERIALS 34,827.91 0.00 35,671.81 0.00 (843.90) 102.42 42055 COMPUTER EQUIPMENT & 190,431.72 78,420.48 260,439.34 174,698.63 (244,706.25) 228.50 42200 ADVERTISING EXPENSE 0.00 0.00 645.07 0.00 (645.07) 0.00 42320 POSTAGE & SHIPPING 0.00 0.00 7.94 0.00 (7.94) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 16.50 0.00 (16.50) 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 0.00 1,161.01 0.00 (1,161.01) 0.00 42800 EQUIPMENT MAINTENANCE 0.00 0.00 17,207.01 0.00 (17,207.01) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 39,556.00 11,386.96 48,050.96 38,800.00 (47,294.96) 219.56 42900 PROF. & CONT. SVCS 541,326.56 46,752.06 672,583.98 687,863.08 (819,120.50) 251.31 43300 CONSTRUCTION CONTRACTS 40,357.20 36,685.92 1,094,125.47 214,949.02 (1,268,717.29) 3,243.71 43301 CAPITAL IMPROVEMENTS 33,612.35 36,440.64 168,408.76 16,187.24 (150,983.65) 549.19 43500 BOOKS 0.00 361.97 4,243.17 0.00 (4,243.17) 0.00
43715 REGULATORY PERMIT & USE FEES 0.00 0.00 2,714.32 0.00 (2,714.32) 0.00 43727 INSPECTION 6,078.20 0.00 33,123.00 78,877.00 (105,921.80) 1,842.65 TOTAL FOR SERVICES-SUPPLIES 13,621,870.40 210,048.03 2,382,916.80 1,211,374.97 10,027,578.63 26.38

CAPITAL OUTLAY
45100 LICENSED VEHICLES 105,911.56 0.00 32,179.13 30,911.56 42,820.87 59.56 JULIEK Page: 1 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
45200 MACHINERY, EQUIPMENT, & FIXTUR 199,544.64 149,720.91 314,409.32 77,271.51 (192,136.19) 196.28 TOTAL FOR CAPITAL OUTLAY 305,456.20 149,720.91 346,588.45 108,183.07 (149,315.32) 148.88 TOTAL FOR NOT APPLICABLE 13,927,326.60 361,913.87 2,759,692.97 1,319,558.04 9,848,075.59 29.28 10 CITY COUNCIL

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 48,000.00 4,000.00 48,000.00 0.00 0.00 100.00 41510 PST DEFERRED COMPENSATION 124.80 10.40 124.80 0.00 0.00 100.00 41910 PERS-NORMAL 4,177.92 348.16 4,177.92 0.00 0.00 100.00 41920 MEDICARE 1,999.68 181.05 2,139.68 0.00 (140.00) 107.00 41931 WORKERS COMP 960.00 80.00 960.00 0.00 0.00 100.00 41940 HEALTH INSURANCE 31,259.04 3,085.39 35,957.44 0.00 (4,698.40) 115.03 41946 LIFE INSURANCE 330.00 27.60 331.20 0.00 (1.20) 100.36 TOTAL FOR SALARIES-BENEFITS 86,851.44 7,732.60 91,691.04 0.00 (4,839.60) 105.57

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 0.00 0.00 1,870.37 0.00 (1,870.37) 0.00 42020 MINOR EQUIPMENT & FURNITURE 500.00 0.00 224.02 0.00 275.98 44.80 42055 COMPUTER EQUIPMENT & 1,000.00 0.00 0.00 0.00 1,000.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 18,500.00 0.00 826.96 0.00 17,673.04 4.47 42300 WIRELESS COMMUNICATION 3,600.00 335.52 3,652.27 0.00 (52.27) 101.45 42320 POSTAGE & SHIPPING 100.00 0.29 89.05 0.00 10.95 89.05 42340 OFFICE SUPPLIES 500.00 0.00 273.57 0.00 226.43 54.71 42345 FIRST AID KIT SUPPLIES 50.00 0.00 0.00 0.00 50.00 0.00 42350 PROGRAM EXPENDITURES 1,000.00 0.00 804.70 0.00 195.30 80.47 42355 MEETING EXPENDITURES 4,400.00 272.17 3,267.76 0.00 1,132.24 74.26 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 745.00 0.00 (245.00) 149.00 42800 EQUIPMENT MAINTENANCE 500.00 (448.03) 0.00 0.00 500.00 0.00 43100 MEMBERSHIP & DUES 1,200.00 0.00 0.00 0.00 1,200.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 8,100.00 0.00 234.96 0.00 7,865.04 2.90 TOTAL FOR SERVICES-SUPPLIES 39,950.00 159.95 11,988.66 0.00 27,961.34 30.00 TOTAL FOR CITY COUNCIL 126,801.44 7,892.55 103,679.70 0.00 23,121.74 81.76 11 CITY MANAGER'S OFFICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,577,804.30 186,499.21 1,420,650.87 0.00 157,153.43 90.03 41103 OUT OF CLASS PAY 0.00 0.00 5,098.86 0.00 (5,098.86) 0.00 41140 FINAL LEAVE 0.00 0.00 73,572.83 0.00 (73,572.83) 0.00 41141 SP COMP-BILINGUAL 11,610.00 2,232.75 16,267.17 0.00 (4,657.17) 140.11 41200 TEMPORARY EMPLOYEES 140,710.56 12,863.38 110,731.80 0.00 29,978.76 78.69 41300 OVERTIME 10,500.00 1,746.19 9,849.85 0.00 650.15 93.80 41410 AUTO ALLOWANCE 17,280.00 1,993.86 11,773.27 0.00 5,506.73 68.13 JULIEK Page: 2 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41500 DEFERRED COMPENSATION MATCH 11,400.00 4,046.16 11,146.16 0.00 253.84 97.77 41510 PST DEFERRED COMPENSATION 412.52 167.23 1,358.16 0.00 (945.64) 329.23 41520 TIERED EMP DEF COMPENSATION 24,100.00 6,175.00 24,100.00 0.00 0.00 100.00 41530 TIERED RHS BENEFIT 3,600.00 1,200.00 4,200.00 0.00 (600.00) 116.66 41600 LONGEVITY 8,000.00 946.08 8,082.92 0.00 (82.92) 101.03 41660 TUITION REIMBURSEMENT 2,500.00 0.00 4,100.17 0.00 (1,600.17) 164.00 41700 ANNUAL LEAVE BUYBACK 53,485.20 0.00 53,485.20 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 38,954.88 0.00 38,954.88 0.00 0.00 100.00 41910 PERS-NORMAL 185,673.13 20,636.91 144,852.34 0.00 40,820.79 78.01 41920 MEDICARE 52,900.87 6,170.76 51,135.19 0.00 1,765.68 96.66 41929 SHORT TERM DISABILITY 5,048.98 764.67 5,824.63 0.00 (775.65) 115.36 41930 LONG TERM DISABILITY 10,729.07 1,268.22 9,660.65 0.00 1,068.42 90.04 41931 WORKERS COMP 34,605.74 3,987.96 30,760.87 0.00 3,844.87 88.88 41932 STATE UNEMPLOYMENT INSURANCE 912.57 103.78 860.34 0.00 52.23 94.27 41940 HEALTH INSURANCE 228,275.52 19,384.96 229,901.92 0.00 (1,626.40) 100.71 41945 OPT OUT HEALTH INSURANCE 4,800.00 600.00 1,600.00 0.00 3,200.00 33.33 41946 LIFE INSURANCE 13,095.78 1,547.94 11,791.40 0.00 1,304.38 90.03 41951 HEALTH ALLOWANCE CREDIT 0.00 821.38 12,632.37 0.00 (12,632.37) 0.00 41997 BUDGETARY/PAYROLL (1,461.95) 0.00 0.00 0.00 (1,461.95) 0.00 TOTAL FOR SALARIES-BENEFITS 2,434,937.17 273,156.44 2,292,391.85 0.00 142,545.32 94.14

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 32,698.00 6,761.22 30,327.11 0.00 2,370.89 92.74 42012 AUDIO VISUAL 24,555.56 (19.38) 36,736.58 0.00 (12,181.02) 149.60 42020 MINOR EQUIPMENT & FURNITURE 2,000.00 52.19 1,466.53 0.00 533.47 73.32 42055 COMPUTER EQUIPMENT & 6,500.00 346.91 9,577.14 0.00 (3,077.14) 147.34 42200 ADVERTISING EXPENSE 7,000.00 516.57 7,213.22 0.00 (213.22) 103.04 42220 PROMOTIONAL/PUBLIC OUTREACH 38,959.00 491.09 25,196.59 9,945.78 3,816.63 90.20 42300 WIRELESS COMMUNICATION 8,820.00 386.05 5,467.41 0.00 3,352.59 61.98 42320 POSTAGE & SHIPPING 1,500.00 8.41 1,975.33 0.00 (475.33) 131.68 42340 OFFICE SUPPLIES 8,650.00 921.21 5,799.71 0.00 2,850.29 67.04 42345 FIRST AID KIT SUPPLIES 150.00 0.00 154.85 0.00 (4.85) 103.23 42350 PROGRAM EXPENDITURES 31,650.00 2,613.18 35,653.70 6,196.17 (10,199.87) 132.22 42355 MEETING EXPENDITURES 10,000.00 272.17 3,848.92 0.00 6,151.08 38.48 42360 CLEANING/JANITORIAL SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42430 WATER UTILITY 0.00 0.00 84.41 0.00 (84.41) 0.00
42710 MILEAGE/VEHICLE EXP REIMB 600.00 0.00 133.39 0.00 466.61 22.23 42800 EQUIPMENT MAINTENANCE 5,000.00 82.78 1,803.43 0.00 3,196.57 36.06 42813 MTCE & REPAIR - EQUIP & FAC 19,838.00 0.00 0.00 19,838.00 0.00 100.00 42900 PROF. & CONT. SVCS 2,276,422.30 15,462.67 786,669.97 223,927.44 1,265,824.89 44.39 43100 MEMBERSHIP & DUES 95,024.00 1,200.00 93,546.33 0.00 1,477.67 98.44 JULIEK Page: 3 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
43110 EMPLOYEE ENGAGEMENT 22,000.00 127.76 6,971.08 0.00 15,028.92 31.68 43200 CONFERENCE, TRAINING & TRAVEL 24,250.00 1,165.02 12,186.51 0.00 12,063.49 50.25 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 86.10 959.20 0.00 (959.20) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,615,716.86 30,473.95 1,065,771.41 259,907.39 1,290,038.06 50.68 TOTAL FOR CITY MANAGER'S OFFICE 5,050,654.03 303,630.39 3,358,163.26 259,907.39 1,432,583.38 71.63 12 TREASURER

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,400.00 200.00 2,400.00 0.00 0.00 100.00 41500 DEFERRED COMPENSATION MATCH 1,900.00 539.40 1,900.00 0.00 0.00 100.00 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 600.00 0.00 0.00 100.00 41910 PERS-NORMAL 261.12 21.76 261.12 0.00 0.00 100.00
41920 MEDICARE 416.01 48.81 415.99 0.00 0.02 99.99
41931 WORKERS COMP 48.00 4.00 48.00 0.00 0.00 100.00
41940 HEALTH INSURANCE 9,240.00 770.00 9,240.00 0.00 0.00 100.00 41946 LIFE INSURANCE 66.00 5.50 66.00 0.00 0.00 100.00
TOTAL FOR SALARIES-BENEFITS 14,931.13 1,739.47 14,931.11 0.00 0.02 100.00 TOTAL FOR TREASURER 14,931.13 1,739.47 14,931.11 0.00 0.02 100.00 13 DEBT SERVICE

SERVICES-SUPPLIES
42500 RENTS & LEASES 4,247,873.00 0.00 4,081,904.99 0.00 165,968.01 96.09 42900 PROF. & CONT. SVCS 3,000.00 0.00 2,096.62 0.00 903.38 69.88 44001 DS PRINCIPAL 2021 POBS 11,536,124.74 0.00 11,916,087.56 0.00 (379,962.82) 103.29 44100 INTEREST EXPENSE 0.00 0.00 163,389.37 0.00 (163,389.37) 0.00 44101 DS INTEREST 2021 POBS 3,919,134.42 0.00 1,562,228.74 0.00 2,356,905.68 39.86 TOTAL FOR SERVICES-SUPPLIES 19,706,132.16 0.00 17,725,707.28 0.00 1,980,424.88 89.95 TOTAL FOR DEBT SERVICE 19,706,132.16 0.00 17,725,707.28 0.00 1,980,424.88 89.95 15 HUMAN RESOURCES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,000,802.37 111,157.66 940,444.09 0.00 60,358.28 93.96 41103 OUT OF CLASS PAY 0.00 0.00 3,448.85 0.00 (3,448.85) 0.00 41140 FINAL LEAVE 0.00 0.00 21,585.59 0.00 (21,585.59) 0.00 41141 SP COMP-BILINGUAL 3,870.00 893.10 7,761.46 0.00 (3,891.46) 200.55 41300 OVERTIME 6,000.00 201.45 590.37 0.00 5,409.63 9.83 41410 AUTO ALLOWANCE 5,760.00 664.62 5,775.86 0.00 (15.86) 100.27 41500 DEFERRED COMPENSATION MATCH 8,708.33 1,400.00 12,057.72 0.00 (3,349.39) 138.46 41520 TIERED EMP DEF COMPENSATION 2,750.00 750.00 2,850.00 0.00 (100.00) 103.63 41530 TIERED RHS BENEFIT 2,750.00 750.00 2,850.00 0.00 (100.00) 103.63 41600 LONGEVITY 5,816.67 738.42 6,363.38 0.00 (546.71) 109.39 JULIEK Page: 4 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41660 TUITION REIMBURSEMENT 0.00 0.00 1,189.00 0.00 (1,189.00) 0.00 41700 ANNUAL LEAVE BUYBACK 42,926.40 0.00 42,926.40 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 1,504.88 0.00 1,504.88 0.00 0.00 100.00 41910 PERS-NORMAL 109,941.20 12,271.44 103,816.74 0.00 6,124.46 94.42 41920 MEDICARE 31,755.04 3,453.51 31,164.14 0.00 590.90 98.13 41929 SHORT TERM DISABILITY 3,202.57 455.72 3,848.39 0.00 (645.82) 120.16 41930 LONG TERM DISABILITY 6,805.46 755.82 6,382.34 0.00 423.12 93.78 41931 WORKERS COMP 20,093.45 2,218.54 18,807.66 0.00 1,285.79 93.60 41932 STATE UNEMPLOYMENT INSURANCE 529.63 57.70 522.00 0.00 7.63 98.55 41940 HEALTH INSURANCE 227,540.84 14,412.58 163,260.53 0.00 64,280.31 71.74 41945 OPT OUT HEALTH INSURANCE 0.00 1,200.00 10,975.92 0.00 (10,975.92) 0.00 41946 LIFE INSURANCE 8,306.66 922.60 7,790.80 0.00 515.86 93.78 41951 HEALTH ALLOWANCE CREDIT 0.00 617.26 8,157.06 0.00 (8,157.06) 0.00 41996 VACANCY FACTOR (55,276.00) 0.00 0.00 0.00 (55,276.00) 0.00 41997 BUDGETARY/PAYROLL (8,870.18) 0.00 0.00 0.00 (8,870.18) 0.00 TOTAL FOR SALARIES-BENEFITS 1,424,917.32 152,920.42 1,404,073.18 0.00 20,844.14 98.53

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 4,000.00 0.00 2,175.65 0.00 1,824.35 54.39 42020 MINOR EQUIPMENT & FURNITURE 3,500.00 2,294.20 2,793.38 0.00 706.62 79.81 42034 SAFETY MATERIALS/CONSTRUCTION 4,000.00 0.00 3,952.24 0.00 47.76 98.80 42055 COMPUTER EQUIPMENT & 15,500.00 155.69 10,288.30 0.00 5,211.70 66.37 42101 SAFETY SHOES - MOU ITEM 850.00 11,028.06 41,458.62 22,828.78 (63,437.40) 7,563.22 42200 ADVERTISING EXPENSE 51,600.00 10,096.21 30,562.91 0.27 21,036.82 59.23 42300 WIRELESS COMMUNICATION 1,320.00 93.54 973.21 0.00 346.79 73.72 42320 POSTAGE & SHIPPING 1,700.00 12.45 1,133.93 0.00 566.07 66.70 42340 OFFICE SUPPLIES 14,820.00 2,151.68 11,996.33 0.00 2,823.67 80.94 42345 FIRST AID KIT SUPPLIES 120.00 883.90 947.44 0.00 (827.44) 789.53 42350 PROGRAM EXPENDITURES 5,500.00 385.11 2,010.72 0.00 3,489.28 36.55 42365 RECYCLED CONTENT PRODUCTS 0.00 0.00 9.80 0.00 (9.80) 0.00 42900 PROF. & CONT. SVCS 362,294.00 21,780.85 190,277.07 47,648.93 124,368.00 65.67 43041 MANDATED SAFETY TRAINING 170,000.00 6,619.00 113,243.14 20,486.92 36,269.94 78.66 43100 MEMBERSHIP & DUES 7,000.00 837.88 3,493.86 0.00 3,506.14 49.91 43110 EMPLOYEE ENGAGEMENT 35,300.00 360.93 33,770.46 0.00 1,529.54 95.66 43200 CONFERENCE, TRAINING & TRAVEL 30,000.00 249.00 13,971.76 0.00 16,028.24 46.57 43400 LEGAL SERVICES-SPECIAL COUNSEL 113,687.10 622.00 44,656.05 26,522.70 42,508.35 62.60 TOTAL FOR SERVICES-SUPPLIES 821,191.10 57,570.50 507,714.87 117,487.60 195,988.63 76.13 TOTAL FOR HUMAN RESOURCES 2,246,108.42 210,490.92 1,911,788.05 117,487.60 216,832.77 90.34 16 GENERAL GOVERNMENT

SALARIES-BENEFITS
JULIEK Page: 5 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41140 FINAL LEAVE 600,000.00 0.00 0.00 0.00 600,000.00 0.00 41500 DEFERRED COMPENSATION MATCH 0.00 0.00 1.29 0.00 (1.29) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 1.53 0.00 (1.53) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 (3.93) 0.00 3.93 0.00 41600 LONGEVITY 0.00 0.00 26.75 0.00 (26.75) 0.00
41601 MARKSMANSHIP 0.00 1.83 1.86 0.00 (1.86) 0.00
41800 UNIFORM ALLOWANCE 0.00 0.00 0.26 0.00 (0.26) 0.00 41910 PERS-NORMAL 420,000.00 0.43 324,160.10 0.00 95,839.90 77.18 41920 MEDICARE 200.00 27.18 205.88 0.00 (5.88) 102.94
41921 RETIREES MEDICARE REIMB 583,000.00 19,286.90 733,820.90 0.00 (150,820.90) 125.86 41930 LONG TERM DISABILITY 0.00 0.00 0.05 0.00 (0.05) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.49 3.59 0.00 (3.59) 0.00 41940 HEALTH INSURANCE 0.00 0.00 18.03 0.00 (18.03) 0.00 41941 RETIREES HEALTH INSURANCE/OPEB 6,272,031.00 446,541.53 6,153,265.67 0.00 118,765.33 98.10 41942 RETIREES LIFE INSURANCE 26,000.00 2,062.50 24,816.00 0.00 1,184.00 95.44 41944 RETIREE FLEX SPENDING PLAN 135,000.00 0.00 126,000.00 0.00 9,000.00 93.33 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 66.66 0.00 (66.66) 0.00 41947 RETIREE HRA 130,000.00 0.00 119,000.00 0.00 11,000.00 91.53 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 12.68 0.00 (12.68) 0.00 41997 BUDGETARY/PAYROLL 614,259.05 0.00 0.00 0.00 614,259.05 0.00 TOTAL FOR SALARIES-BENEFITS 8,780,490.05 467,920.86 7,481,397.32 0.00 1,299,092.73 85.20

SERVICES-SUPPLIES
42310 PHONES, FAX, ISDN LINES 31,000.00 5,092.37 29,267.60 0.00 1,732.40 94.41 42320 POSTAGE & SHIPPING 1,147.00 8.00 262.57 1,147.00 (262.57) 122.89 42330 PHONES,FAX-INDIRECT DEPT 5,160.00 606.06 3,522.18 0.00 1,637.82 68.25 42350 PROGRAM EXPENDITURES 31,985.00 15,600.42 74,287.12 977.37 (43,279.49) 235.31 42380 GEN BENEFIT_CITYWIDE EXPENSE 129,463.00 0.00 120,759.00 0.00 8,704.00 93.27 42410 ELECTRIC UTILITY 1,769,400.00 31,490.57 1,738,254.48 0.00 31,145.52 98.23 42420 NATURAL GAS UTILITY 87,700.00 0.00 206,572.63 0.00 (118,872.63) 235.54 42430 WATER UTILITY 764,400.00 57,899.29 626,234.33 0.00 138,165.67 81.92 42435 RECYCLED WATER UTILITY 912,800.00 83,265.43 745,822.49 0.00 166,977.51 81.70 42600 MOTOR POOL RENTAL 21,710.00 0.00 21,710.00 0.00 0.00 100.00 42900 PROF. & CONT. SVCS 291,113.00 20,443.74 184,639.70 38,108.13 68,365.17 76.51 42902 CUST CREDIT CRD PROCESSING FEE 260,000.00 307.06 253,093.39 0.00 6,906.61 97.34 42960 INDIRECT SPEC DST COUNTY ADMIN 759,805.00 35.93 341,870.99 0.00 417,934.01 44.99 43010 INSURANCE PREMIUMS 1,500,000.00 0.00 0.00 0.00 1,500,000.00 0.00 43100 MEMBERSHIP & DUES 12,000.00 0.00 0.00 0.00 12,000.00 0.00 44200 BAD DEBTS EXPENSE 50,000.00 0.00 0.00 0.00 50,000.00 0.00 44613 INTERNAL SVC CHRG-WAREHOUSE 78,612.00 19,653.00 78,612.00 0.00 0.00 100.00 44614 INTERNAL SVC CHRG-INFO TECH 9,767,033.00 2,441,758.25 9,767,033.00 0.00 0.00 100.00 JULIEK Page: 6 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
TOTAL FOR SERVICES-SUPPLIES 16,473,328.00 2,676,160.12 14,191,941.48 40,232.50 2,241,154.02 86.39

SERVICES-SUPPLIES
43907 LOSS ON SA CITY ADMIN LOAN PYM 0.00 0.00 184,957.91 0.00 (184,957.91) 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 184,957.91 0.00 (184,957.91) 0.00 TOTAL FOR GENERAL GOVERNMENT 25,253,818.05 3,144,080.98 21,858,296.71 40,232.50 3,355,288.84 86.71 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 FINANCE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,383,756.83 255,994.85 2,014,599.30 0.00 369,157.53 84.51 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 87.50 0.00 (87.50) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 1,361.49 0.00 (1,361.49) 0.00 41140 FINAL LEAVE 0.00 0.00 30,719.24 0.00 (30,719.24) 0.00 41141 SP COMP-BILINGUAL 10,694.88 1,050.00 9,391.88 0.00 1,303.00 87.81 41200 TEMPORARY EMPLOYEES 16,745.74 0.00 4,348.08 0.00 12,397.66 25.96 41300 OVERTIME 22,000.00 2,923.01 39,766.23 0.00 (17,766.23) 180.75 41400 SPECIAL DUTY PAY 0.00 0.00 984.77 0.00 (984.77) 0.00 41410 AUTO ALLOWANCE 5,760.00 664.62 5,775.86 0.00 (15.86) 100.27 41500 DEFERRED COMPENSATION MATCH 24,358.33 1,830.00 12,200.00 0.00 12,158.33 50.08 41510 PST DEFERRED COMPENSATION (39.06) 0.00 0.00 0.00 (39.06) 0.00 41520 TIERED EMP DEF COMPENSATION 8,950.00 1,350.00 5,550.00 0.00 3,400.00 62.01 41530 TIERED RHS BENEFIT 6,583.33 1,050.00 4,350.00 0.00 2,233.33 66.07 41600 LONGEVITY 29,064.61 2,947.62 26,918.00 0.00 2,146.61 92.61 41660 TUITION REIMBURSEMENT 0.00 0.00 1,428.99 0.00 (1,428.99) 0.00 41700 ANNUAL LEAVE BUYBACK 82,724.70 0.00 82,724.70 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 32,454.99 0.00 32,454.99 0.00 0.00 100.00 41910 PERS-NORMAL 265,827.39 28,287.23 223,713.92 0.00 42,113.47 84.15 41920 MEDICARE 77,770.67 7,917.82 68,067.61 0.00 9,703.06 87.52 41929 SHORT TERM DISABILITY 7,628.02 1,050.24 8,253.84 0.00 (625.82) 108.20 41930 LONG TERM DISABILITY 16,217.57 1,741.73 13,689.15 0.00 2,528.42 84.40 41931 WORKERS COMP 48,383.66 5,057.32 39,863.18 0.00 8,520.48 82.38 41932 STATE UNEMPLOYMENT INSURANCE 1,293.73 132.81 1,135.80 0.00 157.93 87.79 41940 HEALTH INSURANCE 595,450.84 29,418.15 317,142.05 0.00 278,308.79 53.26 41945 OPT OUT HEALTH INSURANCE 33,600.00 3,400.00 66,237.27 0.00 (32,637.27) 197.13 41946 LIFE INSURANCE 19,782.87 2,125.97 16,708.75 0.00 3,074.12 84.46 41951 HEALTH ALLOWANCE CREDIT 0.00 856.60 11,351.69 0.00 (11,351.69) 0.00 41996 VACANCY FACTOR (128,224.00) 0.00 0.00 0.00 (128,224.00) 0.00 JULIEK Page: 7 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41997 BUDGETARY/PAYROLL (142,248.84) 0.00 0.00 0.00 (142,248.84) 0.00 TOTAL FOR SALARIES-BENEFITS 3,418,536.26 347,797.97 3,038,824.29 0.00 379,711.97 88.89

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 300.00 0.00 0.00 0.00 300.00 0.00
42020 MINOR EQUIPMENT & FURNITURE 7,647.82 59.80 9,436.82 2,455.40 (4,244.40) 155.49 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 424.36 424.36 0.00 (424.36) 0.00 42055 COMPUTER EQUIPMENT & 8,000.00 1,646.00 23,116.28 0.00 (15,116.28) 288.95 42200 ADVERTISING EXPENSE 300.00 0.00 933.63 0.00 (633.63) 311.21 42320 POSTAGE & SHIPPING 3,800.00 45.67 3,703.51 0.00 96.49 97.46 42340 OFFICE SUPPLIES 3,000.00 368.32 4,526.34 0.00 (1,526.34) 150.87 42345 FIRST AID KIT SUPPLIES 25.00 0.00 49.49 0.00 (24.49) 197.96 42350 PROGRAM EXPENDITURES 5,000.00 24.98 4,542.53 0.00 457.47 90.85 42365 RECYCLED CONTENT PRODUCTS 0.00 213.11 600.94 0.00 (600.94) 0.00 42710 MILEAGE/VEHICLE EXP REIMB 200.00 0.00 0.00 0.00 200.00 0.00 42810 BUILDING MAINTENANCE 0.00 0.00 2,402.44 0.00 (2,402.44) 0.00 42900 PROF. & CONT. SVCS 667,136.00 90,220.65 539,800.26 61,240.83 66,094.91 90.09 43100 MEMBERSHIP & DUES 5,490.00 1,884.16 5,669.16 0.00 (179.16) 103.26 43200 CONFERENCE, TRAINING & TRAVEL 12,500.00 748.00 8,198.19 0.00 4,301.81 65.58 43724 OUTSIDE SERVICES - LABOR 198,917.50 8,436.00 96,779.75 8,220.25 93,917.50 52.78 43725 FINES AND PENALTIES 0.00 0.00 50.00 0.00 (50.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 912,316.32 104,071.05 700,233.70 71,916.48 140,166.14 84.63 TOTAL FOR FINANCE 4,330,852.58 451,869.02 3,739,057.99 71,916.48 519,878.11 87.99 19 ECONOMIC DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 395,151.00 48,500.80 401,387.41 0.00 (6,236.41) 101.57 41103 OUT OF CLASS PAY 0.00 0.00 4,367.50 0.00 (4,367.50) 0.00 41141 SP COMP-BILINGUAL 3,870.00 1,339.65 11,195.65 0.00 (7,325.65) 289.29 41410 AUTO ALLOWANCE 5,760.00 664.62 5,775.86 0.00 (15.86) 100.27 41500 DEFERRED COMPENSATION MATCH 0.00 500.00 3,100.00 0.00 (3,100.00) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 150.00 600.00 0.00 (600.00) 0.00 41530 TIERED RHS BENEFIT 0.00 150.00 600.00 0.00 (600.00) 0.00 41710 ANNUAL LEAVE OVER MAX 4,059.14 0.00 4,059.14 0.00 0.00 100.00 41910 PERS-NORMAL 43,413.48 5,422.60 44,888.71 0.00 (1,475.23) 103.39 41920 MEDICARE 11,982.65 1,527.11 12,929.74 0.00 (947.09) 107.90 41929 SHORT TERM DISABILITY 1,264.48 198.85 1,645.69 0.00 (381.21) 130.14 41930 LONG TERM DISABILITY 2,687.03 329.78 2,729.30 0.00 (42.27) 101.57 41931 WORKERS COMP 7,980.42 995.20 8,310.59 0.00 (330.17) 104.13 41932 STATE UNEMPLOYMENT INSURANCE 202.39 25.88 217.99 0.00 (15.60) 107.70 41940 HEALTH INSURANCE 92,517.36 4,470.99 53,828.08 0.00 38,689.28 58.18 JULIEK Page: 8 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41945 OPT OUT HEALTH INSURANCE 0.00 600.00 8,512.64 0.00 (8,512.64) 0.00 41946 LIFE INSURANCE 3,279.75 402.54 3,331.52 0.00 (51.77) 101.57 41951 HEALTH ALLOWANCE CREDIT 0.00 184.20 1,832.04 0.00 (1,832.04) 0.00 41996 VACANCY FACTOR (5,781.00) 0.00 0.00 0.00 (5,781.00) 0.00 TOTAL FOR SALARIES-BENEFITS 566,386.70 65,462.22 569,311.86 0.00 (2,925.16) 100.51

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 42,840.00 289.00 29,284.28 6,100.00 7,455.72 82.59 42020 MINOR EQUIPMENT & FURNITURE 3,000.00 0.00 297.48 0.00 2,702.52 9.91 42055 COMPUTER EQUIPMENT & 10,000.00 124.17 5,562.02 0.00 4,437.98 55.62 42200 ADVERTISING EXPENSE 7,500.00 39.54 549.54 0.00 6,950.46 7.32 42220 PROMOTIONAL/PUBLIC OUTREACH 29,550.00 1,104.33 12,530.90 0.00 17,019.10 42.40 42300 WIRELESS COMMUNICATION 3,700.00 154.40 1,920.04 0.00 1,779.96 51.89 42320 POSTAGE & SHIPPING 1,000.00 0.00 724.84 0.00 275.16 72.48 42340 OFFICE SUPPLIES 3,000.00 270.46 2,223.85 0.00 776.15 74.12 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 901.12 0.00 598.88 60.07 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 0.00 0.00 500.00 0.00 42800 EQUIPMENT MAINTENANCE 400.00 0.00 0.00 0.00 400.00 0.00 42840 FACILITY RENTALS 1,000.00 0.00 0.00 0.00 1,000.00 0.00 42900 PROF. & CONT. SVCS 306,850.00 17,050.00 159,324.62 90,399.50 57,125.88 81.38 43100 MEMBERSHIP & DUES 16,810.00 264.00 6,798.95 0.00 10,011.05 40.44 43200 CONFERENCE, TRAINING & TRAVEL 33,300.00 876.23 6,530.17 0.00 26,769.83 19.61 43400 LEGAL SERVICES-SPECIAL COUNSEL 72,000.00 0.00 184.50 0.00 71,815.50 0.25 TOTAL FOR SERVICES-SUPPLIES 533,050.00 20,172.13 226,832.31 96,499.50 209,718.19 60.65 TOTAL FOR ECONOMIC DEVELOPMENT 1,099,436.70 85,634.35 796,144.17 96,499.50 206,793.03 81.19 20 LEGAL AND RISK MANAGEMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,014,239.00 120,914.62 1,018,095.73 0.00 (3,856.73) 100.38 41141 SP COMP-BILINGUAL 3,870.00 446.55 3,880.73 0.00 (10.73) 100.27 41200 TEMPORARY EMPLOYEES 33,803.20 4,439.43 18,856.29 0.00 14,946.91 55.78 41410 AUTO ALLOWANCE 17,280.00 1,993.86 17,327.59 0.00 (47.59) 100.27 41500 DEFERRED COMPENSATION MATCH 7,600.00 450.00 7,600.00 0.00 0.00 100.00 41510 PST DEFERRED COMPENSATION 439.44 57.73 245.17 0.00 194.27 55.79 41520 TIERED EMP DEF COMPENSATION 15,000.00 3,750.00 15,000.00 0.00 0.00 100.00 41530 TIERED RHS BENEFIT 2,400.00 750.00 3,000.00 0.00 (600.00) 125.00 41600 LONGEVITY 7,000.00 899.88 7,449.07 0.00 (449.07) 106.41 41700 ANNUAL LEAVE BUYBACK 90,890.40 0.00 90,890.40 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 7,232.39 0.00 7,232.39 0.00 0.00 100.00 41910 PERS-NORMAL 111,531.86 13,301.97 112,001.28 0.00 (469.42) 100.42 JULIEK Page: 9 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41920 MEDICARE 35,348.58 3,913.32 37,403.39 0.00 (2,054.81) 105.81 41929 SHORT TERM DISABILITY 3,245.56 495.75 4,174.25 0.00 (928.69) 128.61 41930 LONG TERM DISABILITY 6,896.82 822.18 6,922.88 0.00 (26.06) 100.37 41931 WORKERS COMP 21,038.25 2,495.25 20,611.53 0.00 426.72 97.97 41932 STATE UNEMPLOYMENT INSURANCE 590.19 65.37 593.35 0.00 (3.16) 100.53 41940 HEALTH INSURANCE 83,220.00 6,408.06 75,884.12 0.00 7,335.88 91.18 41945 OPT OUT HEALTH INSURANCE 14,400.00 1,200.00 21,148.42 0.00 (6,748.42) 146.86 41946 LIFE INSURANCE 8,418.18 1,003.56 8,450.02 0.00 (31.84) 100.37 41951 HEALTH ALLOWANCE CREDIT 0.00 359.96 4,253.04 0.00 (4,253.04) 0.00 TOTAL FOR SALARIES-BENEFITS 1,484,443.87 163,767.49 1,481,019.65 0.00 3,424.22 99.76

SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 4,180.00 0.00 1,545.72 0.00 2,634.28 36.97 42300 WIRELESS COMMUNICATION 2,220.00 427.01 2,013.55 0.00 206.45 90.70 42320 POSTAGE & SHIPPING 500.00 24.57 273.35 0.00 226.65 54.67 42340 OFFICE SUPPLIES 5,250.00 269.03 805.18 0.00 4,444.82 15.33 42345 FIRST AID KIT SUPPLIES 120.00 0.00 58.88 0.00 61.12 49.06 42710 MILEAGE/VEHICLE EXP REIMB 100.00 0.00 0.00 0.00 100.00 0.00 42900 PROF. & CONT. SVCS 350.00 36.00 226.67 0.00 123.33 64.76 43100 MEMBERSHIP & DUES 2,505.00 0.00 2,785.00 0.00 (280.00) 111.17 43200 CONFERENCE, TRAINING & TRAVEL 10,000.00 754.00 2,325.00 0.00 7,675.00 23.25 43400 LEGAL SERVICES-SPECIAL COUNSEL 94,225.00 5,769.80 71,439.11 13,626.00 9,159.89 90.27 43410 LEGAL RESEARCH 10,820.00 2,184.22 13,027.54 0.00 (2,207.54) 120.40 43430 LITIGATION EXPENSE 22,000.00 3,933.95 17,238.97 1,261.65 3,499.38 84.09 TOTAL FOR SERVICES-SUPPLIES 152,270.00 13,398.58 111,738.97 14,887.65 25,643.38 83.15 TOTAL FOR LEGAL AND RISK MANAGEMENT1,636,713.87 177,166.07 1,592,758.62 14,887.65 29,067.60 98.22 21 COMMUNITY DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 3,583,048.82 344,098.36 2,693,900.70 0.00 889,148.12 75.18 41103 OUT OF CLASS PAY 0.00 0.00 4,571.52 0.00 (4,571.52) 0.00 41140 FINAL LEAVE 0.00 0.00 17,268.45 0.00 (17,268.45) 0.00 41141 SP COMP-BILINGUAL 31,469.89 2,935.26 20,943.49 0.00 10,526.40 66.55 41200 TEMPORARY EMPLOYEES 47,342.29 6,255.34 51,163.62 0.00 (3,821.33) 108.07 41300 OVERTIME 14,400.00 1,055.64 12,069.47 0.00 2,330.53 83.81 41400 SPECIAL DUTY PAY 0.00 369.96 3,130.72 0.00 (3,130.72) 0.00 41410 AUTO ALLOWANCE 5,760.00 664.62 5,773.97 0.00 (13.97) 100.24 41500 DEFERRED COMPENSATION MATCH 12,277.00 1,213.48 9,114.99 0.00 3,162.01 74.24 41510 PST DEFERRED COMPENSATION 615.45 29.37 192.95 0.00 422.50 31.35 41520 TIERED EMP DEF COMPENSATION 4,446.00 799.50 3,308.81 0.00 1,137.19 74.42 41530 TIERED RHS BENEFIT 3,134.00 521.50 2,282.94 0.00 851.06 72.84 JULIEK Page: 10 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41600 LONGEVITY 19,855.15 2,030.67 18,709.69 0.00 1,145.46 94.23 41700 ANNUAL LEAVE BUYBACK 74,710.74 0.00 74,710.74 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 4,425.37 0.00 4,425.37 0.00 0.00 100.00 41910 PERS-NORMAL 395,371.57 37,978.26 297,332.24 0.00 98,039.33 75.20 41920 MEDICARE 112,773.77 10,663.43 87,992.24 0.00 24,781.53 78.02 41929 SHORT TERM DISABILITY 11,465.76 1,422.63 11,113.56 0.00 352.20 96.92 41930 LONG TERM DISABILITY 24,364.73 2,359.53 18,440.58 0.00 5,924.15 75.68 41931 WORKERS COMP 73,407.05 7,052.66 55,325.51 0.00 18,081.54 75.36 41932 STATE UNEMPLOYMENT INSURANCE 1,903.62 182.39 1,497.58 0.00 406.04 78.67 41940 HEALTH INSURANCE 820,983.64 38,432.04 417,550.84 0.00 403,432.80 50.85 41945 OPT OUT HEALTH INSURANCE 35,400.00 4,050.00 65,922.38 0.00 (30,522.38) 186.22 41946 LIFE INSURANCE 29,739.31 2,879.74 22,507.15 0.00 7,232.16 75.68 41951 HEALTH ALLOWANCE CREDIT 0.00 1,233.24 16,730.59 0.00 (16,730.59) 0.00 41996 VACANCY FACTOR (195,147.00) 0.00 0.00 0.00 (195,147.00) 0.00 41997 BUDGETARY/PAYROLL (250,000.00) 0.00 0.00 0.00 (250,000.00) 0.00 TOTAL FOR SALARIES-BENEFITS 4,861,747.16 466,227.62 3,915,980.10 0.00 945,767.06 80.54

SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,750.00 600.00 3,250.00 0.00 2,500.00 56.52 42010 SUBSCRIPTIONS 426.00 0.00 359.91 0.00 66.09 84.48 42011 SCAN/MICROFIL/MAPPING SVCS 37,000.00 26,432.46 28,101.46 0.00 8,898.54 75.94 42014 ELECTRONIC INFO RESOURCES 1,800.00 150.00 2,252.16 0.00 (452.16) 125.12 42020 MINOR EQUIPMENT & FURNITURE 8,030.00 353.43 4,540.40 0.00 3,489.60 56.54 42033 CONSTRUCTION MATERIALS 700.00 0.00 618.22 0.00 81.78 88.31 42034 SAFETY MATERIALS/CONSTRUCTION 1,200.00 0.00 849.68 0.00 350.32 70.80 42055 COMPUTER EQUIPMENT & 29,890.00 12,290.30 31,082.47 0.00 (1,192.47) 103.98 42100 UNIFORM EXPENSE 8,266.00 25.65 2,423.44 0.00 5,842.56 29.31 42101 SAFETY SHOES - MOU ITEM 9,329.00 0.00 1,997.43 0.00 7,331.57 21.41 42200 ADVERTISING EXPENSE 3,500.00 814.69 37,347.42 0.00 (33,847.42) 1,067.06 42220 PROMOTIONAL/PUBLIC OUTREACH 500.00 0.00 560.00 0.00 (60.00) 112.00 42300 WIRELESS COMMUNICATION 19,554.00 358.19 12,242.29 0.00 7,311.71 62.60 42320 POSTAGE & SHIPPING 12,350.00 69.69 14,489.02 0.00 (2,139.02) 117.32 42340 OFFICE SUPPLIES 14,300.00 875.11 9,157.45 0.00 5,142.55 64.03 42345 FIRST AID KIT SUPPLIES 300.00 0.00 195.07 0.00 104.93 65.02 42350 PROGRAM EXPENDITURES 19,700.00 575.03 23,428.65 0.00 (3,728.65) 118.92 42360 CLEANING/JANITORIAL SUPPLIES 165.60 0.00 0.00 0.00 165.60 0.00 42365 RECYCLED CONTENT PRODUCTS 0.00 761.77 1,992.52 0.00 (1,992.52) 0.00 42430 WATER UTILITY 0.00 (6,556.94) 0.00 0.00 0.00 0.00 42441 UNLEADED FUEL 1,200.00 0.00 0.00 0.00 1,200.00 0.00 42600 MOTOR POOL RENTAL 109,090.00 0.00 109,090.00 0.00 0.00 100.00 42605 RETAINED VEHICLE EXPENSE 1,949.00 0.00 1,949.00 0.00 0.00 100.00 JULIEK Page: 11 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
42710 MILEAGE/VEHICLE EXP REIMB 770.00 0.00 0.00 0.00 770.00 0.00 42800 EQUIPMENT MAINTENANCE 14,500.00 0.00 0.00 0.00 14,500.00 0.00 42900 PROF. & CONT. SVCS 1,874,078.00 344,112.08 2,460,632.05 1,038,491.67 (1,625,045.72) 186.71 42906 OTHER GOVT AGENCY FEES 35,000.00 0.00 35,133.94 0.00 (133.94) 100.38 43100 MEMBERSHIP & DUES 9,422.00 100.00 4,962.58 0.00 4,459.42 52.67 43200 CONFERENCE, TRAINING & TRAVEL 15,910.00 1,415.37 10,567.78 0.00 5,342.22 66.42 43500 BOOKS 17,119.60 0.00 19,411.60 0.00 (2,292.00) 113.38 43724 OUTSIDE SERVICES - LABOR 250,393.12 7,198.25 223,119.53 156,812.92 (129,539.33) 151.73 43727 INSPECTION 0.00 0.00 90,320.85 486,223.00 (576,543.85) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,502,192.32 389,575.08 3,130,074.92 1,681,527.59 (2,309,410.19) 192.29 TOTAL FOR COMMUNITY DEVELOPMENT DEPT7,363,939.48 855,802.70 7,046,055.02 1,681,527.59 (1,363,643.13) 118.51 30 FIRE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 11,814,269.41 1,358,155.03 11,344,450.89 0.00 469,818.52 96.02 41101 SPECIAL ASSIGNMENT PAY 0.00 828.20 2,058.67 0.00 (2,058.67) 0.00 41140 FINAL LEAVE 0.00 7,813.47 97,320.58 0.00 (97,320.58) 0.00 41141 SP COMP-BILINGUAL 64,949.92 6,941.24 58,760.16 0.00 6,189.76 90.46 41149 SP COMP-PARAMEDIC CQI COORD 5,979.96 690.00 5,996.43 0.00 (16.47) 100.27 41150 SP COMP-HAZRDOUS PAY 91,184.64 8,548.41 72,974.62 0.00 18,210.02 80.02 41151 SP COMP-SECONDARY MEDIC 155,006.16 19,800.06 162,834.69 0.00 (7,828.53) 105.05 41153 SP COMP-ACTING FIRE ENG 0.00 136.44 1,064.81 0.00 (1,064.81) 0.00 41154 SP COMP-ACTING FIRE CAPT 0.00 58.62 533.80 0.00 (533.80) 0.00 41155 SP COMP-ACTING BATTALION CHIEF 0.00 0.00 249.23 0.00 (249.23) 0.00 41200 TEMPORARY EMPLOYEES 123,057.91 7,957.11 57,310.18 0.00 65,747.73 46.57 41300 OVERTIME 1,040,000.00 8,007.79 485,544.17 0.00 554,455.83 46.68 41310 OVERTIME - FLSA 577,563.00 33,826.26 276,737.59 0.00 300,825.41 47.91 41330 CONSTANT STAFF LEVELS-OT FIRE 4,798,071.06 544,735.15 4,836,787.80 0.00 (38,716.74) 100.80 41350 OVERTIME - TRAINING 487,435.52 61,428.08 528,503.89 0.00 (41,068.37) 108.42 41400 SPECIAL DUTY PAY 20,000.00 1,798.22 18,540.40 0.00 1,459.60 92.70 41420 FIRE HOLIDAY PAY 585,301.08 70,180.36 425,742.42 0.00 159,558.66 72.73 41500 DEFERRED COMPENSATION MATCH 6,200.00 1,000.00 6,200.00 0.00 0.00 100.00 41510 PST DEFERRED COMPENSATION 1,048.30 100.65 713.87 0.00 334.43 68.09 41520 TIERED EMP DEF COMPENSATION 2,400.00 600.00 2,400.00 0.00 0.00 100.00 41530 TIERED RHS BENEFIT 409,500.00 96,750.00 395,901.97 0.00 13,598.03 96.67 41600 LONGEVITY 331,200.28 39,352.38 331,066.46 0.00 133.82 99.95 41660 TUITION REIMBURSEMENT 106,523.00 15,632.07 69,231.81 0.00 37,291.19 64.99 41700 ANNUAL LEAVE BUYBACK 119,458.14 0.00 119,458.14 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 34,047.02 0.00 34,047.02 0.00 0.00 100.00 41800 UNIFORM ALLOWANCE 2,200.00 253.86 2,206.16 0.00 (6.16) 100.28 41910 PERS-NORMAL 2,700,033.64 301,640.70 2,521,326.14 0.00 178,707.50 93.38 JULIEK Page: 12 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41912 PERS-UNFUNDED 21,410.00 0.00 21,410.00 0.00 0.00 100.00 41920 MEDICARE 403,419.50 34,088.15 299,431.05 0.00 103,988.45 74.22 41929 SHORT TERM DISABILITY 37,805.66 5,540.88 46,410.69 0.00 (8,605.03) 122.76 41930 LONG TERM DISABILITY 80,337.03 9,189.84 76,975.34 0.00 3,361.69 95.81 41931 WORKERS COMP 691,784.71 79,531.55 657,553.26 0.00 34,231.45 95.05 41932 STATE UNEMPLOYMENT INSURANCE 9,672.98 1,079.11 9,403.21 0.00 269.77 97.21 41940 HEALTH INSURANCE 2,290,155.84 143,396.52 1,683,723.71 0.00 606,432.13 73.52 41945 OPT OUT HEALTH INSURANCE 28,800.00 10,000.00 125,242.27 0.00 (96,442.27) 434.86 41946 LIFE INSURANCE 98,058.43 11,216.95 93,952.40 0.00 4,106.03 95.81 41951 HEALTH ALLOWANCE CREDIT 0.00 3,944.60 65,320.68 0.00 (65,320.68) 0.00 41997 BUDGETARY/PAYROLL (4,806.89) 0.00 0.00 0.00 (4,806.89) 0.00 TOTAL FOR SALARIES-BENEFITS 27,132,066.30 2,884,221.70 24,937,384.51 0.00 2,194,681.79 91.91

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 7,600.00 0.00 5,329.46 0.00 2,270.54 70.12 42020 MINOR EQUIPMENT & FURNITURE 305,258.41 26,472.02 319,065.78 11,098.69 (24,906.06) 108.15 42025 HOSE AND APPLIANCE 25,000.00 13,910.63 28,638.65 0.00 (3,638.65) 114.55 42026 HAZMAT EQUIPMENT 80,392.00 131.95 55,898.01 0.00 24,493.99 69.53 42027 TECHNICAL RESCUE EQUIPMENT 35,000.00 595.31 37,967.98 0.00 (2,967.98) 108.47 42028 SCBA BREATHING APPARATUS 15,000.00 2,491.43 10,590.92 3,510.07 899.01 94.00 42033 CONSTRUCTION MATERIALS 0.00 0.00 103.48 0.00 (103.48) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 0.00 2,744.88 0.00 (2,744.88) 0.00 42055 COMPUTER EQUIPMENT & 43,969.00 574.71 28,929.08 10,157.00 4,882.92 88.89 42100 UNIFORM EXPENSE 36,600.00 44.00 44,221.18 0.00 (7,621.18) 120.82 42101 SAFETY SHOES - MOU ITEM 2,400.00 0.00 979.60 0.00 1,420.40 40.81 42105 PROTECTIVE CLOTHING 302,989.00 36,254.14 208,860.01 5,611.88 88,517.11 70.78 42110 EMS SUPPLIES 248,000.00 15,665.83 125,058.26 19,610.90 103,330.84 58.33 42200 ADVERTISING EXPENSE 500.00 0.00 290.41 0.00 209.59 58.08 42220 PROMOTIONAL/PUBLIC OUTREACH 8,000.00 0.00 0.00 0.00 8,000.00 0.00 42300 WIRELESS COMMUNICATION 54,500.00 2,750.45 41,110.22 0.00 13,389.78 75.43 42305 PBLC SFTY RADIO COMMUNICATION 267,797.00 34,770.70 41,510.89 0.00 226,286.11 15.50 42310 PHONES, FAX, ISDN LINES 6,000.00 1,112.26 7,148.20 0.00 (1,148.20) 119.13 42320 POSTAGE & SHIPPING 1,400.00 33.31 3,496.24 0.00 (2,096.24) 249.73 42340 OFFICE SUPPLIES 9,500.00 507.28 9,590.51 0.00 (90.51) 100.95 42350 PROGRAM EXPENDITURES 75,911.90 4,840.72 58,341.71 0.00 17,570.19 76.85 42360 CLEANING/JANITORIAL SUPPLIES 27,200.00 3,219.19 29,569.58 0.00 (2,369.58) 108.71 42365 RECYCLED CONTENT PRODUCTS 0.00 939.32 2,472.33 0.00 (2,472.33) 0.00 42441 UNLEADED FUEL 0.00 0.00 128.69 0.00 (128.69) 0.00 42600 MOTOR POOL RENTAL 1,147,675.00 0.00 1,147,678.00 0.00 (3.00) 100.00 42605 RETAINED VEHICLE EXPENSE 5,081.00 0.00 5,081.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 27,000.00 3,652.36 14,357.84 0.00 12,642.16 53.17 JULIEK Page: 13 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
42640 MDC RENTAL RATES 59,120.00 0.00 41,420.00 0.00 17,700.00 70.06 42700 OTHER EQUIPMENT RENTAL 2,000.00 0.00 1,445.85 0.00 554.15 72.29 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 0.00 0.00 500.00 0.00 42800 EQUIPMENT MAINTENANCE 19,900.00 0.00 20,633.12 326.42 (1,059.54) 105.32 42810 BUILDING MAINTENANCE 47,900.00 19,127.00 46,892.97 2,029.69 (1,022.66) 102.13 42900 PROF. & CONT. SVCS 634,556.00 28,751.45 300,340.73 72,788.12 261,427.15 58.80 42907 EMS SUBSCRIPTION ADMIN 60,000.00 0.00 0.00 0.00 60,000.00 0.00 42912 CAD DISPATCH SERVICES 174,260.00 6,848.70 51,065.11 46,300.00 76,894.89 55.87 43100 MEMBERSHIP & DUES 8,850.00 230.00 8,603.62 0.00 246.38 97.21 43200 CONFERENCE, TRAINING & TRAVEL 83,500.00 4,379.89 77,272.95 0.00 6,227.05 92.54 43500 BOOKS 5,000.00 675.99 6,032.17 0.00 (1,032.17) 120.64 43600 DISASTER PREPAREDNESS 4,000.00 2,094.03 8,768.24 0.00 (4,768.24) 219.20 43714 OUTSIDE LAB ANALYSIS 0.00 2,684.00 2,684.00 0.00 (2,684.00) 0.00 43716 JOB REQ CERTIFICATES & LICENSE 20,000.00 650.00 19,351.81 0.00 648.19 96.75 TOTAL FOR SERVICES-SUPPLIES 3,852,359.31 213,406.67 2,813,673.48 171,432.77 867,253.06 77.48

CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 50,444.56 0.00 34,431.34 0.00 16,013.22 68.25 TOTAL FOR CAPITAL OUTLAY 50,444.56 0.00 34,431.34 0.00 16,013.22 68.25 TOTAL FOR FIRE 31,034,870.17 3,097,628.37 27,785,489.33 171,432.77 3,077,948.07 90.08 32 POLICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 22,565,695.13 2,246,245.91 19,336,674.30 0.00 3,229,020.83 85.69 41101 SPECIAL ASSIGNMENT PAY 0.00 3.88 1,604.18 0.00 (1,604.18) 0.00 41102 SHIFT DIFFERENTIAL 130,000.00 14,147.60 99,140.26 0.00 30,859.74 76.26 41105 INCENTIVE PAY PROGRAM 0.00 15,000.00 47,500.00 0.00 (47,500.00) 0.00 41140 FINAL LEAVE 0.00 12,090.40 277,719.24 0.00 (277,719.24) 0.00 41141 SP COMP-BILINGUAL 197,015.58 23,934.85 209,611.68 0.00 (12,596.10) 106.39 41143 SP COMP-CGEA TRAINING OFFICER 0.00 168.70 1,400.72 0.00 (1,400.72) 0.00 41144 SP COMP-LEAD ANIMAL CTRL 0.00 0.00 1,828.11 0.00 (1,828.11) 0.00 41145 SP COMP-LEAD RECORDS TECH 8,659.92 499.62 4,520.37 0.00 4,139.55 52.19 41157 SP COMP-ACCIDENT INVESTIGATION 0.00 620.40 5,550.79 0.00 (5,550.79) 0.00 41158 SP COMP-MOTOR OFFICER 30,540.64 4,342.80 39,061.46 0.00 (8,520.82) 127.89 41159 SP COMP-INTERMEDIATE POST 434,081.62 5,199.80 46,617.19 0.00 387,464.43 10.73 41160 SP COMP-ADVANCED POST 662,016.55 104,247.74 988,205.11 0.00 (326,188.56) 149.27 41161 SP COMP-SUPERVISOR POST 23,985.17 0.00 0.00 0.00 23,985.17 0.00 41162 SP COMP-MGMT POST 39,975.29 7,677.21 66,747.93 0.00 (26,772.64) 166.97 41164 SP COMP-CANINE PAY 16,562.00 3,097.56 30,443.84 0.00 (13,881.84) 183.81 41165 SP COMP-SCHOOL RESOURCE OFFCR 21,249.95 2,397.12 21,860.69 0.00 (610.74) 102.87 41166 SP COMP-INVESTIGATIVE UNIT 38,780.21 3,459.12 34,362.82 0.00 4,417.39 88.60 JULIEK Page: 14 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41167 SP COMP-TRAFFIC CPL/SGT 7,060.56 841.08 9,176.33 0.00 (2,115.77) 129.96 41168 SP COMP-RELIEF WATCH CMND 28,242.24 2,661.67 23,513.17 0.00 4,729.07 83.25 41169 SP COMP-SPEC ENFORC TEAM 5,474.56 0.00 0.00 0.00 5,474.56 0.00 41171 SP COMP-SR DETECTIVE 50,776.18 3,566.52 42,680.54 0.00 8,095.64 84.05 41172 SP COMP-COMMERCIAL 5,208.32 620.40 6,196.17 0.00 (987.85) 118.96 41173 SP COMP-PACT TEAM 5,474.56 1,193.60 11,783.10 0.00 (6,308.54) 215.23 41174 SP COMP-PERSONNEL OFFICER 21,099.52 1,272.60 11,275.16 0.00 9,824.36 53.43 41176 SP COMP-DETECTIVE SGT 22,569.47 2,523.24 24,199.92 0.00 (1,630.45) 107.22 41177 SP COMP-PROFESSIONAL STND UNIT 8,619.52 801.00 7,165.85 0.00 1,453.67 83.13 41178 SP COMP-PERSONNEL & TRAINING 6,752.63 827.72 7,646.07 0.00 (893.44) 113.23 41179 SP COMP-TRAINING OFFICER 5,208.32 3,524.31 35,468.76 0.00 (30,260.44) 681.00 41180 SP COMP-YOUTH DIVERSION 5,612.88 1,509.72 13,347.51 0.00 (7,734.63) 237.80 41182 SP COMP-TACTICAL FLIGHT OFFCR 5,208.32 0.00 0.00 0.00 5,208.32 0.00 41183 SP COMP-HOPE-HMLS OUTRCH & 22,685.52 2,369.32 22,381.07 0.00 304.45 98.65 41184 SP COMP-FLEX TEAM OFFICER/CORP 22,951.76 2,148.40 25,064.45 0.00 (2,112.69) 109.20 41200 TEMPORARY EMPLOYEES 540,430.20 17,040.12 131,747.79 0.00 408,682.41 24.37 41300 OVERTIME 2,245,052.07 548,106.14 4,409,612.43 0.00 (2,164,560.36) 196.41 41310 OVERTIME - FLSA 0.00 508.15 7,587.00 0.00 (7,587.00) 0.00 41320 COMP TIME 532,715.00 89,298.95 939,627.01 0.00 (406,912.01) 176.38 41400 SPECIAL DUTY PAY 119,315.00 10,941.13 95,911.64 0.00 23,403.36 80.38 41500 DEFERRED COMPENSATION MATCH 31,600.00 2,970.00 30,175.00 0.00 1,425.00 95.49 41510 PST DEFERRED COMPENSATION 6,694.86 121.69 1,393.14 0.00 5,301.72 20.80 41520 TIERED EMP DEF COMPENSATION 18,600.00 4,200.00 17,100.00 0.00 1,500.00 91.93 41530 TIERED RHS BENEFIT 675,991.67 157,025.00 628,204.45 0.00 47,787.22 92.93 41600 LONGEVITY 432,560.54 67,596.12 595,492.05 0.00 (162,931.51) 137.66 41601 MARKSMANSHIP 65,788.10 6,689.10 58,990.81 0.00 6,797.29 89.66 41660 TUITION REIMBURSEMENT 40,804.00 2,430.00 19,505.87 0.00 21,298.13 47.80 41700 ANNUAL LEAVE BUYBACK 821,740.65 0.00 821,740.65 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 35,917.28 0.00 35,917.28 0.00 0.00 100.00 41800 UNIFORM ALLOWANCE 553,395.87 59,723.80 527,705.92 0.00 25,689.95 95.35 41910 PERS-NORMAL 5,195,787.41 555,523.01 4,784,269.74 0.00 411,517.67 92.07 41920 MEDICARE 866,709.69 97,511.38 886,662.22 0.00 (19,952.53) 102.30 41929 SHORT TERM DISABILITY 72,210.21 9,717.63 82,928.54 0.00 (10,718.33) 114.84 41930 LONG TERM DISABILITY 153,446.73 9,624.23 137,402.15 0.00 16,044.58 89.54 41931 WORKERS COMP 1,280,678.01 132,896.06 1,143,981.93 0.00 136,696.08 89.32 41932 STATE UNEMPLOYMENT INSURANCE 14,767.42 1,672.13 15,068.56 0.00 (301.14) 102.03 41940 HEALTH INSURANCE 4,399,096.23 243,619.48 2,819,478.24 0.00 1,579,617.99 64.09 41945 OPT OUT HEALTH INSURANCE 116,928.00 28,244.00 518,257.28 0.00 (401,329.28) 443.22 41946 LIFE INSURANCE 187,295.28 19,671.85 167,871.83 0.00 19,423.45 89.62 41951 HEALTH ALLOWANCE CREDIT 0.00 7,510.88 110,877.92 0.00 (110,877.92) 0.00 JULIEK Page: 15 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41996 VACANCY FACTOR (546,374.00) 0.00 0.00 0.00 (546,374.00) 0.00 41997 BUDGETARY/PAYROLL (293,681.65) 0.00 0.00 0.00 (293,681.65) 0.00 41999 PAYROLL SUSPENSE 0.00 53,312.02 460,401.58 0.00 (460,401.58) 0.00 TOTAL FOR SALARIES-BENEFITS 41,958,974.99 4,592,945.16 40,900,657.82 0.00 1,058,317.17 97.47

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 1,157.00 101.00 749.56 0.00 407.44 64.78 42020 MINOR EQUIPMENT & FURNITURE 212,396.98 18,635.51 156,283.85 12,089.80 44,023.33 79.27 42033 CONSTRUCTION MATERIALS 0.00 0.00 65.10 0.00 (65.10) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 275.00 0.00 640.46 0.00 (365.46) 232.89 42055 COMPUTER EQUIPMENT & 17,194.00 443.65 26,454.03 0.00 (9,260.03) 153.85 42100 UNIFORM EXPENSE 50,950.00 8,804.16 63,513.60 8,254.52 (20,818.12) 140.85 42101 SAFETY SHOES - MOU ITEM 10,050.00 0.00 1,759.54 0.00 8,290.46 17.50 42105 PROTECTIVE CLOTHING 38,991.32 0.00 19,365.41 0.00 19,625.91 49.66 42110 EMS SUPPLIES 0.00 0.00 32.93 0.00 (32.93) 0.00
42300 WIRELESS COMMUNICATION 62,250.00 5,197.57 62,625.18 0.00 (375.18) 100.60 42305 PBLC SFTY RADIO COMMUNICATION 173,373.00 31,647.54 197,378.77 0.00 (24,005.77) 113.84 42310 PHONES, FAX, ISDN LINES 36,450.00 3,373.77 30,081.95 0.00 6,368.05 82.52 42320 POSTAGE & SHIPPING 20,120.00 443.16 17,040.52 0.00 3,079.48 84.69 42340 OFFICE SUPPLIES 46,900.00 3,034.46 40,826.97 0.00 6,073.03 87.05 42345 FIRST AID KIT SUPPLIES 200.00 0.00 105.38 0.00 94.62 52.69 42350 PROGRAM EXPENDITURES 259,232.05 17,141.79 256,206.44 1,943.99 1,081.62 99.58 42360 CLEANING/JANITORIAL SUPPLIES 15,000.00 1,174.62 17,410.71 0.00 (2,410.71) 116.07 42365 RECYCLED CONTENT PRODUCTS 0.00 791.12 3,856.28 0.00 (3,856.28) 0.00 42410 ELECTRIC UTILITY 0.00 0.00 4,940.18 0.00 (4,940.18) 0.00 42441 UNLEADED FUEL 0.00 0.00 63.94 0.00 (63.94) 0.00
42500 RENTS & LEASES 1.00 0.00 0.00 0.00 1.00 0.00
42600 MOTOR POOL RENTAL 1,870,465.00 0.00 1,823,657.00 0.00 46,808.00 97.49 42605 RETAINED VEHICLE EXPENSE 76,852.00 0.00 72,803.00 0.00 4,049.00 94.73 42610 DIRECT VEHICLE EXPENSE 2,249.00 0.00 0.00 0.00 2,249.00 0.00 42640 MDC RENTAL RATES 151,410.00 0.00 151,410.00 0.00 0.00 100.00 42710 MILEAGE/VEHICLE EXP REIMB 0.00 0.00 42.84 0.00 (42.84) 0.00 42800 EQUIPMENT MAINTENANCE 119,100.00 0.00 62,779.98 61,758.54 (5,438.52) 104.56 42810 BUILDING MAINTENANCE 25,450.00 3,165.96 19,506.23 0.00 5,943.77 76.64 42840 FACILITY RENTALS 2,000.00 0.00 0.00 0.00 2,000.00 0.00 42900 PROF. & CONT. SVCS 1,222,547.20 127,706.80 1,107,658.65 162,324.10 (47,435.55) 103.88 42905 SPECIAL INVESTIGATIONS 11,050.00 4,839.30 18,916.21 0.00 (7,866.21) 171.18 43100 MEMBERSHIP & DUES 11,279.00 405.00 8,242.67 0.00 3,036.33 73.07 43200 CONFERENCE, TRAINING & TRAVEL 72,090.00 13,403.85 66,895.15 0.00 5,194.85 92.79 43220 P.O.S.T. CONFERENCE & TRAINING 65,702.00 519.23 51,112.85 0.00 14,589.15 77.79 43500 BOOKS 0.00 0.00 39.95 0.00 (39.95) 0.00
JULIEK Page: 16 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
43715 REGULATORY PERMIT & USE FEES 705.00 0.00 1,753.87 0.00 (1,048.87) 248.77 TOTAL FOR SERVICES-SUPPLIES 4,575,439.55 240,828.49 4,284,219.20 246,370.95 44,849.40 99.01

CAPITAL OUTLAY
45100 LICENSED VEHICLES 161,175.01 43,778.33 43,778.33 134,799.41 (17,402.73) 110.79 TOTAL FOR CAPITAL OUTLAY 161,175.01 43,778.33 43,778.33 134,799.41 (17,402.73) 110.79 TOTAL FOR POLICE 46,695,589.55 4,877,551.98 45,228,655.35 381,170.36 1,085,763.84 97.67 39 PUBLIC WORKS

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,556,145.86 162,559.39 1,339,894.08 0.00 216,251.78 86.10 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 (18.84) 0.00 18.84 0.00 41103 OUT OF CLASS PAY 0.00 83.60 756.44 0.00 (756.44) 0.00 41140 FINAL LEAVE 0.00 0.00 5,528.71 0.00 (5,528.71) 0.00 41141 SP COMP-BILINGUAL 13,711.83 2,164.21 16,063.32 0.00 (2,351.49) 117.14 41200 TEMPORARY EMPLOYEES 14,710.92 0.00 64.54 0.00 14,646.38 0.43 41300 OVERTIME 106,650.00 16,032.58 134,583.09 0.00 (27,933.09) 126.19 41320 COMP TIME 0.00 2,137.32 8,091.24 0.00 (8,091.24) 0.00 41400 SPECIAL DUTY PAY 27,000.00 5,866.77 51,217.08 0.00 (24,217.08) 189.69 41410 AUTO ALLOWANCE 3,052.80 352.26 3,051.71 0.00 1.09 99.96 41500 DEFERRED COMPENSATION MATCH 8,633.00 771.11 6,432.61 0.00 2,200.39 74.51 41510 PST DEFERRED COMPENSATION 191.24 0.00 0.84 0.00 190.40 0.43 41520 TIERED EMP DEF COMPENSATION 5,928.00 1,461.00 5,863.02 0.00 64.98 98.90 41530 TIERED RHS BENEFIT 2,796.00 745.00 2,973.48 0.00 (177.48) 106.34 41600 LONGEVITY 14,128.08 1,468.94 13,013.15 0.00 1,114.93 92.10 41700 ANNUAL LEAVE BUYBACK 54,549.78 0.00 54,549.78 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 2,613.25 0.00 2,613.25 0.00 0.00 100.00 41910 PERS-NORMAL 172,586.55 18,156.01 150,548.54 0.00 22,038.01 87.23 41920 MEDICARE 53,250.58 5,717.53 50,236.62 0.00 3,013.96 94.34 41929 SHORT TERM DISABILITY 4,979.66 706.36 5,770.36 0.00 (790.70) 115.87 41930 LONG TERM DISABILITY 10,581.79 1,171.69 9,570.89 0.00 1,010.90 90.44 41931 WORKERS COMP 32,352.04 3,360.09 27,758.88 0.00 4,593.16 85.80 41932 STATE UNEMPLOYMENT INSURANCE 894.92 96.41 850.08 0.00 44.84 94.98 41940 HEALTH INSURANCE 398,173.23 23,271.77 232,249.98 0.00 165,923.25 58.32 41945 OPT OUT HEALTH INSURANCE 7,440.00 2,356.00 52,725.98 0.00 (45,285.98) 708.68 41946 LIFE INSURANCE 12,916.01 1,430.17 11,682.49 0.00 1,233.52 90.44 41951 HEALTH ALLOWANCE CREDIT 0.00 615.31 8,383.88 0.00 (8,383.88) 0.00 41996 VACANCY FACTOR (101,582.00) 0.00 0.00 0.00 (101,582.00) 0.00 41997 BUDGETARY/PAYROLL 18,593.69 0.00 0.00 0.00 18,593.69 0.00 TOTAL FOR SALARIES-BENEFITS 2,420,297.23 250,523.52 2,194,455.20 0.00 225,842.03 90.66

SERVICES-SUPPLIES
JULIEK Page: 17 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
42020 MINOR EQUIPMENT & FURNITURE 3,500.00 13,269.42 16,859.66 0.00 (13,359.66) 481.70 42033 CONSTRUCTION MATERIALS 60,000.00 12,540.73 94,916.33 21,963.71 (56,880.04) 194.80 42034 SAFETY MATERIALS/CONSTRUCTION 7,700.00 785.97 7,756.93 0.00 (56.93) 100.73 42055 COMPUTER EQUIPMENT & 13,550.00 181.54 9,379.29 0.00 4,170.71 69.21 42100 UNIFORM EXPENSE 7,800.00 499.31 9,684.72 0.00 (1,884.72) 124.16 42101 SAFETY SHOES - MOU ITEM 5,367.00 0.00 669.65 0.00 4,697.35 12.47 42200 ADVERTISING EXPENSE 300.00 0.00 4,515.00 0.00 (4,215.00) 1,505.00 42220 PROMOTIONAL/PUBLIC OUTREACH 17,500.00 0.00 0.00 0.00 17,500.00 0.00 42300 WIRELESS COMMUNICATION 13,020.00 1,642.49 19,469.29 0.00 (6,449.29) 149.53 42320 POSTAGE & SHIPPING 251.00 2.98 126.64 0.00 124.36 50.45 42340 OFFICE SUPPLIES 7,600.00 124.14 4,324.66 0.00 3,275.34 56.90 42345 FIRST AID KIT SUPPLIES 200.00 0.00 61.74 0.00 138.26 30.87 42350 PROGRAM EXPENDITURES 35,000.00 1,579.63 20,743.57 0.00 14,256.43 59.26 42360 CLEANING/JANITORIAL SUPPLIES 200.00 184.88 556.74 0.00 (356.74) 278.37 42441 UNLEADED FUEL 1,500.00 95.44 2,338.59 0.00 (838.59) 155.90 42442 DIESEL FUEL 500.00 0.00 319.80 0.00 180.20 63.96
42600 MOTOR POOL RENTAL 418,741.25 5,670.86 408,044.29 0.00 10,696.96 97.44 42605 RETAINED VEHICLE EXPENSE 13,014.00 0.00 13,014.00 0.00 0.00 100.00 42700 OTHER EQUIPMENT RENTAL 1,800.00 0.00 17,345.03 3,728.49 (19,273.52) 1,170.75 42710 MILEAGE/VEHICLE EXP REIMB 1,650.00 0.00 0.00 0.00 1,650.00 0.00 42800 EQUIPMENT MAINTENANCE 5,000.00 0.00 0.00 0.00 5,000.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 270,000.00 1,532.94 101,154.74 16,597.81 152,247.45 43.61 42816 MOWING/LANDSCAPE CONTRACTS 70,000.00 7,440.00 23,382.40 34,734.51 11,883.09 83.02 42900 PROF. & CONT. SVCS 1,038,643.75 63,618.71 629,924.42 140,617.43 268,101.90 74.18 43100 MEMBERSHIP & DUES 3,700.00 0.00 2,761.80 0.00 938.20 74.64 43200 CONFERENCE, TRAINING & TRAVEL 20,880.00 52.58 3,983.40 0.00 16,896.60 19.07 43715 REGULATORY PERMIT & USE FEES 1,700.00 0.00 557.00 0.00 1,143.00 32.76 43716 JOB REQ CERTIFICATES & LICENSE 5,500.00 0.00 0.00 0.00 5,500.00 0.00 43722 PREVENTION & MAINTENANCE 10,200.00 0.00 9,551.88 0.00 648.12 93.64 43724 OUTSIDE SERVICES - LABOR 140,032.64 0.00 22,020.00 12,634.80 105,377.84 24.74 43727 INSPECTION 337,659.25 0.00 123,472.00 77,796.25 136,391.00 59.60 TOTAL FOR SERVICES-SUPPLIES 2,512,508.89 109,221.62 1,546,933.57 308,073.00 657,502.32 73.83

CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 122.86 0.00 (122.86) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 122.86 0.00 (122.86) 0.00 TOTAL FOR PUBLIC WORKS 4,932,806.12 359,745.14 3,741,511.63 308,073.00 883,221.49 82.09 41 MAINTENANCE SERVICES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 (1,322.45) 0.00 0.00 0.00 0.00 JULIEK Page: 18 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41141 SP COMP-BILINGUAL 0.00 (3.96) 0.00 0.00 0.00 0.00 41148 SP COMP-GRADE 5 CERT PAY 0.00 (5.32) 0.00 0.00 0.00 0.00 41300 OVERTIME 0.00 (0.32) 0.00 0.00 0.00 0.00
41400 SPECIAL DUTY PAY 0.00 (10.58) 0.00 0.00 0.00 0.00 41410 AUTO ALLOWANCE 0.00 (2.06) 0.00 0.00 0.00 0.00
41600 LONGEVITY 0.00 (17.67) 0.00 0.00 0.00 0.00
41910 PERS-NORMAL 0.00 (146.87) 0.00 0.00 0.00 0.00
41920 MEDICARE 0.00 (41.40) 0.00 0.00 0.00 0.00
41929 SHORT TERM DISABILITY 0.00 (5.43) 0.00 0.00 0.00 0.00 41930 LONG TERM DISABILITY 0.00 (8.99) 0.00 0.00 0.00 0.00 41931 WORKERS COMP 0.00 (26.69) 0.00 0.00 0.00 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 (0.71) 0.00 0.00 0.00 0.00 41940 HEALTH INSURANCE 0.00 (846.66) 0.00 0.00 0.00 0.00 41945 OPT OUT HEALTH INSURANCE 0.00 (51.00) 0.00 0.00 0.00 0.00 41946 LIFE INSURANCE 0.00 (10.98) 0.00 0.00 0.00 0.00
TOTAL FOR SALARIES-BENEFITS 0.00 (2,501.09) 0.00 0.00 0.00 0.00

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 (818.39) 0.00 0.00 0.00 0.00 42033 CONSTRUCTION MATERIALS 0.00 (1,991.63) 0.00 0.00 0.00 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 (335.84) 0.00 0.00 0.00 0.00 42350 PROGRAM EXPENDITURES 0.00 (1,011.87) 0.00 0.00 0.00 0.00 42360 CLEANING/JANITORIAL SUPPLIES 0.00 (551.86) 0.00 0.00 0.00 0.00 42710 MILEAGE/VEHICLE EXP REIMB 0.00 (240.00) 0.00 0.00 0.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 2,242.29 0.00 0.00 0.00 0.00 43722 PREVENTION & MAINTENANCE 0.00 (289.29) 0.00 0.00 0.00 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 (2,996.59) 0.00 0.00 0.00 0.00

CAPITAL OUTLAY
TOTAL FOR CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL FOR MAINTENANCE SERVICES 0.00 (5,497.68) 0.00 0.00 0.00 0.00 47 COMMUNITY SERVICES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 3,028,615.85 291,546.22 2,677,656.21 0.00 350,959.64 88.41 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 13.99 0.00 (13.99) 0.00 41103 OUT OF CLASS PAY 0.00 3,520.52 3,520.52 0.00 (3,520.52) 0.00 41140 FINAL LEAVE 0.00 9,666.45 177,719.87 0.00 (177,719.87) 0.00 41141 SP COMP-BILINGUAL 56,217.39 3,618.60 28,070.81 0.00 28,146.58 49.93 41200 TEMPORARY EMPLOYEES 2,049,865.89 230,367.17 1,673,998.21 0.00 375,867.68 81.66 41300 OVERTIME 188,276.00 21,416.56 250,006.96 0.00 (61,730.96) 132.78 41320 COMP TIME 0.00 1,043.89 8,531.00 0.00 (8,531.00) 0.00 JULIEK Page: 19 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41400 SPECIAL DUTY PAY 25,337.00 10,154.88 79,422.52 0.00 (54,085.52) 313.46 41410 AUTO ALLOWANCE 4,780.80 0.00 4,459.42 0.00 321.38 93.27 41500 DEFERRED COMPENSATION MATCH 20,269.45 1,230.00 13,225.92 0.00 7,043.53 65.25 41510 PST DEFERRED COMPENSATION 21,132.98 2,664.37 19,020.05 0.00 2,112.93 90.00 41520 TIERED EMP DEF COMPENSATION 11,100.00 1,800.00 8,848.50 0.00 2,251.50 79.71 41530 TIERED RHS BENEFIT 6,700.00 1,100.00 5,248.50 0.00 1,451.50 78.33 41600 LONGEVITY 18,680.58 1,897.40 17,092.09 0.00 1,588.49 91.49 41660 TUITION REIMBURSEMENT 0.00 1,984.47 3,372.47 0.00 (3,372.47) 0.00 41700 ANNUAL LEAVE BUYBACK 117,341.88 0.00 117,341.88 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 3,031.90 0.00 3,031.90 0.00 0.00 100.00 41910 PERS-NORMAL 399,882.46 35,674.16 308,638.48 0.00 91,243.98 77.18 41920 MEDICARE 132,701.15 13,704.20 126,941.28 0.00 5,759.87 95.65 41929 SHORT TERM DISABILITY 9,691.57 1,215.65 10,677.31 0.00 (985.74) 110.17 41930 LONG TERM DISABILITY 20,594.58 2,016.34 17,709.32 0.00 2,885.26 85.99 41931 WORKERS COMP 103,351.27 10,689.69 86,454.09 0.00 16,897.18 83.65 41932 STATE UNEMPLOYMENT INSURANCE 2,742.52 290.48 2,575.21 0.00 167.31 93.89 41940 HEALTH INSURANCE 808,687.00 39,747.49 450,058.37 0.00 358,628.63 55.65 41945 OPT OUT HEALTH INSURANCE 14,400.00 5,398.90 85,030.78 0.00 (70,630.78) 590.49 41946 LIFE INSURANCE 25,137.79 2,460.96 21,614.64 0.00 3,523.15 85.98 41951 HEALTH ALLOWANCE CREDIT 0.00 1,419.90 19,664.37 0.00 (19,664.37) 0.00 41996 VACANCY FACTOR (305,181.00) 0.00 0.00 0.00 (305,181.00) 0.00 41997 BUDGETARY/PAYROLL 22,941.40 0.00 0.00 0.00 22,941.40 0.00 TOTAL FOR SALARIES-BENEFITS 6,786,298.46 694,628.30 6,219,944.67 0.00 566,353.79 91.65

SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,400.00 550.00 4,500.00 0.00 900.00 83.33 42010 SUBSCRIPTIONS 8,279.00 550.94 7,177.48 0.00 1,101.52 86.69 42012 AUDIO VISUAL 15,000.00 0.00 15,000.00 0.00 0.00 100.00 42014 ELECTRONIC INFO RESOURCES 49,164.00 13,000.00 48,906.13 0.00 257.87 99.47 42020 MINOR EQUIPMENT & FURNITURE 20,513.00 4,710.28 32,286.30 0.00 (11,773.30) 157.39 42030 BUILDING MAINTENANCE SUPPLIES 0.00 0.00 5,430.41 0.00 (5,430.41) 0.00 42033 CONSTRUCTION MATERIALS 318,921.48 28,116.66 541,812.32 66,503.74 (289,394.58) 190.74 42034 SAFETY MATERIALS/CONSTRUCTION 2,000.00 2,561.51 11,753.23 0.00 (9,753.23) 587.66 42055 COMPUTER EQUIPMENT & 24,655.46 5,114.58 21,807.86 5,926.96 (3,079.36) 112.48 42100 UNIFORM EXPENSE 16,314.00 1,419.95 24,066.86 0.00 (7,752.86) 147.52 42101 SAFETY SHOES - MOU ITEM 9,260.00 0.00 5,705.52 0.00 3,554.48 61.61 42200 ADVERTISING EXPENSE 2,300.00 0.00 3,837.06 0.00 (1,537.06) 166.82 42220 PROMOTIONAL/PUBLIC OUTREACH 9,050.00 606.56 1,407.69 0.00 7,642.31 15.55 42300 WIRELESS COMMUNICATION 32,722.00 2,811.16 32,388.66 0.00 333.34 98.98 42310 PHONES, FAX, ISDN LINES 10,488.00 2,139.44 13,324.26 0.00 (2,836.26) 127.04 42320 POSTAGE & SHIPPING 31,200.00 100.53 36,501.99 0.00 (5,301.99) 116.99 JULIEK Page: 20 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
42340 OFFICE SUPPLIES 16,230.00 1,087.67 16,500.41 0.00 (270.41) 101.66 42345 FIRST AID KIT SUPPLIES 2,035.00 536.83 5,978.85 0.00 (3,943.85) 293.80 42350 PROGRAM EXPENDITURES 266,412.38 48,685.16 355,171.41 33,462.28 (122,221.31) 145.87 42360 CLEANING/JANITORIAL SUPPLIES 0.00 760.22 1,129.98 0.00 (1,129.98) 0.00 42410 ELECTRIC UTILITY 0.00 281.73 1,601.97 0.00 (1,601.97) 0.00 42430 WATER UTILITY 0.00 2,989.25 11,352.24 0.00 (11,352.24) 0.00 42435 RECYCLED WATER UTILITY 0.00 584.42 5,382.83 0.00 (5,382.83) 0.00 42441 UNLEADED FUEL 5,548.00 203.92 4,183.04 0.00 1,364.96 75.39 42500 RENTS & LEASES 3,800.00 0.00 0.00 0.00 3,800.00 0.00 42600 MOTOR POOL RENTAL 258,365.00 0.00 212,349.00 0.00 46,016.00 82.18 42605 RETAINED VEHICLE EXPENSE 15,088.00 0.00 15,318.92 0.00 (230.92) 101.53 42610 DIRECT VEHICLE EXPENSE 40,713.96 0.00 1,485.80 0.00 39,228.16 3.64 42630 PARTS/LABOR ON CITY VEHICLES 700.00 0.00 0.00 0.00 700.00 0.00 42700 OTHER EQUIPMENT RENTAL 34,700.00 27,309.57 44,023.49 1,133.42 (10,456.91) 130.13 42710 MILEAGE/VEHICLE EXP REIMB 1,276.00 292.40 667.30 0.00 608.70 52.29 42800 EQUIPMENT MAINTENANCE 41,566.00 0.00 26,898.73 0.00 14,667.27 64.71 42810 BUILDING MAINTENANCE 7,995.00 2,160.00 8,155.00 0.00 (160.00) 102.00 42811 MAINTENANCE & OPERATING 115,000.00 2,103.85 6,021.91 0.00 108,978.09 5.23 42813 MTCE & REPAIR - EQUIP & FAC 654,955.81 69,746.05 1,049,960.09 360,870.56 (755,874.84) 215.40 42815 SCADA MAINTENANCE 4,000.00 0.00 0.00 0.00 4,000.00 0.00 42816 MOWING/LANDSCAPE CONTRACTS 1,668,109.73 485,536.94 1,668,765.42 193,057.63 (193,713.32) 111.61 42819 GRAFFITI REMOVAL 339,055.00 (18,445.00) 231,538.00 136,907.00 (29,390.00) 108.66 42821 TREE MAINTENANCE 996,017.00 134,236.00 1,492,441.70 45,000.00 (541,424.70) 154.35 42822 VANDALISM 11,000.00 0.00 0.00 5,000.00 6,000.00 45.45 42840 FACILITY RENTALS 7,000.00 0.00 0.00 0.00 7,000.00 0.00 42900 PROF. & CONT. SVCS 2,008,354.71 145,883.91 1,430,450.87 516,832.64 61,071.20 96.95 42910 REFUSE DISPOSAL 0.00 8,006.17 17,558.88 0.00 (17,558.88) 0.00 43000 INSURANCE & SURETY BONDS 8,700.00 0.00 8,060.00 0.00 640.00 92.64 43100 MEMBERSHIP & DUES 8,061.00 0.00 4,293.14 0.00 3,767.86 53.25 43200 CONFERENCE, TRAINING & TRAVEL 27,667.74 241.22 29,548.70 644.26 (2,525.22) 109.12 43301 CAPITAL IMPROVEMENTS 0.00 0.00 419.93 0.00 (419.93) 0.00 43500 BOOKS 20,000.00 11,442.74 20,266.28 0.00 (266.28) 101.33 43501 CHILDREN'S BOOKS 30,000.00 6,854.13 32,913.35 0.00 (2,913.35) 109.71 43505 PASSPORT EXPENSES 31,675.00 1,786.38 32,220.29 0.00 (545.29) 101.72 43715 REGULATORY PERMIT & USE FEES 10,637.00 1,698.94 9,031.85 0.00 1,605.15 84.90 43716 JOB REQ CERTIFICATES & LICENSE 1,200.00 0.00 407.00 0.00 793.00 33.91 43722 PREVENTION & MAINTENANCE 449,831.86 30,341.80 211,238.32 36,153.00 202,440.54 54.99 TOTAL FOR SERVICES-SUPPLIES 7,640,961.13 1,026,005.91 7,761,240.47 1,401,491.49 (1,521,770.83) 119.91

CAPITAL OUTLAY
45100 LICENSED VEHICLES 25,775.00 0.00 0.00 0.00 25,775.00 0.00 JULIEK Page: 21 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
TOTAL FOR CAPITAL OUTLAY 25,775.00 0.00 0.00 0.00 25,775.00 0.00 TOTAL FOR COMMUNITY SERVICES 14,453,034.59 1,720,634.21 13,981,185.14 1,401,491.49 (929,642.04) 106.43 65 PARK MAINTENANCE/LMD

SALARIES-BENEFITS
41300 OVERTIME 0.00 533.68 0.00 0.00 0.00 0.00
41920 MEDICARE 0.00 15.70 0.00 0.00 0.00 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.27 0.00 0.00 0.00 0.00 41940 HEALTH INSURANCE 0.00 87.30 0.00 0.00 0.00 0.00
TOTAL FOR SALARIES-BENEFITS 0.00 636.95 0.00 0.00 0.00 0.00

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 (3,021.53) 0.00 0.00 0.00 0.00 42033 CONSTRUCTION MATERIALS 0.00 (9,824.23) 0.00 0.00 0.00 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 (663.39) 0.00 0.00 0.00 0.00 42340 OFFICE SUPPLIES 0.00 (3.24) 0.00 0.00 0.00 0.00
42350 PROGRAM EXPENDITURES 0.00 (9,398.27) 0.00 0.00 0.00 0.00 42430 WATER UTILITY 0.00 (1,708.90) 0.00 0.00 0.00 0.00 42435 RECYCLED WATER UTILITY 0.00 (373.84) 0.00 0.00 0.00 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 (24,555.70) 0.00 0.00 0.00 0.00 42816 MOWING/LANDSCAPE CONTRACTS 0.00 (16,125.30) 0.00 0.00 0.00 0.00 42819 GRAFFITI REMOVAL 0.00 18,445.00 0.00 0.00 0.00 0.00 42910 REFUSE DISPOSAL 0.00 (3,848.92) 0.00 0.00 0.00 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 (51,078.32) 0.00 0.00 0.00 0.00 TOTAL FOR PARK MAINTENANCE/LMD 0.00 (50,441.37) 0.00 0.00 0.00 0.00 FUN 110 177,873,014.89 15,599,840.97 151,643,116.33 5,864,184.37 20,365,714.19 88.55 JULIEK Page: 22 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
120 MEASURE X FUND
00 NOT APPLICABLE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 2,220.46 16,722.55 0.00 (16,722.55) 0.00 41141 SP COMP-BILINGUAL 0.00 8.71 46.27 0.00 (46.27) 0.00 41300 OVERTIME 0.00 0.00 3,774.48 0.00 (3,774.48) 0.00
41320 COMP TIME 0.00 0.00 430.95 0.00 (430.95) 0.00
41520 TIERED EMP DEF COMPENSATION 0.00 0.00 47.81 0.00 (47.81) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 47.81 0.00 (47.81) 0.00 41600 LONGEVITY 0.00 10.57 183.06 0.00 (183.06) 0.00
41910 PERS-NORMAL 0.00 243.66 1,861.43 0.00 (1,861.43) 0.00 41920 MEDICARE 0.00 66.96 617.70 0.00 (617.70) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 22.82 0.00 (22.82) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 37.88 0.00 (37.88) 0.00 41931 WORKERS COMP 0.00 44.72 336.30 0.00 (336.30) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 1.15 10.51 0.00 (10.51) 0.00 41940 HEALTH INSURANCE 0.00 0.00 936.06 0.00 (936.06) 0.00 41946 LIFE INSURANCE 0.00 0.00 46.20 0.00 (46.20) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 25.84 0.00 (25.84) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 2,596.23 25,147.67 0.00 (25,147.67) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 9,371,095.61 0.00 0.00 0.00 9,371,095.61 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 215.30 5,493.73 24,820.59 (30,314.32) 0.00 42028 SCBA BREATHING APPARATUS 515,064.92 4,770.63 1,325,819.78 0.00 (810,754.86) 257.40 42033 CONSTRUCTION MATERIALS 0.00 0.00 1,419.73 0.00 (1,419.73) 0.00 42055 COMPUTER EQUIPMENT & 0.00 0.00 426.81 0.00 (426.81) 0.00 42200 ADVERTISING EXPENSE 0.00 0.00 1,045.99 0.00 (1,045.99) 0.00 42320 POSTAGE & SHIPPING 0.00 0.00 130.76 0.00 (130.76) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 1,961.52 0.00 (1,961.52) 0.00 42435 RECYCLED WATER UTILITY 0.00 251.55 2,519.82 0.00 (2,519.82) 0.00 42900 PROF. & CONT. SVCS 120,019.99 125,833.04 512,901.12 433,055.38 (825,936.51) 788.16 43300 CONSTRUCTION CONTRACTS 0.00 16,959.00 21,319.90 986,535.00 (1,007,854.90) 0.00 43301 CAPITAL IMPROVEMENTS 0.00 0.00 131,102.36 0.00 (131,102.36) 0.00 43715 REGULATORY PERMIT & USE FEES 0.00 0.00 1,822.97 0.00 (1,822.97) 0.00 43727 INSPECTION 0.00 0.00 28,356.00 0.00 (28,356.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 10,006,180.52 148,029.52 2,034,320.49 1,444,410.97 6,527,449.06 34.76

CAPITAL OUTLAY
45100 LICENSED VEHICLES 1,832,904.32 23,811.36 99,149.84 1,553,315.84 180,438.64 90.15 45200 MACHINERY, EQUIPMENT, & FIXTUR 0.00 0.00 119,995.00 0.00 (119,995.00) 0.00 TOTAL FOR CAPITAL OUTLAY 1,832,904.32 23,811.36 219,144.84 1,553,315.84 60,443.64 96.70 JULIEK Page: 23 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
TOTAL FOR NOT APPLICABLE 11,839,084.84 174,437.11 2,278,613.00 2,997,726.81 6,562,745.03 44.56 11 CITY MANAGER'S OFFICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 561,683.80 51,519.60 459,741.89 0.00 101,941.91 81.85 41141 SP COMP-BILINGUAL 3,870.00 0.00 3,125.85 0.00 744.15 80.77 41300 OVERTIME 5,000.00 0.00 5,286.38 0.00 (286.38) 105.72 41910 PERS-NORMAL 61,532.25 5,605.32 50,371.40 0.00 11,160.85 81.86 41920 MEDICARE 17,375.70 1,553.13 14,318.59 0.00 3,057.11 82.40 41929 SHORT TERM DISABILITY 1,797.38 211.22 1,884.91 0.00 (87.53) 104.86 41930 LONG TERM DISABILITY 3,819.45 350.36 3,126.21 0.00 693.24 81.84 41931 WORKERS COMP 11,311.07 1,025.11 9,200.86 0.00 2,110.21 81.34 41932 STATE UNEMPLOYMENT INSURANCE 292.48 26.33 243.60 0.00 48.88 83.28 41940 HEALTH INSURANCE 98,559.36 4,241.53 57,037.37 0.00 41,521.99 57.87 41945 OPT OUT HEALTH INSURANCE 14,400.00 600.00 14,021.30 0.00 378.70 97.37 41946 LIFE INSURANCE 4,661.97 427.58 3,815.78 0.00 846.19 81.84 41951 HEALTH ALLOWANCE CREDIT 0.00 141.96 3,441.54 0.00 (3,441.54) 0.00 TOTAL FOR SALARIES-BENEFITS 784,303.46 65,702.14 625,615.68 0.00 158,687.78 79.76

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 6,000.00 0.00 5,988.00 0.00 12.00 99.80 42020 MINOR EQUIPMENT & FURNITURE 14,500.00 0.00 10,487.14 0.00 4,012.86 72.32 42033 CONSTRUCTION MATERIALS 0.00 0.00 314.62 0.00 (314.62) 0.00 42055 COMPUTER EQUIPMENT & 0.00 0.00 178.99 0.00 (178.99) 0.00 42200 ADVERTISING EXPENSE 400.00 0.00 0.00 0.00 400.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 600.00 0.00 0.00 0.00 600.00 0.00 42300 WIRELESS COMMUNICATION 5,168.00 41.39 396.16 0.00 4,771.84 7.66 42320 POSTAGE & SHIPPING 400.00 0.00 0.00 0.00 400.00 0.00 42340 OFFICE SUPPLIES 2,000.00 0.00 47.31 0.00 1,952.69 2.36 42350 PROGRAM EXPENDITURES 318,406.47 1,200.00 146,075.06 8,874.48 163,456.93 48.66 42710 MILEAGE/VEHICLE EXP REIMB 1,000.00 0.00 0.00 0.00 1,000.00 0.00 42900 PROF. & CONT. SVCS 3,438,337.64 715,776.33 2,275,391.12 1,448,574.94 (285,628.42) 108.30 43100 MEMBERSHIP & DUES 690.00 0.00 0.00 0.00 690.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 3,000.00 0.00 0.00 0.00 3,000.00 0.00 43722 PREVENTION & MAINTENANCE 271.94 0.00 210.00 901.94 (840.00) 408.89 TOTAL FOR SERVICES-SUPPLIES 3,790,774.05 717,017.72 2,439,088.40 1,458,351.36 (106,665.71) 102.81 TOTAL FOR CITY MANAGER'S OFFICE 4,575,077.51 782,719.86 3,064,704.08 1,458,351.36 52,022.07 98.86 13 DEBT SERVICE

SERVICES-SUPPLIES
44001 DS PRINCIPAL 2021 POBS 1,662,992.00 0.00 1,396,309.39 0.00 266,682.61 83.96 44101 DS INTEREST 2021 POBS 0.00 0.00 414,714.96 0.00 (414,714.96) 0.00 JULIEK Page: 24 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
TOTAL FOR SERVICES-SUPPLIES 1,662,992.00 0.00 1,811,024.35 0.00 (148,032.35) 108.90 TOTAL FOR DEBT SERVICE 1,662,992.00 0.00 1,811,024.35 0.00 (148,032.35) 108.90 15 HUMAN RESOURCES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 305,720.20 36,386.40 235,934.44 0.00 69,785.76 77.17 41103 OUT OF CLASS PAY 0.00 0.00 330.40 0.00 (330.40) 0.00 41141 SP COMP-BILINGUAL 0.00 446.55 595.40 0.00 (595.40) 0.00 41300 OVERTIME 0.00 11.68 11.68 0.00 (11.68) 0.00
41700 ANNUAL LEAVE BUYBACK 3,675.40 0.00 3,675.40 0.00 0.00 100.00 41910 PERS-NORMAL 33,262.36 4,007.40 25,734.44 0.00 7,527.92 77.36 41920 MEDICARE 9,341.01 1,119.31 7,436.82 0.00 1,904.19 79.61 41929 SHORT TERM DISABILITY 978.30 149.19 967.29 0.00 11.01 98.87 41930 LONG TERM DISABILITY 2,078.90 247.44 1,604.41 0.00 474.49 77.17 41931 WORKERS COMP 6,114.40 735.93 4,733.17 0.00 1,381.23 77.41 41932 STATE UNEMPLOYMENT INSURANCE 157.70 19.20 127.48 0.00 30.22 80.83 41940 HEALTH INSURANCE 58,580.16 1,514.28 16,222.60 0.00 42,357.56 27.69 41945 OPT OUT HEALTH INSURANCE 7,200.00 1,000.00 10,782.16 0.00 (3,582.16) 149.75 41946 LIFE INSURANCE 2,537.48 302.01 1,958.26 0.00 579.22 77.17 41951 HEALTH ALLOWANCE CREDIT 0.00 37.08 552.08 0.00 (552.08) 0.00 TOTAL FOR SALARIES-BENEFITS 429,645.91 45,976.47 310,666.03 0.00 118,979.88 72.30

SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 2,500.00 0.00 0.00 0.00 2,500.00 0.00 42350 PROGRAM EXPENDITURES 25,000.00 735.40 6,608.25 0.00 18,391.75 26.43 TOTAL FOR SERVICES-SUPPLIES 27,500.00 735.40 6,608.25 0.00 20,891.75 24.03 TOTAL FOR HUMAN RESOURCES 457,145.91 46,711.87 317,274.28 0.00 139,871.63 69.40 17 INFORMATION TECHNOLOGY

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 83,144.53 9,907.20 75,642.24 0.00 7,502.29 90.97 41300 OVERTIME 0.00 123.84 2,267.76 0.00 (2,267.76) 0.00 41400 SPECIAL DUTY PAY 0.00 0.00 400.00 0.00 (400.00) 0.00 41910 PERS-NORMAL 9,046.13 1,077.90 8,229.84 0.00 816.29 90.97 41920 MEDICARE 2,460.86 293.39 2,292.25 0.00 168.61 93.14 41929 SHORT TERM DISABILITY 266.06 40.62 310.19 0.00 (44.13) 116.58 41930 LONG TERM DISABILITY 565.38 67.38 514.43 0.00 50.95 90.98 41931 WORKERS COMP 1,662.89 196.05 1,497.06 0.00 165.83 90.02 41932 STATE UNEMPLOYMENT INSURANCE 41.57 5.02 39.34 0.00 2.23 94.63 41940 HEALTH INSURANCE 24,639.84 1,925.90 22,605.95 0.00 2,033.89 91.74 41946 LIFE INSURANCE 690.10 82.23 627.82 0.00 62.28 90.97 41951 HEALTH ALLOWANCE CREDIT 0.00 78.84 693.40 0.00 (693.40) 0.00 JULIEK Page: 25 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
TOTAL FOR SALARIES-BENEFITS 122,517.36 13,798.37 115,120.28 0.00 7,397.08 93.96

SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 300.00 0.00 0.00 0.00 300.00 0.00 42912 CAD DISPATCH SERVICES 520,475.00 0.00 167,415.00 0.00 353,060.00 32.16 TOTAL FOR SERVICES-SUPPLIES 520,775.00 0.00 167,415.00 0.00 353,360.00 32.14

CAPITAL OUTLAY
45300 COMPUTER SOFTWARE 100,000.00 0.00 0.00 0.00 100,000.00 0.00 TOTAL FOR CAPITAL OUTLAY 100,000.00 0.00 0.00 0.00 100,000.00 0.00 TOTAL FOR INFORMATION TECHNOLOGY 743,292.36 13,798.37 282,535.28 0.00 460,757.08 38.01 18 FINANCE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 185,203.20 11,539.20 95,627.20 0.00 89,576.00 51.63 41141 SP COMP-BILINGUAL 0.00 446.55 3,870.10 0.00 (3,870.10) 0.00 41500 DEFERRED COMPENSATION MATCH 0.00 600.00 1,900.00 0.00 (1,900.00) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 150.00 600.00 0.00 (600.00) 0.00 41530 TIERED RHS BENEFIT 0.00 150.00 600.00 0.00 (600.00) 0.00 41600 LONGEVITY 0.00 184.59 1,530.57 0.00 (1,530.57) 0.00 41700 ANNUAL LEAVE BUYBACK 3,533.60 0.00 3,533.60 0.00 0.00 100.00 41910 PERS-NORMAL 20,150.11 1,324.14 10,991.90 0.00 9,158.21 54.55 41920 MEDICARE 5,478.19 379.51 3,149.59 0.00 2,328.60 57.49 41929 SHORT TERM DISABILITY 592.65 47.31 392.10 0.00 200.55 66.16 41930 LONG TERM DISABILITY 1,259.38 78.48 650.34 0.00 609.04 51.63 41931 WORKERS COMP 3,704.06 238.05 1,979.95 0.00 1,724.11 53.45 41932 STATE UNEMPLOYMENT INSURANCE 92.60 6.14 52.87 0.00 39.73 57.09 41940 HEALTH INSURANCE 49,279.68 1,968.54 23,075.45 0.00 26,204.23 46.82 41946 LIFE INSURANCE 1,537.19 95.79 793.78 0.00 743.41 51.63 41951 HEALTH ALLOWANCE CREDIT 0.00 86.34 1,579.80 0.00 (1,579.80) 0.00 TOTAL FOR SALARIES-BENEFITS 270,830.66 17,294.64 150,327.25 0.00 120,503.41 55.50

SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 4,000.00 536.97 536.97 0.00 3,463.03 13.42 TOTAL FOR SERVICES-SUPPLIES 4,000.00 536.97 536.97 0.00 3,463.03 13.42 TOTAL FOR FINANCE 274,830.66 17,831.61 150,864.22 0.00 123,966.44 54.89 19 ECONOMIC DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 226,077.04 25,598.41 219,500.81 0.00 6,576.23 97.09 41141 SP COMP-BILINGUAL 3,870.00 446.55 3,870.10 0.00 (0.10) 100.00 41910 PERS-NORMAL 25,018.24 2,833.66 24,302.67 0.00 715.57 97.13 41920 MEDICARE 6,789.52 778.10 6,869.44 0.00 (79.92) 101.17 JULIEK Page: 26 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41929 SHORT TERM DISABILITY 723.45 104.94 899.96 0.00 (176.51) 124.39 41930 LONG TERM DISABILITY 1,537.32 174.06 1,492.56 0.00 44.76 97.08 41931 WORKERS COMP 4,598.94 514.50 4,415.36 0.00 183.58 96.00 41932 STATE UNEMPLOYMENT INSURANCE 114.97 13.36 117.85 0.00 (2.88) 102.50 41940 HEALTH INSURANCE 43,237.68 1,514.26 17,750.31 0.00 25,487.37 41.05 41945 OPT OUT HEALTH INSURANCE 0.00 600.00 11,669.94 0.00 (11,669.94) 0.00 41946 LIFE INSURANCE 1,876.44 212.46 1,821.72 0.00 54.72 97.08 41951 HEALTH ALLOWANCE CREDIT 0.00 36.82 860.16 0.00 (860.16) 0.00 TOTAL FOR SALARIES-BENEFITS 313,843.60 32,827.12 293,570.88 0.00 20,272.72 93.54

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 20,800.00 0.00 0.00 0.00 20,800.00 0.00 42200 ADVERTISING EXPENSE 7,500.00 0.00 0.00 0.00 7,500.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 6,500.00 0.00 0.00 0.00 6,500.00 0.00 42300 WIRELESS COMMUNICATION 650.00 0.00 0.00 0.00 650.00 0.00 42320 POSTAGE & SHIPPING 800.00 0.00 0.00 0.00 800.00 0.00 42840 FACILITY RENTALS 1,000.00 0.00 0.00 0.00 1,000.00 0.00 42900 PROF. & CONT. SVCS 49,572.36 0.00 43,470.52 0.00 6,101.84 87.69 43200 CONFERENCE, TRAINING & TRAVEL 4,000.00 0.00 0.00 0.00 4,000.00 0.00 TOTAL FOR SERVICES-SUPPLIES 90,822.36 0.00 43,470.52 0.00 47,351.84 47.86 TOTAL FOR ECONOMIC DEVELOPMENT 404,665.96 32,827.12 337,041.40 0.00 67,624.56 83.28 20 LEGAL AND RISK MANAGEMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 162,864.00 19,171.20 145,588.80 0.00 17,275.20 89.39 41141 SP COMP-BILINGUAL 3,870.00 0.00 0.00 0.00 3,870.00 0.00 41910 PERS-NORMAL 18,140.66 2,085.84 15,840.08 0.00 2,300.58 87.31 41920 MEDICARE 4,920.11 569.66 4,329.99 0.00 590.12 88.00 41929 SHORT TERM DISABILITY 521.16 78.60 596.88 0.00 (75.72) 114.52 41930 LONG TERM DISABILITY 1,107.48 130.35 990.00 0.00 117.48 89.39 41931 WORKERS COMP 3,334.68 381.77 2,901.84 0.00 432.84 87.02 41932 STATE UNEMPLOYMENT INSURANCE 83.37 9.68 73.62 0.00 9.75 88.30 41940 HEALTH INSURANCE 24,639.84 1,972.64 19,202.69 0.00 5,437.15 77.93 41946 LIFE INSURANCE 1,351.77 159.12 1,208.37 0.00 143.40 89.39 41951 HEALTH ALLOWANCE CREDIT 0.00 86.34 1,225.88 0.00 (1,225.88) 0.00 TOTAL FOR SALARIES-BENEFITS 220,833.07 24,645.20 191,958.15 0.00 28,874.92 86.92 TOTAL FOR LEGAL AND RISK MANAGEMENT 220,833.07 24,645.20 191,958.15 0.00 28,874.92 86.92 21 COMMUNITY DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 893,943.40 41,547.96 302,732.95 0.00 591,210.45 33.86 41140 FINAL LEAVE 0.00 0.00 3,004.99 0.00 (3,004.99) 0.00 JULIEK Page: 27 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41141 SP COMP-BILINGUAL 8,531.10 0.00 1,658.54 0.00 6,872.56 19.44 41300 OVERTIME 0.00 0.00 22.93 0.00 (22.93) 0.00
41500 DEFERRED COMPENSATION MATCH 0.00 600.00 1,300.00 0.00 (1,300.00) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 150.00 300.00 0.00 (300.00) 0.00 41530 TIERED RHS BENEFIT 0.00 150.00 300.00 0.00 (300.00) 0.00 41600 LONGEVITY 0.00 666.36 3,665.26 0.00 (3,665.26) 0.00 41700 ANNUAL LEAVE BUYBACK 1,654.00 0.00 1,654.00 0.00 0.00 100.00 41910 PERS-NORMAL 98,189.23 4,592.94 33,516.61 0.00 64,672.62 34.13 41920 MEDICARE 26,734.03 1,282.98 9,539.49 0.00 17,194.54 35.68 41929 SHORT TERM DISABILITY 2,860.62 192.57 1,351.80 0.00 1,508.82 47.25 41930 LONG TERM DISABILITY 6,078.81 319.41 2,242.02 0.00 3,836.79 36.88 41931 WORKERS COMP 18,049.49 831.62 6,071.86 0.00 11,977.63 33.64 41932 STATE UNEMPLOYMENT INSURANCE 451.24 21.53 162.07 0.00 289.17 35.91 41940 HEALTH INSURANCE 277,316.16 6,192.08 51,938.26 0.00 225,377.90 18.72 41945 OPT OUT HEALTH INSURANCE 0.00 400.00 7,874.12 0.00 (7,874.12) 0.00 41946 LIFE INSURANCE 7,419.73 389.88 2,736.84 0.00 4,682.89 36.88 41951 HEALTH ALLOWANCE CREDIT 0.00 244.38 1,975.90 0.00 (1,975.90) 0.00 TOTAL FOR SALARIES-BENEFITS 1,341,227.81 57,581.71 432,047.64 0.00 909,180.17 32.21

SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 17,720.00 0.00 0.00 0.00 17,720.00 0.00 42100 UNIFORM EXPENSE 500.00 0.00 0.00 0.00 500.00 0.00 42101 SAFETY SHOES - MOU ITEM 1,350.00 0.00 0.00 0.00 1,350.00 0.00 42300 WIRELESS COMMUNICATION 240.00 0.00 0.00 0.00 240.00 0.00 42441 UNLEADED FUEL 2,400.00 0.00 0.00 0.00 2,400.00 0.00 42600 MOTOR POOL RENTAL 12,396.00 0.00 0.00 0.00 12,396.00 0.00 43100 MEMBERSHIP & DUES 1,600.00 0.00 0.00 0.00 1,600.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 700.00 0.00 0.00 0.00 700.00 0.00 TOTAL FOR SERVICES-SUPPLIES 36,906.00 0.00 0.00 0.00 36,906.00 0.00 TOTAL FOR COMMUNITY DEVELOPMENT DEPT1,378,133.81 57,581.71 432,047.64 0.00 946,086.17 31.35 30 FIRE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,028,191.26 130,336.68 1,016,772.18 0.00 11,419.08 98.88 41141 SP COMP-BILINGUAL 22,650.00 698.07 3,026.90 0.00 19,623.10 13.36 41151 SP COMP-SECONDARY MEDIC 32,070.24 616.74 5,345.08 0.00 26,725.16 16.66 41154 SP COMP-ACTING FIRE CAPT 0.00 0.00 16.62 0.00 (16.62) 0.00 41155 SP COMP-ACTING BATTALION CHIEF 0.00 0.00 69.97 0.00 (69.97) 0.00 41200 TEMPORARY EMPLOYEES 180,985.26 12,220.08 87,409.54 0.00 93,575.72 48.29 41300 OVERTIME 0.00 0.00 5,813.82 0.00 (5,813.82) 0.00
41310 OVERTIME - FLSA 13,693.54 2,019.21 13,916.78 0.00 (223.24) 101.63 JULIEK Page: 28 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41330 CONSTANT STAFF LEVELS-OT FIRE 0.00 122.23 255.75 0.00 (255.75) 0.00 41350 OVERTIME - TRAINING 55,000.00 3,647.02 54,075.98 0.00 924.02 98.31 41400 SPECIAL DUTY PAY 0.00 416.16 3,709.84 0.00 (3,709.84) 0.00 41420 FIRE HOLIDAY PAY 29,490.06 4,487.25 23,126.33 0.00 6,363.73 78.42 41510 PST DEFERRED COMPENSATION 2,530.84 157.12 1,134.56 0.00 1,396.28 44.82 41530 TIERED RHS BENEFIT 20,000.00 5,000.00 19,223.03 0.00 776.97 96.11 41600 LONGEVITY 17,046.64 2,075.04 17,479.12 0.00 (432.48) 102.53 41660 TUITION REIMBURSEMENT 8,500.00 0.00 4,000.00 0.00 4,500.00 47.05 41910 PERS-NORMAL 182,491.04 22,297.35 176,074.50 0.00 6,416.54 96.48 41920 MEDICARE 20,227.77 2,751.13 22,597.71 0.00 (2,369.94) 111.71 41929 SHORT TERM DISABILITY 3,290.21 533.16 4,167.41 0.00 (877.20) 126.66 41930 LONG TERM DISABILITY 6,991.70 884.22 6,912.02 0.00 79.68 98.86 41931 WORKERS COMP 64,874.29 7,624.59 58,680.91 0.00 6,193.38 90.45 41932 STATE UNEMPLOYMENT INSURANCE 657.76 78.41 616.68 0.00 41.08 93.75 41940 HEALTH INSURANCE 206,419.20 13,702.08 134,562.76 0.00 71,856.44 65.18 41945 OPT OUT HEALTH INSURANCE 7,200.00 600.00 7,200.00 0.00 0.00 100.00 41946 LIFE INSURANCE 8,533.99 1,079.22 8,436.54 0.00 97.45 98.85 41951 HEALTH ALLOWANCE CREDIT 0.00 562.06 6,257.76 0.00 (6,257.76) 0.00 TOTAL FOR SALARIES-BENEFITS 1,910,843.80 211,907.82 1,680,881.79 0.00 229,962.01 87.96

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 608,000.00 10,485.29 531,043.14 7,812.00 69,144.86 88.62 42101 SAFETY SHOES - MOU ITEM 300.00 0.00 0.00 0.00 300.00 0.00 42305 PBLC SFTY RADIO COMMUNICATION 357,452.00 5,725.06 323,005.90 328.21 34,117.89 90.45 42600 MOTOR POOL RENTAL 331,100.00 0.00 331,097.00 0.00 3.00 99.99 42710 MILEAGE/VEHICLE EXP REIMB 0.00 0.00 170.69 0.00 (170.69) 0.00 43200 CONFERENCE, TRAINING & TRAVEL 15,000.00 0.00 13,840.40 0.00 1,159.60 92.26 TOTAL FOR SERVICES-SUPPLIES 1,311,852.00 16,210.35 1,199,157.13 8,140.21 104,554.66 92.02

CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 325,000.00 0.00 0.00 0.00 325,000.00 0.00 TOTAL FOR CAPITAL OUTLAY 325,000.00 0.00 0.00 0.00 325,000.00 0.00 TOTAL FOR FIRE 3,547,695.80 228,118.17 2,880,038.92 8,140.21 659,516.67 81.40 32 POLICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,356,162.43 144,506.24 1,237,927.55 0.00 118,234.88 91.28 41102 SHIFT DIFFERENTIAL 0.00 174.91 6,366.68 0.00 (6,366.68) 0.00 41105 INCENTIVE PAY PROGRAM 0.00 0.00 5,000.00 0.00 (5,000.00) 0.00 41140 FINAL LEAVE 0.00 0.00 1,547.43 0.00 (1,547.43) 0.00 41141 SP COMP-BILINGUAL 10,067.05 1,310.90 11,734.27 0.00 (1,667.22) 116.56 41143 SP COMP-CGEA TRAINING OFFICER 0.00 34.85 76.32 0.00 (76.32) 0.00 JULIEK Page: 29 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
41159 SP COMP-INTERMEDIATE POST 15,977.52 0.00 0.00 0.00 15,977.52 0.00 41160 SP COMP-ADVANCED POST 26,629.20 5,075.73 45,940.76 0.00 (19,311.56) 172.52 41167 SP COMP-TRAFFIC CPL/SGT 5,474.56 652.20 5,821.72 0.00 (347.16) 106.34 41179 SP COMP-TRAINING OFFICER 0.00 0.00 469.81 0.00 (469.81) 0.00 41181 SP COMP-POLICE SUPPORT SVCS 8,619.52 0.00 0.00 0.00 8,619.52 0.00 41183 SP COMP-HOPE-HMLS OUTRCH & 7,060.56 841.08 6,580.30 0.00 480.26 93.19 41184 SP COMP-FLEX TEAM OFFICER/CORP 0.00 357.28 357.28 0.00 (357.28) 0.00 41200 TEMPORARY EMPLOYEES 323,835.92 11,926.81 110,489.86 0.00 213,346.06 34.11 41300 OVERTIME 58,000.00 362.10 37,567.49 0.00 20,432.51 64.77 41310 OVERTIME - FLSA 0.00 0.00 292.50 0.00 (292.50) 0.00 41320 COMP TIME 12,000.00 0.00 10,097.64 0.00 1,902.36 84.14 41400 SPECIAL DUTY PAY 0.00 2,172.41 15,824.80 0.00 (15,824.80) 0.00 41500 DEFERRED COMPENSATION MATCH 500.00 0.00 0.00 0.00 500.00 0.00 41510 PST DEFERRED COMPENSATION 1,972.89 81.95 682.69 0.00 1,290.20 34.60 41520 TIERED EMP DEF COMPENSATION 600.00 0.00 0.00 0.00 600.00 0.00 41530 TIERED RHS BENEFIT 30,200.00 7,500.00 30,000.00 0.00 200.00 99.33 41600 LONGEVITY 10,740.00 2,941.92 26,377.87 0.00 (15,637.87) 245.60 41601 MARKSMANSHIP 2,520.00 290.70 2,509.41 0.00 10.59 99.57 41660 TUITION REIMBURSEMENT 0.00 1,388.00 4,287.50 0.00 (4,287.50) 0.00 41700 ANNUAL LEAVE BUYBACK 18,454.80 0.00 18,454.80 0.00 0.00 100.00 41800 UNIFORM ALLOWANCE 22,480.00 2,593.89 22,230.31 0.00 249.69 98.88 41910 PERS-NORMAL 270,877.20 29,441.17 255,868.70 0.00 15,008.50 94.45 41920 MEDICARE 49,006.01 4,988.09 46,076.18 0.00 2,929.83 94.02 41929 SHORT TERM DISABILITY 4,339.73 597.12 5,237.67 0.00 (897.94) 120.69 41930 LONG TERM DISABILITY 9,221.90 661.81 8,422.18 0.00 799.72 91.32 41931 WORKERS COMP 69,258.46 7,160.94 61,098.81 0.00 8,159.65 88.21 41932 STATE UNEMPLOYMENT INSURANCE 910.53 88.55 812.95 0.00 97.58 89.28 41940 HEALTH INSURANCE 326,598.96 13,582.19 167,506.84 0.00 159,092.12 51.28 41945 OPT OUT HEALTH INSURANCE 12,000.00 1,300.00 25,157.20 0.00 (13,157.20) 209.64 41946 LIFE INSURANCE 11,256.15 1,208.80 10,602.98 0.00 653.17 94.19 41951 HEALTH ALLOWANCE CREDIT 0.00 344.14 6,200.48 0.00 (6,200.48) 0.00 41997 BUDGETARY/PAYROLL 2,058.00 0.00 0.00 0.00 2,058.00 0.00 41999 PAYROLL SUSPENSE 0.00 841.12 13,910.80 0.00 (13,910.80) 0.00 TOTAL FOR SALARIES-BENEFITS 2,666,821.39 242,424.90 2,201,531.78 0.00 465,289.61 82.55

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 107,580.00 4,684.92 30,002.19 15,140.12 62,437.69 41.96 42055 COMPUTER EQUIPMENT & 7,240.00 0.00 0.00 0.00 7,240.00 0.00 42100 UNIFORM EXPENSE 0.00 0.00 27,061.25 0.00 (27,061.25) 0.00 42101 SAFETY SHOES - MOU ITEM 1,950.00 0.00 0.00 0.00 1,950.00 0.00 42105 PROTECTIVE CLOTHING 31,280.00 0.00 0.00 61,142.68 (29,862.68) 195.46 JULIEK Page: 30 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
42300 WIRELESS COMMUNICATION 112,065.00 157.80 114,177.90 0.00 (2,112.90) 101.88 42350 PROGRAM EXPENDITURES 1,250.00 1,250.00 2,763.49 0.00 (1,513.49) 221.07 42600 MOTOR POOL RENTAL 41,177.00 0.00 0.00 0.00 41,177.00 0.00 42640 MDC RENTAL RATES 4,326.00 0.00 0.00 0.00 4,326.00 0.00 42900 PROF. & CONT. SVCS 207,950.00 164,200.00 174,800.00 9,400.00 23,750.00 88.57 43200 CONFERENCE, TRAINING & TRAVEL 41,400.00 0.00 29,894.88 0.00 11,505.12 72.20 43220 P.O.S.T. CONFERENCE & TRAINING 56,600.00 1,915.00 42,782.81 0.00 13,817.19 75.58 TOTAL FOR SERVICES-SUPPLIES 612,818.00 172,207.72 421,482.52 85,682.80 105,652.68 82.75

CAPITAL OUTLAY
45100 LICENSED VEHICLES 196,445.03 0.00 44,445.03 64,055.85 87,944.15 55.23 TOTAL FOR CAPITAL OUTLAY 196,445.03 0.00 44,445.03 64,055.85 87,944.15 55.23 TOTAL FOR POLICE 3,476,084.42 414,632.62 2,667,459.33 149,738.65 658,886.44 81.04 39 PUBLIC WORKS

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 216,403.20 10,004.54 10,004.54 0.00 206,398.66 4.62 41200 TEMPORARY EMPLOYEES 17,596.80 0.00 0.00 0.00 17,596.80 0.00 41910 PERS-NORMAL 25,459.20 1,088.50 1,088.50 0.00 24,370.70 4.27 41920 MEDICARE 6,658.51 296.09 296.09 0.00 6,362.42 4.44 41929 SHORT TERM DISABILITY 692.49 41.02 41.02 0.00 651.47 5.92 41930 LONG TERM DISABILITY 1,471.54 68.03 68.03 0.00 1,403.51 4.62 41931 WORKERS COMP 4,680.00 200.10 200.10 0.00 4,479.90 4.27 41932 STATE UNEMPLOYMENT INSURANCE 117.00 5.08 5.08 0.00 111.92 4.34 41940 HEALTH INSURANCE 49,279.68 1,968.54 1,968.54 0.00 47,311.14 3.99 41946 LIFE INSURANCE 1,796.15 83.05 83.05 0.00 1,713.10 4.62 41951 HEALTH ALLOWANCE CREDIT 0.00 78.84 78.84 0.00 (78.84) 0.00 TOTAL FOR SALARIES-BENEFITS 324,154.57 13,833.79 13,833.79 0.00 310,320.78 4.26

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 17,400.00 4,784.56 4,784.56 0.00 12,615.44 27.49 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 414.62 414.62 0.00 (414.62) 0.00 42101 SAFETY SHOES - MOU ITEM 300.00 0.00 0.00 0.00 300.00 0.00 TOTAL FOR SERVICES-SUPPLIES 17,700.00 5,199.18 5,199.18 0.00 12,500.82 29.37

CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 180,006.00 0.00 125,631.21 197.94 54,176.85 69.90 TOTAL FOR CAPITAL OUTLAY 180,006.00 0.00 125,631.21 197.94 54,176.85 69.90 TOTAL FOR PUBLIC WORKS 521,860.57 19,032.97 144,664.18 197.94 376,998.45 27.75 41 MAINTENANCE SERVICES

SERVICES-SUPPLIES
JULIEK Page: 31 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR MAINTENANCE SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 47 COMMUNITY SERVICES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 779,859.80 74,170.14 656,703.75 0.00 123,156.05 84.20 41102 SHIFT DIFFERENTIAL 0.00 0.00 2.33 0.00 (2.33) 0.00 41140 FINAL LEAVE 0.00 3,174.89 6,255.53 0.00 (6,255.53) 0.00 41141 SP COMP-BILINGUAL 2,274.96 350.00 3,500.00 0.00 (1,225.04) 153.84 41200 TEMPORARY EMPLOYEES 197,202.48 15,951.53 92,421.42 0.00 104,781.06 46.86 41300 OVERTIME 29,484.00 13.35 17,562.04 0.00 11,921.96 59.56 41320 COMP TIME 0.00 428.78 1,561.75 0.00 (1,561.75) 0.00 41500 DEFERRED COMPENSATION MATCH 1,900.00 600.00 1,900.00 0.00 0.00 100.00 41510 PST DEFERRED COMPENSATION 2,633.14 165.92 1,198.09 0.00 1,435.05 45.50 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 600.00 0.00 0.00 100.00 41530 TIERED RHS BENEFIT 600.00 150.00 600.00 0.00 0.00 100.00 41600 LONGEVITY 1,600.00 242.28 1,811.31 0.00 (211.31) 113.20 41660 TUITION REIMBURSEMENT 2,500.00 0.00 4,164.00 0.00 (1,664.00) 166.56 41700 ANNUAL LEAVE BUYBACK 15,465.52 0.00 15,465.52 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 739.07 0.00 739.07 0.00 0.00 100.00 41910 PERS-NORMAL 87,869.21 8,513.88 72,426.02 0.00 15,443.19 82.42 41920 MEDICARE 27,437.75 2,603.79 22,730.30 0.00 4,707.45 82.84 41929 SHORT TERM DISABILITY 2,495.56 303.54 2,693.95 0.00 (198.39) 107.94 41930 LONG TERM DISABILITY 5,303.04 503.43 4,468.10 0.00 834.94 84.25 41931 WORKERS COMP 19,734.21 1,809.76 14,975.19 0.00 4,759.02 75.88 41932 STATE UNEMPLOYMENT INSURANCE 512.17 48.12 410.65 0.00 101.52 80.17 41940 HEALTH INSURANCE 203,638.80 8,518.39 94,723.71 0.00 108,915.09 46.51 41945 OPT OUT HEALTH INSURANCE 0.00 1,200.00 17,937.82 0.00 (17,937.82) 0.00 41946 LIFE INSURANCE 6,472.84 614.51 5,454.02 0.00 1,018.82 84.26 41951 HEALTH ALLOWANCE CREDIT 0.00 273.75 4,232.73 0.00 (4,232.73) 0.00 41997 BUDGETARY/PAYROLL (334.10) 0.00 0.00 0.00 (334.10) 0.00 TOTAL FOR SALARIES-BENEFITS 1,387,988.45 119,786.06 1,044,537.30 0.00 343,451.15 75.25

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 78,061.72 8,898.18 (86,959.90) 0.00 42033 CONSTRUCTION MATERIALS 9,500.00 5,274.42 5,274.42 3,058.14 1,167.44 87.71 42300 WIRELESS COMMUNICATION 0.00 0.00 228.47 0.00 (228.47) 0.00 42310 PHONES, FAX, ISDN LINES 0.00 0.00 255.94 0.00 (255.94) 0.00 42345 FIRST AID KIT SUPPLIES 367.00 0.00 0.00 0.00 367.00 0.00 42350 PROGRAM EXPENDITURES 41,665.00 4,385.06 19,134.40 0.00 22,530.60 45.92 42360 CLEANING/JANITORIAL SUPPLIES 500.00 0.00 0.00 0.00 500.00 0.00 JULIEK Page: 32 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
42410 ELECTRIC UTILITY 0.00 209.42 806.11 0.00 (806.11) 0.00 42420 NATURAL GAS UTILITY 0.00 0.00 490.08 0.00 (490.08) 0.00 42430 WATER UTILITY 0.00 8,659.76 9,490.82 0.00 (9,490.82) 0.00 42710 MILEAGE/VEHICLE EXP REIMB 350.00 0.00 0.00 0.00 350.00 0.00 42811 MAINTENANCE & OPERATING 200,000.00 0.00 0.00 44,850.00 155,150.00 22.42 42813 MTCE & REPAIR - EQUIP & FAC 256,650.00 111,791.18 206,207.38 44,284.04 6,158.58 97.60 42816 MOWING/LANDSCAPE CONTRACTS 51,499.00 0.00 2,646.00 17,186.00 31,667.00 38.50 42819 GRAFFITI REMOVAL 150,000.00 0.00 150,000.00 0.00 0.00 100.00 42821 TREE MAINTENANCE 700,000.00 154,110.00 355,784.00 0.00 344,216.00 50.82 42822 VANDALISM 4,000.00 0.00 0.00 0.00 4,000.00 0.00
42900 PROF. & CONT. SVCS 497,929.00 33,096.65 89,791.34 20,929.75 387,207.91 22.23 43500 BOOKS 25,000.00 0.00 26,957.03 0.00 (1,957.03) 107.82 43715 REGULATORY PERMIT & USE FEES 510.00 0.00 0.00 0.00 510.00 0.00 43722 PREVENTION & MAINTENANCE 37,258.00 966.00 27,966.00 16,038.00 (6,746.00) 118.10 TOTAL FOR SERVICES-SUPPLIES 1,975,228.00 318,492.49 973,093.71 155,244.11 846,890.18 57.12 TOTAL FOR COMMUNITY SERVICES 3,363,216.45 438,278.55 2,017,631.01 155,244.11 1,190,341.33 64.60 FUN 120 32,464,913.36 2,250,615.16 16,575,855.84 4,769,399.08 11,119,658.44 65.74 JULIEK Page: 33 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
232 CIVIC CENTER
00 NOT APPLICABLE

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 254,741.59 0.00 0.00 0.00 254,741.59 0.00 TOTAL FOR SERVICES-SUPPLIES 254,741.59 0.00 0.00 0.00 254,741.59 0.00 TOTAL FOR NOT APPLICABLE 254,741.59 0.00 0.00 0.00 254,741.59 0.00 41 MAINTENANCE SERVICES

SERVICES-SUPPLIES
42410 ELECTRIC UTILITY 0.00 (17,918.44) 0.00 0.00 0.00 0.00 42430 WATER UTILITY 0.00 (13,453.74) 0.00 0.00 0.00 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 (31,372.18) 0.00 0.00 0.00 0.00 TOTAL FOR MAINTENANCE SERVICES 0.00 (31,372.18) 0.00 0.00 0.00 0.00 47 COMMUNITY SERVICES

SERVICES-SUPPLIES
42033 CONSTRUCTION MATERIALS 5,024.31 138.15 358.23 2,000.00 2,666.08 46.93 42100 UNIFORM EXPENSE 0.00 0.00 47.62 0.00 (47.62) 0.00 42410 ELECTRIC UTILITY 63,000.00 18,775.55 56,365.92 0.00 6,634.08 89.46 42420 NATURAL GAS UTILITY 1,092.00 0.00 7,875.70 0.00 (6,783.70) 721.21 42430 WATER UTILITY 23,814.00 15,913.29 22,893.92 0.00 920.08 96.13 42700 OTHER EQUIPMENT RENTAL 0.00 0.00 477.11 122.89 (600.00) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 13,476.00 155.10 11,764.37 7,987.21 (6,275.58) 146.56 42822 VANDALISM 1,189.89 0.00 0.00 0.00 1,189.89 0.00
42900 PROF. & CONT. SVCS 35,752.00 3,487.48 31,898.06 2,652.11 1,201.83 96.63 43715 REGULATORY PERMIT & USE FEES 394.00 0.00 0.00 0.00 394.00 0.00 43722 PREVENTION & MAINTENANCE 12,275.20 185.00 2,352.00 1,155.20 8,768.00 28.57 TOTAL FOR SERVICES-SUPPLIES 156,017.40 38,654.57 134,032.93 13,917.41 8,067.06 94.82 TOTAL FOR COMMUNITY SERVICES 156,017.40 38,654.57 134,032.93 13,917.41 8,067.06 94.82 FUN 232 410,758.99 7,282.39 134,032.93 13,917.41 262,808.65 36.01 JULIEK Page: 34 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

GL
06/30/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2023
OB 12
Ledger:

Level:

Month to
GRAND TOTAL 210,748,687.24 17,857,738.52 168,353,005.10 10,647,500.86 31,748,181.28 84.93 JULIEK Page: 35 Current Date:

GLREREE5_Consolidated_Expenditure_Report
07/17/2023
Current Time: 09:39:40
User:

Report:

← All documents from this meeting