Agenda packet — Upland City Council, May 25, 2023 (part 2 of 3)

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 13 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1013231 5113 OVERTIME 112.67 410.00 410.00 .00 410.00 .00 .0% 1013231 5116 FRINGE BEN 49.90 .00 .00 24.67 .00 .00 .0% 1013231 5133 OT-SW PD 8,042.48 10,510.00 10,510.00 12,922.72 10,510.00 .00 .0% 1013231 5136 FRG B-S PD 1,269.02 .00 .00 1,700.74 .00 .00 .0% 1013231 5137 RT CNTR-PD 56.61 .00 .00 .00 .00 .00 .0% 1013231 5213 DUES&SUBSC .00 50.00 50.00 35.00 40.00 50.00 .0% 1013231 5215 TRNG/CONF 182.36 2,000.00 2,000.00 .00 500.00 2,000.00 .0% 1013231 5217 OTHER SUPP 63.83 6,700.00 6,400.00 2,749.63 7,240.00 13,800.00 115.6% 1013231 5234 OTH EQ RNT .00 1,000.00 1,000.00 251.60 760.00 31,000.00 3000.0% 1013231 5258 OTHER SVS .00 .00 300.00 300.00 300.00 400.00 33.3% TOTAL SPECIAL EVENTS & COMM 10,369.67 20,670.00 20,670.00 18,313.88 19,760.00 47,250.00 128.6% 1013232 POLICE RESERVES
1013232 5213 DUES&SUBSC .00 480.00 480.00 .00 480.00 480.00 .0% 1013232 5215 TRNG/CONF 3,810.43 4,100.00 4,100.00 .00 3,830.00 3,400.00 -17.1% 1013232 5218 UNIFRM EXP .00 2,200.00 2,200.00 1,896.11 1,900.00 2,200.00 .0% 1013232 5222 PRINTING .00 .00 .00 70.04 70.00 280.00 .0% 1013232 5226 TEAMBLDG .00 .00 .00 .00 .00 700.00 .0% TOTAL POLICE RESERVES 3,810.43 6,780.00 6,780.00 1,966.15 6,280.00 7,060.00 4.1% 1013233 CODE ENFORCEMENT
1013233 5111 SALARY-FT 203,133.93 260,210.00 260,210.00 150,000.59 260,210.00 309,250.00 18.8% 1013233 5112 SALARY-PT .00 .00 12,634.00 9,638.58 12,634.00 .00 .0% 1013233 5113 OVERTIME 861.55 1,450.00 1,450.00 1,856.93 950.00 1,980.00 36.6% 1013233 5116 FRINGE BEN 39,761.80 74,060.00 74,243.00 32,013.76 74,243.00 81,030.00 9.1% 1013233 5117 RETIR CNTR 20,011.91 28,340.00 28,340.00 15,450.72 28,340.00 37,050.00 30.7% 1013233 5131 SAL-SW PD .00 .00 .00 .00 .00 28,710.00 .0% 1013233 5211 POSTAGE 4.00 100.00 100.00 .00 50.00 100.00 .0% 1013233 5213 DUES&SUBSC 8,624.13 9,240.00 9,240.00 300.00 300.00 400.00 -95.7% 1013233 5215 TRNG/CONF 3,138.77 8,060.00 8,060.00 1,058.42 8,800.00 8,060.00 .0% 1013233 5217 OTHER SUPP 127.15 400.00 400.00 .00 .00 400.00 .0% 1013233 5218 UNIFRM EXP 195.00 2,100.00 2,100.00 1,440.04 2,020.00 2,100.00 .0% 1013233 5220 FUEL USAGE 4,153.71 3,910.00 3,910.00 2,517.44 3,320.00 4,780.00 22.3% 1013233 5222 PRINTING 547.37 520.00 520.00 524.47 140.00 520.00 .0% 1013233 5233 OTHR EQUIP 477.59 600.00 600.00 121.64 220.00 600.00 .0% 1013233 5251 LEGAL SVS 210,299.26 248,860.00 248,860.00 248,860.00 194,710.00 223,920.00 -10.0% 1013233 5258 OTHER SVS 13,521.20 16,880.00 16,880.00 3,024.52 12,300.00 18,070.00 7.0% 1013233 5702 FLT-MT&RP 3,920.00 4,170.00 4,170.00 4,176.00 4,170.00 4,310.00 3.4% 1013233 5705 SF LIAB 62,340.00 62,380.00 62,380.00 62,388.00 62,380.00 70,660.00 13.3% 1013233 5706 OPB&BN ALC 12,030.00 9,450.00 9,450.00 9,456.00 9,450.00 10,440.00 10.5%

Page 89 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 14 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1013233 5707 PERSUALALC 75,670.00 84,860.00 84,860.00 84,864.00 84,860.00 92,640.00 9.2% TOTAL CODE ENFORCEMENT 658,817.37 815,590.00 828,407.00 627,691.11 759,097.00 895,020.00 8.0% 1013501 FIRE ADMINISTRATION
1013501 5220 FUEL USAGE 18,102.84 14,000.00 14,000.00 14,031.19 19,290.00 20,790.00 48.5% TOTAL FIRE ADMINISTRATION 18,102.84 14,000.00 14,000.00 14,031.19 19,290.00 20,790.00 48.5% 1013512 FIRE STATION II
1013512 5241 UTL-ELECTR 3,216.85 2,480.00 2,480.00 3,777.80 5,030.00 5,340.00 115.3% 1013512 5242 UTL-GAS 532.45 310.00 310.00 1,372.50 1,920.00 2,040.00 558.1% 1013512 5244 UTL-WATER .00 5,060.00 5,060.00 2,288.63 2,420.00 3,000.00 -40.7% 1013512 5704 BDG MT ALC 45,100.00 57,090.00 57,090.00 57,096.00 57,090.00 58,290.00 2.1% TOTAL FIRE STATION II 48,849.30 64,940.00 64,940.00 64,534.93 66,460.00 68,670.00 5.7% 1013518 HISTORIC FIRE STATION
1013518 5243 UTL-TELEPH 1,214.88 .00 .00 1,113.64 1,220.00 1,220.00 .0% 1013518 5704 BDG MT ALC 36,440.00 38,890.00 38,890.00 38,892.00 38,890.00 32,790.00 -15.7% TOTAL HISTORIC FIRE STATION 37,654.88 38,890.00 38,890.00 40,005.64 40,110.00 34,010.00 -12.5% 1014201 RECREATION ADMINISTRATION
1014201 5110 BUY BACKS 3,261.20 3,430.00 3,430.00 1,948.80 3,430.00 7,400.00 115.7% 1014201 5111 SALARY-FT 272,146.37 314,260.00 359,260.00 306,058.23 314,260.00 324,480.00 -9.7% 1014201 5111 91025 SALARY-FT .00 .00 .00 259.09 .00 .00 .0% 1014201 5112 SALARY-PT 97,540.04 54,640.00 149,640.00 74,318.85 54,640.00 501,090.00 234.9% 1014201 5112 20101 SALARY-PT 2,966.82 .00 .00 622.16 .00 .00 .0% 1014201 5112 20106 SALARY-PT 4,243.91 .00 .00 338.13 .00 .00 .0% 1014201 5112 20107 SALARY-PT .00 .00 .00 601.91 .00 .00 .0% 1014201 5112 20108 SALARY-PT 20,241.14 .00 .00 17,753.73 .00 .00 .0% 1014201 5112 91025 SALARY-PT .00 .00 .00 162.09 .00 .00 .0% 1014201 5113 OVERTIME 348.86 500.00 500.00 1,546.92 1,500.00 3,000.00 500.0% 1014201 5116 FRINGE BEN 64,433.34 86,350.00 86,350.00 68,286.25 86,350.00 88,300.00 2.3% 1014201 5116 20101 FRINGE BEN 42.99 .00 .00 9.02 .00 .00 .0% 1014201 5116 20106 FRINGE BEN 61.59 .00 .00 4.90 .00 .00 .0% 1014201 5116 20107 FRINGE BEN .00 .00 .00 8.72 .00 .00 .0% 1014201 5116 20108 FRINGE BEN 293.50 .00 .00 257.46 .00 .00 .0% 1014201 5116 91025 FRINGE BEN .00 .00 .00 68.41 .00 .00 .0%

Page 90 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 15 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1014201 5117 RETIR CNTR 30,642.59 34,350.00 34,350.00 29,848.89 34,350.00 38,740.00 12.8% 1014201 5117 20101 RETIR CNTR 309.22 .00 .00 68.19 .00 .00 .0% 1014201 5117 20106 RETIR CNTR 442.22 .00 .00 37.06 .00 .00 .0% 1014201 5117 20107 RETIR CNTR .00 .00 .00 57.34 .00 .00 .0% 1014201 5117 20108 RETIR CNTR 376.57 .00 .00 157.47 .00 .00 .0% 1014201 5117 91025 RETIR CNTR .00 .00 .00 35.06 .00 .00 .0% 1014201 5211 POSTAGE 5,185.90 9,000.00 6,200.00 6,000.00 6,200.00 9,500.00 53.2% 1014201 5211 20108 POSTAGE .00 .00 .00 98.45 .00 .00 .0% 1014201 5212 ADVERTISNG 70.00 200.00 200.00 19.68 200.00 200.00 .0% 1014201 5213 DUES&SUBSC 2,422.59 2,380.00 4,000.00 2,490.79 5,000.00 7,000.00 75.0% 1014201 5215 TRNG/CONF 2,646.20 4,350.00 8,500.00 3,266.14 8,500.00 10,000.00 17.6% 1014201 5216 OFFIC SUPP 3,143.66 4,000.00 6,000.00 3,499.05 6,000.00 6,500.00 8.3% 1014201 5216 20108 OFFIC SUPP 1,406.61 .00 .00 1,037.25 .00 .00 .0% 1014201 5216 20401 OFFIC SUPP 160.20 .00 .00 .00 .00 .00 .0% 1014201 5217 OTHER SUPP 3,944.19 4,500.00 6,000.00 1,375.64 6,000.00 6,500.00 8.3% 1014201 5217 20101 OTHER SUPP 783.69 .00 .00 .00 .00 .00 .0% 1014201 5217 20106 OTHER SUPP 10.75 .00 .00 .00 .00 .00 .0% 1014201 5217 20108 OTHER SUPP 329.70 .00 .00 .00 .00 .00 .0% 1014201 5218 UNIFRM EXP 677.75 1,000.00 5,000.00 4,231.30 5,000.00 8,000.00 60.0% 1014201 5219 PERM/LC/FE 1,567.00 1,500.00 1,600.00 1,590.51 1,600.00 2,500.00 56.3% 1014201 5220 FUEL USAGE 4,860.97 4,000.00 8,000.00 4,840.93 8,000.00 9,000.00 12.5% 1014201 5221 MILE REIMB .00 200.00 .00 .00 620.00 1,000.00 .0% 1014201 5222 PRNT/MAIL .00 200.00 200.00 112.03 200.00 650.00 225.0% 1014201 5226 TEAM BLDG .00 .00 .00 40.00 .00 600.00 .0% 1014201 5231 FURN&OFFC 1,411.08 500.00 500.00 380.34 500.00 1,000.00 100.0% 1014201 5232 COMP EQUIP 2,135.74 2,500.00 2,500.00 170.85 2,500.00 2,500.00 .0% 1014201 5233 OTHR EQUIP 250.89 200.00 200.00 257.98 200.00 500.00 150.0% 1014201 5233 20108 OTHR EQUIP 32.69 .00 .00 .00 .00 .00 .0% 1014201 5236 RENT 1,869.60 2,500.00 2,500.00 1,632.00 2,500.00 3,000.00 20.0% 1014201 5237 UTL-SWR .00 .00 375.00 389.91 375.00 500.00 33.3% 1014201 5241 UTL-ELECTR 12,721.61 12,000.00 25,250.00 16,434.46 25,250.00 30,000.00 18.8% 1014201 5242 UTL-GAS 1,035.11 1,000.00 1,575.00 3,223.98 4,000.00 5,000.00 217.5% 1014201 5244 UTL-WATER .00 1,810.00 1,300.00 1,040.28 1,300.00 2,000.00 53.8% 1014201 5255 BANKNG SVS 22,706.23 20,000.00 25,000.00 21,092.39 25,000.00 30,000.00 20.0% 1014201 5258 OTHER SVS 14,489.45 21,100.00 19,000.00 17,460.00 19,000.00 30,000.00 57.9% 1014201 5258 20611 OTHER SVS 322.71 .00 .00 .00 .00 .00 .0% 1014201 5290 LATE CHARG 30.09 .00 .00 .00 .00 .00 .0% 1014201 5701 INFO SYS 67,710.00 72,810.00 72,810.00 72,816.00 72,810.00 76,280.00 4.8% 1014201 5702 FLT-MT&RP 6,580.00 3,990.00 3,990.00 3,996.00 3,990.00 15,070.00 277.7% 1014201 5703 VEH ACQ .00 500.00 500.00 504.00 500.00 .00 -100.0% 1014201 5705 SF LIAB 130,770.00 164,140.00 164,140.00 164,136.00 164,140.00 243,200.00 48.2% 1014201 5706 OPB&BN ALC 16,130.00 16,230.00 16,230.00 16,236.00 16,230.00 16,480.00 1.5% 1014201 5707 PERSUALALC 105,460.00 152,360.00 152,360.00 152,364.00 152,360.00 148,180.00 -2.7% TOTAL RECREATION ADMINISTRAT 908,214.77 996,500.00 1,167,460.00 1,003,184.64 1,032,505.00 1,628,170.00 39.5% 1014202 RECREATION CLASSES
1014202 5111 20104 SALARY-FT .00 .00 .00 .00 .00 47,780.00 .0%

Page 91 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 16 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1014202 5112 SALARY-PT 421.25 .00 .00 38,518.64 .00 .00 .0% 1014202 5112 20203 SALARY-PT .00 .00 .00 733.61 .00 .00 .0% 1014202 5112 20206 SALARY-PT 2,658.88 .00 .00 1,177.17 .00 .00 .0% 1014202 5112 20207 SALARY-PT 36.08 .00 .00 .00 .00 .00 .0% 1014202 5112 20208 SALARY-PT 2,366.03 .00 .00 1,544.47 .00 .00 .0% 1014202 5112 20211 SALARY-PT 460.02 .00 .00 119.34 .00 .00 .0% 1014202 5116 FRINGE BEN 6.11 .00 .00 558.54 .00 12,490.00 .0% 1014202 5116 20203 FRINGE BEN .00 .00 .00 10.64 .00 .00 .0% 1014202 5116 20206 FRINGE BEN 38.56 .00 .00 17.06 .00 .00 .0% 1014202 5116 20207 FRINGE BEN .52 .00 .00 .00 .00 .00 .0% 1014202 5116 20208 FRINGE BEN 34.29 .00 .00 22.39 .00 .00 .0% 1014202 5116 20211 FRINGE BEN 6.65 .00 .00 1.74 .00 .00 .0% 1014202 5117 RETIR CNTR 45.02 .00 .00 3,404.62 .00 5,210.00 .0% 1014202 5117 20203 RETIR CNTR .00 .00 .00 39.64 .00 .00 .0% 1014202 5117 20206 RETIR CNTR 184.22 .00 .00 100.87 .00 .00 .0% 1014202 5117 20207 RETIR CNTR 3.76 .00 .00 .00 .00 .00 .0% 1014202 5117 20208 RETIR CNTR 246.96 .00 .00 169.28 .00 .00 .0% 1014202 5117 20211 RETIR CNTR 47.94 .00 .00 13.08 .00 .00 .0% 1014202 5211 POSTAGE .00 250.00 250.00 .00 250.00 300.00 20.0% 1014202 5211 20205 POSTAGE 129.60 .00 .00 242.10 .00 .00 .0% 1014202 5213 DUES&SUBSC .00 .00 15.00 14.99 .00 .00 .0% 1014202 5215 TRNG/CONF 231.23 500.00 485.00 411.78 500.00 500.00 3.1% 1014202 5217 OTHER SUPP 3,512.76 11,500.00 11,500.00 421.58 11,500.00 15,000.00 30.4% 1014202 5217 20201 OTHER SUPP 363.54 .00 .00 212.43 .00 .00 .0% 1014202 5217 20202 OTHER SUPP 232.56 .00 .00 19.36 .00 .00 .0% 1014202 5217 20203 OTHER SUPP .00 .00 .00 101.20 .00 .00 .0% 1014202 5217 20204 OTHER SUPP 270.80 .00 .00 .00 .00 .00 .0% 1014202 5217 20205 OTHER SUPP 51.54 .00 .00 .00 .00 .00 .0% 1014202 5217 20206 OTHER SUPP 54.52 .00 .00 125.31 .00 .00 .0% 1014202 5217 20207 OTHER SUPP 1,610.00 .00 .00 1,228.75 .00 .00 .0% 1014202 5217 20208 OTHER SUPP 841.76 .00 .00 706.79 .00 .00 .0% 1014202 5217 20209 OTHER SUPP 305.15 .00 .00 348.25 .00 .00 .0% 1014202 5217 20211 OTHER SUPP 1,013.22 .00 .00 280.54 .00 .00 .0% 1014202 5217 20611 OTHER SUPP 39.80 .00 .00 .00 .00 .00 .0% 1014202 5231 FURN&OFFC 461.05 .00 .00 .00 .00 .00 .0% 1014202 5253 CONTRC SVS 113,736.00 120,000.00 120,000.00 108,547.93 120,000.00 150,000.00 25.0% 1014202 5258 OTHER SVS .00 33,500.00 33,500.00 32,000.00 33,500.00 36,000.00 7.5% TOTAL RECREATION CLASSES 129,409.82 165,750.00 165,750.00 191,092.10 165,750.00 267,280.00 61.3% 1014203 RECREATION FACILITIES
1014203 5111 SALARY-FT .00 20,330.00 20,330.00 13,629.87 20,330.00 42,770.00 110.4% 1014203 5112 20301 SALARY-PT 2,695.36 .00 .00 3,713.60 .00 .00 .0%

Page 92 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 17 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1014203 5112 20302 SALARY-PT .00 .00 .00 74.48 .00 .00 .0% 1014203 5112 20304 SALARY-PT .00 .00 .00 491.18 .00 .00 .0% 1014203 5112 20305 SALARY-PT .00 .00 .00 1,622.44 .00 .00 .0% 1014203 5116 FRINGE BEN .00 5,500.00 5,500.00 2,146.09 5,500.00 11,160.00 102.9% 1014203 5116 20301 FRINGE BEN 39.12 .00 .00 53.81 .00 .00 .0% 1014203 5116 20302 FRINGE BEN .00 .00 .00 1.08 .00 .00 .0% 1014203 5116 20304 FRINGE BEN .00 .00 .00 7.12 .00 .00 .0% 1014203 5116 20305 FRINGE BEN .00 .00 .00 23.52 .00 .00 .0% 1014203 5117 RETIR CNTR .00 2,220.00 2,220.00 1,493.83 2,220.00 4,650.00 109.5% 1014203 5117 20301 RETIR CNTR .00 .00 .00 60.22 .00 .00 .0% 1014203 5117 20305 RETIR CNTR .00 .00 .00 145.60 .00 .00 .0% 1014203 5217 OTHER SUPP 1,524.66 5,500.00 5,000.00 1,693.22 5,500.00 7,500.00 50.0% 1014203 5217 20301 OTHER SUPP 28.64 .00 .00 .00 .00 .00 .0% 1014203 5217 20401 OTHER SUPP 82.62 .00 .00 .00 .00 .00 .0% 1014203 5231 FURN&OFFC 2,744.76 2,500.00 3,000.00 1,436.20 2,500.00 2,000.00 -33.3% 1014203 5234 OTH EQ RNT .00 .00 2,500.00 2,050.00 2,500.00 .00 .0% 1014203 5241 UTL-ELECTR 18,806.16 19,000.00 25,000.00 19,911.09 19,000.00 24,000.00 -4.0% 1014203 5253 CONTRC SVS .00 2,000.00 2,000.00 .00 .00 .00 .0% 1014203 5299 PY EXP 1,500.00 .00 .00 .00 .00 .00 .0% 1014203 5701 INFO SYS 11,230.00 8,820.00 8,820.00 8,820.00 8,820.00 10,660.00 20.9% 1014203 5704 BDG MT ALC 216,820.00 244,070.00 244,070.00 244,068.00 244,070.00 267,570.00 9.6% TOTAL RECREATION FACILITIES 255,471.32 309,940.00 318,440.00 301,441.35 310,440.00 370,310.00 16.3% 1014204 RECREATION PARKS
1014204 5111 SALARY-FT .00 20,330.00 20,330.00 13,629.87 20,330.00 38,100.00 87.4% 1014204 5112 SALARY-PT 154.50 83,000.00 83,000.00 1,064.26 83,000.00 .00 .0% 1014204 5112 20401 SALARY-PT 22,767.44 .00 .00 24,219.85 .00 .00 .0% 1014204 5112 20403 SALARY-PT 11,704.67 .00 .00 5,997.67 .00 .00 .0% 1014204 5116 FRINGE BEN 2.24 6,700.00 6,700.00 2,161.55 6,700.00 9,930.00 48.2% 1014204 5116 20401 FRINGE BEN 330.10 .00 .00 351.19 .00 .00 .0% 1014204 5116 20403 FRINGE BEN 169.77 .00 .00 86.98 .00 .00 .0% 1014204 5117 RETIR CNTR .00 2,220.00 2,220.00 1,583.82 2,220.00 4,130.00 86.0% 1014204 5117 20401 RETIR CNTR 18.80 .00 .00 158.16 .00 .00 .0% 1014204 5117 20403 RETIR CNTR 48.94 .00 .00 48.59 .00 .00 .0% 1014204 5212 ADVERTISNG .00 300.00 300.00 .00 300.00 600.00 100.0% 1014204 5215 TRNG/CONF 382.58 400.00 400.00 .00 400.00 600.00 50.0% 1014204 5216 OFFIC SUPP .00 300.00 1,000.00 160.99 1,000.00 2,000.00 100.0% 1014204 5217 OTHER SUPP 408.54 450.00 1,000.00 921.27 1,000.00 2,500.00 150.0% 1014204 5217 20401 OTHER SUPP 25.85 .00 .00 201.29 .00 .00 .0% 1014204 5217 21311 OTHER SUPP .00 .00 .00 25.84 .00 .00 .0% 1014204 5222 PRINTING .00 .00 .00 .00 .00 500.00 .0% 1014204 5258 OTHER SVS 4,560.00 6,000.00 4,750.00 4,560.00 4,560.00 6,500.00 36.8%

Page 93 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 18 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL RECREATION PARKS 40,573.43 119,700.00 119,700.00 55,171.33 119,510.00 64,860.00 -45.8% 1014205 SENIOR CENTER
1014205 5111 SALARY-FT 85,839.77 89,640.00 89,640.00 83,587.29 89,640.00 60,680.00 -32.3% 1014205 5112 SALARY-PT 81,446.43 66,000.00 87,660.00 105,431.97 87,660.00 .00 .0% 1014205 5112 20542 SALARY-PT 1,582.03 .00 .00 855.56 .00 .00 .0% 1014205 5112 20543 SALARY-PT .00 .00 .00 438.04 .00 .00 .0% 1014205 5112 20544 SALARY-PT 145.16 .00 .00 .00 .00 .00 .0% 1014205 5112 20546 SALARY-PT .00 .00 .00 608.79 .00 .00 .0% 1014205 5112 20549 SALARY-PT 98.81 .00 .00 .00 .00 .00 .0% 1014205 5112 20553 SALARY-PT 243.33 .00 .00 .00 .00 .00 .0% 1014205 5112 20554 SALARY-PT .00 .00 .00 31.50 .00 .00 .0% 1014205 5112 20555 SALARY-PT 82.13 .00 .00 .00 .00 .00 .0% 1014205 5112 20559 SALARY-PT .00 .00 .00 104.67 .00 .00 .0% 1014205 5113 OVERTIME 18.36 50.00 50.00 77.72 50.00 .00 .0% 1014205 5116 FRINGE BEN 20,805.52 25,480.00 25,480.00 18,367.65 25,480.00 15,890.00 -37.6% 1014205 5116 20542 FRINGE BEN 22.92 .00 .00 12.40 .00 .00 .0% 1014205 5116 20543 FRINGE BEN .00 .00 .00 6.35 .00 .00 .0% 1014205 5116 20544 FRINGE BEN 2.11 .00 .00 .00 .00 .00 .0% 1014205 5116 20546 FRINGE BEN .00 .00 .00 8.83 .00 .00 .0% 1014205 5116 20549 FRINGE BEN 1.43 .00 .00 .00 .00 .00 .0% 1014205 5116 20553 FRINGE BEN 3.53 .00 .00 .00 .00 .00 .0% 1014205 5116 20554 FRINGE BEN .00 .00 .00 .46 .00 .00 .0% 1014205 5116 20555 FRINGE BEN 1.19 .00 .00 .00 .00 .00 .0% 1014205 5116 20559 FRINGE BEN .00 .00 .00 1.52 .00 .00 .0% 1014205 5117 RETIR CNTR 13,928.87 9,800.00 9,800.00 15,801.40 9,800.00 6,620.00 -32.4% 1014205 5117 20542 RETIR CNTR 127.12 .00 .00 93.21 .00 .00 .0% 1014205 5117 20543 RETIR CNTR .00 .00 .00 36.78 .00 .00 .0% 1014205 5117 20544 RETIR CNTR 15.12 .00 .00 .00 .00 .00 .0% 1014205 5117 20546 RETIR CNTR .00 .00 .00 35.50 .00 .00 .0% 1014205 5117 20549 RETIR CNTR 10.29 .00 .00 .00 .00 .00 .0% 1014205 5117 20555 RETIR CNTR 8.56 .00 .00 .00 .00 .00 .0% 1014205 5117 20559 RETIR CNTR .00 .00 .00 11.47 .00 .00 .0% 1014205 5211 POSTAGE .00 100.00 100.00 .00 100.00 450.00 350.0% 1014205 5212 ADVERTISNG .00 200.00 200.00 .00 200.00 500.00 150.0% 1014205 5213 DUES&SUBSC .00 550.00 550.00 .00 550.00 600.00 9.1% 1014205 5215 TRNG/CONF 295.03 400.00 400.00 .00 400.00 500.00 25.0% 1014205 5216 OFFIC SUPP 1,251.81 2,000.00 3,500.00 1,473.21 3,500.00 6,500.00 85.7% 1014205 5217 OTHER SUPP 3,735.55 9,000.00 13,940.00 1,209.99 13,940.00 30,000.00 115.2% 1014205 5217 20542 OTHER SUPP 641.79 .00 .00 508.27 .00 .00 .0% 1014205 5217 20543 OTHER SUPP 334.98 .00 .00 3,934.18 .00 .00 .0% 1014205 5217 20544 OTHER SUPP 365.96 .00 .00 .00 .00 .00 .0%

