Question: How do you make a project cost control excel spread sheet and how does it look? 1- In the spreadsheet theres a row....reflecting the total
How do you make a project cost control excel spread sheet and how does it look?
1- In the spreadsheet theres a row....reflecting the total months for your project (i.e., M1, M2, M3, M4, etc.)
2- In the spreadsheet theres a row...titled BCWS.
3-In the spreadsheet theres a row titled CUM BCWS. This row with the cumulative budget as the months progress (e.g. if BCWS for M1 was $10K....then CUM BCWS for M1 is $10K...and if BCWS for M2 was "$10K...then CUM BCWS for M2 is $20K...etc.)
4- In the spreadsheet theres a row titled BCWP
5- In the spreadsheet theres a row title CUM BCWP. Populate entries for the cumulative earned value for each month
6-In the spreadsheet theres a row titled ACWP. Populate entries for the actual costs that you are simulating for each month up to (and including) the month where you are taking the status snap shot.
7- In the spreadsheet theres a row titled CUM ACWP
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
