Question
Part 2) Software Training Savage Motors sells and leases commercial automobiles, vans, and trucks to customers in southern California. Most of the companys administrative staff
Part 2) Software Training
Savage Motors sells and leases commercial automobiles, vans, and trucks to customers in southern California. Most of the companys administrative staff works in the main office. The company has been in business for 25 years, but only in the last 10 years has the company begun to recognize the benefits of computer training for its employees.
The company president, Arline Savage, is thinking about hiring a training company to give onsite classes. To purse this options, the company would set up a temporary computer Laboratory in one of the meeting rooms, and the trainers would spend all day teaching one or more particular types of software. You have been hired as a consultant to recommend what type pf training would best meet the firms needs.
You begin your task by surveying the three primary corporate departments: Sales, Operations, and Accounting. You find that most employees use their personal computers for only five types of software: 1) Word Processing, 2) Spreadsheet, 3) Database, 4) Presentation, and 5) Accounting. The accompanying table shows your estimates of the total number of hours per week used by each department on each type of the software.
Department (# of Employees) | Word Processing | Spreadsheet | Database | Presentation | Accounting |
Sales (112) | 1,150 | 750 | 900 | 500 | 700 |
Operations (82) | 320 | 2,450 | 650 | 100 | 500 |
Accounting (55) | 750 | 3,600 | 820 | 250 | 2,500 |
Requirements:
- Create a spreadsheet illustrating each departments average use of each application per employee, rounding all averages to one decimal point.
- Suppose there were only enough training funds for each department to train employees on only ONE type of application. What training would you recommend for each department?
- What is the average number of hours of use of each application for all the employees in the company? What training would you recommend if funds were limited to only training ONE type of application for the entire company?
- Use spreadsheet tools, create graphs that illustrate your findings in part 1 and 2. Do you think that your graphs or your numbers better tell your story?
- What alternatives are there to onsite training? Suggest two alternatives and discuss which of your alternatives do you prefer and why.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started