Reference no: EM131030766 , Length: word count:3000
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
|
Develop a financial planning model
: How much will your portfolio be worth in 10 years? In 20 years? When you stop working? The Human Resource department at EcoCarnifex Corporation was asked to develop a financial planning model that would help employees address these questions.
|
|
Determine the power rating of the heater in kw
: When the heat losses from the room on a winter day amount to 6500 kJ/h, the air temperature in the room remains constant even though the heater operates continuously.
|
|
Cut taxes were opposed so strongly as treasury secretary
: From Myth of the Robber Barons: Explain how Charles Schwab and Andrew Carnegie outperformed competitors and why these methods not successful at U.S. Steel and explain why Andrew Mellon’s attempts to cut taxes were opposed so strongly as U.S. Treasury..
|
|
Summarises current state and proposes sustainable strategies
: Analyse the information presented and conceptualise the state of environmental planning in Australia. Apply innovative and entrepreneurial thinking and practice to corporate sustainability management in Australia and produce a report that summarise..
|
|
Does the current level of customer satisfaction
: 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.
|
|
Show the calculation of the gain
: Equipment that cost $80,000 and has accumulated depreciation of $63,000 is exchanged for similar equipment with a fair value of $35,000 and $15,000 cash is received. The exchange lacked commercial substance. Directions: Respond to these questions ..
|
|
Should a court confirm the award or set it aside
: The younger brother also seeks to have the award set aside on the basis of improper conduct in that matters subject to arbitration were discussed between the father and older brother without the younger brother's being present. Should a court conf..
|
|
What is the approximate variance of the original portfolio
: Suppose the variance of the market is 0.04. What is the approximate variance of the original portfolio? What specific tips should you take to rebalance the portfolio, assuming no security position is completely eliminated?
|
|
Determine the rate at which heat needs to be removed
: If the temperature of the balls after quenching is 74°C, determine the rate at which heat needs to be removed from the water in order to keep its temperature constant at 50°C.
|