Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
689 views
in Accounts by (49.5k points)
closed by

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

1 Answer

+1 vote
by (46.2k points)
selected by
 
Best 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

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...