It wasn't long after our 3 stores went live we found that each store had an idea of what they thought was 'normal' for their actions in dealing with CASH CUSTOMERS. And within stores we had a wide diversity of expectations and actions ... to make a LONG STORY short(er) ... thru several months of action - threats - pushing and shoving ...one by one we got the store managers on line and then the counter staff --so we could TRACK cash sales ... by insisting that (almost) every cash customer be flagged in the system.
So --now what ... we have data in the system, ... gee .... this #$^&*()_ system doesn't allow us to get the data out (easily) and let us review and adjust cash customers for their proper discount level ( the assumption is the more they buy--the better the discount they should get - all other things being equal )
One way you can get the data --is to ASK .... ask Tier One staff to have then ask Tier Two staff to run you a report ... see image for the headers we used ....
If we had to do it again -- we might have asked for LAST YEARS SALES ( again - Exploris is confusing ... is every sales column always the past 12 months or is some data by Calendar year ?? ) ... we are asking the store managers to go thru the CONSOLIDATED List ( we use a logic line this ....cust #11 is store#1 billing schedule #1 ....works if you have 9 or fewer stores ..:-) ... and so on ....
The columns TAGGED TO -- is the master cash customer ( e.g.: Cust#11 ) and the sales is their data divided by 100 to get a decimal point into the data.
PS --so after 2 years on the data -- cute to see which of the 3 stores might be 'dragging their feet' the most ... can you help me decide ... ---what store do you think .... one that sells $2601 .. or $4419 ... or $20,557 ... gee ..... let me think on this .... I do have to smile that decisions made as a group of managers ( who are also partners ) ...there is always someone who resists .... love it when I get the data and can POINT FINGERS .... as the whole concept is to have data for the customer who count ... 'things that make you go hmmm'
No comments:
Post a Comment