Cities Index.
Month End Financial Report March 2023

Manhattan Beach City Council
May 16, 2023

Document
Month End Financial Report March 2023
Meeting
May 16, 2023
Body
Manhattan Beach City Council
Original file
785 KB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

City of Manhattan Beach
Finance Department
Month End Report March 2023
Fiscal Year 2022-2023

% of Year

75.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 $3,236,368 $390,111 $905,702 80.0% Finance 12 3,819,223 23,665 3,842,888 2,599,089 86,847 1,156,952 69.9% Human Resources 13 1,622,969 92,701 1,715,670 1,235,464 69,290 410,916 76.0% Parks and Recreation 14 9,131,405 63,127 9,194,532 6,545,424 83,224 2,565,884 72.1% Police 15 33,631,799 510,231 34,142,030 22,581,169 61,664 11,499,197 66.3% Fire 16 15,286,191 335,530 15,621,721 10,341,866 22,935 5,256,920 66.3% Community Development 17 6,782,954 232,895 7,015,849 4,385,144 193,477 2,437,227 65.3% Public Works 18 10,641,587 648,913 11,290,500 6,461,459 576,394 4,252,647 62.3% Information Technology 19 - - - - - - - $85,275,151 $2,080,220 $87,355,371 $57,385,982 $1,483,942 $28,485,446 67.4% ¹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 March 31, 2023
Current Year Activity

% of Year

75.0%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,931,574 $59,536,167 68.5% $87,355,372 $57,385,982 $1,483,942 67.4% Street Lighting & Landscaping Fund 201 390,822 229,643 58.8% 719,511 347,918 5,467 49.1% Gas Tax Fund 205 2,048,850 1,334,274 65.1% 3,763,167 321,561 1,848,191 57.7% Asset Forfeiture 210 41,800 41,806 100.0% 135,497 31,298 27,747 43.6% Police Safety Grants 211 159,000 183,528 115.4% 209,693 87,106 22,651 52.3% Prop A Fund 230 883,003 737,369 83.5% 788,363 497,234 5,307 63.7% Prop C Fund 231 10,681,953 2,387,296 22.3% 11,116,168 1,235,037 1,522,961 24.8% AB 2766 Fund 232 47,500 41,177 86.7% 673 504 - 74.9% Measure R 233 1,087,088 549,729 50.6% 2,595,986 77,469 868,289 36.4% Measure M 234 11,594,378 576,133 5.0% 12,873,472 186,178 430,136 4.8% Measure W 240 3,015,015 461,422 15.3% 2,603,515 90,683 1,073,647 44.7% Capital Improvements Fund 401 2,698,284 1,264,960 46.9% 13,413,182 3,137,120 2,788,483 44.2% Bond Construction Fund 402 - 266,010 n/a 5,595,390 2,852,217 2,610,278 97.6% Underground Assessment District Construction 403 - 125,524 n/a 1,316,657 93,925 8,389 7.8% Water Fund 501 16,472,500 11,661,228 70.8% 33,538,699 16,741,268 9,609,101 78.6% Stormwater Fund 502 344,484 263,493 76.5% 4,458,062 939,079 126,844 23.9% Wastewater Fund 503 3,628,000 3,065,786 84.5% 15,349,147 1,791,479 1,011,059 18.3% Parking Fund 520 3,983,200 3,176,102 79.7% 3,026,777 1,968,109 267,831 73.9% County Parking Lots Fund 521 1,363,000 838,070 61.5% 953,214 152,380 - 16.0% State Pier & Parking Lot Fund 522 833,500 667,538 80.1% 2,776,820 292,232 1,991,758 82.3% Insurance Reserve Fund 601 7,549,860 8,063,673 106.8% 8,277,783 8,431,162 96,479 103.0% Information Systems Reserve Fund 605 3,698,533 2,774,616 75.0% 4,738,998 2,275,960 475,599 58.1% Fleet Management Fund 610 2,772,827 1,948,157 70.3% 4,970,091 2,066,150 1,709,311 76.0% Building Maintenance & Operation Fund 615 2,195,831 1,305,253 59.4% 2,596,244 1,369,466 446,155 69.9% Special Assessment Debt Service 710 714,150 434,502 60.8% 700,450 663,875 - 94.8% Special Assessment UAD 19-12 19-14 Fund 711 606,106 378,240 62.4% 609,007 503,103 - 82.6% Special Assessment UAD 19-4 Fund 712 337,613 188,239 55.8% 341,813 278,506 - 81.5% City Pension Fund 801 264,480 888 0.3% 196,680 148,579 - 75.5% PARS Investment Trust 804 50,000 72,692 145.4% - - - - $164,393,351 $102,573,515 62.4% $225,020,430 $103,965,580 $28,429,627 46.2% Year-to-Date
As of March 31, 2023
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity

