Payroll and taxes Math Problem

[sadio]

Okay we have to do this program in visual basic about someone's pay which is affected by there marital status and gender, the question is as follows:

In visual basic the user will enter the following:
- Enter marriage status
- Enter Gender
- Total number of hours worked for the week
- Pay per hour

Gross Pay:

Regular pay if you work less than or equal to 37.5 ( 37 and a half) hours
Time and a half (1.5) if you work between 37.5 to 47.5 hours
Double time (2) if you work over 47.5 hours

Tax:

If you are married:

If Gross Pay =

$0 - $218 - You pay 0% in taxes
$218 - $400 - Taxes is 10% of gross pay
$400 - $600 - Taxes is 20% of gross pay
Greater than $600 - Taxes is 30% of gross pay


If you are single or divorced:

If gross pay is

$0 - $400 - You pay 0% in taxes
$400 - $500 - Taxes is 12% of gross pay
$500 - $700 - Taxes is 18% of gross pay
Greater than $700 - Taxes is 27% of gross pay

CPP

If you are Male:

If your gross pay is:

$0 - $300 - CPP is 2.5% of gross pay
$300 - $500 - CPP is 3.5% of gross pay
$500 - $700 - CPP is 4.5% of gross pay
Greater than $700 - CPP is 5.5% of gross pay

If you are Female:

If your gross pay is:

$0 - $200 - CPP is 2.5% of gross pay
$200 - $500 - CPP is 3% of gross pay
$500 - $800 - CPP is 4% of gross pay
Greater than $800 - CPP is 5% of gross pay

UIC

UIC is 2.5% of gross pay regardless of gener or marriage status.

Net Pay

Net Pay = Gross Pay - Taxes - UIC - CPP


We have to list the following information:

Gender , Marriage Status, Hours Worked, Pay Per House, Gross Pay , Tax , UIC , CPP, and Net Pay.

_________________________________________________________________

The following is an example shown on the sheet

Gender = Male
Marriage Status = Single
Hours Worked = 50
Pay Per Hour = $10
Gross Pay = $600
Tax = $99.98
UIC = $24.00
CPP = $27.00
Net Pay = $ 449.02

I did some calculations using the formulas as followed by got some errors and was wondering if someone can hopefully tell me what I am doing wrong:

Grosspay:
( 37.5 * 10) = $375
+ ( 50-37.5) * (10 * 1.5) = 187.5
- (50 - 47.5) * (10 * 1.5) = - 37.5
+ ( 50 - 47.5) * ( 10 * 1.5 * 2) = 75

375 + 187.5 -37.5 + 75 = $600

Tax:

I tried $600 * .18 but my answer was $108
I also tried (500 * .12) + ( 100 *.18) but my answer was $78 <--Not sure if I went about this right way but I thought that you might have to "tax" the first $500 you earn at one tax rate(12%), and the additional $100 you earn at another tax rate(18%) since when you add the $100 to the 500% its $600 in which if your gross pay is $600 then you go to the next tax bracket. Of course was the the the first $400 is not taxed at all.

Was wondering if I am going about this the right way of if I am totally off track? Or is the answer supplied in the example on the assignment sheet wrong

UIC:

600 * 0.025 = $15

But the answer says $24.00 I wonder if i am doing something wrong here?

CPP

600 * 0.045 = $27

So taxes and UIC I seem to be having trouble with and am hoping someone could possibly help me out.

Thanks in advance

[opus]

hi sadio, I'm with you, the example has to be wrong.

[sadio]

Well, thats what I was thinking that as well but I'm email the prof and see what he says. Just a question though in regards to taxes which method I should use (look above for 2 different methods I used).

I know my method for UIC has to be correct and thank god CPP is right too. Only taxes I am really confused about since there is one and only one way to do UIC.

[opus]

Different countries, differnt ways to do taxes.
But you got an explanation that says:"$218 - $400 - Taxes is 10% of gross pay"
To that'S pretty clear, 10% on the whole amount.
For your second solution the given explanation doesn't fit.

In my country the percentage rises with the grosspay, so you need something like loookup table.