{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Neuwagen Erlöse - Citroën","Gebrauchtwagen Erlöse-Citroën","Werkstatt + Kaross.&Lack-Citroë","Citroën Teile","Sonstige Aktivitäten & andere M","Vermietung - Citroën","Betriebskosten-Gesamtunternehme","Pers. Statistik - Citroën","Zusammenfassung","Aktiva","Passiva"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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"}

{"sheet":"Neuwagen Erlöse - Citroën","index":0,"n_rows":259,"n_cols":10,"rows_kept":259,"cut":false,"hidden":false,"merged":[]}
[null,"Neuwagen Erlöse - Citroën"]
[""]
[null,"NW PKW - Kunden"]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","AK","Prämien","BE","BE %"]
["B1","C-ZERO",0,0,0,0,0,0,0,0]
["B2","e-MEHARI",0,0,0,0,0,0,0,0]
["B3","C1",0,0,0,0,0,0,0,0]
["B4","C3",0,0,0,0,0,0,0,0]
["B5","C3 Aircross",0,0,0,0,0,0,0,0]
["B6","C4",0,0,0,0,0,0,0,0]
["B179","e-C41",0,0,0,0,0,0,0,0]
["B7","C4 Cactus",0,0,0,0,0,0,0,0]
["B8","C-Elysée",0,0,0,0,0,0,0,0]
["B9","C4 Lounge",0,0,0,0,0,0,0,0]
["B10","C4 Spacetourer 5pl/7pl",0,0,0,0,0,0,0,0]
["B11","C5 Aircross",0,0,0,0,0,0,0,0]
["B180","C5 Aircross Hyb",0,0,0,0,0,0,0,0]
["B12","C5/C5 Tourer",0,0,0,0,0,0,0,0]
["B151","Nemo Multispace",0,0,0,0,0,0,0,0]
["B152","Berlingo",0,0,0,0,0,0,0,0]
["B169","Berlingo VP Elect",0,0,0,0,0,0,0,0]
["B153","Space Tourer/Jumpy",0,0,0,0,0,0,0,0]
["B154","Jumper Combi",0,0,0,0,0,0,0,0]
["B155","Sonstige 1",0,0,0,0,98.0,0,-98.0,0]
["B156","Sonstige 2",58.0,1143100.0,0,1143100.0,420090.0,0,723010.0,63.24993438894235]
["B13","Neuwagen  Citroën - Kunden",58.0,1143100.0,0,1143100.0,420188.0,0,722912.0,63.24136121074272]
[""]
[null,"NW PKW - Flottengeschäft"]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","AK","Prämien","BE","BE %"]
["B14","C-ZERO",0,0,0,0,0,0,0,0]
["B15","e-MEHARI",0,0,0,0,0,0,0,0]
["B16","C1",0,0,0,0,0,0,0,0]
["B17","C3",0,0,0,0,0,0,0,0]
["B18","C3 Aircross",0,0,0,0,0,0,0,0]
["B19","C4",0,0,0,0,0,0,0,0]
["B181","e-C41",0,0,0,0,0,0,0,0]
["B20","C4 Cactus",0,0,0,0,0,0,0,0]
["B21","C-Elysée",0,0,0,0,0,0,0,0]
["B22","C4 Lounge",0,0,0,0,0,0,0,0]
["B23","C4 Spacetourer 5pl/7pl",0,0,0,0,0,0,0,0]
["B24","C5 Aircross",0,0,0,0,0,0,0,0]
["B182","C5 Aircross Hyb",0,0,0,0,0,0,0,0]
["B25","C5/C5 Tourer",0,0,0,0,0,0,0,0]
["B157","Nemo Multispace",0,0,0,0,0,0,0,0]
["B158","Berlingo",0,0,0,0,0,0,0,0]
["B170","Berlingo VP Elect",0,0,0,0,0,0,0,0]
["B159","Space Tourer/Jumpy",0,0,0,0,0,0,0,0]
["B160","Jumper Combi",0,0,0,0,0,0,0,0]
["B161","Sonstige 1",0,0,0,0,0,0,0,0]
["B162","Sonstige 2",0,0,0,0,0,0,0,0]
["B26","Neuwagen Citroën  -  Flottengeschäft",0,0,0,0,0,0,0,0]
[""]
[null,"NW PKW - Vorführwagen"]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","AK","Prämien","BE","BE %"]
["B27","C-ZERO",0,0,0,0,0,0,0,0]
["B28","e-MEHARI",0,0,0,0,0,0,0,0]
["B29","C1",0,0,0,0,0,0,0,0]
["B30","C3",0,0,0,0,0,0,0,0]
["B31","C3 Aircross",0,0,0,0,0,0,0,0]
["B32","C4",0,0,0,0,0,0,0,0]
["B183","e-C41",0,0,0,0,0,0,0,0]
["B33","C4 Cactus",0,0,0,0,0,0,0,0]
["B34","C-Elysée",0,0,0,0,0,0,0,0]
["B35","C4 Lounge",0,0,0,0,0,0,0,0]
["B36","C4 Spacetourer 5pl/7pl",0,0,0,0,0,0,0,0]
["B37","C5 Aircross",0,0,0,0,0,0,0,0]
["B184","C5 Aircross Hyb",0,0,0,0,0,0,0,0]
["B38","C5/C5 Tourer",0,0,0,0,0,0,0,0]
["B163","Nemo Multispace",0,0,0,0,0,0,0,0]
["B164","Berlingo",0,0,0,0,0,0,0,0]
["B165","Space Tourer/Jumpy",0,0,0,0,0,0,0,0]
["B166","Jumper Combi",0,0,0,0,0,0,0,0]
["B171","Berlingo VP Elect",0,0,0,0,0,0,0,0]
["B167","Sonstige 1",1.0,25126.0,0,25126.0,39625.0,0,-14499.0,-57.705165963543735]
["B168","Sonstige 2",204.0,3506990.0,0,3506990.0,3647916.0,0,-140926.0,-4.018431760569605]
["B39","Neuwagen Citroën - Vorführwagen",205.0,3532116.0,0,3532116.0,3687541.0,0,-155425.0,-4.400336795280789]
[""]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","AK","Prämien","BE","BE %"]
["B40","Gesamt NW Citroën - Kunden, Flotte, Vorführwagen",263.0,4675216.0,0,4675216.0,4107729.0,0,567487.0,12.138198534570382]
[""]
[""]
[null,"NFZ - Kunden"]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","AK","Prämien","BE","BE %"]
["B41","Nemo",0,0,0,0,0,0,0,0]
["B42","Berlingo",0,0,0,0,0,0,0,0]
["B173","Berlingo VU Elect",0,0,0,0,0,0,0,0]
["B43","Jumpy",0,0,0,0,0,0,0,0]
["B185","Jumpy Elect",0,0,0,0,0,0,0,0]
["B44","Jumper",0,0,0,0,0,0,0,0]
["B45","Sonstige 1",0,0,0,0,0,0,0,0]
["B46","Sonstige 2",0,0,0,0,0,0,0,0]
["B47","Sonstige 3",0,0,0,0,0,0,0,0]
["B49","NFZ Citroën - Kunden",0,0,0,0,0,0,0,0]
[""]
[null,"NFZ - Flottengeschäft"]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","AK","Prämien","BE","BE %"]
["B50","Nemo",0,0,0,0,0,0,0,0]
["B51","Berlingo",0,0,0,0,0,0,0,0]
["B175","Berlingo VU Elect",0,0,0,0,0,0,0,0]
["B52","Jumpy",0,0,0,0,0,0,0,0]
["B186","Jumpy Elect",0,0,0,0,0,0,0,0]
["B53","Jumper",0,0,0,0,0,0,0,0]
["B54","Sonstige 1",0,0,0,0,0,0,0,0]
["B55","Sonstige 2",0,0,0,0,0,0,0,0]
["B56","Sonstige 3",0,0,0,0,0,0,0,0]
["B58","NFZ Citroën - Flottengeschäft",0,0,0,0,0,0,0,0]
[""]
[null,"NFZ - Vorführwagen"]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","AK","Prämien","BE","BE %"]
["B59","Nemo",0,0,0,0,0,0,0,0]
["B60","Berlingo",0,0,0,0,0,0,0,0]
["B177","Berlingo VU Elect",0,0,0,0,0,0,0,0]
["B61","Jumpy",0,0,0,0,0,0,0,0]
["B187","Jumpy Elect",0,0,0,0,0,0,0,0]
["B62","Jumper",0,0,0,0,0,0,0,0]
["B63","Sonstige 1",0,0,0,0,0,0,0,0]
["B64","Sonstige 2",0,0,0,0,0,0,0,0]
["B65","Sonstige 3",0,0,0,0,0,0,0,0]
["B67","NFZ Citroën- Vorführwagen",0,0,0,0,0,0,0,0]
[""]
[""]
["B68","Gesamt NFZ - Kunden, Flottengeschäft, Vorführwagen",0,0,0,0,0,0,0,0]
["B69","NW - Angeschl. Händler",0,0,0,0,0,0,0]
["B70","NW - Verkauf bilateraler Handel",0,0,0,0,0,0,0]
["B71","NW - Gelegenheitsverkäufe",0,0,0,0,0,0,0]
[""]
["B72","NFZ - Angeschl. Händler",0,0,0,0,0,0,0]
["B73","NFZ - Verkauf bilateraler Handel",0,0,0,0,0,0,0]
["B74","NFZ - Gelegenheitsverkäufe",0,0,0,0,0,0,0]
[""]
[""]
["B75","Gesamt Neuwagen Citroën",263.0,4675216.0,0,4675216.0,4107729.0,0,567487.0,12.138198534570382]
[""]
[""]
[""]
["B76","Bonusvolumen Kunden",{"$nulls":6},0]
["B77","Bonusvolumen Flottengeschäft",{"$nulls":6},0]
["B78","Bonusvolumen Sonstiges",{"$nulls":6},0]
["B79","Sonstiger Bonus",{"$nulls":6},0]
["B80","Bonus",{"$nulls":6},16468.0]
[""]
[""]
["B81","Gesamt Neuwagen Citroën (inkl. Bonus)",263.0,4675216.0,0,4675216.0,4107729.0,0,583955.0]
[""]
[null,"Sonstige Erlöse"]
[{"$nulls":5},"Nettoerlöse","AK"]
["B82","Zubehör auf NW",null,null,null,0,0,null,0]
["B83","Garantievertrag",null,null,null,0,0,null,0]
["B84","Service Wartungsvertrag",null,null,null,0,0,null,0]
["B85","Versicherungsverkauf",null,null,null,0,0,null,0]
["B86","Sonstige Umsätze",null,null,null,7.0,0,null,7.0]
[""]
[""]
[null,"Aufbereitungskosten"]
[{"$nulls":5},"Nettoerlöse","AK",null,"Wert"]
["B87","Zulassungen und Auslieferung",null,null,null,0,0,null,0]
["B88","Aufbereitung",null,null,null,0,0,null,0]
["B89","Gesamt Registrierung, Auslieferung und Aufbereitung",null,null,null,0,0,null,0]
["B90","Boni Aufbereitung (fest)",{"$nulls":6},0]
["B91","Boni Aufbereitung (flexible)",{"$nulls":6},0]
["B92","Gesamt Boni Aufbereitung",{"$nulls":6},0]
["B93","Gesamt Aufbereitsungskosten",{"$nulls":6},0]
[""]
[null,"Sonstige Provisionen"]
["B97","Provisionen Finanzierung und Versicherungen",{"$nulls":6},58203.0]
["B98","Provisionen Wartungsverträge",{"$nulls":6},0]
["B99","Provisionen Versicherungsverträge",{"$nulls":6},0]
[""]
[""]
[""]
["B100","Gesamt NW Citroën - Sonst. Provisionen & Erlöse",null,null,null,7.0,0,null,58210.0]
[""]
[""]
["B101","Gesamtumsatz NW Citroën",263.0,4675216.0,0,4675223.0,4107729.0,0,642165.0]
[""]
[null,"Variable Kosten"]
[{"$nulls":8},"Wert"]
["B102","Verkäufer Provisionen",{"$nulls":6},50387.0]
["B103","Vermittlungsprovision",{"$nulls":6},0]
["B104","Andere var. Verkaufskosten",{"$nulls":6},0]
["B105","GW Eintauschüberpreis",{"$nulls":6},0]
["B106","Umsatzfreie Artikel",{"$nulls":6},0]
["B107","Gesamt NW Citroën Variable Kosten",{"$nulls":6},50387.0]
[""]
["B108","NW Citroën Variabler Nettogewinn",{"$nulls":6},591778.0]
[""]
[null,"Direkte Kosten"]
[{"$nulls":8},"Wert"]
["B109","Gehalt der Abteilungsleitung",{"$nulls":6},0]
["B110","Löhne Verkäufer incl. Soz.aufwand",{"$nulls":6},0]
["B111","Löhne/Gehälter incl. Soz.aufwand",{"$nulls":6},238336.0]
["B112","Ausbildung/Schulung",{"$nulls":6},5570.0]
["B113","Werbung",{"$nulls":6},24970.0]
["B114","Laufende Fahrzeugkosten",{"$nulls":6},2154.0]
["B115","Bestandsabschreibungen",{"$nulls":6},0]
["B116","CRM Kosten (Personalkosten & sonstige Ausgaben)",{"$nulls":6},0]
["B117","Abschreibung Forderungen",{"$nulls":6},0]
["B118","Provisionen an Rückkäufen",{"$nulls":6},0]
["B119","Sonstige Direkte Kosten",{"$nulls":6},2855.0]
["B120","Gesamt NW Citroën - Direkte Kosten",{"$nulls":6},273885.0]
["B121","Neuwagen - Deckungsbeitrag",{"$nulls":6},317893.0]
[""]
[""]
[""]
[null,"Statistik"]
[null,null,"EH","Wert"]
["B122","Neu - Finanzprodukte",0,0]
["B123","Neu - Versicherungsscheine",0,0]
["B124","Neu - Finanzierung und Versicherung",0,0]
["B125","Garantievertrag",0,0]
["B126","Service Wartungsvertrag",0,0]
[""]
[""]
[null,"Bestand Neuwagen"]
[null,null,"EH","Wert"]
["B127","Bestand Zinsfrei",0,0]
["B128","Zinspflichtig",0,0]
[""]
[""]
[null,"Bestand Vorführwagen"]
[""]
["B129","Bestand - < 30 Tage",0,0]
["B130","Bestand - 31-60 Tage",0,0]
["B131","Bestand - 61-90 Tage",0,0]
["B132","Bestand - 91-180 Tage",0,0]
["B133","Bestand - > 180 Tage",0,0]
["B134","Bestand - > 1 Jahr",0,0]
["B135","Gesamtbestand Vorführwagen",0,0]
[""]
[""]
[null,"Bestand NW"]
[""]
["B136","Bestand - < 30 Tage",0,0]
["B137","Bestand - 31-60 Tage",0,0]
["B138","Bestand - 61-90 Tage",0,0]
["B139","Bestand - 91-180 Tage",0,0]
["B140","Bestand - > 180 Tage",0,0]
["B141","Bestand - > 1 Jahr",0,0]
["B142","Gesamtbestand NW",0,0]
[""]
[""]
[null,"Kommentar: Umsatzboni"]
[""]
["B143","Erhaltener Verkaufsbonus von NSC",0,0]
["B144","Erhaltener Verkaufsbonus des Unterbereiches",0,0]
[""]
[""]
[null,"Kommentar: Werbeangebote (alle Kanäle)"]
[null,null,"Nachlass","Ums.Boni"]
["B145","Kundenrabatte",0,0]
["B146","Werbeaufwand",0,0]
["B147","Aktionsangebote",0,0]
["B148","Entsorgungskosten",0,0]
["B149","Kommerzielle Vorleistungen",0,0]
["B150","Gesamt",0,0]
[""]
[""]
[null,"Kommentar: Online - Verkauf"]
["B178","Anzahl der online verkauften NW",0]

