Create a Sales Team scoreboard

  • Posted
  • Proposals 4
  • Remote
  • #13158
  • Expired
Paul A.Jason T.Emanuel C.Peter A. have already sent a proposal.
  • 3

Description

Experience Level: Expert
Create a Sales Team Scoreboard

We currently have a team of 6 people selling cars.
They are a very focused team.
The reporting period is daily, monthly and annually
Their performance is monitored taking into the consideration the following factors
- A standard performance is £1350 sales profit per person, per working day.
- A working month can be anywhere between 19 and 25 days per month.
- Salesmen work to a rota, we're open 7 days a week, they work 5 days.
- We want them to achieve £1350 worth of sales revenue for every day they work.
- £1350 is the average profit per unit sold
- We don't mind if they sell 2 cars every 4 days at an average of £2700 profit per unit or 3 cars in 4 days at £1800 average profit/sales revenue per unit, the important thing is the £1350 per day worked profit.
- At the end of a month if you have worked 20 days and contributed £27,000 you would be seen to be 100% efficient. If you had contributed £54,000 you would be seen to be 200% efficient, if only £13500 you would be only 50% efficient.

The scoreboard has to show a number of things
How efficient the Salesman is at any point in time per month as a percentage and how much profit each salesman has made
How much left to do the Salesman has to do for the rest of the month
What profit per unit each Salesman is currently running at.
A per salesman cumulative tally of items we sell like, finance, GAP insurance, paint protection and warranty.
What a salesmans personal best is.
How many cars have been sold and the number of extras by category, per salesman.

There are 6 salesmen and only one score board. The scoreboard will be electronic and constantly on in the Sales Office. It is important the view that the sales team see displays in a leader boards style, so it shows who's best and worst by ranking.

In the background we would also like a summary of how the department is performing.
The overall efficiency
All the data will come from excel spreadsheets that are updated as each sale is made.

Clarification Board

    There are no clarification messages.