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

Ib chem data booklet - Iom future of nursing summary - 1960 harold pinter play - When was the styrofoam cup invented - Bargaining power of buyers netflix - Research assignment - PP2 - Vashikaran Specialist In Mumbai +917657874622 - Is gd ctcsurvey - Hbr airbnb - Human resource management case study with solution - Darrell lea hard centred chocolates - Results Section of the Thesis - I Need 1500 words on solution an International Management (BUSS 1006)-CW3-Fall-19-QP - Management information system - Case Study: Patricia Brenner theory - Romeo and juliet references in songs - Public health 101 healthy people healthy populations pdf - Mil std 810f 516.5 - Analyze the behavioral implications of different organizational designs - Housekeeping chapter 5 summary - Swot analysis for beddown - Government and not for profit accounting 6th edition - InfoTech Import in Strat Plan (ITS-831) - Tax and Zakat Accounting - Knightswood inn alderman road - Type out what I need to say on the video - Cyte suffix meaning - 48 hour edge tamer walmart - Calculate protein concentration using extinction coefficient - Kaplan psychiatric nursing integrated - Capstone - Sf xtra sound attenuator ventilator - Age of calamitous loyalty vendor - Research paper on jeffrey dahmer - NEED DONE IN 2 HOURS! - Mla format speech outline template - Aqa gcse physics equations - Exercise 2 10 preparing a trial balance lo p2 - Ashworth college medical coding - What is the average value of a loyal customer vlc - Week 1 Discussion - How long to leave tca peel on - Sodium borohydride reduction procedure - Manual pipe rolling machine - Comminutors in wastewater treatment - Modulus argument form to cartesian form - Ethics Module 5 - Examples of self actualization in movies - University college dublin english courses - The last of us walkthrough - Any numbers to be summated - A monopoly misallocates resources when it - Rules of engagement outtakes youtube - Luis and clark viola - Bargaining power of suppliers tesla - What is a category captain - Robert lindneux trail of tears - 4 2/9 - 1 7/9 - Wages expense vs salaries expense - Tax Question - Ultimate body applicator does it work - Pendle community high school - On course study skills plus 2nd edition pdf - Case study supply and demand - Ritz carlton five star employee award - The most popular pizza at pavone's pizza - Structural strain theory social movements - Examples of empirical knowledge in nursing - Who moved my cheese discussion - Discussion: When the People You Love Don’t Think Like You - Discussion: Pediatric Bipolar Depression Disorder Debate Week 8 - 2x 75 WORD POSITIVE FEEDBACK RESPONSE DUE 10/4 - Economics homework - Aws direct connect configuration - Success factors payroll kmart - Dulux duramax spray paint - Uni of glos moodle - How to protect your company from being salted by union - Hofstra law first assignments - Cw williams health center - Monash residential services email - Tall sided origami box - Citing multiple chapters in a book apa - Fedex mission statement analysis - Blue stream academy elearning - Nursing Evolution - Neal st medical centre gisborne - COURSE PROJECT - DELIVERABLE #1- $50.00 - Cca tax shield formula - Breakthroughs in Online Casino Technology - Post- Rett syndrome - Unit 1 IP Project 2 - Create a hair and beauty image - Btec business level 3 unit 4 m1 - Silver nitrate reacts with sodium carbonate - Bob lazar lie detector test - Health promotion model nursing theory - 10 pages - Artificial Intelligence (AI) and Business - IT Course from MBA Program - quality work needed and must follow the instructions - Celestron powerseeker 127eq collimation