HomeMy Public PortalAbout2021-11 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
1
Da
t
a
a
s
o
f
N
o
v
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
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
$
1
1
,
5
4
6
,
8
6
8
.
1
6
$
6
1
2
,
2
9
9
.
9
1
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
,
1
3
9
,
2
8
7
.
2
4
$
8
2
,
9
8
2
.
7
5
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
8
6
,
6
6
0
.
0
6
($
5
,
7
8
3
.
6
3
)
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
,
7
8
5
,
6
2
3
.
3
7
($
6
0
6
,
3
1
0
.
7
9
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
8
0
5
,
5
0
2
.
1
9
$
2
5
4
,
3
4
5
.
4
9
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
4
6
,
6
8
6
.
8
8
($
3
,
2
1
9
.
9
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
,
6
0
4
.
8
4
$
8
4
,
2
6
8
.
3
6
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
2
8
,
3
5
7
.
1
8
$
9
,
7
2
9
.
7
6
Ot
h
e
r
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
s
$2
5
5
,
3
7
2
.
8
9
$
3
9
4
,
7
0
9
.
5
1
$
1
4
1
,
0
1
3
.
8
0
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
0
1
,
9
7
0
.
1
8
$
3
7
,
3
6
9
,
1
1
4
.
8
2
$
5
,
3
0
4
,
2
4
3
.
9
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 11/8/21 As of 11/8/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $11,514,350.83 $1,117,628.23 $12,631,979.06 $579,782.58 $579,782.58
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 $11,546,868.16 $1,117,628.23 $12,664,496.39 $612,299.91 $612,299.91
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $581,106.09 $98,719.59 $679,825.68 $83,825.68 $83,825.68
10‐100‐403010 Gasoline Tax $1,170,000.00 $951,744.24 $200,975.93 $1,152,720.17 ($17,279.83)($17,279.83)
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,139,287.24 $299,695.51 $2,438,982.75 $82,982.75 $82,982.75
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $86,660.06 $7,556.31 $94,216.37 ($5,783.63)($5,783.63)
$100,000.00 $86,660.06 $7,556.31 $94,216.37 ($5,783.63)($5,783.63)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $3,562,288.35 $254,977.25 $3,817,265.60 ($182,734.40)($182,734.40)
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 $781,277.15 $35,597.33 $816,874.48 ($83,125.52)($83,125.52)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $1,149,011.30 $117,171.94 $1,266,183.24 ($333,816.76)($333,816.76)
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,046.57 $25,319.33 $318,365.90 ($6,634.10)($6,634.10)
$6,825,000.00 $5,785,623.37 $433,065.84 $6,218,689.21 ($606,310.79)($606,310.79)
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 $137,645.68 $0.00 $137,645.68 $90,645.68 $90,645.68
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 $30,522.18 $540.15 $31,062.33 $2,062.33 $2,062.33
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,886.65 $0.00 $512,886.65 $42,886.65 $42,886.65
10‐100‐420080 Special Tax Rev $56,000.00 $73,210.94 $9,702.43 $82,913.37 $26,913.37 $26,913.37
$5,561,399.28 $5,805,502.19 $10,242.58 $5,815,744.77 $254,345.49 $254,345.49
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,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 $1,070.45 $11,230.54 $230.54 $230.54
10‐100‐440920 Parts Charge backs $221,206.58 $213,907.10 ($435.98)$213,471.12 ($7,735.46)($7,735.46)
10‐100‐440930 Labor Charge backs $249,445.72 $219,540.48 ($380.62)$219,159.86 ($30,285.86)($30,285.86)
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 $1,988.32 $188,131.31 $23,131.31 $23,131.31
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 $2,769.23 $2,849,456.11 ($3,219.99)($3,219.99)
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,029.92 $0.00 $370,029.92 $55,029.92 $55,029.92
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 11/8/21 As of 11/8/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $2,362.00 ($491.69)$1,870.31 ($129.69)($129.69)
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 ($2,621.71)$89,695.28 $3,695.28 $3,695.28
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 $41.10 $7,038.00 ($1,962.00)($1,962.00)
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,604.84 $1,313.52 $1,036,918.36 $84,268.36 $84,268.36
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 $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 $328,357.18 $56,222.01 $384,579.19 $9,729.76 $9,729.76
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,747.78 $0.00 $43,747.78 ($27,279.67)($27,279.67)
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 $14,491.04 $1,677.18 $16,168.22 ($1,831.78)($1,831.78)
10‐100‐481077 Insurance Claims $156,345.44 $306,574.44 $0.00 $306,574.44 $150,229.00 $150,229.00
10‐100‐481078 Cafeteria Refunds $10,000.00 $29,562.97 $0.00 $29,562.97 $19,562.97 $19,562.97
$255,372.89 $394,709.51 $1,677.18 $396,386.69 $141,013.80 $141,013.80
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,001,970.18 $37,369,114.82 $1,937,099.35 $39,306,214.17 $5,304,243.99 $5,304,243.99