Data Collection & Google Map Creation of Data

Part 1: Collect the dealerships of each of the following companies into an excel spreadsheet by company. Part 2: Create pushpins for each company's dealerships on Google Maps so that each companies stores are a different color. Deliverables: Part 1: Excel spreadsheets for each company with their dealerships listed (dealership name, address, city, state, phone) Part 2: Google Map(s) similar to this ([login to view URL];msid=102699283667558123109.000438a1381d08d828a60) You may quote on one or both Parts. AutoNation: ------------------------------- According to the company’s website, AutoNation, Inc. (NYSE: AN) is America's largest Automotive Retailer. Headquartered in Fort Lauderdale, Fla., AutoNation employs approximately 27,000 people at 257 dealership locations representing 331 new vehicle franchises across 16 states. With over $19 billion in annual revenue, AutoNation ranked #112 on the 2005 Fortune 500, outselling all other automotive retailers in the U.S. AutoNation is a member of the S&P 500. [login to view URL];subaction=dealerlist Penske Auto Group: -------------------------------------------- According to the company’s website, Penske Automotive Group is the second largest publicly-traded automotive retailer in the United States as measured by total revenue. As of July 2, 2007, the company owned and operated 164 franchises in the United States and 145 franchises internationally, primarily in the United Kingdom. PAG offers a full range of 41 vehicle brands, with approximately 94% of its revenues (six months ended March 31, 2007) generated from the combined sales of foreign brands and luxury brands such as BMW, Honda, Lexus, Mercedes and Toyota. In addition to selling new and used vehicles, the company generates revenue at each of its dealerships through the sale of higher-margin products, such as finance, insurance and vehicle service contracts, maintenance repair services, replacement parts and aftermarket automotive products. [login to view URL] Sonic Automotive: -------------------------------------- Sonic Automotive, Inc., a Fortune 300 Company, is one of the largest automotive retailers in the United States operating 178 franchises and 37 collision repair centers. Sonic can be reached on the Web at [login to view URL] [login to view URL] Group 1 Automotive: ------------------------------------------------------------------------- According to the company's web site, Houston-based Group 1 Automotive, Inc., a Fortune 500 automotive retailer, is a leading operator in the $1 trillion automotive retailing industry. Group 1 owns and operates 102 dealerships, 140 franchises and 28 collision service centers in the United States and three dealerships, six franchises and two collision centers in the United Kingdom that offer 32 brands of automobiles. Through its dealerships, the company sells new and used cars and light trucks; arranges related financing, vehicle service and insurance contracts; provides maintenance and repair services; and sells replacement parts. [login to view URL] Asbury Automotive Group: -------------------------------------------- According to the company's website, Asbury Automotive Group, Inc., headquartered in New York City, is one of the largest automobile retailers in the U.S., with 2006 revenues of approximately $5.7 billion. Built through a combination of organic growth and a series of strategic acquisitions, Asbury now operates through geographically concentrated, individually branded regions. These regions operate approximately 88 retail auto stores, encompassing 115 franchises for the sale and servicing of 33 different brands of American, European and Asian automobiles. Asbury believes that its product mix contains a higher proportion of the more desirable luxury and mid-line import brands than most public automotive retailers. The Company offers customers an extensive range of automotive products and services, including new and used vehicle sales and related financing and insurance, vehicle maintenance and repair services, replacement parts and service contracts. [login to view URL] (under "dealerships") Lithia Motors: ----------------------------------------------------------------------------- According to the company's website, Lithia Motors, Inc. is one of the largest full-service new vehicle retailers in the United States with 108 stores in 46 markets located in 15 states in the Western and Midwestern United States. Lithia offers 30 brands of new domestic and imported vehicles, all makes of used vehicles, service and parts, and finance/insurance. Internet sales are centralized at "Lithia.com-America's Car & Truck Store". Lithia had total revenues of $3.17 billion in 2006. [login to view URL];subaction=dealerlist