HomeMy Public PortalAbout2021-05 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
A
p
r
i
l
3
0
,
2
0
2
1
Da
t
a
a
s
o
f
M
a
y
1
0
,
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
5
/
1
0
/
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
$
4
,
8
2
9
,
9
5
1
.
3
0
$
6
1
,
9
5
1
.
0
6
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
,
1
6
4
,
4
3
8
.
3
9
$
1
2
,
3
2
5
.
2
4
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
3
7
,
6
6
6
.
5
6
($
1
,
3
3
1
.
1
0
)
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
$
2
,
5
8
8
,
9
8
3
.
6
4
($
2
8
0
,
3
2
2
.
1
8
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
6
6
3
,
7
6
2
.
7
5
$
2
4
7
,
3
8
6
.
0
2
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
7
1
0
,
7
8
9
.
1
8
$
7
0
5
,
6
1
9
.
1
8
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
,
1
6
5
,
1
9
6
.
5
8
($
1
3
,
5
3
0
.
3
1
)
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
$
4
9
9
,
0
5
2
.
8
5
$
9
1
,
9
8
0
.
6
4
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$6
0
7
,
9
0
0
.
0
0
$
2
6
5
,
9
9
4
.
5
2
($
6
3
,
1
1
5
.
4
4
)
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
$
1
4
3
,
9
0
3
.
9
1
$
6
,
3
7
5
.
9
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
$
1
9
5
,
0
5
7
.
2
4
$
3
5
,
6
7
1
.
5
6
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
5
8
,
7
4
5
.
3
3
$
5
,
7
0
7
.
6
1
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
1
,
0
1
5
.
0
0
$
3
1
5
.
0
0
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
0
9
,
0
9
7
.
1
8
($
3
,
3
8
5
.
9
3
)
To
t
a
l
s
$3
3
,
9
6
7
,
8
1
7
.
9
3
$
1
9
,
9
4
3
,
6
5
4
.
4
3
$
8
0
5
,
6
4
7
.
2
6
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending April 30, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 5/10/21 As of 5/10/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $4,797,433.97 $7,284,196.24 $12,081,630.21 $29,433.73 $29,433.73
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 $4,829,951.30 $7,284,196.24 $12,114,147.54 $61,951.06 $61,951.06
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $208,898.67 $410,577.88 $619,476.55 $23,476.55 $23,476.55
10‐100‐403010 Gasoline Tax $1,170,000.00 $349,102.81 $793,308.97 $1,142,411.78 ($27,588.22)($27,588.22)
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,164,438.39 $1,203,886.85 $2,368,325.24 $12,325.24 $12,325.24
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $37,666.56 $61,002.34 $98,668.90 ($1,331.10)($1,331.10)
$100,000.00 $37,666.56 $61,002.34 $98,668.90 ($1,331.10)($1,331.10)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $1,355,855.16 $2,531,408.34 $3,887,263.50 ($112,736.50)($112,736.50)
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 $531,996.97 $302,839.88 $834,836.85 ($65,163.15)($65,163.15)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $558,896.99 $911,247.21 $1,470,144.20 ($129,855.80)($129,855.80)
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 $142,234.52 $209,198.74 $351,433.26 $26,433.26 $26,433.26
$6,825,000.00 $2,588,983.64 $3,955,694.18 $6,544,677.82 ($280,322.18)($280,322.18)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $4,919,884.89 $63,669.12 $4,983,554.01 $108,554.01 $108,554.01
10‐100‐420020 Del Property Tax $47,000.00 $112,098.25 $23,340.79 $135,439.04 $88,439.04 $88,439.04
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 $12,309.43 $16,121.77 $28,431.20 ($568.80)($568.80)
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 $508,458.95 $5,689.00 $514,147.95 $44,147.95 $44,147.95
10‐100‐420080 Special Tax Rev $56,000.00 $38,474.39 $36,201.87 $74,676.26 $18,676.26 $18,676.26
$5,561,399.28 $5,663,762.75 $145,022.55 $5,808,785.30 $247,386.02 $247,386.02
Intergovernmental
10‐100‐430010 Federal Grant $0.00 $633,553.47 $0.00 $633,553.47 $633,553.47 $633,553.47
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 $50,821.35 $0.00 $50,821.35 $50,821.35 $50,821.35
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 $9,988.00 $0.00 $9,988.00 $9,988.00 $9,988.00
$5,170.00 $710,789.18 $0.00 $710,789.18 $705,619.18 $705,619.18
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 $20,340.00 $15,124.81 $35,464.81 $5,464.81 $5,464.81
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $3,115.10 $5,548.00 $8,663.10 ($2,336.90)($2,336.90)
10‐100‐440920 Parts Charge backs $221,206.58 $105,676.60 $117,302.50 $222,979.10 $1,772.52 $1,772.52
10‐100‐440930 Labor Charge backs $249,445.72 $105,688.95 $117,529.38 $223,218.33 ($26,227.39)($26,227.39)
10‐100‐481020 Cole Cty Animal Rescue $115,034.90 $57,517.46 $57,517.46 $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 $600.00 $12,000.00 $12,600.00 $600.00 $600.00
10‐100‐481045 Rent‐tower Sites $165,000.00 $64,829.42 $104,771.85 $169,601.27 $4,601.27 $4,601.27
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 $198,689.04 $199,838.10 $398,527.14 ($1,149.04)($1,149.04)
10‐100‐481080 Sale Of Maps/GIS Data $0.00 $40.00 $0.00 $40.00 $40.00 $40.00
10‐100‐481085 Cole Cty GIS Joint Coop $15,000.00 $10,152.50 $7,500.00 $17,652.50 $2,652.50 $2,652.50
10‐100‐481100 Sale Of Grave Sites $2,085.00 $1,668.00 $1,517.11 $3,185.11 $1,100.11 $1,100.11
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.51 $0.00 $2.51 $2.51 $2.51
$2,852,676.10 $2,165,196.58 $673,949.21 $2,839,145.79 ($13,530.31)($13,530.31)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $59,432.08 $30,205.32 $89,637.40 $19,637.40 $19,637.40
10‐100‐450020 Business Licenses $220,000.00 $101,262.99 $98,124.26 $199,387.25 ($20,612.75)($20,612.75)
10‐100‐450021 Home Occupation Permit $1,800.00 $1,650.00 $1,350.00 $3,000.00 $1,200.00 $1,200.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 $5,555.00 $4,000.00 $9,555.00 $1,555.00 $1,555.00
10‐100‐450045 Building Construct. Fees $315,000.00 $200,212.76 $203,167.08 $403,379.84 $88,379.84 $88,379.84
10‐100‐450050 Electrical Certificates $22,000.00 $16,734.00 $3,314.23 $20,048.23 ($1,951.77)($1,951.77)
10‐100‐450060 Electrical Permits $4,400.00 $2,274.71 $2,479.96 $4,754.67 $354.67 $354.67
10‐100‐450070 Plumbing Licenses $12,400.00 $9,375.00 $1,369.95 $10,744.95 ($1,655.05)($1,655.05)
10‐100‐450080 Plumbing Permits $8,000.00 $5,714.38 $4,362.74 $10,077.12 $2,077.12 $2,077.12
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending April 30, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 5/10/21 As of 5/10/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,337.00 $1,326.21 $2,663.21 $663.21 $663.21
10‐100‐450091 Day Care Inspection Fees $6,400.00 $1,835.00 $2,747.22 $4,582.22 ($1,817.78)($1,817.78)
10‐100‐450092 Food Inspection Fees $86,000.00 $7,928.99 $80,256.62 $88,185.61 $2,185.61 $2,185.61
10‐100‐450100 Curb Cut Permits $1,000.00 $1,040.00 $728.20 $1,768.20 $768.20 $768.20
10‐100‐450110 Board Of Adj Fees $1,000.00 $800.00 $556.20 $1,356.20 $356.20 $356.20
10‐100‐450120 Sign Permits $6,900.00 $4,620.00 $3,778.12 $8,398.12 $1,498.12 $1,498.12
10‐100‐450130 Demolition Permits $1,800.00 $1,763.00 $557.75 $2,320.75 $520.75 $520.75
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $3,264.90 $4,321.15 $7,586.05 ($1,413.95)($1,413.95)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $350.54 $848.27 $1,198.81 $48.81 $48.81
10‐100‐450170 Animal Redemption Fees $98,000.00 $39,581.50 $59,124.04 $98,705.54 $705.54 $705.54
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $2,325.00 $2,582.25 $4,907.25 ($292.75)($292.75)
10‐100‐450185 Animal Cremation Fees $50,000.00 $21,095.00 $28,582.04 $49,677.04 ($322.96)($322.96)
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 $136.00 $266.67 $402.67 ($397.33)($397.33)
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 $9,405.00 $11,009.24 $20,414.24 $414.24 $414.24
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $140.00 $520.28 $660.28 ($1,139.72)($1,139.72)
$952,650.00 $499,052.85 $545,577.79 $1,044,630.64 $91,980.64 $91,980.64
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $23,116.04 $26,939.26 $50,055.30 ($6,944.70)($6,944.70)
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 $3,848.85 $4,494.56 $8,343.41 ($1,156.59)($1,156.59)
10‐100‐460020 Jail Cost Recovery $1,100.00 $51.10 $462.46 $513.56 ($586.44)($586.44)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $3,739.63 $2,357.03 $6,096.66 $1,896.66 $1,896.66
10‐100‐460030 Pol Fines‐traffic $500,000.00 $224,087.62 $235,009.91 $459,097.53 ($40,902.47)($40,902.47)
10‐100‐460090 Parking Fines $40,000.00 $13,879.50 $11,930.63 $25,810.13 ($14,189.87)($14,189.87)
10‐100‐460100 Bankcard Charges ($3,900.00)($2,728.22)($2,403.81)($5,132.03)($1,232.03)($1,232.03)
$607,900.00 $265,994.52 $278,790.04 $544,784.56 ($63,115.44)($63,115.44)
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,407.43 $0.00 $17,407.43 $100.00 $100.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 $13,053.81 $8,220.25 $21,274.06 $6,274.06 $6,274.06
10‐100‐481055 Street Repair‐Solid Waste Cntr $341,542.00 $112,442.67 $229,101.18 $341,543.85 $1.85 $1.85
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$374,849.43 $143,903.91 $237,321.43 $381,225.34 $6,375.91 $6,375.91
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 $32,086.00 $20,700.55 $52,786.55 ($18,240.90)($18,240.90)
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 $5,736.20 $11,134.41 $16,870.61 ($1,129.39)($1,129.39)
10‐100‐481077 Insurance Claims $122,193.19 $157,235.04 $20,000.00 $177,235.04 $55,041.85 $55,041.85
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$221,220.64 $195,057.24 $61,834.96 $256,892.20 $35,671.56 $35,671.56
Interest Income
10‐100‐470010 Interest $120,000.00 $58,745.33 $66,962.28 $125,707.61 $5,707.61 $5,707.61
$120,000.00 $58,745.33 $66,962.28 $125,707.61 $5,707.61 $5,707.61
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $11,015.00 $302,061.00 $313,076.00 $315.00 $315.00
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $11,015.00 $302,061.00 $313,076.00 $315.00 $315.00
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $9,502.18 $13,511.89 $23,014.07 ($3,385.93)($3,385.93)
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,609,097.18 $13,511.89 $1,622,609.07 ($3,385.93)($3,385.93)
$33,967,817.93 $19,943,654.43 $14,829,810.76 $34,773,465.19 $805,647.26 $805,647.26