City of Manhattan Beach
Month End Report
November 30, 2021
Fiscal Year 2021-2022
% of Year
41.7%
Dept Original Budget Adjusted YTD YTD Available %
No. Budget Adjustments1 Budget Expenditures Encumbrances Budget Used Management Services 11 $3,599,705 $189,112 $3,788,817 $1,311,037 $437,344 $2,040,437 46.1% Finance 12 3,607,149 99,849 3,706,998 1,253,518 139,836 2,313,644 37.6% Human Resources 13 1,416,358 123,169 1,539,527 547,358 86,119 906,049 41.1% Parks and Recreation 14 8,417,571 24,327 8,441,898 3,123,149 54,296 5,264,453 37.6% Police 15 30,667,807 190,779 30,858,586 10,240,035 16,739 20,601,812 33.2% Fire 16 15,471,419 17,430 15,488,849 5,711,926 26,632 9,750,291 37.0% Community Development 17 5,908,891 190,517 6,099,408 1,982,190 162,485 3,954,733 35.2% Public Works 18 8,609,392 268,631 8,878,023 3,083,333 221,634 5,573,056 37.2% Information Technology 19 - - - - - - n/a $77,698,292 $1,103,815 $78,802,107 $27, 252,546 $1,145,084 $50,404,477 36.0% ¹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 November 30, 2021
Current Year Activity
% of Year
41.7%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $82,376,365 $19,224,562 23.3% $41,257,850 $13,366,893 $1,145,084 35.2% Street Lighting & Landscaping Fund 201 389,689 6,462 1.7% 578,252 196,971 7,550 35.4% Gas Tax Fund 205 1,395,158 677,198 48.5% 3,396,740 693,314 612,210 38.4% Asset Forfeiture 210 28,824 3,725 12.9% 136,247 25,908 27,747 39.4% Police Safety Grants 211 159,192 105,400 66.2% 194,408 26,890 13,368 20.7% Prop A Fund 230 737,244 366,165 49.7% 743,685 164,940 11,894 23.8% Prop C Fund 231 634,279 218,073 34.4% 5,827,757 1,516,528 4,363,603 100.9% AB 2766 Fund 232 46,641 (574) -1.2% 673 280 - 41.6% Measure R 233 458,499 169,965 37.1% 409,172 35,684 123,487 38.9% Measure M 234 2,309,690 309,061 13.4% 3,637,544 408,685 828,859 34.0% Capital Improvements Fund 401 2,919,601 797,321 27.3% 5,966,202 167,698 2,245,639 40.5% Bond Construction Fund 402 8,470,000 8,725,894 103.0% 8,470,000 234,791 823,503 12.5% Underground Assessment District Construction 403 42,110 (17,649) -41.9% 3,378,665 945,496 991,119 57.3% Water Fund 501 15,586,832 7,141,674 45.8% 43,983,508 7,245,775 26,373,972 76.4% Stormwater Fund 502 779,889 (7,124) -0.9% 2,465,988 588,552 414,599 40.7% Wastewater Fund 503 3,604,073 1,478,207 41.0% 3,996,944 859,372 977,707 46.0% Parking Fund 520 3,730,433 2,007,354 53.8% 3,052,054 727,844 262,336 32.4% County Parking Lots Fund 521 1,263,000 622,747 49.3% 837,064 65,761 - 7.9% State Pier & Parking Lot Fund 522 894,383 381,965 42.7% 2,201,576 183,446 45,936 10.4% Insurance Reserve Fund 601 7,389,560 3,013,675 40.8% 6,753,567 6,681,470 178,280 101.6% Information Systems Reserve Fund 605 3,039,108 1,266,300 41.7% 2,678,853 625,973 486,916 41.5% Fleet Management Fund 610 2,363,382 900,946 38.1% 3,804,679 352,351 583,647 24.6% Building Maintenance & Operation Fund 615 2,104,412 552,394 26.2% 1,675,522 332,693 150,158 28.8% Special Assessment Debt Service 710 707,750 22,377 3.2% 708,900 663,025 - 93.5% Special Assessment UAD 19-12 19-14 Fund 711 614,943 101,398 16.5% 606,707 494,823 - 81.6% Special Assessment UAD 19-4 Fund 712 336,313 79,627 23.7% 336,163 278,073 - 82.7% City Pension Fund 801 197,697 (511) -0.3% - - - - PARS Investment Trust 804 100,000 (1,464) -1.5% - - - - $142,679,067 $48,145,166 33.7% $147,098,721 $36,883,238 $40,667,614 25.1% Year-to-Date
As of November 30, 2021
Fiscal Year 2021-2022 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
% of Year
41.7%
Fund Original Budget Adjusted Year-to-Date Unrealized % No. Budget Adjustments Budget Actuals Amount Realized
General Fund 100 $82,260,057 116,308 $82,376,365 $19,224,562 63,151,803 23% Street Lighting & Landscaping Fund 201 389,689 - 389,689 6,462 383,227 1.7% Gas Tax Fund 205 1,395,158 - 1,395,158 677,198 717,960 48.5% Asset Forfeiture 210 28,824 - 28,824 3,725 25,099 12.9% Police Safety Grants 211 159,192 - 159,192 105,400 53,792 66.2% Prop A Fund 230 737,244 - 737,244 366,165 371,079 49.7% Prop C Fund 231 634,279 - 634,279 218,073 416,206 34.4% AB 2766 Fund 232 46,641 - 46,641 (574) 47,215 -1.2% Measure R 233 458,499 - 458,499 169,965 288,534 37.1% Measure M 234 2,309,690 - 2,309,690 309,061 2,000,629 13.4% Capital Improvements Fund 401 2,919,601 - 2,919,601 797,321 2,122,280 27.3% Bond Construction Fund 402 - 8,470,000 8,470,000 8,725,894 (255,894) 103.0% Underground Assessment District Construction 403 42,110 - 42,110 (17,649) 59,759 -41.9% Water Fund 501 15,586,832 - 15,586,832 7,141,674 8,445,158 45.8% Stormwater Fund 502 779,889 - 779,889 (7,124) 787,013 -0.9% Wastewater Fund 503 3,604,073 - 3,604,073 1,478,207 2,125,866 41.0% Parking Fund 520 3,730,433 - 3,730,433 2,007,354 1,723,079 53.8% County Parking Lots Fund 521 1,263,000 - 1,263,000 622,747 640,254 49.3% State Pier & Parking Lot Fund 522 894,383 - 894,383 381,965 512,418 42.7% Insurance Reserve Fund 601 7,389,560 - 7,389,560 3,013,675 4,375,885 40.8% Information Systems Reserve Fund 605 3,039,108 - 3,039,108 1,266,300 1,772,808 41.7% Fleet Management Fund 610 2,363,382 - 2,363,382 900,946 1,462,436 38.1% Building Maintenance & Operation Fund 615 2,104,412 - 2,104,412 552,394 1,552,018 26.2% Special Assessment Debt Service 710 707,750 - 707,750 22,377 685,373 3.2% Special Assessment UAD 19-12 19-14 Fund 711 614,943 - 614,943 101,398 513,545 16.5% Special Assessment UAD 19-4 Fund 712 336,313 - 336,313 79,627 256,686 23.7% City Pension Fund 801 197,697 - 197,697 (511) 198,208 -0.3% PARS Investment Trust 804 100,000 - 100,000 (1,464) 101,464 -1.5% $134,092,759 $8,586,308 $142,679,067 $48,145,166 $94,533,901 33.7% City of Manhattan Beach
Fiscal Year 2021-2022 Citywide Revenues
As of November 30, 2021
Current Year Activity
% of Year
41.7%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $40,154,035 $1,103,815 $41,257,850 $13,366,893 $1,145,084 $26,745,873 35.2% Street Lighting & Landscaping Fund 201 570,702 7,550 578,252 196,971 7,550 373,731 35.4% Gas Tax Fund 205 2,098,738 1,298,002 3,396,740 693,314 612,210 2,091,216 38.4% Asset Forfeiture 210 108,500 27,747 136,247 25,908 27,747 82,592 39.4% Police Safety Grants 211 155,000 39,408 194,408 26,890 13,368 154,149 20.7% Prop A Fund 230 731,791 11,894 743,685 164,940 11,894 566,851 23.8% Prop C Fund 231 192,332 5,635,425 5,827,757 1,516,528 4,363,603 (52,374) 100.9% AB 2766 Fund 232 673 - 673 280 - 393 41.6% Measure R 233 263,738 145,434 409,172 35,684 123,487 250,000 38.9% Measure M 234 2,413,738 1,223,806 3,637,544 408,685 828,859 2,400,000 34.0% Capital Improvements Fund 401 4,103,784 1,862,418 5,966,202 167,698 2,245,639 3,552,865 40.5% Bond Construction Fund 402 - 8,470,000 8,470,000 234,791 823,503 7,411,706 12.5% Underground Assessment District Construction 403 1,779,705 1,598,960 3,378,665 945,496 991,119 1,442,050 - Water Fund 501 14,476,419 29,507,089 43,983,508 7,245,775 26,373,972 10,363,761 76.4% Stormwater Fund 502 1,681,576 784,412 2,465,988 588,552 414,599 1,462,837 40.7% Wastewater Fund 503 2,636,995 1,359,949 3,996,944 859,372 977,707 2,159,865 46.0% Parking Fund 520 2,800,332 251,722 3,052,054 727,844 262,336 2,061,874 32.4% County Parking Lots Fund 521 837,064 - 837,064 65,761 - 771,303 7.9% State Pier & Parking Lot Fund 522 2,124,868 76,708 2,201,576 183,446 45,936 1,972,195 10.4% Insurance Reserve Fund 601 6,725,084 28,483 6,753,567 6,681,470 178,280 (106,183) 101.6% Information Systems Reserve Fund 605 2,230,164 448,689 2,678,853 625,973 486,916 1,565,964 41.5% Fleet Management Fund 610 3,657,982 146,697 3,804,679 352,351 583,647 2,868,681 24.6% Building Maintenance & Operation Fund 615 1,570,484 105,038 1,675,522 332,693 150,158 1,192,671 28.8% Special Assessment Debt Service 710 708,900 - 708,900 663,025 - 45,875 93.5% Special Assessment UAD 19-12 19-14 Fund 711 606,707 - 606,707 494,823 - 111,884 81.6% Special Assessment UAD 19-4 Fund 712 336,163 - 336,163 278,073 - 58,090 82.7% City Pension Fund 801 - - - - - - - PARS Investment Trust 804 - - - - - - - $92,965,474 $54,133,247 $147,098,721 $36,883,238 $40,667,614 $69,547,869 52.7% *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 November 30, 2021
Current Year Activity
3 4 5 6 7
City of Manhattan Beach Percent of Year
41.7%
Fund
Major Revenue Accounts No. 2017 2018 2019 2020 2021 2022 Adj Budget Realized Property Taxes 100 1,047,948 1,108,623 1,180,089 1,293,478 1,369,646 1,295,740 38,459,313 3.4% Sales & Use Tax 100 3,629,106 3,778,091 3,801,368 4,041,448 3,294,389 4,311,560 9,260,000 46.6% Franchise Tax (a) 100 344,576 324,281 326,909 316,483 299,254 289,135 1,135,000 25.5% Hotel Tax 100 2,062,509 1,750,697 1,906,547 2,192,832 915,719 2,109,006 4,722,059 44.7% Business License Tax 100 240,414 253,432 377,112 436,630 691,497 989,699 3,600,000 27.5% Real Estate Transfer Tax 100 290,192 374,591 415,056 466,293 339,188 663,510 810,000 81.9% Building Permits 100 663,117 794,408 722,003 702,786 621,607 639,924 1,532,712 41.8% Parking Citations 100 1,223,163 1,052,148 934,035 863,258 701,140 891,113 1,955,000 45.6% Interest Earnings 100 252,288 344,380 440,580 555,322 470,235 315,894 1,362,170 23.2% Marriott Hotel Rent 100 836,639 698,053 806,420 987,326 443,005 636,865 (550,000) -115.8% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 487,762 858,867 827,131 732,195 840,706 781,471 1,755,000 44.5% Total Major Revenue Accounts 11,077,715 11,337,572 11,737,250 12,588,051 9,986,387 12,923,917 64,058,254 20.2% Over/(Under) Prior Year 259,857 399,678 850,802 (2,601,664) 2,937,530 Percent Change From Prior Year 2.3% 3.5% 7.2% (20.7%) 29.4% Other Revenues 6,068,040 6,557,028 8,229,100 6,627,225 5,840,017 6,300,645 18,318,111 34.4% Total General Fund Revenues 17,145,755 17,894,599 19,966,350 19,215,276 15,826,404 19,224,562 82,376,365 23.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.
Fiscal Year 2021-2022 General Fund Major Revenue Trends November 30, 2021
Year-To-Date Actuals FY 2022
$0 $500,000 $1,000,000$1,500,000$2,000,000$2,500,000$3,000,000$3,500,000$4,000,000$4,500,000$5,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
November 30, 2021
Fiscal Year 2021-22
Fiscal Year 2020-21
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
41.7%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through September 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
2017 2018 2019 2020 2021 2022
Hotel Tax
$0
$1,100,000
$2,200,000
$3,300,000
$4,400,000
2017 2018 2019 2020 2021 2022
Business License Tax
$0
$250,000
$500,000
$750,000
$1,000,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
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