HomeMy Public PortalAbout2021-08 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
l
y
3
1
,
2
0
2
1
Da
t
a
a
s
o
f
A
u
g
u
s
t
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
8
/
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
$
8
,
2
3
6
,
3
1
7
.
9
7
$
3
6
2
,
2
9
7
.
6
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
$
1
,
6
7
2
,
4
1
9
.
2
7
$
9
7
,
9
4
2
.
5
7
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
6
2
,
6
6
8
.
7
8
($
2
,
2
6
8
.
6
9
)
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
,
8
1
2
,
2
3
7
.
1
2
($
6
3
4
,
0
7
7
.
9
6
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
7
2
3
,
2
3
7
.
0
6
$
2
3
3
,
1
4
3
.
6
0
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
4
,
7
3
8
,
7
9
3
.
8
6
$
4
,
7
3
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
,
4
5
2
,
9
0
4
.
9
5
($
6
5
,
1
0
3
.
2
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
$
8
5
2
,
5
3
0
.
6
0
$
9
8
,
6
4
6
.
2
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
6
5
,
5
7
6
.
7
5
($
9
4
,
7
9
9
.
6
9
)
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
4
,
3
1
4
.
2
1
$
7
,
2
1
0
.
2
4
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
7
0
,
3
7
8
.
5
5
$
1
0
4
,
3
0
9
.
3
7
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
2
0
,
0
0
0
.
0
0
$
1
1
8
,
3
5
4
.
4
0
$
3
1
,
9
3
2
.
6
6
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
$
4
9
,
3
9
3
.
0
0
($
1
9
,
0
6
8
.
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
6
,
6
6
7
.
4
4
($
2
,
7
7
4
.
5
1
)
To
t
a
l
s
$3
3
,
9
6
7
,
8
1
7
.
9
3
$
3
0
,
2
0
5
,
7
9
3
.
9
6
$
4
,
8
5
1
,
0
1
4
.
0
1
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending July 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 8/9/21 As of 8/9/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $8,203,800.64 $4,178,176.12 $12,381,976.76 $329,780.28 $329,780.28
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 $8,236,317.97 $4,178,176.12 $12,414,494.09 $362,297.61 $362,297.61
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $415,044.98 $273,150.26 $688,195.24 $92,195.24 $92,195.24
10‐100‐403010 Gasoline Tax $1,170,000.00 $650,937.38 $508,373.04 $1,159,310.42 ($10,689.58)($10,689.58)
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,672,419.27 $781,523.30 $2,453,942.57 $97,942.57 $97,942.57
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $62,668.78 $35,062.53 $97,731.31 ($2,268.69)($2,268.69)
$100,000.00 $62,668.78 $35,062.53 $97,731.31 ($2,268.69)($2,268.69)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $2,116,901.16 $1,653,533.72 $3,770,434.88 ($229,565.12)($229,565.12)
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 $685,692.25 $130,771.62 $816,463.87 ($83,536.13)($83,536.13)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $867,337.84 $488,545.18 $1,355,883.02 ($244,116.98)($244,116.98)
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,305.87 $105,834.40 $248,140.27 ($76,859.73)($76,859.73)
$6,825,000.00 $3,812,237.12 $2,378,684.92 $6,190,922.04 ($634,077.96)($634,077.96)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $4,958,609.55 $15,438.93 $4,974,048.48 $99,048.48 $99,048.48
10‐100‐420020 Del Property Tax $47,000.00 $120,373.09 $13,336.15 $133,709.24 $86,709.24 $86,709.24
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 $18,834.96 $8,257.90 $27,092.86 ($1,907.14)($1,907.14)
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,681.82 $1,596.46 $511,278.28 $41,278.28 $41,278.28
10‐100‐420080 Special Tax Rev $56,000.00 $43,200.80 $32,676.38 $75,877.18 $19,877.18 $19,877.18
$5,561,399.28 $5,723,237.06 $71,305.82 $5,794,542.88 $233,143.60 $233,143.60
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 $19,988.00 $0.00 $19,988.00 $19,988.00 $19,988.00
$5,170.00 $4,738,793.86 $0.00 $4,738,793.86 $4,733,623.86 $4,733,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 $0.00 $25,000.00 $25,000.00 $0.00 $0.00
10‐100‐440210 Street Cuts $30,000.00 $27,718.00 $8,672.65 $36,390.65 $6,390.65 $6,390.65
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $5,776.65 $3,058.62 $8,835.27 ($2,164.73)($2,164.73)
10‐100‐440920 Parts Charge backs $221,206.58 $135,553.38 $45,143.54 $180,696.92 ($40,509.66)($40,509.66)
10‐100‐440930 Labor Charge backs $249,445.72 $142,630.98 $59,223.12 $201,854.10 ($47,591.62)($47,591.62)
10‐100‐481020 Cole Cty Animal Rescue $115,034.90 $86,276.19 $28,758.73 $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 $142,587.50 $38,365.47 $180,952.97 $15,952.97 $15,952.97
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 $298,840.59 $99,919.05 $398,759.64 ($916.54)($916.54)
10‐100‐481080 Sale Of Maps/GIS Data $0.00 $60.00 $0.00 $60.00 $60.00 $60.00
10‐100‐481085 Cole Cty GIS Joint Coop $15,000.00 $13,902.50 $3,750.00 $17,652.50 $2,652.50 $2,652.50
10‐100‐481100 Sale Of Grave Sites $2,085.00 $2,085.00 $476.67 $2,561.67 $476.67 $476.67
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.84)$0.00 ($2.84)($2.84)($2.84)
$2,852,676.10 $2,452,904.95 $334,667.86 $2,787,572.81 ($65,103.29)($65,103.29)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $77,075.83 $1,488.32 $78,564.15 $8,564.15 $8,564.15
10‐100‐450020 Business Licenses $220,000.00 $197,734.48 $19,752.14 $217,486.62 ($2,513.38)($2,513.38)
10‐100‐450021 Home Occupation Permit $1,800.00 $2,365.00 $654.55 $3,019.55 $1,219.55 $1,219.55
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 $6,805.00 $2,000.00 $8,805.00 $805.00 $805.00
10‐100‐450045 Building Construct. Fees $315,000.00 $267,836.88 $105,921.50 $373,758.38 $58,758.38 $58,758.38
10‐100‐450050 Electrical Certificates $22,000.00 $21,564.00 $1,227.15 $22,791.15 $791.15 $791.15
10‐100‐450060 Electrical Permits $4,400.00 $8,164.66 $1,381.10 $9,545.76 $5,145.76 $5,145.76
10‐100‐450070 Plumbing Licenses $12,400.00 $11,301.00 $921.84 $12,222.84 ($177.16)($177.16)
10‐100‐450080 Plumbing Permits $8,000.00 $29,332.14 $2,431.58 $31,763.72 $23,763.72 $23,763.72
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending July 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 8/9/21 As of 8/9/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,553.00 $1,155.19 $2,708.19 $708.19 $708.19
10‐100‐450091 Day Care Inspection Fees $6,400.00 $3,565.00 $1,271.86 $4,836.86 ($1,563.14)($1,563.14)
10‐100‐450092 Food Inspection Fees $86,000.00 $91,704.74 ($2,367.18)$89,337.56 $3,337.56 $3,337.56
10‐100‐450100 Curb Cut Permits $1,000.00 $1,370.00 $434.18 $1,804.18 $804.18 $804.18
10‐100‐450110 Board Of Adj Fees $1,000.00 $1,600.00 $463.50 $2,063.50 $1,063.50 $1,063.50
10‐100‐450120 Sign Permits $6,900.00 $6,178.00 $2,287.89 $8,465.89 $1,565.89 $1,565.89
10‐100‐450130 Demolition Permits $1,800.00 $2,373.00 $228.17 $2,601.17 $801.17 $801.17
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $5,226.90 $2,242.68 $7,469.58 ($1,530.42)($1,530.42)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $673.47 $717.82 $1,391.29 $241.29 $241.29
10‐100‐450170 Animal Redemption Fees $98,000.00 $68,681.50 $31,826.41 $100,507.91 $2,507.91 $2,507.91
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $3,770.00 $1,322.18 $5,092.18 ($107.82)($107.82)
10‐100‐450185 Animal Cremation Fees $50,000.00 $29,885.00 $16,712.39 $46,597.39 ($3,402.61)($3,402.61)
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 $133.33 $269.33 ($530.67)($530.67)
10‐100‐450250 Rezoning Request $0.00 $100.00 $0.00 $100.00 $100.00 $100.00
10‐100‐450255 Planning & Zoning Review Fees $20,000.00 $11,435.00 $6,131.52 $17,566.52 ($2,433.48)($2,433.48)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $680.00 $427.52 $1,107.52 ($692.48)($692.48)
$952,650.00 $852,530.60 $198,765.64 $1,051,296.24 $98,646.24 $98,646.24
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $31,062.05 $14,425.34 $45,487.39 ($11,512.61)($11,512.61)
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 $5,165.60 $2,409.47 $7,575.07 ($1,924.93)($1,924.93)
10‐100‐460020 Jail Cost Recovery $1,100.00 $51.10 $309.90 $361.00 ($739.00)($739.00)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $4,858.23 $1,152.15 $6,010.38 $1,810.38 $1,810.38
10‐100‐460030 Pol Fines‐traffic $500,000.00 $306,838.76 $125,596.89 $432,435.65 ($67,564.35)($67,564.35)
10‐100‐460090 Parking Fines $40,000.00 $22,098.50 $4,677.10 $26,775.60 ($13,224.40)($13,224.40)
10‐100‐460100 Bankcard Charges ($3,900.00)($4,497.49)($1,047.28)($5,544.77)($1,644.77)($1,644.77)
$607,900.00 $365,576.75 $147,523.56 $513,100.31 ($94,799.69)($94,799.69)
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,427.43 $0.00 $17,427.43 $120.00 $120.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 $19,112.11 $4,662.20 $23,774.31 $8,774.31 $8,774.31
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 $234,314.21 $147,745.46 $382,059.67 $7,210.24 $7,210.24
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 $35,100.61 $19,055.10 $54,155.71 ($16,871.74)($16,871.74)
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 $10,613.44 $6,096.36 $16,709.80 ($1,290.20)($1,290.20)
10‐100‐481077 Insurance Claims $122,193.19 $224,331.22 $20,000.00 $244,331.22 $122,138.03 $122,138.03
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$221,220.64 $270,378.55 $55,151.46 $325,530.01 $104,309.37 $104,309.37
Interest Income
10‐100‐470010 Interest $120,000.00 $118,354.40 $33,578.26 $151,932.66 $31,932.66 $31,932.66
$120,000.00 $118,354.40 $33,578.26 $151,932.66 $31,932.66 $31,932.66
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $49,393.00 $244,300.00 $293,693.00 ($19,068.00)($19,068.00)
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $49,393.00 $244,300.00 $293,693.00 ($19,068.00)($19,068.00)
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $17,072.44 $6,553.05 $23,625.49 ($2,774.51)($2,774.51)
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,616,667.44 $6,553.05 $1,623,220.49 ($2,774.51)($2,774.51)
$33,967,817.93 $30,205,793.96 $8,613,037.98 $38,818,831.94 $4,851,014.01 $4,851,014.01