Loading...
HomeMy WebLinkAbout320386 01/05/2018 '-L4q CITY OF CARMEL, INDIANA VENDOR: 371726 y �b ONE CIVIC SQUARE REGIONS EQUIPMENT FINANCE CHECK AMOUNT: $****27,719.96* CARMEL, INDIANA 46032 PO BOX 2545 CHECK NUMBER: '320386 9yiroN-`0,r BIRMINGHAM AL 35202-2545 CHECK DATE: 01/05/18 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION. 1115 4463201 820257 12,907.70 HARDWARE 1115 4463201 821355 12,453.00 HARDWARE 1115 4465001 821356 2,359.26 CARS & TRUCKS Prescribed by State Board of Accounts City Form No.201 (Rev.1995) VOUCHER NO. WARRANT NO. ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor# -361485 "3 '7[ REGIONS 5��VP Jf1 IN SUM oI $ CITY OF CARMEL An invoice or bill to be properly itemized must show:kind of service,where performed,dates service rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INinlA LAR_o r�� Payee $27,719.96 Purchase Order# ON ACCOUNT OF'APPROPRIATION FOR ICS Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION. DEPT# INVOICE# Fund# AMOUNT .. .. Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 820257 44-63201 $12,907.70 1 hereby certify that the attached invoice(s),or 12/1/17 820257 $12,907.70 1115 101 Prior Year 1115 101 821356 44-650.01 $2,359.26 bill(s)is(are)true and correct and that the 12/10/17 821356 $2,359.26 1115 101 1 Prior Year materials or services itemized thereon for 1115 1 101 821355 I 44-632.01 I $12,453.00 12/10/17 I 821355 I I $12,453.00 1115 101 Prior Year which charge is made were ordered and 1115 101 received except :Thursday, December.21,2017 Renick,Timothy Director I hereby certify that the attached invoice(s),or bill(s), is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 -- 120- Cost 20Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer it j� �T I A . U I O S REGIONS EQUIPMENT FINANCE P.O.;Box 2545 BIRMINGHAM;AL 35202-2545 Page Number 1.of .2 Invoice Date - 12/10%2017 Invoice Number 821356 0000225 01 SR `0.460 001 Invoice Due Date 01/15/2018 Attn: - LINDA HARVEY Total Current Due 91,204.83 ,CITY OF CARMEL INDIANA Total Amt 91,204.83 ONE CIVIC SOUAAE Total Tax 0.00 CARMEL IN '46032-2584 Total Late Charges 0;00: Total Amount Due 91,204.83 051-001.3163--005 Invoice Description: ONE 1 FORD EXPLORER, MOBILE DATA COMPUTERS.WITH_MOUNTS FOR TH POLICE DEPARTMENT, EMERGENCY OPERAT Purchase Order:, Termination Date: 02/15/2022 .Contract Activit Froin Date To.Date #.of Days. Int Rate:: Int Accrual Int Pymt Payment ;P.rin Bal Accrual Type :05/15/2017. 05/31`/2017 17 2.14 875.33 0.00_ 0.00 866,187.04 Monthend 05/31/2017: 06/30/2017 30 12.14 1',544.70- 0.00 0.00 866,187.04 Monthend 06/30/2017 07/15/2011 14 2.-14 720.86 - -3,707.28 -87,497.55 778,689.49 Payment 07/15/2017 07/15/2017 . 0 2.1.4 0.00 0.00 0.00 778,689:49 Invoicing 07/15/2017 -07/31'/2017 17 2.14 786.91 0.00 0.00 778,689.49 Monthend 07/31/2017 '08/31/2017 31. 2.1.4 1,434.95 0.00 . 0.0.0 778;689:49 Monthend 08/31/2017 09/30/2017 30 2.14 1,388.66 0.00 0.00. 778,689.49 Monthend 09[30/2017 10/31/2017 31 2.14 1,434.95 0.00 0.00 . 778,689.49 Monthend, 10/31/2017 11/30/2017 . 30 2.14. 1388.66 . .0.00 0,00 778,689.49 Monthend 11130/2017 12/31%20.17. 31: 214:.. 1;434.95 0.00 0.00 :: 770,689.49 Monthend 12/3112017 01/15/2018 14 2:14 648.04 0.00 0.00 778,689.49 : In Current:Char es Desc Due Date -. Amount Due Tax Late Charge ' Total Due rincipa- Fixe. Pymt : 01/15/2019 82,687.65 82, ..65 Interest 01/i 5/2018 8,517.18 17.18: ��5 AM& E G"I1`V S . REGIONS EQUIPMENT FINANCE P.O.BOX 2545 , BIRMINGHAM,AL 35202-2545 Page Number '1 of 2 . . ...I. . .I. I !III ..L. II Invoice Date 12/10/2017.. II�_III�.II I I IIII I IIIII III. I I I I. I III II 1 Invoice Number 821355 1:000 1 2601 SP •0:460001-_. Invoice Due'Date 01/15/2018 Attn LINDA HARVEY Total Current Due 1;22,058.19 CITY OF .CARMEL- INDIANA;_ Total Amt 122,058.19.' ONE CIVIC SQUARE Total Tax 0;00 CARMEL IN 46032.=2584 Total Late Charges 0.00 -Total Amount Due 122,058.19 051-0.013163-004 Evoke D scription.FORD F-250 A SECURITY'AV EQUIPMENT; HANDICAP LIFT, NUTAN Purchase Order: Termination Date; 91/16/2022 Contract=Activit From bate 'To Date #:of.Days: -_ Int-Rate Int Accrual Int Pynit Pa ment Prin Bal AccrualType 05/31/2011 06/30/2017 30 2:14 2,056.18 0.00 0.00 1,153,000.00 Monthend . 06/30/2017 07/15/2017- .14 2:1.4 959.55 40;143:83 111,914.36 1,041,085.64 Payment. -07/15/2017 '0711.5/2017 0 2.14 0:00 0.00 0.00 1,041;085.64 -Invoicing- 07/1501_7 Invoicin 07/15/2017 07/31/2017 17 2;14 1,052.07 0.00.. 0.00 1,041,085.64 Monthend - 07/31/2017 08/31/2017 : : 3-1 2.14: 1;91:8:49 0:00.. 0.00 1,041;085.64 : . Monthend 08/31/2017 09/30/2017 30: 2:14 1;856.60 OA0 0:00- 1,041,,085.64 Monthend 09130/201.7 . 10/3112017. 31 2:14 1:918.49:. 0.00 0.00 : 1,041,085.64 Monthend 10/31/201.7 11/30/2017. 30 2:14 1,856:60 0.00 0.00 : :1;041,085.64 Monthend: 11/30/2017 12/31/2017 31 2.14 1,918:49 :0.00 0.00 190411085.64 Monthend 12/31/2017 01/15/2018 14 2.14. 866:41 9.90 0.00 1,041,085.64. Invoicing Current Char es _ . Desc Due Date Amount Due Tax Late Charge Total Due Principal(Fixed-Pymt) 01/.15/2018 110,67.103 110 .03 Interest 0.171512018. 11 387:16 . 41;387:16 5 3. 17- Schedule 4 -information Systems Annual Annual Annual Option Payment. Principal Principal Interest 'Interest Total: ::Payment Principal Purchase Due'Date Payment Total, : ;; Payment Total Payment Total Balance Price 02/16/17 117,635.00 " 15 ,...,,.. 1M =11R Ms � p 0F 941932.76. _ 07/15/18 11,431.58 22,722:73 1,021.42- 2;183.27 12;453.00 24,906:00 83,5.01.18 01/15/19. 11,539:69.. 913:32 12,453..01: „ 71,9.61.49, 07/15/19- 11,67834 23,218:43 774.27 1,687.59 12,453.01 24,906.02 60;282.76 01/15120 11,793.65 659.36. 12,453c01 48,489_;10 07/15/20 11,928:41' 23,722.06 524:60 .1;183.96 12,453.01 24;906.02 36;560.69 01/15/21 12,053:11: 399.89 12,453.00" 24,507.58 07/15/21 121189:32 24,242.43 263.69 663.58 12;453.01 24,906.01 12,318.26 01/15/22 121:31827 12,,318':27 134.73. 134.73 . 12,453.00. 12,453.00' .. Totals $ 117,635:00 $ 6,895.05 $ 124,530.05 .. Lease Schedule,#4 Information Systems Description:: IS,Hardware Security Camera:DVRs-3 fi y I €# !< t I i �1..5 REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202.2545 Page Number 1 of 2 I. rr r II. I I III I I Il��lr Invoice Date 12/01/2017 Invoice Number 820257 t ; Invoice Due Date 01/15/2018 0000s2 of SP o.4so oot Attn: LINDA HARVEY Total Current Due 12,907.70 CITYOF CARMELINDIANA Total Amt 12,907.70 CITY , ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 12,907.70 c 051-0013163-001 Invoice Description: MIRAZON AND MATRIX HARDWARE Purchase Order: Termination Date: 02/15/2021 Contract Activit From Date To Date #of Days Int Rate Int Accrual Int Pymt Payment Prin Bal Accrual Type 04/30/2017 05/31/2017 31 1.65 141.31 0.00 0.00 99,458.99 Monthend 05/31/2017 06/30/2017 30 1.65 136.76 0.00 0.00 99,458.99 Monthend 06/30/2017 07/15/2017 14 1.65 63.82 -838.78 -12,068.92 87,390.07 Payment 07/15/2017 07/15/2017 0 1.65 0.00 0.00 0.00 87,390.07 Invoicing 07/15/2017 07/31/2017 17 1.65 68.09 0.00 0.00 87,390.07 Monthend 07/31/2017 08/31/2017 31 1.65 124.17 0.00 0.00 87,390.07 Monthend 08/31/2017 09/30/2017 30 1.65 120.16 0.00 0.00 87,390.07 Monthend 09/30/2017 10/31/2017 31 1.65 124.17 0.00 0.00 87,390.07 Monthend 10/31/2017 11/30/2017 30 1.65 120.16 0.00 0.00 87,390.07 Monthend 11/30/2017 12/31/2017 31 1.65 124.17 0.00 0.00 87;390.07 Monthend 12/31/2017 01/15/2018 14 1.65 56.08 0.00 0.00 87,390.07 Invoicing Current Char es Desc Due Date Amount Due Tax Late Charge Total Due Principal(Fixed Pymt) 01/15/2018 12,170.62 12,170.62 Interest 01/15/2018 737.08 737.08 i REGIONS Please Detach and Return with Payment EQUIPMENT FINANCE CORPORATION Equipment Finance Payment A/R Name CITY OF CARMEL, INDIANA Contract Number 051-0013163-001 REGIONS CAPITAL ADVANTAGE, INC WIRE INSTRUCTIONS Invoice Due Date 01/15/2018 ABA#062000019 Invoice Number 820257 ACCOUNT#0107024142 Total Amount Due 12,907.70 RE ION BAN I�I I III I II III I� II��II I� II Amount Enclosed `)D`7.70 Schedule 5 -Information Systems Annual Annual Annual Option Payment Principal Principa[ Interest 7interesi Total „Payment 'Principal Purchase Due Date Payment Total. Payment Total Payment Total Balance Price 02/16/17 22,406.28. _ 21680 .:-: �. 2159'26T 17,998.93 07/15/18 2,168.68 4,311:14 190.58 407.38 2;359.26: 4;718.52 15,830:25 01/15/19. 2,188.86. 170:40: 2,359:27 13,641.39 07/15/19 2`,214.82 4,403.68 144.44 814.84 2,359.26 4,718.53 11;426.58. 01/15/20 2,236.26 123.00 2;359.26 9,19031 07/15/20 2,261.41 4,497.67 97.85 220.85 21359.26 4,718.52 6,928.90 01/15/21 2,284.68 74:58, 2,359.26. 4,644.22 07/15/21 2,310.09 4,59437 '49.18 123.76- .2,359.27 4,718.53' 2,334.13 01/15/22 2,334:14 2,334:14•. 25.12 25:12: 2;359.26 2,359.26; - Totals $ 22,406.28 $ 1,186.33 $. :.23,592.61: Lease Schedule.#5-Information Systems Description: Ford Explorer A. :.. ..