Excel Spreadsheet design showing total cost of employee per hour
- or -
Post a project like this1305
£25(approx. $31)
- Posted:
- Proposals: 32
- Remote
- #2993062
- Awarded
360273639507533077764359458636848473773621387349139093074904159489249648838664915631
Description
Experience Level: Entry
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
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
Greg M.
100% (6)Projects Completed
6
Freelancers worked with
6
Projects awarded
18%
Last project
18 Sep 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies