Cities Index.
Month End Financial Report April 2023

Manhattan Beach City Council
June 6, 2023

Document
Month End Financial Report April 2023
Meeting
June 6, 2023
Body
Manhattan Beach City Council
Original file
431 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 April 2023
Fiscal Year 2022-2023

% of Year

83.3%
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,534,857 $356,262 $641,062 85.9% Finance 12 3,819,223 23,665 3,842,888 2,890,559 83,383 868,946 77.4% Human Resources 13 1,622,969 92,701 1,715,670 1,354,784 68,765 292,121 83.0% Parks and Recreation 14 9,131,405 63,127 9,194,532 7,040,360 83,224 2,070,948 77.5% Police 15 33,631,799 510,231 34,142,030 25,116,783 61,664 8,963,582 73.7% Fire 16 15,286,191 335,530 15,621,721 11,444,643 22,935 4,154,143 73.4% Community Development 17 6,782,954 232,895 7,015,849 4,854,129 197,503 1,964,217 72.0% Public Works 18 10,641,587 648,913 11,290,500 7,125,060 662,248 3,503,191 69.0% Information Technology 19 - - - - - - - $85,275,151 $2,080,221 $87,355,372 $63, 361,177 $1,535,985 $22,458,209 74.3% ¹Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year.

City of Manhattan Beach
Fiscal Year 2022-2023 General Fund Expenditures by Department As of April 30, 2023
Current Year Activity

% of Year

83.3%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,931,574 $75,421,780 86.8% $87,355,372 $63,361,177 $1,535,985 74.3% Street Lighting & Landscaping Fund 201 390,822 320,259 81.9% 719,511 373,692 5,467 52.7% Gas Tax Fund 205 2,048,850 1,481,310 72.3% 3,763,167 324,085 1,836,191 57.4% Asset Forfeiture 210 41,800 42,135 100.8% 135,497 31,298 27,747 43.6% Police Safety Grants 211 159,000 184,560 116.1% 209,693 87,106 22,651 52.3% Prop A Fund 230 883,003 739,475 83.7% 788,363 546,682 5,307 70.0% Prop C Fund 231 10,681,953 2,409,166 22.6% 11,116,168 1,250,021 1,419,236 24.0% AB 2766 Fund 232 47,500 41,639 87.7% 673 560 - 83.2% Measure R 233 1,087,088 604,469 55.6% 2,595,986 95,569 1,070,713 44.9% Measure M 234 11,594,378 642,050 5.5% 12,873,472 195,781 1,123,722 10.2% Measure W 240 3,015,015 466,186 15.5% 2,603,515 239,993 879,603 43.0% Capital Improvements Fund 401 2,698,284 1,393,096 51.6% 13,413,182 3,313,153 2,890,740 46.3% Bond Construction Fund 402 - 274,511 n/a 5,595,390 3,323,975 2,138,520 97.6% Underground Assessment District Construction 403 - 130,298 n/a 1,316,657 100,828 8,389 8.3% Water Fund 501 16,472,500 13,102,806 79.5% 33,538,699 17,557,390 9,160,740 79.7% Stormwater Fund 502 344,484 346,695 100.6% 4,458,062 1,075,881 93,620 26.2% Wastewater Fund 503 3,628,000 3,402,725 93.8% 15,349,147 1,999,825 978,024 19.4% Parking Fund 520 3,983,200 3,553,756 89.2% 3,026,777 2,069,729 267,831 77.2% County Parking Lots Fund 521 1,363,000 910,192 66.8% 953,214 191,573 - 20.1% State Pier & Parking Lot Fund 522 833,500 743,660 89.2% 2,776,820 307,633 2,168,748 89.2% Insurance Reserve Fund 601 7,549,860 8,642,833 114.5% 8,277,783 9,007,380 73,491 109.7% Information Systems Reserve Fund 605 3,698,533 3,082,830 83.4% 4,738,998 2,438,387 461,800 61.2% Fleet Management Fund 610 2,772,827 2,200,868 79.4% 4,970,091 2,218,266 1,753,150 79.9% Building Maintenance & Operation Fund 615 2,195,831 1,444,321 65.8% 2,596,244 1,464,254 445,382 73.6% Special Assessment Debt Service 710 714,150 627,178 87.8% 700,450 665,625 - 95.0% Special Assessment UAD 19-12 19-14 Fund 711 606,106 544,379 89.8% 609,007 503,103 - 82.6% Special Assessment UAD 19-4 Fund 712 337,613 285,060 84.4% 341,813 278,506 - 81.5% City Pension Fund 801 264,480 888 0.3% 196,680 164,149 - 83.5% PARS Investment Trust 804 50,000 72,692 145.4% - - - - $164,393,351 $123,111,817 74.9% $225,020,430 $113,185,622 $28,367,059 50.3% Year-to-Date
As of April 30, 2023
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity

% of Year

83.3%
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 $75,421,780 11,509,794 86.8% Street Lighting & Landscaping Fund 201 390,822 - 390,822 320,259 70,563 81.9% Gas Tax Fund 205 1,798,763 250,087 2,048,850 1,481,310 567,539 72.3% Asset Forfeiture 210 41,800 - 41,800 42,135 (335) 100.8% Police Safety Grants 211 159,000 - 159,000 184,560 (25,560) 116.1% Prop A Fund 230 883,003 - 883,003 739,475 143,528 83.7% Prop C Fund 231 712,451 9,969,502 10,681,953 2,409,166 8,272,787 22.6% AB 2766 Fund 232 47,500 - 47,500 41,639 5,861 87.7% Measure R 233 547,088 540,000 1,087,088 604,469 482,619 55.6% Measure M 234 5,921,033 5,673,345 11,594,378 642,050 10,952,328 5.5% Measure W 240 1,611,500 1,403,515 3,015,015 466,186 2,548,829 15.5% Capital Improvements Fund 401 1,605,438 1,092,846 2,698,284 1,393,096 1,305,188 51.6% Bond Construction Fund 402 - - - 274,511 (274,511) 100.0% Underground Assessment District Construction 403 - - - 130,298 (130,298) 100.0% Water Fund 501 16,472,500 - 16,472,500 13,102,806 3,369,694 79.5% Stormwater Fund 502 344,484 - 344,484 346,695 (2,211) 100.6% Wastewater Fund 503 3,628,000 - 3,628,000 3,402,725 225,275 93.8% Parking Fund 520 3,983,200 - 3,983,200 3,553,756 429,444 89.2% County Parking Lots Fund 521 1,363,000 - 1,363,000 910,192 452,808 66.8% State Pier & Parking Lot Fund 522 833,500 - 833,500 743,660 89,840 89.2% Insurance Reserve Fund 601 7,549,860 - 7,549,860 8,642,833 (1,092,973) 114.5% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 3,082,830 615,703 83.4% Fleet Management Fund 610 2,772,827 - 2,772,827 2,200,868 571,959 79.4% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 1,444,321 751,510 65.8% Special Assessment Debt Service 710 714,150 - 714,150 627,178 86,972 87.8% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 544,379 61,727 89.8% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 285,060 52,553 84.4% 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 $123,111,817 $41,281,533 74.9% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of April 30, 2023
Current Year Activity

% of Year

