Hey all!
I have sort of a random poll for everyone.
I’ve been working on a payroll project and as I’m a student and most of the things I had to accomplish for this project I’d never seen before, its’ taken me hours upon hours to code it, but I was curious as to how long (an estimation) something like this would take a professional to do.
So the task was this:
Create a database to store the details of an employee (name, surname, id number, date employee began working for company, project num (which project he/she works on), occupation num (what type of job employee has), bank number and then provident fund and union dues, if applicable (fee’s that get paid directly out of the employees wages, if applicable)
Each job has a different hourly rate, as well as 3 overtime categories, which are worked out based on the normal rates hourly pay (calculated whenever a new job category is added or the normal rate value in a job category is changed). There must be a table that stores each employee’s hours worked for the 4 categories (normal hours and 3 overtime categories). An employee can also receive any number of other payments and allowances (i.e. travel compensation or if they take a loan from the company). Other pay and allowances must be stored in separate tables.
Before a pay slip can be generated, the following must be calculated for each employee:
· Wages (hours worked * hourly rate, therefore there are 4 categories of wages)
· Gross wages (all 4 categories of wages combined)
· Total allowances
· Total other pay
· Total Income (all incomes combined)
· UIF (1% of gross wages)
· Total deductions (all deductions combined)
· Nett Wages (total income – total deductions)
A few other forms must be generated, such as a breakdown of the different monetary values an employee receives, if he/she is paid in cash.
An application program must be created that allows users to access the various tables to view details and add/delete/edit where needs be (i.e. add a new employee to a system, edit the amount given to an employee for travel compensation, etc)
That about sums up the task. Now to the question:
How many hours would you reckon it would take you (working on your own) to complete a task like this (excluding doing documentation of it, i.e. just the coding, creating of the database and queries, etc)?
I have sort of a random poll for everyone.
I’ve been working on a payroll project and as I’m a student and most of the things I had to accomplish for this project I’d never seen before, its’ taken me hours upon hours to code it, but I was curious as to how long (an estimation) something like this would take a professional to do.
So the task was this:
Create a database to store the details of an employee (name, surname, id number, date employee began working for company, project num (which project he/she works on), occupation num (what type of job employee has), bank number and then provident fund and union dues, if applicable (fee’s that get paid directly out of the employees wages, if applicable)
Each job has a different hourly rate, as well as 3 overtime categories, which are worked out based on the normal rates hourly pay (calculated whenever a new job category is added or the normal rate value in a job category is changed). There must be a table that stores each employee’s hours worked for the 4 categories (normal hours and 3 overtime categories). An employee can also receive any number of other payments and allowances (i.e. travel compensation or if they take a loan from the company). Other pay and allowances must be stored in separate tables.
Before a pay slip can be generated, the following must be calculated for each employee:
· Wages (hours worked * hourly rate, therefore there are 4 categories of wages)
· Gross wages (all 4 categories of wages combined)
· Total allowances
· Total other pay
· Total Income (all incomes combined)
· UIF (1% of gross wages)
· Total deductions (all deductions combined)
· Nett Wages (total income – total deductions)
A few other forms must be generated, such as a breakdown of the different monetary values an employee receives, if he/she is paid in cash.
An application program must be created that allows users to access the various tables to view details and add/delete/edit where needs be (i.e. add a new employee to a system, edit the amount given to an employee for travel compensation, etc)
That about sums up the task. Now to the question:
How many hours would you reckon it would take you (working on your own) to complete a task like this (excluding doing documentation of it, i.e. just the coding, creating of the database and queries, etc)?