978-1337398169 Chapter 10 Excel

subject Type Homework Help
subject Pages 12
subject Words 1453
subject Authors Carl Warren, Jeff Jones

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
An asterisk (*) will appear to the right of an incorrect entry.
a.
Earnings:
1. At regular rate
2. At overtime rate 80,000
3. Total earnings
Deductions:
4. Social security tax 32,400$
5. Medicare tax 8,100
6. Income tax withheld 135,000
7. Medical insurance 18,900
8. Union dues
9. Total deductions 201,150$
10. Net amount paid 338,850$
Accounts debited:
11. Factory Wages 285,000
12. Sales Salaries
13. Office Salaries 120,000
b.
Answers are entered in the cells with gray backgrounds.
Exercise 10-10
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
c.
An asterisk (*) will appear to the right of an incorrect entry.
a.
Employer's Payroll Taxes:
Rate
Social security tax
Medicare tax
State unemp. tax
Federal unemp. tax
Total
b.
Answers are entered in the cells with gray backgrounds.
Exercise 10-11
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Amount
Subject to Tax
Tax
An asterisk (*) will appear to the right of an incorrect entry.
1.
Gross Federal Income Social Security Medicare
Employee Earnings Tax Withheld Tax Withheld Tax Withheld
Arnett
Cruz
Edwards
Harvin
Nicks
Shiancoe
Ward
Totals
2.
a. Social security tax paid by employer
Problem 10-3A
Name:
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
Amounts to Be Reported on Wage and Tax Statements (Form W-2)
Employer Payroll Taxes
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
b. Medicare tax paid by employer
c. and d.
SUTA/FUTA
Employee Earnings
Arnett
Cruz
Edwards
Harvin
Nicks
Shiancoe State unemployment compensation tax
Ward
Total Federal unemployment compensation tax
e. Total employer payroll taxes
An asterisk (*) will appear to the right of an incorrect entry.
1.
Gross Federal Income Social Security Medicare
Employee Earnings Tax Withheld Tax Withheld Tax Withheld
Addai
Kasay
McGahee
Moss
Stewart
Tolbert
Wells
Totals
2.
a. Social security tax paid by employer
Problem 10-3B
Name:
Section:
Cells with non-gray backgrounds are protected and cannot be edited.
Amounts to Be Reported on Wage and Tax Statements (Form W-2)
Employer Payroll Taxes
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
b. Medicare tax paid by employer
c. and d.
SUTA/FUTA
Employee Earnings
Addai
Kasay
McGahee
Moss
Stewart
Tolbert State unemployment compensation tax
Wells
Total Federal unemployment compensation tax
e. Total employer payroll taxes
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
1.
Social Federal U.S. Sales Office
Total Security Medicare Income Savings Net Ck. Salaries Salaries
Name Hours Regular Overtime Total Tax Tax Tax Bond Total Amount No. Expense Expense
Aaron 46
Cobb 41
Clemente 48
DiMaggio 35
Griffey, Jr. 45
Mantle
Robinson 36
Williams
Vaughn 42
2.
Answers are entered in the cells with gray backgrounds.
Problem 10-4A
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
PAYROLL FOR WEEK ENDING December 9
EARNINGS
DEDUCTIONS
PAID
ACCOUNTS DEBITED
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
1.
Social Federal U.S. Sales Office
Total Security Medicare Income Savings Net Ck. Salaries Salaries
Name Hours Regular Overtime Total Tax Tax Tax Bond Total Amount No. Expense Expense
Carlton 52
Grove
Johnson 36
Koufax 45
Maddux 37
Seaver
Spahn 46
Winn 48
Young 43
2.
Answers are entered in the cells with gray backgrounds.
Problem 10-4B
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
PAYROLL FOR WEEK ENDING December 9
EARNINGS
DEDUCTIONS
PAID
ACCOUNTS DEBITED

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.