We have an outlet base of circa 350 to 400 sales points. We supply 2 different magazine titles. These outlets cover a large area of mainland Spain. These outlets have several layers of information, delivery agent, Magazine title, accounting type, Weekly sales volume and outlet type. We need to be able to map these to give both a visual view of these outlets and a report of the outputs. We need to be able to slice and sort the data by the attached hierarchy.
We have up to 15 delivery agents
We have two different magazine titles. ( 3 categories are required, one for each title and one for both)
Our outlets are classed by two different accounting types
We classify the outlets by 5 different levels of sale.
We classify our outlets by 5 different types.
We require a system that allows us to map our outlets by one or more of the above categories simply by selecting one or more of the categories. The project delivery is a working program that allows us to add / remove outlets and change delivery agent, accounting type and sales volume.
At the simplest level we would want to see all the outlets plotted on a map at the most complex it would be outlet by sales agent, by magazine title, by accounting type, by sales, by outlet type and all variations in between.
For any of the criteria we would want to be able to sort by one of the types.