HomeMy Public PortalAbout2022-01 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
1
Da
t
a
a
s
o
f
J
a
n
u
a
r
y
1
4
,
2
0
2
2
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
/
1
4
/
2
2
(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
2
,
7
7
8
,
4
3
2
.
0
1
$
7
2
6
,
2
3
5
.
5
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
$
2
,
4
5
3
,
6
5
7
.
4
2
$
9
7
,
6
5
7
.
4
2
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
9
4
,
8
0
4
.
6
2
($
5
,
1
9
5
.
3
8
)
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
$
6
,
2
7
1
,
1
3
9
.
9
3
($
5
5
3
,
8
6
0
.
0
7
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
8
3
4
,
1
5
4
.
3
8
$
2
7
2
,
7
5
5
.
1
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
8
,
7
9
3
.
8
6
$
4
,
7
5
3
,
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
,
8
3
7
,
4
9
2
.
8
8
($
1
5
,
1
8
3
.
2
2
)
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
$
1
,
0
3
5
,
5
6
8
.
8
0
$
8
2
,
9
1
8
.
8
0
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$6
0
7
,
9
0
0
.
0
0
$
4
7
8
,
7
1
9
.
2
5
($
1
2
9
,
1
8
0
.
7
5
)
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
8
6
,
2
6
5
.
1
6
$
1
1
,
4
1
5
.
7
3
Ot
h
e
r
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
s
$2
9
7
,
9
9
7
.
6
8
$
4
3
6
,
0
7
6
.
1
1
$
1
3
8
,
0
7
8
.
4
3
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
1
9
2
,
0
7
6
.
2
2
$
7
2
,
0
7
6
.
2
2
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
$
3
6
4
,
3
0
2
.
1
3
$
5
1
,
5
4
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
3
,
4
5
8
.
0
9
($
2
,
5
3
6
.
9
1
)
To
t
a
l
s
$3
4
,
0
4
4
,
5
9
4
.
9
7
$
3
9
,
5
4
4
,
9
4
0
.
8
6
$
5
,
5
0
0
,
3
4
5
.
8
9
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending October 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 1/14/22 As of 1/14/22 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $12,745,914.68 $0.00 $12,745,914.68 $693,718.20 $693,718.20
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 $12,778,432.01 $0.00 $12,778,432.01 $726,235.53 $726,235.53
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $681,873.36 $0.00 $681,873.36 $85,873.36 $85,873.36
10‐100‐403010 Gasoline Tax $1,170,000.00 $1,165,347.15 $0.00 $1,165,347.15 ($4,652.85)($4,652.85)
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 $2,453,657.42 $0.00 $2,453,657.42 $97,657.42 $97,657.42
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $94,804.62 $0.00 $94,804.62 ($5,195.38)($5,195.38)
$100,000.00 $94,804.62 $0.00 $94,804.62 ($5,195.38)($5,195.38)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $3,921,756.98 $0.00 $3,921,756.98 ($78,243.02)($78,243.02)
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 $814,254.60 $0.00 $814,254.60 ($85,745.40)($85,745.40)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $1,242,044.72 $0.00 $1,242,044.72 ($357,955.28)($357,955.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 $325,000.00 $293,083.63 $0.00 $293,083.63 ($31,916.37)($31,916.37)
$6,825,000.00 $6,271,139.93 $0.00 $6,271,139.93 ($553,860.07)($553,860.07)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $4,978,699.90 $0.00 $4,978,699.90 $103,699.90 $103,699.90
10‐100‐420020 Del Property Tax $47,000.00 $157,405.98 $0.00 $157,405.98 $110,405.98 $110,405.98
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 $35,404.88 $0.00 $35,404.88 $6,404.88 $6,404.88
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,914.78 $0.00 $512,914.78 $42,914.78 $42,914.78
10‐100‐420080 Special Tax Rev $56,000.00 $77,192.00 $0.00 $77,192.00 $21,192.00 $21,192.00
$5,561,399.28 $5,834,154.38 $0.00 $5,834,154.38 $272,755.10 $272,755.10
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 $39,988.00 $0.00 $39,988.00 $39,988.00 $39,988.00
$5,170.00 $4,758,793.86 $0.00 $4,758,793.86 $4,753,623.86 $4,753,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 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10‐100‐440210 Street Cuts $30,000.00 $37,958.00 $0.00 $37,958.00 $7,958.00 $7,958.00
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $10,160.09 $0.00 $10,160.09 ($839.91)($839.91)
10‐100‐440920 Parts Charge backs $221,206.58 $213,907.10 $0.00 $213,907.10 ($7,299.48)($7,299.48)
10‐100‐440930 Labor Charge backs $249,445.72 $219,540.48 $0.00 $219,540.48 ($29,905.24)($29,905.24)
10‐100‐481020 Cole Cty Animal Rescue $115,034.90 $115,034.92 $0.00 $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 $0.00 $1,000.00 ($11,000.00)($11,000.00)
10‐100‐481045 Rent‐tower Sites $165,000.00 $186,142.99 $0.00 $186,142.99 $21,142.99 $21,142.99
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 $398,992.14 $0.00 $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 $17,652.50 $0.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 $20,530.00 $0.00 $20,530.00 ($50.72)($50.72)
10‐100‐481110 Long & Short $0.00 $1,933.66 $0.00 $1,933.66 $1,933.66 $1,933.66
$2,852,676.10 $2,837,492.88 $0.00 $2,837,492.88 ($15,183.22)($15,183.22)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $78,463.33 $0.00 $78,463.33 $8,463.33 $8,463.33
10‐100‐450020 Business Licenses $220,000.00 $211,947.60 $0.00 $211,947.60 ($8,052.40)($8,052.40)
10‐100‐450021 Home Occupation Permit $1,800.00 $2,695.00 $0.00 $2,695.00 $895.00 $895.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 $8,515.62 $0.00 $8,515.62 $515.62 $515.62
10‐100‐450045 Building Construct. Fees $315,000.00 $370,218.26 $0.00 $370,218.26 $55,218.26 $55,218.26
10‐100‐450050 Electrical Certificates $22,000.00 $28,626.00 $0.00 $28,626.00 $6,626.00 $6,626.00
10‐100‐450060 Electrical Permits $4,400.00 $10,336.33 $0.00 $10,336.33 $5,936.33 $5,936.33
10‐100‐450070 Plumbing Licenses $12,400.00 $11,721.00 $0.00 $11,721.00 ($679.00)($679.00)
10‐100‐450080 Plumbing Permits $8,000.00 $32,641.63 $0.00 $32,641.63 $24,641.63 $24,641.63
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending October 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 1/14/22 As of 1/14/22 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,687.00 $0.00 $1,687.00 ($313.00)($313.00)
10‐100‐450091 Day Care Inspection Fees $6,400.00 $4,640.00 $0.00 $4,640.00 ($1,760.00)($1,760.00)
10‐100‐450092 Food Inspection Fees $86,000.00 $90,274.99 $0.00 $90,274.99 $4,274.99 $4,274.99
10‐100‐450100 Curb Cut Permits $1,000.00 $1,755.00 $0.00 $1,755.00 $755.00 $755.00
10‐100‐450110 Board Of Adj Fees $1,000.00 $1,600.00 $0.00 $1,600.00 $600.00 $600.00
10‐100‐450120 Sign Permits $6,900.00 $7,429.00 $0.00 $7,429.00 $529.00 $529.00
10‐100‐450130 Demolition Permits $1,800.00 $4,126.00 $0.00 $4,126.00 $2,326.00 $2,326.00
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $6,996.90 $0.00 $6,996.90 ($2,003.10)($2,003.10)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $1,618.14 $0.00 $1,618.14 $468.14 $468.14
10‐100‐450170 Animal Redemption Fees $98,000.00 $95,919.00 $0.00 $95,919.00 ($2,081.00)($2,081.00)
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $4,525.00 $0.00 $4,525.00 ($675.00)($675.00)
10‐100‐450185 Animal Cremation Fees $50,000.00 $40,865.00 $0.00 $40,865.00 ($9,135.00)($9,135.00)
10‐100‐450186 Animal Boarding Fees $0.00 $1,220.00 $0.00 $1,220.00 $1,220.00 $1,220.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 $0.00 $272.00 ($528.00)($528.00)
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 $15,821.00 $0.00 $15,821.00 ($4,179.00)($4,179.00)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,455.00 $0.00 $1,455.00 ($345.00)($345.00)
$952,650.00 $1,035,568.80 $0.00 $1,035,568.80 $82,918.80 $82,918.80
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $39,784.84 $0.00 $39,784.84 ($17,215.16)($17,215.16)
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,613.42 $0.00 $6,613.42 ($2,886.58)($2,886.58)
10‐100‐460020 Jail Cost Recovery $1,100.00 $51.10 $0.00 $51.10 ($1,048.90)($1,048.90)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $6,452.81 $0.00 $6,452.81 $2,252.81 $2,252.81
10‐100‐460030 Pol Fines‐traffic $500,000.00 $398,619.43 $0.00 $398,619.43 ($101,380.57)($101,380.57)
10‐100‐460090 Parking Fines $40,000.00 $32,961.50 $0.00 $32,961.50 ($7,038.50)($7,038.50)
10‐100‐460100 Bankcard Charges ($3,900.00)($5,978.85)$0.00 ($5,978.85)($2,078.85)($2,078.85)
$607,900.00 $478,719.25 $0.00 $478,719.25 ($129,180.75)($129,180.75)
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,527.43 $0.00 $17,527.43 $220.00 $220.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 $26,193.11 $0.00 $26,193.11 $11,193.11 $11,193.11
10‐100‐481055 Street Repair‐Solid Waste Cntr $341,542.00 $341,544.62 $0.00 $341,544.62 $2.62 $2.62
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$374,849.43 $386,265.16 $0.00 $386,265.16 $11,415.73 $11,415.73
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 $44,505.95 $0.00 $44,505.95 ($26,521.50)($26,521.50)
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 $15,689.51 $0.00 $15,689.51 ($2,310.49)($2,310.49)
10‐100‐481077 Insurance Claims $198,970.23 $345,984.40 $0.00 $345,984.40 $147,014.17 $147,014.17
10‐100‐481078 Cafeteria Refunds $10,000.00 $29,562.97 $0.00 $29,562.97 $19,562.97 $19,562.97
$297,997.68 $436,076.11 $0.00 $436,076.11 $138,078.43 $138,078.43
Interest Income
10‐100‐470010 Interest $120,000.00 $192,076.22 $0.00 $192,076.22 $72,076.22 $72,076.22
$120,000.00 $192,076.22 $0.00 $192,076.22 $72,076.22 $72,076.22
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $364,302.13 $0.00 $364,302.13 $51,541.13 $51,541.13
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $364,302.13 $0.00 $364,302.13 $51,541.13 $51,541.13
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $23,863.09 $0.00 $23,863.09 ($2,536.91)($2,536.91)
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,623,458.09 $0.00 $1,623,458.09 ($2,536.91)($2,536.91)
$34,044,594.97 $39,544,940.86 $0.00 $39,544,940.86 $5,500,345.89 $5,500,345.89