Loading...
HomeMy WebLinkAboutBudget Summary Report - Jan 2020CITY OF REXBURG BUDGET SUMMARY REPORT FY 2020 4 months ending 1/31/2020 Page 1 EXPENDITURES BUDGET ACTUAL 33%FORECAST OPERATING EXPENDITURES Misc. Departments/Categories Arts 645,400 112,011 17%644,800 Building Safety 839,600 275,182 33%839,600 Customer Services 316,200 115,738 37%306,900 Economic Development 396,400 150,239 38%399,900 Emergency Services 4,634,200 1,289,754 28%4,634,200 Financial Management 894,400 330,992 37%895,800 GIS 427,400 157,849 37%427,400 Golf Courses 813,200 203,776 25%853,700 Human Resources 145,100 47,676 33%141,600 Information Technology 695,600 212,663 31%705,600 Legacy Flight Museum 117,900 7,575 6%118,300 Legal Services 273,000 86,986 32%273,000 Mayor, Council & Mayor's Youth Advisory Board 328,100 113,819 35%329,300 Miscellaneous 49,300 7,699 16%49,600 Parks & Ball Diamonds 732,800 193,666 26%730,300 Planning & Zoning 385,400 115,133 30%385,400 Recreation Administration & Programs 547,600 168,771 31%506,400 Rexburg Rapids 726,200 231,996 32%638,200 Total Misc. Departments/Categories 12,967,800 3,821,525 29%12,880,000 Police Department Administration Division & Fund 09 1,363,500 439,591 32%1,309,000 Patrol Division & Funds 13 2,385,800 719,812 30%2,382,800 Investigations Division 750,900 275,282 37%750,900 Community Services Division & Funds 08,11,14 731,800 228,614 31%729,900 Total Police Department 5,232,000 1,663,299 32%5,172,600 Public Works Building Maintenance 52,800 15,247 29%52,800 Shop 610,700 176,816 29%610,700 Sanitation 2,266,500 687,862 30%2,266,500 Water 3,039,100 908,990 30%3,039,100 Wastewater - Treatment 2,976,900 1,062,666 36%2,976,900 Wastewater - Collections 1,735,400 568,787 33%1,735,400 Street Operations 2,669,700 852,721 32%2,397,700 Total Public Works 13,351,100 4,273,089 32%13,079,100 TOTAL OPERATING EXPENDITURES 31,550,900 9,757,913 31%31,131,700 CAPITAL EXPENDITURES Engineering 563,800 189,464 34%563,800 Street Repair Contracts 150,400 184,725 123%403,800 Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 14,776,500 2,156,205 15%16,808,700 Contributed Capital Offset 1,675,000 8,333 0%1,675,000 Capital Reserve Funds 07,18,20,33,34,35,38 627,200 123,693 20%564,200 LID Debt Service Funds 59-69 1,169,600 0%1,169,600 Trust & RLF Funds 15,16,19,21,22,90,91 554,600 47,134 8%596,900 TOTAL CAPITAL EXPENDITURES 19,517,100 2,709,554 14%21,782,000 Contingent Operating Expenses 4,136,600 0%4,328,200 Contingent Capital Expenses 2,269,400 0%2,415,000 Internal Transfers Out for Operations 4,385,300 835,399 19%4,616,900 Internal Transfers Out for Capital 6,180,000 125,000 2%8,208,900 TOTAL EXPENDITURES FOR ALL FUNDS 68,039,300 13,427,866 20%72,482,700 CITY OF REXBURG BUDGET SUMMARY REPORT FY 2020 4 months ending 1/31/2020 Page 2 REVENUES BUDGET ACTUAL 33%FORECAST OPERATING REVENUES County Road Tax 890,000 460,535 52%890,000 Federal Grants 844,600 40,662 5%822,800 Franchise Fees 1,771,400 484,015 27%1,771,500 Fund Balances for Operations 2,246,600 0%3,283,200 Investment Earnings 198,600 53,924 27%198,600 Unrealized Gain (Loss)3,927 0% Interfund Charges for Services - Overhead 3,381,300 1,114,566 33%3,381,300 Miscellaneous 543,000 176,774 33%542,100 Operating Contributions 3,234,300 513,776 16%3,245,300 Parks, Recreation, Museums, Arts, Golf 1,380,600 130,508 9%1,410,100 Permits & Licenses 786,600 208,400 26%777,300 Property Tax 5,054,700 2,990,062 59%5,054,700 State Taxes & Grants 3,700,200 890,331 24%3,480,100 Utility Charges -Water 3,169,300 872,796 28%3,169,300 Utility Charges -Wastewater 5,127,800 1,739,307 34%5,127,800 Utility Charges -Sanitation 2,299,300 845,007 37%2,299,300 TOTAL OPERATING REVENUES 34,628,300 10,524,590 30%35,453,400 CAPITAL REVENUES Borrowing - DEQ Water Loan 1,305,300 575,237 44%1,305,300 Capital Reserve Fees & Impact Fees 2,125,500 469,076 22%2,101,500 Capital Reserve Carryover Balances 2,195,500 0%5,500,200 Construction Funds 7,382,400 86,611 1%7,809,600 Contributed Capital 1,425,000 8,333 1%1,425,000 Engineering Billings 563,100 0%563,100 Fund Balances for Capital 1,147,100 0%2,931,500 Grants & Contributions 3,331,800 0%3,438,400 LID Funds 201,000 20,654 10%201,000 Trust Funds 2,019,400 118,550 6%2,097,100 TOTAL CAPITAL REVENUES 21,696,100 1,278,461 6%27,372,700 Contingent Operating Revenues 0% Contingent Capital Revenues 0% Internal Transfers In for Operations 4,359,800 826,899 19%4,591,400 Internal Transfers In for Capital 7,355,100 133,333 2%9,202,200 TOTAL REVENUES ALL FUNDS 68,039,300 12,763,283 19%76,619,700 OPERATIONS SUMMARY TOTAL OPERATING REVENUES 38,988,100 11,351,489 30%40,044,800 TOTAL OPERATING EXPENDITURES 40,072,800 10,593,312 31%40,076,800 ---NET OPERATIONS -1,084,700 758,177 -32,000 CAPITAL SUMMARY TOTAL CAPITAL REVENUES 29,051,200 1,411,794 6%36,574,900 TOTAL CAPITAL EXPENDITURES 27,966,500 2,834,554 14%32,405,900 ---NET CAPITAL TRANSACTIONS 1,084,700 -1,422,760 4,169,000 TOTAL ALL REVENUES 68,039,300 12,763,283 19%76,619,700 TOTAL ALL EXPENDITURES 68,039,300 13,427,866 20%72,482,700 NET ALL REVENUES OVER EXPENDITURES 0 -664,583 4,137,000 CITY OF REXBURG CASH & INVESTMENT FY 2020 BALANCE REPORT Page 3 BALANCE AS OF CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 1/31/2020 Bank of Commerce Bank CD 249,009 0.81%249,009 Bank of Commerce Legacy FM 44,677 0.15%44,677 Beehive Credit Union CD 250,152 0.81%250,152 Cash On Hand 1,150 0.00%1,150 City Golf Cart CD 91,920 0.30%91,920 Idaho Central Credit Union CD 250,000 0.81%250,000 Idaho Central Credit Union Savings 25 0.00%25 Key Bank Checking (RLF)356,252 1.16%356,252 Moreton Asset Management 2,234,250 2,992,537 16.99%5,226,787 Real Estate Investments (Streets)324,863 1.06%324,863 State Diversified Bond Fund 1,172,415 2,115,273 744,886 13.11%4,032,574 State LGIP--City 5,845,135 209,418 19.68%6,054,553 State LGIP--Fire District 595,080 21,320 2.00%616,400 TVI - Bond Investment 0 2,990,016 9.72%2,990,016 Wells Fargo Drug Fund Checking 14,416 0.05%14,416 Wells Fargo Fire District Banking 465,755 1.51%465,755 Westmark CD 249,990 0.81%249,990 Zions Bank Capital Advisors 3,264,130 1,880,635 16.72%5,144,765 Zions Bank Collateralized Acct 215,841 0.70%215,841 Zions Bank General Checking 4,166,190 13.54%4,166,190 Zions Bank Payroll Checking 19,997 0.06%19,997 TOTAL 19,811,247 10,209,199 744,886 100%30,765,332 % OF TOTAL PORTFOLIO 64.4%33.2%2.4%100% I, Matthew K. Nielson, as Treasurer of the City of Rexburg, hereby under oath, certify to best of my knowledge, that the above accounting of expenses, revenues, and cash and investment balances is true and correct. % of Total Portfolio