Answered step by step
Verified Expert Solution
Question
1 Approved Answer
which ever way it is easy for you, insel pom Add Page NAME HOURS HOURL BASIC WORKED YRATE PAY ALLO WANC ES GROSS PAY TAX
which ever way it is easy for you,
insel pom Add Page NAME HOURS HOURL BASIC WORKED YRATE PAY ALLO WANC ES GROSS PAY TAX DEDUCT NET PAY N.S.S.F CONTRIB UTION John 8 200 Peter 12 444 Sam 22 454 Ivan 3 567 Gerald 45 88 Sally 6 99 Paulin 77 98 e Tina 8 77 Ester 4 64 433 Jessica 33 Lynda 3 444 Jane 34 500 Required; i) Rename work sheet 1 salaries. ii) Insert a column between names and hours worked and give it the label SURNAME iii) Populate the column with surnames of your choice. Carry out the following calculations: 1) BASIC PAYHOURS WORKED HOURLY RATE. 2) ALLOWANCES ARE allocated at 6% of the BASIC PAY. 3) GROSS PAY-BASIC PAY+ ALLOWANCES 4) TAX DEDUCT is calculated at 20% of the GROSS PAY 5) NSSF CONTRIBUTION -4% of the BASIC PAY. Format the NSSF CONTRIBUTION column to zero decimal point 6) NET PAY=GROSS PAY - TAX DEDUCT. 7) What would be the total NET PAY if, The number of hours worked went up by 5% and the hourly rate was reduced by2% for each employee. 8) What would be the total NET PAY if, The tax deduct was increased to 22% of the gross pay! 496 and Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started