Payroll Tax Calculations
Not what you're looking for?
Please see both tabs in the attached file.
Given Data P11-04A:
PALOMA CO.
Tax Rate Applied to
FICA-Social Security 6.20% First $94,200
FICA-Medicare 1.45% Gross pay
FUTA 0.80% First 7,000
SUTA 2.15% First 7,000
Gross
Pay Current Week
through Gross WH
Name 8/18 Pay Tax
Dahlia $93,400 $2,800 $284
Trey 31,700 1,000 145
Kiesha 6,850 550 39
Chee 1,250 500 30
Weekly health insurance premium $34
Percentage of gross earnings contributed
by employer to pension fund 8%
Check figures:
(3) $176.70
(4) 70.33
(5) 5.20
(7) Total net pay 4,036.97
Purchase this Solution
Solution Summary
This solution is an Excel Spreadsheet with calculations of payroll taxes and deductions to net pay.
Solution Preview
Attached is the spreadsheet in complete form. The difficulty is that there is some sort of discrepancy between the amount shown as the weekly deduction for health insurance and the amount deducted according to the set up of the problem. If the problem set up is correct the weekly deduction for health insurance is $17 and not $34. That sort of discrepancy can be time consuming.
As for the rest of the problem the excel worksheet is set up so that the student merely inputs the data where it belongs.
The first key piece of information needed to transition from ...
Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.