Date: 9/09/2010 CITY OF JACKSON Page: 1 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 21833789.00I -22168357.28I 22084244.00I 250455.00I 1.14% I I I I I I I I I I I CURRENT TAXES GENERAL FUNI 21833789.00I -22168357.28I 22084244.00I 250455.00I 1.14% 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 2039.00I -2075.96I 2021.00I -18.00I -0.88% I I I 31101 I I I I I I I I R.E. TAXES 2001 I 3336.00I -1983.84I 2079.00I -1257.00I -37.67% I I I 31102 I I I I I I I I R.E. TAXES 2002 I 5187.00I -3279.83I 4985.00I -202.00I -3.89% I I I 31103 I I I I I I I I R.E. TAXES 2003 I 6606.00I -8448.95I 4620.00I -1986.00I -30.06% I I I 31104 I I I I I I I I R.E. TAXES 2004 I 7671.00I -8177.36I 4424.00I -3247.00I -42.32% I I I 31105 I I I I I I I I R.E. TAXES 2005 I 28986.00I -19472.38I 22628.00I -6358.00I -21.93% I I I 31106 I I I I I I I I R.E. TAXES 2006 I 27923.00I -36518.89I 14315.00I -13608.00I -48.73% I I I 31107 I I I I I I I I R.E. TAXES 2007 I 155060.00I -181683.03I 27464.00I -127596.00I -82.28% I I I 31108 I I I I I I I I R.E. TAXES 2008 I 707673.00I -745622.68I 172410.00I -535263.00I -75.63% I I I 31109 I I I I I I I I R.E. TAXES 2009 I 0.00I 0.00I 601486.00I 601486.00I 100.00% I I I 31197 I I I I I I I I R. E. TAXES 1997 I 0.00I -266.17I 0.00I 0.00I 0.00% I I I 31198 I I I I I I I I R. E. TAXES 1998 I 1228.00I -217.17I 0.00I -1228.00I -100.00% I I I 31199 I I I I I I I I R. E. TAXES 1999 I 2328.00I -1692.49I 1381.00I -947.00I -40.67% I I I I I I I I I I I TOTAL R.E. TAXES I 948037.00I -1009438.75I 857813.00I -90224.00I -9.51% 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 -556229.44I 450000.00I -100000.00I -18.18% I I I 31330 I I I I I I I I ATTY FEES-DELINQ. R.E. TAI 0.00I 1469.24I 0.00I 0.00I 0.00% I I I I I I I I I I I INTEREST/PENALTY R.E TAXEI 550000.00I -554760.20I 450000.00I -100000.00I -18.18% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 2 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 31510 I I I I I I I I PILOT-IDB TAX LIEU I 300530.00I -358977.61I 287334.00I -13196.00I -4.39% I I I 31511 I I I I I I I I TAX EQ.-ELECTRIC I 1968256.00I -2153425.75I 1982044.00I 13788.00I 0.70% I I I 31512 I I I I I I I I LIEU TAX WATER I 222498.00I -272289.64I 223408.00I 910.00I 0.40% I I I 31513 I I I I I I I I TAX EQUIV.-WESLEY I 3851.00I -4500.00I 3743.00I -108.00I -2.80% I I I 31514 I I I I I I I I TAX EQ.-GAS I 984128.00I -1045608.07I 996762.00I 12634.00I 1.28% I I I 31515 I I I I I I I I TAX EQ.-JHA(HOUSING) I 13692.00I -41765.08I 13309.00I -383.00I -2.79% I I I 31516 I I I I I I I I TAX EQ.-ST. MARY MANOR I 4621.00I -5400.00I 4492.00I -129.00I -2.79% I I I I I I I I I I I TAX EQUIVALENT I 3497576.00I -3881966.15I 3511092.00I 13516.00I 0.38% I I I I I I I I I I I 31610 I I I I I I I I LOCAL SALES TAX I 11246480.00I -10252279.90I 11298000.00I 51520.00I 0.45% I I I 31710 I I I I I I I I CITY BEER TAX I 1630000.00I -1642756.42I 1630000.00I 0.00I 0.00% I I I 31720 I I I I I I I I WHOLESALE LIQUOR TAX I 470000.00I -521883.88I 500000.00I 30000.00I 6.38% I I I 31800 I I I I I I I I BUSINESS TAX I 1425000.00I -1475633.29I 1375000.00I -50000.00I -3.50% I I I 31830 I I I I I I I I BUSINESS LICENSE PENT & II 25000.00I -19030.64I 25000.00I 0.00I 0.00% I I I 31912 I I I I I I I I CATV-CHARTER REVENUE I 380000.00I -317081.89I 380000.00I 0.00I 0.00% I I I 31913 I I I I I I I I CATV-JEA REVENUE I 420000.00I -528835.10I 440000.00I 20000.00I 4.76% I I I 31920 I I I I I I I I HOTEL - MOTEL TAX I 390000.00I -391851.06I 390000.00I 0.00I 0.00% I I I 31980 I I I I I I I I MIXED DRINK TAXES I 50000.00I -45915.00I 55000.00I 5000.00I 10.00% I I I I I I I I I I I VARIOUS TAXES I 16036480.00I -15195267.18I 16093000.00I 56520.00I 0.35% 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 1000000.00I -1048500.95I 1000000.00I 0.00I 0.00% I I I 32300 I I I I I I I I LOCAL BEER PRIVILEGE TAX I 25000.00I -28952.40I 25000.00I 0.00I 0.00% I I I Date: 9/09/2010 CITY OF JACKSON Page: 3 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 32310 I I I I I I I I CHAUFFEURS LICENSE I 250.00I -422.50I 250.00I 0.00I 0.00% I I I 32349 I I I I I I I I LIQUOR APPLIC FEE I 500.00I -1250.00I 500.00I 0.00I 0.00% I I I I I I I I I I I LICENSES & FEES I 1025750.00I -1079125.85I 1025750.00I 0.00I 0.00% 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 -64142.50I 70000.00I 0.00I 0.00% I I I 32610 I I I I I I I I BUILDING PERMITS I 325000.00I -304693.47I 357500.00I 32500.00I 10.00% I I I 32611 I I I I I I I I BLDG/PROPERTY LIENS I 10650.00I -13137.24I 0.00I -10650.00I -100.00% I I I 32615 I I I I I I I I PLANS REVIEW I 140000.00I -109340.90I 154000.00I 14000.00I 10.00% I I I 32620 I I I I I I I I ELECTRIC PERMITS I 50000.00I -86545.00I 80000.00I 30000.00I 60.00% I I I 32630 I I I I I I I I PLUMBING PERMITS I 50000.00I -34162.50I 55000.00I 5000.00I 10.00% I I I 32640 I I I I I I I I GAS PERMITS I 20000.00I -15987.50I 22000.00I 2000.00I 10.00% I I I 32670 I I I I I I I I MECHANICAL PERMITS I 38000.00I -41404.00I 38000.00I 0.00I 0.00% I I I 32680 I I I I I I I I SIGN PERMITS I 18000.00I -15654.00I 18000.00I 0.00I 0.00% I I I 32681 I I I I I I I I VIE EVALUATION FEE I 1000.00I -1260.00I 1000.00I 0.00I 0.00% I I I 32682 I I I I I I I I SITE PLAN REVIEW FEE I 2000.00I -2400.00I 2000.00I 0.00I 0.00% I I I 32683 I I I I I I I I LANDSCAPE REVIEW FEE I 1000.00I -950.00I 1000.00I 0.00I 0.00% I I I I I I I I I I I BUILDING & RELATED PERMITI 725650.00I -689677.11I 798500.00I 72850.00I 10.03% I I I I I I I I I I I 34231 I I I I I I I I POLICE-NOTARY FEES I 0.00I -35.00I 0.00I 0.00I 0.00% I I I 32692 I I I I I I I I CODE I 1000.00I -7800.00I 6500.00I 5500.00I 550.00% I I I 32694 I I I I I I I I INVESTIGATION FEES - BEERI 10000.00I -14000.00I 10000.00I 0.00I 0.00% I I I 32695 I I I I I I I I ZONING APPLICATION FES-PLI 3750.00I -7350.00I 6200.00I 2450.00I 65.33% I I I Date: 9/09/2010 CITY OF JACKSON Page: 4 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 32696 I I I I I I I I SUB-DIVISION REVIEW FEES-I 2325.00I -3200.00I 2500.00I 175.00I 7.52% I I I 32697 I I I I I I I I ENG STREET LIGHT FEES I 0.00I -15200.00I 8000.00I 8000.00I 100.00% I I I I I I I I I I I VARIOUS FEES I 17075.00I -47585.00I 33200.00I 16125.00I 94.43% I I I I I I I I I I I 33108 I I I I I I I I FEMA: TORNADO 2008 I 0.00I -316878.25I 0.00I 0.00I 0.00% I I I 33126 I I I I I I I I SART GRANT REVENUE I 80000.00I -60477.09I 80000.00I 0.00I 0.00% I I I 33127 I I I I I I I I 2006 METH GRANT I 80000.00I -5899.11I 55000.00I -25000.00I -31.25% I I I 33129 I I I I I I I I ACT GRANT I 24300.00I -16156.24I 0.00I -24300.00I -100.00% I I I 33131 I I I I I I I I 2008 BYRNE GRANT FOR DRUGI 44240.00I -26677.41I 0.00I -44240.00I -100.00% I I I 33132 I I I I I I I I 2007 METH INITIATIVE GRANI 350000.00I -46994.46I 335000.00I -15000.00I -4.28% I I I 33134 I I I I I I I I 09 JAG RECOVERY I 423442.00I -259590.60I 142000.00I -281442.00I -66.46% I I I 33135 I I I I I I I I STOP DOMESTIC VIOLENCE I 81880.73I -70736.36I 64068.00I -17812.73I -21.75% I I I 33136 I I I I I I I I COLD CASE UNIT GRANT I 71800.00I -68565.78I 68200.00I -3600.00I -5.01% I I I 33137 I I I I I I I I COPS HIRING GRANT I 1568000.00I -320751.80I 1247874.22I -320125.78I -20.41% I I I 33139 I I I I I I I I 09 JAG GRANT I 103013.00I -47164.37I 76658.43I -26354.57I -25.58% I I I 33141 I I I I I I I I DRUG COURT GRANT I 50000.00I -47898.76I 50000.00I 0.00I 0.00% I I I 33147 I I I I I I I I 2004 COPS TECH GRANT I 0.00I -120157.03I 0.00I 0.00I 0.00% I I I 33148 I I I I I I I I BYRNE GRANT-DRUG COURT I 27985.00I -17811.55I 29617.00I 1632.00I 5.83% I I I 33149 I I I I I I I I 2006 COPS TECH GRANT I 0.00I -36880.59I 0.00I 0.00I 0.00% I I I 33150 I I I I I I I I JUVENILE & NEIGHB SAFE PRI 551276.38I -224805.35I 303324.00I -247952.38I -44.97% I I I 33151 I I I I I I I I EDI GRANT-DEPT OF HOUSINGI 173967.00I 0.00I 173967.00I 0.00I 0.00% I I I Date: 9/09/2010 CITY OF JACKSON Page: 5 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 33152 I I I I I I I I BROWNSFIELD CLEANUP GRANTI 186345.51I -158762.82I 6336.88I -180008.63I -96.59% I I I 33153 I I I I I I I I REENTRY GRANT I 755000.00I -114431.59I 612908.00I -142092.00I -18.82% I I I 33154 I I I I I I I I ENERGY&EFFICIENCY CONS GRI 670700.00I -97990.00I 567910.00I -102790.00I -15.32% I I I 33196 I I I I I I I I 2006 JAG GRANT I 2200.00I -412.64I 0.00I -2200.00I -100.00% I I I 33198 I I I I I I I I 2008 EDWARD BYRNE MEM JAGI 14221.00I -13360.50I 0.00I -14221.00I -100.00% I I I 33199 I I I I I I I I 2007 BYRNE JAG GRANT I 18700.00I -10004.70I 8636.40I -10063.60I -53.81% I I I I I I I I I I I FEDERAL GRANTS I 5277070.62I -2082407.00I 3821499.93I -1455570.69I -27.58% I I I I I I I I I I I 33280 I I I I I I I I FEMA FIRE GRANT I 348935.00I 0.00I 0.00I -348935.00I -100.00% I I I 33410 I I I I I I I I ST LAW ENFORCEMENT EDUC SI 125400.00I -118800.00I 123600.00I -1800.00I -1.43% I I I 33420 I I I I I I I I ST FIRE PROTECTION EDUC SI 85200.00I -87000.00I 85200.00I 0.00I 0.00% I I I 33433 I I I I I I I I WEST TENNESSEE RIVER BASII 20000.00I -20000.00I 0.00I -20000.00I -100.00% I I I 33460 I I I I I I I I MITIGATION GRANT REVENUE I 0.00I -48.00I 0.00I 0.00I 0.00% I I I 33461 I I I I I I I I NRPA ACHIEVE GRANT I 35000.00I -12000.00I 23000.00I -12000.00I -34.28% I I I 33491 I I I I I I I I CARFP: SNACK FOOD I 3500.00I -4305.32I 0.00I -3500.00I -100.00% I I I 33493 I I I I I I I I ANDERSON CREEK TRAIL GRANI 0.00I -26875.00I 0.00I 0.00I 0.00% I I I 37993 I I I I I I I I ST OF TN:MUNICIPAL PLN OFI 207000.00I -175626.72I 188000.00I -19000.00I -9.17% I I I 37994 I I I I I I I I DOT: TRANSP/PLANNING PROJI 1000000.00I -148157.72I 532364.98I -467635.02I -46.76% I I I I I I I I I I I STATE GRANTS I 1825035.00I -592812.76I 952164.98I -872870.02I -47.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 134137.00I -128310.59I 150000.00I 15863.00I 11.82% I I I 31930 I I I I I I I I STATE MIXED DRINK TAXES I 297180.00I -316196.17I 300000.00I 2820.00I 0.94% I I I Date: 9/09/2010 CITY OF JACKSON Page: 6 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 31941 I I I I I I I I ST REIMB-TDOT-SSA I 206674.08I -197930.30I 206674.00I -0.08I 0.00% I I I 33510 I I I I I I I I STATE SALES TAX I 3760400.00I -3820896.23I 3720000.00I -40400.00I -1.07% I I I 33520 I I I I I I I I STATE INCOME TAX I 385044.00I -393178.96I 400000.00I 14956.00I 3.88% I I I 33530 I I I I I I I I STATE BEER TAX I 19252.00I -13625.36I 20000.00I 748.00I 3.88% I I I 33551 I I I I I I I I GAS,MOTOR FUEL,ADDL 3-CNTI 1329720.00I -1701926.10I 1374500.00I 44780.00I 3.36% I I I 33580 I I I I I I I I SP PETROLEUM PRODUCTS (88I 93120.00I -61334.70I 93120.00I 0.00I 0.00% I I I 33591 I I I I I I I I STATE TVA GROSS RECEIPTS I 554374.00I -657663.76I 633700.00I 79326.00I 14.30% I I I I I I I I I I I STATE REVENUE ALLOCATIONSI 6779901.08I -7291062.17I 6897994.00I 118092.92I 1.74% 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 15000.00I -8435.00I 15000.00I 0.00I 0.00% I I I I I I I I I I I BUSINESS TAX CLERK FEES I 15000.00I -8435.00I 15000.00I 0.00I 0.00% I I I I I I I I I I I 34125 I I I I I I I I HANDLING FEES I 4500.00I -5542.50I 0.00I -4500.00I -100.00% I I I 34138 I I I I I I I I PLANNING EXPENSES:3-WAY I 200.00I -550.00I 400.00I 200.00I 100.00% I I I 34139 I I I I I I I I PLN SERV:MAD CO I 25500.00I -20000.00I 26000.00I 500.00I 1.96% I I I 34221 I I I I I I I I FIRE REPORTS I 100.00I -31.15I 100.00I 0.00I 0.00% I I I 34293 I I I I I I I I FIRE TRAINING FEES I 20000.00I -29511.00I 20000.00I 0.00I 0.00% I I I 37302 I I I I I I I I HOUSE/BUILDING DEMOLITIONI 0.00I -2855.15I 0.00I 0.00I 0.00% I I I I I I I I I I I CHARGES FOR SERVICES I 50300.00I -58489.80I 46500.00I -3800.00I -7.55% I I I I I I I I I I I 31940 I I I I I I I I SIDEWALK REPAIRS I 2000.00I 0.00I 0.00I -2000.00I -100.00% I I I 32650 I I I I I I I I DEVELOPMENT PERMITS/ENG I 7000.00I -7700.00I 2000.00I -5000.00I -71.42% I I I Date: 9/09/2010 CITY OF JACKSON Page: 7 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 32690 I I I I I I I I MOVING PERMITS I 75.00I -75.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 -27754.58I 30000.00I -10000.00I -25.00% I I I 34315 I I I I I I I I TRAFFIC SIGN/MISC. REVENUI 3000.00I -2118.00I 3000.00I 0.00I 0.00% I I I 34317 I I I I I I I I ENGINEERING - MISC REVENUI 300.00I -2916.50I 300.00I 0.00I 0.00% I I I 34318 I I I I I I I I ENG REVIEW FEES-COUNTY S/I 1500.00I -575.00I 250.00I -1250.00I -83.33% I I I 34319 I I I I I I I I ENG REVIEW FEES-CITY SUBDI 9500.00I -2625.00I 2000.00I -7500.00I -78.94% I I I 34320 I I I I I I I I STORMWATER REIMB I 500.00I 0.00I 500.00I 0.00I 0.00% I I I 36531 I I I I I I I I SALE OF STREET MATERIALS I 2500.00I -3172.70I 2000.00I -500.00I -20.00% I I I I I I I I I I I STREET CHARGES FOR SERVICI 66375.00I -46936.78I 40125.00I -26250.00I -39.54% I I I I I I I I I I I 35100 I I I I I I I I CITY COURT REVENUE I 625000.00I -541592.50I 625000.00I 0.00I 0.00% I I I 35101 I I I I I I I I ENVIRONMENTAL COURT REVENI 16000.00I -25917.34I 18000.00I 2000.00I 12.50% I I I 35103 I I I I I I I I INTERPRETING FEES I 0.00I -200.00I 0.00I 0.00I 0.00% I I I 35105 I I I I I I I I DRUG LITIGATION TAX I 100000.00I -81999.28I 85000.00I -15000.00I -15.00% I I I 35106 I I I I I I I I DRUG COURT FEES I 2500.00I -3290.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 -9712.00I 2500.00I 1000.00I 66.66% I I I 35210 I I I I I I I I SEIZURES I 3000.00I 0.00I 0.00I -3000.00I -100.00% I I I I I I I I I I I FINES AND FORFEITURES I 748000.00I -662711.12I 733000.00I -15000.00I -2.00% I I I I I I I I I I I 34210 I I I I I I I I POLICE SECURITY I 244000.00I -199737.62I 244000.00I 0.00I 0.00% I I I 34211 I I I I I I I I BAR DETAIL REVENUE I 0.00I -19215.00I 25000.00I 25000.00I 100.00% I I I 34240 I I I I I I I I ACCIDENT REPORT FEES I 6825.00I -8680.92I 0.00I -6825.00I -100.00% I I I Date: 9/09/2010 CITY OF JACKSON Page: 8 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 34290 I I I I I I I I DRIVER IMPROVMNT PROG FEEI 8000.00I -6190.30I 3000.00I -5000.00I -62.50% I I I 35000 I I I I I I I I POLICE RED LIGHT OVERAGE I 0.00I -25.00I 0.00I 0.00I 0.00% I I I 35102 I I I I I I I I PHOTO ENFORCEMENT I 210000.00I -419866.00I 400000.00I 190000.00I 90.47% I I I 35104 I I I I I I I I SPEED ENFORCEMENT I 0.00I -417750.00I 300000.00I 300000.00I 100.00% I I I 35120 I I I I I I I I PARKING TICKETS I 59000.00I -132803.55I 65000.00I 6000.00I 10.16% I I I 35121 I I I I I I I I CITY STICKER TICKETS I 50000.00I -69453.00I 45000.00I -5000.00I -10.00% I I I 35214 I I I I I I I I FED EQUITABLE SHARE-SEIZEI 0.00I -26.91I 0.00I 0.00I 0.00% I I I 35361 I I I I I I I I SEX OFFENDER REGIS FEES I 6500.00I -13530.07I 13000.00I 6500.00I 100.00% I I I 37198 I I I I I I I I REIMB: OCDETF I 3000.00I -6422.63I 0.00I -3000.00I -100.00% I I I 37199 I I I I I I I I REIMB: US MARSHALL SERVICI 0.00I -0.01I 0.00I 0.00I 0.00% I I I 37200 I I I I I I I I REIMB:WEST TENN HEALTHCARI 117725.00I -90217.50I 110725.00I -7000.00I -5.94% I I I 37201 I I I I I I I I REIMB:MAD CO SHERIFF-METRI 50000.00I -58082.50I 58000.00I 8000.00I 16.00% I I I 37202 I I I I I I I I REIMB: FINANCIAL FRAUD UNI 6000.00I -12369.40I 0.00I -6000.00I -100.00% I I I 37203 I I I I I I I I REIMB: GANG ENFORCEMENT TI 0.00I -4752.96I 0.00I 0.00I 0.00% I I I 37204 I I I I I I I I REIMB:POLICE DEPARTMENT I 0.00I -8186.32I 0.00I 0.00I 0.00% I I I 37206 I I I I I I I I REIMB: ATF I 0.00I -10808.72I 0.00I 0.00I 0.00% I I I I I I I I I I I POLICE REVENUE I 761050.00I -1478118.41I 1263725.00I 502675.00I 66.05% 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 -1979.00I 6500.00I 0.00I 0.00% I I I 34700-05 I I I I I I I I RECREATION - WW CERAMIC SI 4000.00I -5249.93I 4500.00I 500.00I 12.50% I I I 34701 I I I I I I I I REIMB: JACKSON IDOL I 0.00I -500.00I 0.00I 0.00I 0.00% I I I Date: 9/09/2010 CITY OF JACKSON Page: 9 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 34722 I I I I I I I I SWIMMING POOL REVENUE I 1000.00I -2717.00I 1000.00I 0.00I 0.00% I I I 34740 I I I I I I I I ATHLETICS REVENUE I 75000.00I -76118.06I 75000.00I 0.00I 0.00% I I I 34746 I I I I I I I I TENNIS COURT FEES I 25000.00I -29994.48I 34746.00I 9746.00I 38.98% I I I 34910 I I I I I I I I COMMUNITY EDUCATION I 8000.00I -30450.38I 8000.00I 0.00I 0.00% I I I 34911 I I I I I I I I CHRISTMAS PARADE REG FEESI 0.00I -1016.16I 0.00I 0.00I 0.00% I I I I I I I I I I I RECREATION REVENUE I 119500.00I -148025.01I 129746.00I 10246.00I 8.57% 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 -2348.56I 2000.00I 0.00I 0.00% I I I 34720-04 I I I I I I I I WESTWOOD CENTER - COMP. LI 4000.00I -993.20I 3500.00I -500.00I -12.50% I I I 34791-08 I I I I I I I I BEMIS COMM CTR REV-SENIORI 4000.00I -1652.60I 3500.00I -500.00I -12.50% I I I 34794 I I I I I I I I SO JAX COMMUNITY CTR REVEI 2700.00I -2405.00I 2800.00I 100.00I 3.70% I I I 34794-08 I I I I I I I I SO JAX COMM CTR REV-SENIOI 3600.00I -2748.36I 3120.00I -480.00I -13.33% I I I 34799 I I I I I I I I T.R. WHITE SPORTSPLEX REVI 25000.00I -35741.00I 33258.00I 8258.00I 33.03% I I I I I I I I I I I PUBLIC PROPERTIES REVENUEI 41300.00I -45888.72I 48178.00I 6878.00I 16.65% I I I I I I I I I I I 34913 I I I I I I I I OMAN MISC REVENUE I 3600.00I -11954.06I 800.00I -2800.00I -77.77% I I I 34914 I I I I I I I I OMAN SECURITY I 10000.00I -4171.40I 1100.00I -8900.00I -89.00% I I I 34915 I I I I I I I I OMAN ARENA TICKET SALES I 188425.00I -198605.96I 302200.00I 113775.00I 60.38% I I I 34916 I I I I I I I I OMAN-TICKET HANDLE FEES I 4900.00I -18260.75I 20000.00I 15100.00I 308.16% I I I 34917 I I I I I I I I OMAN ARENA BLDG RENTALS I 28325.00I -33493.50I 25187.50I -3137.50I -11.07% I I I 34918 I I I I I I I I OMAN ARENA EQUIP RENTALS I 6300.00I -2038.00I 1668.00I -4632.00I -73.52% I I I 34942 I I I I I I I I REIMB: STAGE HANDS I 8550.00I 0.00I 0.00I -8550.00I -100.00% I I I Date: 9/09/2010 CITY OF JACKSON Page: 10 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 34943 I I I I I I I I BOX OFFICE FEES-OMAN I 1250.00I -49.00I 0.00I -1250.00I -100.00% I I I 37552 I I I I I I I I OMAN-VENDOR COMMISSIONS I 6700.00I -5709.15I 4500.00I -2200.00I -32.83% I I I I I I I I I I I OMAN ARENA REVENUE I 258050.00I -274281.82I 355455.50I 97405.50I 37.74% I I I I I I I I I I I 34919 I I I I I I I I CIVIC CENTER SECURITY I 20000.00I -18048.00I 21100.00I 1100.00I 5.50% I I I 34920 I I I I I I I I CIVIC CTR EQUIP RENTALS I 63041.00I -32428.69I 40810.45I -22230.55I -35.26% I I I 34921 I I I I I I I I CIVIC CTR-TICKET HANDL FEI 7239.00I -7040.25I 10000.00I 2761.00I 38.14% I I I 34922 I I I I I I I I CIVIC CENTER TICKET SALESI 57015.00I -87934.83I 75772.00I 18757.00I 32.89% I I I 34923 I I I I I I I I CIVIC CTR BLDG RENTALS I 154352.00I -123596.93I 127615.50I -26736.50I -17.32% I I I 34939 I I I I I I I I CIVIC CTR-MISC REVENUE I 2338.00I -3611.37I 1975.00I -363.00I -15.52% I I I 34941 I I I I I I I I REIMB: STAGE HANDS I 15000.00I -3888.40I 13146.80I -1853.20I -12.35% I I I 34944 I I I I I I I I BOX OFFICE FEES-CIVIC CENI 1000.00I -1750.00I 2000.00I 1000.00I 100.00% I I I 37551 I I I I I I I I CIVIC CTR-VENDOR COMM I 500.00I -4374.96I 1316.61I 816.61I 163.32% I I I I I I I I I I I CIVIC CENTER REVENUE I 320485.00I -282673.43I 293736.36I -26748.64I -8.34% 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 -64123.21I 75000.00I 0.00I 0.00% I I I 34924 I I I I I I I I FAIRGROUNDS RENTALS I 180000.00I -206557.27I 200000.00I 20000.00I 11.11% I I I I I I I I I I I FAIRGROUNDS REVENUE I 255000.00I -270680.48I 275000.00I 20000.00I 7.84% I I I I I I I I I I I 34723 I I I I I I I I THEATER/SCRIPTS I 4000.00I -31048.28I 25000.00I 21000.00I 525.00% I I I 34760 I I I I I I I I NED CENTER CONCESSIONS I 650.00I -211.61I 500.00I -150.00I -23.07% I I I 34926 I I I I I I I I PHOTO SALES - NED I 300.00I -454.18I 500.00I 200.00I 66.66% I I I Date: 9/09/2010 CITY OF JACKSON Page: 11 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 34927 I I I I I I I I SEAT & BRICKS-NED I 50.00I -350.00I 150.00I 100.00I 200.00% I I I 34928 I I I I I I I I SOUVENIR COMMISSIONS I 150.00I -336.00I 150.00I 0.00I 0.00% I I I 34930 I I I I I I I I TICKET SALES-NED I 35000.00I -21855.62I 20000.00I -15000.00I -42.85% I I I 34931 I I I I I I I I TICKET HANDL FEES-NED I 4000.00I -1895.00I 1800.00I -2200.00I -55.00% I I I 34932 I I I I I I I I NED SECURITY FEES I 600.00I -770.00I 700.00I 100.00I 16.66% I I I 34933 I I I I I I I I OFFICE RENT-NED CENTER I 6308.52I -6200.02I 7900.00I 1591.48I 25.22% I I I 34934 I I I I I I I I ADS-NED I 2100.00I -3450.00I 2200.00I 100.00I 4.76% I I I 34935 I I I I I I I I GRANTS-NED I 1500.00I -1950.00I 0.00I -1500.00I -100.00% I I I 34936 I I I I I I I I SPONSORSHIPS-NED I 1000.00I -1000.00I 0.00I -1000.00I -100.00% I I I 34937 I I I I I I I I ART COMMISSION-NED I 100.00I -110.00I 100.00I 0.00I 0.00% I I I 34938 I I I I I I I I BUILDING RENTALS-NED I 19500.00I -22425.00I 18000.00I -1500.00I -7.69% I I I 34945 I I I I I I I I BOX OFFICE FEES-NED I 0.00I -1250.00I 0.00I 0.00I 0.00% I I I I I I I I I I I NED CENTER REVENUE I 75258.52I -93305.71I 77000.00I 1741.48I 2.31% I I I I I I I I I I I 34735 I I I I I I I I NAIA CONCESSIONS I 4500.00I -5537.68I 4500.00I 0.00I 0.00% I I I 34736 I I I I I I I I NAIA VENDOR COMMISSIONS I 1000.00I -1089.30I 1000.00I 0.00I 0.00% I I I 34745 I I I I I I I I NAIA TOURNEY REVENUE I 80000.00I -74344.43I 80000.00I 0.00I 0.00% I I I 34761 I I I I I I I I PRINGLES PARK-RENT I 30000.00I -30000.00I 30000.00I 0.00I 0.00% I I I 34763 I I I I I I I I TICKET SURCHARGES-PRINGLEI 15000.00I -8649.75I 15000.00I 0.00I 0.00% I I I 36715 I I I I I I I I NAIA SPONSORSHIPS I 58795.00I -62695.00I 55000.00I -3795.00I -6.45% I I I I I I I I I I I NAIA & PRINGLES REVENUE I 189295.00I -182316.16I 185500.00I -3795.00I -2.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 12 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 36100 I I I I I I I I INTEREST EARNED/ST. DEPT I 15000.00I -23.24I 0.00I -15000.00I -100.00% I I I 37111 I I I I I I I I INTEREST EARNED I 390000.00I -331159.96I 350000.00I -40000.00I -10.25% I I I 37112 I I I I I I I I RIVERSIDE CEMETERY TRST II 3000.00I -4055.55I 3000.00I 0.00I 0.00% I I I I I I I I I I I INTEREST EARNED I 408000.00I -335238.75I 353000.00I -55000.00I -13.48% I I I I I I I I I I I 37211 I I I I I I I I RENT INCOME I 28000.00I -31145.04I 28000.00I 0.00I 0.00% I I I 37212 I I I I I I I I RENT-EMERGENCY MGMT I 11000.00I -5156.20I 11000.00I 0.00I 0.00% I I I 37215 I I I I I I I I RENT-CASEY JONES I 4000.00I -8643.64I 4000.00I 0.00I 0.00% I I I 37553 I I I I I I I I JTA TICKET SALES COMMISSII 0.00I -65.20I 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 -34499.00I 26000.00I 0.00I 0.00% I I I 37931 I I I I I I I I RENT-DEPOT I 1125.00I -1087.50I 1000.00I -125.00I -11.11% I I I 37932 I I I I I I I I KEY DEPOSITS-FARMERS MKT I 0.00I 25.00I 0.00I 0.00I 0.00% I I I I I I I I I I I RENTS & ROYALTIES I 70125.00I -80571.58I 70000.00I -125.00I -0.17% 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 -614208.86I 16000.00I 0.00I 0.00% I I I 36351 I I I I I I I I LEGAL FEES RECOVERY I 0.00I -112000.00I 0.00I 0.00I 0.00% I I I 36352 I I I I I I I I SALE OF FLOOD ITEMS I 0.00I -230.00I 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 -12296.72I 10000.00I 0.00I 0.00% I I I I I I I I I I I SALE/CMPEN FOR LOSS-FXD AI 26000.00I -738735.58I 26000.00I 0.00I 0.00% 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 200000.00I 112286.94I 50000.00I -150000.00I -75.00% I I I I I I I I I I I INC/(DEC) IN FMV OF INVESI 200000.00I 112286.94I 50000.00I -150000.00I -75.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 13 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 36519 I I I I I I I I SALE OF BLDG CODE BOOKS I 5000.00I -2589.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 -1129.34I 0.00I 0.00I 0.00% I I I 37512 I I I I I I I I SALE OF MAPS & COPIES I 0.00I -210.50I 150.00I 150.00I 100.00% I I I 37514 I I I I I I I I SALE OF SCRAP METAL I 0.00I -2669.00I 2000.00I 2000.00I 100.00% I I I 37515 I I I I I I I I SALE OF WASTE OIL & TIRESI 0.00I -1925.10I 0.00I 0.00I 0.00% I I I I I I I I I I I SALE OF MATERIALS & SUPPLI 5000.00I -8523.44I 7150.00I 2150.00I 43.00% I I I I I I I I I I I 36700 I I I I I I I I DONATIONS PRIVATE SOURCESI 0.00I -1923.50I 0.00I 0.00I 0.00% I I I 36707 I I I I I I I I SPONSORS-T-SHIRTS UNIFORMI 2500.00I -3476.00I 0.00I -2500.00I -100.00% I I I 36713 I I I I I I I I JCB-RESTRICTED DONATIONS I 1500.00I -1410.94I 1500.00I 0.00I 0.00% I I I 36714 I I I I I I I I DONATIONS-MIDNITE BASKETBI 1000.00I -1000.00I 1200.00I 200.00I 20.00% I I I 36719 I I I I I I I I DONATIONS-FIRE PROGRAMS I 1000.00I -500.00I 500.00I -500.00I -50.00% I I I 36721 I I I I I I I I DONATIONS - LIBERTY GARDEI 25000.00I -61558.03I 500.00I -24500.00I -98.00% I I I 36723 I I I I I I I I DONATIONS-FIRE EXPLORERS I 0.00I 0.00I 1000.00I 1000.00I 100.00% I I I 36726 I I I I I I I I DONATIONS FOR CIGARETTE LI 0.00I -1500.00I 0.00I 0.00I 0.00% I I I 36731 I I I I I I I I DONATIONS-DEPOT I 516.00I -792.75I 634.00I 118.00I 22.86% I I I I I I I I I I I CONTRI/DONATIONS-PRIV SOUI 31516.00I -72161.22I 5334.00I -26182.00I -83.07% I I I I I I I I I I I 36690 I I I I I I I I REIMB: HOSPITAL STUDY I 0.00I -4272.46I 0.00I 0.00I 0.00% I I I 36691 I I I I I I I I REIMB: IN-KIND CONTRIBU/JI 91800.00I 0.00I 0.00I -91800.00I -100.00% I I I 36692 I I I I I I I I REIMB: NEIGHBORHOOD SERVII 90000.00I -54214.75I 15000.00I -75000.00I -83.33% I I I 36693 I I I I I I I I REIMB: EMA HOMELAND GRANTI 53000.00I -28400.00I 12000.00I -41000.00I -77.35% I I I Date: 9/09/2010 CITY OF JACKSON Page: 14 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 37208 I I I I I I I I REIMB:DELINQ TAX CHANCERYI 0.00I -15144.85I 10000.00I 10000.00I 100.00% I I I 37209 I I I I I I I I REIMBURSEMENTS: OTHER I 0.00I -7324.00I 0.00I 0.00I 0.00% I I I 37210 I I I I I I I I REIMB: DITCH WORK I 0.00I -9000.00I 0.00I 0.00I 0.00% I I I 37214 I I I I I I I I REIMB:DOWNTOWN STREET-CDBI 112721.25I -157330.25I 0.00I -112721.25I -100.00% I I I I I I I I I I I REIMBURSEMENTS I 347521.25I -275686.31I 37000.00I -310521.25I -89.35% 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 -27500.00I 0.00I 0.00I 0.00% I I I 37840 I I I I I I I I TRANSFER FRM OTHER FUNDS I 1500000.00I -3500000.00I 2000000.00I 500000.00I 33.33% I I I I I I I I I I I INTER-FUND TRANSFERS IN I 1500000.00I -3527500.00I 2000000.00I 500000.00I 33.33% I I I I I I I I I I I 37900 I I I I I I I I FROM FUND BALANCE I 336724.98I -38081.90I 931183.00I 594458.02I 176.54% I I I 37990 I I I I I I I I MISCELLANEOUS REVENUE I 2000.00I 29772.94I 25000.00I 23000.00I 1,150.00% I I I 37991 I I I I I I I I COPY REVENUE I 0.00I -173.45I 60.00I 60.00I 100.00% I I I 37992 I I I I I I I I RECYCLING REVENUE I 0.00I -447.98I 1000.00I 1000.00I 100.00% I I I 37996 I I I I I I I I CREDIT/DEBIT CARD FEES I 12000.00I -14397.75I 15000.00I 3000.00I 25.00% I I I 37997 I I I I I I I I ENERNOC FEES I 0.00I -4260.47I 5000.00I 5000.00I 100.00% I I I I I I I I I I I MISCELLANEOUS REVENUE I 350724.98I -27588.61I 977243.00I 626518.02I 178.63% I I I I I I I I I I I 39100 I I I I I I I I CASH SHORT AND OVER I 0.00I 329.33I 0.00I 0.00I 0.00% I I I I I I I I I I I CASH SHORT AND OVER I 0.00I 329.33I 0.00I 0.00I 0.00% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 64354864.45I -63097711.11I 63513950.77I -840913.68I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 15 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 64354864.45 -63097711.11 63513950.77 -840913.68 -1.30% Date: 9/09/2010 CITY OF JACKSON Page: 16 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 124 Fund Name: SPORTSPLEX FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 31920 I I I I I I I I HOTEL/MOTEL TAX I 357000.00I -271449.49I 310000.00I -47000.00I -13.16% I I I 31925 I I I I I I I I STATE SHARED SALES TAX I 152000.00I -232360.59I 275000.00I 123000.00I 80.92% I I I I I I I I I I I TAXES I 509000.00I -503810.08I 585000.00I 76000.00I 14.93% I I I I I I I I I I I 36704 I I I I I I I I SPONSORSHIPS I 400000.00I -349075.00I 305426.54I -94573.46I -23.64% I I I 36721 I I I I I I I I DONATIONS:WTNHC I 200000.00I -200000.00I 200000.00I 0.00I 0.00% I I I I I I I I I I I DONATIONS & CONTRIBUTIONSI 600000.00I -549075.00I 505426.54I -94573.46I -15.76% I I I I I I I I I I I 33100 I I I I I I I I TOURNAMENT FEES I 233000.00I -215879.00I 259000.00I 26000.00I 11.15% I I I 33101 I I I I I I I I GATE ADMISSIONS I 266422.00I -217697.52I 287000.00I 20578.00I 7.72% I I I 33102 I I I I I I I I CONCESSIONS REVENUE I 289000.00I -263775.61I 291000.00I 2000.00I 0.69% I I I 33103 I I I I I I I I GIFT SHOP SALES I 91812.00I -111024.99I 99900.00I 8088.00I 8.80% I I I 33104 I I I I I I I I TOURNAMENT SPONSORS I 5000.00I -3500.00I 8000.00I 3000.00I 60.00% I I I 33105 I I I I I I I I AMUSEMENT/RIDE COMMISSIONI 200.00I -1800.00I 0.00I -200.00I -100.00% I I I 33106 I I I I I I I I ONLINE SHIPPING I 0.00I -26.68I 200.00I 200.00I 100.00% I I I I I I I I I I I SPORTSPLEX REVENUES I 885434.00I -813703.80I 945100.00I 59666.00I 6.73% I I I I I I I I I I I 37200 I I I I I I I I REIMBURSEMENTS:SPORTSPLEXI 0.00I -36740.37I 0.00I 0.00I 0.00% I I I I I I I I I I I REIMBURSEMENTS:SPORTSPLEXI 0.00I -36740.37I 0.00I 0.00I 0.00% I I I I I I I I I I I 37900 I I I I I I I I FROM FUND BALANCE I 96066.44I 0.00I 58000.00I -38066.44I -39.62% I I I I I I I I I I I INTERFUND TRANSFERS IN I 96066.44I 0.00I 58000.00I -38066.44I -39.62% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 17 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 124 Fund Name: SPORTSPLEX FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 36100 I I I I I I I I INTEREST EARNED I 5000.00I 0.00I 5000.00I 0.00I 0.00% I I I I I I I I I I I INTEREST EARNED I 5000.00I 0.00I 5000.00I 0.00I 0.00% I I I I I I I I I I I 39100 I I I I I I I I CASH SHORT AND OVER I 0.00I -101.14I 0.00I 0.00I 0.00% I I I I I I I I I I I CASH SHORT AND OVER I 0.00I -101.14I 0.00I 0.00I 0.00% I I I I I I I I I I I I I I I I I I I SPORTSPLEX TOTAL REVENUE I 2095500.44I -1903430.39I 2098526.54I 3026.10I 0.00% I I I I I I I I I I I 36350 I I I I I I I I INSURANCE RECOVERIES I 0.00I -13858.80I 0.00I 0.00I 0.00% I I I 37990 I I I I I I I I MISCELLANEOUS REVENUE I 0.00I -81.82I 0.00I 0.00I 0.00% I I I I I I I I I I I MISCELLANEOUS REVENUE I 0.00I -13940.62I 0.00I 0.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 18 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 124 Fund Name: SPORTSPLEX FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 2095500.44 -1917371.01 2098526.54 3026.10 0.14% Date: 9/09/2010 CITY OF JACKSON Page: 19 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 125 Fund Name: COMMUNITY DEVELOPMENT FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 34811 I I I I I I I I PRINCIPAL-SBL REPMTS I 0.00I -11973.42I 0.00I 0.00I 0.00% I I I 34811-01 I I I I I I I I PRINCIPAL-SBL LOANS I 0.00I 10983.00I 0.00I 0.00I 0.00% I I I 36111 I I I I I I I I INTEREST-SBL REPMTS I 0.00I -689.55I 0.00I 0.00I 0.00% I I I I I I I I I I I OTHER FUND SOURCES-SBL REI 0.00I -1679.97I 0.00I 0.00I 0.00% I I I I I I I I I I I 34840 I I I I I I I I NON FEDERAL HOUSING I 0.00I -191.91I 0.00I 0.00I 0.00% I I I 34840-01 I I I I I I I I NON FEDERAL HOUSING I 0.00I 191.91I 0.00I 0.00I 0.00% I I I 34841 I I I I I I I I PRINCIPAL-EMGY REP REPMI 0.00I -2698.89I 0.00I 0.00I 0.00% I I I 34841-01 I I I I I I I I PRINCIPAL-EMGY REP LOANS I 0.00I 2426.94I 0.00I 0.00I 0.00% I I I 36141 I I I I I I I I INTEREST-EMGY REP REPMTI 0.00I -61.34I 0.00I 0.00I 0.00% I I I I I I I I I I I OTH FND SOURCES-EMER REP I 0.00I -333.29I 0.00I 0.00I 0.00% I I I I I I I I I I I 34850 I I I I I I I I PRINCIPAL-HOME TA REHABI 0.00I -23820.86I 0.00I 0.00I 0.00% I I I 34850-01 I I I I I I I I PRINCIPAL-HOME TA REHAB LI 0.00I 22594.20I 0.00I 0.00I 0.00% I I I 36150 I I I I I I I I INTEREST-HOME TA REHAB I 0.00I -3040.92I 0.00I 0.00I 0.00% I I I I I I I I I I I OTH FND SOURCES-HOME T.A.I 0.00I -4267.58I 0.00I 0.00I 0.00% I I I I I I I I I I I 34800 I I I I I I I I HOME PROGRAM INCOME I 526156.00I 0.00I 444626.00I -81530.00I -15.49% I I I 37300 I I I I I I I I PROGRAM INCOME-CDBG I 804367.00I 0.00I 693416.00I -110951.00I -13.79% I I I 37405 I I I I I I I I ESG ALLOCATION I 96772.00I 0.00I 96771.00I -1.00I 0.00% I I I I I I I I I I I COMMUNITY DEV REVENUE I 1427295.00I 0.00I 1234813.00I -192482.00I -13.48% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 1427295.00I -6280.84I 1234813.00I -192482.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 20 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 125 Fund Name: COMMUNITY DEVELOPMENT FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 1427295.00 -6280.84 1234813.00 -192482.00 -13.48% Date: 9/09/2010 CITY OF JACKSON Page: 21 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 131 Fund Name: SOLID WASTE COLLECTION FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 33176 I I I I I I I I STATE RECYCLING GRANT I 8778.00I 0.00I 8778.00I 0.00I 0.00% I I I 33177 I I I I I I I I HOST FEES-LANDFILL I 210000.00I -197133.70I 169663.83I -40336.17I -19.20% I I I I I I I I I I I FEDERAL & STATE GRANTS I 218778.00I -197133.70I 178441.83I -40336.17I -18.43% I I I I I I I I I I I 34314 I I I I I I I I MOWING CHARGES I 0.00I -1180.12I 0.00I 0.00I 0.00% I I I 37710 I I I I I I I I GARBAGE COLLECTION REVENUI 9988366.80I -10241878.44I 9990000.00I 1633.20I 0.01% I I I 37711 I I I I I I I I GARBAGE RESET FEE I 500.00I -325.00I 500.00I 0.00I 0.00% I I I 37712 I I I I I I I I PENALTIES FOR GARBAGE I 40000.00I -43049.94I 40000.00I 0.00I 0.00% I I I I I I I I I I I CHARGES FOR SERVICES I 10028866.80I -10286433.50I 10030500.00I 1633.20I 0.01% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNINGS I 30000.00I -7161.58I 10000.00I -20000.00I -66.66% I I I 37900 I I I I I I I I FROM FUND BALANCE I 0.00I 0.00I 851385.57I 851385.57I 100.00% I I I 37991 I I I I I I I I COPY REVENUE I 50.00I 0.00I 50.00I 0.00I 0.00% I I I I I I I I I I I OTHER REVENUE I 30050.00I -7161.58I 861435.57I 831385.57I 2,766.67% I I I I I I I I I I I I I I I I I I I TOTAL H & S REVENUES I 10277694.80I -10490728.78I 11070377.40I 792682.60I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 22 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 131 Fund Name: SOLID WASTE COLLECTION FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 10277694.80 -10490728.78 11070377.40 792682.60 7.71% Date: 9/09/2010 CITY OF JACKSON Page: 23 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 141 Fund Name: POLICE DRUG FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 35000 I I I I I I I I FINES I 90000.00I -70541.75I 85000.00I -5000.00I -5.55% I I I 35250 I I I I I I I I SALE:SEIZED ASSETS/UNCLAII 9000.00I -4714.76I 9000.00I 0.00I 0.00% I I I I I I I I I I I FINES & FORFEITURES I 99000.00I -75256.51I 94000.00I -5000.00I -5.05% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNINGS I 2000.00I -352.17I 500.00I -1500.00I -75.00% I I I I I I I I I I I OTHER REVENUE I 2000.00I -352.17I 500.00I -1500.00I -75.00% I I I I I I I I I I I I I I I I I I I TOTAL POLICE DRUG FUND REI 101000.00I -75608.68I 94500.00I -6500.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 24 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 141 Fund Name: POLICE DRUG FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 101000.00 -75608.68 94500.00 -6500.00 -6.43% Date: 9/09/2010 CITY OF JACKSON Page: 25 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 142 Fund Name: METRO DRUG FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 35140 I I I I I I I I FINES I 80000.00I -12328.16I 80000.00I 0.00I 0.00% I I I 35160 I I I I I I I I FINES-DTF I 3500.00I -1925.37I 2500.00I -1000.00I -28.57% I I I 35200 I I I I I I I I SEIZURES I 68000.00I -111785.18I 80000.00I 12000.00I 17.64% I I I 35250 I I I I I I I I CONTROLLED SUBSTANCE TAX I 11000.00I -33295.01I 0.00I -11000.00I -100.00% I I I 36350 I I I I I I I I FEDERAL EQ SHARING I 42462.00I -151184.83I 25000.00I -17462.00I -41.12% I I I 36991 I I I I I I I I MISC REIMBURSEMENTS I 0.00I -1472.71I 0.00I 0.00I 0.00% I I I I I I I I I I I OPERATING REVENUES I 204962.00I -311991.26I 187500.00I -17462.00I -8.51% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNED I 0.00I -343.59I 200.00I 200.00I 100.00% I I I I I I I I I I I NON-OPERATING REVENUES I 0.00I -343.59I 200.00I 200.00I 100.00% I I I I I I I I I I I I I I I I I I I METRO DRUG FUND REVENUES I 204962.00I -312334.85I 187700.00I -17262.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 26 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 142 Fund Name: METRO DRUG FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 204962.00 -312334.85 187700.00 -17262.00 -8.42% Date: 9/09/2010 CITY OF JACKSON Page: 27 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 211 Fund Name: DEBT SERVICE FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 31100 I I I I I I I I DELINQ TAX-2000 I 344.00I -349.90I 409.00I 65.00I 18.89% I I I 31101 I I I I I I I I DELINQ TAX-2001 I 562.00I -334.39I 420.00I -142.00I -25.26% I I I 31102 I I I I I I I I DELINQ TAX-2002 I 874.00I -552.82I 1008.00I 134.00I 15.33% I I I 31103 I I I I I I I I DELINQ TAX-2003 I 1113.00I -1424.05I 934.00I -179.00I -16.08% I I I 31104 I I I I I I I I DELINQ TAX-2004 I 1293.00I -1378.25I 895.00I -398.00I -30.78% I I I 31105 I I I I I I I I DELINQ TAX-2005 I 4886.00I -3282.07I 4575.00I -311.00I -6.36% I I I 31106 I I I I I I I I DELINQ TAX-2006 I 4706.00I -6155.23I 2894.00I -1812.00I -38.50% I I I 31107 I I I I I I I I DELINQ TAX-2007 I 26135.00I -30622.58I 5553.00I -20582.00I -78.75% I I I 31108 I I I I I I I I DELINQ TAX-2008 I 119276.00I -123336.81I 34860.00I -84416.00I -70.77% I I I 31109 I I I I I I I I DELINQ TAX-2009 I 0.00I 0.00I 121628.00I 121628.00I 100.00% I I I 31198 I I I I I I I I DELINQ TAX-1998 I 207.00I -36.62I 0.00I -207.00I -100.00% I I I 31199 I I I I I I I I DELINQ TAX-1999 I 392.00I -285.30I 279.00I -113.00I -28.82% I I I I I I I I I I I TOTAL DELINQUENT TAX COLLI 159788.00I -167758.02I 173455.00I 13667.00I 8.55% I I I I I I I I I I I 31400 I I I I I I I I CURRENT PROPERTY TAX COLLI 3730681.00I -3738795.88I 4464415.00I 733734.00I 19.66% I I I I I I I I I I I CURRENT PROPERTY TAX COLLI 3730681.00I -3738795.88I 4464415.00I 733734.00I 19.66% 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 331744.00I -60505.39I 58103.00I -273641.00I -82.48% I I I 31511 I I I I I I I I TAX EQUIV-ELECTRIC I 37502.00I -362958.48I 400756.00I 363254.00I 968.62% I I I 31512 I I I I I I I I TAX EQUIV. - WATER I 649.00I 0.00I 45172.00I 44523.00I 6,860.24% I I I 31513 I I I I I I I I TAX EQUIV-WESLEY I 165872.00I 0.00I 757.00I -165115.00I -99.54% I I I 31514 I I I I I I I I TAX EQUIV-GAS I 2308.00I -176236.56I 201538.00I 199230.00I 8,632.14% I I I Date: 9/09/2010 CITY OF JACKSON Page: 28 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 211 Fund Name: DEBT SERVICE FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 31515 I I I I I I I I TAX EQUIV-JHA I 779.00I 0.00I 2691.00I 1912.00I 245.44% I I I 31516 I I I I I I I I TAX EQUIV-ST MARY MANOR I 0.00I 0.00I 908.00I 908.00I 100.00% I I I I I I I I I I I TAX EQUIVALENTS I 538854.00I -599700.43I 709925.00I 171071.00I 31.74% I I I I I I I I I I I 31610 I I I I I I I I LOCAL OPTION SALES TAX-PPI 30000.00I -27781.57I 30000.00I 0.00I 0.00% I I I 33510 I I I I I I I I STATE SHARED SALES TAX-PPI 60000.00I -61920.65I 60000.00I 0.00I 0.00% I I I 36530 I I I I I I I I INTEREST EARNED I 25000.00I -18408.11I 25000.00I 0.00I 0.00% I I I 36932 I I I I I I I I PROCEEDS FROM BONDS(2009-I 0.00I -7169662.83I 1070000.00I 1070000.00I 100.00% I I I 37900 I I I I I I I I FROM FUND BALANCE I 2500000.00I 0.00I 0.00I -2500000.00I -100.00% I I I I I I I I I I I OTHER REVENUE I 2615000.00I -7277773.16I 1185000.00I -1430000.00I -54.68% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 7044323.00I -11784027.49I 6532795.00I -511528.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 29 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 211 Fund Name: DEBT SERVICE FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 7044323.00 -11784027.49 6532795.00 -511528.00 -7.26% Date: 9/09/2010 CITY OF JACKSON Page: 30 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 310 Fund Name: INDUSTRIAL DEVELOPMENT FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 Date: 9/09/2010 CITY OF JACKSON Page: 31 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 312 Fund Name: KATE CAMPBELL ROBERTSON PARK F I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 36980 I I I I I I I I TRNSF FRM RBTSON TRUST FNI 30000.00I 0.00I 30000.00I 0.00I 0.00% I I I I I I I I I I I KCRP REVENUE I 30000.00I 0.00I 30000.00I 0.00I 0.00% I I I I I I I I I I I I I I I I I I I TOTAL KCRP REVENUE I 30000.00I 0.00I 30000.00I 0.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 32 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 312 Fund Name: KATE CAMPBELL ROBERTSON PARK F I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 30000.00 0.00 30000.00 0.00 0.00% Date: 9/09/2010 CITY OF JACKSON Page: 33 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 315 Fund Name: CAPITAL OUTLAY FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 33491 I I I I I I I I TRANSPORT ENHANC-E.CHESTEI 2549429.23I -622296.21I 1971120.13I -578309.10I -22.68% I I I 33495 I I I I I I I I CASEY JONES-TRANSPORTATIOI 0.00I -150183.88I 0.00I 0.00I 0.00% I I I I I I I I I I I STATE GRANTS I 2549429.23I -772480.09I 1971120.13I -578309.10I -22.68% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNED I 0.00I -13724.13I 527.52I 527.52I 100.00% I I I I I I I I I I I INTEREST EARNED I 0.00I -13724.13I 527.52I 527.52I 100.00% I I I I I I I I I I I 37300 I I I I I I I I SALE OF CAPITAL ASSETS I 0.00I -42533.81I 0.00I 0.00I 0.00% I I I 37301 I I I I I I I I SALE OF LAND I 0.00I -36826.38I 0.00I 0.00I 0.00% I I I I I I I I I I I SALE/COMPEN FOR LOSS-FXD I 0.00I -79360.19I 0.00I 0.00I 0.00% I I I I I I I I I I I 36961 I I I I I I I I TRNSF FRM GEN FND (BUDGETI 73000.00I 0.00I 931183.00I 858183.00I 1,175.59% I I I 36962 I I I I I I I I TRNSF FRM DEBT SERVICE I 4421977.77I -4884428.60I 0.00I -4421977.77I -100.00% I I I 37900 I I I I I I I I FROM FUND BALANCE I 0.00I 0.00I 2746475.00I 2746475.00I 100.00% I I I I I I I I I I I INTER-FUND TRANSFERS IN I 4494977.77I -4884428.60I 3677658.00I -817319.77I -18.18% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 7044407.00I -5749993.01I 5649305.65I -1395101.35I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 34 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 315 Fund Name: CAPITAL OUTLAY FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 7044407.00 -5749993.01 5649305.65 -1395101.35 -19.80% Date: 9/09/2010 CITY OF JACKSON Page: 35 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 440 Fund Name: LANDFILL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 37728 I I I I I I I I TRANSFER FROM OTHER FD I 65000.00I 0.00I 65500.00I 500.00I 0.76% I I I I I I I I I I I OPERATING REVENUE I 65000.00I 0.00I 65500.00I 500.00I 0.76% I I I I I I I I I I I 37910 I I I I I I I I INTEREST EARNINGS I 0.00I -1339.89I 0.00I 0.00I 0.00% I I I I I I I I I I I MISCELLANEOUS REVENUE I 0.00I -1339.89I 0.00I 0.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 36 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 440 Fund Name: LANDFILL FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 65000.00 -1339.89 65500.00 500.00 0.76% Date: 9/09/2010 CITY OF JACKSON Page: 37 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 441 Fund Name: COMMUNITY REDEVELOPMENT FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 38101 I I I I I I I I HOSPITAL LOAN PROCEEDS I 0.00I -650000.00I 0.00I 0.00I 0.00% I I I 38102 I I I I I I I I RENTAL REVENUE I 8000.00I -1177.28I 0.00I -8000.00I -100.00% I I I 38103 I I I I I I I I TRANSFER FROM OTHER FUNDSI 102866.15I -650000.00I 63000.00I -39866.15I -38.75% I I I 38104 I I I I I I I I INTEREST REVENUE I 0.00I -7.03I 0.00I 0.00I 0.00% I I I I I I I I I I I COMMUN REDEVE REVENUE I 110866.15I -1301184.31I 63000.00I -47866.15I -43.17% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 38 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 441 Fund Name: COMMUNITY REDEVELOPMENT FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 110866.15 -1301184.31 63000.00 -47866.15 -43.17% Date: 9/09/2010 CITY OF JACKSON Page: 39 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 611 Fund Name: ROBERTSON TRUST FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 36100 I I I I I I I I INTEREST EARNED I 30000.00I -37105.01I 30000.00I 0.00I 0.00% I I I I I I I I I I I RTF REVENUE I 30000.00I -37105.01I 30000.00I 0.00I 0.00% 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 12174.00I 0.00I 0.00I 0.00% I I I I I I I I I I I INC/(DEC) IN FMV OF INVESI 0.00I 12174.00I 0.00I 0.00I 0.00% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 30000.00I -24931.01I 30000.00I 0.00I 0.00% I I I I I I I I I I I Date: 9/09/2010 CITY OF JACKSON Page: 40 Time: 14:36 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 611 Fund Name: ROBERTSON TRUST FUND I CURRENT I 2010 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2010 BUDGET I TOTALS I2011 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 30000.00 -24931.01 30000.00 0.00 0.00% Grand Total 92785912.84 -94761510.98 90570468.36 -2215444.48 -2.38%