Docstoc

2009_operating_budget_worksheet

Document Sample
2009_operating_budget_worksheet Powered By Docstoc
					2009 OPERATING BUDGET WORKSHEET

                                                                                                            Explanations
                                                2007             2008           2008          2009         for significant
                                               ACTUAL           BUDGET         ACTUAL        BUDGET          variances
COUNCIL
WAGES                                             (54,325)          60,000        57,535        60,000

EARLY RETIREMENT INCENTIVE

PENSION                                            (6,681)           8,400         7,927         8,400

HEALTH INSURANCE                                   (6,919)           8,100         9,256         8,100

LIFE INSURANCE                                          (121)            130        121            130

WORKERS COMPENSATION                               (1,803)           2,200          884          2,200

DENTAL INSURANCE                                        (300)            350        312            350

MEDICARE                                                (756)            825        799            825


RECRUITMENT & TESTING
TOTAL PERSONAL SERVICES                           (70,905)          80,005        76,834        80,005

TRAVEL & TRAINING                                  (2,903)           5,000         3,784         5,000
TOTAL GENERAL OPERATING                            (2,903)           5,000         3,784         5,000

OTHER CONTRACTUAL SERVICES                              (165)                                    4,000 Denise - Records

UTILITIES                                               -                -              -             -

RENTS & LEASES

PROFESSIONAL SERVICES                             (26,386)          48,523        38,896        44,000 Legal expenses

INSURANCE

MAINTENANCE OF EQUIPMENT                                (500)        1,000          850          1,000 copier

POSTAGE                                            (1,066)           1,000              24         500

MEMBERSHIPS                                        (5,026)           4,450         5,022         5,000


TELEPHONE                                               (465)            650        762            600

MAINTENANCE OF FACILITY                                 -                -              -             -

PRINTING                                          (11,612)           4,500         2,322         4,500

ADVERTISING                                       (10,700)          27,000        15,870        17,000


HARDWARE/SOFTWARE SUPPORT                             (92)           3,500         3,932         3,500
TOTAL CONTRACTUAL SERVICES                        (56,012)          90,623        67,678        80,100

OFFICE SUPPLIES                                         (650)        1,000          931            700

OPERATING SUPPLIES                                 (1,864)           1,500         1,540         2,000

VEHICLE PARTS                                           -                -              -             -

BOOKS & PUBLICATIONS                                    (194)       12,250          209         12,000 codified ordinances

OFFICE EQUIPMENT                                   (2,548)           1,200          607          1,700

SPECIAL EVENTS                                     (2,646)           3,000         2,964         2,500

SAFETY EQUIPMENT                                     -                 -              -             -
TOTAL MATERIALS & SUPPLIES                         (7,902)          18,950         6,251        18,900

LAND & BUILDINGS                                        -                -              -             -

CAPITAL EQUIPMENT                                                    2,000         1,888

PUBLIC WORKS                                                       100,000             -        50,000 Visioning/Planning
TOTAL CAPITAL OUTLAY                                        -      102,000         1,888        50,000

DEBT SERVICE                                            -                -              -             -
                                                                                                      -
TRANSFERS                                         (47,796)               -              -             -


19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                              Page 1
2009 OPERATING BUDGET WORKSHEET

                                                                                              Explanations
                                                2007         2008        2008       2009      for significant
                                               ACTUAL       BUDGET      ACTUAL     BUDGET       variances
TOTAL COUNCIL                                   (137,722)     194,578    154,547    234,005




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                Page 2
2009 OPERATING BUDGET WORKSHEET

                                                                                                                                 Explanations
                                                2007                2008              2008                  2009                 for significant
                                               ACTUAL              BUDGET            ACTUAL                BUDGET                  variances


MAYOR
WAGES                                             (35,122)             39,580                39,737                45,000


PENSION                                            (4,346)              6,220                  5,886                 6,525

HEALTH INSURANCE

LIFE INSURANCE                                              (61)                80                    61                    80

WORKERS COMPENSATION                               (1,387)              1,462                     680                1,460

DENTAL INSURANCE                                        (300)               400                   312                   400

UNIFORMS                                                -                   -                         -                     -

MEDICARE                                                (471)               525                   530                   655

                                                                                                 -                     -
RECRUITMENT & TESTING                                -                    -                      -                     -
TOTAL PERSONAL SERVICES                           (41,687)             48,267                47,206                54,120

TRAVEL & TRAINING                                  (1,550)              1,800                  1,012                 1,800
TOTAL GENERAL OPERATING                            (1,550)              1,800                  1,012                 1,800


MEMBERSHIPS                                                 (75)            150                       75                100


TELEPHONE                                                                                         102                   250


HARDWARE/SOFTWARE SUPPORT                               (844)           1,200                  1,682
TOTAL CONTRACTUAL SERVICES                              (919)           1,350                  1,859                    350

OFFICE SUPPLIES                                         (152)               200                       49                150

OPERATING SUPPLIES                                      (287)               630                   496                   500

BOOKS & PUBLICATIONS                               (1,048)              1,744                  1,679                 1,500

OFFICE EQUIPMENT                                                                                  277

SAFETY EQUIPMENT                                     -                    -                         -                     -
TOTAL MATERIALS AND SUPPLIES                       (1,487)              2,574                  2,501                 2,150
LAND & BUILDINGS                                     -                    -          ..............        ..............

CAPITAL EQUIPMENT                                       -                   -        ..............        ..............

REFUNDS & REIMBURSEMENTS

TOTAL MAYOR                                      (42,669)             48,843              47,576                58,420




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                   Page 3
2009 OPERATING BUDGET WORKSHEET

                                                                                                                 Explanations
                                                2007             2008              2008          2009            for significant
                                               ACTUAL           BUDGET            ACTUAL        BUDGET             variances


ADMINISTRATION
WAGES                                             (52,381)          82,000           64,856        82,000

OVERTIME                                                                                   39

PART-TIME WAGES

EARLY RETIREMENT INCENTIVE                        (10,708)          10,000            4,240                   paid out '08


PENSION                                            (7,100)          10,750           11,309        12,000

HEALTH INSURANCE                                   (7,398)          15,500            6,627         8,500

LIFE INSURANCE                                          (363)            450           306           450

WORKERS COMPENSATION                               (4,438)           3,750            2,177         3,750

DENTAL INSURANCE                                        (605)            850           718           850

MEDICARE                                                (736)        1,200             916          1,200

OTHER PERSONAL SERVICES                                 (500)            -                 -             -

OTHER PERSONAL SERVICES                                                                609

PRE-EMPLOYMENT PHYSICALS                                (232)            500               39        500 ?

WELLNESS ACTIVITIES                                (1,000)           1,000            1,180         1,000

UNEMPLOYMENT COMPENSATION                               -                -                 -             -

RECRUITMENT & TESTING                                -                 -                 -             - add 3%
TOTAL PERSONAL SERVICES                           (85,461)         126,000           93,016       110,250 +3310

TRAVEL & TRAINING                                  (2,575)           3,500            1,465         2,000
TOTAL GENERAL OPERATING                            (2,575)           3,500            1,465         2,000

RETAINER (CITY TAX-RITA)                          (40,709)          40,000           48,950        48,000

OTHER CONTRACTUAL SERVICES                                                                                    Storm related



PROFESSIONAL SERVICES                             (14,973)          18,826           20,367        15,000 Legal

INSURANCE                                         (18,375)          18,000            4,623         5,000 Reduction in prem.

MAINTENANCE OF EQUIPMENT                           (1,266)           1,000             850          1,000 copiers

POSTAGE                                                 (103)            100           335           250

MEMBERSHIPS                                        (4,812)           4,000            2,090         2,500


TELEPHONE                                          (3,202)           6,200            4,890         6,200

MAINTENANCE OF FACILITY                                 -                -                 -             -
                                                                                           -             -
PRINTING                                                (696)

ADVERTISING                                                                  63            27            50

VEHICLE MAINTENANCE                                     (318)            300                         300


HARDWARE/SOFTWARE SUPPORT                          (4,992)           6,000            8,589         6,000
TOTAL CONTRACTUAL SERVICES                        (89,446)          94,489           90,721        84,300




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                   Page 4
2009 OPERATING BUDGET WORKSHEET

                                                                                                                  Explanations
                                                2007                2008           2008         2009              for significant
                                               ACTUAL              BUDGET         ACTUAL       BUDGET               variances


OFFICE SUPPLIES                                         125                 300        252          300

OPERATING SUPPLIES                                      (937)           1,000         1,704        1,500

VEHICLE PARTS                                               (72)            100                     100

BOOKS & PUBLICATIONS                                    (482)               500        182          100

SERVICE CHARGE                                                          1,300         2,834         600

OFFICE EQUIPMENT                                        (569)                          405          500

FUEL                                                    (578)           1,150          946         1,000

TOOLS                                                   -                   -              -            -

SPECIAL EVENTS                                      (1,147)                 350       1,142         350 Cash - Emerg. Items
                                                                                                            for Wind Storm
SAFETY EQUIPMENT                                        -                   -              -            -

FLEET: SUPPLIES & EQUIPMENT                           -                   -              -            -
TOTAL MATERIALS & SUPPLIES                          (3,660)             4,700         7,465        4,450

LAND & BUILDINGS

CAPITAL EQUIPMENT                                                       8,000         1,828          -      Computer upgrade


PUBLIC WORKS                                                          100,000        12,439          -      phone system upgrade
TOTAL CAPITAL OUTLAY                                                  108,000        14,267          -


TRANSFERS                                       (1,133,418)                 -              -            -   n/a see 101-1009
KWH TAX - TRANSFER TO ELECTRIC FUND                   -                     -                               n/a


TOTAL ADMINISTRATION                            (181,142)            228,689       192,667      201,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                    Page 5
2009 OPERATING BUDGET WORKSHEET

                                                                                                                 Explanations
                                                2007                2008              2008          2009         for significant
                                               ACTUAL              BUDGET            ACTUAL        BUDGET          variances


AUDITOR

PROFESSIONAL SERVICES                             (11,000)             12,500           11,250        12,500

AUDITOR & TREAS. FEES                             (18,462)             18,500           17,433        18,500

ELECTION EXPENSE                                   (1,010)              2,400            3,264         3,300

STATE EXAMINER'S COMP.                                  -                   -                 -             -

COUNTY HEALTH DEPT.                                (9,870)             10,000            9,515        10,000

ADVERTISING DEL. TAX LISTS                                  (62)                75            74            75

10% ROLLBACK                                            -                   -                 -             -
                                                                                              -             -
HOMESTEAD                                               -                   -                 -             -
                                                                                              -             -
                                 2.50%                  -                   -                 -             -

DELIQUENT COLLECTION COSTS                         (1,572)              1,500            2,487         2,500

TELEPHONE                                            -                    -                 -             -
TOTAL CONTRACTUAL SERVICES                        (41,976)             44,975           44,023        46,875
TOTAL AUDITOR                                    (83,952)             89,950           88,046         46,875




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                   Page 6
2009 OPERATING BUDGET WORKSHEET

                                                                                                               Explanations
                                                2007                2008           2008         2009           for significant
                                               ACTUAL              BUDGET         ACTUAL       BUDGET            variances


PROPERTY RENTAL (Train Station/Sutton Farm)

RENTS & LEASES                                              (24)            -              -            -
                                                                                                        -
INSURANCE                                               -                   -              -            -

