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-09 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending August 30, 2022 Data as of September 15, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 9/15 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $10,185,312.84 $838,496.03 Intergovernmental Taxes $2,512,000.00 $1,920,487.11 $54,183.53 Other Taxes $96,000.00 $65,587.76 ($5,451.55) Franchise & Utility Tax $6,450,000.00 $4,692,563.61 $82,327.39 Property Taxes $5,709,659.76 $5,833,721.63 $162,337.33 Intergovernmental $7,074,853.74 $8,335.00 $8,335.00 Charges for Services $3,000,478.08 $2,860,400.46 $77,980.87 Fees, Licenses, & Permits $1,066,437.50 $843,431.41 ($85,190.12) Fines & Forfeitures $580,000.00 $339,376.01 ($162,774.36) Contributions/Donations $383,616.57 $316,229.87 $85,603.78 Other Operating Revenues $164,281.57 $173,889.42 $58,665.14 Interest Income $170,000.00 $168,307.00 $62,957.65 Other Non Operating Revenue $55,000.00 $177,932.06 $177,932.06 Operating Transfers In $506,431.67 $504,249.57 $2,704.66 Totals $40,290,234.28 $28,089,823.75 $1,358,107.42 FY2022Revenue Model Report (Detail)Remaining For the Period Ending August 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 9/15 As of 9/15 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $10,184,540.31 $3,174,658.58 $13,359,198.89 $837,723.50 $837,723.50 10-100-400020 Sales Tax Interest $0.00 $772.53 $0.00 $772.53 $772.53 $772.53 $12,521,475.39 $10,185,312.84 $3,174,658.58 $13,359,971.42 $838,496.03 $838,496.03Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $416,729.92 $204,864.55 $621,594.47 $9,594.47 $9,594.47 10-100-403010 Gasoline Tax $1,250,000.00 $862,194.61 $440,831.87 $1,303,026.48 $53,026.48 $53,026.48 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,920,487.11 $645,696.42 $2,566,183.53 $54,183.53 $54,183.53Other Taxes 10-100-403020 Cig Tax $96,000.00 $65,587.76 $24,960.69 $90,548.45 ($5,451.55)($5,451.55) $96,000.00 $65,587.76 $24,960.69 $90,548.45 ($5,451.55)($5,451.55)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $2,729,857.97 $1,334,133.10 $4,063,991.07 $163,991.07 $163,991.07 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 $947,771.37 $90,840.15 $1,038,611.52 $238,611.52 $238,611.52 10-100-410052 Telephone/Cell Utility $1,450,000.00 $797,476.94 $336,142.59 $1,133,619.53 ($316,380.47)($316,380.47) 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 $217,457.33 $78,647.93 $296,105.26 ($3,894.74)($3,894.74) $6,450,000.00 $4,692,563.61 $1,839,763.78 $6,532,327.39 $82,327.39 $82,327.39Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,043,996.30 $9,084.57 $5,053,080.87 $68,080.87 $68,080.87 10-100-420020 Del Property Tax $60,000.00 $62,926.15 $7,120.56 $70,046.71 $10,046.71 $10,046.71 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 $26,747.51 $4,424.76 $31,172.27 $4,172.27 $4,172.27 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,645.71 $173.15 $505,818.86 $5,818.86 $5,818.86 10-100-420080 Special Tax Rev $66,000.00 $107,762.15 $17,472.42 $125,234.57 $59,234.57 $59,234.57 $5,709,659.76 $5,833,721.63 $38,275.46 $5,871,997.09 $162,337.33 $162,337.33Intergovernmental 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 $26,827.50 $6,629.75 $33,457.25 ($2,542.75)($2,542.75) 10-100-440910 Fuel Charge - backs $13,000.00 $15,415.78 $3,618.20 $19,033.98 $6,033.98 $6,033.98 10-100-440920 Parts Charge backs $242,732.58 $226,882.64 $40,171.45 $267,054.09 $24,321.51 $24,321.51 10-100-440930 Labor Charge backs $273,719.72 $212,614.46 $46,268.81 $258,883.27 ($14,836.45)($14,836.45) 10-100-481020 Cole Cty Animal Rescue $116,645.39 $87,484.05 $29,161.34 $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 $240,608.19 $9,078.15 $249,686.34 $64,686.34 $64,686.34 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 $345,739.59 $69,749.06 $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 $15,285.00 $2,500.00 $17,785.00 $2,785.00 $2,785.00 10-100-481100 Sale Of Grave Sites $3,000.00 $2,085.00 $272.73 $2,357.73 ($642.27)($642.27) 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,860,400.46 $218,058.49 $3,078,458.95 $77,980.87 $77,980.87Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $72,765.92 $401.46 $73,167.38 $1,167.38 $1,167.38 10-100-450020 Business Licenses $220,000.00 $212,120.70 $10,559.79 $222,680.49 $2,680.49 $2,680.49 10-100-450021 Home Occupation Permit $2,500.00 $1,595.00 $403.23 $1,998.23 ($501.77)($501.77) 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 $19,839.38 $0.00 $19,839.38 $11,839.38 $11,839.38 10-100-450045 Building Construct. Fees $421,687.50 $232,298.13 $89,136.83 $321,434.96 ($100,252.54)($100,252.54) 10-100-450050 Electrical Certificates $22,000.00 $27,803.00 $2,404.96 $30,207.96 $8,207.96 $8,207.96 10-100-450060 Electrical Permits $5,000.00 $6,802.97 $514.84 $7,317.81 $2,317.81 $2,317.81 10-100-450070 Plumbing Licenses $12,400.00 $15,879.00 $444.33 $16,323.33 $3,923.33 $3,923.33 10-100-450080 Plumbing Permits $10,000.00 $14,755.12 $1,307.67 $16,062.79 $6,062.79 $6,062.79 10-100-450090 Other Lic & Permits $2,000.00 $1,820.00 $214.26 $2,034.26 $34.26 $34.26 FY2022Revenue Model Report (Detail)Remaining For the Period Ending August 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 9/15 As of 9/15 TOTAL (Under) Budget of Formulas 10-100-450091 Day Care Inspection Fees $5,500.00 $3,270.00 $1,108.30 $4,378.30 ($1,121.70)($1,121.70) 10-100-450092 Food Inspection Fees $88,000.00 $91,529.00 ($1,815.52)$89,713.48 $1,713.48 $1,713.48 10-100-450100 Curb Cut Permits $1,000.00 $990.00 $287.38 $1,277.38 $277.38 $277.38 10-100-450110 Board Of Adj Fees $2,000.00 $2,900.00 $666.67 $3,566.67 $1,566.67 $1,566.67 10-100-450120 Sign Permits $6,900.00 $6,183.00 $1,277.30 $7,460.30 $560.30 $560.30 10-100-450130 Demolition Permits $3,000.00 $3,309.00 $559.47 $3,868.47 $868.47 $868.47 10-100-450150 Acc Rep Fees-police $8,000.00 $5,824.80 $1,438.49 $7,263.29 ($736.71)($736.71) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $248.39 $506.50 $754.89 ($395.11)($395.11) 10-100-450170 Animal Redemption Fees $98,000.00 $76,214.00 $17,854.13 $94,068.13 ($3,931.87)($3,931.87) 10-100-450180 Animal Vaccinations Fees $5,200.00 $3,475.00 $580.33 $4,055.33 ($1,144.67)($1,144.67) 10-100-450185 Animal Cremation Fees $50,000.00 $26,506.00 $6,067.33 $32,573.33 ($17,426.67)($17,426.67) 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 $114.29 $577.29 ($222.71)($222.71) 10-100-450250 Rezoning Request $0.00 $3,960.00 $0.00 $3,960.00 $3,960.00 $3,960.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $11,845.00 $3,437.05 $15,282.05 ($4,717.95)($4,717.95) 10-100-450260 Non-refundable Plans/spec $1,300.00 $1,035.00 $346.88 $1,381.88 $81.88 $81.88 $1,066,437.50 $843,431.41 $137,815.97 $981,247.38 ($85,190.12)($85,190.12)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $25,864.05 $6,808.77 $32,672.82 ($18,327.18)($18,327.18) 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 $4,308.37 $1,122.38 $5,430.75 ($3,069.25)($3,069.25) 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 $4,228.50 $581.81 $4,810.31 ($1,189.69)($1,189.69) 10-100-460030 Pol Fines-traffic $490,000.00 $278,374.12 $65,490.11 $343,864.23 ($146,135.77)($146,135.77) 10-100-460090 Parking Fines $29,000.00 $32,148.00 $4,742.03 $36,890.03 $7,890.03 $7,890.03 10-100-460100 Bankcard Charges ($5,500.00)($5,704.53)($895.49)($6,600.02)($1,100.02)($1,100.02) $580,000.00 $339,376.01 $77,849.63 $417,225.64 ($162,774.36)($162,774.36)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 $100,708.37 $3,880.41 $104,588.78 $83,588.78 $83,588.78 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 $316,229.87 $152,990.48 $469,220.35 $85,603.78 $85,603.78 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 $47,472.54 $15,836.11 $63,308.65 ($19,612.56)($19,612.56) 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 $11,342.64 $4,212.60 $15,555.24 ($1,444.76)($1,444.76) 10-100-481077 Insurance Claims $44,360.36 $55,973.32 $9,008.58 $64,981.90 $20,621.54 $20,621.54 10-100-481078 Cafeteria Refunds $20,000.00 $531.25 $20,000.00 $20,531.25 $531.25 $531.25 $164,281.57 $173,889.42 $49,057.29 $222,946.71 $58,665.14 $58,665.14Interest Income 10-100-470010 Interest $170,000.00 $168,307.00 $64,650.65 $232,957.65 $62,957.65 $62,957.65 $170,000.00 $168,307.00 $64,650.65 $232,957.65 $62,957.65 $62,957.65Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $177,932.06 $55,000.00 $232,932.06 $177,932.06 $177,932.06 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $177,932.06 $55,000.00 $232,932.06 $177,932.06 $177,932.06Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $24,217.90 $4,886.76 $29,104.66 $2,704.66 $2,704.66 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 $504,249.57 $4,886.76 $509,136.33 $2,704.66 $2,704.66 $40,290,234.28 $28,089,823.75 $13,558,517.95 $41,648,341.70 $1,358,107.42 $1,358,107.42