Loading...
HomeMy WebLinkAboutBack-Up DocumentsFY 2022-23 Year -to -Date Budget -to -Actual Performance and Preliminary Projections — March 2023 The books for the month of March were closed on April 11, 2023. The fiscal year is now 50 percent complete. If revenues and expenditures were linear, we would expect to see about 50 percent of the budget utilized or achieved for the first six months of the fiscal year. Please note that this is only a guide as many revenues and expenditure categories do not follow a linear pattern. Attached for your perusal, you will find the revenue and expenditure reports showing both fiscal -year-to-date and projections information. This projection is preliminary, and it is expected that it will change as more data is collected and analyzed through the remainder of the fiscal year. A presentation of these projections will be made at the City Commission meeting on April 27, 2023. Overall projected revenues minus projected expenditures are currently trending toward a surplus of $38.2 million in the General Fund. This includes a surplus of $3.4 million from the Internal Service Fund and a projected deficit of $1.1 million in the Building Fund. The projected surplus also includes $5 million for the "contingency reserve" that the city must set aside pursuant to Financial Integrity Principles. General Fund Revenues Overall actual revenues received year-to-date in the General Fund through March 2023 ($683.4 million) were $57.3 million higher than the revenues received during the same period last fiscal year ($626.1 million). This represents approximately 70.8 percent of general fund budgeted revenues already collected this year. As of the end of March 2023, the city's overall projected revenues in the General Fund are expected to be higher than budgeted by $25.3 million. General Fund Expenditures Overall actual expenditures year-to-date in the General Fund through March 2023 ($628.0 million) were $71.2 million higher than the expenditures incurred during the same period last year ($556.8 million). This represents approximately 65.1 percent of the general fund budget spent this fiscal year. As of the end of March 2023, the city's overall projected expenditures are expected to be lower than budgeted by $9.5 million. Variables It is to be noted that the FY 2022-23 Adopted Budget for the General Fund is $965.3 million, and the target projection variance is to stay within one to two percent. Below are some variables that will have an impact on future end -of -year projections: • The adoption of the Mid -Year Budget Amendment, Floor Amendments, currently unbudgeted items, City Commission directives, and/or any increases to current city services. • Any changes in Internal Service Fund (ISF) particularly related to health care and workers' compensation costs. • Any decisions that result from pending labor negotiations and/or labor settlements. • A preliminary projection of the Overtime in the Police Department indicates that the department will exceed the budget by $7.5 million. OMB will continue to monitor these expenditures through the remainder of the fiscal year. Page 1 of 2 • A preliminary projection of the Fire Department indicates that the department will exceed the budget by $5.8 million. This is mainly due to the overtime lines projected to exceed by an estimated $4.1 million and IAFF Health Trust contribution by an estimated $1.7 million. • A General Fund Contribution to the Police Services, E911 Special Revenue Fund to cover a previous year's fund balance deficit estimated at $706,000. • The city's contract with Limousines of South Florida, Inc. for the operations of the trolley program was renewed in March 2023. However, the renewal of the contract resulted in an increase of 20% to the currently budgeted hourly rate for trolley route services. It is expected that the increase in costs will create a deficit in the Special Revenue Fund for trolley operations and a General Fund contribution may be required by year-end. • Any changes with one-time reimbursements, reclassifications, third -party insurance refunds and settlements. These items will remain volatile up to the end of the current fiscal year and any significant change will have an impact on revenues and expenditures and will change the current projection. New Fiscal Year The preparation of the budget for the upcoming fiscal year is proceeding as planned. All departments have submitted their budget proposals and have met with their corresponding ACM, DCM, and/or the City Manager to present their budget requests and engage in productive discussions. These meetings are a critical aspect of the budget development process, as they will ensure that each department can obtain the necessary resources to accomplish their objectives successfully. During March, the budget deliverables for FY 2023-24 were submitted to the City Manager for review. Additionally, the first community budget meeting was conducted on April 11th to provide stakeholders with an opportunity to provide input and feedback on the proposed budget. During the meeting, questions were raised regarding shelters for the homeless as well as the unfunded surtax revenues from the Citizen's Independent Transportation Transit to fund trolley operations and related expenditures. Should you have questions about the attached reports, please contact OMB at 305-416-1585 or email Mgouin@miamigov.com. Page 2 of 2 * E INCOHP_DAATEI 18?98 General Fund - Revenues • Property Taxes Franchise Fees/Other Taxes Interest Transfer - In Fines & Forfeitures Intergovernmental Revenues Licenses and Permits Other Revenues (Inflows) Charges for Services Total FY 2022-23 Adopted Budget $ 490,546,000 124,167,000 2,537,000 14,898,000 6,208,000 96,229,000 78,451,000 25,583,000 126,662,000 $ 965,281,000 FY 2022-23 Year -to -Date Actual FY 2022-23 Year -End Projection YE Projection to Budget $ 422,522,150 $ 471,731,000 $ (18,815,000) 47,406,077 15,363,870 129,396,000 20,734,000 5,229,000 18,197,000 8,395,533 4,863,195 43,873,550 16,179,000 1,281,000 9,012,000 2,804,000 102,106,000 5,877,000 55,909,616 98,118,000 19,667,000 3,928,790 81,181,102 $ 683,443,883 5,823,000 (19,760,000) 137,486,000 10,824,000 $ 990,585,000 $ 25,304,000 General Fund - Expenditures o Personnel Operating Expense Capital Outlay Non -Operating Expenses Transfers - Out Total FY 2022-23 Amended Budget $ 701,422,000 173,599,000 335,000 22,362,000 67,563,000 $ 965,281,000 FY 2022-23 Year -to -Date Actual $ 448,176,723 108,489,012 199,562 3,539,849 67,602,794 $ 628,007,940 FY 2022-23 Year -End Pro'ection $ 702,708,000 173,263,000 682,000 8,821,000 70, 288,000 $ 955,762,000 YE Projection to Budget $ (1,286,000) 336,000 (347,000) 13,541,000 (2,725,000) $ 9,519,000 Internal Service Fund FY 2022-23 Amended Budget FY 2022-23 Year -to -Date Actual FY 2022-23 Year -End Projection YE Projection to Budget Revenues: Transfers -IN Other Revenues (Inflows) Charges for Services Total Expenditures: Innovation Technology Risk Management Total $ 104,830,000 60,000 $ 104,890,000 14,808,000 90,082,000 $ 104,890,000 $ 2,770 94,473,711 62,766 $ 94,539,247 5,002,268 44,623,317 $ 49,625,585 $ 4,000 105,912,000 143,000 $ 106,059,000 1 14,808,000 87,875,000 $ 102,683,000 $ 4,000 1,082,000 83,000 $ 1,169,000 mi 0 2,207,000 $ 2,207,000 Revenues Over/(Under) $ - $ 44,913,663 $ 3,376,000 Expenditures Summary Item Amount Projected Revenues Projected Expenditures Revenues Over/(Under) Expenditures Internal Service Net Year -End Surplus/(Deficit) Net Year -End Surplus/(Deficit) 990,585,000 955,762,000 34,823,000 3,376,000 38,199,000 Include in this projection : Contingency Reserve (as per Financial Integrity Principles) 5,000,000 City of Miami FY 2022-23 March 2023 Projections CITY OF MIAMI Revenues by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections BudgetFY23 - Working Proj Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) City Attorney Other Revenues (Inflows) 128,000 70,523 55.10% 135,000 7,000 Charges for Services 239,000 26,121 10.93% 155,000 (84,000) Total: 367,000 96,644 26.33% 290,000 (77,000) City Clerk Fines and Forfeitures 650 Other Revenues (Inflows) 0 0 Charges for Services 0 1,610 Tota I: 0 2,260 * * 4,000 4,000 1,000 1,000 2,000 2,000 7,000 7,000 Code Compliance Interest 7,000 414 5.91% 3,000 (4,000) Fines and Forfeitures 360,000 106,202 29.50% 214,000 (146,000) Licenses and Permits 318,000 92,318 29.03% 233,000 (85,000) Other Revenues (Inflows) 391 * * Charges for Services 352,000 143,722 40.83% 318,000 (34,000) Total: 1,037,000 343,046 33.08% 768,000 (269,000) Finance Property Taxes 490,546,000 422,522,150 86.13% 471,731,000 (18,815,000) Franchise Fees and Other Taxes 109,767,000 42,606,795 38.82% 115,399,000 5,632,000 Interest 2,529,000 15,363,104 607.48% 20,730,000 18,201,000 Transfers -IN 14,598,000 6,870,977 47.07% 14,654,000 56,000 Fines and Forfeitures 22,000 1,798,798 8,176.35% 1,799,000 1,777,000 Intergovernmental Revenues 82,751,000 33,382,502 40.34% 87,197,000 4,446,000 Licenses and Permits 10,254,000 8,345,686 81.39% 9,590,000 (664,000) Other Revenues (Inflows) 1,319,000 983,718 74.58% 1,533,000 214,000 Charges for Services 31,680,000 16,689,117 52.68% 33,770,000 2,090,000 Total: 743,466,000 548,562,847 73.78% 756,403,000 12,937,000 Human Resources Other Revenues (Inflows) 1 Total: 1 * Innovation and Technology Other Revenues (Inflows) 60,000 - * 15,000 (45,000) Run Date 04/13/2023 Run Time: 12:10:29 PM Page 1 of 4 CITY OF MIAMI Revenues by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections BudgetFY23 - Working Proj Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Innovation and Technology Charges for Services 6,000 1,692 28.21% 4,000 (2,000) Total: 66,000 1,692 2.56% 19,000 (47,000) Neighborhood Enhancement Teams (NET) Fines and Forfeitures 2.500 Total: 2,500 Procurement Transfers -IN 89 Other Revenues (Inflows) 9 * * Total: 98 * Human Services Other Revenues (Inflows) 14,345 Charges for Services 37,000 9,227 Total: 37,000 23,572 * 24.94% 63.71% 20,000 20,000 15,000 (22,000) 35,000 (2,000) Building Department Fines and Forfeitures 35,000 3,493 9.98% 11,000 (24,000) Licenses and Permits 30,061,000 21,906,369 72.87% 44,453,000 14,392,000 Other Revenues (Inflows) 0 * (1,623,000) (1,623,000) Charges for Services 6,100,000 3,962,416 64.96% 7,545,000 1,445,000 Total: 36,196,000 25,112,143 69.38% 50,386,000 14,190,000 Planning Fines and Forfeitures 3,000 0 Licenses and Permits 700,000 469,685 67.10% 900,000 200,000 Other Revenues (Inflows) 32,000 36,102 112.82% 81,000 49,000 Charges for Services 3,899,000 3,635,231 93.23% 6,359,000 2,460,000 Total: 4,634,000 4,141,004 89.36% 7,340,000 2,706,000 Zoning Licenses and Permits 6,300,000 4,067,078 64.56% 7,261,000 961,000 Other Revenues (Inflows) 16,000 8,039 50.25% 16,000 0 Charges for Services 628,000 247,967 39.49% 497,000 (131,000) Total: 6,944,000 4,323,085 62.26% 7,774,000 830,000 Run Date 04/13/2023 Run Time: 12:10:29 PM Page 2 of 4 CITY OF MIAMI Revenues by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections BudgetFY23 - Working Proj Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) General Services Administration Transfers -IN 410 Other Revenues (Inflows) 152,000 588,145 Total: 152,000 588,555 * 386.94% 387.21% 1,000 1,000 698,000 546,000 699,000 547,000 Total Resilience and Public Works Department Franchise Fees and Other Taxes 14,400,000 4,799,282 33.33% 13,997,000 (403,000) Licenses and Permits 1,400,000 1,541,191 110.09% 2,890,000 1,490,000 Charges for Services 2,540,000 1,761,769 69.36% 3,477,000 937,000 Total: 18,340,000 8,102,241 44.18% 20,364,000 2,024,000 Solid Waste Interest 1,000 352 35.25% 1,000 0 Transfers -IN 1,858 * 2,000 2,000 Fines and Forfeitures 663,000 430,881 64.99% 850,000 187,000 Licenses and Permits 26,527,000 17,354,132 65.42% 30,157,000 3,630,000 Other Revenues (Inflows) 7,000 1,500 21.43% 5,000 (2,000) Charges for Services 24,721,000 21,025,701 85.05% 24,644,000 (77,000) Total: 51,919,000 38,814,423 74.76% 55,659,000 3,740,000 Fire -Rescue Transfers -IN 2,893 * 3,000 3,000 Intergovernmental Revenues 7,476,000 4,491,048 60.07% 8,909,000 1,433,000 Licenses and Permits 2,438,000 1,975,839 81.04% 2,289,000 (149,000) Other Revenues (Inflows) 3,790,000 2,175,100 57.39% 3,778,000 (12,000) Charges for Services 13,743,000 7,454,184 54.24% 14,834,000 1,091,000 Total: 27,447,000 16,099,065 58.66% 29,813,000 2,366,000 Police Transfers -IN 1,219,305 * 1,219,000 1,219,000 Fines and Forfeitures 5,067,000 2,495,080 49.24% 6,066,000 999,000 Intergovernmental Revenues 6,000,000 6,000,000 100.00% 6,000,000 0 Licenses and Permits 295,000 125,160 42.43% 295,000 0 Other Revenues (Inflows) 42,000 200,095 476.42% 223,000 181,000 Charges for Services 4,954,000 2,606,755 52.62% 4,631,000 (323,000) Total: 16,358,000 12,646,396 77.31% 18,434,000 2,076,000 Run Date 04/13/2023 Run Time: 12:10:29 PM Page 3 of 4 CITY OF MIAMI Revenues by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections BudgetFY23 - Working Proj Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Real Estate and Asset Management Fines and Forfeitures 58,000 25,606 44.15% 68,000 10,000 Intergovernmental Revenues 2,000 - * 0 (2,000) Licenses and Permits 158,000 32,157 20.35% 50,000 (108,000) Other Revenues (Inflows) 342,000 243,373 71.16% 337,000 (5,000) Charges for Services 31,274,000 20,178,977 64.52% 36,304,000 5,030,000 Total: 31,834,000 20,480,113 64.33% 36,759,000 4,925,000 Parks and Recreation Other Revenues (Inflows) 300,000 137,663 45.89% 300,000 0 Charges for Services 6,489,000 3,436,613 52.96% 4,931,000 (1,558,000) Total: 6,789,000 3,574,277 52.65% 5,231,000 (1,558,000) Risk Management Other Revenues (Inflows) 40 * * Total: 40 * Non -Departmental Transfers -IN 300,000 300,000 100.00% 300,000 0 Other Revenues (Inflows) 19,395,000 229,880 1.19% 304,000 (19,091,000) Total: 19,695,000 529,880 2.69% 604,000 (19,091,000) All Organizations Property Taxes 490,546,000 422,522,150 86.13% 471,731,000 (18,815,000) Franchise Fees and Other Taxes 124,167,000 47,406,077 38.18% 129,396,000 5,229,000 Interest 2,537,000 15,363,870 605.59% 20,734,000 18,197,000 Transfers -IN 14,898,000 8,395,533 56.35% 16,179,000 1,281,000 Fines and Forfeitures 6,208,000 4,863,195 78.34% 9,012,000 2,804,000 Intergovernmental Revenues 96,229,000 43,873,550 45.59% 102,106,000 5,877,000 Licenses and Permits 78,451,000 55,909,616 71.27% 98,118,000 19,667,000 Other Revenues (Inflows) 25,583,000 3,928,790 15.36% 5,823,000 (19,760,000) Charges for Services 126,662,000 81,181,102 64.09% 137,486,000 10,824,000 Total: 965,281,000 683,443,883 70.80% 990,585,000 25,304,000 Run Date 04/13/2023 Run Time: 12:10:29 PM Page 4 of 4 CITY OF MIAMI Expenditures by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Mayor Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Personnel 2,561,000 1,553,345 60.65% 2,428,000 133,000 Operating Expense 571,000 226,157 39.61% 368,000 203,000 Transfers - OUT 20,000 * 20,000 (20,000) Total: 3,132,000 1,799,502 57.46% 2,816,000 316,000 Commissioners Personnel 7,215,000 3,958,190 Operating Expense 3,401,000 860,331 54.86% 25.30% 6,359,000 1,330,000 856,000 2,071,000 Total: 10,616,000 4,818,522 45.39% 7,689,000 2,927,000 City Manager Personnel 3,745,000 2,076,104 55.44% 3,574,000 171,000 Operating Expense 620,000 533,974 86.12% 648,000 (28,000) Non -Operating Expenses 1,871,000 50,703 2.71% 1,914,000 (43,000) Total: 6,236,000 2,660,780 42.67% 6,136,000 100,000 Office of Agenda Coordination Personnel 369,000 236,957 64.22% 367,000 2,000 Operating Expense 17,000 14,410 84.76% 16,000 1,000 Total: 386,000 251,367 65.12% 383,000 3,000 Independent Auditor General Personnel 1,649,000 Operating Expense 125,000 Capital Outlay 2,000 958,082 62,352 58.10% 1,482,000 167,000 49.88% 101,000 24,000 * 2,000 0 Total: 1,776,000 1,020,434 57.46% 1,585,000 191,000 City Attorney Personnel 11,731,000 7,369,280 Operating Expense 548,000 393,338 62.82% 71.78% 11,597,000 550,000 134,000 (2,000) Total: 12,279,000 7,762,618 63.22% 12,147,000 132,000 City Clerk Personnel 1,779,000 1,185,329 Operating Expense 373,000 183,808 66.63% 49.28% 1,764,000 352,000 15,000 21,000 Total: 2,152,000 1,369,137 63.62% 2,116,000 36,000 Run Date 04/13/2023 Run Time: 12:11:25 PM Page 1 of 6 CITY OF MIAMI Expenditures by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) City Clerk Civil Service Board Personnel Operating Expense 578,000 375,607 64.98% 568,000 10,000 44,000 29,015 65.94% 41,000 3,000 Total: 622,000 404,623 65.05% 609,000 13,000 Code Compliance Personnel 9,372,000 6,132,554 65.43% 9,026,000 346,000 Operating Expense 1,321,000 1,053,595 79.76% 1,251,000 70,000 Capital Outlay 20,000 0 0.00% 20,000 0 Non -Operating Expenses 66 * Total: 10,713,000 7,186,216 67.08% 10,297,000 416,000 Office of Communications Personnel 1,319,000 723,061 54.82% 1,143,000 Operating Expense 252,000 151,349 60.06% 231,000 176,000 21,000 Total: 1,571,000 874,410 55.66% 1,374,000 197,000 Equal Opportunity and Diversity Programs Personnel Operating Expense 579,000 40,000 384,696 66.44% 15,463 38.66% 575,000 4,000 29,000 11,000 Total: 619,000 400,159 64.65% 604,000 15,000 Finance Personnel 10,067,000 6,469,469 Operating Expense 2,291,000 994,149 64.26% 43.39% 10,010,000 1,909,000 57,000 382,000 Total: 12,358,000 7,463,618 60.40% 11,919,000 439,000 Grants Administration Personnel Operating Expense 1,888,000 137,000 765,690 40.56% 60,615 44.24% 1,756,000 133,000 132,000 4,000 Total: 2,025,000 826,305 40.81% 1,889,000 136,000 Human Resources Personnel Operating Expense 5,760,000 273,000 3,697,847 243,258 64.20% 89.11% 5,600,000 269,000 160,000 4,000 Total: 6,033,000 3,941,105 65.33% 5,869,000 164,000 Run Date 04/13/2023 Run Time: 12:11:25 PM Page 2 of 6 CITY OF MIAMI Expenditures by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Human Resources Innovation and Technology Personnel 15,084,000 9,535,838 Operating Expense 626,000 461,823 63.22% 73.77% 14,656,000 518,000 428,000 108,000 Total: 15,710,000 9,997,660 63.64% 15,174,000 536,000 Management and Budget Personnel 2,939,000 1,811,611 Operating Expense 235,000 108,403 61.64% 46.13% 2,852,000 230,000 87,000 5,000 Total: 3,174,000 1,920,014 60.49% 3,082,000 92,000 Procurement Personnel 3,139,000 1,962,867 62.53% 3,035,000 104,000 Operating Expense 302,000 132,680 43.93% 258,000 44,000 Capital Outlay 10,000 - * 10,000 0 Total: 3,451,000 2,095,547 60.72% 3,303,000 148,000 Office of Resilience and Sustainability Personnel Operating Expense 842,000 220,000 495,533 58.85% 16,770 7.62% 835,000 7,000 187,000 33,000 Total: 1,062,000 512,303 48.24% 1,022,000 40,000 Human Services Personnel 5,278,000 3,447,281 Operating Expense 1,346,000 1,511,539 Capital Outlay 0 65.31% 112.30% * 4,766,000 1,456,000 100,000 512,000 (110,000) (100,000) Total: 6,624,000 4,958,820 74.86% 6,322,000 302,000 Building Department Personnel 23,772,000 13,472,067 56.67% 21,327,000 2,445,000 Operating Expense 3,494,000 3,282,822 93.96% 5,808,000 (2,314,000) Capital Outlay - * 7,000 (7,000) Non -Operating Expenses 0 915 * 1,000 (1,000) Total: 27,266,000 16,755,805 61.45% 27,143,000 123,000 Planning Personnel 5,571,000 3,208,206 57.59% 5,336,000 235,000 Run Date 04/13/2023 Run Time: 12:11:25 PM Page 3 of 6 CITY OF MIAMI Expenditures by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Planning Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Operating Expense 890,000 465,324 52.28% 916,000 Total: 6,461,000 3,673,530 56.86% 6,252,000 209,000 Zoning Personnel 4,945,000 3,101,172 62.71% 4,632,000 313,000 Operating Expense 901,000 379,009 42.07% 617,000 284,000 Capital Outlay 3,000 0 0.00% 0 3,000 Total: 5,849,000 3,480,182 59.50% 5,249,000 600,000 General Services Administration Personnel 17,579,000 11,507,482 65.46% 17,016,000 Operating Expense 15,059,000 9,753,394 64.77% 14,923,000 Capital Outlay (914) * 563,000 136,000 Total: 32,638,000 21,259,961 65.14% 31,939,000 699,000 Total Resilience and Public Works Department Personnel 16,889,000 10,677,187 Operating Expense 14,021,000 6,029,656 Capital Outlay 0 18,883 63.22% 43.00% * 16,430,000 14,093,000 20,000 459,000 (72,000) (20,000) Total: 30,910,000 16,725,727 54.11% 30,543,000 367,000 Solid Waste Personnel 26,762,000 17,476,488 65.30% 25,869,000 893,000 Operating Expense 17,611,000 8,470,334 48.10% 18,424,000 (813,000) Capital Outlay 0 71,332 * 80,000 (80,000) Non -Operating Expenses 0 9,356 * 0 Total: 44,373,000 26,027,510 58.66% 44,373,000 0 Capital Improvements and Transportation Personnel 3,602,000 2,786,394 77.36% 3,449,000 153,000 Operating Expense 323,000 254,414 78.77% 300,000 23,000 Capital Outlay 0 0 * 45,000 (45,000) Total: 3,925,000 3,040,808 77.47% 3,794,000 131,000 Fire -Rescue Personnel 174,225,000 111,202,413 63.83% 179,632,000 (5,407,000) Operating Expense 18,648,000 12,761,067 68.43% 18,906,000 (258,000) Run Date 04/13/2023 Run Time: 12:11:25 PM Page 4 of 6 CITY OF MIAMI Expenditures by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Fire -Rescue Capital Outlay Non -Operating Expenses Transfers - OUT 300,000 12,636 1,508,000 (477) 5,238 4.21% (0.03%) * 300,000 0 1,611,000 (103,000) 5,000 (5,000) Total: 194,681,000 123,980,877 63.68% 200,454,000 (5,773,000) Police Personnel 275,105,000 184,568,099 Operating Expense 46,867,000 32,240,789 Capital Outlay 0 83,786 Transfers - OUT 14,555 67.09% 68.79% * * 283,628,000 (8,523,000) 43,856,000 3,011,000 84,000 (84,000) 13,000 (13,000) Total: 321,972,000 216,907,229 67.37% 327,581,000 (5,609,000) Housing and Community Development Department Personnel Operating Expense 1,344,000 1,283,484 95.50% 1,344,000 0 489,000 336,368 68.79% 489,000 0 Total: 1,833,000 1,619,852 88.37% 1,833,000 0 Real Estate and Asset Management Personnel 5,427,000 3,439,416 Operating Expense 12,053,000 7,839,729 63.38% 65.04% 5,504,000 11,927,000 (77,000) 126,000 Total: 17,480,000 11,279,145 64.53% 17,431,000 49,000 Parks and Recreation Personnel 42,036,000 24,621,575 58.57% 39,579,000 2,457,000 Operating Expense 19,437,000 11,678,685 60.08% 18,590,000 847,000 Capital Outlay 0 13,799 * 14,000 Non -Operating Expenses 293,000 47,157 16.09% 195,000 98,000 Total: 61,766,000 36,361,215 58.87% 58,378,000 3,388,000 Risk Management Personnel 3,232,000 1,952,467 Operating Expense 903,000 412,654 60.41% 45.70% 2,954,000 661,000 278,000 242,000 Total: 4,135,000 2,365,121 57.20% 3,615,000 520,000 Non -Departmental Personnel 15,039,000 5,740,931 Operating Expense 10,161,000 7,531,737 38.17% 74.12% 13,614,000 1,425,000 13,876,000 Run Date 04/13/2023 Run Time: 12:11:25 PM Page 5 of 6 CITY OF MIAMI Expenditures by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Adopted Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Non -Departmental Capital Outlay 0 40 Non -Operating Expenses 18,690,000 3,432,129 Transfers - OUT 67,563,000 67,563,000 18.36% 100.00% 0 0 5,100,000 13,590,000 70,250,000 (2,687,000) Total: 111,453,000 84,267,837 75.61% 102,840,000 8,613,000 All Organizations Personnel 701,422,000 448,176,723 63.90% 702,708,000 (1,286,000) Operating Expense 173,599,000 108,489,012 62.49% 173,263,000 336,000 Capital Outlay 335,000 199,562 59.57% 682,000 (347,000) Non -Operating Expenses 22,362,000 3,539,849 15.83% 8,821,000 13,541,000 Transfers - OUT 67,563,000 67,602,794 100.06% 70,288,000 (2,725,000) Total: 965,281,000 628,007,938 65.06% 955,762,000 9,519,000 Run Date 04/13/2023 Run Time: 12:11:25 PM Page 6 of 6 CITY OF MIAMI Monthly Financial Statement - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Projection As of Y-T-D (H-T-D(Mar)) Adopted Variance YTD Act. to Year End Favorable / Actual Budget (%) Projection (Unfavorable) Revenues Property Taxes 490,546,000 422,522,150 86.13% 471,731,000 Franchise Fees and Other Taxes 124,167,000 47,406,077 38.18% 129,396,000 5,229,000 Interest 2,537,000 15,363,870 605.59% 20,734,000 18,197,000 Transfers -IN 14,898,000 8,395,533 56.35% 16,179,000 1,281,000 Fines and Forfeitures 6,208,000 4,863,195 78.34% 9,012,000 2,804,000 Intergovernmental Revenues 96,229,000 43,873,550 45.59% 102,106,000 5,877,000 Licenses and Permits 78,451,000 55,909,616 71.27% 98,118,000 19,667,000 Other Revenues (Inflows) 25,583,000 3,928,790 15.36% 5,823,000 (19,760,000) Charges for Services 126,662,000 81,181,102 64.09% 137,486,000 10,824,000 Total Revenues 965,281,000 683,443,883 70.80% 990,585,000 25,304,000 Expenditures Mayor 3,132,000 1,799,502 57.46% 2,816,000 316,000 Commissioners 10,616,000 4,818,522 45.39% 7,689,000 2,927,000 City Manager 6,236,000 2,660,780 42.67% 6,136,000 100,000 Office of Agenda Coordination 386,000 251,367 65.12% 383,000 3,000 Independent Auditor General 1,776,000 1,020,434 57.46% 1,585,000 191,000 City Attorney 12,279,000 7,762,618 63.22% 12,147,000 132,000 City Clerk 2,152,000 1,369,137 63.62% 2,116,000 36,000 Civil Service Board 622,000 404,623 65.05% 609,000 13,000 Code Compliance 10,713,000 7,186,216 67.08% 10,297,000 416,000 Office of Communications 1,571,000 874,410 55.66% 1,374,000 197,000 Equal Opportunity and Diversity Programs 619,000 400,159 64.65% 604,000 15,000 Finance 12,358,000 7,463,618 60.40% 11,919,000 439,000 Grants Administration 2,025,000 826,305 40.81% 1,889,000 136,000 Human Resources 6,033,000 3,941,105 65.33% 5,869,000 164,000 Innovation and Technology 15,710,000 9,997,660 63.64% 15,174,000 536,000 Management and Budget 3,174,000 1,920,014 60.49% 3,082,000 92,000 Procurement 3,451,000 2,095,547 60.72% 3,303,000 148,000 Office of Resilience and Sustainability 1,062,000 512,303 48.24% 1,022,000 40,000 Human Services 6,624,000 4,958,820 74.86% 6,322,000 302,000 General Government 100,539,000 60,263,140 59.94% 94,337,000 6,202,000 Building Department 27,266,000 16,755,805 61.45% 27,143,000 123,000 Planning 6,461,000 3,673,530 56.86% 6,252,000 209,000 Zoning 5,849,000 3,480,182 59.50% 5,249,000 600,000 Run Date 04/13/2023 Run Time: 12:11:53 PM Page 1 of2 003 Projection ROE for Specified Fund - One Pager Style CITY OF MIAMI Monthly Financial Statement - General Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Projection As of Y-T-D (H-T-D(Mar)) Adopted Variance YTD Act. to Year End Favorable / Actual Budget (%) Projection (Unfavorable) Planning and Development 39,576,000 23,909,517 60.41% 38,644,000 932,000 Housing and Community Development Department 1,833,000 1,619,852 88.37% 1,833,000 0 Housing and Community Development 1,833,000 1,619,852 88.37% 1,833,000 0 General Services Administration 32,638,000 21,259,961 65.14% 31,939,000 699,000 Total Resilience and Public Works Department 30,910,000 16,725,727 54.11% 30,543,000 367,000 Solid Waste 44,373,000 26,027,510 58.66% 44,373,000 0 Capital Improvements and Transportation 3,925,000 3,040,808 77.47% 3,794,000 131,000 Public Works 111,846,000 67,054,006 59.95% 110,649,000 1,197,000 Fire -Rescue 194,681,000 123,980,877 63.68% 200,454,000 (5,773,000) Police 321,972,000 216,907,229 67.37% 327,581,000 (5,609,000) Public Safety 516,653,000 340,888,106 65.98% 528,035,000 (11,382,000) Non -Departmental 111,453,000 84,267,837 75.61% 102,840,000 8,613,000 Non Departmental Units 111,453,000 84,267,837 75.61% 102,840,000 8,613,000 Real Estate and Asset Management 17,480,000 11,279,145 64.53% 17,431,000 49,000 Parks and Recreation 61,766,000 36,361,215 58.87% 58,378,000 3,388,000 Risk Management 4,135,000 2,365,121 57.20% 3,615,000 520,000 Total Other 83,381,000 50,005,481 59.97% 79,424,000 3,957,000 Total Expenditures 965,281,000 628,007,938 65.06% 955,762,000 9,519,000 Total Revenues Over/(Under) Expenditures 0 55,435,944 34,823,000 Run Date 04/13/2023 Run Time: 12:11:53 PM Page 2 of 2 003 Projection ROE for Specified Fund - One Pager Style CITY OF MIAMI Monthly Financial Statement - Internal Service Fund FY 2022-23 YTD Actual vs. Budget with Projections Projections - Working_Projection Projection As of Y-T-D (H-T-D(Mar)) Revenues Transfers -IN Other Revenues (Inflows) Charges for Services Total Revenues Adopted Variance YTD Act. to Year End Favorable / Actual Budget (%) Projection (Unfavorable) - 2,770 * 4,000 4,000 104,830,000 94,473,711 90.12% 105,912,000 1,082,000 60,000 62,766 104.61% 143,000 83,000 104,890,000 94,539,247 90.13% 106,059,000 1,169,000 Expenditures Innovation and Technology 14,808,000 5,002,268 33.78% 14,808,000 0 General Government 14,808,000 5,002,268 33.78% 14,808,000 0 Risk Management 90,082,000 44,623,317 49.54% 87,875,000 2,207,000 Total Other 90,082,000 44,623,317 49.54% 87,875,000 2,207,000 Total Expenditures 104,890,000 49,625,585 47.31% 102,683,000 2,207,000 Total Revenues Over/(Under) Expenditures 0 44,913,663 3,376,000 Run Date 04/13/2023 Run Time: 12:12:37 PM Page 1 of 1 003 Projection ROE for Specified Fund - One Pager Style