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.
Inventory Overage
Re: Inventory Overage
appreciation not posted to the GL?
-
- Posts: 216
- Joined: Wed Feb 21, 2007 12:00 am
Re: Inventory Overage
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.
-
- Posts: 419
- Joined: Thu Feb 27, 2020 4:37 pm
Re: Inventory Overage
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
10% is pretty big.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.
-
- Posts: 192
- Joined: Sat Feb 25, 2017 5:32 pm
Re: Inventory Overage
I am wondering if I could get a copy of that 4 page document that you have?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.
Re: Inventory Overage
I would like a copy also.
-
- Posts: 136
- Joined: Thu Sep 18, 2014 5:35 pm
Re: Inventory Overage
May I get a copy as well please. Thank you
-
- Posts: 115
- Joined: Mon Apr 03, 2017 9:45 pm
Re: Inventory Overage
I'd like one please. Thanks
"The worst thing a Parts Manager can do is to fall in love with his parts."
Re: Inventory Overage
i would like a copy as well