Full Text
Millcreek FY 2021-22 Budget Amendment #4 December 20, 2021 ---PAGE BREAK--- Millcreek FY 2021-22 General Fund – Amendment #4 ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Received % Received 100 GENERAL FUND 3100 TAXES 3110 Property Tax 12 Months of UPD Contract + costs of borrowing 11,075,860 11,075,860 11,075,860 11,075,860 11,075,860 - 5,988,053 54.06% 3120 Sales & Use Tax General 10,000,000 10,000,000 11,901,521 11,901,521 12,150,000 248,479 3,520,272 28.97% 3125 Mass Transit Tax 750,000 750,000 750,000 750,000 850,000 100,000 315,437 37.11% 3130 Franchise Tax Cable Tax 550,000 550,000 550,000 550,000 550,000 - 139,106 25.29% 3140 Transient Room Tax 1,500 1,500 1,500 1,500 4,500 3,000 1,371 30.47% Total Taxes 22,377,360 $ 22,377,360 $ 24,278,881 $ 24,278,881 $ 24,630,360 $ 351,479 $ 9,964,239 $ 40.46% 3200 LICENSES & PERMITS 3210 Business Licenses & Permits 550,000 550,000 550,000 550,000 550,000 - 222,874 40.52% 3220 Building Permits 1,200,000 1,200,000 1,200,000 1,200,000 1,100,000 (100,000) 433,864 39.44% 3230 Special Event Permits 500 500 500 2,000 2,000 - 950 47.50% 3240 Engineering Permits 350,000 350,000 350,000 475,000 500,000 25,000 261,578 52.32% Total Licenses & Permits 2,100,500 $ 2,100,500 $ 2,100,500 $ 2,227,000 $ 2,152,000 $ (75,000) $ 919,266 $ 42.72% 3300 INTERGOVERNMENTAL 3310 Local Grants - - - - - - - 0.00% 3320 State Grants - - 3,000 3,000 43,034 40,034 43,034 100.00% Thrive 125 Grant LeRay McCallister Grant 3330 Liquor Grants 45,000 45,000 45,000 45,000 45,000 - - 0.00% 3350 Federal Grants - 1,694,089 1,694,089 1,694,089 3,964,825 2,270,736 1,694,089 42.73% American Recovery Act Funds Fund 111 Class C Road Funds 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 - 726,601 40.37% Total Intergovernmental 1,845,000 $ 3,539,089 $ 3,542,089 $ 3,542,089 $ 5,852,859 $ 2,310,770 $ 2,463,724 $ 42.09% MILLCREEK FY 2021-22 GENERAL FUND REVENUE BUDGET ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Received % Received 100 GENERAL FUND Total Intergovernmental 1,845,000 $ 3,539,089 $ 3,542,089 $ 3,542,089 $ 5,852,859 $ 2,310,770 $ 2,463,724 $ 42.09% 3400 CHARGES FOR SERVICES 3410 Planning Fees 70,000 70,000 70,000 70,000 75,000 5,000 46,718 62.29% 3420 Engineering Fees - - - - - - - 0.00% 3430 Rents & Leases - - - - - - - 0.00% 3470 Park Impact Fees - - - - - - - 0.00% Total Charges For Services 70,000 $ 70,000 $ 70,000 $ 70,000 $ 75,000 $ 5,000 $ 46,718 $ 62.29% 3500 FINES & FORFEITURES 3510 Court Fines - - - - - - - 0.00% 3520 Code Compliance Fines 5,000 5,000 5,000 7,500 10,000 2,500 7,466 74.66% Total Fines & Forfeitures 5,000 $ 5,000 $ 5,000 $ 7,500 $ 10,000 $ 2,500 $ 7,466 $ 74.66% 3600 MISCELLANEOUS 3610 Interest Earnings 100,000 100,000 100,000 90,000 70,000 (20,000) 28,758 41.08% 3620 Misc. Income - - - 4,800 14,092 9,292 14,092 100.00% 3630 Administrative Fees 110,000 110,000 110,000 110,000 110,000 - 45,833 41.67% 3690 Bond Proceeds - - - 39,243,823 39,243,823 - 39,243,823 100.00% Total Miscellaneous 210,000 $ 210,000 $ 210,000 $ 39,448,623 $ 39,437,915 $ (10,708) $ 39,332,506 $ 99.73% 3800 CONTRIBUTIONS 3810 Donations - - - 200 27,448 27,248 27,448 100.00% Promise Program Donations FY21 Donation for Community Renewable Energy 3820 Use of Fund Balance 1,085,573 1,085,573 1,243,973 1,964,351 1,964,351 - - 0.00% General Fund - - - - UPD Contract 1,085,573 1,085,573 1,243,973 1,964,351 1,934,351 - Total Other Contributions 1,085,573 $ 1,085,573 $ 1,243,973 $ 1,964,551 $ 1,991,799 $ 27,248 $ 27,448 $ 1.38% Total General Fund Revenues 27,693,433 $ 29,387,522 $ 31,450,443 $ 71,538,644 $ 74,149,933 $ 2,611,289 $ 52,761,367 $ 71.15% MILLCREEK FY 2021-22 GENERAL FUND REVENUE BUDGET ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4200 ADMINISTRATION 100-4210 City Management Personnel Services 1100 Salaries & Wages 138,000 140,500 140,500 140,500 165,000 24,500 56,128 108,872 65.98% Assistant City Manager 1200 Part-Time Wages - - - - - - - - 0.00% 1400 Employee Benefits 48,000 48,000 48,000 48,000 56,000 8,000 12,862 43,138 77.03% Total Personnel 186,000 188,500 188,500 188,500 221,000 32,500 68,989 $ 152,011 $ 68.78% Operating Expenses 2100 Books, Subscriptions, Memb. 1,500 1,500 1,500 1,500 1,500 - - 1,500 100.00% 2300 Travel 2,000 2,000 2,000 2,000 2,000 - - 2,000 100.00% 2400 Office Supplies - - - - 0.00% Total Operating 3,500 3,500 3,500 3,500 3,500 - - $ 3,500 $ 100.00% Professional & Contracted Services 3100 Professional Services 5,000 5,000 5,000 5,000 5,000 - - 5,000 100.00% Various 3300 Training 3,000 3,000 3,000 3,000 3,000 - - 3,000 100.00% Total Professional & Contracted 8,000 8,000 8,000 8,000 8,000 - - $ 8,000 $ 100.00% Miscellaneous Expenses 6100 Misc. Expenses 5,000 5,000 5,000 5,000 5,000 - 1,358 3,642 72.83% Total Misc. 5,000 5,000 5,000 5,000 5,000 - 1,358 $ 3,642 $ 72.83% Total City Management 202,500 $ 205,000 $ 205,000 $ 205,000 $ 237,500 $ 32,500 $ 70,348 $ 167,152 $ 70.38% Notes: Department Budget Personnel expense projections increased due to promotion of Assistant City Manager to City Manager. ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4200 ADMINISTRATION 100-4230 Legal Services Personnel Services 1100 Salaries & Wages - - - - - - - - 0.00% 1200 Part-Time Wages - - - - - - - - 0.00% 1400 Employee Benefits - - - - - - - - 0.00% Total Personnel - - - - - - - $ - $ 0.00% Operating Expenses 2100 Books, Subscriptions, Memb. - - - - - - - - 0.00% 2300 Travel - - - - - - - - 0.00% Total Operating - - - - - - - $ - $ 0.00% Professional & Contracted Services 3100 Professional Services 165,000 167,500 167,500 167,500 180,000 12,500 90,199 89,801 49.89% John Brems Misc. Legal 3300 Training 2,000 2,000 2,000 2,000 2,000 - 779 1,221 61.07% 3200 Contracted Services 335,000 335,000 335,000 335,000 335,000 - 73,527 261,473 78.05% SL County Indigent Defense 112,558 SL County Prosecutorial Services 220,000 Total Professional & Contracted 502,000 504,500 504,500 504,500 517,000 12,500 164,505 $ 352,495 $ 68.18% Misc. Expenses 6100 Misc. Expenses 250 250 250 250 250 - 8 242 96.82% Total Misc. 250 250 250 250 250 - 8 $ 242 $ 96.82% Total Legal Services 502,250 $ 504,750 $ 504,750 $ 504,750 $ 517,250 $ 12,500 $ 164,513 $ 352,737 $ 68.19% Notes: Department Budget Professional services line item increased due to higher expense projections. ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4200 ADMINISTRATION 100-4240 Public Safety Professional & Contracted Services 3200 Contracted Services SLC Animal Control 565,000 565,000 565,000 565,000 565,000 - 153,531 411,469 72.83% 12 Months of Contract Unified Police 12,080,000 12,080,000 12,238,400 13,040,211 11,700,622 (1,339,589) 4,502,855 7,197,767 61.52% CARES Act (UPD) - - - - - - - - 0.00% American Recovery Act (UPD) - - - - 1,339,589 1,339,589 506,250 833,339 0.00% CARES Act (UPD Payroll) - - - - - - - - 0.00% American Recovery Act (UFA) - 130,261 130,261 - - - - - 0.00% American Recovery Act - 9,328 9,328 - - - - - 0.00% UPD (Alcohol Tax Exp) 45,000 45,000 45,000 45,000 45,000 - - 45,000 100.00% Total Professional & Contracted 12,690,000 12,829,589 12,987,989 13,650,211 13,650,211 - 5,162,636 $ 8,487,575 $ 62.18% Total Public Safety 12,690,000 $ 12,829,589 $ 12,987,989 $ 13,650,211 $ 13,650,211 $ - $ 5,162,636 $ 8,487,575 $ 62.18% Notes: Department Budget ARPA funds utilized to pay a portion of UPD contract. ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4200 ADMINISTRATION 100-4250 Promise Program Personnel Services 1100 Salaries & Wages 70,000 71,000 71,000 71,000 71,000 - 25,731 45,269 63.76% Promise Program Manager 1200 Part-Time Wages - - - - 30,250 30,250 - 30,250 0.00% 1300 Over-Time Wages 1,500 1,500 1,500 1,500 1,500 - - 1,500 100.00% 1400 Employee Benefits 25,800 25,800 25,800 25,800 35,000 9,200 8,813 26,187 74.82% Total Personnel 97,300 $ 98,300 $ 98,300 $ 98,300 $ 137,750 $ 39,450 $ 34,544 $ 103,206 $ 74.92% Operating Expenses 2100 Books, Subscriptions, Memb. 750 750 750 750 750 - - 750 100.00% 2300 Travel 1,500 1,500 1,500 1,500 1,500 - - 1,500 100.00% 2400 Office Supplies 200 200 200 200 200 - - 200 100.00% 2500 Equipment/Supplies 500 500 500 500 500 - - 500 100.00% Total Operating 2,950 2,950 2,950 2,950 2,950 - - $ 2,950 $ 100.00% Professional & Contracted Services 3100 Professional Services 1,000 1,000 1,000 1,000 1,000 - - 1,000 100.00% 3300 Training 500 500 500 500 500 - - 500 100.00% 3400 Printing 250 250 250 250 250 - - 250 100.00% Total Professional & Contracted 1,750 1,750 1,750 1,750 1,750 - - $ 1,750 $ 100.00% Miscellaneous Expenses 6100 Misc. Expenses 500 500 500 500 500 - 298 202 40.44% Total Misc. 500 500 500 500 500 - 298 $ 202 $ 40.44% Community Programs 8200 Events 7,500 157,500 157,500 157,700 120,498 (37,202) 613 119,885 99.49% American Recovery Act Funds - Misc. Donations Total Community Programs 7,500 157,500 157,500 157,700 120,498 (37,202) 613 $ 119,885 $ 99.49% Total Promise Program 110,000 $ 261,000 $ 261,000 $ 261,200 $ 263,448 $ 2,248 $ 35,455 $ 227,993 $ 86.54% Notes: Department Budget Recognition of donations received and event funds transferred to pay for part-time salaries. ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4310 City Recorder Personnel Services 1100 Salaries & Wages 76,000 78,500 78,500 81,000 81,000 - 33,799 47,201 58.27% City Recorder 1200 Part-Time Wages - - - - - - - - 0.00% 1400 Employee Benefits 35,000 35,000 35,000 35,000 35,000 - 7,395 27,605 78.87% Total Personnel 111,000 113,500 113,500 116,000 116,000 - 41,194 $ 74,806 $ 64.49% Operating Expenses 2100 Books, Subscriptions, Memb. 500 500 500 600 600 - 565 35 5.83% 2300 Travel 1,500 1,500 1,500 1,500 1,500 - 20 1,480 98.67% 2400 Office Supplies - - - - - - - - 0.00% 2800 Postage & Shipping - - - - - - - - 0.00% Total Operating 2,000 2,000 2,000 2,100 2,100 - 585 $ 1,515 $ 72.14% Professional & Contracted Services 3100 Professional Services - - - - 0.00% 3200 Contracted Services 40,000 40,000 40,000 40,000 30,000 (10,000) - 30,000 100.00% SL County Elections 3300 Training 1,200 1,200 1,200 1,200 1,200 - 570 630 52.50% 3400 Printing - - - - - - - - 0.00% 3500 Advertising & Public Notices 10,000 10,000 10,000 8,500 8,500 - 368 8,132 95.67% Total Professional & Contracted 51,200 51,200 51,200 49,700 39,700 (10,000) 938 $ 38,762 $ 97.64% Miscellaneous Expenses 6100 Misc. Expenses 500 500 500 500 500 - 205 295 59.00% Total Misc. 500 500 500 500 500 - 205 $ 295 $ 59.00% Total City Recorder 164,700 $ 167,200 $ 167,200 $ 168,300 $ 158,300 $ (10,000) $ 42,921 $ 115,379 $ 72.89% Notes: Department Budget Decrease in SL County election expenses. ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4500 COMMUNICATIONS & PROGRAMS 100-4510 Communications & Programs Personnel Services 1100 Salaries & Wages 83,250 85,750 85,750 85,750 85,750 - 34,102 51,648 60.23% Communications & Programs Director 1200 Part-Time Wages - - - - - - - - 0.00% 1300 Over-Time Wages - - - - 0.00% 1400 Employee Benefits 37,000 37,000 37,000 37,000 37,000 - 13,190 23,810 64.35% Total Personnel 120,250 122,750 122,750 122,750 122,750 - 47,291 $ 75,459 $ 61.47% Operating Expenses 2100 Books, Subscriptions, Memb. 500 500 500 500 500 - 233 267 53.45% 2300 Travel 750 750 750 750 750 - - 750 100.00% 2500 Equipment/Supplies 2,500 2,500 2,500 2,500 2,500 - - 2,500 100.00% 2800 Postage & Shipping 45,000 45,000 45,000 45,000 45,000 - 11,470 33,530 74.51% Total Operating 48,750 48,750 48,750 48,750 48,750 - 11,703 $ 37,047 $ 75.99% Professional & Contracted Services 3100 Professional Services 35,000 35,000 35,000 35,000 35,000 - 2,870 32,130 91.80% 3300 Training 2,000 2,000 2,000 2,000 2,000 - - 2,000 100.00% 3400 Printing 75,000 75,000 75,000 75,000 75,000 - 7,360 67,640 90.19% Total Professional & Contracted 112,000 112,000 112,000 112,000 112,000 - 10,230 $ 101,770 $ 90.87% Miscellaneous Expenses 6100 Misc. Expenses 2,000 2,000 2,000 2,000 2,000 - 65 1,935 96.77% Total Misc. 2,000 2,000 2,000 2,000 2,000 - 65 $ 1,935 $ 96.77% Community Programs 8100 Community Councils 29,000 29,000 29,000 29,000 29,405 405 6,000 23,405 79.60% Canyon Rim 6,000 East Millcreek 5,000 Millcreek 15,000 Mt. Olympus 3,000 8200 Events 10,000 10,000 10,000 10,000 15,000 5,000 8,417 6,583 43.89% Utah Venture Out (Moved to Events Budget) - Youth City Council 5,000 Other 5,000 8300 Programs 6,250 106,250 106,250 106,250 106,250 - 47,000 59,250 55.76% Rain Barrel Program 6,250 6,250 6,250 6,250 6,250 Asian Association of Utah 100,000 100,000 100,000 100,000 Total Community Programs 45,250 145,250 145,250 145,250 150,655 5,405 61,417 $ 89,238 $ 59.23% Total Communications & Programs 328,250 $ 430,750 $ 430,750 $ 430,750 $ 436,155 $ 5,405 $ 130,706 $ 305,449 $ 70.03% Notes: Department Budget Events & Community Council increased to meet updated expense projections. ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4600 ECONOMIC DEVELOPMENT 100-4610 Economic Development Personnel Services 1100 Salaries & Wages 55,000 57,500 57,500 57,500 57,500 - 23,206 34,294 59.64% Asst. to Economic Dev. Director 1200 Part-Time Wages - - - - 10,000 10,000 - 10,000 100.00% 1300 Over-Time Wages 1,000 1,000 1,000 1,000 1,000 - - 1,000 100.00% 1400 Employee Benefits 25,000 25,000 25,000 25,000 25,000 - 8,254 16,746 66.98% Total Personnel 81,000 83,500 83,500 83,500 93,500 10,000 31,460 $ 62,040 $ 66.35% Operating Expenses 2100 Books, Subscriptions, Memb. 1,200 1,200 1,200 1,200 1,200 - 200 1,000 83.33% 2300 Travel 3,000 3,000 3,000 3,000 3,000 - 1,765 1,235 41.15% 2500 Equipment/Supplies 500 500 500 500 500 - 166 334 66.72% Total Operating 4,700 4,700 4,700 4,700 4,700 - 2,132 $ 2,568 $ 54.64% Professional & Contracted Services 3100 Professional Services 5,000 5,000 5,000 5,000 5,000 - - 5,000 100.00% 3300 Training 5,000 5,000 5,000 5,000 5,000 - 2,440 2,560 51.20% Total Professional & Contracted 10,000 10,000 10,000 10,000 10,000 - 2,440 $ 7,560 $ 75.60% Miscellaneous Expenses 6100 Misc. Expenses 7,500 7,500 7,500 7,500 7,500 - 932 6,568 87.58% 6400 Retail Promotion - - - - 0.00% Total Misc. 7,500 7,500 7,500 7,500 7,500 - 932 $ 6,568 $ 87.58% Department Budget ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-5700 EVENTS/MILLCREEK COMMON 100-5710 Events/Millcreek Common Personnel Services 1100 Salaries & Wages 95,000 96,000 96,000 96,000 96,000 - 35,673 60,327 62.84% Events/Millcreek Common Director 1200 Part-Time Wages 75,000 75,000 40,000 25,000 50,000 25,000 - 50,000 100.00% 1300 Over-Time Wages 2,500 2,500 2,500 2,500 2,500 - - 2,500 100.00% 1400 Employee Benefits 65,000 65,000 65,000 60,000 75,000 15,000 15,565 59,435 79.25% Total Personnel 237,500 238,500 203,500 183,500 223,500 40,000 51,238 $ 172,262 $ 77.07% Operating Expenses 2100 Books, Subscriptions, Memb. 500 500 500 500 500 - - 500 100.00% 2300 Travel 1,500 1,500 1,500 1,500 1,500 - - 1,500 100.00% 2500 Equipment/Supplies 3,500 3,500 3,500 3,500 45,000 41,500 120 44,880 99.73% Total Operating 5,500 5,500 5,500 5,500 47,000 41,500 120 $ 46,880 $ 99.74% Professional & Contracted Services 3100 Professional Services 5,000 5,000 40,000 60,000 110,000 50,000 27,000 83,000 75.45% 3300 Training 1,500 1,500 1,500 1,500 1,500 - - 1,500 100.00% Total Professional & Contracted 6,500 6,500 41,500 61,500 111,500 50,000 27,000 34,500 30.94% Miscellaneous Expenses 6100 Misc. Expenses 5,000 5,000 5,000 5,000 5,000 - - 5,000 100.00% Total Misc. 5,000 5,000 5,000 5,000 5,000 - - $ 5,000 $ 100.00% Community Programs 8200 Events 150,000 150,000 153,000 153,000 200,000 47,000 151,280 48,720 24.36% Utah Venture Out Thrive 125 Grant (Camp Tracy) Millcreek Anniversary Event 8300 Programs 20,000 20,000 20,000 20,000 - (20,000) - - 0.00% Total Community Programs 170,000 $ 170,000 $ 173,000 $ 173,000 $ 200,000 $ 27,000 $ 151,280 $ 48,720 $ 24.36% Total Events/Millcreek Common 424,500 $ 425,500 $ 428,500 $ 428,500 $ 587,000 $ 158,500 $ 229,638 $ 307,362 $ 52.36% Notes: Various line items adjusted based on updated needs. Department Budget ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4700 FINANCE 100-4710 Finance Personnel Services 1100 Salaries & Wages 285,000 293,500 293,500 293,500 348,000 54,500 68,792 279,208 80.23% HR-Finance Director Assistant Finance Director HR Manager HR-Finance Technician CDBG/Grant Administrator 1200 Part-Time Wages - - - - - - - - 0.00% 1400 Employee Benefits 170,000 170,000 170,000 170,000 160,000 (10,000) 32,990 127,010 79.38% Total Personnel 455,000 463,500 463,500 463,500 508,000 44,500 101,782 $ 406,218 $ 79.96% Operating Expenses 2100 Books, Subscriptions, Memb. 250 250 250 250 250 - - 250 100.00% 2300 Travel 500 500 500 500 500 - 38 462 92.42% 2400 Office Supplies 250 250 250 250 250 - 139 112 44.60% 2500 Equipment/Supplies 250 250 250 250 250 - 394 (144) -57.61% Total Operating 1,250 1,250 1,250 1,250 1,250 - 570 $ 680 $ 54.37% Professional & Contracted Services 3100 Professional Services 5,000 5,000 5,000 5,000 25,000 20,000 - 25,000 100.00% 3300 Training 7,500 7,500 7,500 7,500 7,500 - 100 7,400 98.67% 3400 Printing - - - - - - - - 0.00% Total Professional & Contracted 12,500 12,500 12,500 12,500 32,500 20,000 100 $ 32,400 $ 99.69% Miscellaneous Expenses 6100 Misc. Expenses 1,000 1,000 1,000 1,000 1,000 - 385 615 61.54% Total Misc. 1,000 1,000 1,000 1,000 1,000 - 385 $ 615 $ 61.54% Total Finance 469,750 $ 478,250 $ 478,250 $ 478,250 $ 542,750 $ 64,500 $ 102,837 $ 439,913 $ 81.05% Notes: Salaries & Prof. Services increased due to updated expense projections. Department Budget ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4730 Non-Departmental Insurance 4100 Liability Insurance 85,000 85,000 85,000 85,000 85,000 - - 85,000 100.00% Total Insurance 85,000 85,000 85,000 85,000 85,000 - - $ 85,000 $ 100.00% Debt Service 5100 Bond Principal Payments - - 840,000 840,000 840,000 - - 840,000 100.00% 5200 Debt Interest - - 938,361 938,361 938,361 - - 938,361 100.00% 5300 Debt Related Fees - - - 243,823 243,823 - 243,823 - 0.00% Series 2021 Sales Tax Bond Total Debt Service - - 1,778,361 2,022,184 2,022,184 - 243,823 $ 1,778,361 $ 87.94% Miscellaneous Expenses 6100 Misc. Expenses 35,000 35,000 35,000 33,767 33,767 - 1,049 32,718 96.89% 6200 Bank Charges 55,000 55,000 55,000 55,000 65,000 10,000 23,223 41,777 64.27% Total Misc. 90,000 90,000 90,000 88,767 98,767 10,000 24,273 $ 74,494 $ 75.42% Other Financing Uses 9100 Contribution to Fund Balance 1,206,923 1,206,923 1,206,923 1,206,923 1,207,789 866 - 1,207,789 100.00% 9200 Due Other Govt. Entity 61,000 61,000 61,000 61,000 61,000 - - 61,000 100.00% 9300 Transfer to CIP Fund 81,860 1,281,860 1,281,860 40,421,449 42,692,185 2,270,736 - 42,692,185 100.00% American Recovery Act Funds City Hall Bond Funds 9400 Transfer to Stormwater Fund 5,000 13,750 13,750 13,750 13,750 - 8,750 5,000 36.36% Total Other Financing Uses 1,354,783 2,563,533 2,563,533 41,703,122 43,974,724 2,271,602 8,750 $ 43,965,974 $ 99.98% Total Non-Departmental 1,529,783 $ 2,738,533 $ 4,516,894 $ 43,899,073 $ 46,180,675 $ 2,281,602 $ 276,846 $ 45,903,829 $ 99.40% Notes: Bank charges line item increased and the remainder of the City's ARPA funds transferred to CIP Fund. Department Budget ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-4830 Fleet Operating Expenses 2500 Equipment/Supplies 2,500 2,500 2,500 4,000 10,000 6,000 4,618 5,382 53.82% 2650 Vehicle Maintenance 10,000 10,000 10,000 10,000 25,000 15,000 13,577 11,423 45.69% 2900 Fuel 20,000 20,000 20,000 25,500 30,000 4,500 9,612 20,388 67.96% Total Operating Expenses 32,500 32,500 32,500 39,500 65,000 25,500 27,807 $ 37,193 $ 57.22% Capital Expenses 7500 Vehicles 35,000 35,000 35,000 28,000 28,000 - 27,686 314 1.12% Total Capital Expenses 35,000 35,000 35,000 28,000 28,000 - 27,686 $ 314 $ 1.12% Total Fleet 67,500 $ 67,500 $ 67,500 $ 67,500 $ 93,000 $ 25,500 $ 55,493 $ 37,507 $ 40.33% Notes: Various line items increased due to higher expense projections. Department Budget ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amount of Change Total Expenditures Budget Available % Budget Available (58% of budget year remaining) 100-5100 PUBLIC WORKS 100-5110 Public Works Personnel Services 1100 Salaries & Wages 426,400 438,650 438,650 438,650 438,650 - 159,635 279,015 63.61% Public Works Director Staff Engineer I Public Works Operations Manager Public Works Inspector II GIS/Website Technician Permit Technician (50%) 1200 Part-Time Wages 12,000 12,000 12,000 12,000 12,000 - 4,866 7,134 59.45% 1300 Over-Time Wages 7,500 7,500 7,500 7,500 7,500 - 290 7,210 96.14% 1400 Employee Benefits 208,000 208,000 208,000 208,000 208,000 - 62,522 145,478 69.94% Total Personnel 653,900 666,150 666,150 666,150 666,150 - 227,312 $ 438,838 $ 65.88% Operating Expenses 2100 Books, Subscriptions, Memb. 7,500 7,500 7,500 7,500 7,500 - - 7,500 100.00% 2300 Travel 4,500 4,500 4,500 4,500 4,500 - 1,254 3,246 72.12% 2400 Office Supplies - - - - - - - - 0.00% 2500 Equipment/Supplies 3,500 3,500 3,500 3,500 3,500 - - 3,500 100.00% 2700 Utilities 37,500 37,500 37,500 37,500 37,500 - 12,141 25,359 67.62% 2800 Postage & Shipping - - - - - - - - 0.00% Total Operating 53,000 53,000 53,000 53,000 53,000 - 13,396 $ 39,604 $ 74.73% Professional & Contracted Services 3100 Professional Services 200,000 200,000 200,000 200,000 200,000 - 39,060 160,940 80.47% Development Review Services 3200 Contracted Services SL County Parks 400,000 400,000 400,000 400,000 400,000 - 123,710 276,290 69.07% SL County Public Works 3,375,000 3,375,000 3,375,000 3,375,000 3,415,034 40,034 802,406 2,612,628 76.50% SL County Street Lights (See Utilities) - - - - - - - - 0.00% 3300 Training 6,500 6,500 6,500 6,500 6,500 - 1,155 5,345 82.23% 3400 Printing - - - - - - - - 0.00% Total Professional & Contracted 3,981,500 3,981,500 3,981,500 3,981,500 4,021,534 40,034 966,330 $ 3,055,204 $ 75.97% Miscellaneous Expenses 6100 Misc. Expenses 2,500 2,500 2,500 2,500 2,500 - - 2,500 100.00% Total Misc. 2,500 2,500 2,500 2,500 2,500 - - $ 2,500 $ 100.00% Total Public Works 4,690,900 $ 4,703,150 $ 4,703,150 $ 4,703,150 $ 4,743,184 $ 40,034 $ 1,207,038 $ 3,536,146 $ 74.55% Notes: Amount of LeRay McAllister grant added to reimburse expenses paid from PW. Department Budget ---PAGE BREAK--- Millcreek FY 2021-22 Capital Improvement Fund – Amendment #4 ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amt. of Change Total Received % Received CAPITAL IMPROVEMENT PROJECT FUND 450 CIP REVENUE 3300 INTERGOVERNMENTAL 3360 Intergovernmental - CIP - - - - 889,650 889,650 889,650 100.00% Salt Lake County Reimbursement CDBG Reimbursement for Sunnyvale Park Total Intergovernmental - - - - 889,650 889,650 889,650 100.00% 3600 MISCELLANEOUS 3610 Interest Earnings 10,000 10,000 10,000 19,467 100,000 80,533 30,515 30.51% Series 2021 Bond Interest 3620 Misc. - - 352,352 855,665 - (855,665) - 0.00% Total Miscellaneous 10,000 10,000 362,352 875,132 100,000 (775,132) 30,515 30.51% 3800 CONTRIBUTIONS 3820 Use of CIP Fund Balance 1,936,000 1,936,000 1,936,000 1,936,000 4,136,000 2,200,000 - 0.00% Total Contributions 1,936,000 1,936,000 1,936,000 1,936,000 4,136,000 2,200,000 - 0.00% 3900 OTHER SOURCES 3910 Transfer from General Fund 81,860 1,281,860 1,281,860 40,421,449 42,692,185 2,270,736 - 0.00% City Hall Bond Funds 3920 Transfer from Storm Water Fund 776,000 776,000 776,000 776,000 - (776,000) - 0.00% SW CIP funds to be managed within SW Fund Total Other Sources 857,860 2,057,860 2,057,860 41,197,449 42,692,185 1,494,736 - 0.00% Total CIP Revenue 2,803,860 $ 4,003,860 $ 4,356,212 $ 44,008,581 $ 47,817,835 $ 3,809,254 $ 920,165 $ 1.92% MILLCREEK FY 2021-22 CAPITAL IMPROVEMENT FUND REVENUE BUDGET Property tax funds that were replaced by ARPA funds allocated to UPD and the remainder of ARPA funds received by Millcreek ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amt. of Change Total Expenditures Balance Available % Budget Available CAPITAL IMPROVEMENT PROJECT FUND Capital Projects Expenses 450-5410 Capital Improvement Projects 7310 General CIP 300,000 300,000 652,352 652,352 1,352,352 700,000 489,943 862,409 63.77% Pavement Preservation Jupiter Brockbank SW 3900 S: I-215 to 2300 E Reconstruction 900 E: 3900 S to 4500 S Safety Improvements Wasatch Blvd 3441 dip 3900 S: Jordan River to 700 E 3800 S Skyline HS Intersection Highland Dr: 3300 S to 3900 S 900 E: 3900 S to 4500 S Constructions Match 7320 Sidewalk Projects 270,000 270,000 270,000 657,298 1,657,298 1,000,000 453,324 1,203,974 72.65% 4705 S: 1380 E to 1450 E SW Misc. Repair - Overlays SW 50/50 Program SW Cutting (Trip Hazards) 4500 1380 E to 1450 E SW Main Street - AT and SW 700 E: Empire Ave to Redmaple Rd SW 3300 S: 1885 E to 1940 E 3300 S: 2404 E to Pioneer Street SW 3300 S: 2600 E to 2700 E SW Neff's Lane 3900 South: SW at power station (West Temple) to TRAX MILLCREEK FY 2021-22 CAPITAL IMPROVEMENT FUND EXPENSE BUDGET ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #2 FY 2021-22 Amendment #3 FY 2021-22 Amendment #4 Amt. of Change Total Expenditures Balance Available % Budget Available CAPITAL IMPROVEMENT PROJECT FUND Capital Projects Expenses 450-5410 Capital Improvement Projects 7330 Traffic Calming 50,000 50,000 50,000 50,000 50,000 - - 50,000 100.00% Misc. Signs DFS (Speed Signs) Neffs Lane 7340 Storm Drain 776,000 776,000 776,000 776,000 - (776,000) - - 0.00% Emergency CIP Hillside Lane Drainage 300 East: 3900 S to 4000 S Central Avenue Drainage Project Scott's Avenue Drainage (South Side) Orchard Circle to Honeycut Ln SD System Investigation 1940 E 3300 S 3196 S 2045 E (pipe) 2555 E Crestbrook (sump) 1998 Siggard Dr (C&G) Missing C&G Various Locations 7350 Active Transportation - - - - - - - 0.00% 7360 Lighting - - - - - - - 0.00% 7370 Non PW Projects 1,407,860 2,607,860 2,607,860 41,872,930 44,758,185 2,885,255 4,347,219 40,410,966 90.29% CDBG Sunnyvale Park Mountair Streetscape Millcreek Common City Hall Pickleball Courts Other Misc. Projects 9100 CIP Fund Balance - - - - - - - 0.00% Total CIP 2,803,860 $ 4,003,860 $ 4,356,212 $ 44,008,581 $ 47,817,835 $ 3,809,255 $ 5,290,486 $ 42,527,349 88.94% ---PAGE BREAK--- Millcreek FY 2021-22 Storm Water Fund – Amendment #4 ---PAGE BREAK--- FY 2021-22 Adopted Budget FY 2021-22 Amendment #1 FY 2021-22 Amendment #4 Amt. of Change Total Expenditures Budget Available % Available STORM WATER FUND Storm Water Fund Expenses Professional & Contracted Services 3100 Professional Services 90,000 90,000 90,000 - 49,363 40,637 45.15% Rocky Mtn. Power 3200 Contracted Services 384,000 384,000 384,000 - 8,191 375,809 97.87% SL County 3300 Training 15,000 15,000 15,000 - - 15,000 100.00% 3400 Printing 5,000 5,000 5,000 - - 5,000 100.00% Total Professional & Contracted 494,000 $ 494,000 $ 494,000 $ - $ 57,554 $ 436,446 $ 88.35% Miscellaneous Expenses 6100 Misc. Expenses 20,000 20,000 20,000 - - 20,000 100.00% 6400 Administrative Expenses 110,000 110,000 110,000 - 45,833 64,167 58.33% Total Misc. 130,000 $ 130,000 $ 130,000 $ - $ 45,833 $ 84,167 $ 64.74% Capital Expenditures 7340 Storm Drain CIP - - 776,000 776,000 160,022 615,979 79.38% 7400 Equipment (Computers, etc.) 20,000 20,000 20,000 - - 20,000 100.00% 7500 Vehicles 210,000 210,000 210,000 - 204,254 5,746 2.74% Total Capital 230,000 $ 230,000 $ 1,006,000 $ 776,000 $ 223,038 $ 25,746 $ 2.56% Other Financing Uses 9100 Contribution to Fund Balance 605,500 $ 605,500 $ 605,500 $ - - 605,500 100.00% 9300 Transfer to CIP Fund 776,000 $ 776,000 $ - $ (776,000) - - 0.00% Total Other Financing Uses 1,381,500 $ 1,381,500 $ 605,500 $ (776,000) $ - 605,500 100.00% Total Storm Water 2,780,000 $ 2,788,750 $ 2,788,750 $ - $ 489,724 $ 2,290,276 $ 82.13% MILLCREEK FY 2021-22 STORM WATER FUND EXPENSE BUDGET ---PAGE BREAK--- Millcreek FY 2021-22 Projected General Fund Balance ---PAGE BREAK--- Fund Balance Reserve Amount % of General Fund Budget Additional Fund Balance added in FY2020 1,548,302 $ Use of Fund Balance FY2020 - $ Use of UPD Reserve Funds - $ Fund Balance at end of FY2020 5,282,341 $ 15.13% UPD Reserve Funds 1,818,436 $ Unreserved Fund Balance 3,463,905 $ Additional Fund Balance FY2021 5,214,375 $ Additional UPD Reserve Funds 218,224 $ Fund Balance at end of FY2021 10,496,716 $ 30.07% Projected UPD Reserve Funds 2,036,660 $ Projected Unreserved Fund Balance 8,460,056 $ Projected Additional Fund Balance FY2022 1,207,789 $ Projected Use of Fund Balance FY2022 - $ Projected Use of UPD Reserve Funds (1,964,351) $ Projected Fund Balance at end of FY2022 10,504,505 $ 30.09% Projected UPD Reserve Funds 72,309 $ Projected Unreserved Fund Balance 10,432,196 $ Millcreek Fund Balance Reserve State Law Requires Municipalities to maintain at least 5% and no more than 35% of the General Fund in a reserve account.