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

The salary information of a company named Seasons India Ltd. is given below. Prepare Payroll.

Name of the employee Basic pay HRA
Adarsh 8000 1000
Alwin paul 79000 1000
Amal Mohan 8000 1000
Amamath 7550 1000
Anurag 9000 1000

DA – 50% of Basic pay, CCA – 5% of Basic pay, PF 8% of Basic pay.

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 details in the following cells.

Step 3 – Enter the following formula in respective cells

Cell Formula
C2 =B3*50%
E2 =B3*5%
F2 = SUM (B3:E3)
G2 = B3*8%
H2  =F3 - G3

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

Output:

Name of Employee Net salary
Adarsh 12760
Alwin paul 12613
Amal mohan 12760
Amarnath 12098.50
Anurag 14230

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.

...