Corona City Council
May 1, 2024

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
110 GENERAL FUND
00 NOT APPLICABLE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 1,145.06 21,018.91 0.00 (21,018.91) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 50.31 0.00 (50.31) 0.00 41300 OVERTIME 0.00 0.00 863.78 0.00 (863.78) 0.00
41320 COMP TIME 0.00 0.00 833.87 0.00 (833.87) 0.00
41910 PERS-NORMAL 0.00 137.76 2,534.73 0.00 (2,534.73) 0.00 41920 MEDICARE 0.00 34.14 649.12 0.00 (649.12) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 3.64 0.00 (3.64) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 6.04 0.00 (6.04) 0.00 41931 WORKERS COMP 0.00 22.90 421.42 0.00 (421.42) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 1.05 20.03 0.00 (20.03) 0.00 41940 HEALTH INSURANCE 0.00 0.00 97.21 0.00 (97.21) 0.00 41946 LIFE INSURANCE 0.00 0.00 7.37 0.00 (7.37) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 4.06 0.00 (4.06) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 1,340.91 26,510.49 0.00 (26,510.49) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 14,350,043.36 0.00 0.00 0.00 14,350,043.36 0.00 42055 COMPUTER EQUIPMENT & 74,733.63 12,113.95 685,380.16 164,651.30 (775,297.83) 1,137.41 42200 ADVERTISING EXPENSE 0.00 352.09 1,328.69 0.00 (1,328.69) 0.00 42350 PROGRAM EXPENDITURES 0.00 101.00 101.00 0.00 (101.00) 0.00 42800 EQUIPMENT MAINTENANCE 0.00 0.00 (1,800.00) 0.00 1,800.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 184.89 184.89 0.00 (184.89) 0.00 42900 PROF. & CONT. SVCS 308,450.49 156,877.96 500,385.67 140,762.20 (332,697.38) 207.86 43300 CONSTRUCTION CONTRACTS 214,949.02 15,180.00 244,259.51 59,313.43 (88,623.92) 141.23 43301 CAPITAL IMPROVEMENTS 4,387.86 0.00 7,185.24 1,370,876.00 (1,373,673.38) 31,406.22 43500 BOOKS 0.00 0.00 2,034.04 907.51 (2,941.55) 0.00
43715 REGULATORY PERMIT & USE FEES 0.00 1,870.36 0.00 0.00 0.00 0.00 TOTAL FOR SERVICES-SUPPLIES 14,952,564.36 186,680.25 1,439,059.20 1,736,510.44 11,776,994.72 21.23

CAPITAL OUTLAY
45100 LICENSED VEHICLES 140,225.29 0.00 40,153.65 112,659.18 (12,587.54) 108.97 45200 MACHINERY, EQUIPMENT, & FIXTUR 38,396.42 0.00 144,050.53 38,396.42 (144,050.53) 475.16 45400 LAND 0.00 367,805.00 2,005,305.00 0.00 (2,005,305.00) 0.00 TOTAL FOR CAPITAL OUTLAY 178,621.71 367,805.00 2,189,509.18 151,055.60 (2,161,943.07) 1,310.34 TOTAL FOR NOT APPLICABLE 15,131,186.07 555,826.16 3,655,078.87 1,887,566.04 9,588,541.16 36.63 10 CITY COUNCIL

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 48,000.00 4,000.00 36,000.00 0.00 12,000.00 75.00 41510 PST DEFERRED COMPENSATION 125.00 10.40 93.94 0.00 31.06 75.15 JULIEK Page: 1 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41910 PERS-NORMAL 4,620.00 384.96 3,464.64 0.00 1,155.36 74.99 41920 MEDICARE 2,168.00 172.23 1,602.38 0.00 565.62 73.91 41931 WORKERS COMP 960.00 80.00 720.00 0.00 240.00 75.00 41940 HEALTH INSURANCE 36,947.00 2,790.12 26,881.75 0.00 10,065.25 72.75 41946 LIFE INSURANCE 330.00 27.60 248.40 0.00 81.60 75.27 TOTAL FOR SALARIES-BENEFITS 93,150.00 7,465.31 69,011.11 0.00 24,138.89 74.08

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 3,100.00 0.00 920.22 0.00 2,179.78 29.68 42055 COMPUTER EQUIPMENT & 1,000.00 0.00 0.00 0.00 1,000.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 11,000.00 50.03 2,044.64 0.00 8,955.36 18.58 42300 WIRELESS COMMUNICATION 3,600.00 0.00 2,290.39 0.00 1,309.61 63.62 42320 POSTAGE & SHIPPING 100.00 0.00 9.05 0.00 90.95 9.05 42340 OFFICE SUPPLIES 500.00 0.00 370.61 0.00 129.39 74.12 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 269.26 0.00 730.74 26.92 42355 MEETING EXPENDITURES 3,865.78 0.00 1,251.84 0.00 2,613.94 32.38 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 0.00 0.00 500.00 0.00 42800 EQUIPMENT MAINTENANCE 500.00 0.00 0.00 0.00 500.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 2,400.00 0.00 0.00 0.00 2,400.00 0.00 42900 PROF. & CONT. SVCS 0.00 300.00 300.00 0.00 (300.00) 0.00 43100 MEMBERSHIP & DUES 1,200.00 0.00 50.00 0.00 1,150.00 4.16 43200 CONFERENCE, TRAINING & TRAVEL 8,000.00 0.00 3,560.92 0.00 4,439.08 44.51 TOTAL FOR SERVICES-SUPPLIES 36,815.78 350.03 11,066.93 0.00 25,748.85 30.06 TOTAL FOR CITY COUNCIL 129,965.78 7,815.34 80,078.04 0.00 49,887.74 61.61 11 CITY MANAGER'S OFFICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,722,204.00 113,691.07 1,104,185.54 0.00 618,018.46 64.11 41140 FINAL LEAVE 0.00 0.00 1,936.13 0.00 (1,936.13) 0.00 41141 SP COMP-BILINGUAL 19,350.00 1,488.50 14,140.75 0.00 5,209.25 73.07 41200 TEMPORARY EMPLOYEES 124,032.00 8,378.09 73,508.03 0.00 50,523.97 59.26 41300 OVERTIME 5,000.00 478.94 3,826.63 0.00 1,173.37 76.53 41410 AUTO ALLOWANCE 17,280.00 1,329.24 12,627.78 0.00 4,652.22 73.07 41500 DEFERRED COMPENSATION MATCH 11,400.00 8,525.00 10,953.84 0.00 446.16 96.08 41510 PST DEFERRED COMPENSATION 398.00 85.29 849.51 0.00 (451.51) 213.44 41520 TIERED EMP DEF COMPENSATION 24,100.00 6,175.00 18,525.00 0.00 5,575.00 76.86 41530 TIERED RHS BENEFIT 4,200.00 1,200.00 3,600.00 0.00 600.00 85.71 41600 LONGEVITY 9,600.00 753.78 6,922.50 0.00 2,677.50 72.10 41660 TUITION REIMBURSEMENT 2,550.00 0.00 3,330.00 0.00 (780.00) 130.58 41700 ANNUAL LEAVE BUYBACK 5,585.00 0.00 5,584.00 0.00 1.00 99.98 JULIEK Page: 2 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41710 ANNUAL LEAVE OVER MAX 42,850.00 0.00 71,720.20 0.00 (28,870.20) 167.37 41910 PERS-NORMAL 197,038.00 14,165.39 116,250.59 0.00 80,787.41 58.99 41920 MEDICARE 55,651.00 3,946.15 37,239.87 0.00 18,411.13 66.91 41929 SHORT TERM DISABILITY 5,511.00 466.14 4,531.39 0.00 979.61 82.22 41930 LONG TERM DISABILITY 11,709.00 773.09 7,543.52 0.00 4,165.48 64.42 41931 WORKERS COMP 37,313.00 2,395.27 23,408.73 0.00 13,904.27 62.73 41932 STATE UNEMPLOYMENT INSURANCE 1,719.00 112.12 1,099.78 0.00 619.22 63.97 41940 HEALTH INSURANCE 292,896.00 18,792.98 175,282.84 0.00 117,613.16 59.84 41945 OPT OUT HEALTH INSURANCE 0.00 400.00 2,200.00 0.00 (2,200.00) 0.00 41946 LIFE INSURANCE 14,294.00 943.64 9,207.34 0.00 5,086.66 64.41 41951 HEALTH ALLOWANCE CREDIT 0.00 81.10 5,160.54 0.00 (5,160.54) 0.00 41996 VACANCY FACTOR (104,618.00) 0.00 0.00 0.00 (104,618.00) 0.00 41997 BUDGETARY/PAYROLL (2,844.00) 0.00 0.00 0.00 (2,844.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,497,218.00 184,180.79 1,713,634.51 0.00 783,583.49 68.62

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 29,064.00 10,571.50 22,756.98 0.00 6,307.02 78.29 42012 AUDIO VISUAL 2,000.00 0.00 895.86 0.00 1,104.14 44.79 42020 MINOR EQUIPMENT & FURNITURE 1,300.00 0.00 2,140.64 0.00 (840.64) 164.66 42055 COMPUTER EQUIPMENT & 3,000.00 0.00 2,599.12 0.00 400.88 86.63 42200 ADVERTISING EXPENSE 4,000.00 470.31 2,726.77 0.00 1,273.23 68.16 42220 PROMOTIONAL/PUBLIC OUTREACH 35,500.00 71.69 9,184.08 0.00 26,315.92 25.87 42300 WIRELESS COMMUNICATION 8,820.00 36.41 2,884.76 0.00 5,935.24 32.70 42320 POSTAGE & SHIPPING 1,500.00 8.78 782.18 0.00 717.82 52.14 42340 OFFICE SUPPLIES 9,000.00 111.16 2,734.29 0.00 6,265.71 30.38 42345 FIRST AID KIT SUPPLIES 200.00 0.00 103.32 0.00 96.68 51.66 42350 PROGRAM EXPENDITURES 76,000.00 1,590.54 64,511.63 0.00 11,488.37 84.88 42355 MEETING EXPENDITURES 10,267.59 185.63 5,270.35 0.00 4,997.24 51.32 42710 MILEAGE/VEHICLE EXP REIMB 600.00 0.00 159.82 0.00 440.18 26.63 42800 EQUIPMENT MAINTENANCE 750.00 0.00 582.66 0.00 167.34 77.68 42900 PROF. & CONT. SVCS 2,379,346.46 1,918.16 189,946.66 1,903,867.31 285,532.49 88.00 43100 MEMBERSHIP & DUES 99,710.00 100.00 82,283.83 0.00 17,426.17 82.52 43110 EMPLOYEE ENGAGEMENT 25,000.00 1,066.58 7,472.93 0.00 17,527.07 29.89 43200 CONFERENCE, TRAINING & TRAVEL 30,900.00 0.00 15,892.47 0.00 15,007.53 51.43 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 0.00 172.20 0.00 (172.20) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,716,958.05 16,130.76 413,100.55 1,903,867.31 399,990.19 85.27

CAPITAL OUTLAY
45900 INFRASTRUCTURE 0.00 0.00 44,854.80 0.00 (44,854.80) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 44,854.80 0.00 (44,854.80) 0.00 TOTAL FOR CITY MANAGER'S OFFICE 5,214,176.05 200,311.55 2,171,589.86 1,903,867.31 1,138,718.88 78.16 JULIEK Page: 3 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
12 TREASURER

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,400.00 200.00 1,800.00 0.00 600.00 75.00 41500 DEFERRED COMPENSATION MATCH 1,900.00 531.90 1,353.10 0.00 546.90 71.21 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 450.00 0.00 150.00 75.00 41910 PERS-NORMAL 289.00 24.06 216.54 0.00 72.46 74.92
41920 MEDICARE 431.00 48.59 309.87 0.00 121.13 71.89
41931 WORKERS COMP 48.00 4.00 36.00 0.00 12.00 75.00
41940 HEALTH INSURANCE 9,240.00 770.00 6,930.00 0.00 2,310.00 75.00 41946 LIFE INSURANCE 66.00 5.50 49.50 0.00 16.50 75.00
TOTAL FOR SALARIES-BENEFITS 14,974.00 1,734.05 11,145.01 0.00 3,828.99 74.42 TOTAL FOR TREASURER 14,974.00 1,734.05 11,145.01 0.00 3,828.99 74.42 13 DEBT SERVICE

