City of Manhattan Beach
Finance Department
Month End Report December 31, 2022
Fiscal Year 2022-2023
% of Year
50.0%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,729,227 $38,617,031 44.5% $86,416,983 $38,458,178 $1,029,150 45.7% Street Lighting & Landscaping Fund 201 390,822 149,532 38.3% 719,511 231,689 2,516 32.6% Gas Tax Fund 205 2,048,850 894,425 43.7% 3,787,603 190,465 1,054,234 32.9% Asset Forfeiture 210 41,800 22,155 53.0% 135,497 26,783 27,747 40.2% Police Safety Grants 211 159,000 162,160 102.0% 209,693 49,000 5,693 26.1% Prop A Fund 230 883,003 417,520 47.3% 788,363 346,106 5,612 44.6% Prop C Fund 231 9,615,953 1,886,454 19.6% 10,090,283 590,187 1,909,546 24.8% AB 2766 Fund 232 47,500 29,361 61.8% 673 336 - 49.9% Measure R 233 1,087,088 388,637 35.8% 2,595,986 51,140 878,568 35.8% Measure M 234 11,594,378 367,217 3.2% 12,873,472 81,184 538,152 4.8% Measure W 240 3,015,015 41,057 1.4% 2,603,515 75,741 1,073,647 44.1% Capital Improvements Fund 401 2,698,284 830,219 30.8% 13,249,864 1,312,381 3,155,107 33.7% Bond Construction Fund 402 - 240,615 n/a 5,595,390 1,838,423 3,566,813 96.6% Underground Assessment District Construction 403 - 114,041 n/a 1,316,657 73,329 8,389 6.2% Water Fund 501 16,472,500 8,545,295 51.9% 33,720,614 12,497,710 10,298,111 67.6% Stormwater Fund 502 344,484 186,780 54.2% 4,505,108 585,615 183,558 17.1% Wastewater Fund 503 3,628,000 2,290,717 63.1% 15,418,797 1,134,656 1,158,998 14.9% Parking Fund 520 3,983,200 2,138,075 53.7% 3,026,777 1,018,374 22,831 34.4% County Parking Lots Fund 521 1,363,000 677,237 49.7% 953,214 91,371 - 9.6% State Pier & Parking Lot Fund 522 833,500 481,439 57.8% 2,776,820 200,168 29,501 8.3% Insurance Reserve Fund 601 7,549,860 3,783,661 50.1% 8,278,953 6,766,197 168,528 83.8% Information Systems Reserve Fund 605 3,698,533 1,849,734 50.0% 4,738,998 1,654,180 514,374 45.8% Fleet Management Fund 610 2,772,827 1,325,215 47.8% 4,707,048 1,294,160 1,716,237 64.0% Building Maintenance & Operation Fund 615 2,195,831 857,804 39.1% 2,596,244 893,644 376,066 48.9% Special Assessment Debt Service 710 714,150 294,399 41.2% 700,450 663,875 - 94.8% Special Assessment UAD 19-12 19-14 Fund 711 606,106 272,425 44.9% 609,007 499,453 - 82.0% Special Assessment UAD 19-4 Fund 712 337,613 135,738 40.2% 341,813 278,506 - 81.5% City Pension Fund 801 264,480 833 0.3% 196,680 102,097 - 51.9% PARS Investment Trust 804 50,000 (27,262) -54.5% - - - - $163,125,004 $66,972,515 41.1% $222,954,013 $71,004,948 $27,723,378 31.8% Year-to-Date
As of December 31, 2022
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
50.0%
Fund Original Budget Adjusted Year-to-Date Unrealized % No. Budget Adjustments Budget Actuals Amount Realized
General Fund 100 $86,669,227 $60,000 $86,729,227 $38,617,031 48,112,196 44.5% Street Lighting & Landscaping Fund 201 390,822 - 390,822 149,532 241,290 38.3% Gas Tax Fund 205 1,798,763 250,087 2,048,850 894,425 1,154,424 43.7% Asset Forfeiture 210 41,800 - 41,800 22,155 19,645 53.0% Police Safety Grants 211 159,000 - 159,000 162,160 (3,160) 102.0% Prop A Fund 230 883,003 - 883,003 417,520 465,483 47.3% Prop C Fund 231 712,451 8,903,502 9,615,953 1,886,454 7,729,498 19.6% AB 2766 Fund 232 47,500 - 47,500 29,361 18,139 61.8% Measure R 233 547,088 540,000 1,087,088 388,637 698,451 35.8% Measure M 234 5,921,033 5,673,345 11,594,378 367,217 11,227,161 3.2% Measure W 240 1,611,500 1,403,515 3,015,015 41,057 2,973,958 1.4% Capital Improvements Fund 401 1,605,438 1,092,846 2,698,284 830,219 1,868,065 30.8% Bond Construction Fund 402 - - - 240,615 (240,615) 100.0% Underground Assessment District Construction 403 - - - 114,041 (114,041) 100.0% Water Fund 501 16,472,500 - 16,472,500 8,545,295 7,927,205 51.9% Stormwater Fund 502 344,484 - 344,484 186,780 157,704 54.2% Wastewater Fund 503 3,628,000 - 3,628,000 2,290,717 1,337,283 63.1% Parking Fund 520 3,983,200 - 3,983,200 2,138,075 1,845,125 53.7% County Parking Lots Fund 521 1,363,000 - 1,363,000 677,237 685,763 49.7% State Pier & Parking Lot Fund 522 833,500 - 833,500 481,439 352,061 57.8% Insurance Reserve Fund 601 7,549,860 - 7,549,860 3,783,661 3,766,199 50.1% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 1,849,734 1,848,799 50.0% Fleet Management Fund 610 2,772,827 - 2,772,827 1,325,215 1,447,612 47.8% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 857,804 1,338,027 39.1% Special Assessment Debt Service 710 714,150 - 714,150 294,399 419,751 41.2% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 272,425 333,681 44.9% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 135,738 201,875 40.2% City Pension Fund 801 264,480 - 264,480 833 263,647 0.3% PARS Investment Trust 804 50,000 - 50,000 (27,262) 77,262 -54.5% $145,201,709 $17,923,295 $163,125,004 $66,972,515 $96,152,489 41.1% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of December 31, 2022
Current Year Activity
% of Year
50.0%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $1,141,832 $86,416,983 $38,458,178 $1,029,150 $46,929,654 45.7% Street Lighting & Landscaping Fund 201 612,022 107,489 719,511 231,689 2,516 485,305 32.6% Gas Tax Fund 205 1,575,138 2,212,465 3,787,603 190,465 1,054,234 2,542,904 32.9% Asset Forfeiture 210 107,750 27,747 135,497 26,783 27,747 80,967 40.2% Police Safety Grants 211 155,000 54,693 209,693 49,000 5,693 155,000 26.1% Prop A Fund 230 780,646 7,717 788,363 346,106 5,612 436,645 44.6% Prop C Fund 231 1,260,138 8,830,145 10,090,283 590,187 1,909,546 7,590,551 24.8% AB 2766 Fund 232 673 - 673 336 - 337 49.9% Measure R 233 760,138 1,835,848 2,595,986 51,140 878,568 1,666,279 35.8% Measure M 234 5,870,138 7,003,334 12,873,472 81,184 538,152 12,254,137 4.8% Measure W 240 1,200,000 1,403,515 2,603,515 75,741 1,073,647 1,454,127 44.1% Capital Improvements Fund 401 6,442,589 6,807,275 13,249,864 1,312,381 3,155,107 8,782,376 33.7% Bond Construction Fund 402 - 5,595,390 5,595,390 1,838,423 3,566,813 190,154 96.6% Underground Assessment District Construction 403 1,285,750 30,907 1,316,657 73,329 8,389 1,234,939 6.2% Water Fund 501 13,304,706 20,415,908 33,720,614 12,497,710 10,298,111 10,924,793 67.6% Stormwater Fund 502 1,836,564 2,668,544 4,505,108 585,615 183,558 3,735,934 17.1% Wastewater Fund 503 4,710,392 10,708,405 15,418,797 1,134,656 1,158,998 13,125,143 14.9% Parking Fund 520 2,698,608 328,169 3,026,777 1,018,374 22,831 1,985,572 34.4% County Parking Lots Fund 521 953,214 - 953,214 91,371 - 861,843 9.6% State Pier & Parking Lot Fund 522 737,458 2,039,362 2,776,820 200,168 29,501 2,547,151 8.3% Insurance Reserve Fund 601 8,243,352 35,601 8,278,953 6,766,197 168,528 1,344,228 83.8% Information Systems Reserve Fund 605 4,276,387 462,611 4,738,998 1,654,180 514,374 2,570,444 45.8% Fleet Management Fund 610 2,490,440 2,216,608 4,707,048 1,294,160 1,716,237 1,696,651 64.0% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 893,644 376,066 1,326,533 48.9% Special Assessment Debt Service 710 700,450 - 700,450 663,875 - 36,575 94.8% Special Assessment UAD 19-12 19-14 Fund 711 609,007 - 609,007 499,453 - 109,554 82.0% Special Assessment UAD 19-4 Fund 712 341,813 - 341,813 278,506 - 63,307 81.5% City Pension Fund 801 196,680 - 196,680 102,097 - 94,583 51.9% PARS Investment Trust 804 - - - - - - - $148,620,035 $74,333,978 $222,954,013 $71,004,948 $27,723,378 $124,225,687 44.3% *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 2022-2023 Citywide Expenditures
As of December 31, 2022
Current Year Activity
% of Year
50.0%
Dept Original Budget Adjusted YTD YTD Available %
No. Budget Adjustments1 Budget Expenditures Encumbrances Budget Used Management Services 11 $4,359,023 $173,158 $4,532,181 $2,100,534 $417,762 $2,013,886 55.6% Finance 12 3,819,223 23,665 3,842,888 1,749,071 187,658 1,906,159 50.4% Human Resources 13 1,622,969 92,701 1,715,670 837,677 72,142 805,851 53.0% Parks and Recreation 14 9,131,405 63,127 9,194,532 4,223,512 110,946 4,860,074 47.1% Police 15 33,631,799 64,509 33,696,308 15,234,630 25,739 18,435,939 45.3% Fire 16 15,286,191 343,210 15,629,401 6,879,743 14,395 8,735,263 44.1% Community Development 17 6,782,954 82,895 6,865,849 3,026,481 75,242 3,764,126 45.2% Public Works 18 10,641,587 298,566 10,940,153 4,406,531 125,266 6,408,356 41.4% Information Technology 19 - - - - - - - $85,275,151 $1,141,832 $86,416,983 $38,458,178 $1,029,150 $46,929,654 45.7% ¹Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year.
April 30, 2023
May 31, 2022
June 30, 2022
City of Manhattan Beach
Fiscal Year 2022-2023 General Fund Expenditures by Department As of December 31, 2022
Current Year Activity
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. 19,212 100-21706 Recreation Sponsorships 2017 Sponsorship revenue/expenses for other programs. 18,750 802-21708 Public Art Development Fees 2003 Funded through a portion of development fees. Used to fund Public Art. 2,196,352 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. 11,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. 12,980 100-21407 Equipment Deposits 1997 Funded through donations. Used for Various Special Equipment. 23,144 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.
45,891
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. 653 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.
17,255
100-21602 Tree Penalties for Illegal Removal 2018 Fines for illegally removed trees for the planting of new trees. $ 77,255 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.). 487,296 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.
62,115
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. 16,327
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.
90,711
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.
127,317
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 558,714
100-21312 Verizon PEG Deposit 2007 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
321,276
Total $ 4,196,829
Information Technology
Balance Sheet Accounts
As of December 31, 2022
Parks & Recreation
Police
Fire
Community Development
3 4 5 6 7
Percent of Year
50.0%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 10,664,807 11,313,358 12,078,002 12,953,416 13,464,650 13,941,865 38,049,313 36.6% Sales & Use Tax 100 4,604,084 4,549,087 4,757,818 3,294,389 5,014,311 5,743,065 9,260,000 62.0% Franchise Tax (a) 100 411,542 326,909 316,483 299,254 289,135 198,376 1,135,000 17.5% Hotel Tax 100 1,987,252 2,226,721 2,533,906 1,073,791 2,535,995 3,599,900 4,025,000 89.4% Business License Tax 100 282,605 413,645 456,267 764,430 1,005,392 596,350 3,600,000 16.6% Real Estate Transfer Tax 100 441,178 456,342 466,293 436,693 767,356 301,369 810,000 37.2% Building Permits 100 949,655 993,537 914,454 716,503 794,962 886,299 1,532,712 57.8% Parking Citations 100 1,187,576 1,071,314 946,899 855,908 1,046,820 1,146,842 1,875,000 61.2% Interest Earnings 100 354,004 418,994 524,634 533,614 316,614 300,304 637,522 47.1% Marriott Hotel Rent 100 731,386 839,753 1,020,659 535,328 670,198 1,044,172 1,350,000 77.3% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 1,051,101 989,532 1,068,218 1,004,689 1,083,939 881,853 1,755,000 50.2% Total Major Revenue Accounts 22,665,189 23,599,191 25,083,634 22,468,016 26,989,373 28,640,396 64,046,547 44.7% Over/(Under) Prior Year 934,002 1,484,444 (2,615,618) 4,521,357 1,651,023 Percent Change From Prior Year 4.1% 6.3% (10.4%) 20.1% 6.1% Other Revenues 7,765,331 9,401,855 7,997,537 6,445,622 7,630,352 9,976,635 22,682,680 44.0% Total General Fund Revenues 30,430,520 33,001,045 33,081,172 28,913,638 34,619,725 38,617,031 86,729,227 44.5%
(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 2022-2023 General Fund Major Revenue Trends Year-To-Date Actuals FY 2023
December 31, 2022
$0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,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
December 31, 2022
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
50.0%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through December Year-Over-Year
$0
$2,500,000
$5,000,000
$7,500,000
$10,000,000
$12,500,000
2018 2019 2020 2021 2022 2023
Sales & Use Tax
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
2018 2019 2020 2021 2022 2023
Franchise Tax
$0
$8,000,000
$16,000,000
$24,000,000
$32,000,000
$40,000,000
2018 2019 2020 2021 2022 2023
Property Taxes
$0
$1,500,000
$3,000,000
$4,500,000
$6,000,000
2018 2019 2020 2021 2022 2023
Hotel Tax
$0
$1,100,000
$2,200,000
$3,300,000
$4,400,000
$5,500,000
2018 2019 2020 2021 2022 2023
Business License Tax
$0
$250,000
$500,000
$750,000
$1,000,000
$1,250,000
$1,500,000
2018 2019 2020 2021 2022 2023
Real Estate Transfer Tax
$0
$550,000
$1,100,000
$1,650,000
$2,200,000
2018 2019 2020 2021 2022 2023
Building Permits
$0
$600,000
$1,200,000
$1,800,000
$2,400,000
2018 2019 2020 2021 2022 2023
Parking Citations
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
2018 2019 2020 2021 2022 2023
Interest Earnings
$0
$600,000
$1,200,000
$1,800,000
2018 2019 2020 2021 2022 2023
Marriott Hotel Rent
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
2018 2019 2020 2021 2022 2023
Building Plan Check Fees