Answers to problem 11 3a in accounting

Pr. 11-3A
Problem 11-3A
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24," ")
43
Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24," ")
0
Key Code: [Key code here] Total SUM(AD13:AD15)
Instructions 43
Answers are entered in the cells with gray backgrounds. Percentage =(AD16-AD13-AD14)/AD16
Cells with non-gray backgrounds are protected and cannot be edited. 0%
An asterisk (*) will appear to the right of an incorrect entry. Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or blank-entry box is incorrect, returns "*"
1. If number-entry or blank-entry box is correct, returns single space, " "
Amounts to Be Reported on Wage and Tax Statements (Form W-2) Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Gross Federal Income Social Security Medicare
Employee Earnings Tax Withheld Tax Withheld Tax Withheld
Arnett
Cruz
Edwards
Harvin
Nicks
Shiancoe
Ward
Totals
2.
Employer Payroll Taxes
a. Social security tax paid by employer
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
Sol
Problem 11-3A
Name: Solution
Section:
Score: ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
1.
Amounts to Be Reported on Wage and Tax Statements (Form W-2)
Gross Federal Income Social Security Medicare
Employee Earnings Tax Withheld Tax Withheld Tax Withheld
Arnett $ 8,250.00 $ 1,416.00 $ 495.00 $ 123.75
Cruz 57,600.00 9,996.00 3,456.00 864.00
Edwards 24,000.00 4,776.00 1,440.00 360.00
Harvin 6,000.00 1,070.00 360.00 90.00
Nicks 110,000.00 25,850.00 6,600.00 1,650.00
Shiancoe 116,000.00 26,000.00 6,960.00 1,740.00
Ward 7,830.00 1,314.00 469.80 117.45
Totals $ 329,680.00 $ 19,780.80 $ 4,945.20
2.
Employer Payroll Taxes
a. Social security tax paid by employer $ 19,780.80
b. Medicare tax paid by employer 4,945.20
c. and d.
SUTA/FUTA
Employee Earnings
Arnett $ 8,250.00
Cruz 10,000.00
Edwards 10,000.00
Harvin 6,000.00
Nicks 10,000.00
Shiancoe 10,000.00 State unemployment compensation tax 3,352.32
Ward 7,830.00
Total $ 62,080.00 Federal unemployment compensation tax 372.48
e. Total employer payroll taxes $ 28,450.80