Question
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started