Date: 6/16/2011 CITY OF JACKSON Page: 1 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 22270444.00I -21683559.86I 21914316.00I -356128.00I -1.59% I I I I I I I I I I I CURRENT TAXES GENERAL FUNI 22270444.00I -21683559.86I 21914316.00I -356128.00I -1.59% 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 2021.00I -1520.64I 1199.00I -822.00I -40.67% I I I 31101 I I I I I I I I R.E. TAXES 2001 I 2079.00I -1881.19I 2069.00I -10.00I -0.48% I I I 31102 I I I I I I I I R.E. TAXES 2002 I 4985.00I -2429.50I 3122.00I -1863.00I -37.37% I I I 31103 I I I I I I I I R.E. TAXES 2003 I 4620.00I -1996.94I 4289.00I -331.00I -7.16% I I I 31104 I I I I I I I I R.E. TAXES 2004 I 4424.00I -6509.38I 2702.00I -1722.00I -38.92% I I I 31105 I I I I I I I I R.E. TAXES 2005 I 22628.00I -8963.55I 13726.00I -8902.00I -39.34% I I I 31106 I I I I I I I I R.E. TAXES 2006 I 14315.00I -12066.39I 10236.00I -4079.00I -28.49% I I I 31107 I I I I I I I I R.E. TAXES 2007 I 27464.00I -42924.94I 10621.00I -16843.00I -61.32% I I I 31108 I I I I I I I I R.E. TAXES 2008 I 172410.00I -164680.25I 29116.00I -143294.00I -83.11% I I I 31109 I I I I I I I I R.E. TAXES 2009 I 601486.00I -561119.79I 184881.00I -416605.00I -69.26% I I I 31110 I I I I I I I I R.E. TAXES 2010 I 0.00I 0.00I 681573.00I 681573.00I 100.00% I I I 31199 I I I I I I I I R. E. TAXES 1999 I 1381.00I -2575.17I 0.00I -1381.00I -100.00% I I I I I I I I I I I TOTAL R.E. TAXES I 857813.00I -806667.74I 943534.00I 85721.00I 9.99% 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 450000.00I -439903.66I 500000.00I 50000.00I 11.11% I I I 31330 I I I I I I I I ATTY FEES-DELINQ. R.E. TAI 0.00I 1333.54I 0.00I 0.00I 0.00% I I I I I I I I I I I INTEREST/PENALTY R.E TAXEI 450000.00I -438570.12I 500000.00I 50000.00I 11.11% 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 287334.00I -315382.76I 315000.00I 27666.00I 9.62% I I I Date: 6/16/2011 CITY OF JACKSON Page: 2 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 1982044.00I -1750090.71I 2031839.00I 49795.00I 2.51% I I I 31512 I I I I I I I I LIEU TAX WATER I 223408.00I -235458.37I 290830.00I 67422.00I 30.17% I I I 31513 I I I I I I I I TAX EQUIV.-WESLEY I 3743.00I -4500.00I 3630.00I -113.00I -3.01% I I I 31514 I I I I I I I I TAX EQ.-GAS I 996762.00I -839472.24I 963869.00I -32893.00I -3.29% I I I 31515 I I I I I I I I TAX EQ.-JHA(HOUSING) I 13309.00I 0.00I 10730.00I -2579.00I -19.37% I I I 31516 I I I I I I I I TAX EQ.-ST. MARY MANOR I 4492.00I -5400.00I 4356.00I -136.00I -3.02% I I I I I I I I I I I TAX EQUIVALENT I 3511092.00I -3150304.08I 3620254.00I 109162.00I 3.10% I I I I I I I I I I I 31610 I I I I I I I I LOCAL SALES TAX I 11298000.00I -7795474.88I 12008238.00I 710238.00I 6.28% I I I 31710 I I I I I I I I CITY BEER TAX I 1630000.00I -1381349.40I 1630000.00I 0.00I 0.00% I I I 31720 I I I I I I I I WHOLESALE LIQUOR TAX I 500000.00I -445963.68I 500000.00I 0.00I 0.00% I I I 31800 I I I I I I I I BUSINESS TAX I 1375000.00I -759131.10I 1428000.00I 53000.00I 3.85% I I I 31830 I I I I I I I I BUSINESS LICENSE PENT & II 25000.00I -1719.64I 5000.00I -20000.00I -80.00% I I I 31912 I I I I I I I I CATV-CHARTER REVENUE I 380000.00I -161806.15I 320000.00I -60000.00I -15.78% I I I 31913 I I I I I I I I CATV-JEA REVENUE I 440000.00I -265955.69I 535000.00I 95000.00I 21.59% I I I 31920 I I I I I I I I HOTEL - MOTEL TAX I 390000.00I -258023.22I 390000.00I 0.00I 0.00% I I I 31980 I I I I I I I I MIXED DRINK TAXES I 55000.00I -48380.00I 55000.00I 0.00I 0.00% I I I I I I I I I I I VARIOUS TAXES I 16093000.00I -11117803.76I 16871238.00I 778238.00I 4.83% 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 -868022.01I 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 -20224.00I 25000.00I 0.00I 0.00% I I I 32310 I I I I I I I I CHAUFFEURS LICENSE I 250.00I -605.00I 505.00I 255.00I 102.00% I I I Date: 6/16/2011 CITY OF JACKSON Page: 3 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 -2000.00I 2500.00I 2000.00I 400.00% I I I I I I I I I I I LICENSES & FEES I 1025750.00I -890851.01I 1028005.00I 2255.00I 0.21% 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 -62157.50I 60000.00I -10000.00I -14.28% I I I 32610 I I I I I I I I BUILDING PERMITS I 357500.00I -238583.22I 300000.00I -57500.00I -16.08% I I I 32611 I I I I I I I I BLDG/PROPERTY LIENS I 0.00I -15943.29I 20000.00I 20000.00I 100.00% I I I 32615 I I I I I I I I PLANS REVIEW I 154000.00I -95156.81I 140000.00I -14000.00I -9.09% I I I 32620 I I I I I I I I ELECTRIC PERMITS I 80000.00I -71205.00I 80000.00I 0.00I 0.00% I I I 32630 I I I I I I I I PLUMBING PERMITS I 55000.00I -28262.50I 45000.00I -10000.00I -18.18% I I I 32640 I I I I I I I I GAS PERMITS I 22000.00I -12590.00I 16000.00I -6000.00I -27.27% I I I 32670 I I I I I I I I MECHANICAL PERMITS I 38000.00I -25202.00I 28000.00I -10000.00I -26.31% I I I 32680 I I I I I I I I SIGN PERMITS I 18000.00I -15596.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 -1000.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 -2450.00I 2450.00I 450.00I 22.50% I I I 32683 I I I I I I I I LANDSCAPE REVIEW FEE I 1000.00I -1200.00I 1200.00I 200.00I 20.00% I I I I I I I I I I I BUILDING & RELATED PERMITI 798500.00I -569346.32I 711650.00I -86850.00I -10.87% 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 -10.00I 0.00I 0.00I 0.00% I I I 32692 I I I I I I I I CODE I 6500.00I -6150.00I 6000.00I -500.00I -7.69% I I I 32694 I I I I I I I I INVESTIGATION FEES - BEERI 10000.00I -10050.00I 10000.00I 0.00I 0.00% I I I 32695 I I I I I I I I ZONING APPLICATION FES-PLI 6200.00I -4150.00I 4300.00I -1900.00I -30.64% I I I 32696 I I I I I I I I SUB-DIVISION REVIEW FEES-I 2500.00I -1425.00I 1425.00I -1075.00I -43.00% I I I Date: 6/16/2011 CITY OF JACKSON Page: 4 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 32697 I I I I I I I I ENG STREET LIGHT FEES I 8000.00I -11200.00I 13000.00I 5000.00I 62.50% I I I I I I I I I I I VARIOUS FEES I 33200.00I -32985.00I 34725.00I 1525.00I 4.59% I I I I I I I I I I I 33107 I I I I I I I I FEMA: FLOOD 2010 I 0.00I -26997.85I 0.00I 0.00I 0.00% I I I 33126 I I I I I I I I SART GRANT REVENUE I 80000.00I -36832.16I 0.00I -80000.00I -100.00% I I I 33127 I I I I I I I I 2006 METH GRANT I 55000.00I -17521.20I 35145.18I -19854.82I -36.09% I I I 33129 I I I I I I I I CRE GRANT I 39852.15I -13426.94I 13262.60I -26589.55I -66.72% I I I 33131 I I I I I I I I 2008 BYRNE GRANT FOR DRUGI 1.00I -3601.31I 0.00I -1.00I -100.00% I I I 33132 I I I I I I I I 2007 METH INITIATIVE GRANI 335000.00I -15071.09I 0.00I -335000.00I -100.00% I I I 33134 I I I I I I I I 09 JAG RECOVERY I 142000.00I -33725.13I 87829.68I -54170.32I -38.14% I I I 33135 I I I I I I I I STOP DOMESTIC VIOLENCE I 64068.00I -52516.97I 0.00I -64068.00I -100.00% I I I 33136 I I I I I I I I COLD CASE UNIT GRANT I 68200.00I -41816.16I 0.00I -68200.00I -100.00% I I I 33137 I I I I I I I I COPS HIRING GRANT I 1247874.22I -221706.72I 826462.15I -421412.07I -33.77% I I I 33139 I I I I I I I I 09 JAG GRANT I 76658.43I -45817.47I 10031.16I -66627.27I -86.91% I I I 33141 I I I I I I I I DRUG COURT GRANT I 50000.00I -22488.15I 50000.00I 0.00I 0.00% I I I 33148 I I I I I I I I BYRNE GRANT-DRUG COURT I 29617.00I -22318.47I 0.00I -29617.00I -100.00% I I I 33150 I I I I I I I I JUVENILE & NEIGHB SAFE PRI 303324.00I -152569.06I 115781.75I -187542.25I -61.82% 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 33152 I I I I I I I I BROWNSFIELD CLEANUP GRANTI 6336.88I -3630.00I 0.00I -6336.88I -100.00% I I I 33153 I I I I I I I I REENTRY GRANT I 612908.00I -110032.61I 443858.27I -169049.73I -27.58% I I I 33154 I I I I I I I I ENERGY&EFFICIENCY CONS GRI 567910.00I -12222.50I 250000.00I -317910.00I -55.97% I I I Date: 6/16/2011 CITY OF JACKSON Page: 5 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 33194 I I I I I I I I TARGETED COMM VIOLENT CRII 1200000.00I -75019.70I 1085640.37I -114359.63I -9.52% I I I 33197 I I I I I I I I 2010 BYRNE MEMORIAL JAG GI 91265.00I 0.00I 49886.02I -41378.98I -45.33% I I I 33198 I I I I I I I I 2008 EDWARD BYRNE MEM JAGI 0.00I -785.00I 0.00I 0.00I 0.00% I I I 33199 I I I I I I I I 2007 BYRNE JAG GRANT I 8636.40I -8636.40I 0.00I -8636.40I -100.00% I I I I I I I I I I I FEDERAL GRANTS I 5152618.08I -916734.89I 3141864.18I -2010753.90I -39.02% 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 -3900.00I 0.00I -348935.00I -100.00% I I I 33410 I I I I I I I I ST LAW ENFORCEMENT EDUC SI 123600.00I -114600.00I 131400.00I 7800.00I 6.31% I I I 33420 I I I I I I I I ST FIRE PROTECTION EDUC SI 85200.00I -96000.00I 97800.00I 12600.00I 14.78% I I I 33430 I I I I I I I I TENN AGRICULTURAL ENH GRAI 2500.00I 0.00I 0.00I -2500.00I -100.00% I I I 33434 I I I I I I I I RTP GRANT: LIBERTY GARDENI 0.00I 0.00I 80000.00I 80000.00I 100.00% I I I 33461 I I I I I I I I NRPA ACHIEVE GRANT I 23000.00I -12000.00I 18500.00I -4500.00I -19.56% I I I 33491 I I I I I I I I CARFP: SNACK FOOD I 0.00I -931.66I 0.00I 0.00I 0.00% I I I 33492 I I I I I I I I MPO-SPR I 0.00I 0.00I 50439.20I 50439.20I 100.00% I I I 37993 I I I I I I I I ST OF TN:MUNICIPAL PLN OFI 188000.00I -4790.28I 138283.00I -49717.00I -26.44% I I I 37994 I I I I I I I I DOT: TRANSP/PLANNING PROJI 532364.98I -160789.42I 301764.80I -230600.18I -43.31% I I I I I I I I I I I STATE GRANTS I 1303599.98I -393011.36I 818187.00I -485412.98I -37.23% I I I I I I I I I I I 31517 I I I I I I I I STATE EXCISE TAX I 150000.00I -85103.05I 156000.00I 6000.00I 4.00% I I I 31930 I I I I I I I I STATE MIXED DRINK TAXES I 300000.00I -253101.26I 315000.00I 15000.00I 5.00% I I I 31941 I I I I I I I I ST REIMB-TDOT-SSA I 206674.00I -185438.75I 206674.00I 0.00I 0.00% I I I 33510 I I I I I I I I STATE SALES TAX I 3720000.00I -2592584.43I 4077564.00I 357564.00I 9.61% I I I Date: 6/16/2011 CITY OF JACKSON Page: 6 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 33520 I I I I I I I I STATE INCOME TAX I 400000.00I 0.00I 440000.00I 40000.00I 10.00% I I I 33530 I I I I I I I I STATE BEER TAX I 20000.00I -31115.46I 20400.00I 400.00I 2.00% I I I 33551 I I I I I I I I GAS,MOTOR FUEL,ADDL 3-CNTI 1374500.00I -1148088.45I 1464500.00I 90000.00I 6.54% I I I 33580 I I I I I I I I SP PETROLEUM PRODUCTS (88I 93120.00I 0.00I 97310.00I 4190.00I 4.49% I I I 33591 I I I I I I I I STATE TVA GROSS RECEIPTS I 633700.00I -504579.30I 652711.00I 19011.00I 3.00% I I I I I I I I I I I STATE REVENUE ALLOCATIONSI 6897994.00I -4800010.70I 7430159.00I 532165.00I 7.71% 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 -320.00I 1000.00I -14000.00I -93.33% I I I I I I I I I I I BUSINESS TAX CLERK FEES I 15000.00I -320.00I 1000.00I -14000.00I -93.33% I I I I I I I I I I I 34125 I I I I I I I I HANDLING FEES I 0.00I -4118.00I 5000.00I 5000.00I 100.00% I I I 34138 I I I I I I I I PLANNING EXPENSES:3-WAY I 400.00I 0.00I 400.00I 0.00I 0.00% I I I 34139 I I I I I I I I PLN SERV:MAD CO I 26000.00I -14000.00I 26000.00I 0.00I 0.00% I I I 34221 I I I I I I I I FIRE REPORTS I 100.00I -42.25I 100.00I 0.00I 0.00% I I I 34293 I I I I I I I I FIRE TRAINING FEES I 20000.00I -28782.23I 30000.00I 10000.00I 50.00% I I I 37302 I I I I I I I I HOUSE/BUILDING DEMOLITIONI 0.00I -2909.07I 5000.00I 5000.00I 100.00% I I I I I I I I I I I CHARGES FOR SERVICES I 46500.00I -49851.55I 66500.00I 20000.00I 43.01% I I I I I I I I I I I 32650 I I I I I I I I DEVELOPMENT PERMITS/ENG I 2000.00I -4625.00I 4500.00I 2500.00I 125.00% I I I 32690 I I I I I I I I MOVING PERMITS I 75.00I -125.00I 100.00I 25.00I 33.33% I I I 34311 I I I I I I I I ENG. PERMIT FEES,STREET,DI 30000.00I -17771.04I 20000.00I -10000.00I -33.33% I I I 34315 I I I I I I I I TRAFFIC SIGN/MISC. REVENUI 3000.00I -1698.90I 2000.00I -1000.00I -33.33% I I I Date: 6/16/2011 CITY OF JACKSON Page: 7 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 34317 I I I I I I I I ENGINEERING - MISC REVENUI 300.00I -2147.00I 500.00I 200.00I 66.66% I I I 34318 I I I I I I I I ENG REVIEW FEES-COUNTY S/I 250.00I -225.00I 250.00I 0.00I 0.00% I I I 34319 I I I I I I I I ENG REVIEW FEES-CITY SUBDI 2000.00I -1625.00I 2000.00I 0.00I 0.00% 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 2000.00I -1374.00I 1500.00I -500.00I -25.00% I I I I I I I I I I I STREET CHARGES FOR SERVICI 40125.00I -29590.94I 31350.00I -8775.00I -21.86% 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 -426346.08I 600000.00I -25000.00I -4.00% I I I 35101 I I I I I I I I ENVIRONMENTAL COURT REVENI 18000.00I -9518.83I 10000.00I -8000.00I -44.44% I I I 35103 I I I I I I I I INTERPRETING FEES I 0.00I -500.00I 0.00I 0.00I 0.00% I I I 35105 I I I I I I I I DRUG LITIGATION TAX I 85000.00I -69535.00I 85000.00I 0.00I 0.00% I I I 35106 I I I I I I I I DRUG COURT FEES I 2500.00I -2145.00I 2500.00I 0.00I 0.00% I I I 35110 I I I I I I I I CITY JAIL & OFFICERS FEESI 2500.00I -5691.71I 5500.00I 3000.00I 120.00% I I I I I I I I I I I FINES AND FORFEITURES I 733000.00I -513736.62I 703000.00I -30000.00I -4.09% 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 -182452.37I 244000.00I 0.00I 0.00% I I I 34211 I I I I I I I I BAR DETAIL REVENUE I 25000.00I -17281.25I 25000.00I 0.00I 0.00% I I I 34240 I I I I I I I I ACCIDENT REPORT FEES I 0.00I -7545.86I 10000.00I 10000.00I 100.00% I I I 34290 I I I I I I I I DRIVER IMPROVMNT PROG FEEI 3000.00I -1905.00I 3000.00I 0.00I 0.00% I I I 34291 I I I I I I I I SEAT BELT FEES I 0.00I -1240.00I 1500.00I 1500.00I 100.00% I I I 35000 I I I I I I I I POLICE RED LIGHT OVERAGE I 0.00I -260.00I 0.00I 0.00I 0.00% I I I 35102 I I I I I I I I PHOTO ENFORCEMENT I 400000.00I -290028.31I 400000.00I 0.00I 0.00% I I I Date: 6/16/2011 CITY OF JACKSON Page: 8 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 35104 I I I I I I I I SPEED ENFORCEMENT I 300000.00I -294836.31I 400000.00I 100000.00I 33.33% I I I 35120 I I I I I I I I PARKING TICKETS I 65000.00I -41956.00I 65000.00I 0.00I 0.00% I I I 35121 I I I I I I I I CITY STICKER TICKETS I 45000.00I -35475.00I 45000.00I 0.00I 0.00% I I I 35214 I I I I I I I I FED EQUITABLE SHARE-SEIZEI 0.00I -0.49I 0.00I 0.00I 0.00% I I I 35361 I I I I I I I I SEX OFFENDER REGIS FEES I 13000.00I -12600.00I 13000.00I 0.00I 0.00% I I I 37198 I I I I I I I I REIMB: OCDETF I 0.00I -30110.64I 0.00I 0.00I 0.00% I I I 37199 I I I I I I I I REIMB: US MARSHALL SERVICI 0.00I -13907.59I 10000.00I 10000.00I 100.00% I I I 37200 I I I I I I I I REIMB:WEST TENN HEALTHCARI 110725.00I -83666.25I 110725.00I 0.00I 0.00% I I I 37201 I I I I I I I I REIMB:MAD CO SHERIFF-METRI 58000.00I -32031.31I 32000.00I -26000.00I -44.82% I I I 37202 I I I I I I I I REIMB: FINANCIAL FRAUD UNI 0.00I -11575.98I 5000.00I 5000.00I 100.00% I I I 37204 I I I I I I I I REIMB:POLICE DEPARTMENT I 0.00I -580.20I 1000.00I 1000.00I 100.00% I I I 37206 I I I I I I I I REIMB: ATF I 0.00I -4703.28I 7000.00I 7000.00I 100.00% I I I I I I I I I I I POLICE REVENUE I 1263725.00I -1062155.84I 1372225.00I 108500.00I 8.58% 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 -1457.79I 1500.00I -5000.00I -76.92% I I I 34700-05 I I I I I I I I RECREATION - WW CERAMIC SI 4500.00I -3740.40I 4500.00I 0.00I 0.00% I I I 34701 I I I I I I I I REIMB: JACKSON IDOL I 0.00I -500.00I 500.00I 500.00I 100.00% I I I 34722 I I I I I I I I SWIMMING POOL REVENUE I 1000.00I -835.00I 1000.00I 0.00I 0.00% I I I 34740 I I I I I I I I ATHLETICS REVENUE I 75000.00I -68490.90I 72000.00I -3000.00I -4.00% I I I 34746 I I I I I I I I TENNIS COURT FEES I 34746.00I -25273.35I 25000.00I -9746.00I -28.04% I I I 34909 I I I I I I I I FIELD TRIP FEES I 0.00I -3875.00I 3500.00I 3500.00I 100.00% I I I Date: 6/16/2011 CITY OF JACKSON Page: 9 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 34910 I I I I I I I I COMMUNITY EDUCATION I 8000.00I -25554.00I 15000.00I 7000.00I 87.50% I I I 34911 I I I I I I I I CHRISTMAS PARADE REG FEESI 0.00I -673.60I 650.00I 650.00I 100.00% I I I 34912 I I I I I I I I GOLF COURSE REVENUE I 0.00I -3972.00I 0.00I 0.00I 0.00% I I I I I I I I I I I RECREATION REVENUE I 129746.00I -134372.04I 123650.00I -6096.00I -4.69% 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 -2420.18I 2000.00I 0.00I 0.00% I I I 34720-04 I I I I I I I I WESTWOOD CENTER - COMP. LI 3500.00I -1208.08I 1000.00I -2500.00I -71.42% I I I 34791-08 I I I I I I I I BEMIS COMM CTR REV-SENIORI 3500.00I -549.20I 0.00I -3500.00I -100.00% I I I 34794 I I I I I I I I SO JAX COMMUNITY CTR REVEI 2800.00I -2767.50I 2200.00I -600.00I -21.42% I I I 34794-08 I I I I I I I I SO JAX COMM CTR REV-SENIOI 3120.00I -2343.91I 2700.00I -420.00I -13.46% I I I 34799 I I I I I I I I T.R. WHITE SPORTSPLEX REVI 33258.00I -8922.00I 32830.00I -428.00I -1.28% I I I I I I I I I I I PUBLIC PROPERTIES REVENUEI 48178.00I -18210.87I 40730.00I -7448.00I -15.45% I I I I I I I I I I I 34913 I I I I I I I I OMAN MISC REVENUE I 800.00I -6118.29I 10000.00I 9200.00I 1,150.00% I I I 34914 I I I I I I I I OMAN SECURITY I 1100.00I -1224.00I 1100.00I 0.00I 0.00% I I I 34915 I I I I I I I I OMAN ARENA TICKET SALES I 302200.00I -162120.63I 175000.00I -127200.00I -42.09% I I I 34916 I I I I I I I I OMAN-TICKET HANDLE FEES I 20000.00I -15016.00I 20000.00I 0.00I 0.00% I I I 34917 I I I I I I I I OMAN ARENA BLDG RENTALS I 25187.50I -15928.44I 15000.00I -10187.50I -40.44% I I I 34918 I I I I I I I I OMAN ARENA EQUIP RENTALS I 1668.00I 0.00I 0.00I -1668.00I -100.00% I I I 37552 I I I I I I I I OMAN-VENDOR COMMISSIONS I 4500.00I -2734.88I 2000.00I -2500.00I -55.55% I I I I I I I I I I I OMAN ARENA REVENUE I 355455.50I -203142.24I 223100.00I -132355.50I -37.23% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 10 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 34919 I I I I I I I I CIVIC CENTER SECURITY I 21100.00I -21690.40I 20000.00I -1100.00I -5.21% I I I 34920 I I I I I I I I CIVIC CTR EQUIP RENTALS I 40810.45I -35780.98I 65000.00I 24189.55I 59.27% I I I 34921 I I I I I I I I CIVIC CTR-TICKET HANDL FEI 10000.00I -3445.50I 10000.00I 0.00I 0.00% I I I 34922 I I I I I I I I CIVIC CENTER TICKET SALESI 75772.00I -61856.52I 70000.00I -5772.00I -7.61% I I I 34923 I I I I I I I I CIVIC CTR BLDG RENTALS I 127615.50I -102557.50I 150000.00I 22384.50I 17.54% I I I 34939 I I I I I I I I CIVIC CTR-MISC REVENUE I 1975.00I -915.64I 4000.00I 2025.00I 102.53% I I I 34941 I I I I I I I I REIMB: STAGE HANDS I 13146.80I -4547.90I 15000.00I 1853.20I 14.09% I I I 34944 I I I I I I I I BOX OFFICE FEES-CIVIC CENI 2000.00I 0.00I 2000.00I 0.00I 0.00% I I I 34946 I I I I I I I I RENTAL-CC FEES I 0.00I -9.00I 0.00I 0.00I 0.00% I I I 37551 I I I I I I I I CIVIC CTR-VENDOR COMM I 1316.61I -2244.17I 5000.00I 3683.39I 279.76% I I I I I I I I I I I CIVIC CENTER REVENUE I 293736.36I -233047.61I 341000.00I 47263.64I 16.09% 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 -44222.91I 60000.00I -15000.00I -20.00% I I I 34924 I I I I I I I I FAIRGROUNDS RENTALS I 200000.00I -152441.14I 175000.00I -25000.00I -12.50% I I I I I I I I I I I FAIRGROUNDS REVENUE I 275000.00I -196664.05I 235000.00I -40000.00I -14.54% I I I I I I I I I I I 34723 I I I I I I I I THEATER/SCRIPTS I 25000.00I -33660.25I 25000.00I 0.00I 0.00% I I I 34760 I I I I I I I I NED CENTER CONCESSIONS I 500.00I -433.48I 500.00I 0.00I 0.00% I I I 34926 I I I I I I I I PHOTO SALES - NED I 500.00I -592.24I 500.00I 0.00I 0.00% I I I 34927 I I I I I I I I SEAT & BRICKS-NED I 150.00I -50.00I 150.00I 0.00I 0.00% I I I 34928 I I I I I I I I SOUVENIR COMMISSIONS I 150.00I -190.00I 150.00I 0.00I 0.00% I I I 34930 I I I I I I I I TICKET SALES-NED I 20000.00I -3068.68I 5000.00I -15000.00I -75.00% I I I Date: 6/16/2011 CITY OF JACKSON Page: 11 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 34931 I I I I I I I I TICKET HANDL FEES-NED I 1800.00I -457.50I 500.00I -1300.00I -72.22% I I I 34932 I I I I I I I I NED SECURITY FEES I 700.00I -400.00I 700.00I 0.00I 0.00% I I I 34933 I I I I I I I I OFFICE RENT-NED CENTER I 7900.00I -7531.23I 7900.00I 0.00I 0.00% I I I 34934 I I I I I I I I ADS-NED I 2200.00I -3125.00I 2200.00I 0.00I 0.00% I I I 34935 I I I I I I I I GRANTS-NED I 0.00I -8389.22I 0.00I 0.00I 0.00% I I I 34936 I I I I I I I I SPONSORSHIPS-NED I 0.00I -35.00I 0.00I 0.00I 0.00% I I I 34937 I I I I I I I I ART COMMISSION-NED I 100.00I -39.00I 0.00I -100.00I -100.00% I I I 34938 I I I I I I I I BUILDING RENTALS-NED I 18000.00I -17525.00I 18000.00I 0.00I 0.00% I I I I I I I I I I I NED CENTER REVENUE I 77000.00I -75496.60I 60600.00I -16400.00I -21.29% 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 0.00I 0.00I -4500.00I -100.00% I I I 34736 I I I I I I I I NAIA VENDOR COMMISSIONS I 1000.00I -861.40I 0.00I -1000.00I -100.00% I I I 34745 I I I I I I I I NAIA TOURNEY REVENUE I 80000.00I -66020.73I 0.00I -80000.00I -100.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 -7037.03I 15000.00I 0.00I 0.00% I I I 36715 I I I I I I I I NAIA SPONSORSHIPS I 55000.00I -57919.00I 0.00I -55000.00I -100.00% I I I I I I I I I I I NAIA & PRINGLES REVENUE I 185500.00I -159338.16I 45000.00I -140500.00I -75.74% I I I I I I I I I I I 37111 I I I I I I I I INTEREST EARNED I 350000.00I -281097.53I 350000.00I 0.00I 0.00% I I I 37112 I I I I I I I I RIVERSIDE CEMETERY TRST II 3000.00I -1019.10I 2000.00I -1000.00I -33.33% I I I I I I I I I I I INTEREST EARNED I 353000.00I -282116.63I 352000.00I -1000.00I -0.28% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 12 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 37211 I I I I I I I I RENT INCOME I 28000.00I -22384.10I 28000.00I 0.00I 0.00% I I I 37212 I I I I I I I I RENT-EMERGENCY MGMT I 11000.00I -8023.75I 0.00I -11000.00I -100.00% I I I 37215 I I I I I I I I RENT-CASEY JONES I 4000.00I -5598.22I 8000.00I 4000.00I 100.00% I I I 37553 I I I I I I I I JTA TICKET SALES COMMISSII 0.00I -59.80I 0.00I 0.00I 0.00% I I I 37929 I I I I I I I I FARMERS CONCESS-RENT/COMMI 0.00I -3562.39I 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 -32131.11I 26000.00I 0.00I 0.00% I I I 37931 I I I I I I I I RENT-DEPOT I 1000.00I -900.00I 1000.00I 0.00I 0.00% I I I I I I I I I I I RENTS & ROYALTIES I 70000.00I -72659.37I 63000.00I -7000.00I -10.00% 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 -36599.34I 0.00I -16000.00I -100.00% I I I 36352 I I I I I I I I SALE OF FLOOD ITEMS I 0.00I 210.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 -12889.23I 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 -49278.57I 10000.00I -16000.00I -61.53% 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 50000.00I 166283.64I 0.00I -50000.00I -100.00% I I I I I I I I I I I INC/(DEC) IN FMV OF INVESI 50000.00I 166283.64I 0.00I -50000.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 -1177.00I 1500.00I -3500.00I -70.00% I I I 37511 I I I I I I I I SALE OF GEN GOVT SUPPLIESI 0.00I -850.00I 200.00I 200.00I 100.00% I I I 37512 I I I I I I I I SALE OF MAPS & COPIES I 150.00I -226.75I 220.00I 70.00I 46.66% I I I 37514 I I I I I I I I SALE OF SCRAP METAL I 2000.00I -3303.25I 5000.00I 3000.00I 150.00% I I I 37515 I I I I I I I I SALE OF WASTE OIL & TIRESI 0.00I -2432.99I 3000.00I 3000.00I 100.00% I I I Date: 6/16/2011 CITY OF JACKSON Page: 13 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 SALE OF MATERIALS & SUPPLI 7150.00I -7989.99I 9920.00I 2770.00I 38.74% 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 -691.23I 1000.00I 1000.00I 100.00% I I I 36702 I I I I I I I I DONATIONS-2ND CHANCE I 0.00I -100.00I 0.00I 0.00I 0.00% I I I 36707 I I I I I I I I SPONSORS-T-SHIRTS UNIFORMI 0.00I -2850.00I 0.00I 0.00I 0.00% I I I 36713 I I I I I I I I JCB-RESTRICTED DONATIONS I 1500.00I 0.00I 0.00I -1500.00I -100.00% I I I 36714 I I I I I I I I DONATIONS-MIDNITE BASKETBI 1200.00I -1550.00I 900.00I -300.00I -25.00% I I I 36718 I I I I I I I I DONATIONS-TRAFFIC SAFETY I 0.00I -70.00I 0.00I 0.00I 0.00% I I I 36719 I I I I I I I I DONATIONS-FIRE PROGRAMS I 500.00I 0.00I 0.00I -500.00I -100.00% I I I 36721 I I I I I I I I DONATIONS - LIBERTY GARDEI 500.00I -1973.21I 0.00I -500.00I -100.00% I I I 36723 I I I I I I I I DONATIONS-FIRE EXPLORERS I 1000.00I -300.00I 0.00I -1000.00I -100.00% I I I 36731 I I I I I I I I DONATIONS-DEPOT I 634.00I -518.25I 635.00I 1.00I 0.15% I I I I I I I I I I I CONTRI/DONATIONS-PRIV SOUI 5334.00I -8052.69I 2535.00I -2799.00I -52.47% I I I I I I I I I I I 36692 I I I I I I I I REIMB: NEIGHBORHOOD SERVII 15000.00I -9338.85I 15000.00I 0.00I 0.00% I I I 36693 I I I I I I I I REIMB: EMA HOMELAND GRANTI 9000.00I -9000.00I 43912.00I 34912.00I 387.91% I I I 37205 I I I I I I I I REIMB: RECYCLING - STATE I 0.00I -8778.00I 10000.00I 10000.00I 100.00% I I I 37207 I I I I I I I I REIMB: SCHOOL RESOURCE I 0.00I 0.00I 119000.00I 119000.00I 100.00% I I I 37208 I I I I I I I I REIMB:DELINQ TAX CHANCERYI 10000.00I -10860.60I 10000.00I 0.00I 0.00% I I I I I I I I I I I REIMBURSEMENTS I 34000.00I -37977.45I 197912.00I 163912.00I 482.09% I I I I I I I I I I I 37823 I I I I I I I I TRANSFER FROM KCRP FUND I 30000.00I 0.00I 50000.00I 20000.00I 66.66% I I I Date: 6/16/2011 CITY OF JACKSON Page: 14 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 37840 I I I I I I I I TRANSFER FRM OTHER FUNDS I 2021832.00I -1500000.00I 2000000.00I -21832.00I -1.07% I I I I I I I I I I I INTER-FUND TRANSFERS IN I 2051832.00I -1500000.00I 2050000.00I -1832.00I -0.08% 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 15000.00I -12040.89I 15000.00I 0.00I 0.00% I I I 37997 I I I I I I I I ENERNOC FEES I 5000.00I -3283.11I 5000.00I 0.00I 0.00% I I I 37900 I I I I I I I I FROM FUND BALANCE I 2250934.41I 0.00I 846281.46I -1404652.95I -62.40% I I I 37990 I I I I I I I I MISCELLANEOUS REVENUE I 25000.00I -16988.98I 25000.00I 0.00I 0.00% I I I 37991 I I I I I I I I COPY REVENUE I 60.00I -55.00I 60.00I 0.00I 0.00% I I I 37992 I I I I I I I I RECYCLING REVENUE I 1000.00I 0.00I 1000.00I 0.00I 0.00% I I I I I I I I I I I MISCELLANEOUS REVENUE I 2296994.41I -32367.98I 892341.46I -1404652.95I -61.15% 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 -401.51I 0.00I 0.00I 0.00% I I I I I I I I I I I CASH SHORT AND OVER I 0.00I -401.51I 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 66751287.33I -49300331.91I 63834795.64I -2916491.69I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 15 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 110 Fund Name: GENERAL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 66751287.33 -49300331.91 63834795.64 -2916491.69 -4.36% Date: 6/16/2011 CITY OF JACKSON Page: 16 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 124 Fund Name: SPORTSPLEX FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 310000.00I -376481.93I 400000.00I 90000.00I 29.03% I I I 31925 I I I I I I I I STATE SHARED SALES TAX I 281350.09I -192060.09I 509383.42I 228033.33I 81.04% I I I I I I I I I I I TAXES I 591350.09I -568542.02I 909383.42I 318033.33I 53.78% I I I I I I I I I I I 36704 I I I I I I I I SPONSORSHIPS I 305426.54I -293134.00I 300000.00I -5426.54I -1.77% 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 505426.54I -493134.00I 500000.00I -5426.54I -1.07% I I I I I I I I I I I 33100 I I I I I I I I TOURNAMENT FEES I 259000.00I -153997.00I 240000.00I -19000.00I -7.33% I I I 33101 I I I I I I I I GATE ADMISSIONS I 287000.00I -181635.45I 266000.00I -21000.00I -7.31% I I I 33102 I I I I I I I I CONCESSIONS REVENUE I 291000.00I -193654.78I 265000.00I -26000.00I -8.93% I I I 33103 I I I I I I I I GIFT SHOP SALES I 99900.00I -96973.44I 150000.00I 50100.00I 50.15% I I I 33104 I I I I I I I I TOURNAMENT SPONSORS I 8000.00I 0.00I 0.00I -8000.00I -100.00% I I I 33105 I I I I I I I I AMUSEMENT/RIDE COMMISSIONI 0.00I -781.50I 0.00I 0.00I 0.00% I I I 33106 I I I I I I I I ONLINE SHIPPING I 200.00I 0.00I 0.00I -200.00I -100.00% I I I I I I I I I I I SPORTSPLEX REVENUES I 945100.00I -627042.17I 921000.00I -24100.00I -2.54% I I I I I I I I I I I 37900 I I I I I I I I FROM FUND BALANCE I 68780.77I 0.00I 0.00I -68780.77I -100.00% I I I I I I I I I I I INTERFUND TRANSFERS IN I 68780.77I 0.00I 0.00I -68780.77I -100.00% I I 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 0.00I -5000.00I -100.00% I I I I I I I I I I I INTEREST EARNED I 5000.00I 0.00I 0.00I -5000.00I -100.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 17 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 124 Fund Name: SPORTSPLEX FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 39100 I I I I I I I I CASH SHORT AND OVER I 0.00I -898.10I 0.00I 0.00I 0.00% I I I I I I I I I I I CASH SHORT AND OVER I 0.00I -898.10I 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 2115657.40I -1689616.29I 2330383.42I 214726.02I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 18 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 124 Fund Name: SPORTSPLEX FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 2115657.40 -1689616.29 2330383.42 214726.02 10.14% Date: 6/16/2011 CITY OF JACKSON Page: 19 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 125 Fund Name: COMMUNITY DEVELOPMENT FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 -6229.70I 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 6229.70I 0.00I 0.00I 0.00% I I I 36111 I I I I I I I I INTEREST-SBL REPMTS I 0.00I -182.91I 0.00I 0.00I 0.00% I I I 37911 I I I I I I I I LATE CHGS-SBL REPMTS I 0.00I -469.67I 0.00I 0.00I 0.00% I I I I I I I I I I I OTHER FUND SOURCES-SBL REI 0.00I -652.58I 0.00I 0.00I 0.00% I I I I I I I I I I I 34841 I I I I I I I I PRINCIPAL-EMGY REP REPMI 0.00I -2926.74I 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 2926.74I 0.00I 0.00I 0.00% I I I 34850 I I I I I I I I PRINCIPAL-HOME TA REHABI 0.00I -34643.94I 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 34643.94I 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 -2320.83I 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 -2320.83I 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 444626.00I 0.00I 339700.00I -104926.00I -23.59% I I I 37300 I I I I I I I I PROGRAM INCOME-CDBG I 693416.00I 0.00I 507000.00I -186416.00I -26.88% I I I 37405 I I I I I I I I ESG ALLOCATION I 96771.00I 0.00I 0.00I -96771.00I -100.00% I I I 37406 I I I I I I I I D/S RESERVE INTEREST I 0.00I 6411.70I 0.00I 0.00I 0.00% I I I 37407 I I I I I I I I COMM DEV - LOAN PROCEEDS I 0.00I -59088.90I 0.00I 0.00I 0.00% I I I 37408 I I I I I I I I D/S PROCEEDS FROM LOAN I 0.00I -3149837.00I 0.00I 0.00I 0.00% I I I I I I I I I I I COMMUNITY DEV REVENUE I 1234813.00I -3202514.20I 846700.00I -388113.00I -31.43% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 1234813.00I -3205487.61I 846700.00I -388113.00I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 20 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 125 Fund Name: COMMUNITY DEVELOPMENT FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 1234813.00 -3205487.61 846700.00 -388113.00 -31.43% Date: 6/16/2011 CITY OF JACKSON Page: 21 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 131 Fund Name: SOLID WASTE COLLECTION FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 169663.83I -106432.85I 160000.00I -9663.83I -5.69% I I I I I I I I I I I FEDERAL & STATE GRANTS I 178441.83I -106432.85I 168778.00I -9663.83I -5.41% I I I I I I I I I I I 37710 I I I I I I I I GARBAGE COLLECTION REVENUI 9990000.00I -8207458.84I 10300000.00I 310000.00I 3.10% I I I 37711 I I I I I I I I GARBAGE RESET FEE I 500.00I -450.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 -28400.17I 40000.00I 0.00I 0.00% I I I I I I I I I I I CHARGES FOR SERVICES I 10030500.00I -8236309.01I 10340500.00I 310000.00I 3.09% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNINGS I 10000.00I -1458.34I 5000.00I -5000.00I -50.00% I I I 37900 I I I I I I I I FROM FUND BALANCE I 861625.33I 0.00I 608481.21I -253144.12I -29.37% I I I 37990 I I I I I I I I MISCELLANEOUS REVENUE I 0.00I 170.90I 250.00I 250.00I 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 871675.33I -1287.44I 613781.21I -257894.12I -29.58% I I I I I I I I I I I I I I I I I I I TOTAL H & S REVENUES I 11080617.16I -8344029.30I 11123059.21I 42442.05I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 22 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 131 Fund Name: SOLID WASTE COLLECTION FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 11080617.16 -8344029.30 11123059.21 42442.05 0.38% Date: 6/16/2011 CITY OF JACKSON Page: 23 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 141 Fund Name: POLICE DRUG FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 85000.00I -63245.41I 85000.00I 0.00I 0.00% I I I 35250 I I I I I I I I SALE:SEIZED ASSETS/UNCLAII 9000.00I -1983.50I 9000.00I 0.00I 0.00% I I I I I I I I I I I FINES & FORFEITURES I 94000.00I -65228.91I 94000.00I 0.00I 0.00% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNINGS I 500.00I -163.83I 500.00I 0.00I 0.00% I I I I I I I I I I I OTHER REVENUE I 500.00I -163.83I 500.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 POLICE DRUG FUND REI 94500.00I -65392.74I 94500.00I 0.00I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 24 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 141 Fund Name: POLICE DRUG FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 94500.00 -65392.74 94500.00 0.00 0.00% Date: 6/16/2011 CITY OF JACKSON Page: 25 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 142 Fund Name: METRO DRUG FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 -31304.70I 97315.00I 17315.00I 21.64% I I I 35160 I I I I I I I I FINES-DTF I 2500.00I 0.00I 0.00I -2500.00I -100.00% I I I 35200 I I I I I I I I SEIZURES I 80000.00I -228953.35I 100000.00I 20000.00I 25.00% I I I 35250 I I I I I I I I CONTROLLED SUBSTANCE TAX I 0.00I -8272.03I 5000.00I 5000.00I 100.00% I I I 36350 I I I I I I I I FEDERAL EQ SHARING I 165524.70I -124295.03I 0.00I -165524.70I -100.00% I I I 36991 I I I I I I I I MISC REIMBURSEMENTS I 0.00I -877.85I 0.00I 0.00I 0.00% I I I I I I I I I I I OPERATING REVENUES I 328024.70I -393702.96I 202315.00I -125709.70I -38.32% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNED I 200.00I -682.47I 500.00I 300.00I 150.00% I I I I I I I I I I I NON-OPERATING REVENUES I 200.00I -682.47I 500.00I 300.00I 150.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 328224.70I -394385.43I 202815.00I -125409.70I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 26 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 142 Fund Name: METRO DRUG FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 328224.70 -394385.43 202815.00 -125409.70 -38.20% Date: 6/16/2011 CITY OF JACKSON Page: 27 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 211 Fund Name: DEBT SERVICE FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 409.00I -303.04I 287.00I -122.00I -29.82% I I I 31101 I I I I I I I I DELINQ TAX-2001 I 420.00I -376.35I 496.00I 76.00I 18.09% I I I 31102 I I I I I I I I DELINQ TAX-2002 I 1008.00I -483.68I 748.00I -260.00I -25.79% I I I 31103 I I I I I I I I DELINQ TAX-2003 I 934.00I -398.25I 1027.00I 93.00I 9.95% I I I 31104 I I I I I I I I DELINQ TAX-2004 I 895.00I -1288.64I 647.00I -248.00I -27.70% I I I 31105 I I I I I I I I DELINQ TAX-2005 I 4575.00I -1770.40I 3288.00I -1287.00I -28.13% I I I 31106 I I I I I I I I DELINQ TAX-2006 I 2894.00I -2336.10I 2452.00I -442.00I -15.27% I I I 31107 I I I I I I I I DELINQ TAX-2007 I 5553.00I -8036.22I 2594.00I -2959.00I -53.28% I I I 31108 I I I I I I I I DELINQ TAX-2008 I 34860.00I -31242.17I 6975.00I -27885.00I -79.99% I I I 31109 I I I I I I I I DELINQ TAX-2009 I 121628.00I -111108.73I 44301.00I -77327.00I -63.57% I I I 31110 I I I I I I I I DELINQ TAX-2010 I 0.00I 0.00I 187279.00I 187279.00I 100.00% I I I 31199 I I I I I I I I DELINQ TAX-1999 I 279.00I -513.17I 0.00I -279.00I -100.00% I I I I I I I I I I I TOTAL DELINQUENT TAX COLLI 173455.00I -157856.75I 250094.00I 76639.00I 44.18% I I I I I I I I I I I 31400 I I I I I I I I CURRENT PROPERTY TAX COLLI 4464415.00I -4321584.10I 5194725.00I 730310.00I 16.35% I I I I I I I I I I I CURRENT PROPERTY TAX COLLI 4464415.00I -4321584.10I 5194725.00I 730310.00I 16.35% 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 58103.00I -62850.24I 80000.00I 21897.00I 37.68% I I I 31511 I I I I I I I I TAX EQUIV-ELECTRIC I 400756.00I -348763.05I 486741.00I 85985.00I 21.45% I I I 31512 I I I I I I I I TAX EQUIV. - WATER I 45172.00I 0.00I 56206.00I 11034.00I 24.42% I I I 31513 I I I I I I I I TAX EQUIV-WESLEY I 757.00I 0.00I 870.00I 113.00I 14.92% I I I 31514 I I I I I I I I TAX EQUIV-GAS I 201538.00I -167292.43I 230901.00I 29363.00I 14.56% I I I Date: 6/16/2011 CITY OF JACKSON Page: 28 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 211 Fund Name: DEBT SERVICE FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 2691.00I 0.00I 2570.00I -121.00I -4.49% I I I 31516 I I I I I I I I TAX EQUIV-ST MARY MANOR I 908.00I 0.00I 1044.00I 136.00I 14.97% I I I I I I I I I I I TAX EQUIVALENTS I 709925.00I -578905.72I 858332.00I 148407.00I 20.90% 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 -17671.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 -23596.29I 60000.00I 0.00I 0.00% I I I 36530 I I I I I I I I INTEREST EARNED I 25000.00I -5320.91I 10000.00I -15000.00I -60.00% I I I 36933 I I I I I I I I PROC FROM BONDS (2011) I 0.00I 0.00I 10200000.00I 10200000.00I 100.00% I I I 37900 I I I I I I I I FROM FUND BALANCE I 1070000.00I 0.00I 500000.00I -570000.00I -53.27% I I I I I I I I I I I OTHER REVENUE I 1185000.00I -46588.77I 10800000.00I 9615000.00I 811.39% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 6532795.00I -5104935.34I 17103151.00I 10570356.00I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 29 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 211 Fund Name: DEBT SERVICE FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 6532795.00 -5104935.34 17103151.00 10570356.00 161.80% Date: 6/16/2011 CITY OF JACKSON Page: 30 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 310 Fund Name: INDUSTRIAL DEVELOPMENT FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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: 6/16/2011 CITY OF JACKSON Page: 31 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 312 Fund Name: KATE CAMPBELL ROBERTSON PARK F I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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: 6/16/2011 CITY OF JACKSON Page: 32 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 315 Fund Name: CAPITAL OUTLAY FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 528729.94I -37780.18I 0.00I -528729.94I -100.00% I I I 33493 I I I I I I I I ARRA TDOT FUNDING I 1442390.19I -1670340.88I 425000.00I -1017390.19I -70.53% I I I I I I I I I I I STATE GRANTS I 1971120.13I -1708121.06I 425000.00I -1546120.13I -78.43% I I I I I I I I I I I 36100 I I I I I I I I INTEREST EARNED I 527.52I -887.55I 0.00I -527.52I -100.00% I I I I I I I I I I I INTEREST EARNED I 527.52I -887.55I 0.00I -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 -45557.23I 0.00I 0.00I 0.00% I I I 37301 I I I I I I I I SALE OF LAND I 0.00I -8923.51I 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 -54480.74I 0.00I 0.00I 0.00% I I I I I I I I I I I 36725 I I I I I I I I REIMB: EMA-K-9 UNIT I 25000.00I 0.00I 0.00I -25000.00I -100.00% I I I 36726 I I I I I I I I REIMB: CID:HOMELAND SECURI 25000.00I 0.00I 0.00I -25000.00I -100.00% I I I I I I I I I I I REIMBURSEMENTS I 50000.00I 0.00I 0.00I -50000.00I -100.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 1579328.00I -550000.00I 1511492.00I -67836.00I -4.29% I I I 36962 I I I I I I I I TRNSF FRM DEBT SERVICE I 0.00I 0.00I 10200000.00I 10200000.00I 100.00% I I I 37900 I I I I I I I I FROM FUND BALANCE I 2746475.00I 0.00I 0.00I -2746475.00I -100.00% I I I I I I I I I I I INTER-FUND TRANSFERS IN I 4325803.00I -550000.00I 11711492.00I 7385689.00I 170.73% I I I I I I I I I I I I I I I I I I I TOTAL REVENUE I 6347450.65I -2313489.35I 12136492.00I 5789041.35I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 33 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 315 Fund Name: CAPITAL OUTLAY FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 6347450.65 -2313489.35 12136492.00 5789041.35 91.20% Date: 6/16/2011 CITY OF JACKSON Page: 34 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 440 Fund Name: LANDFILL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 65500.00I 0.00I 65000.00I -500.00I -0.76% I I I I I I I I I I I OPERATING REVENUE I 65500.00I 0.00I 65000.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 -588.34I 0.00I 0.00I 0.00% I I I I I I I I I I I MISCELLANEOUS REVENUE I 0.00I -588.34I 0.00I 0.00I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 35 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 440 Fund Name: LANDFILL FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 65500.00 -588.34 65000.00 -500.00 -0.76% Date: 6/16/2011 CITY OF JACKSON Page: 36 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 441 Fund Name: COMMUNITY REDEVELOPMENT FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 38103 I I I I I I I I TRANSFER FROM OTHER FUNDSI 126549.06I 0.00I 0.00I -126549.06I -100.00% I I I 38104 I I I I I I I I INTEREST REVENUE I 0.00I -48.44I 0.00I 0.00I 0.00% I I I I I I I I I I I COMMUN REDEVE REVENUE I 126549.06I -48.44I 0.00I -126549.06I -100.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 37 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 441 Fund Name: COMMUNITY REDEVELOPMENT FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 126549.06 -48.44 0.00 -126549.06 -100.00% Date: 6/16/2011 CITY OF JACKSON Page: 38 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 611 Fund Name: ROBERTSON TRUST FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 -34695.27I 50000.00I 20000.00I 66.66% I I I I I I I I I I I RTF REVENUE I 30000.00I -34695.27I 50000.00I 20000.00I 66.66% 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 20502.31I 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 20502.31I 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 -14192.96I 50000.00I 20000.00I 0.00% I I I I I I I I I I I Date: 6/16/2011 CITY OF JACKSON Page: 39 Time: 16:04 Revenue Budget Worksheets Id: GL5610 User: BELLK Date:__________ Submitted by:________________________________ Department:______________________________ Fund Number: 611 Fund Name: ROBERTSON TRUST FUND I CURRENT I 2011 YTD I PROPOSED IDOLLAR DIFF IPERCENT DIFF I NOTES I NOTES I Account/Description I 2011 BUDGET I TOTALS I2012 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 -14192.96 50000.00 20000.00 66.66% Grand Total 94707394.30 -70432497.71 107786896.27 13079501.97 13.81%