Page 94 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 19 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1014205 5217 20545 OTHER SUPP 94.32 .00 .00 .00 .00 .00 .0% 1014205 5217 20546 OTHER SUPP 454.47 .00 .00 1,009.09 .00 .00 .0% 1014205 5217 20547 OTHER SUPP 840.04 .00 .00 600.11 .00 .00 .0% 1014205 5217 20548 OTHER SUPP 841.29 .00 .00 929.55 .00 .00 .0% 1014205 5217 20549 OTHER SUPP 950.85 .00 .00 .00 .00 .00 .0% 1014205 5217 20550 OTHER SUPP 127.86 .00 .00 158.62 .00 .00 .0% 1014205 5217 20552 OTHER SUPP 462.15 .00 .00 .00 .00 .00 .0% 1014205 5217 20553 OTHER SUPP 341.78 .00 .00 270.74 .00 .00 .0% 1014205 5217 20554 OTHER SUPP 164.37 .00 .00 247.22 .00 .00 .0% 1014205 5217 20555 OTHER SUPP 319.50 .00 .00 .00 .00 .00 .0% 1014205 5217 20556 OTHER SUPP 65.50 .00 .00 .00 .00 .00 .0% 1014205 5217 20557 OTHER SUPP .00 .00 .00 420.01 .00 .00 .0% 1014205 5217 20559 OTHER SUPP 1,520.23 .00 .00 1,569.99 .00 .00 .0% 1014205 5217 32304 OTHER SUPP 94.83 .00 .00 .00 .00 .00 .0% 1014205 5219 PERM/LC/FE .00 .00 .00 .00 .00 600.00 .0% 1014205 5222 PRINTING .00 .00 .00 .00 .00 1,600.00 .0% 1014205 5231 FURN&OFFC -114.58 .00 80.00 75.41 80.00 3,300.00 4025.0% 1014205 5232 COMP EQUIP .00 .00 220.00 .00 .00 2,500.00 1036.4% 1014205 5233 OTHR EQUIP 30.14 .00 .00 215.86 220.00 3,500.00 .0% 1014205 5233 20547 OTHR EQUIP 75.41 .00 .00 .00 .00 .00 .0% 1014205 5237 UTL-SWR .00 .00 100.00 401.28 375.00 500.00 400.0% 1014205 5241 UTL-ELECTR 11,527.76 12,000.00 16,000.00 11,512.26 16,000.00 18,000.00 12.5% 1014205 5242 UTL-GAS 3,928.49 6,000.00 4,000.00 8,694.55 9,000.00 10,000.00 150.0% 1014205 5244 UTL-WATER .00 2,000.00 1,000.00 1,504.28 1,500.00 2,000.00 100.0% 1014205 5258 OTHER SVS 60.00 4,500.00 4,500.00 .00 4,500.00 4,500.00 .0% 1014205 5258 20543 OTHER SVS .00 .00 .00 420.20 .00 .00 .0% 1014205 5258 20544 OTHER SVS 500.00 .00 .00 .00 .00 .00 .0% 1014205 5258 20545 OTHER SVS .00 .00 .00 100.00 .00 .00 .0% 1014205 5258 20546 OTHER SVS .00 .00 .00 38.79 .00 .00 .0% 1014205 5258 20547 OTHER SVS 75.00 .00 .00 .00 .00 .00 .0% 1014205 5258 20548 OTHER SVS .00 .00 .00 250.00 .00 .00 .0% 1014205 5258 20549 OTHER SVS 300.00 .00 .00 .00 .00 .00 .0% 1014205 5258 20553 OTHER SVS .00 .00 .00 614.60 .00 .00 .0% 1014205 5258 20555 OTHER SVS 125.00 .00 .00 .00 .00 .00 .0% 1014205 5258 20559 OTHER SVS .00 .00 .00 125.00 .00 .00 .0% 1014205 5701 INFO SYS 38,600.00 48,180.00 48,180.00 48,180.00 48,180.00 50,670.00 5.2% 1014205 5704 BDG MT ALC 99,820.00 94,470.00 94,470.00 94,476.00 94,470.00 94,340.00 -.1% TOTAL SENIOR CENTER 372,212.21 370,370.00 399,870.00 404,450.32 405,645.00 313,250.00 -21.7% 1014206 SPECIAL EVENTS
1014206 5111 SALARY-FT 271.71 20,330.00 14,730.00 13,629.87 14,730.00 27,190.00 84.6% 1014206 5112 SALARY-PT 2,506.77 4,700.00 18,340.00 .00 18,340.00 .00 .0%

Page 95 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 20 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1014206 5112 20611 SALARY-PT 3,647.38 .00 .00 3,173.14 .00 .00 .0% 1014206 5112 20612 SALARY-PT 154.50 .00 .00 572.31 .00 .00 .0% 1014206 5112 20613 SALARY-PT 1,591.41 .00 .00 1,586.36 .00 .00 .0% 1014206 5112 20614 SALARY-PT 985.06 .00 .00 322.57 .00 .00 .0% 1014206 5112 20617 SALARY-PT 941.70 .00 .00 1,035.74 .00 .00 .0% 1014206 5112 20619 SALARY-PT 1,163.55 .00 .00 899.75 .00 .00 .0% 1014206 5112 20620 SALARY-PT 428.76 .00 .00 1,005.02 .00 .00 .0% 1014206 5112 20621 SALARY-PT 1,829.19 .00 .00 770.72 .00 .00 .0% 1014206 5112 20622 SALARY-PT 54.12 .00 .00 .00 .00 .00 .0% 1014206 5112 20623 SALARY-PT 403.70 .00 .00 717.70 .00 .00 .0% 1014206 5112 20626 SALARY-PT 156.16 .00 .00 .00 .00 .00 .0% 1014206 5112 20627 SALARY-PT .00 .00 .00 809.61 .00 .00 .0% 1014206 5112 20628 SALARY-PT .00 .00 .00 91.03 .00 .00 .0% 1014206 5112 20629 SALARY-PT .00 .00 .00 1,110.82 .00 .00 .0% 1014206 5112 50102 SALARY-PT 1,862.98 .00 .00 .00 .00 .00 .0% 1014206 5113 OVERTIME 487.84 2,900.00 9,340.00 .00 9,340.00 15,000.00 60.6% 1014206 5113 20611 OVERTIME 1,970.25 .00 .00 2,559.56 .00 .00 .0% 1014206 5113 20613 OVERTIME 614.10 .00 .00 2,106.02 .00 .00 .0% 1014206 5113 50102 OVERTIME 1,166.81 .00 .00 .00 .00 .00 .0% 1014206 5116 FRINGE BEN 224.57 5,570.00 3,680.00 2,146.10 3,680.00 7,090.00 92.7% 1014206 5116 20611 FRINGE BEN 324.15 .00 .00 497.14 .00 .00 .0% 1014206 5116 20612 FRINGE BEN 2.24 .00 .00 8.31 .00 .00 .0% 1014206 5116 20613 FRINGE BEN 236.56 .00 .00 303.94 .00 .00 .0% 1014206 5116 20614 FRINGE BEN 14.28 .00 .00 4.68 .00 .00 .0% 1014206 5116 20617 FRINGE BEN 13.64 .00 .00 15.01 .00 .00 .0% 1014206 5116 20619 FRINGE BEN 16.87 .00 .00 13.05 .00 .00 .0% 1014206 5116 20620 FRINGE BEN 6.22 .00 .00 14.57 .00 .00 .0% 1014206 5116 20621 FRINGE BEN 26.51 .00 .00 11.19 .00 .00 .0% 1014206 5116 20622 FRINGE BEN .79 .00 .00 .00 .00 .00 .0% 1014206 5116 20623 FRINGE BEN 5.86 .00 .00 10.42 .00 .00 .0% 1014206 5116 20626 FRINGE BEN 2.26 .00 .00 .00 .00 .00 .0% 1014206 5116 20627 FRINGE BEN .00 .00 .00 11.74 .00 .00 .0% 1014206 5116 20628 FRINGE BEN .00 .00 .00 1.32 .00 .00 .0% 1014206 5116 20629 FRINGE BEN .00 .00 .00 16.10 .00 .00 .0% 1014206 5116 50102 FRINGE BEN 138.13 .00 .00 .00 .00 .00 .0% 1014206 5117 RETIR CNTR 216.01 2,220.00 2,500.00 1,493.81 2,500.00 2,950.00 18.0% 1014206 5117 20611 RETIR CNTR 192.51 .00 .00 149.94 .00 .00 .0% 1014206 5117 20612 RETIR CNTR .00 .00 .00 38.55 .00 .00 .0% 1014206 5117 20613 RETIR CNTR 8.85 .00 .00 99.10 .00 .00 .0% 1014206 5117 20614 RETIR CNTR 95.40 .00 .00 26.28 .00 .00 .0% 1014206 5117 20617 RETIR CNTR 30.05 .00 .00 18.14 .00 .00 .0% 1014206 5117 20619 RETIR CNTR 100.64 .00 .00 44.72 .00 .00 .0% 1014206 5117 20620 RETIR CNTR 8.86 .00 .00 45.56 .00 .00 .0% 1014206 5117 20621 RETIR CNTR 72.79 .00 .00 35.31 .00 .00 .0%

Page 96 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 21 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1014206 5117 20622 RETIR CNTR 5.64 .00 .00 .00 .00 .00 .0% 1014206 5117 20623 RETIR CNTR 16.87 .00 .00 29.99 .00 .00 .0% 1014206 5117 20626 RETIR CNTR 7.52 .00 .00 .00 .00 .00 .0% 1014206 5117 20627 RETIR CNTR .00 .00 .00 50.70 .00 .00 .0% 1014206 5117 20629 RETIR CNTR .00 .00 .00 59.69 .00 .00 .0% 1014206 5117 50102 RETIR CNTR 26.54 .00 .00 .00 .00 .00 .0% 1014206 5133 50102 OT-SW PD 19,308.70 .00 .00 .00 .00 .00 .0% 1014206 5136 50102 FRG B-S PD 1,489.99 .00 .00 .00 .00 .00 .0% 1014206 5137 50102 RT CNTR-PD 196.67 .00 .00 .00 .00 .00 .0% 1014206 5211 20205 POSTAGE .00 .00 .00 42.00 .00 .00 .0% 1014206 5212 ADVERTISNG 214.50 3,500.00 1,350.00 .00 2,300.00 3,000.00 122.2% 1014206 5212 20611 ADVERTISNG 182.25 .00 .00 .00 .00 .00 .0% 1014206 5212 20617 ADVERTISNG 40.50 .00 .00 .00 .00 .00 .0% 1014206 5212 20619 ADVERTISNG .00 .00 .00 233.75 .00 .00 .0% 1014206 5215 TRNG/CONF .00 500.00 500.00 .00 500.00 500.00 .0% 1014206 5217 OTHER SUPP 4,060.36 45,000.00 65,000.00 360.85 65,000.00 90,000.00 38.5% 1014206 5217 20205 OTHER SUPP 76.35 .00 .00 4.31 .00 .00 .0% 1014206 5217 20611 OTHER SUPP 11,364.07 .00 .00 594.08 .00 .00 .0% 1014206 5217 20612 OTHER SUPP 327.58 .00 .00 406.21 .00 .00 .0% 1014206 5217 20613 OTHER SUPP 5,916.19 .00 .00 2,296.13 .00 .00 .0% 1014206 5217 20614 OTHER SUPP 744.81 .00 .00 884.62 .00 .00 .0% 1014206 5217 20617 OTHER SUPP 1,727.10 .00 .00 333.37 .00 .00 .0% 1014206 5217 20619 OTHER SUPP 1,941.41 .00 .00 1,678.41 .00 .00 .0% 1014206 5217 20620 OTHER SUPP 171.56 .00 .00 626.71 .00 .00 .0% 1014206 5217 20621 OTHER SUPP 8,574.63 .00 .00 9,763.15 .00 .00 .0% 1014206 5217 20622 OTHER SUPP 219.82 .00 .00 2,962.16 .00 .00 .0% 1014206 5217 20623 OTHER SUPP 3,358.90 .00 .00 1,000.00 .00 .00 .0% 1014206 5217 20627 OTHER SUPP 4,586.63 .00 .00 5,325.00 .00 .00 .0% 1014206 5217 20628 OTHER SUPP .00 .00 .00 508.79 .00 .00 .0% 1014206 5217 20629 OTHER SUPP .00 .00 .00 548.00 .00 .00 .0% 1014206 5217 50102 OTHER SUPP 1,005.78 .00 .00 .00 .00 .00 .0% 1014206 5219 PERM/LC/FE .00 .00 1,586.00 .00 2,500.00 10,000.00 530.5% 1014206 5219 20611 PERM/LC/FE 260.74 .00 598.00 1,081.00 .00 .00 .0% 1014206 5219 20613 PERM/LC/FE 260.74 300.00 316.00 315.95 .00 .00 .0% 1014206 5222 PRINTING .00 2,250.00 3,800.00 .00 3,800.00 6,000.00 57.9% 1014206 5222 20611 PRINTING 822.40 .00 .00 .00 .00 .00 .0% 1014206 5222 20619 PRINTING .00 .00 .00 58.19 .00 .00 .0% 1014206 5233 OTHR EQUIP 80.75 1,000.00 2,500.00 .00 2,500.00 3,500.00 40.0% 1014206 5233 20613 OTHR EQUIP .00 .00 .00 1,672.62 .00 .00 .0% 1014206 5233 20617 OTHR EQUIP 326.99 .00 .00 .00 .00 .00 .0% 1014206 5233 20619 OTHR EQUIP 215.50 .00 .00 .00 .00 .00 .0% 1014206 5234 OTH EQ RNT 6,723.60 13,000.00 30,000.00 5,682.47 25,000.00 50,000.00 66.7% 1014206 5234 20611 OTH EQ RNT 990.67 .00 .00 15,123.67 .00 .00 .0% 1014206 5234 20612 OTH EQ RNT .00 .00 .00 1,000.00 .00 .00 .0%

Page 97 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 22 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1014206 5234 20613 OTH EQ RNT .00 .00 .00 3,892.70 .00 .00 .0% 1014206 5234 20619 OTH EQ RNT .00 .00 .00 1,401.40 .00 .00 .0% 1014206 5234 20621 OTH EQ RNT 193.95 .00 .00 447.16 .00 .00 .0% 1014206 5234 50102 OTH EQ RNT 17,500.00 .00 .00 .00 .00 .00 .0% 1014206 5236 RENT .00 .00 .00 .00 .00 15,000.00 .0% 1014206 5253 CONTRC SVS 3,000.00 15,000.00 15,000.00 13,500.00 15,000.00 15,000.00 .0% 1014206 5258 OTHER SVS .00 70,000.00 90,000.00 .00 80,000.00 115,000.00 27.8% 1014206 5258 20611 OTHER SVS 42,386.76 .00 .00 26,413.00 .00 .00 .0% 1014206 5258 20613 OTHER SVS .00 .00 .00 229.50 .00 .00 .0% 1014206 5258 20617 OTHER SVS 1,960.00 .00 .00 2,190.00 .00 .00 .0% 1014206 5258 20619 OTHER SVS .00 .00 .00 12,000.00 .00 .00 .0% 1014206 5258 20620 OTHER SVS 1,156.55 .00 .00 .00 .00 .00 .0% 1014206 5258 20621 OTHER SVS 4,012.10 .00 .00 1,897.40 .00 .00 .0% 1014206 5258 20623 OTHER SVS .00 .00 .00 2,319.36 .00 .00 .0% 1014206 5258 20627 OTHER SVS .00 .00 .00 1,631.33 .00 .00 .0% 1014206 5294 SPONSOR .00 .00 .00 .00 7,000.00 10,000.00 .0% 1014206 5294 20621 SPONSOR .00 .00 4,000.00 4,000.00 .00 .00 .0% 1014206 5294 50102 SPONSOR .00 3,000.00 3,000.00 .00 .00 .00 .0% 1014206 5297 OTHR EXP .00 .00 10.00 .00 10.00 .00 .0% 1014206 5297 20623 OTHR EXP .00 .00 .00 4.05 .00 .00 .0% TOTAL SPECIAL EVENTS 167,428.30 189,270.00 266,250.00 157,962.92 252,200.00 370,230.00 39.1% 1015201 PUBLIC WORKS ADMINISTRATION
1015201 5110 BUY BACKS 2,702.96 13,970.00 13,970.00 3,332.06 13,970.00 19,000.00 36.0% 1015201 5111 SALARY-FT 61,101.65 67,970.00 67,970.00 62,493.22 67,970.00 75,040.00 10.4% 1015201 5112 SALARY-PT 3,042.92 4,260.00 4,260.00 .00 4,260.00 4,570.00 7.3% 1015201 5113 OVERTIME 108.13 .00 .00 548.15 .00 .00 .0% 1015201 5116 FRINGE BEN 17,853.69 20,670.00 20,670.00 18,090.40 20,670.00 22,610.00 9.4% 1015201 5117 RETIR CNTR 6,223.29 7,250.00 7,250.00 6,458.09 7,250.00 8,780.00 21.1% 1015201 5213 DUES&SUBSC 385.20 3,000.00 3,000.00 1,714.65 3,000.00 3,000.00 .0% 1015201 5215 TRNG/CONF 3,829.85 5,000.00 5,000.00 3,928.51 5,000.00 10,000.00 100.0% 1015201 5215 40155 TRNG/CONF 318.56 .00 .00 .00 .00 .00 .0% 1015201 5216 OFFIC SUPP 2,207.03 3,000.00 3,000.00 3,655.03 3,000.00 3,000.00 .0% 1015201 5217 OTHER SUPP 4,000.51 6,000.00 6,000.00 3,816.05 3,000.00 2,000.00 -66.7% 1015201 5217 40155 OTHER SUPP 82.08 .00 .00 .00 .00 .00 .0% 1015201 5218 UNIFRM EXP 728.39 .00 .00 949.81 1,000.00 1,000.00 .0% 1015201 5219 PERM/LC/FE 260.00 .00 .00 .00 .00 .00 .0% 1015201 5220 FUEL USAGE 3,812.65 5,500.00 5,500.00 3,178.81 5,500.00 5,500.00 .0% 1015201 5220 13281 FUEL USAGE -2,668.57 .00 .00 -2,036.86 .00 .00 .0% 1015201 5222 PRNT/MAIL 190.72 750.00 750.00 .00 750.00 750.00 .0% 1015201 5226 TEAM BLDG .00 .00 .00 .00 .00 4,000.00 .0% 1015201 5231 FURN&OFFC 4,170.69 5,000.00 5,000.00 75.41 5,000.00 5,000.00 .0%

Page 98 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 23 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1015201 5237 UTL-SWR .00 .00 .00 250.60 .00 .00 .0% 1015201 5241 UTL-ELECTR 35,019.69 20,000.00 35,000.00 23,885.15 35,000.00 35,000.00 .0% 1015201 5242 UTL-GAS 1,258.14 1,200.00 1,200.00 2,443.87 1,200.00 1,200.00 .0% 1015201 5244 UTL-WATER .00 29,550.00 29,550.00 11,462.14 29,550.00 29,550.00 .0% 1015201 5258 OTHER SVS 974.20 1,000.00 5,800.00 5,834.29 5,500.00 5,500.00 -5.2% 1015201 5320 TUIT REIMB .00 .00 .00 413.75 .00 .00 .0% 1015201 5701 INFO SYS 191,340.00 155,570.00 155,570.00 155,568.00 155,570.00 125,790.00 -19.1% 1015201 5702 FLT-MT&RP 9,380.00 10,190.00 10,190.00 10,188.00 10,190.00 16,860.00 65.5% 1015201 5704 BDG MT ALC 207,210.00 104,580.00 104,580.00 104,580.00 104,580.00 126,980.00 21.4% 1015201 5705 SF LIAB 411,020.00 434,720.00 434,720.00 434,736.00 434,720.00 396,790.00 -8.7% 1015201 5706 OPB&BN ALC 62,200.00 53,240.00 53,240.00 53,244.00 53,240.00 49,220.00 -7.6% 1015201 5707 PERSUALALC 386,700.00 473,620.00 473,620.00 473,616.00 473,620.00 414,590.00 -12.5% TOTAL PUBLIC WORKS ADMINISTR 1,413,451.78 1,426,040.00 1,445,840.00 1,382,425.13 1,443,540.00 1,365,730.00 -5.5% 1015301 ENGINEERING ADMINISTRATION
1015301 5110 BUY BACKS 3,592.63 .00 .00 .00 .00 .00 .0% 1015301 5111 SALARY-FT 139,530.76 112,830.00 112,830.00 137,870.84 112,830.00 125,460.00 11.2% 1015301 5113 OVERTIME 10,358.01 .00 .00 12,957.65 .00 15,000.00 .0% 1015301 5116 FRINGE BEN 28,730.01 24,860.00 24,860.00 30,820.29 24,860.00 27,430.00 10.3% 1015301 5117 RETIR CNTR 14,544.79 12,340.00 12,340.00 15,059.49 12,340.00 15,100.00 22.4% 1015301 5211 POSTAGE .00 100.00 100.00 .00 100.00 100.00 .0% 1015301 5213 DUES&SUBSC .00 1,580.00 1,580.00 1,422.50 1,580.00 1,580.00 .0% 1015301 5215 TRNG/CONF 237.50 1,250.00 1,250.00 324.75 1,250.00 1,300.00 4.0% 1015301 5216 OFFIC SUPP 509.76 2,300.00 2,300.00 1,324.22 2,300.00 2,300.00 .0% 1015301 5217 OTHER SUPP .00 940.00 940.00 .00 500.00 500.00 -46.8% 1015301 5218 UNIFRM EXP 736.83 1,600.00 1,600.00 896.70 1,900.00 1,900.00 18.8% 1015301 5220 FUEL USAGE 6,625.60 2,000.00 8,400.00 5,970.72 8,400.00 8,400.00 .0% 1015301 5222 PRNT/MAIL 63.58 50.00 50.00 63.58 100.00 100.00 100.0% 1015301 5252 PROF SVS .00 20,000.00 20,000.00 19,300.00 30,000.00 20,000.00 .0% 1015301 5258 OTHER SVS 45.00 1,000.00 1,000.00 15.00 1,000.00 1,000.00 .0% 1015301 5701 INFO SYS 30,840.00 21,710.00 21,710.00 21,708.00 21,710.00 21,350.00 -1.7% 1015301 5702 FLT-MT&RP 1,540.00 2,150.00 2,150.00 2,148.00 2,150.00 5,600.00 160.5% TOTAL ENGINEERING ADMINISTRA 237,354.47 204,710.00 211,110.00 249,881.74 221,020.00 247,120.00 17.1% 1015302 DEVELOPMENT/TRAFFIC ENGINRG
1015302 5111 SALARY-FT 228,607.63 327,220.00 327,220.00 247,181.96 327,220.00 376,140.00 15.0% 1015302 5113 OVERTIME 3,169.28 .00 .00 339.08 .00 .00 .0% 1015302 5116 FRINGE BEN 48,961.64 81,580.00 81,580.00 54,445.52 81,580.00 90,980.00 11.5% 1015302 5117 RETIR CNTR 22,339.53 35,780.00 35,780.00 25,697.74 35,780.00 45,270.00 26.5% 1015302 5213 DUES&SUBSC .00 500.00 500.00 548.75 1,500.00 1,500.00 200.0%

Page 99 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 24 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1015302 5215 TRNG/CONF .00 700.00 700.00 .00 1,000.00 1,000.00 42.9% 1015302 5216 OFFIC SUPP 277.69 500.00 1,700.00 827.84 300.00 300.00 -82.4% 1015302 5217 OTHER SUPP 2,123.82 1,000.00 1,000.00 283.38 200.00 200.00 -80.0% 1015302 5218 UNIFRM EXP .00 .00 .00 .00 800.00 800.00 .0% 1015302 5219 PERM/LC/FE .00 250.00 250.00 .00 1,000.00 1,000.00 300.0% 1015302 5220 FUEL USAGE 236.97 300.00 300.00 170.32 300.00 300.00 .0% 1015302 5222 PRNT/MAIL 127.14 .00 .00 127.15 .00 .00 .0% 1015302 5231 FURN&OFFC 129.35 .00 .00 463.30 2,000.00 2,000.00 .0% 1015302 5252 PROF SVS 184,514.50 380,000.00 378,800.00 224,996.00 330,000.00 330,000.00 -12.9% 1015302 5254 DATA P SVS .00 .00 .00 2,900.00 .00 .00 .0% 1015302 5258 OTHER SVS 48,787.70 90,000.00 90,000.00 64,868.80 68,500.00 68,500.00 -23.9% 1015302 5299 PY EXP 9,575.00 .00 .00 .00 .00 .00 .0% 1015302 5702 FLT-MT&RP 910.00 1,170.00 1,170.00 1,176.00 1,170.00 2,520.00 115.4% 1015302 5703 VEH ACQ 250.00 .00 .00 .00 .00 .00 .0% TOTAL DEVELOPMENT/TRAFFIC EN 550,010.25 919,000.00 919,000.00 624,025.84 851,350.00 920,510.00 .2% 1015401 STREET MAINTENANCE
1015401 5110 BUY BACKS 4,661.07 .00 .00 5,586.60 .00 .00 .0% 1015401 5111 SALARY-FT 331,691.57 395,420.00 395,420.00 265,947.59 395,420.00 417,660.00 5.6% 1015401 5113 OVERTIME 57,387.32 60,000.00 60,000.00 45,568.60 .00 66,000.00 10.0% 1015401 5113 40155 OVERTIME 2,402.56 .00 .00 .00 .00 .00 .0% 1015401 5116 FRINGE BEN 85,221.45 127,240.00 127,240.00 63,339.54 127,240.00 137,230.00 7.9% 1015401 5116 40155 FRINGE BEN 493.58 .00 .00 .00 .00 .00 .0% 1015401 5117 RETIR CNTR 31,871.99 41,400.00 41,400.00 26,187.27 41,400.00 47,240.00 14.1% 1015401 5213 DUES&SUBSC .00 .00 .00 5,000.00 .00 .00 .0% 1015401 5217 OTHER SUPP 1,239.25 .00 .00 .00 .00 .00 .0% 1015401 5218 UNIFRM EXP 6,825.98 7,600.00 7,600.00 9,141.13 10,050.00 10,350.00 36.2% 1015401 5220 FUEL USAGE 38,556.12 28,000.00 30,000.00 24,858.34 30,000.00 30,000.00 .0% 1015401 5222 PRINTING .00 .00 .00 63.57 .00 .00 .0% 1015401 5233 OTHR EQUIP .00 6,000.00 6,000.00 3,000.00 6,000.00 10,000.00 66.7% 1015401 5234 OTH EQ RNT 3,256.74 6,000.00 6,000.00 826.71 5,000.00 5,000.00 -16.7% 1015401 5234 40155 OTH EQ RNT 11,189.86 .00 .00 .00 .00 .00 .0% 1015401 5253 CONTRC SVS 27,200.00 35,000.00 101,000.00 79,000.00 101,000.00 208,000.00 105.9% 1015401 5258 OTHER SVS 13,800.00 60,000.00 105,000.00 50,035.25 105,000.00 200,000.00 90.5% 1015401 5702 FLT-MT&RP 69,070.00 72,180.00 72,180.00 72,180.00 72,180.00 79,800.00 10.6% 1015401 5703 VEH ACQ 220,250.00 .00 .00 .00 .00 81,000.00 .0% TOTAL STREET MAINTENANCE 905,117.49 838,840.00 951,840.00 650,734.60 893,290.00 1,292,280.00 35.8% 1015402 STREET SWEEPING
1015402 5111 SALARY-FT 12,195.57 13,090.00 13,090.00 10,880.44 13,090.00 13,090.00 .0%

Page 100 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 25 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1015402 5116 FRINGE BEN 2,250.51 2,540.00 2,540.00 2,166.96 2,540.00 2,710.00 6.7% 1015402 5117 RETIR CNTR 1,271.82 1,430.00 1,430.00 1,192.58 1,430.00 1,580.00 10.5% TOTAL STREET SWEEPING 15,717.90 17,060.00 17,060.00 14,239.98 17,060.00 17,380.00 1.9% 1015403 SIDEWALK MAINTENANCE
1015403 5111 SALARY-FT 55,753.37 69,770.00 69,770.00 51,274.28 69,770.00 71,510.00 2.5% 1015403 5112 SALARY-PT 16,025.47 18,970.00 18,970.00 .00 18,970.00 19,670.00 3.7% 1015403 5113 OVERTIME 13,851.57 5,000.00 5,000.00 1,926.81 5,000.00 .00 .0% 1015403 5113 40155 OVERTIME 18,240.84 .00 .00 .00 .00 .00 .0% 1015403 5116 FRINGE BEN 16,993.36 20,530.00 20,530.00 12,471.97 20,530.00 22,030.00 7.3% 1015403 5116 40155 FRINGE BEN 3,591.18 .00 .00 .00 .00 .00 .0% 1015403 5117 RETIR CNTR 6,505.26 7,320.00 7,320.00 5,398.51 7,320.00 8,100.00 10.7% 1015403 5117 40155 RETIR CNTR 24.27 .00 .00 .00 .00 .00 .0% 1015403 5215 TRNG/CONF 48.43 .00 .00 .00 .00 .00 .0% 1015403 5217 OTHER SUPP 15,142.04 25,000.00 10,000.00 11,171.08 25,000.00 .00 -100.0% 1015403 5233 OTHR EQUIP 306.07 6,000.00 6,000.00 2,000.00 6,000.00 .00 -100.0% 1015403 5702 FLT-MT&RP 3,990.00 9,910.00 9,910.00 9,912.00 9,910.00 5,500.00 -44.5% TOTAL SIDEWALK MAINTENANCE 150,471.86 162,500.00 147,500.00 94,154.65 162,500.00 126,810.00 -14.0% 1015404 STREET LIGHTING
1015404 5111 SALARY-FT 12,195.57 13,090.00 13,090.00 10,880.44 13,090.00 13,090.00 .0% 1015404 5116 FRINGE BEN 2,250.51 2,540.00 2,540.00 2,166.96 2,540.00 2,710.00 6.7% 1015404 5117 RETIR CNTR 1,271.82 1,430.00 1,430.00 1,192.58 1,430.00 1,580.00 10.5% 1015404 5217 OTHER SUPP 19,243.21 35,000.00 40,000.00 35,653.00 40,000.00 40,000.00 .0% 1015404 5220 FUEL USAGE 1,700.28 2,500.00 2,500.00 1,543.24 2,500.00 2,500.00 .0% 1015404 5233 OTHR EQUIP 5,000.00 .00 .00 .00 .00 .00 .0% 1015404 5241 UTL-ELECTR 768,069.40 720,000.00 770,000.00 695,107.53 750,000.00 800,000.00 3.9% 1015404 5258 OTHER SVS 3,817.58 10,000.00 10,000.00 .00 10,000.00 20,000.00 100.0% 1015404 5528 IMPRV BLD .00 10,000.00 10,000.00 .00 10,000.00 .00 -100.0% 1015404 5702 FLT-MT&RP 8,760.00 12,990.00 12,990.00 12,996.00 12,990.00 8,630.00 -33.6% TOTAL STREET LIGHTING 822,308.37 807,550.00 862,550.00 759,539.75 842,550.00 888,510.00 3.0% 1015405 TRAFFIC CONTROL
1015405 5111 SALARY-FT 32,578.71 63,570.00 63,570.00 51,211.59 63,570.00 73,250.00 15.2% 1015405 5113 OVERTIME 254.46 .00 .00 2,209.81 .00 .00 .0% 1015405 5116 FRINGE BEN 6,548.78 23,630.00 23,630.00 10,648.58 23,630.00 25,610.00 8.4% 1015405 5117 RETIR CNTR 3,311.61 6,520.00 6,520.00 5,434.03 6,520.00 8,120.00 24.5% 1015405 5217 OTHER SUPP 25,775.09 45,000.00 45,000.00 38,811.14 45,000.00 .00 -100.0%

