{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["고객 수익성 분석"],"not_rendered":{"charts":1,"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"고객 수익성 분석","index":0,"n_rows":42,"n_cols":7,"rows_kept":42}
[{"$nulls":6}," "]
[null,"회사 이름"]
[null,"고객 수익성 분석"]
[null," 준비된 날짜: [날짜 입력]"]
[]
[null,null,"세그먼트 이름 1","세그먼트 이름 2","세그먼트 이름 3","합계"]
[]
[null,"고객 활동"]
[]
[null,"활성 고객 수 - 시작 기간",5,8,8,{"$f":"SUM(C10:E10)","v":21}]
[null,"추가된 고객 수",2,4,4,{"$f":"SUM(C11:E11)","v":10}]
[null,"유출된/해지한 고객 수",1,2,2,5]
[null,"활성 고객 수 - 종료 기간",{"$f":"C10+C11-C12","v":6},{"$f":"D10+D11-D12","v":10},10,26]
[]
[null,"수익성 분석"]
[]
[null,"세그먼트당 매출",{"v":1500000,"d":"₩1,500,000.00"},{"v":1800000,"d":"₩1,800,000.00"},{"v":2500000,"d":"₩2,500,000.00"},{"$f":"SUM(C17:E17)","v":{"v":5800000,"d":"₩5,800,000.00"}}]
[null,"가중치",{"$f":"C17/$F$17","v":{"v":0.25862068965517243,"d":"26%"}},{"$f":"D17/$F$17","v":{"v":0.3103448275862069,"d":"31%"}},{"v":0.43103448275862066,"d":"43%"}]
[]
[null,"판매 비용"]
[]
[null,"상시 서비스 및 지원 비용",{"v":1000000,"d":"₩1,000,000.00"},{"v":1400000,"d":"₩1,400,000.00"},{"v":1400000,"d":"₩1,400,000.00"},{"$f":"SUM(C22:E22)","v":{"v":3800000,"d":"₩3,800,000.00"}}]
[null,"기타 직접 고객 비용",{"v":200000,"d":"₩200,000.00"},{"v":100000,"d":"₩100,000.00"},{"v":100000,"d":"₩100,000.00"},{"$f":"SUM(C23:E23)","v":{"v":400000,"d":"₩400,000.00"}}]
[null,"판매 비용 합계",{"$f":"SUM(C22:C23)","v":{"v":1200000,"d":"₩1,200,000.00"}},{"$f":"SUM(D22:D23)","v":{"v":1500000,"d":"₩1,500,000.00"}},{"v":1500000,"d":"₩1,500,000.00"},{"v":4200000,"d":"₩4,200,000.00"}]
[null,"매출 총 이익",{"$f":"C17-C24","v":{"v":300000,"d":"₩300,000.00"}},{"$f":"D17-D24","v":{"v":300000,"d":"₩300,000.00"}},{"v":1000000,"d":"₩1,000,000.00"},{"v":1600000,"d":"₩1,600,000.00"}]
[null,"가중치",{"$f":"C25/$F$25","v":{"v":0.1875,"d":"19%"}},{"$f":"D25/$F$25","v":{"v":0.1875,"d":"19%"}},{"v":0.625,"d":"63%"}]
[]
[null,"취득 비용"]
[]
[null,"직접 고객 취득",{"v":105000,"d":"₩105,000.00"},{"v":120000,"d":"₩120,000.00"},{"v":235000,"d":"₩235,000.00"},{"$f":"SUM(C30:E30)","v":{"v":460000,"d":"₩460,000.00"}}]
[null,"고객 마케팅",{"v":150000,"d":"₩150,000.00"},{"v":125000,"d":"₩125,000.00"},{"v":275000,"d":"₩275,000.00"},{"$f":"SUM(C31:E31)","v":{"v":550000,"d":"₩550,000.00"}}]
[null,"고객 해지",{"v":35000,"d":"₩35,000.00"},{"v":10000,"d":"₩10,000.00"},{"v":140000,"d":"₩140,000.00"},{"v":185000,"d":"₩185,000.00"}]
[null,"총 취득 비용",{"$f":"SUM(C30:C32)","v":{"v":290000,"d":"₩290,000.00"}},{"$f":"SUM(D30:D32)","v":{"v":255000,"d":"₩255,000.00"}},{"v":650000,"d":"₩650,000.00"},{"v":1195000,"d":"₩1,195,000.00"}]
[null,"세그먼트별 고객 수익",{"$f":"C25-C33","v":{"v":10000,"d":"₩10,000.00"}},{"$f":"D25-D33","v":{"v":45000,"d":"₩45,000.00"}},{"v":350000,"d":"₩350,000.00"},{"v":405000,"d":"₩405,000.00"}]
[null,"가중치",{"$f":"C34/$F$34","v":{"v":0.024691358024691357,"d":"2%"}},{"$f":"D34/$F$34","v":{"v":0.1111111111111111,"d":"11%"}},{"v":0.8641975308641975,"d":"86%"}]
[]
[null,"세그먼트당 요약 메트릭"]
[]
[null,"확보한 고객당 평균 비용",{"$f":"C30/C11","v":{"v":52500,"d":"₩52,500.00"}},{"$f":"D30/D11","v":{"v":30000,"d":"₩30,000.00"}},{"v":58750,"d":"₩58,750.00"},{"$f":"F30/F11","v":{"v":46000,"d":"₩46,000.00"}}]
[null,"활성 고객당 평균 마케팅 비용",{"$f":"C31/C13","v":{"v":25000,"d":"₩25,000.00"}},{"$f":"D31/D13","v":{"v":12500,"d":"₩12,500.00"}},{"v":27500,"d":"₩27,500.00"},{"v":21153.846153846152,"d":"₩21,153.85"}]
[null,"해지한 고객당 평균 비용",{"$f":"C32/C12","v":{"v":35000,"d":"₩35,000.00"}},{"$f":"D32/D12","v":{"v":5000,"d":"₩5,000.00"}},{"v":70000,"d":"₩70,000.00"},{"v":37000,"d":"₩37,000.00"}]
[null,"고객당 평균 수익(손해)",{"$f":"C34/C13","v":{"v":1666.6666666666667,"d":"₩1,666.67"}},{"$f":"D34/D13","v":{"v":4500,"d":"₩4,500.00"}},{"v":35000,"d":"₩35,000.00"},{"v":15576.923076923076,"d":"₩15,576.92"}]