Please complete the payroll document using the directions that are attached IN EXCEL

Turn this data range into a table of your choice Calculate Gross Pay = Hourse worked x Rate Calculate FICA Tax = Gross Pay x 7.65\% Calculate 401K amounts that the company is providing = Gross Pay x Column G Calculate Net Pay = Gross Pay - Medical insurance FICA Tax - 401K Company Calculate New Wage Increase = Raise increase %x Rate Calculate New Wage = Rate + New Wage Increase Calculate New Gross Pay = New wage x Hours Worked Create a total row at the bottom that shows total hours worked, Medical Insurance, Gross pay, FICA Tax, 401K Company, Net pay and New Gross Pay Create a pie chart of your choice that shows the breakdown of net pay for each employee Turn this data range into a table of your choice Calculate Gross Pay = Hourse worked x Rate Calculate FICA Tax = Gross Pay x 7.65\% Calculate 401K amounts that the company is providing = Gross Pay x Column G Calculate Net Pay = Gross Pay - Medical insurance FICA Tax - 401K Company Calculate New Wage Increase = Raise increase %x Rate Calculate New Wage = Rate + New Wage Increase Calculate New Gross Pay = New wage x Hours Worked Create a total row at the bottom that shows total hours worked, Medical Insurance, Gross pay, FICA Tax, 401K Company, Net pay and New Gross Pay Create a pie chart of your choice that shows the breakdown of net pay for each employee