Logo of Value Edge
Ad-Hoc Modelling
Value Edge's team takes a very pragmatic approach to do ad-hoc modeling in MS Excel, vba, access to offer business solutions to clients. Our clients often have need to build quick tools to do some data management or analytics that does not fall under a specific service line. One example of such a deliverable is given below:
The Challenge:
Our client wanted to do a pharmacy stock planning for their key products. The primary questions were:
- Which are the most important pharmacies where stocking needs to be done on priority?
- Can we categorize these pharmacies in deciles of priority?
- What is the quantity of stocking and supply that would be required for the pharmacies?
- What does that mean for the client in terms of planning distribution to regional distributors?
Our Deliverable:
Value Edge developed an access based tool to do the pharmacy stock planning. The model enabled the client to produce account-specific and targeted stocking recommendations for key trade channel customers, which align with the business dynamics and geographic distribution of retail outlets.
Model and Data Filters:
The Launch Stock Plan model provided account-specific stocking recommendations based on data filters that provide a significant level of specificity as to early Rx volume and stocking requirements. Filters employed geographic overlay filters including:
- Target physicians
- Target patient population
- Manufacturer sales representative
- Analogue Rx volume movement within retail pharmacy outlets
Output for Trade Channel Accounts:
The model produced reports that the client provided to their retail accounts to map out sales volume forecasts and stocking volume.
Some illustrative screen-shots for the model are below:
Asia
418-419 International Trade Towers
Nehru Place
New Delhi 110019
INDIA
email: info@valuedgeindia.com
Europe
Paris, France
email: info@valuedgeindia.com
North America
Boston
email: info@valuedgeindia.com