MAINTENANCE OF EQUIPMENT                                -                   650       1,474         650

TREE TRIMMING/LINE CLEARING/LANDSCAPIN                  -                   -              -            -

ELECTRIC                                           (2,446)              2,800         3,268        3,000

MAINTENANCE OF FACILITY                            (3,626)              6,800         9,995        7,500

ADVERTISING                                             -                   -              -            -

NATURAL GAS                                        (1,007)              2,000         2,659        3,000

PROPERTY TAX                                       (6,283)              6,300         6,395        9,495
TOTAL CONTRACTUAL SERVICES                        (13,386)             18,550        23,791       23,645

LAND & BUILDINGS                                        -                   -              -            -

CAPITAL EQUIPMENT                                       -                   -              -            -
                                                                                                            hvac train station
PUBLIC WORKS                                                            3,450                      3,898 security camera - FARM
TOTAL CAPITAL OUTLAY                                                    3,450                      3,898

TOTAL PROPERTY RENTAL                            (13,386)             22,000        23,791       27,543




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                 Page 7
2009 OPERATING BUDGET WORKSHEET

                                                                                                              Explanations
                                                2007             2008           2008             2009         for significant
                                               ACTUAL           BUDGET         ACTUAL           BUDGET          variances


LIBRARY

MAINTENANCE OF EQUIPMENT                           (1,513)           3,000         1,984            3,000
                                                                                                       -
TREE TRIMMING/LINE CLEARING/LANDSCAPIN                  (600)            500            -             500
                                                                                                       -
MAINTENANCE OF FACILITY                            (4,688)           5,000         4,363            5,000

PRINTING                                                -                -              -                -

LICENSE & PERMITS                                    -                 -              -                -
TOTAL CONTRACTUAL SERVICES                         (6,801)           8,500         6,347            8,500


OPERATING SUPPLIES                                      -                -                  7             -

BOOKS & PUBLICATIONS                                    -                -              -                -
                                                                                            7

LAND & BUILDINGS

CAPITAL EQUIPMENT

PUBLIC WORKS                                                        30,230         7,850              -
TOTAL CAPITAL OUTLAY                                                30,230         7,850              -

TOTAL LIBRARY                                     (6,801)          38,730        14,204            8,500




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                Page 8
2009 OPERATING BUDGET WORKSHEET

                                                                                                             Explanations
                                                2007             2008           2008             2009        for significant
                                               ACTUAL           BUDGET         ACTUAL           BUDGET         variances


CABLE TV

PROFESSIONAL SERVICES                                   -                150                -        150
                                                                                                      -
INSURANCE                                               -                -              -             -
                                                                                                      -
MAINTENANCE OF EQUIPMENT                                -                150        358              400
TOTAL CONTRACTUAL SERVICES                                               300        358              550

OPERATING SUPPLIES                                      (655)        1,000          542              700

BOOKS & PUBLICATIONS                                    -                -              -                -
                                                                                        -
OFFICE EQUIPMENT                                        -                -              -                -

SAFETY EQUIPMENT                                         -             -             -                -
TOTAL MATERIALS AND SUPPLIES                            (655)        1,000          542              700

CAPITAL EQUIPMENT                                       -                -                  -        -
TOTAL CAPITAL OUTLAY                                                                                 -

TOTAL CABLE TV                                      (655)           1,300          900             1,250




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                               Page 9
2009 OPERATING BUDGET WORKSHEET

                                                                                             Explanations
                                                2007     2008        2008        2009        for significant
                                               ACTUAL   BUDGET      ACTUAL      BUDGET         variances


TRANSFERS
TRANSFERS FROM GENERL FUND                              1,520,617   1,520,617    977,384   CONTINGENT ON CAPITAL




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                               Page 10
2009 OPERATING BUDGET WORKSHEET

                                                                                                            Explanations
                                                2007             2008           2008          2009         for significant
                                               ACTUAL           BUDGET         ACTUAL        BUDGET           variances


PUBLIC SAFETY
WAGES                                             (455,616)        520,000       454,069       520,000                15600


OVERTIME                                           (29,377)         60,000        63,862        60,000                    1800


HOLIDAYS                                           (17,242)         21,500        18,899        21,500                    645


PART-TIME WAGES                                   (148,592)        160,100       153,926       165,000                    4950


EARLY RETIREMENT INCENTIVE                         (32,382)         39,550        31,620         7,905

PENSION                                            (27,559)         43,000        32,950        43,000                    1290


HEALTH INSURANCE                                  (113,419)        145,000       170,262       145,000                    4350


LIFE INSURANCE                                      (1,293)          1,500         1,302         1,500                       45


WORKERS COMPENSATION                               (28,431)         30,000        13,944        30,000                    900


DENTAL INSURANCE                                    (6,366)          9,000         8,004         9,000                    270


UNIFORMS                                            (7,940)          6,500         6,461         7,900 replace 4 sets bdy armr.

MEDICARE                                            (5,778)          6,350         6,654         6,350                 190.5


OTHER PERSONAL SERVICES                                                  -              67            -

PRE-EMPLOYMENT PHYSICALS                                (467)            500        179            500

WELLNESS ACTIVITIES                                                      100            -          400 departmental mtgs planned

UNEMPLOYMENT COMPENSATION                                (17)        1,000          862          1,000                       30


RECRUITMENT & TESTING                               (1,073)              -              -        1,000 poss dispatch hiring

POLYGRAPHS                                                           1,000              -        1,200 cost of 2 polygraphs

PSYCHOLOGICAL EXAMS                                                   2,000          720          2,000
TOTAL PERSONAL SERVICES                           (875,552)       1,047,100      963,781      1,023,255             30070.5


TRAVEL & TRAINING                                   (1,502)          4,500         4,327         5,800 increase mand. Train.
TOTAL GENERAL OPERATING                             (1,502)          4,500         4,327         5,800




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                              Page 11
2009 OPERATING BUDGET WORKSHEET

                                                                                                                    Explanations
                                                2007                2008              2008          2009            for significant
                                               ACTUAL              BUDGET            ACTUAL        BUDGET             variances


OTHER CONTRACTUAL SERVICES                         (2,616)              2,700            2,073              -    Storm related


UTILITIES                                               -                   -                 -             -

RENTS & LEASES                                     (1,571)              2,500            2,105         2,500

PROFESSIONAL SERVICES                                   (667)           3,500            2,691         3,500

INSURANCE                                               -              10,000           10,000        10,000

MAINTENANCE OF EQUIPMENT                           (2,163)              2,500            1,381         2,500

POSTAGE                                                     (42)                50            38            65

MEMBERSHIPS                                             (350)               350           300         10,850 includes ACE fees, offset by drug se

PRISONER CARE                                      (7,102)              3,000            2,480         3,500 fee increase for 2009

GREENE COUNTY PARK DISTRICT                             -                   -                 -             -

GREENE CENTRAL 911 DISPATCHING                    (11,437)             17,000           15,276        34,000 fees doubling for 2009

XENIA MUNICIPAL COURT CHARGES                      (1,235)              1,500             496          1,750 court fee increase

PRIVATE SECURITY                                        -                   -                 -             -

CISCO SOFTWARE SUPPORT                             (2,483)              2,500            2,483              -    dropped program


MIAMI VALLEY REGIONAL CRIME LAB                    (3,500)              3,500            3,500         3,600 slight increase

ELECTRIC                                                (389)               400               79         400

WATER                                                   -                   -                 -             -

SEWER                                                   -                   -                 -             -

TELEPHONE                                          (6,184)              9,800            9,071         9,800

MAINTENANCE OF FACILITY                                 (773)           1,000             168          1,200

PRINTING                                                -               1,727            1,844         2,000 replace bus cards, forms signs, misc

ADVERTISING                                                 (34)            100               -          250

VEHICLE MAINTENANCE                               (12,502)              8,000            7,353         7,500

LICENSE & PERMITS                                            (5)            -                 -             -

NATURAL GAS                                             -                   -                 -             -

ANIMAL CONTROL                                     (7,350)              7,500            7,350         8,000 unk 2009 increase

HARDWARE/SOFTWARE MAINTENANCE                           (963)           1,500            1,218         4,000 new system in pd, new software syst

LEGAL SERVICES                                       -                    -                 -             -
TOTAL CONTRACTUAL SERVICES                        (61,366)             79,127           69,906       105,415




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                      Page 12
2009 OPERATING BUDGET WORKSHEET

                                                                                                                   Explanations
                                                2007                2008              2008         2009           for significant
                                               ACTUAL              BUDGET            ACTUAL       BUDGET            variances


OFFICE SUPPLIES                                     (1,745)             2,000             1,499        2,500

OPERATING SUPPLIES                                  (3,560)             3,500             3,684        3,500

VEHICLE PARTS                                       (1,548)             3,000             1,981        3,800 3 sets of tires for 2009

BOOKS & PUBLICATIONS                                        (75)            250            178           450 new code books

COATS FUND                                              -                   -                 -            -   has own fund now


OFFICE EQUIPMENT                                    (1,978)             1,500             1,122        2,500 replace dispatch chair

FUEL                                               (17,718)            31,500            27,450       31,500

TOOLS                                                       (40)                50            -          250 replace lockout tools

SPECIAL EVENTS                                      (2,220)             2,773             3,022        3,500

SAFETY EQUIPMENT                                        (306)               -                 -          440 replace safety vests

FLEET: SUPPLIES & EQUIPMENT                                               -                  -            -
TOTAL MATERIALS AND SUPPLIES                       (29,190)            44,573            38,936       48,440

LAND & BUILDINGS                                        -                   -                 -            -

CAPITAL EQUIPMENT                                  (38,502)            15,000            12,002       80,349 see capital equip.
TOTAL CAPITAL OUTLAY                               (38,502)            15,000            12,002       80,349
TRANSFERS                                             -                   -                  -            -
TOTAL PUBLIC SAFETY                            (1,006,112)         1,190,300         1,088,952    1,263,259




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                    Page 13
2009 OPERATING BUDGET WORKSHEET

                                                                                                              Explanations
                                                2007             2008              2008          2009         for significant
                                               ACTUAL           BUDGET            ACTUAL        BUDGET          variances


PLANNING
WAGES                                              (57,225)         86,250           23,310        86,250                2587.5


OVERTIME                                                                               795          1,000                       30


PART-TIME                                          (21,798)         18,000           14,807           -

EARLY RETIREMENT INCENTIVE                          (8,986)         22,500           17,971         4,493

PENSION                                            (10,264)         14,595            5,918        14,595                437.85


HEALTH INSURANCE                                    (2,644)          6,400             591          6,400                   192


LIFE INSURANCE                                          (151)            250               71        250                     7.5


WORKERS COMPENSATION                                (2,982)          2,500            1,462         2,500                       75


DENTAL INSURANCE                                        (136)            600               70        600                        18


MEDICARE                                            (1,065)              900           563           900                        27


OTHER PERSONAL SERVICES

PRE-EMPLOYMENT PHYSICALS

WELLNESS ACTIVITIES

UNEMPLOYMENT COMPENSATION

RECRUITMENT & TESTING
TOTAL PERSONAL SERVICES                           (105,251)        151,995           65,558       116,988              3374.85


TRAVEL & TRAINING                                       (244)        2,500             554          2,500 ?
TOTAL GENERAL OPERATING                                 (244)        2,500             554          2,500

