can you complete please my excel sheet
- All of the employees are paid on a weekly basis on Friday.
- For all voluntary benefits, there is a 50/50 cost sharing agreement.
7. For FUTA, use .08 of the first $7,000 of each employee. For SUTA, use 5.4% of the first $8,500 of each employee.
Dana Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 - A A > General BIU a Av $ % 98 Conditional Format Cell Formatting as Table Styles Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates ex fx B D E F 6 H M N O Erol Fings arty We ST Federe Allerwande From W-4 4 Regular Hours Worked Vacation House She Hours 40103 3 O 1 3 3 3 2 3 4 5 0 0 3 Applie, Suzio Banana, Tim Catalope, Cher Di Sadie Eggplant, Bill Fort, Kyle Gould, Matt Hamm, Mason Igloo Alice Jasper, Alex $10 $96 $15 $20 $17 $12 $192 $14 $15 $15 3 3 3 0 Single married Married Married ead of Househo Single Married Single Married Single 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 400% 4.00% 0 0 50 40 49 47 52 47 35 40 43 28 Overtime Hover Earnings To Purcentage Social Security Media Tax O 6.20% 1.45% 0 6.20% 1.45% O 5.20% 1.45% 0 6.20% 1.45% 0 5.20% 1.45% 8 8 20% 1.45% 0 6.20% 1.45% 0 6.20% 1.45% 15 8.20% 1.45% 10 6.20% 1.45% Insurance Deduction Deller 50.00 20 $8.00 $21.00 $0.00 $0.00 $37.00 $10.00 O $15.00 0 3 3 NNO $0.00 514.00 $12.00 $12.00 $0.00 $15.00 $15.00 $0.00 $15 $10.00 O 9 3 3 0 O 3 AWOSLOPO > y General Insert Delete v WEX = $ % ) 58-98 Conditional Format Cell Formatting as Table Styles Format v s, and improvements, choose Check for Updates. M N O P Q R S T U V w hings 40404 Taxable wages Taxable wages for fedral WM for fedral FICA Fedral WITH State WIHTX Union Deduction Dependent Accident Education Fund Insurance Net Pay Social Security Medicare Tax Tax (Percentagel (Percentage 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1,45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% Insurance Deduction (Dollars $0.00 20 $8.00 $21.00 $0.00 $0.00 $37.00 $10.00 0 $15.00 $0.00 $14.00 $12.00 $12.00 $0.00 $15.00 $15.00 $0.00 $15 $10.00 $0 SO SS $0 $0 $0 $0 SO SO SO $0 $0 $O $5 SO SO SO $0 so SO $0 $0 SO $7 SO $0 SO SO $0 SO Dana Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 - A A > General BIU a Av $ % 98 Conditional Format Cell Formatting as Table Styles Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates ex fx B D E F 6 H M N O Erol Fings arty We ST Federe Allerwande From W-4 4 Regular Hours Worked Vacation House She Hours 40103 3 O 1 3 3 3 2 3 4 5 0 0 3 Applie, Suzio Banana, Tim Catalope, Cher Di Sadie Eggplant, Bill Fort, Kyle Gould, Matt Hamm, Mason Igloo Alice Jasper, Alex $10 $96 $15 $20 $17 $12 $192 $14 $15 $15 3 3 3 0 Single married Married Married ead of Househo Single Married Single Married Single 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 400% 4.00% 0 0 50 40 49 47 52 47 35 40 43 28 Overtime Hover Earnings To Purcentage Social Security Media Tax O 6.20% 1.45% 0 6.20% 1.45% O 5.20% 1.45% 0 6.20% 1.45% 0 5.20% 1.45% 8 8 20% 1.45% 0 6.20% 1.45% 0 6.20% 1.45% 15 8.20% 1.45% 10 6.20% 1.45% Insurance Deduction Deller 50.00 20 $8.00 $21.00 $0.00 $0.00 $37.00 $10.00 O $15.00 0 3 3 NNO $0.00 514.00 $12.00 $12.00 $0.00 $15.00 $15.00 $0.00 $15 $10.00 O 9 3 3 0 O 3 AWOSLOPO > y General Insert Delete v WEX = $ % ) 58-98 Conditional Format Cell Formatting as Table Styles Format v s, and improvements, choose Check for Updates. M N O P Q R S T U V w hings 40404 Taxable wages Taxable wages for fedral WM for fedral FICA Fedral WITH State WIHTX Union Deduction Dependent Accident Education Fund Insurance Net Pay Social Security Medicare Tax Tax (Percentagel (Percentage 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1,45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% 6.20% 1.45% Insurance Deduction (Dollars $0.00 20 $8.00 $21.00 $0.00 $0.00 $37.00 $10.00 0 $15.00 $0.00 $14.00 $12.00 $12.00 $0.00 $15.00 $15.00 $0.00 $15 $10.00 $0 SO SS $0 $0 $0 $0 SO SO SO $0 $0 $O $5 SO SO SO $0 so SO $0 $0 SO $7 SO $0 SO SO $0 SO
