Forum Discussion
Spread project value evenly accross project duration
Essentially i have a table similar to below:
| Project | Start | End | Value | Revenue Shape |
| ABC | 01/02/2020 | 01/04/2022 | $100,000,000.00 | Flat |
| ZYX | 01/01/2018 | 01/02/2029 | $310,000,000.00 | Flat |
| MNO | 01/06/2021 | 01/07/2024 | $75,000,000.00 | S-Curve |
| TUV | 01/10/2019 | 01/02/2025 | $150,000,000.00 | S-Curve |
Flat - Evenly distributed revenue per month
S-Curve - Variable, but essentially a normal distribution of revenue across duration.
I need to create a monthly revenue line chart from the above data.
My first assignment is to assume all the "Revenue Shape" is flat, and to evenly distribute all revenue on a line chart.
Second assignment is to figure out a standard "S-Curve" or normal distribution for forecasting purposes, and to implement this where the "Revenue Shape" equals S-Curve.
I cannot seem to get anything to work, any advice would be appreciated.
Hi,
You may download my PBI file from here. I changed the start and end dates to check my result.
Hope this helps.
16 Replies
- lbendlin
Super User
Is the end date (month) inclusive or exclusive?
For the normal distribution - what is the value for the first and last month?
It would be inclusive, they are usually not the first of the month, but that's just what i put in the table above.
There is literally no defined values to start or end, I just know that some contract types would more likely have an "S-Curve" revenue shape, but I would like to have an "outlook" of revenue.
Would really just need to be some basic standard we apply like over 12 months it could be:Jan 2% Feb 5% Mar 7% Apr 10% May 12% Jun 14% Jul 14% Aug 12% Sep 10% Oct 7% Nov 5% Dec 2% - lbendlin
So the initial value would be 0.02 .
But your sample table only has 12 values. You said inclusive, which would mean 13 months for your examples. Sooo - which one is it?
- Ashish_Mathur
Hi,
I can help you get the monthly revenue projection where the revenue shape is flat of all projects. Would you be OK with that starting point?
- Ashish_Mathur
If the start and end dates are not the first of the month, then should the revenue of that month be recognised on proportionate basis or should the revneue still be recognised for the full month?
