Our employees earn points (demerits) for behaviors we do not wish to occur. For example, if they are late to a shift, they receive .5 points, no call no show for a shift get 2.0 points, etc. We sum up their points over a six month rolling time period. If they receive 5 points or more within the six month period, we need a report to warn the employee they are in danger, we print it and they sign that they received a warning that they are in danger of losing their job. We have another warning at 7.0 points or above. At 8.0 points they are fired. This report can be printed and given to HR. The reports should list what infractions occurred on what dates. It also should list the future date (6 months from then) when the infraction and point will fall off.
Every day an employee enters each employees infractions from a drop down list and it auto populates the point assigned to that infraction.
We should have numerous sorting options. Ability to pick individual employees to see their overall history and their rolling 6 month history. Ability to see a list of all employees and their current point totals.
I am attaching an excel sheet we use, so you can get an idea of what we do. We have SQL servers and we also have Microsoft Access. We are not married to any software language. It could be web based, with login credentials and our users could click on names, allowing for expansion of the employees history, etc. Please present your idea of what software you would use, and what it would take to maintain the software over time.
Please provide your cost to do the project, and future costs for any revisions we want made. Also give us a length of time you will fix bugs as they occur (warranty period)