OTHER CONTRACTUAL SERVICES

UTILITIES

PROFESSIONAL SERVICES                              (60,696)         65,000           44,240        75,000

MAINTENANCE OF EQUIPMENT                                (500)            500           850           500

POSTAGE                                                                  -                 46            80

MEMBERSHIPS                                             (602)            500           353           500


TELEPHONE                                               (319)            450           319           450

MAINTENANCE OF FACILITY                                  (70)            -                 -              -

PRINTING                                                                 500               -         500

ADVERTISING                                                              350               -          -

LICENSE & PERMITS                                                        -                 -              -

NATURAL GAS                                                              -                 -             -

HARDWARE/SOFTWARE SUPPORT                                              300               61           300
TOTAL CONTRACTUAL SERVICES                         (62,187)         67,600           45,869        77,330

OFFICE SUPPLIES                                         (381)            400           407           500

OPERATING SUPPLIES                                      (294)            300           516           600 Need digital camera

BOOKS & PUBLICATIONS                                    (355)            400           195           400

OFFICE EQUIPMENT                                                         200               -         200

FUEL                                                    (106)            200               -         200

TOOLS                                                                        50            20        100 need wheel, pinlocator

SAFETY EQUIPMENT                                                        50               -             50
TOTAL MATERIALS AND SUPPLIES                        (1,136)          1,600            1,138         2,050


19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                Page 14
2009 OPERATING BUDGET WORKSHEET

                                                                                                         Explanations
                                                2007            2008         2008         2009          for significant
                                               ACTUAL          BUDGET       ACTUAL       BUDGET            variances
CAPITAL EQUIPMENT

PUBLIC WORKS                                                       42,500            -      45,000 sidewalk prog., biketrail mtce.
TOTAL CAPITAL OUTLAY                                               42,500                   45,000

REFUNDS & REIMBURSEMENTS                                (35)                                   100

TOTAL PLANNING                                  (168,853)        266,195     113,119      243,968




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                           Page 15
2009 OPERATING BUDGET WORKSHEET

                                                                                                                        Explanations
                                                2007             2008              2008               2009              for significant
                                               ACTUAL           BUDGET            ACTUAL             BUDGET               variances


MEDIATION

PROFESSIONAL SERVICES                              (6,500)           6,500                  6,000              6,500

POSTAGE

MEMBERSHIPS                                                                  35                115                115

TELEPHONE                                               (927)        1,050                  1,006              1,135


OFFICE SUPPLIES                                      -                 -          ..............     ..............
TOTAL CONTRACTUAL SERVICES                         (7,427)           7,585                  7,121              7,750

OPERATING SUPPLIES                                      (108)
TOTAL MATERIALS AND SUPPLIES                            (108)
TRANSFERS OUT                                            -               -        ..............     ..............
TOTAL MEDIATION                                   (7,535)           7,585                 7,121              7,750




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                          Page 16
2009 OPERATING BUDGET WORKSHEET

                                                                                                 Explanations
                                                2007          2008        2008        2009       for significant
                                               ACTUAL        BUDGET      ACTUAL      BUDGET        variances


TOTAL GENERAL FUND                             (1,635,225)   3,531,327   3,223,132   3,069,954




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                   Page 17
2009 OPERATING BUDGET WORKSHEET

                                                                                                             Explanations
                                                2007             2008              2008          2009        for significant
                                               ACTUAL           BUDGET            ACTUAL        BUDGET         variances




STREET MAINTENANCE/REPAIR
WAGES                                             (129,354)        139,500          124,474       139,500                  4185


OVERTIME                                            (6,896)         10,000           12,195        10,000                  300
                                                                                                                               0
EARLY RETIREMENT INCENTIVE                         (16,064)         16,000            6,383              -

PENSION                                            (17,185)         19,750           19,750        19,750                592.5


HEALTH INSURANCE                                   (20,720)         25,000           26,961        25,000                  750


LIFE INSURANCE                                          (315)            350           315           350                   10.5


WORKERS COMPENSATION                                (5,964)          6,500            2,925         6,500                  195


DENTAL INSURANCE                                    (1,459)          2,000            1,936         2,000                      60


UNIFORMS                                                (745)        1,025             652          1,025

MEDICARE                                            (1,420)          1,750            1,429         1,750                  52.5


OTHER PERSONAL SERVICES                                 -                -                 -             -

PRE-EMPLOYMENT PHYSICALS                                (116)            250               58        250

WELLNESS ACTIVITIES                                     -                    50            -             -

UNEMPLOYMENT COMPENSATION                               -            1,050             617          1,050                  31.5


RECRUITMENT & TESTING                                 -                -                 39            -
TOTAL PERSONAL SERVICES                           (200,238)        223,225          197,734       207,175                  6177


TRAVEL & TRAINING                                       (185)            650           543           750
TOTAL GENERAL OPERATING                                 (185)            650           543           750




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                               Page 18
2009 OPERATING BUDGET WORKSHEET

                                                                                                                                       Explanations
                                                2007                2008              2008                     2009                    for significant
                                               ACTUAL              BUDGET            ACTUAL                   BUDGET                     variances


OTHER CONTRACTUAL SERVICES                              (425)               500              26,277                        500 Storm related to date

UTILITIES                                               -                   -                         -                        -

RENTS & LEASES                                      (2,441)             2,500                  1,155                    2,500

PROFESSIONAL SERVICES                              (10,024)            17,024                  4,844                    5,000

INSURANCE                                           (3,446)             3,500                  3,500                    3,500

MAINTENANCE OF EQUIPMENT                            (1,881)             5,000                     291                   5,000

POSTAGE                                                 (210)               -                         -                        -

MEMBERSHIPS                                                 (30)                30                    -                        -

TREE TRIMMING/LINE CLEARING/LANDSCAPIN              (1,550)             2,500                  1,270                    2,500

SOLID WASTE                                                 (31)                50                    -                        -

ELECTRIC                                            (1,743)             2,000                  1,822                    2,000

WATER                                                   -                   -                         -                        -

SEWER                                                   -                   -                         -                        -

TELEPHONE                                               (588)               650                   821                      800

MAINTENANCE OF FACILITY                            (12,395)            12,000                     740                 10,000

PRINTING                                                -                   -                         -                        -

ADVERTISING                                             154                 -                         -                        -

VEHICLE MAINTENANCE                                 (4,499)            11,244                13,719                   10,000

LICENSE & PERMITS                                       -                   -                         -                        -

NATURAL GAS                                         (1,101)             1,600                  1,523                    1,800

PROPERTY TAX                                            -                   -        ..............           ..............

HARDWARE/SOFTWARE MAINTENANCE                         -                   600                    -                        -
TOTAL CONTRACTUAL SERVICES                         (40,210)            59,198                55,962                   43,600

OFFICE SUPPLIES                                             (21)            100                       27                   100

OPERATING SUPPLIES                                 (37,849)            37,600                40,605                   40,000

VEHICLE PARTS                                       (2,658)             3,000                  2,638                    3,000

BOOKS & PUBLICATIONS                                    -                   -                         -                        -

OFFICE EQUIPMENT                                        -                   -                         -                        -

FUEL                                                (4,082)             7,500                  6,736                    7,500

TOOLS                                                   (909)           1,000                     513                   1,000

SPECIAL EVENTS                                              (16)                50                    43                       50

SAFETY EQUIPMENT                                    (1,026)             1,000                     452                   1,000

FLEET: SUPPLIES & EQUIPMENT                         (1,070)             1,500                 1,248                    1,000
TOTAL MATERIALS AND SUPPLIES                       (47,631)            51,750                52,262                   53,650

LAND & BUILDINGS                                        -                   -                             -
                                                                                                                     26,150         Dump Truck
CAPITAL EQUIPMENT                                   (9,013)           102,652                78,167                   8,948         Trailer, snowblower, 1-lane paver
                                                                                                                     20,000         Northern Gateway
PUBLIC WORKS                                      (560,270)           845,675              373,631                  350,000         Road resurfacing
TOTAL CAPITAL OUTLAY                              (569,283)           948,327              451,798                  405,098

DEBT SERVICE                                            -                   -        ..............           ..............

REFUNDS & REIMBURSEMENTS                                -                   -        ..............           ..............
TOTAL STREET MAINTENANCE & REP                  (857,547)          1,283,150            758,299                  710,273

19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                         Page 19
2009 OPERATING BUDGET WORKSHEET

                                                                                                                         Explanations
                                                2007             2008           2008                 2009                for significant
                                               ACTUAL           BUDGET         ACTUAL               BUDGET                 variances
STATE HIGHWAY
WAGES                                                   -                -     ..............       ..............

EARLY RETIREMENT INCENTIVE                              -                -     ..............       ..............

PENSION                                                 -                -     ..............       ..............

OTHER PERSONAL SERVICES                                 -                -     ..............       ..............

OTHER CONTRACTUAL SERVICES                         (1,117)           4,000               2,000                4,000
TOTAL CONTRACTUAL SERVICES                         (1,117)           4,000               2,000                4,000

OPERATING SUPPLIES                                          -            125                    -                    -

VEHICLE PARTS                                           -                -                      -                    -
TOTAL MATERIALS AND SUPPLIES                                -            125

PUBLIC WORKS                                                -        2,250               2,250
TOTAL CAPITAL OUTLAY                                        -        2,250               2,250                       -

TRANSFERS                                               -                -                      -                    -
TOTAL STATE HIGHWAY                               (1,117)           6,375              4,250                4,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                           Page 20
2009 OPERATING BUDGET WORKSHEET

                                                                                                                 Explanations
                                                2007                2008           2008             2009         for significant
                                               ACTUAL              BUDGET         ACTUAL           BUDGET          variances


PARKS & RECREATION FUND
PARKS
WAGES                                              (9,273)             22,500        29,246           29,246                877.38


OVERTIME                                                (200)           1,500         2,101            1,500                       45


PART-TIME WAGES                                   (15,638)             -                   -                -

EARLY RETIREMENT INCENTIVE                              -              -                   -                -

PENSION                                            (3,275)              3,570         4,466            4,500                   135


HEALTH INSURANCE                                   (2,325)              2,800         2,935            2,800                       84


LIFE INSURANCE                                              (24)            25             24               25                 0.75


WORKERS COMPENSATION                                    -               1,000          589             1,000                       30


DENTAL INSURANCE                                        (142)               200        179              200                        6


UNIFORMS                                                (107)               292        570              500

MEDICARE                                                (358)               350        447              350                    10.5


OTHER PERSONAL SERVICES                                 -              -                   -                -

PRE-EMPLOYMENT PHYSICALS                                (390)               116        174              250

WELLNESS ACTIVITIES                                     -              -                   -                -

UNEMPLOYMENT COMPENSATION                               -                   617        617              750

RECRUITMENT & TESTING                                -                 -                 -                -
TOTAL PERSONAL SERVICES                           (31,732)             32,970        41,348           41,121              1188.63


TRAVEL & TRAINING                                             -             -                  -         -
TOTAL GENERAL OPERATING                                       -             -                  -         -

OTHER CONTRACTUAL SERVICES                         -                   -                       -            -

RENTS & LEASES                                              (58)        1,000          737             1,000

PROFESSIONAL SERVICES                              (1,021)                  305                -             -

INSURANCE                                               (492)           1,000         1,000            1,000

MAINTENANCE OF EQUIPMENT                           (1,147)              1,500          673             1,500


