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