City of Manhattan Beach
Finance Department
Month End Report May 2023
Fiscal Year 2022-2023
% of Year
91.7%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,931,574 $87,103,704 100.2% $87,355,372 $69,801,765 $1,515,922 81.6% Street Lighting & Landscaping Fund 201 390,822 365,701 93.6% 719,511 436,706 5,467 61.5% Gas Tax Fund 205 2,048,850 1,598,234 78.0% 3,763,167 923,063 1,863,927 74.1% Asset Forfeiture 210 41,800 42,438 101.5% 135,497 31,298 27,747 43.6% Police Safety Grants 211 159,000 185,553 116.7% 209,693 87,106 43,310 62.2% Prop A Fund 230 883,003 807,765 91.5% 788,363 596,589 5,307 76.3% Prop C Fund 231 10,681,953 2,607,708 24.4% 11,116,168 1,736,545 970,366 24.4% AB 2766 Fund 232 47,500 42,064 88.6% 673 616 - 91.5% Measure R 233 1,087,088 676,606 62.2% 2,595,986 483,831 689,362 45.2% Measure M 234 11,594,378 692,565 6.0% 12,873,472 241,580 1,104,902 10.5% Measure W 240 3,015,015 470,541 15.6% 2,603,515 248,510 879,603 43.3% Capital Improvements Fund 401 2,698,284 1,532,580 56.8% 13,413,182 3,458,790 2,762,567 46.4% Bond Construction Fund 402 - 285,109 n/a 5,595,390 3,781,218 1,681,557 97.6% Underground Assessment District Construction 403 - 135,544 n/a 1,316,657 118,434 8,389 9.6% Water Fund 501 16,472,500 13,953,172 84.7% 33,538,699 21,017,608 6,597,318 82.3% Stormwater Fund 502 344,484 754,586 219.0% 4,458,062 1,179,418 104,763 28.8% Wastewater Fund 503 3,628,000 3,679,967 101.4% 15,349,147 2,272,986 644,053 19.0% Parking Fund 520 3,983,200 3,978,408 99.9% 3,026,777 2,214,016 252,910 81.5% County Parking Lots Fund 521 1,363,000 973,105 71.4% 953,214 202,536 - 21.2% State Pier & Parking Lot Fund 522 833,500 817,117 98.0% 2,776,820 332,862 2,168,748 90.1% Insurance Reserve Fund 601 7,549,860 9,221,995 122.1% 8,277,783 9,690,601 49,268 117.7% Information Systems Reserve Fund 605 3,698,533 3,391,044 91.7% 4,738,998 2,774,065 490,707 68.9% Fleet Management Fund 610 2,772,827 2,298,985 82.9% 4,970,091 2,338,809 1,897,960 85.2% Building Maintenance & Operation Fund 615 2,195,831 1,678,385 76.4% 2,596,244 1,711,566 355,525 79.6% Special Assessment Debt Service 710 714,150 703,463 98.5% 700,450 665,625 - 95.0% Special Assessment UAD 19-12 19-14 Fund 711 606,106 611,578 100.9% 609,007 503,103 - 82.6% Special Assessment UAD 19-4 Fund 712 337,613 312,954 92.7% 341,813 280,486 - 82.1% City Pension Fund 801 264,480 888 0.3% 196,680 179,719 - 91.4% PARS Investment Trust 804 50,000 68,034 136.1% - - - - $164,393,351 $138,989,793 84.5% $225,020,430 $127,309,451 $24,119,677 56.6% Year-to-Date
As of May 31, 2023
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
91.7%
Fund Original Budget Adjusted Year-to-Date Unrealized % No. Budget Adjustments Budget Actuals Amount Realized
General Fund 100 $86,669,227 $262,347 $86,931,574 $87,103,704 (161,037) 100.2% Street Lighting & Landscaping Fund 201 390,822 - 390,822 365,701 25,121 93.6% Gas Tax Fund 205 1,798,763 250,087 2,048,850 1,598,234 450,615 78.0% Asset Forfeiture 210 41,800 - 41,800 42,438 (638) 101.5% Police Safety Grants 211 159,000 - 159,000 185,553 (26,553) 116.7% Prop A Fund 230 883,003 - 883,003 807,765 75,238 91.5% Prop C Fund 231 712,451 9,969,502 10,681,953 2,607,708 8,074,244 24.4% AB 2766 Fund 232 47,500 - 47,500 42,064 5,436 88.6% Measure R 233 547,088 540,000 1,087,088 676,606 410,482 62.2% Measure M 234 5,921,033 5,673,345 11,594,378 692,565 10,901,813 6.0% Measure W 240 1,611,500 1,403,515 3,015,015 470,541 2,544,474 15.6% Capital Improvements Fund 401 1,605,438 1,092,846 2,698,284 1,532,580 1,165,704 56.8% Bond Construction Fund 402 - - - 285,109 (285,109) 100.0% Underground Assessment District Construction 403 - - - 135,544 (135,544) 100.0% Water Fund 501 16,472,500 - 16,472,500 13,953,172 2,519,328 84.7% Stormwater Fund 502 344,484 - 344,484 754,586 (410,102) 219.0% Wastewater Fund 503 3,628,000 - 3,628,000 3,679,967 (51,967) 101.4% Parking Fund 520 3,983,200 - 3,983,200 3,978,408 4,792 99.9% County Parking Lots Fund 521 1,363,000 - 1,363,000 973,105 389,895 71.4% State Pier & Parking Lot Fund 522 833,500 - 833,500 817,117 16,383 98.0% Insurance Reserve Fund 601 7,549,860 - 7,549,860 9,221,995 (1,672,135) 122.1% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 3,391,044 307,489 91.7% Fleet Management Fund 610 2,772,827 - 2,772,827 2,298,985 473,842 82.9% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 1,678,385 517,446 76.4% Special Assessment Debt Service 710 714,150 - 714,150 703,463 10,687 98.5% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 611,578 (5,472) 100.9% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 312,954 24,659 92.7% City Pension Fund 801 264,480 - 264,480 888 263,592 0.3% PARS Investment Trust 804 50,000 - 50,000 68,034 (18,034) 136.1% $145,201,709 $19,191,642 $164,393,351 $138,989,793 $25,414,651 84.5% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of May 31, 2023
Current Year Activity
% of Year
91.7%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $2,080,221 $87,355,372 $69,801,765 $1,515,922 $16,037,685 81.6% Street Lighting & Landscaping Fund 201 612,022 107,489 719,511 436,706 5,467 277,337 61.5% Gas Tax Fund 205 1,575,138 2,188,029 3,763,167 923,063 1,863,927 976,176 74.1% Asset Forfeiture 210 107,750 27,747 135,497 31,298 27,747 76,452 43.6% Police Safety Grants 211 155,000 54,693 209,693 87,106 43,310 79,277 62.2% Prop A Fund 230 780,646 7,717 788,363 596,589 5,307 186,467 76.3% Prop C Fund 231 1,260,138 9,856,030 11,116,168 1,736,545 970,366 8,409,258 24.4% AB 2766 Fund 232 673 - 673 616 - 57 91.5% Measure R 233 760,138 1,835,848 2,595,986 483,831 689,362 1,422,794 45.2% Measure M 234 5,870,138 7,003,334 12,873,472 241,580 1,104,902 11,526,991 10.5% Measure W 240 1,200,000 1,403,515 2,603,515 248,510 879,603 1,475,402 43.3% Capital Improvements Fund 401 6,442,589 6,970,593 13,413,182 3,458,790 2,762,567 7,191,825 46.4% Bond Construction Fund 402 - 5,595,390 5,595,390 3,781,218 1,681,557 132,615 97.6% Underground Assessment District Construction 403 1,285,750 30,907 1,316,657 118,434 8,389 1,189,834 9.6% Water Fund 501 13,304,706 20,233,993 33,538,699 21,017,608 6,597,318 5,923,772 82.3% Stormwater Fund 502 1,836,564 2,621,498 4,458,062 1,179,418 104,763 3,173,881 28.8% Wastewater Fund 503 4,710,392 10,638,755 15,349,147 2,272,986 644,053 12,432,107 19.0% Parking Fund 520 2,698,608 328,169 3,026,777 2,214,016 252,910 559,852 81.5% County Parking Lots Fund 521 953,214 - 953,214 202,536 - 750,678 21.2% State Pier & Parking Lot Fund 522 737,458 2,039,362 2,776,820 332,862 2,168,748 275,210 90.1% Insurance Reserve Fund 601 8,243,352 34,431 8,277,783 9,690,601 49,268 (1,462,086) 117.7% Information Systems Reserve Fund 605 4,276,387 462,611 4,738,998 2,774,065 490,707 1,474,226 68.9% Fleet Management Fund 610 2,490,440 2,479,651 4,970,091 2,338,809 1,897,960 733,322 85.2% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 1,711,566 355,525 529,153 79.6% Special Assessment Debt Service 710 700,450 - 700,450 665,625 - 34,825 95.0% Special Assessment UAD 19-12 19-14 Fund 711 609,007 - 609,007 503,103 - 105,904 82.6% Special Assessment UAD 19-4 Fund 712 341,813 - 341,813 280,486 - 61,327 82.1% City Pension Fund 801 196,680 - 196,680 179,719 - 16,961 91.4% PARS Investment Trust 804 - - - - - - - $148,620,035 $76,400,395 $225,020,430 $127,309,451 $24,119,677 $73,591,302 67.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 May 31, 2023
Current Year Activity
% of Year
91.7%
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 $3,933,945 $403,699 $194,538 95.7% Finance 12 3,819,223 23,665 3,842,888 3,217,649 53,030 572,209 85.1% Human Resources 13 1,622,969 92,701 1,715,670 1,484,384 68,765 162,521 90.5% Parks and Recreation 14 9,131,405 63,127 9,194,532 7,636,519 82,144 1,475,869 83.9% Police 15 33,631,799 510,231 34,142,030 27,716,883 47,072 6,378,075 81.3% Fire 16 15,286,191 335,530 15,621,721 12,564,250 25,855 3,031,616 80.6% Community Development 17 6,782,954 232,895 7,015,849 5,336,921 185,308 1,493,621 78.7% Public Works 18 10,641,587 648,913 11,290,500 7,911,214 650,049 2,729,237 75.8% Information Technology 19 - - - - - - - $85,275,151 $2,080,221 $87,355,372 $69,801,765 $1,515,922 $16,037,685 81.6% ¹Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year.
April 30, 2023
May 31, 2023
June 30, 2023
City of Manhattan Beach
Fiscal Year 2022-2023 General Fund Expenditures by Department As of May 31, 2023
Current Year Activity
3 4 5 6 7
Percent of Year
91.7%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 29,223,746 31,356,382 31,983,209 35,875,913 36,789,619 39,266,063 38,049,313 103.2% Sales & Use Tax 100 8,222,078 8,493,809 8,243,266 7,210,806 9,457,392 10,134,998 9,260,000 109.4% Franchise Tax (a) 100 1,256,226 1,168,793 1,175,490 1,115,583 1,221,477 1,308,725 1,135,000 115.3% Hotel Tax 100 3,398,166 3,993,943 3,765,739 1,845,902 4,893,669 5,918,550 4,025,000 147.0% Business License Tax 100 3,602,915 3,984,673 3,212,405 2,887,121 4,899,419 4,760,055 3,600,000 132.2% Real Estate Transfer Tax 100 708,590 751,942 797,147 957,017 1,066,884 495,552 810,000 61.2% Building Permits 100 1,896,056 1,783,264 1,521,018 1,354,991 1,756,905 1,522,068 1,532,712 99.3% Parking Citations 100 2,122,518 1,799,840 1,585,726 1,291,462 1,900,581 2,053,834 1,875,000 109.5% Interest Earnings 100 630,339 847,165 1,017,036 759,123 522,368 837,636 637,522 131.4% Marriott Hotel Rent 100 1,080,101 1,727,111 1,542,610 701,995 1,476,632 1,913,967 1,350,000 141.8% Vehicle in Lieu 100 18,680 17,276 28,431 - 40,590 36,360 17,000 213.9% Building Plan Check Fees 100 1,683,771 1,644,583 1,362,522 1,818,641 1,897,275 1,529,224 1,755,000 87.1% Total Major Revenue Accounts 53,843,187 57,568,781 56,234,598 55,818,553 65,922,812 69,777,032 64,046,547 108.9% Over/(Under) Prior Year 3,725,595 (1,334,184) (416,045) 10,104,259 3,854,220 Percent Change From Prior Year 6.9% (2.3%) (0.7%) 18.1% 5.8% Other Revenues 14,656,585 15,995,430 12,824,854 97,010,019 14,720,162 17,326,673 22,885,027 75.7% Total General Fund Revenues 68,499,772 73,564,212 69,059,452 152,828,571 80,642,974 87,103,704 86,931,574 100.2%
(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
May 31, 2023
$0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,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
May 31, 2023
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
91.7%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through May 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
$500,000
$1,000,000
$1,500,000
$2,000,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
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. 23,100 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,064,154 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. 13,039 100-21407 Equipment Deposits 1997 Funded through donations. Used for Various Special Equipment. 23,798 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,260
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. 963 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.
24,648
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.). 503,793 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.
65,396
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. 17,424
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,512
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.
172,530
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 507,967
100-21312 Verizon PEG Deposit 2007 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
330,188
Total $ 4,102,456
Information Technology
Balance Sheet Accounts
As of May 31, 2023
Parks & Recreation
Police
Fire
Community Development