Question: You are a Human Resources (HR) Representative working for XYZ Imports, a small business that has recently experienced a great deal of growth and expansion.
You are a Human Resources (HR) Representative working for XYZ Imports, a small business that has recently experienced a great deal of growth and expansion. XYZ Imports has been a small company managing its own payroll system. Now that the company is experiencing significant growth, there is an immediate need to outsource the payroll to a third-party organization. The CEO has selected ADP, one of the largest payroll organizations in the United States. In order to set up the payroll with ADP, you must first provide the company with information related to each employee as mandated under the Fair Labor Standards Act (FLSA). ADP has asked to receive this information in the form of both an Excel Spreadsheet and an Access Database. Your job is to help prepare for this transition. Arrange the entries in Microsoft Excel. When entering your information, ensure that you are formatting the cells so that the information will transfer well into Access for the appropriate data type. Enter the provided employee records with a range of staff and hourly employees. Once the data has been entered, create a chart on a new sheet that graphically represents a comparison of the hourly employees and salaried employees
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
