Cities Index.
Financial Month End Report August 2023

Manhattan Beach City Council
October 3, 2023

Document
Financial Month End Report August 2023
Meeting
October 3, 2023
Body
Manhattan Beach City Council
Original file
651 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
August 2023
Fiscal Year 2022-2023

% of Year

16.7%
Dept Original Budget Adjusted YTD YTD Available %
No. Budget Adjustments1 Budget Expenditures Encumbrances Budget Used Management Services 11 $4,772,336 $35,970 $4,808,306 $494,242 $329,499 $3,984,565 17.1% Finance 12 4,072,716 - 4,072,716 601,551 194,589 3,276,576 19.5% Human Resources 13 1,698,442 - 1,698,442 245,567 55,482 1,397,394 17.7% Parks and Recreation 14 11,616,474 - 11,616,474 1,932,891 1,071,424 8,612,159 25.9% Police 15 35,878,624 - 35,878,624 4,836,794 81,610 30,960,220 13.7% Fire 16 16,595,215 - 16,595,215 2,406,283 14,399 14,174,533 14.6% Community Development 17 7,851,987 - 7,851,987 965,283 604,463 6,282,241 20.0% Public Works 18 10,340,170 - 10,340,170 1,378,908 984,347 7,976,915 22.9% Information Technology 19 - - - - - - - $92,825,964 $35,970 $92,861,934 $12,861,519 $3,335,812 $76,664,604 17.4% ¹Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year.

April 30, 2024
May 31, 2024
June 30, 2024
City of Manhattan Beach
Fiscal Year 2023-2024 General Fund Expenditures by Department As of August 31, 2023
Current Year Activity

% of Year

16.7%
Adjusted Adjusted
Fund Budge t YTD % Budge t %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $93,300,981 $10,529,175 11.3% $92,861,934 $12,861,519 $3,335,812 17.4% Street Lighting & Landscaping Fund 201 390,597 9,186 2.4% 695,449 30,034 80,609 15.9% Gas Tax Fund 205 1,946,355 331,140 17.0% 2,555,138 68,254 2,010,803 81.4% Asset Forfeiture 210 41,800 713 1.7% 90,500 2,326 - 2.6% Police Safety Grants 211 164,000 1,943 1.2% 239,000 22,771 (13,884) 3.7% Prop A Fund 230 1,036,405 166,702 16.1% 763,401 124,405 407,731 69.7% Prop C Fund 231 839,596 729,724 86.9% 810,138 91,931 2,774,557 353.8% AB 2766 Fund 232 47,500 12,715 26.8% 275,673 112 - 0.0% Measure R 233 2,482,521 68,781 2.8% 1,060,138 33,802 496,308 50.0% Measure M 234 3,999,190 73,285 1.8% 3,940,138 101,748 1,892,493 50.6% Measure W 240 25,530,264 8,630 0.0% 26,348,763 22,203 639,725 2.5% Capital Improvements Fund 401 2,072,438 327,060 15.8% 7,896,641 178,660 2,247,622 30.7% Bond Construction Fund 402 - 11,129 n/a - 444,374 1,308,614 n/a Underground Assessment District Construction 403 - 10,262 n/a 360,000 13,425 8,389 6.1% Water Fund 501 16,201,728 2,826,472 17.4% 17,232,256 1,469,512 3,645,292 29.7% Stormwater Fund 502 393,051 18,575 4.7% 3,083,612 105,778 57,581 5.3% Wastewater Fund 503 3,898,500 665,812 17.1% 3,755,752 398,384 567,818 25.7% Parking Fund 520 4,457,200 947,966 21.3% 4,143,929 404,062 224,825 15.2% County Parking Lots Fund 521 1,382,200 269,402 19.5% 1,016,620 15,646 - 1.5% State Pier & Parking Lot Fund 522 858,500 155,550 18.1% 622,046 54,012 2,113,630 348.5% Insurance Reserve Fund 601 8,857,380 1,554,934 17.6% 8,737,009 3,241,301 255,084 40.0% Information Systems Reserve Fund 605 4,404,750 734,128 16.7% 4,516,563 760,876 539,571 28.8% Fleet Management Fund 610 3,204,433 508,515 15.9% 3,281,804 612,460 (136,521) 14.5% Building Maintenance & Operation Fund 615 2,560,994 302,089 11.8% 2,530,593 348,081 268,730 24.4% Special Assessment Debt Service 710 714,150 19,417 2.7% 706,475 661,814 - 93.7% Special Assessment UAD 19-12 19-14 Fund 711 606,106 14,623 2.4% 605,807 492,358 - 81.3% Special Assessment UAD 19-4 Fund 712 337,613 14,048 4.2% 337,363 271,974 - 80.6% City Pension Fund 801 264,480 191 0.1% 196,680 32,266 - 16.4% PARS Investment Trust 804 50,000 982 2.0% - - - - $180,042,732 $20,313,150 11.3% $188,663, 422 $22,864,086 $22,724,792 12.1% Year-to-Date
As of August 31, 2023
Fiscal Year 2023-2024 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity

% of Year

16.7%
Fund Original Budge t Adjusted Year-to-Date Unrealized % No. Budge t Adjustments Budge t Actuals Amoun t Realized General Fund 100 $93,300,981 $0 $93,300,981 $10,529,175 81,748,255 12.4% Street Lighting & Landscaping Fund 201 390,597 - 390,597 9,186 381,411 2.4% Gas Tax Fund 205 1,946,355 - 1,946,355 331,140 1,615,215 17.0% Asset Forfeiture 210 41,800 - 41,800 713 41,087 1.7% Police Safety Grants 211 164,000 - 164,000 1,943 162,057 1.2% Prop A Fund 230 1,036,405 - 1,036,405 166,702 869,703 16.1% Prop C Fund 231 839,596 - 839,596 729,724 109,872 86.9% AB 2766 Fund 232 47,500 - 47,500 12,715 34,785 26.8% Measure R 233 2,482,521 - 2,482,521 68,781 2,413,740 2.8% Measure M 234 3,999,190 - 3,999,190 73,285 3,925,905 1.8% Measure W 240 25,530,264 - 25,530,264 8,630 25,521,634 0.0% Capital Improvements Fund 401 2,072,438 - 2,072,438 327,060 1,745,378 15.8% Bond Construction Fund 402 - - - 11,129 (11,129) 100.0% Underground Assessment District Construction 403 - - - 10,262 (10,262) 100.0% Water Fund 501 16,201,728 - 16,201,728 2,826,472 13,375,256 17.4% Stormwater Fund 502 393,051 - 393,051 18,575 374,476 4.7% Wastewater Fund 503 3,898,500 - 3,898,500 665,812 3,232,688 17.1% Parking Fund 520 4,457,200 - 4,457,200 947,966 3,509,234 21.3% County Parking Lots Fund 521 1,382,200 - 1,382,200 269,402 1,112,798 19.5% State Pier & Parking Lot Fund 522 858,500 - 858,500 155,550 702,950 18.1% Insurance Reserve Fund 601 8,857,380 - 8,857,380 1,554,934 7,302,446 17.6% Information Systems Reserve Fund 605 4,404,750 - 4,404,750 734,128 3,670,622 16.7% Fleet Management Fund 610 3,204,433 - 3,204,433 508,515 2,695,918 15.9% Building Maintenance & Operation Fund 615 2,560,994 - 2,560,994 302,089 2,258,905 11.8% Special Assessment Debt Service 710 714,150 - 714,150 19,417 694,733 2.7% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 14,623 591,483 2.4% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 14,048 323,565 4.2% City Pension Fund 801 264,480 - 264,480 191 264,289 0.1% PARS Investment Trust 804 50,000 - 50,000 982 49,018 2.0% $180,042,732 $0 $180,042,732 $20,313,150 $158,706,031 11.3% City of Manhattan Beach
Fiscal Year 2023-2024 Citywide Revenues
As of August 31, 2023
Current Year Activity

% of Year

