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