HomeMy Public PortalAbout2018-12 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
Oc
t
o
b
e
r
31
,
20
1
8
Da
t
a
as
of
De
c
e
m
b
e
r
7,
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
12
/
7
/
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
$
1
1
,
4
7
0
,
0
5
2
.
2
8
$
5
7
,
0
5
2
.
2
8
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
$
2
,
1
6
5
,
6
1
1
.
5
2
$
1
5
,
9
2
3
.
6
6
Ot
h
e
r
Ta
x
e
s
$1
1
5
,
0
0
0
.
0
0
$
1
0
7
,
4
6
0
.
3
6
($
7
,
5
3
9
.
6
4
)
Fr
a
n
c
h
i
s
e
& Ut
i
l
i
t
y
Ta
x
$7
,
5
5
2
,
8
2
8
.
5
6
$
7
,
6
8
4
,
5
8
9
.
7
2
$
1
3
1
,
7
6
1
.
1
6
Pr
o
p
e
r
t
y
Ta
x
e
s
$5
,
4
0
6
,
3
9
9
.
0
0
$
5
,
4
6
0
,
7
9
4
.
2
5
$
5
4
,
3
9
5
.
2
5
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$4
3
6
,
4
7
9
.
5
0
$
1
6
7
,
1
9
2
.
9
8
($
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
,
8
4
6
,
2
2
6
.
4
0
$
8
1
,
3
9
4
.
7
1
Fe
e
s
,
Li
c
e
n
s
e
s
,
& Pe
r
m
i
t
s
$8
0
0
,
7
0
0
.
0
0
$
9
6
2
,
1
1
9
.
2
0
$
1
6
1
,
3
8
0
.
8
2
Fi
n
e
s
& Fo
r
f
e
i
t
u
r
e
s
$8
9
4
,
1
0
0
.
0
0
$
7
8
0
,
5
3
1
.
3
8
($
1
1
3
,
5
6
8
.
6
2
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
1
6
,
1
8
7
.
5
0
$
2
8
0
,
4
9
2
.
6
0
$
1
5
,
8
0
5
.
1
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
$
1
1
0
,
8
6
6
.
2
8
$
2
6
,
8
6
6
.
2
8
In
t
e
r
e
s
t
In
c
o
m
e
$1
2
1
,
0
6
2
.
3
9
$
1
5
5
,
0
7
0
.
7
9
$
4
6
,
6
0
6
.
4
1
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
$
1
0
2
,
0
8
7
.
7
5
$
5
7
,
0
8
7
.
7
5
Op
e
r
a
t
i
n
g
Tr
a
n
s
f
e
r
s
In
$2
4
,
0
2
4
.
0
0
$2
4
,
1
0
1
.
8
3
$7
7
.
8
3
To
t
a
l
s
$3
2
,
2
3
2
,
6
1
2
.
6
4
$
3
2
,
3
1
7
,
1
9
7
.
3
4
$
3
2
7
,
2
2
7
.
0
7
FY2018
Revenue Model Report (Detail)Remaining
For the Period Ending October 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 12/7/18 As of 12/7/18 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $11,413,000.00 $11,470,052.28 $0.00 $11,470,052.28 $57,052.28 $57,052.28
$11,413,000.00 $11,470,052.28 $0.00 $11,470,052.28 $57,052.28 $57,052.28
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $562,000.00 $540,478.40 $42,823.13 $583,301.53 $21,301.53 $21,301.53
10‐100‐403010 Gasoline Tax $1,147,000.00 $1,055,340.56 $66,489.02 $1,121,829.58 ($25,170.42)($25,170.42)
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 $2,165,611.52 $109,312.14 $2,274,923.66 $15,923.66 $15,923.66
Other Taxes
10‐100‐403020 Cig Tax $115,000.00 $107,460.36 $0.00 $107,460.36 ($7,539.64)($7,539.64)
$115,000.00 $107,460.36 $0.00 $107,460.36 ($7,539.64)($7,539.64)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,050,000.00 $4,185,671.52 $0.00 $4,185,671.52 $135,671.52 $135,671.52
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 $957,893.50 $0.00 $957,893.50 $57,893.50 $57,893.50
10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $1,827,528.11 $0.00 $1,827,528.11 ($222,471.89)($222,471.89)
10‐100‐410053 Telephone/Cell Audit $122,828.56 $122,828.56 $0.00 $122,828.56 $0.00 $0.00
10‐100‐410060 Cable Franchise Fee $430,000.00 $357,507.83 $0.00 $357,507.83 ($72,492.17)($72,492.17)
$7,552,828.56 $7,684,589.72 $0.00 $7,684,589.72 $131,761.16 $131,761.16
Property Taxes
10‐100‐420010 Current Property Tax $4,740,000.00 $4,761,804.77 $0.00 $4,761,804.77 $21,804.77 $21,804.77
10‐100‐420020 Del Property Tax $40,000.00 $36,264.46 $0.00 $36,264.46 ($3,735.54)($3,735.54)
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 $31,399.51 $0.00 $31,399.51 $6,399.51 $6,399.51
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 $466,758.89 $0.00 $466,758.89 ($2,241.11)($2,241.11)
10‐100‐420080 Special Tax Rev $30,000.00 $72,890.84 $0.00 $72,890.84 $42,890.84 $42,890.84
$5,406,399.00 $5,460,794.25 $0.00 $5,460,794.25 $54,395.25 $54,395.25
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 $1,508.00 $237.40 $1,270.60 $1,508.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 $0.00 $0.00 $0.00 $0.00 $0.00
$436,479.50 $167,192.98 $69,270.60 $236,463.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 $26,219.00 $0.00 $26,219.00 $219.00 $219.00
10‐100‐440910 Fuel Charge ‐ backs $14,000.00 $10,854.84 $0.00 $10,854.84 ($3,145.16)($3,145.16)
10‐100‐440920 Parts Charge backs $185,000.00 $231,339.74 $0.00 $231,339.74 $46,339.74 $46,339.74
10‐100‐440930 Labor Charge backs $245,000.00 $241,021.65 $0.00 $241,021.65 ($3,978.35)($3,978.35)
10‐100‐481020 Cole Cty Animal Rescue $108,145.00 $108,145.72 $0.00 $108,145.72 $0.72 $0.72
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 $12,000.00 $0.00 $12,000.00 $12,000.00 $12,000.00
10‐100‐481045 Rent‐tower Sites $140,000.00 $153,218.11 $0.00 $153,218.11 $13,218.11 $13,218.11
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 $376,774.36 $0.00 $376,774.36 ($594.14)($594.14)
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 $23,747.73 $0.00 $23,747.73 $6,897.73 $6,897.73
10‐100‐481100 Sale Of Grave Sites $4,000.00 $4,533.00 $0.00 $4,533.00 $533.00 $533.00
10‐100‐481105 TIF Administration Fee $8,912.19 $8,912.19 $0.00 $8,912.19 $0.00 $0.00
10‐100‐481110 Long & Short $0.00 ($14.94)$0.00 ($14.94)($14.94)($14.94)
$2,764,831.69 $2,846,226.40 $0.00 $2,846,226.40 $81,394.71 $81,394.71
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $59,000.00 $67,581.84 $0.00 $67,581.84 $8,581.84 $8,581.84
10‐100‐450020 Business Licenses $215,000.00 $210,028.69 $0.00 $210,028.69 ($4,971.31)($4,971.31)
10‐100‐450021 Home Occupation Permit $1,600.00 $2,462.00 $0.00 $2,462.00 $862.00 $862.00
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 $55,952.00 $0.00 $55,952.00 $49,452.00 $49,452.00
10‐100‐450045 Building Construct. Fees $245,000.00 $321,005.00 $0.00 $321,005.00 $76,005.00 $76,005.00
10‐100‐450050 Electrical Certificates $19,000.00 $21,450.00 $0.00 $21,450.00 $2,450.00 $2,450.00
10‐100‐450060 Electrical Permits $4,000.00 $3,507.17 $0.00 $3,507.17 ($492.83)($492.83)
10‐100‐450070 Plumbing Licenses $10,500.00 $13,107.00 $0.00 $13,107.00 $2,607.00 $2,607.00
10‐100‐450080 Plumbing Permits $3,600.00 $5,798.50 $0.00 $5,798.50 $2,198.50 $2,198.50
FY2018
Revenue Model Report (Detail)Remaining
For the Period Ending October 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 12/7/18 As of 12/7/18 TOTAL (Under) Budget of Formulas
10‐100‐450090 Other Lic & Permits $2,000.00 $2,151.00 ($38.38)$2,112.62 $112.62 $112.62
10‐100‐450091 Day Care Inspection Fees $7,000.00 $7,310.00 $0.00 $7,310.00 $310.00 $310.00
10‐100‐450092 Food Inspection Fees $85,000.00 $89,793.32 $0.00 $89,793.32 $4,793.32 $4,793.32
10‐100‐450100 Curb Cut Permits $800.00 $3,404.00 $0.00 $3,404.00 $2,604.00 $2,604.00
10‐100‐450110 Board Of Adj Fees $1,300.00 $1,830.00 $0.00 $1,830.00 $530.00 $530.00
10‐100‐450120 Sign Permits $6,000.00 $5,401.00 $0.00 $5,401.00 ($599.00)($599.00)
10‐100‐450130 Demolition Permits $900.00 $1,789.00 $0.00 $1,789.00 $889.00 $889.00
10‐100‐450150 Acc Rep Fees‐police $11,200.00 $11,471.40 $0.00 $11,471.40 $271.40 $271.40
10‐100‐450160 Accrpt/blastg P‐fire $900.00 $1,269.00 $0.00 $1,269.00 $369.00 $369.00
10‐100‐450170 Animal Redemption Fees $63,000.00 $64,238.28 $0.00 $64,238.28 $1,238.28 $1,238.28
10‐100‐450180 Animal Vaccinations Fees $4,800.00 $5,150.00 $0.00 $5,150.00 $350.00 $350.00
10‐100‐450185 Animal Cremation Fees $33,000.00 $41,028.00 $0.00 $41,028.00 $8,028.00 $8,028.00
10‐100‐450186 Animal Boarding Fees $0.00 $320.00 $0.00 $320.00 $320.00 $320.00
10‐100‐450190 Taxi Permits $0.00 $79.00 $0.00 $79.00 $79.00 $79.00
10‐100‐450230 Vacating Right Of Way $800.00 $532.00 $0.00 $532.00 ($268.00)($268.00)
10‐100‐450250 Rezoning Request $10,000.00 $4,783.00 $0.00 $4,783.00 ($5,217.00)($5,217.00)
10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $15,880.00 $0.00 $15,880.00 $7,880.00 $7,880.00
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,908.00 $0.00 $1,908.00 $108.00 $108.00
$800,700.00 $962,119.20 ($38.38)$962,080.82 $161,380.82 $161,380.82
Fines & Forfeitures
10‐100‐460010 Court Cost $73,000.00 $69,740.75 $0.00 $69,740.75 ($3,259.25)($3,259.25)
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 $11,560.30 $0.00 $11,560.30 ($939.70)($939.70)
10‐100‐460020 Jail Cost Recovery $2,000.00 $2,512.42 $0.00 $2,512.42 $512.42 $512.42
10‐100‐460025 Alcohol Offense Cost Rec $7,500.00 $4,154.90 $0.00 $4,154.90 ($3,345.10)($3,345.10)
10‐100‐460030 Pol Fines‐traffic $750,000.00 $630,546.09 $0.00 $630,546.09 ($119,453.91)($119,453.91)
10‐100‐460090 Parking Fines $53,000.00 $65,089.24 $0.00 $65,089.24 $12,089.24 $12,089.24
10‐100‐460100 Bankcard Charges ($3,900.00)($3,072.32)$0.00 ($3,072.32)$827.68 $827.68
$894,100.00 $780,531.38 $0.00 $780,531.38 ($113,568.62)($113,568.62)
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 $2,825.00 $2,825.00 $0.00 $2,825.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 $15,380.60 $0.00 $15,380.60 $15,380.60 $15,380.60
10‐100‐481055 Street Repair‐Solid Waste Cntr $312,862.50 $259,741.00 $51,500.00 $311,241.00 ($1,621.50)($1,621.50)
10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$316,187.50 $280,492.60 $51,500.00 $331,992.60 $15,805.10 $15,805.10
Other Operating Revenues
10‐100‐480011 Police Evidence Funds $0.00 $22,882.36 $0.00 $22,882.36 $22,882.36 $22,882.36
10‐100‐481070 Miscellaneous $36,000.00 $34,536.78 $0.00 $34,536.78 ($1,463.22)($1,463.22)
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 $19,269.19 $0.00 $19,269.19 $1,269.19 $1,269.19
10‐100‐481077 Insurance Claims $20,000.00 $16,795.57 $0.00 $16,795.57 ($3,204.43)($3,204.43)
10‐100‐481078 Cafeteria Refunds $10,000.00 $13,669.88 $0.00 $13,669.88 $3,669.88 $3,669.88
$84,000.00 $110,866.28 $0.00 $110,866.28 $26,866.28 $26,866.28
Interest Income
10‐100‐470010 Interest $121,062.39 $155,070.79 $12,598.01 $167,668.80 $46,606.41 $46,606.41
$121,062.39 $155,070.79 $12,598.01 $167,668.80 $46,606.41 $46,606.41
Other Non Operating Revenue
10‐100‐485050 Sale Of Assets $45,000.00 $102,087.75 $0.00 $102,087.75 $57,087.75 $57,087.75
$45,000.00 $102,087.75 $0.00 $102,087.75 $57,087.75 $57,087.75
Operating Transfers In
10‐100‐490240 Trsfr From Lodging Tax $24,024.00 $24,101.83 $0.00 $24,101.83 $77.83 $77.83
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$24,024.00 $24,101.83 $0.00 $24,101.83 $77.83 $77.83
$32,232,612.64 $32,317,197.34 $242,642.37 $32,559,839.71 $327,227.07 $327,227.07