{"sheet":"Gebrauchtwagen Erlöse-Citroën","index":1,"n_rows":97,"n_cols":8,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,"Gebrauchtwagen Erlöse - Citroën"]
[""]
[null,null,"EH","Nettoerlöse","AK","Aufbereit.","BE","BE %"]
["E7","Gesamt GW Erlöse - Kunden",100,1573490,1435656,0,137834,8.759763328651596]
[""]
[""]
["E14","Gesamt GW Erlöse - Gewerbekunden",0,0,0,0,0,0]
["E15","GW Verschrottung",0,0,0,0,0,0]
["E16","Ankäufer / Handel",81,1073730,1046882,0,26848,2.5004423830944464]
["E17","Gesamt GW - Gewerbek., Verschrottung & Bilat. H.",81,1073730,1046882,0,26848,2.5004423830944464]
[""]
[""]
["E18","Gesamt GW - Citroën",181,2647220,2482538,0,164682,6.220941213801648]
[""]
[""]
["E19","Marken Verkaufsförderung",{"$nulls":4},0]
["E20","Sonstige Verkaufshilfen",{"$nulls":4},0]
["E21","Gesamt Verkaufshilfen",{"$nulls":4},0]
[""]
[""]
["E22","Bonus",{"$nulls":4},0]
[""]
["E23","Gesamt GW Citroën (Verkaufshilfen & Boni inkl)",181,2647220,2482538,0,164682,6.220941213801648]
[""]
[null,"Sonstige Erlöse"]
[null,null,null,"Nettoerlöse","AK",null,"Wert"]
["E24","Zulassung, Auslieferung & Aufbereitung",null,0,0,null,0]
["E25","Erweiterter Versicherungsverkauf",null,0,0,null,0]
["E26","Servieverträge",null,0,0,null,0]
["E27","Versicherungsverkauf",null,0,0,null,0]
["E28","GW Eintauschüberpreis",null,0,0,null,0]
["E29","Sonstige Erlöse",null,0,0,null,0]
["E30","Provision von Rückkäufen",null,0,null,null,0]
["E31","Bestandskorrektur",null,null,0,null,0]
["E32","Extra Kilometer und sonstige Einnahmen aus Leasing",null,0,null,null,0]
[""]
[null,"Sonstige Provisionen"]
[{"$nulls":6},"Wert"]
["E35","Provisionen Finanzierung und Versicherungen",{"$nulls":4},0]
["E36","Provisionen erweiterte Versicherungsverträge",{"$nulls":4},0]
[""]
["E37","Gesamtumsatz GW Citroën",181,2647220,2482538,0,164682]
[""]
[null,"Variable Kosten"]
[{"$nulls":6},"Wert"]
["E38","Verkäufer Provisionen",{"$nulls":4},0]
["E39","Vermittlungsprovision",{"$nulls":4},0]
["E40","Gewährte Kulanz/Garantie",{"$nulls":4},623]
["E41","Transport",{"$nulls":4},0]
["E42","Andere var. Verkaufskosten",{"$nulls":4},0]
["E43","Gesamt Variable Kosten",{"$nulls":4},623]
[""]
[""]
["E44","Gesamt GW Citroën - Bruttoertrag",{"$nulls":4},164059]
[""]
[null,"Direkte Kosten"]
[{"$nulls":6},"Wert"]
["E45","Gehalt der Abteilungsleitung",{"$nulls":4},0]
["E46","Löhne Verkäufer incl. Soz.aufwand",{"$nulls":4},0]
["E47","Löhne/Gehälter incl. Soz.aufwand",{"$nulls":4},21000]
["E48","Ausbildung/Schulung",{"$nulls":4},0]
["E49","Werbung",{"$nulls":4},0]
["E50","Laufende Fahrzeugkosten",{"$nulls":4},1830]
["E51","Bestandsabschreibungen",{"$nulls":4},0]
["E52","CRM Kosten",{"$nulls":4},0]
["E53","Abschreibung Forderungen",{"$nulls":4},0]
["E54","Sonstige Direkte Kosten",{"$nulls":4},255]
["E55","Gesamt Direkte Kosten",{"$nulls":4},23085]
[""]
["E56","GW Citroën - Deckungsbeitrag",{"$nulls":4},140974]
[""]
[null,"Statistik"]
[null,null,"EH","Wert"]
["E57","GW - Finanzprodukte",0,0]
["E58","GW - Versicherungsscheine",0,0]
[""]
[null,"Bestandsanalyse"]
[null,null,"EH","Wert"]
["E59","Bestand - < 30 Tage",0,0]
["E60","Bestand - 31-60 Tage",0,0]
["E61","Bestand - 61-90 Tage",0,0]
["E62","Bestand - 91-180 Tage",0,0]
["E63","Bestand - > 180 Tage",0,0]
["E64","Bestand - > 1 Jahr",0,0]
["E65","Gesamtbestand GW",0,0]
["E66","davon GW Marke",0,0]
["E67","davon GW keine Marke",0,0]
[""]
[null,"Verkauf nach Marke"]
[null,null,"EH"]
["E68","GW Marke - Kunde",2]
["E69","GW keine Marke - Kunde",0]
["E70","Gesamtvolumen - Kunde",2]
[""]
[null,"Kommentar"]
[""]
["E71","Aufbereitungskosten für Leasingfahrzeuge",null,0]

{"sheet":"Werkstatt + Kaross.&Lack-Citroë","index":2,"n_rows":170,"n_cols":9,"rows_kept":170,"cut":false,"hidden":false,"merged":[]}
[null,"Werkstatt + Kaross. & Lack - Citroën"]
[""]
[null,"Werkstatt Lohnerlöse"]
[null,null,"Verk Std","Erlöse","Nachlass","Nettoerl.","AK","BE","BE %"]
[""]
[""]
["N1b","Kunden",2032,166071,0,166071,72012.92020966802,94058.07979033198,56.63726947530392]
["N2b","Komplettpreise",0,0,0,0,0,0,0]
["N3b","Servicevertrag",0,0,0,0,0,0,0]
["N4b","Versicherungen",4,279,0,279,141.7577169481654,137.2422830518346,49.190782455854695]
["N5b","Intern",764,64392,0,64392,27075.723937099592,37316.276062900404,57.951727020282654]
["N6b","Garantie",634,56490,0,56490,22468.598136284218,34021.401863715786,60.22552994107946]
["N7b","TÜV",0,0,0,0,0,0,0]
["N8b","Gesamt Werkstatt Citroën - Lohnerlöse",3434,287232,0,287232,121699,165533,57.63041722370767]
[""]
[null,"Karosserie & Lack Lohnerlöse"]
[""]
[""]
[""]
["N9b","Kunden",214,19261,0,19261,0,19261,100]
["N10b","Komplettpreise",0,0,0,0,0,0,0]
["N11b","Versicherungen",0,0,0,0,0,0,0]
["N12b","Intern",0,0,0,0,0,0,0]
["N13b","Garantie",0,0,0,0,0,0,0]
["N14b","Gesamt Karosserie & Lack Citroën - Lohnerlöse",214,19261,0,19261,0,19261,100]
[""]
[null,"Werkstatt Teileverkauf"]
[null,null,null,"Erlöse","Nachlass","Nettoerl.","AK","BE","BE %"]
[""]
[""]
["N15b","Werkstatt Kunden",null,0,0,0,0,0,0]
["N16b","Werkstatt Komplettpreise",null,0,0,0,0,0,0]
["N17b","Werkstatt Servicevertrag",null,0,0,0,0,0,0]
["N18b","Werkstatt Versicherung",null,0,0,0,0,0,0]
["N19b","Werkstatt Intern",null,0,0,0,0,0,0]
["N20b","Werkstatt Garantie",null,0,0,0,0,0,0]
["N21b","Werkstatt TÜV",null,0,0,0,0,0,0]
["N22b","Gesamt Werkstatt Teile Citroën - Erlöse",null,0,0,0,0,0,0]
[""]
[null,"Karosserie & Lack Teileverkauf"]
[""]
[""]
[""]
["N23b","Karosserie & Lack Werkstatt Kunden",null,0,0,0,0,0,0]
["N24b","Karosserie & Lack Komplettpreise",null,0,0,0,0,0,0]
["N25b","Karosserie & Lack Versicherung",null,0,0,0,0,0,0]
["N26b","Karosserie & Lack Intern",null,0,0,0,0,0,0]
["N27b","Karosserie & Lack Garantie",null,0,0,0,0,0,0]
["N28b","Gesamt Teile Karosserie & Lack Citroën - Erlöse",null,0,0,0,0,0,0]
[""]
[""]
[{"$nulls":7},"Wert"]
["N29","Marken Verkaufshilfen",{"$nulls":5},0]
["N30","Sonstige Verkaufshilfen",{"$nulls":5},0]
["N31","Bonus",{"$nulls":5},0]
["N32","Gesamt Bonus und Verkaufshilfen",{"$nulls":5},0]
[""]
[{"$nulls":5},"Nettoerlöse","AK","BE"]
["N33","Karosserie & Lack Fremdleistungen - Intern",null,null,null,5932,850,5082]
["N34","Karosserie & Lack Fremdleistungen - Extern",null,null,null,32847,43161,-10314]
["N35","Leiharbeit - Intern",null,null,null,0,0,0]
["N36","Leiharbeit - Extern",null,null,null,0,0,0]
["N37","Sonstige Erlöse",null,null,null,3173,0,3173]
["N38","Gesamt Werkstatt + Kaross. & Lack Citroën - Erlöse",3648,348445,0,348445,165710,182735]
[""]
["N39","Umsatz Werkstattmaterial",null,null,null,0,0,0]
["N40","Werkstattersatzwagen",null,null,null,0,0,0]
["N41","Pannenhilfe",null,null,null,0,0,0]
["N42","Bezahlte Provisionen",null,null,null,0,0,0]
["N43","Sonstige variable Kosten",null,null,null,0,8789,-8789]
[""]
["N44","Total Workshop & BS Citroën Sales & Operating Income",null,348445,0,348445,174499,173946]
[""]
[null,"Direkte Kosten"]
[{"$nulls":7},"Wert"]
["N45","Gehalt der Abteilungsleitung",{"$nulls":5},0]
["N46","Serviceberater",{"$nulls":5},0]
["N47","Indirekte Löhne/Gehälter incl. Soz.aufwand",{"$nulls":5},157256]
["N48","Ausbildung/Schulung",{"$nulls":5},7948]
["N49","Werbung",{"$nulls":5},175]
["N50","Werkstattmaterial",{"$nulls":5},0]
["N51","Laufende Fahrzeugkosten",{"$nulls":5},410]
["N52","CRM Kosten",{"$nulls":5},0]
["N53","Ausgabeaufschlag",{"$nulls":5},0]
["N54","Abschreibung Forderungen",{"$nulls":5},0]
["N55","Sonstige Kosten",{"$nulls":5},2692]
["N56","Ges. Werkst. + Kaross. & Lack Citroën - Direkt. Kost.",{"$nulls":5},168481]
[""]
[""]
["N57","DB Werkstatt + Karosserie & Lack Citroën",{"$nulls":5},5465]
[""]
[null,"Werkstatt Statistiik"]
[""]
[null,"Stundenanalyse"]
[null,null,"Std."]
["N61","Gesamt bezahlte Stunden",0]
["N62","Abwesenheitsstd (Urlaub, Krankheit...) - excl. Training",0]
["N63","Abwesenheitsstunden (Training)",0]
["N64","Gesamt Anwesenh. Stunden",0]
["N65","Prod. Stunden - Kunden",0]
["N66","Prod. Stunden - Komplettpreise",0]
["N67","Prod. Stunden - Serviceverträge",0]
["N68","Prod. Stunden - Versicherung",0]
["N69","Prod. Stunden - Intern",0]
["N70","Prod. Stunden - Garantie",0]
["N71","Prod. Stunden - TÜV",0]
["N72","Gesamt produktive Stunden",0]
[""]
["N73","Anz. Arbeitsplätze",0]
[""]
[null,"Anzahl der Durchgänge"]
[null,null,"EH"]
["N74","Durchgänge - Kunde",0]
["N75","Durchgänge - Komplettpreise",0]
["N76","Durchgänge - Serviceverträge",0]
["N77","Durchgänge - Versicherungen",0]
["N78","Durchgänge - Intern",0]
["N79","Durchgänge - Garantie",0]
["N80","Durchgänge - TÜV",0]
["N81","Durchgänge Gesamt",0]
[""]
[null,"Verrechnungssätze"]
[null,null,"Wert"]
["N82","Kunden",0]
["N83","Komplettpreise",0]
["N84","Servicevertrag",0]
["N85","Versicherungen",0]
["N86","Intern",0]
["N87","Garantie",0]
["N88","TÜV",0]
[""]
[null,"Karosserie & Lack Statistik"]
[""]
[null,"Stundenanalyse"]
[null,null,"Std."]
["N92","Gesamt bezahlte Stunden",0]
["N93","Abwesenheitsstd (Urlaub, Krankheit...) - excl. Training",0]
["N94","Abwesenheitsstunden (Training)",0]
["N95","Gesamt Anwesenh. Stunden",0]
["N96","Prod. Stunden - Kunden",0]
["N97","Prod. Stunden - Komplettpreise",0]
["N98","Prod. Stunden - Serviceverträge",0]
["N99","Prod. Stunden - Versicherung",0]
["N100","Prod. Stunden - Intern",0]
["N101","Prod. Stunden - Garantie",0]
["N102","Prod. Stunden - TÜV",0]
["N103","Gesamt produktive Stunden",0]
[""]
["N104","Anz. Arbeitsplätze",0]
[""]
[null,"Anzahl der Durchgänge"]
[null,null,"EH"]
["N105","Durchgänge - Kunden",0]
["N106","Durchgänge - Komplettpreise",0]
["N107","Durchgänge - Serviceverträge",0]
["N108","Durchgänge - Versicherungen",0]
["N109","Durchgänge - Intern",0]
["N110","Durchgänge - Garantie",0]
["N111","Durchgänge - TÜV",0]
["N112","Durchgänge Gesamt",0]
[""]
[null,"Verrechnungssätze"]
[null,null,"Wert"]
["N113","Kunden",0]
["N114","Komplettpreise",0]
["N115","Servicevertrag",0]
["N116","Versicherungen",0]
["N117","Intern",0]
["N118","Garantie",0]
["N119","Tüv",0]

