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
337 views
in Use of Spread Sheet in Business Application by (25.6k points)
closed by

Prepare a Pay Roll statement of Viswanath Enterprises from the table given below and additional information.

No. Employee Name Designation Basic pay LIC TDS
1 kumar Manager 22000 1600 1000
2 Bablu Accountant 18000 650 500
3 Meera Clerk 12000 300 400
4 Nayana Clerk 13500 200
5 Ouseph Clerk 11500 200
6 Premnath Peon 7000 280 200

1. DA is provided at 90% of Basic Pay 

2. HRA: Rs. 500 for manager, 400 for accountant and 200 for others. 

3. PF is deducted @ 20% on Basic + DA

1 Answer

+1 vote
by (27.3k points)
selected by
 
Best answer

Procedure: 

Step 1 – Open a blank worksheet in LibreOffice Calc. 

Step 2 – Enter the following text/formula in respective cells

Step 3 – Enter the given details

Cell Formula
E2 = D2 * 90%
F2 = IF(C2 = “Manager”, 500, IF(C2 = “Accountant”, 400, 200))
G2 = SUM (D2: F2)
H2 = SUM(D2: E2) * 20%
K2 = SUM(H2: J2)
L2 = G2 – K2

Step 4 – Copy the formula down up to the last employee. 

Output:

No Employee Name Net Salary
1 Kumar 31340
2 Balu 26610
3 Meera 17740
4 Nayana 20520
5 Ouseph 17480
6 Premnath 10360

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.

...