Agenda packet, special meeting — Upland City Council, May 9, 2022 (part 3 of 3)

05/02/2022 12:10 |City of Upland, CA |P 91
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL PRODUCTION/STORAGE 14,701,260.22 16,816,020.00 16,846,020.00 15,904,148.04 4,944,830.00 17,814,200.00 5.7% ____________________________________________
6406206 TRANSMISSION & DISTRIBUTION
6406206 5110 BUY BACKS 2,173.30 .00 .00 5,196.27 5,200.00 .00 .0% 6406206 5111 SALARY-FT 770,487.51 971,450.00 971,450.00 654,466.89 772,230.00 997,110.00 2.6% 6406206 5113 OVERTIME 48,865.22 .00 .00 44,964.02 64,100.00 75,000.00 .0% 6406206 5116 FRINGE BEN 155,090.84 268,040.00 268,040.00 139,690.92 166,080.00 278,580.00 3.9% 6406206 5117 RETIR CNTR 82,549.85 98,820.00 98,820.00 63,402.04 74,730.00 105,600.00 6.9% 6406206 5119 UAL PERS 128,370.00 .00 .00 .00 .00 .00 .0% 6406206 5212 ADVERTISNG 2,993.60 .00 .00 .00 .00 .00 .0% 6406206 5213 DUES&SUBSC 495.00 500.00 500.00 495.00 500.00 500.00 .0% 6406206 5215 TRNG/CONF .00 5,000.00 5,000.00 5,249.22 5,000.00 5,000.00 .0% 6406206 5216 OFFIC SUPP 86.18 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 .0% 6406206 5217 OTHER SUPP 342,446.35 393,500.00 393,500.00 363,380.52 395,000.00 506,900.00 28.8% 6406206 5218 UNIFRM EXP .00 .00 21,000.00 18,105.19 21,000.00 .00 -100.0% 6406206 5220 FUEL USAGE 33,434.90 30,000.00 30,000.00 27,047.29 30,000.00 30,000.00 .0% 6406206 5223 INFO SYS 10,700.00 .00 .00 .00 .00 .00 .0% 6406206 5224 VEH CHRG 67,280.00 .00 .00 .00 .00 .00 .0% 6406206 5231 FURN&OFFC 8,382.95 .00 .00 .00 .00 .00 .0% 6406206 5232 COMP EQUIP 282.08 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 6406206 5233 OTHR EQUIP 5,343.92 10,000.00 10,000.00 6,041.44 10,000.00 10,000.00 .0% 6406206 5234 OTH EQ RNT 2,861.70 3,000.00 3,000.00 3,516.67 3,000.00 3,000.00 .0% 6406206 5246 MAINT-EQP .00 .00 .00 99.00 .00 .00 .0% 6406206 5248 MAINT-OTHR 1,500.00 40,000.00 40,000.00 35,000.00 40,000.00 40,000.00 .0% 6406206 5253 CONTRC SVS 102,484.00 325,000.00 305,000.00 260,000.00 325,000.00 325,000.00 6.6% 6406206 5258 OTHER SVS 2,316.00 12,300.00 52,300.00 39,468.00 40,000.00 13,400.00 -74.4% 6406206 5287 DEPR-PIPE 846,514.21 .00 .00 .00 .00 .00 .0% 6406206 5289 DEPR-TRTMT 327,679.00 .00 .00 .00 .00 .00 .0% 6406206 5298 LOSS-CAP A 222,317.00 .00 .00 .00 .00 .00 .0% 6406206 5530 MACH&EQUIP 12,810.34 10,000.00 10,000.00 .00 10,000.00 10,000.00 .0% 6406206 5531 VEHICLES .00 160,250.00 484,845.00 479,984.08 484,845.00 205,000.00 -57.7% 6406206 5600 CONTR FA -12,810.34 .00 .00 -292,710.94 .00 .00 .0% 6406206 5701 INFO SYS .00 200.00 200.00 187.00 200.00 400.00 100.0% 6406206 5702 FLT-MT&RP .00 96,600.00 96,600.00 88,550.00 96,600.00 76,140.00 -21.2%

TOTAL TRANSMISSION & DISTRIB 3,164,653.61 2,432,160.00 2,797,755.00 1,944,632.61 2,550,985.00 2,689,130.00 -3.9% ____________________________________________
6406207 WECWC MANAGEMENT CONTROL
6406207 5110 BUY BACKS .00 .00 .00 181.94 180.00 .00 .0% 6406207 5111 SALARY-FT 64,202.25 62,870.00 62,870.00 51,193.01 64,940.00 71,630.00 13.9%

Page 168 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 92
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 6406207 5111 16110 SALARY-FT 37.87 .00 .00 .00 .00 .00 .0% 6406207 5112 SALARY-PT 13,236.45 .00 .00 .00 .00 .00 .0% 6406207 5113 OVERTIME 12,944.03 12,840.00 12,840.00 10,770.10 13,000.00 13,000.00 1.2% 6406207 5116 FRINGE BEN 14,897.19 15,120.00 15,120.00 11,623.17 13,990.00 16,980.00 12.3% 6406207 5116 16110 FRINGE BEN 4.66 .00 .00 .00 .00 .00 .0% 6406207 5117 RETIR CNTR 5,829.57 6,280.00 6,280.00 4,053.78 5,210.00 7,350.00 17.0% 6406207 5117 16110 RETIR CNTR 4.38 .00 .00 .00 .00 .00 .0% 6406207 5119 UAL PERS 9,537.79 .00 .00 .00 .00 .00 .0% 6406207 5119 16110 UAL PERS 12.21 .00 .00 .00 .00 .00 .0% 6406207 5215 TRNG/CONF .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6406207 5217 OTHER SUPP 110.64 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 6406207 5219 PERM/LC/FE 25.00 30.00 30.00 812.56 30.00 30.00 .0% 6406207 5244 UTL-WATER .00 .00 .00 35,664.00 .00 .00 .0% 6406207 5249 OTHR MAINT .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6406207 5251 LEGAL SVS 266.00 .00 .00 95.00 .00 .00 .0% 6406207 5258 OTHER SVS .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0%

TOTAL WECWC MANAGEMENT CONTR 121,108.04 103,140.00 103,140.00 114,393.56 103,350.00 114,990.00 11.5% ____________________________________________
6406208 CONSERVATION
6406208 5111 SALARY-FT 31,843.57 79,010.00 79,010.00 26,505.32 27,540.00 80,590.00 2.0% 6406208 5116 FRINGE BEN 6,519.62 26,020.00 26,020.00 5,099.44 5,840.00 26,280.00 1.0% 6406208 5117 RETIR CNTR 3,657.54 8,210.00 8,210.00 2,743.30 2,830.00 8,810.00 7.3% 6406208 5119 UAL PERS 1,980.00 .00 .00 .00 .00 .00 .0% 6406208 5211 POSTAGE 4,976.20 23,000.00 23,000.00 4,892.80 23,000.00 23,000.00 .0% 6406208 5212 ADVERTISNG 2,382.24 19,700.00 19,700.00 .00 19,700.00 19,700.00 .0% 6406208 5213 DUES&SUBSC 2,019.40 5,900.00 5,900.00 1,619.40 5,900.00 5,900.00 .0% 6406208 5215 TRNG/CONF 206.08 5,500.00 5,500.00 822.50 5,500.00 5,500.00 .0% 6406208 5216 OFFIC SUPP 1,418.34 2,200.00 2,200.00 822.18 2,200.00 2,200.00 .0% 6406208 5217 OTHER SUPP 3,109.01 28,000.00 28,000.00 3,915.41 28,000.00 28,000.00 .0% 6406208 5217 20201 OTHER SUPP 12.23 .00 .00 .00 .00 .00 .0% 6406208 5217 20202 OTHER SUPP 192.55 .00 .00 .00 .00 .00 .0% 6406208 5217 20211 OTHER SUPP 51.53 .00 .00 .00 .00 .00 .0% 6406208 5218 UNIFRM EXP .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6406208 5222 PRINTING .00 12,000.00 12,000.00 .00 12,000.00 12,000.00 .0% 6406208 5231 FURN&OFFC 142.68 .00 .00 .00 .00 .00 .0% 6406208 5233 OTHR EQUIP 56.23 .00 .00 .00 .00 .00 .0% 6406208 5234 OTH EQ RNT .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6406208 5253 CONTRC SVS 30,000.00 38,000.00 38,000.00 .00 38,000.00 38,000.00 .0% 6406208 5258 OTHER SVS 13,038.95 21,080.00 21,080.00 16,944.14 21,080.00 21,080.00 .0% 6406208 5294 SPONSOR 220.25 5,200.00 5,200.00 .00 5,200.00 5,200.00 .0% 6406208 5701 INFO SYS .00 200.00 200.00 187.00 200.00 200.00 .0%

TOTAL CONSERVATION 101,826.42 276,020.00 276,020.00 63,551.49 198,990.00 278,460.00 .9% ____________________________________________
6406210 DEBT SERVICE
6406210 5252 PROF SVS .00 1,500.00 1,500.00 2,000.00 2,000.00 2,000.00 33.3%

Page 169 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 93
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL DEBT SERVICE 298,125.17 1,020,480.00 1,020,480.00 192,396.83 635,000.00 1,268,920.00 24.3% ____________________________________________
6406211 STORM WATER MGMT & RECHARGE
6406211 5111 SALARY-FT 186,171.03 176,640.00 176,640.00 150,830.93 180,810.00 180,580.00 2.2% 6406211 5112 SALARY-PT .00 8,540.00 8,540.00 .00 .00 .00 -100.0% 6406211 5113 OVERTIME 1,222.35 .00 .00 .00 .00 .00 .0% 6406211 5116 FRINGE BEN 46,985.78 50,470.00 50,470.00 34,867.33 44,010.00 50,590.00 .2% 6406211 5117 RETIR CNTR 20,747.93 17,820.00 17,820.00 15,032.25 18,230.00 19,180.00 7.6% 6406211 5119 UAL PERS 17,850.00 .00 .00 .00 .00 .00 .0% 6406211 5215 TRNG/CONF .00 600.00 600.00 .00 600.00 600.00 .0% 6406211 5217 OTHER SUPP .00 20,000.00 20,000.00 .00 10,000.00 20,000.00 .0% 6406211 5219 PERM/LC/FE 54,020.00 33,000.00 40,000.00 39,300.15 40,000.00 90,260.00 125.7% 6406211 5223 INFO SYS 2,100.00 .00 .00 .00 .00 .00 .0% 6406211 5251 LEGAL SVS .00 .00 .00 .00 .00 15,000.00 .0% 6406211 5252 PROF SVS 15,400.00 .00 .00 .00 10,000.00 .00 .0% 6406211 5258 OTHER SVS .00 1,000.00 1,000.00 .00 1,000.00 80,000.00 7900.0% 6406211 5701 INFO SYS .00 2,220.00 2,220.00 2,035.00 2,220.00 2,220.00 .0%

TOTAL STORM WATER MGMT & REC 344,497.09 310,290.00 317,290.00 242,065.66 306,870.00 458,430.00 44.5% ____________________________________________
6406212 PVPA
6406212 5111 SALARY-FT 13,729.64 .00 .00 8,396.23 11,010.00 .00 .0% 6406212 5113 OVERTIME 121.70 250.00 250.00 389.04 400.00 400.00 60.0% 6406212 5116 FRINGE BEN 2,980.94 .00 .00 1,812.05 2,220.00 .00 .0% 6406212 5117 RETIR CNTR 1,573.18 .00 .00 874.82 1,150.00 .00 .0% 6406212 5119 UAL PERS 3,604.99 .00 .00 .00 .00 .00 .0% 6406212 5217 OTHER SUPP 475.32 2,500.00 2,500.00 375.49 2,500.00 2,500.00 .0% 6406212 5248 MAINT-OTHR 315.38 .00 .00 .00 .00 .00 .0%

TOTAL PVPA 22,801.15 2,750.00 2,750.00 11,847.63 17,280.00 2,900.00 5.5% ____________________________________________
6406213 CUSTOMER SVC - FINANCE
6406213 5111 SALARY-FT 123,919.07 154,090.00 154,090.00 106,969.87 138,060.00 158,430.00 2.8% 6406213 5111 50105 SALARY-FT 9.60 .00 .00 .00 .00 .00 .0% 6406213 5112 SALARY-PT 33.12 .00 .00 .00 .00 .00 .0% 6406213 5113 OVERTIME 170.90 15,600.00 15,600.00 3,234.97 15,600.00 15,600.00 .0% 6406213 5116 FRINGE BEN 28,577.56 49,240.00 49,240.00 24,223.25 30,290.00 47,730.00 -3.1%

Page 170 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 94
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 6406213 5116 50105 FRINGE BEN 2.67 .00 .00 .00 .00 .00 .0% 6406213 5117 RETIR CNTR 14,033.77 16,020.00 16,020.00 10,678.79 13,850.00 17,330.00 8.2% 6406213 5117 50105 RETIR CNTR 1.11 .00 .00 .00 .00 .00 .0% 6406213 5119 UAL PERS 36,056.90 .00 .00 .00 .00 .00 .0% 6406213 5119 50105 UAL PERS 3.10 .00 .00 .00 .00 .00 .0% 6406213 5211 POSTAGE 23,933.96 25,000.00 25,000.00 25,000.00 25,000.00 25,000.00 .0% 6406213 5215 TRNG/CONF .00 5,630.00 5,630.00 .00 5,630.00 5,630.00 .0% 6406213 5216 OFFIC SUPP 1,798.47 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 .0% 6406213 5218 UNIFRM EXP .00 3,850.00 3,850.00 .00 3,850.00 3,850.00 .0% 6406213 5223 INFO SYS 15,480.00 .00 .00 .00 .00 .00 .0% 6406213 5224 VEH CHRG 800.00 .00 .00 .00 .00 .00 .0% 6406213 5231 FURN&OFFC .00 530.00 530.00 .00 530.00 530.00 .0% 6406213 5234 OTH EQ RNT 1,863.44 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 .0% 6406213 5255 BANKNG SVS 121,543.44 102,000.00 102,000.00 89,063.08 102,000.00 102,000.00 .0% 6406213 5258 OTHER SVS 11,714.50 60,840.00 60,840.00 16,244.99 60,840.00 60,840.00 .0% 6406213 5701 INFO SYS .00 27,390.00 27,390.00 25,113.00 27,390.00 32,110.00 17.2%

TOTAL CUSTOMER SVC - FINANCE 379,941.61 464,190.00 464,190.00 304,527.95 427,040.00 473,050.00 1.9% ____________________________________________
6407500 CAPITAL PROJECTS
6407500 5111 91000 SALARY-FT 5,828.44 .00 .00 .00 .00 .00 .0% 6407500 5111 91001 SALARY-FT 532.78 .00 .00 .00 .00 .00 .0% 6407500 5113 91000 OVERTIME 85.62 .00 .00 .00 .00 .00 .0% 6407500 5116 91000 FRINGE BEN 809.05 .00 .00 .00 .00 .00 .0% 6407500 5116 91001 FRINGE BEN 116.30 .00 .00 .00 .00 .00 .0% 6407500 5117 91000 RETIR CNTR 674.17 .00 .00 .00 .00 .00 .0% 6407500 5117 91001 RETIR CNTR 61.63 .00 .00 .00 .00 .00 .0% 6407500 5119 91000 UAL PERS 1,535.88 .00 .00 .00 .00 .00 .0% 6407500 5217 91000 OTHER SUPP 17,986.71 .00 .00 .00 .00 .00 .0% 6407500 5234 91000 OTH EQ RNT 1,153.77 .00 .00 .00 .00 .00 .0% 6407500 5258 91000 OTHER SVS 46,680.00 .00 .00 .00 .00 .00 .0% 6407500 5258 91001 OTHER SVS .00 469,290.00 469,290.00 .00 .00 469,290.00 .0% 6407500 5258 91002 OTHER SVS .00 275,000.00 275,000.00 .00 .00 275,000.00 .0% 6407500 5258 91003 OTHER SVS .00 1,400,000.00 1,400,000.00 .00 .00 1,400,000.00 .0% 6407500 5258 91004 OTHER SVS .00 50,000.00 179,500.00 .00 49,580.00 129,900.00 -27.6% 6407500 5258 91005 OTHER SVS .00 275,000.00 275,000.00 .00 .00 300,000.00 9.1% 6407500 5258 91006 OTHER SVS .00 750,000.00 750,000.00 .00 .00 1,025,000.00 36.7% 6407500 5258 91007 OTHER SVS .00 500,000.00 500,000.00 .00 .00 .00 -100.0% 6407500 5530 91004 MACH&EQUIP .00 .00 .00 117,471.00 .00 .00 .0% 6407500 5600 91000 CONTR FA -74,753.64 .00 .00 .00 .00 .00 .0% 6407500 5600 91001 CONTR FA -710.71 .00 .00 .00 .00 .00 .0%

TOTAL CAPITAL PROJECTS .00 3,719,290.00 3,848,790.00 117,471.00 49,580.00 3,599,190.00 -6.5% ____________________________________________
6409048 RSRV 16 STRCTRL EVAL
6409048 5258 OTHER SVS .00 15,230.00 15,230.00 .00 .00 15,230.00 .0%

Page 171 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 95
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL RSRV 16 STRCTRL EVAL .00 15,230.00 15,230.00 .00 .00 15,230.00 .0% ____________________________________________
6409049 CW LAT REPLC- ANNUAL
6409049 5258 OTHER SVS .00 50,000.00 50,000.00 4,395.69 4,400.00 60,600.00 21.2%

