HomeMy Public PortalAbout2018-06 NO Meeting - Revenue Model ReportRe
v
e
n
u
e
Mo
d
e
l
Re
p
o
r
t
Fo
r
th
e
Pe
r
i
o
d
En
d
i
n
g
Ma
y
31
,
20
1
8
Da
t
a
as
of
Ju
n
e
6,
20
1
8
FY
20
1
8
Y
T
D
Ac
t
u
a
l
P
r
o
j
e
c
t
e
d
Ov
e
r
/
De
s
c
r
i
p
t
i
o
n
Bu
d
g
e
t
As
of
6/
6
/
1
8
(U
n
d
e
r
)
Bu
d
g
e
t
Sa
l
e
s
Ta
x
an
d
Us
e
Ta
x
$1
1
,
4
1
3
,
0
0
0
.
0
0
$
5
,
7
0
5
,
5
6
3
.
5
0
$
2
,
8
3
3
.
6
5
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
Ta
x
e
s
$2
,
2
5
9
,
0
0
0
.
0
0
$
1
,
2
7
7
,
3
5
4
.
1
8
$
3
9
,
8
6
1
.
2
2
Ot
h
e
r
Ta
x
e
s
$1
1
5
,
0
0
0
.
0
0
$
5
0
,
4
3
3
.
2
0
($
5
,
2
7
0
.
1
5
)
Fr
a
n
c
h
i
s
e
& Ut
i
l
i
t
y
Ta
x
$7
,
4
3
0
,
0
0
0
.
0
0
$
3
,
7
3
7
,
8
1
2
.
3
9
$
1
4
5
,
7
5
8
.
7
9
Pr
o
p
e
r
t
y
Ta
x
e
s
$5
,
4
0
6
,
3
9
9
.
0
0
$
5
,
3
1
7
,
2
2
2
.
5
4
$
9
,
1
4
4
.
0
6
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$4
3
4
,
9
7
1
.
5
0
$
2
1
4
,
0
5
2
.
9
6
($
2
0
0
,
0
1
5
.
9
2
)
Ch
a
r
g
e
s
fo
r
Se
r
v
i
c
e
s
$2
,
7
6
4
,
8
3
1
.
6
9
$
2
,
2
8
5
,
6
2
4
.
3
3
$
7
4
,
4
1
2
.
1
5
Fe
e
s
,
Li
c
e
n
s
e
s
,
& Pe
r
m
i
t
s
$8
0
0
,
7
0
0
.
0
0
$
6
7
6
,
5
7
7
.
8
8
$
1
7
4
,
9
6
8
.
4
5
Fi
n
e
s
& Fo
r
f
e
i
t
u
r
e
s
$8
9
4
,
1
0
0
.
0
0
$
4
7
3
,
1
3
1
.
0
2
($
4
8
,
2
9
5
.
8
9
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
1
4
,
4
6
2
.
5
0
$
1
1
8
,
8
9
5
.
0
0
$
1
4
,
2
9
5
.
0
0
Ot
h
e
r
Op
e
r
a
t
i
n
g
Re
v
e
n
u
e
s
$8
4
,
0
0
0
.
0
0
$
4
3
,
4
9
4
.
1
8
$
6
,
7
7
0
.
9
8
In
t
e
r
e
s
t
In
c
o
m
e
$1
2
1
,
0
6
2
.
3
9
$
8
5
,
9
1
5
.
4
6
$
2
9
,
1
3
0
.
9
0
Ot
h
e
r
No
n
Op
e
r
a
t
i
n
g
Re
v
e
n
u
e
$4
5
,
0
0
0
.
0
0
$
3
1
,
3
4
3
.
4
0
$
1
6
,
3
4
3
.
4
0
Op
e
r
a
t
i
n
g
Tr
a
n
s
f
e
r
s
In
$2
4
,
0
2
4
.
0
0
$1
1
,
1
6
4
.
0
0
$2
0
1
.
8
6
To
t
a
l
s
$3
2
,
1
0
6
,
5
5
1
.
0
8
$
2
0
,
0
2
8
,
5
8
4
.
0
4
$
2
6
0
,
1
3
8
.
4
9
FY2018
Revenue Model Report (Detail)Remaining
For the Period Ending May 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 6/6/18 As of 6/6/18 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $11,413,000.00 $5,705,563.50 $5,710,270.15 $11,415,833.65 $2,833.65 $2,833.65
$11,413,000.00 $5,705,563.50 $5,710,270.15 $11,415,833.65 $2,833.65 $2,833.65
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $562,000.00 $245,325.72 $330,818.94 $576,144.66 $14,144.66 $14,144.66
10‐100‐403010 Gasoline Tax $1,147,000.00 $462,235.90 $690,688.10 $1,152,924.00 $5,924.00 $5,924.00
10‐100‐430080 Road & Bridge Tax $550,000.00 $569,792.56 $0.00 $569,792.56 $19,792.56 $19,792.56
$2,259,000.00 $1,277,354.18 $1,021,507.04 $2,298,861.22 $39,861.22 $39,861.22
Other Taxes
10‐100‐403020 Cig Tax $115,000.00 $50,433.20 $59,296.65 $109,729.85 ($5,270.15)($5,270.15)
$115,000.00 $50,433.20 $59,296.65 $109,729.85 ($5,270.15)($5,270.15)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,050,000.00 $1,696,157.88 $2,381,127.13 $4,077,285.01 $27,285.01 $27,285.01
10‐100‐410021 Electric Utility‐AUDIT $0.00 $233,160.20 $0.00 $233,160.20 $233,160.20 $233,160.20
10‐100‐410030 Gas Utility License Tax $900,000.00 $730,005.36 $221,164.90 $951,170.26 $51,170.26 $51,170.26
10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $911,809.78 $1,008,773.05 $1,920,582.83 ($129,417.17)($129,417.17)
10‐100‐410053 Telephone/Cell Audit $0.00 ($15,210.20)$15,210.20 $0.00 $0.00 $0.00
10‐100‐410060 Cable Franchise Fee $430,000.00 $181,889.37 $211,671.12 $393,560.49 ($36,439.51)($36,439.51)
$7,430,000.00 $3,737,812.39 $3,837,946.40 $7,575,758.79 $145,758.79 $145,758.79
Property Taxes
10‐100‐420010 Current Property Tax $4,740,000.00 $4,706,927.66 $45,376.79 $4,752,304.45 $12,304.45 $12,304.45
10‐100‐420020 Del Property Tax $40,000.00 $13,253.03 $18,447.86 $31,700.89 ($8,299.11)($8,299.11)
10‐100‐420040 Fin Institution Tax $48,000.00 $37,276.50 $0.00 $37,276.50 ($10,723.50)($10,723.50)
10‐100‐420050 Prop Tax Int & Penalties $25,000.00 $16,634.09 $12,098.98 $28,733.07 $3,733.07 $3,733.07
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 $469,000.00 $458,417.82 $4,279.04 $462,696.86 ($6,303.14)($6,303.14)
10‐100‐420080 Special Tax Rev $30,000.00 $30,314.16 $18,117.85 $48,432.01 $18,432.01 $18,432.01
$5,406,399.00 $5,317,222.54 $98,320.52 $5,415,543.06 $9,144.06 $9,144.06
Intergovernmental
10‐100‐430010 Federal Grant $434,971.50 $166,955.58 $68,000.00 $234,955.58 ($200,015.92)($200,015.92)
10‐100‐430040 Local Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐480020 NSP Rehab Sales $0.00 $47,097.38 ($47,097.38)$0.00 $0.00 $0.00
10‐100‐480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$434,971.50 $214,052.96 $20,902.62 $234,955.58 ($200,015.92)($200,015.92)
Charges for Services
10‐100‐440010 Admin Charge Backs $1,589,556.00 $1,599,415.00 $0.00 $1,599,415.00 $9,859.00 $9,859.00
10‐100‐440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00
10‐100‐440210 Street Cuts $26,000.00 $13,274.00 $10,615.74 $23,889.74 ($2,110.26)($2,110.26)
10‐100‐440910 Fuel Charge ‐ backs $14,000.00 $5,759.78 $5,935.02 $11,694.80 ($2,305.20)($2,305.20)
10‐100‐440920 Parts Charge backs $185,000.00 $142,355.04 $94,380.24 $236,735.28 $51,735.28 $51,735.28
10‐100‐440930 Labor Charge backs $245,000.00 $130,164.96 $120,889.73 $251,054.69 $6,054.69 $6,054.69
10‐100‐481020 Cole Cty Animal Rescue $108,145.00 $54,072.86 $54,072.50 $108,145.36 $0.36 $0.36
10‐100‐481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐481040 Rent Other $0.00 $0.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00
10‐100‐481045 Rent‐tower Sites $140,000.00 $61,736.18 $79,377.78 $141,113.96 $1,113.96 $1,113.96
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 $377,368.50 $219,000.01 $158,071.40 $377,071.41 ($297.09)($297.09)
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 $16,850.00 $8,750.00 $8,100.00 $16,850.00 $0.00 $0.00
10‐100‐481100 Sale Of Grave Sites $4,000.00 $816.00 $1,264.90 $2,080.90 ($1,919.10)($1,919.10)
10‐100‐481105 TIF Administration Fee $8,912.19 $230.00 $8,912.19 $9,142.19 $230.00 $230.00
10‐100‐481110 Long & Short $0.00 ($9.50)$0.00 ($9.50)($9.50)($9.50)
$2,764,831.69 $2,285,624.33 $553,619.51 $2,839,243.84 $74,412.15 $74,412.15
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $59,000.00 $58,529.34 $6,708.04 $65,237.38 $6,237.38 $6,237.38
10‐100‐450020 Business Licenses $215,000.00 $137,635.13 $90,115.46 $227,750.59 $12,750.59 $12,750.59
10‐100‐450021 Home Occupation Permit $1,600.00 $1,802.00 $674.93 $2,476.93 $876.93 $876.93
10‐100‐450040 Abandoned Bldg. Regist. $0.00 $2,890.00 $0.00 $2,890.00 $2,890.00 $2,890.00
10‐100‐450041 Abandoned Bldg. Admin Fee $6,500.00 $151,010.30 ($14,911.69)$136,098.61 $129,598.61 $129,598.61
10‐100‐450045 Building Construct. Fees $245,000.00 $119,295.50 $140,632.53 $259,928.03 $14,928.03 $14,928.03
10‐100‐450050 Electrical Certificates $19,000.00 $18,714.00 $2,018.34 $20,732.34 $1,732.34 $1,732.34
10‐100‐450060 Electrical Permits $4,000.00 $1,037.14 $2,276.96 $3,314.10 ($685.90)($685.90)
10‐100‐450070 Plumbing Licenses $10,500.00 $11,379.00 $1,053.45 $12,432.45 $1,932.45 $1,932.45
10‐100‐450080 Plumbing Permits $3,600.00 $2,860.25 $1,661.73 $4,521.98 $921.98 $921.98
FY2018
Revenue Model Report (Detail)Remaining
For the Period Ending May 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 6/6/18 As of 6/6/18 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $867.00 $1,068.25 $1,935.25 ($64.75)($64.75)
10‐100‐450091 Day Care Inspection Fees $7,000.00 $4,615.00 $3,281.05 $7,896.05 $896.05 $896.05
10‐100‐450092 Food Inspection Fees $85,000.00 $86,410.74 ($884.43)$85,526.31 $526.31 $526.31
10‐100‐450100 Curb Cut Permits $800.00 $424.00 $303.44 $727.44 ($72.56)($72.56)
10‐100‐450110 Board Of Adj Fees $1,300.00 $630.00 $650.48 $1,280.48 ($19.52)($19.52)
10‐100‐450120 Sign Permits $6,000.00 $2,933.00 $2,375.81 $5,308.81 ($691.19)($691.19)
10‐100‐450130 Demolition Permits $900.00 $583.00 $449.43 $1,032.43 $132.43 $132.43
10‐100‐450150 Acc Rep Fees‐police $11,200.00 $7,070.20 $5,181.56 $12,251.76 $1,051.76 $1,051.76
10‐100‐450160 Accrpt/blastg P‐fire $900.00 $358.00 $615.87 $973.87 $73.87 $73.87
10‐100‐450170 Animal Redemption Fees $63,000.00 $29,623.28 $30,858.30 $60,481.58 ($2,518.42)($2,518.42)
10‐100‐450180 Animal Vaccinations Fees $4,800.00 $2,950.00 $2,072.92 $5,022.92 $222.92 $222.92
10‐100‐450185 Animal Cremation Fees $33,000.00 $23,819.00 $17,219.45 $41,038.45 $8,038.45 $8,038.45
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 $52.00 $0.00 $52.00 $52.00 $52.00
10‐100‐450230 Vacating Right Of Way $800.00 $532.00 $307.80 $839.80 $39.80 $39.80
10‐100‐450250 Rezoning Request $10,000.00 $4,233.00 $1,966.58 $6,199.58 ($3,800.42)($3,800.42)
10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $5,122.00 $2,762.77 $7,884.77 ($115.23)($115.23)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,203.00 $631.55 $1,834.55 $34.55 $34.55
$800,700.00 $676,577.88 $299,090.57 $975,668.45 $174,968.45 $174,968.45
Fines & Forfeitures
10‐100‐460010 Court Cost $73,000.00 $41,014.50 $30,347.96 $71,362.46 ($1,637.54)($1,637.54)
10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐460018 Inmate Security Fund $12,500.00 $6,779.51 $5,260.69 $12,040.20 ($459.80)($459.80)
10‐100‐460020 Jail Cost Recovery $2,000.00 $1,472.93 $679.08 $2,152.01 $152.01 $152.01
10‐100‐460025 Alcohol Offense Cost Rec $7,500.00 $2,733.78 $2,589.09 $5,322.87 ($2,177.13)($2,177.13)
10‐100‐460030 Pol Fines‐traffic $750,000.00 $368,149.02 $308,975.36 $677,124.38 ($72,875.62)($72,875.62)
10‐100‐460090 Parking Fines $53,000.00 $54,238.24 $26,938.29 $81,176.53 $28,176.53 $28,176.53
10‐100‐460100 Bankcard Charges ($3,900.00)($1,256.96)($2,117.38)($3,374.34)$525.66 $525.66
$894,100.00 $473,131.02 $372,673.09 $845,804.11 ($48,295.89)($48,295.89)
Contributions/Donations
10‐100‐480055 JC Fire Museum $0.00 $1,546.00 $0.00 $1,546.00 $1,546.00 $1,546.00
10‐100‐480070 Community Projects Donations $1,100.00 $1,100.00 $0.00 $1,100.00 $0.00 $0.00
10‐100‐480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00
10‐100‐480090 Police K‐9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00
10‐100‐480165 Animal S Donations $0.00 $12,249.00 $0.00 $12,249.00 $12,249.00 $12,249.00
10‐100‐481055 Street Repair‐Solid Waste Cntr $312,862.50 $103,000.00 $209,862.50 $312,862.50 $0.00 $0.00
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$314,462.50 $118,895.00 $209,862.50 $328,757.50 $14,295.00 $14,295.00
Other Operating Revenues
10‐100‐480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10‐100‐481070 Miscellaneous $36,000.00 $15,987.90 $13,072.68 $29,060.58 ($6,939.42)($6,939.42)
10‐100‐481072 TIF Prof Svcs Deposit $0.00 $3,712.50 $0.00 $3,712.50 $3,712.50 $3,712.50
10‐100‐481074 Revenue Share ‐ Purchasing Card $18,000.00 $10,178.97 $9,051.21 $19,230.18 $1,230.18 $1,230.18
10‐100‐481077 Insurance Claims $20,000.00 $13,614.81 $15,152.91 $28,767.72 $8,767.72 $8,767.72
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$84,000.00 $43,494.18 $47,276.80 $90,770.98 $6,770.98 $6,770.98
Interest Income
10‐100‐470010 Interest $121,062.39 $85,915.46 $64,277.83 $150,193.29 $29,130.90 $29,130.90
$121,062.39 $85,915.46 $64,277.83 $150,193.29 $29,130.90 $29,130.90
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $45,000.00 $31,343.40 $30,000.00 $61,343.40 $16,343.40 $16,343.40
$45,000.00 $31,343.40 $30,000.00 $61,343.40 $16,343.40 $16,343.40
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $24,024.00 $11,164.00 $13,061.86 $24,225.86 $201.86 $201.86
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$24,024.00 $11,164.00 $13,061.86 $24,225.86 $201.86 $201.86
$32,106,551.08 $20,028,584.04 $12,338,105.53 $32,366,689.57 $260,138.49 $260,138.49