how to spread the cost of the project overtime usingexcel formula?

D

dalila hima

Hi,
How to use excel formula to spread the cost of the project knowing that its time vary from 12 months to 48 months and that it does not always follow an s curve? like the following list of data:
total cost of the project :$310135272.2

Month Percentage of Cost
1 0.6708%
2 19.0990%
3 0.0259%
4 0.0259%
5 0.0259%
6 0.0259%
7 1.1473%
8 0.6898%
9 3.5729%
10 2.9887%
11 2.9156%
12 2.3157%
13 28.4282%
14 28.2524%
15 1.0606%
16 1.3427%
17 1.2938%
18 6.1188%
so, if the number of months is 48 how can I spread those % keeping the same type of graph and the same cost of the projects ( slow progress)?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Spread Project Costs Over Months Using Bell Curve 2
MS Project. Real progress of the project, % complete 1
per use cost for resource -- spread across period? 2
How to distribute/spread/map cost of project across different year 3
Normal distribution curve 2
Sum If formula 1
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT 9

Top