TOTAL CW LAT REPLC- ANNUAL .00 50,000.00 50,000.00 4,395.69 4,400.00 60,600.00 21.2% ____________________________________________
6409050 CW HYDRANT REPLC- ANNUAL
6409050 5258 OTHER SVS .00 50,000.00 50,000.00 .00 .00 75,000.00 50.0%

TOTAL CW HYDRANT REPLC- ANNU .00 50,000.00 50,000.00 .00 .00 75,000.00 50.0% ____________________________________________
6409052 WST TO DRN DISCH LINES
6409052 5258 OTHER SVS .00 50,000.00 50,000.00 .00 .00 50,000.00 .0%

TOTAL WST TO DRN DISCH LINES .00 50,000.00 50,000.00 .00 .00 50,000.00 .0% ____________________________________________
6409065 RTRFT DSGNS PH 1 RCYCL WTR USR
6409065 5111 SALARY-FT 2,468.16 .00 .00 .00 .00 .00 .0% 6409065 5116 FRINGE BEN 175.56 .00 .00 .00 .00 .00 .0% 6409065 5117 RETIR CNTR 285.50 .00 .00 .00 .00 .00 .0% 6409065 5119 UAL PERS 795.92 .00 .00 .00 .00 .00 .0% 6409065 5217 OTHER SUPP 390.68 .00 .00 .00 .00 .00 .0% 6409065 5258 OTHER SVS .00 3,840.00 3,840.00 .00 .00 .00 -100.0%

TOTAL RTRFT DSGNS PH 1 RCYCL 4,115.82 3,840.00 3,840.00 .00 .00 .00 -100.0% ____________________________________________
6409081 RESERVOIR 16 REPAIRS
6409081 5258 OTHER SVS .00 1,075,000.00 945,500.00 .00 .00 .00 -100.0%

TOTAL RESERVOIR 16 REPAIRS .00 1,075,000.00 945,500.00 .00 .00 .00 -100.0% ____________________________________________
6409082 ONSITE DISINF GNRTN/ DSGN ONLY
6409082 5258 OTHER SVS .00 200,460.00 200,460.00 .00 .00 200,460.00 .0%

TOTAL ONSITE DISINF GNRTN/ D .00 200,460.00 200,460.00 .00 .00 200,460.00 .0% ____________________________________________
6409084 PLANT 3 BOOSTER UPGRADES
6409084 5258 OTHER SVS .00 125,000.00 125,000.00 .00 .00 225,000.00 80.0%

Page 172 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 96
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL PLANT 3 BOOSTER UPGRAD .00 125,000.00 125,000.00 .00 .00 225,000.00 80.0% ____________________________________________
6409087 PRV STNS- ZNS 5/4 & 4/3
6409087 5111 SALARY-FT 180.18 .00 .00 .00 .00 .00 .0% 6409087 5116 FRINGE BEN 36.33 .00 .00 .00 .00 .00 .0% 6409087 5117 RETIR CNTR 20.83 .00 .00 .00 .00 .00 .0% 6409087 5119 UAL PERS 58.10 .00 .00 .00 .00 .00 .0% 6409087 5258 OTHER SVS 2,004.35 852,390.00 850,360.00 6,367.74 .00 1,000,360.00 17.6% 6409087 5600 CONTR FA -2,299.79 .00 .00 .00 .00 .00 .0%

TOTAL PRV STNS- ZNS 5/4 & 4/ .00 852,390.00 850,360.00 6,367.74 .00 1,000,360.00 17.6% ____________________________________________
6409094 GREENTREE RD WM
6409094 5111 SALARY-FT 2,723.32 .00 .00 .00 .00 .00 .0% 6409094 5116 FRINGE BEN 694.00 .00 .00 .00 .00 .00 .0% 6409094 5117 RETIR CNTR 315.02 .00 .00 .00 .00 .00 .0% 6409094 5600 CONTR FA -3,732.34 .00 .00 .00 .00 .00 .0%

TOTAL GREENTREE RD WM .00 .00 .00 .00 .00 .00 .0% ____________________________________________
6409095 7TH ST WM
6409095 5258 OTHER SVS 874,262.04 .00 .00 .00 .00 .00 .0% 6409095 5600 CONTR FA -874,262.04 .00 .00 .00 .00 .00 .0%

TOTAL 7TH ST WM .00 .00 .00 .00 .00 .00 .0% ____________________________________________
6409122 13TH ST RECONST- EUCLID-CAMPUS
6409122 5111 SALARY-FT .00 .00 .00 6,977.24 10,790.00 .00 .0% 6409122 5113 OVERTIME .00 .00 .00 616.26 1,340.00 .00 .0% 6409122 5116 FRINGE BEN .00 .00 .00 1,535.67 2,540.00 .00 .0% 6409122 5117 RETIR CNTR .00 .00 .00 727.08 1,120.00 .00 .0% 6409122 5258 OTHER SVS 2,450.00 893,500.00 893,500.00 752,640.00 758,710.00 134,800.00 -84.9% 6409122 5600 CONTR FA -2,450.00 .00 .00 .00 .00 .00 .0%

TOTAL 13TH ST RECONST- EUCLI .00 893,500.00 893,500.00 762,496.25 774,500.00 134,800.00 -84.9% ____________________________________________
6409124 ARRW HWY REHAB (MNT TO SA)
6409124 5111 SALARY-FT 5,435.78 .00 .00 2,528.93 4,320.00 .00 .0%

