BIS 155

posted by .

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.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. human services my answers

    Progress made in medical sciences is tremendous. Small pox is wiped out. Given the improvement in health care the death rate has reduced compared to centuries ago. Longevity is also significant. As an elected government, it is their …
  2. human resources

    SMC Company manufactures ergonomic office equipment. SMC is located in a small Midwestern town of 30,000 people with a current unemployment rate of 2.2%. The owner is committed to keeping the organization local. Several local companies …
  3. human resource

    SMC Company manufactures ergonomic office equipment. SMC is located in a small Midwestern town of 30,000 people with a current unemployment rate of 2.2%. The owner is committed to keeping the organization local. Several local companies …
  4. English

    Please find errors and correct them. To all ABC Internet Customers we have resolved the problem we were having with the Internet backbone for Southern Illinois. There was an NAP connection that was having trouble in Atlanta, Georgia. …
  5. Please Help-English

    Proofread for spelling Capilization, commas error,any other mistakes, and correct them for me. To all ABC Internet Customers we have resolved the problem we were having with the Internet backbone for Southern Illinois. There was an …
  6. maths

    (a) A random survey of 100 mobile telephone customers indicated that 96 of them had not experienced any difficulties in making mobile calls in the previous 3 months. (i) Derive a point estimate for customer satisfaction levels with …
  7. statistics

    b. A mobile company XYZ wants to conduct a survey to find the proportion P of those customers that are happy with the purchase of their new mobile phone. The company took a random sample of 1000 customers who recently purchased the …
  8. statics

    b. A mobile company XYZ wants to conduct a survey to find the proportion P of those customers that are happy with the purchase of their new mobile phone. The company took a random sample of 1000 customers who recently purchased the …
  9. Statistics

    The records of a computer retail store show that out of the 100 customers who purchased a desktop computer last month, 69 also purchased a service plan that extends the warranty for an extra year. Out of the 25 customers who purchased …
  10. Thermodynamic

    You evaluate a number of different temperature measuring devices in your laboratory classes. a. Explain how at least three operated and justify why you would choose those devices for the scenario below. ‘A local company requires …

More Similar Questions