University Of PhoenixOctober 6, 2008Introduction"During requirements modeling, systems developers must identify and describe all system requirements" (Shelly, Cashman & Rosenblatt, 2004, p. 100,ÃÂ¶ 1) . This document will discuss the factors involved in developing software requirements for the approved software, which will electronically calculate borrowing base ineligibles for asset based banking customers. System requirements are comprised of five general categories, which include outputs, inputs, processes, performance, and controls and will be discussed in the requirements section of this document. The requirements that will be set forth in this document must be followed by the approved software developer chosen by the bank's asset based lending department. This document will not be used in designing the software program.
PurposeThe development of the software program will provide the bank's asset based lending department's collateral analysts and other departmental employees with the ability to calculate borrowing base ineligibles electronically, instead of manually calculating ineligibles for cumbersome customer accounts receivable (AR) and accounts payable (AP) aging reports.
ScopeOver the course of several years, asset based lending management's attention has been focused on the fact that collateral analysts spend a tremendous amount of time manually calculating borrowing base ineligibles, while other areas of work within the department suffer. Typically, a collateral analyst will manually calculate ineligible categories based on cumbersome AR and AP reports, which are provided by the department's customers. By developing a software program that will electronically calculate borrowing base ineligibles based on customer AR and AP aging reports, collateral analyst will spend approximately a few hours a day calculating borrowing base ineligible instead of one or two days manually calculating borrowing base ineligibles. Customer AR and AP aging reports that have been exported into an electronic format such as, PDF, Excel spreadsheets, or text documents must be compatible with the software program that will be developed. The execution of the software program will reduce the amount of time, effort and costs associated with manually calculating borrowing base ineligibles.
RequirementsThe requirements for the software program will be discussed in this section and the developer must adhere to all requirements. The software program must be functional and compatible with all operating systems within the department, which are currently running Windows XP Professional, as well as, other software programs or documents, such as PDF files, Excel spreadsheets and text documents. The software program must also be able to import PDF files, Excel spreadsheets and text documents, in order to calculate borrowing base ineligibles. Other requirements are listed below in system requirements categories, which are as follows:Outputsa.Program must maintain imported AR and AP aging information for two months for each customer account.
b.Program must be able export newly formatted AR and AP agings into a spreadsheet.
c.Program must be able to summarize detailed AR and AP agings.
d.Program must be able to list ineligibles either in detail, summation, by ineligible client, and ineligible categories.
e.Program must be able to recalculate ineligibles if adjustments are made.
f.Program must be able to print all documents listed above.
Inputsa.Program must be able to allow user to change ineligible criteria, such as eligible or ineligible days, percentages for the cross age rule, concentration and other ineligible categories that vary on a customer basis.
b.Program must allow users to change bucket headings in columns, such as logical aging periods, such as 0 - 30 days, 31 - 60 days, 61 - 90 days, and over 90 days.
c.Program must be able to combine customer or vendor names that are segregated based on divisions locations.
d.Program must be able to identify identical or partial AR customer names and AP vendor names in order to determine contra accounts.
Processesa.Program will calculate borrowing based ineligibles based on the cross age rule, accounts over ineligible days, credits over ineligible days, contra accounts, concentration limits, intercompany accounts, international accounts (without letter of credits), and other ineligible categories as determined in loan documents or field examinations.
b.Program must interface correctly with existing system, AWriter for importation of ineligibles, concentrations, past dues, and spreads.
Performancea.Program must be user friendly.
b.Program must be operational seven days a week, 365 days a year.
c.Program must have telephone technical support during regular business hours from 8:00 a.m. - 5:00 p.m. CST or 9:00 a.m. - 4:00 p.m. EST.
d.Response time must not exceed four seconds.
e.The database software program must simultaneously support 30 users; only one user can access one customer at a time.
f.Program must flag when import has failed.
g.Program must be compatible with Microsoft Excel, Adobe Reader, and regular text documents.
h.Program must be able to import electronic PDF, spreadsheets, text documents.
Controlsa.Program should provide security log in for each user.
b.Login information will be synchronized and updated with all other database programs.
c.If program is idle for more than 15 minutes it will log the user out automatically.
d.Additional user controls or additions of users will be maintained by the departmental liaison.
In addition to the above requirements, the software developer must determine how the software program "will handle future growth and demands, and the total cost of ownership, which includes all future operational and support costs" (Shelly, Cashman & Rosenblatt, 2004, p. 102,ÃÂ¶ 1). Expenses for the software program will not exceed $100,000, which will include travel expenses for the software developer, training expenses for departmental employees, the purchase of the software program and licenses, and installation. The total amount of the project will have a onetime fee associated.
Once the software program has been developed and tested by the developer, then the IT department and departmental liaison, will run internal testing's on the software program to ensure the program meets the above requirements. After testing and the software have been approved the developer will begin training classes for all departmental employees along with the departmental liaison.
The timeline for the completion of this project will take approximately six months, which includes two months for development, on month for testing by the developer and internal testing with the IT department and departmental liaison. The program will be installed and deployed to all users during the fourth month and training for all employees will take place in the fifth month. Thus, leading to the six month when the software program will be fully functional.
As noted earlier the program must be user friendly, thus the program will be designed by the developer. Overall, the requirements stated gives guidance's to the software developer and what departmental managers can expect from the software program.
ReferencesShelly, G. B., Cashman, T. J., & Rosenblatt, H. J. (2004). Chapter 3: Requirements Modeling. In Systems Analysis and Design (5th ed., pgs.100 & 102). Course Technology. Retrieved October 4, 2008, from http://ecampus.phoenix.edu/content/eBookLibrary2/content/ereader.aspx?assetmetaid=3df7b872-d3c7-4c1f-a0fe-5ed46961030c&assetdataid=c2047d4b-7855-450e-b51e-6e007038bd6a