YTD Budget Forecast - PDF
Document Sample


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-%
Related docs
Get documents about "