Guadalupe City Council
June 15, 2022

June 15, 2022 City of Guadalupe Council Meeting Agenda Page 1 of 2 City of Guadalupe
AGENDA
Special Meeting of the Guadalupe City Council
Wednesday, June 15, 2022, at 6:00 pm
City Hall, 918 Obispo Street, Council Chambers
The City Council meeting will broadcast live on Charter Spectrum Cable Channel 20.

If you choose not to attend the City Council meeting but wish to make a comment during oral communications or on a specific agenda item, please submit via email to [email protected] no later than 1:00 pm on Wednesday, June 15, 2022.

Please be advised that, pursuant to State Law, any member of the public may address the City Council concerning any item on the Agenda, before or during Council consideration of that item. If you wish to speak on any item on the agenda, including any item on the Consent Calendar or the Ceremonial Calendar, please submit a speaker request form for that item. If you wish to speak on a matter that is not on the agenda, please do so during the Community Participation Forum.

The Agenda and related Staff reports are available on the City’s website: www.ci.guadalupe.ca.us Friday before Council meeting.

Any documents produced by the City and distributed to a majority of the City Council regarding any item on this agenda will be made available the Friday before Council meetings at the Administration Office at City Hall 918 Obispo Street, Monday through Friday between 8:00 am and 4:30 pm, and also posted 72 hours prior to the meeting. The City may charge customary photocopying charges for copies of such documents. Any documents distributed to a majority of the City Council regarding any item on this agenda less than 72 hours before the meeting will be made available for inspection at the meeting and will be posted on the City’s website and made available for inspection the day after the meeting at the Administrator Office at City Hall 918 Obispo Street, Monday through Friday between 8:00 am and 4:30 pm.

In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, including review of the Agenda and related documents, please contact the Administration Office at (805) 356.3891 at least 72 hours prior to the meeting. This will allow time for the City to make reasonable arrangements to ensure accessibility to the meeting.

1. ROLL CALL:

Council Member Liliana Cardenas
Council Member Gilbert Robles
Council Member Eugene Costa Jr.

Mayor Pro Tempore Tony Ramirez
Mayor Ariston Julian

2. MOMENT OF SILENCE
June 15, 2022 City of Guadalupe Council Meeting Agenda Page 2 of 2

3. PLEDGE OF ALLEGIANCE

4. COMMUNITY PARTICIPATION FORUM
Each person will be limited to a discussion of three (3) minutes or as directed by the Mayor.

Pursuant to provisions of the Brown Act, no action may be taken on these matters unless they are listed on the agenda, or unless certain emergency or special circumstances exist. City Council may direct staff to investigate and/or schedule certain matters for consideration at a future City Council meeting.

REGULAR BUSINESS

5. FISCAL YEAR 2022-2023 PROPOSED BUDGET FOR BUDGET WORKSHOP.

6. ADJOURNMENT
I hereby certify under penalty of perjury under the laws of the State of California that the foregoing agenda was posted on the City Hall display case and website not less than 24 hours prior to the meeting. Dated this 9th day of June 2022.
_____________________________________
Todd Bodem, City Administrator
Todd Bodem

Agenda Item No. 5

REPORT TO THE CITY COUNCIL OF THE CITY OF GUADALUPE
Budget Workshop June 15, 2025

_______________________________ _________________________________ Prepared by: Approved by:

Lorena Zarate, Finance Director Todd Bodem, City Administrator SUBJECT: Fiscal Year 2022-2023 Proposed Budget for Budget Workshop RECOMMENDATION:

It is recommended that the City Council review and interactively discuss the proposed budget for the fiscal year 2022-2023, along with the Capital Improvement Projects Budget, Capital Facilities Program of Projects, and American Rescue Plan Act (ARPA) allocation of funds.

BACKGROUND:

City Council and City Staff participated in a goal-setting session on May 31, 2022. One of the goals of the City Council is to have a balance budget for the fiscal year 2022-2023, in which the priority is to build up reserves. In an effort to better match the upcoming year’s budget to the City’s priorities, City Staff is hosting a budget workshop.

City Staff has prepared a preliminary draft of the budget for the fiscal year 2022-2023. As part of the process, each department had an opportunity to evaluate and determine appropriate proposals to continue maintaining current levels of services. City Staff seeks for a recommendation from City Council as to how to finalize the budget and prioritize the use of funds.

DISCUSSION AND PROPOSED BUDGET OVERVIEW:

General Fund Summary
The preliminary draft of the budget includes revenues of $6,761,712 and expenditures of $7,746,896.

The expenditures are broken down in the graphs below.

Lorena Zarate

City Staff is seeking for City Council’s input as to what expenses should be prioritized and what expenses should be deferred to a subsequent fiscal year, consistent with the City Council’s goals. The expenditures per the preliminary draft need to be reduced to the amount of revenue expected, at a minimum, to breakeven. The difference between budgeted revenues and budgeted expenditures per the preliminary draft is $985,184. The budgeted expenditures per the preliminary draft will need to be further reduced if the City Council would like to build additional reserves.

Details on the budgeted revenue and departmental expenditures per the preliminary draft are explained below.

DEPARTMENT NAME
Amended Budget
FY21-22
Estimated Expenses
at 06/30/22
Proposed Budget
FY22-23
% of Total
Budget
Variance/Difference
between budgets
Variance
%
City Council 15,070 12,563 12,680 0.16% (2,390) -16%
Administration 487,530 483,399 539,000 6.96% 51,470 11% City Attorney 120,000 108,000 110,000 1.42% (10,000) -8% Finance 548,475 512,415 594,683 7.68% 46,208 8%
Non Departmental 667,587 557,138 778,507 10.05% 110,920 17% Building Maintenance 325,723 257,654 377,794 4.88% 52,071 16% Police 2,744,346 2,711,335 3,218,800 41.55% 474,454 17% Fire 1,338,000 1,315,034 1,428,900 18.44% 90,900 7%
Parks & Rec 326,099 246,307 390,172 5.04% 64,073 20%
Building and Safety 284,060 239,600 296,360 3.83% 12,300 4% Cannabis 57,587 60,717 - 0.00% (57,587) -100%
TOTAL ALL DEPARTMENTS: 6,914,477 6,504,162 7,746,896 832,419 12% 2022-23 GENERAL FUND PROPOSED DEPT BUDGET

General Fund Revenue (Attachment 1, A-1, and B-1)
Expected revenues as it relates to taxes, per the proposed budget, are $3,873,967 which is similar to the amount from the approved budget for fiscal year 2021-2022. City Staff used a projection performed by HDL for sales tax and local sales tax revenue, which includes the new Measure N. This projection is Exhibit A of Attachment 5. The projection shows sales tax revenue of $549,435 and Measure N sales tax revenue of $691,731. Property tax revenue was projected by HDL as well. The projected property tax revenue for fiscal year 2022-23 is $1,620,801, please see Exhibit B of Attachment 5 for the projection. Remaining revenue items in the Taxes category were projected based on estimated revenue for fiscal year 2021-22 with data through April 2022.

Expected revenues as it relates to building and planning, per the proposed budget, are $472,950 which is a decrease of 49% from the approved budget for fiscal year 2021-2022. This category of revenue represents the most significant change as compared to fiscal year 2021-2022 because the Pasadera development does not plan on permitting out any lots. It does include expected inflows from the Escalante Meadows project, which was originally expected in fiscal year 2021-22. In addition, the City expects to receive remaining funding for the general plan update project from the LEAP and REAP grants.

Expected revenues as it relates to public safety, per the proposed budget, are $338,500 which is a decrease of 37% from the approved budget for fiscal year 2021-2022, because the approved budget for fiscal year 2021-2022 was amended to include the expected mutual aid reimbursement of $229,734.

This proposed budget does not include a possible mutual aid participation as it is unknown. The proposed budget includes the continuation of the School Resource Officer and airport contracts. The remaining revenue items in this category were budgeted similar to the prior fiscal year of 2021-2022.

Expected other revenue is budgeted at $1,065,023, which is an increase of 21% from the approved budget for fiscal year 2021-2022. The proposed budget includes an estimated $100,000 from cannabis.

This was calculated by the City Administrator based on HDL correspondence. The rental revenue was estimated based on current trends since the reopening of city facilities. The City expects to continue to receive the Chevron grant, although it is uncertain that this funding would continue before next year.

Interest rates are currently low.

Expected transfers, (Attachment 1, B-1), into the general fund from other funds were estimated based on a draft calculation of the cost allocation study, which is Exhibit G of attachment 5. These will be updated when the cost allocation study is approved by Council after the budget is finalized. The transfer from the Successor Agency fund to the general fund was updated to reflect the approved ROPS from the Department of Finance. The transfer from ARPA (Attachment 4) in the amount of $484,413 to fund certain expenditures and governmental services will be explained in further detail below.

Overall, the preliminary draft of the budget includes estimated revenues for the general fund in the amount of $6,761,712. This is a decrease of 4% as compared to the prior year budget.

General Fund Expenditures:

Council (Attachment 1, C-1)
The budget for the Council department per the preliminary draft is $12,680, which represents a 16% decrease from the approved budget for fiscal year 2021-2022. Personnel services were calculated assuming the stipend amount would stay the same for all council members at $150 per month. CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.

Other expenses are budgeted to be similar to the prior year budget.

Administration (Attachment 1, C-2)
The budget for the Administration department per the preliminary draft is $539,000, which represents a 11% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• City Administrator
• Administrative Assistant
• HR
• City Clerk
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• City Administrator potential increase to salary of 20% as contract expires in November 2022 • City Clerk stipend remains the same at $150 per month • SEIU COLA of 3%
• Unfilled HR position at predecessor hourly rate plus the assumption of a potential 3% COLA for unrepresentative employees
• Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

All other line items are budgeted similarly to the prior year budget. Election costs are expected to be $10,000 to include TOT, Treasurer, Mayor and two council members.

Attorney (Attachment 1, C-3)
The budget for the Attorney department per the preliminary draft is $110,000, which represents a 8% decrease from the approved budget for fiscal year 2021-2022. The labor law consulting costs for union negotiations is unknown at this time.

Finance (Attachment 1, C-4)
The budget for the Finance department per the preliminary draft is $594,683, which represents an 8% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• Finance Director

• Business Manager
• Two Account Clerks
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• Potential 3% COLA and bilingual pay for unrepresentative employees • Anniversary step increases in hourly rates, discretionary based on performance evaluations • SEIU COLA of 3%
• Temporary assignment during the Tyler accounting software implementation • Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

All other line items are budgeted similarly to the prior year budget. The professional services expense includes new accounting software one-time and monthly cashiering and merchant fees, along with fees to HDL for the new services relating to sales and property tax revenue projections.

Non-Departmental (Attachment 1, C-5)
The budget for the Non-Departmental department per the preliminary draft is $778,507, which represents a 17% increase from the approved budget for fiscal year 2021-2022. The proposed budget for this department includes the following assumptions:
• Operating supplies includes $19,681 for Surface Pros that were allocated and funded by ARPA (Attachment 4), and annual fees paid for compliance with GASB68 and SSA218. • Professional services includes audit fees, dreamhost and the Tyler accounting software annual fee of $19,978.
• Information technology services includes the monthly service amount paid to Itech Solutions, along with the monthly service cost to maintain the City’s website. This line item also includes $36,888 for website and chambers equipment that were allocated and funded by ARPA (Attachment 4).
• CAJPIA provided an estimate for crime, property, and liability insurance (Attachment 5 Exhibit C), which overall increased $6,261.
• Animal services contract increased $22,700 (Attachment 5 Exhibit H) • PPE costs of $4,630 allocated and funded by ARPA (Attachment 4) • Annual payment of interfund loans
• Capital improvements (Attachment 2) and transfers total $317,193 which include the following:
o Accounting software $21,353
o General plan update $40,840
o Maintenance of efforts for streets $60,000, of which $40,000 is going towards the Streets Rehabilitation project and $20,000 going to Measure A o Park improvements that include $40,000 for rubberization at O’Connell Park and $150,000 for Tognazinni Park
o Transfer to help the Library fund pay rent in the amount of $5,000

Building Maintenance (Attachment 1, C-6)
The budget for the Building Maintenance department per the preliminary draft is $377,794, which represents a 16% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• 10% of Maintenance Lead (Rudy Gutierrez)
• 10% of Maintenance Worker (James Batalla)
• 50% of Maintenance Lead (Unfilled)
• 50% of Maintenance Worker (Juan Montero)
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• New Maintenance Lead position to be approved, filled and hired at step A • Anniversary step increases in hourly rates, discretionary based on performance evaluations • SEIU COLA of 3%
• Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

The proposed budget for other supplies and services for this department includes the following assumptions:
• Utilities is proposed at $50,000 which includes new costs for the Leroy Park • Communications expense includes fiber optic internet and phones • Membership dues is proposed at $7,000 to account for the storm water permit and other health permits
• Operating expense includes $20,638 for finance and public works conference room upgrades allocated and funded by ARPA (Attachment 4).
• Professional services include the following:
o $46,698 and $30,876 for auditorium upgrades and vegetation maintenance, respectively, that were allocated and funded by ARPA (Attachment 4) o $1,000 resurface of auditorium floor
o $57,000 recurring costs for maintenance
o $40,000 turf replacement grant match
• CAJPIA provided an estimate for liability insurance (Attachment 5 Exhibit C), which increased overall about $36,000
• All other line items are budgeted similarly to the prior year budget Police (Attachment 1, C-7)
The budget for the Police department per the preliminary draft is $3,218,800, which represents a 17% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• 50% of Chief of Public Safety
• 2 administrative staff

• 2 temporary staff
• 12 officers (2 Unfilled, 2 airport officers, 1 school resource officer) • Sergeant
• Lieutenant
• Code Compliance
• Emergency Preparedness Coordinator (unfilled)
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• Two unfilled officer positions to be filled at a Step A and Step B • Unfilled Emergency Preparedness Coordinator to be filled at Step A • Sergeant to Lieutenant promotion
• 4% COLA to Chief of Public Safety per contract
• Anniversary step increases in hourly rates, discretionary based on performance evaluations • SEIU COLA of 3%, potential POA COLA as union negotiations are underway • Overtime was estimated based on the current fiscal year trends through April 2022 • Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

All other line items in the preliminary draft of the budget were estimated based on annualized data for the current fiscal year, which are similar to the prior year’s budget, with the exception of fuel costs for rising prices. CAJPIA provided an estimate for liability insurance (Attachment 5 Exhibit C), which increased overall about $36,000. In addition, the cost of a generator in the amount of $50,000 was included in the proposed budget, which was allocated and funded by ARPA (Attachment 4).

Fire (Attachment 1, C-8)
The budget for the Fire department per the preliminary draft is $1,428,900, which represents a 7% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• 50% of Chief of Public Safety
• Battalion Chief
• 3 Fire Captains
• 3 Fire Engineers
• PCF’s
• Temporary staff
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• Battalion Chief position to be approved and filled
• 4% COLA to Chief of Public Safety per contract

• Recent negotiation with the IAFF union
• Anniversary step increases in hourly rates, discretionary based on performance evaluations • Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

All other line items in the preliminary draft of the budget were estimated based on annualized data for the current fiscal year, which are similar to the prior year’s budget, with the exception of fuel costs for rising prices. CAJPIA provided an estimate for liability insurance (Attachment 5 Exhibit C), which increased overall about $36,000.

Parks and Recreation (Attachment 1, C-9)
The budget for the Parks and Rec department per the preliminary draft is $390,172, which represents a 20% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• Manager
• 10% of Maintenance Lead (Rudy Gutierrez)
• 10% of Maintenance Worker (James Batalla)
• 50% of Maintenance Lead (Unfilled)
• 50% of Maintenance Worker (Juan Montero)
• Facilities Coordinator (part-time)
• Event Attendant
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• New Maintenance Lead position to be approved, filled and hired at step A • No ARPA funds used for manager or lead positions
• Anniversary step increases in hourly rates, discretionary based on performance evaluations • SEIU COLA of 3%
• Potential 3% COLA for unrepresentative employees
• Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

The proposed budget for other supplies and services for this department includes the following assumptions:
• Utilities and communications are proposed at $85,000 and $4,000, respectively, which includes new costs for the Leroy Park.

• Equipment replacement includes $2,400 for locks
• Operating expense includes $29,571 for recreational programs, tables, storage and concession stand allocated and funded by ARPA (Attachment 4).
• Increase in fuel costs
• Professional services include the following:
o $10,000 central park booster pump replacement
o $40,500 recurring costs for maintenance
• CAJPIA provided an estimate for liability insurance (Attachment 5 Exhibit C), which increased overall about $36,000
• All other line items are budgeted similarly to the prior year budget Building and Permits (Attachment 1, C-10)
The budget for the Building and Permits department per the preliminary draft is $296,360, which represents a 4% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• Permit Technician
• Associate Planner
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• New Associate Planner to be approved and filled at a Step B • SEIU COLA of 3%
• Temporary assignment during the planning accounting software implementation for scanning, allocated and funded by ARPA (Attachment 4)
• Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

The budget for professional services is proposed at $60,000, based on the assumption that the Associate Planner would absorb current consultant costs and $10,000 annual fees for the new planning software. All other line items are budgeted similarly to the prior year budget.

Cannabis (Attachment 1, C-11)
This department was not previously included in the budget. Per the City Administrator, there are no additional fees to be paid to HDL at this time.

General Fund Conclusion
Overall, estimated expenditures for the general fund per the preliminary draft of the budget total $7,746,896, which are approximately 12% greater that the approved budget for fiscal year 2021-2022.

As revenues are expected to exceed expenditures by $985,184, the estimated fund balance for the general fund is expected to be in the red approximately ($158,000) for fiscal year 2023 (Attachment 1, J-1).

City staff has prepared a list of items that are currently in the preliminary draft of the budget that can be reduced or deferred to aid in reaching the goal of a balanced budget, in which budgeted revenues are enough to cover the budgeted expenditures, at least at a breakeven point:
• The use of ARPA funds to fund the Parks and Recreation Manager and unfilled Maintenance Lead, which would reduce costs about $168,100.
• The elimination of the 3% COLA for unrepresented employees would reduce the cost about $8,800 to the General Fund.
• Renewing the City Administrator’s contract for the same salary would save $31,800. • The elimination of the temporary assignment for the Finance department during the accounting software implementation would save $6,500.
• The elimination of bilingual pay for unrepresented employees would save $6,500. • The elimination of the $40,000 rubberization for O’Connell park and $150,000 for Tognazinni park improvements, would save a total of $190,000.
• The allocation of cost hitting the General Fund for the maintenance worker (James Batalla) to streets only would save $16,300.
• The elimination of the Central Park booster pump would save $10,000. • The deferment of filling the three police positions, which includes two police officers and emergency coordinator for one year would save a total of $319,800, $159,900 if deferred for six months, broken out in the following manner:
o Emergency preparedness coordinator annual $109,000, $54,500 if half the year o Replacement officer for I. Reyes annual $107,500, $53,500 if half the year o Replacement officer for J. Bahena annual $103,300, $51,650 if half the year • The elimination of temporary intern positions for public safety would save $22,000. • The elimination of the Battalion Chief position would save approximately $148,000. • The elimination of the turf replacement match would save approximately $40,000. • The elimination of locks under the Parks and Recreation department would save approximately $2,400.
• The postponement of the Associate Planner position would save approximately $40,000. • Reduce operating, equipment and office supplies across all departments. • Re-allocate the use of ARPA funds to increase the figure for revenue loss based on the assumption that the use of the funds would be to fund current governmental services.

Suggestions include:
o Generator
o Reduce website and Adobe expense
o PPE supplies
o Alternative to the Surface Pros
o Reduce auditorium, public works conference room and finance office upgrades o Library relocation
o Differential for emergency services
The items listed above, with the exception of the reallocation of ARPA and reduction of operating supplies across all departments, may result in a total reduction of costs of about $1,010,200 which would be enough to have a balance budget. However, City Staff is seeking input from the City Council as to which costs should be reduced or eliminated. In addition, it is important to emphasize the sustainability aspect of funding recurring costs with one-time monies.

Public Safety Special Funds (Attachment 1, D-1 through D-3) Proposed budgeted revenues for fiscal year 2022-2023 are similar to prior year revenue. No expenses are currently budgeted under these departments. Most of the funds are Proposition 172 funds, related to the Local Public Safety Protection and Improvement Act of 1993, and must be expended only on public safety services as defined in Government Code 30052.

Streets Special Funds:

Measure A (Attachment 1, E-1, and E-2)
Budgeted revenues for Measure A, per the proposed budget, are $676,942, as estimated by SBCAG, and represents an increase of 17% from the approved budget for fiscal year 2022. Revenues also include funds from the General Fund related to the Chevron grant for streets in the amount of $60,000.

The budget for Measure A per the preliminary draft is $1,256,847, which represents a 2% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• 30% Public Works Director
• 33.33% Engineering Technician
• 80% of Maintenance Lead (Rudy Gutierrez)
• 80% of Maintenance Worker (James Batalla)
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• New Engineering Technician position to be filled at step B • Anniversary step increases in hourly rates, discretionary based on performance evaluations • SEIU COLA of 3%
• Potential 3% COLA for unrepresentative employees
• Potential increase to Public Works Director to $70/hour • Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

The proposed budget includes the following:
• $45,000 for a replacement utility vehicle
• $13,000 for equipment for tree survey
• An increase for fuel costs
• $5,000 for the removal of trees from native garden
• $105,000 for an Urban Forest Plan
• Transfer to General Fund per the draft cost allocation study Transfers for capital improvements (Attachment 2) are estimated to be $610,200 to fund street rehabilitation, sidewalk repairs, storm drain improvements.

Gas Tax (Attachment 1, E-1, and E-3)
Budgeted revenues for the Gas Tax fund, per the proposed budget, are $351,812, as estimated by Michael Coleman per CaliforniaCityfinance.com, and represents an increase of 12% from the approved budget for fiscal year 2022. The budget for Gas Tax per the preliminary draft is $705,353, which represents a 17% increase from the approved budget for fiscal year 2021-2022. Transfers for capital improvement (Attachment 2) are estimated to be $701,000 for street rehabilitation.

LTF (Attachment 1, E-1, and E-4)
Budgeted revenues for the LTF fund, per the proposed budget, are $9,270, as estimated by SBCAG, and represents an increase of 17% from the approved budget for fiscal year 2022. The budget for LTF per the preliminary draft is $8,800, for transfers for capital improvements (Attachment 2) for sidewalk repairs.

SB1 RMRA (Attachment 1, E-1, and E-5)
Budgeted revenues for the SB1 RMRA fund, per the proposed budget, are $190,494, as estimated by Michael Coleman per CaliforniaCityfinance.com, and represents an increase of 23% from the approved budget for fiscal year 2022. The budget for SB1 RMRA per the preliminary draft is $380,000, related to transfers for capital improvement (Attachment 2) for street rehabilitation.

SB1 SRTS (Attachment 1, E-1, and E-6)
The funds for Safe Routes to School are expected in a subsequent fiscal year for the construction phase. No budget for fiscal year 2023.

ASHC Pedestrian (Attachment 1, E-1, and E-7)
Budgeted revenues are $200,000 from ASHC grant to fund the 11th St Multimodal path design project.

Enterprise Funds:

Water Operating (Attachment 1, F-1, and F-2)
Budgeted revenues as it relates to the Water Operating fund, per the proposed budget, are $2,626,014, represents a decrease of 3% from the originally approved budget for fiscal year 2022.

Revenue for the water operating fund was estimated by annualizing current data through April 2022 and increasing by 3% related to the recent increase in rates, and it also includes an estimate of connection fees related to Escalante Meadows. Revenues also include a $40,000 grant for turf replacement.

The budget for the water operating fund per the preliminary draft is $2,742,806, which represents a 6% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• 30% Public Works Director
• 33.33% Engineering Technician
• Water Supervisor
• Water Maintenance Operator
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:

• New Engineering Technician position to be filled at step B • Anniversary step increases in hourly rates, discretionary based on performance evaluations • SEIU COLA of 3%
• Potential 3% COLA for unrepresentative employees
• Potential increase to Public Works Director to $70/hour • Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

The proposed budget includes the following:
• $115,000 for the reroute of Campodonico services
• $45,000 for a replacement utility vehicle
• $25,000 for backup well motor for Pasadera well
• $10,000 for pump maintenance
• An increase for utility and fuel costs
• State water purchase decrease, per CCWA projection (Attachment 5 Exhibit F) • $100,000 for the climate action plan and $40,000 shortage contingency plan • $15,000 tank inspection and $20,000 water atlas update • $40,000 turf replacement
• CAJPIA provided an estimate for liability insurance (Attachment 5 Exhibit C), which increased overall about $36,000
• Transfer to General Fund per the draft cost allocation study All other line items in the preliminary draft of the budget were estimated based on annualized data for the current fiscal year, which are similar to the prior year’s budget.

Water Capital (Attachment 1, F-1, and F-3)
In regards to the water capital fund, revenue was estimated to reflect expected impact fees from the Pasadera development, 8 lots, and standby charges. Transfer for capital improvements (Attachment 2) are budgeted to be $1,065,387 for the following projects:
• Financial accounting software
• Elevated tank repairs
• Advanced metering infrastructure
• SCADA improvements
• West main waterline
• Bonita tank demolition
Wastewater Operating (Attachment 1, F-1, and F-4)
Budgeted revenues as it relates to the Wastewater Operating fund, per the proposed budget, are $2,269,300, represents an increase of 1% from the originally approved budget for fiscal year 2022.

Revenue for the wastewater operating fund was estimated by annualizing current data through April

2022 and increasing by 3% related to the recent increase in rates, and it also includes an estimate of connection fees related to Escalante Meadows, along with rental revenue expected from the Clay’s Septic lease agreement.

The budget for the wastewater operating fund per the preliminary draft is $2,502,415, which represents a 34% increase from the approved budget for fiscal year 2021-2022. Personnel for this department includes the following:
• 30% Public Works Director
• 33.33% Engineering Technician
• Wastewater Supervisor
• Wastewater Maintenance Operator
• Operator in training
Personnel services were calculated based on the following assumptions, please see Exhibit D of Attachment 5 for the payroll calculation:
• New Engineering Technician position to be filled at step B • Anniversary step increases in hourly rates, discretionary based on performance evaluations • SEIU COLA of 3%
• Potential 3% COLA for unrepresentative employees
• Potential increase to Public Works Director to $70/hour • Estimation of the unfunded liability cost was prepared using Calpers updated rates (Attachment 5 Exhibit E), which overall increased about $47,000.
• CAJPIA provided an estimate for workers compensation insurance (Attachment 5 Exhibit C), which shows that workers compensation insurance is expected to be about $27,000 higher overall as compared to FY22.
• Medical insurance costs are assumed to be 10% higher.

The proposed budget includes the following:
• An increase for utility and fuel costs
• $48,000 aerator, $70,000 tractor, and $80,000 for grit system replacement • $100,000 for the climate action plan
• $80,000 wastewater master plan
• $50,000 annual jetting
• $20,000 sewer atlas update
• CAJPIA provided an estimate for liability insurance (Attachment 5 Exhibit C), which increased overall about $36,000
• Transfer to General Fund per the draft cost allocation study All other line items in the preliminary draft of the budget were estimated based on annualized data for the current fiscal year, which are similar to the prior year’s budget.

Wastewater Capital (Attachment 1, F-1, and F-5)
In regards to the wastewater capital fund, revenue was estimated to reflect expected impact fees from the Pasadera development, 8 lots and a grant from IRWM for the effluent pump station rehabilitation.

Transfer for capital improvements (Attachment 2) are budgeted to be $1,843,208 for the following projects:
• Financial accounting software
• Effluent irrigation pump station rehab
• Hwy 1 Lift station
• AIPS vault
Solid Waste (Attachment 1, F-1, and F-6)
The budget includes costs related to the Calrecycle grant.

Transit (Attachment 1, F-1, and F-7)
The transit fund is budgeted to receive revenues in the amount of $2,566,305, which includes CARES Act, AHSC grants, CRRSSA, LCTOP, and 3CE. The budgeted expenditures reflect the following:
• Allocation of 10% of the Public Works Director personnel costs • Additional advertising costs for new transit plan
• Vehicle maintenance, contactless pay, increase to fuel costs and increase to Smooth’s contract • $1,800,000 for infrastructure improvements to include EV Bus and charging and Amtrak train station design.

Miscellaneous Special Funds (Attachment 1, G-1 through G-14) Budgeted revenues for the library fund have been estimated to reflect expected impact fees from Pasadera and a $5,000 transfer from General Fund. The budget for the library fund rent costs of $15,000. The library currently has unpaid interfund loan in the amount of $68,333 with the capital facilities fund.

The public facilities fund is budgeted to receive funds from the Escalante Meadows development. This fund is currently accumulating funds with no expenditures budgeted.

The park development fund is budgeted to receive funds from the Escalante Meadows development.

The CDBG fund and the park development fund currently have an interfund loan for Leroy Park and is expected to be partially repaid when the project is complete.

The capital facilities fund houses monies from People Self Help Housing and Pasadera development impact fees. Staff prepared a program of projects for Council’s approval as to the use of the funds (Attachment 3), which includes $70,000 for public safety equipment and $459,537 capital improvements (Attachment 2). The public safety equipment includes fire turnouts, SCBA breather, fire hoses, exhaust captures, and crime prevention camaras. The capital improvements include American Legion wood repair, police electrical upgrade, public facilities master plan, auditorium stage and chambers repairs, and pedestrian improvements. This fund is estimated to run out after this fiscal year 2022-2023.

Budgeted revenues for the city hall equipment fund and traffic fees fund have been updated to reflect expected impact fees from Pasadera. The city hall equipment fund includes a proposed budget of $25,000 for city hall equipment. The traffic fees fund budget includes a transfer for capital improvement, more specifically for street rehabilitation in the amount of $120,000 (Attachment 2).

Budgeted revenues and expenses for the CDBG fund have been updated to reflect expected grant funding for the following projects:
• CV1 total grant of $84,676
• Microenterprises total grant of $250,000
• CV2/3 total grant of $308,128
• Central Park total grant of $4,887,084
• Leroy phase 2 total grant of $1,700,000
• Urban Forest total grant of $170,734
Lighting and Landscape District Funds (Attachment 1, H-1 through H-4) The budgeted revenues for these district funds reflect estimates based on prior year information. The budgeted expenditures for these funds are similar to the prior year budgets with the exception of additional Pasadera Lot 5 electrical and landscaping.

Successor Agency Funds (Attachment 1, I-1 through I-3)
The budgeted revenues for these funds reflect estimates based on prior year information. Revenues include a CDBG grant of $5,100,000 for the Royal Theater. The budgeted expenditures for these funds are similar to the prior year budgets with the exception of the Royal Theater capital project.

Capital Improvement Projects (Attachment 2)
The CIP identifies all of the Capital projects to be undertaken during the budget cycle. The proposed CIP will provide the City of Guadalupe a solid base from which to develop a long-range plan. With Council approval, the City plans on completing $20,228,699 in fiscal year 2023 for public improvements, which are detailed out in Attachment 2.

ARPA (Attachment 4)
The total award to the City was $1,860,000. The City received the first half in the amount of $930,930 in June 2021 and expects to receive the remainder this summer. City Council has approved and allocated a total amount of $1,710,434. It is estimated that by the end of June 2022 the City would have spent $330,606. The proposed budget for fiscal year 2023 includes the use of ARPA funds in the amount of $1,222,218, of which $484,413 is to fund General Fund expenditures, $30,806 is to fund Los Amigos de Guadalupe, and $707,000 is to fund capital projects. Attachment 4 describes the uses of the funds.

ATTACHMENTS:

1. Proposed Fiscal Year 2022-2023 City Budget Draft

2. Proposed Fiscal Year 2022-2023 Capital Improvement Projects Budget Draft

3. Proposed Fiscal Year 2022-2023 Capital Facilities Fund Program of Projects Draft

4. Proposed Fiscal Year 2022-2023 American Rescue Plan Act Allocation Draft

5. Exhibits
Attachment 1
City of Guadalupe
City Budget Draft
Fiscal Year July 1, 2022 through June 30, 2023
Table of Contents
A General Fund Revenue
B General Fund Transfers
C General Fund Expenditures
D Public Safety Funds
E Street Funds
F Enterprise Funds
G Miscellaneous Funds
H Lighting and Landscape District Funds
I Successor Agency Funds
J Fund Balances
Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
Taxes:
3130 Sales & Use Tax        449,876        441,000        523,722        511,345        538,850        549,435 *updated projection from HDL on 4.22.22 3135 Franchise Fees        259,210        248,000        276,551        260,000        260,000        260,000 *annualization of monthly amts from waste mngt, quarterly from charter, annual for socal and pge 3136 Local Sales Tax        154,080        156,000        287,419        800,000        686,697        691,731 *updated projection from HDL on 4.22.22 3140 Real Property Transfer Tax          28,394          29,000          28,112           25,000           35,695           30,000 *similar to FY22 3145 Property Tax    1,273,499    1,409,600    1,446,059     1,550,000     1,583,969     1,620,801 *updated projection from HDL on 5.4.22; GF est $427,735, VLFAA est $940,947; RDA pass est $248,372 (5.5% dec value) 3150 Utility User Tax        442,934        441,000        480,619        450,000        450,000        450,000 *82% of budget through Apr 2022 3210 Bus. License/Gross Receipts Tax 279,629                305,000        268,160        272,000        272,000        272,000 *94% of budget through Apr 2022 Total Taxes    2,887,622    3,029,600    3,310,643     3,868,345     3,827,211     3,873,967 Building & Planning:
3215 Building Permits        276,474        298,596        142,775        261,230        212,000        104,400 *Pasadera 0 lots permitted per Craig; escalante meadows confirmed for FY2023 3216 Other Licenses & Permits          36,795          28,621          19,880           28,230           32,000           18,200 *Pasadera 0 lots permitted per Craig; escalante meadows confirmed for FY2023 3217 Electrical Permit          56,084          59,859          41,580           59,000           66,000           51,800 *Pasadera 0 lots permitted per Craig; escalante meadows confirmed for FY2023 3218 Mechanical Permit          47,388          43,825          19,935           33,300           27,000           12,000 *Pasadera 0 lots permitted per Craig; escalante meadows confirmed for FY2023 3219 Plumbing Permit        154,218          74,471          27,024           66,500           59,000           39,900 *Pasadera 0 lots permitted per Craig; escalante meadows confirmed for FY2023 3220 Plan Check Other        131,693        129,948          59,307        117,900           97,000           64,800 *Pasadera 0 lots permitted per Craig; escalante meadows confirmed for FY2023 3223 Over the Counter Plan check            3,126               510 ‐           14,682           16,834 ‐ *Pasadera 0 lots permitted per Craig 3521 General Plan Update ‐        164,220          30,226        121,229        129,774 ‐ *LEAP grant remaining of $74k of total of $160,000 expected in FY22 REAP/LEAP Grant ‐          12,765        169,280           30,057        127,050 *REAP Grant to offset planning expenses. Aug 2023; environmental part $65k LEAP 3522 Grading Permits               912               900 ‐                900                900                900 *similar to FY22 3525 Public Improvement Plan Check               490               500 ‐                500                500                500 *similar to FY22 3537 Plans & Specs          39,730          25,000          18,689           21,300           27,618           13,500 *similar to FY22 3618 Administrative Overhead          66,739          62,000          35,957           30,000           30,000           39,900 *includes annualization of monthly amounts based on current year FY2022 for rebills and airport Total Building & Planning       813,649       888,450       408,137        924,051        728,683        472,950 Public Safety:
3310 Criminal Fines & Penalties               745               600               283                300                300                300 *similar to FY22 3320 Other Fines & Penalties          11,526          12,300            5,963             5,000             5,000             5,000 *similar to FY22 3450 POST Training            6,604            5,100            7,091 ‐ ‐ ‐ *similar to FY22 3483 School Resource Officer          20,174          44,086          42,766           53,915           60,328           60,400 *similar to FY22 3406 COPS Grants        155,796        166,000        156,764        166,000        185,093        185,100 *includes annualization of monthly amounts based on current year FY2022 3490 Other Government Grants            6,204            5,100            5,927             5,100             9,642             6,000 *similar to FY21 3498 Vehicle Anti‐Theft 3,995                        3,978            4,021             3,978             3,978             4,000 *similar to FY22 3547 Special Fire Services          23,223          12,240 ‐ ‐ ‐ ‐ 3548 AMR Ambulance Revenue          17,398            9,318          16,399           16,000           16,620           16,700 *similar to FY22 3549 CA OES Fire Assistance * ‐ ‐        160,699        222,678        229,734 ‐ *mutual aid is unknown 3560 Special Police Services            1,375 ‐ ‐ ‐ ‐ ‐ 3619 Police Overhead          35,885          51,000          33,148           52,471           52,471           52,500 *Airport, similar to FY22 3643 Misc. Revenue ‐ Police 29,604                    26,520          11,163           15,000           15,000             8,500 *includes annualization of monthly amounts based on current year FY2022 Total Public Safety       312,529       336,242       444,223        540,442        578,166        338,500 Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
3481 CA Beverage Container Grant            7,982            4,300 ‐ ‐ ‐ ‐ 3224 Cannabis App Fee ‐ ‐ ‐           63,000           63,000 ‐ *cannabis application fees, no further revenue expected in FY2022 Cannabis Revenue ‐ ‐ ‐ ‐ ‐        100,000 *per HDL full yr $150k‐300K; assume 1/2 yr conservatively $100k; per City Administrator 3877 Transfer from ARPA ‐ ‐ ‐        365,706        217,572        484,413 *ARPA ‐ (see separate summary) 3499 Revenue from Other Agencies 206,942                192,500        261,138        264,465        266,968        268,000 *Airport revenue similar to PY 3550 Other Permits & Fees            2,197            2,200            7,690             3,200             3,200             2,500 *similar to FY22 3580 Other Service Charges               600               510               335                500                500                500 *similar to FY21 3604 Contributions, non‐gov't. 90,000                    90,000          90,000           90,000           90,000           90,000 *assume similar to FY22 3479 Contributions, other            1,298 ‐              (511) ‐ ‐ ‐ 3610 Rental of Property        114,626        113,000          97,083        100,000        100,000        115,300 *includes annualization of monthly amounts based on current year FY2022; clays septic, ap wireless and facility rental 3615 Refund ‐ Prior Year Exp.               494 ‐                  29 ‐ ‐ ‐ 3620 Miscellaneous Income            4,728            3,060            7,027             1,500             1,500             1,500 *includes annualization of monthly amounts based on current year FY2022 3621 Over/Short              (125) ‐ ‐ ‐                  10                  10 3622 Business License Late Charge ‐ ‐ ‐ ‐ ‐ ‐
3625 Public Donations            2,210 ‐            1,000 ‐ ‐ ‐ 3134 Dividends            1,593            1,530            2,063             1,600             1,600             1,800 *includes annualization of qtrly amount based on current year FY2022 3605 Interest Income          14,205          15,000            3,399             5,000             1,424             1,000 *includes annualization of monthly amounts based on current year FY2022; low interest rates 3606 Investment Income         (11,856) ‐          15,675         (12,000)             5,000 ‐ *based on stock price at end of FY 3638 W/C Reimbursement          36,385 ‐            1,934 ‐ ‐ ‐ 3646 Sale of Surplus Property ‐ ‐ ‐ ‐ ‐ ‐
Total Other Revenue       471,279       422,100       486,863        882,971        750,774     1,065,023 Transfers:

Various Regular Interfund Transfers        777,600        822,212        852,292        850,400        825,957     1,011,272 Total Transfers       777,600       822,212       852,292        850,400        825,957     1,011,272 5,262,679    5,498,604    5,502,158     7,066,209     6,710,790     6,761,712

GENERAL FUND REVENUE

GENERAL FUND REVENUE CONTINUED

GENERAL FUND REVENUE

GENERAL FUND REVENUE

TOTAL GENERAL FUND REVENUE
2022‐2023 Proposed City Budget General Fund Revenue, A‐1 DRAFT 6/8/2022

TRANSFERS TO GENERAL FUND
Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
Enterprise Funds
3810 Water     279,200     286,212     294,900     315,600     315,600        335,200 3815 Wastewater     194,900     198,390     215,000     226,600     226,600        272,000 3831 Transit       35,000       35,000       35,000       35,000       35,000           76,200 509,100     519,602     544,900     577,200     577,200        683,400 Street Funds
71 Measure A       82,600       77,928       99,881       95,250       95,250        124,947 20 Gas Tax                  ‐       19,584          2,719          3,150          3,150             1,353 22 LTF ‐ Roads                   ‐                   ‐                   ‐                   ‐                   ‐ ‐ Sub‐Total Street Funds       82,600       97,512     102,600       98,400       98,400        126,300 Other Funds
67 CDBG Micro         8,000       30,000       29,492 ‐                   ‐                   ‐ 65 Lighting District         9,033          7,752          8,034          6,155          6,155             6,547 63 Pasadera L&L District                   ‐                   ‐                   ‐                   ‐          1,474             4,514 60 Lighting & Landscape District 3,867                   2,346          2,266          3,645          2,171             1,639 Sub‐Total Other Funds       20,900       40,098       39,792          9,800          9,800           12,700 26 Successor Agency Operating 165,000          165,000     165,000     165,000     140,557        188,872 777,600     822,212     852,292     850,400     825,957     1,011,272 Transfers Transfers Estimate Estimate
based on based on based based
Cost Cost on on
Allocation Allocation Cost Alloc Draft
Study Study Study Cost Alloc
Study

TRANSFERS TO GENERAL FUND
Sub‐Total Enterprise Funds
Grand Total General Fund Transfers
2022‐2023 Proposed City Budget Transfers to General Fund, B‐1 DRAFT 6/8/2022
Department: City Council ‐ 4100
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100          1,650          1,800          1,500          1,800          1,800          1,800 Salaries ‐ Part‐time 0125 9,150                    9,000          9,520          9,000          9,000          9,000 Salaries ‐ Temporary 0150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Overtime 0200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Retirement ‐ PERS 0250 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ FICA/Medicare 0300 827                            830              838              830              830              830 Workers' Compensation 0350 441                            528              476              640              452              550 Based on estimate provided by CAJPIA Unemployment Insurance 0360 ‐                   ‐                   ‐                   ‐                                  29 ‐ Medical Insurance 0400 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Other Benefits 0450 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Deferred Comp. 0545 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Dental Insurance 0560 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vision Insurance 0570 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total        12,067        12,158        12,334        12,270        12,111        12,180 SUPPLIES & SERVICES:

Utilities 1100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Communications 1150 598                            670              272 ‐                   ‐                   ‐ Office Supplies & Postage 1200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Advertising & Publication 1250 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Business Exp. & Training 1300 2,043                    2,500              119          2,500 ‐                   ‐                   similar to prior Memberships, dues,subscriptions 1350 825               ‐                   ‐                   ‐                   ‐                   ‐ Equipment Maintenance 1400 ‐                   ‐                                   ‐                   ‐                   ‐                   38 Facility Maintenance 1450 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vehicle Maintenance 1460 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Replacement 1500 ‐                   ‐                            1,010 ‐                   ‐                   ‐ Operating Supplies & Exp. 1550 169                            300              990              300              452              500 similar to prior Fuel & lubricants 1560 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Elections 1600 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Out‐of‐State Sales Taxes 1651 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Bank Service Charges 1750 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Labor Negotiations 2149 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Professional services 2150 ‐                   ‐                                390 ‐                   ‐                   ‐ Information Technology Svs 2151 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Rental 2200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Liability Insurance 2300                    ‐                  ‐   ‐                   ‐                   ‐                   ‐ Services by other Agencies 2350 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total          3,635          3,470          2,819          2,800              452              500 CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Improve. other than Buildings 3150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Land 3170 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment 3200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Debt Service Interest 4100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Lease Purchase 4150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Department Total        15,702        15,628        15,153        15,070        12,563        12,680 NOTES General Fund ‐ 01
Treasurer $150 per month
5 Council $150 per month
at 7.65%
2022‐2023 Proposed City Budget City Council, C‐1
DRAFT 6/8/2022
Department: Administration ‐ 4105
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100      170,696      217,465      248,893      311,000      311,000      333,000 SEIU COLA, Unrep. EE COLA, step increase, HR full time Salaries ‐ Part‐time 0125 38,786                67,736        41,787          1,800          1,800          1,800 City Clerk Salaries ‐ Temporary 0150 61,393                20,000        17,350 ‐ ‐ ‐ Overtime 0200 451                            479          1,574              500              600          1,000 similar to prior budget Retirement ‐ PERS 0250 50,482                55,000        39,524        54,000        54,000        58,900 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300 20,832                21,700        22,981        24,000        24,000        25,600 Workers' Compensation 0350 15,286                13,049        17,525        18,000        18,000        20,700 Based on estimate provided by CAJPIA Unemployment Insurance 0360 ‐ ‐ ‐ ‐                97 ‐ Medical Insurance 0400 33,247                47,000        44,349        53,000        48,000        66,100 Assume increase of 10% Other Benefits 0450 (2,759)          ‐ ‐ ‐ ‐ ‐
Deferred Comp. 0545 ‐ ‐ ‐ ‐             (258) ‐
Dental Insurance 0560          2,800          3,920          3,930          4,000          4,000          4,700 Vision Insurance 0570              469              570              566              580              580              700 Sub‐total      391,683      446,919      438,480      466,880      461,819      512,500 SUPPLIES & SERVICES:

Utilities 1000 ‐ ‐ ‐ ‐ ‐ ‐
Communications 1150 5,544                    5,500          4,852          5,500          4,500          4,500 includes Frontier and Impulse and HR cell phone Office Supplies & Postage 1200 1,522                    2,500          1,729          2,500          1,500          1,500 similar to prior budget; Quill, Staples, Amazon office supplies Advertising and Pubs 1250 1,291                    4,000              934          2,000              280          1,000 similar to prior budget; RFP's and public notices Business Exp. & Training 1300 701                        1,000              937          1,700          1,000              600 Cell phone reimbursement for City Adm Memberships, Dues & Subs 1350 ‐          1,100              265          1,750 ‐ ‐ Equipment Maintenance 1400 ‐ ‐                40 ‐ ‐ ‐
Facilities Maintenance 1450 ‐ ‐ ‐ ‐ ‐ ‐
Vehicle Maintenance 1460 ‐ ‐ ‐ ‐ ‐ ‐
Equipment Replacement 1500 ‐          1,090                64 ‐ ‐ ‐ Operating Supplies & Exp. 1550 2,854                    2,700          5,106          3,400          3,400          3,400 Copies; Ultrex Fuels and Lubricants 1560 ‐ ‐ ‐ ‐ ‐ ‐
Elections 1600 ‐          4,000          9,004 ‐ ‐        10,000 elections in Nov 2022 Out‐of‐State Sales Taxes 1651 ‐ ‐ ‐ ‐ ‐ ‐
Bank Service Charges 1750 ‐ ‐ ‐ ‐ ‐ ‐
Labor Negotiations 2149 ‐ ‐ ‐ ‐ ‐ ‐
Professional Services 2150 8,400                    9,000          3,357          3,800        10,900          5,500 Stanley security, Hinderliter sales tax contract, ASCAP annual fee, Ethics tranining Information Technology Svs 2151 ‐ ‐              488 ‐ ‐ ‐ Equipment Rental 2200 ‐ ‐ ‐ ‐ ‐ ‐
Liability Insurance 2300 ‐ ‐ ‐ ‐ ‐ ‐
Services by other Agencies 2350 ‐ ‐ ‐ ‐ ‐ ‐
COVID 2999 60                 ‐              178 ‐ ‐ ‐
Sub‐total        20,373        30,890        26,954        20,650        21,580        26,500 CAPITAL OUTLAY:

Buildings 3100 ‐ ‐ ‐ ‐ ‐
Improve. other than Buildings 3150 ‐ ‐ ‐ ‐ ‐
Land 3170 ‐ ‐ ‐ ‐ ‐
Equipment 3200 ‐ ‐ ‐ ‐ ‐
Sub‐total                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐ ‐ ‐ ‐ ‐ ‐
Debt Service Interest 4100 ‐ ‐ ‐ ‐ ‐ ‐
Lease Purchase 4150 ‐ ‐ ‐ ‐ ‐ ‐
Sub‐total ‐ ‐ ‐ ‐ ‐ ‐
Department Total      412,055      477,809      465,434      487,530      483,399      539,000 NOTES General Fund ‐ 01
at 7.65%
2022‐2023 Proposed City Budget Administration, C‐2
DRAFT 6/8/2022
Department: City Attorney ‐ 4110
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Salaries ‐ Part‐time 0125 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Salaries ‐ Temporary 0150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Overtime 0200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Retirement ‐ PERS 0250 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ FICA/Medicare 0300 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Workers' Compensation 0350 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Unemployment Insurance 0360 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Medical Insurance 0400 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Other Benefits 0450 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Deferred Comp. 0545 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Dental Insurance 0560 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vision Insurance 0570 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐
SUPPLIES & SERVICES:

Utilities 1000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Communications 1150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Office Supplies & Postage 1200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Advertising & Publication 1250 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Business Exp. & Training 1300 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Memberships, dues,subscriptions 1350 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Maintenance 1400 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Facility Maintenance 1450 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vehicle Maintenance 1460 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Replacement 1500 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Operating Supplies & Exp. 1550 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Fuel & lubricants 1560 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Elections 1600 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Out‐of‐State Sales Taxes 1651 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Bank Service Charges 1750 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Labor Negotiations 2149 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Professional services 2150 80,340                90,000        86,340      120,000      108,000      110,000 labor law consulting; annualized current costs Information Technology Svs 2151 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Rental 2200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Liability Insurance 2300 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Services by other Agencies 2350 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ COVID19 2999 4,208           ‐                            5,726 ‐                   ‐                   ‐ Sub‐total        84,548        90,000        92,065      120,000      108,000      110,000 CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Improve. other than Buildings 3150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Land 3170 ‐                   ‐                   ‐                   ‐                   ‐                    ‐ Equipment 3200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Debt Service Interest 4100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Lease Purchase 4150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐ Department Total        84,548        90,000        92,065      120,000      108,000      110,000 NOTES General Fund ‐ 01
2022‐2023 Proposed City Budget City Attorney, C‐3
DRAFT 6/8/2022
Department: Finance ‐ 4120
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 287,488            303,200      285,692      328,000      305,000      342,100 SEIU COLA, Unrep. EE COLA, step increase Salaries ‐ part‐time 0125 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Salaries ‐ Temporary 0150 37,488         ‐                            8,192 ‐                   ‐                            6,000 temp for Tyler Implementation Overtime 0200 205                          714          2,120          2,000          1,000          1,000 similar to FY21/22 Retirement ‐ PERS 0250 62,967                66,300        58,082        78,000        80,000        86,700 per Calpers employer contrib. rates and unfunded Liab.

FICA/MEDICARE 0300 25,714                24,480        22,496        26,000        24,000        26,800 Workers' Compensation 0350 18,729                18,360        18,342        25,000        20,000        23,500 Based on estimate provided by CAJPIA Unemployment Insurance 0360 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Medical Insurance 0400 41,263                50,500        48,433        61,000        55,000        74,700 estimate 10% increase Other Benefits 0450 (4,646)          ‐                   ‐                   ‐                   ‐                   ‐ Deferred Comp. 0545 3,764           ‐                               840 ‐                            2,500          2,500 Dental Insurance 0560 3,712                    3,570          3,436          4,200          3,500          4,200 Vision Insurance 0570 549                          612             604             620             560             700 Life Insurance 0585 41                 ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total      477,274      467,736      448,237      524,820      491,560      568,200 SUPPLIES & SERVICES:

Utilities 1000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Communications 1150 3,572                    3,600          3,051          3,200          3,000          3,000 similar to prior budget; Frontier and Impulse Office Supplies & Postage 1200 2,275                    2,550          3,517          3,200          3,000          3,000 office supplies and tax forms Advertising & Publication 1250 52                 ‐                   ‐                   ‐                   ‐                   ‐ Business Exp. & Training 1300 1,031                    2,020          2,051          2,000          2,000          2,000 Training for employees and CPE for CPA licensure Memberships, dues,subscriptions 1350 ‐                            2,055          1,430          2,255          2,255          2,255 CSMFO, GFOA, CalCPA, AICPA, CPA Equipment Maintenance 1400 ‐                            1,187              ‐                   ‐                   ‐                   772 Facilities Maintenance 1450 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vehicle Maintenance 1460 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Replacement 1500 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Operating Supplies & Exp. 1550 2,797                    3,000          2,209          3,000          1,600          1,600 similar to FY22; Copies, postage machine, checks Fuel & lubricants 1560 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Elections 1600 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Levys, Penalties, & Interest 1650                 ‐                   ‐                   ‐                   ‐                   ‐                   26 Out‐of‐State Sales Taxes 1651 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Bank Service Charges 1750                39 ‐                   ‐                   ‐                   ‐                   ‐ Labor Negotiations 2149 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Professional services 2150 13,570                15,000          8,408        10,000          9,000        14,628 MOMS,alarm, Tyler Merch fees, HDL prop and sales projc Information Technology Svs 2151 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipmental Rental 2200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Liability Insurance 2300 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Services by Other Agencies 2350 64                 ‐                   ‐                   ‐                   ‐                   ‐ COVID19 2999 298                          524 ‐                   ‐                   ‐ Sub‐total        23,724        29,412        21,962        23,655        20,855        26,483 CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Improve. other than Buildings 3150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Land 3170 ‐                   ‐                   ‐                   ‐                   ‐                    ‐ Equipment 3200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Debt Service Interest 4100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Lease Purchase 4150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Department Total      500,998      497,148      470,199      548,475      512,415      594,683 NOTES General Fund ‐ 01
at 7.65%
2022‐2023 Proposed City Budget Finance, C‐4
DRAFT 6/8/2022
Department: Non‐Departmental ‐ 4140
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Salaries ‐ Part‐time 0125                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Salaries ‐ Temporary 0150                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Overtime 0200                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Retirement ‐ PERS 0250                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ FICA/Medicare 0300                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Workers' Compensation 0350                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Unemployment Insurance 0360                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Medical Insurance 0400          1,979              930          2,611          2,100          2,580          2,600 Employee Assistance Program,health ins fees Other Benefits 0450                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Deferred Comp. 0545                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Dental Insurance 0560                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vision Insurance 0570                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total          1,979              930          2,611          2,100          2,580          2,600 SUPPLIES & SERVICES:

Utilities 1000                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Communications 1150                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Office Supplies & Postage 1200          1,435          1,200              826          1,200          2,090          2,100 Copy paper Advertising and Pubs 1250                    ‐                   ‐              211 ‐                   ‐                   ‐ Business Exp. & Training 1300                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Memberships, Dues & Subs 1350                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Maintenance 1400                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Facilities Maintenance 1450                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vehicle Maintenance 1460                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Replacement 1500                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Operating Supplies & Exp. 1550                    ‐                   ‐          7,250          2,250          2,265        21,932 similar to FY22, GASB 68 and SSA218 Annual Fees; Surface Pro ARPA Fuels and Lubricants 1560                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Elections 1600                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Out‐of‐State Sales Taxes 1651                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Bank Service Charges 1750          2,218          2,300          2,163          2,700          2,000          2,000 account analysis fees, similar to FY22 Labor Negotiations 2149                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Professional Services 2150        19,480        15,000        12,736        15,000        15,000        35,178 New Auditors, dreamhost internet, tyler annual fee Information Technology Svs 2151        32,289        73,704        77,692      112,887      118,000      142,129 Itech Solutions, office 365 and website; website & chambers equip live stream ARPA Equipment Rental 2200                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Liability Insurance 2300        13,341        16,100        15,316        20,008        20,008        22,470 Crime Ins, Property Ins; increase per JPIA estimate Services by other Agencies 2350        65,233        65,000        61,961        62,000        62,000        86,600 Animal Serv. & LAFCO Flood Assistance 2991                   ‐                    ‐                   ‐                   ‐                   ‐                   ‐ COVID19 2999          8,000          1,805          2,098              170          4,630 Sub‐total 133,996            181,304      179,960      218,143      221,533      317,038 CAPITAL OUTLAY:

Buildings 3100                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Improve. other than Buildings 3150                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Land 3170                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment 3200                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total                    ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 95,668              107,334      107,334      119,000      119,000      130,666 Wtr and Lighting Dist Debt Service Interest 4100 20,868                19,055          9,742          2,010          2,010          2,010 Wtr and Lighting Dist, interest rate at 3.31.22 same as 6.30.21 Lease Purchase 4150          6,155          6,200          7,108        10,396          9,000          9,000 New Copiers Interfund Transfers various        72,717      240,980      167,623      315,938      203,015      317,193 Cap Improv (Tyler, MOE, gen plan update, parks); $5000 library rent Write‐offs 8010                    ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total      195,408      373,569      291,807      447,344      333,025      458,869 Department Total      331,383      555,803      474,378      667,587      557,138      778,507 NOTES General Fund ‐ 01
2022‐2023 Proposed City Budget Non‐Departmental, C‐5
DRAFT 6/8/2022
Department: Building Maintainence ‐ 4145
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 18,684                  20,700         16,514         33,000         29,000         61,400 SEIU COLA, Unrep. EE COLA, step increase Salaries ‐ part‐time 0125                     ‐                    ‐ ‐                    ‐                    ‐                    ‐ Salaries ‐ Temporary 0150 768                ‐                    ‐                    ‐                    ‐                    ‐ Overtime 0200                    ‐ ‐                    ‐                    ‐                                  200 ‐ Retirement ‐ PERS 0250 4,344                      4,409           5,437           6,000           5,000           4,900 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300 1,568                      1,650           1,261           3,000           3,000           4,800 Workers' Compensation 0350 877                              768           1,259           2,000           1,300           1,500 Based on estimate provided by CAJPIA Unemployment Insurance 0360                     ‐                    ‐ ‐                    ‐                    ‐                    ‐ Medical Insurance 0400 3,732                      4,285           3,069           6,000           6,000         11,800 estimate 10% increase Other Benefits 0450 (52)                 ‐                                     ‐                    27 ‐                    ‐ Deferred Comp. 0545                    ‐ ‐                                    37           1,200           1,200           1,500 Dental Insurance 0560               247               268               214               400               400               800 Vision Insurance 0570                 28                 28                 24                 60                 60               200 Life Insurance 0585                   9 ‐                    ‐                    ‐                    ‐                    ‐ Sub‐total         30,204         32,108         27,842         51,660         46,160         86,900 SUPPLIES & SERVICES:

Utilities 1000 40,404                  38,757         44,824         50,000         50,000         50,000 City Hall, Vets Hall, Sr. Center, Leroy Park Communications 1150 189                              190               717         16,000         16,000         16,000 Charter, Frontier, fiber optic Office Supplies & Postage 1200 16                  ‐                                     ‐                    96 ‐                    ‐ Advertising & Publication 1250                    ‐ ‐                    ‐                    ‐                    ‐                    ‐ Business Exp. & Training 1300 38                                  40                 30                 30                 30                 30 Public Works Director allocation of cell phone reimbursement Memberships, dues,subscriptions 1350                     ‐                    ‐           5,994           7,000           7,000           7,000 Storm Water Permit and health permits Equipment Maintenance 1400                     ‐                    ‐ ‐                    ‐                    ‐                    ‐ Facility Maintenance 1450 2,360                    55,000         57,780 ‐                    ‐                    ‐ Vehicle Maintenance 1460 638                              650               603               650               650               650 similar to prior year Equipment Replacement 1500                    ‐                ‐                    400           3,806            ‐                    8,086 Operating Supplies & Exp. 1550 11,062                  10,800           6,655         39,260         45,000         35,639 Bathroom paper prod, Supplies; finance office & PW conf room upgrade ARPA Fuel & lubricants 1560 14                                100               302               500               670               750 Elections 1600                     ‐                    ‐ ‐                    ‐                    ‐ Out‐of‐State Sales Taxes 1651                    ‐ ‐                    ‐                    ‐                    ‐ Bank Service Charges 1750                    ‐ ‐                    ‐                    ‐                    ‐ Labor Negotiations 2149                    ‐ ‐                    ‐                    ‐                    ‐ Other professional services 2150 27,518                  25,000         34,108       151,817         80,000       175,574 Janitorial,Lndscp,Pest, Extgshr, aramark, stormwater, vegetation & aud upgrades ARPA; resurface aud floor; turf replacement Information Technology Svs 2151                     ‐                    ‐ ‐                    ‐                    ‐                    ‐ Equipment Rental 2200               427 ‐                    ‐                    ‐                    ‐                    ‐ Liability Insurance 2300 1,367                      1,800           5,327           5,000           4,058           5,251 Per JPIA estimate Services by other Agencies 2350 52                  ‐                    ‐                    ‐                    ‐                    ‐ COVID19 2999                    ‐ ‐                                  179 ‐                    ‐                    ‐ Sub‐total         84,085       132,737       156,616       274,063       211,494       290,894 CAPITAL OUTLAY:

Buildings 3100                    ‐ ‐                    ‐                    ‐                    ‐                    ‐ Improve. other than Buildings 3150                    ‐ ‐                    ‐                    ‐                    ‐                    ‐ Land 3170                    ‐ ‐                    ‐                    ‐                    ‐                    ‐ Equipment 3200                    ‐ ‐                    ‐                    ‐                    ‐                    ‐ Sub‐total                    ‐ ‐                    ‐                    ‐                    ‐                    ‐ OTHER FINANCING USES:

Debt Service Principal 4000                    ‐ ‐                    ‐                                       ‐ ‐                    ‐ Debt Service Interest 4100                    ‐ ‐                    ‐                    ‐                    ‐                    ‐ Lease Purchase 4150           1,406           1,600           1,308 ‐                    ‐                    ‐ Sub‐total           1,406           1,600           1,308 ‐                    ‐                    ‐ Department Total       115,694       166,445       185,766       325,723       257,654       377,794 at 7.65%
NOTES General Fund ‐ 01
2022‐2023 Proposed City Budget Building Maintenance, C‐6 DRAFT 6/8/2022
Department: Police ‐ 4200
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
1 Public Safety Dir @75%,Fire 25%; 2 Airport to be fully funded; lieut.

PERSONNEL SERVICES: 1 sergeants, 12 PO's, 2 admin, code compliance, emergency preparedness Salaries ‐ Regular 0100 986,626                 1,162,000     1,211,488       1,483,000       1,399,000       1,729,500 POA est, SEIU COLA, Director 3% COLA, step increases Salaries ‐ PartTime 0125 550                   ‐                                         ‐ 125                        ‐                        ‐ Salaries ‐ Temporary 0150 1,486                             8,580           14,539             19,400             17,400             18,400 includes temp and interns Salaries ‐ Overtime 0200 317,161                    140,500        274,929           230,000           267,000           236,700 Retirement ‐ PERS 0250 171,966                    204,000        215,129           281,000           272,000           314,500 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300 99,202                         92,500        112,409           128,046           125,000           149,800 Workers' Compensation 0350 107,014                    120,000           81,034           124,000           124,000           149,500 Based on estimate provided by CAJPIA Unemployment Insurance 0360 2,551               ‐                        ‐                                           ‐                       ‐                       ‐ Medical Insurance 0400 117,366                    133,000        157,670           197,000           188,000           234,200 assume 10% increase Other Benefits 0450 6,231                           31,740           20,802             27,000             28,000             24,300 Includes uniform and allowance Deferred Comp. 0545 53,848                         58,100           39,414             32,000             33,000             33,100 Dental Insurance 0560 14,221                         12,700           16,654             19,600             18,500             21,400 Vision Insurance 0570 1,896                             1,800             2,084               2,600               2,600               2,900 Life Insurance 0585 168                                         ‐ ‐                                           ‐                       ‐ Sub‐total      1,880,287       1,964,920     2,146,276       2,543,646       2,474,500       2,914,300 SUPPLIES & SERVICES:

Utilities 1000                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Communications 1150 5,400                            6,000             7,727               7,200             10,100             10,000 Annualized FY22 costs; verizon, frontier, satcom Office Supplies & Postage 1200 393                                 1,000             1,585               2,500               1,600               2,600 Annualized FY22 costs Advertising & Publication 1250                    77                  133 ‐                                           ‐                   130                       ‐ Business Exp. & Training 1300 13,380                         15,363             7,057             11,000             13,500             13,500 POST and travel expenes for trainings Memberships, dues,subscript. 1350 373                                    561                 563                   500                   500                   500 CLEC Dues, Clears Dues Equipment Maintenance 1400                        ‐ ‐                                         ‐ 474                        ‐                                    50,000 generator ARPA Facility Maintenance 1450                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Vehicle Maintenance 1460 7,078                             5,100             4,874               6,000               6,000               6,000 Similar to prior year costs Equipment Replacement 1500 10,126                           7,344              ‐ 5,030                                       ‐ 1,395 Operating Supplies & Exp. 1550 25,290                         20,286           21,291             20,000             24,100             24,000 Similar to prior years Fuel & lubricants 1560 23,017                         25,226           25,067             25,000             35,000             35,000 increase in gas prices Elections 1600                        ‐ ‐                        ‐                                           ‐                       ‐                       ‐ Levys, Penalties/Interest 1650                  287                       ‐                   12                       ‐                       ‐                       ‐ Out‐of‐State Sales Taxes 1651                        ‐ ‐                        ‐                                           ‐                       ‐                       ‐ Bank Service Charges 1750                        ‐ ‐                                             ‐ 6                        ‐                        ‐ Labor Negotiations 2149                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Professional services 2150            15,565             15,865           14,794               5,000               6,700               6,000 Background, Fingerprint, physical exams Information Technolgy Svcs 2151                        ‐ ‐                        ‐                                           ‐                       ‐                       ‐ Equipment Rental 2200                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Liability Insurance 2300            84,975             90,000           84,298             73,000             73,000             93,900 Per JPIA Estimate Services by other Agencies 2350            49,842             50,900           54,348             49,500             62,400             62,000 Dispatch services, toxicology, Dept. of Justice COVID19 2999               ‐ 6,581                                     ‐ 8,107                                       ‐ 1,280 Explorers 3210 1,000                              ‐                     1,020               1,000               1,130               1,000 similar to prior year budget Sub‐total          243,384          238,797        235,232           200,700           236,835           304,500 CAPITAL OUTLAY:

Buildings 3100                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Improve. other than Buildings 3150                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Land 3170                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Equipment 3200                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Sub‐total                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐

OTHER FINANCING USES
Debt Service Principal 4000                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Debt Service Interest 4100                        ‐ ‐                        ‐                                           ‐                       ‐                       ‐ Lease Purchase 4150                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Sub‐total                       ‐                       ‐ ‐                                           ‐                       ‐                       ‐ Department Total      2,123,672       2,203,717     2,381,508       2,744,346       2,711,335       3,218,800 at 7.65%
NOTES General Fund ‐ 01
2022‐2023 Proposed City Budget Police, C‐7
DRAFT 6/8/2022
Department: Fire ‐ 4220
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES: Director of Public Safety 50%; Bat Chief; 3 Captains; Salaries ‐ Regular 0100 351,733            495,000        576,426       591,000       555,000       731,700 3 Engineers; Director 4% COLA, step increases Salaries ‐ PCF's 0125 35,310                45,900           17,789          45,000          45,000          45,000 assume similar to prior year budget Salaries ‐ Temp 0150 18,874         ‐                   ‐                      ‐                     ‐                     ‐ Overtime 0200 102,345              76,500        209,699       259,000       280,000       129,200 Retirement ‐ PERS 0250 71,453                67,700        110,091       132,000       132,000       147,500 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300 42,112                37,880           61,783          60,000          60,000          69,300 Workers' Compensation 0350 36,914                51,000           35,585          58,000          58,000          69,800 Based on estimate provided by CAJPIA Unemployment Insurance 0360 1,045           ‐                   ‐                      ‐                                2,657 ‐ Medical Insurance 0400 59,506                70,000           66,119          75,000          69,000       104,000 new rates Other Benefits 0450 2,919                    5,700             9,163            7,000            7,000          10,500 Includes uniform and allowance Deferred Comp. 0545 7,321                    9,100             5,518            7,000            3,000 ‐ Dental Insurance 0560 2,917                    3,570             2,794            2,800            2,800            3,900 Vision Insurance 0570 441                            510                458               500               500               600 Sub‐total      732,891      862,860     1,095,425    1,237,300    1,214,957    1,311,500 SUPPLIES & SERVICES:

Utilities 1000 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Communications 1150 4,800                    4,900             5,177            5,200            4,500            4,500 telcom services, verizon, frontier, impulse Office Supplies & Postage 1200 620                            670                638               600               400               400 Advertising and Pubs 1250 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Business Exp. & Training 1300 3,173                    5,000             4,067            4,300            3,500            5,000 Travel exp for training, certifications Memberships, Dues & Subs 1350 500                            500                416               800               800               800 Peer Support coordinator quarterly dues Equipment Maintenance 1400 6,408                    5,000             5,516            4,600            3,800            4,000 annualization of current year costs Facilities Mainteanance 1450 753               ‐                   ‐                      ‐                     ‐                     ‐ Vehicle Maintenance 1460 9,006                  10,200             7,084            9,000            6,300            6,500 similar to prior year budget Equipment Replacement 1500 1,474                    1,500              ‐                     1,044                ‐                     653 Operating Supplies & Exp. 1550 12,837                12,240             9,554          12,000          14,200          15,200 annualization of current year costs Fuels and Lubricants 1560 5,827                    6,150             4,927            7,000            7,600          12,600 increase in gas prices Elections 1600 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Levys, Penalties/Interest 1650              861 ‐                   ‐                      ‐                     ‐                     ‐ Out‐of‐State Sales Taxes 1651 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Bank Service Charges 1750 ‐                   ‐                                       6 ‐                     ‐                     ‐ Labor Negotiations 2149 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Professional Services 2150          3,630          7,060                138 ‐                                   100 ‐ Information Technology Svs 2151 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ SBC Fair 2163          1,240 ‐                   ‐                      ‐                     ‐                     ‐ Equipment Rental 2200 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Liability Insurance 2300        30,630        31,000           37,199          33,000          34,000          44,200 Per JPIA estimate Services by other Agencies 2350        18,118        25,400           24,144          24,200          24,200          24,200 Dispatch serivces Fire Prevention 2500 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ COVID 2999 1,031           ‐                               4,338 ‐                                      24 ‐ Sub‐total      100,907      109,620        104,248       100,700       100,077       117,400 CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Improve. other than Buildings 3150 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Land 3170 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Equipment 3200 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Sub‐total ‐                   ‐                   ‐                      ‐                     ‐                     ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Debt Service Interest 4100 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Lease Purchase 4150 ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Sub‐total ‐                   ‐                   ‐                      ‐                     ‐                     ‐ Department Total      833,798      972,480     1,199,673    1,338,000    1,315,034    1,428,900 at 7.65%
NOTES General Fund ‐ 01
2022‐2023 Proposed City Budget Fire, C‐8
DRAFT 6/8/2022
Department: Parks Recreation ‐ 4300
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 17,278                20,662        17,819      101,000        66,000      134,700 SEIU COLA, Unrep. EE COLA, step increase; Manager, maint. Lead, maint Salaries ‐ Part‐time 0125 12,176                19,150        18,110        20,000        20,000        20,000 fac. Coord, bldg attendant Salaries ‐ Temporary 0150 10,830         ‐                                137 ‐                   ‐                   ‐ Overtime 0200 ‐                   ‐                   ‐                   ‐                            1,200 ‐ Retirement ‐ PERS 0250 6,215                    6,715        16,458        18,000        15,000        10,400 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300 3,471                    3,400          3,038        10,000          8,000        12,500 Workers' Compensation 0350 2,158                    2,550          2,424          3,000          3,000          3,300 Based on estimate provided by CAJPIA Unemployment Insurance 0360 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Medical Insurance 0400 4,610                    4,400          3,150        24,000        10,000        20,300 estimate 10% increase Other Benefits 0450 (455)             ‐                                  27 ‐                   ‐                   ‐ Deferred Comp. 0545 1,184                    4,225          3,949          3,000          3,200          4,000 Dental Insurance 0560 379                            620              566          1,500              700          1,300 Vision Insurance 0570 52                                85                82              300              150              300 Sub‐total        57,898        61,807        65,759      180,800      127,250      206,800 SUPPLIES & SERVICES:

Utilities 1000 67,635                65,280        82,148        85,000        59,000        85,000 Annualized current year costs; PGE and City water; Leroy Park Communications 1150 2,313                    2,300          1,771          4,000          2,000          4,000 Annualized current year costs; Impulse, Verizon; Leroy Park Office Supplies & Postage 1200 108                            255              351              500              500              500 Advertising & Publication 1250 431                            500 ‐                   ‐                   ‐                   ‐ Business Exp. & Training 1300 39                              200                30                30              405 ‐ Memberships, dues,subscriptions 1350 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Maintenance 1400 93                              204                34              200 ‐                   ‐ Facility Maintenance 1450 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vehicle Maintenance 1460 71                 ‐                                    2 ‐                                361              400 Equipment Replacement 1500 ‐                   ‐                   ‐                            2,300              336         2,400 Locks Operating Supplies & Exp. 1550 3,794                    4,080          3,480          6,088          8,150        32,572 Copies, hardware store; Leroy Park; rec prog, tables storage concession ARPA Fuel & lubricants 1560 22                              102              222              400              670          1,000 Annualized current year costs, increase in fuel costs Elections 1600 ‐                   ‐                   ‐                   ‐                   ‐ Levys, Penalties/Interest 1650              144 ‐                                  12 ‐                   ‐                   ‐ Out‐of‐State Sales Taxes 1651 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Bank Service Charges 1750 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Labor Negotiations 2149 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Professional services 2150        29,465        38,600        39,623        40,781        40,781        50,500 Landscaping and uniforms; Leroy Park; central park booster pump replacement Information Technology Svs 2151 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Rental 2200 ‐                   ‐                   ‐                   ‐                                450 ‐ Liability Insurance 2300          2,301          2,754          5,833          6,000          6,000          7,000 per JPIA estimate Services by other Agencies 2350 32                 ‐                   ‐                   ‐                   ‐                   ‐ Recreation Programs NEW ‐                   ‐                   ‐ COVID19 2999 1,005           ‐                                603 ‐                                404 ‐ Sub‐total      107,452      114,275      134,110      145,299      119,057      183,372 CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Improve. other than Buildings 3150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Land 3170 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment 3200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Debt Service Interest 4100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Lease Purchase 4150 3,675                    4,590          2,254 ‐                   ‐                   ‐ Sub‐total          3,675          4,590          2,254 ‐                   ‐                   ‐ Department Total      169,024      180,672      202,124      326,099      246,307      390,172 NOTES General Fund ‐ 01
at 7.65%
2022‐2023 Proposed City Budget Parks and Rec, C‐9
DRAFT 6/8/2022
Department:Building Safety;
Permits; Planning ‐ 4405
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES: Permit Tech, associate planner
Salaries ‐ Regular 0100 54,038                54,400        65,651        89,000        72,000         153,800 SEIU COLA Salaries ‐ Part‐Time 0125 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Temporary 0150 ‐                   ‐                   ‐                            1,210 ‐                                1,210 for scanning with ARPA Overtime 0200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Retirement ‐ PERS 0250 17,955                17,800        20,320        34,000        32,000            39,800 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300 4,656                    4,400          5,304          7,000          6,000            12,000 Workers' Compensation 0350 3,455                    3,009          3,401          5,000          5,000              5,600 Based on estimate provided by CAJPIA Unemployment Insurance 0360 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Medical Insurance 0400 7,062                    6,700          8,036        10,000          9,000            17,100 estimate 10% increase Other Benefits 0450 (392)              ‐                   ‐                   ‐                   ‐                   ‐ Deferred Comp. 0545 ‐                   ‐                   ‐                            2,000          2,000              2,500 Dental Insurance 0560 353                            357              410              600              400              1,100 Vision Insurance 0570 59                                61                70              100              100                 200 Sub‐total        87,186        86,727      103,193      148,910      126,500         233,310 SUPPLIES & SERVICES:

Utilities 1000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Communications 1150 2,893                    2,900          2,160          2,500          1,500              1,500 Annualization of current year costs Office Supplies & Postage 1200 192                            200              281              400              300                 300 Annualization of current year costs Advertising and Pubs 1250 647                            650              148              650              200                 200 Annualization of current year costs Business Exp. & Training 1300 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Memberships, Dues & Subs 1350 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Maintenance 1400 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Facility Maintenance 1450 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Vehicle Maintenance 1460 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Replacement 1500 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Operating Supplies & Exp. 1550 547                            600              455              600          1,100              1,050 Annualization of current year costs Fuels and Lubricants 1560 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Elections 1600 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Out‐of‐State Sales Taxes 1651 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Bank Service Charges 1750 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Labor Negotiations 2149 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Professional Services 2150      209,723      110,000      132,224      131,000      110,000            60,000 Appel retirement and planning software annual Information Technology Svs 2151 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment Rental 2200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Liability Insurance 2300 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Services by other Agencies 2350 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total      214,004      114,350      135,268      135,150      113,100           63,050 CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Improve. other than Buildings 3150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Land 3170 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment 3200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Debt Service Interest 4100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Lease Purchase 4150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Department Total      301,189      201,077      238,460      284,060      239,600         296,360 General Fund ‐ 01 NOTES
at 7.65%
2022‐2023 Proposed City Budget Permits, C‐10
DRAFT 6/8/2022
Department: Cannabis ‐ HEMP
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 ‐
Salaries ‐ Part‐Time 0125 ‐
Temporary 0150 ‐
Overtime 0200 ‐
Retirement ‐ PERS 0250 ‐
FICA/Medicare 0300 ‐
Workers' Compensation 0350 ‐
Unemployment Insurance 0360 ‐
Medical Insurance 0400 ‐
Other Benefits 0450 ‐
Deferred Comp. 0545 ‐
Dental Insurance 0560 ‐
Vision Insurance 0570 ‐
Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ SUPPLIES & SERVICES:

Utilities 1000 ‐
Communications 1150 ‐
Office Supplies & Postage 1200 ‐
Advertising and Pubs 1250 ‐
Business Exp. & Training 1300 ‐
Memberships, Dues & Subs 1350 ‐
Equipment Maintenance 1400 ‐
Facility Maintenance 1450 ‐
Vehicle Maintenance 1460 ‐
Equipment Replacement 1500 ‐
Operating Supplies & Exp. 1550                50                50 ‐ Fuels and Lubricants 1560 ‐
Elections 1600 ‐
Out‐of‐State Sales Taxes 1651 ‐
Bank Service Charges 1750 ‐
Labor Negotiations 2149 ‐
Professional Services 2150        57,537        60,667 ‐                   HDL Information Technology Svs 2151 ‐                   ‐
Equipment Rental 2200 ‐
Liability Insurance 2300 ‐
Services by other Agencies 2350 ‐
Sub‐total ‐                   ‐                   ‐                          57,587         ‐                   60,717 CAPITAL OUTLAY:

Buildings 3100 ‐
Improve. other than Buildings 3150 ‐
Land 3170 ‐
Equipment 3200 ‐
Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐
Debt Service Interest 4100 ‐
Lease Purchase 4150 ‐
Sub‐total   ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Department Total ‐                   ‐                   ‐                          57,587        60,717 ‐ NOTES General Fund ‐ 01
2022‐2023 Proposed City Budget Cannabis, C‐11
DRAFT 6/8/2022

PUBLIC SAFETY FUND REVENUE
Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
3409 Electronic Fingerprinting           5,914           3,570           6,432           6,400           5,900           5,900 Annualized current year revenue 3410 Other Government Grants ‐ ‐ ‐ ‐ ‐ ‐
3496 Proposition 172 Revenue           9,502         10,200         12,773         11,600         22,100         22,500 Annualized current year revenue 3605 Interest Income           1,593           1,020              521              700              300              300 Laif Interest 3643 Misc Revenue ‐ ‐ ‐ ‐ ‐ ‐
3646 Surplus Property Sales         10,501           2,040 ‐ ‐ ‐ ‐ Total Police Safety Fund        27,510        16,830        19,725        18,700        28,300        28,700 3490 Other Government Grants         (1,000) ‐           5,744 ‐ ‐ ‐ 3496 Proposition 172 Revenue         12,969           8,160         12,773         11,600         11,100         11,500 Annualized current year revenue 3605 Interest Income           1,101              510              393              600              200              200 Laif Interest 3646 Surplus Property Sales ‐ ‐ ‐ ‐ ‐ ‐
Total Fire Safety Fund        13,070           8,670        18,910        12,200        11,300        11,700 TOTAL PUBLIC SAFETY:        40,632        25,500        38,635        30,900        39,600        40,400 FIRE SAFETY FUND ‐ 40

PUBLIC SAFETY REVENUE
POLICE SAFETY FUND ‐ 42
2022‐2023 Proposed City Budget Public Safety Funds, D‐1 DRAFT 6/8/2022
Prop 172, Fire ‐ 40
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 ‐
Salaries ‐ PartTime 0125 ‐
Salaries ‐ Temporary 0150 ‐
Salaries ‐ Overtime 0200 ‐
Retirement ‐ PERS 0250 ‐
FICA/Medicare 0300 ‐
Workers' Compensation 0350 ‐
Medical/Dental/Life insurance 0400 ‐
Other Benefits 0450 ‐
Dental Insurance 0560 ‐
Vision Insurance 0570 ‐
Sub‐total ‐                    ‐                    ‐
SUPPLIES & SERVICES:

Utilities 1000 ‐
Communications 1150 ‐
Office Supplies & Postage 1200 ‐
Advertising & Publication 1250 ‐
Business Ex and Tng 1300 ‐
Memberships, dues & subs. 1350 ‐
Equipment Maintenance 1400 ‐
Vehicle Maintenance 1460 ‐
Equipment replacement 1500 160                ‐                            13,974         32,395 Operating Supplies & Exp. 1550 677                ‐
Fuel & lubricants 1560 ‐
Professional services 2150 ‐
Property Rental 2250 ‐
Liability Insurance 2300 ‐
Services by other Agencies 2350 ‐
Sub‐total               837 ‐                            13,974 ‐                            32,395 ‐ CAPITAL OUTLAY:

Buildings 3100 ‐
Improve. Other than Buildings 3150 ‐
Land 3170 ‐
Equipment 3200 ‐
Sub‐total ‐                    ‐                    ‐

OTHER FINANCING USES
Debt Service Principal 4000 ‐
Debt Service Principal 4100 ‐
Lease Purchased 4150 ‐
Transfer to General Fund 5000 ‐
Sub‐total ‐                    ‐                    ‐
Fund Total               837 ‐                            13,974 ‐                            32,395 ‐ Prop. 172, Fire ‐ 40 NOTES
2022‐2023 Proposed City Budget Prop 172 Fire, D‐3
DRAFT 6/8/2022
Prop 172, Police ‐ 42
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 ‐
Salaries ‐ PartTime 0125 ‐
Salaries ‐ Temporary 0150 ‐
Salaries ‐ Overtime 0200 ‐
Retirement ‐ PERS 0250 ‐
FICA/Medicare 0300 ‐
Workers' Compensation 0350 ‐
Medical Insurance 0400 ‐
Other Benefits 0450 345                ‐
Dental Insurance 0560 ‐
Vision Insurance 0570 ‐
Sub‐total               345 ‐                    ‐
SUPPLIES & SERVICES:

Utilities 1000 ‐
Communications 1150 ‐
Office Supplies & Postage 1200 ‐
Advertising & Publication 1250 ‐
Business Ex and Tng 1300 ‐
Memberships, dues & subs. 1350 ‐
Equipment Maintenance 1400 ‐
Vehicle Maintenance 1460 ‐
Equipment replacement 1500 14,119          ‐                              2,076               882 Operating Supplies & Exp. 1550 ‐                              2,774         12,182 Fuel & lubricants 1560 ‐
Professional services 2150 88                  ‐
Property Rental 2250 ‐
Liability Insurance 2300 ‐
Services by other Agencies 2350 ‐
Sub‐total         14,207 ‐                              4,851 ‐                            13,064 ‐ CAPITAL OUTLAY:

Buildings 3100 ‐
Improve. Other than Buildings 3150 ‐
Land 3170 ‐
Equipment 3200 ‐
Explorers 3210 ‐
Sub‐total ‐                    ‐                    ‐

OTHER FINANCING USES
Debt Service Principal 4000 ‐
Debt Service Principal 4100 ‐
Lease Purchased 4150 ‐
Transfer to General Fund 5000 ‐
Sub‐total ‐                    ‐                    ‐
Fund Total         14,552 ‐                              4,851 ‐                            13,064 ‐ Prop 172, Police ‐ 42 NOTES
2022‐2023 Proposed City Budget Prop 172 Police, D‐2
DRAFT 6/8/2022

STREET FUND REVENUE
Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
3470 Measure A Tax Revenue      495,336      477,700      559,062      529,604      529,604      656,442 Per SBCAG TTAC staff report 3490 Other Government Grants ‐                   ‐                   ‐                          40,000         ‐                   38,693 Local Road Safety plan 3605 Interest Income        12,504        14,000          4,146          6,000          2,000              500 Laif Interest, rates low 3620 Miscellaneous Income ‐                   ‐                          40,814 ‐                   ‐                          20,000 Chevron from general fund Total Measure A      507,839      491,700      604,021      575,604      570,297      676,942 3430 SB1 Local Streets & Roads ‐                   ‐                   ‐                   ‐                   ‐                   ‐ 3455 Special Gas Tax ‐ 2103        54,053        66,234        53,914        69,249        64,843        87,657 gas tax per CA City Finance.com 3465 Special Gas Tax ‐ 2105        39,987        41,551        41,170        45,123        47,922        51,973 gas tax per CA City Finance.com 3466 Special Gas Tax ‐ 2106        24,869        26,456        25,524        27,405        28,687        30,748 gas tax per CA City Finance.com 3467 Special Gas Tax ‐ 2107        50,492        49,986        55,710        57,422        65,248        70,934 gas tax per CA City Finance.com 3468 Special Gas Tax ‐ 2107.5          2,000          2,000          2,000          2,000          2,000          2,000 gas tax per CA City Finance.com 3469 Regional Surface Transp Prgrm 106,91       6      108,678      108,678      108,678      108,678      108,000 assume similar to last year 3605 Interest Income          3,535          3,500          2,149          2,600          1,080              500 Laif Interest 3620 Miscellaneous Income ‐                   ‐                   ‐                   ‐                   ‐ 3,805 Transfer from General Fund ‐                   ‐                   ‐                   ‐                   ‐ Total Gas Tax      281,852      298,405      289,145      312,477      318,458      351,812 3475 LTF 99234‐Bike & Ped          5,187          6,171          6,679          6,805          8,121          8,870 Per SBCAG TTAC staff report 3605 Interest Income          3,389          3,500              949          1,300              400              400 Laif Interest Total LTF Roads          8,576          9,671          7,628          8,105          8,521          9,270 3430 SB1 Local Streets & Roads      136,627      148,000      148,071      153,211      165,363      190,244 gas tax per CA City Finance.com 3605 Interest Income              762              700              613              900              480              250 Laif Interest Total SB1 Local Streets & Roads 137,389            148,700      148,685      154,111      165,843      190,494 New SB1 SRTS      114,270 ‐                   ‐                   Safe Routes to School‐Construct 3605 Interest Income ‐                   ‐                   ‐ Total SB1 SRTS ‐                   ‐                   ‐                        114,270 ‐                   ‐ New ASHC                    ‐                   ‐      200,000 Mutimodal path design, Guardia 3605 Interest Income ‐                   ‐                   ‐ Total ASHC Pedestrian ‐                   ‐                   ‐                   ‐                   ‐                        200,000 TOTAL STREET REVENUE 1,486,853 1,335,813 1,049,479 1,164,567 1,063,119 1,428,518 SB1 LOCAL STREETS & ROADS ‐ 86

STREETS REVENUE
MEASURE A ‐ 71
GAS TAX ‐ 20
LTF, ROADS ‐ 22
SB1 SRTS ‐ 88
ASHC Pedestrian ‐ NEW
2022‐2023 Proposed City Budget Street Funds, E‐1
DRAFT 6/8/2022
Measure A ‐ 71
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100      138,879      143,300      119,253      138,000      123,000      152,300 SEIU COLA, Unrep. EE COLA, step increase, includes eng tech 33.33% Salaries ‐ part‐time 0125 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Salaries ‐ Temporary 0150           4,606 ‐                   ‐                   ‐                   ‐                   ‐ Overtime 0200              117           3,570               ‐                   157           1,500 ‐ Retirement ‐ PERS 0250         30,052         40,500         36,176         25,000         25,000         29,500 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300         10,870         11,400           8,704         10,000           9,000         11,400 Workers' Compensation 0350           7,706         11,300           8,912         12,000           9,000           9,800 Based on estimate provided by CAJPIA Unemployment Insurance 0360 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Medical Insurance 0400         26,675         30,565         22,076         29,000         22,000         36,300 estimate 10% increase Other Benefits 0450              ‐                   (155)               ‐                   461 ‐                   ‐ Deferred Compensation 0545 ‐                   ‐                                523 ‐                             2,000           2,000 Dental Insurance 0560           2,149           1,930           1,585           3,000           2,000           2,900 Vision Insurance 0570              197              190              165              300              200              400 Life Insurance 0585                 ‐                   69 ‐                   ‐                   ‐                   ‐ Sub‐total      221,165      242,755      198,011      217,300      193,700      244,600 SUPPLIES & SERVICES:

Utilities 1000           2,453           2,550           3,275           3,200           2,000           2,400 Annualized current year costs, increase 20% Communications 1150           3,054           3,000           2,283           3,200           2,300           2,300 Annualized current year costs Office Supplies & Postage 1200              151              150                14              150              150              150 Similar to prior year budget Advertising and Publications 1250              559              179              617              500              500              500 Annualized current year costs Business Expense and Trng 1300              229              180              370              250              250              250 Annualized current year costs Memberships, Dues & Subs 1350               ‐                   157               ‐                   108 ‐                   ‐ Equipment Maintenance 1400           1,439           1,400              368           1,400 ‐                   ‐                   Annualized current year costs Facilities Maintenance 1450 ‐                             1,530              624           1,000           1,000           1,000 Similar to prior year budget Vehicle Maintenance 1460 1,719                      1,530              335           4,000           4,000           4,000 More vehicle maint needed Equipment Replacement 1500 104                         2,040           9,715           3,000 ‐                           45,000 replace utility vehicle Operating Supplies & Expenses 1550         14,557         14,000         10,734         26,000         29,000         42,000 Annualized current year costs and equip for tree survey ATP Cycle 3 1555           8,155 ‐                   ‐                   ‐                   ‐                   ‐ Alternate Transportation Exp. 1559                19         40,800 ‐                   ‐                   ‐                   ‐                   see CIP Fuels & Lubricants 1560           6,310           6,120           5,975           7,000           9,500         11,500 Annualized current year costs; increase fuel cost Professional Services 2150         19,970         38,000         35,323         85,000      125,000      157,000 Similar to prior year budget and remove from native garden, urban fo Equipment Rental 2200 ‐                             3,060              748           2,000           1,000           1,000 Annualized current year costs Lease Payments 2249 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Liability Insurances 2300           5,232         13,260         11,037         10,000         10,000         10,000 per JPIA estimate Services by Other Agencies 2350                 ‐                   61 ‐                   ‐                   ‐                   ‐ Sub‐total         64,169      127,799         81,527      146,700      184,700      277,100 CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Improve. other than Buildings 3150 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Land 3170 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Equipment 3200 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Debt Service Interest 4100 ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Lease Purchase 4150           2,617           2,600 ‐                   ‐                   ‐                   ‐ Transfer to General Fund 5000         82,600         99,881         99,881         95,250         95,250      124,947 Transfer to Capital Improvement Fu 5089      235,255      686,000         18,455      774,000      516,988      610,200 see CIP Sub‐total      320,472      788,481      118,336      869,250      612,238      735,147 Fund Total      605,807   1,159,035      397,874   1,233,250      990,638   1,256,847 NOTES Measure A ‐ 71
at 7.65%
2022‐2023 Proposed City Budget Measure A, E‐2
DRAFT 6/8/2022
Gas Tax ‐ 20
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100 ‐
Salaries ‐ part‐time 0125 ‐
Salaries ‐ Temporary 0150 ‐
Overtime 0200 ‐
Retirement ‐ PERS 0250 ‐
FICA/Medicare 0300 ‐
Workers' Compensation 0350 ‐
Unemployment Insurance 0360 ‐
Medical/Life Insurance 0400 ‐
Other Benefits 0450 ‐
Deferred Compensation 0545 ‐
Dental Insurance 0560 ‐
Vision Insurance 0570 ‐
Sub‐total ‐                   ‐
SUPPLIES & SERVICES:

Utilities 1000 ‐
Communications 1150 ‐
Office Supplies & Postage 1200 ‐
Advertising and Publication 1250 ‐
Business Expense and Trng 1300 ‐
Memberships, Dues & Subs 1350 ‐
Equipment Maintenance 1400 ‐
Facilities Maintenance 1450 ‐
Vehicle maintenance 1460 ‐
Equipment Replacement 1500 ‐
Operating Supplies & Expenses 1550 ‐
Alternate Transportation Exp. 1559 ‐
Fuels & Lubricants 1560 ‐
Professional Services 2150               ‐                    320 SB1 Road Maint ‐ Engineering 2162 ‐
Equipment Rental 2200 ‐
Lease Payments 2249 ‐
Liability Insurances 2300 ‐
Services by Other Agencies 2350           3,000           3,000           3,000           3,000           3,000           3,000 Annual Street Report Bike & Pedestrian Expenses 2357 ‐
Sub‐total           3,320           3,000           3,000           3,000           3,000           3,000 CAPITAL OUTLAY:

Buildings 3100 ‐
SB1 Road Maintenance 3148 ‐
Improve. other than Buildings 3150 ‐
Land 3170 ‐
Equipment 3200 ‐
Sub‐total ‐                    ‐                    ‐
OTHER FINANCING USES:

Debt Service Principal 4000 ‐
Debt Service Interest 4100 ‐
Lease Purchase 4150        18,600        21,000         ‐                    ‐                    ‐                    12,840 Transfer to General Fund 5000 ‐                              2,719           2,719           3,150           3,150           1,353 Transfer to Capital Improvement F 5089        95,024      431,700        79,489      596,000      380,000      701,000 street rehab see CIP Sub‐total      113,624      455,419        95,048      599,150      383,150      702,353 Fund Total      116,944      458,419        98,048      602,150      386,150      705,353 NOTES Gas Tax ‐ 20
2022‐2023 Proposed City Budget Gas Tax, E‐3
DRAFT 6/8/2022
LTF Roads ‐ 22
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100
Salaries ‐ part‐time 0125
Salaries ‐ Temporary 0150
Overtime 0200
Retirement ‐ PERS 0250
FICA/MEDICARE 0300
Workers' Compensation 0350
Unemployment Insurance 0360
Medical Insurance 0400
Other Benefits 0450
Deferred Compensation 0545
Dental Insurance 0560
Life Insurance 0570
Sub‐total
SUPPLIES & SERVICES:

Utilities 1000
Communications 1150
Office Supplies & Postage 1200
Advertising and Publication 1250
Business Expense and Trng 1300
Memberships, Dues & Subs 1350
Equipment Maintenance 1400
Facilities Maintenance 1450
Vehicle maintenance 1460
Equipment Replacement 1500
Operating Supplies & Expenses 1550
Alternate Transportation Exp. 1559
Fuels & Lubricants 1560
Professional Services 2150
Equipment Rental 2200
Lease Payments 2249
Liability Insurances 2300
Services by Other Agencies 2350
Bike & Pedestrian Expenses 2357
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

Debt Service Principal 4000
Debt Service Interest 4100
Lease Purchase 4150
Transfer to General Fund 5000
Transfer to Capital Improvement F 5089        14,389 ‐                   ‐                            6,800          6,800          8,800 sidewalk repairs see CIP Sub‐total        14,389 ‐                   ‐                            6,800          6,800          8,800 Fund Total        14,389 ‐                   ‐                            6,800          6,800          8,800 NOTES LTF Roads ‐ 22
2022‐2023 Proposed City Budget LTF Roads, E‐4
DRAFT 6/8/2022
SB1 Streets and Roads ‐ 86
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100
Salaries ‐ part‐time 0125
Salaries ‐ Temporary 0150
Overtime 0200
Retirement ‐ PERS 0250
FICA/MEDICARE 0300
Workers' Compensation 0350
Unemployment Insurance 0360
Medical Insurance 0400
Other Benefits 0450
Deferred Compensation 0545
Dental Insurance 0560
Life Insurance 0570
Sub‐total
SUPPLIES & SERVICES:

Utilities 1000
Communications 1150
Office Supplies & Postage 1200
Advertising and Publication 1250
Business Expense and Trng 1300
Memberships, Dues & Subs 1350
Equipment Maintenance 1400
Facilities Maintenance 1450
Vehicle maintenance 1460
Equipment Replacement 1500
Operating Supplies & Expenses 1550
Alternate Transportation Exp. 1559
Fuels & Lubricants 1560
Professional Services 2150
Equipment Rental 2200
Lease Payments 2249
Liability Insurances 2300
Services by Other Agencies 2350
Bike & Pedestrian Expenses 2357
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

Debt Service Principal 4000
Debt Service Interest 4100
Lease Purchase 4150
Transfer to General Fund 5000
Transfer to Capital Improvement Fu 5089           2,028       260,000       109,371       139,000         89,000       380,000 street rehab and sidewalk see CIP Sub‐total           2,028       260,000       109,371       139,000         89,000       380,000 Fund Total           2,028       260,000       109,371       139,000         89,000       380,000 NOTES SB1 Streets & Roads ‐ 86
2022‐2023 Proposed City Budget SB1, E‐5
DRAFT 6/8/2022
SB1 SRTS ‐ 88
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100
Salaries ‐ part‐time 0125
Salaries ‐ Temporary 0150
Overtime 0200
Retirement ‐ PERS 0250
FICA/MEDICARE 0300
Workers' Compensation 0350
Unemployment Insurance 0360
Medical Insurance 0400
Other Benefits 0450
Deferred Compensation 0545
Dental Insurance 0560
Life Insurance 0570
Sub‐total
SUPPLIES & SERVICES:

Utilities 1000
Communications 1150
Office Supplies & Postage 1200
Advertising and Publication 1250
Business Expense and Trng 1300
Memberships, Dues & Subs 1350
Equipment Maintenance 1400
Facilities Maintenance 1450
Vehicle maintenance 1460
Equipment Replacement 1500
Operating Supplies & Expenses 1550
Alternate Transportation Exp. 1559
Fuels & Lubricants 1560
Professional Services 2150
Equipment Rental 2200
Lease Payments 2249
Liability Insurances 2300
Services by Other Agencies 2350
Bike & Pedestrian Expenses 2357
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

Debt Service Principal 4000
Debt Service Interest 4100
Lease Purchase 4150
Transfer to General Fund 5000
Transfer to Capital Improvement Fu 5089       114,270 ‐                    ‐                    Safe routes to school construction next FY Sub‐total ‐                    ‐                    ‐                          114,270 ‐                    ‐ Fund Total ‐                    ‐                    ‐                          114,270 ‐                    ‐ NOTES SB1 SRTS ‐ New
2022‐2023 Proposed City Budget SB1, E‐6
DRAFT 6/8/2022
ASHC Pedestrian
‐ NEW
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100
Salaries ‐ part‐time 0125
Salaries ‐ Temporary 0150
Overtime 0200
Retirement ‐ PERS 0250
FICA/MEDICARE 0300
Workers' Compensation 0350
Unemployment Insurance 0360
Medical Insurance 0400
Other Benefits 0450
Deferred Compensation 0545
Dental Insurance 0560
Life Insurance 0570
Sub‐total
SUPPLIES & SERVICES:

Utilities 1000
Communications 1150
Office Supplies & Postage 1200
Advertising and Publication 1250
Business Expense and Trng 1300
Memberships, Dues & Subs 1350
Equipment Maintenance 1400
Facilities Maintenance 1450
Vehicle maintenance 1460
Equipment Replacement 1500
Operating Supplies & Expenses 1550
Alternate Transportation Exp. 1559
Fuels & Lubricants 1560
Professional Services 2150
Equipment Rental 2200
Lease Payments 2249
Liability Insurances 2300
Services by Other Agencies 2350
Bike & Pedestrian Expenses 2357
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

Debt Service Principal 4000
Debt Service Interest 4100
Lease Purchase 4150
Transfer to General Fund 5000
Transfer to Capital Improvement Fu 5089 ‐                    ‐                          200,000 Mutimodal path design, Guardia/Gularte pedestrian Sub‐total ‐                    ‐                    ‐                    ‐                    ‐                          200,000 Fund Total ‐                    ‐                    ‐                    ‐                    ‐                          200,000 NOTES ASHC Pedestrian ‐ New
2022‐2023 Proposed City Budget ASHC, E‐7
DRAFT 6/8/2022

ENTERPRISE FUNDS
Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
3490 Other Government Grants ‐  ‐  ‐  ‐  ‐
3605 Interest Income         33,640         35,000         13,723         17,000           5,300           5,300 Interest from general fund interfund loan and LAIF, interest rates are dow 3620 Miscellaneous Income ‐  ‐            4,543 ‐            1,324         40,000 grant for turf replacement 3877 Transfer from ARPA ‐  ‐  ‐          33,250         33,250 ‐  water utility debt forgiveness ARPA 3900 Water Usage ‐ Residential       665,694       670,000       622,849       674,000       450,000       463,500 Annualized current year revenue plus 3% for utility rate study 3910 Water Service ‐ Residential       717,781       710,000       843,080       809,000       850,000       875,500 Annualized current year revenue plus 3% for utility rate study 3930 Water Usage ‐ Commercial       614,388       610,000    1,004,459       973,000    1,005,000    1,035,150 Annualized current year revenue plus 3% for utility rate study 3940 Water Service ‐ Commercial         51,393         50,053         56,868         56,000         58,800         60,564 Annualized current year revenue plus 3% for utility rate study 3943 Miscellaneous Income ‐  ‐  ‐  ‐  ‐  ‐
3962 Set‐up Fees           4,649           8,331           6,426           6,800           5,200           5,200 Annualized current year revenue 3965 Late Fees         28,737         63,598         13,467         25,000         10,800         16,800 3966 Shut off/ Turn On Fee ‐  ‐  ‐  ‐  ‐  ‐
3969 Prob Rpt, pull mtr ‐  ‐  ‐  ‐  ‐  ‐
3970 Connection Fees           1,316       153,000           4,364       108,000 ‐        108,000 Escalante Meadows, per Alice's estimate 3980 Meters         19,278           5,478         11,650           7,600         15,200         16,000 Annualized current year revenue, less GUSD meter from last year 3990 Uncollectable Accounts ‐  ‐  ‐  ‐  ‐  ‐
Total Water   2,136,877   2,305,460   2,581,429   2,709,650   2,434,874   2,626,014 3490 Other Government Grants            ‐  8,981          ‐  52,481 ‐  ‐ 3605 Interest                ‐  329               572                ‐  790 ‐  LAIF interest 3700 Developer Fees       116,662       102,340         80,920         63,070         89,250           9,520 8 Lots for Pasadera impact fees 3810 Trsfr from wtr op ‐  ‐  ‐  ‐  ‐  ‐
3970 Water Connection Fees         30,250         21,500         17,000         13,250         18,750           2,000 8 Lots for Pasadera impact fees 3975 Stand‐By Charges         41,764         35,000         29,654         35,000         35,000         35,000 assume similar to prior year budget Total Water Capital       197,986       158,840       180,627       112,110       143,000         46,520 3490 Other Government Grants ‐  ‐  ‐  ‐  ‐  ‐
3605 Interest         28,825         30,000                  ‐  62 ‐  ‐ 3610 Rental of Property ‐  ‐        134,666       168,000       168,000       168,000 Clay's septic lease 3620 Miscellaneous Income            ‐  2,591 ‐  ‐  ‐  ‐ 3950 Sewer Service Charges    1,644,003    1,644,455    1,875,250    1,839,000    1,820,000    1,874,600 Annualized current year revenue plus 3% for utility rate study 3962 Set up Fees           5,209           8,782           5,179           6,000           3,700           3,700 Annualized current year revenue 3965 Late Fee         31,299         39,306         10,935         20,000           8,000           8,000 Annualized current year revenue 3970 Connection Fees         12,223       215,000         15,941       215,000 ‐        215,000 Escalante Meadows, per Alice's estimate Total Wastewater Operating   1,724,150   1,937,543   2,042,033   2,248,000   1,999,700   2,269,300 3490 Other Government Grants         15,232       302,821         55,311        ‐  302,821       302,821 IRWM Grant 3605 Interest               482               400         13,200         17,000           6,165           4,000 LAIF Interest; int rates are low 3700 Developer Fees       453,750       322,500       255,000       198,750       281,250         30,000 8 Lots for Pasadera impact fees 3970 Connections Fees   ‐  ‐  ‐  ‐  ‐  ‐
Total Wastewater Capital       469,464       625,721       323,511       518,571       287,415       336,821 3490 Other Government Grants ‐  ‐  ‐  ‐          20,820 ‐  CalRecycle 3605 Interest Income ‐  ‐  ‐  ‐  ‐  ‐
3824 Transfer from Measure A ‐  ‐  ‐  ‐  ‐  ‐
3943 Miscellaneous Income ‐  ‐  ‐  ‐  ‐  ‐
3955 Refuse Service Charges           5,044           4,229           5,364 ‐  ‐  ‐ 3962 Set‐up Fees ‐                ‐  ‐  ‐  ‐  ‐
3965 Late Fees ‐  ‐  ‐  ‐  ‐  ‐
Total Solid Waste           5,044           4,229           5,364 ‐          20,820 ‐ TRANSIT ‐ 23
3401 Bus Passes           1,570           3,060 ‐            3,000           3,000           3,000 assume similar to prior year budget 3459 State Transit Assistance ‐          32,640 ‐        208,182       208,182         75,000 STA 3461 Low Carbon Transit Oper Program ‐  ‐  ‐  ‐  ‐  ‐
3463 Prop 1B Transportation Project ‐  ‐  ‐  ‐  ‐  ‐
3471 LTF 99260       353,254       270,300       354,783       307,300       366,703       400,490 Per TDA LTF Apportionment Est SBCAG TTAC Mar Agenda 3474 LTF Sec 5311       115,217         61,200         66,992         69,500         69,500         98,167 Per Public Works Director 3490 Other Government Grants        ‐  388,901 ‐        634,000           4,441    1,938,148 AHSC Amtrack, CRRSSA, LCTOP, 3CE, AHSC Bus Charger, CARES #2 3811 Transfer from ARPA ‐  ‐  ‐  ‐            2,453 ‐
3511 Fare Box Revenue         46,964         56,100               250         60,000         60,000         50,000 assumes Fares to resume in July 3603 LCTOP Interest Income ‐  ‐  ‐  ‐  ‐  ‐
3605 Interest Income           6,192           2,040           1,736           2,300           1,500           1,500 LAIF interest 3620 Miscellaneous Income         80,294 ‐        133,739 ‐  ‐  ‐ Total Transit       992,391       425,340       557,500   1,284,282       715,779   2,566,305 5,528,201   5,457,134   5,690,464   6,872,613   5,601,588   7,844,960 SOLID WASTE ‐ 15

TOTAL ENTERPRISE FUND REVENUE

ENTERPRISE FUND REVENUE
WATER OPERATING ‐ 10
WATER CAPITAL ‐ 30
WASTEWATER OPERATING ‐ 12
WASTEWATER CAPITAL ‐ 32
2022‐2023 Proposed City Budget Enterprise Funds, F‐1
DRAFT 6/8/2022
Water Operating ‐ 10
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100        193,663        196,980        210,804        200,000        179,000        210,100 Water Super + 1 Fieldworker, SEIU COLA, Unrep. EE COLA, step incre Salaries ‐ part‐time 0125 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Salaries ‐ Temporary 0150           ‐                     14,487             4,831           ‐                     10,000          20,000 temp EE Overtime 0200          17,491          18,870          15,401          17,000          17,000          19,800 Retirement ‐ PERS 0250          62,393          58,000          68,181          59,000          61,000          68,100 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300          16,536          15,242          17,941          18,000          16,000          18,300 Workers' Compensation 0350             9,013          11,730          13,306          18,000          15,000          17,400 Based on estimate provided by CAJPIA Unemployment Insurance 0360 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Medical Insurance 0400          33,188          42,380          40,317          49,000          38,000          54,900 estimate 10% increase Other Benefits 0450          12,789          12,240          11,828          12,000          12,700          12,700 Deferred Compensation 0545 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Dental Insurance 0560             3,252             3,247             3,246             4,000             3,000             4,000 Vision Insurance 0570                450                454                451                600                500                600 Sub‐total        363,263        359,143        386,307        387,600        342,200        425,900 SUPPLIES & SERVICES:

Utilities 1000        157,790        122,200        152,480        200,000        200,000        240,000 similar to prior year budget, increase 20% Communications 1150             6,746             6,700             5,493             6,700             4,500             4,500 annualized current year costs Office Supplies & Postage 1200             9,762             9,180          12,220          12,300          12,300          12,300 annualized current year costs, includes postage Advertising 1250             1,704             1,020             1,317             1,000             1,000             1,000 similar to prior year budget Business Expense and Trng 1300                319             1,530             1,149             1,500             1,500             1,500 similar to prior year budget Memberships, Dues & Subs 1350 ‐                                    510             2,385                500             1,300             2,280 annualized current year costs; Regional Water Efficiency Prg Equipment Maintenance 1400                   45             1,020                137             1,000             1,000             1,000 similar to prior year budget Facilities Maintenance 1450             9,368          10,000             1,850          13,000          13,000        128,000 aging facilities; compodonico reroute service Vehicle maintenance 1460 2,371                          2,300             1,741             2,300             2,300             2,300 similar to prior year budget Equipment Replacement 1500 264                              ‐                     1,020             1,000             1,000          81,000 includes replacement of F150 vehicle & backup well motor for pasadera well, pump maint Meters 1535          19,620          20,200          12,311          21,200          21,200          21,200 similar to prior year budget Operating Supplies & Exp. 1550          36,184          63,000          48,254          70,000          70,000          77,000 similar to prior year budget, for treatment of groundwater, chemica State Water 1553     1,036,515        950,000        901,530        982,000        982,000        650,000 per CCWA Ten year projection Fuel & lubricants 1560             6,056             6,630             3,810             5,000             5,000             6,000 annualized current year costs, increase in cost Bank Service Charges 1750             2,217             2,040             2,093             3,000             2,000             2,000 annualized current year costs Professional Services 2150          89,197        169,000        118,523        150,000        154,000        365,000 includes tank inspection, update water atlas; turf replacement grant, shortage contigency pl Information Technolgy Svs 2151                427                 ‐                     510 ‐                     ‐                     ‐ Equipment Rental 2200 ‐                                 4,000             3,939 ‐                     ‐                     ‐ Lease 2249                200                200                200                200                200                200 Annual lease Peggy Camp Liability Insurance 2300          30,886          54,000          59,729          47,000          54,000          61,200 Per JPIA estimate Services by other Agencies 2350          40,733          45,900             5,231          45,900          45,900          45,900 Annual fees, assume similar to prior budget Sub‐total     1,450,403     1,470,960     1,334,394     1,563,600     1,572,200     1,702,380 CAPITAL OUTLAY:

Buildings 3100 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Improve. Other than Buildings 3150 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Land 3170 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Equipment 3200 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Sub‐total ‐                     ‐                     ‐                     ‐                     ‐                     ‐ OTHER FINANCING USES:

Debt Service Principal 4000 ‐                                 6,160             6,160          44,891          45,586          47,616 COPS 00 and 05 Debt Service Interest 4100 34,850                    50,000          43,448          68,000          43,000          40,647 COPS:  2000; 2005 (see fund 32) Lease Purchase 4150             3,737          18,700             2,276             3,100             3,100             5,100 Copier lease Transfer to General Fund 5000        279,200        294,900        294,900        315,600        315,600        335,200 Transfer to Water Capital 5035 ‐                     ‐                     ‐                     ‐                     ‐                     ‐ Write‐offs 8000          31,591             5,100          75,877             5,100 ‐                     ‐                     annualized current year costs Sub‐total        349,378        374,860        422,661        436,691        407,286        428,563 Department Total     2,163,044     2,204,963     2,143,362     2,387,891     2,321,686     2,556,843 Depreciation        196,725        179,502        185,963        196,725        185,963        185,963 Total with Depreciation     2,359,769     2,384,465     2,329,325     2,584,616     2,507,649     2,742,806 NOTES Water Fund ‐ 10
at 7.65%
2022‐2023 Proposed City Budget Water Operating, F‐2
DRAFT 6/8/2022
Water Capital ‐ 30
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Professional Services 2150
Services By Other Agncs. 2350
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. Other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

Dept Service Principal 4000
Dept Service Interest 4100
Lease Purchase 4150
Transfer to CIP 5089 25,298           1,747,720      397,548   1,032,000          6,612   1,065,387 See Capital Improvement Project fund Transfer to General Fund 5000
Sub‐total        25,298 1,747,720      397,548 1,032,000          6,612 1,065,387 Fund Total        25,298 1,747,720      397,548 1,032,000          6,612 1,065,387 NOTES Water Capital Fund ‐ 30
2022‐2023 Proposed City Budget Water Capital, F‐3
DRAFT 6/8/2022
Wastewater Operating ‐ 12
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100           205,320         195,200         170,003         196,000         168,000         248,000 Super + 1 WWII, OIT, SEIU COLA, Unrep. EE COLA, step increas Salaries ‐ part‐time 0125                         ‐                      ‐ ‐                      ‐                      ‐                      ‐ Salaries ‐ Temporary 0150                7,778                      ‐ ‐                                10,000                      ‐ ‐ Overtime 0200             19,863           27,576           25,791           21,000           29,000           29,000 Retirement ‐ PERS 0250             66,566           34,690           47,235           30,000           28,000           36,900 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300             18,572           16,743           14,785           17,000           15,000           21,000 Workers' Compensation 0350                8,914           12,115           13,538           19,000           14,000           16,100 Based on estimate provided by CAJPIA Unemployment Insurance 0360                        ‐ ‐                      ‐                      ‐                      ‐                      ‐ Medical Insurance 0400             41,114           43,200           38,434           49,000           29,000           49,400 estimate 10% increase Other Benefits 0450             11,703           12,555           11,196           12,000           12,500           12,500 Deferred Compensation 0545 1,29                 0                      ‐                   99                      ‐             2,150             2,500 Dental Insurance 0560                2,805             2,752             2,648             4,000             3,000             3,400 Vision Insurance 0570                   373                 383                 375                 500                 300                 500 Sub‐total 0585           384,300         345,213         324,103         358,500         300,950         419,300 SUPPLIES & SERVICES:

Utilities 1000           255,105         224,400         324,954         269,000         280,000         336,000 Annualized current year costs, increase of 20% Communications 1150                5,447             5,450             4,662           12,000             8,500           12,000 similar to prior year budget Office Supplies & Postage 1200                9,702             8,900           11,926           12,000             7,000           12,000 similar to prior year budget Advertising and Publication 1250                    ‐ 442                                          ‐ 26                                       150                 150 Annualized current year costs Business Expense and Trng 1300                   229             2,040             1,367             2,000                 180             2,000 similar to prior year budget Memberships, Dues & Subs 1350                        ‐           23,210           23,450           27,600           28,291           40,000 State Water Board annual fee, other memberships have incre Equipment Maintenance 1400             36,745           51,000           44,830           53,200           30,000           53,200 similar to prior year budget Facilities Maintenance 1450 9,076                           10,200             3,109           10,200             2,200           10,200 similar to prior year budget Vehicle maintenance 1460 647                                1,530             1,519             1,500             2,200             2,200 Annualized current year costs Equipment Replacement 1500                6,248           61,200             1,852           61,000           10,300         259,000 similar to prior year budget; aerator & tractor replacement; g Improve‐Repairs 1505                1,958                      ‐                 641                      ‐ ‐                      ‐ Operating Supplies & Exp. 1550             20,774           32,640           31,960           36,000           36,000           36,000 Annualized current year costs Fuel & lubricants 1560                5,078             9,180             4,912             7,000             4,000             9,000 increase in fuel costs Lvys, Penaties and Interest 1650                   144                      ‐ ‐                      ‐                      ‐                      ‐ Bank Service Charges 1750                2,218             2,300             2,093             2,900             2,000             2,000 Annualized current year costs Professional Services 2150           142,210         183,000         166,401         190,500         228,000         478,000 Annualized current year costs; wastewater master plan & sew Information Technology Svs 2151                        ‐                 408                      ‐ ‐                      ‐                      ‐ Equipment Rental 2200                6,791             5,500                 477             2,680             2,680             2,680 similar to prior year budget Property Rental 2250                5,191             5,100             5,290             6,000             6,000             6,000 Pasquini Lease Liability Insurance 2300             18,283           40,000           43,231           30,000           40,000           40,000 per JPIA estimate Services by other Agencies 2350             20,123           20,400                 458                      ‐ ‐                      ‐                      under memberships Sub‐total           546,411         686,458         673,159         723,580         687,501     1,300,430 CAPITAL OUTLAY:

Buildings 3100                         ‐                      ‐ ‐                      ‐                      ‐                      ‐ Improve. Other than Buildings 3150                        ‐ ‐                      ‐                      ‐                      ‐                      ‐ Land 3170                        ‐ ‐                      ‐                      ‐                      ‐                      ‐ Equipment 3200                        ‐ ‐                      ‐                      ‐                      ‐                      ‐ Sub‐total                        ‐ ‐                      ‐                      ‐                      ‐                      ‐ OTHER FINANCING USES:

Dept Service Principal 4000                        ‐           22,000             2,200           25,000           25,000           26,600 COPS 00 Dept Service Interest 4100 18,541                        39,000           36,317           34,900           34,900           33,800 Sewer Lines (COPS 00) Lease Purchase 4150                3,737           34,000           32,081           14,100             8,000             6,400 copier lease Transfer to General Fund 5000           194,900         215,000         215,000         226,600         226,600         272,000 Sub‐total           217,178         310,000         285,597         300,600         294,500         338,800 Fund Total        1,147,888     1,341,671     1,282,860     1,382,680     1,282,951     2,058,530 Depreciation 461,14            6         474,982         443,885         474,982         443,885         443,885 Total with Depreciation        1,609,034     1,816,653     1,726,745     1,857,662     1,726,836     2,502,415 NOTES Wastewater Operating ‐ 12
at 7.65%
2022‐2023 Proposed City Budget Wastewater Operating, F‐4 DRAFT 6/8/2022
Wastewater Capital ‐ 32
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Professional Services 2150 ‐                   ‐
Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ CAPITAL OUTLAY:

Buildings 3100 ‐                   ‐
Improve. Other than Buildings 3150 2,842                  30,000 ‐ Land 3170 ‐                   ‐
Equipment 3200 ‐                   ‐
Sub‐total          2,842        30,000 ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Dept Service Principal 4000 ‐                   ‐
Dept Service Interest 4100 ‐                   ‐
Lease Purchase 4150 ‐                   ‐
Transfer to General Fund 5000 ‐                   ‐
Transfer to CIP Fund 5089 179,809         3,396,541      160,030   3,979,821   1,733,944   1,843,208 See Capital Improvement Project fund Sub‐total      179,809 3,396,541      160,030 3,979,821 1,733,944 1,843,208 Fund Total      182,651 3,426,541      160,030 3,979,821 1,733,944 1,843,208 Wastewater Capital Fund ‐ 32 NOTES
2022‐2023 Proposed City Budget Wastewater Capital, F‐5
DRAFT 6/8/2022
Solid Waste ‐ 15
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Advertising & Publication 1250
Equipment maintenance 1400
Fuel & Lubricants 1560
HSS ‐ Service Provider 2110
Professional Services 2150 20,820 Calrecyle
Equipment Rental 2200
Liability Insurance 2300
Franchise Fees 2992
CA Beverage Container Fund 2994
Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                           20,820 CAPITAL OUTLAY:

Buildings 3100
Improve. Other than Buildings 3150 ‐                   ‐ Land 3170
Equipment 3200
Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ OTHER FINANCING USES:

Dept Service Principal 4000
Dept Service Interest 4100
Lease Purchase 4150
Transfer to General Fund 5000
Sub‐total ‐                   ‐                   ‐                   ‐                   ‐                   ‐ Fund Total ‐                   ‐                   ‐                   ‐                   ‐                           20,820 NOTES Solid Waste ‐ 15
2022‐2023 Proposed City Budget Solid Waste, F‐6
DRAFT 6/8/2022
Transit ‐ 23
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100         15,000 PW Director
Salaries ‐ part‐time 0125 ‐
Salaries ‐ Temporary 0150 ‐
Overtime 0200 ‐
Retirement ‐ PERS 0250           7,100 per Calpers employer contrib. rates and unfunded Liab.

FICA/Medicare 0300           1,100
Workers' Compensation 0350 ‐
Unemployment Insurance 0360 ‐
Medical Insurance 0400           2,600 estimate 10% increase Other Benefits 0450 ‐
Deferred Compensation 0545 ‐
Dental Insurance 0560               200
Vision Insurance 0570                 30
Sub‐total 0585 ‐                    ‐                    ‐                    ‐                    ‐                            26,030 SUPPLIES & SERVICES:

Advertising and Publication 1250 58                            5,000 ‐                        18,000         18,000           5,000 new transit plan Memberships and Dues 1350 ‐                ‐                ‐                ‐                          1,000           2,600 CalACT procurement services, trillium Equipment Maintenance 1400 104,609                73,000         39,866         73,000         56,800       130,000 vehicle maintenance Facilieis Maintenance 1450 ‐                ‐                                 ‐                33 ‐                ‐ Equipment Replacement 1500 ‐                ‐                ‐                ‐                ‐                ‐ Operating Supplies 1550 ‐                ‐                              131 ‐                              130         25,000 contactless pay Fuel & lubricants 1560 41,737                  68,350         23,610         68,350         53,300       130,000 fuel cost increase Professional Services 2150 ‐                          1,500         28,497           1,500           5,330           5,000 contactless pay Equipment Rental 2200 1,427                          500               523               500           1,500           1,500 rental for bus outages Liability Insurance 2300 ‐                ‐                ‐                ‐                ‐                ‐ Purchased Transportation 2354 301,25        6       354,578       261,889       355,000       355,000       540,000 increase to Smooth contract LCTOP funded promotion 2358 ‐                ‐                ‐                ‐                ‐                ‐ Sub‐total       449,086       502,928       354,549       516,350       491,060       839,100 CAPITAL OUTLAY:

Buildings 3100 ‐                ‐                ‐                ‐                ‐                ‐ Improve. Other than Buildings 3150 ‐                ‐                ‐                ‐                ‐                ‐ Land 3170 ‐                ‐                ‐                ‐                ‐                ‐ Equipment 3200 ‐                ‐                ‐                ‐                ‐                ‐ Sub‐total ‐                ‐                ‐                ‐                ‐                ‐ OTHER FINANCING USES:

Dept Service Principal 4000 ‐                ‐                ‐                ‐                ‐                ‐ Dept Service Interest 4100 ‐                ‐                ‐                ‐                ‐                ‐ Lease Purchase 4150 ‐                ‐                ‐                ‐                ‐                ‐ Transfer to General Fund 5000 35,000                  35,000        35,000         35,000         35,000         76,200 Transfer to CIP Fund 5089 ‐                ‐                ‐                      291,729         57,206   1,800,000 Infrastructure improvement, see CIP Sub‐total         35,000         35,000         35,000       326,729         92,206   1,876,200 Fund Total       484,086       537,928       389,549       843,079       583,266   2,741,330 Depreciation 135,011              109,030       126,142       135,011       126,142       126,142 Total with Depreciation       619,097       646,958       515,691       978,090       709,408   2,867,472 at 7.65%
NOTES Transit ‐ 23
2022‐2023 Proposed City Budget Transit, F‐7
DRAFT 6/8/2022

MISCELLANEOUS FUNDS
Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
LIBRARY FUND ‐ 28
3484 Other Revenue               ‐                ‐               ‐ ‐               ‐               ‐ 3605 Interest Income              254              250              170              300              100              100 Laif interest 3700 Developer Fees         24,200         17,200         13,600         10,600         15,000           1,600 8 Pasadera Lots impact fees 3805 Transfer from General Fund           6,187 ‐               ‐                         5,000           5,000           5,000 To cover rent 3819 Transfer from Cap Fac Fund               ‐ ‐               ‐               ‐               ‐               ‐ Total Library Fund        30,641        17,450        13,770        15,900        20,100           6,700 PUBLIC FACILITIES ‐ 36
3605 Interest              267              290                 84              100                 50                 50 Laif interest 3721 Public Facility Fees           3,922           8,870 ‐                         8,900 ‐                         8,900 Escalante Meadows estimate Total Public Facilities           4,189           9,160                84           9,000                50           8,950 PARK DEVELOPMENT ‐ 38
3484 Other Revenue 49,281          ‐               ‐               ‐               ‐               ‐ 3510 Park & Recreation Fees               ‐ ‐               ‐               ‐               ‐               ‐ 3605 Interest Income           5,141              320              129              170              170              170 Laif interest 3490 Other Government Grants               ‐      200,000               ‐         50,000         50,000 ‐               Tmobile 3705 Impact Fees           5,826         12,000           4,257         12,000 ‐                       12,000 Escalante Meadows estimate 3877 Transfer from ARPA               ‐ ‐               ‐                       25,000         25,000 ‐               for O'connell play structre Total Park Development        60,248      212,320           4,386        87,170        75,170        12,170 CAPITAL FACILITIES ‐ 76
3605 Interest Income 18,367                  19,000           3,833           5,500           1,500           1,500 Laif interest 3620 Miscellaneous Income                ‐               ‐            ‐               3,500 ‐               ‐ 3700 Developer Fees               ‐ ‐               ‐               ‐               ‐               ‐ 3877 Transfer from ARPA               ‐ ‐               ‐               ‐                         1,350 ‐ Total Capital Facilities        18,367        19,000           7,333           5,500           2,850           1,500 CITY HALL EQUIPMENT ‐ 78
3605 Interest Income              291              300              143              200                 80                 80 Laif interest 3700 Developer Fees           9,680           6,880           5,440           4,240           6,000              640 8 Pasadera Lots impact fees Total City Hall Equipment           9,971           7,180           5,583           4,440           6,080              720 TRAFFIC FEES ‐ 87
3605 Interest Income 1,451                      1,500              698           1,000              300              300 Laif interest 3710 Mitigation Fees 46,686                  26,918         21,284         16,589         23,475           2,504 8 Pasadera Lots impact fees Total Traffic Fees 48,136                28,418        21,982        17,589        23,775           2,804 3605 Interest ‐ 58              201 ‐               ‐               ‐               ‐               ‐ 3620 Misc Income         30,000 ‐                       15,591      300,000      422,349 ‐               donation from SM Valley Chambe 3490 Leroy Park 386,324         4,200,000   2,233,181   2,310,000    ‐               2,761,084 Leroy Park expected to be comple 3490 Other Government Grants                ‐               ‐ ‐                    177,952      177,952 ‐               Prop. 68 per capita funds, $177k t 3605 Interest ‐ 100           5,750           3,000           1,884           3,500              300 ‐               Laif interest 3605 Interest ‐ 67, 58                 48                 50                    ‐               6 ‐               ‐ 3877 Transfer from ARPA               ‐ ‐               ‐                       20,000         48,200         30,800 Los Amigos de Guadalupe Total CDBG Miscellaneous      422,323   4,203,050   2,250,662   2,811,452   3,409,885        30,800 3605 Interest               ‐
3490 Other Government Grants         27,981      200,000         56,695 ‐               runs out in FY22 Total CDBG CV1               ‐ ‐                      27,981      200,000        56,695               ‐ 3605 Interest               ‐
3490 Other Government Grants               ‐ ‐                       10,120      239,880 Total CDBG Microenterprise               ‐ ‐               ‐               ‐                      10,120      239,880 3605 Interest               ‐
3490 Other Government Grants               ‐ ‐                       15,751      292,377 Total CDBG CV2/3               ‐ ‐               ‐               ‐                      15,751      292,377 3605 Interest               ‐
3490 Other Government Grants               ‐ ‐               ‐                 4,887,084 Total CDBG Central Park               ‐ ‐               ‐               ‐               ‐                 4,887,084 3605 Interest               ‐
3490 Other Government Grants               ‐ ‐               ‐                 1,700,000 Total CDBG Leroy Building               ‐ ‐               ‐               ‐               ‐                 1,700,000 3605 Interest               ‐
3490 Other Government Grants               ‐ ‐               ‐                    170,734 Total CDBG Leroy Building               ‐ ‐               ‐               ‐               ‐                    170,734 593,877   4,496,578   2,331,780   3,151,051   3,620,476   7,353,719

MISCELLANEOUS FUND REVENUE
CDBG MISCELLANEOUS ‐ 100,77,58,66,67
TOTAL MISC. FUND REVENUE
CDBG CV1 ‐ 105
CDBG Microenterprise ‐ 106
CDBG CV2/3 ‐ 107
CDBG Central Park ‐ 109
CDBG Leroy Building ‐ NEW
CDBG Urban Forest ‐ NEW
2022‐2023 Proposed City Budget Miscellaneous Funds, G‐1 DRAFT 6/8/2022
Library Fund ‐ 28
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Professional Services 2150
Equipment Rental 2200
Property Rental 2250 10,127                15,000        14,000        15,000        15,000        15,000 Similar to prior year Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total        10,127        15,000        14,000        15,000        15,000        15,000 CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

InterFund Transfer 5010
Sub‐total
Fund Total        10,127        15,000        14,000        15,000        15,000        15,000 Guadalupe Library Fund ‐ 28 NOTES
2022‐2023 Proposed City Budget Library, G‐2
DRAFT 6/8/2022
Public Facilities ‐ 36
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Professional Services 2150
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total
OTHER FINANCING USES:

InterFund Transfer 5010
Sub‐total
Fund Total ‐                   ‐                   ‐
Public Facilities ‐ 36 NOTES
2022‐2023 Proposed City Budget Public Facilities,G‐3
DRAFT 6/8/2022
Park Development ‐ 38
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Operating Supplies/Expense 1550 805
Professional Services 2150
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total              805
CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170 ‐
Equipment 3200
Sub‐total
OTHER FINANCING USES:

Transfer to CDBG fund 100        150,000
Transfer to Capital Projects Fund 5089 ‐                         200,000 ‐                           75,000           75,000 ‐ Sub‐total ‐                         200,000 ‐                           75,000        225,000 ‐ Fund Total              805      200,000 ‐                           75,000        225,000 ‐ Park Development ‐ 38 NOTES
2022‐2023 Proposed City Budget Park Development Fund, G‐4 DRAFT 6/8/2022
Capital Facilities ‐ 76
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000                   ‐
Equipment Maintenance 1400                   ‐
Operating Supplies 1550                   ‐              518 Professional Services 2150 85,694                47,375           ‐                   ‐                   5,480 Equipment Rental 2200                   ‐
Property Rental 2250                   ‐
Liability Insurance 2300                   ‐
Service from Other Agencies 2350                   ‐
Sub‐total        85,694        47,375          5,998 ‐                   ‐                   ‐ CAPITAL OUTLAY:

Buildings 3100 54,199              190,000 ‐                   ‐                   ‐ Improve. other than Buildings 3150
Land 3170
Equipment 3200 169,339            230,000      124,359      147,000      105,000        70,000 see prog of projects Sub‐total 223,538            420,000      124,359      147,000      105,000        70,000 OTHER FINANCING USES:

Interfund Transfer to Capital Proje 5089 1,000                179,539          1,060      484,537          8,516      459,537 CIP, see prog of projects Sub‐total 1,000                179,539          1,060      484,537          8,516      459,537 Fund Total 310,232            646,914      131,418      631,537      113,516      529,537 Capital Facilities ‐ 76 NOTES
2022‐2023 Proposed City Budget Capital Facilities, G‐5
DRAFT 6/8/2022
City Hall Equipment ‐ 78
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Professional Services 2150        25,000 ‐                          25,000 Council meeting public access improvements Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total        25,000 ‐                          25,000 CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

InterFund Transfer 5010
Sub‐total
Fund Total        25,000 ‐                          25,000 City Hall Equipment ‐ 78 NOTES
2022‐2023 Proposed City Budget City Hall, G‐6
DRAFT 6/8/2022
TRAFFIC MITIGATION FUND ‐ 87
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Professional Services 2150
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total
OTHER FINANCING USES:

Interfund Transfer to Capital Proje 5089        60,000        38,227      120,000 Street Rehab, see CIP Sub‐total        60,000        38,227      120,000
Fund Total        60,000        38,227      120,000
Traffic Mitigation ‐ 87 NOTES
2022‐2023 Proposed City Budget Traffic Mitigation, G‐7
DRAFT 6/8/2022
CDBG Miscellaneous ‐ Leroy Park
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Professional Services 2150
General Admin 2164 73,637               207,000       159,903          27,000          45,691          30,800 Los Amigos de Guad ARPA Planning 2165 32,54         0         58,000         30,213          43,000          13,294 Leroy Park 2166 ‐
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total      106,177       265,000       190,117         70,000         58,985         30,800 CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total
OTHER FINANCING USES:

Transfer to General Fund 5000 8,000                   30,000          ‐                29,492 ‐ Transfer to Capital Improvement f new 351,253          3,850,000    2,918,842    2,000,000    2,511,578                    ‐ Leroy Park Sub‐total      359,253   3,880,000   2,948,334    2,000,000    2,511,578                    ‐ Fund Total      465,430   4,145,000   3,138,450    2,070,000    2,570,563         30,800 CDBG, Funds 58, 66, 67, 77, 100 NOTES
2022-2023 Proposed City Budget CDBG Leroy Park, G-8
DRAFT 6/8/2022
CDBG CV1 ‐ 105
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400          10,000
Operating Supplies 1550           1,797
Professional Services 2150           8,977       190,000 General Admin 2164              551            3,065
Planning 2165
Activity 2166          43,437
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total ‐                   ‐                            11,325       200,000          46,502 ‐ CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐                            26,831
Sub‐total         26,831
OTHER FINANCING USES:

Transfer to General Fund 5000
Transfer to Capital Improvement f new
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                    ‐ Fund Total ‐                   ‐                            38,156       200,000          ‐                    46,502 NOTES CDBG CV1 ‐ 105
2022-2023 Proposed City Budget CDBG CV1, G-9
DRAFT 6/8/2022
CDBG Microenterprise ‐ 106
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Operating Supplies 1550
Professional Services 2150
General Admin 2164          10,120            7,380
Planning 2165
Activity 2166 232,50        0
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total ‐                   ‐                    ‐                    ‐                             10,120       239,880 CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total ‐
OTHER FINANCING USES:

Transfer to General Fund 5000
Transfer to Capital Improvement f new
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                    ‐ Fund Total ‐                   ‐                    ‐                    ‐                            10,120       239,880 NOTES CDBG Microenterprise ‐ 106
2022-2023 Proposed City Budget CDBG Micro, G-10
DRAFT 6/8/2022
CDBG CV2/3 ‐ 107
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Operating Supplies 1550
Professional Services 2150
General Admin 2164          15,751          24,305
Planning 2165
Activity 2166       268,072
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total ‐                   ‐                    ‐                    ‐                             15,751       292,377 CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total ‐
OTHER FINANCING USES:

Transfer to General Fund 5000
Transfer to Capital Improvement f new
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                    ‐ Fund Total ‐                   ‐                    ‐                    ‐                            15,751       292,377 NOTES CDBG CV2/3 ‐ 107
2022-2023 Proposed City Budget CDBG CV2/3, G-11
DRAFT 6/8/2022
CDBG Central Park ‐ 109
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Operating Supplies 1550
Professional Services 2150            5,030
General Admin 2164
Planning 2165
Activity 2166
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total ‐                   ‐                    ‐                    ‐                               5,030 ‐ CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total ‐
OTHER FINANCING USES:

Transfer to General Fund 5000
Transfer to Capital Improvement f new    4,882,054
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                       4,882,054 Fund Total ‐                   ‐                    ‐                    ‐                               5,030    4,882,054 NOTES CDBG Central Park ‐ 109
2022-2023 Proposed City Budget CDBG Central Park, G-12
DRAFT 6/8/2022
CDBG Leroy Building ‐ NEW
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Operating Supplies 1550
Professional Services 2150
General Admin 2164
Planning 2165
Activity 2166
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                    ‐ CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total ‐
OTHER FINANCING USES:

Transfer to General Fund 5000
Transfer to Capital Improvement f new    1,700,000
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                       1,700,000 Fund Total ‐                   ‐                    ‐                    ‐                    ‐                       1,700,000 NOTES CDBG Leroy Building ‐ NEW
2022-2023 Proposed City Budget CDBG Leroy Building, G-13 DRAFT 6/8/2022
CDBG Urban Forest ‐ NEW
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Equipment Maintenance 1400
Operating Supplies 1550
Professional Services 2150
General Admin 2164          37,500
Planning 2165
Activity 2166 133,23        4
Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Service from Other Agencies 2350
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                          170,734 CAPITAL OUTLAY:

Buildings 3100
Improve. other than Buildings 3150
Land 3170
Equipment 3200 ‐
Sub‐total ‐
OTHER FINANCING USES:

Transfer to General Fund 5000
Transfer to Capital Improvement f new
Sub‐total ‐                   ‐                    ‐                    ‐                    ‐                    ‐ Fund Total ‐                   ‐                    ‐                    ‐                    ‐                          170,734 NOTES CDBG Urban Forest ‐ NEW
2022-2023 Proposed City Budget CDBG Urban Fores, G-14
DRAFT 6/8/2022

LIGHTING FUNDS
LIGHTING/LANDSCAPE ‐ 60 Actual Budget Actual Budget Estimate Budget REVENUE SUMMARY 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23 3145  Tax Increments 24,761                23,460        23,760        28,500        28,500        29,195 Estimated based on growth ra 3605  Interest Income              605              600              212              300              100              100 Laif Interest 3620 Miscellaneous Income                ‐               ‐               ‐               ‐               ‐               ‐ 3877 Transfer from ARPA                ‐               ‐               ‐          2,787          2,787 ‐ TOTAL REVENUE        25,366        24,060        23,972        31,587        31,387        29,295 PASADERA LANDSCAPE Actual Budget Estimate Budget Estimate Budget & LIGHTING DISTRICT ‐ 63 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23 3145  Tax Increments        95,737        95,700      100,290      100,000      100,000      102,440 Estimated based on growth ra 3605  Interest Income              840              800              879          1,100              600              600 Laif Interest TOTAL REVENUE        96,577        96,500      101,169      101,100      100,600      103,040 LIGHTING DISTRICT ‐ 65 Actual Budget Estimate Budget Estimate Budget REVENUE SUMMARY 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23 3145  Tax Increments 123,717              81,600      141,812      135,700      135,700      139,011 Estimated based on growth ra 3605  Interest Income        12,597        13,000          5,849          6,500          2,200          2,200 Laif Interest and interfund loa 3620 Miscellaneous Income                ‐               ‐               ‐               ‐               ‐               ‐ TOTAL REVENUE      136,314        94,600      147,661      142,200      137,900      141,211 TOTAL LIGHTING FUNDS REVENUE 258,257            215,160      272,802      274,887      269,887      273,546 2022‐2023 Proposed City Budget Lighting Funds, H‐1
DRAFT 6/8/2022
Light. Landscape District ‐ 60
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100
Salaries ‐ Part‐time 0125
Salaries ‐ Temporary 0150
Salaries ‐ Overtime 0200
Retirement ‐ PERS 0250
FICA/Medicare 0300
Workers' Compensation 0350
Medical/Dental/life ins 0400
Other Benefits 0450
Dental Insurance 0560
Vision Insurance 0570
Sub‐total
SUPPLIES & SERVICES:

Utilities 1000          8,814        10,710          7,993        10,000          2,000        10,000 similar to prior year budget Communications 1150 ‐
Office Supplies & Postage 1200 ‐
Advertising & Publication 1250              115                56              114              100              110              110 Annualized of current year costs Business Ex and Tng 1300 ‐
Memberships, dues & sub. 1350 ‐
Equipment Maintenance 1400 ‐
Vehicle Maintenance 1460 ‐
Equipment replacement 1500 ‐                                109 Operating Supplies & Exp. 1550 ‐
Fuel & lubricants 1560 ‐
Professional services 2150          6,390          6,834          7,268          9,887          5,657          6,000 Annualized of current year costs Liability Insurance 2300              290              459              659              570              570              640 Per JPIA estimate Services from other agencies 2350 ‐
Sub‐total        15,609        18,059        16,142        20,557          8,337        16,750 CAPITAL OUTLAY:

Buildings 3100
Improve. Other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total

OTHER FINANCING USES
Transfer to General Fund 5000          3,867          2,346          2,266          2,171          2,171          1,639 Cost Allocation Study Sub‐total          3,867          2,346          2,266          2,171          2,171          1,639 Fund Total        19,476        20,405        18,408        22,728        10,508        18,389 NOTES Light. & Landscape District ‐ 60
2022‐2023 Proposed City Budget Lighting Landscaping District, H‐2 DRAFT 6/8/2022
Pasadera Light Lndscp Dist‐63
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100
Salaries ‐ Part‐time 0125
Salaries ‐ Temporary 0150
Salaries ‐ Overtime 0200
Retirement ‐ PERS 0250
FICA/Medicare 0300
Workers' Compensation 0350
Medical/Dental/life ins 0400
Other Benefits 0450
Dental Insurance 0560
Vision Insurance 0570
Sub‐total
SUPPLIES & SERVICES: ‐
Utilities 1000 ‐                          10,838        10,530         ‐                   10,900        17,620 Similar to prior year budget, pasadera lot 5 Communications 1150
Office Supplies & Postage 1200
Advertising & Publication 1250              117              110              100 Business Ex and Tng 1300
Memberships, dues & sub. 1350
Equipment Maintenance 1400
Vehicle Maintenance 1460
Equipment replacement 1500
Operating Supplies & Exp. 1550
Fuel & lubricants 1560
Homeland Security 1754
Professional services 2150        28,875              666        16,755        17,500        17,500        28,500 consultant services, pasadera lot 5 landscape Liability Insurance 2300
Services from other agencies 2350
Sub‐total        28,992        11,504        27,395        28,400        17,600        46,120 CAPITAL OUTLAY:

Buildings 3100
Improve. Other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total

OTHER FINANCING USES
Transfer to General Fund 5000          1,444          1,474          1,474          4,514 Sub‐total          1,444          1,474          1,474          4,514 Fund Total        28,992        11,504        28,839        29,874        19,074        50,634 NOTES Pasadera Light & Lndscp Dist‐63
2022‐2023 Proposed City Budget Pas Lighting and Landscape, H‐3 DRAFT 6/8/2022
Lighting District ‐ 65
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
PERSONNEL SERVICES:

Salaries ‐ Regular 0100
Salaries ‐ Part‐time 0125
Salaries ‐ Temporary 0150
Salaries ‐ Overtime 0200
Retirement ‐ PERS 0250
FICA/Medicare 0300
Workers' Compensation 0350
Medical/Dental/life ins 0400
Other Benefits 0450
Dental Insurance 0560
Vision Insurance 0570
Sub‐total
SUPPLIES & SERVICES:

Utilities 1000        44,385        52,460        37,718        50,000        62,834        65,000 annualized current year costs Communications 1150
Office Supplies & Postage 1200
Advertising & Publication 1250              115                60              105              100              100              100 annualized current year costs Business Ex and Tng 1300
Memberships, dues & sub. 1350
Equipment Maintenance 1400
Vehicle Maintenance 1460
Equipment replacement 1500
Operating Supplies & Exp. 1550
Fuel & lubricants 1560
Homeland Security 1754
Professional services 2150           1,980
Liability Insurance 2300              708              177           1,386           1,800 Services from other agencies 2350
Sub‐total        47,188        52,520        38,000        50,100        64,320        66,900 CAPITAL OUTLAY:

Buildings 3100
Improve. Other than Buildings 3150
Land 3170
Equipment 3200
Sub‐total

OTHER FINANCING USES
Transfer to General Fund 5000           9,033           7,752           6,590           6,155           6,155           6,547 Sub‐total           9,033           7,752           6,590           6,155           6,155           6,547 Fund Total        56,221        60,272        44,590        56,255        70,475        73,447 NOTES Lighting District ‐ 65
2022-2023 Proposed City Budget Lighting Dist, H-4
DRAFT 6/8/2022

SUCCESSOR AGENCY
Actual Budget Actual Budget Estimate Budget
2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
3145 Property Tax 532,382              622,200       528,796       650,000       650,000       650,000 Similar to prior year budge 3490 Other Government Grants       233,433       153,000       113,690       150,000         98,567         71,528 remaining RR's submitted f 3499 Revenue from Other Agencies ‐ ‐ ‐ ‐ ‐
3605 Interest Income           5,017              510              947           1,500              500              500 Laif interest 3610 Rental of Property ‐ ‐ ‐ ‐ ‐
3620 Miscellaneous Income ‐ ‐ ‐ ‐ ‐
Total Operating Fund      770,832      775,710      643,434      801,500      749,067      722,028 3490 Other Government Grants ‐ ‐ ‐ ‐   5,100,000 Royal Theater Grant 3605 Interest Income         12,193           8,160           3,553           5,000              800              800 Laif interest 3610 Rental of Property ‐ ‐ ‐ ‐ ‐
Total Bond Refinance Fund         12,193           8,160           3,553           5,000              800   5,100,800 783,025      783,870      646,987      806,500      749,867   5,822,828

SUCCESSOR AGENCY REVENUE
SUCCESSOR AGENCY OPERATING ‐ 26
BOND REFINANCE FUND ‐ 91/79

TOTAL SUCCESSOR AGENCY REVENUE
2022‐2023 Proposed City Budget Successor Agency, I‐1
DRAFT 6/8/2022
RDA Bond Refinance ‐ 91/79
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000
Office Supplies & Postage 1200
Advertising and Pubs 1250
Business Expense and Trng 1300
Memberships, Dues & Subs 1350
Operating Supplies & Exp. 1550
Legal Services 2100
Professional Services 2150
Equipment Rental 2200
Liability Insurance 2300
Services by other Agencies 2350
Royal Theatre ‐ Note Payable 2430
Sub‐total
CAPITAL OUTLAY:

Buildings 3100
Improve. Other than Buildings 3150 18,305         ‐                        311,763   5,459,320 Royal theater Loss on Sale 3168
Land 3170
Equipment 3200
Sub‐total        18,305      311,763   5,459,320
OTHER FINANCING USES:

Debt Service ‐ Principal 4000
Debt Service ‐ Interest 4100
Transfer General Fund 5000
Transfer to Legion Hall 5011
Sub‐total
Fund Total        18,305 ‐                        311,763   5,459,320 RDA Bond Refinance ‐ 91/79 NOTES
2022‐2023 Proposed City Budget RDA Bond Refinance, I‐2
DRAFT 6/8/2022
Successor Agency, Operating ‐ 26
Actual Budget Actual Budget Estimate Budget
Acct. 2019/20 2020/21 2020/21 2021/22 2021/22 2022/23
SUPPLIES & SERVICES:

Utilities 1000 23,393                14,000              106         ‐                   15,000 Office Supplies & Postage 1200
Advertising and Pubs 1250
Business Expense and Trng 1300
Memberships, Dues & Subs 1350
Operating Supplies & Exp. 1550
Fuels and Lubricants 1560
Redevelopment Interest 1755 144,599
Legal Services 2100
Professional Services 2150 158,528            114,750      118,421      130,000        95,000          5,000 Remediation winding down Equipment Rental 2200
Property Rental 2250
Liability Insurance 2300
Services by other Agencies 2350
Royal Theatre ‐ Note Payable 2430
Sub‐total      326,520      128,750      118,527      145,000        95,000          5,000 CAPITAL OUTLAY:

Buildings 3100
Improve. Other than Buildings 3150
Loss on sale 3168
Land 3170
Equipment 3200
Sub‐total
OTHER FINANCING USES:

Debt Service ‐ Principal 2250      225,000      230,000 Debt Service ‐ Interest 4100 ‐                        359,000      139,983      360,000      131,600      126,194 Cost of Issuance 4103 5,498           ‐                            5,498 ‐                            5,498          5,498 Transfer  to General Fund 5000 165,000            165,000      165,000      165,000      140,557      188,872 Sub‐total      170,498      524,000      310,481      525,000      502,655      550,564 Fund Total      497,018      652,750      429,008      670,000      597,655      555,564 Depreciation        14,021          9,900          9,900        14,000          9,900          9,900 Total with Depreciation      511,039      662,650      438,908      684,000      607,555      565,464 Successor Agency Operating ‐ 26
NOTES
2022‐2023 Proposed City Budget Successor Agency Operating, I-3 DRAFT 6/8/2022

