Posts tagged "Calculation"

Sales Incentive Calculation Format In Excel

I have Attached Sales Incentive Calculation Format in Excel.

Total Sales Incentives
S.No. Month Incentives (Month Wise)
1 Apr-12 3250.00
2 May-12 0.00
3 Jun-12 0.00
4 Jul-12 0.00
5 Aug-12 0.00
6 Sep-12 0.00
7 Oct-12 0.00
8 Nov-12 0.00
9 Dec-12 0.00
10 Jan-13 0.00
11 Feb-13 0.00
12 Mar-13 0.00
Total 3250.00

 

Click Here To Download Sales Incentive Calculation Format

Search Sample Formats:

Be the first to comment - What do you think?
Posted by Hrformats - October 1, 2012 at 6:55 AM

Categories: HR   Tags: , , ,

Calculation of Penalty After Late Submission of ESI

Penal Interest under section 7Q:
# No.of days delayed in making payment x 12% p.a

Penal Damages under section 14B:
# No.of days delayed in making payment x 5% p.a (Less than 2 months)
# No.of days delayed in making payment x 10% p.a (2 months and above but less than 4 months)
# No.of days delayed in making payment x 15% p.a (4 months and above but less than 6 months)
# No.of days delayed in making payment x 25% p.a (6 months and above)

I have attached worksheet for the same.

EPF Interest and damages for Delayed Payments for the year 2007-2008
Contribution
Period
Due
Date
Paid
Date
Delay
Days
Rate p.a Account No. 1 Account No. 2 Account No. 10 Account No. 21 Account No. 22
Slab 7Q 14B Contribution 7Q Dues 14B Dues Contribution 7Q Dues 14B Dues Contribution 7Q Dues 14B Dues Contribution 7Q Dues 14B Dues Contribution 7Q Dues 14B Dues
Oct-07 11/15/2007 5/15/2008 182 6 months 0 days 12% 25% 10193 610 1271 756 45 94 4416 264 550 343 21 43 7 0 1
Nov-07 12/15/2007 4/15/2008 122 4 months 0 days 12% 15% 11145 447 559 823 33 41 4922 197 247 374 15 19 8 0 0
Dec-07 1/15/2008 3/15/2008 60 2 months 0 days 12% 10% 10880 215 179 804 16 13 4796 95 79 365 7 6 7 0 0
Jan-08 2/15/2008 3/14/2008 28 0 months 30 days 12% 5% 10880 100 42 804 7 3 4796 44 18 365 3 1 7 0 0
TOTAL 1372 2051 101 151 600 894 46 69 0 1
ABSTRACT:
7Q Dues 2119
14B Dues 3166
Total Rs. 5285

 

Click Here To Download EPF Damages Calculation

Search Sample Formats:

3 comments - What do you think?
Posted by Hrformats - September 25, 2012 at 10:14 AM

Categories: HR   Tags: , ,

Gratuity Calculation in Excel

I have Attached Gratuity Calculation Tool

 Gratuity Calculation
Name of the Employee : ASD
Father’s/Husband’s Name : ZXC
Date of Birth : 7/1/1965
Date of Joining : 5/1/2005
Date of Separation : 10/30/2011
Last Drawn Basic Salary : 5000.00
Last Drawn D.A : 0.00
No.of years served : 6 (Roundup nearest 1 Year)
Gratuity Amount : 17308.00

 

Click Here To Download Gratuity Calculation Tool

Search Sample Formats:

Be the first to comment - What do you think?
Posted by Hrformats - August 28, 2012 at 5:44 AM

Categories: HR   Tags: , ,

Calculating Employee Attrition

I have Attached Sample Attrition Calculation sheet

 B Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10
 No. of Left  No. of Left  No. of Left  No. of Left  No. of Left  No. of Left  No. of Left  No. of Left  No. of Left  No. of Left  No. of Left  No. of Left
Manager 0 0 0 1 0 1 0 0 0 1 0 0
Staff 1 0 0 0 2 0 2 0 2 0 5 0
Trainees 0 0 1 0 0 0 0 0 0 0 0 1
 Total left 1 0 1 1 2 1 2 0 2 1 5 1
 Average Headcount 35 39 41 40 41 41 41 41 41 42 43 44
 ATTRITION (%) 2.86% 0.00% 2.44% 2.50% 4.88% 2.44% 4.88% 0.00% 4.88% 2.38% 11.63% 2.27%
 Month wise Attrition Data- B
 Particulars Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10  Total
 Average Headcount 35 39 41 40 41 41 41 41 41 42 43 44 41
 Attrition (No) 1 0 1 1 2 1 2 0 2 1 5 1 1
 Attrition (%) 2.86% 0.00% 2.44% 2.50% 4.88% 2.44% 4.88% 0.00% 4.88% 2.38% 11.63% 2.27% 2.4%

 

