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-03 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending February 28, 2022Data as of March 8, 2022FY 2022 YTD Actual Projected Over/DescriptionBudgetAs of 3/8/22(Under) BudgetSales Tax and Use Tax$12,521,475.39 $3,350,008.32 $284,645.44Intergovernmental Taxes$2,512,000.00 $317,074.79 $17,167.06Other Taxes$96,000.00 $21,631.84($1,374.92)Franchise & Utility Tax$6,450,000.00 $1,501,303.38($31,106.65)Property Taxes$5,709,659.76 $5,616,530.17 $159,733.90Intergovernmental$0.00 $0.00 $0.00Charges for Services$3,000,478.08 $2,031,734.02 $4,245.43Fees, Licenses, & Permits$1,066,437.50 $272,624.48($25,290.20)Fines & Forfeitures$580,000.00 $138,510.20($36,384.86)Contributions/Donations$383,616.57 $53,107.81 $4,499.88Other Operating Revenues$153,809.60 $46,342.62 $16,720.84Interest Income$170,000.00 $34,124.67 $18,698.49Other Non Operating Revenue$55,000.00 $130,108.07 $130,108.07Operating Transfers In$26,400.00$8,564.78$2,214.67Totals$32,724,876.90 $13,521,665.15 $543,877.14 FY2022 Revenue Model Report (Detail)Remaining For the Period Ending February 28, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 3/8/22 As of 3/8/22 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $12,521,475.39 $3,350,008.32 $9,456,112.51 $12,806,120.83 $284,645.44 $284,645.44 10‐100‐400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $3,350,008.32 $9,456,112.51 $12,806,120.83 $284,645.44 $284,645.44 Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $612,000.00 $96,895.34 $518,167.11 $615,062.45 $3,062.45 $3,062.45 10‐100‐403010 Gasoline Tax $1,250,000.00 $220,179.45 $1,043,925.16 $1,264,104.61 $14,104.61 $14,104.61 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 $317,074.79 $2,212,092.27 $2,529,167.06 $17,167.06 $17,167.06 Other Taxes 10‐100‐403020 Cig Tax $96,000.00 $21,631.84 $72,993.24 $94,625.08 ($1,374.92)($1,374.92) $96,000.00 $21,631.84 $72,993.24 $94,625.08 ($1,374.92)($1,374.92) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $3,900,000.00 $798,927.26 $3,113,410.89 $3,912,338.15 $12,338.15 $12,338.15 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 $347,183.52 $511,249.81 $858,433.33 $58,433.33 $58,433.33 10‐100‐410052 Telephone/Cell Utility $1,450,000.00 $285,968.60 $1,068,561.11 $1,354,529.71 ($95,470.29)($95,470.29) 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 $69,224.00 $224,368.15 $293,592.15 ($6,407.85)($6,407.85) $6,450,000.00 $1,501,303.38 $4,917,589.97 $6,418,893.35 ($31,106.65)($31,106.65) Property Taxes 10‐100‐420010 Current Property Tax $4,985,000.00 $4,936,994.39 $126,532.93 $5,063,527.32 $78,527.32 $78,527.32 10‐100‐420020 Del Property Tax $60,000.00 $45,148.39 $44,543.03 $89,691.42 $29,691.42 $29,691.42 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 $11,225.09 $19,372.30 $30,597.39 $3,597.39 $3,597.39 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 $498,447.88 $22,450.29 $520,898.17 $20,898.17 $20,898.17 10‐100‐420080 Special Tax Rev $66,000.00 $38,070.61 $39,964.94 $78,035.55 $12,035.55 $12,035.55 $5,709,659.76 $5,616,530.17 $252,863.49 $5,869,393.66 $159,733.90 $159,733.90 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 $10,882.50 $23,353.80 $34,236.30 ($1,763.70)($1,763.70) 10‐100‐440910 Fuel Charge ‐ backs $13,000.00 $3,915.58 $9,974.84 $13,890.42 $890.42 $890.42 10‐100‐440920 Parts Charge backs $242,732.58 $88,596.43 $169,519.67 $258,116.10 $15,383.52 $15,383.52 10‐100‐440930 Labor Charge backs $273,719.72 $78,416.94 $190,446.34 $268,863.28 ($4,856.44)($4,856.44) 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 $16,796.46 $165,423.75 $182,220.21 ($2,779.79)($2,779.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 $136,516.76 $278,996.24 $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 $5,000.00 $10,000.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 $2,031,734.02 $972,989.49 $3,004,723.51 $4,245.43 $4,245.43 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $72,000.00 $600.50 $70,779.94 $71,380.44 ($619.56)($619.56) 10‐100‐450020 Business Licenses $220,000.00 $96,158.95 $130,650.60 $226,809.55 $6,809.55 $6,809.55 10‐100‐450021 Home Occupation Permit $2,500.00 $385.00 $1,881.72 $2,266.72 ($233.28)($233.28) 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 $6,539.38 $4,000.00 $10,539.38 $2,539.38 $2,539.38 10‐100‐450045 Building Construct. Fees $421,687.50 $70,745.13 $308,271.12 $379,016.25 ($42,671.25)($42,671.25) 10‐100‐450050 Electrical Certificates $22,000.00 $23,085.00 $7,478.42 $30,563.42 $8,563.42 $8,563.42 10‐100‐450060 Electrical Permits $5,000.00 $2,381.01 $4,395.12 $6,776.13 $1,776.13 $1,776.13 10‐100‐450070 Plumbing Licenses $12,400.00 $10,200.00 $6,080.98 $16,280.98 $3,880.98 $3,880.98 10‐100‐450080 Plumbing Permits $10,000.00 $3,600.00 $8,197.39 $11,797.39 $1,797.39 $1,797.39 FY2022 Revenue Model Report (Detail)Remaining For the Period Ending February 28, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 3/8/22 As of 3/8/22 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $999.00 $1,497.76 $2,496.76 $496.76 $496.76 10‐100‐450091 Day Care Inspection Fees $5,500.00 $1,280.00 $4,095.37 $5,375.37 ($124.63)($124.63) 10‐100‐450092 Food Inspection Fees $88,000.00 $5,895.00 $82,600.77 $88,495.77 $495.77 $495.77 10‐100‐450100 Curb Cut Permits $1,000.00 $385.00 $682.52 $1,067.52 $67.52 $67.52 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,586.00 $5,014.71 $7,600.71 $700.71 $700.71 10‐100‐450130 Demolition Permits $3,000.00 $500.00 $2,292.91 $2,792.91 ($207.09)($207.09) 10‐100‐450150 Acc Rep Fees‐police $8,000.00 $2,575.00 $5,186.78 $7,761.78 ($238.22)($238.22) 10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $142.01 $981.46 $1,123.47 ($26.53)($26.53) 10‐100‐450170 Animal Redemption Fees $98,000.00 $27,471.50 $72,685.96 $100,157.46 $2,157.46 $2,157.46 10‐100‐450180 Animal Vaccinations Fees $5,200.00 $770.00 $3,619.89 $4,389.89 ($810.11)($810.11) 10‐100‐450185 Animal Cremation Fees $50,000.00 $9,521.00 $32,721.32 $42,242.32 ($7,757.68)($7,757.68) 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 $400.00 $455.00 ($345.00)($345.00) 10‐100‐450250 Rezoning Request $0.00 $1,520.00 $0.00 $1,520.00 $1,520.00 $1,520.00 10‐100‐450255 Planning & Zoning Review Fees $20,000.00 $3,660.00 $12,757.28 $16,417.28 ($3,582.72)($3,582.72) 10‐100‐450260 Non‐refundable Plans/spec $1,300.00 $570.00 $917.46 $1,487.46 $187.46 $187.46 $1,066,437.50 $272,624.48 $768,522.82 $1,041,147.30 ($25,290.20)($25,290.20) Fines & Forfeitures 10‐100‐460010 Court Cost $51,000.00 $10,530.61 $33,897.20 $44,427.81 ($6,572.19)($6,572.19) 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 $1,758.02 $5,657.13 $7,415.15 ($1,084.85)($1,084.85) 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,625.11 $4,498.62 $6,123.73 $123.73 $123.73 10‐100‐460030 Pol Fines‐traffic $490,000.00 $114,866.45 $341,968.98 $456,835.43 ($33,164.57)($33,164.57) 10‐100‐460090 Parking Fines $29,000.00 $11,613.00 $22,111.51 $33,724.51 $4,724.51 $4,724.51 10‐100‐460100 Bankcard Charges ($5,500.00)($1,882.99)($4,028.50)($5,911.49)($411.49)($411.49) $580,000.00 $138,510.20 $405,104.94 $543,615.14 ($36,384.86)($36,384.86) 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 $10,828.57 $0.00 $10,828.57 $0.00 $0.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 $12,325.25 $12,174.63 $24,499.88 $3,499.88 $3,499.88 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 $383,616.57 $53,107.81 $335,008.64 $388,116.45 $4,499.88 $4,499.88 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 $7,271.34 $59,238.24 $66,509.58 ($16,411.63)($16,411.63) 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 $3,104.75 $13,806.15 $16,910.90 ($89.10)($89.10) 10‐100‐481077 Insurance Claims $33,888.39 $35,966.53 $31,143.43 $67,109.96 $33,221.57 $33,221.57 10‐100‐481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $153,809.60 $46,342.62 $124,187.82 $170,530.44 $16,720.84 $16,720.84 Interest Income 10‐100‐470010 Interest $170,000.00 $34,124.67 $154,573.82 $188,698.49 $18,698.49 $18,698.49 $170,000.00 $34,124.67 $154,573.82 $188,698.49 $18,698.49 $18,698.49 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $55,000.00 $130,108.07 $55,000.00 $185,108.07 $130,108.07 $130,108.07 10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $130,108.07 $55,000.00 $185,108.07 $130,108.07 $130,108.07 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $8,564.78 $20,049.89 $28,614.67 $2,214.67 $2,214.67 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 $8,564.78 $20,049.89 $28,614.67 $2,214.67 $2,214.67 $32,724,876.90 $13,521,665.15 $19,747,088.89 $33,268,754.04 $543,877.14 $543,877.14