# Pay Role Model.

Extracts from this document...

Introduction

## 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”

Middle

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

Conclusion

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$12

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.

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