Start End Rate Revenue
0 7 50.0% 50000
7 14 20.0% 20000
14 21 15.0% 15000
21 28 10.0% 10000
28 35 5.0% 5000

total 100000

Based on a 5 week run or 35 days

Start date Expected sales Month 30/09/2012 31/10/2012 30/11/2012

Days 0 15 20

17/10/2012 100000 Revenue 0 72143 27857

15 days revenue recognition is calculated
50000 7 first seven days generates
20000 7 second week generates
2142.86 1 day of Third week generates

72142.86 15 days difference between start date and month end date

Hi All,
I am hopeful someone can help with a formula that i can apply to a range of products over 24 months to reflect when revenue will be due. The products run for 5 weeks (35 days). I need the formula to determine the number of days of revenue to be recognised and then apply those days to the tiered table above, where the first week will generate 50% of revenue and so on. In the example above the 15th day will generate 1 day of revenue at 15%. with the following month just picking up what is left

Thanks