I need a spreadsheet made to show and calculate the following Hourly wage £00.00 Hours per week 00.00 (The inputted figure will multiply hourly wage by number of hours) Bonus per hour £00.00 (Any figure inputted here to be added to hourly wage total) Total wage per week £000.00 ( This figure is hourly wage multiplied by number of hours, and included any bonus per hour. Total figure shown here of that calculation. Holiday pay per hour £00.00 (12.07 % of the hourly wage excluding any bonus per hour). Employer NI per hour £00.00 (13.80% of hourly wage, bonus, and holiday pay. However 0% up to £169.00 per week). Employer Pension per hour £00.00 (3% of hourly pay, bonus and holiday pay. 0% under £120.00 per week) Grand total per hour £00.00
I would also like our company logo to be added to the final Excel sheet. I would also like the ability for each line for the % and 0% up to figures to be able to be edited by me.
Holiday pay "12.07%" Employer NI "13.80%" "0% up to £169.00" per week Employer pension "3%" on anything over "£120.00" per week.
The reason for this is each April the figures are changed by the UK government. I attach a copy of the logo to this proposal Thank you