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

Copper Contributor
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?
1 Reply

@ambrandt2000 

You could use

 

=(280+50)/280*current_sales_per_store