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

Special Meeting
May 9, 2022
5:00 P M
Carnegie Building, 123 East D Street
***************

CIT Y COUNCIL BUDGET WORKSHOP

1.C A L L TO O R D E R A ND R O L L C A L L

2.O R A L C O MMUNI C AT I O NS
P ursuant to Government Code S ection 54954.2, any member of the public may address any item listed on the agenda. A nyone wishing to address the legislative body should submit a speaker card to the City Clerk at or prior to speaking. S peakers shall keep their comments to no more than three (3) minutes.

3.F I S C A L YE A R 2022/23 B UD G E T W O R K S HO P
Receive the presentation and provide direction for the Fiscal Year 2022/23 B udget. (Staff Person: S tephen Parker)

4.A D J O UR NME NT T he next regularly scheduled City Council meeting is Monday, May 9, 2022

NOT E: A ll Agenda items and back-up materials are available for public review at the U pland P ublic Library, downstairs reference desk at 450 N orth E uclid Avenue, the C ity C lerk's O ffice at 460 N orth E uclid Avenue and the C ity website at www.uplandca.gov .

I n compliance with the A mericans with D isabilities Act, if you need special assistance to participate in this meeting, please contact the C ity C lerk's Office at 909.931.4120. N otification 48 hours prior to the meeting will enable the C ity to make reasonable arrangements to ensure accessibility to this meeting. [28 C F R

35.102-35.104 A DA Title I I ]

P O S T I N G S T A T E M E N T : O n M a y 4 , 2 0 2 2 a t rue a nd co rre ct co p y o f t h i s a g e n d a w a s p o s t e d a t 4 5 0 N . E u cl i d Ave n u e (U p l a nd P u b l i c L i b ra ry) a nd 460 N . E ucl i d A ve nue (U p l a n d C i t y H a l l ), 123 E a s t D St re e t (C a rn e g i e b ui l d i n g ), a nd t h e C i t y W e b s i t e at www.uplandc a.gov

S T A F F R E P O R T
I T E M N O . 3.

D A T E :M ay 9, 2 02 2
T O :M A YO R A N D C I T Y C O U N C I L
F R O M : M I C H A E L B L A Y, C I T Y M A N A G E R P R E P A R E D B Y : S T E P H E N PA R K E R , C PA , A S S I S TA N T C I T Y M A N A G E R S U B J E C T :F I S C A L Y E A R 2 02 2/2 3 B U D G E T W O R K S H O P

R E C O M M E N D E D A C T I O N
I t is rec om m end ed t h at th e C ity C ou ncil rec eive t h e p res en t ati on and p rovid e d i rec ti on for the F iscal Year 20 22 /23 B u d g et.

G O A L S T A T E M E N T
Th e p rop osed act ion su p p orts th e C i ty's g oal to p rovid e fis cal st ew ard sh ip for th e C ity of Up lan d .

B A C K G R O U N D
Th e B ud g et sets fort h a st rat eg i c res ou rce allocation p l an t hat i s d istinctly al ig ned w ith com m u nity g oals, p referen ces, and need s. T he B ud g et is a p olicy d ocum ent, fin ancial p lan, op erations g u id e, and com m u nication s d evice all in one.

S taff b eg an t he b u d g et p roces s in D ecem b er 20 21 . E ach d ep art m en t p rop osed their p erson nel n eed s in J anu ary, an d th eir m ain ten ance an d op erat ion s b u d g ets in Feb ru ary. T he F inan ce D ep artm ent c alc u l ated th e p ers on n el cost s, acc u m u l ated th e s u b m i ss ion s an d con solid ated th e results. O nce th e overall b ud g et p icture w as id en tified , in M arch and A p ril d ep artm en ts m et wi th F i n an ce p ers onn el an d t he C it y M an ag er t o revi ew th eir b u d g ets. A fter m aking m od ificat ion s b ased on th e C i ty M an ag er's d eterm i n at ion , a d raft b u d g et w as p rep ared . T h e F i n an ce C om m it tee was p resen ted w it h i nform at ion reg ard in g t he d raft b u d g et th is A p ril . M in or m od ifications were m ad e aft er th at p resent ation, cu lm in ati n g w ith th e d raft b u d g et att ach ed to th is staff rep ort b ei n g in clud ed in t h e B u d g et W orkshop p res ent ati on. C ity C ou ncil wi ll have t he op p ortu nity to p rovi d e d irect ion for chan g es from wh at is b ein g p rop osed , with th e fin al b ud g et d ocum ent anticip ated to b e p resen ted to C ity C ou ncil for ap p roval at the J un e 13 , 20 22 m eetin g .

Page 1 of 214 ends

I S S U E S /A N A L Y S I S
A p resen tat ion w il l b e p rovid ed t o C i ty C ou n ci l at th e w orkshop , b u t the attached d ocum ents con tain all the b ud g etary d etail of the p rop osed F iscal Year 20 22 /23 B u d g et.

F I S C A L I M P A C T S
Th ere is n o fiscal im p act related to th is item . I f th e in form ation inclu d ed in th e B u d g et Worksh op is u nm od ified , t he F i sc al Year 20 22 /23 B u d g et w ou ld m ain tai n est im ated G eneral F u nd U nassi g n ed F u n d B al ance am ou n ts at th e sam e l evel as t he en d in g am oun ts for F iscal Year 2 02 1/2 2.

A L T E R N A T I V E S
P rovid e altern ative d irection to staff.

AT TAC HM E NT S :

Description
Summary of Changes in Fund Balance
Revenue S ummary
Revenue Detail
Expenditures by Department Program
Expenditures by F und and Category
Expenditures by F und
C I P P roposed Budget
Schedule of T ransfers
Schedule of Positions
Revenue by Fund - M unis Report
Expenditures by F und - M unis Report

Page 2 of 214 ends

Fund
No.

Estimated Fund
Balance
(Unassigned)
7/1/22
One Time Fund
Balance Use
2022-2023 Estimated
Revenue Transfers In
Available
Sources
2022-2023
Operating
Expenditures
Capital
Improvement
Projects
Transfers
Out Total Uses
Change in Fund
Balance
Fund Balance
6/30/23
101 General Fund - Estimated Unreserved 383,290$ -$ 50,181,580$ -$ 50,181,580$ 49,811,500$ -$ 240,000$ 50,051,500$ 130,080$ 513,370$ .25% Building Maint. Reserve - - - - - 130,000 - - 130,000 (130,000) (130,000) Total General Fund 383,290$ -$ 50,181,580$ -$ 50,181,580$ 49,941,500$ -$ 240,000$ 50,181,500$ 80$ 383,370$ 201 Housing 4,217,770$ -$ 4,813,280$ -$ 4,813,280$ 3,959,840$ -$ -$ 3,959,840$ 853,440$ 5,071,210$ 203 Public Safety Augmentation - - 1,422,700 - 1,422,700 1,422,700 - - 1,422,700 - - 204 Gas Tax 7,213,390 - 2,289,540 - 2,289,540 868,510 8,629,410 - 9,497,920 (7,208,380) 5,010 205 Measure I 6,566,130 - 1,623,180 - 1,623,180 421,660 7,766,960 - 8,188,620 (6,565,440) 690 206 RMRA 2,862,290 - 1,789,680 - 1,789,680 105,770 4,542,970 - 4,648,740 (2,859,060) 3,230 208 HOME Investment Partnership Program 933,340 - 48,300 - 48,300 355,000 - - 355,000 (306,700) 626,640 209 Community Development Block Grant - - 794,680 - 794,680 794,680 - - 794,680 - - 210 Parking Business Improvement Area 169,130 - 58,600 - 58,600 88,500 130,550 - 219,050 (160,450) 8,680 211 Air Quality Management District 107,230 - 99,400 - 99,400 163,430 - - 163,430 (64,030) 43,200 215 Prop 30 154,450 - - - - 150,000 - - 150,000 (150,000) 4,450 216 COPS 1,253,660 - 120,000 - 120,000 1,157,660 - - 1,157,660 (1,037,660) 216,000 217 Other Grants - - 655,340 - 655,340 630,900 - - 630,900 24,440 24,440 218 Office of Traffic Safety - - 154,270 - 154,270 5,810 - - 5,810 148,460 148,460 219 Other Public Safety Grants - - - - - - - - - - - 220 Asset Forfeiture 540,790 - - - - - - - - - 540,790 222 CalHOME 674,530 - 35,200 - 35,200 675,000 - - 675,000 (639,800) 34,730 223 Asset Forfeiture-Federal Treasury 10,260 - - - - - - - - - 10,260 224 Asset Forfeiture State 196,390 - - - - - - - - - 196,390 225 BSCC Budget Act 83,020 - - - - - - - - - 83,020 226 CARES Act - - - - - - - - - - - 227 Office of Justice Programs - - - - - - - - - - - 229 ARPA 12,248,530 - 35,000 - 35,000 2,700,300 4,055,360 - 6,755,660 (6,720,660) 5,527,870 Total Special Revenue Funds 37,230,910$ -$ 13,939,170$ -$ 13,939,170$ 13,499,760$ 25,125,250$ -$ 38,625,010$ (24,685,840)$ 12,545,070$ 420 General Capital Improvements 2,480,360$ -$ 195,000$ -$ 195,000$ -$ 555,000$ -$ 555,000$ (360,000)$ 2,120,360$ 421 Park Acquisition & Development 11,135,670 - 800,000 - 800,000 - 1,290,050 - 1,290,050 (490,050) 10,645,620 422 Storm Drain Development 5,285,170 - 366,200 - 366,200 - 3,531,100 - 3,531,100 (3,164,900) 2,120,270 423 Street & Traffic Facility Development 1,411,620 - 386,000 - 386,000 11,880 1,332,520 - 1,344,400 (958,400) 453,220 425 General Capital Projects 1,629,420 - - 240,000 240,000 - 1,448,840 - 1,448,840 (1,208,840) 420,580 426 Street & Alley Repairs 685,070 - 240,000 - 240,000 59,390 830,810 - 890,200 (650,200) 34,870 Total Capital Project Funds 22,627,310$ -$ 1,987,200$ 240,000$ 2,227,200$ 71,270$ 8,988,320$ -$ 9,059,590$ (6,832,390)$ 15,794,920$ 640 Water Utility (Working Cap)25,002,840$ -$ 31,633,050$ -$ 31,633,050$ 29,079,070$ 18,569,220$ -$ 47,648,290$ (16,015,240)$ 8,987,600$ 641 Solid Waste Utility (Working Cap)33,670 - 16,285,000 - 16,285,000 15,678,990 119,510 265,000 16,063,500 221,500 255,170 645 Environmental Enterprise (Working Cap)12,440,700 - 10,430,600 265,000 10,695,600 12,478,860 2,522,340 - 15,001,200 (4,305,600) 8,135,100 Total Enterprise Funds 37,477,210$ -$ 58,348,650$ 265,000$ 58,613,650$ 57,236,920$ 21,211,070$ 265,000$ 78,712,990$ (20,099,340)$ 17,377,870$ 750 Fire Annexation Worker's Comp 473,790$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 473,790$ 751 Self-Funded Liability Insurance (7,416,360) - 5,274,910 - 5,274,910 5,272,750 - - 5,272,750 2,160 (7,414,200) 752 Vehicle Replacement Fund 967,020 - 780,080 - 780,080 891,580 - - 891,580 (111,500) 855,520 753 Information Systems 1,952,600 - 2,827,970 - 2,827,970 2,844,680 - - 2,844,680 (16,710) 1,935,890 754 Building Maintenance & Operations 999,180 - 995,340 - 995,340 1,458,100 - - 1,458,100 (462,760) 536,420 755 UAL and Employee Benefits - - 7,583,450 - 7,583,450 7,583,450 - - 7,583,450 - - Total Internal Service Fund (3,023,770)$ -$ 17,461,750$ -$ 17,461,750$ 18,050,560$ -$ -$ 18,050,560$ (588,810)$ (3,612,580)$ 805 Successor Agency Housing (11,322,970)$ -$ 3,374,160$ -$ 3,374,160$ 3,364,170$ -$ -$ 3,364,170$ 9,990$ (11,312,980)$ Total Private Purpose Trust Fund (11,322,970)$ -$ 3,374,160$ -$ 3,374,160$ 3,364,170$ -$ -$ 3,364,170$ 9,990$ (11,312,980)$ 83,371,980$ -$ 145,292,510$ 505,000$ 145,797,510$ 142,164,180$ 55,324,640$ 505,000$ 197,993,820$ (52,196,310)$ 31,175,670$ FY 2022-23 SUMMARY OF CHANGES IN FUND BALANCE
Grand Total

Page 3 of 214 ends

2019-20 2020-21 2021-22 2021-22 2022-23
Fund No.Actual Actual Adopted Amended Proposed
101 General Fund 45,548,730$ 49,165,380$ 44,891,140$ 48,863,370$ 50,181,580$ Total General Fund 45,548,730$ 49,165,380$ 44,891,140$ 48,863,370$ 50,181,580$ 201 Housing 88,960$ 230,890$ 4,632,780$ 4,632,780$ 4,813,280$ 203 Public Safety Augmentation Fund 990,550 1,057,960 1,339,880 1,339,880 1,422,700 204 Gas Tax 3,905,640 1,727,890 2,052,530 2,052,530 2,289,540 205 Measure I 1,730,130 1,776,810 1,409,270 1,409,270 1,623,180 206 Road Maintenance Rehabilitation Account - 1,465,780 1,533,890 1,533,890 1,789,680 208 HOME Investment Partnership Program 215,280 149,010 75,800 75,800 48,300 209 Community Development Block Grant 367,690 359,110 1,426,860 1,965,190 794,680 210 Parking Business Improvement Area 66,340 60,450 59,000 59,000 58,600 211 Air Quality Management District 260,710 104,900 99,400 99,400 99,400 214 Homeland Security Grants-PD 22,940 28,330 - 11,400 - 215 Prop 30 2,510 1,140 900 900 - 216 COPS 199,140 194,840 120,000 120,000 120,000 217 Other Grants 54,810 25,340 266,980 1,439,820 655,340 218 Office of Traffic Safety 182,850 103,200 45,430 238,430 154,270 219 Other Public Safety Grants - 157,620 11,320 11,320 - 220 Asset Forfeiture 8,100 19,060 - - - 222 CalHOME 43,520 172,940 30,200 30,200 35,200 223 Asset Forfeiture - Federal Treasury 160 80 - - - 224 Asset Forfeiture - State 17,740 1,840 - - - 225 BSCC Budget Act 1,360 620 - - - 226 CARES ACT 324,380 2,143,220 - - - 227 Office of Justice Programs - 41,500 - - - 229 American Rescue Plan Act - 4,740 7,960,000 7,960,000 35,000 Total Special Revenue Funds 8,482,810$ 9,827,270$ 21,064,240$ 22,979,810$ 13,939,170$ 420 General Capital Improvements 652,120$ 345,460$ 279,000$ 279,000$ 195,000$ 421 Park Acquisition & Development 1,791,840 1,572,260 1,242,920 1,242,920 800,000 422 Storm Drain Development 970,880 859,700 410,710 410,710 366,200 423 Street & Traffic Facility Development 471,740 460,660 201,000 201,000 386,000 426 Street & Alley Repairs 234,740 215,730 220,680 220,680 240,000 427 Energy Efficiency Capital Improvement Projec 1,260 40 - - - Total Capital Project Funds 4,122,580$ 3,453,850$ 2,354,310$ 2,354,310$ 1,987,200$ 640 Water Utility 35,692,760$ 31,623,030$ 29,390,000$ 29,390,000$ 31,633,050$ 641 Solid Waste Utility 13,829,030 14,661,310 16,320,980 16,320,980 16,285,000 645 Sewer Utility 15,567,250 10,884,170 10,539,730 10,539,730 10,430,600 Total Enterprise Funds 65,089,040$ 57,168,510$ 56,250,710$ 56,250,710$ 58,348,650$ 750 Fire Annexation Worker's Compensation 7,740$ 3,520$ -$ -$ -$ 751 Self-Funded Insurance 4,182,810 6,144,920 4,818,350 4,818,350 5,274,910 752 Fleet Maintenance & Replacement 1,212,960 728,220 1,435,390 1,435,390 780,080 753 Information Systems 1,763,630 1,996,380 2,505,680 2,505,680 2,827,970 754 Building Maintenance & Operations 1,103,200 939,930 1,127,220 1,127,220 995,340 755 UAL and Employee Benefits - - 10,168,860 10,226,640 7,583,450 Total Internal Service Funds 8,270,340$ 9,812,970$ 20,055,500$ 20,113,280$ 17,461,750$ 805 Successor Agency 3,513,930$ 3,250,430$ 3,408,960$ 3,408,960$ 3,374,160$ Total Private Purpose Trust Fund 3,513,930$ 3,250,430$ 3,408,960$ 3,408,960$ 3,374,160$ Grand Total 135,027,430$ 132,678,410$ 148,024,860$ 153,970,440$ 145,292,510$ 2022-2023 SCHEDULE OF REVENUES BY FUND & CATEGORY

Page 4 of 214 ends

Object 2019-20 2020-21 2021-22 2021-22 2022-23
Code Actual Actual Adopted Amended Proposed
4001 Current Secured Tax 7,094,240$ 7,590,360$ 7,427,570$ 7,668,020$ 8,038,710$ 4001 Property Tax (In-Lieu)8,133,250 8,585,000 9,185,430 8,944,980 8,944,970 4002 Current Unsecured Tax 251,290 264,930 260,000 260,000 275,400 4003 Aircraft Taxes 45,770 41,610 39,660 39,660 33,770 4004 Prior Year Collections 294,720 348,940 241,980 241,980 295,000 4005 Current Supplemental 76,800 94,700 70,000 70,000 85,000 4006 Homeowner Property Tax Relief 69,400 64,890 69,400 69,400 64,800 4009 Weed Abatement Assessment 60,440 4,500 75,000 15,530 75,000 4011 RPTTF-Residual 1,578,910 1,303,180 1,100,000 1,100,000 1,300,000 4012 Trailer Coach in Lieu Tax 66,330 72,970 59,370 59,370 65,000 4403 Motor Vehicle in Lieu Tax 62,110 57,810 57,800 90,700 90,000 17,733,260$ 18,428,890$ 18,586,210$ 18,559,640$ 19,267,650$ 4101 Sales and Use Tax 13,579,780$ 16,876,710$ 14,789,060$ 18,153,630$ 18,404,120$ 4102 Business License Tax 1,133,400 1,119,430 1,080,000 1,080,000 1,100,000 4103 Rock Extraction Tax 277,340 264,960 260,000 260,000 264,000 4104 Transient Occupancy Tax 156,700 195,620 154,000 154,000 164,000 4105 Real Property Transfer Tax 384,580 447,620 350,000 350,000 400,000 4110 Disability Access Fee 20,290 21,940 10,000 10,000 18,500 4121 Franchise Tax 1,252,060 1,284,530 1,252,060 1,252,060 1,284,520 16,804,150$ 20,210,810$ 17,895,120$ 21,259,690$ 21,635,140$ 4201 Building Permits 754,160$ 904,990$ 634,760$ 582,670$ 681,720$ 4202 Plumbing Permits 193,080 144,560 199,330 74,700 86,700 4203 Electrical Permits 434,670 695,080 288,510 392,410 455,400 4204 Heating & Cooling Permits 90,070 55,530 101,610 46,660 54,150 4205 Public Works Construction Permits 843,340 346,630 300,000 150,000 200,000 4206 Grading Permits 2,350 - 4,600 - - 4207 Wall Permits 5,680 11,650 85,850 10,840 12,580 4208 Roofing Permits 51,080 129,950 84,840 93,910 108,990 4215 Other Permits 91,970 73,190 2,940 1,690 1,960 4216 Bicycle Licenses 90 50 70 70 70 4217 Animal Licenses 114,230 114,190 114,000 76,370 76,000 4222 Yard Sale Permits 3,890 3,100 3,500 3,500 3,500 4223 Alarm Permits 130 80 - - - 4224 Gun Licenses 350 2,200 1,510 1,510 500 4226 Metrolink Parking 64,980 2,010 65,000 15,000 21,100 4227 Vehicle Charging - 2,060 - 5,000 - 2,650,070$ 2,485,270$ 1,886,520$ 1,454,330$ 1,702,670$ 4402 State Mandated Costs 1,420$ 50$ -$ -$ -$ 4421 Police Officer Standard Training 19,410 22,310 10,000 18,340 10,000 4482 State Literacy Program 27,470 27,100 27,000 27,000 28,000 48,300$ 49,460$ 37,000$ 45,340$ 38,000$ 4601 Finance Department Fees 28,620$ 31,050$ 28,000$ 28,000$ 28,000$ 4602 City Clerk Fees 2,310 10,870 2,500 2,500 2,500 4603 Damage to City Property 51,630 48,830 - 50,000 - 4604 CFD Admin Fees 57,950 57,950 37,920 37,920 37,920 4611 Planning - Department Fees 131,640 198,490 145,000 325,000 325,000 4613 Planning - Deposit Fees 400,360 253,700 375,000 145,000 70,000 4614 Building - Plan Check Fees 306,770 514,070 238,330 530,190 620,820 4615 Building - Department Fees 274,260 185,250 360 45,710 53,040 4616 Building - Special Inspection Fees 9,160 37,740 58,870 21,220 24,640 4617 Economic Development Fees 200 3,610 - 150,000 - 4622 Police - Department Fees 181,810 147,330 170,580 138,880 143,100 4623 Police - Special Service Fees 6,870 640 24,200 8,760 4,500 4624 Animal Services - Animal Impounds 18,280 8,790 15,000 8,500 8,500 2022-2023 SCHEDULE OF REVENUE DETAIL BY FUND
General Fund
Revenue from Property Tax
Revenue from Other Taxes
Revenue from Licenses & Permits
Revenue from Other Governments

Page 5 of 214 ends

Object 2019-20 2020-21 2021-22 2021-22 2022-23
Code Actual Actual Adopted Amended Proposed
2022-2023 SCHEDULE OF REVENUE DETAIL BY FUND
General Fund (continued)
4626 Police - 30 Day Vehicle Impound Fee 148,420 182,940 179,660 266,600 224,770 4627 Police - School Resources Officer 72,610 - 99,450 28,720 94,450 4629 Animal Services - Spay/Neuter Fees - 640 1,000 1,000 590 4630 Animal Services - Animal Control Fees 800 1,050 1,200 1,200 1,300 4642 Fire Merger Reimbursement 10,190 10,810 - - - 4645 Public Works - Department Fees 217,760 81,060 50,000 250,000 100,000 4646 Public Works - Engr Map & Plan Check Fees 403,570 337,740 300,000 125,000 300,000 4654 Sport Field Usage 21,130 32,420 22,500 30,000 40,000 4655 Recreation - Recreation Program Fees 21,040 80 37,500 - 37,500 4656 Recreation - Youth Sports 27,170 - 1,000 1,000 - 4657 Recreation - User Fees 154,350 49,470 200,000 200,000 200,000 4658 Recreation - Special Events 100,870 46,670 77,300 65,700 55,000 4659 Senior Center Program Fees 8,680 2,570 6,000 6,000 6,000 4660 Youth Partnership Program 3,870 690 - - - 4665 Library - Photocopy Revenue 3,750 600 500 500 500 4667 Landecena - Program Fees 2,660 - 3,400 1,500 3,000 4679 Library - Passport Services 27,430 5,610 20,000 36,000 30,000 4680 User Dept- OPEB 115,620 133,730 - - - 2,809,780$ 2,384,400$ 2,095,270$ 2,504,900$ 2,411,130$ 4701 Non-Vehicle Code Fines 320$ 180$ 210$ 90$ 130$ 4702 Vehicle Code Fines 183,870 95,540 130,000 130,730 130,000 4703 Red Light Code Fines 26,280 9,210 - 13,000 11,100 4704 Muni-Code- Code Enforcement Fines 175,670 6,990 13,000 8,400 13,000 4705 Muni Code- Animal Fines 3,650 5,480 5,200 2,050 2,500 4706 Muni Code- Parking Citation Fines 149,810 121,370 100,000 187,500 150,000 4707 Muni Code- Business License Fines 170,910 154,930 95,000 95,000 110,000 4708 Muni Code- False Alarm Fines 171,470 143,550 150,000 149,640 146,600 4709 Muni Code- Library Fines 11,990 5,350 3,750 3,750 2,500 893,970$ 542,600$ 497,160$ 590,160$ 565,830$ 4801 Interest Earnings 637,640$ 905,420$ 60,000$ 60,000$ 110,000$ 4802 Lease of City Property 758,420 782,960 806,570 806,570 807,030 4803 Rents - Recreation 20,730 2,200 12,000 2,000 12,000 4804 Rents - Park Sites 17,770 17,520 17,500 17,500 25,000 4806 Rental Income- Landecena (600) - - - - 4807 Rents - Library 2,310 - 3,000 3,000 3,000 4814 City Stop Sales 250 80 - - - 4872 Unrealized Gain/Loss 100,830 (106,950) - - - 4901 Sale of Assets - 31,220 - - - 1,537,350$ 1,632,450$ 899,070$ 889,070$ 957,030$ 4904 Donations - General 5,990$ 7,700$ -$ -$ -$ 4905 Donation - Police 6,310 580 - - - 4908 Miscellaneous Reimbursements 4,590 326,760 53,890 30 40,000 4909 Other Revenue 163,480 244,110 90,000 102,300 106,360 4910 Water - Administrative Service Fee 1,404,900 1,404,900 1,404,900 1,727,000 1,727,000 4911 Solid Waste - Administrative Service Fee 481,780 481,780 481,780 546,540 559,710 4912 Sewer - Administrative Service Fee 472,000 472,000 472,000 559,710 546,540 4913 Cash- Over/ Short 260 (10) - - - 4914 15% PBIA Admin Fee (Fire Merge)7,810 10,040 8,780 8,780 8,780 4915 Donations - Animal 250 290 250 150 150 4916 Misc. Reimbursements - Animal Services 1,650 460 300 150 - 4917 Litigation Reimbursement 24,310 - - - - 4918 Prior Year Revenue 15,630 - - - - 4919 Administrative Service Fee 482,890 482,890 482,890 615,580 615,590 3,071,850$ 3,431,500$ 2,994,790$ 3,560,240$ 3,604,130$ 45,548,730$ 49,165,380$ 44,891,140$ 48,863,370$ 50,181,580$ Revenue from Charges for Service
Revenue from Fines & Forfeitures
Revenue from Use of Money & Property
Other Revenue
Total General Fund

Page 6 of 214 ends

Object 2019-20 2020-21 2021-22 2021-22 2022-23
Code Actual Actual Adopted Amended Proposed
2022-2023 SCHEDULE OF REVENUE DETAIL BY FUND
Housing Fund
4801 Interest Income 48,130$ 21,420$ 23,000$ 23,000$ 15,000$ 4805 Rents - Apartments Market - - 4,400,000 4,400,000 4,600,000 4872 Unrealized Gain/Loss 20,160 (21,810) - - - 4908 Miscellaneous Reimbursements 970 - 184,780 184,780 196,280 4909 Other Revenue 156,330 231,280 25,000 25,000 2,000 4918 Prior Year Revenue (136,630) - - - - 88,960$ 230,890$ 4,632,780$ 4,632,780$ 4,813,280$ 4106 Sales Tax- Prop 172 988,430$ 1,056,740$ 1,339,880$ 1,339,880$ 1,422,700$ 4801 Interest Income 2,400 1,220 - - - 4872 Unrealized Gain/Loss (280) - - - - 990,550$ 1,057,960$ 1,339,880$ 1,339,880$ 1,422,700$ 4450 Gas Tax Apportionment 2107.5 7,500$ 7,500$ 7,500$ 7,500$ 7,500$ 4451 Gas Tax Apportionment 2106 245,810 250,530 275,070 275,070 310,160 4452 Gas Tax Apportionment 2107 505,500 543,340 574,900 574,900 692,040 4453 Gas Tax Apportionment 2105 400,340 401,530 451,760 451,760 506,560 4456 Gas Tax Apportionment 2103 541,160 525,830 693,300 693,300 773,280 4457 Gas Tax Apportionment 2032 1,359,280 - - - - 4801 Interest Income 132,050 57,190 50,000 50,000 - 4872 Unrealized Gain/Loss 57,390 (60,360) - - - 4908 Miscellaneous Reimbursements 568,360 - - - - 4909 Other Revenue 88,250 2,330 - - - 3,905,640$ 1,727,890$ 2,052,530$ 2,052,530$ 2,289,540$ 4501 Measure I Apportionment 1,574,580$ 1,782,330$ 1,364,270$ 1,364,270$ 1,623,180$ 4801 Interest Income 108,270 44,350 45,000 45,000 - 4872 Unrealized Gain/Loss 47,280 (49,870) - - - 1,730,130$ 1,776,810$ 1,409,270$ 1,409,270$ 1,623,180$ 4457 Gas Tax Apportionment 2032 -$ 1,461,100$ 1,533,890$ 1,533,890$ 1,789,680$ 4801 Intereset Income - 4,000 - - - 4872 Unrealized Gain/Loss - 680 - - - -$ 1,465,780$ 1,533,890$ 1,533,890$ 1,789,680$ HOME Investment Partnership Program Fund
4801 Interest Income 23,780$ 12,150$ 800$ 800$ 800$ 4872 Unrealized Gain/Loss (2,570) - - - - 4918 Prior Year Revenue (150,350) - - - - 4921 Program Income- Admin 10%22,740 5,820 5,000 5,000 5,000 4922 Recaptured Income 128,770 - 5,000 5,000 1,000 4923 Program Income Revenue- HIP 140,050 16,380 25,000 25,000 1,500 4924 Program Income Revenue- FTHB 52,860 114,660 40,000 40,000 40,000 215,280$ 149,010$ 75,800$ 75,800$ 48,300$ Community Development Block Grant Fund
4310 CDBG Apportionment 367,690$ 359,110$ 1,426,860$ 1,965,190$ 794,680$ 367,690$ 359,110$ 1,426,860$ 1,965,190$ 794,680$ Parking Business Improvement Area Fund
4108 Park & Bus Imp Tax- Zone A 51,870$ 49,660$ 49,000$ 49,000$ 49,000$ 4109 Park & Bus Imp Tax- Zone B 9,930 9,130 9,500 9,500 9,500 4801 Interest Earnings 5,060 1,660 500 500 100 4872 Unrealized Gain/Loss (520) - - - - Total Housing Fund
Public Safety Augmentation Fund
Total Public Safety Augmentation Fund
Gas Tax Fund
Total Gas Tax Fund
Measure I Fund
Total Measure I Fund
Road Maintenance Rehabiliation Account Fund
Total Road Maintenance Rehabiliation Account Fund
Total HOME Fund
Total Community Development Block Grant Fund

Page 7 of 214 ends

Object 2019-20 2020-21 2021-22 2021-22 2022-23
Code Actual Actual Adopted Amended Proposed
2022-2023 SCHEDULE OF REVENUE DETAIL BY FUND
Parking Business Improvement Area Fund (continued)
Total Parking Business Improvement Area Fund 66,340$ 60,450$ 59,000$ 59,000$ 58,600$ 4360 SCIP Grant 160,000$ -$ -$ -$ -$ 4502 Motor Vehicle AB2766 Fees 99,400 102,910 99,400 99,400 99,400 4801 Interest Income 1,760 1,130 - - - 4872 Unrealized Gain/Loss (450) - - - - 4909 Other Revenue - 860 - - - 260,710$ 104,900$ 99,400$ 99,400$ 99,400$ 4342 Homeland Security Grant- 2015 22,940$ 28,330$ -$ 11,400$ -$ Total Homeland Security Grants Fund - PD 22,940$ 28,330$ -$ 11,400$ -$ 4801 Interest Income 2,840$ 1,140$ 900$ 900$ -$ 4872 Unrealized Gain/Loss (330) - - - - 2,510$ 1,140$ 900$ 900$ -$ 4423 COPS 184,950$ 187,380$ 120,000$ 120,000$ 120,000$ 4801 Interest Income 15,690 7,460 - - - 4872 Unrealized Gain/Loss (1,500) - - - - 199,140$ 194,840$ 120,000$ 120,000$ 120,000$ 4355 State Reimbursements 51,830$ 12,110$ -$ 277,840$ 277,840$ 4415 State Revenue 1,870.00 13,080 - 310,000 377,500 4483 Library Literacy - Donations 270 - - - - 4507 County Grant Revenue - - - 585,000 - 4509 JPL NASA Grant 90 - - - - 4801 Interest Income 400 - - - - 4872 Unrealized Gain/Loss (30) - - - - 4908 Miscellaneous Reimbursements - - 225,070 225,070 - 4909 Other Revenue 380 150 41,910 41,910 - 54,810$ 25,340$ 266,980$ 1,439,820$ 655,340$ Office of Traffic Safety Fund
4432 OTS- Sobriety Checkpoint Grants 182,850$ 103,200$ 45,430$ 238,430$ 154,270$ Total Office of Traffic Safety Fund 182,850$ 103,200$ 45,430$ 238,430$ 154,270$ Other Public Safety Grants
4355 State Reimbursements -$ 157,620$ 11,320$ 11,320$ -$ Total Local Law Enforcement Block Grants Fund -$ 157,620$ 11,320$ 11,320$ -$ 4435 Asset Forfeiture- Federal -$ 15,110$ -$ -$ -$ 4801 Interest Income 9,230 3,950 - - - 4872 Unrealized Gain/Loss (1,130) - - - - 8,100$ 19,060.00$ -$ -$ -$ 4801 Interest Income 8,130$ 3,710$ 200$ 200$ 200$ 4872 Unrealized Gain/Loss (900) - - - - 4918 Prior Year Revenue (29,400) - - - - 4923 Program Income - HIP - 79,330 25,000 25,000 10,000 4924 Program Income - FTHB 65,690 89,900 5,000 5,000 25,000 43,520$ 172,940.00$ 30,200$ 30,200$ 35,200$ Total Air Quality Management District Fund
Air Quality Management District (AQMD) Fund
CalHOME Investment Partnership Program Fund
Homeland Security Grants Fund - PD
Proposition 30 Fund
Total Proposition 30 Fund
COPS Fund
Total COPS Fund
Other Grants Fund
Total Other Grants Fund
Asset Forfeiture Fund
Total Asset Forfeiture Fund
Total CalHOME Fund

Page 8 of 214 ends

Object 2019-20 2020-21 2021-22 2021-22 2022-23
Code Actual Actual Adopted Amended Proposed
2022-2023 SCHEDULE OF REVENUE DETAIL BY FUND
4801 Interest Income 180$ 80$ -$ -$ -$ 4872 Unrealized Gain/Loss (20) - - - - 160$ 80$ -$ -$ -$ 4321 H&S Police Forfeiture 2,200$ 60$ -$ -$ -$ 4422 Asset Forfeiture - State 12,490 320 - - - 4801 Interest Income 3,440 1,460 - - - 4872 Unrealized Gain/Loss (390) - - - - 17,740$ 1,840$ -$ -$ -$ 4801 Interest Income 1,540$ 620$ -$ -$ -$ 4872 Unrealized Gain/Loss (180) - - - - 1,360$ 620$ -$ -$ -$ 4439 Federal CARES Act Funding 324,380$ 2,141,160$ -$ -$ -$ 4801 Interest Income - 2,060 - - - 324,380$ 2,143,220$ -$ -$ -$ 4439 Federal OJP Funding -$ 41,500$ -$ -$ -$ Total Office of Justice Programs -$ 41,500$ -$ -$ -$ 4439 Federal ARPA Funding -$ -$ 7,960,000$ 7,960,000$ -$ 4801 Interest Income - 4,740 - - 35,000 Total American Rescue Plan Act -$ 4,740$ 7,960,000$ 7,960,000$ 35,000$ General Capital Improvements Fund
4219 General Capital Impact Fee 210,270$ 181,110$ 110,000$ 110,000$ 100,000$ 4220 Fire Capital Impact Fee 138,050 - 56,000 56,000 - 4221 Police Capital Impact Fee 253,240 164,640 101,000 101,000 95,000 4801 Interest Income 34,980 15,560 12,000 12,000 - 4872 Unrealized Gain/Loss 15,580 (15,850) - - - 652,120$ 345,460$ 279,000$ 279,000$ 195,000$ 4107 Construction Tax 1,577,370$ 1,660,910$ 1,192,920$ 1,192,920$ 800,000$ 4801 Interest Income 148,870 66,580 50,000 50,000 - 4872 Unrealized Gain/Loss 65,600 (67,410) - - - 4918 Prior Year Revenue - (87,820) - - - 1,791,840$ 1,572,260$ 1,242,920$ 1,242,920$ 800,000$ 4211 Storm Drain Permits 787,710$ 786,520$ 310,500$ 310,500$ 290,000$ 4801 Interest Income 72,900 32,370 26,000 26,000 - 4872 Unrealized Gain/Loss 31,170 (33,050) - - - 4902 Lease Proceeds 79,100 73,860 74,210 74,210 76,200 970,880$ 859,700$ 410,710$ 410,710$ 366,200$ Street & Traffic Facility Development Fund
4212 Street & Traffic Facility Permits 401,530$ 464,480$ 185,000$ 185,000$ 370,000$ 4218 Developer Agreement Fees 47,230 - - - - 4801 Interest Income 20,520 18,080 16,000 16,000 16,000 4872 Unrealized Gain/Loss 2,460 (21,900) - - - Total Street & Traffic Facility Development Fund 471,740$ 460,660$ 201,000$ 201,000$ 386,000$ Park Acquisition & Development Fund
Asset Forfeiture - Federal Treasury
Total Asset Forfeiture-Federal Treasury
Asset Forfeiture - State
Total Asset Forfeiture - State
BSCC Budget Act
Total BSCC Budget Act

CARES ACT
Total CARES Act
Office of Justice Programs
Total General Capital Improvements Fund
American Rescue Plan Act
Total Park Acquisition & Development Fund
Storm Drain Development Fund
Total Storm Drain Development Fund

Page 9 of 214 ends

Object 2019-20 2020-21 2021-22 2021-22 2022-23
Code Actual Actual Adopted Amended Proposed
2022-2023 SCHEDULE OF REVENUE DETAIL BY FUND
Street & Alley Repairs Fund
4225 Street & Alley- Burrtec 211,710$ 216,350$ 220,680$ 220,680$ 240,000$ 4801 Interest Income 16,190 6,790 - - - 4872 Unrealized Gain/Loss 6,840 (7,410) - - - Total Street & Alley Repairs Fund 234,740$ 215,730$ 220,680$ 220,680$ 240,000$ Energy Efficiency Capital Improvement Project
4801 Interest Income 1,260$ 40$ -$ -$ -$ Total Energy Efficiency Capital Improvement Project 1,260$ 40$ -$ -$ -$ 4214 Water Construction Permits 611,690$ 690,510$ 400,000$ 400,000$ 350,000$ 4603 Damage to City Property 5,030 35,790 - - - 4681 Water Sales- Metered 25,716,830 27,401,300 27,800,000 27,800,000 30,302,000 4682 Water Sales- Flat Rate 59,720 58,750 55,000 55,000 55,000 4688 Water Sales- Recycled 444,030 511,010 540,000 540,000 - 4691 Water Meter Installation 133,090 137,230 105,000 105,000 105,000 4692 Lease of Stored Water 125,280 327,020 - - - 4697 Hydrant Flow Test 6,210 7,210 5,000 5,000 6,000 4698 Water Jumper Install Fee 17,430 19,040 - - - 4699 Joint Venture Net Income 1,919,880 1,908,830 - - - 4710 Municipal Code- Late Charges 150,040 30 - - - 4801 Interest Income 416,040 206,380 55,000 55,000 385,050 4802 Lease of City Property 15,900 - - - - 4872 Unrealized Gain/Loss 181,860 (185,170) - - - 4901 Sale of Capital Assets - 359,640 - - - 4904 General Donations/Owner Contributions 5,455,130 - - - - 4908 Miscellaneous Reimbursements 262,590 6,120 280,000 280,000 280,000 4909 Other Revenue 172,010 139,340 150,000 150,000 150,000 Total Water Utility Fund 35,692,760$ 31,623,030$ 29,390,000$ 29,390,000$ 31,633,050$ 4351 Beverage Recycling Grant -$ 2,480$ 19,480$ 19,480$ -$ 4352 Used Oil Block Grant - 21,150 21,160 21,160 - 4685 Solid Waste- Residential 5,026,500 5,550,690 5,701,370 5,701,370 6,600,000 4686 Solid Waste- Non-Residential 8,586,900 8,930,750 10,398,460 10,398,460 9,500,000 4689 HHW Transfer In 158,790 162,260 165,510 165,510 180,000 4801 Interest Income 40,070 13,020 15,000 15,000 5,000 4872 Unrealized Gain/Loss 16,570 (19,040) - - - 4908 Miscellaneous Reimbursement 200 - - - - 13,829,030$ 14,661,310$ 16,320,980$ 16,320,980$ 16,285,000$ 4210 Sanitary Sewer Permits- City 301,760$ 337,650$ 150,000$ 150,000$ 130,000$ 4213 Wastewater Permits 45,330 77,050 60,000 60,000 60,000 4683 Sewer Collection Charges 3,398,320 3,429,350 3,212,200 3,212,200 2,600,000 4684 Sewer Treatment- IEUA 6,801,500 6,894,970 7,034,430 7,034,430 7,400,000 4687 Sewer Connection Fees 690 22,750 16,600 16,600 16,600 4694 Sewer- Pass-Thru- Montclair 280 250 500 500 500 4695 Sewer- Pass-Thru- Ontario 42,600 40,570 48,000 48,000 50,000 4696 Sewer- Pass-Thru- LA County 15,380 15,210 18,000 18,000 18,000 4801 Interest Income 399,600 167,650 - - 155,500 4872 Unrealized Gain/Loss 116,990 (131,760) - - - 4901 Sales of Capital Assets 16,000 29,350 - - - 4904 General Donations/Owner Contributions 4,427,850 - - - - 4909 Other Revenue 950 1,130 - - - 15,567,250$ 10,884,170$ 10,539,730$ 10,539,730$ 10,430,600$ Water Utility Fund
Solid Waste Utility Fund
Total Solid Waste Utility Fund
Sewer Utility Fund
Total Sewer Utility Fund

Page 10 of 214 ends

Object 2019-20 2020-21 2021-22 2021-22 2022-23
Code Actual Actual Adopted Amended Proposed
2022-2023 SCHEDULE OF REVENUE DETAIL BY FUND
4801 Interest Income 8,760$ 3,520$ -$ -$ -$ 4872 Unrealized Gain/Loss (1,020) - - - - 7,740$ 3,520$ -$ -$ -$ 4610 Subrogation- Insurance Reimbursement -$ 1,455,010$ -$ -$ -$ 4671 User Departments- Workers Compensation 1,529,550 1,924,880 1,997,290 1,997,290 2,069,310 4672 User Departments- Unemployment 123,430 64,870 64,970 64,970 63,680 4673 User Departments- Long-Term Disability 123,210 125,140 125,000 125,000 90,990 4674 User Departments- Liability 2,275,280 2,443,260 2,503,830 2,503,830 2,978,470 4675 User Departments- Loss Prevention 126,060 124,980 127,260 127,260 72,460 4801 Interest Income 1,890 3,510 - - - 4908 Miscellaneous Reimbursements 3,390 1,710 - - - 4909 Other Revenue - 1,560 - - - 4,182,810$ 6,144,920$ 4,818,350$ 4,818,350$ 5,274,910$ 4676 User Departments- Vehicle Replacement 1,169,290$ 655,990$ 1,376,390$ 1,376,390$ 746,080$ 4801 Interest Income 13,030 5,580 - - - 4872 Unrealized Gain/Loss (1,730) - - - - 4901 Sale of Assets 32,250 66,650 59,000 59,000 34,000 4909 Other Revenue 120 - - - - 1,212,960$ 728,220$ 1,435,390$ 1,435,390$ 780,080$ 4125 PEG Fees 144,780$ 145,480$ 132,820$ 132,820$ 130,000$ 4669 User Departments- Information Systems 1,594,560 1,835,380$ 2,372,860 2,372,860$ 2,697,970 4801 Interest Income 27,180 15,520 - - - 4872 Unrealized Gain/Loss (2,890) - - - - 1,763,630$ 1,996,380$ 2,505,680$ 2,505,680$ 2,827,970$ 4670 User Departments- Building Maint & Operations 1,078,670$ 929,710$ 1,127,220$ 1,127,220$ 995,340$ 4801 Interest Income 27,030 9,920 - - - 4872 Unrealized Gain/Loss (2,500) - - - - 4909 Other Revenue - 300 - - - 1,103,200$ 939,930$ 1,127,220$ 1,127,220$ 995,340$ 4680 User Departments-UAL & Employee Benefits -$ -$ 10,168,860$ 10,226,640$ 7,583,450$ -$ -$ 10,168,860$ 10,226,640$ 7,583,450$ 4430 SA Administrative Allowance 250,000$ 172,890$ 250,000$ 250,000$ 250,000$ 4431 SA RPTTF 3,181,460 3,048,860 3,141,660 3,141,660 3,123,160 4801 Interest Income 32,550 1,130 17,300 17,300 1,000 4891 Repay SA Loans Interest - 8,550 - - - 4892 SA Loan Repay 49,920 18,750 - - - 4908 Miscellaneous Reimbursements - 250 - - - 3,513,930$ 3,250,430$ 3,408,960$ 3,408,960$ 3,374,160$ 135,027,430$ 132,678,410$ 148,024,860$ 153,970,440$ 145,292,510$ Total Self-Funded Insurance Fund
Fire Annexation Worker's Compensation
Total Fire Annexation Worker's Compensation
Self-Funded Insurance Fund
Successor Agency Fund
Total Successor Agency Fund
Grand Total
Fleet Management Fund
Total Fleet Management Fund
Information Systems Fund
Total Information Systems Fund
Building Maintenance & Operations Fund
Total Building Maintenance & Operations Fund
UAL & Employee Benefits
Total UAL and Employee Benefits

Page 11 of 214 ends

2022-2023 EXPENDITURES BY DEPARTMENT PROGRAM
2019-20 2020-21 2021-22 2021-22 2022-23
Actual Actual Adopted Amended Proposed
General Government
City Council 105,410$ 93,410$ 118,200$ 118,200$ 153,550$ City Treasurer 1,690 1,400 2,090 2,090 2,950 Administration 294,450 490,020 796,150 716,950 726,190 City Clerk - - - 617,770 603,850 Total General Government 401,550$ 584,830$ 916,440$ 1,455,010$ 1,486,540$ Administrative Services
Finance 2,277,580$ 1,361,910$ 1,545,730$ 1,529,280$ 1,677,570$ Non-Departmental 3,242,020 3,871,030 2,160,470 1,495,370 6,216,320 Library 1,483,100 1,589,920 1,368,040 1,759,230 1,918,420 Human Resources 767,770 616,720 616,470 616,470 635,290 City Attorney 411,670 630,020 500,000 500,000 500,000 City Clerk 231,430 492,540 416,250 - - Recreation Administration 726,660 749,130 850,820 855,530 975,970 Recreation Classes 164,790 30,850 159,350 127,300 165,750 Recreation Facilities 125,290 176,180 254,250 304,250 308,700 Recreation Parks 65,510 19,990 66,940 91,940 118,460 Senior Center 285,650 387,260 354,370 354,380 364,460 Special Events 120,540 55,690 99,940 154,290 188,030 Community Outreach Services 63,370 940 - - - Landecena Center 29,070 33,710 - - - Carnegie Library Operation 92,150 96,130 - - - Library Literacy Program 190 - - - - Passports 15,590 8,170 - - - Recreation Grants 740 110 - 585,000 - Risk Management 5,705,030 4,656,140 4,818,350 5,369,560 5,272,750 Information Technology 1,572,980 2,262,840 2,506,440 3,715,220 2,844,680 UAL & Employee Benefits - - 10,168,860 10,293,860 7,583,450 Total Administrative Services 17,381,130$ 17,039,280$ 25,886,280$ 27,751,680$ 28,769,850$ Development Services
Building & Safety 859,990$ 953,080$ 1,197,600$ 1,238,600$ 1,539,440$ Weed Abatement 31,110 14,650 77,330 111,830 93,590 Economic Development 300,760 323,520 293,710 364,300 408,380 Planning Commission 12,200 13,880 19,150 19,150 20,650 Planning 611,690 576,710 691,960 752,500 563,650 Santa Fe Depot 27,700 12,000 8,000 8,000 6,000 Housing 2,459,810 2,276,270 3,941,910 3,955,210 3,959,840 HOME Program 305,870 119,230 760,000 760,000 355,000 CBDG 367,690 864,800 1,426,860 1,975,210 794,680 PBIA 91,390 108,060 191,810 333,560 219,050 Development Grants 1,870 34,570 - 566,360 630,900 CalHOME Program 70,750 167,490 295,000 295,000 675,000 Energy Efficiency Capital Imp Project 78,920 28,640 - - - Successor Agency 945,020 929,150 3,374,630 3,375,960 3,364,170 Total Development Services 6,164,770$ 6,422,050$ 12,277,960$ 13,755,680$ 12,630,350$ Fire
Fire Station I 13,850$ -$ -$ -$ -$ Fire Station II 21,690 - - - - Fire Station III 20,220 - - - - Fire Station IV 20,410 - - - - Air Ambulance 4,930 - - - - Total Fire 81,100$ -$ -$ -$ -$

Page 12 of 214 ends

2022-2023 EXPENDITURES BY DEPARTMENT PROGRAM
2019-20 2020-21 2021-22 2021-22 2022-23
Actual Actual Adopted Amended Proposed
Police
Police Administration 5,248,240$ 5,572,370$ 10,861,660$ 11,717,080$ 10,878,150$ Investigations 2,778,670 3,113,740 2,893,120 2,923,780 2,707,580 Animal Services 606,340 586,940 692,210 694,710 710,980 Patrol 14,375,200 14,820,950 13,335,990 23,559,720 13,270,800 Police Special Events & Community Outreach 10,000 1,830 17,660 17,660 20,670 Police Reserves 670 1,460 6,300 6,300 6,780 Code Enforcement 739,690 580,610 671,350 813,850 798,700 Police Grants 265,440 577,130 1,238,110 1,463,510 1,313,470 Total Police 24,024,250$ 25,255,030$ 29,716,400$ 41,196,610$ 29,707,130$ Public Works
Public Works Administration 692,960$ 798,000$ 1,413,370$ 1,840,370$ 1,422,000$ Engineering Administration 458,200 368,390 203,480 207,480 197,860 Development/Traffic Engineering 487,410 503,490 629,870 629,870 898,020 Street Maintenance 533,600 623,400 940,720 1,167,220 814,240 Street Sweeping 18,200 19,590 15,800 15,800 16,280 Sidewalk Maintenance 184,260 172,490 177,080 883,080 157,790 Street Lighting 919,510 893,040 776,860 787,360 806,770 Traffic Control 150,690 165,980 144,010 149,010 139,790 Traffic Facility Maintenance 281,230 272,370 257,300 257,300 274,300 Weed Abatement 47,370 28,240 21,940 21,940 23,770 Flood Control 7,000 4,000 2,000 2,000 3,000 Street Tree Maintenance 826,220 733,640 713,510 880,510 789,240 Public ROW Maintenance 460,890 513,430 440,190 545,190 958,460 Maintenance - Main Street 55,790 58,230 47,910 47,910 40,430 Maintenance - Metrolink 47,180 61,540 204,640 204,640 186,660 Graffiti Abatement 54,030 70,020 80,000 80,000 80,000 Damage to City Property 47,770 50,860 55,000 55,000 66,000 Park Maintenance 638,010 561,420 794,240 804,240 915,810 Sports Field Maintenance 229,990 225,270 221,370 247,370 409,340 Civic Center 307,740 320,820 192,560 192,560 199,460 Fire Fuel 19,730 12,450 14,000 14,000 14,000 Fire Station II Building 85,320 21,010 48,070 48,070 64,940 Historic Fire Station Building 15,750 13,690 36,440 36,440 38,890 Street Projects 2,455,170 4,684,220 17,188,130 17,168,720 22,335,280 General Capital Improvement - ARPA - - - 92,000 4,055,360 General Capital Improvement - 36,830 555,000 560,260 555,000 Park Acquisition & Development 26,570 151,680 664,500 650,190 1,290,050 Storm Drain Development 20,490 116,760 3,692,200 3,600,900 3,531,100 Street & Traffic Facility Development - 1,541,250 1,914,060 1,428,510 1,344,400 General Capital Projects 400,610 515,220 1,334,330 1,423,350 1,448,840 Street & Alley Repairs 10,250 511,500 584,100 572,120 890,200 Water Utility 22,094,390 26,908,310 45,162,860 45,900,100 47,648,290 Solid Waste Utility 13,329,270 14,408,090 15,113,800 15,175,620 15,798,500 Sewer Utility 9,849,710 9,796,450 13,353,490 13,506,340 15,001,200 Fleet Maintenance & Replacement 1,366,390 1,215,670 1,376,390 2,225,970 891,580 Building Maintenance & Operations 986,260 966,970 1,428,970 1,439,050 1,458,100 Total Public Works 57,107,960$ 67,344,320$ 109,798,190$ 112,860,490$ 124,764,950$ Grand Total 105,160,760$ 116,645,510$ 178,595,270$ 197,019,470$ 197,358,820$ Transfers not included in the Schedule of Expenditures by Department Program.

Page 13 of 214 ends

2022-2023 SCHEDULE OF EXPENDITURES BY FUND & CATEGORY
Fund
No.

Salaries &
Benefits
Maintenance &
Operations
Capital
Projects &
Equipment Total
101 General Fund 19,928,570$ 29,872,930$ 10,000$ 49,811,500$ Total General Fund 19,928,570$ 29,872,930$ 10,000$ 49,811,500$ 201 Housing 604,630$ 3,355,210$ -$ 3,959,840$ 203 Public Safety Augmentation 1,422,700 - - 1,422,700 204 Gas Tax 182,710 685,800 8,629,410 9,497,920 205 Measure I 142,620 279,040 7,766,960 8,188,620 206 Road Maintenance Rehabiliation Account 43,340 62,430 4,542,970 4,648,740 208 HOME Investment Partnership Program - 355,000 - 355,000 209 Community Development Block Grant 45,760 748,920 - 794,680 210 Parking Business Improvement Area - 88,500 130,550 219,050 211 Air Quality Management District 4,430 11,000 148,000 163,430 214 Homeland Security Grants - PD - - - - 215 Prop 30 - - 150,000 150,000 216 COPS - - 1,157,660 1,157,660 217 Other Grants 121,420 509,480 - 630,900 218 Office of Traffic Safety - 5,810 - 5,810 219 Local Law Enforcement Block Grants - - - - 222 CalHOME - 675,000 - 675,000 224 Asset Forfeiture State - - - - 226 Federal Grant - CARES Act - - - - 227 Office Of Justice Programs - - - - 229 American Rescue Plan Act 2,583,100 - 4,172,560 6,755,660 Total Special Revenue Funds 5,150,710$ 6,776,190$ 26,698,110$ 38,625,010$ 420 General Capital Improvements -$ -$ 555,000$ 555,000$ 421 Park Acquisition & Development - - 1,290,050 1,290,050 422 Storm Drain Development - - 3,531,100 3,531,100 423 Street & Traffic Facility Development 9,440 2,440 1,332,520 1,344,400 425 General Capital Projects - - 1,448,840 1,448,840 426 Street & Alley Repairs 47,190 12,200 830,810 890,200 427 Energy Efficiency Capital Imp Project - - - - Total Capital Project Funds 56,630$ 14,640$ 8,988,320$ 9,059,590$ 640 Water Utility 4,259,620$ 24,540,200$ 18,848,470$ 47,648,290$ 641 Solid Waste Utility 676,160 15,002,830 119,510 15,798,500 645 Sewer Utility 1,551,300 9,877,060 3,572,840 15,001,200 Total Enterprise Funds 6,487,080$ 49,420,090$ 22,540,820$ 78,447,990$ 751 Self-Funded Insurance 290,590$ 4,982,160$ -$ 5,272,750$ 752 Fleet Maintenance & Replacement 304,550 381,780 205,250 891,580 753 Information Systems 495,020 2,259,160 90,500 2,844,680 754 Building Maintenance & Operations 520,340 897,760 40,000 1,458,100 755 UAL & Employee Benefits - 7,583,450 - 7,583,450 Total Internal Service Funds 1,610,500$ 16,104,310$ 335,750$ 18,050,560$ 805 Successor Agency 171,890$ 3,192,280$ -$ 3,364,170$ Total Private Purpose Trust Fund 171,890$ 3,192,280$ -$ 3,364,170$ Grand Total 33,405,380$ 105,380,440$ 58,573,000$ 197,358,820$ Transfers not included in the Schedule of Expenditures by Fund and Category.

