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-11 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending October 31, 2022 Data as of November 21, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 10/31 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $12,450,009.00 $1,114,572.36 Intergovernmental Taxes $2,512,000.00 $2,479,380.70 $129,922.37 Other Taxes $96,000.00 $79,973.36 ($7,779.39) Franchise & Utility Tax $6,450,000.00 $6,018,239.99 $66,703.10 Property Taxes $5,709,659.76 $5,854,399.38 $155,357.23 Intergovernmental $7,074,853.74 $8,335.00 $8,335.00 Charges for Services $3,000,478.08 $3,052,128.09 $88,693.34 Fees, Licenses, & Permits $1,066,437.50 $917,992.49 ($156,220.01) Fines & Forfeitures $580,000.00 $412,632.19 ($167,815.19) Contributions/Donations $383,616.57 $408,755.86 $83,047.27 Other Operating Revenues $164,281.57 $228,855.30 $64,573.73 Interest Income $170,000.00 $193,010.90 $70,734.73 Other Non Operating Revenue $55,000.00 $214,442.06 $159,442.06 Operating Transfers In $506,431.67 $508,951.32 $2,519.65 Totals $40,290,234.28 $32,827,105.64 $1,612,086.26 FY2022Revenue Model Report (Detail)Remaining For the Period Ending October 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 10/31 As of 10/31 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $12,449,236.47 $1,186,038.75 $13,635,275.22 $1,113,799.83 $1,113,799.83 10-100-400020 Sales Tax Interest $0.00 $772.53 $0.00 $772.53 $772.53 $772.53 $12,521,475.39 $12,450,009.00 $1,186,038.75 $13,636,047.75 $1,114,572.36 $1,114,572.36Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $584,038.23 $48,305.20 $632,343.43 $20,343.43 $20,343.43 10-100-403010 Gasoline Tax $1,250,000.00 $1,253,779.89 $114,236.47 $1,368,016.36 $118,016.36 $118,016.36 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,479,380.70 $162,541.67 $2,641,922.37 $129,922.37 $129,922.37Other Taxes 10-100-403020 Cig Tax $96,000.00 $79,973.36 $8,247.25 $88,220.61 ($7,779.39)($7,779.39) $96,000.00 $79,973.36 $8,247.25 $88,220.61 ($7,779.39)($7,779.39)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $3,719,281.23 $357,474.38 $4,076,755.61 $176,755.61 $176,755.61 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 $1,026,411.11 $32,340.81 $1,058,751.92 $258,751.92 $258,751.92 10-100-410052 Telephone/Cell Utility $1,450,000.00 $986,639.21 $108,609.99 $1,095,249.20 ($354,750.80)($354,750.80) 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 $285,908.44 $37.93 $285,946.37 ($14,053.63)($14,053.63) $6,450,000.00 $6,018,239.99 $498,463.11 $6,516,703.10 $66,703.10 $66,703.10Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,053,033.83 $0.00 $5,053,033.83 $68,033.83 $68,033.83 10-100-420020 Del Property Tax $60,000.00 $67,982.74 $4,285.14 $72,267.88 $12,267.88 $12,267.88 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 $30,741.27 $1,437.26 $32,178.53 $5,178.53 $5,178.53 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.66 ($39.78)$505,826.88 $5,826.88 $5,826.88 10-100-420080 Special Tax Rev $66,000.00 $110,131.07 $4,935.00 $115,066.07 $49,066.07 $49,066.07 $5,709,659.76 $5,854,399.38 $10,617.61 $5,865,016.99 $155,357.23 $155,357.23Intergovernmental 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 $31,348.50 $0.00 $31,348.50 ($4,651.50)($4,651.50) 10-100-440910 Fuel Charge - backs $13,000.00 $20,932.96 $568.55 $21,501.51 $8,501.51 $8,501.51 10-100-440920 Parts Charge backs $242,732.58 $255,288.44 $24,169.96 $279,458.40 $36,725.82 $36,725.82 10-100-440930 Labor Charge backs $273,719.72 $233,057.26 $24,304.82 $257,362.08 ($16,357.64)($16,357.64) 10-100-481020 Cole Cty Animal Rescue $116,645.39 $116,645.40 $0.00 $116,645.40 $0.01 $0.01 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 $24,000.00 ($12,000.00)$12,000.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $185,000.00 $248,595.63 $0.00 $248,595.63 $63,595.63 $63,595.63 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 $415,488.65 $0.00 $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 $17,785.00 $0.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 $20,839.00 $0.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 $3,052,128.09 $37,043.33 $3,089,171.42 $88,693.34 $88,693.34Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $74,359.67 $0.00 $74,359.67 $2,359.67 $2,359.67 10-100-450020 Business Licenses $220,000.00 $218,927.74 $0.00 $218,927.74 ($1,072.26)($1,072.26) 10-100-450021 Home Occupation Permit $2,500.00 $1,815.00 $0.00 $1,815.00 ($685.00)($685.00) 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 $18,170.00 ($7,775.00)$10,395.00 $2,395.00 $2,395.00 10-100-450045 Building Construct. Fees $421,687.50 $254,523.30 $0.00 $254,523.30 ($167,164.20)($167,164.20) 10-100-450050 Electrical Certificates $22,000.00 $28,277.00 $0.00 $28,277.00 $6,277.00 $6,277.00 10-100-450060 Electrical Permits $5,000.00 $7,432.97 $0.00 $7,432.97 $2,432.97 $2,432.97 10-100-450070 Plumbing Licenses $12,400.00 $16,695.00 $0.00 $16,695.00 $4,295.00 $4,295.00 10-100-450080 Plumbing Permits $10,000.00 $18,781.12 $0.00 $18,781.12 $8,781.12 $8,781.12 10-100-450090 Other Lic & Permits $2,000.00 $3,144.00 $0.00 $3,144.00 $1,144.00 $1,144.00 FY2022Revenue Model Report (Detail)Remaining For the Period Ending October 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 10/31 As of 10/31 TOTAL (Under) Budget of Formulas 10-100-450091 Day Care Inspection Fees $5,500.00 $4,560.00 $0.00 $4,560.00 ($940.00)($940.00) 10-100-450092 Food Inspection Fees $88,000.00 $93,447.58 $0.00 $93,447.58 $5,447.58 $5,447.58 10-100-450100 Curb Cut Permits $1,000.00 $1,650.00 $0.00 $1,650.00 $650.00 $650.00 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,701.00 $0.00 $6,701.00 ($199.00)($199.00) 10-100-450130 Demolition Permits $3,000.00 $3,709.00 $0.00 $3,709.00 $709.00 $709.00 10-100-450150 Acc Rep Fees-police $8,000.00 $7,239.80 $0.00 $7,239.80 ($760.20)($760.20) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $877.31 $0.00 $877.31 ($272.69)($272.69) 10-100-450170 Animal Redemption Fees $98,000.00 $92,794.00 $0.00 $92,794.00 ($5,206.00)($5,206.00) 10-100-450180 Animal Vaccinations Fees $5,200.00 $4,275.00 $0.00 $4,275.00 ($925.00)($925.00) 10-100-450185 Animal Cremation Fees $50,000.00 $36,435.00 $0.00 $36,435.00 ($13,565.00)($13,565.00) 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 $0.00 $463.00 ($337.00)($337.00) 10-100-450250 Rezoning Request $0.00 $3,460.00 $0.00 $3,460.00 $3,460.00 $3,460.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $15,475.00 $0.00 $15,475.00 ($4,525.00)($4,525.00) 10-100-450260 Non-refundable Plans/spec $1,300.00 $1,080.00 $0.00 $1,080.00 ($220.00)($220.00) $1,066,437.50 $917,992.49 ($7,775.00)$910,217.49 ($156,220.01)($156,220.01)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $31,797.15 $0.00 $31,797.15 ($19,202.85)($19,202.85) 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 $5,300.21 $0.00 $5,300.21 ($3,199.79)($3,199.79) 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,686.50 $0.00 $5,686.50 ($313.50)($313.50) 10-100-460030 Pol Fines-traffic $490,000.00 $337,540.81 $0.00 $337,540.81 ($152,459.19)($152,459.19) 10-100-460090 Parking Fines $29,000.00 $38,363.00 $0.00 $38,363.00 $9,363.00 $9,363.00 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 $412,632.19 ($447.38)$412,184.81 ($167,815.19)($167,815.19)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 $103,766.53 $0.00 $103,766.53 $82,766.53 $82,766.53 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 $408,755.86 $57,907.98 $466,663.84 $83,047.27 $83,047.27 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 $57,168.52 $0.00 $57,168.52 ($25,752.69)($25,752.69) 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 $14,236.76 $0.00 $14,236.76 ($2,763.24)($2,763.24) 10-100-481077 Insurance Claims $44,360.36 $68,781.72 $0.00 $68,781.72 $24,421.36 $24,421.36 10-100-481078 Cafeteria Refunds $20,000.00 $30,098.63 $0.00 $30,098.63 $10,098.63 $10,098.63 $164,281.57 $228,855.30 $0.00 $228,855.30 $64,573.73 $64,573.73Interest 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 $214,442.06 $0.00 $214,442.06 $159,442.06 $159,442.06 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $214,442.06 $0.00 $214,442.06 $159,442.06 $159,442.06Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $28,919.65 $0.00 $28,919.65 $2,519.65 $2,519.65 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 $508,951.32 $0.00 $508,951.32 $2,519.65 $2,519.65 $40,290,234.28 $32,827,105.64 $9,075,214.90 $41,902,320.54 $1,612,086.26 $1,612,086.26