File #:
|
2021-936
Version:
1
|
Name:
|
|
Type:
|
Discussion
|
Status:
|
Agenda Ready
|
On agenda:
|
2/15/2022
|
Final action:
|
|
Title:
|
FISCAL YEAR 2021-2022 MID-YEAR FINANCIAL REPORT AND CONSIDER ADOPTION OF RESOLUTION NO. 22-021 TO AMEND THE FISCAL YEAR 2021-2022 BUDGET (CITY COUNCIL).
|
Report to Mayor and City Council
Tuesday, February 15, 2022
Discussion
SUBJECT:
Title
FISCAL YEAR 2021-2022 MID-YEAR FINANCIAL REPORT AND CONSIDER ADOPTION OF RESOLUTION NO. 22-021 TO AMEND THE FISCAL YEAR 2021-2022 BUDGET (CITY COUNCIL).
Body
I. SUMMARY
The Finance Department performs an ongoing review of the City’s financial performance and provides updates on the General Fund results to the Mayor and the City Council. The report presents the City’s financial condition in the current Fiscal Year (2021-2022) based on actual revenue and expenditures for the period of July 1 through December 31, 2021. In addition, the report includes a Mid -Year budget funding reallocation request from Public Works department.
II. RECOMMENDATION
Recommendation
1. RECEIVE and FILE Mid -Year Budget Report
2. Adopt Resolution No. 22-021, A RESOLUTION OF THE CITY OF CARSON CITY COUNCIL AMENDING THE FISCAL YEAR 2021-2022 BUDGET IN THE GENERAL FUND.
1.
Body
III. ALTERNATIVES
TAKE another action deemed appropriate by City Council.
IV. BACKGROUND
The City Council adopted the Fiscal Year 2021-2022 Budget at its June 15, 2021 meeting. The Mid-Year budget report analyzes the budget status at the mid-point of the current fiscal year and updates the Mayor and the City Council on the City of Carson’s financial position. The report provides an opportunity to adjust expenditures appropriation based on changed needs or priorities.
The Mid-Year Report is focused on the City’s General Fund as the main operating fund for the City. Staff reviewed and is proposing adjustments to account to changing needs and new priorities within each department, considering anticipated expenditures for the remainder of the fiscal year (June 30, 2022).
The Fiscal Year 2021-2022 Budget was adopted by the City Council to maintain levels of service to the residents for the City of Carson and enhance public safety efforts.
General Fund Revenue Update
At the end of Fiscal Year 2020-2021, the General Fund revenue totaled $93.1 million. This is $6 million (or 7%) higher than originally planned as stated on Table (1).
Table (1): FY 2020-2021 General Fund Revenue by Category
Revenue Source |
Budget |
Actual |
Variance |
Sales and Use Tax |
$23,203,365 |
$30,133,399 |
$6,930,034 |
Franchise Tax |
$9,366,800 |
$11,333,349 |
$1,966,549 |
Property Tax |
$15,274,891 |
$17,177,864 |
$1,902,973 |
Transient Occupancy Tax |
$1,935,000 |
$1,647,103 |
($287,897) |
Utility Users Tax |
$7,000,000 |
$8,670,113 |
$1,670,113 |
Real Property Transfer |
$288,000 |
$583,413 |
$295,413 |
Oil Business Tax |
$4,230,000 |
$2,451,181 |
($1,778,819) |
License and Permits |
$8,048,539 |
$6,845,910 |
($1,202,629) |
Fines and Fees |
$9,009,454 |
$7,602,815 |
($1,406,639) |
Charges for Services |
$3,066,850 |
$910,822 |
($2,156,028) |
Investment Income |
$550,000 |
$280,571 |
($269,429) |
Miscellaneous |
$5,123,500 |
$5,547,123 |
$423,623 |
Total |
$87,096,399 |
$93,183,665 |
$6,087,266 |
Based on year-to-date information, revenue receipts do not follow an even schedule or linear trend. Although 50% of fiscal year 2021-2022 has elapsed, revenues are exceeding historic trends, revenues are estimated to be at approximately 52% of the budgeted amount as stated on Table (2). Most notable are revenues collected for License and Permits which exceeded budget by $1.2 million dollars. Specifically, we received $1.8 million for Building Construction Permits, and $1.6 million in Regulatory Business Permits in the first half of the year.
General Fund revenues collected through December 30, 2021 are $47.9 million (or 52% of budget). Revenue receipts for the second quarter do not necessarily provide a “clear” picture of revenue receipts for the fiscal year, as receipts are seasonal with major revenues such as property taxes not being received until February or March. Sales taxes for the October-December quarter are not finalized until end of February. Business license tax receipts begin in February and peak in March towards the beginning of the annual renewal period. The total revenue is conservatively projected to be in line with the budget and it also should be noted that the lag in timing of revenue receipts is one reason an operating cash reserve continues to be necessary.
The Fiscal Year 2021-2022 General Fund revenue budget, as adopted, totals approximately $92.9 million. Based on economic activity and revenue collections through December 2021, staff is anticipating that total revenues will produce significant increases over the amounts originally budgeted.
Table (2): FY 2021-2022 General Fund Revenue by Category
Revenue Source |
Adopted Budget |
Actuals |
% Collected |
Sales Tax |
$27,355,883 |
$13,770,764 |
50% |
Franchise Tax |
$9,500,000 |
$2,611,803 |
27% |
Property Tax |
$16,972,574 |
$8,663,352 |
51% |
Transaction User Tax (Measure K) |
$13,900,000 |
$6,213,683 |
45% |
Transient Occupancy Tax |
$1,935,000 |
$857,779 |
44% |
Utility Users Tax |
$7,450,000 |
$5,919,525 |
79% |
Oil Business Tax |
$4,700,000 |
$1,173,036 |
25% |
License and Permits |
$2,900,000 |
$4,136,336 |
143% |
Fines and Fees |
$2,400,000 |
$1,247,722 |
52% |
Charges for Services |
$5,800,000 |
$1,025,415 |
18% |
Miscellaneous |
|
$2,297,854 |
|
Total |
$92,913,457 |
$47,917,271 |
52% |
1) General Fund Expenditure Update
When the Fiscal Year 2021-2022 budget was adopted on June 15, 2021, Fiscal Year 2020-2021 was not yet closed; and the beginning General Fund balance was only an estimate of $45 million. The City ended Fiscal Year 2020-2021 with a budget surplus in excess of $59.4 million (Exhibit A) and as stated on Table (3):
Table (3): General Fund Reserve (Fund Balance) Summary
|
Projected |
Actual |
Over/(Under) |
Beginning Fund Balance |
$45.1 M |
$44.6 M |
|
Revenues |
$87.0 M |
$87.4M |
0.4 M |
Expenditures |
$87.0 M |
$72.6M |
($14.4) M |
Ending Fund Balance |
$45.1 M |
$59.4 M |
$14.3 M |
The annual FY 2020-2021 spending is stated in table (4) below.
Table (4): Fiscal Year 2020-2021 Expenditures Summary
Department Name |
Budgeted Expenditures |
Actual |
Over/(Under) Budget |
City Council's Office |
$1,220,841 |
$949,230 |
($271,612) |
City Attorney's Office(1) |
$2,920,000 |
$2,854,441 |
($65,559) |
City Clerk's Office |
$1,022,797 |
$888,226 |
($134,570) |
City Treasurer's Office |
$745,713 |
$640,676 |
($105,037) |
City Manager's Office |
$4,879,236 |
$4,288,494 |
($590,741) |
Public Safety Department |
$25,604,357 |
$25,224,443 |
($379,914 |
Finance Department |
$4,384,082 |
$3,775,921 |
($608,161) |
Human Resources Department |
$2,869,196 |
$2,566,992 |
($302,204) |
Community Development Department |
$6,180,942 |
$3,703,270 |
($2,477,672) |
Community Services Department |
$13,532,689 |
$9,636,790 |
($3,895,899) |
Public Works Department |
$16,731,564 |
$17,208,718 |
$477,154 |
Non-Departmental |
$6,874,984 |
$6,504,712 |
($370,272) |
Total |
$86,966,399 |
$79,241,913 |
($8,724,488) |
(1) The City Attorney’s total expenditures of $2,854,441 are two categories: General Fund ($2,268,726) and Reimbursable Matters ($585,714) -details on Exhibit (B)
The combination of revenue performance and lower expenditures in the General Fund resulted in increased fund balance. The audited fund balance at the beginning of the 2021-2022 fiscal year was a total of $59,399,074.
Fund balance is the City’s “reserve”. It provides a measure of the City’s ability to mitigate future risks associated with providing important services in times of economic uncertainties. To provide funding for emergencies, the City Council has adopted a policy that requires fund balance to be maintained at a minimum level equal to 20% of General Fund’s budget. The City now maintains a very healthy fund balance (“reserve”) at approximately 64% of budgeted expenditures ($41 million or 44% above City Council reserve policy).
Overall, the City of Carson’s spending for the second quarter of Fiscal Year 2021-2022 is 45% (Table 5).
Table (5): Fiscal Year 2021-2022 Year-To-Date Financial Performance
Department Name |
Budget |
Actual |
% Spent |
City Council's Office |
$962,481 |
$527,649 |
55% |
City Attorney's Office(2) |
$3,100,000 |
$1,184,631 |
38% |
City Clerk's Office |
$1,423,926 |
$283,041 |
20% |
City Treasurer's Office |
$770,678 |
$380,738 |
49% |
City Manager's Office |
$5,711,385 |
$2,376,832 |
42% |
Public Safety Department |
$26,235,160 |
$13,304,892 |
51% |
Finance Department |
$4,554,021 |
$1,899,965 |
42% |
Human Resources Department |
$3,329,446 |
$2,095,959 |
63% |
Community Development Department |
$5,695,392 |
$1,582,860 |
28% |
Community Services Department |
$14,954,089 |
$7,030,592 |
47% |
Public Works Department |
$23,182,200 |
$8,742,109 |
38% |
Non-Departmental |
$7,174,984 |
$4,417,005 |
62% |
Total |
$97,093,762 |
$43,826,273 |
45% |
(2)The City Attorney’s total expenditures of $1,184,631 are two categories: General Fund ($1,044,631) and Reimbursable Matters ($140,232) -details on Exhibit (C)
2) Mid-Year Budget Requests
The Public Works Department is requesting the City Council’s approval to reallocate $458,579 within the different department’s operating budget accounts. The Public Works department has had numerous staff vacancies which resulted in many engineering designs and construction projects not occurring and thus the overall PW budget is not being fully spent. The Savings continue to be in the salaries general accounts attributed to vacancies which are available to offset a portion of these projected new $458,579 expenditures. For Fiscal Year 2021-2022, the department is requesting to transfer $458,579 to account for increases in Fleet, Grounds, and Buildings specifically in Sub-Divisions for vehicle maintenance, city-wide landscaping maintenance, park and playground improvements, and building maintenance for the Community Center and City Hall. Also, the department is requesting to transfer funds for mid-year to account for job postings and advertising, computers, phones, smart devices, and software licenses.
3) Fiscal Year 2020-2021 Vacancy Status:
Vacancies are the largest source of budget underspending. Note that vacancies are constantly changing, and certain circumstances could be very different in a matter of days or weeks. The following table summarizes the 41 vacant positions across all departments, which is 13% of total General Fund FTEs (table 6).
Table (6): Vacancy Report by Department
|
|
FY 21-22 Mid-Year |
Department Name |
Budgeted FTEs |
Vacant FTEs |
Vacancy Rate |
Public Works |
130 |
14 |
11% |
Community Services |
67 |
9 |
13% |
Community Development |
23 |
5 |
22% |
Human Resources |
11 |
2 |
18% |
Public Safety |
24 |
3 |
13% |
Finance |
32 |
6 |
19% |
City Manager's Office |
6 |
1 |
17% |
Information Technology |
8 |
|
0% |
City Clerk's Office |
4 |
1 |
25% |
City Treasurer's Office |
4 |
|
0% |
City Council's Office |
5 |
|
0% |
Public Information Office |
4 |
|
0% |
TOTAL |
318 |
41 |
13% |
V. FISCAL IMPACT
The City’s budget provides the funding and expenditure plan for all departments. As such, it serves as the City’s financial plan for the fiscal year. If recommendation no. 2 is approved, $458,579 would be transferred between certain accounts within Public Works department as identified in Exhibit D - Resolution No. 22-021. Finance staff continues to gather and submit all related COVID-19 relief expenditures in order to receive reimbursement through either state or federal emergency COVID-19 funding.
VI. EXHIBITS
1. Exhibit A: FY 20-21 General Fund Balance Reserve. (Page-7)
2. Exhibit B: City Attorney's Office FY 20-21 Expenditures. (Page-8)
3. Exhibit C: City Attorney's Office FY 21-22 Expenditures. (Page-9)
4. Exhibit D: Budget Resolution 22-021. (Page-10)
5. Exhibit E: Public Works Department Mid-Year Budget Reallocation Request. (Page-11)
Prepared by: Tarik Rahmani, Finance Director and Ralston Turner, Sr. Budget Analyst
|