INVENTORY SHORTAGE

[nbeckhart23]

I have a question has anyone in the GM world had a decrease or shortage in their parts inventory over the last year whether it be prices decreasing or anything. I just did inventory and I am coming up short I am looking into posting errors because we have had a few different people in the front office in that position. I'm just looking for ideas on where I can check if it matters I'm on CDK any help as always from this group will be helpful thank you in advance.

[PartsPlant81]

You should never have a shortage. Should always be over due to appreciation throughout the year.
You have internal issues if you are short.

[Mike Nicholes]

Two ideas for you. 1) do a monthly physical reconciliation on the bin counts for all parts selling over 20 per year; you will need to get this report from the generator or using English. If you have problems; send me an email and I'll send you the English statement to get it; free; CDK wants to charge for every special statement of these kinds.
2) go to www.partsconsulting.com and download the reconciliation and key to understanding the reconciliation. This is a monthly process that will help you spot any possible errors between parts and accounting.

Mike

[brparts]

the 2 biggest reasons the inventory would be short after 38 yrs of doing this was the accounting office and i had a service manager that i caught playing with the customer pay RO"s, he had access to the parts side and was lowering the retail price and the cost. by lowering the cost it keep the % up. there are about 20 other reasons that it could be off. these were the main ones that i found.

[X476]

I had a $20,000 shortage once, found counters had counted 30lb cylinders of R12 as 1 instead of 30. Man did I sweat for a minute or two.

[Zep33]

We did our inventory today along with our sister store. We had 151k and were $186 short. Sister store $181k $173 short. Pretty happy with that

[Mike Nicholes]

check you month end summary 'Grand Totals' on the process following the inventory. Look for variances in value, increase or decrease; your answer, if it were unannounced price changes might be shown there. This is NOT the plus and minus adjustments; these only tell you how many numbers were out of whack from the count to the computer at the time the inventory was posted. If that still puzzles, contact me directly.

Mike Nicholes