Page 14 of 214 ends

2022-2023 SCHEDULE OF EXPENDITURES BY FUND
Fund 2019-20 2020-21 2021-22 2021-22 2022-23
No.Actual Actual Adopted Amended Proposed
101 General Fund 40,900,700$ 41,918,660$ 45,763,110$ 56,296,220$ 49,811,500$ Total General Fund 40,900,700$ 41,918,660$ 45,763,110$ 56,296,220$ 49,811,500$ 201 Housing 2,459,340$ 2,276,270$ 3,941,910$ 3,955,210$ 3,959,840$ 203 Public Safety Augmentation 990,550 1,057,960 1,339,880 1,339,880 1,422,700 204 Gas Tax 1,908,330 3,002,730 9,135,880 9,075,510 9,497,920 205 Measure I 546,840 1,641,420 6,631,740 6,660,870 8,188,620 206 Road Maintenance Rehabiliation Account - 40,070 1,420,510 1,432,340 4,648,740 208 HOME Investment Partnership Program 305,870 119,230 760,000 760,000 355,000 209 Community Development Block Grant 367,690 864,800 1,426,860 1,975,210 794,680 210 Parking Business Improvement Area 91,390 108,060 191,810 213,560 219,050 211 Air Quality Management District 309,540 141,180 177,410 194,570 163,430 214 Homeland Security Grants - PD 22,940 28,340 - 32,400 - 215 Prop 30 - - 150,000 150,000 150,000 216 COPS 47,900 47,000 985,150 985,150 1,157,660 217 Other Grants 54,450 79,610 266,980 1,418,340 630,900 218 Office of Traffic Safety 130,100 124,940 49,730 242,730 5,810 219 Other Public Safety Grants 11,660 288,920 11,320 11,320 - 222 CalHOME 70,750 167,490 295,000 295,000 675,000 224 Asset Forfeiture State 1,000 1,500 - - - 226 Federal Grant - CARES Act 571,080 679,910 - 34,020 - 227 Office Of Justice Programs - 41,500 - - - 229 American Rescue Plan Act - - - 2,811,660 6,755,660 Total Special Revenue Funds 7,889,430$ 10,710,930$ 26,784,180$ 31,587,770$ 38,625,010$ 420 General Capital Improvements -$ 265,640$ 555,000$ 592,750$ 555,000$ 421 Park Acquisition & Development 26,570 151,680 664,500 650,190 1,290,050 422 Storm Drain Development 20,490 116,760 3,692,200 3,600,900 3,531,100 423 Street & Traffic Facility Development - 1,541,250 1,914,060 1,428,510 1,344,400 425 General Capital Projects 411,030 515,220 1,334,330 1,423,350 1,448,840 426 Street & Alley Repairs 10,250 511,500 584,100 572,120 890,200 427 Energy Efficiency Capital Imp Project 78,920 28,640 - - - Total Capital Project Funds 547,260$ 3,130,690$ 8,744,190$ 8,267,820$ 9,059,590$ 640 Water Utility 22,094,390$ 26,908,090$ 45,162,860$ 45,900,100$ 47,648,290$ 641 Solid Waste Utility 13,329,270 14,408,090 15,113,800 15,175,620 15,798,500 645 Sewer Utility 9,849,710 9,795,880 13,353,490 13,506,340 15,001,200 Total Enterprise Funds 45,273,370$ 51,112,060$ 73,630,150$ 74,582,060$ 78,447,990$ 751 Self-Funded Insurance 5,693,510$ 4,656,140$ 4,818,350$ 5,369,560$ 5,272,750$ 752 Fleet Management 1,366,390 1,215,670 1,376,390 2,225,970 891,580 753 Information Systems 1,564,430 2,005,240 2,506,440 3,581,200 2,844,680 754 Building Maintenance & Operations 980,650 966,970 1,428,970 1,439,050 1,458,100 755 UAL & Employee Benefits - - 10,168,860 10,293,860 7,583,450 Total Internal Service Funds 9,604,980$ 8,844,020$ 20,299,010$ 22,909,640$ 18,050,560$ 805 Successor Agency 945,020$ 929,150$ 3,374,630$ 3,375,960$ 3,364,170$ Total Private Purpose Trust Fund 945,020$ 929,150$ 3,374,630$ 3,375,960$ 3,364,170$ Grand Total 105,160,760$ 116,645,510$ 178,595,270$ 197,019,470$ 197,358,820$ Transfers not included in the Schedule of Expenditures by Fund.

Page 15 of 214 ends

CAPITAL IMPROVEMENT PROGRAM
FY 2022-23
2022/2023
Proposed
CIP
Budget
204 7003 Pavement Management System 135,490 131,960 (5,330) 126,630 - 35,000 161,630 204 7031 Traffic Safety Projects - Annual 72,150 69,450 (2,250) 67,200 - - 67,200 204 7069 Arrow Highway Rehab (Benson to Mountain)1,125,050 1,094,830 (3,760) 1,091,070 - 300,000 1,391,070 204 7070 Citywide Concrete Maintenance 2018/19 74,340 74,340 - 74,340 (74,340) - - 204 7071 Citywide Concrete Repairs 2018/19 22,560 17,700 (1,030) 16,670 (16,670) - - 204 7076 Alpine Street Rehab (West End to Palm Ave.)696,620 684,680 (12,320) 672,360 - - 672,360 204 7077 Vernon Drive (West End to Palm Ave.)380,240 368,390 (12,070) 356,320 - - 356,320 204 7078 Palm Avenue (9th Street to Arrow Hwy.)770,270 758,440 (14,180) 744,260 - - 744,260 204 7080 Citywide Concrete Repairs 2019/20 47,110 32,290 - 32,290 (32,290) - - 204 8617 Arrow Route Widening
(Monte Vista Avenue to San Antonio Channel East)
249,480 249,480 - 249,480 (150,000) - 99,480 204 9124 Arrow Highway Rehab (Mountain to San Antonio)973,710 945,820 (3,650) 942,170 - 300,000 1,242,170 204 7500 70002 Citywide Concrete Repairs 2020/21 300,000 300,000 (263,920) 36,080 (36,080) - - 204 7500 70003 Citywide Striping Replacement 2020/21 196,790 190,030 (15,070) 174,960 - - 174,960 204 7500 70004 Citywide Crack Seal/Slurry Seal/Rubberized Overlay 2020/21
491,180 486,120 (181,110) 305,010 - - 305,010 204 7500 70005 14th Street Rehab (Campus to Grove)109,950 109,950 - 109,950 - - 109,950 204 7500 70007 City/County North Shared Roadways Project 1,000,000 1,000,000 (1,120) 998,880 - 256,120 1,255,000 204 7500 70008 Citywide Concrete Repairs 2021/22 500,000 500,000 (500,000) - - - - 204 7500 70009 Citywide Striping Replacement 2021/22 150,000 150,000 - 150,000 - - 150,000 204 7500 70010 Citywide Crack Seal/Slurry Seal 2021/22 500,000 500,000 - 500,000 - - 500,000 204 7500 70011 Foothill Blvd. Rehab (Mountain to San Antonio)550,000 550,000 - 550,000 (550,000) - - 204 7500 XXXXX Citywide Concrete Repairs 2022/23 - - - - 500,000 500,000 204 7500 XXXXX Citywide Striping Replacement 2022/23 - - - - 400,000 400,000 204 7500 XXXXX Citywide Crack Seal/Slurry Seal 2022/23 - - - - 500,000 500,000 Total Gas Tax 8,344,940 8,213,480 (1,015,810) 7,197,670 (859,380) 2,291,120 8,629,410 205 7339 Campus Ave. Rehab (9th St. to Foothill Blvd.)1,571,280 1,570,560 (4,670) 1,565,890 - - 1,565,890 205 7340 17th Street Reconstruction (San Antonio to Euclid)623,450 623,450 (25,530) 597,920 - 300,000 897,920 205 7341 San Bernardino Valley Coordinated Traffic Signal System 6,840 6,840 - 6,840 (6,840) - - 205 7343 19th Street Reconstruction (Mountain to Euclid)1,450,000 1,450,000 - 1,450,000 - - 1,450,000 205 7345 Grove Avenue Rehab (Foothill to 15th Street)1,189,850 1,189,380 (80) 1,189,300 - 290,000 1,479,300 205 7346 Citywide Pavement Maintenance 2019/2020 139,140 139,140 (124,740) 14,400 (14,400) - - 205 9122 13th Street Reconstruction (Euclid to Campus)645,320 639,560 (452,020) 187,540 (187,540) - - 205 7500 74002 Citywide Pavement Maintenance 2020/2021 290,000 290,000 (268,970) 21,030 (21,030) - - 205 7500 74003 Phase-II of the Metrolink Station Accessibility Improvement Project (ATP Cycle 4)
50,330 45,780 (6,650) 39,120 - - 39,120 205 7500 74004 Citywide Pavement Maintenance 2021/2022 300,000 299,870 (165,140) 134,730 - - 134,730 205 7500 XXXXX 18th Street Rehab (Mountain to Euclid)- - - - 1,000,000 1,000,000 205 7500 XXXXX Citywide Pavement Maintenance 2022/2023 - - - - 250,000 250,000 205 7500 XXXXX Mountain Avenue Rehab (20th to 23rd)- - - - 950,000 950,000 Total Measure I 6,266,210 6,254,580 (1,047,800) 5,206,770 (229,810) 2,790,000 7,766,960 206 7500 70006 Mulberry Avenue Reconstruction
(Foothill Blvd. to Pine Street)
348,320 348,100 (5,130) 342,970 - 85,000 427,970 206 7500 70005 14th Street Rehab (Campus to Grove)980,000 980,000 - 980,000 - 260,000 1,240,000 206 7500 XXXXX Foothill Blvd. Rehab (Benson to Mountain)- - - - 1,475,000 1,475,000 206 7500 XXXXX Foothill Blvd. Rehab (Mountain to San Antonio)- - - - 1,400,000 1,400,000 Total RMRA 1,328,320 1,328,100 (5,130) 1,322,970 - 3,220,000 4,542,970 209 7613 Landecena Interior Improvements 97,790 95,890 (87,080) 8,810 (8,810) - - Total CDBG 97,790 95,890 (87,080) 8,810 (8,810) - - 210 7702 Parking Lot Rehabilitation (1st Ave. & "A" Street)138,830 138,830 (8,280) 130,550 - - 130,550 Total PBIA 138,830 138,830 (8,280) 130,550 - - 130,550 229 7500 16150 ARPA Alley Rehabilitation Phase 1 - 556,000 (11,380) 544,620 - - 544,620 229 7500 16159 Civic Center Paving and ADA - 92,000 (80,260) 11,740 - - 11,740 229 7500 XXXXX ARPA Alley Rehabilitation Phase 2 - 444,000 - 444,000 - - 444,000 229 7500 XXXXX ARPA Concrete Repairs FY 2021/2022 - 526,000 - 526,000 - - 526,000 229 7500 XXXXX ARPA Concrete Repairs FY 2022/2023 - - - - - 474,000 474,000 229 7500 XXXXX ARPA Park Parking Lot Improvements - - - - - 1,250,000 1,250,000 2021/2022
Projected
Expenses
Projected
Balance
6/30/2022
Return to Fund
Balance
2022/2023
New
Approp.

Fund Proj.

No.

Proj.

ID
Project Description 2021/2022
Adopted
CIP
Budget
2021/2022
Amended
CIP
Budget

Page 16 of 214 ends

CAPITAL IMPROVEMENT PROGRAM
FY 2022-23
2022/2023
Proposed
CIP
Budget
2021/2022
Projected
Expenses
Projected
Balance
6/30/2022
Return to Fund
Balance
2022/2023
New
Approp.

Fund Proj.

No.

Proj.

ID
Project Description 2021/2022
Adopted
CIP
Budget
2021/2022
Amended
CIP
Budget
229 8001 Pavement Management System Report and Pavement Master Plan
- 200,000 - 200,000 - - 200,000 229 8003 Sidewalk Inventory and Repair Master Plan - 180,000 - 180,000 - - 180,000 229 8004 Public Facilities ADA Master Plan - 250,000 - 250,000 - - 250,000 229 8005 Traffic Signal Assessment and Master Plan - 175,000 - 175,000 - - 175,000 Total American Rescue Plan Act (ARPA)- 2,423,000 (91,640) 2,331,360 - 1,724,000 4,055,360 420 7500 80001 PD Women's Locker Room 225,000 225,000 - 225,000 - - 225,000 420 7500 80002 Men's Locker Replacement (PD)330,000 330,000 - 330,000 - - 330,000 Total Development Improvements 555,000 555,000 - 555,000 - - 555,000 421 8203 Sports Park 85,120 86,150 - 86,150 - - 86,150 421 8209 Magnolia Restroom ADA Compliance 23,400 23,400 - 23,400 (23,400) - - 421 8231 Memorial Park 18,980 3,240 (1,040) 2,200 (2,200) - - 421 7500 82338 Downtown Urban Space 272,000 266,340 (12,360) 253,980 - - 253,980 421 7500 82339 Dog Park Improvements 200,000 200,000 (80) 199,920 - - 199,920 421 7500 XXXXX Shade Structures for Park Picnic Areas
(Citrus Park, Greenbelt Park, and Sierra Vista Park)
- - - - 550,000 550,000 421 7500 XXXXX Citrus Park Snackbar/Admin Building Roof Replacement - - - - 200,000 200,000 Total Park Acquisition & Development 599,500 579,130 (13,480) 565,650 (25,600) 750,000 1,290,050 422 8402 Misc. Storm Drain Replacements - Annual 191,390 191,390 - 191,390 - - 191,390 422 8405 Euclid Avenue Storm Drain 91,730 91,730 - 91,730 - - 91,730 422 8408 Storm Drain Master Plan Improvements - Phase 1 99,770 99,770 - 99,770 - - 99,770 422 8411 SP/PE Trail Storm Drain Improvements 159,630 69,180 (6,630) 62,540 (62,540) - - 422 7500 84001 Arrow Hwy. Storm Drain Improvements
(Benson to Fairwood)
1,449,680 1,448,830 (610) 1,448,210 - - 1,448,210 422 7500 84002 Campus Ave. Storm Drain (Arrow Hwy. to Foothill)1,700,000 1,700,000 - 1,700,000 - - 1,700,000 Total Storm Drain Development 3,692,200 3,600,900 (7,240) 3,593,640 (62,540) - 3,531,100 423 8617 Arrow Route Widening (Monte Vista to Central)600,000 600,000 - 600,000 - - 600,000 423 8622 I-10 & Euclid Avenue Interchange Project 634,960 171,750 - 171,750 - - 171,750 423 8623 I-10 & Monte Vista Avenue Interchange Project 454,790 454,600 (343,830) 110,770 - - 110,770 423 8624 Traffic Signal Upgrades 2018-19 62,900 31,260 (16,200) 15,060 (15,060) - - 423 8625 Traffic Signal Upgrades 2019-20 150,000 150,000 - 150,000 - - 150,000 423 7500 XXXXX LSRP Intersection Improvements 2022-23 - - - - 300,000 300,000 Total Street & Traffic Facilitiy Development 1,902,650 1,407,610 (360,030) 1,047,580 (15,060) 300,000 1,332,520 425 8040 Utility Undergrounding 2019 962,800 984,800 (790) 984,010 - - 984,010 425 7500 82336 Civic Center Paving and ADA 171,530 171,530 (146,700) 24,830 - - 24,830 425 7500 82341 Animal Shelter Generator Improvements 150,000 150,000 - 150,000 - - 150,000 425 7500 82342 Police Dept. Generator Improvements 50,000 50,000 - 50,000 - - 50,000 425 7500 XXXXX Public Works Locker Room Addition - - - - 150,000 150,000 425 7500 XXXXX Scoreboard at Olivedale Park - - - - 30,000 30,000 425 7500 XXXXX Feline Kennels at Animal Shelter - - - - 60,000 60,000 Total General Capital Projects 1,334,330 1,356,330 (147,490) 1,208,840 - 240,000 1,448,840 426 8801 Street & Alley Program 121,130 116,240 (2,410) 113,830 - - 113,830 426 7500 86001 Street & Alley Program Rehab 2020-21 200,600 193,510 (172,680) 20,840 - - 20,840 426 7500 86002 Street & Alley Program Rehab 2021-22 205,000 205,000 (3,860) 201,140 - 50,000 251,140 426 7500 XXXXX Street & Alley Program Rehab 2022-23 - - - - 445,000 445,000 Total Street & Alley Program 526,730 514,750 (178,950) 335,800 - 495,000 830,810 640 9048 Reservoir 16 Structural Evaluation (San Antonio Park)15,230 15,230 - 15,230 - - 15,230 640 9049 Citywide Lateral Replacements - Annual 50,000 50,000 (4,400) 45,600 - 15,000 60,600 640 9050 Citywide Hydrant Replacements - Annual 50,000 50,000 - 50,000 - 25,000 75,000 640 9052 Waste to Drain Discharge Lines 50,000 50,000 - 50,000 - - 50,000 640 9065 Retrofit Designs for Phase 1 Recycled Water Users 3,840 3,840 - 3,840 (3,840) - - 640 9081 Reservoir 16 Repairs 1,075,000 945,500 - 945,500 (945,500) - - 640 9082 Onsite Disinfection Generation (Plant 6 on 15th Street)200,460 200,460 - 200,460 - - 200,460 640 9084 Plant 3 MCC Upgrades (22nd Street)125,000 125,000 - 125,000 - 100,000 225,000

Page 17 of 214 ends

CAPITAL IMPROVEMENT PROGRAM
FY 2022-23
2022/2023
Proposed
CIP
Budget
2021/2022
Projected
Expenses
Projected
Balance
6/30/2022
Return to Fund
Balance
2022/2023
New
Approp.

Fund Proj.

No.

Proj.

ID
Project Description 2021/2022
Adopted
CIP
Budget
2021/2022
Amended
CIP
Budget
640 9087 PRV Stations 852,390 850,360 - 850,360 - 150,000 1,000,360 640 9122 13th Street Water Main Repl. (Euclid to Campus)893,500 893,500 (758,710) 134,800 - - 134,800 640 9124 Arrow Highway Water Main Repl.
(Mountain to San Antonio)
392,080 389,070 (3,260) 385,810 - 65,000 450,810 640 9127 Ground Water Nitrate Treatment - Study & Design 300,000 300,000 - 300,000 - - 300,000 640 9128 Reservoir Replacement at 17th Street 1,154,020 1,154,020 (27,020) 1,127,000 - - 1,127,000 640 9132 Water Interconnect with CVWD System 50,000 50,000 - 50,000 - - 50,000 640 9133 Water Conservation Landscape Modification Project 120,000 120,000 - 120,000 (120,000) - - 640 9134 Reservoir 15 Enhancements 26,060 26,060 - 26,060 - 75,000 101,060 640 9135 Plant 6 Motor Control Center (15th Street)253,400 253,400 (160,170) 93,230 - - 93,230 640 9136 Plant 3 Booster 3 Install Pump and Motor (22nd St.)80,000 80,000 - 80,000 - 45,000 125,000 640 9137 Generator at Plant 2 (24th Street)258,590 258,590 (3,990) 254,600 - - 254,600 640 9138 Generator at Plant 6 (15th Street)787,890 787,890 (4,590) 783,300 - - 783,300 640 9140 17th Street Water Main (Laurel to Euclid) & Service Replacements (San Antonio to Euclid)
446,550 446,550 (13,630) 432,930 - 500,000 932,930 640 9141 19th Street Water Main (Mountain to San Antonio) & Service Replacements (Mountain to Euclid)
800,000 800,000 - 800,000 - 200,000 1,000,000 640 9142 Arrow Highway Water Main Repl.
(Benson to Mountain)
393,320 388,990 (8,700) 380,290 - - 380,290 640 9143 Mulberry Avenue Water Main Repl.
(Foothill Blvd. to Pine Street ~ 920')
440,000 440,000 (3,680) 436,330 - - 436,330 640 9144 Huntington Drive Water Main Repl.
(West End to Benson Avenue)
46,070 46,070 - 46,070 - 750,000 796,070 640 9145 Alpine Street Water Main Repl.
(West End to Palm Avenue)
490,360 478,640 (5,360) 473,290 - 50,000 523,290 640 9146 Vernon Drive Water Main Repl.
(West End to Palm Avenue)
300,710 288,990 (5,340) 283,660 - 15,000 298,660 640 9147 Palm Avenue Water Main Repl.
(9th Street to Arrow Hwy.)
780,780 769,040 (5,990) 763,050 - - 763,050 640 9148 New Well Chino Basin (drilling only)1,187,270 1,187,270 - 1,187,270 - - 1,187,270 640 9149 Storm Water Trash Capture Devices (In Catch Basins)599,390 599,390 - 599,390 - - 599,390 640 9152 Grove Avenue Water Main Repl.
(Foothill Blvd. to 15th Street)
991,620 991,300 - 991,300 - 515,000 1,506,300 640 7500 91001 14th Street Water Main Repl.
(Alta Ave. to Grove Ave.)
469,290 469,290 - 469,290 - - 469,290 640 7500 91002 Alley Water Main Replacement 2020-21 275,000 275,000 - 275,000 - - 275,000 640 7500 91003 Campus Avenue Water Main Replacement,
9th to Washington & Arrow to Foothill
1,400,000 1,400,000 - 1,400,000 - - 1,400,000 640 7500 91004 Plant 4 Chlorine Generation, CMU Secured Housing, and MCC Upgrades (401 E. 19th St.)
50,000 179,500 (49,600) 129,900 - - 129,900 640 7500 91005 Water Master Plan 275,000 275,000 - 275,000 - 25,000 300,000 640 7500 91006 Foothill Blvd. Water Main Repl.
(Mountain to San Antonio)
750,000 750,000 - 750,000 - 275,000 1,025,000 640 7500 91007 9th Street Water Main Repl.
(Benson to Mountain)
500,000 500,000 - 500,000 (500,000) - - 640 7500 XXXXX Foothill Blvd. Water Main Repl.
(San Antonio to Euclid)
- - - - 1,000,000 1,000,000 640 7500 XXXXX 11th Street Recycled Water Main
(Monte Vista Ave. to 11th St)
- - - - 175,000 175,000 640 7500 XXXXX 15th Street Recycled Water Main
(Benson Ave to 2nd Ave)
- - - - 175,000 175,000 640 7500 XXXXX Water Rate Study - - - - 150,000 150,000 Total Water Utility 16,932,820 16,887,950 (1,054,440) 15,833,560 (1,569,340) 4,305,000 18,569,220 641 9501 HHW Canopy Improvements 55,000 - (500) (500) - 500 - 641 9502 Downtown Trash Enclosures 89,840 89,840 (330) 89,510 - 30,000 119,510 Total Solid Waste 144,840 89,840 (830) 89,010 - 30,500 119,510 645 9301 Upland Landfill Post-Closure Plan 100,000 100,000 (1,820) 98,180 - - 98,180 645 9324 Landfill Flare Modifications 400,000 396,350 (21,890) 374,460 - - 374,460 645 9330 Richland Street Trunk Main Repair 75,000 75,000 - 75,000 - - 75,000 645 7500 94001 Citywide Sewer Rehabilitation 2020/2021
(Hydraulic Deficiencies, Root Intrusion, Structural Manhole Replacements).
413,200 413,200 (138,500) 274,700 - - 274,700 645 7500 94002 Manhole Adjustments to Grade for City/County Shared Roadway Project
100,000 100,000 - 100,000 - 50,000 150,000 645 7500 94003 Sewer Master Plan 275,000 275,000 - 275,000 - 25,000 300,000 645 7500 94004 Sewer System Management Plan (SSMP)200,000 200,000 - 200,000 - - 200,000 645 7500 94005 Citywide Sewer Rehabilitation 2021/2022
(Hydraulic Deficiencies, Root Intrusion, Structural Manhole Replacements).
400,000 400,000 - 400,000 - - 400,000

Page 18 of 214 ends

CAPITAL IMPROVEMENT PROGRAM
FY 2022-23
2022/2023
Proposed
CIP
Budget
2021/2022
Projected
Expenses
Projected
Balance
6/30/2022
Return to Fund
Balance
2022/2023
New
Approp.

Fund Proj.

No.

Proj.

ID
Project Description 2021/2022
Adopted
CIP
Budget
2021/2022
Amended
CIP
Budget
645 7500 XXXXX Citywide Sewer Rehabilitation 2022/2023
(Hydraulic Deficiencies, Root Intrusion, Structural Manhole Replacements).
- - - - 500,000 500,000
645 7500 XXXXX Sewer Rate Study - - - - 150,000 150,000 Total Sewer Utility 1,963,200 1,959,550 (162,210) 1,797,340 - 725,000 2,522,340 204 8,344,940 8,213,480 (1,015,810) 7,197,670 (859,380) 2,291,120 8,629,410 205 6,266,210 6,254,580 (1,047,800) 5,206,770 (229,810) 2,790,000 7,766,960 206 1,328,320 1,328,100 (5,130) 1,322,970 - 3,220,000 4,542,970 209 97,790 95,890 (87,080) 8,810 (8,810) - - 210 138,830 138,830 (8,280) 130,550 - - 130,550 229 - 2,423,000 (91,640) 2,331,360 - 1,724,000 4,055,360 420 555,000 555,000 - 555,000 - - 555,000 421 599,500 579,130 (13,480) 565,650 (25,600) 750,000 1,290,050 422 3,692,200 3,600,900 (7,240) 3,593,640 (62,540) - 3,531,100 423 1,902,650 1,407,610 (360,030) 1,047,580 (15,060) 300,000 1,332,520 425 1,334,330 1,356,330 (147,490) 1,208,840 - 240,000 1,448,840 426 526,730 514,750 (178,950) 335,800 - 495,000 830,810 640 16,932,820 16,887,950 (1,054,440) 15,833,560 (1,569,340) 4,305,000 18,569,220 641 144,840 89,840 (830) 89,010 - 30,500 119,510 645 1,963,200 1,959,550 (162,210) 1,797,340 - 725,000 2,522,340 TOTALS:43,827,360 45,404,940 (4,180,410) 41,224,550 (2,770,540) 16,870,620 55,324,640 A Estimate
A-1 Res. 2 Evaluation, Air Gaps, Roof Vents, In-Tank Mixer System (Mountain Lane s/o San Antonio Dam)
$400,000
A-2 Res. 3 & 7 Evaluation, Air Gaps, Roof Vents (1090 W. 22nd Street)
$450,000
A-3 Res. 4 Evaluation, New Roof and Hatches (159 N. 6th Avenue)
$275,000
A-4 Res. 9 Seismic Evaluation (467 S. Campus Avenue)$100,000 A-5 Res. 10 Evaluation, Air Gaps, Roof Vents, In-Tank Mixer System (1335 N. Benson Ave.)
$400,000
A-6 Res. 12 & 12A Evaluation, Air Gaps, Roof Vents (580 E. 15th Street)
$475,000
A-7 Res. 13 & 13A Evaluation, Air Gaps, Roof Vents (401 E. 19th Street)
$475,000
A-8 Res. 14 Evaluation, Air Gaps, Roof Vents (1505 E. 16th St.)$400,000 A-9 Res. 16 Evaluation, Structural Repairs, Air Gaps, Roof Vents
(1285 W. 24th Street)
$3,500,000
B
B-1 Chino Basin Water Treatment Plant (1258 W. 9th St.)$2,925,000 B-2 Plant 4 CMU Building for Ex. Chlorine Gneration, Pump to waste discharge Pipe (300 LF), New Chain Link Fence &
Gates, Equipment, and Site clean-up (401 E. 19th Street) $700,000
B-3 Plant 5 Vehicular Gates Replacement, SCADA Antena
Replacement, and Equipment (1505 E. 16th Street)
$200,000
B-4 Plant 6 Chlorine Generation, CMU Buildings, Drainage Pipe and Undersidewalk Box Culvert at South End, Plug Valve
for Pump Station By-pass, New Chain Link Fence with 1"
mesh, and Equipment (580 E. 15th Street)
$600,000
B-5 Plant 10 New CMU Building with Removable Roof, Chain Link Fencing with 1" mesh, Waste to Drain Pipe to Benson Avenue, Well Rehab, and Equipment (250 N. Benson
Avenue)
$550,000
B-6 Plant 11 New Roof, Security Doors & Windows, Chain Link Fencing with 1" mesh, and Equipment (149 N. Benson
Avenue)
$400,000
B-7 Plant 13 Chlorine Generation, Install AC in Ex. Building, Replace severed sewer line, and Equipment (159 N. 6th
Avenue)
$450,000

RESERVOIR PROJECTS

TREATMENT PLANT PROJECTS

GENERAL CAPITAL PROJECTS

STREET & ALLEY PROGRAM

WATER UTILITY

SOLID WASTE

SEWER UTILITY

WATER BOND PROJECTS

STREET & TRAFFIC FACILITY DEVELOPMENT

TOTALS BY FUND

GAS TAX

MEASURE I
ROAD MAINT. REHAB ACCOUNT (RMRA)
CDBG
PBIA

AMERICAN RESCUE PLAN ACT (ARPA)

DEVELOPMENT IMPROVEMENTS

PARK ACQUISITION & DEVELOPMENT

STORM DRAIN DEVELOPMENT

Page 19 of 214 ends

CAPITAL IMPROVEMENT PROGRAM
FY 2022-23
B-8 Plant 14 Evaluate connection with City of Ontario, New Roof for Building, New Chain Link Fence & Gate, and Equipment (467 S. Campus Avenue)
$200,000
C
C-1 9th Street, from Benson Ave. to Mountain Ave.$500,000 C-2 9th Street, from 8th Ave. to Grove Ave.$2,500,000
$15,500,000

PIPELINE PROJECTS

Page 20 of 214 ends

Fund No.Fund Name Transfers In Transfers Out
425 General Capital Projects 240,000
101 General Fund 240,000
To Fund Capital Improvement Projects.
645 Sewer Utility 265,000
641 Solid Waste Utility 265,000
To Transfer for Landfill Costs.

Total 505,000$ 505,000$
FISCAL YEAR 2022-23

SUMMARY OF TRANSFERS

Page 21 of 214 ends

Bargaining Salary Minimum Maximum 2019-20 2020-21 2021-22 2021-22 2022-23 2022-23 Unit Grade (Step 1)(Step 13)ACTUAL ACTUAL ADOPTED AMENDED CHANGE PROPOSED

GENERAL GOVERNMENT

ELECTED/APPOINTED
MAYOR ELEC ---1.00 1.00 1.00 1.00 0.00 1.00
COUNCIL ELEC ---4.00 4.00 4.00 4.00 0.00 4.00
TREASURER ELEC ---1.00 1.00 1.00 1.00 0.00 1.00

6.00 6.00 6.00 6.00 0.00 6.00

ADMINISTRATION
CITY MANAGER EXEC 96 $17,625 $23,704 1.00 1.00 1.00 1.00 0.00 1.00 ASSISTANT CITY MANAGER EXEC 83 $12,786 $17,195 1.00 1.00 1.00 1.00 0.00 1.00 EXECUTIVE ASSISTANT TO THE CITY MANAGER MMGT 45 $5,003 $6,728 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR ADMINISTRATIVE ASSISTANT GENL 33 $3,720 $5,003 0.00 0.00 0.00 1.00 0.00 1.00

3.00 3.00 3.00 4.00 0.00 4.00

CITY CLERK
CITY CLERK MMGT 60 $7,246 $9,744 0.00 0.00 0.00 1.00 0.00 1.00 DEPUTY CITY CLERK GENL 35 $3,908 $5,256 0.00 0.00 0.00 1.00 0.00 1.00 SENIOR ADMINISTRATIVE ASSISTANT GENL 33 $3,720 $5,003 0.00 0.00 0.00 1.00 0.00 1.00

0.00 0.00 0.00 3.00 0.00 3.00
GENERAL GOVERNMENT-TOTAL 9.00 9.00 9.00 13.00 0.00 13.00

ADMINISTRATIVE SERVICES

CITY CLERK
CITY CLERK MMGT 60 $7,246 $9,744 1.00 1.00 1.00 0.00 0.00 0.00 DEPUTY CITY CLERK GENL 35 $3,908 $5,256 0.00 1.00 1.00 0.00 0.00 0.00 SENIOR ADMINISTRATIVE ASSISTANT GENL 33 $3,720 $5,003 1.00 0.00 1.00 0.00 0.00 0.00

2.00 2.00 3.00 0.00 0.00 0.00

FINANCE
FINANCE OFFICER MMGT 62 $7,612 $10,238 1.00 1.00 1.00 1.00 0.00 1.00 ACCOUNTING SUPERVISOR MMGT 57 $6,728 $9,049 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR ACCOUNTANT GENL 46 $5,128 $6,896 1.00 2.00 2.00 2.00 0.00 2.00 ACCOUNTANT GENL ---1.00 0.00 0.00 0.00 0.00 0.00
BUDGET COORDINATOR GENL 43 $4,762 $6,404 0.00 0.00 0.00 0.00 1.00 1.00 SENIOR ACCOUNTING TECHNICIAN GENL 40 $4,422 $5,947 1.00 1.00 1.00 1.00 (1.00)0.00 PAYROLL TECHNICIAN GENL 39 $4,314 $5,802 1.00 1.00 1.00 1.00 0.00 1.00 ACCOUNTING TECHNICIAN GENL 35 $3,908 $5,256 3.00 3.00 3.00 3.00 0.00 3.00 UTILITY BILLING & CUSTOMER SERVICE SUPERVISOR MMGT 50 $5,660 $7,612 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR CUSTOMER SERVICE SPECIALIST GENL 40 $4,422 $5,947 1.00 1.00 1.00 2.00 0.00 2.00 †(1) UTILITY BILLING & BUSINESS LICENSE INSPECTOR GENL 38 $4,209 $5,660 1.00 1.00 1.00 1.00 0.00 1.00 CUSTOMER SERVICE SPECIALIST II GENL 29 $3,370 $4,532 2.00 3.00 3.00 3.00 0.00 3.00 CUSTOMER SERVICE SPECIALIST I GENL 25 $3,053 $4,106 3.00 2.00 2.00 2.00 0.00 2.00

17.00 17.00 17.00 18.00 0.00 18.00

INFORMATION TECHNOLOGY
INFORMATION TECHNOLOGY MANAGER MMGT 62 $7,612 $10,238 1.00 1.00 1.00 1.00 0.00 1.00 INFORMATION TECHNOLOGY TECHNICIAN GENL 39 $4,314 $5,802 2.00 2.00 2.00 2.00 1.00 3.00

3.00 3.00 3.00 3.00 1.00 4.00
2022-23 SCHEDULE OF POSITIONS

Page 22 of 214 ends

HUMAN RESOURCES
HUMAN RESOURCES/RISK MANAGER MMGT 62 $7,612 $10,238 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR HUMAN RESOURCES ANALYST MMGT 53 $6,095 $8,198 1.00 1.00 1.00 1.00 0.00 1.00 HUMAN RESOURCES ANALYST MMGT 44 $4,881 $6,564 1.00 1.00 1.00 1.00 0.00 1.00 ADMINISTRATIVE ASSISTANT GENL 26 $3,129 $4,209 0.00 1.00 1.00 1.00 0.00 1.00

3.00 4.00 4.00 4.00 0.00 4.00

RECREATION AND COMMUNITY SERVICES
RECREATION MANAGER MMGT 55 $6,404 $8,613 1.00 1.00 1.00 1.00 0.00 1.00 RECREATION SUPERVISOR MMGT 42 $4,646 $6,248 2.00 2.00 2.00 2.00 0.00 2.00 RECREATION COORDINATOR GENL 36 $4,006 $5,387 0.00 1.00 1.00 1.00 1.00 2.00 SENIOR ADMINISTRATIVE ASSISTANT GENL 33 $3,720 $5,003 2.00 1.00 1.00 1.00 0.00 1.00

5.00 5.00 5.00 5.00 1.00 6.00
ADMINISTRATIVE SERVICES-TOTAL 30.00 31.00 32.00 30.00 2.00 32.00

DEVELOPMENT SERVICES

BUILDING AND PLANNING
DEVELOPMENT SERVICES DIRECTOR EXEC 3243 $10,803 $14,529 1.00 1.00 1.00 1.00 0.00 1.00 DEVELOPMENT SERVICES MANAGER MMGT 62 $7,612 $10,238 1.00 1.00 1.00 1.00 0.00 1.00 ECONOMIC DEVELOPMENT COORDINATOR MMGT 46 $5,128 $6,896 1.00 1.00 1.00 1.00 0.00 1.00 DEVELOPMENT SERVICES SPECIALIST (LIMITED TERM)^GENL 36 $4,006 $5,387 0.00 0.00 0.00 1.00 0.00 1.00 ADMINISTRATIVE ANALYST MMGT 44 $4,881 $6,564 0.00 1.00 1.00 1.00 0.00 1.00 ACCOUNTING TECHNICIAN GENL 35 $3,908 $5,256 0.00 1.00 1.00 1.00 0.00 1.00 SENIOR ADMINISTRATIVE ASSISTANT GENL ---2.00 0.00 0.00 0.00 0.00 0.00 PLANNING MANAGER MMGT 63 $7,803 $10,494 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR PLANNER MMGT 54 $6,248 $8,403 0.00 0.00 0.00 1.00 0.00 1.00 ASSOCIATE PLANNER MMGT 46 $5,128 $6,896 1.00 1.00 1.00 1.00 0.00 1.00 ASSISTANT PLANNER MMGT 42 $4,646 $6,248 1.00 1.00 1.00 0.00 0.00 0.00 BUILDING OFFICIAL (FY 2021-22 FREEZE POSITION)MMGT 63 $7,803 $10,494 1.00 1.00 1.00 1.00 0.00 1.00 *(1) PLANS EXAMINER (FY 2021-22 FREEZE POSITION)GENL 47 $5,256 $7,069 1.00 1.00 1.00 1.00 0.00 1.00 *(1) SENIOR BUILDING INSPECTOR GENL 45 $5,003 $6,728 0.00 0.00 1.00 1.00 0.00 1.00 BUILDING INSPECTOR II GENL 41 $4,532 $6,095 2.00 3.00 2.00 1.00 0.00 1.00 BUILDING INSPECTOR I GENL 39 $4,314 $5,802 1.00 0.00 0.00 1.00 0.00 1.00 SENIOR DEVELOPMENT SERVICES TECHNICIAN GENL 33 $3,720 $5,003 1.00 1.00 1.00 1.00 0.00 1.00 DEVELOPMENT SERVICES TECHNICIAN GENL 30 $3,454 $4,646 0.00 0.00 0.00 1.00 0.00 1.00

14.00 14.00 14.00 16.00 0.00 16.00

HOUSING / SUCCESSOR AGENCY
HOUSING COORDINATOR MMGT 43 $4,762 $6,404 1.00 1.00 1.00 1.00 0.00 1.00

1.00 1.00 1.00 1.00 0.00 1.00
DEVELOPMENT SERVICES-TOTAL 15.00 15.00 15.00 17.00 0.00 17.00

Page 23 of 214 ends

Bargaining Salary Minimum Maximum 2019-20 2020-21 2021-22 2021-22 2022-23 2022-23 Unit Grade (Step 1)(Step 13)ACTUAL ACTUAL ADOPTED AMENDED CHANGE PROPOSED 2022-23 SCHEDULE OF POSITIONS

PUBLIC WORKS

PUBLIC WORKS - ADMINISTRATION
PUBLIC WORKS DIRECTOR/CITY ENGINEER EXEC 3247 $11,243 $15,118 1.00 1.00 1.00 1.00 0.00 1.00 ACCOUNTING TECHNICIAN GENL 35 $3,908 $5,256 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR ADMINISTRATIVE ASSISTANT GENL 33 $3,720 $5,003 1.00 1.00 1.00 1.00 0.00 1.00 ADMINISTRATIVE ASSISTANT GENL 26 $3,129 $4,209 0.00 1.00 1.00 1.00 0.00 1.00

3.00 4.00 4.00 4.00 0.00 4.00

PUBLIC WORKS - OPERATIONS
OPERATIONS MANAGER MMGT 67 $8,613 $11,583 1.00 1.00 1.00 1.00 0.00 1.00 MAINTENANCE SUPERVISOR MMGT 45 $5,003 $6,728 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR MAINTENANCE WORKER GENL 34 $3,813 $5,128 3.00 3.00 3.00 3.00 0.00 3.00 MAINTENANCE WORKER GENL 28 $3,288 $4,422 10.00 10.00 10.00 10.00 1.00 11.00 FACILITIES COORDINATOR GENL 40 $4,422 $5,947 1.00 1.00 1.00 1.00 0.00 1.00 FACILITIES SPECIALIST GENL 36 $4,006 $5,387 1.50 1.50 2.00 2.00 0.00 2.00 CUSTODIAN GENL 22 $2,835 $3,813 3.00 3.00 3.00 3.00 0.00 3.00 SENIOR EQUIPMENT MECHANIC GENL 38 $4,209 $5,660 1.00 1.00 1.00 1.00 0.00 1.00 EQUIPMENT MECHANIC GENL 34 $3,813 $5,128 2.00 2.00 2.00 2.00 0.00 2.00 INVENTORY SPECIALIST GENL 26 $3,129 $4,209 1.00 1.00 1.00 1.00 0.00 1.00

24.50 24.50 25.00 25.00 1.00 26.00

PUBLIC WORKS - CAPITAL PROJECTS
ENGINEERING MANAGER MMGT 67 $8,613 $11,583 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR ENGINEER MMGT 60 $7,246 $9,744 1.00 1.00 1.00 1.00 0.00 1.00 ASSOCIATE ENGINEER MMGT 54 $6,248 $8,403 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR PUBLIC WORKS INSPECTOR GENL 45 $5,003 $6,728 2.00 2.00 2.00 2.00 0.00 2.00 CROSS CONNECTION CONTROL TECHNICIAN GENL 45 $5,003 $6,728 1.00 1.00 1.00 1.00 0.00 1.00

6.00 6.00 6.00 6.00 0.00 6.00

TRAFFIC ENGINEERING
PRINCIPAL ENGINEER MMGT 63 $7,803 $10,494 1.00 1.00 1.00 1.00 0.00 1.00 ASSISTANT ENGINEER MMGT 48 $5,387 $7,246 1.00 1.00 2.00 2.00 0.00 2.00 ENGINEERING TECHNICIAN GENL 30 $3,454 $4,646 1.00 1.00 1.00 1.00 0.00 1.00

3.00 3.00 4.00 4.00 0.00 4.00

PUBLIC WORKS - SEWER
ENVIRONMENTAL QUALITY ADMINISTRATOR MMGT 63 $7,803 $10,494 1.00 1.00 1.00 1.00 0.00 1.00 ASSOCIATE ENGINEER MMGT 54 $6,248 $8,403 1.00 1.00 1.00 1.00 0.00 1.00 ASSISTANT ENGINEER MMGT 48 $5,387 $7,246 1.00 1.00 2.00 2.00 0.00 2.00 SENIOR ENVIRONMENTAL CONTROL TECHNICIAN GENL 38 $4,209 $5,662 1.00 1.00 1.00 1.00 0.00 1.00

4.00 4.00 5.00 5.00 0.00 5.00

PUBLIC WORKS - SOLID WASTE
MANAGEMENT ANALYST MMGT 44 $4,881 $6,564 1.00 1.00 1.00 1.00 0.00 1.00

1.00 1.00 1.00 1.00 0.00 1.00

PUBLIC WORKS - WATER
UTILITIES MANAGER MMGT 67 $8,613 $11,583 1.00 1.00 1.00 1.00 0.00 1.00 CHIEF WATER TREATMENT OPERATOR MMGT 51 $5,802 $7,803 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR WATER TREATMENT OPERATOR GENL 43 $4,762 $6,404 2.00 2.00 2.00 2.00 0.00 2.00 WATER TREATMENT OPERATOR GENL 37 $4,106 $5,522 2.00 2.00 2.00 2.00 1.00 3.00 UTILITY SYSTEM SUPERVISOR MMGT 50 $5,660 $7,612 1.00 1.00 1.00 1.00 0.00 1.00

Page 24 of 214 ends

Bargaining Salary Minimum Maximum 2019-20 2020-21 2021-22 2021-22 2022-23 2022-23 Unit Grade (Step 1)(Step 13)ACTUAL ACTUAL ADOPTED AMENDED CHANGE PROPOSED 2022-23 SCHEDULE OF POSITIONS
(Public Works Continued)
SENIOR UTILITY SYSTEM WORKER GENL 43 $4,762 $6,404 2.00 2.00 2.00 2.00 0.00 2.00 UTILITY SYSTEM WORKER GENL 34 $3,813 $5,128 10.00 10.00 11.00 11.00 0.00 11.00 SENIOR UTILITY SYSTEM WORKER-SEWER GENL 43 $4,762 $6,404 1.00 1.00 1.00 1.00 0.00 1.00 UTILITY SYSTEM WORKER-SEWER GENL 34 $3,813 $5,128 6.00 6.00 6.00 6.00 0.00 6.00 SENIOR WATER METER TECHNICIAN GENL 34 $3,813 $5,128 1.00 1.00 1.00 1.00 0.00 1.00 WATER METER TECHNICIAN GENL 30 $3,454 $4,646 2.00 2.00 2.00 2.00 1.00 3.00 MANAGEMENT ANALYST MMGT 44 $4,881 $6,564 1.00 1.00 1.00 1.00 0.00 1.00 ASSOCIATE ENGINEER MMGT 54 $6,248 $8,403 0.00 0.00 0.00 0.00 1.00 1.00 GIS/CAD TECHNICIAN GENL 39 $4,314 $5,802 1.00 1.00 1.00 1.00 0.00 1.00 CUSTOMER SERVICE SPECIALIST I GENL 25 $3,053 $4,106 0.00 0.00 1.00 1.00 0.00 1.00

31.00 31.00 33.00 33.00 3.00 36.00
PUBLIC WORKS-TOTAL 72.50 73.50 78.00 78.00 4.00 82.00
POLICE

POLICE- SWORN
CHIEF OF POLICE EXEC 94 $16,776 $22,562 1.00 1.00 1.00 1.00 0.00 1.00 POLICE CAPTAIN PDCP 6461 $11,796 $14,338 2.00 2.00 2.00 2.00 0.00 2.00 POLICE LIEUTENANT PD-MMGT 5421 $10,002 $12,157 4.00 4.00 3.00 3.00 0.00 3.00 POLICE SERGEANT PD-MMGT 5387 $8,285 $10,071 9.00 9.00 9.00 9.00 0.00 9.00 POLICE DETECTIVE PDSW 6363 $6,794 $8,259 9.00 9.00 9.00 9.00 0.00 9.00 POLICE CORPORAL PDSW 6363 $6,794 $8,259 0.00 0.00 5.00 5.00 0.00 5.00 POLICE OFFICER PDSW 6339 $6,044 $7,347 50.00 50.00 49.00 49.00 0.00 49.00

75.00 75.00 78.00 78.00 0.00 78.00

POLICE- NON-SWORN
CRIME ANALYST MMGT 45 $5,003 $6,728 1.00 1.00 1.00 1.00 0.00 1.00 EXECUTIVE ASSISTANT TO THE CHIEF OF POLICE MMGT 41 $4,532 $6,095 1.00 1.00 1.00 0.00 0.00 0.00 FORENSIC SPECIALIST GENL 38 $4,209 $5,660 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR ACCOUNTING TECHNICIAN GENL 40 $4,422 $5,947 0.00 0.00 1.00 1.00 0.00 1.00 ACCOUNTING TECHNICIAN GENL 35 $3,908 $5,256 1.00 1.00 0.00 0.00 0.00 0.00 SENIOR ADMINISTRATIVE ASSISTANT GENL 33 $3,720 $5,003 0.00 0.00 0.00 1.00 0.00 1.00 ADMINISTRATIVE ASSISTANT GENL 26 $3,129 $4,209 1.00 1.00 1.00 0.00 0.00 0.00 POLICE DISPATCH SUPERVISOR MMGT 44 $4,881 $6,564 1.00 1.00 1.00 1.00 0.00 1.00 LEAD DISPATCHER (FY 2021-22 FREEZE ONE POSITION)GENL 37 $4,106 $5,522 2.00 2.00 2.00 2.00 0.00 2.00 *(1) POLICE DISPATCHER II GENL 35 $3,908 $5,256 10.00 10.00 10.00 10.00 0.00 10.00 POLICE RECORDS SUPERVISOR MMGT 34 $3,813 $5,128 1.00 1.00 1.00 1.00 0.00 1.00 SENIOR RECORDS SPECIALIST GENL 29 $3,370 $4,532 0.00 0.00 0.00 1.00 0.00 1.00 POLICE RECORDS SPECIALIST II GENL 25 $3,053 $4,106 5.00 5.00 5.00 5.00 0.00 5.00 HOMELESS SERVICES COORDINATOR GENL 41 $4,532 $6,095 0.00 0.00 1.00 1.00 0.00 1.00 HOMELESS COORDINATOR GENL 30 $3,454 $4,646 0.00 1.00 0.00 0.00 0.00 0.00 TRAFFIC AIDE GENL 28 $3,288 $4,422 0.00 0.00 0.00 1.00 0.00 1.00 POLICE SERVICES TECHNICIAN GENL 27 $3,208 $3,208 6.00 6.00 6.00 7.00 0.00 7.00

30.00 31.00 31.00 33.00 0.00 33.00

Page 25 of 214 ends

ANIMAL SERVICES
ANIMAL SERVICES SUPERVISOR MMGT 38 $4,209 $5,660 1.00 1.00 1.00 1.00 0.00 1.00 ANIMAL SERVICES OFFICER (FY 21-22 FREEZE ONE POSITION)GENL 32 $3,629 $4,881 3.00 3.00 3.00 3.00 0.00 3.00 *(1)

4.00 4.00 4.00 4.00 0.00 4.00

CODE ENFORCEMENT
CODE ENFORCEMENT OFFICER GENL 38 $4,209 $5,660 4.00 4.00 4.00 4.00 0.00 4.00

4.00 4.00 4.00 4.00 0.00 4.00
POLICE-TOTAL 113.00 114.00 117.00 119.00 0.00 119.00
GRAND TOTAL 239.50 242.50 251.00 257.00 6.00 263.00
^ Position funded through 12/31/2024.
† Number of limited term positions. Position funded through 12/31/2023. * Number of positions to remain unfilled for FY 2022-23.

Page 26 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 1
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
1010000 GENERAL FUND
1010000 4001 CUR SEC TX -16,175,364.47 -16,613,000.00 -16,613,000.00 -12,013,769.27 -16,613,000.00 -16,983,680.00 2.2% 1010000 4002 CUR UNS TX -264,925.79 -260,000.00 -260,000.00 -269,133.58 -270,000.00 -275,400.00 5.9% 1010000 4003 AIRCRFT TX -41,610.54 -39,660.00 -39,660.00 -35,155.14 -39,660.00 -33,770.00 -14.9% 1010000 4004 PY COLLCTN -348,944.32 -241,980.00 -241,980.00 -209,404.47 -295,000.00 -295,000.00 21.9% 1010000 4005 CURR SUPPL -94,696.46 -70,000.00 -70,000.00 -121,977.76 -85,000.00 -85,000.00 21.4% 1010000 4006 HOM TX RLF -64,889.42 -69,400.00 -69,400.00 -30,815.84 -64,800.00 -64,800.00 -6.6% 1010000 4009 WEED ABATE -4,496.25 .00 .00 -559.19 .00 .00 .0% 1010000 4011 RPTTF-RESI -1,303,183.99 -1,100,000.00 -1,100,000.00 -934,401.07 -1,100,000.00 -1,300,000.00 18.2% 1010000 4012 TRAILER -72,971.00 -59,370.00 -59,370.00 -80,043.02 -65,000.00 -65,000.00 9.5% 1010000 4101 SALES TAX -16,876,712.15 -14,789,060.00 -18,153,630.00 -12,160,113.61 -18,153,630.00 -18,404,120.00 1.4% 1010000 4102 BUS LIC TX -1,119,427.31 -1,080,000.00 -1,080,000.00 -829,755.83 -1,080,000.00 -1,100,000.00 1.9% 1010000 4103 ROCK EX TX -264,964.72 -260,000.00 -260,000.00 -191,066.31 -264,000.00 -264,000.00 1.5% 1010000 4104 TRNS OC TX -195,618.86 -154,000.00 -154,000.00 -133,194.55 -194,000.00 -164,000.00 6.5% 1010000 4105 TRANSFR TX -447,618.99 -350,000.00 -350,000.00 -408,410.79 -400,000.00 -400,000.00 14.3% 1010000 4110 DSBLTY FEE -21,935.60 -10,000.00 -10,000.00 -16,087.23 -18,500.00 -18,500.00 85.0% 1010000 4121 FRANCHS TX -1,284,525.17 -1,252,060.00 -1,252,060.00 -1,014,257.20 -1,265,000.00 -1,284,520.00 2.6% 1010000 4222 YARD PERMT -3,096.00 -3,500.00 -3,500.00 -3,300.00 -3,500.00 -3,500.00 .0% 1010000 4223 ALARM PERM -77.00 .00 .00 .00 .00 .00 .0% 1010000 4402 ST MAN CST -50.00 .00 .00 .00 .00 .00 .0% 1010000 4403 PROPTX-MV -57,805.11 -57,800.00 -90,700.00 -90,702.33 -90,700.00 -90,000.00 -.8% 1010000 4604 CFD ADMIN -37,952.00 -37,920.00 -37,920.00 -34,760.00 .00 .00 -100.0% 1010000 4617 EC DEV FEE .00 .00 -150,000.00 .00 .00 .00 -100.0% 1010000 4680 UD-OPEB -133,730.00 .00 .00 .00 .00 .00 .0% 1010000 4707 MU-BL FINE -154,934.75 -95,000.00 -95,000.00 -59,053.35 -110,000.00 -110,000.00 15.8% 1010000 4709 MU- LIB FN .00 .00 .00 20.00 .00 .00 .0% 1010000 4800 UN INT INC .00 .00 .00 -148,096.39 .00 .00 .0% 1010000 4801 INT INCOME -905,416.99 -60,000.00 -60,000.00 -54,899.43 -110,000.00 -110,000.00 83.3% 1010000 4814 STOP SALES -76.50 .00 .00 -97.50 .00 .00 .0% 1010000 4872 UNRL GN/LS 106,950.79 .00 .00 13,828.02 .00 .00 .0% 1010000 4901 SALE OF CA -31,218.00 .00 .00 .00 .00 .00 .0% 1010000 4908 MISC REIMB -2,614.14 .00 .00 .00 .00 .00 .0% 1010000 4909 OTHER REV -18,078.78 .00 .00 -6,764.36 .00 .00 .0% 1010000 4910 WTR-ADM SV -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% 1010000 4911 SW-ADM SV -481,775.00 -481,780.00 -546,540.00 -481,780.00 -559,710.00 -559,710.00 2.4% 1010000 4912 SWR-ADM SV -471,998.00 -472,000.00 -559,710.00 -472,000.00 -546,540.00 -546,540.00 -2.4% 1010000 4913 CASH-OV/SH 8.00 .00 .00 200.85 .00 .00 .0% 1010000 4914 15% PBIA -10,039.07 -8,780.00 -8,780.00 -4,941.46 -8,780.00 -8,780.00 .0% 1010000 4919 ADMIN FEE -482,893.00 -482,890.00 -615,580.00 -482,900.00 -615,590.00 -615,590.00 .0% 1010000 4970 TRNSFR IN .00 -1,077,340.00 .00 .00 .00 .00 .0% 1010000 4970 16110 TRNSFR IN -351,591.25 .00 .00 .00 .00 .00 .0% 1010000 4970 16111 TRNSFR IN -805,941.78 .00 .00 .00 .00 .00 .0%

Page 27 of 214 ends

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

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

TOTAL GENERAL FUND -43,829,111.62 -40,530,440.00 -43,607,830.00 -31,678,290.81 -43,679,410.00 -44,508,910.00 2.1% ____________________________________________
1011301 ACCOUNTING SERVICES
1011301 4601 FINAN FEES -31,048.23 -28,000.00 -28,000.00 -18,203.30 -28,000.00 -28,000.00 .0% 1011301 4604 CFD ADMIN -20,000.00 .00 .00 .00 -37,920.00 -37,920.00 .0% 1011301 4909 OTHER REV -198.83 .00 .00 -226.75 .00 .00 .0% 1011301 4918 PY REVENUE .00 .00 .00 -285.85 .00 .00 .0%

TOTAL ACCOUNTING SERVICES -51,247.06 -28,000.00 -28,000.00 -18,715.90 -65,920.00 -65,920.00 135.4% ____________________________________________
1011504 NON-DEPARTMENTAL
1011504 4909 OTHER REV -1,155.33 .00 .00 .00 .00 .00 .0% 1011504 4917 RESTITUTIO .00 .00 .00 -55,000.00 .00 .00 .0%

TOTAL NON-DEPARTMENTAL -1,155.33 .00 .00 -55,000.00 .00 .00 .0% ____________________________________________
1011510 LIBRARY
1011510 4482 ST LITRACY -27,099.00 -27,000.00 -27,000.00 -27,706.00 -27,000.00 -28,000.00 3.7% 1011510 4665 COPY REVNU -600.25 -500.00 -500.00 -795.00 .00 -500.00 .0% 1011510 4709 MU- LIB FN -5,345.65 -3,750.00 -3,750.00 -5,594.00 -2,090.00 -2,500.00 -33.3%

TOTAL LIBRARY -33,044.90 -31,250.00 -31,250.00 -34,095.00 -29,090.00 -31,000.00 -.8% ____________________________________________
1011601 HUMAN RESOURCES
1011601 4665 COPY REVNU .00 .00 .00 -7.50 .00 .00 .0%

TOTAL HUMAN RESOURCES .00 .00 .00 -7.50 .00 .00 .0% ____________________________________________
1011603 CITY ATTORNEY
1011603 4908 MISC REIMB -83,953.52 .00 .00 -16,097.60 .00 .00 .0% 1011603 4908 50105 MISC REIMB -226,267.85 .00 .00 .00 .00 .00 .0%

TOTAL CITY ATTORNEY -310,221.37 .00 .00 -16,097.60 .00 .00 .0% ____________________________________________
1011701 CITY CLERK
1011701 4602 CC FEES -10,869.50 -2,500.00 -2,500.00 -2,067.13 -2,500.00 -2,500.00 .0%

TOTAL CITY CLERK -10,869.50 -2,500.00 -2,500.00 -2,067.13 -2,500.00 -2,500.00 .0% ____________________________________________
1012201 BUILDING AND SAFETY
1012201 4201 BLDG PERMT -904,989.38 -634,760.00 -582,670.00 -618,846.94 -582,670.00 -681,720.00 17.0%

Page 28 of 214 ends

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

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

TOTAL BUILDING AND SAFETY -2,751,999.79 -1,700,000.00 -1,800,000.00 -1,783,775.52 -1,800,000.00 -2,100,000.00 16.7% ____________________________________________
1012202 WEED ABATEMENT
1012202 4009 WEED ABATE .00 -75,000.00 -15,530.00 .00 .00 -75,000.00 382.9%

TOTAL WEED ABATEMENT .00 -75,000.00 -15,530.00 .00 .00 -75,000.00 382.9% ____________________________________________
1012203 ECONOMIC DEVELOPMENT
1012203 4617 EC DEV FEE -3,612.50 .00 .00 -135,041.04 .00 .00 .0% 1012203 4802 LEASE PROP -116,101.43 -118,950.00 -118,950.00 -99,275.20 -119,000.00 -122,250.00 2.8% 1012203 4802 50105 LEASE PROP -130,170.00 -134,080.00 -134,080.00 -100,311.00 -134,080.00 -138,105.00 3.0% 1012203 4802 50111 LEASE PROP -41,487.94 -42,770.00 -42,770.00 -32,039.41 -42,735.00 -43,950.00 2.8% 1012203 4802 50112 LEASE PROP -9,590.40 -9,590.00 -9,590.00 -7,192.80 -9,590.00 -9,760.00 1.8% 1012203 4802 50113 LEASE PROP -31,286.25 -32,780.00 -32,225.00 -26,761.21 -32,225.00 -33,190.00 3.0% 1012203 4802 50114 LEASE PROP -26,098.31 -26,900.00 -26,900.00 -22,343.48 -26,810.00 -27,520.00 2.3% 1012203 4802 50115 LEASE PROP -23,083.61 -23,440.00 -23,440.00 -19,951.66 -23,515.00 -23,545.00 .4% 1012203 4802 50116 LEASE PROP -181,315.60 -181,160.00 -181,575.00 -151,467.00 -181,575.00 -181,155.00 -.2% 1012203 4802 50117 LEASE PROP -35,342.31 -35,700.00 -35,700.00 -29,721.85 -35,700.00 -36,055.00 1.0% 1012203 4802 50118 LEASE PROP -15,000.00 -15,000.00 -15,000.00 -12,500.00 -15,000.00 -15,000.00 .0% 1012203 4802 50123 LEASE PROP -48,985.12 -65,410.00 -65,715.00 -52,854.68 -66,040.00 -53,205.00 -19.0% 1012203 4802 50129 LEASE PROP -27,122.13 -21,020.00 -21,280.00 -16,119.68 -21,280.00 -21,440.00 .8% 1012203 4802 50132 LEASE PROP -48,832.80 -49,550.00 -49,550.00 -38,240.20 -49,545.00 -50,785.00 2.5% 1012203 4802 50133 LEASE PROP -27,531.90 -28,360.00 -28,360.00 -23,549.86 -28,360.00 -29,210.00 3.0% 1012203 4802 50134 LEASE PROP -21,012.82 -21,860.00 -21,435.00 -17,849.22 -21,435.00 -21,860.00 2.0% 1012203 4908 MISC REIMB -519.50 -43,890.00 .00 .00 .00 -30,000.00 .0% 1012203 4909 OTHER REV -609.30 .00 -3,360.00 -3,362.95 -3,360.00 -3,360.00 .0%

TOTAL ECONOMIC DEVELOPMENT -787,701.92 -850,460.00 -809,930.00 -788,581.24 -810,250.00 -840,390.00 3.8% ____________________________________________
1012205 PLANNING
1012205 4218 DEV AGR FE .00 .00 .00 -50,000.00 .00 .00 .0%

Page 29 of 214 ends

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

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

TOTAL PLANNING -453,124.90 -520,000.00 -470,000.00 -339,668.45 -470,000.00 -395,000.00 -16.0% ____________________________________________
1013201 POLICE ADMINISTRATION
1013201 4216 BIKE LIC -45.00 -70.00 -70.00 -60.00 -100.00 -70.00 .0% 1013201 4224 GUN LICENS -2,203.00 -1,510.00 -1,510.00 -232.00 -460.00 -500.00 -66.9% 1013201 4603 DAMAG PROP -3,014.15 .00 .00 .00 .00 .00 .0% 1013201 4622 PD DPT FEE -147,327.76 -170,580.00 -138,880.00 -147,359.57 -138,880.00 -143,100.00 3.0% 1013201 4626 PD-30 VEH -182,940.00 -179,660.00 -266,600.00 -192,797.00 -266,600.00 -224,770.00 -15.7% 1013201 4905 DONATION -575.07 .00 .00 .00 .00 .00 .0% 1013201 4908 MISC REIMB -2,694.37 -10,000.00 -30.00 -9,601.18 -30.00 -10,000.00 .0% 1013201 4909 OTHER REV -223,138.24 -90,000.00 -98,940.00 -89,408.90 -121,200.00 -103,000.00 4.1% 1013201 4918 PY REVENUE .00 .00 .00 -5,999.95 .00 .00 .0%

TOTAL POLICE ADMINISTRATION -561,937.59 -451,820.00 -506,030.00 -445,458.60 -527,270.00 -481,440.00 -4.9% ____________________________________________
1013205 ANIMAL SERVICES
1013205 4217 ANML LIC -114,190.00 -114,000.00 -76,370.00 -81,660.53 -76,370.00 -76,000.00 -.5% 1013205 4624 ANML IMPND -8,791.00 -15,000.00 -8,500.00 -7,437.00 -8,500.00 -8,500.00 .0% 1013205 4629 SPAY NEUTR -640.00 -1,000.00 -1,000.00 -470.00 -540.00 -590.00 -41.0% 1013205 4630 ANML CNTRL -1,050.00 -1,200.00 -1,200.00 -1,455.00 -1,560.00 -1,300.00 8.3% 1013205 4705 MU-ANML FN -5,480.00 -5,200.00 -2,050.00 -2,646.75 -2,050.00 -2,500.00 22.0% 1013205 4915 DON - AS -293.00 -250.00 -150.00 -97.00 -150.00 -150.00 .0% 1013205 4916 MSC RMB-AS -458.00 -300.00 -150.00 -187.00 -150.00 .00 -100.0%

TOTAL ANIMAL SERVICES -130,902.00 -136,950.00 -89,420.00 -93,953.28 -89,320.00 -89,040.00 -.4% ____________________________________________
1013211 POLICE PATROL
1013211 4421 PD TRAING -22,309.85 -10,000.00 -18,340.00 -15,737.92 -18,340.00 -10,000.00 -45.5% 1013211 4627 PD-SCHL RS .00 -99,450.00 -28,720.00 -28,722.00 -28,720.00 -94,450.00 228.9% 1013211 4701 NON-VEH FN -183.76 -210.00 -90.00 -81.97 -90.00 -130.00 44.4% 1013211 4702 VEH FINE -95,542.82 -130,000.00 -130,730.00 -78,252.36 -130,790.00 -130,000.00 -.6% 1013211 4703 RED LIT FN -9,206.43 .00 -13,000.00 -8,574.36 -13,000.00 -11,100.00 -14.6% 1013211 4706 MU-CITE-PD -121,370.65 -100,000.00 -187,500.00 -93,310.99 -187,500.00 -150,000.00 -20.0% 1013211 4708 PD-FLS ALM -143,554.29 -150,000.00 -149,640.00 -98,181.00 -149,640.00 -146,600.00 -2.0% 1013211 4908 MISC REIMB -9,322.00 .00 .00 9,322.00 .00 .00 .0% 1013211 4918 PY REVENUE .00 .00 .00 -5,570.71 .00 .00 .0%

TOTAL POLICE PATROL -401,489.80 -489,660.00 -528,020.00 -319,109.31 -528,080.00 -542,280.00 2.7% ____________________________________________
1013231 SPECIAL EVENTS & COMM OUTREACH
1013231 4623 PD SPC FEE -641.60 -24,200.00 -8,760.00 -8,443.04 -8,760.00 -4,500.00 -48.6%

Page 30 of 214 ends

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

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

TOTAL SPECIAL EVENTS & COMM -641.60 -24,200.00 -8,760.00 -8,443.04 -8,760.00 -4,500.00 -48.6% ____________________________________________
1013233 CODE ENFORCEMENT
1013233 4704 MU-CD FN -6,986.00 -13,000.00 -8,400.00 -17,914.30 -8,400.00 -13,000.00 54.8%

TOTAL CODE ENFORCEMENT -6,986.00 -13,000.00 -8,400.00 -17,914.30 -8,400.00 -13,000.00 54.8% ____________________________________________
1013501 FIRE ADMINISTRATION
1013501 4642 FR MERGER -10,808.58 .00 .00 -10,137.26 .00 .00 .0%

TOTAL FIRE ADMINISTRATION -10,808.58 .00 .00 -10,137.26 .00 .00 .0% ____________________________________________
1014201 RECREATION ADMINISTRATION
1014201 4654 21201 FIELD USE -10,231.85 .00 .00 -157.20 .00 .00 .0% 1014201 4654 21202 FIELD USE -435.16 .00 .00 -1,282.80 .00 .00 .0% 1014201 4654 21203 FIELD USE -21,161.70 .00 .00 -2,070.00 .00 .00 .0% 1014201 4654 21205 FIELD USE .00 .00 .00 4,063.11 .00 .00 .0% 1014201 4654 21206 FIELD USE -594.78 .00 .00 -4,063.11 .00 .00 .0% 1014201 4679 PASSPORT .00 -20,000.00 -36,000.00 -34,732.00 -20,000.00 -30,000.00 -16.7% 1014201 4803 RENT-REC -1,985.00 .00 .00 -190.00 .00 .00 .0% 1014201 4803 20105 RENT-REC -210.00 .00 .00 -450.00 .00 .00 .0% 1014201 4804 RENT-PARK -17,522.50 .00 .00 -1,415.00 .00 .00 .0% 1014201 4909 OTHER REV .22 .00 .00 -70.47 .00 .00 .0%

TOTAL RECREATION ADMINISTRAT -52,140.77 -20,000.00 -36,000.00 -40,367.47 -20,000.00 -30,000.00 -16.7% ____________________________________________
1014202 RECREATION CLASSES
1014202 4655 REC FEES -76.05 -37,500.00 .00 -1,710.00 -37,500.00 -37,500.00 .0% 1014202 4657 REC USER -48,248.30 -200,000.00 -200,000.00 -138,931.55 -200,000.00 -200,000.00 .0% 1014202 4657 20201 REC USER -1,055.00 .00 .00 -600.00 .00 .00 .0% 1014202 4657 20202 REC USER -100.00 .00 .00 .00 .00 .00 .0% 1014202 4657 20205 REC USER -61.25 .00 .00 -96.75 .00 .00 .0% 1014202 4657 20210 REC USER -10.00 .00 .00 .00 .00 .00 .0%

TOTAL RECREATION CLASSES -49,550.60 -237,500.00 -200,000.00 -141,338.30 -237,500.00 -237,500.00 18.8% ____________________________________________
1014203 RECREATION FACILITIES
1014203 4667 LANDECENA .00 -3,400.00 -1,500.00 .00 -1,500.00 -3,000.00 100.0%

Page 31 of 214 ends

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

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

TOTAL RECREATION FACILITIES .00 -18,400.00 -6,500.00 -4,850.00 -6,500.00 -18,000.00 176.9% ____________________________________________
1014204 RECREATION PARKS
1014204 4654 FIELD USE .00 -22,500.00 -30,000.00 .00 -30,000.00 -40,000.00 33.3% 1014204 4654 21201 FIELD USE .00 .00 .00 -9,934.14 .00 .00 .0% 1014204 4654 21202 FIELD USE .00 .00 .00 -2,880.98 .00 .00 .0% 1014204 4654 21203 FIELD USE .00 .00 .00 -7,619.47 .00 .00 .0% 1014204 4654 21204 FIELD USE .00 .00 .00 -3,513.75 .00 .00 .0% 1014204 4654 21205 FIELD USE .00 .00 .00 -4,063.11 .00 .00 .0% 1014204 4654 21206 FIELD USE .00 .00 .00 -594.36 .00 .00 .0% 1014204 4656 YTH SPORTS .00 -1,000.00 -1,000.00 .00 -1,000.00 .00 -100.0% 1014204 4656 20406 YTH SPORTS .00 .00 .00 -152.00 -152.00 .00 .0% 1014204 4804 RENT-PARK .00 -17,500.00 -17,500.00 -2,520.00 -17,500.00 -25,000.00 42.9% 1014204 4804 21311 RENT-PARK .00 .00 .00 -495.00 .00 .00 .0% 1014204 4804 21312 RENT-PARK .00 .00 .00 -315.00 .00 .00 .0% 1014204 4804 21313 RENT-PARK .00 .00 .00 -1,523.00 .00 .00 .0% 1014204 4804 21314 RENT-PARK .00 .00 .00 -4,350.00 .00 .00 .0% 1014204 4804 21315 RENT-PARK .00 .00 .00 -5,737.50 .00 .00 .0% 1014204 4804 21316 RENT-PARK .00 .00 .00 -2,160.00 .00 .00 .0% 1014204 4804 21317 RENT-PARK .00 .00 .00 -900.00 .00 .00 .0% 1014204 4804 21318 RENT-PARK .00 .00 .00 -4,237.50 .00 .00 .0% 1014204 4804 21319 RENT-PARK .00 .00 .00 -8,812.50 .00 .00 .0%

TOTAL RECREATION PARKS .00 -41,000.00 -48,500.00 -59,808.31 -48,652.00 -65,000.00 34.0% ____________________________________________
1014205 SENIOR CENTER
1014205 4659 SR CTR FEE -1,589.00 -6,000.00 -6,000.00 -4,620.00 -6,000.00 -6,000.00 .0% 1014205 4659 20546 SR CTR FEE -150.00 .00 .00 -750.00 .00 .00 .0% 1014205 4659 20547 SR CTR FEE -219.00 .00 .00 .00 .00 .00 .0% 1014205 4659 20548 SR CTR FEE -348.00 .00 .00 .00 .00 .00 .0% 1014205 4659 20552 SR CTR FEE -267.00 .00 .00 .00 .00 .00 .0% 1014205 4905 32304 DONATION .00 .00 .00 -900.00 .00 .00 .0%

TOTAL SENIOR CENTER -2,573.00 -6,000.00 -6,000.00 -6,270.00 -6,000.00 -6,000.00 .0% ____________________________________________
1014206 SPECIAL EVENTS
1014206 4658 SPC EVENTS .00 -77,300.00 -65,700.00 -29,278.25 -77,300.00 -55,000.00 -16.3% 1014206 4658 20611 SPC EVENTS -36,943.71 .00 .00 -5,660.59 .00 .00 .0%

Page 32 of 214 ends

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

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

TOTAL SPECIAL EVENTS -46,667.66 -77,300.00 -65,700.00 -41,805.02 -77,300.00 -55,000.00 -16.3% ____________________________________________
1014207 COMMUNITY OUTREACH SERVICES
1014207 4660 YTH PRTNR -692.76 .00 .00 .00 .00 .00 .0%

TOTAL COMMUNITY OUTREACH SER -692.76 .00 .00 .00 .00 .00 .0% ____________________________________________
1014409 PASSPORTS
1014409 4679 PASSPORT -5,608.70 .00 .00 -15,972.00 .00 .00 .0%

TOTAL PASSPORTS -5,608.70 .00 .00 -15,972.00 .00 .00 .0% ____________________________________________
1015201 PUBLIC WORKS ADMINISTRATION
1015201 4904 GEN DONATN -7,704.89 .00 .00 -8,120.68 .00 .00 .0% 1015201 4908 MISC REIMB -1,387.50 .00 .00 .00 .00 .00 .0% 1015201 4909 OTHER REV .26 .00 .00 .00 .00 .00 .0%

TOTAL PUBLIC WORKS ADMINISTR -9,092.13 .00 .00 -8,120.68 .00 .00 .0% ____________________________________________
1015301 ENGINEERING ADMINISTRATION
1015301 4908 MISC REIMB .00 .00 .00 -12,314.50 .00 .00 .0%

TOTAL ENGINEERING ADMINISTRA .00 .00 .00 -12,314.50 .00 .00 .0% ____________________________________________
1015302 DEVELOPMENT/TRAFFIC ENGINRG
1015302 4205 CNSTR PERM -346,631.00 -300,000.00 -150,000.00 -130,675.50 -300,000.00 -200,000.00 33.3% 1015302 4645 PW FEES -81,057.50 -50,000.00 -250,000.00 -231,456.63 -50,000.00 -100,000.00 -60.0% 1015302 4646 ENG PL CK -337,744.46 -300,000.00 -125,000.00 -104,217.50 -300,000.00 -300,000.00 140.0%

TOTAL DEVELOPMENT/TRAFFIC EN -765,432.96 -650,000.00 -525,000.00 -466,349.63 -650,000.00 -600,000.00 14.3% ____________________________________________
1015404 STREET LIGHTING
1015404 4603 DAMAG PROP -15,794.64 .00 .00 -966.55 .00 .00 .0%

Page 33 of 214 ends

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

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

TOTAL STREET LIGHTING -15,794.64 .00 .00 -966.55 .00 .00 .0% ____________________________________________
1015405 TRAFFIC CONTROL
1015405 4603 DAMAG PROP -17,248.81 .00 -22,000.00 -21,677.94 .00 .00 -100.0%

TOTAL TRAFFIC CONTROL -17,248.81 .00 -22,000.00 -21,677.94 .00 .00 -100.0% ____________________________________________
1015413 MAINTENANCE-METROLINK STATION
1015413 4226 54130 METRO PKG -2,005.25 -65,000.00 -15,000.00 -4,716.71 -65,000.00 -21,100.00 40.7%

TOTAL MAINTENANCE-METROLINK -2,005.25 -65,000.00 -15,000.00 -4,716.71 -65,000.00 -21,100.00 40.7% ____________________________________________
1015416 DAMAGE TO CITY PROPERTY
1015416 4603 DAMAG PROP -12,774.85 .00 -28,000.00 -29,362.14 .00 .00 -100.0%

TOTAL DAMAGE TO CITY PROPERT -12,774.85 .00 -28,000.00 -29,362.14 .00 .00 -100.0% ____________________________________________
1015601 CITY HALL
1015601 4227 VEH CHG -2,063.60 .00 -5,000.00 -5,115.08 .00 .00 -100.0%

TOTAL CITY HALL -2,063.60 .00 -5,000.00 -5,115.08 .00 .00 -100.0% TOTAL GENERAL FUND -50,322,887.69 -45,968,480.00 -48,863,370.00 -36,470,349.27 -49,129,952.00 -50,181,580.00 2.7%

Page 34 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 9
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2010000 HOUSING FUND
2010000 4801 INT INCOME -21,416.47 -23,000.00 -23,000.00 -5,237.06 -15,000.00 -15,000.00 -34.8% 2010000 4805 RENT-APTMK .00 -4,400,000.00 -4,400,000.00 .00 -4,400,000.00 -4,600,000.00 4.5% 2010000 4872 UNRL GN/LS 21,810.42 .00 .00 3,657.10 .00 .00 .0% 2010000 4908 MISC REIMB .00 -184,780.00 -184,780.00 .00 -187,490.00 -196,280.00 6.2% 2010000 4909 OTHER REV -231,284.00 -25,000.00 -25,000.00 -67,241.76 .00 -2,000.00 -92.0% 2010000 4970 TRNSFR IN -2,448,983.03 .00 .00 -2,142,214.97 .00 .00 .0% 2010000 4970 16110 TRNSFR IN -430.85 .00 .00 .00 .00 .00 .0% 2010000 4970 16111 TRNSFR IN -364.96 .00 .00 .00 .00 .00 .0%

TOTAL HOUSING FUND -2,680,668.89 -4,632,780.00 -4,632,780.00 -2,211,036.69 -4,602,490.00 -4,813,280.00 3.9% ____________________________________________
2012931 HOUSING PROGRAM
2012931 4602 CC FEES .00 .00 .00 -384.75 .00 .00 .0% 2012931 4605 HOUSING FE .00 .00 .00 -449.62 .00 .00 .0% 2012931 4908 MISC REIMB .00 .00 .00 -5,463.32 .00 .00 .0% 2012931 4909 OTHER REV .00 .00 .00 -5,500.00 .00 .00 .0%

TOTAL HOUSING PROGRAM .00 .00 .00 -11,797.69 .00 .00 .0% TOTAL HOUSING FUND -2,680,668.89 -4,632,780.00 -4,632,780.00 -2,222,834.38 -4,602,490.00 -4,813,280.00 3.9%

Page 35 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 10
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 4801 INT INCOME -49.37 .00 .00 -7.26 .00 .00 .0% 2020000 4805 RENT-APTMK -3,747,234.37 .00 .00 -2,185,316.43 .00 .00 .0% 2020000 4809 RENT-APTLO -455,404.35 .00 .00 -434,385.81 .00 .00 .0% 2020000 4909 OTHER REV -168,023.04 .00 .00 -45,092.31 .00 .00 .0% 2020000 4920 LATE CHG -12,350.00 .00 .00 -3,300.00 .00 .00 .0%

TOTAL HOUSING FUND - RENTALS -4,383,061.13 .00 .00 -2,668,101.81 .00 .00 .0% TOTAL HOUSING FUND - RENTALS -4,383,061.13 .00 .00 -2,668,101.81 .00 .00 .0%

Page 36 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 11
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2030000 PUB SAFETY AUGMENTATION
2030000 4106 1/2 CNT TX -1,056,742.00 -1,339,880.00 -1,339,880.00 -1,023,064.00 -1,388,960.00 -1,422,700.00 6.2% 2030000 4801 INT INCOME -1,219.67 .00 .00 -121.08 .00 .00 .0%

TOTAL PUB SAFETY AUGMENTATIO -1,057,961.67 -1,339,880.00 -1,339,880.00 -1,023,185.08 -1,388,960.00 -1,422,700.00 6.2% TOTAL PUB SAFETY AUGMENTATIO -1,057,961.67 -1,339,880.00 -1,339,880.00 -1,023,185.08 -1,388,960.00 -1,422,700.00 6.2%

Page 37 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 12
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2040000 GAS TAX
2040000 4450 G TX 21075 -7,500.00 -7,500.00 -7,500.00 -7,500.00 -7,500.00 -7,500.00 .0% 2040000 4451 GS TX 2106 -250,530.76 -275,070.00 -275,070.00 -212,917.90 -284,262.00 -310,160.00 12.8% 2040000 4452 GS TX 2107 -543,338.38 -574,900.00 -574,900.00 -377,017.98 -632,842.00 -692,040.00 20.4% 2040000 4453 GS TX 2105 -401,530.22 -451,760.00 -451,760.00 -331,931.23 -464,374.00 -506,560.00 12.1% 2040000 4456 GS TX 2103 -525,825.66 -693,300.00 -693,300.00 -471,925.41 -665,796.00 -773,280.00 11.5% 2040000 4801 INT INCOME -57,185.42 -50,000.00 -50,000.00 -11,569.26 -50,000.00 .00 -100.0% 2040000 4872 UNRL GN/LS 60,356.83 .00 .00 9,765.26 .00 .00 .0% 2040000 4909 OTHER REV -2,326.11 .00 .00 .00 .00 .00 .0%

TOTAL GAS TAX -1,727,879.72 -2,052,530.00 -2,052,530.00 -1,403,096.52 -2,104,774.00 -2,289,540.00 11.5% TOTAL GAS TAX -1,727,879.72 -2,052,530.00 -2,052,530.00 -1,403,096.52 -2,104,774.00 -2,289,540.00 11.5%

Page 38 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 13
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2050000 MEASURE I
2050000 4501 MEASURE I -1,782,332.09 -1,364,270.00 -1,364,270.00 -1,017,875.59 -1,561,771.00 -1,623,180.00 19.0% 2050000 4801 INT INCOME -44,347.96 -45,000.00 -45,000.00 -10,259.41 -45,000.00 .00 -100.0% 2050000 4872 UNRL GN/LS 49,874.43 .00 .00 7,573.06 .00 .00 .0%

TOTAL MEASURE I -1,776,805.62 -1,409,270.00 -1,409,270.00 -1,020,561.94 -1,606,771.00 -1,623,180.00 15.2% TOTAL MEASURE I -1,776,805.62 -1,409,270.00 -1,409,270.00 -1,020,561.94 -1,606,771.00 -1,623,180.00 15.2%

Page 39 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 14
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2060000 RMRA
2060000 4457 GS TX RMRA -1,461,096.64 -1,533,890.00 -1,533,890.00 -1,043,670.82 -1,626,200.00 -1,789,680.00 16.7% 2060000 4801 INT INCOME -4,001.47 .00 .00 -2,747.86 .00 .00 .0% 2060000 4872 UNRL GN/LS -683.31 .00 .00 683.31 .00 .00 .0%

TOTAL RMRA -1,465,781.42 -1,533,890.00 -1,533,890.00 -1,045,735.37 -1,626,200.00 -1,789,680.00 16.7% TOTAL ROAD MAINT REHAB ACCOU -1,465,781.42 -1,533,890.00 -1,533,890.00 -1,045,735.37 -1,626,200.00 -1,789,680.00 16.7%

Page 40 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 15
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2080000 HOME
2080000 4801 INT INCOME -12,148.72 -800.00 -800.00 -2,573.00 -800.00 -800.00 .0% 2080000 4921 PI-ADM 10% -5,819.00 -5,000.00 -5,000.00 -8,116.40 -7,500.00 -5,000.00 .0% 2080000 4922 RECAP INC .00 -5,000.00 -5,000.00 .00 .00 -1,000.00 -80.0% 2080000 4923 PI-HIP -16,380.00 -25,000.00 -25,000.00 -100,705.00 -1,500.00 -1,500.00 -94.0% 2080000 4924 PI-FTHB -114,655.79 -40,000.00 -40,000.00 -141,196.61 -40,000.00 -40,000.00 .0%

TOTAL HOME -149,003.51 -75,800.00 -75,800.00 -252,591.01 -49,800.00 -48,300.00 -36.3% TOTAL HOME -149,003.51 -75,800.00 -75,800.00 -252,591.01 -49,800.00 -48,300.00 -36.3%

Page 41 of 214 ends

05/02/2022 12:03 |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
CDBG ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2090000 CDBG
2090000 4310 CDBG -206,543.02 -1,078,460.00 -1,562,877.25 -430,532.91 -825,250.00 -794,680.00 -49.2%

TOTAL CDBG -206,543.02 -1,078,460.00 -1,562,877.25 -430,532.91 -825,250.00 -794,680.00 -49.2% ____________________________________________
2092323 CDBG CORONAVIRUS
2092323 4310 CDBG -129,005.04 -183,590.00 -132,601.45 -162,660.37 -132,640.00 .00 -100.0%

TOTAL CDBG CORONAVIRUS -129,005.04 -183,590.00 -132,601.45 -162,660.37 -132,640.00 .00 -100.0% ____________________________________________
2092324 CDBG-CV3
2092324 4310 CDBG -23,565.94 -164,810.00 -269,715.69 -330,110.65 -270,310.00 .00 -100.0%

TOTAL CDBG-CV3 -23,565.94 -164,810.00 -269,715.69 -330,110.65 -270,310.00 .00 -100.0% TOTAL CDBG -359,114.00 -1,426,860.00 -1,965,194.39 -923,303.93 -1,228,200.00 -794,680.00 -59.6%

Page 42 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 17
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2100000 PBIA FUND
2100000 4108 PBID-ZN A -49,664.30 -49,000.00 -49,000.00 -41,577.42 -49,000.00 -49,000.00 .0% 2100000 4109 PBID-ZN B -9,133.04 -9,500.00 -9,500.00 -6,109.30 -9,500.00 -9,500.00 .0% 2100000 4801 INT INCOME -1,662.13 -500.00 -500.00 -307.85 -100.00 -100.00 -80.0%

TOTAL PBIA FUND -60,459.47 -59,000.00 -59,000.00 -47,994.57 -58,600.00 -58,600.00 -.7% TOTAL PBIA -60,459.47 -59,000.00 -59,000.00 -47,994.57 -58,600.00 -58,600.00 -.7%

Page 43 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 18
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2110000 AIR QUALITY POLLUTION REDUCT
2110000 4502 MV AB 2766 -102,913.84 -99,400.00 -99,400.00 -49,558.08 -99,400.00 -99,400.00 .0% 2110000 4801 INT INCOME -1,132.46 .00 .00 -293.05 .00 .00 .0% 2110000 4909 OTHER REV -855.00 .00 .00 .00 .00 .00 .0%

TOTAL AIR QUALITY POLLUTION -104,901.30 -99,400.00 -99,400.00 -49,851.13 -99,400.00 -99,400.00 .0% TOTAL AIR QUALITY POLLUTION -104,901.30 -99,400.00 -99,400.00 -49,851.13 -99,400.00 -99,400.00 .0%

Page 44 of 214 ends

05/02/2022 12:03 |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
HOMELAND SECURITY GRANTS-PD ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2140000 HOMELAND SECURITY GRANTS-PD
32606 HOMELAND SECURITY GRANT FY19
2140000 4342 32606 HSG PD .00 .00 -11,400.00 .00 -32,400.00 .00 -100.0% 2140000 4342 43201 HSG PD -28,334.00 .00 .00 .00 .00 .00 .0%

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

Page 45 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 20
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2150000 PROP 30
2150000 4801 INT INCOME -1,141.87 -900.00 -900.00 -238.94 -900.00 .00 -100.0%

TOTAL PROP 30 -1,141.87 -900.00 -900.00 -238.94 -900.00 .00 -100.0% TOTAL PROP 30 -1,141.87 -900.00 -900.00 -238.94 -900.00 .00 -100.0%

Page 46 of 214 ends

05/02/2022 12:03 |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
COPS ALLOCATION-PD ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2160000 COPS ALLOCATION-PD
2160000 4423 COPS -187,377.79 -120,000.00 -120,000.00 -193,699.65 -193,700.00 -120,000.00 .0% 2160000 4801 INT INCOME -7,464.15 .00 .00 -1,779.58 -3,560.00 .00 .0%

TOTAL COPS ALLOCATION-PD -194,841.94 -120,000.00 -120,000.00 -195,479.23 -197,260.00 -120,000.00 .0% TOTAL COPS ALLOCATION-PD -194,841.94 -120,000.00 -120,000.00 -195,479.23 -197,260.00 -120,000.00 .0%

Page 47 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 22
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2170000 OTHER GRANTS
32601 H.E.A.P.- FY19/20
2170000 4355 32601 ST REIMB -12,109.61 .00 .00 -32,813.28 .00 .00 .0% 2170000 4355 42021 ST REIMB .00 .00 -277,837.00 .00 -277,837.00 -277,840.00 .0% 2170000 4415 42020 STATE REV -13,084.37 .00 .00 -4,295.10 .00 .00 .0% 2170000 4908 16106 MISC REIMB .00 .00 .00 -1,000.00 .00 .00 .0% 2170000 4909 OTHER REV -145.67 -41,910.00 -41,910.00 .00 -41,910.00 .00 -100.0%

TOTAL OTHER GRANTS -25,339.65 -41,910.00 -319,747.00 -38,108.38 -319,747.00 -277,840.00 -13.1% ____________________________________________
2172205 PLANNING
2172205 4415 32605 STATE REV .00 .00 -310,000.00 .00 -232,500.00 -77,500.00 -75.0% 2172205 4415 32615 STATE REV .00 .00 .00 .00 .00 -300,000.00 .0%

TOTAL PLANNING .00 .00 -310,000.00 .00 -232,500.00 -377,500.00 21.8% ____________________________________________
2174201 RECREATION
2174201 4507 82331 CO GRNT RV .00 .00 -585,000.00 -585,000.00 .00 .00 -100.0%

TOTAL RECREATION .00 .00 -585,000.00 -585,000.00 .00 .00 -100.0% ____________________________________________
2175420 PER CAPITA GRANT
2175420 4908 MISC REIMB .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 -25,339.65 -266,980.00 -1,439,817.00 -623,108.38 -777,317.00 -655,340.00 -54.5%

Page 48 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 23
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2180000 OFFICE OF TRAFFIC SAFETY
2180000 4432 OTS-SOB -71,777.59 .00 .00 -25,302.45 -25,300.00 .00 .0% 2180000 4432 32607 OTS-SOB -6,619.82 -39,430.00 -39,430.00 -44,628.25 -44,620.00 .00 -100.0% 2180000 4432 32608 OTS-SOB -24,800.00 .00 .00 .00 .00 .00 .0% 2180000 4432 32609 OTS-SOB .00 -6,000.00 -6,000.00 -3,425.81 -3,420.00 .00 -100.0% 2180000 4432 32610 OTS-SOB .00 .00 -170,000.00 .00 -15,730.00 -154,270.00 -9.3% 2180000 4432 32611 OTS-SOB .00 .00 -23,000.00 .00 -20,520.00 .00 -100.0%

TOTAL OFFICE OF TRAFFIC SAFE -103,197.41 -45,430.00 -238,430.00 -73,356.51 -109,590.00 -154,270.00 -35.3% TOTAL OFFICE OF TRAFFIC SAFE -103,197.41 -45,430.00 -238,430.00 -73,356.51 -109,590.00 -154,270.00 -35.3%

Page 49 of 214 ends

05/02/2022 12:03 |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
OTHER PUBLIC SAFETY GRANTS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2190000 OTHER PUBLIC SAFETY GRANTS
2190000 4355 ST REIMB .00 .00 .00 -2,968.82 .00 .00 .0% 2190000 4355 32001 ST REIMB -11,669.58 -11,320.00 -11,320.00 -7,907.01 -11,320.00 .00 -100.0% 2190000 4355 32603 ST RMB-OW -66,315.00 .00 .00 .00 -62,940.00 .00 .0% 2190000 4355 32604 ST RMB-CD -79,632.50 .00 .00 -69,147.50 -69,140.00 .00 .0%

TOTAL OTHER PUBLIC SAFETY GR -157,617.08 -11,320.00 -11,320.00 -80,023.33 -143,400.00 .00 -100.0% TOTAL OTHER PUBLIC SAFETY GR -157,617.08 -11,320.00 -11,320.00 -80,023.33 -143,400.00 .00 -100.0%

Page 50 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 25
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-FED DOJ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2200000 ASSET FORFEITURE-FED DOJ
2200000 4435 AF-FED -15,112.50 .00 .00 .00 .00 .00 .0% 2200000 4801 INT INCOME -3,949.56 .00 .00 -889.82 .00 .00 .0%

TOTAL ASSET FORFEITURE-FED D -19,062.06 .00 .00 -889.82 .00 .00 .0% TOTAL ASSET FORFEITURE-FED D -19,062.06 .00 .00 -889.82 .00 .00 .0%

Page 51 of 214 ends

05/02/2022 12:03 |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
CALHOME ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2220000 CALHOME
2220000 4801 INT INCOME -3,707.02 -200.00 -200.00 -930.78 -200.00 -200.00 .0% 2220000 4923 PI-HIP -79,330.00 -25,000.00 -25,000.00 -4,254.36 -10,000.00 -10,000.00 -60.0% 2220000 4924 PI-FTHB -89,895.03 -5,000.00 -5,000.00 -168,538.96 -125,000.00 -25,000.00 400.0%

TOTAL CALHOME -172,932.05 -30,200.00 -30,200.00 -173,724.10 -135,200.00 -35,200.00 16.6% TOTAL CALHOME -172,932.05 -30,200.00 -30,200.00 -173,724.10 -135,200.00 -35,200.00 16.6%

Page 52 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 27
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-FED TREASURY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2230000 ASSET FORFEITURE-FED TREASURY
2230000 4801 INT INCOME -76.26 .00 .00 -15.96 .00 .00 .0%

TOTAL ASSET FORFEITURE-FED T -76.26 .00 .00 -15.96 .00 .00 .0% TOTAL ASSET FORFEITURE-FED T -76.26 .00 .00 -15.96 .00 .00 .0%

Page 53 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 28
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2240000 ASSET FORFEITURE STATE
2240000 4321 H&S PD FOR -56.23 .00 .00 .00 .00 .00 .0% 2240000 4422 AF-STATE -318.62 .00 .00 .00 .00 .00 .0% 2240000 4801 INT INCOME -1,460.27 .00 .00 -295.80 .00 .00 .0%

TOTAL ASSET FORFEITURE STATE -1,835.12 .00 .00 -295.80 .00 .00 .0% TOTAL ASSET FORFEITURE-STATE -1,835.12 .00 .00 -295.80 .00 .00 .0%

Page 54 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 29
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
BSCC BUDGET ACT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
2250000 BSCC BUDGET ACT
2250000 4801 INT INCOME -617.39 .00 .00 -129.19 .00 .00 .0%

TOTAL BSCC BUDGET ACT -617.39 .00 .00 -129.19 .00 .00 .0% TOTAL BSCC BUDGET ACT -617.39 .00 .00 -129.19 .00 .00 .0%

Page 55 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 30
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 4439 16110 FED REV -648,751.00 .00 .00 .00 .00 .00 .0% 2260000 4439 16111 FD CTY CRS -973,127.00 .00 .00 .00 .00 .00 .0% 2260000 4439 16112 FD CRS PRJ -519,286.49 .00 .00 .46 .00 .00 .0% 2260000 4801 INT INCOME -2,062.78 .00 .00 .00 .00 .00 .0%

TOTAL FEDERAL GRANT-CARES AC -2,143,227.27 .00 .00 .46 .00 .00 .0% TOTAL FEDERAL GRANT-CARES AC -2,143,227.27 .00 .00 .46 .00 .00 .0%

Page 56 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 31
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
2270000 OFFICE OF JUSTICE PROGRAMS
2270000 4439 FED REV -41,498.84 .00 .00 .00 .00 .00 .0%

TOTAL OFFICE OF JUSTICE PROG -41,498.84 .00 .00 .00 .00 .00 .0% TOTAL OFFICE OF JUSTICE PROG -41,498.84 .00 .00 .00 .00 .00 .0%

Page 57 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 32
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 4439 FED REV .00 -7,960,000.00 -7,960,000.00 -7,606,858.00 -15,213,720.00 .00 -100.0% 2290000 4801 INT INCOME -4,741.43 .00 .00 -11,763.27 -30,000.00 -35,000.00 .0%

TOTAL AMERICAN RESCUE PLAN A -4,741.43 -7,960,000.00 -7,960,000.00 -7,618,621.27 -15,243,720.00 -35,000.00 -99.6% TOTAL AMERICAN RESCUE PLAN A -4,741.43 -7,960,000.00 -7,960,000.00 -7,618,621.27 -15,243,720.00 -35,000.00 -99.6%

Page 58 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 33
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
4200000 GENERAL DEVELOPMENT
4200000 4219 GEN CP IMP -181,107.34 -110,000.00 -110,000.00 -37,823.99 -110,000.00 -100,000.00 -9.1% 4200000 4220 FIR CP IMP .00 -56,000.00 -56,000.00 -3,528.00 -56,000.00 .00 -100.0% 4200000 4221 PD CAP IMP -164,642.15 -101,000.00 -101,000.00 -38,718.46 -101,000.00 -95,000.00 -5.9% 4200000 4801 INT INCOME -15,562.50 -12,000.00 -12,000.00 -3,438.45 -12,000.00 .00 -100.0% 4200000 4872 UNRL GN/LS 15,854.34 .00 .00 2,657.52 .00 .00 .0%

TOTAL GENERAL DEVELOPMENT -345,457.65 -279,000.00 -279,000.00 -80,851.38 -279,000.00 -195,000.00 -30.1% TOTAL GENERAL DEVELOPMENT -345,457.65 -279,000.00 -279,000.00 -80,851.38 -279,000.00 -195,000.00 -30.1%

Page 59 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 34
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
4210000 PARK ACQUISITION & DEVELOPMENT
4210000 4107 PK IMP FEE -1,660,906.00 -1,192,920.00 -1,192,920.00 -332,757.00 -1,192,920.00 -800,000.00 -32.9% 4210000 4801 INT INCOME -66,584.76 -50,000.00 -50,000.00 -15,753.83 -50,000.00 .00 -100.0% 4210000 4872 UNRL GN/LS 67,405.06 .00 .00 11,370.32 .00 .00 .0% 4210000 4918 PY REVENUE 87,821.69 .00 .00 .00 .00 .00 .0%

TOTAL PARK ACQUISITION & DEV -1,572,264.01 -1,242,920.00 -1,242,920.00 -337,140.51 -1,242,920.00 -800,000.00 -35.6% TOTAL PARK ACQUISITION & DEV -1,572,264.01 -1,242,920.00 -1,242,920.00 -337,140.51 -1,242,920.00 -800,000.00 -35.6%

Page 60 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 35
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
4220000 STORM DRAIN DEVELOPMENT
4220000 4211 SD PERMIT -786,515.90 -310,500.00 -310,500.00 -155,357.04 -310,500.00 -290,000.00 -6.6% 4220000 4801 INT INCOME -32,374.04 -26,000.00 -26,000.00 -7,741.51 -26,000.00 .00 -100.0% 4220000 4872 UNRL GN/LS 33,049.04 .00 .00 5,528.34 .00 .00 .0% 4220000 4902 LEASE PROC -35,317.29 -74,210.00 -74,210.00 .00 -35,655.00 -36,000.00 -51.5% 4220000 4902 50120 LEASE PROC -3,489.86 .00 .00 -2,538.08 -3,810.00 -3,810.00 .0% 4220000 4902 50121 LEASE PROC -27,557.83 .00 .00 -20,893.70 -28,045.00 -28,890.00 .0% 4220000 4902 50122 LEASE PROC -7,500.00 .00 .00 -6,250.00 -7,500.00 -7,500.00 .0%

TOTAL STORM DRAIN DEVELOPMEN -859,705.88 -410,710.00 -410,710.00 -187,251.99 -411,510.00 -366,200.00 -10.8% TOTAL STORM DRAIN DEVELOPMEN -859,705.88 -410,710.00 -410,710.00 -187,251.99 -411,510.00 -366,200.00 -10.8%

Page 61 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 36
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
4230000 STREET & TRAFFIC FACILITY DEV
4230000 4212 S&T PERMIT -464,484.04 -185,000.00 -185,000.00 -149,128.64 -185,000.00 -370,000.00 100.0% 4230000 4801 INT INCOME -18,084.85 -16,000.00 -16,000.00 -2,583.24 -16,000.00 -16,000.00 .0% 4230000 4872 UNRL GN/LS 21,902.55 .00 .00 3,088.25 .00 .00 .0%

TOTAL STREET & TRAFFIC FACIL -460,666.34 -201,000.00 -201,000.00 -148,623.63 -201,000.00 -386,000.00 92.0% TOTAL STREET & TRAFFIC FACIL -460,666.34 -201,000.00 -201,000.00 -148,623.63 -201,000.00 -386,000.00 92.0%

Page 62 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 37
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 ____________________________________________________________________________________________________________________________________ ____________________________________________
4250000 GENERAL CAPITAL PROJECTS
4250000 4970 TRNSFR IN -400,000.00 -200,000.00 -290,000.00 -290,000.00 -200,000.00 -240,000.00 -17.2% 4250000 4970 82337 TRNSFR IN -193,000.00 .00 .00 .00 .00 .00 .0%

TOTAL GENERAL CAPITAL PROJEC -593,000.00 -200,000.00 -290,000.00 -290,000.00 -200,000.00 -240,000.00 -17.2% ____________________________________________
4258040 UTILITY UNDERGROUND 2019
4258040 4235 UN UTIL WV .00 .00 .00 -22,000.00 .00 .00 .0%

TOTAL UTILITY UNDERGROUND 20 .00 .00 .00 -22,000.00 .00 .00 .0% TOTAL GENERAL CAPITAL PROJEC -593,000.00 -200,000.00 -290,000.00 -312,000.00 -200,000.00 -240,000.00 -17.2%

Page 63 of 214 ends

05/02/2022 12:03 |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
STREET& ALLEY REPAIRS-BURRTEC ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
4260000 STREET& ALLEY REPAIRS-BURRTEC
4260000 4225 S&A-BURR -216,348.00 -220,680.00 -220,680.00 -164,305.00 -220,680.00 -240,000.00 8.8% 4260000 4801 INT INCOME -6,787.47 .00 .00 -1,141.50 .00 .00 .0% 4260000 4872 UNRL GN/LS 7,409.77 .00 .00 1,159.06 .00 .00 .0%

TOTAL STREET& ALLEY REPAIRS- -215,725.70 -220,680.00 -220,680.00 -164,287.44 -220,680.00 -240,000.00 8.8% TOTAL STREET& ALLEY REPAIRS- -215,725.70 -220,680.00 -220,680.00 -164,287.44 -220,680.00 -240,000.00 8.8%

Page 64 of 214 ends

05/02/2022 12:03 |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
ERG EFFIC CAPITAL IMPROVED PRO ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
4270000 ERG EFFIC CAPITAL IMPROVED PRO
4270000 4801 INT INCOME -42.32 .00 .00 .00 .00 .00 .0%

TOTAL ERG EFFIC CAPITAL IMPR -42.32 .00 .00 .00 .00 .00 .0% TOTAL ERG EFFIC CAPITAL IMPR -42.32 .00 .00 .00 .00 .00 .0%

Page 65 of 214 ends

05/02/2022 12:03 |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
WATER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
6400000 WATER UTILITY
6400000 4214 WTR CNS PM -690,512.43 -400,000.00 -400,000.00 -177,470.44 -400,000.00 -350,000.00 -12.5% 6400000 4603 DAMAG PROP -32,161.62 .00 .00 .00 .00 .00 .0% 6400000 4681 WTR-MTR -27,401,301.52 -27,800,000.00 -27,800,000.00 -20,485,352.15 -27,800,000.00 -30,302,000.00 9.0% 6400000 4682 WTR-FL RAT -58,752.30 -55,000.00 -55,000.00 -47,290.64 -55,000.00 -55,000.00 .0% 6400000 4688 WTR-RCYCL -511,010.00 -540,000.00 -540,000.00 -461,132.85 -540,000.00 .00 -100.0% 6400000 4691 METER INST -137,225.00 -105,000.00 -105,000.00 -102,178.00 -105,000.00 -105,000.00 .0% 6400000 4692 LSE STR WT -327,016.69 .00 .00 .00 .00 .00 .0% 6400000 4697 FLOW TEST -7,210.00 -5,000.00 -5,000.00 -8,100.00 6,000.00 -6,000.00 20.0% 6400000 4698 WTR JUMPR -19,035.00 .00 .00 -11,025.00 .00 .00 .0% 6400000 4699 JV INC -1,908,828.19 .00 .00 .00 .00 .00 .0% 6400000 4710 MU-LATE CH -31.50 .00 .00 .00 .00 .00 .0% 6400000 4801 INT INCOME -206,379.79 -55,000.00 -55,000.00 -47,185.62 -55,000.00 -385,050.00 600.1% 6400000 4872 UNRL GN/LS 185,172.95 .00 .00 35,242.24 .00 .00 .0% 6400000 4901 SALE OF CA -359,637.50 .00 .00 -16,500.00 .00 .00 .0% 6400000 4908 MISC REIMB -1,906.67 -280,000.00 -280,000.00 -1,743.24 -280,000.00 -280,000.00 .0% 6400000 4909 OTHER REV -139,337.29 -150,000.00 -150,000.00 -155,231.66 -150,000.00 -150,000.00 .0% 6400000 4970 16111 TRNSFR IN -982.44 .00 .00 .00 .00 .00 .0% 6400000 4999 OTC - UB .00 .00 .00 -2,207,121.11 .00 .00 .0%

TOTAL WATER UTILITY -31,616,154.99 -29,390,000.00 -29,390,000.00 -23,685,088.47 -29,379,000.00 -31,633,050.00 7.6% ____________________________________________
6406201 WATER ADMINISTRATION
6406201 4603 DAMAG PROP -3,632.44 .00 .00 .00 .00 .00 .0% 6406201 4908 MISC REIMB .00 .00 .00 -6,823,724.61 .00 .00 .0%

TOTAL WATER ADMINISTRATION -3,632.44 .00 .00 -6,823,724.61 .00 .00 .0% ____________________________________________
6406214 RECYCLED WATER RETROFIT
6406214 4908 MISC REIMB -4,208.75 .00 .00 .00 .00 .00 .0%

TOTAL RECYCLED WATER RETROFI -4,208.75 .00 .00 .00 .00 .00 .0% TOTAL WATER UTILITY -31,623,996.18 -29,390,000.00 -29,390,000.00 -30,508,813.08 -29,379,000.00 -31,633,050.00 7.6%

Page 66 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SOLID WASTE UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
6410000 SOLID WASTE UTILITY
6410000 4351 BEV RECYCL .00 -19,480.00 -19,480.00 .00 -19,480.00 .00 -100.0% 6410000 4351 40051 BEV RECYCL -2,478.26 .00 .00 -17,001.74 .00 .00 .0% 6410000 4351 40052 BEV RECYCL .00 .00 .00 -19,621.00 .00 .00 .0% 6410000 4352 USED OIL .00 -21,160.00 -21,160.00 .00 -21,160.00 .00 -100.0% 6410000 4352 40100 USED OIL .00 .00 .00 -9,197.00 .00 .00 .0% 6410000 4685 SW-RES COL -5,550,687.10 -5,701,370.00 -5,701,370.00 -4,422,485.80 -5,701,370.00 -6,600,000.00 15.8% 6410000 4686 SW-NRS COL -8,930,752.52 -10,398,460.00 -10,398,460.00 -7,880,028.26 -10,398,460.00 -9,500,000.00 -8.6% 6410000 4689 HHW-BURRTC -162,264.00 -165,510.00 -165,510.00 -123,231.00 -165,510.00 -180,000.00 8.8% 6410000 4801 INT INCOME -13,023.95 -15,000.00 -15,000.00 -2,215.50 -15,000.00 -5,000.00 -66.7% 6410000 4872 UNRL GN/LS 19,041.57 .00 .00 2,223.96 .00 .00 .0% 6410000 4970 16111 TRNSFR IN -613.19 .00 .00 .00 .00 .00 .0%

TOTAL SOLID WASTE UTILITY -14,640,777.45 -16,320,980.00 -16,320,980.00 -12,471,556.34 -16,320,980.00 -16,285,000.00 -.2% ____________________________________________
6416329 USED OIL BLOCK GRANT - OPP10
6416329 4352 USED OIL -21,152.56 .00 .00 .00 .00 .00 .0%

TOTAL USED OIL BLOCK GRANT - -21,152.56 .00 .00 .00 .00 .00 .0% TOTAL SOLID WASTE UTILITY -14,661,930.01 -16,320,980.00 -16,320,980.00 -12,471,556.34 -16,320,980.00 -16,285,000.00 -.2%

Page 67 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SEWER UTILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
6450000 SEWER UTILITY
6450000 4210 SWR-CITY -337,647.95 -150,000.00 -150,000.00 -84,142.09 -150,000.00 -130,000.00 -13.3% 6450000 4213 WW PERMIT -77,048.75 -60,000.00 -60,000.00 -31,911.00 -60,000.00 -60,000.00 .0% 6450000 4683 SWR COLL -3,429,352.28 -3,212,200.00 -3,212,200.00 -2,292,439.72 -3,212,200.00 -2,600,000.00 -19.1% 6450000 4684 SWR-IEUA -6,894,965.15 -7,034,430.00 -7,034,430.00 -5,512,822.84 -7,034,430.00 -7,400,000.00 5.2% 6450000 4687 SWR CONN -22,749.69 -16,600.00 -16,600.00 -5,306.37 -16,600.00 -16,600.00 .0% 6450000 4694 SWR-MCLAIR -245.64 -500.00 -500.00 -203.85 -500.00 -500.00 .0% 6450000 4695 SWR-ONTARO -40,567.41 -48,000.00 -48,000.00 -32,887.65 -48,000.00 -50,000.00 4.2% 6450000 4696 SWR-LA CO -15,208.44 -18,000.00 -18,000.00 -12,831.30 -18,000.00 -18,000.00 .0% 6450000 4801 INT INCOME -167,647.76 .00 .00 -30,755.46 .00 -155,500.00 .0% 6450000 4872 UNRL GN/LS 131,764.46 .00 .00 21,038.47 .00 .00 .0% 6450000 4901 SALE OF CA -29,350.00 .00 .00 .00 .00 .00 .0% 6450000 4909 OTHER REV -1,126.50 .00 .00 .00 .00 .00 .0% 6450000 4970 TRNSFR IN -265,000.00 -265,000.00 -265,000.00 -265,000.00 -265,000.00 -265,000.00 .0% 6450000 4970 16111 TRNSFR IN -1,679.66 .00 .00 .00 .00 .00 .0%

TOTAL SEWER UTILITY -11,150,824.77 -10,804,730.00 -10,804,730.00 -8,247,261.81 -10,804,730.00 -10,695,600.00 -1.0% TOTAL SEWER UTILITY -11,150,824.77 -10,804,730.00 -10,804,730.00 -8,247,261.81 -10,804,730.00 -10,695,600.00 -1.0%

Page 68 of 214 ends

05/02/2022 12:03 |City of Upland, CA |P 43
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
FIRE ANNEXATION WORKER'S COMP ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7500000 FIRE ANNEXATION WORKER'S COMP
7500000 4801 INT INCOME -3,523.41 .00 .00 -737.29 .00 .00 .0%

TOTAL FIRE ANNEXATION WORKER -3,523.41 .00 .00 -737.29 .00 .00 .0% TOTAL FIRE ANNEXATION WORKER -3,523.41 .00 .00 -737.29 .00 .00 .0%

Page 69 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
SELF-FUNDED LIABILITY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7510000 SELF-FUNDED LIABILITY
7510000 4801 INT INCOME -3,507.46 .00 .00 -1,692.27 .00 .00 .0% 7510000 4908 MISC REIMB -120.00 .00 .00 -2,304.96 .00 .00 .0% 7510000 4909 OTHER REV -1,555.77 .00 .00 .00 .00 .00 .0% 7510000 4970 TRNSFR IN -700,000.00 .00 -550,000.00 -550,000.00 .00 .00 -100.0% 7510000 4970 16110 TRNSFR IN -783.55 .00 .00 .00 .00 .00 .0% 7510000 4970 16111 TRNSFR IN -4,346.83 .00 .00 .00 .00 .00 .0%

TOTAL SELF-FUNDED LIABILITY -710,313.61 .00 -550,000.00 -553,997.23 .00 .00 -100.0% ____________________________________________
7511601 HUMAN RESOURCES
7511601 4908 MISC REIMB -1,593.33 .00 .00 .00 .00 .00 .0%

TOTAL HUMAN RESOURCES -1,593.33 .00 .00 .00 .00 .00 .0% ____________________________________________
7511611 WORKERS COMPENSATION
7511611 4671 UD-WK CMP -1,924,880.00 -1,997,290.00 -1,997,290.00 -1,830,873.00 -1,997,290.00 -2,069,310.00 3.6%

TOTAL WORKERS COMPENSATION -1,924,880.00 -1,997,290.00 -1,997,290.00 -1,830,873.00 -1,997,290.00 -2,069,310.00 3.6% ____________________________________________
7511612 UNEMPLOYMENT
7511612 4672 UD-UNEMPL -64,870.00 -64,970.00 -64,970.00 -59,554.00 -64,970.00 -63,680.00 -2.0%

TOTAL UNEMPLOYMENT -64,870.00 -64,970.00 -64,970.00 -59,554.00 -64,970.00 -63,680.00 -2.0% ____________________________________________
7511613 LONG-TERM DISABILITY
7511613 4673 UD-LT DISB -125,140.00 -125,000.00 -125,000.00 -114,598.00 -125,000.00 -90,990.00 -27.2%

TOTAL LONG-TERM DISABILITY -125,140.00 -125,000.00 -125,000.00 -114,598.00 -125,000.00 -90,990.00 -27.2% ____________________________________________
7511614 LIABILITY
7511614 4610 SUBROGATN -1,455,011.69 .00 .00 -253,707.13 .00 .00 .0% 7511614 4674 UD-LIABLTY -2,443,260.00 -2,503,830.00 -2,503,830.00 -2,295,183.00 -2,503,830.00 -2,978,470.00 19.0%

TOTAL LIABILITY -3,898,271.69 -2,503,830.00 -2,503,830.00 -2,548,890.13 -2,503,830.00 -2,978,470.00 19.0% ____________________________________________
7511615 LOSS PREVENTION
7511615 4675 UD-LOSS PR -124,980.00 -127,260.00 -127,260.00 -116,688.00 -127,260.00 -72,460.00 -43.1%

Page 70 of 214 ends

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

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

TOTAL LOSS PREVENTION -124,980.00 -127,260.00 -127,260.00 -116,688.00 -127,260.00 -72,460.00 -43.1% TOTAL SELF-FUNDED LIABILITY -6,850,048.63 -4,818,350.00 -5,368,350.00 -5,224,600.36 -4,818,350.00 -5,274,910.00 -1.7%

Page 71 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
FLEET MANAGEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7520000 FLEET MANAGEMENT
7520000 4676 UD-VEH REP -655,990.00 -1,376,390.00 -1,376,390.00 -1,261,722.00 -1,376,390.00 -746,080.00 -45.8% 7520000 4801 INT INCOME -5,575.09 .00 .00 -975.53 .00 .00 .0% 7520000 4901 SALE OF CA -66,650.00 -59,000.00 -59,000.00 -5,900.00 -59,000.00 -34,000.00 -42.4% 7520000 4970 TRNSFR IN -349,165.00 .00 -578,150.00 -578,150.00 .00 .00 -100.0% 7520000 4970 16110 TRNSFR IN -108.55 .00 .00 .00 .00 .00 .0%

TOTAL FLEET MANAGEMENT -1,077,488.64 -1,435,390.00 -2,013,540.00 -1,846,747.53 -1,435,390.00 -780,080.00 -61.3% TOTAL FLEET MANAGEMENT -1,077,488.64 -1,435,390.00 -2,013,540.00 -1,846,747.53 -1,435,390.00 -780,080.00 -61.3%

Page 72 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
INFORMATION SYSTEMS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7530000 INFORMATION SYSTEMS
7530000 4125 PEG FEES -145,482.13 -132,820.00 -132,820.00 -31,423.90 -132,820.00 .00 -100.0% 7530000 4125 14020 PEG FEES .00 .00 .00 -41,585.31 -130,000.00 -130,000.00 .0% 7530000 4669 UD-INFO SY -1,835,380.00 -2,372,860.00 -2,372,860.00 -2,175,184.00 -2,372,860.00 -2,697,970.00 13.7% 7530000 4801 INT INCOME -15,522.66 .00 .00 -3,532.17 .00 .00 .0% 7530000 4970 TRNSFR IN -266,209.00 .00 -740,000.00 -740,000.00 .00 .00 -100.0% 7530000 4970 16110 TRNSFR IN -11,579.92 .00 .00 .00 .00 .00 .0% 7530000 4970 16111 TRNSFR IN -711.38 .00 .00 .00 .00 .00 .0%

TOTAL INFORMATION SYSTEMS -2,274,885.09 -2,505,680.00 -3,245,680.00 -2,991,725.38 -2,635,680.00 -2,827,970.00 -12.9% ____________________________________________
7531401 INFORMATION SYSTEMS
7531401 4909 OTHER REV .00 .00 .00 -2,784.00 .00 .00 .0%

TOTAL INFORMATION SYSTEMS .00 .00 .00 -2,784.00 .00 .00 .0% TOTAL INFORMATION SYSTEMS -2,274,885.09 -2,505,680.00 -3,245,680.00 -2,994,509.38 -2,635,680.00 -2,827,970.00 -12.9%

Page 73 of 214 ends

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

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

ACCOUNTS FOR:
2021 2022 2022 2022 2022 2023 PCT
BUILDING MAINT & OPERATIONS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7540000 BUILDING MAINT & OPERATIONS
7540000 4670 UD-BLDG MT -929,710.00 -1,127,220.00 -1,127,220.00 -1,033,285.00 -1,127,220.00 -995,340.00 -11.7% 7540000 4801 INT INCOME -9,920.07 .00 .00 -2,040.75 .00 .00 .0% 7540000 4909 OTHER REV -300.00 .00 .00 .00 .00 .00 .0% 7540000 4970 16110 TRNSFR IN -6,558.65 .00 .00 .00 .00 .00 .0% 7540000 4970 16111 TRNSFR IN -3,502.98 .00 .00 .00 .00 .00 .0%

TOTAL BUILDING MAINT & OPERA -949,991.70 -1,127,220.00 -1,127,220.00 -1,035,325.75 -1,127,220.00 -995,340.00 -11.7% TOTAL BUILDING MAINT & OPERA -949,991.70 -1,127,220.00 -1,127,220.00 -1,035,325.75 -1,127,220.00 -995,340.00 -11.7%

Page 74 of 214 ends

05/02/2022 12:03 |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
UAL AND EMPLOYEE BENEFITS ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
7550000 UAL AND EMPLOYEE BENEFITS
7550000 4680 UD-OPEB .00 -10,168,860.00 -10,226,640.00 -9,321,510.00 -10,226,640.00 -7,583,450.00 -25.8% 7550000 4970 TRNSFR IN .00 .00 -125,000.00 -125,000.00 -125,000.00 .00 -100.0%

TOTAL UAL AND EMPLOYEE BENEF .00 -10,168,860.00 -10,351,640.00 -9,446,510.00 -10,351,640.00 -7,583,450.00 -26.7% TOTAL UAL AND EMPLOYEE BENEF .00 -10,168,860.00 -10,351,640.00 -9,446,510.00 -10,351,640.00 -7,583,450.00 -26.7%

Page 75 of 214 ends

05/02/2022 12:03 |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
SUCCESSOR AGENCY ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION City Mgr CHANGE ____________________________________________________________________________________________________________________________________ ____________________________________________
8050000 SUCCESSOR AGENCY
8050000 4430 SA ADM ALW -172,885.00 -250,000.00 -250,000.00 -125,000.00 -250,000.00 -250,000.00 .0% 8050000 4431 SA RPTTF -3,048,857.00 -3,141,660.00 -3,141,660.00 -357,964.00 -3,141,660.00 -3,123,160.00 -.6% 8050000 4801 INT INCOME -1,132.86 -17,300.00 -17,300.00 -87.69 -125.00 -1,000.00 -94.2% 8050000 4891 SA LN INT -8,551.56 .00 .00 .00 .00 .00 .0% 8050000 4892 SA LN PR -18,750.00 .00 .00 .00 .00 .00 .0% 8050000 4908 MISC REIMB -250.00 .00 .00 .00 .00 .00 .0% 8050000 4909 OTHER REV .00 .00 .00 -.11 .00 .00 .0%

TOTAL SUCCESSOR AGENCY -3,250,426.42 -3,408,960.00 -3,408,960.00 -483,051.80 -3,391,785.00 -3,374,160.00 -1.0% TOTAL SUCCESSOR AGENCY -3,250,426.42 -3,408,960.00 -3,408,960.00 -483,051.80 -3,391,785.00 -3,374,160.00 -1.0%

TOTAL REVENUE-142,872,963.54-149,567,200.00-156,518,591.39-129,382,755.37-161,354,819.00-145,797,510.00 -6.8% TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .0%

GRAND TOTAL -142,872,963.54-149,567,200.00-156,518,591.39-129,382,755.37-161,354,819.00-145,797,510.00 -6.8%

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

Page 76 of 214 ends

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

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

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

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

Report type:1
Budget level: 4
Percentage change calculation method:1
Print first or second year of budget requests:F
Print revenue as credit:Y
Include cfwd in rev bud:N
Include cfwd in actuals:N
Print totals only:N
Include segment code:N
Include report grand totals by account type:Y
Print full GL account:N
Double space:N
Suppress zero bdgt accts:Y
Print as worksheet:N
Print percent change or comment:P
Print text:N
Amounts/totals exceed 999 million dollars:N
Print five budget levels:N
Report view:F

Find Criteria
Field Name Field Value

Org *
Object 4*
Project
Account type
Account status

Page 77 of 214 ends

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

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

TOTAL GENERAL FUND 1,889,509.00 200,000.00 2,283,150.00 2,283,150.00 175,000.00 240,000.00 -89.5% ____________________________________________
1011101 CITY COUNCIL
1011101 5111 SALARY-FT 31,308.70 29,290.00 29,290.00 30,272.38 36,910.00 48,560.00 65.8% 1011101 5111 16110 SALARY-FT 14.97 .00 .00 .00 .00 .00 .0% 1011101 5112 SALARY-PT .00 .00 .00 .00 .00 1,860.00 .0% 1011101 5116 FRINGE BEN 3,377.31 3,860.00 3,860.00 2,861.52 3,540.00 10,170.00 163.5% 1011101 5116 16110 FRINGE BEN 5.09 .00 .00 .00 .00 .00 .0% 1011101 5116 50105 FRINGE BEN -.06 .00 .00 .00 .00 .00 .0% 1011101 5117 RETIR CNTR 1,097.51 1,110.00 1,110.00 941.49 1,140.00 3,270.00 194.6% 1011101 5117 16110 RETIR CNTR 1.74 .00 .00 .00 .00 .00 .0% 1011101 5119 UAL PERS 3,395.17 .00 .00 .00 .00 .00 .0% 1011101 5119 16110 UAL PERS 4.83 .00 .00 .00 .00 .00 .0% 1011101 5211 POSTAGE .00 30.00 30.00 .00 30.00 30.00 .0% 1011101 5212 ADVERTISNG .00 2,050.00 2,500.00 .00 2,500.00 3,850.00 54.0% 1011101 5213 DUES&SUBSC 48,690.21 56,340.00 57,540.00 56,725.11 57,540.00 58,510.00 1.7% 1011101 5215 TRNG/CONF 2,440.72 15,650.00 13,780.00 4,486.66 4,340.00 15,650.00 13.6% 1011101 5216 OFFIC SUPP 160.87 500.00 500.00 66.61 500.00 500.00 .0% 1011101 5217 OTHER SUPP 2,215.72 3,000.00 3,220.00 2,737.24 3,220.00 3,000.00 -6.8% 1011101 5222 PRINTING 249.98 170.00 170.00 84.04 170.00 570.00 235.3% 1011101 5258 OTHER SVS 405.01 2,200.00 2,200.00 3,250.00 1,750.00 3,580.00 62.7% 1011101 5297 OTHR EXP .00 .00 .00 107.58 .00 .00 .0% 1011101 5321 EMPL INCEN 27.72 .00 .00 .00 .00 .00 .0% 1011101 5701 INFO SYS .00 4,000.00 4,000.00 3,663.00 4,000.00 4,000.00 .0%

TOTAL CITY COUNCIL 93,395.49 118,200.00 118,200.00 105,195.63 115,640.00 153,550.00 29.9% ____________________________________________
1011104 CITY TREASURER
1011104 5111 SALARY-FT 1,050.00 1,350.00 1,350.00 2,000.00 2,600.00 2,400.00 77.8% 1011104 5116 FRINGE BEN 15.88 120.00 120.00 30.57 40.00 150.00 25.0% 1011104 5213 DUES&SUBSC 95.00 100.00 100.00 .00 .00 100.00 .0% 1011104 5215 TRNG/CONF .00 300.00 300.00 .00 300.00 300.00 .0% 1011104 5222 PRINTING .00 100.00 100.00 .00 100.00 .00 -100.0% 1011104 5258 OTHER SVS 127.50 .00 .00 .00 .00 .00 .0% 1011104 5271 INS PREM 100.00 120.00 120.00 100.00 110.00 .00 -100.0%

TOTAL CITY TREASURER 1,388.38 2,090.00 2,090.00 2,130.57 3,150.00 2,950.00 41.1% ____________________________________________
1011201 CITY ADMINISTRATION
1011201 5110 BUY BACKS 17,606.33 18,200.00 18,200.00 11,219.60 11,220.00 11,800.00 -35.2%

Page 78 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 2
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 ____________________________________________________________________________________________________________________________________ 1011201 5111 SALARY-FT 191,363.57 108,300.00 117,163.00 194,993.77 61,770.00 127,800.00 9.1% 1011201 5111 16110 SALARY-FT 386.24 .00 .00 .00 .00 .00 .0% 1011201 5111 16111 SALARY-FT 461.40 .00 .00 .00 .00 .00 .0% 1011201 5111 16125 SALARY-FT 1,463.32 .00 .00 .00 .00 .00 .0% 1011201 5111 50105 SALARY-FT 75.48 .00 .00 .00 .00 .00 .0% 1011201 5112 SALARY-PT .00 .00 .00 .00 .00 5,590.00 .0% 1011201 5116 FRINGE BEN 24,134.08 18,310.00 21,328.00 16,916.22 13,700.00 23,990.00 12.5% 1011201 5116 16110 FRINGE BEN 79.55 .00 .00 .00 .00 .00 .0% 1011201 5116 16111 FRINGE BEN 81.93 .00 .00 .00 .00 .00 .0% 1011201 5116 16125 FRINGE BEN 346.65 .00 .00 .00 .00 .00 .0% 1011201 5116 50105 FRINGE BEN 14.99 .00 .00 .00 .00 .00 .0% 1011201 5117 RETIR CNTR 10,946.62 11,100.00 12,022.00 7,626.80 6,030.00 10,340.00 -14.0% 1011201 5117 16110 RETIR CNTR 40.95 .00 .00 .00 .00 .00 .0% 1011201 5117 16111 RETIR CNTR 47.15 .00 .00 .00 .00 .00 .0% 1011201 5117 16125 RETIR CNTR 157.53 .00 .00 .00 .00 .00 .0% 1011201 5117 50105 RETIR CNTR 7.68 .00 .00 .00 .00 .00 .0% 1011201 5119 UAL PERS 48,349.14 .00 .00 .00 .00 .00 .0% 1011201 5119 16110 UAL PERS 124.56 .00 .00 .00 .00 .00 .0% 1011201 5119 16111 UAL PERS 148.80 .00 .00 .00 .00 .00 .0% 1011201 5119 16125 UAL PERS 471.87 .00 .00 .00 .00 .00 .0% 1011201 5119 50105 UAL PERS 24.34 .00 .00 .00 .00 .00 .0% 1011201 5210 CM CONT .00 87,000.00 87,000.00 .00 15,000.00 75,000.00 -13.8% 1011201 5210 16110 CM CONT 125.70 .00 .00 .00 .00 .00 .0% 1011201 5211 POSTAGE 4,931.89 6,500.00 6,500.00 4,892.80 6,000.00 6,500.00 .0% 1011201 5212 ADVERTISNG .00 7,200.00 7,200.00 .00 1,500.00 7,200.00 .0% 1011201 5213 DUES&SUBSC 1,069.40 5,680.00 5,680.00 1,873.40 3,820.00 5,340.00 -6.0% 1011201 5215 TRNG/CONF 1,107.95 13,900.00 13,900.00 4,181.52 10,000.00 13,900.00 .0% 1011201 5216 OFFIC SUPP 239.87 1,000.00 1,000.00 262.78 950.00 1,000.00 .0% 1011201 5216 16110 OFFIC SUPP 130.35 .00 .00 .00 .00 .00 .0% 1011201 5217 OTHER SUPP 3,026.44 22,700.00 21,500.00 65.59 900.00 22,700.00 5.6% 1011201 5217 16110 OTHER SUPP 9,878.70 .00 .00 .00 .00 .00 .0% 1011201 5219 PERM/LC/FE 8,000.00 .00 .00 .00 .00 .00 .0% 1011201 5222 PRNT/MAIL 97.63 400.00 400.00 165.90 150.00 400.00 .0% 1011201 5223 INFO SYS 13,470.00 .00 .00 .00 .00 .00 .0% 1011201 5231 FURN&OFFC .00 .00 1,200.00 .00 1,200.00 1,200.00 .0% 1011201 5233 OTHR EQUIP .00 .00 .00 32.31 .00 .00 .0% 1011201 5234 16110 OTH EQ RNT 25,591.81 .00 .00 .00 .00 .00 .0% 1011201 5234 16111 OTH EQ RNT 9,057.05 .00 .00 .00 .00 .00 .0% 1011201 5252 PROF SVS 7,760.00 135,000.00 118,000.00 89,500.00 100,000.00 73,000.00 -38.1% 1011201 5253 CONTRC SVS 54,937.50 241,000.00 166,000.00 147,576.88 142,280.00 185,000.00 11.4% 1011201 5258 OTHER SVS 13,081.31 20,000.00 20,000.00 15,925.17 20,370.00 20,500.00 2.5% 1011201 5258 16111 OTHER SVS 200.00 .00 .00 .00 .00 .00 .0% 1011201 5258 20611 OTHER SVS 921.57 .00 .00 .00 .00 .00 .0% 1011201 5271 INS PREM 100.00 300.00 300.00 103.50 250.00 300.00 .0%

Page 79 of 214 ends

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

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

TOTAL CITY ADMINISTRATION 486,359.35 796,150.00 716,953.00 582,956.24 491,200.00 726,190.00 1.3% ____________________________________________
1011301 ACCOUNTING SERVICES
1011301 5110 BUY BACKS 10,192.07 10,500.00 10,500.00 6,716.05 6,720.00 7,100.00 -32.4% 1011301 5111 SALARY-FT 420,366.65 479,250.00 485,581.00 351,507.40 443,840.00 486,940.00 .3% 1011301 5111 50105 SALARY-FT 1.60 .00 .00 .00 .00 .00 .0% 1011301 5112 SALARY-PT 5,638.16 20,100.00 20,100.00 7,424.31 10,370.00 20,100.00 .0% 1011301 5113 OVERTIME 4,659.61 15,000.00 15,000.00 2,463.38 5,000.00 15,000.00 .0% 1011301 5114 CATASTR LV .00 .00 .00 20,412.23 .00 .00 .0% 1011301 5116 FRINGE BEN 95,090.85 122,130.00 124,286.00 79,930.87 97,120.00 126,120.00 1.5% 1011301 5116 50105 FRINGE BEN .44 .00 .00 .00 .00 .00 .0% 1011301 5117 RETIR CNTR 47,547.40 51,950.00 52,609.00 37,175.71 45,300.00 55,480.00 5.5% 1011301 5117 50105 RETIR CNTR .19 .00 .00 .00 .00 .00 .0% 1011301 5119 UAL PERS 155,226.67 .00 .00 .00 .00 .00 .0% 1011301 5119 50105 UAL PERS .52 .00 .00 .00 .00 .00 .0% 1011301 5211 POSTAGE 9.22 100.00 100.00 .00 100.00 100.00 .0% 1011301 5212 ADVERTISNG 331.52 .00 .00 566.88 .00 .00 .0% 1011301 5213 DUES&SUBSC 1,595.00 2,000.00 3,580.00 2,465.00 3,580.00 3,600.00 .6% 1011301 5215 TRNG/CONF 550.00 9,340.00 9,340.00 884.80 5,790.00 11,060.00 18.4% 1011301 5216 OFFIC SUPP 1,175.05 1,650.00 1,970.00 474.39 1,970.00 1,970.00 .0% 1011301 5217 OTHER SUPP 421.86 .00 .00 85.22 .00 .00 .0% 1011301 5218 UNIFRM EXP 88.58 230.00 230.00 181.69 200.00 200.00 -13.0% 1011301 5219 PERM/LC/FE 6,000.00 500.00 500.00 250.00 500.00 .00 -100.0% 1011301 5220 FUEL USAGE 368.53 600.00 610.00 251.59 610.00 600.00 -1.6% 1011301 5221 MILE REIMB .00 500.00 500.00 20.58 100.00 500.00 .0% 1011301 5222 PRNT/MAIL 804.67 820.00 1,010.00 889.39 1,010.00 1,200.00 18.8% 1011301 5223 INFO SYS 52,860.00 .00 .00 .00 .00 .00 .0% 1011301 5231 FURN&OFFC .00 .00 .00 6,591.57 6,460.00 .00 .0% 1011301 5232 COMP EQUIP 1,061.44 .00 .00 .00 .00 .00 .0% 1011301 5233 OTHR EQUIP 17.55 .00 .00 .00 5,000.00 5,000.00 .0% 1011301 5243 UTL-TELEPH 80.79 .00 .00 100.47 .00 .00 .0% 1011301 5251 LEGAL SVS 390.00 .00 .00 2,593.02 .00 .00 .0%

Page 80 of 214 ends

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

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

TOTAL ACCOUNTING SERVICES 1,320,121.87 1,476,690.00 1,460,240.00 1,036,409.32 1,336,550.00 1,541,580.00 5.6% ____________________________________________
1011302 MAIL/PRINTING SERVICES
1011302 5211 POSTAGE 25,000.00 37,700.00 37,700.00 20,000.00 37,700.00 37,700.00 .0% 1011302 5216 OFFIC SUPP 4,389.94 17,620.00 17,620.00 17,704.36 14,300.00 17,620.00 .0% 1011302 5220 FUEL USAGE 11.15 100.00 100.00 46.55 100.00 100.00 .0% 1011302 5223 INFO SYS 4,230.00 .00 .00 .00 .00 .00 .0% 1011302 5224 VEH CHRG 1,740.00 .00 .00 .00 .00 .00 .0% 1011302 5231 FURN&OFFC 1,499.88 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 1011302 5232 COMP EQUIP 53.86 .00 .00 .00 .00 .00 .0% 1011302 5234 OTH EQ RNT 1,863.36 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 .0% 1011302 5258 OTHER SVS 2,976.02 4,150.00 4,150.00 3,632.70 4,150.00 4,220.00 1.7% 1011302 5701 INFO SYS .00 4,230.00 4,230.00 3,883.00 4,230.00 3,680.00 -13.0% 1011302 5702 FLT-MT&RP .00 1,990.00 1,990.00 1,793.00 1,960.00 2,660.00 33.7% 1011302 5703 VEH ACQ .00 250.00 250.00 231.00 250.00 .00 -100.0%

TOTAL MAIL/PRINTING SERVICES 41,764.21 69,040.00 69,040.00 49,290.61 65,690.00 68,980.00 -.1% ____________________________________________
1011504 NON-DEPARTMENTAL
1011504 5111 SALARY-FT .00 -1,082,960.00 -2,282,960.00 .00 .00 517,280.00 -122.7% 1011504 5116 FRINGE BEN .00 .00 .00 .00 .00 -1,168,170.00 .0% 1011504 5117 RETIR CNTR 38,632.60 31,000.00 31,000.00 37,636.35 30,550.00 30,550.00 -1.5% 1011504 5119 UAL PERS .00 .00 .00 .00 .00 1,169,810.00 .0%

Page 81 of 214 ends

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

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

TOTAL NON-DEPARTMENTAL 3,853,616.03 2,160,470.00 1,495,370.00 2,583,461.76 3,777,850.00 6,216,320.00 315.7% ____________________________________________
1011510 LIBRARY
1011510 5117 RETIR CNTR .00 .00 57,100.00 57,086.29 57,100.00 .00 -100.0% 1011510 5223 INFO SYS 124,710.00 .00 .00 .00 .00 .00 .0% 1011510 5225 BLDG MT&OP 117,600.00 .00 .00 .00 .00 .00 .0% 1011510 5231 FURN&OFFC 4,190.95 .00 .00 .00 .00 .00 .0% 1011510 5233 OTHR EQUIP 15,428.69 .00 .00 .00 .00 .00 .0% 1011510 5241 UTL-ELECTR 53,319.45 45,000.00 45,000.00 54,335.08 45,000.00 74,000.00 64.4% 1011510 5242 UTL-GAS 8,965.88 6,700.00 6,700.00 6,523.17 6,700.00 9,000.00 34.3% 1011510 5244 UTL-WATER .00 .00 .00 .00 .00 17,720.00 .0% 1011510 5253 CONTRC SVS 973,338.00 1,021,810.00 1,286,388.00 1,286,387.99 1,286,390.00 1,387,980.00 7.9% 1011510 5255 BANKNG SVS 380.35 800.00 800.00 255.44 800.00 .00 -100.0% 1011510 5258 OTHER SVS .00 7,500.00 7,500.00 .00 .00 7,500.00 .0% 1011510 5261 BK&DIG MAT 114,761.04 52,500.00 114,636.00 114,635.95 96,290.00 165,580.00 44.4% 1011510 5528 IMPRV BLD 59,783.21 .00 7,371.00 5,291.00 7,371.00 .00 -100.0% 1011510 5530 MACH&EQUIP 19,017.00 .00 .00 .00 .00 .00 .0% 1011510 5701 INFO SYS .00 158,410.00 158,410.00 145,211.00 158,410.00 150,430.00 -5.0% 1011510 5704 BDG MT ALC .00 75,320.00 75,320.00 69,047.00 75,320.00 106,210.00 41.0%

TOTAL LIBRARY 1,491,494.57 1,368,040.00 1,759,225.00 1,738,772.92 1,733,381.00 1,918,420.00 9.0% ____________________________________________
1011601 HUMAN RESOURCES
1011601 5110 BUY BACKS 1,856.36 1,920.00 1,920.00 3,286.70 3,290.00 3,460.00 80.2%

