HomeMy WebLinkAbout04/27/2015FINANCE COMMITTEE
April 27, 2015
5:10 PM
Harold E. Getty Council Chambers
Members
Chairperson Carolyn Cole
Vice Chair Steve Schmitt
David Jones
Roll Call:
Approval of Agenda
Approval of Minutes
of April 20, 2015 as proposed.
NEW BUSINESS
TRAVEL REQUESTS
1. Five (5) Waterloo Police Officers
Class/Meeting: CTK Advanced Interview and Interrogation School
Destination: Waterloo, Iowa
Dates. 5/27/15 - 5/28/15 Amount not to exceed: $1,000.00
2. Director, Trelka
Class/Meeting: Executive Session: Re -Engineering Police Use of Force
Destination: Washington, D.C.
Dates: 5/6/15 - 5/7/15 Amount not to exceed: $878.00
3. Investigator Pohl (Amended -Date Change)
Class/Meeting: MacIntosh and iDevice Training
Destination: Madison, Wisconsin
Dates: 3/23/15 - 3/26/15 Amount not to exceed: $903.00
4. Richard Olson, Maintenance Foreman
Class/Meeting: 5 hours of Backflow Tester Renewal - Education (CEU's)
Destination: Waterloo, Iowa
Dates: 5/13/15 Amount not to exceed: $135.00
5. Pre -Authorizations to Expend over $1,000.00
Building Maintenance
Amount and Estimated S/H: $5,779.82
Expenditure: Carpeting 2nd floor of Veteran's Memorial Hall
Central Garage
Amount and Estimated S/H: $7,545.11 + $302.12 S/H
Page 1 of 43
r
Expenditure: Vacuum breaker box assembly - 143001
Central Garage
Amount and Estimated S/H: $3,152.55 + $125.00 S/H
Expenditure: Inner boom tube - Truck 210
Central Garage
Amount and Estimated S/H: $3,797.05
Expenditure: Turbo, HE431V - Truck 710
Central Garage
Amount and Estimated S/H: $3,348.20
Expenditure: PTO and pump assembly - 530210
Central Garage
Amount and Estimated S/H: $5,605.30 + $200.00 S/H
Expenditure: Turbo Replacement - Fire Aerial 311
MIS
Amount and Estimated S/H: $1,710.18
Expenditure: 3 Windows Server Standard 2012 R2 licenses
Street
Amount and Estimated S/H: $4,544.55 + $175.00 S/H
Expenditure: Sweeper repair parts - 008
BUDGET LINE ITEMS TO BE AMENDED
6. Approve the project budget for the Cedar Trails Partnership bike maintenance
station project funded with a donation in the amount of $1,350, as submitted by the
Cultural & Arts Department..
7. Approve the project budget for the Mobilizing to End Mass Incarceration - An Action
Conference, funded with HUD Fair Housing Partnership funds in the amount of
42,000, as submitted by the Human Rights Department.
8. Approve the budget amendment for the Alcohol, tobacco and firearms Task Force in
the amount of $8,000, funded with federal reimbursements, as submitted by the Police
Department.
9. Approve the budget amendment for the Young Arena Improvements to use
MidAmerican Energy rebates revenue for improvements in the amount of $13,736, as
submitted by Leisure Services.
10. Approve the budget amendment to increase liability insurance claims paid funded
with fund balance restricted health insurance in the amount of $120,000, as submitted
by Clerk/Finance.
Page 2 of 43
11. Approve the budget amendment to increase other professional services for human
resources in the amount of $35,000,as submitted by Clerk/Finance.
12. Approve the budget amendment to increase the advertising budget for Cultural &
Arts funded with hotel/motel tax revenue awarded in the prior year in the amount of
$2,579.09, as submitted by the Cultural & Arts Department.
13. Approve the budget amendments to increase miscellaneous revenue in the Central
Garage activity to budget for a refund received and use the funds for parts in the
amount of $29,000 and to increase damage claims revenue in the Street Department
activity to budget for damage claim revenue received and use the funds for building
maintenance in the amount of $2,083, as submitted by the Central Garage.
BILLS PAYMENT
14. April 27th, 2015
ADJOURNMENT
Suzy Schares, CMC
City Clerk/Human Resource Director
Page 3 of 43
TRAVEL REQUEST
CITY OF WATERLOO
FINANCE DEPT.
LINE ITEM USED
FY _2015_ BUDGETED
EXPENDED YTD
THIS REQUEST
LEFT AFTER THIS
REQUEST
DATE
Original - Clerk/Finance
STAFF ONLY
010-11-1100-1346
`33 ce5
Copy - De•artment
NAME(S) AND POSITION(S):
Five (5) Waterloo Police Officers
DATE:
April 22nd, 2015
NAME OF CLASS / MEETING:
CTK Advanced Interview and Interrogation School
DESTINATION Waterloo, Iowa
DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE:
May 27, 2015
Return Date:
May 271', 2015
DATE(S) OF MEETING:
May 2711'-281h, 2015
PURPOSE OF TRAVEL:
Director Trelka is requesting authorization to send five (5)Officers to CTK Advanced Interview and Interrogation
school at Hawkeye Community College, in Waterloo, Iowa. This two day school is taught by CTK Group, who are
investigators from the Iowa Division of Criminal Investigation. The attendees will be taught on an advanced level
on how to improve their interview and interrogation skills to better improve our ability to solve crimes. The only
cost to the training is the registration fee.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
x COST $
YES NO
METHOD OF TRAVEL:
CITY VEHICLE PRIVATE VEHICLE
AIRFARE DEPARTING FROM:
ESTIMATE OF COST:
$.00 LODGING
$.00 MEALS
$1000.00 REGISTRATION
$.00 MILEAGE/FUEL
TOTAL FOR ALL: $ /000.00
Rental car
PARKING
AIRFARE
MISCITOLLS
BUDGET LINE ITEM:
x GRANT REIMBURSABLE
YES NO
x REQUIRED CERTIFICATION
YES NO
TOTAL: $ 250.00 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
I APPROVE THIS TRAVEL REQUEST
DEPARTMENT HEAD MAYOR
L1- 22-tom
DATE DATE
TRAVEL REQUEST
CITY OF WATERLOO
FINANCE DEPT.
LINE ITEM USED
FY _2015_ BUDGETED
EXPENDED YID
THIS REQUEST
LEFT AFTER THIS
REQUEST
DATE
Original - Clerk/Finance
STAFF ONLY
010-11-1100-1346
010-11-1200-1346
`3 SOZJ �r /cyzrz..Y
et46, 4=-1-
sad%sue
%w?S�/ — G7—
Cop - De..rtment
NAME(S) AND POSITION(S):
Director Dan Trelka
DATE:
April22nd, 2015
NAME OF CLASS / MEETING:
Executive Session: Re -Engineering Police Use of Force
DESTINATION Washington, DC
DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE:
May 6th, 2015
Return Date:
May 8m, 2015
DATE(S) OF MEETING:
May 6th-7th, 2015
PURPOSE OF TRAVEL:
Director Trelka is requesting authorization to attend the Executive Session Conference: Re -Engineering Police
Use of Force, in Washington, DC. At this conference, police executives from the United States and other nations
will be brought together to develop new systems and coordinated approaches to use of force training, policy, and
supervision. The hotel and flight is a package deal not to exceed $700.00.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
x COST $
YES NO
METHOD OF TRAVEL:
CITY VEHICLE
x PRIVATE VEHICLE
x AIRFARE DEPARTING FROM: Minneapolis, Minnesota
ESTIMATE OF COST:
$350.00 LODGING
$128.00 MEALS 50.00
$.00 REGISTRATION 350.00
$.00 MILEAGE/FUEL
TOTAL FOR ALL: $ 878.00
Rental car
PARKING
AIRFARE
MISC/TOLLS
BUDGET LINE ITEM:
x GRANT REIMBURSABLE
YES NO
x REQUIRED CERTIFICATION
YES NO
TOTAL: $ 878.00 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
I APPROVE THIS TRAVEL REQUEST
DEPARTMENT HEAD MAYOR
DATE DATE
TRAVEL REQUEST
CITY OF WATERLOO
FINANCE DEPT
LINE ITEM USED
FY _2015_ BUDGETED
EXPENDED YTD
THIS REQUEST
LEFT AFTER THIS
REQUEST
DATE
. STAFF ONLY
010-11-1100-1346
-;?/
j5
/2, /U1
Original- Clerk/Finance Co
- De•artment
NAME(S) AND POSITION(S):
Inv. Pohl
Amended
DATE:
February 11th, 2015
NAME OF CLASS / MEETING:
Macintosh and iDevice Training
DESTINATION: Madison, Wisconsin
DEPARTURE POINT
IF NOT WATERLOO:
DEPARTURE DATE:
Amended March22nd, 2015
Return Date:
March 26th , 2015
DATE(S) OF MEETING:
March 23rd-26th , 2015
PURPOSE OF TRAVEL:
Captain Mohlis is requesting authorization to send Inv. J. Pohl to Macintosh and iDevice Training (Cybercop 215 &
Cybercop 225) in Madison Wisconsin. This training will introduce Inv. Pohl to various models of Apple hardware that are
most likely to be encountered during an investigation. These classes also include the acquisition and analysis of data from
non-IOS devices. Inv. Pohl is currently assigned to the Investigations division and does computer forensics. A city vehicle
will be needed for this training.
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
x COST $
YES NO
METHOD OF TRAVEL:
x CITY VEHICLE
AIRFARE DEPARTING FROM:
PRIVATE VEHICLE
ESTIMATE OF COST:
$600.00 LODGING
$203.00 MEALS
$.00 REGISTRATION
$/00.00 MILEAGE/FUEL
TOTAL FOR ALL: $ 903.00
Rental car
PARKING
AIRFARE
MISCITOLLS
BUDGET LINE ITEM:
x GRANT REIMBURSABLE
YES NO
x REQUIRED CERTIFICATION
YES NO
TOTAL: $ 903.00 PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
DEPARTMENT HEAD
DATE
I APPROVE THIS TRAVEL REQUEST
MAYOR
DATE
TRAVEL REQUEST
CITY OF WATERLOO
NAME(S) AND POSITION(S):
Richard Olson
NAME OF CLASS 1 MEETING:
Relief Valves 101
DEPARTURE DATE:
May 13, 2015
PURPOSE OF TRAVELITRAINING:
5 hours for Backflow Tester Renewal —education CEU's
RETURN DATE:
May 13, 2015
WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL:
FINANCE
LINE ITEM USED
FY L. BUDGETED
EXPENDED YTD
THIS REQUEST
LEFT AFTER THIS
REQUEST
DATE
Original- Clerk/Finance
DATE:
4/22/15
DESTINATION: In Waterloo.
DEPARTURE POINT registration
IF NOT WATERLOO:
STAFF ONLY
Co
Y
/3 U-'
i5
/ 03
- De.artment
Location TBA with
DATE(S) OF MEETING:
May 13, 2015
x COST $
YES NO
METHOD OF TRAVEL:
xx CITY VEHICLE
AIRFARE DEPARTING FROM:
ESTIMATE OF COST:
LODGING TAXI
MEALS PARKING
135.00 REGISTRATION AIRFARE
MILEAGEIFUEL MISCITOLLS
TOTAL FOR ALL: $ 135.00
PRIVATE VEHICLE
520-14-5200-1346
BUDGET LINE ITEM:
GRANT REIMBURSABLE
YES NO
x
YES NO
REQUIRED CERTIFICATION
TOTAL: $ 135.00
PER PERSON
I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE
AND IS NECESSARY AND BENEFICIAL TO THE
CITY OF WATERLOO
TMMENT HEAD
l S
DATE DATE
K:\Shared Goodies\Forms\Travel Request Form January 2010
1 APPROVE THIS TRAVEL REQUEST
MAYOR
Registration: $135.00 ea.
Total Backflow
Payment required prior to class
o 0 • ) M O
a)ow
O c.3
zb'- 7 -:()c
Resources, Inc.
Relief Valves 101
5 hours for Backflow Tester Renewal
z
J
CD
U
10:00 — 10;15 Break
Address: /?c.
Ir
r.
fir
Please select a location
May 12, 2015--- Iowa City
X May 13, 2015----Waterloo
May 14, 2015 Des Moines
1:30- 1:45 Break
0
Addresses TBA with re
Closing/CEU's
w m 0 N
O � U • o '" O,4 1-4
31
+-� b0 q In e O o o 0
•
In • 5 • �� U o c o O o
w W .gyp., '-0 1:3 O c O
aa> CI 0 Ol 0 OOi y O
.+ c" 0 ^' O
rn ▪ • O. CI cn 0 c«•I k
�" • w Y o ri 44 cd U 'U con O ▪ ▪ -�
y w o p. y O In I -I 0 0 LI .) ct 0
0, U 1. o i �0 d ° O 6 0 Ca sn
cri
p O 0 o o> p 0 �.CI) .y W O
O .O0'4 � � v' a' Q '0 'b 0 C." SC a) cd
4-1 U
Cy U W r_ O i.i °) y U
G r. I~ w°J ai C"• m N U U N
0 y O aOi -� p p °) › O,g -0 y n 0
City Clerk Use Only
Finance Committee
Approval Date Vz7 /(
City of Waterloo
Expenditure Pre -Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Building Maint Department to expend
$ 5,779.82 plus est. shipping costs of $ to pay for or purchase
This purchase or expenditure is being made because:
Carpeting 2nd floor of Veteran's Memorial Hall
Vendor selected for this purchase: Floor Decor
ri Bids or written quotes were taken on this purchase, as follows:
Floor Decor - $ 5,779.82
0 Bids or quotes were not taken on this purchase because:
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
r7 General Fund n Road Use Tax r7 Sewer ❑ Sanitation
QX Bonds 0 Federal/other grants ❑ Other (specify)
This expenditure is to be coded to the following budget line -item:
414-22-8800-2152
(Fund - Department - Activity - Account Number) (Project Code)
in which the budgeted amount is
and the current available balance is
Resplly submitted,
f
(Signature Dept. Head or Designee)
7; 87l07'
/-4-5 /4 ,f t 4-�/
Date (Signat�re Finance Dept. Review) Date
K:\shared goodies\forms\Pe-Auth - Vet Hall Carpet 2nd Floor.xls (Mar 2010)
Sold to-<-LJ
r �T
706 Ansborough Avenue
Waterloo, Iowa 50701
Phone (319) 232-9242
FAX (319) 232-1516
Address:
City:
Home Phone -
Installed at:
Date
10 12
-7
/7
Style #
Color #
Area to Install
Sq. Yards
Unit Cost
Amount
7
r
i
INSTALLATION INSTRUCTIONS:
Labor: Carpet
Vinyl
Underlayment
Ceramic
Metals
Tear -Up
Subtotal
Sales Tax
Total
Total Labor
Grand Total
Furn. or Appt.. <; - Deposit
l - Balance Due
TYPE OF FLOOR 0 Wood ❑ Cement FURNITURE ❑ Yes ❑ No APPLIANCES ❑ Yes ❑ No
O Check El Cash ❑Charge ❑Other
CUSTOMER READ BEFORE SIGNING- Buyer understands that there may be a dye -lot variation from sample. Seller is not responsible for chips, dents or
conditions of existing mouldings, doors, jambs or fixtures. Room must be clear of obsticles at time of installation. Seller is not responsible for cutting doors.
Seller is not responsible for customer measurements. Seller is not responsible for manufacturer or shipper delays. Unforseen technical problems upon instal-
lation may change the amount due on this invoice. A FINANCE CHARGE of 1.5% (8% PER ANNUM) will be charged to accounts past 30 days. In the event
Buyer defaults under the terms of this agreement, Buyer agrees to pay responsible attorney fees, if the sums due are collected by or through a attorney.
Other:
PAYMENT IN FULL TO BE MADE UPON COMPLETION OF INSTALLATION, UNLESS OTHERWISE NOTED.
I/We the buyer(s) hereby accept the above terms and conditions:
Signature:
u/S/ ') J?
06,v 4 y 7 0
TO PLACE YOUR ORDER PLEASE CALL - 1-800-346-6429
Frp
Lt n I.
-
.v,n^4+ray.
Warehouse
GCD
Dye Lot Cartons
T06220 89
'/7. K.
Square Yards
704.88
Style
Color
Backing
Installation
Yarn Content
Fabric Type
Gauge
Pile Height
Stiches Per Inch
Pile Weight
Dye Method
Pattern Repeat
Square Yards Per Box
City of Waterloo
Expenditure Pre -Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Central Garage Department to expend
$ 7,545.11 plus est. shipping costs of $ 302.12 to pay for or purchase
Vacuum breaker box assembly - 143001
City Clerk Use Only
Finance Committee
Approval Date 4/2-7/1
This purchase or expenditure is being made because:
Excessive corrosion, box replacement required
Vendor selected for this purchase: Mid -Iowa Solid Waste
n Bids or written quotes were taken on this purchase, as follows:
n Bids or quotes were not taken on this purchase because:
OEM Only
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
❑X General Fund I I Road Use Tax n Sewer n Sanitation
Bonds n Federal/other grants n Other (specify)
This expenditure is to be coded to the following budget line -item:
010-18-7955-1569
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
1--� 4/-z0 -4s �il�r�d�uPCc_ �v2c9�
(Project Code)
$ 2AA706�96 off; /,J) J
%�
<Sl
$ /4,://
viL
K:\shared goodies\forms\Central Garage -Sewer - Vacuum breaker box - 143001 - Apr 2015.xls (Mar 2010)
City of Waterloo
Expenditure Pre -Authorization Request Form
City Clerk Use Only
Finance Committee
Approval Date 4/2.7/( 7
The Finance Committee of the City Council
purchase or expenditure submitted by the
$ 3,348.20 plus est. shipping costs of
PTO and pump assembly - 530210
is hereby requested to authorize the following
Central Garage Department to expend
$ 0.00 to pay for or purchase
This purchase or expenditure is being made because:
Internal failure - replacement required
Vendor selected for this purchase: SunSource
❑ Bids or written quotes were taken on this purchase, as follows:
❑ Bids or quotes were not taken on this purchase because:
OEM Only
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
General Fund ❑ Road Use Tax
❑ Sewer ❑ Sanitation
Bonds ri Federal/othergrants I I Other (specify)
This expenditure is to be coded to the following budget line -item:
010-18-7955-1569
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfully omitted,
(Project Code)
/J.J-c-61,u/L.
K:\shared goodies\forms\Central Garage -Sewer - PTO & Pump Assy - 530210 - Apr 2015.xls (Mar 2010)
City of Waterloo
Expenditure Pre -Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Central Garage Department to expend
$ 3,152.55 plus est. shipping costs of $ 125.00 to pay for or purchase
Inner boom tube - Truck 210
City Clerk Use Only
Finance Committee
Approval Date 4/2- 7A 5—
This purchase or expenditure is being made because:
Worn beyond limits
Vendor selected for this purchase: Elliott Equipment Co
Bids or written quotes were taken on this purchase, as follows:
nBids or quotes were not taken on this purchase because:
OEM only
Prior Committee Actions (Dates):
Please check the following bOx(es) as appropriate to describe the funding for this expense:
❑X General Fund Road Use Tax n Sewer El Sanitation
Bonds � Federal/other grants n Other (specify)
This expenditure is to be coded to the following budget line -item:
010-18-7955-1569
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
(Project Code)
$ 2843666-A0 Clv D 0 c)
$ 4, g3(e,
•
K:\shared goodies Worms \Central Garage - Inner Boom Tube - Sewer Truck 210 - April 2015.xls (Mar 2010)
0
City of Waterloo
Expenditure Pre -Authorization Request Form
City Clerk Use Only
Finance Committee
Approval Date 4/z7/15
The Finance Committee of the City Council
purchase or expenditure submitted by the
$ 3,797.05 plus est. shipping costs of
Turbo, HE431V - Truck 710
is hereby requested to authorize the following
Central Garage
$ 0.00
Department to expend
to pay for or purchase
This purchase or expenditure is being made because:
Turbo blown out - not repairable
Vendor selected for this purchase: Cummins Central Power
n Bids or written quotes were taken on this purchase, as follows:
n Bids or quotes were not taken on this purchase because:
OEM Only
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
General Fund n Road Use Tax n Sewer n
Sanitation
Bonds n Federal/other grants n Other (specify)
This expenditure is to be coded to the following budget line -item:
010-18-7955-1569
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfull submitted,
-V-7G /
(Project Code)
$ 200,00040 os4e5 m?U
K:\shared goodies\forms\Central Garage - Sanitation 710 Turbo Replacement - Apr 2015.xls (Mar 2010)
City of Waterloo
Expenditure Pre -Authorization Request Form
City Clerk Use Only
Finance Committee
Approval Date `/2 i/1
The Finance Committee of the City Council
purchase or expenditure submitted by the
$ 5,605.30 plus est. shipping costs of
Turbo Replacement - Fire Aerial 311
is hereby requested to authorize the following
Central Garage
$ 200.00
Department to expend
to pay for or purchase
This purchase or expenditure is being made because:
Turbo non -repairable
Vendor selected for this purchase: Altorfer Inc
n Bids or written quotes were taken on this purchase, as follows:
nBids or quotes were not taken on this purchase because:
OEM Only (Caterpillar)
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
General Fund n Road Use Tax n Sewer n Sanitation
Bonds n Federal/other grants n Other (specify)
This expenditure is to be coded to the following budget line -item:
010-18-1405-1569
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
/3-,
$
$
(Project Code)
-G0,000.GO— 746)0 c� ✓
Zy,?1LC., 4/JA,-(..aL42tI
K:\shared goodies\forms\Central Garage - Fire - Aerial 311 Turbo's - Mar 2015.xls (Mar 2010)
City of Waterloo
Expenditure Pre -Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the MIS Department to expend
$ 1,710.18 plus est. shipping costs of $ 0.00 to pay for or purchase
3 Windows Server Standard 2012 R2 licenses
City Clerk Use Only
Finance Committee
Approval Date/` 7//
This purchase or expenditure is being made because:
Server licenses are needed to upgrade existing servers which are running Server 2003
as that is no longer supported by Microsoft beginning this summer.
Vendor selected for this purchase: Insight
El Bids or written quotes were taken on this purchase, as follows:
Insight: $1710.18 (state bid)
CDWG: $1868.49
El Bids or quotes were not taken on this purchase because:
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
General Fund 0 Road Use Tax � Sewer 0 Sanitation
❑X Bonds Federal/other grants Ei Other (specify)
This expenditure is to be coded to the following budget line -item:
413 01 8225 2106
(Fund - Department - Activity - Account Number)
(Project Code)
in which the budgeted amount is $ 4gg-949� -ao y ��� 31'-
and the current available balance is $ 99,085.40
Respectfully submitted,
1 /&J i5 ,6rkt.Gvu k 41 71 5-
(Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Server licenses 4-27-15.xls (Mar 2010)
Insi ht.
PUBLIC SECTOR
SOLD -TO PARTY
CITY OF WATERLOO
MATT O'BRIEN
715 MULBERRY ST
WATERLOO IA 50703-5714
USA
SHIP -TO ADDRESS
CITY OF WATERLOO
MATT O'BRIEN
715 MULBERRY ST
WATERLOO IA 50703-5714
USA
We deliver according to the following terms:
Payment Terms
Ship Via
Terms of Delivery
Currency
Insight Public Sector SLED
6820 S HARL AVE
TEMPE AZ 85283-4318
Tel. 800-467-4448
Quotation Number
216665631
PO Number
PO Release
Customer No.
Sales Rep
Email
Telephone
Sales Rep 2
Email
Telephone
10706346
Shawn Wood
swood@insight.com
651523-6161
Beau Slayton
bslayton@insight.com
509742-2315 X 5097
Creation Date
15-APR-2015
: Net 30 days
: Electronic Delivery / Electronic Delivery
: FOB DESTINATION
: USD
Material Description
P73-06309-SLP
Microsoft Windows Server 2012 R2 Standard - License
- 2 processors - Select, Select Plus - Single Language
STATE OF IOWA COTS SOFTWARE CONTRACT(# 4276-12)
LICENSE:
Deploy To Date:
6193872
04/1512015
Quantity
3
Unit Price
570.06
Extended Price
1,710.18
Product Subtotal
Tax
1,710.18
0.00
Page 1 of 2
Ins7ght. ht
PUBLIC SECTOR
Quotation Number/ Creation Date
216665631 / 15-APR-2015
Total 1,710.18
Lease & Financing options available from Insight Global Finance for your equipment & software acquisitions. Contact
your Insight account executive for a quote.
Thank you for considering Insight. Please contact us with any questions or for additional information about Insight's
complete IT solution offering.
Sincerely,
Shawn Wood
651523-6161
swood@insight.com
Fax: 480760-9899
Beau Slayton
509742-2315 Ex 5097
bslayton@insight.com
Insight Global Finance has a wide variety of flexible financing options and technology refresh solutions. Contact your Insight representative
for an innovative approach to maximizing your technology and developing a strategy to manage your financial options.
Subject to IPS Terms & Conditions online unless purchase is being made pursuant to a separate written agreement in which case
the terms and conditions of the separate written agreement shall govern.
https://www. ips. insioht.com/us/en/terms-conditions/terms-of-sale-products. html
Page 2 of 2
CDW Shopping Cart
Page 1 of 152
Hi, Matt I Log Orr
Hardware
Shopping Cart
Save. Yew and Share...
Item
Need Help?
800.808.4239
Servers ' Account
Software Cloud
Microsoft Windows Server 2012 R2 Standard - license
MFG Part#: P73.006309
COW Pac#: 3'78091
JNSPSC'. 4,8233004
INJPA 100614#CDW Technology:, : $622 83
Ships today it ordered within
Quick Links
Cart (3) - $1,868.49
Mahe larch o9!iune V
All Product Catalog 7 i Search for...
lql
Product Finders
Brands
Best Deals
dd Item to Cart: Enter CDW# or MFG#
Quantity Availability Unit Price Item Total
3 n Stock
UPd te
$622.83
$1.868.49 Remove
Continue Shopping
Customers Who Viewed These Items Also Viewed (12)
Microsoft Windows Server
2012 R2 Standard - license
Lowest Online Price
$830.76
NJPA 100614#CDW Technology..
•wara20tc ns-2a
Microsoft Windows Server Microsoft Windows Server
I 2012 R2 Standard - license 2012 - license
Lowest Donne Price
$207.92
NJPA 100614#CDW Technology
Lowest Online Price
$27.40
NJPA 100614#CDW Technology
Subtotal: $1,868.49
Tax and snipping WI! be calcu"sated in checkout.
I.e ase Option($58.30 /month)
Microsoft Windows Server
2012 - license
Lowest Online Price
$32.13
NJPA 100614#CDW Technology._
https://www.cdwg.com/shop/cart/default.aspx
4/1 6/201 5
City Clerk Use Only
Finance Committee
Approval Date 4/271 f5
City of Waterloo
Expenditure Pre -Authorization Request Form
The Finance Committee of the City Council is hereby requested to authorize the following
purchase or expenditure submitted by the Street Department to expend
$ 4,544.55 plus est. shipping costs of $ 175.00 to pay for or purchase
Sweeper repair parts - 008
This purchase or expenditure is being made because:
Repair parts for completion of "D" service
Vendor selected for this purchase: Trans -IA Equipment
❑ Bids or written quotes were taken on this purchase, as follows:
❑X Bids or quotes were not taken on this purchase because:
OEM Only
Prior Committee Actions (Dates):
Please check the following box(es) as appropriate to describe the funding for this expense:
❑X General Fund
n Bonds
Road Use Tax n Sewer n Sanitation
Federal/other grants ❑X Other (specify) Storm Water
This expenditure is to be coded to the following budget line -item:
010-18-7955-1571
(Fund - Department - Activity - Account Number)
in which the budgeted amount is
and the current available balance is
Respectfully submitted,
t7%
(Project Code)
$ '2O0;9OO90 s,5 7,)oo
�75
$ ea,�a Z
K:\shared goodies\forms\Street Department - 008 Sweeper parts.xls (Mar 2010)
Budget Amendment Descriptions for 4/27/2015 Finance Committee Meeting Agenda:
1. Approve the project budget for the Cedar Trails Partnership bike maintenance station project
funded with a donation in the amount of $1,350 as submitted by the Cultural & Arts
department.
2. Approve the project budget for the Mobilizing to End Mass Incarceration — An Action
Conference, funded with HUD Fair Housing Partnership funds in the amount of $2,000 as
submitted by the Human Rights Department.
3. Approve the budget amendment for the Alcohol, Tobacco and Firearms Task Force in the
amount of $8,000, funded with federal reimbursements, as submitted by the Police department.
4. Approve the budget amendment for the Young Arena Improvements to use MidAmerican
Energy rebates revenue for improvements in the amount of $13,736 as submitted by Leisure
Services.
5. Approve the budget amendment to increase liability insurance claims paid funded with fund
balance restricted health insurance in the amount of $120,000 as submitted by Clerk/Finance.
6. Approve the budget amendment to increase other professional services for human resources in
the amount of $35,000 as submitted by Clerk/Finance.
7. Approve the budget amendment to increase the advertising budget for Cultural & Arts funded
with hotel/motel tax revenue awarded in the prior year in the amount of $2,579.09 as
submitted by the Cultural & Arts Department.
8 j Approve the budget amendments to increase miscellaneous revenue in the Central Garage
activity to budget for a refund received and use the funds for parts in the amount of $29,000
and to increase damage claims revenue in the Street Department activity to budget for damage
b'
r�nh claim revenue received and use the funds for building maintenance in the amount of $2,083 as
A'•
submitted by the Central Garage.
Please use this for project budget descriptions on Finance agenda. Do not need to include this cover
sheet in the Finance Committee packet.
Budget Amendment Descriptions for 4/27/2015 Finance Committee Meeting Agenda:
1. Approve the project budget for the Cedar Trails Partnership bike maintenance station project
funded with a donation in the amount of $1,350 as submitted by the Cultural & Arts
department.
2. Approve the project budget for the Mobilizing to End Mass Incarceration — An Action
Conference, funded with HUD Fair Housing Partnership funds in the amount of $2,000 as
submitted by the Human Rights Department.
3. Approve the budget amendment for the Alcohol, Tobacco and Firearms Task Force in the
amount of $8,000, funded with federal reimbursements, as submitted by the Police department.
4. Approve the budget amendment for the Young Arena Improvements to use MidAmerican
Energy rebates revenue for improvements in the amount of $13,736 as submitted by Leisure
Services.
5. Approve the budget amendment to increase liability insurance claims paid funded with fund
balance restricted health insurance in the amount of $120,000 as submitted by Clerk/Finance.
6. Approve the budget amendment to increase other professional services for human resources in
the amount of $35,000 as submitted by Clerk/Finance.
7. Approve the budget amendment to increase the advertising budget for Cultural & Arts funded
with hotel/motel tax revenue awarded in the prior year in the amount of $2,579.09 as
submitted by the Cultural & Arts Department.
Please use this for project budget descriptions on Finance agenda. Do not need to include this cover
sheet in the Finance Committee packet.
Project Name
City Contract No.
Project Manager
Project Budget Total
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
CEDAR TRAILS PARTNERSHIP AWARD (�,�
KENT SHANKLE
$ 1,350.00
1. How will this project be funded?
A. Federal Grant Yes 0 No
Grant Name
CFDA #
B. State Grant Yes
Grant Name
No
C. City Match Source of Funding
D. Other Entities Yes
Name
No
% Paid by federal grant
Grant Agreement Number
% Paid by state grant
Grant Agreement Number
% Paid by City
% Paid by other entity
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
r
3. Does the project include the purchase of right of way or other real property?
If yes, will real property purchases be reimbursable under the grant?
If yes, have you attached authorization to purchase real property to this document?
4. Will this project include any non -participating expenses, such as:
A. Stormwater permit fees
B. Publication, or printing costs
C. Others, list
5. Does this project cover any regular full-time salaries or benefits?
If yes, employee/position to be covered.
6. Include a brief description of the project in the space below: (REQUIRED)
Done None
❑X ❑
Yes No
❑ 0
❑ ❑X
❑ ❑X
❑ ❑X
❑ ❑X
0 El
INSTALL A BIKE MAINTENANCE STATION ALONG THE WCA RIVERWALK COURT
ALSO A BIKE RACK AND DIRECTIONAL SIGNAGE TO THE WCA AND ARTHOUSE CAFE
SEE COPY ATTACHED
Page 2 must be attached and signed.
K:\shared goodies\forms\Project Budget-FY2015-26GFT.Trails Award 4-16-151Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval Date
Project Name (from page one) CEDAR TRAILS PARTNERSHIP AWARD
Department No. project will be budgeted under 26
Activity No. project will be budgeted under 4265
REVENUES:
3000 Cash on Hand
3350 Federal Grant
3352 Federal HUD Grant
3354 Shared Program - Local
3357 Shared Program - County
3358 Shared Program - City
3360 Shared Program - State
3361 State Grant
3720 Donations - Restricted
3750 Sale of Bonds
EXPENDITURES:
�y(Each column should only include amounts by fund)
Fund: Vl U Fund: Fund:
Fund:
Total
1,350.00 1,350.00
TOTALS $ 1,350.00 $ $ - $ $ 1,350.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
Bet l-Serviees 1,350.00
� 5�5 kt (C i -P
4.Stipt; es
TO ALS $ 1,350.00 $ $ - $ $ 1,350.00
1
1,350.00
}-t0�
It to/ I S-
( ignature Dept. Head) Date
(Signature Finance Dept. Review)
s�(7 5--
Date
K:\shared goodies\forms\Project Budget Worksheet\Page 2 (Donat or NON-constr) (Mar 2010)
PROJECT BUDGET WORKSHEET - ALL PROJECTS
PAGE ONE
Project Name
City Contract No.
Project Manager
Mobilizing To End Mass Incarceration
Abraham Funchess
Project Budget Total $ 2,000.00
1. How will this project be funded?
A. Federal Grant Yes X No
Grant Name HUD Partnership grant
B. State Grant Yes 1 1 No
Grant Name
CFDA #
C. City Match Source of Funding
D. Other Entities Yes 0 No C
Name
% Paid by federal grant 100.00%
Grant Agreement Number
% Paid by state grant
Grant Agreement Number
% Paid by City
Paid by other entity
2. Attach copies of any grant agreements that will fund the project (REQUIRED)
3. Does the project include the purchase of right of way or other real property?
If yes, will real property purchases be reimbursable under the grant?
If yes, have you attached authorization to purchase real property to this document?
4. Will this project include any non -participating expenses, such as:
A. Stormwater permit fees
B. Publication, or printing costs
C. Others, list
5. Does this project cover any regular full-time salaries or benefits?
If yes, employee/position to be covered.
Done None
El El
Yes No
6. Include a brief description of the project in the space below: (REQUIRED)
Mobilizing To End Mass Incarceration: An Action Conference - David Liners is the Executive Director of WISDOM, a
Wisconsin netweork of faith based organizations, part of the International Gamaliel Foundation. Under his leadership, the
statewide network has grown from three to eleven diverse, interfaith organizaitons in Wisconsin. He helps develop new
models and strategies for a variety of projects. He holds a BA from Marquette from Marquette University, a Masters of
Divinity from the Catholic Theological Union in Chicago, and a Doctor of Ministry from St. Mary of the Lake University.
He lives in Milwaukee, Wisconsin.
Page 2 must be attached and signed.
K:\shared goodies\forms\Project Budget Worksheet Mass Incarceration.xls\Page 1 All Projects (Mar 2010)
PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION
PAGE TWO
City Clerk Use Only
Finance Committee
Approval Date
Project Name (from page one) Mobilizing To End Mass Incarceration
Department No. project will be budgeted under 010-27
Activity No. project will be budgeted under 2510
REVENUES:
3000 Cash on Hand
3350 Federal Grant
3352 Federal HUD Grant
3354 Shared Program - Local
3357 Shared Program - County
3358 Shared Program - City
3360 Shared Program - State
3361 State Grant
3720 Donations - Restricted
3750 Sale of Bonds
EXPENDITURES:
(Each column should only include amounts by fund)
Fund: 1303 Fund: Fund: Fund:
2,000.00
Total
2,000.00
TOTALS $ 2,000.00 $ - $ $ $ 2,000.00
1111 Salaries - Regular
1112 Salaries - Part Time
1315 Education & Training
1345 Travel - Official City
1346 Travel - Prof Training
1390 Contractual Services
1303 Meetings/Workshops
2,000.00
2,000.00
TOTALS 2,000.00 $ $ $ $ 2,000.00
(Si. - ature Dept. Head)
120 tc Afibe 7 Lvt.42 zi
Date (Signature Finance Dept. Review) Date
K:\shared goodies\forms\Project Budget Worksheet Mass Incarceration.xls\Page 2 (Donat or NON-constr) (Mar 2010)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
Financ 'Co ittee approval required?
YES NO
If so, date approved:
City of Waterloo
Line -Item Budget Amendment Request Form
The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget
amendment for FYE 15 submitted by the POLICE Department:
EXPENSES/REVENUE
DECREASE EXPENDITURES (INCREASE REVENUE)
INCREASE EXPENDITURES (DECREASE REVENUE)
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
010 11 1150 3873
ATFT
11 GRT ATFT
8,000.00
010 11 1150 1114
Overtime
11 GRT ATFT
8,000.00
TOTAL
This amendment is being requested because:
To conform with the City's budget line item control policy.
$8,000.00
TOTAL
$8,000.00
Wad / Y vices
.till 14 A>cilwe 77)/ .� �L �� �d�� r te_Q
-ibis 'Veil- Alfa' /at 61451e0 Pfa&y l "r /
Prior Committee Actions (Dates):
(Si ature De
\VdN4at171\ rTh
t. Head or De igriee�
1
y'oi
D e
.11,e( L.1), 174 /f-4
(Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K:lusers\shared goodies\formstcsbudgetamendregform (Apr 2003)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
Fina C mittee approval required?
YES NO
If so, date approved:
City of Waterloo
Line -Item Budget Amendment Request Form
The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget
amendment for FYE 2015 submitted by the Leisure Services Department:
EXPENSES/REVENUE
DECREASE EXPENDITURES (INCREASE REVENUE)
INCREASE EXPENDITURES (DECREASE REVENUE)
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount .
YGnd Dept Activity Acct #
Acct Name
Proj Code
Amount
010
37
4105 372�_Reatr
YAMI
9,060.00i/9'10
37
4105
Restreited $BTi'
YAMI
9,060.00
ed Dun.
010
37
4105 372A
YAMI
4,676.00t/010
37
4105
4.7.6
.�esheited-flop.
YAMI
4,676.00
ri`-
1 N a,
6 1(q'DNA'
TOTAL
$13,736.00
TOTAL
$13,736.00
This amendment is being requested because:
for yountablity purposes these Mid -American Energy rebates needed to be added into the FY 2015 cwg{puebudget 5i /t C _ fYIQV
C-11 n p ,GY.cI bd
Cl' corirrl ryrv=rya- .
Prior Committee Actions (Dates):
(
(Signature D-pte : or Designee) Date (Signature Finance Dept. Review)
Date
Date Posted (Finance Dept.)
K:Wsersishared goodiesVormseBudget Amendment Request Form (Apr 2003)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
Finance CC nmittee approval required?
YES 'f NO
If so, date approved:
City of Waterloo
Line -Item Budget Amendment Request Form
The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget
amendment for FYE 2015 submitted by the City Clerk's Department:
EXPENSES/REVENUE
DECREASE EXPENDITURES (INCREASE REVENUE)
INCREASE EXPENDITURES (DECREASE REVENUE)
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
010-03-3000
Cash
120,000.00
010-03-8905-1359
Liab. Claims
120,000.00
TOTAL
$120,000.00
This amendment is being requested because' I p
Restricted fund balance — L+ Q �� l ,1!f J C Ca-(wl�
TOTAL
$120,000.00
Prior Committee Actions (Dates):
(Si. nature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K:\users\shared goodies \forms\Budget Amendment Request Form.xls (Apr 2003)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
Finance C mittee approval required?
YES 1 NO
If so. date approved:
City of Waterloo
Line -Item Budget Amendment Request Form
The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget
amendment for FYE 2015 submitted by the Human Resources Department:
EXPENSES/REVENUE
DECREASE EXPENDITURES (INCREASE REVENUE)
INCREASE EXPENDITURES (DECREASE REVENUE)
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
010-03-3000
Cash
35,000.00
010-03-8250-1319
Other Prof. Srvcs
35,000.00
TOTAL
$35,000.00
TOTAL
This amendment is being requested because:
Due to ongoing lititgation the attorney fees are causing an overbalance so I am requesting to use fund balance.
$35,000.00
Prior Committee Actions (Dates):
C>iC
(Si. ature Dept. Head or Designee)
Date (Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K1users\shared goodieslformslBudget Amendment Request Form.xls (Apr 2003)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
Finan C mittee approval required?
YES NO
If so, date approved:
City of Waterloo
Line -Item Budget Amendment Request Form
The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget
amendment for FYE FY2015 submitted by the WCA-PYP Department:
EXPENSES/REVENUE
DECREASE EXPENDITURES (INCREASE REVENUE)
INCREASE EXPENDITURES (DECREASE REVENUE)
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount ✓
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
010-26-4265-1 HOTEL -MOTEL FY2014
2,579.09
010-26-4265-1351
Advertising
2,579.09
3000
C(7a-51`) 26HMT.ADVFY14
26HMT.ADVFY14
TOTAL
$2,579.09
This amendment is being requested because:
INCREASING ADVERTISING BUDGET WITH THE FY2014 HMT.ADVFY14 CARRYOVER BALANCE.
TOTAL
$2,579.09
Prior Committee Actions (Dates):
E S�
(Signature Dept. Head or Designee)
/26l)J.�J M
Date (Signature Finance Dept. Review) Date
Date Posted (Finance Dept.)
K:\users\shared goodies \forms \FY2015-Amendmnt-Grants 4-20-15 (Apr 2003)
Completed forms should be routed directly to the Finance Dept.
FINANCE DEPT. ONLY
FinanceCommittee approval required?
YES J NO
If so, date approved:
City of Waterloo
Line -Item Budget Amendment Request Form
The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget
amendment for FYE 2015 submitted by the Public Works Department:
EXPENSES/REVENUE
DECREASE EXPENDITURES (INCREASE REVENUE)
INCREASE EXPENDITURES (DECREASE REVENUE)
Fund Dept Activity Acct #
Acct Name
Proj Code
Amount
lund Dept Activity Acct #
Acct Name
Proj Code
Amount
010
18 7950 3800
iscellaneous Reveni
29,000.00
010 18 1405 1569
Vehicle Repl Parts
29,000.00
266
19 7100 3871
Damage Claims
a0 �99419.
266 19 7100 1371
Building Maintenancf
O,rw3'
47Beg-ge
TOTAL
This amendment is being requested because:
Transfer to cover fire equipment repair expenses.
$30,800.00
Transfer to cover anticipated building maintenance expenses.
TOTAL
$30,800.00
Prior Committee Actions (Dates):
(Signature Dept. ad or Designee)
Date
A4.4 GJ�(--4.42,a/1-
(Signature Finance Dept. Review)
2,7
Date
Date Posted (Finance Dept.)
K:\users\shared goodies\forms\Line Item Amendment - 2015 - Public Works Budget Amendment - Apr 2015.xls (Apr 2003)