Loading...
FY2009-07 New World Systems License AgreementMs. Sharon Blakeslee Kodiak Island, r'" g, 7 10 Mill Bay Road, Kodiak,, AK 99615 Dear Ms. Blakeslee: New World Systems is pleased to provide additional services for Loges. NET Training. The atta:ched fonn (Exhibit. B) Is to 'be reviewed and approved, 'by you and/or your authorized, representative. It describes the additional services you have requested along with the related fees. Other than for the purposes of internal review, we ask ,that, you treat our fees as confidential �information. This due to the competitive nature of our business. The General Terms and Condiflons, from our original License Agreement are incorporated, and contmue to apply. , Any taxes or fees imposed from the course of this Agreement are the responsibility of the Customer. We thank you for your continued busmess with New World Systems. We look forward to working on, this project with you. Date: lq- (Customer) r rvl By: 141 q Authorized n Sia r tu g e Titte aa o Authorized Signature Title 11 Each indi'vidual. signing above represents that (s)he has the requisite authorit e-#x behalf of the organizaflon for which (s)he repriesents and that all the necessary forma The "Effective Date" of this Agreement is the latter of the two dates in the above signature b Corporate: 888 West Big Beaver Road * Suite 600 o Troy * Michigan 48084 -4 749 a 248-269-1000 * www. n 0410-12LIA 0730Add Training Svcs m EXHIBIT B ADDIT10NAL SUPPORT SERVICES AND FEE, L Sup t Hours Recommended Up, to 40 hours have been allocated to provide Logos.NET Training. Actual usage may be higher, or 0 lower based on Customer's requirements and use of the support services. Support services, are typ�ic all y per -ned at Custamer's premises but may be provided at New 'World national headquarters, in Troy, Michigan. C i er agrees to reimburse New World for support trips canceled by Customer less than.. ten, (10) days before the scheduled start date to cover New World's out of pocket costs and lost revenues. 2. Sup Service Fees The hours cited above will be provided at the! rate of $160 per hour. AnY additional support, services provided, by New World outside the scope of this Agreement will be pr id ed as an additional cost at the Customer's hourly rate in t at that time. use on the hours listed above, the support service cost Iii. $ ,, (Plus all actual and reasonable travel expenses 'incurred by, New World divided proportionately between all New World customers visited on a single trip, and actual employees travel time up to but not exceed four (4) hours per Customer visit.), 3. Payments, for Services and Travel. Costs Support Services will be billed as follows: a I ,) Amount, invoiced upon the Effect' ve Date (100%) TOTALDUE.*#*# was 6 avis 6 psi *stoat a at* a* 0*0 0 as 0 00 0,60 as 640 6 of* *ao**** goo 0 000 as to so*&** 0 0 0 00 0 0 0#0 0 Go *Sao* Go *goo a a 4100 All travel, costs will be billed weekly for the previous calendar week. Any taxes or fees imposed from the course: of this Agreement are the responsibility of the Customer and. Customer agrees to remit when imposed. If an exemption i's claimed by the Customer, an exemption certificate must be submitted to New World. Payments are due within fiftee .5) days from receipt of invoice, Kodiiak Istand Borough,,AK CONFIDENTIAL Page 2 of 2 0410-12LIA 0730 Add Training � Svcs, New World Systems Public Sector 1i)/rrrare 4bn; /nosy Mr. Karleton Short Kodiak Island Borough 710 Mill Bay Road Kodiak, AK 99615 Dear Mr. Short: New World Systems is pleased to provide additional services for systems upgrade. The attached form (Exhibit B) is to be reviewed and approved by you and /or your authorized representative. It describes the additional services you have requested along with the related fees. Other than for the purposes of internal review, we ask that you treat our fees as confidential information. This is due to the competitive nature of our business. The General Terms and Conditions from our original License Agreement are incorporated and continue to apply. Any taxes or fees imposed from the course of this Agreement are the responsibility of the Customer. We thank you for your continued business with New World Systems. We look forward to working on this project with you. ACKNOWLEDGED AND AGREED TO BY: October 4 2010 ADDITIONAL SERVICES AGREEMENT NEW WORLD SYSTEMS CORPORATION (New W Id) _ a stomer) KODIAK ISLAND BOROUGH, AK Larry 7 Leinweber, Presi Each individual signing above represents that (s)he has the requisite authority to execute this Agreement on behalf of the organization for which (s)he represents and that all the necessary formalities have been met. The "Effective Date" of this Agreement is the latter of the two dates in the above signature block. PRICING 1S VALID THROUGH DECEMBER 23, 2010. Corporate: 888 West Big Beaver Road • Suite 600 • Troy • Michigan 48084 -4749 •248- 269 -1000 • www.newworldsystens.com 1. Service Fees and Travel Costs EXHIBIT B ADDTTIONAL SUPPORT SERVICES AND FEES Allocating adequate support service resources for systems upgrade including: Current system review /analysis; Migration planning and pre -trip consultation; On -site trip (2 -3 days); Windows Server 2008 installation & Configuration; SQL Server 2008 installation and configuration; Logos.NET installation; system performance tuning; and establishment of maintenance plans and back -up procedures will be $5,000. (Plus all actual and reasonable travel expenses incurred by New World divided proportionately between all New World customers visited on a single trip and actual employee travel time for Installation and Training up to but not exceed four (4) hours per Customer visit.) The installation and training support services are typically performed at Customer's premises but, at Customer's option, may be provided at New World national headquarters in Troy, Michigan. (Other support services often involve services performed at the New World's national headquarters.) Customer agrees to reimburse New World for support trips canceled by Customer less than ten (10) days before the scheduled start date to cover New World's out of pocket costs and lost revenues. Additional support services provided by New World after execution of this Agreement will be provided at the Customer's hourly rate in effect at that time, currently $160 per hour. 2. Additional Services Available Other New World services may be required or requested for the following: (a) File conversion assistance; (b) Consulting with New World technical staff; (c) Modifying the Licensed Standard Software; (d) Designing and programming Custom Software; (e) Maintaining modified Licensed Standard Software and/or Custom Software; (f) New World Consultation with other vendors or third parties; (g) Software testing; and /or (h) Assistance as Customer is going "live ". Customer may request these additional services in writing using New World's Request For Service (RFS) procedure (or other appropriate procedure mutually agreed upon by Customer and New World). 3. Payments for Services and Travel Costs Support Services will be billed as follows: a) Amount invoiced upon the Effective Date (100 %) $5,000 TOTAL DUE S Q9 All travel costs will be billed weekly for the previous calendar week. Any taxes or fees imposed from the course of this Agreement are the responsibility of the Customer and Customer agrees to remit when imposed. If an exemption is claimed by the Customer, an exemption certificate must be submitted to New World. Payments are due within fifteen (15) days from receipt of invoice. (2L CNT 100410 Sys Upgrade) CONFIDEN " FIAL Page 2 of 2 Kodiak Island Borough, AK c r i New World Systems y U1,1 1(V.! 1,41 "!I'i'±l lr!!kitlf Mr. Karleton Short Finance Director Kodiak Island Borough 710 Mill Bay Road Kodiak, AK 99615 Dear Mr. Short: ADDITIONAL SOFTWARE LICENSE AGREEMENT For a Logos 400 to Logos .NET Upgrade New World Systems is pleased to license you additional software and provide implementation services for the upgrade of your AS/400 licensed standard software to the New World .Logos .NET Licensed Standard Software. The attached forms (Exhibits A, B, C and F) are to be reviewed and approved by you and/or your authorized representative. They describe the additional software and services you have requested along with the related fees. Other than for the purposes of internal review, we ask that you treat our fees as confidential information. This is due to the competitive nature of our business. The General Terms and Conditions from our original License Agreement with Kodiak Island Borough, AK, are incorporated and continue to apply. Upon completion of the upgrade to Logos .NET standard software, the definition of COMPUTER from the (June 29, 1990) Agreement will be both the .NET server(s) and the IBM AS /400 in use. Any taxes or fees imposed from the course of this Agreement are the responsibility of the Customer. Please acknowledge the change and your understanding on the services by the appropriate signature below. ACKNOWLEDGED AND AGREED TO BY: NEW WORLD SYSTEMS CORPORATION (New World) / (Customer) B Date: Lar D. Leinweber, President /2 -22 -ve M e si-; October 3, 2008 KOKIAK ISLAND BOROUGH, AK n itt r o YQ v�'e-r Date: Al pi/6k Each individual signing above represents that (s)he has the requisite authority to execute this behalf of the organization for which (s)he represents and that all the necessary formalities h The "Effective Date" of this Agreement is the latter of the two dates in the above signature blo PRICING IS VALID THROUGH DECEMBER 26, 2008. Corporate: 888 West Big Beaver Road • Suite 600 • Troy • Michigan 48084 - 4749.248 -269 -1000 • www.n Fy.2oa9 -o7 1. License Fee for Licensed Standard Software And Documentation Selected By Customer: Application Package 1 (0,( .\I:l `I \ \I) \ILI) I'I'I.I( \ I IO\ tiOI INN \RI .' FINANCIAL MANAGEMENT 1. Logos.NET Financial Management Base Suite - General Ledger - Budget Management - Annual Budget Preparation - Accounts Payable Module - Revenue /Cash Receipting 2. Logos.NET Additional Financial Management Software - Asset Management 5,000 - Project Accounting 5,000 - Misc. Billing & Receivables 5,000 - Govemment (GASB) Reporting 9,000 - Business Analytics 3,000 3. Logos.NET Procurement Management Suite - Purchasing Base .t B \1 1 I\ \ \( I t1. \I \\ \(.I: \II:\ I \101)1 I.I' 11.111111 PAYROLL & HUMAN RESOURCES SUITE 4. Logos.NET Human Resources Management Base Suite - Payroll Processing - Personnel Mana' ement .I li -1 OI VI 1' !WI I. 111 \I \ ILI -' )L R( 1 . \IOD(I I • 211.1111(1 NEW WORLD STANDARD SOFTWARE LICENSE FEE LESS CUSTOMER LOYAL SOFTWARE CREDIT 101 tI. `OI INN WI I. I( I \' 1 . 1 1 1 '.2S -115 1 EXHIBIT A LICENSED STANDARD SOFTWARE AND FEES Cost (Users included - 10) $25,000 9,000 (Users included - 5) 20,000 81,000 (45,595) � CONFIDENTIAL 4 CNT ADD,1 1Sp2Win.docx Page 2 of 11 Kodiak Island Borough, AK Exhibit A / LICENSED STANDARD SOFTWARE AND FEES 2 3 4 6 ENDNOTES Personal Computers must meet the minimum hardware requirements for New World Systems' Logos.NET product. Microsoft Windows 2000 or Windows /XP with IE 6.0 are the required operating systems for all client machines. Windows 2003 Server is required for the Application Server(s), Web Server(s) and Database Server. SQL Server 2005 is required for the Database Server. New World Systems Logos.NET product requires Microsoft Windows 2003 Server and SQL Server 2005 including required Client Access Licenses (CALs) for applicable Microsoft products. Servers must meet minimum hardware requirements provided by New World Systems. Suggested minimum: 100MB Ethernet Network. 10MB CATS Ethernet Network may have less than adequate response time. Further consultation would be required to assess your network. Additional cost per group of 5 for standard user is $5,000. s Prices assume that all software proposed is licensed. Prices are quoted as preliminary estimates only and are subject to further clarification and confirmation. Any taxes or fees imposed are the responsibility of the purchaser and will be remitted when imposed. 2. License Fee Payment Schedule for Licensed Standard Software and Documentation a) DOWN PAYMENT 50% of the total Exhibit A cost [Invoiced upon receipt of signed Standard Software License and Services Agreement.] b) DELIVERY PAYMENT 50% of each application cost [Invoiced as each Exhibit A Licensed Standard Software package is delivered to Customer.] TOTAL LICENSED STANDARD SOFTWARE PAYMENTS DUE ALL PAYMENTS ARE DUE WITHIN FIFTEEN (15) DAYS FROM RECEIPT OF INVOICE PRICING VALID THROUGH DECEMBER 26, 2008 $17,700 17,705 CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 3 of 11 Kodiak Island Borough, AK 1. Project Management Services EXHIBIT B PROJECT MANAGEMENT, INSTALLATION AND TRAINING SUPPORT SERVICES AND FEES New World shall act as Project Manager to assist Customer's management in implementing the Exhibit A software. This responsibility will include documenting, coordinating and managing the overall Implementation Plan with Customer's management and the Customer Liaison. Project Management Services include: a) a summary level Implementation Plan; b) a detail level Implementation Plan; c) revised Implementation Plans (if required); d) monthly project status reports; and e) project status meetings • a project review (kickoff) meeting at Customer's location • progress status meeting(s) will occur during implementation via telephone conference or at Customer's location; and • a project close -out meeting at Customer's location to conclude the project. To implement the Exhibit A applications, the Project Management fee will be $12,000. This fee covers the above Project Management Services for a period up to 12 months after this Agreement is executed. 2. Implementation and Training Support Hours Recommended It is recommended that appropriate support hours are allocated for all Licensed Standard Software listed in Exhibit A to insure successful implementation of and training on each application package. Based on the Licensed Standard Software listed on Exhibit A, 480 hours of New World implementation and training support services have been allocated. Avoiding or minimizing custom or modified features will aid in keeping the support costs to the amount allocated. Customer agrees to reimburse New World for support trips canceled by Customer less than ten (10) days before the scheduled start date to cover New World's out -of- pocket costs and lost revenues. The recommended implementation and training support services include: a) implementation of each package of Licensed Standard Software; and b) Customer training and/or assistance in testing for each package of Licensed Standard Software. The project management, implementation and training support services are performed at Customer's premises and/or at New World national headquarters in Troy, Michigan (e.g., portions of project management are performed in Troy). 3. Hardware Quality Assurance Service Fees A flat rate fee is charged for quality assurance of the Customer's existing .Net Server(s). This fee does not include hardware and/or third -party product costs. Whenever possible, this work will be done remotely, resulting in savings in travel costs. If an on -site installation review is required, Customer will be responsible for the actual travel costs. a) Hardware Quality Assurance Fee $6,000 TOTAL QUALITY ASSURANCE SERVICE FEES $6,000 CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 4 of 11 Kodiak Island Borough, AK • Exhibit B / PROJECT MANAGEMENT, INSTALLATION AND TRAINING SUPPORT SERVICES AND FEES 4. Suaaort Service Fees Estimate The 480 hours of installation and training support services cost has been calculated using a rate of $140 per hour. Additional services are also available at the rate of $140 per hour. This rate is protected for one year from the date New World executes this Agreement. After one year, Customer shall pay the then - current hourly rate for all Exhibit B support services rendered. Based on the services suggested above, the Project Management ($12,000), Installation and Training Support Services ($67,200) and Quality Assurance Services ($6,000) costs will be a total of $85.200. (Plus all actual and reasonable travel expenses incurred by New World divided proportionately between all New World customers visited on a single trip and actual employee travel time for Installation and Training up to but not exceeding four (4) hours per Customer visit.) 5. Additional Services Available Other New World services may be required or requested for the following: a) additional software training; b) tailoring of Licensed Standard Software by New World technical staff and/or consultation with New World technical staff; c) New World consultation with other vendors or third parties; d) modifying the Licensed Standard Software; e) designing and programming Licensed Custom Software; and f) maintaining modified Licensed Standard Software and/or custom software. Customer may request these additional services in writing using New World's Request For Service (RFS) procedure (or other appropriate procedures mutually agreed upon by Customer and New World). 6. Payments for Proiect Management Services Project Management Services will be billed as follows: a) 10 days after the Effective Date $3,600 b) 90 days after the Effective Date 3,600 c) 180 days after the Effective Date 3,600 d) Upon project completion or 365 days after 1,200 the Effective Date, whichever comes first. TOTAL PROJECT MANAGEMENT SERVICES FEE $12,000 7. Payments for Hardware Quality Assurance Services Hardware Quality Assurance Services will be billed as follows: a) 50% of the total amount is due upon the Effective Date $3,000 b) 50% of the total amount is due upon completion of Quality Assurance 3,000 TOTAL HARDWARE QUALITY ASSURANCE SERVICES FEE $6,000 CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 5 of 11 Kodiak Island Borough, AK Exhibit B / PROJECT MANAGEMENT, INSTALLATION AND TRAINING SUPPORT SERVICES AND FEES 8. Payments for Installation and Training Support Services and Travel Costs All hours for installation and training support services and all travel costs will be billed weekly for services provided in the previous calendar week. Note: Any taxes imposed from the course of this Agreement are the responsibility of the Customer and Customer agrees to remit when imposed. If an exemption is claimed by the Customer, an exemption certificate must be submitted to New World. ALL PAYMENTS ARE DUE WITHIN FIFTEEN (15) DAYS FROM RECEIPT OF INVOICE. CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 6 of 11 Kodiak Island Borough, AK 9 This Standard Software Maintenance Agreement (SSMA) between New World Systems Corporation (New World) and Kodiak Island Borough, AK, (Customer) sets forth the standard software maintenance support services provided by New World. 1. Service Period 4. Billing EXHIBIT C STANDARD SOFTWARE MAINTENANCE AGREEMENT This SSMA shall remain in effect for a period of five (5) years (the SSMA term) beginning on July 1, 2009, (the start date) and ending on the same calendar date at the conclusion of the SSMA term. 2. Services Included The following services or features are available under this SSMA: a) upgrades, including new releases, to the Licensed Standard Software (prior releases of Licensed Standard Software application packages are supported no longer than nine (9) months after a new release is announced by New World); b) temporary fixes to Licensed Standard Software (see paragraph 6 below); c) revisions to Licensed Documentation; d) reasonable telephone support for Licensed Standard Software on Monday through Friday from 8:00 a.m. to 8:00 p.m. (Eastern Time Zone); and e) invitation to and participation in user group meetings. Items a, b, and c above will be distributed to Customer by electronic means. Additional support services are available as requested by Customer using the then - current hourly rates or applicable fees. Exhibit B has a description of support services available. 3. Maintenance for Modified Licensed Standard Software and Custom Software Customer is advised that if it requests or makes changes or modifications to the Licensed Standard Software, these changes or modifications (no matter who makes them) make the modified Licensed Standard Software more difficult to maintain. If New World agrees to provide maintenance support for Custom Software or Licensed Standard Software modified at Customer's request, or for prior releases of New World's software, then the additional New World maintenance or support services provided shall be billed at the then - current Exhibit B hourly fees plus reasonable expenses. Maintenance costs will be billed annually, beginning on the start date and on the same day each year thereafter for the term of the SSMA. (Any Exhibit B support or service hours and travel costs incurred are billed weekly for the previous calendar week.) 5. Additions of Software to Maintenance Agreement Additional Licensed Standard Software licensed from New World will be added to the SSMA ninety (90) days after delivery. Costs for the maintenance for the additional software will be billed to Customer on a pro rata basis for the remainder of the maintenance year and on a full year basis thereafter. CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 7 of 11 Kodiak Island Borough, AK Exhibit C / STANDARD SOFTWARE MAINTENANCE AGREEMENT 6. Requests for Software Correction on Licensed Standard Software At any time during the SSMA period, if Customer believes that the Licensed Standard Software does not conform to the current specifications set forth in the user manuals, Customer must notify New World in writing that there is a claimed defect and specify which feature and/or report it believes to be defective. Before any notice is sent to New World, it must be reviewed and approved by the Customer Liaison. Documented examples of the claimed defect must accompany each notice. New World will review the documented notice and when a feature or report does not conform to the published specifications, New World will provide software correction service at no charge. (See paragraph 4.0 of the General Terms and Conditions of this Agreement for the New World warranties provided). A non - warranty request is handled as a billable Request For Service (RFS) (see Exhibit B). The no- charge software correction service does not apply to any of the following: a) situations where the Licensed Standard Software has been changed by anyone other than New World personnel; b) situations where Customer's use or operations error causes incorrect information or reports to be generated; and c) requests that go beyond the scope of the specifications set forth in the current User Manuals. 7. Maintenance Costs for Licensed Standard Software Packages Covered for .NET Server(s) and IBM iSeries 400 Model New World agrees to provide software maintenance at the costs listed below for the following New World Licensed Standard Software packages installed at Customer's location: Application Packages for Logos.NET Number of Modules 1) Logos.NET Financial Management Base Suite 5 2) Logos.NET Additional Financial Management Software 5 3) Logos.NET Procurement Management Suite 1 4) Logos.NET Human Resources Management Base Suite 2 5) Logos 400 Financial Management Software* 1 6) Logos 400 Property Tax Software* 5 7) Logos 400 Utility Information Software* 1 * Licensed in prior contract. Annual Maintenance Cost (5 -Year Plan) Billed annually and due on July 1 of each year) Year 1 for period July 1, 2009 — June 30, 2010 $46,320 Year 2 for period July 1, 2010 — June 30, 2011 3% increase over previous year Year 3 for period July 1, 2011 — June 30, 2012 3% increase over previous year Year 4 for period July 1, 2012 — June 30, 2013 3% increase over previous year Year 5 for period July 1, 2013 — June 30, 2014 3% increase over previous year ALL PAYMENTS ARE DUE WITHIN FIFTEEN (15) DAYS FROM RECEIPT OF INVOICE. CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 8 of 11 Kodiak Island Borough, AK • New World Responsibilities EXHIBIT F DATA FILE CONVERSION ASSISTANCE New World will provide conversion assistance to Customer to help convert the existing data files specified below. If additional files are identified after contract execution, estimates will be provided to Customer prior to New World beginning work on those newly identified files. General 1. This conversion effort includes data coming from one unique database or source, not multiple sources. 2. No data cleansing, consolidation of records, or editing of data will be part of the data conversion effort. Any data cleansing, removal of duplicate records, or editing must take place by Customer prior to providing the data to New World. 1. New World will provide the data conversion programs to convert Customers data from a single data source to the New World Licensed Standard Software for the specified files that contain 500 or more records. 2. New World will provide Customer up to 2 test sets of the converted data. Additional test sets requested may /will require additional conversion costs. 3. As provided in the approved project plan for conversions, New World will schedule a conversion analysis trip and a separate data conversion testing trip to Customer's location. The conversion testing trip will be part of delivering the conversion programs to Customer. 4. New World will create and provide Customer with a conversion design document for signoff prior to beginning development work on the data conversion. No conversion programming by New World will commence until Customer approves this document. Customer Responsibilities 1. Discrete data files from Customer's current database are included in this conversion. 2. Data files submitted must include an accurate count of records contained in the file. Customer understands that files or tables containing less than 500 records or table entries will not be converted. 3. As provided in the project plan for conversions, Customer will provide a dedicated resource in each application area to focus on conversion mapping and testing. This includes dedicating a support person(s) whenever New World staff is on site regarding conversions. Roughly a one to one ratio exists for Customer commitment and the New World commitment. Customer understands that thorough and timely testing of the converted data by Customer personnel is a key part of a successful data conversion. 4. Customer agrees to promptly review and signoff on both the conversion design document, and on the final conversions after appropriate review. CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 9 of 11 Kodiak Island Borough, AK Fin Finance Base - (Minimum Requirement) • COA - The chart of accounts includes funds, organizations 2 through 6, base and detail accounts, organizations sets. • Vendor - Vendors include the base vendor, vendor contacts, and vendor addresses. • Projects - Project set up and general ledger transactions. • GL History - The General Ledger History conversion includes the detailed general ledger transaction history. • Current Year's Budget - Pending budget. • Budget History - Adopted budget history. • Banks - Bank set up includes the bank information and the bank account information. • Departments - Departments include the conversion of the functional department and sub - department codes • Limited Master Files - Financial Managements master files include invoice types, sales tax, and validations sets. • Purchase Orders - Purchase order, detail items, disbursements, receipt of goods, requisitions, change history. • Accounts Payable - Accounts Payable conversion includes the accounts payable invoices, detail items, charges, payments, checks, and disbursements. • Limited Master Files - • Misc. Billing Customer - Customers, include customer demographic information, customer contacts, and customer addresses. • Misc. Billing Invoice - Accounts receivable invoices, payments, and disbursements. • Limited Master Files - Financial Managements master files include customer types, invoice types, and validation sets. • Revenue Collection Receipts - Receipt transactions • Limited Master Files - Financial Managements master files include payment codes, collection stations, and validations sets. • Fixed Assets/ Pending Assets - Assets, asset items, asset classifications, transaction history. • Limited Master Files - Financial Managements master files include depreciation methods, asset classifications, and validation sets Exhibit F / DATA FILE CONVERSION ASSISTANCE Files to be converted: Human Resources / Payroll: Employee Base - (Minimum Requirement) • Employee - Employee Master Files include Employee demographic information, assigned benefits, assigned deductions, assigned taxes, assigned pay rate, employee direct deposit set up, employee gl distributions, assigned schedules, assigned dependents, assigned Certification. • Employee Check Messages - Check messages to appear on the employee's check. • Employee Documents - Attaches Word and Excel documents to the employee. Free form text on the 400 is not supported. • Employee Inventory - Inventory items such as keys, pagers, and key cards assigned to employees. • Employee Education - Education, skills, and certifications aquired by the employee. • Master Files - HR Master files include Benefit Codes, Deduction Codes, Tax Codes, Hours Codes, Hours Categories, Shift Codes, FLSA Codes, Job Classes, Grades/Rates, Workers Compensation codes, Frequency Codes Separate Check codes, Bank Accounts, Benefit Groups, Pay Batches, Departments and Sub - departments and validation set entries required for employee set up. CONFIDENTIAL 1 CNT ADD 100308 Up2Win.docx Page 10 of 11 Kodiak Island Borough, AK Exhibit F / DATA FILE CONVERSION ASSISTANCE Payroll History Base - (Required if not going live on January 1. Requires base Employee Base.) • Pay Batch History - The batch history for payroll. • Earnings History - The employees earnings history by pay batch. • Deduction History - The employees deduction payment history by pay batch. • Benefit History - The employees benefit history by pay batch. • Hours History - The employees hour history by pay batch. This includes earned and taken accrual hours. • Payroll Journal - Detail line items of main General Ledger journal entry. Customer Investment The cost for the Data File Conversion services is 24,000 and is to be paid as follows: a) DOWN PAYMENT (50% - due upon the Effective Date) $12,000 b) ANALYSIS PAYMENT 7,200 (30% - due upon delivery of conversion design document to Customer) c) FINAL PAYMENT 4,800 (20% - due 30 days after initial delivery of converted data) TOTAL PAYMENTS DUE FOR DATA FILE CONVERSION (Exhibit F) $24,000 Note: Where applicable, travel costs for New World employees to complete the tasks for Exhibit F services are billed under the provisions of Exhibit B services. All travel to be mutually agreed upon by Customer and New World. 1 CNT ADD 100308 Up2Win.docx CONFIDENTIAL Page 11 of 11 Kodiak Island Borough, AK