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

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

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

TOTAL POLICE INVESTIGATIONS 3,113,722.91 2,893,120.00 2,898,775.00 5,835,533.22 1,916,065.00 2,707,580.00 -6.6% ____________________________________________
1013205 ANIMAL SERVICES
1013205 5110 BUY BACKS 1,359.46 .00 .00 1,456.85 1,460.00 .00 .0% 1013205 5111 SALARY-FT 160,934.05 201,430.00 201,430.00 153,347.25 192,510.00 211,350.00 4.9% 1013205 5111 16111 SALARY-FT 2,512.56 .00 .00 .00 .00 .00 .0% 1013205 5111 50105 SALARY-FT 1.60 .00 .00 .00 .00 .00 .0% 1013205 5112 16111 SALARY-PT 126.28 .00 .00 .00 .00 .00 .0% 1013205 5113 OVERTIME 2,897.85 11,960.00 11,960.00 1,848.69 2,020.00 2,750.00 -77.0% 1013205 5113 16110 OVERTIME 6,238.95 .00 .00 .00 .00 .00 .0% 1013205 5113 16111 OVERTIME 1,155.54 .00 .00 .00 .00 .00 .0% 1013205 5116 FRINGE BEN 44,067.48 65,800.00 65,800.00 37,573.10 47,120.00 67,930.00 3.2% 1013205 5116 16110 FRINGE BEN 1,598.46 .00 .00 .00 .00 .00 .0% 1013205 5116 16111 FRINGE BEN 486.07 .00 .00 .00 .00 .00 .0% 1013205 5116 50105 FRINGE BEN .44 .00 .00 .00 .00 .00 .0% 1013205 5117 RETIR CNTR 18,261.83 20,940.00 20,940.00 15,486.99 19,310.00 23,040.00 10.0% 1013205 5117 16111 RETIR CNTR 305.27 .00 .00 .00 .00 .00 .0% 1013205 5117 50105 RETIR CNTR .19 .00 .00 .00 .00 .00 .0% 1013205 5119 UAL PERS 57,976.75 .00 .00 .00 .00 .00 .0% 1013205 5119 50105 UAL PERS .52 .00 .00 .00 .00 .00 .0% 1013205 5213 DUES&SUBSC .00 380.00 380.00 .00 .00 380.00 .0% 1013205 5215 TRNG/CONF 300.00 4,280.00 3,280.00 .00 3,060.00 4,280.00 30.5% 1013205 5217 OTHER SUPP 2,894.32 13,100.00 10,100.00 1,558.41 9,270.00 13,100.00 29.7% 1013205 5218 UNIFRM EXP 38.00 2,400.00 2,270.00 1,094.03 1,970.00 2,800.00 23.3% 1013205 5220 FUEL USAGE 2,854.73 4,500.00 4,500.00 2,754.09 4,370.00 5,030.00 11.8% 1013205 5222 PRINTING .00 1,000.00 .00 .00 .00 1,000.00 .0% 1013205 5223 INFO SYS 136,400.00 .00 .00 .00 .00 .00 .0% 1013205 5224 VEH CHRG 11,780.00 .00 .00 .00 .00 .00 .0% 1013205 5225 BLDG MT&OP 39,140.00 .00 .00 .00 .00 .00 .0% 1013205 5232 COMP EQUIP .00 .00 20.00 18.31 20.00 50.00 150.0% 1013205 5233 OTHR EQUIP .00 .00 80.00 77.10 80.00 100.00 25.0% 1013205 5241 UTL-ELECTR 17,130.93 22,190.00 26,360.00 16,039.22 26,360.00 25,010.00 -5.1% 1013205 5242 UTL-GAS 4,527.99 5,140.00 6,310.00 5,331.92 6,310.00 5,960.00 -5.5% 1013205 5244 UTL-WATER .00 .00 .00 .00 .00 5,110.00 .0% 1013205 5246 MAINT-EQP 180.70 .00 440.00 435.96 440.00 .00 -100.0% 1013205 5253 CONTRC SVS .00 .00 2,500.00 374.63 .00 5,000.00 100.0% 1013205 5255 BANKNG SVS 423.99 400.00 650.00 437.92 650.00 700.00 7.7% 1013205 5258 OTHER SVS 11,671.96 14,120.00 13,120.00 10,348.59 12,710.00 14,640.00 11.6% 1013205 5273 WK CMP CHG 25,350.00 .00 .00 .00 .00 .00 .0% 1013205 5274 UNEMPL CHG 850.00 .00 .00 .00 .00 .00 .0% 1013205 5275 LT DIS CHG 1,650.00 .00 .00 .00 .00 .00 .0%

Page 91 of 214 ends

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

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

TOTAL ANIMAL SERVICES 586,935.92 692,210.00 694,710.00 545,645.06 652,230.00 710,980.00 2.3% ____________________________________________
1013211 POLICE PATROL
1013211 5110 BUY BACKS 40,906.50 .00 .00 39,570.50 38,720.00 .00 .0% 1013211 5111 SALARY-FT 883,036.71 1,028,050.00 1,050,582.00 761,086.67 805,940.00 1,002,230.00 -4.6% 1013211 5111 40155 SALARY-FT .00 .00 .00 2,595.13 .00 .00 .0% 1013211 5112 SALARY-PT 177,330.40 181,960.00 171,630.00 162,750.45 233,820.00 137,800.00 -19.7% 1013211 5113 OVERTIME 98,532.71 192,430.00 192,430.00 132,299.19 180,150.00 182,530.00 -5.1% 1013211 5113 16110 OVERTIME 37,769.67 .00 .00 .00 .00 .00 .0% 1013211 5113 16111 OVERTIME 43,214.46 .00 .00 .00 .00 .00 .0% 1013211 5113 16125 OVERTIME 126.24 .00 .00 .00 .00 .00 .0% 1013211 5113 40155 OVERTIME .00 .00 .00 709.99 .00 .00 .0% 1013211 5114 CATASTR LV -8,729.87 .00 .00 8,729.88 .00 .00 .0% 1013211 5116 FRINGE BEN 208,064.53 322,810.00 331,235.00 171,317.46 206,700.00 306,900.00 -7.3% 1013211 5116 16110 FRINGE BEN 9,044.81 .00 .00 .00 .00 .00 .0% 1013211 5116 16111 FRINGE BEN 3,288.25 .00 .00 .00 .00 .00 .0% 1013211 5116 16115 FRINGE BEN .03 .00 .00 .00 .00 .00 .0% 1013211 5116 16125 FRINGE BEN 14.37 .00 .00 .00 .00 .00 .0% 1013211 5116 40155 FRINGE BEN .00 .00 .00 656.94 .00 .00 .0% 1013211 5117 RETIR CNTR 107,366.34 109,840.00 112,183.00 79,206.97 92,480.00 112,450.00 .2% 1013211 5117 40155 RETIR CNTR .00 .00 .00 264.42 .00 .00 .0% 1013211 5119 UAL PERS 346,609.32 .00 .00 .00 .00 .00 .0% 1013211 5131 SAL-SW PD 5,110,686.32 5,954,230.00 5,954,230.00 4,499,252.42 5,625,920.00 4,016,180.00 -32.5% 1013211 5131 16111 SAL-SW PD 309,802.33 .00 .00 .00 .00 .00 .0% 1013211 5131 40155 SAL-SW PD .00 .00 .00 2,508.88 .00 .00 .0% 1013211 5133 OT-SW PD 546,322.36 677,480.00 677,480.00 772,272.29 915,270.00 920,510.00 35.9% 1013211 5133 16110 OT-SW PD 287,239.62 .00 .00 .00 .00 .00 .0% 1013211 5133 16111 OT-SW PD 132,730.33 .00 .00 .00 .00 .00 .0% 1013211 5133 16115 OT-SW PD 761.05 .00 .00 .00 .00 .00 .0% 1013211 5133 16125 OT-SW PD 660.43 .00 .00 .00 .00 .00 .0% 1013211 5133 40155 OT-SW PD .00 .00 .00 1,856.86 .00 .00 .0% 1013211 5136 FRG B-S PD 885,768.50 1,116,050.00 1,116,050.00 712,290.80 905,050.00 768,520.00 -31.1% 1013211 5136 16110 FRG B-S PD 34,167.28 .00 .00 .00 .00 .00 .0% 1013211 5136 16111 FRG B-S PD 36,559.62 .00 .00 .00 .00 .00 .0%

Page 92 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 1013211 5136 16115 FRG B-S PD 109.21 .00 .00 .00 .00 .00 .0% 1013211 5136 16125 FRG B-S PD 89.79 .00 .00 .00 .00 .00 .0% 1013211 5136 40155 FRG B-S PD .00 .00 .00 597.32 .00 .00 .0% 1013211 5137 RT CNTR-PD 928,856.76 1,049,010.00 1,049,010.00 745,859.14 945,050.00 701,650.00 -33.1% 1013211 5137 16111 RT CNTR-PD 53,274.17 .00 .00 .00 .00 .00 .0% 1013211 5137 40155 RT CNTR-PD .00 .00 .00 457.55 .00 .00 .0% 1013211 5139 UAL PD SWR 2,321,786.01 .00 10,000,000.00 26,357,298.00 .00 .00 -100.0% 1013211 5139 16111 UAL PD SWR 71,028.73 .00 .00 .00 .00 .00 .0% 1013211 5211 POSTAGE 3.00 .00 .00 .00 .00 .00 .0% 1013211 5213 DUES&SUBSC 365.56 3,340.00 3,360.00 1,387.83 3,360.00 3,930.00 17.0% 1013211 5215 TRNG/CONF 11,469.23 40,870.00 40,870.00 22,830.54 22,340.00 40,070.00 -2.0% 1013211 5216 OFFIC SUPP 51.40 .00 .00 .00 .00 .00 .0% 1013211 5217 OTHER SUPP 60,733.42 106,280.00 117,270.00 100,608.24 117,270.00 125,550.00 7.1% 1013211 5217 16110 OTHER SUPP 5,452.15 .00 .00 .00 .00 .00 .0% 1013211 5217 16111 OTHER SUPP 436.39 .00 .00 .00 .00 .00 .0% 1013211 5218 UNIFRM EXP 39,408.28 61,160.00 61,160.00 54,989.95 58,300.00 68,260.00 11.6% 1013211 5219 PERM/LC/FE 122.50 .00 .00 .00 .00 .00 .0% 1013211 5220 FUEL USAGE 135,532.10 169,070.00 169,070.00 109,888.04 165,610.00 190,450.00 12.6% 1013211 5224 VEH CHRG 230,980.00 .00 .00 .00 .00 .00 .0% 1013211 5231 FURN&OFFC 3,252.33 .00 6,200.00 6,194.93 6,200.00 6,200.00 .0% 1013211 5232 COMP EQUIP .00 .00 .00 458.50 .00 .00 .0% 1013211 5233 OTHR EQUIP 42,904.78 101,480.00 92,154.00 91,202.85 83,225.00 61,840.00 -32.9% 1013211 5246 MAINT-EQP 15,095.28 21,310.00 21,310.00 14,223.00 19,020.00 7,080.00 -66.8% 1013211 5247 16110 MAINT-VEH 33,135.00 .00 .00 .00 .00 .00 .0% 1013211 5253 CONTRC SVS 221,458.47 235,680.00 235,680.00 233,330.00 232,010.00 236,940.00 .5% 1013211 5258 OTHER SVS 120,762.67 166,470.00 166,470.00 88,628.54 146,270.00 166,830.00 .2% 1013211 5271 INS PREM 1,019.93 .00 910.00 1,152.11 910.00 1,350.00 48.4% 1013211 5530 MACH&EQUIP 3,804.61 .00 .00 .00 .00 .00 .0% 1013211 5531 VEHICLES .00 .00 4,700.00 4,700.00 4,700.00 .00 -100.0% 1013211 5702 FLT-MT&RP .00 251,690.00 251,690.00 230,714.00 251,690.00 229,010.00 -9.0% 1013211 5703 VEH ACQ .00 206,900.00 206,900.00 189,662.00 206,900.00 .00 -100.0%

TOTAL POLICE PATROL 13,592,404.08 11,996,110.00 22,032,574.00 35,601,551.39 11,266,905.00 9,286,280.00 -57.9% ____________________________________________
1013231 SPECIAL EVENTS & COMM OUTREACH
1013231 5112 SALARY-PT .00 .00 .00 592.80 1,280.00 .00 .0% 1013231 5113 OVERTIME .00 .00 .00 112.67 240.00 410.00 .0% 1013231 5116 FRINGE BEN .00 .00 .00 49.90 110.00 .00 .0% 1013231 5133 OT-SW PD .00 10,510.00 10,510.00 8,042.48 17,430.00 10,510.00 .0% 1013231 5136 FRG B-S PD .00 .00 .00 1,269.02 2,750.00 .00 .0% 1013231 5137 RT CNTR-PD -123.57 .00 .00 56.61 120.00 .00 .0% 1013231 5213 DUES&SUBSC .00 50.00 50.00 .00 50.00 50.00 .0% 1013231 5215 TRNG/CONF .00 1,000.00 1,000.00 182.36 500.00 2,000.00 100.0%

Page 93 of 214 ends

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

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

TOTAL SPECIAL EVENTS & COMM 1,817.91 17,660.00 17,660.00 10,369.67 26,290.00 20,670.00 17.0% ____________________________________________
1013232 POLICE RESERVES
1013232 5213 DUES&SUBSC .00 .00 480.00 .00 480.00 480.00 .0% 1013232 5215 TRNG/CONF 642.07 4,100.00 4,100.00 3,810.43 3,960.00 4,100.00 .0% 1013232 5218 UNIFRM EXP 822.04 2,200.00 1,720.00 1,000.00 1,100.00 2,200.00 27.9%

TOTAL POLICE RESERVES 1,464.11 6,300.00 6,300.00 4,810.43 5,540.00 6,780.00 7.6% ____________________________________________
1013233 CODE ENFORCEMENT
1013233 5111 SALARY-FT 195,585.31 259,160.00 259,160.00 166,925.41 207,370.00 247,990.00 -4.3% 1013233 5113 OVERTIME .00 13,390.00 13,390.00 861.55 1,320.00 1,450.00 -89.2% 1013233 5114 CATASTR LV -13.14 .00 .00 .00 .00 .00 .0% 1013233 5116 FRINGE BEN 48,909.76 71,390.00 71,390.00 32,809.75 43,570.00 70,660.00 -1.0% 1013233 5117 RETIR CNTR 22,540.88 26,960.00 26,960.00 16,342.02 21,000.00 27,070.00 .4% 1013233 5119 UAL PERS 82,744.79 .00 .00 .00 .00 .00 .0% 1013233 5211 POSTAGE .00 100.00 100.00 4.00 50.00 100.00 .0% 1013233 5213 DUES&SUBSC 8,517.50 8,820.00 8,820.00 8,624.13 8,820.00 9,240.00 4.8% 1013233 5215 TRNG/CONF 1,814.17 8,060.00 7,700.00 3,138.77 5,450.00 8,060.00 4.7% 1013233 5217 OTHER SUPP 99.09 400.00 400.00 .00 400.00 400.00 .0% 1013233 5218 UNIFRM EXP 1,239.00 2,100.00 2,100.00 1,495.00 1,570.00 2,100.00 .0% 1013233 5220 FUEL USAGE 2,471.06 3,260.00 3,400.00 2,252.66 3,400.00 3,910.00 15.0% 1013233 5222 PRINTING 363.90 300.00 520.00 327.66 520.00 520.00 .0% 1013233 5224 VEH CHRG 8,790.00 .00 .00 .00 .00 .00 .0% 1013233 5233 OTHR EQUIP .00 600.00 600.00 49.70 600.00 600.00 .0% 1013233 5251 LEGAL SVS 144,361.49 113,970.00 248,970.00 248,970.00 248,860.00 248,860.00 .0% 1013233 5258 OTHER SVS 5,149.88 8,880.00 16,380.00 11,085.00 15,940.00 16,880.00 3.1% 1013233 5273 WK CMP CHG 26,070.00 .00 .00 .00 .00 .00 .0% 1013233 5274 UNEMPL CHG 880.00 .00 .00 .00 .00 .00 .0% 1013233 5275 LT DIS CHG 1,700.00 .00 .00 .00 .00 .00 .0% 1013233 5276 LIAB CHG 33,090.00 .00 .00 .00 .00 .00 .0% 1013233 5277 LOSS PREV 1,690.00 .00 .00 .00 .00 .00 .0% 1013233 5299 PY EXP -5,393.26 .00 .00 .00 .00 .00 .0% 1013233 5702 FLT-MT&RP .00 3,920.00 3,920.00 3,597.00 3,920.00 4,170.00 6.4% 1013233 5705 SF LIAB .00 62,340.00 62,340.00 57,145.00 62,340.00 62,380.00 .1% 1013233 5706 OPB&BN ALC .00 12,030.00 12,030.00 11,000.00 12,030.00 9,450.00 -21.4% 1013233 5707 PERSUALALC .00 75,670.00 75,670.00 69,410.00 75,670.00 84,860.00 12.1%

TOTAL CODE ENFORCEMENT 580,610.43 671,350.00 813,850.00 634,037.65 712,830.00 798,700.00 -1.9% ____________________________________________
1013501 FIRE ADMINISTRATION
1013501 5220 FUEL USAGE 11,162.21 14,000.00 14,000.00 10,137.26 15,210.00 14,000.00 .0%

Page 94 of 214 ends

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

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

TOTAL FIRE ADMINISTRATION 12,457.18 14,000.00 14,000.00 10,137.26 15,210.00 14,000.00 .0% ____________________________________________
1013512 FIRE STATION II
1013512 5225 BLDG MT&OP 17,700.00 .00 .00 .00 .00 .00 .0% 1013512 5241 UTL-ELECTR 2,920.26 2,700.00 2,700.00 2,209.15 2,700.00 2,480.00 -8.1% 1013512 5242 UTL-GAS 386.98 270.00 270.00 461.52 270.00 310.00 14.8% 1013512 5244 UTL-WATER .00 .00 .00 .00 .00 5,060.00 .0% 1013512 5704 BDG MT ALC .00 45,100.00 45,100.00 41,338.00 45,100.00 57,090.00 26.6%

TOTAL FIRE STATION II 21,007.24 48,070.00 48,070.00 44,008.67 48,070.00 64,940.00 35.1% ____________________________________________
1013518 HISTORIC FIRE STATION
1013518 5225 BLDG MT&OP 12,480.00 .00 .00 .00 .00 .00 .0% 1013518 5243 UTL-TELEPH 1,214.88 .00 .00 1,012.40 .00 .00 .0% 1013518 5704 BDG MT ALC .00 36,440.00 36,440.00 33,407.00 36,440.00 38,890.00 6.7%

TOTAL HISTORIC FIRE STATION 13,694.88 36,440.00 36,440.00 34,419.40 36,440.00 38,890.00 6.7% ____________________________________________
1014201 RECREATION ADMINISTRATION
1014201 5110 BUY BACKS 5,734.02 5,910.00 5,910.00 3,261.20 3,260.00 3,430.00 -42.0% 1014201 5111 SALARY-FT 213,487.91 277,460.00 277,460.00 211,176.35 240,980.00 300,280.00 8.2% 1014201 5111 16110 SALARY-FT 4,426.48 .00 .00 .00 .00 .00 .0% 1014201 5111 16111 SALARY-FT 1,514.15 .00 .00 .00 .00 .00 .0% 1014201 5111 16125 SALARY-FT 313.24 .00 .00 .00 .00 .00 .0% 1014201 5112 SALARY-PT 45,719.23 54,640.00 54,640.00 76,249.25 89,990.00 54,640.00 .0% 1014201 5112 16105 SALARY-PT 640.98 .00 .00 .00 .00 .00 .0% 1014201 5112 16110 SALARY-PT 13,683.16 .00 .00 .00 .00 .00 .0% 1014201 5112 16111 SALARY-PT 500.40 .00 .00 .00 .00 .00 .0% 1014201 5112 16125 SALARY-PT 269.24 .00 .00 .00 .00 .00 .0% 1014201 5112 20101 SALARY-PT 1,977.31 .00 .00 960.63 1,230.00 .00 .0% 1014201 5112 20106 SALARY-PT 3,803.90 .00 .00 3,905.66 4,680.00 .00 .0% 1014201 5112 20107 SALARY-PT 2,968.10 .00 .00 .00 .00 .00 .0% 1014201 5112 20108 SALARY-PT 274.70 .00 .00 15,737.01 20,800.00 .00 .0% 1014201 5113 OVERTIME 559.36 .00 .00 225.78 490.00 500.00 .0% 1014201 5116 FRINGE BEN 47,932.69 78,570.00 78,570.00 50,874.69 58,220.00 81,310.00 3.5% 1014201 5116 16105 FRINGE BEN 9.30 .00 .00 .00 .00 .00 .0% 1014201 5116 16110 FRINGE BEN 4,029.32 .00 .00 .00 .00 .00 .0% 1014201 5116 16111 FRINGE BEN 367.75 .00 .00 .00 .00 .00 .0% 1014201 5116 16125 FRINGE BEN 63.04 .00 .00 .00 .00 .00 .0%

Page 95 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 1014201 5116 20101 FRINGE BEN 28.67 .00 .00 13.90 20.00 .00 .0% 1014201 5116 20106 FRINGE BEN 55.18 .00 .00 56.69 70.00 .00 .0% 1014201 5116 20107 FRINGE BEN 43.06 .00 .00 .00 .00 .00 .0% 1014201 5116 20108 FRINGE BEN 3.98 .00 .00 228.19 300.00 .00 .0% 1014201 5117 RETIR CNTR 24,963.47 28,840.00 28,840.00 23,580.74 26,890.00 32,840.00 13.9% 1014201 5117 16105 RETIR CNTR 27.11 .00 .00 .00 .00 .00 .0% 1014201 5117 16110 RETIR CNTR 2,038.31 .00 .00 .00 .00 .00 .0% 1014201 5117 16111 RETIR CNTR 186.89 .00 .00 .00 .00 .00 .0% 1014201 5117 16125 RETIR CNTR 45.34 .00 .00 .00 .00 .00 .0% 1014201 5117 20101 RETIR CNTR 228.71 .00 .00 100.11 130.00 .00 .0% 1014201 5117 20106 RETIR CNTR 434.34 .00 .00 406.97 490.00 .00 .0% 1014201 5117 20107 RETIR CNTR 192.93 .00 .00 .00 .00 .00 .0% 1014201 5117 20108 RETIR CNTR 16.95 .00 .00 376.57 610.00 .00 .0% 1014201 5119 UAL PERS 82,134.17 .00 .00 .00 .00 .00 .0% 1014201 5119 16105 UAL PERS 34.86 .00 .00 .00 .00 .00 .0% 1014201 5119 16110 UAL PERS 5,007.64 .00 .00 .00 .00 .00 .0% 1014201 5119 16111 UAL PERS 499.89 .00 .00 .00 .00 .00 .0% 1014201 5119 16125 UAL PERS 113.44 .00 .00 .00 .00 .00 .0% 1014201 5119 20101 UAL PERS 637.61 .00 .00 .00 .00 .00 .0% 1014201 5119 20106 UAL PERS 1,210.84 .00 .00 .00 .00 .00 .0% 1014201 5119 20107 UAL PERS 482.57 .00 .00 .00 .00 .00 .0% 1014201 5211 POSTAGE 4,908.59 8,000.00 8,000.00 4,904.61 8,000.00 9,000.00 12.5% 1014201 5212 ADVERTISNG .00 100.00 100.00 25.00 100.00 200.00 100.0% 1014201 5213 DUES&SUBSC 2,214.47 2,010.00 2,010.00 1,427.93 .00 2,380.00 18.4% 1014201 5215 TRNG/CONF 796.60 1,150.00 3,550.00 2,183.87 3,550.00 4,350.00 22.5% 1014201 5215 20101 TRNG/CONF 42.75 .00 .00 .00 .00 .00 .0% 1014201 5216 OFFIC SUPP 2,393.26 3,500.00 3,500.00 2,073.90 3,500.00 4,000.00 14.3% 1014201 5216 20108 OFFIC SUPP .00 .00 .00 609.59 .00 .00 .0% 1014201 5216 20401 OFFIC SUPP .00 .00 300.00 160.20 300.00 .00 -100.0% 1014201 5217 OTHER SUPP 4,064.74 5,100.00 5,100.00 4,195.80 5,100.00 4,500.00 -11.8% 1014201 5217 16125 OTHER SUPP 822.57 .00 .00 .00 .00 .00 .0% 1014201 5217 20101 OTHER SUPP 41.98 .00 .00 .00 .00 .00 .0% 1014201 5217 20106 OTHER SUPP 90.19 .00 .00 10.75 .00 .00 .0% 1014201 5217 20107 OTHER SUPP 59.32 .00 .00 .00 .00 .00 .0% 1014201 5217 20108 OTHER SUPP .00 .00 .00 329.70 .00 .00 .0% 1014201 5218 UNIFRM EXP .00 .00 678.00 677.75 677.75 1,000.00 47.5% 1014201 5219 PERM/LC/FE 734.21 1,490.00 1,490.00 1,467.00 1,490.00 1,500.00 .7% 1014201 5220 FUEL USAGE 1,062.20 1,300.00 3,500.00 2,027.02 3,000.00 4,000.00 14.3% 1014201 5221 MILE REIMB .00 100.00 100.00 .00 100.00 200.00 100.0% 1014201 5222 PRNT/MAIL 147.62 700.00 700.00 .00 700.00 200.00 -71.4% 1014201 5223 INFO SYS 65,250.00 .00 .00 .00 .00 .00 .0% 1014201 5224 VEH CHRG 3,750.00 .00 .00 .00 .00 .00 .0% 1014201 5231 FURN&OFFC 5,227.32 800.00 800.00 .00 800.00 500.00 -37.5% 1014201 5232 COMP EQUIP 226.25 .00 2,136.00 2,135.74 2,135.74 2,500.00 17.0%

Page 96 of 214 ends

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

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

TOTAL RECREATION ADMINISTRAT 749,172.25 850,820.00 855,521.00 750,902.19 858,952.44 975,970.00 14.1% ____________________________________________
1014202 RECREATION CLASSES
1014202 5112 SALARY-PT 2,098.61 .00 .00 213.60 460.00 .00 .0% 1014202 5112 16110 SALARY-PT 99.23 .00 .00 .00 .00 .00 .0% 1014202 5112 20201 SALARY-PT 302.17 .00 .00 .00 .00 .00 .0% 1014202 5112 20202 SALARY-PT 135.30 .00 .00 .00 .00 .00 .0% 1014202 5112 20206 SALARY-PT .00 .00 .00 2,296.83 4,050.00 .00 .0% 1014202 5112 20207 SALARY-PT 759.28 .00 .00 36.08 80.00 .00 .0% 1014202 5112 20208 SALARY-PT 1,867.14 .00 .00 1,686.74 2,500.00 .00 .0% 1014202 5112 20209 SALARY-PT 284.32 .00 .00 .00 .00 .00 .0% 1014202 5112 20210 SALARY-PT 727.96 .00 .00 .00 .00 .00 .0% 1014202 5112 20211 SALARY-PT 275.11 .00 .00 387.86 630.00 .00 .0% 1014202 5112 20733 SALARY-PT 1,264.95 .00 .00 .00 .00 .00 .0% 1014202 5116 FRINGE BEN 30.43 .00 .00 3.10 10.00 .00 .0% 1014202 5116 16110 FRINGE BEN 1.43 .00 .00 .00 .00 .00 .0% 1014202 5116 20201 FRINGE BEN 4.38 .00 .00 .00 .00 .00 .0% 1014202 5116 20202 FRINGE BEN 1.97 .00 .00 .00 .00 .00 .0%

Page 97 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 1014202 5116 20206 FRINGE BEN .00 .00 .00 33.31 60.00 .00 .0% 1014202 5116 20207 FRINGE BEN 11.02 .00 .00 .52 1.00 .00 .0% 1014202 5116 20208 FRINGE BEN 27.06 .00 .00 24.43 40.00 .00 .0% 1014202 5116 20209 FRINGE BEN 4.13 .00 .00 .00 .00 .00 .0% 1014202 5116 20210 FRINGE BEN 10.55 .00 .00 .00 .00 .00 .0% 1014202 5116 20211 FRINGE BEN 4.00 .00 .00 5.61 10.00 .00 .0% 1014202 5117 RETIR CNTR 180.55 .00 .00 22.26 50.00 .00 .0% 1014202 5117 16110 RETIR CNTR 12.00 .00 .00 .00 .00 .00 .0% 1014202 5117 20201 RETIR CNTR 34.95 .00 .00 .00 .00 .00 .0% 1014202 5117 20202 RETIR CNTR 15.65 .00 .00 .00 .00 .00 .0% 1014202 5117 20206 RETIR CNTR .00 .00 .00 146.49 260.00 .00 .0% 1014202 5117 20207 RETIR CNTR 58.43 .00 .00 3.76 10.00 .00 .0% 1014202 5117 20208 RETIR CNTR 215.96 .00 .00 175.78 260.00 .00 .0% 1014202 5117 20209 RETIR CNTR 16.69 .00 .00 .00 .00 .00 .0% 1014202 5117 20210 RETIR CNTR 84.22 .00 .00 .00 .00 .00 .0% 1014202 5117 20211 RETIR CNTR 31.82 .00 .00 40.42 70.00 .00 .0% 1014202 5119 UAL PERS 480.50 .00 .00 .00 .00 .00 .0% 1014202 5119 16110 UAL PERS 33.45 .00 .00 .00 .00 .00 .0% 1014202 5119 20201 UAL PERS 97.45 .00 .00 .00 .00 .00 .0% 1014202 5119 20202 UAL PERS 43.63 .00 .00 .00 .00 .00 .0% 1014202 5119 20207 UAL PERS 162.89 .00 .00 .00 .00 .00 .0% 1014202 5119 20208 UAL PERS 602.09 .00 .00 .00 .00 .00 .0% 1014202 5119 20209 UAL PERS 46.54 .00 .00 .00 .00 .00 .0% 1014202 5119 20210 UAL PERS 234.75 .00 .00 .00 .00 .00 .0% 1014202 5119 20211 UAL PERS 88.71 .00 .00 .00 .00 .00 .0% 1014202 5211 POSTAGE .00 100.00 100.00 .00 100.00 250.00 150.0% 1014202 5211 20205 POSTAGE .00 .00 60.00 129.60 60.00 .00 -100.0% 1014202 5215 TRNG/CONF .00 .00 232.00 231.23 232.00 500.00 115.5% 1014202 5215 20208 TRNG/CONF 22.00 .00 .00 .00 .00 .00 .0% 1014202 5217 OTHER SUPP .00 8,250.00 7,958.00 425.39 8,250.00 11,500.00 44.5% 1014202 5217 20201 OTHER SUPP 374.49 .00 .00 .00 .00 .00 .0% 1014202 5217 20202 OTHER SUPP 338.63 .00 .00 .00 .00 .00 .0% 1014202 5217 20204 OTHER SUPP 250.00 .00 .00 .00 .00 .00 .0% 1014202 5217 20205 OTHER SUPP 56.46 .00 .00 3.21 .00 .00 .0% 1014202 5217 20206 OTHER SUPP .00 .00 .00 6.33 .00 .00 .0% 1014202 5217 20207 OTHER SUPP 603.90 .00 .00 900.00 .00 .00 .0% 1014202 5217 20208 OTHER SUPP 410.37 .00 .00 417.79 .00 .00 .0% 1014202 5217 20209 OTHER SUPP 294.38 .00 .00 305.15 .00 .00 .0% 1014202 5217 20211 OTHER SUPP 328.01 .00 .00 411.28 .00 .00 .0% 1014202 5231 FURN&OFFC .00 .00 .00 461.05 .00 .00 .0% 1014202 5253 CONTRC SVS 17,851.34 118,000.00 118,000.00 105,589.04 118,000.00 120,000.00 1.7% 1014202 5258 OTHER SVS .00 33,000.00 950.00 .00 33,000.00 33,500.00 3426.3%

TOTAL RECREATION CLASSES 30,878.90 159,350.00 127,300.00 113,956.86 168,133.00 165,750.00 30.2% ____________________________________________
1014203 RECREATION FACILITIES
1014203 5111 SALARY-FT .00 .00 .00 .00 .00 19,430.00 .0%

Page 98 of 214 ends

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

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

TOTAL RECREATION FACILITIES 103,313.45 254,250.00 254,250.00 229,881.67 257,413.00 308,700.00 21.4% ____________________________________________
1014204 RECREATION PARKS
1014204 5111 SALARY-FT .00 .00 .00 .00 .00 19,430.00 .0% 1014204 5112 SALARY-PT .00 58,000.00 83,000.00 154.50 330.00 83,000.00 .0% 1014204 5112 16105 SALARY-PT 29.44 .00 .00 .00 .00 .00 .0% 1014204 5112 20401 SALARY-PT 2,094.67 .00 .00 14,651.63 14,600.00 .00 .0% 1014204 5112 20402 SALARY-PT 147.20 .00 .00 .00 .00 .00 .0% 1014204 5112 20403 SALARY-PT 15,972.99 .00 .00 9,606.78 13,200.00 .00 .0% 1014204 5116 FRINGE BEN .00 840.00 840.00 2.24 .00 6,450.00 667.9% 1014204 5116 16105 FRINGE BEN .43 .00 .00 .00 .00 .00 .0% 1014204 5116 20401 FRINGE BEN 30.36 .00 .00 212.42 210.00 .00 .0% 1014204 5116 20402 FRINGE BEN 2.13 .00 .00 .00 .00 .00 .0% 1014204 5116 20403 FRINGE BEN 231.61 .00 .00 139.35 190.00 .00 .0% 1014204 5117 RETIR CNTR .00 .00 .00 .00 .00 2,130.00 .0% 1014204 5117 20401 RETIR CNTR .00 .00 .00 18.80 40.00 .00 .0% 1014204 5117 20403 RETIR CNTR 470.98 .00 .00 48.94 60.00 .00 .0% 1014204 5119 20403 UAL PERS 140.89 .00 .00 .00 .00 .00 .0% 1014204 5212 ADVERTISNG .00 300.00 300.00 .00 300.00 300.00 .0% 1014204 5215 TRNG/CONF .00 400.00 400.00 .00 400.00 400.00 .0% 1014204 5216 OFFIC SUPP .00 100.00 160.00 .00 160.00 300.00 87.5% 1014204 5217 OTHER SUPP .00 300.00 300.00 340.68 100.00 450.00 50.0% 1014204 5217 20401 OTHER SUPP .00 .00 150.00 25.85 150.00 .00 -100.0% 1014204 5217 20403 OTHER SUPP 495.38 .00 .00 .00 .00 .00 .0% 1014204 5218 20401 UNIFRM EXP 267.22 .00 .00 .00 .00 .00 .0% 1014204 5222 PRINTING .00 500.00 290.00 .00 .00 .00 -100.0% 1014204 5248 20403 MAINT-OTHR 108.22 .00 .00 .00 .00 .00 .0%

Page 99 of 214 ends

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

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

TOTAL RECREATION PARKS 19,991.52 66,940.00 91,940.00 29,761.19 36,240.00 118,460.00 28.8% ____________________________________________
1014205 SENIOR CENTER
1014205 5111 SALARY-FT 60,350.68 85,520.00 85,520.00 68,167.96 83,720.00 85,770.00 .3% 1014205 5111 16110 SALARY-FT 5,852.15 .00 .00 .00 .00 .00 .0% 1014205 5111 16111 SALARY-FT 2,161.62 .00 .00 .00 .00 .00 .0% 1014205 5112 SALARY-PT 60,322.51 66,000.00 66,000.00 63,458.95 84,710.00 66,000.00 .0% 1014205 5112 16105 SALARY-PT 231.16 .00 .00 .00 .00 .00 .0% 1014205 5112 16110 SALARY-PT 4,004.52 .00 .00 .00 .00 .00 .0% 1014205 5112 16111 SALARY-PT 2,273.36 .00 .00 .00 .00 .00 .0% 1014205 5112 20542 SALARY-PT 88.32 .00 .00 1,099.18 1,240.00 .00 .0% 1014205 5112 20543 SALARY-PT 23.78 .00 .00 .00 .00 .00 .0% 1014205 5112 20544 SALARY-PT .00 .00 .00 145.16 .00 .00 .0% 1014205 5112 20546 SALARY-PT 674.75 .00 .00 .00 .00 .00 .0% 1014205 5112 20547 SALARY-PT 287.93 .00 .00 .00 .00 .00 .0% 1014205 5112 20552 SALARY-PT 203.90 .00 .00 .00 .00 .00 .0% 1014205 5112 20553 SALARY-PT 325.76 .00 .00 243.33 .00 .00 .0% 1014205 5112 20559 SALARY-PT 230.55 .00 .00 .00 .00 .00 .0% 1014205 5113 OVERTIME .00 .00 .00 11.88 30.00 50.00 .0% 1014205 5116 FRINGE BEN 16,350.47 23,840.00 23,840.00 16,757.91 20,600.00 23,860.00 .1% 1014205 5116 16105 FRINGE BEN 3.36 .00 .00 .00 .00 .00 .0% 1014205 5116 16110 FRINGE BEN 1,568.64 .00 .00 .00 .00 .00 .0% 1014205 5116 16111 FRINGE BEN 557.13 .00 .00 .00 .00 .00 .0% 1014205 5116 20542 FRINGE BEN 1.28 .00 .00 15.93 20.00 .00 .0% 1014205 5116 20543 FRINGE BEN .35 .00 .00 .00 .00 .00 .0% 1014205 5116 20544 FRINGE BEN .00 .00 .00 2.11 .00 .00 .0% 1014205 5116 20546 FRINGE BEN 9.77 .00 .00 .00 .00 .00 .0% 1014205 5116 20547 FRINGE BEN 4.17 .00 .00 .00 .00 .00 .0% 1014205 5116 20552 FRINGE BEN 2.96 .00 .00 .00 .00 .00 .0% 1014205 5116 20553 FRINGE BEN 4.73 .00 .00 3.53 .00 .00 .0% 1014205 5116 20559 FRINGE BEN 3.34 .00 .00 .00 .00 .00 .0% 1014205 5117 RETIR CNTR 12,118.59 8,890.00 8,890.00 11,269.30 14,470.00 9,380.00 5.5% 1014205 5117 16105 RETIR CNTR 19.75 .00 .00 .00 .00 .00 .0% 1014205 5117 16110 RETIR CNTR 743.86 .00 .00 .00 .00 .00 .0% 1014205 5117 16111 RETIR CNTR 298.04 .00 .00 .00 .00 .00 .0% 1014205 5117 20542 RETIR CNTR 10.21 .00 .00 83.54 110.00 .00 .0% 1014205 5117 20543 RETIR CNTR 2.75 .00 .00 .00 .00 .00 .0% 1014205 5117 20544 RETIR CNTR .00 .00 .00 15.12 .00 .00 .0% 1014205 5117 20546 RETIR CNTR 61.07 .00 .00 .00 .00 .00 .0% 1014205 5117 20547 RETIR CNTR 18.12 .00 .00 .00 .00 .00 .0% 1014205 5117 20552 RETIR CNTR 23.58 .00 .00 .00 .00 .00 .0%

Page 100 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 1014205 5117 20559 RETIR CNTR 11.48 .00 .00 .00 .00 .00 .0% 1014205 5119 UAL PERS 36,348.80 .00 .00 .00 .00 .00 .0% 1014205 5119 16105 UAL PERS 24.46 .00 .00 .00 .00 .00 .0% 1014205 5119 16110 UAL PERS 2,050.04 .00 .00 .00 .00 .00 .0% 1014205 5119 16111 UAL PERS 830.86 .00 .00 .00 .00 .00 .0% 1014205 5119 20543 UAL PERS 7.67 .00 .00 .00 .00 .00 .0% 1014205 5119 20546 UAL PERS 34.15 .00 .00 .00 .00 .00 .0% 1014205 5119 20547 UAL PERS 50.50 .00 .00 .00 .00 .00 .0% 1014205 5119 20552 UAL PERS 36.66 .00 .00 .00 .00 .00 .0% 1014205 5211 POSTAGE .00 100.00 100.00 .00 100.00 100.00 .0% 1014205 5212 ADVERTISNG .00 200.00 200.00 .00 200.00 200.00 .0% 1014205 5213 DUES&SUBSC 401.02 400.00 400.00 .00 400.00 550.00 37.5% 1014205 5215 TRNG/CONF 74.67 400.00 400.00 .00 400.00 400.00 .0% 1014205 5216 OFFIC SUPP 664.00 1,000.00 1,000.00 1,002.79 1,000.00 2,000.00 100.0% 1014205 5217 OTHER SUPP 2,526.59 9,100.00 8,985.00 1,597.21 9,100.00 9,000.00 .2% 1014205 5217 16110 OTHER SUPP 54.48 .00 .00 .00 .00 .00 .0% 1014205 5217 16111 OTHER SUPP 43.08 .00 .00 .00 .00 .00 .0% 1014205 5217 20542 OTHER SUPP .00 .00 .00 324.58 .00 .00 .0% 1014205 5217 20543 OTHER SUPP 319.32 .00 .00 434.98 .00 .00 .0% 1014205 5217 20544 OTHER SUPP 401.52 .00 .00 .00 .00 .00 .0% 1014205 5217 20546 OTHER SUPP 403.31 .00 .00 454.47 .00 .00 .0% 1014205 5217 20547 OTHER SUPP 548.26 .00 .00 840.04 .00 .00 .0% 1014205 5217 20548 OTHER SUPP 324.84 .00 .00 841.29 .00 .00 .0% 1014205 5217 20549 OTHER SUPP 211.85 .00 .00 261.69 .00 .00 .0% 1014205 5217 20550 OTHER SUPP 65.41 .00 .00 127.86 .00 .00 .0% 1014205 5217 20552 OTHER SUPP 78.17 .00 .00 462.15 .00 .00 .0% 1014205 5217 20553 OTHER SUPP 64.63 .00 .00 289.42 .00 .00 .0% 1014205 5217 20554 OTHER SUPP 47.18 .00 .00 59.18 .00 .00 .0% 1014205 5217 20555 OTHER SUPP 484.26 .00 .00 .00 .00 .00 .0% 1014205 5217 20556 OTHER SUPP 67.14 .00 .00 .00 .00 .00 .0% 1014205 5217 20559 OTHER SUPP 315.60 .00 .00 978.02 .00 .00 .0% 1014205 5223 INFO SYS 41,460.00 .00 .00 .00 .00 .00 .0% 1014205 5225 BLDG MT&OP 77,810.00 .00 .00 .00 .00 .00 .0% 1014205 5231 FURN&OFFC 1,015.26 .00 .00 -114.58 .00 .00 .0% 1014205 5233 OTHR EQUIP 960.29 .00 40.00 30.14 40.00 .00 -100.0% 1014205 5233 20547 OTHR EQUIP .00 .00 .00 75.41 .00 .00 .0% 1014205 5241 UTL-ELECTR 9,096.34 11,000.00 11,000.00 7,742.75 11,000.00 12,000.00 9.1% 1014205 5242 UTL-GAS 2,959.41 5,000.00 5,000.00 3,195.86 5,000.00 6,000.00 20.0% 1014205 5244 UTL-WATER .00 .00 .00 .00 .00 2,000.00 .0% 1014205 5246 MAINT-EQP 27.99 .00 .00 .00 .00 .00 .0% 1014205 5258 OTHER SVS 25.00 4,500.00 4,500.00 .00 4,425.00 4,500.00 .0% 1014205 5258 20544 OTHER SVS .00 .00 .00 500.00 .00 .00 .0% 1014205 5258 20547 OTHER SVS .00 .00 75.00 75.00 75.00 .00 -100.0% 1014205 5528 IMPRV BLD 18,710.00 .00 .00 .00 .00 .00 .0%

Page 101 of 214 ends

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

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

TOTAL SENIOR CENTER 367,387.40 354,370.00 354,370.00 307,337.16 375,060.00 364,460.00 2.8% ____________________________________________
1014206 SPECIAL EVENTS
1014206 5111 SALARY-FT .00 .00 .00 .00 .00 19,430.00 .0% 1014206 5112 SALARY-PT 740.86 4,700.00 4,700.00 2,398.62 2,440.00 4,700.00 .0% 1014206 5112 20611 SALARY-PT 986.60 .00 .00 1,554.52 3,370.00 .00 .0% 1014206 5112 20612 SALARY-PT .00 .00 .00 154.50 330.00 .00 .0% 1014206 5112 20613 SALARY-PT 1,328.57 .00 .00 1,591.41 3,450.00 .00 .0% 1014206 5112 20614 SALARY-PT .00 .00 .00 985.06 1,900.00 .00 .0% 1014206 5112 20617 SALARY-PT 272.34 .00 .00 304.99 660.00 .00 .0% 1014206 5112 20618 SALARY-PT 374.33 .00 .00 .00 .00 .00 .0% 1014206 5112 20619 SALARY-PT 993.36 .00 .00 1,163.55 2,410.00 .00 .0% 1014206 5112 20620 SALARY-PT 1,255.38 .00 .00 428.76 .00 .00 .0% 1014206 5112 20621 SALARY-PT 605.50 .00 .00 1,829.19 3,960.00 .00 .0% 1014206 5112 20622 SALARY-PT .00 .00 .00 54.12 120.00 .00 .0% 1014206 5112 20623 SALARY-PT 705.91 .00 .00 .00 .00 .00 .0% 1014206 5112 20624 SALARY-PT 865.27 .00 .00 .00 .00 .00 .0% 1014206 5112 20625 SALARY-PT 572.52 .00 .00 .00 .00 .00 .0% 1014206 5112 20626 SALARY-PT .00 .00 .00 156.16 340.00 .00 .0% 1014206 5113 OVERTIME .00 .00 .00 .00 .00 2,900.00 .0% 1014206 5113 20611 OVERTIME .00 .00 .00 530.50 1,150.00 .00 .0% 1014206 5113 20613 OVERTIME .00 .00 .00 614.10 1,330.00 .00 .0% 1014206 5116 FRINGE BEN 10.74 70.00 70.00 34.80 40.00 5,320.00 7500.0% 1014206 5116 20611 FRINGE BEN 18.30 .00 .00 40.03 90.00 .00 .0% 1014206 5116 20612 FRINGE BEN .00 .00 .00 2.24 .00 .00 .0% 1014206 5116 20613 FRINGE BEN 19.27 .00 .00 236.56 510.00 .00 .0% 1014206 5116 20614 FRINGE BEN .00 .00 .00 14.28 30.00 .00 .0% 1014206 5116 20617 FRINGE BEN 3.94 .00 .00 4.42 10.00 .00 .0% 1014206 5116 20618 FRINGE BEN 5.43 .00 .00 .00 .00 .00 .0% 1014206 5116 20619 FRINGE BEN 14.41 .00 .00 16.87 30.00 .00 .0% 1014206 5116 20620 FRINGE BEN 18.20 .00 .00 6.22 .00 .00 .0% 1014206 5116 20621 FRINGE BEN 8.79 .00 .00 26.51 60.00 .00 .0% 1014206 5116 20622 FRINGE BEN .00 .00 .00 .79 .00 .00 .0% 1014206 5116 20623 FRINGE BEN 10.22 .00 .00 .00 .00 .00 .0% 1014206 5116 20624 FRINGE BEN 12.54 .00 .00 .00 .00 .00 .0% 1014206 5116 20625 FRINGE BEN 8.31 .00 .00 .00 .00 .00 .0% 1014206 5116 20626 FRINGE BEN .00 .00 .00 2.26 .00 .00 .0% 1014206 5117 RETIR CNTR 34.43 .00 .00 187.70 250.00 2,130.00 .0% 1014206 5117 20611 RETIR CNTR 79.76 .00 .00 96.58 210.00 .00 .0% 1014206 5117 20613 RETIR CNTR 143.47 .00 .00 8.85 20.00 .00 .0%

Page 102 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 1014206 5117 20614 RETIR CNTR .00 .00 .00 95.40 180.00 .00 .0% 1014206 5117 20617 RETIR CNTR 17.74 .00 .00 8.93 20.00 .00 .0% 1014206 5117 20618 RETIR CNTR 43.31 .00 .00 .00 .00 .00 .0% 1014206 5117 20619 RETIR CNTR 61.44 .00 .00 100.64 210.00 .00 .0% 1014206 5117 20620 RETIR CNTR 124.16 .00 .00 8.86 .00 .00 .0% 1014206 5117 20621 RETIR CNTR 27.12 .00 .00 72.79 160.00 .00 .0% 1014206 5117 20622 RETIR CNTR .00 .00 .00 5.64 10.00 .00 .0% 1014206 5117 20623 RETIR CNTR 73.56 .00 .00 .00 .00 .00 .0% 1014206 5117 20624 RETIR CNTR 56.86 .00 .00 .00 .00 .00 .0% 1014206 5117 20625 RETIR CNTR 43.83 .00 .00 .00 .00 .00 .0% 1014206 5117 20626 RETIR CNTR .00 .00 .00 7.52 20.00 .00 .0% 1014206 5119 UAL PERS 95.98 .00 .00 .00 .00 .00 .0% 1014206 5119 20611 UAL PERS 103.26 .00 .00 .00 .00 .00 .0% 1014206 5119 20613 UAL PERS 399.95 .00 .00 .00 .00 .00 .0% 1014206 5119 20618 UAL PERS 120.71 .00 .00 .00 .00 .00 .0% 1014206 5119 20619 UAL PERS 171.27 .00 .00 .00 .00 .00 .0% 1014206 5119 20620 UAL PERS 346.15 .00 .00 .00 .00 .00 .0% 1014206 5119 20621 UAL PERS 20.36 .00 .00 .00 .00 .00 .0% 1014206 5119 20623 UAL PERS 205.07 .00 .00 .00 .00 .00 .0% 1014206 5119 20624 UAL PERS 158.52 .00 .00 .00 .00 .00 .0% 1014206 5119 20625 UAL PERS 122.17 .00 .00 .00 .00 .00 .0% 1014206 5211 20621 POSTAGE 36.05 .00 .00 .00 .00 .00 .0% 1014206 5212 ADVERTISNG .00 3,500.00 3,500.00 214.50 3,500.00 3,500.00 .0% 1014206 5215 TRNG/CONF .00 500.00 500.00 .00 500.00 500.00 .0% 1014206 5217 OTHER SUPP 1,079.56 32,620.00 32,620.00 2,921.63 32,620.00 45,000.00 38.0% 1014206 5217 20205 OTHER SUPP .00 .00 .00 76.35 .00 .00 .0% 1014206 5217 20611 OTHER SUPP 4,598.37 .00 .00 2,440.38 .00 .00 .0% 1014206 5217 20612 OTHER SUPP .00 .00 .00 327.58 .00 .00 .0% 1014206 5217 20613 OTHER SUPP 1,246.39 .00 .00 5,916.19 .00 .00 .0% 1014206 5217 20614 OTHER SUPP .00 .00 .00 744.81 .00 .00 .0% 1014206 5217 20617 OTHER SUPP 83.34 .00 .00 706.24 .00 .00 .0% 1014206 5217 20618 OTHER SUPP 2,033.38 .00 .00 .00 .00 .00 .0% 1014206 5217 20619 OTHER SUPP 219.05 .00 .00 1,941.41 .00 .00 .0% 1014206 5217 20620 OTHER SUPP 1,171.48 .00 .00 .00 .00 .00 .0% 1014206 5217 20621 OTHER SUPP 3,982.94 .00 .00 12,481.65 .00 .00 .0% 1014206 5217 20623 OTHER SUPP 2,931.30 .00 .00 .00 .00 .00 .0% 1014206 5217 20624 OTHER SUPP 2,151.51 .00 .00 .00 .00 .00 .0% 1014206 5217 20625 OTHER SUPP 160.84 .00 .00 .00 .00 .00 .0% 1014206 5217 20627 OTHER SUPP .00 .00 .00 4,098.12 .00 .00 .0% 1014206 5219 20611 PERM/LC/FE 437.00 .00 .00 .00 .00 .00 .0% 1014206 5219 20613 PERM/LC/FE .00 .00 300.00 260.74 300.00 300.00 .0% 1014206 5222 PRINTING .00 2,250.00 2,250.00 .00 2,250.00 2,250.00 .0% 1014206 5222 20611 PRINTING 134.69 .00 .00 .00 .00 .00 .0% 1014206 5222 20617 PRINTING 134.69 .00 .00 .00 .00 .00 .0%

Page 103 of 214 ends

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

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

TOTAL SPECIAL EVENTS 55,696.49 99,940.00 154,290.00 124,925.11 138,330.00 188,030.00 21.9% ____________________________________________
1014207 COMMUNITY OUTREACH SERVICES
1014207 5112 16110 SALARY-PT -87.62 .00 .00 .00 .00 .00 .0% 1014207 5112 16111 SALARY-PT 72.16 .00 .00 .00 .00 .00 .0% 1014207 5112 20731 SALARY-PT 36.08 .00 .00 .00 .00 .00 .0% 1014207 5112 20733 SALARY-PT 142.89 .00 .00 .00 .00 .00 .0% 1014207 5116 16110 FRINGE BEN -1.28 .00 .00 .00 .00 .00 .0% 1014207 5116 16111 FRINGE BEN 1.05 .00 .00 .00 .00 .00 .0% 1014207 5116 20731 FRINGE BEN .53 .00 .00 .00 .00 .00 .0% 1014207 5116 20733 FRINGE BEN 2.07 .00 .00 .00 .00 .00 .0% 1014207 5117 16110 RETIR CNTR -10.14 .00 .00 .00 .00 .00 .0% 1014207 5117 16111 RETIR CNTR 8.35 .00 .00 .00 .00 .00 .0% 1014207 5117 20731 RETIR CNTR 4.17 .00 .00 .00 .00 .00 .0% 1014207 5117 20733 RETIR CNTR 16.53 .00 .00 .00 .00 .00 .0% 1014207 5119 16110 UAL PERS -28.26 .00 .00 .00 .00 .00 .0% 1014207 5119 16111 UAL PERS 23.27 .00 .00 .00 .00 .00 .0% 1014207 5119 20733 UAL PERS 57.71 .00 .00 .00 .00 .00 .0% 1014207 5236 20733 RENT 714.71 .00 .00 .00 .00 .00 .0%

TOTAL COMMUNITY OUTREACH SER 952.22 .00 .00 .00 .00 .00 .0% ____________________________________________
1014210 LANDECENA CENTER
1014210 5223 INFO SYS 7,610.00 .00 .00 .00 .00 .00 .0% 1014210 5225 BLDG MT&OP 24,280.00 .00 .00 .00 .00 .00 .0% 1014210 5241 UTL-ELECTR 1,823.50 .00 .00 .00 .00 .00 .0%

TOTAL LANDECENA CENTER 33,713.50 .00 .00 .00 .00 .00 .0% ____________________________________________
1014402 CARNEGIE LIBRARY
1014402 5223 INFO SYS 4,520.00 .00 .00 .00 .00 .00 .0%

Page 104 of 214 ends

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

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

TOTAL CARNEGIE LIBRARY 96,134.83 .00 .00 .00 .00 .00 .0% ____________________________________________
1014409 PASSPORTS
1014409 5112 SALARY-PT 5,725.60 .00 .00 .00 .00 .00 .0% 1014409 5112 16105 SALARY-PT 77.25 .00 .00 .00 .00 .00 .0% 1014409 5116 FRINGE BEN 83.01 .00 .00 .00 .00 .00 .0% 1014409 5116 16105 FRINGE BEN 1.12 .00 .00 .00 .00 .00 .0% 1014409 5117 RETIR CNTR 221.64 .00 .00 .00 .00 .00 .0% 1014409 5119 UAL PERS 501.61 .00 .00 .00 .00 .00 .0% 1014409 5216 OFFIC SUPP 1,560.25 .00 .00 .00 .00 .00 .0%

TOTAL PASSPORTS 8,170.48 .00 .00 .00 .00 .00 .0% ____________________________________________
1015201 PUBLIC WORKS ADMINISTRATION
1015201 5110 BUY BACKS 3,126.06 12,240.00 12,240.00 2,702.96 2,700.00 13,970.00 14.1% 1015201 5111 SALARY-FT 54,865.57 63,750.00 63,750.00 47,946.07 59,460.00 65,120.00 2.1% 1015201 5111 16110 SALARY-FT 94.10 .00 .00 .00 .00 .00 .0% 1015201 5112 SALARY-PT 1,204.04 3,860.00 3,860.00 3,042.92 3,780.00 4,260.00 10.4% 1015201 5113 OVERTIME 343.58 .00 .00 108.13 .00 .00 .0% 1015201 5116 FRINGE BEN 16,677.66 19,680.00 19,680.00 14,402.56 17,530.00 19,780.00 .5% 1015201 5116 16110 FRINGE BEN 11.65 .00 .00 .00 .00 .00 .0% 1015201 5117 RETIR CNTR 6,246.09 6,610.00 6,610.00 4,888.04 6,110.00 6,950.00 5.1% 1015201 5117 16110 RETIR CNTR 10.88 .00 .00 .00 .00 .00 .0% 1015201 5119 UAL PERS 16,816.31 .00 .00 .00 .00 .00 .0% 1015201 5119 16110 UAL PERS 30.35 .00 .00 .00 .00 .00 .0% 1015201 5213 DUES&SUBSC 1,318.09 3,000.00 2,530.00 105.20 3,000.00 3,000.00 18.6% 1015201 5215 TRNG/CONF 1,670.29 5,000.00 4,000.00 2,244.19 5,000.00 5,000.00 25.0% 1015201 5216 OFFIC SUPP 2,031.52 2,000.00 3,000.00 2,318.13 3,000.00 3,000.00 .0% 1015201 5217 OTHER SUPP 2,943.01 5,000.00 5,000.00 3,451.39 6,000.00 6,000.00 20.0% 1015201 5217 16110 OTHER SUPP 22.52 .00 .00 .00 .00 .00 .0% 1015201 5218 UNIFRM EXP 4,693.93 .00 .00 .00 .00 .00 .0% 1015201 5219 PERM/LC/FE 403.89 .00 .00 .00 .00 .00 .0% 1015201 5220 FUEL USAGE 2,786.07 4,000.00 4,000.00 2,176.75 5,000.00 5,500.00 37.5% 1015201 5220 13281 FUEL USAGE -2,001.73 .00 .00 -1,904.10 .00 .00 .0% 1015201 5222 PRNT/MAIL 52.80 580.00 750.00 190.72 750.00 750.00 .0% 1015201 5223 INFO SYS 96,230.00 .00 .00 .00 .00 .00 .0% 1015201 5224 VEH CHRG 12,900.00 .00 .00 .00 .00 .00 .0% 1015201 5225 BLDG MT&OP 127,040.00 .00 .00 .00 .00 .00 .0% 1015201 5231 FURN&OFFC 1,923.44 .00 .00 4,170.69 .00 5,000.00 .0%

Page 105 of 214 ends

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

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

TOTAL PUBLIC WORKS ADMINISTR 793,916.32 1,413,370.00 1,415,370.00 1,266,347.88 1,402,180.00 1,422,000.00 .5% ____________________________________________
1015301 ENGINEERING ADMINISTRATION
1015301 5110 BUY BACKS 2,458.88 .00 .00 3,592.63 3,590.00 .00 .0% 1015301 5111 SALARY-FT 189,467.16 107,870.00 107,870.00 110,446.60 137,420.00 107,910.00 .0% 1015301 5113 OVERTIME 20,302.90 .00 .00 9,426.41 11,000.00 .00 .0% 1015301 5116 FRINGE BEN 41,342.38 23,400.00 23,400.00 23,485.44 28,820.00 23,470.00 .3% 1015301 5117 RETIR CNTR 21,429.64 11,220.00 11,220.00 11,618.67 14,060.00 11,800.00 5.2% 1015301 5119 UAL PERS 49,891.16 .00 .00 .00 .00 .00 .0% 1015301 5211 POSTAGE .00 100.00 100.00 .00 100.00 100.00 .0% 1015301 5213 DUES&SUBSC 900.00 1,380.00 1,380.00 .00 1,380.00 1,580.00 14.5% 1015301 5215 TRNG/CONF 238.50 1,240.00 1,240.00 237.50 1,240.00 1,250.00 .8% 1015301 5216 OFFIC SUPP 463.66 1,900.00 1,900.00 600.00 1,900.00 2,300.00 21.1% 1015301 5217 OTHER SUPP 313.99 940.00 940.00 .00 940.00 940.00 .0% 1015301 5218 UNIFRM EXP 706.00 1,000.00 1,000.00 486.83 1,000.00 1,600.00 60.0% 1015301 5220 FUEL USAGE 834.44 1,000.00 5,000.00 3,279.60 1,000.00 2,000.00 -60.0% 1015301 5222 PRNT/MAIL 105.60 50.00 50.00 .00 50.00 50.00 .0% 1015301 5223 INFO SYS 31,740.00 .00 .00 .00 .00 .00 .0% 1015301 5224 VEH CHRG 7,370.00 .00 .00 .00 .00 .00 .0% 1015301 5252 PROF SVS .00 20,000.00 20,000.00 4,300.00 20,000.00 20,000.00 .0% 1015301 5258 OTHER SVS 828.50 1,000.00 1,000.00 30.00 1,000.00 1,000.00 .0% 1015301 5701 INFO SYS .00 30,840.00 30,840.00 28,270.00 30,840.00 21,710.00 -29.6% 1015301 5702 FLT-MT&RP .00 1,540.00 1,540.00 1,408.00 1,540.00 2,150.00 39.6%

TOTAL ENGINEERING ADMINISTRA 368,392.81 203,480.00 207,480.00 197,181.68 255,880.00 197,860.00 -4.6% ____________________________________________
1015302 DEVELOPMENT/TRAFFIC ENGINRG
1015302 5111 SALARY-FT 233,311.69 295,170.00 295,170.00 177,160.26 203,280.00 313,060.00 6.1%

Page 106 of 214 ends

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

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

TOTAL DEVELOPMENT/TRAFFIC EN 503,472.74 629,870.00 629,870.00 450,856.81 505,620.00 898,020.00 42.6% ____________________________________________
1015401 STREET MAINTENANCE
1015401 5110 BUY BACKS 6,284.44 .00 .00 4,661.07 4,660.00 .00 .0% 1015401 5111 SALARY-FT 260,085.11 332,340.00 332,340.00 272,868.96 324,200.00 378,500.00 13.9% 1015401 5112 SALARY-PT 6,313.35 10,430.00 10,430.00 .00 .00 .00 -100.0% 1015401 5113 OVERTIME 55,386.09 50,000.00 50,000.00 44,568.08 60,000.00 60,000.00 20.0% 1015401 5113 40155 OVERTIME .00 .00 .00 2,402.56 .00 .00 .0% 1015401 5116 FRINGE BEN 84,415.82 104,360.00 104,360.00 71,286.78 91,570.00 121,340.00 16.3% 1015401 5116 40155 FRINGE BEN .00 .00 .00 493.58 .00 .00 .0% 1015401 5117 RETIR CNTR 28,893.34 33,190.00 33,190.00 25,947.18 31,330.00 39,620.00 19.4% 1015401 5119 UAL PERS 49,012.86 .00 .00 .00 .00 .00 .0% 1015401 5215 TRNG/CONF 449.22 .00 .00 .00 .00 .00 .0% 1015401 5217 OTHER SUPP .00 .00 200.00 198.50 .00 .00 -100.0% 1015401 5218 UNIFRM EXP 3,298.46 7,580.00 7,600.00 6,055.00 7,600.00 7,600.00 .0% 1015401 5220 FUEL USAGE 31,264.77 26,500.00 31,500.00 21,741.47 28,000.00 28,000.00 -11.1% 1015401 5223 INFO SYS 4,500.00 .00 .00 .00 .00 .00 .0% 1015401 5224 VEH CHRG 39,310.00 .00 .00 .00 .00 .00 .0% 1015401 5233 OTHR EQUIP 4,993.87 5,000.00 5,000.00 3,000.00 6,000.00 6,000.00 20.0% 1015401 5234 OTH EQ RNT .00 2,000.00 3,000.00 2,609.16 3,000.00 6,000.00 100.0% 1015401 5234 40155 OTH EQ RNT .00 .00 11,500.00 11,400.00 .00 .00 -100.0% 1015401 5247 MAINT-VEH 38.00 .00 .00 .00 .00 .00 .0%

Page 107 of 214 ends

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

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

TOTAL STREET MAINTENANCE 623,404.83 940,720.00 967,220.00 773,442.34 940,680.00 814,240.00 -15.8% ____________________________________________
1015402 STREET SWEEPING
1015402 5111 SALARY-FT 11,426.35 12,180.00 12,180.00 9,608.86 11,620.00 12,530.00 2.9% 1015402 5116 FRINGE BEN 2,257.21 2,350.00 2,350.00 1,815.82 2,240.00 2,380.00 1.3% 1015402 5117 RETIR CNTR 1,314.69 1,270.00 1,270.00 1,001.28 1,210.00 1,370.00 7.9% 1015402 5119 UAL PERS 4,590.44 .00 .00 .00 .00 .00 .0%

TOTAL STREET SWEEPING 19,588.69 15,800.00 15,800.00 12,425.96 15,070.00 16,280.00 3.0% ____________________________________________
1015403 SIDEWALK MAINTENANCE
1015403 5111 SALARY-FT 65,452.36 66,740.00 66,740.00 47,999.57 61,840.00 66,380.00 -.5% 1015403 5112 SALARY-PT 22,855.81 49,920.00 49,920.00 14,925.33 20,790.00 18,970.00 -62.0% 1015403 5113 OVERTIME 6,600.18 5,000.00 5,000.00 7,158.90 5,000.00 5,000.00 .0% 1015403 5113 40155 OVERTIME .00 .00 .00 18,240.84 .00 .00 .0% 1015403 5116 FRINGE BEN 17,947.05 19,780.00 19,780.00 13,309.03 15,150.00 19,570.00 -1.1% 1015403 5116 40155 FRINGE BEN .00 .00 .00 3,591.18 .00 .00 .0% 1015403 5117 RETIR CNTR 7,356.64 6,650.00 6,650.00 5,158.94 6,830.00 6,960.00 4.7% 1015403 5117 40155 RETIR CNTR .00 .00 .00 24.27 .00 .00 .0% 1015403 5119 UAL PERS 20,613.13 .00 .00 .00 .00 .00 .0% 1015403 5215 TRNG/CONF 449.22 .00 .00 48.43 .00 .00 .0% 1015403 5217 OTHER SUPP 16,567.57 20,000.00 20,000.00 16,391.10 25,000.00 25,000.00 25.0% 1015403 5224 VEH CHRG 7,360.00 .00 .00 .00 .00 .00 .0% 1015403 5233 OTHR EQUIP 7,281.26 5,000.00 5,000.00 2,000.00 6,000.00 6,000.00 20.0% 1015403 5702 FLT-MT&RP .00 3,990.00 3,990.00 3,663.00 3,990.00 9,910.00 148.4%

TOTAL SIDEWALK MAINTENANCE 172,483.22 177,080.00 177,080.00 132,510.59 144,600.00 157,790.00 -10.9% ____________________________________________
1015404 STREET LIGHTING
1015404 5111 SALARY-FT 11,426.35 12,180.00 12,180.00 9,608.86 11,620.00 12,530.00 2.9% 1015404 5116 FRINGE BEN 2,257.21 2,350.00 2,350.00 1,815.82 2,240.00 2,380.00 1.3% 1015404 5117 RETIR CNTR 1,314.69 1,270.00 1,270.00 1,001.28 1,210.00 1,370.00 7.9% 1015404 5119 UAL PERS 4,590.44 .00 .00 .00 .00 .00 .0% 1015404 5217 OTHER SUPP 29,905.42 30,000.00 30,000.00 17,000.00 35,000.00 35,000.00 16.7% 1015404 5220 FUEL USAGE 2,123.03 2,300.00 2,800.00 873.27 2,500.00 2,500.00 -10.7% 1015404 5224 VEH CHRG 11,410.00 .00 .00 .00 .00 .00 .0%

Page 108 of 214 ends

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

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

TOTAL STREET LIGHTING 893,032.74 776,860.00 787,360.00 597,413.09 801,330.00 806,770.00 2.5% ____________________________________________
1015405 TRAFFIC CONTROL
1015405 5111 SALARY-FT 69,647.86 73,680.00 73,680.00 19,959.09 30,970.00 65,290.00 -11.4% 1015405 5113 OVERTIME 5,644.90 .00 .00 254.46 550.00 .00 .0% 1015405 5116 FRINGE BEN 19,725.56 22,640.00 22,640.00 4,603.58 6,900.00 22,620.00 -.1% 1015405 5117 RETIR CNTR 7,828.13 7,270.00 7,270.00 1,999.58 3,080.00 6,730.00 -7.4% 1015405 5119 UAL PERS 27,685.63 .00 .00 .00 .00 .00 .0% 1015405 5217 OTHER SUPP 33,158.68 40,000.00 45,000.00 35,000.00 45,000.00 45,000.00 .0% 1015405 5224 VEH CHRG 1,810.00 .00 .00 .00 .00 .00 .0% 1015405 5258 OTHER SVS 466.85 .00 .00 269.50 .00 .00 .0% 1015405 5702 FLT-MT&RP .00 420.00 420.00 385.00 420.00 150.00 -64.3%

TOTAL TRAFFIC CONTROL 165,967.61 144,010.00 149,010.00 62,471.21 86,920.00 139,790.00 -6.2% ____________________________________________
1015406 TRAFFIC FACILITY MAINTENANCE
1015406 5233 OTHR EQUIP 1,718.62 10,000.00 10,000.00 1,203.00 10,000.00 10,000.00 .0% 1015406 5241 UTL-ELECTR 57,968.93 60,000.00 60,000.00 45,564.05 60,000.00 62,000.00 3.3% 1015406 5258 OTHER SVS 212,676.44 187,300.00 187,300.00 186,106.00 187,300.00 202,300.00 8.0%

TOTAL TRAFFIC FACILITY MAINT 272,363.99 257,300.00 257,300.00 232,873.05 257,300.00 274,300.00 6.6% ____________________________________________
1015407 WEED ABATEMENT
1015407 5111 SALARY-FT 5,545.94 .00 .00 .00 .00 .00 .0% 1015407 5113 OVERTIME 130.84 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 1015407 5113 40155 OVERTIME .00 .00 .00 628.19 .00 .00 .0% 1015407 5116 FRINGE BEN 1,266.03 .00 .00 .00 .00 .00 .0% 1015407 5116 40155 FRINGE BEN .00 .00 .00 133.10 .00 .00 .0% 1015407 5117 RETIR CNTR 544.96 .00 .00 .00 .00 .00 .0% 1015407 5119 UAL PERS 1,980.57 .00 .00 .00 .00 .00 .0% 1015407 5217 OTHER SUPP 5,930.13 10,000.00 10,000.00 7,000.00 12,000.00 12,000.00 20.0% 1015407 5220 FUEL USAGE 910.44 2,850.00 2,850.00 671.72 3,000.00 3,000.00 5.3% 1015407 5224 VEH CHRG 6,910.00 .00 .00 .00 .00 .00 .0% 1015407 5233 OTHR EQUIP 4,776.66 5,000.00 5,000.00 1,000.00 6,000.00 6,000.00 20.0% 1015407 5246 MAINT-EQP 242.38 .00 .00 .00 .00 .00 .0%

Page 109 of 214 ends

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

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

TOTAL WEED ABATEMENT 28,237.95 21,940.00 21,940.00 11,809.01 25,590.00 23,770.00 8.3% ____________________________________________
1015408 FLOOD CONTROL
1015408 5217 OTHER SUPP 4,000.50 1,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 1015408 5233 OTHR EQUIP .00 1,000.00 .00 .00 1,000.00 1,000.00 .0%

TOTAL FLOOD CONTROL 4,000.50 2,000.00 2,000.00 .00 3,000.00 3,000.00 50.0% ____________________________________________
1015409 STREET TREE MAINTENANCE
1015409 5111 SALARY-FT 62,128.18 65,180.00 65,180.00 51,414.68 62,840.00 65,460.00 .4% 1015409 5113 OVERTIME 137.16 .00 .00 151.43 330.00 .00 .0% 1015409 5113 40155 OVERTIME .00 .00 .00 3,095.92 .00 .00 .0% 1015409 5116 FRINGE BEN 15,946.56 16,400.00 16,400.00 12,521.79 15,530.00 16,450.00 .3% 1015409 5116 40155 FRINGE BEN .00 .00 .00 659.77 .00 .00 .0% 1015409 5117 RETIR CNTR 7,176.44 6,780.00 6,780.00 5,360.32 6,550.00 7,160.00 5.6% 1015409 5119 UAL PERS 25,030.99 .00 .00 .00 .00 .00 .0% 1015409 5213 DUES&SUBSC 14.00 150.00 150.00 .00 150.00 150.00 .0% 1015409 5215 TRNG/CONF 190.00 .00 .00 .00 .00 .00 .0% 1015409 5217 OTHER SUPP 5.62 .00 .00 .00 .00 .00 .0% 1015409 5253 CONTRC SVS 623,000.00 625,000.00 792,000.00 493,000.00 700,000.00 700,000.00 -11.6% 1015409 5253 40155 CONTRC SVS .00 .00 .00 132,000.00 .00 .00 .0% 1015409 5702 FLT-MT&RP .00 .00 .00 .00 .00 20.00 .0%

TOTAL STREET TREE MAINTENANC 733,628.95 713,510.00 880,510.00 698,203.91 785,400.00 789,240.00 -10.4% ____________________________________________
1015410 PARKWAY MAINTENANCE-ROW
1015410 5110 BUY BACKS .00 .00 .00 2,328.98 2,330.00 .00 .0% 1015410 5111 SALARY-FT 59,037.57 64,970.00 64,970.00 49,833.38 60,440.00 66,420.00 2.2% 1015410 5113 OVERTIME 654.25 1,000.00 1,000.00 .00 5,000.00 5,000.00 400.0% 1015410 5116 FRINGE BEN 13,900.52 18,150.00 18,150.00 10,783.52 13,390.00 18,210.00 .3% 1015410 5117 RETIR CNTR 6,319.77 6,570.00 6,570.00 4,816.11 5,830.00 7,070.00 7.6% 1015410 5119 UAL PERS 22,332.36 .00 .00 .00 .00 .00 .0% 1015410 5217 OTHER SUPP 13,321.04 16,000.00 16,000.00 10,719.58 20,000.00 20,000.00 25.0% 1015410 5220 FUEL USAGE 1,667.06 800.00 1,650.00 1,094.43 1,000.00 1,000.00 -39.4% 1015410 5224 VEH CHRG 1,570.00 .00 .00 .00 .00 .00 .0% 1015410 5233 OTHR EQUIP 2,194.28 12,000.00 11,150.00 4,072.47 10,000.00 10,000.00 -10.3% 1015410 5234 OTH EQ RNT 1,101.07 .00 .00 .00 .00 .00 .0% 1015410 5241 UTL-ELECTR 24,115.15 25,000.00 25,000.00 19,352.02 25,000.00 25,000.00 .0%

Page 110 of 214 ends

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

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

TOTAL PARKWAY MAINTENANCE-RO 459,451.00 440,190.00 545,190.00 497,350.99 504,690.00 958,460.00 75.8% ____________________________________________
1015412 MAINTENANCE-MAIN STREET
1015412 5111 SALARY-FT 30,988.42 32,360.00 32,360.00 8,180.85 17,730.00 25,950.00 -19.8% 1015412 5116 FRINGE BEN 7,966.63 9,180.00 9,180.00 1,335.88 2,890.00 8,640.00 -5.9% 1015412 5117 RETIR CNTR 3,520.66 3,370.00 3,370.00 820.45 1,780.00 2,840.00 -15.7% 1015412 5119 UAL PERS 12,751.12 .00 .00 .00 .00 .00 .0% 1015412 5217 OTHER SUPP 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 .0%

TOTAL MAINTENANCE-MAIN STREE 58,226.83 47,910.00 47,910.00 13,337.18 25,400.00 40,430.00 -15.6% ____________________________________________
1015413 MAINTENANCE-METROLINK STATION
1015413 5111 SALARY-FT 15,323.47 16,230.00 16,230.00 12,824.46 15,560.00 16,580.00 2.2% 1015413 5116 FRINGE BEN 3,307.39 3,410.00 3,410.00 2,643.50 3,260.00 3,450.00 1.2% 1015413 5117 RETIR CNTR 1,765.01 1,690.00 1,690.00 1,336.37 1,620.00 1,810.00 7.1% 1015413 5119 UAL PERS 6,155.69 .00 .00 .00 .00 .00 .0% 1015413 5217 OTHER SUPP 2,969.99 1,000.00 3,000.00 1,000.00 3,000.00 3,000.00 .0% 1015413 5223 INFO SYS 400.00 .00 .00 .00 .00 .00 .0% 1015413 5241 UTL-ELECTR 3,118.28 8,000.00 6,000.00 1,979.11 10,000.00 4,000.00 -33.3% 1015413 5243 UTL-TELEPH .00 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0% 1015413 5243 54130 UTL-TELEPH 912.24 .00 .00 803.16 .00 .00 .0% 1015413 5244 UTL-WATER .00 .00 .00 .00 .00 11,620.00 .0% 1015413 5253 CONTRC SVS 3,107.28 3,110.00 3,110.00 3,110.00 5,000.00 5,000.00 60.8% 1015413 5253 54130 CONTRC SVS 21,902.89 150,000.00 150,000.00 135,305.00 150,000.00 140,000.00 -6.7% 1015413 5255 54130 BANKNG SVS 1,789.21 .00 .00 1,630.83 .00 .00 .0% 1015413 5258 OTHER SVS 778.02 .00 .00 .00 .00 .00 .0% 1015413 5530 54130 MACH&EQUIP .00 20,000.00 20,000.00 .00 20,000.00 .00 -100.0%

TOTAL MAINTENANCE-METROLINK 61,529.47 204,640.00 204,640.00 160,632.43 209,640.00 186,660.00 -8.8% ____________________________________________
1015415 GRAFFITI REMOVAL-PW
1015415 5253 CONTRC SVS 70,018.40 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 .0%

TOTAL GRAFFITI REMOVAL-PW 70,018.40 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 .0% ____________________________________________
1015416 DAMAGE TO CITY PROPERTY
1015416 5217 OTHER SUPP 5,649.59 5,000.00 6,000.00 2,500.00 6,000.00 6,000.00 .0%

Page 111 of 214 ends

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

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

TOTAL DAMAGE TO CITY PROPERT 50,860.09 55,000.00 55,000.00 54,659.39 66,000.00 66,000.00 20.0% ____________________________________________
1015420 PARK MAINTENANCE
1015420 5111 SALARY-FT 97,633.21 103,300.00 103,300.00 88,999.57 111,350.00 106,750.00 3.3% 1015420 5112 SALARY-PT 10,179.99 .00 .00 .00 .00 .00 .0% 1015420 5113 OVERTIME 815.19 10,000.00 10,000.00 2,856.73 5,000.00 5,000.00 -50.0% 1015420 5116 FRINGE BEN 20,081.45 31,800.00 31,800.00 15,530.40 20,300.00 31,910.00 .3% 1015420 5117 RETIR CNTR 10,020.09 10,300.00 10,300.00 8,243.53 10,400.00 11,220.00 8.9% 1015420 5119 UAL PERS 14,983.18 .00 .00 .00 .00 .00 .0% 1015420 5213 DUES&SUBSC .00 .00 .00 98.00 .00 .00 .0% 1015420 5215 TRNG/CONF .00 .00 .00 1,938.34 .00 .00 .0% 1015420 5217 OTHER SUPP 18,746.30 25,000.00 25,000.00 20,531.33 30,000.00 30,000.00 20.0% 1015420 5218 UNIFRM EXP 4,917.56 6,620.00 7,000.00 6,290.57 7,000.00 7,000.00 .0% 1015420 5220 FUEL USAGE 8,251.75 10,000.00 10,000.00 5,258.96 12,000.00 12,000.00 20.0% 1015420 5223 INFO SYS 3,750.00 .00 .00 .00 .00 .00 .0% 1015420 5224 VEH CHRG 17,440.00 .00 .00 .00 .00 .00 .0% 1015420 5225 BLDG MT&OP 20,000.00 .00 .00 .00 .00 .00 .0% 1015420 5231 FURN&OFFC .00 .00 2,000.00 1,842.40 .00 .00 -100.0% 1015420 5233 OTHR EQUIP 9,566.34 5,000.00 6,000.00 5,039.18 6,000.00 6,000.00 .0% 1015420 5241 UTL-ELECTR 25,522.49 30,000.00 26,620.00 18,537.58 30,000.00 27,000.00 1.4% 1015420 5242 UTL-GAS 150.80 250.00 250.00 60.12 250.00 250.00 .0% 1015420 5244 UTL-WATER .00 .00 .00 .00 .00 283,100.00 .0% 1015420 5253 CONTRC SVS 274,961.56 271,000.00 271,000.00 271,000.00 340,000.00 340,000.00 25.5% 1015420 5258 OTHER SVS 24,397.13 15,000.00 25,000.00 14,350.00 20,000.00 20,000.00 -20.0% 1015420 5702 FLT-MT&RP .00 15,900.00 15,900.00 14,575.00 15,900.00 19,580.00 23.1% 1015420 5704 BDG MT ALC .00 35,000.00 35,000.00 32,087.00 35,000.00 16,000.00 -54.3%

TOTAL PARK MAINTENANCE 561,417.04 569,170.00 579,170.00 507,238.71 643,200.00 915,810.00 58.1% ____________________________________________
1015421 SPORTS FIELD MAINTENANCE
1015421 5111 SALARY-FT 65,521.68 80,020.00 80,020.00 60,780.21 75,780.00 81,050.00 1.3% 1015421 5113 OVERTIME 2,501.03 1,000.00 1,000.00 1,012.46 3,000.00 3,000.00 200.0% 1015421 5116 FRINGE BEN 19,261.97 23,690.00 23,690.00 15,333.99 20,320.00 23,730.00 .2% 1015421 5117 RETIR CNTR 7,528.90 8,160.00 8,160.00 6,301.47 7,860.00 8,690.00 6.5% 1015421 5119 UAL PERS 21,337.14 .00 .00 .00 .00 .00 .0% 1015421 5217 OTHER SUPP 755.68 3,500.00 13,500.00 2,125.00 15,000.00 8,000.00 -40.7% 1015421 5233 OTHR EQUIP 2,892.58 1,000.00 4,000.00 3,900.00 12,000.00 6,000.00 50.0% 1015421 5234 OTH EQ RNT 3,412.44 .00 .00 .00 .00 .00 .0% 1015421 5241 UTL-ELECTR 32,280.83 32,000.00 37,000.00 34,860.72 34,000.00 34,000.00 -8.1% 1015421 5244 UTL-WATER .00 .00 .00 .00 .00 149,870.00 .0%

Page 112 of 214 ends

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

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

TOTAL SPORTS FIELD MAINTENAN 225,281.00 221,370.00 247,370.00 199,263.85 262,960.00 409,340.00 65.5% ____________________________________________
1015601 CITY HALL
1015601 5217 OTHER SUPP 62.00 1,000.00 1,000.00 .00 2,000.00 2,000.00 100.0% 1015601 5220 FUEL USAGE 2,932.17 4,000.00 4,500.00 2,852.39 4,500.00 4,500.00 .0% 1015601 5223 INFO SYS 2,600.00 .00 .00 .00 .00 .00 .0% 1015601 5224 VEH CHRG 5,530.00 .00 .00 .00 .00 .00 .0% 1015601 5225 BLDG MT&OP 248,730.00 .00 .00 .00 .00 .00 .0% 1015601 5241 UTL-ELECTR 35,708.91 39,000.00 39,000.00 34,311.85 40,000.00 40,000.00 2.6% 1015601 5242 UTL-GAS 7,301.51 9,800.00 9,300.00 5,149.69 10,000.00 10,000.00 7.5% 1015601 5244 UTL-WATER .00 .00 .00 .00 .00 35,310.00 .0% 1015601 5702 FLT-MT&RP .00 10,650.00 10,650.00 9,768.00 10,650.00 7,430.00 -30.2% 1015601 5703 VEH ACQ .00 31,250.00 31,250.00 28,644.00 31,250.00 .00 -100.0% 1015601 5704 BDG MT ALC .00 96,860.00 96,860.00 88,792.00 96,860.00 100,220.00 3.5%

TOTAL CITY HALL 302,864.59 192,560.00 192,560.00 169,517.93 195,260.00 199,460.00 3.6% TOTAL GENERAL FUND 43,802,918.70 45,963,110.00 58,579,332.00 71,505,015.41 45,669,137.90 50,051,500.00 -14.6%

Page 113 of 214 ends

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

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

TOTAL HOUSING FUND 50,865.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2012931 HOUSING PROGRAM
2012931 5110 BUY BACKS 2,227.63 2,300.00 2,300.00 5,045.09 5,050.00 5,300.00 130.4% 2012931 5111 SALARY-FT 449,209.67 452,980.00 459,707.00 294,897.58 355,950.00 438,490.00 -4.6% 2012931 5111 16110 SALARY-FT 269.36 .00 .00 .00 .00 .00 .0% 2012931 5111 16111 SALARY-FT 227.89 .00 .00 .00 .00 .00 .0% 2012931 5111 50105 SALARY-FT 55.74 .00 .00 .00 .00 .00 .0% 2012931 5112 SALARY-PT 10,724.44 9,030.00 9,030.00 767.30 .00 9,030.00 .0% 2012931 5113 OVERTIME -21.49 .00 .00 191.09 500.00 1,000.00 .0% 2012931 5116 FRINGE BEN 95,253.92 113,050.00 114,798.00 64,753.77 77,470.00 104,600.00 -8.9% 2012931 5116 16110 FRINGE BEN 60.09 .00 .00 .00 .00 .00 .0% 2012931 5116 16111 FRINGE BEN 40.33 .00 .00 .00 .00 .00 .0% 2012931 5116 50105 FRINGE BEN 13.04 .00 .00 .00 .00 .00 .0% 2012931 5117 RETIR CNTR 46,827.82 46,950.00 47,624.00 28,546.73 33,890.00 46,210.00 -3.0% 2012931 5117 16110 RETIR CNTR 29.27 .00 .00 .00 .00 .00 .0% 2012931 5117 16111 RETIR CNTR 23.25 .00 .00 .00 .00 .00 .0% 2012931 5117 50105 RETIR CNTR 5.92 .00 .00 .00 .00 .00 .0% 2012931 5119 UAL PERS 127,358.70 .00 .00 .00 .00 .00 .0% 2012931 5119 16110 UAL PERS 72.13 .00 .00 .00 .00 .00 .0% 2012931 5119 16111 UAL PERS 73.49 .00 .00 .00 .00 .00 .0% 2012931 5119 50105 UAL PERS 14.68 .00 .00 .00 .00 .00 .0% 2012931 5211 POSTAGE .00 100.00 100.00 17.12 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 .00 500.00 500.00 380.00 680.00 680.00 36.0% 2012931 5215 TRNG/CONF .00 4,000.00 4,000.00 205.75 3,500.00 3,650.00 -8.8% 2012931 5216 OFFIC SUPP 773.55 1,000.00 1,000.00 436.85 1,000.00 1,000.00 .0% 2012931 5217 OTHER SUPP 323.74 500.00 500.00 263.36 500.00 500.00 .0% 2012931 5218 UNIFRM EXP 36.63 .00 .00 .00 .00 .00 .0% 2012931 5221 MILE REIMB 77.97 500.00 500.00 54.52 250.00 250.00 -50.0% 2012931 5222 PRNT/MAIL .00 200.00 200.00 105.59 200.00 250.00 25.0% 2012931 5223 INFO SYS 23,530.00 .00 .00 .00 .00 .00 .0% 2012931 5232 COMP EQUIP 2,741.57 .00 .00 19.38 20.00 100.00 .0% 2012931 5233 OTHR EQUIP .00 .00 .00 59.61 55.00 500.00 .0% 2012931 5243 UTL-TELEPH 1,035.54 1,200.00 1,200.00 1,550.95 1,500.00 2,500.00 108.3% 2012931 5245 MAINT-BLDG .00 200.00 200.00 .00 100.00 .00 -100.0% 2012931 5251 LEGAL SVS 3,740.50 10,000.00 10,000.00 259.50 15,000.00 15,000.00 50.0% 2012931 5252 PROF SVS 166,513.16 298,250.00 298,250.00 211,132.50 345,370.00 318,400.00 6.8%

Page 114 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
HOUSING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 2012931 5253 CONTRC SVS 250.00 .00 .00 250.00 250.00 700.00 .0% 2012931 5258 OTHER SVS 661.72 1,612,000.00 1,612,000.00 15,018.88 1,612,900.00 1,605,180.00 -.4% 2012931 5273 WK CMP CHG 44,310.00 .00 .00 .00 .00 .00 .0% 2012931 5274 UNEMPL CHG 1,490.00 .00 .00 .00 .00 .00 .0% 2012931 5275 LT DIS CHG 2,880.00 .00 .00 .00 .00 .00 .0% 2012931 5276 LIAB CHG 56,250.00 .00 .00 .00 .00 .00 .0% 2012931 5277 LOSS PREV 2,880.00 .00 .00 .00 .00 .00 .0% 2012931 5324 OPEB 17,460.00 .00 .00 .00 .00 .00 .0% 2012931 5424 BND PRNCPL 556,924.61 581,770.00 581,770.00 472,909.12 581,770.00 654,065.00 12.4% 2012931 5425 BND INT EX 524,987.35 500,150.00 500,150.00 299,400.21 500,150.00 375,685.00 -24.9% 2012931 5601 LN ACTV 154,410.00 .00 .00 .00 .00 .00 .0% 2012931 5701 INFO SYS .00 34,110.00 34,110.00 31,273.00 34,110.00 44,770.00 31.3% 2012931 5704 BDG MT ALC .00 6,260.00 6,260.00 5,742.00 6,260.00 .00 -100.0% 2012931 5705 SF LIAB .00 111,480.00 111,480.00 102,190.00 111,480.00 136,020.00 22.0% 2012931 5706 OPB&BN ALC .00 19,970.00 24,120.00 18,260.00 19,970.00 18,310.00 -24.1% 2012931 5707 PERSUALALC .00 131,910.00 131,910.00 120,890.00 131,910.00 174,050.00 31.9%

TOTAL HOUSING PROGRAM 2,293,742.22 3,941,910.00 3,955,209.00 1,678,119.90 3,843,435.00 3,959,840.00 .1% TOTAL HOUSING FUND 2,344,607.22 3,941,910.00 3,955,209.00 1,678,119.90 3,843,435.00 3,959,840.00 .1%

Page 115 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
HOUSING FUND - RENTALS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2020000 HOUSING FUND - RENTALS
2020000 5070 TRNSFR OUT 2,448,983.03 .00 .00 2,142,214.97 .00 .00 .0%

TOTAL HOUSING FUND - RENTALS 2,448,983.03 .00 .00 2,142,214.97 .00 .00 .0% ____________________________________________
2022931 HOUSING PROGRAM
2022931 5201 PRSNL REIM 501,959.43 .00 .00 119,202.07 .00 .00 .0% 2022931 5212 ADVERTISNG 19,775.51 .00 .00 10,271.23 .00 .00 .0% 2022931 5213 DUES&SUBSC 19,383.89 .00 .00 5,746.30 .00 .00 .0% 2022931 5215 TRNG/CONF 160.77 .00 .00 .00 .00 .00 .0% 2022931 5216 OFFIC SUPP 16,110.83 .00 .00 4,620.46 .00 .00 .0% 2022931 5221 MILE REIMB 110.89 .00 .00 .00 .00 .00 .0% 2022931 5240 UTL-TRASH 83,785.69 .00 .00 20,147.44 .00 .00 .0% 2022931 5241 UTL-ELECTR 36,552.93 .00 .00 13,113.06 .00 .00 .0% 2022931 5242 UTL-GAS 69,606.05 .00 .00 16,325.26 .00 .00 .0% 2022931 5243 UTL-TELEPH 14,629.00 .00 .00 3,369.88 .00 .00 .0% 2022931 5244 UTL-WATER 200,041.27 .00 .00 64,817.25 .00 .00 .0% 2022931 5245 MAINT-BLDG 506,092.18 .00 .00 113,595.96 .00 .00 .0% 2022931 5251 LEGAL SVS 188.29 .00 .00 774.27 .00 .00 .0% 2022931 5252 PROF SVS 208,097.91 .00 .00 52,930.38 .00 .00 .0% 2022931 5255 BANKNG SVS 10,851.98 .00 .00 3,321.92 .00 .00 .0% 2022931 5258 OTHER SVS 135,793.31 .00 .00 31,583.42 .00 .00 .0% 2022931 5278 LEGL SV CH 10,652.50 .00 .00 200.00 .00 .00 .0%

TOTAL HOUSING PROGRAM 1,833,792.43 .00 .00 460,018.90 .00 .00 .0% TOTAL HOUSING FUND - RENTALS 4,282,775.46 .00 .00 2,602,233.87 .00 .00 .0%

Page 116 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
PUB SAFETY AUGMENTATION ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2033211 POLICE PATROL
2033211 5110 BUY BACKS 831.08 .00 .00 2,543.10 2,540.00 .00 .0% 2033211 5116 FRINGE BEN 18.83 .00 .00 .00 .00 .00 .0% 2033211 5131 SAL-SW PD 846,313.16 754,550.00 754,550.00 465,993.98 754,550.00 983,030.00 30.3% 2033211 5131 16111 SAL-SW PD 13,765.49 .00 .00 .00 .00 .00 .0% 2033211 5131 40155 SAL-SW PD .00 .00 .00 282.57 .00 .00 .0% 2033211 5133 OT-SW PD 5,946.85 301,920.00 301,920.00 39,978.02 301,920.00 88,480.00 -70.7% 2033211 5136 FRG B-S PD 64,700.43 147,520.00 147,520.00 75,454.36 147,520.00 186,300.00 26.3% 2033211 5136 16111 FRG B-S PD 1,581.60 .00 .00 .00 .00 .00 .0% 2033211 5136 40155 FRG B-S PD .00 .00 .00 42.70 .00 .00 .0% 2033211 5137 RT CNTR-PD 86,754.56 135,890.00 135,890.00 90,880.41 135,890.00 164,890.00 21.3% 2033211 5137 16111 RT CNTR-PD 2,544.39 .00 .00 .00 .00 .00 .0% 2033211 5137 40155 RT CNTR-PD .00 .00 .00 51.40 .00 .00 .0% 2033211 5139 UAL PD SWR 34,125.33 .00 .00 .00 .00 .00 .0% 2033211 5139 16111 UAL PD SWR 1,379.95 .00 .00 .00 .00 .00 .0%

TOTAL POLICE PATROL 1,057,961.67 1,339,880.00 1,339,880.00 675,226.54 1,342,420.00 1,422,700.00 6.2% TOTAL PUB SAFETY AUGMENTATIO 1,057,961.67 1,339,880.00 1,339,880.00 675,226.54 1,342,420.00 1,422,700.00 6.2%

Page 117 of 214 ends

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

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

TOTAL ACCOUNTING SERVICES 4,853.27 6,210.00 6,210.00 4,300.16 6,310.00 6,310.00 1.6% ____________________________________________
2045000 NEW CIP
2045000 5258 OTHER SVS .00 .00 .00 .00 1,013,090.00 1,400,000.00 .0%

TOTAL NEW CIP .00 .00 .00 .00 1,013,090.00 1,400,000.00 .0% ____________________________________________
2045201 GAS TAX ADMINITRATION
2045201 5292 ADM SV EXP 257,134.00 257,130.00 327,290.00 257,130.00 327,290.00 327,290.00 .0%

TOTAL GAS TAX ADMINITRATION 257,134.00 257,130.00 327,290.00 257,130.00 327,290.00 327,290.00 .0% ____________________________________________
2045301 ENGINEERING ADMINISTRATION
2045301 5111 SALARY-FT 372.14 138,230.00 138,230.00 29,182.80 29,550.00 138,230.00 .0% 2045301 5116 FRINGE BEN 80.23 29,320.00 29,320.00 5,713.09 6,000.00 29,350.00 .1% 2045301 5117 RETIR CNTR 38.13 14,380.00 14,380.00 2,989.91 3,010.00 15,130.00 5.2% 2045301 5706 OPB&BN ALC .00 5,490.00 6,420.00 5,060.00 5,490.00 4,760.00 -25.9% 2045301 5707 PERSUALALC .00 40,180.00 40,180.00 36,850.00 40,180.00 47,440.00 18.1%

TOTAL ENGINEERING ADMINISTRA 490.50 227,600.00 228,530.00 79,795.80 84,230.00 234,910.00 2.8% ____________________________________________
2045401 STREET MAINTENANCE-GAS TAX
2045401 5217 OTHER SUPP 47,197.53 50,000.00 50,000.00 50,003.85 50,000.00 50,000.00 .0% 2045401 5233 OTHR EQUIP .00 .00 .00 1,071.17 .00 .00 .0% 2045401 5258 OTHER SVS 1,140.00 .00 .00 .00 .00 .00 .0%

TOTAL STREET MAINTENANCE-GAS 48,337.53 50,000.00 50,000.00 51,075.02 50,000.00 50,000.00 .0% ____________________________________________
2045404 STREET LIGHTING-GAS TAX
2045404 5241 UTL-ELECTR .00 100,000.00 100,000.00 99,974.49 100,000.00 100,000.00 .0%

TOTAL STREET LIGHTING-GAS TA .00 100,000.00 100,000.00 99,974.49 100,000.00 100,000.00 .0% ____________________________________________
2045409 STREET TREE MAINTENANCE-GAS TX
2045409 5253 CONTRC SVS 99,999.60 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 .0%

Page 118 of 214 ends

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

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

TOTAL STREET TREE MAINTENANC 99,999.60 100,000.00 100,000.00 100,000.00 100,000.00 100,000.00 .0% ____________________________________________
2045410 PARKWAY MAINTENANCE-ROW-GAS TX
2045410 5253 CONTRC SVS 49,999.20 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 .0%

TOTAL PARKWAY MAINTENANCE-RO 49,999.20 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 .0% ____________________________________________
2047003 PAVEMENT MANAGEMENT
2047003 5111 SALARY-FT 3,895.70 .00 .00 2,064.72 2,990.00 .00 .0% 2047003 5116 FRINGE BEN 754.42 .00 .00 379.66 530.00 .00 .0% 2047003 5117 RETIR CNTR 449.01 .00 .00 215.12 310.00 .00 .0% 2047003 5119 UAL PERS 1,210.93 .00 .00 .00 .00 .00 .0% 2047003 5254 DATA P SVS 3,180.00 .00 .00 .00 .00 .00 .0% 2047003 5258 OTHER SVS 4,425.00 135,490.00 131,955.00 3,000.00 5,010.00 161,630.00 22.5%

TOTAL PAVEMENT MANAGEMENT 13,915.06 135,490.00 131,955.00 5,659.50 8,840.00 161,630.00 22.5% ____________________________________________
2047031 TRAFFIC SAFETY PRJCT 08-09
2047031 5111 SALARY-FT 1,665.33 .00 .00 676.93 1,470.00 .00 .0% 2047031 5116 FRINGE BEN 359.80 .00 .00 108.49 240.00 .00 .0% 2047031 5117 RETIR CNTR 191.98 .00 .00 70.54 150.00 .00 .0% 2047031 5119 UAL PERS 518.69 .00 .00 .00 .00 .00 .0% 2047031 5252 PROF SVS 3,748.00 .00 .00 .00 .00 .00 .0% 2047031 5258 OTHER SVS 580.00 72,150.00 69,446.00 27,802.75 2,250.00 67,200.00 -3.2%

TOTAL TRAFFIC SAFETY PRJCT 0 7,063.80 72,150.00 69,446.00 28,658.71 4,110.00 67,200.00 -3.2% ____________________________________________
2047067 CW CRCK SL/ SLR SL/ RB FY18
2047067 5111 SALARY-FT 65.52 .00 .00 .00 .00 .00 .0% 2047067 5116 FRINGE BEN 13.20 .00 .00 .00 .00 .00 .0% 2047067 5117 RETIR CNTR 7.58 .00 .00 .00 .00 .00 .0% 2047067 5119 UAL PERS 21.13 .00 .00 .00 .00 .00 .0%

TOTAL CW CRCK SL/ SLR SL/ RB 107.43 .00 .00 .00 .00 .00 .0% ____________________________________________
2047069 ARROW HIGHWAY REHAB (BENS-MTN)
2047069 5111 SALARY-FT 6,934.29 .00 .00 2,898.38 4,970.00 .00 .0% 2047069 5116 FRINGE BEN 1,492.22 .00 .00 581.73 1,060.00 .00 .0%

Page 119 of 214 ends

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

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

