I have an excel homework I need help with. Here is the instructions and excel sheet needed.
Chapter 7 & 8 Written Test
Part I. The payroll clerk of XYZ Company gathered the following data from the individual employee
earnings records. Your task is to complete a payroll register on March 30. Employee Allowance &
Marital Status Eric Wood
Susie Que S-0
$2,080 Check No. Department 29
Office Assume the following:
6. FICA OASDI is 6.2% on $106,800; FICA Medicare is 1.45% on all earnings.
State income tax rate is 5%.
The SUTA tax rate is 5.4% on the first $7,000.
The FUTA tax rate is .8% on the first $7,000 of earnings.
Each employee contributes $25 biweekly for union dues.
Eric and John work in the factory while Susie is the manager and considered to work in the
office. Part II.
a. Using the same account title headings from the payroll register, prepare the general journal
entry to record the March 30 payroll.
b. Journalize the entry to record the employer?s payroll tax expense for March 30 payroll.
c. Journalize the entry to record the payment of the March 30 payroll on April 10.
d. Journalize the entry to record the payment of the federal taxes on April 15.
This question was answered on: Jan 30, 2021
Buy this answer for only: $15
This attachment is locked
We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)
Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this QuestionSTATUS
Jan 30, 2021EXPERT
GET INSTANT HELP/h4>
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions:
- As a reference for in-depth understanding of the subject.
- As a source of ideas / reasoning for your own research (if properly referenced)
- For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
NEW ASSIGNMENT HELP?
Order New Solution. Quick Turnaround
Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.
WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.