Payroll - a model produced for a company to work out its total wage bill
Member rating: No Rating | Words: | Submitted: Thu Oct 30 2003
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
GCSE coursework - Payroll. The model has been produced for the company to work out its total wage bill, this includes the total hours, overtime hours, amount of standard pay and the overtime pay and of course the total amount. The type of data being used is numerical, textural and currency. The data being used is the name of each teacher, the total hours worked per week, the amount of overtime hours, standard pay and overtime pay. There is also information about hourly rate and overtime rate. I am now going to look at the formulas used and how they are produced. Fiq 1. A screen dump of the payroll model. Fiq 2. A screen dump of formulas to produce the payroll model In fiq 1, C4 shows the overtime the teacher has worked. In fiq 2 you can see that the formula used is =B4-35, this is done by taking the total hours worked by...


