Inventory Overage

bobs96
Posts: 5
Joined: Wed Oct 29, 2014 9:06 pm

Inventory Overage

Post 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.
Zep33
Posts: 1410
Joined: Wed Mar 19, 2008 12:00 am

Re: Inventory Overage

Post by Zep33 »

appreciation not posted to the GL?
FixedManager
Posts: 216
Joined: Wed Feb 21, 2007 12:00 am

Re: Inventory Overage

Post 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.
olepartsguy
Posts: 419
Joined: Thu Feb 27, 2020 4:37 pm

Re: Inventory Overage

Post 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.
PartScott
Posts: 767
Joined: Tue Sep 22, 2015 1:50 pm

Re: Inventory Overage

Post 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.
Fixed Ops Mgr
Posts: 192
Joined: Sat Feb 25, 2017 5:32 pm

Re: Inventory Overage

Post 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?
satguy
Posts: 28
Joined: Wed Oct 19, 2005 12:00 am

Re: Inventory Overage

Post by satguy »

I would like a copy also.
nbeckhart23
Posts: 136
Joined: Thu Sep 18, 2014 5:35 pm

Re: Inventory Overage

Post by nbeckhart23 »

May I get a copy as well please. Thank you
MSInventory
Posts: 115
Joined: Mon Apr 03, 2017 9:45 pm

Re: Inventory Overage

Post by MSInventory »

I'd like one please. Thanks
"The worst thing a Parts Manager can do is to fall in love with his parts."
yosvany
Posts: 26
Joined: Thu Jun 25, 2020 6:14 pm

Re: Inventory Overage

Post by yosvany »

i would like a copy as well
Post Reply