City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SOLID WASTE UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6416303 5217 OTHER SUPP .00 1,000.00 1,000.00 858.96 1,500.00 1,500.00 50.0% TOTAL SHARPS PROGRAM .00 2,000.00 2,000.00 858.96 2,000.00 2,000.00 .0% 6416311 USED OIL BLOCK GRANT
6416311 5217 OTHER SUPP .00 .00 .00 2,320.02 2,320.00 2,500.00 .0% 6416311 5253 CONTRC SVS .00 .00 .00 .00 8,560.00 9,770.00 .0% 6416311 5253 40100 CONTRC SVS 9,197.00 .00 .00 .00 .00 .00 .0% 6416311 5258 40101 OTHER SVS .00 .00 10,878.00 .00 .00 .00 .0% 6416311 5258 40102 OTHER SVS .00 .00 .00 .00 .00 12,270.00 .0% TOTAL USED OIL BLOCK GRANT 9,197.00 .00 10,878.00 2,320.02 10,880.00 24,540.00 125.6% 6416312 BEVERAGE RECYCLING GRANT
6416312 5112 SALARY-PT .00 950.00 950.00 .00 950.00 980.00 3.2% 6416312 5116 FRINGE BEN .00 10.00 10.00 .00 10.00 10.00 .0% 6416312 5217 OTHER SUPP .00 .00 .00 .00 2,000.00 2,000.00 .0% TOTAL BEVERAGE RECYCLING GRA .00 960.00 960.00 .00 2,960.00 2,990.00 211.5% 6416315 BEVERAGE RECY GRANT
6416315 5111 40051 SALARY-FT 13,602.76 .00 .00 .00 .00 .00 .0% 6416315 5217 40051 OTHER SUPP 3,399.09 .00 .00 .00 .00 .00 .0% 6416315 5258 40052 OTHER SVS .00 .00 19,621.00 .00 19,621.00 .00 .0% 6416315 5258 40053 OTHER SVS .00 .00 19,700.00 .00 19,700.00 .00 .0% TOTAL BEVERAGE RECY GRANT 17,001.85 .00 39,321.00 .00 39,321.00 .00 -100.0% 6419501 HHW CANOPY IMPROVEMENTS
6419501 5111 SALARY-FT 407.59 .00 .00 .00 .00 .00 .0% 6419501 5116 FRINGE BEN 47.15 .00 .00 .00 .00 .00 .0% 6419501 5117 RETIR CNTR 42.48 .00 .00 .00 .00 .00 .0% 6419501 5600 CONTR FA -497.22 .00 .00 .00 .00 .00 .0% TOTAL HHW CANOPY IMPROVEMENT .00 .00 .00 .00 .00 .00 .0% 6419502 DOWNTOWN TRASH ENCLOSURES
6419502 5111 SALARY-FT 250.59 .00 .00 3,349.47 .00 .00 .0% 6419502 5116 FRINGE BEN 49.72 .00 .00 743.27 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SOLID WASTE UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6419502 5117 RETIR CNTR 26.11 .00 .00 366.87 .00 .00 .0% 6419502 5258 OTHER SVS .00 119,510.00 119,510.00 11,580.00 12,240.00 107,270.00 -10.2% 6419502 5600 CONTR FA -326.42 .00 .00 .00 .00 .00 .0% TOTAL DOWNTOWN TRASH ENCLOSU .00 119,510.00 119,510.00 16,039.61 12,240.00 107,270.00 -10.2% TOTAL SOLID WASTE UTILITY 15,968,025.12 16,084,440.00 16,249,004.00 16,841,929.49 17,693,066.00 17,987,050.00 10.7%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SEWER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6456213 CUSTOMER SVC - FINANCE
6456213 5211 POSTAGE 22,500.33 27,000.00 27,000.00 27,000.00 23,000.00 37,000.00 37.0% 6456213 5216 OFFIC SUPP 1,606.85 2,600.00 2,600.00 2,600.00 1,700.00 3,800.00 46.2% 6456213 5218 UNIFRM EXP .00 3,850.00 3,850.00 149.66 370.00 1,500.00 -61.0% 6456213 5234 OTH EQ RNT 1,863.41 2,000.00 2,000.00 2,000.00 2,000.00 2,500.00 25.0% 6456213 5258 OTHER SVS 10,442.52 16,070.00 16,070.00 13,000.00 12,000.00 20,250.00 26.0% TOTAL CUSTOMER SVC - FINANCE 36,413.11 51,520.00 51,520.00 44,749.66 39,070.00 65,050.00 26.3% 6456401 LANDFILL SITE MAINTENANCE
6456401 5111 SALARY-FT 55,173.78 97,910.00 97,910.00 51,560.96 97,910.00 114,760.00 17.2% 6456401 5116 FRINGE BEN 17,819.53 26,660.00 26,660.00 12,471.96 26,660.00 31,380.00 17.7% 6456401 5117 RETIR CNTR 7,665.47 10,700.00 10,700.00 5,398.64 10,700.00 13,750.00 28.5% 6456401 5211 POSTAGE 266.20 300.00 300.00 198.30 300.00 300.00 .0% 6456401 5213 DUES&SUBSC 346.00 370.00 370.00 428.00 430.00 500.00 35.1% 6456401 5215 TRNG/CONF .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6456401 5216 OFFIC SUPP 44.35 250.00 250.00 .00 250.00 250.00 .0% 6456401 5217 OTHER SUPP 1,178.68 25,200.00 25,200.00 1,859.63 34,500.00 34,800.00 38.1% 6456401 5218 UNIFRM EXP 124.99 490.00 490.00 232.75 700.00 1,500.00 206.1% 6456401 5219 PERM/LC/FE 18,074.02 23,150.00 23,150.00 14,549.12 26,600.00 26,180.00 13.1% 6456401 5222 PRINTING 5.68 100.00 100.00 .00 50.00 50.00 -50.0% 6456401 5233 OTHR EQUIP 1,061.16 1,200.00 1,200.00 4,702.76 5,760.00 1,500.00 25.0% 6456401 5241 UTL-ELECTR 1,068.74 2,200.00 2,200.00 1,954.57 2,200.00 4,950.00 125.0% 6456401 5246 MAINT-EQP 1,329.99 650.00 650.00 421.28 450.00 1,000.00 53.8% 6456401 5252 PROF SVS 5,660.00 70,000.00 70,000.00 703.50 70,000.00 70,000.00 .0% 6456401 5258 OTHER SVS 59,949.20 95,000.00 95,000.00 99,993.83 108,500.00 131,500.00 38.4% 6456401 5530 MACH&EQUIP .00 .00 .00 6,190.92 .00 .00 .0% 6456401 5600 CONTR FA .00 .00 .00 -568,301.52 .00 .00 .0% 6456401 5701 INFO SYS 450.00 450.00 450.00 456.00 450.00 450.00 .0% 6456401 5702 FLT-MT&RP 560.00 90.00 90.00 96.00 90.00 .00 .0% TOTAL LANDFILL SITE MAINTENA 170,777.79 355,720.00 355,720.00 -367,083.30 386,550.00 433,870.00 22.0% 6456402 SEWER MAINTENANCE & OPERATIONS
6456402 5110 BUY BACKS .00 .00 .00 1,014.94 .00 2,800.00 .0% 6456402 5111 SALARY-FT 567,366.19 791,690.00 781,719.00 509,300.60 781,719.00 867,920.00 11.0% 6456402 5112 SALARY-PT 1,684.82 4,410.00 4,410.00 6,632.00 4,410.00 4,550.00 3.2% 6456402 5113 OVERTIME 8,865.24 12,480.00 12,480.00 12,357.20 17,080.00 17,080.00 36.9% 6456402 5116 FRINGE BEN 114,759.90 215,250.00 212,178.00 116,396.20 212,178.00 250,280.00 18.0% 6456402 5117 RETIR CNTR 55,442.49 80,880.00 79,594.00 48,858.38 79,594.00 94,890.00 19.2%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SEWER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6456402 5211 POSTAGE 5,155.86 33,500.00 33,500.00 6,000.00 33,500.00 14,470.00 -56.8% 6456402 5212 ADVERTISNG 158.89 250.00 250.00 254.62 300.00 300.00 20.0% 6456402 5213 DUES&SUBSC 865.00 2,820.00 2,820.00 6,083.50 4,990.00 5,100.00 80.9% 6456402 5215 TRNG/CONF 4,322.45 4,000.00 4,000.00 1,214.00 13,800.00 13,850.00 246.3% 6456402 5216 OFFIC SUPP .00 2,000.00 2,000.00 .00 2,000.00 500.00 -75.0% 6456402 5217 OTHER SUPP 45,341.90 80,630.00 80,630.00 45,496.31 80,380.00 101,400.00 25.8% 6456402 5218 UNIFRM EXP 13,279.45 16,370.00 16,370.00 13,821.08 19,900.00 20,800.00 27.1% 6456402 5219 PERM/LC/FE 49.00 .00 .00 .00 14,290.00 14,290.00 .0% 6456402 5220 FUEL USAGE 39,567.72 35,000.00 35,000.00 23,722.98 35,000.00 88,000.00 151.4% 6456402 5222 PRNT/MAIL .00 .00 .00 42.03 .00 .00 .0% 6456402 5226 TEAM BLDG .00 .00 .00 .00 .00 1,300.00 .0% 6456402 5231 FURN&OFFC .00 .00 .00 .00 .00 1,750.00 .0% 6456402 5233 OTHR EQUIP 9,814.41 4,380.00 4,380.00 7,409.00 9,380.00 12,500.00 185.4% 6456402 5234 OTH EQ RNT .00 3,500.00 3,500.00 .00 3,500.00 3,500.00 .0% 6456402 5243 UTL-TELEPH 120.37 .00 .00 110.02 .00 .00 .0% 6456402 5244 UTL-WATER .00 70,000.00 .00 .00 70,000.00 70,000.00 .0% 6456402 5246 MAINT-EQP 2,686.17 5,000.00 5,000.00 10,044.00 5,000.00 26,000.00 420.0% 6456402 5251 LEGAL SVS 3,761.24 .00 .00 53,150.35 48,000.00 60,000.00 .0% 6456402 5252 PROF SVS 15,816.23 4,230.00 7,045.00 4,893.91 21,080.00 24,340.00 245.5% 6456402 5253 CONTRC SVS 26,153.12 51,250.00 65,579.00 32,024.58 45,000.00 48,300.00 -26.3% 6456402 5254 DATA P SVS 3,525.79 3,810.00 3,810.00 -338.70 .00 .00 .0% 6456402 5255 BANKNG SVS 10,691.94 3,980.00 3,980.00 .00 .00 .00 .0% 6456402 5257 SWR DSP SV 57,316.67 50,000.00 50,000.00 .00 50,000.00 65,000.00 30.0% 6456402 5258 OTHER SVS 117,755.51 250,000.00 250,000.00 131,092.50 198,680.00 228,680.00 -8.5% 6456402 5287 DEPR-PIPE 498,822.71 .00 .00 .00 .00 .00 .0% 6456402 5289 DEPR-TRTMT 69,784.24 .00 .00 .00 .00 .00 .0% 6456402 5324 OPEB 40,710.00 .00 .00 .00 .00 .00 .0% 6456402 5325 PEN EXP -544,289.29 .00 .00 .00 .00 .00 .0% 6456402 5529 BLD IMP .00 .00 .00 .00 .00 25,000.00 .0% 6456402 5530 MACH&EQUIP .00 150,000.00 150,000.00 .00 150,000.00 110,000.00 -26.7% 6456402 5531 VEHICLES 50,646.94 900,500.00 1,000,500.00 568,301.52 900,500.00 .00 .0% 6456402 5600 CONTR FA -50,646.94 .00 .00 -6,190.92 .00 .00 .0% 6456402 5701 INFO SYS 115,700.00 114,610.00 114,610.00 114,612.00 114,610.00 91,550.00 -20.1% 6456402 5702 FLT-MT&RP 58,140.00 76,710.00 76,710.00 76,716.00 76,710.00 127,680.00 66.4% 6456402 5704 BDG MT ALC 43,230.00 21,590.00 21,590.00 21,588.00 21,590.00 18,140.00 -16.0% 6456402 5705 SF LIAB 279,270.00 282,640.00 282,640.00 282,636.00 282,640.00 270,130.00 -4.4% 6456402 5706 OPB&BN ALC 63,150.00 41,520.00 41,520.00 41,520.00 41,520.00 40,340.00 -2.8% 6456402 5707 PERSUALALC 335,470.00 .00 .00 .00 .00 .00 .0% TOTAL SEWER MAINTENANCE & OP 2,064,488.02 3,313,000.00 3,345,815.00 2,128,762.10 3,337,351.00 2,720,440.00 -18.7% 6456403 SEWER - RESIDENTIAL
6456403 5111 SALARY-FT 113,069.24 171,350.00 171,350.00 107,868.68 171,350.00 191,460.00 11.7%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SEWER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6456403 5112 SALARY-PT 2,434.37 3,400.00 3,400.00 .00 3,400.00 3,660.00 7.6% 6456403 5116 FRINGE BEN 26,452.61 46,500.00 46,500.00 26,371.13 46,500.00 51,430.00 10.6% 6456403 5117 RETIR CNTR 10,871.49 18,730.00 18,730.00 11,411.06 18,730.00 23,030.00 23.0% 6456403 5211 POSTAGE .00 100.00 100.00 .00 100.00 250.00 150.0% 6456403 5215 TRNG/CONF .00 1,200.00 1,200.00 175.00 1,200.00 1,200.00 .0% 6456403 5216 OFFIC SUPP 12.07 500.00 500.00 606.52 500.00 500.00 .0% 6456403 5217 OTHER SUPP .00 1,500.00 1,500.00 .00 1,500.00 1,500.00 .0% 6456403 5219 PERM/LC/FE 19,188.00 22,190.00 22,190.00 18,512.00 19,220.00 23,500.00 5.9% 6456403 5220 FUEL USAGE 1,561.42 3,500.00 3,500.00 2,174.01 3,500.00 3,500.00 .0% 6456403 5222 PRINTING 63.57 .00 .00 .00 .00 .00 .0% 6456403 5257 SWR DSP SV 6,939,066.79 7,469,200.00 7,469,200.00 7,462,920.77 7,337,300.00 7,997,560.00 7.1% 6456403 5258 OTHER SVS 72.50 30,150.00 30,150.00 30.00 30,150.00 30,150.00 .0% 6456403 5280 DEPR-LND I 987.00 .00 .00 .00 .00 .00 .0% 6456403 5283 DEPR-M&EQP 30,945.80 .00 .00 .00 .00 .00 .0% 6456403 5284 DEPR-VEH 214,768.03 .00 .00 .00 .00 .00 .0% 6456403 5291 BAD DB EXP 28,255.57 .00 .00 .00 .00 .00 .0% 6456403 5292 ADM SV EXP 559,710.00 546,540.00 546,540.00 559,710.00 559,710.00 559,710.00 2.4% 6456403 5701 INFO SYS 2,380.00 2,380.00 2,380.00 2,376.00 2,380.00 1,200.00 -49.6% 6456403 5702 FLT-MT&RP 9,250.00 7,350.00 7,350.00 7,356.00 7,350.00 440.00 -94.0% TOTAL SEWER - RESIDENTIAL 7,959,088.46 8,324,590.00 8,324,590.00 8,199,511.17 8,202,890.00 8,889,090.00 6.8% 6456404 SEWER - NON RESIDENTIAL
6456404 5111 SALARY-FT 66,630.62 99,210.00 99,210.00 53,274.83 99,210.00 109,510.00 10.4% 6456404 5116 FRINGE BEN 13,912.01 26,400.00 26,400.00 12,382.68 26,400.00 29,190.00 10.6% 6456404 5117 RETIR CNTR 6,067.79 10,850.00 10,850.00 5,670.72 10,850.00 13,180.00 21.5% 6456404 5211 POSTAGE .00 100.00 100.00 .00 100.00 100.00 .0% 6456404 5213 DUES&SUBSC 763.00 1,600.00 1,600.00 712.00 1,600.00 2,000.00 25.0% 6456404 5215 TRNG/CONF 162.53 2,500.00 2,500.00 199.25 2,500.00 2,500.00 .0% 6456404 5216 OFFIC SUPP .00 100.00 100.00 .00 100.00 100.00 .0% 6456404 5217 OTHER SUPP 12.73 2,000.00 2,000.00 160.12 2,000.00 2,000.00 .0% 6456404 5218 UNIFRM EXP 125.00 400.00 400.00 .00 575.00 580.00 45.0% 6456404 5219 PERM/LC/FE 101.00 .00 .00 .00 .00 .00 .0% 6456404 5220 FUEL USAGE 2,302.11 4,500.00 4,500.00 .00 .00 .00 .0% 6456404 5232 COMP EQUIP .00 2,200.00 2,200.00 .00 1,900.00 1,950.00 -11.4% 6456404 5251 LEGAL SVS .00 50,000.00 50,000.00 .00 200,000.00 200,000.00 300.0% 6456404 5257 SWR DSP SV .00 30,000.00 .00 .00 30,000.00 30,000.00 .0% 6456404 5258 OTHER SVS 420.59 260,000.00 260,000.00 .00 260,000.00 260,000.00 .0% 6456404 5701 INFO SYS 2,380.00 2,380.00 2,380.00 2,376.00 2,380.00 3,890.00 63.4% 6456404 5702 FLT-MT&RP 5,460.00 6,910.00 6,910.00 6,912.00 6,910.00 3,310.00 -52.1% TOTAL SEWER - NON RESIDENTIA 98,337.38 499,150.00 469,150.00 81,687.60 644,525.00 658,310.00 40.3% 6457500 CAPITAL PROJECTS
6457500 5111 94003 SALARY-FT .00 .00 .00 157.13 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SEWER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6457500 5111 94005 SALARY-FT .00 .00 .00 366.63 .00 .00 .0% 6457500 5111 94006 SALARY-FT .00 .00 .00 157.13 .00 .00 .0% 6457500 5116 94003 FRINGE BEN .00 .00 .00 29.91 .00 .00 .0% 6457500 5116 94005 FRINGE BEN .00 .00 .00 72.78 .00 .00 .0% 6457500 5116 94006 FRINGE BEN .00 .00 .00 32.01 .00 .00 .0% 6457500 5117 94003 RETIR CNTR .00 .00 .00 17.22 .00 .00 .0% 6457500 5117 94005 RETIR CNTR .00 .00 .00 40.06 .00 .00 .0% 6457500 5117 94006 RETIR CNTR .00 .00 .00 17.14 .00 .00 .0% 6457500 5252 94003 PROF SVS .00 .00 543,696.00 543,696.00 .00 .00 .0% 6457500 5258 OTHER SVS .00 .00 .00 .00 .00 1,000,000.00 .0% 6457500 5258 94001 OTHER SVS 138,500.00 274,700.00 274,700.00 .00 .00 274,700.00 .0% 6457500 5258 94002 OTHER SVS .00 150,000.00 150,000.00 .00 .00 150,000.00 .0% 6457500 5258 94003 OTHER SVS .00 300,000.00 .00 .00 210.00 543,490.00 .0% 6457500 5258 94004 OTHER SVS .00 200,000.00 .00 .00 .00 200,000.00 .0% 6457500 5258 94005 OTHER SVS .00 400,000.00 400,000.00 .00 480.00 399,520.00 -.1% 6457500 5258 94006 OTHER SVS .00 500,000.00 500,000.00 .00 210.00 499,790.00 .0% 6457500 5258 94007 OTHER SVS .00 150,000.00 106,304.00 .00 .00 200,000.00 88.1% 6457500 5600 94001 CONTR FA -138,500.00 .00 .00 .00 .00 .00 .0% TOTAL CAPITAL PROJECTS .00 1,974,700.00 1,974,700.00 544,586.01 900.00 3,267,500.00 65.5% 6459301 UPLND LNDFLL PST-CLSR PLN
6459301 5111 SALARY-FT 1,823.14 .00 .00 260.48 .00 .00 .0% 6459301 5116 FRINGE BEN 350.39 .00 .00 53.49 .00 .00 .0% 6459301 5117 RETIR CNTR 190.05 .00 .00 28.38 .00 .00 .0% 6459301 5258 OTHER SVS .00 98,180.00 97,636.00 18,638.15 18,980.00 78,660.00 -19.4% 6459301 5600 CONTR FA -2,363.58 .00 .00 .00 .00 .00 .0% TOTAL UPLND LNDFLL PST-CLSR .00 98,180.00 97,636.00 18,980.50 18,980.00 78,660.00 -19.4% 6459324 LDFILL FLARE SUPP GAS LINE
6459324 5111 SALARY-FT 13,770.25 .00 .00 4,190.30 .00 .00 .0% 6459324 5116 FRINGE BEN 3,052.25 .00 .00 963.64 .00 .00 .0% 6459324 5117 RETIR CNTR 1,429.32 .00 .00 459.26 .00 .00 .0% 6459324 5212 ADVERTISNG 4,043.20 .00 .00 .00 .00 .00 .0% 6459324 5222 PRINTING 1,497.54 .00 .00 .00 .00 .00 .0% 6459324 5258 OTHER SVS 297,232.45 374,460.00 75,329.00 65,163.50 70,780.00 4,550.00 -94.0% 6459324 5600 CONTR FA -321,025.01 .00 .00 .00 .00 .00 .0% TOTAL LDFILL FLARE SUPP GAS .00 374,460.00 75,329.00 70,776.70 70,780.00 4,550.00 -94.0% 6459330 RICHLAND ST TRUNK MAIN REPAIR
6459330 5258 OTHER SVS .00 75,000.00 75,000.00 .00 .00 100,000.00 33.3%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SEWER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL RICHLAND ST TRUNK MAIN .00 75,000.00 75,000.00 .00 .00 100,000.00 33.3% TOTAL SEWER UTILITY 10,329,104.76 15,066,320.00 14,769,460.00 10,721,970.44 12,701,046.00 16,217,470.00 9.8%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SELF-FUNDED LIABILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7511601 HUMAN RESOURCES
7511601 5324 OPEB 48,952.00 .00 .00 .00 .00 .00 .0% 7511601 5325 PEN EXP -125,832.35 .00 .00 .00 .00 .00 .0% TOTAL HUMAN RESOURCES -76,880.35 .00 .00 .00 .00 .00 .0% 7511611 WORKERS COMPENSATION
7511611 5111 SALARY-FT 51,710.75 52,410.00 52,410.00 44,923.68 52,410.00 78,060.00 48.9% 7511611 5116 FRINGE BEN 9,242.58 10,200.00 10,200.00 9,226.77 10,200.00 19,560.00 91.8% 7511611 5117 RETIR CNTR 4,541.57 5,690.00 5,690.00 4,187.02 5,690.00 9,350.00 64.3% 7511611 5213 DUES&SUBSC .00 150.00 150.00 .00 .00 150.00 .0% 7511611 5215 TRNG/CONF .00 5,400.00 5,400.00 .00 .00 5,400.00 .0% 7511611 5216 OFFIC SUPP .00 500.00 500.00 .00 .00 500.00 .0% 7511611 5219 PERM/LC/FE 91,758.48 91,800.00 91,800.00 60,934.65 61,000.00 65,000.00 -29.2% 7511611 5258 OTHER SVS 139,474.00 149,450.00 149,450.00 149,444.00 149,450.00 152,500.00 2.0% 7511611 5270 IBNR CLAIM 158,443.70 .00 .00 .00 .00 .00 .0% 7511611 5271 INS PREM 233,834.00 269,000.00 269,000.00 250,128.00 246,730.00 283,320.00 5.3% 7511611 5272 CLAIMS EXP 923,727.10 1,466,040.00 1,466,040.00 976,484.78 1,466,040.00 1,000,000.00 -31.8% 7511611 5299 PY EXP -6,440.00 .00 .00 -2,317.00 .00 .00 .0% 7511611 5706 OPB&BN ALC 1,920.00 1,670.00 1,670.00 1,668.00 1,670.00 2,250.00 34.7% 7511611 5707 PERSUALALC 12,720.00 17,350.00 17,350.00 17,352.00 17,350.00 21,240.00 22.4% TOTAL WORKERS COMPENSATION 1,620,932.18 2,069,660.00 2,069,660.00 1,512,031.90 2,010,540.00 1,637,330.00 -20.9% 7511612 UNEMPLOYMENT
7511612 5111 SALARY-FT 10,269.32 10,640.00 10,640.00 9,023.32 10,640.00 4,540.00 -57.3% 7511612 5116 FRINGE BEN 2,230.67 2,480.00 2,480.00 2,219.69 2,480.00 1,310.00 -47.2% 7511612 5117 RETIR CNTR 968.35 1,160.00 1,160.00 891.71 1,160.00 550.00 -52.6% 7511612 5258 OTHER SVS 1,756.75 2,000.00 2,000.00 1,822.00 1,830.00 1,850.00 -7.5% 7511612 5272 CLAIMS EXP 36,242.25 45,000.00 45,000.00 1,738.00 45,000.00 45,000.00 .0% 7511612 5290 LATE CHARG 148.24 .00 .00 .00 .00 .00 .0% 7511612 5706 OPB&BN ALC 650.00 370.00 370.00 372.00 370.00 150.00 -59.5% 7511612 5707 PERSUALALC 3,010.00 3,520.00 3,520.00 3,516.00 3,520.00 1,280.00 -63.6% TOTAL UNEMPLOYMENT 55,275.58 65,170.00 65,170.00 19,582.72 65,000.00 54,680.00 -16.1% 7511613 LONG-TERM DISABILITY
7511613 5111 SALARY-FT 6,162.97 6,430.00 6,430.00 5,478.39 6,430.00 .00 .0% 7511613 5116 FRINGE BEN 1,640.05 1,330.00 1,330.00 1,610.94 1,330.00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SELF-FUNDED LIABILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7511613 5117 RETIR CNTR 556.38 700.00 700.00 510.70 700.00 .00 .0% 7511613 5118 EMPL LTD 30,292.69 46,000.00 46,000.00 28,372.73 46,000.00 46,000.00 .0% 7511613 5271 INS PREM 33,568.51 34,000.00 34,000.00 31,107.97 34,000.00 34,000.00 .0% 7511613 5706 OPB&BN ALC 470.00 220.00 220.00 216.00 220.00 .00 .0% 7511613 5707 PERSUALALC 1,670.00 2,170.00 2,170.00 2,172.00 2,170.00 .00 .0% TOTAL LONG-TERM DISABILITY 74,360.60 90,850.00 90,850.00 69,468.73 90,850.00 80,000.00 -11.9% 7511614 LIABILITY
7511614 5111 SALARY-FT 61,058.47 86,140.00 86,140.00 69,050.32 86,140.00 82,570.00 -4.1% 7511614 5116 FRINGE BEN 11,045.82 19,810.00 19,810.00 15,099.50 19,810.00 20,280.00 2.4% 7511614 5117 RETIR CNTR 5,502.98 9,370.00 9,370.00 6,740.57 9,370.00 9,900.00 5.7% 7511614 5251 LEGAL SVS 170,739.61 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 .0% 7511614 5258 OTHER SVS 48,528.50 47,650.00 47,650.00 47,616.00 47,650.00 48,500.00 1.8% 7511614 5270 IBNR CLAIM -74,164.02 .00 .00 .00 .00 .00 .0% 7511614 5271 INS PREM 1,390,617.44 1,599,220.00 1,599,220.00 1,853,772.75 1,829,630.00 2,104,070.00 31.6% 7511614 5272 CLAIMS EXP 1,250,014.36 1,000,000.00 1,000,000.00 343,264.85 350,000.00 1,000,000.00 .0% 7511614 5410 ICRMA ASSM 87,686.73 87,700.00 87,700.00 87,686.73 87,700.00 87,700.00 .0% 7511614 5706 OPB&BN ALC 3,350.00 2,880.00 2,880.00 2,880.00 2,880.00 2,370.00 -17.7% 7511614 5707 PERSUALALC 22,100.00 28,470.00 28,470.00 28,476.00 28,470.00 22,010.00 -22.7% TOTAL LIABILITY 2,976,479.89 2,981,240.00 2,981,240.00 2,554,586.72 2,561,650.00 3,477,400.00 16.6% 7511615 LOSS PREVENTION
7511615 5111 SALARY-FT 31,884.41 34,700.00 34,700.00 36,873.90 34,700.00 3,480.00 -90.0% 7511615 5116 FRINGE BEN 6,118.27 9,220.00 9,220.00 10,628.34 9,220.00 1,210.00 -86.9% 7511615 5117 RETIR CNTR 3,308.61 3,790.00 3,790.00 3,454.13 3,790.00 420.00 -88.9% 7511615 5217 OTHER SUPP 74.82 .00 .00 .00 .00 .00 .0% 7511615 5233 OTHR EQUIP 118.51 .00 .00 .00 .00 .00 .0% 7511615 5258 OTHER SVS 10,331.05 15,000.00 15,000.00 14,628.76 15,000.00 18,600.00 24.0% 7511615 5706 OPB&BN ALC 1,650.00 1,210.00 1,210.00 1,212.00 1,210.00 90.00 -92.6% 7511615 5707 PERSUALALC 9,380.00 11,390.00 11,390.00 11,388.00 11,390.00 1,020.00 -91.0% TOTAL LOSS PREVENTION 62,865.67 75,310.00 75,310.00 78,185.13 75,310.00 24,820.00 -67.0% TOTAL SELF-FUNDED LIABILITY 4,713,033.57 5,282,230.00 5,282,230.00 4,233,855.20 4,803,350.00 5,274,230.00 -.2%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7521301 ACCOUNTING SERVICES
7521301 5227 PART/REP 22.18 .00 .00 82.50 .00 .00 .0% TOTAL ACCOUNTING SERVICES 22.18 .00 .00 82.50 .00 .00 .0% 7521302 MAIL/PRINTING SERVICES
7521302 5227 PART/REP 7.98 .00 .00 216.40 .00 .00 .0% 7521302 5531 VEHICLES .00 .00 500.00 250.00 500.00 .00 .0% TOTAL MAIL/PRINTING SERVICES 7.98 .00 500.00 466.40 500.00 .00 -100.0% 7521401 INFORMATION SYSTEMS
7521401 5227 PART/REP 525.51 .00 .00 117.49 .00 .00 .0% TOTAL INFORMATION SYSTEMS 525.51 .00 .00 117.49 .00 .00 .0% 7522201 BUILDING AND SAFETY
7522201 5227 PART/REP 327.81 .00 .00 1,273.47 .00 .00 .0% TOTAL BUILDING AND SAFETY 327.81 .00 .00 1,273.47 .00 .00 .0% 7522202 WEED ABATEMENT
7522202 5227 PART/REP 17.09 .00 .00 .00 .00 .00 .0% TOTAL WEED ABATEMENT 17.09 .00 .00 .00 .00 .00 .0% 7522931 HOUSING ADMINISTRATION
7522931 5531 VEHICLES 50,415.26 .00 .00 .00 .00 .00 .0% TOTAL HOUSING ADMINISTRATION 50,415.26 .00 .00 .00 .00 .00 .0% 7523201 POLICE ADMINISTRATION
7523201 5227 PART/REP 1,960.50 .00 .00 1,752.55 .00 .00 .0% 7523201 5531 VEHICLES 34,705.16 59,600.00 462,063.00 299,346.80 462,063.00 .00 -100.0% TOTAL POLICE ADMINISTRATION 36,665.66 59,600.00 462,063.00 301,099.35 462,063.00 .00 -100.0% 7523202 POLICE INVESTIGATIONS
7523202 5227 PART/REP 6,905.95 .00 .00 5,957.67 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7523202 5531 VEHICLES 34,880.80 .00 45,088.00 14,000.00 45,088.00 .00 .0% TOTAL POLICE INVESTIGATIONS 41,786.75 .00 45,088.00 19,957.67 45,088.00 .00 -100.0% 7523205 ANIMAL SERVICES
7523205 5227 PART/REP 653.82 .00 .00 390.18 .00 .00 .0% 7523205 5531 VEHICLES 72,796.63 .00 70,000.00 .00 .00 84,100.00 20.1% TOTAL ANIMAL SERVICES 73,450.45 .00 70,000.00 390.18 .00 84,100.00 20.1% 7523211 POLICE PATROL
7523211 5227 VEH PARTS 36,781.54 .00 .00 39,558.29 .00 .00 .0% 7523211 5233 OTHR EQUIP 773.18 .00 .00 .00 .00 .00 .0% 7523211 5531 VEHICLES 4,821.30 .00 376,578.00 376,033.60 296,578.00 485,100.00 28.8% TOTAL POLICE PATROL 42,376.02 .00 376,578.00 415,591.89 296,578.00 485,100.00 28.8% 7523233 CODE ENFORCEMENT
7523233 5227 PART/REP 157.35 .00 .00 525.47 .00 .00 .0% 7523233 5531 VEHICLES .00 .00 3,602.00 3,602.00 3,602.00 .00 .0% TOTAL CODE ENFORCEMENT 157.35 .00 3,602.00 4,127.47 3,602.00 .00 -100.0% 7524201 RECREATION ADMINISTRATION
7524201 5227 PART/REP 1,092.20 .00 .00 985.65 .00 .00 .0% TOTAL RECREATION ADMINISTRAT 1,092.20 .00 .00 985.65 .00 .00 .0% 7524204 RECREATION PARKS
7524204 5531 VEHICLES .00 70,000.00 70,000.00 68,398.96 70,000.00 .00 .0% TOTAL RECREATION PARKS .00 70,000.00 70,000.00 68,398.96 70,000.00 .00 -100.0% 7525201 PUBLIC WORKS ADMINISTRATION
7525201 5227 PART/REP 91.57 .00 .00 29.89 .00 .00 .0% 7525201 5245 MAINT-BLDG 74.11 .00 .00 .00 .00 .00 .0% TOTAL PUBLIC WORKS ADMINISTR 165.68 .00 .00 29.89 .00 .00 .0% 7525301 ENGINEERING ADMINISTRATION
7525301 5227 PART/REP 362.49 .00 .00 752.99 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7525301 5531 VEHICLES 94,417.77 .00 .00 .00 .00 .00 .0% TOTAL ENGINEERING ADMINISTRA 94,780.26 .00 .00 752.99 .00 .00 .0% 7525302 DEVELOPMENT/TRAFFIC ENGINRG
7525302 5227 PART/REP 158.87 .00 .00 80.26 .00 .00 .0% 7525302 5531 VEHICLES .00 .00 500.00 250.00 500.00 .00 .0% TOTAL DEVELOPMENT/TRAFFIC EN 158.87 .00 500.00 330.26 500.00 .00 -100.0% 7525401 STREET MAINTENANCE
7525401 5227 PART/REP 5,885.65 .00 .00 3,496.73 .00 .00 .0% 7525401 5283 DEPR-M&EQP 44,656.35 .00 .00 .00 .00 .00 .0% 7525401 5531 VEHICLES .00 .00 177,250.00 171,094.39 177,250.00 81,000.00 -54.3% TOTAL STREET MAINTENANCE 50,542.00 .00 177,250.00 174,591.12 177,250.00 81,000.00 -54.3% 7525403 SIDEWALK MAINTENANCE
7525403 5227 PART/REP 358.61 .00 .00 285.66 .00 .00 .0% TOTAL SIDEWALK MAINTENANCE 358.61 .00 .00 285.66 .00 .00 .0% 7525404 STREET LIGHTING
7525404 5227 PART/REP 147.45 .00 .00 288.28 .00 .00 .0% TOTAL STREET LIGHTING 147.45 .00 .00 288.28 .00 .00 .0% 7525405 TRAFFIC CONTROL
7525405 5227 PART/REP 5.34 .00 .00 4.70 .00 .00 .0% TOTAL TRAFFIC CONTROL 5.34 .00 .00 4.70 .00 .00 .0% 7525407 WEED ABATEMENT
7525407 5227 PART/REP 25.50 .00 .00 68.01 .00 .00 .0% 7525407 5530 MACH&EQUIP .00 .00 .00 52,241.74 .00 .00 .0% 7525407 5531 VEHICLES .00 .00 320,250.00 .00 320,250.00 .00 .0% TOTAL WEED ABATEMENT 25.50 .00 320,250.00 52,309.75 320,250.00 .00 -100.0% 7525409 STREET TREE MAINTENANCE
7525409 5227 PART/REP .00 .00 .00 6.89 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL STREET TREE MAINTENANC .00 .00 .00 6.89 .00 .00 .0% 7525410 PARKWAY MAINTENANCE
7525410 5227 PART/REP 155.81 .00 .00 792.96 .00 .00 .0% TOTAL PARKWAY MAINTENANCE 155.81 .00 .00 792.96 .00 .00 .0% 7525414 FLEET MAINTENANCE
7525414 5110 BUY BACKS .00 .00 .00 .00 .00 600.00 .0% 7525414 5111 SALARY-FT 143,422.77 225,400.00 225,400.00 134,099.04 225,400.00 240,020.00 6.5% 7525414 5113 OVERTIME 4,339.88 3,100.00 3,100.00 2,536.44 3,100.00 3,300.00 6.5% 7525414 5116 FRINGE BEN 33,009.22 66,730.00 66,730.00 22,173.88 66,730.00 71,750.00 7.5% 7525414 5117 RETIR CNTR 14,752.62 24,260.00 24,260.00 12,986.88 24,260.00 28,250.00 16.4% 7525414 5211 POSTAGE .00 50.00 200.00 187.82 200.00 100.00 -50.0% 7525414 5213 DUES&SUBSC 1,616.25 .00 .00 .00 .00 .00 .0% 7525414 5215 TRNG/CONF 1,360.00 2,250.00 2,250.00 325.00 400.00 3,000.00 33.3% 7525414 5216 OFFIC SUPP 169.16 500.00 1,000.00 464.22 600.00 600.00 -40.0% 7525414 5217 OTHER SUPP 9,048.95 20,450.00 23,200.00 11,057.68 23,200.00 23,200.00 .0% 7525414 5218 UNIFRM EXP 2,619.89 3,070.00 3,070.00 3,488.96 4,800.00 4,100.00 33.6% 7525414 5219 PERM/LC/FE 5,552.28 6,650.00 6,650.00 8,561.38 6,650.00 6,650.00 .0% 7525414 5220 FUEL USAGE 4,465.96 4,500.00 5,500.00 6,545.01 9,500.00 9,500.00 72.7% 7525414 5222 PRNT/MAIL .00 100.00 100.00 .00 100.00 100.00 .0% 7525414 5227 VEH PARTS 177,532.47 184,450.00 194,950.00 188,003.23 184,450.00 295,700.00 51.7% 7525414 5227 40155 PART/REP 2,166.50 .00 .00 .00 .00 .00 .0% 7525414 5231 FURN&OFFC .00 750.00 750.00 .00 .00 750.00 .0% 7525414 5232 COMP EQUIP .00 1,250.00 1,250.00 .00 .00 .00 .0% 7525414 5233 OTHR EQUIP 25,317.58 2,000.00 10,000.00 7,767.55 10,000.00 10,000.00 .0% 7525414 5242 UTL-GAS 1,467.86 800.00 2,000.00 2,851.17 2,500.00 2,800.00 40.0% 7525414 5248 MAINT-OTHR 2,515.00 3,300.00 3,300.00 2,365.71 2,400.00 3,300.00 .0% 7525414 5253 CONTRC SVS 24,844.80 37,300.00 38,200.00 38,200.00 38,200.00 42,020.00 10.0% 7525414 5254 DUES&SUBSC 2,426.89 4,600.00 4,600.00 3,606.20 4,020.00 8,500.00 84.8% 7525414 5258 OTHER SVS 14,468.61 15,400.00 15,400.00 15,060.00 23,200.00 25,400.00 64.9% 7525414 5283 DEPR-M&EQP 88,881.98 .00 .00 .00 .00 .00 .0% 7525414 5290 LATE CHARG .00 .00 .00 214.30 .00 .00 .0% 7525414 5295 PUMP TAX 2,441.00 5,000.00 5,000.00 2,142.94 5,000.00 5,000.00 .0% 7525414 5324 OPEB -29,259.00 .00 .00 .00 .00 .00 .0% 7525414 5325 PEN EXP -15,067.31 .00 .00 .00 .00 .00 .0% 7525414 5530 MACH&EQUIP 900.00 .00 .00 .00 .00 .00 .0% 7525414 5531 VEHICLES .00 16,400.00 18,380.00 1,979.69 18,380.00 .00 -100.0% 7525414 5600 CONTR FA .00 .00 .00 -52,241.73 .00 .00 .0% 7525414 5701 INFO SYS 7,150.00 7,650.00 7,650.00 7,656.00 7,650.00 15,650.00 104.6%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7525414 5706 OPB&BN ALC 13,140.00 8,240.00 8,240.00 8,244.00 8,240.00 7,980.00 -3.2% 7525414 5707 PERSUALALC 66,960.00 73,470.00 73,470.00 73,476.00 73,470.00 66,280.00 -9.8% TOTAL FLEET MAINTENANCE 606,243.36 717,670.00 744,650.00 501,751.37 742,450.00 874,550.00 17.4% 7525420 PARK MAINTENANCE
7525420 5227 PART/REP 432.03 .00 .00 353.67 .00 .00 .0% 7525420 5531 VEHICLES .00 60,000.00 60,000.00 .00 60,000.00 62,000.00 3.3% TOTAL PARK MAINTENANCE 432.03 60,000.00 60,000.00 353.67 60,000.00 62,000.00 3.3% 7525601 CITY HALL
7525601 5227 PART/REP 975.02 .00 .00 570.72 .00 .00 .0% 7525601 5531 VEHICLES .00 .00 31,250.00 250.00 31,250.00 .00 .0% TOTAL CITY HALL 975.02 .00 31,250.00 820.72 31,250.00 .00 -100.0% 7525602 BUILDING MAINT & OPERATIONS
7525602 5227 PART/REP .00 .00 .00 546.92 .00 .00 .0% 7525602 5531 VEHICLES .00 59,250.00 59,250.00 34,199.48 59,250.00 .00 -100.0% TOTAL BUILDING MAINT & OPERA .00 59,250.00 59,250.00 34,746.40 59,250.00 .00 -100.0% 7526201 WATER ADMINISTRATION
7526201 5227 PART/REP .00 .00 .00 573.11 .00 .00 .0% TOTAL WATER ADMINISTRATION .00 .00 .00 573.11 .00 .00 .0% 7526202 CUSTOMER SERVICE
7526202 5227 PART/REP 1,972.22 .00 .00 .00 .00 .00 .0% TOTAL CUSTOMER SERVICE 1,972.22 .00 .00 .00 .00 .00 .0% 7526203 METER SERVICES
7526203 5227 PART/REP 702.03 .00 .00 1,436.78 .00 .00 .0% TOTAL METER SERVICES 702.03 .00 .00 1,436.78 .00 .00 .0% 7526205 PRODUCTION/STORAGE
7526205 5227 PART/REP 3,488.42 .00 .00 3,094.01 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL PRODUCTION/STORAGE 3,488.42 .00 .00 3,094.01 .00 .00 .0% 7526206 TRANSMISSION & DISTRIBUTION
7526206 5227 PART/REP 8,332.10 .00 .00 6,249.90 .00 .00 .0% TOTAL TRANSMISSION & DISTRIB 8,332.10 .00 .00 6,249.90 .00 .00 .0% 7526402 SEWER MAINTENANCE & OPERATIONS
7526402 5227 PART/REP 9,331.67 .00 .00 3,451.28 .00 .00 .0% TOTAL SEWER MAINTENANCE & OP 9,331.67 .00 .00 3,451.28 .00 .00 .0% 7526403 SEWER - RESIDENTIAL
7526403 5227 PART/REP 46.80 .00 .00 3.95 .00 .00 .0% TOTAL SEWER - RESIDENTIAL 46.80 .00 .00 3.95 .00 .00 .0% 7526404 SEWER - NON RESIDENTIAL
7526404 5227 PART/REP 538.52 .00 .00 47.75 .00 .00 .0% TOTAL SEWER - NON RESIDENTIA 538.52 .00 .00 47.75 .00 .00 .0% TOTAL FLEET MANAGEMENT 1,025,245.95 966,520.00 2,420,981.00 1,594,412.47 2,268,781.00 1,586,750.00 -34.5%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7531101 CITY COUNCIL
7531101 5217 OTHER SUPP .00 .00 .00 65.73 .00 .00 .0% 7531101 5232 COMP EQUIP .00 .00 .00 2,286.68 .00 .00 .0% 7531101 5243 UTL-TELEPH 3,814.28 .00 .00 4,593.58 .00 .00 .0% TOTAL CITY COUNCIL 3,814.28 .00 .00 6,945.99 .00 .00 .0% 7531201 CITY ADMINISTRATION
7531201 5213 DUES&SUBSC .00 .00 .00 2,070.20 .00 .00 .0% 7531201 5217 OTHER SUPP .00 .00 .00 20.58 .00 .00 .0% 7531201 5219 PERM/LC/FE 68.78 .00 .00 .00 .00 .00 .0% 7531201 5232 COMP EQUIP 2,214.22 .00 .00 .00 .00 .00 .0% 7531201 5234 OTH EQ RNT 1,263.96 .00 .00 1,263.96 .00 .00 .0% 7531201 5235 COPY USG 450.85 .00 .00 778.72 .00 .00 .0% TOTAL CITY ADMINISTRATION 3,997.81 .00 .00 4,133.46 .00 .00 .0% 7531301 ACCOUNTING SERVICES
7531301 5213 DUES&SUBSC .00 .00 .00 428.40 .00 .00 .0% 7531301 5217 OTHER SUPP .00 .00 .00 446.75 .00 .00 .0% 7531301 5219 PERM/LC/FE 412.68 .00 .00 .00 .00 .00 .0% 7531301 5232 COMP EQUIP 61.36 .00 .00 .00 .00 .00 .0% 7531301 5234 OTH EQ RNT 1,328.64 .00 .00 1,328.64 .00 .00 .0% 7531301 5235 COPY USG 4,191.85 .00 .00 5,604.39 .00 .00 .0% 7531301 5252 PROF SVS 350.00 .00 .00 .00 .00 .00 .0% 7531301 5254 DATA P SVS 58,963.37 .00 .00 -4,521.55 .00 .00 .0% TOTAL ACCOUNTING SERVICES 65,307.90 .00 .00 3,286.63 .00 .00 .0% 7531302 MAIL/PRINTING SERVICES
7531302 5234 OTH EQ RNT 3,301.80 .00 .00 3,301.80 .00 .00 .0% 7531302 5235 COPY USG 265.77 .00 .00 318.57 .00 .00 .0% TOTAL MAIL/PRINTING SERVICES 3,567.57 .00 .00 3,620.37 .00 .00 .0% 7531401 INFORMATION SYSTEMS
7531401 5110 BUY BACKS 3,543.83 3,730.00 3,730.00 .00 3,730.00 4,700.00 26.0% 7531401 5111 SALARY-FT 313,582.06 378,220.00 378,220.00 270,825.47 378,220.00 425,100.00 12.4%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7531401 5113 OVERTIME 5,107.46 6,000.00 6,000.00 3,953.37 6,000.00 .00 .0% 7531401 5113 40155 OVERTIME 200.82 .00 .00 .00 .00 .00 .0% 7531401 5116 FRINGE BEN 45,479.15 87,710.00 87,710.00 48,095.10 87,710.00 96,940.00 10.5% 7531401 5116 40155 FRINGE BEN 27.83 .00 .00 .00 .00 .00 .0% 7531401 5117 RETIR CNTR 29,005.73 41,030.00 41,030.00 28,125.38 41,030.00 50,610.00 23.3% 7531401 5211 POSTAGE 11.85 .00 .00 .00 .00 .00 .0% 7531401 5213 DUES&SUBSC 29,199.94 .00 .00 21,233.75 21,134.00 .00 .0% 7531401 5215 TRNG/CONF 722.47 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 7531401 5215 70102 TRNG/CONF .00 .00 .00 12,000.00 .00 .00 .0% 7531401 5216 OFFIC SUPP 432.04 600.00 600.00 .00 600.00 600.00 .0% 7531401 5217 OTHER SUPP 5,396.06 6,000.00 6,000.00 4,728.72 6,000.00 15,000.00 150.0% 7531401 5218 UNIFRM EXP 158.39 .00 .00 156.20 .00 .00 .0% 7531401 5219 PERM/LC/FE 151,462.02 705,000.00 705,000.00 348,762.86 618,080.00 1,169,410.00 65.9% 7531401 5220 FUEL USAGE 893.94 850.00 850.00 515.20 600.00 600.00 -29.4% 7531401 5221 MILE REIMB .00 100.00 100.00 10.00 100.00 100.00 .0% 7531401 5222 PRINTING 42.02 .00 .00 .00 .00 .00 .0% 7531401 5226 TEAMBLDG .00 .00 .00 .00 .00 500.00 .0% 7531401 5231 FURN&OFFC .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 7531401 5232 COMP EQUIP 40,499.08 53,000.00 53,000.00 105,769.04 112,830.00 105,000.00 98.1% 7531401 5233 OTHR EQUIP 38,232.97 45,000.00 45,000.00 9,625.28 45,000.00 30,000.00 -33.3% 7531401 5234 OTH EQ RNT .00 52,520.00 52,520.00 .00 52,520.00 52,520.00 .0% 7531401 5235 COPY USG .00 65,000.00 65,000.00 .00 65,000.00 65,000.00 .0% 7531401 5243 UTL-TELEPH 57,754.98 331,000.00 331,000.00 54,413.03 414,010.00 420,200.00 26.9% 7531401 5246 MAINT-EQP 275.85 .00 .00 .00 .00 .00 .0% 7531401 5248 MAINT-OTHR 3,119.67 .00 .00 .00 .00 .00 .0% 7531401 5252 PROF SVS .00 .00 45,000.00 45,000.00 45,000.00 .00 .0% 7531401 5253 CONTRC SVS .00 .00 .00 297.03 .00 .00 .0% 7531401 5254 DATA P SVS 124,250.68 699,030.00 711,800.00 66,195.35 465,070.00 506,710.00 -28.8% 7531401 5258 OTHER SVS 15,239.86 8,050.00 8,050.00 18,513.43 8,200.00 5,000.00 -37.9% 7531401 5283 DEPR-M&EQP 182,274.43 .00 .00 .00 .00 .00 .0% 7531401 5284 DEPR-VEH 5,668.09 .00 .00 .00 .00 .00 .0% 7531401 5290 LATE CHARG 1,114.13 .00 .00 1,496.43 1,100.00 1,200.00 .0% 7531401 5324 OPEB 24,085.00 .00 .00 .00 .00 .00 .0% 7531401 5325 PEN EXP -37,093.25 .00 .00 .00 .00 .00 .0% 7531401 5530 MACH&EQUIP 56,404.33 90,000.00 758,595.00 465,194.44 758,595.00 50,000.00 -93.4% 7531401 5530 70102 MACH&EQUIP .00 .00 161,835.00 152,814.17 .00 .00 -100.0% 7531401 5530 82331 MACH&EQUIP .00 .00 .00 14,531.54 .00 .00 .0% 7531401 5531 VEHICLES .00 500.00 500.00 .00 500.00 .00 .0% 7531401 5600 CONTR FA -221,619.62 .00 .00 -602,011.66 .00 .00 .0% 7531401 5702 FLT-MT&RP 3,080.00 2,970.00 2,970.00 2,976.00 2,970.00 4,380.00 47.5% 7531401 5703 VEH ACQ .00 500.00 500.00 504.00 500.00 .00 .0% 7531401 5706 OPB&BN ALC 13,670.00 12,900.00 12,900.00 12,900.00 12,900.00 12,560.00 -2.6% 7531401 5707 PERSUALALC 81,360.00 124,170.00 124,170.00 124,176.00 124,170.00 116,440.00 -6.2% TOTAL INFORMATION SYSTEMS 973,581.81 2,719,880.00 3,608,080.00 1,210,800.13 3,277,569.00 3,138,570.00 -13.0% 7531405 COUNCIL CHAMBERS
7531405 5243 14020 UTL-TELEPH 12,058.54 12,600.00 12,600.00 11,217.87 12,600.00 12,600.00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7531405 5254 DATA P SVS .00 .00 .00 800.00 .00 .00 .0% 7531405 5254 14020 DATA P SVS 159,287.60 120,000.00 120,000.00 5,263.80 120,000.00 120,000.00 .0% 7531405 5283 DEPR-M&EQP 8,708.72 .00 .00 .00 .00 .00 .0% 7531405 5530 14020 MACH&EQUIP 113,711.16 .00 .00 .00 .00 .00 .0% 7531405 5600 CONTR FA -83,577.56 .00 .00 .00 .00 .00 .0% 7531405 5701 INFO SYS 21,080.00 13,870.00 13,870.00 13,872.00 13,870.00 37,010.00 166.8% TOTAL COUNCIL CHAMBERS 231,268.46 146,470.00 146,470.00 31,153.67 146,470.00 169,610.00 15.8% 7531510 LIBRARY
7531510 5213 DUES&SUBSC .00 .00 .00 142.80 .00 .00 .0% 7531510 5219 PERM/LC/FE 137.56 .00 .00 .00 .00 .00 .0% 7531510 5232 COMP EQUIP 1,421.00 .00 .00 .00 .00 .00 .0% 7531510 5234 OTH EQ RNT 13,026.12 .00 .00 13,026.12 .00 .00 .0% 7531510 5235 COPY USG 3,163.17 .00 .00 8,183.44 .00 .00 .0% 7531510 5243 UTL-TELEPH 3,041.13 .00 .00 1,590.31 .00 .00 .0% 7531510 5248 MAINT-OTHR 323.25 .00 .00 .00 .00 .00 .0% 7531510 5254 DATA P SVS 10,069.01 .00 .00 8,917.60 .00 .00 .0% 7531510 5258 OTHER SVS .00 .00 .00 320.34 .00 .00 .0% 7531510 5283 DEPR-M&EQP 469.68 .00 .00 .00 .00 .00 .0% TOTAL LIBRARY 31,650.92 .00 .00 32,180.61 .00 .00 .0% 7531601 HUMAN RESOURCES
7531601 5213 DUES&SUBSC 50.00 .00 .00 7,297.95 .00 .00 .0% 7531601 5217 OTHER SUPP 21.96 .00 .00 1,891.35 .00 .00 .0% 7531601 5219 PERM/LC/FE 343.90 .00 .00 8,453.00 .00 .00 .0% 7531601 5232 COMP EQUIP 460.46 .00 .00 .00 .00 .00 .0% 7531601 5234 OTH EQ RNT 2,087.28 .00 .00 2,087.28 .00 .00 .0% 7531601 5235 COPY USG 2,861.73 .00 .00 4,802.07 .00 .00 .0% 7531601 5243 UTL-TELEPH 1,053.54 .00 .00 1,338.63 .00 .00 .0% 7531601 5254 DATA P SVS 5,764.84 .00 .00 15,913.39 .00 .00 .0% TOTAL HUMAN RESOURCES 12,643.71 .00 .00 41,783.67 .00 .00 .0% 7531701 CITY CLERK
7531701 5213 DUES&SUBSC 7,550.00 .00 .00 7,984.20 .00 .00 .0% 7531701 5217 OTHER SUPP 27.45 .00 .00 60.65 .00 .00 .0% 7531701 5219 PERM/LC/FE 137.56 .00 .00 6,250.00 .00 .00 .0% 7531701 5232 COMP EQUIP 291.94 .00 .00 .00 .00 .00 .0% 7531701 5234 OTH EQ RNT 1,955.88 .00 .00 1,955.88 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7531701 5235 COPY USG 2,550.76 .00 .00 3,020.47 .00 .00 .0% 7531701 5243 UTL-TELEPH 879.22 .00 .00 937.83 .00 .00 .0% 7531701 5248 MAINT-OTHR 95.90 .00 .00 .00 .00 .00 .0% 7531701 5253 CONTRC SVS .00 .00 250,000.00 .00 .00 .00 .0% 7531701 5254 DATA P SVS 28,006.28 .00 .00 29,366.50 .00 .00 .0% TOTAL CITY CLERK 41,494.99 .00 250,000.00 49,575.53 .00 .00 -100.0% 7532201 BUILDING AND SAFETY
7532201 5213 DUES&SUBSC .00 .00 .00 696.40 .00 .00 .0% 7532201 5217 OTHER SUPP 215.66 .00 .00 .00 .00 .00 .0% 7532201 5219 PERM/LC/FE 137.56 .00 .00 .00 .00 .00 .0% 7532201 5232 COMP EQUIP 8,502.96 .00 .00 .00 .00 .00 .0% 7532201 5234 OTH EQ RNT 2,378.16 .00 .00 2,378.16 .00 .00 .0% 7532201 5235 COPY USG 4,227.09 .00 .00 4,282.93 .00 .00 .0% 7532201 5243 UTL-TELEPH 8,871.68 .00 .00 8,879.63 .00 .00 .0% 7532201 5254 DATA P SVS 33,223.38 .00 .00 16,050.53 .00 .00 .0% 7532201 5258 OTHER SVS .00 .00 .00 281.25 .00 .00 .0% TOTAL BUILDING AND SAFETY 57,556.49 .00 .00 32,568.90 .00 .00 .0% 7532203 ECONOMIC DEVELOPMENT
7532203 5219 PERM/LC/FE 68.78 .00 .00 .00 .00 .00 .0% TOTAL ECONOMIC DEVELOPMENT 68.78 .00 .00 .00 .00 .00 .0% 7532205 PLANNING
7532205 5213 DUES&SUBSC .00 .00 .00 600.00 .00 .00 .0% 7532205 5217 OTHER SUPP .00 .00 .00 59.74 .00 .00 .0% 7532205 5219 PERM/LC/FE 562.45 .00 .00 .00 .00 .00 .0% 7532205 5232 COMP EQUIP 5,965.33 .00 .00 .00 .00 .00 .0% 7532205 5235 COPY USG 1,902.93 .00 .00 1,309.66 .00 .00 .0% 7532205 5243 UTL-TELEPH 382.83 .00 .00 .00 .00 .00 .0% 7532205 5254 DATA P SVS 27,695.47 .00 .00 16,144.99 .00 .00 .0% TOTAL PLANNING 36,509.01 .00 .00 18,114.39 .00 .00 .0% 7532931 HOUSING ADMINISTRATION
7532931 5213 DUES&SUBSC .00 .00 .00 285.60 .00 .00 .0% 7532931 5217 OTHER SUPP 314.59 .00 .00 .00 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7532931 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7532931 5235 COPY USG 4,534.69 .00 .00 5,533.59 .00 .00 .0% TOTAL HOUSING ADMINISTRATION 7,449.80 .00 .00 8,419.71 .00 .00 .0% 7533201 POLICE ADMINISTRATION
7533201 5213 DUES&SUBSC 40,417.30 .00 .00 37,575.89 .00 .00 .0% 7533201 5217 OTHER SUPP 3,369.74 .00 .00 8,285.08 .00 .00 .0% 7533201 5219 PERM/LC/FE 24,188.62 .00 .00 326,241.35 .00 .00 .0% 7533201 5232 COMP EQUIP 66,219.08 .00 .00 87,777.19 .00 .00 .0% 7533201 5233 OTHR EQUIP 2,954.94 .00 .00 1,140.90 .00 .00 .0% 7533201 5234 OTH EQ RNT 9,611.04 .00 .00 9,611.04 .00 .00 .0% 7533201 5235 COPY USG 19,265.23 .00 .00 5,234.76 .00 .00 .0% 7533201 5243 UTL-TELEPH 155,681.65 .00 .00 177,608.49 .00 .00 .0% 7533201 5248 MAINT-OTHR 10,188.87 .00 .00 1,472.00 .00 .00 .0% 7533201 5254 DATA P SVS 174,657.42 .00 .00 179,607.35 .00 .00 .0% 7533201 5254 54130 DATA P SVS 200.00 .00 .00 450.00 .00 .00 .0% 7533201 5255 54130 BANKNG SVS 83.72 .00 .00 121.68 .00 .00 .0% 7533201 5258 OTHER SVS 878.09 .00 .00 339.24 .00 .00 .0% 7533201 5283 DEPR-M&EQP 15,300.09 .00 .00 .00 .00 .00 .0% 7533201 5530 MACH&EQUIP 13,835.10 .00 253,220.00 .00 253,220.00 .00 .0% 7533201 5530 54130 MACH&EQUIP 1,970.41 .00 .00 .00 .00 .00 .0% TOTAL POLICE ADMINISTRATION 538,821.30 .00 253,220.00 835,464.97 253,220.00 .00 -100.0% 7533205 ANIMAL SERVICES
7533205 5213 DUES&SUBSC .00 .00 .00 625.00 .00 .00 .0% 7533205 5217 OTHER SUPP 408.37 .00 .00 .00 .00 .00 .0% 7533205 5219 PERM/LC/FE 3,840.00 .00 .00 18,321.60 .00 .00 .0% 7533205 5232 COMP EQUIP 2,794.12 .00 .00 1,168.73 .00 .00 .0% 7533205 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7533205 5235 COPY USG 5,132.66 .00 .00 7,775.35 .00 .00 .0% 7533205 5243 UTL-TELEPH 13,350.44 .00 .00 10,924.63 .00 .00 .0% 7533205 5254 DATA P SVS 369.00 .00 .00 .00 .00 .00 .0% 7533205 5255 54130 BANKNG SVS .00 .00 .00 15.08 .00 .00 .0% TOTAL ANIMAL SERVICES 28,495.11 .00 .00 41,430.91 .00 .00 .0% 7534201 RECREATION ADMINISTRATION
7534201 5213 DUES&SUBSC .00 .00 .00 1,620.22 .00 .00 .0% 7534201 5217 OTHER SUPP 24.76 .00 .00 .00 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7534201 5219 PERM/LC/FE 68.78 .00 .00 524.10 .00 .00 .0% 7534201 5232 COMP EQUIP 4,358.28 .00 .00 4,195.84 .00 .00 .0% 7534201 5233 OTHR EQUIP 88.74 .00 .00 .00 .00 .00 .0% 7534201 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7534201 5235 COPY USG 3,043.03 .00 .00 3,244.64 .00 .00 .0% 7534201 5243 UTL-TELEPH 13,257.50 .00 .00 15,791.83 .00 .00 .0% 7534201 5254 DATA P SVS 369.00 .00 .00 .00 .00 .00 .0% 7534201 5530 MACH&EQUIP .00 .00 .00 89,677.88 .00 .00 .0% TOTAL RECREATION ADMINISTRAT 23,810.61 .00 .00 117,655.03 .00 .00 .0% 7534203 RECREATION FACILITIES
7534203 5233 OTHR EQUIP 177.28 .00 .00 .00 .00 .00 .0% 7534203 5243 UTL-TELEPH 1,585.56 .00 .00 1,453.43 .00 .00 .0% TOTAL RECREATION FACILITIES 1,762.84 .00 .00 1,453.43 .00 .00 .0% 7534205 SENIOR CENTER
7534205 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7534205 5235 COPY USG 5,352.61 .00 .00 8,565.86 .00 .00 .0% 7534205 5243 UTL-TELEPH 6,752.20 .00 .00 5,895.37 .00 .00 .0% 7534205 5530 MACH&EQUIP .00 .00 .00 82,100.71 .00 .00 .0% TOTAL SENIOR CENTER 14,705.33 .00 .00 99,162.46 .00 .00 .0% 7534210 LANDACENA CENTER
7534210 5232 COMP EQUIP 5,422.66 .00 .00 .00 .00 .00 .0% 7534210 5243 TELE 6,107.60 .00 .00 6,386.27 .00 .00 .0% 7534210 5530 MACH&EQUIP .00 .00 .00 48,446.72 .00 .00 .0% TOTAL LANDACENA CENTER 11,530.26 .00 .00 54,832.99 .00 .00 .0% 7534402 CARNEGIE LIBRARY
7534402 5217 OTHER SUPP .00 .00 .00 4,388.83 .00 .00 .0% 7534402 5232 COMP EQUIP 350.84 .00 .00 .00 .00 .00 .0% TOTAL CARNEGIE LIBRARY 350.84 .00 .00 4,388.83 .00 .00 .0% 7535201 PUBLIC WORKS ADMINISTRATION
7535201 5213 DUES&SUBSC .00 .00 .00 357.00 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7535201 5217 OTHER SUPP 215.86 .00 .00 293.51 .00 .00 .0% 7535201 5219 PERM/LC/FE 137.56 .00 .00 .00 .00 .00 .0% 7535201 5232 COMP EQUIP 1,944.41 .00 .00 865.61 .00 .00 .0% 7535201 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7535201 5235 COPY USG 3,834.11 .00 .00 4,530.70 .00 .00 .0% 7535201 5243 UTL-TELEPH 15,119.79 .00 .00 5,617.60 .00 .00 .0% 7535201 5254 DATA PRCS 2,123.50 .00 .00 1,293.00 .00 .00 .0% 7535201 5530 MACH&EQUIP .00 .00 .00 18,806.08 .00 .00 .0% TOTAL PUBLIC WORKS ADMINISTR 25,975.75 .00 .00 34,364.02 .00 .00 .0% 7535202 NPDES
7535202 5219 PERM/LC/FE 68.78 .00 .00 .00 .00 .00 .0% TOTAL NPDES 68.78 .00 .00 .00 .00 .00 .0% 7535301 ENGINEERING ADMINISTRATION
7535301 5213 DUES&SUBSC 1,530.28 .00 .00 428.40 .00 .00 .0% 7535301 5217 OTHER SUPP 63.89 .00 .00 .00 .00 .00 .0% 7535301 5219 PERM/LC/FE 343.90 .00 .00 .00 .00 .00 .0% 7535301 5243 UTL-TELEPH 4,399.41 .00 .00 3,274.29 .00 .00 .0% TOTAL ENGINEERING ADMINISTRA 6,337.48 .00 .00 3,702.69 .00 .00 .0% 7535401 STREET MAINTENANCE
7535401 5232 COMP EQUIP 4,106.41 .00 .00 .00 .00 .00 .0% 7535401 5243 UTL-TELEPH 5,628.19 .00 .00 6,047.72 .00 .00 .0% TOTAL STREET MAINTENANCE 9,734.60 .00 .00 6,047.72 .00 .00 .0% 7535413 MAINTENANCE-METROLINK STATION
7535413 5243 54130 UTL-TELEPH 378.00 .00 .00 379.50 .00 .00 .0% TOTAL MAINTENANCE-METROLINK 378.00 .00 .00 379.50 .00 .00 .0% 7535414 FLEET MAINTENANCE
7535414 5213 DUES&SUBSC .00 .00 .00 7,625.00 .00 .00 .0% 7535414 5232 COMP EQUIP .00 .00 .00 304.24 .00 .00 .0% 7535414 5243 UTL-TELEPH 2,352.53 .00 .00 1,784.84 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7535414 5254 DATA P SVS 7,631.63 .00 .00 7,974.40 .00 .00 .0% TOTAL FLEET MAINTENANCE 9,984.16 .00 .00 17,688.48 .00 .00 .0% 7535420 PARK MAINTENANCE
7535420 5232 COMP EQUIP 4,765.79 .00 .00 1,089.24 .00 .00 .0% 7535420 5243 UTL-TELEPH 5,281.42 .00 .00 7,694.95 .00 .00 .0% TOTAL PARK MAINTENANCE 10,047.21 .00 .00 8,784.19 .00 .00 .0% 7535601 CITY HALL
7535601 5232 COMP EQUIP 2,317.48 .00 .00 .00 .00 .00 .0% 7535601 5243 UTL-TELEPH 1,026.60 .00 .00 .00 .00 .00 .0% TOTAL CITY HALL 3,344.08 .00 .00 .00 .00 .00 .0% 7535602 BUILDING MAINT & OPERATIONS
7535602 5232 COMP EQUIP .00 .00 .00 142.61 .00 .00 .0% 7535602 5243 UTL-TELEPH 3,766.35 .00 .00 4,058.69 .00 .00 .0% TOTAL BUILDING MAINT & OPERA 3,766.35 .00 .00 4,201.30 .00 .00 .0% 7536201 WATER ADMINISTRATION
7536201 5213 DUES&SUBSC 2,007.00 .00 .00 11,320.80 .00 .00 .0% 7536201 5217 OTHER SUPP 153.22 .00 .00 343.72 .00 .00 .0% 7536201 5219 PERM/LC/FE 440.65 .00 .00 2,313.00 .00 .00 .0% 7536201 5232 COMP EQUIP 170.56 .00 .00 6,381.00 .00 .00 .0% 7536201 5234 OTH EQ RNT 4,475.76 .00 .00 4,475.76 .00 .00 .0% 7536201 5235 COPY USG 2,206.07 .00 .00 2,607.51 .00 .00 .0% 7536201 5243 UTL-TELEPH 7,089.40 .00 .00 6,271.15 .00 .00 .0% 7536201 5254 DATA P SVS 3,125.00 .00 .00 6,332.74 .00 .00 .0% TOTAL WATER ADMINISTRATION 19,667.66 .00 .00 40,045.68 .00 .00 .0% 7536202 CUSTOMER SERVICE
7536202 5243 UTL-TELEPH 364.23 .00 .00 501.21 .00 .00 .0% 7536202 5254 DATA P SVS 12,029.96 .00 .00 12,932.20 .00 .00 .0% TOTAL CUSTOMER SERVICE 12,394.19 .00 .00 13,433.41 .00 .00 .0% 7536203 METER SERVICES
7536203 5243 UTL-TELEPH 2,362.62 .00 .00 1,002.42 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL METER SERVICES 2,362.62 .00 .00 1,002.42 .00 .00 .0% 7536205 PRODUCTION/STORAGE
7536205 5232 COMP EQUIP 1,237.33 .00 .00 3,909.96 .00 .00 .0% 7536205 5243 UTL-TELEPH 17,309.27 .00 .00 15,647.42 .00 .00 .0% 7536205 5245 MAINT-BLDG .00 .00 .00 955.08 .00 .00 .0% TOTAL PRODUCTION/STORAGE 18,546.60 .00 .00 20,512.46 .00 .00 .0% 7536206 TRANSMISSION & DISTRIBUTION
7536206 5232 COMP EQUIP 3,703.33 .00 .00 4,715.70 .00 .00 .0% 7536206 5243 UTL-TELEPH 22,994.70 .00 .00 21,789.13 .00 .00 .0% TOTAL TRANSMISSION & DISTRIB 26,698.03 .00 .00 26,504.83 .00 .00 .0% 7536208 CONSERVATION
7536208 5219 PERM/LC/FE 68.78 .00 .00 .00 .00 .00 .0% TOTAL CONSERVATION 68.78 .00 .00 .00 .00 .00 .0% 7536211 STORM WATER MGMT & RECHARGE
7536211 5254 DATA P SVS 5,033.00 .00 .00 5,033.00 .00 .00 .0% TOTAL STORM WATER MGMT & REC 5,033.00 .00 .00 5,033.00 .00 .00 .0% 7536301 SOLID WASTE
7536301 5217 OTHER SUPP .00 .00 .00 445.00 .00 .00 .0% 7536301 5243 UTL-TELEPH .00 .00 .00 365.13 .00 .00 .0% 7536301 5254 DATA P SVS 9,199.40 .00 .00 15,709.35 .00 .00 .0% TOTAL SOLID WASTE 9,199.40 .00 .00 16,519.48 .00 .00 .0% 7536401 LANDFILL SITE MAINTENANCE
7536401 5213 DUES&SUBSC .00 .00 .00 142.80 .00 .00 .0% 7536401 5219 PERM/LC/FE .00 .00 .00 395.00 .00 .00 .0% TOTAL LANDFILL SITE MAINTENA .00 .00 .00 537.80 .00 .00 .0% 7536402 SEWER MAINTENANCE & OPERATIONS
7536402 5232 COMP EQUIP 426.40 .00 .00 2,944.47 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7536402 5243 UTL-TELEPH 4,070.58 .00 .00 6,082.35 .00 .00 .0% 7536402 5254 DATA P SVS 13,799.09 .00 .00 14,834.03 .00 .00 .0% TOTAL SEWER MAINTENANCE & OP 18,296.07 .00 .00 23,860.85 .00 .00 .0% 7536403 SEWER - RESIDENTIAL
7536403 5254 DATA P SVS 1,174.50 .00 .00 1,174.00 .00 .00 .0% TOTAL SEWER - RESIDENTIAL 1,174.50 .00 .00 1,174.00 .00 .00 .0% 7536404 SEWER - NON RESIDENTIAL
7536404 5232 COMP EQUIP 46.50 .00 .00 .00 .00 .00 .0% 7536404 5243 UTL-TELEPH 2,423.12 .00 .00 1,784.84 .00 .00 .0% 7536404 5254 DATA P SVS 1,174.50 .00 .00 1,728.00 .00 .00 .0% TOTAL SEWER - NON RESIDENTIA 3,644.12 .00 .00 3,512.84 .00 .00 .0% TOTAL INFORMATION SYSTEMS 2,275,109.20 2,866,350.00 4,257,770.00 2,824,276.35 3,677,259.00 3,308,180.00 -22.3%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT BUILDING MAINT & OPERATIONS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7541510 LIBRARY
7541510 5217 OTHER SUPP 88.86 .00 .00 .00 .00 .00 .0% 7541510 5219 PERM/LC/FE .00 .00 .00 .00 1,000.00 1,000.00 .0% 7541510 5233 OTHR EQUIP 1,471.95 .00 .00 .00 .00 .00 .0% 7541510 5245 MAINT-BLDG 26,745.57 40,000.00 40,000.00 88,898.75 40,000.00 64,000.00 60.0% 7541510 5530 MACH&EQUIP .00 .00 .00 479.85 .00 .00 .0% TOTAL LIBRARY 28,306.38 40,000.00 40,000.00 89,378.60 41,000.00 65,000.00 62.5% 7542207 SANTA FE DEPOT
7542207 5245 MAINT-BLDG 1,014.00 6,000.00 6,000.00 6,301.00 6,000.00 5,000.00 -16.7% TOTAL SANTA FE DEPOT 1,014.00 6,000.00 6,000.00 6,301.00 6,000.00 5,000.00 -16.7% 7543201 POLICE ADMINISTRATION
7543201 5217 OTHER SUPP 820.68 .00 .00 268.70 .00 .00 .0% 7543201 5219 PERM/LC/FE 582.74 1,000.00 1,000.00 620.61 1,000.00 1,000.00 .0% 7543201 5231 FURN&OFFC -75.44 .00 .00 .00 .00 .00 .0% 7543201 5233 OTHR EQUIP 2,173.92 .00 .00 .00 .00 .00 .0% 7543201 5245 MAINT-BLDG 31,052.79 140,000.00 140,000.00 120,903.16 140,000.00 90,000.00 -35.7% 7543201 5528 IMPRV BLD 19,510.00 .00 .00 17,987.82 .00 .00 .0% 7543201 5529 BLD IMP .00 .00 .00 18,084.91 18,090.00 .00 .0% 7543201 5530 MACH&EQUIP .00 .00 .00 10,682.00 .00 .00 .0% TOTAL POLICE ADMINISTRATION 54,064.69 141,000.00 141,000.00 168,547.20 159,090.00 91,000.00 -35.5% 7543205 ANIMAL SERVICES
7543205 5217 OTHER SUPP 70.40 .00 .00 379.96 .00 .00 .0% 7543205 5219 PERM/LC/FE 870.50 1,000.00 1,000.00 620.61 1,000.00 1,000.00 .0% 7543205 5245 MAINT-BLDG 16,312.14 24,000.00 24,000.00 22,874.98 35,000.00 19,000.00 -20.8% 7543205 5246 MAINT-EQP 1,448.03 .00 .00 .00 .00 .00 .0% 7543205 5290 LATE CHARG .00 .00 .00 37.97 .00 .00 .0% TOTAL ANIMAL SERVICES 18,701.07 25,000.00 25,000.00 23,913.52 36,000.00 20,000.00 -20.0% 7543512 FIRE STATION II
7543512 5219 PERM/LC/FE .00 .00 .00 .00 .00 500.00 .0% 7543512 5245 MAINT-BLDG 1,466.29 10,000.00 10,000.00 3,282.82 10,000.00 5,000.00 -50.0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT BUILDING MAINT & OPERATIONS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL FIRE STATION II 1,466.29 10,000.00 10,000.00 3,282.82 10,000.00 5,500.00 -45.0% 7543518 HISTORIC FIRE STATION
7543518 5245 MAINT-BLDG 3,792.88 15,000.00 15,000.00 5,988.00 14,050.00 6,000.00 -60.0% TOTAL HISTORIC FIRE STATION 3,792.88 15,000.00 15,000.00 5,988.00 14,050.00 6,000.00 -60.0% 7544203 RECREATION FACILITIES
7544203 5217 OTHER SUPP .00 .00 .00 31.67 .00 .00 .0% 7544203 5245 MAINT-BLDG 18,116.34 30,000.00 30,000.00 48,041.71 35,000.00 29,000.00 -3.3% 7544203 5528 IMPRV BLD .00 40,000.00 40,000.00 36,153.00 40,000.00 .00 .0% TOTAL RECREATION FACILITIES 18,116.34 70,000.00 70,000.00 84,226.38 75,000.00 29,000.00 -58.6% 7544205 SENIOR CENTER
7544205 5233 OTHR EQUIP 67.87 .00 .00 .00 .00 .00 .0% 7544205 5245 MAINT-BLDG 16,965.12 40,000.00 40,000.00 46,739.26 40,000.00 25,000.00 -37.5% TOTAL SENIOR CENTER 17,032.99 40,000.00 40,000.00 46,739.26 40,000.00 25,000.00 -37.5% 7544210 LANDECENA CENTER
7544210 5245 MAINT-BLDG 22,400.20 22,000.00 22,000.00 15,745.00 22,000.00 25,000.00 13.6% TOTAL LANDECENA CENTER 22,400.20 22,000.00 22,000.00 15,745.00 22,000.00 25,000.00 13.6% 7544402 CARNEGIE LIBRARY
7544402 5233 OTHR EQUIP 1,471.95 .00 .00 .00 .00 .00 .0% 7544402 5245 MAINT-BLDG 8,101.85 35,000.00 35,000.00 8,623.00 35,000.00 15,000.00 -57.1% TOTAL CARNEGIE LIBRARY 9,573.80 35,000.00 35,000.00 8,623.00 35,000.00 15,000.00 -57.1% 7545201 PUBLIC WORKS ADMINISTRATION
7545201 5217 OTHER SUPP 1,104.94 .00 .00 1,182.39 .00 .00 .0% 7545201 5218 UNIFRM EXP -24.77 .00 .00 .00 .00 .00 .0% 7545201 5233 OTHR EQUIP 890.91 .00 .00 741.85 .00 .00 .0% 7545201 5245 MAINT-BLDG 15,055.65 55,000.00 55,000.00 40,163.11 54,680.00 40,000.00 -27.3% 7545201 5245 40155 MAINT-BLDG 17,900.00 .00 .00 .00 .00 .00 .0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT BUILDING MAINT & OPERATIONS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7545201 5246 MAINT-EQP 375.00 .00 .00 865.61 .00 .00 .0% 7545201 5528 IMPRV BLD 4,805.00 .00 .00 .00 .00 .00 .0% TOTAL PUBLIC WORKS ADMINISTR 40,106.73 55,000.00 55,000.00 42,952.96 54,680.00 40,000.00 -27.3% 7545414 FLEET MAINTENANCE
7545414 5217 OTHER SUPP 5.93 .00 .00 .00 .00 .00 .0% 7545414 5233 OTHR EQUIP 1,768.28 .00 .00 3,750.56 .00 .00 .0% 7545414 5234 OTH EQ RNT 2,186.37 .00 .00 .00 .00 .00 .0% 7545414 5245 MAINT-BLDG 8,351.14 35,000.00 35,000.00 23,816.45 35,000.00 20,000.00 -42.9% 7545414 5529 BLD IMP 72,375.00 .00 .00 .00 .00 .00 .0% TOTAL FLEET MAINTENANCE 84,686.72 35,000.00 35,000.00 27,567.01 35,000.00 20,000.00 -42.9% 7545420 PARK MAINTENANCE
7545420 5217 OTHER SUPP 1,062.95 .00 .00 1,264.40 .00 .00 .0% 7545420 5233 OTHR EQUIP .00 .00 .00 10,950.00 .00 .00 .0% 7545420 5234 OTH EQ RNT 6,577.64 .00 .00 .00 .00 .00 .0% 7545420 5245 MAINT-BLDG 12,521.49 40,000.00 513,750.00 25,883.08 40,000.00 25,000.00 -95.1% TOTAL PARK MAINTENANCE 20,162.08 40,000.00 513,750.00 38,097.48 40,000.00 25,000.00 -95.1% 7545601 CITY HALL
7545601 5217 OTHER SUPP 165.63 .00 .00 798.40 .00 .00 .0% 7545601 5219 PERM/LC/FE .00 700.00 700.00 .00 700.00 700.00 .0% 7545601 5231 FURN&OFFC 3,031.67 .00 15,000.00 17,150.57 15,000.00 .00 .0% 7545601 5233 OTHR EQUIP 2,047.38 .00 .00 .00 .00 .00 .0% 7545601 5245 MAINT-BLDG 81,893.84 70,000.00 70,000.00 66,567.12 70,000.00 82,000.00 17.1% TOTAL CITY HALL 87,138.52 70,700.00 85,700.00 84,516.09 85,700.00 82,700.00 -3.5% 7545602 BUILDING MAINT & OPERATIONS
7545602 5110 BUY BACKS 4,667.01 4,910.00 4,910.00 3,767.70 4,910.00 6,400.00 30.3% 7545602 5111 SALARY-FT 280,903.82 354,080.00 354,080.00 253,471.99 354,080.00 430,510.00 21.6% 7545602 5112 SALARY-PT 14,851.27 16,360.00 16,360.00 .00 16,360.00 18,720.00 14.4% 7545602 5113 OVERTIME 15,013.85 18,000.00 18,000.00 17,677.20 18,000.00 18,200.00 1.1% 7545602 5116 FRINGE BEN 78,014.48 110,620.00 110,620.00 81,403.55 110,620.00 139,070.00 25.7% 7545602 5117 RETIR CNTR 27,024.44 36,990.00 36,990.00 25,465.27 36,990.00 48,960.00 32.4% 7545602 5213 DUES&SUBSC 192.87 300.00 300.00 192.87 300.00 300.00 .0% 7545602 5216 OFFIC SUPP 17.69 1,000.00 1,000.00 971.47 900.00 600.00 -40.0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT BUILDING MAINT & OPERATIONS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7545602 5217 OTHER SUPP 2,552.63 1,000.00 1,000.00 65.63 1,000.00 1,000.00 .0% 7545602 5218 UNIFRM EXP 4,075.50 6,000.00 6,000.00 6,477.29 6,900.00 7,900.00 31.7% 7545602 5220 FUEL USAGE 18.69 .00 .00 657.23 .00 4,500.00 .0% 7545602 5222 PRINTING 63.57 .00 .00 .00 .00 .00 .0% 7545602 5233 OTHR EQUIP 4,412.53 10,000.00 10,000.00 3,801.69 10,000.00 8,000.00 -20.0% 7545602 5245 MAINT-BLDG .00 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 7545602 5253 CONTRC SVS .00 .00 .00 6,900.00 .00 .00 .0% 7545602 5258 OTHER SVS 225.50 5,000.00 5,000.00 1,559.00 5,000.00 50,000.00 900.0% 7545602 5324 OPEB -36,823.00 .00 .00 .00 .00 .00 .0% 7545602 5325 PEN EXP 210,130.29 .00 .00 .00 .00 .00 .0% 7545602 5528 IMPRV BLD .00 .00 .00 5,287.81 .00 .00 .0% 7545602 5530 MACH&EQUIP 2,998.15 .00 .00 .00 .00 .00 .0% 7545602 5703 VH ACQ ALC .00 59,250.00 59,250.00 59,256.00 59,250.00 .00 -100.0% 7545602 5706 OPB&BN ALC 20,950.00 13,210.00 13,210.00 13,212.00 13,210.00 14,650.00 10.9% 7545602 5707 PERSUALALC 102,120.00 116,300.00 116,300.00 116,304.00 116,300.00 118,750.00 2.1% TOTAL BUILDING MAINT & OPERA 731,409.29 758,020.00 758,020.00 596,470.70 758,820.00 872,560.00 15.1% 7546205 PRODUCTION/STORAGE
7546205 5245 MAINT-BLDG 79,052.47 110,000.00 110,000.00 38,120.86 110,000.00 40,000.00 -63.6% TOTAL PRODUCTION/STORAGE 79,052.47 110,000.00 110,000.00 38,120.86 110,000.00 40,000.00 -63.6% 7546301 SOLID WASTE
7546301 5245 MAINT-BLDG .00 3,000.00 3,000.00 .00 3,000.00 5,000.00 66.7% TOTAL SOLID WASTE .00 3,000.00 3,000.00 .00 3,000.00 5,000.00 66.7% 7546402 SEWER MAINTENANCE & OPERATIONS
7546402 5245 MAINT-BLDG .00 3,000.00 3,000.00 .00 3,000.00 5,000.00 66.7% TOTAL SEWER MAINTENANCE & OP .00 3,000.00 3,000.00 .00 3,000.00 5,000.00 66.7% TOTAL BUILDING MAINT & OPERA 1,217,024.45 1,478,720.00 1,967,470.00 1,280,469.88 1,528,340.00 1,376,760.00 -30.0%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT UAL AND EMPLOYEE BENEFITS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 7551504 NON-DEPARTMENTAL
7551504 5150 OPEB EXP 277,000.00 .00 .00 .00 .00 .00 .0% 7551504 5213 DUES&SUBSC 2,600.00 2,600.00 8,123.00 8,123.00 8,130.00 8,330.00 2.5% 7551504 5217 OTHER SUPP 29.98 .00 .00 3,688.08 4,000.00 4,000.00 .0% 7551504 5252 PROF SVS 34,730.80 22,830.00 22,830.00 26,950.00 25,000.00 35,000.00 53.3% 7551504 5253 CONTRC SVS 99,132.95 37,500.00 175,098.00 137,597.05 175,100.00 80,100.00 -54.3% 7551504 5255 BANKNG SVS 36,786.54 46,960.00 46,960.00 12,673.84 15,150.00 20,000.00 -57.4% 7551504 5258 OTHER SVS 6,690.75 14,300.00 14,300.00 9,700.00 5,000.00 8,600.00 -39.9% 7551504 5321 EMPL INCEN 15,869.04 21,500.00 21,500.00 69,739.24 21,500.00 25,000.00 16.3% 7551504 5322 HLTH-RETIR 360,171.65 345,370.00 345,370.00 311,472.69 343,130.00 343,130.00 -.6% 7551504 5325 PEN EXP 9,294,799.00 6,819,870.00 6,819,870.00 6,819,845.00 6,819,870.00 6,209,670.00 -8.9% 7551504 5326 MED-RETIRE 176,349.13 192,480.00 186,957.00 111,071.56 147,150.00 147,150.00 -21.3% 7551504 5327 DEN-RETIRE 85,375.59 75,000.00 75,000.00 68,341.91 73,160.00 73,160.00 -2.5% 7551504 5328 VIS-RETIRE 4,982.80 5,040.00 5,040.00 3,219.06 5,870.00 5,870.00 16.5% TOTAL NON-DEPARTMENTAL 10,394,518.23 7,583,450.00 7,721,048.00 7,582,421.43 7,643,060.00 6,960,010.00 -9.9% TOTAL UAL AND EMPLOYEE BENEF 10,394,518.23 7,583,450.00 7,721,048.00 7,582,421.43 7,643,060.00 6,960,010.00 -9.9%
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SUCCESSOR AGENCY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 8052901 SUCCESSOR AGENCY ADMINISTRATIO
8052901 5111 SALARY-FT 136,284.25 132,680.00 132,680.00 92,990.36 132,680.00 114,940.00 -13.4% 8052901 5113 OVERTIME .00 .00 .00 8.97 .00 .00 .0% 8052901 5116 FRINGE BEN 26,259.45 30,600.00 30,600.00 17,205.11 30,600.00 27,580.00 -9.9% 8052901 5117 RETIR CNTR 13,729.30 14,090.00 14,090.00 8,806.62 14,090.00 12,900.00 -8.4% 8052901 5251 LEGAL SVS .00 4,500.00 4,500.00 .00 4,500.00 7,500.00 66.7% 8052901 5252 PROF SVS 4,475.03 12,620.00 13,947.00 1,327.00 12,620.00 35,400.00 153.8% 8052901 5253 CONTRC SVS .00 10,930.00 10,930.00 2,000.00 10,930.00 .00 .0% 8052901 5255 BANKNG SVS 4,000.00 4,100.00 4,100.00 4,400.00 4,100.00 4,400.00 7.3% 8052901 5258 OTHER SVS 2,970.00 .00 .00 3,000.00 .00 .00 .0% 8052901 5296 RDA PASS-T 120,385.52 .00 .00 .00 .00 .00 .0% 8052901 5424 BND PRNCPL .00 2,480,000.00 2,480,000.00 .00 2,480,000.00 2,605,000.00 5.0% 8052901 5425 BND INT EX 490,355.65 635,940.00 635,940.00 635,937.50 635,940.00 510,790.00 -19.7% 8052901 5707 PERSUALALC 40,510.00 44,190.00 44,190.00 44,196.00 44,190.00 31,730.00 -28.2% TOTAL SUCCESSOR AGENCY ADMIN 838,969.20 3,369,650.00 3,370,977.00 809,871.56 3,369,650.00 3,350,240.00 -.6% TOTAL SUCCESSOR AGENCY 838,969.20 3,369,650.00 3,370,977.00 809,871.56 3,369,650.00 3,350,240.00 -.6% TOTAL REVENUE .00 .00 .00 .00 .00 .00 .0% TOTAL EXPENSE 162,900,256.25 184,018,790.00 196,811,724.00 132,274,411.85 160,114,021.00 211,747,710.00 7.6% GRAND TOTAL 162,900,256.25 184,018,790.00 196,811,724.00 132,274,411.85 160,114,021.00 211,747,710.00 7.6% ** END OF REPORT - Generated by Saleha Kazmi **
City of Upland, CA
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts
PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SUCCESSOR AGENCY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE Field # Total Page Break
Sequence 1 1 Y Y
Sequence 2 9 Y N
Sequence 3 11 N N
Sequence 4 12 N N
Report title:
05/17/2023 15:28 |City of Upland, CA |P 1 skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrp PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 Report type: 1
Budget level: 4
Percentage change calculation method: 4
Print first or second year of budget requests: F
Print revenue as credit: Y
Include cfwd in rev bud: N
Include cfwd in actuals: N
Print totals only: N
Include segment code: N
Include report grand totals by account type: Y
Print full GL account: N
Double space: N
Suppress zero bdgt accts: Y
Print as worksheet: N
Print percent change or comment: P
Print text: N
Amounts/totals exceed 999 million dollars: N
Print five budget levels: N
Report view: F
Find Criteria
Field Name Field Value
Org *
Object 5*
Project
Account type
Account status