Click Here To Download Sample Attrition Calculation sheet

Be the first to comment - What do you think?
Posted by Hrformats - August 17, 2012 at 4:46 AM

Categories: HR   Tags: , , ,

Salary Calculation Template In Excel

I have Attached Sample Salary Calculation Template.

 

Salary Calculation Template
GROSS – Cost to Company Rs. Chq Amt Every Month Rs. Gets Will get in Rs.
Basic + DA 8000.00 Basic + DA     8,000.00 Take Home Amt                   12,040.00
PF 12.00%           960.00 PF, 12%       (960.00) Other accts                      4,780.00
HRA        4,000.00 HRA     4,000.00 Prof tax                         200.00
ESIC 4.75%                    – ESIC, 1.75%                  – Total                   17,020.00
LTA 5.00%           400.00 Conveyance         800.00 Annual CTC                 204,240.00
Medical 5.00%           400.00 Prof Tax       (200.00)
Conveyance           800.00 Helper allowance                  – Name
Outfit           100.00 Family welfare         200.00 Division
Helper allowance                    – Education allowance         200.00 Grade
Family welfare           200.00   12,040.00 Qualification:
Gratuity 4.50%           360.00 DOJ
Bonus 20.00%        1,600.00 Effective
Education           200.00 Added to other accounts Position
S.A. 10.00%                    – PF, 24%     1,920.00 Location
Food coupons                    – ESIC, 6.5%                  –
    17,020.00 LTA, 5%         400.00
  204,240.00 Bonus, 20%     1,600.00
Outfit         100.00
PF deposited in PF department Medical, 5%         400.00
ESIC deposited with ESIC dept Gratuity 4.5%         360.00
Prof tax paid to PT department Food Coupons                  – 549
LTA payable in August     4,780.00 99
Medical if appl.payable in August
Outfit if appl. payable in January
Bonus paid at the time of Diwali
Gratuity will be paid after 5 yrs services
Note: Your Compensation is personal to you and confidential between you and the Company.
         You are requested not to share details of the same with others, within or outside the Company.
            Eventhough LTA, Medical, & Bonus are the part of salary package, These will be  payable only if employee completes one year of service
Authorised Signatory

 

Click Here To Download Salary Calculation Template

Search Sample Formats:

3 comments - What do you think?
Posted by Hrformats - May 29, 2012 at 10:42 AM

Categories: HR   Tags: , , ,

TDS Calculation & Investment Detail

 I have Attached TDS Calculation & Investment Detail

Company Name & Address Comp. Logo
 IT DECLARATION FORM  & TDS Calculation
Financial Year
Employee Name
Branch
Annual salary Tax Rate 0
DATE
Sl. No. investments/ Saving Details Amount (Annual value)
Under Section 80 C
1 Deductions under Pension scheme of Insurance Companies 0
2 Deduction Under New Pension Scheme-NPS 0
3 NSC 0
4 PPF 0
5 Infra Structure Bond 0
6 Children Education 0
7 Housing Loan Principal repayment 0
8 Insurance Premium  0
9 Others  (MF, ULIP)  0
10 EPF & Voluntary PF 0
Under Section 80 D
11 Medical Insurance Premium-Self 0
12 Medical Insurance Premium-parents (dependents) 0
13 Medical for disable dependents 0
14 Medical expenditure for specifies diseases 0
15 Deferred Annuity 0
Other Mscl. Sections
16 Higher Education Loan Interest Repayment [Sec 80E] 0
17 Rent Deductions [Sec 80GG] only if HRA is not received 0
TOTAL (savings of Tax Rebate) 0
ANNUAL INCOME (Earnings)
1 BASIC 0
2 HRA 0
3 CONVEYANCE 0
4 INCENTIVE 0
5 HRA paid by Employer* 0
Total Income 0
Income Tax Exemptions 200000
Total Taxable Income -200000
Savings of Tax Rebate 0
Net Taxable Income for Deducting Tax -200000
Tax on Total Income 0
3% Education Cess 0
Tax Payable (Annual) 0
Monthly Tax 0

 

 

Click Here To Download IT Declaration Form

Search Sample Formats:

Be the first to comment - What do you think?
Posted by Hrformats - May 1, 2012 at 11:36 AM

Categories: HR   Tags: , , ,

TDS Calculation & Investment Detail

 I have Attached TDS Calculation & Investment Detail

