Spreadsheet

UNION TOWNSHIP EXPENDITURE REPORT BY DEPARTMENT

2010 PROPOSED BUDGET FUND 01 - GENERAL









EXPENDITURE CATEGORIES

2006 2007 2008 2009 2009 2009 2009 2010

ACTUAL ACTUAL ACTUAL Budget Actual Remaining % Budget

Thru Nov Thru Dec Thru Dec Proposed

Acct.No. ADMINISTRATIVE - 401

01.400.000 Supervisors-Meeting Pay 9,800 9,300 10,000 10,000 7,300 2,700 73.00% 10,000

01.400.158 Supervisors - Life Insurance 348 551 1,102 1,500 1,116 384 74.40% 1,500

01.400.200 Supervisors - Expenses 23 384 49 1,000 46 954 4.60% 250

01.400.340 Supervisor - Advertising - 825 1,000 - 1,000 0.00% 250

01.400.420 Supervisors Dues 651 - 436 750 225 525 30.00% 500

01.400.460 Supervisors-Conventions/Mtg 1,238 425 125 1,000 260 740 26.00% 1,000

SUBTOTAL 12,060 11,485 11,712 15,250 8,947 6,303 58.67% 13,500



Acct.No. AUDITOR - 402

01.402.200 Auditors - Elected - - 500 73 427 14.60% 250

01.402.200 Auditor Expenses 222 700 75 500 500 0.00% 250

01.402.311 Auditors - Accounting/Audit 12,732 9,048 12,440 14,000 6,989 7,011 49.92% 10,000

SUBTOTAL 12,954 9,748 12,515 15,000 7,062 7,938 47.08% 12,000



Acct.No. TAX COLLECTION - 403

01.403.100 Tax Collector-Salary 10,768 10,977 11,628 11,000 11,556 (556) 105.05% 12,000

01.403.160 Tax Collecter - Keystone 9,138 6,432 6,079 8,000 6,574 1,426 82.18% 10,000

01.403.200 Tax Collector - Supplies 1,407 1,484 3,361 1,550 1,928 (378) 124.39% 2,000

01.403.430 Reimbursements RE Tax 68 - 11 200 200 0.00% 200

01.403.500 Contributions TCC 200

SUBTOTAL 21,381 18,893 21,079 20,750 20,058 692 96.67% 24,400



Acct.No. LEGAL - 404

01.404.314 Legal - Solicitor 28,324 60,955 35,138 50,000 29,396 20,604 58.79% 42,000

01.404.300 Legal-Special Services 3,451 1,677 645 - - #DIV/0! -

01.404.410 Legal - Codification - - 2,600 - 2,600 0.00% 2,600

01.404.420 Legal - Due/Subscription - - - - - #DIV/0! -

SUBTOTAL 31,775 62,632 35,783 52,600 29,396 23,204 55.89% 44,600









Last Revised: 12/3/2011 Page: 1

UNION TOWNSHIP EXPENDITURE REPORT BY DEPARTMENT

2010 PROPOSED BUDGET FUND 01 - GENERAL









EXPENDITURE CATEGORIES

2006 2007 2008 2009 2009 2009 2009 2010

ACTUAL ACTUAL ACTUAL Budget Actual Remaining % Budget

Thru Nov Thru Dec Thru Dec Proposed

Acct.No. SECRETARY - 405

01.405.100 Secretary/Treasurer Salary 26,871 27,972 28,134 35,000 32,418 2,582 92.62% 37,500

01.405.110 Clerk Compensation 14,174 27,791 28,737 29,650 26,177 3,473 88.29% 30,550

01.405.157 Secretary-Retirement 3,185 3,185 0.00% 3,185

01.405.157 Secretary-Life Ins - - 348 500 372 128 74.40% 500

01.405.157 Clerk-Life Ins 464 372 (372) #DIV/0! 500

01.405.210 Secretary-Office Supplies 230 1,762 3,908 3,000 4,032 (1,032) 134.40% 4,000

01.405.200 Clerk Benefits - 5,785 16,830 20,800 18,695 2,105 89.88% 22,500

01.405.200 Secretary-Legal Advertising 3,024 2,901 9,473 5,000 6,391 (1,391) 127.82% 8,000

01.405.325 Secretary - Postage 413 246 625 1,000 679 321 67.90% 1,000

01.405.338 Secretary - Mileage 62 101 261 200 124 76 62.00% 200

01.405.342 Sec. - Bank Fee 598 551 103 200 43 157 21.50% 200

01.405.353 Treasurers Bond 325 388 700 533 167 76.14% 700

01.405.374 Sec. - Repair/Main-Equipment - - 63 500 1,292 (792) 258.40% 1,000

01.405.420 Sec - Dues & Subscriptions 285 1,679 1,700 1,000 140 860 14.00% 500

01.405.425 Sec - Cont Serv Fees 730 - #DIV/0!

01.405.460 Sec - Training/Conferences 254 - 140 500 367 133 73.40% 500

