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-04 Meeting - Revenue Model Report
Revenue Model Report For the Period Ending March 31, 2022 Data as of April 6, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 4/6 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $4,350,452.02 $367,798.56 Intergovernmental Taxes $2,512,000.00 $454,222.17 $16,343.66 Other Taxes $96,000.00 $28,596.64 ($784.65) Franchise & Utility Tax $6,450,000.00 $2,063,594.54 ($10,338.66) Property Taxes $5,709,659.76 $5,642,617.42 $103,245.24 Intergovernmental $0.00 $3,335.00 $3,335.00 Charges for Services $3,000,478.08 $2,176,671.14 $10,852.94 Fees, Licenses, & Permits $1,066,437.50 $363,495.49 ($23,491.07) Fines & Forfeitures $580,000.00 $174,230.69 ($82,510.35) Contributions/Donations $383,616.57 $189,139.30 $53,472.97 Other Operating Revenues $153,809.60 $59,023.14 $4,898.30 Interest Income $170,000.00 $78,041.57 $38,914.95 Other Non Operating Revenue $55,000.00 $130,108.07 $130,108.07 Operating Transfers In $26,400.00 $10,551.09 $2,482.95 Totals $32,724,876.90 $15,724,078.28 $614,327.91 FY2022Revenue Model Report (Detail)Remaining For the Period Ending March 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 4/6 As of 4/6 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $4,350,452.02 $8,538,821.93 $12,889,273.95 $367,798.56 $367,798.56 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $4,350,452.02 $8,538,821.93 $12,889,273.95 $367,798.56 $367,798.56Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $134,325.96 $478,721.71 $613,047.67 $1,047.67 $1,047.67 10-100-403010 Gasoline Tax $1,250,000.00 $319,896.21 $945,399.78 $1,265,295.99 $15,295.99 $15,295.99 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 $454,222.17 $2,074,121.49 $2,528,343.66 $16,343.66 $16,343.66Other Taxes 10-100-403020 Cig Tax $96,000.00 $28,596.64 $66,618.71 $95,215.35 ($784.65)($784.65) $96,000.00 $28,596.64 $66,618.71 $95,215.35 ($784.65)($784.65)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $1,098,736.32 $2,823,743.53 $3,922,479.85 $22,479.85 $22,479.85 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 $539,257.63 $375,867.03 $915,124.66 $115,124.66 $115,124.66 10-100-410052 Telephone/Cell Utility $1,450,000.00 $356,350.59 $953,870.39 $1,310,220.98 ($139,779.02)($139,779.02) 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 $69,250.00 $222,585.85 $291,835.85 ($8,164.15)($8,164.15) $6,450,000.00 $2,063,594.54 $4,376,066.80 $6,439,661.34 ($10,338.66)($10,338.66)Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $4,957,783.38 $80,441.76 $5,038,225.14 $53,225.14 $53,225.14 10-100-420020 Del Property Tax $60,000.00 $46,664.40 $23,778.05 $70,442.45 $10,442.45 $10,442.45 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 $12,457.94 $17,656.19 $30,114.13 $3,114.13 $3,114.13 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 $499,398.00 $9,015.41 $508,413.41 $8,413.41 $8,413.41 10-100-420080 Special Tax Rev $66,000.00 $39,669.89 $39,396.17 $79,066.06 $13,066.06 $13,066.06 $5,709,659.76 $5,642,617.42 $170,287.58 $5,812,905.00 $103,245.24 $103,245.24Intergovernmental 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 $14,727.50 $20,552.87 $35,280.37 ($719.63)($719.63) 10-100-440910 Fuel Charge - backs $13,000.00 $5,085.17 $8,852.34 $13,937.51 $937.51 $937.51 10-100-440920 Parts Charge backs $242,732.58 $89,340.89 $143,134.67 $232,475.56 ($10,257.02)($10,257.02) 10-100-440930 Labor Charge backs $273,719.72 $79,091.94 $164,480.24 $243,572.18 ($30,147.54)($30,147.54) 10-100-481020 Cole Cty Animal Rescue $116,645.39 $29,161.35 $87,484.04 $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 $118,758.00 $119,493.19 $238,251.19 $53,251.19 $53,251.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 $171,391.29 $244,121.71 $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 $6,250.00 $8,750.00 $15,000.00 $0.00 $0.00 10-100-481100 Sale Of Grave Sites $3,000.00 $417.00 $2,181.82 $2,598.82 ($401.18)($401.18) 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,176,671.14 $834,659.88 $3,011,331.02 $10,852.94 $10,852.94Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $27,428.00 $49,523.13 $76,951.13 $4,951.13 $4,951.13 10-100-450020 Business Licenses $220,000.00 $102,306.26 $121,274.08 $223,580.34 $3,580.34 $3,580.34 10-100-450021 Home Occupation Permit $2,500.00 $660.00 $1,774.19 $2,434.19 ($65.81)($65.81) 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 $8,564.38 $4,000.00 $12,564.38 $4,564.38 $4,564.38 10-100-450045 Building Construct. Fees $421,687.50 $104,612.09 $275,313.27 $379,925.36 ($41,762.14)($41,762.14) 10-100-450050 Electrical Certificates $22,000.00 $23,829.00 $5,932.05 $29,761.05 $7,761.05 $7,761.05 10-100-450060 Electrical Permits $5,000.00 $3,819.91 $4,250.00 $8,069.91 $3,069.91 $3,069.91 10-100-450070 Plumbing Licenses $12,400.00 $10,410.00 $3,595.90 $14,005.90 $1,605.90 $1,605.90 10-100-450080 Plumbing Permits $10,000.00 $4,575.00 $7,701.57 $12,276.57 $2,276.57 $2,276.57 FY2022Revenue Model Report (Detail)Remaining For the Period Ending March 31, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 4/6 As of 4/6 TOTAL (Under) Budget of Formulas 10-100-450090 Other Lic & Permits $2,000.00 $999.00 $660.01 $1,659.01 ($340.99)($340.99) 10-100-450091 Day Care Inspection Fees $5,500.00 $1,280.00 $3,585.67 $4,865.67 ($634.33)($634.33) 10-100-450092 Food Inspection Fees $88,000.00 $6,581.75 $82,221.05 $88,802.80 $802.80 $802.80 10-100-450100 Curb Cut Permits $1,000.00 $495.00 $575.73 $1,070.73 $70.73 $70.73 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,030.00 $4,321.13 $7,351.13 $451.13 $451.13 10-100-450130 Demolition Permits $3,000.00 $1,055.00 $2,239.14 $3,294.14 $294.14 $294.14 10-100-450150 Acc Rep Fees-police $8,000.00 $2,995.80 $4,556.82 $7,552.62 ($447.38)($447.38) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $178.80 $880.50 $1,059.30 ($90.70)($90.70) 10-100-450170 Animal Redemption Fees $98,000.00 $37,376.50 $64,287.63 $101,664.13 $3,664.13 $3,664.13 10-100-450180 Animal Vaccinations Fees $5,200.00 $1,245.00 $3,074.03 $4,319.03 ($880.97)($880.97) 10-100-450185 Animal Cremation Fees $50,000.00 $11,469.00 $27,805.66 $39,274.66 ($10,725.34)($10,725.34) 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 $6,275.00 $9,899.28 $16,174.28 ($3,825.72)($3,825.72) 10-100-450260 Non-refundable Plans/spec $1,300.00 $685.00 $646.76 $1,331.76 $31.76 $31.76 $1,066,437.50 $363,495.49 $679,450.94 $1,042,946.43 ($23,491.07)($23,491.07)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $13,114.91 $27,271.72 $40,386.63 ($10,613.37)($10,613.37) 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,190.75 $4,545.86 $6,736.61 ($1,763.39)($1,763.39) 10-100-460020 Jail Cost Recovery $1,000.00 $107.50 $0.00 $107.50 ($892.50)($892.50) 10-100-460025 Alcohol Offense Cost Rec $6,000.00 $2,012.49 $3,804.19 $5,816.68 ($183.32)($183.32) 10-100-460030 Pol Fines-traffic $490,000.00 $142,588.61 $273,268.54 $415,857.15 ($74,142.85)($74,142.85) 10-100-460090 Parking Fines $29,000.00 $16,533.00 $18,108.55 $34,641.55 $5,641.55 $5,641.55 10-100-460100 Bankcard Charges ($5,500.00)($2,316.57)($3,739.91)($6,056.48)($556.48)($556.48) $580,000.00 $174,230.69 $323,258.96 $497,489.65 ($82,510.35)($82,510.35)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 $10,828.57 $0.00 $10,828.57 $0.00 $0.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 $61,494.77 $11,978.20 $73,472.97 $52,472.97 $52,472.97 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 $189,139.30 $247,950.24 $437,089.54 $53,472.97 $53,472.97 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 $8,651.27 $46,733.51 $55,384.78 ($27,536.43)($27,536.43) 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 $4,368.05 $12,106.51 $16,474.56 ($525.44)($525.44) 10-100-481077 Insurance Claims $33,888.39 $46,003.82 $20,844.74 $66,848.56 $32,960.17 $32,960.17 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $153,809.60 $59,023.14 $99,684.76 $158,707.90 $4,898.30 $4,898.30Interest Income 10-100-470010 Interest $170,000.00 $78,041.57 $130,873.38 $208,914.95 $38,914.95 $38,914.95 $170,000.00 $78,041.57 $130,873.38 $208,914.95 $38,914.95 $38,914.95Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $130,108.07 $55,000.00 $185,108.07 $130,108.07 $130,108.07 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $130,108.07 $55,000.00 $185,108.07 $130,108.07 $130,108.07Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $10,551.09 $18,331.86 $28,882.95 $2,482.95 $2,482.95 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 $10,551.09 $18,331.86 $28,882.95 $2,482.95 $2,482.95 $32,724,876.90 $15,724,078.28 $17,615,126.53 $33,339,204.81 $614,327.91 $614,327.91