InterviewSolution
Saved Bookmarks
| 1. |
The spreadsheet below shows the payroll structure of Pluto Ltd.Based on the information give in the spreadsheet, write the formula for calculating each of the following:(a) Net Pay of EMP002(b) Provident Fund (PF) amount of EMP004.(c) Income Tax (I TAX) of EMP003(d) The total gross salary of all the employees.(e) The basic salary of EMP005 |
|
Answer» (a) Net pay of EMP002 = G3 – H3 – 13 – J3 (b) Provident Fund amount of EMP004 = 10/100*(B5 + C5) (c) Income Tax of EMP003 = G4* 10/100 (d) Total gross salary of all the employees = SUM (G2 : G6) (e) The basic salary of EMP005 = G6 – C6 – D6 – E6 – F6 |
|