DealersEdge Professional Forums

Ok guys and gals,
As I stated not long ago. I am a NEWBIE to GM Parts Management. Every Month my boss has me print off a report - Inventory Value List - Dealer.
This month I did it and he comes back with questions I can not answer. So here I am. The report says my % SP value of Inventory is 44. So to me that means 44 % of my inventory is covered by RIm. And my % non SP value of inventory is 56. So to me that means 56 percent of my inventory is not covered by RIM. Am I correct? If I run this report over a years span the numbers are pretty consistent across the board. My boss wants to see the percentages reversed. How Do I go about doing that. I have been trying to get a handle on the RIM situation But I am still learning. When special parts are ordered, They are billed ASAP. Most of the time Billed when ordered. I keep outside purchases to a min from places like NAPA, Oreilly ect.
What Am I doing wrong? any help would be greatly appreciated.

Basically I need to know what percentage of my inventory is RIM protected and What percentage is not. What report do I need to pull that shows this. Thanks

Look at the parts that are not on rim. Check to see what obsolescence and look at sales of the parts to see what percentage of your non-rim parts are moving. You will have to start weeding those non-rim parts out through your return reserve. Also check your RIM, your only required that 85% rim you need to stock. I don't know having more of that is wise, because it really only benefits GM.

My loyalty is in the 90% area. I don't understand the issue

Your boss has a valid point and here are a few things for consideration.

You inherited this from another manager and if you start a correction project today you will begin to see fruits of your labor in 90 days. Depending on your inventory makeup it could take 9-24 months for a full correction.

1) Create a report, Excel preferred, of all parts not RIM protected. Review it and look for trends and opportunities to revise stocking levels. From this report you will gain insight as to the makeup of unprotected items. Many normal stock items are not protected.
2) You will need to create and review reports on a regular basis to identify parts categories to give a perspective as to the non-protected items. Items such as tires, oil, chemicals, accessories, non-factory parts will not have protection but are sold daily and may have protection from other sources. Non-returnable, damaged, painted, bad packaging are a few things that need to be written off and destroyed.
3) The biggest question is; Does your special order system work? Is your Service department flooding your parts department with obsolescence?

This is only a shortened version of what you will need to do but I hope it will get you thinking about steps necessary to put it in perspective and gain your bosses support. This is key to getting where you want to be as some tough decisions will need to be made. Good Luck, this project will be a great learning experience.

If you are on CDK you can add state codes and Strada codes to your report, that is one way of doing it.
Also in rim you can see the dollar value and all of the part numbers of what is protected, there are 2 ways of checking it.

yosvany wrote:If you are on CDK you can add state codes and Strada codes to your report, that is one way of doing it.
Also in rim you can see the dollar value and all of the part numbers of what is protected, there are 2 ways of checking it.

Is RIM code available as a field to report on?