• 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

    5.1 is an example Width 10 grid, with example "T"s ranging from 3x1 to 9x5. For examples of different grid widths, see Figs 2.1-2.5. a) Here are the results of the 5 calculations for a 5x1 "T" on Width 10 Grid: Middle Number Sum of Wing Sum of Tail Total Sum (Wing + Tail)

  2. T-Shapes Coursework

    using the table width/grid size (g), I will try to find a generalised formula, so here we go: 23 30 31 32 41 n - 7 n n +1 n + 2 n + 11 n - (g -2) n n +1 n + 2 n + (g + 2)

  1. Maths Coursework T-Totals

    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 34 35 36 37 38 39 60 61 62 63 64 65 66 67 68 69 70 71 72 73

  2. Maths coursework

    Therefore I want to double check N = 46 T = (46 + 39 + 31 + 32 + 33) = 181 Therefore: 181 = (5 � 46) - 46 = 181 Therefore the formula of T = 5N - 49 is correct However this formula is only correct for

  1. I am going to investigate how changing the number of tiles at the centre ...

    This tells you the formula is based on N�. The second difference is 4 and you divide this by 2, to get 2. This is the multiplier of N�, so you should now have 2N�. You will then need to find the second part of the equation, this will be

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

  1. T-Total Course Work

    18-10 18 T-17 T-16 T-15 T-8 T T-total = 34 10 18 2 3 4 T-number = 19 Numbers: 2 3 4 11 19 19-2 19-3 19-4 19-11 19 T-17 T-16 T-15 T-8 T T-total = 39 11 19 (T-17)

  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.

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