*Please Use Excel to answer the question*
Mr. Samuel Cooper, is an hourly employee who earns $25.00 per hour. He is paid weekly for his work
week of 40 hours. His federal withholding tax rate is 12% and his DC State is 7%.
His weekly voluntary benefits that he pays are as follows:
Health Insurance $30.00; FSA $25.00; Dental Insurance $6.50; Vision $3.50; and 401K 5%.
For the first week of the year, that is January 1st, his timesheet was as follows:
Monday Jan 1st on the Holiday he work 8 hours
Tuesday Jan 2nd, he worked 10 hours
Wednesday Jan 3rd he worked 10 hours
Thursday Jan 4th he worked 12 hours
Friday Jan 5th he worked 10 hours.
1. Calculate Samuel's Net Pay showing all detail.
2. What taxes will the employer be resposible to pay?