Project Visibility Calculations


Show all your calculations on this page. 
Perform the calculations described below and put the current weeks data on the home page.
Then beneath your calculations, summarize the data by week in a table or chart.
 

Days ahead of Schedule

Simply refer to the tasks planned in the detailed schedule and report days ahead of schedule.  If you are behind schedule, report it as negative days.
 

Percent of Resources Used

Team X planned resource utilization is 15 hrs / person / week or 90 hours.  Project total = 90 hrs * 10 weeks = 900 hrs.
  Week 1 Week 2 Week 3 ...           Week 10 Total
Joe 8.25 13.0 12.0                
Sue 12.5 11.5 10.25                
Bill 9.75 10.0 11.5                
Sam 11.5 12.25 12.0                
Ted 10.25 9.25 10.0                
Total 52.25 56.0 55.75                
% of planned 58% 62% 61%                
Obtain the actual hours for each person from their Time Log.

To Date Resources Used

  Week 1 Week 2 Week 3 ...              Total
To Date
Actual
52.25 108.25 164                
To Date
Planned
90 180 270 360 450
540
630
720
810
900
 900
To Date
%Planned
10
20
30
40
50
60
70
80
90
100
100

 For week 3 you would report 164 / 900 vs 270 / 900, i.e., 18% / 30%


Batting Average

This is a measure of how successful your team is at completing action items on time.
Action  Items
Week 1 Week 2 Week 3 ...              
Completed
on time
40 45 51                
To Date
40
85
136








Due
45 47
53
               
To Date
45
92
145








%ontime
88
92
93








 For week 3 you would compute  136 / 145 and report 0.93



You must update the document history table every time you update this page.

Document History
 
Date  Author  Change