16.7%
Fund Original Budge t Adjusted Available %
No. Budge t Adjustments* Budge t Actuals Encumbrances Budge t Utilized General Fund 100 $92,825,964 $35,970 $92,861,934 $12,861,519 $3,335,812 $76,664,604 17.4% Street Lighting & Landscaping Fund 201 695,449 - 695,449 30,034 80,609 584,807 15.9% Gas Tax Fund 205 2,555,138 - 2,555,138 68,254 2,010,803 476,081 81.4% Asset Forfeiture 210 90,500 - 90,500 2,326 - 88,174 2.6% Police Safety Grants 211 239,000 - 239,000 22,771 (13,884) 230,112 3.7% Prop A Fund 230 763,401 - 763,401 124,405 407,731 231,265 69.7% Prop C Fund 231 810,138 - 810,138 91,931 2,774,557 (2,056,350) 353.8% AB 2766 Fund 232 275,673 - 275,673 112 - 275,561 0.0% Measure R 233 1,060,138 - 1,060,138 33,802 496,308 530,028 50.0% Measure M 234 3,940,138 - 3,940,138 101,748 1,892,493 1,945,897 50.6% Measure W 240 26,348,763 - 26,348,763 22,203 639,725 25,686,835 2.5% Capital Improvements Fund 401 7,896,641 - 7,896,641 178,660 2,247,622 5,470,359 30.7% Bond Construction Fund 402 - - - 444,374 1,308,614 (1,752,988) 100.0% Underground Assessment District Construction 403 360,000 - 360,000 13,425 8,389 338,186 6.1% Water Fund 501 17,232,256 - 17,232,256 1,469,512 3,645,292 12,117,452 29.7% Stormwater Fund 502 3,083,612 - 3,083,612 105,778 57,581 2,920,253 5.3% Wastewater Fund 503 3,755,752 - 3,755,752 398,384 567,818 2,789,550 25.7% Parking Fund 520 4,143,929 - 4,143,929 404,062 224,825 3,515,042 15.2% County Parking Lots Fund 521 1,016,620 - 1,016,620 15,646 - 1,000,974 1.5% State Pier & Parking Lot Fund 522 622,046 - 622,046 54,012 2,113,630 (1,545,596) 348.5% Insurance Reserve Fund 601 8,737,009 - 8,737,009 3,241,301 255,084 5,240,625 40.0% Information Systems Reserve Fund 605 4,516,563 - 4,516,563 760,876 539,571 3,216,115 28.8% Fleet Management Fund 610 3,281,804 - 3,281,804 612,460 (136,521) 2,805,865 14.5% Building Maintenance & Operation Fund 615 2,530,593 - 2,530,593 348,081 268,730 1,913,782 24.4% Special Assessment Debt Service 710 706,475 - 706,475 661,814 - 44,661 93.7% Special Assessment UAD 19-12 19-14 Fund 711 605,807 - 605,807 492,358 - 113,449 81.3% Special Assessment UAD 19-4 Fund 712 337,363 - 337,363 271,974 - 65,389 80.6% City Pension Fund 801 196,680 - 196,680 32,266 - 164,414 16.4% PARS Investment Trust 804 - - - - - - - $188,627,452 $35,970 $188,663,422 $22,864,086 $22,724,792 $143,074,545 24.2% *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 2023-2024 Citywide Expenditures
As of August 31, 2023
Current Year Activity

$3 $4 $5 $6 $7
Percent of Year

