HomeMy Public PortalAbout2021-07 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
J
u
n
e
3
0
,
2
0
2
1
Da
t
a
a
s
o
f
J
u
l
y
1
2
,
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
7
/
1
2
/
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
$
7
,
2
3
9
,
6
8
2
.
9
0
$
2
6
7
,
1
5
0
.
5
5
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
,
5
0
3
,
6
1
3
.
6
2
$
8
5
,
0
4
5
.
5
3
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
5
3
,
6
0
2
.
8
6
($
2
,
4
5
9
.
3
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
$
3
,
3
5
7
,
1
9
4
.
8
5
($
4
5
6
,
7
2
8
.
2
7
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
7
1
0
,
3
1
7
.
3
1
$
2
3
4
,
8
3
2
.
9
4
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
4
,
6
8
8
,
8
8
7
.
6
1
$
4
,
6
8
3
,
7
1
7
.
6
1
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
,
3
2
0
,
8
6
6
.
5
3
($
3
1
,
4
8
5
.
0
5
)
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
$
7
7
0
,
0
3
4
.
1
8
$
9
0
,
2
3
1
.
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
$
3
4
1
,
9
9
0
.
9
8
($
7
1
,
3
1
0
.
6
8
)
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
$
2
3
3
,
2
0
8
.
3
6
$
6
,
4
4
3
.
5
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
$
2
6
6
,
7
0
6
.
4
7
$
1
0
1
,
8
8
6
.
1
4
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
9
8
,
6
5
8
.
7
7
$
2
2
,
4
3
1
.
5
4
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
,
5
1
2
.
0
0
($
6
,
9
4
9
.
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
4
,
0
1
4
.
8
9
($
3
,
0
7
0
.
1
4
)
To
t
a
l
s
$3
3
,
9
6
7
,
8
1
7
.
9
3
$
2
8
,
2
1
0
,
2
9
1
.
3
3
$
4
,
9
1
9
,
7
3
7
.
0
1
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending June 30, 2021 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 7/12/21 As of 7/12/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $7,207,165.57 $5,079,664.13 $12,286,829.70 $234,633.22 $234,633.22
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 $7,239,682.90 $5,079,664.13 $12,319,347.03 $267,150.55 $267,150.55
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $348,072.39 $329,174.69 $677,247.08 $81,247.08 $81,247.08
10‐100‐403010 Gasoline Tax $1,170,000.00 $549,104.32 $608,257.22 $1,157,361.54 ($12,638.46)($12,638.46)
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,503,613.62 $937,431.91 $2,441,045.53 $85,045.53 $85,045.53
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $53,602.86 $43,937.84 $97,540.70 ($2,459.30)($2,459.30)
$100,000.00 $53,602.86 $43,937.84 $97,540.70 ($2,459.30)($2,459.30)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $1,805,215.93 $2,052,483.39 $3,857,699.32 ($142,300.68)($142,300.68)
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 $648,231.53 $166,372.47 $814,604.00 ($85,396.00)($85,396.00)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $761,476.98 $637,584.90 $1,399,061.88 ($200,938.12)($200,938.12)
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 $142,270.41 $154,636.13 $296,906.54 ($28,093.46)($28,093.46)
$6,825,000.00 $3,357,194.85 $3,011,076.88 $6,368,271.73 ($456,728.27)($456,728.27)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $4,953,286.19 $22,818.06 $4,976,104.25 $101,104.25 $101,104.25
10‐100‐420020 Del Property Tax $47,000.00 $118,018.65 $16,676.53 $134,695.18 $87,695.18 $87,695.18
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 $17,220.64 $10,426.65 $27,647.29 ($1,352.71)($1,352.71)
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,587.99 $2,066.50 $511,654.49 $41,654.49 $41,654.49
10‐100‐420080 Special Tax Rev $56,000.00 $39,667.00 $33,927.16 $73,594.16 $17,594.16 $17,594.16
$5,561,399.28 $5,710,317.31 $85,914.91 $5,796,232.22 $234,832.94 $234,832.94
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 $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 $14,988.00 $0.00 $14,988.00 $14,988.00 $14,988.00
$5,170.00 $4,688,887.61 $0.00 $4,688,887.61 $4,683,717.61 $4,683,717.61
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 $24,950.00 $10,840.45 $35,790.45 $5,790.45 $5,790.45
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $4,841.79 $4,018.17 $8,859.96 ($2,140.04)($2,140.04)
10‐100‐440920 Parts Charge backs $221,206.58 $123,803.48 $75,013.28 $198,816.76 ($22,389.82)($22,389.82)
10‐100‐440930 Labor Charge backs $249,445.72 $125,761.98 $96,118.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 $106,278.07 $70,623.86 $176,901.93 $11,901.93 $11,901.93
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 $265,456.74 $133,225.40 $398,682.14 ($994.04)($994.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 $12,652.50 $5,000.00 $17,652.50 $2,652.50 $2,652.50
10‐100‐481100 Sale Of Grave Sites $2,085.00 $2,085.00 $667.34 $2,752.34 $667.34 $667.34
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,320,866.53 $500,324.52 $2,821,191.05 ($31,485.05)($31,485.05)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $76,072.08 $5,633.48 $81,705.56 $11,705.56 $11,705.56
10‐100‐450020 Business Licenses $220,000.00 $163,777.48 $41,177.77 $204,955.25 ($15,044.75)($15,044.75)
10‐100‐450021 Home Occupation Permit $1,800.00 $1,980.00 $981.82 $2,961.82 $1,161.82 $1,161.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 $9,230.00 $2,666.67 $11,896.67 $3,896.67 $3,896.67
10‐100‐450045 Building Construct. Fees $315,000.00 $240,283.11 $131,840.99 $372,124.10 $57,124.10 $57,124.10
10‐100‐450050 Electrical Certificates $22,000.00 $18,585.00 $1,741.27 $20,326.27 ($1,673.73)($1,673.73)
10‐100‐450060 Electrical Permits $4,400.00 $7,430.91 $1,764.60 $9,195.51 $4,795.51 $4,795.51
10‐100‐450070 Plumbing Licenses $12,400.00 $10,881.00 $921.84 $11,802.84 ($597.16)($597.16)
10‐100‐450080 Plumbing Permits $8,000.00 $28,407.14 $3,149.62 $31,556.76 $23,556.76 $23,556.76
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending June 30, 2021 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 7/12/21 As of 7/12/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,445.00 $1,240.70 $2,685.70 $685.70 $685.70
10‐100‐450091 Day Care Inspection Fees $6,400.00 $2,995.00 $1,872.18 $4,867.18 ($1,532.82)($1,532.82)
10‐100‐450092 Food Inspection Fees $86,000.00 $91,926.24 ($2,432.72)$89,493.52 $3,493.52 $3,493.52
10‐100‐450100 Curb Cut Permits $1,000.00 $1,260.00 $554.05 $1,814.05 $814.05 $814.05
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,381.00 $3,015.81 $8,396.81 $1,496.81 $1,496.81
10‐100‐450130 Demolition Permits $1,800.00 $2,018.00 $430.99 $2,448.99 $648.99 $648.99
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $4,681.90 $3,031.49 $7,713.39 ($1,286.61)($1,286.61)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $667.82 $757.94 $1,425.76 $275.76 $275.76
10‐100‐450170 Animal Redemption Fees $98,000.00 $57,406.50 $42,489.95 $99,896.45 $1,896.45 $1,896.45
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $3,220.00 $1,703.75 $4,923.75 ($276.25)($276.25)
10‐100‐450185 Animal Cremation Fees $50,000.00 $27,605.00 $21,190.30 $48,795.30 ($1,204.70)($1,204.70)
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 $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,945.00 $7,919.15 $18,864.15 ($1,135.85)($1,135.85)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $680.00 $439.61 $1,119.61 ($680.39)($680.39)
$952,650.00 $770,034.18 $272,847.46 $1,042,881.64 $90,231.64 $90,231.64
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $28,896.05 $19,093.84 $47,989.89 ($9,010.11)($9,010.11)
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,809.84 $3,187.78 $7,997.62 ($1,502.38)($1,502.38)
10‐100‐460020 Jail Cost Recovery $1,100.00 $51.10 $357.53 $408.63 ($691.37)($691.37)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $4,685.08 $1,692.61 $6,377.69 $2,177.69 $2,177.69
10‐100‐460030 Pol Fines‐traffic $500,000.00 $286,560.36 $166,000.61 $452,560.97 ($47,439.03)($47,439.03)
10‐100‐460090 Parking Fines $40,000.00 $20,194.50 $6,300.86 $26,495.36 ($13,504.64)($13,504.64)
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 $341,990.98 $194,598.34 $536,589.32 ($71,310.68)($71,310.68)
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 $18,026.26 $5,001.32 $23,027.58 $8,027.58 $8,027.58
10‐100‐481055 Street Repair‐Solid Waste Cntr $341,542.00 $196,774.67 $143,083.26 $339,857.93 ($1,684.07)($1,684.07)
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$374,849.43 $233,208.36 $148,084.58 $381,292.94 $6,443.51 $6,443.51
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 $34,235.78 $19,055.10 $53,290.88 ($17,736.57)($17,736.57)
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 $9,006.19 $7,345.21 $16,351.40 ($1,648.60)($1,648.60)
10‐100‐481077 Insurance Claims $122,193.19 $223,131.22 $20,000.00 $243,131.22 $120,938.03 $120,938.03
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$221,220.64 $266,706.47 $56,400.31 $323,106.78 $101,886.14 $101,886.14
Interest Income
10‐100‐470010 Interest $120,000.00 $98,658.77 $43,772.77 $142,431.54 $22,431.54 $22,431.54
$120,000.00 $98,658.77 $43,772.77 $142,431.54 $22,431.54 $22,431.54
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $11,512.00 $294,300.00 $305,812.00 ($6,949.00)($6,949.00)
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $11,512.00 $294,300.00 $305,812.00 ($6,949.00)($6,949.00)
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $14,419.89 $8,909.97 $23,329.86 ($3,070.14)($3,070.14)
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,614,014.89 $8,909.97 $1,622,924.86 ($3,070.14)($3,070.14)
$33,967,817.93 $28,210,291.33 $10,677,263.61 $38,887,554.94 $4,919,737.01 $4,919,737.01