Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management And Cost Accounting

Authors: Colin Drury

6th Edition

1844807037, 978-1844807031

More Books

Students also viewed these Accounting questions

Question

=+ How is it best to target them through apps and mobile web?

Answered: 1 week ago

Question

2. Use different groups for different subjects.

Answered: 1 week ago

Question

Why should a consultants progress be regularly monitored?

Answered: 1 week ago