HomeMy WebLinkAboutBudget Summary ReportCITY OF REXBURG BUDGET SUMMARY REPORT
FY 2018 9 months ending
6/30/2018 Page 1
EXPENDITURES BUDGET ACTUAL 75%FORECAST
OPERATING EXPENDITURES
Arts 535,600 233,270 44%447,400
Building Safety 867,600 705,797 81%929,700
Customer Services 393,700 259,719 66%341,800
Economic Development 389,700 250,282 64%386,600
Emergency Services 3,656,300 2,780,446 76%3,860,300
Financial Management 891,200 615,680 69%848,100
GIS 399,000 273,869 69%380,200
Golf Courses 622,700 344,976 55%609,700
Human Resources 124,200 85,253 69%123,700
Information Technology 664,900 471,300 71%652,000
Legacy Flight Museum 151,400 109,347 72%161,600
Legal Services 231,500 179,878 78%233,300
Mayor, Council & Mayor's Youth Advisory Board 385,000 299,110 78%382,900
Miscellaneous 53,200 35,654 67%47,800
Parks & Ball Diamonds 729,600 397,670 55%727,300
Planning & Zoning 331,400 251,028 76%327,400
Recreation Administration & Programs 396,800 304,135 77%449,400
Rexburg Rapids 482,800 225,183 47%470,500
Police Department
Administration Division & Fund 09 1,177,000 847,127 72%1,199,600
Patrol Division & Funds 13 2,117,500 1,561,667 74%2,129,600
Investigations Division 699,400 537,643 77%703,600
Community Services Division & Funds 08,11,14 660,700 467,313 71%675,300
Total Police Department 4,654,600 3,413,750 73%4,708,100
Public Works
Building Maintenance 44,100 32,285 73%47,900
Shop 608,700 402,870 66%539,400
Sanitation 2,104,300 1,544,270 73%2,064,100
Water 2,709,900 1,979,310 73%2,775,900
Wastewater - Treatment 2,768,300 2,157,108 78%3,091,300
Wastewater - Collections 1,488,700 1,105,570 74%1,475,400
Street Operations 2,277,300 1,395,961 61%2,227,100
Street Repair Contracts 2,256,000 101,635 5%2,268,500
Total Public Works 14,257,300 8,719,009 61%14,489,600
TOTAL OPERATING EXPENDITURES 30,218,500 19,955,356 66%30,577,400
CAPITAL EXPENDITURES
Engineering 553,900 414,065 75%550,400
Construction 06,30,31,32,39,41,42,44,46,49,51-58,82,84,85 10,460,800 1,922,837 18%8,572,500
Contributed Capital Offset 2,070,000 0%2,070,000
Capital Reserve Funds 07,18,20,33,34,35,38 1,062,800 746,895 70%998,100
LID Debt Service Funds 59-69 1,119,300 209,368 19%1,174,200
Trust & RLF Funds 15,16,19,21,22,90,91 227,600 76,330 34%112,100
TOTAL CAPITAL EXPENDITURES 15,494,400 3,369,495 22%13,477,300
Contingent Operating Expenses 2,206,200 0%71,500
Contingent Capital Expenses 2,994,300 0%8,000
Internal Transfers Out for Operations 3,547,700 441,175 12%3,588,400
Internal Transfers Out for Capital 6,854,800 105,000 2%6,151,200
TOTAL EXPENDITURES FOR ALL FUNDS 61,315,900 23,871,026 39%53,873,800
CITY OF REXBURG BUDGET SUMMARY REPORT
FY 2018 9 months ending
6/30/2018 Page 2
REVENUES BUDGET ACTUAL 75%FORECAST
OPERATING REVENUES
County Road Tax 826,000 607,389 74%830,000
Federal Grants 509,200 96,353 19%577,300
Franchise Fees 1,723,000 1,040,746 60%1,768,500
Fund Balances for Operations 3,419,200 0%3,994,800
Investment Earnings 148,100 104,193 70%137,300
Unrealized Gain (Loss)-208,447 0%
Interfund Charges for Services 3,299,700 2,453,325 74%3,235,900
Miscellaneous 515,000 382,133 74%548,800
Operating Contributions 2,951,600 1,799,415 61%3,010,100
Parks, Recreation, Museums, Arts, Golf 1,279,700 638,665 50%1,225,200
Permits & Licenses 752,700 911,094 121%925,000
Property Tax 4,557,100 3,224,824 71%4,557,100
State Taxes & Grants 2,841,100 1,512,778 53%2,960,800
Utility Charges -Water 2,827,500 1,770,005 63%2,890,500
Utility Charges -Wastewater 4,677,600 3,383,418 72%4,704,300
Utility Charges -Sanitation 2,128,400 1,764,397 83%2,230,700
TOTAL OPERATING REVENUES 32,455,900 19,480,288 60%33,596,300
CAPITAL REVENUES
Borrowing 2,204,300 458,771 21%3,495,200
Capital Reserve Fees & Impact Fees 1,959,700 2,887,646 147%2,792,700
Capital Reserve Carryover Balances 2,196,500 0%3,355,400
Construction Funds 3,744,100 198,365 5%2,529,500
Contributed Capital 1,900,800 50,800 3%1,901,950
Engineering Billings 559,700 0%549,700
Fund Balances for Capital 1,410,000 0%1,176,300
Grants 808,800 39,542 5%801,500
LID Funds 357,400 30,951 9%197,100
Trust Funds 1,708,900 588,415 34%1,726,730
TOTAL CAPITAL REVENUES 16,850,200 4,254,490 25%18,526,080
Contingent Operating Revenues 0%
Contingent Capital Revenues 0%
Internal Transfers In for Operations 3,584,500 441,175 12%3,580,650
Internal Transfers In for Capital 8,425,300 219,900 3%6,166,800
TOTAL REVENUES ALL FUNDS 61,315,900 24,395,853 40%61,869,830
OPERATIONS SUMMARY
TOTAL OPERATING REVENUES 36,040,400 19,921,463 60%37,176,950
TOTAL OPERATING EXPENDITURES 35,972,400 20,396,531 66%34,237,300
---NET OPERATIONS 68,000 -475,068 2,939,650
CAPITAL SUMMARY
TOTAL CAPITAL REVENUES 25,275,500 4,474,390 25%24,692,880
TOTAL CAPITAL EXPENDITURES 25,343,500 3,474,495 22%19,636,500
---NET CAPITAL TRANSACTIONS -68,000 999,895 5,056,380
TOTAL ALL REVENUES 61,315,900 24,395,853 40%61,869,830
TOTAL ALL EXPENDITURES 61,315,900 23,871,026 39%53,873,800
NET ALL REVENUES OVER EXPENDITURES 0 524,827 7,996,030
CITY OF REXBURG CASH & INVESTMENT
FY 2018 BALANCE REPORT
Page 3
BALANCE AS
OF
CASH & INVESTMENTS < 1 YEAR 1-5 YEARS > 5 YEARS 6/30/2018
Bank of Commerce Legacy FM 40,332 0.16%40,332
Beehive Credit Union CD 250,000 1.01%250,000
Cash On Hand 4,350 0.02%4,350
Citizens Community Bank CDARS 752,870 3.04%752,870
Idaho Central Credit Union CD 250,000 1.01%250,000
Idaho Central Credit Union Savings 25 0.00%25
Key Bank Checking (RLF)283,090 1.14%283,090
Moreton Asset Management 1,472,949 2,268,274 15.10%3,741,223
Real Estate Investments (Streets)307,085 1.24%307,085
State Diversified Bond Fund 642,337 4,633,109 2,231,583 30.29%7,507,029
State LGIP--City 6,849,218 901,904 31.28%7,751,122
State LGIP--Fire District 388 51 0.00%439
Wells Fargo Drug Fund Checking 15,418 0.06%15,418
Wells Fargo Fire District Banking 270,800 1.09%270,800
Zions Bank Capital Advisors 1,037,209 2,151,290 12.87%3,188,499
Zions Bank Collateralized Acct 1,097,892 4.43%1,097,892
Zions Bank General Checking -697,303 -2.81%-697303
Zions Bank Payroll Checking 20,522 0.08%20,522
TOTAL 12,597,182 9,954,628 2,231,583 100%24,783,393
% OF TOTAL PORTFOLIO 50.8%40.2%9.0%100%
I, Matt 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
Portfolio