City of Manhattan Beach
Finance Department
Month End Report August 31, 2022
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,359,023 $0 $4,359,023 $556,394 $576,580 $3,226,049 26.0% Finance 12 3,819,223 - 3,819,223 478,949 164,086 3,176,188 16.8% Human Resources 13 1,622,969 - 1,622,969 239,768 75,883 1,307,318 19.4% Parks and Recreation 14 9,131,405 - 9,131,405 1,536,063 114,224 7,481,118 18.1% Police 15 33,631,799 - 33,631,799 4,395,219 208,532 29,028,048 13.7% Fire 16 15,286,191 - 15,286,191 2,000,821 14,395 13,270,975 13.2% Community Development 17 6,782,954 - 6,782,954 781,097 81,372 5,920,485 12.7% Public Works 18 10,641,587 250,000 10,891,587 1,139,563 167,663 9,584,361 12.0% Information Technology 19 - - - - - - - $85,275,151 $250,000 $85,525,151 $11,127,874 $1,402,735 $72,994,542 14.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 August 31, 2022
Current Year Activity
% of Year
16.7%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,669,227 $9,930,719 11.5% $85,525,151 $11,127,874 $1,402,735 14.7% Street Lighting & Landscaping Fund 201 390,822 1,667 0.4% 612,022 25,833 61,324 14.2% Gas Tax Fund 205 1,798,763 278,762 15.5% 1,575,138 120,508 574,299 44.1% Asset Forfeiture 210 41,800 6,081 14.5% 107,750 9,340 27,747 34.4% Police Safety Grants 211 159,000 12,620 7.9% 155,000 - 5,693 3.7% Prop A Fund 230 883,003 175,019 19.8% 780,646 104,146 7,717 14.3% Prop C Fund 231 712,451 149,109 20.9% 1,260,138 312,276 2,144,882 195.0% AB 2766 Fund 232 47,500 4,786 10.1% 673 112 - 16.6% Measure R 233 547,088 161,712 29.6% 1,010,138 15,743 283,059 29.6% Measure M 234 7,121,033 146,680 2.1% 7,070,138 31,887 381,512 5.8% Measure W 240 1,611,500 28,061 1.7% 1,200,000 - 1,149,197 95.8% Capital Improvements Fund 401 1,605,438 288,535 18.0% 6,442,589 761,690 3,382,674 64.3% Bond Construction Fund 402 - 202,703 n/a - 826,435 4,578,801 n/a Underground Assessment District Construction 403 - 97,421 n/a 1,285,750 35,642 247,219 22.0% Water Fund 501 16,472,500 2,798,114 17.0% 13,304,706 3,123,722 13,251,094 123.1% Stormwater Fund 502 344,484 43,706 12.7% 1,836,564 104,977 255,134 19.6% Wastewater Fund 503 3,628,000 880,339 24.3% 4,710,392 278,974 1,336,547 34.3% Parking Fund 520 3,983,200 995,621 25.0% 2,698,608 322,813 22,831 12.8% County Parking Lots Fund 521 1,363,000 318,843 23.4% 953,214 12,201 - 1.3% State Pier & Parking Lot Fund 522 833,500 199,216 23.9% 737,458 46,086 54,452 13.6% Insurance Reserve Fund 601 7,549,860 1,158,361 15.3% 8,243,352 4,712,678 259,820 60.3% Information Systems Reserve Fund 605 3,698,533 616,428 16.7% 4,276,387 561,447 757,864 30.9% Fleet Management Fund 610 2,772,827 375,304 13.5% 2,490,440 256,293 91,649 14.0% Building Maintenance & Operation Fund 615 2,195,831 219,457 10.0% 2,195,831 207,640 434,601 29.2% 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 778 0.3% 196,680 32,140 - 16.3% PARS Investment Trust 804 50,000 9,954 19.9% - - - - $146,401,709 $19,105,068 13.0% $150,320,035 $24,472,291 $30,710,851 16.3% Year-to-Date
As of August 31, 2022
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
16.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 $9,930,719 76,738,508 11.5% Street Lighting & Landscaping Fund 201 390,822 - 390,822 1,667 389,155 0.4% Gas Tax Fund 205 1,798,763 - 1,798,763 278,762 1,520,001 15.5% Asset Forfeiture 210 41,800 - 41,800 6,081 35,719 14.5% Police Safety Grants 211 159,000 - 159,000 12,620 146,380 7.9% Prop A Fund 230 883,003 - 883,003 175,019 707,984 19.8% Prop C Fund 231 712,451 - 712,451 149,109 563,342 20.9% AB 2766 Fund 232 47,500 - 47,500 4,786 42,714 10.1% Measure R 233 547,088 - 547,088 161,712 385,376 29.6% Measure M 234 5,921,033 1,200,000 7,121,033 146,680 6,974,353 2.1% Measure W 240 1,611,500 - 1,611,500 28,061 1,583,439 1.7% Capital Improvements Fund 401 1,605,438 - 1,605,438 288,535 1,316,903 18.0% Bond Construction Fund 402 - - - 202,703 (202,703) 100.0% Underground Assessment District Construction 403 - - - 97,421 (97,421) 100.0% Water Fund 501 16,472,500 - 16,472,500 2,798,114 13,674,386 17.0% Stormwater Fund 502 344,484 - 344,484 43,706 300,778 12.7% Wastewater Fund 503 3,628,000 - 3,628,000 880,339 2,747,661 24.3% Parking Fund 520 3,983,200 - 3,983,200 995,621 2,987,579 25.0% County Parking Lots Fund 521 1,363,000 - 1,363,000 318,843 1,044,157 23.4% State Pier & Parking Lot Fund 522 833,500 - 833,500 199,216 634,284 23.9% Insurance Reserve Fund 601 7,549,860 - 7,549,860 1,158,361 6,391,499 15.3% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 616,428 3,082,105 16.7% Fleet Management Fund 610 2,772,827 - 2,772,827 375,304 2,397,523 13.5% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 219,457 1,976,374 10.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 778 263,702 0.3% PARS Investment Trust 804 50,000 - 50,000 9,954 40,046 19.9% $145,201,709 $1,200,000 $146,401,709 $19,105,068 $127,296,641 13.0% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of August 31, 2022
Current Year Activity
% of Year
16.7%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $250,000 $85,525,151 $11,127,874 $1,402,735 $72,994,542 14.7% Street Lighting & Landscaping Fund 201 612,022 - 612,022 25,833 61,324 524,865 14.2% Gas Tax Fund 205 1,575,138 - 1,575,138 120,508 574,299 880,331 44.1% Asset Forfeiture 210 107,750 - 107,750 9,340 27,747 70,664 34.4% Police Safety Grants 211 155,000 - 155,000 - 5,693 149,307 3.7% Prop A Fund 230 780,646 - 780,646 104,146 7,717 668,783 14.3% Prop C Fund 231 1,260,138 - 1,260,138 312,276 2,144,882 (1,197,020) 195.0% AB 2766 Fund 232 673 - 673 112 - 561 16.6%
Measure R 233 760,138 250,000 1,010,138 15,743 283,059 711,336 29.6% Measure M 234 5,870,138 1,200,000 7,070,138 31,887 381,512 6,656,739 5.8% Measure W 240 1,200,000 - 1,200,000 - 1,149,197 50,803 - Capital Improvements Fund 401 6,442,589 - 6,442,589 761,690 3,382,674 2,298,225 64.3% Bond Construction Fund 402 - - - 826,435 4,578,801 (5,405,236) 100.0% Underground Assessment District Construction 403 1,285,750 - 1,285,750 35,642 247,219 1,002,890 22.0% Water Fund 501 13,304,706 - 13,304,706 3,123,722 13,251,094 (3,070,109) 123.1% Stormwater Fund 502 1,836,564 - 1,836,564 104,977 255,134 1,476,453 19.6% Wastewater Fund 503 4,710,392 - 4,710,392 278,974 1,336,547 3,094,872 34.3% Parking Fund 520 2,698,608 - 2,698,608 322,813 22,831 2,352,965 12.8% County Parking Lots Fund 521 953,214 - 953,214 12,201 - 941,013 1.3% State Pier & Parking Lot Fund 522 737,458 - 737,458 46,086 54,452 636,919 13.6% Insurance Reserve Fund 601 8,243,352 - 8,243,352 4,712,678 259,820 3,270,854 60.3% Information Systems Reserve Fund 605 4,276,387 - 4,276,387 561,447 757,864 2,957,075 30.9% Fleet Management Fund 610 2,490,440 - 2,490,440 256,293 91,649 2,142,498 14.0% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 207,640 434,601 1,553,590 29.2% 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 32,140 - 164,540 16.3% PARS Investment Trust 804 - - - - - - -
$148,620,035 $1,700,000 $150,320,035 $24,472,291 $30,710,851 $95,136,893 36.7% *Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year. Capital Improvement project budget carryforwards will be posted after the prior year-end closing.
Year-to-Date
City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Expenditures
As of August 31, 2022
Current Year Activity
3 4 5 6 7
City of Manhattan Beach Percent of Year
16.7%
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 1,416,000 1,512,010 1,638,508 1,249,220 1,708,940 1,995,892 9,260,000 21.6% Franchise Tax (a) 100 161,392 167,202 159,776 151,631 147,576 - 1,135,000 0.0% Hotel Tax 100 786,960 785,764 910,733 300,577 882,717 1,114,074 4,025,000 27.7% Business License Tax 100 124,560 210,013 244,238 489,304 717,723 315,511 3,600,000 8.8% Real Estate Transfer Tax 100 181,549 183,454 121,395 43,690 336,863 - 810,000 0.0% Building Permits 100 292,466 230,870 334,463 256,657 240,375 369,028 1,532,712 24.1% Parking Citations 100 426,629 440,273 316,479 195,554 360,864 234,394 1,875,000 12.5% Interest Earnings 100 162,239 260,118 362,501 337,855 151,755 134,355 637,522 21.1% Marriott Hotel Rent 100 394,945 352,504 456,801 66,667 229,869 66,667 1,350,000 4.9% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 402,870 323,537 323,307 346,109 248,307 364,369 1,755,000 20.8% Total Major Revenue Accounts 5,031,616 5,194,724 5,623,918 4,213,730 5,795,216 5,418,887 64,046,547 8.5% Over/(Under) Prior Year 163,108 429,194 (1,410,188) 1,581,486 (376,329) Percent Change From Prior Year 3.2% 8.3% (25.1%) 37.5% (6.5%) Other Revenues 3,471,147 3,689,863 3,373,532 2,268,022 2,725,009 4,511,832 22,622,680 19.9% Total General Fund Revenues 8,502,763 8,884,587 8,997,449 6,481,752 8,520,225 9,930,719 86,669,227 11.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.
Fiscal Year 2022-2023 General Fund Major Revenue Trends August 31, 2022
Year-To-Date Actuals FY 2023
$0 $500,000 $1,000,000 $1,500,000 $2,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
August 31, 2022
Fiscal Year 2022-23
Fiscal Year 2021-22
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
$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