Question: Input file: 2) Your mission is to create an awk file that will report employee name, state, gross pay, taxes, and net pay in a

 Input file: 2) Your mission is to create an awk file

Input file:

that will report employee name, state, gross pay, taxes, and net pay

2) Your mission is to create an awk file that will report employee name, state, gross pay, taxes, and net pay in a specific format. The input file has the following fields: State Pay Raite Hoskd Oventime Hours Name Hours Worked Overtime Hours There is math involved. The pay rate is the hourly pay rate - different for each employee. Overtime hours are paid at 1.5 times base rate ((OT Hours * 1.5) Pay Rate). Gross Pay = (Hours worked + (Overtime Hours * 1.5)) * Pay Rate. Taxes are computed at 8% (0.08) for State-MO and 7% for State = KS. Net Pay Gross Pay-Taxes The output should look like the following: Name Sam Smith MO Gross Pay: $1690 Taxes Net Pay: $1554.8 $135.2 Send me the link to your awk file (I will run it with the awk -f command)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!