01.406.000 General Govt Administration 1,304 (1,304) #DIV/0! 1,000

01.407.270 Sec. - Computer 8,659 4,632 1,000 - 1,000 0.00% 1,000

01.407.320 Communications 5,206 3,880 4,542 4,000 4,543 (543) 113.58% 5,000

SUBTOTAL 60,101 77,688 96,058 106,235 97,482 8,753 91.76% 117,835

*Upgrade 1

*Upgrade 1 PC in Office PC in Office *Upgrade 1 PC in Office

Acct.No. ENGINEERING-408

01.408.100 Engineer 7,178 12,033 12,457 16,000 20,159 (4,159) 125.99% 18,000

01.408.214 Maps/fees - - - - - #DIV/0! -

01.408.340 Advertising 392 2,851 - - - #DIV/0! -

SUBTOTAL 7,570 14,884 12,457 16,000 20,159 (4,159) 135.44% 18,000



Acct.No. BUILDINGS & PLANTS - 409

01.409.000 Building - Office Supplies 2,572 2,115 1,468 2,500 1,634 866 65.36% 2,500

01.409.241 Building - General Supplies 468 625 437 1,500 1,015 485 67.67% 1,500

01.409.310 Building Appraisal/Inspect - 66 750 - 750 0.00% 750

01.409.361 Electric 4,718 3,753 4,931 6,000 4,296 1,704 71.60% 6,000

01.409.362 Gas 5,877 5,914 8,371 10,000 6,344 3,656 63.44% 10,000

01.409.364 Sewer 456 463 421 650 419 231 64.46% 650

01.409.366 Water 277 233 (2,709) 750 281 469 37.47% 500

01.409.600 Bldg. - Repairs/Maint 7,161 4,667 3,562 6,000 3,038 2,962 50.63% 6,000

01-409-740 Bldg -Mach & Equip 35,000 #DIV/0! 25,000

SUBTOTAL 21,529 17,836 16,481 28,150 52,027 11,123 184.82% 52,900









Last Revised: 12/3/2011 Page: 2

UNION TOWNSHIP EXPENDITURE REPORT BY DEPARTMENT

2010 PROPOSED BUDGET FUND 01 - GENERAL









EXPENDITURE CATEGORIES

2006 2007 2008 2009 2009 2009 2009 2010

ACTUAL ACTUAL ACTUAL Budget Actual Remaining % Budget

Thru Nov Thru Dec Thru Dec Proposed



Acct.No. POLICE DEPT - 410

01.410.100 Police - Payroll/Interest - - 71,520 #VALUE!

01.410.105 CHIEFADM - - #VALUE!

01.410.157 Health Insurance - - #VALUE!

01.410.158 Life Insurance - - #VALUE!

01.410.182 Police - Longevity Pay - - #VALUE!

01.410.183 OT - Court - - #VALUE!

01.410.188 Subtracting Grievance 6,145 #DIV/0!

01.410.199 Workmens Comp Police Reimb - - #VALUE!

01.410.200 Supplies & Expenses - - #VALUE!

01.410.220 Police - Computer - - #VALUE!

01.410.230 Uniforms - - #VALUE!

01.410.250 Vehicle Expense - 119 #VALUE!

01.410.300 Dog Law Officer - - #VALUE!

01.410.314 Police - Special Legal Serv - - #VALUE!

01.410.325 Postage - - #VALUE!

01.410.326 Police-Radio Service - - #VALUE!

01.410.451 Police - Contract Maint 5,000 8,724 (3,724) - #DIV/0!

01.410.460 Police - Mtg/Conf/Training - - #VALUE!

01.410.700 Vehicle - Radio Equipment - - #VALUE!

SUBTOTAL 5,000 8,843 73,941 - - #DIV/0! -



Acct.No. FIRE DEPT - 411

01.411.361 Hydrants 36,946 39,774 31,654 45,000 34,174 10,826 75.94% 40,000

01.411.450 Fire Department Services 21,250 21,250 21,250 21,250 21,250 - 100.00% 23,250

01.411.461 Foreign Fire Insurance 8,539 34,450 35,283 34,500 31,530 2,970 91.39% 31,000

01.412.450 Ambulance Service 500

SUBTOTAL 66,735 95,474 88,187 100,750 86,954 13,796 86.31% 94,750



Acct.No. CODE ENFORCEMENT-413

01.413.310 Code Enforc - CodeSys - 4,775 8,767 10,000 2,300 7,700 23.00% 4,000

01.413.310 Code Enforc - BCO - #DIV/0! 22,000

01.413.450 Code Enforc - Animal Contr 2,400 2,700 2,475 2,700 2,475 225 91.67% 2,700

01.413.460 UCC Education Fee 296 404 (404) #DIV/0! 200

SUBTOTAL 2,400 7,475 11,538 12,700 5,179 7,521 40.78% 28,900









Last Revised: 12/3/2011 Page: 3

