Am not much of a stats guy so looking for help from you experts.
We have total sales data for around 100 stores for 12 months. The stores need to close for remodeling for 2 months; all the stores cannot be closed in the same month. There are few months were all the stores do good. In fact mostly the sales trend is uniform.
Any suggestion on best way to determine which stores should be closed when.
Currently, we have a very basic approach: determine the lowest 15% sales for a 2 month period (say Jan, Feb) and eliminate them, and then move to the next 2 month period...and continue.
Any advice? Any software , formula that will help?
Appreciate your help!