-1. The spreadsheet in Microsoft Excel file Ch01Ex01_U10e.xlsx contains records of employee activity on special projects. Open this workbook and examine the data that you find in the three spreadsheets it contains. Assess the accuracy, relevancy, and sufficiency of this data to the following people and problems. a. You manage the Denver plant, and you want to know how much time your employ- ees 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 your 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 your 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? 1 2 Hours Worked 27 12 15 3 4. 5 6 18 18 19 7 8 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 Dept Mkt Mkt Acct Acct Acct Ops Ops Acct Acct Ops Ops Ops Mkt Sales Plant Project Chicago Quota Computation Chicago Quota Computation Chicago Sourcing Review Chicago Sourcing Review Chicago Production Planning Chicago Production Planning Chicago Production Planning Chicago Production Planning Chicago Quota Computation Chicago Quota Computation Chicago Sourcing Review Chicago Production Planning Chicago Quota Computation Chicago Quota Computation 17 9 10 16 22 29 19 11 12 13 14 5 11 29 15 16 17 Total Hours 257 18 19 20 21 22 23 24 25 26 27 28 29 BO 31 32 33 34 35 36 37 38 39 70 41 72 13 44 15 16 17 Denver Chicago Reno + 1 2 3 4 5 Employee Name Casimiro, Amanda McGovern, Adrian Menstell,Lori Lee Jefferies David Nurul, Nicole Garrett, James Austin, James Redmond, Elizabeth Daniel, James Dept Ops Acct Mkt Mkt Mkt Ops Sales Mkt Sales Plant Reno Reno Reno 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 Hours Worked 17 23 21 19 20 11 27 27 42 6 7 8 9 10 11 12 Total Hours 207 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 III. Denver Chica... Reno v Hoursvorked 17 2 3 4 5 Employee Name Casimiro, Amanda McGovern, Adrian Menstell,Lori Lee Jefferies David Nurul, Nicole Garrett, James Austin, James Redmond, Elizabeth Daniel, James Dept Ops Acct Mkt Mkt Mkt Ops Sales Mkt Sales Plany Reno Reno Reno Reno Reno Reno Reno Reno Reno 6 Project Sourcing Review Sourcing Review Sourcing Review Production Planning Production Planning Production Planning Quota Computation Sourcing Review Quota Computation 23 21 19 20 11 7 8 27 9 27 42 10 11 12 Total Hours 207 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 III Denver Chica... Reno A B D E F Hours Worked 17 22 9 Employee Name Dept Ashley, Jane Mkt Davidson Kaye Acct Ching, Kam Hoong Ops Collins, Giovanni Ops Corning, Sandra Mkt Scott, Rex Mkt Corovic, Jose Acct Lane, Brandon Acct Wei, Guang Acct Dixon, Eleanore Ops Lee, Brandon Ops Duong, Linda Mkt Bosa, Victor Mkt Drew, Richard Acct Adams, James Acct Lunden, Haley Ops UTran, Diem Thi Mkt Plant Project Denver Market Analysis Denver Quota Computation Denver Sourcing Review Denver Production Planning Denver Market Analysis Denver Sourcing Review Denver Sourcing Review Denver Production Planning Denver Production Planning Denver Production Planning Denver Sourcing Review Denver Quota Computation Denver Production Planning Denver Quota Computation Denver Sourcing Review Denver Production Planning Denver Quota Computation 12 21 22 10 15 21 35 21 30 20 17 5 19 31 Total Hours 327 Total Hours for all plants: 791 Denver Chica... Reno +