Question: Note: You do not need to come up with the answer to the question. Just identify whether the data in the 3 sheets is accurate

Note: You do not need to come up with the answer to the question. Just identify whether the data in the 3 sheets is accurate or not accurate enough, relevant or not relevant enough, and is sufficient or not sufficient enough to answer the question.

a.You manage the Denver plant, and you want to know how much time your employees are spending on special projects. b. You manage the Reno plant, and you want to know how much time your employees are spending on special projects.

c. You manage the Quota Computation project in Chicago, and you want to know how much time your employees have spent on that project. d. You manage the Quota Computation project for all three plants, and you want to know the total time employees have spent on that project.

e. You manage the Quota Computation project for all three plants, and you want to know the total labor cost for all employees on that project. f. You manage the Quota Computation project for all three plants, and you want to know how the labor-hour total for your project compares to the labor-hour totals for the other special projects.

g. What conclusions can you make from this exercise?

Note: You do not need to come up with the answerNote: You do not need to come up with the answerNote: You do not need to come up with the answer

Plant HoursWorked Dept Mkt 17 Acct Denver Denver Denver 22 9 Denver Denver Denver Denver Employee Name Ashley, Jane Davidson Kaye Ching, Kam Hoong Collins, Giovanni Corning, Sandra Scott, Rex Corovic, Jose Lane, Brandon Wei, Guang Dixon, Eleanore Lee, Brandon Duong, Linda Bosa, Victor Drew, Richard Adams, James Lunden, Haley UTran, Diem Thi Ops Ops Mkt Mkt Acct Acct Acct Ops Ops Mkt Mkt Denver Project Market Analysis Quota Computation Sourcing Review Production Planning Market Analysis Sourcing Review Sourcing Review Production Planning Production Planning Production Planning Sourcing Review Quota Computation Production Planning Quota Computation Sourcing Review Production Planning Quota Computation Denver 12 21 22 10 15 21 35 21 30 20 17 Denver Denver Denver Denver Denver Denver Denver Denver Acct Acct 5 19 Ops Mkt 31 Total Hours 327 Plant Dept Mkt Mkt Employee Name Dixon, James T Goston, Sayeh Spenser, William Ray, Anthony Ryan, Mark Rikki, Nicole Scott, Bryan Warrem, Jason La Pierre, Anna Angel, Kathy Quigly, James Pham, Mary Jordan, Matthew Bernard, Steven Acct Acct Acct Ops Ops Acct Acct Ops Ops Ops Mkt Sales Chicago Chicago Chicago Chicago Chicago Chicago Chicago Chicago Chicago Chicago Chicago Chicago Chicago Chicago Project Quota Computation Quota Computation Sourcing Review Sourcing Review Production Planning Production Planning Production Planning Production Planning Quota Computation Quota Computation Sourcing Review Production Planning Quota Computation Quota Computation HoursWork 27 12 15 18 18 19 17 16 22 29 19 5 11 29 Total Hours 257 Dept Plant HoursWorked Reno 17 Ops Acct Reno 23 21 Employee Name Casimiro, Amanda McGovern, Adrian Menstell, Lori Lee Jefferies David Nurul Nicole Garrett, James Austin, James Redmond, Elizabeth Daniel, James Mkt Mkt Mkt Ops Sales Mkt Sales Reno Reno Reno Reno Reno Reno Project Sourcing Review Sourcing Review Sourcing Review Production Planning Production Planning Production Planning Quota Computation Sourcing Review Quota Computation 19 20 11 27 27 Reno 42 Total Hours 207

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 General Management Questions!