City of Manhattan Beach
Finance Department
Preliminary Month End Report
July 31, 2022
Fiscal Year 2021-2022
% of Year
8.3%
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 $224,666 $414,485 $3,719,872 14.7% Finance 12 3,819,223 - 3,819,223 238,287 115,232 3,465,704 9.3% Human Resources 13 1,622,969 - 1,622,969 142,827 26,500 1,453,642 10.4% Parks and Recreation 14 9,131,405 - 9,131,405 601,150 30,000 8,500,255 6.9% Police 15 33,631,799 - 33,631,799 2,112,999 65,922 31,452,878 6.5% Fire 16 15,286,191 - 15,286,191 1,011,214 - 14,274,977 6.6% Community Development 17 6,782,954 - 6,782,954 420,236 3,282 6,359,436 6.2% Public Works 18 10,641,587 - 10,641,587 422,753 7,681 10,211,153 4.0% Information Technology 19 - - - - - - - $85,275,151 $0 $85,275,151 $5,174,133 $663,102 $79,437,916 6.8% ¹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 July 31, 2022
Current Year Activity
% of Year
8.3%
Adjusted Adjusted
Fund Budget YTD % Budget %
No. Revenues Revenues Realized Expenditures Expenditures Encumbrances Utilized General Fund 100 $86,669,227 $7,270,165 8.4% $85,275,151 $5,174,133 $663,102 6.8% Street Lighting & Landscaping Fund 201 390,822 43 0.0% 612,022 22,766 7,550 5.0% Gas Tax Fund 205 1,798,763 134,186 7.5% 1,575,138 6,464 9,718 1.0% Asset Forfeiture 210 41,800 1,859 4.4% 107,750 5,057 - 4.7% Police Safety Grants 211 159,000 620 0.4% 155,000 - - 0.0% Prop A Fund 230 883,003 92,622 10.5% 780,646 46,596 - 6.0% Prop C Fund 231 712,451 78,640 11.0% 1,260,138 7,684 253,547 20.7% AB 2766 Fund 232 47,500 252 0.5% 673 56 - 8.3% Measure R 233 547,088 59,617 10.9% 760,138 4,161 - 0.5% Measure M 234 5,921,033 66,605 1.1% 5,870,138 5,069 - 0.1% Measure W 240 1,611,500 2,744 0.2% 1,200,000 - - 0.0% Capital Improvements Fund 401 1,605,438 104,144 6.5% 6,442,589 19,479 324,335 5.3% Bond Construction Fund 402 - 8,459 n/a - - 4,901,031 n/a Underground Assessment District Construction 403 - 3,773 n/a 1,285,750 9,445 - 0.7% Water Fund 501 16,472,500 1,681,650 10.2% 13,304,706 1,006,352 1,008,468 15.1% Stormwater Fund 502 344,484 1,197 0.3% 1,836,564 25,161 - 1.4% Wastewater Fund 503 3,628,000 361,454 10.0% 4,710,392 110,465 654,139 16.2% Parking Fund 520 3,983,200 439,331 11.0% 2,698,608 105,745 - 3.9% County Parking Lots Fund 521 1,363,000 163,707 12.0% 953,214 5,931 - 0.6% State Pier & Parking Lot Fund 522 833,500 102,954 12.4% 737,458 24,662 - 3.3% Insurance Reserve Fund 601 7,549,860 579,183 7.7% 8,243,352 4,410,052 251,680 56.6% Information Systems Reserve Fund 605 3,698,533 308,214 8.3% 4,276,387 398,069 234,714 14.8% Fleet Management Fund 610 2,772,827 165,553 6.0% 2,490,440 78,552 32,181 4.4% Building Maintenance & Operation Fund 615 2,195,831 120,737 5.5% 2,195,831 115,914 34,188 6.8% Special Assessment Debt Service 710 714,150 231 0.0% 700,450 - - 0.0% Special Assessment UAD 19-12 19-14 Fund 711 606,106 3,736 0.6% 609,007 - - 0.0% Special Assessment UAD 19-4 Fund 712 337,613 111 0.0% 341,813 - - 0.0% City Pension Fund 801 264,480 - 0.0% 196,680 16,472 - 8.4% PARS Investment Trust 804 50,000 57,657 115.3% - - - - $145,201,709 $11,809,446 8.1% $148,620,035 $11,598,285 $8,374,653 7.8% Year-to-Date
As of July 31, 2022
Fiscal Year 2022-2023 Statement of Revenues & Expenditures City of Manhattan Beach
Current Year Activity
3 4 5 6 7
City of Manhattan Beach Percent of Year
8.3%
Fund
Major Revenue Accounts No. 2018 2019 2020 2021 2022 2023 Adj Budget Realized Property Taxes 100 - - - - - - 38,049,313 0.0% Sales & Use Tax 100 606,900 807,489 796,068 808,170 810,878 903,609 9,260,000 9.8% Franchise Tax (a) 100 - - - - - - 1,135,000 0.0% Hotel Tax 100 369,936 368,172 428,140 149,656 424,420 374,609 4,025,000 9.3% Business License Tax 100 50,224 94,379 125,814 309,824 590,778 185,688 3,600,000 5.2% Real Estate Transfer Tax 100 86,207 83,209 42,322 - 99,788 - 810,000 0.0% Building Permits 100 162,910 103,762 211,387 192,218 118,802 170,529 1,532,712 11.1% Parking Citations 100 237,001 208,631 161,563 121,490 195,593 289,815 1,875,000 15.5% Interest Earnings 100 92,151 95,297 269,085 (30,364) 63,707 (24,827) 637,522 -3.9% Marriott Hotel Rent 100 361,611 33,333 423,467 33,333 196,535 33,333 1,350,000 2.5% Vehicle in Lieu 100 - - - - - - 17,000 0.0% Building Plan Check Fees 100 235,673 171,379 189,865 242,439 131,989 179,695 1,755,000 10.2% Total Major Revenue Accounts 2,202,612 1,965,650 2,647,711 1,826,766 2,632,490 2,112,451 64,046,547 3.3% Over/(Under) Prior Year (236,962) 682,060 (820,944) 805,723 (520,039) Percent Change From Prior Year (10.8%) 34.7% (31.0%) 44.1% (19.8%) Other Revenues 2,140,704 2,307,387 2,205,619 1,193,188 1,357,645 5,157,715 22,622,680 22.8% Total General Fund Revenues 4,343,317 4,273,038 4,853,329 3,019,954 3,990,134 7,270,165 86,669,227 8.4%
(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 July 31, 2022
Year-To-Date Actuals FY 2023
$0 $500,000 $1,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
July 31, 2022
Fiscal Year 2022-23
Fiscal Year 2021-22
General Fund Major Revenue Sources
3 4 5 6 7
Percent of Year
8.3%
#DIV/0!
-
City of Manhattan Beach
Fiscal Year-To-Date General Fund Trends
Through July 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
% of Year
8.3%
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 $7,270,165 79,399,062 8% Street Lighting & Landscaping Fund 201 390,822 - 390,822 43 390,779 0.0% Gas Tax Fund 205 1,798,763 - 1,798,763 134,186 1,664,577 7.5% Asset Forfeiture 210 41,800 - 41,800 1,859 39,941 4.4% Police Safety Grants 211 159,000 - 159,000 620 158,380 0.4% Prop A Fund 230 883,003 - 883,003 92,622 790,381 10.5% Prop C Fund 231 712,451 - 712,451 78,640 633,811 11.0% AB 2766 Fund 232 47,500 - 47,500 252 47,248 0.5% Measure R 233 547,088 - 547,088 59,617 487,471 10.9% Measure M 234 5,921,033 - 5,921,033 66,605 5,854,428 1.1% Measure W 240 1,611,500 - 1,611,500 2,744 1,608,756 0.2% Capital Improvements Fund 401 1,605,438 - 1,605,438 104,144 1,501,294 6.5% Bond Construction Fund 402 - - - 8,459 (8,459) 100.0% Underground Assessment District Construction 403 - - - 3,773 (3,773) 100.0% Water Fund 501 16,472,500 - 16,472,500 1,681,650 14,790,850 10.2% Stormwater Fund 502 344,484 - 344,484 1,197 343,287 0.3% Wastewater Fund 503 3,628,000 - 3,628,000 361,454 3,266,546 10.0% Parking Fund 520 3,983,200 - 3,983,200 439,331 3,543,869 11.0% County Parking Lots Fund 521 1,363,000 - 1,363,000 163,707 1,199,293 12.0% State Pier & Parking Lot Fund 522 833,500 - 833,500 102,954 730,546 12.4% Insurance Reserve Fund 601 7,549,860 - 7,549,860 579,183 6,970,677 7.7% Information Systems Reserve Fund 605 3,698,533 - 3,698,533 308,214 3,390,319 8.3% Fleet Management Fund 610 2,772,827 - 2,772,827 165,553 2,607,274 6.0% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 120,737 2,075,094 5.5% Special Assessment Debt Service 710 714,150 - 714,150 231 713,919 0.0% Special Assessment UAD 19-12 19-14 Fund 711 606,106 - 606,106 3,736 602,370 0.6% Special Assessment UAD 19-4 Fund 712 337,613 - 337,613 111 337,502 0.0% City Pension Fund 801 264,480 - 264,480 - 264,480 0.0% PARS Investment Trust 804 50,000 - 50,000 57,657 (7,657) 115.3% $145,201,709 $0 $145,201,709 $11,809,446 $133,392,263 8.1% City of Manhattan Beach
Fiscal Year 2022-2023 Citywide Revenues
As of July 31, 2022
Current Year Activity
% of Year
8.3%
Fund Original Budget Adjusted Available %
No. Budget Adjustments* Budget Actuals Encumbrances Budget Utilized General Fund 100 $85,275,151 $0 $85,275,151 $5,174,133 $663,102 $79,437,916 6.8% Street Lighting & Landscaping Fund 201 612,022 - 612,022 22,766 7,550 581,706 5.0% Gas Tax Fund 205 1,575,138 - 1,575,138 6,464 9,718 1,558,956 1.0% Asset Forfeiture 210 107,750 - 107,750 5,057 - 102,693 4.7% Police Safety Grants 211 155,000 - 155,000 - - 155,000 0.0% Prop A Fund 230 780,646 - 780,646 46,596 - 734,050 6.0% Prop C Fund 231 1,260,138 - 1,260,138 7,684 253,547 998,907 20.7% AB 2766 Fund 232 673 - 673 56 - 617 8.3% Measure R 233 760,138 - 760,138 4,161 - 755,977 0.5% Measure M 234 5,870,138 - 5,870,138 5,069 - 5,865,069 0.1% Measure W 240 1,200,000 - 1,200,000 - - 1,200,000 - Capital Improvements Fund 401 6,442,589 - 6,442,589 19,479 324,335 6,098,775 5.3% Bond Construction Fund 402 - - - - 4,901,031 (4,901,031) 100.0% Underground Assessment District Construction 403 1,285,750 - 1,285,750 9,445 - 1,276,305 0.7% Water Fund 501 13,304,706 - 13,304,706 1,006,352 1,008,468 11,289,886 15.1% Stormwater Fund 502 1,836,564 - 1,836,564 25,161 - 1,811,403 1.4% Wastewater Fund 503 4,710,392 - 4,710,392 110,465 654,139 3,945,788 16.2% Parking Fund 520 2,698,608 - 2,698,608 105,745 - 2,592,863 3.9% County Parking Lots Fund 521 953,214 - 953,214 5,931 - 947,283 0.6% State Pier & Parking Lot Fund 522 737,458 - 737,458 24,662 - 712,796 3.3% Insurance Reserve Fund 601 8,243,352 - 8,243,352 4,410,052 251,680 3,581,620 56.6% Information Systems Reserve Fund 605 4,276,387 - 4,276,387 398,069 234,714 3,643,604 14.8% Fleet Management Fund 610 2,490,440 - 2,490,440 78,552 32,181 2,379,707 4.4% Building Maintenance & Operation Fund 615 2,195,831 - 2,195,831 115,914 34,188 2,045,729 6.8% Special Assessment Debt Service 710 700,450 - 700,450 - - 700,450 0.0% Special Assessment UAD 19-12 19-14 Fund 711 609,007 - 609,007 - - 609,007 0.0% Special Assessment UAD 19-4 Fund 712 341,813 - 341,813 - - 341,813 0.0% City Pension Fund 801 196,680 - 196,680 16,472 - 180,208 8.4% PARS Investment Trust 804 - - - - - - - $148,620,035 $0 $148,620,035 $11,598,285 $8,374,653 $128,647,097 13.4% *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 2022-2023 Citywide Expenditures
As of July 31, 2022
Current Year Activity