# Excel Spreadsheet on Project Monitoring

I’m studying for my Management class and need an explanation.

Chapter 10 Project Monitoring: Problems:

NOTE: Do this work on an MS Excel Spreadsheet – Include the Questions.

Exercise 1: Find the schedule and cost variances for a project that has an actual cost as month 22 of \$540,000, a scheduled cost of \$523,000, and an earned value of \$535,000.

Show work and Answers on an Excel spreadsheet:

Exercise 2 : A sales project at mon5 had an actual cost of \$34,000, a planned cost of \$42,000, and a value completed of \$39,000. Find the cost and schedule variances and the CPI and SPI.

Show work and Answers on an Excel spreadsheet:

Exercise 7 : Given an activity in an advertising project whose planned cost was \$12,000 but actual cost to date is \$10,000 so far and the value completed is only 70 percent, calculate the cost and schedule variances. Will the client be pleased or angry? Explain.

Show work and Answers on an Excel spreadsheet:

Optional Reference:

Earned Value Management: http://www.hyperthot.com/pm_cscs.htm (Links to an external site.)

Earned Value, Clear and Simple: http://www.projectsmart.co.uk/docs/earned-value.pdf