I need help.Thank you.

You are a college student who has just been accepted by a local company for your college internship. Your responsibilities will be to perform the responsibilities of a payroll clerk for the payroll department-hourly employees for the first quarter of 2017. She also wishes for you to help improve this department during your stay. The company has about 18 illion in assets. They produce fan blades for the auto industry. You are responsible for the hourly employees, about 90, who are all union employees. Your responsibilities are as follows Collect the time cards from all of the union employees. (Each employee keeps his own time card in his/her pocket and turns it in on Friday (Monday or Tuesday of the next week if it is forgotten.) The company has a time clock. There is a stack of blank timecards next to the time clock. Each employee grabs one and puts his/her name on top and keeps it until it is turned in Calculate the regular hours and overtime hours for each employee. Your work is done on each time card and summarized on an excel worksheet that you create new each week. 1. 2. 3. Calculate the Federal and State withholding taxes as well as Social Security and Medicare for each employee. This information is put on each employee's timecard. Make appropriate non tax deductions (union dues and charitable, and miscellaneous deductions such as court order deductions) Calculate net pay for each employee on an excel worksheet. This information is recovered from each employee's time card. (This is called the payroll register.) 4. ENG 5. 04 PM 6/04/2018 6. Type up the payroll checks for each employee 7. Maintain a payroll ledger card on excel for each emplovee