You have the responsibility to manage software training for Sales, Accounting, and Operations Department workers in your organization. You have surveyed the workers to get a feel for the amounts of time spent using various packages and the results are shown below. The values shown are the total number of workers in each department and the total weekly hours the department€™s workers spend using each software package. You have been asked to prepare a spreadsheet summarizing these data and comparing the use of the various packages across departments.

a. Create a spreadsheet illustrating each application€™s average use per department. To do this, you will first enter the data shown above. Then compute the average weekly spreadsheet use by dividing spreadsheet hours by the number of Sales workers. Do this for each department. Repeat these three calculations for both database and presentation use. Round results to the nearest 1/100th.

b. Create a three-dimensional bar graph illustrating the averages by department and softwarepackage.

Transcribed Image Text:

Deparment Employees Spreadsheet Database Presentations Sales Operations Accounting 225 75 30 410 710 310 1,100 520 405 650 405 50 Task Name Project Name Fin-Goods-Inv Fin-Goods-Inv Fin-Goods-Inv HR HR HR HR HR Shipmt-Tracking D Design Shipmt Tracking DB Design Shipmt-Tracking Shipmt-Tracking Shipmt-Tracking UI Design App. Devel DB Design UI Design Analysis Analysis UI Design UI Design UI Design Employee ID Production Week Hours Worked 21 20 20 21 20 20 456 345 234 234 456 123 123 234 345 345 345 123 42 20 16 24 48 20 21 21 20 20 40 32 24 16 20 32 24 DB Development UI Design 234