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-02 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending January 31, 2022Data as of February 8, 2022FY 2022 YTD Actual Projected Over/DescriptionBudgetAs of 2/8/22(Under) BudgetSales Tax and Use Tax$12,521,475.39 $2,246,183.42 $267,951.73Intergovernmental Taxes$2,512,000.00 $155,674.60 $7,521.40Other Taxes$96,000.00 $14,235.44($1,789.66)Franchise & Utility Tax$6,450,000.00 $869,774.60($70,714.83)Property Taxes$5,709,659.76 $5,512,310.83 $187,783.65Intergovernmental$0.00 $0.00 $0.00Charges for Services$3,000,478.08 $1,914,009.78($32,515.71)Fees, Licenses, & Permits$1,066,437.50 $234,644.28($17,603.00)Fines & Forfeitures$580,000.00 $52,679.55($74,689.00)Contributions/Donations$372,788.00 $51,817.81 $14,234.87Other Operating Revenues$153,809.60 $25,551.73 $4,704.36Interest Income$170,000.00 $17,451.24 $10,289.17Other Non Operating Revenue$55,000.00 $127,227.08 $127,227.08Operating Transfers In$26,400.00$5,006.40$1,937.37Totals$32,714,048.33 $11,226,566.76 $424,337.44 FY2022 Revenue Model Report (Detail)Remaining For the Period Ending January 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 2/8/22 As of 2/8/22 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $12,521,475.39 $2,246,183.42 $10,543,243.70 $12,789,427.12 $267,951.73 $267,951.73 10‐100‐400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $2,246,183.42 $10,543,243.70 $12,789,427.12 $267,951.73 $267,951.73 Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $612,000.00 $51,067.58 $565,710.68 $616,778.26 $4,778.26 $4,778.26 10‐100‐403010 Gasoline Tax $1,250,000.00 $104,607.02 $1,148,136.12 $1,252,743.14 $2,743.14 $2,743.14 10‐100‐430080 Road & Bridge Tax $650,000.00 $0.00 $650,000.00 $650,000.00 $0.00 $0.00 $2,512,000.00 $155,674.60 $2,363,846.80 $2,519,521.40 $7,521.40 $7,521.40 Other Taxes 10‐100‐403020 Cig Tax $96,000.00 $14,235.44 $79,974.90 $94,210.34 ($1,789.66)($1,789.66) $96,000.00 $14,235.44 $79,974.90 $94,210.34 ($1,789.66)($1,789.66) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $3,900,000.00 $490,893.23 $3,398,064.56 $3,888,957.79 ($11,042.21)($11,042.21) 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 $180,756.46 $632,852.15 $813,608.61 $13,608.61 $13,608.61 10‐100‐410052 Telephone/Cell Utility $1,450,000.00 $198,070.19 $1,182,706.56 $1,380,776.75 ($69,223.25)($69,223.25) 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 $54.72 $295,887.30 $295,942.02 ($4,057.98)($4,057.98) $6,450,000.00 $869,774.60 $5,509,510.57 $6,379,285.17 ($70,714.83)($70,714.83) Property Taxes 10‐100‐420010 Current Property Tax $4,985,000.00 $4,886,289.13 $218,635.22 $5,104,924.35 $119,924.35 $119,924.35 10‐100‐420020 Del Property Tax $60,000.00 $43,602.26 $46,399.69 $90,001.95 $30,001.95 $30,001.95 10‐100‐420040 Fin Institution Tax $30,000.00 $0.00 $30,000.00 $30,000.00 $0.00 $0.00 10‐100‐420050 Prop Tax Int & Penalties $27,000.00 $10,081.73 $21,406.48 $31,488.21 $4,488.21 $4,488.21 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 $485,058.50 $28,083.31 $513,141.81 $13,141.81 $13,141.81 10‐100‐420080 Special Tax Rev $66,000.00 $32,879.93 $40,607.88 $73,487.81 $7,487.81 $7,487.81 $5,709,659.76 $5,512,310.83 $385,132.58 $5,897,443.41 $187,783.65 $187,783.65 Intergovernmental 10‐100‐430010 Federal Grant $0.00 $0.00 $0.00 $0.00 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Charges 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 $0.00 $25,000.00 $25,000.00 $0.00 $0.00 10‐100‐440210 Street Cuts $36,000.00 $7,752.50 $26,504.68 $34,257.18 ($1,742.82)($1,742.82) 10‐100‐440910 Fuel Charge ‐ backs $13,000.00 $2,584.13 $10,926.02 $13,510.15 $510.15 $510.15 10‐100‐440920 Parts Charge backs $242,732.58 $55,744.28 $186,418.21 $242,162.49 ($570.09)($570.09) 10‐100‐440930 Labor Charge backs $273,719.72 $38,668.94 $208,729.20 $247,398.14 ($26,321.58)($26,321.58) 10‐100‐481020 Cole Cty Animal Rescue $116,645.39 $29,161.35 $87,484.04 $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 $12,258.35 $170,978.86 $183,237.21 ($1,762.79)($1,762.79) 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 $101,642.23 $313,870.77 $415,513.00 ($2,051.39)($2,051.39) 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 $3,750.00 $11,250.00 $15,000.00 $0.00 $0.00 10‐100‐481100 Sale Of Grave Sites $3,000.00 $0.00 $2,181.82 $2,181.82 ($818.18)($818.18) 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 $231.00 $0.00 $231.00 $231.00 $231.00 $3,000,478.08 $1,914,009.78 $1,053,952.59 $2,967,962.37 ($32,515.71)($32,515.71) Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $72,000.00 $288.00 $71,016.99 $71,304.99 ($695.01)($695.01) 10‐100‐450020 Business Licenses $220,000.00 $90,131.04 $141,587.72 $231,718.76 $11,718.76 $11,718.76 10‐100‐450021 Home Occupation Permit $2,500.00 $220.00 $2,177.42 $2,397.42 ($102.58)($102.58) 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 $3,414.38 $4,000.00 $7,414.38 ($585.62)($585.62) 10‐100‐450045 Building Construct. Fees $421,687.50 $63,563.83 $316,209.41 $379,773.24 ($41,914.26)($41,914.26) 10‐100‐450050 Electrical Certificates $22,000.00 $21,765.00 $10,428.83 $32,193.83 $10,193.83 $10,193.83 10‐100‐450060 Electrical Permits $5,000.00 $1,418.11 $4,566.97 $5,985.08 $985.08 $985.08 10‐100‐450070 Plumbing Licenses $12,400.00 $9,990.00 $10,003.79 $19,993.79 $7,593.79 $7,593.79 10‐100‐450080 Plumbing Permits $10,000.00 $3,025.00 $8,774.74 $11,799.74 $1,799.74 $1,799.74 FY2022 Revenue Model Report (Detail)Remaining For the Period Ending January 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 2/8/22 As of 2/8/22 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $891.00 $1,572.17 $2,463.17 $463.17 $463.17 10‐100‐450091 Day Care Inspection Fees $5,500.00 $920.00 $4,421.34 $5,341.34 ($158.66)($158.66) 10‐100‐450092 Food Inspection Fees $88,000.00 $4,379.50 $83,125.69 $87,505.19 ($494.81)($494.81) 10‐100‐450100 Curb Cut Permits $1,000.00 $275.00 $693.20 $968.20 ($31.80)($31.80) 10‐100‐450110 Board Of Adj Fees $2,000.00 $800.00 $1,333.33 $2,133.33 $133.33 $133.33 10‐100‐450120 Sign Permits $6,900.00 $2,026.00 $5,506.02 $7,532.02 $632.02 $632.02 10‐100‐450130 Demolition Permits $3,000.00 $300.00 $2,388.44 $2,688.44 ($311.56)($311.56) 10‐100‐450150 Acc Rep Fees‐police $8,000.00 $1,995.00 $5,985.27 $7,980.27 ($19.73)($19.73) 10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $112.92 $989.11 $1,102.03 ($47.97)($47.97) 10‐100‐450170 Animal Redemption Fees $98,000.00 $16,812.50 $81,571.14 $98,383.64 $383.64 $383.64 10‐100‐450180 Animal Vaccinations Fees $5,200.00 $545.00 $4,108.29 $4,653.29 ($546.71)($546.71) 10‐100‐450185 Animal Cremation Fees $50,000.00 $6,542.00 $36,961.92 $43,503.92 ($6,496.08)($6,496.08) 10‐100‐450186 Animal Boarding Fees $0.00 $200.00 $0.00 $200.00 $200.00 $200.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 $55.00 $514.29 $569.29 ($230.71)($230.71) 10‐100‐450250 Rezoning Request $0.00 $1,420.00 $0.00 $1,420.00 $1,420.00 $1,420.00 10‐100‐450255 Planning & Zoning Review Fees $20,000.00 $3,090.00 $15,116.24 $18,206.24 ($1,793.76)($1,793.76) 10‐100‐450260 Non‐refundable Plans/spec $1,300.00 $465.00 $1,137.91 $1,602.91 $302.91 $302.91 $1,066,437.50 $234,644.28 $814,190.22 $1,048,834.50 ($17,603.00)($17,603.00) Fines & Forfeitures 10‐100‐460010 Court Cost $51,000.00 $2,687.90 $38,531.02 $41,218.92 ($9,781.08)($9,781.08) 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 $455.35 $6,426.87 $6,882.22 ($1,617.78)($1,617.78) 10‐100‐460020 Jail Cost Recovery $1,000.00 $0.00 $1,000.00 $1,000.00 $0.00 $0.00 10‐100‐460025 Alcohol Offense Cost Rec $6,000.00 $1,178.15 $5,069.51 $6,247.66 $247.66 $247.66 10‐100‐460030 Pol Fines‐traffic $490,000.00 $41,026.50 $381,537.75 $422,564.25 ($67,435.75)($67,435.75) 10‐100‐460090 Parking Fines $29,000.00 $8,308.00 $24,876.23 $33,184.23 $4,184.23 $4,184.23 10‐100‐460100 Bankcard Charges ($5,500.00)($976.35)($4,809.92)($5,786.27)($286.27)($286.27) $580,000.00 $52,679.55 $452,631.45 $505,311.00 ($74,689.00)($74,689.00) 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 $0.00 $10,828.57 $0.00 $10,828.57 $10,828.57 $10,828.57 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 $11,035.25 $12,371.05 $23,406.30 $2,406.30 $2,406.30 10‐100‐481055 Street Repair‐Solid Waste Cntr $351,788.00 $28,953.99 $322,834.01 $351,788.00 $0.00 $0.00 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $372,788.00 $51,817.81 $335,205.06 $387,022.87 $14,234.87 $14,234.87 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 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481070 Miscellaneous $82,921.21 $4,326.77 $65,490.22 $69,816.99 ($13,104.22)($13,104.22) 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 $2,113.96 $14,921.08 $17,035.04 $35.04 $35.04 10‐100‐481077 Insurance Claims $33,888.39 $19,111.00 $32,550.93 $51,661.93 $17,773.54 $17,773.54 10‐100‐481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $153,809.60 $25,551.73 $132,962.23 $158,513.96 $4,704.36 $4,704.36 Interest Income 10‐100‐470010 Interest $170,000.00 $17,451.24 $162,837.93 $180,289.17 $10,289.17 $10,289.17 $170,000.00 $17,451.24 $162,837.93 $180,289.17 $10,289.17 $10,289.17 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $55,000.00 $127,227.08 $55,000.00 $182,227.08 $127,227.08 $127,227.08 10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $127,227.08 $55,000.00 $182,227.08 $127,227.08 $127,227.08 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $5,006.40 $23,330.97 $28,337.37 $1,937.37 $1,937.37 10‐100‐490355 Transfer from CIT 'G' $0.00 $0.00 $0.00 $0.00 $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 $26,400.00 $5,006.40 $23,330.97 $28,337.37 $1,937.37 $1,937.37 $32,714,048.33 $11,226,566.76 $21,911,819.01 $33,138,385.77 $424,337.44 $424,337.44