Question: 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  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 employee worked 40 hours. The FICA rate is 7.65%, federal

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!