Page 101 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 26 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1015405 5258 OTHER SVS 269.50 .00 .00 1,774.44 .00 .00 .0% 1015405 5528 IMPRV BLD .00 .00 .00 5,287.82 .00 .00 .0% 1015405 5530 MACH&EQUIP 4,414.54 .00 .00 .00 .00 .00 .0% 1015405 5702 FLT-MT&RP 420.00 150.00 150.00 156.00 150.00 360.00 140.0% TOTAL TRAFFIC CONTROL 73,572.69 138,870.00 138,870.00 115,533.41 138,870.00 107,340.00 -22.7% 1015406 TRAFFIC FACILITY MAINTENANCE
1015406 5233 OTHR EQUIP 1,203.00 10,000.00 10,000.00 .00 10,000.00 10,000.00 .0% 1015406 5241 UTL-ELECTR 63,835.55 62,000.00 75,000.00 62,124.74 75,000.00 75,000.00 .0% 1015406 5258 OTHER SVS 236,176.83 202,300.00 262,300.00 185,557.89 278,000.00 278,000.00 6.0% TOTAL TRAFFIC FACILITY MAINT 301,215.38 274,300.00 347,300.00 247,682.63 363,000.00 363,000.00 4.5% 1015407 WEED ABATEMENT
1015407 5113 OVERTIME .00 1,000.00 1,000.00 .00 1,000.00 .00 .0% 1015407 5113 40155 OVERTIME 628.19 .00 .00 .00 .00 .00 .0% 1015407 5116 40155 FRINGE BEN 133.10 .00 .00 .00 .00 .00 .0% 1015407 5217 OTHER SUPP 3,805.95 12,000.00 12,000.00 4,916.85 12,000.00 .00 -100.0% 1015407 5220 FUEL USAGE 1,332.52 3,000.00 3,000.00 786.37 3,000.00 3,000.00 .0% 1015407 5233 OTHR EQUIP .00 6,000.00 6,000.00 .00 6,000.00 .00 -100.0% 1015407 5248 MAINT-OTHR .00 1,000.00 1,000.00 .00 1,000.00 .00 -100.0% 1015407 5530 MACH&EQUIP 2,998.14 .00 .00 .00 .00 .00 .0% 1015407 5702 FLT-MT&RP 2,590.00 770.00 770.00 768.00 770.00 1,410.00 83.1% TOTAL WEED ABATEMENT 11,487.90 23,770.00 23,770.00 6,471.22 23,770.00 4,410.00 -81.4% 1015408 FLOOD CONTROL
1015408 5217 OTHER SUPP .00 2,000.00 2,000.00 .00 2,000.00 .00 -100.0% 1015408 5233 OTHR EQUIP .00 1,000.00 1,000.00 .00 1,000.00 .00 .0% TOTAL FLOOD CONTROL .00 3,000.00 3,000.00 .00 3,000.00 .00 -100.0% 1015409 STREET TREE MAINTENANCE
1015409 5111 SALARY-FT 64,853.96 68,580.00 68,580.00 56,976.52 68,580.00 75,400.00 9.9% 1015409 5113 OVERTIME 151.43 .00 .00 689.30 .00 .00 .0% 1015409 5113 40155 OVERTIME 3,095.92 .00 .00 .00 .00 .00 .0% 1015409 5116 FRINGE BEN 15,469.91 17,550.00 17,550.00 14,410.23 17,550.00 19,310.00 10.0% 1015409 5116 40155 FRINGE BEN 659.77 .00 .00 .00 .00 .00 .0% 1015409 5117 RETIR CNTR 6,766.54 7,500.00 7,500.00 6,198.78 7,500.00 9,070.00 20.9%

Page 102 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 27 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1015409 5213 DUES&SUBSC .00 150.00 150.00 .00 150.00 250.00 66.7% 1015409 5253 CONTRC SVS 801,967.72 700,000.00 700,000.00 700,000.00 700,000.00 850,000.00 21.4% 1015409 5253 40155 CONTRC SVS 197,167.28 .00 .00 .00 .00 .00 .0% 1015409 5702 FLT-MT&RP .00 20.00 20.00 12.00 20.00 610.00 2950.0% TOTAL STREET TREE MAINTENANC 1,090,132.53 793,800.00 793,800.00 778,286.83 793,800.00 954,640.00 20.3% 1015410 PARKWAY MAINTENANCE-ROW
1015410 5110 BUY BACKS 2,328.98 .00 .00 2,433.79 .00 .00 .0% 1015410 5111 SALARY-FT 63,023.48 69,390.00 69,390.00 43,540.82 69,390.00 67,470.00 -2.8% 1015410 5113 OVERTIME .00 5,000.00 5,000.00 1,875.37 .00 5,000.00 .0% 1015410 5116 FRINGE BEN 13,486.59 19,290.00 19,290.00 10,600.18 19,290.00 20,800.00 7.8% 1015410 5117 RETIR CNTR 6,105.15 7,390.00 7,390.00 4,468.61 7,390.00 7,800.00 5.5% 1015410 5217 OTHER SUPP 8,486.10 20,000.00 9,700.00 14,139.21 20,000.00 40,000.00 312.4% 1015410 5220 FUEL USAGE 2,115.58 1,000.00 1,000.00 674.52 1,000.00 3,000.00 200.0% 1015410 5233 OTHR EQUIP 11,606.69 10,000.00 10,000.00 1,504.90 10,000.00 10,000.00 .0% 1015410 5237 UTL-SWR .00 .00 300.00 188.67 .00 .00 .0% 1015410 5241 UTL-ELECTR 30,072.35 25,000.00 25,000.00 9,813.95 25,000.00 35,000.00 40.0% 1015410 5244 UTL-WATER .00 445,260.00 365,260.00 227,460.36 445,260.00 445,260.00 21.9% 1015410 5245 MAINT-BLDG .00 .00 .00 398.00 .00 .00 .0% 1015410 5253 CONTRC SVS 217,992.82 270,000.00 280,000.00 280,000.00 280,000.00 264,000.00 -5.7% 1015410 5258 OTHER SVS 100,721.97 80,000.00 130,000.00 93,041.00 130,000.00 180,000.00 38.5% 1015410 5258 40155 OTHER SVS 70,395.75 .00 .00 .00 .00 .00 .0% 1015410 5530 MACH&EQUIP 2,998.15 .00 .00 .00 .00 .00 .0% 1015410 5702 FLT-MT&RP 11,700.00 10,500.00 10,500.00 10,500.00 10,500.00 4,900.00 -53.3% TOTAL PARKWAY MAINTENANCE-RO 541,033.61 962,830.00 932,830.00 700,639.38 1,017,830.00 1,083,230.00 16.1% 1015412 MAINTENANCE-MAIN STREET
1015412 5111 SALARY-FT 8,180.85 27,160.00 27,160.00 24,444.73 27,160.00 31,680.00 16.6% 1015412 5113 OVERTIME .00 .00 .00 879.73 .00 .00 .0% 1015412 5116 FRINGE BEN 1,335.88 9,060.00 9,060.00 3,197.97 9,060.00 9,910.00 9.4% 1015412 5117 RETIR CNTR 820.45 2,970.00 2,970.00 2,211.77 2,970.00 3,810.00 28.3% 1015412 5217 OTHER SUPP .00 3,000.00 3,000.00 2,500.00 3,000.00 .00 -100.0% 1015412 5245 MAINT-BLDG .00 .00 .00 79.00 .00 .00 .0% 1015412 5258 OTHER SVS 2,235.00 .00 .00 .00 .00 .00 .0% TOTAL MAINTENANCE-MAIN STREE 12,572.18 42,190.00 42,190.00 33,313.20 42,190.00 45,400.00 7.6% 1015413 MAINTENANCE-METROLINK STATION
1015413 5111 SALARY-FT 16,245.90 17,320.00 17,320.00 14,391.54 17,320.00 18,010.00 4.0%

Page 103 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 28 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1015413 5116 FRINGE BEN 3,273.81 3,690.00 3,690.00 3,150.88 3,690.00 4,000.00 8.4% 1015413 5117 RETIR CNTR 1,694.21 1,900.00 1,900.00 1,577.34 1,900.00 2,170.00 14.2% 1015413 5217 OTHER SUPP .00 3,000.00 3,000.00 1,530.00 3,000.00 .00 -100.0% 1015413 5217 54130 OTHER SUPP .00 .00 .00 1,529.51 .00 .00 .0% 1015413 5241 UTL-ELECTR 2,866.85 4,000.00 4,000.00 2,328.07 4,000.00 4,000.00 .0% 1015413 5243 UTL-TELEPH .00 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0% 1015413 5243 54130 UTL-TELEPH 963.20 .00 .00 567.92 .00 .00 .0% 1015413 5244 UTL-WATER .00 11,620.00 11,620.00 5,013.07 11,620.00 11,620.00 .0% 1015413 5253 CONTRC SVS 3,107.28 5,000.00 5,000.00 5,000.00 5,000.00 .00 -100.0% 1015413 5253 54130 CONTRC SVS 135,249.00 140,000.00 140,000.00 135,305.00 140,000.00 140,000.00 .0% 1015413 5255 54130 BANKNG SVS 2,268.33 .00 .00 2,824.31 .00 .00 .0% TOTAL MAINTENANCE-METROLINK 165,668.58 187,730.00 187,730.00 173,217.64 187,730.00 181,000.00 -3.6% 1015415 GRAFFITI REMOVAL-PW
1015415 5253 CONTRC SVS 80,018.40 80,000.00 82,000.00 81,352.60 82,000.00 86,000.00 4.9% TOTAL GRAFFITI REMOVAL-PW 80,018.40 80,000.00 82,000.00 81,352.60 82,000.00 86,000.00 4.9% 1015416 DAMAGE TO CITY PROPERTY
1015416 5217 OTHER SUPP .00 6,000.00 36,000.00 26,500.00 36,000.00 30,000.00 -16.7% 1015416 5258 OTHER SVS 46,931.74 60,000.00 90,000.00 88,690.18 110,000.00 90,000.00 .0% TOTAL DAMAGE TO CITY PROPERT 46,931.74 66,000.00 126,000.00 115,190.18 146,000.00 120,000.00 -4.8% 1015420 PARK MAINTENANCE
1015420 5111 SALARY-FT 110,635.69 111,680.00 111,680.00 53,954.71 111,680.00 78,400.00 -29.8% 1015420 5113 OVERTIME 7,434.32 5,000.00 5,000.00 5,413.97 5,000.00 .00 .0% 1015420 5116 FRINGE BEN 19,279.60 33,510.00 33,510.00 10,530.00 33,510.00 26,190.00 -21.8% 1015420 5117 RETIR CNTR 9,784.25 11,740.00 11,740.00 5,216.86 11,740.00 8,920.00 -24.0% 1015420 5212 ADVERTISNG .00 .00 1,000.00 916.28 .00 .00 .0% 1015420 5213 DUES&SUBSC 174.45 .00 .00 80.75 .00 .00 .0% 1015420 5215 TRNG/CONF 1,938.34 .00 .00 .00 .00 .00 .0% 1015420 5217 OTHER SUPP 15,205.97 30,000.00 45,000.00 19,049.81 30,000.00 60,000.00 33.3% 1015420 5218 UNIFRM EXP 6,970.03 7,000.00 9,600.00 10,071.82 9,000.00 9,200.00 -4.2% 1015420 5220 FUEL USAGE 7,723.31 12,000.00 6,000.00 3,934.20 12,000.00 12,000.00 100.0% 1015420 5231 FURN&OFFC 1,842.40 .00 .00 .00 .00 .00 .0% 1015420 5233 OTHR EQUIP 16,318.72 6,000.00 6,000.00 21,250.00 6,000.00 10,000.00 66.7% 1015420 5237 UTL-SWR .00 .00 42,400.00 21,741.24 .00 .00 .0% 1015420 5241 UTL-ELECTR 29,205.04 27,000.00 27,000.00 24,550.38 27,000.00 35,000.00 29.6% 1015420 5242 UTL-GAS 81.45 250.00 250.00 78.45 250.00 600.00 140.0%

Page 104 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 29 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 1015420 5244 UTL-WATER .00 283,100.00 238,100.00 113,354.83 283,100.00 283,100.00 18.9% 1015420 5253 CONTRC SVS 270,961.56 340,000.00 340,000.00 340,000.00 340,000.00 336,200.00 -1.1% 1015420 5258 OTHER SVS 13,995.61 20,000.00 25,000.00 31,412.40 30,000.00 30,000.00 20.0% 1015420 5321 EMPL INCEN 135.66 .00 .00 .00 .00 .00 .0% 1015420 5530 MACH&EQUIP 2,998.14 .00 .00 .00 .00 .00 .0% 1015420 5702 FLT-MT&RP 15,900.00 19,580.00 19,580.00 19,584.00 19,580.00 7,790.00 -60.2% 1015420 5703 VEH ACQ .00 60,000.00 60,000.00 60,000.00 60,000.00 62,000.00 3.3% 1015420 5704 BDG MT ALC 35,000.00 16,000.00 16,000.00 15,996.00 16,000.00 25,000.00 56.3% TOTAL PARK MAINTENANCE 565,584.54 982,860.00 997,860.00 757,135.70 994,860.00 984,400.00 -1.3% 1015421 SPORTS FIELD MAINTENANCE
1015421 5111 SALARY-FT 74,852.27 85,040.00 85,040.00 57,626.49 85,040.00 63,240.00 -25.6% 1015421 5113 OVERTIME 1,012.46 3,000.00 3,000.00 4,875.01 3,000.00 .00 .0% 1015421 5116 FRINGE BEN 18,153.19 25,020.00 25,020.00 14,221.65 25,020.00 17,450.00 -30.3% 1015421 5117 RETIR CNTR 7,596.16 9,120.00 9,120.00 6,015.76 9,120.00 7,580.00 -16.9% 1015421 5217 OTHER SUPP 2,125.00 8,000.00 8,000.00 8,107.80 8,000.00 10,000.00 25.0% 1015421 5233 OTHR EQUIP 3,900.00 6,000.00 5,500.00 2,327.00 6,000.00 .00 -100.0% 1015421 5237 UTL-SWR .00 .00 500.00 342.23 .00 .00 .0% 1015421 5241 UTL-ELECTR 50,735.91 34,000.00 45,000.00 29,669.53 45,000.00 45,000.00 .0% 1015421 5244 UTL-WATER .00 149,870.00 264,870.00 91,129.06 149,870.00 149,870.00 -43.4% 1015421 5245 40155 MAINT-BLDG 3,850.00 .00 .00 .00 .00 .00 .0% 1015421 5253 CONTRC SVS 66,054.48 85,000.00 120,000.00 120,000.00 120,000.00 90,000.00 -25.0% 1015421 5258 OTHER SVS 4,939.12 10,000.00 10,000.00 10,000.00 20,000.00 60,000.00 500.0% TOTAL SPORTS FIELD MAINTENAN 233,218.59 415,050.00 576,050.00 344,314.53 471,050.00 443,140.00 -23.1% 1015601 CITY HALL
1015601 5217 OTHER SUPP .00 2,000.00 2,000.00 .00 2,000.00 .00 -100.0% 1015601 5220 FUEL USAGE 5,431.20 4,500.00 4,500.00 3,680.82 4,500.00 .00 -100.0% 1015601 5237 UTL-SWR .00 .00 .00 3,803.55 .00 .00 .0% 1015601 5241 UTL-ELECTR 44,777.78 40,000.00 40,000.00 45,143.71 40,000.00 40,000.00 .0% 1015601 5242 UTL-GAS 6,731.27 10,000.00 10,000.00 14,727.44 10,000.00 10,000.00 .0% 1015601 5244 UTL-WATER .00 35,310.00 35,310.00 6,491.59 35,310.00 35,310.00 .0% 1015601 5702 FLT-MT&RP 10,650.00 7,430.00 7,430.00 7,428.00 7,430.00 8,370.00 12.7% 1015601 5703 VEH ACQ 31,250.00 .00 .00 .00 .00 .00 .0% 1015601 5704 BDG MT ALC 96,860.00 100,220.00 100,220.00 100,224.00 100,220.00 116,580.00 16.3% TOTAL CITY HALL 195,700.25 199,460.00 199,460.00 181,499.11 199,460.00 210,260.00 5.4% TOTAL GENERAL FUND 77,986,976.28 52,496,120.00 53,240,424.00 42,192,599.98 51,205,505.00 54,932,520.00 3.2%

Page 105 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 30 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT HOUSING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2012931 HOUSING PROGRAM
2012931 5110 BUY BACKS 5,045.09 5,300.00 5,300.00 4,157.73 5,300.00 9,800.00 84.9% 2012931 5111 SALARY-FT 381,769.87 454,520.00 450,656.00 382,708.53 450,656.00 564,690.00 25.3% 2012931 5112 SALARY-PT 3,810.92 9,030.00 9,030.00 7,412.45 9,030.00 11,130.00 23.3% 2012931 5113 OVERTIME 227.49 1,000.00 1,000.00 68.44 1,000.00 500.00 -50.0% 2012931 5116 FRINGE BEN 80,962.40 109,430.00 108,326.00 82,189.95 108,326.00 134,960.00 24.6% 2012931 5117 RETIR CNTR 37,222.26 47,950.00 47,398.00 37,051.53 47,398.00 65,500.00 38.2% 2012931 5211 POSTAGE 36.72 100.00 100.00 .00 100.00 100.00 .0% 2012931 5212 ADVERTISNG .00 3,500.00 3,500.00 3,500.00 3,500.00 3,500.00 .0% 2012931 5213 DUES&SUBSC 680.00 680.00 680.00 725.00 680.00 730.00 7.4% 2012931 5215 TRNG/CONF 2,177.83 3,650.00 3,250.00 2,729.04 3,250.00 4,630.00 42.5% 2012931 5216 OFFIC SUPP 835.68 1,000.00 1,000.00 535.43 1,000.00 1,000.00 .0% 2012931 5217 OTHER SUPP 366.58 500.00 500.00 663.16 500.00 1,000.00 100.0% 2012931 5217 20311 OTHER SUPP .00 .00 .00 110.73 .00 .00 .0% 2012931 5218 UNIFRM EXP 529.75 .00 .00 .00 .00 500.00 .0% 2012931 5221 MILE REIMB 122.61 250.00 250.00 241.25 250.00 500.00 100.0% 2012931 5222 PRNT/MAIL 169.16 250.00 250.00 63.57 250.00 100.00 -60.0% 2012931 5226 TEAMBLDG .00 .00 .00 .00 .00 400.00 .0% 2012931 5232 COMP EQUIP 19.38 100.00 100.00 .00 100.00 100.00 .0% 2012931 5233 OTHR EQUIP 137.24 500.00 900.00 814.99 900.00 .00 .0% 2012931 5243 UTL-TELEPH 1,420.40 2,500.00 2,500.00 2,182.75 2,500.00 2,500.00 .0% 2012931 5251 LEGAL SVS .00 15,000.00 10,940.00 1,909.50 10,940.00 10,000.00 -8.6% 2012931 5252 PROF SVS 175,105.55 318,400.00 318,400.00 228,036.00 318,400.00 301,620.00 -5.3% 2012931 5253 CONTRC SVS 250.00 700.00 10,280.00 10,670.00 10,280.00 4,950.00 -51.8% 2012931 5258 OTHER SVS 15,384.24 1,605,180.00 1,585,180.00 2,737.37 1,585,180.00 1,606,690.00 1.4% 2012931 5258 20311 OTHER SVS .00 .00 .00 11,850.00 .00 .00 .0% 2012931 5299 PY EXP 1,264.95 .00 .00 .00 .00 .00 .0% 2012931 5302 LOANS .00 .00 .00 .00 .00 100,000.00 .0% 2012931 5305 EMERG PROG 10,000.00 .00 20,000.00 16,904.60 20,000.00 20,000.00 .0% 2012931 5424 BND PRNCPL 580,246.30 654,065.00 654,065.00 545,045.67 654,065.00 674,580.00 3.1% 2012931 5425 BND INT EX 363,687.33 375,685.00 375,685.00 313,075.80 375,685.00 355,200.00 -5.5% 2012931 5601 LN ACTV 101,022.65 .00 .00 .00 .00 .00 .0% 2012931 5701 INFO SYS 34,110.00 44,770.00 44,770.00 44,772.00 44,770.00 39,200.00 -12.4% 2012931 5704 BDG MT ALC 6,260.00 .00 .00 .00 .00 .00 .0% 2012931 5705 SF LIAB 111,480.00 136,020.00 136,020.00 136,032.00 136,020.00 144,850.00 6.5% 2012931 5706 OPB&BN ALC 24,120.00 18,310.00 18,310.00 18,312.00 18,310.00 19,590.00 7.0% 2012931 5707 PERSUALALC 131,910.00 174,050.00 174,050.00 174,048.00 174,050.00 179,910.00 3.4% TOTAL HOUSING PROGRAM 2,070,374.40 3,982,440.00 3,982,440.00 2,028,547.49 3,982,440.00 4,258,230.00 6.9% TOTAL HOUSING FUND 2,070,374.40 3,982,440.00 3,982,440.00 2,028,547.49 3,982,440.00 4,258,230.00 6.9%

Page 106 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 31 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT PUB SAFETY AUGMENTATION ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2033211 POLICE PATROL
2033211 5110 BUY BACKS 2,543.10 .00 .00 890.08 .00 .00 .0% 2033211 5131 SAL-SW PD 1,099,172.96 1,054,290.00 1,054,290.00 792,324.14 1,054,290.00 1,103,480.00 4.7% 2033211 5131 40155 SAL-SW PD 282.57 .00 .00 .00 .00 .00 .0% 2033211 5133 OT-SW PD 61,338.06 88,480.00 88,480.00 51,465.64 88,480.00 .00 .0% 2033211 5136 FRG B-S PD 94,635.28 193,330.00 193,330.00 104,127.90 193,330.00 189,950.00 -1.7% 2033211 5136 40155 FRG B-S PD 42.70 .00 .00 .00 .00 .00 .0% 2033211 5137 RT CNTR-PD 116,890.53 176,800.00 176,800.00 112,538.79 176,800.00 206,640.00 16.9% 2033211 5137 40155 RT CNTR-PD 51.40 .00 .00 .00 .00 .00 .0% TOTAL POLICE PATROL 1,374,956.60 1,512,900.00 1,512,900.00 1,061,346.55 1,512,900.00 1,500,070.00 -.8% TOTAL PUB SAFETY AUGMENTATIO 1,374,956.60 1,512,900.00 1,512,900.00 1,061,346.55 1,512,900.00 1,500,070.00 -.8%

Page 107 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 32 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GAS TAX ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2041301 ACCOUNTING SERVICES
2041301 5252 PROF SVS 4,935.00 6,310.00 7,610.00 4,495.52 7,610.00 .00 .0% TOTAL ACCOUNTING SERVICES 4,935.00 6,310.00 7,610.00 4,495.52 7,610.00 .00 -100.0% 2045201 GAS TAX ADMINITRATION
2045201 5292 ADM SV EXP 327,290.00 327,290.00 327,290.00 327,290.00 327,290.00 327,290.00 .0% TOTAL GAS TAX ADMINITRATION 327,290.00 327,290.00 327,290.00 327,290.00 327,290.00 327,290.00 .0% 2045301 ENGINEERING ADMINISTRATION
2045301 5111 SALARY-FT 34,862.37 144,490.00 144,490.00 31,607.88 144,490.00 160,800.00 11.3% 2045301 5116 FRINGE BEN 6,709.03 31,220.00 31,220.00 6,450.45 31,220.00 34,580.00 10.8% 2045301 5117 RETIR CNTR 3,572.15 15,800.00 15,800.00 3,413.46 15,800.00 19,360.00 22.5% 2045301 5706 OPB&BN ALC 6,420.00 4,760.00 4,760.00 4,764.00 4,760.00 4,570.00 -4.0% 2045301 5707 PERSUALALC 40,180.00 47,440.00 47,440.00 47,436.00 47,440.00 43,760.00 -7.8% TOTAL ENGINEERING ADMINISTRA 91,743.55 243,710.00 243,710.00 93,671.79 243,710.00 263,070.00 7.9% 2045401 STREET MAINTENANCE-GAS TAX
2045401 5217 OTHER SUPP 27,253.45 50,000.00 50,000.00 49,446.64 50,000.00 50,000.00 .0% 2045401 5233 OTHR EQUIP 1,071.17 .00 .00 .00 .00 .00 .0% TOTAL STREET MAINTENANCE-GAS 28,324.62 50,000.00 50,000.00 49,446.64 50,000.00 50,000.00 .0% 2045404 STREET LIGHTING-GAS TAX
2045404 5241 UTL-ELECTR 100,000.00 100,000.00 100,000.00 81,915.40 100,000.00 .00 .0% TOTAL STREET LIGHTING-GAS TA 100,000.00 100,000.00 100,000.00 81,915.40 100,000.00 .00 -100.0% 2045409 STREET TREE MAINTENANCE-GAS TX
2045409 5253 CONTRC SVS 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 150,000.00 50.0% TOTAL STREET TREE MAINTENANC 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 150,000.00 50.0% 2045410 PARKWAY MAINTENANCE-ROW-GAS TX
2045410 5253 CONTRC SVS 49,999.56 50,000.00 50,000.00 50,000.00 50,000.00 150,000.00 200.0%

