HomeMy Public PortalAbout2020-04 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
M
a
r
c
h
3
1
,
2
0
2
0
Da
t
a
a
s
o
f
A
p
r
i
l
9
,
2
0
2
0
.
FY
2
0
2
0
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
4
/
9
/
2
0
(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
1
,
8
7
4
,
0
8
5
.
2
0
$
4
,
0
0
6
,
7
7
5
.
0
9
($
4
7
,
8
3
2
.
4
6
)
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
T
a
x
e
s
$2
,
3
2
2
,
5
0
0
.
0
0
$
4
1
2
,
3
8
8
.
0
8
($
3
,
0
9
0
.
2
2
)
Ot
h
e
r
T
a
x
e
s
$1
0
6
,
0
0
0
.
0
0
$
2
9
,
5
9
8
.
1
2
($
3
,
7
5
0
.
5
3
)
Fr
a
n
c
h
i
s
e
&
U
t
i
l
i
t
y
T
a
x
$7
,
2
0
5
,
0
0
0
.
0
0
$
2
,
1
0
7
,
0
4
5
.
8
9
($
2
7
6
,
6
3
1
.
5
1
)
Pr
o
p
e
r
t
y
T
a
x
e
s
$5
,
4
6
6
,
3
9
9
.
0
0
$
5
,
4
0
6
,
7
2
2
.
4
2
$
1
1
2
,
5
1
7
.
1
7
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$2
,
9
2
5
.
0
0
$
5
0
,
0
2
2
.
3
8
$
4
7
,
0
9
7
.
3
8
Ch
a
r
g
e
s
f
o
r
S
e
r
v
i
c
e
s
$2
,
8
7
5
,
1
3
0
.
0
4
$
2
,
0
7
5
,
8
3
1
.
6
3
($
2
0
,
1
8
4
.
1
7
)
Fe
e
s
,
L
i
c
e
n
s
e
s
,
&
P
e
r
m
i
t
s
$9
0
2
,
5
2
0
.
0
0
$
4
2
4
,
7
2
0
.
2
2
$
1
1
8
,
0
6
5
.
0
9
Fi
n
e
s
&
F
o
r
f
e
i
t
u
r
e
s
$7
6
6
,
6
0
0
.
0
0
$
2
0
1
,
6
9
2
.
1
8
($
1
4
6
,
1
4
5
.
6
8
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
4
2
,
2
0
9
.
5
6
$
5
1
,
9
5
1
.
0
7
$
1
3
,
4
3
7
.
0
1
Ot
h
e
r
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
s
$1
0
2
,
0
0
0
.
0
0
$
8
7
,
8
1
4
.
6
2
$
4
6
,
3
9
0
.
8
8
In
t
e
r
e
s
t
I
n
c
o
m
e
$1
6
0
,
0
0
2
.
0
4
$
2
7
,
4
8
4
.
3
5
($
9
,
1
7
7
.
3
0
)
Ot
h
e
r
N
o
n
O
p
e
r
a
t
i
n
g
R
e
v
e
n
u
e
$5
5
,
0
0
0
.
0
0
$
1
8
,
1
8
7
.
7
5
($
8
1
2
.
2
5
)
Op
e
r
a
t
i
n
g
T
r
a
n
s
f
e
r
s
I
n
$2
6
,
0
0
0
.
0
0
$1
0
,
6
3
7
.
9
9
$1
,
2
2
5
.
1
7
To
t
a
l
s
$3
2
,
2
0
6
,
3
7
0
.
8
4
$
1
4
,
9
1
0
,
8
7
1
.
7
9
($
1
6
8
,
8
9
1
.
4
0
)
FY2020
Revenue Model Report (Detail)Remaining
For the Period Ending March 31, 2020 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 4/9/20 As of 4/9/20 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $11,874,085.20 $4,000,068.53 $7,819,477.65 $11,819,546.18 ($54,539.02)($54,539.02)
10‐100‐400020 Sales Tax Interest $0.00 $6,706.56 $0.00 $6,706.56 $6,706.56 $6,706.56
$11,874,085.20 $4,006,775.09 $7,819,477.65 $11,826,252.74 ($47,832.46) ($47,832.46)
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $591,500.00 $129,711.31 $457,390.11 $587,101.42 ($4,398.58)($4,398.58)
10‐100‐403010 Gasoline Tax $1,161,000.00 $282,676.77 $879,631.59 $1,162,308.36 $1,308.36 $1,308.36
10‐100‐430080 Road & Bridge Tax $570,000.00 $0.00 $570,000.00 $570,000.00 $0.00 $0.00
$2,322,500.00 $412,388.08 $1,907,021.70 $2,319,409.78 ($3,090.22)($3,090.22)
Other Taxes
10‐100‐403020 Cig Tax $106,000.00 $29,598.12 $72,651.35 $102,249.47 ($3,750.53)($3,750.53)
$106,000.00 $29,598.12 $72,651.35 $102,249.47 ($3,750.53)($3,750.53)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,100,000.00 $1,123,505.04 $2,933,789.37 $4,057,294.41 ($42,705.59)($42,705.59)
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 $950,000.00 $418,266.12 $446,408.41 $864,674.53 ($85,325.47)($85,325.47)
10‐100‐410052 Telephone/Cell Utility $1,800,000.00 $487,340.77 $1,187,543.35 $1,674,884.12 ($125,115.88)($125,115.88)
10‐100‐410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐410060 Cable Franchise Fee $355,000.00 $77,933.96 $253,581.48 $331,515.44 ($23,484.56)($23,484.56)
$7,205,000.00 $2,107,045.89 $4,821,322.60 $6,928,368.49 ($276,631.51)($276,631.51)
Property Taxes
10‐100‐420010 Current Property Tax $4,790,000.00 $4,794,740.21 $85,123.88 $4,879,864.09 $89,864.09 $89,864.09
10‐100‐420020 Del Property Tax $45,000.00 $25,739.47 $23,017.74 $48,757.21 $3,757.21 $3,757.21
10‐100‐420040 Fin Institution Tax $33,000.00 $29,796.21 $0.00 $29,796.21 ($3,203.79)($3,203.79)
10‐100‐420050 Prop Tax Int & Penalties $29,000.00 $11,800.50 $18,461.27 $30,261.77 $1,261.77 $1,261.77
10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28
10‐100‐420060 Surtax Receipts $467,000.00 $467,203.80 $14,742.72 $481,946.52 $14,946.52 $14,946.52
10‐100‐420080 Special Tax Rev $48,000.00 $23,042.95 $30,848.13 $53,891.08 $5,891.08 $5,891.08
$5,466,399.00 $5,406,722.42 $172,193.75 $5,578,916.17 $112,517.17 $112,517.17
Intergovernmental
10‐100‐430010 Federal Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐430040 Local Grant $2,925.00 $2,925.00 $0.00 $2,925.00 $0.00 $0.00
10‐100‐430060 Drug Forfeiture $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $47,097.38 $0.00 $47,097.38 $47,097.38 $47,097.38
$2,925.00 $50,022.38 $0.00 $50,022.38 $47,097.38 $47,097.38
Charges for Services
10‐100‐440010 Admin Charge Backs $1,555,757.00 $1,555,757.00 $0.00 $1,555,757.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 $27,000.00 $16,039.00 $15,977.94 $32,016.94 $5,016.94 $5,016.94
10‐100‐440910 Fuel Charge ‐ backs $12,000.00 $3,455.88 $7,537.96 $10,993.84 ($1,006.16)($1,006.16)
10‐100‐440920 Parts Charge backs $244,000.00 $102,630.73 $128,598.92 $231,229.65 ($12,770.35)($12,770.35)
10‐100‐440930 Labor Charge backs $275,000.00 $100,786.72 $155,351.04 $256,137.76 ($18,862.24)($18,862.24)
10‐100‐481020 Cole Cty Animal Rescue $112,229.12 $28,057.29 $84,171.84 $112,229.13 $0.01 $0.01
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 $300.00 $12,000.00 $12,300.00 $300.00 $300.00
10‐100‐481045 Rent‐tower Sites $156,000.00 $65,409.54 $99,317.45 $164,726.99 $8,726.99 $8,726.99
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 $389,991.81 $161,906.00 $228,037.74 $389,943.74 ($48.07)($48.07)
10‐100‐481080 Sale Of Maps/GIS Data $0.00 $10.00 $0.00 $10.00 $10.00 $10.00
10‐100‐481085 Cole Cty GIS Joint Coop $16,850.00 $6,250.00 $10,600.00 $16,850.00 $0.00 $0.00
10‐100‐481100 Sale Of Grave Sites $4,500.00 $417.00 $2,521.35 $2,938.35 ($1,561.65)($1,561.65)
10‐100‐481105 TIF Administration Fee $19,802.11 $9,802.12 $10,000.00 $19,802.12 $0.01 $0.01
10‐100‐481110 Long & Short $0.00 $10.35 $0.00 $10.35 $10.35 $10.35
$2,875,130.04 $2,075,831.63 $779,114.24 $2,854,945.87 ($20,184.17)($20,184.17)
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $68,000.00 $23,159.17 $54,515.33 $77,674.50 $9,674.50 $9,674.50
10‐100‐450020 Business Licenses $215,000.00 $97,451.59 $121,816.58 $219,268.17 $4,268.17 $4,268.17
10‐100‐450021 Home Occupation Permit $2,000.00 $495.00 $1,116.87 $1,611.87 ($388.13)($388.13)
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,707.00 $4,666.67 $11,373.67 $3,373.67 $3,373.67
10‐100‐450045 Building Construct. Fees $260,000.00 $171,258.27 $180,124.74 $351,383.01 $91,383.01 $91,383.01
10‐100‐450050 Electrical Certificates $22,000.00 $18,318.00 $3,710.72 $22,028.72 $28.72 $28.72
10‐100‐450060 Electrical Permits $4,000.00 $4,285.07 $2,622.45 $6,907.52 $2,907.52 $2,907.52
10‐100‐450070 Plumbing Licenses $12,000.00 $10,209.00 $2,506.98 $12,715.98 $715.98 $715.98
10‐100‐450080 Plumbing Permits $5,800.00 $3,622.50 $3,883.46 $7,505.96 $1,705.96 $1,705.96
FY2020
Revenue Model Report (Detail)Remaining
For the Period Ending March 31, 2020 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 4/9/20 As of 4/9/20 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $716.00 $1,479.32 $2,195.32 $195.32 $195.32
10‐100‐450091 Day Care Inspection Fees $7,300.00 $2,585.00 $3,772.22 $6,357.22 ($942.78)($942.78)
10‐100‐450092 Food Inspection Fees $87,550.00 $5,762.86 $83,119.58 $88,882.44 $1,332.44 $1,332.44
10‐100‐450100 Curb Cut Permits $850.00 $1,200.00 $777.38 $1,977.38 $1,127.38 $1,127.38
10‐100‐450110 Board Of Adj Fees $3,770.00 $400.00 $1,981.89 $2,381.89 ($1,388.11)($1,388.11)
10‐100‐450120 Sign Permits $6,300.00 $3,146.00 $4,106.90 $7,252.90 $952.90 $952.90
10‐100‐450130 Demolition Permits $1,600.00 $1,900.00 $1,272.78 $3,172.78 $1,572.78 $1,572.78
10‐100‐450150 Acc Rep Fees‐police $11,500.00 $3,335.60 $6,799.91 $10,135.51 ($1,364.49)($1,364.49)
10‐100‐450160 Accrpt/blastg P‐fire $1,050.00 $166.26 $768.42 $934.68 ($115.32)($115.32)
10‐100‐450170 Animal Redemption Fees $108,000.00 $38,152.10 $72,383.84 $110,535.94 $2,535.94 $2,535.94
10‐100‐450180 Animal Vaccinations Fees $5,200.00 $1,950.00 $3,046.81 $4,996.81 ($203.19)($203.19)
10‐100‐450185 Animal Cremation Fees $45,000.00 $19,848.00 $26,823.12 $46,671.12 $1,671.12 $1,671.12
10‐100‐450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐450190 Taxi Permits $0.00 $27.00 $0.00 $27.00 $27.00 $27.00
10‐100‐450230 Vacating Right Of Way $800.00 $816.00 $436.96 $1,252.96 $452.96 $452.96
10‐100‐450250 Rezoning Request $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐450255 Planning & Zoning Review Fees $23,000.00 $8,574.80 $13,549.18 $22,123.98 ($876.02)($876.02)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $635.00 $582.75 $1,217.75 ($582.25)($582.25)
$902,520.00 $424,720.22 $595,864.87 $1,020,585.09 $118,065.09 $118,065.09
Fines & Forfeitures
10‐100‐460010 Court Cost $69,000.00 $17,181.16 $38,210.17 $55,391.33 ($13,608.67)($13,608.67)
10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐460018 Inmate Security Fund $11,500.00 $2,873.52 $6,362.97 $9,236.49 ($2,263.51)($2,263.51)
10‐100‐460020 Jail Cost Recovery $1,500.00 $160.57 $954.73 $1,115.30 ($384.70)($384.70)
10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $2,322.29 $2,043.49 $4,365.78 $165.78 $165.78
10‐100‐460030 Pol Fines‐traffic $630,000.00 $174,191.32 $350,046.42 $524,237.74 ($105,762.26)($105,762.26)
10‐100‐460090 Parking Fines $54,000.00 $7,248.50 $23,521.49 $30,769.99 ($23,230.01)($23,230.01)
10‐100‐460100 Bankcard Charges ($3,600.00)($2,285.18)($2,377.14)($4,662.32)($1,062.32)($1,062.32)
$766,600.00 $201,692.18 $418,762.14 $620,454.32 ($146,145.68)($146,145.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 $9,615.56 $15,153.05 $0.00 $15,153.05 $5,537.49 $5,537.49
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 $0.00 $8,506.11 $0.00 $8,506.11 $8,506.11 $8,506.11
10‐100‐481055 Street Repair‐Solid Waste Cntr $331,594.00 $27,291.91 $303,695.50 $330,987.41 ($606.59)($606.59)
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$342,209.56 $51,951.07 $303,695.50 $355,646.57 $13,437.01 $13,437.01
Other Operating Revenues
10‐100‐480010 Citizen Participation $0.00 $322.57 $0.00 $322.57 $322.57 $322.57
10‐100‐480011 Police Evidence Funds $0.00 $29,284.88 $0.00 $29,284.88 $29,284.88 $29,284.88
10‐100‐481070 Miscellaneous $53,000.00 $42,120.75 $22,276.51 $64,397.26 $11,397.26 $11,397.26
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 $19,000.00 $4,345.06 $12,588.15 $16,933.21 ($2,066.79)($2,066.79)
10‐100‐481077 Insurance Claims $20,000.00 $11,741.36 $15,711.60 $27,452.96 $7,452.96 $7,452.96
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$102,000.00 $87,814.62 $60,576.26 $148,390.88 $46,390.88 $46,390.88
Interest Income
10‐100‐470010 Interest $160,002.04 $27,484.35 $123,340.39 $150,824.74 ($9,177.30)($9,177.30)
$160,002.04 $27,484.35 $123,340.39 $150,824.74 ($9,177.30)($9,177.30)
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $55,000.00 $18,187.75 $36,000.00 $54,187.75 ($812.25)($812.25)
$55,000.00 $18,187.75 $36,000.00 $54,187.75 ($812.25)($812.25)
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $26,000.00 $10,637.99 $16,587.18 $27,225.17 $1,225.17 $1,225.17
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$26,000.00 $10,637.99 $16,587.18 $27,225.17 $1,225.17 $1,225.17
$32,206,370.84 $14,910,871.79 $17,126,607.65 $32,037,479.44 ($168,891.40)($168,891.40)