UNION TOWNSHIP EXPENDITURE REPORT BY DEPARTMENT

2010 PROPOSED BUDGET FUND 01 - GENERAL









EXPENDITURE CATEGORIES

2006 2007 2008 2009 2009 2009 2009 2010

ACTUAL ACTUAL ACTUAL Budget Actual Remaining % Budget

Thru Nov Thru Dec Thru Dec Proposed

Acct.No. PLANNING/ZONING 414

01.414.100 Zoning Salaries 5,380 23,002 20,608 40,000 38,911 1,089 97.28% 18,000

01.414.157 Health Insurance - 9,870 18,000 18,000 0.00%

01.414.158 Life Insurance - 348 500 500 0.00%

01.414.212 Supplies 2 610 650 - 650 0.00% 100

01.414.310 Updating 5 200 100 500 500 0.00% 500

01.414.314 ZHB - Legal Services 1,398 259 476 1,500 650 850 43.33% 1,500

01.414.325 Postage 114 - 112 2,000 884 1,116 44.20% 1,500

01.414.338 Mileage - 206 250 - 250 0.00% 100

01.414.340 Advertising 1,347 184 397 2,000 (536) 2,536 -26.80% 1,500

01.414.400 Zoning Bd. Hearing - Trans. 568 853 3,446 2,000 1,669 331 83.45% 2,000

01.414.430 Training 150 35 1,000 - 1,000 0.00% 750

01.414.450 Zoning - Contracted Svcs 15,549 8,275 120 5,000 (145) 5,145 -2.90% 5,000

01.414.455 Zoning - Other Expenses 627 2,600 2,600 2,600 (298) 2,898 -11.46% 2,600

01.414.470 Zoning - Reimbursements - - 110 150 150 0.00% 150

SUBTOTAL 25,140 46,442 27,969 76,150 41,135 35,015 54.02% 33,700



Acct.No. RECYCLING - 426

01.419.280 Neighborhood Watch Supp 2,448 - #DIV/0!

01.426.227 Recycling Expense - 4,533 500 - 500 0.00% 500

01.429.310 Wastewater-Prof Svcs 409 - #DIV/0! 500

SUBTOTAL - 4,942 2,448 500 - 500 0.00% 1,000



Acct.No. PUBLIC WORKS - 430

01.430.100 General Highway Salaries 141,933 133,162 134,018 170,000 119,372 50,628 70.22% 172,000

01.430.157 Highway - Benefits - Health 57,913 42,631 57,545 93,000 65,253 27,747 70.16% 99,000

01.430.158 Highway - Benefits - Life 1,392 1,740 1,044 1,750 1,116 634 63.77% 1,750

01.430.191 Highways - Uniform 1,881 1,569 1,294 1,750 1,333 417 76.17% 2,000

01.430.231 Vehicle - Gas 8,377 11,553 10,767 14,000 8,420 5,580 60.14% 12,000

01.430.232 Vehicle - Diesel 3,936 5,262 6,667 6,000 4,097 1,903 68.28% 6,000

01.430.251 Vehicle - Parts 2,256 3,893 2,401 1,500 1,861 (361) 124.07% 2,000

01.430.300 General Highway Vehicles 7,334 14,098 9,146 8,000 3,170 4,830 39.63% 5,000

01.430.400 General Highway Expenses 8,772 61,665 8,569 6,000 5,295 705 88.25% 8,000

01.432.200 Snow Removal Expenses - 64,360 117,053 90,000 38,650 51,350 42.94% 90,000

01.433.361 Traffic Signals, Signs 1,889 13,142 1,153 4,000 5,245 (1,245) 131.13% 4,500

01.435.372 Storm Sewer Expense 3,200 - 7,912 3,500 9,445 (5,945) 269.86% 8,000

01.437.200 Equipment Repairs 13,706 989 1,946 10,000 2,506 7,494 25.06% 8,000

01.437.251 Equipment - Parts 10,233 1,246 783 8,000 2,264 5,736 28.30% 5,000

01.437.700 Equipment - New 8,690 75,740 104,780 40,000 2,360 37,640 5.90% 75,000

01.438.600 Road Maintenance 127,328 35,232 65,378 50,000 16,692 33,308 33.38% 50,000

01.439.310 Road Paving-Cont Svcs 261,264 113,000 48,317 64,683 42.76% 113,000

SUBTOTAL 398,840 466,282 791,720 620,500 335,396 285,104 54.05% 661,250







Last Revised: 12/3/2011 Page: 4

UNION TOWNSHIP EXPENDITURE REPORT BY DEPARTMENT

2010 PROPOSED BUDGET FUND 01 - GENERAL









EXPENDITURE CATEGORIES

2006 2007 2008 2009 2009 2009 2009 2010

ACTUAL ACTUAL ACTUAL Budget Actual Remaining % Budget

Thru Nov Thru Dec Thru Dec Proposed



Acct.No. RECREATION - 450

01.451.241 Recreation Bldg Maint 2,211 1,925 3,958 5,000 8,203 (3,203) 164.06% 6,000

01.451.245 Recreation - Road Supplies - - - 500 3,104 (2,604) 620.80% 500

01.451.340 Recreation - Legal Adv 55 - - - - #DIV/0! -

01.451.361 Rec - Electricity 526 797 597 500 876 (376) 175.20% 1,000

01.451.364 Rec - Sewage 1,100 640 960 2,100 960 1,140 45.71% 1,200

01.451.366 Rec - Water 261 270 391 500 350 150 70.00% 500

01.457.361 Memorial Elec 300 100 300 100 200 33.33% 300

SUBTOTAL 4,153 3,932 6,006 8,900 13,593 (4,693) 152.73% 9,500



Acct.No. DEBT SERVICE 470

01.471.400 Debt Service - Principal 42,180 - - 23,015 21,253 1,762 92.34% 43,435

01.472.400 Debt Service - Interest 3,939 1,655 1,075 4,835 4,025 810 83.25% 6,805

SUBTOTAL 46,119 1,655 1,075 27,850 25,278 2,572 90.76% 50,240



Acct.No. MISC EXPENDITURES-481

01.480.200 Miscellaneous Expense 2,001 400 572 2,500 533 1,967 21.32% 1,000

01.480.360 Tax Refunds - - - - #DIV/0!

01.482.000 Judgments/Settlements - - 871 500 704 (204) 140.80% 1,000

SUBTOTAL 2,001 400 1,443 3,000 1,237 1,763 41.23% 2,000



Acct.No. INSURANCE 486

01.486.001 Fire, Auto, Liability 23,225 22,939 22,508 24,000 586 23,414 2.44% 19,000

01.486.352 Deductible - - 1,440 2,500 3,560 (1,060) 142.40% 5,000

01.486.353 Workers Compensation 17,616 23,160 16,087 18,600 16,366 2,234 87.99% 19,000

SUBTOTAL 40,841 46,099 40,035 45,100 20,512 24,588 45.48% 43,000



Acct.No. EMPLOYEE BENEFITS - 487

01.487.161 FICA & Medicare Expense 15,971 18,064 20,578 21,500 15,965 5,535 74.26% 21,500

01.487.160 Non-Uniform Pension 15,276 14,338 14,204 16,650 12,328 4,322 74.04% 16,650

01.487.353 Police Pension (Pass thru) 1,478 - 2,500 2,500 0.00%

01.487.162 Unemployment 1,885 2,972 4,438 3,500 3,644 (144) 104.11% 4,200

SUBTOTAL 34,610 35,374 39,220 44,150 31,937 12,213 72.34% 42,350









Last Revised: 12/3/2011 Page: 5

UNION TOWNSHIP EXPENDITURE REPORT BY DEPARTMENT

2010 PROPOSED BUDGET FUND 01 - GENERAL









EXPENDITURE CATEGORIES

2006 2007 2008 2009 2009 2009 2009 2010

ACTUAL ACTUAL ACTUAL Budget Actual Remaining % Budget

Thru Nov Thru Dec Thru Dec Proposed

Acct.No. OTHER USES - 490

01.491.000 Refunds of Prior Rev 183 250 250 0.00% 250

01.492.023 Transfer to Capital Res Fund - - 37,500

01.492.080 Transfer to Elrama Sew Fund 642

01.495.200 Due to Salt Storage Acct - - -

01.495.300 Reimburse Police Pension - - -

01.495.400 Reimburse Patterson Road Acct 16,271 - -

01.495.500 Reimburse Escrow Account - - -

01.495.600 Reimburse Water Fund - -

01.495.700 Transfer to Operating Res - -

01.495.750 Transfer to Capital Projects 250,000 - - - -

01.495.900 Contingency-Current Year - - - - -

SUBTOTAL 266,271 - 38,325 250 - 250 0.00% 250



TOTAL EXPENSES 1,059,480 930,084 1,327,992 1,193,835 796,352 397,483 66.71% 1,250,175





174,691 138,607 915 1,800









Last Revised: 12/3/2011 Page: 6

UNION TOWNSHIP REVENUE REPORT

BY SOURCE

2010 PROPOSED BUDGET FUND 01 - GENERAL









2006 2007 2008 2009 2009 2009 2009 2010

REVENUE CATEGORY ACTUAL ACTUAL ACTUAL BUDGET Actual Remaining % BUDGET

Thru Nov Thru Dec Thru Nov Proposed

Beginning Fund Balance 58.33%



Acct. No. REAL ESTATE TAXES - 300

01.301.100 Real Estate Taxes - Current Estimate 369,609 364,375 386,964 385,000 380,220 4,780 98.8% 380,000

01.301.400 Real Estate Taxes - Tax Claim 19,176 16,860 18,109 15,000 17,731 (2,731) 118.2% 16,000