Page 108 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 33 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GAS TAX ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL PARKWAY MAINTENANCE-RO 49,999.56 50,000.00 50,000.00 50,000.00 50,000.00 150,000.00 200.0% 2047003 PAVEMENT MANAGEMENT
2047003 5111 SALARY-FT 2,678.88 .00 .00 4,185.51 .00 .00 .0% 2047003 5116 FRINGE BEN 481.01 .00 .00 801.87 .00 .00 .0% 2047003 5117 RETIR CNTR 279.45 .00 .00 457.93 .00 .00 .0% 2047003 5254 DATA P SVS 3,180.00 .00 .00 .00 .00 .00 .0% 2047003 5258 OTHER SVS 3,000.00 161,660.00 157,336.00 2,000.00 7,450.00 25,000.00 -84.1% TOTAL PAVEMENT MANAGEMENT 9,619.34 161,660.00 157,336.00 7,445.31 7,450.00 25,000.00 -84.1% 2047031 TRAFFIC SAFETY PRJCT 08-09
2047031 5111 SALARY-FT 743.76 .00 .00 2,237.90 .00 .00 .0% 2047031 5116 FRINGE BEN 121.52 .00 .00 440.16 .00 .00 .0% 2047031 5117 RETIR CNTR 77.50 .00 .00 245.22 .00 .00 .0% 2047031 5258 OTHER SVS 5,234.50 67,200.00 63,269.00 37,568.25 22,320.00 40,950.00 -35.3% TOTAL TRAFFIC SAFETY PRJCT 0 6,177.28 67,200.00 63,269.00 40,491.53 22,320.00 40,950.00 -35.3% 2047069 ARROW HIGHWAY REHAB (BENS-MTN)
2047069 5111 SALARY-FT 3,623.22 .00 .00 6,274.22 .00 .00 .0% 2047069 5116 FRINGE BEN 692.44 .00 .00 1,323.58 .00 .00 .0% 2047069 5117 RETIR CNTR 378.09 .00 .00 687.46 .00 .00 .0% 2047069 5258 OTHER SVS .00 1,391,050.00 1,390,138.00 12,722.60 21,010.00 2,369,130.00 70.4% TOTAL ARROW HIGHWAY REHAB (B 4,693.75 1,391,050.00 1,390,138.00 21,007.86 21,010.00 2,369,130.00 70.4% 2047070 CW CONCRETE MAINT 18/19
2047070 5258 OTHER SVS .00 .00 74,340.00 .00 .00 .00 .0% TOTAL CW CONCRETE MAINT 18/1 .00 .00 74,340.00 .00 .00 .00 -100.0% 2047071 CW CONCRETE REPAIRS 18/19
2047071 5111 SALARY-FT 747.18 .00 .00 .00 .00 .00 .0% 2047071 5113 OVERTIME 116.45 .00 .00 .00 .00 .00 .0% 2047071 5116 FRINGE BEN 86.04 .00 .00 .00 .00 .00 .0% 2047071 5117 RETIR CNTR 77.86 .00 .00 .00 .00 .00 .0% 2047071 5258 OTHER SVS .00 .00 16,668.00 .00 .00 .00 .0%

Page 109 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 34 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GAS TAX ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL CW CONCRETE REPAIRS 18 1,027.53 .00 16,668.00 .00 .00 .00 -100.0% 2047076 ALPINE ST REHAB (WEST TO PALM)
2047076 5111 SALARY-FT 4,171.42 .00 .00 3,182.83 .00 .00 .0% 2047076 5116 FRINGE BEN 803.79 .00 .00 683.86 .00 .00 .0% 2047076 5117 RETIR CNTR 434.88 .00 .00 348.85 .00 .00 .0% 2047076 5212 ADVERTISNG .00 .00 .00 1,338.14 .00 .00 .0% 2047076 5222 PRINTING .00 .00 .00 374.79 .00 .00 .0% 2047076 5258 OTHER SVS 10,351.81 672,360.00 668,919.00 1,955.53 9,700.00 885,220.00 32.3% TOTAL ALPINE ST REHAB (WEST 15,761.90 672,360.00 668,919.00 7,884.00 9,700.00 885,220.00 32.3% 2047077 VERNON DR (WEST TO PALM)
2047077 5111 SALARY-FT 3,755.91 .00 .00 3,154.18 .00 .00 .0% 2047077 5116 FRINGE BEN 736.33 .00 .00 677.86 .00 .00 .0% 2047077 5117 RETIR CNTR 391.60 .00 .00 345.71 .00 .00 .0% 2047077 5212 ADVERTISNG .00 .00 .00 1,338.14 .00 .00 .0% 2047077 5258 OTHER SVS 10,351.81 356,320.00 353,153.00 2,505.53 9,830.00 514,320.00 45.6% TOTAL VERNON DR (WEST TO PAL 15,235.65 356,320.00 353,153.00 8,021.42 9,830.00 514,320.00 45.6% 2047078 PALM AVE (9TH ST TO ARROW HWY)
2047078 5111 SALARY-FT 4,009.69 .00 .00 4,731.79 .00 .00 .0% 2047078 5116 FRINGE BEN 786.77 .00 .00 983.35 .00 .00 .0% 2047078 5117 RETIR CNTR 418.04 .00 .00 518.21 .00 .00 .0% 2047078 5212 ADVERTISNG .00 .00 .00 1,338.14 .00 .00 .0% 2047078 5258 OTHER SVS 12,116.47 744,260.00 741,109.00 100,419.48 109,810.00 1,435,300.00 93.7% TOTAL PALM AVE (9TH ST TO AR 17,330.97 744,260.00 741,109.00 107,990.97 109,810.00 1,435,300.00 93.7% 2047080 CW CONCRETE REPAIR 19/20
2047080 5258 OTHER SVS .00 .00 32,288.00 .00 .00 .00 .0% TOTAL CW CONCRETE REPAIR 19/ .00 .00 32,288.00 .00 .00 .00 -100.0% 2047500 CAPITAL PROJECTS
2047500 5111 70001 SALARY-FT .00 .00 .00 17.46 .00 .00 .0% 2047500 5111 70003 SALARY-FT 16,502.90 .00 .00 15,493.18 .00 .00 .0%

Page 110 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 35 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GAS TAX ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2047500 5111 70004 SALARY-FT 27,652.27 .00 .00 2,764.91 .00 .00 .0% 2047500 5111 70007 SALARY-FT 881.30 .00 .00 10,317.52 .00 .00 .0% 2047500 5111 70008 SALARY-FT 200.48 .00 .00 .00 .00 .00 .0% 2047500 5111 70010 SALARY-FT 1,101.42 .00 .00 1,934.37 .00 .00 .0% 2047500 5111 70011 SALARY-FT 150.36 .00 .00 .00 .00 .00 .0% 2047500 5111 70012 SALARY-FT .00 .00 .00 314.25 .00 .00 .0% 2047500 5111 70014 SALARY-FT .00 .00 .00 5,977.64 .00 .00 .0% 2047500 5113 70003 OVERTIME .00 .00 .00 1,338.59 .00 .00 .0% 2047500 5116 70001 FRINGE BEN .00 .00 .00 3.32 .00 .00 .0% 2047500 5116 70003 FRINGE BEN 3,791.15 .00 .00 3,123.08 .00 .00 .0% 2047500 5116 70004 FRINGE BEN 6,129.86 .00 .00 523.53 .00 .00 .0% 2047500 5116 70007 FRINGE BEN 163.48 .00 .00 2,358.53 .00 .00 .0% 2047500 5116 70008 FRINGE BEN 39.09 .00 .00 .00 .00 .00 .0% 2047500 5116 70010 FRINGE BEN 207.38 .00 .00 368.20 .00 .00 .0% 2047500 5116 70011 FRINGE BEN 29.32 .00 .00 .00 .00 .00 .0% 2047500 5116 70012 FRINGE BEN .00 .00 .00 61.03 .00 .00 .0% 2047500 5116 70014 FRINGE BEN .00 .00 .00 1,006.36 .00 .00 .0% 2047500 5117 70001 RETIR CNTR .00 .00 .00 1.91 .00 .00 .0% 2047500 5117 70003 RETIR CNTR 1,722.04 .00 .00 1,604.31 .00 .00 .0% 2047500 5117 70004 RETIR CNTR 2,736.68 .00 .00 303.03 .00 .00 .0% 2047500 5117 70007 RETIR CNTR 91.90 .00 .00 1,130.62 .00 .00 .0% 2047500 5117 70008 RETIR CNTR 20.88 .00 .00 .00 .00 .00 .0% 2047500 5117 70010 RETIR CNTR 116.31 .00 .00 212.02 .00 .00 .0% 2047500 5117 70011 RETIR CNTR 15.66 .00 .00 .00 .00 .00 .0% 2047500 5117 70012 RETIR CNTR .00 .00 .00 34.39 .00 .00 .0% 2047500 5117 70014 RETIR CNTR .00 .00 .00 655.13 .00 .00 .0% 2047500 5212 70003 ADVERTISNG .00 .00 .00 6,128.21 .00 .00 .0% 2047500 5212 70004 ADVERTISNG 3,542.30 .00 .00 .00 .00 .00 .0% 2047500 5219 70004 PERM/LC/FE 50.00 .00 .00 .00 .00 .00 .0% 2047500 5258 OTHER SVS .00 .00 .00 .00 .00 25,000.00 .0% 2047500 5258 70002 OTHER SVS 263,920.00 .00 36,080.00 .00 .00 .00 .0% 2047500 5258 70003 OTHER SVS .00 174,960.00 168,014.00 96,478.01 129,260.00 8,750.00 -94.8% 2047500 5258 70004 OTHER SVS 413,551.31 305,010.00 32,454.00 .00 3,590.00 .00 .0% 2047500 5258 70005 OTHER SVS .00 109,950.00 109,950.00 .00 .00 .00 -100.0% 2047500 5258 70007 OTHER SVS .00 1,255,000.00 1,254,983.00 .00 11,030.00 1,243,950.00 -.9% 2047500 5258 70008 OTHER SVS 500,000.00 .00 .00 .00 .00 .00 .0% 2047500 5258 70009 OTHER SVS .00 150,000.00 150,000.00 99,023.92 101,000.00 .00 .0% 2047500 5258 70010 OTHER SVS 413,370.70 500,000.00 85,204.00 .00 2,520.00 .00 .0% 2047500 5258 70012 OTHER SVS .00 500,000.00 500,000.00 500,000.00 500,410.00 .00 .0% 2047500 5258 70013 OTHER SVS .00 400,000.00 400,000.00 .00 .00 250,000.00 -37.5% 2047500 5258 70014 OTHER SVS .00 500,000.00 500,000.00 .00 4,830.00 495,170.00 -1.0% TOTAL CAPITAL PROJECTS 1,655,986.79 3,894,920.00 3,236,685.00 751,173.52 752,640.00 2,022,870.00 -37.5% 2048617 ARROW RTW WDNG
2048617 5258 OTHER SVS .00 99,480.00 249,480.00 .00 .00 20,000.00 -92.0%

Page 111 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 36 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GAS TAX ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL ARROW RTW WDNG .00 99,480.00 249,480.00 .00 .00 20,000.00 -92.0% 2049124 ARRW HWY REHAB (MNT TO SA)
2049124 5111 SALARY-FT 3,483.10 .00 .00 5,044.26 .00 .00 .0% 2049124 5116 FRINGE BEN 667.97 .00 .00 1,064.74 .00 .00 .0% 2049124 5117 RETIR CNTR 363.28 .00 .00 552.88 .00 .00 .0% 2049124 5258 OTHER SVS .00 1,242,170.00 1,241,304.00 12,772.60 19,430.00 2,346,870.00 89.1% TOTAL ARRW HWY REHAB (MNT TO 4,514.35 1,242,170.00 1,241,304.00 19,434.48 19,430.00 2,346,870.00 89.1% TOTAL GAS TAX 2,432,640.29 9,506,730.00 9,103,299.00 1,670,268.44 1,830,800.00 10,600,020.00 16.4%

Page 112 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 37 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT MEASURE I ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2055201 MEASURE I ADMINISTRATION
2055201 5292 ADM SV EXP 238,410.00 238,410.00 238,410.00 238,410.00 238,410.00 .00 .0% TOTAL MEASURE I ADMINISTRATI 238,410.00 238,410.00 238,410.00 238,410.00 238,410.00 .00 -100.0% 2055301 ENGINEERING ADMINISTRATION
2055301 5111 SALARY-FT 23,702.86 112,610.00 112,610.00 21,773.53 112,610.00 124,160.00 10.3% 2055301 5116 FRINGE BEN 4,667.42 24,540.00 24,540.00 4,465.05 24,540.00 27,110.00 10.5% 2055301 5117 RETIR CNTR 2,437.75 12,320.00 12,320.00 2,361.08 12,320.00 14,950.00 21.3% 2055301 5706 OPB&BN ALC 5,080.00 3,760.00 3,760.00 3,756.00 3,760.00 3,550.00 -5.6% 2055301 5707 PERSUALALC 31,470.00 36,870.00 36,870.00 36,876.00 36,870.00 33,780.00 -8.4% TOTAL ENGINEERING ADMINISTRA 67,358.03 190,100.00 190,100.00 69,231.66 190,100.00 203,550.00 7.1% 2057339 CAMPUS AVE RHB (CL TO FTHLL)
2057339 5111 SALARY-FT 4,122.90 .00 .00 3,802.78 .00 .00 .0% 2057339 5116 FRINGE BEN 946.11 .00 .00 578.51 .00 .00 .0% 2057339 5117 RETIR CNTR 429.63 .00 .00 416.76 .00 .00 .0% 2057339 5258 OTHER SVS .00 160,880.00 160,062.00 .00 4,790.00 461,500.00 188.3% TOTAL CAMPUS AVE RHB (CL TO 5,498.64 160,880.00 160,062.00 4,798.05 4,790.00 461,500.00 188.3% 2057340 17TH ST RECNSTRTN (SA TO EUCL)
2057340 5111 SALARY-FT 11,925.46 .00 .00 13,332.16 .00 .00 .0% 2057340 5116 FRINGE BEN 2,748.68 .00 .00 2,344.97 .00 .00 .0% 2057340 5117 RETIR CNTR 1,243.38 .00 .00 1,461.06 .00 .00 .0% 2057340 5212 ADVERTISNG .00 .00 .00 3,296.91 .00 .00 .0% 2057340 5258 OTHER SVS 13,000.00 897,920.00 883,848.00 857.59 21,240.00 862,610.00 -2.4% TOTAL 17TH ST RECNSTRTN (SA 28,917.52 897,920.00 883,848.00 21,292.69 21,240.00 862,610.00 -2.4% 2057341 SBV COORDINATED TRAFFIC SIGNAL
2057341 5258 OTHER SVS .00 .00 6,840.00 .00 .00 .00 .0% TOTAL SBV COORDINATED TRAFFI .00 .00 6,840.00 .00 .00 .00 -100.0% 2057343 19TH ST RECONSTRUCT-MTN TO EUC
2057343 5111 SALARY-FT .00 .00 .00 9,219.75 .00 .00 .0%

Page 113 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 38 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT MEASURE I ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2057343 5116 FRINGE BEN .00 .00 .00 1,560.77 .00 .00 .0% 2057343 5117 RETIR CNTR .00 .00 .00 1,010.52 .00 .00 .0% 2057343 5258 OTHER SVS .00 150,000.00 150,000.00 .00 11,790.00 631,590.00 321.1% TOTAL 19TH ST RECONSTRUCT-MT .00 150,000.00 150,000.00 11,791.04 11,790.00 631,590.00 321.1% 2057345 GROVE AVE REHAB (FTHL & 15TH)
2057345 5111 SALARY-FT 126.70 .00 .00 .00 .00 .00 .0% 2057345 5116 FRINGE BEN 26.34 .00 .00 .00 .00 .00 .0% 2057345 5117 RETIR CNTR 13.20 .00 .00 .00 .00 .00 .0% 2057345 5258 OTHER SVS .00 134,300.00 134,212.00 .00 .00 499,210.00 272.0% TOTAL GROVE AVE REHAB (FTHL 166.24 134,300.00 134,212.00 .00 .00 499,210.00 272.0% 2057346 CW PAVEMENT MAINT 19/20
2057346 5258 OTHER SVS 124,740.00 .00 14,400.00 .00 .00 .00 .0% TOTAL CW PAVEMENT MAINT 19/2 124,740.00 .00 14,400.00 .00 .00 .00 -100.0% 2057500 CAPITAL PROJECTS
2057500 5111 74001 SALARY-FT 165.78 .00 .00 .00 .00 .00 .0% 2057500 5111 74003 SALARY-FT 7,159.82 .00 .00 4,493.17 .00 .00 .0% 2057500 5111 74004 SALARY-FT 26,674.49 .00 .00 5,979.13 .00 .00 .0% 2057500 5113 74004 OVERTIME 524.02 .00 .00 .00 .00 .00 .0% 2057500 5116 74001 FRINGE BEN 18.20 .00 .00 .00 .00 .00 .0% 2057500 5116 74003 FRINGE BEN 1,422.60 .00 .00 840.64 .00 .00 .0% 2057500 5116 74004 FRINGE BEN 5,465.78 .00 .00 1,146.92 .00 .00 .0% 2057500 5117 74001 RETIR CNTR 17.27 .00 .00 .00 .00 .00 .0% 2057500 5117 74003 RETIR CNTR 747.61 .00 .00 492.42 .00 .00 .0% 2057500 5117 74004 RETIR CNTR 2,780.22 .00 .00 654.60 .00 .00 .0% 2057500 5212 74004 ADVERTISNG 1,900.36 .00 .00 .00 .00 .00 .0% 2057500 5258 OTHER SVS .00 .00 .00 .00 .00 1,996,000.00 .0% 2057500 5258 74002 OTHER SVS 268,969.00 .00 21,031.00 .00 .00 .00 .0% 2057500 5258 74003 OTHER SVS 1,763.44 39,120.00 34,685.00 .00 5,830.00 28,860.00 -16.8% 2057500 5258 74004 OTHER SVS 153,825.49 134,730.00 108,697.00 49,500.00 57,280.00 111,420.00 2.5% 2057500 5258 74005 OTHER SVS .00 104,000.00 104,000.00 .00 .00 577,000.00 454.8% 2057500 5258 74006 OTHER SVS .00 250,000.00 250,000.00 .00 .00 250,000.00 .0% 2057500 5258 74007 OTHER SVS .00 100,000.00 100,000.00 .00 .00 300,000.00 200.0% TOTAL CAPITAL PROJECTS 471,434.08 627,850.00 618,413.00 63,106.88 63,110.00 3,263,280.00 427.7% 2059122 13TH ST RECONST- EUCLID-CAMPUS
2059122 5111 SALARY-FT 21,344.21 .00 .00 .00 .00 .00 .0%

Page 114 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 39 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT MEASURE I ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2059122 5113 OVERTIME 1,339.17 .00 .00 .00 .00 .00 .0% 2059122 5116 FRINGE BEN 4,445.13 .00 .00 .00 .00 .00 .0% 2059122 5117 RETIR CNTR 2,224.07 .00 .00 .00 .00 .00 .0% 2059122 5258 OTHER SVS 423,256.83 .00 186,955.00 .00 .00 .00 .0% TOTAL 13TH ST RECONST- EUCLI 452,609.41 .00 186,955.00 .00 .00 .00 -100.0% TOTAL MEASURE I 1,389,133.92 2,399,460.00 2,583,240.00 408,630.32 529,440.00 5,921,740.00 129.2%

Page 115 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 40 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT ROAD MAINT REHAB ACCOUNT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2065201 RMRA ADMINISTRATION
2065201 5292 ADM SV EXP 49,890.00 49,890.00 49,890.00 49,890.00 49,890.00 .00 .0% TOTAL RMRA ADMINISTRATION 49,890.00 49,890.00 49,890.00 49,890.00 49,890.00 .00 -100.0% 2065301 ENGINEERING ADMINISTRATION
2065301 5111 SALARY-FT 8,797.05 34,430.00 34,430.00 8,391.34 34,430.00 37,830.00 9.9% 2065301 5116 FRINGE BEN 1,720.40 7,230.00 7,230.00 1,778.46 7,230.00 8,000.00 10.7% 2065301 5117 RETIR CNTR 901.91 3,770.00 3,770.00 907.01 3,770.00 4,560.00 21.0% 2065301 5706 OPB&BN ALC 1,490.00 1,150.00 1,150.00 1,152.00 1,150.00 1,060.00 -7.8% 2065301 5707 PERSUALALC 9,710.00 11,390.00 11,390.00 11,388.00 11,390.00 10,490.00 -7.9% TOTAL ENGINEERING ADMINISTRA 22,619.36 57,970.00 57,970.00 23,616.81 57,970.00 61,940.00 6.8% 2067500 CAPITAL PROJECTS
2067500 5111 70005 SALARY-FT 300.71 .00 .00 .00 .00 .00 .0% 2067500 5111 70006 SALARY-FT 5,282.08 .00 .00 12,699.86 .00 .00 .0% 2067500 5111 70015 SALARY-FT .00 .00 .00 663.40 .00 .00 .0% 2067500 5111 70016 SALARY-FT .00 .00 .00 541.21 .00 .00 .0% 2067500 5116 70005 FRINGE BEN 58.64 .00 .00 .00 .00 .00 .0% 2067500 5116 70006 FRINGE BEN 1,153.51 .00 .00 2,213.30 .00 .00 .0% 2067500 5116 70015 FRINGE BEN .00 .00 .00 138.24 .00 .00 .0% 2067500 5116 70016 FRINGE BEN .00 .00 .00 112.86 .00 .00 .0% 2067500 5117 70005 RETIR CNTR 31.33 .00 .00 .00 .00 .00 .0% 2067500 5117 70006 RETIR CNTR 551.53 .00 .00 1,391.65 .00 .00 .0% 2067500 5117 70015 RETIR CNTR .00 .00 .00 72.54 .00 .00 .0% 2067500 5117 70016 RETIR CNTR .00 .00 .00 59.22 .00 .00 .0% 2067500 5258 OTHR SVCS .00 .00 .00 .00 .00 350,000.00 .0% 2067500 5258 70005 OTHER SVS .00 120,000.00 119,609.00 .00 .00 169,610.00 41.8% 2067500 5258 70006 OTHER SVS 15,575.00 427,970.00 410,542.00 5,000.00 21,300.00 1,100,240.00 168.0% 2067500 5258 70011 OTHER SVS .00 .00 549,805.00 .00 .00 .00 .0% 2067500 5258 70015 OTHER SVS .00 152,000.00 152,000.00 18,000.00 17,230.00 3,964,930.00 2508.5% 2067500 5258 70016 OTHER SVS .00 145,000.00 145,000.00 15,000.00 7,540.00 137,460.00 -5.2% TOTAL CAPITAL PROJECTS 22,952.80 844,970.00 1,376,956.00 55,892.28 46,070.00 5,722,240.00 315.6% TOTAL ROAD MAINT REHAB ACCOU 95,462.16 952,830.00 1,484,816.00 129,399.09 153,930.00 5,784,180.00 289.6%

Page 116 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 41 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT HOME ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2082401 HOME PROGRAM
2082401 5601 LN ACTV 209,790.00 .00 .00 .00 .00 .00 .0% TOTAL HOME PROGRAM 209,790.00 .00 .00 .00 .00 .00 .0% 2082408 PROGRAM INCOME LOANS
2082408 5314 HIP LOANS 47,190.00 230,000.00 230,000.00 .00 230,000.00 230,000.00 .0% 2082408 5315 FTHB LOANS .00 125,000.00 125,000.00 .00 125,000.00 280,000.00 124.0% TOTAL PROGRAM INCOME LOANS 47,190.00 355,000.00 355,000.00 .00 355,000.00 510,000.00 43.7% TOTAL HOME 256,980.00 355,000.00 355,000.00 .00 355,000.00 510,000.00 43.7%

Page 117 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 42 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT CDBG ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2092301 CDBG ADMINISTRATION
2092301 5111 SALARY-FT 26,741.18 34,560.00 34,560.00 29,060.13 34,560.00 42,530.00 23.1% 2092301 5116 FRINGE BEN 6,965.33 9,050.00 9,050.00 8,014.85 9,050.00 10,610.00 17.2% 2092301 5117 RETIR CNTR 2,623.01 3,670.00 3,670.00 2,896.72 3,670.00 4,890.00 33.2% 2092301 5212 ADVERTISNG 5,618.62 .00 10,000.00 6,366.13 10,000.00 8,500.00 -15.0% 2092301 5215 TRNG/CONF 155.39 .00 200.00 .00 200.00 .00 .0% 2092301 5216 OFFIC SUPP 100.00 .00 100.00 75.43 100.00 .00 .0% 2092301 5252 PROF SVS 12,615.47 .00 .00 .00 .00 .00 .0% 2092301 5258 OTHER SVS 34,730.00 .00 18,960.00 18,960.00 18,960.00 14,440.00 -23.8% TOTAL CDBG ADMINISTRATION 89,549.00 47,280.00 76,540.00 65,373.26 76,540.00 80,970.00 5.8% 2092304 SENIOR WELLNESS
2092304 5258 OTHER SVS 4,034.62 .00 .00 .00 .00 .00 .0% TOTAL SENIOR WELLNESS 4,034.62 .00 .00 .00 .00 .00 .0% 2092309 FAIR HOUSING
2092309 5258 OTHER SVS 26,000.00 .00 26,000.00 26,000.00 26,000.00 27,600.00 6.2% TOTAL FAIR HOUSING 26,000.00 .00 26,000.00 26,000.00 26,000.00 27,600.00 6.2% 2092311 FOOD- ST. JOSEPH
2092311 5258 OTHER SVS 19,816.00 .00 18,000.00 18,000.00 18,000.00 18,000.00 .0% TOTAL FOOD- ST. JOSEPH 19,816.00 .00 18,000.00 18,000.00 18,000.00 18,000.00 .0% 2092312 HOMELESS SERVICES
2092312 5258 OTHER SVS 56,339.00 .00 .00 .00 .00 .00 .0% 2092312 5258 23510 OTHER SVS .00 .00 30,120.00 30,120.00 30,120.00 21,000.00 -30.3% 2092312 5258 23511 OTHER SVS .00 .00 15,000.00 15,000.00 15,000.00 7,550.00 -49.7% TOTAL HOMELESS SERVICES 56,339.00 .00 45,120.00 45,120.00 45,120.00 28,550.00 -36.7% 2092313 U-HOPE
2092313 5258 OTHER SVS .00 .00 .00 .00 .00 22,000.00 .0% TOTAL U-HOPE .00 .00 .00 .00 .00 22,000.00 .0% 2092314 HOUSING MEDIATION
2092314 5258 OTHER SVS 19,500.00 .00 19,500.00 19,500.00 19,500.00 20,590.00 5.6%

Page 118 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 43 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT CDBG ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL HOUSING MEDIATION 19,500.00 .00 19,500.00 19,500.00 19,500.00 20,590.00 5.6% 2092323 CDBG CORONAVIRUS
2092323 5111 32313 SALARY-FT 9,339.69 .00 .00 .00 .00 .00 .0% 2092323 5112 32304 SALARY-PT 2,363.32 .00 .00 .00 .00 .00 .0% 2092323 5116 32304 FRINGE BEN 26.82 .00 .00 .00 .00 .00 .0% 2092323 5116 32313 FRINGE BEN 1,626.80 .00 .00 .00 .00 .00 .0% 2092323 5117 32304 RETIR CNTR 192.69 .00 .00 .00 .00 .00 .0% 2092323 5117 32313 RETIR CNTR 973.19 .00 .00 .00 .00 .00 .0% 2092323 5216 OFFIC SUPP 475.33 .00 .00 .00 .00 .00 .0% 2092323 5217 OTHER SUPP 105.85 .00 .00 .00 .00 .00 .0% 2092323 5231 FURN&OFFC 942.09 .00 .00 .00 .00 .00 .0% 2092323 5232 COMP EQUIP 2,147.69 .00 .00 .00 .00 .00 .0% 2092323 5233 OTHR EQUIP 53.86 .00 .00 .00 .00 .00 .0% 2092323 5243 UTL-TELEPH 565.67 .00 .00 .00 .00 .00 .0% 2092323 5252 32337 PROF SVS 960.00 .00 .00 540.00 .00 .00 .0% 2092323 5258 32313 OTHER SVS 50,479.62 .00 4,090.00 20.47 4,090.00 .00 .0% 2092323 5258 32337 OTHER SVS .00 .00 .00 50.00 .00 .00 .0% 2092323 5528 32337 IMPRV BLD 13,354.50 .00 76,185.00 20,283.00 76,185.00 .00 .0% TOTAL CDBG CORONAVIRUS 83,607.12 .00 80,275.00 20,893.47 80,275.00 .00 -100.0% 2092324 CDBG-CV3
2092324 5111 SALARY-FT 47,304.72 .00 .00 .00 .00 .00 .0% 2092324 5112 32304 SALARY-PT 7,220.82 .00 .00 .00 .00 .00 .0% 2092324 5116 FRINGE BEN 9,552.22 .00 .00 .00 .00 .00 .0% 2092324 5116 32304 FRINGE BEN 112.16 .00 .00 .00 .00 .00 .0% 2092324 5117 RETIR CNTR 4,785.25 .00 .00 .00 .00 .00 .0% 2092324 5117 32304 RETIR CNTR 806.00 .00 .00 .00 .00 .00 .0% 2092324 5216 OFFIC SUPP .00 .00 .00 654.85 .00 .00 .0% 2092324 5217 OTHER SUPP .00 .00 .00 16.58 .00 .00 .0% 2092324 5217 32304 OTHER SUPP 11,861.02 .00 .00 .00 .00 .00 .0% 2092324 5232 COMP EQUIP 856.98 .00 .00 156.19 .00 .00 .0% 2092324 5252 PROF SVS 50.44 .00 .00 .00 .00 .00 .0% 2092324 5258 OTHER SVS .00 .00 10,424.00 .00 10,424.00 .00 .0% 2092324 5258 32332 OTHER SVS 9,480.69 .00 .00 .00 .00 .00 .0% 2092324 5258 32333 OTHER SVS 19,651.00 .00 349.00 349.00 349.00 .00 .0% 2092324 5258 32334 OTHER SVS 50,000.00 .00 .00 .00 .00 .00 .0% 2092324 5258 32336 OTHER SVS 66,572.44 .00 .00 .00 .00 .00 .0% TOTAL CDBG-CV3 228,253.74 .00 10,773.00 1,176.62 10,773.00 .00 -100.0% 2092325 HOPE PRTNRS-FOOD SCRTY-CLOSED
2092325 5258 OTHER SVS .00 .00 10,000.00 10,000.00 10,000.00 8,000.00 -20.0%

Page 119 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 44 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT CDBG ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL HOPE PRTNRS-FOOD SCRTY .00 .00 10,000.00 10,000.00 10,000.00 8,000.00 -20.0% 2092332 CDBG- PAC LIFELINE WOMENS PRG
2092332 5258 OTHER SVS 8,000.00 .00 8,000.00 8,000.00 8,000.00 5,000.00 -37.5% TOTAL CDBG- PAC LIFELINE WOM 8,000.00 .00 8,000.00 8,000.00 8,000.00 5,000.00 -37.5% 2092336 CDBG-BIZ ASSTN & ACCTRA 18-19
2092336 5258 23619 OTHER SVS 8,800.00 .00 .00 400.00 .00 .00 .0% 2092336 5258 23620 OTHER SVS .00 .00 .00 400.00 .00 .00 .0% 2092336 5258 23621 OTHER SVS .00 .00 .00 6,702.50 .00 .00 .0% 2092336 5310 23619 FORG LOANS 33,972.00 .00 22,238.00 21,838.00 22,238.00 .00 .0% 2092336 5310 23620 FORG LOANS .00 .00 60,000.00 59,600.00 60,000.00 .00 .0% 2092336 5310 23621 FORG LOANS .00 110,000.00 120,000.00 113,297.50 120,000.00 .00 .0% 2092336 5310 23622 FORG LOANS .00 122,540.00 122,540.00 81,064.50 122,540.00 .00 .0% 2092336 5310 23624 FORG LOANS .00 .00 .00 .00 .00 139,490.00 .0% TOTAL CDBG-BIZ ASSTN & ACCTR 42,772.00 232,540.00 324,778.00 283,302.50 324,778.00 139,490.00 -57.1% 2092337 DWNTWN FACADE 18-19
2092337 5253 23720 CONTRC SVS 9,550.00 .00 .00 4,852.50 .00 .00 .0% 2092337 5258 23719 OTHER SVS 21,534.04 .00 1,000.00 1,000.00 1,000.00 .00 .0% 2092337 5258 23720 OTHER SVS 50,779.96 .00 39,671.00 34,818.50 39,671.00 .00 .0% 2092337 5258 23721 OTHER SVS .00 100,000.00 100,000.00 43,441.00 100,000.00 .00 .0% 2092337 5258 23722 OTHER SVS .00 110,000.00 110,000.00 .00 110,000.00 .00 .0% 2092337 5258 23724 OTHER SVS .00 .00 .00 .00 .00 139,490.00 .0% TOTAL DWNTWN FACADE 18-19 81,864.00 210,000.00 250,671.00 84,112.00 250,671.00 139,490.00 -44.4% 2092338 CDBG-EMGNCY REPAIR PRG 18-19
2092338 5252 23821 PROF SVS .00 .00 .00 800.00 .00 .00 .0% 2092338 5253 23821 CONTRC SVS 21,681.48 .00 .00 .00 .00 .00 .0% 2092338 5258 23820 OTHER SVS 89,531.68 .00 597.00 597.00 597.00 .00 .0% 2092338 5258 23821 OTHER SVS 38,307.58 100,000.00 133,046.00 132,245.26 133,046.00 .00 .0% 2092338 5258 23822 OTHER SVS .00 206,380.00 206,380.00 119,632.24 206,380.00 .00 .0% 2092338 5258 23823 OTHER SVS .00 .00 97,190.00 .00 97,190.00 .00 .0% 2092338 5258 23824 OTHER SVS .00 .00 .00 .00 .00 139,490.00 .0% TOTAL CDBG-EMGNCY REPAIR PRG 149,520.74 306,380.00 437,213.00 253,274.50 437,213.00 139,490.00 -68.1% 2092342 IVRS
2092342 5258 OTHER SVS .00 .00 .00 .00 .00 4,000.00 .0%

Page 120 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 45 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT CDBG ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL IVRS .00 .00 .00 .00 .00 4,000.00 .0% 2092345 BUSINESS ASST 17-18
2092345 5310 FORG LOANS 41,028.00 .00 .00 .00 .00 .00 .0% TOTAL BUSINESS ASST 17-18 41,028.00 .00 .00 .00 .00 .00 .0% 2092350 EASTERSEALS OF SOCAL - CLOSED
2092350 5258 OTHER SVS .00 .00 10,410.00 10,409.50 10,410.00 .00 .0% TOTAL EASTERSEALS OF SOCAL - .00 .00 10,410.00 10,409.50 10,410.00 .00 -100.0% 2092351 DOWNTOWN PK LOT IMP PRG-CLOSED
2092351 5528 IMPRV BLD .00 .00 146,450.00 15,477.00 146,450.00 .00 .0% TOTAL DOWNTOWN PK LOT IMP PR .00 .00 146,450.00 15,477.00 146,450.00 .00 -100.0% 2092352 ASSIST LEAGUE OF FOOTHILL COMM
2092352 5258 OTHER SVS .00 .00 .00 .00 .00 8,000.00 .0% TOTAL ASSIST LEAGUE OF FOOTH .00 .00 .00 .00 .00 8,000.00 .0% 2097500 CAPITAL PROJECTS - CLOSED
2097500 5258 OTHER SVS .00 .00 .00 .00 .00 146,450.00 .0% TOTAL CAPITAL PROJECTS - CLO .00 .00 .00 .00 .00 146,450.00 .0% 2097613 LANDECENA INTERIOR IMPROVEMENT
2097613 5212 23923 ADVERTISNG .00 .00 .00 4,702.46 .00 .00 .0% 2097613 5245 MAINT-BLDG 26,660.07 .00 .00 .00 .00 .00 .0% 2097613 5258 OTHER SVS 5,479.14 .00 .00 .00 .00 .00 .0% 2097613 5258 23923 OTHER SVS .00 .00 166,000.00 17,697.00 .00 137,000.00 -17.5% 2097613 5530 MACH&EQUIP 63,750.00 .00 .00 .00 .00 .00 .0% TOTAL LANDECENA INTERIOR IMP 95,889.21 .00 166,000.00 22,399.46 .00 137,000.00 -17.5% TOTAL CDBG 946,173.43 796,200.00 1,629,730.00 883,038.31 1,463,730.00 924,630.00 -43.3%

Page 121 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 46 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT PBIA ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2102501 PBIA
2102501 5245 MAINT-BLDG 24,990.00 39,000.00 39,000.00 .00 .00 94,800.00 143.1% 2102501 5251 LEGAL SVS 227.50 .00 .00 .00 .00 .00 .0% 2102501 5258 OTHER SVS 48,227.31 49,500.00 49,500.00 14,887.10 45,000.00 .00 .0% TOTAL PBIA 73,444.81 88,500.00 88,500.00 14,887.10 45,000.00 94,800.00 7.1% 2107500 CAPITAL PROJECTS - CLOSED
2107500 5258 OTHER SVS .00 .00 .00 .00 .00 39,000.00 .0% TOTAL CAPITAL PROJECTS - CLO .00 .00 .00 .00 .00 39,000.00 .0% 2107702 PARKING LOT REHAB & DWNTWN STR
2107702 5111 SALARY-FT .00 .00 .00 34.92 .00 .00 .0% 2107702 5116 FRINGE BEN .00 .00 .00 7.29 .00 .00 .0% 2107702 5117 RETIR CNTR .00 .00 .00 3.82 .00 .00 .0% 2107702 5222 PRINTING .00 .00 .00 373.16 .00 .00 .0% 2107702 5258 OTHER SVS 21,499.23 130,550.00 117,331.00 28,259.77 28,170.00 102,380.00 -12.7% TOTAL PARKING LOT REHAB & DW 21,499.23 130,550.00 117,331.00 28,678.96 28,170.00 102,380.00 -12.7% TOTAL PBIA 94,944.04 219,050.00 205,831.00 43,566.06 73,170.00 236,180.00 14.7%

Page 122 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 47 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT AIR QUALITY POLLUTION REDUCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2112502 AQMD
2112502 5111 SALARY-FT 4,514.65 3,370.00 3,370.00 2,835.85 3,370.00 3,450.00 2.4% 2112502 5116 FRINGE BEN 1,410.32 920.00 920.00 1,817.79 920.00 1,020.00 10.9% 2112502 5117 RETIR CNTR 329.72 370.00 370.00 304.80 370.00 420.00 13.5% 2112502 5136 FRG B-S PD 68.19 .00 .00 7.55 .00 .00 .0% 2112502 5217 OTHER SUPP .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 2112502 5321 EMPL INCEN 5,064.00 10,000.00 10,000.00 4,997.00 10,000.00 20,000.00 100.0% 2112502 5531 VEHICLES .00 148,000.00 307,000.00 61,546.20 307,000.00 .00 .0% TOTAL AQMD 11,386.88 163,660.00 322,660.00 71,509.19 322,660.00 25,890.00 -92.0% 2113211 POLICE PATROL
2113211 5530 MACH&EQUIP 17,150.03 .00 .00 .00 .00 .00 .0% TOTAL POLICE PATROL 17,150.03 .00 .00 .00 .00 .00 .0% TOTAL AIR QUALITY POLLUTION 28,536.91 163,660.00 322,660.00 71,509.19 322,660.00 25,890.00 -92.0%

Page 123 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 48 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT HOMELAND SECURITY GRANTS-PD ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2143201 HOMELAND SECURITY GRANTS-PD
32650 Homeland Security- TVTP 2021
2143201 5201 32650 PRSNL REIM .00 .00 5,859.00 .00 .00 5,860.00 .0% 2143201 5215 32650 TRNG/CONF .00 .00 10,000.00 .00 2,000.00 8,000.00 -20.0% 2143201 5233 32606 OTHR EQUIP 32,400.00 .00 .00 .00 .00 .00 .0% 2143201 5233 32613 OTHR EQUIP .00 .00 24,411.00 10,276.20 10,280.00 3,330.00 -86.4% 2143201 5233 32618 OTHR EQUIP .00 .00 .00 .00 .00 22,530.00 .0% 2143201 5253 32650 CONTRC SVS 23,615.20 .00 120,256.00 130,525.80 79,560.00 64,580.00 -46.3% 2143201 5530 32613 MACH&EQUIP .00 .00 .00 10,796.55 10,800.00 .00 .0% TOTAL HOMELAND SECURITY GRAN 56,015.20 .00 160,526.00 151,598.55 102,640.00 104,300.00 -35.0% TOTAL HOMELAND SECURITY GRAN 56,015.20 .00 160,526.00 151,598.55 102,640.00 104,300.00 -35.0%

Page 124 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 49 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT PROP 30 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2153257 PROP 30 - PD
2153257 5530 MACH&EQUIP .00 150,000.00 150,000.00 .00 .00 150,000.00 .0% TOTAL PROP 30 - PD .00 150,000.00 150,000.00 .00 .00 150,000.00 .0% TOTAL PROP 30 .00 150,000.00 150,000.00 .00 .00 150,000.00 .0%

Page 125 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 50 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT COPS ALLOCATION-PD ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2163201 POLICE ADMINISTRATION
2163201 5233 OTHR EQUIP .00 .00 .00 18,192.51 18,190.00 .00 .0% 2163201 5530 MACH&EQUIP .00 858,310.00 821,052.00 .00 .00 660,570.00 -19.5% 2163201 5531 VEHICLES .00 299,350.00 299,350.00 .00 .00 660,570.00 120.7% TOTAL POLICE ADMINISTRATION .00 1,157,660.00 1,120,402.00 18,192.51 18,190.00 1,321,140.00 17.9% 2163256 COPS ALLOCATION FY 14-15
2163256 5531 VEHICLES .00 .00 37,870.00 37,870.00 37,870.00 .00 .0% TOTAL COPS ALLOCATION FY 14- .00 .00 37,870.00 37,870.00 37,870.00 .00 -100.0% 2163262 COPS ALLOCATION FY 15-16
2163262 5531 VEHICLES .00 .00 153,230.00 153,230.00 153,230.00 .00 .0% TOTAL COPS ALLOCATION FY 15- .00 .00 153,230.00 153,230.00 153,230.00 .00 -100.0% 2163267 COPS ALLOCATION FY 16-17
2163267 5213 DUES&SUBSC .00 .00 .00 21,805.00 21,810.00 .00 .0% 2163267 5217 OTHER SUPP .00 .00 .00 676.10 680.00 .00 .0% 2163267 5531 VEHICLES .00 .00 162,730.00 116,778.85 116,780.00 .00 .0% TOTAL COPS ALLOCATION FY 16- .00 .00 162,730.00 139,259.95 139,270.00 .00 -100.0% 2163269 COPS ALLOCATION FY 17-18
2163269 5246 MAINT-EQP .00 .00 .00 176.00 180.00 .00 .0% 2163269 5530 MACH&EQUIP .00 .00 .00 6,515.47 6,500.00 .00 .0% 2163269 5531 VEHICLES .00 .00 37,258.00 49,579.23 .00 .00 .0% TOTAL COPS ALLOCATION FY 17- .00 .00 37,258.00 56,270.70 6,680.00 .00 -100.0% TOTAL COPS ALLOCATION-PD .00 1,157,660.00 1,511,490.00 404,823.16 355,240.00 1,321,140.00 -12.6%

Page 126 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 51 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT OTHER GRANTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2171401 INFORMATION SYSTEMS
82332 HAGMAN TECH & INFRASTRUCTURE GRT
2171401 5211 82332 POSTAGE .00 .00 .00 141.61 .00 .00 .0% 2171401 5217 82332 OTHER SUPP .00 .00 .00 494.70 .00 .00 .0% 2171401 5219 82332 PERM/LC/FE .00 .00 220,000.00 220,030.00 220,000.00 .00 .0% 2171401 5530 82332 MACH&EQUIP .00 .00 50,000.00 .00 50,000.00 .00 .0% TOTAL INFORMATION SYSTEMS .00 .00 270,000.00 220,666.31 270,000.00 .00 -100.0% 2171510 OTHER LIBRARY GRANT
2171510 5232 40180 COMP EQUIP .00 .00 29,854.00 29,854.50 29,854.00 .00 .0% TOTAL OTHER LIBRARY GRANT .00 .00 29,854.00 29,854.50 29,854.00 .00 -100.0% 2172203 ECONOMIC DEVELOPMENT
2172203 5299 42020 PY EXP 4,295.10 .00 .00 .00 .00 .00 .0% TOTAL ECONOMIC DEVELOPMENT 4,295.10 .00 .00 .00 .00 .00 .0% 2172205 PLANNING
2172205 5111 32605 SALARY-FT 4,917.55 .00 .00 3,234.29 .00 .00 .0% 2172205 5116 32605 FRINGE BEN 285.49 .00 .00 717.90 .00 .00 .0% 2172205 5117 32605 RETIR CNTR 131.71 .00 .00 345.37 .00 .00 .0% 2172205 5211 32605 POSTAGE 16.93 .00 .00 17.70 .00 .00 .0% 2172205 5212 32605 ADVERTISNG 1,634.64 .00 .00 750.98 .00 .00 .0% 2172205 5252 32605 PROF SVS 46,125.00 77,500.00 148,460.00 116,115.00 148,460.00 .00 .0% 2172205 5253 32615 CONTRC SVS .00 300,000.00 300,000.00 75,500.00 300,000.00 .00 .0% 2172205 5258 32605 OTHER SVS 700.00 .00 .00 700.00 .00 .00 .0% TOTAL PLANNING 53,811.32 377,500.00 448,460.00 197,381.24 448,460.00 .00 -100.0% 2172931 HOUSING PROGRAM
2172931 5111 42021 SALARY-FT 30,122.16 73,240.00 73,240.00 46,029.90 73,240.00 93,340.00 27.4% 2172931 5112 42021 SALARY-PT 20,342.97 23,310.00 23,310.00 4,367.27 23,310.00 23,560.00 1.1% 2172931 5113 42021 OVERTIME 1,648.28 .00 .00 904.84 .00 .00 .0% 2172931 5116 42021 FRINGE BEN 8,067.92 21,340.00 21,340.00 9,701.30 21,340.00 23,070.00 8.1% 2172931 5117 42021 RETIR CNTR 3,125.61 8,010.00 8,010.00 4,723.85 8,010.00 11,180.00 39.6% 2172931 5217 42021 OTHER SUPP .00 980.00 980.00 .00 980.00 .00 .0%

Page 127 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 52 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT OTHER GRANTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2172931 5258 42021 OTHER SVS 29,049.26 131,000.00 131,000.00 91,418.87 131,000.00 .00 .0% TOTAL HOUSING PROGRAM 92,356.20 257,880.00 257,880.00 157,146.03 257,880.00 151,150.00 -41.4% 2173201 POLICE
2173201 5530 82332 MACH&EQUIP .00 .00 87,288.00 84,328.18 87,280.00 .00 .0% TOTAL POLICE .00 .00 87,288.00 84,328.18 87,280.00 .00 -100.0% 2174201 RECREATION
2174201 5217 82331 OTHER SUPP .00 .00 .00 60,000.00 .00 .00 .0% 2174201 5231 82331 FURN&OFFC .00 .00 .00 29,169.21 .00 .00 .0% 2174201 5245 82331 MAINT-BLDG .00 .00 39,500.00 39,500.00 39,500.00 .00 .0% 2174201 5258 82331 OTHER SVS .00 .00 430,243.00 219,291.04 430,243.00 .00 .0% 2174201 5528 82331 IMPRV BLD 121,856.99 .00 115,257.00 115,256.96 115,257.00 .00 .0% TOTAL RECREATION 121,856.99 .00 585,000.00 463,217.21 585,000.00 .00 -100.0% 2175420 PARK MAINTENANCE - CLOSED
2175420 5217 25420 OTHER SUPP .00 .00 47,118.00 .00 310.00 690.00 -98.5% 2175420 5258 25420 OTHER SVS .00 .00 .00 39,035.00 59,740.00 .00 .0% 2175420 5528 25420 IMPRV BLD .00 .00 .00 .00 .00 164,340.00 .0% 2175420 5530 25420 MACH&EQUIP .00 .00 177,952.00 .00 .00 .00 .0% TOTAL PARK MAINTENANCE - CLO .00 .00 225,070.00 39,035.00 60,050.00 165,030.00 -26.7% TOTAL OTHER GRANTS 272,319.61 635,380.00 1,903,552.00 1,191,628.47 1,738,524.00 316,180.00 -83.4%

Page 128 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 53 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT OFFICE OF TRAFFIC SAFETY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2183276 OTS GRANTS
32607 OTS-STEP GRANT PT21173
2183276 5112 32607 SALARY-PT 1,094.48 .00 .00 .00 .00 .00 .0% 2183276 5113 32607 OVERTIME 1,480.59 .00 .00 .00 .00 .00 .0% 2183276 5113 32609 OVERTIME 257.53 .00 .00 .00 .00 .00 .0% 2183276 5113 32610 OVERTIME 4,827.21 .00 .00 844.02 1,570.00 .00 .0% 2183276 5113 32612 OVERTIME 490.39 .00 .00 282.74 530.00 .00 .0% 2183276 5113 32617 OVERTIME .00 .00 .00 4,949.29 5,520.00 1,840.00 .0% 2183276 5116 32612 FRINGE BEN 3.43 .00 .00 4.10 120.00 .00 .0% 2183276 5116 32617 FRINGE BEN .00 .00 .00 278.09 430.00 .00 .0% 2183276 5133 32607 OT-SW PD 41,956.61 .00 .00 .00 .00 .00 .0% 2183276 5133 32609 OT-SW PD 3,168.28 .00 .00 .00 .00 .00 .0% 2183276 5133 32610 OT-SW PD 47,817.28 .00 .00 23,990.51 44,550.00 .00 .0% 2183276 5133 32612 OT-SW PD 5,766.54 .00 .00 4,467.61 8,300.00 .00 .0% 2183276 5133 32614 OT-SW PD .00 .00 20,516.00 3,165.43 3,170.00 17,350.00 -15.4% 2183276 5133 32617 OT-SW PD .00 .00 174,567.00 55,171.99 64,820.00 102,380.00 -41.4% 2183276 5136 32610 FRG B-S PD 40.16 .00 .00 .00 780.00 .00 .0% 2183276 5136 32612 FRG B-S PD 83.61 .00 .00 64.78 1,110.00 .00 .0% 2183276 5136 32614 FRG B-S PD .00 .00 297.00 45.90 .00 .00 .0% 2183276 5136 32617 FRG B-S PD .00 .00 .00 1,586.39 2,800.00 .00 .0% 2183276 5215 32610 TRNG/CONF 340.00 1,590.00 1,590.00 .00 .00 .00 .0% 2183276 5215 32614 TRNG/CONF .00 .00 1,187.00 .00 .00 1,180.00 -.6% 2183276 5215 32617 TRNG/CONF .00 .00 2,367.00 486.47 .00 2,360.00 -.3% 2183276 5217 32610 OTHER SUPP .00 2,150.00 2,150.00 .00 1,850.00 .00 .0% 2183276 5217 32614 OTHER SUPP .00 .00 3,000.00 1,844.94 .00 1,150.00 -61.7% 2183276 5217 32617 OTHER SUPP .00 .00 9,566.00 1,951.16 2,440.00 2,120.00 -77.8% 2183276 5219 32611 PERM/LC/FE 20,520.55 .00 .00 .00 .00 .00 .0% 2183276 5233 32610 OTHR EQUIP 10,489.81 .00 .00 .00 .00 .00 .0% 2183276 5233 32617 OTHR EQUIP .00 .00 .00 4,999.97 5,000.00 .00 .0% 2183276 5253 32610 CONTRC SVS 525.00 .00 .00 .00 .00 .00 .0% 2183276 5254 32616 DATA P SVS .00 .00 .00 9,460.20 .00 9,460.00 .0% 2183276 5258 32610 OTHER SVS .00 2,070.00 2,070.00 .00 .00 .00 .0% 2183276 5258 32616 OTHER SVS .00 .00 21,000.00 1,560.00 .00 1,560.00 -92.6% 2183276 5258 32617 OTHER SVS .00 .00 3,000.00 .00 .00 3,000.00 .0% 2183276 5530 32617 MACH&EQUIP .00 .00 10,500.00 9,183.45 9,190.00 1,310.00 -87.5% 2183276 5535 32616 INTAN-SFTW .00 .00 .00 9,500.36 9,500.00 .00 .0% TOTAL OTS GRANTS 138,861.47 5,810.00 251,810.00 133,837.40 161,680.00 143,710.00 -42.9% TOTAL OFFICE OF TRAFFIC SAFE 138,861.47 5,810.00 251,810.00 133,837.40 161,680.00 143,710.00 -42.9%

Page 129 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 54 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT OTHER PUBLIC SAFETY GRANTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2190000 OTHER PUBLIC SAFETY GRANTS
32010 JAG GRANT 2017
2190000 5233 32010 OTHR EQUIP .00 .00 .00 13,719.00 .00 .00 .0% 2190000 5530 32010 MACH&EQUIP .00 .00 13,719.00 .00 13,720.00 .00 .0% TOTAL OTHER PUBLIC SAFETY GR .00 .00 13,719.00 13,719.00 13,720.00 .00 -100.0% 2193201 PUBLIC SAFETY GRANTS
2193201 5133 32001 OT-SW PD .00 .00 .00 519.20 .00 .00 .0% 2193201 5136 32001 FRG B-S PD .00 .00 .00 93.74 .00 .00 .0% 2193201 5233 32011 OTHR EQUIP .00 .00 .00 .00 .00 15,270.00 .0% 2193201 5233 32012 OTHR EQUIP .00 .00 .00 .00 .00 15,730.00 .0% 2193201 5233 32013 OTHR EQUIP .00 .00 .00 .00 .00 15,590.00 .0% 2193201 5233 32014 OTHR EQUIP .00 .00 .00 .00 .00 19,170.00 .0% 2193201 5233 32015 OTHR EQUIP .00 .00 .00 .00 .00 23,090.00 .0% TOTAL PUBLIC SAFETY GRANTS .00 .00 .00 612.94 .00 88,850.00 .0% TOTAL OTHER PUBLIC SAFETY GR .00 .00 13,719.00 14,331.94 13,720.00 88,850.00 547.6%

Page 130 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 55 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT ASSET FORFEITURE-FED DOJ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2203201 ASSET FORFEITURE-FED DOJ
2203201 5530 MACH&EQUIP .00 .00 .00 .00 .00 1,189,580.00 .0% TOTAL ASSET FORFEITURE-FED D .00 .00 .00 .00 .00 1,189,580.00 .0% TOTAL ASSET FORFEITURE-FED D .00 .00 .00 .00 .00 1,189,580.00 .0%

Page 131 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 56 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT CALHOME ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2222402 HOME IMPROVEMENT PROGRAM
2222402 5601 LN ACTV 126,760.35 .00 .00 .00 .00 .00 .0% TOTAL HOME IMPROVEMENT PROGR 126,760.35 .00 .00 .00 .00 .00 .0% 2222407 CALHOME 12-8689
2222407 5314 HIP LOANS .00 115,000.00 115,000.00 .00 115,000.00 .00 .0% 2222407 5315 FTHB LOANS .00 560,000.00 560,000.00 .00 560,000.00 .00 .0% TOTAL CALHOME 12-8689 .00 675,000.00 675,000.00 .00 675,000.00 .00 -100.0% TOTAL CALHOME 126,760.35 675,000.00 675,000.00 .00 675,000.00 .00 -100.0%

Page 132 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 57 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT ASSET FORFEITURE-FED TREASURY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2233201 ASSET FORFEITURE-FED TREASURY
2233201 5530 MACH&EQUIP .00 .00 .00 .00 .00 10,350.00 .0% TOTAL ASSET FORFEITURE-FED T .00 .00 .00 .00 .00 10,350.00 .0% TOTAL ASSET FORFEITURE-FED T .00 .00 .00 .00 .00 10,350.00 .0%

Page 133 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 58 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT ASSET FORFEITURE-STATE ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2243201 ASSET FORFEITURE-STATE
2243201 5530 MACH&EQUIP .00 .00 .00 .00 .00 193,360.00 .0% TOTAL ASSET FORFEITURE-STATE .00 .00 .00 .00 .00 193,360.00 .0% 2243423 ASSET FORFEITURE STATE-15%
2243423 5258 OTHER SVS 6,500.00 .00 .00 .00 .00 .00 .0% TOTAL ASSET FORFEITURE STATE 6,500.00 .00 .00 .00 .00 .00 .0% TOTAL ASSET FORFEITURE-STATE 6,500.00 .00 .00 .00 .00 193,360.00 .0%

Page 134 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 59 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT OFFICE OF JUSTICE PROGRAMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2273211 POLICE PATROL
2273211 5232 COMP EQUIP 7,056.90 .00 .00 .00 .00 .00 .0% TOTAL POLICE PATROL 7,056.90 .00 .00 .00 .00 .00 .0% TOTAL OFFICE OF JUSTICE PROG 7,056.90 .00 .00 .00 .00 .00 .0%

Page 135 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 60 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT AMERICAN RESCUE PLAN ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2290000 AMERICAN RESCUE PLAN ACT
2290000 5070 TRNSFR OUT .00 2,444,620.00 2,444,620.00 .00 2,444,620.00 .00 .0% TOTAL AMERICAN RESCUE PLAN A .00 2,444,620.00 2,444,620.00 .00 2,444,620.00 .00 -100.0% 2291201 CITY ADMINISTRATION
2291201 5253 CONTRC SVS 22,275.00 .00 .00 .00 .00 .00 .0% TOTAL CITY ADMINISTRATION 22,275.00 .00 .00 .00 .00 .00 .0% 2291301 ARPA FINANCE
2291301 5111 SALARY-FT .00 52,300.00 52,300.00 41,373.83 52,300.00 65,970.00 26.1% 2291301 5116 FRINGE BEN .00 11,220.00 11,220.00 8,491.22 11,220.00 14,560.00 29.8% 2291301 5117 RETIR CNTR .00 5,670.00 5,670.00 4,235.77 5,670.00 7,860.00 38.6% 2291301 5253 CONTRC SVS 11,093.75 .00 .00 .00 .00 .00 .0% 2291301 5529 BLD IMP .00 .00 .00 .00 .00 60,000.00 .0% TOTAL ARPA FINANCE 11,093.75 69,190.00 69,190.00 54,100.82 69,190.00 148,390.00 114.5% 2291401 INFORMATION SYSTEMS
2291401 5232 16141 COMP EQUIP 26,337.10 .00 .00 .00 .00 .00 .0% 2291401 5232 16142 COMP EQUIP 90,454.48 .00 .00 .00 .00 .00 .0% TOTAL INFORMATION SYSTEMS 116,791.58 .00 .00 .00 .00 .00 .0% 2291504 ARPA NON-DEPARTMENTAL
2291504 5115 EW PRM PAY .00 936,225.00 936,225.00 915,250.00 936,225.00 803,340.00 -14.2% 2291504 5116 FRINGE BEN .00 13,775.00 13,775.00 7,451.19 13,775.00 11,650.00 -15.4% 2291504 5136 FRG B-S PD .00 .00 .00 5,682.19 .00 .00 .0% TOTAL ARPA NON-DEPARTMENTAL .00 950,000.00 950,000.00 928,383.38 950,000.00 814,990.00 -14.2% 2291601 ARPA-HUMAN RESOURCES
2291601 5529 BLD IMP .00 .00 .00 .00 .00 40,000.00 .0% TOTAL ARPA-HUMAN RESOURCES .00 .00 .00 .00 .00 40,000.00 .0% 2291701 ARPA CITY CLERK
2291701 5219 16119 PERM/LC/FE 93,375.00 .00 42,693.00 42,693.00 42,693.00 .00 .0%

Page 136 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 61 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT AMERICAN RESCUE PLAN ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL ARPA CITY CLERK 93,375.00 .00 42,693.00 42,693.00 42,693.00 .00 -100.0% 2292203 ECONOMIC DEVELOPMENT
2292203 5111 SALARY-FT 221.31 50,350.00 15,560.00 13,320.99 15,560.00 18,780.00 20.7% 2292203 5116 FRINGE BEN 8.27 14,610.00 1,720.00 2,411.18 1,720.00 4,960.00 188.4% 2292203 5117 RETIR CNTR 24.26 5,500.00 4,570.00 1,458.10 4,570.00 2,260.00 -50.5% 2292203 5212 16123 ADVERTISNG .00 .00 .00 106.25 .00 .00 .0% 2292203 5222 16123 PRINTING .00 .00 .00 105.60 .00 .00 .0% 2292203 5258 16120 OTHER SVS .00 .00 350,000.00 .00 350,000.00 .00 .0% 2292203 5258 16121 OTHER SVS .00 .00 350,000.00 .00 350,000.00 .00 .0% 2292203 5258 16122 OTHER SVS .00 .00 325,000.00 105,207.56 325,000.00 .00 .0% 2292203 5258 16123 OTHER SVS .00 .00 250,000.00 250,000.00 250,000.00 .00 .0% TOTAL ECONOMIC DEVELOPMENT 253.84 70,460.00 1,296,850.00 372,609.68 1,296,850.00 26,000.00 -98.0% 2292501 ARPA DOWNTOWN IMPROVEMENTS
2292501 5111 32337 SALARY-FT .00 .00 .00 34.92 .00 .00 .0% 2292501 5116 32337 FRINGE BEN .00 .00 .00 7.24 .00 .00 .0% 2292501 5117 32337 RETIR CNTR .00 .00 .00 3.80 .00 .00 .0% 2292501 5222 32337 PRINTING .00 .00 .00 639.63 .00 .00 .0% 2292501 5233 32337 OTHR EQUIP .00 .00 120,000.00 .00 .00 .00 -100.0% 2292501 5258 16126 OTHER SVS .00 .00 .00 1,610.87 660.00 119,340.00 .0% 2292501 5530 16126 MACH&EQUIP .00 .00 210,016.00 208,404.33 210,016.00 .00 .0% TOTAL ARPA DOWNTOWN IMPROVEM .00 .00 330,016.00 210,700.79 210,676.00 119,340.00 -63.8% 2292931 HOUSING ADMINISTRATION
2292931 5252 16114 PROF SVS 800.00 .00 48,610.00 .00 48,610.00 .00 .0% TOTAL HOUSING ADMINISTRATION 800.00 .00 48,610.00 .00 48,610.00 .00 -100.0% 2293201 LICENSE PLATE READER UPGRADE
2293201 5213 16134 DUES&SUBSC .00 .00 .00 165,935.00 .00 .00 .0% 2293201 5215 16134 TRNG/CONF .00 .00 .00 999.99 .00 .00 .0% 2293201 5219 16134 PERM/LC/FE .00 .00 .00 65,000.00 .00 .00 .0% 2293201 5231 FURN&OFFC .00 .00 .00 .00 .00 22,500.00 .0% 2293201 5246 16134 MAINT-EQP .00 .00 .00 64,000.00 .00 .00 .0% 2293201 5258 16134 OTHER SVS .00 .00 .00 5,212.50 .00 .00 .0% 2293201 5530 16134 MACH&EQUIP .00 .00 775,272.00 775,271.86 775,272.00 .00 .0%

Page 137 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 62 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT AMERICAN RESCUE PLAN ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2293201 5535 16134 INTAN-SFTW .00 .00 .00 10,000.00 .00 .00 .0% TOTAL LICENSE PLATE READER U .00 .00 775,272.00 1,086,419.35 775,272.00 22,500.00 -97.1% 2293202 VENTILATION EQUIPMENT
2293202 5131 SAL-SW PD 5,050.77 .00 .00 .00 .00 .00 .0% 2293202 5530 16132 MACH&EQUIP 16,147.34 .00 .00 8,852.66 .00 .00 .0% TOTAL VENTILATION EQUIPMENT 21,198.11 .00 .00 8,852.66 .00 .00 .0% 2293211 POLICE PATROL
2293211 5131 SAL-SW PD 258,594.72 .00 .00 .00 .00 .00 .0% 2293211 5133 OT-SW PD 58,715.50 .00 .00 .00 .00 .00 .0% 2293211 5136 FRG B-S PD 46,688.08 .00 .00 .00 .00 .00 .0% 2293211 5137 RT CNTR-PD 45,156.23 .00 .00 .00 .00 .00 .0% 2293211 5253 16113 CONTRC SVS 141,225.00 .00 .00 .00 .00 .00 .0% 2293211 5531 VEHICLES .00 117,200.00 117,200.00 99,157.84 117,200.00 .00 .0% TOTAL POLICE PATROL 550,379.53 117,200.00 117,200.00 99,157.84 117,200.00 .00 -100.0% 2294201 ARPA-RECREATION ADMINISTRATION
2294201 5531 VEHICLES .00 .00 .00 .00 .00 18,000.00 .0% TOTAL ARPA-RECREATION ADMINI .00 .00 .00 .00 .00 18,000.00 .0% 2294203 ARPA-RECREATION FACILITIES
2294203 5528 16151 IMPRV BLD .00 .00 47,520.00 47,520.00 47,520.00 .00 .0% 2294203 5529 BLD IMP .00 .00 .00 .00 .00 60,000.00 .0% TOTAL ARPA-RECREATION FACILI .00 .00 47,520.00 47,520.00 47,520.00 60,000.00 26.3% 2295301 ARPA-ENGINEERING ADMIN
2295301 5253 16154 CONTRC SVS .00 .00 600,000.00 300,000.00 600,000.00 .00 .0% TOTAL ARPA-ENGINEERING ADMIN .00 .00 600,000.00 300,000.00 600,000.00 .00 -100.0% 2295403 ARPA-SIDEWALK MAINTENANCE
2295403 5253 16157 CONTRC SVS 525,997.00 .00 .00 .00 .00 .00 .0%

Page 138 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 63 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT AMERICAN RESCUE PLAN ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL ARPA-SIDEWALK MAINTENA 525,997.00 .00 .00 .00 .00 .00 .0% 2295420 ARPA- PARK MAINTENANCE
2295420 5530 MACH&EQUIP .00 .00 .00 .00 .00 90,000.00 .0% TOTAL ARPA- PARK MAINTENANCE .00 .00 .00 .00 .00 90,000.00 .0% 2297500 CAPITAL PROJECTS
2297500 5111 16150 SALARY-FT 15,395.64 .00 .00 8,507.09 .00 .00 .0% 2297500 5111 16160 SALARY-FT .00 .00 .00 2,836.84 .00 .00 .0% 2297500 5111 16163 SALARY-FT .00 .00 .00 366.63 .00 .00 .0% 2297500 5113 16150 OVERTIME 87.34 .00 .00 .00 .00 .00 .0% 2297500 5116 16150 FRINGE BEN 2,798.73 .00 .00 1,653.63 .00 .00 .0% 2297500 5116 16160 FRINGE BEN .00 .00 .00 422.34 .00 .00 .0% 2297500 5116 16163 FRINGE BEN .00 .00 .00 49.28 .00 .00 .0% 2297500 5117 16150 RETIR CNTR 1,608.78 .00 .00 932.25 .00 .00 .0% 2297500 5117 16160 RETIR CNTR .00 .00 .00 310.92 .00 .00 .0% 2297500 5117 16163 RETIR CNTR .00 .00 .00 40.09 .00 .00 .0% 2297500 5212 16150 ADVERTISNG 3,673.28 .00 .00 .00 .00 .00 .0% 2297500 5219 16150 PERM/LC/FE 50.00 .00 .00 .00 .00 .00 .0% 2297500 5258 OTHER SVS .00 .00 .00 .00 .00 795,000.00 .0% 2297500 5258 16150 OTHER SVS 412,795.76 544,620.00 119,590.00 522,176.75 28,990.00 .00 .0% 2297500 5258 16159 OTHER SVS 91,749.88 11,740.00 250.00 .00 .00 .00 .0% 2297500 5258 16160 OTHER SVS .00 444,000.00 444,000.00 .00 2,750.00 531,850.00 19.8% 2297500 5258 16161 OTHER SVS .00 526,000.00 526,000.00 .00 526,000.00 .00 .0% 2297500 5258 16162 OTHER SVS .00 474,000.00 474,000.00 474,000.00 474,000.00 .00 .0% 2297500 5258 16163 OTHER SVS .00 129,000.00 129,000.00 .00 270.00 1,250,000.00 869.0% TOTAL CAPITAL PROJECTS 528,159.41 2,129,360.00 1,692,840.00 1,011,295.82 1,032,010.00 2,576,850.00 52.2% 2298001 PAVA MGMT-MASTER PLAN
2298001 5111 SALARY-FT .00 .00 .00 331.71 .00 .00 .0% 2298001 5116 FRINGE BEN .00 .00 .00 45.04 .00 .00 .0% 2298001 5117 RETIR CNTR .00 .00 .00 36.35 .00 .00 .0% 2298001 5258 16153 OTHER SVS .00 200,000.00 200,000.00 .00 410.00 199,590.00 -.2% TOTAL PAVA MGMT-MASTER PLAN .00 200,000.00 200,000.00 413.10 410.00 199,590.00 -.2% 2298003 SIDEWALK INV-MASTER PLAN
2298003 5111 SALARY-FT .00 .00 .00 104.75 .00 .00 .0%

Page 139 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 64 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT AMERICAN RESCUE PLAN ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 2298003 5116 FRINGE BEN .00 .00 .00 20.54 .00 .00 .0% 2298003 5117 RETIR CNTR .00 .00 .00 11.45 .00 .00 .0% 2298003 5252 16156 PROF SVS .00 .00 .00 440,550.00 .00 .00 .0% 2298003 5258 16156 OTHER SVS .00 180,000.00 440,550.00 .00 57,940.00 382,610.00 -13.2% TOTAL SIDEWALK INV-MASTER PL .00 180,000.00 440,550.00 440,686.74 57,940.00 382,610.00 -13.2% 2298004 ADA PUB FAC-MASTER PLAN
2298004 5111 16155 SALARY-FT .00 .00 .00 69.83 .00 .00 .0% 2298004 5116 16155 FRINGE BEN .00 .00 .00 14.59 .00 .00 .0% 2298004 5117 16155 RETIR CNTR .00 .00 .00 7.65 .00 .00 .0% 2298004 5258 16155 OTHER SVS .00 250,000.00 250,000.00 .00 90.00 249,910.00 .0% TOTAL ADA PUB FAC-MASTER PLA .00 250,000.00 250,000.00 92.07 90.00 249,910.00 .0% 2298005 TRAFFIC SIG-MASTER PLAN
2298005 5111 16158 SALARY-FT .00 .00 .00 279.33 .00 .00 .0% 2298005 5116 16158 FRINGE BEN .00 .00 .00 57.98 .00 .00 .0% 2298005 5117 16158 RETIR CNTR .00 .00 .00 30.42 .00 .00 .0% 2298005 5258 16158 OTHER SVS .00 175,000.00 175,000.00 .00 370.00 174,630.00 -.2% TOTAL TRAFFIC SIG-MASTER PLA .00 175,000.00 175,000.00 367.73 370.00 174,630.00 -.2% TOTAL AMERICAN RESCUE PLAN A 1,870,323.22 6,585,830.00 9,480,361.00 4,603,292.98 7,693,451.00 4,922,810.00 -48.1%

Page 140 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 65 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4203201 POLICE ADMINISTRATION-DIF
4203201 5531 VEHICLES 4,383.15 .00 .00 .00 .00 .00 .0% TOTAL POLICE ADMINISTRATION- 4,383.15 .00 .00 .00 .00 .00 .0% 4203211 PD PATROL - DIF
4203211 5531 VEHICLES .00 .00 28,112.00 28,112.27 28,112.00 .00 .0% TOTAL PD PATROL - DIF .00 .00 28,112.00 28,112.27 28,112.00 .00 -100.0% 4207500 CAPITAL PROJECTS
4207500 5111 80002 SALARY-FT .00 .00 .00 209.50 .00 .00 .0% 4207500 5116 80002 FRINGE BEN .00 .00 .00 42.64 .00 .00 .0% 4207500 5117 80002 RETIR CNTR .00 .00 .00 22.88 .00 .00 .0% 4207500 5258 80001 OTHER SVS .00 33,000.00 33,000.00 .00 .00 225,000.00 581.8% 4207500 5258 80002 OTHER SVS .00 48,000.00 48,000.00 .00 250.00 329,750.00 587.0% TOTAL CAPITAL PROJECTS .00 81,000.00 81,000.00 275.02 250.00 554,750.00 584.9% TOTAL GENERAL DEVELOPMENT 4,383.15 81,000.00 109,112.00 28,387.29 28,362.00 554,750.00 408.4%

Page 141 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 66 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT PARK ACQUISITION & DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4212501 QUIMBY ACT-PW ADMIN
32337 UPLAND PARKLET PRG-CARS ACT
4212501 5233 32337 OTHR EQUIP .00 .00 100,000.00 .00 .00 .00 .0% TOTAL QUIMBY ACT-PW ADMIN .00 .00 100,000.00 .00 .00 .00 -100.0% 4217500 CAPITAL PROJECTS
4217500 5111 82338 SALARY-FT 254.89 .00 .00 101.96 .00 .00 .0% 4217500 5111 82339 SALARY-FT 258.25 .00 .00 7,914.91 .00 .00 .0% 4217500 5116 82338 FRINGE BEN 50.24 .00 .00 19.41 .00 .00 .0% 4217500 5116 82339 FRINGE BEN 54.69 .00 .00 1,402.35 .00 .00 .0% 4217500 5117 82338 RETIR CNTR 26.75 .00 .00 11.18 .00 .00 .0% 4217500 5117 82339 RETIR CNTR 27.39 .00 .00 867.31 .00 .00 .0% 4217500 5212 82339 ADVERTISNG .00 .00 .00 3,011.54 .00 .00 .0% 4217500 5252 82338 PROF SVS 1,350.00 .00 .00 540.00 .00 .00 .0% 4217500 5252 82340 PROF SVS 1,967.50 .00 .00 .00 .00 .00 .0% 4217500 5258 OTHER SVS .00 .00 .00 .00 .00 867,250.00 .0% 4217500 5258 82338 OTHER SVS 12,878.69 253,980.00 256,639.00 65,000.00 65,340.00 191,300.00 -25.5% 4217500 5258 82339 OTHER SVS .00 199,910.00 199,660.00 241.89 13,440.00 800,000.00 300.7% 4217500 5258 82345 OTHER SVS .00 550,000.00 550,000.00 .00 .00 550,000.00 .0% 4217500 5258 82346 OTHER SVS .00 200,000.00 200,000.00 .00 .00 200,000.00 .0% TOTAL CAPITAL PROJECTS 16,868.40 1,203,890.00 1,206,299.00 79,110.55 78,780.00 2,608,550.00 116.2% 4218203 SPORTS PARK
4218203 5111 SALARY-FT .00 .00 .00 87.29 .00 .00 .0% 4218203 5116 FRINGE BEN .00 .00 .00 18.12 .00 .00 .0% 4218203 5117 RETIR CNTR .00 .00 .00 9.50 .00 .00 .0% 4218203 5258 OTHER SVS .00 86,150.00 86,150.00 .00 110.00 86,040.00 -.1% TOTAL SPORTS PARK .00 86,150.00 86,150.00 114.91 110.00 86,040.00 -.1% 4218209 MAGNOLIA RESTROOM ADA CMPLNC
4218209 5258 OTHER SVS .00 .00 23,400.00 .00 .00 .00 .0% TOTAL MAGNOLIA RESTROOM ADA .00 .00 23,400.00 .00 .00 .00 -100.0% 4218231 MEM PK BKST/SAFETY NET
4218231 5258 OTHER SVS 1,040.00 .00 2,196.00 .00 .00 .00 .0%

Page 142 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 67 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT PARK ACQUISITION & DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL MEM PK BKST/SAFETY NET 1,040.00 .00 2,196.00 .00 .00 .00 -100.0% TOTAL PARK ACQUISITION & DEV 17,908.40 1,290,040.00 1,418,045.00 79,225.46 78,890.00 2,694,590.00 90.0%

Page 143 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 68 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT STORM DRAIN DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4227500 CAPITAL PROJECTS
84001 ARROW HY STRM DRN IMPRV (BNSN-FRWD)
4227500 5111 84001 SALARY-FT 473.78 .00 .00 174.58 .00 .00 .0% 4227500 5111 84002 SALARY-FT .00 .00 .00 52.37 .00 .00 .0% 4227500 5116 84001 FRINGE BEN 91.11 .00 .00 17.89 .00 .00 .0% 4227500 5116 84002 FRINGE BEN .00 .00 .00 .76 .00 .00 .0% 4227500 5117 84001 RETIR CNTR 49.37 .00 .00 19.14 .00 .00 .0% 4227500 5117 84002 RETIR CNTR .00 .00 .00 5.74 .00 .00 .0% 4227500 5258 84001 OTHER SVS .00 1,448,210.00 1,448,210.00 .00 210.00 2,248,000.00 55.2% 4227500 5258 84002 OTHER SVS .00 175,000.00 175,000.00 .00 60.00 174,940.00 .0% TOTAL CAPITAL PROJECTS 614.26 1,623,210.00 1,623,210.00 270.48 270.00 2,422,940.00 49.3% 4228402 STRM DRN RPLCMNTS
4228402 5111 SALARY-FT .00 .00 .00 594.96 .00 .00 .0% 4228402 5116 FRINGE BEN .00 .00 .00 137.92 .00 .00 .0% 4228402 5117 RETIR CNTR .00 .00 .00 65.11 .00 .00 .0% 4228402 5258 OTHER SVS .00 191,390.00 191,390.00 .00 13,300.00 178,090.00 -6.9% TOTAL STRM DRN RPLCMNTS .00 191,390.00 191,390.00 797.99 13,300.00 178,090.00 -6.9% 4228405 EUCLID STRM DRN-"D" TO 18TH ST
4228405 5111 SALARY-FT .00 .00 .00 890.36 .00 .00 .0% 4228405 5116 FRINGE BEN .00 .00 .00 161.23 .00 .00 .0% 4228405 5117 RETIR CNTR .00 .00 .00 97.58 .00 .00 .0% 4228405 5258 OTHER SVS .00 91,730.00 91,730.00 .00 1,150.00 90,580.00 -1.3% TOTAL EUCLID STRM DRN-"D" TO .00 91,730.00 91,730.00 1,149.17 1,150.00 90,580.00 -1.3% 4228408 SD MP IMP- PH 1
4228408 5258 OTHER SVS .00 99,770.00 99,770.00 .00 .00 99,770.00 .0% TOTAL SD MP IMP- PH 1 .00 99,770.00 99,770.00 .00 .00 99,770.00 .0% 4228411 SP/PE TRAIL STORM DRAIN IMPROV
4228411 5111 SALARY-FT 1,145.85 .00 .00 .00 .00 .00 .0% 4228411 5116 FRINGE BEN 188.72 .00 .00 .00 .00 .00 .0% 4228411 5117 RETIR CNTR 119.39 .00 .00 .00 .00 .00 .0%

Page 144 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 69 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT STORM DRAIN DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4228411 5258 OTHER SVS 5,200.00 .00 62,521.00 .00 .00 .00 .0% TOTAL SP/PE TRAIL STORM DRAI 6,653.96 .00 62,521.00 .00 .00 .00 -100.0% TOTAL STORM DRAIN DEVELOPMEN 7,268.22 2,006,100.00 2,068,621.00 2,217.64 14,720.00 2,791,380.00 34.9%

Page 145 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 70 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT STREET & TRAFFIC FACILITY DEV ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4235301 ENGINEERING ADMINISTRATION
4235301 5111 SALARY-FT 3,957.69 7,600.00 7,600.00 3,565.13 7,600.00 8,750.00 15.1% 4235301 5116 FRINGE BEN 683.55 1,460.00 1,460.00 725.56 1,460.00 1,630.00 11.6% 4235301 5117 RETIR CNTR 398.08 830.00 830.00 378.05 830.00 1,050.00 26.5% 4235301 5707 PERSUALALC 2,010.00 2,440.00 2,440.00 2,436.00 2,440.00 2,300.00 -5.7% TOTAL ENGINEERING ADMINISTRA 7,049.32 12,330.00 12,330.00 7,104.74 12,330.00 13,730.00 11.4% 4237500 CAPITAL PROJECTS
4237500 5258 OTHER SVS .00 .00 .00 .00 .00 406,840.00 .0% 4237500 5258 85001 OTHER SVS .00 31,000.00 31,000.00 .00 .00 31,000.00 .0% TOTAL CAPITAL PROJECTS .00 31,000.00 31,000.00 .00 .00 437,840.00 1312.4% 4238617 ARROW RTW WDNG
4238617 5258 OTHER SVS .00 62,000.00 62,000.00 .00 .00 62,000.00 .0% TOTAL ARROW RTW WDNG .00 62,000.00 62,000.00 .00 .00 62,000.00 .0% 4238622 I-10 & EUCLID AVE INTERCHANGE
4238622 5111 SALARY-FT 66.83 .00 .00 69.83 .00 .00 .0% 4238622 5116 FRINGE BEN 13.32 .00 .00 14.59 .00 .00 .0% 4238622 5117 RETIR CNTR 6.96 .00 .00 7.65 .00 .00 .0% 4238622 5258 OTHER SVS .00 171,750.00 171,664.00 161,381.00 161,470.00 10,190.00 -94.1% TOTAL I-10 & EUCLID AVE INTE 87.11 171,750.00 171,664.00 161,473.07 161,470.00 10,190.00 -94.1% 4238623 I-10 & MONTE VISTA INTERCHANGE
4238623 5111 SALARY-FT 142.08 .00 .00 44.69 .00 .00 .0% 4238623 5116 FRINGE BEN 27.58 .00 .00 8.51 .00 .00 .0% 4238623 5117 RETIR CNTR 14.94 .00 .00 4.90 .00 .00 .0% 4238623 5258 OTHER SVS 360,177.00 110,770.00 94,236.00 .00 60.00 94,180.00 -.1% TOTAL I-10 & MONTE VISTA INT 360,361.60 110,770.00 94,236.00 58.10 60.00 94,180.00 -.1% 4238624 TRAFFIC SIGNAL UPGRADES 18/19
4238624 5111 SALARY-FT 699.00 .00 .00 .00 .00 .00 .0%

Page 146 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 71 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT STREET & TRAFFIC FACILITY DEV ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4238624 5116 FRINGE BEN 140.05 .00 .00 .00 .00 .00 .0% 4238624 5117 RETIR CNTR 72.83 .00 .00 .00 .00 .00 .0% 4238624 5258 OTHER SVS 5,800.00 .00 24,547.00 .00 .00 .00 .0% 4238624 5530 MACH&EQUIP 9,488.89 .00 .00 .00 .00 .00 .0% TOTAL TRAFFIC SIGNAL UPGRADE 16,200.77 .00 24,547.00 .00 .00 .00 -100.0% 4238625 TRAFFIC SIGNAL UPGRADES 19/20
4238625 5111 SALARY-FT .00 .00 .00 69.83 .00 .00 .0% 4238625 5116 FRINGE BEN .00 .00 .00 13.29 .00 .00 .0% 4238625 5117 RETIR CNTR .00 .00 .00 7.65 .00 .00 .0% 4238625 5258 OTHER SVS .00 150,000.00 150,000.00 .00 90.00 299,910.00 99.9% TOTAL TRAFFIC SIGNAL UPGRADE .00 150,000.00 150,000.00 90.77 90.00 299,910.00 99.9% TOTAL STREET & TRAFFIC FACIL 383,698.80 537,850.00 545,777.00 168,726.68 173,950.00 917,850.00 68.2%

Page 147 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 72 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT GENERAL CAPITAL PROJECTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4253205 ANIMAL SHELTER
30502 ANIMAL SHELTER IMPROVEMENTS
4253205 5528 30502 IMPRV BLD .00 60,000.00 60,000.00 60,000.00 60,000.00 .00 .0% TOTAL ANIMAL SHELTER .00 60,000.00 60,000.00 60,000.00 60,000.00 .00 -100.0% 4254203 RECREATION FACILITIES
4254203 5245 20310 MAINT-BLDG .00 .00 .00 92,432.46 .00 .00 .0% 4254203 5258 20310 OTHER SVS .00 .00 102,485.00 .00 .00 .00 .0% 4254203 5530 20104 MACH&EQUIP .00 30,000.00 30,000.00 26,684.00 .00 .00 .0% TOTAL RECREATION FACILITIES .00 30,000.00 132,485.00 119,116.46 .00 .00 -100.0% 4257500 CAPITAL PROJECTS
4257500 5111 82336 SALARY-FT 1,580.56 .00 .00 818.86 .00 .00 .0% 4257500 5116 82336 FRINGE BEN 301.18 .00 .00 175.39 .00 .00 .0% 4257500 5117 82336 RETIR CNTR 164.71 .00 .00 89.75 .00 .00 .0% 4257500 5212 82336 ADVERTISNG 1,900.36 .00 .00 .00 .00 .00 .0% 4257500 5219 82336 PERM/LC/FE 50.00 .00 .00 .00 .00 .00 .0% 4257500 5258 OTHER SVS .00 .00 .00 .00 .00 150,000.00 .0% 4257500 5258 82336 OTHER SVS 146,339.33 24,830.00 20,217.00 .00 1,090.00 .00 .0% 4257500 5258 82341 OTHER SVS .00 150,000.00 150,000.00 .00 .00 150,000.00 .0% 4257500 5258 82342 OTHER SVS .00 50,000.00 50,000.00 .00 .00 50,000.00 .0% 4257500 5258 82343 OTHER SVS .00 150,000.00 150,000.00 .00 .00 150,000.00 .0% 4257500 5258 82344 OTHER SVS .00 90,000.00 250,000.00 .00 .00 190,000.00 -24.0% TOTAL CAPITAL PROJECTS 150,336.14 464,830.00 620,217.00 1,084.00 1,090.00 690,000.00 11.3% 4258040 UTILITY UNDERGROUND 2019
4258040 5111 SALARY-FT 618.14 .00 .00 522.64 .00 .00 .0% 4258040 5116 FRINGE BEN 108.44 .00 .00 114.70 .00 .00 .0% 4258040 5117 RETIR CNTR 64.41 .00 .00 57.12 .00 .00 .0% 4258040 5258 OTHER SVS .00 101,010.00 79,009.00 .00 700.00 178,310.00 125.7% TOTAL UTILITY UNDERGROUND 20 790.99 101,010.00 79,009.00 694.46 700.00 178,310.00 125.7% TOTAL GENERAL CAPITAL PROJEC 151,127.13 655,840.00 891,711.00 180,894.92 61,790.00 868,310.00 -2.6%

Page 148 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 73 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT STREET& ALLEY REPAIRS-BURRTEC ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 4265301 ENGINEERING ADMINISTRATION
4265301 5111 SALARY-FT 8,894.39 37,180.00 37,180.00 7,698.07 37,180.00 42,330.00 13.9% 4265301 5116 FRINGE BEN 1,676.24 8,250.00 8,250.00 1,512.05 8,250.00 9,190.00 11.4% 4265301 5117 RETIR CNTR 912.87 4,070.00 4,070.00 831.01 4,070.00 5,100.00 25.3% 4265301 5707 PERSUALALC 10,380.00 12,200.00 12,200.00 12,204.00 12,200.00 11,260.00 -7.7% TOTAL ENGINEERING ADMINISTRA 21,863.50 61,700.00 61,700.00 22,245.13 61,700.00 67,880.00 10.0% 4267500 CAPITAL PROJECTS
4267500 5111 86001 SALARY-FT 3,603.24 .00 .00 .00 .00 .00 .0% 4267500 5111 86002 SALARY-FT 2,860.11 .00 .00 .00 .00 .00 .0% 4267500 5111 86003 SALARY-FT .00 .00 .00 558.67 .00 .00 .0% 4267500 5116 86001 FRINGE BEN 771.99 .00 .00 .00 .00 .00 .0% 4267500 5116 86002 FRINGE BEN 702.61 .00 .00 .00 .00 .00 .0% 4267500 5116 86003 FRINGE BEN .00 .00 .00 115.96 .00 .00 .0% 4267500 5117 86001 RETIR CNTR 375.46 .00 .00 .00 .00 .00 .0% 4267500 5117 86002 RETIR CNTR 298.02 .00 .00 .00 .00 .00 .0% 4267500 5117 86003 RETIR CNTR .00 .00 .00 60.83 .00 .00 .0% 4267500 5258 OTHER SVS .00 .00 .00 .00 .00 350,000.00 .0% 4267500 5258 86001 OTHER SVS 167,091.83 20,840.00 21,671.00 .00 .00 .00 .0% 4267500 5258 86002 OTHER SVS .00 251,140.00 251,140.00 .00 .00 251,140.00 .0% 4267500 5258 86003 OTHER SVS .00 445,000.00 445,000.00 .00 730.00 444,270.00 -.2% TOTAL CAPITAL PROJECTS 175,703.26 716,980.00 717,811.00 735.46 730.00 1,045,410.00 45.6% 4268801 STREET & ALLEY PROGRAM
4268801 5111 SALARY-FT 2,303.49 .00 .00 265.37 .00 .00 .0% 4268801 5116 FRINGE BEN 387.38 .00 .00 50.51 .00 .00 .0% 4268801 5117 RETIR CNTR 240.19 .00 .00 29.08 .00 .00 .0% 4268801 5258 OTHER SVS 1,725.00 113,830.00 111,585.00 .00 350.00 .00 .0% TOTAL STREET & ALLEY PROGRAM 4,656.06 113,830.00 111,585.00 344.96 350.00 .00 -100.0% TOTAL STREET& ALLEY REPAIRS- 202,222.82 892,510.00 891,096.00 23,325.55 62,780.00 1,113,290.00 24.9%

Page 149 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 74 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER BOND CAPITAL PROJECT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6396201 WATER BOND CP ADMINISTRATION
6396201 5427 ISSUA COST 229,637.50 .00 .00 .00 .00 .00 .0% TOTAL WATER BOND CP ADMINIST 229,637.50 .00 .00 .00 .00 .00 .0% 6396210 DEBT SERVICE-2022 WTR
6396210 5425 BND INT EX .00 .00 .00 296,808.00 .00 .00 .0% TOTAL DEBT SERVICE-2022 WTR .00 .00 .00 296,808.00 .00 .00 .0% 6397500 CAPITAL PROJECTS
6397500 5258 OTHER SVS .00 .00 .00 .00 18,540.00 3,480,320.00 .0% 6397500 5258 91006 OTHER SVS .00 .00 500,000.00 .00 .00 .00 .0% 6397500 5258 92101 OTHER SVS .00 400,000.00 400,000.00 .00 .00 400,000.00 .0% 6397500 5258 92102 OTHER SVS .00 450,000.00 450,000.00 .00 .00 450,000.00 .0% 6397500 5258 92103 OTHER SVS .00 275,000.00 275,000.00 .00 .00 275,000.00 .0% 6397500 5258 92104 OTHER SVS .00 100,000.00 100,000.00 .00 .00 100,000.00 .0% 6397500 5258 92105 OTHER SVS .00 400,000.00 400,000.00 .00 .00 400,000.00 .0% 6397500 5258 92106 OTHER SVS .00 475,000.00 475,000.00 .00 .00 475,000.00 .0% 6397500 5258 92107 OTHER SVS .00 475,000.00 475,000.00 .00 .00 475,000.00 .0% 6397500 5258 92108 OTHER SVS .00 400,000.00 400,000.00 .00 .00 400,000.00 .0% 6397500 5258 92109 OTHER SVS .00 361,000.00 361,000.00 .00 .00 361,000.00 .0% 6397500 5258 92131 OTHER SVS .00 301,000.00 301,000.00 .00 .00 301,000.00 .0% 6397500 5258 92132 OTHER SVS .00 72,000.00 72,000.00 .00 .00 72,000.00 .0% 6397500 5258 92133 OTHER SVS .00 200,000.00 200,000.00 .00 .00 200,000.00 .0% 6397500 5258 92134 OTHER SVS .00 62,000.00 62,000.00 .00 .00 62,000.00 .0% 6397500 5258 92135 OTHER SVS .00 56,000.00 56,000.00 .00 .00 56,000.00 .0% 6397500 5258 92136 OTHER SVS .00 41,000.00 41,000.00 .00 .00 41,000.00 .0% 6397500 5258 92137 OTHER SVS .00 450,000.00 450,000.00 .00 .00 450,000.00 .0% 6397500 5258 92138 OTHER SVS .00 21,000.00 21,000.00 .00 .00 21,000.00 .0% 6397500 5258 92151 OTHER SVS .00 52,000.00 52,000.00 .00 .00 .00 -100.0% 6397500 5258 92152 OTHER SVS .00 258,000.00 258,000.00 .00 .00 .00 -100.0% TOTAL CAPITAL PROJECTS .00 4,849,000.00 5,349,000.00 .00 18,540.00 8,019,320.00 49.9% 6399081 RESERVOIR 16 REPAIRS
6399081 5258 OTHER SVS .00 .00 945,500.00 .00 .00 945,500.00 .0% TOTAL RESERVOIR 16 REPAIRS .00 .00 945,500.00 .00 .00 945,500.00 .0% TOTAL WATER BOND CAPITAL PRO 229,637.50 4,849,000.00 6,294,500.00 296,808.00 18,540.00 8,964,820.00 42.4%

Page 150 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 75 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6405202 NPDES
6405202 5251 LEGAL SVS 260.00 .00 .00 142.70 .00 .00 .0% TOTAL NPDES 260.00 .00 .00 142.70 .00 .00 .0% 6406201 WATER ADMINISTRATION
6406201 5110 BUY BACKS .00 14,410.00 14,410.00 .00 14,410.00 43,200.00 199.8% 6406201 5111 SALARY-FT 532,502.03 681,490.00 657,562.00 502,992.64 657,562.00 748,950.00 13.9% 6406201 5112 SALARY-PT 5,617.39 11,740.00 11,740.00 5,210.41 11,740.00 12,200.00 3.9% 6406201 5113 OVERTIME 5.17 .00 .00 274.10 300.00 300.00 .0% 6406201 5116 FRINGE BEN 101,830.86 154,480.00 147,345.00 109,993.26 147,345.00 201,480.00 36.7% 6406201 5117 RETIR CNTR 49,221.67 68,250.00 65,017.00 47,536.24 65,017.00 81,680.00 25.6% 6406201 5211 POSTAGE 8.06 100.00 100.00 .00 100.00 100.00 .0% 6406201 5212 ADVERTISNG 158.89 250.00 250.00 254.62 260.00 260.00 4.0% 6406201 5213 DUES&SUBSC .00 1,000.00 1,000.00 5,495.00 1,500.00 1,500.00 50.0% 6406201 5215 TRNG/CONF 1,742.10 1,500.00 1,500.00 1,049.26 1,000.00 1,780.00 18.7% 6406201 5216 OFFIC SUPP 442.61 1,500.00 1,500.00 .00 1,000.00 1,000.00 -33.3% 6406201 5217 OTHER SUPP .00 1,500.00 1,500.00 200.17 1,500.00 500.00 -66.7% 6406201 5218 UNIFRM EXP 5,045.93 2,000.00 2,000.00 1,008.48 2,000.00 2,000.00 .0% 6406201 5219 PERM/LC/FE 50.00 .00 .00 .00 500.00 500.00 .0% 6406201 5220 FUEL USAGE 159.51 1,000.00 1,000.00 292.38 1,000.00 1,000.00 .0% 6406201 5222 PRNT/MAIL 127.15 .00 .00 .00 .00 .00 .0% 6406201 5226 TEAM BLDG .00 .00 .00 .00 .00 2,800.00 .0% 6406201 5232 COMP EQUIP .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 6406201 5237 UTL-SWR .00 .00 .00 2.20 .00 .00 .0% 6406201 5242 UTL-GAS 1,467.86 1,000.00 1,000.00 2,851.18 3,190.00 3,500.00 250.0% 6406201 5243 UTL-TELEPH 120.37 .00 .00 110.00 140.00 200.00 .0% 6406201 5244 UTL-WATER 1,116,276.00 98,920.00 98,920.00 16,057.49 25,000.00 98,920.00 .0% 6406201 5251 LEGAL SVS 22,409.74 70,000.00 70,000.00 35,245.00 70,000.00 70,000.00 .0% 6406201 5252 PROF SVS 13,885.73 10,870.00 18,167.00 7,297.01 14,870.00 40,250.00 121.6% 6406201 5253 CONTRC SVS 38,084.37 50,000.00 84,296.00 57,395.12 50,000.00 53,300.00 -36.8% 6406201 5255 BANKNG SVS .00 .00 .00 6.39 4,000.00 4,000.00 .0% 6406201 5258 OTHER SVS 3,977.00 25,000.00 25,000.00 11,847.00 34,780.00 7,280.00 -70.9% 6406201 5283 DEPR-M&EQP 78,624.83 .00 .00 .00 .00 .00 .0% 6406201 5284 DEPR-VEH 191,008.51 .00 .00 .00 .00 .00 .0% 6406201 5290 LATE CHARG 8.37 .00 .00 .00 .00 .00 .0% 6406201 5291 BAD DB EXP 51,956.11 .00 .00 .00 .00 .00 .0% 6406201 5292 ADM SV EXP 1,727,000.00 1,727,000.00 1,727,000.00 1,727,000.00 1,727,000.00 1,727,000.00 .0% 6406201 5324 OPEB 88,762.00 .00 .00 .00 .00 .00 .0% 6406201 5325 PEN EXP 381,735.07 .00 .00 .00 .00 .00 .0% 6406201 5424 BND PRNCPL .00 344,000.00 344,000.00 .00 344,000.00 344,000.00 .0%

Page 151 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 76 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6406201 5425 BND INT EX 19,401.60 12,940.00 12,940.00 25,600.31 12,940.00 30,000.00 131.8% 6406201 5427 ISSUA COST 100,138.25 .00 .00 .00 .00 .00 .0% 6406201 5529 BLD IMP .00 .00 .00 .00 .00 25,000.00 .0% 6406201 5531 VEHICLES .00 .00 .00 .00 .00 53,500.00 .0% 6406201 5701 INFO SYS 204,420.00 167,850.00 167,850.00 167,856.00 167,850.00 152,140.00 -9.4% 6406201 5702 FLT-MT&RP 10,320.00 6,790.00 6,790.00 6,792.00 6,790.00 11,930.00 75.7% 6406201 5704 BDG MT ALC 48,890.00 21,690.00 21,690.00 21,696.00 21,690.00 27,560.00 27.1% 6406201 5705 SF LIAB 646,180.00 752,410.00 752,410.00 752,424.00 752,410.00 727,280.00 -3.3% 6406201 5706 OPB&BN ALC 148,740.00 109,610.00 109,610.00 109,608.00 109,610.00 108,260.00 -1.2% 6406201 5707 PERSUALALC 779,760.00 .00 .00 .00 .00 .00 .0% TOTAL WATER ADMINISTRATION 6,370,077.18 4,339,300.00 4,346,597.00 3,616,094.26 4,251,504.00 4,585,370.00 5.5% 6406202 CUSTOMER SERVICE
6406202 5110 BUY BACKS 1,775.03 .00 .00 1,854.90 .00 .00 .0% 6406202 5111 SALARY-FT 68,091.94 76,850.00 76,850.00 56,306.47 76,850.00 84,680.00 10.2% 6406202 5113 OVERTIME 589.82 830.00 830.00 525.41 830.00 830.00 .0% 6406202 5116 FRINGE BEN 13,000.42 21,150.00 21,150.00 13,541.41 21,150.00 22,890.00 8.2% 6406202 5117 RETIR CNTR 6,821.86 8,400.00 8,400.00 5,988.31 8,400.00 10,190.00 21.3% 6406202 5211 POSTAGE .00 72,000.00 72,000.00 .00 72,000.00 72,000.00 .0% 6406202 5212 ADVERTISNG .00 .00 .00 763.86 .00 800.00 .0% 6406202 5216 OFFIC SUPP .00 2,500.00 2,500.00 .00 2,500.00 500.00 -80.0% 6406202 5217 OTHER SUPP 263.55 650.00 650.00 700.38 820.00 .00 -100.0% 6406202 5218 UNIFRM EXP 1,719.05 .00 .00 2,830.52 .00 1,220.00 .0% 6406202 5220 FUEL USAGE .00 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0% 6406202 5231 FURN&OFFC .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 6406202 5251 LEGAL SVS .00 .00 .00 109.20 .00 .00 .0% 6406202 5258 OTHER SVS 204.67 .00 .00 .00 .00 .00 .0% 6406202 5701 INFO SYS 27,970.00 28,500.00 28,500.00 28,500.00 28,500.00 13,020.00 -54.3% 6406202 5702 FLT-MT&RP 1,190.00 1,930.00 1,930.00 1,932.00 1,930.00 .00 .0% TOTAL CUSTOMER SERVICE 121,626.34 216,010.00 216,010.00 113,052.46 216,180.00 209,330.00 -3.1% 6406203 METER SERVICES
6406203 5111 SALARY-FT 145,810.10 227,980.00 227,980.00 122,503.43 227,980.00 243,700.00 6.9% 6406203 5113 OVERTIME 18,102.22 16,000.00 16,000.00 3,900.02 5,200.00 6,000.00 -62.5% 6406203 5116 FRINGE BEN 41,913.54 75,440.00 75,440.00 32,240.98 75,440.00 80,910.00 7.3% 6406203 5117 RETIR CNTR 14,148.57 24,690.00 24,690.00 12,690.31 24,690.00 28,930.00 17.2% 6406203 5215 TRNG/CONF 400.00 5,000.00 5,000.00 2,828.44 2,700.00 5,000.00 .0% 6406203 5217 OTHER SUPP 79,776.42 101,500.00 101,500.00 8.61 81,500.00 101,500.00 .0% 6406203 5218 UNIFRM EXP 1,813.55 .00 .00 3,871.86 3,780.00 3,800.00 .0% 6406203 5220 FUEL USAGE 7,660.90 5,000.00 5,000.00 6,166.39 8,700.00 9,300.00 86.0%

Page 152 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 77 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6406203 5233 OTHR EQUIP 652,253.79 900,000.00 900,000.00 820,381.56 800,000.00 1,000,000.00 11.1% 6406203 5258 OTHER SVS 57,325.94 53,000.00 53,000.00 69,260.00 68,000.00 83,000.00 56.6% 6406203 5530 MACH&EQUIP .00 .00 .00 35,530.00 35,600.00 .00 .0% 6406203 5531 VEHICLES .00 58,250.00 211,750.00 134,371.35 211,750.00 .00 .0% 6406203 5600 CONTR FA .00 .00 .00 -65,972.39 .00 .00 .0% 6406203 5701 INFO SYS 500.00 500.00 500.00 504.00 500.00 .00 .0% 6406203 5702 FLT-MT&RP 5,530.00 5,870.00 5,870.00 5,868.00 5,870.00 12,220.00 108.2% TOTAL METER SERVICES 1,025,235.03 1,473,230.00 1,626,730.00 1,184,152.56 1,551,710.00 1,574,360.00 -3.2% 6406204 DAMAGE TO CITY PROPERTY
6406204 5258 OTHER SVS .00 .00 .00 3,000.00 .00 .00 .0% TOTAL DAMAGE TO CITY PROPERT .00 .00 .00 3,000.00 .00 .00 .0% 6406205 PRODUCTION/STORAGE
6406205 5110 BUY BACKS 8,374.53 .00 .00 10,698.57 .00 .00 .0% 6406205 5111 SALARY-FT 355,206.83 536,470.00 536,470.00 349,402.11 536,470.00 628,710.00 17.2% 6406205 5112 SALARY-PT 12,672.21 27,470.00 27,470.00 3,709.02 27,470.00 30,640.00 11.5% 6406205 5113 OVERTIME 43,634.98 45,000.00 45,000.00 45,729.80 45,000.00 52,000.00 15.6% 6406205 5116 FRINGE BEN 73,607.05 126,000.00 126,000.00 79,317.98 126,000.00 150,370.00 19.3% 6406205 5117 RETIR CNTR 34,053.83 54,820.00 54,820.00 34,344.09 54,820.00 69,080.00 26.0% 6406205 5211 POSTAGE 295.39 350.00 350.00 193.98 450.00 500.00 42.9% 6406205 5213 DUES&SUBSC 302.00 300.00 300.00 .00 300.00 4,000.00 1233.3% 6406205 5215 TRNG/CONF 2,243.73 9,130.00 9,130.00 8,718.50 6,630.00 9,130.00 .0% 6406205 5216 OFFIC SUPP 169.92 800.00 800.00 800.00 800.00 500.00 -37.5% 6406205 5217 OTHER SUPP 137,497.09 387,300.00 387,300.00 237,139.60 386,800.00 416,500.00 7.5% 6406205 5218 UNIFRM EXP 3,876.57 4,900.00 4,900.00 6,125.69 7,000.00 7,800.00 59.2% 6406205 5219 PERM/LC/FE 84,151.43 91,000.00 91,000.00 95,897.69 96,500.00 103,000.00 13.2% 6406205 5220 FUEL USAGE 28,549.57 26,500.00 26,500.00 27,772.10 35,000.00 37,000.00 39.6% 6406205 5222 PRINTING 3,185.20 2,900.00 2,900.00 .00 2,900.00 2,900.00 .0% 6406205 5231 FURN&OFFC 640.74 750.00 750.00 237.04 950.00 950.00 26.7% 6406205 5232 COMP EQUIP 3,042.23 11,600.00 11,600.00 11,600.00 11,600.00 11,600.00 .0% 6406205 5233 OTHR EQUIP 10,722.98 13,750.00 13,750.00 12,999.08 13,000.00 32,750.00 138.2% 6406205 5234 OTH EQ RNT 9,089.10 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 .0% 6406205 5236 RENT 57,304.80 59,000.00 59,000.00 59,000.00 62,000.00 70,000.00 18.6% 6406205 5241 UTL-ELECTR 1,496,037.42 1,400,000.00 1,400,000.00 1,032,667.48 1,400,000.00 1,491,000.00 6.5% 6406205 5244 UTL-WATER 9,087,087.39 12,229,830.00 12,229,830.00 12,228,206.09 12,969,100.00 12,970,600.00 6.1% 6406205 5246 MAINT-EQP 28,468.93 .00 .00 3,600.00 3,600.00 6,000.00 .0% 6406205 5248 MAINT-OTHR 43,396.12 80,720.00 80,720.00 88,655.00 76,720.00 96,800.00 19.9% 6406205 5251 LEGAL SVS 65.00 .00 .00 .00 .00 .00 .0% 6406205 5254 DATA P SVS 12,015.79 8,800.00 8,800.00 8,656.31 9,000.00 9,000.00 2.3%

Page 153 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 78 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6406205 5258 OTHER SVS 78,995.87 439,200.00 439,200.00 412,213.05 619,800.00 626,000.00 42.5% 6406205 5259 RECYCL WTR 1,289,245.32 1,341,500.00 1,341,500.00 1,341,500.00 1,507,420.00 1,685,390.00 25.6% 6406205 5288 DEPR-RESER 738,484.81 .00 .00 .00 .00 .00 .0% 6406205 5290 LATE CHARG 3,414.02 .00 .00 31.80 .00 .00 .0% 6406205 5304 CONTRIBUTN 296,830.47 777,000.00 777,000.00 777,000.00 777,000.00 777,000.00 .0% 6406205 5530 MACH&EQUIP 57,310.46 6,000.00 6,000.00 39,336.21 39,400.00 20,000.00 233.3% 6406205 5600 CONTR FA -174,451.12 .00 .00 -124,137.74 .00 .00 .0% 6406205 5701 INFO SYS 15,100.00 18,630.00 18,630.00 18,636.00 18,630.00 35,270.00 89.3% 6406205 5702 FLT-MT&RP 27,740.00 22,550.00 22,550.00 22,548.00 22,550.00 30,330.00 34.5% 6406205 5704 BDG MT ALC 85,000.00 110,000.00 110,000.00 110,004.00 110,000.00 40,000.00 -63.6% TOTAL PRODUCTION/STORAGE 13,953,360.66 17,847,270.00 17,847,270.00 16,957,601.45 18,981,910.00 19,429,820.00 8.9% 6406206 TRANSMISSION & DISTRIBUTION
6406206 5110 BUY BACKS 5,196.27 .00 .00 6,376.32 .00 .00 .0% 6406206 5111 SALARY-FT 827,607.57 1,043,670.00 1,043,670.00 649,633.73 1,043,670.00 1,105,650.00 5.9% 6406206 5113 OVERTIME 58,047.80 75,000.00 75,000.00 76,671.73 94,100.00 100,000.00 33.3% 6406206 5116 FRINGE BEN 174,619.18 293,030.00 293,030.00 129,797.87 293,030.00 316,370.00 8.0% 6406206 5117 RETIR CNTR 80,549.81 110,520.00 110,520.00 64,971.90 110,520.00 127,070.00 15.0% 6406206 5213 DUES&SUBSC 495.00 500.00 500.00 .00 500.00 500.00 .0% 6406206 5215 TRNG/CONF 5,309.22 5,000.00 5,000.00 7,704.96 5,120.00 36,620.00 632.4% 6406206 5216 OFFIC SUPP 255.32 2,500.00 2,500.00 2,571.10 2,500.00 500.00 -80.0% 6406206 5217 OTHER SUPP 346,539.58 506,900.00 506,900.00 513,819.57 544,900.00 567,000.00 11.9% 6406206 5218 UNIFRM EXP 17,394.18 .00 .00 26,974.86 29,000.00 31,100.00 .0% 6406206 5219 PERM/LC/FE .00 .00 .00 53.00 200.00 200.00 .0% 6406206 5220 FUEL USAGE 49,627.39 30,000.00 30,000.00 36,957.49 60,000.00 60,000.00 100.0% 6406206 5231 FURN&OFFC 322.06 .00 .00 .00 .00 .00 .0% 6406206 5232 COMP EQUIP 403.98 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 6406206 5233 OTHR EQUIP 6,309.34 10,000.00 10,000.00 36,586.35 18,400.00 22,100.00 121.0% 6406206 5234 OTH EQ RNT 3,516.67 3,000.00 3,000.00 .00 .00 .00 .0% 6406206 5246 MAINT-EQP 99.00 .00 .00 .00 .00 .00 .0% 6406206 5247 MAINT-VEH .00 .00 .00 6,798.50 .00 .00 .0% 6406206 5248 MAINT-OTHR 14,192.00 40,000.00 40,000.00 35,000.00 35,000.00 40,000.00 .0% 6406206 5253 CONTRC SVS 223,024.50 325,000.00 325,000.00 200,000.00 275,000.00 275,000.00 -15.4% 6406206 5258 OTHER SVS 39,723.00 13,400.00 13,400.00 5,160.00 5,100.00 3,500.00 -73.9% 6406206 5287 DEPR-PIPE 879,448.32 .00 .00 .00 .00 .00 .0% 6406206 5289 DEPR-TRTMT 326,471.35 .00 .00 .00 .00 .00 .0% 6406206 5290 LATE CHARG .00 .00 .00 28.17 .00 .00 .0% 6406206 5298 LOSS-CAP A 139,976.00 .00 .00 .00 .00 .00 .0% 6406206 5529 BLD IMP .00 .00 .00 .00 .00 80,000.00 .0% 6406206 5530 MACH&EQUIP .00 10,000.00 10,000.00 .00 10,000.00 10,000.00 .0% 6406206 5531 VEHICLES 292,970.94 205,000.00 392,012.00 392,012.38 392,013.00 53,500.00 -86.4% 6406206 5600 CONTR FA -292,710.94 .00 .00 -136,052.17 .00 .00 .0%

Page 154 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 79 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6406206 5701 INFO SYS 200.00 400.00 400.00 396.00 400.00 25,490.00 6272.5% 6406206 5702 FLT-MT&RP 96,600.00 76,140.00 76,140.00 76,140.00 76,140.00 121,760.00 59.9% TOTAL TRANSMISSION & DISTRIB 3,296,187.54 2,755,060.00 2,942,072.00 2,131,601.76 3,000,593.00 2,981,360.00 1.3% 6406207 WECWC MANAGEMENT CONTROL
6406207 5110 BUY BACKS 181.94 .00 .00 .00 .00 .00 .0% 6406207 5111 SALARY-FT 64,960.24 74,780.00 74,780.00 67,694.80 74,780.00 88,080.00 17.8% 6406207 5113 OVERTIME 13,605.66 13,000.00 13,000.00 12,475.33 14,000.00 21,000.00 61.5% 6406207 5116 FRINGE BEN 14,499.07 17,900.00 17,900.00 16,065.46 17,900.00 21,500.00 20.1% 6406207 5117 RETIR CNTR 5,144.60 7,680.00 7,680.00 5,770.22 7,680.00 9,760.00 27.1% 6406207 5215 TRNG/CONF .00 1,000.00 1,000.00 .00 1,000.00 500.00 -50.0% 6406207 5217 OTHER SUPP .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 6406207 5219 PERM/LC/FE 1,812.56 30.00 30.00 .00 1,820.00 1,830.00 6000.0% 6406207 5233 OTHR EQUIP .00 .00 .00 1,299.47 .00 .00 .0% 6406207 5244 UTL-WATER 38,072.64 .00 .00 2,085.39 .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 95.00 .00 .00 .00 .00 .00 .0% 6406207 5258 OTHER SVS 728.20 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% TOTAL WECWC MANAGEMENT CONTR 139,099.91 119,390.00 119,390.00 105,390.67 122,180.00 147,670.00 23.7% 6406208 CONSERVATION
6406208 5111 SALARY-FT 41,765.37 84,280.00 84,280.00 60,647.85 84,280.00 92,960.00 10.3% 6406208 5113 OVERTIME 5.02 .00 .00 25.07 .00 .00 .0% 6406208 5116 FRINGE BEN 7,691.62 27,870.00 27,870.00 12,666.40 27,870.00 30,700.00 10.2% 6406208 5117 RETIR CNTR 4,258.50 9,210.00 9,210.00 6,615.57 9,210.00 11,180.00 21.4% 6406208 5211 POSTAGE 5,369.93 23,000.00 23,000.00 6,031.12 23,000.00 23,000.00 .0% 6406208 5212 ADVERTISNG .00 19,700.00 19,700.00 .00 19,700.00 19,700.00 .0% 6406208 5213 DUES&SUBSC 1,869.40 5,900.00 5,900.00 1,894.40 5,900.00 5,770.00 -2.2% 6406208 5215 TRNG/CONF 874.00 5,500.00 5,500.00 1,346.28 5,500.00 5,500.00 .0% 6406208 5216 OFFIC SUPP 616.66 2,200.00 2,200.00 515.31 2,200.00 2,000.00 -9.1% 6406208 5217 OTHER SUPP 20,341.21 28,000.00 28,000.00 5,849.60 28,000.00 28,000.00 .0% 6406208 5218 UNIFRM EXP 204.73 1,000.00 1,000.00 .00 1,000.00 250.00 -75.0% 6406208 5222 PRINTING 791.02 12,000.00 12,000.00 127.14 12,000.00 12,000.00 .0% 6406208 5231 FURN&OFFC .00 .00 .00 .00 .00 200.00 .0% 6406208 5233 OTHR EQUIP 181.92 .00 .00 .00 .00 .00 .0% 6406208 5234 OTH EQ RNT .00 1,000.00 1,000.00 157.44 1,000.00 1,000.00 .0% 6406208 5253 CONTRC SVS .00 38,000.00 38,000.00 .00 38,000.00 38,000.00 .0% 6406208 5258 OTHER SVS 15,468.85 21,080.00 21,080.00 17,343.00 21,380.00 21,380.00 1.4% 6406208 5294 SPONSOR .00 5,200.00 5,200.00 500.00 5,200.00 5,200.00 .0% 6406208 5530 MACH&EQUIP .00 .00 .00 4,954.89 .00 .00 .0%

Page 155 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 80 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6406208 5600 CONTR FA .00 .00 .00 -4,954.89 .00 .00 .0% 6406208 5701 INFO SYS 200.00 200.00 200.00 204.00 200.00 .00 .0% TOTAL CONSERVATION 99,638.23 284,140.00 284,140.00 113,923.18 284,440.00 296,840.00 4.5% 6406210 DEBT SERVICE
6406210 5252 PROF SVS 2,000.00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 6406210 5255 BANKNG SVS .00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 .0% 6406210 5424 BND PRNCPL .00 870,000.00 870,000.00 .00 870,000.00 890,000.00 2.3% 6406210 5425 BND INT EX 152,649.91 394,920.00 394,920.00 98,107.50 394,920.00 375,620.00 -4.9% TOTAL DEBT SERVICE 154,649.91 1,268,920.00 1,268,920.00 100,107.50 1,268,920.00 1,269,620.00 .1% 6406211 STORM WATER MGMT & RECHARGE
6406211 5111 SALARY-FT 188,372.13 188,610.00 188,610.00 127,968.42 188,610.00 205,030.00 8.7% 6406211 5113 OVERTIME 103.94 .00 .00 3,322.39 3,400.00 3,500.00 .0% 6406211 5116 FRINGE BEN 42,184.64 53,520.00 53,520.00 28,475.73 53,520.00 60,330.00 12.7% 6406211 5117 RETIR CNTR 18,742.05 20,040.00 20,040.00 13,055.03 20,040.00 23,660.00 18.1% 6406211 5215 TRNG/CONF .00 600.00 600.00 933.24 1,000.00 1,800.00 200.0% 6406211 5217 OTHER SUPP .00 20,000.00 20,000.00 379.95 20,000.00 20,000.00 .0% 6406211 5219 PERM/LC/FE 39,300.15 90,260.00 90,260.00 75,585.00 80,600.00 175,000.00 93.9% 6406211 5251 LEGAL SVS .00 15,000.00 15,000.00 .00 15,000.00 15,000.00 .0% 6406211 5258 OTHER SVS 2,250.00 80,000.00 80,000.00 .00 301,000.00 311,000.00 288.8% 6406211 5701 INFO SYS 2,220.00 2,220.00 2,220.00 2,220.00 2,220.00 8,590.00 286.9% TOTAL STORM WATER MGMT & REC 293,172.91 470,250.00 470,250.00 251,939.76 685,390.00 823,910.00 75.2% 6406212 PVPA
6406212 5111 SALARY-FT 10,960.59 .00 .00 14,320.02 .00 .00 .0% 6406212 5113 OVERTIME 389.04 400.00 400.00 5,505.84 1,800.00 2,000.00 400.0% 6406212 5116 FRINGE BEN 2,259.26 .00 .00 3,672.64 .00 .00 .0% 6406212 5117 RETIR CNTR 1,142.82 .00 .00 1,582.77 .00 .00 .0% 6406212 5217 OTHER SUPP 882.54 2,500.00 2,500.00 565.53 1,500.00 1,500.00 -40.0% 6406212 5219 PERM/LC/FE .00 .00 .00 5.00 .00 .00 .0% 6406212 5233 OTHR EQUIP 1,754.69 .00 .00 369.28 1,000.00 1,000.00 .0% TOTAL PVPA 17,388.94 2,900.00 2,900.00 26,021.08 4,300.00 4,500.00 55.2% 6406213 CUSTOMER SVC - FINANCE
6406213 5111 SALARY-FT 132,527.04 165,160.00 165,160.00 120,931.09 138,230.00 237,540.00 43.8%

Page 156 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 81 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6406213 5112 SALARY-PT 1,746.28 .00 .00 5,609.12 4,260.00 .00 .0% 6406213 5113 OVERTIME 4,268.80 15,600.00 15,600.00 1,270.13 2,000.00 15,600.00 .0% 6406213 5116 FRINGE BEN 30,321.31 50,540.00 50,540.00 30,328.65 32,960.00 76,690.00 51.7% 6406213 5117 RETIR CNTR 13,227.01 18,040.00 18,040.00 12,609.50 14,360.00 28,560.00 58.3% 6406213 5211 POSTAGE 25,227.68 25,000.00 25,000.00 25,000.00 25,000.00 38,000.00 52.0% 6406213 5215 TRNG/CONF .00 5,630.00 5,630.00 .00 .00 5,630.00 .0% 6406213 5216 OFFIC SUPP 1,801.62 2,000.00 2,000.00 2,000.00 2,000.00 4,000.00 100.0% 6406213 5218 UNIFRM EXP .00 3,850.00 3,850.00 149.66 370.00 1,500.00 -61.0% 6406213 5231 FURN&OFFC .00 530.00 530.00 .00 .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,500.00 25.0% 6406213 5255 BANKNG SVS 123,371.10 102,000.00 102,000.00 104,182.14 102,000.00 133,500.00 30.9% 6406213 5258 OTHER SVS 11,708.30 60,840.00 60,840.00 16,240.00 12,000.00 64,800.00 6.5% 6406213 5701 INFO SYS 27,390.00 32,110.00 32,110.00 32,112.00 32,110.00 32,630.00 1.6% TOTAL CUSTOMER SVC - FINANCE 373,452.58 483,300.00 483,300.00 352,432.29 367,290.00 641,480.00 32.7% 6407500 CAPITAL PROJECTS
6407500 5252 91005 PROF SVS .00 .00 .00 439,878.00 .00 .00 .0% 6407500 5258 OTHER SVS .00 .00 .00 .00 .00 3,313,000.00 .0% 6407500 5258 91001 OTHER SVS .00 47,990.00 47,990.00 .00 .00 100,000.00 108.4% 6407500 5258 91002 OTHER SVS .00 275,000.00 275,000.00 .00 .00 .00 -100.0% 6407500 5258 91003 OTHER SVS .00 145,000.00 145,000.00 .00 .00 300,000.00 106.9% 6407500 5258 91004 OTHER SVS .00 129,920.00 62,359.00 .00 .00 62,360.00 .0% 6407500 5258 91005 OTHER SVS .00 300,000.00 439,878.00 .00 19,060.00 420,820.00 -4.3% 6407500 5258 91006 OTHER SVS .00 106,000.00 106,000.00 12,000.00 5,300.00 100,700.00 -5.0% 6407500 5258 91008 OTHER SVS .00 104,000.00 104,000.00 15,000.00 5,550.00 98,450.00 -5.3% 6407500 5258 91009 OTHER SVS .00 175,000.00 175,000.00 .00 .00 275,000.00 57.1% 6407500 5258 91010 OTHER SVS .00 175,000.00 175,000.00 .00 .00 275,000.00 57.1% 6407500 5258 91011 OTHER SVS .00 150,000.00 150,000.00 .00 .00 200,000.00 33.3% 6407500 5258 91026 OTHER SVS .00 .00 150,000.00 150,000.00 .00 .00 .0% 6407500 5258 91030 OTHER SVS .00 .00 102,040.00 102,040.00 .00 .00 .0% 6407500 5530 91004 MACH&EQUIP 117,140.66 .00 .00 .00 .00 .00 .0% TOTAL CAPITAL PROJECTS 117,140.66 1,607,910.00 1,932,267.00 718,918.00 29,910.00 5,145,330.00 166.3% 6409048 RSRV 16 STRCTRL EVAL
6409048 5258 OTHER SVS .00 15,230.00 15,230.00 .00 .00 15,230.00 .0% 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 4,395.69 60,600.00 60,600.00 .00 .00 210,600.00 247.5%

Page 157 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 82 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL CW LAT REPLC- ANNUAL 4,395.69 60,600.00 60,600.00 .00 .00 210,600.00 247.5% 6409050 CW HYDRANT REPLC- ANNUAL
6409050 5258 OTHER SVS .00 75,000.00 75,000.00 .00 .00 225,000.00 200.0% TOTAL CW HYDRANT REPLC- ANNU .00 75,000.00 75,000.00 .00 .00 225,000.00 200.0% 6409052 WST TO DRN DISCH LINES
6409052 5258 OTHER SVS .00 50,000.00 .00 .00 .00 50,000.00 .0% TOTAL WST TO DRN DISCH LINES .00 50,000.00 .00 .00 .00 50,000.00 .0% 6409065 RTRFT DSGNS PH 1 RCYCL WTR USR
6409065 5258 OTHER SVS .00 .00 3,840.00 .00 .00 .00 .0% TOTAL RTRFT DSGNS PH 1 RCYCL .00 .00 3,840.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 225,000.00 225,000.00 .00 .00 225,000.00 .0% TOTAL PLANT 3 BOOSTER UPGRAD .00 225,000.00 225,000.00 .00 .00 225,000.00 .0% 6409087 PRV STNS- ZNS 5/4 & 4/3
6409087 5258 OTHER SVS .00 104,360.00 4,360.00 .00 .00 4,360.00 .0% TOTAL PRV STNS- ZNS 5/4 & 4/ .00 104,360.00 4,360.00 .00 .00 4,360.00 .0% 6409122 13TH ST RECONST- EUCLID-CAMPUS
6409122 5111 SALARY-FT 7,497.25 .00 .00 29.37 .00 .00 .0% 6409122 5113 OVERTIME 616.26 .00 .00 .00 .00 .00 .0% 6409122 5116 FRINGE BEN 1,643.41 .00 .00 6.36 .00 .00 .0%

Page 158 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 83 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6409122 5117 RETIR CNTR 781.26 .00 .00 3.22 .00 .00 .0% 6409122 5258 OTHER SVS 749,670.57 134,800.00 133,291.00 .00 40.00 .00 .0% 6409122 5600 CONTR FA -737,679.93 .00 .00 .00 .00 .00 .0% TOTAL 13TH ST RECONST- EUCLI 22,528.82 134,800.00 133,291.00 38.95 40.00 .00 -100.0% 6409124 ARRW HWY REHAB (MNT TO SA)
6409124 5111 SALARY-FT 3,159.84 .00 .00 4,822.00 .00 .00 .0% 6409124 5116 FRINGE BEN 583.74 .00 .00 1,043.07 .00 .00 .0% 6409124 5117 RETIR CNTR 329.59 .00 .00 528.49 .00 .00 .0% 6409124 5258 OTHER SVS .00 450,790.00 449,995.00 .00 .00 .00 -100.0% 6409124 5600 CONTR FA -4,073.17 .00 .00 .00 .00 .00 .0% TOTAL ARRW HWY REHAB (MNT TO .00 450,790.00 449,995.00 6,393.56 .00 .00 -100.0% 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 31,898.27 .00 .00 29,680.74 .00 .00 .0% 6409128 5113 OVERTIME .00 .00 .00 185.13 .00 .00 .0% 6409128 5116 FRINGE BEN 6,126.23 .00 .00 6,136.98 .00 .00 .0% 6409128 5117 RETIR CNTR 3,327.01 .00 .00 3,251.86 .00 .00 .0% 6409128 5211 POSTAGE 9.64 .00 .00 .00 .00 .00 .0% 6409128 5217 OTHER SUPP 5,667.33 .00 .00 2,044.00 .00 .00 .0% 6409128 5258 OTHER SVS 8,028,556.52 1,127,000.00 1,127,000.00 4,801,367.45 2,910,560.00 216,440.00 -80.8% 6409128 5600 CONTR FA -8,075,585.00 .00 .00 .00 .00 .00 .0% TOTAL WTR RSRV RPLC 17TH & B .00 1,127,000.00 1,127,000.00 4,842,666.16 2,910,560.00 216,440.00 -80.8% 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 .00 120,000.00 .00 .00 .00 .0%

Page 159 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 84 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL WATER CONS LNDSCP MOD .00 .00 120,000.00 .00 .00 .00 -100.0% 6409134 RESERVOIR 15 ENH 17th & BENSON
6409134 5111 SALARY-FT .00 .00 .00 174.59 .00 .00 .0% 6409134 5116 FRINGE BEN .00 .00 .00 36.25 .00 .00 .0% 6409134 5117 RETIR CNTR .00 .00 .00 19.01 .00 .00 .0% 6409134 5217 OTHER SUPP .00 .00 .00 8,350.02 .00 .00 .0% 6409134 5258 OTHER SVS .00 101,060.00 101,060.00 .00 8,580.00 92,480.00 -8.5% TOTAL RESERVOIR 15 ENH 17th .00 101,060.00 101,060.00 8,579.87 8,580.00 92,480.00 -8.5% 6409135 PLANT 6 MOTOR CONTROL CTR-15TH
6409135 5258 OTHER SVS 51,296.49 93,230.00 156,635.00 .00 114,700.00 41,940.00 -73.2% 6409135 5530 MACH&EQUIP 45,468.64 .00 .00 114,698.81 .00 .00 .0% 6409135 5600 CONTR FA -96,765.13 .00 .00 -65,426.90 .00 .00 .0% TOTAL PLANT 6 MOTOR CONTROL .00 93,230.00 156,635.00 49,271.91 114,700.00 41,940.00 -73.2% 6409136 PLANT 3 BOOSTR INSTALL PUMP&MO
6409136 5258 OTHER SVS .00 125,000.00 125,000.00 .00 .00 125,000.00 .0% TOTAL PLANT 3 BOOSTR INSTALL .00 125,000.00 125,000.00 .00 .00 125,000.00 .0% 6409137 GENERATORS AT PLANT 2 - 24TH
6409137 5111 SALARY-FT 4,929.84 .00 .00 2,435.68 .00 .00 .0% 6409137 5116 FRINGE BEN 1,033.08 .00 .00 507.87 .00 .00 .0% 6409137 5117 RETIR CNTR 513.84 .00 .00 266.96 .00 .00 .0% 6409137 5258 OTHER SVS 1,539.53 254,610.00 249,354.00 284.00 3,490.00 500,860.00 100.9% 6409137 5600 CONTR FA -8,016.29 .00 .00 .00 .00 .00 .0% TOTAL GENERATORS AT PLANT 2 .00 254,610.00 249,354.00 3,494.51 3,490.00 500,860.00 100.9% 6409138 GENERATORS AT PLANT 6 - 15TH
6409138 5111 SALARY-FT 5,387.48 .00 .00 2,582.57 .00 .00 .0% 6409138 5116 FRINGE BEN 1,122.70 .00 .00 539.68 .00 .00 .0% 6409138 5117 RETIR CNTR 561.55 .00 .00 283.07 .00 .00 .0% 6409138 5258 OTHER SVS 1,539.54 783,300.00 777,813.00 .00 3,400.00 1,074,410.00 38.1% 6409138 5600 CONTR FA -8,611.27 .00 .00 .00 .00 .00 .0%

Page 160 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 85 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE TOTAL GENERATORS AT PLANT 6 .00 783,300.00 777,813.00 3,405.32 3,400.00 1,074,410.00 38.1% 6409140 17TH ST WTR MAIN & SVC RPLCMNT
6409140 5111 SALARY-FT .00 .00 .00 244.42 .00 .00 .0% 6409140 5116 FRINGE BEN .00 .00 .00 46.52 .00 .00 .0% 6409140 5117 RETIR CNTR .00 .00 .00 26.78 .00 .00 .0% 6409140 5258 OTHER SVS 15,000.00 932,930.00 931,550.00 2,500.00 2,820.00 928,730.00 -.3% 6409140 5600 CONTR FA -15,000.00 .00 .00 .00 .00 .00 .0% TOTAL 17TH ST WTR MAIN & SVC .00 932,930.00 931,550.00 2,817.72 2,820.00 928,730.00 -.3% 6409141 19TH ST WTR MAIN & SVC RPLCMNT
6409141 5258 OTHER SVS .00 104,000.00 104,000.00 .00 .00 104,000.00 .0% TOTAL 19TH ST WTR MAIN & SVC .00 104,000.00 104,000.00 .00 .00 104,000.00 .0% 6409142 ARROW HWY WTR MAIN RPLCMNT
6409142 5111 SALARY-FT 3,331.00 .00 .00 5,406.24 .00 .00 .0% 6409142 5116 FRINGE BEN 588.07 .00 .00 1,146.73 .00 .00 .0% 6409142 5117 RETIR CNTR 347.67 .00 .00 592.47 .00 .00 .0% 6409142 5217 OTHER SUPP 14,012.65 .00 .00 .00 .00 .00 .0% 6409142 5258 OTHER SVS .00 380,290.00 370,709.00 .00 .00 .00 -100.0% 6409142 5600 CONTR FA -18,279.39 .00 .00 .00 .00 .00 .0% TOTAL ARROW HWY WTR MAIN RPL .00 380,290.00 370,709.00 7,145.44 .00 .00 -100.0% 6409143 MULBERRY AVE WTR MAIN RPLCMNT
6409143 5258 OTHER SVS 11,025.00 436,330.00 428,975.00 5,000.00 .00 .00 -100.0% 6409143 5600 CONTR FA -11,025.00 .00 .00 .00 .00 .00 .0% TOTAL MULBERRY AVE WTR MAIN .00 436,330.00 428,975.00 5,000.00 .00 .00 -100.0% 6409144 HUNTINGTON DR WTR MAIN RPLCMNT
6409144 5258 OTHER SVS .00 82,070.00 82,070.00 .00 .00 82,070.00 .0% TOTAL HUNTINGTON DR WTR MAIN .00 82,070.00 82,070.00 .00 .00 82,070.00 .0% 6409145 ALPINE ST WATER MAIN REPLCMNT
6409145 5111 SALARY-FT 3,327.10 .00 .00 3,163.58 .00 .00 .0%

Page 161 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 86 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6409145 5116 FRINGE BEN 648.02 .00 .00 680.25 .00 .00 .0% 6409145 5117 RETIR CNTR 346.94 .00 .00 346.75 .00 .00 .0% 6409145 5258 OTHER SVS 2,192.00 523,290.00 522,129.00 .00 4,190.00 577,940.00 10.7% 6409145 5600 CONTR FA -6,514.06 .00 .00 .00 .00 .00 .0% TOTAL ALPINE ST WATER MAIN R .00 523,290.00 522,129.00 4,190.58 4,190.00 577,940.00 10.7% 6409146 VERNON DR WTR MAIN REPLACEMENT
6409146 5111 SALARY-FT 3,349.93 .00 .00 3,183.54 .00 .00 .0% 6409146 5116 FRINGE BEN 653.15 .00 .00 684.88 .00 .00 .0% 6409146 5117 RETIR CNTR 349.30 .00 .00 348.93 .00 .00 .0% 6409146 5258 OTHER SVS 2,192.00 298,660.00 297,450.00 .00 4,220.00 336,230.00 13.0% 6409146 5600 CONTR FA -6,544.38 .00 .00 .00 .00 .00 .0% TOTAL VERNON DR WTR MAIN REP .00 298,660.00 297,450.00 4,217.35 4,220.00 336,230.00 13.0% 6409147 PALM AVE WTR MAIN REPLACEMENT
6409147 5111 SALARY-FT 3,369.28 .00 .00 3,237.00 .00 .00 .0% 6409147 5116 FRINGE BEN 648.61 .00 .00 690.52 .00 .00 .0% 6409147 5117 RETIR CNTR 351.35 .00 .00 354.78 .00 .00 .0% 6409147 5258 OTHER SVS 2,830.00 763,050.00 761,837.00 .00 4,280.00 757,560.00 -.6% 6409147 5600 CONTR FA -7,199.24 .00 .00 .00 .00 .00 .0% TOTAL PALM AVE WTR MAIN REPL .00 763,050.00 761,837.00 4,282.30 4,280.00 757,560.00 -.6% 6409148 NEW WELL CHINO BASIN & PIPELIN
6409148 5258 OTHER SVS .00 122,270.00 20,230.00 .00 .00 .00 .0% TOTAL NEW WELL CHINO BASIN & .00 122,270.00 20,230.00 .00 .00 .00 -100.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 5258 OTHER SVS .00 154,300.00 154,300.00 .00 .00 821,000.00 432.1% TOTAL GROVE AVE WATER MAIN R .00 154,300.00 154,300.00 .00 .00 821,000.00 432.1% 6409305 UPDATE SWR MODEL
6409305 5111 SALARY-FT 585.20 .00 .00 957.36 .00 .00 .0%

Page 162 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 87 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6409305 5116 FRINGE BEN 104.38 .00 .00 257.93 .00 .00 .0% 6409305 5117 RETIR CNTR 60.99 .00 .00 104.93 .00 .00 .0% TOTAL UPDATE SWR MODEL 750.57 .00 .00 1,320.22 .00 .00 .0% TOTAL WATER UTILITY 25,988,964.97 39,414,700.00 39,987,124.00 30,617,201.56 33,820,607.00 44,648,290.00 11.7%

Page 163 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 88 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SOLID WASTE UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6410000 SOLID WASTE UTILITY
6410000 5070 TRNSFR OUT 265,000.00 265,000.00 265,000.00 .00 265,000.00 265,000.00 .0% TOTAL SOLID WASTE UTILITY 265,000.00 265,000.00 265,000.00 .00 265,000.00 265,000.00 .0% 6416213 CUSTOMER SVC - FINANCE
6416213 5211 POSTAGE 20,454.89 22,000.00 22,000.00 22,000.00 22,000.00 .00 .0% 6416213 5216 OFFIC SUPP 1,460.79 2,200.00 2,200.00 2,200.00 2,200.00 .00 .0% 6416213 5218 UNIFRM EXP .00 3,850.00 3,850.00 149.67 3,850.00 .00 .0% 6416213 5234 OTH EQ RNT 1,863.43 2,000.00 2,000.00 2,000.00 2,000.00 .00 .0% 6416213 5258 OTHER SVS 9,493.16 14,070.00 14,070.00 11,000.00 14,070.00 .00 .0% TOTAL CUSTOMER SVC - FINANCE 33,272.27 44,120.00 44,120.00 37,349.67 44,120.00 .00 -100.0% 6416300 STATE GRANTS
6416300 5111 42030 SALARY-FT .00 .00 37,000.00 .00 .00 .00 .0% 6416300 5211 42030 POSTAGE .00 .00 2,500.00 .00 .00 2,500.00 .0% 6416300 5212 42030 ADVERTISNG .00 .00 14,000.00 .00 2,000.00 12,000.00 -14.3% 6416300 5215 42030 TRNG/CONF .00 .00 900.00 400.00 400.00 500.00 -44.4% 6416300 5217 42030 OTHER SUPP .00 .00 38,977.00 32,440.89 31,800.00 7,500.00 -80.8% 6416300 5258 42030 OTHER SVS .00 .00 18,300.00 1,685.00 2,800.00 15,500.00 -15.3% TOTAL STATE GRANTS .00 .00 111,677.00 34,525.89 37,000.00 38,000.00 -66.0% 6416301 SOLID WASTE
6416301 5110 BUY BACKS .00 .00 .00 .00 .00 1,900.00 .0% 6416301 5111 SALARY-FT 294,642.69 406,040.00 398,602.00 304,675.48 398,602.00 349,320.00 -12.4% 6416301 5112 SALARY-PT 4,627.95 29,120.00 29,120.00 4,517.01 29,120.00 29,640.00 1.8% 6416301 5113 OVERTIME 5.33 .00 .00 78.55 .00 .00 .0% 6416301 5116 FRINGE BEN 61,091.56 112,280.00 109,931.00 68,849.79 109,931.00 96,820.00 -11.9% 6416301 5117 RETIR CNTR 27,972.11 41,800.00 40,877.00 30,184.04 40,877.00 39,550.00 -3.2% 6416301 5211 POSTAGE 5,184.14 25,000.00 25,000.00 6,123.42 25,000.00 25,000.00 .0% 6416301 5212 ADVERTISNG 616.51 3,000.00 3,000.00 254.62 1,200.00 3,000.00 .0% 6416301 5213 DUES&SUBSC 756.00 1,200.00 1,200.00 630.00 1,010.00 1,100.00 -8.3% 6416301 5215 TRNG/CONF 310.00 2,800.00 2,800.00 1,190.00 2,940.00 2,900.00 3.6% 6416301 5216 OFFIC SUPP 396.12 1,500.00 1,500.00 243.71 1,000.00 1,000.00 -33.3% 6416301 5217 OTHER SUPP 784.09 2,320.00 2,320.00 614.30 3,820.00 3,820.00 64.7% 6416301 5218 UNIFRM EXP 10.50 .00 .00 179.94 .00 .00 .0% 6416301 5222 PRNT/MAIL 63.57 .00 .00 63.57 .00 .00 .0%

Page 164 of 197 ends

City of Upland, CA

NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 05/17/2023 15:28
User: skazmi
Program ID: bgnyrpts

Page 89 ends

PROJECTION: 20241 FY 2023-24 ANNUAL BUDGET FOR PERIOD 99 ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT SOLID WASTE UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE 6416301 5226 TEAM BLDG .00 .00 .00 .00 .00 100.00 .0% 6416301 5231 FURN&OFFC 215.49 .00 .00 .00 .00 .00 .0% 6416301 5234 OTH EQ RNT .00 1,900.00 1,900.00 157.44 2,100.00 1,900.00 .0% 6416301 5243 UTL-TELEPH 120.37 .00 .00 110.01 .00 .00 .0% 6416301 5244 UTL-WATER .00 1,760.00 1,760.00 1,387.86 .00 .00 .0% 6416301 5251 LEGAL SVS 6,806.91 3,000.00 3,000.00 10,000.00 10,000.00 10,000.00 233.3% 6416301 5252 PROF SVS 11,500.00 4,010.00 6,698.00 2,687.66 4,010.00 4,150.00 -38.0% 6416301 5253 CONTRC SVS 2,784.38 5,375.00 16,085.00 8,341.43 13,725.00 8,680.00 -46.0% 6416301 5254 DATA P SVS 3,525.78 3,810.00 3,810.00 -338.69 3,810.00 3,810.00 .0% 6416301 5255 BANKNG SVS 10,691.95 3,500.00 3,500.00 .00 3,500.00 10,000.00 185.7% 6416301 5256 SW SVS 14,374,788.76 13,976,240.00 13,976,240.00 15,365,781.70 15,620,000.00 16,000,000.00 14.5% 6416301 5258 OTHER SVS 15,416.08 50,000.00 50,000.00 23,473.42 28,450.00 48,900.00 -2.2% 6416301 5291 BAD DB EXP 12,587.62 .00 .00 .00 .00 .00 .0% 6416301 5292 ADM SV EXP 546,540.00 559,710.00 559,710.00 546,540.00 546,540.00 546,540.00 -2.4% 6416301 5324 OPEB 47,111.00 .00 .00 .00 .00 .00 .0% 6416301 5325 PEN EXP -264,779.05 .00 .00 .00 .00 .00 .0% 6416301 5530 MACH&EQUIP .00 .00 .00 4,954.88 5,000.00 .00 .0% 6416301 5600 CONTR FA .00 .00 .00 -4,954.88 .00 .00 .0% 6416301 5701 INFO SYS 54,740.00 56,630.00 56,630.00 56,628.00 56,630.00 23,060.00 -59.3% 6416301 5704 BDG MT ALC 9,940.00 5,240.00 5,240.00 5,244.00 5,240.00 5,950.00 13.5% 6416301 5705 SF LIAB 99,860.00 117,690.00 117,690.00 117,696.00 117,690.00 89,150.00 -24.3% 6416301 5706 OPB&BN ALC 19,750.00 14,750.00 14,750.00 14,748.00 14,750.00 10,950.00 -25.8% 6416301 5707 PERSUALALC 102,120.00 .00 .00 .00 .00 .00 .0% TOTAL SOLID WASTE 15,450,179.86 15,428,675.00 15,431,363.00 16,570,061.26 17,044,945.00 17,317,240.00 12.2% 6416302 HOUSEHOLD HAZARDOUS WASTE
6416302 5111 SALARY-FT 2,053.37 5,160.00 5,160.00 3,923.00 5,160.00 5,560.00 7.8% 6416302 5112 SALARY-PT 1,525.79 40,440.00 40,440.00 .00 40,440.00 40,860.00 1.0% 6416302 5113 OVERTIME 69,308.63 58,000.00 58,000.00 48,906.51 65,000.00 65,000.00 12.1% 6416302 5116 FRINGE BEN 14,027.31 2,740.00 2,740.00 10,166.47 2,740.00 2,920.00 6.6% 6416302 5117 RETIR CNTR 167.62 560.00 560.00 429.91 560.00 670.00 19.6% 6416302 5215 TRNG/CONF .00 975.00 975.00 1,552.52 2,000.00 2,000.00 105.1% 6416302 5217 OTHER SUPP 47.22 1,300.00 1,300.00 102.31 3,000.00 3,000.00 130.8% 6416302 5233 OTHR EQUIP 3,409.76 .00 .00 .00 .00 .00 .0% 6416302 5253 CONTRC SVS 102,134.44 115,000.00 115,000.00 105,693.36 105,700.00 110,000.00 -4.3% 6416302 5258 OTHER SVS 700.00 .00 .00 10,000.00 10,000.00 .00 .0% TOTAL HOUSEHOLD HAZARDOUS WA 193,374.14 224,175.00 224,175.00 180,774.08 234,600.00 230,010.00 2.6% 6416303 SHARPS PROGRAM
6416303 5212 ADVERTISNG .00 1,000.00 1,000.00 .00 500.00 500.00 -50.0%

Page 165 of 197 ends

Upland City CouncilMay 25, 2023

Upland City Council
May 25, 2023