iPE Help

How are the Hours (or Costs) per Month Calculated from a Distribution Curve?

Updated on

Labor hours or other direct costs are distributed between the WBS, task or assigned resource start and end dates based on the curve selected above. The costing model which is generated has a granularity of a calendar month, in other words on figure of hours and costs per calendar month. So how are the hours (or costs) distributed given that tasks can start in the middle of a month and do not necessarily start on the 1st and end on the last day of the month?  The actual distribution works as follows - example data based on 1000 hrs of labor assigned to a task starting 1/15/19 and ending 3/25/19 and using a stepped distribution curve of 10%, 40%, 40%, 10% is also included:

  • The total number of normal working days between the start and end dates, excluding holidays and weekends, is calculated. In our example there are 50 working days between Jan 15th and March 25th (no holidays during that time)
  • This total number of days is divided equally into the number of distribution periods, four in this case two each with 10% and two each with 40%. In our example 50 days is divided evenly into four periods of 12.5 days each
  • The total effort is divided based on each distribution profile %. In our example the first period (12.5 days) has 10% of the total or 100 hours, the second period (day 12.5 to 25) has 40% or 400 hours, the third period also has 400 hours and the final period has 100 hours
  • Each period is mapped to a calendar month. If it falls entirely inside one calendar month the distributed hours are added to the total for that month. If the period in question spans more than one month then the effort is divided up evenly between the two or more months based on the number of working days from that period in each calendar month. In our example:
    • The first period runs from Jan 15th to half way through Jan 31st so that's 100 hours in January
    • The second period runs from half way through Jan 31st until Feb 18th so one 25th (0.5 / 12.5 of 400 hrs =16 hrs) falls into January while the remainder (400 - 16 = 384 hours) falls into February
    • The third period runs from Feb 19th until half way through March 7th so that's 8 days in February and 4.5 days in March. 8/12.5 of 400 hrs = 256 hrs are added to February and the remainder (400 - 256 = 144 hrs) falls into March
    • The last period runs from March 7th until March 25th so the final 100 hrs are entirely allocated to March
  • The days allocated to each calendar month are added up and costed based on the labor rate applicable to your company's fiscal year for the calendar year and month in question. In our example the total hours for January would be 116 hrs, in February 384 + 256 = 640 hours and in March 244 hours. Despite the bell distribution curve being "even" the fact that the task starts in mid-January and ends almost at the end of March explains why March's calendar month allocation of effort is more than double that of January.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article How are Labor Costs Distributed over Time using a Curve
Next Article How are Labor Costs Distributed over Time Manually