Salary Analysis ka matlab hai employees ki salary-related information ko Excel mein calculate, compare aur analyze karna.
Isme employee ki Basic Salary, Allowances, Deductions, Gross Salary, Net Salary, Bonus etc. ka calculation aur comparison kiya ja sakta hai.
Simple Definition:
Employees ki salary ko calculate, compare aur analyze karke useful salary report banana Salary Analysis kehlata hai.
Salary Analysis ka main purpose hota hai:
| Component | Meaning |
|---|---|
| Basic Salary | Employee ki main salary |
| HRA | House Rent Allowance |
| DA | Dearness Allowance |
| TA | Travel/Transport Allowance |
| Bonus | Additional payment |
| Gross Salary | Total salary before deductions |
| PF | Provident Fund deduction |
| Tax | Applicable tax deduction |
| Other Deduction | Other salary deductions |
| Net Salary | Employee ko receive hone wali salary |
Gross Salary calculate karne ke liye generally salary components ko add kiya jata hai.
Gross Salary = Basic Salary + HRA + DA + TA + BonusExample:
Basic Salary = ₹30,000
HRA = ₹8,000
DA = ₹3,000
TA = ₹2,000
Bonus = ₹2,000
Gross Salary = ₹45,000
Net Salary calculate karne ke liye Gross Salary se deductions subtract kiye jate hain.
Net Salary = Gross Salary - Total DeductionsExample:
Gross Salary = ₹45,000
PF = ₹2,000
Tax = ₹1,500
Other Deduction = ₹500
Total Deduction:
=2000+1500+500Total Deduction = ₹4,000
Net Salary:
=45000-4000Net Salary = ₹41,000
| Employee | Department | Basic | HRA | DA | Gross Salary | Deduction | Net Salary |
|---|---|---|---|---|---|---|---|
| Rahul | IT | ₹30,000 | ₹8,000 | ₹3,000 | ₹41,000 | ₹3,000 | ₹38,000 |
| Aman | Sales | ₹28,000 | ₹7,000 | ₹2,500 | ₹37,500 | ₹2,500 | ₹35,000 |
| Priya | HR | ₹35,000 | ₹9,000 | ₹3,500 | ₹47,500 | ₹3,500 | ₹44,000 |
Is table se employee-wise salary compare ki ja sakti hai.
Salary ko department ke according bhi analyze kiya ja sakta hai.
Example:
| Department | Employees | Total Salary |
|---|---|---|
| IT | 10 | ₹4,50,000 |
| HR | 5 | ₹2,00,000 |
| Sales | 8 | ₹3,20,000 |
| Accounts | 6 | ₹2,70,000 |
Isse company ko pata chal sakta hai ki kis department ka salary expense kitna hai.
Pivot Table is type ke analysis ke liye useful hai.
Excel functions ke through highest aur lowest salary identify ki ja sakti hai.
=MAX(H2:H20)=MIN(H2:H20)=AVERAGE(H2:H20)=SUM(H2:H20)Salary Analysis mein different employees ki salary compare ki ja sakti hai.
Example:
| Employee | Net Salary |
|---|---|
| Rahul | ₹38,000 |
| Aman | ₹35,000 |
| Priya | ₹44,000 |
| Neha | ₹32,000 |
Is data ko Column Chart se visually compare kiya ja sakta hai.
Isse quickly identify ho sakta hai:
Different charts ka use kiya ja sakta hai:
Employee-wise salary comparison.
Monthly salary expense ka trend.
Department-wise salary expense ka share.
Salary expense + employee count ko ek report mein show karna.
Company future salary expenses ka projection bhi bana sakti hai.
Example:
Current Monthly Salary Expense = ₹5,00,000
Expected increment = 10%
=500000*(1+10%)Projected Salary Expense:
₹5,50,000
Isse future salary budget plan karne mein help milti hai.
Salary Analysis ka use:
Leave a Reply