• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  • Level: GCSE
  • Subject: Maths
  • Word count: 1209

Pay Role Model.

Extracts from this document...


Pay Role Model

Project 1B

The purpose of the data is to show the salary of the employees in High Pavement College. There is six people that have been employed in the ICT department and the data shows how much each employee gets. The contract made by High Pavement College to the employee is that the minimum hours they can work is 35 hours a week, any additional hours worked will increase because of overtime pay. The college has to create this data because it has to keep a record of how much money is coming in and how much is going out, every business even a College has to do this.

The model shows the following:

  • The name of the employees.
  • The hours they have worked.
  • The hours of overtime they worked.
  • The standard pay using a formula by multiplying the hours worked by the standard rate, which is £8.00 per/hr.
  • The overtime payment using another formula, which is done by, multiplying the overtime worked and the overtime pay rate, which is £12.00 per/hr.
  • The gross pay is also included in the data (The total pay). Their is also a formula used and this is done by adding the Standard pay to the overtime pay.
  • The total wage bill is also included by adding all the total pay and putting a subtitle “wage bill”
...read more.




Now I will predict another change in the data, I will change the same data that I have already changed in the previous objectives. I predict that if I double the hours C. Clayton, works she will get 50% more salary. The total wage bill will also increase but by a smaller amount as C. Clayton only forms part of the total wage bill.

The second change I will do is decrease the hourly rate by 50% so the hourly rate will change to £5.00 so the effect on the whole wage bill will be a decrease of 50%.

I will now change the data in the workbook. And I will screen dump the changed data.

Change 1


Change 2

My predictions were not correct because I got my data mixed up by having 2 percentages. C. Clayton’s 50% had an effect but as the change in overtime pay meant Clayton overall bill does increase by same percentage.

For the second change I was also correct because the wage bill decreased, but I did get the total wage bill wrong because

...read more.


There was a problem with my model and I spotted it during the changes.  The formula for the standard pay is too simple to use for changes to the total hours and overtime because sometimes it would mean some people would be paid twice, so the new and improved formula would be:

= (B4-C4)*$B$12image07.pngimage08.pngimage01.png


Now I will change the old formula and put the new formula, which is the one above.


This now is the updated version with the new formula added so this would be suitable for the real life situation.

The next thing I will do is just to help check the average wage bill for an employee. Then I will include the maximum and minimum wage bill that should be given. This is very useful for an employer because it saves a lot of time to work it all out. I will work out the gross pay wage bill.

There will be 3 formulas I will need to use to work out minimum, average and maximum wage bill.

  • =Min(f4:f9)
  • =Max(f4:f9)
  • =Average(f4:f9)

The cell f4 and f9 are the cells for gross pay for the employees. This will calculate the average for the gross pay and work out the maximum and minimum wage.

...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. I am going to investigate how changing the number of tiles at the centre ...

    N=1, T = 2(1)� + 6(1) + 4 = 10. N=2, T = 2(2)� + 6(2) + 4 = 24. N=3, T = 2(3)� + 6(3) + 4 = 40. I have proved that this formula gives me the same sequence of total tiles as I have counted from my diagrams.

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

    VAT is then worked out after the standing charge has been added onto the unit total. VAT is usually about 5% for most suppliers. The VAT is calculated after the units cost and the standing charges have been added together.

  1. Exploring Business Data.

    It also shows a forecast for the years 2000 and 2001. The forecast predicts the total number of passengers that would use the airports if the upward trend continues. The forecast shows that in the year 2000 there should be about 158,000,000 passengers using UK airports and in the year 2001, there should be about 164,000,000 passengers.

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

    and multiplies it by the overtime rate (B13), like the hourly rate this is an absolute reference as it is the same for all teachers. To find out the total pay for each teacher you look in column F. the formula for F4 simply adds the total paid for normal hours and the overtime paid owed.

  1. I have decided to carry out a simulation on a real life situation. A ...

    This will also enable me to make some random number schemes for Service duration times. Service duration times (secs) Tally Frequency Percentage frequency 4 3 6 5 6 12 6 11 22 7 11 22 8 5 10 9 6 12 10 8 16 From this I get the following

  2. Urban Settlements have much greater accessibility than rural settlements. Is this so?

    None needed, maybe a reconsideration of the places where we performed the counts. Bus Frequency I rang the bus company, and they sent me timetables. Before I could do this, I had to note which buses ran through the villages, and who to ring.

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