83.3%
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 $63,361,177 $1,535,985 $22,458,209 74.3% Street Lighting & Landscaping Fund 201 612,022 107,489 719,511 373,692 5,467 340,351 52.7% Gas Tax Fund 205 1,575,138 2,188,029 3,763,167 324,085 1,836,191 1,602,891 57.4% 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 546,682 5,307 236,374 70.0% Prop C Fund 231 1,260,138 9,856,030 11,116,168 1,250,021 1,419,236 8,446,912 24.0% AB 2766 Fund 232 673 - 673 560 - 113 83.2% Measure R 233 760,138 1,835,848 2,595,986 95,569 1,070,713 1,429,705 44.9% Measure M 234 5,870,138 7,003,334 12,873,472 195,781 1,123,722 11,553,969 10.2% Measure W 240 1,200,000 1,403,515 2,603,515 239,993 879,603 1,483,920 43.0% Capital Improvements Fund 401 6,442,589 6,970,593 13,413,182 3,313,153 2,890,740 7,209,289 46.3% Bond Construction Fund 402 - 5,595,390 5,595,390 3,323,975 2,138,520 132,895 97.6% Underground Assessment District Construction 403 1,285,750 30,907 1,316,657 100,828 8,389 1,207,439 8.3% Water Fund 501 13,304,706 20,233,993 33,538,699 17,557,390 9,160,740 6,820,568 79.7% Stormwater Fund 502 1,836,564 2,621,498 4,458,062 1,075,881 93,620 3,288,560 26.2% Wastewater Fund 503 4,710,392 10,638,755 15,349,147 1,999,825 978,024 12,371,297 19.4% Parking Fund 520 2,698,608 328,169 3,026,777 2,069,729 267,831 689,218 77.2% County Parking Lots Fund 521 953,214 - 953,214 191,573 - 761,641 20.1% State Pier & Parking Lot Fund 522 737,458 2,039,362 2,776,820 307,633 2,168,748 300,439 89.2% Insurance Reserve Fund 601 8,243,352 34,431 8,277,783 9,007,380 73,491 (803,088) 109.7% Information Systems Reserve Fund 605 4,276,387 462,611 4,738,998 2,438,387 461,800 1,838,811 61.2% Fleet Management Fund 610 2,490,440 2,479,651 4,970,091 2,218,266 1,753,150 998,675 79.9% Building Maintenance & Operation Fund 615 2,195,831 400,413 2,596,244 1,464,254 445,382 686,608 73.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,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 164,149 - 32,531 83.5% PARS Investment Trust 804 - - - - - - - $148,620,035 $76,400,395 $225,020,430 $113,185,622 $28,367,059 $83,467,750 62.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 April 30, 2023
Current Year Activity

3 4 5 6 7
Percent of Year

83.3%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 24,215,864 25,746,991 27,471,166 29,619,573 30,904,803 32,448,751 38,049,313 85.3% Sales & Use Tax 100 7,312,584 7,837,528 7,830,413 6,467,650 8,347,199 9,023,876 9,260,000 97.5% Franchise Tax (a) 100 1,094,222 1,008,237 1,018,936 1,051,935 1,082,197 1,174,970 1,135,000 103.5% Hotel Tax 100 3,076,271 3,588,030 3,574,726 1,605,033 4,398,130 5,426,979 4,025,000 134.8% Business License Tax 100 3,022,394 3,535,969 2,065,381 2,307,770 4,350,917 3,862,047 3,600,000 107.3% Real Estate Transfer Tax 100 663,498 598,175 674,360 733,379 1,066,884 453,420 810,000 56.0% Building Permits 100 1,695,463 1,610,408 1,391,144 1,231,939 1,574,559 1,355,818 1,532,712 88.5% Parking Citations 100 2,009,513 1,601,018 1,489,437 1,100,187 1,679,238 1,858,192 1,875,000 99.1% Interest Earnings 100 669,800 862,173 1,056,505 771,459 556,518 860,355 637,522 135.0% Marriott Hotel Rent 100 903,496 1,315,062 1,509,276 668,661 1,075,168 1,880,634 1,350,000 139.3% Vehicle in Lieu 100 18,680 17,276 28,431 - 40,590 36,360 17,000 213.9% Building Plan Check Fees 100 1,496,387 1,547,138 1,335,854 1,702,313 1,820,395 1,411,301 1,755,000 80.4% Total Major Revenue Accounts 46,178,172 49,268,008 49,445,629 47,259,899 56,896,598 59,792,702 64,046,547 93.4% Over/(Under) Prior Year 3,089,836 177,621 (2,185,730) 9,636,699 2,896,104 Percent Change From Prior Year 6.7% 0.4% (4.4%) 20.4% 5.1% Other Revenues 12,942,497 14,277,203 12,094,009 9,976,135 13,574,066 15,629,078 22,885,027 68.3% Total General Fund Revenues 59,120,669 63,545,210 61,539,638 57,236,033 70,470,663 75,421,780 86,931,574 86.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
April 30, 2023
$0 $4,000,000 $8,000,000 $12,000,000 $16,000,000 $20,000,000 $24,000,000 $28,000,000 $32,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
April 30, 2023
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources

3 4 5 6 7
Percent of Year

83.3%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through April 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
$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. 31,091 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,186,926 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,402
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.). 499,245 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.
64,368
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,099
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.
161,044
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,190,445
Information Technology
Balance Sheet Accounts
As of April 30, 2023
Parks & Recreation
Police
Fire
Community Development

← All documents from this meeting