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?

Ch01 Ex01_U12e [9171 1 8] - Excel X 49 lololle ly lollar +4 GIOE A B1 X V fx Dept A B C D E F G H J K L M N O P 1 Employee Name Dept Plant Project HoursWorked 2 Dixon, James T Mkt Chicago Quota Computation 27 3 Goston, Sayeh Mkt Chicago Quota Computation 12 Spenser, William Acct Chicago Sourcing Review 15 5 Ray, Anthony Acct Chicago Sourcing Review 18 6 Ryan, Mark Acct Chicago Production Planning 18 Rikki, Nicole Ops Chicago Production Planning 19 8 Scott, Bryan Ops Chicago Production Planning 17 9 Warrem, Jason Acct Chicago Production Planning 16 10 La Pierre, Anna Acct Chicago Quota Computation 22 11 Angel, Kathy Ops Chicago Quota Computation 29 12 Quigly, James Ops Chicago Sourcing Review 19 13 Pham, Mary Ops Chicago Production Planning 5 14 Jordan, Matthew Mkt Chicago Quota Computation 11 15 Bernard, Steven Sales Chicago Quota Computation 29 16 17 Total Hours 257 18 19 20 21 22 23 24 25 26 Denver Chicago Reno Answer + 1 4 O J - + 100% 7:43 PM Type here to search 6/4/2022Ch01 Ex01_U12e [9171 1 8] - Excel X 49 tololla lylolIr +4 GOE 25 47| 0482 498 921 4X18. A1 X V fx Employee Name C D E F G H I J K L M N O A B 1 Employee Name Dept Plant Project HoursWorked 2 Casimiro, Amanda Ops Reno Sourcing Review 17 3 McGovern, Adrian Acct Reno Sourcing Review 23 4 Menstell, Lori Lee Mk Reno Sourcing Review 21 5 Jefferies David Mkt Reno Production Planning 19 6 Nurul, Nicole Mkt Reno Production Planning 20 7 Garrett, James Ops Reno Production Planning 11 8 Austin, James Sales Reno Quota Computation 27 9 Redmond, Elizabeth Mkt Reno Sourcing Review 27 10 Daniel, James Sales Reno Quota Computation 42 11 12 Total Hours 207 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Denver Chicago Reno Answer + : 4 O J - + 100% 7:43 PM Type here to search 70OF ~ D (4 0 1) 6 7 24 6/4/2022C36 X B C D E F G H I J K L M N O A 1 ashley, Jane Dept Plant Project HoursWorked 2 Ashley, Jane Mkt Denver Market Analysis 17 3 Davidson Kaye Acct Denver Quota Computation 22 4 Ching, Kam Hoong Ops Denver Sourcing Review 9 5 Collins, Giovanni Ops Denver Production Planning 12 6 Corning, Sandra Mkt Denver Market Analysis 21 7 Scott, Rex Mkt Denver Sourcing Review 22 8 Corovic, Jose Acct Denver Sourcing Review 10 9 Lane, Brandon Acct Denver Production Planning 15 10 Wei, Guang Acct Denver Production Planning 21 11 Dixon, Eleanore Ops Denver Production Planning 35 12 Lee, Brandon Ops Denver Sourcing Review 21 13 Duong, Linda Mkt Denver Quota Computation 30 14 Bosa, Victor Mkt Denver Production Planning 20 15 Drew, Richard Acct Denver Quota Computation 17 16 Adams, James Acct Denver Sourcing Review 5 17 Lunden, Haley Ops Denver Production Planning 19 18 UTran, Diem Thi Mkt Denver Quota Computation 31 19 20 Total Hours 327 21 22 23 Total Hours for all plants: 791 24 25 26 Denver Chicago Reno Answer +