HomeMy Public PortalAbout2021-06 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
M
a
y
3
1
,
2
0
2
1
Da
t
a
a
s
o
f
J
u
n
e
9
,
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
6
/
9
/
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
$
6
,
1
2
7
,
0
0
8
.
3
9
$
2
7
9
,
5
3
2
.
9
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
$
1
,
3
3
8
,
1
8
7
.
6
8
$
4
6
,
9
4
3
.
9
6
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
4
5
,
8
8
8
.
5
6
($
1
,
5
9
9
.
4
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
$
2
,
9
7
7
,
1
7
0
.
1
1
($
4
0
0
,
5
1
5
.
4
7
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
6
9
7
,
9
3
8
.
6
6
$
2
5
2
,
6
9
8
.
3
6
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
4
,
5
0
9
,
0
7
9
.
6
8
$
4
,
5
0
3
,
9
0
9
.
6
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
,
2
4
4
,
1
0
2
.
2
5
($
3
7
,
4
2
3
.
0
3
)
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
$
6
7
7
,
8
6
8
.
0
7
$
9
2
,
0
8
5
.
4
1
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$6
0
7
,
9
0
0
.
0
0
$
3
0
0
,
5
4
4
.
0
2
($
6
8
,
6
5
0
.
3
0
)
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
7
,
3
2
2
.
3
6
$
8
,
2
7
7
.
0
8
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
$
2
4
5
,
9
0
9
.
9
3
$
8
3
,
4
3
9
.
5
5
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
7
6
,
3
7
1
.
5
7
$
1
1
,
8
8
8
.
4
0
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
,
4
6
2
.
0
0
$
7
6
2
.
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
1
1
,
3
9
3
.
0
3
($
3
,
3
3
0
.
0
2
)
To
t
a
l
s
$3
3
,
9
6
7
,
8
1
7
.
9
3
$
2
6
,
0
1
0
,
2
4
6
.
3
1
$
4
,
7
6
8
,
0
1
9
.
0
7
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending May 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 6/9/21 As of 6/9/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $6,094,491.06 $6,204,720.99 $12,299,212.05 $247,015.57 $247,015.57
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 $6,127,008.39 $6,204,720.99 $12,331,729.38 $279,532.90 $279,532.90
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $286,418.52 $368,483.44 $654,901.96 $58,901.96 $58,901.96
10‐100‐403010 Gasoline Tax $1,170,000.00 $445,332.25 $696,272.83 $1,141,605.08 ($28,394.92)($28,394.92)
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,338,187.68 $1,064,756.28 $2,402,943.96 $46,943.96 $46,943.96
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $45,888.56 $52,512.00 $98,400.56 ($1,599.44)($1,599.44)
$100,000.00 $45,888.56 $52,512.00 $98,400.56 ($1,599.44)($1,599.44)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $1,577,500.75 $2,297,791.09 $3,875,291.84 ($124,708.16)($124,708.16)
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 $597,314.95 $217,810.18 $815,125.13 ($84,874.87)($84,874.87)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $660,119.89 $771,624.83 $1,431,744.72 ($168,255.28)($168,255.28)
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 $159,088.32 $301,322.84 ($23,677.16)($23,677.16)
$6,825,000.00 $2,977,170.11 $3,447,314.42 $6,424,484.53 ($400,515.47)($400,515.47)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $4,944,726.62 $42,609.85 $4,987,336.47 $112,336.47 $112,336.47
10‐100‐420020 Del Property Tax $47,000.00 $116,471.11 $20,576.41 $137,047.52 $90,047.52 $90,047.52
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 $15,820.34 $13,362.57 $29,182.91 $182.91 $182.91
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 $509,516.75 $4,484.32 $514,001.07 $44,001.07 $44,001.07
10‐100‐420080 Special Tax Rev $56,000.00 $38,867.00 $35,125.82 $73,992.82 $17,992.82 $17,992.82
$5,561,399.28 $5,697,938.66 $116,158.98 $5,814,097.64 $252,698.36 $252,698.36
Intergovernmental
10‐100‐430010 Federal Grant $0.00 $4,426,843.97 $0.00 $4,426,843.97 $4,426,843.97 $4,426,843.97
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 $14,988.00 $0.00 $14,988.00 $14,988.00 $14,988.00
$5,170.00 $4,509,079.68 $0.00 $4,509,079.68 $4,503,909.68 $4,503,909.68
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 $22,780.00 $13,358.83 $36,138.83 $6,138.83 $6,138.83
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $3,895.17 $4,790.63 $8,685.80 ($2,314.20)($2,314.20)
10‐100‐440920 Parts Charge backs $221,206.58 $123,602.60 $75,214.16 $198,816.76 ($22,389.82)($22,389.82)
10‐100‐440930 Labor Charge backs $249,445.72 $125,266.98 $96,613.57 $221,880.55 ($27,565.17)($27,565.17)
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 $67,960.14 $100,902.63 $168,862.77 $3,862.77 $3,862.77
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 $232,072.89 $166,531.75 $398,604.64 ($1,071.54)($1,071.54)
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 $11,402.50 $7,500.00 $18,902.50 $3,902.50 $3,902.50
10‐100‐481100 Sale Of Grave Sites $2,085.00 $2,085.00 $1,421.78 $3,506.78 $1,421.78 $1,421.78
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,244,102.25 $571,150.82 $2,815,253.07 ($37,423.03)($37,423.03)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $71,552.08 $13,551.72 $85,103.80 $15,103.80 $15,103.80
10‐100‐450020 Business Licenses $220,000.00 $119,568.29 $71,883.86 $191,452.15 ($28,547.85)($28,547.85)
10‐100‐450021 Home Occupation Permit $1,800.00 $1,815.00 $981.82 $2,796.82 $996.82 $996.82
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 $7,005.00 $3,333.33 $10,338.33 $2,338.33 $2,338.33
10‐100‐450045 Building Construct. Fees $315,000.00 $221,946.04 $166,972.15 $388,918.19 $73,918.19 $73,918.19
10‐100‐450050 Electrical Certificates $22,000.00 $17,259.00 $2,194.19 $19,453.19 ($2,546.81)($2,546.81)
10‐100‐450060 Electrical Permits $4,400.00 $3,344.71 $2,218.68 $5,563.39 $1,163.39 $1,163.39
10‐100‐450070 Plumbing Licenses $12,400.00 $10,227.00 $1,145.90 $11,372.90 ($1,027.10)($1,027.10)
10‐100‐450080 Plumbing Permits $8,000.00 $27,295.01 $4,362.74 $31,657.75 $23,657.75 $23,657.75
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending May 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 6/9/21 As of 6/9/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,337.00 $1,240.70 $2,577.70 $577.70 $577.70
10‐100‐450091 Day Care Inspection Fees $6,400.00 $2,395.00 $2,560.68 $4,955.68 ($1,444.32)($1,444.32)
10‐100‐450092 Food Inspection Fees $86,000.00 $90,996.24 ($3,092.58)$87,903.66 $1,903.66 $1,903.66
10‐100‐450100 Curb Cut Permits $1,000.00 $1,205.00 $655.98 $1,860.98 $860.98 $860.98
10‐100‐450110 Board Of Adj Fees $1,000.00 $1,600.00 $556.20 $2,156.20 $1,156.20 $1,156.20
10‐100‐450120 Sign Permits $6,900.00 $5,067.00 $3,442.38 $8,509.38 $1,609.38 $1,609.38
10‐100‐450130 Demolition Permits $1,800.00 $1,763.00 $507.04 $2,270.04 $470.04 $470.04
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $3,876.90 $3,656.94 $7,533.84 ($1,466.16)($1,466.16)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $656.30 $837.33 $1,493.63 $343.63 $343.63
10‐100‐450170 Animal Redemption Fees $98,000.00 $48,771.50 $52,295.24 $101,066.74 $3,066.74 $3,066.74
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $2,625.00 $2,174.06 $4,799.06 ($400.94)($400.94)
10‐100‐450185 Animal Cremation Fees $50,000.00 $25,357.00 $25,088.70 $50,445.70 $445.70 $445.70
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 $200.00 $336.00 ($464.00)($464.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 $20,000.00 $10,205.00 $9,660.69 $19,865.69 ($134.31)($134.31)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $645.00 $439.61 $1,084.61 ($715.39)($715.39)
$952,650.00 $677,868.07 $366,867.34 $1,044,735.41 $92,085.41 $92,085.41
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $25,808.73 $23,221.67 $49,030.40 ($7,969.60)($7,969.60)
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 $4,299.00 $3,876.20 $8,175.20 ($1,324.80)($1,324.80)
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 $4,154.55 $2,190.41 $6,344.96 $2,144.96 $2,144.96
10‐100‐460030 Pol Fines‐traffic $500,000.00 $252,112.09 $202,319.50 $454,431.59 ($45,568.41)($45,568.41)
10‐100‐460090 Parking Fines $40,000.00 $17,324.50 $8,670.33 $25,994.83 ($14,005.17)($14,005.17)
10‐100‐460100 Bankcard Charges ($3,900.00)($3,205.95)($2,034.89)($5,240.84)($1,340.84)($1,340.84)
$607,900.00 $300,544.02 $238,705.68 $539,249.70 ($68,650.30)($68,650.30)
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 $16,472.26 $6,702.97 $23,175.23 $8,175.23 $8,175.23
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 $147,322.36 $235,804.15 $383,126.51 $8,277.08 $8,277.08
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 $33,026.90 $19,735.85 $52,762.75 ($18,264.70)($18,264.70)
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 $7,471.93 $9,014.41 $16,486.34 ($1,513.66)($1,513.66)
10‐100‐481077 Insurance Claims $122,193.19 $205,077.82 $20,000.00 $225,077.82 $102,884.63 $102,884.63
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$221,220.64 $245,909.93 $58,750.26 $304,660.19 $83,439.55 $83,439.55
Interest Income
10‐100‐470010 Interest $120,000.00 $76,371.57 $55,516.83 $131,888.40 $11,888.40 $11,888.40
$120,000.00 $76,371.57 $55,516.83 $131,888.40 $11,888.40 $11,888.40
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $11,462.00 $302,061.00 $313,523.00 $762.00 $762.00
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $11,462.00 $302,061.00 $313,523.00 $762.00 $762.00
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $11,798.03 $11,271.95 $23,069.98 ($3,330.02)($3,330.02)
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,611,393.03 $11,271.95 $1,622,664.98 ($3,330.02)($3,330.02)
$33,967,817.93 $26,010,246.31 $12,725,590.69 $38,735,837.00 $4,768,019.07 $4,768,019.07