HomeMy Public PortalAbout2021-10 Meeting - Revenue ModelRe
v
e
n
u
e
Mo
d
e
l
Re
p
o
r
t
Fo
r
t
h
e
P
e
r
i
o
d
E
n
d
i
n
g
S
e
p
t
e
m
b
e
r
3
0
,
2
0
2
1
Da
t
a
a
s
o
f
O
c
t
o
b
e
r
7
,
2
0
2
1
FY
2
0
2
1
Y
T
D
A
c
t
u
a
l
P
r
o
j
e
c
t
e
d
O
v
e
r
/
De
s
c
r
i
p
t
i
o
n
Bu
d
g
e
t
As
o
f
1
0
/
7
/
2
1
(U
n
d
e
r
)
B
u
d
g
e
t
Sa
l
e
s
T
a
x
a
n
d
U
s
e
T
a
x
$1
2
,
0
5
2
,
1
9
6
.
4
8
$
1
0
,
5
7
5
,
0
5
4
.
3
0
$
4
8
6
,
4
3
4
.
8
3
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
T
a
x
e
s
$2
,
3
5
6
,
0
0
0
.
0
0
$
1
,
9
8
7
,
7
7
4
.
0
6
$
9
3
,
1
0
8
.
4
9
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
7
8
,
2
0
3
.
4
2
($
4
,
5
8
4
.
6
5
)
Fr
a
n
c
h
i
s
e
&
U
t
i
l
i
t
y
T
a
x
$6
,
8
2
5
,
0
0
0
.
0
0
$
5
,
0
8
7
,
2
5
8
.
2
5
($
6
5
4
,
7
4
0
.
9
8
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
7
9
9
,
0
7
3
.
6
8
$
2
5
6
,
4
6
4
.
8
0
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
4
,
7
5
3
,
7
9
3
.
8
6
$
4
,
7
4
8
,
6
2
3
.
8
6
Ch
a
r
g
e
s
f
o
r
S
e
r
v
i
c
e
s
$2
,
8
5
2
,
6
7
6
.
1
0
$
2
,
6
8
5
,
6
8
2
.
2
7
($
9
,
5
8
4
.
9
6
)
Fe
e
s
,
L
i
c
e
n
s
e
s
,
&
P
e
r
m
i
t
s
$9
5
2
,
6
5
0
.
0
0
$
9
8
9
,
3
5
3
.
9
3
$
8
0
,
7
1
3
.
4
3
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$6
0
7
,
9
0
0
.
0
0
$
4
4
3
,
1
8
5
.
9
0
($
1
1
4
,
3
6
6
.
4
2
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
7
4
,
8
4
9
.
4
3
$
3
2
5
,
2
9
7
.
1
8
$
9
,
6
0
0
.
0
4
Ot
h
e
r
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
s
$2
2
1
,
2
2
0
.
6
4
$
3
3
4
,
3
2
9
.
4
2
$
1
3
5
,
1
7
3
.
1
3
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
1
3
8
,
1
0
5
.
1
1
$
3
2
,
7
1
2
.
9
9
Ot
h
e
r
N
o
n
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
$3
1
2
,
7
6
1
.
0
0
$
9
3
,
8
9
2
.
1
3
$
1
,
1
3
1
.
1
3
Op
e
r
a
t
i
n
g
T
r
a
n
s
f
e
r
s
I
n
$1
,
6
2
5
,
9
9
5
.
0
0
$1
,
6
2
1
,
1
2
0
.
7
3
($
2
,
6
0
4
.
1
7
)
To
t
a
l
s
$3
3
,
9
6
7
,
8
1
7
.
9
3
$
3
4
,
9
1
2
,
1
2
4
.
2
4
$
5
,
0
5
8
,
0
8
1
.
5
2
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending September 30, 2021 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 10/7/21 As of 10/7/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $10,542,536.97 $1,963,577.01 $12,506,113.98 $453,917.50 $453,917.50
10‐100‐400020 Sales Tax Interest $0.00 $32,517.33 $0.00 $32,517.33 $32,517.33 $32,517.33
$12,052,196.48 $10,575,054.30 $1,963,577.01 $12,538,631.31 $486,434.83 $486,434.83
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $525,445.51 $154,875.97 $680,321.48 $84,321.48 $84,321.48
10‐100‐403010 Gasoline Tax $1,170,000.00 $855,891.64 $306,458.46 $1,162,350.10 ($7,649.90)($7,649.90)
10‐100‐430080 Road & Bridge Tax $590,000.00 $606,436.91 $0.00 $606,436.91 $16,436.91 $16,436.91
$2,356,000.00 $1,987,774.06 $461,334.43 $2,449,108.49 $93,108.49 $93,108.49
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $78,203.42 $17,211.93 $95,415.35 ($4,584.65)($4,584.65)
$100,000.00 $78,203.42 $17,211.93 $95,415.35 ($4,584.65)($4,584.65)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $3,080,697.62 $699,788.87 $3,780,486.49 ($219,513.51)($219,513.51)
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 $900,000.00 $749,293.32 $67,271.56 $816,564.88 ($83,435.12)($83,435.12)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $1,040,983.66 $240,962.98 $1,281,946.64 ($318,053.36)($318,053.36)
10‐100‐410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐410060 Cable Franchise Fee $325,000.00 $216,283.65 $74,977.37 $291,261.02 ($33,738.98)($33,738.98)
$6,825,000.00 $5,087,258.25 $1,083,000.77 $6,170,259.02 ($654,740.98)($654,740.98)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $4,975,044.19 $3,257.22 $4,978,301.41 $103,301.41 $103,301.41
10‐100‐420020 Del Property Tax $47,000.00 $137,209.78 $929.45 $138,139.23 $91,139.23 $91,139.23
10‐100‐420040 Fin Institution Tax $30,000.00 $18,137.56 $0.00 $18,137.56 ($11,862.44)($11,862.44)
10‐100‐420050 Prop Tax Int & Penalties $29,000.00 $29,711.96 $1,529.95 $31,241.91 $2,241.91 $2,241.91
10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.28 $54,399.28 $0.00 $54,399.28 $0.00 $0.00
10‐100‐420060 Surtax Receipts $470,000.00 $512,779.01 $16.51 $512,795.52 $42,795.52 $42,795.52
10‐100‐420080 Special Tax Rev $56,000.00 $71,791.90 $13,057.26 $84,849.16 $28,849.16 $28,849.16
$5,561,399.28 $5,799,073.68 $18,790.40 $5,817,864.08 $256,464.80 $256,464.80
Intergovernmental
10‐100‐430010 Federal Grant $0.00 $4,471,750.22 $0.00 $4,471,750.22 $4,471,750.22 $4,471,750.22
10‐100‐430040 Local Grant $5,170.00 $16,426.36 $0.00 $16,426.36 $11,256.36 $11,256.36
10‐100‐430060 Drug Forfeiture $0.00 $230,629.28 $0.00 $230,629.28 $230,629.28 $230,629.28
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 $34,988.00 $0.00 $34,988.00 $34,988.00 $34,988.00
$5,170.00 $4,753,793.86 $0.00 $4,753,793.86 $4,748,623.86 $4,748,623.86
Charges for Services
10‐100‐440010 Admin Charge Backs $1,561,647.00 $1,561,647.00 $0.00 $1,561,647.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 $30,000.00 $32,058.00 $3,221.64 $35,279.64 $5,279.64 $5,279.64
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $7,970.81 $1,070.45 $9,041.26 ($1,958.74)($1,958.74)
10‐100‐440920 Parts Charge backs $221,206.58 $192,607.42 $18,037.01 $210,644.43 ($10,562.15)($10,562.15)
10‐100‐440930 Labor Charge backs $249,445.72 $200,046.48 $18,503.96 $218,550.44 ($30,895.28)($30,895.28)
10‐100‐481020 Cole Cty Animal Rescue $115,034.90 $86,276.19 $28,758.73 $115,034.92 $0.02 $0.02
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 $1,000.00 $12,000.00 $13,000.00 $1,000.00 $1,000.00
10‐100‐481045 Rent‐tower Sites $165,000.00 $183,843.92 $5,883.23 $189,727.15 $24,727.15 $24,727.15
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 $399,676.18 $365,608.29 $33,383.85 $398,992.14 ($684.04)($684.04)
10‐100‐481080 Sale Of Maps/GIS Data $0.00 $75.00 $0.00 $75.00 $75.00 $75.00
10‐100‐481085 Cole Cty GIS Joint Coop $15,000.00 $16,402.50 $1,250.00 $17,652.50 $2,652.50 $2,652.50
10‐100‐481100 Sale Of Grave Sites $2,085.00 $2,919.00 $0.00 $2,919.00 $834.00 $834.00
10‐100‐481105 TIF Administration Fee $20,580.72 $10,230.00 $10,300.00 $20,530.00 ($50.72)($50.72)
10‐100‐481110 Long & Short $0.00 ($2.34)$0.00 ($2.34)($2.34)($2.34)
$2,852,676.10 $2,685,682.27 $157,408.87 $2,843,091.14 ($9,584.96)($9,584.96)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $78,403.33 $277.24 $78,680.57 $8,680.57 $8,680.57
10‐100‐450020 Business Licenses $220,000.00 $210,671.49 $3,989.18 $214,660.67 ($5,339.33)($5,339.33)
10‐100‐450021 Home Occupation Permit $1,800.00 $2,640.00 $286.36 $2,926.36 $1,126.36 $1,126.36
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 $7,830.00 $666.67 $8,496.67 $496.67 $496.67
10‐100‐450045 Building Construct. Fees $315,000.00 $345,419.26 $14,747.44 $360,166.70 $45,166.70 $45,166.70
10‐100‐450050 Electrical Certificates $22,000.00 $25,422.00 $774.24 $26,196.24 $4,196.24 $4,196.24
10‐100‐450060 Electrical Permits $4,400.00 $9,986.33 $383.50 $10,369.83 $5,969.83 $5,969.83
10‐100‐450070 Plumbing Licenses $12,400.00 $11,301.00 $348.89 $11,649.89 ($750.11)($750.11)
10‐100‐450080 Plumbing Permits $8,000.00 $31,716.63 $1,343.46 $33,060.09 $25,060.09 $25,060.09
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending September 30, 2021 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 10/7/21 As of 10/7/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,768.00 $673.79 $2,441.79 $441.79 $441.79
10‐100‐450091 Day Care Inspection Fees $6,400.00 $4,160.00 $210.28 $4,370.28 ($2,029.72)($2,029.72)
10‐100‐450092 Food Inspection Fees $86,000.00 $92,084.24 ($2,574.22)$89,510.02 $3,510.02 $3,510.02
10‐100‐450100 Curb Cut Permits $1,000.00 $1,590.00 $134.43 $1,724.43 $724.43 $724.43
10‐100‐450110 Board Of Adj Fees $1,000.00 $1,600.00 $46.35 $1,646.35 $646.35 $646.35
10‐100‐450120 Sign Permits $6,900.00 $7,183.00 $759.06 $7,942.06 $1,042.06 $1,042.06
10‐100‐450130 Demolition Permits $1,800.00 $3,626.00 $152.11 $3,778.11 $1,978.11 $1,978.11
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $6,401.90 $839.15 $7,241.05 ($1,758.95)($1,758.95)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $1,595.75 $111.12 $1,706.87 $556.87 $556.87
10‐100‐450170 Animal Redemption Fees $98,000.00 $88,464.00 $10,664.57 $99,128.57 $1,128.57 $1,128.57
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $4,345.00 $585.67 $4,930.67 ($269.33)($269.33)
10‐100‐450185 Animal Cremation Fees $50,000.00 $36,368.00 $7,797.75 $44,165.75 ($5,834.25)($5,834.25)
10‐100‐450186 Animal Boarding Fees $0.00 $1,420.00 $0.00 $1,420.00 $1,420.00 $1,420.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 $272.00 $66.67 $338.67 ($461.33)($461.33)
10‐100‐450250 Rezoning Request $0.00 $200.00 $0.00 $200.00 $200.00 $200.00
10‐100‐450255 Planning & Zoning Review Fees $20,000.00 $14,081.00 $1,578.59 $15,659.59 ($4,340.41)($4,340.41)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $805.00 $147.21 $952.21 ($847.79)($847.79)
$952,650.00 $989,353.93 $44,009.50 $1,033,363.43 $80,713.43 $80,713.43
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $36,918.45 $4,968.42 $41,886.87 ($15,113.13)($15,113.13)
10‐100‐460015 Court Restitutions $0.00 $215.00 $0.00 $215.00 $215.00 $215.00
10‐100‐460018 Inmate Security Fund $9,500.00 $6,139.22 $825.96 $6,965.18 ($2,534.82)($2,534.82)
10‐100‐460020 Jail Cost Recovery $1,100.00 $51.10 $142.40 $193.50 ($906.50)($906.50)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $6,171.22 $140.97 $6,312.19 $2,112.19 $2,112.19
10‐100‐460030 Pol Fines‐traffic $500,000.00 $369,285.83 $42,928.90 $412,214.73 ($87,785.27)($87,785.27)
10‐100‐460090 Parking Fines $40,000.00 $29,870.50 $1,639.26 $31,509.76 ($8,490.24)($8,490.24)
10‐100‐460100 Bankcard Charges ($3,900.00)($5,465.42)($298.23)($5,763.65)($1,863.65)($1,863.65)
$607,900.00 $443,185.90 $50,347.68 $493,533.58 ($114,366.42)($114,366.42)
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 $17,307.43 $17,427.43 $0.00 $17,427.43 $120.00 $120.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 $1,000.00 $1,000.00 $0.00 $1,000.00 $0.00 $0.00
10‐100‐480165 Animal S Donations $15,000.00 $23,233.11 $2,930.28 $26,163.39 $11,163.39 $11,163.39
10‐100‐481055 Street Repair‐Solid Waste Cntr $341,542.00 $283,636.64 $56,222.01 $339,858.65 ($1,683.35)($1,683.35)
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$374,849.43 $325,297.18 $59,152.29 $384,449.47 $9,600.04 $9,600.04
Other Operating Revenues
10‐100‐480010 Citizen Participation $0.00 $333.28 $0.00 $333.28 $333.28 $333.28
10‐100‐480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐481070 Miscellaneous $71,027.45 $38,561.82 $8,842.69 $47,404.51 ($23,622.94)($23,622.94)
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 $18,000.00 $12,707.92 $3,221.66 $15,929.58 ($2,070.42)($2,070.42)
10‐100‐481077 Insurance Claims $122,193.19 $282,726.40 $0.00 $282,726.40 $160,533.21 $160,533.21
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$221,220.64 $334,329.42 $22,064.35 $356,393.77 $135,173.13 $135,173.13
Interest Income
10‐100‐470010 Interest $120,000.00 $138,105.11 $14,607.88 $152,712.99 $32,712.99 $32,712.99
$120,000.00 $138,105.11 $14,607.88 $152,712.99 $32,712.99 $32,712.99
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $93,892.13 $220,000.00 $313,892.13 $1,131.13 $1,131.13
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $93,892.13 $220,000.00 $313,892.13 $1,131.13 $1,131.13
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $21,525.73 $2,270.10 $23,795.83 ($2,604.17)($2,604.17)
10‐100‐490355 Transfer from CIT 'G' $1,599,595.00 $1,599,595.00 $0.00 $1,599,595.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
$1,625,995.00 $1,621,120.73 $2,270.10 $1,623,390.83 ($2,604.17)($2,604.17)
$33,967,817.93 $34,912,124.24 $4,113,775.21 $39,025,899.45 $5,058,081.52 $5,058,081.52