Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2024-03 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending February 29, 2024 Data as of March 19, 2024 FY 2024 YTD Actual Projected Over/ Description Budget As of 3/19/2024 (Under) Budget Sales Tax and Use Tax $14,042,669.68 $3,692,796.74 $187,646.09 Intergovernmental Taxes $2,830,000.00 $365,102.61 $19,595.43 Other Taxes $270,317.90 $128,095.78 $61,189.28 Franchise & Utility Tax $6,308,000.00 $1,548,095.52 $23,163.92 Property Taxes $5,858,659.76 $5,918,077.02 $253,635.84 Charges for Services $3,436,858.78 $2,396,655.63 ($29,706.54) Fees, Licenses, & Permits $857,500.00 $491,464.18 $218,373.35 Fines & Forfeitures $402,700.00 $158,703.73 $28,897.96 Contributions/Donations $373,215.05 $30,717.29 $0.03 Other Operating Revenues $92,000.00 $26,264.53 $3,693.90 Interest Income $200,000.00 $77,393.76 $51,490.00 Other Non Operating Revenue $55,000.00 $44,485.50 $0.00 Operating Transfers In $5,250,673.25 $5,223,562.48 $530.18 Totals $39,977,594.42 $20,101,414.77 $818,509.44 This schedule does not reflect variances in budget vs. actual for grants, as grants are typically reappropriated from year to year until the grant expires. This schedule does not reflect variances in budget vs. actual for contributions/donations that have designated reserve accounts. FY2024Revenue Model Report (Detail)Remaining For the Period Ending February 29, 2024 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 3/19/2024 As of 3/19/2024 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $14,042,669.68 $3,692,796.74 $10,537,519.03 $14,230,315.77 $187,646.09 $187,646.09 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14,042,669.68 $3,692,796.74 $10,537,519.03 $14,230,315.77 $187,646.09 $187,646.09Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $665,000.00 $103,997.08 $557,865.72 $661,862.80 ($3,137.20)($3,137.20) 10-100-403010 Gasoline Tax $1,490,000.00 $261,105.53 $1,251,627.11 $1,512,732.64 $22,732.64 $22,732.64 10-100-430080 Road & Bridge Tax $675,000.00 $0.00 $675,000.00 $675,000.00 $0.00 $0.00 $2,830,000.00 $365,102.61 $2,484,492.82 $2,849,595.43 $19,595.43 $19,595.43Other Taxes 10-100-403020 Cig Tax $70,000.00 $16,586.00 $53,172.98 $69,758.98 ($241.02)($241.02) 10-100-403030 Marijuana Tax $200,317.90 $111,509.78 $150,238.42 $261,748.20 $61,430.30 $61,430.30 $270,317.90 $128,095.78 $203,411.40 $331,507.18 $61,189.28 $61,189.28Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $4,100,000.00 $929,418.45 $3,270,259.14 $4,199,677.59 $99,677.59 $99,677.59 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 $1,100,000.00 $341,879.77 $698,619.08 $1,040,498.85 ($59,501.15)($59,501.15) 10-100-410052 Telephone/Cell Utility $850,000.00 $226,544.70 $624,695.45 $851,240.15 $1,240.15 $1,240.15 10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $258,000.00 $50,252.60 $189,494.73 $239,747.33 ($18,252.67)($18,252.67) $6,308,000.00 $1,548,095.52 $4,783,068.40 $6,331,163.92 $23,163.92 $23,163.92Property Taxes 10-100-420010 Current Property Tax $5,210,000.00 $5,296,753.10 $125,116.45 $5,421,869.55 $211,869.55 $211,869.55 10-100-420020 Del Property Tax $40,000.00 $25,005.81 $21,883.07 $46,888.88 $6,888.88 $6,888.88 10-100-420040 Fin Institution Tax $40,000.00 $38,442.47 $0.00 $38,442.47 ($1,557.53)($1,557.53) 10-100-420050 Prop Tax Int & Penalties $31,000.00 $22,588.22 $21,690.86 $44,279.08 $13,279.08 $13,279.08 10-100-420055 Surtax Receipts - County Reimb $41,659.76 $41,659.76 $0.00 $41,659.76 $0.00 $0.00 10-100-420060 Surtax Receipts $430,000.00 $447,953.51 $5,202.35 $453,155.86 $23,155.86 $23,155.86 10-100-420080 Special Tax Rev $66,000.00 $45,674.15 $20,325.85 $66,000.00 $0.00 $0.00 $5,858,659.76 $5,918,077.02 $194,218.58 $6,112,295.60 $253,635.84 $253,635.84Charges for Services 10-100-440010 Admin Charge Backs $1,991,217.11 $1,991,217.11 $0.00 $1,991,217.11 $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 $32,000.00 $10,140.00 $21,860.00 $32,000.00 $0.00 $0.00 10-100-440910 Fuel Charge - backs $22,000.00 $4,555.14 $16,788.84 $21,343.98 ($656.02)($656.02) 10-100-440920 Parts Charge backs $243,692.65 $63,896.46 $168,399.99 $232,296.45 ($11,396.20)($11,396.20) 10-100-440930 Labor Charge backs $274,802.35 $67,386.00 $185,254.61 $252,640.61 ($22,161.74)($22,161.74) 10-100-481020 Cole Cty Animal Rescue $133,418.99 $33,354.75 $100,064.25 $133,419.00 $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 $0.00 $12,000.00 $12,000.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $168,000.00 $23,042.35 $146,733.73 $169,776.08 $1,776.08 $1,776.08 10-100-481065 Parking Spot Maintenance $30,000.00 $30,000.00 $0.00 $30,000.00 $0.00 $0.00 10-100-481075 Cole Cty 911 Reimb $465,323.87 $156,612.82 $310,835.92 $467,448.74 $2,124.87 $2,124.87 10-100-481080 Sale Of Maps/GIS Data $0.00 $20.00 $0.00 $20.00 $20.00 $20.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 $2,919.00 $1,251.00 $2,304.47 $3,555.47 $636.47 $636.47 10-100-481105 TIF Administration Fee $21,484.81 $10,230.00 $11,254.81 $21,484.81 $0.00 $0.00 10-100-481110 Long & Short $0.00 ($50.00)$0.00 ($50.00)($50.00)($50.00) $3,436,858.78 $2,396,655.63 $1,010,496.61 $3,407,152.24 ($29,706.54)($29,706.54)Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $2,142.50 $70,834.87 $72,977.37 $977.37 $977.37 10-100-450020 Business Licenses $220,000.00 $95,229.56 $126,176.97 $221,406.53 $1,406.53 $1,406.53 10-100-450021 Home Occupation Permit $0.00 $0.00 $0.00 $0.00 $0.00 $0.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 $45,595.00 ($37,595.00)$8,000.00 $0.00 $0.00 10-100-450045 Building Construct. Fees $240,000.00 $256,547.96 $199,684.43 $456,232.39 $216,232.39 $216,232.39 10-100-450050 Electrical Certificates $22,000.00 $15,606.50 $6,205.49 $21,811.99 ($188.01)($188.01) 10-100-450060 Electrical Permits $7,500.00 $4,600.27 $5,464.97 $10,065.24 $2,565.24 $2,565.24 10-100-450070 Plumbing Licenses $12,400.00 $9,582.00 $2,828.96 $12,410.96 $10.96 $10.96 10-100-450080 Plumbing Permits $15,000.00 $4,572.98 $11,433.95 $16,006.93 $1,006.93 $1,006.93 10-100-450090 Other Lic & Permits $2,000.00 $1,256.00 $1,546.33 $2,802.33 $802.33 $802.33 10-100-450091 Day Care Inspection Fees $4,500.00 $2,860.00 $832.78 $3,692.78 ($807.22)($807.22) 10-100-450092 Food Inspection Fees $90,000.00 $5,160.16 $85,409.55 $90,569.71 $569.71 $569.71 10-100-450100 Curb Cut Permits $1,000.00 $275.00 $762.73 $1,037.73 $37.73 $37.73 10-100-450110 Board Of Adj Fees $1,600.00 $800.00 $1,240.45 $2,040.45 $440.45 $440.45 10-100-450120 Sign Permits $6,000.00 $2,165.00 $3,896.82 $6,061.82 $61.82 $61.82 10-100-450130 Demolition Permits $3,000.00 $965.00 $2,271.66 $3,236.66 $236.66 $236.66 FY2024Revenue Model Report (Detail)Remaining For the Period Ending February 29, 2024 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 3/19/2024 As of 3/19/2024 TOTAL (Under) Budget of Formulas 10-100-450150 Acc Rep Fees-police $7,000.00 $2,641.60 $4,722.39 $7,363.99 $363.99 $363.99 10-100-450160 Accrpt/blastg P-fire $1,000.00 $948.65 $785.16 $1,733.81 $733.81 $733.81 10-100-450170 Animal Redemption Fees $90,000.00 $26,885.00 $64,232.39 $91,117.39 $1,117.39 $1,117.39 10-100-450180 Animal Vaccinations Fees $4,500.00 $1,025.00 $3,159.46 $4,184.46 ($315.54)($315.54) 10-100-450185 Animal Cremation Fees $35,000.00 $5,254.00 $21,039.70 $26,293.70 ($8,706.30)($8,706.30) 10-100-450186 Animal Boarding Fees $0.00 $1,500.00 $0.00 $1,500.00 $1,500.00 $1,500.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 $0.00 $272.00 $0.00 $272.00 $272.00 $272.00 10-100-450250 Rezoning Request $0.00 $1,940.00 $0.00 $1,940.00 $1,940.00 $1,940.00 10-100-450255 Planning & Zoning Review Fees $15,000.00 $3,570.00 $9,475.10 $13,045.10 ($1,954.90)($1,954.90) 10-100-450260 Non-refundable Plans/spec $0.00 $70.00 $0.00 $70.00 $70.00 $70.00 $857,500.00 $491,464.18 $584,409.17 $1,075,873.35 $218,373.35 $218,373.35Fines & Forfeitures 10-100-460010 Court Cost $34,000.00 $12,185.71 $22,889.03 $35,074.74 $1,074.74 $1,074.74 10-100-460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460018 Inmate Security Fund $5,300.00 $2,035.00 $3,641.11 $5,676.11 $376.11 $376.11 10-100-460020 Jail Cost Recovery $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460025 Alcohol Offense Cost Rec $5,700.00 $1,198.00 $4,079.71 $5,277.71 ($422.29)($422.29) 10-100-460030 Pol Fines-traffic $330,000.00 $136,932.33 $224,095.98 $361,028.31 $31,028.31 $31,028.31 10-100-460090 Parking Fines $34,000.00 $7,901.00 $23,068.57 $30,969.57 ($3,030.43)($3,030.43) 10-100-460100 Bankcard Charges ($6,300.00)($1,548.31)($4,880.17)($6,428.48)($128.48)($128.48) $402,700.00 $158,703.73 $272,894.23 $431,597.96 $28,897.96 $28,897.96Contributions/Donations 10-100-480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480090 Police K-9 Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481055 Street Repair-Solid Waste Cntr $373,215.05 $30,717.29 $342,497.79 $373,215.08 $0.03 $0.03 $373,215.05 $30,717.29 $342,497.79 $373,215.08 $0.03 $0.03Other 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 $1,221.81 $0.00 $1,221.81 $1,221.81 $1,221.81 10-100-481070 Miscellaneous $40,000.00 $20,200.36 $25,204.68 $45,405.04 $5,405.04 $5,405.04 10-100-481072 TIF Prof Svcs Deposit $0.00 $251.25 $0.00 $251.25 $251.25 $251.25 10-100-481074 Revenue Share - Purchasing Card $12,000.00 $2,599.86 $9,519.09 $12,118.95 $118.95 $118.95 10-100-481077 Insurance Claims $20,000.00 $1,991.25 $14,705.60 $16,696.85 ($3,303.15)($3,303.15) 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $92,000.00 $26,264.53 $69,429.37 $95,693.90 $3,693.90 $3,693.90Interest Income 10-100-470010 Interest $200,000.00 $77,393.76 $174,096.24 $251,490.00 $51,490.00 $51,490.00 $200,000.00 $77,393.76 $174,096.24 $251,490.00 $51,490.00 $51,490.00Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $44,485.50 $10,514.50 $55,000.00 $0.00 $0.00 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $44,485.50 $10,514.50 $55,000.00 $0.00 $0.00Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $33,000.00 $5,889.23 $27,640.95 $33,530.18 $530.18 $530.18 10-100-490355 Transfer from CIT 'G'$1,113,169.00 $1,113,169.00 $0.00 $1,113,169.00 $0.00 $0.00 10-100-490500 Transfer from Public Safety Tax $3,851,304.25 $3,851,304.25 $0.00 $3,851,304.25 $0.00 $0.00 10-100-490600 Transfer from Parking Fund $253,200.00 $253,200.00 $0.00 $253,200.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 $5,250,673.25 $5,223,562.48 $27,640.95 $5,251,203.43 $530.18 $530.18 $39,977,594.42 $20,101,414.77 $20,694,689.09 $40,796,103.86 $818,509.44 $818,509.44