Loading...
HomeMy WebLinkAboutBudget Summary Report.pdfCITY OF REXBURG BUDGET SUMMARY REPORT FY 2017 4 months ending 1/31/2017 Page 1 EXPENDITURES BUDGET ACTUAL 33%FORECAST OPERATING EXPENDITURES Arts 374,100 120,215 32%379,100 Building Maintenance 37,700 12,813 34%37,700 Building Safety 698,100 250,903 36%736,100 Customer Services 351,300 95,113 27%351,300 Economic Development 283,700 115,857 41%313,500 Emergency Services 3,376,900 1,108,279 33%3,200,900 Financial Management 810,700 269,254 33%810,700 GIS 436,200 157,348 36%436,200 Golf Courses 448,900 97,239 22%448,900 Human Resources 105,100 34,055 32%103,100 Information Technology 461,700 119,709 26%461,700 Legacy Flight Museum 56,100 31,663 56%56,100 Legal Services 226,500 77,295 34%226,500 Mayor, Council & Mayor's Youth Advisory Board 376,000 128,174 34%376,000 Miscellaneous 51,400 8,213 16%52,900 Parks & Ball Diamonds 557,600 131,412 24%557,600 Planning & Zoning 261,500 72,473 28%261,500 Recreation Administration & Programs 519,000 86,577 17%519,000 Rexburg Rapids 432,800 26,417 6%432,800 Police Department Administration Division & Fund 09 1,102,100 321,224 29%1,102,100 Patrol Division & Funds 13 2,095,900 644,657 31%2,103,900 Investigations Division 647,900 226,731 35%647,900 Community Services Division & Funds 08,11,14 566,400 176,024 31%570,700 Total Police Department 4,412,300 1,368,636 31%4,424,600 Public Works Shop 480,200 160,714 33%480,200 Sanitation 1,934,400 578,608 30%1,934,400 Water 2,395,200 774,195 32%2,398,700 Wastewater - Treatment 2,275,900 803,797 35%2,299,900 Wastewater - Collections 1,370,700 406,174 30%1,370,700 Street Operations 1,882,300 482,248 26%1,891,300 Street Repair Contracts 240,000 10,678 4%245,000 Total Public Works 10,578,700 3,216,414 30%10,620,200 TOTAL OPERATING EXPENDITURES 24,856,300 7,528,059 30%24,806,400 CAPITAL EXPENDITURES Engineering 624,300 210,694 34%624,300 Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,85 20,755,200 4,627,982 22%21,952,000 Contributed Capital 2,600,000 0%2,600,000 Capital Reserve Funds 07,18,20,33,34,35,38 1,885,900 232,064 12%2,375,900 LID Debt Service Funds 59-69 1,166,100 52,612 5%1,166,100 Trust & RLF Funds 15,16,19,21,22,90,91 211,400 16,688 8%211,600 TOTAL CAPITAL EXPENDITURES 27,242,900 5,140,040 19%28,929,900 Contingent Operating Expenses 2,577,000 0%2,297,700 Contingent Capital Expenses 2,149,800 0%1,682,100 Internal Transfers Out for Operations 2,899,500 6,132 0%3,179,300 Internal Transfers Out for Capital 17,323,000 0%17,175,600 TOTAL EXPENDITURES FOR ALL FUNDS 77,048,500 12,674,231 16%78,071,000 CITY OF REXBURG BUDGET SUMMARY REPORT FY 2017 4 months ending 1/31/2017 Page 2 REVENUES BUDGET ACTUAL 33%FORECAST OPERATING REVENUES County Road Tax 844,000 467,788 55%844,000 Federal Grants 497,000 109,034 22%462,000 Franchise Fees 1,629,400 401,040 25%1,629,400 Fund Balances for Operations 1,951,400 0%2,795,000 Investment Earnings 161,500 -120,880 -75%161,500 Interfund Charges for Services 2,873,700 927,900 32%2,873,700 Miscellaneous 529,300 145,381 27%529,300 Operating Contributions 2,806,000 727,829 26%2,718,000 Parks, Recreation, Museums, Arts, Golf 1,219,100 85,038 7%1,222,800 Permits & Licenses 737,200 273,928 37%737,200 Property Tax 4,314,400 2,513,464 58%4,314,400 State Taxes & Grants 2,695,900 618,781 23%2,705,900 Utility Charges -Water 2,489,000 637,881 26%2,489,000 Utility Charges -Wastewater 4,162,000 1,339,632 32%4,162,000 Utility Charges -Sanitation 1,975,000 690,070 35%1,975,000 TOTAL OPERATING REVENUES 28,884,900 8,816,886 31%29,619,200 CAPITAL REVENUES Borrowing 5,888,700 956,446 16%5,888,700 Capital Reserve Funds 5,006,100 817,257 16%6,214,500 Construction Funds 5,358,400 71,502 1%5,139,200 Contributed Capital 2,485,000 0%2,813,500 Engineering Billings 623,300 0%623,300 Fund Balances for Capital 3,563,600 0%4,119,000 Grants 2,444,500 -39,519 -2%2,444,500 LID Funds 498,100 47,493 10%498,100 Trust Funds 1,529,800 478,739 31%1,623,700 TOTAL CAPITAL REVENUES 27,397,500 2,331,918 9%29,364,500 Contingent Operating Revenues 34,800 0%2,800 Contingent Capital Revenues 508,800 0%508,800 Internal Transfers In for Operations 2,889,500 6,132 0%3,158,800 Internal Transfers In for Capital 17,333,000 0%17,170,600 TOTAL REVENUES ALL FUNDS 77,048,500 11,154,936 14%79,824,700 OPERATIONS SUMMARY TOTAL OPERATING REVENUES 28,884,900 8,816,886 31%29,619,200 TOTAL OPERATING EXPENDITURES 24,856,300 7,528,059 30%24,806,400 ---NET OPERATIONS 4,028,600 1,288,827 0%4,812,800 CAPITAL SUMMARY TOTAL CAPITAL REVENUES 27,397,500 2,331,918 9%29,364,500 TOTAL CAPITAL EXPENDITURES 27,242,900 5,140,040 19%28,929,900 ---NET CAPITAL TRANSACTIONS 154,600 -2,808,122 -10%434,600 TOTAL ALL REVENUES 77,048,500 11,154,936 14%79,824,700 TOTAL ALL EXPENDITURES 77,048,500 12,674,231 16%78,071,000 NET ALL REVENUES OVER EXPENDITURES 0 -1,519,295 -2%1,753,700 CITY OF REXBURG CASH & INVESTMENT FY 2017 BALANCE REPORT Page 3 BALANCE AS OF CASH & INVESTMENTS*1/31/2017 Bank of Commerce Legacy Flight Museum Checking 45,219 0.19% Beehive Credit Union CD 250,000 1.08% Cash On Hand 1,350 0.01% Citizens Community Bank CDARS 1,431,886 6.17% Citizens Community Bank Checking (RLF)158,891 0.68% Idaho Central Credit Union CD 250,000 1.08% Idaho Central Credit Union Savings 25 0.00% Moreton Asset Management Government Securities 3,655,435 15.75% Real Estate Investments (Streets)307,085 1.32% State Diversified Bond Fund 7,430,646 32.02% State Local Government Investment Pool--City 1,261,206 5.44% State Local Government Investment Pool--Fire District 435 0.00% Wells Fargo Bank Drug Fund Checking 19,084 0.08% Wells Fargo Bank Fire District Checking & Savings 641,433 2.76% Zions Bank Capital Advisors 2,505,893 10.80% Zions Bank Collateralized Acct 4,222,337 18.20% Zions Bank Direct Auction-Agencies 444,724 1.92% Zions Bank Direct Auction-CD 200,000 0.86% Zions Bank General Checking 359,096 1.55% Zions Bank Payroll Checking 20,454 0.09% TOTAL 23,205,199 100.00% Percentage of Portfolio