Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2017-01 Meeting - Revenue Model Report
Revenue Model Report For Period Ending October 31, 2016 Data as of January 6, 2017 CFY 2016 YTD Actual Projected Over/ Description Budget As of 1/6/17 (Under) Budget Sales Tax and Use Tax $10,303,920.64 $11,002,277.22 $698,356.58 Intergovernmental Taxes $2,175,000.00 $2,256,567.12 $81,567.12 Other Taxes $120,000.00 $119,147.32 ($852.68) Franchise & Utility Tax $7,557,241.00 $7,258,960.13 ($298,280.87) Property Taxes $5,249,399.00 $5,267,656.59 $18,257.59 Intergovernmental $0.00 $53,961.29 $53,961.29 Charges for Services $2,614,957.65 $2,727,265.73 $112,308.08 Fees, Licenses, & Permits $716,850.00 $818,419.51 $101,569.51 Fines & Forfeitures $986,300.00 $939,843.01 ($46,456.99) Contributions/Donations $134,771.30 $315,830.53 $181,059.23 Other Operating Revenues $182,750.90 $226,093.63 $43,342.73 Interest Income $95,000.00 $161,299.58 $66,299.58 Other Non Operating Revenue $55,000.00 $310,059.27 $255,059.27 Operating Transfers In $72,200.00 $71,795.86 ($404.14) Totals $30,263,390.49 $31,529,176.79 $1,265,786.30 CFY2016 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2016 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 1/6/17 As of 1/6/17 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10-100-400010 Sales Tax $0.00 $10,303,920.64 $11,002,277.22 $0.00 $11,002,277.22 $698,356.58 $698,356.58 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,303,920.64 $11,002,277.22 $0.00 $11,002,277.22 $698,356.58 $698,356.58Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $0.00 $510,000.00 $556,693.03 $0.00 $556,693.03 $46,693.03 $46,693.03 10-100-403010 Gasoline Tax $0.00 $1,115,000.00 $1,147,229.81 $0.00 $1,147,229.81 $32,229.81 $32,229.81 10-100-430080 Road & Bridge Tax $0.00 $550,000.00 $552,644.28 $0.00 $552,644.28 $2,644.28 $2,644.28 $2,175,000.00 $2,256,567.12 $0.00 $2,256,567.12 $81,567.12 $81,567.12Other Taxes 10-100-403020 Cig Tax $0.00 $120,000.00 $119,147.32 $0.00 $119,147.32 ($852.68)($852.68) $120,000.00 $119,147.32 $0.00 $119,147.32 ($852.68)($852.68)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $0.00 $3,953,963.00 $4,005,062.85 $0.00 $4,005,062.85 $51,099.85 $51,099.85 10-100-410030 Gas Utility License Tax $0.00 $1,083,278.00 $785,322.37 $0.00 $785,322.37 ($297,955.63)($297,955.63) 10-100-410052 Telephone Cell w/o audit money $0.00 $2,100,000.00 $2,042,469.88 $0.00 $2,042,469.88 ($57,530.12)($57,530.12) 10-100-410053 Telephone/Cell Utility Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $0.00 $420,000.00 $426,105.03 $0.00 $426,105.03 $6,105.03 $6,105.03 10-100-410061 Cable Utility Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,557,241.00 $7,258,960.13 $0.00 $7,258,960.13 ($298,280.87)($298,280.87)Property Taxes 10-100-420010 Current Property Tax $0.00 $4,578,000.00 $4,589,286.70 $0.00 $4,589,286.70 $11,286.70 $11,286.70 10-100-420020 Del Property Tax $0.00 $55,000.00 $42,788.42 $0.00 $42,788.42 ($12,211.58)($12,211.58) 10-100-420040 Fin Institution Tax $0.00 $40,000.00 $41,818.57 $0.00 $41,818.57 $1,818.57 $1,818.57 10-100-420050 Prop Tax Int & Penalties $0.00 $30,000.00 $24,462.75 $0.00 $24,462.75 ($5,537.25)($5,537.25) 10-100-420055 Surtax Receipts - County Reimb $0.00 $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10-100-420060 Surtax Receipts $0.00 $472,000.00 $466,715.24 $0.00 $466,715.24 ($5,284.76)($5,284.76) 10-100-420080 Special Tax Rev $0.00 $20,000.00 $48,185.63 $0.00 $48,185.63 $28,185.63 $28,185.63 $5,249,399.00 $5,267,656.59 $0.00 $5,267,656.59 $18,257.59 $18,257.59Intergovernmental 10-100-430010 Federal Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430020 State Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430100 State DNR Historic Pres $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480020 NSP Rehab Sales $0.00 $0.00 $52,301.29 $0.00 $52,301.29 $52,301.29 $52,301.29 10-100-480025 HUD Program Income $0.00 $0.00 $1,660.00 $0.00 $1,660.00 $1,660.00 $1,660.00 $0.00 $53,961.29 $0.00 $53,961.29 $53,961.29 $53,961.29Charges for Services 10-100-440010 Admin Charge Backs $0.00 $1,559,899.00 $1,559,899.00 $0.00 $1,559,899.00 $0.00 $0.00 10-100-440050 Emt Reimbursement $0.00 $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $0.00 $25,000.00 $26,744.00 $0.00 $26,744.00 $1,744.00 $1,744.00 10-100-440910 Fuel Charge - backs $0.00 $13,000.00 $8,218.58 $0.00 $8,218.58 ($4,781.42)($4,781.42) 10-100-440920 Parts Charge backs $0.00 $110,000.00 $156,216.64 $0.00 $156,216.64 $46,216.64 $46,216.64 10-100-440930 Labor Charge backs $0.00 $216,449.00 $224,755.05 $0.00 $224,755.05 $8,306.05 $8,306.05 10-100-450189 Animal Shelter Bricks $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481020 Cole Cty Animal Rescue $0.00 $105,000.00 $104,051.32 $0.00 $104,051.32 ($948.68)($948.68) 10-100-481030 Rent City Hall/annex $0.00 $35,000.00 $35,000.00 $0.00 $35,000.00 $0.00 $0.00 10-100-481039 Rent-Hyde Park Facility $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481040 Rent Other $0.00 $0.00 $12,000.00 $0.00 $12,000.00 $12,000.00 $12,000.00 10-100-481045 Rent-tower Sites $0.00 $104,000.00 $155,246.71 $0.00 $155,246.71 $51,246.71 $51,246.71 10-100-481065 Parking Spot Maintenance $0.00 $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-481075 Cole Cty 911 Reimb $0.00 $369,879.65 $367,255.80 $0.00 $367,255.80 ($2,623.85)($2,623.85) 10-100-481080 Sale Of Maps/gis Data $0.00 $0.00 $265.00 $0.00 $265.00 $265.00 $265.00 10-100-481085 Cole Cty Gis Joint Coop $0.00 $15,000.00 $15,000.00 $0.00 $15,000.00 $0.00 $0.00 10-100-481090 Cole Cty Sheriff-New World $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481100 Sale Of Grave Sites $0.00 $4,000.00 $4,488.00 $0.00 $4,488.00 $488.00 $488.00 10-100-481105 TIF Administration Fee $0.00 $7,730.00 $8,105.00 $0.00 $8,105.00 $375.00 $375.00 10-100-481110 Long & Short $0.00 $0.00 $20.63 $0.00 $20.63 $20.63 $20.63 $2,614,957.65 $2,727,265.73 $0.00 $2,727,265.73 $112,308.08 $112,308.08Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $0.00 $65,000.00 $65,255.58 $0.00 $65,255.58 $255.58 $255.58 10-100-450020 Business Licenses $0.00 $215,000.00 $212,362.34 $0.00 $212,362.34 ($2,637.66)($2,637.66) 10-100-450021 Home Occupation Permit $0.00 $1,500.00 $1,537.00 $0.00 $1,537.00 $37.00 $37.00 10-100-450030 Solicitors Lic $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450040 Abandoned Bldg. Reg $0.00 $0.00 $1,525.00 $0.00 $1,525.00 $1,525.00 $1,525.00 10-100-450041 Abandoned Bldg. Admin Fee $0.00 $6,500.00 $4,129.00 $0.00 $4,129.00 ($2,371.00)($2,371.00) 10-100-450045 Bldg. Constr Fees $0.00 $175,000.00 $249,151.66 $0.00 $249,151.66 $74,151.66 $74,151.66 10-100-450050 Electrical Certificates $0.00 $18,000.00 $16,974.00 $0.00 $16,974.00 ($1,026.00)($1,026.00) 10-100-450060 Electrical Permits $0.00 $3,000.00 $2,436.41 $0.00 $2,436.41 ($563.59)($563.59) 10-100-450070 Plumbing Licenses $0.00 $10,000.00 $10,713.00 $0.00 $10,713.00 $713.00 $713.00 10-100-450080 Plumbing Permits $0.00 $5,000.00 $3,766.41 $0.00 $3,766.41 ($1,233.59)($1,233.59) 10-100-450090 Other Lic & Permits $0.00 $2,000.00 $2,386.00 $0.00 $2,386.00 $386.00 $386.00 10-100-450091 Day Care Inspection Fees $0.00 $9,000.00 $7,935.00 $0.00 $7,935.00 ($1,065.00)($1,065.00) 10-100-450092 Food Inspection Fees $0.00 $86,500.00 $83,846.41 $0.00 $83,846.41 ($2,653.59)($2,653.59) 10-100-450100 Curb Cut Permits $0.00 $1,500.00 $689.00 $0.00 $689.00 ($811.00)($811.00) 10-100-450110 Board Of Adj Fees $0.00 $1,200.00 $1,680.00 $0.00 $1,680.00 $480.00 $480.00 10-100-450120 Sign Permits $0.00 $5,000.00 $7,238.00 $0.00 $7,238.00 $2,238.00 $2,238.00 10-100-450130 Demolition Permits $0.00 $500.00 $1,484.00 $0.00 $1,484.00 $984.00 $984.00 10-100-450150 Acc Rep Fees-police $0.00 $12,000.00 $12,214.70 $0.00 $12,214.70 $214.70 $214.70 10-100-450160 Accrpt/blastg P-fire $0.00 $750.00 $1,293.00 $0.00 $1,293.00 $543.00 $543.00 10-100-450170 Animal Redemption Fees $0.00 $55,000.00 $69,956.00 $0.00 $69,956.00 $14,956.00 $14,956.00 10-100-450180 Animal Vaccinations Fees $0.00 $5,000.00 $5,000.00 $0.00 $5,000.00 $0.00 $0.00 10-100-450185 Animal Cremation Fees $0.00 $25,000.00 $35,185.00 $0.00 $35,185.00 $10,185.00 $10,185.00 10-100-450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450190 Taxi Permits $0.00 $500.00 $1,014.00 $0.00 $1,014.00 $514.00 $514.00 10-100-450230 Vacating Right Of Way $0.00 $400.00 $1,330.00 $0.00 $1,330.00 $930.00 $930.00 10-100-450250 Rezoning Request $0.00 $12,000.00 $6,925.00 $0.00 $6,925.00 ($5,075.00)($5,075.00) 10-100-450255 Planning & Zoning Review Fees $0.00 $0.00 $10,433.00 $0.00 $10,433.00 $10,433.00 $10,433.00 10-100-450260 Non-refundable Plans/spec $0.00 $1,500.00 $1,960.00 $0.00 $1,960.00 $460.00 $460.00 $716,850.00 $818,419.51 $0.00 $818,419.51 $101,569.51 $101,569.51 CFY2016 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2016 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 1/6/17 As of 1/6/17 TOTAL (Under) Budget of Formulas Fines & Forfeitures 10-100-460010 Court Cost $0.00 $75,500.00 $72,783.06 $0.00 $72,783.06 ($2,716.94)($2,716.94) 10-100-460015 Court Restitutions $0.00 $1,300.00 $89.71 $0.00 $89.71 ($1,210.29)($1,210.29) 10-100-460018 Inmate Security Fund $0.00 $12,500.00 $11,750.65 $0.00 $11,750.65 ($749.35)($749.35) 10-100-460020 Jail Cost Recovery $0.00 $8,000.00 $2,563.53 $0.00 $2,563.53 ($5,436.47)($5,436.47) 10-100-460025 Alcohol Offense Cost Rec $0.00 $8,000.00 $8,346.50 $0.00 $8,346.50 $346.50 $346.50 10-100-460030 Pol Fines-traffic $0.00 $835,000.00 $783,575.22 $0.00 $783,575.22 ($51,424.78)($51,424.78) 10-100-460040 Pol Tickets-parking $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460050 Pol fines - Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460060 Dog Fines $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460070 P & Code Violations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460090 Parking Fines $0.00 $53,000.00 $65,256.20 $0.00 $65,256.20 $12,256.20 $12,256.20 10-100-460100 Bankcard Charges $0.00 ($7,000.00)($4,521.86)$0.00 ($4,521.86)$2,478.14 $2,478.14 $986,300.00 $939,843.01 $0.00 $939,843.01 ($46,456.99)($46,456.99)Contributions/Donations 10-100-480010 Citizen Participation $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480015 Sidewalk Waiver Revenue $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480030 Donations-Recycling $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480050 Sober Driver Program $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480055 JC Fire Museum $0.00 $0.00 $4,190.00 $0.00 $4,190.00 $4,190.00 $4,190.00 10-100-480063 Private Donations-Cultural Art $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480065 Cultural Arts $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480070 Community Projects Donations $0.00 $3,700.00 $3,700.00 $0.00 $3,700.00 $0.00 $0.00 10-100-480080 Dare Donations $0.00 $0.00 $500.00 $0.00 $500.00 $500.00 $500.00 10-100-480090 Police K-9 Donations $0.00 $55,500.00 $55,500.00 $0.00 $55,500.00 $0.00 $0.00 10-100-480165 Animal S Donations $0.00 $0.00 $14,884.28 $0.00 $14,884.28 $14,884.28 $14,884.28 10-100-481050 Transfer Stn/Plng-Sld Wst Cntr $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481055 Street Repair-Solid Waste Cntr $0.00 $75,000.00 $236,484.95 $0.00 $236,484.95 $161,484.95 $161,484.95 10-100-481095 Cemetery Donations $0.00 $571.30 $571.30 $0.00 $571.30 $0.00 $0.00 10-100-486070 Cap Contr-neighorhood Imp Pro $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $134,771.30 $315,830.53 $0.00 $315,830.53 $181,059.23 $181,059.23 Other Operating Revenues 10-100-450187 Special Sn Program $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450188 Adoption Voucher Program $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480011 Police Evidence Funds $0.00 $0.00 $23,896.98 $0.00 $23,896.98 $23,896.98 $23,896.98 10-100-481069 Utility Audit Revenue $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481070 Miscellaneous $0.00 $35,000.00 $21,897.50 $0.00 $21,897.50 ($13,102.50)($13,102.50) 10-100-481072 TIF Prof Svcs Deposit $0.00 $117,750.90 $99,093.40 $0.00 $99,093.40 ($18,657.50)($18,657.50) 10-100-481074 Revenue Share - Purchasing Card $0.00 $21,165.22 $0.00 $21,165.22 $21,165.22 $21,165.22 10-100-481077 Insurance Claims $0.00 $20,000.00 $51,377.33 $0.00 $51,377.33 $31,377.33 $31,377.33 10-100-481078 Cafeteria Refunds $0.00 $10,000.00 $8,663.20 $0.00 $8,663.20 ($1,336.80)($1,336.80) $182,750.90 $226,093.63 $0.00 $226,093.63 $43,342.73 $43,342.73Interest Income 10-100-470010 Interest $0.00 $95,000.00 $161,299.58 $0.00 $161,299.58 $66,299.58 $66,299.58 10-100-470051 Unrealized Gains and Losses $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $95,000.00 $161,299.58 $0.00 $161,299.58 $66,299.58 $66,299.58Other Non Operating Revenue 10-100-485049 Cap Vhcl Equip sale of assets $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-485050 Sale Of Assets $0.00 $55,000.00 $310,059.27 $0.00 $310,059.27 $255,059.27 $255,059.27 $55,000.00 $310,059.27 $0.00 $310,059.27 $255,059.27 $255,059.27Operating Transfers In 10-100-490193 Trsfer From Grant Fund $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490240 Trsfr From Lodging Tax $0.00 $23,800.00 $23,395.86 $0.00 $23,395.86 ($404.14)($404.14) 10-100-490260 Trsfr from Fireman's Spec Rev $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490280 Trnf from Stoneridge TDD $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490353 Transfer From Cit "e"$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490600 Transfer from Water Fund $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490620 Transfer from Parking Fund $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $48,400.00 $48,400.00 $0.00 $48,400.00 $0.00 $0.00 $72,200.00 $71,795.86 $0.00 $71,795.86 ($404.14)($404.14) $30,263,390.49 $31,529,176.79 $0.00 $31,529,176.79 $1,265,786.30 $1,265,786.30