# 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

×

• Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

• Contributor

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

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

• 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

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

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What are the top four laws of overtime in California?

California government has made the law to put financial pressure on employers to hire additional staff and to protect employees in weak bargaining positions from being overwork. The top four laws of overtime in California are:
1. Provides overtime at half time and a half of employees regular rate pay for work performed in excess of 40 hours a week.
2. Workers who work more than eight hours in a workday must be paid at one and a half times their regular rate of remuneration.
3. Employees are paid double for overtime for work performed in excess of 12 hours in one day.
4. California law provides that when an employee does work seven consecutive days in a row, he or she must be paid overtime for the entire day of work.
For more details about a law or any legal help, you can look on Overtime California.

Mar 23, 2017 | Cars & Trucks

### When should an employee be paid overtime in California?

The California labor code provides multiple ways for workers to earn overtime. In California, overtime is paid when work performed by an employee in excess of 8 hours in one work day, or in excess of 40 hours in one work week, along with the first 8 hours worked on the seventh consecutive day of any one workweek. To know more about the overtime law, you can refer Overtime California.

Mar 23, 2017 | Computers & Internet

### How much employees are paid for overtime in California?

Overtime is when an employee works more than a specified number of hours in a week. It is the additional pay rate paid to employees who work more than a specified number of hours in a week. In California, according to law overtime must be paid at one and a half times their regular rate of remuneration.This law has made to protect workers in weak bargaining positions from being overwork. If you want to know more about it, you can see Overtime California.

Mar 23, 2017 | Computers & Internet

### I paid my bill online but my phone has been turned off?

You will need to contact the phone company/carrier about this issue. We are not equipped to handle such problems. However, remember that even online payments have cutoff hours for acceptance of payments, and even then, some companies can take 2 or 3 days to post online payments depending on day/date paid. If you were facing a cutoff deadline and paid on the very last day, it may have been too late to avoid the shutoff unless you had called customer service and paid thru a representative. They can often accept payments late and abort shutoff orders.

Nov 19, 2015 | Cell Phones

### 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

### 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

### 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:

199 people viewed this question

Level 3 Expert

Level 3 Expert