Heard from Ian and confirmed by Raleigh that version 53 ( due in August ) we will be able to delete junk part numbers .... what about that ....
The junk can finally go ....
a group of CARQUEST jobbers writing about good and poor things in Exploris - and how to make it better and more productive tool for the CARQUEST Auto Parts store. This is WHI's Nexpart computer system with a CARQUEST name
Tuesday, March 27, 2012
Monday, March 26, 2012
More than a typewriter & adding machine ....
When Exploris first came out we worried that it might only be a 'typewriter' and a 'adding machine' ...as what does the JV ( company owed side of stores ) really need? The JV side pulls the A/R out and pushes it thru Oracle ... what else they do -- who knows....
BUT -- what about us Independent Jobbers -- how do we plan and manager our business .... here is a good example -- name me a report or screen that calls up a customer and gives us a good and SIMPLE scan of his purchases ... noting were he does above or BELOW average on purchases ....
One - lets work with product groups .... group all BRAKES into one bucket ... and so on ... we use these buckets below for review on sales by LINES ... but they could also be grouped for sales analysis for specific customers ... helping us see what we need to work on ...
accessories Total
battery Total
belts + Total
brakes Total
buy outs Total
chassis Total
chemicals Total
dorman type Total
electrical Total
emmissions Total
engine Total
equipment Total
exhaust Total
farm Total
filters Total
fork lift Total
fuel Total
heat-cool Total
import Total
lighting Total
marine Total
misc Total
obsolete Total
oil Total
P B E Total
paint Total
plugs Total
special Total
struts Total
tools Total
trailer Total
welding Total
wipers Total
zz-obsol Total
Grand Total
If any of your readers have an idea --love to hear it --- really need some more innovation in Exploris ( NexPart by eBay nee WHI )
BUT -- what about us Independent Jobbers -- how do we plan and manager our business .... here is a good example -- name me a report or screen that calls up a customer and gives us a good and SIMPLE scan of his purchases ... noting were he does above or BELOW average on purchases ....
One - lets work with product groups .... group all BRAKES into one bucket ... and so on ... we use these buckets below for review on sales by LINES ... but they could also be grouped for sales analysis for specific customers ... helping us see what we need to work on ...
accessories Total
battery Total
belts + Total
brakes Total
buy outs Total
chassis Total
chemicals Total
dorman type Total
electrical Total
emmissions Total
engine Total
equipment Total
exhaust Total
farm Total
filters Total
fork lift Total
fuel Total
heat-cool Total
import Total
lighting Total
marine Total
misc Total
obsolete Total
oil Total
P B E Total
paint Total
plugs Total
special Total
struts Total
tools Total
trailer Total
welding Total
wipers Total
zz-obsol Total
Grand Total
If any of your readers have an idea --love to hear it --- really need some more innovation in Exploris ( NexPart by eBay nee WHI )
Thursday, March 15, 2012
Welcome back ?
Well - after a great 9 week vacation that took me across USA and back and an extended stay in Carlsbad, Ca ( what a town ! ) ... time to get back to work
Doing an updated data dump where we grab all the product into and import into excel - typically we separate the CQ and the X lines - but I forgot ...on the 1st store --- nice to see the system didn't crash --and all 252,000 parts came out .... but had to go back and re-do it ---as it make the excel file just TOO BIG once we add in the remaining stores ( we have 3 in total ).
Grabbing all data and dumping into excel helps us spot many kinds of problems ....
ps - --just sorted all parts with a REPLACED BY data ... and all items with qty on hand -- hmm ...between 3 stores we have $23,000 in parts that are replaced by something else ( a lot is one recent line in brakes - but it does help us identify the few stragglers )
ps- how many parts do you have in your system with a BLANK sales class - we have 197 ...some are our fault - were the system allows us to make a BAD PART # .... others are mistakes of CARQUEST
ps- How many parts do you have with a sales class or 8 or 8.0 .... either way it is a mistake = that CARQUEST has MISSED in updating the sales movement codes .... for our 3 stores -- we have a combined 20,402 ....holly cow ... similarly we have 842 parts with 1 sales movement code of X or x.0 ( e.g. 1 or 1.0 thru 7 or 7.0 ....all examples of sales movement codes been forgotten in the updating process )
ps - how many parts do you have with a sales movement class of LESS THAN ONE .... we have 4679 .... most are 0.0 which means obsolete ( of these we have 19 sku's with on hand stock .... hmmm ) but there this a variety of .9 or .1 sales movement codes that are also errors ( one assumes )
ps- ever wonder how many parts you have on hand with a 7.1 or slower movement code and no sales in 12 months and you have stock -- hope you don;t -- you will never sleep at night once you do --- damm
Doing an updated data dump where we grab all the product into and import into excel - typically we separate the CQ and the X lines - but I forgot ...on the 1st store --- nice to see the system didn't crash --and all 252,000 parts came out .... but had to go back and re-do it ---as it make the excel file just TOO BIG once we add in the remaining stores ( we have 3 in total ).
Grabbing all data and dumping into excel helps us spot many kinds of problems ....
ps - --just sorted all parts with a REPLACED BY data ... and all items with qty on hand -- hmm ...between 3 stores we have $23,000 in parts that are replaced by something else ( a lot is one recent line in brakes - but it does help us identify the few stragglers )
ps- how many parts do you have in your system with a BLANK sales class - we have 197 ...some are our fault - were the system allows us to make a BAD PART # .... others are mistakes of CARQUEST
ps- How many parts do you have with a sales class or 8 or 8.0 .... either way it is a mistake = that CARQUEST has MISSED in updating the sales movement codes .... for our 3 stores -- we have a combined 20,402 ....holly cow ... similarly we have 842 parts with 1 sales movement code of X or x.0 ( e.g. 1 or 1.0 thru 7 or 7.0 ....all examples of sales movement codes been forgotten in the updating process )
ps - how many parts do you have with a sales movement class of LESS THAN ONE .... we have 4679 .... most are 0.0 which means obsolete ( of these we have 19 sku's with on hand stock .... hmmm ) but there this a variety of .9 or .1 sales movement codes that are also errors ( one assumes )
ps- ever wonder how many parts you have on hand with a 7.1 or slower movement code and no sales in 12 months and you have stock -- hope you don;t -- you will never sleep at night once you do --- damm
Subscribe to:
Posts (Atom)