Question Details

[answered] Metropolitan Zoo Gift Shop Department Name No. of Dependent


I need help with my ICS class. On this assignment you must follow the instructions in order to fix an EXCEL document. It must receive an A grade for it to count but can be redone if it ends up being a lower grade.?


Metropolitan Zoo

 

Gift Shop Department Name No. of

 

Dependents Abram

 

Acosta

 

Bordeaux

 

Higinbotham

 

Ianziti

 

Jaussi

 

Ling

 

Munoz

 

Riley

 

Sabey

 

Trujillo

 

Weston

 

Totals 2

 

1

 

3

 

1

 

1

 

1

 

3

 

2

 

3

 

2

 

1

 

2 $9.95

 

$9.55

 

$11.75

 

$11.75

 

$10.00

 

$9.55

 

$15.75

 

$12.25

 

$13.35

 

$10.00

 

$9.95

 

$11.75 Hours

 

Worked $ 40

 

1.5

 

7.65%

 

50.00 Regular Pay Overtime

 

Pay Gross Pay Taxable Pay Federal

 

Withholding

 

Tax FICA Net Pay # of Hours Gross Pay Net Pay Hours # Employees 48

 

48

 

50

 

35

 

40

 

44

 

40

 

20

 

38

 

45

 

15

 

41 Taxable

 

Pay Assumptions

 

Base Work Hours

 

Overtime rate

 

FICA rate

 

Deduct per Depend Hourly

 

Wage $0

 

$250

 

$300

 

$450

 

$525 Tax Rate

 

15%

 

22%

 

25%

 

28%

 

31% Notes

 

1. The base workweek is 40 hours. Regular pay is based on hourly wage and hours worked up to 40.

 

2. Overtime pay is based on overtime hours, the hourly wage, and the overtime rate.

 

3. The gross pay is the total of the regular pay and overtime pay.

 

4. The taxable pay is the difference between the gross pay

 

and the product of the number of dependents and deduction per dependent.

 

5. Federal withholding tax is calculated on the taxable pay based on the tax table.

 

6. FICA is calculated on the employee's gross pay.

 

7. The net pay is based on the gross pay, federal withholding tax, and FICA. Summary

 

Statistics

 

Average

 

Highest

 

Lowest Bin 0-19

 

20-29

 

30-40

 

Over 40

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001013792.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 copy from our tutoring website www.aceyourhomework.com (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

Sep 18, 2020

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 YOUR SET DEADLINE.

Order Now