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 2022. You want to better understand how your employees spent their time in the calendar year 1/1/22-12/31/22. Specifically, you want to be able to calculate the following: how many hours each employee spent on a series of 3 special projects during 2022. what percentage of hours worked on special projects vs total hours worked in 2022 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 report: Employee Name Casimiro, Amanda McGovern, Adrian Menstell,Lori Lee Jefferies David Nurul, Nicole Garrett, James Austin, James Redmond, Elizabeth Daniel, James Mei Ling Garcia Menstell, Lorie Lee 2022 Hours Worked Report (1/1/22-12/31/23) Dept Ops Acct Mkt Mkt Mkt Ops Sales Mkt Sales Acct Mkt Plant Reno Reno Reno Reno Reno Reno Vegas Reno Reno Reno Reno Hours Worked On Special Projects(") Sourcing Production Review Planning 300 200 500 300 400 300 100 500 200 500 800 0 200 500 700 -100 100 300 500 200 500 Quota Computation 500 500 100 222 500 100 100 600 500 500 100 Regular Hours Worked (") 1000 600 1400 878 500 1700 (*) For each employee, Regular Hours Worked + Hours Worked On Special Projects = Total Hours Worked 1300 900 500 500 1400 Your job is to review the report and determine how good the data is. Please do the following for this assignment: 1. Identify ALL potentially questionable data in the table, and indicate exactly what it is about the piece of data that is questionable. Be as SPECIFIC as possible. Here is an example: o Instead of saying "some data seems wrong", you might say "the value "941310" is listed as a zip code, but zip codes consist of 5 digits, whereas this value has 6 digits. 2. For each data integrity characteristics (accuracy, timeliness, relevance, sufficient, worth it) describe whether the data in the table satisfies that data integrity characteristic. In your assessment of the characteristics, indicate if there are any desired calculations that you will not be able to perform because of the state of the data, and explain why.