{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Kundenrentabilität","Auswertung Kennzahlen - Chart"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Kundenrentabilität","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Firmenname]"]
[null,"Wirtschaftlichkeitsanalyse Kunden"]
[null,"[Datum]"]
[]
[null,"Die Werte in den grau unterlegten Zellen werden automatisch berechnet. Hier sind keine Eingaben nötig."]
[]
[null,null,"[ Segmentname]","[Segmentname]","[Segmentname]","Gesamt"]
[null,"Kundenaktivität "]
[null,"Anzahl aktive Kunden—Fristbeginn",5,8,8,21]
[null,"Anzahl Neukunden",2,4,4,10]
[null,"Anzahl Kundenverluste, -abwicklungen",-1,-2,-2,-5]
[null,"Anzahl aktive Kunden-Stichtag",6,10,10,26]
[]
[null,"Rentabilitätsanalyse:"]
[null,"Umsatzerlöse pro Segment",1500000,1800000,2500000,5800000]
[null,"Gewichtung",0.25862068965517243,0.3103448275862069,0.43103448275862066,1]
[]
[null,"Umsatzkosten:"]
[null,"Laufende Wartungs- und Kundendienstkosten",1000000,1400000,1400000,3800000]
[null,"Sonstige kundenbezogene Kosten",200000,100000,100000,400000]
[null,"Gesamt Umsatzkosten",1200000,1500000,1500000,4200000]
[]
[null,"Bruttomarge",300000,300000,1000000,1600000]
[null,"  Gewichtung",0.1875,0.1875,0.625,1]
[]
[null,"Sonstige Kosten:"]
[null,"Kundenakquise",105000,120000,235000,460000]
[null,"Kundenmarketing",150000,125000,275000,550000]
[null,"Kundenabwicklung",80000,190000,140000,410000]
[null,"Gesamt Sonstige kundenbezogene Kosten",335000,435000,650000,1420000]
[]
[null,"Ertrag nach Segment",-35000,-135000,350000,180000]
[null,"  Gewichtung",0,0,1,1]
[]
[null,"Auswertung Kennzahlen:"]
[null,null,"[ Segmentname]","[Segmentname]","[Segmentname]"]
[null,"Durchschnittskosten pro Neukunde",52500,30000,58750]
[null,"Durchschnittskosten pro Kundenabwicklung",80000,95000,70000]
[null,"Durchschnittliche Marketingkosten pro aktivem Kunden",25000,12500,27500]
[null,"Durchschnittlicher Gewinn (Verlust) pro Kunde",-5833.333333333333,-13500,35000]

{"sheet":"Auswertung Kennzahlen - Chart","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}