Page 1 of 2
Inventory Overage

Posted:
Tue Feb 09, 2021 10:58 pm
by bobs96
We have 3 stores that all had an overage in the last 2 years. 19k, 14k, 9k.this year. We are on Dealertrack. I have checked manufacture posting. Vendor posting, all stocking groups are relieving inventory, miss posted credit to inventory, cost changes, price updates, all gp% in range, no free parts except some antifreeze/brake fluid from techs, no over costed parts..... Any ideas. I find it hard to believe that if this was a posting error that it has happened at all 3 stores as an overage. I want to think it's a set up issue but cannot find anything that stands out. No help from dealertrack. I consider myself pretty knowledgeable with dealertrack and the accounting side and have ran numerous reports looking for something to stand out. Stumped. Please Help. Thanks.
By the way yes I did find some miss posted GL Entries but those are easy to find if posted to parts account.
Re: Inventory Overage

Posted:
Wed Feb 10, 2021 1:23 pm
by Zep33
appreciation not posted to the GL?
Re: Inventory Overage

Posted:
Thu Feb 11, 2021 6:11 pm
by FixedManager
An inventory variance is normal (1%+/-) but when looking at it as a dollar value you could be a hero or a zero. In other words, if you and I drop a $100.00 bill we are knocking over people to get it, Jeff Bezos probably keeps walking. Don't tax your resources to find it if you are within guides as there are many reasons for PAD/GL variances. I do this for a living and have a single spaced document stating the possible reasons for variance and it is four pages in length. As Zep said, appreciation/depreciation is one of the biggest. It needs to be handled in a specific manner during a short open window as soon as price tapes run. This is exacerbated by some manufacturers that are running daily price tapes now.
Re: Inventory Overage

Posted:
Fri Feb 12, 2021 9:02 pm
by olepartsguy
I usually have a inventory of about 400,000 and so far 2 years in a row my overage was around 40,000.
Re: Inventory Overage

Posted:
Fri Feb 12, 2021 9:24 pm
by PartScott
olepartsguy wrote:I usually have a inventory of about 400,000 and so far 2 years in a row my overage was around 40,000.
10% is pretty big.
Re: Inventory Overage

Posted:
Sat Feb 13, 2021 1:13 am
by Fixed Ops Mgr
FixedManager wrote:An inventory variance is normal (1%+/-) but when looking at it as a dollar value you could be a hero or a zero. In other words, if you and I drop a $100.00 bill we are knocking over people to get it, Jeff Bezos probably keeps walking. Don't tax your resources to find it if you are within guides as there are many reasons for PAD/GL variances. I do this for a living and have a single spaced document stating the possible reasons for variance and it is four pages in length. As Zep said, appreciation/depreciation is one of the biggest. It needs to be handled in a specific manner during a short open window as soon as price tapes run. This is exacerbated by some manufacturers that are running daily price tapes now.
I am wondering if I could get a copy of that 4 page document that you have?
Re: Inventory Overage

Posted:
Sat Feb 13, 2021 7:35 pm
by satguy
I would like a copy also.
Re: Inventory Overage

Posted:
Mon Feb 15, 2021 3:08 pm
by nbeckhart23
May I get a copy as well please. Thank you
Re: Inventory Overage

Posted:
Tue Feb 16, 2021 3:25 pm
by MSInventory
I'd like one please. Thanks
Re: Inventory Overage

Posted:
Wed Feb 17, 2021 1:15 pm
by yosvany
i would like a copy as well