This assignment will use the Time Sharing System from “How to Build Work Breakdown Structures”
(Week 1 → Readings). The customer has signed off on the project and it is now ready to launch. Your
team includes eight resources made up of Project Manager (that is you!), Analysts, Developers, and
Testers. The project is planned to start on July 11th, finish on November 30th, and cost $301,602.
Once into execution, you will see some changes (surprises) come up that affect the schedule. Since
earned value is calculated from data within the schedule1
, that whole picture will change as well. The
Excel sheet is pre-loaded with data from schedule snapshots taken at six different points during project
execution.
NOTE: There are two parts to this assignment.
Part 1 – Enter Earned Value data into Microsoft Excel
Part 2 – Answers to Questions in Microsoft Word
Open a Microsoft Word document. Copy the following questions and paste them into the document,
then answer the following questions.
Question 1: Explain the relationship between PV and EV for Schedule Performance, i.e., when one is
higher (or lower) than the other, how does Schedule Performance change?
Question 2: What performance factor does SPI affect? Explain what SPI of more (or less) than one
means.
Question 3: Explain the relationship between EV and AC for Cost Performance. When one is higher (or
lower) than the other, how does Cost Performance change?
Question 4: What performance factor does CPI affect? Explain CPI of more (or less) than one means.
Project Execution
(Individual assignment)
Project Execution Summer 2023 Page 3 of 4
For the following questions, use formula notation. Do not explain the answers in text form.
Question 5: What formula did you use to calculate CV?
Question 6: What formula did you use to calculate SV?
Question 7: What formula did you use to calculate CPI?
Question 8: What formula did you use to calculate SPI?
Question 9: What formula did you use to calculate EAC?
Question 10: What formula did you use to calculate ETC (assuming that cost variance is atypical)?