\begin{tabular}{l|l|l|l|l|} & \multicolumn{1}{c}{ A } & & \multicolumn{1}{c}{ B } & \multicolumn{1}{c}{ D } \\ \cline { 1 - 4 } 1 & Employee Name & Dept & Plant & Project \\ \hline 2 & Ashley, Jane & Mkt & Denver & Market Analysis \\ \hline 3 & Davidson Kaye & Acct & Denver & Quota Computation \\ \hline 4 & Ching, Kam Hoong & Ops & Denver & Sourcing Review \\ \hline 5 & Collins,Giovanni & Ops & Denver & Production Planning \\ \hline 6 & Corning,Sandra & Mkt & Denver & Market Analysis \\ \hline 7 & Scott, Rex & Mkt & Denver & Sourcing Review \\ \hline 8 & Corovic,Jose & Acct & Denver & Sourcing Review \\ \hline 9 & Lane, Brandon & Acct & Denver & Production Planning \\ \hline 10 & Wei, Guang & Acct & Denver & Production Planning \\ \hline 11 & Dixon,Eleanore & Ops & Denver & Production Planning \\ \hline 12 & Lee, Brandon & Ops & Denver & Sourcing Review \\ \hline 13 & Duong, Linda & Mkt & Denver & Quota Computation \\ \hline 14 & Bosa, Victor & Mkt & Denver & Production Planning \\ \hline 15 & Drew, Richard & Acct & Denver & Quota Computation \\ \hline 16 & Adams, James & Acct & Denver & Sourcing Review \\ \hline 17 & Lunden,Haley & Ops & Denver & Production Planning \\ \hline 18 & UTran,Diem Thi & Mkt & Denver & Quota Computation \\ \hline 19 & & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline HoursWorked & & \\ \hline & 17 & \\ \hline 22 & \\ \hline 9 & \\ \hline 12 & \\ \hline 21 & \\ \hline 22 & \\ \hline 10 & \\ \hline 15 & \\ \hline 21 & \\ \hline 35 & \\ \hline 21 & \\ \hline 30 & \\ \hline 20 & \\ \hline 17 & \\ \hline 5 & \\ \hline & 19 & \\ \hline 31 & \\ \hline \end{tabular} AE1-1 The spreadsheet in Microsoft Excel file Ch01Ex01_U12e.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 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