HomeMy Public PortalAbout2021-01 NO Meeting - Revenue Model ReportRe
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
O
c
t
o
b
e
r
3
1
,
2
0
2
0
Da
t
a
a
s
o
f
J
a
n
u
a
r
y
7
,
2
0
2
1
FY
2
0
2
0
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
/
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
1
,
8
7
4
,
0
8
5
.
2
0
$
1
2
,
2
1
9
,
1
1
0
.
0
0
$
3
4
5
,
0
2
4
.
8
0
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
T
a
x
e
s
$2
,
3
2
2
,
5
0
0
.
0
0
$
2
,
2
8
0
,
3
7
9
.
9
4
($
4
2
,
1
2
0
.
0
6
)
Ot
h
e
r
T
a
x
e
s
$1
0
6
,
0
0
0
.
0
0
$
9
6
,
7
7
6
.
3
6
($
9
,
2
2
3
.
6
4
)
Fr
a
n
c
h
i
s
e
&
U
t
i
l
i
t
y
T
a
x
$7
,
2
0
5
,
0
0
0
.
0
0
$
6
,
2
1
3
,
4
2
8
.
6
1
($
9
9
1
,
5
7
1
.
3
9
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
4
6
6
,
3
9
9
.
0
0
$
5
,
5
7
1
,
6
8
2
.
9
0
$
1
0
5
,
2
8
3
.
9
0
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$8
2
,
1
8
0
.
2
8
$
1
,
1
3
7
,
4
0
5
.
1
7
$
1
,
0
5
5
,
2
2
4
.
8
9
Ch
a
r
g
e
s
f
o
r
S
e
r
v
i
c
e
s
$2
,
8
7
5
,
1
3
0
.
0
4
$
2
,
8
8
3
,
7
3
4
.
8
3
$
8
,
6
0
4
.
7
9
Fe
e
s
,
L
i
c
e
n
s
e
s
,
&
P
e
r
m
i
t
s
$9
0
2
,
5
2
0
.
0
0
$
1
,
1
9
2
,
0
5
1
.
8
4
$
2
8
9
,
5
3
1
.
8
4
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$7
6
6
,
6
0
0
.
0
0
$
4
3
2
,
2
7
4
.
7
7
($
3
3
4
,
3
2
5
.
2
3
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
4
3
,
1
5
9
.
5
6
$
3
7
0
,
9
9
2
.
8
7
$
2
7
,
8
3
3
.
3
1
Ot
h
e
r
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
s
$2
2
1
,
8
2
7
.
7
6
$
2
0
9
,
8
5
0
.
2
8
($
1
1
,
9
7
7
.
4
8
)
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
6
0
,
0
0
2
.
0
4
$
1
1
8
,
4
7
8
.
9
0
($
4
1
,
5
2
3
.
1
4
)
Ot
h
e
r
N
o
n
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
$5
5
,
0
0
0
.
0
0
$
4
7
,
9
1
1
.
1
3
($
7
,
0
8
8
.
8
7
)
Op
e
r
a
t
i
n
g
T
r
a
n
s
f
e
r
s
I
n
$2
6
,
0
0
0
.
0
0
$2
1
,
5
2
5
.
4
1
($
4
,
4
7
4
.
5
9
)
To
t
a
l
s
$3
2
,
4
0
6
,
4
0
3
.
8
8
$
3
2
,
7
9
5
,
6
0
3
.
0
1
$
3
8
9
,
1
9
9
.
1
3
FY2020
Revenue Model Report (Detail)Remaining
For the Period Ending October 31, 2020 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 1/7/21 As of 1/7/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $11,874,085.20 $12,206,053.06 $0.00 $12,206,053.06 $331,967.86 $331,967.86
10‐100‐400020 Sales Tax Interest $0.00 $13,056.94 $0.00 $13,056.94 $13,056.94 $13,056.94
$11,874,085.20 $12,219,110.00 $0.00 $12,219,110.00 $345,024.80 $345,024.80
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $591,500.00 $597,610.62 $0.00 $597,610.62 $6,110.62 $6,110.62
10‐100‐403010 Gasoline Tax $1,161,000.00 $1,093,355.53 $0.00 $1,093,355.53 ($67,644.47)($67,644.47)
10‐100‐430080 Road & Bridge Tax $570,000.00 $589,413.79 $0.00 $589,413.79 $19,413.79 $19,413.79
$2,322,500.00 $2,280,379.94 $0.00 $2,280,379.94 ($42,120.06)($42,120.06)
Other Taxes
10‐100‐403020 Cig Tax $106,000.00 $96,776.36 $0.00 $96,776.36 ($9,223.64)($9,223.64)
$106,000.00 $96,776.36 $0.00 $96,776.36 ($9,223.64)($9,223.64)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,100,000.00 $3,708,995.13 $0.00 $3,708,995.13 ($391,004.87)($391,004.87)
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 $950,000.00 $788,656.49 $0.00 $788,656.49 ($161,343.51)($161,343.51)
10‐100‐410052 Telephone/Cell Utility $1,800,000.00 $1,414,172.82 $0.00 $1,414,172.82 ($385,827.18)($385,827.18)
10‐100‐410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐410060 Cable Franchise Fee $355,000.00 $301,604.17 $0.00 $301,604.17 ($53,395.83)($53,395.83)
$7,205,000.00 $6,213,428.61 $0.00 $6,213,428.61 ($991,571.39)($991,571.39)
Property Taxes
10‐100‐420010 Current Property Tax $4,790,000.00 $4,874,236.38 $0.00 $4,874,236.38 $84,236.38 $84,236.38
10‐100‐420020 Del Property Tax $45,000.00 $48,435.76 $0.00 $48,435.76 $3,435.76 $3,435.76
10‐100‐420040 Fin Institution Tax $33,000.00 $29,796.21 $0.00 $29,796.21 ($3,203.79)($3,203.79)
10‐100‐420050 Prop Tax Int & Penalties $29,000.00 $26,808.93 $0.00 $26,808.93 ($2,191.07)($2,191.07)
10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28
10‐100‐420060 Surtax Receipts $467,000.00 $472,146.53 $0.00 $472,146.53 $5,146.53 $5,146.53
10‐100‐420080 Special Tax Rev $48,000.00 $65,859.81 $0.00 $65,859.81 $17,859.81 $17,859.81
$5,466,399.00 $5,571,682.90 $0.00 $5,571,682.90 $105,283.90 $105,283.90
Intergovernmental
10‐100‐430010 Federal Grant $79,255.28 $1,187,965.80 $0.00 $1,187,965.80 $1,108,710.52 $1,108,710.52
10‐100‐430040 Local Grant $2,925.00 $2,925.00 $0.00 $2,925.00 $0.00 $0.00
10‐100‐430060 Drug Forfeiture $0.00 ($110,583.01)$0.00 ($110,583.01) ($110,583.01)($110,583.01)
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 $57,097.38 $0.00 $57,097.38 $57,097.38 $57,097.38
$82,180.28 $1,137,405.17 $0.00 $1,137,405.17 $1,055,224.89 $1,055,224.89
Charges for Services
10‐100‐440010 Admin Charge Backs $1,555,757.00 $1,555,757.00 $0.00 $1,555,757.00 $0.00 $0.00
10‐100‐440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10‐100‐440210 Street Cuts $27,000.00 $40,934.00 $0.00 $40,934.00 $13,934.00 $13,934.00
10‐100‐440910 Fuel Charge ‐ backs $12,000.00 $7,561.48 $0.00 $7,561.48 ($4,438.52)($4,438.52)
10‐100‐440920 Parts Charge backs $244,000.00 $252,261.54 $0.00 $252,261.54 $8,261.54 $8,261.54
10‐100‐440930 Labor Charge backs $275,000.00 $240,424.77 $0.00 $240,424.77 ($34,575.23)($34,575.23)
10‐100‐481020 Cole Cty Animal Rescue $112,229.12 $112,229.16 $0.00 $112,229.16 $0.04 $0.04
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,900.00 $0.00 $12,900.00 $900.00 $900.00
10‐100‐481045 Rent‐tower Sites $156,000.00 $185,230.89 $0.00 $185,230.89 $29,230.89 $29,230.89
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 $389,991.81 $389,943.74 $0.00 $389,943.74 ($48.07)($48.07)
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 $16,850.00 $15,000.00 $0.00 $15,000.00 ($1,850.00)($1,850.00)
10‐100‐481100 Sale Of Grave Sites $4,500.00 $1,668.00 $0.00 $1,668.00 ($2,832.00)($2,832.00)
10‐100‐481105 TIF Administration Fee $19,802.11 $19,802.12 $0.00 $19,802.12 $0.01 $0.01
10‐100‐481110 Long & Short $0.00 $12.13 $0.00 $12.13 $12.13 $12.13
$2,875,130.04 $2,883,734.83 $0.00 $2,883,734.83 $8,604.79 $8,604.79
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $68,000.00 $71,960.42 $0.00 $71,960.42 $3,960.42 $3,960.42
10‐100‐450020 Business Licenses $215,000.00 $217,858.74 $0.00 $217,858.74 $2,858.74 $2,858.74
10‐100‐450021 Home Occupation Permit $2,000.00 $2,420.00 $0.00 $2,420.00 $420.00 $420.00
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 ($2,805.00)$0.00 ($2,805.00) ($10,805.00)($10,805.00)
10‐100‐450045 Building Construct. Fees $260,000.00 $549,880.92 $0.00 $549,880.92 $289,880.92 $289,880.92
10‐100‐450050 Electrical Certificates $22,000.00 $21,567.00 $0.00 $21,567.00 ($433.00)($433.00)
10‐100‐450060 Electrical Permits $4,000.00 $10,440.80 $0.00 $10,440.80 $6,440.80 $6,440.80
10‐100‐450070 Plumbing Licenses $12,000.00 $11,622.00 $0.00 $11,622.00 ($378.00)($378.00)
10‐100‐450080 Plumbing Permits $5,800.00 $8,932.50 $0.00 $8,932.50 $3,132.50 $3,132.50
FY2020
Revenue Model Report (Detail)Remaining
For the Period Ending October 31, 2020 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 1/7/21 As of 1/7/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,216.00 $0.00 $1,216.00 ($784.00)($784.00)
10‐100‐450091 Day Care Inspection Fees $7,300.00 $5,195.00 $0.00 $5,195.00 ($2,105.00)($2,105.00)
10‐100‐450092 Food Inspection Fees $87,550.00 $87,765.95 $0.00 $87,765.95 $215.95 $215.95
10‐100‐450100 Curb Cut Permits $850.00 $2,410.00 $0.00 $2,410.00 $1,560.00 $1,560.00
10‐100‐450110 Board Of Adj Fees $3,770.00 $2,800.00 $0.00 $2,800.00 ($970.00)($970.00)
10‐100‐450120 Sign Permits $6,300.00 $6,833.00 $0.00 $6,833.00 $533.00 $533.00
10‐100‐450130 Demolition Permits $1,600.00 $7,100.00 $0.00 $7,100.00 $5,500.00 $5,500.00
10‐100‐450150 Acc Rep Fees‐police $11,500.00 $7,173.80 $0.00 $7,173.80 ($4,326.20)($4,326.20)
10‐100‐450160 Accrpt/blastg P‐fire $1,050.00 $740.31 $0.00 $740.31 ($309.69)($309.69)
10‐100‐450170 Animal Redemption Fees $108,000.00 $97,124.60 $0.00 $97,124.60 ($10,875.40)($10,875.40)
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $4,200.00 $0.00 $4,200.00 ($1,000.00)($1,000.00)
10‐100‐450185 Animal Cremation Fees $45,000.00 $58,507.00 $0.00 $58,507.00 $13,507.00 $13,507.00
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 $27.00 $0.00 $27.00 $27.00 $27.00
10‐100‐450230 Vacating Right Of Way $800.00 $816.00 $0.00 $816.00 $16.00 $16.00
10‐100‐450250 Rezoning Request $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐450255 Planning & Zoning Review Fees $23,000.00 $17,025.80 $0.00 $17,025.80 ($5,974.20)($5,974.20)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,240.00 $0.00 $1,240.00 ($560.00)($560.00)
$902,520.00 $1,192,051.84 $0.00 $1,192,051.84 $289,531.84 $289,531.84
Fines & Forfeitures
10‐100‐460010 Court Cost $69,000.00 $37,845.08 $0.00 $37,845.08 ($31,154.92)($31,154.92)
10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐460018 Inmate Security Fund $11,500.00 $6,326.05 $0.00 $6,326.05 ($5,173.95)($5,173.95)
10‐100‐460020 Jail Cost Recovery $1,500.00 $288.29 $0.00 $288.29 ($1,211.71)($1,211.71)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $5,448.26 $0.00 $5,448.26 $1,248.26 $1,248.26
10‐100‐460030 Pol Fines‐traffic $630,000.00 $372,034.44 $0.00 $372,034.44 ($257,965.56)($257,965.56)
10‐100‐460090 Parking Fines $54,000.00 $18,387.50 $0.00 $18,387.50 ($35,612.50)($35,612.50)
10‐100‐460100 Bankcard Charges ($3,600.00)($8,054.85)$0.00 ($8,054.85)($4,454.85)($4,454.85)
$766,600.00 $432,274.77 $0.00 $432,274.77 ($334,325.23)($334,325.23)
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,115.56 $15,653.05 $0.00 $15,653.05 $5,537.49 $5,537.49
10‐100‐480080 Dare Donations $450.00 $450.00 $0.00 $450.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 $0.00 $22,293.11 $0.00 $22,293.11 $22,293.11 $22,293.11
10‐100‐481055 Street Repair‐Solid Waste Cntr $331,594.00 $331,596.71 $0.00 $331,596.71 $2.71 $2.71
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$343,159.56 $370,992.87 $0.00 $370,992.87 $27,833.31 $27,833.31
Other Operating Revenues
10‐100‐480010 Citizen Participation $0.00 $322.57 $0.00 $322.57 $322.57 $322.57
10‐100‐480011 Police Evidence Funds $0.00 $65,581.18 $0.00 $65,581.18 $65,581.18 $65,581.18
10‐100‐481070 Miscellaneous $53,000.00 $80,537.44 $0.00 $80,537.44 $27,537.44 $27,537.44
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 $19,000.00 $14,984.33 $0.00 $14,984.33 ($4,015.67)($4,015.67)
10‐100‐481077 Insurance Claims $139,827.76 $28,027.67 $0.00 $28,027.67 ($111,800.09)($111,800.09)
10‐100‐481078 Cafeteria Refunds $10,000.00 $20,397.09 $0.00 $20,397.09 $10,397.09 $10,397.09
$221,827.76 $209,850.28 $0.00 $209,850.28 ($11,977.48)($11,977.48)
Interest Income
10‐100‐470010 Interest $160,002.04 $118,478.90 $0.00 $118,478.90 ($41,523.14)($41,523.14)
$160,002.04 $118,478.90 $0.00 $118,478.90 ($41,523.14)($41,523.14)
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $55,000.00 $40,753.13 $0.00 $40,753.13 ($14,246.87)($14,246.87)
10‐100‐486020 Capital Contribution‐Developer $0.00 $7,158.00 $0.00 $7,158.00 $7,158.00 $7,158.00
$55,000.00 $47,911.13 $0.00 $47,911.13 ($7,088.87)($7,088.87)
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,000.00 $21,525.41 $0.00 $21,525.41 ($4,474.59)($4,474.59)
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$26,000.00 $21,525.41 $0.00 $21,525.41 ($4,474.59)($4,474.59)
$32,406,403.88 $32,795,603.01 $0.00 $32,795,603.01 $389,199.13 $389,199.13
Re
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
D
e
c
e
m
b
e
r
3
1
,
2
0
2
0
Da
t
a
a
s
o
f
J
a
n
u
a
r
y
8
,
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
/
8
/
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
$
9
8
6
,
1
7
9
.
9
6
($
4
9
,
8
9
8
.
7
0
)
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
$
0
.
0
0
$
0
.
0
0
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
6
,
7
8
0
.
3
6
($
4
0
5
.
9
4
)
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
$
3
8
1
,
0
1
3
.
8
6
($
7
8
,
2
5
2
.
5
6
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
9
1
7
,
4
6
7
.
4
5
$
6
8
,
0
4
9
.
0
4
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
5
,
1
6
5
.
0
0
$
5
,
1
6
5
.
0
0
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
$
1
,
7
2
7
,
0
0
7
.
1
6
($
1
4
,
8
5
9
.
0
0
)
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
$
2
1
1
,
8
5
2
.
7
7
$
5
9
,
7
8
7
.
9
6
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$6
0
7
,
9
0
0
.
0
0
$
6
7
,
3
9
4
.
2
3
($
2
6
,
3
4
2
.
2
4
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
7
3
,
5
0
0
.
2
1
$
5
3
,
8
5
9
.
3
7
$
5
,
0
8
5
.
0
1
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
$
8
,
7
7
4
.
1
4
($
1
,
6
9
0
.
9
4
)
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
8
,
8
1
4
.
2
4
$
3
5
1
.
6
8
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
$
1
0
,
7
0
0
.
0
0
$
0
.
0
0
Op
e
r
a
t
i
n
g
T
r
a
n
s
f
e
r
s
I
n
$2
6
,
4
0
0
.
0
0
$2
,
7
7
4
.
1
1
($
1
,
9
9
7
.
4
6
)
To
t
a
l
s
$3
2
,
3
6
6
,
8
7
3
.
7
1
$
4
,
3
8
7
,
7
8
2
.
6
5
($
3
5
,
0
0
8
.
1
3
)
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending December 31, 2020 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 1/8/21 As of 1/8/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $986,179.96 $11,016,117.82 $12,002,297.78 ($49,898.70)($49,898.70)
10‐100‐400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$12,052,196.48 $986,179.96 $11,016,117.82 $12,002,297.78 ($49,898.70) ($49,898.70)
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $0.00 $596,000.00 $596,000.00 $0.00 $0.00
10‐100‐403010 Gasoline Tax $1,170,000.00 $0.00 $1,170,000.00 $1,170,000.00 $0.00 $0.00
10‐100‐430080 Road & Bridge Tax $590,000.00 $0.00 $590,000.00 $590,000.00 $0.00 $0.00
$2,356,000.00 $0.00 $2,356,000.00 $2,356,000.00 $0.00 $0.00
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $6,780.36 $92,813.70 $99,594.06 ($405.94)($405.94)
$100,000.00 $6,780.36 $92,813.70 $99,594.06 ($405.94)($405.94)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $248,865.38 $3,746,851.76 $3,995,717.14 ($4,282.86)($4,282.86)
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 $60,568.16 $829,563.89 $890,132.05 ($9,867.95)($9,867.95)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $69,547.70 $1,468,698.39 $1,538,246.09 ($61,753.91)($61,753.91)
10‐100‐410053 Telephone/Cell Audit $0.00 $0.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
10‐100‐410060 Cable Franchise Fee $325,000.00 $2,032.62 $319,619.54 $321,652.16 ($3,347.84)($3,347.84)
$6,825,000.00 $381,013.86 $6,365,733.58 $6,746,747.44 ($78,252.56)($78,252.56)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $790,863.85 $4,146,760.21 $4,937,624.06 $62,624.06 $62,624.06
10‐100‐420020 Del Property Tax $47,000.00 $6,020.45 $37,610.99 $43,631.44 ($3,368.56)($3,368.56)
10‐100‐420040 Fin Institution Tax $30,000.00 $0.00 $30,000.00 $30,000.00 $0.00 $0.00
10‐100‐420050 Prop Tax Int & Penalties $29,000.00 $3,798.30 $26,064.21 $29,862.51 $862.51 $862.51
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 $62,385.57 $415,187.90 $477,573.47 $7,573.47 $7,573.47
10‐100‐420080 Special Tax Rev $56,000.00 $0.00 $56,357.55 $56,357.55 $357.55 $357.55
$5,561,399.28 $917,467.45 $4,711,980.87 $5,629,448.32 $68,049.04 $68,049.04
Intergovernmental
10‐100‐430010 Federal Grant $0.00 $165.00 $0.00 $165.00 $165.00 $165.00
10‐100‐430040 Local Grant $5,170.00 $0.00 $5,170.00 $5,170.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 $5,000.00 $0.00 $5,000.00 $5,000.00 $5,000.00
$5,170.00 $5,165.00 $5,170.00 $10,335.00 $5,165.00 $5,165.00
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 $4,175.00 $25,713.27 $29,888.27 ($111.73)($111.73)
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $404.75 $9,109.97 $9,514.72 ($1,485.28)($1,485.28)
10‐100‐440920 Parts Charge backs $221,206.58 $27,138.94 $190,793.67 $217,932.61 ($3,273.97)($3,273.97)
10‐100‐440930 Labor Charge backs $249,445.72 $33,846.50 $205,211.48 $239,057.98 ($10,387.74)($10,387.74)
10‐100‐481020 Cole Cty Animal Rescue $115,034.90 $0.00 $115,034.90 $115,034.90 $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 $200.00 $12,000.00 $12,200.00 $200.00 $200.00
10‐100‐481045 Rent‐tower Sites $165,000.00 $6,512.83 $160,189.98 $166,702.81 $1,702.81 $1,702.81
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 $65,153.64 $333,063.50 $398,217.14 ($1,459.04)($1,459.04)
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 $2,500.00 $12,500.00 $15,000.00 $0.00 $0.00
10‐100‐481100 Sale Of Grave Sites $2,085.00 $417.00 $1,612.45 $2,029.45 ($55.55)($55.55)
10‐100‐481105 TIF Administration Fee $20,580.72 $0.00 $20,580.72 $20,580.72 $0.00 $0.00
10‐100‐481110 Long & Short $0.00 $1.50 $0.00 $1.50 $1.50 $1.50
$2,852,676.10 $1,727,007.16 $1,110,809.94 $2,837,817.10 ($14,859.00)($14,859.00)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $1,011.25 $69,034.51 $70,045.76 $45.76 $45.76
10‐100‐450020 Business Licenses $220,000.00 $70,938.40 $160,666.58 $231,604.98 $11,604.98 $11,604.98
10‐100‐450021 Home Occupation Permit $1,800.00 $165.00 $1,677.27 $1,842.27 $42.27 $42.27
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 $1,180.00 $6,666.67 $7,846.67 ($153.33)($153.33)
10‐100‐450045 Building Construct. Fees $315,000.00 $103,420.58 $261,601.11 $365,021.69 $50,021.69 $50,021.69
10‐100‐450050 Electrical Certificates $22,000.00 $3,537.00 $17,241.34 $20,778.34 ($1,221.66)($1,221.66)
10‐100‐450060 Electrical Permits $4,400.00 $641.19 $4,133.07 $4,774.26 $374.26 $374.26
10‐100‐450070 Plumbing Licenses $12,400.00 $864.00 $9,829.74 $10,693.74 ($1,706.26)($1,706.26)
10‐100‐450080 Plumbing Permits $8,000.00 $957.50 $6,802.24 $7,759.74 ($240.26)($240.26)
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending December 31, 2020 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 1/8/21 As of 1/8/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $621.00 $1,978.62 $2,599.62 $599.62 $599.62
10‐100‐450091 Day Care Inspection Fees $6,400.00 $910.00 $4,950.08 $5,860.08 ($539.92)($539.92)
10‐100‐450092 Food Inspection Fees $86,000.00 $4,515.74 $82,391.42 $86,907.16 $907.16 $907.16
10‐100‐450100 Curb Cut Permits $1,000.00 $220.00 $856.45 $1,076.45 $76.45 $76.45
10‐100‐450110 Board Of Adj Fees $1,000.00 $400.00 $882.97 $1,282.97 $282.97 $282.97
10‐100‐450120 Sign Permits $6,900.00 $784.00 $6,025.46 $6,809.46 ($90.54)($90.54)
10‐100‐450130 Demolition Permits $1,800.00 $800.00 $1,470.42 $2,270.42 $470.42 $470.42
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $1,025.50 $7,515.38 $8,540.88 ($459.12)($459.12)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $18.61 $1,087.35 $1,105.96 ($44.04)($44.04)
10‐100‐450170 Animal Redemption Fees $98,000.00 $14,095.00 $85,596.62 $99,691.62 $1,691.62 $1,691.62
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $625.00 $4,277.13 $4,902.13 ($297.87)($297.87)
10‐100‐450185 Animal Cremation Fees $50,000.00 $3,184.00 $46,075.67 $49,259.67 ($740.33)($740.33)
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 $136.00 $533.33 $669.33 ($130.67)($130.67)
10‐100‐450250 Rezoning Request $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐450255 Planning & Zoning Review Fees $20,000.00 $1,803.00 $17,700.68 $19,503.68 ($496.32)($496.32)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $0.00 $1,591.08 $1,591.08 ($208.92)($208.92)
$952,650.00 $211,852.77 $800,585.19 $1,012,437.96 $59,787.96 $59,787.96
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $6,445.81 $47,430.35 $53,876.16 ($3,123.84)($3,123.84)
10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐460018 Inmate Security Fund $9,500.00 $1,055.34 $7,909.30 $8,964.64 ($535.36)($535.36)
10‐100‐460020 Jail Cost Recovery $1,100.00 $0.00 $1,015.51 $1,015.51 ($84.49)($84.49)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $659.30 $3,681.69 $4,340.99 $140.99 $140.99
10‐100‐460030 Pol Fines‐traffic $500,000.00 $57,130.41 $420,055.55 $477,185.96 ($22,814.04)($22,814.04)
10‐100‐460090 Parking Fines $40,000.00 $3,024.00 $37,518.32 $40,542.32 $542.32 $542.32
10‐100‐460100 Bankcard Charges ($3,900.00)($920.63)($3,447.19)($4,367.82)($467.82)($467.82)
$607,900.00 $67,394.23 $514,163.53 $581,557.76 ($26,342.24)($26,342.24)
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 $15,958.21 $15,958.21 $0.00 $15,958.21 $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 $1,000.00 $1,000.00 $0.00 $1,000.00 $0.00 $0.00
10‐100‐480165 Animal S Donations $15,000.00 $8,790.49 $11,293.42 $20,083.91 $5,083.91 $5,083.91
10‐100‐481055 Street Repair‐Solid Waste Cntr $341,542.00 $28,110.67 $313,432.43 $341,543.10 $1.10 $1.10
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$373,500.21 $53,859.37 $324,725.85 $378,585.22 $5,085.01 $5,085.01
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 $71,027.45 $7,986.66 $61,524.63 $69,511.29 ($1,516.16)($1,516.16)
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 $787.48 $17,037.74 $17,825.22 ($174.78)($174.78)
10‐100‐481077 Insurance Claims $122,193.19 $0.00 $122,193.19 $122,193.19 $0.00 $0.00
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$221,220.64 $8,774.14 $210,755.56 $219,529.70 ($1,690.94)($1,690.94)
Interest Income
10‐100‐470010 Interest $120,000.00 $8,814.24 $111,537.44 $120,351.68 $351.68 $351.68
$120,000.00 $8,814.24 $111,537.44 $120,351.68 $351.68 $351.68
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $10,700.00 $302,061.00 $312,761.00 $0.00 $0.00
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $10,700.00 $302,061.00 $312,761.00 $0.00 $0.00
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $2,774.11 $21,628.43 $24,402.54 ($1,997.46)($1,997.46)
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$26,400.00 $2,774.11 $21,628.43 $24,402.54 ($1,997.46)($1,997.46)
$32,366,873.71 $4,387,782.65 $27,944,082.93 $32,331,865.58 ($35,008.13)($35,008.13)