BLUE FOLDER ITEM
Blue folder items are additional back up material to administrative reports and/or public comments received after the printing and distribution of the agenda packet for receive and file.
CITY COUNCIL MEETING
April 18, 2023
N.2. DISCUSSION AND POSSIBLE ACTION REGARDING THE FISCAL YEAR 2022-23 MIDYEAR BUDGET REVIEW
RECEIVE AND FILE THE FY 2022-23 MIDYEAR BUDGET REPORT
ADOPT BY 4/5THS VOTE AND BY TITLE ONLY RESOLUTION NO. CC2304-041, A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
REDONDO BEACH, CALIFORNIA, MODIFYING THE BUDGET FOR
FISCAL YEAR 2022-23
CONTACT: WENDY COLLAZO, FINANCE DIRECTOR
REVISED:
• ADMINISTRATIVE REPORT (Revised)
• ATTACHMENT 1 - FY 2022-23 Summary (Updated)
• EXHIBIT B - Midyear Adjustments to Revenue 22-23 (Updated) • INTERNAL SERVICE FUND (ISF) - Summary by Fund
• INTERNAL SERVICE FUND (ISF) - Summary by Object
N.2., File # 23-5940 Meeting Date: 4/18/2023
Administrative
Report
N.2., File # 23-5940 Meeting Date: 4/18/2023
To: MAYOR AND CITY COUNCIL
From: WENDY COLLAZO, FINANCE DIRECTOR
TITLE
DISCUSSION AND POSSIBLE ACTION REGARDING THE FISCAL YEAR 2022-23 MIDYEAR
BUDGET REVIEW
RECEIVE AND FILE THE FY 2022-23 MIDYEAR BUDGET REPORT
ADOPT BY 4/5THS VOTE AND BY TITLE ONLY RESOLUTION NO. CC-2304-041, A RESOLUTION
OF THE CITY COUNCIL OF THE CITY OF REDONDO BEACH, CALIFORNIA, MODIFYING THE BUDGET FOR FISCAL YEAR 2022-23
EXECUTIVE SUMMARY
In June, the City Council adopted the FY 2022-23 operating budget. The City Council adopted a balanced budget which allocates funding for the provision of core municipal services to the residents, businesses, and visitors of Redondo Beach.
This report reviews the City’s budget and financial condition at the midyear point of FY 2022-23. The report is condensed due to circumstances surrounding the development of the City’s annual Financial Statements and the incorporation of GASB 87. The report provides a broad view of the City’s revenue and expenditure projections and includes no Decision Packages. This is for two reasons; one, the adopted budget included a significant number of programs and projects that are still underway and two, the proposed FY 2023-24 budget is less than a month away and is a better time to consider budget modifications. It should be noted that the mid-year update is positive, as total FY 2022-23 General Fund revenues are expected to exceed total expenditures, after incorporating the Internal Service Fund allocation adjustments, by roughly $2.4M.
BACKGROUND
Where are the revised estimated ending fund balance summaries shown with proposed midyear FY 2022-23 revenues and expenditures?
Attachment 1 provides details of the revised estimated ending fund balances as shown on the Proposed Midyear FY 2022-23 Summary that arise in consideration of adjustments to appropriations, and adjustments to revenue projections if needed.
N.2., File # 23-5940 Meeting Date: 4/18/2023
What was the remaining amount of the General Fund balance at FY 2021-22 year-end after completing the June 30, 2022 Annual Comprehensive Financial Report (ACFR) that becomes the FY 2022-23 beginning fund balance?
The remaining General Fund balance was calculated as follows by excluding fund balance assignments made in March for fiscal year end 2021-22 which are not available to pay for FY 2022- 23 $11,953,989 Total General Fund balance before assignments and transfers (June 30, 2022 ending fund balance)
-8,599,208 Committed fund balance for 8.33% General Fund reserve (contingency reserve required by the City Council’s Financial Principles) -18,605 Nonspendable fund balance for notes and loans (loans to employees for computer purchases pursuant to labor agreements)
-785,832 Fund balance assignment for compensated absences (provision for vacation cash outs upon retirement/termination funded at 30% of employee balances as of June 30, 2022)
-12,800 Fund balance assignment for petty cash (small cash funds held by departments for cash register change drawer or reimbursement of expenses in the amount of $50 or less)
$3,422,710 General Fund remaining fund balance
The remaining General Fund balance can also be calculated as follows by including fund balance assignments (but not transfers) made in March for fiscal year end 2021-22 which are available to pay for FY 2022-23 expenditures.
$253,693 Unassigned/unallocated fund balance (after all other fund balance assignments)
52,821 Nonspendable fund balance (payments made in FY 2021-22 for FY 2022-23 expenditures)
1,270,389 Fund balance assignment for encumbrances (open purchase orders as of June 30, 2022 for contracted goods or services not yet received) 1,845,807 Fund balance assignment for carryovers (unspent FY 2021-22 funds to be used for FY 2022-23 departmental, donation, grant and capital improvement project expenditures)
$3,422,710 General Fund remaining fund balance
N.2., File # 23-5940 Meeting Date: 4/18/2023
The beginning fund balances of the other funds are calculated similarly, with capital assets and net pension and OPEB liabilities excluded from the balances in the Enterprise and Internal Service Funds.
What additional items adjust the beginning fund balances to their estimated ending fund balances?
In addition to the General Fund adopted revenues and transfers-in and the adopted appropriations and transfers-out, the following items adjust the beginning fund balance to the estimated ending fund balance.
$3,422,710 General Fund beginning fund balance for FY 2022-23 101,870,217 Adopted revenues and transfers in FY 2022-23 -110,401,496 Adopted appropriations and transfers out FY 2022-23 -1,270,389 Prior year encumbrances (finalized open purchase orders as of June 30, 2020 for which a fund balance assignment is included in the beginning fund balance - see above)
-1,845,809 Carryover appropriations and transfers out (re-budgeted departmental carryover requests for which a fund balance assignment is included in the beginning fund balance - see above)
-160,000 Other Council-approved appropriations and transfers out (budget modifications approved by City Council resolutions with a 4/5ths affirmative vote during the FY
$146,512 Estimated General Fund ending fund balance for FY 2022-2023 The estimated ending fund balances of the other funds are calculated similarly.
What midyear revenue adjustments to the estimated fund balances are recommended? At this point in the fiscal year, staff has reviewed revenues received to date and revised the adopted revenue estimates as necessary. The revised revenue estimates are shown in Exhibit B with critical General Fund tax revenues anticipated to finish $2.9 million higher than projected at budget adoption.
The largest increase is from property tax which continues to remain strong. Utility Users Tax is also showing solid growth and transient occupancy tax revenue is trending upwards despite the delay in funding from the Marine Ave hotel properties. It should be noted that internal service allocation adjustments reduce overhead revenue accruing to the General Fund by $1,288,538 yielding a net revenue increase in the General Fund of roughly $1.7M.
N.2., File # 23-5940 Meeting Date: 4/18/2023
What midyear adjustments to appropriations are recommended? The proposed adjustments included in the Midyear Adjustments to Appropriations Schedule reflect the annual update to the internal service fund/overhead allocations, which across all funds totals, $801,150, roughly a 3% increase. Additionally, included is an increase of $65,639 for a SBCCOG (South Bay) Grant in the 230 Intergovernmental Grants Fund. It should be noted that the General Fund will experience a reduction of $587,417 in Internal Service Fund Allocation Appropriations, much of which relate to decreased IT equipment expenditures.
Midyear changes to the adopted budget are traditionally considered by the City Council through supplemental budget requests called Decision Packages. Decision Packages typically relate to policy, operational, and other financial matters. As mentioned above, due to the current workload across all City operating departments, and the general proximity to the FY 2023-24 Budget Adoption process which will begin in May, no Decision Packages are recommended at this time.
What is the resulting impact of revising the revenue estimates and funding the recommended Internal Service Fund Allocation and proposed Grants Fund changes at this time? The FY 2022-23 General Fund revised estimated ending fund balance after adjusting for revenue increases and funding the annual Internal Service Fund Allocation changes is as follows:
$146,512 Estimated General Fund ending fund balance for FY 2022-23 1,668,876 Adjustments to Revenue (impact of the revenue revisions as shown in Exhibit B)
(587,417) Adjustments to Appropriations (Exhibit C)
$2,402,805 Estimated General Fund ending fund balance for FY 2022-23 Is there a proposed use for the estimated General Fund Balance for FY 2022-23? There is no recommended use for the expected fund balance at this time, due to the issues described above. The Fund Balance will be included/utilized as part of the proposed FY 2023-24 Budget.
What is the status of preparation of the FY 2023-24 Budget? Following completion of the midyear review, attention will turn immediately towards preparation of the FY 2023-24 Budget that takes effect July 1, 2023. The Budget will be proposed to the City Council for consideration on May 16, 2023. Staff are preparing a public hearing and budget workshop meeting calendar that will be considered for approval by City Council on May 2.
COORDINATION
Each Department analyzed their respective FY 2022-23 revenue and expenditure projections to look for potential revenue shortfalls and/or expenditure overages. The Budget and Finance Commission N.2., File # 23-5940 Meeting Date: 4/18/2023
reviewed the midyear budget report on April 13th. The midyear budget resolution has been approved as to form by the City Attorney’s Office.
FISCAL IMPACT
The report describes the City’s financial and budgetary situation at the midyear point of FY 2022-23.
As mentioned, year-end revenues are expected to exceed year-end expenditures by $2.4M.
APPROVED BY:
Mike Witzansky, City Manager
ATTACHMENTS
• FY 2022-23 Midyear Budget Resolution
• Attachment 1 - FY 2022-23 Summary
• Exhibit A - Council-Approved Appropriation Modifications • Exhibit B - Adjustments to Revenue
• Exhibit C - Adjustments to Appropriations
FY 2022-2023 Midyear Fund Balances
Storm Drain St Landscaping/ Local Transport
Description General 1 State Gas Tax Improvement Lighting Article 3 Measure M Beginning Fund Balance 11,953,989 3,035,204 459,347 - (907) 3,394,608 Adopted Revenues 100,119,290 3,475,852 30,000 1,530,600 62,594 1,173,593 Carry-over Revenues - - - - - -
Other Council-Approved Revenues - - - - - -
Transfers In 1,750,927 147 - 1,382,194 - -
Total Revenue 101,870,217 3,475,999 30,000 2,912,794 62,594 1,173,593 Adopted Appropriations 106,332,914 3,353,390 - 2,912,794 62,595 1,300,342 Prior Year Encumbrances 1,270,389 240,139 287,017 63,272 - 1,044,103 Carryover Appropriations 1,845,809 1,680,591 - - 2,249 2,151,163 Other Council-Approved Appropriations (Exhibit A) 160,000 - - - - - Transfers Out 4,068,582 - - - - -
Total Uses 113,677,694 5,274,120 287,017 2,976,066 64,844 4,495,608 Estimated Ending Fund Balance 146,512 1,237,083 202,330 (63,272) (3,157) 72,593 Adjustments to Revenue (Exhibit B) 1,668,876 - - - - -
Adjustments to Appropriations (Exhibit C) (587,417) (51,063) - (28,313) - (342) Adjustments to Revenue/Transfers In (Decision Pkgs) - - - - - - Adjustments to Appropriations/Transfers Out (Decision Pkgs) - - - - - - Revised Estimated Ending Fund Balance 2,402,805 1,288,146 202,330 (34,959) (3,157) 72,935 1 The General Fund beginning fund balance excludes the 8.33% minimum contingency reserve set by the City Council. 2 Beginning Balance of Intergovernmental Grants is usually negative so it is updated to zero. 3 Because any fund balance (positive or negative) is eliminated with an adjustment to the transfer from the Proposition A Fund, the Transit Fund’s beginning fund balance was shown as zero. 4 Prior year encumbrances will only be reflected after the hard year-end close has been completed.
Prior year encumbrances this year have not occurred due to the delay in the financials (ACFR).
Attachment 1 - Page 1
FY 2022-2023 Midyear Fund Balances
Description
Beginning Fund Balance
Adopted Revenues
Carry-over Revenues
Other Council-Approved Revenues
Transfers In
Total Revenue
Adopted Appropriations
Prior Year Encumbrances
Carryover Appropriations
Other Council-Approved Appropriations (Exhibit A)
Transfers Out
Total Uses
Estimated Ending Fund Balance
Adjustments to Revenue (Exhibit B)
Adjustments to Appropriations (Exhibit C)
Adjustments to Revenue/Transfers In (Decision Pkgs)
Adjustments to Appropriations/Transfers Out (Decision Pkgs) Revised Estimated Ending Fund Balance
Prop A Prop C Air Quality Intergovernmental
Local Trans Tax Local Trans Tax Measure R Measure W Improvement Grants 2 2,376,476 6,289,187 2,052,193 345,713 222,675 -
1,651,996 1,465,403 1,024,052 720,000 90,000 11,690,794 - - - - - 1,531,249
- - - - - 1,564,285
- - - - 45 -
1,651,996 1,465,403 1,024,052 720,000 90,045 14,786,328 - 1,501,605 1,135,000 742,093 72,838 11,690,794
- 2,344,399 152,473 53,534 5,059 6,489,070
75,000 3,946,287 1,715,046 871,527 41,400 18,393,256
- - - - - 2,472,236
993,724 - - - - -
1,068,724 7,792,291 3,002,519 1,667,154 119,297 39,045,356 2,959,748 (37,701) 73,726 (601,441) 193,423 (24,259,028) - - - - - -
- 1,786 2,706 22,369 (3,477) 65,639
- - - - - -
- - - - - -
2,959,748 (39,487) 71,020 (623,810) 196,900 (24,324,667) Attachment 1 - Page 2
FY 2022-2023 Midyear Fund Balances
Description
Beginning Fund Balance
Adopted Revenues
Carry-over Revenues
Other Council-Approved Revenues
Transfers In
Total Revenue
Adopted Appropriations
Prior Year Encumbrances
Carryover Appropriations
Other Council-Approved Appropriations (Exhibit A)
Transfers Out
Total Uses
Estimated Ending Fund Balance
Adjustments to Revenue (Exhibit B)
Adjustments to Appropriations (Exhibit C)
Adjustments to Revenue/Transfers In (Decision Pkgs)
Adjustments to Appropriations/Transfers Out (Decision Pkgs) Revised Estimated Ending Fund Balance
Comm Develop Housing Parks/Rec Narcotic Subdivision Disaster Block Grant Authority Facilities Forfeiture/Seizure Park Trust Recovery - 1,581,064 79,643 269,009 2,075,434 311,703
285,916 6,627,168 31,500 30,000 1,162,500 51,000
- - - - - -
- - - - - -
- 298 - 5,742 - -
285,916 6,627,466 31,500 35,742 1,162,500 51,000
285,916 6,728,170 - 66,872 741,025 17,060
96,759 - - 8,473 311,949 -
119,898 9,496 100,000 102,333 1,708,632 -
- - - - - -
- - - - - -
502,573 6,737,666 100,000 177,678 2,761,606 17,060
(216,657) 1,470,864 11,143 127,073 476,328 345,643
- - - - - -
- - - (8,173) - 7,379
- - - - - -
- - - - - -
(216,657) 1,470,864 11,143 135,246 476,328 338,264
Attachment 1 - Page 3
FY 2022-2023 Midyear Fund Balances
Description
Beginning Fund Balance
Adopted Revenues
Carry-over Revenues
Other Council-Approved Revenues
Transfers In
Total Revenue
Adopted Appropriations
Prior Year Encumbrances
Carryover Appropriations
Other Council-Approved Appropriations (Exhibit A)
Transfers Out
Total Uses
Estimated Ending Fund Balance
Adjustments to Revenue (Exhibit B)
Adjustments to Appropriations (Exhibit C)
Adjustments to Revenue/Transfers In (Decision Pkgs)
Adjustments to Appropriations/Transfers Out (Decision Pkgs) Revised Estimated Ending Fund Balance
CalPERS Major Facilities Open Space Harbor Harbor
Reserve Capital Projects Reconstruction Acquisition Tidelands 5 Uplands 6 7,975,721 13,252,098 653,214 1,302,576 9,399,538 2,155,051 - 491,370 - - 6,547,997 5,840,200
- - - - - -
- - - - - -
- 812,381 500,000 500,000 1,507 935
- 1,303,751 500,000 500,000 6,549,504 5,841,135
- 3,388,640 - 476,000 9,880,333 6,781,235
- 1,724,004 23,750 - 3,981,039 318,444
- 8,393,208 608,750 203,427 6,617,038 692,794
- (740,000) - - 465,000 -
- - - - 100,189 1,650,738
- 12,765,852 632,500 679,427 21,043,599 9,443,211
7,975,721 1,789,997 520,714 1,123,149 (5,094,557) (1,447,025) - - - - - -
- 28,258 - - 200,345 688,453
- - - - - -
- - - - - -
7,975,721 1,761,739 520,714 1,123,149 (5,294,902) (2,135,478) 5 Tidelands- The beginning fund balance includes a reduction per GASB for capital assets, depreciation, and pension and OPEB future liabilities which total $7.8M. These liabilities will not materialize in the period.
When adding them back to the fund balance the net total is $2.5M. 6 Uplands- The beginning fund balance includes a reduction per GASB for capital assets, depreciation, and pension and OPEB future liabilities which total $3.4M. These liabilities will not materialize in the period.
When adding them to the fund balance the net total is $1.2M.
Attachment 1 - Page 4
FY 2022-2023 Midyear Fund Balances
Description
Beginning Fund Balance
Adopted Revenues
Carry-over Revenues
Other Council-Approved Revenues
Transfers In
Total Revenue
Adopted Appropriations
Prior Year Encumbrances
Carryover Appropriations
Other Council-Approved Appropriations (Exhibit A)
Transfers Out
Total Uses
Estimated Ending Fund Balance
Adjustments to Revenue (Exhibit B)
Adjustments to Appropriations (Exhibit C)
Adjustments to Revenue/Transfers In (Decision Pkgs)
Adjustments to Appropriations/Transfers Out (Decision Pkgs) Revised Estimated Ending Fund Balance
Self-Insurance Vehicle Building
Solid Waste Wastewater Transit 3 Program Replacement Occupancy 1,285,404 14,741,773 - (11,109,497) 9,431,896 1,499,500 6,056,272 5,871,641 4,468,111 6,510,854 3,355,361 6,864,757 39,475 - - - - -
- - - - - -
324 437 995,258 - 176 310
6,096,071 5,872,078 5,463,369 6,510,854 3,355,537 6,865,067 6,175,312 8,322,491 5,463,369 7,424,206 4,380,825 3,342,740 22,325 4,680,387 1,134,003 - 1,247,567 693
39,475 6,345,306 - - 210,645 -
61,505 604,489 - - 1,032,000 -
- - - - - -
6,298,617 19,952,673 6,597,372 7,424,206 6,871,037 3,343,433 1,082,858 661,178 (1,134,003) (12,022,849) 5,916,396 5,021,134 - (1,702) - 2,100,839 800,129 573,312
(19,768) 12,189 95,677 15,086 86,466 (78,681)
- - - - - -
- - - - - -
1,102,626 647,287 (1,229,680) (9,937,096) 6,630,059 5,673,127 Attachment 1 - Page 5
FY 2022-2023 Midyear Fund Balances
Description
Beginning Fund Balance
Adopted Revenues
Carry-over Revenues
Other Council-Approved Revenues
Transfers In
Total Revenue
Adopted Appropriations
Prior Year Encumbrances
Carryover Appropriations
Other Council-Approved Appropriations (Exhibit A)
Transfers Out
Total Uses
Estimated Ending Fund Balance
Adjustments to Revenue (Exhibit B)
Adjustments to Appropriations (Exhibit C)
Adjustments to Revenue/Transfers In (Decision Pkgs)
Adjustments to Appropriations/Transfers Out (Decision Pkgs) Revised Estimated Ending Fund Balance
Information Emergency Major Facilities
Technology Communications Repair Total
2,042,798 4,614,766 978,646 92,668,822
4,246,821 4,148,630 107,072 185,731,344
- - - 1,570,724
- - - 1,564,285
24,008 187 - 5,974,876
4,270,829 4,148,817 107,072 194,841,229
3,693,032 2,839,944 - 199,111,535
936,753 61,442 34,191 26,531,235
520,779 117,829 751,668 57,263,606
- - - 4,055,230
- - - 6,813,233
5,150,564 3,019,215 785,859 293,774,838
1,163,063 5,744,368 299,859 (5,663,346)
(559,445) (826,919) 3,474 3,758,564
478,618 (157,837) - 769,900
- - - -
- - - -
125,000 5,075,286 303,333 (2,674,682)
Attachment 1 - Page 6
Fiscal Year 2022 - 2023
Adopted Adjusted Increase Actual Estimated Estimated Variance Variance 2022-2023 2022-2023 (Decrease) 2022-2023 Apr-Jun Year End $ %
GENERAL FUND
Taxes:
Property Tax 32,313,229 32,313,229 - 19,461,889 13,736,274 33,198,162 884,933 3% Property Tax in Lieu of VLF 9,094,480 9,094,480 - 4,607,293 4,326,574 8,933,867 (160,613) -2% Homeowners' Exemption 140,000 140,000 - 67,467 68,123 135,589 (4,411) -3% Sales and Use Tax 11,839,338 11,839,338 - 6,455,197 4,937,492 11,392,689 (446,649) -4% Property Tax Trust 300,000 300,000 - 389 25,264 25,653 (274,347) -91% Public Safety Aug. Fund 926,189 926,189 - 586,765 401,922 988,687 62,498 7% Utility Users' Tax 7,072,150 7,072,150 - 5,982,562 2,657,141 8,639,703 1,567,553 22% Transient Occupancy Tax 5,800,000 5,800,000 - 4,520,258 2,261,564 6,781,822 981,822 17% Franchise Fees 1,775,000 1,775,000 - 1,044,682 1,120,666 2,165,348 390,348 22% Business License Tax 1,271,042 1,271,042 - 1,100,247 226,155 1,326,402 55,360 4% Property Transfer Tax 3,000,000 3,000,000 - 1,459,854 1,441,065 2,900,919 (99,081) -3% Sub-total 73,531,428 73,531,428 - 45,286,603 31,202,240 76,488,843 2,957,415 4% Licenses and Permits:
Construction/Excavation Permits 1,719,900 1,719,900 - - - 1,719,900 - 0% Street/Curb/Parking Permits 68,500 68,500 - - - 68,500 - 0% Misc. Licenses/Permits 479,459 479,459 - - - 479,459 - 0% Sub-total 2,267,859 2,267,859 - - - 2,267,859 - 0%
Fines and Forfeitures:
Parking Citations 1,335,000 1,335,000 - 785,941 419,318 1,335,000 - 0% Vehicle Code Fines 95,000 95,000 - 108,540 24,623 95,000 - 0% Restitution 16,200 16,200 - 48,029 1,505 16,200 - 0%
Sub-total 1,446,200 1,446,200 - 942,511 445,446 1,446,200 - 0% Use of Money and Property:
Investment Earnings 750,000 750,000 - 817,729 377,333 750,000 - 0% Rents and Percentages 1,760,396 1,760,396 - 1,323,899 487,205 1,760,396 - 0% Sub-total 2,510,396 2,510,396 - 2,141,628 864,538 2,510,396 - 0% Intergovernmental:
Motor Vehicle/In-Lieu 30,000 30,000 - 72,000 - 30,000 - 0% SB90 State Mandated Cost Reimb. 30,000 30,000 - - 26,708 30,000 - 0% Other Intergovernmental Revenue 180,000 180,000 - 52,330 - 180,000 - 0% City of Redondo Beach
2022-2023 Midyear Revenue Adjustments
Exhibit B - Page 1
Fiscal Year 2022 - 2023
Adopted Adjusted Increase Actual Estimated Estimated Variance Variance 2022-2023 2022-2023 (Decrease) 2022-2023 Apr-Jun Year End $ % City of Redondo Beach
2022-2023 Midyear Revenue Adjustments
Sub-total 240,000 240,000 - 124,329 26,708 240,000 - 0% Exhibit B - Page 2
Fiscal Year 2022 - 2023
Adopted Adjusted Increase Actual Estimated Estimated Variance Variance 2022-2023 2022-2023 (Decrease) 2022-2023 Apr-Jun Year End $ % City of Redondo Beach
2022-2023 Midyear Revenue Adjustments
Charges for Services:
Administrative Fees 89,100 89,100 - 94,140 34,678 89,100 - 0% Parking Meter Fees 2,500,000 2,500,000 - 2,001,670 783,988 2,500,000 - 0% Police Service Fees 277,000 277,000 - 280,616 183,344 277,000 - 0% Fire Service Fees 663,000 663,000 - 158,141 294,468 663,000 - 0% Library Book Fines and Fees 19,500 19,500 - 16,592 5,686 19,500 - 0% Recreation Users Pay 1,375,050 1,375,050 - 1,472,034 465,490 1,375,050 - 0% Planning Fees 325,000 325,000 - 146,921 56,713 325,000 - 0% Building and Engineering Fees 2,103,320 2,103,320 - 3,081,432 979,473 2,103,320 - 0% State Energy Fees 181,650 181,650 - 430,385 31,346 181,650 - 0% Other Building Fees 164,395 164,395 - 278,113 43,738 164,395 - 0% Public Works Fees 2,000 2,000 - - - 2,000 - 0%
Sub-total 7,700,015 7,700,015 - 7,960,043 2,878,923 7,700,015 - 0% Other Revenues:
Miscellaneous Revenue 2,260,025 2,260,025 - 334,226 1,816,360 2,260,025 - 0% Program Donations 127,141 127,141 - 87,579 28,207 127,141 - 0% Claims Settlement - - - - - - - 0%
Sub-total 2,387,166 2,387,166 - 421,806 1,844,567 2,387,166 - 0% REVENUE FROM OUTSIDE SOURCES 90,083,064 90,083,064 - 56,876,919 37,262,423 93,040,479 2,957,415 3% Internal Revenue:
Overhead Charges 10,036,226 10,036,226 - 6,689,369 2,058,319 8,747,688 (1,288,538) -13% Transfers In - - - - - - - 0%
Sub-total 10,036,226 10,036,226 - 6,689,369 2,058,319 8,747,688 (1,288,538) -13% TOTAL GENERAL FUND 100,119,290 100,119,290 - 63,566,288 39,320,742 101,788,166 1,668,876 2% Exhibit B - Page 3
A B C=B-A D E=C-D
Funds
22-23 Adopted
Budget Amounts
(Based on 21-22
Actuals)
22-23 Midyear
Budget Amounts
(Based on 21-22
Actuals)
Expenditure
Inc/(Dec) Revenue Inc/(Dec) Net Inc/(Dec) to Expenditures Explanation of Increase / Decrease General 25,283,973 24,696,556 (587,417) (1,288,538) 701,121 State Gas Tax 455,882 404,819 (51,063) (51,063)
Street Landscaping and Lighting 278,342 250,029 (28,313) (28,313) Measure M 342 - (342) (342)
Proposition C 1,605 3,391 1,786 1,786
Measure R - 2,706 2,706 2,706
Transit 216,371 312,048 95,677 95,677
Measure W 42,590 64,959 22,369 22,369
Air Quality Improvement 9,076 5,599 (3,477) (3,477)
Narcotic Forfeiture and Seizure 8,173 - (8,173) (8,173) Disaster Recovery - 7,379 7,379 7,379
Capital Projects - 28,258 28,258 28,258
Harbor Tidelands 1,022,542 1,222,887 200,345 200,345
Harbor Uplands 1,272,295 1,960,748 688,453 688,453
Solid Waste 351,246 331,478 (19,768) (19,768)
Wastewater 538,351 550,540 12,189 (1,702) 13,891
Self-Insurance Program 44,626 59,712 15,086 2,100,839 (2,085,753) Vehicle Replacement 260,932 347,398 86,466 800,129 (713,663) Building Occupancy 500,105 421,424 (78,681) 573,312 (651,993) Information Technology 218,348 696,966 478,618 (559,445) 1,038,063 Emergency Communications 540,518 382,681 (157,837) (826,919) 669,082 Major Facilities Repair - - - 3,474 (3,474)
Community Financing Authority 50,326 67,772 17,446 17,446 Housing Authority 156,686 236,129 79,443 79,443
Totals 31,252,329 32,053,479 801,150 801,150 -
CITY OF REDONDO MIDYEAR 2022-23 INTERNAL SERVICE ALLOCATION BY FUND City-Wide Internal Service Fund Analysis By Object
Internal Service Funds
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
% Inc/Dec
Vehicle Maintenance 2,062,256 2,112,806 2% n/a - Expected increase / decrease No change Vehicle Equipment Replacement 1,115,601 1,865,180 67%
Resumption of full allocations following two years
of reduced allocations for City Council-directed
one year vehicle purchase delay
No change
Information Technology Maintenance 3,758,050 3,282,799 -13% Decreased allocated pension-related and internal service fund expenditures No change
Information Technology Equipment Replacement 496,659 412,465 -17% Decreased allocations with removal of telephone
switch from replacement schedule due to FY 22-
23 purchase of hosted system
Beginning with the 22-23 Midyear Budget, 1)
equipment utilized by all departments (e.g.,
network equipment, firewall) is allocated only to
the Information Technology Department and 2)
allocations to the Police, Fire, Community
Services and Public Works Departments are
made only to the Administration Divisions of these
departments. As a FY 22-23 expenditures of
these divisions/department, they will be allocated
to the applicable divisions/departments with
computers and/or telephones in FY 23-24.
Explanation for Increase/Decrease Allocation Methodology Improvements
City-Wide Internal Service Fund Analysis By Object
Internal Service Funds
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
% Inc/Dec Explanation for Increase/Decrease Allocation Methodology Improvements Communications Equipment Replacement 492,422 492,427 0% n/a - Expected increase / decrease Beginning with the 22-23 Midyear Budget,
allocations to the Police, Fire and Public Works
Departments are made only to the Administration
Divisions of these departments.
Workers' Compensation Insurance 2,371,524 2,655,880 12% Increased allocated costs for pension-related expenditures No change
Liability Insurance 4,007,047 5,823,530 45%
Increased allocated costs for liability and property
insurance premiums and claims payable per the
actuarial study of the City's liability self-insurance
program.
No change
Building Occupancy 3,110,802 3,684,114 18% Increased allocated costs primarily for utilities No change
City-Wide Internal Service Fund Analysis By Object
Internal Service Funds
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
% Inc/Dec Explanation for Increase/Decrease Allocation Methodology Improvements Major Facilities Repair 107,071 110,545 3% n/a - Expected increase / decrease No change City Facility Sewer Fee 40,638 38,936 -4% n/a - Expected increase / decrease No change Emergency Communications Operations 3,656,204 2,829,280 -23% Decreased allocated costs for pension-related expenditures No change
Overhead 10,034,055 8,745,517 -13%
1) Increased City Manager hours of support and
expenditures related to non-allocated items such
as agenda preparation and interest expense; and
2) decreased Fire Administration internal service
fund expenditures
No change
City-Wide Internal Service Fund Analysis By Object
Internal Service Funds
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
22-23 Adopted
Budget Amounts
(Based on 21-22
Draft Actuals)
% Inc/Dec Explanation for Increase/Decrease Allocation Methodology Improvements Totals 31,252,329 32,053,479 3%