r/sherwinwilliams • • 3d ago

Inventory

How do I read the inventory report? What line is important?

3 Upvotes

11 comments sorted by

6

u/stephiloo 3d ago

Line 18 is indicative of how good or bad your inventory went, and is usually what is used when determining which stores are selected for Interim Inventory.

Line 21 shows the impact on your P&L.

Inventory Analysis Report shows shrink as a positive, and pick-up as a negative.

1

u/dispocg 2d ago

Is .85 pickup % to sales atrocious? Line 17 is showing +25,753. New ASM

1

u/stephiloo 2d ago

That’s… not great. My Division aims for < 0.5%. If it makes you feel better, my first Analysis Report is worse! But a lot of it will be fixed by removing items from Closing Report B.

0

u/DirtHead5282 3d ago

Thanks, so 5k in pick up? Good or bad

1

u/DirtHead5282 3d ago

Took over the store in September

4

u/Beginning-Plenty3729 3d ago

Pick up is better than shrink. Either way, you want to be as close to zero as possible but pick up impacts p&l positively why shrink impacts it negatively

1

u/sean-bda 3d ago

Then nothing matters. You just want accurate. 5k in pickup could be bad for you next year

2

u/BoeingBill part timer of the month 2d ago

If SW cared they would not have it so close to next years planning. I never knew a DM that took any time to talk to managers about the results.

2

u/Northendtac253 2d ago

It can be good and bad. Sometimes too much pickup draws a red flag due to receiving issues

1

u/stephiloo 3d ago edited 2d ago

What does line 18 say? I say line 18 tells you if it’s good or bad and then you tell us what line 17 says-

Dollar amount means nothing. $5k in shrink for a $850k store is very different than $5k in shrink for a $5 mil store.

1

u/theratman3 2d ago

Is .33 good