Project Earned Value Calculation Period

1 2 3 4 5 6 7 8 9 9 9
Weeks in 4 week increments
Activities 1 to 4 5 to 8 9 to 12 13 to 16 17 to 20 21 to 24 25 to 26 27 to 30 30 to 34 34 to 38 38 to 42 Totals
Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total %  Total Earned  Total % 
Value Complete Value Complete Value Complete Value Complete Value Complete Value Complete Value Complete Value Complete Value Complete Value Complete Value Complete
1 1. Drone Delivery system for Pharma product
1.1 Initial Planning with Wilmont
1.1.1 Requirement meetings & Sign off dea $     3,080.00 70% $     1,320.00 30% $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        4,400.00
1.1.2 Project Chatter Statement approval $     3,600.00 90% $        400.00 10% $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        4,000.00
1.1.3 Risk management plan & Mitigation $        500.00 100% $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $           500.00
1.1.4 Fund & Resource allocation $        825.00 50% $        825.00 50% $        1,650.00
1.1.5 Legal compliance  $        1,300.00
$               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.2 DroneTech internal allocation and Approvals $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.2.1   Internal meeting with Drone engineers and IT engineer $        550.00 50% $        550.00 50% $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        1,100.00
1.2.2   Resource and fund distribution $        220.00 40% $          330.00 60% $           550.00
$                  ‐ 
1.3 Drone Customization $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.3.1   Procurement of Drone part $               ‐ $               ‐ $     43,498.20 60% $     28,998.80 40% $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $      72,497.00
1.3.2 Procurement of Spare parts $               ‐ $               ‐ $                 ‐ $     10,162.50 50% $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $      20,325.00
1.3.3 Assemble drone $               ‐ $               ‐ $       1,462.50 25% $       1,462.50 25% $       1,462.50 25% $       1,462.50 25% $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        5,850.00
1.3.4 Change the color and logo of drone $          525.00 50% $          525.00 50% $                 ‐ $        1,050.00
1.3.5 Quality check and test of drone basic function $       1,125.00 50% $       1,125.00 50% $        2,250.00
$               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.4 Drone flight operation customization $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.4.1   Flight within give area and path $        540.00 10% $     1,080.00 20% $        5,400.00
1.4.2  New drone clamp  to hold custom package $               ‐ $               ‐ $           350.00
1.4.3 customize delivery packaging $               ‐ $               ‐ $       1,350.00 20% $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        6,750.00
1.4.4 Quality check and test of customized flight operation $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        3,500.00
$                  ‐ 
1.5 DroneTech Delivery system customization $                  ‐ 
1.5.1   Existing IT Delivery system needs to be customized so that it 
looks like a part of Wilmont
$               ‐ $        250.00 10% $          250.00 10% $       2,000.00 80% $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        2,500.00
1.5.2   Online & Smartphone request enablement $               ‐ $               ‐ $          562.50 50% $          562.50 50% $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        1,125.00
1.5.3 Integration with Wilmont Online order system $               ‐ $               ‐ $                 ‐ $          900.00 50% $          900.00 50% $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        1,800.00
1.5.4 Wilmont customer Data security, reliability, integrity check $               ‐ $               ‐ $                 ‐ $                 ‐ $       1,000.00 50% $       1,000.00 50% $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        2,000.00
1.5.5 Validate and Test the changes $               ‐ $               ‐ $                 ‐ $                 ‐ $          675.00 30% $       1,575.00 70% $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        2,250.00
$               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.6 Wilmont’s enhanced online order entry $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.6.1  Wilmont should enhance the online order entry process $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.6.2  Integration with DroneTech Delivery system $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.6.3 Validate and Test the changes $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
$               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.7 User Training $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.7.1  Training to Pharma store managers  $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        1,800.00
1.7.2 Train staff for use of new Drone flight operation $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        1,800.00
$               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.8 System Integration and Validation $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.8.1 Integrate the system $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        2,250.00
1.8.2 Validate the system as a whole $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        2,250.00
$               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.9 Release  $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.9.1 Provide Wilmont with new customized Drone $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        1,300.00
1.9.2 Provide Wilmont required documentation and support of 
running Drone and IT system $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $           200.00
Dron Maintain and repair work $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $        4,240.00
1.10 Project Closure $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $                  ‐ 
1.10.1 Find the learning $               ‐ $               ‐ $                 ‐ $                 ‐ $                 ‐ $                 ‐ $              ‐ $                ‐ $                 ‐ $                 ‐ $                 ‐ $           275.00
Total Earned Value  $     9,095.00 $     4,645.00 $    47,453.20 $    44,611.30 $       5,687.50 $       5,162.50 $              ‐ $               ‐ $                ‐ $                ‐ $                ‐ $    116,654.50

Period 1 2 3 4 5 6 7 8 9 10 11 12
Total Actual Cumulative Cost 9875 15040 62493.2 97442 103129.5 108292 108292 108292 108292 108292 108292 216584
Total Cumulative Plan Cost $  13,195.00 $  17,450.00 $  96,522.00 $  101,772.00 $  107,459.50 $  112,622.00 $  118,697.00 $  123,772.00 $  129,293.00 $ 133,438.00 $  135,637.00 $ 271,274.00
Earned Value $     9,095.00 $     4,645.00 $  47,453.20 $     44,611.30 $       5,687.50 $       5,162.50 $                ‐ $                ‐ $                ‐ $               ‐ $                ‐ $               ‐
SPI 0.689276241 0.266189112 0.491630924 0.438345517 0.052926917 0.045839179 0 0 0 0 0 0
CPI $            0.92 $            0.31 $            0.76 $               0.46 $              0.06 $              0.05 $                ‐ $                ‐ $                ‐ $               ‐ $                ‐ $               ‐
 Earned Value
Earned Value Total Actual Cumulative Cost Total Cumulative Plan Cost

 $300,000.00

 $250,000.00

 $200,000.00

 $150,000.00

 $100,000.00

 $50,000.00

 $‐
1 2 3 4 5 6 7 8 9 10 11 12

SPI & CPI Chart
50000 1

45000 0.9

40000 0.8

35000 0.7
CP = 1 Right Budget
CP > 1 Under Buget
30000 CP < 1 Over Buget 0.6

25000 SP = 1 On Schedule 0.5

15000 0.3

10000 0.2

5000 0.1

0 0
1 2 3 4 5 6 7 8 9 10 11 12

Period Earned Value SPI CPI Expon. (Period)