It seems like you're trying to do a lot of unnecessary work, someone has to be dropping the ball somewhere. Where do you even get the time to do something like this? The only place you realistically have assortments is softlines and that should only be a couple aisles in the backroom that you have to search. You'll have a few down HBO/Pharmacy, but those shippers have dates plastered all over them. If the backroom team isn't stoing boxes with the date outwards, they need to be coached until they do so. In the end, there is no one report that lists what you're asking for because a report like that isn't necessary if people do what they are supposed to do. Be proactive and find out who isn't doing their job properly, causing all of these assortment boxes to build up and fix that, instead of reactive and wasting a bunch of time each week visiting all your assortment boxes in the back.
I agree. It's a lot of unnecessary work which I've pointed out. For any good it might do, it's minimal in contrast to the time spent doing it. I've instructed to them what needs to be done to avoid the whole thing entirely, but they don't seem to like to hold their overnight process accountable. Unfortunately I'm just a team member and this directive comes straight from my Store Team Leader, so I just do what I am told and try to manage. The issue of STOing boxes with their dates out isn't really an issue to me provided people are pushing the ones that need to be pushed because the others should be getting pulled with the set. I'm just lucky they actually locate stuff on a shelf. The number is assortments isn't alarming at least to me. We're a fairly high volume store and considering we get assortment boxes for set dates months prior to set date, it's not uncommon. Thanks for the response though.
I guess I'm not sure what you're trying to do, and why. Are you backroom? Salesfloor? TM? TL?
If the goal is to keep assortments from getting lost in the BR, there are better ways to go about it. Try to get the backroom to keep assortments in certain specific areas instead of any available shelf. Have them get in the habit of writing the set date in sharpie on the box near the pick label, so you can see right away that someone checked it and when it sets.
There is no report that does what you want, because it doesn't seem necessary in the first place.
I am a backroom team member. The assortments are kept in specific areas...as much as they can be at least. When I first started doing this audit, I would write the dates on the boxes, but I found that to be silly and unproductive considering most already had the dates on them in pretty bold print. In this situation, it's really just a matter of trying to get the overnight process to push assortments already set and if it all comes back, break them open and backstock them instead of backstocking the entire box. Our dayside backroom knows this is the general rule, so they have no issues (at least when I am there, I can't speak for early morning).
My team will only backstock assortments that aren't past their date. TLs of their areas should be aware of sets and ETL-SF/GE will send e-mail weekly for assortment report. I will audit areas that commonly have assortments and pull anything past their date down and set it aside for the TL that owns the block.
If you have 200 assortments, something probably isn't right. You don't need to send out a weekly email for that, start purging the BR. Softlines is the only thing that gets in our way, and it's because our softlines team is garbage.
Which is exactly how it should be, unfortunately you can only really watch the people you're around. E-Mail wise, I don't know what they send out as I don't have access to that. The audit you're describing is exactly what I do, I pull up the assortment report, find the set date for each assortment box located and write them down. Then whatever is already set without a future date, I physically go and pull it and leave it for my Team Lead to push the next time he's in. 150-200 assortments isn't uncommon IMO considering we get items that won't be set for months, we're a high volume store last I checked...but that may have changed.
Appreciate all the replies from everyone with suggestions. Unfortunately when it comes to fixing whatever issues may be, that's not within my authority as much as I've protested against it. My STL wants it done and feels it's a priority, so I get it done...I've told them it's a big waste of time, but if they insist on me wasting my time...then so be it. I was just looking for quicker way to do it...I figured Spot may have been smart enough to implement a method for actually pulling up some sort of report with set dates rather than having to look them all up individually. Thanks again everyone.