Jenzyme
CONSULTING ASSOCIATES
AlloVac™
Jenzyme have designed and built a specialist resource allocation model called AlloVac™.
AlloVac™ has been specially designed to help answer the questions:
-
If allowable headcount is less than the number of vacancies we have, which vacancies are the most important to fill?
-
If specialist resource or extra money is available, where should we invest first?
-
Would we do better by changing the detailing priorities on certain territories?
Traditionally, there has always been a number of complicating factors when trying to establish answers to the above questions:
-
The number of different promoted products the company has, each with a differing level of importance to the company’s success or sales strategy. A single territory has to manage all of these products.
-
A number of contributory factors combine to measure ‘Territory Potential’, or how ‘Attractive’ a territory is, for different products in different market places. However, these factors may or may not be common across different market places and they certainly have differing levels of importance.
-
How important is ‘Territory Workload’ to the decision? Is there enough ‘Work’ for a full-time representative on the territory?
AlloVac™ is a resource allocation computer model that has been designed to run in Excel™. After customisation and raw data input, clients weight the relative importance of promoted products and measures of potential / attractiveness. The model then produces an output index for individual products and a consolidated view. The result is a ranked list of the most important (highest potential/ attractiveness) to the least important (lowest potential/ attractiveness) sales territories in the company, based on weighted factors and promoted product importance.
Contents·
-
Customised AlloVac™ model in Excel™ based on initial client brief on:
-
relevant measures of “Potential”;
-
“Workload” requirements;
-
graphical representation requirements;
-
number of products / territories·
-
-
Populate AlloVac™
-
Gather and input raw data in appropriate electronic format
-
Input “potential” and “product” weightings
-
-
Production of AlloVac™ output
-
A list of ranked territories by product
-
A consolidated list of ranked territories and graphical representation
-
Logistics
Following a briefing from the Client Company, we build a customised Excel™ workbook to display the output as per the client’s initial brief. Having then populated the spreadsheet with the raw input data and the client-identified product and variable weightings, we are then able to print out the ranked territory listings and supporting visual graphical representations.
The whole project takes approximately two weeks.