spreading percentages across days of the week

[ab9788]

i have a file that takes a weekly sales number and breaks it down to daily sales figures so stores have a daily sales target to hit. Each day of the week (sun-sat) gets a percentage assigned to it based on sales volume of that day. When a store closes, i have to figure out how to take that days percentage away and spread it across the remaining days. I have tried a few different ways but always come up a little short or a little over 100%. does anybody know how i would do this?

 

[Kamolga]

If I understand what you mean, you want the E5 on Tuesday when you recieved actual of Monday

[/URL][/IMG]

to reach the weekly objective at its end. You can drag it to the right and overwrite it with your actuals.

 

[ab9788]

sorry, i maybe need to explain it better. assume the store is open 7 days a week and the sales target for the week is 20K. i use a template to break that 20K down to a daily figure, so each day has a % assigned to it, so the 20K would be multiplied by the % below for each day and that would be the daily sales target.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
0.112389	0.138559	0.131818	0.134257	0.136572	0.16573	0.180676

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

now assume that the store is no longer going to be open on saturday and sunday, so i need to take the % allocated to those days and spread it among the 5 days the store will be open. i dont want to just take the sum of saturday and sunday and divide by 5 and then add that to each day because it wont be reflective of what the store is capable of on that day.... for instance, monday through thursday is around .13 but friday is around .16 so when spreading the amounts, friday should got a portion more than the rest of the days.

 

[Kamolga]

The formula in C5 respect the prorata of the days left (mo to fri)

[/URL][/IMG]