spreading percentages across days of the week

ab9788

New Member
Joined
Nov 8, 2018
Messages
5
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
If I understand what you mean, you want the E5 on Tuesday when you recieved actual of Monday

Capture.jpg
[/URL][/IMG]

to reach the weekly objective at its end. You can drag it to the right and overwrite it with your actuals.
 
Last edited:
Upvote 0
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.
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Sun[/TD]
[TD="width: 64"]Mon[/TD]
[TD="width: 64"]Tue[/TD]
[TD="width: 64"]Wed[/TD]
[TD="width: 64"]Thu[/TD]
[TD="width: 64"]Fri[/TD]
[TD="width: 64"]Sat[/TD]
[/TR]
[TR]
[TD="align: right"]0.112389[/TD]
[TD="align: right"]0.138559[/TD]
[TD="align: right"]0.131818[/TD]
[TD="align: right"]0.134257[/TD]
[TD="align: right"]0.136572[/TD]
[TD="align: right"]0.16573[/TD]
[TD="align: right"]0.180676[/TD]
[/TR]
</tbody>[/TABLE]

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.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,180
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top