HomeMy WebLinkAboutLease Amendment - Hewlett Packard - Amend the Quantity and Price of Schedule 13 of Master Computer Lease1316 COUNTY -CITY BUILDING
227 W. JEFFERSON BOULEVARD
SOUTH BEND. INDIANA 46601-1830
CITY OF SOUTH BEND PETE BUTTIGIEG, MAYOR
BOARD OF PUBLIC WORKS
March 14, 2017
Marc Lozandier
Hewlett-Packard Financial Services Company
200 Connell Drive, Suite 5000
Berkeley Heights, NJ 07922
RE: Lease Amendment
Dear Mr. Lozandier:
PHONE 574/235.9251
FAX 574/ 235-9171
The Board of Public Works, at its meeting held on March 14, 2017, approved the above
referenced agreement to amend the quantity and price of Schedule 13 of the Master
computer lease for an increase of $1,678.70, and a new total of $156,029.30
Enclosed please find a copy of the agreement for your records.
If you have any further questions regarding this matter, please call this office at (574) 235-
9251.
Sincerely,
Linda M. M`arti�n, Clerk
Enclosure
c: Sue Gerlach, IT
GARY A. GILGT SUZANNA M. FRITZBERG ELIZABETH A. MARADIK JAMEs A. MUELLER THERESE J. DoRAu
imm�"
Hewlett Packard
Enterprise
October 04, 2016
City of South Bend, Indiana
227 W Jefferson Suite 1200
South Bend, IN 46601
Subject: Lease Schedule Number 624608822900013 ("Schedule")
Dear Sir/ Madam:
Thank you for doing business with Hewlett-Packard Financial Services Company.
Please be advised that we have received final invoices from the Supplier under the
above referenced Schedule. This is to confirm the total cost increased from
$154,350.60 to $156,029.30. Thus, the payment increase from $3,311.78 to $3,348.47.
The New payment for the lease is $3,348.47
All terms used herein and not defined shall have the meanings set forth in the
Agreement. All other terms and conditions of the Agreement remain unchanged and in
full force and effect.
If you should have any questions or require additional information, please feel free to
contact me at (908) 898-4777.
Sincerely,
Marc Lozandier
?? 4W Z"W(&A
Customer Delivery Specialist
Hewlett-Packard Financial Services Company
LESSEE: City of South Bend, Indiana
By: X
(Date):
(Lessee Aufhonzea SlgnnNre) 4 MOVED
Heard of Puklic Works
ITvno/Prinf Nxmnl �.
Sch 13 TVAL.xlsx
Page 1 of 2
AMORTIZATION SCHEDULE - Normal Amortization
Date
Payment
Interest
Principal
Balance
Loan
11/1/2016
156,029.30
1
11/30/2016
3,348.47
605.97
2,742.50
153,286.80
2
12/31/2016
3,348.47
624.40
2,724.07
150,562.73
3
1/31/2017
3,348.47
613.31
2,735.16
147,827.57
4
2/28/2017
3,348.47
602.17
2,746.30
145,081.27
5
3/31/2017
3,348.47
590.98
2,757.49
142,323.78
6
4/30/2017
3,348.47
579.75
2,768.72
139,555.06
7
5/31/2017
3,348.47
568.47
2,780.00
136,775.06
8
6/30/2017
3,348.47
557.14
2,791.33
133,983.73
9
7/31/2017
3,348.47
545.77
2,802.70
131,181.03
10
8/31/2017
3,348.47
534.36
2,814.11
128,366.92
11
9/30/2017
3,348.47
522.89
2,825.58
125,541.34
12
10/31/2017
3,348.47
511.38
2,837.09
122,704.25
1311/30/2017
3,348.47
499.83
2,848.64
119,855.61
1412/31/2017
3,348.47
488.22
2,860.25
116,995.36
15
1/31/2018
3,348.47
476.57
2,871.90
114,123.46
16
2/28/2018
3,348.47
464.87
2,883.60
111,239.86
17
3/31/2018
3,348.47
453.13
2,895.34
108,344.52
18
4/30/2018
3,348.47
441.33
2,907.14
105,437.38
19
5/31/2018
3,348.47
429.49
2,918.98
102,518.40
20
6/30/2018
3,348.47
417.60
2,930.87
99,587.53
21
7/31/2018
3,348.47
405.66
2,942.81
96,644.72
22
8/31/2018
3,348.47
393.68
2,954.79
93,689.93
23
9/30/2018
3,348.47
381.64
2,966.83
90,723.10
2410/31/2018
3,348.47
369.55
2,978.92
87,744.18
25
11/30/2018
3,348.47
357.42
2,991.05
84,753.13
2612/31/2018
3,348.47
345.24
3,003.23
81,749.90
27
1/31/2019
3,348.47
333.00
3,015.47
78,734.43
28
2/28/2019
3,348.47
320.72
3,027.75
75,706.68
29
3/31/2019
3,348.47
308.39
3,040.08
72,666.60
30
4/30/2019
3,348.47
296.00
3,052.47
69,614.13
31
5/31/2019
3,348.47
283.57
3,064.90
66,549.23
32
6/30/2019
3,348.47
271.08
3,077.39
63,471.84
33
7/31/2019
3,348.47
258.55
3,089.92
60,381.92
34
8/31/2019
3,348.47
245.96
3,102.51
57,279.41
35
9/30/2019
3,348.47
233.32
3,115.15
54,164.26
3610/31/2019
3,348.47
220.63
3,127.84
51,036.42
3711/30/2019
3,348.47
207.89
3,140.58
47,895.84
38
12/31/2019
3,348.47
195.10
3,153.37
44,742.47
39
1/31/2020
3,348.47
182.26
3,166.21
41,576.26
40
2/29/2020
3,348.47
169.36
3,179.11
38,397.15
41
3/31/2020
3,348.47
156.41
3,192.06
35,205.09
https://usl-excel.officeappslive.com/x/ layouts/xlprintview.aspx?&NoAuth=1&sessionld=... 3/2/2017
Sch 13 TVAL.xlsx
Page 2 of 2
43
5%31%2020
3;348.47
130.35
3 218.12
28,7781.91
44
6/30/2020
3,348.47
117.24
3,231.23
25,550.68
45
7/31/2020
3,348.47
104.08
3,244.39
22,306.29
46
8/31/2020
3,348.47
90.86
3,257.61
19,048.68
47
9/30/2020
3,348.47
77.59
3,270.88
15,777.80
4810/31/2020
3,348.47
64.27
3,284.20
12,493.60
4911/30/2020
12,544.52
50.92
12,493.60
0.00
Grand Totals 173,271.08 17,241.78 156,029.30
https://us 1-excel.officeapps.live. com/x/_layouts/xlprintview. aspx?&NoAuth=1 &sessionld=... 3/2/2017
INTER -OFFICE MEMORANDUM
Information Technologies Department
227 W Jefferson Blvd (574) 245-6000
TO: The Board of Public Works
FROM: Information Technologies Department
SUBJECT: Change to HP Master Lease #5245088229 Schedule 13
DATE: 312/17
Members of the Board -
For your approval are changes in quantity and price which increases the cost of
Schedule 13 from $154,350.60 to $156,029.30. This increases the monthly cost
of the lease from $3,311.78 to $3,348.47 resulting in a monthly increase of
$36.68 and total increase of $1,678.70.
Thank you for your consideration.
Sue Gerlach
Cc: John Murphy
Amy O'Connor
George King
Michael Schmidt
Date
Name
BOARD OF PUBLIC WORKS
AGENDA ITEM REVIEW REQUEST FORM
3/2/17
Gerlach
Department IT
BPW Date 3/16/17 Phone Extension 6209
Required Prior to Submittal to Board
Legal ® Attorney Name Michael Schmidt
Controller ® Controller review is required for all Contracts $5,000.00 or more and
greater than one year in length per the City Purchasing Policy
Purchasing
H Agreement ❑ Contract ❑ Proposal ❑ Addendum
❑ Professional Services ❑ Resolution
❑ Bid Opening ❑ Bid Award ❑ Req. to Advertise ❑ Title Sheet
❑ Quote Opening ❑ Quote Award
❑ Change Order No. ❑ C/O & PCA No. ❑ PCA
❑ Ease/Encroach. ❑ Traffic Control
M Other: Final cost chanae
Company or Vendor Name Hewlett-Packard
New Vendor ❑ Yes ® No
MBE/1NBE Contractor ❑ MBE ❑ WBE
it Yes, Approved by Purchasing
MBE/INBE Contractor Requested ❑ No ❑ Yes Name of Company
Project Name HP Schedule 13
Project Number
Funding Source
Account No.
Amount
Terms of Contract
Purpose/Description
N/A
IT Lease
279-0672-415-37-11 /12
$ 1678.70
48 Months
Changes in quantity and price
❑ Required Contractor's Certification Form Attached (Non -
Collusion, Non -Discrimination, Non -Debarment, E-Verifv. Iran. etc
Amount of U Increase
❑ Decrease
Previous Amount
Current Percent of Change:
New Amount
Total Percent of Change:
Copy
Original
®
❑
Sue Gerlach
Dispersal After Approval