Reference no: EM13954059
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.
Department Employees Spreadsheet Database Presentations
Sales 225 410 1,100 650
Operations 75 710 520 405
Accounting 30 310 405 50
a. Create a spreadsheet illustrating each applications 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 software package.
c. A committee has been formed to plan software training classes at your company. Prepare a slide presentation with four slides illustrating your findings. The first slide should serve as an introduction to the data; the second slide should contain a copy of the original data table (without the averages); the third slide should contain a copy of the three-dimensional bar graph from the previous answer; and the fourth slide should contain your conclusions regarding key applications per department. Use professional labels, formatting, and backgrounds.
|
Find the short run equilibrium output
: Let's assume the following information for an economy. C=10000+0.6Y I=2000 G=5000 X=600 M=400 [All the notations are standard as discussed in the class]. Find the size of the multiplier in this economy.
|
|
Demand is normally distributed with a standard deviation
: The manager of the Quick Stop convenience store (which never closes) sells 24 six packs of Fizzy soda each day. Order costs are $8.00 per order, and Fizzy soda costs $4.00 per six-pack. Holding costs are $1 per six pack. Orders arrive five days from ..
|
|
Complete the scoring model
: Complete the scoring model. Show all your work. Tell which project you would pick first, second, third and last. How confident are you with each choice? If you lack confidence regarding any of your choices, what would you prefer to do about it?
|
|
Abundant with natural and human resources
: Africa is abundant with natural and human resources, but who is/are benefiting from these most? Is free enterprise economy prevalent there yet? Is the Western aid serving its purpose? Is Africa attractive to foreign direct investment? How effective a..
|
|
Department employees spreadsheet database presentations
: 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 a..
|
|
Minimizes average ordering-carrying costs
: You just computed the EOQ for an inventory item using the (Q,R) system, and your answer is Q = 315 units. The item in question comes in boxes of 100, so you will need to round your answer. Which of the following presents the more valid logic: Round t..
|
|
What is the future value of the loan over 5 years
: For a project such as a Charter school,the cost can be (e.g. $2,000,000) compute the following using an MARR of 8% for a 5 year term using tables and Excel. Net Present Value of the Loan over 5 years.
|
|
Organizational innovation is the successful implementation
: Organizational innovation is the successful implementation of creative ideas. Complete the following: identify a business going through change that you would like to be the focus of your investigation.
|
|
Dorothy overlooked some of proper recruiting practices
: Dorothy overlooked some of proper recruiting practices, which resulted in an excessive number of unqualified people applying. What are they? 2. Are there hiring standards that should be avoided? Identify them and explain why they should be avoided?
|