The spreadsheet in Microsoft Excel file ChOlExOl_U7e.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 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?