Monday, April 16, 2012

fun with numbers - sometimes

We recently saw a report that lists the lines we sell and our purchases from the CARQUEST DC ( Toronto ) and their 'average' sale .... cute ... some interest.  They are looking at what jobbers are under supporting some lines ( we guess ) ... but we can also see more data .... take the Warehouse sales and calculate the % sales by line ... then apply to the GROUPS ... groups is something we have been working with for a few years ... here is our first stab at groups


25 Group
accessories
battery
bearing-seals
belts +
brakes
chassis
chemicals
cores
dorman type
electrical
emmissions
engine
equipment
exhaust
filters
fuel
heat-cool
import
lighting
misc
oil
P B E
plugs
struts
tools
trailer
welding
wipers
zz-obsol


Then a few weeks back we started to talk with Vince in TOR DC about his support for a SAP report for group sales ) the USA has a report - but would need work to make it Cdn ) ... and suggested a slimmed down 10 groups ....


10 Group 25 Group
Battery battery
cores cores
IIFM import
IIFM trailer
IIFM welding
Liquids chemicals
Liquids oil
Misc misc
Misc zz-obsol
On Car accessories
On Car dorman type
On Car lighting
On Car wipers
P B E P B E
Tools equipment
Tools tools
Under Car bearing-seals
Under Car brakes
Under Car chassis
Under Car exhaust
Under Car struts
Under Hood belts +
Under Hood electrical
Under Hood emmissions
Under Hood engine
Under Hood filters
Under Hood fuel
Under Hood heat-cool
Under Hood plugs



Here is sample chart for store ( or is it the Warehouse - buy me a beet and I will tell you ) ....



This kind of data seems to raise more questions than it  answers ...  but such is life





No comments: