HomeMy Public PortalAbout2021-12 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
N
o
v
e
m
b
e
r
3
0
,
2
0
2
1
Da
t
a
a
s
o
f
D
e
c
e
m
b
e
r
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
2
/
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
$
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
,
2
9
2
,
5
7
3
.
1
7
$
8
9
,
6
3
4
.
6
0
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
9
3
,
8
6
9
.
0
2
($
6
,
1
3
0
.
9
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
0
4
.
3
6
($
5
5
3
,
8
9
5
.
6
4
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
8
3
9
,
0
3
3
.
5
5
$
2
7
7
,
6
3
4
.
2
7
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
5
,
3
8
5
,
9
9
4
.
2
5
$
5
,
3
8
0
,
8
2
4
.
2
5
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
4
6
,
6
8
6
.
8
8
($
4
,
6
4
2
.
4
9
)
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
,
7
9
3
.
1
8
$
8
7
,
5
2
8
.
9
9
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
5
,
3
7
3
.
1
4
$
1
3
7
,
3
7
5
.
4
6
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
1
7
4
,
5
4
2
.
0
6
$
6
1
,
4
7
0
.
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
$
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
$
4
0
,
0
0
6
,
1
4
6
.
2
5
$
6
,
1
2
7
,
2
7
4
.
1
8
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending November 30, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 12/8/21 As of 12/8/21 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 $632,778.94 $49,453.80 $682,232.74 $86,232.74 $86,232.74
10‐100‐403010 Gasoline Tax $1,170,000.00 $1,053,357.32 $103,607.63 $1,156,964.95 ($13,035.05)($13,035.05)
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,292,573.17 $153,061.43 $2,445,634.60 $89,634.60 $89,634.60
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $93,869.02 $0.00 $93,869.02 ($6,130.98)($6,130.98)
$100,000.00 $93,869.02 $0.00 $93,869.02 ($6,130.98)($6,130.98)
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,009.15 $0.00 $1,242,009.15 ($357,990.85)($357,990.85)
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,104.36 $0.00 $6,271,104.36 ($553,895.64)($553,895.64)
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 $162,387.57 $0.00 $162,387.57 $115,387.57 $115,387.57
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 $36,241.04 $0.00 $36,241.04 $7,241.04 $7,241.04
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,926.52 $0.00 $512,926.52 $42,926.52 $42,926.52
10‐100‐420080 Special Tax Rev $56,000.00 $76,241.68 $0.00 $76,241.68 $20,241.68 $20,241.68
$5,561,399.28 $5,839,033.55 $0.00 $5,839,033.55 $277,634.27 $277,634.27
Intergovernmental
10‐100‐430010 Federal Grant $0.00 $5,098,950.61 $0.00 $5,098,950.61 $5,098,950.61 $5,098,950.61
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 $5,385,994.25 $0.00 $5,385,994.25 $5,380,824.25 $5,380,824.25
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,088.00 $527.07 $37,615.07 $7,615.07 $7,615.07
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $10,160.09 $819.66 $10,979.75 ($20.25)($20.25)
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 $13,000.00 $0.00 $13,000.00 $1,000.00 $1,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 ($2.34)$0.00 ($2.34)($2.34)($2.34)
$2,852,676.10 $2,846,686.88 $1,346.73 $2,848,033.61 ($4,642.49)($4,642.49)
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,255.00 $0.00 $8,255.00 $255.00 $255.00
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 November 30, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 12/8/21 As of 12/8/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $2,362.00 $0.00 $2,362.00 $362.00 $362.00
10‐100‐450091 Day Care Inspection Fees $6,400.00 $4,530.00 $0.00 $4,530.00 ($1,870.00)($1,870.00)
10‐100‐450092 Food Inspection Fees $86,000.00 $92,316.99 $0.00 $92,316.99 $6,316.99 $6,316.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,545.00 $0.00 $4,545.00 ($655.00)($655.00)
10‐100‐450185 Animal Cremation Fees $50,000.00 $38,523.00 $4,385.81 $42,908.81 ($7,091.19)($7,091.19)
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 $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,793.18 $4,385.81 $1,040,178.99 $87,528.99 $87,528.99
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 $43,802.98 $0.00 $43,802.98 ($27,224.47)($27,224.47)
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 $435,373.14 $0.00 $435,373.14 $137,375.46 $137,375.46
Interest Income
10‐100‐470010 Interest $120,000.00 $174,542.06 $6,928.93 $181,470.99 $61,470.99 $61,470.99
$120,000.00 $174,542.06 $6,928.93 $181,470.99 $61,470.99 $61,470.99
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 $40,006,146.25 $165,722.90 $40,171,869.15 $6,127,274.18 $6,127,274.18