Use input file, input4.xlsx
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
Requirements: as long as it take
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.