Question Details

(solution) I have an excel homework I need help with. Here is the


I have an excel homework I need help with.  Here is the instructions and excel sheet needed.  


Office Accounting

 

Chapter 7 & 8 Written Test

 

Directions:

 

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

 

John Doe

 

Susie Que S-0

 

S-3

 

S-1 Cumulative

 

Earnings

 

Before This

 

Payroll

 

$5,600

 

$50,000

 

$101,000 Biweekly

 

Salary $800

 

$2,000

 

$2,080 Check No. Department 29

 

30

 

31 Factory

 

Factory

 

Office Assume the following:

 

1.

 

2.

 

3.

 

4.

 

5.

 

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.

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jan 30, 2021

PRICE: $15

Solution~0001017648.zip (25.37 KB)

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 .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 30, 2021

EXPERT

Tutor

ANSWER RATING

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).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

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.

Order Now