Page 173 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 97
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL ARRW HWY REHAB (MNT TO .00 392,080.00 389,068.00 3,276.37 8,910.00 450,810.00 15.9% ____________________________________________
6409127 GROUND WTR NITRATE TREATMNT
6409127 5258 OTHER SVS .00 300,000.00 300,000.00 .00 .00 300,000.00 .0%

TOTAL GROUND WTR NITRATE TRE .00 300,000.00 300,000.00 .00 .00 300,000.00 .0% ____________________________________________
6409128 WTR RSRV RPLC 17TH & BNSN
6409128 5111 SALARY-FT 30,981.61 .00 .00 24,371.46 28,400.00 .00 .0% 6409128 5116 FRINGE BEN 6,134.73 .00 .00 4,815.55 5,570.00 .00 .0% 6409128 5117 RETIR CNTR 3,580.66 .00 .00 2,539.52 2,960.00 .00 .0% 6409128 5119 UAL PERS 9,469.80 .00 .00 .00 .00 .00 .0% 6409128 5212 ADVERTISNG 5,827.90 .00 .00 .00 .00 .00 .0% 6409128 5251 LEGAL SVS 3,229.74 .00 .00 .00 .00 .00 .0% 6409128 5258 OTHER SVS 2,583,000.20 1,154,020.00 1,154,020.00 12,134,403.10 24,100.00 1,127,000.00 -2.3% 6409128 5600 CONTR FA -2,642,224.64 .00 .00 .00 .00 .00 .0%

TOTAL WTR RSRV RPLC 17TH & B .00 1,154,020.00 1,154,020.00 12,166,129.63 61,030.00 1,127,000.00 -2.3% ____________________________________________
6409132 WATER INTERCONNECT W CVWD SYS
6409132 5258 OTHER SVS .00 50,000.00 50,000.00 .00 .00 50,000.00 .0%

TOTAL WATER INTERCONNECT W C .00 50,000.00 50,000.00 .00 .00 50,000.00 .0% ____________________________________________
6409133 WATER CONS LNDSCP MOD PROJ
6409133 5258 OTHER SVS .00 120,000.00 120,000.00 .00 .00 .00 -100.0%

TOTAL WATER CONS LNDSCP MOD .00 120,000.00 120,000.00 .00 .00 .00 -100.0% ____________________________________________
6409134 RESERVOIR 15 ENH 17th & BENSON
6409134 5258 OTHER SVS .00 26,060.00 26,060.00 .00 .00 101,060.00 287.8%

TOTAL RESERVOIR 15 ENH 17th .00 26,060.00 26,060.00 .00 .00 101,060.00 287.8% ____________________________________________
6409135 PLANT 6 MOTOR CONTROL CTR-15TH
6409135 5111 SALARY-FT 32.76 .00 .00 .00 .00 .00 .0%

Page 174 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 98
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL PLANT 6 MOTOR CONTROL .00 253,400.00 253,400.00 160,167.45 160,170.00 93,230.00 -63.2% ____________________________________________
6409136 PLANT 3 BOOSTR INSTALL PUMP&MO
6409136 5258 OTHER SVS .00 80,000.00 80,000.00 .00 .00 125,000.00 56.3%

TOTAL PLANT 3 BOOSTR INSTALL .00 80,000.00 80,000.00 .00 .00 125,000.00 56.3% ____________________________________________
6409137 GENERATORS AT PLANT 2 - 24TH
6409137 5111 SALARY-FT 4,660.47 .00 .00 2,375.20 2,010.00 .00 .0% 6409137 5116 FRINGE BEN 983.65 .00 .00 494.02 450.00 .00 .0% 6409137 5117 RETIR CNTR 539.09 .00 .00 247.49 210.00 .00 .0% 6409137 5119 UAL PERS 1,502.91 .00 .00 .00 .00 .00 .0% 6409137 5258 OTHER SVS 8,593.50 258,590.00 257,370.00 2,160.00 3,870.00 254,600.00 -1.1% 6409137 5600 CONTR FA -16,279.62 .00 .00 .00 .00 .00 .0%

TOTAL GENERATORS AT PLANT 2 .00 258,590.00 257,370.00 5,276.71 6,540.00 254,600.00 -1.1% ____________________________________________
6409138 GENERATORS AT PLANT 6 - 15TH
6409138 5111 SALARY-FT 4,602.42 .00 .00 2,855.66 2,330.00 .00 .0% 6409138 5116 FRINGE BEN 965.50 .00 .00 589.67 520.00 .00 .0% 6409138 5117 RETIR CNTR 532.32 .00 .00 297.56 240.00 .00 .0% 6409138 5119 UAL PERS 1,482.59 .00 .00 .00 .00 .00 .0% 6409138 5258 OTHER SVS 8,593.50 787,890.00 786,424.00 2,160.00 4,390.00 783,300.00 -.4% 6409138 5600 CONTR FA -16,176.33 .00 .00 .00 .00 .00 .0%

TOTAL GENERATORS AT PLANT 6 .00 787,890.00 786,424.00 5,902.89 7,480.00 783,300.00 -.4% ____________________________________________
6409139 ALLEY WATER MAIN REPLCMNT 1819
6409139 5258 OTHER SVS 145,716.06 .00 .00 .00 .00 .00 .0% 6409139 5600 CONTR FA -145,716.06 .00 .00 .00 .00 .00 .0%

TOTAL ALLEY WATER MAIN REPLC .00 .00 .00 .00 .00 .00 .0% ____________________________________________
6409140 17TH ST WTR MAIN & SVC RPLCMNT
6409140 5258 OTHER SVS 3,450.00 446,550.00 446,550.00 15,000.00 13,630.00 932,930.00 108.9%

Page 175 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 99
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL 17TH ST WTR MAIN & SVC .00 446,550.00 446,550.00 15,000.00 13,630.00 932,930.00 108.9% ____________________________________________
6409141 19TH ST WTR MAIN & SVC RPLCMNT
6409141 5258 OTHER SVS .00 800,000.00 800,000.00 .00 .00 1,000,000.00 25.0%

TOTAL 19TH ST WTR MAIN & SVC .00 800,000.00 800,000.00 .00 .00 1,000,000.00 25.0% ____________________________________________
6409142 ARROW HWY WTR MAIN RPLCMNT
6409142 5111 SALARY-FT 5,717.69 .00 .00 2,684.20 4,320.00 .00 .0% 6409142 5116 FRINGE BEN 1,237.72 .00 .00 486.21 880.00 .00 .0% 6409142 5117 RETIR CNTR 660.71 .00 .00 279.66 450.00 .00 .0% 6409142 5119 UAL PERS 1,825.38 .00 .00 .00 .00 .00 .0% 6409142 5217 OTHER SUPP .00 .00 .00 37,500.00 .00 .00 .0% 6409142 5258 OTHER SVS .00 393,320.00 388,988.00 .00 8,680.00 380,290.00 -2.2% 6409142 5600 CONTR FA -9,441.50 .00 .00 .00 .00 .00 .0%

TOTAL ARROW HWY WTR MAIN RPL .00 393,320.00 388,988.00 40,950.07 14,330.00 380,290.00 -2.2% ____________________________________________
6409143 MULBERRY AVE WTR MAIN RPLCMNT
6409143 5258 OTHER SVS .00 440,000.00 440,000.00 12,000.00 3,680.00 436,330.00 -.8%

TOTAL MULBERRY AVE WTR MAIN .00 440,000.00 440,000.00 12,000.00 3,680.00 436,330.00 -.8% ____________________________________________
6409144 HUNTINGTON DR WTR MAIN RPLCMNT
6409144 5111 SALARY-FT 936.97 .00 .00 .00 .00 .00 .0% 6409144 5116 FRINGE BEN 200.70 .00 .00 .00 .00 .00 .0% 6409144 5117 RETIR CNTR 108.38 .00 .00 .00 .00 .00 .0% 6409144 5119 UAL PERS 302.12 .00 .00 .00 .00 .00 .0% 6409144 5258 OTHER SVS .00 46,070.00 46,070.00 .00 .00 796,070.00 1628.0% 6409144 5600 CONTR FA -1,548.17 .00 .00 .00 .00 .00 .0%

TOTAL HUNTINGTON DR WTR MAIN .00 46,070.00 46,070.00 .00 .00 796,070.00 1628.0% ____________________________________________
6409145 ALPINE ST WATER MAIN REPLCMNT
6409145 5111 SALARY-FT 3,219.31 .00 .00 2,445.02 3,620.00 .00 .0% 6409145 5116 FRINGE BEN 688.77 .00 .00 483.00 760.00 .00 .0% 6409145 5117 RETIR CNTR 372.05 .00 .00 254.74 380.00 .00 .0%

Page 176 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 100
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL ALPINE ST WATER MAIN R .00 490,360.00 478,643.00 5,374.76 9,860.00 523,290.00 9.3% ____________________________________________
6409146 VERNON DR WTR MAIN REPLACEMENT
6409146 5111 SALARY-FT 3,092.34 .00 .00 2,430.97 3,620.00 .00 .0% 6409146 5116 FRINGE BEN 659.99 .00 .00 479.83 760.00 .00 .0% 6409146 5117 RETIR CNTR 357.34 .00 .00 253.28 380.00 .00 .0% 6409146 5119 UAL PERS 987.96 .00 .00 .00 .00 .00 .0% 6409146 5258 OTHER SVS 10,808.00 300,710.00 288,994.00 2,192.00 5,100.00 298,660.00 3.3% 6409146 5600 CONTR FA -15,905.63 .00 .00 .00 .00 .00 .0%

TOTAL VERNON DR WTR MAIN REP .00 300,710.00 288,994.00 5,356.08 9,860.00 298,660.00 3.3% ____________________________________________
6409147 PALM AVE WTR MAIN REPLACEMENT
6409147 5111 SALARY-FT 3,109.07 .00 .00 2,445.03 3,650.00 .00 .0% 6409147 5116 FRINGE BEN 663.78 .00 .00 474.14 750.00 .00 .0% 6409147 5117 RETIR CNTR 359.29 .00 .00 254.75 380.00 .00 .0% 6409147 5119 UAL PERS 993.36 .00 .00 .00 .00 .00 .0% 6409147 5258 OTHER SVS 10,808.00 780,780.00 769,036.00 2,830.00 5,740.00 763,050.00 -.8% 6409147 5600 CONTR FA -15,933.50 .00 .00 .00 .00 .00 .0%

TOTAL PALM AVE WTR MAIN REPL .00 780,780.00 769,036.00 6,003.92 10,520.00 763,050.00 -.8% ____________________________________________
6409148 NEW WELL CHINO BASIN & PIPELIN
6409148 5258 OTHER SVS .00 1,187,270.00 1,187,270.00 .00 .00 1,187,270.00 .0%

TOTAL NEW WELL CHINO BASIN & .00 1,187,270.00 1,187,270.00 .00 .00 1,187,270.00 .0% ____________________________________________
6409149 STORM WTR TRASH CAPT DEV
6409149 5258 OTHER SVS .00 599,390.00 599,390.00 .00 .00 599,390.00 .0%

TOTAL STORM WTR TRASH CAPT D .00 599,390.00 599,390.00 .00 .00 599,390.00 .0% ____________________________________________
6409152 GROVE AVE WATER MAIN REPL
6409152 5111 SALARY-FT 2,568.80 .00 .00 .00 .00 .00 .0% 6409152 5116 FRINGE BEN 547.23 .00 .00 .00 .00 .00 .0%

Page 177 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 101
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL GROVE AVE WATER MAIN R .00 991,620.00 991,298.00 .00 .00 1,506,300.00 52.0% ____________________________________________
6409305 UPDATE SWR MODEL
6409305 5111 SALARY-FT 4,353.19 .00 .00 585.20 1,090.00 .00 .0% 6409305 5116 FRINGE BEN 1,170.48 .00 .00 104.38 200.00 .00 .0% 6409305 5117 RETIR CNTR 503.53 .00 .00 60.99 110.00 .00 .0%

TOTAL UPDATE SWR MODEL 6,027.20 .00 .00 750.57 1,400.00 .00 .0% TOTAL WATER UTILITY 24,750,299.18 45,162,860.00 45,900,086.00 38,100,592.14 17,515,530.00 47,648,290.00 3.8%

Page 178 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 102
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL SOLID WASTE UTILITY 265,000.00 265,000.00 265,000.00 265,000.00 265,000.00 265,000.00 .0% ____________________________________________
6416205 PRODUCTION/STORAGE
6416205 5212 ADVERTISNG 233.22 .00 .00 .00 .00 .00 .0%

TOTAL PRODUCTION/STORAGE 233.22 .00 .00 .00 .00 .00 .0% ____________________________________________
6416213 CUSTOMER SVC - FINANCE
6416213 5211 POSTAGE 19,405.93 22,000.00 22,000.00 22,000.00 22,000.00 22,000.00 .0% 6416213 5216 OFFIC SUPP 1,458.23 2,200.00 2,200.00 2,200.00 2,200.00 2,200.00 .0% 6416213 5218 UNIFRM EXP .00 3,850.00 3,850.00 .00 3,850.00 3,850.00 .0% 6416213 5234 OTH EQ RNT 1,863.44 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 .0% 6416213 5258 OTHER SVS 9,498.26 14,070.00 14,070.00 11,004.05 14,070.00 14,070.00 .0%

TOTAL CUSTOMER SVC - FINANCE 32,225.86 44,120.00 44,120.00 37,204.05 44,120.00 44,120.00 .0% ____________________________________________
6416301 SOLID WASTE
6416301 5111 SALARY-FT 279,098.02 345,520.00 346,786.00 227,125.32 260,790.00 392,380.00 13.1% 6416301 5111 16110 SALARY-FT 710.59 .00 .00 .00 .00 .00 .0% 6416301 5111 16111 SALARY-FT 385.60 .00 .00 .00 .00 .00 .0% 6416301 5111 50105 SALARY-FT 47.34 .00 .00 .00 .00 .00 .0% 6416301 5112 SALARY-PT 675.90 26,920.00 26,920.00 4,406.48 6,070.00 29,250.00 8.7% 6416301 5113 OVERTIME 3.66 .00 .00 5.33 10.00 .00 .0% 6416301 5116 FRINGE BEN 56,509.25 93,750.00 94,181.00 49,650.06 57,580.00 106,680.00 13.3% 6416301 5116 16110 FRINGE BEN 97.37 .00 .00 .00 .00 .00 .0% 6416301 5116 16111 FRINGE BEN 63.93 .00 .00 .00 .00 .00 .0% 6416301 5116 50105 FRINGE BEN 10.16 .00 .00 .00 .00 .00 .0% 6416301 5117 RETIR CNTR 27,164.49 35,580.00 35,712.00 22,237.17 26,190.00 40,340.00 13.0% 6416301 5117 16110 RETIR CNTR 76.91 .00 .00 .00 .00 .00 .0% 6416301 5117 16111 RETIR CNTR 39.31 .00 .00 .00 .00 .00 .0% 6416301 5117 50105 RETIR CNTR 4.94 .00 .00 .00 .00 .00 .0% 6416301 5119 UAL PERS 111,281.22 .00 .00 .00 .00 .00 .0% 6416301 5119 16110 UAL PERS 229.15 .00 .00 .00 .00 .00 .0% 6416301 5119 16111 UAL PERS 124.35 .00 .00 .00 .00 .00 .0% 6416301 5119 50105 UAL PERS 15.28 .00 .00 .00 .00 .00 .0% 6416301 5211 POSTAGE 5,012.82 25,000.00 25,000.00 4,921.06 25,000.00 25,000.00 .0%

Page 179 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 103
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SOLID WASTE UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 6416301 5212 ADVERTISNG 628.88 2,000.00 2,000.00 158.88 3,000.00 3,000.00 50.0% 6416301 5213 DUES&SUBSC 623.00 1,200.00 1,200.00 390.00 1,200.00 1,200.00 .0% 6416301 5215 TRNG/CONF 40.00 1,250.00 1,250.00 310.00 2,800.00 2,800.00 124.0% 6416301 5216 OFFIC SUPP 18.31 1,500.00 1,500.00 237.38 1,500.00 1,500.00 .0% 6416301 5217 OTHER SUPP 2,399.24 2,320.00 2,320.00 562.50 2,320.00 2,320.00 .0% 6416301 5218 UNIFRM EXP 88.58 .00 .00 10.50 .00 .00 .0% 6416301 5222 PRNT/MAIL .00 .00 .00 63.57 .00 .00 .0% 6416301 5223 INFO SYS 23,050.00 .00 .00 .00 .00 .00 .0% 6416301 5225 BLDG MT&OP 1,120.00 .00 .00 .00 .00 .00 .0% 6416301 5231 FURN&OFFC 78.66 .00 .00 215.49 .00 .00 .0% 6416301 5232 COMP EQUIP 99.92 .00 .00 .00 .00 .00 .0% 6416301 5234 OTH EQ RNT .00 1,900.00 1,900.00 .00 1,900.00 1,900.00 .0% 6416301 5243 UTL-TELEPH 80.75 .00 .00 100.37 .00 .00 .0% 6416301 5244 UTL-WATER .00 .00 .00 .00 .00 1,760.00 .0% 6416301 5251 LEGAL SVS 2,093.50 3,000.00 3,000.00 10,000.00 3,000.00 3,000.00 .0% 6416301 5252 PROF SVS 3,937.34 29,010.00 21,698.00 2,687.66 4,010.00 4,010.00 -81.5% 6416301 5253 CONTRC SVS 4,576.42 5,000.00 5,375.00 3,211.51 5,375.00 5,375.00 .0% 6416301 5254 DATA P SVS 3,357.90 3,810.00 3,810.00 3,525.78 3,810.00 3,810.00 .0% 6416301 5255 BANKNG SVS 11,839.86 3,500.00 3,500.00 5,354.44 3,500.00 3,500.00 .0% 6416301 5256 SW SVS 12,996,810.44 13,310,700.00 13,310,700.00 16,257,251.79 13,976,235.00 13,976,240.00 5.0% 6416301 5258 OTHER SVS 15,718.98 50,000.00 50,000.00 25,308.69 50,000.00 50,000.00 .0% 6416301 5273 WK CMP CHG 43,170.00 .00 .00 .00 .00 .00 .0% 6416301 5274 UNEMPL CHG 1,460.00 .00 .00 .00 .00 .00 .0% 6416301 5275 LT DIS CHG 2,810.00 .00 .00 .00 .00 .00 .0% 6416301 5276 LIAB CHG 54,800.00 .00 .00 .00 .00 .00 .0% 6416301 5277 LOSS PREV 2,800.00 .00 .00 .00 .00 .00 .0% 6416301 5291 BAD DB EXP 6,915.21 .00 .00 425.28 .00 .00 .0% 6416301 5292 ADM SV EXP 481,775.00 481,780.00 546,540.00 481,780.00 559,710.00 559,710.00 2.4% 6416301 5324 OPEB 3,790.00 .00 .00 .00 .00 .00 .0% 6416301 5325 PEN EXP 131,793.62 .00 .00 .00 .00 .00 .0% 6416301 5701 INFO SYS .00 54,740.00 54,740.00 50,182.00 54,740.00 56,630.00 3.5% 6416301 5704 BDG MT ALC .00 9,940.00 9,940.00 9,108.00 9,940.00 5,240.00 -47.3% 6416301 5705 SF LIAB .00 99,860.00 99,860.00 91,542.00 99,860.00 117,690.00 17.9% 6416301 5706 OPB&BN ALC .00 16,090.00 19,750.00 14,740.00 16,090.00 14,750.00 -25.3% 6416301 5707 PERSUALALC .00 102,120.00 102,120.00 93,610.00 102,120.00 .00 -100.0%

TOTAL SOLID WASTE 14,277,425.90 14,706,490.00 14,769,802.00 17,359,121.26 15,276,750.00 15,408,085.00 4.3% ____________________________________________
6416302 HOUSEHOLD HAZARDOUS WASTE
6416302 5111 SALARY-FT 1,858.75 4,990.00 4,990.00 1,007.93 .00 4,930.00 -1.2% 6416302 5112 SALARY-PT 2,971.55 40,440.00 40,440.00 1,525.79 3,130.00 40,440.00 .0% 6416302 5113 OVERTIME 54,994.91 60,000.00 60,000.00 52,098.64 60,330.00 58,000.00 -3.3% 6416302 5116 FRINGE BEN 11,663.03 2,640.00 2,640.00 10,680.18 13,330.00 2,640.00 .0%

Page 180 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 104
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL HOUSEHOLD HAZARDOUS WA 153,296.68 215,390.00 268,890.00 180,867.76 194,065.00 223,825.00 -16.8% ____________________________________________
6416303 SHARPS PROGRAM
6416303 5212 ADVERTISNG .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6416303 5217 OTHER SUPP 1,289.34 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%

TOTAL SHARPS PROGRAM 1,289.34 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% ____________________________________________
6416312 BEVERAGE RECYCLING GRANT
6416312 5112 SALARY-PT 93.41 950.00 950.00 .00 .00 950.00 .0% 6416312 5116 FRINGE BEN 1.37 10.00 10.00 .00 .00 10.00 .0%

TOTAL BEVERAGE RECYCLING GRA 94.78 960.00 960.00 .00 .00 960.00 .0% ____________________________________________
6416315 BEVERAGE RECY GRANT
6416315 5217 40051 OTHER SUPP 2,478.26 .00 .00 .00 .00 .00 .0%

TOTAL BEVERAGE RECY GRANT 2,478.26 .00 .00 .00 .00 .00 .0% ____________________________________________
6416329 USED OIL BLOCK GRANT - OPP10
6416329 5217 OTHER SUPP 1,420.15 .00 .00 .00 .00 .00 .0% 6416329 5253 CONTRC SVS 19,733.85 .00 .00 .00 .00 .00 .0%

TOTAL USED OIL BLOCK GRANT - 21,154.00 .00 .00 .00 .00 .00 .0% ____________________________________________
6419501 HHW CANOPY IMPROVEMENTS
6419501 5111 SALARY-FT 192.90 .00 .00 407.59 760.00 .00 .0% 6419501 5116 FRINGE BEN 43.73 .00 .00 47.15 70.00 .00 .0% 6419501 5117 RETIR CNTR 22.31 .00 .00 42.48 80.00 .00 .0% 6419501 5119 UAL PERS 62.20 .00 .00 .00 .00 .00 .0% 6419501 5258 OTHER SVS 55,000.00 55,000.00 .00 .00 500.00 .00 .0%

Page 181 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 105
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL HHW CANOPY IMPROVEMENT .00 55,000.00 .00 497.22 1,410.00 .00 .0% ____________________________________________
6419502 DOWNTOWN TRASH ENCLOSURES
6419502 5111 SALARY-FT 98.27 .00 .00 250.59 510.00 .00 .0% 6419502 5116 FRINGE BEN 19.81 .00 .00 49.72 100.00 .00 .0% 6419502 5117 RETIR CNTR 11.37 .00 .00 26.11 50.00 .00 .0% 6419502 5119 UAL PERS 31.69 .00 .00 .00 .00 .00 .0% 6419502 5258 OTHER SVS .00 89,840.00 89,840.00 .00 330.00 119,510.00 33.0% 6419502 5600 CONTR FA -161.14 .00 .00 .00 .00 .00 .0%

TOTAL DOWNTOWN TRASH ENCLOSU .00 89,840.00 89,840.00 326.42 990.00 119,510.00 33.0% TOTAL SOLID WASTE UTILITY 14,753,198.04 15,378,800.00 15,440,612.00 17,843,016.71 15,784,335.00 16,063,500.00 4.0%

Page 182 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 106
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL NEW CIP .00 .00 .00 .00 161,900.00 650,000.00 .0% ____________________________________________
6456213 CUSTOMER SVC - FINANCE
6456213 5211 POSTAGE 21,346.52 27,000.00 27,000.00 27,000.00 27,000.00 27,000.00 .0% 6456213 5216 OFFIC SUPP 1,604.03 2,600.00 2,600.00 2,600.00 2,600.00 2,600.00 .0% 6456213 5218 UNIFRM EXP .00 3,850.00 3,850.00 .00 3,850.00 3,850.00 .0% 6456213 5234 OTH EQ RNT 1,863.44 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 .0% 6456213 5258 OTHER SVS 10,448.07 16,070.00 16,070.00 13,004.46 16,070.00 16,070.00 .0%

TOTAL CUSTOMER SVC - FINANCE 35,262.06 51,520.00 51,520.00 44,604.46 51,520.00 51,520.00 .0% ____________________________________________
6456401 LANDFILL SITE MAINTENANCE
6456401 5111 SALARY-FT 68,841.79 97,930.00 97,930.00 70,392.69 84,410.00 93,660.00 -4.4% 6456401 5116 FRINGE BEN 19,866.20 25,610.00 25,610.00 15,433.33 20,630.00 24,990.00 -2.4% 6456401 5117 RETIR CNTR 8,961.06 10,180.00 10,180.00 6,582.14 8,740.00 10,240.00 .6% 6456401 5119 UAL PERS 24,335.64 .00 .00 .00 .00 .00 .0% 6456401 5211 POSTAGE 65.30 300.00 300.00 266.20 340.00 300.00 .0% 6456401 5213 DUES&SUBSC .00 250.00 250.00 346.00 350.00 370.00 48.0% 6456401 5215 TRNG/CONF 91.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6456401 5216 OFFIC SUPP 18.62 250.00 250.00 44.35 250.00 250.00 .0% 6456401 5217 OTHER SUPP 1,724.91 14,300.00 14,300.00 991.31 20,260.00 25,200.00 76.2% 6456401 5218 UNIFRM EXP .00 .00 .00 .00 300.00 490.00 .0% 6456401 5219 PERM/LC/FE 17,396.18 22,000.00 22,000.00 20,694.00 25,000.00 23,150.00 5.2% 6456401 5222 PRINTING 131.95 150.00 150.00 5.68 100.00 100.00 -33.3% 6456401 5223 INFO SYS 450.00 .00 .00 .00 .00 .00 .0% 6456401 5224 VEH CHRG 40.00 .00 .00 .00 .00 .00 .0% 6456401 5233 OTHR EQUIP 779.94 850.00 850.00 1,061.16 1,150.00 1,200.00 41.2% 6456401 5241 UTL-ELECTR 775.96 2,200.00 2,200.00 835.32 2,200.00 2,200.00 .0% 6456401 5246 MAINT-EQP 61.24 600.00 600.00 1,329.99 1,030.00 650.00 8.3% 6456401 5252 PROF SVS 4,215.00 15,000.00 15,000.00 8,718.50 47,640.00 70,000.00 366.7% 6456401 5258 OTHER SVS 70,023.37 73,500.00 73,500.00 73,000.00 78,500.00 95,000.00 29.3% 6456401 5701 INFO SYS .00 450.00 450.00 418.00 450.00 450.00 .0% 6456401 5702 FLT-MT&RP .00 560.00 560.00 517.00 560.00 90.00 -83.9%

TOTAL LANDFILL SITE MAINTENA 217,778.16 265,130.00 265,130.00 200,635.67 292,910.00 349,340.00 31.8% ____________________________________________
6456402 SEWER MAINTENANCE & OPERATIONS
6456402 5110 BUY BACKS 1,576.55 1,630.00 1,630.00 .00 .00 .00 -100.0%

Page 183 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 107
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SEWER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 6456402 5111 SALARY-FT 619,204.91 789,010.00 791,543.00 452,166.39 575,290.00 763,470.00 -3.5% 6456402 5111 16110 SALARY-FT 1,403.75 .00 .00 .00 .00 .00 .0% 6456402 5111 16111 SALARY-FT 1,051.76 .00 .00 .00 .00 .00 .0% 6456402 5111 50105 SALARY-FT 176.92 .00 .00 .00 .00 .00 .0% 6456402 5112 SALARY-PT 624.28 8,370.00 8,370.00 989.93 1,380.00 4,540.00 -45.8% 6456402 5113 OVERTIME 6,409.88 .00 .00 5,814.88 10,400.00 12,480.00 .0% 6456402 5116 FRINGE BEN 133,226.16 206,470.00 207,332.00 93,345.02 120,470.00 205,280.00 -1.0% 6456402 5116 16110 FRINGE BEN 210.40 .00 .00 .00 .00 .00 .0% 6456402 5116 16111 FRINGE BEN 181.68 .00 .00 .00 .00 .00 .0% 6456402 5116 50105 FRINGE BEN 36.75 .00 .00 .00 .00 .00 .0% 6456402 5117 RETIR CNTR 62,000.40 79,370.00 79,634.00 44,276.77 56,790.00 77,880.00 -2.2% 6456402 5117 16110 RETIR CNTR 151.48 .00 .00 .00 .00 .00 .0% 6456402 5117 16111 RETIR CNTR 107.05 .00 .00 .00 .00 .00 .0% 6456402 5117 50105 RETIR CNTR 18.36 .00 .00 .00 .00 .00 .0% 6456402 5119 UAL PERS 233,911.11 .00 .00 .00 .00 .00 .0% 6456402 5119 16110 UAL PERS 452.67 .00 .00 .00 .00 .00 .0% 6456402 5119 16111 UAL PERS 339.17 .00 .00 .00 .00 .00 .0% 6456402 5119 50105 UAL PERS 57.05 .00 .00 .00 .00 .00 .0% 6456402 5211 POSTAGE 4,908.62 33,500.00 33,500.00 4,892.80 33,500.00 33,500.00 .0% 6456402 5212 ADVERTISNG 233.23 250.00 250.00 158.89 250.00 250.00 .0% 6456402 5213 DUES&SUBSC 1,861.00 2,340.00 2,340.00 865.00 2,400.00 2,820.00 20.5% 6456402 5215 TRNG/CONF .00 3,600.00 3,600.00 4,209.92 4,190.00 4,000.00 11.1% 6456402 5216 OFFIC SUPP 86.18 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 6456402 5217 OTHER SUPP 40,965.70 64,500.00 64,500.00 49,343.83 64,500.00 80,630.00 25.0% 6456402 5217 16110 OTHER SUPP 2,577.36 .00 .00 .00 .00 .00 .0% 6456402 5218 UNIFRM EXP 692.80 13,440.00 13,440.00 12,400.85 13,440.00 16,370.00 21.8% 6456402 5220 FUEL USAGE 26,914.22 26,000.00 26,000.00 22,465.27 32,500.00 35,000.00 34.6% 6456402 5223 INFO SYS 63,360.00 .00 .00 .00 .00 .00 .0% 6456402 5224 VEH CHRG 53,190.00 .00 .00 .00 .00 .00 .0% 6456402 5225 BLDG MT&OP 1,870.00 .00 .00 .00 .00 .00 .0% 6456402 5232 COMP EQUIP 207.64 .00 .00 .00 .00 .00 .0% 6456402 5233 OTHR EQUIP 1,179.61 3,500.00 3,500.00 7,877.89 8,820.00 4,380.00 25.1% 6456402 5234 OTH EQ RNT .00 3,500.00 3,500.00 .00 3,500.00 3,500.00 .0% 6456402 5243 UTL-TELEPH 80.77 .00 .00 100.37 .00 .00 .0% 6456402 5244 UTL-WATER 7,214.77 70,000.00 70,000.00 .00 .00 70,000.00 .0% 6456402 5246 MAINT-EQP 135.00 150.00 150.00 2,686.17 2,500.00 5,000.00 3233.3% 6456402 5247 MAINT-VEH 2,718.24 .00 .00 .00 .00 .00 .0% 6456402 5251 LEGAL SVS .00 .00 .00 5,000.00 .00 .00 .0% 6456402 5252 PROF SVS 4,124.67 21,080.00 23,896.00 26,038.33 4,230.00 4,230.00 -82.3% 6456402 5253 CONTRC SVS 17,576.42 45,000.00 45,375.00 29,080.25 45,375.00 51,250.00 12.9% 6456402 5254 DATA P SVS 3,357.90 3,810.00 3,810.00 3,525.79 3,810.00 3,810.00 .0% 6456402 5255 BANKNG SVS 11,701.21 3,980.00 3,980.00 5,354.43 3,980.00 3,980.00 .0% 6456402 5257 SWR DSP SV 61,671.35 47,000.00 47,000.00 45,177.76 47,000.00 50,000.00 6.4% 6456402 5258 OTHER SVS 132,326.80 250,000.00 250,000.00 127,751.29 250,000.00 250,000.00 .0%

Page 184 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 108
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL SEWER MAINTENANCE & OP 2,764,078.34 2,712,170.00 2,780,957.00 1,804,230.77 2,370,645.00 3,271,940.00 17.7% ____________________________________________
6456403 SEWER - RESIDENTIAL
6456403 5111 SALARY-FT 121,580.24 164,270.00 164,270.00 95,188.13 109,330.00 163,850.00 -.3% 6456403 5112 SALARY-PT 14.81 6,880.00 6,880.00 2,434.37 3,020.00 3,400.00 -50.6% 6456403 5116 FRINGE BEN 29,665.28 43,980.00 43,980.00 22,306.76 27,910.00 43,620.00 -.8% 6456403 5117 RETIR CNTR 13,790.35 17,080.00 17,080.00 9,024.31 11,170.00 17,920.00 4.9% 6456403 5119 UAL PERS 35,151.83 .00 .00 .00 .00 .00 .0% 6456403 5211 POSTAGE .00 2,500.00 2,500.00 .00 100.00 100.00 -96.0% 6456403 5215 TRNG/CONF .00 1,200.00 1,200.00 .00 500.00 1,200.00 .0% 6456403 5216 OFFIC SUPP 112.08 500.00 500.00 500.00 200.00 500.00 .0% 6456403 5217 OTHER SUPP .00 1,500.00 1,500.00 .00 1,000.00 1,500.00 .0% 6456403 5219 PERM/LC/FE 15,907.00 18,200.00 18,200.00 18,472.00 18,480.00 22,190.00 21.9% 6456403 5220 FUEL USAGE 2,603.78 3,000.00 3,000.00 825.87 3,000.00 3,500.00 16.7% 6456403 5222 PRINTING .00 .00 .00 63.57 .00 .00 .0% 6456403 5223 INFO SYS 2,220.00 .00 .00 .00 .00 .00 .0% 6456403 5224 VEH CHRG 9,470.00 .00 .00 .00 .00 .00 .0% 6456403 5257 SWR DSP SV 6,539,634.36 7,090,930.00 7,090,930.00 7,090,929.99 7,096,680.00 7,469,200.00 5.3% 6456403 5258 OTHER SVS 1,383.68 33,300.00 33,300.00 27.50 22,650.00 30,150.00 -9.5% 6456403 5280 DEPR-LND I 987.00 .00 .00 .00 .00 .00 .0% 6456403 5283 DEPR-M&EQP 33,117.89 .00 .00 .00 .00 .00 .0% 6456403 5284 DEPR-VEH 207,457.05 .00 .00 .00 .00 .00 .0% 6456403 5291 BAD DB EXP 6,643.18 .00 .00 503.74 .00 .00 .0%

Page 185 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 109
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL SEWER - RESIDENTIAL 7,491,736.53 7,866,970.00 7,954,680.00 7,722,935.24 7,852,210.00 8,313,400.00 4.5% ____________________________________________
6456404 SEWER - NON RESIDENTIAL
6456404 5111 SALARY-FT 55,878.92 99,910.00 99,910.00 57,664.08 53,900.00 94,910.00 -5.0% 6456404 5116 FRINGE BEN 14,119.79 25,410.00 25,410.00 12,039.78 13,230.00 24,680.00 -2.9% 6456404 5117 RETIR CNTR 6,378.61 10,390.00 10,390.00 5,130.08 5,550.00 10,380.00 -.1% 6456404 5119 UAL PERS 24,720.00 .00 .00 .00 .00 .00 .0% 6456404 5211 POSTAGE .00 100.00 100.00 .00 50.00 100.00 .0% 6456404 5213 DUES&SUBSC 828.00 1,900.00 1,900.00 300.00 1,780.00 1,600.00 -15.8% 6456404 5215 TRNG/CONF 50.00 2,500.00 2,500.00 .00 2,000.00 2,500.00 .0% 6456404 5216 OFFIC SUPP .00 200.00 200.00 .00 200.00 100.00 -50.0% 6456404 5217 OTHER SUPP 633.94 2,000.00 2,000.00 12.73 2,000.00 2,000.00 .0% 6456404 5218 UNIFRM EXP 298.89 250.00 250.00 .00 250.00 400.00 60.0% 6456404 5219 PERM/LC/FE 101.00 .00 .00 101.00 .00 .00 .0% 6456404 5220 FUEL USAGE 3,502.09 4,000.00 4,000.00 1,831.77 4,000.00 4,500.00 12.5% 6456404 5223 INFO SYS 4,220.00 .00 .00 .00 .00 .00 .0% 6456404 5224 VEH CHRG 4,450.00 .00 .00 .00 .00 .00 .0% 6456404 5232 COMP EQUIP .00 .00 .00 .00 .00 2,200.00 .0% 6456404 5251 LEGAL SVS .00 50,000.00 50,000.00 .00 50,000.00 50,000.00 .0% 6456404 5257 SWR DSP SV .00 30,000.00 30,000.00 .00 30,000.00 30,000.00 .0% 6456404 5258 OTHER SVS 70,457.54 260,000.00 260,000.00 420.59 260,000.00 260,000.00 .0% 6456404 5701 INFO SYS .00 2,380.00 2,380.00 2,178.00 2,380.00 2,380.00 .0% 6456404 5702 FLT-MT&RP .00 5,460.00 5,460.00 5,005.00 5,460.00 6,910.00 26.6%

TOTAL SEWER - NON RESIDENTIA 185,638.78 494,500.00 494,500.00 84,683.03 430,800.00 492,660.00 -.4% ____________________________________________
6457500 CAPITAL PROJECTS
6457500 5258 94001 OTHER SVS 86,800.00 413,200.00 413,200.00 141,500.00 138,500.00 274,700.00 -33.5% 6457500 5258 94002 OTHER SVS .00 100,000.00 100,000.00 .00 .00 150,000.00 50.0% 6457500 5258 94003 OTHER SVS .00 275,000.00 275,000.00 .00 .00 300,000.00 9.1% 6457500 5258 94004 OTHER SVS .00 200,000.00 200,000.00 .00 .00 200,000.00 .0% 6457500 5258 94005 OTHER SVS .00 400,000.00 400,000.00 .00 .00 400,000.00 .0% 6457500 5600 94001 CONTR FA -86,800.00 .00 .00 .00 .00 .00 .0%

TOTAL CAPITAL PROJECTS .00 1,388,200.00 1,388,200.00 141,500.00 138,500.00 1,324,700.00 -4.6% ____________________________________________
6459301 UPLND LNDFLL PST-CLSR PLN
6459301 5111 SALARY-FT .00 .00 .00 1,403.33 2,530.00 .00 .0%

Page 186 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 110
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL UPLND LNDFLL PST-CLSR .00 100,000.00 100,000.00 26,821.17 4,970.00 98,180.00 -1.8% ____________________________________________
6459324 LDFILL FLARE SUPP GAS LINE
6459324 5111 SALARY-FT 2,937.76 .00 .00 11,863.31 21,360.00 .00 .0% 6459324 5116 FRINGE BEN 720.41 .00 .00 2,676.35 5,070.00 .00 .0% 6459324 5117 RETIR CNTR 337.76 .00 .00 1,236.15 2,230.00 .00 .0% 6459324 5119 UAL PERS 519.60 .00 .00 .00 .00 .00 .0% 6459324 5212 ADVERTISNG .00 .00 .00 4,043.20 .00 .00 .0% 6459324 5222 PRINTING .00 .00 .00 1,497.54 .00 .00 .0% 6459324 5258 OTHER SVS .00 400,000.00 396,354.00 549.95 21,710.00 374,460.00 -5.5% 6459324 5600 CONTR FA -4,515.53 .00 .00 .00 .00 .00 .0%

TOTAL LDFILL FLARE SUPP GAS .00 400,000.00 396,354.00 21,866.50 50,370.00 374,460.00 -5.5% ____________________________________________
6459330 RICHLAND ST TRUNK MAIN REPAIR
6459330 5258 OTHER SVS .00 75,000.00 75,000.00 .00 .00 75,000.00 .0%

TOTAL RICHLAND ST TRUNK MAIN .00 75,000.00 75,000.00 .00 .00 75,000.00 .0% ____________________________________________
6459331 CW SEWER REHABILITATION 19/20
6459331 5111 SALARY-FT 1,156.16 .00 .00 .00 .00 .00 .0% 6459331 5116 FRINGE BEN 242.03 .00 .00 .00 .00 .00 .0% 6459331 5117 RETIR CNTR 133.73 .00 .00 .00 .00 .00 .0% 6459331 5119 UAL PERS 26.41 .00 .00 .00 .00 .00 .0% 6459331 5258 OTHER SVS 144,726.37 .00 .00 .00 .00 .00 .0% 6459331 5600 CONTR FA -146,284.70 .00 .00 .00 .00 .00 .0%

TOTAL CW SEWER REHABILITATIO .00 .00 .00 .00 .00 .00 .0% TOTAL SEWER UTILITY 10,694,493.87 13,353,490.00 13,506,341.00 10,047,276.84 11,353,825.00 15,001,200.00 11.1%

Page 187 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 111
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SELF-FUNDED LIABILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7511601 HUMAN RESOURCES
7511601 5290 LATE CHARG 125.55 .00 .00 .00 .00 .00 .0% 7511601 5324 OPEB -47,636.00 .00 .00 .00 .00 .00 .0% 7511601 5325 PEN EXP 203,068.87 .00 .00 .00 .00 .00 .0%

TOTAL HUMAN RESOURCES 155,558.42 .00 .00 .00 .00 .00 .0% ____________________________________________
7511603 CITY ATTORNEY
7511603 5251 LEGAL SVS 1,170.00 .00 .00 .00 .00 .00 .0%

TOTAL CITY ATTORNEY 1,170.00 .00 .00 .00 .00 .00 .0% ____________________________________________
7511611 WORKERS COMPENSATION
7511611 5111 SALARY-FT 45,986.40 43,700.00 43,700.00 40,277.59 50,480.00 51,020.00 16.8% 7511611 5111 16110 SALARY-FT 1,495.43 .00 .00 .00 .00 .00 .0% 7511611 5111 16111 SALARY-FT 1,219.26 .00 .00 .00 .00 .00 .0% 7511611 5111 50105 SALARY-FT 75.48 .00 .00 .00 .00 .00 .0% 7511611 5116 FRINGE BEN 8,455.19 8,130.00 8,130.00 7,431.64 9,210.00 9,760.00 20.0% 7511611 5116 16110 FRINGE BEN 184.25 .00 .00 .00 .00 .00 .0% 7511611 5116 16111 FRINGE BEN 193.40 .00 .00 .00 .00 .00 .0% 7511611 5116 50105 FRINGE BEN 14.99 .00 .00 .00 .00 .00 .0% 7511611 5117 RETIR CNTR 4,620.16 4,520.00 4,520.00 3,602.87 4,520.00 5,540.00 22.6% 7511611 5117 16110 RETIR CNTR 152.05 .00 .00 .00 .00 .00 .0% 7511611 5117 16111 RETIR CNTR 123.96 .00 .00 .00 .00 .00 .0% 7511611 5117 50105 RETIR CNTR 7.68 .00 .00 .00 .00 .00 .0% 7511611 5119 UAL PERS 15,610.27 .00 .00 .00 .00 .00 .0% 7511611 5119 16110 UAL PERS 482.21 .00 .00 .00 .00 .00 .0% 7511611 5119 16111 UAL PERS 393.18 .00 .00 .00 .00 .00 .0% 7511611 5119 50105 UAL PERS 24.34 .00 .00 .00 .00 .00 .0% 7511611 5213 DUES&SUBSC .00 150.00 150.00 .00 .00 150.00 .0% 7511611 5215 TRNG/CONF .00 5,400.00 400.00 .00 .00 5,400.00 1250.0% 7511611 5216 OFFIC SUPP .00 500.00 .00 .00 .00 500.00 .0% 7511611 5219 PERM/LC/FE 43,754.50 63,000.00 91,800.00 91,758.48 91,800.00 91,800.00 .0% 7511611 5258 OTHER SVS 137,877.03 141,450.00 144,450.00 141,444.00 144,450.00 149,450.00 3.5% 7511611 5270 IBNR CLAIM -8,706.92 .00 .00 .00 .00 .00 .0% 7511611 5271 INS PREM 198,784.98 250,000.00 235,000.00 233,834.00 233,840.00 269,000.00 14.5% 7511611 5272 CLAIMS EXP 1,372,553.38 1,466,040.00 1,466,040.00 646,070.84 1,466,040.00 1,466,040.00 .0% 7511611 5299 PY EXP -1,327.00 .00 .00 -6,440.00 .00 .00 .0% 7511611 5706 OPB&BN ALC .00 1,680.00 1,920.00 1,540.00 1,680.00 1,670.00 -13.0% 7511611 5707 PERSUALALC .00 12,720.00 12,720.00 11,660.00 12,720.00 17,350.00 36.4%

Page 188 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 112
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL WORKERS COMPENSATION 1,821,974.22 1,997,290.00 2,008,830.00 1,171,179.42 2,014,740.00 2,067,680.00 2.9% ____________________________________________
7511612 UNEMPLOYMENT
7511612 5111 SALARY-FT 9,595.21 10,180.00 10,180.00 8,168.48 10,080.00 10,180.00 .0% 7511612 5111 16110 SALARY-FT 245.40 .00 .00 .00 .00 .00 .0% 7511612 5111 16111 SALARY-FT 154.61 .00 .00 .00 .00 .00 .0% 7511612 5116 FRINGE BEN 2,050.41 2,310.00 2,310.00 1,805.01 2,240.00 2,310.00 .0% 7511612 5116 16110 FRINGE BEN 26.87 .00 .00 .00 .00 .00 .0% 7511612 5116 16111 FRINGE BEN 22.97 .00 .00 .00 .00 .00 .0% 7511612 5117 RETIR CNTR 1,018.12 1,060.00 1,060.00 768.16 940.00 1,110.00 4.7% 7511612 5117 16110 RETIR CNTR 24.96 .00 .00 .00 .00 .00 .0% 7511612 5117 16111 RETIR CNTR 15.72 .00 .00 .00 .00 .00 .0% 7511612 5119 UAL PERS 3,321.02 .00 .00 .00 .00 .00 .0% 7511612 5119 16110 UAL PERS 79.12 .00 .00 .00 .00 .00 .0% 7511612 5119 16111 UAL PERS 49.86 .00 .00 .00 .00 .00 .0% 7511612 5258 OTHER SVS 1,695.00 3,000.00 2,080.00 1,756.75 1,740.00 2,000.00 -3.8% 7511612 5272 CLAIMS EXP 22,282.04 45,000.00 45,000.00 6,476.25 45,000.00 45,000.00 .0% 7511612 5272 16110 CLAIMS EXP -4,596.50 .00 .00 .00 .00 .00 .0% 7511612 5290 LATE CHARG .00 .00 .00 148.24 .00 .00 .0% 7511612 5706 OPB&BN ALC .00 410.00 650.00 330.00 410.00 370.00 -43.1% 7511612 5707 PERSUALALC .00 3,010.00 3,010.00 2,750.00 3,010.00 3,520.00 16.9%

TOTAL UNEMPLOYMENT 35,984.81 64,970.00 64,290.00 22,202.89 63,420.00 64,490.00 .3% ____________________________________________
7511613 LONG-TERM DISABILITY
7511613 5111 SALARY-FT 5,651.72 6,150.00 6,150.00 4,892.81 5,990.00 6,150.00 .0% 7511613 5111 16110 SALARY-FT 245.98 .00 .00 .00 .00 .00 .0% 7511613 5111 16111 SALARY-FT 155.18 .00 .00 .00 .00 .00 .0% 7511613 5116 FRINGE BEN 1,450.39 1,240.00 1,240.00 1,319.45 1,620.00 1,240.00 .0% 7511613 5116 16110 FRINGE BEN 26.88 .00 .00 .00 .00 .00 .0% 7511613 5116 16111 FRINGE BEN 23.07 .00 .00 .00 .00 .00 .0% 7511613 5117 RETIR CNTR 572.69 640.00 640.00 441.33 540.00 670.00 4.7% 7511613 5117 16110 RETIR CNTR 25.02 .00 .00 .00 .00 .00 .0% 7511613 5117 16111 RETIR CNTR 15.78 .00 .00 .00 .00 .00 .0% 7511613 5118 EMPL LTD 31,999.32 46,000.00 46,000.00 23,999.49 28,890.00 46,000.00 .0% 7511613 5119 UAL PERS 1,950.66 .00 .00 .00 .00 .00 .0% 7511613 5119 16110 UAL PERS 79.30 .00 .00 .00 .00 .00 .0% 7511613 5119 16111 UAL PERS 50.04 .00 .00 .00 .00 .00 .0% 7511613 5271 INS PREM 32,858.48 69,070.00 34,070.00 30,650.73 34,000.00 34,000.00 -.2% 7511613 5706 OPB&BN ALC .00 230.00 470.00 220.00 230.00 220.00 -53.2% 7511613 5707 PERSUALALC .00 1,670.00 1,670.00 1,540.00 1,670.00 2,170.00 29.9%

Page 189 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 113
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL LONG-TERM DISABILITY 75,104.51 125,000.00 90,240.00 63,063.81 72,940.00 90,450.00 .2% ____________________________________________
7511614 LIABILITY
7511614 5111 SALARY-FT 59,766.76 75,760.00 75,760.00 46,686.81 58,320.00 83,270.00 9.9% 7511614 5111 16110 SALARY-FT 1,494.59 .00 .00 .00 .00 .00 .0% 7511614 5111 16111 SALARY-FT 1,219.26 .00 .00 .00 .00 .00 .0% 7511614 5111 50105 SALARY-FT 75.48 .00 .00 .00 .00 .00 .0% 7511614 5116 FRINGE BEN 10,242.79 17,210.00 17,210.00 8,850.98 10,950.00 18,870.00 9.6% 7511614 5116 16110 FRINGE BEN 184.08 .00 .00 .00 .00 .00 .0% 7511614 5116 16111 FRINGE BEN 193.40 .00 .00 .00 .00 .00 .0% 7511614 5116 50105 FRINGE BEN 14.99 .00 .00 .00 .00 .00 .0% 7511614 5117 RETIR CNTR 5,493.47 7,850.00 7,850.00 4,256.21 5,310.00 9,060.00 15.4% 7511614 5117 16110 RETIR CNTR 151.97 .00 .00 .00 .00 .00 .0% 7511614 5117 16111 RETIR CNTR 123.96 .00 .00 .00 .00 .00 .0% 7511614 5117 50105 RETIR CNTR 7.68 .00 .00 .00 .00 .00 .0% 7511614 5119 UAL PERS 18,250.54 .00 .00 .00 .00 .00 .0% 7511614 5119 16110 UAL PERS 481.94 .00 .00 .00 .00 .00 .0% 7511614 5119 16111 UAL PERS 393.18 .00 .00 .00 .00 .00 .0% 7511614 5119 50105 UAL PERS 24.34 .00 .00 .00 .00 .00 .0% 7511614 5211 POSTAGE .00 100.00 100.00 .00 .00 .00 -100.0% 7511614 5251 LEGAL SVS 80,495.48 100,000.00 474,000.00 240,864.30 434,600.00 100,000.00 -78.9% 7511614 5258 OTHER SVS 65,546.96 50,000.00 50,000.00 48,528.50 47,650.00 47,650.00 -4.7% 7511614 5270 IBNR CLAIM -748,551.44 .00 .00 .00 .00 .00 .0% 7511614 5271 INS PREM 987,637.65 1,140,000.00 1,390,620.00 1,390,617.44 1,390,620.00 1,599,220.00 15.0% 7511614 5272 CLAIMS EXP 2,088,620.80 1,000,000.00 1,000,000.00 702,805.55 1,000,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 5425 BND INT EX 1,223.10 .00 .00 .00 .00 .00 .0% 7511614 5706 OPB&BN ALC .00 3,110.00 3,350.00 2,860.00 3,110.00 2,880.00 -14.0% 7511614 5707 PERSUALALC .00 22,100.00 22,100.00 20,240.00 22,100.00 28,470.00 28.8%

TOTAL LIABILITY 2,660,777.71 2,503,830.00 3,128,690.00 2,553,396.52 3,060,360.00 2,977,120.00 -4.8% ____________________________________________
7511615 LOSS PREVENTION
7511615 5111 SALARY-FT 29,941.15 31,800.00 31,800.00 25,210.55 30,330.00 33,210.00 4.4% 7511615 5116 FRINGE BEN 6,130.56 8,440.00 8,440.00 4,932.18 6,020.00 8,570.00 1.5% 7511615 5117 RETIR CNTR 3,439.97 3,310.00 3,310.00 2,612.40 3,140.00 3,630.00 9.7% 7511615 5119 UAL PERS 10,340.00 .00 .00 .00 .00 .00 .0% 7511615 5213 DUES&SUBSC .00 100.00 100.00 .00 .00 .00 -100.0% 7511615 5215 TRNG/CONF .00 2,000.00 2,000.00 .00 .00 .00 -100.0% 7511615 5217 OTHER SUPP .00 .00 .00 43.58 .00 .00 .0% 7511615 5258 OTHER SVS 11,165.88 70,830.00 20,830.00 13,966.50 15,000.00 15,000.00 -28.0%

Page 190 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 114
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SELF-FUNDED LIABILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 7511615 5706 OPB&BN ALC .00 1,400.00 1,650.00 1,320.00 1,400.00 1,210.00 -26.7% 7511615 5707 PERSUALALC .00 9,380.00 9,380.00 8,580.00 9,380.00 11,390.00 21.4%

TOTAL LOSS PREVENTION 61,017.56 127,260.00 77,510.00 56,665.21 65,270.00 73,010.00 -5.8% TOTAL SELF-FUNDED LIABILITY 4,811,587.23 4,818,350.00 5,369,560.00 3,866,507.85 5,276,730.00 5,272,750.00 -1.8%

Page 191 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 115
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7521301 ACCOUNTING SERVICES
7521301 5227 PART/REP 277.30 .00 .00 22.18 .00 .00 .0%

TOTAL ACCOUNTING SERVICES 277.30 .00 .00 22.18 .00 .00 .0% ____________________________________________
7521302 MAIL/PRINTING SERVICES
7521302 5227 PART/REP 222.54 .00 .00 7.98 .00 .00 .0% 7521302 5531 VEHICLES .00 250.00 250.00 250.00 250.00 .00 -100.0%

TOTAL MAIL/PRINTING SERVICES 222.54 250.00 250.00 257.98 250.00 .00 -100.0% ____________________________________________
7521401 INFORMATION SYSTEMS
7521401 5227 PART/REP 51.82 .00 .00 525.51 .00 .00 .0%

TOTAL INFORMATION SYSTEMS 51.82 .00 .00 525.51 .00 .00 .0% ____________________________________________
7522201 BUILDING AND SAFETY
7522201 5227 PART/REP 1,054.69 .00 .00 72.02 .00 .00 .0%

TOTAL BUILDING AND SAFETY 1,054.69 .00 .00 72.02 .00 .00 .0% ____________________________________________
7522202 WEED ABATEMENT
7522202 5227 PART/REP 42.45 .00 .00 17.09 .00 .00 .0%

TOTAL WEED ABATEMENT 42.45 .00 .00 17.09 .00 .00 .0% ____________________________________________
7522931 HOUSING ADMINISTRATION
7522931 5246 MAINT-EQP 168.00 .00 .00 .00 .00 .00 .0% 7522931 5531 VEHICLES 5,820.27 .00 44,186.00 59,686.98 44,186.00 .00 -100.0%

TOTAL HOUSING ADMINISTRATION 5,988.27 .00 44,186.00 59,686.98 44,186.00 .00 -100.0% ____________________________________________
7523201 POLICE ADMINISTRATION
7523201 5227 PART/REP 3,554.27 .00 .00 1,332.47 .00 .00 .0% 7523201 5531 VEHICLES .00 165,000.00 437,168.00 84,479.84 192,968.00 59,600.00 -86.4%

TOTAL POLICE ADMINISTRATION 3,554.27 165,000.00 437,168.00 85,812.31 192,968.00 59,600.00 -86.4% ____________________________________________
7523202 POLICE INVESTIGATIONS
7523202 5227 PART/REP 3,229.03 .00 .00 4,729.58 .00 .00 .0%

Page 192 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 116
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 7523202 5531 VEHICLES .00 52,000.00 79,968.00 74,509.34 79,968.00 .00 -100.0%

TOTAL POLICE INVESTIGATIONS 3,229.03 52,000.00 79,968.00 79,238.92 79,968.00 .00 -100.0% ____________________________________________
7523205 ANIMAL SERVICES
7523205 5227 PART/REP 972.28 .00 .00 599.12 .00 .00 .0% 7523205 5531 VEHICLES .00 .00 68,849.00 76,448.34 68,849.00 .00 -100.0%

TOTAL ANIMAL SERVICES 972.28 .00 68,849.00 77,047.46 68,849.00 .00 -100.0% ____________________________________________
7523211 POLICE PATROL
7523211 5227 VEH PARTS 33,148.52 .00 .00 23,420.71 .00 .00 .0% 7523211 5233 OTHR EQUIP .00 .00 .00 773.18 .00 .00 .0% 7523211 5531 VEHICLES 58,210.25 206,900.00 263,600.00 54,526.22 206,900.00 .00 -100.0%

TOTAL POLICE PATROL 91,358.77 206,900.00 263,600.00 78,720.11 206,900.00 .00 -100.0% ____________________________________________
7523233 CODE ENFORCEMENT
7523233 5227 PART/REP 224.39 .00 .00 68.99 .00 .00 .0% 7523233 5531 VEHICLES 15,897.73 .00 3,603.00 3,602.27 3,603.00 .00 -100.0%

TOTAL CODE ENFORCEMENT 16,122.12 .00 3,603.00 3,671.26 3,603.00 .00 -100.0% ____________________________________________
7524201 RECREATION ADMINISTRATION
7524201 5227 PART/REP 224.22 .00 .00 529.02 .00 .00 .0%

TOTAL RECREATION ADMINISTRAT 224.22 .00 .00 529.02 .00 .00 .0% ____________________________________________
7524204 RECREATION PARKS
7524204 5531 VEHICLES .00 .00 .00 .00 .00 70,000.00 .0%

TOTAL RECREATION PARKS .00 .00 .00 .00 .00 70,000.00 .0% ____________________________________________
7525201 PUBLIC WORKS ADMINISTRATION
7525201 5227 PART/REP 214.30 .00 .00 91.57 .00 .00 .0% 7525201 5245 MAINT-BLDG .00 .00 .00 74.11 .00 .00 .0%

TOTAL PUBLIC WORKS ADMINISTR 214.30 .00 .00 165.68 .00 .00 .0% ____________________________________________
7525301 ENGINEERING ADMINISTRATION
7525301 5227 PART/REP 185.00 .00 .00 290.08 .00 .00 .0%

Page 193 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 117
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 7525301 5531 VEHICLES .00 .00 94,418.00 94,417.77 94,418.00 .00 -100.0%

TOTAL ENGINEERING ADMINISTRA 185.00 .00 94,418.00 94,707.85 94,418.00 .00 -100.0% ____________________________________________
7525302 DEVELOPMENT/TRAFFIC ENGINRG
7525302 5227 PART/REP 21.20 .00 .00 141.49 .00 .00 .0% 7525302 5531 VEHICLES .00 250.00 250.00 250.00 250.00 .00 -100.0%

TOTAL DEVELOPMENT/TRAFFIC EN 21.20 250.00 250.00 391.49 250.00 .00 -100.0% ____________________________________________
7525401 STREET MAINTENANCE
7525401 5227 PART/REP 6,263.51 .00 .00 4,910.89 .00 .00 .0% 7525401 5283 DEPR-M&EQP 44,656.35 .00 .00 .00 .00 .00 .0% 7525401 5531 VEHICLES 78,223.24 220,250.00 220,250.00 250.00 220,250.00 .00 -100.0%

TOTAL STREET MAINTENANCE 129,143.10 220,250.00 220,250.00 5,160.89 220,250.00 .00 -100.0% ____________________________________________
7525403 SIDEWALK MAINTENANCE
7525403 5227 PART/REP 135.84 .00 .00 358.61 .00 .00 .0%

TOTAL SIDEWALK MAINTENANCE 135.84 .00 .00 358.61 .00 .00 .0% ____________________________________________
7525404 STREET LIGHTING
7525404 5227 PART/REP 691.44 .00 .00 128.25 .00 .00 .0%

TOTAL STREET LIGHTING 691.44 .00 .00 128.25 .00 .00 .0% ____________________________________________
7525405 TRAFFIC CONTROL
7525405 5227 PART/REP .00 .00 .00 5.34 .00 .00 .0%

TOTAL TRAFFIC CONTROL .00 .00 .00 5.34 .00 .00 .0% ____________________________________________
7525407 WEED ABATEMENT
7525407 5227 PART/REP 24.94 .00 .00 25.50 .00 .00 .0% 7525407 5530 MACH&EQUIP .00 .00 .00 52,241.74 .00 .00 .0% 7525407 5531 VEHICLES .00 .00 277,250.00 .00 .00 .00 -100.0%

TOTAL WEED ABATEMENT 24.94 .00 277,250.00 52,267.24 .00 .00 -100.0% ____________________________________________
7525410 PARKWAY MAINTENANCE
7525410 5227 PART/REP 622.66 .00 .00 121.29 .00 .00 .0%

Page 194 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 118
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL PARKWAY MAINTENANCE 622.66 .00 .00 121.29 .00 .00 .0% ____________________________________________
7525414 FLEET MAINTENANCE
7525414 5111 SALARY-FT 165,243.48 229,270.00 229,270.00 112,409.51 130,070.00 214,730.00 -6.3% 7525414 5113 OVERTIME 2,806.90 3,100.00 3,100.00 3,463.28 3,500.00 3,100.00 .0% 7525414 5116 FRINGE BEN 41,541.39 63,770.00 63,770.00 26,529.22 31,110.00 63,600.00 -.3% 7525414 5117 RETIR CNTR 18,752.56 23,560.00 23,560.00 11,485.97 13,430.00 23,120.00 -1.9% 7525414 5119 UAL PERS 51,420.00 .00 .00 .00 .00 .00 .0% 7525414 5211 POSTAGE 75.11 50.00 50.00 .00 50.00 50.00 .0% 7525414 5213 DUES&SUBSC .00 .00 .00 1,616.25 .00 .00 .0% 7525414 5215 TRNG/CONF 2,737.00 2,250.00 2,250.00 833.00 1,500.00 2,250.00 .0% 7525414 5216 OFFIC SUPP 321.42 500.00 500.00 400.00 350.00 500.00 .0% 7525414 5217 OTHER SUPP 14,556.89 14,450.00 14,450.00 14,823.95 14,450.00 20,450.00 41.5% 7525414 5217 16110 OTHER SUPP 108.55 .00 .00 .00 .00 .00 .0% 7525414 5218 UNIFRM EXP 2,327.63 3,070.00 3,070.00 2,559.01 2,300.00 3,070.00 .0% 7525414 5219 PERM/LC/FE 5,476.31 6,650.00 6,650.00 5,904.00 6,650.00 6,650.00 .0% 7525414 5220 FUEL USAGE 1,753.73 2,000.00 2,000.00 5,368.51 2,500.00 4,500.00 125.0% 7525414 5222 PRNT/MAIL 63.57 100.00 100.00 .00 50.00 100.00 .0% 7525414 5223 INFO SYS 9,000.00 .00 .00 .00 .00 .00 .0% 7525414 5227 VEH PARTS 135,088.12 175,200.00 175,200.00 161,374.27 165,200.00 184,450.00 5.3% 7525414 5227 40155 PART/REP .00 .00 .00 2,166.50 .00 .00 .0% 7525414 5231 FURN&OFFC 581.82 750.00 750.00 .00 400.00 750.00 .0% 7525414 5232 COMP EQUIP 211.02 1,250.00 1,250.00 .00 .00 1,250.00 .0% 7525414 5233 OTHR EQUIP 4,494.73 20,000.00 20,000.00 20,947.79 20,000.00 2,000.00 -90.0% 7525414 5242 UTL-GAS 1,069.64 800.00 800.00 1,275.01 600.00 800.00 .0% 7525414 5246 MAINT-EQP 957.82 .00 .00 .00 .00 .00 .0% 7525414 5247 MAINT-VEH 40.00 .00 .00 .00 .00 .00 .0% 7525414 5248 MAINT-OTHR 4,121.96 3,300.00 3,300.00 2,215.00 2,800.00 3,300.00 .0% 7525414 5253 CONTRC SVS 32,709.21 42,870.00 42,870.00 37,300.00 30,000.00 37,300.00 -13.0% 7525414 5254 DUES&SUBSC 4,475.22 4,350.00 4,350.00 2,426.89 4,350.00 4,600.00 5.7% 7525414 5258 OTHER SVS 11,101.46 13,400.00 13,400.00 14,374.96 11,300.00 15,400.00 14.9% 7525414 5295 PUMP TAX 2,437.36 5,000.00 5,000.00 2,441.00 3,500.00 5,000.00 .0% 7525414 5324 OPEB -25,640.00 .00 .00 .00 .00 .00 .0% 7525414 5325 PEN EXP -21,541.45 .00 .00 .00 .00 .00 .0% 7525414 5530 MACH&EQUIP 467,696.04 .00 .00 .00 .00 .00 .0% 7525414 5531 VEHICLES 2,020.31 .00 1,980.00 1,979.69 1,980.00 16,400.00 728.3% 7525414 5600 CONTR FA -444,409.90 .00 .00 .00 .00 .00 .0% 7525414 5701 INFO SYS .00 7,150.00 7,150.00 6,556.00 7,150.00 7,650.00 7.0% 7525414 5706 OPB&BN ALC .00 10,690.00 13,140.00 9,790.00 10,690.00 8,240.00 -37.3% 7525414 5707 PERSUALALC .00 66,960.00 66,960.00 61,380.00 66,960.00 73,470.00 9.7%

TOTAL FLEET MAINTENANCE 491,597.90 700,490.00 704,920.00 509,619.81 530,890.00 702,730.00 -.3% ____________________________________________
7525420 PARK MAINTENANCE
7525420 5227 PART/REP 2,465.69 .00 .00 401.93 .00 .00 .0%

Page 195 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 119
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL PARK MAINTENANCE 2,465.69 .00 .00 401.93 .00 .00 .0% ____________________________________________
7525601 CITY HALL
7525601 5227 PART/REP 865.00 .00 .00 929.96 .00 .00 .0% 7525601 5531 VEHICLES .00 31,250.00 31,250.00 250.00 31,250.00 .00 -100.0%

TOTAL CITY HALL 865.00 31,250.00 31,250.00 1,179.96 31,250.00 .00 -100.0% ____________________________________________
7525602 BUILDING MAINT & OPERATIONS
7525602 5531 VEHICLES .00 .00 .00 .00 .00 59,250.00 .0%

TOTAL BUILDING MAINT & OPERA .00 .00 .00 .00 .00 59,250.00 .0% ____________________________________________
7526201 WATER ADMINISTRATION
7526201 5227 PART/REP 48.26 .00 .00 .00 .00 .00 .0%

TOTAL WATER ADMINISTRATION 48.26 .00 .00 .00 .00 .00 .0% ____________________________________________
7526202 CUSTOMER SERVICE
7526202 5227 PART/REP 52.53 .00 .00 1,972.22 .00 .00 .0%

TOTAL CUSTOMER SERVICE 52.53 .00 .00 1,972.22 .00 .00 .0% ____________________________________________
7526203 METER SERVICES
7526203 5227 PART/REP 707.64 .00 .00 556.70 .00 .00 .0%

TOTAL METER SERVICES 707.64 .00 .00 556.70 .00 .00 .0% ____________________________________________
7526205 PRODUCTION/STORAGE
7526205 5227 PART/REP 1,603.21 .00 .00 2,852.97 .00 .00 .0% 7526205 5232 COMP EQUIP 927.61 .00 .00 .00 .00 .00 .0% 7526205 5243 UTL-TELEPH 53.23 .00 .00 .00 .00 .00 .0%

TOTAL PRODUCTION/STORAGE 2,584.05 .00 .00 2,852.97 .00 .00 .0% ____________________________________________
7526206 TRANSMISSION & DISTRIBUTION
7526206 5227 PART/REP 4,657.68 .00 .00 5,426.67 .00 .00 .0%

Page 196 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 120
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL TRANSMISSION & DISTRIB 4,657.68 .00 .00 5,426.67 .00 .00 .0% ____________________________________________
7526402 SEWER MAINTENANCE & OPERATIONS
7526402 5227 PART/REP 7,562.28 .00 .00 1,746.64 .00 .00 .0%

TOTAL SEWER MAINTENANCE & OP 7,562.28 .00 .00 1,746.64 .00 .00 .0% ____________________________________________
7526403 SEWER - RESIDENTIAL
7526403 5227 PART/REP 940.47 .00 .00 8.40 .00 .00 .0%

TOTAL SEWER - RESIDENTIAL 940.47 .00 .00 8.40 .00 .00 .0% ____________________________________________
7526404 SEWER - NON RESIDENTIAL
7526404 5227 PART/REP 379.14 .00 .00 538.52 .00 .00 .0%

TOTAL SEWER - NON RESIDENTIA 379.14 .00 .00 538.52 .00 .00 .0% TOTAL FLEET MANAGEMENT 765,996.88 1,376,390.00 2,225,962.00 1,063,211.30 1,473,782.00 891,580.00 -59.9%

Page 197 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 121
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL CITY COUNCIL 6,200.37 .00 .00 3,171.18 .00 .00 .0% ____________________________________________
7531201 CITY ADMINISTRATION
7531201 5219 PERM/LC/FE 119.88 .00 .00 68.78 .00 .00 .0% 7531201 5232 COMP EQUIP .00 .00 .00 2,214.22 .00 .00 .0% 7531201 5234 OTH EQ RNT 1,263.96 .00 .00 1,263.96 .00 .00 .0% 7531201 5235 COPY USG 802.81 .00 .00 810.00 .00 .00 .0%

TOTAL CITY ADMINISTRATION 2,186.65 .00 .00 4,356.96 .00 .00 .0% ____________________________________________
7531301 ACCOUNTING SERVICES
7531301 5213 DUES&SUBSC 579.96 .00 .00 .00 .00 .00 .0% 7531301 5219 PERM/LC/FE .00 .00 .00 412.68 .00 .00 .0% 7531301 5232 COMP EQUIP .00 .00 .00 61.36 .00 .00 .0% 7531301 5234 OTH EQ RNT 1,328.64 .00 .00 1,328.64 .00 .00 .0% 7531301 5235 COPY USG 3,088.85 .00 .00 3,090.00 .00 .00 .0% 7531301 5254 DATA P SVS 56,395.13 .00 .00 58,963.37 .00 .00 .0%

TOTAL ACCOUNTING SERVICES 61,392.58 .00 .00 63,856.05 .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 308.67 .00 .00 310.00 .00 .00 .0%

TOTAL MAIL/PRINTING SERVICES 3,610.47 .00 .00 3,611.80 .00 .00 .0% ____________________________________________
7531401 INFORMATION SYSTEMS
7531401 5110 BUY BACKS .00 .00 .00 3,543.83 3,540.00 3,730.00 .0% 7531401 5111 SALARY-FT 263,065.94 279,410.00 281,943.00 226,085.27 278,060.00 362,640.00 28.6% 7531401 5111 16110 SALARY-FT 265.86 .00 .00 .00 .00 .00 .0% 7531401 5111 16111 SALARY-FT 444.48 .00 .00 .00 .00 .00 .0% 7531401 5111 50105 SALARY-FT 75.48 .00 .00 .00 .00 .00 .0% 7531401 5113 OVERTIME 6,033.29 12,000.00 12,000.00 3,419.37 3,600.00 6,000.00 -50.0% 7531401 5113 16110 OVERTIME 562.21 .00 .00 .00 .00 .00 .0%

Page 198 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 122
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 7531401 5113 40155 OVERTIME .00 .00 .00 200.82 .00 .00 .0% 7531401 5113 50105 OVERTIME 93.70 .00 .00 .00 .00 .00 .0% 7531401 5116 FRINGE BEN 42,804.44 62,230.00 63,092.00 36,572.09 44,860.00 83,290.00 32.0% 7531401 5116 16110 FRINGE BEN 105.71 .00 .00 .00 .00 .00 .0% 7531401 5116 16111 FRINGE BEN 78.37 .00 .00 .00 .00 .00 .0% 7531401 5116 40155 FRINGE BEN .00 .00 .00 27.83 .00 .00 .0% 7531401 5116 50105 FRINGE BEN 25.12 .00 .00 .00 .00 .00 .0% 7531401 5117 RETIR CNTR 28,171.55 28,740.00 29,004.00 22,974.66 28,120.00 39,360.00 35.7% 7531401 5117 16110 RETIR CNTR 27.04 .00 .00 .00 .00 .00 .0% 7531401 5117 16111 RETIR CNTR 45.19 .00 .00 .00 .00 .00 .0% 7531401 5117 50105 RETIR CNTR 7.68 .00 .00 .00 .00 .00 .0% 7531401 5119 UAL PERS 68,196.59 .00 .00 .00 .00 .00 .0% 7531401 5119 16110 UAL PERS 85.73 .00 .00 .00 .00 .00 .0% 7531401 5119 16111 UAL PERS 143.34 .00 .00 .00 .00 .00 .0% 7531401 5119 50105 UAL PERS 24.34 .00 .00 .00 .00 .00 .0% 7531401 5211 POSTAGE 10.86 .00 .00 11.85 .00 .00 .0% 7531401 5213 DUES&SUBSC 51,388.96 .00 .00 28,479.94 .00 .00 .0% 7531401 5215 TRNG/CONF .00 6,000.00 6,000.00 722.47 570.00 5,000.00 -16.7% 7531401 5216 OFFIC SUPP 13.78 600.00 600.00 33.38 600.00 600.00 .0% 7531401 5217 OTHER SUPP 4,411.82 5,000.00 5,000.00 2,395.18 5,000.00 6,000.00 20.0% 7531401 5219 PERM/LC/FE 155,141.16 272,220.00 272,220.00 151,744.39 272,220.00 705,000.00 159.0% 7531401 5220 FUEL USAGE 475.08 850.00 850.00 522.38 850.00 850.00 .0% 7531401 5221 MILE REIMB .00 100.00 100.00 .00 .00 100.00 .0% 7531401 5224 VEH CHRG 1,220.00 .00 .00 .00 .00 .00 .0% 7531401 5231 FURN&OFFC 377.12 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 7531401 5232 COMP EQUIP 95,470.25 68,000.00 110,211.00 29,782.49 70,211.00 53,000.00 -51.9% 7531401 5233 OTHR EQUIP 75,332.40 .00 31,912.00 37,896.25 31,912.00 45,000.00 41.0% 7531401 5234 OTH EQ RNT .00 80,000.00 80,000.00 .00 80,000.00 52,520.00 -34.4% 7531401 5235 COPY USG .00 65,000.00 65,000.00 .00 65,000.00 65,000.00 .0% 7531401 5243 UTL-TELEPH 56,671.53 309,000.00 309,000.00 50,866.05 309,000.00 331,000.00 7.1% 7531401 5246 MAINT-EQP 245.67 .00 .00 275.85 .00 .00 .0% 7531401 5248 MAINT-OTHR 2,227.27 50,000.00 50,000.00 5,343.17 50,000.00 .00 -100.0% 7531401 5253 CONTRC SVS .00 110,000.00 110,000.00 .00 110,000.00 .00 -100.0% 7531401 5254 DATA P SVS 103,833.20 574,350.00 574,350.00 156,110.01 574,350.00 699,030.00 21.7% 7531401 5254 16110 DATA P SVS 10,000.00 .00 .00 .00 .00 .00 .0% 7531401 5258 OTHER SVS 7,860.60 5,000.00 11,250.00 9,448.35 11,250.00 8,050.00 -28.4% 7531401 5283 DEPR-M&EQP 180,929.92 .00 .00 .00 .00 .00 .0% 7531401 5284 DEPR-VEH 5,668.08 .00 .00 .00 .00 .00 .0% 7531401 5290 LATE CHARG 896.25 1,000.00 1,000.00 931.71 1,000.00 .00 -100.0% 7531401 5324 OPEB -6,781.00 .00 .00 .00 .00 .00 .0% 7531401 5325 PEN EXP 29,497.44 .00 .00 .00 .00 .00 .0% 7531401 5530 MACH&EQUIP 88,721.17 220,000.00 725,000.00 56,405.39 290,000.00 90,000.00 -87.6% 7531401 5530 70102 MACH&EQUIP .00 126,370.00 161,835.00 152,814.17 279,185.00 .00 -100.0% 7531401 5531 VEHICLES .00 .00 .00 .00 .00 500.00 .0%

Page 199 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 123
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL INFORMATION SYSTEMS 1,182,798.04 2,372,860.00 2,999,477.00 908,786.51 2,606,318.00 2,698,210.00 -10.0% ____________________________________________
7531405 COUNCIL CHAMBERS
7531405 5223 INFO SYS 15,670.00 .00 .00 .00 .00 .00 .0% 7531405 5232 COMP EQUIP 283.10 10,000.00 10,000.00 .00 10,000.00 .00 -100.0% 7531405 5243 14020 UTL-TELEPH 2,741.49 .00 .00 10,125.28 12,600.00 12,600.00 .0% 7531405 5254 14020 DATA P SVS 2,340.00 2,500.00 163,607.00 177,370.31 176,000.00 120,000.00 -26.7% 7531405 5258 14020 OTHER SVS 9,533.42 .00 .00 .00 .00 .00 .0% 7531405 5283 DEPR-M&EQP 8,708.72 .00 .00 .00 .00 .00 .0% 7531405 5530 MACH&EQUIP .00 100,000.00 100,000.00 .00 90,000.00 .00 -100.0% 7531405 5530 14020 MACH&EQUIP .00 .00 .00 83,577.56 .00 .00 .0% 7531405 5701 INFO SYS .00 21,080.00 21,080.00 19,327.00 21,080.00 13,870.00 -34.2%

TOTAL COUNCIL CHAMBERS 39,276.73 133,580.00 294,687.00 290,400.15 309,680.00 146,470.00 -50.3% ____________________________________________
7531510 LIBRARY
7531510 5213 DUES&SUBSC 386.64 .00 .00 .00 .00 .00 .0% 7531510 5219 PERM/LC/FE 1,560.00 .00 .00 137.56 .00 .00 .0% 7531510 5232 COMP EQUIP 597.28 .00 .00 1,421.00 .00 .00 .0% 7531510 5233 16110 OTHR EQUIP 533.37 .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 2,281.48 .00 .00 5,000.00 .00 .00 .0% 7531510 5243 UTL-TELEPH 4,776.53 .00 .00 2,786.31 .00 .00 .0% 7531510 5248 MAINT-OTHR .00 .00 .00 323.25 .00 .00 .0% 7531510 5254 DATA P SVS 4,327.40 .00 .00 9,919.40 .00 .00 .0% 7531510 5530 MACH&EQUIP 2,348.41 .00 .00 .00 .00 .00 .0%

TOTAL LIBRARY 29,837.23 .00 .00 32,613.64 .00 .00 .0% ____________________________________________
7531601 HUMAN RESOURCES
7531601 5213 DUES&SUBSC 8,972.75 .00 .00 50.00 .00 .00 .0% 7531601 5217 OTHER SUPP .00 .00 .00 21.96 .00 .00 .0% 7531601 5219 PERM/LC/FE .00 .00 .00 343.90 .00 .00 .0% 7531601 5232 COMP EQUIP 78.65 .00 .00 460.46 .00 .00 .0% 7531601 5234 OTH EQ RNT 2,087.28 .00 .00 2,087.28 .00 .00 .0%

Page 200 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 124
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL HUMAN RESOURCES 17,731.83 .00 .00 10,176.51 .00 .00 .0% ____________________________________________
7531701 CITY CLERK
7531701 5213 DUES&SUBSC 386.64 .00 .00 7,550.00 .00 .00 .0% 7531701 5217 OTHER SUPP .00 .00 .00 27.45 .00 .00 .0% 7531701 5219 PERM/LC/FE 11,680.00 .00 .00 137.56 .00 .00 .0% 7531701 5232 COMP EQUIP .00 .00 .00 291.94 .00 .00 .0% 7531701 5234 OTH EQ RNT 1,955.88 .00 .00 1,955.88 .00 .00 .0% 7531701 5235 COPY USG 2,067.20 .00 .00 2,070.00 .00 .00 .0% 7531701 5243 UTL-TELEPH 857.55 .00 .00 728.82 .00 .00 .0% 7531701 5254 DATA P SVS .00 .00 .00 28,606.28 .00 .00 .0%

TOTAL CITY CLERK 16,947.27 .00 .00 41,367.93 .00 .00 .0% ____________________________________________
7532201 BUILDING AND SAFETY
7532201 5213 DUES&SUBSC 193.32 .00 .00 .00 .00 .00 .0% 7532201 5216 OFFIC SUPP 689.43 .00 .00 .00 .00 .00 .0% 7532201 5217 OTHER SUPP 38.78 .00 .00 215.66 .00 .00 .0% 7532201 5219 PERM/LC/FE 96.84 .00 .00 137.56 .00 .00 .0% 7532201 5232 COMP EQUIP 159.54 .00 .00 8,502.96 .00 .00 .0% 7532201 5233 OTHR EQUIP 1,044.60 .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,270.57 .00 .00 4,280.00 .00 .00 .0% 7532201 5243 UTL-TELEPH 6,677.02 .00 .00 7,265.40 .00 .00 .0% 7532201 5254 DATA P SVS 31,110.63 .00 .00 33,223.38 .00 .00 .0%

TOTAL BUILDING AND SAFETY 46,658.89 .00 .00 56,003.12 .00 .00 .0% ____________________________________________
7532203 ECONOMIC DEVELOPMENT
7532203 5219 PERM/LC/FE .00 .00 .00 68.78 .00 .00 .0%

TOTAL ECONOMIC DEVELOPMENT .00 .00 .00 68.78 .00 .00 .0% ____________________________________________
7532205 PLANNING
7532205 5217 OTHER SUPP 27.97 .00 .00 .00 .00 .00 .0% 7532205 5219 PERM/LC/FE 562.50 .00 .00 562.45 .00 .00 .0%

Page 201 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 125
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL PLANNING 29,294.05 .00 .00 37,536.08 .00 .00 .0% ____________________________________________
7532931 HOUSING ADMINISTRATION
7532931 5213 DUES&SUBSC 386.64 .00 .00 .00 .00 .00 .0% 7532931 5217 OTHER SUPP .00 .00 .00 314.59 .00 .00 .0% 7532931 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7532931 5235 COPY USG 4,030.07 .00 .00 4,040.00 .00 .00 .0%

TOTAL HOUSING ADMINISTRATION 7,017.23 .00 .00 6,955.11 .00 .00 .0% ____________________________________________
7533201 POLICE ADMINISTRATION
7533201 5213 DUES&SUBSC 516.64 .00 .00 11,425.42 .00 .00 .0% 7533201 5215 TRNG/CONF .00 .00 .00 500.00 .00 .00 .0% 7533201 5217 OTHER SUPP 111.97 .00 .00 3,508.03 .00 .00 .0% 7533201 5219 PERM/LC/FE 39,986.00 .00 .00 55,461.69 .00 .00 .0% 7533201 5232 COMP EQUIP 32,432.23 .00 19,980.00 84,215.76 19,980.00 .00 -100.0% 7533201 5233 OTHR EQUIP 983.24 .00 .00 3,325.99 .00 .00 .0% 7533201 5234 OTH EQ RNT 9,611.04 .00 .00 9,611.04 .00 .00 .0% 7533201 5235 COPY USG 17,969.92 .00 .00 17,970.00 .00 .00 .0% 7533201 5243 UTL-TELEPH 114,427.40 .00 .00 121,666.93 .00 .00 .0% 7533201 5248 MAINT-OTHR 3,551.68 .00 .00 3,017.19 .00 .00 .0% 7533201 5254 DATA P SVS 194,726.81 .00 .00 170,418.61 .00 .00 .0% 7533201 5254 54130 DATA P SVS .00 .00 .00 50.00 .00 .00 .0% 7533201 5255 54130 BANKNG SVS .00 .00 .00 25.61 .00 .00 .0% 7533201 5258 OTHER SVS .00 .00 .00 2,556.00 .00 .00 .0% 7533201 5283 DEPR-M&EQP 10,263.43 .00 .00 .00 .00 .00 .0% 7533201 5530 MACH&EQUIP 25,183.31 .00 267,055.00 13,836.00 2,055.00 .00 -100.0% 7533201 5530 54130 MACH&EQUIP .00 .00 .00 2,054.56 .00 .00 .0% 7533201 5600 CONTR FA -25,183.31 .00 .00 .00 .00 .00 .0%

TOTAL POLICE ADMINISTRATION 424,580.36 .00 287,035.00 499,642.83 22,035.00 .00 -100.0% ____________________________________________
7533205 ANIMAL SERVICES
7533205 5213 DUES&SUBSC 400.00 .00 .00 .00 .00 .00 .0% 7533205 5217 OTHER SUPP .00 .00 .00 163.42 .00 .00 .0% 7533205 5219 PERM/LC/FE 75.88 .00 .00 3,840.00 .00 .00 .0%

Page 202 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 126
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL ANIMAL SERVICES 37,669.60 .00 .00 24,069.94 .00 .00 .0% ____________________________________________
7534201 RECREATION ADMINISTRATION
7534201 5213 DUES&SUBSC 413.36 .00 .00 .00 .00 .00 .0% 7534201 5217 OTHER SUPP .00 .00 .00 24.76 .00 .00 .0% 7534201 5219 PERM/LC/FE 80.70 .00 .00 68.78 .00 .00 .0% 7534201 5232 COMP EQUIP .00 .00 .00 4,358.28 .00 .00 .0% 7534201 5233 OTHR EQUIP .00 .00 .00 88.74 .00 .00 .0% 7534201 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7534201 5235 COPY USG 885.57 .00 .00 3,830.00 .00 .00 .0% 7534201 5243 UTL-TELEPH 4,968.92 .00 .00 10,893.46 .00 .00 .0% 7534201 5254 DATA P SVS .00 .00 .00 369.00 .00 .00 .0%

TOTAL RECREATION ADMINISTRAT 8,949.07 .00 .00 22,233.54 .00 .00 .0% ____________________________________________
7534203 RECREATION FACILITIES
7534203 5233 OTHR EQUIP .00 .00 .00 177.28 .00 .00 .0% 7534203 5243 UTL-TELEPH 1,585.56 .00 .00 1,321.30 .00 .00 .0%

TOTAL RECREATION FACILITIES 1,585.56 .00 .00 1,498.58 .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 4,777.17 .00 .00 4,780.00 .00 .00 .0% 7534205 5243 UTL-TELEPH 6,312.61 .00 .00 5,632.08 .00 .00 .0%

TOTAL SENIOR CENTER 13,690.30 .00 .00 13,012.60 .00 .00 .0% ____________________________________________
7534210 LANDACENA CENTER
7534210 5232 COMP EQUIP 269.20 .00 .00 5,422.66 .00 .00 .0% 7534210 5243 TELE 5,383.28 .00 .00 5,054.38 .00 .00 .0% 7534210 5258 OTHER SVS 2,460.67 .00 .00 .00 .00 .00 .0%

TOTAL LANDACENA CENTER 8,113.15 .00 .00 10,477.04 .00 .00 .0% ____________________________________________
7534402 CARNEGIE LIBRARY
7534402 5232 COMP EQUIP .00 .00 .00 350.84 .00 .00 .0%

Page 203 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 127
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL CARNEGIE LIBRARY 331.34 .00 .00 350.84 .00 .00 .0% ____________________________________________
7535201 PUBLIC WORKS ADMINISTRATION
7535201 5213 DUES&SUBSC 386.64 .00 .00 .00 .00 .00 .0% 7535201 5219 PERM/LC/FE .00 .00 .00 137.56 .00 .00 .0% 7535201 5232 COMP EQUIP 2,413.66 .00 .00 1,598.02 .00 .00 .0% 7535201 5234 OTH EQ RNT 2,600.52 .00 .00 2,600.52 .00 .00 .0% 7535201 5235 COPY USG 3,453.14 .00 .00 3,460.00 .00 .00 .0% 7535201 5243 UTL-TELEPH 15,337.81 .00 .00 12,028.65 .00 .00 .0% 7535201 5254 DATA PRCS .00 .00 .00 2,267.38 .00 .00 .0%

TOTAL PUBLIC WORKS ADMINISTR 24,191.77 .00 .00 22,092.13 .00 .00 .0% ____________________________________________
7535202 NPDES
7535202 5219 PERM/LC/FE .00 .00 .00 68.78 .00 .00 .0%

TOTAL NPDES .00 .00 .00 68.78 .00 .00 .0% ____________________________________________
7535301 ENGINEERING ADMINISTRATION
7535301 5213 DUES&SUBSC 1,800.96 .00 .00 1,530.28 .00 .00 .0% 7535301 5217 OTHER SUPP .00 .00 .00 63.89 .00 .00 .0% 7535301 5219 PERM/LC/FE 536.20 .00 .00 343.90 .00 .00 .0% 7535301 5243 UTL-TELEPH 4,325.52 .00 .00 3,673.11 .00 .00 .0%

TOTAL ENGINEERING ADMINISTRA 6,662.68 .00 .00 5,611.18 .00 .00 .0% ____________________________________________
7535401 STREET MAINTENANCE
7535401 5232 COMP EQUIP 1,308.52 .00 .00 838.69 .00 .00 .0% 7535401 5243 UTL-TELEPH 5,261.20 .00 .00 4,505.85 .00 .00 .0%

TOTAL STREET MAINTENANCE 6,569.72 .00 .00 5,344.54 .00 .00 .0% ____________________________________________
7535413 MAINTENANCE-METROLINK STATION
7535413 5243 54130 UTL-TELEPH 376.50 .00 .00 346.50 .00 .00 .0%

TOTAL MAINTENANCE-METROLINK 376.50 .00 .00 346.50 .00 .00 .0% ____________________________________________
7535414 FLEET MAINTENANCE
7535414 5243 UTL-TELEPH 1,498.82 .00 .00 1,988.03 .00 .00 .0%

Page 204 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 128
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL FLEET MAINTENANCE 8,643.32 .00 .00 9,619.66 .00 .00 .0% ____________________________________________
7535420 PARK MAINTENANCE
7535420 5232 COMP EQUIP 1,236.46 .00 .00 408.83 .00 .00 .0% 7535420 5243 UTL-TELEPH 5,014.39 .00 .00 4,131.42 .00 .00 .0%

TOTAL PARK MAINTENANCE 6,250.85 .00 .00 4,540.25 .00 .00 .0% ____________________________________________
7535601 CITY HALL
7535601 5232 COMP EQUIP 94.97 .00 .00 2,317.48 .00 .00 .0% 7535601 5233 OTHR EQUIP 1,330.73 .00 .00 .00 .00 .00 .0% 7535601 5243 UTL-TELEPH 2,731.53 .00 .00 905.10 .00 .00 .0%

TOTAL CITY HALL 4,157.23 .00 .00 3,222.58 .00 .00 .0% ____________________________________________
7535602 BUILDING MAINT & OPERATIONS
7535602 5243 UTL-TELEPH .00 .00 .00 2,983.81 .00 .00 .0%

TOTAL BUILDING MAINT & OPERA .00 .00 .00 2,983.81 .00 .00 .0% ____________________________________________
7536201 WATER ADMINISTRATION
7536201 5213 DUES&SUBSC 800.64 .00 .00 2,007.00 .00 .00 .0% 7536201 5217 OTHER SUPP .00 .00 .00 20.45 .00 .00 .0% 7536201 5219 PERM/LC/FE 1,894.72 .00 .00 440.65 .00 .00 .0% 7536201 5232 COMP EQUIP 46.50 .00 .00 170.56 .00 .00 .0% 7536201 5234 OTH EQ RNT 4,475.76 .00 .00 4,475.76 .00 .00 .0% 7536201 5235 COPY USG 2,334.21 .00 .00 2,340.00 .00 .00 .0% 7536201 5243 UTL-TELEPH 10,042.08 .00 .00 6,075.72 .00 .00 .0% 7536201 5254 DATA P SVS .00 .00 .00 3,125.00 .00 .00 .0%

TOTAL WATER ADMINISTRATION 19,593.91 .00 .00 18,655.14 .00 .00 .0% ____________________________________________
7536202 CUSTOMER SERVICE
7536202 5243 UTL-TELEPH .00 .00 .00 318.73 .00 .00 .0% 7536202 5254 DATA P SVS 13,498.18 .00 .00 12,029.96 .00 .00 .0%

TOTAL CUSTOMER SERVICE 13,498.18 .00 .00 12,348.69 .00 .00 .0% ____________________________________________
7536203 METER SERVICES
7536203 5243 UTL-TELEPH .00 .00 .00 2,180.62 .00 .00 .0%

Page 205 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 129
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL METER SERVICES .00 .00 .00 2,180.62 .00 .00 .0% ____________________________________________
7536205 PRODUCTION/STORAGE
7536205 5232 COMP EQUIP 186.71 .00 .00 1,237.33 .00 .00 .0% 7536205 5243 UTL-TELEPH 18,380.24 .00 .00 15,184.58 .00 .00 .0%

TOTAL PRODUCTION/STORAGE 18,566.95 .00 .00 16,421.91 .00 .00 .0% ____________________________________________
7536206 TRANSMISSION & DISTRIBUTION
7536206 5232 COMP EQUIP 9,885.88 .00 .00 3,703.33 .00 .00 .0% 7536206 5243 UTL-TELEPH 19,118.75 .00 .00 19,078.06 .00 .00 .0%

TOTAL TRANSMISSION & DISTRIB 29,004.63 .00 .00 22,781.39 .00 .00 .0% ____________________________________________
7536208 CONSERVATION
7536208 5213 DUES&SUBSC 231.98 .00 .00 .00 .00 .00 .0% 7536208 5219 PERM/LC/FE .00 .00 .00 68.78 .00 .00 .0%

TOTAL CONSERVATION 231.98 .00 .00 68.78 .00 .00 .0% ____________________________________________
7536211 STORM WATER MGMT & RECHARGE
7536211 5254 DATA P SVS 4,748.00 .00 .00 10,066.00 .00 .00 .0%

TOTAL STORM WATER MGMT & REC 4,748.00 .00 .00 10,066.00 .00 .00 .0% ____________________________________________
7536301 SOLID WASTE
7536301 5254 DATA P SVS 11,942.16 .00 .00 9,199.40 .00 .00 .0%

TOTAL SOLID WASTE 11,942.16 .00 .00 9,199.40 .00 .00 .0% ____________________________________________
7536401 LANDFILL SITE MAINTENANCE
7536401 5219 PERM/LC/FE 395.00 .00 .00 .00 .00 .00 .0%

TOTAL LANDFILL SITE MAINTENA 395.00 .00 .00 .00 .00 .00 .0% ____________________________________________
7536402 SEWER MAINTENANCE & OPERATIONS
7536402 5232 COMP EQUIP 196.49 .00 .00 426.40 .00 .00 .0%

Page 206 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 130
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL SEWER MAINTENANCE & OP 19,776.45 .00 .00 17,608.55 .00 .00 .0% ____________________________________________
7536403 SEWER - RESIDENTIAL
7536403 5254 DATA P SVS 1,108.00 .00 .00 2,349.00 .00 .00 .0%

TOTAL SEWER - RESIDENTIAL 1,108.00 .00 .00 2,349.00 .00 .00 .0% ____________________________________________
7536404 SEWER - NON RESIDENTIAL
7536404 5213 DUES&SUBSC 193.64 .00 .00 .00 .00 .00 .0% 7536404 5232 COMP EQUIP 191.28 .00 .00 46.50 .00 .00 .0% 7536404 5243 UTL-TELEPH 2,144.22 .00 .00 2,058.62 .00 .00 .0% 7536404 5254 DATA P SVS 1,108.00 .00 .00 2,349.00 .00 .00 .0%

TOTAL SEWER - NON RESIDENTIA 3,637.14 .00 .00 4,454.12 .00 .00 .0% TOTAL INFORMATION SYSTEMS 2,117,225.19 2,506,440.00 3,581,199.00 2,200,152.22 2,938,033.00 2,844,680.00 -20.6%

Page 207 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 131
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL BUILDING MAINT & OPERA 193,000.00 .00 .00 .00 .00 .00 .0% ____________________________________________
7541510 LIBRARY
7541510 5217 OTHER SUPP .00 .00 .00 43.58 .00 .00 .0% 7541510 5245 MAINT-BLDG 21,734.05 45,000.00 45,000.00 35,995.35 40,000.00 40,000.00 -11.1% 7541510 5245 16110 MAINT-BLDG 118.53 .00 .00 .00 .00 .00 .0%

TOTAL LIBRARY 21,852.58 45,000.00 45,000.00 36,038.93 40,000.00 40,000.00 -11.1% ____________________________________________
7541701 CITY CLERK
7541701 5530 MACH&EQUIP .00 39,720.00 39,720.00 .00 39,720.00 .00 -100.0%

TOTAL CITY CLERK .00 39,720.00 39,720.00 .00 39,720.00 .00 -100.0% ____________________________________________
7542207 SANTA FE DEPOT
7542207 5245 MAINT-BLDG 10,630.80 8,000.00 8,000.00 3,246.00 6,000.00 6,000.00 -25.0%

TOTAL SANTA FE DEPOT 10,630.80 8,000.00 8,000.00 3,246.00 6,000.00 6,000.00 -25.0% ____________________________________________
7543201 POLICE ADMINISTRATION
7543201 5217 OTHER SUPP 3,512.34 .00 .00 24.50 .00 .00 .0% 7543201 5219 PERM/LC/FE 2,076.10 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 .0% 7543201 5231 FURN&OFFC 11,867.70 .00 .00 -280.15 .00 .00 .0% 7543201 5233 OTHR EQUIP 15,481.05 .00 .00 896.52 .00 .00 .0% 7543201 5234 OTH EQ RNT 4,596.38 .00 .00 .00 .00 .00 .0% 7543201 5245 MAINT-BLDG 34,154.96 105,000.00 105,000.00 61,088.55 140,000.00 140,000.00 33.3% 7543201 5248 MAINT-OTHR 2,599.00 .00 .00 .00 .00 .00 .0% 7543201 5254 DATA P SVS 7,143.12 .00 .00 .00 .00 .00 .0% 7543201 5528 IMPRV BLD 20,558.92 .00 .00 19,560.00 .00 .00 .0% 7543201 5530 MACH&EQUIP 35,883.56 .00 .00 .00 .00 .00 .0%

TOTAL POLICE ADMINISTRATION 137,873.13 106,000.00 106,000.00 82,289.42 141,000.00 141,000.00 33.0% ____________________________________________
7543205 ANIMAL SERVICES
7543205 5217 OTHER SUPP .00 .00 .00 29.47 .00 .00 .0%

Page 208 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 132
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL ANIMAL SERVICES 11,081.01 25,000.00 25,000.00 16,518.81 36,000.00 25,000.00 .0% ____________________________________________
7543512 FIRE STATION II
7543512 5217 OTHER SUPP 26.17 .00 .00 .00 .00 .00 .0% 7543512 5219 PERM/LC/FE .00 .00 .00 900.00 .00 .00 .0% 7543512 5245 MAINT-BLDG 1,362.91 5,000.00 5,000.00 4,081.66 10,000.00 10,000.00 100.0% 7543512 5529 BLD IMP 15,420.46 .00 .00 .00 .00 .00 .0%

TOTAL FIRE STATION II 16,809.54 5,000.00 5,000.00 4,981.66 10,000.00 10,000.00 100.0% ____________________________________________
7543518 HISTORIC FIRE STATION
7543518 5245 MAINT-BLDG 4,782.92 12,000.00 12,000.00 8,688.00 15,000.00 15,000.00 25.0%

TOTAL HISTORIC FIRE STATION 4,782.92 12,000.00 12,000.00 8,688.00 15,000.00 15,000.00 25.0% ____________________________________________
7544203 RECREATION FACILITIES
7544203 5217 OTHER SUPP 37.70 .00 .00 .00 .00 .00 .0% 7544203 5245 MAINT-BLDG 18,829.82 30,000.00 30,000.00 25,501.65 35,000.00 30,000.00 .0% 7544203 5528 IMPRV BLD .00 .00 .00 .00 60,000.00 40,000.00 .0%

TOTAL RECREATION FACILITIES 18,867.52 30,000.00 30,000.00 25,501.65 95,000.00 70,000.00 133.3% ____________________________________________
7544205 SENIOR CENTER
7544205 5217 OTHER SUPP 56.23 .00 .00 .00 .00 .00 .0% 7544205 5232 COMP EQUIP 50.63 .00 .00 .00 .00 .00 .0% 7544205 5233 OTHR EQUIP .00 .00 .00 67.87 .00 .00 .0% 7544205 5245 MAINT-BLDG 25,055.99 35,000.00 35,000.00 26,177.56 40,000.00 40,000.00 14.3%

TOTAL SENIOR CENTER 25,162.85 35,000.00 35,000.00 26,245.43 40,000.00 40,000.00 14.3% ____________________________________________
7544210 LANDECENA CENTER
7544210 5212 ADVERTISNG 8,040.40 .00 .00 .00 .00 .00 .0% 7544210 5245 MAINT-BLDG 2,708.67 20,000.00 20,000.00 33,122.62 22,000.00 22,000.00 10.0%

TOTAL LANDECENA CENTER 10,749.07 20,000.00 20,000.00 33,122.62 22,000.00 22,000.00 10.0% ____________________________________________
7544402 CARNEGIE LIBRARY
7544402 5245 MAINT-BLDG 6,315.99 35,000.00 35,000.00 12,784.14 35,000.00 35,000.00 .0%

Page 209 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 133
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

TOTAL CARNEGIE LIBRARY 6,315.99 35,000.00 35,000.00 12,784.14 35,000.00 35,000.00 .0% ____________________________________________
7545201 PUBLIC WORKS ADMINISTRATION
7545201 5213 DUES&SUBSC 206.87 .00 .00 .00 .00 .00 .0% 7545201 5217 OTHER SUPP 254.23 .00 .00 59.68 .00 .00 .0% 7545201 5218 UNIFRM EXP 274.77 .00 .00 -24.77 .00 .00 .0% 7545201 5232 COMP EQUIP 603.37 .00 .00 .00 .00 .00 .0% 7545201 5233 OTHR EQUIP 376.70 .00 .00 533.77 .00 .00 .0% 7545201 5245 MAINT-BLDG 17,859.03 55,000.00 55,000.00 19,576.49 55,000.00 55,000.00 .0% 7545201 5245 40155 MAINT-BLDG .00 .00 .00 17,900.00 .00 .00 .0% 7545201 5246 MAINT-EQP .00 .00 .00 375.00 .00 .00 .0% 7545201 5248 MAINT-OTHR 4,779.78 .00 .00 .00 .00 .00 .0% 7545201 5528 IMPRV BLD .00 .00 .00 4,805.00 .00 .00 .0% 7545201 5529 BLD IMP .00 70,000.00 70,000.00 .00 70,000.00 .00 -100.0%

TOTAL PUBLIC WORKS ADMINISTR 24,354.75 125,000.00 125,000.00 43,225.17 125,000.00 55,000.00 -56.0% ____________________________________________
7545414 FLEET MAINTENANCE
7545414 5245 MAINT-BLDG 16,174.76 35,000.00 35,000.00 14,956.00 35,000.00 35,000.00 .0% 7545414 5529 BLD IMP .00 60,000.00 60,000.00 72,375.00 60,000.00 .00 -100.0%

TOTAL FLEET MAINTENANCE 16,174.76 95,000.00 95,000.00 87,331.00 95,000.00 35,000.00 -63.2% ____________________________________________
7545420 PARK MAINTENANCE
7545420 5234 OTH EQ RNT .00 .00 .00 4,400.00 .00 .00 .0% 7545420 5245 MAINT-BLDG 16,907.40 35,000.00 35,000.00 16,889.18 40,000.00 40,000.00 14.3%

TOTAL PARK MAINTENANCE 16,907.40 35,000.00 35,000.00 21,289.18 40,000.00 40,000.00 14.3% ____________________________________________
7545601 CITY HALL
7545601 5217 OTHER SUPP 2,399.68 .00 .00 165.63 .00 .00 .0% 7545601 5219 PERM/LC/FE .00 700.00 700.00 700.00 700.00 700.00 .0% 7545601 5231 FURN&OFFC .00 .00 3,000.00 3,031.67 3,000.00 .00 -100.0% 7545601 5233 OTHR EQUIP 1,134.00 .00 .00 .00 .00 .00 .0% 7545601 5245 MAINT-BLDG 55,257.81 65,000.00 65,000.00 81,191.06 70,000.00 70,000.00 7.7% 7545601 5245 16110 MAINT-BLDG 21.55 .00 .00 .00 .00 .00 .0% 7545601 5258 OTHER SVS 23.00 .00 .00 .00 .00 .00 .0%

TOTAL CITY HALL 58,836.04 65,700.00 68,700.00 85,088.36 73,700.00 70,700.00 2.9% ____________________________________________
7545602 BUILDING MAINT & OPERATIONS
7545602 5110 BUY BACKS 4,230.82 4,360.00 4,360.00 4,667.01 4,670.00 4,910.00 12.6%

Page 210 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 134
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
BUILDING MAINT & OPERATIONS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 7545602 5111 SALARY-FT 282,269.59 350,150.00 350,150.00 224,258.17 283,940.00 339,960.00 -2.9% 7545602 5112 SALARY-PT 24,164.61 16,360.00 16,360.00 13,673.63 15,590.00 16,360.00 .0% 7545602 5113 OVERTIME 14,759.57 12,000.00 12,000.00 12,071.37 18,000.00 18,000.00 50.0% 7545602 5113 16110 OVERTIME 5,074.38 .00 .00 .00 .00 .00 .0% 7545602 5113 16111 OVERTIME 2,887.89 .00 .00 .00 .00 .00 .0% 7545602 5116 FRINGE BEN 82,609.78 106,270.00 106,270.00 64,545.54 83,850.00 105,600.00 -.6% 7545602 5116 16110 FRINGE BEN 1,344.19 .00 .00 .00 .00 .00 .0% 7545602 5116 16111 FRINGE BEN 615.09 .00 .00 .00 .00 .00 .0% 7545602 5117 RETIR CNTR 29,144.57 34,680.00 34,680.00 21,543.28 26,700.00 35,510.00 2.4% 7545602 5119 UAL PERS 56,170.00 .00 .00 .00 .00 .00 .0% 7545602 5213 DUES&SUBSC .00 200.00 200.00 .00 300.00 300.00 50.0% 7545602 5215 TRNG/CONF 47.95 .00 .00 .00 .00 .00 .0% 7545602 5216 OFFIC SUPP 75.07 500.00 500.00 500.00 1,000.00 1,000.00 100.0% 7545602 5217 OTHER SUPP 48.95 500.00 500.00 228.09 1,000.00 1,000.00 100.0% 7545602 5218 UNIFRM EXP 3,226.27 4,540.00 4,540.00 3,782.63 6,000.00 6,000.00 32.2% 7545602 5220 FUEL USAGE 6.08 .00 .00 17.33 .00 .00 .0% 7545602 5222 PRINTING .00 .00 .00 63.57 .00 .00 .0% 7545602 5233 OTHR EQUIP 4,784.25 10,000.00 10,000.00 3,000.00 10,000.00 10,000.00 .0% 7545602 5245 MAINT-BLDG .00 .00 .00 .00 5,000.00 5,000.00 .0% 7545602 5258 OTHER SVS 102.00 .00 .00 165.50 5,000.00 5,000.00 .0% 7545602 5324 OPEB -7,219.00 .00 .00 .00 .00 .00 .0% 7545602 5325 PEN EXP -56,305.60 .00 .00 .00 .00 .00 .0% 7545602 5703 VH ACQ ALC .00 .00 .00 .00 .00 59,250.00 .0% 7545602 5706 OPB&BN ALC .00 16,870.00 20,950.00 15,510.00 16,870.00 13,210.00 -36.9% 7545602 5707 PERSUALALC .00 102,120.00 102,120.00 93,610.00 102,120.00 116,300.00 13.9%

TOTAL BUILDING MAINT & OPERA 448,036.46 658,550.00 662,630.00 457,636.12 580,040.00 737,400.00 11.3% ____________________________________________
7546205 PRODUCTION/STORAGE
7546205 5245 MAINT-BLDG 75,024.88 85,000.00 88,000.00 80,064.59 110,000.00 110,000.00 25.0%

TOTAL PRODUCTION/STORAGE 75,024.88 85,000.00 88,000.00 80,064.59 110,000.00 110,000.00 25.0% ____________________________________________
7546301 SOLID WASTE
7546301 5245 MAINT-BLDG .00 2,000.00 2,000.00 .00 3,000.00 3,000.00 50.0%

TOTAL SOLID WASTE .00 2,000.00 2,000.00 .00 3,000.00 3,000.00 50.0% ____________________________________________
7546402 SEWER MAINTENANCE & OPERATIONS
7546402 5245 MAINT-BLDG .00 2,000.00 2,000.00 .00 3,000.00 3,000.00 50.0%

TOTAL SEWER MAINTENANCE & OP .00 2,000.00 2,000.00 .00 3,000.00 3,000.00 50.0% TOTAL BUILDING MAINT & OPERA 1,096,459.70 1,428,970.00 1,439,050.00 1,024,051.08 1,509,460.00 1,458,100.00 1.3%

Page 211 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 135
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
UAL AND EMPLOYEE BENEFITS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7551504 NON-DEPARTMENTAL
7551504 5213 DUES&SUBSC .00 .00 2,600.00 2,600.00 2,600.00 2,600.00 .0% 7551504 5251 LEGAL SVS .00 100,000.00 21,070.00 .00 21,070.00 .00 -100.0% 7551504 5252 PROF SVS .00 20,830.00 36,830.00 36,500.00 36,830.00 22,830.00 -38.0% 7551504 5253 CONTRC SVS .00 130,000.00 255,000.00 201,985.00 255,000.00 37,500.00 -85.3% 7551504 5255 BANKNG SVS .00 34,000.00 51,180.00 57,686.76 51,180.00 46,960.00 -8.2% 7551504 5258 OTHER SVS .00 .00 14,220.00 6,120.40 14,220.00 14,300.00 .6% 7551504 5321 EMPL INCEN .00 16,700.00 16,700.00 15,356.63 16,700.00 21,500.00 28.7% 7551504 5322 HLTH-RETIR .00 300,000.00 328,930.00 304,016.11 328,930.00 345,370.00 5.0% 7551504 5325 PEN EXP .00 9,294,810.00 9,294,810.00 9,294,799.00 9,294,810.00 6,819,870.00 -26.6% 7551504 5326 MED-RETIRE .00 192,480.00 192,480.00 245,717.58 192,480.00 192,480.00 .0% 7551504 5327 DEN-RETIRE .00 75,000.00 75,000.00 76,870.91 75,000.00 75,000.00 .0% 7551504 5328 VIS-RETIRE .00 5,040.00 5,040.00 4,568.88 5,040.00 5,040.00 .0%

TOTAL NON-DEPARTMENTAL .00 10,168,860.00 10,293,860.00 10,246,221.27 10,293,860.00 7,583,450.00 -26.3% TOTAL UAL AND EMPLOYEE BENEF .00 10,168,860.00 10,293,860.00 10,246,221.27 10,293,860.00 7,583,450.00 -26.3%

Page 212 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 136
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SUCCESSOR AGENCY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
8052901 SUCCESSOR AGENCY ADMINISTRATIO
8052901 5111 SALARY-FT 146,988.78 139,130.00 139,130.00 107,270.41 139,130.00 128,970.00 -7.3% 8052901 5111 16110 SALARY-FT 44.78 .00 .00 .00 .00 .00 .0% 8052901 5111 50105 SALARY-FT 2.56 .00 .00 .00 .00 .00 .0% 8052901 5112 SALARY-PT 4,338.27 .00 .00 .00 .00 .00 .0% 8052901 5113 OVERTIME 21.65 .00 .00 .00 .00 .00 .0% 8052901 5116 FRINGE BEN 27,280.64 31,960.00 31,960.00 21,415.16 31,960.00 29,240.00 -8.5% 8052901 5116 16110 FRINGE BEN 11.95 .00 .00 .00 .00 .00 .0% 8052901 5116 50105 FRINGE BEN .89 .00 .00 .00 .00 .00 .0% 8052901 5117 RETIR CNTR 16,665.08 14,390.00 14,390.00 10,745.54 14,390.00 13,680.00 -4.9% 8052901 5117 16110 RETIR CNTR 5.18 .00 .00 .00 .00 .00 .0% 8052901 5117 50105 RETIR CNTR .30 .00 .00 .00 .00 .00 .0% 8052901 5119 UAL PERS 41,561.79 .00 .00 .00 .00 .00 .0% 8052901 5119 16110 UAL PERS 8.21 .00 .00 .00 .00 .00 .0% 8052901 5251 LEGAL SVS 684.00 1,000.00 1,000.00 .00 .00 4,500.00 350.0% 8052901 5252 PROF SVS 1,945.27 13,950.00 15,278.00 3,827.03 13,950.00 12,620.00 -17.4% 8052901 5253 CONTRC SVS .00 .00 .00 .00 .00 10,930.00 .0% 8052901 5255 BANKNG SVS 4,015.63 4,000.00 4,000.00 4,000.00 4,000.00 4,100.00 2.5% 8052901 5258 OTHER SVS 2,970.00 .00 .00 2,970.00 .00 .00 .0% 8052901 5296 RDA PASS-T 97,779.36 .00 .00 .00 .00 .00 .0% 8052901 5424 BND PRNCPL .00 2,385,000.00 2,385,000.00 .00 2,385,000.00 2,480,000.00 4.0% 8052901 5425 BND INT EX 584,819.13 744,690.00 744,690.00 744,687.50 744,690.00 635,940.00 -14.6% 8052901 5707 PERSUALALC .00 40,510.00 40,510.00 37,180.00 40,510.00 44,190.00 9.1%

TOTAL SUCCESSOR AGENCY ADMIN 929,143.47 3,374,630.00 3,375,958.00 932,095.64 3,373,630.00 3,364,170.00 -.3% TOTAL SUCCESSOR AGENCY 929,143.47 3,374,630.00 3,375,958.00 932,095.64 3,373,630.00 3,364,170.00 -.3%

TOTAL REVENUE .00 .00 .00 .00 .00 .00 .0% TOTAL EXPENSE 123,103,186.67 180,137,610.00 199,567,499.39 170,200,761.32 131,175,986.90 197,863,820.00 -.9%

GRAND TOTAL 123,103,186.67 180,137,610.00 199,567,499.39 170,200,761.32 131,175,986.90 197,863,820.00 -.9%

** END OF REPORT - Generated by Saleha Kazmi **

Page 213 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 137
skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

Report title:
05/02/2022 12:10 |City of Upland, CA |P 137 skazmi |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts

PROJECTION:20231 FY 2022-23 ANNUAL BUDGET FOR PERIOD 99

Report type:1
Budget level: 4
Percentage change calculation method:1
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

Page 214 of 214 ends

Upland City CouncilMay 9, 2022

Upland City Council
May 9, 2022