Customer complaint data showed that within the last year, complaints by category were as follows: publication subscribers

INSTRUCTIONS:  Read the case in the textbook.  As a team, answer the questions in this spreadsheet, then save and submit the assignment as one Microsoft® Excel® attachment.  Also, submit a 1-paragraph Microsoft®Word document explaining any issues or successes you had in answering these questions.          

          

"Refer to and use the following abbreviations for the problems below:  

     • PS = Public Subscribers

     • AD = Advertisers

     • TC = Telephone Customers

     • ISP = Internet Customers

     • TOT = Total Customers"          

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. a) What percentage of customers (round to two decimal places)complained within the last year in each category?  b) If the CRM software were able to reduce complaints by 50% each year over the next 2 years, how many complaints would there be by category at the end of that time period? And c) What would the number of complaints at the end of 2 years represent on a percentage basis?