Question: You are a manager in a large information systems consulting company, managing 1 0 employees in Reno, who each worked 5 0 weeks, 4 0

You are a manager in a large information systems consulting company, managing 10 employees in Reno, who each worked 50 weeks, 40 hours per week, (or a total of 2000 hours) in 2023. You want to better understand how your employees spent their time in the calendar year 1/1/23-12/31/23. Specifically, you want to be able to calculate the following:
how many hours each employee spent on a series of 3 special projects during 2023.
what percentage of hours worked on special projects vs total hours worked in 2023 for each employee
how many years they have worked for the company
You request a report from the Project Management Office, which keeps track of employee information and hour worked. You immediately receive back the following spreadsheet:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!