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

If Statement ? Seperate cost over years of project 1
How to distribute/spread/map cost of project across different year 3
Sum If formula 3
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT 9
Normal distribution curve 2
Excel : how do I sum costs if the they relates to the same period 1
Sorting the cells of a formula causes the formula to not work 3
NEED FORMULA TO PICK UP TOP OF A COLUMN WHEN CERTAIN CRITERIA MET 3

Top