Use of Spreadsheet, Database, and Presentations packages
Not what you're looking for?
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 this data and comparing the use of the various packages across departments.
Create a spreadsheet illustrating each application's average use per department. To do this, you will first enter the data shown below. 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.
Create a three-dimensional bar graph illustrating the averages by department and software package.
(Look at attached Word Doc. for correct data below)
Department Employees Spreadsheet Database Presentations
Sales 225 410 1100 650
Operations 75 710 520 405
Accounting 30 310 405 50
Purchase this Solution
Solution Summary
The solution is a company using the different software packages--Spreadsheet, Database, and Presentations. The solution provides for a spreadsheet illustrating each application's average use per department. The attached spreadsheet and word processed files discusses the detailed steps.
Solution Preview
Please see the attached files.
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 this data and ...
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Motivation
This tests some key elements of major motivation theories.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.