TREE TRIMMING/LINE CLEARING/LANDSCAPIN                  (400)               500            -                -

SOLID WASTE                                        -                   -                   -                -

ELECTRIC                                           (2,540)              3,000          533              600

WATER                                                   (234)               300            -                -

SEWER                                                   (374)               500            -                -

TELEPHONE                                               (439)           1,095         1,004            1,095

MAINTENANCE OF FACILITY                            (4,251)              4,500         1,782            4,500

PRINTING                                           -                   -                   -                -

ADVERTISING                                                  (9)       -                   36               -

VEHICLE MAINTENANCE                                     (315)           2,700         3,932            1,500

LICENSE & PERMITS                                  -                   -                   -                -

NATURAL GAS                                             (275)               900                -             -

PROPERTY TAX                                                (15)            25             15               25

HARDWARE/SOFTWARE MAINTENANCE                      -                   -                 -                -
TOTAL CONTRACTUAL SERVICES                        (11,570)             17,325         9,712           11,220

19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                   Page 21
2009 OPERATING BUDGET WORKSHEET

                                                                                                                 Explanations
                                                2007                 2008           2008             2009        for significant
                                               ACTUAL               BUDGET         ACTUAL           BUDGET         variances
OFFICE SUPPLIES                                      -                   -                      -            -

OPERATING SUPPLIES                                  (4,321)              4,500         1,801            4,500

VEHICLE PARTS                                                (26)        1,500          773             1,500


FUEL                                                (3,765)              6,500         6,551            6,500

TOOLS                                               -                        250        369              500

SAFETY EQUIPMENT                                             (69)            100        193              500

FLEET: SUPPLIES & EQUIPMENT                           (453)                500            -               500
TOTAL MATERIALS AND SUPPLIES                        (8,634)             13,350         9,687           14,000

LAND & BUILDINGS                                    -                   -                       -            -

CAPITAL EQUIPMENT                                   -                   27,820        11,338            6,000 Replace mower
                                                                                                        8,250 Dump Truck
PUBLIC WORKS                                        -                    5,000             -               -
TOTAL CAPITAL OUTLAY                                                    32,820        11,338           14,250

DEBT SERVICE                                             -                   -              -                -

TRANSFERS                                                -                   -              -                -
TOTAL PARKS                                       51,936               96,465        72,085           80,591




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                   Page 22
2009 OPERATING BUDGET WORKSHEET

                                                                                                                                        Explanations
                                                2007                2008              2008                     2009                    for significant
                                               ACTUAL              BUDGET            ACTUAL                   BUDGET                      variances
POOL
WAGES                                                   -               5,000                  1,059                    5,000                         150


OVERTIME                                                -                   -                  4,296                    1,500                            45


PART-TIME WAGES                                   (24,504)             38,000                32,774                   38,000                          1140


EARLY RETIREMENT INCENTIVE                              -                   -                         -                        -

PENSION                                            (3,340)              6,020                  4,718                    6,000                         180



WORKERS COMPENSATION                               (1,110)              1,200                     544                   1,200                            36



UNIFORMS                                                (174)               500                1,268                    1,200

MEDICARE                                                (355)               620                   502                      620                        18.6


OTHER PERSONAL SERVICES                                 -                   -                         -                        -

PRE-EMPLOYMENT PHYSICALS                           (1,050)              1,200                  1,222                    1,200


RECRUITMENT & TESTING                                -                    350                    -                        -
TOTAL PERSONAL SERVICES                           (30,533)             52,890                46,383                   54,720                       1569.6


TRAVEL & TRAINING                                           31          1,000                     896                      100
TOTAL GENERAL OPERATING                                     31          1,000                     896                      100

OTHER CONTRACTUAL SERVICES                              -                   -                     996                          -

UTILITIES                                               -                   -                         -                        -

RENTS & LEASES                                          -                   -                     114                      200

PROFESSIONAL SERVICES                                   (223)               650                       -                    250

INSURANCE                                               -                   -                         -                        -

MAINTENANCE OF EQUIPMENT                                -               1,750                  1,685                    1,750


ELECTRIC                                                (954)           1,200                  1,871                    1,200 THERE WILL be WORK GOING
                                                                                                                                    on this fall
WATER                                                   (427)               800                3,145                    1,000

SEWER                                                   (710)           1,350                  5,198                    1,500

TELEPHONE                                               (415)               450                   370                      100

MAINTENANCE OF FACILITY                            (6,358)              5,500                  4,915                    5,500

PRINTING                                                -                   350                       -                        -

ADVERTISING                                                 (29)                30                602                      700

VEHICLE MAINTENANCE                                     -                   -                         -                        -

LICENSE & PERMITS                                    (905)              1,200                   778                    1,000
TOTAL CONTRACTUAL SERVICES                        (10,021)             13,280                19,674                   13,200

OFFICE SUPPLIES                                         -                   100                           7                    25

OPERATING SUPPLIES                                (12,159)             12,400                14,988                   15,000

VEHICLE PARTS                                           -                   -        ..............           ..............

CONCESSION SUPPLIES                                     (523)           3,600                  2,977                    3,600

OFFICE EQUIPMENT                                        -                   -        ..............           ..............

FUEL                                                    -                   -        ..............           ..............

TOOLS                                                   -                   -        ..............           ..............

SAFETY EQUIPMENT                                     (133)                650                   606                      650
TOTAL MATERIALS AND SUPPLIES                      (12,815)             16,750                18,578                   19,275


19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                          Page 23
2009 OPERATING BUDGET WORKSHEET

                                                                                                          Explanations
                                                2007              2008           2008         2009        for significant
                                               ACTUAL            BUDGET         ACTUAL       BUDGET         variances
LAND & BUILDINGS                                     -                -                  -            -

CAPITAL EQUIPMENT                                   -                 6,100         6,053        2,000

PUBLIC WORKS                                        -                 5,000         3,611
TOTAL CAPITAL OUTLAY                                                 11,100         9,664        2,000

REFUNDS & REIMBURSEMENTS                                 (200)            200            -        200
TOTAL POOL                                        (53,538)          95,220        95,195       89,495




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                            Page 24
2009 OPERATING BUDGET WORKSHEET

                                                                                                                                    Explanations
                                                2007                2008              2008                     2009                 for significant
                                               ACTUAL              BUDGET            ACTUAL                   BUDGET                  variances
BRYAN CENTER
WAGES                                              -                   -                              -                        -

OVERTIME                                           (1,670)              1,000                  4,015                    1,000                         30


PART-TIME WAGES                                   (37,790)             43,000                43,501                   40,000                      1200


EARLY RETIREMENT INCENTIVE                        (15,064)             19,000                15,064                            -

PENSION                                            (5,097)              6,175                  7,338                    6,175                  185.25


HEALTH INSURANCE                                   -                   -                                  -                    -

LIFE INSURANCE                                     -                   -                                  -                    -

WORKERS COMPENSATION                               (1,179)              1,200                     578                   1,200                         36


DENTAL INSURANCE                                   -                   -                                  -                    -

UNIFORMS                                                -                   -        ..............           ..............

MEDICARE                                                (529)               730                   740                      730                    21.9


OTHER PERSONAL SERVICES                            -                   -                                  -                    -

PRE-EMPLOYMENT PHYSICALS                           -                   -                                  -                    -

WELLNESS ACTIVITIES                                -                   -                                  -                    -

UNEMPLOYMENT COMPENSATION                          -                   -                                  -                    -

RECRUITMENT & TESTING                              -                   -                          -                       -
TOTAL PERSONAL SERVICES                           (61,329)             71,105                71,236                   49,105                 1473.15


TRAVEL & TRAINING                                       (127)                   50                    11                       50
TOTAL GENERAL OPERATING                                 (127)                   50                    11                       50

OTHER CONTRACTUAL SERVICES                         (2,100)                      64                    64                   100

UTILITIES                                          -                   -                                  -                    -

RENTS & LEASES                                     -                   -                                  -                    -

PROFESSIONAL SERVICES                                       (38)       -                          114                          -

INSURANCE                                          -                   -                                  -                    -

MAINTENANCE OF EQUIPMENT                           (9,528)             15,050                16,299                   15,050


ELECTRIC                                          (30,564)             33,727                29,693                   33,727

WATER                                              (1,770)              3,500                  1,756                    5,500

SEWER                                              (2,950)              5,500                  2,933                    5,500

TELEPHONE                                          (3,063)              3,200                  3,822                    3,500

MAINTENANCE OF FACILITY                           (35,955)             46,202                44,108                   48,300 Janitorial, painting

PRINTING                                           -                   -                                  -                    -

ADVERTISING                                        -                        500                           -                500


LICENSE & PERMITS                                       (223)               223                   368                      223

NATURAL GAS                                        (5,988)             10,750                11,952                   12,000

HARDWARE/SOFTWARE SUPPORT                          -                   -                         -                       -
TOTAL CONTRACTUAL SERVICES                        (92,179)            118,716              111,109                  124,400

OFFICE SUPPLIES                                         (936)               500                   144                      150

OPERATING SUPPLIES                                 (2,609)              3,500                  4,205                    4,000




SAFETY EQUIPMENT                                        (180)          -                                  -                    -

19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                      Page 25
2009 OPERATING BUDGET WORKSHEET

                                                                                                         Explanations
                                                2007            2008           2008         2009         for significant
                                               ACTUAL          BUDGET         ACTUAL       BUDGET          variances
TOTAL MATERIALS AND SUPPLIES                         (3,802)         4,000         4,349        4,150

LAND & BUILDINGS                                     -              -                  -           -

CAPITAL EQUIPMENT                                   (10,580)            800        1,278           -

PUBLIC WORKS                                         -              44,200         8,205
TOTAL CAPITAL OUTLAY                                (10,580)        45,000         9,483          -

DEBT SERVICE                                         -              -                  -           -

REFUNDS & REIMBURSEMENTS                             (2,992)         3,000         1,758        1,800

TRANSFERS                                           (47,796)        48,396        48,396       48,884 to BR
TOTAL BRYAN CENTER                               (218,805)       290,267       246,342      228,389




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                           Page 26
2009 OPERATING BUDGET WORKSHEET

                                                                                                                                Explanations
                                                2007                2008              2008                  2009                for significant
                                               ACTUAL              BUDGET            ACTUAL                BUDGET                 variances


BRYAN YOUTH CENTER
RECRUITMENT & TESTING                                   -                   -        ..............        ..............

TRAVEL & TRAINING                                           (47)                50                    16                    -
TOTAL GENERAL OPERATING                                     (47)                50                    16

OTHER CONTRACTUAL SERVICES

UTILITIES

RENTS & LEASES

PROFESSIONAL SERVICES

MAINTENANCE OF EQUIPMENT                                      -             100                        -                    -

PRINTING                                                      -        -                               -                    -
TOTAL CONTRACTUAL SERVICES                                    -             100                        -                    -

OPERATING SUPPLIES                                      (782)           2,500                  2,495                 2,500


SPECIAL EVENTS                                     (2,327)              2,500                  2,043                 2,500

SAFETY EQUIPMENT                                     -                 -                            -                     -
TOTAL MATERIALS AND SUPPLIES                       (3,109)              5,000                  4,538                 5,000
204-1604-55101                                       -                    -          ..............        ..............

204-1604-55102                                          -                   -        ..............        ..............
TOTAL BRYAN YOUTH CENTER                          (3,156)              5,150                 4,554                 5,000

