Earned Value - Wilmont Pharmacy Drone Case.pdf

Project Name: Wilmont's Pharmacy Drone Project

Revision Number: 00 Revision Date: 14/02/2020

Project Earned Value Calculation

Activities

1 2 Weeks in 5 week increments 1 to 5 6 to 10 Total Earned Total % Total Earned Total % Value Complete Value Complete

1.1 Initiating 1.1.1 Develop Scope and Plan 1.1.2 Engage Stakeholders 1.1.3 Funding 1.1.4 Preparing List of Difficulties

$ 6,120.00 $ 612.00 $ 6,220.00 $ 18,360.00

1.2 Planning 1.2.1 Gathering information regarding Drone 1.2.2 System Design 1.2.3 Cost Estimate 1.2.4 Approvals

$ $ $ $

1.3 Construction Phase of One Drone 1.3.1 Gathering Team 1.3.2 Educating Manpower 1.3.3 Renting / Gathering Tools and Equipment 1.3.4 Complete Coding 1.3.5 Complete Construction

100.00% 10.00% 100.00% 100.00%

3 11 to 15 Total Earned Total % Value Complete

$ 10.00% $ $ $

16 to 20 Total Earned Total % Value Complete

612.00 -

-

$ $ $ $

5,280.00 6,900.00 3,960.00 4,060.00

$ $ $ $ $

-

$ $ $ $ $

-

$ $ $ $ $

1.4 Testing of Drone 1.4.1 Flight Test 1.4.2 Integrity Test 1.4.3 Component Test 1.4.4 Area Covering Test

$ $ $ $

-

$ $ $ $

-

$ $ $ $

1.5 Construction Phase of Other Three Drones 1.5.1 Complete Coding 1.5.2 Complete Construction

$ $

-

$ $

-

1.6 Testing of Other Three Drones 1.6.1 Flight Test 1.6.2 Integrity Test 1.6.3 Component Test 1.6.4 Area Covering Test

$ $ $ $

-

$ $ $ $

1.7 Delivery 1.7.1 Packing and Packaging 1.7.2 Documents Regarding Design 1.7.3 User Manual and Application 1.7.4 Certificates

$ $ $ $

-

1.8 Training 1.8.1 Handling of Drone Flight 1.8.2 Maintenance / Troubleshooting of Drone

$ $

1.9 Warranty and Payment 1.9.1 Time 1.9.2 Accessories 1.9.3 Payment

$ $ $

Total Earned Value

$ 31,312.00

Period Total Cumulative Plan Cost Total Cumulative Actual Cost Total Earned Value

1 2 3 4 5 6 7 8 9 $ 31,618.00 $ 52,736.00 $ 66,520.40 $ 77,654.80 $ 85,639.20 $ 102,273.60 $ 128,813.20 $ 141,352.80 $ 175,920.00 $ 31,900.00 $ 53,380.00 $ 67,280.00 $ 79,080.00 $ 87,130.00 $ 103,780.00 $ 130,530.00 $ 143,730.00 $ 178,130.00 $ 31,312.00 2081200.00% $ 13,662.00 $ 11,012.00 $ 7,862.00 $ 16,512.00 $ 26,662.00 $ 12,662.00 $ 35,424.00

$ $ $ $

$ 10.00% $ $ $

-

612.00 -

26 to 30 Total Earned Total % Value Complete

$ 10.00% $ $ $

612.00 -

$ 10.00% $ $ $

612.00 -

9

36 to 40 Total Earned Total % Value Complete

$ 10.00% $ $ $

612.00 -

41 to 45 Total Earned Total % Value Complete

$ 10.00% $ $ $

1,224.00 -

Totals

$ 20.00% $ $ $

6,120.00 6,120.00 6,220.00 18,360.00

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

5,280.00 6,900.00 3,960.00 4,060.00

-

$ $ $ $ $

-

$ $ $ $ $

-

$ $ $ $ $

-

$ $ $ $ $

-

$ $ $ $ $

1,600.00 2,950.00 3,500.00 5,000.00 5,200.00

$ 50.00% $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

2,250.00 5,000.00 5,200.00 2,500.00

$ 100.00% $

-

$ $

-

$ $

13,400.00 13,600.00

$ 33.33% $ $ 33.33% $

-

$ $ $ $

2,250.00 5,000.00 5,200.00 2,500.00

-

$ $ $ $

2,160.00 2,740.00 2,740.00 1,910.00

$ $ $ $ 100.00% $

-

$ $ $ $

5,200.00 -

$ $ 100.00% $ $

$ $

-

$ $

-

$ $

-

$ 13,400.00 $ -

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $ $ $

-

$ $

-

$ $

-

$ $

-

$ $

-

$ $

-

-

$ $ $

-

$ $ $

-

$ $ $

-

$ $ $

-

$ $ $

-

$ 11,012.00

8

31 to 35 Total Earned Total % Value Complete

5,200.00

$ 13,662.00

100.00% 100.00% 100.00% 100.00%

-

$ 10.00% $ $ $

7

$ $ $ $ $

$ 20,812.00

1,600.00 2,950.00 3,500.00 5,000.00 -

$ $ $ $

612.00 -

6

21 to 25 Total Earned Total % Value Complete

$ $ $ $

100.00% 100.00% 100.00% 100.00%

612.00 -

Period 5

4

$

2,250.00 2,500.00 2,500.00

7,862.00

100.00% $ 50.00% $ $ 100.00% $

2,500.00 -

$ 16,512.00

100.00% $ $ 13,600.00

2,250.00 3,333.33 5,200.00 1,666.67

$ $ $ $

1,666.67 833.33

-

$ $ $ $

2,160.00 2,740.00 2,740.00 1,910.00

$ $

-

$ $

-

$ 16,150.00 $ 16,150.00

100.00% $ 100.00% $

16,150.00 16,150.00

$ $ $

-

$ $ $

-

$ $ $

100.00% $ 100.00% $ 100.00% $

600.00 700.00 600.00

$ 26,662.00

100.00% 66.67% 100.00% 66.67%

$ 12,662.00

100.00% 100.00% 100.00% 100.00%

$ $ $ $

600.00 700.00 600.00

$ 35,424.00

$ 175,920.00

Status:

Chart Title $200,000.00

$180,000.00

$160,000.00

$140,000.00

Total Cost

$120,000.00

$100,000.00

$80,000.00

$60,000.00

$40,000.00

$20,000.00

$1

2

3

4

5

6

Period Total Cumulative Plan Cost

Total Cumulative Actual Cost

Total Earned Value

7

8

9