| BUS472 Unit 5 Assignment Template |
| | | Instructions: Fill in the only the yellow fields: |
| | 1. S-Curve |
| | | | Develop a simple S-curve for the expected cumulative budget expenditures for this project: |
| | | | | | | | Duration (in days) |
| | | | | | | | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 |
| | | | | Activities | | | 4 | 8 | 12 | 20 | 10 | 8 | 6 | 2 |
| | | | | Cumulative | | | 4 | 12 | 24 | 44 | 54 | 62 | 68 | 70 |
| | | | | | Hint: Highlight the table above and insert a line chart within the yellow space below, ensure to only show cumulative data |
| | 2. Earned Value Management |
| | | A. Using the plan data in the table below, complete the table by calculating the cumulative planned and cumulative actual monthly budgets through the end of June. Complete the earned value column on the right. Assume the project is planned for a 12-month duration and $250,000 budget. |
| | | | Activity | | Jan | Feb | Mar | Apr | May | Jun | Plan | % Complete | | | | Earned Value |
| | | | Staffing | | 8 | 7 | | | | | 15 | 100% |
| | | | Blueprinting | | | 4 | 6 | | | | 10 | 100% |
| | | | Prototype | | | | 2 | 8 | | | 10 | 70% | | | | 7 | | | <Hint this one is computed for you |
| | | | Full Design | | | | | 3 | 8 | 10 | 21 | 67% |
| | | | Construction | | | | | | 2 | 30 | 32 | 25% |
| | | | Transfer | | | | | | | 10 | 10 | 0% |
| | | Monthly Plan: | Monthly Plan: | | | | | | | | | | | | Total: |
| | | Cumulative: |
| | | Monthly Actual: | | Monthly Actual: | 10 | 15 | 6 | 14 | 9 | 40 |
| | | Cumul. Actual: | | Cumul. Actual: |
| | | B. Using the above data, calculate the following values: |
| | | | Schedule Variances |
| | | | Planned Value |
| | | | Earned Value |
| | | | Schedule Performance Index |
| | | | Estimated Time to Completion |
| | | | Cost Variances |
| | | | Actual Cost of Work Performed |
| | | | Earned Value |
| | | | Cost Performance Index |
| | | | Estimated Cost to Completion | | | | | | | | | | <- Ensure to express as 000,000 |
| | 3. Interpreting Project Performance |
| | | A. You have collected the following data based on three months of your project’s performance. Complete the table. |
| | | | | | EV | | Cumul. EV | | AC | | Cumul. AC | | CPI | | Cumul. CPI |
| | | | January | | 30,000 | | | | 35,000 |
| | | | February | | 95,000 | | | | 100,000 |
| | | | March | | 125,500 | | | | 138,000 |
| | | B. How is the project performing after these three months? |
| | | C. Is the trend positive or negative? |
| | 4. Project Closeout Critique |
| | | Go to https://pmhut.com/wp-content/uploads/2008/03/project-closeout-document.pdf. Critique the content of this closeout form. What information would you suggest adding to the form to make it a more comprehensive closeout document? |
jacknael
BUS472_U5_Assignment_Excel_Template.xlsx
