Question
The following data for Flexco Inc. relate to the payroll for the week ended December 9: Hours Hourly Weekly Federal U.S. Savings Employee Worked Rate
The following data for Flexco Inc. relate to the payroll for the week ended December 9:
Hours | Hourly | Weekly | Federal | U.S. Savings | ||||||
Employee | Worked | Rate | Salary | Income Tax | Bonds | |||||
Carlton | 52 | $50.00 | $667.00 | $60 | ||||||
Grove | $4,000 | 860.00 | 100 | |||||||
Johnson | 36 | 52.00 | 355.68 | 0 | ||||||
Koufax | 45 | 58.00 | 578.55 | 44 | ||||||
Maddux | 37 | 45.00 | 349.65 | 62 | ||||||
Seaver | 3,200 | 768.00 | 120 | |||||||
Spahn | 46 | 52.00 | 382.20 | 0 | ||||||
Winn | 48 | 50.00 | 572.00 | 75 | ||||||
Young | 43 | 54.00 | 480.60 | 80 |
Employees Grove and Seaver are office staff, and all of the other employees are sales personnel. All sales personnel are paid 1 times the regular rate for all hours in excess of 40 hours per week. The social security tax rate is 6.0% of each employees annual earnings, and Medicare tax is 1.5% of each employees annual earnings. The next payroll check to be used is No. 328.
Required:
1. Prepare a payroll summary for Flexco Inc. for the week ended December 9. Assume the normal working hours in a week are 40 hours. Enter amounts as positive numbers. Round your intermediate calculations and final answers to the nearest whole cent (two decimal places).
Payroll for Week Ending December 9 | |||||||||||||
EARNINGS | DEDUCTIONS | PAID | ACCOUNTS DEBITED | ||||||||||
Employee | Total Hours | Regular | Overtime | Total | Social Security Tax | Medicare Tax | Federal Income Tax | U.S. Savings Bonds | Total | Net Pay | Ck. No. | Sales Salaries Expense | Office Salaries Expense |
Carlton | 52 | $fill in the blank 2ff2c2090fe6fd9_1 | $fill in the blank 2ff2c2090fe6fd9_2 | $fill in the blank 2ff2c2090fe6fd9_3 | $fill in the blank 2ff2c2090fe6fd9_4 | $fill in the blank 2ff2c2090fe6fd9_5 | $667.00 | $60.00 | $fill in the blank 2ff2c2090fe6fd9_6 | $fill in the blank 2ff2c2090fe6fd9_7 | 328 | $fill in the blank 2ff2c2090fe6fd9_8 | |
Grove | fill in the blank 2ff2c2090fe6fd9_9 | fill in the blank 2ff2c2090fe6fd9_10 | fill in the blank 2ff2c2090fe6fd9_11 | fill in the blank 2ff2c2090fe6fd9_12 | 860.00 | 100.00 | fill in the blank 2ff2c2090fe6fd9_13 | fill in the blank 2ff2c2090fe6fd9_14 | 329 | $fill in the blank 2ff2c2090fe6fd9_15 | |||
Johnson | 36 | fill in the blank 2ff2c2090fe6fd9_16 | fill in the blank 2ff2c2090fe6fd9_17 | fill in the blank 2ff2c2090fe6fd9_18 | fill in the blank 2ff2c2090fe6fd9_19 | 355.68 | fill in the blank 2ff2c2090fe6fd9_20 | fill in the blank 2ff2c2090fe6fd9_21 | 330 | fill in the blank 2ff2c2090fe6fd9_22 | |||
Koufax | 45 | fill in the blank 2ff2c2090fe6fd9_23 | fill in the blank 2ff2c2090fe6fd9_24 | fill in the blank 2ff2c2090fe6fd9_25 | fill in the blank 2ff2c2090fe6fd9_26 | fill in the blank 2ff2c2090fe6fd9_27 | 578.55 | 44.00 | fill in the blank 2ff2c2090fe6fd9_28 | fill in the blank 2ff2c2090fe6fd9_29 | 331 | fill in the blank 2ff2c2090fe6fd9_30 | |
Maddux | 37 | fill in the blank 2ff2c2090fe6fd9_31 | fill in the blank 2ff2c2090fe6fd9_32 | fill in the blank 2ff2c2090fe6fd9_33 | fill in the blank 2ff2c2090fe6fd9_34 | 349.65 | 62.00 | fill in the blank 2ff2c2090fe6fd9_35 | fill in the blank 2ff2c2090fe6fd9_36 | 332 | fill in the blank 2ff2c2090fe6fd9_37 | ||
Seaver | fill in the blank 2ff2c2090fe6fd9_38 | fill in the blank 2ff2c2090fe6fd9_39 | fill in the blank 2ff2c2090fe6fd9_40 | fill in the blank 2ff2c2090fe6fd9_41 | 768.00 | 120.00 | fill in the blank 2ff2c2090fe6fd9_42 | fill in the blank 2ff2c2090fe6fd9_43 | 333 | fill in the blank 2ff2c2090fe6fd9_44 | |||
Spahn | 46 | fill in the blank 2ff2c2090fe6fd9_45 | fill in the blank 2ff2c2090fe6fd9_46 | fill in the blank 2ff2c2090fe6fd9_47 | fill in the blank 2ff2c2090fe6fd9_48 | fill in the blank 2ff2c2090fe6fd9_49 | 382.20 | fill in the blank 2ff2c2090fe6fd9_50 | fill in the blank 2ff2c2090fe6fd9_51 | 334 | fill in the blank 2ff2c2090fe6fd9_52 | ||
Winn | 48 | fill in the blank 2ff2c2090fe6fd9_53 | fill in the blank 2ff2c2090fe6fd9_54 | fill in the blank 2ff2c2090fe6fd9_55 | fill in the blank 2ff2c2090fe6fd9_56 | fill in the blank 2ff2c2090fe6fd9_57 | 572.00 | 75.00 | fill in the blank 2ff2c2090fe6fd9_58 | fill in the blank 2ff2c2090fe6fd9_59 | 335 | fill in the blank 2ff2c2090fe6fd9_60 | |
Young | 43 | fill in the blank 2ff2c2090fe6fd9_61 | fill in the blank 2ff2c2090fe6fd9_62 | fill in the blank 2ff2c2090fe6fd9_63 | fill in the blank 2ff2c2090fe6fd9_64 | fill in the blank 2ff2c2090fe6fd9_65 | 480.60 | 80.00 | fill in the blank 2ff2c2090fe6fd9_66 | fill in the blank 2ff2c2090fe6fd9_67 | 336 | fill in the blank 2ff2c2090fe6fd9_68 | |
Totals | $fill in the blank 2ff2c2090fe6fd9_69 | $fill in the blank 2ff2c2090fe6fd9_70 | $fill in the blank 2ff2c2090fe6fd9_71 | $fill in the blank 2ff2c2090fe6fd9_72 | $fill in the blank 2ff2c2090fe6fd9_73 | $fill in the blank 2ff2c2090fe6fd9_74 | $fill in the blank 2ff2c2090fe6fd9_75 | $fill in the blank 2ff2c2090fe6fd9_76 | $fill in the blank 2ff2c2090fe6fd9_77 | $fill in the blank 2ff2c2090fe6fd9_78 | $fill in the blank 2ff2c2090fe6fd9_79 |
2. Journalize the entry to record the payroll for the week. If an amount box does not require an entry, leave it blank. When required, round answers to the nearest whole cent (two decimal places).
Medicare Tax ExpenseSalaries PayableSales Salaries ExpenseSocial Security Tax PayableU.S. Savings Bond Deductions Payable | - Select - | - Select - | |
Medicare Tax ExpenseOffice Salaries ExpenseSalaries PayableSocial Security Tax PayableU.S. Savings Bond Deductions Payable | - Select - | - Select - | |
CashOffice Salaries ExpenseSales Salaries ExpenseSocial Security Tax ExpenseSocial Security Tax Payable | - Select - | - Select - | |
CashMedicare Tax ExpenseMedicare Tax PayableOffice Salaries ExpenseSales Salaries Expense | - Select - | - Select - | |
CashEmployees Federal Income Tax ExpenseEmployees Federal Income Tax PayableOffice Salaries ExpenseSales Salaries Expense | - Select - | - Select - | |
CashOffice Salaries ExpenseSales Salaries ExpenseU.S. Savings Bond Deductions ExpenseU.S. Savings Bond Deductions Payable | - Select - | - Select - | |
Accounts ReceivableCashOffice Salaries ExpenseSalaries PayableSales Salaries Expense | - Select - | - Select - |
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