Orange County NC Website
.Insufficient Re ortin Ca abilities <br />The legacy system software reporting of revenues and expenditures is inflexible and inefficient. <br />There are no opportunities to create specialized reports since the report formulation requires <br />manual intervention from a programmer. The data presented is not user friendly (An example <br />of the detailed expenditure screen on the current software is included as Attachment 2.) <br />Further, the software is limited to regurgitation of data. Any analysis of data must be <br />accomplished by another means. <br />Capabilities in newer technology applications would allow departments to create their own <br />reports based on their specific information need. This would significantly reduce the amount of <br />time spent by some internal services departments (Budget, Finance, Personnel, Purchasing) <br />who constantly provide information to departments on a variety of issues (E.G. payments made <br />to vendors, status of purchase orders, status of budget amendments, status of personnel <br />actions, etc.). <br />Batch Processin4 <br />Work is posted to the General Ledger at this time using a batch processing method. For <br />example, at the end of the day purchase orders that have been encumbered or bills that have <br />been paid will be "posted". It is only after a batch has been posted that they are reflected in an <br />account. As a result of batch processing, the balances reflected on the General Ledger screen <br />are likely to be inaccurate most of the time. This becomes parkicularly problematic toward the <br />end of a fiscal year when funds may become limited. <br />Pro osed Action <br />The Needs Assessment is clear in its recommendation that the legacy software should be <br />replaced. The IT Committee has also endorsed the replacement of the business system <br />software. The course of action recommended by Summit Business Solutions (SBS) is as <br />follows: <br />• Solicit a Request for Proposal pursuant to the Needs Assessment; <br />• Analyze the options, cost, benefits and risks for each of the systems proposed; <br />• Utilize life-cycle costing methodology to determine the best long term option for the <br />County; <br />• Select a recommended vendor for County Commissioner consideration; <br />• Negotiate a contract with the recommended vendor; <br />• Develop an implementation plan. <br />Because of the complexity of issues associated with acquisition of large package software, it is <br />recommended that the County extend the existing contract with Summit Business Solutions to <br />include the steps mentioned above. SBS has a demonstrated working knowledge of a number <br />of governmental software packages being used by North Carolina counties. This is a critical <br />component in determining a final package and implementation cost and in successful contract <br />negotiation. SBS also has detailed knowledge of the County's software needs and <br />requirements developed in the course of the needs assessment. <br />Should the Board endorse the plan of action, Requests for Proposals would likely be solicited in <br />fall 2001, with recommendation for acquisition presented for Board consideration in early 2002. <br />Financial package components will be brought on line first within an anticipated 12-18 month <br />time period after award of a contract. Other components such as Human Resources may <br />extend full implementation by an additional six months, thereby making total system <br />implementation complete within approximately 24 months. <br />