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-06 NO Meeting - Revenue Model Report
Revenue Model Report For the Period Ending May 31, 2022 Data as of June 13, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 6/13 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $6,560,139.29 $529,923.75 Intergovernmental Taxes $2,512,000.00 $1,416,834.86 $25,825.44 Other Taxes $96,000.00 $42,830.64 ($3,636.52) Franchise & Utility Tax $6,450,000.00 $3,105,445.45 $21,684.85 Property Taxes $5,709,659.76 $5,716,556.86 $112,929.42 Intergovernmental $0.00 $3,335.00 $3,335.00 Charges for Services $3,000,478.08 $2,391,855.85 $68,599.54 Fees, Licenses, & Permits $1,066,437.50 $635,757.58 ($28,630.70) Fines & Forfeitures $580,000.00 $242,624.31 ($126,700.97) Contributions/Donations $383,616.57 $224,124.86 $84,273.90 Other Operating Revenues $153,809.60 $77,694.76 ($11,915.95) Interest Income $170,000.00 $100,825.77 $48,832.32 Other Non Operating Revenue $55,000.00 $177,714.06 $177,714.06 Operating Transfers In $26,400.00 $16,205.06 $3,152.77 Totals $32,724,876.90 $20,711,944.35 $905,386.90 FY2022Revenue Model Report (Detail)Remaining For the Period Ending May 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 6/13 As of 6/13 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $6,560,139.29 $6,491,259.85 $13,051,399.14 $529,923.75 $529,923.75 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $6,560,139.29 $6,491,259.85 $13,051,399.14 $529,923.75 $529,923.75Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $252,302.21 $369,687.59 $621,989.80 $9,989.80 $9,989.80 10-100-403010 Gasoline Tax $1,250,000.00 $522,970.07 $751,302.99 $1,274,273.06 $24,273.06 $24,273.06 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,416,834.86 $1,120,990.58 $2,537,825.44 $25,825.44 $25,825.44Other Taxes 10-100-403020 Cig Tax $96,000.00 $42,830.64 $49,532.84 $92,363.48 ($3,636.52)($3,636.52) $96,000.00 $42,830.64 $49,532.84 $92,363.48 ($3,636.52)($3,636.52)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $1,623,961.15 $2,331,250.85 $3,955,212.00 $55,212.00 $55,212.00 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 $797,573.47 $201,223.23 $998,796.70 $198,796.70 $198,796.70 10-100-410052 Telephone/Cell Utility $1,450,000.00 $541,908.34 $679,356.38 $1,221,264.72 ($228,735.28)($228,735.28) 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,002.49 $154,408.94 $296,411.43 ($3,588.57)($3,588.57) $6,450,000.00 $3,105,445.45 $3,366,239.40 $6,471,684.85 $21,684.85 $21,684.85Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,014,642.20 $35,794.04 $5,050,436.24 $65,436.24 $65,436.24 10-100-420020 Del Property Tax $60,000.00 $52,846.12 $18,560.09 $71,406.21 $11,406.21 $11,406.21 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 $18,698.98 $12,923.29 $31,622.27 $4,622.27 $4,622.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 $503,290.51 $2,913.25 $506,203.76 $6,203.76 $6,203.76 10-100-420080 Special Tax Rev $66,000.00 $40,435.24 $35,841.65 $76,276.89 $10,276.89 $10,276.89 $5,709,659.76 $5,716,556.86 $106,032.32 $5,822,589.18 $112,929.42 $112,929.42Intergovernmental 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 $18,517.50 $14,405.22 $32,922.72 ($3,077.28)($3,077.28) 10-100-440910 Fuel Charge - backs $13,000.00 $8,792.81 $6,896.15 $15,688.96 $2,688.96 $2,688.96 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 $132,302.43 $115,238.76 $247,541.19 $62,541.19 $62,541.19 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 $241,140.35 $174,372.65 $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 $11,535.00 $6,250.00 $17,785.00 $2,785.00 $2,785.00 10-100-481100 Sale Of Grave Sites $3,000.00 $834.00 $1,363.64 $2,197.64 ($802.36)($802.36) 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,391,855.85 $677,221.77 $3,069,077.62 $68,599.54 $68,599.54Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $70,538.00 $6,341.94 $76,879.94 $4,879.94 $4,879.94 10-100-450020 Business Licenses $220,000.00 $126,933.34 $85,216.29 $212,149.63 ($7,850.37)($7,850.37) 10-100-450021 Home Occupation Permit $2,500.00 $990.00 $1,075.27 $2,065.27 ($434.73)($434.73) 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 $18,739.38 $0.00 $18,739.38 $10,739.38 $10,739.38 10-100-450045 Building Construct. Fees $421,687.50 $180,824.82 $207,698.52 $388,523.34 ($33,164.16)($33,164.16) 10-100-450050 Electrical Certificates $22,000.00 $25,056.00 $4,856.75 $29,912.75 $7,912.75 $7,912.75 10-100-450060 Electrical Permits $5,000.00 $4,329.60 $3,382.06 $7,711.66 $2,711.66 $2,711.66 10-100-450070 Plumbing Licenses $12,400.00 $12,978.00 $1,580.55 $14,558.55 $2,158.55 $2,158.55 10-100-450080 Plumbing Permits $10,000.00 $7,528.00 $2,837.79 $10,365.79 $365.79 $365.79 FY2022Revenue Model Report (Detail)Remaining For the Period Ending May 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 6/13 As of 6/13 TOTAL (Under) Budget of Formulas 10-100-450090 Other Lic & Permits $2,000.00 $1,657.00 $511.20 $2,168.20 $168.20 $168.20 10-100-450091 Day Care Inspection Fees $5,500.00 $2,330.00 $2,661.10 $4,991.10 ($508.90)($508.90) 10-100-450092 Food Inspection Fees $88,000.00 $90,054.25 ($2,323.25)$87,731.00 ($269.00)($269.00) 10-100-450100 Curb Cut Permits $1,000.00 $715.00 $394.17 $1,109.17 $109.17 $109.17 10-100-450110 Board Of Adj Fees $2,000.00 $1,200.00 $857.14 $2,057.14 $57.14 $57.14 10-100-450120 Sign Permits $6,900.00 $3,487.00 $3,111.35 $6,598.35 ($301.65)($301.65) 10-100-450130 Demolition Permits $3,000.00 $2,026.00 $1,426.19 $3,452.19 $452.19 $452.19 10-100-450150 Acc Rep Fees-police $8,000.00 $3,927.80 $3,401.96 $7,329.76 ($670.24)($670.24) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $212.39 $770.54 $982.93 ($167.07)($167.07) 10-100-450170 Animal Redemption Fees $98,000.00 $49,279.00 $48,170.38 $97,449.38 ($550.62)($550.62) 10-100-450180 Animal Vaccinations Fees $5,200.00 $2,295.00 $2,183.43 $4,478.43 ($721.57)($721.57) 10-100-450185 Animal Cremation Fees $50,000.00 $18,440.00 $19,506.34 $37,946.34 ($12,053.66)($12,053.66) 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 $327.00 $228.57 $555.57 ($244.43)($244.43) 10-100-450250 Rezoning Request $0.00 $2,870.00 $0.00 $2,870.00 $2,870.00 $2,870.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $8,105.00 $7,773.50 $15,878.50 ($4,121.50)($4,121.50) 10-100-450260 Non-refundable Plans/spec $1,300.00 $715.00 $387.41 $1,102.41 ($197.59)($197.59) $1,066,437.50 $635,757.58 $402,049.22 $1,037,806.80 ($28,630.70)($28,630.70)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $18,125.07 $17,915.91 $36,040.98 ($14,959.02)($14,959.02) 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,017.05 $2,974.64 $5,991.69 ($2,508.31)($2,508.31) 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,547.13 $2,136.99 $5,684.12 ($315.88)($315.88) 10-100-460030 Pol Fines-traffic $490,000.00 $197,910.40 $180,093.07 $378,003.47 ($111,996.53)($111,996.53) 10-100-460090 Parking Fines $29,000.00 $23,425.00 $10,321.04 $33,746.04 $4,746.04 $4,746.04 10-100-460100 Bankcard Charges ($5,500.00)($3,557.84)($2,766.93)($6,324.77)($824.77)($824.77) $580,000.00 $242,624.31 $210,674.72 $453,299.03 ($126,700.97)($126,700.97)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 $95,465.33 $7,793.57 $103,258.90 $82,258.90 $82,258.90 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 $224,124.86 $243,765.61 $467,890.47 $84,273.90 $84,273.90 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 $23,853.25 $21,759.81 $45,613.06 ($37,308.15)($37,308.15) 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 $7,537.69 $8,800.82 $16,338.51 ($661.49)($661.49) 10-100-481077 Insurance Claims $33,888.39 $46,303.82 $13,638.26 $59,942.08 $26,053.69 $26,053.69 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $153,809.60 $77,694.76 $64,198.89 $141,893.65 ($11,915.95)($11,915.95)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,714.06 $55,000.00 $232,714.06 $177,714.06 $177,714.06 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $177,714.06 $55,000.00 $232,714.06 $177,714.06 $177,714.06Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $16,205.06 $13,347.71 $29,552.77 $3,152.77 $3,152.77 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 $16,205.06 $13,347.71 $29,552.77 $3,152.77 $3,152.77 $32,724,876.90 $20,711,944.35 $12,918,319.45 $33,630,263.80 $905,386.90 $905,386.90