The calculation method for estimated hours cost
Professional profiles accept ranges of values. For example – A “Junior Engineer” as an employee (in-house) can have assigned a cost of $30/hr from 1st to 15th January, and then $35/hr from 16th January onwards. To estimate the cost for a task to be completed between 1st and 30th January, the system will automatically multiply the assigned hours by the hourly rate, for each day. For example:
Task: Draw a Turbine
Junior Engineer Assigned: Cairo Martell
Total hours spent: 80hr
Hour distribution: Uniform, 4hr/day, 20 days
- 1st-15th January: 20hr - 16th-30th January: 20hr
Hourly cost of this task:
- 1st-15th January: 20hr x $30/hr = $600 - 16th-30th January: 20hr x $35/hr = $700 Total cost of this task = $1,300
Purchases for this task: $2,000
- Total cost of this task: $3,300
To be able to perform the calculations aforementioned, each task should have a defined starting and ending date. Therefore, one would be able to determine which hourly rate should apply, based on the professional profile. Since ITM Platform allows for tasks to have neither of the two dates, the calculations will be done according to:
- If both starting and ending dates are provided, the previous methodology will be applied, calculating the hourly cost every day.
- If only either the starting or ending date is provided, the hourly rate of the current day will be applied on the total hours spent in a given task.
- If neither date is provided, the standard cost at the calculation time and date will be applied on the total hours spent in a given task.
The aforementioned will also be applied to provider rates.
The calculations for estimated hour cost can be found in project list (task-list), services, tasks and activities, details in the Commitment section of each task, budget section of a given project or service, tables, P&L reports and API methods.
Other related articles: Resource Planning.