Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2016-08 Meeting - Revenue Model Report
Revenue Model Report For Period Ending July 31, 2016 Data as of August 8, 2016 CFY 2016 YTD Actual Projected Over/ Description Budget As of 8/8/16 (Under) Budget Sales Tax and Use Tax $10,303,920.64 $7,260,144.71 $798,441.10 Intergovernmental Taxes $2,175,000.00 $1,526,909.74 $66,410.32 Other Taxes $120,000.00 $78,501.92 $91.20 Franchise & Utility Tax $7,557,241.00 $4,541,375.95 ($360,614.75) Property Taxes $5,249,399.00 $5,208,497.64 $21,973.85 Intergovernmental $3,930.00 $52,301.29 ($3,930.00) Charges for Services $2,614,957.65 $2,437,167.00 $68,719.89 Fees, Licenses, & Permits $716,850.00 $684,697.74 $123,908.06 Fines & Forfeitures $986,300.00 $717,663.62 ($20,050.96) Contributions/Donations $134,371.30 $182,155.53 $88,243.85 Other Operating Revenues $65,000.00 $60,981.30 $4,150.47 Interest Income $95,000.00 $107,363.65 $51,307.23 Other Non Operating Revenue $25,000.00 $168,180.00 $168,180.00 Operating Transfers In $72,200.00 $66,074.01 ($502.61) Totals $30,119,169.59 $23,092,014.10 $1,006,327.65 CFY2016 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2016 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 8/8/16 As of 8/8/16 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10-100-400010 Sales Tax $0.00 $10,303,920.64 $7,260,144.71 $3,842,217.03 $11,102,361.74 $798,441.10 $798,441.10 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,303,920.64 $7,260,144.71 $3,842,217.03 $11,102,361.74 $798,441.10 $798,441.10Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $0.00 $510,000.00 $325,956.14 $220,525.18 $546,481.32 $36,481.31 $36,481.31 10-100-403010 Gasoline Tax $0.00 $1,115,000.00 $648,309.32 $493,975.41 $1,142,284.73 $27,284.73 $27,284.73 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 $1,526,909.74 $714,500.59 $2,241,410.33 $66,410.32 $66,410.33Other Taxes 10-100-403020 Cig Tax $0.00 $120,000.00 $78,501.92 $41,589.28 $120,091.20 $91.20 $91.20 $120,000.00 $78,501.92 $41,589.28 $120,091.20 $91.20 $91.20Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $0.00 $3,953,963.00 $2,302,695.83 $1,625,305.69 $3,928,001.52 ($25,961.48)($25,961.48) 10-100-410030 Gas Utility License Tax $0.00 $1,083,278.00 $652,349.40 $150,130.86 $802,480.26 ($280,797.74)($280,797.74) 10-100-410052 Telephone Cell w/o audit money $0.00 $2,100,000.00 $1,369,071.02 $707,035.70 $2,076,106.72 ($23,893.28)($23,893.28) 10-100-410053 Telephone/Cell Utility Audit $0.00 $0.00 ($17,210.20)$17,210.20 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $0.00 $420,000.00 $234,469.90 $155,567.86 $390,037.76 ($29,962.25)($29,962.25) 10-100-410061 Cable Utility Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,557,241.00 $4,541,375.95 $2,655,250.30 $7,196,626.25 ($360,614.75)($360,614.75)Property Taxes 10-100-420010 Current Property Tax $0.00 $4,578,000.00 $4,573,949.01 $16,894.00 $4,590,843.01 $12,843.01 $12,843.01 10-100-420020 Del Property Tax $0.00 $55,000.00 $33,035.86 $9,068.03 $42,103.89 ($12,896.12)($12,896.12) 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 $16,586.49 $8,506.73 $25,093.22 ($4,906.79)($4,906.79) 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 $465,330.07 $2,305.01 $467,635.08 ($4,364.92)($4,364.92) 10-100-420080 Special Tax Rev $0.00 $20,000.00 $23,378.36 $26,101.46 $49,479.82 $29,479.82 $29,479.82 $5,249,399.00 $5,208,497.64 $62,875.21 $5,271,372.85 $21,973.85 $21,973.85Intergovernmental 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 $3,930.00 $0.00 $0.00 $0.00 ($3,930.00)($3,930.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 ($52,301.29)$0.00 $0.00 $0.00 10-100-480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,930.00 $52,301.29 ($52,301.29)$0.00 ($3,930.00)($3,930.00)Charges 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 $0.00 $0.00 $0.00 ($25,000.00)($25,000.00) 10-100-440210 Street Cuts $0.00 $25,000.00 $17,847.00 $6,164.00 $24,011.00 ($989.00)($989.00) 10-100-440910 Fuel Charge - backs $0.00 $13,000.00 $6,067.59 $0.00 $6,067.59 ($6,932.41)($6,932.41) 10-100-440920 Parts Charge backs $0.00 $110,000.00 $123,360.04 $27,500.00 $150,860.04 $40,860.04 $40,860.04 10-100-440930 Labor Charge backs $0.00 $216,449.00 $172,815.05 $49,800.18 $222,615.23 $6,166.22 $6,166.22 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 $78,038.49 $27,974.34 $106,012.83 $1,012.83 $1,012.83 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 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $0.00 $104,000.00 $122,576.80 $30,306.12 $152,882.92 $48,882.92 $48,882.92 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 $274,553.40 $92,469.90 $367,023.30 ($2,856.35)($2,856.35) 10-100-481080 Sale Of Maps/gis Data $0.00 $0.00 $195.00 $0.00 $195.00 $195.00 $195.00 10-100-481085 Cole Cty Gis Joint Coop $0.00 $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.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 $2,448.00 $816.00 $3,264.00 ($736.00)($736.00) 10-100-481105 TIF Administration Fee $0.00 $7,730.00 $8,105.00 $7,730.00 $15,835.00 $8,105.00 $8,105.00 10-100-481110 Long & Short $0.00 $0.00 $11.63 $0.00 $11.63 $11.63 $11.63 $2,614,957.65 $2,437,167.00 $246,510.54 $2,683,677.54 $68,719.89 $68,719.88Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $0.00 $65,000.00 $63,611.58 $2,031.25 $65,642.83 $642.83 $642.83 10-100-450020 Business Licenses $0.00 $215,000.00 $186,111.10 $30,726.67 $216,837.77 $1,837.77 $1,837.77 10-100-450021 Home Occupation Permit $0.00 $1,500.00 $1,430.00 $132.00 $1,562.00 $62.00 $62.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 $5,550.00 $0.00 $5,550.00 $5,550.00 $5,550.00 10-100-450041 Abandoned Bldg. Admin Fee $0.00 $6,500.00 $38,681.13 $0.00 $38,681.13 $32,181.13 $32,181.13 10-100-450045 Bldg. Constr Fees $0.00 $175,000.00 $151,220.26 $83,886.15 $235,106.41 $60,106.41 $60,106.41 10-100-450050 Electrical Certificates $0.00 $18,000.00 $16,692.00 $1,685.00 $18,377.00 $377.00 $377.00 10-100-450060 Electrical Permits $0.00 $3,000.00 $1,803.11 $1,921.18 $3,724.29 $724.29 $724.29 10-100-450070 Plumbing Licenses $0.00 $10,000.00 $10,083.00 $528.50 $10,611.50 $611.50 $611.50 10-100-450080 Plumbing Permits $0.00 $5,000.00 $2,791.25 $1,005.00 $3,796.25 ($1,203.75)($1,203.75) 10-100-450090 Other Lic & Permits $0.00 $2,000.00 $1,287.00 $1,068.00 $2,355.00 $355.00 $355.00 10-100-450091 Day Care Inspection Fees $0.00 $9,000.00 $4,720.00 $2,302.50 $7,022.50 ($1,977.50)($1,977.50) 10-100-450092 Food Inspection Fees $0.00 $86,500.00 $87,395.91 $1,038.02 $88,433.93 $1,933.93 $1,933.93 10-100-450100 Curb Cut Permits $0.00 $1,500.00 $530.00 $212.00 $742.00 ($758.00)($758.00) 10-100-450110 Board Of Adj Fees $0.00 $1,200.00 $1,050.00 $0.00 $1,050.00 ($150.00)($150.00) 10-100-450120 Sign Permits $0.00 $5,000.00 $5,688.00 $818.00 $6,506.00 $1,506.00 $1,506.00 10-100-450130 Demolition Permits $0.00 $500.00 $1,272.00 $53.00 $1,325.00 $825.00 $825.00 10-100-450150 Acc Rep Fees-police $0.00 $12,000.00 $8,791.40 $2,541.05 $11,332.45 ($667.55)($667.55) 10-100-450160 Accrpt/blastg P-fire $0.00 $750.00 $738.00 $333.50 $1,071.50 $321.50 $321.50 10-100-450170 Animal Redemption Fees $0.00 $55,000.00 $49,821.00 $16,072.50 $65,893.50 $10,893.50 $10,893.50 10-100-450180 Animal Vaccinations Fees $0.00 $5,000.00 $3,600.00 $987.50 $4,587.50 ($412.50)($412.50) 10-100-450185 Animal Cremation Fees $0.00 $25,000.00 $24,284.00 $5,156.00 $29,440.00 $4,440.00 $4,440.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 $962.00 $26.00 $988.00 $488.00 $488.00 10-100-450230 Vacating Right Of Way $0.00 $400.00 $1,330.00 $131.50 $1,461.50 $1,061.50 $1,061.50 10-100-450250 Rezoning Request $0.00 $12,000.00 $4,719.00 $3,157.50 $7,876.50 ($4,123.50)($4,123.50) 10-100-450255 Planning & Zoning Review Fees $0.00 $0.00 $8,576.00 $0.00 $8,576.00 $8,576.00 $8,576.00 10-100-450260 Non-refundable Plans/spec $0.00 $1,500.00 $1,960.00 $247.50 $2,207.50 $707.50 $707.50 $716,850.00 $684,697.74 $156,060.32 $840,758.06 $123,908.06 $123,908.06 CFY2016 Revenue Model Report (Detail)Remaining For Period Ending July 31, 2016 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 8/8/16 As of 8/8/16 TOTAL (Under) Budget of Formulas Fines & Forfeitures 10-100-460010 Court Cost $0.00 $75,500.00 $56,444.66 $19,599.51 $76,044.17 $544.17 $544.17 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 $9,070.47 $3,243.41 $12,313.88 ($186.12)($186.12) 10-100-460020 Jail Cost Recovery $0.00 $8,000.00 $2,217.02 $864.47 $3,081.49 ($4,918.52)($4,918.52) 10-100-460025 Alcohol Offense Cost Rec $0.00 $8,000.00 $6,219.00 $2,124.75 $8,343.75 $343.75 $343.75 10-100-460030 Pol Fines-traffic $0.00 $835,000.00 $612,359.36 $214,270.45 $826,629.81 ($8,370.19)($8,370.19) 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 $33,902.79 $9,296.73 $43,199.52 ($9,800.49)($9,800.49) 10-100-460100 Bankcard Charges $0.00 ($7,000.00)($2,639.39)($813.88)($3,453.27)$3,546.73 $3,546.73 $986,300.00 $717,663.62 $248,585.43 $966,249.05 ($20,050.96)($20,050.95)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 $2,015.00 $0.00 $2,015.00 $2,015.00 $2,015.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,300.00 $3,300.00 $0.00 $3,300.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 $8,784.28 $0.00 $8,784.28 $8,784.28 $8,784.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 $111,484.95 $40,459.62 $151,944.57 $76,944.57 $76,944.57 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,371.30 $182,155.53 $40,459.62 $222,615.15 $88,243.85 $88,243.85 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 $14,342.74 $0.00 $14,342.74 $14,342.74 $14,342.74 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 $14,418.32 $0.00 $14,418.32 ($20,581.68)($20,581.68) 10-100-481072 TIF Prof Svcs Deposit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481074 Revenue Share - Purchasing Card $0.00 $15,002.12 $0.00 $15,002.12 $15,002.12 $15,002.12 10-100-481077 Insurance Claims $0.00 $20,000.00 $17,218.12 $8,169.17 $25,387.29 $5,387.29 $5,387.29 10-100-481078 Cafeteria Refunds $0.00 $10,000.00 $0.00 $0.00 $0.00 ($10,000.00)($10,000.00) $65,000.00 $60,981.30 $8,169.17 $69,150.47 $4,150.47 $4,150.47Interest Income 10-100-470010 Interest $0.00 $95,000.00 $107,363.65 $38,943.58 $146,307.23 $51,307.23 $51,307.23 10-100-470051 Unrealized Gains and Losses $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $95,000.00 $107,363.65 $38,943.58 $146,307.23 $51,307.23 $51,307.23Other 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 $25,000.00 $168,180.00 $25,000.00 $193,180.00 $168,180.00 $168,180.00 $25,000.00 $168,180.00 $25,000.00 $193,180.00 $168,180.00 $168,180.00Operating 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 $17,674.01 $5,623.38 $23,297.39 ($502.61)($502.61) 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 $66,074.01 $5,623.38 $71,697.39 ($502.61)($502.61) $30,119,169.59 $23,092,014.10 $8,033,483.14 $31,125,497.24 $1,006,327.65 $1,006,327.65