Scribd
Upload
26 views4 pages

Excel Assignment

The document outlines the calculation of monthly salaries for seven employees, detailing their basic salaries, allowances for conveyance, house rent, and food, leading to a gross salary. It also includes deductions for income tax and other expenses, resulting in the net salary for each employee. The total gross salary for all employees amounts to ₹73,200.

Uploaded by

suman852587
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
26 views4 pages

Excel Assignment

The document outlines the calculation of monthly salaries for seven employees, detailing their basic salaries, allowances for conveyance, house rent, and food, leading to a gross salary. It also includes deductions for income tax and other expenses, resulting in the net salary for each employee. The total gross salary for all employees amounts to ₹73,200.

Uploaded by

suman852587
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Calculation of Monthly Salary

Allowance (Flexi Payments)


S.No Emp.Name Basic Salary Conveyance House Rent Food Gross Salary
10% 20% 8%
1 Anand ₹ 10,000.00 ₹ 1,000 ₹ 2,000 ₹ 800 ₹ 13,800
2 Babu ₹ 8,500.00 ₹ 850 ₹ 1,700 ₹ 680 ₹ 11,730
3 David ₹ 7,500.00 ₹ 750 ₹ 1,500 ₹ 600 ₹ 10,350
4 Fathima ₹ 8,700.00 ₹ 870 ₹ 1,740 ₹ 696 ₹ 12,006
5 Gokul ₹ 10,000.00 ₹ 1,000 ₹ 2,000 ₹ 800 ₹ 13,800
6 Kannan ₹ 6,800.00 ₹ 680 ₹ 1,360 ₹ 544 ₹ 9,384
7 Senthil ₹ 9,500.00 ₹ 950 ₹ 1,900 ₹ 760 ₹ 13,110

Basic Pay + Allowances Gross Salary


Gross Pay - Deductions = Net Salary (TAKE HOME SALARY)
Deductions
IT Others Net salary
Total Deduction
10% 8%
₹ 1,000 ₹ 800 ₹ 1,800 ₹ 12,000
₹ 850 ₹ 680 ₹ 1,530 ₹ 10,200
₹ 750 ₹ 600 ₹ 1,350 ₹ 9,000
₹ 870 ₹ 696 ₹ 1,566 ₹ 10,440
₹ 1,000 ₹ 800 ₹ 1,800 ₹ 12,000
₹ 680 ₹ 544 ₹ 1,224 ₹ 8,160
₹ 950 ₹ 760 ₹ 1,710 ₹ 11,400
Total ₹ 73,200
Calculation of Monthly Salary
Allowance (Flexi Payments)
Conveyance House Rent Food
S.No Emp.Name Basic Salary Gross Salary
10% 20% 8%

1 Anand ₹ 10,000.00 ₹ 1,000 ₹ 2,000 ₹ 800 ₹ 13,800

2 Babu ₹ 8,500.00 ₹ 850 ₹ 1,700 ₹ 680 ₹ 11,730

3 David ₹ 7,500.00 ₹ 750 ₹ 1,500 ₹ 600 ₹ 10,350

4 Fathima ₹ 8,700.00 ₹ 870 ₹ 1,740 ₹ 696 ₹ 12,006

5 Gokul ₹ 10,000.00 ₹ 1,000 ₹ 2,000 ₹ 800 ₹ 13,800

6 Kannan ₹ 6,800.00 ₹ 680 ₹ 1,360 ₹ 544 ₹ 9,384

7 Senthil ₹ 9,500.00 ₹ 950 ₹ 1,900 ₹ 760 ₹ 13,110


hly Salary
Deductions
IT Others
Net salary
Total Deduction
10% 8%

₹ 1,000 ₹ 800 ₹ 1,800 ₹ 12,000

₹ 850 ₹ 680 ₹ 1,530 ₹ 10,200

₹ 750 ₹ 600 ₹ 1,350 ₹ 9,000

₹ 870 ₹ 696 ₹ 1,566 ₹ 10,440

₹ 1,000 ₹ 800 ₹ 1,800 ₹ 12,000

₹ 680 ₹ 544 ₹ 1,224 ₹ 8,160

₹ 950 ₹ 760 ₹ 1,710 ₹ 11,400

total - ₹ 73,200

You might also like