EVM Example Week$7.$xlsx

Directions $-$ Step $1$: using the data from the Excel spreadsheet $($EMV$\_$Example$\_$Week$7)$

Calculate the forecasting parameters through the end of the project $($i$.$e$.,$ EAC, ETC,

VAC$)-$ use Formula #$3$ from the slide deck to calculate EAC

Question #$1$: Based on your estimates, what would be your recommendations for

managing the project at the end of Week $7?$

Directions $-$ Step $2$: Update the Excel spreadsheet with the information through Week

$12($see table from the lecture slide$)$

Calculate the performance value metrics $($i$.$e$.,$ CV$,$ SV$,$ CPI, SPI, EAC$)$ for Week $12$

Present the EV performance graph for Week $12$

Question #$2$: How do the project's final weeks compare with the recommendations

you made at the end of Week $7?$

Submit a $2-$page summary of your answers to Questions $1$ and $2$

Page $1=$ EV performance graph and answer to Question #$1$

Page $2=$ Updated EV performance graph and answer to Question #$2$

Submission requirements:

Written in full sentences

Proper spelling and grammar

Times New Roman $12-$point font, $1"$ margins, double$-$spaced

Grading $(25$ points total$)$

Copy of EV performance graph and narrative response to Question #$1(10$ points$)$

Copy of updated EV performance graph and narrative response to Question #$2(10$

points$)$

Narrative follows formatting requirements $(5$ points$)$

$[$Project Title$]$

$[$Company Name $/$ Logo$]$

Earned Value Analysis Report

Prepared By: Alex Zylka

Date: $\frac{11}{8}\frac{?}{23}$

For Period:

Week $7$

Summary:

$[$Use this space to write a brief summary or to record specific observations or notes$]$

Planned Value $($PV$)$ or Budgeted Cost of Work Scheduled $($BCWS$)$

$\backslash$table$[[$WBS$,$Task Name,TBC$,1,2,3,4,5,6,7,8,9,10,11,12],[1\mathrm{.}1,$Task $1,3500,1000,500,2000,,,,,,,,,],[1\mathrm{.}2,$Task $2,4200,,500,800,900,2000,,,,,,,],[1\mathrm{.}3,$Task $3,4500,,,700,2000,1000,800,,,,,,],[1\mathrm{.}4,$Task $4,3300,,,200,600,1000,1500,,,,,,],[1\mathrm{.}5,$Task $5,3000,,,,,700,500,1000,800,,,,],[1\mathrm{.}6,$Task $6,6700,,,,,,,,700,2000,1000,2000,1000],[,0,,,,,,,,,,,,],[,0,,,,,,,,,,,,],[,0,,,,,,,,,,,,],[,0,,,,,,,,,,,,],[,0,,,,,,,,,,,,],[,0,,,,,,,,,,,,],[$Insert new rows above this one$],[,$Total Budgeted Cost,$25200,1000,1000,3700,3500,4700,2800,1000,1500,2000,1000,2000,1000],[,$Cumulative Planned V$,$lue $($PV$),1000,2000,5700,9200,13900,16700,17700,19200,21200,22200,24200,25200]]$

Actual Cost and Earned Value

Project Performance Metrics

Cost Variance $(CV=EV-AC)$

Schedule Variance $($SV $=$ EV $-$ PV$)$

Cost Performance Index $($CPI $=$ EV$/$AC$)$

Schedule Performance Index $($SPI $=$ EV$/$PV$)$

Estimated Cost at Completion $($EAC$)$

Esitmate to complete $($ETC$=$EAC$-$AC$)$

Variance at Completion $($VAC$=$BAC$-$EAC$)$

$\backslash$table$[[-275,850,1335,1270,-1075,1570,6270],[-475,800,185,-1380,-4175,-1530,3070],[0\mathrm{.}66,1\mathrm{.}44,1\mathrm{.}29,1\mathrm{.}19,0\mathrm{.}90,1\mathrm{.}12,1\mathrm{.}43],[0\mathrm{.}53,1\mathrm{.}40,1\mathrm{.}03,0\mathrm{.}85,0\mathrm{.}70,0\mathrm{.}91,1\mathrm{.}17],[38400,17550,19483,21107,27986,22592,17593]]$

$\backslash$table$[[-275,850,1335,1270,-1075,1570,6270],[-475,800,185,-1380,-4175,-1530,3070],$

$[0\mathrm{.}66,1\mathrm{.}44,1\mathrm{.}29,1\mathrm{.}19,0\mathrm{.}90,1\mathrm{.}12,1\mathrm{.}43],[0\mathrm{.}53,1\mathrm{.}40,1\mathrm{.}03,0\mathrm{.}85,0\mathrm{.}70,0\mathrm{.}91,1\mathrm{.}17],[38400,17550,19483,21107,27986,$

$22592,17593]]$

Updated EV and AC for Weeks $8$ Through $12$

Tips on Completing the Assignment:

Step $1$: Take a screenshot of the graph and calculate the EAC, ETC, and VAC, then answer Question $1.$

Step $2$: Enter the data for Weeks $8$ through $12($see below$).$

Step $3$: Take a screenshot of the graph and compare the BAC with the EAC $($i$.$e$.,$ look at the VAC$)$ at week

$12$ and then answer Question $2.$

NOTE: Don't forget to update the cumulative AC and EAC in the Actual Cost and Earned Value

rows in the Report tab.$[$Project Title$]$

$[$Company Name $/$ Logo$]$

Earned Value Analysis Report

Prepared By: Alex Zylka

Date: $\frac{11}{8}\frac{?}{23}$

For Period:

Week $7$

Summary:

$[$Use this space to write a brief summary or to record specific observations or notes$]$

Planned Value $($PV$)$ or Budgeted Cost of Work Scheduled $($BCWS$)$

$\backslash$table$[[$WBS$,$Task Name,TBC$,1,2,3,4,5,6,7,8,9,10,11,12],[1\mathrm{.}1,$Task $1,3500,1000,500,2000,,,,,,,,,],[1\mathrm{.}2,$Task $2,4200,,500,800,900,2000,,,,,,,],[1\mathrm{.}3,$Task $3,4500,,,700,2000,1000,800,,,,,,],[1\mathrm{.}4,$Task $4,3300,,,200,600,1000,1500,,,,,,],[1\mathrm{.}5,$Task $5,3000,,,,,700,500,1000,800,,,,],[1\mathrm{.}6,$Task