% of Year

75.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 $59,536,167 27,395,407 68.5% Street Lighting & Landscaping Fund 201 390,822 - 390,822 229,643 161,179 58.8% Gas Tax Fund 205 1,798,763 250,087 2,048,850 1,334,274 714,576 65.1% Asset Forfeiture 210 41,800 - 41,800 41,806 (6) 100.0% Police Safety Grants 211 159,000 - 159,000 183,528 (24,528) 115.4% Prop A Fund 230 883,003 - 883,003 737,369 145,634 83.5% Prop C Fund 231 712,451 9,969,502 10,681,953 2,387,296 8,294,657 22.3% AB 2766 Fund 232 47,500 - 47,500 41,177 6,323 86.7% Measure R 233 547,088 540,000 1,087,088 549,729 537,359 50.6% Measure M 234 5,921,033 5,673,345 11,594,378 576,133 11,018,245 5.0% Measure W 240 1,611,500 1,403,515 3,015,015 461,422 2,553,593 15.3% Capital Improvements Fund 401 1,605,438 1,092,846 2,698,284 1,264,960 1,433,324 46.9% Bond Construction Fund 402 - - - 266,010 (266,010) 100.0% Underground Assessment District Construction 403 - - - 125,524 (125,524) 100.0% Water Fund 501 16,472,500 - 16,472,500 11,661,228 4,811,272 70.8% Stormwater Fund 502 344,484 - 344,484 263,493 80,991 76.5% Wastewater Fund 503 3,628,000 - 3,628,000 3,065,786 562,214 84.5% Parking Fund 520 3,983,200 - 3,983,200 3,176,102 807,098 79.7% County Parking Lots Fund 521 1,363,000 - 1,363,000 838,070 524,930 61.5% State Pier & Parking Lot Fund 522 833,500 - 833,500 667,538 165,962 80.1% Insurance Reserve Fund 601 7,549,860 - 7,549,860 8,063,673 (513,813) 106.8% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 2,774,616 923,917 75.0% Fleet Management Fund 610 2,772,827 - 2,772,827 1,948,157 824,670 70.3% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 1,305,253 890,578 59.4% Special Assessment Debt Service 710 714,150 - 714,150 434,502 279,648 60.8% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 378,240 227,866 62.4% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 188,239 149,374 55.8% City Pension Fund 801 264,480 - 264,480 888 263,592 0.3% PARS Investment Trust 804 50,000 - 50,000 72,692 (22,692) 145.4% $145,201,709 $19,191,642 $164,393,351 $102,573,515 $61,819,836 62.4% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of March 31, 2023
Current Year Activity

% of Year

75.0%
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 $57,385,982 $1,483,942 $28,485,447 67.4% Street Lighting & Landscaping Fund 201 612,022 107,489 719,511 347,918 5,467 366,125 49.1% Gas Tax Fund 205 1,575,138 2,188,029 3,763,167 321,561 1,848,191 1,593,415 57.7% 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 22,651 99,936 52.3% Prop A Fund 230 780,646 7,717 788,363 497,234 5,307 285,822 63.7% Prop C Fund 231 1,260,138 9,856,030 11,116,168 1,235,037 1,522,961 8,358,170 24.8% AB 2766 Fund 232 673 - 673 504 - 169 74.9% Measure R 233 760,138 1,835,848 2,595,986 77,469 868,289 1,650,229 36.4% Measure M 234 5,870,138 7,003,334 12,873,472 186,178 430,136 12,257,158 4.8% Measure W 240 1,200,000 1,403,515 2,603,515 90,683 1,073,647 1,439,185 44.7% Capital Improvements Fund 401 6,442,589 6,970,593 13,413,182 3,137,120 2,788,483 7,487,580 44.2% Bond Construction Fund 402 - 5,595,390 5,595,390 2,852,217 2,610,278 132,895 97.6% Underground Assessment District Construction 403 1,285,750 30,907 1,316,657 93,925 8,389 1,214,343 7.8% Water Fund 501 13,304,706 20,233,993 33,538,699 16,741,268 9,609,101 7,188,330 78.6% Stormwater Fund 502 1,836,564 2,621,498 4,458,062 939,079 126,844 3,392,139 23.9% Wastewater Fund 503 4,710,392 10,638,755 15,349,147 1,791,479 1,011,059 12,546,608 18.3% Parking Fund 520 2,698,608 328,169 3,026,777 1,968,109 267,831 790,838 73.9% County Parking Lots Fund 521 953,214 - 953,214 152,380 - 800,834 16.0% State Pier & Parking Lot Fund 522 737,458 2,039,362 2,776,820 292,232 1,991,758 492,830 82.3% Insurance Reserve Fund 601 8,243,352 34,431 8,277,783 8,431,162 96,479 (249,858) 103.0% Information Systems Reserve Fund 605 4,276,387 462,611 4,738,998 2,275,960 475,599 1,987,439 58.1% Fleet Management Fund 610 2,490,440 2,479,651 4,970,091 2,066,150 1,709,311 1,194,631 76.0% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 1,369,466 446,155 780,622 69.9% 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 503,103 - 105,904 82.6% 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 148,579 - 48,101 75.5% PARS Investment Trust 804 - - - - - - - $148,620,035 $76,400,395 $225,020,430 $103,965,580 $28,429,627 $92,625,223 58.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 March 31, 2023
Current Year Activity

3 4 5 6 7
Percent of Year

75.0%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 18,369,067 17,999,960 19,103,960 20,261,524 21,339,126 22,490,143 38,049,313 59.1% Sales & Use Tax 100 6,745,784 7,098,843 7,320,455 5,815,740 7,767,456 8,356,391 9,260,000 90.2% Franchise Tax (a) 100 577,877 492,778 472,597 479,817 437,439 431,910 1,135,000 38.1% Hotel Tax 100 2,739,395 3,188,321 3,477,703 1,324,542 3,852,232 4,831,563 4,025,000 120.0% Business License Tax 100 1,455,078 1,721,276 1,585,560 1,885,110 2,655,398 2,191,862 3,600,000 60.9% Real Estate Transfer Tax 100 592,224 557,800 640,128 669,075 923,107 453,420 810,000 56.0% Building Permits 100 1,519,164 1,433,997 1,329,552 1,091,710 1,407,719 1,251,806 1,532,712 81.7% Parking Citations 100 1,760,903 1,449,210 1,300,562 1,014,780 1,390,771 1,716,982 1,875,000 91.6% Interest Earnings 100 523,879 725,986 824,764 666,215 494,478 636,140 637,522 99.8% Marriott Hotel Rent 100 870,163 1,281,729 1,475,943 635,328 1,041,834 1,533,988 1,350,000 113.6% Vehicle in Lieu 100 18,680 17,276 28,431 - 40,590 36,360 17,000 213.9% Building Plan Check Fees 100 1,375,476 1,420,482 1,319,346 1,581,912 1,629,664 1,299,156 1,755,000 74.0% Total Major Revenue Accounts 36,547,691 37,387,659 38,879,000 35,425,753 42,979,813 45,229,721 64,046,547 70.6% Over/(Under) Prior Year 839,969 1,491,340 (3,453,247) 7,554,061 2,249,908 Percent Change From Prior Year 2.3% 4.0% (8.9%) 21.3% 5.2% Other Revenues 11,612,463 12,950,964 11,376,693 8,912,907 12,196,650 14,306,446 22,885,027 62.5% Total General Fund Revenues 48,160,154 50,338,624 50,255,692 44,338,660 55,176,463 59,536,167 86,931,574 68.5%

(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
March 31, 2023
$0 $3,000,000 $6,000,000 $9,000,000 $12,000,000 $15,000,000 $18,000,000 $21,000,000 $24,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
March 31, 2023
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources

3 4 5 6 7
Percent of Year

75.0%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through March 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

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. 31,326 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,184,778 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,106
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.
20,040
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.). 497,072 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.
63,898
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,966
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.
153,452
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 491,424
100-21312 Verizon PEG Deposit 2007 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
325,842
Total $ 4,177,801
Information Technology
Balance Sheet Accounts
As of March 31, 2023
Parks & Recreation
Police
Fire
Community Development

← All documents from this meeting