HomeMy Public PortalAbout2018-02 Meeting - Revenue Model ReportRe
v
e
n
u
e
Mo
d
e
l
Re
p
o
r
t
Fo
r
Pe
r
i
o
d
En
d
i
n
g
Ja
n
u
a
r
y
31
,
20
1
8
Da
t
a
as
of
Fe
b
r
u
a
r
y
5,
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
2/
5
/
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
$
8
8
4
,
2
5
9
.
2
8
($
1
3
3
,
5
0
6
.
9
2
)
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
4
2
,
7
3
0
.
1
7
$
9
,
4
1
1
.
5
2
Ot
h
e
r
Ta
x
e
s
$1
1
5
,
0
0
0
.
0
0
$
1
7
,
0
2
4
.
5
2
($
2
,
2
8
9
.
1
1
)
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
$
1
,
0
0
2
,
7
0
4
.
4
3
($
9
1
,
1
4
3
.
5
0
)
Pr
o
p
e
r
t
y
Ta
x
e
s
$5
,
4
0
6
,
3
9
9
.
0
0
$
5
,
1
4
9
,
1
2
0
.
1
0
($
2
6
,
6
4
7
.
3
9
)
In
t
e
r
g
o
v
e
r
n
m
e
n
t
a
l
$4
3
4
,
9
7
1
.
5
0
$
4
7
,
0
9
7
.
3
8
$
0
.
0
0
Ch
a
r
g
e
s
fo
r
Se
r
v
i
c
e
s
$2
,
7
6
4
,
8
3
1
.
6
9
$
1
,
8
5
9
,
0
6
9
.
2
2
$
6
,
6
4
7
.
7
2
Fe
e
s
,
Li
c
e
n
s
e
s
,
& Pe
r
m
i
t
s
$8
0
0
,
7
0
0
.
0
0
$
3
0
3
,
8
0
0
.
9
4
$
1
4
8
,
7
4
3
.
7
3
Fi
n
e
s
& Fo
r
f
e
i
t
u
r
e
s
$8
9
4
,
1
0
0
.
0
0
$
1
7
4
,
6
6
1
.
8
8
($
3
2
,
0
1
2
.
1
6
)
Co
n
t
r
i
b
u
t
i
o
n
s
/
D
o
n
a
t
i
o
n
s
$3
1
3
,
7
1
2
.
5
0
$
3
5
,
6
4
0
.
0
0
$
9
,
0
4
0
.
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
$
1
0
,
0
1
8
.
7
2
($
1
,
5
8
5
.
0
4
)
In
t
e
r
e
s
t
In
c
o
m
e
$1
2
1
,
0
6
2
.
3
9
$
1
1
,
3
9
1
.
8
2
($
3
,
6
3
9
.
4
3
)
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
$4
,
0
5
0
.
9
3
$2
2
6
.
4
8
To
t
a
l
s
$3
2
,
1
0
5
,
8
0
1
.
0
8
$
9
,
6
7
2
,
9
1
2
.
7
9
($
1
0
0
,
4
1
0
.
7
0
)
FY2018
Revenue Model Report (Detail)Remaining
For Period Ending January 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 2/5/18 As of 2/5/18 TOTAL (Under) Budget of Formulas
Sales Tax and Use Tax
10‐100‐400010 Sales Tax $11,413,000.00 $884,259.28 $10,395,233.80 $11,279,493.08 ($133,506.92)($133,506.92)
$11,413,000.00 $884,259.28 $10,395,233.80 $11,279,493.08 ($133,506.92) ($133,506.92)
Intergovernmental Taxes
10‐100‐401030 Motor Vehicle Sales Tax $562,000.00 $46,963.72 $519,123.99 $566,087.71 $4,087.71 $4,087.71
10‐100‐403010 Gasoline Tax $1,147,000.00 $95,766.45 $1,056,557.36 $1,152,323.81 $5,323.81 $5,323.81
10‐100‐430080 Road & Bridge Tax $550,000.00 $0.00 $550,000.00 $550,000.00 $0.00 $0.00
$2,259,000.00 $142,730.17 $2,125,681.35 $2,268,411.52 $9,411.52 $9,411.52
Other Taxes
10‐100‐403020 Cig Tax $115,000.00 $17,024.52 $95,686.37 $112,710.89 ($2,289.11)($2,289.11)
$115,000.00 $17,024.52 $95,686.37 $112,710.89 ($2,289.11)($2,289.11)
Franchise & Utility Tax
10‐100‐410020 Electric Utility Lic Tax $4,050,000.00 $522,873.12 $3,516,963.51 $4,039,836.63 ($10,163.37)($10,163.37)
10‐100‐410030 Gas Utility License Tax $900,000.00 $164,444.80 $724,370.73 $888,815.53 ($11,184.47)($11,184.47)
10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $314,537.51 $1,696,595.58 $2,011,133.09 ($38,866.91)($38,866.91)
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 $16,059.20 $383,012.04 $399,071.24 ($30,928.76)($30,928.76)
$7,430,000.00 $1,002,704.43 $6,336,152.07 $7,338,856.50 ($91,143.50)($91,143.50)
Property Taxes
10‐100‐420010 Current Property Tax $4,740,000.00 $4,584,140.65 $148,219.75 $4,732,360.40 ($7,639.60)($7,639.60)
10‐100‐420020 Del Property Tax $40,000.00 ($4,274.55)$28,880.87 $24,606.32 ($15,393.68)($15,393.68)
10‐100‐420040 Fin Institution Tax $48,000.00 $37,069.23 $0.00 $37,069.23 ($10,930.77)($10,930.77)
10‐100‐420050 Prop Tax Int & Penalties $25,000.00 $4,423.66 $21,014.32 $25,437.98 $437.98 $437.98
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 $449,343.71 $11,644.94 $460,988.65 ($8,011.35)($8,011.35)
10‐100‐420080 Special Tax Rev $30,000.00 $24,018.12 $20,871.62 $44,889.74 $14,889.74 $14,889.74
$5,406,399.00 $5,149,120.10 $230,631.51 $5,379,751.61 ($26,647.39)($26,647.39)
Intergovernmental
10‐100‐430010 Federal Grant $434,971.50 $0.00 $434,971.50 $434,971.50 $0.00 $0.00
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 $47,097.38 $387,874.12 $434,971.50 $0.00 $0.00
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 $0.00 $25,000.00 $25,000.00 $0.00 $0.00
10‐100‐440210 Street Cuts $26,000.00 $4,161.00 $19,774.76 $23,935.76 ($2,064.24)($2,064.24)
10‐100‐440910 Fuel Charge ‐ backs $14,000.00 $2,310.60 $10,281.05 $12,591.65 ($1,408.35)($1,408.35)
10‐100‐440920 Parts Charge backs $185,000.00 $46,208.68 $143,870.89 $190,079.57 $5,079.57 $5,079.57
10‐100‐440930 Labor Charge backs $245,000.00 $43,891.97 $186,524.85 $230,416.82 ($14,583.18)($14,583.18)
10‐100‐481020 Cole Cty Animal Rescue $108,145.00 $27,036.43 $81,108.75 $108,145.18 $0.18 $0.18
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 $13,428.51 $124,679.85 $138,108.36 ($1,891.64)($1,891.64)
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 $92,780.53 $284,528.52 $377,309.05 ($59.45)($59.45)
10‐100‐481080 Sale Of Maps/GIS Data $0.00 $50.00 $0.00 $50.00 $50.00 $50.00
10‐100‐481085 Cole Cty GIS Joint Coop $16,850.00 $3,750.00 $13,100.00 $16,850.00 $0.00 $0.00
10‐100‐481100 Sale Of Grave Sites $4,000.00 $816.00 $2,629.34 $3,445.34 ($554.66)($554.66)
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 $1,859,069.22 $912,410.19 $2,771,479.41 $6,647.72 $6,647.72
Fees, Licenses, & Permits
10‐100‐450010 Liquor Licenses $59,000.00 $1,272.50 $58,812.16 $60,084.66 $1,084.66 $1,084.66
10‐100‐450020 Business Licenses $215,000.00 $71,305.92 $161,976.07 $233,281.99 $18,281.99 $18,281.99
10‐100‐450021 Home Occupation Permit $1,600.00 $371.00 $1,233.54 $1,604.54 $4.54 $4.54
10‐100‐450040 Abandoned Bldg. Regist. $0.00 $2,740.00 $0.00 $2,740.00 $2,740.00 $2,740.00
10‐100‐450041 Abandoned Bldg. Admin Fee $6,500.00 $123,500.30 ($2,754.74)$120,745.56 $114,245.56 $114,245.56
10‐100‐450045 Building Construct. Fees $245,000.00 $48,158.23 $209,973.08 $258,131.31 $13,131.31 $13,131.31
10‐100‐450050 Electrical Certificates $19,000.00 $13,572.00 $5,885.13 $19,457.13 $457.13 $457.13
10‐100‐450060 Electrical Permits $4,000.00 $560.00 $3,204.09 $3,764.09 ($235.91)($235.91)
10‐100‐450070 Plumbing Licenses $10,500.00 $7,683.00 $2,937.90 $10,620.90 $120.90 $120.90
10‐100‐450080 Plumbing Permits $3,600.00 $1,030.00 $2,919.25 $3,949.25 $349.25 $349.25
10‐100‐450090 Other Lic & Permits $2,000.00 $157.00 $1,476.80 $1,633.80 ($366.20)($366.20)
FY2018
Revenue Model Report (Detail)Remaining
For Period Ending January 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification
Description Budget As of 2/5/18 As of 2/5/18 TOTAL (Under) Budget of Formulas
10‐100‐450091 Day Care Inspection Fees $7,000.00 $1,990.00 $5,398.69 $7,388.69 $388.69 $388.69
10‐100‐450092 Food Inspection Fees $85,000.00 $3,482.99 $80,477.30 $83,960.29 ($1,039.71)($1,039.71)
10‐100‐450100 Curb Cut Permits $800.00 $106.00 $619.77 $725.77 ($74.23)($74.23)
10‐100‐450110 Board Of Adj Fees $1,300.00 $210.00 $1,000.29 $1,210.29 ($89.71)($89.71)
10‐100‐450120 Sign Permits $6,000.00 $1,059.00 $5,099.59 $6,158.59 $158.59 $158.59
10‐100‐450130 Demolition Permits $900.00 $371.00 $674.15 $1,045.15 $145.15 $145.15
10‐100‐450150 Acc Rep Fees‐police $11,200.00 $2,815.00 $8,665.69 $11,480.69 $280.69 $280.69
10‐100‐450160 Accrpt/blastg P‐fire $900.00 $19.00 $836.59 $855.59 ($44.41)($44.41)
10‐100‐450170 Animal Redemption Fees $63,000.00 $10,120.00 $50,164.45 $60,284.45 ($2,715.55)($2,715.55)
10‐100‐450180 Animal Vaccinations Fees $4,800.00 $1,225.00 $3,712.57 $4,937.57 $137.57 $137.57
10‐100‐450185 Animal Cremation Fees $33,000.00 $7,459.00 $26,997.73 $34,456.73 $1,456.73 $1,456.73
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 $26.00 $0.00 $26.00 $26.00 $26.00
10‐100‐450230 Vacating Right Of Way $800.00 $266.00 $553.20 $819.20 $19.20 $19.20
10‐100‐450250 Rezoning Request $10,000.00 $1,462.00 $8,421.14 $9,883.14 ($116.86)($116.86)
10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $2,097.00 $5,584.12 $7,681.12 ($318.88)($318.88)
10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $743.00 $1,774.22 $2,517.22 $717.22 $717.22
$800,700.00 $303,800.94 $645,642.79 $949,443.73 $148,743.73 $148,743.73
Fines & Forfeitures
10‐100‐460010 Court Cost $73,000.00 $17,189.80 $55,742.14 $72,931.94 ($68.06)($68.06)
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 $2,849.07 $9,597.55 $12,446.62 ($53.38)($53.38)
10‐100‐460020 Jail Cost Recovery $2,000.00 $190.17 $1,554.85 $1,745.02 ($254.98)($254.98)
10‐100‐460025 Alcohol Offense Cost Rec $7,500.00 $762.94 $5,839.28 $6,602.22 ($897.78)($897.78)
10‐100‐460030 Pol Fines‐traffic $750,000.00 $140,360.22 $579,842.47 $720,202.69 ($29,797.31)($29,797.31)
10‐100‐460090 Parking Fines $53,000.00 $13,725.64 $38,287.16 $52,012.80 ($987.20)($987.20)
10‐100‐460100 Bankcard Charges ($3,900.00)($415.96)($3,437.50)($3,853.46)$46.54 $46.54
$894,100.00 $174,661.88 $687,425.96 $862,087.84 ($32,012.16)($32,012.16)
Contributions/Donations
10‐100‐480055 JC Fire Museum $0.00 $860.00 $0.00 $860.00 $860.00 $860.00
10‐100‐480070 Community Projects Donations $350.00 $350.00 $0.00 $350.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 $7,680.00 $0.00 $7,680.00 $7,680.00 $7,680.00
10‐100‐481055 Street Repair‐Solid Waste Cntr $312,862.50 $25,750.00 $287,112.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
$313,712.50 $35,640.00 $287,112.50 $322,752.50 $9,040.00 $9,040.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 $4,781.76 $29,622.23 $34,403.99 ($1,596.01)($1,596.01)
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 $2,968.65 $15,649.02 $18,617.67 $617.67 $617.67
10‐100‐481077 Insurance Claims $20,000.00 $2,268.31 $17,124.98 $19,393.29 ($606.71)($606.71)
10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00
$84,000.00 $10,018.72 $72,396.24 $82,414.96 ($1,585.04)($1,585.04)
Interest Income
10‐100‐470010 Interest $121,062.39 $11,391.82 $106,031.14 $117,422.96 ($3,639.43)($3,639.43)
$121,062.39 $11,391.82 $106,031.14 $117,422.96 ($3,639.43)($3,639.43)
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 $4,050.93 $20,199.55 $24,250.48 $226.48 $226.48
10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$24,024.00 $4,050.93 $20,199.55 $24,250.48 $226.48 $226.48
$32,105,801.08 $9,672,912.79 $22,332,477.59 $32,005,390.38 ($100,410.70)($100,410.70)