Loading...
HomeMy WebLinkAboutBack-Up DocumentsFY 2022-23 Year -to -Date Budget -to -Actual Performance and Preliminary Projections — June 2023. The books for the month of June were closed on July 12, 2023. The fiscal year is now 75 percent complete. If revenues and expenditures were linear, we would expect to see about 75 percent of the budget utilized or achieved for the first nine 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. Overall projected revenues minus projected expenditures are currently trending toward a surplus of $24.1 million in the General Fund. This includes a deficit of $7.9 million from the Internal Service Fund and a projected deficit of $1.4 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 June 2023 ($854.0 million) were $70.0 million higher than the revenues received during the same period last fiscal year ($784.0 million). This represents approximately 86.4 percent of general fund budgeted revenues already collected this year. As of the end of June 2023, the city's overall projected revenues in the General Fund are expected to be higher than budgeted by $16.7 million. General Fund Expenditures Overall actual expenditures year-to-date in the General Fund through June 2023 ($803.7 million) were $98.1 million higher than the expenditures incurred during the same period last year ($705.6 million). This represents approximately 81.3 percent of the general fund budget spent this fiscal year. As of the end of June 2023, the city's overall projected expenditures are expected to be lower than budgeted by $15.2 million. Variables It is to be noted that the FY 2022-23 Amended Budget for the General Fund is $988.8 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: • Any changes in Internal Service Fund (ISF) particularly related to insurance general liability, to health care and workers' compensation costs. • Any decisions that result from pending labor negotiations and/or labor settlements. • The Human Services Department is expected to exceed its overall budget by $429,000. This is mainly due to the Professional Services Line Item projected to exceed budget allocation due to lack of funding to cover the Hotel/Motel expenditures for the remainder of the fiscal year. • The Solid Waste Department is expected to exceed its overall budget by $274,000. This is mainly due to the Contractual Services Line Item being projected to exceed budget allocation due to the increase in disposals and having to use a different vendor due to one of the main county sites being down. • The Building Department is expected to exceed its overall budget by $835,000. This is mainly due to the Contractual Services Line Item being projected to exceed budget allocation due to the increased rates for consultants and the challenges associated with hiring full-time positions. • The Fire Rescue Department is expected to exceed its overall budget by $7.8 million. This is mainly due to the overtime lines projected to exceed by an estimated $4.8 million and IAFF Health Trust contribution by an estimated $1.8 million. Also, the Department is projecting the operating budget to be exceeded by a total of $1.2 million in operating supplies and other operating expenses. • 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 development of the FY 2023-24 Proposed Budget is nearing completion. We anticipate releasing the Proposed Budget by the end of this week. Should you have questions about the attached reports, please contact OMB at 305-416-1585 or email Mgouin@miamigov.com. City of Miami FY 2022-23 June 2023 Projections General Fund - Revenues 1 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 19,707,000 14,898,000 6,208,000 99,876,000 78,451,000 28,261,000 126,662,000 $ 988,776,000 FY 2022-23 Year -to -Date Actual FY 2022-23 Year -End Projection YE Projection to Budget $ 474,776,196 $ 476,999,000 $ (13,547,000) 81,565,922 22,860,869 8,523,708 4,870,748 61,528,678 134,145,000 23,268,000 8,525,000 7,010,000 104,437,000 9,978,000 3,561,000 (6,373,000) 802,000 4,561,000 77,295,051 101,025,000 22,574,000 5,509,024 117,032,824 $ 853,963,020 6,479,000 143,591,000 (21,782,000) 16,929,000 $ 1,005,479,000 $ 16,703,000 General Fund - Expenditures FY 2022-23 Amended Budget FY 2022-23 Year -to -Date Actual FY 2022-23 Year -End Projection YE Projection to Budget Personnel $ 653,888,000 $ 521,699,013 $ 649,865,000 $ 4,023,000 Operating Expense 175,768,000 140, 3 60,191 179,104,574 (3,336,574) Capital Outlay 503,000 310,513 749,000 (246,000) Non -Operating Expenses 21,379,000 3,950,355 6,454,000 14,925,000 Transfers - Out 137,238,000 137,381,786 137,383,000 (145,000) Total $ 988,776,000 $ 803,701,858 $ 973,555,574 15,220,426 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 $ 20,512 96,781,158 86,137 $ 96,887,807 9,734,268 71,483,185 $ 81,217,453 $ 21,000 98,644,000 119,000 $ 98,784,000 1 12,837,000 93,810,000 $ 106,647,000 $ 21,000 (6,186,000) 59,000 $ (6,106,000) 1 1,971,000 (3,728,000) $ (1,757,000) Revenues Over/(Under) $ - $ 15,670,354 $ (7,863,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) 1,005,479,000 973,555,574 31,923,426 (7,863,000) 24,060,426 Include in this projection : Contingency Reserve (as per Financial Integrity Principles) 5,000,000 City of Miami FY 2022-23 June 2023 Projections CITY OF MIAMI Revenues by Department w/Categories - General Fund FY 2022-23 YTD Actual vs. Budget with Projections BudgetFY23 - Working Proj Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) City Attorney Other Revenues (Inflows) 128,000 103,432 80.81% 136,000 8,000 Charges for Services 239,000 74,097 31.00% 104,000 (135,000) Total: 367,000 177,529 48.37% 240,000 (127,000) City Clerk Fines and Forfeitures 650 Other Revenues (Inflows) 0 Charges for Services 6,551 Tota I: 7,201 * * 4,000 4,000 1,000 1,000 6,000 6,000 11,000 11,000 Code Compliance Interest 7,000 908 12.98% 2,000 (5,000) Fines and Forfeitures 360,000 154,182 42.83% 205,000 (155,000) Licenses and Permits 318,000 153,234 48.19% 213,000 (105,000) Other Revenues (Inflows) 567 * 1,000 1,000 Charges for Services 352,000 161,970 46.01% 216,000 (136,000) Total: 1,037,000 470,862 45.41% 637,000 (400,000) Finance Property Taxes 490,546,000 474,776,196 96.79% 476,999,000 (13,547,000) Franchise Fees and Other Taxes 109,767,000 73,393,231 66.86% 120,148,000 10,381,000 Interest 19,699,000 22,859,592 116.04% 23,265,000 3,566,000 Transfers -IN 14,598,000 6,870,977 47.07% 6,871,000 Fines and Forfeitures 22,000 47,436 215.62% 48,000 26,000 Intergovernmental Revenues 86,398,000 50,798,820 58.80% 89,528,000 3,130,000 Licenses and Permits 10,254,000 8,707,342 84.92% 9,690,000 (564,000) Other Revenues (Inflows) 1,319,000 1,261,502 95.64% 1,527,000 208,000 Charges for Services 31,680,000 26,175,676 82.63% 33,741,000 2,061,000 Total: 764,283,000 664,890,772 87.00% 761,817,000 (2,466,000) Human Resources Other Revenues (Inflows) 1 Total: 1 * Innovation and Technology Other Revenues (Inflows) 60,000 67,086 111.81% 108,000 48,000 Run Date 07/14/2023 Run Time: 5:31:23 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Innovation and Technology Charges for Services 6,000 3,519 58.65% 5,000 (1,000) Total: 66,000 70,605 106.98% 113,000 47,000 Neighborhood Enhancement Teams (NET) Fines and Forfeitures 4.600 Total: 4,600 * Procurement Transfers -IN 89 Other Revenues (Inflows) 9 * * Total: 98 * Human Services Other Revenues (Inflows) 18,844 Charges for Services 37,000 12,377 Total: 37,000 31,221 * 33.45% 84.38% 22,000 22,000 16,000 (21,000) 38,000 1,000 Building Department Fines and Forfeitures 35,000 4,206 12.02% 9,000 (26,000) Licenses and Permits 30,061,000 33,424,404 111.19% 44,385,000 14,324,000 Other Revenues (Inflows) * (1,599,000) (1,599,000) Charges for Services 6,100,000 5,700,968 93.46% 7,628,000 1,528,000 Total: 36,196,000 37,984,511 104.94% 50,423,000 14,227,000 Planning Fines and Forfeitures 3,000 (0.73%) 0 Licenses and Permits 700,000 684,209 97.74% 874,000 174,000 Other Revenues (Inflows) 32,000 109,540 342.31% 138,000 106,000 Charges for Services 3,899,000 4,624,853 118.62% 6,143,000 2,244,000 Total: 4,634,000 5,418,580 116.93% 7,155,000 2,521,000 Zoning Licenses and Permits 6,300,000 5,669,501 89.99% 7,466,000 1,166,000 Other Revenues (Inflows) 16,000 12,671 79.19% 17,000 1,000 Charges for Services 628,000 327,810 52.20% 464,000 (164,000) Total: 6,944,000 6,009,982 86.55% 7,947,000 1,003,000 Run Date 07/14/2023 Run Time: 5:31:23 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) General Services Administration Transfers -IN 99,174 Other Revenues (Inflows) 152,000 588,145 Total: 152,000 687,319 * 386.94% 452.18% 100,000 100,000 600,000 448,000 700,000 548,000 Total Resilience and Public Works Department Franchise Fees and Other Taxes 14,400,000 8,172,691 56.75% 13,997,000 (403,000) Licenses and Permits 1,400,000 2,246,837 160.49% 3,015,000 1,615,000 Other Revenues (Inflows) 19,725 * 20,000 20,000 Charges for Services 2,540,000 2,526,656 99.47% 3,403,000 863,000 Total: 18,340,000 12,965,909 70.70% 20,435,000 2,095,000 Solid Waste Interest 1,000 368 36.80% 1,000 0 Transfers -IN 1,858 * 2,000 2,000 Fines and Forfeitures 663,000 691,158 104.25% 901,000 238,000 Licenses and Permits 26,527,000 24,067,248 90.73% 32,767,000 6,240,000 Other Revenues (Inflows) 7,000 1,686 24.09% 2,000 (5,000) Charges for Services 24,721,000 24,178,197 97.80% 25,497,000 776,000 Total: 51,919,000 48,940,514 94.26% 59,170,000 7,251,000 Fire -Rescue Transfers -IN 2,893 * 3,000 3,000 Intergovernmental Revenues 7,476,000 4,729,858 63.27% 8,909,000 1,433,000 Licenses and Permits 2,438,000 2,105,218 86.35% 2,289,000 (149,000) Other Revenues (Inflows) 3,790,000 3,407,219 89.90% 4,256,000 466,000 Charges for Services 13,743,000 13,723,136 99.86% 16,418,000 2,675,000 Total: 27,447,000 23,968,324 87.33% 31,875,000 4,428,000 Police Transfers -IN 1,223,281 * 1,224,000 1,224,000 Fines and Forfeitures 5,067,000 3,924,797 77.46% 5,770,000 703,000 Intergovernmental Revenues 6,000,000 6,000,000 100.00% 6,000,000 0 Licenses and Permits 295,000 185,487 62.88% 252,000 (43,000) Other Revenues (Inflows) 42,000 161,103 383.58% 187,000 145,000 Charges for Services 4,954,000 3,733,473 75.36% 4,860,000 (94,000) Total: 16,358,000 15,228,142 93.09% 18,293,000 1,935,000 Run Date 07/14/2023 Run Time: 5:31:23 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Police Real Estate and Asset Management Fines and Forfeitures 58,000 43,741 75.41% 73,000 15,000 Intergovernmental Revenues 2,000 - * 0 (2,000) Licenses and Permits 158,000 46,424 29.38% 69,000 (89,000) Other Revenues (Inflows) 342,000 281,466 82.30% 323,000 (19,000) Charges for Services 31,274,000 32,873,018 105.11% 41,662,000 10,388,000 Total: 31,834,000 33,244,648 104.43% 42,127,000 10,293,000 Parks and Recreation Licenses and Permits 5,147 * 5,000 5,000 Other Revenues (Inflows) 300,000 223,251 74.42% 271,000 (29,000) Charges for Services 6,489,000 2,910,524 44.85% 3,428,000 (3,061,000) Total: 6,789,000 3,138,921 46.24% 3,704,000 (3,085,000) Risk Management Other Revenues (Inflows) 40 * * Total: 40 * Non -Departmental Transfers -IN 300,000 325,435 108.48% 325,000 25,000 Other Revenues (Inflows) 22,073,000 397,803 1.80% 469,000 (21,604,000) Total: 22,373,000 723,239 3.23% 794,000 (21,579,000) All Organizations Property Taxes 490,546,000 474,776,196 96.79% 476,999,000 (13,547,000) Franchise Fees and Other Taxes 124,167,000 81,565,922 65.69% 134,145,000 9,978,000 Interest 19,707,000 22,860,869 116.00% 23,268,000 3,561,000 Transfers -IN 14,898,000 8,523,708 57.21% 8,525,000 (6,373,000) Fines and Forfeitures 6,208,000 4,870,748 78.46% 7,010,000 802,000 Intergovernmental Revenues 99,876,000 61,528,678 61.61% 104,437,000 4,561,000 Licenses and Permits 78,451,000 77,295,051 98.53% 101,025,000 22,574,000 Other Revenues (Inflows) 28,261,000 5,509,024 19.49% 6,479,000 (21,782,000) Charges for Services 126,662,000 117,032,824 92.40% 143,591,000 16,929,000 Total: 988,776,000 853,963,019 86.37% 1,005,479,000 16,703,000 Run Date 07/14/2023 Run Time: 5:31:23 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Personnel 2,561,000 1,927,378 Operating Expense 571,000 288,445 Capital Outlay 19,209 Transfers - OUT 20,000 75.26% 50.52% * * 2,361,000 572,000 19,000 20,000 200,000 (1,000) (19,000) (20,000) Total: 3,132,000 2,255,032 72.00% 2,972,000 160,000 Commissioners Personnel 7,215,000 5,285,961 Operating Expense 3,401,000 1,053,035 Capital Outlay 2,068 Transfers - OUT 98,764 73.26% 30.96% * * 6,490,000 1,304,000 2,000 99,000 725,000 2,097,000 (2,000) (99,000) Total: 10,616,000 6,439,828 60.66% 7,895,000 2,721,000 City Manager Personnel 3,745,000 2,858,555 76.33% 3,567,000 178,000 Operating Expense 620,000 858,595 138.48% 735,000 (115,000) Non -Operating Expenses 1,871,000 249,503 13.34% 873,000 998,000 Total: 6,236,000 3,966,653 63.61% 5,175,000 1,061,000 Office of Agenda Coordination Personnel 369,000 288,930 78.30% 348,000 21,000 Operating Expense 17,000 14,779 86.94% 16,000 1,000 Total: 386,000 303,710 78.68% 364,000 22,000 Independent Auditor General Personnel 1,649,000 1,224,953 Operating Expense 125,000 63,868 Capital Outlay 2,000 74.28% 51.09% * 1,486,000 89,000 2,000 163,000 36,000 0 Total: 1,776,000 1,288,821 72.57% 1,577,000 199,000 City Attorney Personnel 11,701,000 9,245,825 79.02% 11,409,000 292,000 Operating Expense 578,000 456,079 78.91% 556,000 22,000 Total: 12,279,000 9,701,904 79.01% 11,965,000 314,000 City Clerk Run Date 07/15/2023 Run Time: 12:20:53 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 City Clerk Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Personnel 1,779,000 1,485,010 83.47% 1,781,000 Operating Expense 373,000 247,367 66.32% 342,000 Total: 2,152,000 1,732,377 80.50% 2,123,000 31,000 29,000 Civil Service Board Personnel 568,000 470,255 82.79% 567,000 Operating Expense 54,000 40,622 75.23% 55,000 Total: 622,000 510,876 82.13% 622,000 1,000 0 Code Compliance Personnel 9,372,000 7,610,570 81.21% 9,060,000 312,000 Operating Expense 1,321,000 1,133,937 85.84% 1,291,000 30,000 Capital Outlay 20,000 (8) (0.04%) 20,000 0 Non -Operating Expenses 66 * Total: 10,713,000 8,744,565 81.63% 10,371,000 342,000 Office of Communications Personnel 1,319,000 958,151 72.64% 1,198,000 121,000 Operating Expense 252,000 204,754 81.25% 237,000 15,000 Total: 1,571,000 1,162,905 74.02% 1,435,000 136,000 Equal Opportunity and Diversity Programs Personnel 579,000 478,869 82.71% 575,000 4,000 Operating Expense 40,000 20,397 50.99% 28,000 12,000 Total: 619,000 499,266 80.66% 603,000 16,000 Finance Personnel 10,067,000 8,046,101 79.93% 9,717,000 350,000 Operating Expense 2,291,000 1,647,173 71.90% 1,966,000 325,000 Total: 12,358,000 9,693,274 78.44% 11,683,000 675,000 Grants Administration Personnel 1,888,000 1,047,225 55.47% 1,675,000 213,000 Operating Expense 137,000 74,477 54.36% 131,000 6,000 Total: 2,025,000 1,121,702 55.39% 1,806,000 219,000 Human Resources Run Date 07/15/2023 Run Time: 12:20:53 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Human Resources Personnel 5,760,000 4,593,464 79.75% 5,574,000 186,000 Operating Expense 273,000 299,346 109.65% 340,000 (67,000) Total: 6,033,000 4,892,810 81.10% 5,914,000 119,000 Innovation and Technology Personnel 14,906,000 11,844,343 79.46% 14,305,000 601,000 Operating Expense 804,000 491,114 61.08% 520,000 284,000 Total: 15,710,000 12,335,457 78.52% 14,825,000 885,000 Management and Budget Personnel 2,939,000 2,306,720 78.49% 2,888,000 51,000 Operating Expense 235,000 112,759 47.98% 181,000 54,000 Total: 3,174,000 2,419,479 76.23% 3,069,000 105,000 Procurement Personnel 3,139,000 2,448,252 77.99% 2,963,000 176,000 Operating Expense 302,000 143,545 47.53% 303,000 (1,000) Capital Outlay 10,000 - * 10,000 0 Total: 3,451,000 2,591,797 75.10% 3,276,000 175,000 Office of Resilience and Sustainability Personnel 842,000 643,670 76.45% 814,000 28,000 Operating Expense 220,000 26,808 12.19% 137,000 83,000 Total: 1,062,000 670,478 63.13% 951,000 111,000 Human Services Personnel 5,278,000 4,101,727 Operating Expense 1,346,000 2,453,096 Capital Outlay 0 77.71% 182.25% * 4,833,000 2,145,000 75,000 445,000 (799,000) (75,000) Total: 6,624,000 6,554,823 98.96% 7,053,000 (429,000) Building Department Personnel 23,772,000 17,244,022 72.54% 21,388,000 2,384,000 Operating Expense 3,494,000 5,109,342 146.23% 6,711,574 (3,217,574) Non -Operating Expenses 915 * 1,000 (1,000) Total: 27,266,000 22,354,279 81.99% 28,100,574 (834,574) Run Date 07/15/2023 Run Time: 12:20:53 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Personnel 5,571,000 4,078,077 73.20% 4,988,000 583,000 Operating Expense 890,000 624,575 70.18% 768,000 122,000 Total: 6,461,000 4,702,652 72.79% 5,756,000 705,000 Zoning Personnel 4,945,000 3,822,659 77.30% 4,655,000 290,000 Operating Expense 901,000 508,505 56.44% 620,000 281,000 Capital Outlay 3,000 0 0.00% 1,000 2,000 Total: 5,849,000 4,331,164 74.05% 5,276,000 573,000 General Services Administration Personnel 17,579,000 14,200,753 Operating Expense 15,059,000 12,892,135 Capital Outlay (2,982) 80.78% 85.61% * 16,752,000 827,000 15,673,000 (614,000) Total: 32,638,000 27,089,906 83.00% 32,425,000 213,000 Total Resilience and Public Works Department Personnel 16,889,000 13,347,276 Operating Expense 15,021,000 8,846,716 Capital Outlay 18,883 79.03% 58.90% * 16,985,000 14,102,000 20,000 (96,000) 919,000 (20,000) Total: 31,910,000 22,212,875 69.61% 31,107,000 803,000 Solid Waste Personnel 26,762,000 21,442,777 80.12% 25,792,000 970,000 Operating Expense 17,611,000 13,694,526 77.76% 18,769,000 (1,158,000) Capital Outlay 71,332 * 77,000 (77,000) Non -Operating Expenses 9,428 * 9,000 (9,000) Total: 44,373,000 35,218,064 79.37% 44,647,000 (274,000) Capital Improvements and Transportation Personnel 3,602,000 3,093,077 85.87% 3,228,000 374,000 Operating Expense 323,000 258,416 80.01% 290,000 33,000 Total: 3,925,000 3,351,494 85.39% 3,518,000 407,000 Fire -Rescue Personnel 162, 719,000 133,016,113 Operating Expense 19,266,000 15,576,869 81.75% 80.85% 169,395,000 20, 328,000 (6,676,000) (1,062,000) Run Date 07/15/2023 Run Time: 12:20:53 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Fire -Rescue Capital Outlay 300,000 54,267 18.09% 300,000 0 Non -Operating Expenses 1,508,000 (0.02%) 1,611,000 (103,000) Transfers - OUT 7,554 * 8,000 (8,000) Total: 183,793,000 148,654,471 80.88% 191,642,000 (7,849,000) Police Personnel 240,585,000 195,250,440 81.16% 240,315,000 270,000 Operating Expense 46,824,000 38,495,098 82.21% 44,915,000 1,909,000 Capital Outlay 118,000 128,786 109.14% 129,000 (11,000) Transfers - OUT 17,468 * 18,000 (18,000) Total: 287,527,000 233,891,792 81.35% 285,377,000 2,150,000 Housing and Community Development Department Personnel 1,344,000 1,303,203 96.96% 1,344,000 0 Operating Expense 489,000 424,296 86.77% 489,000 0 Total: 1,833,000 1,727,499 94.24% 1,833,000 0 Real Estate and Asset Management Personnel 5,482,000 4,302,787 78.49% 5,256,000 226,000 Operating Expense 12,429,000 10,404,161 83.71% 12,651,000 (222,000) Capital Outlay 50,000 - * 0 50,000 Total: 17,961,000 14,706,948 81.88% 17,907,000 54,000 Parks and Recreation Personnel 40,691,000 31,747,566 78.02% 38,916,000 1,775,000 Operating Expense 19,437,000 14,853,469 76.42% 19,423,000 14,000 Capital Outlay 18,919 * 19,000 (19,000) Non -Operating Expenses 293,000 229,914 78.47% 266,000 27,000 Total: 60,421,000 46,849,867 77.54% 58,624,000 1,797,000 Risk Management Personnel 3,232,000 2,416,734 74.78% 2,963,000 269,000 Operating Expense 903,000 329,102 36.45% 510,000 393,000 Total: 4,135,000 2,745,836 66.40% 3,473,000 662,000 Non -Departmental Personnel 15,039,000 9,567,571 63.62% 16,201,000 (1,162,000) Run Date 07/15/2023 Run Time: 12:20:53 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 Amended Year to Date YTD Act. to Year End YE Proj. to Actual Budget (%) Projected Budget ($) Non -Departmental Operating Expense 10,161,000 8,712,784 85.75% 13,655,000 (3,494,000) Capital Outlay 40 * 0 0 Non -Operating Expenses 17,707,000 3,460,862 19.55% 4,636,000 13,071,000 Transfers - OUT 137,238,000 137,238,000 100.00% 137,238,000 0 Total: 180,145,000 158,979,256 88.25% 171,730,000 8,415,000 All Organizations Personnel 653,888,000 521,699,013 79.78% 649,865,000 4,023,000 Operating Expense 175,768,000 140,360,191 79.86% 179,104,574 (3,336,574) Capital Outlay 503,000 310,513 61.73% 749,000 (246,000) Non -Operating Expenses 21,379,000 3,950,355 18.48% 6,454,000 14,925,000 Transfers - OUT 137,238,000 137,381,786 100.10% 137,383,000 (145,000) Total: 988,776,000 803,701,859 81.28% 973,555,574 15,220,426 Run Date 07/15/2023 Run Time: 12:20:53 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(Jun)) Amended Variance YTD Act. to Year End Favorable / Actual Budget (%) Projection (Unfavorable) Revenues Property Taxes 490,546,000 474,776,196 96.79% 476,999,000 Franchise Fees and Other Taxes 124,167,000 81,565,922 65.69% 134,145,000 9,978,000 Interest 19,707,000 22,860,869 116.00% 23,268,000 3,561,000 Transfers -IN 14,898,000 8,523,708 57.21% 8,525,000 (6,373,000) Fines and Forfeitures 6,208,000 4,870,748 78.46% 7,010,000 802,000 Intergovernmental Revenues 99,876,000 61,528,678 61.61% 104,437,000 4,561,000 Licenses and Permits 78,451,000 77,295,051 98.53% 101,025,000 22,574,000 Other Revenues (Inflows) 28,261,000 5,509,024 19.49% 6,479,000 (21,782,000) Charges for Services 126,662,000 117,032,824 92.40% 143,591,000 16,929,000 Total Revenues 988,776,000 853,963,019 86.37% 1,005,479,000 16,703,000 Expenditures Mayor 3,132,000 2,255,032 72.00% 2,972,000 160,000 Commissioners 10,616,000 6,439,828 60.66% 7,895,000 2,721,000 City Manager 6,236,000 3,966,653 63.61% 5,175,000 1,061,000 Office of Agenda Coordination 386,000 303,710 78.68% 364,000 22,000 Independent Auditor General 1,776,000 1,288,821 72.57% 1,577,000 199,000 City Attorney 12,279,000 9,701,904 79.01% 11,965,000 314,000 City Clerk 2,152,000 1,732,377 80.50% 2,123,000 29,000 Civil Service Board 622,000 510,876 82.13% 622,000 0 Code Compliance 10,713,000 8,744,565 81.63% 10,371,000 342,000 Office of Communications 1,571,000 1,162,905 74.02% 1,435,000 136,000 Equal Opportunity and Diversity Programs 619,000 499,266 80.66% 603,000 16,000 Finance 12,358,000 9,693,274 78.44% 11,683,000 675,000 Grants Administration 2,025,000 1,121,702 55.39% 1,806,000 219,000 Human Resources 6,033,000 4,892,810 81.10% 5,914,000 119,000 Innovation and Technology 15,710,000 12,335,457 78.52% 14,825,000 885,000 Management and Budget 3,174,000 2,419,479 76.23% 3,069,000 105,000 Procurement 3,451,000 2,591,797 75.10% 3,276,000 175,000 Office of Resilience and Sustainability 1,062,000 670,478 63.13% 951,000 111,000 Human Services 6,624,000 6,554,823 98.96% 7,053,000 (429,000) General Government 100,539,000 76,885,757 76.47% 92,140,000 8,399,000 Building Department 27,266,000 22,354,279 81.99% 28,100,574 (834,574) Planning 6,461,000 4,702,652 72.79% 5,756,000 705,000 Zoning 5,849,000 4,331,164 74.05% 5,276,000 573,000 Run Date 07/15/2023 Run Time: 12:41:43 PM Page 1 of 2 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(Jun)) Planning and Development Housing and Community Development Department Housing and Community Development General Services Administration Total Resilience and Public Works Department Solid Waste Capital Improvements and Transportation Public Works Fire -Rescue Police Public Safety 950101- Office of Civilian Investigative Panel Civilian Investigative Panel Non -Departmental Non Departmental Units Real Estate and Asset Management Parks and Recreation Risk Management Total Other Total Expenditures Total Revenues Over/(Under) Expenditures Amended YTD Act. to Actual Budget (%) Year End Projection ti .,., 15[C!! 11 :1 I. A. qt- Variance Favorable / (Unfavorable) 39,576,000 31,388,094 1,833,000 1,727,499 79.31% 39,132,574 94.24% 1,833,000 443,426 0 1,833,000 1,727,499 94.24% 1,833,000 0 32,638,000 27,089,906 31,910,000 44,373,000 3,925,000 22,212,875 35,218,064 3,351,494 83.00% 32,425,000 69.61% 79.37% 85.39% 31,107,000 44, 647,000 3,518,000 213,000 803,000 (274,000) 407,000 112,846,000 183,793,000 287,527,000 471,320,000 87,872,338 148,654,471 233,891,792 382, 546, 263 77.87% 80.88% 81.35% 81.16% 111,697,000 191, 642,000 285,377,000 477,019,000 1,149,000 (7,849,000) 2,150,000 (5,699,000) 0 0 180,145,000 180,145,000 17,961,000 60,421,000 4,135,000 158,979,256 158,979,256 14,706,948 46,849,867 2,745,836 88.25% 88.25% 81.88% 77.54% 66.40% 171,730,000 8,415,000 171,730,000 8,415,000 17,907,000 54,000 58,624,000 1,797,000 3,473,000 662,000 82,517,000 988,776,000 64, 302, 651 803,701,859 77.93% 81.28% 80,004,000 973,555,574 2,513,000 15,220,426 0 50,261,159 31,923,426 Run Date 07/15/2023 Run Time: 12:41:43 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(Jun)) Revenues Transfers -IN Other Revenues (Inflows) Charges for Services Total Revenues Expenditures Innovation and Technology General Government Risk Management Total Other Total Expenditures Total Revenues Over/(Under) Expenditures Amended Variance YTD Act. to Year End Favorable / Actual Budget (%) Projection (Unfavorable) - 20,512 * 21,000 104,830,000 96,781,158 92.32% 98,644,000 60,000 86,137 143.56% 119,000 21,000 59,000 104,890,000 96,887,807 92.37% 98,784,000 14,808,000 9,734,268 65.74% 12,837,000 1,971,000 14,808,000 90,082,000 90,082,000 104,890,000 9,734,268 71,483,185 71,483,185 81,217,453 65.74% 12,837,000 79.35% 93,810,000 79.35% 93,810,000 77.43% 106,647,000 1,971,000 (3,728,000) (3,728,000) (1,757,000) 0 15, 670, 354 (7,863,000) Run Date 07/15/2023 Run Time: 12:27:34 PM Page 1 of 1 003 Projection ROE for Specified Fund - One Pager Style