• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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

Extracts from this document...


Nicola Bowskill

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 the teacher concerned (B4) and subtracting 35, the normal working hours.

...read more.


Every week someone will have to re type certain data to work out the new weeks wages. There will be for of the values that might have to be changed:

  • The total hours worked
  • The hourly rate
  • The overtime rate
  • The minimum number of contract hours.

This would have various affects on the output data, if the total hours worked is lower than the original then the total pay will go down and visa versa. Likewise if the any of the other variables are altered it will have an affect on the total wage bill.

I have made the above changes to the model and produced this:


Fiq 3. Shows changes made to the model

As you can see this shows that increasing the total hours for B. Bryson will increase overtime pay, and the total pay as well as the total wage bill. If I decrease the minimum hours from 35 hours to 30 hours then the overtime pay, total pay and total wage bill will all go up.

...read more.


lowing changes occurred:


Fiq 5. Shows the affects of the changes in hours.

As an affect of the change made to the hourly rate the following changes occurred:


Fiq 6. Shows the changes made in the hourly rate

If the contract changes and the minimum working hours becomes 30 then the formula will have to be changed for column C, this means that the overtime pay, total pay and total wage bill will all go up.


Fiq. 7. Shows the changes made in the contracted hours

The model doesn’t look at income tax, so two new columns need to be added, one to show the amount of tax to be paid and the amount owed to the staff, Net Pay. The tax will be 22% so the total wage bill and the entire total pay now call Net pay will be down by 22%.


Fiq.8. Shows the changes made by adding tax allowance.

This is done by:


This doesn’t take into account other factors such as National Insurance, tax rates etc. This would have to be looked into further.

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE T-Total essays

  1. T-Shapes Coursework

    24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73

  2. Maths Coursework T-Totals

    will be equal to 0, therefore canceling out that part of the equation as it would equal 0. For example if we wanted to translate a T-Shape with a v number of 41 on a grid width of 9, by -3 horizontally, the equation would look like; T=(5x41-2x9)-0(5x9)-(5x-3)

  1. Maths GCSE Coursework – T-Total

    45 205 t = (5 x 45) + ( 2 x 10 ) N/a As I predicted the "magic" number was 5, therefore I can generalize and state that; Any horizontal translation can be found by t=(5v-2g)+5a, were v is the middle number, a is the figure by which the T-Shape is translated (e.g. +3 or -2)

  2. For this task we were required to create a model that can be used ...

    This is how a bill can be made. The resulting value would be the price needing to be paid. A standing charge may also be added. This is a sum of money that is added to the total cost for the units.

  1. T-Total Course Work

    + (T-16) + (T-15) + (T-8) + (T) = 5T - 56 Let T-number = T Let T-total = n T n I realised the pattern of the sequence goes up by 5 each time. 18 19 20 34 (+5)

  2. Maths coursework

    to minus 19 N- 18: this is the number above N - 9 and in each case, to get back to N you have to minus 18 N- 17: this is the number right of N - 18 and in each case, to get back to N you have to

  1. Compile a report which will look at, and assess the performance of sales generated ...

    Descriptive Statistics: Total sales Variable N N* Mean SE Mean StDev Minimum Q1 Median Q3 Total sales 95 0 635.44 9.23 89.95 449.00 559.00 641.00 721.00 Variable Maximum Total sales 780.00 Figure 1 shows the overall distribution of sales in the uk.

  2. Pay Role Model.

    I predict that for the first change the standard pay will increase dramatically because the hours worked will be multiplied by 10 and as I am increasing hourly rate to �10 not �8. So that means the total pay will increase, so then the net pay will increase.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work