Page 82 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 6
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 ____________________________________________________________________________________________________________________________________ 1011601 5111 SALARY-FT 121,859.71 126,590.00 126,590.00 107,205.28 133,340.00 134,320.00 6.1% 1011601 5111 16110 SALARY-FT 1,495.41 .00 .00 .00 .00 .00 .0% 1011601 5111 16111 SALARY-FT 1,219.26 .00 .00 .00 .00 .00 .0% 1011601 5111 50105 SALARY-FT 75.48 .00 .00 .00 .00 .00 .0% 1011601 5112 SALARY-PT 7,385.93 .00 .00 .00 .00 .00 .0% 1011601 5116 FRINGE BEN 29,693.06 32,220.00 32,220.00 25,672.71 31,830.00 33,920.00 5.3% 1011601 5116 16110 FRINGE BEN 184.24 .00 .00 .00 .00 .00 .0% 1011601 5116 16111 FRINGE BEN 193.40 .00 .00 .00 .00 .00 .0% 1011601 5116 50105 FRINGE BEN 14.99 .00 .00 .00 .00 .00 .0% 1011601 5117 RETIR CNTR 13,213.33 13,130.00 13,130.00 10,340.05 12,750.00 14,650.00 11.6% 1011601 5117 16110 RETIR CNTR 152.03 .00 .00 .00 .00 .00 .0% 1011601 5117 16111 RETIR CNTR 123.96 .00 .00 .00 .00 .00 .0% 1011601 5117 50105 RETIR CNTR 7.68 .00 .00 .00 .00 .00 .0% 1011601 5119 UAL PERS 50,555.00 .00 .00 .00 .00 .00 .0% 1011601 5119 16110 UAL PERS 482.21 .00 .00 .00 .00 .00 .0% 1011601 5119 16111 UAL PERS 393.18 .00 .00 .00 .00 .00 .0% 1011601 5119 50105 UAL PERS 24.34 .00 .00 .00 .00 .00 .0% 1011601 5205 RECRUIT 1,232.59 5,000.00 5,000.00 1,968.56 5,000.00 8,700.00 74.0% 1011601 5211 POSTAGE 26.51 150.00 150.00 7.68 50.00 150.00 .0% 1011601 5213 DUES&SUBSC 9,634.53 7,030.00 7,030.00 6,029.82 7,030.00 9,610.00 36.7% 1011601 5215 TRNG/CONF 799.00 7,700.00 6,130.00 664.31 4,000.00 9,500.00 55.0% 1011601 5216 OFFIC SUPP 1,502.93 3,500.00 3,500.00 1,223.71 3,500.00 3,500.00 .0% 1011601 5216 16110 OFFIC SUPP 108.73 .00 .00 .00 .00 .00 .0% 1011601 5217 OTHER SUPP 2,301.30 3,000.00 3,000.00 1,801.69 3,000.00 2,000.00 -33.3% 1011601 5218 UNIFRM EXP 290.90 300.00 300.00 .00 300.00 300.00 .0% 1011601 5219 PERM/LC/FE 6,000.00 .00 .00 .00 .00 .00 .0% 1011601 5221 MILE REIMB .00 300.00 300.00 .00 300.00 300.00 .0% 1011601 5222 PRNT/MAIL .00 200.00 200.00 84.05 .00 200.00 .0% 1011601 5223 INFO SYS 41,750.00 .00 .00 .00 .00 .00 .0% 1011601 5231 FURN&OFFC 1,348.78 .00 .00 98.09 .00 2,500.00 .0% 1011601 5232 COMP EQUIP 60.32 .00 1,440.00 1,438.46 1,438.46 .00 -100.0% 1011601 5233 OTHR EQUIP .00 .00 130.00 129.29 130.00 .00 -100.0% 1011601 5251 LEGAL SVS 150.00 .00 .00 .00 .00 .00 .0% 1011601 5252 PROF SVS 25,163.50 26,000.00 26,000.00 2,000.00 26,000.00 17,600.00 -32.3% 1011601 5258 OTHER SVS 108,663.54 97,400.00 97,400.00 87,373.22 97,400.00 101,950.00 4.7% 1011601 5273 WK CMP CHG 14,790.00 .00 .00 .00 .00 .00 .0% 1011601 5274 UNEMPL CHG 500.00 .00 .00 .00 .00 .00 .0% 1011601 5275 LT DIS CHG 960.00 .00 .00 .00 .00 .00 .0% 1011601 5276 LIAB CHG 18,780.00 .00 .00 .00 .00 .00 .0% 1011601 5277 LOSS PREV 960.00 .00 .00 .00 .00 .00 .0% 1011601 5290 LATE CHARG 500.00 .00 .00 .00 .00 .00 .0% 1011601 5321 EMPL INCEN 5,820.12 .00 .00 .00 .00 .00 .0% 1011601 5701 INFO SYS .00 39,810.00 39,810.00 36,498.00 39,810.00 42,520.00 6.8% 1011601 5705 SF LIAB .00 31,420.00 31,420.00 28,809.00 31,420.00 34,600.00 10.1%

Page 83 of 214 ends

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

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

TOTAL HUMAN RESOURCES 470,272.32 439,060.00 439,060.00 354,340.62 443,978.46 471,860.00 7.5% ____________________________________________
1011603 CITY ATTORNEY
1011603 5251 LEGAL SVS 539,685.57 500,000.00 500,000.00 401,705.00 550,000.00 500,000.00 .0% 1011603 5251 50105 LEGAL SVS 82,237.06 .00 .00 .00 .00 .00 .0%

TOTAL CITY ATTORNEY 621,922.63 500,000.00 500,000.00 401,705.00 550,000.00 500,000.00 .0% ____________________________________________
1011701 CITY CLERK
1011701 5110 BUY BACKS 2,583.37 2,670.00 2,670.00 2,768.43 2,770.00 2,910.00 9.0% 1011701 5111 SALARY-FT 136,227.44 164,530.00 164,530.00 113,053.59 139,840.00 178,000.00 8.2% 1011701 5111 16110 SALARY-FT 266.70 .00 .00 .00 .00 .00 .0% 1011701 5111 16111 SALARY-FT 444.48 .00 .00 .00 .00 .00 .0% 1011701 5111 16125 SALARY-FT 43.06 .00 .00 .00 .00 .00 .0% 1011701 5111 50105 SALARY-FT 240.67 .00 .00 .00 .00 .00 .0% 1011701 5113 OVERTIME 688.99 2,670.00 2,670.00 1,212.51 1,450.00 2,670.00 .0% 1011701 5113 16110 OVERTIME 707.96 .00 .00 .00 .00 .00 .0% 1011701 5113 16111 OVERTIME 252.56 .00 .00 .00 .00 .00 .0% 1011701 5113 50105 OVERTIME 290.13 .00 .00 .00 .00 .00 .0% 1011701 5116 FRINGE BEN 30,795.35 44,020.00 44,020.00 23,714.76 29,300.00 46,040.00 4.6% 1011701 5116 16110 FRINGE BEN 172.44 .00 .00 .00 .00 .00 .0% 1011701 5116 16111 FRINGE BEN 112.14 .00 .00 .00 .00 .00 .0% 1011701 5116 16125 FRINGE BEN 10.94 .00 .00 .00 .00 .00 .0% 1011701 5116 50105 FRINGE BEN 114.55 .00 .00 .00 .00 .00 .0% 1011701 5117 RETIR CNTR 15,234.51 17,080.00 17,080.00 11,325.55 13,920.00 19,430.00 13.8% 1011701 5117 16110 RETIR CNTR 27.12 .00 .00 .00 .00 .00 .0% 1011701 5117 16111 RETIR CNTR 45.19 .00 .00 .00 .00 .00 .0% 1011701 5117 16125 RETIR CNTR 4.98 .00 .00 .00 .00 .00 .0% 1011701 5117 50105 RETIR CNTR 26.80 .00 .00 .00 .00 .00 .0% 1011701 5119 UAL PERS 37,804.84 .00 .00 .00 .00 .00 .0% 1011701 5119 16110 UAL PERS 86.00 .00 .00 .00 .00 .00 .0% 1011701 5119 16111 UAL PERS 143.34 .00 .00 .00 .00 .00 .0% 1011701 5119 16125 UAL PERS 13.89 .00 .00 .00 .00 .00 .0% 1011701 5119 50105 UAL PERS 63.35 .00 .00 .00 .00 .00 .0% 1011701 5211 POSTAGE .00 .00 .00 8.06 .00 .00 .0% 1011701 5212 ADVERTISNG 15,218.35 18,000.00 33,000.00 33,000.00 30,000.00 20,000.00 -39.4% 1011701 5212 50105 ADVERTISNG 9,430.73 .00 .00 .00 .00 .00 .0% 1011701 5213 DUES&SUBSC 330.00 590.00 830.00 820.22 830.00 850.00 2.4% 1011701 5215 TRNG/CONF 1,955.00 3,000.00 3,000.00 1,264.15 3,000.00 3,000.00 .0%

Page 84 of 214 ends

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

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

TOTAL CITY CLERK 492,543.86 416,250.00 481,700.00 385,913.62 434,600.00 603,850.00 25.4% ____________________________________________
1012201 BUILDING AND SAFETY
1012201 5110 BUY BACKS 9,040.40 11,740.00 11,740.00 12,176.30 12,180.00 15,300.00 30.3% 1012201 5111 SALARY-FT 174,171.66 215,650.00 215,650.00 165,951.76 221,600.00 324,270.00 50.4% 1012201 5112 SALARY-PT .00 3,610.00 3,610.00 3,015.03 .00 3,610.00 .0% 1012201 5113 OVERTIME 17,503.62 16,500.00 16,500.00 14,154.32 20,000.00 20,000.00 21.2% 1012201 5113 40155 OVERTIME .00 .00 .00 339.16 .00 .00 .0% 1012201 5116 FRINGE BEN 47,794.95 53,550.00 53,550.00 39,090.11 51,820.00 79,460.00 48.4% 1012201 5116 40155 FRINGE BEN .00 .00 .00 64.03 .00 .00 .0% 1012201 5117 RETIR CNTR 19,592.92 22,300.00 22,300.00 15,809.76 20,410.00 34,850.00 56.3% 1012201 5119 UAL PERS 70,737.95 .00 .00 .00 .00 .00 .0% 1012201 5213 DUES&SUBSC 822.83 2,100.00 1,100.00 295.00 500.00 4,630.00 320.9% 1012201 5215 TRNG/CONF 780.00 2,000.00 1,000.00 780.00 780.00 4,000.00 300.0% 1012201 5216 OFFIC SUPP 1,891.54 2,200.00 2,200.00 1,113.09 2,200.00 2,200.00 .0% 1012201 5217 OTHER SUPP 350.75 1,000.00 1,000.00 780.43 1,000.00 1,000.00 .0% 1012201 5218 UNIFRM EXP 871.48 1,000.00 1,000.00 247.26 1,000.00 1,000.00 .0% 1012201 5220 FUEL USAGE 2,607.69 4,000.00 4,000.00 1,133.73 4,000.00 4,000.00 .0% 1012201 5221 MILE REIMB .00 .00 150.00 .00 150.00 150.00 .0% 1012201 5222 PRNT/MAIL 63.57 150.00 150.00 42.02 150.00 150.00 .0% 1012201 5223 INFO SYS 91,590.00 .00 .00 .00 .00 .00 .0% 1012201 5224 VEH CHRG 12,740.00 .00 .00 .00 .00 .00 .0%

Page 85 of 214 ends

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

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

TOTAL BUILDING AND SAFETY 953,108.45 1,197,600.00 1,238,600.00 1,065,084.41 1,201,130.00 1,539,440.00 24.3% ____________________________________________
1012202 WEED ABATEMENT
1012202 5112 SALARY-PT 12,325.50 32,330.00 12,330.00 137.73 140.00 .00 -100.0% 1012202 5116 FRINGE BEN 178.72 470.00 470.00 2.00 5.00 .00 -100.0% 1012202 5213 DUES&SUBSC .00 .00 8,980.00 8,974.00 8,980.00 5,760.00 -35.9% 1012202 5220 FUEL USAGE 89.08 200.00 138.00 63.30 65.00 100.00 -27.5% 1012202 5221 MILE REIMB .00 .00 399.00 .00 .00 .00 -100.0% 1012202 5222 PRINTING 1,173.72 1,300.00 1,300.00 978.83 1,300.00 1,300.00 .0% 1012202 5224 VEH CHRG 730.00 .00 .00 .00 .00 .00 .0% 1012202 5233 OTHR EQUIP .00 .00 1,310.00 1,054.21 1,060.00 .00 -100.0% 1012202 5243 UTL-TELEPH 148.78 650.00 280.00 70.69 280.00 500.00 78.6% 1012202 5253 CONTRC SVS .00 .00 44,000.00 44,000.00 44,000.00 44,000.00 .0% 1012202 5258 OTHER SVS .00 40,000.00 40,242.00 40,000.00 40,000.00 40,000.00 -.6% 1012202 5702 FLT-MT&RP .00 2,380.00 2,380.00 2,178.00 2,380.00 1,930.00 -18.9%

TOTAL WEED ABATEMENT 14,645.80 77,330.00 111,829.00 97,458.76 98,210.00 93,590.00 -16.3% ____________________________________________
1012203 ECONOMIC DEVELOPMENT
1012203 5111 SALARY-FT 53,188.57 74,710.00 74,710.00 59,327.04 72,680.00 74,690.00 .0% 1012203 5112 SALARY-PT .00 2,710.00 2,710.00 230.18 .00 2,710.00 .0% 1012203 5116 FRINGE BEN 18,766.23 19,410.00 19,410.00 15,017.31 18,600.00 19,430.00 .1% 1012203 5117 RETIR CNTR 6,102.94 7,760.00 7,760.00 6,181.73 7,570.00 8,160.00 5.2% 1012203 5119 UAL PERS 4,155.66 .00 .00 .00 .00 .00 .0%

Page 86 of 214 ends

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

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

TOTAL ECONOMIC DEVELOPMENT 203,592.69 293,710.00 328,710.00 261,902.31 302,770.00 336,910.00 2.5% ____________________________________________
1012204 PLANNING COMMISSION
1012204 5215 TRNG/CONF 1,000.00 5,000.00 6,200.00 513.34 6,200.00 6,500.00 4.8% 1012204 5216 OFFIC SUPP .00 500.00 500.00 .00 500.00 500.00 .0% 1012204 5217 OTHER SUPP 178.16 250.00 250.00 58.58 250.00 250.00 .0% 1012204 5222 PRINTING .00 300.00 300.00 42.03 300.00 300.00 .0% 1012204 5252 PROF SVS 4,200.00 4,000.00 4,000.00 1,500.00 4,000.00 4,000.00 .0% 1012204 5258 OTHER SVS 8,500.00 9,100.00 7,900.00 3,600.00 5,900.00 9,100.00 15.2%

TOTAL PLANNING COMMISSION 13,878.16 19,150.00 19,150.00 5,713.95 17,150.00 20,650.00 7.8% ____________________________________________
1012205 PLANNING
1012205 5110 BUY BACKS 2,340.41 .00 .00 2,387.21 2,390.00 .00 .0% 1012205 5111 SALARY-FT 155,445.23 265,370.00 302,398.00 168,255.81 181,660.00 307,970.00 1.8% 1012205 5111 50105 SALARY-FT 2.05 .00 .00 .00 .00 .00 .0% 1012205 5112 SALARY-PT 35,929.68 49,680.00 14,815.00 15,043.96 25,350.00 2,710.00 -81.7% 1012205 5113 OVERTIME 2,317.89 5,000.00 5,000.00 .00 .00 2,500.00 -50.0% 1012205 5116 FRINGE BEN 37,049.29 66,840.00 75,090.00 37,882.27 43,600.00 78,900.00 5.1% 1012205 5116 50105 FRINGE BEN .71 .00 .00 .00 .00 .00 .0% 1012205 5117 RETIR CNTR 19,929.37 30,150.00 31,266.00 17,872.02 20,050.00 33,250.00 6.3% 1012205 5117 50105 RETIR CNTR .24 .00 .00 .00 .00 .00 .0% 1012205 5119 UAL PERS 17,532.81 .00 .00 .00 .00 .00 .0%

Page 87 of 214 ends

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

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

TOTAL PLANNING 576,691.85 691,960.00 752,489.00 541,683.08 542,770.00 563,650.00 -25.1% ____________________________________________
1012207 SANTA FE DEPOT
1012207 5225 BLDG MT&OP 12,000.00 .00 .00 .00 .00 .00 .0% 1012207 5704 BDG MT ALC .00 8,000.00 8,000.00 7,337.00 8,000.00 6,000.00 -25.0%

TOTAL SANTA FE DEPOT 12,000.00 8,000.00 8,000.00 7,337.00 8,000.00 6,000.00 -25.0% ____________________________________________
1013201 POLICE ADMINISTRATION
1013201 5110 BUY BACKS 14,024.55 70,120.00 70,120.00 19,627.78 19,630.00 75,000.00 7.0% 1013201 5111 SALARY-FT 564,026.74 494,090.00 500,559.00 304,233.59 365,200.00 511,540.00 2.2% 1013201 5112 SALARY-PT 99,158.59 156,140.00 156,140.00 78,220.08 101,980.00 292,840.00 87.5% 1013201 5113 OVERTIME 19,715.01 16,900.00 16,900.00 40,595.69 63,230.00 57,350.00 239.3% 1013201 5113 16110 OVERTIME 4,764.56 .00 .00 .00 .00 .00 .0% 1013201 5113 16111 OVERTIME 3,214.76 .00 .00 .00 .00 .00 .0% 1013201 5116 FRINGE BEN 135,962.40 168,660.00 166,325.00 84,247.11 101,340.00 183,500.00 10.3% 1013201 5116 16110 FRINGE BEN 966.73 .00 .00 .00 .00 .00 .0% 1013201 5116 16111 FRINGE BEN 671.56 .00 .00 .00 .00 .00 .0% 1013201 5117 RETIR CNTR 54,414.96 51,360.00 50,261.00 30,993.99 35,780.00 55,810.00 11.0% 1013201 5119 UAL PERS 149,993.25 .00 .00 .00 .00 .00 .0% 1013201 5131 SAL-SW PD 206,115.14 422,730.00 422,730.00 372,805.39 431,250.00 1,491,320.00 252.8% 1013201 5131 16111 SAL-SW PD 8,174.49 .00 .00 .00 .00 .00 .0% 1013201 5136 FRG B-S PD 35,729.48 68,190.00 68,190.00 54,979.62 67,830.00 98,050.00 43.8% 1013201 5136 16111 FRG B-S PD 1,524.71 .00 .00 .00 .00 .00 .0% 1013201 5137 RT CNTR-PD 29,899.61 74,680.00 74,680.00 49,487.98 53,400.00 89,890.00 20.4% 1013201 5139 UAL PD SWR 2,770.00 .00 .00 .00 .00 .00 .0%

Page 88 of 214 ends

05/02/2022 12:10 |City of Upland, CA |P 12
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 ____________________________________________________________________________________________________________________________________ 1013201 5211 POSTAGE 290.57 1,150.00 1,150.00 775.93 920.00 1,150.00 .0% 1013201 5213 DUES&SUBSC 9,625.14 12,070.00 12,070.00 4,683.82 11,370.00 12,220.00 1.2% 1013201 5215 TRNG/CONF 79,340.58 97,400.00 83,400.00 48,600.76 83,200.00 97,380.00 16.8% 1013201 5216 OFFIC SUPP 14,651.04 16,700.00 16,700.00 16,414.60 16,250.00 18,010.00 7.8% 1013201 5217 OTHER SUPP 16,783.19 24,100.00 16,100.00 10,948.81 23,350.00 24,300.00 50.9% 1013201 5217 16110 OTHER SUPP 1,127.75 .00 .00 .00 .00 .00 .0% 1013201 5217 16111 OTHER SUPP 388.91 .00 .00 .00 .00 .00 .0% 1013201 5218 UNIFRM EXP 2,396.03 4,000.00 3,000.00 3,496.64 2,000.00 4,000.00 33.3% 1013201 5220 FUEL USAGE 11,003.62 13,000.00 15,240.00 10,010.50 15,240.00 17,520.00 15.0% 1013201 5222 PRNT/MAIL 1,107.14 1,650.00 1,650.00 1,717.93 1,650.00 1,950.00 18.2% 1013201 5223 INFO SYS 662,840.00 .00 .00 .00 .00 .00 .0% 1013201 5224 VEH CHRG 29,110.00 .00 .00 .00 .00 .00 .0% 1013201 5225 BLDG MT&OP 326,890.00 .00 .00 .00 .00 .00 .0% 1013201 5231 FURN&OFFC 1,738.05 14,500.00 14,320.00 123.04 14,000.00 14,500.00 1.3% 1013201 5232 COMP EQUIP 164.16 500.00 500.00 246.07 360.00 500.00 .0% 1013201 5232 16111 COMP EQUIP 429.91 .00 .00 .00 .00 .00 .0% 1013201 5233 OTHR EQUIP 8,655.02 6,090.00 45,490.00 47,461.20 47,830.00 12,410.00 -72.7% 1013201 5234 OTH EQ RNT 100.00 700.00 1,260.00 334.19 1,260.00 1,500.00 19.0% 1013201 5236 RENT 2,200.00 2,640.00 2,640.00 2,000.00 2,400.00 2,640.00 .0% 1013201 5241 UTL-ELECTR 69,896.95 78,780.00 83,570.00 69,103.01 83,570.00 88,250.00 5.6% 1013201 5242 UTL-GAS 11,784.18 2,430.00 20,430.00 19,839.36 19,700.00 18,100.00 -11.4% 1013201 5243 16110 UTL-TELEPH 106.68 .00 .00 .00 .00 .00 .0% 1013201 5244 UTL-WATER .00 .00 .00 .00 .00 25,360.00 .0% 1013201 5246 MAINT-EQP 159.00 1,900.00 900.00 .00 200.00 900.00 .0% 1013201 5247 MAINT-VEH 5,824.00 10,000.00 10,000.00 10,340.00 9,500.00 10,000.00 .0% 1013201 5251 LEGAL SVS 60,321.07 79,500.00 99,500.00 83,000.00 98,770.00 103,770.00 4.3% 1013201 5253 CONTRC SVS 165,035.33 302,000.00 291,371.00 279,801.80 289,430.00 307,500.00 5.5% 1013201 5255 BANKNG SVS 1,817.68 2,700.00 2,700.00 1,632.77 2,300.00 2,700.00 .0% 1013201 5258 OTHER SVS 211,637.40 235,040.00 252,860.00 232,913.01 252,860.00 244,040.00 -3.5% 1013201 5273 WK CMP CHG 1,014,530.00 .00 .00 .00 .00 .00 .0% 1013201 5274 UNEMPL CHG 34,200.00 .00 .00 .00 .00 .00 .0% 1013201 5275 LT DIS CHG 65,950.00 .00 .00 .00 .00 .00 .0% 1013201 5276 LIAB CHG 1,287,740.00 .00 .00 .00 .00 .00 .0% 1013201 5277 LOSS PREV 65,880.00 .00 .00 .00 .00 .00 .0% 1013201 5297 OTHR EXP .00 200.00 200.00 .00 100.00 200.00 .0% 1013201 5318 PREVENTION 7,049.81 .00 .00 .00 .00 .00 .0% 1013201 5319 NAVIGATION 7,049.82 .00 .00 .00 .00 .00 .0% 1013201 5701 INFO SYS .00 922,820.00 922,820.00 845,922.00 922,820.00 1,258,320.00 36.4% 1013201 5702 FLT-MT&RP .00 33,690.00 33,690.00 30,888.00 33,690.00 32,910.00 -2.3% 1013201 5703 VEH ACQ .00 165,000.00 165,000.00 151,250.00 165,000.00 145,000.00 -12.1% 1013201 5704 BDG MT ALC .00 273,820.00 273,820.00 250,998.00 273,820.00 326,210.00 19.1% 1013201 5705 SF LIAB .00 2,599,000.00 2,599,000.00 2,382,424.00 2,599,000.00 2,771,390.00 6.6% 1013201 5706 OPB&BN ALC .00 428,880.00 428,880.00 393,140.00 428,880.00 368,760.00 -14.0% 1013201 5707 PERSUALALC .00 4,008,530.00 4,008,530.00 3,674,440.00 4,008,530.00 2,111,360.00 -47.3%

Page 89 of 214 ends

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

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

TOTAL POLICE ADMINISTRATION 5,508,949.57 10,861,660.00 10,932,696.00 9,607,696.67 10,647,640.00 10,878,150.00 -.5% ____________________________________________
1013202 POLICE INVESTIGATIONS
1013202 5110 BUY BACKS 16,679.68 .00 .00 9,058.40 9,060.00 .00 .0% 1013202 5111 SALARY-FT 112,890.14 127,720.00 127,720.00 112,276.00 135,070.00 233,710.00 83.0% 1013202 5112 SALARY-PT .00 .00 .00 .00 .00 31,230.00 .0% 1013202 5113 OVERTIME 735.18 1,500.00 1,500.00 3,450.04 11,080.00 3,830.00 155.3% 1013202 5116 FRINGE BEN 34,147.99 38,100.00 38,100.00 24,649.95 29,410.00 73,560.00 93.1% 1013202 5116 16110 FRINGE BEN 18.18 .00 .00 .00 .00 .00 .0% 1013202 5116 16111 FRINGE BEN 53.98 .00 .00 .00 .00 .00 .0% 1013202 5117 RETIR CNTR 12,745.75 13,280.00 13,280.00 10,812.67 12,910.00 25,460.00 91.7% 1013202 5119 UAL PERS 53,275.02 .00 .00 .00 .00 .00 .0% 1013202 5131 SAL-SW PD 1,221,178.41 1,699,090.00 1,699,090.00 853,006.91 982,430.00 1,410,350.00 -17.0% 1013202 5131 16111 SAL-SW PD 51,307.68 .00 .00 .00 .00 .00 .0% 1013202 5133 OT-SW PD 47,464.06 138,000.00 138,000.00 138,773.91 138,880.00 167,420.00 21.3% 1013202 5133 16110 OT-SW PD 8,389.71 .00 .00 .00 .00 .00 .0% 1013202 5133 16111 OT-SW PD 6,286.37 .00 .00 .00 .00 .00 .0% 1013202 5133 32002 OT-SW PD .00 .00 .00 6,441.11 3,140.00 .00 .0% 1013202 5133 40155 OT-SW PD .00 .00 .00 20.10 .00 .00 .0% 1013202 5136 FRG B-S PD 203,136.89 311,650.00 311,650.00 145,623.72 169,310.00 254,310.00 -18.4% 1013202 5136 16110 FRG B-S PD 971.57 .00 .00 .00 .00 .00 .0% 1013202 5136 16111 FRG B-S PD 5,673.09 .00 .00 .00 .00 .00 .0% 1013202 5136 32002 FRG B-S PD .00 .00 .00 978.62 710.00 .00 .0% 1013202 5136 40155 FRG B-S PD .00 .00 .00 3.17 .00 .00 .0% 1013202 5137 RT CNTR-PD 188,048.70 281,950.00 281,950.00 131,209.38 145,750.00 243,970.00 -13.5% 1013202 5137 16111 RT CNTR-PD 8,281.59 .00 .00 .00 .00 .00 .0% 1013202 5139 UAL PD SWR 901,649.52 .00 .00 4,142,702.00 .00 .00 .0% 1013202 5139 16111 UAL PD SWR 23,481.46 .00 .00 .00 .00 .00 .0% 1013202 5213 DUES&SUBSC 15,057.08 34,890.00 38,010.00 23,708.83 38,210.00 45,040.00 18.5% 1013202 5215 TRNG/CONF 975.87 5,000.00 10,655.00 9,208.50 10,415.00 5,000.00 -53.1% 1013202 5216 OFFIC SUPP 13.95 .00 .00 .00 .00 .00 .0% 1013202 5217 OTHER SUPP 4,293.96 7,450.00 8,470.00 1,528.45 8,470.00 8,010.00 -5.4% 1013202 5218 UNIFRM EXP .00 .00 .00 18.00 .00 .00 .0% 1013202 5219 PERM/LC/FE 4,995.00 .00 5,000.00 5,000.00 5,000.00 5,000.00 .0% 1013202 5220 FUEL USAGE 21,250.80 29,480.00 29,480.00 15,950.70 22,590.00 25,980.00 -11.9% 1013202 5224 VEH CHRG 50,390.00 .00 .00 .00 .00 .00 .0% 1013202 5231 FURN&OFFC 3,317.37 8,250.00 2,250.00 495.88 1,100.00 6,250.00 177.8% 1013202 5232 COMP EQUIP 3,659.99 .00 5,260.00 5,398.30 5,260.00 5,200.00 -1.1% 1013202 5233 OTHR EQUIP 2,759.34 .00 1,580.00 12,637.12 1,580.00 13,000.00 722.8% 1013202 5253 CONTRC SVS 92,633.58 93,010.00 93,010.00 93,000.52 93,000.00 95,790.00 3.0% 1013202 5258 OTHER SVS 17,961.00 19,460.00 9,480.00 12,316.94 8,400.00 16,000.00 68.8% 1013202 5702 FLT-MT&RP .00 32,290.00 32,290.00 29,601.00 32,290.00 38,470.00 19.1%

Page 90 of 214 ends

Upland City CouncilMay 9, 2022

Upland City Council
May 9, 2022