Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2015-08 Meeting - Revenue Model Report
Revenue Model Report For Period Ending July 31, 2015 Data as of August 4, 2015 for period ending July 31, 2015 CFY 2015 YTD Actual Projected Over/Description Budget As of 7/31/2015 (Under) Budget Sales Tax and Use Tax 9,772,509.00$ 7,014,084.53$ **823,284.35$ Intergovernmental Taxes 2,130,000.00$ 1,508,525.63$ 78,147.35$ Other Taxes 120,000.00$ 78,935.56$ 962.32$ Franchise & Utility Tax 7,225,000.00$ 4,641,470.77$ (55,426.02)$ Property Taxes 5,249,399.00$ 5,182,293.21$ (21,770.76)$ Intergovernmental 1,057,136.48$ 5,000.00$ 5,000.00$ Charges for Services 2,448,744.80$ 2,288,648.26$ 94,528.72$ Fees, Licenses, & Permits 658,300.00$ 592,867.62$ 44,906.36$ Fines & Forfeitures 992,380.00$ 743,486.81$ 14,184.21$ Contributions/Donations 122,685.53$ 131,999.53$ 38,226.85$ Other Operating Revenues 82,597.00$ 174,096.67$ 109,619.09$ Interest Income 90,000.00$ 83,343.55$ 11,564.52$ Other Non Operating Revenue 25,000.00$ 17,306.00$ -$ Operating Transfers In 34,100.00$ 27,320.45$ (1,030.26)$ Totals 30,007,851.81$ 22,489,378.59$ 1,142,196.71$ **Includes July actual sales tax receipts amount CFY2015 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 7/31/2015 8-15 thru 10-15 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax 2 9,772,509.00 7,014,084.53 3,581,708.82 10,595,793.35 823,284.35 823,284.35 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 0.00 9,772,509.00 7,014,084.53 3,581,708.82 10,595,793.35 823,284.35 823,284.35Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax 2 480,000.00 316,419.82 216,467.19 532,887.01 52,887.01 52,887.01 10-100-403010 Gasoline Tax 2 1,100,000.00 642,487.41 483,154.53 1,125,641.94 25,641.94 25,641.94 10-100-430080 Road & Bridge Tax 0 550,000.00 549,618.40 0.00 549,618.40 (381.60)(381.60) 2,130,000.00 1,508,525.63 699,621.72 2,208,147.35 78,147.35 78,147.35Other Taxes 10-100-403020 Cig Tax 1 120,000.00 78,935.56 42,026.76 120,962.32 962.32 962.32 120,000.00 78,935.56 42,026.76 120,962.32 962.32 962.32Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax 1 3,580,000.00 2,198,669.53 1,462,639.47 3,661,309.00 81,309.00 81,309.00 10-100-410030 Gas Utility License Tax 1 990,000.00 824,785.25 145,893.39 970,678.64 (19,321.36)(19,321.36) 10-100-410052 Telephone Cell w/o audit money 1 2,250,000.00 1,399,679.15 731,575.93 2,131,255.08 (118,744.92)(118,744.92) 10-100-410053 Telecom Audit 0.00 (17,210.20)0.00 (17,210.20)(17,210.20)(17,210.20) 10-100-410060 Cable Franchise Fee R/1 405,000.00 235,547.04 187,994.42 423,541.46 18,541.46 18,541.46 10-100-410061 Cable Utility Audit -$ -$ -$ -$ -$ -$ 7,225,000.00 4,641,470.77 2,528,103.21 7,169,573.98 (55,426.02)(55,426.02)Property Taxes 10-100-420010 Current Property Tax 0 4,600,000.00 4,542,021.81 15,267.68 4,557,289.49 (42,710.51)(42,710.51) 10-100-420020 Del Property Tax 0 55,000.00 40,386.07 13,498.70 53,884.77 (1,115.24)(1,115.24) 10-100-420040 Fin Institution Tax 0 20,000.00 43,692.38 0.00 43,692.38 23,692.38 23,692.38 10-100-420050 Prop Tax Int & Penalties 0 30,000.00 18,334.18 8,697.77 27,031.95 (2,968.05)(2,968.05) 10-100-420055 Surtax Receipts - County Reimb 0 54,399.00 54,399.28 0.00 54,399.28 0.28 0.28 10-100-420060 Surtax Receipts 0 470,000.00 462,192.17 1,518.33 463,710.50 (6,289.50)(6,289.50) 10-100-420080 Special Tax Rev 2 20,000.00 21,267.32 6,352.56 27,619.88 7,619.88 7,619.88 5,249,399.00 5,182,293.21 45,335.03 5,227,628.24 (21,770.76)(21,770.76)Intergovernmental 10-100-430010 Federal Grant 0 1,057,136.48 0.00 1,057,136.48 1,057,136.48 0.00 0.00 10-100-430100 State DNR Historic Pres 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480025 HUD Program Income 0 0.00 5,000.00 0.00 5,000.00 5,000.00 5,000.00 1,057,136.48 5,000.00 1,057,136.48 1,062,136.48 5,000.00 5,000.00Charges for Services 10-100-440010 Admin Charge Backs 0 1,527,958.00 1,527,957.00 0.00 1,527,957.00 (1.00)(1.00) 10-100-440050 Emt Reimbursement 0 25,000.00 25,000.00 0.00 25,000.00 0.00 0.00 10-100-440210 Street Cuts 0 25,000.00 20,498.00 4,864.00 25,362.00 362.00 362.00 10-100-440910 Fuel Charge - backs 0 18,000.00 7,924.50 4,500.00 12,424.50 (5,575.50)(5,575.50) 10-100-440920 Parts Charge backs 0 95,000.00 118,565.16 31,666.67 150,231.83 55,231.83 55,231.83 10-100-440930 Labor Charge backs 0 125,000.00 113,867.01 44,971.24 158,838.25 33,838.25 33,838.25 CFY2015 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 7/31/2015 8-15 thru 10-15 TOTAL (Under) Budget of Formulas 10-100-450189 Animal Shelter Bricks 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481020 Cole Cty Animal Rescue 0 100,000.00 77,025.65 25,000.00 102,025.65 2,025.65 2,025.65 10-100-481030 Rent City Hall/annex 0 6,500.00 6,500.00 0.00 6,500.00 0.00 0.00 10-100-481039 Rent-Hyde Park Facility 0.00 100.00 0.00 100.00 100.00 100.00 10-100-481040 Rent Other 0 12,000.00 0.00 12,000.00 12,000.00 0.00 0.00 10-100-481045 Rent-tower Sites 1 115,000.00 79,437.70 40,101.65 119,539.35 4,539.35 4,539.35 10-100-481065 Parking Spot Maintenance 25,000.00 25,000.00 0.00 25,000.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 0 348,556.80 263,727.08 87,371.70 351,098.78 2,541.98 2,541.98 10-100-481080 Sale Of Maps/gis Data 0 0.00 55.00 0.00 55.00 55.00 55.00 10-100-481085 Cole Cty Gis Joint Coop 0 15,000.00 11,250.00 3,750.00 15,000.00 0.00 0.00 10-100-481090 Cole Cty Sheriff-New World 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 0 3,000.00 4,008.00 400.00 4,408.00 1,408.00 1,408.00 10-100-481105 TIF Administration Fee 7,730.00 7,730.00 0.00 7,730.00 0.00 0.00 10-100-481110 Long & Short 0 0.00 3.16 0.00 3.16 3.16 3.16 2,448,744.80 2,288,648.26 254,625.26 2,543,273.52 94,528.72 94,528.72Fees, Licenses, & Permits 10-100-450010 Liquor Licenses 0 65,000.00 64,525.40 3,294.25 67,819.65 2,819.65 2,819.65 10-100-450020 Business Licenses 0 215,000.00 182,108.58 33,863.11 215,971.69 971.69 971.69 10-100-450021 Home Occupation Permit 0 1,500.00 1,358.00 416.00 1,774.00 274.00 274.00 10-100-450030 Solicitors Lic 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg. Reg 0 0.00 396.00 0.00 396.00 396.00 396.00 10-100-450041 Abandoned Bldg. Admin Fee 0 5,500.00 11,618.17 0.00 11,618.17 6,118.17 6,118.17 10-100-450045 Bldg. Constr Fees 0 125,000.00 115,636.37 31,250.00 146,886.37 21,886.37 21,886.37 10-100-450050 Electrical Certificates 0 16,000.00 18,252.00 1,804.00 20,056.00 4,056.00 4,056.00 10-100-450060 Electrical Permits 0 2,500.00 2,322.48 1,416.00 3,738.48 1,238.48 1,238.48 10-100-450070 Plumbing Licenses 0 10,000.00 9,806.00 377.00 10,183.00 183.00 183.00 10-100-450080 Plumbing Permits 0 5,000.00 2,800.00 1,296.25 4,096.25 (903.75)(903.75) 10-100-450090 Other Lic & Permits 0 2,000.00 1,065.00 1,055.50 2,120.50 120.50 120.50 10-100-450091 Day Care Inspection Fees 0 8,000.00 5,590.00 2,662.50 8,252.50 252.50 252.50 10-100-450092 Food Inspection Fees 0 88,000.00 85,119.32 1,043.08 86,162.40 (1,837.61)(1,837.61) 10-100-450100 Curb Cut Permits 0 1,500.00 728.00 364.00 1,092.00 (408.00)(408.00) 10-100-450110 Board Of Adj Fees 0 1,200.00 618.00 0.00 618.00 (582.00)(582.00) 10-100-450120 Sign Permits 0 5,000.00 3,640.00 778.00 4,418.00 (582.00)(582.00) 10-100-450130 Demolition Permits 0 500.00 832.00 364.00 1,196.00 696.00 696.00 10-100-450150 Acc Rep Fees-police 0 12,000.00 8,766.30 2,936.05 11,702.35 (297.65)(297.65) 10-100-450160 Accrpt/blastg P-fire 0 750.00 273.00 325.00 598.00 (152.00)(152.00) 10-100-450170 Animal Redemption Fees 0 52,000.00 39,770.00 14,355.00 54,125.00 2,125.00 2,125.00 10-100-450180 Animal Vaccinations Fees 0 5,000.00 3,525.00 1,400.00 4,925.00 (75.00)(75.00) 10-100-450185 Animal Cremation Fees 0 24,000.00 21,128.00 6,729.00 27,857.00 3,857.00 3,857.00 10-100-450186 Animal Boarding Fees 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 0 450.00 552.00 25.00 577.00 127.00 127.00 10-100-450230 Vacating Right Of Way 0 400.00 390.00 130.00 520.00 120.00 120.00 CFY2015 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 7/31/2015 8-15 thru 10-15 TOTAL (Under) Budget of Formulas 10-100-450250 Rezoning Request 0 10,000.00 10,013.00 4,092.50 14,105.50 4,105.50 4,105.50 10-100-450255 Planning & Zoning Review Fees 0.00 412.00 0.00 412.00 412.00 412.00 10-100-450260 Non-refundable Plans/spec 0 2,000.00 1,623.00 362.50 1,985.50 (14.50)(14.50) 658,300.00 592,867.62 110,338.74 703,206.36 44,906.36 44,906.36Fines & Forfeitures 10-100-460010 Court Cost 0 80,000.00 55,069.83 20,887.26 75,957.09 (4,042.91)(4,042.91) 10-100-460015 Court Restitutions 0 1,300.00 1,734.59 0.00 1,734.59 434.59 434.59 10-100-460018 Inmate Security Fund 0 12,080.00 8,994.67 3,444.86 12,439.53 359.53 359.53 10-100-460020 Jail Cost Recovery 0 10,000.00 3,523.47 1,276.02 4,799.49 (5,200.51)(5,200.51) 10-100-460025 Alcohol Offense Cost Rec 0 8,000.00 7,774.00 2,434.63 10,208.63 2,208.63 2,208.63 10-100-460030 Pol Fines-traffic 0 835,000.00 626,760.37 226,063.92 852,824.29 17,824.29 17,824.29 10-100-460040 Pol Tickets-parking 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460050 Pol fines - Other 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460060 Dog Fines 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460070 P & Code Violations 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460090 Parking Fines 0 53,000.00 42,792.61 10,720.72 53,513.33 513.32 513.32 10-100-460100 Bankcard Charges 0 (7,000.00)(3,162.73)(1,750.00)(4,912.73)2,087.27 2,087.27 992,380.00 743,486.81 263,077.40 1,006,564.21 14,184.21 14,184.21Contributions/Donations 10-100-430055 DARE Contri 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480010 Citizen Participation 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480030 Donations-Recycling 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480050 Sober Driver Program 0 2,930.00 2,930.00 0.00 2,930.00 0.00 0.00 10-100-480055 JC Fire Museum 0 0.00 2,251.00 0.00 2,251.00 2,251.00 2,251.00 10-100-480063 Private Donations-Cultural Art 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 0 7,255.53 7,255.53 0.00 7,255.53 0.00 0.00 10-100-480080 Dare Donations 0 0.00 500.00 0.00 500.00 500.00 500.00 10-100-480090 Police K-9 Donations 0 500.00 500.00 0.00 500.00 0.00 0.00 10-100-480165 Animal S Donations 0 0.00 7,070.21 0.00 7,070.21 7,070.21 7,070.21 10-100-481050 Transfer Stn/Plng-Sld Wst Cntr 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481055 Street Repair-Solid Waste Cntr 0 112,000.00 111,492.79 28,912.85 140,405.64 28,405.64 28,405.64 10-100-481095 Cemetery Donations 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-486070 Cap Contr-neighorhood Imp Pro 0 0.00 0.00 0.00 0.00 0.00 0.00 122,685.53 131,999.53 28,912.85 160,912.38 38,226.85 38,226.85 Other Operating Revenues 10-100-450187 Special Sn Program 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450188 Adoption Voucher Program 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480011 Police Evidence Funds 0.00 17,042.09 0.00 17,042.09 17,042.09 17,042.09 10-100-481070 Miscellaneous 0 30,000.00 127,643.38 7,500.00 135,143.38 105,143.38 105,143.38 CFY2015 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 7/31/2015 8-15 thru 10-15 TOTAL (Under) Budget of Formulas 10-100-481072 TIF Prof Svcs Deposit 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481074 Revenue Share - Purchasing Card 0.00 3,589.32 0.00 3,589.32 3,589.32 3,589.32 10-100-481077 Insurance Claims 0 42,597.00 25,821.88 619.42 26,441.30 (16,155.70)(16,155.70) 10-100-481078 Cafeteria Refunds 0 10,000.00 0.00 10,000.00 10,000.00 0.00 0.00 82,597.00 174,096.67 18,119.42 192,216.09 109,619.09 109,619.09Interest Income 10-100-470010 Interest 0 90,000.00 83,343.55 18,220.97 101,564.52 11,564.52 11,564.52 10-100-470051 Unrealized Gains and Losses 0 0.00 0.00 0.00 0.00 0.00 0.00 90,000.00 83,343.55 18,220.97 101,564.52 11,564.52 11,564.52Other Non Operating Revenue 10-100-485049 Cap Vhcl Equip sale of assets 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 0 25,000.00 17,306.00 7,694.00 25,000.00 0.00 0.00 25,000.00 17,306.00 7,694.00 25,000.00 0.00 0.00Operating Transfers In 10-100-490193 Trsfer From Grant Fund 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 0 24,100.00 17,320.45 5,749.29 23,069.74 (1,030.26)(1,030.26) 10-100-490260 Trsfr from Fireman's Spec Rev 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf from Stoneridge TDD 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit "e"0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0 10,000.00 10,000.00 0.00 10,000.00 0.00 0.00 34,100.00 27,320.45 5,749.29 33,069.74 (1,030.26)(1,030.26) 30,007,851.81 22,489,378.59 8,660,669.93 31,150,048.52 1,142,196.71 1,142,196.71