Minh phan is going over the numbers one more time

Need help to complete the following case studies 
Microsoft Excel template answers must show all work and calculations.

Get a plagiarism free copy of this essay from our experts
Minh phan is going over the numbers one more time
For as low as $13/Page
Order Now

6-2 Customer Relationship Management
Minh Phan is going over the numbers one more time. He is about to make the most important sales

presentation of his young career, and wants everything to be right. His prospective client, Media

Systems, Inc., is one of the country’s leading media and communications organizations. Media Systems’

primary challenge is how to effectively manage its diverse customer base. The company has

70,000 publication subscribers, 58,000 advertisers, 30,000 telephone services customers, and

18,000 ISP (Internet service provider) customers. The company had little information about who its

customers truly were, which products they were using, and how satisfied they were with the service

they received. That’s where Minh and his company, Customer Solution Technologies, LLC, came

in. Through the use of customer relationship management software, Minh believed Media Systems

would be able to substantially improve its ability to cross-sell and up-sell multiple media and communications

services to customers, while substantially reducing customer complaints.

1. What percentage of the total does each of the four customer groups represent? Round to the

nearest hundredth of a percent.


2. Minh’s data shows that on average, only 4.6% of customers were purchasing complementary services available within Media Systems.

By using his company’s services, Minh was projecting that these percentages would triple across all user groups within one year. How

many customers would that equate to in total for each group? What would be the difference compared to current levels?

3. Customer complaint data showed that within the last year, complaints by category were as follows: publication subscribers, 1,174; advertisers,

423; telephone service customers, 4,411; and ISP customers 823. What percentage of customers (round to two decimal places)

complained within the last year in each category? If the CRM software were able to reduce complaints by 50% each year over the next

two years, how many complaints would there be by category at the end of that time period? What would the number of complaints at the

end of two years represent on a percentage basis?

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYHELP