City of Manhattan Beach
Finance Department
Preliminary Month End Report
June 2023
Fiscal Year 2022-2023
% of Year
100.0%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,931,574 $91,170,841 104.9% $87,349,171 $77,542,259 $1,925,833 91.0% Street Lighting & Landscaping Fund 201 390,822 365,262 93.5% 719,511 537,078 54,967 82.3% Gas Tax Fund 205 2,048,850 1,760,788 85.9% 3,749,335 1,368,586 2,023,805 90.5% Asset Forfeiture 210 41,800 43,382 103.8% 135,497 32,498 27,747 44.5% Police Safety Grants 211 159,000 187,079 117.7% 209,693 156,765 44,419 95.9% Prop A Fund 230 883,003 957,903 108.5% 788,363 665,243 5,307 85.1% Prop C Fund 231 10,681,953 2,737,365 25.6% 10,834,646 1,807,666 2,966,066 44.1% AB 2766 Fund 232 47,500 54,751 115.3% 673 617 - 91.6% Measure R 233 1,927,088 775,773 40.3% 2,595,986 637,149 656,076 49.8% Measure M 234 11,594,378 802,923 6.9% 12,873,472 330,752 2,120,538 19.0% Measure W 240 3,015,015 477,667 15.8% 2,603,515 453,928 689,214 43.9% Capital Improvements Fund 401 2,698,284 1,681,775 62.3% 13,300,530 3,902,130 2,259,235 46.3% Bond Construction Fund 402 - 290,518 n/a 5,595,390 4,278,141 2,151,892 114.9% Underground Assessment District Construction 403 - 142,097 n/a 1,316,657 129,836 8,389 10.5% Water Fund 501 16,472,500 15,590,177 94.6% 33,492,299 24,654,806 4,475,271 87.0% Stormwater Fund 502 344,484 855,112 248.2% 4,458,062 1,263,576 107,732 30.8% Wastewater Fund 503 3,628,000 4,088,279 112.7% 15,045,338 2,482,134 578,403 20.3% Parking Fund 520 3,983,200 4,449,721 111.7% 3,040,277 2,373,775 207,025 84.9% County Parking Lots Fund 521 1,363,000 1,058,319 77.6% 953,214 210,420 - 22.1% State Pier & Parking Lot Fund 522 833,500 907,357 108.9% 2,776,820 403,921 2,168,748 92.6% Insurance Reserve Fund 601 7,549,860 9,227,793 122.2% 8,277,783 10,076,984 48,608 122.3% Information Systems Reserve Fund 605 3,698,533 3,394,145 91.8% 4,738,998 3,071,503 693,113 79.4% Fleet Management Fund 610 2,772,827 2,523,619 91.0% 4,964,155 2,641,972 1,723,669 87.9% Building Maintenance & Operation Fund 615 2,195,831 1,930,306 87.9% 2,596,244 1,959,474 313,676 87.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,353 - 82.7% Special Assessment UAD 19-4 Fund 712 337,613 312,954 92.7% 341,813 280,736 - 82.1% City Pension Fund 801 264,480 833 0.3% 196,680 203,420 - 103.4% PARS Investment Trust 804 50,000 118,726 237.5% - - - - $165,233,351 $147,220,506 89.1% $224,263,578 $142,634,349 $25,249,734 63.6% Year-to-Date
As of June 30, 2023
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
100.0%
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 $91,170,841 (4,228,174) 104.9% Street Lighting & Landscaping Fund 201 390,822 - 390,822 365,262 25,560 93.5% Gas Tax Fund 205 1,798,763 250,087 2,048,850 1,760,788 288,061 85.9% Asset Forfeiture 210 41,800 - 41,800 43,382 (1,582) 103.8% Police Safety Grants 211 159,000 - 159,000 187,079 (28,079) 117.7% Prop A Fund 230 883,003 - 883,003 957,903 (74,900) 108.5% Prop C Fund 231 712,451 9,969,502 10,681,953 2,737,365 7,944,588 25.6% AB 2766 Fund 232 47,500 - 47,500 54,751 (7,251) 115.3% Measure R 233 547,088 1,380,000 1,927,088 775,773 1,151,315 40.3% Measure M 234 5,921,033 5,673,345 11,594,378 802,923 10,791,455 6.9% Measure W 240 1,611,500 1,403,515 3,015,015 477,667 2,537,348 15.8% Capital Improvements Fund 401 1,605,438 1,092,846 2,698,284 1,681,775 1,016,509 62.3% Bond Construction Fund 402 - - - 290,518 (290,518) 100.0% Underground Assessment District Construction 403 - - - 142,097 (142,097) 100.0% Water Fund 501 16,472,500 - 16,472,500 15,590,177 882,323 94.6% Stormwater Fund 502 344,484 - 344,484 855,112 (510,628) 248.2% Wastewater Fund 503 3,628,000 - 3,628,000 4,088,279 (460,279) 112.7% Parking Fund 520 3,983,200 - 3,983,200 4,449,721 (466,521) 111.7% County Parking Lots Fund 521 1,363,000 - 1,363,000 1,058,319 304,681 77.6% State Pier & Parking Lot Fund 522 833,500 - 833,500 907,357 (73,857) 108.9% Insurance Reserve Fund 601 7,549,860 - 7,549,860 9,227,793 (1,677,933) 122.2% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 3,394,145 304,388 91.8% Fleet Management Fund 610 2,772,827 - 2,772,827 2,523,619 249,208 91.0% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 1,930,306 265,525 87.9% 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 833 263,647 0.3% PARS Investment Trust 804 50,000 - 50,000 118,726 (68,726) 237.5% $145,201,709 $20,031,642 $165,233,351 $147,220,506 $18,023,938 89.1% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of June 30, 2023
Current Year Activity
% of Year
100.0%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $2,074,020 $87,349,171 $77,542,259 $1,925,833 $7,881,079 91.0% Street Lighting & Landscaping Fund 201 612,022 107,489 719,511 537,078 54,967 127,465 82.3% Gas Tax Fund 205 1,575,138 2,174,197 3,749,335 1,368,586 2,023,805 356,944 90.5% Asset Forfeiture 210 107,750 27,747 135,497 32,498 27,747 75,252 44.5% Police Safety Grants 211 155,000 54,693 209,693 156,765 44,419 8,509 95.9% Prop A Fund 230 780,646 7,717 788,363 665,243 5,307 117,813 85.1% Prop C Fund 231 1,260,138 9,574,508 10,834,646 1,807,666 2,966,066 6,060,914 44.1% AB 2766 Fund 232 673 - 673 617 - 56 91.6% Measure R 233 760,138 1,835,848 2,595,986 637,149 656,076 1,302,761 49.8% Measure M 234 5,870,138 7,003,334 12,873,472 330,752 2,120,538 10,422,183 19.0% Measure W 240 1,200,000 1,403,515 2,603,515 453,928 689,214 1,460,373 43.9% Capital Improvements Fund 401 6,442,589 6,857,941 13,300,530 3,902,130 2,259,235 7,139,165 46.3% Bond Construction Fund 402 - 5,595,390 5,595,390 4,278,141 2,151,892 (834,643) 114.9% Underground Assessment District Construction 403 1,285,750 30,907 1,316,657 129,836 8,389 1,178,431 10.5% Water Fund 501 13,304,706 20,187,593 33,492,299 24,654,806 4,475,271 4,362,221 87.0% Stormwater Fund 502 1,836,564 2,621,498 4,458,062 1,263,576 107,732 3,086,753 30.8% Wastewater Fund 503 4,710,392 10,334,946 15,045,338 2,482,134 578,403 11,984,800 20.3% Parking Fund 520 2,698,608 341,669 3,040,277 2,373,775 207,025 459,477 84.9% County Parking Lots Fund 521 953,214 - 953,214 210,420 - 742,794 22.1% State Pier & Parking Lot Fund 522 737,458 2,039,362 2,776,820 403,921 2,168,748 204,151 92.6% Insurance Reserve Fund 601 8,243,352 34,431 8,277,783 10,076,984 48,608 (1,847,809) 122.3% Information Systems Reserve Fund 605 4,276,387 462,611 4,738,998 3,071,503 693,113 974,382 79.4% Fleet Management Fund 610 2,490,440 2,473,715 4,964,155 2,641,972 1,723,669 598,515 87.9% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 1,959,474 313,676 323,093 87.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,353 - 105,654 82.7% Special Assessment UAD 19-4 Fund 712 341,813 - 341,813 280,736 - 61,077 82.1% City Pension Fund 801 196,680 - 196,680 203,420 - (6,740) 103.4% PARS Investment Trust 804 - - - - - - - $148,620,035 $75,643,543 $224,263,578 $142,634,349 $25,249,734 $56,379,496 74.9% *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 June 30, 2023
Current Year Activity
% of Year
100.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 $4,418,018 $352,761 ($238,597) 105.3% Finance 12 3,819,223 23,665 3,842,888 3,592,992 90,604 159,292 95.9% Human Resources 13 1,622,969 92,701 1,715,670 1,618,282 61,675 35,713 97.9% Parks and Recreation 14 9,131,405 63,127 9,194,532 8,594,766 130,187 469,580 94.9% Police 15 33,631,799 510,231 34,142,030 30,544,401 124,474 3,473,154 89.8% Fire 16 15,286,191 329,330 15,615,521 13,903,589 16,735 1,695,197 89.1% Community Development 17 6,782,954 232,895 7,015,849 6,070,890 301,676 643,283 90.8% Public Works 18 10,641,587 648,913 11,290,500 8,799,322 847,720 1,643,458 85.4% Information Technology 19 - - - - - - - $85,275,151 $2,074,020 $87,349,171 $77,542,259 $1,925,833 $7,881,079 91.0% ¹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 June 30, 2023
Current Year Activity
3 4 5 6 7
Percent of Year
100.0%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 29,300,348 31,448,387 33,319,571 36,823,265 38,703,862 39,332,579 38,049,313 103.4% Sales & Use Tax 100 8,874,799 9,212,806 8,797,241 8,038,137 10,473,355 10,924,271 9,260,000 118.0% Franchise Tax (a) 100 1,256,226 1,168,793 1,175,490 1,189,086 1,217,755 1,308,725 1,135,000 115.3% Hotel Tax 100 3,766,448 4,372,444 3,852,539 2,382,137 5,585,495 6,552,506 4,025,000 162.8% Business License Tax 100 3,718,418 4,053,020 3,643,611 3,755,555 5,175,626 4,878,679 3,600,000 135.5% Real Estate Transfer Tax 100 791,201 824,402 827,475 1,132,663 1,333,170 627,606 810,000 77.5% Building Permits 100 2,118,129 1,929,097 1,601,914 1,433,778 1,910,538 1,678,521 1,532,712 109.5% Parking Citations 100 2,241,452 1,803,259 1,538,218 1,354,932 2,316,440 2,167,719 1,875,000 115.6% Interest Earnings 100 667,922 842,465 928,038 454,133 559,145 745,920 637,522 117.0% Marriott Hotel Rent 100 1,113,434 1,760,444 1,575,943 898,530 1,346,764 1,947,300 1,350,000 144.2% Vehicle in Lieu 100 18,680 17,276 28,431 - 40,590 36,360 17,000 213.9% Building Plan Check Fees 100 1,807,117 1,775,015 1,418,857 1,986,711 2,111,264 1,703,380 1,755,000 97.1% Total Major Revenue Accounts 55,674,175 59,207,409 58,707,325 59,448,928 70,774,002 71,903,567 64,046,547 112.3% Over/(Under) Prior Year 3,533,234 (500,084) 741,603 11,325,074 1,129,565 Percent Change From Prior Year 6.3% (0.8%) 1.3% 19.1% 1.6% Other Revenues 16,016,874 17,223,328 13,207,006 103,641,135 19,011,307 19,267,275 22,885,027 84.2% Total General Fund Revenues 71,691,049 76,430,737 71,914,331 163,090,063 89,785,308 91,170,841 86,931,574 104.9%
(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
June 30, 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
June 30, 2023
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
100.0%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through June 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
$2,000,000
$4,000,000
$6,000,000
$8,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,053,251 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. 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,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.
27,613
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.). 508,241 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.
66,225
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,669
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.
183,823
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 506,827
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,110,595
Information Technology
Balance Sheet Accounts
As of June 30, 2023
Parks & Recreation
Police
Fire
Community Development