CIST2311 – Visual Basic Programming I Project 1 Employees Weekly Pay

Description

CIST2311 – Visual Basic Programming I Project 1 Employees Weekly Pay

Create a program that will calculate employee’s weekly pay as follows:
Inputs:
1) Name
2) Hourly Rate of Pay ($ / hour)
3) Marital Status (Married, Single)
4) # of Dependents
5) Healthcare (Yes or No)
6) Hours worked

Outputs:
1) Gross pay (Hours over 40 are paid at time and ½)
2) Health Insurance Amount
3) Federal Tax, calculated as follows:
A. From gross taxable pay subtract $70 for each dependent
B. From value in A subtract appropriate value in Standard Deduction Column from table below to give taxable gross.
C. Tax at rate of 10% appropriate amount in 10% Column from table below.
D. Tax at rate of 15% appropriate amount in 15% Column from table below.
E. Tax at rate of 25% appropriate amount in 25% Column from table below.
F. Tax at rate of 35% remaining amount (if any) in 35% Column from table below.
Marital Status Deductions Tax Rates
Medical Standard 10% 15% 25% 35%
Single $60 $75 <=$100 $101-$250 $251-$400 >$400
Married $100 $150 <=$200 $201-$500 $501-$800 >$800
4) Net Pay (Gross Pay – Health Care Deduction (if any) – Federal Tax).
5) If any of the inputs are unreasonable, tell user with a message and force reentry of the data.

Additional Requirements:
1) Name any control that is referenced in code with a meaningful name
2) Use functions for major tasks
a. Calculate Gross Pay
b. Calculate Health Deductions
c. Calculate Tax
3) Other than constants, do NOT use global variables (e.g. You need to pass variable between functions through the argument list and the return value).
4) Comment each function and variable and major sections of code.
5) Submitting a program that does not compile is an automatic 20 point deduction.

Tax Calculation Pseudocode
The following is one possible pseudocode for calculating the tax. There are many ways to implement this code, any that work are acceptable.

Assume that variable GrossPay is the calculated total pay for individual. All the constants are from the table on the previous page:
If married
TaxablePay = GrossPay – 150 – 70.0 * NumberDependents
if healthcare
TaxablePay = TaxablePay – 100
if TaxablePay > 800
Tax = (TaxablePay – 800) * .35 + (800 – 500) * .25 + (500 – 200) * .15 +200 * .10
else if TaxablePay > 500 Tax = (TaxablePay – 500) * .25 + (500 – 200) * .15 +200 * .10
else if TaxablePay > 200 Tax = (TaxablePay – 200) * .15 +200 * .10
else Tax = TaxablePay * .10
else TaxablePay = GrossPay – 75 – 70.0 * NumberDependents
if healthcare TaxablePay = TaxablePay – 60
if TaxablePay > 400 Tax = (TaxablePay – 400) * .35 + (400 – 250) * .25 + (250 – 100) * .15 +100 * .10
else if TaxablePay > 250 Tax = (TaxablePay – 250) * .25 + (250 – 100) * .15 +100 * .10
else if TaxablePay > 100 Tax = (TaxablePay – 100) * .15 +100 * .10
else Tax = TaxablePay * .10

Examples:
1. A married employee with 45 hours at $20.00/hour, 2 dependents and health care:
A. Gross Pay: 40 * 20.00 + 5 * 20.00 * 1.5 = $950.00
B. Minus Standard Deduction of $150.00 = 800.00
C. Minus Medical Deduction of $100.00 = $700.00
D. Minus 2 dependents (@$70) = $560.00
E. Tax at 10% Bracket = 200 * .10 = $20.00
F. Tax at 15% Bracket ($500 – $200) = 300 * .15 = $45.00
G. Tax at 25% Bracket ($560 – $500) = $60.00 * .25 = $15.00
H. Total Tax = $20 + $45 + $15.00 = $80.00
I. Net Pay = 950.00 – $100.00 (Medical) – $80.00 (Tax) = $770.00
2. A single employee with 45 hours at $20.00/hour, 1 dependent and no health care:
A. Gross Pay: 40 * 20.00 + 5 * 20.00 * 1.5 = $950.00
B. Minus Standard Deduction of $75.00 = 875.00
C. Minus 1 dependent (@$70) = $805.00
D. Tax at 10% Bracket = 100 * .10 = $10.00
E. Tax at 15% Bracket ($250 – $100) = $150.00 * .15 = $22.5
F. Tax at 25% Bracket ($400 – $250) = $150.00 * .25 = $37.5
G. Tax at 35% Bracket ($805 – $400) = $405 * .35 = $141.75
H. Total Tax = $10 + $22.50 + $37.50 + 141.75 = $211.75
I. Net Pay = 950.00 – $0.00 (Medical) – $211.75 (Tax) = $738.25