Your Status: Logged out Log in

Payroll - a model produced for a company to work out its total wage bill  

Member rating: No Rating | Words: | Submitted: Thu Oct 30 2003

Page Preview
Preview
Previous 1 of 6 Next

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...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 147,195 others
Register Now
OR

Receive email updates for this category



  • Simply tell us your email address and receive a weekly Study Help Email for FREE
  • Receive 3 FREE essay views with each email
  • Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk