"Master Contract Summarization"
Support and Operations Services Master Contract STATEMENT OF WORK FOR TECHNOLOGY Services ISSUED BY Minnesota Department of Finance Description of Work Government Accounting Standards Board (GASB) Statement No. 34 requires that in addition to the fund level financial statements included in the State’s Comprehensive Annual Financial Report (CAFR), financial statements will be included to report on the state government as a whole using the full accrual method of accounting for all fund types. The State will have to issue two sets of financial statements for certain fund types: one set using the modified accrual basis of accounting and a second set using the full accrual method. The State is acquiring a financial reporting software system, FundWare 7 Enterprise Level 1 from American Fundware, Inc., that is a computer-based, accounting software system capable of compiling financial information on multiple funds and fund types and reporting on the activities of the State as required by GASB 34. Currently, information (cash and modified accrual basis) from the Minnesota Accounting and Procurement System (MAPS) is downloaded to Microsoft Access for reclassification and summarization purposes and then electronically transferred to Kenrick software, the current financial reporting software that is being replaced by June 30, 2001. The possible information flows when FundWare is installed are as follows: 1) information residing in MAPS will be downloaded to Microsoft Access for reclassification and summarization purposes and then electronically transferred to FundWare for financial statement preparation or, 2) information residing in MAPS will be downloaded directly to Fundware for financial statement preparation. Additionally, information residing outside MAPS, such as for financial statements prepared by other agencies, will be entered into FundWare manually and then further processed as stated under #1. Adjusting journal entries will be processed in Fundware to convert modified accrual financial statements to full accrual financial statements in accordance with GASB 34. The tasks involved in include, but are not limited to, the following: ?? Assist in establishing, or establish, new routines using MAPS data to create Microsoft Access tables with account balances for electronic transfer to the Fundware software. Some examples of the types of tables required to implement GASB 34 are: chart of accounts; amortization of current year bond issuance costs, premiums, and discounts; amortization schedule for capital leases; capital debt analysis of prior year bond issuances and refundings; interfund activity; and reconciliation of fund level to government-wide 1 statements. These tables may include complex formulas required to calculate various financial amounts and values for CAFR presentation. ?? Design, or assist with the design of, routines for uploading the financial information in Access into Fundware software. ?? Assist Department of Finance staff in designing, or designing, reports using the Fundware software system. ?? Assist Department of Finance staff in entering conversion information, such as the chart of accounts and beginning balances, from Kenrick software into Fundware software. Training in FundWare software required to complete the above tasks will be provided by American Fundware, Inc. and/or Department of Finance staff. Product of Result The product or result of this assignment will include: 1) Computer programs which will transfer, compile, and reclassify financial information (mainly account balances) into the formats required for CAFR preparation. These programs will be developed in Microsoft Access. 2) Databases in Microsoft Access where the financial information will reside and be retained for future processing and audit trails. 3) Reports from the Fundware software system that display information in various ways as required by Department of Finance staff. These reports will be developed using Fundware software instructions. Required Skills The following knowledge, skills, and abilities are required: 1) Ability to develop databases in Microsoft Access for purposes of compiling and processing financial information. 2) Ability to develop routines and programs for electronically transferring information from MAPS to Microsoft Access and from Microsoft Access to Fundware. Desired Skills Knowledge and experience in the field of accounting, with an emphasis on governmental account and generally accepted accounting principles is desired. Duration of Assignment 350 hours of programming and/or data entry from June 1 through June 30, 2001. The State requests that responses be based on providing two persons for this time period. 2 The Department of Finance may require the services of a third person; however, this cannot be determined until after June 1, 2001. Responses should include costs for providing a third person if required by the State and the dates that the person would be available during June 2001. The tasks under this work order end on, or before, June 30, 2001. This work order request does not obligate the state to award a work order or complete the assignment, and the state reserves the right to cancel the solicitation if it is considered to be in the State’s best interest. Description of Evaluation Process The evaluation of responses will be based on the following: 1) The cost per hour for each person under this work order. 2) The qualifications and experience of each person who will work with the Department of Finance staff on Access spreadsheets and other matters related to Microsoft Access processing. The weighting of each factor will be as follows: 1) Cost of providing services – 30 percent 2) Qualifications of persons – 70 percent Response Requirements Vendors are to submit candidate resumes directly to Pete Maurer by 3 :00 p.m. on or before the date response are due. This may be done via an attachment to e-mail, or timely delivery of hard copies to the Department of Finance, 658 Cedar Street, 400 Centennial Building, St. Paul, MN 55155. Response Due Date: May 24, 2001 Questions Any questions regarding this Work Order Request should be submitted via e-mail by 12:00 noon on May 23, 2001, to: Pete Maurer: Financial Reporting Supervisor Minnesota Department of Finance 658 Cedar Street 400 Centennial Building St. Paul, MN 55155 (651) 296-5187 firstname.lastname@example.org 3