FUND BALANCE
Fund Fund Description Actual Fund Balance
6/30/21
Estimated Revenue
2021‐2022
Estimated Expense
2021‐2022
Estimated Fund
Balance 6/30/22
Estimated Revenue
2022‐2023
Estimated Expense
2022‐2023
Estimated Fund
Balance 6/30/23
01 General Fund                                  370,353 6,710,790              6,385,162                                  695,981 6,761,712              7,616,230                (158,537) 57 Alch. & Drug Grant (Gladiators) 4,151 ‐  ‐ 4,151 ‐  ‐ 4,151 39 Community Corrections Grant 551 ‐  ‐ 551 ‐  ‐ 551
42 Police Safety Fund                  107,468 28,300 13,064                  122,704 28,700 ‐                  151,404 40 Fire Safety Fund 73,330 11,300 32,395 52,235 11,700 ‐  63,935 Public Safety Special Funds                  185,500 39,600 45,459                  179,641 40,400 ‐                  220,041 71 Measure A               1,001,756 570,297                 990,638                  581,415 676,942              1,256,847 1,510 86 SB1                  156,737 165,843 89,000                  233,580 190,494                 380,000 44,074 NEW SB1 SRTS ‐ ‐  ‐ ‐ ‐  ‐ ‐
NEW ASHC Pedestrian ‐ ‐  ‐ ‐ 200,000                 200,000 ‐ 20 Gas Tax                  488,661 318,458                 386,150                  420,969 351,812                 705,353 67,428 22 Local Transportation Fund                  192,248 8,521 6,800                  193,969 9,270 8,800                 194,439 Streets & Roads              1,839,402               1,063,119              1,472,588              1,429,933               1,428,518              2,551,000                  307,451 10/30 Water Operating Fund               4,303,898               2,577,874              2,514,261               4,367,511               2,672,534              3,808,193               3,231,852 12/32 Wastewater Operating Fund               6,435,392               2,287,115              3,460,780               5,261,727               2,606,121              4,345,623               3,522,225 15 Solid Waste Fund 1,135 20,820 ‐  21,955 ‐  20,820 1,135 23 Transit Fund               1,190,563 715,779                 709,408               1,196,934               2,566,305              2,867,472                 895,767 Enterprise Funds            11,930,988               5,601,588              6,684,449            10,848,127               7,844,960            11,042,108              7,650,979 28 Library Fund (33,864) 20,100 15,000 (28,764) 6,700 15,000 (37,064) 36 Public Facilities Fund 15,789 50 ‐  15,839 8,950 ‐  24,789 38 Park Development Fund                  770,265 75,170                 225,000                  620,435 12,170 ‐                  632,605 76 Capital Facilities Fund                  717,414 2,850                 113,516                  606,748 1,500                 529,537 78,711 78 City Hall Equipment Fund 29,534 6,080 ‐  35,614 720 25,000 11,334 87 Traffic Mitigation Fund                  141,866 23,775 38,227                  127,414 2,804                 120,000 10,218 94 Sewer Bond 32,003 ‐  ‐ 32,003 ‐  ‐ 32,003
100/58/67 Leroy Park CDBG                 (852,227)               3,409,885              2,570,563 (12,905) 30,800 30,800 (12,905) 105 CDBG CV1 (10,175) 56,695 46,502 18 ‐  ‐ 18
106 CDBG MicroEnt ‐ 10,120 10,120 ‐ 239,880                 239,880 ‐ 107 CDBG CV2/3 ‐ 15,751 15,751 ‐ 292,377                 292,377 ‐ 109 CDBG Central Park ‐ ‐  5,030 (5,030)               4,887,084              4,882,054 ‐ new CDBG Leroy Bldg ‐ ‐  ‐ ‐               1,700,000              1,700,000 ‐ new CDBG Urban Forest ‐ ‐  ‐ ‐ 170,734                 170,734 ‐ Miscellaneous Funds                  810,605              3,620,476            3,039,709              1,391,372              7,353,719            8,005,382                  739,709 60 Lighting & Landscaping District 45,424 31,387 10,508 66,303 29,295 18,389 77,209 63 Pasadera Light & Landscape Dist                  212,901 100,600 19,074                  294,427 103,040 50,634                  346,833 65 Lighting District                  694,174 137,900 70,475                  761,599 141,211 73,447                  829,363 Lighting Districts                  952,499 269,887                 100,057              1,122,329 273,546                 142,470              1,253,405 CITY OF GUADALUPE             16,089,346              17,305,460            17,727,424            15,667,382             23,702,855            29,357,190            10,013,047 Fund Fund Description Actual Fund Balance
6/30/21
Estimated Revenue
2021‐2022
Estimated Expense
2021‐2022
Estimated Fund
Balance 6/30/22
Estimated Revenue
2022‐2023
Estimated Expense
2022‐2023
Estimated Fund
Balance 6/30/23
26 RDA Operating             (3,817,639) 749,067                 607,555             (3,676,127) 722,028                 656,464             (3,610,563) 90 RDA Affordable Housing                  422,702 ‐  ‐                  422,702 ‐  ‐                  422,702 91/79 RDA Bond Refinance (Royal                  670,739 800                 311,763                  359,776               5,100,800              5,459,320 1,256 SUCCESSOR AGENCY             (2,724,197) 749,867                 919,318             (2,893,648)               5,822,828              6,115,784             (3,186,604) 2022‐2023 Proposed City Budget Fund Balance, J‐1
DRAFT 6/8/2022
Attachment 2
City of Guadalupe
Proposed Capital Improvement Projects
(CIP) Budget Draft
Fiscal Year July 1, 2022 through June 30, 2023
Project
Numbers
Account
Numbers
General
Fund ARPA Gas Tax
Capital Facilities
Impact Fees Traffic Mitigation LTF Measure A SB1 RMRA
AHSC‐
Pedestrian AHSC‐Transit IRWM CDBG Water Sewer 2022‐23 TOTAL 100 Buildings
089‐104 89‐4444‐3044 21,353 73,000 30,387 30,387 155,127089‐105 89‐4444‐3045 40,840 40,840089‐106 89‐4444‐3077 90,000 90,000089‐107 89‐4444‐3076 70,000 70,000089‐108 89‐4444‐3075 50,000 120,000 170,000089‐109 New Royal Theatre 5,459,320 5,459,320089‐110 New Library Relocation 30,000 30,000089‐111 New City Hall Restroom Redesign 154,000 154,000089‐112 New 400,000 400,000200 Parks089‐201 New 4,882,054 4,882,054089‐204 New CDBG (Leroy Phase 2) 1,700,000 1,700,000089‐203 89‐4444‐3078 Parks Improvements (O'Connell rubberization $40k, Tognazzini Park 190,000 190,000300 Streets, Sidewalks, Bicycle Facilities089‐307 89‐4444‐3067 179,537 200,000 379,537089‐308 89‐4444‐3068 40,000 701,000 120,000 459,000 380,000 1,700,000089‐309 89‐4444‐3097 8,800 91,200 100,000089‐311 89‐4444‐3092 60,000 60,000400 Water089‐406 89‐4444‐3093 295,000 295,000089‐407 89‐4444‐3094 200,000 200,000089‐408 89‐4444‐3095 50,000 50,000089‐409 89‐4444‐3096 450,000 450,000089‐410 New 40,000 40,000500 Wastewater089‐503 89‐4444‐3083 302,821 220,000 522,821 089‐504 89‐4444‐3084 1,200,000 1,200,000
089‐510 89‐4444‐3090 90,000 90,000600 Transit089‐603 New 1,700,000 1,700,000089‐602 New 100,000 100,000 Transfer to CIP fund 089: 292,193 707,000 701,000 459,537 120,000 8,800 610,200 380,000 200,000 1,800,000 302,821 12,041,374 1,065,387 1,540,387 20,228,699 20,228,699 20,228,699
‐

PROJECT DESCRIPTIONS
Funding Allocation
City of Guadalupe
Capital Improvement Projects Budget ‐ Fiscal Year 22‐23 Financial Accounting Software
Storm Drain ImprovementsElevated Tank Repairs/Evaluate Antenna RevenueGeneral Plan Update Public Facilities Master Plan (includes parks and library)American Legion wood repairBuilding improvements (PD Electrical, misc)CDBG (Central Park)City Hall Upgrades (roof & assoc. building repairs) 11th st multimodal path designAmtrak Tran Station Rehab (design) AIPS vaultEV Bus and charging
Advanced Metering Infrastructure Phase 1SCADA ImprovementsWest Main WaterlineEffluent Irrigation Pump Station RehabilitationHwy 1 Lift Station Bonita Tank DemolitionStreet Rehabilitation FY 22/23Sidewalk repairs DRAFT 6/8/2022
Project Categories FY 2022‐23 General Fund ARPA Gas Tax Cap Facilites Traffic Mit LTF Measure A SB1 RMRA Stimulus/Other Grants Water Wastewater CDBG Buildings 6,569,287 62,193 707,000 ‐                  280,000 ‐                  ‐ ‐ ‐  ‐  30,387 30,387 ‐ Parks 6,772,054 190,000   ‐ ‐                   ‐                  ‐                  ‐ ‐ ‐  ‐  ‐ ‐ 12,041,374 Streets, Sidewalks, Bicycle Facilities 2,239,537 40,000 701,000 179,537 120,000 8,800 610,200 380,000 200,000 ‐ ‐ ‐ Water 1,035,000 ‐                   ‐                  ‐                  ‐ ‐ ‐ ‐  ‐  1,035,000 ‐ ‐ Wastewater 1,812,821 ‐                   ‐                  ‐                  ‐ ‐ ‐ ‐  ‐  ‐ 1,812,821 ‐ Transit 1,800,000 ‐                   ‐                  ‐                  ‐ ‐ ‐ ‐  1,800,000 ‐ ‐ ‐ Total CIP Expenditures 20,228,699 292,193 707,000 701,000 459,537 120,000 8,800 610,200 380,000 2,000,000 1,065,387 1,843,208 12,041,374 ‐  ‐  ‐  ‐                   ‐                  ‐                  ‐ ‐ ‐  ‐  ‐ ‐ ‐ City of Guadalupe
Capital Improvement Projects Budget ‐ Fiscal Year 22‐23 Funding by Category and Funding Source
2022‐23 Fund Allocation
Buildings
32%
Parks
34%
Streets, Sidewalks, Bicycle Facilities
11%
Water
5%
Wastewater
9%
Transit
9%
FY 2022‐23 Projects By Catgegory
DRAFT 6/8/2022
Attachment 3
City of Guadalupe
Proposed Capital Facilities Fund Program
of Projects Budget Draft
Fiscal Year July 1, 2022 through June 30, 2023
Budget Capital Facilities Fund 76 ‐ People's Self‐Help Housing/Pasadera Impact FY2022‐2023 Project Funds Required Reference to Budget
Public Safety:

Fire Turnouts $ 3,000 Equipment
SCBA Breather $ 8,500 Equipment
Fire Hoses $ 1,500 Equipment
Exhaust Capture (2) $                 25,000 Equipment
Crime Prevention Camaras (20) $                 32,000
$                 70,000
General Fund:

Termite repair American Legion $                 70,000 Capital Project PD Electrical Upgrade $              100,000 Capital Project Facilities master plan $                 90,000 Capital Project Auditorium Stage and Chambers Repairs $                 20,000 Capital Project $              280,000
Streets:

Pedestrian Improvements $              179,537 Capital Project $              179,537
$              529,537
DRAFT 6/8/2022
City of Guadalupe
Proposed ARPA
Fiscal Year July 1, 2022 through June 30, 2023
Attachment 4
ARPA Summary ‐ Draft
BUDGETED ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ESTIMATE Est BUDGETED BUDGETED Description Council Approved FY21‐22 DEC 2021 JAN 2022 FEB 2022 MAR 2022 APR 2022 MAY 2022 JUN 2022 FY21‐22 REMAINING FY22‐23 REMAINING FY23‐24 REMAINING revenue General Fund loss of revenue $ 200,456 $ 30,000 $ 30,000.00 $ 30,000.00 $ 170,456.17 170,456.17 ‐  ‐  ‐ revenue General Plan Environmental impact review $ 46,074 $ ‐ $ 46,073.80 46,073.80 ‐  ‐  ‐ Water Utility debt forgiveness $ 35,000 $ 35,000 $ 35,000.00 $ 35,000.00 $ ‐ ‐  ‐  ‐  ‐ CDBG Los Amigos de Guadalupe $ 40,000 $ 20,000 $ 2,707.54 $ 3,286.67 $ 3,200.00 $ 9,194.21 $ 30,805.79 30,805.79 ‐  ‐  ‐ revenue Cyber Sec Upgrades IT $ 75,000 $ 26,220 $ 26,220.00 $ 26,220.00 $ 48,780.00 24,390.00 24,390.00 24,390.00 ‐ Rec Manager $ 168,865 $ 50,957 $ 6,148.79 $ 6,721.04 $ 6,721.04 $ 6,721.04 $ 6,716.47 $ 6,720.00 $ 39,748.38 $ 129,116.82 ‐  129,116.82 129,116.82 Jack O'Connell Park $ 25,000 $ 25,000 $ 3,496.06 $ 21,503.94 $ 25,000.00 $ ‐ ‐  ‐  ‐  ‐ 01‐4300‐1550 Concession Stand $ 1,000 $ ‐ $ 1,000.00 1,000.00 ‐  ‐  ‐ 01‐4300‐1550 Recreational Programs $ 20,000 $ 313.09 $ 15.20 $ 328.29 $ 19,671.71 19,671.71 ‐  ‐  ‐ 01‐4300‐1550 Tables and C Storage $ 8,900 $ ‐ $ 8,900.00 8,900.00 ‐  ‐  ‐ 01‐4140‐2999 PPE Supplies $ 4,800 $ 2,098 $ 169.64 $ 169.64 $ 4,630.36 4,630.36 ‐  ‐  ‐ Public Safety Paid Volunteers $ 10,000 $ 10,000 $ 8,901.16 $ 2,179.91 $ 1,598.60 $ (2,679.67) $ 10,000.00 $ (0.00) ‐  (0.00) ‐  (0.00) CIP Planning Software $ 62,933 $ 73,000 $ ‐ $ 62,933.13 73,000.00 (10,066.87) ‐  (10,066.87) 01‐4140‐2151 Adobe $ 18,208 $ 3,166 $ 3,165.91 $ 7,423.30 $ 10,589.21 $ 7,618.51 7,618.51 ‐  ‐  ‐ WIFI for LeRoy Park ‐ Change Orders $ 39,000 $ 30,370.00 $ 8,630.00 $ 39,000.00 $ ‐ ‐  ‐  ‐  ‐ Live Streaming Equipment, Webcam, TV's $ 8,500 $ 4,090.80 $ 1,008.96 $ 1,972.82 $ 1,427.42 $ 8,500.00 $ ‐ ‐  ‐  ‐  ‐ 01‐4140‐2151 Building Attendent ‐ Live Streaming Administration $ 4,320 $ ‐ $ 4,320.00 4,320.00 ‐  ‐  ‐ 01‐4140‐2151 Spanish/Mixteco Interpreting Services $ 7,500 $ ‐ $ 7,500.00 7,500.00 ‐  ‐  ‐ 01‐4140‐2151 Website Update $ 15,000 $ 3,500 $ 3,500.00 $ 1,050.00 $ 1,100.00 $ 125.00 $ 1,775.00 $ 1,000.00 $ 8,550.00 $ 6,450.00 6,450.00 ‐  ‐  ‐ 01‐4140‐2151 Website Content $ 4,800 $ ‐ $ 4,800.00 4,800.00 ‐  ‐  ‐ 01‐4140‐2151 Website Event Management Plugin $ 5,000 $ ‐ $ 5,000.00 5,000.00 ‐  ‐  ‐ 01‐4140‐2151 Website PW Request ‐ Workflow Management $ 1,200 $ ‐ $ 1,200.00 1,200.00 ‐  ‐  ‐ 01‐4140‐1550 Surface Pro 7 w/Keyboard $ 19,682 $ ‐ $ 19,681.60 19,681.60 ‐  ‐  ‐ CIP Council Chambers ‐ ADA/Window Ventilation Update $ 300,000 $ 300,000 $ ‐ $ 300,000.00 300,000.00 ‐  ‐  ‐ CIP Architectural Drawings $ 100,000 $ 100,000 $ ‐ $ 100,000.00 100,000.00 ‐  ‐  ‐ CIP City Hall Restroom(s) Redesign $ 154,000 $ ‐ $ 154,000.00 154,000.00 ‐  ‐  ‐ 01‐4200‐1400 Generator (1) $ 50,000 $ ‐ $ 50,000.00 50,000.00 ‐  ‐  ‐ 01‐4145‐2150 Auditorium Upgrades $ 75,000 $ 75,000 $ 247.00 $ 2,571.16 $ 10,033.73 $ 15,450.00 $ 28,301.89 $ 46,698.11 46,698.11 ‐  ‐  ‐ 01‐4145‐1550 PW Conference Room Upgrades $ 18,000 $ 18,000 $ 200.62 $ 2,020.00 $ 69.13 $ 71.68 $ 2,361.43 $ 15,638.57 15,638.57 ‐  ‐  ‐ 01‐4145‐1550 Finance Office Upgrades $ 5,000 $ 5,000 $ ‐ $ 5,000.00 5,000.00 ‐  ‐  ‐ 01‐4145‐2150 Vegetation Maintenance $ 50,000 $ 30,000 $ 8,043.00 $ 6,041.00 $ 5,040.00 $ 19,124.00 $ 30,876.00 30,876.00 ‐  ‐  ‐ Maintenance Lead $ 85,500 $ 23,328 $ ‐ $ 85,500.00 85,500.00 85,500.00 CIP Library Relocation $ 30,000 $ ‐ $ 30,000.00 30,000.00 ‐  ‐  ‐ Admin and Finance Heating $ 5,460 $ 5,460 $ 4,280.00 $ 1,180.16 $ 19,780.00 $ 25,240.16 $ (19,780.00) ‐  (19,780.00) ‐  (19,780.00) SBCAG Broadband Contribution $ 5,223 $ 5,422.63 $ 5,422.63 $ (200.00) ‐  (200.00) ‐  (200.00) 01‐4200‐0100 Differential for Emergency Services Manager $ 3,298 $ 3,298 $ ‐ $ 3,298.00 3,298.00 ‐  ‐  ‐ 01‐4405‐0150 Temp. Permit/Planning appointment for scanning $ 1,210 $ 1,210 $ ‐ $ 1,210.00 1,210.00 ‐  ‐  ‐ Drinking Fountain and refridgerator $ 6,506 $ 6,506 $ 6,506.25 $ 6,506.25 $ (0.25) ‐  (0.25) ‐  (0.25) CIP Emergency declaration ‐ electrical issues $ ‐ $ ‐ $ 1,350.00 $ 1,350.00 $ (1,350.00) 50,000.00 (51,350.00) ‐  (51,350.00) $ 1,710,434 $ 846,743 $ 200.62 $ 34,080.59 $ 17,921.49 $ 47,906.54 $ 86,376.12 $ 89,764.17 $ 54,356.56 $ 330,606.09 $ 1,379,828.32 1,222,218.62 157,609.70 24,390.00 133,219.70 Total ARPA awarded $ 1,860,000
Remaining to allocate $ 149,566 BUDGETED ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ESTIMATE TOTAL ESTIMATE TOTAL BUDGET TOTAL BUDGET FY21‐22 DEC 2021 JAN 2022 FEB 2022 MAR 2022 APR 2022 May 2022 June 2022 FY21‐22 FY22‐23 FY23‐24 Received $ 930,930 $ 365,706 $ 201 $ 31,294 $ 17,921 $ 45,454 $ 18,699 $ 74,351.44 $ 29,652.62 $ 217,572 related to General Fund $ 484,413 related to General Fund $ 24,390 related to General Fund $ ‐ $ ‐ $ ‐ $ ‐ $ 2,453 $ ‐ $ ‐ $ ‐ $ 2,453 related to transit $ ‐ related to transit $ ‐ related to transit $ 20,000 $ ‐ $ ‐ $ ‐ $ ‐ $ 33,078 $ 11,916.67 $ 3,200.00 $ 48,194 related to cdbg $ 30,806 related to cdbg $ ‐ related to cdbg $ 2,787 $ ‐ $ 2,787 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 2,787 related to fund 60 $ ‐ related to fund 60 $ ‐ related to fund 60 $ 400,000 $ ‐ $ ‐ $ ‐ $ ‐ $ 1,350 $ ‐ $ ‐ $ 1,350 related to CIP $ 707,000 related to CIP $ ‐ related to CIP$ 33,250 $ ‐ $ ‐ $ ‐ $ ‐ $ 33,250 $ ‐ $ ‐ $ 33,250 related to water $ ‐ related to water $ ‐ related to water$ 25,000 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 3,496.06 $ 21,503.94 $ 25,000 related to fund 38 related to fund 38 $ ‐ related to fund 38 $ 846,743 $ 201 $ 34,081 $ 17,921 $ 47,907 $ 86,376 $ 89,764 $ 54,357 $ 330,606 $ 1,222,219 $ 24,390 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
DRAFT 6/8/2022
Attachment 5
City of Guadalupe
Budget Draft Exhibits
Fiscal Year July 1, 2022 through June 30, 2023

CITY OF GUADALUPE
3 YEAR SALES AND USE TAX BUDGET ESTIMATE
FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24
Industry Group Actuals Projection % Projection % Projection % Autos & Transportation 19,059 18,810 -1.3% 19,610 4.3% 19,610 0.0% Building & Construction 102,604 109,083 6.3% 108,983 -0.1% 112,283 3.0% Business & Industry 164,324 158,013 -3.8% 162,913 3.1% 167,813 3.0% Food & Drugs 43,228 43,435 0.5% 44,235 1.8% 45,135 2.0% Fuel & Service Stations 56,632 79,741 40.8% 79,941 0.3% 81,541 2.0% General Consumer Goods 3,777 4,826 27.8% 4,226 -12.4% 4,326 2.4% Restaurants & Hotels 30,815 29,938 -2.8% 31,038 3.7% 31,938 2.9% Transfers & Unidentified 628 887 41.4% 887 0.0% 887 0.0% State & County Pools 106,554 98,391 -7.7% 102,391 4.1% 106,491 4.0% Total 527,620 543,124 2.9% 554,224 2.0% 570,024 2.9%
Administration Cost (3,897) (4,274) (4,788) (4,925)
Total 523,722 538,850 2.9% 549,435 2.0% 565,099 2.9%
With Accrual 523,722 538,850 2.9% 549,435 2.0% 565,099 2.9% *Estimate is on an accrual basis (allocations for sales through June) Note: HdL’s March 2022 Consensus Forecast was used to develop budget estimates based on local and statewide results, as well as regional & national economic outlooks. Growth factors consider the pandemic rebound, inflationary pressures, geopolitical impacts and workforce constraints.

FY 2018-19: Actual total was $450,002; Measure X was $160,145 FY 2019-20: Actual total was $449,876 (reflects March – June pandemic influence) FY 2020-21: Wayfair/AB147 implementation as of 3Q20; adjusts for tax deferral programs and delayed payments. *Effective 1Q21: use tax pools allocations reflect Amazon’s business restructuring, which shifts some taxes to cities and counties with fulfillment centers that ship directly to CA customers. Forecast includes this shift, but does not include an anticipated 4Q20 negative correction to Amazon's tax filings. *4Q21 R&H down due to missing payment from Point Sal Restaurant.

CONFIDENTIAL INFORMATION - DO NOT COPY OR DISTRIBUTE WITHOUT AUTHORIZATION 4/25/2022 10:59 AM HdL · 909.861.4335 · www.hdlcompanies.com Prepared: 4/22/22 By: trv

CITY OF GUADALUPE MEASURE N2020
3 YEAR TRANSACTIONS AND USE TAX BUDGET ESTIMATE
FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24
Industry Group Actuals Projection % Projection % Projection % Autos & Transportation 53,995 214,422 297% 215,622 0.6% 215,622 0.0% Building & Construction 19,204 97,665 409% 98,065 0.4% 100,065 2.0% Business & Industry 25,366 114,083 350% 116,483 2.1% 119,983 3.0% Food & Drugs 10,475 41,522 296% 42,322 1.9% 43,122 1.9% Fuel & Service Stations 19,300 101,814 428% 102,114 0.3% 104,114 2.0% General Consumer Goods 22,988 90,742 295% 91,042 0.3% 91,942 1.0% Restaurants & Hotels 6,688 22,615 238% 23,015 1.8% 23,715 3.0% Transfers & Unidentified 1,390 7,038 406% 7,038 0.0% 7,038 0.0% Total 159,405 689,901 333% 695,701 0.8% 705,601 1.4%
Administration Cost (710) (3,204) (3,970) (4,022)
Total 158,695 686,697 333% 691,731 0.7% 701,579 1.4%
With Accrual 158,695 686,697 333% 691,731 0.7% 701,579 1.4% *Estimate is on an accrual basis (allocations for sales through June) Note: HdL’s March 2022 Consensus Forecast was used to develop budget estimates based on local and statewide results, as well as regional & national economic outlooks. Growth factors consider the pandemic rebound, inflationary pressures, geopolitical impacts and workforce constraints.

Measure N 1% district tax became effective 4/1/21 after Measure X .25% district tax ended 3/31/21.

FY 2020-21: Reflects partial year of Measure N; Wayfair/AB147 implementation as of 3Q20; adjusts for tax deferral programs and delayed payments.

CONFIDENTIAL INFORMATION - DO NOT COPY OR DISTRIBUTE WITHOUT AUTHORIZATION 4/25/2022 10:19 AM HdL · 909.861.4335 · www.hdlcompanies.com Prepared: 4/25/22 By: trv

$280,932,158 $304,733,077 $321,125,218 $338,190,853 $356,390,974 $238,116,918 $261,917,837 $278,309,978 $295,375,613 $313,575,734 $4,600,098 $4,646,607 $5,464,043 $5,836,325 $6,271,515
$18,085,392 $10,175,436 $11,111,256 $12,199,013 $12,950,678 $1,115,429 $1,570,097 $490,336 $164,783 $0
$261,917,837 $278,309,978 $295,375,613 $313,575,734 $332,797,926 $42,688,213 $42,688,213 $42,688,213 $42,688,213 $42,688,213 $0 $0 $0 $0 $0
$127,027 $127,027 $127,027 $127,027 $127,027
$0 $0 $0 $0 $0
$304,733,077 $321,125,218 $338,190,853 $356,390,974 $375,613,166

8.47% 5.38% 5.31% 5.38% 5.39%
$3,047,331 $3,211,252 $3,381,909 $3,563,910 $3,756,132
$427,735 $450,743 $474,697 $500,244 $527,225
$$ $$$
$0 $0 $0 $0 $0
$427,735 $450,743 $474,697 $500,244 $527,225
$412,764 $434,967 $458,083 $482,735 $508,772
$14,971 $15,776 $16,614 $17,509 $18,453
$$ $$$
Rev from Taxable Val* $427,735 $450,743 $474,697 $500,244 $527,225 $9,413 $9,413 $9,413 $9,413 $9,413
-$5,667 -$5,966 -$6,276 -$6,607 -$6,957
2022-23 2023-24 2024-25 2025-26 2026-27
$555,652,453 $564,198,068 $596,954,864 $631,681,971 $668,936,532 $518,423,502 $526,969,117 $559,725,913 $594,453,020 $631,707,581 $10,024,530 $9,685,331 $10,924,357 $11,673,004 $12,550,840 -$3,283,454 $20,374,134 $22,360,634 $24,596,090 $26,112,325 $1,804,539 $2,697,331 $1,442,116 $985,468 $304,480
$526,969,117 $559,725,913 $594,453,020 $631,707,581 $670,675,227 $25,145,540 $25,145,540 $25,145,540 $25,145,540 $25,145,540 $12,008,411 $12,008,411 $12,008,411 $12,008,411 $12,008,411 $75,000 $75,000 $75,000 $75,000 $75,000
$564,198,068 $596,954,864 $631,681,971 $668,936,532 $707,904,178

1.54% 5.81% 5.82% 5.90% 5.83%
$926,676 $940,947 $995,616 $1,053,561 $1,115,721
$14,271 $54,669 $57,945 $62,160 $65,047
VLFAA Estimate $940,947 $995,616 $1,053,561 $1,115,721 $1,180,767 NOTES:
● The revenue projection assumes 100% payment of taxes. Delinquency is not considered in the projection; however, rates of between 1% and 2.5% are typical. ● Estimated Assessor Prop 8 Adjustments: Prop 8 reductions in value are TEMPORARY reductions applied by the assessor that recognize the fact that the current market value of a property has fallen below its trended (Prop 13) assessed value. For 2022-23 and later, properties with prior Prop 8 reductions are not included in the CPI increase, they are projected flat until either the Assessor begins to recapture value as the economy improves and median sale prices begin to increase, they are further reduced, or they sell and are reset per Prop 13. ● CPI of Non Prop 8 Parcels is calculated at the following rates: 2022-23 @ 2.000%; 2023-24 @ 2.000%; 2024-25 @ 2.000%; 2025-26 @ 2.000%; 2026-27 @ 2.000%; ● Prop 8 restoration adjustments are based on projected median SFR home price growth. For this projection the following median year-to-year percentage changes are used: 2023-24: 11.4%; 2024-25: 12.1%; 2025-26: 12.7%; 2026-27: 12.7%
● Transfer of Ownership Assessed Value Change: For 2022-23, the projected increase from known 2021 transfers is used. For years 2023-24 and later a growth rate is applied that is representative of the historical average rate of real property growth due to properties that have transferred ownership. Value growth due to transfers is estimated as the following percentages of prior year real property value: 2023- 24 @ 3.8%; 2024-25 @ 4.0%; 2025-26 @ 4.1%; 2026-27 @ 4.1%; ● Base Year Values Entry: With the dissolution of redevelopment, base year values are unlikely to change and are budgeted flat. ● Secured personal property and unsecured values are projected to grow at the following rates 2022-23 @ 0.0%; 2023-24 @ 0.0%; 2024-25 @ 0.0%; 2025-26 @ 0.0%; 2026-27 @ 0.0%; . Unsecured escaped assessments may be included in the unsecured value. The value of escaped assessments is generally inconsistent and varies from year to year. ● Completed new construction entry: This data entry point allows for the inclusion of new construction projects completed annually. Due to processing delays we suggest that a time frame of November - October be selected. (e.g. Nov. 2020 - Oct. 2021 for the 2022-23 FY). If completed new construction has resulted in a sale of the property it is likely that the new value will appear in the value increase due to transfers of ownership entry and therefore should not be also included in the completed new construction value. ● Pooled Revenue Sources include supplemental allocations, redemptions for delinquent payments in Non-Teeter cities, tax payer refunds due to successful appeals, roll corrections and other adjustments applied after the release of the roll. The forecasting of these revenues should be developed based on historical averages over a minimum of 3 years. ● General Fund Revenue Estimate does not include any ad valorem voter approved debt service revenue. ● Pass through and residual revenues from former redevelopment agencies are not included in this estimate. ● SB 2557 Administration Fees are not deducted from the general fund projections. In this projection, SB2557 Administration fees are estimated by considering the jurisdiction's most recently reported fee amount as a percentage of its general fund revenue in that year, and applying that percentage to the updated revenue.

Prepared on 5/4/22 Using Sales Through 12/31/21
This report is not to be used in support of debt issuance or continuing disclosure statements without the written consent of HdL Coren & Cone Nonunitary Utility Value (0.0% growth)
Enter Completed New Construction
Estimated Net Taxable Value
Estimated Total Percent Change
Base Value of VLFAA
Estimated Change to VLFAA
Unsecured Personal Property Value (see notes)
Admin Fee (Not Deducted Above)
Enter Suppl. Apportionment - Avg 3 Yrs
Enter Delinquent Apportionment - Avg 3 Yrs
VLFAA
Citywide Net Taxable Value
Real Property Value (Incl. Prop 8 parcels)
CPI of Non Prop 8 Parcels (2022-23 @ 2.000%)
Transfer of Ownership Assessed Val Change
Est. SFR Prop 8 Adj Based on Recent SFR Price
Estimated Real Property Value
Secured Personal Property Value (see notes)
Unitary Revenue (Budgeted Flat)
Estimated Total Percent Change
Revenue Calculations
Net Taxable Value Tax @ 1%
City Share of 1% Tax @ 14.03637362%
Aircraft Value Tax @ 1%
City Share of Aircraft Tax @ 33.3%
Net GF Estimate
Taxable Value Revenue Categories
Secured Revenue
Unsecured Revenue
Aircraft Revenue
Estimated Net Taxable Value
General Fund and BY Values
Real Property Value (Incl. Prop 8 parcels)
CPI of Non Prop 8 Parcels (2022-23 @ 2.000%)
Transfer of Ownership Assessed Value Change
Est. SFR Prop 8 Adj Based on Recent Price
Estimated Real Property Value
Base Year Values
Secured Personal Property Value (see notes)
Unsecured Personal Property Value (see notes)
Nonunitary Utility Value (0.0% growth)
Enter Completed New Construction

THE CITY OF GUADALUPE
GENERAL FUND REVENUE ESTIMATE - DEFAULT SCENARIO 2022
2022-23 Through 2026-27 Revenue Estimate Based on 2021-22 Values and Estimated Changes General Fund 2022-23 2023-24 2024-25 2025-26 2026-27
Guadalupe Successor Agency
RPTTF Allocation History
Fiscal Year 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 RPTTF Allocation 17-18B 18-19A 18-19B 19-20A 19-20B 20-21A 20-21B 21-22A 21-22B 22-23A 22-23B 23-24AAllocation Date 1/2/2018 6/1/2018 1/2/2019 6/1/2019 1/2/2020 6/1/2020 1/2/2021 6/1/2021 1/2/2022 6/1/2022 1/2/2023 6/1/2023RPTTF Tax Revenue Deposit 1,250,399 990,567 1,298,085 1,072,317 1,386,484 1,140,699 1,442,539 1,216,686 1,514,235 1,277,157 EstimatedLess County RPTTF Admin (306) (562) (669) (6,131) (284) (1,402) (1,252) (1,164) (616) (1,000) Estimated Less County PTAX Admin (SB2557/SB813) 0 (32,924) 0 (38,272) 0 (39,637) 0 (34,103) 0 (36,288) Estimated Total Pass Through (196,084) (196,084) (230,038) (230,038) (262,784) (262,784) (298,318) (298,318) (326,009) (326,009) Estimated Net Revenue for ROPS 1,054,009 760,997 1,067,378 797,876 1,123,416 836,876 1,142,969 883,101 1,187,610 913,860Non‐Admin ROPS 132,269 694,573 2,430 363,460 3,604 362,439 1,175 369,069 8,675 486,319 8,675 From OB approved 22‐23 ROPS Admin ROPS 40,000 62,500 87,500 82,500 82,500 82,500 82,500 70,750 69,807 94,436 94,436 From OB approved 22‐23 ROPS Prior Period Adjustments (PPA) 000000000
Residual Revenue 881,740 3,924 977,448 351,916 1,037,312 391,937 1,059,294 443,282 1,109,128 333,105City Pass Through Amount 10,689 10,689 12,595 12,595 14,548 14,548 17,495 17,495 19,405 19,405 Pass through on A ROPS always is the same as on the B ROPS in JanuaryCity Residual Revenue & PPA Amount 125,815 1,304 139,495 60,704 148,657 67,639 157,238 77,951 165,864 58,293 Estimated at 17.5% of estimated residual amount.

Fiscal Year Totals 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 Total RPTTF Deposits 2,240,966 2,370,402 2,527,183 2,659,225 2,791,392 2,593,801 City Pass Through Amount 21,378 25,190 29,096 34,990 38,810 36,656 City Pass Through as % of RPTTF Deposits 0.9540% 1.0627% 1.1513% 1.3158% 1.3903% City Residual Revenue Amount 127,119 200,199 216,296 235,189 224,157 211,717 City Residual as % of RPTTF Deposits 5.6725% 8.4458% 8.5588% 8.8443% 8.0303% 248,372.64 Combined ROPS amounts by FY 929,342 535,890 531,043 523,494 659,237 RPTTF deposit as % of total deposits for year 55.80% 44.20% 54.76% 45.24% 54.86% 45.14% 54.25% 45.75% 54.25% 45.75% 32,924.00 38,272.00 39,637.00 34,103.00

1.47% 1.61% 1.57% 1.28%

14.27% 33.23% 14.27% 17.25% 14.33% 17.26% 14.84% 17.58% 14.95% 17.50% City of Guadalupe
California JPIA Contribution Summary
Report Date: 3/31/2022
~ Estimate ~
Liability
Annual Contribution 199,012 $ 243,309 $ 44,297 $ 22.3%
Retrospective Adjustment 22,682 14,201 (8,481) -37.4%
Payment Plan Principal - - -
Payment Plan Fee - - -
Claims Administration - - -
Excess Pool Distribution* - - -
Subtotal 221,694 257,510 35,816 16.2%
Workers' Compensation
Annual Contribution 261,568 302,923 41,355 15.8%
Retrospective Adjustment (23,189) 14,301 37,490 161.7%
Payment Plan Principal 49,954 - (49,954) -100.0%
Payment Plan Fee 1,037 - (1,037) -100.0%
Tail Claims Administration - - -
Subtotal 289,370 317,224 27,854 9.6%
Property
All-Risk 28,516 34,219 5,703 20.0%
Earthquake - - -
Other Vehicles 4,614 4,913 299 6.5%
Emergency Vehicles 1,255 1,255 - 0.0%
Mechanical Breakdown 1,335 1,335 (0) 0.0%
Admin and Appraisal Fee 1,705 1,688 (17) -1.0%
Mid Year TIV Changes (166) 22 188 113.3%
Subtotal 37,259 43,432 6,173 16.6%
Miscellaneous
Crime (premium paid to Alliant) 1,100 1,188 88 8.0%
Pollution Legal Liability - - -
Underground Storage Tanks - - -
Subtotal 1,100 1,188 88 8.0%
Grand Total 549,423 $ 619,354 $ 69,931 $ 12.7%
2021-22 Change % 2022-23
* The Excess Pool Distribution is a return of contributions to members of the Primary Liability Program who participated between 1986 and 1997.

Distributions commenced in 2021-22 and will be paid out over 5 years.

Gen Gov
Based on Oper Budget 21‐22 46.44%
Oper % of 119,585
Gen Fund Budget Total Liability
01 4145 2300 Bldg Maint 164,720 4.39% 5,251
01 4300 2300 Parks 212,530 5.67% 6,775
Sub total Gen Fund 12,026
Streets
71 4454 2300 Measure A 308,000 8.21% 9,818
Lighting/Landscape
60 4490 2300 Guad Assmt Dist 19,841 0.53% 632
65 4485 2300 Guad Light Dist 56,255 1.50% 1,793
Sub total Lighting 2,426
Enterprise
10 4420 2300 Water 1,918,200 51.13% 61,147
12 4425 2300 Sewer 1,071,880 28.57% 34,169
Sub total Enterprise 95,316
Total Gen Government 3,751,426 100.00% 119,585
Pub Safety
Based on Oper Budget for FY 21‐22 53.56%
Oper % of 137,925
Safety‐Gen Fund Budget Total Liability
01 4200 2300 Police 2,437,300 68.02% 93,822
01 4220 2300 Fire 1,145,700 31.98% 44,103
Total Public Safety 3,583,000 100.00% 137,925
Total 21‐22 Liability Premium 257,510
Gen Gov & Police Share per Liab Prgrm pg 12 A/P Distribution General Gov 95,338 46.4391% 01 1014 149,950
Police 109,959 53.5609% 71 1014 9,818
Total 205,297 60 1014 632
65 1014 1,793
10 1014 61,147
12 1014 34,169
Total 257,510
General Government
Public Safety
City of Guadalupe
Liability Premium Allocation
Fiscal Year 22‐23 ESTIMATE
$257,510
N:\2022‐2023 Budget\Workpapers\addressed\Gen Liab & WC Allocation 21‐22 LZ ESTIMATE FOR FY23 6/8/2022
Gen Gov
Based on Budgeted P/R for FY 21‐22 30.90%
Budgeted % of 98,018
Gen Fund Payroll Payroll W/C
01 4100 0350 Council 12,270 0.56% 548
01 4105 0350 Admin 462,680 21.10% 20,677
01 4120 0350 Finance 524,820 23.93% 23,454
01 4145 0350 Bldg Maint 33,440 1.52% 1,494
01 4300 0350 Parks 73,000 3.33% 3,262
01 4405 0350 Bldg Permits 123,700 5.64% 5,528
Sub total Gen Fund 54,964
Safety
57 4213 0350 Drug/Alcohol 0 0.00% 0
Streets
71 4454 0350 Meas A 217,300 9.91% 9,711
Enterprise
10 2253 Water 387,600 17.67% 17,322
12 2253 Sewer 358,500 16.35% 16,021
Sub total Enterprise 33,343
Total Gen Government 2,193,310 100.00% 98,018
0 Pub Safety
0 69.10%
Budgeted % of 219,206
Safety‐Gen Fund Payroll Payroll W/C
01 4200 0350 Police 2,241,500 68.16% 149,415
01 4220 0350 Fire 1,047,000 31.84% 69,791
Total Public Safety 3,288,500 100.00% 219,206
Total 21‐22 W/C Premium 317,224
Gen Gov & Police Share per Liab Prgrm pg 12 A/P Distribution General Gov 86,270 30.8986% 01 1014 274,170
Police 192,934 69.1014% 57 1014 0
Total 279,204 71 1014 9,711
10 1014 17,322
12 1014 16,021
Total 317,224
City of Guadalupe
Workers Comp Premium Allocation
$317,224
Fiscal Year 22‐23 ESTIMATE
Public Safety
N:\2022‐2023 Budget\Workpapers\addressed\Gen Liab & WC Allocation 21‐22 LZ ESTIMATE FOR FY23 6/8/2022
Admin Dept
Base
Current Next Hrly rate remaining Regular Total Employer Employer Employer Employer Total Remaining ID Employee Union Step Increase at 7/1 total Hrs Cost OT Bilgl Def Comp Gross Payroll Taxes PERS Med/Den/Vis Ins Total Benefits Costs BOD01 Todd Bodem N/A Contract N/A 79.3272 2080 165,000.58      ‐                  ‐                  ‐ 165,000.58 12,581.27 12,325.54 23,762.02 48,668.84 213,669.42 0.4628128 MER01 Juana Escobar SEIU 205/E 4/20/2024 40.718 2080 84,693.36 1,000.00        ‐ 3,250.00 88,943.36 6,762.90 12,646.25 23,789.19 43,198.34 132,141.70 0.286221921 unfilled unfilled N/A 38.451 2080 79,977.93         ‐                  ‐ 79,977.93 6,077.04 5,974.35 23,835.24 35,886.63 115,864.57 0.250965279 City Clerk N/A N/A N/A 1,800.00 1,800.00 137.70 0 0 137.70 1,937.70 331,471.87 1,000.00       ‐ 3,250.00 335,721.87 25,558.91 30,946.15 71,386.46 127,891.52 463,613.38 Estimated Costs Unfunded Liab Total Life 483.91
Reg 01‐4105‐0100 332,921.87 332,921.87 Vision 672.67
Part Time 01‐4105‐0125 1,800.00 1,800.00 Dental 4,669.24 temp 01‐4105‐0150                       ‐ ‐ Med 65,560.64 OT 01‐4105‐0200 1,000.00 1,000.00 71,386.46
Retirement 01‐4105‐0250 30,946.15 27,891.33 58,837.48
Taxes 01‐4105‐0300 25,558.91 25,558.91
workers comp01‐4105‐0350 20,677.00 20,677.00
Insurance 01‐4105‐0400 66,044.55 66,044.55
Dental 01‐4105‐0560 4,669.24 4,669.24
Vision 01‐4105‐0570 672.67 672.67
484,290.38 512,181.71
20,677.00
335,194.01 3,714,446.10
1 Finance Dept
Base
Current Next Hrly rate remaining Regular Total Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Gross Payroll Taxes PERS Med/Den/Vis Ins Total Benefits Costs ZAR01 Lorena Zarate N/A N/A 11/1/2022 50.250 2080 108,003.1    ‐ 0      ‐ 3,250.00 111,253.10 8,497.26 8,310.61 22,680.09 39,487.95 150,741.05 0.304827 PER01 Angie Pereyra SEIU 205/L2 44.013 2080 91,546.89 1,000.00      ‐ 3,250.00 95,796.89 7,287.19 13,631.79 23,789.19 44,708.18 140,505.07 0.284128RIV01 Isaias Rivas SEIU 181/L1 1/1/2024 33.013 2080 68,666.0      ‐ 6      ‐ 3,250.00 71,916.06 5,460.31 5,372.13 23,770.03 34,602.47 106,518.53 0.215401 FAB01 Veronica FabianSEIU 181/C 1/1/2023 28.518 2080 60,799.5      ‐ 4 3,250.00 2,471.04 66,520.58 5,075.22 9,565.66 9,128.55 23,769.43 90,290.01 0.182583 unfilled temp sum/fall 15.000 400 6,000.00 6,000.00               ‐ 459.00               ‐ 459.00 6,459.00 335,015.60 1,000.00 13,000.00 2,471.04 351,486.64 26,778.97 36,880.19 79,367.86 143,027.02 494,513.66 Estimated Costs Unfunded Liab Total Life 665.81
Reg 01‐4120‐0100 342,015.60 342,015.60 Vision 618.90
temp 01‐4120‐0150 6,000.00 6,000.00 Dental 4,117.26OT 01‐4120‐0200 1,000.00 1,000.00 Med 73,965.89 Retirement 01‐4120‐0250 36,880.19 49,743.10 86,623.29 79,367.86 Taxes 01‐4120‐0300 26,778.97 26,778.97
workers com 01‐4120‐0350 23,454.00 23,454.00Insurance 01‐4120‐0400 74,631.70 74,631.70def comp 01‐4120‐0545 2,471.04 2,471.04Dental 01‐4120‐0560 4,117.26 4,117.26Vision 01‐4120‐0570 618.90 618.90 517,967.66 567,710.76
23,454.00
2 Building Maint Dept
Base
Current Next Hrly rate remaining Regular Total Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Gross Payroll Taxes PERS Med/Den/Vis Ins Total Benefits Costs SWE01 Shannon Sweeney N/A N/A max 72.100 2080 149,968.00    ‐               ‐                   ‐ 149,968.00 10,890.43 21,565.40 27,088.78 59,544.61 209,512.61 unfilled Eng. Technician SEIU 191/B 30.003 2080 62,405.97      ‐               ‐                   ‐ 62,405.97 4,774.06 4,661.73 10,798.22 20,234.00 82,639.97 GUT01 Rudy Gutierrez SEIU 151/D 8/1/2022 27.731 2080 60,323.49      ‐               ‐                   ‐ 60,323.49 4,364.31 4,506.17 10,798.22 19,668.69 79,992.19 BAT01 James Batalla SEIU 4/17/2022 22.706 2080 47,720.64      ‐               ‐ 2,471.04 50,191.68 3,798.39 3,749.32 23,770.03 31,317.74 81,509.42 MON01 Juan Montero SEIU 10/1/2022 20.148 2080 43,479.02      ‐ 2,471.04 45,950.06 3,501.57 3,432.47 9,128.55 16,062.59 62,012.65 unfilled Maint. Lead SEIU 188/A 27.731 2080 57,679.84      ‐               ‐                   ‐ 57,679.84 4,412.51 4,308.68 9,128.55 17,849.74 75,529.57 ‐ 421,576.95               ‐ 4,942.08 426,519.03 31,741.27 42,223.76 90,712.34 164,677.37 591,196.40 Estimated Costs Unfunded Liab Total Life 948.66
Reg 01‐4145‐0100 61,383.84 61,383.84 Vision 789.36
Reg 01‐4300‐0100 61,383.84 61,383.84 Dental 6,043.75
Reg 71‐4454‐0100 152,231.87 152,231.87 Med 82,930.56
Reg 10‐4420‐0100 65,790.31 65,790.31 90,712.34
Reg 12‐4425‐0100 65,790.31 65,790.31
Reg 23‐4461‐0100 14,996.80 14,996.80 Med Life Dental Vision Retirement 01‐4145‐0250 4,696.12 122.41 4,818.53 Shannon 25,022.71 285.428 1,556.41 224.224 27,088.78 Retirement 01‐4300‐0250 4,696.12 4,696.12 Eng Tech 9,621.90 127.842 963.25 85.228 10,798.22 Retirement 71‐4454‐0250 14,628.23 14,799.76 29,427.99 Rudy 9,621.90 127.842 963.25 85.228 10,798.22 Retirement 10‐4420‐0250 8,023.37 8,023.37 James 21,853.55 135.85 1,556.41 224.22 23,770.03 Retirement 12‐4425‐0250 8,023.37 8,023.37 Juan 8,405.25 135.85 502.22 85.228 9,128.55 Retirement 23‐4461‐0250 2,156.54 4,861.97 7,018.51 Lead 8,405.25 135.85 502.22 85.228 9,128.55Taxes 01‐4145‐0300 4,773.31 4,773.31 82,930.56 948.66 6,043.75 789.36 90,712.34 Taxes 01‐4300‐0300 4,773.31 4,773.31
Taxes 71‐4454‐0300 11,388.96 11,388.96
Taxes 10‐4420‐0300 4,858.32 4,858.32
Taxes 12‐4425‐0300 4,858.32 4,858.32
Taxes 23‐4461‐0300 1,089.04 1,089.04
Workers Com01‐4145‐0350 1,494.00 1,494.00
Workers Com01‐4300‐0350 3,262.00 3,262.00Workers Com71‐4454‐0350 9,711.00 9,711.00Workers Com10‐4420‐0350 17,322.00 17,322.00Workers Com12‐4425‐0350 16,021.00 16,021.00Workers Com23‐4461‐0250                       ‐ ‐ Insurance 01‐4145‐0400 11,715.02 11,715.02
Insurance 01‐4300‐0400 11,715.02 11,715.02
Insurance 71‐4454‐0400 36,234.31 36,234.31
Insurance 10‐4420‐0400 10,842.03 10,842.03
Insurance 12‐4425‐0400 10,842.03 10,842.03
Insurance 23‐4461‐0400 2,530.81 2,530.81
Def Comp 01‐4145‐0545 1,482.62 1,482.62
Def Comp 01‐4300‐0545 1,482.62 1,482.62
Def Comp 71‐4454‐0545 1,976.83 1,976.83
Def Comp 10‐4420‐0545                       ‐ ‐Def Comp 12‐4425‐0545                       ‐ ‐ Def Comp 23‐4461‐0545                       ‐ ‐
Dental 01‐4145‐0560 754.18 754.18
Dental 01‐4300‐0560 754.18 754.18
Dental 71‐4454‐0560 2,803.79 2,803.79
Dental 10‐4420‐0560 787.97 787.97
Dental 12‐4425‐0560 787.97 787.97
Dental 23‐4461‐0560 155.64 155.64
Vision 01‐4145‐0570 116.17 116.17
Vision 01‐4300‐0570 116.17 116.17
Vision 71‐4454‐0570 343.25 343.25
Vision 10‐4420‐0570 95.67 95.67
Vision 12‐4425‐0570 95.67 95.67
Vision 23‐4461‐0570 22.42 22.42
639,006.40 658,790.54
47,810.00
Bldg Maint 01‐4145 86,537.68
Parks 01‐4300 88,183.27
Meas A 71‐4454 244,117.99
Water 10‐4420 107,719.68
Wstwater 12‐4425 106,418.68
transit 23‐4461 25,813.23
658,790.54
‐
3 Police Dept
Base 0100 0100 0545 0450 0100 0100
Current Next Hrly rate remaining Regular Total Employer Employer Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Uniform Holiday POST/EDU Gross Payroll Taxes PERS med/life Den Vis Total Benefits Costs CA01 Michael Cash N/A N/A 10/9/2022 64.044 2080 137,207.87        ‐                   ‐                    ‐      ‐ 1,196.00                ‐ 138,403.87 10,023.54 14,818.45 18,133.83 963.53 136.14 44,075.49 182,479.35 BRI01 Norma Bribiesca POA 171/D 1/1/2023 36.584 2080 77,996.11          ‐ 3,250.00 12,675.00      ‐ 1,398.00 8,579.57 103,898.68 7,906.98 6,709.98 155.01 1,556.41 224.22 16,552.60 120,451.28 ‐                        ‐ ‐
IWA02 Steve Iwasko POA 182/F max 41.279 2080 85,860.96       ‐ 15,000.00 1,028.82 1,398.00 5,935.14 7,343.69 116,566.61 8,917.35 17,845.16 12,751.02 502.22 85.23 40,100.98 156,667.59 JAI01 Miguel Jaimes POA 182/new A 12/1/2021 33.961 2080 72,698.84 17,600.00           ‐ 3,250.00 1,398.00 5,025.31 2,331.72 102,303.87 7,238.00 8,997.03 14,097.51 1,556.41 85.23 31,974.19 134,278.06 unfilled emergency coord SEIU 218/A 37.380 2080 77,749.84          ‐ 3,250.00 80,999.84 6,196.49 6,050.69 14,097.51 1,556.41 85.23 27,986.33 108,986.17 LEN01 Cian Lenehen POA 182/C 1/1/2023 35.660 2080 76,026.33       ‐ 24,300.00 12,135.50 1,398.00 5,255.32 3,251.27 122,366.42 9,361.03 9,129.56 127.84 1,556.41 224.22 20,399.06 142,765.48 ‐                        ‐ ‐
LIM02 Carlos Limon POA Lieutenant/C 59.212 2080 123,160.15        ‐           ‐ 3,250.00      ‐ 1,398.00 8,621.21 136,429.36 9,845.38 24,305.64 14,078.35 1,556.41 224.22 50,010.01        ‐ 186,439.37 MED01 Frank Medina POA 202/D (sgt) 4/1/2023 45.105 2080 94,991.21 24,400.00 3,250.00 972.14 1,398.00 6,566.27 8,124.60 139,702.22 10,673.60 20,327.77 13,028.16 502.22 85.23 44,616.97 184,319.19 MEN01 Joana Mendosa POA 159/D 1/1/2023 33.925 2080 72,328.33          ‐           ‐ 3,250.00      ‐ 1,398.00 76,976.33 5,297.22 5,645.70 14,051.18 1,556.41 224.22 26,774.74 103,751.07 MER02 Josue Meraz SEIU 1/1/2023 29.118 2080 62,079.79          ‐           ‐ 3,250.00         ‐ 699.00                ‐ 66,028.79 5,009.93 9,146.17 21,989.68 1,556.41 224.22 37,926.42 103,955.21 MIL03 Heath Miller POA 182/D 9/1/2022 37.442 2080 81,123.32       ‐ 26,800.00                    ‐ 1,398.00 5,607.65 5,419.24 120,348.20 8,615.19 9,952.22 14,097.51 1,556.41 224.22 34,445.56 154,793.76 NEG01 Maria Negranti POA 182/D 7/1/2022 39.314 2080 81,772.30 20,600.00           ‐ 3,250.00 1,398.00 5,652.51 2,622.74 115,295.56 8,230.67 10,076.14 14,097.51 1,556.41 136.14 34,096.87 149,392.42 ORO01 Chris Orozco POA 182/New B 8/1/2022 33.961 2080 73,876.84 38,200.00 3,250.00 4,855.76 1,398.00      ‐ 5,106.74 126,687.34 9,687.64 8,881.23 8,541.10 502.22 170.46 27,782.65 154,469.99 RUI03 Edwin Ruiz POA 182/New a 1/1/2023 33.961 2080 72,404.51 22,400.00 3,250.00 151.32 1,398.00 5,004.96 2,600.00 107,208.80 8,187.85 8,992.02 13,009.00 502.22 85.23 30,776.31 137,985.11 RUI01 Omar Ruiz POA 182/New B 3/1/2023 33.961 2080 71,816.53 47,400.00 3,250.00 1,206.66 1,398.00 4,964.32 8,742.47 138,777.98 10,602.89 9,587.52 12,753.88 502.22 85.23 33,531.74 172,309.72 unfilled replace I. Reyes POA 182/B 33.960 2080 70,637.07          ‐           ‐ 3,250.00 1,398.00      ‐ 4,882.79 80,167.86 5,544.59 8,507.14 12,753.88 502.22 85.23 27,393.07 107,560.92 unfilled replace J. bahena POA 182/A 32.343 2080 67,273.50          ‐           ‐ 3,250.00 1,398.00      ‐ 4,650.28 76,571.78 5,269.49 8,118.77 12,753.88 502.22 85.23 26,729.59 103,301.37 KUH01 Michael Kuhbander POA 182/E 9/13/2022 39.313 2080 85,178.25          ‐                   ‐                    ‐ 1,398.00 5,887.95 12,293.94 104,758.14 6,872.35 11,162.89 14,073.20 1,556.41 224.22 33,889.08 138,647.22 WRI01 Rob Wright POA 182/E 6/14/2022 41.279 2080 85,859.68          ‐                   ‐                    ‐ 1,398.00 5,935.05 11,015.37 104,208.10 7,380.45 11,103.49 14,073.20 1,556.41 224.22 34,337.78 138,545.88 Rosanne Tesoro temp 20.175 390 7,868.25            ‐                   ‐                    ‐                    ‐               ‐                ‐ 7,868.25 601.92 0 0 0 0 601.92 8,470.17 Matsuura temp 15.000 702 10,530.00          ‐                   ‐                    ‐                    ‐               ‐                ‐ 10,530.00 805.55 0 0 0 0 805.55 11,335.55 1,588,439.69 236,700.00 42,250.00 33,025.20 24,263.00 70,474.28 80,945.81 2,076,097.99 152,268.10 209,357.58 238,663.28 21,599.58 2,918.34 624,806.89 2,700,904.87 Estimated Costs Unfunded Liab Total
Reg 01‐4200‐0100 1,729,409.57 1,729,409.57Part time 01‐4200‐0125                         ‐ ‐ Temp 01‐4200‐0150 18,398.25 18,398.25Overtime 01‐4200‐0200 236,700.00 236,700.00 Retirement 01‐4200‐0250 205,652.97 108,773.15 314,426.12 Taxes 01‐4200‐0300 149,762.21 149,762.21
Workers Com01‐4200‐0350 149,415.00 149,415.00
Insurance 01‐4200‐0400 234,129.82 234,129.82
Benefits 01‐4200‐0450 24,263.00 24,263.00
Def Comp 01‐4200‐0545 33,025.20 33,025.20
Dental 01‐4200‐0560 21,358.69 21,358.69Vision 01‐4200‐0570 2,884.31 2,884.31 Total 2,804,999.03 2,913,772.18Diff 104,094.16
diff is chief's 25% to fire 45,320.84
149,415.00
4 Fire Dept
Base 0100 0100 0545 0450 0100 0100
Current Next Hrly rate remaining Regular Total Employer Employer Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Uniform Holiday Incentives Gross Payroll Taxes PERS med/life Den Vis Total Benefits Costs CA01 Michael Cash N/A N/A 10/9/2022 64.044 2080 137,207.87        ‐                  ‐                ‐    ‐ 1,196.00                ‐ 138,403.87 10,023.54 14,818.45 18,133.83 963.53 136.14 44,075.49 182,479.35 unfilled Batallion Chief 54.180 2080 112,694.40 1,495.00 114,189.40 8,695.01 12,171.00 12,340.61 502.22 85.23 33,794.07 147,983.47 GAR03 Fernando Garcia IAFF 184/L2 Max 34.254 2756 94,403.14 23,234.59      ‐ 3,250.00 1,495.00 7,481.00 7,413.05 137,276.79 9,919.55 20,258.50 25,161.42 1,556.41 224.22 57,120.11 194,396.90 GAR07 Issac Garcia IAFF 171/B 9/1/2022 24.761 2756 71,062.67 20,045.23      ‐ 3,250.00 1,495.00 5,678.18 4,604.45 106,135.53 8,092.52 9,136.29      ‐ 11,258.26                ‐ 28,487.07 134,622.60MAC01 Ryan Mack IAFF 184/D 6/1/2022 32.623 2756 89,908.43      ‐ 23,199.02                ‐ 1,495.00 7,124.82 11,973.66 133,700.93 10,187.65 11,772.75 12,340.61 502.22 85.23 34,888.45 168,589.38 NUN01 Jacob Nuno IAFF 171/A 5/1/2022 24.761 2756 68,241.90 19,566.99      ‐ 3,250.00 1,495.00 5,407.85 5,718.99 103,680.73 7,891.10 8,922.82 12,359.49 502.22 85.23 29,760.86 133,441.58REY04 Lupe Reyes IAFF 171/B 9/1/2022 24.761 2756 71,062.67 20,519.06      ‐ 3,250.00 1,495.00 5,678.18 8,441.49 110,446.40 8,449.15 9,550.69      ‐ 13,000.70                ‐ 31,000.54 141,446.94 SCH02 Pat Schmitz IAFF 184/L1 7/1/2023 32.623 2756 89,909.51 22,604.62      ‐ 3,250.00 1,495.00 7,124.90 7,122.06 131,506.10 10,046.59 19,333.17 12,981.83 502.22 85.23 42,949.03 174,455.13 PCF's part time 35,000.00 35,000.00 2,677.50 0 0 0 0 2,677.50 37,677.50 Ramos temp 15.000 702 10,530.00          ‐                  ‐                ‐                 ‐              ‐                ‐ 10,530.00 805.55 0 0 0 0 805.55 11,335.55 780,020.59 129,169.52    ‐ 16,250.00 ######## 38,494.94 45,273.70 1,020,869.74 76,788.15 105,963.66 117,576.76 4,528.81 701.27 305,558.65 1,326,428.39 Estimated Costs Unfunded Liab Total
Reg 01‐4220‐0100 731,603.33 731,603.33part time 01‐4220‐0125 35,000.00 35,000.00 temp 01‐4220‐0150 10,530.00 10,530.00
overtime 01‐4220‐0200 129,169.52 129,169.52Retirement 01‐4220‐0250 94,849.82 52,645.98 147,495.80Taxes 01‐4220‐0300 69,270.50 69,270.50 workers comp01‐4220‐0350 69,791.00 69,791.00
Insurance 01‐4220‐0400 103,976.39 103,976.39Benefits 01‐4220‐0450 10,465.00 10,465.00 Def Comp 01‐4220‐0545                      ‐ ‐
Dental 01‐4220‐0560 3,806.16 3,806.16
Vision 01‐4220‐0570 599.17 599.17
Total 1,259,060.88 1,311,706.86
Diff (67,367.51)
diff is chief's 75% to PD 137,158.51
69,791.00

0.00 5
Parks & Rec
Base 0125 0100 0545 0450 0100 0100
Current Next Hrly rate Remaining Regular Total Employer Employer Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost Bilgl Def Comp Uniform Holiday POST/EDU Gross Payroll Taxes PERS med/life Den Vis Total Benefits Costs FUE01 Hannah Fuentes unrep 1/1/2023 32.844 2080 70,022.58 2,471.04 72,493.62 5,532.16 5,415.27 8,535.96 502.22 85.23 20,070.83 92,564.45 ‐                        ‐ ‐
FIG01 Mayra Figueroa SEIU part time 151/A 5/1/2023 20.151 936 18,939.85 3,250.00 22,189.85            ‐ 1,697.52                    ‐                   ‐                ‐ 1,697.52 23,887.37 GUT03 Jacob Gutierrez temp 15.000 390 5,850.00 5,850.00 447.53 447.53 6,297.53 ‐                        ‐ ‐‐                        ‐ ‐ 94,812.43 3,250.00      ‐ 2,471.04             ‐                ‐ 100,533.47 7,677.21 5,415.27 8,535.96 502.22 85.23 22,215.88 122,749.34 Estimated Costs Unfunded Liab Total
Reg 01‐4300‐0100 134,656.42 134,656.42
Part 01‐4300‐0125 18,939.85 18,939.85
TEMP 01‐4300‐0150 5,850.00
Retirement 01‐4300‐0250 10,111.40 262.05 10,373.45
Taxes 01‐4300‐0300 12,450.52 12,450.52
workerscomp01‐4300‐0350 3,262.00 3,262.00
Insurance 01‐4300‐0400 20,250.97 20,250.97
Def Comp 01‐4300‐0545 3,953.66 3,953.66
Dental 01‐4300‐0560 1,256.40 1,256.40
Vision 01‐4300‐0570 201.40 201.40
Total 210,932.62 205,344.67
Diff 88,183.27
‐
6 Permit Dept
Base 0100 0100 0545 0450 0100 0100
Current Next Hrly rate Annual Regular Total Employer Employer Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost Bilgl Def Comp Uniform Holiday POST/EDU Gross Payroll Taxes PERS med/life Den Vis Total Benefits Costs SAU01 Alice Saucedo SEIU 181/L2 max 34.664 2080 72,100.33          ‐       ‐ 2,471.04              ‐                ‐ 74,571.37 5,697.65 10,094.05 8,541.10 502.22 85.23 24,920.24 99,491.61 unfilled associate planner SEIU 218/B 39.249 2080 81,638.29 81,638.29 6,231.72 6,098.38 8,541.10 502.22 85.23 21,458.65 103,096.95 ‐ 153,738.62      ‐ 2,471.04             ‐                ‐ 156,209.66 11,929.37 16,192.43 17,082.21 1,004.43 170.46 46,378.89 202,588.56 Estimated CostsUnfunded Liab Total
Reg 01‐4405‐0100 153,738.62 153,738.62
Retirement 01‐4405‐0250 16,192.43 23,537.76 39,730.19Taxes 01‐4405‐0300 11,929.37 11,929.37workers comp01‐4405‐0350 5,528.00 5,528.00 Insurance 01‐4405‐0400 17,082.21 17,082.21Benefits 01‐4405‐0450                      ‐ ‐ Def Comp 01‐4405‐0545 2,471.04 2,471.04
Dental 01‐4405‐0560 1,004.43 1,004.43
Vision 01‐4405‐0570 170.46 170.46
Total 208,116.56 231,654.32Diff 5,528.00
7 Water Dept
Base
Current Next Hrly rate Annual Regular pager Total Employer Employer Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost OT Bilgl other ben Gross Payroll Taxes PERS med/life Den Vis Total Benefits Costs SAG01 Jose Sagisi SEIU 162A/C 10/1/2022 25.749 2080 55,566.28     ‐ 7,210.00 6,000.00 68,776.28 5,220.11 5,137.59 22,008.84 1,556.41 224.22 34,147.18 102,923.46 VID01 Jaime Vidales SEIU 205A/D 4/1/2023 41.062 2080 85,408.92 12,500.00 3,250.00 6,000.00 107,158.92 8,156.39 12,412.25 22,008.84 1,556.41 224.22 44,358.11 151,517.03 140,975.20 ######## 3,250.00 12,000.00 175,935.20 13,376.50 17,549.84 44,017.69 3,112.82 448.45 78,505.30 254,440.49 Estimated CostsUnfunded Liab Total
Reg 10‐4420‐0100 210,015.51 210,015.51
temp 10‐4420‐0150                     ‐ ‐
OT 10‐4420‐0200 19,710.00 19,710.00
Retirement 10‐4420‐0250 25,573.21 42,427.82 68,001.03
Taxes 10‐4420‐0300 18,234.82 18,234.82
workers com 10‐4420‐0350 17,322.00 17,322.00
Insurance 10‐4420‐0400 54,859.72 54,859.72
other ben 10‐4420‐0450 12,000.00 12,000.00
Dental 10‐4420‐0560 3,900.80 3,900.80Vision 10‐4420‐0570 544.12 544.12 362,160.17 404,587.99
107,719.68
‐
8 Wastewater Dept
Base
Current Next Hrly rate Annual Regular pager Total Employer Employer Employer Employer Employer Employer Total ID Employee Union Step Increase at 7/1 Hours Cost OT Bilgl def comp other ben Gross Payroll Taxes PERS med/life Den Vis Total Benefits Costs VAL01 Devin Valdivia SEIU 188A 9/1/2022 29.118 2080 63,089.22       ‐ 9,400.00 2,471.04 6,000.00 80,960.26 6,179.85 4,897.35 8,535.96 502.22 85.23 20,200.61 101,160.86 MIK01 David Miklas SEIU 205A/B 7/1/2022 37.245 2080 77,468.97     ‐ 16,500.00              ‐ 6,000.00 99,968.97 6,762.52 5,786.93 21,483.46 1,556.41 224.22 35,813.55 135,782.52new Vargas SEIU 20.000 2080 41,600.00 41,600.00 3,182.40 3,107.52 8,535.96 502.22 85.23 15,413.32 57,013.32 182,158.19    ‐ 25,900.00 2,471.04 12,000.00 222,529.23 16,124.78 13,791.80 38,555.37 2,560.84 394.68 71,427.48 293,956.70 remaining costunfunded liabTotal
Reg 12‐4425‐0100 247,948.50 247,948.50OT 12‐4425‐0200 25,900.00 25,900.00Retirement 12‐4425‐0250 21,815.18 14,990.65 36,805.83 Taxes 12‐4425‐0300 20,983.10 20,983.10
workerscomp12‐4425‐0350 16,021.00 16,021.00Insurance 12‐4425‐0400 49,397.40 49,397.40other ben 12‐4425‐0450 12,000.00 12,000.00def comp 12‐4425‐0545 2,471.04 2,471.04Dental 12‐4425‐0560 3,348.82 3,348.82 Vision 12‐4425‐0570 490.35 490.35
400,375.39 415,366.04
106,418.68
‐
340,055.98 total unfunded liab316,675.00 total workers comp (549.00) workers comp council not in this workbook
9 
Base Pay Allocation Dept
Name Department % Amt as of % 196,659.00 Alloc
Alloc ESTIMATE ANNUAL
01 4300 Parks & Rec
PARKS & REC POSITION 01 4300 0250                  ‐ 0.00% 0.00 01 4120 ‐ Finance
PEREYRA‐LEON, ANGELITA 01 4120 0250 91,546.86 15.09% 29,679.54 VERONICA FABIAN 01 4120 0250 60,799.54 10.02% 19,711.24 49,390.78 Police
MERAZ, JOSUE, I 01 4200 0250 100% 62,079.79 62,079.79 10.23% 20,126.30

0.00 0.00 0.00% 0.00

0.00 0.00 0.00% 0.00
62,079.79             ‐ s/b zero
01 4105 ‐ Admin
MERINO‐ESCOBAR, JUANA 01 4105 0250 84,693.36 13.96% 27,457.63 Various
VIDALES, JAIME, N 10 4420 0250 85,408.92 14.08% 27,689.62 PENA, MICHAEL, R 10 4420 0250    30% 0.00 0.00 0.00% 0.00 71 4454 0250    30% 0.00 0.00 0.00% 0.00
12 4425 0250    30% 0.00 0.00 0.00% 0.00
01 4145 0250     5% 0.00 0.00 0.00% 0.00
01 4300 0250     5% 0.00 0.00 0.00% 0.00
SWEENEY, SHANNON 10 4420 0250    30% 44,990.40 44,990.40 7.42% 14,585.91 71 4454 0250    30% 44,990.40 44,990.40 7.42% 14,585.91 12 4425 0250    30% 44,990.40 44,990.40 7.42% 14,585.91 23 4461 0250     5% 7,498.40 7,498.40 1.24% 2,430.99
23 4461 0250     5% 7,498.40 7,498.40 1.24% 2,430.99
149,968.00             ‐ s/b zero
12 4425 ‐ Wastewater
12 4425 0250 0.00% 0.00
Fire
SAUCEDO, ALICE, R 01 4405 0250    100% 72,100.33 72,100.33 11.89% 23,374.96 01 4220 0250    0% 0.00 0.00 0.00% 0.00
72,100.33             ‐ s/b zero
01 4200 Police
01 4200 0250 0.00% 0.00
Total 606,596.8 100.00% 196,659.00             ‐ s/b zero 100.00%             ‐ s/b zero
Allocation
01 4105 0250 27,457.63 MOMS # Base Pay ESTIMATE ANNUAL
01 4120 0250 49,390.78 GUZ01 C. Guzman                             ‐ 01 4145 0250   0.00
01 4200 0250 20,126.30 PER01 A. Leon                 91,546.86 01 4220 0250    0.00
01 4300 0250 0.00 MER02 J. Meraz                 62,079.79 01 4405 0250 23,374.96
10 4420 0250 42,275.53 MER01 J. Escobar                 84,693.36 12 4425 0250 14,585.91 FAB01 V. Fabian                 60,799.54 23 4461 0250 4,861.97
71 4454 0250    14,585.91 VID01 J. Vidales                 85,408.92 Total 196,659.00 PEN01 M. Pena                             ‐ SWE01 S. Sweeney               149,968.00

0.00 SAU01 A Saucedo                 72,100.33
TOTAL               606,596.80
340,056.00 3,654,282.39
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Class 1169 (Classic‐Miscellaneous)
Fiscal Year 22‐23 estimate
N:\2022-2023 Budget\Workpapers\addressed\Contribution Detail Report-Unfunded Liab est FY2023 6/8/2022
Base Pay Allocation Dept
Name Department Amt as of % 136,295.00 Total
MOMS # est 2022
LIMON, CARLOS, H 01 4200 0250 LIM02 123,160.15 25.22% 34,374.88 IWASKO, STEVEN, D 01 4200 0250 IWA02 85,860.96 17.58% 23,964.41 MEDINA, FRANK 01 4200 0250 MED01 94,991.21 19.45% 26,512.73 84,852.02 SCHMITZ, PATRICK, B 01 4220 0250 SCH02 89,909.51 18.41% 25,094.39 GARCIA, FERNANDO 01 4220 0250 GAR03 94,403.14 19.33% 26,348.59 51,442.98 Total 488,324.97 100.00% 136,295.00 ######
Allocation
01 4200 0250 84,852.02
01 4220 0250 51,442.98
Total 136,295.00
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Class 1170 (Classic-Safety)
Fiscal Year 22‐23 estimate
N:\2022-2023 Budget\Workpapers\addressed\Contribution Detail Report-Unfunded Liab est FY2023 6/8/2022
Base Pay Allocation Dept
PEPRA Misc 26751 Amt as of % 2,559.00 Total
est 2023
% MOMS #
Bodem, Todd 01 4105 0250 BOD01 137,500.48 10.72% 274.21 HR 01 4105 0250 79,977.93 6.23% 159.49
Zarate, Lorena 01 4120 0250 ZAR01 108,003.10 8.42% 215.38 Rivas, Isaias 01 4120 0250 RIV01 68,666.06 5.35% 136.94 Gutierrez, Rudy 71 4454 0250 80% GUT01 48,258.79 3.76% 96.24 60,323.49 01 4145 0250 10% 6,032.35 0.47% 12.03
01 4300 0250 10% 6,032.35 0.47% 12.03
Batalla, james 71 4454 0250 80% bat01 38,176.51 2.98% 76.13 47,720.64 01 4145 0250 10% 4,772.06 0.37% 9.52
01 4300 0250 10% 4,772.06 0.37% 9.52
New eng tech 71 4454 0250 33% new 20,799.91 1.62% 41.48 62,405.97 10 4420 0250 33% 20,799.91 1.62% 41.48
12 4425 0250 33% 20,799.91 1.62% 41.48
Montero, Juan 01 4300 0250 50% new 21,739.51 1.69% 43.35 43,479.02 01 4145 0250 50% 21,739.51 1.69% 43.35
new lead 01 4300 0250 50% new 28,839.92 2.25% 57.51
57,679.84 01 4145 0250 50% 28,839.92 2.25% 57.51
Fuentes, Hannah 01 4300 0250 FUE01 70,022.58 5.46% 139.64 new assoc planner 01 4405 0250 new 81,638.29 6.36% 162.80 Sagisi, Jose 10 4420 0250 SAG01 55,566.28 4.33% 110.81
Miklas, David 12 4425 0250 MIK01 77,468.97 6.04% 154.49 Valdivia, Devin 12 4425 0250 VAL01 63,089.22 4.92% 125.81 Vargas 12 4425 0250 new 41,600.00 3.24% 82.96
Bribriesca, Norma 01 4200 0250 BRI01 77,996.11 6.08% 155.54 emergency 01 4200 0250 new 77,749.84 6.06% 155.05
Mendosa, Joana 01 4200 0250 MEN01 72,328.33 5.64% 144.24 Total ######### 100.0% 2,559.00
PEPRA Safety 25554 & 25555 Allocation
3,340.00
Police MOMS #
unfilled 01 4200 0250 new 67,273.50 6.89% 230.25
unfilled 01 4200 0250 new 70,637.07 7.24% 241.76
Wright 01 4200 0250 wri01 85,859.68 8.80% 293.86
Kuhbander 01 4200 0250 kuh01 85,178.25 8.73% 291.53
Cash, Michael 01 4200 0250 CAS01 137,207.87 14.06% 469.60 Lenehan, Cian 01 4200 0250 LEN01 76,026.33 7.79% 260.21 Miller, Heath 01 4200 0250 MIL03 81,123.32 8.31% 277.65 Negranti, Maria 01 4200 0250 NEG01 81,772.30 8.38% 279.87 Orozco, Chris 01 4200 0250 ORO01 73,876.84 7.57% 252.85 Ruiz, Edwin 01 4200 0250 RUI03 72,404.51 7.42% 247.81
Ruiz, Omar 01 4200 0250 RUI01 71,816.53 7.36% 245.80
Jaimes, Miguel 01 4200 0250 JAI01 72,698.84 7.45% 248.82 975,875.04 sub-total 3,340.00
Fire 1,203.00
Mack, Ryan 01 4220 0250 MAC01 89,908.43 29.94% 360.20
Garcia, Isaac 01 4220 0250 GAR07 71,062.67 23.67% 284.70 Nuno, Jacob 01 4220 0250 NUN01 68,241.90 22.73% 273.40
Reyes, Guadalupe 01 4220 0250 REY04 71,062.67 23.67% 284.70 300,275.67 sub-total 1,203.00
Total 1,276,150.71 200.0% 4,543.00
Allocation PEPRA Misc
01 4105 0250 433.70
01 4120 0250 352.32
71 4454 0250 213.85
01 4145 0250 122.41
01 4300 0250 262.05
01 4405 0250 162.80
10 4420 0250 152.29
12 4425 0250 404.74
01 4200 0250 454.83
Total 2,559.00

0.00 Allocation PEPRA Safety
01 4200 0250 3,340.00
01 4220 0250 1,203.00
Total 4,543.00

0.00 340,056.00
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Fiscal Year 22‐23 estimate
Class 26751 and 25554/25555 (PEPRA)
N:\2022-2023 Budget\Workpapers\addressed\Contribution Detail Report-Unfunded Liab est FY2023 6/8/2022
Water Deliveries‐Fiscal Year Basis (AF) (1) FY 22/23 FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 28/29 FY 29/30 FY 30/31 FY 31/32 Water Deliveries‐1st Quarter 3 3 77 77 77 77 77 77 77 77 Water Deliveries‐2nd Quarter 3 3 87 87 87 87 87 87 87 87 Water Deliveries‐3rd Quarter 3 3 102 102 102 102 102 102 102 102 Water Deliveries‐4th Quarter 3 3 92 92 92 92 92 92 92 92 Total FY Water Deliveries (acre‐feet) 12 12 358 358 358 358 358 358 358 358 CCWA Variable Cost per AF Assumptions 128 $ $ 135 $ 142 $ 149 $ 156 $ 164 $ 172 $ 181 $ 190 $ 199 DWR Variable Cost per AF Assumptions 275 $ $ 303 $ 318 $ 334 $ 351 $ 369 $ 387 $ 406 $ 427 $ 448 CCWA Costs
CCWA Fixed O&M Costs (2) $ 115,601 $ 119,069 $ 122,641 $ 126,321 $ 130,110 $ 134,014 $ 138,034 $ 142,175 $ 146,440 $ 146,440 CCWA Variable O&M Costs (5) 1,540 1,618 50,725 53,261 55,925 58,721 61,657 64,740 67,977 71,375 CCWA(Credits) Amount Due (20,705)
Subtotal: CCWA Costs 96,437 120,687 173,367 179,582 186,035 192,734 199,691 206,915 214,417 217,816 DWR Costs (7)
Transportation Capital 283,361 310,559 321,294 321,222 321,206 321,113 320,923 320,849 320,759 320,428 Coastal Branch Extension                      ‐ ‐                  ‐                   ‐                   ‐                   ‐                   ‐                   ‐                    ‐                          ‐ Water System Revenue Bond Surcharge ‐ 13,654 12,825 11,672 10,976 13,185 8,412 11,284 916 19,069 Transportation Minimum OMP&R 62,037 157,554 158,613 160,199 160,410 163,419 165,053 166,704 168,371 170,055 Delta Water Charge 59,518 68,984 72,526 76,244 80,149 84,249 88,554 93,074 97,820 99,668 DWR Variable Costs (5) (6) 2,849 3,638 114,096 119,800 125,790 132,080 138,684 145,618 152,899 160,544 Subtotal: DWR Costs 407,766 $ $ 554,389 $ 679,353 $ 689,138 $ 698,531 $ 714,046 $ 721,626 $ 737,528 $ 740,765 $ 769,763 Total Projected State Water Costs $ 504,203 $ 675,076 $ 852,720 $ 868,720 $ 884,566 $ 906,780 $ 921,317 $ 944,443 $ 955,182 $ 987,579 Projected Payments by Due Date
June 1st Fixed Payment (3) $ 499,814 $ 669,821 $ 687,899 $ 695,658 $ 702,851 $ 715,980 $ 720,977 $ 734,086 $ 734,306 $ 755,660 July 1st Variable Payment (4) 1,097 1,314 35,319 37,085 38,939 40,886 42,930 45,077 47,330 49,697 October 1st Variable Payment 1,097 1,314 40,010 42,010 44,110 46,316 48,632 51,063 53,617 56,297 January 1st Variable Payment 1,097 1,314 47,000 49,350 51,817 54,408 57,128 59,985 62,984 66,133 April 1st Variable Payment 1,097 1,314 42,493 44,617 46,848 49,191 51,650 54,233 56,944 59,792 Central Coast Water Authority
City of Guadalupe
State Water Cost Ten‐Year Projections
Fiscal Year 2022/23 Final Proposed Budget
GENERAL FUND REIMBURSEMENT TRANSFERS Table 7
2022-23
Per Cost
Per Estimate Allocation Imposed
Table 2 Plan Limitation* Variance Use
Special Revenue Funds
Street & Roads Funds 126,300 27,900 98,400 126,300
Lighting and Landscape Maintenance 9,800 12,700 2,900 12,700 CDBG - Microenterprise - - -
Enterprise Funds
Water Fund Operating 335,200 19,600 315,600 335,200
Wastewater Fund Operating 272,000 45,400 226,600 272,000 Transit Fund 35,000 76,200 41,200 76,200
Successor Agency per 22-23 ROPS 188,872 - 188,872 188,872 Total $874,272 $1,011,272 $137,000 $1,011,272* Not currently allowed by funding sources need approval by the Department of Transportation - 24 -
Healthier communities through leadership, partnership & science MGT Analysis – Full Cost Recovery