Benchmark Homework: Cost and Earned Value Management
Description
The purpose of this homework is to establish a baseline, record actual project data, and utilize earned value management data to measure project performance and communicate necessary project adjustments to stakeholders.
Part I
Review the "Project Execution" section of Chapter 3 in the textbook. Follow the steps provided to guide your baseline process and the subsequent status of you plan.
1) Open the Microsoft Project "Global Treps Project Rev4" file and set a baseline. To set the baseline, first select the project tab. Then select set baseline. Then click OK.
2) Turn on the Tracking Table.
3) Update the following tasks with the revised actuals specified below.
4) Update the Resource Sheet to reflect the revised labor costs specified below.
5) Save the Microsoft Project file as "Global Treps Project Rev5."
Revised Actuals:
1) Finalize project team - 100% complete
2) Develop project charter - 100% complete
3) Develop scope statement - 100% complete
4) Develop and refine other plans - 100% complete
5) Evaluate current systems - 100% complete - Make the "Actual Start" date the "Current Date" and the "Actual Finish" date 10 days later than the "Current Date."
6) Conduct research for income mechanism into Global Treps - 30 days - 100% complete
7) Evaluate current system - 10 days - 100% complete
8) Define requirement - 22 days - 100% complete
9) Define user requirements - 23 days - 100% complete
10) Define content requirements - 29 days - 100% complete
11) Define system requirements - 33 days - 100% complete
12) Define server owner requirements - 20 days - 100% complete
13) Define specific functionality - 33 days - 100% complete
14) Define risks and risk management approach - 21 days - 100% complete
15) Develop project plan - 32 days - 100% complete
16) Brief web development team - 3 days - 100% complete
Revised Resource Labor Costs:
1) Project Manager (you): $120 per hour
2) Website Developer (Bobby): $125 per hour
3) System Test Engineer and Event Runner: Vietnam (Kim): $55 per hour
4) Support Team Manager and Event Runner: India (Ashok): $55 per hour
5) Event Runner: Ethiopia (Alfreda): $55 per hour
Part II
Using the information from "Global Treps Project Rev5," you must evaluate the seriousness of the threats to project success based upon data from the Earned Value Table and Earned Value Report. Complete the steps below to access the data.
1) Using the "Global Treps Project Rev5" you created in Part 1, view the Earned Value table by selecting the "Select All" button, then right-click your selection, select "More Tables," and double-click on "Earned Value." Reveal all the columns. Be sure the entire number shows in each column. Add a column for the cost performance index (CPI) and schedule performance index (SPI).
2) View the earned value report by clicking the "Report" tab, and then click "Costs" followed by the "Earned Value Report."
3) Create a Word document and insert a screen shot of the earned value table and the earned value report.
4) Using the earned value table and the earned value report, answer the following questions in the Word document after the screenshots.
Questions:
1) What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project?
2) Is the project ahead of schedule or behind schedule? Is the project under budget or over budget?
3) Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?
4) Use the SPI to estimate how long it will take to finish this project.
Part III
Create a management report to discuss where the project stands in terms of the triple constraint: meeting scope, time, and cost goals at a specific point in time. Use the revised information from the Microsoft Project earned value dashboards and reports to communicate the project status to project stakeholders. Be sure the comments address each of the questions below and provide any additional information required in the template.
1) Are there issues that need to be escalated?
2) Is it acceptable to do nothing and simply proceed?
3) Should the project be terminated?
4) Based on your evaluation of the threats to the project, how should you proceed?
Format your homework according to the following formatting requirements:
(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
(2) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Global-Treps-Project.rar