system analysis report 50pages

J.A.A. Systems Consulting

Logo here

System Proposal for Autos R Us

By: Justin Teran, Abdul Foudah, and Abdulaziz Alrasheed

Background:

Business:

Autos R Us

Business Location:

88 Fair Dr. Costa Mesa, CA 92883

Owner:

Susan Krause

Telephone: (949)-498-7088

Website: extremeautoseatcovers.com

Table of Contents

Executive Summary................................. 1

Background............................................. 2

Project Plan............................................. 3

Process Modeling.................................... 5

Data Modeling.........................................

Candidate Tech Solution..........................

Executive Summary :

The objective for Auto’s R Us is to have a fully functional, cheap, effective, and efficient Customer Relation Management (CRM) System. Because of that fact that Auto’s R Us has been in business for 30 years, they contain a lot of legacy customer data, most of it written on paper. A CRM system will allow them to better organize and utilize their vast library of customer information. It will also allow them to do away with many file cabinets, and increase the security of their valuable data.

J.A.A. has identified three possible systems solutions: a cloud based solution, a customized proprietary system, and a system provided by a vendor.

The Vendor built solution offers rapid scalability and rapid implementation, but is the most expensive, and therefore not cost effective. The proprietary system is also expensive, and will take more time and labor to build. The cloud based solution is the cheapest solution, has available documentation, extended resources such as customer support, and excellent bandwidth capacity. We have decided that the cloud based CRM is most suited to meet the needs of Autos R Us due to its ease of use, ease of implementation, and cost effectiveness.

This system solution will offer scalability, 24/7 accessibility on the cloud, and sustainability (less maintenance). The costs for the new system have been broken down as follows:

Cost:

Background

About the Business:

Autos R us was founded in 1985 in Orange County, California. They are a small business that sells automotive interior accessories such as seat covers and dash covers. They are open only on Saturdays and Sundays, and the rest of the week they fill, process, and ship orders. They currently do not use any enterprise systems, they simply use file cabinets. The disadvantages of using file cabinets to store data are: bulk, data repetition, lost, damaged or stolen data, and difficulty sifting through the data. The implementation of a CRM system will help Auto’s R Us organize and consolidate their valuable 30 years’ worth of data, and make it possible to integrate their CRM with their website later on.

Project Plan:

Business Problem:

Currently Autos R Us does not have a CRM system. As mentioned, they are still using file cabinets, which is an out dated method of storing data. In addition to the obvious disadvantages of using file cabinets, they rely heavily on employee time and resources. This has been costing the company countless extra hours that it could have been using to improve its processes or increase productivity instead. In Addition, if they wanted to send out promotional coupons of fliers to previous customers, they would need to do countless hours of reading, writing, and sifting through data.

New System:

With the cloud based CRM system implemented, Autos R Us’ productivity will increase drastically. This is because the CRM system will free up more employee time that would have otherwise been spent sifting through file cabinets to find customer information. The CRM will allow Autos R Us to sort customer names alphabetically, chronologically (by when the order was placed), or in virtually any other way. This will make it easier to sift through the customer information to find specific customers, etc. Another benefit of the system will be the ability to quickly and efficiently extract customer information in order to send fliers and other promotional content to customers via email or mail. In summary, not only will Autos R Us save revenue in the form of less time spent with file cabinets, they will also potentially generate more revenue due to the ease of sending out promotional offers.

Brief statement of problem, opportunity or directive	Urgency	Visibility	Annual Benefits	Priority	Proposed Solution
Building/buying the system determines the production of the system.	High	Low	$10,000	1	New Development
The system will need to be interoperable with other future Databases and systems	High	High	$12,000	2	Make compatible/interoperable with future systems and website.
System should be available 24/7	High	Medium	$15,000	3	Make system available 24/7 and remotely.
The system should protect customer and other important data	High	Medium	$25,000	4	Encrypt and secure all data in the system.
Identify different roles and wages that will be involved with maintaining the system.	Medium	Medium	9,000	5	New development

Process Modeling

System Outline

System: CRM@Auto’sRUs

Entities: Customer, Product, Order                                 

Data Flow:    Inputs: Customer info, Order Info, Product Description

Outputs: Invoice

Process/Task: