You are a manager in a large information systems consulting company, managing 10 employees in Reno,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
To review the report and assess the datas quality we will start by looking at potentially questionable data and then evaluate the data integrity characteristics 1 Identifying questionable data Upon ex... View the full answer
Related Book For
Business and Administrative Communication
ISBN: 978-0073403182
10th edition
Authors: Kitty o. locker, Donna s. kienzler
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
College Spirit sells sportswear with logos of major universities. At the end of 2019, the following balance sheet account balances were available. Accounts payable $104,700 Required: 1. Prepare a...
-
1. Charmaine read Paradise Lost. (Rxy: x read y) 2. Whoever reads Paradise Lost is educated. (Rxy: x reads y; Ex: x is educated) 3. James is a friend of either Ellen or Connie. (Fxy: x is a friend of...
-
Implement Dijkstras algorithm assuming that the edge weights are integers.
-
Recall the facts in Leonard v. Pepsico Had this been a contract, would it have been subject to the Statute of Frauds?
-
CVP analysis, income taxes (CMA, adapted) R. A. Ro and Company, a manufacturer of quality handmade walnut bowls, has had a steady growth in sales for the past five years. However, increased...
-
12. "New competition is not between what companies produce in their factories, but between what they add to their factory output in the form of packaging, services, advertising, customer advice,...
-
A storeroom is used to organize items stored in it on N shelves. Shelves are numbered from 0 to N-1. The K-th shelf is dedicated to items of only one type, denoted by a positive integer A[K]....
-
T&Co entered a cross currency swap four years ago and the swap has exactly one year to run. Under the swap T&Co pays a bank 4.7% p.a. fixed on USD 7 million and receives 7.4% p.a. fixed on AUD 10...
-
The availability of the cash method has changed over time. We discussed the limitations of the cash method in the course. Please give three distinct examples of taxpayers that MAY use the cash method...
-
What is the yield to maturity on a 3-year, $1,000 discount bond with a current price of $947? Yield to maturity =_______percent. (Round your response to one decimal places.)
-
The product cost method of determining selling prices includes the total of costs plus a desired profit. the fixed and variable product costs plus a markup. the variable product costs plus...
-
Prompt: (1) Explain "excise" tax in detail. (2) Discuss when an excise tax is likely to be used and its impact. (3) Discuss the pros and cons of an excise tax. (4) Discuss the use of an excise tax to...
-
A company has a beta greater than one. Explain what this means and the benefits to managers of knowing the cost of equity capital of their companies.
-
Suppose that you took out a mortgage loan and should repay $500 per month in the next 20 years. In this circumstance, would you be happy if the central bank decides to raise the interest rate?
-
What are the two methods used to translate financial statements and how does the functional currency play a role in determining which method is used?
-
Provide the necessary punctuation in the following sentences. Note that not every box requires punctuation. 1. The system ( s (ser ( friendly design ( provides screen displays of work codes ( rates (...
-
What is a random sample?
-
How can you get better feedback on your writing?
-
Show that if two given networks are described by \(Y_{i}=\sum_{j=1}^{M} T_{i j} X_{j}\) and \(Y_{i}^{\prime}=\) \(\sum_{j=1}^{M} T_{i j}^{\prime} X_{j}^{\prime}\), then these networks are...
-
Some FIR filters present a rational transfer function: (a) Show that the transfer function \[H(z)=\frac{\left(r^{-1} z ight)^{-(M+1)}-1}{r e^{\mathrm{j} 2 \pi /(M+1)} z^{-1}-1}\] corresponds to an...
-
Design second-order lowpass and highpass blocks, and combine them in parallel, to form a bandstop filter with stopband \(0.25 \leq \omega \leq 0.35\), where \(\omega_{\mathrm{s}}=1\). Plot the...
Study smarter with the SolutionInn App