Company Name & Address Comp. Logo
 IT DECLARATION FORM  & TDS Calculation
Financial Year
Employee Name
Branch
Annual salary Tax Rate 0
DATE
Sl. No. investments/ Saving Details Amount (Annual value)
Under Section 80 C
1 Deductions under Pension scheme of Insurance Companies 0
2 Deduction Under New Pension Scheme-NPS 0
3 NSC 0
4 PPF 0
5 Infra Structure Bond 0
6 Children Education 0
7 Housing Loan Principal repayment 0
8 Insurance Premium  0
9 Others  (MF, ULIP)  0
10 EPF & Voluntary PF 0
Under Section 80 D
11 Medical Insurance Premium-Self 0
12 Medical Insurance Premium-parents (dependents) 0
13 Medical for disable dependents 0
14 Medical expenditure for specifies diseases 0
15 Deferred Annuity 0
Other Mscl. Sections
16 Higher Education Loan Interest Repayment [Sec 80E] 0
17 Rent Deductions [Sec 80GG] only if HRA is not received 0
TOTAL (savings of Tax Rebate) 0
ANNUAL INCOME (Earnings)
1 BASIC 0
2 HRA 0
3 CONVEYANCE 0
4 INCENTIVE 0
5 HRA paid by Employer* 0
Total Income 0
Income Tax Exemptions 200000
Total Taxable Income -200000
Savings of Tax Rebate 0
Net Taxable Income for Deducting Tax -200000
Tax on Total Income 0
3% Education Cess 0
Tax Payable (Annual) 0
Monthly Tax 0

 

Click Here To Download TDS Calculation & Investment Detail

Be the first to comment - What do you think?
Posted by Hrformats - April 28, 2012 at 9:47 AM

Categories: HR   Tags: , , ,

Gratuity Calculation tool

I have Attached Gratuity Calculation tool

 Gratuity Calculation
Name of the Employee : ABC
Father’s/Husband’s Name : XYZ
Date of Birth : 7/1/1965
Date of Joining : 5/1/2005
Date of Separation : 10/30/2009
Last Drawn Basic Salary : 5000.00
Last Drawn D.A : 2000.00
No.of years served : 5
Gratuity Amount : 18178.61

Click Here To Download Gratuity Calulation

Be the first to comment - What do you think?
Posted by Hrformats - February 7, 2012 at 11:09 AM

Categories: HR   Tags: , ,

Salary Calculation Sheet in Excel

 I have Attached Salary Calculation Sheet in Excel

FOR GENERAL STAFF
INPUT HERE TOTAL CTC   = 9001
XYZ LTD.
Name: Grade: Revised
Design: D.O.J.: Grade:
E.Code: Design:
Deptt.: D.O. Inc.: w.e.f.:
SALARY BREAK UP
(Amt.in Rs.)
S.No. Description Existing Increment Revised salary Remarks
salary w.e.f. w.e.f.
1 Basic Pay 4428
2 HRA 40% of Basic Pay 1771
3 Conv.Allow 15% of Basic Pay 664
4 C.E.A 5% of Basic Pay 221
5 Uniform Maint. Allow 500
GROSS AMOUNT 7584
6 P.F. 531
7 Bonus 886
TOTAL CTC 9001
SR. MANAGER (HR.) BUSINESS HEAD

 

Click Here To Download Salary Calculation sheet in excel

1 comment - What do you think?
Posted by Hrformats - January 27, 2012 at 11:43 AM

Categories: HR   Tags: , , ,

Salary Calculation Sheet in Excel

 I have Attached Salary Calculation Sheet in Excel

FOR GENERAL STAFF
INPUT HERE TOTAL CTC   = 9001
XYZ LTD.
Name: Grade: Revised
Design: D.O.J.: Grade:
E.Code: Design:
Deptt.: D.O. Inc.: w.e.f.:
SALARY BREAK UP
(Amt.in Rs.)
S.No. Description Existing Increment Revised salary Remarks
salary w.e.f. w.e.f.
1 Basic Pay 4428
2 HRA 40% of Basic Pay 1771
3 Conv.Allow 15% of Basic Pay 664
4 C.E.A 5% of Basic Pay 221
5 Uniform Maint. Allow 500
GROSS AMOUNT 7584
6 P.F. 531
7 Bonus 886
TOTAL CTC 9001
SR. MANAGER (HR.) BUSINESS HEAD

Click Here To Download Salary Calculation Sheet in Excel

2 comments - What do you think?
Posted by Hrformats - January 25, 2012 at 11:17 AM

Categories: HR   Tags: , , ,

Next Page »