BIS 155

You own a small computer service company with only 2 employees. You provide different types of services to regular customers and companies. You have noticed an increase of demand for troubleshooting and support of mobile devices. However, you only support desktop, laptop, networking, and printing devices. Your current staff doesn't have the skills or experience to troubleshoot this type of devices such as mobile phones (iPhone, Android), tablets, or eBook readers.
You have kept a log of each of these inquiries for "mobile device" troubleshooting and support. The list includes the type of device, issue, and customer's name. You feel this is an opportunity for your business and you want to make sure you can serve your customers well and expand your services.

A - Explain how you will use Excel to find out how much support you have been inquired for mobile devices. Include how to identify the number of devices per customer. Be specific.
B - You wish to survey your customers to find out what type of devices they own and their needs. To accomplish this you have created a survey and you must send it via mail to more than 50 customers. However, you dread hand addressing the envelopes. Explain how you might use Excel to make this go faster.
C - If you get the results you expect to get from contacting your customers, you want to be able to do this every month. Explain how you might use Excel to automate the process of separating your list as you did in Part A.
D - You are anticipating your man hours will increase by 20 percent over the next month for every 15 customers your support. You need to hire new employees so you want to gauge the impact on your workforce by including 30, 40, or 50 clients as part of your new strategy. Explain how you might evaluate this using your Excel tools.

  1. 👍 0
  2. 👎 0
  3. 👁 193
  1. Try some of the following links about Excel:

    http://www.google.com/search?q=what+y+ou+can+do+with+Excel&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

    Sra

    1. 👍 0
    2. 👎 0
  2. Explain how you might use Excel to automate the process of separating your list as you did in Part A.

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. math

    A company has two office buildings that hold 30,000 employees. Their headquarters contains 14 times as many employees as their overseas branch. Therefore, their headquarters contains __?__ employees.

    asked by Anonymous on April 4, 2018
  2. maths

    ABC company currently has 1/4 fewer computers than it has employees,if they currently have 80 employees and they want to hire 5% more.how many computers will they need to buy to ensure that each employees has one?

    asked by Gladys on October 8, 2016
  3. Statistics

    The distribution of weekly salaries at a large company is reverse J-shaped with a mean of $1000 and a standard deviation of $370. What is the probability that the sampling error made in estimating the mean weekly salary for all

    asked by Janet on April 13, 2015
  4. math

    Solve the problem. A shirt company has 4 designs that can be made with short or long sleeves. There are 5 color patterns available. How many different types of shirts are available from this company? a. 9 types b. 40 types c. 11

    asked by Dana on May 4, 2008
  5. Gr.11 Math

    A large company has a phone tree to contact its employees in case of an emergency factory shutdown. Each of the five senior managers calls three eployees, who calls three other employees and so on. If the tree consists of seven

    asked by Nancy on January 5, 2009
  1. PSY

    22. A company can either invest in employee training seminars or update its computer network. Since updating the computer network would result in more measurable benefits, the company would be best off updating its computer

    asked by Cat on September 25, 2010
  2. statistics

    The distribution of weekly salaries at a large company is right skewed with a mean of $1000 and a standard deviation of $350. What is the probability that the sampling error made in estimating the mean weekly salary for all

    asked by Anonymous on June 18, 2013
  3. Grade 11 maths plz help!!!

    A software company started with 2 employees. In 6 months, the company had 7 employees. The number of employees increased in a steady rate. Which equation models the relationship between the number of employees n and the number of

    asked by Anjali on September 23, 2008
  4. Statistics

    Listed below are amounts​ (in millions of​ dollars) collected from parking meters by a security service company and other companies during similar time periods. Do the limited data listed here show evidence of stealing by the

    asked by Hayley on September 9, 2018
  5. Civics

    A company decided to pass a policy banning cell phones on their property. A group of employees collected signatures to protest. Many of the co-workers who signed the petition were later fired because the petition was deemed

    asked by Carla on May 24, 2017
  6. Stats

    8.0235% of the employees of the Acme Tire store are enrolled in a 401k at the store. If the company has 600 employees, what is the probability that less than 40 employees are entered in the 401k.

    asked by Sam on April 6, 2016

You can view more similar questions or ask a new question.