Employee code

employee name

employee basic salary(we enter)

calculate gross salary(with hra,da,ta)

Ad

1helpful

2answers

I haven't used a calculator with these functions, so let's do a test.

I'm guessing is it for doing basic accounting. The equation is Sales - Costs = Gross Profit and maybe Gross Profit / Sales = Gross Margin.

If we enter 100 in sell, 40 in cost, does the margin come out to be 60 or 0.6? If it comes out to 60, the margin is the Gross Profit. If it comes out to 0.6, then the margin is Gross Margin.

Good luck,

Paul

I'm guessing is it for doing basic accounting. The equation is Sales - Costs = Gross Profit and maybe Gross Profit / Sales = Gross Margin.

If we enter 100 in sell, 40 in cost, does the margin come out to be 60 or 0.6? If it comes out to 60, the margin is the Gross Profit. If it comes out to 0.6, then the margin is Gross Margin.

Good luck,

Paul

May 12, 2016 •
Office Equipment & Supplies

0helpful

1answer

The easiest way to do this is to use Excel spreadsheet.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 •
Computers & Internet

0helpful

1answer

Change the default from salary to hourly on the employee file.

www.cpahispano.com

www.cpahispano.com

Jun 25, 2010 •
Intuit QuickBooks Pro 2010 Full Version...

0helpful

1answer

Employee's having gross salary of Rs-10000/- or less are eligible for ESI scheme .It means they are covered under ESI scheme while others not.

The rate is

4.75% for employer&

1.75% for employee

of the gross salary

The rate is

4.75% for employer&

1.75% for employee

of the gross salary

Jun 10, 2010 •
Computers & Internet

0helpful

1answer

hi,
well u don't need looping in salary computation.
here is the program:-

#include<iostream.h> #include<conio.h> int main() { float bs,gs,hra,da; cout<<"enter basic salary"; cin>>bs; hra=40*bs/100; da=20*bs/100; gs=bs+hra+da; cout<<gs; return 0; }

regards, poly

#include<iostream.h> #include<conio.h> int main() { float bs,gs,hra,da; cout<<"enter basic salary"; cin>>bs; hra=40*bs/100; da=20*bs/100; gs=bs+hra+da; cout<<gs; return 0; }

regards, poly

Oct 07, 2009 •
Computers & Internet

0helpful

1answer

class employee

{

int emp_no;

char emp_name[80];

float Basic;

public:

employee(int no, char *name, float basic)

{

emp_no=no;

emp_name=name;

Basic=basic;

}

float int calc_da()

{

return(Basic*52/100);

}

float calc_it()

{

return((Basic+calc_da())*30/100);

}

float calc_netSal()

{return(Basic+calc_da()-calc_it();}

};

{

int emp_no;

char emp_name[80];

float Basic;

public:

employee(int no, char *name, float basic)

{

emp_no=no;

emp_name=name;

Basic=basic;

}

float int calc_da()

{

return(Basic*52/100);

}

float calc_it()

{

return((Basic+calc_da())*30/100);

}

float calc_netSal()

{return(Basic+calc_da()-calc_it();}

};

Feb 28, 2009 •
IBM Computers & Internet

1helpful

1answer

da=basic*(Da%/100)

hra=basic*(Hra%/100)

apply the same for remaining additions and deductions

net=(basic+da+hra+ca+ea)-(pf+pt)

hra=basic*(Hra%/100)

apply the same for remaining additions and deductions

net=(basic+da+hra+ca+ea)-(pf+pt)

Feb 23, 2009 •
Microsoft Office 2003 Basic Edition...

2helpful

1answer

Nice try!

Find an upper-class student that can give one-on-one tutoring with your homework.

Find an upper-class student that can give one-on-one tutoring with your homework.

Nov 25, 2008 •
Computers & Internet

0helpful

1answer

please provide details of what is hra,da,ta and pf. I will provide the formula for you..

Aug 28, 2007 •
Microsoft Office Standard for PC

1,115 views

Usually answered in minutes!

×