City of Manhattan Beach
Finance Department
Month End Report October 31, 2022
Fiscal Year 2022-2023
% of Year
33.3%
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,172,313 $512,305 $2,828,664 37.3% Finance 12 3,819,223 23,665 3,842,888 1,053,130 207,914 2,581,845 32.8% Human Resources 13 1,622,969 92,701 1,715,670 550,022 73,195 1,092,454 36.3% Parks and Recreation 14 9,131,405 83,084 9,214,489 2,667,051 132,553 6,414,885 30.4% Police 15 33,631,799 4,509 33,636,308 9,403,784 155,944 24,076,580 28.4% Fire 16 15,286,191 14,395 15,300,586 4,096,432 14,395 11,189,759 26.9% Community Development 17 6,782,954 83,329 6,866,283 1,822,028 75,242 4,969,013 27.6% Public Works 18 10,641,587 298,566 10,940,153 2,641,067 169,523 8,129,563 25.7% Information Technology 19 - - - - - - - $85,275,151 $754,507 $86,029,658 $23,405,825 $1,341,070 $61,282,762 28.8% ¹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 October 31, 2022
Current Year Activity
% of Year
33.3%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,669,227 $18,018,023 20.8% $86,029,658 $23,405,825 $1,341,070 28.8% Street Lighting & Landscaping Fund 201 390,822 1,821 0.5% 665,796 112,402 34,202 22.0% Gas Tax Fund 205 1,798,763 583,182 32.4% 2,075,257 157,937 1,107,882 61.0% Asset Forfeiture 210 41,800 14,819 35.5% 135,497 9,783 27,747 27.7% Police Safety Grants 211 159,000 94,752 59.6% 209,693 24,500 30,193 26.1% Prop A Fund 230 883,003 335,570 38.0% 788,363 222,369 7,337 29.1% Prop C Fund 231 712,451 498,190 69.9% 3,511,593 427,926 1,785,797 63.0% AB 2766 Fund 232 47,500 16,935 35.7% 673 224 - 33.3% Measure R 233 547,088 272,192 49.8% 1,175,677 37,668 883,668 78.4% Measure M 234 7,121,033 249,396 3.5% 7,461,244 48,157 562,725 8.2% Measure W 240 1,611,500 34,273 2.1% 2,349,197 47,738 1,101,650 48.9% Capital Improvements Fund 401 1,605,438 609,467 38.0% 8,794,476 1,140,536 3,047,839 47.6% Bond Construction Fund 402 - 221,557 n/a 5,405,236 1,680,683 3,724,553 100.0% Underground Assessment District Construction 403 - 105,670 n/a 1,552,206 51,754 245,619 19.2% Water Fund 501 16,472,500 3,313,641 20.1% 28,519,324 8,784,000 11,899,232 72.5% Stormwater Fund 502 344,484 53,016 15.4% 2,139,873 369,056 164,360 24.9% Wastewater Fund 503 3,628,000 1,067,911 29.4% 5,411,858 615,488 1,265,845 34.8% Parking Fund 520 3,983,200 1,734,193 43.5% 2,861,687 710,175 22,831 25.6% County Parking Lots Fund 521 1,363,000 544,167 39.9% 953,214 70,086 - 7.4% State Pier & Parking Lot Fund 522 833,500 363,186 43.6% 795,910 126,275 49,595 22.1% Insurance Reserve Fund 601 7,549,860 2,625,327 34.8% 8,278,953 5,688,394 214,174 71.3% Information Systems Reserve Fund 605 3,698,533 1,232,838 33.3% 4,738,564 1,079,162 550,517 34.4% Fleet Management Fund 610 2,772,827 776,656 28.0% 4,593,948 874,979 1,719,355 56.5% Building Maintenance & Operation Fund 615 2,195,831 527,381 24.0% 2,596,244 524,893 391,962 35.3% 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 63,749 - 32.4% PARS Investment Trust 804 50,000 (102,308) -204.6% - - - - $146,401,709 $33,197,759 22.7% $182,892,091 $47,715,591 $30,178,152 26.1% Year-to-Date
As of October 31, 2022
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
33.3%
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 $18,018,023 68,651,204 20.8% 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 583,182 1,215,581 32.4% Asset Forfeiture 210 41,800 - 41,800 14,819 26,981 35.5% Police Safety Grants 211 159,000 - 159,000 94,752 64,248 59.6% Prop A Fund 230 883,003 - 883,003 335,570 547,433 38.0% Prop C Fund 231 712,451 - 712,451 498,190 214,261 69.9% AB 2766 Fund 232 47,500 - 47,500 16,935 30,565 35.7% Measure R 233 547,088 - 547,088 272,192 274,896 49.8% Measure M 234 5,921,033 1,200,000 7,121,033 249,396 6,871,637 3.5% Measure W 240 1,611,500 - 1,611,500 34,273 1,577,227 2.1% Capital Improvements Fund 401 1,605,438 - 1,605,438 609,467 995,971 38.0% Bond Construction Fund 402 - - - 221,557 (221,557) 100.0% Underground Assessment District Construction 403 - - - 105,670 (105,670) 100.0% Water Fund 501 16,472,500 - 16,472,500 3,313,641 13,158,859 20.1% Stormwater Fund 502 344,484 - 344,484 53,016 291,468 15.4% Wastewater Fund 503 3,628,000 - 3,628,000 1,067,911 2,560,089 29.4% Parking Fund 520 3,983,200 - 3,983,200 1,734,193 2,249,007 43.5% County Parking Lots Fund 521 1,363,000 - 1,363,000 544,167 818,833 39.9% State Pier & Parking Lot Fund 522 833,500 - 833,500 363,186 470,314 43.6% Insurance Reserve Fund 601 7,549,860 - 7,549,860 2,625,327 4,924,533 34.8% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 1,232,838 2,465,695 33.3% Fleet Management Fund 610 2,772,827 - 2,772,827 776,656 1,996,171 28.0% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 527,381 1,668,450 24.0% 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 $33,197,759 $113,203,950 22.7% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of October 31, 2022
Current Year Activity
% of Year
33.3%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $754,507 $86,029,658 $23,405,825 $1,341,070 $61,282,762 28.8% Street Lighting & Landscaping Fund 201 612,022 53,774 665,796 112,402 34,202 519,192 22.0% Gas Tax Fund 205 1,575,138 500,119 2,075,257 157,937 1,107,882 809,439 61.0% 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 222,369 7,337 558,657 29.1% Prop C Fund 231 1,260,138 2,251,455 3,511,593 427,926 1,785,797 1,297,870 63.0% AB 2766 Fund 232 673 - 673 224 - 449 33.3% Measure R 233 760,138 415,539 1,175,677 37,668 883,668 254,340 78.4% Measure M 234 5,870,138 1,591,106 7,461,244 48,157 562,725 6,850,363 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,140,536 3,047,839 4,606,101 47.6% Bond Construction Fund 402 - 5,405,236 5,405,236 1,680,683 3,724,553 - 100.0% Underground Assessment District Construction 403 1,285,750 266,456 1,552,206 51,754 245,619 1,254,834 19.2% Water Fund 501 13,304,706 15,214,618 28,519,324 8,784,000 11,899,232 7,836,092 72.5% Stormwater Fund 502 1,836,564 303,309 2,139,873 369,056 164,360 1,606,457 24.9% Wastewater Fund 503 4,710,392 701,466 5,411,858 615,488 1,265,845 3,530,526 34.8% Parking Fund 520 2,698,608 163,079 2,861,687 710,175 22,831 2,128,682 25.6% County Parking Lots Fund 521 953,214 - 953,214 70,086 - 883,128 7.4% State Pier & Parking Lot Fund 522 737,458 58,452 795,910 126,275 49,595 620,040 22.1% Insurance Reserve Fund 601 8,243,352 35,601 8,278,953 5,688,394 214,174 2,376,385 71.3% Information Systems Reserve Fund 605 4,276,387 462,177 4,738,564 1,079,162 550,517 3,108,885 34.4% Fleet Management Fund 610 2,490,440 2,103,508 4,593,948 874,979 1,719,355 1,999,615 56.5% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 524,893 391,962 1,679,390 35.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 63,749 - 132,931 32.4% PARS Investment Trust 804 - - - - - - - $148,620,035 $34,272,056 $182,892,091 $47,715,591 $30,178,152 $104,998,348 42.6% *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 October 31, 2022
Current Year Activity
3 4 5 6 7
Percent of Year
33.3%
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,948,891 3,145,539 3,129,223 2,574,802 3,264,452 3,758,858 9,260,000 40.6% 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,469,012 1,538,810 1,774,893 711,274 1,698,850 2,495,220 4,025,000 62.0% Business License Tax 100 223,753 324,698 396,282 608,993 903,296 519,882 3,600,000 14.4% Real Estate Transfer Tax 100 253,528 335,473 412,419 224,754 564,928 172,356 810,000 21.3% Building Permits 100 658,173 564,972 612,909 536,256 559,167 657,607 1,532,712 42.9% Parking Citations 100 875,245 772,887 680,689 508,999 672,561 863,556 1,875,000 46.1% Interest Earnings 100 366,051 446,992 591,874 479,350 320,513 348,793 637,522 54.7% Marriott Hotel Rent 100 664,719 773,086 953,992 383,402 603,531 535,855 1,350,000 39.7% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 737,499 653,120 651,158 624,437 643,222 554,836 1,755,000 31.6% Total Major Revenue Accounts 9,040,269 9,451,761 10,118,934 7,580,365 10,148,323 10,875,414 64,046,547 17.0% Over/(Under) Prior Year 411,492 667,173 (2,538,568) 2,567,958 727,091 Percent Change From Prior Year 4.6% 7.1% (25.1%) 33.9% 7.2% Other Revenues 5,543,796 5,684,684 5,656,712 4,596,117 5,199,716 7,142,609 22,622,680 31.6% Total General Fund Revenues 14,584,065 15,136,445 15,775,646 12,176,483 15,348,039 18,018,023 86,669,227 20.8%
(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
October 31, 2022
$0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,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
October 31, 2022
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
33.3%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through October 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
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,572 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,211,688 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,748
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.
14,028
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.). 482,155 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.
60,855
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,951
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.
112,505
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 459,677
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,073,229
Information Technology
Balance Sheet Accounts
As of October 31, 2022
Parks & Recreation
Police
Fire
Community Development