City of Manhattan Beach
Finance Department
Month End Report November 30, 2022
Fiscal Year 2022-2023
% of Year
41.7%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,669,227 $23,370,734 27.0% $86,029,658 $30,510,364 $1,078,647 36.7% Street Lighting & Landscaping Fund 201 390,822 1,821 0.5% 665,796 193,107 5,322 29.8% Gas Tax Fund 205 1,798,763 732,570 40.7% 2,075,257 189,603 1,106,479 62.5% Asset Forfeiture 210 41,800 18,748 44.9% 135,497 9,783 27,747 27.7% Police Safety Grants 211 159,000 131,991 83.0% 209,693 24,500 30,193 26.1% Prop A Fund 230 883,003 415,667 47.1% 788,363 278,599 6,560 36.2% Prop C Fund 231 712,451 566,068 79.5% 3,511,593 453,735 1,522,432 56.3% AB 2766 Fund 232 47,500 17,277 36.4% 673 280 - 41.6% Measure R 233 547,088 390,633 71.4% 1,175,677 42,348 883,198 78.7% Measure M 234 7,121,033 308,680 4.3% 7,461,244 66,439 548,515 8.2% Measure W 240 1,611,500 37,609 2.3% 2,349,197 47,738 1,101,650 48.9% Capital Improvements Fund 401 1,605,438 753,258 46.9% 8,794,476 1,178,556 3,022,727 47.8% Bond Construction Fund 402 - 231,228 n/a 5,405,236 1,683,307 3,721,929 100.0% Underground Assessment District Construction 403 - 109,865 n/a 1,552,206 59,586 244,019 19.6% Water Fund 501 16,472,500 3,792,085 23.0% 28,519,324 11,399,476 10,612,188 77.2% Stormwater Fund 502 344,484 59,656 17.3% 2,139,873 494,981 164,360 30.8% Wastewater Fund 503 3,628,000 1,210,626 33.4% 5,411,858 889,170 1,145,960 37.6% Parking Fund 520 3,983,200 2,052,551 51.5% 2,861,687 870,346 22,831 31.2% County Parking Lots Fund 521 1,363,000 617,024 45.3% 953,214 79,712 - 8.4% State Pier & Parking Lot Fund 522 833,500 423,891 50.9% 795,910 164,096 49,595 26.8% Insurance Reserve Fund 601 7,549,860 3,204,494 42.4% 8,278,953 5,832,736 191,516 72.8% Information Systems Reserve Fund 605 3,698,533 1,541,052 41.7% 4,738,564 1,266,359 605,617 39.5% Fleet Management Fund 610 2,772,827 1,101,053 39.7% 4,593,948 1,162,420 1,734,406 63.1% Building Maintenance & Operation Fund 615 2,195,831 705,169 32.1% 2,596,244 721,547 377,588 42.3% Special Assessment Debt Service 710 714,150 5,355 0.7% 700,450 663,875 - 94.8% Special Assessment UAD 19-12 19-14 Fund 711 606,106 6,313 1.0% 609,007 499,453 - 82.0% Special Assessment UAD 19-4 Fund 712 337,613 3,496 1.0% 341,813 278,506 - 81.5% City Pension Fund 801 264,480 833 0.3% 196,680 79,088 - 40.2% PARS Investment Trust 804 50,000 20,531 41.1% - - - - $146,401,709 $41,830,277 28.6% $182,892,091 $59,139,709 $28,203,478 32.3% Year-to-Date
As of November 30, 2022
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
41.7%
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 $23,370,734 63,298,493 27.0% Street Lighting & Landscaping Fund 201 390,822 - 390,822 1,821 389,001 0.5% Gas Tax Fund 205 1,798,763 - 1,798,763 732,570 1,066,193 40.7% Asset Forfeiture 210 41,800 - 41,800 18,748 23,052 44.9% Police Safety Grants 211 159,000 - 159,000 131,991 27,009 83.0% Prop A Fund 230 883,003 - 883,003 415,667 467,336 47.1% Prop C Fund 231 712,451 - 712,451 566,068 146,383 79.5% AB 2766 Fund 232 47,500 - 47,500 17,277 30,223 36.4% Measure R 233 547,088 - 547,088 390,633 156,455 71.4% Measure M 234 5,921,033 1,200,000 7,121,033 308,680 6,812,353 4.3% Measure W 240 1,611,500 - 1,611,500 37,609 1,573,891 2.3% Capital Improvements Fund 401 1,605,438 - 1,605,438 753,258 852,180 46.9% Bond Construction Fund 402 - - - 231,228 (231,228) 100.0% Underground Assessment District Construction 403 - - - 109,865 (109,865) 100.0% Water Fund 501 16,472,500 - 16,472,500 3,792,085 12,680,415 23.0% Stormwater Fund 502 344,484 - 344,484 59,656 284,828 17.3% Wastewater Fund 503 3,628,000 - 3,628,000 1,210,626 2,417,374 33.4% Parking Fund 520 3,983,200 - 3,983,200 2,052,551 1,930,649 51.5% County Parking Lots Fund 521 1,363,000 - 1,363,000 617,024 745,976 45.3% State Pier & Parking Lot Fund 522 833,500 - 833,500 423,891 409,609 50.9% Insurance Reserve Fund 601 7,549,860 - 7,549,860 3,204,494 4,345,366 42.4% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 1,541,052 2,157,481 41.7% Fleet Management Fund 610 2,772,827 - 2,772,827 1,101,053 1,671,774 39.7% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 705,169 1,490,662 32.1% Special Assessment Debt Service 710 714,150 - 714,150 5,355 708,795 0.7% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 6,313 599,793 1.0% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 3,496 334,117 1.0% City Pension Fund 801 264,480 - 264,480 833 263,647 0.3% PARS Investment Trust 804 50,000 - 50,000 20,531 29,469 41.1% $145,201,709 $1,200,000 $146,401,709 $41,830,277 $104,571,432 28.6% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of November 30, 2022
Current Year Activity
% of Year
41.7%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $754,507 $86,029,658 $30,510,364 $1,078,647 $54,440,648 36.7% Street Lighting & Landscaping Fund 201 612,022 53,774 665,796 193,107 5,322 467,367 29.8% Gas Tax Fund 205 1,575,138 500,119 2,075,257 189,603 1,106,479 779,175 62.5% 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 278,599 6,560 503,204 36.2% Prop C Fund 231 1,260,138 2,251,455 3,511,593 453,735 1,522,432 1,535,426 56.3% AB 2766 Fund 232 673 - 673 280 - 393 41.6% Measure R 233 760,138 415,539 1,175,677 42,348 883,198 250,130 78.7% Measure M 234 5,870,138 1,591,106 7,461,244 66,439 548,515 6,846,290 8.2% 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 1,178,556 3,022,727 4,593,193 47.8% Bond Construction Fund 402 - 5,405,236 5,405,236 1,683,307 3,721,929 - 100.0% Underground Assessment District Construction 403 1,285,750 266,456 1,552,206 59,586 244,019 1,248,601 19.6% Water Fund 501 13,304,706 15,214,618 28,519,324 11,399,476 10,612,188 6,507,660 77.2% Stormwater Fund 502 1,836,564 303,309 2,139,873 494,981 164,360 1,480,532 30.8% Wastewater Fund 503 4,710,392 701,466 5,411,858 889,170 1,145,960 3,376,729 37.6% Parking Fund 520 2,698,608 163,079 2,861,687 870,346 22,831 1,968,511 31.2% County Parking Lots Fund 521 953,214 - 953,214 79,712 - 873,502 8.4% State Pier & Parking Lot Fund 522 737,458 58,452 795,910 164,096 49,595 582,219 26.8% Insurance Reserve Fund 601 8,243,352 35,601 8,278,953 5,832,736 191,516 2,254,701 72.8% Information Systems Reserve Fund 605 4,276,387 462,177 4,738,564 1,266,359 605,617 2,866,588 39.5% Fleet Management Fund 610 2,490,440 2,103,508 4,593,948 1,162,420 1,734,406 1,697,123 63.1% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 721,547 377,588 1,497,108 42.3% 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 79,088 - 117,592 40.2% PARS Investment Trust 804 - - - - - - - $148,620,035 $34,272,056 $182,892,091 $59,139,709 $28,203,478 $95,548,904 47.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 2022-2023 Citywide Expenditures
As of November 30, 2022
Current Year Activity
3 4 5 6 7
Percent of Year
41.7%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 1,108,623 1,180,089 1,293,478 1,369,646 1,295,740 824,597 38,049,313 2.2% Sales & Use Tax 100 3,778,091 3,801,368 4,041,448 3,294,389 4,311,560 4,838,676 9,260,000 52.3% Franchise Tax (a) 100 324,281 326,909 316,483 299,254 289,135 198,376 1,135,000 17.5% Hotel Tax 100 1,750,697 1,906,547 2,192,832 915,719 2,109,006 3,045,913 4,025,000 75.7% Business License Tax 100 253,432 377,112 436,630 691,497 989,699 565,514 3,600,000 15.7% Real Estate Transfer Tax 100 374,591 415,056 466,293 339,188 663,510 246,602 810,000 30.4% Building Permits 100 794,408 722,003 702,786 621,607 639,924 768,695 1,532,712 50.2% Parking Citations 100 1,052,148 934,035 863,258 701,140 891,113 932,091 1,875,000 49.7% Interest Earnings 100 344,380 440,580 555,322 470,235 315,894 2,360,592 637,522 370.3% Marriott Hotel Rent 100 698,053 806,420 987,326 443,005 636,865 569,188 1,350,000 42.2% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 858,867 827,131 732,195 840,706 781,471 668,285 1,755,000 38.1% Total Major Revenue Accounts 11,337,572 11,737,250 12,588,051 9,986,387 12,923,917 15,018,530 64,046,547 23.4% Over/(Under) Prior Year 399,678 850,802 (2,601,664) 2,937,530 2,094,613 Percent Change From Prior Year 3.5% 7.2% (20.7%) 29.4% 16.2% Other Revenues 6,557,028 8,229,100 6,627,225 5,840,017 6,299,404 8,352,204 22,622,680 36.9% Total General Fund Revenues 17,894,599 19,966,350 19,215,276 15,826,404 19,223,320 23,370,734 86,669,227 27.0%
(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
November 30, 2022
$0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,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
November 30, 2022
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
41.7%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through November 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
% of Year
41.7%
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 $1,774,800 $424,762 $2,313,720 48.7% Finance 12 3,819,223 23,665 3,842,888 1,371,838 201,420 2,269,631 40.9% Human Resources 13 1,622,969 92,701 1,715,670 653,597 72,755 989,318 42.3% Parks and Recreation 14 9,131,405 83,084 9,214,489 3,510,383 131,578 5,572,529 39.5% Police 15 33,631,799 4,509 33,636,308 12,067,519 15,839 21,552,950 35.9% Fire 16 15,286,191 14,395 15,300,586 5,358,056 14,395 9,928,135 35.1% Community Development 17 6,782,954 83,329 6,866,283 2,336,186 75,242 4,454,855 35.1% Public Works 18 10,641,587 298,566 10,940,153 3,437,986 142,656 7,359,511 32.7% Information Technology 19 - - - - - - - $85,275,151 $754,507 $86,029,658 $30,510,364 $1,078,647 $54,440,648 36.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 November 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. 18,540 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,214,279 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,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.
16,744
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.). 484,622 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.
61,459
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,136
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.
119,449
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 560,176
100-21312 Verizon PEG Deposit 2007 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
322,758
Total $ 4,197,082
Information Technology
Balance Sheet Accounts
As of November 30, 2022
Parks & Recreation
Police
Fire
Community Development