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-07 Meeting - Revenue Model Report
Revenue Model Report For the Period Ending June 30, 2022 Data as of July 13, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 7/13 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $7,670,113.63 $509,745.32 Intergovernmental Taxes $2,512,000.00 $1,580,489.04 $46,606.58 Other Taxes $96,000.00 $49,997.04 ($4,281.69) Franchise & Utility Tax $6,450,000.00 $3,504,088.14 $29,595.57 Property Taxes $5,709,659.76 $5,794,228.58 $172,199.51 Intergovernmental $0.00 $3,801,625.50 $3,801,625.50 Charges for Services $3,000,478.08 $2,531,164.94 $50,580.44 Fees, Licenses, & Permits $1,066,437.50 $721,203.95 ($40,051.66) Fines & Forfeitures $580,000.00 $279,326.83 ($138,459.43) Contributions/Donations $383,616.57 $313,125.83 $85,167.00 Other Operating Revenues $164,281.57 $99,151.68 ($7,196.53) Interest Income $170,000.00 $100,825.77 $48,832.32 Other Non Operating Revenue $55,000.00 $177,855.06 $177,855.06 Operating Transfers In $26,400.00 $19,202.87 $3,249.99 Totals $32,735,348.87 $26,642,398.86 $4,735,467.96 FY2022Revenue Model Report (Detail)Remaining For the Period Ending June 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 7/13 As of 7/13 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $7,670,113.63 $5,361,107.08 $13,031,220.71 $509,745.32 $509,745.32 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $7,670,113.63 $5,361,107.08 $13,031,220.71 $509,745.32 $509,745.32Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $306,481.64 $325,538.41 $632,020.05 $20,020.05 $20,020.05 10-100-403010 Gasoline Tax $1,250,000.00 $632,444.82 $652,579.13 $1,285,023.95 $35,023.95 $35,023.95 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 $1,580,489.04 $978,117.54 $2,558,606.58 $46,606.58 $46,606.58Other Taxes 10-100-403020 Cig Tax $96,000.00 $49,997.04 $41,721.27 $91,718.31 ($4,281.69)($4,281.69) $96,000.00 $49,997.04 $41,721.27 $91,718.31 ($4,281.69)($4,281.69)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $1,872,914.70 $2,104,798.98 $3,977,713.68 $77,713.68 $77,713.68 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 $864,709.68 $155,307.15 $1,020,016.83 $220,016.83 $220,016.83 10-100-410052 Telephone/Cell Utility $1,450,000.00 $624,429.95 $561,029.09 $1,185,459.04 ($264,540.96)($264,540.96) 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 $142,033.81 $154,372.20 $296,406.01 ($3,593.99)($3,593.99) $6,450,000.00 $3,504,088.14 $2,975,507.43 $6,479,595.57 $29,595.57 $29,595.57Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,029,203.94 $23,864.15 $5,053,068.09 $68,068.09 $68,068.09 10-100-420020 Del Property Tax $60,000.00 $54,731.64 $16,559.11 $71,290.75 $11,290.75 $11,290.75 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 $20,994.98 $10,840.97 $31,835.95 $4,835.95 $4,835.95 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 $504,996.89 $2,359.75 $507,356.64 $7,356.64 $7,356.64 10-100-420080 Special Tax Rev $66,000.00 $97,657.32 $34,006.70 $131,664.02 $65,664.02 $65,664.02 $5,709,659.76 $5,794,228.58 $87,630.69 $5,881,859.27 $172,199.51 $172,199.51Intergovernmental 10-100-430010 Federal Grant $0.00 $3,793,290.50 $0.00 $3,793,290.50 $3,793,290.50 $3,793,290.50 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 $0.00 $3,801,625.50 $0.00 $3,801,625.50 $3,801,625.50 $3,801,625.50Charges 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 $21,202.50 $11,642.83 $32,845.33 ($3,154.67)($3,154.67) 10-100-440910 Fuel Charge - backs $13,000.00 $10,628.42 $5,866.19 $16,494.61 $3,494.61 $3,494.61 10-100-440920 Parts Charge backs $242,732.58 $179,596.24 $89,305.40 $268,901.64 $26,169.06 $26,169.06 10-100-440930 Labor Charge backs $273,719.72 $170,915.41 $96,675.07 $267,590.48 ($6,129.24)($6,129.24) 10-100-481020 Cole Cty Animal Rescue $116,645.39 $58,322.70 $58,322.69 $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 $137,990.54 $77,156.11 $215,146.65 $30,146.65 $30,146.65 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 $276,014.88 $139,498.12 $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 $12,785.00 $5,000.00 $17,785.00 $2,785.00 $2,785.00 10-100-481100 Sale Of Grave Sites $3,000.00 $1,251.00 $818.18 $2,069.18 ($930.82)($930.82) 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,531,164.94 $519,893.58 $3,051,058.52 $50,580.44 $50,580.44Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $72,075.50 $2,194.27 $74,269.77 $2,269.77 $2,269.77 10-100-450020 Business Licenses $220,000.00 $165,488.68 $52,552.36 $218,041.04 ($1,958.96)($1,958.96) 10-100-450021 Home Occupation Permit $2,500.00 $1,045.00 $994.62 $2,039.62 ($460.38)($460.38) 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 $22,439.38 $0.00 $22,439.38 $14,439.38 $14,439.38 10-100-450045 Building Construct. Fees $421,687.50 $201,196.79 $168,240.96 $369,437.75 ($52,249.75)($52,249.75) 10-100-450050 Electrical Certificates $22,000.00 $26,034.00 $4,211.20 $30,245.20 $8,245.20 $8,245.20 10-100-450060 Electrical Permits $5,000.00 $4,938.43 $1,405.44 $6,343.87 $1,343.87 $1,343.87 10-100-450070 Plumbing Licenses $12,400.00 $13,410.00 $888.66 $14,298.66 $1,898.66 $1,898.66 10-100-450080 Plumbing Permits $10,000.00 $9,458.50 $2,320.49 $11,778.99 $1,778.99 $1,778.99 FY2022Revenue Model Report (Detail)Remaining For the Period Ending June 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 7/13 As of 7/13 TOTAL (Under) Budget of Formulas 10-100-450090 Other Lic & Permits $2,000.00 $1,765.00 $436.79 $2,201.79 $201.79 $201.79 10-100-450091 Day Care Inspection Fees $5,500.00 $2,810.00 $1,949.89 $4,759.89 ($740.11)($740.11) 10-100-450092 Food Inspection Fees $88,000.00 $90,808.50 ($2,188.65)$88,619.85 $619.85 $619.85 10-100-450100 Curb Cut Permits $1,000.00 $715.00 $362.14 $1,077.14 $77.14 $77.14 10-100-450110 Board Of Adj Fees $2,000.00 $2,800.00 $857.14 $3,657.14 $1,657.14 $1,657.14 10-100-450120 Sign Permits $6,900.00 $4,177.00 $2,833.27 $7,010.27 $110.27 $110.27 10-100-450130 Demolition Permits $3,000.00 $2,081.00 $1,288.06 $3,369.06 $369.06 $369.06 10-100-450150 Acc Rep Fees-police $8,000.00 $4,482.80 $2,721.90 $7,204.70 ($795.30)($795.30) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $223.37 $696.28 $919.65 ($230.35)($230.35) 10-100-450170 Animal Redemption Fees $98,000.00 $58,109.00 $39,348.04 $97,457.04 ($542.96)($542.96) 10-100-450180 Animal Vaccinations Fees $5,200.00 $2,625.00 $1,499.67 $4,124.67 ($1,075.33)($1,075.33) 10-100-450185 Animal Cremation Fees $50,000.00 $20,728.00 $15,854.19 $36,582.19 ($13,417.81)($13,417.81) 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 $228.57 $691.57 ($108.43)($108.43) 10-100-450250 Rezoning Request $0.00 $3,660.00 $0.00 $3,660.00 $3,660.00 $3,660.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $8,635.00 $6,110.52 $14,745.52 ($5,254.48)($5,254.48) 10-100-450260 Non-refundable Plans/spec $1,300.00 $1,035.00 $376.06 $1,411.06 $111.06 $111.06 $1,066,437.50 $721,203.95 $305,181.89 $1,026,385.84 ($40,051.66)($40,051.66)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $21,019.07 $13,958.29 $34,977.36 ($16,022.64)($16,022.64) 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 $3,503.14 $2,318.08 $5,821.22 ($2,678.78)($2,678.78) 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 $3,815.09 $1,643.68 $5,458.77 ($541.23)($541.23) 10-100-460030 Pol Fines-traffic $490,000.00 $229,159.99 $138,159.78 $367,319.77 ($122,680.23)($122,680.23) 10-100-460090 Parking Fines $29,000.00 $25,930.00 $8,160.71 $34,090.71 $5,090.71 $5,090.71 10-100-460100 Bankcard Charges ($5,500.00)($4,257.96)($2,026.81)($6,284.77)($784.77)($784.77) $580,000.00 $279,326.83 $162,213.74 $441,540.57 ($138,459.43)($138,459.43)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 $97,604.33 $6,547.67 $104,152.00 $83,152.00 $83,152.00 10-100-481055 Street Repair-Solid Waste Cntr $351,788.00 $202,677.93 $149,110.07 $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 $313,125.83 $155,657.74 $468,783.57 $85,167.00 $85,167.00 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 $44,402.05 $19,134.86 $63,536.91 ($19,384.30)($19,384.30) 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 $8,445.81 $7,228.20 $15,674.01 ($1,325.99)($1,325.99) 10-100-481077 Insurance Claims $44,360.36 $46,303.82 $11,570.31 $57,874.13 $13,513.77 $13,513.77 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $164,281.57 $99,151.68 $57,933.36 $157,085.04 ($7,196.53)($7,196.53)Interest Income 10-100-470010 Interest $170,000.00 $100,825.77 $118,006.55 $218,832.32 $48,832.32 $48,832.32 $170,000.00 $100,825.77 $118,006.55 $218,832.32 $48,832.32 $48,832.32Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $177,855.06 $55,000.00 $232,855.06 $177,855.06 $177,855.06 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $177,855.06 $55,000.00 $232,855.06 $177,855.06 $177,855.06Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $19,202.87 $10,447.12 $29,649.99 $3,249.99 $3,249.99 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 $19,202.87 $10,447.12 $29,649.99 $3,249.99 $3,249.99 $32,735,348.87 $26,642,398.86 $10,828,417.97 $37,470,816.83 $4,735,467.96 $4,735,467.96