SERVICES-SUPPLIES
42500 RENTS & LEASES 4,250,072.00 0.00 3,812,001.33 0.00 438,070.67 89.69 42900 PROF. & CONT. SVCS 3,000.00 0.00 3,628.66 0.00 (628.66) 120.95 44001 DS PRINCIPAL 2021 POBS 12,169,572.00 0.00 0.00 0.00 12,169,572.00 0.00 44100 INTEREST EXPENSE 0.00 0.00 132,845.93 0.00 (132,845.93) 0.00 44101 DS INTEREST 2021 POBS 3,285,688.00 0.00 1,642,843.68 0.00 1,642,844.32 50.00 TOTAL FOR SERVICES-SUPPLIES 19,708,332.00 0.00 5,591,319.60 0.00 14,117,012.40 28.37 TOTAL FOR DEBT SERVICE 19,708,332.00 0.00 5,591,319.60 0.00 14,117,012.40 28.37 15 HUMAN RESOURCES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,124,324.00 78,160.00 771,964.88 0.00 352,359.12 68.66 41103 OUT OF CLASS PAY 0.00 0.00 864.00 0.00 (864.00) 0.00 41140 FINAL LEAVE 0.00 0.00 14,753.22 0.00 (14,753.22) 0.00 41141 SP COMP-BILINGUAL 3,870.00 595.40 5,656.30 0.00 (1,786.30) 146.15 41300 OVERTIME 4,000.00 361.26 2,507.46 0.00 1,492.54 62.68 41410 AUTO ALLOWANCE 5,760.00 443.08 4,209.26 0.00 1,550.74 73.07 41500 DEFERRED COMPENSATION MATCH 9,500.00 7,700.00 7,700.00 0.00 1,800.00 81.05 41520 TIERED EMP DEF COMPENSATION 3,000.00 750.00 2,250.00 0.00 750.00 75.00 41530 TIERED RHS BENEFIT 3,000.00 750.00 2,250.00 0.00 750.00 75.00 41600 LONGEVITY 6,400.00 492.28 4,676.66 0.00 1,723.34 73.07 41660 TUITION REIMBURSEMENT 1,820.00 0.00 0.00 0.00 1,820.00 0.00 41700 ANNUAL LEAVE BUYBACK 51,080.00 0.00 49,825.60 0.00 1,254.40 97.54 41710 ANNUAL LEAVE OVER MAX 1,655.00 0.00 0.00 0.00 1,655.00 0.00 41910 PERS-NORMAL 136,492.00 9,533.54 94,214.57 0.00 42,277.43 69.02 41920 MEDICARE 36,122.00 2,625.46 26,195.03 0.00 9,926.97 72.51 41929 SHORT TERM DISABILITY 3,596.00 320.46 3,149.29 0.00 446.71 87.57 JULIEK Page: 4 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41930 LONG TERM DISABILITY 7,646.00 531.50 5,223.26 0.00 2,422.74 68.31 41931 WORKERS COMP 22,564.00 1,544.46 15,374.49 0.00 7,189.51 68.13 41932 STATE UNEMPLOYMENT INSURANCE 1,078.00 72.91 786.85 0.00 291.15 72.99 41940 HEALTH INSURANCE 206,894.00 14,690.41 129,565.99 0.00 77,328.01 62.62 41945 OPT OUT HEALTH INSURANCE 7,200.00 1,200.00 16,514.61 0.00 (9,314.61) 229.36 41946 LIFE INSURANCE 9,332.00 648.74 6,375.73 0.00 2,956.27 68.32 41951 HEALTH ALLOWANCE CREDIT 0.00 450.24 5,149.42 0.00 (5,149.42) 0.00 41996 VACANCY FACTOR (75,281.00) 0.00 0.00 0.00 (75,281.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,570,052.00 120,869.74 1,169,206.62 0.00 400,845.38 74.46

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 4,100.00 0.00 3,876.87 0.00 223.13 94.55 42034 SAFETY MATERIALS/CONSTRUCTION 4,000.00 1,411.09 1,656.54 0.00 2,343.46 41.41 42055 COMPUTER EQUIPMENT & 8,000.00 0.00 7,088.53 0.00 911.47 88.60 42101 SAFETY SHOES - MOU ITEM 23,428.78 0.00 0.00 22,251.09 1,177.69 94.97 42200 ADVERTISING EXPENSE 63,100.00 629.00 23,860.37 500.00 38,739.63 38.60 42300 WIRELESS COMMUNICATION 1,500.00 0.00 629.84 0.00 870.16 41.98 42320 POSTAGE & SHIPPING 1,700.00 11.16 708.12 0.00 991.88 41.65 42340 OFFICE SUPPLIES 19,500.00 168.13 4,992.84 0.00 14,507.16 25.60 42345 FIRST AID KIT SUPPLIES 120.00 0.00 42.89 0.00 77.11 35.74 42350 PROGRAM EXPENDITURES 5,000.00 411.61 4,271.76 0.00 728.24 85.43 42900 PROF. & CONT. SVCS 339,132.00 24,330.00 159,217.21 44,987.65 134,927.14 60.21 43041 MANDATED SAFETY TRAINING 165,000.00 0.00 145,002.00 0.00 19,998.00 87.88 43100 MEMBERSHIP & DUES 7,000.00 0.00 775.70 0.00 6,224.30 11.08 43110 EMPLOYEE ENGAGEMENT 35,000.00 0.00 24,932.98 0.00 10,067.02 71.23 43200 CONFERENCE, TRAINING & TRAVEL 117,000.00 915.48 33,167.66 0.00 83,832.34 28.34 43400 LEGAL SERVICES-SPECIAL COUNSEL 50,000.00 3,069.50 8,947.50 41,052.50 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 843,580.78 30,945.97 419,170.81 108,791.24 315,618.73 62.58 TOTAL FOR HUMAN RESOURCES 2,413,632.78 151,815.71 1,588,377.43 108,791.24 716,464.11 70.31 16 GENERAL GOVERNMENT

SALARIES-BENEFITS
41140 FINAL LEAVE 650,000.00 0.00 0.00 0.00 650,000.00 0.00 41601 MARKSMANSHIP 0.00 3.23 21.07 0.00 (21.07) 0.00
41800 UNIFORM ALLOWANCE 0.00 0.00 47.18 0.00 (47.18) 0.00 41910 PERS-NORMAL 440,000.00 0.83 281,623.26 0.00 158,376.74 64.00 41920 MEDICARE 200.00 14.71 129.44 0.00 70.56 64.72
41921 RETIREES MEDICARE REIMB 600,000.00 60,039.00 627,378.15 0.00 (27,378.15) 104.56 41929 SHORT TERM DISABILITY 0.00 0.97 0.97 0.00 (0.97) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.45 4.07 0.00 (4.07) 0.00 41941 RETIREES HEALTH INSURANCE/OPEB 6,432,942.00 147,738.55 4,327,688.99 0.00 2,105,253.01 67.27 JULIEK Page: 5 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41942 RETIREES LIFE INSURANCE 26,000.00 2,062.50 18,430.50 0.00 7,569.50 70.88 41944 RETIREE FLEX SPENDING PLAN 135,000.00 0.00 125,531.84 0.00 9,468.16 92.98 41947 RETIREE HRA 130,000.00 0.00 120,000.00 0.00 10,000.00 92.30 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 2.58 0.00 (2.58) 0.00 41997 BUDGETARY/PAYROLL 275,000.00 0.00 0.00 0.00 275,000.00 0.00 TOTAL FOR SALARIES-BENEFITS 8,689,142.00 209,860.24 5,500,858.05 0.00 3,188,283.95 63.30

SERVICES-SUPPLIES
42310 PHONES, FAX, ISDN LINES 34,000.00 0.00 18,298.79 0.00 15,701.21 53.81 42320 POSTAGE & SHIPPING 0.00 0.00 6,320.95 0.00 (6,320.95) 0.00 42330 PHONES,FAX-INDIRECT DEPT 5,000.00 0.00 1,850.59 0.00 3,149.41 37.01 42350 PROGRAM EXPENDITURES 46,020.00 1,688.00 9,533.10 0.00 36,486.90 20.71 42380 GEN BENEFIT_CITYWIDE EXPENSE 132,052.00 0.00 159,530.00 0.00 (27,478.00) 120.80 42410 ELECTRIC UTILITY 2,418,142.00 135,599.37 1,724,653.01 0.00 693,488.99 71.32 42420 NATURAL GAS UTILITY 160,700.00 19,807.17 114,213.62 0.00 46,486.38 71.07 42430 WATER UTILITY 722,300.00 46,449.19 525,350.47 0.00 196,949.53 72.73 42435 RECYCLED WATER UTILITY 971,000.00 8,516.91 597,970.90 0.00 373,029.10 61.58 42600 MOTOR POOL RENTAL - OPS & MTCE 9,432.00 0.00 4,716.00 0.00 4,716.00 50.00 42900 PROF. & CONT. SVCS 682,795.00 14,555.42 497,484.47 22,589.26 162,721.27 76.16 42902 CUST CREDIT CRD PROCESSING FEE 240,000.00 19,927.89 223,585.50 0.00 16,414.50 93.16 42960 INDIRECT SPEC DST COUNTY ADMIN 819,185.94 11,721.46 277,427.79 0.00 541,758.15 33.86 43010 INSURANCE PREMIUMS 5,710,073.00 0.00 0.00 0.00 5,710,073.00 0.00 44200 BAD DEBTS EXPENSE 100,000.00 0.00 0.00 0.00 100,000.00 0.00 44613 INTERNAL SVC CHRG-WAREHOUSE 141,600.00 35,400.00 106,200.00 0.00 35,400.00 75.00 44614 INTERNAL SVC CHRG-INFO TECH 9,148,345.00 2,304,949.67 6,843,395.34 0.00 2,304,949.66 74.80 TOTAL FOR SERVICES-SUPPLIES 21,340,644.94 2,598,615.08 11,110,530.53 22,589.26 10,207,525.15 52.16 TOTAL FOR GENERAL GOVERNMENT 30,029,786.94 2,808,475.32 16,611,388.58 22,589.26 13,395,809.10 55.39 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,520,460.25 185,321.81 1,729,744.97 0.00 790,715.28 68.62 41140 FINAL LEAVE 0.00 18,791.46 32,947.92 0.00 (32,947.92) 0.00 41141 SP COMP-BILINGUAL 11,375.00 875.00 9,100.00 0.00 2,275.00 80.00 41300 OVERTIME 25,000.00 1,965.42 18,503.60 0.00 6,496.40 74.01 41410 AUTO ALLOWANCE 5,760.00 443.08 4,209.26 0.00 1,550.74 73.07 41500 DEFERRED COMPENSATION MATCH 15,300.00 7,085.00 11,920.00 0.00 3,380.00 77.90 41520 TIERED EMP DEF COMPENSATION 5,400.00 1,050.00 3,750.00 0.00 1,650.00 69.44 JULIEK Page: 6 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41530 TIERED RHS BENEFIT 4,200.00 750.00 2,850.00 0.00 1,350.00 67.85 41600 LONGEVITY 25,582.00 1,897.84 19,416.43 0.00 6,165.57 75.89 41660 TUITION REIMBURSEMENT 2,190.00 0.00 1,897.58 0.00 292.42 86.64 41700 ANNUAL LEAVE BUYBACK 54,032.00 0.00 48,094.45 0.00 5,937.55 89.01 41710 ANNUAL LEAVE OVER MAX 35,700.00 0.00 34,341.22 0.00 1,358.78 96.19 41910 PERS-NORMAL 307,656.80 22,627.83 211,418.10 0.00 96,238.70 68.71 41920 MEDICARE 80,328.50 6,418.05 57,476.58 0.00 22,851.92 71.55 41929 SHORT TERM DISABILITY 8,067.32 760.15 7,089.25 0.00 978.07 87.87 41930 LONG TERM DISABILITY 17,140.19 1,260.67 11,757.14 0.00 5,383.05 68.59 41931 WORKERS COMP 50,814.02 3,595.85 33,952.28 0.00 16,861.74 66.81 41932 STATE UNEMPLOYMENT INSURANCE 2,408.97 189.04 1,703.35 0.00 705.62 70.70 41940 HEALTH INSURANCE 506,553.96 31,666.74 287,944.14 0.00 218,609.82 56.84 41945 OPT OUT HEALTH INSURANCE 33,600.00 4,716.00 49,818.82 0.00 (16,218.82) 148.27 41946 LIFE INSURANCE 20,918.47 1,538.74 14,350.90 0.00 6,567.57 68.60 41951 HEALTH ALLOWANCE CREDIT 0.00 147.34 5,968.23 0.00 (5,968.23) 0.00 41996 VACANCY FACTOR (172,535.00) 0.00 0.00 0.00 (172,535.00) 0.00 41997 BUDGETARY/PAYROLL (1,741.48) 0.00 0.00 0.00 (1,741.48) 0.00 TOTAL FOR SALARIES-BENEFITS 3,558,211.00 291,100.02 2,598,254.22 0.00 959,956.78 73.02

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 2,955.40 0.00 3,492.08 0.00 (536.68) 118.15 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 0.00 32.16 0.00 (32.16) 0.00 42055 COMPUTER EQUIPMENT & 1,000.00 0.00 268.46 0.00 731.54 26.84 42200 ADVERTISING EXPENSE 1,100.00 0.00 649.87 0.00 450.13 59.07 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 0.00 1,706.29 0.00 (1,706.29) 0.00 42310 PHONES, FAX, ISDN LINES 0.00 0.00 70.04 0.00 (70.04) 0.00 42320 POSTAGE & SHIPPING 3,900.00 377.02 5,230.34 0.00 (1,330.34) 134.11 42340 OFFICE SUPPLIES 3,100.00 72.53 2,480.87 0.00 619.13 80.02 42345 FIRST AID KIT SUPPLIES 50.00 0.00 79.14 0.00 (29.14) 158.28 42350 PROGRAM EXPENDITURES 5,600.00 0.00 3,035.94 0.00 2,564.06 54.21 42365 RECYCLED CONTENT PRODUCTS 0.00 312.68 824.53 0.00 (824.53) 0.00 42710 MILEAGE/VEHICLE EXP REIMB 200.00 0.00 59.67 0.00 140.33 29.83 42900 PROF. & CONT. SVCS 717,280.00 151,030.01 600,975.41 202,582.25 (86,277.66) 112.02 43100 MEMBERSHIP & DUES 5,875.00 1,095.00 2,150.00 0.00 3,725.00 36.59 43200 CONFERENCE, TRAINING & TRAVEL 22,075.00 0.00 7,483.79 0.00 14,591.21 33.90 TOTAL FOR SERVICES-SUPPLIES 763,135.40 152,887.24 628,538.59 202,582.25 (67,985.44) 108.90 TOTAL FOR FINANCE 4,321,346.40 443,987.26 3,226,792.81 202,582.25 891,971.34 79.35 19 ECONOMIC DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 427,465.00 21,519.52 295,357.95 0.00 132,107.05 69.09 JULIEK Page: 7 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41140 FINAL LEAVE 0.00 15,388.90 22,218.37 0.00 (22,218.37) 0.00 41141 SP COMP-BILINGUAL 11,610.00 595.40 7,889.05 0.00 3,720.95 67.95 41410 AUTO ALLOWANCE 5,760.00 443.08 4,209.26 0.00 1,550.74 73.07 41500 DEFERRED COMPENSATION MATCH 1,900.00 1,400.00 1,400.00 0.00 500.00 73.68 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 450.00 0.00 150.00 75.00 41530 TIERED RHS BENEFIT 600.00 150.00 450.00 0.00 150.00 75.00 41710 ANNUAL LEAVE OVER MAX 4,465.00 0.00 0.00 0.00 4,465.00 0.00 41910 PERS-NORMAL 52,820.00 2,660.44 36,480.83 0.00 16,339.17 69.06 41920 MEDICARE 13,426.00 1,156.03 10,155.43 0.00 3,270.57 75.64 41929 SHORT TERM DISABILITY 1,368.00 88.23 1,210.93 0.00 157.07 88.51 41930 LONG TERM DISABILITY 2,907.00 146.32 2,008.29 0.00 898.71 69.08 41931 WORKERS COMP 8,781.00 435.24 6,034.11 0.00 2,746.89 68.71 41932 STATE UNEMPLOYMENT INSURANCE 407.00 34.36 307.81 0.00 99.19 75.62 41940 HEALTH INSURANCE 52,538.00 4,690.55 40,895.29 0.00 11,642.71 77.83 41945 OPT OUT HEALTH INSURANCE 7,200.00 0.00 8,738.16 0.00 (1,538.16) 121.36 41946 LIFE INSURANCE 3,549.00 178.61 2,451.45 0.00 1,097.55 69.07 41951 HEALTH ALLOWANCE CREDIT 0.00 97.62 1,398.06 0.00 (1,398.06) 0.00 TOTAL FOR SALARIES-BENEFITS 595,396.00 49,134.30 441,654.99 0.00 153,741.01 74.17

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 47,245.00 0.00 22,405.74 0.00 24,839.26 47.42 42020 MINOR EQUIPMENT & FURNITURE 1,500.00 0.00 0.00 0.00 1,500.00 0.00 42055 COMPUTER EQUIPMENT & 2,000.00 0.00 1,604.31 0.00 395.69 80.21 42200 ADVERTISING EXPENSE 7,500.00 0.00 320.00 0.00 7,180.00 4.26 42220 PROMOTIONAL/PUBLIC OUTREACH 21,500.00 120.00 10,698.97 0.00 10,801.03 49.76 42300 WIRELESS COMMUNICATION 2,500.00 0.00 1,200.16 0.00 1,299.84 48.00 42320 POSTAGE & SHIPPING 500.00 0.00 48.65 0.00 451.35 9.73 42340 OFFICE SUPPLIES 2,500.00 0.00 1,736.22 0.00 763.78 69.44 42345 FIRST AID KIT SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42350 PROGRAM EXPENDITURES 1,500.00 9.99 199.03 0.00 1,300.97 13.26 42710 MILEAGE/VEHICLE EXP REIMB 500.00 134.54 134.54 0.00 365.46 26.90 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 186,900.00 29,435.00 129,476.71 33,790.00 23,633.29 87.35 43100 MEMBERSHIP & DUES 14,880.00 0.00 3,036.13 0.00 11,843.87 20.40 43200 CONFERENCE, TRAINING & TRAVEL 28,900.00 0.00 1,662.28 0.00 27,237.72 5.75 43400 LEGAL SERVICES-SPECIAL COUNSEL 72,000.00 0.00 3,178.90 0.00 68,821.10 4.41 TOTAL FOR SERVICES-SUPPLIES 391,425.00 29,699.53 175,701.64 33,790.00 181,933.36 53.52 TOTAL FOR ECONOMIC DEVELOPMENT 986,821.00 78,833.83 617,356.63 33,790.00 335,674.37 65.98 20 LEGAL AND RISK MANAGEMENT
JULIEK Page: 8 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,051,857.00 82,072.29 769,449.06 0.00 282,407.94 73.15 41141 SP COMP-BILINGUAL 3,870.00 297.70 2,828.15 0.00 1,041.85 73.07 41200 TEMPORARY EMPLOYEES 38,813.20 2,113.43 17,480.65 0.00 21,332.55 45.03 41410 AUTO ALLOWANCE 17,280.00 1,329.24 12,627.78 0.00 4,652.22 73.07 41500 DEFERRED COMPENSATION MATCH 9,500.00 6,225.00 7,150.00 0.00 2,350.00 75.26 41510 PST DEFERRED COMPENSATION 505.13 27.47 227.25 0.00 277.88 44.98 41520 TIERED EMP DEF COMPENSATION 15,000.00 3,750.00 11,250.00 0.00 3,750.00 75.00 41530 TIERED RHS BENEFIT 3,000.00 750.00 2,250.00 0.00 750.00 75.00 41600 LONGEVITY 7,800.00 599.92 5,699.24 0.00 2,100.76 73.06 41700 ANNUAL LEAVE BUYBACK 63,439.00 0.00 63,437.20 0.00 1.80 99.99 41710 ANNUAL LEAVE OVER MAX 7,956.00 0.00 25,667.59 0.00 (17,711.59) 322.61 41910 PERS-NORMAL 127,942.00 9,981.28 93,590.58 0.00 34,351.42 73.15 41920 MEDICARE 35,967.85 2,857.90 29,068.94 0.00 6,898.91 80.81 41929 SHORT TERM DISABILITY 3,365.00 336.52 3,154.80 0.00 210.20 93.75 41930 LONG TERM DISABILITY 7,153.00 558.08 5,232.04 0.00 1,920.96 73.14 41931 WORKERS COMP 21,790.00 1,669.03 15,641.33 0.00 6,148.67 71.78 41932 STATE UNEMPLOYMENT INSURANCE 1,077.51 79.16 806.02 0.00 271.49 74.80 41940 HEALTH INSURANCE 83,220.00 6,896.97 59,136.02 0.00 24,083.98 71.05 41945 OPT OUT HEALTH INSURANCE 14,400.00 1,200.00 16,634.68 0.00 (2,234.68) 115.51 41946 LIFE INSURANCE 8,731.00 681.18 6,386.23 0.00 2,344.77 73.14 41951 HEALTH ALLOWANCE CREDIT 0.00 92.16 2,436.24 0.00 (2,436.24) 0.00 TOTAL FOR SALARIES-BENEFITS 1,522,666.69 121,517.33 1,150,153.80 0.00 372,512.89 75.53

SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 4,360.00 0.00 0.00 0.00 4,360.00 0.00 42300 WIRELESS COMMUNICATION 2,220.00 53.50 979.67 0.00 1,240.33 44.12 42320 POSTAGE & SHIPPING 450.00 25.20 160.66 0.00 289.34 35.70 42340 OFFICE SUPPLIES 3,500.00 0.00 436.00 0.00 3,064.00 12.45 42345 FIRST AID KIT SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42710 MILEAGE/VEHICLE EXP REIMB 100.00 0.00 0.00 0.00 100.00 0.00 42900 PROF. & CONT. SVCS 350.00 20.00 180.00 0.00 170.00 51.42 43100 MEMBERSHIP & DUES 3,310.00 0.00 3,060.00 0.00 250.00 92.44 43200 CONFERENCE, TRAINING & TRAVEL 7,375.00 0.00 753.59 0.00 6,621.41 10.21 43400 LEGAL SERVICES-SPECIAL COUNSEL 95,000.00 15,244.01 51,207.63 0.00 43,792.37 53.90 43410 LEGAL RESEARCH 17,798.00 1,168.56 9,436.40 4,675.88 3,685.72 79.29 43430 LITIGATION EXPENSE 120,000.00 1,507.00 5,135.65 3,758.60 111,105.75 7.41 TOTAL FOR SERVICES-SUPPLIES 254,563.00 18,018.27 71,349.60 8,434.48 174,778.92 31.34 TOTAL FOR LEGAL AND RISK MANAGEMENT1,777,229.69 139,535.60 1,221,503.40 8,434.48 547,291.81 69.20 21 PLANNING & DEVELOPMENT
JULIEK Page: 9 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 3,790,007.00 231,774.16 2,157,038.03 0.00 1,632,968.97 56.91 41140 FINAL LEAVE 0.00 444.58 73,101.33 0.00 (73,101.33) 0.00 41141 SP COMP-BILINGUAL 29,878.00 2,235.24 21,461.63 0.00 8,416.37 71.83 41200 TEMPORARY EMPLOYEES 59,853.00 3,238.41 42,460.16 0.00 17,392.84 70.94 41300 OVERTIME 91,341.00 4,031.20 37,209.01 0.00 54,131.99 40.73 41400 SPECIAL DUTY PAY 0.00 252.88 2,678.68 0.00 (2,678.68) 0.00 41410 AUTO ALLOWANCE 5,760.00 443.08 4,209.26 0.00 1,550.74 73.07 41500 DEFERRED COMPENSATION MATCH 9,135.00 5,910.02 6,859.98 0.00 2,275.02 75.09 41510 PST DEFERRED COMPENSATION 777.00 0.00 168.77 0.00 608.23 21.72 41520 TIERED EMP DEF COMPENSATION 3,798.00 799.50 2,548.50 0.00 1,249.50 67.10 41530 TIERED RHS BENEFIT 2,286.00 521.50 1,614.50 0.00 671.50 70.62 41600 LONGEVITY 18,943.00 1,390.44 13,734.69 0.00 5,208.31 72.50 41660 TUITION REIMBURSEMENT 0.00 0.00 1,873.80 0.00 (1,873.80) 0.00 41700 ANNUAL LEAVE BUYBACK 60,980.00 0.00 56,852.92 0.00 4,127.08 93.23 41710 ANNUAL LEAVE OVER MAX 4,868.00 0.00 9,824.29 0.00 (4,956.29) 201.81 41910 PERS-NORMAL 449,553.00 28,318.64 263,655.77 0.00 185,897.23 58.64 41920 MEDICARE 121,345.00 7,311.75 72,258.39 0.00 49,086.61 59.54 41929 SHORT TERM DISABILITY 12,125.00 956.98 8,904.95 0.00 3,220.05 73.44 41930 LONG TERM DISABILITY 25,772.00 1,587.20 14,769.65 0.00 11,002.35 57.30 41931 WORKERS COMP 77,750.00 4,649.09 44,000.26 0.00 33,749.74 56.59 41932 STATE UNEMPLOYMENT INSURANCE 3,683.00 220.08 2,216.74 0.00 1,466.26 60.18 41940 HEALTH INSURANCE 725,067.00 39,780.34 364,143.58 0.00 360,923.42 50.22 41945 OPT OUT HEALTH INSURANCE 48,600.00 2,850.00 47,419.47 0.00 1,180.53 97.57 41946 LIFE INSURANCE 31,457.00 1,937.42 18,026.63 0.00 13,430.37 57.30 41951 HEALTH ALLOWANCE CREDIT 0.00 410.79 9,411.03 0.00 (9,411.03) 0.00 41996 VACANCY FACTOR (327,312.00) 0.00 0.00 0.00 (327,312.00) 0.00 41997 BUDGETARY/PAYROLL (25,000.00) 0.00 0.00 0.00 (25,000.00) 0.00 TOTAL FOR SALARIES-BENEFITS 5,220,666.00 339,063.30 3,276,442.02 0.00 1,944,223.98 62.75

SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,750.00 900.00 3,271.70 0.00 2,478.30 56.89 42010 SUBSCRIPTIONS 276.00 0.00 230.01 0.00 45.99 83.33 42011 SCAN/MICROFIL/MAPPING SVCS 25,000.00 0.00 15,506.64 0.00 9,493.36 62.02 42014 ELECTRONIC INFO RESOURCES 3,500.00 0.00 2,589.16 0.00 910.84 73.97 42020 MINOR EQUIPMENT & FURNITURE 17,250.00 0.00 13,770.98 0.00 3,479.02 79.83 42033 CONSTRUCTION MATERIALS 700.00 0.00 160.52 0.00 539.48 22.93 42034 SAFETY MATERIALS/CONSTRUCTION 500.00 0.00 456.74 0.00 43.26 91.34 42055 COMPUTER EQUIPMENT & 18,735.00 0.00 13,605.32 0.00 5,129.68 72.61 42100 UNIFORM EXPENSE 5,565.00 61.99 1,269.61 0.00 4,295.39 22.81 42101 SAFETY SHOES - MOU ITEM 11,354.00 0.00 2,715.57 0.00 8,638.43 23.91 JULIEK Page: 10 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
42200 ADVERTISING EXPENSE 11,000.00 1,025.64 8,296.08 0.00 2,703.92 75.41 42300 WIRELESS COMMUNICATION 24,396.00 0.00 9,683.89 0.00 14,712.11 39.69 42320 POSTAGE & SHIPPING 15,750.00 0.44 9,414.48 0.00 6,335.52 59.77 42340 OFFICE SUPPLIES 15,700.00 151.68 5,383.85 0.00 10,316.15 34.29 42345 FIRST AID KIT SUPPLIES 300.00 0.00 54.91 0.00 245.09 18.30 42350 PROGRAM EXPENDITURES 19,700.00 535.06 10,236.59 0.00 9,463.41 51.96 42360 CLEANING/JANITORIAL SUPPLIES 320.00 0.00 0.00 0.00 320.00 0.00 42365 RECYCLED CONTENT PRODUCTS 0.00 0.00 2,186.28 0.00 (2,186.28) 0.00 42600 MOTOR POOL RENTAL - OPS & MTCE 151,971.00 0.00 75,985.50 0.00 75,985.50 50.00 42710 MILEAGE/VEHICLE EXP REIMB 1,070.00 0.00 0.00 0.00 1,070.00 0.00 42800 EQUIPMENT MAINTENANCE 18,000.00 0.00 0.00 0.00 18,000.00 0.00 42900 PROF. & CONT. SVCS 3,331,544.55 134,288.27 832,948.39 659,283.05 1,839,313.11 44.79 42906 OTHER GOVT AGENCY FEES 37,000.00 0.00 34,521.97 0.00 2,478.03 93.30 43100 MEMBERSHIP & DUES 9,660.00 240.00 4,633.31 0.00 5,026.69 47.96 43200 CONFERENCE, TRAINING & TRAVEL 21,495.00 40.00 13,425.18 0.00 8,069.82 62.45 43500 BOOKS 2,900.00 0.00 1,119.31 0.00 1,780.69 38.59
43724 OUTSIDE SERVICES - LABOR 381,400.50 35,498.14 50,187.66 195,397.00 135,815.84 64.39 TOTAL FOR SERVICES-SUPPLIES 4,130,837.05 172,741.22 1,111,653.65 854,680.05 2,164,503.35 47.60 TOTAL FOR PLANNING & DEVELOPMENT DEPT9,351,503.05 511,804.52 4,388,095.67 854,680.05 4,108,727.33 56.06 30 FIRE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 12,547,533.72 934,205.26 8,581,348.02 0.00 3,966,185.70 68.39 41101 SPECIAL ASSIGNMENT PAY 0.00 34.36 725.21 0.00 (725.21) 0.00 41140 FINAL LEAVE 0.00 0.00 40,238.06 0.00 (40,238.06) 0.00 41141 SP COMP-BILINGUAL 71,955.19 4,821.08 45,800.26 0.00 26,154.93 63.65 41149 SP COMP-PARAMEDIC CQI COORD 5,980.00 460.00 4,370.00 0.00 1,610.00 73.07 41150 SP COMP-HAZRDOUS PAY 68,388.00 5,698.94 54,139.93 0.00 14,248.07 79.16 41151 SP COMP-SECONDARY MEDIC 170,594.62 12,536.04 114,595.95 0.00 55,998.67 67.17 41153 SP COMP-ACTING FIRE ENG 0.00 23.62 974.59 0.00 (974.59) 0.00 41154 SP COMP-ACTING FIRE CAPT 0.00 21.89 626.88 0.00 (626.88) 0.00 41155 SP COMP-ACTING BATTALION CHIEF 0.00 0.00 908.11 0.00 (908.11) 0.00 41200 TEMPORARY EMPLOYEES 102,937.00 5,407.27 51,243.95 0.00 51,693.05 49.78 41300 OVERTIME 977,000.00 19,087.99 860,337.10 0.00 116,662.90 88.05 41310 OVERTIME - FLSA 288,379.18 22,914.82 222,356.38 0.00 66,022.80 77.10 41330 CONSTANT STAFF LEVELS-OT FIRE 5,342,355.72 430,398.79 4,160,316.05 0.00 1,182,039.67 77.87 41350 OVERTIME - TRAINING 506,849.00 50,232.35 348,109.86 0.00 158,739.14 68.68 41400 SPECIAL DUTY PAY 19,000.00 1,987.50 18,430.41 0.00 569.59 97.00 41420 FIRE HOLIDAY PAY 653,510.78 0.00 447,093.10 0.00 206,417.68 68.41 41500 DEFERRED COMPENSATION MATCH 6,200.00 3,125.00 3,300.00 0.00 2,900.00 53.22 41510 PST DEFERRED COMPENSATION 1,115.00 70.29 656.03 0.00 458.97 58.83 JULIEK Page: 11 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41520 TIERED EMP DEF COMPENSATION 2,400.00 450.00 1,500.00 0.00 900.00 62.50 41530 TIERED RHS BENEFIT 395,229.17 95,350.00 288,700.00 0.00 106,529.17 73.04 41600 LONGEVITY 358,882.84 26,322.54 250,620.63 0.00 108,262.21 69.83 41660 TUITION REIMBURSEMENT 61,550.00 1,460.00 45,798.63 0.00 15,751.37 74.40 41700 ANNUAL LEAVE BUYBACK 78,647.00 0.00 69,808.39 0.00 8,838.61 88.76 41710 ANNUAL LEAVE OVER MAX 37,452.00 0.00 51,298.56 0.00 (13,846.56) 136.97 41800 UNIFORM ALLOWANCE 2,200.00 169.24 1,607.78 0.00 592.22 73.08 41910 PERS-NORMAL 3,095,503.77 218,445.36 2,137,432.31 0.00 958,071.46 69.04 41920 MEDICARE 436,901.33 23,448.90 244,284.22 0.00 192,617.11 55.91 41929 SHORT TERM DISABILITY 40,154.31 3,811.17 35,192.32 0.00 4,961.99 87.64 41930 LONG TERM DISABILITY 85,326.04 6,321.13 58,368.09 0.00 26,957.95 68.40 41931 WORKERS COMP 748,173.80 51,171.23 502,495.45 0.00 245,678.35 67.16 41932 STATE UNEMPLOYMENT INSURANCE 18,759.66 1,345.15 13,703.79 0.00 5,055.87 73.04 41940 HEALTH INSURANCE 1,850,323.78 145,237.65 1,284,987.81 0.00 565,335.97 69.44 41945 OPT OUT HEALTH INSURANCE 120,000.00 9,800.00 94,108.77 0.00 25,891.23 78.42 41946 LIFE INSURANCE 104,133.09 7,715.18 71,242.16 0.00 32,890.93 68.41 41951 HEALTH ALLOWANCE CREDIT 0.00 493.22 25,049.84 0.00 (25,049.84) 0.00 41997 BUDGETARY/PAYROLL 54,589.00 0.00 0.00 0.00 54,589.00 0.00 TOTAL FOR SALARIES-BENEFITS 28,252,024.00 2,082,565.97 20,131,768.64 0.00 8,120,255.36 71.25

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 7,600.00 0.00 1,103.49 0.00 6,496.51 14.51 42020 MINOR EQUIPMENT & FURNITURE 301,501.00 25,378.25 141,339.65 12,185.32 147,976.03 50.92 42025 HOSE AND APPLIANCE 35,000.00 0.00 193.23 0.00 34,806.77 0.55 42026 HAZMAT EQUIPMENT 38,658.00 0.00 21,155.16 0.00 17,502.84 54.72 42027 TECHNICAL RESCUE EQUIPMENT 25,500.00 2,539.81 19,288.53 0.00 6,211.47 75.64 42028 SCBA BREATHING APPARATUS 15,000.00 453.47 8,454.03 1,619.53 4,926.44 67.15 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 0.00 398.83 0.00 (398.83) 0.00 42055 COMPUTER EQUIPMENT & 12,657.00 0.00 36,871.44 260.65 (24,475.09) 293.37 42100 UNIFORM EXPENSE 44,300.00 1,218.10 35,874.11 161.94 8,263.95 81.34 42101 SAFETY SHOES - MOU ITEM 3,000.00 0.00 315.35 0.00 2,684.65 10.51 42105 PROTECTIVE CLOTHING 287,384.95 (135.25) 76,181.37 59,421.15 151,782.43 47.18 42110 EMS SUPPLIES 125,000.00 8,397.59 70,069.46 61,773.12 (6,842.58) 105.47 42200 ADVERTISING EXPENSE 250.00 0.00 0.00 0.00 250.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 0.00 210.73 0.00 (210.73) 0.00 42300 WIRELESS COMMUNICATION 42,365.00 375.40 12,558.50 0.00 29,806.50 29.64 42305 PBLC SFTY RADIO COMMUNICATION 242,505.00 171.60 2,485.67 0.00 240,019.33 1.02 42310 PHONES, FAX, ISDN LINES 6,200.00 0.00 4,163.24 0.00 2,036.76 67.14 42320 POSTAGE & SHIPPING 1,600.00 4.75 1,434.71 0.00 165.29 89.66 42340 OFFICE SUPPLIES 8,000.00 593.13 7,278.58 0.00 721.42 90.98 42350 PROGRAM EXPENDITURES 65,595.99 1,738.41 61,760.86 0.00 3,835.13 94.15 JULIEK Page: 12 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
42360 CLEANING/JANITORIAL SUPPLIES 26,800.00 1,666.80 15,909.53 0.00 10,890.47 59.36 42365 RECYCLED CONTENT PRODUCTS 0.00 600.17 5,183.55 0.00 (5,183.55) 0.00 42441 UNLEADED FUEL 0.00 77.77 157.22 0.00 (157.22) 0.00 42600 MOTOR POOL RENTAL - OPS & MTCE 1,682,660.00 0.00 841,330.00 0.00 841,330.00 50.00 42605 RETAINED VEHICLE EXPENSE 2,660.00 0.00 1,330.00 0.00 1,330.00 50.00 42610 DIRECT VEHICLE EXPENSE 13,000.00 0.00 1,691.48 0.00 11,308.52 13.01 42650 TABLET RENTAL RATES 77,845.00 0.00 38,922.50 0.00 38,922.50 50.00 42700 OTHER EQUIPMENT RENTAL 2,000.00 0.00 2,630.90 0.00 (630.90) 131.54 42710 MILEAGE/VEHICLE EXP REIMB 0.00 125.45 422.69 0.00 (422.69) 0.00 42800 EQUIPMENT MAINTENANCE 20,200.00 459.57 11,605.49 0.00 8,594.51 57.45 42810 BUILDING MAINTENANCE 33,000.00 0.00 16,570.92 0.00 16,429.08 50.21 42900 PROF. & CONT. SVCS 762,677.11 30,970.49 118,496.17 371,090.63 273,090.31 64.19 42907 EMS SUBSCRIPTION ADMIN 60,000.00 0.00 0.00 0.00 60,000.00 0.00 42912 CAD DISPATCH SERVICES 113,694.89 51,802.23 73,481.12 0.00 40,213.77 64.63 43100 MEMBERSHIP & DUES 12,525.00 0.00 3,826.91 0.00 8,698.09 30.55 43200 CONFERENCE, TRAINING & TRAVEL 90,995.00 1,606.88 88,516.82 0.00 2,478.18 97.27 43500 BOOKS 1,500.00 0.00 254.29 0.00 1,245.71 16.95
43600 DISASTER PREPAREDNESS 22,914.00 1,725.00 5,297.47 0.00 17,616.53 23.11 43716 JOB REQ CERTIFICATES & LICENSE 20,000.00 0.00 3,164.47 0.00 16,835.53 15.82 TOTAL FOR SERVICES-SUPPLIES 4,204,587.94 129,769.62 1,729,928.47 506,512.34 1,968,147.13 53.19

CAPITAL OUTLAY
TOTAL FOR CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL FOR FIRE 32,456,611.94 2,212,335.59 21,861,697.11 506,512.34 10,088,402.49 68.91 32 POLICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 23,342,683.58 1,598,910.15 14,735,761.86 0.00 8,606,921.72 63.12 41101 SPECIAL ASSIGNMENT PAY 0.00 462.44 777.52 0.00 (777.52) 0.00 41102 SHIFT DIFFERENTIAL 110,000.00 10,098.93 81,819.59 0.00 28,180.41 74.38 41105 INCENTIVE PAY PROGRAM 0.00 0.00 2,500.00 0.00 (2,500.00) 0.00 41140 FINAL LEAVE 0.00 49,082.57 418,985.08 0.00 (418,985.08) 0.00 41141 SP COMP-BILINGUAL 202,009.00 15,543.26 155,456.51 0.00 46,552.49 76.95 41143 SP COMP-CGEA TRAINING OFFICER 0.00 280.59 1,847.53 0.00 (1,847.53) 0.00 41144 SP COMP-LEAD ANIMAL CTRL 2,630.00 0.00 0.00 0.00 2,630.00 0.00 41145 SP COMP-LEAD RECORDS TECH 4,330.00 666.16 6,161.98 0.00 (1,831.98) 142.30 41157 SP COMP-ACCIDENT INVESTIGATION 5,444.00 424.00 3,955.20 0.00 1,488.80 72.65 41158 SP COMP-MOTOR OFFICER 38,108.00 2,968.00 30,235.00 0.00 7,873.00 79.34 41159 SP COMP-INTERMEDIATE POST 47,561.54 4,366.13 35,837.98 0.00 11,723.56 75.35 41160 SP COMP-ADVANCED POST 962,966.02 69,422.41 706,418.79 0.00 256,547.23 73.35 41162 SP COMP-MGMT POST 67,485.00 5,092.14 48,799.24 0.00 18,685.76 72.31 JULIEK Page: 13 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41164 SP COMP-CANINE PAY 27,320.00 1,689.44 19,380.17 0.00 7,939.83 70.93 41165 SP COMP-SCHOOL RESOURCE OFFCR 21,114.00 1,647.40 16,077.68 0.00 5,036.32 76.14 41166 SP COMP-INVESTIGATIVE UNIT 30,560.00 1,370.64 13,936.51 0.00 16,623.49 45.60 41167 SP COMP-TRAFFIC CPL/SGT 0.00 1,149.44 6,061.39 0.00 (6,061.39) 0.00 41168 SP COMP-RELIEF WATCH CMND 29,520.00 1,555.19 17,813.53 0.00 11,706.47 60.34 41171 SP COMP-SR DETECTIVE 35,202.00 2,512.84 25,228.91 0.00 9,973.09 71.66 41172 SP COMP-COMMERCIAL 5,444.00 424.00 4,600.54 0.00 843.46 84.50 41173 SP COMP-PACT TEAM 0.00 821.08 7,583.52 0.00 (7,583.52) 0.00 41174 SP COMP-PERSONNEL OFFICER 11,167.00 445.68 6,834.15 0.00 4,332.85 61.19 41175 SP COMP-CAPTAINS ADJUTANT 0.00 547.36 1,635.40 0.00 (1,635.40) 0.00 41176 SP COMP-DETECTIVE SGT 22,140.00 2,048.32 16,651.44 0.00 5,488.56 75.20 41177 SP COMP-PROFESSIONAL STND UNIT 7,380.00 574.72 5,642.20 0.00 1,737.80 76.45 41178 SP COMP-PERSONNEL & TRAINING 7,380.00 521.28 7,429.99 0.00 (49.99) 100.67 41179 SP COMP-TRAINING OFFICER 5,444.00 4,085.90 18,832.26 0.00 (13,388.26) 345.92 41180 SP COMP-YOUTH DIVERSION 13,247.00 1,031.60 10,350.48 0.00 2,896.52 78.13 41183 SP COMP-HOPE-HMLS OUTRCH & 20,814.00 1,628.60 18,617.68 0.00 2,196.32 89.44 41184 SP COMP-FLEX TEAM OFFICER/CORP 12,724.00 1,325.52 14,229.79 0.00 (1,505.79) 111.83 41200 TEMPORARY EMPLOYEES 228,844.00 14,327.32 165,424.89 0.00 63,419.11 72.28 41300 OVERTIME 2,518,670.12 343,015.18 3,394,702.10 0.00 (876,031.98) 134.78 41310 OVERTIME - FLSA 0.00 784.70 5,617.13 0.00 (5,617.13) 0.00 41320 COMP TIME 717,815.00 69,825.30 566,440.33 0.00 151,374.67 78.91 41400 SPECIAL DUTY PAY 113,150.00 7,748.89 79,066.97 0.00 34,083.03 69.87 41500 DEFERRED COMPENSATION MATCH 31,000.00 23,035.00 26,900.00 0.00 4,100.00 86.77 41510 PST DEFERRED COMPENSATION 2,204.00 186.25 1,766.01 0.00 437.99 80.12 41520 TIERED EMP DEF COMPENSATION 16,800.00 3,450.00 10,650.00 0.00 6,150.00 63.39 41530 TIERED RHS BENEFIT 664,350.00 168,000.00 476,725.00 0.00 187,625.00 71.75 41600 LONGEVITY 676,733.00 48,927.84 474,958.44 0.00 201,774.56 70.18 41601 MARKSMANSHIP 65,667.00 4,577.45 41,925.90 0.00 23,741.10 63.84 41660 TUITION REIMBURSEMENT 22,510.00 0.00 9,926.86 0.00 12,583.14 44.09 41700 ANNUAL LEAVE BUYBACK 381,925.00 0.00 366,749.83 0.00 15,175.17 96.02 41710 ANNUAL LEAVE OVER MAX 39,509.00 0.00 92,981.85 0.00 (53,472.85) 235.34 41800 UNIFORM ALLOWANCE 559,125.00 40,077.62 374,245.87 0.00 184,879.13 66.93 41910 PERS-NORMAL 5,816,209.10 423,465.18 3,965,208.65 0.00 1,851,000.45 68.17 41920 MEDICARE 898,418.26 68,983.24 671,463.34 0.00 226,954.92 74.73 41929 SHORT TERM DISABILITY 74,680.50 6,780.97 61,372.05 0.00 13,308.45 82.17 41930 LONG TERM DISABILITY 158,710.71 5,112.77 120,570.50 0.00 38,140.21 75.96 41931 WORKERS COMP 1,302,908.55 91,861.92 855,423.95 0.00 447,484.60 65.65 41932 STATE UNEMPLOYMENT INSURANCE 27,487.03 2,112.27 20,471.37 0.00 7,015.66 74.47 41940 HEALTH INSURANCE 3,604,943.26 256,311.18 2,199,648.59 0.00 1,405,294.67 61.01 41945 OPT OUT HEALTH INSURANCE 334,128.00 28,700.00 404,850.95 0.00 (70,722.95) 121.16 JULIEK Page: 14 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41946 LIFE INSURANCE 193,752.54 13,727.72 124,159.42 0.00 69,593.12 64.08 41951 HEALTH ALLOWANCE CREDIT 0.00 2,397.36 51,597.16 0.00 (51,597.16) 0.00 41996 VACANCY FACTOR (90,622.00) 0.00 0.00 0.00 (90,622.00) 0.00 41997 BUDGETARY/PAYROLL 6,066.91 0.00 0.00 0.00 6,066.91 0.00 41999 PAYROLL SUSPENSE 0.00 34,366.89 312,274.88 0.00 (312,274.88) 0.00 TOTAL FOR SALARIES-BENEFITS 43,397,658.12 3,438,470.84 31,314,583.96 0.00 12,083,074.16 72.15

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 1,215.00 0.00 603.83 0.00 611.17 49.69 42020 MINOR EQUIPMENT & FURNITURE 188,183.85 11,216.67 97,017.94 60,978.21 30,187.70 83.95 42033 CONSTRUCTION MATERIALS 0.00 9.90 47.84 0.00 (47.84) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 275.00 18.68 179.94 0.00 95.06 65.43 42055 COMPUTER EQUIPMENT & 20,420.00 0.00 24,364.34 0.00 (3,944.34) 119.31 42100 UNIFORM EXPENSE 58,250.00 5,485.75 59,075.53 8,329.78 (9,155.31) 115.71 42101 SAFETY SHOES - MOU ITEM 12,150.00 0.00 2,784.71 0.00 9,365.29 22.91 42105 PROTECTIVE CLOTHING 37,990.00 7,761.14 26,989.18 2,811.80 8,189.02 78.44 42300 WIRELESS COMMUNICATION 62,154.00 86.48 35,728.17 0.00 26,425.83 57.48 42305 PBLC SFTY RADIO COMMUNICATION 192,535.00 17,648.42 138,725.27 0.00 53,809.73 72.05 42310 PHONES, FAX, ISDN LINES 35,200.00 106.69 12,464.64 0.00 22,735.36 35.41 42320 POSTAGE & SHIPPING 21,540.00 201.56 9,767.09 0.00 11,772.91 45.34 42340 OFFICE SUPPLIES 50,500.00 6,679.23 26,827.19 0.00 23,672.81 53.12 42345 FIRST AID KIT SUPPLIES 200.00 0.00 839.06 0.00 (639.06) 419.53 42350 PROGRAM EXPENDITURES 269,679.00 732.32 179,562.50 17,228.93 72,887.57 72.97 42360 CLEANING/JANITORIAL SUPPLIES 14,600.00 391.10 11,524.50 0.00 3,075.50 78.93 42365 RECYCLED CONTENT PRODUCTS 2,000.00 319.66 3,123.53 0.00 (1,123.53) 156.17 42410 ELECTRIC UTILITY 0.00 0.00 4,500.32 0.00 (4,500.32) 0.00 42441 UNLEADED FUEL 0.00 0.00 102.57 0.00 (102.57) 0.00 42500 RENTS & LEASES 1.00 0.00 0.00 0.00 1.00 0.00
42600 MOTOR POOL RENTAL - OPS & MTCE 2,319,562.00 0.00 1,141,708.00 0.00 1,177,854.00 49.22 42640 MDC RENTAL RATES 211,066.00 0.00 105,533.00 0.00 105,533.00 50.00 42800 EQUIPMENT MAINTENANCE 72,235.00 2,610.00 68,838.13 0.62 3,396.25 95.29 42810 BUILDING MAINTENANCE 3,600.00 30.04 584.99 0.00 3,015.01 16.24 42840 FACILITY RENTALS 2,000.00 0.00 0.00 0.00 2,000.00 0.00 42900 PROF. & CONT. SVCS 1,566,309.87 69,066.86 1,019,939.34 599,182.96 (52,812.43) 103.37 42905 SPECIAL INVESTIGATIONS 14,600.00 1,894.00 10,675.47 0.00 3,924.53 73.11 43100 MEMBERSHIP & DUES 10,904.00 175.00 9,551.30 0.00 1,352.70 87.59 43200 CONFERENCE, TRAINING & TRAVEL 83,089.00 582.60 80,755.55 0.00 2,333.45 97.19 43220 P.O.S.T. CONFERENCE & TRAINING 66,160.00 1,952.00 13,534.70 0.00 52,625.30 20.45 43500 BOOKS 0.00 0.00 684.08 0.00 (684.08) 0.00
43715 REGULATORY PERMIT & USE FEES 705.00 605.00 605.00 0.00 100.00 85.81 TOTAL FOR SERVICES-SUPPLIES 5,317,123.72 127,573.10 3,086,637.71 688,532.30 1,541,953.71 71.00 JULIEK Page: 15 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to

CAPITAL OUTLAY
45100 LICENSED VEHICLES 142,512.01 0.00 97,512.10 0.00 44,999.91 68.42 TOTAL FOR CAPITAL OUTLAY 142,512.01 0.00 97,512.10 0.00 44,999.91 68.42 TOTAL FOR POLICE 48,857,293.85 3,566,043.94 34,498,733.77 688,532.30 13,670,027.78 72.02 39 PUBLIC WORKS

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,726,684.37 108,930.57 1,052,928.56 0.00 673,755.81 60.97 41101 SPECIAL ASSIGNMENT PAY 0.00 8.75 8.75 0.00 (8.75) 0.00 41102 SHIFT DIFFERENTIAL 0.00 0.00 32.50 0.00 (32.50) 0.00 41140 FINAL LEAVE 0.00 0.00 11,254.80 0.00 (11,254.80) 0.00 41141 SP COMP-BILINGUAL 17,373.00 1,552.40 15,623.24 0.00 1,749.76 89.92 41300 OVERTIME 101,950.00 6,374.36 81,012.34 0.00 20,937.66 79.46 41320 COMP TIME 4,226.00 1,298.92 9,905.15 0.00 (5,679.15) 234.38 41400 SPECIAL DUTY PAY 59,848.00 4,295.90 37,739.31 0.00 22,108.69 63.05 41410 AUTO ALLOWANCE 3,053.00 234.84 2,230.98 0.00 822.02 73.07 41500 DEFERRED COMPENSATION MATCH 9,305.00 5,068.90 5,508.39 0.00 3,796.61 59.19 41520 TIERED EMP DEF COMPENSATION 5,844.00 1,453.50 4,368.00 0.00 1,476.00 74.74 41530 TIERED RHS BENEFIT 2,980.00 737.50 2,220.00 0.00 760.00 74.49 41600 LONGEVITY 14,219.00 974.54 9,553.45 0.00 4,665.55 67.18 41700 ANNUAL LEAVE BUYBACK 31,908.00 0.00 30,390.41 0.00 1,517.59 95.24 41710 ANNUAL LEAVE OVER MAX 2,875.00 0.00 2,837.58 0.00 37.42 98.69 41910 PERS-NORMAL 211,790.84 13,470.41 130,893.11 0.00 80,897.73 61.80 41920 MEDICARE 59,293.05 3,813.61 38,501.42 0.00 20,791.63 64.93 41929 SHORT TERM DISABILITY 5,522.42 505.94 4,763.83 0.00 758.59 86.26 41930 LONG TERM DISABILITY 11,742.52 839.15 7,901.96 0.00 3,840.56 67.29 41931 WORKERS COMP 35,580.70 2,200.36 21,633.23 0.00 13,947.47 60.80 41932 STATE UNEMPLOYMENT INSURANCE 1,761.52 111.11 1,170.16 0.00 591.36 66.42 41940 HEALTH INSURANCE 368,948.00 25,332.22 225,355.23 0.00 143,592.77 61.08 41945 OPT OUT HEALTH INSURANCE 23,952.00 2,178.00 41,211.81 0.00 (17,259.81) 172.05 41946 LIFE INSURANCE 14,331.07 1,024.22 9,644.96 0.00 4,686.11 67.30 41951 HEALTH ALLOWANCE CREDIT 0.00 268.19 4,862.46 0.00 (4,862.46) 0.00 41996 VACANCY FACTOR (252,324.00) 0.00 0.00 0.00 (252,324.00) 0.00 41997 BUDGETARY/PAYROLL 17,204.65 0.00 0.00 0.00 17,204.65 0.00 TOTAL FOR SALARIES-BENEFITS 2,478,068.14 180,673.39 1,751,551.63 0.00 726,516.51 70.68

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 6,500.00 837.49 9,234.64 0.00 (2,734.64) 142.07 42033 CONSTRUCTION MATERIALS 115,000.00 14,624.15 59,740.15 18,834.83 36,425.02 68.32 42034 SAFETY MATERIALS/CONSTRUCTION 7,700.00 775.97 8,918.65 45.35 (1,264.00) 116.41 42055 COMPUTER EQUIPMENT & 7,300.00 0.00 4,377.30 0.00 2,922.70 59.96 JULIEK Page: 16 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
42100 UNIFORM EXPENSE 7,300.00 500.45 3,542.02 0.00 3,757.98 48.52 42101 SAFETY SHOES - MOU ITEM 6,003.00 438.02 7,454.72 0.00 (1,451.72) 124.18 42200 ADVERTISING EXPENSE 5,300.00 0.00 3,653.79 0.00 1,646.21 68.93 42220 PROMOTIONAL/PUBLIC OUTREACH 5,000.00 0.00 0.00 0.00 5,000.00 0.00 42300 WIRELESS COMMUNICATION 13,400.00 0.00 7,926.97 0.00 5,473.03 59.15 42320 POSTAGE & SHIPPING 150.00 15.88 852.54 0.00 (702.54) 568.36 42340 OFFICE SUPPLIES 9,100.00 1,737.07 4,471.01 0.00 4,628.99 49.13 42345 FIRST AID KIT SUPPLIES 200.00 0.00 44.08 0.00 155.92 22.04 42350 PROGRAM EXPENDITURES 35,000.00 130.04 11,536.50 15,356.32 8,107.18 76.83 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 187.28 0.00 (187.28) 0.00 42441 UNLEADED FUEL 2,500.00 0.00 601.74 0.00 1,898.26 24.06 42442 DIESEL FUEL 500.00 0.00 512.32 0.00 (12.32) 102.46 42600 MOTOR POOL RENTAL - OPS & MTCE 484,594.00 0.00 215,311.52 0.00 269,282.48 44.43 42605 RETAINED VEHICLE EXPENSE 34,252.00 0.00 5,888.00 0.00 28,364.00 17.19 42700 OTHER EQUIPMENT RENTAL 15,000.00 986.00 5,787.52 0.00 9,212.48 38.58 42710 MILEAGE/VEHICLE EXP REIMB 650.00 0.00 36.29 0.00 613.71 5.58 42813 MTCE & REPAIR - EQUIP & FAC 125,000.00 2,016.93 17,090.40 46,038.48 61,871.12 50.50 42816 MOWING/LANDSCAPE CONTRACTS 64,560.00 3,520.19 24,548.42 3,501.58 36,510.00 43.44 42900 PROF. & CONT. SVCS 1,038,462.40 248,505.17 524,768.54 124,339.67 389,354.19 62.50 43100 MEMBERSHIP & DUES 3,695.00 0.00 2,543.10 0.00 1,151.90 68.82 43200 CONFERENCE, TRAINING & TRAVEL 31,185.00 6.00 8,962.77 0.00 22,222.23 28.74 43715 REGULATORY PERMIT & USE FEES 1,700.00 557.00 557.00 0.00 1,143.00 32.76 43716 JOB REQ CERTIFICATES & LICENSE 5,500.00 0.00 9,800.00 0.00 (4,300.00) 178.18 43724 OUTSIDE SERVICES - LABOR 11,259.80 0.00 0.00 11,259.80 0.00 100.00 43727 INSPECTION 0.00 0.00 14,994.00 0.00 (14,994.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,036,811.20 274,650.36 953,341.27 219,376.03 864,093.90 57.57

CAPITAL OUTLAY
45900 INFRASTRUCTURE 0.00 0.00 1,105.75 0.00 (1,105.75) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 1,105.75 0.00 (1,105.75) 0.00 TOTAL FOR PUBLIC WORKS 4,514,879.34 455,323.75 2,705,998.65 219,376.03 1,589,504.66 64.79 41 MAINTENANCE SERVICES

SERVICES-SUPPLIES
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 3,268,491.01 220,189.42 2,000,170.24 0.00 1,268,320.77 61.19 41103 OUT OF CLASS PAY 0.00 (328.18) 21,532.67 0.00 (21,532.67) 0.00 41140 FINAL LEAVE 0.00 0.00 4,228.88 0.00 (4,228.88) 0.00 JULIEK Page: 17 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41141 SP COMP-BILINGUAL 37,656.00 2,766.01 25,620.10 0.00 12,035.90 68.03 41200 TEMPORARY EMPLOYEES 2,141,415.00 163,965.87 1,454,201.98 0.00 687,213.02 67.90 41300 OVERTIME 189,176.00 10,271.79 194,530.88 0.00 (5,354.88) 102.83 41320 COMP TIME 4,500.00 464.57 5,575.03 0.00 (1,075.03) 123.88 41400 SPECIAL DUTY PAY 53,983.00 7,200.66 64,949.64 0.00 (10,966.64) 120.31 41410 AUTO ALLOWANCE 4,781.00 367.76 367.76 0.00 4,413.24 7.69 41500 DEFERRED COMPENSATION MATCH 15,457.00 5,539.99 7,829.99 0.00 7,627.01 50.65 41510 PST DEFERRED COMPENSATION 24,015.57 1,906.10 16,723.04 0.00 7,292.53 69.63 41520 TIERED EMP DEF COMPENSATION 8,298.00 1,684.50 5,284.50 0.00 3,013.50 63.68 41530 TIERED RHS BENEFIT 5,098.00 1,144.50 3,344.50 0.00 1,753.50 65.60 41600 LONGEVITY 17,723.00 1,510.92 13,485.93 0.00 4,237.07 76.09 41660 TUITION REIMBURSEMENT 2,130.00 1,110.00 11,022.28 0.00 (8,892.28) 517.47 41700 ANNUAL LEAVE BUYBACK 59,632.00 0.00 48,105.00 0.00 11,527.00 80.66 41710 ANNUAL LEAVE OVER MAX 3,335.00 0.00 17,361.86 0.00 (14,026.86) 520.59 41910 PERS-NORMAL 426,409.86 29,097.75 271,757.96 0.00 154,651.90 63.73 41920 MEDICARE 140,762.04 9,815.49 94,231.65 0.00 46,530.39 66.94 41929 SHORT TERM DISABILITY 10,355.93 914.57 8,324.32 0.00 2,031.61 80.38 41930 LONG TERM DISABILITY 22,008.84 1,516.97 13,793.09 0.00 8,215.75 62.67 41931 WORKERS COMP 110,016.45 7,727.02 70,452.29 0.00 39,564.16 64.03 41932 STATE UNEMPLOYMENT INSURANCE 5,230.23 369.45 3,543.14 0.00 1,687.09 67.74 41940 HEALTH INSURANCE 648,357.56 39,155.74 370,815.67 0.00 277,541.89 57.19 41945 OPT OUT HEALTH INSURANCE 59,040.00 6,277.68 91,425.97 0.00 (32,385.97) 154.85 41946 LIFE INSURANCE 26,857.57 1,851.51 16,835.19 0.00 10,022.38 62.68 41951 HEALTH ALLOWANCE CREDIT 0.00 504.40 10,829.95 0.00 (10,829.95) 0.00 41996 VACANCY FACTOR (393,171.00) 0.00 0.00 0.00 (393,171.00) 0.00 41997 BUDGETARY/PAYROLL 17,135.94 0.00 0.00 0.00 17,135.94 0.00 TOTAL FOR SALARIES-BENEFITS 6,908,694.00 515,024.49 4,846,343.51 0.00 2,062,350.49 70.14

SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,400.00 500.00 3,350.00 0.00 2,050.00 62.03 42010 SUBSCRIPTIONS 8,279.00 0.00 5,940.82 0.00 2,338.18 71.75 42012 AUDIO VISUAL 15,000.00 0.00 14,067.14 0.00 932.86 93.78 42014 ELECTRONIC INFO RESOURCES 29,232.93 17,000.00 27,431.41 1,128.94 672.58 97.69 42020 MINOR EQUIPMENT & FURNITURE 101,163.73 1,545.37 61,615.53 0.00 39,548.20 60.90 42030 BUILDING MAINTENANCE SUPPLIES 5,000.00 0.00 2,879.95 0.00 2,120.05 57.59 42033 CONSTRUCTION MATERIALS 331,450.00 48,917.52 310,718.11 75,293.10 (54,561.21) 116.46 42034 SAFETY MATERIALS/CONSTRUCTION 8,700.00 711.73 7,679.02 0.00 1,020.98 88.26 42055 COMPUTER EQUIPMENT & 9,052.00 0.00 4,346.07 0.00 4,705.93 48.01 42100 UNIFORM EXPENSE 25,514.00 1,424.75 20,034.54 0.00 5,479.46 78.52 42101 SAFETY SHOES - MOU ITEM 10,635.00 0.00 7,171.39 0.00 3,463.61 67.43 42200 ADVERTISING EXPENSE 4,600.00 0.00 90.06 0.00 4,509.94 1.95 JULIEK Page: 18 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
42220 PROMOTIONAL/PUBLIC OUTREACH 13,475.00 0.00 4,786.73 0.00 8,688.27 35.52 42300 WIRELESS COMMUNICATION 33,647.00 0.00 18,522.49 0.00 15,124.51 55.04 42310 PHONES, FAX, ISDN LINES 9,600.00 0.00 9,573.20 0.00 26.80 99.72 42320 POSTAGE & SHIPPING 53,700.00 15.36 30,623.62 0.00 23,076.38 57.02 42340 OFFICE SUPPLIES 25,239.00 323.40 8,856.18 0.00 16,382.82 35.08 42345 FIRST AID KIT SUPPLIES 1,783.00 0.00 815.43 0.00 967.57 45.73 42350 PROGRAM EXPENDITURES 322,247.19 28,556.34 246,241.47 10,750.30 65,255.42 79.74 42360 CLEANING/JANITORIAL SUPPLIES 0.00 164.44 1,007.20 0.00 (1,007.20) 0.00 42410 ELECTRIC UTILITY 19,743.00 912.76 14,376.80 0.00 5,366.20 72.81 42430 WATER UTILITY 0.00 33.34 7,862.54 0.00 (7,862.54) 0.00 42435 RECYCLED WATER UTILITY 0.00 129.37 4,930.75 0.00 (4,930.75) 0.00 42440 GASOLINE 1,479.00 0.00 0.00 0.00 1,479.00 0.00
42441 UNLEADED FUEL 3,457.00 0.00 3,043.05 0.00 413.95 88.02 42600 MOTOR POOL RENTAL - OPS & MTCE 198,366.00 0.00 99,178.25 0.00 99,187.75 49.99 42605 RETAINED VEHICLE EXPENSE 11,699.00 0.00 5,849.50 0.00 5,849.50 50.00 42610 DIRECT VEHICLE EXPENSE 2,900.00 0.00 221.87 0.00 2,678.13 7.65 42630 PARTS/LABOR ON CITY VEHICLES 700.00 0.00 0.00 0.00 700.00 0.00 42700 OTHER EQUIPMENT RENTAL 40,150.00 0.00 37,246.23 2,093.92 809.85 97.98 42710 MILEAGE/VEHICLE EXP REIMB 550.00 82.01 359.54 0.00 190.46 65.37 42800 EQUIPMENT MAINTENANCE 33,366.00 0.00 28,177.81 0.00 5,188.19 84.45 42810 BUILDING MAINTENANCE 0.00 0.00 91.67 0.00 (91.67) 0.00 42811 MAINTENANCE & OPERATING 150,000.00 0.00 148.05 0.00 149,851.95 0.09 42813 MTCE & REPAIR - EQUIP & FAC 1,031,193.18 57,909.98 682,028.86 432,119.26 (82,954.94) 108.04 42816 MOWING/LANDSCAPE CONTRACTS 1,663,924.00 191,978.86 1,063,434.14 212,989.50 387,500.36 76.71 42819 GRAFFITI REMOVAL 157,500.00 56,656.00 85,056.00 64,944.00 7,500.00 95.23 42821 TREE MAINTENANCE 996,017.00 39,807.00 1,068,516.50 0.00 (72,499.50) 107.27 42822 VANDALISM 11,000.00 0.00 0.00 0.00 11,000.00 0.00 42840 FACILITY RENTALS 5,700.00 0.00 0.00 0.00 5,700.00 0.00 42900 PROF. & CONT. SVCS 2,465,643.97 79,518.60 1,330,318.94 730,664.39 404,660.64 83.58 42910 REFUSE DISPOSAL 2,600.00 1,142.10 4,351.80 0.00 (1,751.80) 167.37 43000 INSURANCE & SURETY BONDS 9,200.00 0.00 7,222.00 0.00 1,978.00 78.50 43100 MEMBERSHIP & DUES 8,061.00 0.00 2,961.43 300.00 4,799.57 40.45 43110 EMPLOYEE ENGAGEMENT 0.00 0.00 61.77 0.00 (61.77) 0.00 43200 CONFERENCE, TRAINING & TRAVEL 23,577.53 416.80 10,875.47 0.00 12,702.06 46.12 43500 BOOKS 40,500.00 2,978.49 22,341.72 0.00 18,158.28 55.16 43501 CHILDREN'S BOOKS 30,000.00 836.85 19,368.71 0.00 10,631.29 64.56 43505 PASSPORT EXPENSES 31,675.00 50.94 18,838.35 200.00 12,636.65 60.10 43715 REGULATORY PERMIT & USE FEES 11,781.00 962.78 12,677.42 0.00 (896.42) 107.60 43716 JOB REQ CERTIFICATES & LICENSE 1,200.00 0.00 1,130.80 0.00 69.20 94.23 43722 PREVENTION & MAINTENANCE 378,017.88 3,248.24 83,103.53 75,547.40 219,366.95 41.96 JULIEK Page: 19 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
TOTAL FOR SERVICES-SUPPLIES 8,343,718.41 535,823.03 5,399,523.86 1,606,030.81 1,338,163.74 83.96

CAPITAL OUTLAY
45100 LICENSED VEHICLES 25,775.00 0.00 0.00 0.00 25,775.00 0.00 45200 MACHINERY, EQUIPMENT, & FIXTUR 0.00 0.00 66,594.75 0.00 (66,594.75) 0.00 TOTAL FOR CAPITAL OUTLAY 25,775.00 0.00 66,594.75 0.00 (40,819.75) 258.36 TOTAL FOR COMMUNITY SERVICES 15,278,187.41 1,050,847.52 10,312,462.12 1,606,030.81 3,359,694.48 78.00 65 PARK MAINTENANCE/LMD

SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR PARK MAINTENANCE/LMD 0.00 0.00 0.00 0.00 0.00 0.00 FUN 110 190,185,926.30 12,184,690.14 108,541,617.55 8,042,752.11 73,601,556.64 61.30 JULIEK Page: 20 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
120 MEASURE X FUND
00 NOT APPLICABLE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 3,398.53 31,940.36 0.00 (31,940.36) 0.00 41141 SP COMP-BILINGUAL 0.00 10.39 132.42 0.00 (132.42) 0.00 41300 OVERTIME 0.00 0.00 148.61 0.00 (148.61) 0.00
41600 LONGEVITY 0.00 0.00 36.91 0.00 (36.91) 0.00
41910 PERS-NORMAL 0.00 410.10 3,862.69 0.00 (3,862.69) 0.00 41920 MEDICARE 0.00 101.76 960.61 0.00 (960.61) 0.00
41931 WORKERS COMP 0.00 68.18 641.92 0.00 (641.92) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 3.09 29.44 0.00 (29.44) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 9.53 0.00 (9.53) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 3,992.05 37,762.49 0.00 (37,762.49) 0.00

SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 30,056,599.64 0.00 0.00 0.00 30,056,599.64 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 26,401.64 0.00 (26,401.64) 0.00 42028 SCBA BREATHING APPARATUS 0.00 0.00 (167.04) 0.00 167.04 0.00 42200 ADVERTISING EXPENSE 0.00 352.09 1,613.32 0.00 (1,613.32) 0.00 42305 PBLC SFTY RADIO COMMUNICATION 0.00 0.00 18,933.00 0.00 (18,933.00) 0.00 42350 PROGRAM EXPENDITURES 0.00 223.85 23,369.79 0.00 (23,369.79) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 38,800.00 71,418.00 0.00 (71,418.00) 0.00 42900 PROF. & CONT. SVCS 216,434.53 505,021.17 761,782.30 7,672,773.85 (8,218,121.62) 3,897.04 43300 CONSTRUCTION CONTRACTS 682,385.00 0.00 687,637.11 342,392.00 (347,644.11) 150.94 43715 REGULATORY PERMIT & USE FEES 0.00 0.00 51.14 0.00 (51.14) 0.00 TOTAL FOR SERVICES-SUPPLIES 30,955,419.17 544,397.11 1,591,039.26 8,015,165.85 21,349,214.06 31.03

CAPITAL OUTLAY
45100 LICENSED VEHICLES 651,566.41 0.00 584,817.41 1,929,072.13 (1,862,323.13) 385.82 45400 LAND 0.00 0.00 1,196,736.25 0.00 (1,196,736.25) 0.00 TOTAL FOR CAPITAL OUTLAY 651,566.41 0.00 1,781,553.66 1,929,072.13 (3,059,059.38) 569.49 TOTAL FOR NOT APPLICABLE 31,606,985.58 548,389.16 3,410,355.41 9,944,237.98 18,252,392.19 42.25 11 CITY MANAGER'S OFFICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 602,117.00 45,109.06 401,665.27 0.00 200,451.73 66.70 41300 OVERTIME 15,000.00 866.12 12,843.95 0.00 2,156.05 85.62 41700 ANNUAL LEAVE BUYBACK 15,297.00 0.00 5,287.20 0.00 10,009.80 34.56 41710 ANNUAL LEAVE OVER MAX 0.00 0.00 2,329.67 0.00 (2,329.67) 0.00 41910 PERS-NORMAL 72,435.00 5,426.62 48,490.45 0.00 23,944.55 66.94 41920 MEDICARE 18,782.00 1,350.45 12,840.02 0.00 5,941.98 68.36 41929 SHORT TERM DISABILITY 1,926.00 184.97 1,646.83 0.00 279.17 85.50 41930 LONG TERM DISABILITY 4,094.00 306.72 2,731.28 0.00 1,362.72 66.71 JULIEK Page: 21 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41931 WORKERS COMP 12,043.00 877.41 7,919.07 0.00 4,123.93 65.75 41932 STATE UNEMPLOYMENT INSURANCE 574.00 41.23 390.37 0.00 183.63 68.00 41940 HEALTH INSURANCE 92,520.00 6,014.64 46,519.14 0.00 46,000.86 50.28 41945 OPT OUT HEALTH INSURANCE 7,200.00 400.00 13,255.10 0.00 (6,055.10) 184.09 41946 LIFE INSURANCE 4,997.00 374.41 3,333.71 0.00 1,663.29 66.71 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 925.92 0.00 (925.92) 0.00 TOTAL FOR SALARIES-BENEFITS 846,985.00 60,951.63 560,177.98 0.00 286,807.02 66.13

SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 7,188.00 0.00 7,188.00 0.00 0.00 100.00 42020 MINOR EQUIPMENT & FURNITURE 8,677.40 0.00 1,322.60 0.00 7,354.80 15.24 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 4,830.60 0.00 1,199.68 0.00 3,630.92 24.83 42320 POSTAGE & SHIPPING 400.00 0.00 0.00 0.00 400.00 0.00 42340 OFFICE SUPPLIES 2,000.00 0.00 0.00 0.00 2,000.00 0.00 42350 PROGRAM EXPENDITURES 413,000.00 0.00 186,721.37 0.00 226,278.63 45.21 42710 MILEAGE/VEHICLE EXP REIMB 2,000.00 0.00 0.00 0.00 2,000.00 0.00 42800 EQUIPMENT MAINTENANCE 0.00 0.00 83.02 0.00 (83.02) 0.00 42900 PROF. & CONT. SVCS 6,791,956.94 13,000.00 1,237,265.48 2,041,152.41 3,513,539.05 48.26 43100 MEMBERSHIP & DUES 690.00 0.00 0.00 0.00 690.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 24,500.00 0.00 10,035.36 0.00 14,464.64 40.96 43301 CAPITAL IMPROVEMENTS 110,000.00 0.00 0.00 0.00 110,000.00 0.00 TOTAL FOR SERVICES-SUPPLIES 7,366,242.94 13,000.00 1,443,815.51 2,041,152.41 3,881,275.02 47.30 TOTAL FOR CITY MANAGER'S OFFICE 8,213,227.94 73,951.63 2,003,993.49 2,041,152.41 4,168,082.04 49.25 13 DEBT SERVICE

SERVICES-SUPPLIES
44001 DS PRINCIPAL 2021 POBS 2,273,224.00 0.00 0.00 0.00 2,273,224.00 0.00 44101 DS INTEREST 2021 POBS 613,752.00 0.00 306,876.13 0.00 306,875.87 50.00 TOTAL FOR SERVICES-SUPPLIES 2,886,976.00 0.00 306,876.13 0.00 2,580,099.87 10.62 TOTAL FOR DEBT SERVICE 2,886,976.00 0.00 306,876.13 0.00 2,580,099.87 10.62 15 HUMAN RESOURCES

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 340,664.00 25,939.20 226,903.64 0.00 113,760.36 66.60 41103 OUT OF CLASS PAY 0.00 0.00 2,040.00 0.00 (2,040.00) 0.00 41141 SP COMP-BILINGUAL 3,870.00 297.70 2,828.15 0.00 1,041.85 73.07 41300 OVERTIME 0.00 0.00 231.97 0.00 (231.97) 0.00
41600 LONGEVITY 0.00 107.68 161.52 0.00 (161.52) 0.00
41700 ANNUAL LEAVE BUYBACK 1,963.00 0.00 1,869.00 0.00 94.00 95.21 41910 PERS-NORMAL 41,447.00 3,169.26 27,656.31 0.00 13,790.69 66.72 JULIEK Page: 22 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41920 MEDICARE 10,463.00 794.34 7,154.02 0.00 3,308.98 68.37 41929 SHORT TERM DISABILITY 1,090.00 106.34 930.32 0.00 159.68 85.35 41930 LONG TERM DISABILITY 2,317.00 176.38 1,542.98 0.00 774.02 66.59 41931 WORKERS COMP 6,891.00 521.20 4,618.44 0.00 2,272.56 67.02 41932 STATE UNEMPLOYMENT INSURANCE 319.00 24.44 220.51 0.00 98.49 69.12 41940 HEALTH INSURANCE 52,538.00 3,320.96 23,029.42 0.00 29,508.58 43.83 41945 OPT OUT HEALTH INSURANCE 7,200.00 600.00 8,395.69 0.00 (1,195.69) 116.60 41946 LIFE INSURANCE 2,827.00 215.30 1,883.33 0.00 943.67 66.61 41951 HEALTH ALLOWANCE CREDIT 0.00 211.36 1,162.86 0.00 (1,162.86) 0.00 TOTAL FOR SALARIES-BENEFITS 471,589.00 35,484.16 310,628.16 0.00 160,960.84 65.86

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 36,000.00 0.00 41,673.00 0.00 (5,673.00) 115.75 42350 PROGRAM EXPENDITURES 25,000.00 0.00 15,326.39 0.00 9,673.61 61.30 TOTAL FOR SERVICES-SUPPLIES 61,000.00 0.00 56,999.39 0.00 4,000.61 93.44 TOTAL FOR HUMAN RESOURCES 532,589.00 35,484.16 367,627.55 0.00 164,961.45 69.02 17 INFORMATION TECHNOLOGY

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 88,039.00 6,771.20 63,161.60 0.00 24,877.40 71.74 41141 SP COMP-BILINGUAL 0.00 175.00 1,400.00 0.00 (1,400.00) 0.00 41300 OVERTIME 0.00 1,441.67 5,563.06 0.00 (5,563.06) 0.00 41320 COMP TIME 0.00 0.00 1,487.44 0.00 (1,487.44) 0.00 41400 SPECIAL DUTY PAY 0.00 400.00 2,800.00 0.00 (2,800.00) 0.00 41910 PERS-NORMAL 10,591.00 835.64 7,770.67 0.00 2,820.33 73.37 41920 MEDICARE 2,600.00 258.02 2,141.32 0.00 458.68 82.35 41929 SHORT TERM DISABILITY 282.00 27.76 258.96 0.00 23.04 91.82 41930 LONG TERM DISABILITY 599.00 46.04 429.54 0.00 169.46 71.70 41931 WORKERS COMP 1,761.00 137.92 1,279.35 0.00 481.65 72.64 41932 STATE UNEMPLOYMENT INSURANCE 79.00 7.98 66.18 0.00 12.82 83.77 41940 HEALTH INSURANCE 24,640.00 1,973.60 17,475.20 0.00 7,164.80 70.92 41946 LIFE INSURANCE 731.00 56.20 524.24 0.00 206.76 71.71 41951 HEALTH ALLOWANCE CREDIT 0.00 78.84 709.56 0.00 (709.56) 0.00 TOTAL FOR SALARIES-BENEFITS 129,322.00 12,209.87 105,067.12 0.00 24,254.88 81.24

SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 10,000.00 0.00 0.00 0.00 10,000.00 0.00 42101 SAFETY SHOES - MOU ITEM 300.00 0.00 573.06 0.00 (273.06) 191.02 42912 CAD DISPATCH SERVICES 877,315.00 53,909.63 111,594.02 49,062.93 716,658.05 18.31 TOTAL FOR SERVICES-SUPPLIES 887,615.00 53,909.63 112,167.08 49,062.93 726,384.99 18.16

CAPITAL OUTLAY
45300 COMPUTER SOFTWARE 100,000.00 0.00 0.00 0.00 100,000.00 0.00 JULIEK Page: 23 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
TOTAL FOR CAPITAL OUTLAY 100,000.00 0.00 0.00 0.00 100,000.00 0.00 TOTAL FOR INFORMATION TECHNOLOGY 1,116,937.00 66,119.50 217,234.20 49,062.93 850,639.87 23.84 18 FINANCE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 189,349.00 14,148.80 109,074.40 0.00 80,274.60 57.60 41141 SP COMP-BILINGUAL 3,870.00 297.70 2,828.15 0.00 1,041.85 73.07 41500 DEFERRED COMPENSATION MATCH 1,900.00 1,900.00 2,500.00 0.00 (600.00) 131.57 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 450.00 0.00 150.00 75.00 41530 TIERED RHS BENEFIT 600.00 150.00 450.00 0.00 150.00 75.00 41600 LONGEVITY 1,600.00 123.06 1,169.07 0.00 430.93 73.06 41700 ANNUAL LEAVE BUYBACK 8,078.00 0.00 8,076.80 0.00 1.20 99.98 41710 ANNUAL LEAVE OVER MAX 0.00 0.00 3,947.03 0.00 (3,947.03) 0.00 41910 PERS-NORMAL 23,437.00 1,752.72 13,602.52 0.00 9,834.48 58.03 41920 MEDICARE 6,073.00 479.56 3,734.39 0.00 2,338.61 61.49 41929 SHORT TERM DISABILITY 606.00 58.02 447.27 0.00 158.73 73.80 41930 LONG TERM DISABILITY 1,288.00 96.22 741.69 0.00 546.31 57.58 41931 WORKERS COMP 3,865.00 281.10 2,204.56 0.00 1,660.44 57.03 41932 STATE UNEMPLOYMENT INSURANCE 183.00 12.97 109.13 0.00 73.87 59.63 41940 HEALTH INSURANCE 49,280.00 3,573.74 25,494.06 0.00 23,785.94 51.73 41946 LIFE INSURANCE 1,571.00 117.44 905.32 0.00 665.68 57.62 41951 HEALTH ALLOWANCE CREDIT 0.00 32.80 723.36 0.00 (723.36) 0.00 TOTAL FOR SALARIES-BENEFITS 292,300.00 23,174.13 176,457.75 0.00 115,842.25 60.36 TOTAL FOR FINANCE 292,300.00 23,174.13 176,457.75 0.00 115,842.25 60.36 19 ECONOMIC DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 217,180.00 17,497.60 163,203.20 0.00 53,976.80 75.14 41141 SP COMP-BILINGUAL 3,870.00 297.70 2,828.15 0.00 1,041.85 73.07 41910 PERS-NORMAL 26,592.00 2,140.78 19,973.69 0.00 6,618.31 75.11 41920 MEDICARE 6,746.00 515.84 5,109.60 0.00 1,636.40 75.74 41929 SHORT TERM DISABILITY 695.00 71.76 669.12 0.00 25.88 96.27 41930 LONG TERM DISABILITY 1,477.00 119.00 1,109.78 0.00 367.22 75.13 41931 WORKERS COMP 4,421.00 348.98 3,270.62 0.00 1,150.38 73.97 41932 STATE UNEMPLOYMENT INSURANCE 206.00 15.94 157.85 0.00 48.15 76.62 41940 HEALTH INSURANCE 18,598.00 3,636.31 19,993.69 0.00 (1,395.69) 107.50 41945 OPT OUT HEALTH INSURANCE 7,200.00 0.00 9,359.64 0.00 (2,159.64) 129.99 41946 LIFE INSURANCE 1,802.00 145.24 1,354.58 0.00 447.42 75.17 41951 HEALTH ALLOWANCE CREDIT 0.00 6.66 240.90 0.00 (240.90) 0.00 TOTAL FOR SALARIES-BENEFITS 288,787.00 24,795.81 227,270.82 0.00 61,516.18 78.69

SERVICES-SUPPLIES
JULIEK Page: 24 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
42020 MINOR EQUIPMENT & FURNITURE 500.00 0.00 468.90 0.00 31.10 93.78 42055 COMPUTER EQUIPMENT & 1,000.00 0.00 0.00 0.00 1,000.00 0.00 42300 WIRELESS COMMUNICATION 650.00 0.00 658.20 0.00 (8.20) 101.26 42340 OFFICE SUPPLIES 0.00 0.00 38.21 0.00 (38.21) 0.00 42900 PROF. & CONT. SVCS 305,000.00 0.00 15,000.00 15,000.00 275,000.00 9.83 43100 MEMBERSHIP & DUES 1,610.00 0.00 389.00 0.00 1,221.00 24.16 43200 CONFERENCE, TRAINING & TRAVEL 20,400.00 0.00 0.00 0.00 20,400.00 0.00 TOTAL FOR SERVICES-SUPPLIES 329,160.00 0.00 16,554.31 15,000.00 297,605.69 9.58 TOTAL FOR ECONOMIC DEVELOPMENT 617,947.00 24,795.81 243,825.13 15,000.00 359,121.87 41.88 20 LEGAL AND RISK MANAGEMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 189,624.00 14,769.60 137,768.80 0.00 51,855.20 72.65 41910 PERS-NORMAL 22,812.00 1,776.78 16,573.51 0.00 6,238.49 72.65 41920 MEDICARE 5,648.00 429.90 4,064.27 0.00 1,583.73 71.95 41929 SHORT TERM DISABILITY 607.00 60.56 564.82 0.00 42.18 93.05 41930 LONG TERM DISABILITY 1,289.00 100.44 936.82 0.00 352.18 72.67 41931 WORKERS COMP 3,792.00 287.98 2,723.12 0.00 1,068.88 71.81 41932 STATE UNEMPLOYMENT INSURANCE 171.00 13.14 124.32 0.00 46.68 72.70 41940 HEALTH INSURANCE 24,640.00 2,158.72 18,311.00 0.00 6,329.00 74.31 41946 LIFE INSURANCE 1,574.00 122.58 1,143.51 0.00 430.49 72.64 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 518.04 0.00 (518.04) 0.00 TOTAL FOR SALARIES-BENEFITS 250,157.00 19,719.70 182,728.21 0.00 67,428.79 73.04 TOTAL FOR LEGAL AND RISK MANAGEMENT 250,157.00 19,719.70 182,728.21 0.00 67,428.79 73.04 21 PLANNING & DEVELOPMENT

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 908,600.00 52,855.85 472,464.62 0.00 436,135.38 51.99 41140 FINAL LEAVE 0.00 3,553.82 3,553.82 0.00 (3,553.82) 0.00 41141 SP COMP-BILINGUAL 4,606.00 393.72 4,286.27 0.00 319.73 93.05 41300 OVERTIME 0.00 155.39 543.16 0.00 (543.16) 0.00
41500 DEFERRED COMPENSATION MATCH 2,400.00 831.25 1,562.50 0.00 837.50 65.10 41520 TIERED EMP DEF COMPENSATION 600.00 262.50 787.50 0.00 (187.50) 131.25 41530 TIERED RHS BENEFIT 600.00 187.50 562.50 0.00 37.50 93.75 41600 LONGEVITY 4,492.00 484.72 4,489.35 0.00 2.65 99.94 41700 ANNUAL LEAVE BUYBACK 9,570.00 0.00 10,132.80 0.00 (562.80) 105.88 41910 PERS-NORMAL 110,397.00 6,464.22 57,893.06 0.00 52,503.94 52.44 41920 MEDICARE 27,730.00 1,737.56 15,185.13 0.00 12,544.87 54.76 41929 SHORT TERM DISABILITY 2,909.00 235.74 2,073.75 0.00 835.25 71.28 41930 LONG TERM DISABILITY 6,178.00 391.00 3,439.70 0.00 2,738.30 55.67 41931 WORKERS COMP 18,304.00 1,041.28 9,450.56 0.00 8,853.44 51.63 JULIEK Page: 25 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41932 STATE UNEMPLOYMENT INSURANCE 840.00 52.44 464.71 0.00 375.29 55.32 41940 HEALTH INSURANCE 237,338.00 9,032.49 79,916.69 0.00 157,421.31 33.67 41945 OPT OUT HEALTH INSURANCE 4,800.00 1,350.00 19,229.93 0.00 (14,429.93) 400.62 41946 LIFE INSURANCE 7,541.00 477.25 4,198.64 0.00 3,342.36 55.67 41951 HEALTH ALLOWANCE CREDIT 0.00 210.56 2,475.47 0.00 (2,475.47) 0.00 41996 VACANCY FACTOR (251,814.00) 0.00 0.00 0.00 (251,814.00) 0.00 41997 BUDGETARY/PAYROLL (75,000.00) 0.00 0.00 0.00 (75,000.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,020,091.00 79,717.29 692,710.16 0.00 327,380.84 67.90

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 28,600.00 0.00 0.00 0.00 28,600.00 0.00 42033 CONSTRUCTION MATERIALS 85,000.00 0.00 0.00 0.00 85,000.00 0.00 42101 SAFETY SHOES - MOU ITEM 1,350.00 0.00 1,230.00 0.00 120.00 91.11 42300 WIRELESS COMMUNICATION 0.00 0.00 357.16 0.00 (357.16) 0.00 42900 PROF. & CONT. SVCS 75,000.00 0.00 0.00 0.00 75,000.00 0.00 43724 OUTSIDE SERVICES - LABOR 0.00 512.00 512.00 0.00 (512.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 189,950.00 512.00 2,099.16 0.00 187,850.84 1.10 TOTAL FOR PLANNING & DEVELOPMENT DEPT1,210,041.00 80,229.29 694,809.32 0.00 515,231.68 57.42 30 FIRE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,217,834.00 92,262.40 838,557.03 0.00 379,276.97 68.85 41140 FINAL LEAVE 0.00 0.00 42,381.03 0.00 (42,381.03) 0.00 41141 SP COMP-BILINGUAL 2,275.00 465.38 4,421.11 0.00 (2,146.11) 194.33 41151 SP COMP-SECONDARY MEDIC 5,345.00 411.16 4,111.60 0.00 1,233.40 76.92 41200 TEMPORARY EMPLOYEES 177,152.00 11,694.78 93,300.85 0.00 83,851.15 52.66 41300 OVERTIME 0.00 58.53 150.29 0.00 (150.29) 0.00
41310 OVERTIME - FLSA 16,272.00 1,186.83 11,599.20 0.00 4,672.80 71.28 41330 CONSTANT STAFF LEVELS-OT FIRE 0.00 0.00 299.41 0.00 (299.41) 0.00 41350 OVERTIME - TRAINING 47,093.00 7,003.16 47,593.39 0.00 (500.39) 101.06 41400 SPECIAL DUTY PAY 4,000.00 0.00 887.80 0.00 3,112.20 22.19 41420 FIRE HOLIDAY PAY 35,049.00 0.00 26,338.20 0.00 8,710.80 75.14 41510 PST DEFERRED COMPENSATION 2,301.00 152.05 1,168.93 0.00 1,132.07 50.80 41530 TIERED RHS BENEFIT 17,500.00 5,000.00 13,125.00 0.00 4,375.00 75.00 41600 LONGEVITY 18,477.00 1,459.28 13,718.76 0.00 4,758.24 74.24 41660 TUITION REIMBURSEMENT 6,120.00 0.00 850.00 0.00 5,270.00 13.88 41910 PERS-NORMAL 224,214.00 16,857.06 158,886.52 0.00 65,327.48 70.86 41920 MEDICARE 25,517.00 2,093.90 20,878.87 0.00 4,638.13 81.82 41929 SHORT TERM DISABILITY 3,900.00 378.29 3,435.94 0.00 464.06 88.10 41930 LONG TERM DISABILITY 8,280.00 627.40 5,698.69 0.00 2,581.31 68.82 41931 WORKERS COMP 68,262.00 4,842.37 46,343.84 0.00 21,918.16 67.89 JULIEK Page: 26 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41932 STATE UNEMPLOYMENT INSURANCE 1,349.00 101.56 971.70 0.00 377.30 72.03 41940 HEALTH INSURANCE 188,296.00 14,673.68 137,989.11 0.00 50,306.89 73.28 41945 OPT OUT HEALTH INSURANCE 7,200.00 400.00 4,459.90 0.00 2,740.10 61.94 41946 LIFE INSURANCE 10,106.00 765.74 6,955.64 0.00 3,150.36 68.82 41951 HEALTH ALLOWANCE CREDIT 0.00 217.78 3,979.35 0.00 (3,979.35) 0.00 41997 BUDGETARY/PAYROLL 7,798.00 0.00 0.00 0.00 7,798.00 0.00 TOTAL FOR SALARIES-BENEFITS 2,094,340.00 160,651.35 1,488,102.16 0.00 606,237.84 71.05

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 18,000.00 0.00 20,785.89 0.00 (2,785.89) 115.47 42055 COMPUTER EQUIPMENT & 0.00 0.00 1,875.44 0.00 (1,875.44) 0.00 42101 SAFETY SHOES - MOU ITEM 300.00 0.00 0.00 0.00 300.00 0.00 42105 PROTECTIVE CLOTHING 78,000.00 0.00 0.00 77,859.56 140.44 99.81 42305 PBLC SFTY RADIO COMMUNICATION 37,580.00 0.00 0.00 0.00 37,580.00 0.00 42900 PROF. & CONT. SVCS 0.00 0.00 0.00 6,900.00 (6,900.00) 0.00 43200 CONFERENCE, TRAINING & TRAVEL 20,945.00 576.00 7,781.09 0.00 13,163.91 37.15 TOTAL FOR SERVICES-SUPPLIES 154,825.00 576.00 30,442.42 84,759.56 39,623.02 74.40

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 2,574,165.00 161,227.35 1,518,544.58 84,759.56 970,860.86 62.28 32 POLICE

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,019,180.00 117,350.37 828,592.49 0.00 1,190,587.51 41.03 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 348.88 0.00 (348.88) 0.00 41102 SHIFT DIFFERENTIAL 10,000.00 1,425.04 4,581.04 0.00 5,418.96 45.81 41140 FINAL LEAVE 0.00 0.00 1,755.18 0.00 (1,755.18) 0.00 41141 SP COMP-BILINGUAL 11,590.00 1,367.16 11,271.04 0.00 318.96 97.24 41143 SP COMP-CGEA TRAINING OFFICER 0.00 137.69 789.12 0.00 (789.12) 0.00 41160 SP COMP-ADVANCED POST 44,540.00 3,869.28 30,406.93 0.00 14,133.07 68.26 41167 SP COMP-TRAFFIC CPL/SGT 5,723.00 445.68 4,375.20 0.00 1,347.80 76.44 41178 SP COMP-PERSONNEL & TRAINING 0.00 574.72 3,587.85 0.00 (3,587.85) 0.00 41179 SP COMP-TRAINING OFFICER 0.00 0.00 27.86 0.00 (27.86) 0.00 41183 SP COMP-HOPE-HMLS OUTRCH & 7,380.00 547.36 1,635.40 0.00 5,744.60 22.15 41184 SP COMP-FLEX TEAM OFFICER/CORP 0.00 0.00 239.01 0.00 (239.01) 0.00 41200 TEMPORARY EMPLOYEES 289,437.00 2,591.25 44,021.43 0.00 245,415.57 15.20 41300 OVERTIME 150,400.00 37,772.70 217,679.06 0.00 (67,279.06) 144.73 41310 OVERTIME - FLSA 0.00 123.75 146.25 0.00 (146.25) 0.00 41320 COMP TIME 66,400.00 4,260.27 13,636.29 0.00 52,763.71 20.53 41400 SPECIAL DUTY PAY 9,650.00 801.28 3,929.51 0.00 5,720.49 40.72 JULIEK Page: 27 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41500 DEFERRED COMPENSATION MATCH 0.00 850.00 1,650.00 0.00 (1,650.00) 0.00 41510 PST DEFERRED COMPENSATION 1,662.00 33.69 331.22 0.00 1,330.78 19.92 41520 TIERED EMP DEF COMPENSATION 0.00 300.00 900.00 0.00 (900.00) 0.00 41530 TIERED RHS BENEFIT 35,000.00 8,950.00 26,850.00 0.00 8,150.00 76.71 41600 LONGEVITY 27,121.00 2,735.40 25,751.58 0.00 1,369.42 94.95 41601 MARKSMANSHIP 2,940.00 183.57 1,883.83 0.00 1,056.17 64.07 41660 TUITION REIMBURSEMENT 3,590.00 0.00 5,552.00 0.00 (1,962.00) 154.65 41700 ANNUAL LEAVE BUYBACK 9,840.00 0.00 8,696.00 0.00 1,144.00 88.37 41710 ANNUAL LEAVE OVER MAX 0.00 0.00 4,337.84 0.00 (4,337.84) 0.00 41800 UNIFORM ALLOWANCE 27,760.00 2,064.66 19,054.74 0.00 8,705.26 68.64 41910 PERS-NORMAL 383,741.00 24,250.29 185,943.97 0.00 197,797.03 48.45 41920 MEDICARE 75,075.00 5,116.49 36,115.67 0.00 38,959.33 48.10 41929 SHORT TERM DISABILITY 6,458.00 564.30 4,786.11 0.00 1,671.89 74.11 41930 LONG TERM DISABILITY 13,731.00 619.32 9,075.45 0.00 4,655.55 66.09 41931 WORKERS COMP 87,595.00 4,848.14 36,740.93 0.00 50,854.07 41.94 41932 STATE UNEMPLOYMENT INSURANCE 2,409.00 158.23 1,124.23 0.00 1,284.77 46.66 41940 HEALTH INSURANCE 468,638.00 20,707.52 171,248.07 0.00 297,389.93 36.54 41945 OPT OUT HEALTH INSURANCE 15,600.00 2,300.00 22,442.65 0.00 (6,842.65) 143.86 41946 LIFE INSURANCE 16,762.00 1,142.38 9,768.91 0.00 6,993.09 58.28 41951 HEALTH ALLOWANCE CREDIT 0.00 245.60 3,769.35 0.00 (3,769.35) 0.00 41996 VACANCY FACTOR (380,973.00) 0.00 0.00 0.00 (380,973.00) 0.00 41997 BUDGETARY/PAYROLL 6,454.00 0.00 0.00 0.00 6,454.00 0.00 41999 PAYROLL SUSPENSE 0.00 436.00 4,067.80 0.00 (4,067.80) 0.00 TOTAL FOR SALARIES-BENEFITS 3,417,703.00 246,772.14 1,747,112.89 0.00 1,670,590.11 51.11

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 2,640,346.12 32,000.61 2,141,252.82 434,979.01 64,114.29 97.57 42055 COMPUTER EQUIPMENT & 0.00 0.00 69.80 0.00 (69.80) 0.00 42100 UNIFORM EXPENSE 0.00 0.00 5,133.00 0.00 (5,133.00) 0.00 42101 SAFETY SHOES - MOU ITEM 4,650.00 0.00 388.20 0.00 4,261.80 8.34 42105 PROTECTIVE CLOTHING 1,610.00 0.00 0.00 0.00 1,610.00 0.00 42300 WIRELESS COMMUNICATION 71,190.00 0.00 3,874.87 47,838.55 19,476.58 72.64 42310 PHONES, FAX, ISDN LINES 12,000.00 0.00 0.00 0.00 12,000.00 0.00 42350 PROGRAM EXPENDITURES 5,250.00 15.64 3,152.50 0.00 2,097.50 60.04 42600 MOTOR POOL RENTAL - OPS & MTCE 66,147.00 0.00 0.00 0.00 66,147.00 0.00 42640 MDC RENTAL RATES 5,484.00 0.00 2,742.00 0.00 2,742.00 50.00 42900 PROF. & CONT. SVCS 233,800.00 0.00 175,275.00 60,088.28 (1,563.28) 100.66 43200 CONFERENCE, TRAINING & TRAVEL 41,400.00 0.00 24,295.01 0.00 17,104.99 58.68 43220 P.O.S.T. CONFERENCE & TRAINING 55,000.00 0.00 49,334.63 0.00 5,665.37 89.69 TOTAL FOR SERVICES-SUPPLIES 3,136,877.12 32,016.25 2,405,517.83 542,905.84 188,453.45 93.99

CAPITAL OUTLAY
JULIEK Page: 28 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
45100 LICENSED VEHICLES 64,055.85 0.00 64,055.85 0.00 0.00 100.00 TOTAL FOR CAPITAL OUTLAY 64,055.85 0.00 64,055.85 0.00 0.00 100.00 TOTAL FOR POLICE 6,618,635.97 278,788.39 4,216,686.57 542,905.84 1,859,043.56 71.91 39 PUBLIC WORKS

SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 281,193.00 11,131.20 74,711.20 0.00 206,481.80 26.56 41141 SP COMP-BILINGUAL 0.00 175.00 437.50 0.00 (437.50) 0.00 41200 TEMPORARY EMPLOYEES 17,597.00 0.00 0.00 0.00 17,597.00 0.00 41300 OVERTIME 0.00 0.00 1,248.48 0.00 (1,248.48) 0.00
41910 PERS-NORMAL 35,970.00 1,360.14 9,040.39 0.00 26,929.61 25.13 41920 MEDICARE 8,572.00 320.93 2,225.26 0.00 6,346.74 25.95 41929 SHORT TERM DISABILITY 900.00 45.64 306.32 0.00 593.68 34.03 41930 LONG TERM DISABILITY 1,911.00 75.70 508.03 0.00 1,402.97 26.58 41931 WORKERS COMP 5,976.00 221.00 1,489.33 0.00 4,486.67 24.92 41932 STATE UNEMPLOYMENT INSURANCE 268.00 9.90 68.69 0.00 199.31 25.63 41940 HEALTH INSURANCE 73,920.00 4,029.20 22,870.04 0.00 51,049.96 30.93 41946 LIFE INSURANCE 2,334.00 92.40 620.20 0.00 1,713.80 26.57 41951 HEALTH ALLOWANCE CREDIT 0.00 81.10 716.34 0.00 (716.34) 0.00 41996 VACANCY FACTOR (107,235.00) 0.00 0.00 0.00 (107,235.00) 0.00 TOTAL FOR SALARIES-BENEFITS 321,406.00 17,542.21 114,241.78 0.00 207,164.22 35.54

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 33,500.00 0.00 0.00 34,640.54 (1,140.54) 103.40 42033 CONSTRUCTION MATERIALS 45,000.00 0.00 0.00 0.00 45,000.00 0.00 42101 SAFETY SHOES - MOU ITEM 600.00 600.00 600.00 0.00 0.00 100.00 42600 MOTOR POOL RENTAL - OPS & MTCE 19,392.00 0.00 0.00 0.00 19,392.00 0.00 TOTAL FOR SERVICES-SUPPLIES 98,492.00 600.00 600.00 34,640.54 63,251.46 35.78

CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 82,838.94 0.00 86,646.24 2,266.19 (6,073.49) 107.33 TOTAL FOR CAPITAL OUTLAY 82,838.94 0.00 86,646.24 2,266.19 (6,073.49) 107.33 TOTAL FOR PUBLIC WORKS 502,736.94 18,142.21 201,488.02 36,906.73 264,342.19 47.41 41 MAINTENANCE SERVICES

SERVICES-SUPPLIES
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 1,113,578.02 73,928.39 599,177.67 0.00 514,400.35 53.80 41140 FINAL LEAVE 0.00 0.00 10,450.35 0.00 (10,450.35) 0.00 JULIEK Page: 29 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
41141 SP COMP-BILINGUAL 6,825.00 175.00 1,662.50 0.00 5,162.50 24.35 41200 TEMPORARY EMPLOYEES 218,017.00 7,940.30 97,340.56 0.00 120,676.44 44.64 41300 OVERTIME 0.00 1,346.95 9,374.72 0.00 (9,374.72) 0.00 41320 COMP TIME 0.00 223.64 223.64 0.00 (223.64) 0.00
41400 SPECIAL DUTY PAY 0.00 35.92 288.74 0.00 (288.74) 0.00 41500 DEFERRED COMPENSATION MATCH 1,900.00 700.00 1,300.00 0.00 600.00 68.42 41510 PST DEFERRED COMPENSATION 2,477.00 51.55 818.70 0.00 1,658.30 33.05 41520 TIERED EMP DEF COMPENSATION 600.00 150.00 450.00 0.00 150.00 75.00 41530 TIERED RHS BENEFIT 600.00 150.00 450.00 0.00 150.00 75.00 41600 LONGEVITY 2,100.00 161.52 1,534.44 0.00 565.56 73.06 41660 TUITION REIMBURSEMENT 6,380.00 0.00 5,919.00 0.00 461.00 92.77 41700 ANNUAL LEAVE BUYBACK 13,877.00 0.00 13,406.40 0.00 470.60 96.60 41710 ANNUAL LEAVE OVER MAX 813.00 0.00 9,495.64 0.00 (8,682.64) 1,167.97 41910 PERS-NORMAL 138,342.00 9,416.69 75,326.56 0.00 63,015.44 54.44 41920 MEDICARE 37,331.00 2,388.04 21,036.61 0.00 16,294.39 56.35 41929 SHORT TERM DISABILITY 3,564.00 303.09 2,459.31 0.00 1,104.69 69.00 41930 LONG TERM DISABILITY 7,570.99 502.71 4,078.99 0.00 3,492.00 53.87 41931 WORKERS COMP 26,766.00 1,604.97 13,812.87 0.00 12,953.13 51.60 41932 STATE UNEMPLOYMENT INSURANCE 1,231.99 76.28 690.23 0.00 541.76 56.02 41940 HEALTH INSURANCE 252,920.00 13,150.40 88,392.10 0.00 164,527.90 34.94 41945 OPT OUT HEALTH INSURANCE 14,400.00 1,800.00 29,470.25 0.00 (15,070.25) 204.65 41946 LIFE INSURANCE 9,243.00 613.59 4,978.78 0.00 4,264.22 53.86 41951 HEALTH ALLOWANCE CREDIT 0.00 82.14 1,952.31 0.00 (1,952.31) 0.00 41996 VACANCY FACTOR (335,928.00) 0.00 0.00 0.00 (335,928.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,522,608.00 114,801.18 994,090.37 0.00 528,517.63 65.28

SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 326.62 326.62 0.00 (326.62) 0.00 42033 CONSTRUCTION MATERIALS 50,000.00 8,924.89 42,035.59 15,835.35 (7,870.94) 115.74 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 1,495.38 1,495.38 0.00 (1,495.38) 0.00 42101 SAFETY SHOES - MOU ITEM 900.00 0.00 1,195.20 0.00 (295.20) 132.80 42200 ADVERTISING EXPENSE 0.00 729.88 729.88 0.00 (729.88) 0.00 42340 OFFICE SUPPLIES 0.00 19.78 64.24 0.00 (64.24) 0.00 42350 PROGRAM EXPENDITURES 41,665.00 581.12 5,378.49 0.00 36,286.51 12.90 42430 WATER UTILITY 0.00 768.72 7,190.12 0.00 (7,190.12) 0.00 42605 RETAINED VEHICLE EXPENSE 0.00 0.00 14,158.35 0.00 (14,158.35) 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 0.00 1,630.91 0.00 (1,630.91) 0.00 42810 BUILDING MAINTENANCE 100,000.00 0.00 0.00 0.00 100,000.00 0.00 42811 MAINTENANCE & OPERATING 45,000.00 0.00 4,055.00 54,634.00 (13,689.00) 130.42 42813 MTCE & REPAIR - EQUIP & FAC 284,116.91 42,195.00 121,311.86 84,451.14 78,353.91 72.42 42816 MOWING/LANDSCAPE CONTRACTS 40,000.00 0.00 0.00 47,189.26 (7,189.26) 117.97 JULIEK Page: 30 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
42819 GRAFFITI REMOVAL 150,000.00 0.00 31,760.00 118,240.00 0.00 100.00 42821 TREE MAINTENANCE 700,000.00 36,951.00 792,540.00 73,025.00 (165,565.00) 123.65 42900 PROF. & CONT. SVCS 316,046.96 52,434.61 148,172.68 137,811.39 30,062.89 90.48 43200 CONFERENCE, TRAINING & TRAVEL 7,500.00 494.58 2,004.58 0.00 5,495.42 26.72 43500 BOOKS 23,926.00 0.00 15,940.58 5,059.42 2,926.00 87.77 43722 PREVENTION & MAINTENANCE 143,000.00 0.00 22,211.88 8,458.84 112,329.28 21.44 TOTAL FOR SERVICES-SUPPLIES 1,902,154.87 144,921.58 1,212,201.36 544,704.40 145,249.11 92.36 TOTAL FOR COMMUNITY SERVICES 3,424,762.87 259,722.76 2,206,291.73 544,704.40 673,766.74 80.32 65 PARK MAINTENANCE/LMD

SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR PARK MAINTENANCE/LMD 0.00 0.00 0.00 0.00 0.00 0.00 FUN 120 59,847,461.30 1,589,744.09 15,746,918.09 13,258,729.85 30,841,813.36 48.46 JULIEK Page: 31 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
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
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

SERVICES-SUPPLIES
42033 CONSTRUCTION MATERIALS 3,900.00 0.00 1,447.20 280.99 2,171.81 44.31 42410 ELECTRIC UTILITY 63,000.00 3,101.81 50,165.99 0.00 12,834.01 79.62 42420 NATURAL GAS UTILITY 3,000.00 595.87 2,087.72 0.00 912.28 69.59 42430 WATER UTILITY 23,814.00 1,269.93 24,179.16 0.00 (365.16) 101.53 42813 MTCE & REPAIR - EQUIP & FAC 14,400.00 715.11 1,204.68 10,536.12 2,659.20 81.53 42822 VANDALISM 1,000.00 0.00 0.00 0.00 1,000.00 0.00
42900 PROF. & CONT. SVCS 35,752.00 904.92 26,188.84 14,738.00 (5,174.84) 114.47 43715 REGULATORY PERMIT & USE FEES 394.00 0.00 0.00 0.00 394.00 0.00 43722 PREVENTION & MAINTENANCE 6,648.00 1,093.80 2,053.80 2,304.20 2,290.00 65.55 TOTAL FOR SERVICES-SUPPLIES 151,908.00 7,681.44 107,327.39 27,859.31 16,721.30 88.99 TOTAL FOR COMMUNITY SERVICES 151,908.00 7,681.44 107,327.39 27,859.31 16,721.30 88.99 FUN 232 406,649.59 7,681.44 107,327.39 27,859.31 271,462.89 33.24 JULIEK Page: 32 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report:

GL
03/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used

CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:

Fiscal Year: 2024
OB 09
Ledger:

Level:

Month to
GRAND TOTAL 250,440,037.19 13,782,115.67 124,395,863.03 21,329,341.27 104,714,832.89 58.18 JULIEK Page: 33 Current Date:

GLREREE5_Consolidated_Expenditure_Report
04/11/2024
Current Time: 07:50:55
User:

Report: