Date: 6/03/2009 CITY OF JACKSON Page: 1 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 31111 I I I I I I I I CURRENT TAXES GENERAL FNDI 19925147.00I -19973391.41I 21833789.00I 1908642.00I 9.57% I I I I I I I I I I I CURRENT TAXES GENERAL FUNI 19925147.00I -19973391.41I 21833789.00I 1908642.00I 9.57% I I I I I I I I I I I 31100 I I I I I I I I R.E. TAXES 2000 I 3035.00I -3674.86I 2039.00I -996.00I -32.81% I I I 31101 I I I I I I I I R.E. TAXES 2001 I 3098.00I -2085.59I 3336.00I 238.00I 7.68% I I I 31102 I I I I I I I I R.E. TAXES 2002 I 6573.00I -4568.14I 5187.00I -1386.00I -21.08% I I I 31103 I I I I I I I I R.E. TAXES 2003 I 9892.00I -4762.83I 6606.00I -3286.00I -33.21% I I I 31104 I I I I I I I I R.E. TAXES 2004 I 9173.00I -6805.47I 7671.00I -1502.00I -16.37% I I I 31105 I I I I I I I I R.E. TAXES 2005 I 41914.00I -21127.56I 28986.00I -12928.00I -30.84% I I I 31106 I I I I I I I I R.E. TAXES 2006 I 115602.00I -80208.80I 27923.00I -87679.00I -75.84% I I I 31107 I I I I I I I I R.E. TAXES 2007 I 555698.00I -589194.92I 155060.00I -400638.00I -72.09% I I I 31108 I I I I I I I I R.E. TAXES 2008 I 0.00I 0.00I 707673.00I 707673.00I 100.00% I I I 31197 I I I I I I I I R. E. TAXES 1997 I 1243.00I -4156.98I 0.00I -1243.00I -100.00% I I I 31198 I I I I I I I I R. E. TAXES 1998 I 1867.00I -1256.82I 1228.00I -639.00I -34.22% I I I 31199 I I I I I I I I R. E. TAXES 1999 I 2137.00I -1718.22I 2328.00I 191.00I 8.93% I I I I I I I I I I I TOTAL R.E. TAXES I 750232.00I -719560.19I 948037.00I 197805.00I 26.36% I I I I I I I I I I I 31310 I I I I I I I I INTEREST/PENALTIES R.E. TI 550000.00I -421888.06I 550000.00I 0.00I 0.00% I I I 31330 I I I I I I I I ATTY FEES-DELINQ. R.E. TAI 70000.00I 0.00I 0.00I -70000.00I -100.00% I I I I I I I I I I I INTEREST/PENALTY R.E TAXEI 620000.00I -421888.06I 550000.00I -70000.00I -11.29% I I I I I I I I I I I 31510 I I I I I I I I PILOT-IDB TAX LIEU I 218000.00I -170208.76I 300530.00I 82530.00I 37.85% I I I Date: 6/03/2009 CITY OF JACKSON Page: 2 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 31511 I I I I I I I I TAX EQ.-ELECTRIC I 1838462.00I -1784518.48I 1968256.00I 129794.00I 7.05% I I I 31512 I I I I I I I I LIEU TAX WATER I 207826.00I -243862.03I 222498.00I 14672.00I 7.05% I I I 31513 I I I I I I I I TAX EQUIV.-WESLEY I 3597.00I -4500.00I 3851.00I 254.00I 7.06% I I I 31514 I I I I I I I I TAX EQ.-GAS I 919231.00I -879228.07I 984128.00I 64897.00I 7.05% I I I 31515 I I I I I I I I TAX EQ.-JHA(HOUSING) I 12789.00I 0.00I 13692.00I 903.00I 7.06% I I I 31516 I I I I I I I I TAX EQ.-ST. MARY MANOR I 4316.00I -5400.00I 4621.00I 305.00I 7.06% I I I I I I I I I I I TAX EQUIVALENT I 3204221.00I -3087717.34I 3497576.00I 293355.00I 9.15% I I I I I I I I I I I 31610 I I I I I I I I LOCAL SALES TAX I 11476187.00I -9540754.99I 11246480.00I -229707.00I -2.00% I I I 31710 I I I I I I I I CITY BEER TAX I 1700000.00I -1498242.64I 1630000.00I -70000.00I -4.11% I I I 31720 I I I I I I I I WHOLESALE LIQUOR TAX I 490000.00I -468537.01I 470000.00I -20000.00I -4.08% I I I 31800 I I I I I I I I BUSINESS TAX I 1500000.00I -1418622.03I 1425000.00I -75000.00I -5.00% I I I 31830 I I I I I I I I BUSINESS LICENSE PENT & II 25000.00I -25514.42I 25000.00I 0.00I 0.00% I I I 31912 I I I I I I I I CATV-CHARTER REVENUE I 380000.00I -339363.36I 380000.00I 0.00I 0.00% I I I 31913 I I I I I I I I CATV-JEA REVENUE I 420000.00I -350384.19I 420000.00I 0.00I 0.00% I I I 31920 I I I I I I I I HOTEL - MOTEL TAX I 390000.00I -282297.52I 390000.00I 0.00I 0.00% I I I 31980 I I I I I I I I MIXED DRINK TAXES I 50000.00I -44489.00I 50000.00I 0.00I 0.00% I I I I I I I I I I I VARIOUS TAXES I 16431187.00I -13968205.16I 16036480.00I -394707.00I -2.40% I I I I I I I I I I I 32110 I I I I I I I I CITY STKERS (AUTO REGSTR I 1050000.00I -890818.04I 1000000.00I -50000.00I -4.76% I I I 32300 I I I I I I I I LOCAL BEER PRIVILEGE TAX I 35000.00I -19066.00I 25000.00I -10000.00I -28.57% I I I 32310 I I I I I I I I CHAUFFEURS LICENSE I 250.00I -225.00I 250.00I 0.00I 0.00% I I I Date: 6/03/2009 CITY OF JACKSON Page: 3 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 32349 I I I I I I I I LIQUOR APPLIC FEE I 500.00I 0.00I 500.00I 0.00I 0.00% I I I I I I I I I I I LICENSES & FEES I 1085750.00I -910109.04I 1025750.00I -60000.00I -5.52% I I I I I I I I I I I 32410 I I I I I I I I TRADESMAN LICENSE FEES I 70000.00I -66180.00I 70000.00I 0.00I 0.00% I I I 32610 I I I I I I I I BUILDING PERMITS I 350000.00I -354365.13I 325000.00I -25000.00I -7.14% I I I 32611 I I I I I I I I BLDG/PROPERTY LIENS I 0.00I -3423.44I 10650.00I 10650.00I 100.00% I I I 32615 I I I I I I I I PLANS REVIEW I 140000.00I -129339.90I 140000.00I 0.00I 0.00% I I I 32620 I I I I I I I I ELECTRIC PERMITS I 55000.00I -52447.50I 50000.00I -5000.00I -9.09% I I I 32630 I I I I I I I I PLUMBING PERMITS I 55000.00I -35057.50I 50000.00I -5000.00I -9.09% I I I 32640 I I I I I I I I GAS PERMITS I 25000.00I -14506.00I 20000.00I -5000.00I -20.00% I I I 32670 I I I I I I I I MECHANICAL PERMITS I 40000.00I -37345.50I 38000.00I -2000.00I -5.00% I I I 32680 I I I I I I I I SIGN PERMITS I 20000.00I -11569.00I 18000.00I -2000.00I -10.00% I I I 32681 I I I I I I I I VIE EVALUATION FEE I 1700.00I -1150.00I 1000.00I -700.00I -41.17% I I I 32682 I I I I I I I I SITE PLAN REVIEW FEE I 3000.00I -2325.00I 2000.00I -1000.00I -33.33% I I I 32683 I I I I I I I I LANDSCAPE REVIEW FEE I 1300.00I -1000.00I 1000.00I -300.00I -23.07% I I I I I I I I I I I BUILDING & RELATED PERMITI 761000.00I -708708.97I 725650.00I -35350.00I -4.64% I I I I I I I I I I I 32692 I I I I I I I I CODE I 7000.00I -6750.00I 1000.00I -6000.00I -85.71% I I I 32694 I I I I I I I I INVESTIGATION FEES - BEERI 15500.00I -10500.00I 10000.00I -5500.00I -35.48% I I I 32695 I I I I I I I I ZONING APPLICATION FES-PLI 4725.00I -5250.00I 3750.00I -975.00I -20.63% I I I 32696 I I I I I I I I SUB-DIVISION REVIEW FEES-I 4725.00I -2550.00I 2325.00I -2400.00I -50.79% I I I I I I I I I I I VARIOUS FEES I 31950.00I -25050.00I 17075.00I -14875.00I -46.55% I I I I I I I I I I I Date: 6/03/2009 CITY OF JACKSON Page: 4 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 33108 I I I I I I I I FEMA: TORNADO 2008 I 501000.00I -424678.14I 0.00I -501000.00I -100.00% I I I 33126 I I I I I I I I SART GRANT REVENUE I 80000.00I -30975.11I 80000.00I 0.00I 0.00% I I I 33127 I I I I I I I I 2006 METH GRANT I 150000.00I -24881.21I 80000.00I -70000.00I -46.66% I I I 33129 I I I I I I I I ACT GRANT I 74734.00I -37207.46I 24300.00I -50434.00I -67.48% I I I 33131 I I I I I I I I 2008 BYRNE GRANT FOR DRUGI 44240.00I -28408.25I 44240.00I 0.00I 0.00% I I I 33132 I I I I I I I I 2007 METH INITIATIVE GRANI 420000.00I -27491.25I 350000.00I -70000.00I -16.66% I I I 33141 I I I I I I I I DRUG COURT GRANT I 50000.00I -28366.06I 50000.00I 0.00I 0.00% I I I 33147 I I I I I I I I 2004 COPS TECH GRANT I 350000.00I -520.36I 0.00I -350000.00I -100.00% I I I 33148 I I I I I I I I BYRNE GRANT-DRUG COURT I 0.00I 0.00I 27985.00I 27985.00I 100.00% I I I 33149 I I I I I I I I 2006 COPS TECH GRANT I 268685.58I -2250.00I 0.00I -268685.58I -100.00% I I I 33150 I I I I I I I I JUVENILE & NEIGHB SAFE PRI 715479.00I -36132.36I 551276.38I -164202.62I -22.95% I I I 33151 I I I I I I I I EDI GRANT-DEPT OF HOUSINGI 173967.00I 0.00I 0.00I -173967.00I -100.00% I I I 33152 I I I I I I I I BROWNSFIELD CLEANUP GRANTI 200000.00I -15360.65I 186345.51I -13654.49I -6.82% I I I 33195 I I I I I I I I 2005 JAG GRANT I 21500.00I -18706.00I 0.00I -21500.00I -100.00% I I I 33196 I I I I I I I I 2006 JAG GRANT I 20000.00I -1691.20I 2200.00I -17800.00I -89.00% I I I 33198 I I I I I I I I 2008 EDWARD BYRNE MEM JAGI 26721.00I -12500.00I 14221.00I -12500.00I -46.77% I I I 33199 I I I I I I I I 2007 BYRNE JAG GRANT I 60000.00I 37937.60I 18700.00I -41300.00I -68.83% I I I I I I I I I I I FEDERAL GRANTS I 3156326.58I -651230.45I 1429267.89I -1727058.69I -54.71% I I I I I I I I I I I 33410 I I I I I I I I ST LAW ENFORCEMENT EDUC SI 126600.00I -112200.00I 125400.00I -1200.00I -0.94% I I I 33420 I I I I I I I I ST FIRE PROTECTION EDUC SI 111600.00I -85200.00I 85200.00I -26400.00I -23.65% I I I Date: 6/03/2009 CITY OF JACKSON Page: 5 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 33433 I I I I I I I I DIRECT ALLOCATION-STATE GI 50000.00I -50000.00I 0.00I -50000.00I -100.00% I I I 33491 I I I I I I I I CARFP: SNACK FOOD I 5000.00I -3515.92I 3500.00I -1500.00I -30.00% I I I 33493 I I I I I I I I ANDERSON CREEK TRAIL GRANI 52455.00I 0.00I 0.00I -52455.00I -100.00% I I I 37993 I I I I I I I I ST OF TN:MUNICIPAL PLN OFI 175000.00I -54422.46I 207000.00I 32000.00I 18.28% I I I 37994 I I I I I I I I DOT: TRANSP/PLANNING PROJI 95000.00I -97889.44I 1000000.00I 905000.00I 952.63% I I I I I I I I I I I STATE GRANTS I 615655.00I -403227.82I 1421100.00I 805445.00I 130.82% I I I I I I I I I I I 31517 I I I I I I I I STATE EXCISE TAX I 175000.00I -225328.32I 134137.00I -40863.00I -23.35% I I I 31930 I I I I I I I I STATE MIXED DRINK TAXES I 300000.00I -250748.96I 297180.00I -2820.00I -0.94% I I I 31941 I I I I I I I I ST REIMB-TDOT-SSA I 220000.00I -204121.89I 206674.08I -13325.92I -6.05% I I I 33510 I I I I I I I I STATE SALES TAX I 4400000.00I -2985951.91I 3760400.00I -639600.00I -14.53% I I I 33520 I I I I I I I I STATE INCOME TAX I 440000.00I -537.11I 385044.00I -54956.00I -12.49% I I I 33530 I I I I I I I I STATE BEER TAX I 20000.00I -31110.19I 19252.00I -748.00I -3.74% I I I 33551 I I I I I I I I GAS,MOTOR FUEL,ADDL 3-CNTI 1600000.00I -1157306.67I 1329720.00I -270280.00I -16.89% I I I 33580 I I I I I I I I SP PETROLEUM PRODUCTS (88I 100000.00I -96110.17I 93120.00I -6880.00I -6.88% I I I 33591 I I I I I I I I STATE TVA GROSS RECEIPTS I 545000.00I -430136.52I 554374.00I 9374.00I 1.72% I I I I I I I I I I I STATE REVENUE ALLOCATIONSI 7800000.00I -5381351.74I 6779901.08I -1020098.92I -13.07% I I I I I I I I I I I 34121 I I I I I I I I BUSINESS TAX CLERKS FEE I 5000.00I -12801.05I 15000.00I 10000.00I 200.00% I I I I I I I I I I I BUSINESS TAX CLERK FEES I 5000.00I -12801.05I 15000.00I 10000.00I 200.00% I I I I I I I I I I I 34125 I I I I I I I I HANDLING FEES I 4000.00I -4672.50I 4500.00I 500.00I 12.50% I I I Date: 6/03/2009 CITY OF JACKSON Page: 6 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 34138 I I I I I I I I PLANNING EXPENSES:3-WAY I 400.00I -200.00I 200.00I -200.00I -50.00% I I I 34139 I I I I I I I I PLN SERV:MAD CO I 26000.00I -20000.00I 25500.00I -500.00I -1.92% I I I 34221 I I I I I I I I FIRE REPORTS I 350.00I -306.00I 100.00I -250.00I -71.42% I I I 34293 I I I I I I I I FIRE TRAINING FEES I 20000.00I -28700.00I 20000.00I 0.00I 0.00% I I I 37302 I I I I I I I I HOUSE/BUILDING DEMOLITIONI 0.00I -18554.97I 0.00I 0.00I 0.00% I I I I I I I I I I I CHARGES FOR SERVICES I 50750.00I -72433.47I 50300.00I -450.00I -0.88% I I I I I I I I I I I 31940 I I I I I I I I SIDEWALK REPAIRS I 0.00I 0.00I 2000.00I 2000.00I 100.00% I I I 32650 I I I I I I I I DEVELOPMENT PERMITS/ENG I 8375.00I -6882.00I 7000.00I -1375.00I -16.41% I I I 32690 I I I I I I I I MOVING PERMITS I 75.00I -225.00I 75.00I 0.00I 0.00% I I I 34311 I I I I I I I I ENG. PERMIT FEES,STREET,DI 40000.00I -31769.56I 40000.00I 0.00I 0.00% I I I 34315 I I I I I I I I TRAFFIC SIGN/MISC. REVENUI 6000.00I 0.00I 3000.00I -3000.00I -50.00% I I I 34317 I I I I I I I I ENGINEERING - MISC REVENUI 500.00I -220.00I 300.00I -200.00I -40.00% I I I 34318 I I I I I I I I ENG REVIEW FEES-COUNTY S/I 2350.00I -1600.00I 1500.00I -850.00I -36.17% I I I 34319 I I I I I I I I ENG REVIEW FEES-CITY SUBDI 5300.00I -9450.00I 9500.00I 4200.00I 79.24% I I I 34320 I I I I I I I I STORMWATER REIMB I 1000.00I 0.00I 500.00I -500.00I -50.00% I I I 36531 I I I I I I I I SALE OF STREET MATERIALS I 0.00I -2550.90I 2500.00I 2500.00I 100.00% I I I I I I I I I I I STREET CHARGES FOR SERVICI 63600.00I -52697.46I 66375.00I 2775.00I 4.36% I I I I I I I I I I I 34795 I I I I I I I I SRS ACTIVITY/CLASS FEES I 1416.00I -178.00I 0.00I -1416.00I -100.00% I I I I I I I I I I I PROGRAM INCOME I 1416.00I -178.00I 0.00I -1416.00I -100.00% I I I I I I I I I I I Date: 6/03/2009 CITY OF JACKSON Page: 7 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 35100 I I I I I I I I CITY COURT REVENUE I 550000.00I -587473.03I 625000.00I 75000.00I 13.63% I I I 35101 I I I I I I I I ENVIRONMENTAL COURT REVENI 0.00I -12047.17I 16000.00I 16000.00I 100.00% I I I 35103 I I I I I I I I INTERPRETING FEES I 1500.00I -1301.50I 0.00I -1500.00I -100.00% I I I 35105 I I I I I I I I DRUG LITIGATION TAX I 95000.00I -106326.50I 100000.00I 5000.00I 5.26% I I I 35106 I I I I I I I I DRUG COURT FEES I 2500.00I -2420.00I 2500.00I 0.00I 0.00% I I I 35110 I I I I I I I I CITY JAIL & OFFICERS FEESI 1500.00I -2157.75I 1500.00I 0.00I 0.00% I I I 35210 I I I I I I I I SEIZURES I 0.00I -5528.44I 3000.00I 3000.00I 100.00% I I I I I I I I I I I FINES AND FORFEITURES I 650500.00I -717254.39I 748000.00I 97500.00I 14.98% I I I I I I I I I I I 34210 I I I I I I I I POLICE SECURITY I 199500.00I -218768.31I 244000.00I 44500.00I 22.30% I I I 34230 I I I I I I I I POLICE STORAGE FEES (VEHII 400.00I 0.00I 0.00I -400.00I -100.00% I I I 34240 I I I I I I I I ACCIDENT REPORT FEES I 26000.00I -23047.85I 6825.00I -19175.00I -73.75% I I I 34290 I I I I I I I I DRIVER IMPROVMNT PROG FEEI 14000.00I -6295.00I 8000.00I -6000.00I -42.85% I I I 35000 I I I I I I I I POLICE REVENUE I 2000.00I -75.00I 0.00I -2000.00I -100.00% I I I 35102 I I I I I I I I PHOTO ENFORCEMENT I 210000.00I -202720.00I 210000.00I 0.00I 0.00% I I I 35120 I I I I I I I I PARKING TICKETS I 65000.00I -55738.05I 59000.00I -6000.00I -9.23% I I I 35121 I I I I I I I I CITY STICKER TICKETS I 32500.00I -55600.00I 50000.00I 17500.00I 53.84% I I I 35214 I I I I I I I I FED EQUITABLE SHARE-SEIZEI 0.00I -14.42I 0.00I 0.00I 0.00% I I I 35361 I I I I I I I I SEX OFFENDER REGIS FEES I 3000.00I -6375.00I 6500.00I 3500.00I 116.66% I I I 37198 I I I I I I I I REIMB: OCDETF I 0.00I 0.00I 3000.00I 3000.00I 100.00% I I I 37200 I I I I I I I I REIMB:WEST TENN HEALTHCARI 0.00I -26500.00I 117725.00I 117725.00I 100.00% I I I Date: 6/03/2009 CITY OF JACKSON Page: 8 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 37201 I I I I I I I I REIMB:MAD CO SHERIFF-METRI 49000.00I -51173.86I 50000.00I 1000.00I 2.04% I I I 37202 I I I I I I I I REIMB: FINANCIAL FRAUD UNI 0.00I -7644.02I 6000.00I 6000.00I 100.00% I I I 37203 I I I I I I I I REIMB: GANG ENFORCEMENT TI 10000.00I -5169.96I 0.00I -10000.00I -100.00% I I I 37204 I I I I I I I I REIMB:POLICE DEPARTMENT I 0.00I -456.13I 0.00I 0.00I 0.00% I I I 37206 I I I I I I I I REIMB: ATF I 10000.00I -12257.13I 0.00I -10000.00I -100.00% I I I I I I I I I I I POLICE REVENUE I 621400.00I -671834.73I 761050.00I 139650.00I 22.47% I I I I I I I I I I I 34700 I I I I I I I I RECREATION REVENUE I 6500.00I -7282.45I 6500.00I 0.00I 0.00% I I I 34700-05 I I I I I I I I RECREATION - WW CERAMIC SI 4500.00I -4230.86I 4000.00I -500.00I -11.11% I I I 34722 I I I I I I I I SWIMMING POOL REVENUE I 1000.00I -798.00I 1000.00I 0.00I 0.00% I I I 34740 I I I I I I I I ATHLETICS REVENUE I 80000.00I -92078.27I 75000.00I -5000.00I -6.25% I I I 34746 I I I I I I I I TENNIS COURT FEES I 27500.00I -26922.90I 25000.00I -2500.00I -9.09% I I I 34910 I I I I I I I I COMMUNITY EDUCATION I 8000.00I -16125.40I 8000.00I 0.00I 0.00% I I I I I I I I I I I RECREATION REVENUE I 127500.00I -147437.88I 119500.00I -8000.00I -6.27% I I I I I I I I I I I 34720 I I I I I I I I WESTWOOD COMM CTR REVENUEI 2000.00I -2028.00I 2000.00I 0.00I 0.00% I I I 34720-04 I I I I I I I I WESTWOOD CENTER - COMP. LI 5000.00I -2273.20I 4000.00I -1000.00I -20.00% I I I 34791-08 I I I I I I I I BEMIS COMM CTR REV-SENIORI 4000.00I -1814.80I 4000.00I 0.00I 0.00% I I I 34794 I I I I I I I I SO JAX COMMUNITY CTR REVEI 7965.00I -2838.00I 2700.00I -5265.00I -66.10% I I I 34794-08 I I I I I I I I SO JAX COMM CTR REV-SENIOI 0.00I -2030.00I 3600.00I 3600.00I 100.00% I I I 34799 I I I I I I I I T.R. WHITE SPORTSPLEX REVI 25000.00I -31417.00I 25000.00I 0.00I 0.00% I I I I I I I I I I I PUBLIC PROPERTIES REVENUEI 43965.00I -42401.00I 41300.00I -2665.00I -6.06% I I I I I I I I I I I Date: 6/03/2009 CITY OF JACKSON Page: 9 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 34786 I I I I I I I I SPONSORSHIPS-JACKSON CENTI 0.00I 8750.00I 0.00I 0.00I 0.00% I I I 34775 I I I I I I I I OMAN ARENA CONCESSIONS I 6000.00I -1378.50I 0.00I -6000.00I -100.00% I I I 34913 I I I I I I I I OMAN MISC REVENUE I 0.00I 0.00I 3600.00I 3600.00I 100.00% I I I 34914 I I I I I I I I OMAN SECURITY I 0.00I -3210.00I 10000.00I 10000.00I 100.00% I I I 34915 I I I I I I I I OMAN ARENA TICKET SALES I 302000.00I -217054.89I 188425.00I -113575.00I -37.60% I I I 34916 I I I I I I I I OMAN-TICKET HANDLE FEES I 0.00I -22306.00I 4900.00I 4900.00I 100.00% I I I 34917 I I I I I I I I OMAN ARENA BLDG RENTALS I 33309.00I -27268.50I 28325.00I -4984.00I -14.96% I I I 34918 I I I I I I I I OMAN ARENA EQUIP RENTALS I 0.00I -2339.38I 6300.00I 6300.00I 100.00% I I I 34942 I I I I I I I I REIMB: STAGE HANDS I 0.00I 0.00I 8550.00I 8550.00I 100.00% I I I 34943 I I I I I I I I BOX OFFICE FEES-OMAN I 0.00I -500.00I 1250.00I 1250.00I 100.00% I I I 37552 I I I I I I I I OMAN-VENDOR COMMISSIONS I 0.00I -3157.77I 6700.00I 6700.00I 100.00% I I I I I I I I I I I OMAN ARENA REVENUE I 341309.00I -268465.04I 258050.00I -83259.00I -24.39% I I I I I I I I I I I 34755 I I I I I I I I CIVIC CENTER CONCESSIONS I 1210.00I -750.00I 0.00I -1210.00I -100.00% I I I 34919 I I I I I I I I CIVIC CENTER SECURITY I 0.00I -17063.00I 20000.00I 20000.00I 100.00% I I I 34920 I I I I I I I I CIVIC CTR EQUIP RENTALS I 0.00I -42530.52I 63041.00I 63041.00I 100.00% I I I 34921 I I I I I I I I CIVIC CTR-TICKET HANDL FEI 0.00I -11271.00I 7239.00I 7239.00I 100.00% I I I 34922 I I I I I I I I CIVIC CENTER TICKET SALESI 93000.00I -137011.03I 57015.00I -35985.00I -38.69% I I I 34923 I I I I I I I I CIVIC CTR BLDG RENTALS I 281088.00I -118279.50I 154352.00I -126736.00I -45.08% I I I 34939 I I I I I I I I CIVIC CTR-MISC REVENUE I 0.00I -736.57I 2338.00I 2338.00I 100.00% I I I 34941 I I I I I I I I REIMB: STAGE HANDS I 0.00I -14172.70I 15000.00I 15000.00I 100.00% I I I Date: 6/03/2009 CITY OF JACKSON Page: 10 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 34944 I I I I I I I I BOX OFFICE FEES-CIVIC CENI 0.00I -1720.00I 1000.00I 1000.00I 100.00% I I I 37551 I I I I I I I I CIVIC CTR-VENDOR COMM I 0.00I -4270.76I 500.00I 500.00I 100.00% I I I I I I I I I I I CIVIC CENTER REVENUE I 375298.00I -347805.08I 320485.00I -54813.00I -14.60% I I I I I I I I I I I 34780 I I I I I I I I FAIRGROUNDS CONCESSIONS I 75000.00I -65767.10I 75000.00I 0.00I 0.00% I I I 34924 I I I I I I I I FAIRGROUNDS RENTALS I 190000.00I -154727.87I 180000.00I -10000.00I -5.26% I I I I I I I I I I I FAIRGROUNDS REVENUE I 265000.00I -220494.97I 255000.00I -10000.00I -3.77% I I I I I I I I I I I 34734 I I I I I I I I CARNEGIE CONCESSIONS I 2500.00I 0.00I 0.00I -2500.00I -100.00% I I I 34925 I I I I I I I I CARNEGIE RENTALS I 16000.00I -21947.40I 16000.00I 0.00I 0.00% I I I I I I I I I I I CARNEGIE REVENUE I 18500.00I -21947.40I 16000.00I -2500.00I -13.51% I I I I I I I I I I I 34723 I I I I I I I I THEATER/SCRIPTS I 0.00I -8402.20I 4000.00I 4000.00I 100.00% I I I 34760 I I I I I I I I NED CENTER CONCESSIONS I 400.00I -630.07I 650.00I 250.00I 62.50% I I I 34926 I I I I I I I I PHOTO SALES - NED I 450.00I -266.50I 300.00I -150.00I -33.33% I I I 34927 I I I I I I I I SEAT & BRICKS-NED I 50.00I 0.00I 50.00I 0.00I 0.00% I I I 34928 I I I I I I I I SOUVENIR COMMISSIONS I 100.00I -142.00I 150.00I 50.00I 50.00% I I I 34929 I I I I I I I I NED TICKET SALES I 4500.00I 0.00I 0.00I -4500.00I -100.00% I I I 34930 I I I I I I I I TICKET SALES-NED I 45000.00I -32023.93I 35000.00I -10000.00I -22.22% I I I 34931 I I I I I I I I TICKET HANDL FEES-NED I 849.00I -3629.22I 4000.00I 3151.00I 371.14% I I I 34932 I I I I I I I I NED SECURITY FEES I 0.00I -340.00I 600.00I 600.00I 100.00% I I I 34933 I I I I I I I I OFFICE RENT-NED CENTER I 42986.36I -27109.28I 6308.52I -36677.84I -85.32% I I I Date: 6/03/2009 CITY OF JACKSON Page: 11 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 34934 I I I I I I I I ADS-NED I 1000.00I -2010.00I 2100.00I 1100.00I 110.00% I I I 34935 I I I I I I I I GRANTS-NED I 2000.00I -1830.00I 1500.00I -500.00I -25.00% I I I 34936 I I I I I I I I SPONSORSHIPS-NED I 1000.00I -1000.00I 1000.00I 0.00I 0.00% I I I 34937 I I I I I I I I ART COMMISSION-NED I 150.00I 0.00I 100.00I -50.00I -33.33% I I I 34938 I I I I I I I I BUILDING RENTALS-NED I 16500.00I -22584.50I 19500.00I 3000.00I 18.18% I I I 34940 I I I I I I I I CATERING FOOD/BEVERAGE I 0.00I -595.00I 0.00I 0.00I 0.00% I I I 34945 I I I I I I I I BOX OFFICE FEES-NED I 0.00I -750.00I 0.00I 0.00I 0.00% I I I I I I I I I I I NED CENTER REVENUE I 114985.36I -101312.70I 75258.52I -39726.84I -34.54% I I I I I I I I I I I 34735 I I I I I I I I NAIA CONCESSIONS I 0.00I -4655.57I 4500.00I 4500.00I 100.00% I I I 34736 I I I I I I I I NAIA VENDOR COMMISSIONS I 0.00I -1162.10I 1000.00I 1000.00I 100.00% I I I 34745 I I I I I I I I NAIA TOURNEY REVENUE I 80000.00I -83908.19I 80000.00I 0.00I 0.00% I I I 34761 I I I I I I I I PRINGLES PARK-RENT I 30000.00I -27500.00I 30000.00I 0.00I 0.00% I I I 34763 I I I I I I I I TICKET SURCHARGES-PRINGLEI 15000.00I -15098.81I 15000.00I 0.00I 0.00% I I I 36715 I I I I I I I I NAIA SPONSORSHIPS I 75000.00I -57695.00I 58795.00I -16205.00I -21.60% I I I I I I I I I I I NAIA & PRINGLES REVENUE I 200000.00I -190019.67I 189295.00I -10705.00I -5.35% I I I I I I I I I I I 34799-09 I I I I I I I I T R WHITE CONC-VENDING COI 150.00I 0.00I 0.00I -150.00I -100.00% I I I I I I I I I I I VENDING MACHINE CONCESSIOI 150.00I 0.00I 0.00I -150.00I -100.00% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNED/ST. DEPT I 35000.00I -14831.13I 15000.00I -20000.00I -57.14% I I I 37111 I I I I I I I I INTEREST EARNED I 450000.00I -341745.99I 390000.00I -60000.00I -13.33% I I I Date: 6/03/2009 CITY OF JACKSON Page: 12 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 37112 I I I I I I I I RIVERSIDE CEMETERY TRST II 5000.00I -3926.65I 3000.00I -2000.00I -40.00% I I I I I I I I I I I INTEREST EARNED I 490000.00I -360503.77I 408000.00I -82000.00I -16.73% I I I I I I I I I I I 37211 I I I I I I I I RENT INCOME I 50000.00I -32854.59I 28000.00I -22000.00I -44.00% I I I 37212 I I I I I I I I RENT-EMERGENCY MGMT I 11000.00I -5850.64I 11000.00I 0.00I 0.00% I I I 37215 I I I I I I I I RENT-CASEY JONES I 8500.00I -2255.00I 4000.00I -4500.00I -52.94% I I I 37553 I I I I I I I I JTA TICKET SALES COMMISSII 0.00I -62.30I 0.00I 0.00I 0.00% I I I 37930 I I I I I I I I RENT-FARMER'S MARKET I 26000.00I -15972.00I 26000.00I 0.00I 0.00% I I I 37931 I I I I I I I I RENT-DEPOT I 1650.00I -1050.00I 1125.00I -525.00I -31.81% I I I I I I I I I I I RENTS & ROYALTIES I 97150.00I -58044.53I 70125.00I -27025.00I -27.81% I I I I I I I I I I I 36350 I I I I I I I I INSURANCE/PERSONAL RECOVEI 16000.00I -199205.95I 16000.00I 0.00I 0.00% I I I 36351 I I I I I I I I LEGAL FEES RECOVERY I 175000.00I -41576.33I 0.00I -175000.00I -100.00% I I I 36352 I I I I I I I I TORNADO RECOVERY-08 I 0.00I -119248.44I 0.00I 0.00I 0.00% I I I 37301 I I I I I I I I SALE OF PROPERTY-DELINQ TI 10000.00I -793.73I 10000.00I 0.00I 0.00% I I I I I I I I I I I SALE/CMPEN FOR LOSS-FXD AI 201000.00I -360824.45I 26000.00I -175000.00I -87.06% I I I I I I I I I I I 36400 I I I I I I I I INC/(DEC) FMV OF INVESTMEI 0.00I -373321.95I 200000.00I 200000.00I 100.00% I I I I I I I I I I I INC/(DEC) IN FMV OF INVESI 0.00I -373321.95I 200000.00I 200000.00I 100.00% I I I I I I I I I I I 36519 I I I I I I I I SALE OF BLDG CODE BOOKS I 5000.00I -3227.50I 5000.00I 0.00I 0.00% I I I 37511 I I I I I I I I SALE OF GEN GOVT SUPPLIESI 0.00I -940.00I 0.00I 0.00I 0.00% I I I 37512 I I I I I I I I SALE OF MAPS & COPIES I 500.00I -310.50I 0.00I -500.00I -100.00% I I I Date: 6/03/2009 CITY OF JACKSON Page: 13 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I 37514 I I I I I I I I SALE OF SCRAP METAL I 0.00I -470.00I 0.00I 0.00I 0.00% I I I 37515 I I I I I I I I SALE OF WASTE OIL & TIRESI 0.00I -1931.42I 0.00I 0.00I 0.00% I I I I I I I I I I I SALE OF MATERIALS & SUPPLI 5500.00I -6879.42I 5000.00I -500.00I -9.09% I I I I I I I I I I I 36700 I I I I I I I I DONATIONS -RECREATION I 0.00I -1668.00I 0.00I 0.00I 0.00% I I I 36707 I I I I I I I I SPONSORS-T-SHIRTS UNIFORMI 4500.00I -3750.00I 2500.00I -2000.00I -44.44% I I I 36713 I I I I I I I I JCB-RESTRICTED DONATIONS I 1200.00I -1036.00I 1500.00I 300.00I 25.00% I I I 36714 I I I I I I I I DONATIONS-MIDNITE BASKETBI 1000.00I -1200.00I 1000.00I 0.00I 0.00% I I I 36719 I I I I I I I I DONATIONS-FIRE PROGRAMS I 0.00I -1371.38I 1000.00I 1000.00I 100.00% I I I 36721 I I I I I I I I DONATIONS - LIBERTY GARDEI 500.00I -3858.91I 25000.00I 24500.00I 4,900.00% I I I 36726 I I I I I I I I DONATIONS FOR CIGARETTE LI 0.00I -500.00I 0.00I 0.00I 0.00% I I I 36731 I I I I I I I I DONATIONS-DEPOT I 425.00I -416.00I 516.00I 91.00I 21.41% I I I I I I I I I I I CONTRI/DONATIONS-PRIV SOUI 7625.00I -13800.29I 31516.00I 23891.00I 313.32% I I I I I I I I I I I 36690 I I I I I I I I REIMB: HOSPITAL STUDY I 100000.00I 0.00I 0.00I -100000.00I -100.00% I I I 36691 I I I I I I I I REIMB: IN-KIND CONTRIBU/JI 91800.00I 0.00I 91800.00I 0.00I 0.00% I I I 36692 I I I I I I I I REIMB: NEIGHBORHOOD SERVII 90000.00I -56468.13I 90000.00I 0.00I 0.00% I I I 37205 I I I I I I I I REIMB: RECYCLING - STATE I 0.00I -18879.93I 0.00I 0.00I 0.00% I I I 37208 I I I I I I I I REIMB:DELINQ TAX CHANCERYI 0.00I -12656.85I 0.00I 0.00I 0.00% I I I 37209 I I I I I I I I REIMBURSEMENTS: OTHER I 0.00I -18576.00I 0.00I 0.00I 0.00% I I I 37210 I I I I I I I I REIMB: GOLF CART PMTS I 24934.00I 0.00I 0.00I -24934.00I -100.00% I I I 37214 I I I I I I I I REIMB:DOWNTOWN STREET-CDBI 177000.00I 0.00I 112721.25I -64278.75I -36.31% I I I Date: 6/03/2009 CITY OF JACKSON Page: 14 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I I I I I I I I REIMBURSEMENTS I 483734.00I -106580.91I 294521.25I -189212.75I -39.11% I I I I I I I I I I I 36964 I I I I I I I I TRANSFER FRM POL DRUG FUNI 0.00I -32500.00I 0.00I 0.00I 0.00% I I I 37840 I I I I I I I I TRANSFER FRM OTHER FUNDS I 996583.09I -996583.09I 1500000.00I 503416.91I 50.51% I I I I I I I I I I I INTER-FUND TRANSFERS IN I 996583.09I -1029083.09I 1500000.00I 503416.91I 50.51% I I I I I I I I I I I 37900 I I I I I I I I FROM FUND BALANCE I 6407276.57I 0.00I 0.00I -6407276.57I -100.00% I I I 37990 I I I I I I I I MISCELLANEOUS REVENUE I 0.00I -37151.33I 2000.00I 2000.00I 100.00% I I I 37991 I I I I I I I I COPY REVENUE I 60.00I -78.50I 0.00I -60.00I -100.00% I I I 37992 I I I I I I I I RECYCLING REVENUE I 0.00I -0.63I 0.00I 0.00I 0.00% I I I I I I I I I I I MISCELLANEOUS REVENUE I 6407336.57I -37230.46I 2000.00I -6405336.57I -99.96% I I I I I I I I I I I 37996 I I I I I I I I CREDIT/DEBIT CARD FEES I 0.00I 0.00I 12000.00I 12000.00I 100.00% I I I 37997 I I I I I I I I ENERNOC FEES I 0.00I -951.47I 0.00I 0.00I 0.00% I I I 39100 I I I I I I I I CASH SHORT AND OVER I 0.00I 587.36I 0.00I 0.00I 0.00% I I I I I I I I I I I CASH SHORT AND OVER I 0.00I -364.11I 12000.00I 12000.00I 100.00% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 65949770.60I -51464156.00I 59729401.74I -6220368.86I 0.00% I I I I I I I I I I I Date: 6/03/2009 CITY OF JACKSON Page: 15 Time: 10:02 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2009 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2009 BUDGET I TOTALS I2010 BUDGET IBETWEEN BUDGEIBETWEEN BUDGEI I I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I I 1 I 2 I 3 I 4 I 5 I 6 I 7 I I-------------I-------------I-------------I-------------I-------------I-------------I-------------I Total Available Fund 65949770.60 -51464156.00 59729401.74 -6220368.86 -9.43% Grand Total 65949770.60 -51464156.00 59729401.74 -6220368.86 -9.43%