[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
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001013792.zip (25.37 KB)

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)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor