HomeMy Public PortalAbout2021-09 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
A
u
g
u
s
t
3
1
,
2
0
2
1
Da
t
a
a
s
o
f
S
e
p
t
e
m
b
e
r
7
,
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
9
/
7
/
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
$
9
,
4
6
1
,
2
7
7
.
7
6
$
3
8
0
,
2
4
7
.
1
4
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
,
8
3
0
,
5
3
6
.
1
7
$
9
5
,
7
9
2
.
4
7
Ot
h
e
r
T
a
x
e
s
$1
0
0
,
0
0
0
.
0
0
$
7
0
,
1
5
4
.
7
4
($
4
,
3
9
4
.
5
8
)
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
$
4
,
4
6
4
,
1
3
0
.
8
8
($
6
4
1
,
8
5
0
.
5
0
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
5
6
1
,
3
9
9
.
2
8
$
5
,
7
7
2
,
9
3
7
.
7
8
$
2
4
4
,
8
7
1
.
0
2
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$5
,
1
7
0
.
0
0
$
4
,
7
4
8
,
7
9
3
.
8
6
$
4
,
7
4
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
,
5
5
5
,
2
5
8
.
8
4
($
3
1
,
4
4
5
.
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
$
9
3
9
,
4
2
4
.
4
7
$
1
2
3
,
7
3
5
.
3
7
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$6
0
7
,
9
0
0
.
0
0
$
4
0
3
,
4
2
8
.
0
1
($
1
0
7
,
8
8
0
.
9
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
$
2
3
6
,
5
5
5
.
2
1
$
8
,
5
6
7
.
1
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
8
3
,
5
3
5
.
3
7
$
8
5
,
5
9
1
.
5
2
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
0
4
.
5
4
$
1
2
,
9
1
2
.
4
2
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
$
9
2
,
6
2
1
.
1
3
($
1
3
9
.
8
7
)
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
9
,
0
4
0
.
9
2
($
2
,
6
9
0
.
3
1
)
To
t
a
l
s
$3
3
,
9
6
7
,
8
1
7
.
9
3
$
3
2
,
5
9
5
,
9
9
9
.
6
8
$
4
,
9
0
6
,
9
3
8
.
7
1
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending August 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 9/7/21 As of 9/7/21 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $12,052,196.48 $9,428,760.43 $2,971,165.86 $12,399,926.29 $347,729.81 $347,729.81
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 $9,461,277.76 $2,971,165.86 $12,432,443.62 $380,247.14 $380,247.14
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $596,000.00 $471,093.29 $212,412.17 $683,505.46 $87,505.46 $87,505.46
10‐100‐403010 Gasoline Tax $1,170,000.00 $753,005.97 $408,844.13 $1,161,850.10 ($8,149.90)($8,149.90)
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,830,536.17 $621,256.30 $2,451,792.47 $95,792.47 $95,792.47
Other Taxes
10‐100‐403020 Cig Tax $100,000.00 $70,154.74 $25,450.68 $95,605.42 ($4,394.58)($4,394.58)
$100,000.00 $70,154.74 $25,450.68 $95,605.42 ($4,394.58)($4,394.58)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $2,580,181.13 $1,177,482.43 $3,757,663.56 ($242,336.44)($242,336.44)
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 $717,905.08 $98,478.34 $816,383.42 ($83,616.58)($83,616.58)
10‐100‐410052 Telephone/Cell Utility $1,600,000.00 $949,795.78 $364,153.38 $1,313,949.16 ($286,050.84)($286,050.84)
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 $216,248.89 $78,904.47 $295,153.36 ($29,846.64)($29,846.64)
$6,825,000.00 $4,464,130.88 $1,719,018.62 $6,183,149.50 ($641,850.50)($641,850.50)
Property Taxes
10‐100‐420010 Current Property Tax $4,875,000.00 $4,967,795.67 $8,498.87 $4,976,294.54 $101,294.54 $101,294.54
10‐100‐420020 Del Property Tax $47,000.00 $132,923.31 $3,644.84 $136,568.15 $89,568.15 $89,568.15
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 $26,609.60 $3,636.85 $30,246.45 $1,246.45 $1,246.45
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,439.68 $234.96 $512,674.64 $42,674.64 $42,674.64
10‐100‐420080 Special Tax Rev $56,000.00 $60,632.68 $17,316.99 $77,949.67 $21,949.67 $21,949.67
$5,561,399.28 $5,772,937.78 $33,332.52 $5,806,270.30 $244,871.02 $244,871.02
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 $29,988.00 $0.00 $29,988.00 $29,988.00 $29,988.00
$5,170.00 $4,748,793.86 $0.00 $4,748,793.86 $4,743,623.86 $4,743,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 $28,868.00 $5,670.43 $34,538.43 $4,538.43 $4,538.43
10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $6,770.81 $2,096.22 $8,867.03 ($2,132.97)($2,132.97)
10‐100‐440920 Parts Charge backs $221,206.58 $150,601.44 $44,299.74 $194,901.18 ($26,305.40)($26,305.40)
10‐100‐440930 Labor Charge backs $249,445.72 $161,157.98 $57,918.12 $219,076.10 ($30,369.62)($30,369.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 $1,000.00 $12,000.00 $13,000.00 $1,000.00 $1,000.00
10‐100‐481045 Rent‐tower Sites $165,000.00 $173,756.57 $10,660.33 $184,416.90 $19,416.90 $19,416.90
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 $332,224.44 $66,767.70 $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 $15,152.50 $2,500.00 $17,652.50 $2,652.50 $2,652.50
10‐100‐481100 Sale Of Grave Sites $2,085.00 $2,502.00 $0.00 $2,502.00 $417.00 $417.00
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 ($3.09)$0.00 ($3.09)($3.09)($3.09)
$2,852,676.10 $2,555,258.84 $265,971.27 $2,821,230.11 ($31,445.99)($31,445.99)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $70,000.00 $78,025.83 $1,186.76 $79,212.59 $9,212.59 $9,212.59
10‐100‐450020 Business Licenses $220,000.00 $207,225.40 $10,618.63 $217,844.03 ($2,155.97)($2,155.97)
10‐100‐450021 Home Occupation Permit $1,800.00 $2,420.00 $409.09 $2,829.09 $1,029.09 $1,029.09
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,130.00 $1,333.33 $10,463.33 $2,463.33 $2,463.33
10‐100‐450045 Building Construct. Fees $315,000.00 $319,492.56 $76,136.43 $395,628.99 $80,628.99 $80,628.99
10‐100‐450050 Electrical Certificates $22,000.00 $23,433.00 $1,227.15 $24,660.15 $2,660.15 $2,660.15
10‐100‐450060 Electrical Permits $4,400.00 $9,272.02 $562.60 $9,834.62 $5,434.62 $5,434.62
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 $30,607.14 $1,866.27 $32,473.41 $24,473.41 $24,473.41
FY2021
Revenue Model Report (Detail)Remaining
For the Period Ending August 31, 2021 YTD Actual
Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 9/7/21 As of 9/7/21 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $1,768.00 $673.79 $2,441.79 $441.79 $441.79
10‐100‐450091 Day Care Inspection Fees $6,400.00 $3,705.00 $785.16 $4,490.16 ($1,909.84)($1,909.84)
10‐100‐450092 Food Inspection Fees $86,000.00 $91,844.74 ($1,919.04)$89,925.70 $3,925.70 $3,925.70
10‐100‐450100 Curb Cut Permits $1,000.00 $1,425.00 $231.50 $1,656.50 $656.50 $656.50
10‐100‐450110 Board Of Adj Fees $1,000.00 $1,600.00 $370.80 $1,970.80 $970.80 $970.80
10‐100‐450120 Sign Permits $6,900.00 $6,927.00 $1,513.91 $8,440.91 $1,540.91 $1,540.91
10‐100‐450130 Demolition Permits $1,800.00 $3,373.00 $202.82 $3,575.82 $1,775.82 $1,775.82
10‐100‐450150 Acc Rep Fees‐police $9,000.00 $5,806.90 $1,528.95 $7,335.85 ($1,664.15)($1,664.15)
10‐100‐450160 Accrpt/blastg P‐fire $1,150.00 $984.88 $662.02 $1,646.90 $496.90 $496.90
10‐100‐450170 Animal Redemption Fees $98,000.00 $78,444.00 $21,415.90 $99,859.90 $1,859.90 $1,859.90
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $4,020.00 $922.87 $4,942.87 ($257.13)($257.13)
10‐100‐450185 Animal Cremation Fees $50,000.00 $34,157.00 $11,593.99 $45,750.99 ($4,249.01)($4,249.01)
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 $133.33 $405.33 ($394.67)($394.67)
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 $11,890.00 $4,179.48 $16,069.48 ($3,930.52)($3,930.52)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $680.00 $403.32 $1,083.32 ($716.68)($716.68)
$952,650.00 $939,424.47 $136,960.90 $1,076,385.37 $123,735.37 $123,735.37
Fines & Forfeitures
10‐100‐460010 Court Cost $57,000.00 $33,880.50 $9,715.97 $43,596.47 ($13,403.53)($13,403.53)
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,639.24 $1,623.15 $7,262.39 ($2,237.61)($2,237.61)
10‐100‐460020 Jail Cost Recovery $1,100.00 $51.10 $266.26 $317.36 ($782.64)($782.64)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $5,482.09 $658.21 $6,140.30 $1,940.30 $1,940.30
10‐100‐460030 Pol Fines‐traffic $500,000.00 $338,114.07 $81,625.42 $419,739.49 ($80,260.51)($80,260.51)
10‐100‐460090 Parking Fines $40,000.00 $24,758.50 $3,347.72 $28,106.22 ($11,893.78)($11,893.78)
10‐100‐460100 Bankcard Charges ($3,900.00)($4,497.49)($645.70)($5,143.19)($1,243.19)($1,243.19)
$607,900.00 $403,428.01 $96,591.04 $500,019.05 ($107,880.95)($107,880.95)
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 $21,353.11 $3,778.07 $25,131.18 $10,131.18 $10,131.18
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 $236,555.21 $146,861.33 $383,416.54 $8,567.11 $8,567.11
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 $36,079.80 $8,842.69 $44,922.49 ($26,104.96)($26,104.96)
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 $11,598.65 $4,434.11 $16,032.76 ($1,967.24)($1,967.24)
10‐100‐481077 Insurance Claims $122,193.19 $235,523.64 $0.00 $235,523.64 $113,330.45 $113,330.45
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$221,220.64 $283,535.37 $23,276.79 $306,812.16 $85,591.52 $85,591.52
Interest Income
10‐100‐470010 Interest $120,000.00 $118,304.54 $14,607.88 $132,912.42 $12,912.42 $12,912.42
$120,000.00 $118,304.54 $14,607.88 $132,912.42 $12,912.42 $12,912.42
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $312,761.00 $92,621.13 $220,000.00 $312,621.13 ($139.87)($139.87)
10‐100‐486020 Capital Contribution‐Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$312,761.00 $92,621.13 $220,000.00 $312,621.13 ($139.87)($139.87)
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,400.00 $19,445.92 $4,263.77 $23,709.69 ($2,690.31)($2,690.31)
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,619,040.92 $4,263.77 $1,623,304.69 ($2,690.31)($2,690.31)
$33,967,817.93 $32,595,999.68 $6,278,756.96 $38,874,756.64 $4,906,938.71 $4,906,938.71