Forum Discussion

ambrandt2000's avatar
ambrandt2000
Copper Contributor
Feb 02, 2023

What formula(s) could I use to allocate a 50 per store per day average sales increase?

I have the data of daily sales volume per day for each store (there are 1170 stores). The average is ~280 sales per day per store. I'm trying to see what it would look like across stores if we increased sales + 50/store/day on average. Some stores average sales are ~20 versus others are ~1060 & so I'm trying to figure out how to create a "what-if" analysis that would allocate this increase appropriately based on current averages / %s of sales volume.  How many sales per day would each store need to average to meet this 50 per store per day increase?

Resources