City of Manhattan Beach
Finance Department
Preliminary Month End Report
June 30, 2022
Fiscal
Year 2021-2022
% of Year
100.0%
Dept Original Budget Adjusted YTD YTD Available %
No. Budget Adjustments1 Budget Expenditures Encumbrances Budget Used Management Services 11 $3,599,705 $667,835 $4,267,540 $3,723,777 $287,041 $256,722 94.0% Finance 12 3,607,149 54,297 3,661,446 3,586,290 33,426 41,730 98.9% Human Resources 13 1,416,358 267,511 1,683,869 1,507,119 71,291 105,459 93.7% Parks and Recreation 14 8,417,571 24,296 8,441,867 8,382,750 89,215 (30,098) 100.4% Police 15 30,667,807 190,717 30,858,524 29,705,677 4,521 1,148,326 96.3% Fire 16 15,471,419 11,727 15,483,146 15,559,865 14,395 (91,114) 100.6% Community Development 17 5,908,891 305,381 6,214,272 6,035,180 88,795 90,296 98.5% Public Works 18 8,609,392 78,023 8,687,415 8,597,990 128,118 (38,693) 100.4% Information Technology 19 - - - - - - - $77,698,292 $1,599,788 $79,298,080 $77,098,648 $716,803 $1,482,628 98.1% ¹Budget Adjustments include City Council-approved adjustments during the current year and encumbrances carried forward from the prior year.
April 30, 2022
May 31, 2022
June 30, 2022
City of Manhattan Beach
Fiscal Year 2021-2022 General Fund Expenditures by Department As of June 30, 2022
Current Year Activity
% of Year
100.0%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $82,742,365 $84,872,839 102.6% $79,298,080 $77,098,648 $716,803 98.1% Street Lighting & Landscaping Fund 201 389,689 501,062 128.6% 648,241 554,750 53,774 93.9% Gas Tax Fund 205 2,711,285 2,535,568 93.5% 3,866,994 1,383,168 1,098,517 64.2% Asset Forfeiture 210 28,824 34,836 120.9% 136,247 84,668 27,747 82.5% Police Safety Grants 211 159,192 161,255 101.3% 194,408 65,013 99,945 84.9% Prop A Fund 230 737,244 897,675 121.8% 943,975 628,594 7,717 67.4% Prop C Fund 231 14,405,003 5,570,562 38.7% 13,617,577 4,413,299 2,311,767 49.4% AB 2766 Fund 232 46,641 34,182 73.3% 673 672 - 99.9% Measure R 233 998,499 558,741 56.0% 2,044,355 160,348 177,973 16.5% Measure M 234 5,949,690 1,594,037 26.8% 6,835,866 947,761 435,792 20.2% Measure W 240 1,907,100 1,918,218 100.6% 1,497,100 17,103 1,218,948 82.6% Capital Improvements Fund 401 3,862,447 1,554,061 40.2% 9,823,368 3,075,858 3,590,183 67.9% Bond Construction Fund 402 8,470,000 8,783,609 103.7% 8,470,000 2,850,196 5,445,601 97.9% Underground Assessment District Construction 403 42,110 3,910 9.3% 3,378,665 1,797,136 317,043 62.6% Water Fund 501 15,586,832 13,589,196 87.2% 47,871,153 26,438,934 16,011,853 88.7% Stormwater Fund 502 369,889 330,530 89.4% 4,489,880 1,550,554 342,746 42.2% Wastewater Fund 503 3,604,073 3,197,796 88.7% 13,749,711 2,640,124 626,869 23.8% Parking Fund 520 3,730,433 4,562,148 122.3% 3,413,511 2,978,245 224,433 93.8% County Parking Lots Fund 521 1,263,000 1,339,593 106.1% 872,452 186,950 - 21.4% State Pier & Parking Lot Fund 522 894,383 918,040 102.6% 2,325,346 502,212 84,827 25.2% Insurance Reserve Fund 601 11,026,963 13,920,159 126.2% 10,957,853 10,578,966 42,451 96.9% Information Systems Reserve Fund 605 3,039,108 3,039,249 100.0% 3,947,575 2,846,395 483,522 84.4% Fleet Management Fund 610 2,363,382 2,256,861 95.5% 4,201,748 1,323,531 2,081,204 81.0% Building Maintenance & Operation Fund 615 2,104,412 1,628,747 77.4% 2,200,703 1,640,801 508,781 97.7% Special Assessment Debt Service 710 707,750 701,484 99.1% 708,900 708,650 - 100.0% Special Assessment UAD 19-12 19-14 Fund 711 614,943 675,437 109.8% 606,707 607,876 - 100.2% Special Assessment UAD 19-4 Fund 712 336,313 399,771 118.9% 336,163 336,579 - 100.1% City Pension Fund 801 197,697 (511) -0.3% 196,680 209,130 - 106.3% PARS Investment Trust 804 100,000 (217,518) -217.5% - - - - $168,389,267 $155,361,537 92.3% $226,633,929 $145,626,160 $35,908,497 64.3% Year-to-Date
As of June 30, 2022
Fiscal Year 2021-2022 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
100.0%
Fund Original Budget Adjusted Year-to-Date Unrealized % No. Budget Adjustments Budget Actuals Amount Realized
General Fund 100 $82,260,057 482,308 $82,742,365 $84,872,839 (2,130,474) 103% Street Lighting & Landscaping Fund 201 389,689 - 389,689 501,062 (111,373) 128.6% Gas Tax Fund 205 1,395,158 1,316,127 2,711,285 2,535,568 175,716 93.5% Asset Forfeiture 210 28,824 - 28,824 34,836 (6,012) 120.9% Police Safety Grants 211 159,192 - 159,192 161,255 (2,063) 101.3% Prop A Fund 230 737,244 - 737,244 897,675 (160,431) 121.8% Prop C Fund 231 634,279 13,770,724 14,405,003 5,570,562 8,834,442 38.7% AB 2766 Fund 232 46,641 - 46,641 34,182 12,459 73.3% Measure R 233 458,499 540,000 998,499 558,741 439,758 56.0% Measure M 234 2,309,690 3,640,000 5,949,690 1,594,037 4,355,653 26.8% Measure W 240 - 1,907,100 1,907,100 1,918,218 (11,118) 100.6% Capital Improvements Fund 401 2,919,601 942,846 3,862,447 1,554,061 2,308,386 40.2% Bond Construction Fund 402 - 8,470,000 8,470,000 8,783,609 (313,609) 103.7% Underground Assessment District Construction 403 42,110 - 42,110 3,910 38,200 9.3% Water Fund 501 15,586,832 - 15,586,832 13,589,196 1,997,636 87.2% Stormwater Fund 502 779,889 (410,000) 369,889 330,530 39,359 89.4% Wastewater Fund 503 3,604,073 - 3,604,073 3,197,796 406,277 88.7% Parking Fund 520 3,730,433 - 3,730,433 4,562,148 (831,715) 122.3% County Parking Lots Fund 521 1,263,000 - 1,263,000 1,339,593 (76,593) 106.1% State Pier & Parking Lot Fund 522 894,383 - 894,383 918,040 (23,657) 102.6% Insurance Reserve Fund 601 7,389,560 3,637,403 11,026,963 13,920,159 (2,893,196) 126.2% Information Systems Reserve Fund 605 3,039,108 - 3,039,108 3,039,249 (141) 100.0% Fleet Management Fund 610 2,363,382 - 2,363,382 2,256,861 106,521 95.5% Building Maintenance & Operation Fund 615 2,104,412 - 2,104,412 1,628,747 475,665 77.4% Special Assessment Debt Service 710 707,750 - 707,750 701,484 6,266 99.1% Special Assessment UAD 19-12 19-14 Fund 711 614,943 - 614,943 675,437 (60,494) 109.8% Special Assessment UAD 19-4 Fund 712 336,313 - 336,313 399,771 (63,458) 118.9% City Pension Fund 801 197,697 - 197,697 (511) 198,208 -0.3% PARS Investment Trust 804 100,000 - 100,000 (217,518) 317,518 -217.5% $134,092,759 $34,296,508 $168,389,267 $155,361,537 $13,027,730 92.3% City of Manhattan Beach
Fiscal Year 2021-2022 Citywide Revenues
As of June 30, 2022
Current Year Activity
% of Year
100.0%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $77,698,292 $1,599,788 $79,298,080 $77,098,648 $716,803 $1,482,628 98.1% Street Lighting & Landscaping Fund 201 570,702 77,539 648,241 554,750 53,774 39,716 93.9% Gas Tax Fund 205 2,098,738 1,768,256 3,866,994 1,383,168 1,098,517 1,385,309 64.2% Asset Forfeiture 210 108,500 27,747 136,247 84,668 27,747 23,832 82.5% Police Safety Grants 211 155,000 39,408 194,408 65,013 99,945 29,450 84.9% Prop A Fund 230 932,081 11,894 943,975 628,594 7,717 307,665 67.4% Prop C Fund 231 192,332 13,425,245 13,617,577 4,413,299 2,311,767 6,892,511 49.4% AB 2766 Fund 232 673 - 673 672 - 1 99.9% Measure R 233 263,738 1,780,617 2,044,355 160,348 177,973 1,706,034 16.5% Measure M 234 2,413,738 4,422,128 6,835,866 947,761 435,792 5,452,313 20.2% Measure W 240 - 1,497,100 1,497,100 17,103 1,218,948 261,050 - Capital Improvements Fund 401 4,103,784 5,719,584 9,823,368 3,075,858 3,590,183 3,157,327 67.9% Bond Construction Fund 402 - 8,470,000 8,470,000 2,850,196 5,445,601 174,204 97.9% Underground Assessment District Construction 403 1,779,705 1,598,960 3,378,665 1,797,136 317,043 1,264,485 62.6% Water Fund 501 15,551,079 32,320,074 47,871,153 26,438,934 16,011,853 5,420,366 88.7% Stormwater Fund 502 1,787,478 2,702,402 4,489,880 1,550,554 342,746 2,596,580 42.2% Wastewater Fund 503 3,045,862 10,703,849 13,749,711 2,640,124 626,869 10,482,718 23.8% Parking Fund 520 2,933,472 480,039 3,413,511 2,978,245 224,433 210,832 93.8% County Parking Lots Fund 521 872,452 - 872,452 186,950 - 685,502 21.4% State Pier & Parking Lot Fund 522 2,160,254 165,092 2,325,346 502,212 84,827 1,738,307 25.2% Insurance Reserve Fund 601 7,179,370 3,778,483 10,957,853 10,578,966 42,451 336,436 96.9% Information Systems Reserve Fund 605 3,520,830 426,745 3,947,575 2,846,395 483,522 617,658 84.4% Fleet Management Fund 610 4,056,296 145,452 4,201,748 1,323,531 2,081,204 797,013 81.0% Building Maintenance & Operation Fund 615 2,097,330 103,373 2,200,703 1,640,801 508,781 51,121 97.7% Special Assessment Debt Service 710 708,900 - 708,900 708,650 - 250 100.0% Special Assessment UAD 19-12 19-14 Fund 711 606,707 - 606,707 607,876 - (1,169) 100.2% Special Assessment UAD 19-4 Fund 712 336,163 - 336,163 336,579 - (416) 100.1% City Pension Fund 801 196,680 - 196,680 209,130 - (12,450) 106.3% PARS Investment Trust 804 - - - - - - - $135,370,156 $91,263,773 $226,633,929 $145,626,160 $35,908,497 $45,099,272 80.1% *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 2021-2022 Citywide Expenditures
As of June 30, 2022
Current Year Activity
3 4 5 6 7
City of Manhattan Beach Percent of Year
100.0%
Fund
Major Revenue Accounts No. 2017 2018 2019 2020 2021 2022 Adj Budget Realized Property Taxes 100 27,398,256 29,300,348 31,448,387 33,319,571 36,823,265 36,896,462 38,049,313 97.0% Sales & Use Tax 100 9,005,517 8,874,799 9,212,806 8,797,241 8,038,137 10,186,403 9,260,000 110.0% Franchise Tax (a) 100 1,268,064 1,256,226 1,168,793 1,175,490 1,189,086 1,221,477 1,135,000 107.6% Hotel Tax 100 4,436,206 3,766,448 4,372,444 3,852,539 2,382,137 5,691,238 4,025,000 141.4% Business License Tax 100 3,658,194 3,718,418 4,053,020 3,643,611 3,755,555 5,066,506 3,600,000 140.7% Real Estate Transfer Tax 100 716,888 791,201 824,402 827,475 1,132,663 1,258,518 810,000 155.4% Building Permits 100 1,620,362 2,118,129 1,929,097 1,601,914 1,433,778 1,944,720 1,532,712 126.9% Parking Citations 100 2,331,181 2,241,452 1,803,259 1,538,218 1,354,932 2,135,538 1,875,000 113.9% Interest Earnings 100 570,677 667,922 842,465 928,038 454,133 499,589 637,522 78.4% Marriott Hotel Rent 100 1,662,914 1,113,434 1,760,444 1,575,943 898,530 1,509,966 1,350,000 111.8% Vehicle in Lieu 100 15,812 18,680 17,276 28,431 - 40,590 17,000 238.8% Building Plan Check Fees 100 1,893,390 1,807,117 1,775,015 1,418,857 1,986,711 2,169,213 1,755,000 123.6% Total Major Revenue Accounts 54,577,462 55,674,175 59,207,409 58,707,325 59,448,928 68,620,218 64,046,547 107.1% Over/(Under) Prior Year 1,096,713 3,533,234 (500,084) 741,603 9,171,290 Percent Change From Prior Year 2.0% 6.3% (0.8%) 1.3% 15.4% Other Revenues 17,559,750 16,016,874 17,223,328 13,207,006 103,641,135 16,252,621 18,695,818 86.9% Total General Fund Revenues 72,137,212 71,691,049 76,430,737 71,914,331 163,090,063 84,872,839 82,742,365 102.6%
(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 2021-2022 General Fund Major Revenue Trends June 30, 2022
Year-To-Date Actuals FY 2022
$0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,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
June 30, 2022
Fiscal Year 2021-22
Fiscal Year 2020-21
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
100.0%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through June Year-Over-Year
$0
$2,500,000
$5,000,000
$7,500,000
$10,000,000
$12,500,000
2017 2018 2019 2020 2021 2022
Sales & Use Tax
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
2017 2018 2019 2020 2021 2022
Franchise Tax
$0
$8,000,000
$16,000,000
$24,000,000
$32,000,000
$40,000,000
2017 2018 2019 2020 2021 2022
Property Taxes
$0
$1,500,000
$3,000,000
$4,500,000
$6,000,000
2017 2018 2019 2020 2021 2022
Hotel Tax
$0
$1,100,000
$2,200,000
$3,300,000
$4,400,000
$5,500,000
2017 2018 2019 2020 2021 2022
Business License Tax
$0
$250,000
$500,000
$750,000
$1,000,000
$1,250,000
$1,500,000
2017 2018 2019 2020 2021 2022
Real Estate Transfer Tax
$0
$550,000
$1,100,000
$1,650,000
$2,200,000
2017 2018 2019 2020 2021 2022
Building Permits
$0
$600,000
$1,200,000
$1,800,000
$2,400,000
2017 2018 2019 2020 2021 2022
Parking Citations
$0
$250,000
$500,000
$750,000
$1,000,000
$1,250,000
2017 2018 2019 2020 2021 2022
Interest Earnings
$0
$600,000
$1,200,000
$1,800,000
2017 2018 2019 2020 2021 2022
Marriott Hotel Rent
$0
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
2017 2018 2019 2020 2021 2022
Building Plan Check Fees