Cities Index.
Financial Month End Report October 2023

Manhattan Beach City Council
December 5, 2023

Document
Financial Month End Report October 2023
Meeting
December 5, 2023
Body
Manhattan Beach City Council
Original file
585 KB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

City of Manhattan Beach
Finance Department
Month End Report
October 2023
Fiscal Year 2022-2023

% of Year

33.3%
Dept Original Budget Adjusted YTD YTD Available %
No. Budget Adjustments1 Budget Expenditures Encumbrances Budget Used Management Services 11 $4,772,336 $318,674 $5,091,010 $1,189,927 $311,968 $3,589,115 29.5% Finance 12 4,072,716 64,446 4,137,162 1,298,082 130,119 2,708,961 34.5% Human Resources 13 1,698,442 40,482 1,738,924 471,366 39,413 1,228,145 29.4% Parks and Recreation 14 11,616,474 116,816 11,733,290 3,619,698 956,363 7,157,228 39.0% Police 15 35,878,624 116,296 35,994,920 9,823,948 102,026 26,068,945 27.6% Fire 16 16,595,215 12,918 16,608,133 5,198,385 61,161 11,348,587 31.7% Community Development 17 7,851,987 446,771 8,298,758 2,212,449 500,368 5,585,941 32.7% Public Works 18 10,340,170 774,993 11,115,163 2,993,786 1,174,014 6,947,364 37.5% Information Technology 19 - - - - - - - $92,825,964 $1,891,395 $94,717,359 $26,807,641 $3,275,433 $64,634,286 31.8% ¹Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year.

April 30, 2024
May 31, 2024
June 30, 2024
City of Manhattan Beach
Fiscal Year 2023-2024 General Fund Expenditures by Department As of October 31, 2023
Current Year Activity

% of Year

33.3%
Adjusted Adjusted
Fund Budge t YTD % Budge t %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $93,300,981 $21,175,153 22.7% $94,717,359 $26,807,641 $3,275,433 31.8% Street Lighting & Landscaping Fund 201 390,597 1,478 0.4% 730,365 167,956 23,150 26.2% Gas Tax Fund 205 1,982,355 687,541 34.7% 4,574,162 489,040 1,643,050 46.6% Asset Forfeiture Fund 210 41,800 8,821 21.1% 90,500 11,029 - 12.2% Police Safety Grants Fund 211 164,000 133,206 81.2% 269,421 39,400 - 14.6% Prop A Fund 230 1,403,363 285,950 20.4% 1,171,132 230,787 407,731 54.5% Prop C Fund 231 839,596 509,875 60.7% 3,637,466 2,433,950 422,097 78.5% AB 2766 Fund 232 47,500 11,546 24.3% 275,673 224 - 0.1% Measure R Fund 233 2,482,521 389,787 15.7% 1,556,916 30,389 536,770 36.4% Measure M Fund 234 3,999,190 308,352 7.7% 5,880,763 1,688,840 373,833 35.1% Measure W Fund 240 25,530,264 111,929 0.4% 26,938,812 32,969 629,029 2.5% Capital Improvements Fund 401 2,272,393 985,749 43.4% 11,152,980 1,086,526 1,417,442 22.5% Bond Construction Fund 402 - 242,805 n/a 1,899,593 1,157,323 706,652 98.1% Underground Assessment District Construction 403 - 129,618 n/a 368,389 12,612 8,389 5.7% Water Fund 501 16,201,728 6,387,524 39.4% 20,919,761 4,654,591 3,004,675 36.6% Stormwater Fund 502 393,051 138,604 35.3% 3,260,173 246,292 120,519 11.3% Wastewater Fund 503 3,898,500 2,061,596 52.9% 4,328,228 733,843 528,959 29.2% Parking Fund 520 4,457,200 1,833,986 41.1% 4,442,179 707,374 223,793 21.0% County Parking Lots Fund 521 1,382,200 426,402 30.8% 1,017,984 64,839 24,591 8.8% State Pier & Parking Lot Fund 522 858,500 369,003 43.0% 2,747,336 128,126 2,161,289 83.3% Insurance Reserve Fund 601 8,857,380 3,230,552 36.5% 8,775,042 4,279,575 206,097 51.1% Information Technology Fund 605 4,404,750 1,468,256 33.3% 5,166,879 1,630,175 473,071 40.7% Fleet Management Fund 610 3,204,433 961,718 30.0% 4,995,171 1,079,154 1,534,787 52.3% Building Maintenance & Operation Fund 615 2,560,994 711,402 27.8% 2,841,710 732,476 265,242 35.1% Special Assessment Debt Service 710 714,150 8,961 1.3% 706,475 661,814 - 93.7% Special Assessment UAD 19-12 19-14 Fund 711 606,106 7,054 1.2% 605,807 492,358 - 81.3% Special Assessment UAD 19-4 Fund 712 337,613 3,683 1.1% 337,363 271,974 - 80.6% City Pension Fund 801 264,480 559 0.2% 196,680 65,151 - 33.1% Pension Stabilization Fund 804 50,000 (140,080) -280.2% - - - - $180,645,645 $42,451,032 23.5% $213,604, 320 $49,936,428 $17,986,600 23.4% Year-to-Date
As of October 31, 2023
Fiscal Year 2023-2024 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity

% of Year

33.3%
Fund Original Budge t Adjusted Year-to-Date Unrealized % No. Budge t Adjustments Budge t Actuals Amoun t Realized General Fund 100 $93,300,981 $0 $93,300,981 $21,175,153 72,125,828 22.7% Street Lighting & Landscaping Fund 201 390,597 - 390,597 1,478 389,119 0.4% Gas Tax Fund 205 1,946,355 36,000 1,982,355 687,541 1,294,814 34.7% Asset Forfeiture Fund 210 41,800 - 41,800 8,821 32,979 21.1% Police Safety Grants Fund 211 164,000 - 164,000 133,206 30,794 81.2% Prop A Fund 230 1,036,405 366,958 1,403,363 285,950 1,117,413 20.4% Prop C Fund 231 839,596 - 839,596 509,875 329,721 60.7% AB 2766 Fund 232 47,500 - 47,500 11,546 35,954 24.3% Measure R Fund 233 2,482,521 - 2,482,521 389,787 2,092,734 15.7% Measure M Fund 234 3,999,190 - 3,999,190 308,352 3,690,838 7.7% Measure W Fund 240 25,530,264 - 25,530,264 111,929 25,418,335 0.4% Capital Improvements Fund 401 2,072,438 199,955 2,272,393 985,749 1,286,644 43.4% Bond Construction Fund 402 - - - 242,805 (242,805) 100.0% Underground Assessment District Construction 403 - - - 129,618 (129,618) 100.0% Water Fund 501 16,201,728 - 16,201,728 6,387,524 9,814,204 39.4% Stormwater Fund 502 393,051 - 393,051 138,604 254,447 35.3% Wastewater Fund 503 3,898,500 - 3,898,500 2,061,596 1,836,904 52.9% Parking Fund 520 4,457,200 - 4,457,200 1,833,986 2,623,214 41.1% County Parking Lots Fund 521 1,382,200 - 1,382,200 426,402 955,798 30.8% State Pier & Parking Lot Fund 522 858,500 - 858,500 369,003 489,497 43.0% Insurance Reserve Fund 601 8,857,380 - 8,857,380 3,230,552 5,626,828 36.5% Information Technology Fund 605 4,404,750 - 4,404,750 1,468,256 2,936,494 33.3% Fleet Management Fund 610 3,204,433 - 3,204,433 961,718 2,242,715 30.0% Building Maintenance & Operation Fund 615 2,560,994 - 2,560,994 711,402 1,849,592 27.8% Special Assessment Debt Service 710 714,150 - 714,150 8,961 705,189 1.3% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 7,054 599,052 1.2% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 3,683 333,930 1.1% City Pension Fund 801 264,480 - 264,480 559 263,921 0.2% Pension Stabilization Fund 804 50,000 - 50,000 (140,080) 190,080 -280.2% $180,042,732 $602,913 $180,645,645 $42,451,032 $138,194,612 23.5% City of Manhattan Beach
Fiscal Year 2023-2024 Citywide Revenues
As of October 31, 2023
Current Year Activity

% of Year

33.3%
Fund Original Budge t Adjusted Available %
No. Budge t Adjustments* Budge t Actuals Encumbrances Budge t Utilized General Fund 100 $92,825,964 $1,891,395 $94,717,359 $26,807,641 $3,275,433 $64,634,286 31.8% Street Lighting & Landscaping Fund 201 695,449 34,916 730,365 167,956 23,150 539,259 26.2% Gas Tax Fund 205 2,555,138 2,019,024 4,574,162 489,040 1,643,050 2,442,071 46.6% Asset Forfeiture Fund 210 90,500 - 90,500 11,029 - 79,471 12.2% Police Safety Grants Fund 211 239,000 30,421 269,421 39,400 - 230,021 14.6% Prop A Fund 230 763,401 407,731 1,171,132 230,787 407,731 532,614 54.5% Prop C Fund 231 810,138 2,827,328 3,637,466 2,433,950 422,097 781,419 78.5% AB 2766 Fund 232 275,673 - 275,673 224 - 275,449 0.1% Measure R Fund 233 1,060,138 496,778 1,556,916 30,389 536,770 989,757 36.4% Measure M Fund 234 3,940,138 1,940,625 5,880,763 1,688,840 373,833 3,818,090 35.1% Measure W Fund 240 26,348,763 590,049 26,938,812 32,969 629,029 26,276,814 2.5% Capital Improvements Fund 401 7,896,641 3,256,339 11,152,980 1,086,526 1,417,442 8,649,012 22.5% Bond Construction Fund 402 - 1,899,593 1,899,593 1,157,323 706,652 35,618 98.1% Underground Assessment District Construction 403 360,000 8,389 368,389 12,612 8,389 347,388 5.7% Water Fund 501 17,232,256 3,687,505 20,919,761 4,654,591 3,004,675 13,260,495 36.6% Stormwater Fund 502 3,083,612 176,561 3,260,173 246,292 120,519 2,893,362 11.3% Wastewater Fund 503 3,755,752 572,476 4,328,228 733,843 528,959 3,065,427 29.2% Parking Fund 520 4,143,929 298,250 4,442,179 707,374 223,793 3,511,012 21.0% County Parking Lots Fund 521 1,016,620 1,364 1,017,984 64,839 24,591 928,554 8.8% State Pier & Parking Lot Fund 522 622,046 2,125,290 2,747,336 128,126 2,161,289 457,921 83.3% Insurance Reserve Fund 601 8,737,009 38,033 8,775,042 4,279,575 206,097 4,289,370 51.1% Information Technology Fund 605 4,516,563 650,316 5,166,879 1,630,175 473,071 3,063,633 40.7% Fleet Management Fund 610 3,281,804 1,713,367 4,995,171 1,079,154 1,534,787 2,381,230 52.3% Building Maintenance & Operation Fund 615 2,530,593 311,117 2,841,710 732,476 265,242 1,843,992 35.1% Special Assessment Debt Service 710 706,475 - 706,475 661,814 - 44,661 93.7% Special Assessment UAD 19-12 19-14 Fund 711 605,807 - 605,807 492,358 - 113,449 81.3% Special Assessment UAD 19-4 Fund 712 337,363 - 337,363 271,974 - 65,389 80.6% City Pension Fund 801 196,680 - 196,680 65,151 - 131,529 33.1% Pension Stabilization Fund 804 - - - - - - - $188,627,452 $24,976,868 $213,604,320 $49,936,428 $17,986,600 $145,681,293 31.8% *Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year.

Year-to-Date
City of Manhattan Beach
Fiscal Year 2023-2024 Citywide Expenditures
As of October 31, 2023
Current Year Activity

$3 $4 $5 $6 $7
Percent of Year

33.3%
Fund
Major Revenue Accounts No. 2019 2020 2021 2022 2023 2024 Adj Budget Realized Property Taxes 100 $728,979 $755,718 $776,468 $770,228 $824,597 $896,048 $38,049,313 2.4% Sales & Use Tax 100 3,145,539 3,129,223 2,574,802 3,264,452 3,758,858 3,952,856 9,260,000 42.7% Franchise Tax (a) 100 167,202 159,776 151,631 147,576 143,854 131,838 1,135,000 11.6% Hotel Tax 100 1,538,810 1,774,893 711,274 1,698,850 2,495,220 3,068,459 4,025,000 76.2% Business License Tax 100 324,698 396,282 608,993 903,296 519,882 568,734 3,600,000 15.8% Real Estate Transfer Tax 100 335,473 412,419 224,754 564,928 172,356 162,856 810,000 20.1% Building Permits 100 564,972 612,909 536,256 559,167 657,607 837,879 1,532,712 54.7% Parking Citations 100 772,887 680,689 508,999 672,561 863,450 445,957 1,875,000 23.8% Interest Earnings 100 446,992 591,874 479,350 320,513 348,793 855,017 637,522 134.1% Marriott Hotel Rent 100 773,086 953,992 383,402 603,531 535,855 1,066,580 1,350,000 79.0% Building Plan Check Fees 100 653,120 651,158 624,437 643,222 554,836 641,343 1,755,000 36.5% Total Major Revenue Accounts $9,451,761 $10,118,934 $7,580,365 $10,148,323 $10,875,308 $12,627,566 $64,029,547 19.7% Over/(Under) Prior Year 667,173 (2,538,568) 2,567,958 726,985 1,752,258 Percent Change From Prior Year 7.1% (25.1%) 33.9% 7.2% 16.1% Other Revenues 5,684,684 5,656,712 4,596,117 5,199,716 7,216,058 $8,547,587 29,271,434 29.2% Total General Fund Revenues $15,136,445 $15,775,646 $12,176,483 $15,348,039 $18,091,366 $21,175,153 $93,300,981 22.7%

(a) The structure of payments for the some of the franchise fees has changed resulting in lower initial revenues at the beginning of the fiscal year as compared to prior years. This revenue will self adjust throughout the year to better align with prior full-year numbers.

City of Manhattan Beach
Fiscal Year 2023-2024 General Fund Major Revenue Trends Year-To-Date Actuals FY 2024
October 31, 2023
$0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 Building Plan Check Fees
Marriott Hotel Rent
Interest Earnings
Parking Citations
Building Permits
Real Estate Transfer Tax
Business License Tax
Hotel Tax
Franchise Tax (a)
Sales & Use Tax
Property Taxes
October 31, 2023
Fiscal Year 2023-24
Fiscal Year 2022-23
General Fund Major Revenue Sources

$3 $4 $5 $6 $7
Percent of Year

33.3%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through October Year-Over-Year
$0
$1,000,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
2019 2020 2021 2022 2023 2024
Sales & Use Tax
$0
$100,000
$200,000
$300,000
$400,000
$500,000
2019 2020 2021 2022 2023 2024
Franchise Tax
$0
$400,000
$800,000
$1,200,000
$1,600,000
$2,000,000
2019 2020 2021 2022 2023 2024
Property Taxes
$0
$700,000
$1,400,000
$2,100,000
$2,800,000
$3,500,000
2019 2020 2021 2022 2023 2024
Hotel Tax
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
2019 2020 2021 2022 2023 2024
Business License Tax
$0
$150,000
$300,000
$450,000
$600,000
2019 2020 2021 2022 2023 2024
Real Estate Transfer Tax
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
2019 2020 2021 2022 2023 2024
Building Permits
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
2019 2020 2021 2022 2023 2024
Parking Citations
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
2019 2020 2021 2022 2023 2024
Interest Earnings
$0
$300,000
$600,000
$900,000
$1,200,000
2019 2020 2021 2022 2023 2024
Marriott Hotel Rent
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
2019 2020 2021 2022 2023 2024
Building Plan Check Fees

Account Description Established Purpose Amount
100-21501 Tree and Bench Donations 2003 Donations for trees & benches. $ 6,797 100-21702 Joslyn Foundation Deposits 1997 Joslyn Center Donations. 6,558 100-21705 Pumpkin Race 2013 Sponsorship revenue/expenses for Pumpkin Race. 25,090 100-21706 Recreation Sponsorships 2017 Sponsorship revenue/expenses for other programs. 24,750 802-21708 Public Art Development Fees 2003 Funded through a portion of development fees. Used to fund Public Art. 1,759,477 100-21410 Reserve Force Deposits 1997 Funded through donations. Reserve Officer equipment, training, etc. $ 1,945 100-21405 K9 Deposits 1997 Funded through donations. Used for K9 Equipment. 530 100-21408 Victims Assistance Deposits 1997 Property that is forfeited permanently and goes to auction. The funds are deposited for Victims Assistance programs. 3,423 100-21411 Every 15 Minutes Deposits 1998 Funded through donations. Every 15 Minutes Program. In conjunction with Mira Costa (MBUSD). 4,356 100-21409 Explorer Scout Deposits 1997 Funded through donations. Explorer events, special equipment, etc. 12,585 100-21404 Neighborhood Watch Deposits 1997 Property that is forfeited permanently and goes to auction. The funds are deposited for various Neighborhood Watch uses. 11,225 100-21407 Equipment Deposits 1997 Funded through donations. Used for Various Special Equipment. 24,198 100-21412 Graux Trust (Police) 2014 Donation gift from the Graux Trust. 8,893 100-21402 Inmate Welfare Deposits 1997 Funds generated through inmate telephone in the jail. Use for Inmate welfare, i.e. new mattresses, periodicals, newspapers, books, etc.
46,415
100-21453 Paramedic Trust Deposits 1997 Donations to Fire operations. $ 7,295 100-21451 Graux/Rotary Trust (Fire) 2014 Donation gift from the Graux Trust. 1,756 100-21452 Customer Deposits 2012 Donations from public to fire services. 1,063 100-21913 Fire Technology Replacement 2020 Funded through a fee of 5% of annual Fire Inspection Permits. The purpose of this technology fee is to recover the cost associated with replacement of existing system, upgrades to the existing and new system, and maintenance costs associated with the system.
32,309
100-21602 Tree Penalties for Illegal Removal 2018 Fines for illegally removed trees for the planting of new trees. $ 77,355 100-21601 General Plan Maintenance 2010 Surcharge taken from permits to fund updates for General Plan (i.e., Mobility Plan, Housing Element, Land Use, etc.). 531,645 100-21608 Seismic Fees 1998 A portion of this fee is paid quarterly by the City to the Department of Conservation (DoC) along with a quarterly report.

Balance of fee is used for data utilization, and seismic education incorporating data interpretations from data of the strong- motion instrumentation program.
70,744
100-21609 Congestion Management Plan 2002 Fees that are charged for projects that increase traffic; Planning correction checklist has section for CMP, where a spreadsheet calculates trips/cost; county program on hold for number of years. Funds are to be used for transportation improvements.
68,440
100-21610 BSA Revolving Fund Fee 2009 Fee identified during Building permit application. A portion of this fee is paid quarterly by the City to the CA Building Standards Commission (BSC) along with a quarterly report. Fee paid to BSC based on calculations in the report. 19,180
100-21616 SB 1186 Disability Access & Education 2014 Fee charged on permits, a portion of which is available yearly for Building Inspector training on Title 24, CASp (Certified Access Specialist Program), and SB 1186.
106,888
100-21914 Energov Technology Replacement 2020 Funded through a fee of 3% of Building Permits. The purpose of this technology fee is to recover the cost associated with replacement of existing system, upgrades to the existing and new system, and maintenance costs associated with the system.
80,336
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 520,496
100-21312 Verizon PEG Deposit 2007 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
330,441
Total $ 3,784,192
Information Technology
Balance Sheet Accounts
As of October 31, 2023
Parks & Recreation
Police
Fire
Community Development

← All documents from this meeting