GPLEB Software Proposal
March 17, 2009
GPLEB Software Proposal /ISQS 4350: Project Management /
Nathan Blacketer
Jeff Morris
Brian Wilder
3/17/2009 /
Table of Contents
Scope
Advantages
Financial
Cost Analysis
Cost Management Plan
Plan
Project Analysis
Deliverables
Project Analysis
Project Design
Project Integration
Project Testing
Acceptance
Alternatives
Terms and Conditions
Glossary
GPLEB Software Proposal
March 17, 2009
Scope
The Great Plains Lions Eye Bank (GPLEB) procures and, when necessary, imports donor tissue to service patients suffering from corneal blindness in West Texas. Information regarding tissue recovery and tissue importation must be documented and statistics must be kept in accordance with the bylaws of the Eye Bank Association of America (EBAA) and the Food and Drug Administration (FDA). At present, the GPLEB utilizes a bulky, inefficient paper filing system to catalog each donor and import entry. This practice costs the GPLEB thousands of dollars per year in paper and man hours – hours which could be put to much better use.
BMW Ltd. has developed a solution to this problem utilizing a system that would keep these files and statistics electronically. Our system will file the necessary attributes for each donor and each tissue, but will reduce waste. By making use of a LAMP configuration (an arrangement that consists of a Linux operating system, an Apache web server, MySQL as a database server and PHP as a development language), we will be able to effectively set up a working database that will be simplistic enough for inexperienced users to learn quickly and yet powerful enough to be able to perform each function necessary. It will also be exponentially faster to use our system as opposed to filling out each file by hand. The data entered will be backed up weekly to local and external servers weekly to ensure that all information is saved and secure. Our system will be able to produce all of the reports and statistics that the GPLEB will require every month and every year. Not only will this be a more efficient and responsible system for the eye bank, it will also increase employee morale because of the elimination of redundant and tedious work.
At this point we do not anticipate significant future growth beyond the GPLEB’s needs, but we feel it would be wise to be prepared in case there becomes a demand for program among eye banks nationwide. The GPLEB handles roughly 200 tissues every year and our database will be capable of holding 5000 entries, so the database should last the eye bank 25 years. We will provide training for eye bank employees, but we will also be developing a manual so that we can be prepared in the event that there becomes a larger demand for our system. Not only will this program benefit the GPLEB, but the possibility of a standardized system nationwide would be advantageous for the entire eye bank community.
Our proposed system will not include provisions for research tissue, since we are being asked only to catalog surgical tissue. In addition, we will not include paperwork for items ordered, items received or any cleaning and lab maintenance documentation in our system.
Advantages
Our software system will enjoy a litany of advantages over the current paper file system the GPLEB currently employs. The first of these is the fact that our system will end the need for thousands of dollars worth of paper per year. Our system will keep these files electronically and the data will be available 24 hours per day. If an employee has access to the server at his or her residence, he or she can even make updates to the data from home! Our system will also free up space inside the eye bank. At present, the entries into these paper files are stored in cabinets which take up a great deal of space. With all the files kept electronically, this space can be used for a more worthwhile cause.
Another advantage our system will provide is time and cost savings in terms of man hours. The annual statistical reports for the EBAA and FDA that took days to compile previously will now be generated in a matter of minutes. In addition, everyday tasks at the eye bank will now be able to be done at a computer station, rather than having to fill out 27 different forms in sequence. What was once a two or three day job for two people will now be a 1 hour job for one person.
The GPLEB would benefit from using our system over any other sort of system because one of our team is actually a former eye banker that understands the demands and needs of the eye bank. Not only can we provide a better service because of this, but we also have an understanding of what the EBAA and FDA require.
Page 1GPLEB Software Proposal
March 17, 2009
Financial
If we can get a go ahead decision by March 23, 2009, our assigned start date will be March 26, 2009. From that point, our estimated completion date for creation of the system will be April 20, 2009 and testing can begin. The entire process is scheduled to be finished on May 16, 2009.
Cost Analysis
ID / Task Name / Cost1 / Eye Bank System / $19,120.00
2 / Implementation / $14,960.00
3 / Creation / $7,840.00
4 / Back-End / $1,120.00
5 / Donor Data Tables / $560.00
6 / Tissue Data Tables / $560.00
7 / Front-End / $6,720.00
8 / Donor / $3,360.00
9 / Data Entry Screen / $1,120.00
10 / Statistics / $1,120.00
11 / Reporting / $1,120.00
12 / Tissue / $3,360.00
13 / Data Entry Screen / $1,120.00
14 / Statistics / $1,120.00
15 / Reporting / $1,120.00
16 / Debugging / $7,120.00
17 / Alpha - (Internal) / $2,240.00
18 / Back-End Testing (Load Balancing) / $560.00
19 / Front-End Testing / $1,680.00
20 / Beta - (External) / $2,400.00
21 / Client Check-off Sheets / $2,400.00
22 / Collect Results / $800.00
23 / Bug Fixes / $1,680.00
24 / Documentation / $3,360.00
25 / User Manual / $1,680.00
26 / Developer Manual / $1,680.00
27 / Training / $800.00
28 / Meeting / $800.00
Cost Management Plan
Sincethe systems we are utilizing are open source programs and the Department of Ophthalmology already has a server that we can make use of, costs will be kept at a minimum. The only costs for the GPLEB will be the yearly maintenance of the system and the cost of our project team. The yearly maintenance ends up being $1200.00/year and the costs of the team end up being $19,120.00.
Plan
The BMW Ltd. Project team will consist of Brian Wilder as the Project Manager and two Developers, Jeff Morris and Nathan Blacketer. The major phases of the proposed system are outlined below, along with individual tasks that must be undertaken.
Project Analysis
Conduct interviews with eye bank and ophthalmology personnel to learn about GPLEB’s current practices.
Design requirements document as a guideline for scope and draw up proposal.
Present proposal to chief stakeholders.
Deliverables
During the course of this project, there will be four deliverables. The deliverables must be completed in proper sequence in order for the project to be completed correctly. Each deliverable is assigned a specific start and end date. These time constraints must be met to keep the project on time.
Project Analysis
Start: March 26, 2009
End:March 31, 2009
Project Design
Start:April 1, 2009
End:April 12, 2009
Project Integration
Start:April 13, 2009
End:April 25, 2009
Project Testing
Start:April 26, 2009
End:May 09, 2009
Acceptance
Our team will have scheduled review points where the customer will be able to ascertain whether their expectations are being met or not. Once the stakeholders have the report, they will have 3 business days to determine whether or not to accept the work or make changes. If changes are necessary, our developers will be available to the stakeholders to discuss the nature of these changes.
Alternatives
The GPLEB could continue working with the current paper system, which would cost more and involve more man hours. The eye bank could also use another eye bank’s database system, but our system will be specifically designed to meet the GPLEB’s needs, while other software will not. Another option the GPLEB could consider would be to use Microsoft Access and create its own database. However, unless the company has the right personnel, the database might not be easy for the user to navigate and it would lack a proper graphical user interface. For these reasons, we believe that our software would be the most beneficial option for the GPLEB.
Terms and Conditions
This proposal and the associated cost quote will be good for 10 days after this proposal’s receipt. BMW Ltd. cannot be held responsible for any problems that are not associated with this proposal or BMW Ltd.’s exclusive work. The BMW team will not assume any liability relative to this proposal. Upon acceptance of this proposal, the customer is expected to fulfill its responsibilities, just as BMW Ltd. is. Our team guarantees the work it has suggested, subject to changes in cost and duration because of customer changes.
Glossary
BMW Ltd. – The Blacketer Morris Wilder team that will develop the software
GPLEB – Great Plains Lions Eye Bank
FDA – Federal Food and Drug Administration
LAMP – Linux Apache MySQL PHP configuration for software
Page 1