TOTAL PARKS & RECREATION FUND                   (223,563)            487,102            418,176               403,475




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                  Page 27
2009 OPERATING BUDGET WORKSHEET

                                                                                                     Explanations
                                                2007          2008         2008         2009        for significant
                                               ACTUAL        BUDGET       ACTUAL       BUDGET         variances


ECONOMIC DEVELOPMENT

PROFESSIONAL SERVICES                              (2,000)        2,500            -      50,000

LOANS                                             (20,000)      100,000            -     100,000 Tr. From GF
TOTAL CONTRACTUAL SERVICES                        (22,000)      102,500            -     150,000

LAND & BUILDINGS                                        -             -            -         -
TOTAL ECONOMIC DEVELOPMENT                       (22,000)      102,500             -    150,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                      Page 28
2009 OPERATING BUDGET WORKSHEET

                                                                                                                     Explanations
                                                2007             2008         2008                 2009              for significant
                                               ACTUAL           BUDGET       ACTUAL               BUDGET               variances


GREEN SPACE FUND


LAND & BUILDINGS                                            -      137,900                    -         250,000

PUBLIC WORKS                                                -           -                     -                  -
TOTAL CAPITAL OUTLAY                                               137,900                              250,000
207-1501-57102                                          -              -     ..............       ..............

207-1501-59101                                          -                -   ..............       ..............
TOTAL GREEN SPACE                                           -     137,900                     -      250,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                       Page 29
2009 OPERATING BUDGET WORKSHEET

                                                                                                     Explanations
                                                2007           2008         2008         2009        for significant
                                               ACTUAL         BUDGET       ACTUAL       BUDGET         variances


PERMISSIVE TAX FUND
PROFESSIONAL SERVICES                                    -             -            -            -

PUBLIC WORKS                                      (137,130)        3,100            -            -

TRANSFERS                                                -             -            -            -
TOTAL PERMISSIVE TAX                            (137,130)         3,100             -        -




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                       Page 30
2009 OPERATING BUDGET WORKSHEET

                                                                                                    Explanations
                                                2007          2008         2008        2009         for significant
                                               ACTUAL        BUDGET       ACTUAL      BUDGET          variances


MAYOR'S COURT COMPUTER FUND

HARDWARE/SOFTWARE                                  (7,307)        4,975       3,987       5,000
TOTAL CONTRACTUAL SERVICES                         (7,307)        4,975       3,987       5,000

CAPITAL EQUIPMENT                                       -             -        944          -     Upgrade
TOTAL CAPITAL OUTLAY                                    -             -        944          -


TOTAL MAYOR'S COURT COMPUTER                      (7,307)        4,975       4,931       5,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                      Page 31
2009 OPERATING BUDGET WORKSHEET

                                                                                                    Explanations
                                                2007         2008         2008         2009         for significant
                                               ACTUAL       BUDGET       ACTUAL       BUDGET          variances


FEMA GRANT
TRANSFERS OUT                                           -            -            -         -

REFUNDS & REIMBURSEMENTS                                -            -       8,985       79,000 Reimb. - windstorm

TRANSFERS OUT                                           -            -            -         -
TOTAL FEMA                                              -        -          8,985       79,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                      Page 32
2009 OPERATING BUDGET WORKSHEET

                                                                                                Explanations
                                                2007         2008         2008       2009       for significant
                                               ACTUAL       BUDGET       ACTUAL     BUDGET        variances


LAW ENFORCEMENT & EDUCATION FUND
TRAVEL & TRAINING                                       -        1,500        539       1,500
TOTAL GENERAL OPERATING                                 -        1,500        539       1,500

OFFICE SUPPLIES                                         -            -        860         -
TOTAL LAW ENF & EDUCATON                                -       1,500       1,399      1,500




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                  Page 33
2009 OPERATING BUDGET WORKSHEET

                                                                                                  Explanations
                                                2007          2008         2008        2009       for significant
                                               ACTUAL        BUDGET       ACTUAL      BUDGET        variances


COATS & SUPPLIES FUND (donations)
COATS & SUPPLIES                                   (1,725)        5,000       1,779       5,000

TOTAL COATS & SUPPLIES                            (1,725)        5,000       1,779       5,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                    Page 34
2009 OPERATING BUDGET WORKSHEET

                                                                                                   Explanations
                                                2007          2008         2008         2009       for significant
                                               ACTUAL        BUDGET       ACTUAL       BUDGET        variances


FURTHERANCE OF JUSTICE (forfeitures)
CAPITAL EQUIPMENT                                       -        23,828      22,747       20,000
TOTAL CAPITAL OUTLAY                                    -        23,828      22,747       20,000

REFUNDS & REIMBURSEMENTS                                -             -            -         -

MISCELLANEOUS                                      (2,279)       13,000     112,258       15,000
TOTAL FOJ                                         (2,279)       36,828     135,005       35,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                     Page 35
2009 OPERATING BUDGET WORKSHEET

                                                                                                         Explanations
                                                2007             2008           2008         2009        for significant
                                               ACTUAL           BUDGET         ACTUAL       BUDGET         variances


POLICE PENSION FUND (Tax settlements/subsidized by GF)
EARLY RETIREMENT INCENTIVE                              -                -              -            -

PENSION                                            (84,744)         87,721         87,693       88,600            2,658.00


WORKERS COMPENSATION
TOTAL PERSONAL SERVICES                            (84,744)         87,721         87,693       88,600            2,658.00


AUDITOR & TREAS. FEES                                   (358)            350         359          360

10% ROLLBACK

HOMESTEAD

2 1/2% ROLLBACK

DELINQUENT COLLECTION COSTS                              (51)             52          70           70
TOTAL CONTRACTUAL SERVICES                              (409)            402         429          430

REFUNDS & REIMBURSEMENTS                                    -            -              -          -
TOTAL POLICE PENSION FUND                        (85,153)          88,123        88,122       89,030

TOTAL SPECIAL REVENUE FUNDS                    (1,337,821)      2,156,553      1,420,946    1,732,278




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                           Page 36
2009 OPERATING BUDGET WORKSHEET

                                                                                                                        Explanations
                                                2007             2008          2008                 2009                for significant
                                               ACTUAL           BUDGET        ACTUAL               BUDGET                 variances


CAPITAL PROJECT FUNDS:

VEHICLE REPLACEMENT FUND
POLICE CRUISERS - VEHICLE REPLACEMENT                       -             -                    -                    -
TOTAL VEHICLE REPLACEMENT FUND                              -         -                        -               -

CABLE T.V. CAPITAL FUND
CAPITAL EQUIPMENT                                       (900)       12,500              5,884                2,000
TOTAL CAPITAL- CABLE                                (900)          12,500             5,884                2,000

WATER IMPROVEMENT FUND
PUBLIC WORKS                                                -             -                    -                    -
TOTAL CAPITAL - WATER IMPROV.                               -         -                        -               -
TRANSFERS OUT                                           -                -    ..............       ..............




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                          Page 37
2009 OPERATING BUDGET WORKSHEET

                                                                                                    Explanations
                                                2007         2008          2008         2009        for significant
                                               ACTUAL       BUDGET        ACTUAL       BUDGET         variances


SEWER IMPROVEMENT FUND
OTHER CONTRACTUAL SERVICES                              -            -             -        -

PROFESSIONAL SERVICES                                   -            -        5,561

MAINTENANCE OF EQUPMENT                                 -            -             -        -

MAINTENANCE OF FACILITY                                 -            -            -         -
TOTAL CONTRACTUAL SERVICES                              -            -        5,561         -

LAND AND BUILDINGS                                      -            -             -        -

CAPITAL EQUIPMENT                                       -            -             -        -

PUBLIC WORKS                                            -     1,121,200            -
TOTAL CAPITAL OUTLAY                                    -     1,121,200            -        -
TOTAL SEWER IMPROVEMENT FUND                            -   1,121,200        5,561              -




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                      Page 38
2009 OPERATING BUDGET WORKSHEET

                                                                                                              Explanations
                                                2007           2008              2008         2009            for significant
                                               ACTUAL         BUDGET            ACTUAL       BUDGET             variances
Activity to be moved to new Sewer Fund
ELECTRIC IMPROVEMENT FUND
OTHER CONTRACTUAL SERVICES                               -                  -            -                -

PROFESSIONAL SERVICES                                    -                  -            -                -

MAINTENANCE OF EQUIPMENT                                 -                  -            -                -

MAINTENANCE OF FACILITY                                  -                  -            -                -
TOTAL CONTRACTUAL SERVICES                               -              -                -            -

LAND AND BUILDINGS                                       -                  -            -                -

CAPITAL EQUIPMENT                                        -                  -            -                -

PUBLIC WORKS                                             -                  -            -                -
TOTAL CAPITAL OUTLAY                                     -              -                -            -
ELECTRIC IMPROVEMENT FUND                                -          -                -            -

PARKS & RECREATION IMPROVEMENT FUND
OTHER CONTRACTUAL SERVICES                               -                  -            -                -

PROFESSIONAL SERVICES                                    -                  -            -                -

MAINTENANCE OF EQUIPMENT                                 -                  -            -                -

MAINTENANCE OF FACILITY                                  -                  -            -                -
TOTAL CONTRACTUAL SERVICES                               -              -                -            -

LAND AND BUILDINGS                                       -              -                -            -

CAPITAL EQUIPMENT                                        -              -                -            -

PUBLIC WORKS                                             -        87,500           17,535       20,000 Complete work on baby pool
TOTAL CAPITAL OUTLAY                                     -        87,500           17,535       20,000
TOTAL PARKS IMPROVEMENT FUND                             -       87,500           17,535       20,000

FACILITIES IMPROVEMENT FUND
OTHER CONTRACTUAL SERVICES                               -                  -            -                -

PROFESSIONAL SERVICES                                    -                  -            -                -

MAINTENANCE OF EQUIPMENT                                 -                  -            -                -

MAINTENANCE OF FACILITY                                  -                  -            -                -
TOTAL CONTRACTUAL SERVICES                               -                  -            -                -

LAND AND BUILDINGS                                       -                  -            -                -

CAPITAL EQUIPMENT                                        -                  -            -                -

PUBLIC WORKS                                             -                  -            -                -
TOTAL CAPITAL OUTLAY                                     -                  -            -                -
TOTAL FACILITIES IMPROVEMENT FU                          -                  -            -                -

CAPITAL EQUIPMENT FUND
MAINTENANCE OF EQUIPMENT                                 -                  -            -                -
TOTAL CONTRACTUAL SERVICES                               -                  -            -                -

CAPITAL EQUIPMENT                                        -                  -            -                -
TOTAL CAPITAL OUTLAY                                     -                  -            -                -
TOTAL CAPITAL EQUIPMENT FUND                             -                  -            -                -

OPWC GRANT - DAYTON STREET

PROFESSIONAL SERVICES                                    -                  -            -                -
TOTAL CONTRACTUAL SERVICES                               -                  -            -                -

PUBLIC WORKS                                      (325,176)                 -            -            -
TOTAL CAPITAL OUTLAY                              (325,176)                 -            -            -

TOTAL OPWC GRANT - DAYTON STRE                  (325,176)                   -            -                - complete




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                Page 39
2009 OPERATING BUDGET WORKSHEET

                                                                                                        Explanations
                                                2007          2008           2008          2009        for significant
                                               ACTUAL        BUDGET         ACTUAL        BUDGET         variances


USACE GRANT - CTR BUS. & ED.
PROFESSIONAL SERVICES                                   -             -              16         -

ADVERTISING                                             -             600        596            -
TOTAL CONTRACTUAL SERVICES                              -             600        612            -

CAPITAL EQUIPMENT                                       -             -               -         -

PUBLIC WORKS                                       (1,038)       50,400        18,147        50,000 (FB = 22203) ASKI ED
TOTAL CAPITAL OUTLAY                               (1,038)       50,400        18,147        50,000

TOTAL USACE GRANT - Ctr BUS. & ED                 (1,038)       51,000        18,759        50,000

ODOT GRANT FUND - CTR BUS. & ED.
PUBLIC WORKS                                            -        50,000               -      50,000 ASK ED
TOTAL CAPITAL OUTLAY                                    -        50,000               -      50,000

TOTAL CAPITAL PROJECT FUNDS                     (327,114)    1,322,200        47,739       122,000




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                         Page 40
2009 OPERATING BUDGET WORKSHEET

                                                                                                                            Explanations
                                                2007             2008           2008                 2009                   for significant
                                               ACTUAL           BUDGET         ACTUAL               BUDGET                    variances


DEBT SERVICE FUNDS:
BOND RETIREMENT FUND
PROFESSIONAL SERVICES                                       -            -                      -                    -

AUD. & TREAS.FEES-SPEC.ASSMT.                           (244)            250                    -                    -

DELINQUENT COLLECTION COSTS                                 -            -                      -                    -

DEBT SERVICE - PRINCIPAL                          (89,161)          85,000             85,000               90,000 From GF, Pks, Elec
                                                                                                                         for Bldg. Bond
DEBT SERVICE - INTEREST                           (48,095)          44,055             44,055               40,357

REFUNDS & REIMBURSEMENTS                                -                -     ..............       ..............

TRANSFERS OUT                                           -                -     ..............       ..............
TOTAL BOND RETIREMENT FUND                      (137,500)         129,305         129,055              130,357




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                              Page 41
2009 OPERATING BUDGET WORKSHEET

                                                                                                              Explanations
                                                2007             2008           2008          2009            for significant
                                               ACTUAL           BUDGET         ACTUAL        BUDGET              variances


ENTERPRISE FUNDS:                                                                                          53,125 Utilities
ELECTRIC FUND
WAGES                                             (196,195)        255,000       203,983       255,000 Kelley's                           7650


OVERTIME                                            (6,599)          4,500        14,475         4,500 Kelley's                            135


PART-TIME                                          (17,803)         25,000        14,636        15,500 Utilities                           465


EARLY RETIREMENT INCENTIVE                          (7,942)         13,300         8,885         1,797

PENSION                                            (29,009)         37,750        33,947        41,398 .145 x 1st 3 lines               1241.94


HEALTH INSURANCE                                   (41,670)         50,000        49,978        50,000                                    1500


LIFE INSURANCE                                          (681)            750        534            488                                    14.64


WORKERS COMPENSATION                                (8,391)          9,000         4,115         5,000                                     150


DENTAL INSURANCE                                    (2,281)          2,500         2,352         2,500                                      75


UNIFORMS                                            (1,244)          1,750          400            250

UNIFORMS - FR                                              -         2,000               -       2,000

MEDICARE                                            (1,910)          1,960         2,041         4,140 .0145 x wages                      124.2


OTHER PERSONAL SERVICES                                    -             -               -          -

PRE-EMPLOYMENT PHYSICALS                                 (39)            120             -          -

WELLNESS ACTIVITIES                                        -             50             -             50

UNEMPLOYMENT COMPENSATION                           (2,580)              -              14          -

RECRUITMENT & TESTING                                    -              13             -           -
TOTAL PERSONAL SERVICES                           (316,344)        403,693       335,360       382,623                              11355.78


TRAVEL & TRAINING                                   (3,054)          5,125         3,179         5,125
TOTAL GENERAL OPERATING                             (3,054)          5,125         3,179         5,125




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                  Page 42
2009 OPERATING BUDGET WORKSHEET

                                                                                                            Explanations
                                                2007             2008           2008         2009           for significant
                                               ACTUAL           BUDGET         ACTUAL       BUDGET            variances
OTHER CONTRACTUAL SERVICES                              (584)            967       23,722         -      Storm related to date


UTILITIES                                                  -             -              -          -

RENTS & LEASES                                      (1,889)          2,390          2,527        2,390

PROFESSIONAL SERVICES                             (20,806)          93,297          9,007        5,000

INSURANCE                                         (15,754)          17,000         17,000       20,000

MAINTENANCE OF EQUIPMENT                          (12,999)          14,500         11,673       14,500

POSTAGE                                             (3,118)          3,500          4,009        3,500 UT bills

MEMBERSHIPS                                         (3,355)          3,500          3,155        3,200

POWER COST (AMP-OHIO/DP&L)                      (1,693,111)       1,798,852     1,737,245    1,900,000

TREE TRIM/LINE CLEAR/LANDSCAPING                  (37,805)          96,600         55,644       96,600

SOLID WASTE                                              (31)            100            -          -

ELECTRIC                                            (1,715)          2,000          1,834        2,000

WATER                                                      -             13             -          -

SEWER                                                      -             -              -          -

TELEPHONE                                           (5,273)          8,533          6,972        8,802

MAINTENANCE OF FACILITY                             (2,244)          2,200           794         2,200

PRINTING                                            (2,231)          3,000          1,312        1,400 UT bills

ADVERTISING                                             154              500          81           500

VEHICLE MAINTENANCE                                     (337)            500         363           500

LICENSE & PERMITS                                        (53)            150         117           150

NATURAL GAS                                             (982)        1,500          1,523        1,700

HARDWARE/SOFTWARE MAINTENANCE                       (8,431)          8,500          7,424        8,500

JV2 ISSUANCE COSTS & POWER MAINTENANC              (24,236)          31,623        17,784          -   PAID OFF '08
TOTAL CONTRACTUAL SERVICES                      (1,834,800)       2,089,225     1,902,186    2,070,942

OFFICE SUPPLIES                                         (394)        1,000           518         1,000

OPERATING SUPPLIES                                (44,662)          49,082         19,054       22,000 customer cost-sharing

VEHICLE PARTS                                           (998)        1,500          1,209        1,500

BOOKS & PUBLICATIONS                                    (443)            400         155           200

NSF BANK CHARGES                                           -             -              -          -

OFFICE EQUIPMENT                                           -             200            -          -

FUEL                                                (3,521)          5,700          5,326        5,700

TOOLS                                               (4,421)          5,000           934         2,500

SPECIAL EVENTS                                          (150)            50           43            50

SAFETY EQUIPMENT                                    (1,554)          4,300           816         1,300

FLEET: SUPPLIES & EQUIPMENT                             -              150            189          150
TOTAL MATERIALS AND SUPPLIES                      (56,143)          67,382         28,244       34,400




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                              Page 43
2009 OPERATING BUDGET WORKSHEET

                                                                                                                              Explanations
                                                2007             2008             2008                 2009                   for significant
                                               ACTUAL           BUDGET           ACTUAL               BUDGET                    variances
LAND & BUILDINGS                                            -            -                        -         -

CAPITAL EQUIPMENT                                  (24,975)         70,600               62,917                 5,602 1/3 UT office equpment

PUBLIC WORKS                                             -          55,000                4,670
                                                   (24,975)        125,600               67,587                 5,602
TOTAL CAPITAL OUTLAY
JV-2 WORKING CAPITAL                                -                        0                    -        0

DEBT SERVICE - PRINCIPAL                          (100,000)        175,000             175,000                         -   OMEGA JV2 - BA NOTE
                                                                                                                           paid off 11/08
INTEREST                                           (10,284)          7,000               7,068                         -
TOTAL DEBT SERVICE                                (110,284)        182,000             182,068                         -

KWH TAX - TO STATE OF OHIO                          (3,404)          3,500                 2,989                3,000

REFUNDS & REIMBURSEMENTS                                (581)            500                  801                  800

TRANSFERS                                          (31,863)         32,264               32,264                32,590 to BR - 25% of Bldg. Bond

KWH-PAYMENT TO GENERAL FUND                       (145,730)        146,000             137,362              146,000

                                                        -                -       ..............       ..............
TOTAL ELECTRIC FUND                            (2,527,178)      3,055,289        2,692,040            2,681,082




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                Page 44
2009 OPERATING BUDGET WORKSHEET

                                                                                                            Explanations
                                                2007             2008           2008          2009          for significant
                                               ACTUAL           BUDGET         ACTUAL        BUDGET           variances


WATER FUND:
WATER DISTRIBUTION


WAGES                                             (106,640)        142,000       116,488       142,000 $36,053=utilities             4260


OVERTIME                                            (3,076)            3,500       6,258         3,500                                105


PART-TIME                                          (14,486)         16,000        11,413        11,350 Utilities                     340.5


EARLY RETIREMENT INCENTIVE                          (5,984)         10,000         6,663         1,348

PENSION                                            (16,124)         21,200        19,426        22,750                               682.5


HEALTH INSURANCE                                   (23,679)         36,500        27,934        36,500 .145 OF 1st 3 accts           1095


LIFE INSURANCE                                          (442)            600        322            600                                 18


WORKERS COMPENSATION                                (4,161)            4,500       2,041         4,500                                135


DENTAL INSURANCE                                    (1,408)            1,750       1,379         1,750                                52.5


UNIFORMS                                                (858)          1,000        400          1,000

MEDICARE                                            (1,227)            1,250       1,351         2,060                                61.8


OTHER PERSONAL SERVICES                                    -             -               -          -

PRE-EMPLOYMENT PHYSICALS                                 (39)            -               -          -

WELLNESS ACTIVITIES                                        -             -               -          -

UNEMPLOYMENT COMPENSATION                           (2,580)            1,000            14          -

RECRUITMENT & TESTING                                    -             -               -           -
TOTAL PERSONAL SERVICES                           (180,704)        239,300       193,689       227,358                              6750.3


TRAVEL & TRAINING                                       (690)          1,000        193            500
TOTAL GENERAL OPERATING                                 (690)          1,000        193            500

OTHER CONTRACTUAL SERVICES                                 -       -                    29            -

UTILITIES                                                  -       -                    -             -

RENTS & LEASES                                      (1,873)            2,000       2,155         2,000

PROFESSIONAL SERVICES                               (9,395)            9,000       4,343        16,500

INSURANCE                                           (3,938)            4,000       4,000         4,500

MAINTENANCE OF EQUIPMENT                            (3,951)            4,000       1,312         4,000

POSTAGE                                             (3,258)            3,400       4,006         3,500 ut bills

MEMBERSHIPS                                              (35)            100             -         100

TREE TRIMMING/LINE CLEARING/LANDSCAPIN                     -             -               -          -

SOLID WASTE                                              (31)            100             -          -

ELECTRIC                                                (617)            650        680            700


TELEPHONE                                           (5,025)            8,301       6,829         9,000

MAINTENANCE OF FACILITY                                 (863)          1,200        794          1,200

PRINTING                                            (1,361)            1,500       1,312         1,300 ut bills

ADVERTISING                                             154              -              19            25

VEHICLE MAINTENANCE                                     (625)          1,500        125          1,000

