1. Milestone Logic Calculations
The Overall Completion Date Variance for a Milestone not completed is based on the effort/duration to complete the task as per the schedule baseline start and end dates displayed as a % score to be completed per day. For completed milestones the variance calculation based on the baseline end date – date milestone completed and percentage updated to 100%
Milestone Calculation – Based on today’s date 27/12/2018 | |
Formula: | Sample Calculation: |
Step 1 – Calculate planned daily % 100% milestone duration Milestone duration = total number of calendar days between milestone start and end dates | //// |
Step 2 – Calculate planned days to complete 100% - % completed = days to complete Daily planned % (step 1) | 100-75 / 16.7% per day = 1.5 days effort required |
Step 3 - Calculate total days delay (end date – today’s date) + (days to complete step 2) = days late | (05/11 – 27/12/2018) = 52 days delayed
52 delayed days + 1.5 days = 53 days late |