Full Text
Millcreek FY 2019-20 Quarterly Report For Period Ending March 31, 2020 ---PAGE BREAK--- Millcreek FY 2019-20 3rd Quarter Report • 75% of the budget year has passed • 80% of General Fund revenues received • This amount is what would be expected at this time in the budget cycle since mos property taxes have been collected • 63% of the General Fund budget has been expended • This too is what would be expected at this time ---PAGE BREAK--- Millcreek FY 2019-20 General Fund Revenues ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 Total Received 1st Quarter Total Received 2nd Quarter Total Received 3rd Quarter Total Received % Received 100 GENERAL FUND 3100 TAXES 3110 Property Tax 12 Months of UPD Contract + costs of borrowing 10,448,910 10,448,910 197,609 9,711,031 529,458 10,438,099 99.90% 3120 Sales & Use Tax General 10,400,000 10,400,000 881,819 2,645,809 2,978,143 6,505,771 62.56% 3125 Mass Transit Tax - 500,000 69,576 230,529 262,085 562,189 112.44% 3130 Franchise Tax Cable Tax 560,000 560,000 - 139,406 140,077 279,482 49.91% 3140 Transient Room Tax 2,500 2,500 354 437 781 1,572 62.88% Total Taxes 21,411,410 $ 21,911,410 $ 1,149,358 $ 12,727,212 $ 3,910,544 $ 17,787,114 $ 82.11% 3200 LICENSES & PERMITS 3210 Business Licenses & Permits 500,000 550,000 106,294 201,455 156,575 464,324 84.42% 3220 Building Permits 1,200,000 1,200,000 452,215 204,097 601,983 1,258,296 104.86% 3230 Special Event Permits 2,500 2,500 150 700 275 1,125 45.00% 3240 Engineering Permits 40,000 90,000 38,473 33,012 24,969 96,453 107.17% Total Licenses & Permits 1,742,500 $ 1,842,500 $ 597,132 $ 439,265 $ 783,801 $ 1,820,198 $ 100.98% 3300 INTERGOVERNMENTAL 3310 Local Grants - - - - 1,000 1,000 0.00% 3320 State Grants - - - - - - 0.00% 3330 Liquor Grants 45,000 42,361 - 42,361 - 42,361 100.00% Fund 111 Class C Road Funds 1,700,000 2,100,000 263,699 424,983 670,339 1,359,021 64.72% Total Intergovernmental 1,745,000 $ 2,142,361 $ 263,699 $ 467,344 $ 671,339 $ 1,402,382 $ 65.38% 3400 CHARGES FOR SERVICES 3410 Planning Fees 60,000 80,000 11,472 41,697 38,089 91,258 114.07% 3420 Engineering Fees - - - - - - 0.00% 3430 Rents & Leases - - - - - - 0.00% 3470 Park Impact Fees - 12,278 1,484 8,904 22,666 0.00% Total Charges For Services 60,000 $ 80,000 $ 23,749 $ 43,181 $ 46,994 $ 113,924 $ 142.40% 3500 FINES & FORFEITURES 3510 Court Fines - - - - - - 0.00% Total Fines & Forfeitures - $ - $ - $ - $ - $ - $ 0.00% 3600 MISCELLANEOUS 3610 Interest Earnings 250,000 275,000 111,417 110,882 106,876 329,175 119.70% 3620 Misc. Income - 31,000 3,899 13,604 16,136 33,638 108.51% Total Miscellaneous 250,000 $ 306,000 $ 115,316 $ 124,486 $ 123,012 $ 362,814 $ 142.73% 3800 CONTRIBUTIONS 3810 Donations - 8,778 766 7,012 1,000 8,778 99.99% Promise Program Donations 3820 Use of Fund Balance 326,090 673,878 - - - - 0.00% Use of Fund Balance for UPD Contract Total Other Contributions 326,090 $ 682,656 $ 766 $ 7,012 $ 1,000 $ 8,778 $ 1.39% Total General Fund Revenues 25,535,000 $ 26,964,927 $ 2,150,020 $ 13,808,500 $ 5,536,689 $ 21,495,208 $ 79.72% MILLCREEK FY 2019-20 GENERAL FUND REVENUE BUDGET ---PAGE BREAK--- Millcreek FY 2019-20 General Fund Expenses ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4100 LEGISLATIVE 100-4110 Mayor & City Council Personnel Expenses 1100 Salaries & Wages 100,000 100,000 26,923 24,452 28,849 80,224 19,776 19.78% 1400 Employee Benefits 66,000 66,000 16,574 12,232 13,848 42,654 23,346 35.37% Total Personnel 166,000 166,000 43,497 $ 36,684 $ 42,697 $ 122,878 $ 43,122 $ 25.98% Operating Expenses 2100 Books, Subscriptions, Memb. 120,000 120,000 115,416 2,941 50 118,407 1,593 1.33% Utah League of Cities & Towns Jordan River Commission Central Wasatch Commission 2300 Travel 2,000 2,000 - - 201 201 1,799 89.96% Total Operating 122,000 122,000 115,416 $ 2,941 $ 251 $ 118,608 $ 3,392 $ 2.78% Professional & Contracted Services 3100 Professional Services 60,000 55,000 7,500 19,750 9,250 36,500 18,500 33.64% Capstone Strategies Sustainability Coordinator Auditor 3300 Training 4,500 4,500 1,390 - 2,720 4,110 390 8.67% Total Professional & Contracted 64,500 59,500 8,890 $ 19,750 $ 11,970 $ 40,610 $ 18,890 $ 31.75% Miscellaneous Expenses 6100 Misc. Expenses 500 500 - 80 1,160 1,240 (740) -148.00% Total Misc. 500 500 - $ 80 $ 1,160 $ 1,240 $ (740) $ -148.00% 353,000 $ 348,000 $ 167,803 $ 59,455 $ 56,078 $ 283,335 $ 64,665 $ 18.58% Notes: Department Budget Total Mayor & City Council Misc. Expenses will need to be adjusted with the next amendment, however the overall budget is within expected MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4200 ADMINISTRATION 100-4210 City Manager Personnel Services 1100 Salaries & Wages 147,504 148,000 39,507 35,294 41,525 116,325 31,675 21.40% City Manager 1200 Part-Time Wages - - - - - - - 0.00% 1400 Employee Benefits 50,000 50,000 13,309 10,226 11,459 34,994 15,006 30.01% Total Personnel 197,504 198,000 52,815 $ 45,520 $ 52,984 $ 151,319 $ 46,681 $ 23.58% Operating Expenses 2100 Books, Subscriptions, Memb. 1,600 1,600 193 162 360 715 885 55.33% 2300 Travel 2,500 2,500 - - - - 2,500 100.00% 2400 Office Supplies - - - - - - - 0.00% Total Operating 4,100 4,100 193 $ 162 $ 360 $ 715 $ 3,385 $ 82.57% Professional & Contracted Services 3100 Professional Services 5,000 5,000 - - - - 5,000 100.00% LYRB 3300 Training 3,500 3,500 460 305 110 875 2,625 75.00% Total Professional & Contracted 8,500 8,500 460 $ 305 $ 110 $ 875 $ 7,625 $ 89.71% Miscellaneous Expenses 6100 Misc. Expenses 4,000 4,000 748 2,112 294 3,154 846 21.15% Total Misc. 4,000 4,000 748 $ 2,112 $ 294 $ 3,154 $ 846 $ 21.15% Total City Manager 214,104 $ 214,600 $ 54,216 $ 48,098 $ 53,749 $ 156,063 $ 58,537 $ 27.28% Notes: Department Budget Budget is within expected parameters. MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4220 Justice Court Professional & Contracted Services 3100 Professional Services - - - - - - - 0.00% 3200 Contracted Services 170,000 210,000 - 89,491 18,251 107,741 102,259 48.69% Total Professional & Contracted 170,000 210,000 - $ 89,491 $ 18,251 $ 107,741 $ 102,259 $ 48.69% Total Justice Court 170,000 $ 210,000 $ - $ 89,491 $ 18,251 $ 107,741 $ 102,259 $ 48.69% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget available is higher than expected since only one invoice was received during the 3rd quarter. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4230 Legal Services Personnel Services 1100 Salaries & Wages 74,124 - - - - - - 0.00% Law Clerk 1200 Part-Time Wages - - - - - - - 0.00% 1400 Employee Benefits 25,000 - - - - - - 0.00% Total Personnel 99,124 - - $ - $ - $ - $ - $ 0.00% Operating Expenses 2100 Books, Subscriptions, Memb. 4,000 - - - - - - 0.00% 2300 Travel 1,500 - - - - - - 0.00% Total Operating 5,500 - - $ - $ - $ - $ - $ 0.00% Professional & Contracted Services 3100 Professional Services 140,000 145,000 41,899 38,596 28,186 108,680 36,320 25.05% John Brems 3300 Training 2,000 2,000 1,203 - - 1,203 797 39.87% 3200 Contracted Services 323,800 335,000 32,673 74,533 60,300 167,505 167,495 50.00% SL County Indigent Defense SL County Prosecutorial Services Total Professional & Contracted 465,800 482,000 75,774 $ 113,129 $ 88,485 $ 277,388 $ 204,612 $ 42.45% Misc. Expenses 6100 Misc. Expenses 250 250 - - - - 250 100.00% Total Misc. 250 250 - $ - $ - $ - $ 250 $ 100.00% Total Legal Services 570,674 $ 482,250 $ 75,774 $ 113,129 $ 88,485 $ 277,388 $ 204,862 $ 42.48% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget available is higher than expected since not all invoices from SL County have been received. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4240 Public Safety Professional & Contracted Services 3200 Contracted Services SLC Animal Control 552,944 552,944 176,060 88,030 132,045 396,135 156,809 28.36% 12 Months of Contract Unified Police 10,400,000 10,761,278 2,690,322 2,690,322 2,690,322 8,070,966 2,690,312 25.00% UPD (Alcohol Tax Exp) 42,500 86,000 42,964 - 42,361 85,324 676 0.79% Total Professional & Contracted 10,995,444 11,400,222 2,909,346 $ 2,778,352 $ 2,864,728 $ 8,552,425 $ 2,847,797 $ 24.98% Total Public Safety 10,995,444 $ 11,400,222 $ 2,909,346 $ 2,778,352 $ 2,864,728 $ 8,552,425 $ 2,847,797 $ 24.98% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4300 RECORDER 100-4310 City Recorder Personnel Services 1100 Salaries & Wages 69,983 72,000 18,783 16,507 19,358 54,647 17,353 24.10% City Recorder - 1200 Part-Time Wages - - - - - - - 0.00% 1400 Employee Benefits 30,000 32,000 7,668 6,436 7,407 21,510 10,490 32.78% Total Personnel 99,983 104,000 26,451 $ 22,942 $ 26,764 $ 76,157 $ 27,843 $ 26.77% Operating Expenses 2100 Books, Subscriptions, Memb. 600 600 470 - 40 510 90 15.00% 2300 Travel 1,200 1,200 663 - - 663 537 44.74% 2400 Office Supplies 250 250 - - - - 250 100.00% 2800 Postage & Shipping - - - - - - - 0.00% Total Operating 2,050 2,050 1,133 $ - $ 40 $ 1,173 $ 877 $ 42.78% Professional & Contracted Services 3100 Professional Services 1,000 1,000 - - - - 1,000 100.00% 3200 Contracted Services 130,000 44,000 - 43,606 - 43,606 394 0.90% SL County Elections 3300 Training 1,200 1,200 425 - 769 1,194 6 0.50% 3400 Printing - - - - - - - 0.00% 3500 Advertising & Public Notices 10,000 10,000 275 1,047 735 2,057 7,943 79.43% Total Professional & Contracted 142,200 56,200 700 $ 44,653 $ 1,504 $ 46,857 $ 9,343 $ 16.62% Miscellaneous Expenses 6100 Misc. Expenses 500 500 - 7 81 88 412 82.44% Total Misc. 500 500 - $ 7 $ 81 $ 88 $ 412 $ 82.44% Total City Recorder 244,733 $ 162,750 $ 28,284 $ 67,602 $ 28,389 $ 124,275 $ 38,475 $ 23.64% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4400 BUILDING SERVICES 100-4410 Building Services Personnel Services 1100 Salaries & Wages - 520,000 110,628 105,193 151,743 367,564 152,436 29.31% Building Services Director /Building Off. Asst. Building Official Plans Examiner I Building Inspector III Building Inspector I Permit Technician II Permit Technician I Code Compliance Inspector II Code Compliance Inspector I 1200 Part-Time Wages - - - - - - - 0.00% 1300 Over-Time Wages - 2,000 - - 1,038 1,038 962 48.10% 1400 Employee Benefits - 230,000 50,373 45,194 62,053 157,620 72,380 31.47% Total Personnel - 752,000 161,001 $ 150,387 $ 214,834 $ 526,223 $ 225,777 $ 30.02% Operating Expenses 2100 Books, Subscriptions, Memb. - 2,500 277 867 752 1,896 604 24.18% 2300 Travel - 3,000 293 834 4,476 5,603 (2,603) -86.78% 2500 Equipment/Supplies - 5,000 106 944 - 1,051 3,949 78.99% Total Operating - 10,500 676 $ 2,645 $ 5,228 $ 8,550 $ 1,950 $ 18.57% Professional & Contracted Services 3100 Professional Services - 90,000 5,865 11,310 390 17,565 72,435 80.48% Building Inspection Services Code Compliance Abatement 3300 Training - 12,500 1,205 1,108 4,931 7,244 5,256 42.05% 3400 Printing - - - - - - - 0.00% Total Professional & Contracted - 102,500 7,070 $ 12,418 $ 5,321 $ 24,809 $ 77,691 $ 75.80% Miscellaneous Expenses 6100 Misc. Expenses - 2,500 - 221 83 305 2,195 87.81% Total Misc. - 2,500 - $ 221 $ 83 $ 305 $ 2,195 $ 87.81% Total Building Services - $ 867,500 $ 168,747 $ 165,672 $ 225,466 $ 559,886 $ 307,614 $ 35.46% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Various line items will need to be adjusted with the next budget amendment however budget available is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4500 COMMUNICATIONS & PROGRAMS 100-4510 Communications & Programs Personnel Services 1100 Salaries & Wages 73,206 105,000 34,671 28,366 20,497 83,534 21,466 20.44% Communications & Programs Director Communications Outreach Specialist 1200 Part-Time Wages - 1,500 165 499 64 728 772 51.45% 1300 Over-Time Wages - 1,000 325 257 - 582 418 41.82% 1400 Employee Benefits 35,000 45,000 14,433 11,106 8,406 33,944 11,056 24.57% Total Personnel 108,206 152,500 49,593 $ 40,228 $ 28,967 $ 118,788 $ 33,712 $ 22.11% Operating Expenses 2100 Books, Subscriptions, Memb. 500 500 150 - 147 297 203 40.59% 2300 Travel 500 750 - - - - 750 100.00% 2500 Equipment/Supplies 10,000 5,000 - - - - 5,000 100.00% 2800 Postage & Shipping 15,000 35,000 5,918 6,890 11,842 24,650 10,350 29.57% Total Operating 26,000 41,250 6,068 $ 6,890 $ 11,989 $ 24,947 $ 16,303 $ 39.52% Professional & Contracted Services 3100 Professional Services 10,000 40,000 25,323 - 250 25,573 14,427 36.07% 3300 Training 2,000 2,000 425 - - 425 1,575 78.75% 3400 Printing 75,000 60,000 - 7,221 8,224 15,445 44,555 74.26% Total Professional & Contracted 87,000 102,000 25,748 $ 7,221 $ 8,474 $ 41,443 $ 60,557 $ 59.37% Miscellaneous Expenses 6100 Misc. Expenses 2,500 2,000 524 624 678 1,826 174 8.71% Total Misc. 2,500 2,000 524 $ 624 $ 678 $ 1,826 $ 174 $ 8.71% Community Programs 8100 Community Councils 32,200 32,200 - 1,386 7,000 8,386 23,814 73.96% Canyon Rim 6,000 East Millcreek 5,000 Millcreek 15,000 Mt. Olympus 3,000 Insurance for CC 3,200 8200 Events 170,000 220,000 1,885 151,274 4,524 157,683 62,317 28.33% Utah Venture Out 125,000 Event Coordinator 30,000 Youth City Council 5,000 Other 10,000 8300 Programs 5,000 5,000 - - - - 5,000 100.00% Rain Barrel Program 5,000 Total Community Programs 207,200 257,200 1,885 $ 152,660 $ 11,524 $ 166,069 $ 91,131 $ 35.43% Total Communications & Programs 430,906 $ 554,950 $ 83,818 $ 207,624 $ 61,632 $ 353,073 $ 201,877 $ 36.38% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4520 Emergency Management Personnel Services 1100 Salaries & Wages 47,726 53,000 15,372 7,791 16,141 39,304 13,696 25.84% Emergency Manager 1200 Part-Time Wages - - - - - - - 0.00% 1300 Over-Time Wages 2,000 2,000 710 - - 710 1,290 64.48% 1400 Employee Benefits 20,000 27,000 5,646 4,149 7,786 17,581 9,419 34.89% Total Personnel 69,726 82,000 21,728 $ 11,940 $ 23,927 $ 57,595 $ 24,405 $ 29.76% Operating Expenses 2100 Books, Subscriptions, Memb. 1,000 1,000 - - - - 1,000 100.00% 2300 Travel 250 250 - - - - 250 100.00% 2400 Office Supplies - - - - - - - 0.00% 2500 Equipment/Supplies 10,000 10,000 88 1,498 - 1,587 8,413 84.13% Total Operating 11,250 11,250 88 $ 1,498 $ - $ 1,587 $ 9,663 $ 85.90% Professional & Contracted Services 3100 Professional Services - - - - - - - 0.00% 3300 Training 7,500 7,500 - 256 - 256 7,244 96.59% 3400 Printing 3,500 2,500 - - - - 2,500 100.00% Total Professional & Contracted 11,000 10,000 - $ 256 $ - $ 256 $ 9,744 $ 97.44% Miscellaneous Expenses 6100 Misc. Expenses 2,500 2,500 543 - 797 1,340 1,160 46.40% Total Misc. 2,500 2,500 543 $ - $ 797 $ 1,340 $ 1,160 $ 46.40% Total Emergency Management 94,476 $ 105,750 $ 22,360 $ 13,694 $ 24,724 $ 60,778 $ 44,972 $ 42.53% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4530 Information Center Personnel Services 1100 Salaries & Wages 130,000 145,000 37,206 34,194 38,303 109,703 35,297 24.34% Information Center Manager Information Center Technician Information Center Technician 1200 Part-Time Wages - - - - - - - 0.00% 1300 Over-Time Wages 1,000 2,000 - 1,021 2,170 3,191 (1,191) -59.57% 1400 Employee Benefits 65,000 70,000 19,723 16,734 16,687 53,144 16,856 24.08% Total Personnel 196,000 217,000 56,929 $ 51,949 $ 57,160 $ 166,038 $ 50,962 $ 23.48% Operating Expenses 2100 Books, Subscriptions, Memb. 500 500 - 40 - 40 460 92.02% 2300 Travel 500 500 - - - - 500 100.00% 2400 Office Supplies 25,000 20,000 3,895 3,543 6,441 13,879 6,121 30.61% 2500 Equipment/Supplies 5,000 5,000 - 916 61 977 4,023 80.46% 2800 Postage & Shipping 12,000 12,000 2,856 1,784 3,778 8,418 3,582 29.85% Total Operating 43,000 38,000 6,751 $ 6,283 $ 10,279 $ 23,313 $ 14,687 $ 38.65% Professional & Contracted Services 3100 Professional Services 1,000 1,000 21 - - 21 979 97.86% 3300 Training 1,200 1,200 - - - - 1,200 100.00% 3400 Printing 1,200 1,200 949 55 - 1,004 196 16.36% Total Professional & Contracted 3,400 3,400 970 $ 55 $ - $ 1,025 $ 2,375 $ 69.85% Miscellaneous Expenses 6100 Misc. Expenses 5,000 5,000 1,368 202 230 1,801 3,199 63.98% 6300 Meals 7,500 7,500 730 1,306 1,060 3,096 4,404 58.72% Total Misc. 12,500 12,500 2,099 $ 1,508 $ 1,290 $ 4,897 $ 7,603 $ 60.83% Total Information Center 254,900 $ 270,900 $ 66,749 $ 59,795 $ 68,729 $ 195,273 $ 75,627 $ 27.92% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4540 IT Management Operating Expenses 2500 Equipment/Supplies 155,000 405,000 28,992 59,384 42,234 130,610 274,390 67.75% 25000 General Supplies & Microsoft Licensing 75,000 Financial Management Software 5,000 AutoCad 23,000 CivicPlus 5,000 Bluebeam 2,000 MuniCode 238,000 EnerGov 32,000 iWorQ License Maintenance 2700 Utilities Telephone 45,000 45,000 7,191 8,628 8,588 24,406 20,594 45.76% Total Operating 200,000 450,000 36,183 $ 68,012 $ 50,822 $ 155,016 $ 294,984 $ 65.55% Professional & Contracted Services 3100 Professional Services 65,000 40,000 9,082 12,169 10,573 31,824 8,176 20.44% Network Providers, Inc. 3300 Training - - - - - - - 0.00% Total Professional & Contracted 65,000 40,000 9,082 $ 12,169 $ 10,573 $ 31,824 $ 8,176 $ 20.44% Miscellaneous Expenses 6100 Misc. Expenses 2,000 2,000 538 401 29 968 1,032 51.61% Total Misc. 2,000 2,000 538 $ 401 $ 29 $ 968 $ 1,032 $ 51.61% Capital 7400 Equipment (Computers, etc.) 50,000 35,000 2,105 11,689 13,380 27,173 7,827 22.36% 50,000 35,000 2,105 $ 11,689 $ 13,380 $ 27,173 $ 7,827 $ 22.36% Total IT Management 317,000 $ 527,000 $ 47,907 $ 92,270 $ 74,803 $ 214,981 $ 312,019 $ 59.21% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget available is higher than expected due to various software expenses have yet to be paid. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4600 ECONOMIC DEVELOPMENT 100-4610 Economic Development Personnel Services 1100 Salaries & Wages 169,000 215,000 45,449 42,306 64,993 152,748 62,252 28.95% Economic Dev. Director Asst. to Economic Dev. Director Field Officer 1200 Part-Time Wages - - - - - - 0.00% 1300 Over-Time Wages - - - - - - 0.00% 1400 Employee Benefits 60,000 75,000 15,659 10,808 19,469 45,937 29,063 38.75% Total Personnel 229,000 290,000 61,108 $ 53,114 $ 84,463 $ 198,685 $ 91,315 $ 31.49% Operating Expenses 2100 Books, Subscriptions, Memb. 1,200 1,200 - - 200 200 1,000 83.33% 2300 Travel 2,500 5,000 670 2,750 411 3,831 1,170 23.39% 2400 Office Supplies - - - - - - - 0.00% 2500 Equipment/Supplies 500 500 - - - - 500 100.00% 2800 Postage & Shipping - - - - - - - 0.00% Total Operating 4,200 6,700 670 $ 2,750 $ 611 $ 4,031 $ 2,670 $ 39.84% Professional & Contracted Services 3100 Professional Services - 2,500 - 1,540 - 1,540 960 38.40% 3300 Training 2,500 2,500 579 504 1,984 3,066 (566) -22.65% Total Professional & Contracted 2,500 5,000 579 $ 2,044 $ 1,984 $ 4,606 $ 394 $ 7.88% Miscellaneous Expenses 6100 Misc. Expenses 10,000 12,000 4,285 3,790 978 9,052 2,948 24.56% Total Misc. 10,000 12,000 4,285 $ 3,790 $ 978 $ 9,052 $ 2,948 $ 24.56% Total Economic Development 245,700 $ 313,700 $ 66,642 $ 61,697 $ 88,035 $ 216,374 $ 97,326 $ 31.03% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Various line items will need to be adjusted with the next budget amendment however budget available is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4620 Business License Administration Personnel Services 1100 Salaries & Wages 97,105 105,000 25,948 22,769 18,658 67,375 37,625 35.83% Business License Administrator Business License Assistant 1200 Part-Time Wages - - - - - - - 0.00% 1300 Over-Time Wages 3,000 2,000 - - 286 286 1,714 85.71% 1400 Employee Benefits 40,000 40,000 9,437 7,895 6,465 23,797 16,203 40.51% Total Personnel 140,105 147,000 35,385 $ 30,665 $ 25,409 $ 91,459 $ 55,541 $ 37.78% Operating Expenses 2100 Books, Subscriptions, Memb. 250 250 - - - - 250 100.00% 2300 Travel 1,500 1,500 579 - - 579 921 61.39% 2500 Equipment/Supplies 250 250 - - - - 250 100.00% Total Operating 2,000 2,000 579 $ - $ - $ 579 $ 1,421 $ 71.05% Professional & Contracted Services 3100 Professional Services - 15,000 - 2,400 - 2,400 12,600 84.00% Business License Fee Study 3300 Training 1,200 1,200 390 - - 390 810 67.50% Total Professional & Contracted 1,200 16,200 390 $ 2,400 $ - $ 2,790 $ 13,410 $ 82.78% Miscellaneous Expenses 6100 Misc. Expenses 500 500 - - 28 28 472 94.44% Total Misc. 500 500 - $ - $ 28 $ 28 $ 472 $ 94.44% Total Business License Administration 143,805 $ 165,700 $ 36,355 $ 33,065 $ 25,436 $ 94,856 $ 70,844 $ 42.75% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget available is higher than expected due to professional services funds which will be expended in the last quarter. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4700 FINANCE 100-4710 Finance Personnel Services 1100 Salaries & Wages 135,000 170,000 35,674 31,531 41,999 109,203 60,797 35.76% HR-Finance Director HR-Finance Asst. HR-Finance Technician 1200 Part-Time Wages - - - - - - - 0.00% 1400 Employee Benefits 62,000 80,000 15,393 13,469 17,679 46,541 33,459 41.82% Total Personnel 197,000 250,000 51,067 $ 45,000 $ 59,678 $ 155,744 $ 94,256 $ 37.70% Operating Expenses 2100 Books, Subscriptions, Memb. 250 250 - - - - 250 100.00% 2300 Travel 500 500 19 22 61 102 398 79.55% 2400 Office Supplies 250 250 - 135 - 135 115 46.00% 2500 Equipment/Supplies - - - - - - - 0.00% Total Operating 1,000 1,000 19 $ 157 $ 61 $ 237 $ 763 $ 76.28% Professional & Contracted Services 3100 Professional Services 24,000 30,000 4,213 6,168 4,800 15,180 14,820 49.40% D&S Accounting 3300 Training 500 4,000 200 - 460 660 3,340 83.50% 3400 Printing - - - - - - - 0.00% Total Professional & Contracted 24,500 34,000 4,413 $ 6,168 $ 5,260 $ 15,840 $ 18,160 $ 53.41% Miscellaneous Expenses 6100 Misc. Expenses 2,000 1,000 54 391 170 615 385 38.48% Total Misc. 2,000 1,000 54 $ 391 $ 170 $ 615 $ 385 $ 38.48% Total Finance 224,500 $ 286,000 $ 55,553 $ 51,716 $ 65,168 $ 172,437 $ 113,563 $ 39.71% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4720 Human Resources Personnel Services 1100 Salaries & Wages 56,000 - - - - - - 0.00% Communications Outreach/Risk Manager 1200 Part-Time Wages - - - - - - - 0.00% 1300 Over-Time Wages - - - - - - - 0.00% 1400 Employee Benefits 20,600 - - - - - - 0.00% Total Personnel 76,600 - - $ - $ - $ - $ - $ 0.00% Operating Expenses 2100 Books, Subscriptions, Memb. 500 250 - - - - 250 100.00% 2300 Travel 500 - - - - - - 0.00% 2400 Office Supplies - - - - - - - 0.00% 2500 Equipment/Supplies 250 250 - - - - 250 100.00% 2800 Postage & Shipping 250 250 - - - - 250 100.00% Total Operating 1,500 750 - $ - $ - $ - $ 750 $ 100.00% Professional & Contracted Services 3100 Professional Services 1,200 3,000 105 423 1,216 1,744 1,256 41.87% Employee Assistance Program Drug Testing 3300 Training 2,000 1,000 - - 30 30 970 97.00% 3400 Printing 500 500 500 - - 500 - 0.00% Total Professional & Contracted 3,700 4,500 605 $ 423 $ 1,246 $ 2,274 $ 2,226 $ 49.47% Insurance 4200 Worker's Comp Insurance 35,000 40,000 5,748 5,405 6,098 17,251 22,749 56.87% Total Insurance 35,000 40,000 5,748 $ 5,405 $ 6,098 $ 17,251 $ 22,749 $ 56.87% Miscellaneous Expenses 6100 Misc. Expenses 1,000 1,000 278 68 3 348 652 65.16% Total Misc. 1,000 1,000 278 $ 68 $ 3 $ 348 $ 652 $ 65.16% Total Human Resources 117,800 $ 46,250 $ 6,631 $ 5,896 $ 7,347 $ 19,873 $ 26,377 $ 57.03% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget available is higher than expected due to Worker's Comp funds which will be expended in the last quarter. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4730 Non-Departmental Insurance 4100 Liability Insurance 80,000 82,000 - 81,192 - 81,192 808 0.98% Total Insurance 80,000 82,000 - $ 81,192 $ - $ 81,192 $ 808 $ 0.98% Debt Service 5100 Bond Principal Payments - - - - - - - 0.00% 5200 Debt Interest Bond Interest - - - - - - - 0.00% UPD Debt Interest 315,000 315,000 - 68,344 - 68,344 246,656 78.30% 5300 Fees UPD Debt Related Fees 60,000 61,000 30,500 30,500 - 61,000 - 0.00% Total Debt Service 60,000 376,000 30,500 $ 30,500 $ - $ 129,344 $ 246,656 $ 65.60% Miscellaneous Expenses 6100 Misc. Expenses 6,000 10,000 2,585 5,551 173 8,308 1,692 16.92% 6200 Bank Charges 42,750 45,000 9,226 12,268 9,259 30,754 14,246 31.66% Total Misc. 48,750 55,000 11,811 $ 17,819 $ 9,432 $ 39,062 $ 15,938 $ 28.98% Other Financing Uses 9100 Contribution to Fund Balance 204,588 296,207 - - - - 296,207 100.00% 9200 Due Other Govt. Entity - 61,000 - - - - 61,000 100.00% 9300 Transfer to CIP Fund 1,750,000 1,750,000 1,750,000 - - 1,750,000 - 0.00% Total Other Financing Uses 1,954,588 2,107,207 1,750,000 $ - $ - $ 1,750,000 $ 357,207 $ 16.95% Total Non-Departmental 2,143,338 $ 2,620,207 $ 1,792,311 $ 129,511 $ 9,432 $ 1,999,598 $ 620,609 $ 23.69% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4800 LEGISLATIVE POLICY 100-4810 Legislative Policy Personnel Services 1100 Salaries & Wages 715,000 285,000 99,853 64,676 65,420 229,949 55,051 19.32% Legislative Policy Director Legislative Policy Clerk IT/Facilities Manager Legislative Analyst Code Compliance Inspector II Code Compliance Inspector II Code Compliance Inspector I 1200 Part-Time Wages - - - - - - - 0.00% 1300 Over-Time Wages 2,500 4,000 779 1,240 1,761 3,780 220 5.51% 1400 Employee Benefits 355,000 125,000 43,696 31,331 27,024 102,051 22,949 18.36% Total Personnel 1,072,500 414,000 144,327 $ 97,248 $ 94,204 $ 335,779 $ 78,221 $ 18.89% Operating Expenses 2100 Books, Subscriptions, Memb. 3,000 4,000 1,499 1,028 859 3,386 614 15.35% 2300 Travel 3,500 4,000 2,019 738 423 3,180 820 20.50% 2500 Equipment/Supplies 12,000 6,000 243 1,503 76 1,822 4,178 69.63% Total Operating 18,500 14,000 3,761 $ 3,268 $ 1,359 $ 8,388 $ 5,612 $ 40.09% Professional & Contracted Services 3100 Professional Services 40,000 10,000 1,228 1,867 2,142 5,236 4,764 47.64% Code Compliance Abatement 3200 Contracted Services 420,000 - - - - - - 0.00% SL County Parks 3300 Training 10,000 7,000 3,642 725 1,219 5,586 1,414 20.20% 3400 Printing 1,500 500 - - - - 500 100.00% Total Professional & Contracted 471,500 17,500 4,870 $ 2,592 $ 3,361 $ 10,822 $ 6,678 $ 38.16% Miscellaneous Expenses 6100 Misc. Expenses 2,500 2,500 358 470 - 828 1,672 66.88% Total Misc. 2,500 2,500 358 $ 470 $ - $ 828 $ 1,672 $ 66.88% Total Legislative Policy 1,565,000 $ 448,000 $ 153,316 $ 103,578 $ 98,924 $ 355,818 $ 92,182 $ 20.58% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4820 Facilities Operating Expenses 2500 Equipment/Supplies 30,000 25,000 3,382 3,707 6,464 13,553 11,447 45.79% 2600 Building Maintenance 50,000 85,000 11,673 2,553 57,080 71,305 13,695 16.11% 2700 Utilities 34,750 40,000 5,827 7,639 7,297 20,763 19,237 48.09% Electricity Natural Gas Waste & Disposal Water & Sewer Total Operating 114,750 150,000 20,882 $ 13,899 $ 70,841 $ 105,622 $ 44,378 $ 29.59% Professional & Contracted Services 3100 Professional Services 20,000 30,000 8,208 5,180 5,070 18,458 11,542 38.47% 3300 Training - - - - - - - 0.00% Total Professional & Contracted 20,000 30,000 8,208 $ 5,180 $ 5,070 $ 18,458 $ 11,542 $ 38.47% Debt Service 5400 Leases 195,120 195,120 48,774 48,774 54,630 152,179 42,941 22.01% Total Leases 195,120 195,120 48,774 $ 48,774 $ 54,630 $ 152,179 $ 42,941 $ 22.01% Miscellaneous Expenses 6100 Misc. Expenses 12,000 7,500 1,285 39 308 1,632 5,868 78.24% Total Misc. 12,000 7,500 1,285 $ 39 $ 308 $ 1,632 $ 5,868 $ 78.24% Total Facilities 341,870 $ 382,620 $ 79,149 $ 67,893 $ 130,849 $ 277,891 $ 104,729 $ 27.37% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4830 Fleet Operating Expenses 2500 Equipment/Supplies 2,500 2,500 248 678 - 927 1,573 62.94% 2650 Vehicle Maintenance 15,000 10,000 1,647 171 1,493 3,311 6,689 66.89% 2900 Fuel 18,000 18,000 3,225 3,653 2,754 9,631 8,369 46.49% Total Operating Expenses 35,500 30,500 5,120 $ 4,502 $ 4,247 $ 13,869 $ 16,631 $ 54.53% Capital Expenses 7500 Vehicles - - - - - - - 0.00% Total Vehicles - - - $ - $ - $ - $ - $ 0.00% Total Fleet 35,500 $ 30,500 $ 5,120 $ 4,502 $ 4,247 $ 13,869 $ 16,631 $ 54.53% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4900 PLANNING & ZONING 100-4910 Planning & Zoning Personnel Services 1100 Salaries & Wages 385,000 420,000 104,566 90,988 95,894 291,448 128,552 30.61% Planning & Zoning Director Planning Engineer Senior Planner Planner II Planner II Planner I 1200 Part-Time Wages - - - - - - - 0.00% 1300 Over-Time Wages 5,000 5,000 1,349 823 3,533 5,705 (705) -14.10% 1400 Employee Benefits 155,000 180,000 40,725 31,992 34,507 107,224 72,776 40.43% Total Personnel 545,000 605,000 146,640 $ 123,803 $ 133,934 $ 404,377 $ 200,623 $ 33.16% Operating Expenses 2100 Books, Subscriptions, Memb. 5,000 5,000 684 346 - 1,030 3,970 79.40% 2300 Travel 5,000 5,000 1,986 - 48 2,034 2,966 59.33% 2400 Office Supplies 500 500 - - - - 500 100.00% 2500 Equipment/Supplies 1,500 1,500 - - - - 1,500 100.00% Total Operating 12,000 12,000 2,670 $ 346 $ 48 $ 3,064 $ 8,936 $ 74.47% Professional & Contracted Services 3100 Professional Services 100,000 130,000 25,938 63,637 6,658 96,232 33,768 25.98% John Janson Traffic Studies Impact Fee Study 3200 Contracted Services SL County Addressing 15,000 12,000 3,790 2,600 740 7,130 4,870 40.58% SL County Planning & Dev. 2,500 2,500 - - - - 2,500 100.00% SL County Surveying 7,000 10,000 3,540 1,650 7,020 12,210 (2,210) -22.10% 3300 Training 7,500 7,500 3,238 180 665 4,083 3,417 45.56% 3400 Printing 5,000 5,000 67 - - 67 4,933 98.66% Total Professional & Contracted 137,000 167,000 36,573 $ 68,067 $ 15,083 $ 119,722 $ 47,278 $ 28.31% Miscellaneous Expenses 6100 Misc. Expenses 2,500 2,500 42 243 - 285 2,215 88.59% Total Misc. 2,500 2,500 42 $ 243 $ - $ 285 $ 2,215 $ 88.59% Total Planning & Zoning 696,500 $ 786,500 $ 185,925 $ 192,460 $ 149,064 $ 527,449 $ 259,051 $ 32.94% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Various line items will need to be adjusted with the next budget amendment however budget available is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-4920 Promise Program Personnel Services 1100 Salaries & Wages 54,080 55,000 14,422 12,769 14,933 42,125 12,875 23.41% Promise Program Manager 1200 Part-Time Wages 5,000 5,000 - - - - 5,000 100.00% 1300 Over-Time Wages 2,500 3,500 994 371 562 1,927 1,573 44.94% 1400 Employee Benefits 20,000 22,000 5,524 4,514 5,200 15,238 6,762 30.74% Total Personnel 81,580 85,500 20,941 $ 17,654 $ 20,695 $ 59,290 $ 26,210 $ 30.66% Operating Expenses 2100 Books, Subscriptions, Memb. 600 600 375 70 - 445 155 25.88% 2300 Travel 2,000 2,000 131 128 135 395 1,605 80.27% 2400 Office Supplies - - - - - - - 0.00% 2500 Equipment/Supplies 2,500 2,500 - - - - 2,500 100.00% Total Operating 5,100 5,100 506 $ 198 $ 135 $ 839 $ 4,261 $ 83.54% Professional & Contracted Services 3100 Professional Services 3,400 3,400 194 303 1,500 1,996 1,404 41.28% 3300 Training 1,000 1,000 150 - 511 661 339 33.90% 3400 Printing 500 500 14 - - 14 486 97.12% Total Professional & Contracted 4,900 4,900 358 $ 303 $ 2,011 $ 2,672 $ 2,228 $ 45.47% Miscellaneous Expenses 6100 Misc. Expenses 2,000 2,000 620 165 1,180 1,965 35 1.74% Total Misc. 2,000 2,000 620 $ 165 $ 1,180 $ 1,965 $ 35 $ 1.74% Community Programs 8200 Events 6,420 11,278 1,496 152 702 2,350 8,928 79.16% Total Community Programs 6,420 11,278 1,496 $ 152 $ 702 $ 2,350 $ 8,928 $ 79.16% Total Promise Program 100,000 $ 108,778 $ 23,921 $ 18,472 $ 24,723 $ 67,116 $ 41,662 $ 38.30% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget is within expected parameters. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) 100-5100 PUBLIC WORKS 100-5110 Public Works Personnel Services 1100 Salaries & Wages 475,000 530,000 128,848 118,716 149,352 396,916 133,084 25.11% Public Works Director Stormwater Engineer Staff Engineer II Staff Engineer I Public Works Inspector II Public Works Inspector II GIS/Website Technician 1200 Part-Time Wages 15,000 30,000 13,473 14,590 - 28,063 1,937 6.46% 1300 Over-Time Wages 500 5,000 2,083 475 842 3,400 1,600 32.01% 1400 Employee Benefits 195,000 220,000 52,942 42,370 52,462 147,773 72,227 32.83% Total Personnel 685,500 785,000 197,346 $ 176,151 $ 202,656 $ 576,152 $ 208,848 $ 26.60% Operating Expenses 2100 Books, Subscriptions, Memb. 5,000 7,500 3,175 305 50 3,530 3,970 52.93% 2300 Travel 3,500 3,500 - 681 583 1,264 2,236 63.88% 2400 Office Supplies - - - - - - - 0.00% 2500 Equipment/Supplies 3,000 3,000 444 - - 444 2,556 85.19% 2800 Postage & Shipping - - - - - - - 0.00% Total Operating 11,500 14,000 3,619 $ 986 $ 633 $ 5,238 $ 8,762 $ 62.58% Professional & Contracted Services 3100 Professional Services 250,000 150,000 4,300 22,003 - 26,303 123,698 82.47% Development Review Services 3200 Contracted Services SL County Parks - 420,000 - - 219,207 219,207 200,793 47.81% SL County Public Works 3,268,750 3,118,750 - - 803,367 803,367 2,315,383 74.24% SL County Street Lights 37,500 37,500 6,874 10,597 10,127 27,598 9,902 26.41% 3300 Training 5,000 5,000 95 555 - 650 4,350 87.00% 3400 Printing - - - - - - - 0.00% Total Professional & Contracted 3,561,250 3,731,250 11,269 $ 33,155 $ 1,032,701 $ 1,077,125 $ 2,654,125 $ 71.13% Miscellaneous Expenses 6100 Misc. Expenses 2,500 2,500 - - 13 13 2,487 99.48% Total Misc. 2,500 2,500 - $ - $ 13 $ 13 $ 2,487 $ 99.48% Total Public Works 4,260,750 $ 4,532,750 $ 212,233 $ 210,292 $ 1,236,003 $ 1,658,528 $ 2,874,222 $ 63.41% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget available is higher than expected since not all invoices from SL County have been received. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) Fund 111 Class B & C Road Class B & C Road Expenditures 4910 Class C - Road Maintenance 1,700,000 2,100,000 - - 846,765 846,765 1,253,235 59.68% 4920 Class C - Sidewalk - - - - - - - - 4930 Class C - Traffic Calming - - - - - - - - 4930 Class C - Storm Drain - - - - - - - - 4940 Class C - Active Transportation - - - - - - - - Total Class B & C Road 1,700,000 $ 2,100,000 $ - $ - $ 846,765 $ 846,765 $ 1,253,235 $ 59.68% Notes: Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET Budget available is higher than expected since not all invoices from SL County have been received. ---PAGE BREAK--- FY 2019-20 Adopted Budget FY 2019-20 Amendment #3 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Budget Available % Budget Available (25% of Fiscal Year Remaining) Total General Fund Expenses 25,220,000 $ 26,964,927 $ 6,242,159 $ 4,574,262 $ 6,251,027 $ 17,135,792 $ 9,829,135 $ 36.45% Department Budget MILLCREEK FY 2019-20 GENERAL FUND EXPENSE BUDGET ---PAGE BREAK--- Millcreek FY 2019-20 Capital Improvement Budget Quarterly Report ---PAGE BREAK--- FY 2018-19 Balances Carried Forward FY 2019-20 Adopted Budget FY 2019-20 Amendment #2 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Balance Available % Budget Available CAPITAL IMPROVEMENT PROJECT FUND Capital Projects Expenses 450-5410 Capital Improvement Projects 7310 General CIP 158,142 350,000 508,142 - - 8,502 8,502 499,640 $ 98.33% 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 Bridge (300 W) Repair 3900 S: Jordan River to 700 E 3800 S Skyline HS Intersection 7320 Sidewalk Projects 1,537,323 355,000 1,892,323 11,132 58,810 4,678 74,619 1,817,704 $ 96.06% 4705 S: 1380 E to 1450 E SW Misc. Repair - Overlays SW 50/50 Program SW Cutting (Trip Hazards) 4500 S: 1380 E to 1450 E SW Main Street - AT & 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 MILLCREEK FY 2019-20 CAPITAL IMPROVEMENT FUND EXPENSE BUDGET ---PAGE BREAK--- FY 2018-19 Balances Carried Forward FY 2019-20 Adopted Budget FY 2019-20 Amendment #2 1st Quarter Expenditures 2nd Quarter Expenditures 3rd Quarter Expenditures Total Expenditures Balance Available % Budget Available CAPITAL IMPROVEMENT PROJECT FUND Capital Projects Expenses 450-5410 Capital Improvement Projects 7330 Traffic Calming 2,629 100,000 102,629 - - 13,250 13,250 89,379 $ 87.09% Misc. Signs DFS ( Speed Signs) Neffs Lane 7340 Storm Drain 1,302 700,000 701,302 - 35,542 205,825 241,367 459,935 $ 65.58% Emergency CIP Hillside Lane Drainage 300 East: 3900 S to 4000 S Central Avenue Drainage Project Scott Avenue Drainage 7350 Active Transportation 28,456 150,000 178,456 1,496 47,177 - 48,673 129,783 $ 72.73% 3300 S. - x-walk (School for deaf & blind) Match - Misc. Locations TLC Circulation Study (SLC) 7360 Lighting 50,000 96,000 146,000 - - 78,653 78,653 67,347 $ 46.13% 7370 Misc. Projects 1,845,745 - 1,945,745 6,430 11,523 8,199 26,152 1,919,593 $ 98.66% CDBG Sunnyvale Park Mountair Streeetscape TLC 3300 Corridor Study 2300 S Roundabout Highland Drive Reconfiguration Other Misc. Projects Total CIP 3,623,597 $ 1,751,000 $ 5,474,597 $ 19,058 $ 153,052 $ 319,107 $ 491,216 $ 4,983,381 $ 91.03% MILLCREEK FY 2019-20 CAPITAL IMPROVEMENT FUND EXPENSE BUDGET