Rank order all of the sales representatives in each category

Assignment Help Financial Management

Reference no: EM131873282

MINICASE: WEST MIDLANDS RESTAURANT APPLIANCES

West Midlands Restaurant Appliances (WMRA), headquartered in Birmingham, UK, sells large, industrial appliances such as refrigerators, freezers, and dishwashers to restaurants all over Great Britain. For several years, the company has been second in UK market share to industry leader Thames Restaurant Services, but it has been gaining share in recent years.

WMRA is especially optimistic about catching Thames this year because of the rise of its star sales manager, David Epstein, an energetic 31-year-old who has been with the company since he was 22. Epstein is popular with the sales staff, but he also is aggressive and demands high performance. One of his initiatives is to make all salespeople accountable by strictly evaluating performance using ratios as well as purely objective measures. In particular, he has collected performance data for each of his seven sales representatives as follows:

Epstein would like to see an analysis of salesperson performance using the following ratios: sales growth, sales to quota, sales per account, average order, sales expense, calls per day, orders per call.

Most of the salespeople are happy to be evaluated, but a few are dubious and fearful of the consequences. Robert Smythe, for one, feels that his territory, which includes some of the more rural areas in western England is more difficult to sell in because there are fewer restaurants and he has only been a salesperson for about a year. In addition, one of Derek Francona’s largest customers recently went out of business, and he feels that his numbers slipped as a result. Both are close to quitting because they feel they are being evaluated unfairly.

Epstein wants to beat Thames very badly this year and feels that improving salesperson performance is the key. Therefore, his performance evaluation system is of the utmost importance.

Exhibit 13.2:

1. From page 433, use (current sales-previous sales)/previous sales to calculate sales growth and (current sales-current quota)/current quota to calculate sales to quota for each sales Rep. Use the formulas provided in Exhibit 13.2, on page 410, to assist in completing the remaining categories of the spreadsheet in the Data Used tab.

2. Rank order all of the sales representatives in each category, then summing the rank orders across for each representative, come up with a ranking. For example, Erin ranks 1st in sales growth, 2nd in sales to quota, 5th in sales per account, and 6th, 4th, 1st, and 2nd in the remaining category for a total of 21 (1+2+5+6+4+1+2=21). Doing a similar exercise for the remaining sales people results in a ranking, from best to worst.

Reference no: EM131873282

Questions Cloud

Creation of an analysis of product introduction : The final project for this course is the creation of an analysis of product introduction. The final product represents an authentic demonstration of competency.

Changing weekly payroll to bi-weekly payroll : Explain the potential advantage to a company of changing a weekly payroll to a bi-weekly payroll.

Illustrating five solutions implemented at hospitals : Review the instructions for your Final Paper located in Week Six of your online course. As part of your Final Paper, you are asked to research and identify.

Write a paper about selling bmw car parts on e bay online : Write a paper about Selling BMW Car Parts On E bay (Online). Own a ware house, break down auction cars, list parts online and mail purchased parts to customers.

Rank order all of the sales representatives in each category : Rank order all of the sales representatives in each category, then summing the rank orders across for each representative, come up with a ranking.

Convert nominal dollars to constant dollars : What three pieces of information are needed to convert nominal dollars to constant dollars?

Conduct longitudinal and cross-sectional financial analyses : Financial analysis is a critical component to strategic planning and execution. We use both financial ratios and common-sized statements to find trends.

What is the minimal amount you should bid per park : You are working on a bid to build two city parks a year for the next three years. What is the minimal amount you should bid per park?

What were the consequences of the code of hammurabi : What were the consequences of the Code of Hammurabi for ancient society, and how does this system of justice compare to modern American laws

User Account

All Pages