Personnel Availability Report
The Personnel Availability Report allows users to easily spot overloaded or underutilized personnel. It displays one row per person showing the normal work hours into the future (by day, week, month, or year) and subtracts the forecasted hours to show how much time each person has “available” during the period. To aid in spotting trends, problems, or opportunities, the report cells are color coded so that when a person has available time, the cell is green and the intensity of the green gets deeper based on the percentage of their time that is available. When a person has little available time, the cell is white. If the forecasted hours exceed the normal work hours, a negative number is displayed and the cell turns yellow with deeper shades indicating higher levels of overtime. Once the system determines a person will need to work more than 50% of their normally scheduled hours in the period, the cell is turned red to highlight the problem.