You are the project manager of a project developing a new product for your company. The project has seven tasks, each with a finish$-$to$-$start relationship. Below is project baseline information indicating the planned schedule and budgeted cost of each task. The Product Release $1\mathrm{.}0$ row is the summary task that summarizes the tasks below it$.$

Planned

Task Name $\%$ Complete Baseline Duration Baseline Start Baseline Finish Baseline Cost

Product Release $1\mathrm{.}00\%240$ days $01/08/2412/07/24$ $$295,000\mathrm{.}00$

Requirements $0\%30$ days $01/08/2402/16/24$ $$30,000\mathrm{.}00$

Design $0\%60$ days $02/19/2405/11/24$ $$70,000\mathrm{.}00$

Proof of Concept $0\%30$ days $05/14/2406/22/24$ $$45,000\mathrm{.}00$

Build Product $0\%45$ days $06/25/2408/24/24$ $$60,000\mathrm{.}00$

Test Product $0\%45$ days $08/27/2410/26/24$ $$60,000\mathrm{.}00$

Deploy Product $0\%30$ days $10/29/2412/07/24$ $$30,000\mathrm{.}00$

Product Release Complete $0\%0$ days $12/07/2412/07/24$ $$0\mathrm{.}00$

The project is currently in the middle of the execution phase and the date is June $22$th$.$ The information in the chart below provides the schedule and cost information to$-$date and the Gantt chart reflects the project's current progress and estimated completion dates.

Actual

Task Name $\%$ Complete Actual Duration Actual Start Actual Finish Actual Cost

Product Release $1\mathrm{.}050\%122$ days $01/08/24$ NA $$147,000\mathrm{.}00$

Requirements $100\%35$ days $01/08/2402/23/24$ $$32,000\mathrm{.}00$

Design $100\%60$ days $02/26/2405/17/24$ $$70,000\mathrm{.}00$

Proof of Concept $90\%27$ days $05/20/24$ NA $$45,000\mathrm{.}00$

Build Product $0\%0$ days NA NA $$0\mathrm{.}00$

Test Product $0\%0$ days NA NA $$0\mathrm{.}00$

Deploy Product $0\%0$ days NA NA $$0\mathrm{.}00$

Product Release Complete $0\%0$ days NA NA $$0\mathrm{.}00$

image.png

Excel Workbook Requirements

Include the first and last name$($s$)$ of the student$($s$)$ that prepared the workbook in the file name $($ex$.$ Earned Value Kathy Majeske.xlsx$)$

Use appropriate formulas to calculate the following Earned Value measures:

SV

SPI

CV

CPI

EAC

ETC

BAC

VAC