ASAP!

Have to analyze the excel file and with that data to put into a python code, and make the new excel file with the new data filled out.

Your input file is called, "exercise file"

We want to create an output file with the following items:

Name - Copy from input file

Department - Copy from input file

HI Enrollment - Copy from input file

Rate of Pay / Salary - Copy from input file

Pay Basis - Copy from input file

Hours worked - Copy from input file

Regular Hours - For salaried employees, this is equal to hours worked. For hourly employees, this is hours worked if under 40. If 40 or greater, this is equal to 40.

OT hours - For hourly employees, only, this is hours worked in excess of 40. Salaried employees, this is always zero.

Regular Pay - For Hourly employees, this is Regular Hours times pay rate. for salaried employees, this is rate of pay/salary.

OT Pay - For hourly employees, only, this is overtime hours, times hourly rate, times 1.5. For salaried employees, this is always zero.

Gross Pay - This is regular pay, plus OT pay.

Federal Tax - This is gross pay * .30

State Tax - This is gross pay * .04

Local Tax - This is gross pay * .03

FICA - This is gross pay * .062

Health Insurance - For HI Enrollment F, this is $250. For HI enrollment X, this is $25. For HI enrollment I, this is $100. (F = Family, I = Individual, X = opt-out.)

Total Deductions: This is All taxes, plus health insurance, summed.

Net Pay: This is Gross Pay, minus Total Deductions

Write the file to an output *.xlsx file

Submit your output file and your python file. (*.xlsx and *.py)