Which three departments paid the most in overtime? You must create a pivot table with a pivot chart to support your answer.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Applications in Human Resources

Objective

Payroll Analysis

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

• Pivot Tables and Pivot Charts

Workbooks Required

• Employee.xlsx

• TimeWorked.xlsx

Tasks

• Link the two worksheets together using lookup tables to calculate the pay due to each employee.

Analysis

    Calculate the number of employees for each department.

Which three departments have the highest salaries? You must create a pivot table with a pivot chart to support your answer.

    Which three employees are paid the most? You must create a pivot table with a pivot chart to support your answer.

Which three departments paid the most in overtime? You must create a pivot table with a pivot chart to support your answer.

    Which three employees paid the most in overtime? You must create a pivot table with a pivot chart to support your answer.

    If you were sitting in a meeting with all department heads, create five questions that you would ask. Identify which department you direct the question to and the question you would ask.

Spreadsheet Modeling & Decision Analysis Case Study Outline 19

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme