Payroll and taxes Math Problem

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

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

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.

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.