Excel Spreadsheet on Project Monitoring
Do you need academic writing help with your homework? Let us write your papers.
Order a Similar Paper
Order a Different Paper
Chapter 10 Project Monitoring: Problems:
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowNOTE: 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
