Your analysis should include (1) Trevor's best customers (top 10 in terms of volume and revenue); (2) Trevor's worst customers (bottom 10 in terms of lowest volume and lost revenue); and (3) the mochanics that perform the repairs for each customer. SOME PARTICULARS YOU SHOULD KNOW 1. As you consider the information provided to you, think in terms of what information is important. You might need to use the existing information to create new information. 2. In your analysis, provide examples of the types of marketing campaigns Trevor should offer his most valuable customers. 3. Upon completing your analysis, please provide concise yet detailed and thorough documentation (in narrative, numeric, and graphic forms) that justifies your recommendations. 4. File: TREVOR.xis (Excel file). ASSESSING THE VALUE OF CUSTOMER RELATIONSHIP MANAGEMENT TREVOR TOY AUTO MECHANICS Trevor Toy Auto Mechanics is an automobile repair shop in Phoenix, Arizona. Over the past few years, Trevor has seen his business grow from a two-bay car repair shop with only one other employee to a 15 -bay car repair shop with 21 employees. Trevor wants to improve service and add a level of personalization to his customers. However, Trevor has no idea who his best customers are, the work that is being performed, or which mechanic is responsible for the repairs. Trevor is asking for your help. He has provided you with a spreadsheet file, TREVOR.xls, that contains a list of all the repairs his shop has completed over the past year including each client's name along with a unique identifier. The spreadsheet file contains the fields provided in the table below