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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!