Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer using microsoft excel and show formulas used. thank you 4 Cougar Corp. has 17 hourly employees eaming $16.50 per hour. Last week each

please answer using microsoft excel and show formulas used. thank you image text in transcribed
image text in transcribed
image text in transcribed
4 Cougar Corp. has 17 hourly employees eaming $16.50 per hour. Last week each employee worked 40 hours. The FICA rate is 7.65%, federal income tax is withheld at an average of 13%, there is no state tax, the State Unemployment (SUTA) rate is 2.5% and the Federal Unemployment (FUTA) tax rate is 1.15%. Answer the following questions. In formulating your answers, disregard health insurance premiums, workers compensation insurance, holiday and vacation pay, etc. Be sure and show your 7 work. Partial credit will be awarded for showing how you got your answers . . What is the gross payroll for Cougar Corp? 10 . What is the net payroll for Cougar Corp? 11. What is the total amount paid by Cougar Corp? Cougar Corp. has 17 hourly employees eaming $16.50 per hour. Last week each employee worked 40 hours. The FICA rate is 7.65%, federal income tax is withheld at an average of 13%, there is no state tax, the State Unemployment (SUTA) rate is 2.5% and the Federal Unemployment (FUTA) tax rate is 1.15%. Answer the following questions. In formulating your answers, disregard health insurance premiums, workers compensation insurance, holiday and vacation pay, etc. Be sure and show your work. Partial credit will be awarded for showing how you got your answers. 9 a. What is the gross payroll for Cougar Corp? 10 b. What is the net payroll for Cougar Corp? 11 c. What is the total amount paid by Cougar Corp? 12 Cougar Corp. has 17 hourly employees eaming $16.50 per hour. Last week each employee worked 40 hours. The FICA rate is 7.65%, federal income tax is withheld at an average of 13%, there is no state tax, the State Unemployment (SUTA) rate is 2.5% and the Federal Unemployment (FUTA) tax rate is 1.15%. Answer the following questions. In formulating your answers, disregard health insurance premiums, workers compensation insurance, holiday and vacation pay, etc. Be sure and show your work. Partial credit will be awarded for showing how you got your answers 9 a. What is the gross payroll for Cougar Corp? 10 b. What is the net payroll for Cougar Corp? 11 c. What is the total amount paid by Cougar Corp

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Art Of Auditing Uncovering Core Principles Of Audit Profession

Authors: Ignatius Ravi

1st Edition

B0CC7FFYP6, 979-8852090959

More Books

Students also viewed these Accounting questions

Question

11. Explain what dreams are, why we have them, and what they mean.

Answered: 1 week ago