I've hit a road block on how I can put what I have into a calculation that works. Simply I am trying to work out the "value" of each company that we have on my companies books. The information I want to put in:
Time spent on company (minutes) Time spent on paid work (minutes(can assume a value of £45 per hour for this work) Income from the company (£ and monthly) Priority - value of 1-7
The logic:
1) A client that is giving us, say arbitrarily £500 a month is twice as important as one that is giving us £250 a month.
2) I would expect a priority 1 client to give 50% more hassle than a priority 2, and a priority 2 50% more than a priority 3. The priority should have a weighting
No idea where to start :(