Foundations of Business Analysis
Assignment:
Case Study - Computers R Us
Computers R Us, a computer manufacturer and retailer has recently launched a service and repair division, CompleteCare, for its portable/laptop/notebook computers. This division promises to provide a rapid response to customer technical enquiries and warranty repairs.
However, the division is experiencing:
- a shortage of trained technical operators in its telephone centre;
- distribution problems; and
- parts availability problems.
As a result, Computers R Us has received multiple complaints about CompleteCare at the Computers R Us call centre.
To address these issues, a research proposal was prepared (Assignment 1)and the research overseen by the management of Computers R Us. It was found that customer satisfaction was a contributing factor to the issues experienced in the CompleteCare division. Consequently, the management of Computers R Us have developed several possible initiatives to improve customer satisfaction to a minimum level of 6out of 10. These initiatives include: decreasing response times in the CompleteCare division, increasing methods of communication between Computers R Us and itscustomers, the level of advice CompleteCare staff provide on Computers R Us products and services, and a new loyalty rewards program.Management is interested to know which of these strategies is considered the most effective by Computers R Uscustomers.
A member of your team has already collected data that can be used for this analysis. To collect this data, a simple random sample of 500 customerswas selected. Of the 500 customersto whom surveys were sent, 420 responded. The survey used to collect this data is provided below and the survey responses have been collated in the CompleteCare.xls Excel file. You are required to write a report after performingananalysis on the data collected from the customers of Computers R Us.
A member of your team has suggested that, when you perform this analysis, you should undertake a series of hypothesis tests to examine the following:
1. Does the current level of customer satisfaction differ from management's goal of 6 out of 10?
2. Is there any difference between the satisfaction of male and female customerswith the response time of the CompleteCare division?
3. Are there any differences in the overall customer satisfaction across the following age groups: 1, 2, 3, 4 and 5?
4. Is there any difference in customer satisfaction between responses to the initiatives of ‘decreasing response times in the CompleteCare division' and ‘the level of communication with staff and management'?
5. Doany of the initiativesof ‘decreasing response times in the CompleteCare division', ‘the level of advice CompleteCare staff provide on Computers R Us products and services', ‘the level of communication with staff and management' and ‘new loyalty rewards program'influence the overall satisfaction of Computers R Uscustomers?
Required:
Write a data analysis report that provides the results to each of the fivehypothesis tests above and make overall recommendations to Computers R Us that management can use for future business decision-making. Based on your analysis relating to these hypotheses, your report should focus on two keyissues:the current degree of customer satisfaction and the strategy or strategies that would be most effective to increase customer satisfaction.
Attachment:- Data set of CompleteCare Tri.rar