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-08 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending July 31, 2022 Data as of August 17, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 8/17 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $8,921,151.58 $802,486.02 Intergovernmental Taxes $2,512,000.00 $1,753,946.29 $54,197.20 Other Taxes $96,000.00 $58,120.56 ($5,338.40) Franchise & Utility Tax $6,450,000.00 $3,977,082.66 $34,805.33 Property Taxes $5,709,659.76 $5,809,996.63 $174,640.77 Intergovernmental $4,990,917.60 $8,335.00 $8,335.00 Charges for Services $3,000,478.08 $2,694,395.39 $69,905.55 Fees, Licenses, & Permits $1,066,437.50 $792,338.08 ($57,671.83) Fines & Forfeitures $580,000.00 $307,897.40 ($152,399.21) Contributions/Donations $383,616.57 $314,970.83 $86,141.43 Other Operating Revenues $164,281.57 $161,366.54 $51,693.85 Interest Income $170,000.00 $168,307.00 $62,957.65 Other Non Operating Revenue $55,000.00 $177,855.06 $177,855.06 Operating Transfers In $388,497.37 $384,069.56 $3,084.76 Totals $38,088,363.84 $25,529,832.58 $1,310,693.19 FY2022Revenue Model Report (Detail)Remaining For the Period Ending July 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/17 As of 8/17 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $8,921,151.58 $4,402,809.83 $13,323,961.41 $802,486.02 $802,486.02 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $8,921,151.58 $4,402,809.83 $13,323,961.41 $802,486.02 $802,486.02Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $363,248.23 $264,101.39 $627,349.62 $15,349.62 $15,349.62 10-100-403010 Gasoline Tax $1,250,000.00 $749,135.48 $548,149.52 $1,297,285.00 $47,285.00 $47,285.00 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,753,946.29 $812,250.91 $2,566,197.20 $54,197.20 $54,197.20Other Taxes 10-100-403020 Cig Tax $96,000.00 $58,120.56 $32,541.04 $90,661.60 ($5,338.40)($5,338.40) $96,000.00 $58,120.56 $32,541.04 $90,661.60 ($5,338.40)($5,338.40)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $2,214,500.93 $1,794,842.91 $4,009,343.84 $109,343.84 $109,343.84 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 $908,572.96 $121,099.88 $1,029,672.84 $229,672.84 $229,672.84 10-100-410052 Telephone/Cell Utility $1,450,000.00 $711,948.93 $437,443.97 $1,149,392.90 ($300,607.10)($300,607.10) 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,059.84 $154,335.91 $296,395.75 ($3,604.25)($3,604.25) $6,450,000.00 $3,977,082.66 $2,507,722.67 $6,484,805.33 $34,805.33 $34,805.33Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,037,889.80 $16,457.84 $5,054,347.64 $69,347.64 $69,347.64 10-100-420020 Del Property Tax $60,000.00 $57,094.02 $14,396.86 $71,490.88 $11,490.88 $11,490.88 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 $22,805.41 $9,009.99 $31,815.40 $4,815.40 $4,815.40 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,141.89 $2,003.70 $507,145.59 $7,145.59 $7,145.59 10-100-420080 Special Tax Rev $66,000.00 $100,421.70 $32,435.52 $132,857.22 $66,857.22 $66,857.22 $5,709,659.76 $5,809,996.63 $74,303.90 $5,884,300.53 $174,640.77 $174,640.77Intergovernmental 10-100-430010 Federal Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430012 Federal Grant $4,990,917.60 $0.00 $4,990,917.60 $4,990,917.60 $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 $4,990,917.60 $8,335.00 $4,990,917.60 $4,999,252.60 $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 $0.00 $25,000.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $36,000.00 $23,317.50 $9,218.60 $32,536.10 ($3,463.90)($3,463.90) 10-100-440910 Fuel Charge - backs $13,000.00 $12,894.50 $4,799.10 $17,693.60 $4,693.60 $4,693.60 10-100-440920 Parts Charge backs $242,732.58 $197,098.54 $72,794.05 $269,892.59 $27,160.01 $27,160.01 10-100-440930 Labor Charge backs $273,719.72 $190,807.41 $74,417.46 $265,224.87 ($8,494.85)($8,494.85) 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 $193,350.08 $41,069.64 $234,419.72 $49,419.72 $49,419.72 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 $310,865.06 $104,623.59 $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 $14,035.00 $3,750.00 $17,785.00 $2,785.00 $2,785.00 10-100-481100 Sale Of Grave Sites $3,000.00 $2,085.00 $545.45 $2,630.45 ($369.55)($369.55) 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,694,395.39 $375,988.24 $3,070,383.63 $69,905.55 $69,905.55Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $72,260.50 $1,273.21 $73,533.71 $1,533.71 $1,533.71 10-100-450020 Business Licenses $220,000.00 $202,916.01 $21,773.53 $224,689.54 $4,689.54 $4,689.54 10-100-450021 Home Occupation Permit $2,500.00 $1,375.00 $591.40 $1,966.40 ($533.60)($533.60) 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 $16,139.38 $0.00 $16,139.38 $8,139.38 $8,139.38 10-100-450045 Building Construct. Fees $421,687.50 $218,402.21 $134,502.59 $352,904.80 ($68,782.70)($68,782.70) 10-100-450050 Electrical Certificates $22,000.00 $26,725.00 $3,041.32 $29,766.32 $7,766.32 $7,766.32 10-100-450060 Electrical Permits $5,000.00 $5,284.55 $1,050.50 $6,335.05 $1,335.05 $1,335.05 10-100-450070 Plumbing Licenses $12,400.00 $15,258.00 $444.33 $15,702.33 $3,302.33 $3,302.33 10-100-450080 Plumbing Permits $10,000.00 $10,300.50 $1,846.23 $12,146.73 $2,146.73 $2,146.73 10-100-450090 Other Lic & Permits $2,000.00 $1,820.00 $362.38 $2,182.38 $182.38 $182.38 FY2022Revenue Model Report (Detail)Remaining For the Period Ending July 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 8/17 As of 8/17 TOTAL (Under) Budget of Formulas 10-100-450091 Day Care Inspection Fees $5,500.00 $3,050.00 $1,274.25 $4,324.25 ($1,175.75)($1,175.75) 10-100-450092 Food Inspection Fees $88,000.00 $91,501.00 ($2,070.72)$89,430.28 $1,430.28 $1,430.28 10-100-450100 Curb Cut Permits $1,000.00 $825.00 $308.74 $1,133.74 $133.74 $133.74 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 $5,376.00 $2,028.04 $7,404.04 $504.04 $504.04 10-100-450130 Demolition Permits $3,000.00 $2,281.00 $833.61 $3,114.61 $114.61 $114.61 10-100-450150 Acc Rep Fees-police $8,000.00 $5,132.80 $2,116.28 $7,249.08 ($750.92)($750.92) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $229.13 $658.30 $887.43 ($262.57)($262.57) 10-100-450170 Animal Redemption Fees $98,000.00 $68,704.00 $27,828.43 $96,532.43 ($1,467.57)($1,467.57) 10-100-450180 Animal Vaccinations Fees $5,200.00 $3,000.00 $867.62 $3,867.62 ($1,332.38)($1,332.38) 10-100-450185 Animal Cremation Fees $50,000.00 $23,545.00 $11,618.58 $35,163.58 ($14,836.42)($14,836.42) 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 $171.43 $634.43 ($165.57)($165.57) 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 $9,855.00 $4,874.54 $14,729.54 ($5,270.46)($5,270.46) 10-100-450260 Non-refundable Plans/spec $1,300.00 $1,035.00 $366.33 $1,401.33 $101.33 $101.33 $1,066,437.50 $792,338.08 $216,427.59 $1,008,765.67 ($57,671.83)($57,671.83)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $23,299.22 $10,326.33 $33,625.55 ($17,374.45)($17,374.45) 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,879.90 $1,717.90 $5,597.80 ($2,902.20)($2,902.20) 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,094.47 $1,375.75 $5,470.22 ($529.78)($529.78) 10-100-460030 Pol Fines-traffic $490,000.00 $252,124.46 $101,210.33 $353,334.79 ($136,665.21)($136,665.21) 10-100-460090 Parking Fines $29,000.00 $29,365.00 $6,518.56 $35,883.56 $6,883.56 $6,883.56 10-100-460100 Bankcard Charges ($5,500.00)($5,023.15)($1,445.49)($6,468.64)($968.64)($968.64) $580,000.00 $307,897.40 $119,703.39 $427,600.79 ($152,399.21)($152,399.21)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 $99,449.33 $5,677.10 $105,126.43 $84,126.43 $84,126.43 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 $314,970.83 $154,787.17 $469,758.00 $86,141.43 $86,141.43 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 $46,560.60 $17,477.49 $64,038.09 ($18,883.12)($18,883.12) 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 $9,932.45 $5,669.81 $15,602.26 ($1,397.74)($1,397.74) 10-100-481077 Insurance Claims $44,360.36 $46,303.82 $11,461.58 $57,765.40 $13,405.04 $13,405.04 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $164,281.57 $161,366.54 $54,608.88 $215,975.42 $51,693.85 $51,693.85Interest 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,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 $21,972.19 $7,512.57 $29,484.76 $3,084.76 $3,084.76 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 $362,097.37 $362,097.37 $0.00 $362,097.37 $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 $388,497.37 $384,069.56 $7,512.57 $391,582.13 $3,084.76 $3,084.76 $38,088,363.84 $25,529,832.58 $13,869,224.45 $39,399,057.03 $1,310,693.19 $1,310,693.19