Value of customer relationship management

Assignment Help Financial Management
Reference no: EM131509


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.

Column Name                 Description

A CUSTOMER #               A unique number assigned to each customer

B CUSTOMER NAME         The name of the customer

C MECHANIC #                A unique number assigned to the mechanic who completed the work

D CAR TYPE                     The type of car on which the work was completed

E WORK COMPLETED      What type of repair was performed on the car

F NUM HOURS                 How long in hours it took to complete the work

G COST OF PARTS           The cost of the parts associated with completing the repair

H TOTAL CHARGE             The amount charged to the customer for the repair

Your analysis should include

(1) Trevor's best customers;

(2) Trevor's worst customers; and

(3) the mechanics that perform the repairs for each customer.

Reference no: EM131509

Previous Q& A

  Create a system to manage the overall process

Create a system to manage the overall process

  Explain whether the firm will make economic profit

Explain whether the firm will make economic profit, In the short run and In the long run.

  Draw a teapot at the global origin

Draw a teapot at the global origin

  What is the dipole contribution to the scalar potential

Charge is distributed with constant volume density D throughout the rectangular box with length a, width b and height c.

  Implement the guess the word

Implement  the ‘Guess the Word' game in an object-oriented manner

  Write an essay on locke''s theory of meaning

Write an essay on Locke's theory of meaning

  Explain include authority and reasoning

Explain the problem with authority and resoning

  Prepare a marymount faculty site

Prepare a Marymount faculty site

  American society in the making

American Society in the Making


Write a Review


Similar Q& A

  Maximization of shareholder wealth

Maximization of shareholder wealth

  Pricing and production decisions

Pricing and Production Decisions at PoolVac, Inc.

  Develop a financial analysis

Develop a financial analysis

  Capital budget methods

What is the project's NPV?

  Determine the proposed projects internal rate of return

Determine the proposed project's internal rate of return.

  Supply and demand

Question based on supply and demand

  Indifference curve analysis

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change.

  Pricing objectives and pricing methods

Pricing objectives and pricing methods in the services sector

  Calculate the minimum variance and optimal portfolio

Create a model that will automatically calculate the minimum variance and optimal portfolio as well as be able to draw the efficient frontier for a 3 risky asset portfolio.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Create a portfolio of analytical reference materials

Create a portfolio of analytical reference materials including the financial reports for at least five years. This is your analytical permanent file for the selected company.

  Calculate the market value of renowned cola''s debt

Joe Brown and Fred Anthony are planning to invest in a Go Green project. Calculate the market value of Renowned Cola's debt

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd