FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
1,623,345 4,713,525
1,413,195 4,463,865
1,104,787 4,369,944
GENERAL FUND 01. 854,298
BEGINNING BALANCE MAY 1 TOTAL REVENUES
4,782,470
1,623,345 4,764,861
TOTAL FUNDS AVAILABLE
5,636,768
6,388,206
6,336,870
5,877,060
5,474,731
TOTAL EXPENSES
4,781,903
4,795,510
4,922,283
4,253,715
4,061,536
APRIL 30
854,865
1,592,696
1,414,587
1,623,345
1,413,195
FISCAL YEAR REVENUES LESS EXPENSES
567
ENDING BALANCE
(30,649) (208,758) 210,150 308,408 $738,398 $738,558 MOVED TO ESTABLISH S&A EQUIPMENT/CAPITAL PROJECTS FUND
REVENUES Taxes 3110 3150 3160
01.00.31. Property Tax Road & Bridge Tax Telecommunications Tax
Licenses 01.00.32. 3210 Liquor Licenses 3230 Contractor Registration 3250 Franchise Licenses 3260 Amusement/Raffle 3270 Mfg. Home Monthly Fee
Based on levy TO S&A EQUIP/CAPITAL FUND Village 6% phone service tax collected by state. Est=$25.4K/mo
10x$1125(A/bar),8x$1500(B/Pkg),2x$750(C/Rest),3x550(O/outside),4x1000(D/table)
$150 per x 175 contractors Cable (tax on cable bills) - semi-annual payments 8x$500 + 13 machines x$20 + 35 VGT x $20 + raffle $150 MapleValley $3015x12 + OakRidge $9850x12
Permit 01.00.33. 3310 Building Permits 3320 Building Permit Inspections Intergovernmental Revenues 01.00.34. 3410 State Income Tax Pop. 9204 x $95.40 (IML est. Jan'13) 3420 Replacement Tax no change over 2012 (IML estimate Jan'13) 3422 Replacement Tax-Township 3440 Sales Tax 1% (from state 6.25%) local retail (84.5K /mo) Tied to rebates 3450 Local Use Tax Population 9204 x $16.20 (IML estimate Jan'13) 3460 Video Gaming Revenue 3470 State Grant Pull Tab (law enforce grant) $1K 3480 Federal Grant 3490 Other Grants T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
1,380,000 305,000 1,685,000
1,372,996 138,129 308,000
1,373,000 138,150 318,000
1,348,752 132,096 316,700
1,305,077 126,162 329,030
1,819,125
1,829,150
1,797,548
1,760,269
30,400 27,000 120,000 5,500 154,470 337,370
25,350 24,150 114,380 5,000 151,900
25,325 24,000 114,350 5,000 151,900
25,713 26,400 108,593 3,160 148,298
24,400 33,300 103,178 3,245 146,280
320,780
320,575
312,164
310,403
28,000 27,000 55,000
26,000 25,000
27,000 29,000
22,467 21,900
27,167 25,520
51,000
56,000
44,367
52,687
878,000 18,600 900 1,014,000 149,000 36,000 1,000 -
882,702 18,604 900 987,000 144,000 6,500 15,000 -
808,750 19,050 900 987,500 140,500 6,500 15,000 -
633,205 18,765 1,273 808,086 134,242
711,251 20,801 1,134 736,965 114,524
19,875 -
1/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
Fines & Forfeits 01.00.35. 3511 Court & Traffic Fines 3512 Ticket Vehicle Surcharge 3513 Police Storage Fee 3514 DUI Forfeiture 3515 DUI Equipment Fines 3516 Vehicle Seized or Sold 3517 Drug Enforcement 3550 Ordinance Fines 3560 Building Fines 3590 Other Fines Service Charges 01.00.36. 3630 Garbage Charge
APPROVED APRIL 15, 2013
from Kankakee County court system $10 per ticket from County Vehicles stored by Village
Village ordinance, Non traffic
2460 units x $12.70 x 2&2460 x $14.70 x 10 +penalties(inc 07/01/13)
Service Fees 01.00.37. 3780 Police Reports Other Revenues 01.00.38. 3800 Interest Income 3820 Rental Income 3831 Development Donations 3833 Wright Estates Park Donat. 3839 Other Donations 3840 Recapture Fees 3861 Platting Fees 3862 Development Process Fees 3870 Retired Assets 3880 Reimbursements 3899 Misc. Income Other Financing Sources 01.00.39. 3940 Short Term Notes 3990 Interfund Operating Transfer
BUDGET FY 2013-14
@ 0.25% (on $1.2M balance) (subdivision $1800 per lot & ESDA $31.25/acre); DeeAnn done
$550 x 3 homes WAIVED
platting fees $900 per lot Variances, PC hearings Misc equipment, Cross Guards 12K, WC, Traf Lts, Animal Capture;event coord 16K
TIF1 Surplus $12,982; TIF2 Surplus $12,666, other
Refinance orig $2M Golf Course Loan Dec 2013
TOTAL REVENUES - GENERAL FUND T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
AMENDED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
2,097,500
2,054,706
1,978,200
1,615,446
1,584,675
52,000 5,000 1,000 15,000 10,000 5,000 88,000
47,500 5,000 1,000 10,000 2,800 10,000 6,000 -
47,500 5,000 1,000 15,000 2,800 10,000 6,000 -
51,703 4,961 264 36,575 9,104 3,700 -
65,238 4,872 983 8,500 12,385 2,025 -
82,300
87,300
106,307
94,003
430,000 430,000
380,000
380,000
380,896
361,329
380,000
380,000
380,896
361,329
500 500
CommCenter $2K, farm 12 acres
4/9/2013
PROJECTED
400
400
466
523
400
400
466
523
5,250 4,500 2,800 40,000 4,000
5,250 4,500 2,400 6,000 40,000 3,750
4,723 4,793 47,785 8,800 800 13,431 25,134 26,205
4,136 5,063 2,830 900 400 48,474 99,252
56,550
61,900
131,671
161,055
-
-
-
75,000
45,000
-
-
75,000
45,000
4,782,470
4,764,861
4,713,525
4,463,865
4,369,944
3,000 5,000 900 1,200 6,000 38,000 35,000 89,100
2/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
EXPENSES ADMINISTRATION 01.11. Personnel 01.11.40. 4210 Wages - Regular 4220 Wages - Temp/Part Time 4230 Wages - Overtime 4270 Wages - Administrator 4310 Wages - Elected 4510 Health Insurance 4515 HRA Reimbursements 4520 Life Insurance 4530 Unemployment Ins. 4610 Social Security Contrib. 4620 Medicare Contribution 4630 Retirement Contribution Contractual Services 01.11.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5200 Maint. Service - Computer 5290 Maint. Service - Other 5310 Accounting Service 5320 Engineering Service 5330 Legal Service 5340 Medical Service / Testing 5350 Design Service 5360 Janitorial Service 5370 Web Host Service 5380 Codification Service 5450 UB Outsourcing Service 5490 Other Professional Services 5510 Postage 5520 Telephone 5530 Publishing 5540 Printing / Maps 5610 Dues / Licenses 5620 Travel Expenses 5630 Training 5635 Conferences/Prof. Meetings
Hurley 100%; Schulteis 50%, Kiedaisch 50%, Hays 50% to Se Adm 172,600 Mayor:8K, Clerk:4K, Deputy:1.5K, Trustees:24 reg+24 com per@$50
20% increase in Oct Health Reimb for deductible costs: 2 Single$1,000 / 2 Fam $2,000
$7 May-Oct; $7.25 Nov-Apr 4% on first $13,500 (4 emp) 6.20% 1.45% IMRF estimate 14% (current 13.93%) (employees+Mayor)
Orkin $780; Alarm $400; VH roof repair MSI 9K; Duratech backup 3K, service calls
10% increase Retainer 1450/mo,
$110/mo web host 700, webfoot 200 Codifier host 500, codification 3K $325/mo +billing stock $4K (1/2) + postage 16K (25%) GIS contrib?; LiveVault 550; ach 400; A/P + utility billing delinquency +cell phone Mayor $780; Fax 220; Uverse 1K Treas.Report 1700; levy 800; PH Notices, Bids, Legals Letterhead; env; cks; ADD calendar 6K Chamber 250; Treasurer 195; Clerk 380; IML 800; shrm 160;
IML 5K, Mileage; Treasurer and Clerk annual seminars Trustees IML, Treasuer and Clerk annual seminars
Elected officials
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
144,000 100 28,500 38,500 5,000 350 2,160 10,701 2,503 21,280 253,094
144,000 93 27,000 34,700 3,000 340 1,500 10,639 2,427 20,700
144,000 60 27,000 34,700 9,050 340 1,500 10,639 2,427 20,700
210,142 357 26,283 38,690
210,142 140 24,017 40,550
339 1,135 14,279 3,340 29,248
295 1,240 14,105 3,299 28,798
244,399
250,416
323,813
322,586
3,200 500 12,500 500 6,800 9,000 60,000 1,500 1,000 4,000 10,000 2,000 4,000 6,500 3,000 2,500 2,000 8,000 5,000 300
2,800 500 11,000 400 6,150 8,000 43,000 1,500 1,000 5,500 7,500 7,000 5,000 5,500 2,700 2,500 2,000 500 -
3,500 500 14,500 700 6,200 12,000 71,000 1,500 1,500 5,500 9,000 10,000 5,000 6,000 3,000 4,000 2,000 500 -
5,351 1,041 11,355 274 6,000 3,888 87,060 1,089 -
2,465 1,170 6,305 593 6,940 5,498 93,871 2,710
6,224 5,427 4,387 1,189 6,765 1,606 180 295 40
15,129 4,997 7,611 4,146 3,131 1,980 99 3/37
FY 2013-2014 Budget With Detail 4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
600 600 367,500 6,550 22,700 6,500
900 1,000 367,500 6,600 22,700 6,500
2,523 367,284 6,505 20,057 6,270
3,294 367,284 6,307 31,473 1,410
517,000
561,600
544,810
566,413
1,500 1,100 5,300 500 400 600 500 1,000 200
1,500 1,100 5,300 1,000 600 600 600 5,000 300
1,017 6,160 608 415 91 279 2,393 1,040 477
650 4,923 938 356 274 14,508 -
11,100
16,000
12,480
21,649
53,600 53,600
53,600 -
53,600 -
53,600 -
53,600 -
53,600
53,600
53,600
53,600
-
-
-
2,500 2,500
13,000 1,000
16,000 3,500
1,264 529 5,499
37,590 1,154 23,801 2,901
14,000
19,500
7,292
65,446
3,000 11,000 -
1,500 23,500 -
1,500 23,500 -
1,257 12,375 -
282 12,375 -
auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
5640 5710 5715 5730 5785 5920 5930 5940
4/15/2013
Tuition Reimbursement Utilities Utilities - Food Pantry Garbage Disposal Transit Services General Insurance / Bonds Risk Management Contrib Rentals/Leases
Commodities 01.11.60. 6100 Maintenance Supplies 6450 Utility Billing Supplies 6510 Office Supplies 6520 Operating Supplies 6540 Janitorial Supplies 6550 Gasoline 6700 Books/Subscriptions 6840 Computer App / Software 6860 Seasonal Decorations 6890 Other Supplies / Materials Debt Service 01.11.70. 7100 Principal Payment 7200 Interest Payment 7300 Fiscal Agent Fees Capital Outlay 01.11.80. 8100 Land 8200 Building 8300 Equipment 8350 Equipment < $5,000 8700 Furniture 8900 Other Improvements 8950 Other Improvements < $5,000 Other Expenditures 01.11.90. 9110 Public Relations/Hospitality 9111 Donations - Organizations 9120 State/Federal Permit Fees
APPROVED APRIL 15, 2013
Nicor beyond maximum therms allowed, Comcast in BdRm $35/mo
ComEd, Nicor 2460 homes x $14.70 x 12 Metro Bus Notary; RR liability 5K 15% increase Pitney Bowes 1.5K; NO Safety box 50; RR 25, COPIER 350/mo
Building, Equipment, Grounds Envelopes, colored paper toner, ink cartridges, paper, time cards, W2 forms/env, badges, clerk forms towels, cleaners, soap, trash bags Mayor pub rec bulletin 250; int'l council/shopping 100;manteno news 25 anti-virus 1000; Updates, modules, enhancements
Interior Keys
Golf Course REFIN DEC 2013 $2M 2-yr loan Municipal. Interest 2.68%
Replace last office computer, check endorser
Dinners:Chamber 400, Mayors 700, Ofest 750, EduGolf 400;memorials;recognition
Not for profit
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 1,200 1,500 424,500 7,300 26,100 6,800 609,700 1,500 1,000 5,500 600 500 1,200 600 5,000 500 200 16,600
4/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
9160 9190 9200 9220 9230 9240 9290
4/15/2013
Property Tax Administrator Expenses Sales/Prop Tax Rebate Insurance Claims Expense Retiree Insurance Expense Grant Expense Miscellaneous Expense
APPROVED APRIL 15, 2013 Village owned properties Kolesar 1K,Breitbarth 200 World Fuels 63K,Manteno Ford 52K,TireTracks 4K,Curwick 3K,other in/out line item for costs & payment related to insurance claims in/out line item for costs & reimbursement related to retirees insurance
in/out line item for cost & grants NOT payroll-related grants SHREDDING
Other Financing Uses 01.11.95. 9530 Intergovernmental Agreement 9990 Interfund Operating Transfer
TOTAL EXPENSES - Administration
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
3,400 124,000 10,000 900 152,300
3,150 110,000 20,000 1,000
3,150 110,000 15,000 1,000
3,599 69,083 306 401 265
1,375 995 18 4,937 174
159,150
154,150
87,286
20,156
-
-
-
-
-
1,087,794
999,249
1,055,266
1,029,281
1,049,850
5/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
96,200 7,900 1,700 22,500 2,000 200 1,150 6,597 1,543 13,300
96,200 7,900 1,700 22,500 2,000 200 1,500 6,597 1,543 13,300
99,802 6,450 750 30,529
100,568 7,980 350 32,184
162 710 5,974 1,398 13,271
148 957 6,116 1,430 13,174
153,090
153,440
159,046
162,907
BUILDING & ZONING 01.15. Personnel 01.15.40. 4210 Wages - Regular 4220 Wages-Temp/Part Time 4230 Wages - Overtime 4320 Wages - Commissions 4510 Health Insurance 4515 HRA Reimbursements 4520 Life Insurance 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution Contractual Services 01.15.50. 5120 Maint. Service - Equipment 5130 Maint. Service - Vehicle 5200 Maint. Service - Computer 5290 Maint. Service - Other 5320 Engineering Service 5330 Legal Service 5340 Medical Service / Testing 5350 Design Service 5490 Other Professional Services 5510 Postage 5520 Telephone 5530 Publishing 5540 Printing / Maps 5610 Dues / Licenses 5620 Travel Expenses 5630 Training 5635 Conferences / Prof Meetings 5640 Tuition Reimbursement 5930 Risk Management Contrib 5940 Rentals/Leases Commodities 01.15.60. 6100 Maintenance Supplies 6130 Maint. Supplies - Vehicle
LaRocque, Spiek 333 inspections @$30 (4 PT emp.) $25 per member per mtg. Allow 8 mtgs. 20% increase in Oct Health Reimb for deductible costs: 1 Single$1,000 / 1 Fam $2,000
$7 May-Oct; $7.25 Nov-Apr 2 emp 4% on first $13,500 (2 emp)+PT 6.20% 1.45% IMRF estimate 14% (current 13.9%)
Duratech service Tyson general, review Legal review; code violation lawsuits;
Court reporter, const. bids, recording fees +1 cell phone 780; Fax 220; DSL 130 Public hearings forms, maps, SSBOA, IPOC, ICC Midwest Blders Conf.,IML,ICC,CRCA,RMDL SSBOA, ICC, B&F, meet requirements for certification educat. IML, SSBOA, IPOC, Building Directors Increase 15%
in-house servicing
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
97,000 10,000 500 1,400 24,000 3,000 200 1,480 6,752 1,579 13,650 159,561 200 200 900 13,000 10,000 200 3,000 500 3,700 1,000 900 300 600 1,000 500 350 36,350
100 900 9,000 9,000 200 3,500 500 3,500 2,000 600 300 1,000 200 300 -
200 200 900 16,200 16,400 200 3,500 500 3,500 2,500 600 300 1,100 300 300 -
2,653 354 11,775 5,701 1,042 500 3,341 650 1,007 345 158 120 191 253 -
367 117 6,848 1,332 3,088 498 5,199 354 618 345 136 94 -
31,100
46,700
28,090
18,996
100 300
100
100 200
-
6/37
FY 2013-2014 Budget With Detail 4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
900 300 1,500 600 600 100
900 300 1,500 600 600 500 100
20 362 97 1,218
118 233 163 1,499
263 277
114 -
4,100
4,800
2,237
2,127
-
-
-
1,179 4,360 -
-
-
-
5,539
-
200 300 500
300 900
300 900
360
12 130
1,200
1,200
360
142
201,311
189,490
206,140
195,272
184,172
auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
6200 6510 6520 6550 6590 6700 6840 6890
4/15/2013
Maint. Supplies - Computer Office Supplies Operating Supplies Gasoline Uniform Supplies Books/Subscriptions Computer App/Software Other Supplies / Materials
APPROVED APRIL 15, 2013 update computers
anti-virus, updates Keys
Capital Outlay 01.15.80. 8300 Equipment 8350 Equipment < $5,000 8400 Vehicle 8700 Furniture 8900 Other Improvements 8950 Other Improvements < $5,000 Other Expenditures 01.15.90. 9110 Public Relations/Hospitality 9290 Miscellaneous Expense 9400 Refund Permit Fees
contractors mtg, ISO rating Refund from revenue acct
TOTAL EXPENSES - Building & Zoning
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 300 600 300 1,700 400 500 500 200 4,900
7/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
PUBLIC SAFETY 01.21. Personnel 01.21.40. 4210 Wages - Regular 4220 Wages-Temp, Part Time 4230 Wages - Overtime 4240 Wages - Premium OIC/FTO 4250 Wages - Holiday Pay 4320 Wages - Commissions 4510 Health Insurance 4515 HRA Reimbursements 4520 Life Insurance 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution 4635 Police Pension Contribution 4710 Uniform Allowance Contractual Services 01.21.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5130 Maint. Service - Vehicle 5200 Maint. Service - Computer 5290 Maint. Service - Other 5330 Legal Service 5340 Medical Service / Testing 5360 Janitorial Service 5490 Other Professional Services 5510 Postage 5520 Telephone 5530 Publishing 5540 Printing / Maps 5560 Dispatching 5610 Dues / Licenses 5620 Travel Expenses 5630 Training 5635 Conferences/Prof Meetings 5640 Tuition Reimbursement 5930 Risk Management Contrib
Chief, Lt, 4 Sgts, 11 Officers, Office Mgr ESDA Director; AnimalControl,Cross Guards3%; Adjudication 3K
Increase for school coverage Holiday pay 45K, holiday worked 10K 1,423,000 20% increase in Oct Health Reimb for deductible costs: 5 Single$1,000 / 13 Fam $2,000
$7 May-Oct; $7.25 Nov-Apr 18 emp 4% on first $13,500 (18 emp)+PT 6.20% 1.45% IMRF estimate 14% (current 13.9%) Carla Amt to levy per IL Dept of Insurance actuarial requirement $326,500
17x$900
Orkin $900; alarm , roof repair Radios Major repairs, minor in-house S&A Duratech backup 2K, Collections reporting, contract negotiations (delayed billing)
$65 wk Inmates / testing services / special tows +8 cell phone reimb $6240, DSL 840, Wireless 6K, Fax 720 Tickets, Report Sheets Increased calls for services Actual $23,140 +$30,412 Training / Investigation related ERT / Specialized training Specialized conferences for officers / Chief's conference Contractual limit 3K add 15%
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
1,232,000 44,000 95,000 52,000 204,000 21,000 1,550 11,480 88,226 20,634 4,900 320,000 15,300 2,110,090
1,194,500 40,500 70,000 49,500 202,000 7,000 1,550 7,300 85,746 20,054 4,725 260,000 15,300
1,194,500 40,500 83,000 50,000 202,000 7,000 1,550 14,500 85,746 20,054 4,725 260,000 15,300
1,139,568 35,619 63,021 118 47,988 214,477
1,110,312 34,041 69,725 10,926 46,896 227,550
1,499 5,875 77,297 18,078 4,027 220,000 14,850
1,328 6,412 76,482 17,887 3,967 194,277 15,300
1,958,175
1,978,875
1,842,417
1,815,103
8,000 2,800 10,000 3,500 10,000 700 3,400 3,500 100 16,000 2,200 53,600 1,500 3,000 10,000 1,500 46,350
2,000 1,000 24,000 4,500 3,000 750 3,000 6,500 100 14,800 300 2,000 46,600 1,500 2,000 5,000 500 750 41,150
3,500 3,000 24,750 4,500 11,000 750 3,000 6,500 100 15,000 300 2,500 46,600 1,500 2,000 5,000 500 1,500 41,150
2,955 4,341 21,456 3,242 702 4,868 198 2,700 2,227 208 14,695 1,108 47,416 1,565 2,437 6,570 275 1,080 39,164
2,496 11,801 1,411 2,122 479 3,513 16,712 642 2,080 45,288 2,191 1,585 1,635 478 69,172 8/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
5940 Rentals/Leases Commodities 01.21.60. 6110 Maint. Supplies - Building 6120 Maint. Supplies - Equipment 6130 Maint. Supplies - Vehicle 6200 Maint. Supplies - Computer 6290 Maint. Supplies - Other 6510 Office Supplies 6520 Operating Supplies 6540 Janitorial Supplies 6550 Gasoline 6555 Gasoline - Animal Control 6590 Uniform Supplies 6700 Books/Subscriptions 6840 Computer App / Software 6890 Other Supplies / Materials Capital Outlay 01.21.80. 8200 Building 8300 Equipment 8350 Equipment < $5,000 8400 Vehicle 8700 Furniture 8900 Other Improvements 8950 Other Improvements < $5,000 Other Expenditures 01.21.90. 9110 Public Relations/Hospitality 9115 Outreach Programs 9290 Miscellaneous Expense 9300 DUI Expense 9310 Drug Enforcement Expense 9320 Crime Prevention Expense 9380 ESDA Expense
APPROVED APRIL 15, 2013 Copier $300 mo
In-house S&A, oil changes, Special brake parts / fluids
Ammo, Evidence kits, Weapon supplies, Taser cartridges towels, cleaners, soap, trash bags Increase in cost 15% Vests, new officer, damaged items Annual anti-virus Keys
vehicle & other equipment, radio replacement program vehicle replacement
Professional mtgs Senior & Junior programs - offset by Comm.Fund donations Kitchen supplies, coffee Operations / buy money Siren maintenance 2K / EOC / shelter expenses
TOTAL EXPENSES - Public Safety T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 3,500 179,650
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
3,000
3,500
-
-
162,450
176,650
157,207
161,605
1,000 1,000 7,000 150 100 2,000 4,800 600 66,000 1,700 6,000 100 700 500 91,650
2,000 2,000 1,500 1,800 4,000 500 57,000 1,400 4,500 700
2,000 2,000 1,500 300 2,000 4,000 700 57,250 2,500 5,500 100 700 700
465 343 1,064 158 5 2,223 5,183 268 62,792
56 1,240 88 11 1,334 1,747 46,932
4,528 30 200
6,790 244 57
75,400
79,250
77,259
58,499
5,000 35,000 40,000
2,000 32,000 70,000 -
2,000 32,000 70,000 -
17,129 123,084 -
5,500 5,493 1,000 -
104,000
104,000
140,213
11,993
300 300 2,500 3,100
200 2,200
300 400 500 4,000
61 612 2,163
85 613 2,900
2,400
5,200
2,836
3,598
2,424,490
2,302,425
2,343,975
2,219,932
2,050,798 9/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
STREETS & ALLEYS 01.41. Personnel 01.41.40. 4210 Wages - Regular 4220 Wages-Temp, Part Time 4230 Wages - Overtime 4260 Wages - Shift Differential 4510 Health Insurance 4515 HRA Reimbursements 4520 Life Insurance 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution 4710 Uniform Allowance Contractual Services 01.41.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5130 Maint. Service - Vehicle 5140 Maint. Service - Street 5145 Maint. Service-Street Lights 5148 Maint. Service-Traffic Lights 5170 Maint. Service - Grounds 5200 Maint. Service - Computer 5290 Maint. Service - Other 5320 Engineering Service 5330 Legal Service 5340 Medical Service / Testing 5490 Other Professional Services 5510 Postage 5520 Telephone 5530 Publishing 5540 Printing / Maps 5610 Dues / Licenses 5620 Travel Expenses 5630 Training 5635 Conferences/Prof Meetings 5640 Tuition Reimbursement 5710 Utilities
O'Keefe 50%, Hanley, Stromme, Rodgers, Regas, Prince, Bart, NO NEW
Add $10,000 for park maintenance increase 425,500
20% increase in Oct Health Reimb for deductible costs: 6 Single$1,000 / 2 Fam $2,000
$7 May-Oct; $7.25 Nov-Apr 7 emp 4% on first $13,500 (7 emp)+PT 6.20% 1.45% IMRF estimate 14% (current 13.9%) 7 x $250
Overhead door 4K, salt shed roof 5K, alarm system 2013 Tires 4500, Misc repairs 2500 Tires, inspections Misc MFT testing 3K, Striping 3K, concrete (sidewalk) lifting Repair damage JULIE locates 1K, traffic light maint 2500, new light Ash tree removal (5@$1K=5K), 10000 Overpass 5K misc repairs, service calls misc Contract negotiations (delayed billing) Random drug, post accident Naptha Disp. Pit service, fire extinquishers, alarm service 250 UPS Cell phone reimb (2@$65/mo)$1560, DSL, Phone PW S&A worker ad Time sheets, maps, misc CDL, Mosquito, R-O-W, EAB Spraying None anticipated (IML) Operators Training Facility (3@480) None anticipated (IML, snow removal conference) No submissions
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
330,000 71,000 24,000 500 76,000 7,000 700 6,620 26,381 6,170 59,570 1,750 609,691
327,000 56,500 20,000 500 59,000 4,000 600 3,450 24,921 5,835 50,370 1,750
327,000 58,000 20,000 500 59,000 4,000 600 3,850 24,921 5,835 50,370 1,750
298,362 31,461 11,793 264 70,769
294,234 29,823 17,015 15 68,813
598 2,738 20,877 4,883 43,367 1,750
511 3,287 20,857 4,878 42,776 2,000
553,926
555,826
486,862
484,209
11,000 7,000 2,500 9,500 2,000 10,000 10,000 500 500 500 9,000 500 1,500 100 3,500 150 150 500 1,440 750 -
500 20,000 1,300 7,500 1,500 10,000 1,200 800 300 1,400 100 800 1,500 100 3,300 200 400 300 750 -
500 21,900 2,000 8,500 3,000 10,000 1,500 1,000 500 1,400 100 800 1,500 100 3,400 200 400 300 750 -
1,285 6,645 1,309 3,158 8,876 195 941 238 623 2,438 3,064 185 315 30 15 750 -
590 4,746 2,279 10,630 474 6,485 775 223 128 555 377 2,633 12 3,836 240 53 301 15 750 10/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
5720 Street Lighting 5930 Risk Management Contrib 5940 Rentals/Leases Commodities 01.41.60. 6110 Maint. Supplies - Building 6120 Maint. Supplies - Equipment 6130 Maint. Supplies - Vehicle 6140 Maint. Supplies - Street 6143 Maint.Supplies-Street Signs 6145 Maint.Supplies-Street Lights 6160 Maint.Supplies-Snow Rem. 6170 Maint. Supplies - Grounds 6180 Maint. Supplies - Parkway 6200 Maint. Supplies - Computer 6290 Maint. Supplies - Other 6510 Office Supplies 6520 Operating Supplies 6530 Small Tools 6540 Janitorial Supplies 6550 Gasoline 6560 Diesel Fuel 6570 Lubricants 6580 Chemicals 6590 Uniform Supplies 6600 Safety Supplies 6840 Computer App / Software 6860 Seasonal Decorations 6870 Street Light Banners/Flags 6890 Other Supplies / Materials Capital Outlay 01.41.80. 8200 Building 8300 Equipment 8350 Equipment < $5,000 8400 Vehicle 8600 Streets/Roads 8603 Street Signs 8605 Street Light Poles
APPROVED APRIL 15, 2013 Com Ed avg 4720/mo. Anticipate $57K Estimate 15% increase Sod cutter, Light tower
Shop exhaust fan, gas heat supplement Maint. (extend longevity) Maint. (extend longevity) Deliniators, curbs, x-walk paint, stamped sealer Increase in sign postings Maintenance Sidewalk salt Flowers, landscape, planters, lights, mulch Bollards, sod, mail boxes, tree replace (30@$250=$7.5K) None anticipated Misc nuts, bolts, plowskirts, steel Time clock, ink toner, paper, etc Paint, o/ac, fittings, soap, wax, bead blast, grind wheels, brushes
Hand tools, sprayers, heated pressure washer Can liners, paper towels, toiletries, cleaners S&A gasoline 17% S&A diesel Oil, grease, spl oils (add'l police vehicle maintenance) fertilizer, larvacide, pre-emergents, round-up Reimbursed safety boots, glasses; shirts Safety glasses, first aid restock, gloves, misc safety Misc computer Bells & bows (175@$13), Tree lights (72@$30) Replacement schedule: $9K banners, $3K flags Keys, Fuel keys, kitchen supplies, mouse traps, misc
40 x 80 bldg expansion @$50/sq.ft=$160K UNDER S&A EQUIP/CAPITAL FUND $155,000 UNDER S&A EQUIP/CAPITAL FUND $5,000 UNDER S&A EQUIP/CAPITAL FUND $500,000 None anticipated (19 additional on TIF - Division st)
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 60,000 44,300 1,000 176,390
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
56,300 43,950 1,000
57,000 43,950 1,000
56,595 36,361 525
64,664 30,496 6
153,200
159,800
123,548
130,268
5,000 15,000 5,000 7,800 2,500 6,800 1,000 6,000 10,000 500 1,000 4,800 2,800 1,000 13,000 25,000 3,800 3,000 1,800 2,500 5,000 12,000 250 135,550
3,000 20,000 4,000 6,000 3,200 6,500 1,000 5,000 500 2,000 3,500 2,800 1,000 11,000 20,000 3,400 3,000 1,600 1,500 3,900 2,000 3,000 200
3,000 22,000 5,000 8,000 3,400 7,000 1,000 8,000 750 2,000 4,600 2,800 1,000 13,000 22,000 3,400 1,500 1,600 1,500 4,900 2,000 4,000 250
2,808 15,008 4,214 6,642 1,093 7,506 772 2,205 250 109 1,999 3,531 2,261 645 10,228 20,119 2,975 3,551 2,019 562 3,902
1,095 10,841 2,061 4,922 940 3,288 834 1,675 156 221 870 5,382 1,900 870 6,873 15,790 2,167 1,916 566 972 1,908
124
31
108,100
122,700
92,523
65,278
-
4,500 389,100 10,400
5,000 389,100 10,400
42,127 11,911 -
2,634 6,222 11/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
8607 8700 8800 8900 8950
4/15/2013
Traffic Signs Furniture Parkway Improvements Other Improvements
APPROVED APRIL 15, 2013 None anticipated None anticipated None anticipated
Other Improvements < $5,000
Other Expenditures 01.41.90. 9110 Public Relations/Hospitality 9290 Miscellaneous Expense
EAB information dissemination
TOTAL EXPENSES - Streets & Alleys
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 -
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
13,500 -
13,500 -
2,836
-
417,500
418,000
56,874
8,856
1,500 150 1,650
150
150
151
-
150
150
151
-
923,281
1,232,876
1,256,476
759,958
688,611
12/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
450
-
40 -
-
45 28 7 -
-
3 2 1 -
COMMUNITY CENTER 01.51. Personnel 01.51.40. 4210 Wages - Regular 4220 Wages - Temp, Part Time 4230 Wages - Overtime 4510 Health Insurance 4515 HRA Reimbursements 4520 Life Insurance 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution Contractual Services 01.51.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5290 Maint. Service - Other 5360 Janitorial Service 5410 Program/Event Services 5490 Other Professional Services 5510 Postage 5520 Telephone 5530 Publishing 5540 Printing / Maps 5620 Travel Expenses-Event Coor 5630 Training-Event Coord 5710 Utilities 5930 Risk Management Contrib. 5940 Rentals/Leases Commodities 01.51.60. 6110 Maint. Supplies - Building 6120 Maint. Supplies - Equipment 6170 Maint. Supplies - Grounds 6290 Maint. Supplies - Other 6510 Office Supplies 6540 Janitorial Supplies 6550 Gasoline-Event Planner 6610 Program/Event Supplies
Event Coordinator $32.5K (ChamberComm reimb $15K) 32,500 Child coverage for event coordinator Health Reimb for deductible costs: Fam $2,000
5% on first $14,000 6.20% 1.45% IMRF estimate 14% (current 13.37%)
Orkin=$700, roof reseal to stop small leaks Air conditioner & heater repairs Fire extinq.tests PW floor maint, Cleaning $50/wk x52 &seniors 1500
+cell phone $780
Comcast Bd Rm
T8 fixture changes, light bulbs, ceiling tiles, roof repair Remove & replace landscaping
towels, cleaning,
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
32,500 11,000 2,000 100 540 471 471 4,550 51,633
-
-
530
-
46
2,000 1,000 300 2,500 5,000 2,400 600 700 600 100 15,200
2,000 100 2,000 80 -
2,000 1,000 300 2,400 100 -
2,608 1,758 -
806 1,600 -
-
-
-
-
4,180
5,800
4,366
2,406
2,000 1,000 1,000 300 1,500 2,500
1,000 5 1,000 300
2,000 1,000 300
184 21 225
822 228
-
-
-
-
-
13/37
FY 2013-2014 Budget With Detail 4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
-
-
-
16 -
2,305
3,300
430
1,066
1,000 3,500 4,500
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
80,833
6,485
9,630
4,796
3,518
auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
6860 Seasonal Decorations 6890 Other Supplies / Materials Capital Outlay 01.51.80. 8200 Building 8300 Equipment 8350 Equipment < $5,000 8700 Furniture 8900 Other Improvements 8950 Other Improvements < $5,000
APPROVED APRIL 15, 2013 Pre-lit tree Keys
Toilet replacement
Other Expenditures 01.51.90. 9110 Public Relations/Hospitality 9290 Miscellaneous Expense
TOTAL EXPENSES - Community Center
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 1,000 200 9,500
14/37
FY 2013-2014 Budget With Detail auto updates to other sheets
BUDGET FY 2013-14
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
600 30 250 50 500
3,500 600 37 9 -
400 25 6 -
475 29 7 -
23,885
4,146
431
511
500 1,500 2,000 500 200 2,600 7,000 3,400 2,500
500 4,000 2,750 500 250 2,700 8,000 3,450 2,500
1,256 2,821 1,774 461 200 2,470 5,195 3,466 2,412
284 2,523 347 200 3,263 6,086 853 426
20,200
24,650
20,055
13,982
PARKS 01.52. Personnel 01.52.40. 4210 Wages - Regular 4220 Wages - Temp, Part Time 4230 Wages - Overtime 4320 Salaries - Commissions 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution Contractual Services 01.52.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5170 Maint. Service - Grounds 5290 Maint. Service - Other 5410 Program/Event Services 5490 Other Professional Services 5610 Dues / Licenses 5710 Utilities 5730 Garbage Disposal 5780 Public Comfort Stations 5930 Risk Management Contrib 5940 Rentals/Leases Commodities 01.52.60. 6110 Maint. Supplies - Building 6120 Maint. Supplies - Equipment 6170 Maint. Supplies - Grounds 6290 Maint. Supplies - Other 6580 Chemicals 6610 Program/Event Supplies 6860 Seasonal Decorations 6890 Other Supplies / Materials Capital Outlay 01.52.80. 8100 Land 8200 Building 8300 Equipment
3000 600 4% on first $13,500 6.20% 1.45% IMRF estimate 14% (current 13.9%)
Pest Control Wright Park & Thies Park have old equipment Stump grinding, soil sampling None anticipated Santa, egg hunt, ice rink Signs Health dept. Concession license$250 Com Ed $3K; (no charge from Aqua??) None anticipated Port-a-potties increase 15% Boom mower, Aerator
Tables, Heritage planters, play equip repairs, nets, paint, etc Creek trees at Ruder, playground sand, mulch, flowers, seed Ice rink materials Fertilizer, 2-4-d, sterilizer, pre-emergents… Easter, Santa, elf costume, cookies, event signage Heritage park janitorials
None anticipated None anticipated None anticipated
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
600 37 9 646 500 2,000 4,000 500 250 2,700 8,000 3,600 2,800 24,350 900 5,000 11,500 2,000 3,000 1,000 800 24,200
800 900 8,000 5,100 3,000 2,500 600
1,000 1,000 8,000 5,100 3,000 2,900 1,000
831 1,380 11,255 2,441 729 313
487 144 5,279 2,451 718 70
20,900
22,000
16,949
9,149
-
-
-
-
60,945 15/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
8350 Equipment < $5,000 8900 Other Improvements 8950 Other Improvements < $5,000
APPROVED APRIL 15, 2013 Heritage & Ruder trash cans, Ruder picnic tables Ice Rink
Other Expenditures 01.52.90. 9110 Public Relations/Hospitality 9290 Miscellaneous Expense
TOTAL EXPENSES - Parks
TOTAL EXPENSES - GENERAL FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
5,000 10,000 15,000
-
-
3,308 3,733
-
-
-
7,041
60,945
-
-
-
-
-
64,196
64,985
50,796
44,476
84,587
4,781,903
4,795,510
4,922,283
4,253,715
4,061,536
16/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
COMMUNITY FUND 03. TOTAL FUNDS AVAILABLE
35,325 6,050 41,375
31,845 10,980 42,825
31,845 10,980 42,825
28,048 7,281 35,329
28,348 12,628 40,976
TOTAL EXPENSES
6,000
7,500
7,500
3,484
12,928
APRIL 30
35,375
35,325
35,325
31,845
28,048
FISCAL YEAR REVENUES LESS EXPENSES
50
3,480
3,480
3,797
(300)
50 5,000 500 500 6,050
180 5,800 5,000 -
180 5,800 5,000 -
360 6,218 703
241 3,390 8,597 400
10,980
10,980
7,281
12,628
6,050
10,980
10,980
7,281
12,628
5,000 1,000 6,000
7,500 -
7,000 500 -
3,484 -
4,993 925 6,686 324
7,500
7,500
3,484
12,928
6,000
7,500
7,500
3,484
12,928
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
REVENUES Other Revenues 03.00.38. 3800 Interest Income 3835 Police Donations 3836 Park Donations 3837 Sewer Donations 3839 Other Donations
Comm/Escrow/Impact @ 0.25% Senior & junior programs
TOTAL REVENUES - COMMUNITY FUND EXPENSES Other Expenditures 03.11.90. 9111 Organization Donation Exp 9112 Police Donation Expense 9113 Parks Donation Expense 9114 PW Donation Expense 9115 Other Donation Expense 9240 Grant Expense 9290 Miscellaneous Expense
Senior/Junior programs
in/out line item for costs & grants associated to cover NOT PAYROLL
TOTAL EXPENSES - COMMUNITY FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
17/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
ESCROW FUND 05. TOTAL FUNDS AVAILABLE
523,357 40,000 563,357
42,757 708,600 751,357
42,757 708,600 751,357
44,827 1,750 46,577
47,622 3,820 51,442
TOTAL EXPENSES
543,500
228,000
228,500
3,820
6,615
19,857
523,357
522,857
42,757
44,827
(503,500)
480,600
480,100
(2,070)
(2,795)
15,000 25,000 40,000
683,600 25,000
683,600 25,000
1,750
3,820
708,600
708,600
1,750
3,820
40,000
708,600
708,600
1,750
3,820
5,000 2,000 5,000 12,000
18,000 18,000
20,000 20,000
-
-
500,000
203,000
200,000
-
-
1,500 30,000 31,500
7,000 -
1,500 7,000 -
3,820 -
6,615 -
7,000
8,500
3,820
6,615
543,500
228,000
228,500
3,820
6,615
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
APRIL 30
FISCAL YEAR REVENUES LESS EXPENSES
REVENUES Other Revenues 05.00.38. 3800 Interest Income 3840 Escrow Recapture 3851 Development Escrow 3852 Temp. Occupy Escrow
Pass-thru for recapture agreements Developers cover review fees, letter of credit cash in, Builder receives temp. occupancy in bad weather
TOTAL REVENUES - ESCROW FUND EXPENSES Contractual Services 05.11.50. 5320 Engineering Service 5330 Legal Service 5350 Design Service 5490 Other Professional Services Capital Outlay 05.11.80. 8500 Subdivision Improvements Other Expenditures 05.11.90. 9290 Miscellaneous Expense 9400 Reimbursement-Escrow 9405 Recapture Payouts
TOTAL EXPENSES - ESCROW FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
18/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
IMPACT FEE FUND 09. TOTAL FUNDS AVAILABLE
2,605 2,605
1,325 1,280 2,605
1,325 1,325
1,325 2,816 4,141
10,595 10,595
TOTAL EXPENSES
-
-
-
2,816
9,270
APRIL 30
2,605
2,605
1,325
1,325
1,325
FISCAL YEAR REVENUES LESS EXPENSES
-
1,280
-
-
1,325
-
1,280 -
-
2,816
10,595
1,280
-
2,816
10,595
-
-
-
-
-
-
1,280
-
2,816
10,595
-
-
-
2,816 -
9,270 -
-
-
2,816
9,270
-
-
-
-
-
-
-
-
2,816
9,270
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
REVENUES Other Revenues 09.00.38. 3800 Interest Income 3832 Impact Fees
WAIVE FEES for FY 13-14
Other Financing Sources 09.00.39. 3990 Interfund Operating Transfer
TOTAL REVENUES - IMPACT FEE FUND EXPENSES Other Expenditures 09.11.90. 9290 Miscellaneous Expense 9401 Reimburse - School 9402 Reimburse - Park Other Financing Uses 09.11.95. 9990 Interfund Operating Transfer
TOTAL EXPENSES IMPACT FEE FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
19/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
MOTOR FUEL TAX FUND 17. TOTAL FUNDS AVAILABLE
563,544 249,100 812,644
501,201 395,643 896,844
501,201 254,100 755,301
406,607 408,620 815,227
319,834 319,779 639,613
TOTAL EXPENSES
517,200
333,300
452,200
314,026
233,006
295,444
563,544
303,101
501,201
406,607
(268,100)
62,343
(198,100)
94,594
86,773
228,500
368,543
233,500
269,375
252,001
600 20,000 20,600
600 26,500 27,100
600 20,000 20,600
292 138,953 139,245
518 67,260 67,778
249,100
395,643
254,100
408,620
319,779
95,000 75,000 200 2,000 172,200
7,500 77,000 300 84,800
24,900 80,000 300 2,000 107,200
58,752 161,212 203 220,167
128,509 540 129,049
15,000 28,000 2,000 45,000
5,000 20,500 25,500
15,000 28,000 2,000 45,000
2,696 21,252 23,948
3,012 25,059 28,071
250,000 50,000 300,000
223,000 223,000
260,000 40,000 300,000
69,911 69,911
59,836 16,050 75,886
517,200
333,300
452,200
314,026
233,006
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
APRIL 30
FISCAL YEAR REVENUES LESS EXPENSES
REVENUES Intergovernmental Revenues 17.00.34. 3430 Motor Fuel Tax Population 9204 x $23.50 (IML estimate Jan'13) + Hi growth $12K Other Revenues 17.00.38. 3800 Interest Income 3880 Reimbursements
0.25%
TOTAL REVENUES - MOTOR FUEL TAX FUND EXPENSES Contractual Services 17.11.50. 5140 Maint. Service - Street 5320 Engineering Service 5490 Other Professional Services 5530 Publishing 5940 Rentals/Leases
N Cypress & Co9 RH turn lane curb, pave & stripe MFT maintenance projects
Commodities 17.11.60. 6140 Maint. Supplies - Street 6160 Maint. Supplies-Snow Rem. 6290 Maint. Supplies - Other
cold patch, stone, concrete salt - State bid Traffic paint
Capital Outlay 17.11.80. 8600 Streets/Roads 8900 Other Improvements
Ruder Park Project $72K total match (including eng)
TOTAL EXPENSES - MOTOR FUEL TAX FUND T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
20/37
FY 2013-2014 Budget With Detail 4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
TAX INCREMENT FINANCING (TIF #1) FUND 18. TOTAL FUNDS AVAILABLE
575,900 923,000 1,498,900
1,333,860 916,100 2,249,960
1,333,860 923,000 2,256,860
1,683,170 930,731 2,613,901
1,536,843 930,155 2,466,998
TOTAL EXPENSES
1,348,100
1,674,060
2,173,210
1,280,041
783,828
150,800
575,900
83,650
1,333,860
1,683,170
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
APRIL 30
FISCAL YEAR REVENUES LESS EXPENSES
(425,100)
(757,960) (1,250,210)
(349,310)
146,327
REVENUES Taxes 18.00.31. 3110 Property Tax Other Revenues 18.00.38. 3800 Interest Income 3820 Rental Income-Wayfinders 3880 Reimbursements 3899 Misc. Income
0.25%
TOTAL REVENUES - TIF #1 FUND
919,000
900,650
901,000
921,333
926,750
4,000 4,000
1,550 11,400 2,500 -
1,500 18,000 2,500 -
5,923
3,405
2,500 975
-
15,450
22,000
9,398
3,405
923,000
916,100
923,000
930,731
930,155
2,000 35,000 5,000 5,000 10,000 1,000 58,000
2,000 52,600 9,000 43,900 35,000 500 -
2,000 52,600 9,000 43,900 35,000 500 -
2,000 71,965 3,748 66,652 22,055 457 -
3,092 3,470 4,408 5,768 19,766 50,808 118 -
143,000
143,000
166,877
87,430
10,000
-
3,000
-
2,854
EXPENSES Contractual Services 18.11.50. 5140 Maint. Service - Street 5152 Maint. Service-SA Sewer 5153 Maint. Service-Storm Sewer 5290 Maint. Service - Other 5310 Accounting Service 5320 Engineering Service 5330 Legal Service 5350 Design Service 5490 Other Professional Services 5530 Publishing 5540 Printing / Maps Commodities 18.11.60. 6140 Maint. Supplies - Street
South Creek Traffic Signal $20K
crosswalk surfacing
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
21/37
FY 2013-2014 Budget With Detail 4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
-
10,000 5,000 10,000
-
-
-
28,000
-
2,854
100,000 23,000 123,000
100,000 22,850
100,000 23,000
100,000 25,347
-
122,850
123,000
125,347
-
150,000 250,000 180,000 350,000 930,000
59,000 3,000 942,000 250,000
150,000 3,000 200,000 942,000 430,000
40,138 192,936 344 379,510
193,172 361,173 10,000 73,866
1,254,000
1,725,000
612,928
638,211
75,000 7,000 82,000
10,300 5,700 -
10,300 5,700 -
215,228 2,068 18,581 -
38,267 17,066 -
16,000
16,000
235,877
55,333
135,100
138,210
138,210
139,012
-
1,348,100
1,674,060
2,173,210
1,280,041
783,828
auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
6152 6153 6170 6290
4/15/2013
APPROVED APRIL 15, 2013
10,000 20,000
Maint. Supplies - SA Sewer Maint. Supplies-Storm Sewer Maint. Supplies - Grounds Maint. Supplies - Other
Debt Service 18.11.70. 7100 Principal Payment 7200 Interest Payment Capital Outlay 18.11.80. 8100 Land 8200 Building 8520 Sanitary Sewer System 8530 Storm Sewer System 8600 Streets/Roads 8800 Parkway Improvements 8900 Other Improvements Other Expenditures 18.11.90. 9116 Project Grants 9200 Sales Tax Rebate 9202 Property Tax Rebate 9290 Miscellaneous Expense 9400 Reimbursements Other Financing Uses 18.11.95. 9530 Intergovernmental Agreement
BUDGET FY 2013-14
Municipal Bank Municipal Bank
Property assembly
Curbs Division 250K; (Oak St 425K FY 13-14) Division St decorative lights Memorial Park 150K; SCreek signal $170K; PD,CC,VH rrigation $23K
Facades, business incentives Curwick Oak St
Surplus declared (15% of 2011 prop tax receipts)
TOTAL EXPENSES - TIF #1 FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
22/37
FY 2013-2014 Budget With Detail 4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
TAX INCREMENT FINANCING (TIF #2) FUND 19. TOTAL FUNDS AVAILABLE
189,751 144,850 334,601
182,171 139,150 321,321
182,171 144,850 327,021
171,796 139,156 310,952
171,159 136,007 307,166
TOTAL EXPENSES
131,820
131,570
131,570
128,781
135,370
APRIL 30
202,781
189,751
195,451
182,171
171,796
FISCAL YEAR REVENUES LESS EXPENSES
13,030
7,580
13,280
10,375
637
144,600
138,800
144,600
138,491
135,558
250 250
350 -
250 -
350
250
665 665
449 449
144,850
139,150
144,850
139,156
136,007
-
-
-
-
-
Capital Outlay 19.11.80. 8900 Other Improvements
-
-
-
-
-
Other Expenditures 19.11.90. 9290 Miscellaneous Expense
-
-
-
-
-
131,820
131,570
131,570
128,781
135,370
131,820
131,570
131,570
128,781
135,370
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
REVENUES Taxes 19.00.31. 3110 Property Tax
Assumes 1.5% growth
Other Revenues 18.00.38. 3800 Interest Income 3880 Reimbursements 3899 Misc. Income
0.25%
TOTAL REVENUES - TIF #2 FUND EXPENSES Contractual Services 19.11.50. 5310 Accounting Service 5320 Engineering Service 5330 Legal Service 5490 Other Professional Services 5530 Publishing
Other Financing Uses 19.11.95. 9530 Intergovernmental Agreement
Surplus disbursed
TOTAL EXPENSES - TIF #2 FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
23/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
WPCC EQUIPMENT/CAPITAL PROJECTS FUND 32.
ESTABLISHED 04/30/2013
BEGINNING BALANCE MAY 1 TOTAL REVENUES
882,228
TOTAL FUNDS AVAILABLE
1,542,228
TOTAL EXPENSES
550,000
-
APRIL 30
992,228
882,228
FISCAL YEAR REVENUES LESS EXPENSES
110,000
ENDING BALANCE
660,000
$882,228 MOVED from SEWER FUND to ESTABLISH WPCC CAPITAL PROJECTS FUND
REVENUES Other Revenues 32.00.38. 3800 Interest Income 3840 Recapture Fees Other Financing Sources 32.00.39. 3910 Proceeds-Bond Sales 3920 Proceeds-Fixed Asset Sales 3990 Interfund Operating Transfer
Waived for any residential development in 2013-2014
From Sewer Fund $55K/month=$660K
TOTAL REVENUES- WPCC CAPITAL PROJECTS FUND
-
-
-
-
-
-
-
-
-
660,000 660,000
-
-
-
-
-
-
-
-
660,000
-
-
-
-
550,000 550,000
354,200 252,600 -
500,000 150,000 10,000 -
69,341 7,926 -
37,828 -
606,800
660,000
77,267
37,828
550,000
606,800
660,000
77,267
37,828
EXPENSES Capital Outlay 32.11.80. 8100 Land 8200 Building 8300 Equipment 8400 Vehicle 8520 Sanitary Sewer System 8530 Storm Sewer System 8900 Other Improvements
Secondary clarifier improvements (yr 4-6 cap.plan) $500K >>>>>>>> Lester & Whispering Creek lift station generators $50K^^^
TOTAL EXPENSES- WPCC EQUIPMENT/CAPITAL FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
24/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
LEGACY PARK CAPITAL FUND 35. TOTAL FUNDS AVAILABLE
268,249 92,000 360,249
221,199 1,524,661 1,745,860
221,199 1,524,500 1,745,699
625,326 1,492,662 2,117,988
1,121,135 287,827 1,408,962
TOTAL EXPENSES
78,500
1,477,611
1,507,661
1,896,789
783,636
APRIL 30
281,749
268,249
238,038
221,199
625,326
FISCAL YEAR REVENUES LESS EXPENSES
13,500
47,050
16,839
(404,127)
(495,809)
-
400,000 -
400,000 -
400,000 -
-
400,000
400,000
400,000
-
2,000 50,000 52,000
500 109,000 5,000 -
500 108,000 5,000 -
762 16,785 75 300
1,605 865 22,500 1,100
114,500
113,500
17,922
26,070
40,000 40,000
35,000 975,161
35,000 976,000
224,740 850,000
261,757 -
1,010,161
1,011,000
1,074,740
261,757
92,000
1,524,661
1,524,500
1,492,662
287,827
-
200 2,000 500 10,000
200 2,000 2,500 13,750
2,000 9,606 1,605
38,641 5,094
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
REVENUES Intergovernmental Revenues 35.00.34. 3470 State Grant 3490 Other Grants Other Revenues 35.00.38. 3800 Interest Income 3820 Rental Income 3839 Other Donations 3880 Reimbursements 3899 Misc. Income Other Financing Sources 35.00.39. 3930 Intergovernmental Agreement 3990 Interfund Operating Transfer
0.25%
Township Annual contribution
TOTAL REVENUES - LEGACY PARK CAPITAL EXPENSES Contractual Services 35.11.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5170 Maint. Service - Grounds 5290 Maint. Service - Other 5310 Accounting Service 5320 Engineering Service 5330 Legal Service
Stump grinding, soil sampling
Staking or surveying (Add $ for eng. Future Phases???)
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
2,000 2,500 2,500 5,000
25/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
5350 5410 5490 5710 5730 5780 5930 5940
4/15/2013
Design Service Program/Event Services Other Professional Services Utilties Garbage Disposal Public Comfort Stations Risk Management-CommPk Rentals
Commodities 35.11.60. 6100 Maintenance Supplies 6110 Maint. Supplies - Building 6120 Maint. Supplies - Equipment 6170 Maint. Supplies - Grounds 6290 Maint. Supplies - Other 6580 Chemicals 6610 Program/Event Supplies 6890 Other Supplies / Materials
APPROVED APRIL 15, 2013 Add $ for Future Phases??? July 3rd None anticipated Com Ed, Aqua Port-o-potties 15% increase Aerator
None anticipated None anticipated Tree replacement, playground mulch, flower, seed None anticipated Fertilizer, 2-4-d, sterilizer, pre-emergents.. Signs, water supplies, misc None anticipated
Debt Service 35.11.70. 7100 Principal Payment 7200 Interest Payment Capital Outlay 35.11.80. 8200 Building 8300 Equipment 8350 Equipment < $5,000 8900 Other Improvements 8950 Other Improvements < $5,000
None anticipated None anticipated Picnic tables, garbage cans, bean bags None anticipated
Other Expenditures 35.11.90. 9290 Miscellaneous Expense
TOTAL EXPENSES LEGACY PARK
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
5,000 5,000 20,000 2,000 3,000 1,250 1,000 49,250
3,500 9,000 1,000 3,000 1,050 -
4,000 2,500 10,000 1,000 3,000 1,050 -
27,583 6,496 1,263 431 -
74,758 5,497 -
30,250
40,000
48,984
123,990
13,000 12,000 2,000 250 27,250
20,000 1,500 1,500 23,000
20,000
1,957
151
10,000 1,500 31,500
-
-
1,957
151
-
1,222,000 53,161
1,222,000 53,161
173,000 60,302
166,000 67,160
1,275,161
1,275,161
233,302
233,160
2,000 2,000
-
-
-
-
146,200 3,000
146,500 14,500
1,612,546 -
426,202 -
149,200
161,000
1,612,546
426,202
-
-
-
-
133
78,500
1,477,611
1,507,661
1,896,789
783,636
-
26/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
S&A EQUIPMENT/CAPITAL FUND 36.
ESTABLISHED 04/30/2013
BEGINNING BALANCE MAY 1 TOTAL REVENUES
738,558 140,000
$738,558 MOVED from GENERAL FUND to ESTABLISH
TOTAL FUNDS AVAILABLE
878,558
S&A EQUIPMENT/CAPITAL PROJECTS FUND
TOTAL EXPENSES
660,000
-
218,558
738,558
ENDING BALANCE
APRIL 30
FISCAL YEAR REVENUES LESS EXPENSES
(520,000)
REVENUES Taxes 36.00.31. 3150 Road & Bridge Tax
From Township Road
Other Revenues 36.00.38. 3800 Interest Income 3870 Retired Assets Other Financing Sources 36.00.39. 3990 Interfund Operating Transfer
TOTAL REVENUES - S&A EQUIP/CAPITAL FUND
140,000 140,000
FOR INFO ONLY 138,129
135,000
132,096
126,162
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
140,000
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
EXPENSES Capital Outlay 36.11.80. 8200 Building 8300 Equipment 8350 Equipment < $5,000 8400 Vehicle 8600 Streets/Roads
40 x 80 bldg expansion @$50/sq.ft=$160K Batwing $50K, Zero turn $15K, Backhoe $90K Vehicle lift $5K S Cypress $500K, PW asphalt lot expansion 1800 sq.yd@$40/sq.yd
TOTAL EXPENSES - S&A EQUIP/CAPITAL FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
155,000 5,000 500,000 660,000
660,000
FOR INFO ONLY 389,100
27/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
SEWER FUND 52. TOTAL FUNDS AVAILABLE
4,338,084 2,390,700 6,728,784
6,565,949 2,133,010 8,698,959
6,565,949 2,143,100 8,709,049
7,020,665 1,811,661 8,832,326
7,110,305 1,446,812 8,557,117
TOTAL EXPENSES
3,093,566
3,478,647
3,662,454
2,266,377
1,536,452
3,635,218
5,220,312
5,046,595
6,565,949
7,020,665
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
APRIL 30
FISCAL YEAR REVENUES LESS EXPENSES
(702,866)
Major Capital Expenditures from Dedicated Savings - GOB B&I Savings Pay-off UV Loan 1,120,300
(1,345,637) (1,519,354)
(454,716)
(89,640)
$882,228 MOVED from SEWER FUND to ESTABLISH WPCC CAPITAL PROJECTS FUND
REVENUES Taxes 52.00.31 3110 Property Taxes Intergovernmental Revenues 52.00.34. 3470 State Grant 3480 Federal Grant 3490 Other Grants Fines & Forfeits 52.00.35. 3530 Penalties 3550 Ordinance Fines 3590 Other Fines Service Charges 52.00.36. 3610 Water Charges 3621 Sewer Charges 3622 Sewer - Outside Limits 3623 Sewer - IL Vets 3640 Tap-on Fees 3690 Other Service Charges
Village sewer billing
Increase adds $300,000 to revenues Sunny Acres $14,500.50 x 12 (per ord se increase) $2518 x 12 Waived for any residential development in 2012-2013
Service Fees 52.00.37. 3790 Other Service Fees Other Revenues 52.00.38. 3800 Interest Income 3831 Development Donations T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
0.25%
6,500
8,600
8,600
7,203
7,734
-
43,310 -
43,500 -
-
-
43,310
43,500
-
-
-
-
-
-
-
-
-
-
-
2,170,000 172,000 30,200 2,372,200
1,870,400 172,000 30,200 1,300 -
1,880,400 172,000 30,200 1,200 -
1,616,605 143,243 30,216 -
1,239,398 116,457 32,734 400 -
2,073,900
2,083,800
1,790,064
1,388,989
-
-
-
-
-
5,000 -
6,200 -
6,200 -
5,713 -
18,928 28/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
3840 3870 3880 3899
4/15/2013
Recapture Fees Retired Assets Reimbursements Misc. Income
APPROVED APRIL 15, 2013 Waived for any residential development in 2012-2013 No ComEd buyback
Other Financing Sources 52.00.39. 3910 Proceeds-Bond Sales 3920 Proceeds-Fixed Asset Sales 3930 Intergovernental Agreement 3940 Short Term Note 3990 Interfund Operating Transfer
TOTAL REVENUES - SEWER FUND
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
1,000 1,000 5,000 12,000
1,000
1,000
7,504 1,177
17,856 590 12,715
7,200
7,200
14,394
50,089
-
-
-
-
-
-
-
-
-
2,390,700
2,133,010
2,143,100
1,811,661
1,446,812
81,500 500 6,000 5,084 1,189 11,890 106,163
81,300 100 4,100 4,929 1,153 11,130
81,300 100 4,100 4,929 1,153 11,130
-
-
-
-
102,712
102,712
-
-
8,000 5,000 18,000 3,000 500 150 2,700
7,150 1,000 18,000 2,400 1,500 900 3,000
7,150 4,900 18,000 2,400 1,500 900 800 3,000
7,000 5,828 1,878 5,520 13,500 2,773
6,940 -
EXPENSES ADMINISTRATION 52.11. Personnel 52.11.40. 4210 Wages - Regular 4220 Wages - Temp, Part Time 4230 Wages - Overtime 4510 Health Insurance 4515 HRA - SE Reimbursement 4520 Life Insurance 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution Contractual Services 52.11.50. 5310 Accounting Service 5320 Engineering Service 5330 Legal Service 5450 UB Outsourcing Service 5490 Other Professional Services 5510 Postage 5530 Publishing 5540 Printing / Maps 5710 Utilities - Lift Stations
Schulteis 50%, Kiedaisch 50%, Hays 50% (Utility billing/admin)
82,000 20% increase in Oct Reimburse health insurance deductible ($1K ind, $2K family) $7 May-Oct; $7.25 Nov-Apr 7 emp 4% on first $13,500 6.20% 1.45% IMRF estimate 14.5% (current 13.9%)
10% increase Contract negotiations $325/mo +billing stock $4K (1/2) + postage 16K (75%) Julie locates 2.5K moved to 52.46.50.5480 misc postage Clarifier rebuild ads Lift station com ed
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
14,134 4,000 3,723 2,372 29/37
FY 2013-2014 Budget With Detail 4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
5,302 1,500
5,350 1,500
5,302 -
4,433 -
40,752
45,500
41,801
35,602
2,500 500 3,000
1,750 500 -
2,500 500 -
1,423 2,000 -
-
2,250
3,000
3,423
-
1,097,640 22,640 1,120,280
70,000 48,010 -
70,000 48,100 -
70,000 50,670 -
65,000 53,075 -
118,010
118,100
120,670
118,075
300 300
400
400
8,330 121
-
400
400
8,451
-
660,000 660,000
975,161
975,161
925,000
45,000
975,161
975,161
925,000
45,000
1,937,193
1,239,285
1,244,873
1,099,345
198,677
auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
5930 Risk Management Contrib 5940 Rentals/Leases Commodities 52.11.60. 6450 Utility Billing Supplies 6520 Operating Supplies 6890 Other Supplies/Materials Debt Service 52.11.70. 7100 Principal Payment 7200 Interest Payment 7300 Fiscal Agent Fees Other Expenditures 52.11.90. 9290 Miscellaneous Expense 9400 Refund Se Chg Overpay
APPROVED APRIL 15, 2013 15% increase in Oct Copier lease for UB $300 mo
Keys
2005 GOB UV EARLY PAY-OFF Feb 2014 2005 GOB UV
NSF PAYMENTS Refund from revenue acct
Other Financing Uses 52.11.95. 9530 Intergovernmental Agreement 9990 Interfund Operating Transfer To WPCC Capital Fund $55K/mo=$660K
TOTAL EXPENSES - Sewer Administration
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 6,100 4,000 47,450
30/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
89,900 15,000 31,100 257 1,300 6,417 1,501 14,490
89,900 15,000 1,000 36,600 257 2,800 6,417 1,501 14,490
79,549 11,883 34,040 169 887 5,103 1,194 12,032
129,813 9,382 51 38,752 209 1,203 8,136 1,902 18,239
159,965
167,965
144,857
207,687
250 2,000 1,000 35,250 400 500 5,000 2,900 1,700 300 95,000 10,290 250 150,000
750 15,000 1,500 35,250 1,000 1,000 500 5,000 3,200 1,750 100 500 750 120,200 10,300 250 150,000
56 7,669 222 39,298 1,150 190 70 187 4,352 2,220 1,268 61 7 149 472 119,294
115 7,839 157 34,249 150 4,356 2,101 1,375 464 142,350
150,000
225 150,000
304,840
347,050
326,665
343,381
WPCC OPERATIONS 52.43. Personnel 52.43.40. 4210 Wages - Regular 4230 Wages - Overtime 4260 Wages - Shift Differential 4510 Health Insurance 4520 Life Insurance 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution Contractual Services 52.43.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5130 Maint. Service - Vehicle 5155 Maint. Service-Sludge Disp. 5170 Maint. Service - Grounds 5200 Maint. Service - Computer 5290 Maint. Service - Other 5320 Engineering Service 5340 Medical Service / Testing 5360 Janitorial Service 5490 Other Professional Services 5520 Telephone 5530 Publishing 5540 Printing / Maps 5590 Uniform Cleaning Service 5610 Dues / Licenses 5620 Travel Expenses 5630 Training 5635 Conferences / Prof Meetings 5640 Tuition Reimbursement 5710 Utilities 5930 Risk Management Contrib 5940 Rentals/Leases 5950 KRMA Sewer Lease/Fee
O'Keefe 25%, Wilson 75%, Bobera 50% 108,500 20% increase in Oct $7 May-Oct; $7.25 Nov-Apr 7 emp 4% on first $13,500 (4 emp) 6.20% 1.45% IMRF estimate 14% (current 13.9%)
Alarm system, boiler check, maint.bldg ventilation Skidsteer tires, calibration, vehicle inspection Misc repairs Re-bid contract for 2013-15 Pave N maint shed entrance Misc repairs None anticipated KRMA connection review & update tech. Random drug testing None anticipated Extinguisher test, sample test, alarm service $20/mo
1 cell $560, DSL, Fax, phone Ads for bids - sludge, clarifier rebuild None anticipated 1/2 cost; $17.50/wk per employee (3) None anticipated None anticipated Welding, electrical & pump maint & repair None anticipated None anticipated Lift station electric (7.5K/mo) +10% 15% increase in Oct Pumps, pressure washer lease fee 150K, user fees 75K
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
(+$4,500)
93,000 15,000 500 30,700 257 2,160 6,727 1,573 15,190 165,107 5,000 10,000 1,000 40,000 6,000 500 1,000 500 5,000 3,000 300 1,800 100 860 100,000 11,850 250 150,000 337,160
31/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
Commodities 52.43.60. 6110 Maint. Supplies - Building 6120 Maint. Supplies - Equipment 6130 Maint. Supplies - Vehicle 6170 Maint. Supplies - Grounds 6200 Maint. Supplies - Computer 6290 Maint. Supplies - Other 6510 Office Supplies 6520 Operating Supplies 6525 Lab Supplies 6530 Small Tools 6540 Janitorial Supplies 6550 Gasoline 6560 Diesel Fuel 6570 Lubricants 6580 Chemicals 6590 Uniform Supplies 6600 Safety Supplies 6700 Books/Subscriptions 6840 Computer App / Software 6890 Other Supplies / Materials Debt Service 52.43.70. 7100 Principal Payment 7200 Interest Payment 7300 Fiscal Agent Fees Capital Outlay 52.43.80. 8100 Land 8200 Building 8300 Equipment 8350 Equipment < $5,000 8400 Vehicle 8700 Furniture 8900 Other Improvements 8950 Other Improvements < $5,000
APPROVED APRIL 15, 2013 T8 lighting EPA requirement (partial grant reimb) General maintenance Oil, coolant, misc Fence & grading repairs None anticipated None anticipated ink, paper, misc Repair, steel, hoses, welding supplies, o/ac Beakers, chart paper, distilled water Grinders, saws, bench supplies Toilet paper, towels, cleaners gas used will come from collections None anticipated Degreaser, generator oil, grease Hydroclean solution, chlorine, sulf.dioxide Reimbursed safety boots, glasses, shirts, coats, First aid supplies
Keys, flags, misc
IEPA Loan / WPCC Expansion 1999 IEPA Loan / WPCC Expansion 1999
None anticipated None anticipated UNDER WPCC CAPITAL FUND $500,000 None anticipated None anticipated None anticipated Motorized entrance gate
Other Expenditures 52.43.90. 9120 State/Federal Permit Fees T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
4,000 15,000 1,000 1,000 500 2,000 1,500 1,000 250 250 7,000 500 1,500 250 35,750
3,000 17,000 1,000 1,000 1,000 2,000 1,500 1,000 150 250 9,000 500 1,500 250
3,000 17,000 1,000 1,000 1,000 2,000 1,500 1,000 150 250 9,000 500 1,500 250
491 15,153 847 506 991 1,786 896 671 20 39 7,349 100 316 287
537 16,469 129 820 1,468 1,134 550 78 69 31 6,915 167 464 194
39,150
39,150
29,452
29,025
290,000 23,200 313,200
843,850 18,350 -
843,850 18,350 -
251,336 62,584 -
244,227 69,693 -
862,200
862,200
313,920
313,920
12,000 12,000
354,200 -
410,000 25,000 -
69,341 13,966 -
197,780 -
354,200
435,000
83,307
197,780
18,000
17,500
18,000
17,500
17,500 32/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
9290 Miscellaneous Expense
APPROVED APRIL 15, 2013 sample shipping
TOTAL EXPENSES - WPCC
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
250 18,250
100 17,600
250 18,250
103 17,603
139 17,639
881,467
1,737,955
1,869,615
915,804
1,109,432
113,200 10,000 500 15,500 85 540 7,669 1,794 17,318 166,606
111,400 7,000 500 15,500 85 700 7,254 1,697 16,380 160,516
111,400 7,500 500 16,000 85 700 7,254 1,697 16,380 161,516
100,284 5,329 15,843 85 5,794 1,355 13,999 142,689
98,333 2,764 16,529 68 5,598 1,309 13,242 137,843
1,000 5,000 1,000 1,000 2,200 3,000 1,700 9,000 5,600
4,000 500 1,000 -
7,000 1,000 2,500 2,500 1,400 850 1,600 150 500 750 15,000 20,400
3,624 285 -
3,714 303 1,386 48 -
508 163 1,268 13,789 14,236
325 1,375 11,989 15,219
COLLECTION SYSTEM 52.46. Personnel 52.46.40. 4210 Wages - Regular 4220 Wages - Temp, Part Time 4230 Wages - Overtime 4260 Wages - Shift Differential 4510 Health Insurance 4520 Life Insurance 4530 Unemployment Insurance 4610 Social Security Contribution 4620 Medicare Contribution 4630 Retirement Contribution Contractual Services 52.46.50. 5110 Maint. Service - Building 5120 Maint. Service - Equipment 5130 Maint. Service - Vehicle 5152 Maint. Service - SA Sewer 5153 Maint. Service-Storm Sewer 5290 Maint. Service - Other 5320 Engineering Service 5340 Medical Service / Testing 5480 JULIE Locate Service 5490 Other Professional Services 5530 Publishing 5540 Printing / Maps 5590 Uniform Cleaning Service 5610 Dues / Licenses 5620 Travel Expenses 5630 Training 5635 Conferences / Prof Meetings 5640 Tuition Reimbursement 5710 Utilities 5930 Risk Management Contrib
O'Keefe 25%, Wilson 25%, Bobera 50%, Mueller 100%
123,700 20% increase in Oct 6x$6.45; 6x$7.00 4% on first $13,500 (1 emp) 6.20% 1.45% IMRF estimate 14% (current 13.9%)
Fire & heat alarm I&I, troubleshooting, electrical rebuid pumps VacCon issues, inspections None anticipated None anticipated None anticipated KRMA connection review & update tech. Annual Alarm service, lift station monitoring $2.3K(from Utilities) None anticipated None anticipated 1/2 cost; $17.50/wk per employee (3) None anticipated None anticipated None anticipated None anticipated None anticipated lift station electricity & gas, KRMA lines 15% increase in Oct
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
500 1,600 135 12,000 4,806
33/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
5940 Rentals/Leases Commodities 52.46.60. 6110 Maint. Supplies - Building 6120 Maint. Supplies - Equipment 6130 Maint. Supplies - Vehicle 6152 Maint. Supplies - SA Sewer 6153 Maint. Supplies-Storm Sewer 6290 Maint. Supplies - Other 6480 JULIE Locate Supplies 6520 Operating Supplies 6530 Small Tools 6550 Gasoline 6560 Diesel Fuel 6570 Lubricants 6590 Uniform Supplies 6890 Other Supplies / Materials Capital Outlay 52.46.80. 8300 Equipment 8350 Equipment < $5,000 8400 Vehicle 8520 Sanitary Sewer System 8530 Storm Sewer System 8900 Other Improvements 8950 Other Improvements < $5,000
APPROVED APRIL 15, 2013 Pumps, compressor
Well 3, 4, 5 house roofing Generators, pumps, hoses, seals, controls VacCon, JULIE van - Tires, oil, wipers, misc Lift station floats, chimney seals, rims, pumps Concrete, rims reducers - manholes
Batteries, disks, paint, smoke, boots, elbows, weed eater line Hand tools, heaters 1500 gal@$3.50/gal - all sewer dept vehicles (+10%) 1000 gal@$4.00/gal - all sewer dept vehicles (+10%) Lift station grease, generator oil Reimbursed safety boots, glasses under WPCC Keys, Reducers, ferncos,
UNDER WPCC CAPITAL FUND $50,000 Powered lift station & manlift hoist None anticipated None anticipated
Other Expenditures 52.46.90. 9120 State/Federal Permit Fees 9290 Miscellaneous Expense
TOTAL EXPENSES - Collections
TOTAL EXPENSES - SEWER FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
BUDGET FY 2013-14 250 29,750
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
250
250
-
236
24,791
53,900
33,873
34,595
5,000 4,000 500 5,000 2,000 1,000 300 6,400 4,000 100
6,000 5,000 1,000 5,000 2,000 -
2,794 22 3,144 2,085 -
3,289 16 4,756 2,591 -
1,500 500 7,000 4,000 200 100
344 270 6,174 2,045 22 17
664 90 4,545 1,945 39 96
28,300
32,300
16,917
18,031
5,000 25,000 10,000 40,000
12,950 22,000 252,600 -
13,450 23,950 252,600 10,000 -
49,823 7,926 -
37,828 -
287,550
300,000
57,749
37,828
250 250
250
250
-
46
250
250
-
46
274,906
501,407
547,966
251,228
228,343
3,093,566
3,478,647
3,662,454
2,266,377
1,536,452
7,000 5,000 1,000 5,000 4,000 1,500 1,000 500 8,000 5,000 200 100 38,300
34/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
GOLF COURSE FUND 57. TOTAL FUNDS AVAILABLE
6,234 6,234
10,084 10,084
10,084 10,084
13,923 57 13,980
15,636 47 15,683
TOTAL EXPENSES
5,300
3,850
5,300
3,896
1,760
934
6,234
4,784
10,084
13,923
(3,850)
(5,300)
(3,839)
(1,713)
BEGINNING BALANCE MAY 1 TOTAL REVENUES
ENDING BALANCE
APRIL 30
FISCAL YEAR REVENUES LESS EXPENSES
(5,300)
REVENUES Other Revenues 57.00.38. 3800 Interest Income 3870 Retired Assets 3899 Misc. Income Other Financing Sources 57.00.39. 3920 Proceeds-Fixed Asset Sales 3990 Interfund Operating Transfer
TOTAL REVENUES - GOLF COURSE FUND
-
-
-
57 57
47 47
-
-
-
-
-
-
-
-
57
47
1,800 2,500 4,300
3,850 3,850
4,300 4,300
3,896 3,896
1,760 1,760
-
-
-
-
-
1,000
-
1,000
-
-
-
-
-
-
-
5,300
3,850
5,300
3,896
1,760
EXPENSES Contractual Services 57.11.50. 5110 Maint. Service - Building 5170 Maint. Service - Grounds 5310 Accounting Service 5490 Other Professional Services 5930 Risk Management Contribution Capital Outlay 57.11.80. 8900 Other Improvements Other Expenditures 57.11.90. 9290 Miscellaneous Expense Other Financing Uses 57.11.95. 9990 Interfund Operating Transfer
TOTAL EXPENSES - GOLF COURSE
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
35/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
SUMMARY ALL FUNDS WITH BEGINNING / ENDING BALANCES Estimated 5/1/13 Balance
GENERAL FUND
FY 2013-14 Revenues
FY 2013-14 Estimated Expenses 4/30/14 Balance
854,298
4,782,470
4,781,903
854,865
35,325
6,050
6,000
35,375
523,357
40,000
543,500
19,857
2,605
-
-
2,605
MOTOR FUEL TAX FUND
563,544
249,100
517,200
295,444
TIF #1 FUND
575,900
923,000
1,348,100
150,800
TIF #2 FUND
189,751
144,850
131,820
202,781
WPCC CAPITAL FUND
882,228
660,000
550,000
992,228
LEGACY PARK CAPITAL FUND
268,249
92,000
78,500
281,749
S&A EQUIP/CAPITAL FUND
738,558
140,000
660,000
218,558
4,338,084
2,390,700
3,093,566
3,635,218
6,234
-
5,300
934
8,978,133
9,428,170
11,715,890
6,690,413
COMMUNITY FUND ESCROW FUND IMPACT FEE FUND
SEWER FUND GOLF COURSE FUND ALL FUNDS
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
36/37
FY 2013-2014 Budget With Detail auto updates to other sheets
VILLAGE OF MANTENO FY 2013-2014 BUDGET Update 02/06/13
4/15/2013
APPROVED APRIL 15, 2013
BUDGET FY 2013-14
4/9/2013
AMENDED
PROJECTED
BUDGET
ACTUAL
ACTUAL
FY 2012-13
FY 2012-13
FY 2011-12
FY 2010-11
POLICE PENSION FUND 76. REVENUES Other Revenues 76.00.38. 3800 Interest Income 3805 Interest Inv. Raymond James 3880 Reimbursements 3885 Employee P/R Deductions 3886 Employer Contributions 3899 Misc. Income
TOTAL REVENUES - POLICE PENSION FUND
90,000 99,000 320,000 509,000
90,000 95,000 260,000 445,000
90,000 95,000 260,000 445,000
90,000 4,040 105,000 220,000 419,040
90,000 488,756 105,000 186,277 870,033
509,000
445,000
445,000
419,040
870,033
20,000 20,000
-
20,000 20,000
20,000 20,000
20,000 20,000
6,000 800 6,800
5,450 775 6,225
5,450 800 6,250
1,300 775 2,075
1,300 775 2,075
-
-
-
-
-
700 700
650 650
650 650
500 500
500 500
27,500
6,875
26,900
22,575
22,575
EXPENSES Personnel 76.11.40. 4210 Refunds, Pensions 4610 Social Security Contribution 4620 Medicare Contribution Contractual Services 76.11.50. 5310 Accounting Service 5330 Legal Service 5490 Other Professional Services 5610 Dues / Licenses 5620 Travel Expenses 5630 Training 5635 Conferences / Prof. Meetings Commodities 76.11.60. 6890 Other Supplies / Materials Other Expenditures 76.11.90. 9120 State/Federal Fees 9290 Miscellaneous Expense
TOTAL EXPENSES - POLICE PENSION FUND
T:\jschulteis\BUDGET\BUDGET FY 13-14\BUDGET 13-14 with comments.xls
37/37