SUBTOTAL -- RE TAXES 388,785 381,235 405,073 400,000 397,951 2,049 99.5% 396,000





Acct. No. ACT 511 ENABLING TAXES - 310

01.310.010 Per Capita Tax 13,213 10,880 12,489 12,000 11,898 102 99.2% 12,000

01.310.100 Real Estate Transfer Tax 46,831 60,197 74,956 55,000 43,784 11,216 79.6% 47,000

01.310.210 Earned Income Tax 406,490 430,110 432,223 420,000 384,207 35,793 91.5% 380,000

01.310.510 Occupational Priv Tax/Local Svs Tax 7,733 6,455 5,552 6,000 5,772 228 96.2% 50,000

SUBTOTAL - - ACT 511 TAXES 474,267 507,642 525,220 493,000 445,661 47,339 90.4% 489,000





Acct. No. LICENSES AND PERMITS - 320

01.321.320 Junk Yard Permit 100 50 50 100 150 (50) 150.0% 100

01.321.350 Grading Permit 855 4,520 1,000 1,980 (980) 198.0% 1,000

01.321.740 Mechanical Amusement Tax - 500 1,800 (1,300) 360.0% 1,000

01.321.800 Cable TV Franchise Fees 42,663 46,906 49,957 44,000 51,250 (7,250) 116.5% 48,000

01.321.910 Permit-Soliciting 25 25 50 25 25 50.0% 50

01.322.820 Road Encroachment/OW Veh Permits 275 865 1,600 600 1,097 (497) 182.8% 600

01.322.821 Demolition Permit 50 50 50 50 500 (450) 1000.0% 50

01.322.830 Sign Permit 243 50 50 50 - 100.0% 50

SUBTOTAL -- LICENSES/PERMITS 44,211 47,946 56,177 46,350 56,852 (10,502) 122.7% 50,850





Acct. No. FINES & FORFEITS - 330

01.331.100 Fines -- Magistrate Fines 6,114 6,540 4,693 5,000 4,095 905 81.9% 4,000

01.331.130 Fines -- State Dist 6,163 8,156 5,753 5,000 2,722 2,278 54.4% 5,000

SUBTOTAL -- FINES & FORFEITS 12,277 14,696 10,446 10,000 6,817 3,183 68.2% 9,000





Acct. No. INTEREST-RENTS-ROYALTIES - 341

01.341.000 Interest Earned 11,027 25,668 14,901 5,000 4,730 270 94.6% 5,000

01.342.100 Miscellaneous Rents 1,500 1,625 1,250 1,500 1,375 125 91.7% 2,100

SUBTOTAL -- INTEREST EARNINGS 12,527 27,293 16,151 6,500 6,105 395 93.9% 7,100









Page 7

Last Revised: 12/3/2011

UNION TOWNSHIP REVENUE REPORT

BY SOURCE

2010 PROPOSED BUDGET FUND 01 - GENERAL









2006 2007 2008 2009 2009 2009 2009 2010

REVENUE CATEGORY ACTUAL ACTUAL ACTUAL BUDGET Actual Remaining % BUDGET

Thru Nov Thru Dec Thru Nov Proposed

Acct. No. INTERGOVERNMENTAL REVENUE - 350

01.354.010 State Grant 15,000 (15,000) 0 - 0

01.354.010 State Grants - Security Upgrade 5,500 20,000 12,000 12,000 -

01.355.010 Public Utilities Tax 1,433 1,250 1,187 1,000 1,309 (309) 130.9% 1,000

01.355.040 Alcohol Beverage License 650 1,050 850 650 850 (200) 130.8% 850

01.355.050 Gen. Mun. Pension State Aid 13,647 12,825 12,745 12,500 13,908 (1,408) 111.3% 12,500

01.355.070 Foreign Fire Insurance Premium 34,156 34,450 35,283 34,000 31,530 2,470 92.7% 31,000

SUBTOTAL -- STATE SHARED REVENUE 70,386 69,575 35,065 60,150 59,597 553 99.1% 45,350







Acct. No. DEPARTMENTAL EARNINGS - 360

01.361.100 Municipal Lien Letters 3,575 2,450 2,400 1,800 2,400 (600) 133.3% 1,800

01.361.300 Subdivision Fee - 2,275 1,000 1,500 475 1,025 31.7% 1,000

01.361.310 Land Development Fees - 500 - 500

01.361.320 Site Inspections 3,022 3,641 926 1,500 1,500 0.0% 1,000

01.361.330 Variance Fee/Cond. Use 1,810 500 - 500 0.0% 500

01.361.340 Zoning - Hearing Fees 2,225 325 950 950 950 - 100.0% 950

01.361.350 Zoning - Rezoning Fee 950 200 - 200 0.0% 200

01.361.510 Zoning - Sale of Maps 250 20 50 50 0.0% 50

01.361.520 Copies of Ordinances 42 50 - 50 0.0% 50

01.361.530 Sale - Subdivision Book 30 50 - 50 0.0% 50

01.361.540 Departmental - Zoning - 1,225 56 100 200 (100) 200.0% 100

01.361.710 Photocopies of Records 29 60 50 54 50

01.362.410 Permits - Building 49,550 23,277 46,800 25,000 38,558 (13,558) 154.2% 30,000

01.362.420 Permits - Electrical - 3,714 3,194 1,000 3,972 (2,972) 397.2% 2,500

01.362.450 Permit - Use/Occupancy 4,100 4,375 2,650 1,000 2,250 (1,250) 225.0% 1,500

01.362.470 UCC Residential ED Fee 10 280 352 200 380 (180) 190.0% 200

01.364.000 Recycling Containers 245 85 100 100 210 (110) 210.0% 100

01.364.600 Solid Waste Benefit Fee 77,839 75,743 55,180 75,000 55,548 19,452 74.1% 55,000

01.367.400 Recreation Rental Fees 130 335 350 200 900 (700) 450.0% 1,125

SUBTOTAL--DEPARTMENT EARNINGS 143,807 117,725 114,038 109,750 105,897 3,357 96.5% 96,675



Acct. No. WATER - 370

01.378.900 Water Service Fee 297 0 - - #DIV/0! 0

SUBTOTAL - WATER 297 - - - #DIV/0! -







Page 8

Last Revised: 12/3/2011

UNION TOWNSHIP REVENUE REPORT

BY SOURCE

2010 PROPOSED BUDGET FUND 01 - GENERAL









2006 2007 2008 2009 2009 2009 2009 2010

REVENUE CATEGORY ACTUAL ACTUAL ACTUAL BUDGET Actual Remaining % BUDGET

Thru Nov Thru Dec Thru Nov Proposed

Acct. No. MISCELLANEOUS REVENUE - 380

01.380.000 Miscellaneous Revenue 2,726 10,129 2,589 1,000 51 949 5.1% 1,000

01.380.400 Donations 3,039 0 - - #DIV/0! 0

SUBTOTAL MISCELLANEOUS REVENUE 5,765 10,129 5,289 1,000 51 949 5.1% 1,000





Acct. No. OTHER SOURCES - 390

01.391.100 Sale of Assets - 25 2,260 1,000 1,000 0.0% 1,000

01.391.200 Comp. Loss Damage 11,878 0 - - #DIV/0! 0

01.392.000 Transfer from Operating Reserve 7,507 62,000

01.392.000 Transfer-From State Highway Aid - 169,000 - #DIV/0!

01.392.18 Transfer from Cap Imp Fund-Equip Purch 45,000 25,000

01.393.13 Proceeds from Long Term Borrowing 92,042 0 74,000

01.395.000 Refund Prior Year Expenditure 16,791 872 18,348 5,000 28,117 (23,117) 562.3% 5,000

01.395.354 Dividend Workers Comp Trust 18,602 17,490 17,000 15,481 1,519 91.1% 15,000

SUBTOTAL OTHER FINANCING 16,791 38,884 299,140 68,000 68,598 (20,598) 100.9% 157,000

TOTAL REVENUE AND FUND BALANCE 1,169,113 1,215,125 1,466,599 1,194,750 1,147,529 26,725 96.0% 1,251,975









Page 9

Last Revised: 12/3/2011

UNION TOWNSHIP

2010 PROPOSED BUDGET

FUND 35-STATE LIQUID FUELS FUND





2006 2007 2008 2009 2009 2010

REVENUE CATEGORY ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET

Acct. No. Proposed

Beginning Balance: $ 65,207 $ 28,969 $ 15,141 $ 910 $ 910 $ 19,235

35.341.100 Interest $ 4,881 $ 3,791 $ 1,122 $ 329 $ 500 $ 300

35.355.020 Liquid Fuels $ 133,476 $ 135,550 $ 149,286 $ 143,730 $ 143,500 $ 138,000

35.355.051 Turn-Back $ 11,064 $ - $ 4,160 $ 4,160 $ 4,000 $ 4,160

35.395.000 Refund Pr Yr Exp $ 275

Total $ 214,628 $ 168,310 $ 169,984 $ 149,129 $ 148,910 $ 161,695





2006 2007 2008 2009 2009 2010

EXPENSE CATEGORY ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET

Acct. No. Proposed

35.432.245 Winter Materials $ 338 $ - $ - $ - $ -

35437.39 Bank Service Chgs $ 75

35.438.245 Street Materials $ 171,447 $ - $ - $ - $ -

35.439.740 Paving Project $ - $ 157,317 $ 169,000 $ 129,891 $ 147,000 $ 150,000

35.438.740 Vehicle Payment $ 13,874 $ - $ - $ - $ -



Total $ 185,659 $ 157,317 $ 169,075 $ 129,891 $ 147,000 $ 150,000





Balance $ 28,969 $ 10,993 $ 909 $ 19,238 $ 1,910 $ 11,695

UNION TOWNSHIP

2010 PROSED BUDGET

FUND 18 - CAPITAL RESERVE FUND







2007 2008 2009 2009 2010

REVENUE CATEGORY ACTUAL ACTUAL ACTUAL BUDGET BUDGET

Acct. No. Proposed

Available for Appropriation: $ 129,787 $ 114,129 $ 540,190

01.109.920 Reserve Patterson Road $ 17,556 $ 17,377 $ 17,645

30.100.000 Capital Reserve Salt Shed $ 51,682 $ 51,302 $ 76,700

30.100.001 Capital Reserve Equipment Fund $ 60,549 $ 45,450 $ 345,845

30.100.002 Capital Reserve Slide Repair $ - $ 100,000



30.341.100 Interest $ 4,103 $ 2,222 $ 635 $ 300 $ 4,400

30.395.010 Transfer from GL Fund to Equip $ - $ 37,500 $ 300,000

30.395.010 Transfer from GL Fund to Slide Acct $ 100,000

30.130.080 Due from Elrama Sewage Project $ 7,125







Miscellaneous $ - $ -

Total $ 4,103 $ 39,722 $ 530,422 $ 121,554 $ 544,590





2007 2008 2009 2009 2010

EXPENSE CATEGORY ACTUAL ACTUAL ACTUAL BUDGET BUDGET

Acct. No. Proposed

30.409.740 Improvements to Facilities $ -

30.492.010 Transfer to GF Equipment Purchase $ - $ 25,000 $ 45,000 $ 75,000

30.492.010 Transfer to GF Slide Repair Acct

30.230.080 Due to Elrama Sewage for Loan Paymnts $ - $ 7,125





$ -

$ -

Total $ - $ - $ 25,000 $ 52,125 $ 75,000





$ 4,103 $ 39,722 $ 505,422 $ 69,429 $ 469,590





Last Updated: 12/3/2011

UNION TOWNSHIP

2010 PROPOSED BUDGET

FUND 02 - STREET LIGHT FUND







2006 2007 2008 2009 2009 2010

REVENUE CATEGORY ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET

Acct. No. Proposed

02.341.00 Interest 50

02.383.11 Assessments for Street Lighting 11,066 8,873 8,401 8,888 8,500 8,890

-

Total 11,066 8,873 8,401 8,888 8,500 8,940





2007 2008 2009 2009 2010

EXPENSE CATEGORY ACTUAL ACTUAL ACTUAL BUDGET BUDGET

Acct. No. Proposed

2.403.001 Commission Tax Collector 209 222 225

02.434.001 Electric Street Lights 13,532 12,296 13,039 13,273 13,000 10,500

02.492.01 Due to Gen Fund 2009 - 10,500 13,275

-

-

-

Total 13,532 12,296 13,248 23,500 24,000





Balance (2,466) (3,423) (4,847) (15,000) (15,060)









Last Updated: 12/3/2011

UNION TOWNSHIP

2010 PROPOSED BUDGET

FUND 08 - ELRAMA SEWAGE FUND







2009 2009 2009 2010

REVENUE CATEGORY ACTUAL Projected BUDGET BUDGET

Acct. No. Proposed



08.130.18 Loan from Cap Proj for Loan 22630 Payments $ 7,125

08.341.00 Interest $ 100 $ 100

08.351.04 Grant-Fed Army Corp $ 1,000,000 $ 1,000,000 $ 1,000,000

08.354.04 Pennvest Loan/Grant, Other PA Grants $ 2,233,119 $ 2,679,673 $ 2,980,292

08.364.11 Sewage Charges (240 EDUs x$60 x12 mos)-5% Delinq $ 72,000 $ 164,160

08.383.10 Tap Fees-Construction $ 202,000 $ 225,000 $ 240,000 $ 15,000









Total $ 3,435,119 $ 3,904,673 $ 4,299,517 $ 179,260





2009 2010

EXPENSE CATEGORY BUDGET BUDGET

Acct. No. Proposed



08.429.00 Sewage Treatmnt--WESA (240 EDUs x$20 x12 mos) $ 24,000 $ 57,600

08.429.00 O & M Costs $ 18,000 $ 37,128

08.429.60 Sewage System Construction $ 3,284,263 $ 3,863,835 $ 4,220,292

08.470.00 Debt Service Pennvest Loan $ 15,036 $ 17,100 $ 29,500 $ 75,393

08.230.18 Due to Cap Proj Repay Loan $ 7,125





Total $ 3,299,299 $ 3,880,935 $ 4,298,917 $ 170,121





Balance $ 135,820 $ 23,738 $ 600 $ 9,139









Last Updated: 12/3/2011

11/23/09 UNION TOWNSHIP FUND 01 - GENERAL FUND

AS ADVERTISED 2010 PROPOSED BUDGET









FUND 01

SUMMARY OF REVENUE AND EXPENSE CATEGORIES

Actual Actual Actual Budget Budget Actual Actual Actual Budget Budget 08-09

