Calculate %work done compared to work bid

Question:     

 Can Milestone be set up where I can show the percent of work that has been done compared to how many hours I originally bid?

 

Answer:

Here's an example of how this can be accomplished.  In the schedule below:

  • Hours Bid is the duration of the task, using a Duration SmartColumn.  

  • Hours Worked is entered and represents the actual number of hours worked.  

  • Percent complete (% Comp.) is adjusted for each task by entering the percent of work done in the column.

  • % Duration Used is calculated by dividing Hours Worked by Hours Bid.

  • The Indicator column subtracts Duration Used from % Comp.  Red indicates more work has been done than what has been accomplished.  Green indicates percent of the job complete is greater than the % of hours worked, meaning good progress is being made on the job.

 


 

 

Related topics

Duration on a summary bar

Duration values for single milestones

Earliest and latest supported dates supported by Milestones

 

 

 

 

 

 

Applies to Milestones Professional:      2019        2021        2023        2025

 

 

 

 

      

The fast easy way to schedule your projects:  Milestones Software by KIDASA Software, Inc. www.kidasa.com

Copyright © 2025 KIDASA Software, Inc. All rights reserved.