TOTAL ARROW HIGHWAY REHAB (B 95,218.15 1,125,050.00 1,094,832.00 16,504.69 10,310.00 1,391,070.00 27.1% ____________________________________________
2047070 CW CONCRETE MAINT 18/19
2047070 5111 SALARY-FT 32.76 .00 .00 .00 .00 .00 .0% 2047070 5116 FRINGE BEN 6.61 .00 .00 .00 .00 .00 .0% 2047070 5117 RETIR CNTR 3.79 .00 .00 .00 .00 .00 .0% 2047070 5119 UAL PERS 10.56 .00 .00 .00 .00 .00 .0% 2047070 5258 OTHER SVS 209,468.00 74,340.00 74,340.00 .00 .00 .00 -100.0%

TOTAL CW CONCRETE MAINT 18/1 209,521.72 74,340.00 74,340.00 .00 .00 .00 -100.0% ____________________________________________
2047071 CW CONCRETE REPAIRS 18/19
2047071 5111 SALARY-FT 26,554.05 .00 .00 747.18 1,620.00 .00 .0% 2047071 5113 OVERTIME .00 .00 .00 116.45 250.00 .00 .0% 2047071 5116 FRINGE BEN 5,791.81 .00 .00 86.04 190.00 .00 .0% 2047071 5117 RETIR CNTR 3,056.53 .00 .00 77.86 170.00 .00 .0% 2047071 5119 UAL PERS 987.68 .00 .00 .00 .00 .00 .0% 2047071 5212 ADVERTISNG 3,312.20 .00 .00 .00 .00 .00 .0% 2047071 5258 OTHER SVS 329,371.61 22,560.00 17,696.00 .00 1,030.00 .00 -100.0%

TOTAL CW CONCRETE REPAIRS 18 369,073.88 22,560.00 17,696.00 1,027.53 3,260.00 .00 -100.0% ____________________________________________
2047072 CW CRACK SEAL/SLURR OVRLY 1819
2047072 5258 OTHER SVS 29.00 .00 .00 .00 .00 .00 .0%

TOTAL CW CRACK SEAL/SLURR OV 29.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2047075 7TH ST REHAB (SA TO EUCLID)
2047075 5111 SALARY-FT 17,519.15 .00 .00 .00 .00 .00 .0% 2047075 5113 OVERTIME 114.17 .00 .00 .00 .00 .00 .0% 2047075 5116 FRINGE BEN 2,328.92 .00 .00 .00 .00 .00 .0% 2047075 5117 RETIR CNTR 2,013.83 .00 .00 .00 .00 .00 .0% 2047075 5119 UAL PERS 2,488.76 .00 .00 .00 .00 .00 .0% 2047075 5217 OTHER SUPP 8.71 .00 .00 .00 .00 .00 .0% 2047075 5258 OTHER SVS 665,538.63 .00 .00 .00 .00 .00 .0%

TOTAL 7TH ST REHAB (SA TO EU 690,012.17 .00 .00 .00 .00 .00 .0% ____________________________________________
2047076 ALPINE ST REHAB (WEST TO PALM)
2047076 5111 SALARY-FT 6,268.55 .00 .00 2,981.62 4,570.00 .00 .0%

Page 120 of 214 ends

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

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

TOTAL ALPINE ST REHAB (WEST 29,739.49 696,620.00 684,681.00 16,196.50 18,120.00 672,360.00 -1.8% ____________________________________________
2047077 VERNON DR (WEST TO PALM)
2047077 5111 SALARY-FT 4,080.40 .00 .00 2,726.11 4,230.00 .00 .0% 2047077 5116 FRINGE BEN 867.05 .00 .00 543.02 900.00 .00 .0% 2047077 5117 RETIR CNTR 471.66 .00 .00 284.03 440.00 .00 .0% 2047077 5119 UAL PERS 1,268.86 .00 .00 .00 .00 .00 .0% 2047077 5258 OTHER SVS 19,692.66 380,240.00 368,389.00 12,307.34 11,890.00 356,320.00 -3.3%

TOTAL VERNON DR (WEST TO PAL 26,380.63 380,240.00 368,389.00 15,860.50 17,460.00 356,320.00 -3.3% ____________________________________________
2047078 PALM AVE (9TH ST TO ARROW HWY)
2047078 5111 SALARY-FT 4,049.89 .00 .00 2,993.15 4,780.00 .00 .0% 2047078 5116 FRINGE BEN 860.15 .00 .00 594.00 1,010.00 .00 .0% 2047078 5117 RETIR CNTR 468.10 .00 .00 311.86 500.00 .00 .0% 2047078 5119 UAL PERS 1,259.01 .00 .00 .00 .00 .00 .0% 2047078 5258 OTHER SVS 19,692.68 770,270.00 758,440.00 14,071.96 12,210.00 744,260.00 -1.9%

TOTAL PALM AVE (9TH ST TO AR 26,329.83 770,270.00 758,440.00 17,970.97 18,500.00 744,260.00 -1.9% ____________________________________________
2047079 CW CONCRETE MAINT 19/20
2047079 5258 OTHER SVS 300,000.00 .00 .00 .00 .00 .00 .0%

TOTAL CW CONCRETE MAINT 19/2 300,000.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2047080 CW CONCRETE REPAIR 19/20
2047080 5258 OTHER SVS 357,722.39 47,110.00 32,288.00 .00 .00 .00 -100.0%

TOTAL CW CONCRETE REPAIR 19/ 357,722.39 47,110.00 32,288.00 .00 .00 .00 -100.0% ____________________________________________
2047500 CAPITAL PROJECTS
2047500 5111 70003 SALARY-FT 7,330.61 .00 .00 13,406.71 12,030.00 .00 .0% 2047500 5111 70004 SALARY-FT 10,218.06 .00 .00 21,144.76 20,340.00 .00 .0% 2047500 5111 70005 SALARY-FT 32.76 .00 .00 .00 .00 .00 .0%

Page 121 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GAS TAX ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 2047500 5111 70007 SALARY-FT .00 .00 .00 868.73 1,740.00 .00 .0% 2047500 5111 70008 SALARY-FT .00 .00 .00 83.53 .00 .00 .0% 2047500 5111 70011 SALARY-FT .00 .00 .00 150.36 .00 .00 .0% 2047500 5116 70003 FRINGE BEN 1,745.31 .00 .00 3,110.76 2,690.00 .00 .0% 2047500 5116 70004 FRINGE BEN 2,486.94 .00 .00 4,775.12 4,520.00 .00 .0% 2047500 5116 70005 FRINGE BEN 6.61 .00 .00 .00 .00 .00 .0% 2047500 5116 70007 FRINGE BEN .00 .00 .00 161.09 350.00 .00 .0% 2047500 5116 70008 FRINGE BEN .00 .00 .00 16.29 .00 .00 .0% 2047500 5116 70011 FRINGE BEN .00 .00 .00 29.32 .00 .00 .0% 2047500 5117 70003 RETIR CNTR 846.16 .00 .00 1,396.96 1,250.00 .00 .0% 2047500 5117 70004 RETIR CNTR 1,179.36 .00 .00 2,203.27 2,120.00 .00 .0% 2047500 5117 70005 RETIR CNTR 3.79 .00 .00 .00 .00 .00 .0% 2047500 5117 70007 RETIR CNTR .00 .00 .00 90.52 180.00 .00 .0% 2047500 5117 70008 RETIR CNTR .00 .00 .00 8.70 .00 .00 .0% 2047500 5117 70011 RETIR CNTR .00 .00 .00 15.66 .00 .00 .0% 2047500 5119 70003 UAL PERS 47.53 .00 .00 .00 .00 .00 .0% 2047500 5119 70005 UAL PERS 10.56 .00 .00 .00 .00 .00 .0% 2047500 5212 70004 ADVERTISNG .00 .00 .00 3,542.30 .00 .00 .0% 2047500 5219 70004 PERM/LC/FE .00 .00 .00 50.00 .00 .00 .0% 2047500 5258 70001 OTHER SVS 299,992.00 .00 .00 .00 .00 .00 .0% 2047500 5258 70002 OTHER SVS .00 300,000.00 300,000.00 265,800.00 263,920.00 .00 -100.0% 2047500 5258 70003 OTHER SVS .00 196,790.00 190,030.00 .00 15,070.00 174,960.00 -7.9% 2047500 5258 70004 OTHER SVS .00 491,180.00 486,116.00 392,556.14 181,110.00 305,010.00 -37.3% 2047500 5258 70005 OTHER SVS .00 109,950.00 109,950.00 .00 .00 109,950.00 .0% 2047500 5258 70007 OTHER SVS .00 1,000,000.00 1,000,000.00 .00 1,120.00 1,255,000.00 25.5% 2047500 5258 70008 OTHER SVS .00 500,000.00 500,000.00 500,000.00 500,000.00 .00 -100.0% 2047500 5258 70009 OTHER SVS .00 150,000.00 150,000.00 .00 .00 150,000.00 .0% 2047500 5258 70010 OTHER SVS .00 500,000.00 500,000.00 392,375.53 .00 500,000.00 .0% 2047500 5258 70011 OTHER SVS .00 550,000.00 550,000.00 .00 .00 .00 -100.0%

TOTAL CAPITAL PROJECTS 323,899.69 3,797,920.00 3,786,096.00 1,601,785.75 1,006,440.00 2,494,920.00 -34.1% ____________________________________________
2048617 ARROW RTW WDNG
2048617 5258 OTHER SVS .00 249,480.00 249,480.00 .00 .00 99,480.00 -60.1%

TOTAL ARROW RTW WDNG .00 249,480.00 249,480.00 .00 .00 99,480.00 -60.1% ____________________________________________
2049124 ARRW HWY REHAB (MNT TO SA)
2049124 5111 SALARY-FT 5,509.85 .00 .00 2,795.97 4,750.00 .00 .0% 2049124 5116 FRINGE BEN 1,209.99 .00 .00 564.44 1,020.00 .00 .0% 2049124 5117 RETIR CNTR 636.64 .00 .00 291.31 490.00 .00 .0% 2049124 5119 UAL PERS 1,758.32 .00 .00 .00 .00 .00 .0%

Page 122 of 214 ends

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

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

TOTAL ARRW HWY REHAB (MNT TO 92,892.20 973,710.00 945,818.00 16,374.32 9,890.00 1,242,170.00 31.3% TOTAL GAS TAX 3,002,719.54 9,135,880.00 9,075,491.00 2,362,313.94 2,827,850.00 9,497,920.00 4.7%

Page 123 of 214 ends

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

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

TOTAL NEW CIP .00 .00 .00 .00 1,046,240.00 2,200,000.00 .0% ____________________________________________
2055201 MEASURE I ADMINISTRATION
2055201 5292 ADM SV EXP 187,714.00 187,720.00 238,410.00 187,720.00 238,410.00 238,410.00 .0%

TOTAL MEASURE I ADMINISTRATI 187,714.00 187,720.00 238,410.00 187,720.00 238,410.00 238,410.00 .0% ____________________________________________
2055301 ENGINEERING ADMINISTRATION
2055301 5111 SALARY-FT 256.69 107,720.00 107,720.00 20,020.82 19,900.00 107,720.00 .0% 2055301 5116 FRINGE BEN 55.74 23,080.00 23,080.00 3,993.16 4,150.00 23,110.00 .1% 2055301 5117 RETIR CNTR 26.42 11,210.00 11,210.00 2,058.22 2,040.00 11,790.00 5.2% 2055301 5706 OPB&BN ALC .00 4,330.00 5,080.00 3,960.00 4,330.00 3,760.00 -26.0% 2055301 5707 PERSUALALC .00 31,470.00 31,470.00 28,820.00 31,470.00 36,870.00 17.2%

TOTAL ENGINEERING ADMINISTRA 338.85 177,810.00 178,560.00 58,852.20 61,890.00 183,250.00 2.6% ____________________________________________
2057339 CAMPUS AVE RHB (CL TO FTHLL)
2057339 5111 SALARY-FT 4,327.03 .00 .00 3,516.95 7,410.00 .00 .0% 2057339 5116 FRINGE BEN 1,102.02 .00 .00 797.00 1,720.00 .00 .0% 2057339 5117 RETIR CNTR 499.69 .00 .00 366.48 770.00 .00 .0% 2057339 5258 OTHER SVS .00 1,571,280.00 1,570,561.00 .00 4,680.00 1,565,890.00 -.3%

TOTAL CAMPUS AVE RHB (CL TO 5,928.74 1,571,280.00 1,570,561.00 4,680.43 14,580.00 1,565,890.00 -.3% ____________________________________________
2057340 17TH ST RECNSTRTN (SA TO EUCL)
2057340 5111 SALARY-FT 5,826.76 .00 .00 9,520.50 16,080.00 .00 .0% 2057340 5116 FRINGE BEN 1,427.02 .00 .00 2,242.77 3,900.00 .00 .0% 2057340 5117 RETIR CNTR 673.17 .00 .00 992.00 1,670.00 .00 .0% 2057340 5119 UAL PERS 132.04 .00 .00 .00 .00 .00 .0% 2057340 5258 OTHER SVS 31,325.00 623,450.00 612,766.00 17,110.00 24,820.00 897,920.00 46.5%

TOTAL 17TH ST RECNSTRTN (SA 39,383.99 623,450.00 612,766.00 29,865.27 46,470.00 897,920.00 46.5% ____________________________________________
2057341 SBV COORDINATED TRAFFIC SIGNAL
2057341 5111 SALARY-FT 98.28 .00 .00 .00 .00 .00 .0%

Page 124 of 214 ends

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

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

TOTAL SBV COORDINATED TRAFFI 161.15 6,840.00 6,840.00 .00 .00 .00 -100.0% ____________________________________________
2057343 19TH ST RECONSTRUCT-MTN TO EUC
2057343 5258 OTHER SVS .00 1,450,000.00 1,450,000.00 .00 .00 1,450,000.00 .0%

TOTAL 19TH ST RECONSTRUCT-MT .00 1,450,000.00 1,450,000.00 .00 .00 1,450,000.00 .0% ____________________________________________
2057345 GROVE AVE REHAB (FTHL & 15TH)
2057345 5111 SALARY-FT 3,230.73 .00 .00 109.99 130.00 .00 .0% 2057345 5116 FRINGE BEN 633.73 .00 .00 23.08 30.00 .00 .0% 2057345 5117 RETIR CNTR 373.44 .00 .00 11.46 10.00 .00 .0% 2057345 5119 UAL PERS 1,033.87 .00 .00 .00 .00 .00 .0% 2057345 5258 OTHER SVS .00 1,189,850.00 1,189,378.00 .00 80.00 1,479,300.00 24.4%

TOTAL GROVE AVE REHAB (FTHL 5,271.77 1,189,850.00 1,189,378.00 144.53 250.00 1,479,300.00 24.4% ____________________________________________
2057346 CW PAVEMENT MAINT 19/20
2057346 5111 SALARY-FT 524.12 .00 .00 .00 .00 .00 .0% 2057346 5116 FRINGE BEN 105.62 .00 .00 .00 .00 .00 .0% 2057346 5117 RETIR CNTR 60.63 .00 .00 .00 .00 .00 .0% 2057346 5119 UAL PERS 169.01 .00 .00 .00 .00 .00 .0% 2057346 5258 OTHER SVS .00 139,140.00 139,140.00 124,740.00 124,740.00 .00 -100.0%

TOTAL CW PAVEMENT MAINT 19/2 859.38 139,140.00 139,140.00 124,740.00 124,740.00 .00 -100.0% ____________________________________________
2057500 CAPITAL PROJECTS
2057500 5111 SALARY-FT 5,212.85 .00 .00 .00 320.00 .00 .0% 2057500 5111 74001 SALARY-FT 16,083.27 .00 .00 165.78 210.00 .00 .0% 2057500 5111 74003 SALARY-FT 2,519.99 .00 .00 4,750.12 5,900.00 .00 .0% 2057500 5111 74004 SALARY-FT 98.41 .00 .00 23,126.06 19,370.00 .00 .0% 2057500 5113 74001 OVERTIME 685.00 .00 .00 .00 .00 .00 .0% 2057500 5113 74004 OVERTIME .00 .00 .00 524.02 .00 .00 .0% 2057500 5116 FRINGE BEN 1,156.40 .00 .00 .00 70.00 .00 .0% 2057500 5116 74001 FRINGE BEN 3,551.08 .00 .00 18.20 .00 .00 .0% 2057500 5116 74003 FRINGE BEN 542.29 .00 .00 979.82 1,240.00 .00 .0%

Page 125 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
MEASURE I ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 2057500 5116 74004 FRINGE BEN 24.01 .00 .00 4,834.55 3,770.00 .00 .0% 2057500 5117 RETIR CNTR 602.68 .00 .00 .00 30.00 .00 .0% 2057500 5117 74001 RETIR CNTR 1,860.32 .00 .00 17.27 20.00 .00 .0% 2057500 5117 74003 RETIR CNTR 291.47 .00 .00 494.97 610.00 .00 .0% 2057500 5117 74004 RETIR CNTR 10.25 .00 .00 2,409.80 2,020.00 .00 .0% 2057500 5119 UAL PERS 915.23 .00 .00 .00 .00 .00 .0% 2057500 5119 74001 UAL PERS 1,818.52 .00 .00 .00 .00 .00 .0% 2057500 5119 74003 UAL PERS 812.62 .00 .00 .00 .00 .00 .0% 2057500 5212 74004 ADVERTISNG .00 .00 .00 1,900.36 .00 .00 .0% 2057500 5258 74001 OTHER SVS 889,105.00 .00 .00 .00 .00 .00 .0% 2057500 5258 74002 OTHER SVS .00 290,000.00 290,000.00 289,220.00 268,970.00 .00 -100.0% 2057500 5258 74003 OTHER SVS 446,340.00 50,330.00 45,778.00 1,763.44 6,650.00 39,120.00 -14.5% 2057500 5258 74004 OTHER SVS .00 300,000.00 299,867.00 153,073.49 165,140.00 134,730.00 -55.1%

TOTAL CAPITAL PROJECTS 1,371,629.39 640,330.00 635,645.00 483,277.88 474,320.00 173,850.00 -72.6% ____________________________________________
2059122 13TH ST RECONST- EUCLID-CAMPUS
2059122 5111 SALARY-FT 12,741.43 .00 .00 21,060.20 41,250.00 .00 .0% 2059122 5113 OVERTIME .00 .00 .00 1,339.17 2,900.00 .00 .0% 2059122 5116 FRINGE BEN 2,778.40 .00 .00 4,389.76 8,830.00 .00 .0% 2059122 5117 RETIR CNTR 1,468.76 .00 .00 2,194.47 4,300.00 .00 .0% 2059122 5119 UAL PERS 3,967.45 .00 .00 .00 .00 .00 .0% 2059122 5212 ADVERTISNG 3,050.24 .00 .00 .00 .00 .00 .0% 2059122 5258 OTHER SVS 6,119.48 645,320.00 639,564.00 436,642.10 451,160.00 .00 -100.0%

TOTAL 13TH ST RECONST- EUCLI 30,125.76 645,320.00 639,564.00 465,625.70 508,440.00 .00 -100.0% TOTAL MEASURE I 1,641,413.03 6,631,740.00 6,660,864.00 1,354,906.01 2,515,340.00 8,188,620.00 22.9%

Page 126 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
ROAD MAINT REHAB ACCOUNT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2065000 NEW CIP
2065000 5258 OTHER SVS .00 .00 .00 .00 3,430.00 2,875,000.00 .0%

TOTAL NEW CIP .00 .00 .00 .00 3,430.00 2,875,000.00 .0% ____________________________________________
2065201 RMRA ADMINISTRATION
2065201 5292 ADM SV EXP 38,045.00 38,050.00 49,890.00 38,050.00 49,890.00 49,890.00 .0%

TOTAL RMRA ADMINISTRATION 38,045.00 38,050.00 49,890.00 38,050.00 49,890.00 49,890.00 .0% ____________________________________________
2065301 ENGINEERING ADMINISTRATION
2065301 5111 SALARY-FT 92.95 32,930.00 32,930.00 7,489.25 6,660.00 32,940.00 .0% 2065301 5116 FRINGE BEN 19.83 6,790.00 6,790.00 1,486.82 1,330.00 6,790.00 .0% 2065301 5117 RETIR CNTR 9.52 3,430.00 3,430.00 768.07 680.00 3,610.00 5.2% 2065301 5706 OPB&BN ALC .00 1,280.00 1,490.00 1,210.00 1,280.00 1,150.00 -22.8% 2065301 5707 PERSUALALC .00 9,710.00 9,710.00 8,910.00 9,710.00 11,390.00 17.3%

TOTAL ENGINEERING ADMINISTRA 122.30 54,140.00 54,350.00 19,864.14 19,660.00 55,880.00 2.8% ____________________________________________
2067500 CAPITAL PROJECTS
2067500 5111 70006 SALARY-FT 1,288.46 .00 .00 1,867.99 .00 .00 .0% 2067500 5116 70006 FRINGE BEN 43.17 .00 .00 455.83 .00 .00 .0% 2067500 5117 70006 RETIR CNTR 149.01 .00 .00 194.65 .00 .00 .0% 2067500 5119 70006 UAL PERS 415.50 .00 .00 .00 .00 .00 .0% 2067500 5258 70005 OTHER SVS .00 980,000.00 980,000.00 .00 .00 1,240,000.00 26.5% 2067500 5258 70006 OTHER SVS .00 348,320.00 348,104.00 16,000.00 3,430.00 427,970.00 22.9%

TOTAL CAPITAL PROJECTS 1,896.14 1,328,320.00 1,328,104.00 18,518.47 3,430.00 1,667,970.00 25.6% TOTAL ROAD MAINT REHAB ACCOU 40,063.44 1,420,510.00 1,432,344.00 76,432.61 76,410.00 4,648,740.00 224.6%

Page 127 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
HOME ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2082401 HOME PROGRAM
2082401 5601 LN ACTV 8,070.00 .00 .00 .00 .00 .00 .0%

TOTAL HOME PROGRAM 8,070.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2082408 PROGRAM INCOME LOANS
2082408 5314 HIP LOANS 111,164.80 200,000.00 200,000.00 47,190.00 245,000.00 230,000.00 15.0% 2082408 5315 FTHB LOANS .00 560,000.00 560,000.00 .00 .00 125,000.00 -77.7%

TOTAL PROGRAM INCOME LOANS 111,164.80 760,000.00 760,000.00 47,190.00 245,000.00 355,000.00 -53.3% TOTAL HOME 119,234.80 760,000.00 760,000.00 47,190.00 245,000.00 355,000.00 -53.3%

Page 128 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
CDBG ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2092301 CDBG ADMINISTRATION
2092301 5111 SALARY-FT 25,978.87 31,170.00 33,129.00 20,088.52 33,130.00 33,450.00 1.0% 2092301 5111 50105 SALARY-FT 10.77 .00 .00 .00 .00 .00 .0% 2092301 5116 FRINGE BEN 5,456.54 8,070.00 8,070.00 5,378.66 8,070.00 8,760.00 8.6% 2092301 5116 50105 FRINGE BEN 3.77 .00 .00 .00 .00 .00 .0% 2092301 5117 RETIR CNTR 2,545.77 3,220.00 3,220.00 1,974.18 3,220.00 3,550.00 10.2% 2092301 5117 50105 RETIR CNTR 1.25 .00 .00 .00 .00 .00 .0% 2092301 5212 ADVERTISNG 8,742.90 10,000.00 10,000.00 10,000.00 10,000.00 .00 -100.0% 2092301 5215 TRNG/CONF .00 300.00 300.00 .00 300.00 .00 -100.0% 2092301 5216 OFFIC SUPP 96.01 100.00 100.00 47.38 100.00 .00 -100.0% 2092301 5217 OTHER SUPP 32.33 .00 .00 .00 .00 .00 .0% 2092301 5258 OTHER SVS 39,122.04 34,730.00 34,730.00 34,730.00 34,730.00 .00 -100.0% 2092301 5299 PY EXP .00 .00 .00 1,264.95 1,270.00 .00 .0%

TOTAL CDBG ADMINISTRATION 81,990.25 87,590.00 89,549.00 73,483.69 90,820.00 45,760.00 -48.9% ____________________________________________
2092304 SENIOR WELLNESS
2092304 5258 OTHER SVS .00 7,500.00 7,500.00 7,500.00 7,500.00 .00 -100.0%

TOTAL SENIOR WELLNESS .00 7,500.00 7,500.00 7,500.00 7,500.00 .00 -100.0% ____________________________________________
2092305 GRAFFTI REMOVAL
2092305 5258 OTHER SVS 10,000.00 .00 .00 .00 .00 .00 .0%

TOTAL GRAFFTI REMOVAL 10,000.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2092308 DIAMOND COURT
2092308 5112 20733 SALARY-PT 859.58 .00 .00 .00 .00 .00 .0% 2092308 5116 20733 FRINGE BEN 30.82 .00 .00 .00 .00 .00 .0% 2092308 5117 20733 RETIR CNTR 245.74 .00 .00 .00 .00 .00 .0% 2092308 5119 20733 UAL PERS 503.30 .00 .00 .00 .00 .00 .0%

TOTAL DIAMOND COURT 1,639.44 .00 .00 .00 .00 .00 .0% ____________________________________________
2092309 FAIR HOUSING
2092309 5258 OTHER SVS 26,000.00 26,000.00 26,000.00 26,000.00 26,000.00 .00 -100.0%

TOTAL FAIR HOUSING 26,000.00 26,000.00 26,000.00 26,000.00 26,000.00 .00 -100.0% ____________________________________________
2092311 FOOD- ST. JOSEPH
2092311 5258 OTHER SVS 22,000.00 19,820.00 19,816.00 19,816.00 19,820.00 .00 -100.0%

Page 129 of 214 ends

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

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

TOTAL FOOD- ST. JOSEPH 22,000.00 19,820.00 19,816.00 19,816.00 19,820.00 .00 -100.0% ____________________________________________
2092312 HOMELESS SERVICES
2092312 5258 OTHER SVS 15,000.00 64,500.00 65,971.00 65,971.00 65,970.00 .00 -100.0%

TOTAL HOMELESS SERVICES 15,000.00 64,500.00 65,971.00 65,971.00 65,970.00 .00 -100.0% ____________________________________________
2092313 U-HOPE
2092313 5258 OTHER SVS 17,909.63 .00 .00 .00 .00 .00 .0%

TOTAL U-HOPE 17,909.63 .00 .00 .00 .00 .00 .0% ____________________________________________
2092314 HOUSING MEDIATION
2092314 5258 OTHER SVS 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 .00 -100.0%

TOTAL HOUSING MEDIATION 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 .00 -100.0% ____________________________________________
2092323 CDBG CORONAVIRUS
2092323 5111 SALARY-FT 52,161.38 .00 .00 .00 .00 .00 .0% 2092323 5111 32313 SALARY-FT .00 .00 .00 9,339.69 9,340.00 .00 .0% 2092323 5112 32304 SALARY-PT 16,675.98 .00 2,365.00 2,363.32 2,370.00 .00 -100.0% 2092323 5113 32313 OVERTIME 1,768.82 .00 .00 .00 .00 .00 .0% 2092323 5116 FRINGE BEN 12,364.93 .00 .00 .00 .00 .00 .0% 2092323 5116 32304 FRINGE BEN 241.77 .00 30.00 26.82 30.00 .00 -100.0% 2092323 5116 32313 FRINGE BEN 310.72 .00 .00 1,626.80 1,630.00 .00 .0% 2092323 5117 RETIR CNTR 6,330.20 .00 .00 .00 .00 .00 .0% 2092323 5117 32304 RETIR CNTR 1,926.54 .00 195.00 192.69 200.00 .00 -100.0% 2092323 5117 32313 RETIR CNTR .00 .00 .00 973.19 980.00 .00 .0% 2092323 5119 32304 UAL PERS 4,454.17 .00 .00 .00 .00 .00 .0% 2092323 5216 OFFIC SUPP .00 .00 .00 13.75 .00 .00 .0% 2092323 5217 OTHER SUPP .00 .00 4,290.49 .00 4,300.00 .00 -100.0% 2092323 5217 32304 OTHER SUPP 19,118.71 .00 .00 .00 .00 .00 .0% 2092323 5231 FURN&OFFC .00 .00 .00 942.09 .00 .00 .0% 2092323 5232 COMP EQUIP .00 .00 .00 2,147.69 .00 .00 .0% 2092323 5243 UTL-TELEPH .00 .00 .00 213.10 .00 .00 .0% 2092323 5258 32311 OTHER SVS 5,000.00 .00 .00 .00 .00 .00 .0% 2092323 5258 32312 OTHER SVS 25,000.00 .00 .00 .00 .00 .00 .0% 2092323 5258 32313 OTHER SVS 55,000.00 123,590.00 66,508.46 37,141.01 54,570.00 .00 -100.0% 2092323 5258 32315 OTHER SVS 12,000.00 .00 .00 .00 .00 .00 .0%

Page 130 of 214 ends

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

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

TOTAL CDBG CORONAVIRUS 243,140.72 183,590.00 132,601.45 59,192.65 132,640.00 .00 -100.0% ____________________________________________
2092324 CDBG-CV3
2092324 5111 SALARY-FT 477.26 43,920.00 43,920.00 36,057.13 43,920.00 .00 -100.0% 2092324 5112 32304 SALARY-PT .00 .00 7,455.00 6,226.86 7,450.00 .00 -100.0% 2092324 5116 FRINGE BEN 105.27 8,950.00 8,950.00 7,345.96 8,950.00 .00 -100.0% 2092324 5116 32304 FRINGE BEN .00 .00 110.00 97.75 110.00 .00 -100.0% 2092324 5117 RETIR CNTR 48.75 4,570.00 4,570.00 3,669.90 4,570.00 .00 -100.0% 2092324 5117 32304 RETIR CNTR .00 .00 .00 702.42 .00 .00 .0% 2092324 5217 32304 OTHER SUPP .00 .00 12,440.00 10,874.44 12,440.00 .00 -100.0% 2092324 5232 COMP EQUIP .00 .00 .00 856.98 .00 .00 .0% 2092324 5252 PROF SVS .00 14,930.00 14,930.00 50.44 15,530.00 .00 -100.0% 2092324 5258 OTHER SVS 25,996.38 .00 .00 .00 .00 .00 .0% 2092324 5258 32304 OTHER SVS .00 12,440.00 .00 .00 .00 .00 .0% 2092324 5258 32332 OTHER SVS 519.31 10,000.00 9,480.69 9,480.69 9,480.00 .00 -100.0% 2092324 5258 32333 OTHER SVS .00 20,000.00 20,000.00 20,000.00 20,000.00 .00 -100.0% 2092324 5258 32334 OTHER SVS .00 50,000.00 50,000.00 50,000.00 50,000.00 .00 -100.0% 2092324 5258 32336 OTHER SVS 200,548.55 .00 97,860.00 77,702.44 97,860.00 .00 -100.0%

TOTAL CDBG-CV3 227,695.52 164,810.00 269,715.69 223,065.01 270,310.00 .00 -100.0% ____________________________________________
2092325 HOPE PARTNERS- FOOD SECURITY
2092325 5258 OTHER SVS 5,000.00 .00 .00 .00 .00 .00 .0%

TOTAL HOPE PARTNERS- FOOD SE 5,000.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2092332 CDBG- PAC LIFELINE WOMENS PRG
2092332 5258 OTHER SVS 6,473.65 8,000.00 8,000.00 8,000.00 8,000.00 .00 -100.0%

TOTAL CDBG- PAC LIFELINE WOM 6,473.65 8,000.00 8,000.00 8,000.00 8,000.00 .00 -100.0% ____________________________________________
2092336 CDBG-BIZ ASSTN & ACCTRA 18-19
2092336 5310 23619 FORG LOANS .00 .00 65,010.00 33,972.00 65,010.00 .00 -100.0% 2092336 5310 23620 FORG LOANS .00 .00 60,000.00 .00 60,000.00 .00 -100.0% 2092336 5310 23621 FORG LOANS .00 95,790.00 120,000.00 .00 10,000.00 110,000.00 -8.3% 2092336 5310 23622 FORG LOANS .00 122,540.00 122,538.00 .00 .00 122,540.00 .0%

Page 131 of 214 ends

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

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

TOTAL CDBG-BIZ ASSTN & ACCTR .00 218,330.00 367,548.00 33,972.00 135,010.00 232,540.00 -36.7% ____________________________________________
2092337 DWNTWN FACADE 18-19
2092337 5258 23719 OTHER SVS 43,444.22 .00 22,534.04 20,259.04 22,540.00 .00 -100.0% 2092337 5258 23720 OTHER SVS .00 .00 100,000.00 11,275.96 100,000.00 .00 -100.0% 2092337 5258 23721 OTHER SVS .00 61,380.00 100,000.00 .00 .00 100,000.00 .0% 2092337 5258 23722 OTHER SVS .00 110,000.00 110,000.00 .00 .00 110,000.00 .0%

TOTAL DWNTWN FACADE 18-19 43,444.22 171,380.00 332,534.04 31,535.00 122,540.00 210,000.00 -36.8% ____________________________________________
2092338 CDBG-EMGNCY REPAIR PRG 18-19
2092338 5253 23819 CONTRC SVS 5,210.00 .00 .00 .00 .00 .00 .0% 2092338 5253 23820 CONTRC SVS 2,075.50 .00 .00 .00 .00 .00 .0% 2092338 5258 23819 OTHER SVS 40,738.18 .00 .00 .00 .00 .00 .0% 2092338 5258 23820 OTHER SVS 62,859.82 .00 90,128.68 90,128.68 90,130.00 .00 -100.0% 2092338 5258 23821 OTHER SVS .00 158,050.00 203,034.32 38,612.83 103,040.00 100,000.00 -50.7% 2092338 5258 23822 OTHER SVS .00 200,000.00 206,380.00 .00 .00 206,380.00 .0%

TOTAL CDBG-EMGNCY REPAIR PRG 110,883.50 358,050.00 499,543.00 128,741.51 193,170.00 306,380.00 -38.7% ____________________________________________
2092342 IVRS
2092342 5258 OTHER SVS 5,000.00 .00 .00 .00 .00 .00 .0%

TOTAL IVRS 5,000.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2092345 BUSINESS ASST 17-18
2092345 5310 FORG LOANS 25,000.00 .00 41,028.00 41,028.00 41,030.00 .00 -100.0%

TOTAL BUSINESS ASST 17-18 25,000.00 .00 41,028.00 41,028.00 41,030.00 .00 -100.0% ____________________________________________
2097613 LANDECENA INTERIOR IMPROVEMENT
2097613 5245 MAINT-BLDG .00 .00 .00 19,776.00 .00 .00 .0% 2097613 5258 OTHER SVS 4,110.79 97,790.00 95,889.21 12,365.00 87,080.00 .00 -100.0% 2097613 5530 MACH&EQUIP .00 .00 .00 63,750.00 .00 .00 .0%

TOTAL LANDECENA INTERIOR IMP 4,110.79 97,790.00 95,889.21 95,891.00 87,080.00 .00 -100.0% TOTAL CDBG 864,787.72 1,426,860.00 1,975,195.39 833,695.86 1,219,390.00 794,680.00 -59.8%

Page 132 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
PBIA ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2102501 PBIA
2102501 5245 MAINT-BLDG .00 3,480.00 25,225.00 25,225.00 25,225.00 39,000.00 54.6% 2102501 5251 LEGAL SVS .00 .00 .00 227.50 .00 .00 .0% 2102501 5258 OTHER SVS 42,355.10 49,500.00 49,500.00 49,271.46 49,500.00 49,500.00 .0% 2102501 5528 IMPRV BLD 65,538.24 .00 .00 .00 .00 .00 .0%

TOTAL PBIA 107,893.34 52,980.00 74,725.00 74,723.96 74,725.00 88,500.00 18.4% ____________________________________________
2107702 PARKING LOT REHAB & DWNTWN STR
2107702 5111 SALARY-FT 98.27 .00 .00 .00 .00 .00 .0% 2107702 5116 FRINGE BEN 19.81 .00 .00 .00 .00 .00 .0% 2107702 5117 RETIR CNTR 11.37 .00 .00 .00 .00 .00 .0% 2107702 5119 UAL PERS 31.69 .00 .00 .00 .00 .00 .0% 2107702 5258 OTHER SVS .00 138,830.00 138,830.00 39,564.23 8,280.00 130,550.00 -6.0%

TOTAL PARKING LOT REHAB & DW 161.14 138,830.00 138,830.00 39,564.23 8,280.00 130,550.00 -6.0% TOTAL PBIA 108,054.48 191,810.00 213,555.00 114,288.19 83,005.00 219,050.00 2.6%

Page 133 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
AIR QUALITY POLLUTION REDUCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2112502 AQMD
2112502 5111 SALARY-FT 3,154.90 3,220.00 3,220.00 2,620.39 3,220.00 3,220.00 .0% 2112502 5116 FRINGE BEN 1,830.98 850.00 850.00 1,118.22 850.00 860.00 1.2% 2112502 5117 RETIR CNTR 356.24 340.00 340.00 261.57 340.00 350.00 2.9% 2112502 5119 UAL PERS 1,090.00 .00 .00 .00 .00 .00 .0% 2112502 5136 FRG B-S PD .00 .00 .00 67.08 .00 .00 .0% 2112502 5217 OTHER SUPP .00 1,000.00 1,000.00 .00 .00 1,000.00 .0% 2112502 5321 EMPL INCEN 9,034.00 13,000.00 13,000.00 3,859.00 6,000.00 10,000.00 -23.1% 2112502 5531 VEHICLES 125,722.24 159,000.00 159,000.00 127,671.56 159,000.00 148,000.00 -6.9%

TOTAL AQMD 141,188.36 177,410.00 177,410.00 135,597.82 169,410.00 163,430.00 -7.9% ____________________________________________
2113211 POLICE PATROL
2113211 5530 MACH&EQUIP .00 .00 17,160.00 17,150.03 .00 .00 -100.0%

TOTAL POLICE PATROL .00 .00 17,160.00 17,150.03 .00 .00 -100.0% TOTAL AIR QUALITY POLLUTION 141,188.36 177,410.00 194,570.00 152,747.85 169,410.00 163,430.00 -16.0%

Page 134 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
HOMELAND SECURITY GRANTS-PD ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2143201 HOMELAND SECURITY GRANTS-PD
32606 HOMELAND SECURITY GRANT FY19
2143201 5233 32606 OTHR EQUIP .00 .00 32,400.00 32,400.00 32,400.00 .00 -100.0% 2143201 5233 43201 OTHR EQUIP 6,795.00 .00 .00 .00 .00 .00 .0% 2143201 5530 43201 MACH&EQUIP 21,539.00 .00 .00 .00 .00 .00 .0%

TOTAL HOMELAND SECURITY GRAN 28,334.00 .00 32,400.00 32,400.00 32,400.00 .00 -100.0% TOTAL HOMELAND SECURITY GRAN 28,334.00 .00 32,400.00 32,400.00 32,400.00 .00 -100.0%

Page 135 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
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 136 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
COPS ALLOCATION-PD ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2163201 POLICE ADMINISTRATION
2163201 5530 MACH&EQUIP .00 .00 .00 .00 .00 858,310.00 .0% 2163201 5531 VEHICLES .00 .00 .00 .00 .00 299,350.00 .0%

TOTAL POLICE ADMINISTRATION .00 .00 .00 .00 .00 1,157,660.00 .0% ____________________________________________
2163256 COPS ALLOCATION FY 14-15
2163256 5213 DUES&SUBSC 25,000.00 .00 .00 .00 .00 .00 .0% 2163256 5253 CONTRC SVS 22,000.00 .00 .00 .00 .00 .00 .0% 2163256 5530 MACH&EQUIP .00 37,870.00 37,870.00 .00 .00 .00 -100.0% 2163256 5531 VEHICLES .00 .00 .00 37,870.00 .00 .00 .0%

TOTAL COPS ALLOCATION FY 14- 47,000.00 37,870.00 37,870.00 37,870.00 .00 .00 -100.0% ____________________________________________
2163262 COPS ALLOCATION FY 15-16
2163262 5530 MACH&EQUIP .00 153,230.00 153,230.00 .00 .00 .00 -100.0% 2163262 5531 VEHICLES .00 .00 .00 153,230.00 .00 .00 .0%

TOTAL COPS ALLOCATION FY 15- .00 153,230.00 153,230.00 153,230.00 .00 .00 -100.0% ____________________________________________
2163267 COPS ALLOCATION FY 16-17
2163267 5530 MACH&EQUIP .00 162,730.00 162,730.00 .00 .00 .00 -100.0% 2163267 5531 VEHICLES .00 .00 .00 108,252.25 .00 .00 .0%

TOTAL COPS ALLOCATION FY 16- .00 162,730.00 162,730.00 108,252.25 .00 .00 -100.0% ____________________________________________
2163269 COPS ALLOCATION FY 17-18
2163269 5530 MACH&EQUIP .00 174,840.00 174,840.00 .00 .00 .00 -100.0%

TOTAL COPS ALLOCATION FY 17- .00 174,840.00 174,840.00 .00 .00 .00 -100.0% ____________________________________________
2163272 COPS ALLOCATION FY 18-19
2163272 5530 MACH&EQUIP .00 117,460.00 117,460.00 .00 .00 .00 -100.0%

TOTAL COPS ALLOCATION FY 18- .00 117,460.00 117,460.00 .00 .00 .00 -100.0% ____________________________________________
2163274 COPS ALLOCATION FY 19-20
2163274 5530 MACH&EQUIP .00 174,730.00 174,730.00 .00 .00 .00 -100.0%

Page 137 of 214 ends

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

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

TOTAL COPS ALLOCATION FY 19- .00 174,730.00 174,730.00 .00 .00 .00 -100.0% ____________________________________________
2163275 COPS ALLOCATION FY 20-21
2163275 5530 MACH&EQUIP .00 164,290.00 164,290.00 .00 .00 .00 -100.0%

TOTAL COPS ALLOCATION FY 20- .00 164,290.00 164,290.00 .00 .00 .00 -100.0% TOTAL COPS ALLOCATION-PD 47,000.00 985,150.00 985,150.00 299,352.25 .00 1,157,660.00 17.5%

Page 138 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
OTHER GRANTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2172203 ECONOMIC DEVELOPMENT
42020 CENSUS 2020 GRANT
2172203 5217 42020 OTHER SUPP 13,084.37 .00 .00 .00 .00 .00 .0%

TOTAL ECONOMIC DEVELOPMENT 13,084.37 .00 .00 .00 .00 .00 .0% ____________________________________________
2172205 PLANNING
2172205 5111 32605 SALARY-FT 1,868.46 .00 .00 4,917.55 .00 .00 .0% 2172205 5116 32605 FRINGE BEN .00 .00 .00 285.49 .00 .00 .0% 2172205 5117 32605 RETIR CNTR .00 .00 .00 131.71 .00 .00 .0% 2172205 5211 32605 POSTAGE .00 .00 .00 16.93 .00 .00 .0% 2172205 5212 32605 ADVERTISNG 321.52 .00 .00 1,634.64 .00 .00 .0% 2172205 5252 32605 PROF SVS 18,000.00 .00 288,510.00 132,360.00 232,500.00 77,500.00 -73.1% 2172205 5253 32615 CONTRC SVS .00 .00 .00 .00 .00 300,000.00 .0% 2172205 5258 32605 OTHER SVS 1,300.00 .00 .00 700.00 .00 .00 .0%

TOTAL PLANNING 21,489.98 .00 288,510.00 140,046.32 232,500.00 377,500.00 30.8% ____________________________________________
2172931 HOUSING PROGRAM
2172931 5111 42021 SALARY-FT .00 .00 74,875.00 25,861.20 86,587.00 70,000.00 -6.5% 2172931 5112 42021 SALARY-PT .00 .00 30,000.00 12,820.28 29,690.00 23,310.00 -22.3% 2172931 5113 42021 OVERTIME .00 .00 .00 1,648.28 .00 .00 .0% 2172931 5116 42021 FRINGE BEN .00 .00 27,399.00 6,117.71 20,000.00 20,450.00 -25.4% 2172931 5117 42021 RETIR CNTR .00 .00 11,405.00 2,678.34 7,400.00 7,660.00 -32.8% 2172931 5217 42021 OTHER SUPP .00 .00 31,973.00 .00 975.00 980.00 -96.9% 2172931 5252 42021 PROF SVS .00 .00 2,185.00 .00 2,185.00 .00 -100.0% 2172931 5258 42021 OTHER SVS .00 .00 100,000.00 24,087.73 131,000.00 131,000.00 31.0%

TOTAL HOUSING PROGRAM .00 .00 277,837.00 73,213.54 277,837.00 253,400.00 -8.8% ____________________________________________
2173201 HOMELESS EMERGENCY AID PRG
2173201 5111 32601 SALARY-FT 22,828.64 30,080.00 30,080.00 .00 30,080.00 .00 -100.0% 2173201 5116 32601 FRINGE BEN 8,630.00 8,700.00 8,700.00 .00 8,700.00 .00 -100.0% 2173201 5117 32601 RETIR CNTR 3,860.00 3,130.00 3,130.00 .00 3,130.00 .00 -100.0% 2173201 5318 32601 PREVENTION 2,425.17 .00 .00 .00 .00 .00 .0% 2173201 5319 32601 NAVIGATION 7,179.08 .00 .00 .00 .00 .00 .0%

TOTAL HOMELESS EMERGENCY AID 44,922.89 41,910.00 41,910.00 .00 41,910.00 .00 -100.0% ____________________________________________
2174201 RECREATION
2174201 5258 82331 OTHER SVS .00 .00 585,000.00 .00 .00 .00 -100.0%

Page 139 of 214 ends

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

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

TOTAL RECREATION .00 .00 585,000.00 .00 .00 .00 -100.0% ____________________________________________
2174205 SENIOR CENTER
2174205 5217 OTHER SUPP 108.84 .00 .00 .00 .00 .00 .0%

TOTAL SENIOR CENTER 108.84 .00 .00 .00 .00 .00 .0% ____________________________________________
2175420 PER CAPITA GRANT
2175420 5530 MACH&EQUIP .00 225,070.00 225,070.00 .00 225,070.00 .00 -100.0%

TOTAL PER CAPITA GRANT .00 225,070.00 225,070.00 .00 225,070.00 .00 -100.0% TOTAL OTHER GRANTS 79,606.08 266,980.00 1,418,327.00 213,259.86 777,317.00 630,900.00 -55.5%

Page 140 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
OFFICE OF TRAFFIC SAFETY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2183273 DUI ENF STEP GRANT-PT20131
2183273 5112 SALARY-PT 2,877.09 .00 .00 .00 .00 .00 .0% 2183273 5113 OVERTIME 3,292.17 .00 .00 .00 .00 .00 .0% 2183273 5133 OT-SW PD 16,696.84 .00 .00 .00 .00 .00 .0% 2183273 5217 OTHER SUPP 52.80 .00 .00 .00 .00 .00 .0%

TOTAL DUI ENF STEP GRANT-PT2 22,918.90 .00 .00 .00 .00 .00 .0% ____________________________________________
2183276 OTS GRANTS
2183276 5112 32607 SALARY-PT 2,373.47 .00 .00 1,094.48 .00 .00 .0% 2183276 5113 32607 OVERTIME 3,279.70 .00 .00 1,480.59 .00 .00 .0% 2183276 5113 32609 OVERTIME 725.88 .00 .00 257.53 .00 .00 .0% 2183276 5113 32610 OVERTIME .00 .00 .00 2,820.08 .00 .00 .0% 2183276 5133 32607 OT-SW PD 47,148.61 36,830.00 36,830.00 42,053.18 .00 .00 -100.0% 2183276 5133 32609 OT-SW PD 5,944.66 9,420.00 9,420.00 5,888.81 .00 .00 -100.0% 2183276 5133 32610 OT-SW PD .00 .00 151,515.00 26,321.75 .00 .00 -100.0% 2183276 5136 32610 FRG B-S PD .00 .00 .00 247.92 .00 .00 .0% 2183276 5215 32607 TRNG/CONF 3,010.00 .00 .00 .00 .00 .00 .0% 2183276 5215 32609 TRNG/CONF .00 650.00 650.00 .00 .00 .00 -100.0% 2183276 5215 32610 TRNG/CONF .00 .00 1,591.00 .00 .00 1,590.00 -.1% 2183276 5217 32607 OTHER SUPP 2,305.85 1,950.00 1,950.00 .00 .00 .00 -100.0% 2183276 5217 32609 OTHER SUPP 431.00 880.00 880.00 .00 .00 .00 -100.0% 2183276 5217 32610 OTHER SUPP .00 .00 .00 .00 .00 2,150.00 .0% 2183276 5219 32611 PERM/LC/FE .00 .00 .00 20,520.55 20,521.00 .00 .0% 2183276 5233 32610 OTHR EQUIP .00 .00 13,144.00 10,564.81 10,565.00 .00 -100.0% 2183276 5258 32608 OTHER SVS 24,800.00 .00 .00 .00 .00 .00 .0% 2183276 5258 32610 OTHER SVS .00 .00 3,750.00 .00 80.00 2,070.00 -44.8% 2183276 5258 32611 OTHER SVS .00 .00 23,000.00 .00 20,521.00 .00 -100.0% 2183276 5530 32607 MACH&EQUIP 12,000.00 .00 .00 .00 .00 .00 .0%

TOTAL OTS GRANTS 102,019.17 49,730.00 242,730.00 111,249.70 51,687.00 5,810.00 -97.6% TOTAL OFFICE OF TRAFFIC SAFE 124,938.07 49,730.00 242,730.00 111,249.70 51,687.00 5,810.00 -97.6%

Page 141 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
OTHER PUBLIC SAFETY GRANTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2193201 PUBLIC SAFETY GRANTS
32001 TOBACCO LAW ENFORCEMENT GRANT PRGM
2193201 5112 32001 SALARY-PT 147.20 .00 .00 .00 .00 .00 .0% 2193201 5116 32001 FRINGE BEN 5.87 .00 .00 .00 .00 .00 .0% 2193201 5133 32001 OT-SW PD 9,509.88 10,320.00 10,320.00 .00 10,320.00 .00 -100.0% 2193201 5136 32001 FRG B-S PD 1,212.88 .00 .00 .00 .00 .00 .0% 2193201 5214 32603 TR-POST OW 129,262.50 .00 .00 .00 .00 .00 .0% 2193201 5214 32604 TR-POST CL 148,780.00 .00 .00 .00 .00 .00 .0% 2193201 5222 32001 PRINTING .00 1,000.00 1,000.00 .00 1,000.00 .00 -100.0%

TOTAL PUBLIC SAFETY GRANTS 288,918.33 11,320.00 11,320.00 .00 11,320.00 .00 -100.0% TOTAL OTHER PUBLIC SAFETY GR 288,918.33 11,320.00 11,320.00 .00 11,320.00 .00 -100.0%

Page 142 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
CALHOME ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2222402 HOME IMPROVEMENT PROGRAM
2222402 5601 LN ACTV 167,488.00 .00 .00 .00 .00 .00 .0%

TOTAL HOME IMPROVEMENT PROGR 167,488.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2222407 CALHOME 12-8689
2222407 5314 HIP LOANS .00 .00 .00 .00 .00 115,000.00 .0% 2222407 5315 FTHB LOANS .00 295,000.00 295,000.00 .00 .00 560,000.00 89.8%

TOTAL CALHOME 12-8689 .00 295,000.00 295,000.00 .00 .00 675,000.00 128.8% TOTAL CALHOME 167,488.00 295,000.00 295,000.00 .00 .00 675,000.00 128.8%

Page 143 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
ASSET FORFEITURE-STATE ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2243423 ASSET FORFEITURE STATE-15%
2243423 5258 OTHER SVS 1,500.00 .00 .00 6,500.00 .00 .00 .0%

TOTAL ASSET FORFEITURE STATE 1,500.00 .00 .00 6,500.00 .00 .00 .0% TOTAL ASSET FORFEITURE-STATE 1,500.00 .00 .00 6,500.00 .00 .00 .0%

Page 144 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
FEDERAL GRANT-CARES ACT. ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2260000 FEDERAL GRANT-CARES ACT.
16110 COVID-19
2260000 5070 16110 TRNSFR OUT 371,052.77 .00 .00 .00 .00 .00 .0% 2260000 5070 16111 TRNSFR OUT 818,143.22 .00 .00 .00 .00 .00 .0%

TOTAL FEDERAL GRANT-CARES AC 1,189,195.99 .00 .00 .00 .00 .00 .0% ____________________________________________
2261201 CITY ADMINISTRATION
2261201 5217 16111 OTHER SUPP 3,652.31 .00 .00 .00 .00 .00 .0%

TOTAL CITY ADMINISTRATION 3,652.31 .00 .00 .00 .00 .00 .0% ____________________________________________
2261401 INFORMATION SYSTEMS
2261401 5213 16112 DUES&SUBSC 35,272.41 .00 .00 .00 .00 .00 .0% 2261401 5219 16112 PERM/LC/FE 36,235.92 .00 .00 .00 .00 .00 .0% 2261401 5232 16112 COMP EQUIP 49,457.39 .00 2,211.00 2,210.89 2,211.00 .00 -100.0% 2261401 5233 16112 OTHR EQUIP 71,187.11 .00 29,241.00 29,240.86 29,241.00 .00 -100.0% 2261401 5530 16112 MACH&EQUIP 65,440.97 .00 2,570.00 2,569.50 2,570.00 .00 -100.0%

TOTAL INFORMATION SYSTEMS 257,593.80 .00 34,022.00 34,021.25 34,022.00 .00 -100.0% ____________________________________________
2261504 NON-DEPARTMENTAL
2261504 5217 16110 OTHER SUPP 129.22 .00 .00 .00 .00 .00 .0% 2261504 5253 16111 CONTRC SVS 17,299.58 .00 .00 .00 .00 .00 .0%

TOTAL NON-DEPARTMENTAL 17,428.80 .00 .00 .00 .00 .00 .0% ____________________________________________
2261510 LIBRARY
2261510 5231 16112 FURN&OFFC 4,190.93 .00 .00 .00 .00 .00 .0% 2261510 5233 16112 OTHR EQUIP 15,428.69 .00 .00 .00 .00 .00 .0% 2261510 5528 16112 IMPRV BLD 59,783.22 .00 .00 2,080.00 .00 .00 .0% 2261510 5530 16112 MACH&EQUIP 19,017.00 .00 .00 .00 .00 .00 .0%

TOTAL LIBRARY 98,419.84 .00 .00 2,080.00 .00 .00 .0% ____________________________________________
2261603 CITY ATTORNEY
2261603 5251 16110 LEGAL SVS 4,084.00 .00 .00 .00 .00 .00 .0%

Page 145 of 214 ends

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

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

TOTAL CITY ATTORNEY 8,093.00 .00 .00 .00 .00 .00 .0% ____________________________________________
2262203 ECON DEVELOPMENT/CARES
2262203 5252 16111 PROF SVS 25,257.50 .00 .00 .00 .00 .00 .0% 2262203 5253 16111 CONTRC SVS 26,789.50 .00 .00 .00 .00 .00 .0% 2262203 5301 16111 GRANTS 67,864.03 .00 .00 .00 .00 .00 .0%

TOTAL ECON DEVELOPMENT/CARES 119,911.03 .00 .00 .00 .00 .00 .0% ____________________________________________
2263201 POLICE ADMINISTRATION
2263201 5217 16111 OTHER SUPP 1,457.13 .00 .00 .00 .00 .00 .0% 2263201 5233 16111 OTHR EQUIP 3,743.24 .00 .00 .00 .00 .00 .0%

TOTAL POLICE ADMINISTRATION 5,200.37 .00 .00 .00 .00 .00 .0% ____________________________________________
2264203 RECREATION FACILITIES
2264203 5527 16112 BUILDINGS 72,873.14 .00 .00 10,297.50 .00 .00 .0%

TOTAL RECREATION FACILITIES 72,873.14 .00 .00 10,297.50 .00 .00 .0% ____________________________________________
2264205 SENIOR CENTER
2264205 5217 16111 OTHER SUPP 34.46 .00 .00 .00 .00 .00 .0% 2264205 5231 16112 FURN&OFFC 219.64 .00 .00 .00 .00 .00 .0% 2264205 5233 16112 OTHR EQUIP 960.28 .00 .00 .00 .00 .00 .0% 2264205 5528 16112 IMPRV BLD 18,710.00 .00 .00 .00 .00 .00 .0%

TOTAL SENIOR CENTER 19,924.38 .00 .00 .00 .00 .00 .0% ____________________________________________
2265201 PUBLIC WORKS ADMINISTRATION
2265201 5217 16111 OTHER SUPP 4,085.13 .00 .00 .00 .00 .00 .0%

TOTAL PUBLIC WORKS ADMINISTR 4,085.13 .00 .00 .00 .00 .00 .0% ____________________________________________
2265410 PARKWAY MAINTENANCE -ROW
2265410 5530 16112 MACH&EQUIP 53,982.75 .00 .00 .00 .00 .00 .0%

TOTAL PARKWAY MAINTENANCE -R 53,982.75 .00 .00 .00 .00 .00 .0% ____________________________________________
2265601 CITY HALL
2265601 5245 16112 MAINT-BLDG 17,963.27 .00 .00 .00 .00 .00 .0%

Page 146 of 214 ends

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

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

TOTAL CITY HALL 17,963.27 .00 .00 .00 .00 .00 .0% ____________________________________________
2266201 WATER ADMINISTRATION
2266201 5217 16111 OTHER SUPP 51.14 .00 .00 .00 .00 .00 .0% 2266201 5233 16111 OTHR EQUIP 172.97 .00 .00 .00 .00 .00 .0%

TOTAL WATER ADMINISTRATION 224.11 .00 .00 .00 .00 .00 .0% ____________________________________________
2266402 SEWER MAINTENANCE & OPERATIONS
2266402 5217 16111 OTHER SUPP 567.72 .00 .00 .00 .00 .00 .0%

TOTAL SEWER MAINTENANCE & OP 567.72 .00 .00 .00 .00 .00 .0% TOTAL FEDERAL GRANT-CARES AC 1,869,115.64 .00 34,022.00 46,398.75 34,022.00 .00 -100.0%

Page 147 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
OFFICE OF JUSTICE PROGRAMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2273211 POLICE PATROL
2273211 5217 OTHER SUPP 469.79 .00 .00 .00 .00 .00 .0% 2273211 5232 COMP EQUIP .00 .00 .00 7,056.90 .00 .00 .0% 2273211 5233 OTHR EQUIP 41,029.05 .00 .00 .00 .00 .00 .0%

TOTAL POLICE PATROL 41,498.84 .00 .00 7,056.90 .00 .00 .0% TOTAL OFFICE OF JUSTICE PROG 41,498.84 .00 .00 7,056.90 .00 .00 .0%

Page 148 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
AMERICAN RESCUE PLAN ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2290000 AMERICAN RESCUE PLAN ACT
2290000 5070 TRNSFR OUT .00 1,077,340.00 .00 .00 .00 .00 .0%

TOTAL AMERICAN RESCUE PLAN A .00 1,077,340.00 .00 .00 .00 .00 .0% ____________________________________________
2291201 CITY ADMINISTRATION
2291201 5253 CONTRC SVS .00 .00 .00 22,275.00 .00 .00 .0%

TOTAL CITY ADMINISTRATION .00 .00 .00 22,275.00 .00 .00 .0% ____________________________________________
2291301 ARPA FINANCE
2291301 5111 SALARY-FT .00 .00 .00 .00 .00 50,720.00 .0% 2291301 5116 FRINGE BEN .00 .00 .00 .00 .00 10,790.00 .0% 2291301 5117 RETIR CNTR .00 .00 .00 .00 .00 5,500.00 .0%

TOTAL ARPA FINANCE .00 .00 .00 .00 .00 67,010.00 .0% ____________________________________________
2291401 INFORMATION SYSTEMS
2291401 5232 16141 COMP EQUIP .00 .00 .00 28,000.00 .00 .00 .0% 2291401 5232 16142 COMP EQUIP .00 .00 100,000.00 89,764.78 .00 .00 -100.0%

TOTAL INFORMATION SYSTEMS .00 .00 100,000.00 117,764.78 .00 .00 -100.0% ____________________________________________
2291701 ARPA CITY CLERK
2291701 5219 16119 PERM/LC/FE .00 .00 136,068.00 136,068.00 .00 .00 -100.0%

TOTAL ARPA CITY CLERK .00 .00 136,068.00 136,068.00 .00 .00 -100.0% ____________________________________________
2292203 ECONOMIC DEVELOPMENT
2292203 5111 SALARY-FT .00 .00 25,903.00 .00 .00 51,810.00 100.0% 2292203 5116 FRINGE BEN .00 .00 6,991.00 .00 .00 13,990.00 100.1% 2292203 5117 RETIR CNTR .00 .00 2,695.00 .00 .00 5,670.00 110.4%

TOTAL ECONOMIC DEVELOPMENT .00 .00 35,589.00 .00 .00 71,470.00 100.8% ____________________________________________
2292501 ARPA DOWNTOWN IMPROVEMENTS
2292501 5233 16129 OTHR EQUIP .00 .00 120,000.00 .00 .00 .00 -100.0%

Page 149 of 214 ends

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

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

TOTAL ARPA DOWNTOWN IMPROVEM .00 .00 120,000.00 .00 .00 .00 -100.0% ____________________________________________
2292931 HOUSING ADMINISTRATION
2292931 5252 16114 PROF SVS .00 .00 .00 1,000.00 .00 .00 .0%

TOTAL HOUSING ADMINISTRATION .00 .00 .00 1,000.00 .00 .00 .0% ____________________________________________
2293201 LICENSE PLATE READER UPGRADE
2293201 5530 16134 MACH&EQUIP .00 .00 780,000.00 775,271.86 .00 .00 -100.0%

TOTAL LICENSE PLATE READER U .00 .00 780,000.00 775,271.86 .00 .00 -100.0% ____________________________________________
2293202 VENTILATION EQUIPMENT
2293202 5530 16132 MACH&EQUIP .00 .00 25,000.00 24,998.25 .00 .00 -100.0%

TOTAL VENTILATION EQUIPMENT .00 .00 25,000.00 24,998.25 .00 .00 -100.0% ____________________________________________
2293211 POLICE PATROL
2293211 5131 SAL-SW PD .00 .00 .00 .00 .00 1,793,550.00 .0% 2293211 5136 FRG B-S PD .00 .00 .00 .00 .00 345,550.00 .0% 2293211 5137 RT CNTR-PD .00 .00 .00 .00 .00 305,520.00 .0% 2293211 5253 16113 CONTRC SVS .00 .00 142,000.00 142,000.00 142,000.00 .00 -100.0% 2293211 5531 VEHICLES .00 .00 .00 .00 .00 117,200.00 .0%

TOTAL POLICE PATROL .00 .00 142,000.00 142,000.00 142,000.00 2,561,820.00 1704.1% ____________________________________________
2294203 ARPA-RECREATION FACILITIES
2294203 5528 16151 IMPRV BLD .00 .00 50,000.00 47,520.00 50,000.00 .00 -100.0%

TOTAL ARPA-RECREATION FACILI .00 .00 50,000.00 47,520.00 50,000.00 .00 -100.0% ____________________________________________
2295000 NEW CIP
2295000 5258 OTHER SVS .00 .00 .00 .00 90,030.00 2,694,000.00 .0%

TOTAL NEW CIP .00 .00 .00 .00 90,030.00 2,694,000.00 .0% ____________________________________________
2295201 ARPA-PW ADMIN
2295201 5253 16155 CONTRC SVS .00 .00 250,000.00 .00 250,000.00 .00 -100.0%

Page 150 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
AMERICAN RESCUE PLAN ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 2295201 5253 16158 CONTRC SVS .00 .00 175,000.00 .00 175,000.00 .00 -100.0%

TOTAL ARPA-PW ADMIN .00 .00 425,000.00 .00 425,000.00 .00 -100.0% ____________________________________________
2295401 ARPA-STREET MAINTENANCE
2295401 5253 16153 CONTRC SVS .00 .00 200,000.00 .00 200,000.00 .00 -100.0%

TOTAL ARPA-STREET MAINTENANC .00 .00 200,000.00 .00 200,000.00 .00 -100.0% ____________________________________________
2295403 ARPA-SIDEWALK MAINTENANCE
2295403 5253 16156 CONTRC SVS .00 .00 180,000.00 .00 180,000.00 .00 -100.0% 2295403 5253 16157 CONTRC SVS .00 .00 526,000.00 526,000.00 .00 .00 -100.0%

TOTAL ARPA-SIDEWALK MAINTENA .00 .00 706,000.00 526,000.00 180,000.00 .00 -100.0% ____________________________________________
2297500 CAPITAL PROJECTS
2297500 5111 16150 SALARY-FT .00 .00 .00 6,149.38 1,250.00 .00 .0% 2297500 5116 16150 FRINGE BEN .00 .00 .00 1,365.56 300.00 .00 .0% 2297500 5117 16150 RETIR CNTR .00 .00 .00 640.76 130.00 .00 .0% 2297500 5212 16150 ADVERTISNG .00 .00 .00 3,673.28 .00 .00 .0% 2297500 5219 16150 PERM/LC/FE .00 .00 .00 50.00 .00 .00 .0% 2297500 5258 16150 OTHER SVS .00 .00 .00 286.22 9,770.00 544,620.00 .0% 2297500 5258 16159 OTHER SVS .00 .00 92,000.00 90,997.88 80,260.00 11,740.00 -87.2%

TOTAL CAPITAL PROJECTS .00 .00 92,000.00 103,163.08 91,710.00 556,360.00 504.7% ____________________________________________
2298001 PAVA MGMT-MASTER PLAN
2298001 5258 OTHER SVS .00 .00 .00 .00 .00 200,000.00 .0%

TOTAL PAVA MGMT-MASTER PLAN .00 .00 .00 .00 .00 200,000.00 .0% ____________________________________________
2298003 SIDEWALK INV-MASTER PLAN
2298003 5258 OTHER SVS .00 .00 .00 .00 .00 180,000.00 .0%

TOTAL SIDEWALK INV-MASTER PL .00 .00 .00 .00 .00 180,000.00 .0% ____________________________________________
2298004 ADA PUB FAC-MASTER PLAN
2298004 5258 OTHER SVS .00 .00 .00 .00 .00 250,000.00 .0%

Page 151 of 214 ends

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

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

TOTAL ADA PUB FAC-MASTER PLA .00 .00 .00 .00 .00 250,000.00 .0% ____________________________________________
2298005 TRAFFIC SIG-MASTER PLAN
2298005 5258 OTHER SVS .00 .00 .00 .00 .00 175,000.00 .0%

TOTAL TRAFFIC SIG-MASTER PLA .00 .00 .00 .00 .00 175,000.00 .0% TOTAL AMERICAN RESCUE PLAN A .00 1,077,340.00 2,811,657.00 1,896,060.97 1,178,740.00 6,755,660.00 140.3%

Page 152 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GENERAL DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
4203201 POLICE ADMINISTRATION-DIF
4203201 5531 VEHICLES 58,221.13 .00 4,384.00 4,383.15 4,384.00 .00 -100.0%

TOTAL POLICE ADMINISTRATION- 58,221.13 .00 4,384.00 4,383.15 4,384.00 .00 -100.0% ____________________________________________
4203211 PD PATROL - DIF
4203211 5531 VEHICLES 170,585.37 .00 28,113.00 28,112.27 28,113.00 .00 -100.0%

TOTAL PD PATROL - DIF 170,585.37 .00 28,113.00 28,112.27 28,113.00 .00 -100.0% ____________________________________________
4207500 CAPITAL PROJECTS
4207500 5258 80001 OTHER SVS .00 225,000.00 225,000.00 .00 .00 225,000.00 .0% 4207500 5258 80002 OTHER SVS .00 330,000.00 330,000.00 .00 .00 330,000.00 .0%

TOTAL CAPITAL PROJECTS .00 555,000.00 555,000.00 .00 .00 555,000.00 .0% ____________________________________________
4208039 PD ENTRANCE TO IMPND LT/ FUEL
4208039 5258 OTHER SVS 36,827.70 .00 5,264.00 .00 .00 .00 -100.0%

TOTAL PD ENTRANCE TO IMPND L 36,827.70 .00 5,264.00 .00 .00 .00 -100.0% TOTAL GENERAL DEVELOPMENT 265,634.20 555,000.00 592,761.00 32,495.42 32,497.00 555,000.00 -6.4%

Page 153 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
PARK ACQUISITION & DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
4215000 NEW CIP
4215000 5258 OTHER SVS .00 .00 .00 .00 13,490.00 750,000.00 .0%

TOTAL NEW CIP .00 .00 .00 .00 13,490.00 750,000.00 .0% ____________________________________________
4215420 PARK MAINTENANCE-PK DEV DIF
4215420 5530 MACH&EQUIP 59,990.21 65,000.00 65,000.00 .00 65,000.00 .00 -100.0%

TOTAL PARK MAINTENANCE-PK DE 59,990.21 65,000.00 65,000.00 .00 65,000.00 .00 -100.0% ____________________________________________
4217500 CAPITAL PROJECTS
4217500 5111 82338 SALARY-FT .00 .00 .00 133.65 290.00 .00 .0% 4217500 5111 82339 SALARY-FT .00 .00 .00 66.83 140.00 .00 .0% 4217500 5116 82338 FRINGE BEN .00 .00 .00 26.77 60.00 .00 .0% 4217500 5116 82339 FRINGE BEN .00 .00 .00 13.32 30.00 .00 .0% 4217500 5117 82338 RETIR CNTR .00 .00 .00 13.92 30.00 .00 .0% 4217500 5117 82339 RETIR CNTR .00 .00 .00 6.96 20.00 .00 .0% 4217500 5216 82338 OFFIC SUPP 61.26 .00 .00 .00 .00 .00 .0% 4217500 5217 82338 OTHER SUPP 131.22 .00 .00 .00 .00 .00 .0% 4217500 5252 82338 PROF SVS 33,476.65 .00 4,859.00 4,858.60 4,859.00 .00 -100.0% 4217500 5252 82340 PROF SVS 5,647.50 .00 1,203.00 1,387.50 1,203.00 .00 -100.0% 4217500 5258 82338 OTHER SVS .00 272,000.00 266,341.00 12,397.50 12,360.00 253,980.00 -4.6% 4217500 5258 82339 OTHER SVS .00 200,000.00 200,000.00 .00 90.00 199,920.00 .0%

TOTAL CAPITAL PROJECTS 39,316.63 472,000.00 472,403.00 18,905.05 19,082.00 453,900.00 -3.9% ____________________________________________
4218203 SPORTS PARK
4218203 5258 OTHER SVS .00 85,120.00 86,150.00 .00 .00 86,150.00 .0%

TOTAL SPORTS PARK .00 85,120.00 86,150.00 .00 .00 86,150.00 .0% ____________________________________________
4218209 MAGNOLIA RESTROOM ADA CMPLNC
4218209 5258 OTHER SVS .00 23,400.00 23,400.00 .00 .00 .00 -100.0%

TOTAL MAGNOLIA RESTROOM ADA .00 23,400.00 23,400.00 .00 .00 .00 -100.0% ____________________________________________
4218231 MEM PK BKST/SAFETY NET
4218231 5219 PERM/LC/FE 50.00 .00 .00 .00 .00 .00 .0%

Page 154 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
PARK ACQUISITION & DEVELOPMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 4218231 5252 PROF SVS 7,498.00 .00 .00 .00 .00 .00 .0% 4218231 5258 OTHER SVS 44,816.25 18,980.00 3,236.00 45,955.00 1,040.00 .00 -100.0%

TOTAL MEM PK BKST/SAFETY NET 52,364.25 18,980.00 3,236.00 45,955.00 1,040.00 .00 -100.0% TOTAL PARK ACQUISITION & DEV 151,671.09 664,500.00 650,189.00 64,860.05 98,612.00 1,290,050.00 98.4%

Page 155 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
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 732.68 .00 .00 473.78 1,030.00 .00 .0% 4227500 5116 84001 FRINGE BEN 147.39 .00 .00 91.11 200.00 .00 .0% 4227500 5117 84001 RETIR CNTR 83.87 .00 .00 49.37 110.00 .00 .0% 4227500 5119 84001 UAL PERS 211.26 .00 .00 .00 .00 .00 .0% 4227500 5258 84001 OTHER SVS .00 1,449,680.00 1,448,825.00 .00 610.00 1,448,210.00 .0% 4227500 5258 84002 OTHER SVS .00 1,700,000.00 1,700,000.00 .00 .00 1,700,000.00 .0%

TOTAL CAPITAL PROJECTS 1,175.20 3,149,680.00 3,148,825.00 614.26 1,950.00 3,148,210.00 .0% ____________________________________________
4228402 STRM DRN RPLCMNTS
4228402 5258 OTHER SVS .00 191,390.00 191,390.00 .00 .00 191,390.00 .0%

TOTAL STRM DRN RPLCMNTS .00 191,390.00 191,390.00 .00 .00 191,390.00 .0% ____________________________________________
4228405 EUCLID STRM DRN-"D" TO 18TH ST
4228405 5258 OTHER SVS .00 91,730.00 91,730.00 .00 .00 91,730.00 .0%

TOTAL EUCLID STRM DRN-"D" TO .00 91,730.00 91,730.00 .00 .00 91,730.00 .0% ____________________________________________
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 3,895.87 .00 .00 1,145.85 290.00 .00 .0% 4228411 5116 FRINGE BEN 786.14 .00 .00 188.72 60.00 .00 .0% 4228411 5117 RETIR CNTR 450.61 .00 .00 119.39 30.00 .00 .0% 4228411 5119 UAL PERS 1,121.33 .00 .00 .00 .00 .00 .0% 4228411 5212 ADVERTISNG 3,294.50 .00 .00 .00 .00 .00 .0% 4228411 5252 PROF SVS 19,630.00 .00 .00 .00 .00 .00 .0% 4228411 5258 OTHER SVS 86,406.62 159,630.00 69,175.00 5,200.00 6,630.00 .00 -100.0%

TOTAL SP/PE TRAIL STORM DRAI 115,585.07 159,630.00 69,175.00 6,653.96 7,010.00 .00 -100.0% TOTAL STORM DRAIN DEVELOPMEN 116,760.27 3,692,200.00 3,600,890.00 7,268.22 8,960.00 3,531,100.00 -1.9%

Page 156 of 214 ends

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

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

TOTAL NEW CIP .00 .00 .00 .00 360,030.00 300,000.00 .0% ____________________________________________
4235301 ENGINEERING ADMINISTRATION
4235301 5111 SALARY-FT 45.40 7,280.00 7,280.00 3,231.10 3,630.00 7,280.00 .0% 4235301 5116 FRINGE BEN 9.34 1,360.00 1,360.00 576.11 650.00 1,360.00 .0% 4235301 5117 RETIR CNTR 4.57 760.00 760.00 325.15 360.00 800.00 5.3% 4235301 5707 PERSUALALC .00 2,010.00 2,010.00 1,870.00 2,010.00 2,440.00 21.4%

TOTAL ENGINEERING ADMINISTRA 59.31 11,410.00 11,410.00 6,002.36 6,650.00 11,880.00 4.1% ____________________________________________
4238617 ARROW RTW WDNG
4238617 5258 OTHER SVS .00 600,000.00 600,000.00 .00 .00 600,000.00 .0%

TOTAL ARROW RTW WDNG .00 600,000.00 600,000.00 .00 .00 600,000.00 .0% ____________________________________________
4238622 I-10 & EUCLID AVE INTERCHANGE
4238622 5111 SALARY-FT .00 .00 .00 66.83 140.00 .00 .0% 4238622 5116 FRINGE BEN .00 .00 .00 13.32 30.00 .00 .0% 4238622 5117 RETIR CNTR .00 .00 .00 6.96 20.00 .00 .0% 4238622 5258 OTHER SVS 463,209.00 634,960.00 171,751.00 .00 .00 171,750.00 .0%

TOTAL I-10 & EUCLID AVE INTE 463,209.00 634,960.00 171,751.00 87.11 190.00 171,750.00 .0% ____________________________________________
4238623 I-10 & MONTE VISTA INTERCHANGE
4238623 5111 SALARY-FT 114.66 .00 .00 116.94 .00 .00 .0% 4238623 5116 FRINGE BEN 23.10 .00 .00 22.80 .00 .00 .0% 4238623 5117 RETIR CNTR 13.26 .00 .00 12.19 .00 .00 .0% 4238623 5119 UAL PERS 36.98 .00 .00 .00 .00 .00 .0% 4238623 5258 OTHER SVS 1,045,104.00 454,790.00 454,598.00 343,827.58 343,830.00 110,770.00 -75.6%

TOTAL I-10 & MONTE VISTA INT 1,045,292.00 454,790.00 454,598.00 343,979.51 343,830.00 110,770.00 -75.6% ____________________________________________
4238624 TRAFFIC SIGNAL UPGRADES 18/19
4238624 5111 SALARY-FT 1,650.77 .00 .00 699.00 1,510.00 .00 .0%

Page 157 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
STREET & TRAFFIC FACILITY DEV ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 4238624 5116 FRINGE BEN 356.27 .00 .00 140.05 300.00 .00 .0% 4238624 5117 RETIR CNTR 190.73 .00 .00 72.83 160.00 .00 .0% 4238624 5119 UAL PERS 438.56 .00 .00 .00 .00 .00 .0% 4238624 5258 OTHER SVS 3,246.64 62,900.00 31,259.00 5,800.00 16,200.00 .00 -100.0% 4238624 5530 MACH&EQUIP 26,808.20 .00 9,489.00 9,488.89 9,489.00 .00 -100.0%

TOTAL TRAFFIC SIGNAL UPGRADE 32,691.17 62,900.00 40,748.00 16,200.77 27,659.00 .00 -100.0% ____________________________________________
4238625 TRAFFIC SIGNAL UPGRADES 19/20
4238625 5258 OTHER SVS .00 150,000.00 150,000.00 .00 .00 150,000.00 .0%

TOTAL TRAFFIC SIGNAL UPGRADE .00 150,000.00 150,000.00 .00 .00 150,000.00 .0% TOTAL STREET & TRAFFIC FACIL 1,541,251.48 1,914,060.00 1,428,507.00 366,269.75 738,359.00 1,344,400.00 -5.9%

Page 158 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
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 .00 60,000.00 .00 .00 .00 -100.0%

TOTAL ANIMAL SHELTER .00 .00 60,000.00 .00 .00 .00 -100.0% ____________________________________________
4254203 RECREATION FACILITIES
4254203 5530 20104 MACH&EQUIP .00 .00 30,000.00 26,684.00 .00 .00 -100.0%

TOTAL RECREATION FACILITIES .00 .00 30,000.00 26,684.00 .00 .00 -100.0% ____________________________________________
4255000 NEW CIP
4255000 5258 OTHER SVS .00 .00 .00 .00 147,490.00 240,000.00 .0%

TOTAL NEW CIP .00 .00 .00 .00 147,490.00 240,000.00 .0% ____________________________________________
4257500 CAPITAL PROJECTS
4257500 5111 82336 SALARY-FT 1,191.50 .00 .00 1,213.02 1,580.00 .00 .0% 4257500 5116 82336 FRINGE BEN 266.29 .00 .00 229.52 300.00 .00 .0% 4257500 5117 82336 RETIR CNTR 137.54 .00 .00 126.41 170.00 .00 .0% 4257500 5119 82336 UAL PERS 376.32 .00 .00 .00 .00 .00 .0% 4257500 5212 82336 ADVERTISNG .00 .00 .00 1,900.36 .00 .00 .0% 4257500 5219 21204 PERM/LC/FE 2,530.25 .00 .00 .00 .00 .00 .0% 4257500 5219 82336 PERM/LC/FE .00 .00 .00 50.00 .00 .00 .0% 4257500 5234 82337 OTH EQ RNT 392,953.90 .00 .00 .00 .00 .00 .0% 4257500 5246 82337 MAINT-EQP 4,992.69 .00 .00 .00 .00 .00 .0% 4257500 5253 82335 CONTRC SVS 21,586.00 .00 .00 .00 .00 .00 .0% 4257500 5258 82336 OTHER SVS 2,475.00 171,530.00 170,553.00 145,881.50 146,700.00 24,830.00 -85.4% 4257500 5258 82337 OTHER SVS 500.00 .00 .00 .00 .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%

TOTAL CAPITAL PROJECTS 427,009.49 371,530.00 370,553.00 149,400.81 148,750.00 224,830.00 -39.3% ____________________________________________
4258038 MAGNOLIA REC CTR UPGRADES
4258038 5217 OTHER SUPP 160.55 .00 .00 .00 .00 .00 .0% 4258038 5231 FURN&OFFC 6,849.41 .00 .00 .00 .00 .00 .0% 4258038 5233 OTHR EQUIP 1,379.85 .00 .00 .00 .00 .00 .0%

Page 159 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
GENERAL CAPITAL PROJECTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 4258038 5258 OTHER SVS 79,808.09 .00 .00 .00 .00 .00 .0%

TOTAL MAGNOLIA REC CTR UPGRA 88,197.90 .00 .00 .00 .00 .00 .0% ____________________________________________
4258040 UTILITY UNDERGROUND 2019
4258040 5111 SALARY-FT .00 .00 .00 618.14 1,190.00 .00 .0% 4258040 5116 FRINGE BEN .00 .00 .00 108.44 230.00 .00 .0% 4258040 5117 RETIR CNTR .00 .00 .00 64.41 120.00 .00 .0% 4258040 5258 OTHER SVS .00 962,800.00 962,800.00 .00 790.00 984,010.00 2.2%

TOTAL UTILITY UNDERGROUND 20 .00 962,800.00 962,800.00 790.99 2,330.00 984,010.00 2.2% TOTAL GENERAL CAPITAL PROJEC 515,207.39 1,334,330.00 1,423,353.00 176,875.80 298,570.00 1,448,840.00 1.8%

Page 160 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
STREET& ALLEY REPAIRS-BURRTEC ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
4265000 NEW CIP
4265000 5258 OTHER SVS .00 .00 .00 .00 178,950.00 445,000.00 .0%

TOTAL NEW CIP .00 .00 .00 .00 178,950.00 445,000.00 .0% ____________________________________________
4265301 ENGINEERING ADMINISTRATION
4265301 5111 SALARY-FT 85.90 35,570.00 35,570.00 7,276.97 8,470.00 35,570.00 .0% 4265301 5116 FRINGE BEN 18.88 7,720.00 7,720.00 1,396.33 1,750.00 7,730.00 .1% 4265301 5117 RETIR CNTR 8.79 3,700.00 3,700.00 746.76 870.00 3,890.00 5.1% 4265301 5707 PERSUALALC .00 10,380.00 10,380.00 9,570.00 10,380.00 12,200.00 17.5%

TOTAL ENGINEERING ADMINISTRA 113.57 57,370.00 57,370.00 18,990.06 21,470.00 59,390.00 3.5% ____________________________________________
4267500 CAPITAL PROJECTS
4267500 5111 86001 SALARY-FT 1,463.96 .00 .00 3,603.24 7,810.00 .00 .0% 4267500 5111 86002 SALARY-FT .00 .00 .00 2,860.11 6,200.00 .00 .0% 4267500 5116 86001 FRINGE BEN 356.00 .00 .00 771.99 1,670.00 .00 .0% 4267500 5116 86002 FRINGE BEN .00 .00 .00 702.61 1,520.00 .00 .0% 4267500 5117 86001 RETIR CNTR 165.63 .00 .00 375.46 810.00 .00 .0% 4267500 5117 86002 RETIR CNTR .00 .00 .00 298.02 650.00 .00 .0% 4267500 5258 86001 OTHER SVS 9,500.00 200,600.00 193,514.00 167,091.83 172,680.00 20,840.00 -89.2% 4267500 5258 86002 OTHER SVS .00 205,000.00 205,000.00 .00 3,860.00 251,140.00 22.5%

TOTAL CAPITAL PROJECTS 11,485.59 405,600.00 398,514.00 175,703.26 195,200.00 271,980.00 -31.8% ____________________________________________
4268801 STREET & ALLEY PROGRAM
4268801 5111 SALARY-FT 28,944.95 .00 .00 2,221.95 3,870.00 .00 .0% 4268801 5113 OVERTIME 1,569.78 .00 .00 .00 .00 .00 .0% 4268801 5116 FRINGE BEN 6,689.89 .00 .00 371.63 620.00 .00 .0% 4268801 5117 RETIR CNTR 3,334.34 .00 .00 231.52 400.00 .00 .0% 4268801 5119 UAL PERS 1,426.06 .00 .00 .00 .00 .00 .0% 4268801 5212 ADVERTISNG 2,981.20 .00 .00 .00 .00 .00 .0% 4268801 5258 OTHER SVS 163,933.13 121,130.00 116,241.00 16,000.00 2,410.00 113,830.00 -2.1%

TOTAL STREET & ALLEY PROGRAM 208,879.35 121,130.00 116,241.00 18,825.10 7,300.00 113,830.00 -2.1% ____________________________________________
4268802 STREET & ALLEY PROG REHAB 1819
4268802 5258 OTHER SVS 159,752.00 .00 .00 .00 .00 .00 .0%

Page 161 of 214 ends

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

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

TOTAL STREET & ALLEY PROG RE 159,752.00 .00 .00 .00 .00 .00 .0% ____________________________________________
4268803 STREET & ALLEY PROG RHAB 19/20
4268803 5258 OTHER SVS 131,267.45 .00 .00 .00 .00 .00 .0%

TOTAL STREET & ALLEY PROG RH 131,267.45 .00 .00 .00 .00 .00 .0% TOTAL STREET& ALLEY REPAIRS- 511,497.96 584,100.00 572,125.00 213,518.42 402,920.00 890,200.00 55.6%

Page 162 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
ERG EFFIC CAPITAL IMPROVED PRO ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
4271504 NON-DEPARTMENTAL
4271504 5253 CONTRC SVS 1,900.00 .00 .00 1,900.00 .00 .00 .0%

TOTAL NON-DEPARTMENTAL 1,900.00 .00 .00 1,900.00 .00 .00 .0% ____________________________________________
4277500 CAPITAL PROJECTS
4277500 5253 50151 CONTRC SVS -.02 .00 .00 .00 .00 .00 .0% 4277500 5253 50152 CONTRC SVS 26,737.36 .00 .00 .00 .00 .00 .0%

TOTAL CAPITAL PROJECTS 26,737.34 .00 .00 .00 .00 .00 .0% TOTAL ERG EFFIC CAPITAL IMPR 28,637.34 .00 .00 1,900.00 .00 .00 .0%

Page 163 of 214 ends

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

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

TOTAL NEW CIP .00 .00 .00 .00 1,050,410.00 1,500,000.00 .0% ____________________________________________
6406201 WATER ADMINISTRATION
6406201 5110 BUY BACKS .00 11,050.00 11,050.00 .00 .00 14,410.00 30.4% 6406201 5111 SALARY-FT 522,218.36 589,890.00 593,689.00 387,655.08 448,010.00 662,280.00 11.6% 6406201 5111 16110 SALARY-FT 1,263.71 .00 .00 .00 .00 .00 .0% 6406201 5111 16111 SALARY-FT 171.53 .00 .00 .00 .00 .00 .0% 6406201 5111 50105 SALARY-FT 25.16 .00 .00 .00 .00 .00 .0% 6406201 5112 SALARY-PT 955.15 7,880.00 7,880.00 4,527.90 5,850.00 12,010.00 52.4% 6406201 5113 OVERTIME 107.30 .00 .00 1.90 .00 .00 .0% 6406201 5116 FRINGE BEN 92,948.58 129,940.00 131,233.00 81,525.69 95,230.00 147,840.00 12.7% 6406201 5116 16110 FRINGE BEN 164.99 .00 .00 .00 .00 .00 .0% 6406201 5116 16111 FRINGE BEN 26.53 .00 .00 .00 .00 .00 .0% 6406201 5116 50105 FRINGE BEN 5.00 .00 .00 .00 .00 .00 .0% 6406201 5117 RETIR CNTR 45,690.97 60,150.00 60,545.00 38,307.12 44,390.00 66,180.00 9.3% 6406201 5117 16110 RETIR CNTR 142.75 .00 .00 .00 .00 .00 .0% 6406201 5117 16111 RETIR CNTR 17.68 .00 .00 .00 .00 .00 .0% 6406201 5117 50105 RETIR CNTR 2.56 .00 .00 .00 .00 .00 .0% 6406201 5119 UAL PERS 214,849.05 .00 .00 .00 .00 .00 .0% 6406201 5119 16110 UAL PERS 407.52 .00 .00 .00 .00 .00 .0% 6406201 5119 16111 UAL PERS 55.32 .00 .00 .00 .00 .00 .0% 6406201 5119 50105 UAL PERS 8.11 .00 .00 .00 .00 .00 .0% 6406201 5211 POSTAGE .00 100.00 100.00 8.06 100.00 100.00 .0% 6406201 5212 ADVERTISNG 233.23 250.00 250.00 158.89 250.00 250.00 .0% 6406201 5213 DUES&SUBSC 626.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 6406201 5215 TRNG/CONF 9,077.30 1,500.00 1,500.00 1,313.53 1,500.00 1,500.00 .0% 6406201 5216 OFFIC SUPP 403.66 1,500.00 1,500.00 191.26 1,500.00 1,500.00 .0% 6406201 5217 OTHER SUPP 529.11 1,500.00 1,500.00 .00 1,500.00 1,500.00 .0% 6406201 5218 UNIFRM EXP 30,349.44 2,000.00 2,000.00 2,260.50 2,200.00 2,000.00 .0% 6406201 5219 PERM/LC/FE 436.91 .00 .00 155.99 .00 .00 .0% 6406201 5220 FUEL USAGE 602.97 .00 .00 96.74 200.00 1,000.00 .0% 6406201 5222 PRNT/MAIL 920.76 .00 .00 63.58 .00 .00 .0% 6406201 5223 INFO SYS 121,060.00 .00 .00 .00 .00 .00 .0% 6406201 5224 VEH CHRG 14,800.00 .00 .00 .00 .00 .00 .0% 6406201 5232 COMP EQUIP .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 6406201 5242 UTL-GAS 1,069.64 900.00 900.00 1,275.01 900.00 1,000.00 11.1% 6406201 5243 UTL-TELEPH 180.67 .00 .00 100.37 .00 .00 .0% 6406201 5244 UTL-WATER 1,229,289.67 1,100,000.00 1,100,000.00 806,242.59 .00 98,920.00 -91.0%

Page 164 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ 6406201 5251 LEGAL SVS 21,294.82 40,000.00 40,000.00 37,099.00 70,000.00 70,000.00 75.0% 6406201 5252 PROF SVS 10,687.99 60,870.00 68,168.00 30,424.01 10,870.00 10,870.00 -84.1% 6406201 5253 CONTRC SVS 6,751.42 50,000.00 50,375.00 31,230.25 50,375.00 50,000.00 -.7% 6406201 5255 BANKNG SVS 2,002.10 .00 .00 .00 .00 .00 .0% 6406201 5258 OTHER SVS 126,268.89 25,000.00 25,000.00 3,977.00 25,000.00 25,000.00 .0% 6406201 5273 WK CMP CHG 262,310.00 .00 .00 .00 .00 .00 .0% 6406201 5274 UNEMPL CHG 8,840.00 .00 .00 .00 .00 .00 .0% 6406201 5275 LT DIS CHG 17,050.00 .00 .00 .00 .00 .00 .0% 6406201 5276 LIAB CHG 332,950.00 .00 .00 .00 .00 .00 .0% 6406201 5277 LOSS PREV 17,030.00 .00 .00 .00 .00 .00 .0% 6406201 5283 DEPR-M&EQP 62,196.54 .00 .00 .00 .00 .00 .0% 6406201 5284 DEPR-VEH 184,975.53 .00 .00 .00 .00 .00 .0% 6406201 5290 LATE CHARG 42.92 .00 .00 8.37 .00 .00 .0% 6406201 5291 BAD DB EXP 17,884.75 .00 .00 1,133.85 .00 .00 .0% 6406201 5292 ADM SV EXP 1,404,898.00 1,404,900.00 1,727,000.00 1,404,900.00 1,727,000.00 1,727,000.00 .0% 6406201 5324 OPEB 25,959.00 .00 .00 .00 .00 .00 .0% 6406201 5325 PEN EXP -193,165.69 .00 .00 .00 .00 .00 .0% 6406201 5424 BND PRNCPL .00 .00 .00 .00 344,000.00 344,000.00 .0% 6406201 5425 BND INT EX 31,184.31 .00 .00 19,401.60 19,400.00 12,940.00 .0% 6406201 5427 ISSUA COST .00 .00 .00 300,138.25 .00 .00 .0% 6406201 5531 VEHICLES 31,430.56 .00 .00 .00 .00 .00 .0% 6406201 5600 CONTR FA -112,975.81 .00 .00 .00 .00 .00 .0% 6406201 5701 INFO SYS .00 204,420.00 204,420.00 187,385.00 204,420.00 167,850.00 -17.9% 6406201 5702 FLT-MT&RP .00 10,290.00 10,290.00 9,460.00 10,290.00 6,790.00 -34.0% 6406201 5704 BDG MT ALC .00 48,890.00 48,890.00 44,814.00 48,890.00 21,690.00 -55.6% 6406201 5705 SF LIAB .00 646,180.00 646,180.00 592,350.00 646,180.00 752,410.00 16.4% 6406201 5706 OPB&BN ALC .00 121,810.00 148,740.00 111,650.00 121,810.00 109,610.00 -26.3% 6406201 5707 PERSUALALC .00 779,760.00 779,760.00 714,780.00 779,760.00 .00 -100.0%

TOTAL WATER ADMINISTRATION 4,546,254.96 5,301,780.00 5,663,970.00 4,812,635.54 4,662,625.00 4,311,650.00 -23.9% ____________________________________________
6406202 CUSTOMER SERVICE
6406202 5110 BUY BACKS 1,740.22 .00 .00 1,775.03 1,780.00 .00 .0% 6406202 5111 SALARY-FT 69,179.25 72,360.00 72,360.00 54,385.02 68,150.00 72,220.00 -.2% 6406202 5111 16110 SALARY-FT 266.70 .00 .00 .00 .00 .00 .0% 6406202 5111 16111 SALARY-FT 444.48 .00 .00 .00 .00 .00 .0% 6406202 5111 50105 SALARY-FT 66.68 .00 .00 .00 .00 .00 .0% 6406202 5113 OVERTIME 26.25 .00 .00 403.75 830.00 830.00 .0% 6406202 5116 FRINGE BEN 14,755.82 19,830.00 19,830.00 10,514.07 12,940.00 20,150.00 1.6% 6406202 5116 16110 FRINGE BEN 49.86 .00 .00 .00 .00 .00 .0% 6406202 5116 16111 FRINGE BEN 78.37 .00 .00 .00 .00 .00 .0% 6406202 5116 50105 FRINGE BEN 14.12 .00 .00 .00 .00 .00 .0% 6406202 5117 RETIR CNTR 7,690.93 7,530.00 7,530.00 5,413.11 6,640.00 7,900.00 4.9%

Page 165 of 214 ends

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

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

TOTAL CUSTOMER SERVICE 170,208.69 206,030.00 206,030.00 101,155.65 196,650.00 209,880.00 1.9% ____________________________________________
6406203 METER SERVICES
6406203 5111 SALARY-FT 157,769.28 166,630.00 166,630.00 110,645.47 137,190.00 216,890.00 30.2% 6406203 5113 OVERTIME 6,343.62 .00 .00 12,596.73 15,790.00 16,000.00 .0% 6406203 5116 FRINGE BEN 44,790.88 53,890.00 53,890.00 32,538.57 39,740.00 71,940.00 33.5% 6406203 5117 RETIR CNTR 17,366.72 17,130.00 17,130.00 10,782.13 13,360.00 23,510.00 37.2% 6406203 5119 UAL PERS 38,270.00 .00 .00 .00 .00 .00 .0% 6406203 5215 TRNG/CONF .00 3,000.00 3,000.00 400.00 3,000.00 5,000.00 66.7% 6406203 5217 OTHER SUPP 41,421.63 81,000.00 81,000.00 80,000.00 81,000.00 101,500.00 25.3% 6406203 5218 UNIFRM EXP .00 .00 .00 1,837.35 .00 .00 .0% 6406203 5220 FUEL USAGE 4,098.17 5,000.00 5,000.00 3,984.80 5,000.00 5,000.00 .0% 6406203 5223 INFO SYS 500.00 .00 .00 .00 .00 .00 .0% 6406203 5224 VEH CHRG 5,240.00 .00 .00 .00 .00 .00 .0% 6406203 5233 OTHR EQUIP 523,665.06 800,000.00 800,000.00 760,000.00 800,000.00 900,000.00 12.5% 6406203 5253 CONTRC SVS .00 .00 20,000.00 20,000.00 20,000.00 .00 -100.0% 6406203 5258 OTHER SVS 44,417.66 51,000.00 51,000.00 51,000.00 51,000.00 53,000.00 3.9% 6406203 5531 VEHICLES 82,416.08 113,500.00 113,500.00 .00 113,500.00 58,250.00 -48.7% 6406203 5600 CONTR FA -82,416.08 .00 .00 .00 .00 .00 .0% 6406203 5701 INFO SYS .00 500.00 500.00 462.00 500.00 500.00 .0% 6406203 5702 FLT-MT&RP .00 5,530.00 5,530.00 5,071.00 5,530.00 5,870.00 6.1%

TOTAL METER SERVICES 883,883.02 1,297,180.00 1,317,180.00 1,089,318.05 1,285,610.00 1,457,460.00 10.7% ____________________________________________
6406204 DAMAGE TO CITY PROPERTY
6406204 5258 OTHER SVS 5,596.18 .00 .00 3,000.00 .00 .00 .0%

Page 166 of 214 ends

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

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

TOTAL DAMAGE TO CITY PROPERT 5,596.18 .00 .00 3,000.00 .00 .00 .0% ____________________________________________
6406205 PRODUCTION/STORAGE
6406205 5110 BUY BACKS 6,801.99 .00 .00 8,374.53 8,370.00 .00 .0% 6406205 5111 SALARY-FT 344,275.51 402,860.00 402,860.00 280,878.29 343,190.00 512,580.00 27.2% 6406205 5112 SALARY-PT .00 .00 .00 7,417.30 .00 27,470.00 .0% 6406205 5113 OVERTIME 44,384.01 45,000.00 45,000.00 33,655.39 34,830.00 45,000.00 .0% 6406205 5116 FRINGE BEN 76,903.31 93,140.00 93,140.00 59,177.72 70,930.00 119,340.00 28.1% 6406205 5117 RETIR CNTR 37,413.77 39,680.00 39,680.00 26,951.71 32,870.00 52,300.00 31.8% 6406205 5119 UAL PERS 68,950.00 .00 .00 .00 .00 .00 .0% 6406205 5211 POSTAGE 96.17 100.00 100.00 225.77 320.00 350.00 250.0% 6406205 5213 DUES&SUBSC 294.00 300.00 300.00 .00 300.00 300.00 .0% 6406205 5215 TRNG/CONF .00 8,730.00 8,730.00 2,157.23 8,930.00 9,130.00 4.6% 6406205 5216 OFFIC SUPP 260.01 500.00 500.00 407.41 500.00 800.00 60.0% 6406205 5217 OTHER SUPP 124,685.72 346,250.00 346,250.00 176,127.30 349,250.00 387,300.00 11.9% 6406205 5218 UNIFRM EXP .00 3,950.00 3,950.00 3,850.00 3,950.00 4,900.00 24.1% 6406205 5219 PERM/LC/FE 78,774.83 82,000.00 82,000.00 85,906.92 90,000.00 91,000.00 11.0% 6406205 5220 FUEL USAGE 21,501.05 16,200.00 16,200.00 18,733.40 19,200.00 26,500.00 63.6% 6406205 5222 PRINTING .00 2,000.00 2,000.00 1,429.08 2,000.00 2,900.00 45.0% 6406205 5223 INFO SYS 32,270.00 .00 .00 .00 .00 .00 .0% 6406205 5224 VEH CHRG 36,560.00 .00 .00 .00 .00 .00 .0% 6406205 5225 BLDG MT&OP 79,330.00 .00 .00 .00 .00 .00 .0% 6406205 5231 FURN&OFFC .00 750.00 750.00 .00 750.00 750.00 .0% 6406205 5232 COMP EQUIP 12,397.67 9,600.00 9,600.00 12,051.76 9,600.00 11,600.00 20.8% 6406205 5233 OTHR EQUIP 7,205.95 11,000.00 11,000.00 7,849.08 11,000.00 13,750.00 25.0% 6406205 5234 OTH EQ RNT 8,879.82 12,000.00 12,000.00 12,000.00 12,000.00 15,000.00 25.0% 6406205 5236 RENT 55,576.32 57,000.00 57,000.00 57,304.80 57,000.00 59,000.00 3.5% 6406205 5241 UTL-ELECTR 1,276,290.76 1,300,000.00 1,300,000.00 1,036,922.09 1,300,000.00 1,400,000.00 7.7% 6406205 5244 UTL-WATER 9,302,340.07 11,830,120.00 11,830,120.00 11,754,170.92 .00 12,229,830.00 3.4% 6406205 5246 MAINT-EQP .00 .00 30,000.00 30,426.95 30,000.00 .00 -100.0% 6406205 5248 MAINT-OTHR 21,763.74 44,000.00 44,000.00 42,302.20 44,000.00 80,720.00 83.5% 6406205 5253 CONTRC SVS 20,150.00 .00 .00 .00 .00 .00 .0% 6406205 5254 DATA P SVS 8,240.00 8,500.00 8,500.00 12,015.79 8,500.00 8,800.00 3.5% 6406205 5258 OTHER SVS 268,029.38 428,500.00 428,500.00 157,712.79 433,500.00 439,200.00 2.5% 6406205 5259 RECYCL WTR 1,220,554.55 1,173,000.00 1,173,000.00 1,168,101.70 1,173,000.00 1,341,500.00 14.4% 6406205 5288 DEPR-RESER 739,291.39 .00 .00 .00 .00 .00 .0% 6406205 5290 LATE CHARG 6,717.62 .00 .00 3,409.02 .00 .00 .0% 6406205 5304 CONTRIBUTN 792,045.73 767,000.00 767,000.00 836,810.18 767,000.00 777,000.00 1.3% 6406205 5530 MACH&EQUIP 16,438.27 6,000.00 6,000.00 57,481.50 6,000.00 6,000.00 .0% 6406205 5600 CONTR FA -7,161.42 .00 .00 -106,885.79 .00 .00 .0% 6406205 5701 INFO SYS .00 15,100.00 15,100.00 13,838.00 15,100.00 18,630.00 23.4% 6406205 5702 FLT-MT&RP .00 27,740.00 27,740.00 25,432.00 27,740.00 22,550.00 -18.7%

Page 167 of 214 ends

Upland City CouncilMay 9, 2022

Upland City Council
May 9, 2022