REVENUES 2006 2007 2008 2009 2010 xxx EXPENSES 2006 2007 2008 2009 2010 Diff





01.301 Real Estate Tax 388,785 381,235 405,073 400,000 396,000 01.400 Gl Govt-Admin $ 167,370 $ 213,166 $ 206,085 $ 253,985 $ 283,235 11.5%

01.310 Act 511 Taxes 474,267 507,642 525,220 493,000 489,000 01.410 Police Dept $ 5,000 $ 8,843 $ 73,941 $ - $ - #DIV/0!

01.321 Licnse/Permits 44,211 47,946 56,177 46,350 50,850 01.411 Fire Dept $ 66,735 $ 95,474 $ 88,187 $ 100,750 $ 94,750 -6.0%

01.331 Fines/Forfeits 12,277 14,696 10,446 10,000 9,000 01.414 Code/Zoning $ 27,540 $ 53,917 $ 39,507 $ 88,850 $ 62,600 -29.5%

01.341 Interest/Rents 12,527 27,293 16,151 6,500 7,100 01.430 Public Works $ 398,840 $ 471,224 $ 794,168 $ 621,000 $ 662,250 6.6%

01.355 Intergoverntl 70,386 69,575 35,065 60,150 45,350 01.450 Recreation $ 4,153 $ 3,932 $ 6,006 $ 8,900 $ 9,500 6.7%

01.470 Debt Service $ 46,119 $ 1,655 $ 1,075 $ 27,850 $ 50,240 80.4%

01.362 Dept. Earnings 144,104 117,725 114,038 109,750 96,675 01.480 Misc. Expense $ 2,001 $ 400 $ 1,443 $ 3,000 $ 2,000 -33.3%

01.364 Misc. Revenue 5,765 10,129 5,289 1,000 1,000 01.485 Insurance $ 40,841 $ 46,099 $ 40,035 $ 45,100 $ 43,000 -4.7%

01.391 Interfund Transf 16,791 38,884 299,140 68,000 157,000 01.487 Emply Benefits $ 34,610 $ 35,374 $ 39,220 $ 44,150 $ 42,350 -4.1%

01.495 Other Uses $ 266,271 $ - $ 38,325 $ 250 $ 250 0.0%









TOTAL 1,169,113 1,215,125 1,466,599 1,194,750 1,251,975 TOTAL $ 1,059,480 $ 930,084 $ 1,327,992 $ 1,193,835 $ 1,250,175 4.7%









Year Revenues - Expenses $$ +(-)

Actual 2006 1,169,113 (1,059,480) 109,633

Actual 2007 1,215,125 (930,084) 285,041

Actual 2008 1,466,599 (1,327,992) 138,607

Budget 2009 1,194,750 (1,193,835) 915

Actual 11/16/2009 1,147,529 (796,352) 351,177

Budget 2010 1,251,975 (1,250,175) 1,800









Last Updated: 12/3/2011

2010 PROPOSED BUDGET

TOTAL ALL FUNDS





Total All Funds General Fund State Fund Elrama Sewage Street Light Oper

Cap Reserve Fund

Reserve

Cash Balance on Hand 1-1-10 1,315,324 284,000 19,235 540,190 91,603 3,333 376,963









REVENUES

300.00 TAXES 885,000 885,000

320.00 LIC & PERMITS 50,850 50,850

330.00 FINES 9,000 9,000

340.00 INTEREST 13,850 7,100 300 4,000 100 50 2,300

350.00 INTERGOVT REV 187,510 45,350 142,160

360.00 CHGS FOR SERVICE 260,835 96,675 164,160

380.00 MISCELLANEOUS 24,890 1,000 15,000 8,890

390.00 OTHER FINANCING/REFUNDS 157,000 157,000

TOTAL REVENUES 1,588,935 1,251,975 142,460 4,000 179,260 8,940 2,300



TOT CASH ON HAND + REV 2,904,259 1,535,975 161,695 544,190 270,863 12,273 379,263



EXPENDITURES

400.00 GENERAL GOVT 345,460 283,235 225 62,000

410.00 PUBLIC SAFETY 157,350 157,350

429.00 PUBLIC WORKS-SANITATION 95,728 1,000 94,728

430.00 HIGHWAY/ROADS 899,525 661,250 150,000 75,000 13,275

450.00 CULTURE & REC 9,500 9,500

470.00 DEBT SERVICE 125,633 50,240 75,393

480.00 INSURANCE AND MISC EXP 87,350 87,350

490.00 OTHER FINANCING/REFUNDS 10,750 250 10,500

TOTAL EXPENDITURES 1,731,296 1,250,175 150,000 75,000 170,121 24,000 62,000

0

REVENUE OVER EXPENDITURES -142,361 1,800 -7,540 -71,000 9,139 -15,060 -59,700

0

BALANCE ON HAND 12-31-10 1,172,963 285,800 11,695 469,190 100,742 -11,727 317,263