Loading...
HomeMy WebLinkAbout2015 forecast as of 10-6-15.pdfUser: mattn 15.05.05.09.19 Budget Totals Report Page 1 Account: 01 City of Rexburg Date: 10/06/2015 Time: 18:16:35 2013 2014 2015 1509 100% 2015 2016 2017 Account Description Actual Actual Budget Actual YTD Forecast Budget Budget ———————————————————————————————— —————————————————————————————— ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— GENERAL FUND REVENUES TOTAL PROPERTY TAXES 3,231,735.12 3,321,468.58 3,688,300.00 3,647,514.10 98 3,688,300.00 4,000,600.00 TOTAL FRANCHISE FEES 524,310.41 508,657.87 515,400.00 381,130.65 73 488,400.00 505,900.00 TOTAL MISCELLANEOUS 49,606.90 62,953.74 41,900.00 44,634.37 106 44,900.00 64,800.00 TOTAL STATE OF IDAHO REVENUES 1,145,478.71 1,276,679.31 1,325,300.00 1,002,403.46 75 1,347,100.00 1,409,600.00 TOTAL MISCELLANEOUS 1,327,685.76 1,809,629.60 1,642,100.00 1,755,104.35 106 1,785,400.00 1,196,300.00 TOTAL INTERFUND CHARGES 2,758,272.86 2,872,766.49 2,977,000.00 2,386,253.00 80 2,943,000.00 3,244,900.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL GENERAL FUND REVENUES 9,037,089.76 9,852,155.59 10,190,000.00 9,217,039.93 90 10,297,100.00 10,422,100.00 GENERAL FUND EXPENSES TOTAL PERSONNEL TOTAL OPERATIONS TOTAL CAPITAL ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL PUBLIC AFFAIRS **HUMAN RESOURCE MANAGMENT TOTAL PERSONNEL -71,000.00 TOTAL OPERATIONS -9,100.00 TOTAL CAPITAL -2,000.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL HUMAN RESOURCE MNGMT -82,100.00 **MAYOR & COUNCIL TOTAL PERSONNEL COSTS -186,906.83 -210,191.12 -220,300.00 -225,058.14 102 -225,200.00 -230,200.00 TOTAL OPERATIONS -58,752.15 -54,427.96 -60,200.00 -52,329.90 86 -54,400.00 -56,300.00 TOTAL CAPITAL -3,773.10 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL MAYOR & COUNCIL -245,658.98 -268,392.18 -280,500.00 -277,388.04 98 -279,600.00 -286,500.00 *ECONOMIC DEVELOPMENT/PUB AFF* TOTAL PERSONNEL -137,526.63 -147,845.13 -150,000.00 -152,841.17 101 -152,900.00 -187,100.00 TOTAL OPERATIONS -34,284.78 -34,706.98 -42,000.00 -31,944.61 76 -32,800.00 -39,600.00 TOTAL CAPITAL -800.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL ECON DEV./PUBLIC AFFAIRS -171,811.41 -182,552.11 -192,800.00 -184,785.78 95 -185,700.00 -226,700.00 **CUSTOMER SERVICES TOTAL PERSONNEL -258,838.96 -275,851.40 -284,100.00 -281,781.21 99 -283,700.00 -322,800.00 TOTAL OPERATIONS -24,822.85 -22,069.87 -24,700.00 -25,890.88 104 -27,700.00 -26,000.00 TOTAL CAPITAL -1,200.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL CUSTOMER SERVICES -283,661.81 -297,921.27 -308,800.00 -307,672.09 99 -311,400.00 -350,000.00 **INFORMATION TECHNOLOGY TOTAL PERSONNEL -289,477.78 -315,231.83 -369,000.00 -340,285.74 92 -340,300.00 -360,800.00 TOTAL OPERATIONS -20,843.43 -27,360.64 -31,000.00 -35,712.89 115 -37,500.00 -49,300.00 TOTAL CAPITAL -38,915.48 -28,585.93 -43,100.00 -30,234.19 70 -45,800.00 -31,000.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL INFORMATION TECHNOLOGY -349,236.69 -371,803.40 -443,100.00 -406,232.82 91 -423,600.00 -441,400.00 **FINANCIAL MANAGEMENT TOTAL PERSONNEL -578,708.47 -593,555.44 -499,200.00 -476,575.93 95 -476,800.00 -544,500.00 TOTAL OPERATIONS -177,429.09 -178,780.43 -272,300.00 -227,235.23 83 -233,700.00 -249,100.00 TOTAL CAPITAL -10,533.60 -82,400.00 -26,086.00 31 -82,900.00 -44,700.00 TOTAL OTHER -5,034.00 -7,600.00 -7,596.00 99 -6,300.00 -8,000.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL FINANCIAL MANAGEMENT -766,671.16 -777,369.87 -861,500.00 -737,493.16 85 -799,700.00 -846,300.00 **LEGAL TOTAL PERSONNEL -219,860.70 -207,090.37 -205,400.00 -205,099.62 99 -205,800.00 -208,100.00 User: mattn 15.05.05.09.19 Budget Totals Report Page 2 Account: 01 City of Rexburg Date: 10/06/2015 Time: 18:16:35 2013 2014 2015 1509 100% 2015 2016 2017 Account Description Actual Actual Budget Actual YTD Forecast Budget Budget ———————————————————————————————— —————————————————————————————— ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL OPERATIONS -16,392.21 -18,579.15 -14,800.00 -10,896.70 73 -11,500.00 -21,200.00 TOTAL CAPITAL -2,648.00 -2,700.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL LEGAL -236,252.91 -225,669.52 -220,200.00 -218,644.32 99 -220,000.00 -229,300.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— **ECONOMIC DEVELOPMENT TOTAL ECONOMIC DEVELOPMENT **POLICE PATROL TOTAL PERSONNEL -1,377,339.26 -1,405,154.45 -1,483,600.00 -1,452,036.49 97 -1,452,700.00 -1,651,300.00 TOTAL OPERATIONS -186,557.81 -179,948.51 -192,100.00 -159,118.41 82 -162,600.00 -212,600.00 TOTAL CAPITAL -181,950.11 -184,233.26 -203,300.00 -195,980.68 96 -196,500.00 -211,500.00 TOTAL OTHER -9,995.00 -13,000.00 -12,996.00 99 -6,200.00 -8,000.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL POLICE PATROL -1,745,847.18 -1,779,331.22 -1,892,000.00 -1,820,131.58 96 -1,818,000.00 -2,083,400.00 **POLICE ADMINISTRATION TOTAL PERSONNEL -608,890.73 -653,304.35 -680,400.00 -667,712.48 98 -669,400.00 -696,500.00 TOTAL OPERATIONS -328,915.75 -292,329.80 -350,900.00 -301,352.91 85 -322,400.00 -350,400.00 TOTAL CAPITAL -38,333.66 -59,834.64 -36,000.00 -28,311.10 78 -32,300.00 -43,000.00 TOTAL OTHER -18,313.04 -596.00 -1,000.00 -996.00 99 -1,200.00 -1,500.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL POLICE ADMINISTRATION -994,453.18 -1,006,064.79 -1,068,300.00 -998,372.49 93 -1,025,300.00 -1,091,400.00 **POLICE DETECTIVES TOTAL PERSONNEL -549,381.32 -552,210.61 -581,300.00 -572,853.99 98 -573,100.00 -579,500.00 TOTAL OPERATIONS -68,952.86 -60,060.46 -74,500.00 -67,113.97 90 -72,000.00 -72,400.00 TOTAL CAPITAL -64,968.15 -5,696.53 -28,500.00 -33,442.85 117 -33,500.00 -1,000.00 TOTAL OTHER -852.00 -1,000.00 -996.00 99 -3,300.00 -3,800.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL POLICE DETECTIVES -683,302.33 -618,819.60 -685,300.00 -674,406.81 98 -681,900.00 -656,700.00 **BUILDING SAFETY TOTAL PERSONAL TOTAL OPERATIONS TOTAL CAPITAL ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL BUILDING SAFETY **POLICE COMMUNITY POLICING TOTAL PERSONNEL -329,638.92 -350,444.80 -372,300.00 -359,122.46 96 -359,400.00 -369,200.00 TOTAL OPERATIONS -42,408.91 -38,119.09 -41,100.00 -34,262.97 83 -35,300.00 -38,300.00 TOTAL CAPITAL -11,628.26 -19,150.51 -9,000.00 -8,991.55 99 -9,200.00 -7,200.00 TOTAL OTHER -1,335.00 -2,000.00 -2,004.00 100 -700.00 -1,000.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL POLICE COMMUNITY POLICIN -383,676.09 -409,049.40 -424,400.00 -404,380.98 95 -404,600.00 -415,700.00 **ENGINEERING TOTAL PERSONNEL -372,705.56 -427,955.70 -442,500.00 -445,618.98 100 -445,800.00 -475,000.00 TOTAL OPERATIONS -54,660.99 -52,293.07 -58,500.00 -41,241.13 70 -36,800.00 -42,200.00 TOTAL CAPITAL -4,169.55 -4,000.00 -3,560.40 89 -3,600.00 -40,800.00 TOTAL OTHER -79,043.00 -84,433.00 -86,000.00 -85,992.00 99 -85,200.00 -86,400.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL ENGINEERING -510,579.10 -564,681.77 -591,000.00 -576,412.51 97 -571,400.00 -644,400.00 **PUBLIC WORKS DIRECTOR TOTAL PERSONNEL TOTAL OPERATIONS TOTAL CAPITAL ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL PUBLIC WORKS DIRECTOR User: mattn 15.05.05.09.19 Budget Totals Report Page 3 Account: 01 City of Rexburg Date: 10/06/2015 Time: 18:16:35 2013 2014 2015 1509 100% 2015 2016 2017 Account Description Actual Actual Budget Actual YTD Forecast Budget Budget ———————————————————————————————— —————————————————————————————— ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— **SHOP TOTAL PERSONNEL -264,575.39 -288,301.96 -305,600.00 -315,067.39 103 -315,500.00 -337,300.00 TOTAL OPERATIONS -74,028.23 -68,144.81 -81,000.00 -74,382.42 91 -77,400.00 -75,700.00 TOTAL CAPITAL -6,670.36 -7,338.85 -19,300.00 -6,221.46 32 -8,100.00 -40,400.00 TOTAL OTHER -65,600.00 -60,400.00 -63,700.00 -63,696.00 99 -63,700.00 -69,400.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL SHOP -410,873.98 -424,185.62 -469,600.00 -459,367.27 97 -464,700.00 -522,800.00 **PARKS TOTAL PERSONNEL -287,821.71 -293,580.89 -297,000.00 -301,117.82 101 -301,600.00 -296,200.00 TOTAL OPERATIONS -137,779.22 -137,850.15 -165,000.00 -134,127.76 81 -148,700.00 -158,700.00 TOTAL CAPITAL -263,771.36 -740,840.14 -71,100.00 -49,958.26 70 -54,800.00 -48,000.00 TOTAL OTHER -24,550.04 -29,455.00 -25,100.00 -25,104.00 100 -32,000.00 -35,000.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL PARKS -713,922.33 -1,201,726.18 -558,200.00 -510,307.84 91 -537,100.00 -537,900.00 **BALL DIAMONDS TOTAL PERSONNEL -1,199.16 -412.49 -3,400.00 -274.98 8 -1,000.00 -1,100.00 TOTAL OPERATIONS -8,434.09 -8,434.08 -14,900.00 -4,858.07 32 -5,100.00 -10,400.00 TOTAL CAPITAL -3,698.99 -5,300.00 -2,204.99 41 -2,300.00 TOTAL OTHER EXPENSES -483.00 -200.00 -204.00 102 -200.00 -200.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL BALL DIAMONDS -13,332.24 -9,329.57 -23,800.00 -7,542.04 31 -8,600.00 -11,700.00 **RECREATION ADMINISTRATION TOTAL PERSONNEL -112,775.23 -136,608.12 -216,900.00 -216,070.61 99 -217,100.00 -227,300.00 TOTAL OPERATIONS -25,727.97 -33,886.40 -41,300.00 -29,935.14 72 -33,200.00 -32,500.00 TOTAL CAPITAL -16,000.00 -19,010.31 118 -19,100.00 TOTAL OTHER -1,448.00 -200.00 -204.00 102 -1,400.00 -1,500.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— TOTAL RECR. ADMINISTRATION -138,503.20 -171,942.52 -274,400.00 -265,220.06 96 -270,800.00 -261,300.00 **MISCELLANEOUS TOTAL MISCELLANEOUS -17,775.26 -34,649.04 -26,100.00 -29,484.00 112 -31,800.00 -32,500.00 TOTAL CONTINGENCY -76,000.00 -25,000.00 -133,400.00 TOTAL FUND TRANSFERS -1,291,273.08 -1,348,837.63 -1,791,500.00 -73,703.85 4 -2,049,600.00 -1,568,600.00 TOTAL GENERAL FUND EXPENSES -8,956,830.93 -9,692,325.69 -10,187,500.00 -7,951,545.64 78 -10,108,800.00 -10,422,100.00 ——————————————— ——————————————— ——————————————— ——————————————— ————— ——————————————— ——————————————— ——————————————— GENERAL FUND NET 80,258.83 159,829.90 2,500.00 1,265,494.29 619 188,300.00 GRAND TOTAL REVENUE: 9,037,089.76 9,852,155.59 10,190,000.00 9,217,039.93 10,297,100.00 10,422,100.00 GRAND TOTAL EXPENSE: -8,956,830.93 -9,692,325.69 -10,187,500.00 -7,951,545.64 -10,108,800.00 -10,422,100.00 DIFFERENCE: 80,258.83 159,829.90 2,500.00 1,265,494.29 188,300.00