Need assistance to finish the next case research Microsoft Excel template solutions should present all work and calculations.6-2 Buyer Relationship ManagementMinh Phan goes over the numbers another time. He’s about to make crucial salespresentation of his younger profession, and needs every thing to be proper. His potential shopper, MediaSystems, Inc., is among the countryâs main media and communications organizations. Media Systemsâmain problem is how one can successfully handle its various buyer base. The corporate has70,000 publication subscribers, 58,000 advertisers, 30,000 phone providers clients, and18,000 ISP (Web service supplier) clients. The corporate had little details about who itscustomers really had been, which merchandise they had been utilizing, and the way glad they had been with the servicethey obtained. Thatâs the place Minh and his firm, Buyer Answer Applied sciences, LLC, camein. By means of using buyer relationship administration software program, Minh believed Media Systemswould be capable to considerably enhance its means to cross-sell and up-sell a number of media and communicationsservices to clients, whereas considerably lowering buyer complaints.1. What share of the whole does every of the 4 buyer teams signify? Spherical to thenearest hundredth of a p.c.CASE STUDIES2. Minhâs information reveals that on common, solely four.6% of consumers had been buying complementary providers obtainable inside Media Programs.By utilizing his companyâs providers, Minh was projecting that these percentages would triple throughout all person teams inside one yr. Howmany clients would that equate to in complete for every group? What could be the distinction in comparison with present ranges?three. Buyer grievance information confirmed that inside the final yr, complaints by class had been as follows: publication subscribers, 1,174; advertisers,423; phone service clients, four,411; and ISP clients 823. What share of consumers (spherical to 2 decimal locations)complained inside the final yr in every class? If the CRM software program had been in a position to scale back complaints by 50% every year over the nexttwo years, what number of complaints would there be by class on the finish of that point interval? What would the variety of complaints at theend of two years signify on a share foundation?