Data Table Allowance and Cumulative Earings Before This Payroll Daily Time T w 1 Hourly Rate of Pay Marital Status M F FIT M-1 $ 26,500 8 10 9 6 5 S 20 $ 140 Employee Kent, Parker Diaz, Darby Dean, Reagan Wade Jeremie SO 16.000 4 9 8 9 7 13 57 M-3 71.000 12 8 11 6 13 18 71 S 1 21.500 12 6 12 7 6 26 176 More Info Assume the following: 1. FICA OASDI is 6.2% on $127,200, FICA Medicare is 1.45% on all earnings. 2. Federal income tax has been calculated from a weekly table for you. 3. Each employee contributes $31 weekly for health insurance 4. Overtime is paid at a rate of 1.5 over 40 hours. 5. Kent and Dean work in the office, the other employees work in sales Question 2 The bookkeeper of Samba Co gathered the following data from individual employee earnings records and daily time cards Your task is needed. If a box is not used in the table leave the box empty do not enter a zero. Abbreviations used Allow = Allowances YTD = Year E (Click the icon to view the data) Click the icon to view the assumptions.) Prior W-4 Earnings (YTD) Current Allow Regular Hours Rate Amount Overtime Salary Employee Name Kent, P Diaz, D Dean, R Gross M-1 Hours Rate Amount Earnings (YTD) Pay S-0 M-3 Wade, J S-1 Deductions Employee Name Taxable Earnings FUTA SUTA OASDI FICA Exp. Account Charged Ck Med Net FIT SIT Kent P OASDI Medicare Ins Pay # Office Sales Diaz D Taxable Earnings Deductions Exp. Account Charged FUTA FICA Med Net CK SUTA OASDI FIT SIT OASDI Medicare Ins Pay # Office Sales Employee Name Kent, P Diaz D Dean, R Wade, J