Employee Hours Estimation
- Mahendra Meesa
- Helen Ramsay
The application automatically calculates the hours for each current month using the hours from the 2 prior months.
How to Calculate Estimated Hours?
Hours from past two previous months divided by the number of days in that month multiplied by the number of the days in the current month.
The following table has the actual hours for January – March and April’s hours (also the Incident Rate) are estimate. These hours were calculated by using February as the example. Our system will calculate the hours for each current month (April) using the hours from two prior months ago (February). The process to create those hours is as follows:
- During the month of February, there are 28 days.
- 469,528 Hours / 28 Days = 16,769 Hours per Day
- February’s per day hours of 16,769 will be used to estimate the hours for April.
- April has 30 days. Each day the system would add 16,769 hours. On April 30th, the monthly total would be estimated at 503,070 hours (16,769 * 30).
Assumptions:
- Yellow Color indicates Hours are estimated.
- Daily Estimation based on that day Prior 2 month Data (i.e., in the above example February).
- Once the hours are inputted then estimation stops.
- Current Month Hours cannot be edited.
Related articles
Related content
© 2018 ProcessMAP Corporation, All Rights Reserved Confidential, may not be disclosed without the express permission of ProcessMAP Corporation