The URL can be used to link to this page

Home My WebLink AboutAgenda Report - July 16, 1997 (46)wCITY OF LODI COUNCIL COMMUNICATION AGENDA TITLE: Lease / Purchase an AS/400 RISC Computer ($236,460.60) and purchase hardware and operating system software ($50,000.00) MEETING DATE: July 16, 1997 PREPARED BY: Finance Director RECOMMENDED ACTION: City Council authorize a five year Lease/Purchase with IBM for an AS/400 RISC Computer (Reduced Instruction Set Computer) and purchase of hardware and operating system software. BACKGROUND INFORMATION: All of the existing AS/400 based "mission critical" application software must be repaired or replaced prior to the year 2000 in order to avoid system failures. Staff has been given the direction to start the process of evaluating General Accounting and Payroll/human Resources Software. The Utility Billing system is tentatively put on hold pending the completion of the NCPA/SCPPA study to be completed by R. W. Beck. This is in concurrence with the final recommendations made by the group of Lodi representatives who traveled to Oregon to review Customer Information Systems (see attached). New software will occupy considerably greater disk space and computer memory, and will need much more processing power to operate efficiently. Modern database oriented applications require greater resource, but deliver much greater value in terms of availability and content of information. Newer applications also provide improved functionality and accuracy of data along with a much improved user interface. In addition to meeting the Year 2000 need, we must be ready for citywide connectivity and communication and have the repository of data which the future will demand. To be successful, we must begin this process immediately. While these demands for improvement are reasonable, we must have the necessary tools to meet them. The current AS/400 is seven years old, with outdated processor design, and is not capable of handling the demand included with today's sophisticated software. It was purchased through a five year lease purchase arrangement similar to the one staff is recommending, and has proven to have been an extremely good investment for the City. In seven years the computer has never been the cause of any application failure or delay. It has been more than adequate for yesterday's needs, but the connectivity and required access to extensive collections of data necessitate improved technology. Staff is recommending proceeding with the lease purchase with IBM for an AS/400 RISC computer, and purchase of new mag tape backup, fax/modem, and the operating system software. The purchase of the hardware and operating software will save financing charges associated with those items. With the new AS/400 installed, it will be possible to move ahead with software improvements per the attached implementation schedule. FUNDING: Funding for Lease payments included in Finance Department Operating Budget. Total monthly payments of $3,941.01 beginning Sept. 1, 1997 through August 1, 2002 Funding for purchase of hardware and operating software - CIP budget ($50,000) Respectfully, Vicky McAthie Finance Director Prepared by Roy Todd, Data Processing Manager APPROVED: — ___ H. Dixon Flynn -- City Manager CITY OF LODI — ADMINISTRATLON - 1N'iBROFP10E MEMORANDUM TO: MXON FLYNN, CITY NfANAGBR FRC)M- JANF'T S. KF.ETER, Dr_.PUTY CITY MANAGER SUBJECT: F'INALC1S;`BILLING FL'C0M-.\4ENDAT10N DATE: JIJNL, 1%, 1997 The group of Lodi represcrttutives who ir:r'.•C["i to OrcS7)n t -%v.,) works agv to rcvrew Customer Tnformition Svster ns met tockv to discuss ;i final recommendation. :'resent during the meetutg were alic tvllvwiru, irtdividL dS! Vicky McAEc S%ur I Icirrrlc Alan Fallow lznet Keeter Davc Waxner Su. -vu Kirm was uruble to alt -n(I tic: mcetirrg,, however T slidpcai: with hire on the tcicphcne tol[owing rhe me.etYng to rt.cie-, the,, final recommenda6orts. Fir conc:urree with the group's d(.0 lsUXl5. RECOMMENDATIONS: 1. .Acquire an AS•1017 for Fimrrtce Dg3artrrteni now I %Cult f -)r the t4C FA.M.SC ITA str_ucfy to be completed by L'ecl: (mid -_Roust) prior to recrmirrimllrng a CfS JPillirrr S stern 3. \Vait Cor the N( -P ,"S(,PP_l ::Range of Optiom" cl ialvsi. to br completed poor to rec-ommendinp a.C[S.. Systc�rrt 4. tilt. (7[s >tuaics arc antic r<La.t , dc:vulop tilt. Rcquc•st. firr FImposals !FiFP lir the City's Certertl TA:d',j :ri,CT , anti Pa tall ,lt-cmul6r'� S+�trr;r.rc S. U;tan c.;)rnplt to iri cd the CAS stitches, Vralciate hr.xr c+F?tic.n f%tr t.1w.. City cif T odi and Make rer.+xnrrzncia.tinrI for >t.C(S,'7,iI ing Sycte•m (i. C)r;(rr Cl. :rr+a ('a..t'nl'I ri:'ccxathrig S,+{tuart itt Emir tri h.lve it !rostallyd (m the AS -100 by t7ecrnthe••. 19��, . .. Re:ra.+n iltr ser-vice.:nt Sr;tr; Fie m10 as ;a- pr-+lrer ::nor u• a.tctr rcr adrise ^.nti a;,i.; in imltlr n�nt;tti�rt srtd kf It circc Icrltrrx nt ilii —fit= -199^ 11 �� 1 cG + �b8 25 9 P. 01 ji-rr a lurrrricriLurrrcl rrc7.rrarirrrda ur_s were cot 1—de rasilc, as dxrc are rrsu.v variables to cusr:der tui t}rc CIS: Bitlirrzl CI, urd Payrull Syst=res. Factors, xidch complicate the de"siem- mi4inr` process, irrr'(cu}e the un4n+.:wns of wlr:rr will actu;itly he required by decegalatlon. In ackiitiorr, the City will ncod to dcx-ick: how tar to g., with marketing acrd c,duc-added prcxiucts and services far urilitv cwstomcrs. hlcxsc IM. rrte kriz; P It you woukt like further der it on the reac urnmendatians. Other wise, } mpecr th(7: Firunce D.^partmeilt tc) conic: hrrward to the City Courant in (illy -with a recommendation to hirer purchuc or lMsc.. purch<<e arr AS4t U. } am relierud that we have collectively come to conchrsion on tile hest crrune of ,a. io,i for mcxaing the. ,;e:rr 3JUt) chalLrargc ;u sell as bveinning the Process of rescrrching a C.IS "Bigmg, Sy: env. - - -979 P . 02 Plan 1: Software Ir. :ementation Schedule ID 1 Task Mime New RISC AS/400 & Version 3 Start Finish 997 1998 1999 T- 255o at 1 03 1 Q4 Q1 02 1p3 Q4 01 Q2 03 p4 1 Q1 ---r—Q2 —[--Q3 9124 12/4 1/29 h. ............ .......... 1. 9/28 3/12 8/1/97 10/9/97 2 Finance Network & CA/400 10/10197 11120197 3 Connect to City Hall Network 11/21/97 111/93 4 General Accounfirig Failure 10111/98 10/11/98 5 Core Financial Software 8/1/97 1116199 6 Research: GA, HR 8/1197 10/23197 7 8 1 GA: Conversion GA: Testing & Installation GA: Post Installation Support 10124/97 2/12198 2/13/98 5/7/98 S/8/98 7/2198 10 GA: Budget Repairs Install Applicant Tracking ?? 7/3/98 10/24197 9/24/98 1214/97 I I 12 Payables: Conversion PA: Testing & Installation 10/24/97 11/11/98 13 1/2/98 1129/98 14 PA. Post Installation Support 1/30198 2126198 15 Payroll: Conversion Sit 1198 8128198 16 PR: Testing SInstallation 8/31198 11/20/98 17 PR: Post Installation Support 11123/98 1/15/99 10 CIS Software 2/20/97 12/17/99 19 CIS Research 2120/97 4130/97 20 21 CIS: Conversion 9/28198 3112/99 CIS: Testing & Installation 3/15199 7/2/99 22 CIS: Post Installation Support 7/5199 10122/99 23 Business License: YR2000 12/17/99 Page 1 Plan 1: Software In cementation Schedule ID_ Task Name Start Finish 1987 1980 1999 2000 Q1 Q2 ( 03 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 02 Q3 24 25 Research Added Software Building Permits (Sierra?) 116199 1/6/99 5123/00 3/2/99 26 27 28 29 Purchasing/Inventory 3/3199 4/27/99 Receivables Cashiering Fixed Assets 4/28199 6122/99 6/23/99 8117/99 8/18/99 10/12/99 30 Miscellaneous Licenses 10/13/99 1217/99 31 Work Orders/Facility Mgmt. 12/8/99 2/1/00 32 — 33 Fleet Maintenance 2/2/00 3/28/00 Parks 3 Recreation 3/29/00 5123/00 Page 2 cirdit carporaf ion Quote 001443419-01 CITY OF LODI Rates Valid Through: July 29, 1997 INSTALLMENT PAYMENT RATES: Install Mach Mod Opt Term Month IBM SOURCED HARDWARE 3570 B01 IG 60 07/97 Financing Proposal Monthly Annualized Net Interest Interest Purchase Down Rate % Rate % Price Payment 6.50 6.70 12,121.00 0.00 7852 400 IG 60 07/97 6.50 Preferred Rate Financing 9406 510 IG 60 07/97 6.50 Preferred Rate Financing 5ikik *## S 60 07/97 6.50 Preferred Rate Financing* 6.70 525.00 0.00 6.70 201,420.00 0.00 6.70 35,795.00 0.00 Rate and Payment Information July 1, 1997 ('redie Corporation Quote Q01443419-01 CITY OF LODI Rates Valid Through: July 29, 1997 PAYMENT INFORMATION: 1. Term is the number of monthly payment periods. Fimmcing Proposal 2. Unless otherwise specified on the Supplement, Interest starts on the date that payment of the Purchase price or one-time charge is due for Products and Services; or the date we provide you the funding for all other charges. 3. Payment amounts for monthly payment periods are invoiced as of the first day of each calendar month and are due on the first day of the following month. Payment amounts for all other payment Periods (for example, annual) are invoiced 30 calendar days before the end of their Payment period and are due on the day following the close of the respective payment period. PLEASE NOTE: FINANCING RATES IN THIS QUOTE HAVE BEEN SPECIFICALLY PREPARED FOR YOU AND ARE CONTINGENT UPON THE RATE ASSUMPTIONS BEING CORRECT, ALL CONDITIONS BEING MET, AND THE TIMELY COMPLETION OF REQUIRED DOCUMENTATION. IBM CREDIT CORPORATION RESERVES THE RIGHT TO MODIFY OR WITHDRAW THIS OFFER IF, IN THE SOLE DECISION OF IBM CREDIT, THERE IS AN ADVERSE CHANGE IN THE CUSTOMER'S FINANCIAL CONDITION. Please contact your Financial Marketing Advisor Carol Hobbs with any questions. Rate and Payment Information July 1, 1997 - - CreditC,o'pun";'M /PMA Payment Schedule Customer Name: CITY OF LODI Reference Number: 901443419-01 Date: July 1, 1997 Mach/Model: 3570/801 Net Purchase Price: 12,121.00 Term: 60 Payment Frequency: monthly Install Month: 07/97 Option: IG monthly Rate: 6.50% Interest Commencement Date: 08/01/1997 Payment Schedule calculations are based on the Planned Install Date, the Interest Commencement Date and reflect any downpayments. Payments and charges resulting from loan prepayment prior to the stated end of term, will be based on the actual Install Date and Interest Commencement Date. Payment Due ------------ Payment ------------- Fin. Charge -------------- -------------- Principal SEP 01, 1997 237.16 65.66 171.50 OCT 01, 1997 237.16 64.73 172.43 NOV 01, 1997 237.16 63.79 173.37 DEC 01, 1997 237.16 62.85 174.31 JAN 01, 1998 237.16 61.91 175.25 FES 01, 1998 237.16 60.96 176.20 MAR 01, 1998 237.16 60.01 177.15 APR 01, 1998 237.16 59.05 178.11 MAY 01, 1998 237.16 58.08 179.08 JUN 01, 1998 237.16 57.11 180.05 'UL 01, 1998 237.16 56.14 181.02 AUG 01, 1996 237.16 55.16 182.00 SEP 01, 1998 237.16 54.17 182.99 OCT 01, 1998 237.16 53.16 183.98 NOV 01, 1998 237.16 52.18 184.98 DEC 01, 1998 237.16 51.18 185.98 JAN 01, 1999 237.16 50.17 186.99 FEB 01, 1999 237.16 49.16 188.00 MAR 01, 1999 237.16 48.14 189.02 APR 01, 1999 237.16 47.12 190.04 MAY 01, 1999 237.16 46.09 191.07 JUN 01, 1999 237.16 45.05 192.11 JUL 01, 1999 237.16 44.01 193.15 AUG 01, 1999 237.16 42.97 194.19 SEP 01, 1999 237.16 41.91 195.25 OCT 01, 1999 237.16 40.86 196.30 NOV 01, 1999 237.16 39.79 197.37 DEC 01, 1999 237.16 38.72 198.44 JAN 01, 2000 237.16 37.65 199.51 FEB 01, 2000 237.16 36.57 200.59 MAR 01, 2000 237.16 35.48 201.68 APR 01, 2000 237.16 34.39 202.77 MAY 01, 2000 237.16 33.29 203.87 - N 01, 2000 237.16 32.19 204.97 JUL 01, 2000 237.16 31.08 206.08 AUG 01, 2000 237.16 29.96 207.20 SEP 01, 2000 237.16 28.84 208.32 Balance 12,121.00 11,949.50 11,777.07 11,603.70 11,429.39 11,254.14 11,077.94 10,900.79 10,722.68 10,543.60 10,363.55 10,182.53 10,000.53 9,817.54 9,633.56 9,448.58 9,262.60 9,075.61 8,887.61 8,698.59 8,508.55 8,317.48 8,125.37 7,932.22 7,738.03 7,542.78 7,346.48 7,149.11 6,950.67 6,751.16 6,550.57 6,348.89 6,146.12 5,942.2S 5,737.28 5,531.20 5,324.00 5,115.68 PAGE 1 of 2 Credi! Corporation Customer Name: CITY OF LODI Reference Number: Q01443419-01 Date: July 1, 1997 Payment Due Payment OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR APR PiAY 1 UN JUL AUG 2000 2000 2000 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 2002 2002 2002 2002 237.15 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 237.16 Total 14,229-60 tPMA Payment Schedule Fin. Charge Principal Balance 27.71 209.45 4,906.23 25.58 210.58 4,695.65 25.43 211.73 4,483.92 24.29 212.87 4,271.05 23.13 214.03 4,057.02 21.98 215.18 3,841.84 20.81 216.35 3,625.49 19.64 217.52 3,407.97 18.46 218.70 3,189.27 17.28 219.88 2,969.39 16.08 221.08 2,748.31 14.89 222.27 2,526.04 13.68 223.48 2,302.56 12.47 224.69 2,077.87 11.26 225.90. 1,851.97 10.03 227.13 1,624.84 8.80 228.36 1,396.48 7.56 229.60 1,166.88 6.32 230.84 936.04 5.07 232.09 703.95 3.81 233.35 470.60 2.55 234.61 235.99 1.17 235.99 0.00 2,106.60 12,121 00 PAGE 2 of 2 Credit Co'Fa ation 1PMA Paynunt Schedule Customer Name: CITY OF LODI Reference Number: Q01443419-01 Date: July 1, 1997 Mach/Model: 7852/400 Net Purchase Price: 525.00 Term: 60 Payment Frequency: monthly Install Month: 07/97 Option: IG monthly Rate: 6.50% Interest Commencement Date: 08/01/1997 Payment Schedule calculations are based on the Planned Install Date, the Interest Commencement Date and reflect any downpayments. Payments and charges resulting from loan prepayment prior to the stated end of term, will be based on the actual Install Date and Interest Commencement Date. Payment Due ------------------------- Payment Fin. Charge Principal ---------------------------- Balance --------------- SEP 01, 1997 10.27 2.84 7.43 525.00 517.57 OCT 01, 1997 10.27 2.60 7.47 510.10 NOV 01, 1997 10.27 2.76 7.51 502.59 DEC 01, 1997 10.27 2.72 7.55 495.04 JAN 01, 1998 1.0.27 2.68 7.59 487.45 FEB 01, 1998 10.27 2.64 7.63 479.82 MAR 01, 1998 10.27 2.60 7.67 472.15 APR 01, 1998 10.27 2.56 7.71 464.44 MAY 01, 1998 10.27 2.52 7.75 456.69 JUN 01, 1998 10.27 2.47 7.80 448.89 JUL 01, 1998 10.27 2.43 7.84 441.05 AUC 01, 1998 10.27 2.39 7.88 433.17 SEP 01, 1998 10.27 2.35 7.92 425.25 C:,: 01, 1998 10.27 2.30 7.97 417.28 NOV 01, 1998 10.27 2.26 6.01 409.27 DT -C 01, 1998 10.27 2.22 8.05 401.22 JAN 01, 1999 10.27 2.17 8.10 393.12 F:.B 01, 1999 10.27 2.13 8.14 384.98 F-A.R 01, 1999 10.27 2.09 8.16 376.80 APR 01, 1999 10.27 2.04 8.23 368.57 MAY 01, 1999 10.27 2.00 8.27 360.30 JUN 01, 1999 10.27 1.95 8.32 351.98 JUL 01, 1999 10.27 1.91 8.36 343.62 AUG 01, 1999 10.27 1.86 8.41 335.21 SE? 01, 1999 10.27 1.82 8.45 326.76 OCT 01, 1999 10.27 1.77 8.50 318.26 Nov 01, 1999 10.27 1.72 8.55 309.71 DEC 01, 1999 10.27 1.68 8.59 301.12 JAN 01, 2000 10.27 1.63 8.64 292.48 FEB 01, 2000 10.27 1.58 8.69 283.79 FILAR 01, 2000 10.27 1.54 8.73 275.06 APR 01, 2000 10.27 1.49 8.76 166.28 MAY 01, 2000 10.27 1.44 8.83 257.45 JUN 01, 2000 10.27 1.39 8.88 248.57 JUL 01, 2000 10.27 1.35 8.92 239.65 AUG 01, 2000 10.27 1.30 8.97 230.68 SEP 01, 2000 10.27 1.25 9.02 221.66 PAGE 1 of 2 credit {,orEwrutiun Customer Name: CITY OF LODI Reference Number: Q01443419-01 Date: July 1, 1997 Payment Due OCT 01, 2000 NOV 01, 2000 DEC 01, 2000 JAN 01, 2001 FEB 01, 2001 MAR 01, 2001 APR 01, 2001 MAY 01, 2001 JUN 01, 2001 JUL 01, 2001 AUG 01, 2001 SEP 01, 2001 OCT 01, 2001 NOV 01, 2001 DEC 01, 2001 JAN 01, 2002 FEB 01, 2002 MAR 01, 2002 ADR 01, 2002 MAY 01, 2002 TUN 01, 2002 JUL 01, 2002 AUG 01, 2002 Total Payment 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 10.27 616.20 Fin. Charge 1.20 1.15 1.10 1.05 1.00 0.95 0.90 0.85 0.80 0.75 0.70 0.65 0.59 0.54 0.49 0.44 0.38 0.33 0.27 0.22 0.17 0.11 -0.09 91.20 IPMA Payment Schedule Principal 9.07 9.12 9.17 9.22 9.27 9.32 9.37 9.42 9.47 9.52 9.57 9.62 9.68 9.73 9.78 9.83 9.89 9.94 10.00 10.05 10.10 10.16 10.36 525.00 Balance 212.59 203.47 194.30 185.08 175.81 166.49 157.12 147.70 138.23 126.71 119.14 109.52 99.84 90.11 80.33 70.50 60.61 50.67 40.67 30.62 20.52 10.35 0.00 PAGE 2 of 2 Credit COrpwralioo Customer Name: CITY OF LODI Reference Number: 901443419-01 Date: July 1, 1997 IPMA Payment Schedule Mach/Model: 9406/510 Net Purchase Price: 201,420.00 Term: 60 Payment Frequency: monthly Install Month: 07/97 Option: IG monthly Rate: 6.50% Interest Commencement Date: 08/01/1997 Payment Schedule calculations are based on the Planned Install Date, the Interest Commencement Date and reflect any downpayments. Payments and charges resulting from loan prepayment prior to the stated end of term, will be based on the actual Install Date and Interest Commencement Date. Payment ------------ Due ------------- Payment Fin. Charge -------------- Principal Balance ---------------------------- 201,420.00 SEP 01, 1997 3,941.01 1,091.02 2,849.99 198,570.01 OCT 01, 1997 3,941.01 1,075.59 2,865.42 195,704.59 NOV 01, 1997 3,941.01 1,060.07 2,880.94 192,823.65 DEC 01, 1997 3,941.01 1,044.46 2,896.55 169,927..10 JAN 01, 1998 3,941.01 1,028.77 2,912.24 187,014.86 FEB 01, 1998 3,941.01 1,013.00 2,928.01 184,086.85 MAR 01, 1998 3,941.01 997.24 2,943.87 181,142.98 APR 01, 1998 3,941.01 981.19 2,959.82 178,183.16 MAY 01, 1998 3,941.01 965.16 2,975.85 175,207.31 UN 01, 1998 3,941.01 949.04 2,991.97 172,215.34 JUL 01, 1998 3,941.01 932.83 3,008.18 169,207.16 AUG 01, 1998 3,941.01 916.54 3,024.47 156,182.69 SEP 01, 1998 3,941.01 900.16 3,040.85 163,141.84 OCT 01, 1998 3,941.01 883.68 3,057.33 160,084.51 NOV 01, 1998 3,941.01 867.12 3,073.89 157,010.62 DEC 01, 1998 3,941.01 850.47 3,090.54 153,920.08 JAN 01, 1999 3,941.01 833.73 3,107.28 150,812.80 FEB 01, 1999 3,941.01 816.90 3,124.11 147,688.69 MAR 01, 1999 3,941.01 799.98 3,141.03 144,547.66 APR 01, 1999 3,941.01 782.97 3,158.04 141,389.62 MAY 01, 1999 3,941.01 765.86 3,175.15 138,214.47 JUN 01, 1999 3,941.01 748.66 3,192.35 135,022.12 JUL 01, 1999 3,941.01 731.37 3,209.64 131,812.48 AUG 01, 1999 3,941.01 713.98 3,227.03 128,585.45 SEF 01, 1999 3,941.01 696.50 3,244.51 125,340.94 OCT 01, 1999 3,941.01 678.93 3,262.08 122,078.86 NOV 01, 1999 3,941.01 661.26 3,279.75 118,799.11 DEC 01, 1999 3,941.01 643.50 3,297.51 115,501.60 JAN 01, 2000 3,941.01 625.63 3,315.38 112,186.22 FEB 01, 2000 3,941.01 607.68 3,333.33 108,852.89 MAR 01, 2000 3,941.01 589.62 3,351.39 105,501.50 APR 01, 2000 3,941.01 571.47 3,369.54 102,131.96 MAY 01, 2000 3,941.01 553.21 3,387.80 98,744.16 JUN 01, 2000 3,941.01 534.86 3,406.15 95,338.01 JUL 01, 2000 3,941.01 516.41 3,424.60 91,913.41 AUG 01, 2000 3,941.01 497.86 3,443.15 88,470.26 SEP 01, 2000 3,941.01 479,21 3,461.80 85,006.46 PAGE 1 of 2 Credit Corporation Customer Name: Reference Number Date: Payment Due OCT 01, 2000 NOV 01, 2000 DEC 01, 2000 JAN 01, 2001 FEB 01, 2001 MAR 01, 2001 APR 01, 2001 MAY 01, 2001 JUN 01, 2001 JUL 01, 2001 AUG 01, 2001 SEP 01, 2001 OCT 01, 2001 NOV 01, 2001 DEC 01, 2001 JAN 01, 2002 FEB 01, 2002 MAR 01, 2002 APR 01, 2002 MAY 01, 2002 JUN 01, 2002 JUL 01, 2002 AUG 01, 2002 Total CITY OF LODI Q01443419-01 July 1, 1997 Payment 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 3,941.01 236,460.60 Fin. Charge 460.46 441.61 422.65 403.50 384.44 365.17 345.80 326.33 306.75 287.06 267.27 247.37 227.36 207.25 187.02 166.69 146.25 125.69 105.02 84.25 63.35 42.35 21.03 35,040.60 IPMA Payment Schedule Principal 3,480.55 3,499.40 3,518.36 3,537.41 3,556.57 3,575.84 3,595.21 3,514.58 3,634.26 3,653.95 3,673.74 3,693.64 3,713.65 3,733.76 3,753.99 3,774.32 3,794.76 3,815.32 3,835.99 3,856.76 3,877.66 3,898.56 3,919.98 201,420.00 Balance 81,527.91 78,028.51 74,510.15 70,972.74 67,416.17 53,840.33 60,245.12 56,630.44 52,996.18 49,342.23 45,668.49 41,974.85 38,261.20 34,527.44 30,773.45 26,999.13 23,204.37 19,389.05 15,553.06 11,696.30 7,818.64 3,919.98 0.00 PAGE 2 of 2 CtCdt[ COrfiOf7RfiOR IPMA Payment Schedule Customer Name: CITY OF LODI Reference Number: '201443419-01 Date: July 1, 1997 Mach/Model: 5###/### Net Purchase Price: 35,795.00 Term: 60 Payment Frequency: monthly Install Month: 07/97 Option: S monthly Rate: 6.50% Interest Commencement Date: 08/01/1997 Payment Schedule calculations are based on the Planned Install Date, the Interest Commencement Date and reflect any downpayments. Payments and charges resulting from loan prepayment prior to the stated end of term, will be based on the actual Install Date and Interest Commencement Date. Payment Due Payment Fin. Charge Principal Balance SEP 01, 1997 700.37 193.89 506.48 35,795.00 35,288.52 OCT 01, 1997 700.37 191.15 509.22 34,779.30 NOV 01, 1997 700.37 168.39 511.98 34,257.32 DEC 01, 1997 700.37 185.61 514.76 33,752.56 JAN 01, 1998 700.37 182.83 517.54 33,235.02 FEB 01, 1998 700.37 180.02 520.35 32,714.67 MAR 01, 1998 700.37 177.20 523.17 32,191.50 APR 01, 1998 700.37 174.37 526.00 31,665.50 KAY 01, 1998 700.37 171.52 528.85 31,136.65 UN 01, 1998 700.37 168.66 531.71 30,604.94 3UL 01, 1998 700.37 165.78 534.59 30,070.35 AUG 01, 1998 700.37 162.88 537.49 29,532.86 SE? 01, 1998 700.37 159.97 540.40 28,992.46 OCT 01, 1998 700.37 157.04 543.33 28,449.13 NOV 01, 1998 700.37 154.10 546.27 27,902.86 DEC 01, 1998 700.37 151.14 549.23 27,353.63 JAN 01, 1999 700.37 148.17 552.20 26,801.43 FEB 01, 1999 700.37 145.17 555.20 26,246.23 MAR 01, 1999 700.37 142.17 558.20 25,688.03 APR 01, 1999 700.37 139.14 561.23 25,126.80 MAY 01, 1999 700.37 136.10 564,27 24,562.53 JUIN 01, 1999 700.37 133.05 567.32 23,995.21 JUL 01, 1999 700.37 129.97 570.40 23,424.81 AUG 01, 1999 700.37 126.88 573.49 22,851.32 SEP 01, 1999 700.37 123.78 576.59 22,274.73 OCT 01, 1999 700.37 120.65 579.72 21,695.01 NOV 01, 1999 700.37 117.51 582.86 21,112.15 DEC 01, 1999 700.37 114.36 586.01 20,526.14 JANN 01, 2000 700.37 111.18 589.19 19,936.95 FEB 01, 2000 700.37 107.99 592.38 19,344.57 MAR 01, 2000 700.37 104.78 595.59 18,746.98 APR 01, 2000 700.37 101.56 598.81 18,150.17 MAY 01, 2000 700.37 98.31 602.06 17,548.11 JUN 01, 2000 700.37 95.05 605.32 16,942.79 JUL 01, 2000 700.37 91.77 608.60 16,334.19 AUG 01, 2000 700.37 88.48 611.89 15,722.30 Sv-P 01, 2000 700.37 85.16 615.21 15,107.09 PAGE 1 of 2 �r cm4ig t,OrporcLav 7 Customer Name: CITY OF LODI Reference Number: Q01443419-01 Date: July 1, 1997 Payment Due OCT 01, 2000 NOV 01' 2000 DEC 01, 2000 JAN 01, 2001 FEB 01, 2001 MAR 01, 2001 APR 01, 2001 MAY 01, 2001 JUN 01, 2001 JUL 01, 2001 AUG 01, 2001 SEP 01, 2001 OCT 01, Z001 NOV 01, 2001 DEC 01, 2001 JAN 01, 2002 FEB 01, 2002 MAR 01, 2002 APR 01, 2002 MAY 01, 2002 UN 01, 2002 JUL 01, 2002 AUG 01, 2002 Total Payment 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 700.37 42,022.20 Fin. Charge 81.83 78.48 75.11 71.72 68.32 64.90 61.45 57.99 54.51 51.01 47.50 43.96 40.41 36.83 33.24 29.62 25.99 22.34 18.66 14.97 11.26 7.53 3.79 6,227.20 IPMA Payment Schedule Principal 618.54 621.89 625.26 628.65 632.05 635.47 638.92 642.38 645.86 649.36 652.87 656.41 659.96 663.54 667.13 670.75 674:38 678.03 681.71 685.40 689.11 692.84 696.58 35,795.00 Balance 14,488.55 13,866.66 13,241.40 12,612.75 11,980.70 11,345.23 10,706.31 10,063.93 9,418.07 8,768.71 8,115.84 7,459.43 6,799.47 6,135.93 5,468.80 4,798.05 4,123.67 3,445.64 2,763.93 2,078.53 1,389.42 696.56 0.00 PACE 2 of 2 ** TOTAL PAr;E, 11 *_* RESOLUTION NO. 97-102 A RESOLUTION OF THE LODI CITY COUNCIL APPROVING THE LEASE/PURCHASE OF AN AS/400 RISC COMPUTER, AND THE PURCHASE OF HARDWARE AND OPERATING SYSTEM SOFTWARE WHEREAS, Lodi Municipal Code, §3.20.070, authorizes dispensing with bids for purchases of supplies, services or equipment when it is in the best interests of the City to do so; and WHEREAS, the existing AS/400 based "mission critical' application software must be repaired or replaced prior to the year 2000 in order to avoid system failures; and WHEREAS, new software will occupy greater disk space and computer memory, and will require much more processing power to operate efficiently. Modern database oriented applications require greater resource, but deliver much greater value in terms of availability and content of information. Newer applications also provide improved functionality and accuracy of data along with a much improved user interface; and WHEREAS, in addition to meeting the Year 2000 need, we must be ready for citywide connectivity and communication and have the repository of data which the future will demand; and WHEREAS, the current AS/400 is seven years old, with outdated processor design, and is not capable of handling the demand included with today's sophisticated software. WHEREAS, it is staff recommendation that the City Council authorize the five year lease/purchase of the AS/400 RISC Computer, and the purchase of new mag tape backup, fax/modem, and the operating system software; and NOW, THEREFORE, BE IT RESOLVED, that the Lodi City Council hereby approves the five year lease/purchase of an AS/400 RISC Computer, and purchase new mag tape backup, fax/modem, and the operating system software from IBM in the amount of $236,460.60 and S50,000.00 respectively. Dated: July 16, 1997 ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- I hereby certify that Resolution No. 97-102 was passed and adopted by the City Council of the City of Lodi in a regular meeting held July 16, 1997, by the following vote: AYES: COUNCIL MEMBERS - NOES: COUNCIL MEMBERS ABSENT: COUNCIL MEMBERS - ABSTAIN: COUNCIL MEMBERS - ALICE M. REIMCHE Acting City Clerk 97-102