Phase 2 of Access Program for Employee Performance Tracking.
Currently the program allows an admin to add employees, projects, tasks and products. In turn the Admin can then assign tasks to employees. Employee logins and can only see tasks assigned to them. They select task, start the task from a drop down and then can enter number of items made and number of items wasted throughout the day. They can also suspend and complete the task. The admin can generate a graph that shows items made, waste, percentage completed, etc.
After implementing this on the floor we found changes and additions that need to be added that include the following. Keep in mind that the changes and additions might require additional changes to existing tables, etc. The items listed below exist on several forms and will need to be changed throughout.. "Change this > to this"
Project > Job #
Task Name > Activity
Product > Part #
Completion > RPH (Rate Per Hour.) Average Parts Per Hour based on current parts and current hours.
Waste > Estimated Time (will be an estimate time to complete. For example 24 hours)
Target Quantity >Order Quantity (Quantity ordered by client)
Need to add....
Expected Quantity (Quantity we expect to produce)
Suspension Reason ( Need "Add Suspension Reason" in Admin Control Panel. Admin adds a "reason" . Admin needs option to set that reason to stop the work clock or continue it. Can be a tick mark or other means. Only selectable on Admin Panel.)
The program will needs to track the hours worked for a task. So when they "start" a task and "complete" a task the total hours need to be recorded. Tasks may take 4 hour or 40 hours. There is no definite set time for any task. For that reason, if a tasks is suspended for end of workday the time must stop until it started again. The suspend option is located in the status drop down. When the employee clicks suspend there needs to be a popup or other means for them to choose a reason for the suspension. The reasons in this list are created by the Admin in the "Suspension Reason" option in Admin control panel. The reason will either stop the work clock or not based on how the Admin set it up.
The Rate Per Hour mentioned earlier will need to take into account how many bolts were made on average for the time worked. For example an employee starts a task and completes in the same day. He started it at 8am, ended it at 4pm. During that time he took a 1 hour lunch and took 1 hour for setup. The lunch option stopped the clock. The setup does not stop the clock. That's 7 hours of logged time and you would use the amount of bolts made to get the average for that 7 hours.
The current phase of this project has a chart option. This needs to be modified. Items to be included and selectable by the admin as part of the chart.. # parts made, rate per our, total time. At any time the admin should be able to select employee(s) and view their current total rate per hour, not just for a task but a standing total rate per hour. In turn it needs to have the option to select a month, a day, a year and a selectable date range.
In this project you need to take into account that the modifications requested could break or change something in a way that is not desirable. That possibility needs to be taken into account as part of the project and not as additional task.
If you have suggestions for a better approach to this project that would make it easier, for example something other than just access... SQL + Access ? Please speak up. Currently we only see the need for one employee to be logged in at a time. Not even sure if multiple logins are supported in the current state. Would like to see what needs to be done to allow multiple logins if that becomes an issue.
Time frame for completion is not a huge concern. Would like to see about 7 day turn around but if it goes over we are not that concerned. Usually available 8a to 5p pacific here on site.
10 freelance ont fait une offre moyenne de 188 $ pour ce travail
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription. Good luck and succeed in this project.