{"sheet":"Citroën Teile","index":3,"n_rows":151,"n_cols":8,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
[null,"Teile - Citroën"]
[""]
[null,"Teile - Citroën Original"]
[null,null,"Verk. Erlös","Nachlass","Nettoerlöse","AK","BE","BE %"]
["T1a","Verkauf Theke",12472,0,12472,9806,2666,21.3758819756254]
["T2a","Verkauf Handel",3533,0,3533,1777,1756,49.70280215114634]
["T3a","ERCS Netzwerk",0,0,0,0,0,0]
["T4a","AR & Verkauf an AVH",0,0,0,0,0,0]
["T5a","Verkauf an Händler",0,0,0,0,0,0]
["T6a","Reifen/Zubehör",0,0,0,0,0,0]
["T7a","Sonstige Erlöse",0,0,0,0,0,0]
["T8a","Gesamt Teile Extern",16005,0,16005,11583,4422,27.628865979381445]
[""]
[""]
[""]
[""]
["T9a","Werkstatt Kunden",162856,11183,151673,80606,71067,43.637937810089895]
["T10a","Werkstatt Komplettpreise",0,0,0,0,0,0]
["T11a","Werkstatt Servicevertrag",0,0,0,0,0,0]
["T12a","Werkstatt Versicherung",0,0,0,0,0,0]
["T13a","Werkstatt Intern",54790,0,54790,45094,9696,17.696659974447893]
["T14a","Werkstatt Garantie",71202,0,71202,59425,11777,16.540265722872956]
["T15a","Werkstatt TÜV",0,0,0,0,0,0]
["T16a","Gesamt Teile - Werkstatt",288848,11183,277665,185125,92540,32.037611477316794]
[""]
[""]
[""]
[""]
["T17a","Chrono Service Kunden",0,0,0,0,0,0]
["T18a","Chrono Service Komplettpreise",0,0,0,0,0,0]
["T19a","Chrono Service Servicevertrag",0,0,0,0,0,0]
["T20a","Chrono Service Intern",0,0,0,0,0,0]
["T21a","Chrono Service Garantie",0,0,0,0,0,0]
["T22a","Gesamt Teile - Chrono Service",0,0,0,0,0,0]
[""]
[""]
[""]
[""]
["T23a","Karosserie & Lack Kunden",0,0,0,0,0,0]
["T24a","Karosserie & Lack Komplettpreise",0,0,0,0,0,0]
["T25a","Karosserie & Lack Versicherung",0,0,0,0,0,0]
["T26a","Karosserie & Lack Intern",0,0,0,0,0,0]
["T27a","Karosserie & Lack Garantie",0,0,0,0,0,0]
["T28a","Gesamt Teile - Karosserie & Lack",0,0,0,0,0,0]
[""]
[""]
[""]
[""]
["T37a","Intern Chrono Service Kunden",0,0,0,0,0,0]
["T38a","Intern Chrono Service Komplettpreise",0,0,0,0,0,0]
["T39a","Intern Chrono Service Servicevertrag",0,0,0,0,0,0]
["T40a","Intern Chrono Service Intern",0,0,0,0,0,0]
["T41a","Intern Chrono Service Garantie",0,0,0,0,0,0]
["T42a","Gesamt Teile - Intern Chrono Service",0,0,0,0,0,0]
[""]
[""]
[""]
[""]
["T43a","Intern Karosserie & Lack Kunden",0,0,0,0,0,0]
["T44a","Intern Karosserie & Lack Komplettpreise",0,0,0,0,0,0]
["T45a","Intern Karosserie & Lack Versicherung",0,0,0,0,0,0]
["T46a","Intern Karosserie & Lack Intern",0,0,0,0,0,0]
["T47a","Intern Karosserie & Lack Versicherung",0,0,0,0,0,0]
["T48a","Gesamt Teile - Intern Karosserie & Lack",0,0,0,0,0,0]
[""]
[""]
[""]
[""]
[""]
["T50","Gesamt Teile (inkl. Intern)",304853,11183,293670,196708,96962,31.806149193217713]
[""]
[""]
["T51","Gesamt Teile",304853,11183,293670,196708,96962,31.806149193217713]
[""]
[""]
["T52","Deckungsbeitrag Teile (inkl. Intern)",{"$nulls":4},96962,31.806149193217713]
[""]
[""]
["T53","Marken Volumenbonus - Ausführung",{"$nulls":4},0]
["T54","Marken Volumenbonus - Verkaufswerbung",{"$nulls":4},0]
["T55","Gesamt Marken Volumenbonus",{"$nulls":4},0]
[""]
[""]
["T56","Parts Hub Volumenbonus - Ausführung",{"$nulls":4},0]
["T57","Parts Hub Volumenbonus - Verkaufswerbung",{"$nulls":4},0]
["T58","Gesamt Parts Hub Volumenbonus",{"$nulls":4},0]
[""]
[""]
["T59","Sonstige Verkaufshilfen",{"$nulls":4},0]
["T60","Bonus",{"$nulls":4},0]
[""]
["T61","Gesamt Teile Citroën - Erlöse",304853,11183,293670,196708,96962]
[""]
[""]
["T62","Fremdteile",134921,0,134921,80971,53950]
[""]
[""]
["T63","Umsatz Gesamt",439774,11183,428591,277679,150912]
[""]
[null,"Variable Kosten"]
[{"$nulls":6},"Wert"]
["T64","Vermittlungsprovision & Kundenbonus",{"$nulls":4},0]
["T65","Verpackung und Transport",{"$nulls":4},0]
["T66","Andere Verkaufskosten Zugaben",{"$nulls":4},0]
["T67","Gesamt Variable Kosten",{"$nulls":4},0]
[""]
[""]
["T68","Bruttoertrag",{"$nulls":4},150912]
[""]
[null,"Direkte Kosten"]
[{"$nulls":6},"Wert"]
["T69","Gehalt der Abteilungsleitung",{"$nulls":4},0]
["T70","Gehälter incl. Soz. Aufwand Teileverkäufer",{"$nulls":4},0]
["T71","Gehälter incl. Soz. Aufwand sonstige Angest.",{"$nulls":4},65518]
["T72","Ausbildung/Schulung",{"$nulls":4},0]
["T73","Werbung",{"$nulls":4},0]
["T74","Wartung und Abschreibung",{"$nulls":4},0]
["T75","Fahrzeugkosten",{"$nulls":4},0]
["T76","Bestandsabschreibungen",{"$nulls":4},0]
["T77","CRM Kosten",{"$nulls":4},0]
["T78","Abschreibung Forderungen",{"$nulls":4},0]
["T79","Lagerbestand Anpassung",{"$nulls":4},0]
["T80","Sonstige Kosten",{"$nulls":4},161]
["T81","Gesamt Direkte Kosten",{"$nulls":4},65679]
[""]
[""]
["T82","Deckungsbeitrag",{"$nulls":4},85233]
[""]
[null,"Statistik"]
[""]
[null,"Bestand Altersstruktur"]
[{"$nulls":6},"Wert"]
["T83","Bestand - 6 Monate",{"$nulls":4},0]
["T84","Bestand - 6-12 Monate",{"$nulls":4},0]
["T85","Bestand - 12-24 Monate",{"$nulls":4},0]
["T86","Bestand - > 24 Monate",{"$nulls":4},0]
["T87","Gesamt Bestand",{"$nulls":4},0]
["T88","davon Citroën Original",{"$nulls":4},0]
["T89","davon ERCS",{"$nulls":4},0]
["T90","davon IAM",{"$nulls":4},0]
["T91","davon andere Marken/kein origin. Equip.",{"$nulls":4},0]
[""]
[null,"Kommentar: Umsatzanalyse"]
[null,null,"Verk. Erlöse","Nachlass","Nettoerlöse","AK","BE"]
["T92","Citroën Original",304853,11183,293670,196709,96961]
["T93","ERCS Teile",0,0,0,0,0]
["T94","IAM Teile",0,0,0,0,0]
["T95","Schmierstoffe",48419,0,48419,9656,38763]
["T96","Reifen",42266,0,42266,38275,3991]
["T97","Sonstige",44236,0,44236,33040,11196]
["T98","Gesamt",439774,11183,428591,277680,150911]

{"sheet":"Sonstige Aktivitäten & andere M","index":4,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Sonstige Aktivitäten & andere Marken"]
[""]
[null,null,"Erlöse","AK","Bruttoertrag","BE %"]
["V1","Tankstelle",-126,0,-126,100]
["V2","Waschstraße",0,0,0,0]
["V3","Leasing",0,0,0,0]
["V4","Krafträder",0,0,0,0]
["V5","Sonstige",0,0,0,0]
["V6","Gesamtumsatz",-126,0,-126,100]
[""]
[""]
["V7","Sonstige Aktivitäten - Variable und Fixe Kosten",null,null,1912,-1517.4603174603174]
["V8","Gesamt Sonstige Aktivitäten",null,null,-2038,1617.4603174603174]
[""]
[null,"Andere Marken (keine PSA Aktivitäten)"]
[""]
[null,null,"Erlöse","AK","Bruttoertrag","BE %"]
["V9","Andere Marken Umsatz",94277072,88758300,5518772,5.853779591288113]
[""]
[{"$nulls":4},"Wert","% Ums."]
["V10","Andere Marken - Variable und Fixe Kosten",null,null,3482108,3.693483395411347]
[""]
[""]
["V11","Deckungsbeitrag Andere Marken",null,null,2036664,2.160296195876766]

{"sheet":"Vermietung - Citroën","index":5,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[""]
[null,"Vermietung - Citroën"]
[""]
[null,null,"Erlöse","AK","BE","BE %"]
["X1","Vermietung",0,0,0,0]
["X2","Versicherungen",0,0,0,0]
["X3","Sonstiges",11271,0,11271,100]
["X4","Summe Vermietung",11271,0,11271,100]
["X5","Verkauf Mietfahrzeuge",0,0,0,0]
[""]
[""]
["X6","Gesamt Vermietung",11271,0,11271,100]
[""]
[null,"Mietwagenflotte Kosten"]
[""]
["X7","Fahrzeugabschreibung",null,null,0]
["X8","Fahrzeugwartung",null,null,2776]
["X9","Fahrzeuge - Sonstige Kosten",null,null,0]
["X10","Gesamt Mietwagenflotte - Kosten",null,null,2776]
[""]
[""]
["X11","Gesamt Vermietung BE",null,null,8495]
[""]
[null,"Vermietung Direkte Kosten"]
[""]
["X12","Personalkosten",null,null,0]
["X13","Ausbildung/Schulung",null,null,0]
["X14","Werbung",null,null,0]
["X15","Sonstige Kosten",null,null,0]
["X16","Gesamt Direkte Kosten",null,null,0]
[""]
[""]
["X17","Gesamt Vermietung",null,null,8495]
[""]
[null,"Statistik"]
[{"$nulls":4},"Wert"]
["X18","Miettage",null,null,0]
["X19","Mieteinheiten",null,null,0]
[""]
[""]
[null,"Kommentar: F2M Free2Move"]
["X20","Miettage F2M",null,null,0]
["X21","Mieteinheiten F2M",null,null,0]

{"sheet":"Betriebskosten-Gesamtunternehme","index":6,"n_rows":118,"n_cols":8,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[null,"Betriebskosten-Gesamtunternehmen"]
[{"$nulls":4},"Aufteilung%"]
[null,null,null,"% Peugeot","% Citroën","% DS","% Opel","% And. Marken"]
[null,null,null,0,10,0,0,90]
[""]
[null,"Kosten Grundvermögen"]
[null,null,"Kosten","Peugeot","Citroën","DS","Opel","Andere Marken"]
[""]
["ZA1","Miete",611095,0,61109.5,0,0,549985.50]
["ZA2","Gebühren und Abgaben",27055,0,2705.5,0,0,24349.5]
["ZA3","Leasing Gebäude",0,0,0,0,0,0]
["ZA4","Instandhaltung Gebäude",56454,0,5645.400000000001,0,0,50808.60]
["ZA5","Afa Gebäude",0,0,0,0,0,0]
["ZA6","Heizung/Gas/Wasser/Strom",60165,0,6016.5,0,0,54148.5]
["ZA7","Reinigung",28733,0,2873.30,0,0,25859.70]
["ZA8","Versicherungen",0,0,0,0,0,0]
["ZA9","Sicherheitskosten",0,0,0,0,0,0]
["ZA10","Sonstige",0,0,0,0,0,0]
["ZA11","Gesamt Aufwand Grundbesitz/Eigentum",783502,0,78350.20,0,0,705151.80]
[""]
[null,"Kosten für die Administration & GF"]
[""]
["ZA12","Gehälter Verwaltung",483719,0,48371.90,0,0,435347.10]
["ZA13","Interim & Administrative Angestellte",0,0,0,0,0,0]
["ZA14","Geschäftsführergehalt",0,0,0,0,0,0]
["ZA15","Ausbildung/Schulung",5583,0,558.3000000000001,0,0,5024.70]
["ZA16","Gesamt Kosten für die Administration & GF",489302,0,48930.20,0,0,440371.80]
[""]
[null,"Holding"]
[""]
["ZA17","Holding Kosten - Personal",0,0,0,0,0,0]
["ZA18","Holding Kosten - Sonstiges",0,0,0,0,0,0]
["ZA19","Holidng Gebühren",0,0,0,0,0,0]
["ZA20","Gesamt Holding Kosten & Gebühren",0,0,0,0,0,0]
[""]
[null,"Allgemeine Kosten"]
[""]
["ZA21","Abschreibung Kundendienst Ausstattung",0,0,0,0,0,0]
["ZA22","Abschreibung sonstige Ausstattung",0,0,0,0,0,0]
["ZA23","Leasing Ausstattung",13191,0,1319.10,0,0,11871.90]
["ZA24","Wartungsequipment",0,0,0,0,0,0]
["ZA25","Porto und Telefon",83668,0,8366.800000000001,0,0,75301.20]
["ZA26","Büromaterial",19510,0,1951,0,0,17559]
["ZA27","Versicherung (o. Gebäude)",186057,0,18605.70,0,0,167451.30000000002]
["ZA28","Beratungs- , Mitgliedschafts- und Anwaltskosten",3248,0,324.80,0,0,2923.2000000000003]
["ZA29","Firmenwerbung etc",59356,0,5935.60,0,0,53420.40]
["ZA30","Reisekosten",36727,0,3672.7000000000003,0,0,33054.30]
["ZA31","Kosten Betriebs-Kfz",306743,0,30674.300000000003,0,0,276068.70]
["ZA32","Afa Betriebs-Kfz",0,0,0,0,0,0]
["ZA33","Gebühren und Beiträge",86806,0,8680.60,0,0,78125.40000000001]
["ZA34","IT Kosten",49758,0,4975.80,0,0,44782.20]
["ZA35","Abschreibung Forderungen",0,0,0,0,0,0]
["ZA36","Andere Provisionen",0,0,0,0,0,0]
["ZA37","C3S",0,0,0,0,0,0]
["ZA38","CET",0,0,0,0,0,0]
["ZA39","Sonst. Abg. & Steuern (o. Einkommens- & Immobilienst.)",0,0,0,0,0,0]
["ZA40","Ges. sonst. Abg. & Steuern (o. Eink.- & Immo. St.)",0,0,0,0,0,0]
["ZA41","Bankgebühren",0,0,0,0,0,0]
["ZA42","Sonstige Afa",619917,0,61991.70,0,0,557925.30]
["ZA43","Interne Blockkosten",0,0,0,0,0,0]
["ZA44","Sonstige Betriebsausgaben",230813,0,23081.300000000003,0,0,207731.70]
["ZA45","Gesamt Betiebsausgaben",1695794,0,169579.40000000002,0,0,1526214.60]
[""]
[""]
["ZA46","Blockkosten Gesamt",2968598,0,296859.80000000005,0,0,2671738.20]
[""]
[""]
["ZA47","Operatives Ergebnis",-375912.00000000023,0,261200.19999999995,0,0,-637112.2000000002]
[""]
[""]
[null,"Zinsaufwand/-ertrag"]
[""]
[null,null,"Kosten","Peugeot","Citroën","DS","Opel","Andere Marken"]
["ZA48","Zinsaufwand NW",2381,0,238.10000000000002,0,0,2142.90]
["ZA49","Zinsaufwand GW",17915,0,1791.5,0,0,16123.5]
["ZA50","Zinsaufwand Vermietungen",0,0,0,0,0,0]
["ZA51","Passivzinsen Peugeot - Sonstige Anleihen",0,0,0,0,0,0]
["ZA52","Zinsen Fzg. Bestand Hausbank",0,0,0,0,0,0]
["ZA53","Überziehungszinsen",0,0,0,0,0,0]
["ZA54","Zinsen / Hypothekenzinsen",0,0,0,0,0,0]
["ZA55","Sonstige Zinsaufwendungen",42386,0,4238.60,0,0,38147.40]
["ZA56","Darlehenszinsen anderer Banken",0,0,0,0,0,0]
["ZA57","Gesamt Zinssaldo",62682,0,6268.200000000001,0,0,56413.80]
[""]
[""]
["ZA58","Zinserträge",583,0,58.30,0,0,524.70]
[""]
[""]
["ZA59","Gesamt Zinsaufwand",-62099,0,-6209.900000000001,0,0,-55889.100000000006]
[""]
[""]
["ZA60","Ergebnis vor Neutralem Ergebnis",-438011.00000000023,0,254990.29999999996,0,0,-693001.3000000002]
[""]
[""]
["ZA61","Sonstige Unternehmenseinnahmen",0,0,0,0,0,0]
[""]
["ZA62","Sonstige Unternehmensabzüge",0,0,0,0,0,0]
[""]
["ZA63","Regierungssubventionen",0,0,0,0,0,0]
[""]
[""]
["ZA64","Unrealisierte Erträge (-)",0,0,0,0,0,0]
["ZA65","Sonstige Neutrale Kosten",16487,0,1648.70,0,0,14838.30]
["ZA66","Gesamt Neutrale Kosten",16487,0,1648.70,0,0,14838.30]
[""]
[""]
["ZA67","Unrealisierte Erträge (+)",0,0,0,0,0,0]
["ZA68","Sonstige Neutrale Erlöse",62081,0,6208.10,0,0,55872.90]
["ZA69","Gesamt Neutrale Erlöse",62081,0,6208.10,0,0,55872.90]
[""]
[""]
["ZA70","Unternehmensergebnis vor Steuern",-392417.00000000023,0,259549.69999999995,0,0,-651966.7000000002]
[""]
[""]
["ZA71","Steuer auf Einkommen und Ertrag",0,0,0,0,0,0]
[""]
[""]
["ZA72","Nettogewinn",-392417.00000000023,0,259549.69999999995,0,0,-651966.7000000002]

{"sheet":"Pers. Statistik - Citroën","index":7,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Pers. Statistik - Citroën"]
[""]
[null,null,"NW","GW","Teile","Werkstatt","Chrono Service","K & L","And. Akt.","Verm.","And. Mark.","Verwalt.","Gesamt"]
["AD1","Abteilungsleitung",0,0,0,0,0,0,0,0,2,0,2]
["AD2","Serviceberater",null,null,null,3,0,0,{"$nulls":4},3]
["AD3","Verkäufer",1,1,1,null,null,null,0,null,8,null,11]
["AD4","- davon Flottengeschäft",0,0,0,{"$nulls":7},0]
["AD5","- davon im Verkaufsraum",0,0,0,{"$nulls":7},0]
["AD6","- davon Wechselarbeiter",0,0,0,{"$nulls":7},0]
["AD7","GW Experten",null,0,{"$nulls":8},0]
["AD8","Aufbereitung",0,0,null,0,{"$nulls":4},0,null,0]
["AD9","Administrativ",1,0,0,0,0,0,null,null,1,0,2]
["AD10","- davon CRM",0,0,0,0,0,0,{"$nulls":4},0]
[""]
["AD11","Monteure",null,null,null,5,0,0,null,null,38,null,43]
["AD12","- davon Spezialisiert",null,null,null,0,0,{"$nulls":5},0]
[""]
["AD13","Auszubildende im 1. Lehrjahr",0,0,0,2,0,0,0,0,9,0,11]
["AD14","Auszubildende im 2. Lehrjahr",0,0,0,0,0,0,0,0,0,0,0]
["AD15","Auszubildende im 3. Lehrjahr",0,0,0,0,0,0,0,0,0,0,0]
["AD16","Gesamt Auszubildende",0,0,0,2,0,0,0,0,9,0,11]
["AD17","Sonstige Angestellte",0,0,2,1,0,0,0,0,18,18,39]
[""]
["AD18","Teilhaber/Inhaber",0,0,0,0,0,0,0,0,1,0,1]
["AD19","Gesamt Angestellte Citroën",2,1,3,11,0,0,0,0,77,18,112]

{"sheet":"Zusammenfassung","index":8,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Zusammenfassung"]
[""]
[null,null,"EH","Umsatz","Nachlass","Nettoerlöse","Bruttoertrag","BE %","Bruttogewinn","Bruttogew. %"]
["AB1","Gesamt Neuwagen (PKW+NV)",263,4675216,0,4675223,591778,12.657768111676551,317893,6.799536106994843]
[""]
["AB2","Gebrauchtwagen",181,null,null,2647220,164059,6.197407091212669,140974,5.325360189179592]
[""]
["AB3","Gesamt Fahrzeuge",444,4675216,0,7322443,755837,10.322206981392531,458867,6.266589424612247]
[""]
[null,null,"Std.","Umsatz","Nachlass","Nettoerlöse","Bruttoertrag","BE %","Bruttogewinn","Bruttogew. %"]
["AB4","Teile",null,439774,11183,428591,150912,34.315807664846034,85233,19.381091196842014]
["AB5","Werkstatt",0,0,0,0,0,0,0,0]
["AB6","Rapid Service Abteilung",0,0,0,0,0,0,0,0]
["AB7","Karosserie & Lack",0,0,0,0,0,0,0,0]
["AB8","Werkstatt & Karosserie",3648,348445,0,348445,173946,49.92064744794731,5465,1.5683967340613294]
["AB9","Gesamt Kundendienst",3648,788219,11183,777036,324858,41.214180322981306,90698,11.50670054895911]
[""]
["AB10","Andere Aktivitäten",null,null,null,-126,-126,100,-2038,1617.4603174603174]
["AB11","Vermietung",null,null,null,11271,8495,75.37041966107711,8495,75.37041966107711]
["AB12","Gesamt Unternehmen",null,5463435,11183,8110624,1089064,13.409145755866925,556022,6.846043980398433]
[""]
["AB13","PSA Blockkosten",{"$nulls":6},2968598,2.8990534192603215]
["AB15","Operativ. Ergebn.(exkl. And. Mark.)",{"$nulls":6},-2412576,-29.704942254180107]
["AB14","Andere Marken",null,null,null,0,0,0,2036664,1.9889515970449363]
["AB21","Andere Marken Blockkosten","","","","","","",0,0]
["AB16","Operativ. Ergebn.(inkl. And. Mark.)",{"$nulls":6},-375912,-0.36710560639769546]
[""]
["AB20","Andere Gebühren / Einkommen",{"$nulls":6},0,0]
[""]
["AB17","Zinsaufwand/-ertrag",{"$nulls":6},-62099,-0.060644222721515914]
[""]
["AB18","Neutrales Ergebnis",{"$nulls":6},45594,0.04452588110540905]
[""]
["AB19","Gewinn vor Steuern",{"$nulls":6},-392417,-0.38322394801380233]

{"sheet":"Aktiva","index":9,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,"Aktiva"]
[""]
[null,"Anlagevermögen"]
[null,null,null,"Bruttowert","Abschreib.","Gesamt"]
["AC1","Gewerbliche Liegenschaften",null,0,0,0]
["AC2","Sonstige immaterielle Anlagevermögen",null,24423,0,24423]
["AC3","Grundstück, Gebäude und andere Anlagen",null,251523,0,251523]
["AC4","Ausrüstung und Einrichtung",null,-39286,0,-39286]
["AC5","Einbauten und Möbel",null,613904,0,613904]
["AC6","Computer Hardware",null,0,0,0]
["AC7","VFW/Betriebs-Kfz",null,2336011,0,2336011]
["AC8","Sonstige Anlagevermögen",null,0,0,0]
["AC9","Anlagevermögen",null,3186575,0,3186575]
[""]
["AC10","Finanzanlagen",null,0,0,0]
["AC11","Feste Kapitalanlagen",null,0,0,0]
["AC12","Gesamt Anlagevermögen",null,3186575,0,3186575]
[""]
[null,"Umlaufvermögen"]
[""]
[null,"Bestände und unfertige Erzeugnisse"]
[null,null,"EH","Bruttowert","Abschreib.","Gesamt"]
["AC13","Bestand NW",0,2570299,0,2570299]
["AC14","Bestand Vorführwagen",0,4056673,0,4056673]
["AC15","Gesamt Bestand",0,6626972,0,6626972]
[""]
["AC16","Gesamt GW Bestand",0,16777509,0,16777509]
[""]
["AC17","Bestand Fahrzeuge anderer Marken",0,0,0,0]
["AC18","Gesamt Teilebestand",null,786335,0,786335]
[""]
["AC19","Gesamt sonstiger Bestand (exkl. Fahrzeugaktivitäten)",null,16744,0,16744]
["AC20","Gesamt unfertige Erzeugnisse",null,0,0,0]
["AC21","Gesamt Bestand und unfertige Erzeugnisse",null,24207560,0,24207560]
[""]
[""]
[null,"Forderungen"]
[null,null,null,"Bruttowert","Abschreib.","Gesamt"]
["AC22","Forderungen NW",null,2264206,0,2264206]
["AC23","Forderungen GW",null,0,0,0]
["AC24","Forderungen Teile & Kundendienst",null,0,0,0]
["AC25","Forderungen AP/AC/DS/OV",null,288914,0,288914]
["AC26","Forderungen MwSt /Steuern",null,65614538,0,65614538]
["AC27","Sonstige Forderungen",null,420419,0,420419]
["AC28","Gesamt Forderungen",null,68588077,0,68588077]
[""]
["AC29","Forderungen aus laufenden Rechnungen",null,0,0,0]
["AC30","Vorauszahlungen",null,0,0,0]
["AC31","Sonstiges Umlaufvermögen",null,-4677,0,-4677]
["AC32","Gesamt sonstiges Umlaufvermögen",null,-4677,0,-4677]
[""]
[null,"Liquidität"]
[{"$nulls":5},"Wert"]
["AC33","Anlagevermögen",null,null,null,84791]
["AC34","Anlagevermögen der Gruppe",null,null,null,0]
["AC35","Bank",null,null,null,-440487]
["AC36","Kasse",null,null,null,9830]
["AC37","Gesamt Liquidität",null,null,null,-345866]
[""]
["AC38","Gesamt Umlaufvermögen",null,null,null,92445094]
[""]
["AC39","Gesamtaktiva",null,null,null,95631669]

{"sheet":"Passiva","index":10,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Passiva"]
[""]
[null,"Eigenkapital"]
[null,null,"Wert"]
["AC40","Gezeichnetes Kapital/Eigenkapital",26000]
["AC41","Sonderposten mit Rücklageanteil",125107]
["AC42","Kapitalrücklagen",0]
["AC43","Gewinn- bzw. Verlustvortrag",13416703]
["AC44","Ergebnis lfd. Jahr",0]
["AC45","Gesamt Eigenkapital",13567810]
[""]
[""]
[null,"Langfristige Verbindlichkeiten (> 1 Jahr)"]
[null,null,"Wert"]
["AC46","Verbindlichk. v. Gruppen- & Beteiligungsunternehmen (geblockt)",1131018]
["AC47","Langfristige Darlehen",0]
["AC48","Hypotheken",0]
["AC49","Sonstige langfr. Darlehen",0]
["AC50","Gesamt Langfristige Verbindl.",1131018]
[""]
[""]
[""]
[null,"Kurzfristige Verbindlichkeiten  (< 1 Jahr)"]
[null,null,"Wert"]
["AC51","Verbindlichk. v. Gruppen- & Beteiligungsunternehmen (ungeblockt)",0]
["AC52","Kurzfristige Bankschulden",0]
["AC53","kurzfr. Bankverbindlichkeiten",4655113]
["AC54","Kreditoren",5804223]
["AC55","Verbindlichkeiten Neuwagen",5286339]
["AC56","Verbindlichkeiten Vorführwagen",0]
["AC57","Verbindlichkeiten GW",0]
["AC58","Verbindlichkeiten Ersatzteile",0]
["AC59","Mehrwertsteuer",64865685]
["AC60","Öffentliche Verwaltung",0]
["AC61","Kundenanzahlungen",-31817]
["AC62","Angestellte (noch zu zahlende Gehälter)",0]
["AC63","Sonstige kurzf. Verbindlichkeiten",745714]
["AC64","Gesamt Kurzfristige Verbindl.",81325257]
[""]
["AC65","Gesamtpassiva",96024085]