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-05 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending April 30, 2022 Data as of May 6, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 5/6 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $5,332,200.58 $501,499.36 Intergovernmental Taxes $2,512,000.00 $603,074.89 $16,967.91 Other Taxes $96,000.00 $36,153.04 ($1,988.45) Franchise & Utility Tax $6,450,000.00 $2,667,576.09 ($11,729.69) Property Taxes $5,709,659.76 $5,673,298.58 $98,754.32 Intergovernmental $0.00 $3,335.00 $3,335.00 Charges for Services $3,000,478.08 $2,344,124.79 $63,448.91 Fees, Licenses, & Permits $1,066,437.50 $458,244.48 ($15,559.46) Fines & Forfeitures $580,000.00 $211,348.81 ($116,892.40) Contributions/Donations $383,616.57 $220,005.14 $82,894.88 Other Operating Revenues $153,809.60 $74,698.28 ($7,333.26) Interest Income $170,000.00 $78,017.05 $38,890.43 Other Non Operating Revenue $55,000.00 $150,108.07 $150,108.07 Operating Transfers In $26,400.00 $13,218.27 $2,705.90 Totals $32,724,876.90 $17,865,403.07 $805,101.52 FY2022Revenue Model Report (Detail)Remaining For the Period Ending April 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 5/6 As of 5/6 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $5,332,200.58 $7,690,774.17 $13,022,974.75 $501,499.36 $501,499.36 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $5,332,200.58 $7,690,774.17 $13,022,974.75 $501,499.36 $501,499.36Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $197,118.75 $421,767.76 $618,886.51 $6,886.51 $6,886.51 10-100-403010 Gasoline Tax $1,250,000.00 $405,956.14 $854,125.26 $1,260,081.40 $10,081.40 $10,081.40 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 $603,074.89 $1,925,893.02 $2,528,967.91 $16,967.91 $16,967.91Other Taxes 10-100-403020 Cig Tax $96,000.00 $36,153.04 $57,858.51 $94,011.55 ($1,988.45)($1,988.45) $96,000.00 $36,153.04 $57,858.51 $94,011.55 ($1,988.45)($1,988.45)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $1,374,899.17 $2,551,666.80 $3,926,565.97 $26,565.97 $26,565.97 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 $692,670.11 $267,091.47 $959,761.58 $159,761.58 $159,761.58 10-100-410052 Telephone/Cell Utility $1,450,000.00 $458,034.00 $797,527.01 $1,255,561.01 ($194,438.99)($194,438.99) 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 $141,972.81 $154,408.94 $296,381.75 ($3,618.25)($3,618.25) $6,450,000.00 $2,667,576.09 $3,770,694.22 $6,438,270.31 ($11,729.69)($11,729.69)Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $4,982,855.34 $57,616.10 $5,040,471.44 $55,471.44 $55,471.44 10-100-420020 Del Property Tax $60,000.00 $49,153.98 $20,713.50 $69,867.48 $9,867.48 $9,867.48 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 $14,717.26 $15,480.94 $30,198.20 $3,198.20 $3,198.20 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 $500,258.30 $4,183.72 $504,442.02 $4,442.02 $4,442.02 10-100-420080 Special Tax Rev $66,000.00 $39,669.89 $37,121.25 $76,791.14 $10,791.14 $10,791.14 $5,709,659.76 $5,673,298.58 $135,115.50 $5,808,414.08 $98,754.32 $98,754.32Intergovernmental 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 $3,335.00 $0.00 $3,335.00 $3,335.00 $3,335.00 $0.00 $3,335.00 $0.00 $3,335.00 $3,335.00 $3,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 $0.00 $25,000.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $36,000.00 $16,407.50 $16,545.08 $32,952.58 ($3,047.42)($3,047.42) 10-100-440910 Fuel Charge - backs $13,000.00 $6,916.71 $7,827.96 $14,744.67 $1,744.67 $1,744.67 10-100-440920 Parts Charge backs $242,732.58 $134,940.23 $122,815.32 $257,755.55 $15,022.97 $15,022.97 10-100-440930 Labor Charge backs $273,719.72 $123,012.58 $141,948.35 $264,960.93 ($8,758.79)($8,758.79) 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 $127,894.25 $118,350.25 $246,244.50 $61,244.50 $61,244.50 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 $206,265.82 $209,247.18 $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 $7,500.00 $7,500.00 $15,000.00 $0.00 $0.00 10-100-481100 Sale Of Grave Sites $3,000.00 $417.00 $1,636.36 $2,053.36 ($946.64)($946.64) 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,344,124.79 $719,802.20 $3,063,926.99 $63,448.91 $63,448.91Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $59,710.50 $17,463.57 $77,174.07 $5,174.07 $5,174.07 10-100-450020 Business Licenses $220,000.00 $105,092.94 $111,348.02 $216,440.96 ($3,559.04)($3,559.04) 10-100-450021 Home Occupation Permit $2,500.00 $770.00 $1,397.85 $2,167.85 ($332.15)($332.15) 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 $14,989.38 $4,000.00 $18,989.38 $10,989.38 $10,989.38 10-100-450045 Building Construct. Fees $421,687.50 $142,285.38 $249,288.12 $391,573.50 ($30,114.00)($30,114.00) 10-100-450050 Electrical Certificates $22,000.00 $24,321.00 $5,514.23 $29,835.23 $7,835.23 $7,835.23 10-100-450060 Electrical Permits $5,000.00 $4,154.60 $3,899.65 $8,054.25 $3,054.25 $3,054.25 10-100-450070 Plumbing Licenses $12,400.00 $11,508.00 $2,481.90 $13,989.90 $1,589.90 $1,589.90 10-100-450080 Plumbing Permits $10,000.00 $5,627.00 $7,090.76 $12,717.76 $2,717.76 $2,717.76 FY2022Revenue Model Report (Detail)Remaining For the Period Ending April 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 5/6 As of 5/6 TOTAL (Under) Budget of Formulas 10-100-450090 Other Lic & Permits $2,000.00 $1,657.00 $585.60 $2,242.60 $242.60 $242.60 10-100-450091 Day Care Inspection Fees $5,500.00 $1,710.00 $3,324.89 $5,034.89 ($465.11)($465.11) 10-100-450092 Food Inspection Fees $88,000.00 $7,104.25 $81,490.02 $88,594.27 $594.27 $594.27 10-100-450100 Curb Cut Permits $1,000.00 $605.00 $500.97 $1,105.97 $105.97 $105.97 10-100-450110 Board Of Adj Fees $2,000.00 $800.00 $1,047.62 $1,847.62 ($152.38)($152.38) 10-100-450120 Sign Permits $6,900.00 $3,153.00 $3,476.80 $6,629.80 ($270.20)($270.20) 10-100-450130 Demolition Permits $3,000.00 $1,363.00 $1,489.46 $2,852.46 ($147.54)($147.54) 10-100-450150 Acc Rep Fees-police $8,000.00 $3,382.80 $3,961.18 $7,343.98 ($656.02)($656.02) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $196.63 $874.56 $1,071.19 ($78.81)($78.81) 10-100-450170 Animal Redemption Fees $98,000.00 $42,679.00 $57,559.76 $100,238.76 $2,238.76 $2,238.76 10-100-450180 Animal Vaccinations Fees $5,200.00 $1,670.00 $2,528.18 $4,198.18 ($1,001.82)($1,001.82) 10-100-450185 Animal Cremation Fees $50,000.00 $14,820.00 $23,340.04 $38,160.04 ($11,839.96)($11,839.96) 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 $285.71 $340.71 ($459.29)($459.29) 10-100-450250 Rezoning Request $0.00 $2,570.00 $0.00 $2,570.00 $2,570.00 $2,570.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $7,135.00 $9,120.57 $16,255.57 ($3,744.43)($3,744.43) 10-100-450260 Non-refundable Plans/spec $1,300.00 $685.00 $564.09 $1,249.09 ($50.91)($50.91) $1,066,437.50 $458,244.48 $592,633.56 $1,050,878.04 ($15,559.46)($15,559.46)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $15,842.01 $21,367.66 $37,209.67 ($13,790.33)($13,790.33) 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 $2,636.62 $3,553.21 $6,189.83 ($2,310.17)($2,310.17) 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 $2,686.32 $2,522.79 $5,209.11 ($790.89)($790.89) 10-100-460030 Pol Fines-traffic $490,000.00 $173,358.98 $214,541.94 $387,900.92 ($102,099.08)($102,099.08) 10-100-460090 Parking Fines $29,000.00 $19,810.00 $13,053.49 $32,863.49 $3,863.49 $3,863.49 10-100-460100 Bankcard Charges ($5,500.00)($3,142.62)($3,280.29)($6,422.91)($922.91)($922.91) $580,000.00 $211,348.81 $251,758.79 $463,107.60 ($116,892.40)($116,892.40)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,823.57 $0.00 $11,823.57 $995.00 $995.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 $91,365.61 $10,534.27 $101,899.88 $80,899.88 $80,899.88 10-100-481055 Street Repair-Solid Waste Cntr $351,788.00 $115,815.96 $235,972.04 $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 $220,005.14 $246,506.31 $466,511.45 $82,894.88 $82,894.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 $22,530.98 $23,512.85 $46,043.83 ($36,877.38)($36,877.38) 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 $6,163.48 $10,292.03 $16,455.51 ($544.49)($544.49) 10-100-481077 Insurance Claims $33,888.39 $46,003.82 $17,973.19 $63,977.01 $30,088.62 $30,088.62 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $153,809.60 $74,698.28 $71,778.06 $146,476.34 ($7,333.26)($7,333.26)Interest Income 10-100-470010 Interest $170,000.00 $78,017.05 $130,873.38 $208,890.43 $38,890.43 $38,890.43 $170,000.00 $78,017.05 $130,873.38 $208,890.43 $38,890.43 $38,890.43Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $150,108.07 $55,000.00 $205,108.07 $150,108.07 $150,108.07 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $150,108.07 $55,000.00 $205,108.07 $150,108.07 $150,108.07Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $13,218.27 $15,887.63 $29,105.90 $2,705.90 $2,705.90 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 $13,218.27 $15,887.63 $29,105.90 $2,705.90 $2,705.90 $32,724,876.90 $17,865,403.07 $15,664,575.35 $33,529,978.42 $805,101.52 $805,101.52