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