do you see any cause for concern based on the analysis above? if so, what would you recommend?
Question1:
Question2:
Question3:
Question 4:
Question5:
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & Department & 10 & 12 & 32 & 34 & 40 & 45 & 52 & 54 & 80 \\ \hline & & 6 & 3 & 12 & 7 & 3 & 6 & 4 & 5 & 4 \\ \hline \multirow[t]{3}{*}{2} & Departments & 10 & $337,243.00 & & & & & & & \\ \hline & & 12 & $212,755.50 & & & & & & & \\ \hline & & 32 & \$ 192,426.00 & & & & & & & \\ \hline \multirow[t]{3}{*}{3} & Employees & 102 & \$ 48,660.00 & & & & & & & \\ \hline & & 103 & \$ 48,450.00 & & & & & & & \\ \hline & & 143 & S 47,317.50 & & & & & & & \\ \hline & & & & & & & & & & \\ \hline & Ovetime by Dept & 45 & 3,246.00 & $541.00 & & & & & & \\ \hline & & 40 & 2,371.50 & $790.50 & & & & & & \\ \hline & & 34 & \$ 1,248.00 & $178.29 & & & & & & \\ \hline & & 32 & 957,00 & \$ 79.75 & & & & & & \\ \hline & Overtime by Employee & 124 & \$ 1,458.00 & & & & & & & \\ \hline & & 105 & $1,248.00 & & & & & & & \\ \hline & & 111 & 913.50 & & & & & & & \\ \hline \end{tabular} Payroll Accounting Objective: Employee and Payroll Decision Making Overview: You are a human resources manager. You are asked by senior management to work with an employee and time worked sheet to provide an analysis about trends and characteristics regarding human resource issues. Techniques Covered: - Working with large datasets - Lookup Tables - Multiple worksheets linking - Advanced formulas and macros - Charting and presentations Workbooks Required: - Employee.xlsx - TimeWorked.xlsx Tasks: - Link the two worksheets together using lookup tables to calculate the pay due to each employee. Analysis: 1. Calculate the number of employees for each department. 2. Which three departments have the highest salaries? 3. Which three employees are paid the most? 4. Which, if any, departments have abnormally high total overtime payments? 5. Which, if any, individuals have abnormally high total overtime payments? 6. Do you see any cause for concern based on the analysis above? If so, what would you recommend? 8 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & Department & 10 & 12 & 32 & 34 & 40 & 45 & 52 & 54 & 80 \\ \hline & & 6 & 3 & 12 & 7 & 3 & 6 & 4 & 5 & 4 \\ \hline \multirow[t]{3}{*}{2} & Departments & 10 & $337,243.00 & & & & & & & \\ \hline & & 12 & $212,755.50 & & & & & & & \\ \hline & & 32 & \$ 192,426.00 & & & & & & & \\ \hline \multirow[t]{3}{*}{3} & Employees & 102 & \$ 48,660.00 & & & & & & & \\ \hline & & 103 & \$ 48,450.00 & & & & & & & \\ \hline & & 143 & S 47,317.50 & & & & & & & \\ \hline & & & & & & & & & & \\ \hline & Ovetime by Dept & 45 & 3,246.00 & $541.00 & & & & & & \\ \hline & & 40 & 2,371.50 & $790.50 & & & & & & \\ \hline & & 34 & \$ 1,248.00 & $178.29 & & & & & & \\ \hline & & 32 & 957,00 & \$ 79.75 & & & & & & \\ \hline & Overtime by Employee & 124 & \$ 1,458.00 & & & & & & & \\ \hline & & 105 & $1,248.00 & & & & & & & \\ \hline & & 111 & 913.50 & & & & & & & \\ \hline \end{tabular} Payroll Accounting Objective: Employee and Payroll Decision Making Overview: You are a human resources manager. You are asked by senior management to work with an employee and time worked sheet to provide an analysis about trends and characteristics regarding human resource issues. Techniques Covered: - Working with large datasets - Lookup Tables - Multiple worksheets linking - Advanced formulas and macros - Charting and presentations Workbooks Required: - Employee.xlsx - TimeWorked.xlsx Tasks: - Link the two worksheets together using lookup tables to calculate the pay due to each employee. Analysis: 1. Calculate the number of employees for each department. 2. Which three departments have the highest salaries? 3. Which three employees are paid the most? 4. Which, if any, departments have abnormally high total overtime payments? 5. Which, if any, individuals have abnormally high total overtime payments? 6. Do you see any cause for concern based on the analysis above? If so, what would you recommend? 8
