Case 6-2 TemplateINSTRUCTIONS: 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, include a brief write-up of one paragraph explaining any issues or successes you had in answering these questions. This paragraph should be embedded within this tab below your last solution. 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 1. What percentage of the total does each of the four customer groups represent? Round to the nearest hundredth of a percent. 70,000+58,000+30,000+18,000=176,000 70000/176000=39.77% 58000/176000=32.95% 30000/176000=17.05% 18000/176000=10.23% Use the cells below to fill in the appropriate numbers for the variables (PS, AD, TC, ISP) to check your answers. Variables UsedPS=70,000 AD=58,000 TC=30,000 ISP=18,000 TOT=176,000 Excel FormulasPS % of total39.77% AD % of total32.95% TC % of total17.05% ISP % of total10.23% Use the cursor to highlight the yellow cells and look at the area above the column headings to see the background formulas. What is great about a Microsoft®Excel® reference formula is you can change any of the non-total variables and the Total and Percentage answers will change; thus, allowing many what-if scenarios. Try it. 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 1 year. a) How many customers would that equate to in total for each group? b) What would be the difference compared to current levels? 4.6*3=13.8% increase in complementary services. 70,000*.138=9660 58,000*.138=8004 30,000*.138=4140 18,000*.138= 2484 Use the cells below to fill in the appropriate numbers for the variables (PS, AD, TC, ISP, current purchasing %, projected multiple factor, and % difference) to check your answers. Variables UsedPS=9,660 AD=8,004 TC=4,140 ISP=2,484 Current Purchasing %1.00% Projected multiple factor1.00 % Difference1.00% Excel Formulas Part APart B PS=$96.60$96.60 AD=$80.04$80.04 TC=$41.40$41.40 ISP=$24.84$24.84 Use the cursor to highlight the yellow cells and look at the area above the column headings to see the background formulas. What is great about a Microsoft®Excel® reference formula is you can change any of the variables and the cells with formulas will change; thus, allowing many what-if scenarios. Try it. 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? (Use this cell to answer parts a, b, and c. Be sure to show your work.) Now use the cells below to fill in the appropriate numbers for the variables to check your answers. Variables Used ComplaintsCustomers PS=11 AD=11 TC=11 ISP=11 TOT=44 Complaint reduction Factor1% Excel Formulas Part APart BPart C PS=100.00%$0.000.01% AD=100.00%$0.000.01% TC=100.00%$0.000.01% ISP=100.00%$0.000.01% Use the cursor to highlight the yellow cells and look at the area above the column headings to see the background formulas. What is great about a Microsoft®Excel® reference formula is you can change any of the variables and the cells with formulas will change; thus, allowing many what-if scenarios. Try it.
by admin | Sep 23, 2022 | Business & Finance /Accounting | 0 comments
Case 6-2 TemplateINSTRUCTIONS: Read the case in the textbook. As a team, answer the questions…
A professional Academic Service Provider
Distinguished Writers Ensure Accountability, Confidentiality, High-Quality, and Timely Execution
Distinguished Writers comprises of well-trained professionals striving to give our clients an awesome experience. We engage with our customers throughout the learning process to ensure they are comfortable with both their classwork and homework in order to achieve excellent grades. The team is well-balanced across different fields to suit our clients. Our diversified fields include article writing, thesis proposals, project management, coursework, essay writing, and dissertations among others.Fundamental Values
1. Accountability: The company values professionalism in all our undertakings. As such, we interact transparently with our customers.
2. Confidentiality: The company does not disclose anything to third-parties, and our interactions with customers remain confidential.
3. High-Quality The products are thoroughly proofread and counter-checked to ensure they meet the expected quality levels.
Guarantees
4. Quality is a Guarantee: Our writers are accurately matched with their area of expertise to ensure proper quality is maintained. We are also equipped with adequate software to guarantee error-free products.
5. Money Back Policy: As a client-oriented service, we offer 100% refund for the following: if we received a double payment from you; if you placed similar orders twice (or more) and paid for all of them; the writer has not been assigned; you asked to cancel the order within 20 minutes after placing it; an e-Check payment has been sent (the Dispute Manager will contact you accordingly). Other cases involve a comprehensive investigation by the Dispute Department and feedback given within 24 hours. We value our customers; therefore, the process will be fair, fast, and precise.
5 .Free Revisions: You can request for revisions at no additional cost. Nonetheless, this does not include complete change of the initial order instructions and if it is not past ten days upon your approval.
6. 24/7 Customer Support: Our support staff are always online to provide any assistance when needed
Ordering Process
NOTE: If you have any question, always contact our support team before the commencement of your project. ALL THE BEST”:
Recent Comments