Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2022-10 Meeting - Revenue Model Report
Revenue Model Report For the Period Ending September 30, 2022 Data as of October 12, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 10/12 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $11,362,633.99 $944,812.07 Intergovernmental Taxes $2,512,000.00 $2,111,433.74 $78,538.74 Other Taxes $96,000.00 $72,996.12 ($6,193.36) Franchise & Utility Tax $6,450,000.00 $5,323,582.11 $85,182.49 Property Taxes $5,709,659.76 $5,847,176.07 $157,409.30 Intergovernmental $7,074,853.74 $8,335.00 $8,335.00 Charges for Services $3,000,478.08 $2,954,836.20 $85,444.67 Fees, Licenses, & Permits $1,066,437.50 $879,663.99 ($144,637.67) Fines & Forfeitures $580,000.00 $377,658.66 ($160,161.44) Contributions/Donations $383,616.57 $407,314.86 $83,979.41 Other Operating Revenues $164,281.57 $178,407.67 $58,542.03 Interest Income $170,000.00 $193,010.90 $70,734.73 Other Non Operating Revenue $55,000.00 $197,742.06 $197,742.06 Operating Transfers In $506,431.67 $506,460.43 $2,614.61 Totals $40,290,234.28 $30,421,251.80 $1,462,342.64 FY2022Revenue Model Report (Detail)Remaining For the Period Ending September 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 10/12 As of 10/12 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $11,361,861.46 $2,103,653.47 $13,465,514.93 $944,039.54 $944,039.54 10-100-400020 Sales Tax Interest $0.00 $772.53 $0.00 $772.53 $772.53 $772.53 $12,521,475.39 $11,362,633.99 $2,103,653.47 $13,466,287.46 $944,812.07 $944,812.07Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $485,427.12 $151,084.77 $636,511.89 $24,511.89 $24,511.89 10-100-403010 Gasoline Tax $1,250,000.00 $984,444.04 $328,020.23 $1,312,464.27 $62,464.27 $62,464.27 10-100-430080 Road & Bridge Tax $650,000.00 $641,562.58 $0.00 $641,562.58 ($8,437.42)($8,437.42) $2,512,000.00 $2,111,433.74 $479,105.00 $2,590,538.74 $78,538.74 $78,538.74Other Taxes 10-100-403020 Cig Tax $96,000.00 $72,996.12 $16,810.52 $89,806.64 ($6,193.36)($6,193.36) $96,000.00 $72,996.12 $16,810.52 $89,806.64 ($6,193.36)($6,193.36)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $3,236,281.82 $836,393.36 $4,072,675.18 $172,675.18 $172,675.18 10-100-410021 Electric Utility-AUDIT $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410030 Gas Utility License Tax $800,000.00 $986,300.97 $61,870.00 $1,048,170.97 $248,170.97 $248,170.97 10-100-410052 Telephone/Cell Utility $1,450,000.00 $883,503.17 $234,724.67 $1,118,227.84 ($331,772.16)($331,772.16) 10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $300,000.00 $217,496.15 $78,612.35 $296,108.50 ($3,891.50)($3,891.50) $6,450,000.00 $5,323,582.11 $1,211,600.38 $6,535,182.49 $85,182.49 $85,182.49Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,049,474.07 $3,482.56 $5,052,956.63 $67,956.63 $67,956.63 10-100-420020 Del Property Tax $60,000.00 $66,467.29 $4,895.17 $71,362.46 $11,362.46 $11,362.46 10-100-420040 Fin Institution Tax $30,000.00 $32,244.53 $0.00 $32,244.53 $2,244.53 $2,244.53 10-100-420050 Prop Tax Int & Penalties $27,000.00 $29,443.51 $2,312.28 $31,755.79 $4,755.79 $4,755.79 10-100-420055 Surtax Receipts - County Reimb $41,659.76 $54,399.28 $0.00 $54,399.28 $12,739.52 $12,739.52 10-100-420060 Surtax Receipts $500,000.00 $505,866.32 ($2.59)$505,863.73 $5,863.73 $5,863.73 10-100-420080 Special Tax Rev $66,000.00 $109,281.07 $9,205.57 $118,486.64 $52,486.64 $52,486.64 $5,709,659.76 $5,847,176.07 $19,892.99 $5,867,069.06 $157,409.30 $157,409.30Intergovernmental 10-100-430010 Federal Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430012 Federal Grant $7,074,853.74 $0.00 $7,074,853.74 $7,074,853.74 $0.00 $0.00 10-100-430040 Local Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430060 Drug Forfeiture $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480020 NSP Rehab Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480025 HUD Program Income $0.00 $8,335.00 $0.00 $8,335.00 $8,335.00 $8,335.00 $7,074,853.74 $8,335.00 $7,074,853.74 $7,083,188.74 $8,335.00 $8,335.00Charges for Services 10-100-440010 Admin Charge Backs $1,614,977.00 $1,614,977.00 $0.00 $1,614,977.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 $36,000.00 $28,297.50 $4,359.33 $32,656.83 ($3,343.17)($3,343.17) 10-100-440910 Fuel Charge - backs $13,000.00 $18,174.26 $2,291.01 $20,465.27 $7,465.27 $7,465.27 10-100-440920 Parts Charge backs $242,732.58 $254,789.17 $24,169.96 $278,959.13 $36,226.55 $36,226.55 10-100-440930 Labor Charge backs $273,719.72 $232,337.26 $24,304.82 $256,642.08 ($17,077.64)($17,077.64) 10-100-481020 Cole Cty Animal Rescue $116,645.39 $87,484.05 $29,161.34 $116,645.39 $0.00 $0.00 10-100-481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481040 Rent Other $12,000.00 $12,000.00 $0.00 $12,000.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $185,000.00 $246,227.59 $66.55 $246,294.14 $61,294.14 $61,294.14 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 $417,564.39 $380,614.12 $34,874.53 $415,488.65 ($2,075.74)($2,075.74) 10-100-481080 Sale Of Maps/GIS Data $0.00 $10.00 $0.00 $10.00 $10.00 $10.00 10-100-481085 Cole Cty GIS Joint Coop $15,000.00 $16,535.00 $1,250.00 $17,785.00 $2,785.00 $2,785.00 10-100-481100 Sale Of Grave Sites $3,000.00 $2,919.00 $0.00 $2,919.00 ($81.00)($81.00) 10-100-481105 TIF Administration Fee $20,839.00 $10,230.00 $10,609.00 $20,839.00 $0.00 $0.00 10-100-481110 Long & Short $0.00 $241.25 $0.00 $241.25 $241.25 $241.25 $3,000,478.08 $2,954,836.20 $131,086.55 $3,085,922.75 $85,444.67 $85,444.67Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $72,994.67 $55.06 $73,049.73 $1,049.73 $1,049.73 10-100-450020 Business Licenses $220,000.00 $216,784.21 $4,073.65 $220,857.86 $857.86 $857.86 10-100-450021 Home Occupation Permit $2,500.00 $1,870.00 $215.05 $2,085.05 ($414.95)($414.95) 10-100-450040 Abandoned Bldg. Regist.$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450041 Abandoned Bldg. Admin Fee $8,000.00 $9,495.00 $0.00 $9,495.00 $1,495.00 $1,495.00 10-100-450045 Building Construct. Fees $421,687.50 $247,720.17 $22,205.48 $269,925.65 ($151,761.85)($151,761.85) 10-100-450050 Electrical Certificates $22,000.00 $27,827.00 $1,499.54 $29,326.54 $7,326.54 $7,326.54 10-100-450060 Electrical Permits $5,000.00 $7,207.97 $169.31 $7,377.28 $2,377.28 $2,377.28 10-100-450070 Plumbing Licenses $12,400.00 $16,665.00 $444.33 $17,109.33 $4,709.33 $4,709.33 10-100-450080 Plumbing Permits $10,000.00 $16,678.12 $881.11 $17,559.23 $7,559.23 $7,559.23 10-100-450090 Other Lic & Permits $2,000.00 $2,644.00 $214.26 $2,858.26 $858.26 $858.26 FY2022Revenue Model Report (Detail)Remaining For the Period Ending September 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 10/12 As of 10/12 TOTAL (Under) Budget of Formulas 10-100-450091 Day Care Inspection Fees $5,500.00 $3,510.00 $568.97 $4,078.97 ($1,421.03)($1,421.03) 10-100-450092 Food Inspection Fees $88,000.00 $92,314.25 ($2,336.60)$89,977.65 $1,977.65 $1,977.65 10-100-450100 Curb Cut Permits $1,000.00 $1,375.00 $148.54 $1,523.54 $523.54 $523.54 10-100-450110 Board Of Adj Fees $2,000.00 $3,700.00 $0.00 $3,700.00 $1,700.00 $1,700.00 10-100-450120 Sign Permits $6,900.00 $6,293.00 $657.45 $6,950.45 $50.45 $50.45 10-100-450130 Demolition Permits $3,000.00 $3,409.00 $316.32 $3,725.32 $725.32 $725.32 10-100-450150 Acc Rep Fees-police $8,000.00 $6,439.80 $706.29 $7,146.09 ($853.91)($853.91) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $859.80 $107.39 $967.19 ($182.81)($182.81) 10-100-450170 Animal Redemption Fees $98,000.00 $89,339.00 $7,616.74 $96,955.74 ($1,044.26)($1,044.26) 10-100-450180 Animal Vaccinations Fees $5,200.00 $3,850.00 $206.85 $4,056.85 ($1,143.15)($1,143.15) 10-100-450185 Animal Cremation Fees $50,000.00 $30,160.00 $2,923.98 $33,083.98 ($16,916.02)($16,916.02) 10-100-450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450190 Taxi Permits $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450230 Vacating Right Of Way $800.00 $463.00 $57.14 $520.14 ($279.86)($279.86) 10-100-450250 Rezoning Request $0.00 $3,260.00 $0.00 $3,260.00 $3,260.00 $3,260.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $13,725.00 $1,178.04 $14,903.04 ($5,096.96)($5,096.96) 10-100-450260 Non-refundable Plans/spec $1,300.00 $1,080.00 $226.93 $1,306.93 $6.93 $6.93 $1,066,437.50 $879,663.99 $42,135.84 $921,799.83 ($144,637.67)($144,637.67)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $28,996.88 $3,698.88 $32,695.76 ($18,304.24)($18,304.24) 10-100-460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460018 Inmate Security Fund $8,500.00 $4,837.08 $609.47 $5,446.55 ($3,053.45)($3,053.45) 10-100-460020 Jail Cost Recovery $1,000.00 $157.50 $0.00 $157.50 ($842.50)($842.50) 10-100-460025 Alcohol Offense Cost Rec $6,000.00 $5,180.00 $261.83 $5,441.83 ($558.17)($558.17) 10-100-460030 Pol Fines-traffic $490,000.00 $309,387.18 $36,058.11 $345,445.29 ($144,554.71)($144,554.71) 10-100-460090 Parking Fines $29,000.00 $35,313.00 $1,998.98 $37,311.98 $8,311.98 $8,311.98 10-100-460100 Bankcard Charges ($5,500.00)($6,212.98)($447.38)($6,660.36)($1,160.36)($1,160.36) $580,000.00 $377,658.66 $42,179.90 $419,838.56 ($160,161.44)($160,161.44)Contributions/Donations 10-100-480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480070 Community Projects Donations $10,828.57 $11,843.57 $0.00 $11,843.57 $1,015.00 $1,015.00 10-100-480080 Dare Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480090 Police K-9 Donations $0.00 $1,000.00 $0.00 $1,000.00 $1,000.00 $1,000.00 10-100-480165 Animal S Donations $21,000.00 $102,325.53 $2,373.14 $104,698.67 $83,698.67 $83,698.67 10-100-481055 Street Repair-Solid Waste Cntr $351,788.00 $292,145.76 $57,907.98 $350,053.74 ($1,734.26)($1,734.26) 10-100-481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $383,616.57 $407,314.86 $60,281.12 $467,595.98 $83,979.41 $83,979.41 Other Operating Revenues 10-100-480010 Citizen Participation $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480011 Police Evidence Funds $0.00 $58,569.67 $0.00 $58,569.67 $58,569.67 $58,569.67 10-100-481070 Miscellaneous $82,921.21 $48,722.35 $15,836.11 $64,558.46 ($18,362.75)($18,362.75) 10-100-481072 TIF Prof Svcs Deposit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481074 Revenue Share - Purchasing Card $17,000.00 $12,534.83 $3,020.44 $15,555.27 ($1,444.73)($1,444.73) 10-100-481077 Insurance Claims $44,360.36 $57,518.32 $5,559.37 $63,077.69 $18,717.33 $18,717.33 10-100-481078 Cafeteria Refunds $20,000.00 $1,062.50 $20,000.00 $21,062.50 $1,062.50 $1,062.50 $164,281.57 $178,407.67 $44,415.93 $222,823.60 $58,542.03 $58,542.03Interest Income 10-100-470010 Interest $170,000.00 $193,010.90 $47,723.83 $240,734.73 $70,734.73 $70,734.73 $170,000.00 $193,010.90 $47,723.83 $240,734.73 $70,734.73 $70,734.73Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $197,742.06 $55,000.00 $252,742.06 $197,742.06 $197,742.06 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $197,742.06 $55,000.00 $252,742.06 $197,742.06 $197,742.06Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $26,428.76 $2,585.85 $29,014.61 $2,614.61 $2,614.61 10-100-490355 Transfer from CIT 'G'$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490500 Transfer from Public Safety Tax $480,031.67 $480,031.67 $0.00 $480,031.67 $0.00 $0.00 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $506,431.67 $506,460.43 $2,585.85 $509,046.28 $2,614.61 $2,614.61 $40,290,234.28 $30,421,251.80 $11,331,325.12 $41,752,576.92 $1,462,342.64 $1,462,342.64