Need help to complete the following case studies Microsoft Excel template answers must show all work and calculations.6-2 Customer Relationship ManagementMinh Phan is going over the numbers one more time. He is about to make the most important salespresentation of his young career, and wants everything to be right. His prospective client, MediaSystems, 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 has70,000 publication subscribers, 58,000 advertisers, 30,000 telephone services customers, and18,000 ISP (Internet service provider) customers. The company had little information about who itscustomers truly were, which products they were using, and how satisfied they were with the servicethey received. ThatΓ’ΒΒs where Minh and his company, Customer Solution Technologies, LLC, camein. Through the use of customer relationship management software, Minh believed Media Systemswould be able to substantially improve its ability to cross-sell and up-sell multiple media and communicationsservices to customers, while substantially reducing customer complaints.1. What percentage of the total does each of the four customer groups represent? Round to thenearest hundredth of a percent.CASE STUDIES2. 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. Howmany 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 nexttwo years, how many complaints would there be by category at the end of that time period? What would the number of complaints at theend of two years represent on a percentage basis?
π¦πΊ Writing for Australian Universities
- AGLC4 (law), APA 7th, Harvard (Business), Vancouver (Health Sciences)
- Grading: HD (85-100%), D (75-84%), C (65-74%), P (50-64%)
- UniMelb, UNSW, ANU, Monash, UQ, UWA standards covered
- Australia uses British English spelling conventions
- Turnitin is widely used β all work is checked before delivery
Australia Pricing Guide
How It Works β 3 Simple Steps
Fill In Your Order Form
Provide your topic, academic level, deadline, referencing style, and any specific instructions or rubric criteria.
Get Matched with a Writer
We assign the best-qualified expert in your subject, familiar with Australia university requirements.
Receive & Review
Download your plagiarism-free paper, review it, and request any free revisions within 14 days if needed.
Frequently Asked Questions
Is this service plagiarism-free?
Yes. Every paper is written from scratch by a human expert to your specific instructions. We run all papers through professional plagiarism detection software and can include a Turnitin-equivalent report on request.
Do your writers know Australia academic standards?
Yes. Our writers are familiar with Australia's university systems, citation styles, and marking conventions. You'll get a paper that meets your institution's exact expectations.
What citation styles do you support for Australia?
We support all major citation styles required by Australia universities, including APA 7th, Harvard, Chicago/Turabian, MLA, OSCOLA, Vancouver, and IEEE.
Can you write just one chapter of my dissertation?
Yes. We write individual dissertation chapters β literature reviews, methodology, data analysis, introductions, conclusions β or the full manuscript from proposal to defence-ready submission.