mcdavison1
New Member
- Joined
- Jul 2, 2018
- Messages
- 1
I am looking to create a burn table for some new projects in our future pipeline. I have researched S curves, bell curves, and burn rate tables, but nothing is coming up with just what I need. For example:
Project X is going to be for $80M, and will last 72 months
Project Y is going to be for $20M, and will last 24 months
Project Z is going to be for $5M, and will last 6 months
I am looking to figure how much Revenue we will burn in month 1, 2, 3, .... 72.... for each of our projects. We want to have a ramp up period, and a ramp down period. A project with 6 months is obviously going to burn at a different rate than one that will last 72 months, and I am looking to create a table that I can reference, based on the varying projects' duration. We have about 100 different projects, with different duration periods. My problem with the Bell curve, was that I needed to calc a different standard deviation for each duration period, and was really struggling with it.
Any ideas on how I can create myself a table with burn schedules out for 72 (maybe more) months? The duration will be down left, and the months across the top, I think like this below. For example, a 6 month project will burn 5% in the first month, 15% in the second month, and so on til the final 6th month. Per below:
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
Project X is going to be for $80M, and will last 72 months
Project Y is going to be for $20M, and will last 24 months
Project Z is going to be for $5M, and will last 6 months
I am looking to figure how much Revenue we will burn in month 1, 2, 3, .... 72.... for each of our projects. We want to have a ramp up period, and a ramp down period. A project with 6 months is obviously going to burn at a different rate than one that will last 72 months, and I am looking to create a table that I can reference, based on the varying projects' duration. We have about 100 different projects, with different duration periods. My problem with the Bell curve, was that I needed to calc a different standard deviation for each duration period, and was really struggling with it.
Any ideas on how I can create myself a table with burn schedules out for 72 (maybe more) months? The duration will be down left, and the months across the top, I think like this below. For example, a 6 month project will burn 5% in the first month, 15% in the second month, and so on til the final 6th month. Per below:
Duration | 1 Month | 2 Month | 3 Month | 4 Month | 5 Month | 6 Month | 7 Month | 8 Month | 9 Month |
0 Month | 0.00% | ||||||||
1 Month | 100.00% | ||||||||
2 Month | 50.00% | 50.00% | |||||||
3 Month | 25.00% | 40.00% | 35.00% | ||||||
4 Month | 10.00% | 30.00% | 35.00% | 25.00% | |||||
5 Month | 10.00% | 20.00% | 25.00% | 30.00% | 15.00% | ||||
6 Month | 5.00% | 15.00% | 20.00% | 25.00% | 25.00% | 10.00% | |||
7 Month | 4.00% | 12.00% | 17.00% | 20.00% | 20.00% | 15.00% | 12.00% | ||
8 Month | 3.00% | 7.00% | 11.00% | 12.00% | 20.00% | 20.00% | 17.00% | 10.00% |
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>