Computers & Internet Logo

Related Topics:

Posted on Aug 12, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

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%.

  • Anonymous Mar 27, 2014

    Need list for tax preparation

×

3 Answers

Westea49

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

  • Contributor 4 Answers
  • Posted on Dec 31, 2014
Westea49
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Joined: Nov 21, 2014
Answers
4
Questions
0
Helped
2168
Points
4

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.

A

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

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
  • Posted on Aug 29, 2008
Anonymous
Expert
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.

Joined: May 27, 2008
Answers
79
Questions
0
Helped
24268
Points
158

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.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

What the company offer me after the jobs done? and do you offer overtime? and how many peoples in your department? and after to long a must wait for job?

hi
o meet deadlines, some times one is forced for work on long hours every day. Some people work overtime regularly, and it helps them to learn some extra income.
If working overtime or working for long hours on a regular basis, what may be their impact on an employee?
Has any study been done on this?! Your views are welcome!
Best wishes, Sundar
0helpful
1answer

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
0helpful
1answer
0helpful
1answer

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.
3helpful
3answers

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.
Not finding what you are looking for?

235 views

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...