|
Simple Job Automation
Payroll Entry & Reporting
|
Manual or
Spreadsheet Process
 |
Automation of the Process (Database)
|
| 1) Payroll clerk copies the weekly spreadsheet and re-names it
2004_Sep_WK_1.xls (Week 1 of September) |
X |
|
| 2) Payroll clerk clicks on button and opens the payroll form, then
picks the correct week. |
|
X |
| 2) Gets time cards and enters beginning and ending time before
lunch and then the same for after lunch. |
X |
X |
| 3) Enter any Sick, Vacation, or Holiday Hours |
X |
X |
| 4) Printout Payroll Names with associated hours for the pay period |
X |
X |
| 5) Printout cost for this weeks payroll. |
maybe |
X |
| 6) Printout cost by department for this weeks payroll |
|
X |
| 7) Printout payroll information a particular department for any
period of time. |
|
X |
| 8) Payroll hours for a single employee for any period of time. (Do
you ever have an employee ask for last 3 months hours - it's not a problem with
the right database.) |
|
X |
| 9) Lookup overtime hours for any period of time. |
|
X |
| 10) Compare this years employment costs with last years - per
employ. |
|
X |
| 11) Compare this years employment costs with last years - per
department, per period. |
|
X |
| 12) Compare this years hours with last years hours - per employ. |
|
X |
| 13) Compare this years hours with last years hours - per
department. |
|
X |
| 14) Have a program that is a step closer to getting cost and
profit per product. |
|
X |