Write a payroll processing program. Input will be from a file called “weeklyData.txt”. You may create this file on your own for testing purposes, but I have provided a file with 75 employees that I will use to test your code. (I know what it should produce).

Each line in the file contains information about one employee. Each item is separated by a space. The items are, in order:

First Name

Last Name

Hourly wage rate (decimal)

Hours worked (decimal)

# of dependents (whole number)

For each employee listed in this file, read the above data and produce the following detail data:

Regular hours worked and overtime hours worked

Regular pay and overtime pay and gross pay

Insurance deduction and Income tax deduction

Net pay

Calculations:

Overtime hours are all hours over 40, the rest are regular hours

Regular pay is the regular hours times the wage rate

Overtime pay is 1.5 times the overtime hours times the wage rate

Insurance is determined by the number of dependents:

0 is $25.19

1 is $39.02

2 or more is $50.63

Income tax is calculated as follows.

The first $300 dollars is not taxed

The next $500 is taxed at 5% of gross

Everything over $800 is taxed at 8.5% of gross

Net pay is gross pay minus the two deductions (tax and insurance)

The detail output should be to a file called “payroll.txt” formatted nicely, and include the three input values as well as all calculated values. Separate each employee’s detail data in the file as you see fit.

Here are two lines of a sample input file

Kelvin Fowler 37.45 40.00 1

Shea Torres 31.19 49.75 4

and suggested output:

Pay stub for Fowler, Kelvin (Dependents: 1)

Hours: 40.00 (regular: 40.00 Overtime: 0.00)

Hourly Rate: $37.45

Gross pay: $1498.00 (Regular: $1498.00 Overtime: $0.00)

Deductions:

Insurance: $39.02

Taxes: $84.33

Total Deductions: $123.35

Net Pay: $1374.65

*************************

Pay stub for Torres, Shea (Dependents: 4)

Hours: 49.75 (regular: 40.00 Overtime: 9.75)

Hourly Rate: $31.19

Gross pay: $1703.75 (Regular: $1247.60 Overtime: $456.15)

Deductions:

Insurance: $50.63

Taxes: $101.82

Total Deductions: $152.45

Net Pay: $1551.30

*************************

Summary data should include the following (and should be printed at the end of the detail data in the output file, as well as to the screen.

# of employees

Total payroll (sum of all gross pay), and of that how much was overtime

Total hours worked, and of that how many were overtime hours

Total insurance premiums

Total taxes withheld

Sample summary from detail data above:

# of employees: 2

Total hours: 89.75 Overtime hours: 9.75

Total gross pay: $3201.75 Overtime pay: $456.15

Total insurance withheld: $89.65 Taxes withheld: $186.15