Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

YTD Budget Forecast - PDF by PhilCantillon

VIEWS: 32 PAGES: 11

									GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                    PAGE   1
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    001 GENERAL TOWN

DP DV    ACCTNO              ------ Y E A R - T O - D A T E ------ Y E A R L Y   T O T A L S
    DESCRIPTION                   ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST       VARIANCE


001 0 0010-0000
PROPERTY TAX - CURRENT          612,815.88     590,334   22,481.88     590,334    22,481.88
     MAJOR ACCOUNT TOTALS       612,815.88     590,334   22,481.88     590,334    22,481.88
                                                            103.81 %                 103.81 %


001 0 0011-0000
PROPERTY TAX - PRIOR YEARS          124.77         100       24.77        100         24.77
     MAJOR ACCOUNT TOTALS           124.77         100       24.77        100         24.77
                                                            124.77 %                 124.77 %


001 0 0015-0000
PERSONAL PROPERTY REPL TAX       14,046.31      16,000    1,953.69-    16,000      1,953.69-
     MAJOR ACCOUNT TOTALS        14,046.31      16,000    1,953.69-    16,000      1,953.69-
                                                             87.79 %                  87.79 %


001 0 0025-0000
IN LIEU OF TAXES                    928.01         400      528.01        400        528.01
     MAJOR ACCOUNT TOTALS           928.01         400      528.01        400        528.01
                                                            232.00 %                 232.00 %


001 0 0027-0000
MOBILE HOME TAXES                    57.66          60        2.34-        60          2.34-
     MAJOR ACCOUNT TOTALS            57.66          60        2.34-        60          2.34-
                                                             96.10 %                  96.10 %


001 0 0130-0000
INTEREST INCOME                   5,725.93      18,000   12,274.07-    18,000     12,274.07-
     MAJOR ACCOUNT TOTALS         5,725.93      18,000   12,274.07-    18,000     12,274.07-
                                                             31.81 %                  31.81 %


001 0 0250-0000
MISCELLANEOUS INCOME                  4.30           0        4.30          0          4.30
     MAJOR ACCOUNT TOTALS             4.30           0        4.30          0          4.30
                                                               .00 %                    .00 %
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                    PAGE   2
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    001 GENERAL TOWN

DP DV    ACCTNO              ------ Y E A R - T O - D A T E ------ Y E A R L Y   T O T A L S
    DESCRIPTION                   ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST       VARIANCE

       DIVISION TOTALS          633,702.86     624,894    8,808.86     624,894     8,808.86
                                                            101.41 %                 101.41 %

         DEPARTMENT TOTALS                     624,894                 624,894
                                633,702.86                8,808.86                 8,808.86
                                                            101.41 %                 101.41 %
            REVENUE TOTALS                     624,894                 624,894
                                633,702.86                8,808.86                 8,808.86
                                                            101.40 %                 101.40 %
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                    PAGE   1
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    001 GENERAL TOWN

DP DV    ACCTNO             ------ Y E A R - T O - D A T E ------ Y E A R L Y    T O T A L S
    DESCRIPTION                  ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST        VARIANCE


001 1 1100-1100
SUPERVISOR'S SALARY              45,924.48      46,200      275.52-    46,200        275.52-
001 1 1100-1102
CLERK'S SALARY                    4,418.73       4,500       81.27-     4,500         81.27-
001 1 1100-1103
BOARD'S SALARY                    3,066.71       3,400      333.29-     3,400        333.29-
001 1 1100-1200
SALARIES - OTHERS                43,185.36      44,000      814.64-    44,000        814.64-
001 1 1100-1800
HEALTH INSURANCE                 13,674.00      14,000      326.00-    14,000        326.00-
001 1 1100-1850
I.M.R.F.                         11,217.85      11,225        7.15-    11,225          7.15-
001 1 1100-1851
FICA                              7,010.00       7,627      617.00-     7,627        617.00-
001 1 1100-1900
UNEMPLOYMENT COMPENSATION INS       472.10         473         .90-        473          .90-
     MAJOR ACCOUNT TOTALS       128,969.23     131,425    2,455.77-    131,425     2,455.77-
                                                             98.13 %                  98.13 %


001 1 1200-2020
OFFICE SUPPLIES                   1,080.34       1,081         .66-     1,081           .66-
001 1 1200-2030
MISCELLANEOUS EXPENSE                  .00          50       50.00-        50         50.00-
     MAJOR ACCOUNT TOTALS         1,080.34       1,131       50.66-     1,131         50.66-
                                                             95.52 %                  95.52 %


001 1 1300-3010
DUES AND SUBSCRIPTIONS              966.04       1,019       52.96-     1,019         52.96-
001 1 1300-3020
TRAVEL                                 .00          50       50.00-        50         50.00-
001 1 1300-3030
TRAINING                               .00         150      150.00-       150        150.00-
001 1 1300-3116
LEGAL                            12,276.50      13,000      723.50-    13,000        723.50-
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                    PAGE   2
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    001 GENERAL TOWN

DP DV    ACCTNO             ------ Y E A R - T O - D A T E ------ Y E A R L Y    T O T A L S
    DESCRIPTION                  ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST        VARIANCE


001 1 1300-3210
MAINTENANCE - EQUIPMENT             696.89       1,000      303.11-     1,000        303.11-
001 1 1300-3212
MAINT.-BLDGS. AND GROUNDS        25,449.55      25,450         .45-    25,450           .45-
001 1 1300-3220
VEHICLE SERVICE                        .00         550      550.00-       550        550.00-
001 1 1300-3400
ACCT. & AUDITING SERVICES         3,870.00       4,000      130.00-     4,000        130.00-
001 1 1300-3447
COMPUTER SERVICE                     75.00         400      325.00-       400        325.00-
001 1 1300-3750
UTILITIES                         4,156.73       4,157         .27-     4,157           .27-
001 1 1300-3920
GENERAL INSURANCE                 7,453.00       7,875      422.00-     7,875        422.00-
     MAJOR ACCOUNT TOTALS        54,943.71      57,651    2,707.29-    57,651      2,707.29-
                                                             95.30 %                  95.30 %


001 1 1400-4350
EQUIPMENT PURCHASES                 191.45       1,000      808.55-     1,000        808.55-
001 1 1400-4370
VEHICLE PURCHASE                 19,126.65      24,343    5,216.35-    24,343      5,216.35-
001 1 1400-4375
CARLE PROPERTY TAX REFUND              .00      50,000   50,000.00-    50,000     50,000.00-
     MAJOR ACCOUNT TOTALS        19,318.10      75,343   56,024.90-    75,343     56,024.90-
                                                             25.64 %                  25.64 %

       DIVISION TOTALS          204,311.38     265,550   61,238.62-    265,550    61,238.62-
                                                             76.94 %                  76.94 %
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                    PAGE   3
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    001 GENERAL TOWN

DP DV    ACCTNO             ------ Y E A R - T O - D A T E ------ Y E A R L Y    T O T A L S
    DESCRIPTION                  ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST        VARIANCE


001 2 1100-1101
ASSESSOR'S SALARY                49,719.84      49,720         .16-    49,720           .16-
001 2 1100-1200
SALARIES - OTHERS               127,038.24     130,000    2,961.76-    130,000     2,961.76-
001 2 1100-1800
HEALTH INSURANCE                 27,348.00      28,000      652.00-    28,000        652.00-
001 2 1100-1850
I.M.R.F.                         17,890.95      18,000      109.05-    18,000        109.05-
001 2 1100-1851
FICA                             12,475.15      13,773    1,297.85-    13,773      1,297.85-
001 2 1100-1900
UNEMPLOYMENT COMPENSATION INS     1,426.04       1,427         .96-      1,427          .96-
     MAJOR ACCOUNT TOTALS       235,898.22     240,920    5,021.78-    240,920     5,021.78-
                                                             97.92 %                  97.92 %


001 2 1200-2020
OFFICE SUPPLIES                   1,150.11       1,200       49.89-     1,200         49.89-
001 2 1200-2030
MISCELLANEOUS EXPENSE                  .00          20       20.00-        20         20.00-
     MAJOR ACCOUNT TOTALS         1,150.11       1,220       69.89-     1,220         69.89-
                                                             94.27 %                  94.27 %


001 2 1300-3010
DUES AND SUBSCRIPTIONS            2,554.65       3,100      545.35-     3,100        545.35-
001 2 1300-3020
TRAVEL                              423.43         500       76.57-       500         76.57-
001 2 1300-3030
TRAINING                          1,937.31       3,941    2,003.69-     3,941      2,003.69-
001 2 1300-3140
JANITOR SERVICES                  1,338.00       1,338         .00      1,338           .00
001 2 1300-3210
MAINTENANCE - EQUIPMENT           1,058.65       1,059         .35-     1,059           .35-
001 2 1300-3220
VEHICLE SERVICE                        .00       1,000    1,000.00-     1,000      1,000.00-
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                    PAGE   4
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    001 GENERAL TOWN

DP DV    ACCTNO             ------ Y E A R - T O - D A T E ------ Y E A R L Y    T O T A L S
    DESCRIPTION                  ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST        VARIANCE


001 2 1300-3410
POSTAGE                           2,859.08       4,500    1,640.92-     4,500      1,640.92-
001 2 1300-3430
PRINTING                          1,331.94       1,500      168.06-     1,500        168.06-
001 2 1300-3445
APPRAISALS                             .00       3,700    3,700.00-     3,700      3,700.00-
001 2 1300-3447
COMPUTER SERVICE                 10,702.13      13,000    2,297.87-    13,000      2,297.87-
001 2 1300-3930
TELEPHONE                         3,188.56       3,300      111.44-     3,300        111.44-
     MAJOR ACCOUNT TOTALS        25,393.75      36,938   11,544.25-    36,938     11,544.25-
                                                             68.75 %                  68.75 %


001 2 1400-4350
EQUIPMENT PURCHASES                    .00       3,000    3,000.00-     3,000      3,000.00-
001 2 1400-4375
CARLE PROPERTY TAX REFUND              .00      50,000   50,000.00-    50,000     50,000.00-
     MAJOR ACCOUNT TOTALS              .00      53,000   53,000.00-    53,000     53,000.00-
                                                               .00 %                    .00 %

       DIVISION TOTALS          262,442.08     332,078   69,635.92-    332,078    69,635.92-
                                                             79.03 %                  79.03 %
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                     PAGE   5
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    001 GENERAL TOWN

DP DV    ACCTNO              ------ Y E A R - T O - D A T E ------ Y E A R L Y    T O T A L S
    DESCRIPTION                   ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST        VARIANCE


001 3 1300-4026
A WOMAN'S FUND                   14,000.00      14,000          .00     14,000           .00
001 3 1300-4030
CRISIS NURSERY                   16,500.00      16,500          .00     16,500           .00
001 3 1300-4031
HOMESTEAD CORPORATION             5,000.00       5,000          .00      5,000           .00
001 3 1300-4032
THE READING GROUP-SCHOLARSHIP     4,000.00       4,000          .00      4,000           .00
001 3 1300-4033
CHAMP COUNTY OPERATION SNOWBA     3,100.00       3,100          .00      3,100           .00
001 3 1300-4034
CUAP                              2,900.00       2,900          .00      2,900           .00
001 3 1300-4035
DON MOYER BOYS & GIRLS CLUB      12,000.00      12,000          .00     12,000           .00
001 3 1300-4036
FRANCES NELSON/CHIC              11,000.00      11,000          .00     11,000           .00
001 3 1300-4037
GCAP                              4,000.00       4,000          .00      4,000           .00
001 3 1300-4038
MARILYN QUELLER CHILD CARE CE     1,000.00       1,000          .00      1,000           .00
001 3 1300-4080
PACE PERSONAL ASSISTANCE          6,530.00       6,500        30.00      6,500         30.00
     MAJOR ACCOUNT TOTALS        80,030.00      80,000        30.00     80,000         30.00
                                                             100.04 %                 100.04 %

       DIVISION TOTALS           80,030.00      80,000        30.00     80,000         30.00
                                                             100.04 %                 100.04 %

         DEPARTMENT TOTALS                     677,628                  677,628
                                546,783.46               130,844.54-              130,844.54-
                                                              80.69 %                  80.69 %
            EXPENSE TOTALS                     677,628                  677,628
                                546,783.46               130,844.54-              130,844.54-
                                                              80.69 %                  80.69 %
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                      PAGE   1
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    002 GENERAL ASSISTANCE

DP DV    ACCTNO              ------ Y E A R - T O - D A T E ------ Y E A R L Y     T O T A L S
    DESCRIPTION                   ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST         VARIANCE


002 0 0010-0000
PROPERTY TAX - CURRENT          450,663.01     462,383    11,719.99-    462,383     11,719.99-
     MAJOR ACCOUNT TOTALS       450,663.01     462,383    11,719.99-    462,383     11,719.99-
                                                              97.47 %                   97.47 %


002 0 0011-0000
PROPERTY TAX - PRIOR YEARS           97.71          80        17.71           80        17.71
     MAJOR ACCOUNT TOTALS            97.71          80        17.71           80        17.71
                                                             122.14 %                  122.14 %


002 0 0015-0000
PERSONAL PROPERTY REPL TAX       14,046.34      16,000     1,953.66-    16,000       1,953.66-
     MAJOR ACCOUNT TOTALS        14,046.34      16,000     1,953.66-    16,000       1,953.66-
                                                              87.79 %                   87.79 %


002 0 0025-0000
IN LIEU OF TAX                      727.10         300       427.10          300       427.10
     MAJOR ACCOUNT TOTALS           727.10         300       427.10          300       427.10
                                                             242.37 %                  242.37 %


002 0 0027-0000
MOBILE HOME TAXES                    45.16          50         4.84-          50         4.84-
     MAJOR ACCOUNT TOTALS            45.16          50         4.84-          50         4.84-
                                                              90.32 %                   90.32 %


002 0 0130-0000
INTEREST INCOME                   7,088.86      20,000    12,911.14-    20,000      12,911.14-
     MAJOR ACCOUNT TOTALS         7,088.86      20,000    12,911.14-    20,000      12,911.14-
                                                              35.44 %                   35.44 %


002 0 0250-0000
MISCELLANEOUS INCOME             13,521.76      20,000     6,478.24-    20,000       6,478.24-
     MAJOR ACCOUNT TOTALS        13,521.76      20,000     6,478.24-    20,000       6,478.24-
                                                              67.61 %                   67.61 %

       DIVISION TOTALS          486,189.94     518,813    32,623.06-    518,813     32,623.06-
                                                              93.71 %                   93.71 %

         DEPARTMENT TOTALS                     518,813                  518,813
                                486,189.94                32,623.06-                32,623.06-
                                                              93.71 %                   93.71 %
            REVENUE TOTALS                     518,813                  518,813
                                486,189.94                32,623.06-                32,623.06-
                                                              93.71 %                   93.71 %
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                     PAGE   1
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    002 GENERAL ASSISTANCE

DP DV    ACCTNO             ------ Y E A R - T O - D A T E ------ Y E A R L Y     T O T A L S
    DESCRIPTION                  ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST         VARIANCE


002 1 1100-1200
SALARIES                         55,133.64      55,753       619.36-    55,753        619.36-
002 1 1100-1800
EMPLOYEE INSURANCE               10,620.00      10,620          .00     10,620           .00
002 1 1100-1850
I.M.R.F.                          5,616.86       5,617          .14-     5,617           .14-
002 1 1100-1851
FICA                              4,190.37       4,400       209.63-     4,400        209.63-
002 1 1100-1900
UNEMPLOYMENT COMPENSATION INS     1,309.12       1,310          .88-     1,310           .88-
     MAJOR ACCOUNT TOTALS        76,869.99      77,700       830.01-    77,700        830.01-
                                                              98.93 %                  98.93 %


002 1 1200-2020
OFFICE SUPPLIES                   1,061.77       1,062          .23-     1,062           .23-
002 1 1200-2030
MISCELLANEOUS EXPENSE                  .00          20        20.00-         20        20.00-
002 1 1200-2040
WORK/TRAINING SUPPLIES               15.00         500       485.00-       500        485.00-
     MAJOR ACCOUNT TOTALS         1,076.77       1,582       505.23-     1,582        505.23-
                                                              68.06 %                  68.06 %


002 1 1300-3010
DUES AND SUBSCRIPTIONS               50.00          75        25.00-         75        25.00-
002 1 1300-3020
TRAVEL                               71.62          75         3.38-         75         3.38-
002 1 1300-3030
TRAINING                               .00          88        88.00-         88        88.00-
002 1 1300-3050
MEDICAL CARE                    130,422.37     145,000    14,577.63-    145,000    14,577.63-
002 1 1300-3070
PERSONAL ALLOWANCES             168,492.62     172,000     3,507.38-    172,000     3,507.38-
002 1 1300-3140
JANITOR SERVICE                   4,014.00       4,500       486.00-     4,500        486.00-
GL55         DATE 7/09/09                    BUDGET AND FORECAST REPORT                      PAGE   2
          PERIOD 7/01/2008 TO    6/30/2009       CUNNINGHAM TOWNSHIP
                                                    002 GENERAL ASSISTANCE

DP DV    ACCTNO              ------ Y E A R - T O - D A T E ------ Y E A R L Y     T O T A L S
    DESCRIPTION                   ACTUAL   BUDG/FORCST   VARIANCE BUDG/FORCST         VARIANCE


002 1 1300-3210
MAINTENANCE - EQUIPMENT             732.42       1,000       267.58-     1,000         267.58-
002 1 1300-3220
VEHICLE SERVICE                        .00         500       500.00-         500       500.00-
002 1 1300-3410
POSTAGE                             174.80       4,000     3,825.20-     4,000       3,825.20-
002 1 1300-3430
PRINTING                            720.42       1,500       779.58-     1,500         779.58-
002 1 1300-3447
COMPUTER SERVICES                      .00         300       300.00-         300       300.00-
002 1 1300-3750
UTILITIES                         2,440.93       3,500     1,059.07-     3,500       1,059.07-
002 1 1300-3930
TELEPHONE                         3,404.10       3,500        95.90-      3,500         95.90-
     MAJOR ACCOUNT TOTALS       310,523.28     336,038    25,514.72-    336,038     25,514.72-
                                                              92.41 %                   92.41 %


002 1 1400-3400
ACCOUNTING & AUDITING             4,000.00       4,000          .00      4,000            .00
002 1 1400-4350
EQUIPMENT PURCHASES               1,370.00       1,500       130.00-     1,500         130.00-
002 1 1400-4375
CARLE PROPERTY TAX REFUND              .00     100,000   100,000.00-    100,000    100,000.00-
     MAJOR ACCOUNT TOTALS         5,370.00     105,500   100,130.00-    105,500    100,130.00-
                                                               5.09 %                    5.09 %

       DIVISION TOTALS          393,840.04     520,820   126,979.96-    520,820    126,979.96-
                                                              75.62 %                   75.62 %

         DEPARTMENT TOTALS                     520,820                  520,820
                                393,840.04               126,979.96-               126,979.96-
                                                              75.62 %                   75.62 %
            EXPENSE TOTALS                     520,820                  520,820
                                393,840.04               126,979.96-               126,979.96-
                                                              75.61 %                   75.61 %
FINAL TOTALS                 54,741                  54,741
               179,269.30-            234,010.30-             234,010.30-
                                          327.49-%                327.49-%

								
To top