16.7%
Fund
Major Revenue Accounts No. 2019 2020 2021 2022 2023 2024 Adj Budget Realized Property Taxes 100 $728,979 $755,718 $776,468 $770,228 $824,597 $896,139 $38,049,313 2.4% Sales & Use Tax 100 1,512,010 1,638,508 1,249,220 1,708,940 1,995,892 2,248,249 9,260,000 24.3% Franchise Tax (a) 100 167,202 159,776 151,631 147,576 - 131,838 1,135,000 11.6% Hotel Tax 100 785,764 910,733 300,577 882,717 1,114,074 1,500,175 4,025,000 37.3% Business License Tax 100 210,013 244,238 489,304 717,723 315,511 385,656 3,600,000 10.7% Real Estate Transfer Tax 100 183,454 121,395 43,690 336,863 - 69,040 810,000 8.5% Building Permits 100 230,870 334,463 256,657 240,375 369,028 431,554 1,532,712 28.2% Parking Citations 100 440,273 316,479 195,554 360,864 234,447 344,599 1,875,000 18.4% Interest Earnings 100 260,118 362,501 337,855 151,755 134,355 360,878 637,522 56.6% Marriott Hotel Rent 100 352,504 456,801 66,667 229,869 66,667 525,804 1,350,000 38.9% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 323,537 323,307 346,109 248,307 364,369 353,602 1,755,000 20.1% Total Major Revenue Accounts $5,194,724 $5,623,918 $4,213,730 $5,795,216 $5,418,940 $7,247,533 $64,046,547 11.3% Over/(Under) Prior Year 429,194 (1,410,188) 1,581,486 (376,276) 1,828,593 Percent Change From Prior Year 8.3% (25.1%) 37.5% (6.5%) 33.7% Other Revenues 3,689,863 3,373,532 2,268,022
2,725,009 4,853,958 3,281,642 29,254,434 11.2% Total General Fund Revenues $8,884,587 $8,997,449 $6,481,752 $8,520,225 $10,272,898 $10,529,175 $93,300,981 11.3%

(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 2023-2024 General Fund Major Revenue Trends Year-To-Date Actuals FY 2024
August 31, 2023
$0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,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
August 31, 2023
Fiscal Year 2023-24
Fiscal Year 2022-23
General Fund Major Revenue Sources

$3 $4 $5 $6 $7
Percent of Year

16.7%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through August Year-Over-Year
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
2019 2020 2021 2022 2023 2024
Sales & Use Tax
$0
$100,000
$200,000
$300,000
$400,000
$500,000
2019 2020 2021 2022 2023 2024
Franchise Tax
$0
$400,000
$800,000
$1,200,000
$1,600,000
$2,000,000
2019 2020 2021 2022 2023 2024
Property Taxes
$0
$400,000
$800,000
$1,200,000
$1,600,000
$2,000,000
2019 2020 2021 2022 2023 2024
Hotel Tax
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
2019 2020 2021 2022 2023 2024
Business License Tax
$0
$100,000
$200,000
$300,000
$400,000
$500,000
2019 2020 2021 2022 2023 2024
Real Estate Transfer Tax
$0
$100,000
$200,000
$300,000
$400,000
$500,000
2019 2020 2021 2022 2023 2024
Building Permits
$0
$100,000
$200,000
$300,000
$400,000
$500,000
2019 2020 2021 2022 2023 2024
Parking Citations
$0
$100,000
$200,000
$300,000
$400,000
$500,000
2019 2020 2021 2022 2023 2024
Interest Earnings
$0
$200,000
$400,000
$600,000
$800,000
$1,000,000
2019 2020 2021 2022 2023 2024
Marriott Hotel Rent
$0
$100,000
$200,000
$300,000
$400,000
$500,000
2019 2020 2021 2022 2023 2024
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. 15,864 100-21706 Recreation Sponsorships 2017 Sponsorship revenue/expenses for other programs. 24,750 802-21708 Public Art Development Fees 2003 Funded through a portion of development fees. Used to fund Public Art. 1,804,922 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. 24,198 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,344
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.
29,511
100-21602 Tree Penalties for Illegal Removal 2018 Fines for illegally removed trees for the planting of new trees. $ 77,355 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.). 520,701 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.
68,751
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. 18,494
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.
213,203
100-21311 Time Warner PEG Deposit 1997 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
$ 523,127
100-21312 Verizon PEG Deposit 2007 Public, Education, and Governmental Access. MBtv (city government cablecast and webcast) capital expenditures, repairs and upgrades.
330,441
Total $ 3,924,756
Information Technology
Balance Sheet Accounts
As of August 31, 2023
Parks & Recreation
Police
Fire
Community Development

← All documents from this meeting