LICENSE & PERMITS                                       (319)            400        117            400

NATURAL GAS                                             (982)          1,500       1,523         1,500

HARDWARE/SOFTWARE MAINTENANCE                       (6,268)            6,500       4,998         6,500
19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                              Page 45
2009 OPERATING BUDGET WORKSHEET

                                                                                                              Explanations
                                                2007            2008           2008         2009              for significant
                                               ACTUAL          BUDGET         ACTUAL       BUDGET               variances
TOTAL CONTRACTUAL SERVICES                         (38,387)        44,151         32,242       52,225

OFFICE SUPPLIES                                        (308)          400           442           400
                                                                                                           incls. 12,000 wtr mtr to resume
OPERATING SUPPLIES                                  (17,548)       15,799         11,215       27,000 rotation replacement for > 15
                                                                                                           yrs. Old
VEHICLE PARTS                                          (509)        1,000          1,241        1,000

BOOKS & PUBLICATIONS                                    (13)           50            13            50

OFFICE EQUIPMENT                                          -           -                -           -

FUEL                                                 (3,520)        5,800          5,413        5,800

TOOLS                                                  (490)          500           202           500

SPECIAL EVENTS                                            -            50            43            50

SAFETY EQUIPMENT                                       (979)        1,200           786         1,200

FLEET: SUPPLIES & EQUIPMENT                             (27)          100              -          100
TOTAL MATERIALS AND SUPPLIES                        (23,394)       24,899         19,355       36,100

LAND AND BUILDINGS                                        -           -                -           -

CAPITAL EQUIPMENT                                    (4,733)       39,710         37,684        5,599

PUBLIC WORKS                                       (193,343)       76,500          2,406        7,500
TOTAL CAPITAL OUTLAY                               (198,076)      116,210         40,090       13,099

DEBT SERVICE - PRINCIPAL                            (13,438)       29,252         14,139       14,877 OWDA Loan #3473

DEBT SERVICE - INTEREST                              (8,068)       14,567          7,367        6,630 OWDA Loan #3473
TOTAL DEBT SERVICE                                  (21,506)       43,819         21,506       21,507

REFUNDS & REIMBURSEMENTS                               (668)          200           328           400

TRANSFERS                                                 -               -            -               -
TOTAL WATER DISTRIBUTION                         (463,425)       469,579       307,403      351,189




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                Page 46
2009 OPERATING BUDGET WORKSHEET

                                                                                                                 Explanations
                                                2007             2008           2008            2009             for significant
                                               ACTUAL           BUDGET         ACTUAL          BUDGET              variances


WATER TREATMENT:
WAGES                                              (78,779)         81,500           78,453       81,500                                  2445


OVERTIME                                            (4,220)            4,500         12,708           4,500 STORM RELATED                 135


EARLY RETIREMENT INCENTIVE                                 -       -                   (636)            -     (Correction)


PENSION                                            (10,409)         13,600           13,378       13,600                                  408


HEALTH INSURANCE                                   (19,788)         25,000           24,983       25,000                                  750


LIFE INSURANCE                                          (182)            250           184             250                                 7.5


WORKERS COMPENSATION                                (2,982)            3,000          1,462           3,000                                90


DENTAL INSURANCE                                    (1,174)              900          1,142           1,200                                36
                                                                                 .
UNIFORMS                                                (381)            400           356             400

MEDICARE                                                (369)            400           448            1,250                               37.5


OTHER PERSONAL SERVICES                                    -             -                -             -

PRE-EMPLOYMENT PHYSICALS                                 (58)            -                -             -

WELLNESS ACTIVITIES                                        -             50               -             50

UNEMPLOYMENT COMPENSATION                                  -             -                -             -

RECRUITMENT & TESTING                                    -             -               -             -
TOTAL PERSONAL SERVICES                           (118,342)        129,600       132,478         130,750                                  3909


TRAVEL & TRAINING                                          -             500           100      500
TOTAL GENERAL OPERATING                                    -             500           100      500

OTHER CONTRACTUAL SERVICES                               (39)            -             269              -     Storm related


UTILITIES                                                  -             -                -             -

RENTS & LEASES                                             -             -              11              -

PROFESSIONAL SERVICES                               (3,490)            7,525          6,790       18,518 Includes Annual Calibration
                                                                                                                              $3,518
INSURANCE                                                  -             -                -             -

MAINTENANCE OF EQUIPMENT                           (16,357)         20,600           19,598       20,600

POSTAGE                                                 (500)            600           705             800

MEMBERSHIPS                                             (124)            150           124             150

TREE TRIMMING/LINE CLEARING/LANDSCAPIN                     -           9,175          9,000           5,000

GROUNDS MAINTENANCE/LANDSCAPING                            -             -                -             -

SOLID WASTE                                                -             63               -             65

ELECTRIC                                           (16,967)         17,500           17,785       18,000

WATER                                                      -             -                -             -

SEWER                                                      -             750              -             -

TELEPHONE                                               (661)            988           944            1,000

MAINTENANCE OF FACILITY                                    -        19,664            4,366       22,000

PRINTING                                                (507)            500           563             600

ADVERTISING                                                -             -              22              30

VEHICLE MAINTENANCE                                 (1,676)            1,500          1,285           1,500

LICENSE & PERMITS                                   (3,120)            4,750          4,670           3,200

WELLHEAD PROTECTION                                        -           1,000              -           1,000

HARDWARE/SOFTWARE SUPPORT                                  -             -                -            200
19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                    Page 47
2009 OPERATING BUDGET WORKSHEET

                                                                                                                                Explanations
                                                2007             2008             2008                  2009                    for significant
                                               ACTUAL           BUDGET           ACTUAL                BUDGET                     variances
TOTAL CONTRACTUAL SERVICES                         (43,441)         84,765           66,132                92,663


OFFICE SUPPLIES                                         (392)            200                  250                   300

OPERATING SUPPLIES                                   (4,617)         7,100                 8,638                 9,000

VEHICLE PARTS                                           (244)            400                  144                   400

BOOKS & PUBLICATIONS                                       -             -                         -                    -

OFFICE EQUIPMENT                                        (823)            650                       -                500

FUEL                                                 (2,663)         3,000                 2,696                 3,500

TOOLS                                                      -             -                         -                300

SPECIAL EVENTS                                           (61)            50                       50                    50

SAFETY EQUIPMENT                                         (49)            50                   525                   100

FLEET: SUPPLIES & EQUIPMENT                               -            -                      -                   -
TOTAL MATERIALS AND SUPPLIES                         (8,849)        11,450               12,303                14,150

LAND & BUILDINGS                                           -             -                         -           32,000 pole barn for generator

CAPITAL EQUIPMENT                                          -        13,500               13,117                10,000 1/2 vehicle

PUBLIC WORKS                                               -        18,000               17,939                45,121
TOTAL CAPITAL OUTLAY                                       -        31,500               31,056                87,121

DEBT SERVICE                                               -                 -                     -                        -

REFUNDS & REIMBURSEMENTS                                   -             50                       36                        -

CANCELLED CHECKS                                    -                -           ..............        ..............

TRANSFERS                                                  -                 -                     -                        -
TOTAL WATER TREATMENT                            (170,632)        257,865           242,105               325,184

TOTAL WATER FUND                                 (634,057)        727,444           549,508               676,373




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                  Page 48
2009 OPERATING BUDGET WORKSHEET

                                                                                                            Explanations
                                                2007             2008           2008          2009          for significant
                                               ACTUAL           BUDGET         ACTUAL        BUDGET           variances


SEWER FUND:
SEWER COLLECTION                                         -             -               -        48,424 Utilities                    1452.72
WAGES                                             (111,642)        133,500       120,366        85,876 Dave                         2576.28


OVERTIME                                            (3,779)          3,500         6,626         5,000 Dave                            150
                                                                                                 9,568 Utilities                     287.04
PART-TIME                                          (10,797)         12,500         6,542         6,000 Dave                            180


EARLY RETIREMENT INCENTIVE                         (12,930)         16,758        10,035         1,348

PENSION                                            (15,882)         19,945        19,378        22,500                                 675


HEALTH INSURANCE                                   (18,057)         24,500        21,793        24,500                                 735


LIFE INSURANCE                                          (417)            500        321            500                                  15


WORKERS COMPENSATION                                (5,964)          6,500         2,925         6,500                                 195


DENTAL INSURANCE                                    (1,317)          1,700         1,395         1,700                                  51


UNIFORMS                                                (850)        1,000          449          1,000

UNIFORMS - FR                                              -             -               -          -

MEDICARE                                            (1,540)          1,800         1,658         2,250                                 67.5


OTHER PERSONAL SERVICES                                    -             -               -          -

PRE-EMPLOYMENT PHYSICALS                                 (97)            50              -          -

WELLNESS ACTIVITIES                                        -             -               -          -

UNEMPLOYMENT COMPENSATION                           (2,580)              775        448            775                                23.25


RECRUITMENT & TESTING                                    -             -               -           -
TOTAL PERSONAL SERVICES                           (185,852)        223,028       191,936       215,941                              6407.79


TRAVEL & TRAINING                                          -             250        782          1,000
TOTAL GENERAL OPERATING                                    -             250        782          1,000

OTHER CONTRACTUAL SERVICES                                 -             500            29         500


RENTS & LEASES                                      (2,674)          2,800         2,149         2,500

PROFESSIONAL SERVICES                               (1,736)          2,000         4,406         2,500

INSURANCE                                           (7,385)          7,500         7,500         7,500

MAINTENANCE OF EQUIPMENT                            (3,415)         15,550        10,900        15,000

POSTAGE                                             (3,258)          3,400         3,952         3,500 ut bills

MEMBERSHIPS                                              (30)            150             -         150

SOLID WASTE                                              (31)            100             -         100

ELECTRIC                                            (3,412)          3,500         4,253         4,000

WATER                                               (1,402)          1,500          668          1,500

SEWER                                               (2,185)          2,300         1,042         2,300

TELEPHONE                                           (5,095)          5,500         6,544         7,500

MAINTENANCE OF FACILITY                                 (926)        1,000          859          5,000

PRINTING                                            (1,361)          1,500         1,402         1,250 ut bills

ADVERTISING                                             154              250            19         250

VEHICLE MAINTENANCE                                 (1,318)          1,500         3,793         1,500

LICENSE & PERMITS                                       (158)            250        117            250

NATURAL GAS                                         (1,504)          1,500         2,486         3,000

HARDWARE/SOFTWARE MAINTENANCE                       (6,615)          5,000         4,998         5,000
19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                              Page 49
2009 OPERATING BUDGET WORKSHEET

                                                                                                                      Explanations
                                                2007            2008                2008             2009            for significant
                                               ACTUAL          BUDGET              ACTUAL           BUDGET             variances
TOTAL CONTRACTUAL SERVICES                         (42,351)        55,800              55,117           63,300

OFFICE SUPPLIES                                       (172)           500                372               500

OPERATING SUPPLIES                                   (7,321)         6,200              6,305            6,000

VEHICLE PARTS                                         (949)          1,000                  -            1,000

BOOKS & PUBLICATIONS                                    (13)            50                13                50

OFFICE EQUIPMENT                                          -            -                    -              -

FUEL                                                 (4,451)         8,000              7,265            8,000

TOOLS                                                 (622)          1,000              1,083            1,000

SPECIAL EVENTS                                            -             50                43                50

