Please find the only TOP sub dept over stock (as of Jul 31) vs Jul target as below.
We are also providing you the list of overstock which the concept to calculate is
- Actual stock (by each items) excluded BAS
- Target stock by item (due to normally we don't have specific target by item) , then to be a guideline to see stock vs target, we use the target of each department (DOH) that identify by Merchandise x historical sales 30 days of each item to be identify target stock of each item
(Any sub dept which total sub-dept are already lower will not in a list, we focus only TOP sub-dept). Please note that we consider actual DOH vs DOH target as mentioned, we haven't ignored the current promotion / next promotion items.
So, please consider it to identify appropriate action plan (some may be good stock (Active status) but too much when compare with your target) so you may consider to do promotion in any brochurs or ads etc. Details are as K.Vitsanu's mail.
This is just for your information to consider action plan for some items ie. select some of them to do promotional items if you want , any questions if have please feel free to contact us.