Question about Computers & Internet

# Computer Programming In a certain company, employees are paid in an hourly basis. Write a program that will accept the number of hours worked, rate per hour and civil of an employee as inputs. The program will compute for the net take home pay for the week. Net take home pay is computed as gross pay minus tax. Gross pay is equal to number of hours worked times rate per hour. After computing for gross pay, compute for the taxable amount which is computed as gross pay minus exemptions. If the employee is married, ask for the number of children and exemption is equal to 10% of gross pay plus P50 per child but only until 4. If single, exemption is only 8% of gross pay. Tax is computed as taxable amount times tax rate where tax rate varies depending on the taxable amount and is based on the given conditions below; >If taxable amount is equal or greater than P25,000, tax rate is 10% >If taxable amount is less than P25,000 but equal or greater than P20,000, tax rate is 8% >If taxable amount is less than P20,000 but equal or greater than P15,000, tax rate is 6% >If taxable amount is less than P15,000, tax rate is 5%.

Posted by on

• Anonymous Mar 27, 2014

Need list for tax preparation

×

Ad

## 3 Answers

### Westea49

• Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

• Contributor
• 4 Answers

15 years ago I used Quickbooks to help with the tax laws and to track our small business. It may have been overkill but as a startup business I needed help that I could afford.

Certainly, a simple program could be written but keeping up with the changes in the tax laws (state and federal) would be a headache I did not want to worry with.

I am sure you could set up a spreadsheet to do the calculations using Microsoft Office, LibreOffice (free) or OpenOffice (also free).

NOTE: the company did not turn a profit and I had to close it so I am not up to date on Quickbooks.

Posted on Dec 31, 2014

Ad

### Anonymous

Thanks for giving same tip, I understand, in fact the problem that i gave was done all by my self ^^ the solution must have "if-else"
step by step to logic...to analyze the problem I need to used Flowchart to make answer easily....

Thank you...

Posted on Sep 03, 2008

Ad

### Anonymous

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Expert
• 79 Answers

HI
first of all dont expect experts to write you codes.
secondly,coming back to the problem this requires
nested if-else logic. with some logical operators involved.
(and - &&, pipe - ||).

I hope you have the logic and now you can easily write the code.

Posted on Aug 29, 2008

## Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Loading...

## Related Questions:

1 Answer

### When a person does not volunteer the full amount of hours in the week, do they have to make the time up?I.e

no
hours lost are hours lost
sick days are sick leave and paid accordingly
Time for appointments are the employee responsibility but can be made up if the company allows it
It is not compulsory

Mar 28, 2018 | The Computers & Internet

1 Answer

### What is payroll tax?

Payroll tax is the money that goes to the state and or federal government directly from your salary. There are two basic kinds of payroll tax. The first is the kind that your employer pays on your behalf and the second is the money that you pay out of your salary. These amounts are always based on your salary and they are related to each other. For example if you make 10 dollars per hour and your coworker makes 20 dollars per hour, the amount of payroll tax they and your employer pays for your coworkers is twice that of yours.

Aug 19, 2013 | Finance

1 Answer

### Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.

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.

Mar 24, 2011 | Computers & Internet

3 Answers

### Payroll system in DBMS. I don't know what data is to be taken.

Firstly you need to determine/state whether you are using a database application, such as Access, MtSQL or MS SQL and programming them to do create this application, or are you using a programming development tool such as Visual Studio, ASP.NET, PHP or the like, as the solution and guidance will be different for each.
In terms of the data design, you should store the data necessary to identify each employee uniquely and each data point per employee needed to calculate their payroll. You should then store the generic (applys to all employees) such as tax rates, in separate tables and call on it to calculate wages and other paystub data.
For instance, the employee first and last names and tax ID should be a sufficient unique identifier. Create a table for just employees, their names, tax ID, start date, schedule, pay rate, number of deductions, direct bank payment data, etc., and whatever else you decide you need for each employee. You can calculate their wages by multiplying their rate by their schedule and applying the appropriate tax rate and medical/witholding deductions as you go, so calculated data does not need to be stored and consume database space.
You'll likely need a separate table for common data such as tax rates, one for deductions/witholdings, one for holidays, one for vacation accrual rates, one for medical rates, etc. This data if common to employees does not need to be stored per individual, as that would cause redundant replication of data. If the employees are on an hourly rate, rather than a set salary/wage, then you'll need a table of worked hours per employee, akin to their timesheet data. If you use a timesheet/timecard, the entering and storing only the totals and keeping the physical timesheet for backup records should suffice.
Once you design and populate your database as suggested above, then it's a relatively-simple task of calculating the computed paystub data and storing the salient resulting datapoints for the record.
Consider a reporting application, such as Crystal Reports, for your printing needs, as its far easier to configure Crystal or similar product to format reports, paystubs, checks, etc., than coding these from scratch.
Hope this helps.

Dec 25, 2008 | Computers & Internet

## Open Questions:

#### Related Topics:

221 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

13434 Answers

Level 3 Expert

10422 Answers

Level 3 Expert

18342 Answers

Loading...