1. Complete earned value metrics for each line item of the project.
2. Use the metrics to create indexes for cost and schedule.
3. Explain what the metrics mean in terms of the overall health of the project.

 

Activity	Start	Planned Duration	Actual Duration	Plan Date	Actual Date	Difference	Budget	Actual	Difference
Call Center Stations
Call center stations inventory	3/1/20	14	14	3/15/20	3/15/20	0	$2,100.00	$2,100.00	$0.00
Call center layout-new	3/15/20	15	18	3/30/20	4/2/20	3	$   4,500.00	$   5,400.00	$900.00
Call center stations breakdown	4/2/20	8	13	4/10/20	4/15/20	5	$   2,400.00	$   3,900.00	$1,500.00
Call center stations pack	4/10/20	5	20	4/15/20	4/30/20	15	$   1,500.00	$   6,000.00	$4,500.00
Call center stations move	4/30/20	10	10	4/20/20	5/10/20	20	$   2,000.00	$   2,000.00	$0.00
Call center stations install	5/10/20	9	15	5/1/20	5/25/20	24	$1,800.00	$3,000.00	$1,200.00
Office Furniture & Equipment Move
Inventory furniture	3/15/20	15	15	3/30/20	3/30/20	0	$1,350.00	$1,350.00	$0.00
Inventory equipment	3/30/20	11	11	4/10/20	4/10/20	0	$6,435.00	$6,435.00	$0.00
Create office layout	4/10/20	5	5	4/15/20	4/15/20	0	$2,925.00	$2,925.00	$0.00
Dissassemble	4/15/20	5	7	4/20/20	4/22/20	2	$2,925.00	$4,095.00	$1,170.00
Pack	4/22/20	9	9	5/1/20	5/1/20	0	$5,400.00	$5,400.00	$0.00
Move	5/1/20	14	16	5/15/20	5/17/20	2	$8,400.00	$9,600.00	$1,200.00
Install	5/17/20	3	8	5/20/20	5/25/20	5	$1,800.00	$4,800.00	$3,000.00
Wi-Fi
New site survey	3/10/20	5	5	3/15/20	3/15/20	0	$1,250.00	$1,250.00	$0.00
Develop requirements	3/15/20	15	15	3/30/20	3/30/20	0	$5,325.00	$5,325.00	$0.00
Vendor search	3/20/20	21	21	4/10/20	4/10/20	0	$2,100.00	$2,100.00	$0.00
Vendor selection	4/20/20	10	13	4/30/20	5/3/20	3	$2,550.00	$3,315.00	$765.00
Design layout	4/15/20	5	15	4/20/20	4/30/20	10	$450.00	$1,350.00	$900.00
Order Wi-Fi equipment	4/30/20	1	5	5/1/20	5/5/20	4	$250.00	$1,250.00	$1,000.00
Install Wi-Fi system	5/5/20	10	13	5/15/20	5/18/20	3	$850.00	$1,105.00	$255.00
Test Wi-Fi system	5/18/20	7		5/25/20	5/25/20	0	$3,500.00
Station Upgrade
Wireless card selection	3/30/20	21	21	4/20/20	4/20/20	0	$12,600.00	$12,600.00	$0.00
Order wireless cards	4/20/20	11	11	5/1/20	5/1/20	0	$5,500.00	$5,500.00	$0.00
Install PC wireless cards	5/1/20	14	18	5/15/20	5/19/20	4	$11,200.00	$14,400.00	$3,200.00
Load software	5/19/20	6		5/25/20	5/25/20	0	$1,200.00
Test wireless PC	5/25/20	5		5/30/20	6/2/20	3	$3,000.00
Call Center Software
Install software	5/25/20	10		5/15/20	5/30/20	15	$5,850.00
Test software	5/3/20	27		5/30/20	6/5/20	6	$15,795.00
Software training	6/5/20	4		6/1/20	6/10/20	9	$2,340.00
Trial run	6/10/20	5		6/15/20	6/17/20	2	$750.00
Cutover to new software	6/17/20	13		6/30/20	6/30/20	0	$1,950.00
Business System Software
Install software	5/25/20	5		5/30/20	6/2/20	3	$5,875.00		$5,875.00
Test software	6/13/20	2		6/15/20	6/15/20	0	$2,350.00		$2,350.00
Software training	6/17/20	3		6/20/20	6/23/20	3	$3,975.00		$3,975.00
Trial run	6/24/20	6		6/30/20	6/30/20	0	$7,050.00		$7,050.00
Cutover to new software	7/12/20	3		7/15/20	7/18/20	3	$3,525.