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-02 Meeting - Revenue Model Report
Revenue Model Report For Period Ending January 31, 2017 Data as of February 3, 2017 FY 2017 YTD Actual Projected Over/ Description Budget As of 2/3/17 (Under) Budget Sales Tax and Use Tax $11,300,000.00 $1,083,570.26 $159,065.99 Intergovernmental Taxes $2,220,000.00 $138,766.93 $8,257.12 Other Taxes $116,000.00 $19,645.16 ($36.24) Franchise & Utility Tax $7,500,000.00 $1,113,137.37 $45,600.57 Property Taxes $5,274,699.00 $5,190,630.13 $134,863.16 Intergovernmental $0.00 $350.09 $350.09 Charges for Services $2,715,993.65 $1,769,890.79 ($109,401.07) Fees, Licenses, & Permits $708,400.00 $149,961.82 ($7,160.71) Fines & Forfeitures $1,009,100.00 $177,667.46 ($57,824.64) Contributions/Donations $306,950.00 $35,480.76 $5,780.76 Other Operating Revenues $84,181.25 $41,527.86 $31,026.31 Interest Income $110,000.00 $24,468.68 $11,661.39 Other Non Operating Revenue $54,000.00 $34,000.00 $0.00 Operating Transfers In $23,800.00 $4,184.53 $624.95 Totals $31,423,123.90 $9,783,281.84 $222,807.66 FY2017 Revenue Model Report (Detail)Remaining For Period Ending January 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 2/3/17 As of 2/3/17 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10-100-400010 Sales Tax $11,300,000.00 $1,083,570.26 $10,375,495.73 $11,459,065.99 $159,065.99 $159,065.99 $11,300,000.00 $1,083,570.26 $10,375,495.73 $11,459,065.99 $159,065.99 $159,065.99Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $550,000.00 $43,898.32 $501,918.14 $545,816.46 ($4,183.54)($4,183.54) 10-100-403010 Gasoline Tax $1,120,000.00 $94,868.61 $1,037,572.06 $1,132,440.67 $12,440.67 $12,440.67 10-100-430080 Road & Bridge Tax $550,000.00 $0.00 $550,000.00 $550,000.00 $0.00 $0.00 $2,220,000.00 $138,766.93 $2,089,490.19 $2,228,257.12 $8,257.12 $8,257.12Other Taxes 10-100-403020 Cig Tax $116,000.00 $19,645.16 $96,318.60 $115,963.76 ($36.24)($36.24) $116,000.00 $19,645.16 $96,318.60 $115,963.76 ($36.24)($36.24)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $4,000,000.00 $534,507.42 $3,484,000.91 $4,018,508.33 $18,508.33 $18,508.33 10-100-410030 Gas Utility License Tax $1,000,000.00 $147,448.70 $816,705.63 $964,154.33 ($35,845.67)($35,845.67) 10-100-410052 Telephone/Cell Utility $2,070,000.00 $348,349.30 $1,721,914.66 $2,070,263.96 $263.96 $263.96 10-100-410053 Telephone/Cell Audit $0.00 ($16,210.20)$0.00 ($16,210.20)($16,210.20)($16,210.20) 10-100-410060 Cable Franchise Fee $430,000.00 $99,042.15 $409,842.00 $508,884.15 $78,884.15 $78,884.15 $7,500,000.00 $1,113,137.37 $6,432,463.20 $7,545,600.57 $45,600.57 $45,600.57Property Taxes 10-100-420010 Current Property Tax $4,617,300.00 $4,586,292.36 $137,409.40 $4,723,701.76 $106,401.76 $106,401.76 10-100-420020 Del Property Tax $46,000.00 $12,521.47 $30,403.15 $42,924.62 ($3,075.38)($3,075.38) 10-100-420040 Fin Institution Tax $42,000.00 $53,356.45 $0.00 $53,356.45 $11,356.45 $11,356.45 10-100-420050 Prop Tax Int & Penalties $25,000.00 $4,168.92 $20,303.19 $24,472.11 ($527.89)($527.89) 10-100-420055 Surtax Receipts - County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10-100-420060 Surtax Receipts $465,000.00 $456,953.41 $13,639.43 $470,592.84 $5,592.84 $5,592.84 10-100-420080 Special Tax Rev $25,000.00 $22,938.24 $17,176.87 $40,115.11 $15,115.11 $15,115.11 $5,274,699.00 $5,190,630.13 $218,932.03 $5,409,562.16 $134,863.16 $134,863.16Intergovernmental 10-100-430040 Local Grant $0.00 $0.09 $0.00 $0.09 $0.09 $0.09 10-100-480020 NSP Rehab Sales $0.00 $350.00 $0.00 $350.00 $350.00 $350.00 10-100-480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $350.09 $0.00 $350.09 $350.09 $350.09 Charges for Services 10-100-440010 Admin Charge Backs $1,556,063.00 $1,556,063.00 $0.00 $1,556,063.00 $0.00 $0.00 10-100-440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $28,000.00 $4,893.00 $22,230.06 $27,123.06 ($876.94)($876.94) 10-100-440910 Fuel Charge - backs $11,000.00 $1,994.67 $7,886.32 $9,880.99 ($1,119.01)($1,119.01) 10-100-440920 Parts Charge backs $185,000.00 $7,603.61 $143,471.17 $151,074.78 ($33,925.22)($33,925.22) 10-100-440930 Labor Charge backs $240,000.00 $11,462.74 $182,254.07 $193,716.81 ($46,283.19)($46,283.19) 10-100-481020 Cole Cty Animal Rescue $105,508.00 $26,377.01 $79,131.00 $105,508.01 $0.01 $0.01 10-100-481030 Rent City Hall/Annex $35,000.00 $0.00 $0.00 $0.00 ($35,000.00)($35,000.00) 10-100-481040 Rent Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $104,000.00 $12,654.33 $98,577.10 $111,231.43 $7,231.43 $7,231.43 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 $366,423.91 $92,414.43 $273,721.51 $366,135.94 ($287.97)($287.97) 10-100-481080 Sale Of Maps/GIS Data $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481085 Cole Cty GIS Joint Coop $15,000.00 $3,750.00 $11,250.00 $15,000.00 $0.00 $0.00 10-100-481100 Sale Of Grave Sites $4,000.00 $2,448.00 $2,181.82 $4,629.82 $629.82 $629.82 10-100-481105 TIF Administration Fee $15,998.74 $230.00 $15,998.74 $16,228.74 $230.00 $230.00 10-100-481110 Long & Short $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,715,993.65 $1,769,890.79 $836,701.79 $2,606,592.58 ($109,401.07)($109,401.07)Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $66,000.00 $50.00 $64,815.05 $64,865.05 ($1,134.95)($1,134.95) 10-100-450020 Business Licenses $215,000.00 $32,332.41 $140,639.20 $172,971.61 ($42,028.39)($42,028.39) 10-100-450021 Home Occupation Permit $1,600.00 $371.02 $1,224.64 $1,595.66 ($4.34)($4.34) 10-100-450040 Abandoned Bldg. Regist.$0.00 $7,625.00 $0.00 $7,625.00 $7,625.00 $7,625.00 10-100-450041 Abandoned Bldg. Admin Fee $6,500.00 $22,322.00 $5,875.22 $28,197.22 $21,697.22 $21,697.22 10-100-450045 Building Construct. Fees $150,000.00 $28,200.03 $121,867.31 $150,067.34 $67.34 $67.34 10-100-450050 Electrical Certificates $19,000.00 $14,367.00 $3,626.07 $17,993.07 ($1,006.93)($1,006.93) 10-100-450060 Electrical Permits $4,000.00 $542.29 $3,214.58 $3,756.87 ($243.13)($243.13) 10-100-450070 Plumbing Licenses $10,500.00 $7,596.00 $2,734.53 $10,330.53 ($169.47)($169.47) 10-100-450080 Plumbing Permits $4,000.00 $790.00 $3,065.06 $3,855.06 ($144.94)($144.94) 10-100-450090 Other Lic & Permits $2,000.00 $631.00 $1,648.78 $2,279.78 $279.78 $279.78 10-100-450091 Day Care Inspection Fees $7,000.00 $1,290.00 $5,606.18 $6,896.18 ($103.82)($103.82) 10-100-450092 Food Inspection Fees $85,000.00 $4,741.07 $84,611.17 $89,352.24 $4,352.24 $4,352.24 10-100-450100 Curb Cut Permits $800.00 $212.00 $640.48 $852.48 $52.48 $52.48 FY2017 Revenue Model Report (Detail)Remaining For Period Ending January 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 2/3/17 As of 2/3/17 TOTAL (Under) Budget of Formulas 10-100-450110 Board Of Adj Fees $1,300.00 $420.00 $886.57 $1,306.57 $6.57 $6.57 10-100-450120 Sign Permits $5,100.00 $1,083.00 $4,298.47 $5,381.47 $281.47 $281.47 10-100-450130 Demolition Permits $900.00 $212.00 $645.58 $857.58 ($42.42)($42.42) 10-100-450150 Acc Rep Fees-police $11,200.00 $2,346.00 $8,547.24 $10,893.24 ($306.76)($306.76) 10-100-450160 Accrpt/blastg P-fire $900.00 $14.00 $789.29 $803.29 ($96.71)($96.71) 10-100-450170 Animal Redemption Fees $60,000.00 $12,695.00 $47,422.57 $60,117.57 $117.57 $117.57 10-100-450180 Animal Vaccinations Fees $4,300.00 $1,200.00 $3,612.00 $4,812.00 $512.00 $512.00 10-100-450185 Animal Cremation Fees $30,000.00 $6,907.00 $24,316.33 $31,223.33 $1,223.33 $1,223.33 10-100-450190 Taxi Permits $700.00 $78.00 $644.65 $722.65 $22.65 $22.65 10-100-450230 Vacating Right Of Way $800.00 $399.00 $479.45 $878.45 $78.45 $78.45 10-100-450250 Rezoning Request $12,000.00 $790.00 $12,000.00 $12,790.00 $790.00 $790.00 10-100-450255 Planning & Zoning Review Fees $8,000.00 $2,703.00 $6,278.79 $8,981.79 $981.79 $981.79 10-100-450260 Non-refundable Plans/spec $1,800.00 $45.00 $1,788.26 $1,833.26 $33.26 $33.26 $708,400.00 $149,961.82 $551,277.47 $701,239.29 ($7,160.71)($7,160.71)Fines & Forfeitures 10-100-460010 Court Cost $75,500.00 $15,969.84 $57,244.71 $73,214.55 ($2,285.45)($2,285.45) 10-100-460015 Court Restitutions $0.00 ($10.00)$0.00 ($10.00)($10.00)($10.00) 10-100-460018 Inmate Security Fund $12,500.00 $2,641.32 $9,587.80 $12,229.12 ($270.88)($270.88) 10-100-460020 Jail Cost Recovery $4,000.00 $353.82 $2,849.27 $3,203.09 ($796.91)($796.91) 10-100-460025 Alcohol Offense Cost Rec $8,000.00 $1,876.50 $6,522.99 $8,399.49 $399.49 $399.49 10-100-460030 Pol Fines-traffic $860,000.00 $146,381.97 $661,684.51 $808,066.48 ($51,933.52)($51,933.52) 10-100-460090 Parking Fines $53,000.00 $10,871.55 $39,152.72 $50,024.27 ($2,975.73)($2,975.73) 10-100-460100 Bankcard Charges ($3,900.00)($417.54)($3,434.11)($3,851.65)$48.35 $48.35 $1,009,100.00 $177,667.46 $773,607.90 $951,275.36 ($57,824.64)($57,824.64)Contributions/Donations 10-100-480055 JC Fire Museum $0.00 $700.00 $0.00 $700.00 $700.00 $700.00 10-100-480070 Community Projects Donations $4,200.00 $4,200.00 $0.00 $4,200.00 $0.00 $0.00 10-100-480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00 10-100-480090 Police K-9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00 10-100-480165 Animal S Donations $0.00 $4,580.76 $0.00 $4,580.76 $4,580.76 $4,580.76 10-100-481055 Street Repair-Solid Waste Cntr $302,250.00 $25,000.00 $277,250.00 $302,250.00 $0.00 $0.00 10-100-481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $306,950.00 $35,480.76 $277,250.00 $312,730.76 $5,780.76 $5,780.76 Other Operating Revenues 10-100-480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481070 Miscellaneous $35,000.00 $12,881.12 $32,600.40 $45,481.52 $10,481.52 $10,481.52 10-100-481072 TIF Prof Svcs Deposit $1,181.25 $21,582.50 $0.00 $21,582.50 $20,401.25 $20,401.25 10-100-481074 Revenue Share - Purchasing Card $18,000.00 $2,356.24 $14,705.31 $17,061.55 ($938.45)($938.45) 10-100-481077 Insurance Claims $20,000.00 $4,708.00 $16,373.98 $21,081.98 $1,081.98 $1,081.98 10-100-481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $84,181.25 $41,527.86 $73,679.70 $115,207.56 $31,026.31 $31,026.31 Interest Income 10-100-470010 Interest $110,000.00 $24,468.68 $97,192.71 $121,661.39 $11,661.39 $11,661.39 $110,000.00 $24,468.68 $97,192.71 $121,661.39 $11,661.39 $11,661.39Other Non Operating Revenue 10-100-485050 Sale Of Assets $54,000.00 $34,000.00 $20,000.00 $54,000.00 $0.00 $0.00 $54,000.00 $34,000.00 $20,000.00 $54,000.00 $0.00 $0.00Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $23,800.00 $4,184.53 $20,240.42 $24,424.95 $624.95 $624.95 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23,800.00 $4,184.53 $20,240.42 $24,424.95 $624.95 $624.95 $31,423,123.90 $9,783,281.84 $21,862,649.72 $31,645,931.56 $222,807.66 $222,807.66