Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Answers to problem 11 3a in accounting

07/10/2021 Client: muhammad11 Deadline: 2 Day

Problem 11-3A - Due In 24 Hours

Complete the attached, Problem 11-3A Template. Please refer to Ch. 11 in your textbook for detailed instructions

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

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignment Writer
Top Academic Tutor
Accounting & Finance Specialist
Math Specialist
Smart Tutor
Essay & Assignment Help
Writer Writer Name Offer Chat
Instant Assignment Writer

ONLINE

Instant Assignment Writer

Give me a chance, i will do this with my best efforts

$27 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I have read and understood all your initial requirements, and I am very professional in this task.

$46 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$45 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I will cover all the points which you have mentioned in your project details.

$29 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$20 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I have read and understood all your initial requirements, and I am very professional in this task.

$44 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Translational Research And Population Health Management - Student success in college doing what works pdf - How to make a pyramid foldable - Therese raquin emile zola pdf - Nursing student goals and objectives examples - Http faculty washington edu herronjc softwarefolder allelea1 html - Revex s20 coaxial switch price - Ana scope and standards of practice and continuing education - A certain anesthetic contains 64.9 percent c - Chemical formula of copper wire - Pos409 - Dna replication and protein synthesis crossword answers - Needed in 12 hours - Acconting - Pdms 2 reliability and validity - Discussion Question Assignment - REP 2 - A doll's house questions - HCS/341: Wk 1 DQ - Bsbwor502b answers - How to draw a constellation diagram - True or false questions and answers list - Discussion-1 MF - C06 Online Exam 7_10 SCORE 100 PERCENT - Mental health nursing process recording example - Risksimtable - The embalming of mr jones comprehension - Lum head primary school - Imp's cold sweat battle cats - The words under god added to the pledge of allegiance - St johns first aid adamstown - Please see attachment - Cca tax shield formula - How to use a cutting torch to cut metal - Worldview and nursing process personal statement - Http extras denverpost com archive captured asp - Characters in jasper jones - Week 1 Discussion - Principles of managements and organization - Juiced 1 ps2 cheats - Books to read for accounting and finance personal statement - Elderly - 550 word essay - Which of the following best describes relationship conflict - John westling walmart - Marketing exam - Fema is 120 c an introduction to exercises answers - Mcmi iii inconsistency scale w - Doppler radar speed sensor - Console into cisco switch with mac - Runcorn road dialysis unit - Hallelujah ultimate guitar rufus wainwright - Hominin Toolkit Worksheet - I need 3000 words Marketing Plan - 0.76666 as a fraction - Information System and Technology - The electron configuration of potassium - Kol balish english meaning - Inventory Management - Discussion - The drawing shows a lower leg being exercised - Translucent transparent and opaque - The zone of proximal development vygotsky - In establishing warranties on hdtv sets - Child abuse and/or neglect - Wipo romarin international registration - What danger does the narrator discover after attacking the waitress - Ford d albritton jr - Trevor noah world war d - Braun clarke thematic analysis - Pocket god episode 40 take a hint from the vampires - Maths week 9 - Casee - Astrand rhyming cycle ergometer test - 18 cross road myrtle bank - Working with employees - portfolio assignment - Response Required Discussion cloud DBA - Which angle does not terminate in quadrant iv - Managing organizations for sport and physical activity 4th edition pdf - Paper - Shock response spectrum matlab - Alfred health staff email - Journal #1 - Swansea bay campus map - Everest simulation environmentalist - Organizational Communication - Cert IV TAE - Vegapuls wl 61 manual - Retained earnings end of year - Heart failure concept map - What is loading effect - 2 - 7.2 3.7 lab troubleshooting advanced eigrp - Maria nguyen dentist camden - Three phases of systemic formulation - Humanistic personality analysis - Simnet access independent project 1 5 - Social Work Process Recording - What residue is prevented by cleaning floor surfaces - Human observation project