{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Customer Profitability","Summary Metrics Chart"],"not_rendered":{"charts":1,"macros":1,"external_links":1,"defined_names":24},"unopened":[{"sheet":"Summary Metrics Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Customer Profitability","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Customer Profitability Analysis"]
[null,"[Date]"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything into them."]
[]
[null,null,"[Segment Name]","[Segment Name]","[Segment Name]","Overall"]
[null,"Customer Activity:"]
[null,"Number of active customers—Beginning of period",5,8,8,{"v":21,"d":"21 "}]
[null,"Number of customers added",2,4,4,{"v":10,"d":"10 "}]
[null,"Number of customers lost/terminated",{"v":-1,"d":"(1)"},{"v":-2,"d":"(2)"},{"v":-2,"d":"(2)"},{"v":-5,"d":"(5)"}]
[null,"Number of active customers—End of period",6,10,10,26]
[]
[null,"Profitability Analysis:"]
[null,"Revenue per segment",{"v":1500000,"d":"$1,500,000"},{"v":1800000,"d":"$1,800,000"},{"v":2500000,"d":"$2,500,000"},{"v":5800000,"d":"$5,800,000"}]
[null,"Weighting",{"v":0.25862068965517243,"d":"25.9%"},{"v":0.3103448275862069,"d":"31.0%"},{"v":0.43103448275862066,"d":"43.1%"},{"v":1,"d":"100.0%"}]
[]
[null,"Cost of sales:"]
[null,"Ongoing service and support costs",{"v":1000000,"d":"$1,000,000"},{"v":1400000,"d":"$1,400,000"},{"v":1400000,"d":"$1,400,000"},{"v":3800000,"d":"$3,800,000"}]
[null,"Other direct customer costs",{"v":200000,"d":"200,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":400000,"d":"400,000 "}]
[null,"Total cost of sales",{"v":1200000,"d":"$1,200,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":4200000,"d":"$4,200,000"}]
[]
[null,"Gross margin",{"v":300000,"d":"$300,000"},{"v":300000,"d":"$300,000"},{"v":1000000,"d":"$1,000,000"},{"v":1600000,"d":"$1,600,000"}]
[null,"   Weighting",{"v":0.1875,"d":"18.8%"},{"v":0.1875,"d":"18.8%"},{"v":0.625,"d":"62.5%"},{"v":1,"d":"100.0%"}]
[]
[null,"Other costs:"]
[null,"Customer acquisition",{"v":105000,"d":"$105,000"},{"v":120000,"d":"$120,000"},{"v":235000,"d":"$235,000"},{"v":460000,"d":"$460,000"}]
[null,"Customer marketing",{"v":150000,"d":"150,000 "},{"v":125000,"d":"125,000 "},{"v":275000,"d":"275,000 "},{"v":550000,"d":"550,000 "}]
[null,"Customer termination",{"v":80000,"d":"80,000 "},{"v":190000,"d":"190,000 "},{"v":140000,"d":"140,000 "},{"v":410000,"d":"410,000 "}]
[null,"Total other customer costs",{"v":335000,"d":"$335,000"},{"v":435000,"d":"$435,000"},{"v":650000,"d":"$650,000"},{"v":1420000,"d":"$1,420,000"}]
[]
[null,"Customer profit by segment",{"v":-35000,"d":"($35,000)"},{"v":-135000,"d":"($135,000)"},{"v":350000,"d":"$350,000"},{"v":180000,"d":"$180,000"}]
[null,"   Weighting",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},{"v":1,"d":"100.0%"}]
[]
[null,"Summary Metrics:"]
[null,null,"[Segment Name]","[Segment Name]","[Segment Name]"]
[null,"Average cost per acquired customer",{"v":52500,"d":"$52,500"},{"v":30000,"d":"$30,000"},{"v":58750,"d":"$58,750"}]
[null,"Average cost per terminated customer",{"v":80000,"d":"$80,000"},{"v":95000,"d":"$95,000"},{"v":70000,"d":"$70,000"}]
[null,"Average marketing cost per active customer",{"v":25000,"d":"$25,000"},{"v":12500,"d":"$12,500"},{"v":27500,"d":"$27,500"}]
[null,"Average profit (loss) per customer",{"v":-5833.333333333333,"d":"($5,833)"},{"v":-13500,"d":"($13,500)"},{"v":35000,"d":"$35,000"}]