BUDGET Airport Fund CDBG Housing Rehab Community Buildings Fund Electrical Fund Fire Protection Fund Gas Utility Fund General Fund Golf Fund Hospital Bond Sinking Fund Library Fund Park Fund Pheasant Ridge Trail Fund Police Protection Fund Pool Fund Recreation Fund RV Park Fund Sanitation Fund Shop Fund Street Fund Wastewater Utility Fund Water Utility Fund TOTAL
Oct '16 - Sep 17                                            
Ordinary Income/Expense
Income
01.4000 Taxes
01.4200 Motor Vehicle Taxes 20,000.00 38,000.00 58,000.00
01.4201 Motor Vehicle Pro-Rate Tax 500.00 150.00 650.00
01.4300 Local Option Sales Tax 1% 113,333.00 35,000.00 148,333.00
01.4301 PropertyTaxes 209,200.00 79,000.00 288,200.00
01.4302 Local Option Sales Tax 1/2% 56,667.00 66,000.00   122,667.00
Total 01.4000 Taxes 399,700.00 145,150.00 73,000.00 617,850.00
02.4000 Intergovernmental
02.4100 Municipal Equalization 67,619.00 67,619.00
02.4300 State Aid 850.00 850.00
02.4400 Highway Allocation/Incentive 137,063.00 137,063.00
02.4500 Motor Vehicle Fee 10,000.00 10,000.00
02.4700 5%-Lieu of Tax 19,000.00   7,000.00   26,000.00
Total 02.4000 Intergovernmental 86,619.00 850.00 7,000.00 147,063.00 241,532.00
03.4000 Fees, Licenses, & Other
03.4010 Building Permits & Fees 2,500.00 2,500.00
03.4020 Concessions Sales 2,200.00 2,200.00
03.4021 Beer Sales 60,000.00 60,000.00
03.4022 Drinks 80,000.00 80,000.00
03.4023 Soda 5,500.00 5,500.00
03.4024 Candy, Chips, Nuts, Etc. 2,000.00 2,000.00
03.4028 Gift Certificates Purchased 500.00 500.00
03.4030 Deposits -Gas,Wat, Sew; Compost 2,000.00 1,000.00 2,500.00 5,500.00
03.4035 Compost Key Fees 2,000.00 2,000.00
03.4040 Contributions Restricted 5,000.00 18,000.00 23,000.00
03.4045 Contributions Unrestricted 2,000.00 2,000.00
03.4050 Franchise Fees 1,800.00 1,800.00
03.4051 Pro Agreement-N.P.P.D. 170,000.00 170,000.00
03.4052 US Cellular Water Tower Lease 2,640.00 2,640.00
03.4060 Interest Income 60.00 4,000.00 50.00 4,110.00
03.4065 Dog Tags 1,200.00 1,200.00
03.4070 Library Fines 1,300.00 1,300.00
03.4080 Liquor License 1,800.00 1,800.00
03.4100 Miscellaneous Other Income 780.00 200.00 250.00 1,800.00 23,175.00 1,000.00 27,205.00
03.4120 Rent Income 13,904.00 3,000.00 1,300.00 3,500.00 90.00 21,794.00
03.4140 Swim Pool Tickets 12,000.00 12,000.00
03.4150 Tobacco Licenses 60.00 60.00
03.4700 Fuel Income 27,000.00                           27,000.00
Total 03.4000 Fees, Licenses, & Other 40,904.00 780.00 3,000.00 170,000.00 60.00 2,000.00 15,500.00 156,800.00 90.00 21,100.00 39,375.00 2,000.00 1,000.00 3,500.00 456,109.00
04.4000 Charges for Services
04.4050 Metered Sales 490,000.00 490,000.00
04.4075 Metered Sales/Past Consumption 256,000.00 256,000.00
04.4100 Wastewater Charges 73,000.00 73,000.00
04.4200 Trash Service Charges 165,500.00 165,500.00
04.4300 Golf Cart Storage 15,000.00 15,000.00
04.4310 Golf Cart Rental 8,000.00 8,000.00
04.4320 Golf Membership Dues 59,000.00 59,000.00
04.4330 Golf Green Fees 19,000.00 19,000.00
04.4400 Campground Fees 47,000.00 47,000.00
04.4900 Sales Tax Collected 18,700.00 140.00 18,840.00
Total 04.4000 Charges for Services 490,000.00 119,700.00 47,140.00 165,500.00 73,000.00 256,000.00 1,151,340.00
Total Income 40,904.00 780.00 3,000.00 170,000.00 60.00 492,000.00 501,819.00 276,500.00 90.00 21,950.00 191,525.00 47,140.00 167,500.00 220,063.00 74,000.00 259,500.00 2,466,831.00
Gross Profit 40,904.00 780.00 3,000.00 170,000.00 60.00 492,000.00 501,819.00 276,500.00 90.00 21,950.00 191,525.00 47,140.00 167,500.00 220,063.00 74,000.00 259,500.00 2,466,831.00
Expense
10.1000 Personal Services
10.1002 Salary Elected Officials 13,400.00 13,400.00
10.1005 Salary Wages 52,983.00 138,176.00 61,125.00 29,916.00 8,400.00 290,600.00
10.1010 Hourly Wages 42,000.00 15,191.00 14,750.00 57,000.00 44,012.00 31,012.00 21,278.00 82,318.00 307,561.00
10.1020 Overtime Wages 1,500.00 500.00 700.00 700.00 1,500.00 4,900.00
10.1060 Employee Bonus 400.00 120.00 20.00 40.00 100.00 100.00 440.00 1,220.00
10.1061 Building Permit Commissions 1,300.00 1,300.00
10.1070 Clothing/Auto/Cell Allowance 900.00 420.00 1,320.00
10.2000 Employee Pension 2,724.00 8,408.00 2,306.00 1,496.00 1,998.00 1,586.00 1,099.00 4,191.00 23,808.00
10.2010 Emp Health & Life Insurance 13,082.00 20,440.00 6,673.00 1,637.00 1,637.00 8,585.00 8,585.00 24,592.00 85,231.00
10.2020 Employee Dental Insurance 473.00 1,420.00 473.00 473.00 473.00 237.00 237.00 946.00 4,732.00
10.2030 Employee Eyecare Insurance 86.00 258.00 86.00 86.00 86.00 43.00 43.00 172.00 860.00
10.2050 Volunteers Life Insurance 4,000.00 2,426.00 6,426.00
10.3000 Payroll Taxes 4,168.00 11,596.00 7,520.00 3,451.00 1,128.00 4,590.00 643.00 3,405.00 1,681.00 6,412.00 44,594.00
10.4005 Nonemployee Compensation 5,976.00 1,224.00 1,884.00 9,084.00
10.4010 Fire & Ambulance Calls   1,100.00                       1,100.00
Total 10.1000 Personal Services 5,976.00 5,100.00 76,716.00 195,942.00 120,623.00 54,174.00 15,878.00 61,590.00 9,043.00 52,211.00 44,689.00 33,623.00 120,571.00 796,136.00
20.1000 Operating Expenses
20.1001 Advertising 100.00 250.00 350.00
20.1005 Animal Control 300.00 300.00
20.1010 Audit & Accounting Fees 17,000.00 17,000.00
20.1011 Bank Charges 60.00 240.00 60.00 120.00 60.00 60.00 600.00
20.1015 Cable Television Expense 1,000.00 1,000.00
20.1016 City Wide Clean Up 6,500.00 6,500.00
20.1020 Contractual Services 41,616.00 41,616.00
20.1025 Computer Services & Software 15.00 900.00 10,000.00 1,000.00 900.00 900.00 900.00 14,615.00
20.1029 Credit Card Transaction 2,000.00 2,000.00
20.1030 Deposit Refunds 1,000.00 1,000.00 1,000.00 3,000.00
20.1035 Dues & Fees 1,300.00 642.00 3,500.00 3,000.00 400.00 300.00 100.00 100.00 150.00 300.00 3,300.00 13,092.00
20.1036 Ec. Development * Newsletter 1,000.00 1,000.00
20.1037 Economic Development 11,500.00 11,500.00
20.1038 Ec. Development * A D C 20,000.00 20,000.00
20.1040 Electric Expense 2,000.00 4,500.00 2,500.00 400.00 1,800.00 17,000.00 2,600.00 540.00 2,500.00 3,100.00 1,000.00 7,500.00 450.00 1,000.00 37,000.00 6,300.00 25,000.00 115,190.00
20.1045 Employee Appreciation 1,000.00 1,000.00
20.1050 Engineering Fees 1,000.00 1,000.00
20.1060 Fuel & Oil 250.00 2,500.00 2,000.00 200.00 6,000.00 1,600.00 100.00 400.00 13,500.00 100.00 10,000.00 400.00 3,800.00 40,850.00
20.1070 Gas Purchased 300,000.00 300,000.00
20.1090 Gas, Water, & Wastewater 4,000.00 1,500.00 300.00 3,000.00 1,500.00 5,800.00 10,000.00 5,000.00 2,500.00 5,000.00 230.00 38,830.00
20.1100 Insurance Expense 6,680.00 3,300.00 6,000.00 3,000.00 7,000.00 7,000.00 3,000.00 2,500.00 5,000.00 2,000.00 1,000.00 3,000.00 1,000.00 6,600.00 1,200.00 10,000.00 68,280.00
20.1102 Internet Expense 1,000.00 1,000.00
20.1105 Land Lease 505.00 505.00
20.1110 Legal Fees 28,000.00 28,000.00
20.1120 Line Maintenance 3,000.00 10,000.00 6,000.00 19,000.00
20.1135 Liquor & Tobacco License 1,860.00 300.00 2,160.00
20.1140 Lodging Tax in Sales 125.00 125.00
20.1150 Miscellaneous Other Expense 200.00 1,500.00 3,000.00 500.00 300.00 100.00 500.00 250.00 50.00 730.00 100.00 500.00 7,730.00
20.1152 Nuisances 3,000.00 3,000.00
20.1158 Pool Certification 3,100.00 3,100.00
20.1160 Postage & Freight Expense 1,000.00 1,500.00 1,200.00 1,000.00 1,000.00 1,000.00 6,700.00
20.1170 Printing & Publishing 150.00 4,000.00 200.00 100.00 200.00 300.00 100.00 250.00 5,300.00
20.1180 Professional & School 750.00 2,500.00 150.00 200.00 400.00 150.00 4,150.00
20.1185 Publicity 500.00 500.00 1,000.00
20.1187 Recycling Fees 5,400.00 5,400.00
20.1190 Repairs & Maint. Buildings 250.00 4,500.00 2,000.00 3,500.00 3,500.00 1,000.00 500.00 1,000.00 200.00 500.00 200.00 500.00 500.00 18,150.00
20.1195 Repairs & Maint. Dumpsters & Mi 600.00 600.00
20.1200 Repairs & Maint. Equipment 400.00 500.00 13,000.00 2,000.00 4,000.00 6,000.00 1,190.00 1,200.00 1,000.00 1,000.00 1,000.00 5,000.00 500.00 8,000.00 4,000.00 5,000.00 53,790.00
20.1210 Repairs & Maint. Grounds 2,000.00 50.00 7,000.00 2,500.00 500.00 250.00 1,000.00 500.00 2,000.00 300.00 16,100.00
20.1220 Repairs & Maint. Wells 4,000.00 4,000.00
20.1225 Repairs & Maint. Streets 50,000.00 50,000.00
20.1226 Repairs & Maint. Sidewalks 5,000.00 5,000.00
20.1230 Sales Tax in Sales 36,750.00 1,100.00 2,000.00 5,400.00 15,750.00 61,000.00
20.1231 Sales Tax in Sales - Golf 18,700.00 18,700.00
20.1235 Subscriptions 200.00 200.00
20.1240 Telephone Expense 1,600.00 375.00 900.00 1,500.00 3,200.00 500.00 885.00 550.00 600.00 780.00 550.00 11,440.00
20.1250 Trash Removal 1,200.00 531.00 175.00 1,500.00 100.00 366.00 85.00 100.00 250.00 1,700.00 25,000.00 685.00 31,692.00
20.1260 Travel & Meal Expense 400.00 1,000.00 250.00 600.00 50.00 250.00 300.00 2,850.00
20.1270 Uniform Expense 400.00 1,100.00 400.00 400.00 700.00 3,000.00
20.1280 Water Testing                                   3,000.00 3,000.00
Total 20.1000 Operating Expenses 14,845.00 18,425.00 29,573.00 358,160.00 150,575.00 54,750.00 12,775.00 15,106.00 3,085.00 41,616.00 27,100.00 10,550.00 19,825.00 62,660.00 9,615.00 121,150.00 32,045.00 82,560.00 1,064,415.00
20.1085 Fuel Purchases 22,500.00 22,500.00
30.1000 Materials & Supplies
30.1010 Asphaltic 800.00 800.00
30.1020 Books - Restricted 7,000.00 7,000.00
30.1030 Chemicals 500.00 5,000.00 1,500.00 50.00 4,000.00 75.00 1,800.00 1,000.00 8,000.00 21,925.00
30.1040 Concession Supplies 5,500.00 2,500.00 8,000.00
30.1041 Purchases Beer 23,000.00 23,000.00
30.1044 Purchases Food 1,300.00 600.00 1,900.00
30.1045 Purchases Liquor 28,000.00 28,000.00
30.1047 Purchases Pop 5,000.00 5,000.00
30.1050 Concrete 1,500.00 1,500.00
30.1060 Gravel & Barrow 500.00 150.00 3,000.00 3,650.00
30.1070 Magazines 550.00 550.00
30.1090 Office Supplies 5,000.00 150.00 50.00 5,200.00
30.1100 Signs & Posts 300.00 50.00 50.00 500.00 900.00
30.1110 Small Tools 100.00 100.00 100.00 25.00 100.00 100.00 525.00
30.1120 Supplies 100.00 1,600.00 1,100.00 300.00 1,000.00 3,000.00 2,300.00 500.00 50.00 1,000.00 250.00 300.00 1,000.00 1,000.00 500.00 300.00 500.00 14,800.00
30.1121 Shop Supplies 100.00 100.00
30.1130 Videos 1,400.00 1,400.00
30.1135 Gift Certificates Redeemed           250.00                       250.00
Total 30.1000 Materials & Supplies 900.00 1,600.00 1,100.00 400.00 6,000.00 71,900.00 11,250.00 2,000.00 150.00 8,100.00 400.00 475.00 1,000.00 1,100.00 8,125.00 1,400.00 8,600.00 124,500.00
40.1000 Equipment Rental
40.1100 Equipment Rentals 150.00 2,800.00 2,950.00
Total 40.1000 Equipment Rental 150.00 2,800.00 2,950.00
50.1000 Capital Outlay
20.2200 Cap Outlay - Misc Improvements 5,200.00 5,200.00
50.1200 Cap Outlay - Buildings 15,000.00 27,654.00 42,654.00
50.1300 Cap Outlay - Equip & fixtures 4,500.00 18,000.00 2,900.00 4,000.00 2,175.00 3,000.00 18,000.00 4,500.00 71,700.00 7,500.00 12,500.00 148,775.00
50.1600 Cap Outlay - Grounds Projects 2,000.00 3,000.00 5,000.00
50.1800 Cap Outlay - Water Utility proj 10,400.00 10,400.00
50.1900 Cap Out-Wastewater Utility Proj                       50,000.00   50,000.00
Total 50.1000 Capital Outlay 4,500.00 18,000.00 17,900.00 4,000.00 7,375.00 2,000.00 30,654.00 3,000.00 18,000.00 4,500.00 71,700.00 57,500.00 22,900.00 262,029.00
60.1000 Debt Service
60.1500 Bond Principal Payments 9,720.00 80,000.00 45,000.00 41,000.00 175,720.00
60.2000 Bond Interest Payments 47,785.00 13,933.00 731.00 62,449.00
60.2500 Loan Principal Payments 14,060.00 20,193.00 2,688.00 22,500.00 77,500.00 136,941.00
60.3000 Loan Interest Payments 4,437.00 62.00 675.00 1,400.00 6,574.00
Total 60.1000 Debt Service 9,720.00 14,060.00 24,630.00 2,750.00 150,960.00 78,900.00 58,933.00 41,731.00 381,684.00
Total Expense 48,115.00   30,501.00 14,060.00 35,773.00 453,276.00 373,217.00 275,903.00   85,574.00 37,734.00 3,235.00 41,616.00 278,404.00 13,950.00 47,343.00 199,271.00 10,715.00 304,597.00 124,568.00 276,362.00 2,654,214.00
Net Ordinary Income (7,211.00) 780.00 (27,501.00) 155,940.00 (35,713.00) 38,724.00 128,602.00 597.00 90.00 (63,624.00) (37,734.00) (3,235.00) (41,616.00) (86,879.00) (13,950.00) (203.00) (31,771.00) (10,715.00) (84,534.00) (50,568.00) (16,862.00) (187,383.00)
Other Income/Expense
Other Income
70.1000 Other Financing Sources
70.1500 Transfers In 7,600.00 32,500.00 35,500.00 75,200.00 15,000.00 20,000.00 61,700.00 38,800.00 3,300.00 41,616.00 42,700.00 15,000.00 28,300.00 9,500.00 108,000.00 52,500.00 587,216.00
70.1501 Transfer into Pension - Fire 3,000.00 3,000.00
70.1505 Transfer In - Sales Tax 18,700.00 18,700.00
Total 70.1000 Other Financing Sources 7,600.00 32,500.00 38,500.00 93,900.00 15,000.00 20,000.00 61,700.00 38,800.00 3,300.00 41,616.00 42,700.00 15,000.00 28,300.00 9,500.00 108,000.00 52,500.00 608,916.00
Total Other Income 7,600.00 32,500.00 38,500.00 93,900.00 15,000.00 20,000.00 61,700.00 38,800.00 3,300.00 41,616.00 42,700.00 15,000.00 28,300.00 9,500.00 108,000.00 52,500.00 608,916.00
Other Expense
70.5000 Other Financing Uses
70.5500 Transfers Out 156,000.00 434,216.00 590,216.00
70.5505 Transfer Out - Sales Tax 18,700.00 18,700.00
Total 70.5000 Other Financing Uses 156,000.00 434,216.00 18,700.00 608,916.00
Total Other Expense 156,000.00 434,216.00 18,700.00 608,916.00
Net Other Income 7,600.00 32,500.00 (156,000.00) 38,500.00 (340,316.00) (3,700.00) 20,000.00 61,700.00 38,800.00 3,300.00 41,616.00 42,700.00 15,000.00 28,300.00 9,500.00 108,000.00 52,500.00 0.00
Net Income 389.00 780.00 4,999.00 (60.00) 2,787.00 38,724.00 (211,714.00) (3,103.00) 20,090.00 (1,924.00) 1,066.00 65.00 0.00 (44,179.00) 1,050.00 (203.00) (3,471.00) (1,215.00) 23,466.00 1,932.00 (16,862.00) (187,383.00)