City of Manhattan Beach
Finance Department
Month End Report September 30, 2022
Fiscal Year 2022-2023
% of Year
25.0%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,669,227 $13,920,567 16.1% $86,029,658 $16,727,539 $1,421,179 21.1% Street Lighting & Landscaping Fund 201 390,822 1,767 0.5% 665,796 65,983 40,987 16.1% Gas Tax Fund 205 1,798,763 433,364 24.1% 2,075,257 133,976 574,299 34.1% Asset Forfeiture 210 41,800 14,565 34.8% 135,497 9,783 27,747 27.7% Police Safety Grants 211 159,000 13,225 8.3% 209,693 24,500 30,193 26.1% Prop A Fund 230 883,003 254,381 28.8% 788,363 169,378 7,717 22.5% Prop C Fund 231 712,451 216,378 30.4% 3,511,593 273,410 1,878,095 61.3% AB 2766 Fund 232 47,500 16,606 35.0% 673 168 - 25.0% Measure R 233 547,088 164,983 30.2% 1,175,677 23,872 894,525 78.1% Measure M 234 7,121,033 191,364 2.7% 7,461,244 34,409 381,512 5.6% Measure W 240 1,611,500 31,061 1.9% 2,349,197 47,738 1,101,650 48.9% Capital Improvements Fund 401 1,605,438 466,994 29.1% 8,794,476 795,070 3,352,376 47.2% Bond Construction Fund 402 - 212,149 n/a 5,405,236 1,280,159 4,125,076 100.0% Underground Assessment District Construction 403 - 101,444 n/a 1,552,206 44,914 245,619 18.7% Water Fund 501 16,472,500 3,260,005 19.8% 28,519,324 4,988,195 12,960,740 62.9% Stormwater Fund 502 344,484 48,158 14.0% 2,139,873 268,728 169,611 20.5% Wastewater Fund 503 3,628,000 1,020,981 28.1% 5,411,858 447,542 1,302,547 32.3% Parking Fund 520 3,983,200 1,376,130 34.5% 2,861,687 498,729 22,831 18.2% County Parking Lots Fund 521 1,363,000 450,443 33.0% 953,214 19,725 - 2.1% State Pier & Parking Lot Fund 522 833,500 287,740 34.5% 795,910 82,371 54,452 17.2% Insurance Reserve Fund 601 7,549,860 2,039,166 27.0% 8,278,953 5,501,842 237,327 69.3% Information Systems Reserve Fund 605 3,698,533 924,642 25.0% 4,738,564 757,105 714,104 31.0% Fleet Management Fund 610 2,772,827 581,934 21.0% 4,593,948 789,580 1,742,025 55.1% Building Maintenance & Operation Fund 615 2,195,831 344,488 15.7% 2,596,244 350,847 431,759 30.1% Special Assessment Debt Service 710 714,150 681 0.1% 700,450 663,875 - 94.8% Special Assessment UAD 19-12 19-14 Fund 711 606,106 4,090 0.7% 609,007 499,453 - 82.0% Special Assessment UAD 19-4 Fund 712 337,613 302 0.1% 341,813 278,506 - 81.5% City Pension Fund 801 264,480 833 0.3% 196,680 48,040 - 24.4% PARS Investment Trust 804 50,000 (102,308) -204.6% - - - - $146,401,709 $26,276,133 17.9% $182,892,091 $34,825,438 $31,716,371 19.0% Year-to-Date
As of September 30, 2022
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
25.0%
Fund Original Budget Adjusted Year-to-Date Unrealized % No. Budget Adjustments Budget Actuals Amount Realized
General Fund 100 $86,669,227 $0 $86,669,227 $13,920,567 72,748,660 16.1% Street Lighting & Landscaping Fund 201 390,822 - 390,822 1,767 389,055 0.5% Gas Tax Fund 205 1,798,763 - 1,798,763 433,364 1,365,399 24.1% Asset Forfeiture 210 41,800 - 41,800 14,565 27,235 34.8% Police Safety Grants 211 159,000 - 159,000 13,225 145,775 8.3% Prop A Fund 230 883,003 - 883,003 254,381 628,622 28.8% Prop C Fund 231 712,451 - 712,451 216,378 496,073 30.4% AB 2766 Fund 232 47,500 - 47,500 16,606 30,894 35.0% Measure R 233 547,088 - 547,088 164,983 382,105 30.2% Measure M 234 5,921,033 1,200,000 7,121,033 191,364 6,929,669 2.7% Measure W 240 1,611,500 - 1,611,500 31,061 1,580,439 1.9% Capital Improvements Fund 401 1,605,438 - 1,605,438 466,994 1,138,444 29.1% Bond Construction Fund 402 - - - 212,149 (212,149) 100.0% Underground Assessment District Construction 403 - - - 101,444 (101,444) 100.0% Water Fund 501 16,472,500 - 16,472,500 3,260,005 13,212,495 19.8% Stormwater Fund 502 344,484 - 344,484 48,158 296,326 14.0% Wastewater Fund 503 3,628,000 - 3,628,000 1,020,981 2,607,019 28.1% Parking Fund 520 3,983,200 - 3,983,200 1,376,130 2,607,070 34.5% County Parking Lots Fund 521 1,363,000 - 1,363,000 450,443 912,557 33.0% State Pier & Parking Lot Fund 522 833,500 - 833,500 287,740 545,760 34.5% Insurance Reserve Fund 601 7,549,860 - 7,549,860 2,039,166 5,510,694 27.0% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 924,642 2,773,891 25.0% Fleet Management Fund 610 2,772,827 - 2,772,827 581,934 2,190,893 21.0% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 344,488 1,851,343 15.7% Special Assessment Debt Service 710 714,150 - 714,150 681 713,469 0.1% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 4,090 602,016 0.7% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 302 337,311 0.1% City Pension Fund 801 264,480 - 264,480 833 263,647 0.3% PARS Investment Trust 804 50,000 - 50,000 (102,308) 152,308 -204.6% $145,201,709 $1,200,000 $146,401,709 $26,276,133 $120,125,576 17.9% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of September 30, 2022
Current Year Activity
% of Year
25.0%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $754,507 $86,029,658 $16,727,539 $1,421,179 $67,880,940 21.1% Street Lighting & Landscaping Fund 201 612,022 53,774 665,796 65,983 40,987 558,826 16.1% Gas Tax Fund 205 1,575,138 500,119 2,075,257 133,976 574,299 1,366,982 34.1% Asset Forfeiture 210 107,750 27,747 135,497 9,783 27,747 97,967 27.7% Police Safety Grants 211 155,000 54,693 209,693 24,500 30,193 155,000 26.1% Prop A Fund 230 780,646 7,717 788,363 169,378 7,717 611,268 22.5% Prop C Fund 231 1,260,138 2,251,455 3,511,593 273,410 1,878,095 1,360,089 61.3% AB 2766 Fund 232 673 - 673 168 - 505 25.0% Measure R 233 760,138 415,539 1,175,677 23,872 894,525 257,280 78.1% Measure M 234 5,870,138 1,591,106 7,461,244 34,409 381,512 7,045,323 5.6% Measure W 240 1,200,000 1,149,197 2,349,197 47,738 1,101,650 1,199,808 48.9% Capital Improvements Fund 401 6,442,589 2,351,887 8,794,476 795,070 3,352,376 4,647,029 47.2% Bond Construction Fund 402 - 5,405,236 5,405,236 1,280,159 4,125,076 - 100.0% Underground Assessment District Construction 403 1,285,750 266,456 1,552,206 44,914 245,619 1,261,674 18.7% Water Fund 501 13,304,706 15,214,618 28,519,324 4,988,195 12,960,740 10,570,389 62.9% Stormwater Fund 502 1,836,564 303,309 2,139,873 268,728 169,611 1,701,535 20.5% Wastewater Fund 503 4,710,392 701,466 5,411,858 447,542 1,302,547 3,661,770 32.3% Parking Fund 520 2,698,608 163,079 2,861,687 498,729 22,831 2,340,128 18.2% County Parking Lots Fund 521 953,214 - 953,214 19,725 - 933,489 2.1% State Pier & Parking Lot Fund 522 737,458 58,452 795,910 82,371 54,452 659,087 17.2% Insurance Reserve Fund 601 8,243,352 35,601 8,278,953 5,501,842 237,327 2,539,784 69.3% Information Systems Reserve Fund 605 4,276,387 462,177 4,738,564 757,105 714,104 3,267,354 31.0% Fleet Management Fund 610 2,490,440 2,103,508 4,593,948 789,580 1,742,025 2,062,343 55.1% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 350,847 431,759 1,813,638 30.1% 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 48,040 - 148,640 24.4% PARS Investment Trust 804 - - - - - - - $148,620,035 $34,272,056 $182,892,091 $34,825,438 $31,716,371 $116,350,283 36.4% *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 September 30, 2022
Current Year Activity
3 4 5 6 7
Percent of Year
25.0%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 682,006 728,979 755,718 776,468 770,228 824,597 38,049,313 2.2% Sales & Use Tax 100 2,326,891 2,287,552 2,317,466 1,945,493 2,376,253 2,864,287 9,260,000 30.9% Franchise Tax (a) 100 161,392 167,202 159,776 151,631 147,576 143,854 1,135,000 12.7% Hotel Tax 100 1,166,198 1,202,279 1,391,156 501,037 1,308,753 1,889,107 4,025,000 46.9% Business License Tax 100 182,984 272,090 319,075 557,680 801,942 432,420 3,600,000 12.0% Real Estate Transfer Tax 100 181,549 183,454 377,688 128,916 336,863 109,875 810,000 13.6% Building Permits 100 469,340 406,031 466,690 378,485 462,326 507,980 1,532,712 33.1% Parking Citations 100 693,066 563,197 526,435 386,735 532,862 524,577 1,875,000 28.0% Interest Earnings 100 230,151 334,805 388,176 370,608 245,811 199,650 637,522 31.3% Marriott Hotel Rent 100 428,278 385,837 490,134 100,000 263,202 502,522 1,350,000 37.2% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 601,459 457,552 512,390 481,107 458,479 446,677 1,755,000 25.5% Total Major Revenue Accounts 7,123,314 6,988,978 7,704,704 5,778,161 7,704,294 8,445,545 64,046,547 13.2% Over/(Under) Prior Year (134,337) 715,726 (1,926,543) 1,926,133 741,251 Percent Change From Prior Year (1.9%) 10.2% (25.0%) 33.3% 9.6% Other Revenues 4,568,653 4,750,134 4,397,387 3,360,990 3,998,534 5,475,022 22,622,680 24.2% Total General Fund Revenues 11,691,968 11,739,112 12,102,091 9,139,151 11,702,828 13,920,567 86,669,227 16.1%
(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
September 30, 2022
$0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,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
September 30, 2022
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
25.0%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through September 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
$250,000
$500,000
$750,000
$1,000,000
$1,250,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
% of Year
25.0%
Dept Original Budget Adjusted YTD YTD Available %
No. Budget Adjustments1 Budget Expenditures Encumbrances Budget Used Management Services 11 $4,359,023 $154,258 $4,513,281 $800,429 $542,305 $3,170,548 29.8% Finance 12 3,819,223 23,665 3,842,888 730,741 242,312 2,869,835 25.3% Human Resources 13 1,622,969 92,701 1,715,670 350,888 73,195 1,291,587 24.7% Parks and Recreation 14 9,131,405 83,084 9,214,489 2,026,229 110,938 7,077,322 23.2% Police 15 33,631,799 4,509 33,636,308 6,872,082 150,754 26,613,471 20.9% Fire 16 15,286,191 14,395 15,300,586 2,960,968 14,395 12,325,224 19.4% Community Development 17 6,782,954 83,329 6,866,283 1,302,734 81,391 5,482,158 20.2% Public Works 18 10,641,587 298,566 10,940,153 1,683,468 205,890 9,050,795 17.3% Information Technology 19 - - - - - - - $85,275,151 $754,507 $86,029,658 $16,727,539 $1,421,179 $67,880,940 21.1% ¹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 September 30, 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. 13,498 100-21706 Recreation Sponsorships 2017 Sponsorship revenue/expenses for other programs. 15,000 802-21708 Public Art Development Fees 2003 Funded through a portion of development fees. Used to fund Public Art. 2,202,539 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. 10,915 100-21404 Neighborhood Watch Deposits 1997 Property that is forfeited permanently and goes to auction. The funds are deposited for various Neighborhood Watch uses. 9,371 100-21407 Equipment Deposits 1997 Funded through donations. Used for Various Special Equipment. 23,128 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,675
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. 628 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.
11,120
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.). 478,142 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.
59,728
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. 15,642
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,841
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.
100,324
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 442,357
100-21312 Verizon PEG Deposit 2007 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
319,890
Total $ 4,026,050
Information Technology
Balance Sheet Accounts
As of September 30, 2022
Parks & Recreation
Police
Fire
Community Development