GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
110 GENERAL FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 1,126.08 6,457.13 0.00 (6,457.13) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 110.25 0.00 (110.25) 0.00 41300 OVERTIME 0.00 144.03 3,679.60 0.00 (3,679.60) 0.00 41320 COMP TIME 0.00 0.00 195.08 0.00 (195.08) 0.00
41600 LONGEVITY 0.00 17.30 87.46 0.00 (87.46) 0.00
41910 PERS-NORMAL 0.00 130.23 745.41 0.00 (745.41) 0.00 41920 MEDICARE 0.00 36.07 304.07 0.00 (304.07) 0.00
41931 WORKERS COMP 0.00 22.54 129.19 0.00 (129.19) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.64 5.24 0.00 (5.24) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 1,476.89 11,713.43 0.00 (11,713.43) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 18,985,369.52 0.00 0.00 0.00 18,985,369.52 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 (16,956.97) 19,144.25 27,318.47 (46,462.72) 0.00 42033 CONSTRUCTION MATERIALS 0.00 3,083.46 7,596.54 36,744.45 (44,340.99) 0.00 42055 COMPUTER EQUIPMENT & 188,187.45 35,532.79 36,590.00 264,295.95 (112,698.50) 159.88 42200 ADVERTISING EXPENSE 0.00 0.00 743.93 0.00 (743.93) 0.00 42300 WIRELESS COMMUNICATION 0.00 (1,218.41) 0.00 0.00 0.00 0.00 42305 PBLC SFTY RADIO COMMUNICATION 26,160.00 (583.43) 26,049.33 110.67 0.00 100.00 42320 POSTAGE & SHIPPING 0.00 (341.33) 13,030.00 0.00 (13,030.00) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 50,978.34 0.00 (50,978.34) 0.00 42700 OTHER EQUIPMENT RENTAL 335.19 0.00 0.00 335.19 0.00 100.00 42800 EQUIPMENT MAINTENANCE 1,885.81 0.00 11,626.45 68,983.87 (78,724.51) 4,274.57 42813 MTCE & REPAIR - EQUIP & FAC 0.00 42,417.59 178,064.59 46,553.00 (224,617.59) 0.00 42900 PROF. & CONT. SVCS 598,017.41 32,914.13 389,819.14 966,482.36 (758,284.09) 226.79 43300 CONSTRUCTION CONTRACTS 191,767.42 0.00 641,972.75 1,012,685.29 (1,462,890.62) 862.84 43301 CAPITAL IMPROVEMENTS 2,350.00 154,331.92 404,882.28 33,612.35 (436,144.63) 18,659.34 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 360.00 2,700.00 0.00 (2,700.00) 0.00 43500 BOOKS 0.00 0.00 4,583.73 0.00 (4,583.73) 0.00
43501 CHILDREN'S BOOKS 0.00 0.00 0.00 400.00 (400.00) 0.00 43715 REGULATORY PERMIT & USE FEES 0.00 0.00 51.14 0.00 (51.14) 0.00 43724 OUTSIDE SERVICES - LABOR 0.00 8,178.75 8,178.75 0.00 (8,178.75) 0.00 43727 INSPECTION 2,424.43 6,365.00 22,105.00 17,602.20 (37,282.77) 1,637.79 TOTAL FOR SERVICES-SUPPLIES 19,996,497.23 264,083.50 1,818,116.22 2,475,123.80 15,703,257.21 21.46
CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 168,312.50 30,911.56 (199,224.06) 0.00 45200 MACHINERY, EQUIPMENT, & FIXTUR 116,096.42 0.00 133,660.23 204,350.80 (221,914.61) 291.14 45400 LAND 0.00 0.00 5,102,844.78 0.00 (5,102,844.78) 0.00 JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
TOTAL FOR CAPITAL OUTLAY 116,096.42 0.00 5,404,817.51 235,262.36 (5,523,983.45) 4,858.09 TOTAL FOR NOT APPLICABLE 20,112,593.65 265,560.39 7,234,647.16 2,710,386.16 10,167,560.33 49.44 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,373.76 364.48 4,373.76 0.00 0.00 100.00 41912 PERS-UNFUNDED 3,819.69 0.00 3,819.69 0.00 0.00 100.00 41920 MEDICARE 2,104.18 166.95 2,003.31 0.00 100.87 95.20 41931 WORKERS COMP 960.00 80.00 960.00 0.00 0.00 100.00 41940 HEALTH INSURANCE 34,811.04 (520.24) 31,313.22 0.00 3,497.82 89.95 41946 LIFE INSURANCE 330.00 27.60 331.20 0.00 (1.20) 100.36 TOTAL FOR SALARIES-BENEFITS 94,523.47 4,129.19 90,925.98 0.00 3,597.49 96.19
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 2,000.00 0.00 512.99 0.00 1,487.01 25.64 42220 PROMOTIONAL/PUBLIC OUTREACH 3,500.00 84.83 84.83 0.00 3,415.17 2.42 42300 WIRELESS COMMUNICATION 3,500.00 0.00 4,084.23 0.00 (584.23) 116.69 42320 POSTAGE & SHIPPING 100.00 4.52 66.32 0.00 33.68 66.32 42340 OFFICE SUPPLIES 850.00 0.00 405.84 0.00 444.16 47.74 42345 FIRST AID KIT SUPPLIES 50.00 0.00 0.00 0.00 50.00 0.00 42350 PROGRAM EXPENDITURES 7,000.00 0.00 7,821.73 0.00 (821.73) 111.73 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 0.00 0.00 500.00 0.00 42800 EQUIPMENT MAINTENANCE 500.00 0.00 4,164.12 0.00 (3,664.12) 832.82 42900 PROF. & CONT. SVCS 5,000.00 0.00 0.00 0.00 5,000.00 0.00 43100 MEMBERSHIP & DUES 1,650.00 0.00 100.00 0.00 1,550.00 6.06 43200 CONFERENCE, TRAINING & TRAVEL 12,000.00 40.00 2,478.31 0.00 9,521.69 20.65 TOTAL FOR SERVICES-SUPPLIES 36,650.00 129.35 19,718.37 0.00 16,931.63 53.80 TOTAL FOR CITY COUNCIL 131,173.47 4,258.54 110,644.35 0.00 20,529.12 84.34 11 CITY MANAGER'S OFFICE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,787,491.97 137,299.16 1,412,700.31 0.00 374,791.66 79.03 41103 OUT OF CLASS PAY 0.00 969.60 2,032.80 0.00 (2,032.80) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 118.55 0.00 (118.55) 0.00 41141 SP COMP-BILINGUAL 15,158.00 1,190.80 13,013.74 0.00 2,144.26 85.85 41200 TEMPORARY EMPLOYEES 84,718.76 0.00 24,896.21 0.00 59,822.55 29.38 41300 OVERTIME 7,540.00 698.88 8,968.49 0.00 (1,428.49) 118.94 41410 AUTO ALLOWANCE 17,280.00 886.16 11,140.30 0.00 6,139.70 64.46 41500 DEFERRED COMPENSATION MATCH 11,400.00 4,400.00 15,510.00 0.00 (4,110.00) 136.05 41510 PST DEFERRED COMPENSATION 411.40 0.00 198.64 0.00 212.76 48.28 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41520 TIERED EMP DEF COMPENSATION 24,100.00 6,175.00 9,325.00 0.00 14,775.00 38.69 41530 TIERED RHS BENEFIT 3,600.00 1,200.00 4,350.00 0.00 (750.00) 120.83 41600 LONGEVITY 7,800.00 615.34 14,261.49 0.00 (6,461.49) 182.83 41630 ONE TIME MOU PAYMENTS 24,440.84 0.00 24,440.84 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 5,000.00 0.00 4,169.42 0.00 830.58 83.38 41700 ANNUAL LEAVE BUYBACK 13,029.00 0.00 13,028.32 0.00 0.68 99.99 41710 ANNUAL LEAVE OVER MAX 2,570.00 0.00 11,124.49 0.00 (8,554.49) 432.85 41910 PERS-NORMAL 208,593.48 15,954.57 153,345.94 0.00 55,247.54 73.51 41912 PERS-UNFUNDED 86,779.11 0.00 86,779.11 0.00 0.00 100.00 41920 MEDICARE 58,688.35 4,510.40 46,160.09 0.00 12,528.26 78.65 41929 SHORT TERM DISABILITY 5,766.30 501.15 4,579.28 0.00 1,187.02 79.41 41930 LONG TERM DISABILITY 12,339.78 933.65 9,600.02 0.00 2,739.76 77.79 41931 WORKERS COMP 37,528.62 2,768.74 28,508.03 0.00 9,020.59 75.96 41932 STATE UNEMPLOYMENT INSURANCE 11,452.50 71.94 770.60 0.00 10,681.90 6.72 41940 HEALTH INSURANCE 216,261.13 21,720.13 198,367.20 0.00 17,893.93 91.72 41945 OPT OUT HEALTH INSURANCE 28,685.00 1,000.00 20,725.00 0.00 7,960.00 72.25 41946 LIFE INSURANCE 14,751.39 1,139.59 11,717.61 0.00 3,033.78 79.43 41951 HEALTH ALLOWANCE CREDIT 0.00 1,624.00 8,885.00 0.00 (8,885.00) 0.00 41996 VACANCY FACTOR (117,552.00) 0.00 0.00 0.00 (117,552.00) 0.00 41997 BUDGETARY/PAYROLL (4,474.00) 0.00 0.00 0.00 (4,474.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,563,359.63 203,659.11 2,138,716.48 0.00 424,643.15 83.43
SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 12,433.78 0.00 9,038.82 0.00 3,394.96 72.69 42012 AUDIO VISUAL 10,304.08 0.00 466.42 0.00 9,837.66 4.52 42020 MINOR EQUIPMENT & FURNITURE 2,000.00 289.00 4,073.13 0.00 (2,073.13) 203.65 42033 CONSTRUCTION MATERIALS 0.00 0.00 1,575.30 0.00 (1,575.30) 0.00 42055 COMPUTER EQUIPMENT & 6,500.00 0.00 1,233.39 0.00 5,266.61 18.97 42200 ADVERTISING EXPENSE 6,300.00 1,233.60 4,121.99 0.00 2,178.01 65.42 42220 PROMOTIONAL/PUBLIC OUTREACH 24,499.00 1,437.00 14,532.44 1,563.94 8,402.62 65.70 42300 WIRELESS COMMUNICATION 12,520.00 0.00 2,862.77 0.00 9,657.23 22.86 42320 POSTAGE & SHIPPING 2,700.00 41.06 1,000.44 0.00 1,699.56 37.05 42340 OFFICE SUPPLIES 7,816.00 103.69 2,765.42 0.00 5,050.58 35.38 42345 FIRST AID KIT SUPPLIES 350.00 0.00 72.74 0.00 277.26 20.78 42350 PROGRAM EXPENDITURES 22,610.00 2,036.80 32,743.71 5,734.48 (15,868.19) 170.18 42360 CLEANING/JANITORIAL SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42710 MILEAGE/VEHICLE EXP REIMB 1,350.00 0.00 21.42 0.00 1,328.58 1.58 42800 EQUIPMENT MAINTENANCE 5,000.00 0.00 4,899.41 0.00 100.59 97.98 42813 MTCE & REPAIR - EQUIP & FAC 0.00 2,704.00 10,027.00 19,838.00 (29,865.00) 0.00 42900 PROF. & CONT. SVCS 2,600,967.03 117,789.52 1,187,598.73 1,246,696.49 166,671.81 93.59 43100 MEMBERSHIP & DUES 89,264.00 20,290.33 84,306.11 0.00 4,957.89 94.44 JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
43200 CONFERENCE, TRAINING & TRAVEL 22,950.00 40.00 8,337.91 0.00 14,612.09 36.33 43722 PREVENTION & MAINTENANCE 0.00 0.00 728.06 271.94 (1,000.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,827,663.89 145,965.00 1,370,405.21 1,274,104.85 183,153.83 93.52 TOTAL FOR CITY MANAGER'S OFFICE 5,391,023.52 349,624.11 3,509,121.69 1,274,104.85 607,796.98 88.72 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 719.20 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 273.36 22.78 273.36 0.00 0.00 100.00
41912 PERS-UNFUNDED 190.98 0.00 190.98 0.00 0.00 100.00 41920 MEDICARE 416.01 54.11 416.01 0.00 0.00 100.00
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 15,134.35 1,925.59 15,134.35 0.00 0.00 100.00 TOTAL FOR TREASURER 15,134.35 1,925.59 15,134.35 0.00 0.00 100.00 13 DEBT SERVICE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 221,989,148.87 0.00 221,112,128.67 0.00 877,020.20 99.60 TOTAL FOR SALARIES-BENEFITS 221,989,148.87 0.00 221,112,128.67 0.00 877,020.20 99.60
SERVICES-SUPPLIES
42500 RENTS & LEASES 4,243,273.00 0.00 4,243,245.60 0.00 27.40 99.99 42900 PROF. & CONT. SVCS 1,500.00 0.00 878,270.20 0.00 (876,770.20) 58,551.34 44001 DS PRINCIPAL 2021 POBS 13,684,008.49 0.00 13,684,008.49 0.00 0.00 100.00 44101 DS INTEREST 2021 POBS 2,163,454.97 0.00 2,163,455.56 0.00 (0.59) 100.00 TOTAL FOR SERVICES-SUPPLIES 20,092,236.46 0.00 20,968,979.85 0.00 (876,743.39) 104.36 TOTAL FOR DEBT SERVICE 242,081,385.33 0.00 242,081,108.52 0.00 276.81 100.00 15 HUMAN RESOURCES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,131,508.67 81,786.40 793,851.59 0.00 337,657.08 70.15 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 4,018.85 0.00 (4,018.85) 0.00 41103 OUT OF CLASS PAY 0.00 422.40 3,012.96 0.00 (3,012.96) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 68.43 0.00 (68.43) 0.00 41140 FINAL LEAVE 0.00 0.00 21,408.99 0.00 (21,408.99) 0.00 41141 SP COMP-BILINGUAL 5,482.00 297.70 1,339.65 0.00 4,142.35 24.43 41200 TEMPORARY EMPLOYEES 0.00 0.00 145.73 0.00 (145.73) 0.00 41300 OVERTIME 5,228.00 0.00 7,649.09 0.00 (2,421.09) 146.31 JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41410 AUTO ALLOWANCE 0.00 443.08 1,550.78 0.00 (1,550.78) 0.00 41500 DEFERRED COMPENSATION MATCH 9,500.00 2,080.76 8,442.32 0.00 1,057.68 88.86 41510 PST DEFERRED COMPENSATION 0.00 0.00 1.89 0.00 (1.89) 0.00 41520 TIERED EMP DEF COMPENSATION 3,000.00 750.00 2,550.00 0.00 450.00 85.00 41530 TIERED RHS BENEFIT 3,000.00 750.00 2,550.00 0.00 450.00 85.00 41600 LONGEVITY 6,000.00 492.28 11,369.22 0.00 (5,369.22) 189.48 41630 ONE TIME MOU PAYMENTS 15,370.71 0.00 15,370.71 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 13,281.00 0.00 13,564.88 0.00 (283.88) 102.13 41710 ANNUAL LEAVE OVER MAX 11,897.00 0.00 8,027.40 0.00 3,869.60 67.47 41910 PERS-NORMAL 130,188.41 9,405.43 92,324.83 0.00 37,863.58 70.91 41912 PERS-UNFUNDED 61,179.45 0.00 61,179.45 0.00 0.00 100.00 41920 MEDICARE 36,378.10 2,599.01 26,331.73 0.00 10,046.37 72.38 41929 SHORT TERM DISABILITY 3,620.64 298.50 2,577.28 0.00 1,043.36 71.18 41930 LONG TERM DISABILITY 7,694.85 556.15 5,398.27 0.00 2,296.58 70.15 41931 WORKERS COMP 22,633.97 1,639.86 15,768.51 0.00 6,865.46 69.66 41932 STATE UNEMPLOYMENT INSURANCE 704.15 42.98 444.37 0.00 259.78 63.10 41940 HEALTH INSURANCE 213,806.83 13,270.00 122,617.89 0.00 91,188.94 57.34 41945 OPT OUT HEALTH INSURANCE 18,000.00 1,800.00 16,500.00 0.00 1,500.00 91.66 41946 LIFE INSURANCE 9,391.03 678.83 6,588.99 0.00 2,802.04 70.16 41951 HEALTH ALLOWANCE CREDIT 0.00 738.18 3,875.28 0.00 (3,875.28) 0.00 41996 VACANCY FACTOR (82,141.00) 0.00 0.00 0.00 (82,141.00) 0.00 41997 BUDGETARY/PAYROLL (6,381.00) 0.00 0.00 0.00 (6,381.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,619,342.81 118,051.56 1,248,529.09 0.00 370,813.72 77.10
SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 3,500.00 0.00 2,262.29 0.00 1,237.71 64.63 42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 335.69 0.00 (335.69) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 3,920.00 735.90 2,190.82 64.10 1,665.08 57.52 42055 COMPUTER EQUIPMENT & 10,768.00 0.00 9,289.61 0.00 1,478.39 86.27 42100 UNIFORM EXPENSE 0.00 14,073.78 26,977.70 0.00 (26,977.70) 0.00 42101 SAFETY SHOES - MOU ITEM 350.00 0.00 20,901.30 0.00 (20,551.30) 5,971.80 42200 ADVERTISING EXPENSE 3,100.00 0.00 250.93 19,000.00 (16,150.93) 620.99 42300 WIRELESS COMMUNICATION 1,320.00 0.00 1,011.07 0.00 308.93 76.59 42320 POSTAGE & SHIPPING 900.00 479.62 1,200.72 0.00 (300.72) 133.41 42340 OFFICE SUPPLIES 10,000.00 (4.99) 5,473.63 0.00 4,526.37 54.73 42345 FIRST AID KIT SUPPLIES 120.00 3,956.99 3,968.46 0.00 (3,848.46) 3,307.05 42350 PROGRAM EXPENDITURES 1,000.00 1,469.89 2,041.29 0.00 (1,041.29) 204.12 42630 PARTS/LABOR ON CITY VEHICLES 0.00 (20.40) (20.40) 0.00 20.40 0.00 42800 EQUIPMENT MAINTENANCE 6,000.00 0.00 0.00 0.00 6,000.00 0.00 42900 PROF. & CONT. SVCS 300,608.00 33,238.09 169,715.51 73,449.91 57,442.58 80.89 43041 MANDATED SAFETY TRAINING 162,200.00 28,722.00 129,546.82 37,253.18 (4,600.00) 102.83 JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
43100 MEMBERSHIP & DUES 5,680.00 0.00 149.99 0.00 5,530.01 2.64 43110 EMPLOYEE ENGAGEMENT 15,000.00 0.00 524.07 0.00 14,475.93 3.49 43200 CONFERENCE, TRAINING & TRAVEL 11,795.00 0.00 4,271.99 0.00 7,523.01 36.21 43400 LEGAL SERVICES-SPECIAL COUNSEL 262,141.00 6,603.50 176,412.40 67,211.60 18,517.00 92.93 TOTAL FOR SERVICES-SUPPLIES 798,402.00 89,254.38 556,503.89 196,978.79 44,919.32 94.37 TOTAL FOR HUMAN RESOURCES 2,417,744.81 207,305.94 1,805,032.98 196,978.79 415,733.04 82.80 16 GENERAL GOVERNMENT
SALARIES-BENEFITS
41102 SHIFT DIFFERENTIAL 974.00 0.00 0.00 0.00 974.00 0.00 41140 FINAL LEAVE 300,000.00 0.00 0.00 0.00 300,000.00 0.00 41600 LONGEVITY 0.00 12.06 118.05 0.00 (118.05) 0.00
41650 EMPLOYEE EXPENSE 0.00 3,713.76 3,713.76 0.00 (3,713.76) 0.00 41700 ANNUAL LEAVE BUYBACK 84,201.00 0.00 0.00 0.00 84,201.00 0.00 41910 PERS-NORMAL 450,000.00 2,272.01 416,799.70 0.00 33,200.30 92.62 41920 MEDICARE 200.00 24.78 176.07 0.00 23.93 88.03
41921 RETIREES MEDICARE REIMB 535,000.00 17,070.00 602,020.55 0.00 (67,020.55) 112.52 41929 SHORT TERM DISABILITY 0.00 0.00 2.36 0.00 (2.36) 0.00 41931 WORKERS COMP 0.00 0.00 (0.11) 0.00 0.11 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.42 3.08 0.00 (3.08) 0.00 41940 HEALTH INSURANCE 0.00 0.00 199.81 0.00 (199.81) 0.00 41941 RETIREES HEALTH INSURANCE/OPEB 6,659,340.00 224,887.82 6,289,564.85 0.00 369,775.15 94.44 41942 RETIREES LIFE INSURANCE 26,000.00 2,073.50 24,733.50 0.00 1,266.50 95.12 41944 RETIREE FLEX SPENDING PLAN 135,000.00 0.00 125,625.00 0.00 9,375.00 93.05 41947 RETIREE HRA 130,000.00 0.00 108,000.00 0.00 22,000.00 83.07 41997 BUDGETARY/PAYROLL 663,198.00 0.00 0.00 0.00 663,198.00 0.00 TOTAL FOR SALARIES-BENEFITS 8,983,913.00 250,054.35 7,570,956.62 0.00 1,412,956.38 84.27
SERVICES-SUPPLIES
42310 PHONES, FAX, ISDN LINES 30,000.00 5,203.25 31,072.43 0.00 (1,072.43) 103.57 42320 POSTAGE & SHIPPING 0.00 113.91 113.91 0.00 (113.91) 0.00 42330 PHONES,FAX-INDIRECT DEPT 5,060.00 559.77 4,196.66 0.00 863.34 82.93 42340 OFFICE SUPPLIES 0.00 0.00 56.53 0.00 (56.53) 0.00 42350 PROGRAM EXPENDITURES 10,000.00 9,235.60 72,671.04 0.00 (62,671.04) 726.71 42380 GEN BENEFIT_CITYWIDE EXPENSE 130,624.00 0.00 123,298.00 0.00 7,326.00 94.39 42410 ELECTRIC UTILITY 1,734,705.00 155,235.85 1,879,923.59 0.00 (145,218.59) 108.37 42420 NATURAL GAS UTILITY 86,000.00 13,659.29 143,138.79 0.00 (57,138.79) 166.44 42430 WATER UTILITY 728,000.00 69,565.17 771,903.47 0.00 (43,903.47) 106.03 42435 RECYCLED WATER UTILITY 886,200.00 110,514.72 845,515.61 0.00 40,684.39 95.40 42600 MOTOR POOL RENTAL 17,116.00 0.00 17,116.00 0.00 0.00 100.00 42900 PROF. & CONT. SVCS 195,500.00 12,731.96 192,197.65 55,169.98 (51,867.63) 126.53 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42902 CUST CREDIT CRD PROCESSING FEE 160,000.00 119.50 207,442.20 0.00 (47,442.20) 129.65 42960 INDIRECT SPEC DST COUNTY ADMIN 775,968.76 11,333.45 335,951.73 14,225.00 425,792.03 45.12 43010 INSURANCE PREMIUMS 1,740,636.00 0.00 0.00 0.00 1,740,636.00 0.00 43100 MEMBERSHIP & DUES 12,000.00 0.00 0.00 0.00 12,000.00 0.00 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 0.00 3,034.82 0.00 (3,034.82) 0.00 44200 BAD DEBTS EXPENSE 1,200.00 0.00 0.00 0.00 1,200.00 0.00 44613 INTERNAL SVC CHRG-WAREHOUSE 93,873.00 0.00 70,404.75 0.00 23,468.25 75.00 44614 INTERNAL SVC CHRG-INFO TECH 8,340,166.00 0.00 6,255,124.50 0.00 2,085,041.50 75.00 TOTAL FOR SERVICES-SUPPLIES 14,947,048.76 388,272.47 10,953,161.68 69,394.98 3,924,492.10 73.74
SERVICES-SUPPLIES
43907 LOSS ON SA CITY ADMIN LOAN PYM 0.00 0.00 526,625.31 0.00 (526,625.31) 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 526,625.31 0.00 (526,625.31) 0.00 TOTAL FOR GENERAL GOVERNMENT 23,930,961.76 638,326.82 19,050,743.61 69,394.98 4,810,823.17 79.89 17 INFORMATION TECHNOLOGY
SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR INFORMATION TECHNOLOGY 0.00 0.00 0.00 0.00 0.00 0.00 18 ADMIN SERVICES-FINANCE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,324,479.79 140,889.12 1,593,148.84 0.00 731,330.95 68.53 41103 OUT OF CLASS PAY 0.00 668.80 3,522.24 0.00 (3,522.24) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 360.98 0.00 (360.98) 0.00 41140 FINAL LEAVE 0.00 0.00 30,837.35 0.00 (30,837.35) 0.00 41141 SP COMP-BILINGUAL 10,694.88 822.70 10,342.52 0.00 352.36 96.70 41200 TEMPORARY EMPLOYEES 41,417.42 2,523.57 31,436.68 0.00 9,980.74 75.90 41300 OVERTIME 22,172.16 3,165.46 30,723.60 0.00 (8,551.44) 138.56 41410 AUTO ALLOWANCE 0.00 443.08 1,550.78 0.00 (1,550.78) 0.00 41500 DEFERRED COMPENSATION MATCH 21,721.00 3,035.00 19,290.00 0.00 2,431.00 88.80 41510 PST DEFERRED COMPENSATION 270.12 0.00 0.00 0.00 270.12 0.00 41520 TIERED EMP DEF COMPENSATION 8,225.00 1,650.00 7,200.00 0.00 1,025.00 87.53 41530 TIERED RHS BENEFIT 5,942.00 1,350.00 5,600.00 0.00 342.00 94.24 41600 LONGEVITY 32,105.28 2,166.02 44,189.14 0.00 (12,083.86) 137.63 41630 ONE TIME MOU PAYMENTS 34,206.07 0.00 34,206.07 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 1,771.00 0.00 3,346.52 0.00 (1,575.52) 188.96 41700 ANNUAL LEAVE BUYBACK 49,042.00 0.00 44,594.88 0.00 4,447.12 90.93 41710 ANNUAL LEAVE OVER MAX 13,328.00 0.00 39,921.62 0.00 (26,593.62) 299.53 41910 PERS-NORMAL 271,956.14 16,762.56 191,631.01 0.00 80,325.13 70.46 41912 PERS-UNFUNDED 155,923.20 0.00 155,923.20 0.00 0.00 100.00 41920 MEDICARE 78,440.76 4,653.73 56,067.80 0.00 22,372.96 71.47 JULIEK Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41929 SHORT TERM DISABILITY 7,437.05 514.32 5,162.62 0.00 2,274.43 69.41 41930 LONG TERM DISABILITY 15,805.12 958.05 10,836.55 0.00 4,968.57 68.56 41931 WORKERS COMP 47,734.84 2,873.55 32,132.99 0.00 15,601.85 67.31 41932 STATE UNEMPLOYMENT INSURANCE 1,298.53 77.52 948.43 0.00 350.10 73.03 41940 HEALTH INSURANCE 410,740.85 23,294.09 245,995.39 0.00 164,745.46 59.89 41945 OPT OUT HEALTH INSURANCE 76,475.00 3,916.00 82,941.00 0.00 (6,466.00) 108.45 41946 LIFE INSURANCE 19,291.64 1,169.40 13,227.33 0.00 6,064.31 68.56 41951 HEALTH ALLOWANCE CREDIT 0.00 1,058.86 6,095.88 0.00 (6,095.88) 0.00 41996 VACANCY FACTOR (89,975.00) 0.00 0.00 0.00 (89,975.00) 0.00 41997 BUDGETARY/PAYROLL (75,000.00) 0.00 0.00 0.00 (75,000.00) 0.00 TOTAL FOR SALARIES-BENEFITS 3,485,502.85 211,991.83 2,701,233.42 0.00 784,269.43 77.49
SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 300.00 0.00 650.00 0.00 (350.00) 216.66 42020 MINOR EQUIPMENT & FURNITURE 1,000.00 0.00 278.73 7,147.82 (6,426.55) 742.65 42055 COMPUTER EQUIPMENT & 5,000.00 559.64 20,919.71 0.35 (15,920.06) 418.40 42200 ADVERTISING EXPENSE 300.00 0.00 1,294.02 0.00 (994.02) 431.34 42220 PROMOTIONAL/PUBLIC OUTREACH 150.00 0.00 0.00 0.00 150.00 0.00 42300 WIRELESS COMMUNICATION 350.00 0.00 0.00 0.00 350.00 0.00 42320 POSTAGE & SHIPPING 3,800.00 308.81 3,847.01 0.00 (47.01) 101.23 42340 OFFICE SUPPLIES 3,200.00 116.36 2,840.97 0.00 359.03 88.78 42345 FIRST AID KIT SUPPLIES 50.00 0.00 8.18 0.00 41.82 16.36 42350 PROGRAM EXPENDITURES 5,250.00 550.00 4,191.96 0.00 1,058.04 79.84 42710 MILEAGE/VEHICLE EXP REIMB 200.00 0.00 20.12 0.00 179.88 10.06 42800 EQUIPMENT MAINTENANCE 5,000.00 0.00 0.00 0.00 5,000.00 0.00 42900 PROF. & CONT. SVCS 663,995.00 114,898.12 483,126.31 156,064.62 24,804.07 96.26 43100 MEMBERSHIP & DUES 4,685.00 150.00 3,540.00 0.00 1,145.00 75.56 43200 CONFERENCE, TRAINING & TRAVEL 10,500.00 0.00 2,885.45 0.00 7,614.55 27.48 43500 BOOKS 450.00 0.00 96.75 0.00 353.25 21.50
43724 OUTSIDE SERVICES - LABOR 113,275.00 8,950.00 145,144.00 72,742.50 (104,611.50) 192.35 TOTAL FOR SERVICES-SUPPLIES 817,505.00 125,532.93 668,843.21 235,955.29 (87,293.50) 110.67 TOTAL FOR ADMIN SERVICES-FINANCE 4,303,007.85 337,524.76 3,370,076.63 235,955.29 696,975.93 83.80 19 ECONOMIC DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 508,249.40 36,147.70 433,606.45 0.00 74,642.95 85.31 41141 SP COMP-BILINGUAL 7,740.00 595.40 7,485.03 0.00 254.97 96.70 41200 TEMPORARY EMPLOYEES 10,475.58 0.00 8,392.96 0.00 2,082.62 80.11 41410 AUTO ALLOWANCE 5,760.00 443.08 5,570.15 0.00 189.85 96.70 41500 DEFERRED COMPENSATION MATCH 1,900.00 0.00 1,900.00 0.00 0.00 100.00 41510 PST DEFERRED COMPENSATION 135.90 0.00 109.12 0.00 26.78 80.29 JULIEK Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
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,400.00 0.00 2,245.67 0.00 (845.67) 160.40 41630 ONE TIME MOU PAYMENTS 9,025.36 0.00 9,025.36 0.00 0.00 100.00 41710 ANNUAL LEAVE OVER MAX 6,475.00 0.00 0.00 0.00 6,475.00 0.00 41910 PERS-NORMAL 58,901.43 4,185.04 50,504.74 0.00 8,396.69 85.74 41912 PERS-UNFUNDED 19,012.62 0.00 19,012.62 0.00 0.00 100.00 41920 MEDICARE 16,209.75 1,111.92 13,656.31 0.00 2,553.44 84.24 41929 SHORT TERM DISABILITY 1,625.37 133.18 1,405.09 0.00 220.28 86.44 41930 LONG TERM DISABILITY 3,454.29 245.79 2,947.98 0.00 506.31 85.34 41931 WORKERS COMP 10,525.36 728.34 8,744.43 0.00 1,780.93 83.07 41932 STATE UNEMPLOYMENT INSURANCE 271.27 18.97 235.65 0.00 35.62 86.86 41940 HEALTH INSURANCE 82,500.64 5,232.74 52,964.43 0.00 29,536.21 64.19 41945 OPT OUT HEALTH INSURANCE 0.00 600.00 10,600.00 0.00 (10,600.00) 0.00 41946 LIFE INSURANCE 4,216.09 300.01 3,598.40 0.00 617.69 85.34 41951 HEALTH ALLOWANCE CREDIT 0.00 174.28 951.68 0.00 (951.68) 0.00 TOTAL FOR SALARIES-BENEFITS 749,078.06 50,216.45 634,156.07 0.00 114,921.99 84.65
SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 68,640.00 0.00 15,567.84 0.00 53,072.16 22.68 42020 MINOR EQUIPMENT & FURNITURE 3,000.00 0.00 2,790.47 0.00 209.53 93.01 42055 COMPUTER EQUIPMENT & 26,000.00 0.00 3,205.18 0.00 22,794.82 12.32 42220 PROMOTIONAL/PUBLIC OUTREACH 22,000.00 (92.06) 18,375.50 0.00 3,624.50 83.52 42300 WIRELESS COMMUNICATION 2,600.00 0.00 1,895.01 0.00 704.99 72.88 42320 POSTAGE & SHIPPING 200.00 61.69 204.11 0.00 (4.11) 102.05 42340 OFFICE SUPPLIES 3,000.00 0.00 1,693.22 0.00 1,306.78 56.44 42345 FIRST AID KIT SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42350 PROGRAM EXPENDITURES 6,500.00 0.00 758.28 0.00 5,741.72 11.66 42710 MILEAGE/VEHICLE EXP REIMB 500.00 0.00 33.00 0.00 467.00 6.60 42800 EQUIPMENT MAINTENANCE 400.00 0.00 6,600.44 0.00 (6,200.44) 1,650.11 42900 PROF. & CONT. SVCS 576,823.24 39,315.15 478,967.11 425,023.46 (327,167.33) 156.71 43100 MEMBERSHIP & DUES 17,680.00 0.00 5,094.10 0.00 12,585.90 28.81 43200 CONFERENCE, TRAINING & TRAVEL 30,540.00 0.00 2,208.67 0.00 28,331.33 7.23 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 1,917.00 105,398.58 0.00 (105,398.58) 0.00 TOTAL FOR SERVICES-SUPPLIES 757,983.24 41,201.78 642,791.51 425,023.46 (309,831.73) 140.87 TOTAL FOR ECONOMIC DEVELOPMENT 1,507,061.30 91,418.23 1,276,947.58 425,023.46 (194,909.74) 112.93 20 LEGAL AND RISK MANAGEMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 944,278.77 75,870.61 909,734.72 0.00 34,544.05 96.34 41141 SP COMP-BILINGUAL 3,870.00 297.70 3,742.51 0.00 127.49 96.70 JULIEK Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41200 TEMPORARY EMPLOYEES 28,826.95 818.44 17,032.74 0.00 11,794.21 59.08 41410 AUTO ALLOWANCE 17,280.00 1,329.24 16,710.45 0.00 569.55 96.70 41500 DEFERRED COMPENSATION MATCH 7,600.00 525.00 9,550.00 0.00 (1,950.00) 125.65 41510 PST DEFERRED COMPENSATION 374.77 10.65 221.42 0.00 153.35 59.08 41520 TIERED EMP DEF COMPENSATION 15,000.00 3,750.00 6,000.00 0.00 9,000.00 40.00 41530 TIERED RHS BENEFIT 2,800.00 750.00 3,000.00 0.00 (200.00) 107.14 41600 LONGEVITY 7,000.00 538.40 12,653.90 0.00 (5,653.90) 180.77 41630 ONE TIME MOU PAYMENTS 18,395.33 0.00 18,395.33 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 52,603.00 0.00 52,601.68 0.00 1.32 99.99 41710 ANNUAL LEAVE OVER MAX 17,299.00 0.00 23,672.49 0.00 (6,373.49) 136.84 41910 PERS-NORMAL 108,791.09 8,736.90 105,486.29 0.00 3,304.80 96.96 41912 PERS-UNFUNDED 73,155.93 0.00 73,155.93 0.00 0.00 100.00 41920 MEDICARE 33,179.03 2,480.99 32,647.97 0.00 531.06 98.39 41929 SHORT TERM DISABILITY 3,021.71 276.94 2,945.33 0.00 76.38 97.47 41930 LONG TERM DISABILITY 6,421.37 515.92 6,186.11 0.00 235.26 96.33 41931 WORKERS COMP 17,467.93 1,522.03 18,256.46 0.00 (788.53) 104.51 41932 STATE UNEMPLOYMENT INSURANCE 546.02 40.19 525.34 0.00 20.68 96.21 41940 HEALTH INSURANCE 78,239.73 6,235.08 68,068.71 0.00 10,171.02 87.00 41945 OPT OUT HEALTH INSURANCE 20,800.00 1,200.00 21,200.00 0.00 (400.00) 101.92 41946 LIFE INSURANCE 7,830.74 629.72 7,550.69 0.00 280.05 96.42 41951 HEALTH ALLOWANCE CREDIT 0.00 348.88 2,093.28 0.00 (2,093.28) 0.00 41997 BUDGETARY/PAYROLL (2,835.00) 0.00 0.00 0.00 (2,835.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,461,946.37 105,876.69 1,411,431.35 0.00 50,515.02 96.54
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 850.00 0.00 (850.00) 0.00 42055 COMPUTER EQUIPMENT & 4,180.00 0.00 3,800.00 0.00 380.00 90.90 42300 WIRELESS COMMUNICATION 1,400.00 0.00 2,994.65 0.00 (1,594.65) 213.90 42320 POSTAGE & SHIPPING 500.00 20.93 226.71 0.00 273.29 45.34 42340 OFFICE SUPPLIES 5,600.00 0.00 873.11 0.00 4,726.89 15.59 42345 FIRST AID KIT SUPPLIES 120.00 0.00 41.67 0.00 78.33 34.72 42710 MILEAGE/VEHICLE EXP REIMB 100.00 0.00 0.00 0.00 100.00 0.00 42900 PROF. & CONT. SVCS 0.00 (5.74) 258.26 0.00 (258.26) 0.00 43010 INSURANCE PREMIUMS 0.00 0.00 4,500.00 0.00 (4,500.00) 0.00 43100 MEMBERSHIP & DUES 2,706.00 125.00 1,790.00 0.00 916.00 66.14 43200 CONFERENCE, TRAINING & TRAVEL 5,036.00 0.00 58.00 0.00 4,978.00 1.15 43400 LEGAL SERVICES-SPECIAL COUNSEL 93,900.00 46,040.68 124,502.85 18,673.12 (49,275.97) 152.47 43410 LEGAL RESEARCH 10,484.00 856.96 10,605.31 176.20 (297.51) 102.83 43430 LITIGATION EXPENSE 22,000.00 991.75 3,401.06 68,176.35 (49,577.41) 325.35 TOTAL FOR SERVICES-SUPPLIES 146,026.00 48,029.58 153,901.62 87,025.67 (94,901.29) 164.98 JULIEK Page: 10 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
TOTAL FOR LEGAL AND RISK MANAGEMENT1,607,972.37 153,906.27 1,565,332.97 87,025.67 (44,386.27) 102.76 21 COMMUNITY DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,624,985.10 149,766.28 1,669,296.33 0.00 955,688.77 63.59 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 12.12 0.00 (12.12) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 600.42 0.00 (600.42) 0.00 41140 FINAL LEAVE 0.00 0.00 37,712.78 0.00 (37,712.78) 0.00 41141 SP COMP-BILINGUAL 26,096.71 1,340.19 17,113.04 0.00 8,983.67 65.57 41200 TEMPORARY EMPLOYEES 0.00 0.00 44.23 0.00 (44.23) 0.00 41300 OVERTIME 9,661.05 930.10 11,761.14 0.00 (2,100.09) 121.73 41410 AUTO ALLOWANCE 5,068.80 389.92 4,901.85 0.00 166.95 96.70 41500 DEFERRED COMPENSATION MATCH 11,562.00 1,800.06 11,102.52 0.00 459.48 96.02 41520 TIERED EMP DEF COMPENSATION 4,800.00 960.00 4,410.00 0.00 390.00 91.87 41530 TIERED RHS BENEFIT 2,760.00 610.00 2,630.00 0.00 130.00 95.28 41600 LONGEVITY 20,959.81 1,374.25 28,091.82 0.00 (7,132.01) 134.02 41630 ONE TIME MOU PAYMENTS 33,181.21 0.00 33,181.21 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 48,985.68 0.00 51,400.67 0.00 (2,414.99) 104.92 41710 ANNUAL LEAVE OVER MAX 15,950.00 0.00 29,864.02 0.00 (13,914.02) 187.23 41910 PERS-NORMAL 304,866.04 17,367.60 195,212.01 0.00 109,654.03 64.03 41912 PERS-UNFUNDED 125,588.43 0.00 125,588.43 0.00 0.00 100.00 41920 MEDICARE 85,891.83 4,787.77 57,643.29 0.00 28,248.54 67.11 41929 SHORT TERM DISABILITY 8,422.90 574.94 5,682.18 0.00 2,740.72 67.46 41930 LONG TERM DISABILITY 17,900.79 1,071.24 11,940.04 0.00 5,960.75 66.70 41931 WORKERS COMP 53,296.43 3,023.06 33,452.95 0.00 19,843.48 62.76 41932 STATE UNEMPLOYMENT INSURANCE 1,424.35 80.09 969.77 0.00 454.58 68.08 41940 HEALTH INSURANCE 449,598.19 24,209.54 229,552.21 0.00 220,045.98 51.05 41945 OPT OUT HEALTH INSURANCE 76,452.00 4,626.85 78,748.95 0.00 (2,296.95) 103.00 41946 LIFE INSURANCE 21,847.72 1,307.68 14,574.74 0.00 7,272.98 66.71 41951 HEALTH ALLOWANCE CREDIT 0.00 1,120.68 6,723.94 0.00 (6,723.94) 0.00 41996 VACANCY FACTOR (213,786.00) 0.00 0.00 0.00 (213,786.00) 0.00 41997 BUDGETARY/PAYROLL 5,539.00 0.00 0.00 0.00 5,539.00 0.00 TOTAL FOR SALARIES-BENEFITS 3,741,052.04 215,340.25 2,662,210.66 0.00 1,078,841.38 71.16
SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,750.00 0.00 2,650.00 0.00 3,100.00 46.08 42010 SUBSCRIPTIONS 634.00 0.00 678.36 0.00 (44.36) 106.99 42011 SCAN/MICROFIL/MAPPING SVCS 25,000.00 0.00 1,866.82 0.00 23,133.18 7.46 42014 ELECTRONIC INFO RESOURCES 1,800.00 0.00 44.58 0.00 1,755.42 2.47 42020 MINOR EQUIPMENT & FURNITURE 5,720.00 26,558.88 34,490.14 0.00 (28,770.14) 602.97 42025 HOSE AND APPLIANCE 0.00 0.00 303.41 0.00 (303.41) 0.00 42033 CONSTRUCTION MATERIALS 0.00 0.00 127.56 0.00 (127.56) 0.00 JULIEK Page: 11 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42034 SAFETY MATERIALS/CONSTRUCTION 150.00 0.00 0.00 0.00 150.00 0.00 42055 COMPUTER EQUIPMENT & 16,270.00 0.00 11,668.93 0.00 4,601.07 71.72 42100 UNIFORM EXPENSE 3,750.00 0.00 2,822.87 0.00 927.13 75.27 42101 SAFETY SHOES - MOU ITEM 3,655.50 0.00 675.79 0.00 2,979.71 18.48 42200 ADVERTISING EXPENSE 3,400.00 102.80 6,805.53 0.00 (3,405.53) 200.16 42300 WIRELESS COMMUNICATION 17,486.00 0.00 11,044.74 0.00 6,441.26 63.16 42310 PHONES, FAX, ISDN LINES 1,200.00 240.94 1,533.61 0.00 (333.61) 127.80 42320 POSTAGE & SHIPPING 12,050.00 1,743.50 7,716.16 0.00 4,333.84 64.03 42340 OFFICE SUPPLIES 10,000.00 698.85 7,736.20 0.00 2,263.80 77.36 42345 FIRST AID KIT SUPPLIES 150.00 0.00 197.67 0.00 (47.67) 131.78 42350 PROGRAM EXPENDITURES 15,025.00 190.33 19,329.25 0.00 (4,304.25) 128.64 42360 CLEANING/JANITORIAL SUPPLIES 124.20 0.00 0.00 0.00 124.20 0.00 42410 ELECTRIC UTILITY 1,200.00 204.52 1,197.12 0.00 2.88 99.76 42420 NATURAL GAS UTILITY 2,400.00 166.33 1,576.49 0.00 823.51 65.68 42430 WATER UTILITY 10,000.00 751.05 9,281.09 0.00 718.91 92.81 42600 MOTOR POOL RENTAL 83,551.00 0.00 45,075.00 0.00 38,476.00 53.94 42710 MILEAGE/VEHICLE EXP REIMB 720.00 0.00 0.00 0.00 720.00 0.00 42800 EQUIPMENT MAINTENANCE 14,300.00 0.00 0.00 0.00 14,300.00 0.00 42811 MAINTENANCE & OPERATING 17,500.00 335.00 6,428.70 17,091.30 (6,020.00) 134.40 42813 MTCE & REPAIR - EQUIP & FAC 0.00 314.74 1,250.22 13.93 (1,264.15) 0.00 42900 PROF. & CONT. SVCS 1,686,736.88 563,771.70 1,998,321.90 592,023.87 (903,608.89) 153.57 42906 OTHER GOVT AGENCY FEES 30,000.00 0.00 32,335.16 0.00 (2,335.16) 107.78 43100 MEMBERSHIP & DUES 7,933.00 0.00 3,131.48 0.00 4,801.52 39.47 43200 CONFERENCE, TRAINING & TRAVEL 12,100.00 0.00 3,404.16 0.00 8,695.84 28.13 43400 LEGAL SERVICES-SPECIAL COUNSEL 25,000.00 0.00 0.00 0.00 25,000.00 0.00 43500 BOOKS 650.00 0.00 551.18 0.00 98.82 84.79
43724 OUTSIDE SERVICES - LABOR 0.00 0.00 0.00 4,817.00 (4,817.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,014,255.58 595,078.64 2,212,244.12 613,946.10 (811,934.64) 140.30 TOTAL FOR COMMUNITY DEVELOPMENT DEPT5,755,307.62 810,418.89 4,874,454.78 613,946.10 266,906.74 95.36 30 FIRE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 11,203,643.20 857,108.66 10,140,642.77 0.00 1,063,000.43 90.51 41101 SPECIAL ASSIGNMENT PAY 0.00 (41.01) (257.33) 0.00 257.33 0.00 41140 FINAL LEAVE 0.00 43,081.72 176,253.62 0.00 (176,253.62) 0.00 41141 SP COMP-BILINGUAL 76,274.92 4,095.13 53,016.50 0.00 23,258.42 69.50 41149 SP COMP-PARAMEDIC CQI COORD 5,979.96 460.00 5,782.86 0.00 197.10 96.70 41150 SP COMP-HAZRDOUS PAY 107,331.56 5,698.94 71,581.20 0.00 35,750.36 66.69 41151 SP COMP-SECONDARY MEDIC 145,430.01 13,424.27 138,303.74 0.00 7,126.27 95.09 41152 SP COMP-SP ASSIGNMENT 0.00 0.00 1,864.80 0.00 (1,864.80) 0.00 41153 SP COMP-ACTING FIRE ENG 0.00 1.94 1,172.84 0.00 (1,172.84) 0.00 JULIEK Page: 12 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41154 SP COMP-ACTING FIRE CAPT 0.00 54.84 379.24 0.00 (379.24) 0.00 41155 SP COMP-ACTING BATTALION CHIEF 0.00 0.00 1,192.26 0.00 (1,192.26) 0.00 41200 TEMPORARY EMPLOYEES 286,035.83 4,674.92 74,026.54 0.00 212,009.29 25.88 41300 OVERTIME 861,795.00 39,660.97 892,453.89 0.00 (30,658.89) 103.55 41310 OVERTIME - FLSA 249,164.53 20,667.55 896,199.11 0.00 (647,034.58) 359.68 41330 CONSTANT STAFF LEVELS-OT FIRE 5,176,663.00 401,918.93 5,442,162.22 0.00 (265,499.22) 105.12 41350 OVERTIME - TRAINING 565,800.00 35,588.22 308,921.53 0.00 256,878.47 54.59 41400 SPECIAL DUTY PAY 22,000.00 1,531.52 17,608.72 0.00 4,391.28 80.03 41420 FIRE HOLIDAY PAY 529,263.53 26,450.85 423,857.06 0.00 105,406.47 80.08 41500 DEFERRED COMPENSATION MATCH 4,821.00 3,475.00 6,200.00 0.00 (1,379.00) 128.60 41510 PST DEFERRED COMPENSATION 3,049.42 60.79 643.67 0.00 2,405.75 21.10 41520 TIERED EMP DEF COMPENSATION 2,425.00 750.00 2,550.00 0.00 (125.00) 105.15 41530 TIERED RHS BENEFIT 404,318.00 99,400.00 390,242.86 0.00 14,075.14 96.51 41600 LONGEVITY 327,925.96 25,287.18 310,265.34 0.00 17,660.62 94.61 41630 ONE TIME MOU PAYMENTS 11,220.80 0.00 11,220.80 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 115,523.00 525.00 32,521.90 0.00 83,001.10 28.15 41700 ANNUAL LEAVE BUYBACK 24,670.00 0.00 36,990.15 0.00 (12,320.15) 149.93 41710 ANNUAL LEAVE OVER MAX 67,906.00 0.00 71,676.33 0.00 (3,770.33) 105.55 41800 UNIFORM ALLOWANCE 4,040.00 310.78 4,117.73 0.00 (77.73) 101.92 41910 PERS-NORMAL 2,632,505.72 193,271.55 2,348,492.09 0.00 284,013.63 89.21 41912 PERS-UNFUNDED 1,098,087.18 0.00 1,098,087.18 0.00 0.00 100.00 41920 MEDICARE 395,554.41 23,463.05 305,416.69 0.00 90,137.72 77.21 41929 SHORT TERM DISABILITY 35,878.54 3,128.83 32,858.22 0.00 3,020.32 91.58 41930 LONG TERM DISABILITY 76,250.22 5,832.79 69,009.47 0.00 7,240.75 90.50 41931 WORKERS COMP 666,116.27 49,574.52 588,878.35 0.00 77,237.92 88.40 41932 STATE UNEMPLOYMENT INSURANCE 9,475.32 740.55 9,501.53 0.00 (26.21) 100.27 41940 HEALTH INSURANCE 1,683,653.09 134,304.85 1,475,666.08 0.00 207,987.01 87.64 41945 OPT OUT HEALTH INSURANCE 180,525.00 11,000.00 166,850.00 0.00 13,675.00 92.42 41946 LIFE INSURANCE 93,067.84 7,119.02 84,233.21 0.00 8,834.63 90.50 41950 MEDICAL DIFFERENCE 0.00 0.00 5,064.88 0.00 (5,064.88) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 7,263.60 51,608.31 0.00 (51,608.31) 0.00 41996 VACANCY FACTOR (173,127.00) 0.00 0.00 0.00 (173,127.00) 0.00 41997 BUDGETARY/PAYROLL (104,013.00) 0.00 0.00 0.00 (104,013.00) 0.00 TOTAL FOR SALARIES-BENEFITS 26,789,254.31 2,019,884.96 25,747,256.36 0.00 1,041,997.95 96.11
SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 2,300.00 0.00 5,511.50 0.00 (3,211.50) 239.63 42020 MINOR EQUIPMENT & FURNITURE 338,263.29 56,158.32 215,807.75 52,466.57 69,988.97 79.30 42025 HOSE AND APPLIANCE 37,488.67 941.23 38,861.55 0.00 (1,372.88) 103.66 42026 HAZMAT EQUIPMENT 15,000.00 0.00 14,960.72 0.00 39.28 99.73 42027 TECHNICAL RESCUE EQUIPMENT 20,000.00 0.00 13,994.37 0.00 6,005.63 69.97 JULIEK Page: 13 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42028 SCBA BREATHING APPARATUS 25,000.00 0.00 12,993.94 7,126.64 4,879.42 80.48 42033 CONSTRUCTION MATERIALS 0.00 0.00 291.69 0.00 (291.69) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 5,000.00 0.00 5,022.16 0.00 (22.16) 100.44 42055 COMPUTER EQUIPMENT & 10,500.00 0.00 7,619.49 0.00 2,880.51 72.56 42100 UNIFORM EXPENSE 35,300.00 0.00 32,704.52 1,560.87 1,034.61 97.06 42101 SAFETY SHOES - MOU ITEM 1,400.00 0.00 146.37 0.00 1,253.63 10.45 42105 PROTECTIVE CLOTHING 301,669.00 42,359.01 207,195.26 2,642.87 91,830.87 69.55 42110 EMS SUPPLIES 208,000.00 50.17 79,530.98 13,886.03 114,582.99 44.91 42300 WIRELESS COMMUNICATION 54,500.00 208.85 43,937.84 0.00 10,562.16 80.61 42305 PBLC SFTY RADIO COMMUNICATION 39,400.00 543.20 2,553.11 0.00 36,846.89 6.47 42310 PHONES, FAX, ISDN LINES 10,000.00 521.92 6,026.33 0.00 3,973.67 60.26 42320 POSTAGE & SHIPPING 2,000.00 102.18 1,435.03 0.00 564.97 71.75 42340 OFFICE SUPPLIES 9,200.00 454.04 6,847.89 0.00 2,352.11 74.43 42350 PROGRAM EXPENDITURES 72,862.00 891.07 41,405.37 0.00 31,456.63 56.82 42360 CLEANING/JANITORIAL SUPPLIES 26,600.00 1,855.86 24,007.73 0.00 2,592.27 90.25 42441 UNLEADED FUEL 0.00 0.00 226.18 0.00 (226.18) 0.00 42600 MOTOR POOL RENTAL 1,451,825.00 0.00 1,413,526.00 0.00 38,299.00 97.36 42605 RETAINED VEHICLE EXPENSE 4,937.00 0.00 4,937.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 13,200.00 0.00 10,314.87 0.00 2,885.13 78.14 42640 MDC RENTAL RATES 56,240.00 0.00 38,540.00 0.00 17,700.00 68.52 42700 OTHER EQUIPMENT RENTAL 2,000.00 0.00 1,927.80 0.00 72.20 96.39 42710 MILEAGE/VEHICLE EXP REIMB 200.00 0.00 531.10 0.00 (331.10) 265.55 42800 EQUIPMENT MAINTENANCE 8,500.00 0.00 10,874.85 427.05 (2,801.90) 132.96 42810 BUILDING MAINTENANCE 78,676.86 157.96 70,897.18 17,781.78 (10,002.10) 112.71 42900 PROF. & CONT. SVCS 422,627.32 75,916.58 293,683.34 91,171.50 37,772.48 91.06 42907 EMS SUBSCRIPTION ADMIN 60,000.00 0.00 0.00 0.00 60,000.00 0.00 42912 CAD DISPATCH SERVICES 210,000.00 0.00 0.00 0.00 210,000.00 0.00 43100 MEMBERSHIP & DUES 4,650.00 0.00 7,104.10 0.00 (2,454.10) 152.77 43200 CONFERENCE, TRAINING & TRAVEL 107,900.00 11,540.29 68,575.61 0.00 39,324.39 63.55 43500 BOOKS 1,500.00 0.00 515.68 0.00 984.32 34.37
43600 DISASTER PREPAREDNESS 4,000.00 0.00 610.95 0.00 3,389.05 15.27 43716 JOB REQ CERTIFICATES & LICENSE 2,750.00 425.00 3,742.56 0.00 (992.56) 136.09 TOTAL FOR SERVICES-SUPPLIES 3,643,489.14 192,125.68 2,686,860.82 187,063.31 769,565.01 78.87
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 118,541.66 0.00 68,728.90 50,444.56 (631.80) 100.53 TOTAL FOR CAPITAL OUTLAY 118,541.66 0.00 68,728.90 50,444.56 (631.80) 100.53 TOTAL FOR FIRE 30,551,285.11 2,212,010.64 28,502,846.08 237,507.87 1,810,931.16 94.07 32 POLICE
SALARIES-BENEFITS
JULIEK Page: 14 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41100 PERMANENT EMPLOYEES 22,253,982.00 1,514,327.69 18,464,316.47 0.00 3,789,665.53 82.97 41101 SPECIAL ASSIGNMENT PAY 0.00 25.04 3,617.28 0.00 (3,617.28) 0.00 41102 SHIFT DIFFERENTIAL 132,912.00 7,373.82 119,990.40 0.00 12,921.60 90.27 41103 OUT OF CLASS PAY 0.00 0.00 1,449.84 0.00 (1,449.84) 0.00 41105 INCENTIVE PAY PROGRAM 0.00 10,000.00 50,000.00 0.00 (50,000.00) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 6,709.98 0.00 (6,709.98) 0.00 41140 FINAL LEAVE 0.00 10,597.88 353,389.61 0.00 (353,389.61) 0.00 41141 SP COMP-BILINGUAL 194,230.41 14,186.57 182,749.92 0.00 11,480.49 94.08 41142 SP COMP-EMD PAY 54,838.12 0.00 39,853.96 0.00 14,984.16 72.67 41143 SP COMP-CGEA TRAINING OFFICER 2,899.92 19.17 1,839.39 0.00 1,060.53 63.42 41144 SP COMP-LEAD ANIMAL CTRL 2,630.04 202.32 2,543.45 0.00 86.59 96.70 41145 SP COMP-LEAD RECORDS TECH 8,659.92 666.16 8,374.58 0.00 285.34 96.70 41157 SP COMP-ACCIDENT INVESTIGATION 6,756.59 400.64 4,763.25 0.00 1,993.34 70.49 41158 SP COMP-MOTOR OFFICER 35,556.10 2,003.20 30,072.61 0.00 5,483.49 84.57 41159 SP COMP-INTERMEDIATE POST 438,954.68 3,742.30 300,988.25 0.00 137,966.43 68.56 41160 SP COMP-ADVANCED POST 636,231.88 69,975.91 669,569.98 0.00 (33,338.10) 105.23 41161 SP COMP-SUPERVISOR POST 20,108.64 0.00 15,744.73 0.00 4,363.91 78.29 41162 SP COMP-MGMT POST 33,515.41 4,819.40 36,438.95 0.00 (2,923.54) 108.72 41164 SP COMP-CANINE PAY 15,892.83 1,983.76 27,359.41 0.00 (11,466.58) 172.14 41165 SP COMP-SCHOOL RESOURCE OFFCR 15,074.61 1,602.56 20,266.22 0.00 (5,191.61) 134.43 41166 SP COMP-INVESTIGATIVE UNIT 38,685.84 2,640.80 41,397.56 0.00 (2,711.72) 107.00 41167 SP COMP-TRAFFIC CPL/SGT 12,224.85 964.24 9,602.32 0.00 2,622.53 78.54 41168 SP COMP-RELIEF WATCH CMND 13,319.77 1,597.87 20,160.07 0.00 (6,840.30) 151.35 41169 SP COMP-SPEC ENFORC TEAM 15,632.91 0.00 881.97 0.00 14,750.94 5.64 41171 SP COMP-SR DETECTIVE 54,369.68 3,022.32 34,278.12 0.00 20,091.56 63.04 41172 SP COMP-COMMERCIAL 5,079.59 400.64 4,623.13 0.00 456.46 91.01 41173 SP COMP-PACT TEAM 5,338.51 802.72 10,222.02 0.00 (4,883.51) 191.47 41174 SP COMP-PERSONNEL OFFICER 5,338.51 821.76 12,724.99 0.00 (7,386.48) 238.36 41176 SP COMP-DETECTIVE SGT 21,610.95 1,577.68 20,965.62 0.00 645.33 97.01 41177 SP COMP-PROFESSIONAL STND UNIT 7,079.81 492.64 6,151.20 0.00 928.61 86.88 41178 SP COMP-PERSONNEL & TRAINING 6,885.34 504.96 6,935.94 0.00 (50.60) 100.73 41179 SP COMP-TRAINING OFFICER 5,079.59 1,750.13 28,375.29 0.00 (23,295.70) 558.61 41180 SP COMP-YOUTH DIVERSION 14,538.42 949.04 11,020.37 0.00 3,518.05 75.80 41181 SP COMP-POLICE SUPPORT SVCS 10,910.39 0.00 0.00 0.00 10,910.39 0.00 41182 SP COMP-TACTICAL FLIGHT OFFCR 5,079.59 0.00 28.01 0.00 5,051.58 0.55 41183 SP COMP-HOPE-HMLS OUTRCH & 22,549.67 2,145.68 23,047.84 0.00 (498.17) 102.20 41184 SP COMP-FLEX TEAM OFFICER/CORP 15,193.93 1,765.52 22,616.75 0.00 (7,422.82) 148.85 41200 TEMPORARY EMPLOYEES 607,148.53 30,552.92 274,067.83 0.00 333,080.70 45.14 41300 OVERTIME 2,254,337.14 333,538.96 3,645,752.89 0.00 (1,391,415.75) 161.72 41310 OVERTIME - FLSA 0.00 129.99 1,297.44 0.00 (1,297.44) 0.00 JULIEK Page: 15 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41320 COMP TIME 475,815.00 75,365.22 722,258.86 0.00 (246,443.86) 151.79 41400 SPECIAL DUTY PAY 100,520.00 8,083.12 95,626.07 0.00 4,893.93 95.13 41500 DEFERRED COMPENSATION MATCH 34,854.00 5,290.00 34,125.00 0.00 729.00 97.90 41510 PST DEFERRED COMPENSATION 5,672.77 185.89 2,243.02 0.00 3,429.75 39.54 41520 TIERED EMP DEF COMPENSATION 20,825.00 4,500.00 18,900.00 0.00 1,925.00 90.75 41530 TIERED RHS BENEFIT 667,970.00 156,687.50 614,928.57 0.00 53,041.43 92.05 41600 LONGEVITY 602,134.56 47,992.35 1,112,234.92 0.00 (510,100.36) 184.71 41601 MARKSMANSHIP 67,830.00 4,675.42 61,750.22 0.00 6,079.78 91.03 41630 ONE TIME MOU PAYMENTS 86,129.85 0.00 86,129.85 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 44,134.00 0.00 16,819.63 0.00 27,314.37 38.11 41700 ANNUAL LEAVE BUYBACK 440,260.00 0.00 433,813.31 0.00 6,446.69 98.53 41710 ANNUAL LEAVE OVER MAX 89,718.00 0.00 124,818.16 0.00 (35,100.16) 139.12 41800 UNIFORM ALLOWANCE 575,514.00 40,660.74 533,819.89 0.00 41,694.11 92.75 41910 PERS-NORMAL 5,271,051.37 374,711.57 4,722,243.19 0.00 548,808.18 89.58 41912 PERS-UNFUNDED 2,009,402.46 0.00 2,009,402.46 0.00 0.00 100.00 41920 MEDICARE 872,920.11 64,927.72 832,954.22 0.00 39,965.89 95.42 41929 SHORT TERM DISABILITY 71,223.92 5,784.16 61,993.82 0.00 9,230.10 87.04 41930 LONG TERM DISABILITY 151,349.68 6,035.85 127,570.39 0.00 23,779.29 84.28 41931 WORKERS COMP 1,264,154.72 89,076.01 1,075,054.76 0.00 189,099.96 85.04 41932 STATE UNEMPLOYMENT INSURANCE 14,842.95 1,119.15 14,270.13 0.00 572.82 96.14 41940 HEALTH INSURANCE 3,101,359.28 231,973.36 2,499,755.49 0.00 601,603.79 80.60 41945 OPT OUT HEALTH INSURANCE 594,208.00 30,830.00 582,371.25 0.00 11,836.75 98.00 41946 LIFE INSURANCE 184,733.93 13,145.77 158,937.93 0.00 25,796.00 86.03 41950 MEDICAL DIFFERENCE 0.00 0.00 2,946.45 0.00 (2,946.45) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 11,384.20 66,606.30 0.00 (66,606.30) 0.00 41996 VACANCY FACTOR (566,495.00) 0.00 0.00 0.00 (566,495.00) 0.00 41997 BUDGETARY/PAYROLL (141,789.43) 0.00 0.00 0.00 (141,789.43) 0.00 41999 PAYROLL SUSPENSE 0.00 34,522.64 424,907.36 0.00 (424,907.36) 0.00 TOTAL FOR SALARIES-BENEFITS 43,010,985.34 3,232,534.96 40,950,668.89 0.00 2,060,316.45 95.20
SERVICES-SUPPLIES
42010 SUBSCRIPTIONS 1,157.00 0.00 644.94 0.00 512.06 55.74 42020 MINOR EQUIPMENT & FURNITURE 168,891.73 15,186.33 101,507.48 20,921.40 46,462.85 72.48 42033 CONSTRUCTION MATERIALS 0.00 7.70 255.44 0.00 (255.44) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 250.00 6.44 612.50 0.00 (362.50) 245.00 42055 COMPUTER EQUIPMENT & 18,984.00 0.00 43,211.91 0.00 (24,227.91) 227.62 42100 UNIFORM EXPENSE 47,800.00 5,927.44 60,964.85 3,949.52 (17,114.37) 135.80 42101 SAFETY SHOES - MOU ITEM 12,439.00 0.00 175.00 0.00 12,264.00 1.40 42105 PROTECTIVE CLOTHING 49,763.50 16,732.29 56,702.18 0.00 (6,938.68) 113.94 42200 ADVERTISING EXPENSE 0.00 0.00 292.69 0.00 (292.69) 0.00 42300 WIRELESS COMMUNICATION 63,400.00 1,163.72 56,239.46 0.00 7,160.54 88.70 JULIEK Page: 16 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42305 PBLC SFTY RADIO COMMUNICATION 163,563.00 47,665.80 107,349.90 0.00 56,213.10 65.63 42310 PHONES, FAX, ISDN LINES 37,290.00 2,667.08 32,065.78 0.00 5,224.22 85.99 42320 POSTAGE & SHIPPING 27,295.00 1,310.05 14,463.59 0.00 12,831.41 52.98 42340 OFFICE SUPPLIES 53,850.00 2,239.60 36,057.30 0.00 17,792.70 66.95 42345 FIRST AID KIT SUPPLIES 0.00 0.00 174.02 0.00 (174.02) 0.00 42350 PROGRAM EXPENDITURES 265,881.10 527.71 253,273.47 24,526.62 (11,918.99) 104.48 42360 CLEANING/JANITORIAL SUPPLIES 15,500.00 0.00 11,005.90 0.00 4,494.10 71.00 42410 ELECTRIC UTILITY 5,000.00 478.74 4,719.68 0.00 280.32 94.39 42441 UNLEADED FUEL 0.00 23.73 67.24 0.00 (67.24) 0.00
42442 DIESEL FUEL 0.00 0.00 20.60 0.00 (20.60) 0.00
42500 RENTS & LEASES 1.00 0.00 2.00 0.00 (1.00) 200.00
42600 MOTOR POOL RENTAL 1,654,480.00 0.00 1,642,485.00 0.00 11,995.00 99.27 42605 RETAINED VEHICLE EXPENSE 42,471.00 0.00 42,471.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 7,249.00 0.00 0.00 0.00 7,249.00 0.00 42640 MDC RENTAL RATES 139,580.00 0.00 139,580.00 0.00 0.00 100.00 42800 EQUIPMENT MAINTENANCE 117,390.43 31.09 74,028.97 1,395.53 41,965.93 64.25 42810 BUILDING MAINTENANCE 24,700.00 3,517.80 22,462.03 0.00 2,237.97 90.93 42813 MTCE & REPAIR - EQUIP & FAC 0.00 0.00 2.36 0.00 (2.36) 0.00 42900 PROF. & CONT. SVCS 1,214,414.81 89,878.71 972,925.93 132,266.64 109,222.24 91.00 42905 SPECIAL INVESTIGATIONS 9,070.00 720.00 14,188.39 0.00 (5,118.39) 156.43 43100 MEMBERSHIP & DUES 12,424.00 0.00 7,942.00 0.00 4,482.00 63.92 43200 CONFERENCE, TRAINING & TRAVEL 65,480.00 228.00 80,818.73 0.00 (15,338.73) 123.42 43220 P.O.S.T. CONFERENCE & TRAINING 69,494.00 1,928.00 111,196.01 0.00 (41,702.01) 160.00 43500 BOOKS 1,070.00 0.00 0.00 0.00 1,070.00 0.00
43715 REGULATORY PERMIT & USE FEES 705.00 0.00 595.00 0.00 110.00 84.39 TOTAL FOR SERVICES-SUPPLIES 4,289,593.57 190,240.23 3,888,501.35 183,059.71 218,032.51 94.91
CAPITAL OUTLAY
45100 LICENSED VEHICLES 185,663.00 0.00 0.00 137,971.87 47,691.13 74.31 TOTAL FOR CAPITAL OUTLAY 185,663.00 0.00 0.00 137,971.87 47,691.13 74.31 TOTAL FOR POLICE 47,486,241.91 3,422,775.19 44,839,170.24 321,031.58 2,326,040.09 95.10 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,573,029.30 94,664.32 1,062,506.99 0.00 510,522.31 67.54 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 401.90 0.00 (401.90) 0.00 41102 SHIFT DIFFERENTIAL 0.00 0.00 6.63 0.00 (6.63) 0.00 41103 OUT OF CLASS PAY 0.00 737.28 4,149.43 0.00 (4,149.43) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 2,626.03 0.00 (2,626.03) 0.00 41140 FINAL LEAVE 0.00 4,839.13 40,816.96 0.00 (40,816.96) 0.00 41141 SP COMP-BILINGUAL 10,712.88 727.45 5,489.85 0.00 5,223.03 51.24 JULIEK Page: 17 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41200 TEMPORARY EMPLOYEES 111,963.65 3,052.44 54,582.03 0.00 57,381.62 48.74 41300 OVERTIME 47,855.00 6,257.24 92,267.77 0.00 (44,412.77) 192.80 41400 SPECIAL DUTY PAY 21,910.00 2,243.90 30,184.37 0.00 (8,274.37) 137.76 41410 AUTO ALLOWANCE 2,534.40 194.96 2,457.79 0.00 76.61 96.97 41500 DEFERRED COMPENSATION MATCH 8,548.00 2,326.99 6,151.45 0.00 2,396.55 71.96 41510 PST DEFERRED COMPENSATION 706.84 22.71 156.02 0.00 550.82 22.07 41520 TIERED EMP DEF COMPENSATION 3,942.00 801.00 3,238.89 0.00 703.11 82.16 41530 TIERED RHS BENEFIT 2,614.00 618.00 2,339.63 0.00 274.37 89.50 41600 LONGEVITY 7,824.41 655.09 13,036.93 0.00 (5,212.52) 166.61 41630 ONE TIME MOU PAYMENTS 19,076.73 0.00 19,076.73 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 10,124.35 0.00 10,123.65 0.00 0.70 99.99 41710 ANNUAL LEAVE OVER MAX 1,404.00 0.00 1,359.84 0.00 44.16 96.85 41910 PERS-NORMAL 181,273.05 10,963.33 123,471.82 0.00 57,801.23 68.11 41912 PERS-UNFUNDED 97,270.47 0.00 97,270.47 0.00 0.00 100.00 41920 MEDICARE 53,549.42 3,471.81 39,791.29 0.00 13,758.13 74.30 41929 SHORT TERM DISABILITY 5,031.91 355.26 3,535.38 0.00 1,496.53 70.25 41930 LONG TERM DISABILITY 10,695.93 663.73 7,435.99 0.00 3,259.94 69.52 41931 WORKERS COMP 33,936.75 1,993.74 22,413.28 0.00 11,523.47 66.04 41932 STATE UNEMPLOYMENT INSURANCE 915.89 58.68 691.21 0.00 224.68 75.46 41940 HEALTH INSURANCE 303,851.89 13,017.68 155,468.16 0.00 148,383.73 51.16 41945 OPT OUT HEALTH INSURANCE 26,863.00 2,695.98 40,643.52 0.00 (13,780.52) 151.29 41946 LIFE INSURANCE 13,057.62 810.09 9,076.28 0.00 3,981.34 69.50 41951 HEALTH ALLOWANCE CREDIT 0.00 718.92 4,627.95 0.00 (4,627.95) 0.00 41996 VACANCY FACTOR (141,951.00) 0.00 0.00 0.00 (141,951.00) 0.00 41997 BUDGETARY/PAYROLL (74,200.00) 0.00 0.00 0.00 (74,200.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,332,540.49 151,889.73 1,855,398.24 0.00 477,142.25 79.54
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 3,800.00 0.00 5,826.10 0.00 (2,026.10) 153.31 42033 CONSTRUCTION MATERIALS 0.00 0.00 106.30 0.00 (106.30) 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 450.00 0.00 669.22 0.00 (219.22) 148.71 42055 COMPUTER EQUIPMENT & 9,550.00 0.00 17,160.78 0.00 (7,610.78) 179.69 42100 UNIFORM EXPENSE 300.00 0.00 0.00 0.00 300.00 0.00 42101 SAFETY SHOES - MOU ITEM 4,947.63 0.00 0.00 0.00 4,947.63 0.00 42300 WIRELESS COMMUNICATION 7,350.00 0.00 10,012.74 0.00 (2,662.74) 136.22 42320 POSTAGE & SHIPPING 600.00 15.83 772.18 0.00 (172.18) 128.69 42340 OFFICE SUPPLIES 7,900.00 560.31 6,723.63 0.00 1,176.37 85.10 42345 FIRST AID KIT SUPPLIES 200.00 0.00 92.95 0.00 107.05 46.47 42350 PROGRAM EXPENDITURES 6,200.00 470.11 2,860.95 0.00 3,339.05 46.14 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 100.26 0.00 (100.26) 0.00 42435 RECYCLED WATER UTILITY 0.00 0.00 10.85 0.00 (10.85) 0.00 JULIEK Page: 18 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42600 MOTOR POOL RENTAL 48,083.25 0.00 48,083.25 0.00 0.00 100.00 42710 MILEAGE/VEHICLE EXP REIMB 1,650.00 0.00 18.95 0.00 1,631.05 1.14 42800 EQUIPMENT MAINTENANCE 13,800.00 0.00 0.00 0.00 13,800.00 0.00 42900 PROF. & CONT. SVCS 319,863.71 98,297.50 148,946.24 106,719.58 64,197.89 79.92 43100 MEMBERSHIP & DUES 1,400.00 0.00 4,059.77 0.00 (2,659.77) 289.98 43200 CONFERENCE, TRAINING & TRAVEL 6,900.00 0.00 3,954.08 0.00 2,945.92 57.30 43724 OUTSIDE SERVICES - LABOR 536,218.00 42,199.40 480,502.30 173,038.26 (117,322.56) 121.87 43727 INSPECTION 661,111.25 134,810.00 354,351.49 474,505.25 (167,745.49) 125.37 TOTAL FOR SERVICES-SUPPLIES 1,630,323.84 276,353.15 1,084,252.04 754,263.09 (208,191.29) 112.76 TOTAL FOR PUBLIC WORKS 3,962,864.33 428,242.88 2,939,650.28 754,263.09 268,950.96 93.21 41 MAINTENANCE SERVICES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,266,235.86 89,645.07 1,071,314.35 0.00 194,921.51 84.60 41103 OUT OF CLASS PAY 0.00 53.52 2,587.60 0.00 (2,587.60) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 4,820.56 0.00 (4,820.56) 0.00 41140 FINAL LEAVE 0.00 0.00 9,017.91 0.00 (9,017.91) 0.00 41141 SP COMP-BILINGUAL 3,981.63 372.88 3,853.98 0.00 127.65 96.79 41148 SP COMP-GRADE 5 CERT PAY 0.00 148.96 446.88 0.00 (446.88) 0.00 41200 TEMPORARY EMPLOYEES 18,484.96 0.00 1,499.29 0.00 16,985.67 8.11 41300 OVERTIME 156,796.00 5,382.67 124,822.85 0.00 31,973.15 79.60 41320 COMP TIME 0.00 394.99 5,261.46 0.00 (5,261.46) 0.00 41400 SPECIAL DUTY PAY 34,498.00 4,709.24 57,109.66 0.00 (22,611.66) 165.54 41410 AUTO ALLOWANCE 1,210.80 57.60 724.11 0.00 486.69 59.80 41500 DEFERRED COMPENSATION MATCH 8,009.00 1,743.90 7,342.20 0.00 666.80 91.67 41510 PST DEFERRED COMPENSATION 0.00 0.00 19.50 0.00 (19.50) 0.00 41520 TIERED EMP DEF COMPENSATION 5,736.00 1,613.99 6,103.49 0.00 (367.49) 106.40 41530 TIERED RHS BENEFIT 2,424.00 686.00 2,591.50 0.00 (167.50) 106.91 41600 LONGEVITY 13,127.96 1,061.08 22,021.56 0.00 (8,893.60) 167.74 41630 ONE TIME MOU PAYMENTS 23,737.89 0.00 23,737.89 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 21,659.37 0.00 21,673.34 0.00 (13.97) 100.06 41710 ANNUAL LEAVE OVER MAX 6,534.00 0.00 5,515.43 0.00 1,018.57 84.41 41910 PERS-NORMAL 148,657.50 10,443.50 126,841.28 0.00 21,816.22 85.32 41912 PERS-UNFUNDED 91,867.32 0.00 91,867.32 0.00 0.00 100.00 41920 MEDICARE 47,874.79 3,195.60 41,564.55 0.00 6,310.24 86.81 41929 SHORT TERM DISABILITY 4,052.49 329.91 3,485.59 0.00 566.90 86.01 41930 LONG TERM DISABILITY 8,610.92 614.61 7,319.39 0.00 1,291.53 85.00 41931 WORKERS COMP 26,776.55 1,865.41 22,004.08 0.00 4,772.47 82.17 41932 STATE UNEMPLOYMENT INSURANCE 792.59 53.00 704.02 0.00 88.57 88.82 41940 HEALTH INSURANCE 293,104.77 18,151.39 213,303.68 0.00 79,801.09 72.77 41945 OPT OUT HEALTH INSURANCE 48,745.00 3,765.99 61,675.75 0.00 (12,930.75) 126.52 JULIEK Page: 19 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41946 LIFE INSURANCE 10,509.67 750.22 8,933.87 0.00 1,575.80 85.00 41951 HEALTH ALLOWANCE CREDIT 0.00 771.17 5,429.02 0.00 (5,429.02) 0.00 41996 VACANCY FACTOR (57,676.00) 0.00 0.00 0.00 (57,676.00) 0.00 41997 BUDGETARY/PAYROLL (6,690.00) 0.00 0.00 0.00 (6,690.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,179,061.07 145,810.70 1,953,592.11 0.00 225,468.96 89.65
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 13,000.00 2,485.72 19,242.12 2,500.00 (8,742.12) 167.24 42030 BUILDING MAINTENANCE SUPPLIES 0.00 0.00 1,098.47 0.00 (1,098.47) 0.00 42033 CONSTRUCTION MATERIALS 207,372.00 15,894.22 190,339.76 36,860.37 (19,828.13) 109.56 42034 SAFETY MATERIALS/CONSTRUCTION 8,500.00 876.57 11,108.52 483.72 (3,092.24) 136.37 42055 COMPUTER EQUIPMENT & 3,365.00 0.00 7,171.54 0.00 (3,806.54) 213.12 42100 UNIFORM EXPENSE 9,694.00 (302.41) 8,116.64 0.00 1,577.36 83.72 42101 SAFETY SHOES - MOU ITEM 3,717.00 0.00 0.00 0.00 3,717.00 0.00 42200 ADVERTISING EXPENSE 1,200.00 0.00 3,962.94 0.00 (2,762.94) 330.24 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 0.00 2,174.97 1,259.12 (3,434.09) 0.00 42300 WIRELESS COMMUNICATION 13,125.00 0.00 11,462.69 0.00 1,662.31 87.33 42310 PHONES, FAX, ISDN LINES 5,298.00 383.48 4,612.09 0.00 685.91 87.05 42320 POSTAGE & SHIPPING 151.00 0.00 1.46 0.00 149.54 0.96 42340 OFFICE SUPPLIES 200.00 44.91 280.13 0.00 (80.13) 140.06 42345 FIRST AID KIT SUPPLIES 547.00 0.00 128.72 0.00 418.28 23.53 42350 PROGRAM EXPENDITURES 13,389.00 880.97 14,720.01 0.00 (1,331.01) 109.94 42360 CLEANING/JANITORIAL SUPPLIES 500.00 0.00 84.16 0.00 415.84 16.83 42440 GASOLINE 1,479.00 0.00 0.00 0.00 1,479.00 0.00
42441 UNLEADED FUEL 1,500.00 419.52 3,829.58 0.00 (2,329.58) 255.30 42442 DIESEL FUEL 500.00 0.00 321.03 0.00 178.97 64.20
42600 MOTOR POOL RENTAL 406,103.50 0.00 402,415.50 0.00 3,688.00 99.09 42605 RETAINED VEHICLE EXPENSE 11,100.00 0.00 11,100.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 1,798.00 0.00 0.00 0.00 1,798.00 0.00 42700 OTHER EQUIPMENT RENTAL 5,745.72 1,086.01 3,688.51 1,382.93 674.28 88.26 42710 MILEAGE/VEHICLE EXP REIMB 3,126.00 0.00 551.13 0.00 2,574.87 17.63 42800 EQUIPMENT MAINTENANCE 0.00 89.41 89.41 0.00 (89.41) 0.00 42810 BUILDING MAINTENANCE 0.00 0.00 11,192.88 0.00 (11,192.88) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 548,738.50 60,155.33 470,080.11 203,012.85 (124,354.46) 122.66 42815 SCADA MAINTENANCE 0.00 0.00 360.29 0.00 (360.29) 0.00 42816 MOWING/LANDSCAPE CONTRACTS 75,000.00 11,250.00 32,770.00 0.00 42,230.00 43.69 42822 VANDALISM 13,000.00 0.00 1,958.00 9,285.63 1,756.37 86.48 42900 PROF. & CONT. SVCS 1,507,821.00 108,430.20 1,115,131.17 149,165.59 243,524.24 83.84 42960 INDIRECT SPEC DST COUNTY ADMIN 14,866.00 0.00 0.00 0.00 14,866.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 5,000.00 0.00 1,052.18 0.00 3,947.82 21.04 43715 REGULATORY PERMIT & USE FEES 11,919.00 0.00 8,371.03 0.00 3,547.97 70.23 JULIEK Page: 20 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
43716 JOB REQ CERTIFICATES & LICENSE 5,058.00 0.00 0.00 0.00 5,058.00 0.00 43722 PREVENTION & MAINTENANCE 248,362.67 4,191.23 78,072.75 73,991.82 96,298.10 61.22 43726 PROJECT MANAGEMENT 0.00 0.00 388.80 0.00 (388.80) 0.00 TOTAL FOR SERVICES-SUPPLIES 3,141,175.39 205,885.16 2,415,876.59 477,942.03 247,356.77 92.12
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 8,657.00 0.00 7,930.40 0.00 726.60 91.60 TOTAL FOR CAPITAL OUTLAY 8,657.00 0.00 7,930.40 0.00 726.60 91.60 TOTAL FOR MAINTENANCE SERVICES 5,328,893.46 351,695.86 4,377,399.10 477,942.03 473,552.33 91.11 47 COMMUNITY SERVICES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,101,336.31 137,369.39 1,583,745.14 0.00 517,591.17 75.36 41101 SPECIAL ASSIGNMENT PAY 0.00 1.03 1.03 0.00 (1.03) 0.00 41140 FINAL LEAVE 0.00 2,143.17 7,231.75 0.00 (7,231.75) 0.00 41141 SP COMP-BILINGUAL 11,374.80 1,347.70 10,210.20 0.00 1,164.60 89.76 41200 TEMPORARY EMPLOYEES 2,006,275.12 112,038.15 1,396,992.65 0.00 609,282.47 69.63 41300 OVERTIME 1,810.00 313.01 2,934.13 0.00 (1,124.13) 162.10 41400 SPECIAL DUTY PAY 1,460.00 993.33 22,448.92 0.00 (20,988.92) 1,537.59 41410 AUTO ALLOWANCE 4,896.00 376.62 4,734.65 0.00 161.35 96.70 41500 DEFERRED COMPENSATION MATCH 8,362.96 2,795.00 9,360.00 0.00 (997.04) 111.92 41510 PST DEFERRED COMPENSATION 21,162.56 1,121.94 15,167.37 0.00 5,995.19 71.67 41520 TIERED EMP DEF COMPENSATION 4,948.67 1,477.50 5,527.50 0.00 (578.83) 111.69 41530 TIERED RHS BENEFIT 3,351.20 1,077.50 3,627.50 0.00 (276.30) 108.24 41600 LONGEVITY 9,263.00 792.26 17,319.02 0.00 (8,056.02) 186.96 41630 ONE TIME MOU PAYMENTS 30,028.65 0.00 30,028.65 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 2,500.00 0.00 7,478.00 0.00 (4,978.00) 299.12 41700 ANNUAL LEAVE BUYBACK 27,801.00 0.00 19,206.71 0.00 8,594.29 69.08 41710 ANNUAL LEAVE OVER MAX 11,321.00 0.00 18,350.89 0.00 (7,029.89) 162.09 41910 PERS-NORMAL 298,565.32 18,857.73 208,653.15 0.00 89,912.17 69.88 41912 PERS-UNFUNDED 117,477.30 0.00 117,477.30 0.00 0.00 100.00 41920 MEDICARE 96,128.88 6,082.46 71,942.51 0.00 24,186.37 74.83 41929 SHORT TERM DISABILITY 6,765.61 498.30 5,129.30 0.00 1,636.31 75.81 41930 LONG TERM DISABILITY 11,000.59 932.89 10,772.92 0.00 227.67 97.93 41931 WORKERS COMP 81,464.65 5,017.51 59,771.81 0.00 21,692.84 73.37 41932 STATE UNEMPLOYMENT INSURANCE 2,105.47 129.69 1,569.93 0.00 535.54 74.56 41940 HEALTH INSURANCE 367,033.03 19,647.77 214,418.57 0.00 152,614.46 58.41 41945 OPT OUT HEALTH INSURANCE 52,750.00 2,600.00 42,787.50 0.00 9,962.50 81.11 41946 LIFE INSURANCE 17,568.41 1,138.62 13,149.47 0.00 4,418.94 74.84 41951 HEALTH ALLOWANCE CREDIT 0.00 819.50 4,986.30 0.00 (4,986.30) 0.00 41996 VACANCY FACTOR (193,885.00) 0.00 0.00 0.00 (193,885.00) 0.00 JULIEK Page: 21 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41997 BUDGETARY/PAYROLL (16,914.00) 0.00 0.00 0.00 (16,914.00) 0.00 TOTAL FOR SALARIES-BENEFITS 5,085,951.53 317,571.07 3,905,022.87 0.00 1,180,928.66 76.78
SERVICES-SUPPLIES
42001 APPOINTED OFFICIAL STIPEND 5,400.00 600.00 4,050.00 0.00 1,350.00 75.00 42010 SUBSCRIPTIONS 6,587.00 0.00 6,199.09 0.00 387.91 94.11 42012 AUDIO VISUAL 6,000.00 0.00 6,000.00 0.00 0.00 100.00 42014 ELECTRONIC INFO RESOURCES 21,432.22 0.00 20,870.12 84.09 478.01 97.76 42020 MINOR EQUIPMENT & FURNITURE 21,150.10 337.10 26,757.98 0.00 (5,607.88) 126.51 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 0.00 708.20 0.00 (708.20) 0.00 42055 COMPUTER EQUIPMENT & 27,003.46 0.00 5,405.10 0.00 21,598.36 20.01 42100 UNIFORM EXPENSE 8,750.00 0.00 2,518.90 0.00 6,231.10 28.78 42200 ADVERTISING EXPENSE 0.00 0.00 194.52 0.00 (194.52) 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 4,000.00 0.00 3,370.98 0.00 629.02 84.27 42300 WIRELESS COMMUNICATION 13,224.00 0.00 13,609.41 0.00 (385.41) 102.91 42310 PHONES, FAX, ISDN LINES 2,500.00 168.04 2,028.77 0.00 471.23 81.15 42320 POSTAGE & SHIPPING 26,800.00 1,709.60 18,781.90 0.00 8,018.10 70.08 42340 OFFICE SUPPLIES 14,330.00 60.63 10,694.47 0.00 3,635.53 74.62 42345 FIRST AID KIT SUPPLIES 1,855.00 0.00 297.97 0.00 1,557.03 16.06 42350 PROGRAM EXPENDITURES 290,418.14 4,238.75 198,505.15 0.00 91,912.99 68.35 42441 UNLEADED FUEL 1,825.00 63.92 454.06 0.00 1,370.94 24.88 42630 PARTS/LABOR ON CITY VEHICLES 700.00 0.00 0.00 0.00 700.00 0.00 42700 OTHER EQUIPMENT RENTAL 8,200.00 0.00 7,144.53 0.00 1,055.47 87.12 42710 MILEAGE/VEHICLE EXP REIMB 0.00 0.00 486.75 0.00 (486.75) 0.00 42800 EQUIPMENT MAINTENANCE 22,956.00 0.00 13,761.70 1,800.00 7,394.30 67.78 42810 BUILDING MAINTENANCE 2,500.00 0.00 99.82 0.00 2,400.18 3.99 42813 MTCE & REPAIR - EQUIP & FAC 13,000.00 0.00 6,285.96 0.00 6,714.04 48.35 42900 PROF. & CONT. SVCS 754,704.56 25,159.19 534,767.46 36,773.67 183,163.43 75.73 43000 INSURANCE & SURETY BONDS 8,500.00 0.00 6,555.00 0.00 1,945.00 77.11 43100 MEMBERSHIP & DUES 8,989.00 0.00 4,111.64 0.00 4,877.36 45.74 43200 CONFERENCE, TRAINING & TRAVEL 35,555.00 4,163.03 22,684.64 3,062.74 9,807.62 72.41 43500 BOOKS (5,000.00) 150.12 18,961.36 0.00 (23,961.36) (379.22) 43501 CHILDREN'S BOOKS 30,000.00 3,972.97 28,500.76 0.00 1,499.24 95.00 43505 PASSPORT EXPENSES 31,675.00 5,230.01 19,935.40 0.00 11,739.60 62.93 TOTAL FOR SERVICES-SUPPLIES 1,363,054.48 45,853.36 983,741.64 41,720.50 337,592.34 75.23
CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 1,500.00 0.00 (1,500.00) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 1,500.00 0.00 (1,500.00) 0.00 TOTAL FOR COMMUNITY SERVICES 6,449,006.01 363,424.43 4,890,264.51 41,720.50 1,517,021.00 76.47 65 PARK MAINTENANCE/LMD
JULIEK Page: 22 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 952,484.10 65,670.23 682,297.18 0.00 270,186.92 71.63 41110 CONTRACTUAL OBLIGATION 0.00 0.00 6,554.64 0.00 (6,554.64) 0.00 41141 SP COMP-BILINGUAL 12,985.96 1,225.00 10,687.50 0.00 2,298.46 82.30 41200 TEMPORARY EMPLOYEES 213,046.58 6,971.61 60,538.93 0.00 152,507.65 28.41 41300 OVERTIME 126,544.00 11,634.47 179,454.05 0.00 (52,910.05) 141.81 41320 COMP TIME 0.00 350.20 4,951.97 0.00 (4,951.97) 0.00 41400 SPECIAL DUTY PAY 4,956.00 2,171.43 35,343.57 0.00 (30,387.57) 713.14 41410 AUTO ALLOWANCE 864.00 66.46 835.50 0.00 28.50 96.70 41500 DEFERRED COMPENSATION MATCH 5,637.04 525.00 2,075.00 0.00 3,562.04 36.81 41510 PST DEFERRED COMPENSATION 1,415.44 69.80 718.58 0.00 696.86 50.76 41520 TIERED EMP DEF COMPENSATION 3,451.33 735.00 2,947.50 0.00 503.83 85.40 41530 TIERED RHS BENEFIT 1,448.80 335.00 1,347.50 0.00 101.30 93.00 41600 LONGEVITY 3,300.00 261.52 5,846.03 0.00 (2,546.03) 177.15 41630 ONE TIME MOU PAYMENTS 14,036.32 0.00 14,036.32 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 17,825.00 0.00 15,498.70 0.00 2,326.30 86.94 41710 ANNUAL LEAVE OVER MAX 2,584.00 0.00 4,033.27 0.00 (1,449.27) 156.08 41910 PERS-NORMAL 120,874.06 7,846.23 81,157.81 0.00 39,716.25 67.14 41912 PERS-UNFUNDED 50,573.94 0.00 50,573.94 0.00 0.00 100.00 41920 MEDICARE 39,245.05 2,590.72 29,986.11 0.00 9,258.94 76.40 41929 SHORT TERM DISABILITY 3,204.57 241.11 2,214.07 0.00 990.50 69.09 41930 LONG TERM DISABILITY 10,185.78 446.56 4,639.49 0.00 5,546.29 45.54 41931 WORKERS COMP 24,139.15 1,512.11 15,343.36 0.00 8,795.79 63.56 41932 STATE UNEMPLOYMENT INSURANCE 685.17 45.42 526.48 0.00 158.69 76.83 41940 HEALTH INSURANCE 197,993.41 12,530.40 131,174.09 0.00 66,819.32 66.25 41945 OPT OUT HEALTH INSURANCE 41,175.00 2,050.00 39,012.50 0.00 2,162.50 94.74 41946 LIFE INSURANCE 8,292.04 545.07 5,663.47 0.00 2,628.57 68.30 41951 HEALTH ALLOWANCE CREDIT 0.00 795.08 4,636.98 0.00 (4,636.98) 0.00 41996 VACANCY FACTOR (124,269.00) 0.00 0.00 0.00 (124,269.00) 0.00 41997 BUDGETARY/PAYROLL (38,250.00) 0.00 0.00 0.00 (38,250.00) 0.00 TOTAL FOR SALARIES-BENEFITS 1,694,427.74 118,618.42 1,392,094.54 0.00 302,333.20 82.15
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 19,130.70 2,010.97 36,226.34 0.00 (17,095.64) 189.36 42033 CONSTRUCTION MATERIALS 235,562.00 24,420.21 333,032.66 96,179.58 (193,650.24) 182.20 42034 SAFETY MATERIALS/CONSTRUCTION 1,000.00 1,021.53 9,585.65 0.00 (8,585.65) 958.56 42055 COMPUTER EQUIPMENT & 147.00 0.00 3,131.00 0.00 (2,984.00) 2,129.93 42100 UNIFORM EXPENSE 5,764.00 569.05 8,649.68 0.00 (2,885.68) 150.06 42101 SAFETY SHOES - MOU ITEM 2,669.00 0.00 0.00 0.00 2,669.00 0.00 42200 ADVERTISING EXPENSE 300.00 786.42 3,433.99 0.00 (3,133.99) 1,144.66 42300 WIRELESS COMMUNICATION 4,275.00 297.92 11,576.11 0.00 (7,301.11) 270.78 JULIEK Page: 23 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42310 PHONES, FAX, ISDN LINES 2,699.00 219.28 7,708.87 0.00 (5,009.87) 285.61 42320 POSTAGE & SHIPPING 50.00 0.00 265.73 0.00 (215.73) 531.46 42340 OFFICE SUPPLIES 1,000.00 6.48 303.23 0.00 696.77 30.32 42350 PROGRAM EXPENDITURES 46,305.00 2,697.20 53,930.78 15,505.80 (23,131.58) 149.95 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 84.16 0.00 (84.16) 0.00 42430 WATER UTILITY 0.00 335.53 6,258.30 0.00 (6,258.30) 0.00 42435 RECYCLED WATER UTILITY 0.00 210.16 853.00 0.00 (853.00) 0.00 42441 UNLEADED FUEL 2,244.00 104.79 2,222.34 0.00 21.66 99.03 42500 RENTS & LEASES 3,800.00 0.00 0.00 0.00 3,800.00 0.00 42600 MOTOR POOL RENTAL 98,841.00 0.00 98,841.00 0.00 0.00 100.00 42605 RETAINED VEHICLE EXPENSE 11,765.00 0.00 11,765.00 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 40,714.00 0.00 0.00 37,813.96 2,900.04 92.87 42700 OTHER EQUIPMENT RENTAL 34,500.00 18,756.78 90,722.19 51,074.72 (107,296.91) 411.00 42811 MAINTENANCE & OPERATING 309,060.00 0.00 13,838.77 0.00 295,221.23 4.47 42813 MTCE & REPAIR - EQUIP & FAC 509,781.55 63,420.92 638,774.55 75,280.87 (204,273.87) 140.07 42815 SCADA MAINTENANCE 4,000.00 0.00 0.00 0.00 4,000.00 0.00 42816 MOWING/LANDSCAPE CONTRACTS 1,613,763.93 320,860.44 1,884,431.93 195,269.59 (465,937.59) 128.87 42819 GRAFFITI REMOVAL 160,135.00 124,217.50 268,908.98 31,555.00 (140,328.98) 187.63 42821 TREE MAINTENANCE 995,621.65 49,603.50 900,822.08 221.70 94,577.87 90.50 42900 PROF. & CONT. SVCS 546,092.71 26,485.18 297,255.27 33,102.81 215,734.63 60.49 42910 REFUSE DISPOSAL 0.00 148.12 1,477.33 0.00 (1,477.33) 0.00 43100 MEMBERSHIP & DUES 0.00 0.00 70.00 0.00 (70.00) 0.00 43200 CONFERENCE, TRAINING & TRAVEL 2,500.00 0.00 2,571.00 0.00 (71.00) 102.84 43301 CAPITAL IMPROVEMENTS 0.00 1,695.00 1,695.00 0.00 (1,695.00) 0.00 43715 REGULATORY PERMIT & USE FEES 1,856.00 406.00 1,960.00 0.00 (104.00) 105.60 43716 JOB REQ CERTIFICATES & LICENSE 1,200.00 0.00 2,335.00 0.00 (1,135.00) 194.58 43722 PREVENTION & MAINTENANCE 231,171.27 22,737.40 188,624.70 32,075.30 10,471.27 95.47 TOTAL FOR SERVICES-SUPPLIES 4,885,947.81 661,010.38 4,881,354.64 568,079.33 (563,486.16) 111.53
CAPITAL OUTLAY
45100 LICENSED VEHICLES 25,775.00 0.00 0.00 0.00 25,775.00 0.00 TOTAL FOR CAPITAL OUTLAY 25,775.00 0.00 0.00 0.00 25,775.00 0.00 TOTAL FOR PARK MAINTENANCE/LMD 6,606,150.55 779,628.80 6,273,449.18 568,079.33 (235,377.96) 103.56 FUN 110 407,637,807.40 10,418,047.34 376,716,024.01 8,013,359.70 22,908,423.69 94.38 JULIEK Page: 24 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
120 MEASURE X FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 469.20 2,080.12 0.00 (2,080.12) 0.00 41300 OVERTIME 0.00 12,816.82 14,294.87 0.00 (14,294.87) 0.00 41320 COMP TIME 0.00 821.12 821.12 0.00 (821.12) 0.00
41600 LONGEVITY 0.00 7.21 32.00 0.00 (32.00) 0.00
41910 PERS-NORMAL 0.00 54.27 240.60 0.00 (240.60) 0.00
41920 MEDICARE 0.00 391.23 483.30 0.00 (483.30) 0.00
41931 WORKERS COMP 0.00 9.38 41.59 0.00 (41.59) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 6.74 8.29 0.00 (8.29) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 14,575.97 18,001.89 0.00 (18,001.89) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 9,259,001.00 0.00 0.00 0.00 9,259,001.00 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 16,956.97 26,504.19 0.00 (26,504.19) 0.00 42028 SCBA BREATHING APPARATUS 0.00 0.00 72,187.65 516,629.42 (588,817.07) 0.00 42055 COMPUTER EQUIPMENT & 0.00 1,057.21 1,174.64 0.00 (1,174.64) 0.00 42300 WIRELESS COMMUNICATION 0.00 1,218.41 1,218.41 0.00 (1,218.41) 0.00 42305 PBLC SFTY RADIO COMMUNICATION 0.00 583.43 328,755.08 322.00 (329,077.08) 0.00 42320 POSTAGE & SHIPPING 0.00 341.33 341.33 0.00 (341.33) 0.00 42810 BUILDING MAINTENANCE 0.00 0.00 1,080.00 0.00 (1,080.00) 0.00 42811 MAINTENANCE & OPERATING 0.00 280.00 280.00 0.00 (280.00) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 0.00 49,103.86 2,796.14 (51,900.00) 0.00 42900 PROF. & CONT. SVCS 0.00 15,298.31 74,078.63 141,497.11 (215,575.74) 0.00 TOTAL FOR SERVICES-SUPPLIES 9,259,001.00 35,735.66 554,723.79 661,244.67 8,043,032.54 13.13
CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 0.00 1,606,904.32 (1,606,904.32) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 0.00 1,606,904.32 (1,606,904.32) 0.00 TOTAL FOR NOT APPLICABLE 9,259,001.00 50,311.63 572,725.68 2,268,148.99 6,418,126.33 30.68 13 DEBT SERVICE
SERVICES-SUPPLIES
44001 DS PRINCIPAL 2021 POBS 126,537.00 0.00 126,537.00 0.00 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 126,537.00 0.00 126,537.00 0.00 0.00 100.00 TOTAL FOR DEBT SERVICE 126,537.00 0.00 126,537.00 0.00 0.00 100.00 FUN 120 9,385,538.00 50,311.63 699,262.68 2,268,148.99 6,418,126.33 31.61 JULIEK Page: 25 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
232 CIVIC CENTER
00 NOT APPLICABLE
SALARIES-BENEFITS
41300 OVERTIME 0.00 0.00 222.41 0.00 (222.41) 0.00
41920 MEDICARE 0.00 0.00 6.52 0.00 (6.52) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.00 0.11 0.00 (0.11) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 0.00 229.04 0.00 (229.04) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 213,730.63 0.00 0.00 0.00 213,730.63 0.00 43301 CAPITAL IMPROVEMENTS 41,240.00 0.00 0.00 41,240.00 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 254,970.63 0.00 0.00 41,240.00 213,730.63 16.17 TOTAL FOR NOT APPLICABLE 254,970.63 0.00 229.04 41,240.00 213,501.59 16.26 41 MAINTENANCE SERVICES
SERVICES-SUPPLIES
42033 CONSTRUCTION MATERIALS 3,900.00 110.84 2,993.17 3,158.98 (2,252.15) 157.74 42410 ELECTRIC UTILITY 60,000.00 4,375.89 50,704.39 0.00 9,295.61 84.50 42420 NATURAL GAS UTILITY 1,040.00 15.78 1,374.81 0.00 (334.81) 132.19 42430 WATER UTILITY 22,680.00 2,238.32 17,537.46 0.00 5,142.54 77.32 42813 MTCE & REPAIR - EQUIP & FAC 40,340.99 0.00 8,334.80 14,521.20 17,484.99 56.65 42822 VANDALISM 1,000.00 0.00 2,732.29 1,189.89 (2,922.18) 392.21 42900 PROF. & CONT. SVCS 35,752.00 2,730.71 31,446.31 0.00 4,305.69 87.95 43715 REGULATORY PERMIT & USE FEES 230.00 0.00 164.83 0.00 65.17 71.66 43722 PREVENTION & MAINTENANCE 13,191.70 190.00 5,313.38 185.17 7,693.15 41.68 TOTAL FOR SERVICES-SUPPLIES 178,134.69 9,661.54 120,601.44 19,055.24 38,478.01 78.39 TOTAL FOR MAINTENANCE SERVICES 178,134.69 9,661.54 120,601.44 19,055.24 38,478.01 78.39 FUN 232 433,105.32 9,661.54 120,830.48 60,295.24 251,979.60 41.82 JULIEK Page: 26 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
GRAND TOTAL 417,456,450.72 10,478,020.51 377,536,117.17 10,341,803.93 29,578,529.62 92.91 JULIEK Page: 27 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:46:24
User:
Report: