Essay About Summarycasesincludedexcludedtotalnpercentnpercentnpercenttotal Profit And Percentile Group Of Totalprofit100099.8

How Is the Variability of Profitability of Infinity’s Customers Across Different Product Lines?
Essay Preview: How Is the Variability of Profitability of Infinity’s Customers Across Different Product Lines?
Report this essay
How is the variability of Profitability of Infinity’s customers across different product lines?Average ProfitabilityCC only: 35.85CA only: -35.91M only: 228.22CC+CA: 71.80CC+M: 320.38CA+M: 353.85All 3: 434.84Case Processing SummaryCasesIncludedExcludedTotalNPercentNPercentNPercentTotal Profit  * Credit Card * Current Account * Mortgage7000100.0%00.0%7000100.0%[pic 1]How is the variability of Profitability of Infinity’s customers within each product line (i.e., CC, CA, Mortgage)?CC only: Top 10% of Customers create 51.7% of total profitsTop 20% create 79.4% of profitsProfitable customers create 170.9% of profits9.8% of customers  are unprofitable?Case Processing SummaryCasesIncludedExcludedTotalNPercentNPercentNPercentTotal Profit  * Percentile Group of TotalProfit100099.8%20.2%1002100.0%Case SummariesTotal Profit  Percentile Group of TotalProfitNMeanSum% of Total Sum197191.061853351.7%210891.82991727.7%39279.18728520.3%410669.88740720.7%59961.42608117.0%69452.69495313.8%710339.93411311.5%810321.2621906.1%91007.597592.1%1098-259.02-25384-70.8%Total100035.8535854100.0%[pic 2]M only: Top 10% of Customers create 22.8% of total profitsTop 20% create 39.8% of profitsProfitable customers create 112.9% of profits9.9% of customers  are unprofitable?Case Processing SummaryCasesIncludedExcludedTotalNPercentNPercentNPercentTotal Profit  * Percentile Group of TotalProfit100099.8%20.2%1002100.0%Case SummariesTotal Profit  Percentile Group of TotalProfitNMeanSum% of Total Sum1100519.285192822.8%2100387.013870117.0%3102328.253348114.7%498289.512837212.4%598262.372571211.3%6101237.722401010.5%7101212.87215009.4%8100185.24185248.1%9101150.31151816.7%1099-294.81-29186-12.8%Total1000228.22228223100.0%[pic 3]CA ONLY: