City of Manhattan Beach
Month End Report
May 31, 2022
Fiscal Year 2021-2022
% of Year
91.7%
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,184,387 $211,226 $871,927 79.6% Finance 12 3,607,149 54,297 3,661,446 3,156,099 36,678 468,669 87.2% Human Resources 13 1,416,358 267,511 1,683,869 1,355,252 71,291 257,325 84.7% Parks and Recreation 14 8,417,571 24,296 8,441,867 7,343,173 100,975 997,720 88.2% Police 15 30,667,807 190,717 30,858,524 26,273,786 13,539 4,571,199 85.2% Fire 16 15,471,419 17,403 15,488,822 13,971,548 22,672 1,494,603 90.4% Community Development 17 5,908,891 305,381 6,214,272 5,325,697 92,739 795,836 87.2% Public Works 18 8,609,392 78,023 8,687,415 7,550,286 112,755 1,024,374 88.2% Information Technology 19 - - - - - - - $77,698,292 $1,605,464 $79,303,756 $68, 160,229 $661,875 $10,481,652 86.8% ¹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 2021-2022 General Fund Expenditures by Department As of May 31, 2022
Current Year Activity
% of Year
91.7%
Adjusted Adjusted
Fund Budge t YTD % Budge t %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrance s Utilized General Fund 100 $82,742,365 $80,780,220 97.6% $79,303,756 $68,160,229 $661,875 86.8% Street Lighting & Landscaping Fund 201 389,689 500,982 128.6% 648,241 483,700 64,345 84.5% Gas Tax Fund 205 2,711,285 2,357,467 87.0% 3,866,994 1,368,251 215,044 40.9% Asset Forfeiture 210 28,824 23,236 80.6% 136,247 72,040 27,747 73.2% Police Safety Grants 211 159,192 160,650 100.9% 194,408 65,013 50,945 59.6% Prop A Fund 230 737,244 820,552 111.3% 943,975 553,612 7,717 59.5% Prop C Fund 231 14,405,003 4,955,065 34.4% 13,617,577 4,390,696 2,303,163 49.2% AB 2766 Fund 232 46,641 22,599 48.5% 673 616 - 91.5% Measure R 233 998,499 508,375 50.9% 2,044,355 160,348 177,973 16.5% Measure M 234 5,949,690 1,250,169 21.0% 6,835,866 947,761 435,792 20.2% Measure W 240 1,907,100 1,915,568 100.4% 1,497,100 17,103 (17,103) 0.0% Capital Improvements Fund 401 3,862,447 1,415,417 36.6% 9,823,368 2,474,401 2,479,845 50.4% Bond Construction Fund 402 8,470,000 8,774,780 103.6% 8,470,000 2,407,167 5,887,921 97.9% Underground Assessment District Construction 403 42,110 265 0.6% 3,378,665 1,782,519 306,448 61.8% Water Fund 501 15,586,832 12,855,013 82.5% 47,871,153 24,525,242 15,889,511 84.4% Stormwater Fund 502 369,889 329,935 89.2% 4,489,880 1,426,001 422,626 41.2% Wastewater Fund 503 3,604,073 2,974,700 82.5% 13,749,711 2,481,997 445,966 21.3% Parking Fund 520 3,730,433 4,067,407 109.0% 3,413,511 2,445,307 192,336 77.3% County Parking Lots Fund 521 1,263,000 1,198,589 94.9% 872,452 177,134 - 20.3% State Pier & Parking Lot Fund 522 894,383 818,159 91.5% 2,325,346 473,812 18,557 21.2% Insurance Reserve Fund 601 11,026,963 13,326,562 120.9% 10,957,853 10,352,511 68,003 95.1% Information Systems Reserve Fund 605 3,039,108 2,785,860 91.7% 3,960,092 2,546,909 485,160 76.6% Fleet Management Fund 610 2,363,382 2,063,257 87.3% 4,201,748 1,218,060 2,081,204 78.5% Building Maintenance & Operation Fund 615 2,104,412 1,458,274 69.3% 2,200,703 1,472,527 482,514 88.8% Special Assessment Debt Service 710 707,750 701,412 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 186,278 - 94.7% PARS Investment Trust 804 100,000 (152,632) -152.6% - - - - $168,389,267 $146,986,576 87.3% $226,652, 122 $131,842,340 $32,687,589 58.2% Year-to-Date
As of May 31, 2022
Fiscal Year 2021-2022 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
91.7%
Fund Original Budge t Adjusted Year-to-Date Unrealized % No. Budge t Adjustments Budge t Actuals Amoun t Realized General Fund 100 $82,260,057 482,308 $82,742,365 $80,780,220 1,962,145 98% Street Lighting & Landscaping Fund 201 389,689 - 389,689 500,982 (111,293) 128.6% Gas Tax Fund 205 1,395,158 1,316,127 2,711,285 2,357,467 353,818 87.0% Asset Forfeiture 210 28,824 - 28,824 23,236 5,588 80.6% Police Safety Grants 211 159,192 - 159,192 160,650 (1,458) 100.9% Prop A Fund 230 737,244 - 737,244 820,552 (83,308) 111.3% Prop C Fund 231 634,279 13,770,724 14,405,003 4,955,065 9,449,938 34.4% AB 2766 Fund 232 46,641 - 46,641 22,599 24,042 48.5% Measure R 233 458,499 540,000 998,499 508,375 490,124 50.9% Measure M 234 2,309,690 3,640,000 5,949,690 1,250,169 4,699,521 21.0% Measure W 240 - 1,907,100 1,907,100 1,915,568 (8,468) 100.4% Capital Improvements Fund 401 2,919,601 942,846 3,862,447 1,415,417 2,447,030 36.6% Bond Construction Fund 402 - 8,470,000 8,470,000 8,774,780 (304,780) 103.6% Underground Assessment District Construction 403 42,110 - 42,110 265 41,845 0.6% Water Fund 501 15,586,832 - 15,586,832 12,855,013 2,731,819 82.5% Stormwater Fund 502 779,889 (410,000) 369,889 329,935 39,954 89.2% Wastewater Fund 503 3,604,073 - 3,604,073 2,974,700 629,373 82.5% Parking Fund 520 3,730,433 - 3,730,433 4,067,407 (336,974) 109.0% County Parking Lots Fund 521 1,263,000 - 1,263,000 1,198,589 64,411 94.9% State Pier & Parking Lot Fund 522 894,383 - 894,383 818,159 76,224 91.5% Insurance Reserve Fund 601 7,389,560 3,637,403 11,026,963 13,326,562 (2,299,599) 120.9% Information Systems Reserve Fund 605 3,039,108 - 3,039,108 2,785,860 253,248 91.7% Fleet Management Fund 610 2,363,382 - 2,363,382 2,063,257 300,125 87.3% Building Maintenance & Operation Fund 615 2,104,412 - 2,104,412 1,458,274 646,138 69.3% Special Assessment Debt Service 710 707,750 - 707,750 701,412 6,338 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 (152,632) 252,632 -152.6% $134,092,759 $34,296,508 $168,389,267 $146,986,576 $21,402,691 87.3% City of Manhattan Beach
Fiscal Year 2021-2022 Citywide Revenues
As of May 31, 2022
Current Year Activity
% of Year
91.7%
Fund Original Budge t Adjusted Available %
No. Budge t Adjustments* Budge t Actuals Encumbrances Budge t Utilized General Fund 100 $77,698,292 $1,605,464 $79,303,756 $68,160,229 $661,875 $10,481,652 86.8% Street Lighting & Landscaping Fund 201 570,702 77,539 648,241 483,700 64,345 100,195 84.5% Gas Tax Fund 205 2,098,738 1,768,256 3,866,994 1,368,251 215,044 2,283,699 40.9% Asset Forfeiture 210 108,500 27,747 136,247 72,040 27,747 36,460 73.2% Police Safety Grants 211 155,000 39,408 194,408 65,013 50,945 78,450 59.6% Prop A Fund 230 932,081 11,894 943,975 553,612 7,717 382,646 59.5% Prop C Fund 231 192,332 13,425,245 13,617,577 4,390,696 2,303,163 6,923,718 49.2% AB 2766 Fund 232 673 - 673 616 - 57 91.5% 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 (17,103) 1,497,100 - Capital Improvements Fund 401 4,103,784 5,719,584 9,823,368 2,474,401 2,479,845 4,869,122 50.4% Bond Construction Fund 402 - 8,470,000 8,470,000 2,407,167 5,887,921 174,913 97.9% Underground Assessment District Construction 403 1,779,705 1,598,960 3,378,665 1,782,519 306,448 1,289,697 61.8% Water Fund 501 15,551,079 32,320,074 47,871,153 24,525,242 15,889,511 7,456,399 84.4% Stormwater Fund 502 1,787,478 2,702,402 4,489,880 1,426,001 422,626 2,641,253 41.2% Wastewater Fund 503 3,045,862 10,703,849 13,749,711 2,481,997 445,966 10,821,748 21.3% Parking Fund 520 2,933,472 480,039 3,413,511 2,445,307 192,336 775,867 77.3% County Parking Lots Fund 521 872,452 - 872,452 177,134 - 695,318 20.3% State Pier & Parking Lot Fund 522 2,160,254 165,092 2,325,346 473,812 18,557 1,832,976 21.2% Insurance Reserve Fund 601 7,179,370 3,778,483 10,957,853 10,352,511 68,003 537,339 95.1% Information Systems Reserve Fund 605 3,520,830 439,262 3,960,092 2,546,909 485,160 928,024 76.6% Fleet Management Fund 610 4,056,296 145,452 4,201,748 1,218,060 2,081,204 902,483 78.5% Building Maintenance & Operation Fund 615 2,097,330 103,373 2,200,703 1,472,527 482,514 245,663 88.8% 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 186,278 - 10,402 94.7% PARS Investment Trust 804 - - - - - - - $135,370,156 $91,281,966 $226,652,122 $131,842,340 $32,687,589 $62,122,193 72.6% *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 May 31, 2022
Current Year Activity
34567
City of Manhattan Beach Percent of Year
91.7%
Fund
Major Revenue Accounts No. 2017 2018 2019 2020 2021 2022 Adj Budget Realized Property Taxes 100 27,345,688 29,223,746 31,356,382 31,983,209 35,875,913 36,789,619 38,049,313 96.7% Sales & Use Tax 100 8,179,957 8,222,078 8,493,809 8,243,266 7,210,806 9,457,392 9,260,000 102.1% Franchise Tax (a) 100 1,268,064 1,256,226 1,168,793 1,175,490 1,115,583 1,221,477 1,135,000 107.6% Hotel Tax 100 4,059,721 3,398,166 3,993,943 3,765,739 1,845,902 5,164,154 4,025,000 128.3% Business License Tax 100 3,558,189 3,602,915 3,984,673 3,212,405 2,887,121 4,899,419 3,600,000 136.1% Real Estate Transfer Tax 100 623,655 708,590 751,942 797,147 957,017 1,066,884 810,000 131.7% Building Permits 100 1,452,788 1,896,056 1,783,264 1,521,018 1,354,991 1,791,087 1,532,712 116.9% Parking Citations 100 2,201,847 2,122,518 1,799,840 1,585,726 1,291,462 1,906,996 1,875,000 101.7% Interest Earnings 100 519,119 630,339 847,165 1,017,036 759,123 522,368 637,522 81.9% Marriott Hotel Rent 100 1,629,580 1,080,101 1,727,111 1,542,610 701,995 1,476,632 1,350,000 109.4% Vehicle in Lieu 100 15,812 18,680 17,276 28,431 - 40,590 17,000 238.8% Building Plan Check Fees 100 1,692,921 1,683,771 1,644,583 1,362,522 1,818,641 1,955,224 1,755,000 111.4% Total Major Revenue Accounts 52,547,343 53,843,187 57,568,781 56,234,598 55,818,553 66,291,843 64,046,547 103.5% Over/(Under) Prior Year 1,295,844 3,725,595 (1,334,184) (416,045) 10,473,290 Percent Change From Prior Year 2.5% 6.9% (2.3%) (0.7%) 18.8% Other Revenues 14,317,099 14,656,585 15,995,430 12,824,854 97,010,019 4,079,851 18,695,818 21.8% Total General Fund Revenues 66,864,442 68,499,772 73,564,212 69,059,452 152,828,571 70,371,694 82,742,365 85.0%
(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 May 31, 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
May 31, 2022
Fiscal Year 2021-22
Fiscal Year 2020-21
General Fund Major Revenue Sources
34567
Percent of Year
91.7%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through May Year-Over-Year
$0
$2,500,000
$5,000,000
$7,500,000
$10,000,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
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
2017 2018 2019 2020 2021 2022
Building Plan Check Fees