SAFETY EQUIPMENT                                     (1,016)         1,000               452             1,000

FLEET: SUPPLIES & EQUIPMENT                            (195)           200              1,051              250
TOTAL MATERIALS AND SUPPLIES                        (14,739)        18,000             16,584           17,850

LAND & BUILDINGS                                          -            -                    -              -

CAPITAL EQUIPMENT                                    (8,066)        20,410             18,071            8,547

PUBLIC WORKS                                              -         59,750              2,406            7,500
TOTAL CAPITAL OUTLAY                                 (8,066)        80,160             20,477           16,047

DEBT SERVICE - PRINCIPAL                            (20,864)        32,177             18,258           19,536 OWDA Loans #1988/1989

DEBT SERVICE - INTEREST                              (3,598)        14,921              6,259            5,250 OWDA Loans #1988/1989
TOTAL DEBT SERVICE                                  (24,462)        47,098             24,517           24,786

REFUNDS & REIMBURSEMENTS                            (13,206)      15,000.00            13,739           12,000 Repayment of Interfund Loan
                                                                                                                   from GF
TRANSFERS                                                 -                -                -                  -
TOTAL SEWER COLLECTION                           (288,676)       439,336       -    323,152     -    350,924




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                       Page 50
2009 OPERATING BUDGET WORKSHEET

                                                                                                              Explanations
                                                2007             2008           2008          2009            for significant
                                               ACTUAL           BUDGET         ACTUAL        BUDGET             variances


SEWER TREATMENT
WAGES                                             (56,977)          38,000        37,169        38,000                 1,140.00


OVERTIME                                           (1,606)           4,000         2,555         4,000                     120.00


PART-TIME                                          (4,948)           1,487               -         -

EARLY RETIREMENT INCENTIVE                        (12,484)          16,645        16,645         4,161

PENSION                                            (8,600)           8,000         5,892         6,100                     183.00


HEALTH INSURANCE                                  (10,306)          15,100        14,758        15,100                     453.00


LIFE INSURANCE                                          (182)            300        129           300                        9.00


WORKERS COMPENSATION                                    (243)            200        119           200                        6.00


DENTAL INSURANCE                                        (626)        7,500          716           750                       22.50


UNIFORMS                                                (382)        1,100         1,070          500

MEDICARE                                                (472)            550        546           610                       18.30


OTHER PERSONAL SERVICES                                    -             50              -         -

PRE-EMPLOYMENT PHYSICALS                                 (58)            -               -         -

WELLNESS ACTIVITIES                                        -             -               -         -

UNEMPLOYMENT COMPENSATION                                  -             -               -         -

RECRUITMENT & TESTING                                   -               20             -           -
TOTAL PERSONAL SERVICES                           (96,884)          92,952        79,599        69,721                 1,951.80


TRAVEL & TRAINING                                       (165)        1,500         1,172         1,500
TOTAL GENERAL OPERATING                                 (165)        1,500         1,172         1,500

OTHER CONTRACTUAL SERVICES                                 -             -         7,673           -       Storm related


UTILITIES                                                  -             -               -         -

RENTS & LEASES                                          (216)            250        105           250

PROFESSIONAL SERVICES                             (20,335)          31,927        26,380        32,000

INSURANCE                                                  -             -               -         -

MAINTENANCE OF EQUIPMENT                          (10,334)          22,698        17,359        23,000

POSTAGE                                                 (132)            -              12            20

MEMBERSHIPS                                              (63)            100            88        150

TREE TRIMMING/LINE CLEARING/LANDSCAPIN                     -             -               -         -

SOLID WASTE                                       (26,875)          32,500        25,701        32,500

ELECTRIC                                          (61,458)          62,000        75,050        68,000

WATER                                              (1,964)           2,000          571          2,000

SEWER                                              (2,266)           2,300         1,074         2,300

TELEPHONE                                               (585)            600        899          1,000

MAINTENANCE OF FACILITY                            (6,354)           6,500         2,567         6,500

PRINTING                                                   -             -               -         -

ADVERTISING                                                -             -          869            -

VEHICLE MAINTENANCE                                     (439)            500            36        500

LICENSE & PERMITS                                  (2,655)           2,700         2,600         2,700

NATURAL GAS                                                -             -               -         -

HARDWARE/SOFTWARE MAINTENANCE                              -             100        100           200

19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                Page 51
2009 OPERATING BUDGET WORKSHEET

                                                                                                            Explanations
                                                2007            2008            2008         2009          for significant
                                               ACTUAL          BUDGET          ACTUAL       BUDGET           variances
TOTAL CONTRACTUAL SERVICES                        (133,676)       164,175         161,084      171,120

OFFICE SUPPLIES                                        (358)            500          138           500

OPERATING SUPPLIES                                   (8,611)           6,580        5,395        6,600

VEHICLE PARTS                                          (171)            300          152           300

BOOKS & PUBLICATIONS                                      -              -              -          -

OFFICE EQUIPMENT                                          -             600             -          300

FUEL                                                   (875)           1,150         994         1,500

TOOLS                                                     -              -              -          500

SPECIAL EVENTS                                          (61)             50           50           50

SAFETY EQUIPMENT                                     (1,215)            500          593           500

FLEET: SUPPLIES & EQUIPMENT                               -        -                    -          -
TOTAL MATERIALS AND SUPPLIES                        (11,291)           9,680        7,322       10,250

LAND & BUILDINGS                                          -              -              -          -

CAPITAL EQUIPMENT                                   (10,270)           8,500            -       10,000

PUBLIC WORKS                                              -              -              -       96,517
TOTAL CAPITAL OUTLAY                                (10,270)           8,500            -      106,517

DEBT SERVICE - PRINCIPAL                           (141,443)       37,147               -          -     Estimated on Sewer upgrade
                                                                                                         OEPA & OWDA
DEBT SERVICE - INTEREST                              (4,783)       44,875               -          -     Estimated on Sewer upgrade


REFUNDS & REIMBURSEMENTS                                  -              15           25           -

TRANSFERS                                                 -              -              -          -
TOTAL SEWER TREATMENT                            (398,512)       358,844        249,202      359,108

WWTP UPGRADE
PROFESSIONAL SERVICE
PUBLIC WORKS                                                                                2,621,200 Grants & Loans

TOTAL SEWER FUND                                 (687,188)       798,180        572,354     3,331,232




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                             Page 52
2009 OPERATING BUDGET WORKSHEET

                                                                                                                                     Explanations
                                                2007                2008              2008                  2009                     for significant
                                               ACTUAL              BUDGET            ACTUAL                BUDGET                      variances


SOLID WASTE FUND                                                                                                                 Utilities
WAGES                                               (5,210)               5,500                6,585                 6,960 Dave                               208.8


OVERTIME                                                    (87)            150                       50                150                                     4.5


EARLY RETIREMENT INCENTIVE                                    -       -                               -                     -

PENSION                                                 (670)               900                   900                1,031                                    30.93


HEALTH INSURANCE                                    (1,360)               1,400                1,650                 1,400                                      42


LIFE INSURANCE                                              (27)                50                    23                    50                                  1.5


WORKERS COMPENSATION                                    (312)               450                   153                   450                                    13.5


DENTAL INSURANCE                                        (103)               100                   107                   100                                      3


UNIFORMS                                                      -                 80                     -                    -

MEDICARE                                                    (73)                24                    91                104                                    3.12


OTHER PERSONAL SERVICES                                       -             -                          -                    -

PRE-EMPLOYMENT PHYSICALS                                      -             -                          -                    -

WELLNESS ACTIVITIES                                           -             -                          -                    -

UNEMPLOYMENT COMPENSATION                                     -             -                          -                    -

RECRUITMENT & TESTING                                    -                  -                      -                  -
TOTAL PERSONAL SERVICES                             (7,842)               8,654                9,559               10,245                                    307.35


TRAVEL & TRAINING                                   -                            0   ..............        ..............

OTHER CONTRACTUAL SERVICES                          -                            0   ..............        ..............

UTILITIES                                           -                            0   ..............        ..............

RENTS & LEASES                                      -                            0   ..............        ..............

PROFESSIONAL SERVICES                                         -                 3                      -                    -

INSURANCE                                               -                   -        ..............        ..............

MAINTENANCE OF EQUIPMENT                                -                   -        ..............        ..............

POSTAGE                                                 -                   -        ..............        ..............

MEMBERSHIPS                                             -                   -        ..............        ..............

SOLID WASTE (RUMPKE)                              (191,761)           218,470              218,470               218,470

ELECTRIC                                                -                   -        ..............        ..............

WATER                                                   -                   -        ..............        ..............

SEWER                                                   -                   -        ..............        ..............

TELEPHONE                                               -                   -        ..............        ..............

MAINTENANCE OF FACILITY                                 -                   -        ..............        ..............

PRINTING                                                 -              1,200                       -                     -
TOTAL CONTRACTUAL SERVICES                        (191,761)           219,673              218,470               218,470
ADVERTISING                                         -                        0       ..............        ..............

VEHICLE MAINTENANCE                                 -                            0   ..............        ..............

LICENSE & PERMITS                                   -                            0   ..............        ..............

NATURAL GAS                                         -                            0   ..............        ..............

HARDWARE/SOFTWARE                                   -                            0   ..............        ..............

OFFICE SUPPLIES                                     -                            0   ..............        ..............

OPERATING SUPPLIES                                            -             300                        -                300
TOTAL MATERIALS AND SUPPLIES                                  -             300                        -                300
19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                                       Page 53
2009 OPERATING BUDGET WORKSHEET

                                                                                                                        Explanations
                                                2007           2008            2008                  2009               for significant
                                               ACTUAL         BUDGET        ACTUAL                BUDGET                  variances
VEHICLE PARTS                                        -                 0    ..............        ..............
                                                     -
BOOKS & PUBLICATIONS                                 -                 0    ..............        ..............

OFFICE EQUIPMENT                                    -                  0    ..............        ..............

FUEL                                                -                  0    ..............        ..............

TOOLS                                               -                  0    ..............        ..............

SAFETY EQUIPMENT                                    -                  0    ..............        ..............

FLEET: SUPPLIES & EQUIPMENT                         -                  0    ..............        ..............

CAPITAL EQUIPMENT                                         -        5,000                      -
TOTAL CAPITAL OUTLAY                                      -        5,000                      -                    -
PUBLIC WORKS                                        -                   0   ..............        ..............

DEBT SERVICE                                        -                  0    ..............        ..............

REFUNDS & REIMBURSEMENTS                                 11            10                    25                    25
TOTAL SOLID WASTE FUND                           (199,592)      233,637        228,054               229,040

TOTAL ENTERPRISE FUNDS                         (4,048,015)    4,814,550     4,041,956             6,917,727




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                          Page 54
2009 OPERATING BUDGET WORKSHEET

                                                                                                               Explanations
                                                         2007           2008         2008         2009         for significant
                                                        ACTUAL         BUDGET       ACTUAL       BUDGET          variances


TOTAL ALL FUNDS\                                        (7,485,675)    11,953,935   8,862,828    11,972,316




TRANSFERS (in and out)                                   (1,737,186)            -            -             -




OPERATING SUPPLIES                                           -                  -         400          1,500
(flour&sugar for widows at Christmas Transf. From GF)




19-SHARON_BUDGET (Autosaved) (Autosaved).xls                                                                                 Page 55

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:3
posted:7/13/2011
language:English
pages:55