1 Texas Cars LLC Project Sponsor: Bob Smith CEO of Texas Cars LLCPhone: Fax: Presented By Arlo Carreon Elvis Candelaria Nupur Agarwal Swetha Srinivasan

2 Table of Contents Business Background Business NeedBusiness Requirements Business Value Issues and Constraints

3 Business Background Administrative Office: Houston, TXTexas Cars is a privately owned car dealership in the State of Texas. Deals with buying/selling used cars. Texas Cars is composed of 5 franchises: Houston, Dallas, Austin, San Antonio and Corpus Christi. Administrative Office: Houston, TX

4 Business Need Present: Texas Cars shares a hosted Excel document on Google Documents. Each franchise edits the document, inserting their current inventory. On current website potential customers can fill out a form which s a car request to the nearest franchise.

5 Business Need (cont) Problem: Only 10% of website car requests turn into sales. This manual process of receiving request and manually looking over the excel sheet for possible match takes approximately 20 min per request. With the number of requests increasing, valuable time is being taken from Sales Representatives each day. Also, potential customer usually waits too long for a reply.

6 Business Need (cont) Solution: Creating a centralized inventory system which can be maintained by each franchise. This system will be able to instantly show potential customers results according to their search requirements.

7 Business RequirementsDesign/create Database for Texas Cars’ inventory system. Create a login portal for administrative personnel for each franchise. Create a login portal for potential customers to create wish lists. Browse through the cars according to specifications such as make, model, color, price, mileage and type.

8 Business Value Internet Application is portal and can be accessed anywhere by the administrators. Reduce the administrative cost, due to decrease in manual processing. Improve customer satisfaction through: Easier application process. Easier and faster search response. Reports can be viewed by: Monthly, yearly, quarterly, etc. Revenue. Inventory. Market analysis when buying new inventory.

9 Issues and ConstraintsShould be completed by: November 2009. Training must be done by: September 2009. $200,000 will be needed to develop the system.

10 Questions ?