Loading...
HomeMy WebLinkAbout35. 4th Quarter Preliminary Revenue & Expense StatementsGeneral Fund Revenues - Fourth Quarter 2017 January 1, 2017 - December 31, 2017 (Preliminary) TAXES LEVIED BY CITY General Property Tax Municipal Owned Utility Snow Removal Weed Cutting Mobile Home Tax Payment in Lieu of Taxes TOTAL TAXES LEVIED LICENSES & PERMITS Liquor License Cigarette License Sundry License Assessor Fees Code Enforcement Zoning Ordinances TOTAL LICENSES & PERMITS FINES & COSTS County Court Police Dept. Penalties TOTAL FINES & COSTS ESTATE & COUNTY AIDS Town Ambulance Aid Aid to Local Streets Municipal Services State Shared Aids State/Fed Aids - Misc. State Aids - Fire Aids -Police State Computer Credit Expenditure Restraint TOTAL STATE & CO. AIDS FUSE OF MONEY & PROPERTY Interest on Investments Interest on Spec. Assess. Rent TOTAL USE OF MONEY & PROP. 2016 2016 2017 2017 BUDGETED Twelve Month % BUDGETED Twelve Month % REVENUES Actual Received REVENUES Actual Received $16,106,900 $16,095,825 99.93% $17,521,500 17,512,190 99.95% 1,000,000 1,000,000 100.00% 1,000,000 1,000,000 100.00% 87,300 50,579 57.94% 67,700 26,100 38.55% 37,500 24,258 64.69% 37,500 28,117 74.98% 125,000 137,836 110.27% 130,000 150,327 115.64% 105,000 133,104 126.77% 105,000 124,539 118.61% $17,461,700 $17,441,602 99.88% $18,861,700 $18,841,272 99.89% 130,700 133,039 101.79% $281,800 131,500 132,590 100.83% 419,567 7,000 6,560 93.71% 117.71% 6,800 6,700 98.53% 87,600 28,000 29,551 105.54% $783,652 27,000 29,293 108.49% 108.79% 128,900 131,644 102.13% 0 120,000 155,868 129.89% 156,864 0 (200) 0.00% 106.68% 0 0 0.00% 215,300 _83,900 143,777 171.37% 323,614 110,000 120,466 109.51% 284.94% $378,500 $444,371 117.40% $395,300 $444,916 112.55% $280,600 $266,531 94.99% $281,800 283,341 100.55% 438,800 419,567 95.62% 425,600 500,983 117.71% 85,700 97,554 113.83% 87,600 80,524 91.92% $805,100 $783,652 97.34% $795,000 $ 864,848 108.79% $34,200 $35,190 102.89% $35,900 35,955 100.15% 3,197,800 3,192,255 99.83% 3,191,400 3,185,130 99.80% 970,700 964,397 99.35% 964,400 989,790 102.63% 9,680,200 9,682,879 100.03% 9,686,000 9,680,007 99.94% 4,500 8,401 186.69% 0 0 100.00% 150,000 156,864 104.58% 156,900 167,386 106.68% 221,600 212,198 95.76% 215,300 47,848 22.22% 175,000 323,614 184.92% 175,000 498,647 284.94% 1,176,800 1,176,792 100.00% 1,244,500 1,244,490 100.00% $15,610,800 $15,752,590 100.91% $15,669,400 $15,849,252 101.15% $50,000.00 $96,163.00 192.33% $70,000.00 $120,243 171.78% 316,600 480,057 151.63% 451,300 $13,491 2.99% 100 55 55.00% 100 $5 5.00% $366,700 $576,275 157.15% $521,400 $133,738 25.65% TOTAL CHGS. FOR CUR. SERV. $4,548,200 $4,018,106 88.34% $4,068,200 4,058,868 99.77% INTERDEPARTMENTAL REVENUES Materials & Labor -Utilities BUDGETED REVENUES Twelve Month Actual % Received BUDGETED REVENUES Twelve Month Actual % Received CHARGES FOR CURRENT SERVICES 347,500 299,885 86.30% 280,000 326,401 116.57% Police Dept. Fees $175,400 $220,722 125.84% $162,500 196,633 121.00% Fire Dept. Fees 158,500 196,608 124.04% 171,800 161,317 93.90% Ambulance Fees 2,594,000 2,157,585 83.18% 2,160,000 2,146,888 99.39% Engineering Fees 10,000 318 3.18% 0 5,429 100.00% Street Services 17,500 11,194 63.97% 12,500 12,731 101.85% Central Garage 0 41,855 0.00% 35,000 45,868 131.05% Electrical Dept. 30,000 69,009 230.03% 30,000 30,514 101.71% Sign Dept. 3,000 5,251 175.03% 3,000 2,366 78.85% Parks Revenues 45,000 51,731 114.96% 69,000 58,702 85.08% City Clerk Fees 6,300 5,685 90.24% 5,800 5,945 102.50% Community Dev / Econ Dev 256,400 247,629 96.58% 255,500 272,051 106.48% Community Dev. -TIF 411,900 411,900 100.00% 400,200 400,276 100.02% Economic Dev. - County Aids 66,300 0 0.00% 0 0 0.00% Comm. Dev-Plan Review Fees -Econ Dev 25,000 0 0.00% 25,000 0 0.00% Cable Access Fees 3,500 3,800 108.57% 3,500 4,165 119.00% CAN Revenue 723,800 566,449 78.26% 705,500 684,852 97.07% Property Search 21,100 28,370 134.45% 28,400 31,130 109.61% Hazardous Materials 500 0 0.00% 500 0 0.00% TOTAL CHGS. FOR CUR. SERV. $4,548,200 $4,018,106 88.34% $4,068,200 4,058,868 99.77% INTERDEPARTMENTAL REVENUES Materials & Labor -Utilities $530,500 $276,820 52.18% $295,000 256,461 86.94% Sup./Admin. Labor -Utilities 347,500 299,885 86.30% 280,000 326,401 116.57% Central Garage 237,500 384,694 161.98% 419,000 372,612 88.93% Accounting Services -Utilities 421,800 492,731 116.82% 464,300 508,335 109.48% Equip/Labor Rental - Recycling 401,000 342,364 85.38% 340,100 285,133 83.84% Computer Services - Utilities 168,500 168,500 100.00% 168,500 168,500 100.00% Engineering Fees -Const. 1,810,000 1,807,490 99.86% 1,600,000 1,873,565 117.10% TOTAL INTER. DEP. REV. $3,916,800 $3,772,484 96.32% $3,566,900 3,791,007 106.28% JUNCLASSIFIED Miscellaneous Revenue $0 $0 #DIV/0! $0 3,761 #DIV/0! Sundry Revenue $130,000 $116,938 89.95% $100,000 138,496 138.50% Capital Gains on Investments 0 100.00% 0 1,022 100.00% Sale of Capital Assets 0 11,175 100.00% 0 19,478 100.00% Bond Proceeds 0 0 0.00% 0 0 0.00% TOTAL UNCLASSIFIED $130,000 $128,113 98.55% 100,000 162,758 162.76% TOTAL REVENUES $43,217,800 $42,917,193 99.30% $43,977,900 $44,146,659 100.38% General Fund Expenditures - Fourth Quarter 2017 January 1, 2017 - December 31, 2017 (Preliminary) GENERAL GOVERNMENT City Council City Manager City Attorney Human Resources City Clerk Elections Finance Purchasing Information Technology Insurance Facilities Maintenance Independent Audit Oshkosh Media TOTAL GENERAL GOVERNMENT PUBLIC SAFETY Police Animal Care Fire & Ambulance Hydrant Rental Auxiliary Police Crossing Guards Police & Fire Commission TOTAL PUBLIC SAFETY 2016 2016 2017 2017 ANNUAL Twelve Month % ANNUAL Twelve Month % BUDGET Actual Expended BUDGET Actual Expended $52,900 $53,340 100.83% $56,600 $54,832 96.88% 267,800 274,465 102.49% 276,300 280,040 101.35% 431,000 433,580 100.60% 422,300 394,246 93.36% 618,500 536,223 86.70% 554,300 554,981 100.12% 254,100 262,717 103.39% 255,200 251,710 98.63% 164,200 157,069 95.66% 74,100 69,404 93.66% 1,034,700 1,067,846 103.20% 1,154,500 1,123,993 97.36% 231,900 233,407 100.65% 232,500 242,842 104.45% 1,220,800 1,216,943 99.68% 1,310,400 1,354,851 103.39% 631,900 621,985 98.43% 554,800 516,503 93.10% 710,800 689,275 96.97% 704,400 692,812 98.35% 24,000 23,768 99.03% 24,300 17,994 74.05% 212,300 _ 215,162 101.35% 217,000 226,203 104.24% $5,854,900 $5,785,780 98.82% $5,836,700 $5,780,413 99.04% $12,700,200 $12,964,979 102.08% $12,870,900 $12,776,770 99.27% 88,200 87,033 98.68% 88,200 90,405 102.50% 1,229,530 11,834,100 11,934,051 100.84% 12,205,300 12,239,780 100.28% 2,536,127 650,000 650,000 100.00% 650,000 650,000 100.00% 1,790,049 4,800 4,010 83.54% 20,900 20,556 98.36% $5,909,089 80,600 75,701 93.92% 82,200 76,177 92.67% 13,600 21,031 154.64% 18,600 15,316 82.34% $1,747,400 $25,371,500 $25,736,805 101.44% $25,936,100 $25,869,004 99.74% Public Works - Admin. $374,500 $338,764 90.46% $373,200 $353,383 94.69% Engineering 1,189,900 1,151,578 96.78% 1,238,900 1,229,530 99.24% Streets -General 2,706,200 2,557,186 94.49% 2,650,400 2,536,127 95.69% Central Garage 1,946,600 1,711,174 87.91% 1,855,300 1,790,049 96.48% TOTAL PUBLIC WORKS $6,217,200 $5,758,702 92.63% $6,117,800 $5,909,089 96.59% PARKS & OTHER FACILITIES Parks $1,734,300 $1,672,291 96.42% $1,747,400 $1,717,343 98.28% Forestry 331,400 328,504 99.13% 335,500 340,449 101.48% TOTAL PARKS & OTHER FAC. $2,065,700 $2,000,795 96.86% $2,082,900 $2,057,792 98.79% COMMUNITY DEVELOPMENT Assessor $580,500 $574,998 99.05% $598,700 $604,147 100.91% Economic Development 660,900 585,388 88.57% 625,300 602,118 96.29% Planning Services 715,100 728,997 101.94% 735,700 713,996 97.05% TOTAL COMMUNITY DEV. $1,956,500 $1,889,383 96.57% $1,959,700 $1,920,262 97.99% 2016 2016 2017 2017 ANNUAL Twelve Month % ANNUAL Twelve Month % BUDGET Actual Expended BUDGET ActualExpended TRANSPORTATION Electric $509,200 $499,651 98.12% $536,700 $540,929 100.79% Sign 209,700 178,269 85.01% 222,700 182,809 82.09% TOTAL TRANSPORTATION $718,900 $677,920 94.30% $759,400 $723,738 95.30% UNCLASSIFIED 4,600,928 93.67% 3,501,800 3,306,144 94.41% 3,556,700 Unemployment Compensation $25,000 ($1) 0.00% $9,800 $5,165 52.70% Bank Fees 0 6,039 0.00% 6,500 11,592 178.35% Uncollectible Accounts 625,000 497,805 79.65% 554,400 610,619 110.14% Employee Benefit Fees 12,000 9,588 79.90% 10,000 10,969 109.69% Patriotic Celebrations 20,000 18,548 92.74% 20,000 18,733 93.66% Unclass. Expense 120,000 65,609 54.67% 106,200 73,322 69.04% Mobile Home Tax 48,000 45,815 95.45% 48,000 50,010 104.19% Adjustment of Salaries 183,100 0 0.00% 530,400 509,524 96.06% TOTAL UNCLASSIFIED $1,033,100 $643,403 62.28% $1,285,300 $1,289,934 100.36% 100 -GENERAL FUND TOTALS: $43,217,800 $42,492,788 98.32% $43,977,900 $43,550,231 99.03% Other Funds Operations January 1, 2017 - December 31, 2017 (Preliminary) LEVY FUNDS Recycling Garbage Collection & Disposal Street Lighting Senior Services Transit Utility Library Museum Grand Opera House Cemetery Equipment Leach Amphitheater Pollock Comm. Water Park LEVYFUNDS- SUBTOTAL: NON -LEVY FUNDS Golf Course Oshkosh Convention Center Oshkosh Center Parking Ramp Parks Revenue Facilities Inspections Srvcs - Rental Registry Inspections Srvcs - Weights & Meas. Inspections Srvcs - Inspections Parking Utility Water Utility Sewer Utility Stormwater Utility Safety/Worker Comp. /Agency Fund NON -LEVY FUNDS SUBTOTAL 2016 2016 2017 2017 ANNUAL Twelve Month % ANNUAL Twelve Month % BUDGET Actual Expended BUDGET Actual Expended $1,025,600 $789,275 76.96% $1,332,100 $1,147,681 86.16% 1,252,900 1,300,802 103.82% 1,330,600 1,333,175 100.19% 1,151,700 1,020,753 88.63% 1,052,000 1,068,802 101.60% 579,700 469,105 80.92% 515,100 499,269 96.93% 4,627,200 4,852,181 104.86% 4,912,000 4,600,928 93.67% 3,501,800 3,306,144 94.41% 3,556,700 3,404,961 95.73% 1,119,800 1,086,057 96.99% 1,135,200 1,110,848 97.85% 22,700 27,014 119.00% 20,400 24,303 119.13% 393,200 392,819 99.90% 409,700 404,224 98.66% 915,900 915,900 100.00% 1,000,000 1,000,000 100.00% 74,100 73,411 99.07% 75,100 69,078 91.98% 347,300 341,126 98.22% 353,100 354,330 100.35% $15,011,900 $14,574,587 97.09% $15,692,000 $15,017,598 95.70% $541,500 $588,712 108.72% $551,000 $530,363 96.25% 1,604,500 1,677,721 104.56% 1,694,500 1,525,456 90.02% 96,500 18,923 19.61% 89,500 93,301 104.25% 263,900 267,344 101.31% 405,100 223,687 55.22% 90,500 7,322 8.09% 241,100 32,691 13.56% 133,700 108,169 80.90% 116,600 117,187 100.50% 774,700 720,464 93.00% 746,300 746,503 100.03% 290,600 277,420 95.46% 304,100 125,379 41.23% 12,152,980 11,903,487 97.95% 12,157,000 11,691,536 96.17% 11,383,598 10,866,401 95.46% 11,362,800 10,390,133 91.44% 6,032,167 6,664,378 110.48% 6,328,700 6,079,095 96.06% 474,800 579,386 122.03% 468,400 523,872 111.84% $33,839,445 $33,679,727 99.53% $34,465,100 $32,079,204 93.08% TOTAL OTHER FUNDS: $48,851,345 $48,254,314 98.78% $50,157,100 $47,096,802 93.90% ANALYSIS OF GENERAL FUND EQUITY December, 2017 (Preliminary) Historical Balances 12/31/2008 $9,037,575 12/31/2009 $7,623,103 2009 Fund Balance Reservations ($52,270) Allowance -Due From Golf CourserNon-Current Receivable ($480,191) 12/312010 $8,871,437 2010 Fund Balance Reservations ($286,025) Inventory- Unspendable (New Requirement per GASB 54) ($15,128) Allowance -Due From Golf Course/Non-Current Receivable ($480,191) 1213112011 $9, 708,106 2011 Fund Balance Reservations ($687,688) Inventory - Unspendable (New Requirement per GASB 54) ($20,117) Allowance -Due From Golf Course/Non-Current Receivable ($480,191) 1213112012 $9,386,660 2012 Fund Balance Reservations ($502,664) Inventory - Unspendable (New Requirement per GASB 54) ($63,560) 12/312013 $8,847,799 2013 Fund Balance Reservations ($91,977) Inventory- Unspendable (New Requirement per GASB 54) ($13,477) Allowance -Due From Golf Course/Non-Current Receivable ($480,191) 12/31/2014 $9,277,395 2014 Fund Balance Reservations ($44,977) Inventory- Unspendable (New Requirement per GASB 54) ($33,723) Allowance -Due From Golf Course/Non-Current Receivable ($480,191) 12/31/2015 $9,037,575 2015 Fund Balance Reservations $0 Inventory - Unspendable (New Requirement per GASB 54) ($17,259) Allowance -Due From Golf Course/Non-Current Receivable ($480,191) 12/31/2016 $9,461,979 2016 Fund Balance Reservations ($1,835) Inventory - Unspendable (New Requirement per GASB 54) ($46,778) 12/312017 Allowance -Due From Golf CourseMon-Current Receivable ($985,659) 2017 Fund Balance Reservations TBD Inventory - Unspendable (New Requirement per GASB 54) TBD Allowance -Due From Golf Course/Non-Current Receivable TBD Current Year Budget January 1, 2017 Unassigned Fund Balance Total General Fund Budgeted Expenditures (over)/under for 2017 Total General Fund Budgeted Revenues over/(under) for 2017 Net Change in Fund Balance Estimated Fund Balance, 1-1-18 $6,965,275 $7,090,642 $8,090,093 $8,520,110 $8,820,436 $8,262,154 $8,718,504 $8,540,125 $8,427,707 $0 $8,427,707 $427,669 $168,759 $596,428 $9,024,135