Business Case
Project Project Name:
Computer mputer Ope Operrated Database
(COD)
By:
Team Ventur Venture:
Pat Bannon Andrew Nerger Dan Wilson
Project Project Descr Descriptio iption Husky
Air is a prominent airline company located at the DeKalb Taylor Municipal Airport in DeKalb, Illinois. Husky Air provides services such as ref ueling, aviation maintenance, rentals, renta ls, and aviation su pplies to volunteer pilots referred to as Pilot Angels. Pilot Angels work w ith hospitals and healthcare agencies by flying patients in need of surgery, diagnostics, or other medical services to their necessary destinations. Husky
Air requires a database system to keep track of o f all information critical to its operations to replace their paper file system. The database will utilize information such as names, addresses, and phone numbers, as well as other usef ul flight information. information. easurable Measur
Org Organizati anizatio onal Value
Team Venture will provide a compatible database system syste m solution based on the alternatives stated, and then constr uct and implement that database. d atabase. Objectives: 1. Organizational Value a. The Database will contain a list list of o f information on: i. Pilot Angels; name address phone number, total hours, certifications, etc ii. Planes; name, type of plane, identification number (n-number), engine type, capacity (passengers and cargo), cargo ), ownership iii. Patients; name, condition, address, destination, medical history, et c iv. Passengers; name, address, relationship, etc v. List of flights; pilot pilot who flew flight, passengers on board, plane used, total time of flight, distance and destination of flight, date and time of the flight, and total f uel used. 2. Better Service a. Match patience with most compatibl co mpatiblee pilot, plane, and equipment i. Database will be able to handle simple queries that coordinate flights more efficiently 3. Faster Information a. Reduce the time required to process a patient i. Database will be easily accessible to staff and will be able to attain information in real time for employees etrics Metr
1. Time to process orders will be reduced by 90% 2. Patient satisfaction will increase 25% The target metrics will be achieved within w ithin three months of implementation by using surveys and observations to prove objectives.
Summary: Husky Air¶s Pilot Angel Program will possess a f unctional database system in order to provide faster information for its operational staff and pilots, as well as better service for its patients. of Alterrnatives Compar mpariso ison of Alte
Track Via(Software Package) - provides software as a service for t urning spreadsheets into databases that are tr usted and used by Fortune 100 companies. Database needs to be tailored by Husky Air associates for use.
Up Front Cost: $99-249 a month Additional Fees: Additio Additional User Users:
$20/User/Mo
Archives:
$100/archive
Additio Additional Recor Records: ds:
$15/50K Records/Mo
Email Campaig Campaigns:
$0.01/addressee
Additio Additional Stor Stora age:
$20/1GB/Mo
T&M Ser Service Rate:
$180/Hour
Stand-Alo Stand-Alone API API::
Please call
24x7 Suppor Support: t:
Please call
http://www.trackvia.com/products/pricing-new
Indirect Cost y y
training creation time
Total Benefits of Ownership y y y y y y
Increase high-value work Improves accuracy and efficiency Improved decision making Improved service Easy to use and respected software Quick Installation
ile F ile
and Paper (Status Quo ) ± Keep the original system
Up Front Cost - $0 Indirect Costs y y y
Cost of added employees over o ver time if work flow increases Wasted time and resources Opportunity cost
Maintenance Cost y y y
Paper Salary Storage
Total Benefits of Ownership y y
Build
Low cost Gets job done Database System- create a custom database system that suit Husky Air¶s needs.
Total Cost of Ownership y y y
Upfront Cost - $5,000 Indirect Costs - Training Maintenance - $50/ hour service after third year of implementation
Total Benefits of Ownership y y y y y
Improve coordination between plane, pilots, and equipment Minimal variable cost Improved decision making time Improved Accuracy/ Efficiency Improved service for clients
Reco Recommendatio mmendation
Based u pon the previous comparisons a custom built database system is the su perior alternative for Husky Air. It provides long term cost effective solution to its management situation, and will be most adept at handling Husky Air¶s specific needs.
