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

Introduction

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.

image00.png

Fiq 1. A screen dump of the payroll model.

image01.png

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.

Middle

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:

image02.png

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.

Conclusion

lowing changes occurred:

image04.png

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:

image05.png

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.

image06.png

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

image07.png

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

This is done by:

image08.png

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

    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 74 75 76 77 78 79 80 81 The table above shows our T-Shape being rotated 270� clockwise,

  1. Maths Coursework T-Totals

    +3 or -2) and g is the grid width. Combinations (diagonal) For diagonal translation across a grid a combination of horizontal and vertical translations are used, therefore I predict that if I combine my 2 found equations for horizontal and vertical equations, I can generate a general formula for diagonal translations, which is a prediction I need to change.

  2. Maths coursework

    this is: I will now add up all of that is in the t-shape and put it into its simplest form: T = N + (N - G) + (N - 2G) + (N - 2G + 1) + (N - 2G - 1)

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

    I can express this new algebraic sequence for total tiles, in terms of both, N, the pattern number and, C, the number of centre tiles. I can now form a complete formula to predict the amount of total tiles required.

  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