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.