{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Finanzplanung 2018"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Finanzplanung 2018","index":0,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Rechtseinheit","Betrieb","Marke","Kostenstelle","Ebene21","Ebene22","Ebene23","Ebene24","Ebene25","Ebene26","Bookkeep Date","GuV1","GuV2","GuV3","GuV4","GuV5","GuV6","GuV7","GuV8","GuV9","GuV10","GuV11","GuV12"]
[1,1,1,1,"GuV","1. Umsatzerlöse","a) Neuwagen",null,null,null,2018,-10700000,-10700000,-10700000,-10700000,-10700000,-10700000,-10700000,-10700000,-10700000,-10700000,-10700000,-10700000]
[1,1,1,2,"GuV","1. Umsatzerlöse","b) Gebrauchtwagen",null,null,null,2018,-3650000,-3650000,-3650000,-3650000,-3650000,-3650000,-3650000,-3650000,-3650000,-3650000,-3650000,-3650000]
[1,1,1,6,"GuV","1. Umsatzerlöse","c) Teile & Zubehör",null,null,null,2018,-680000,-680000,-680000,-680000,-680000,-680000,-680000,-680000,-680000,-680000,-680000,-680000]
[1,1,1,3,"GuV","1. Umsatzerlöse","d) Service",null,null,null,2018,-520000,-520000,-520000,-520000,-520000,-520000,-520000,-520000,-520000,-520000,-520000,-520000]
[1,1,1,7,"GuV","1. Umsatzerlöse","e) Mietwagen",null,null,null,2018,-270000,-270000,-270000,-270000,-270000,-270000,-270000,-270000,-270000,-270000,-270000,-270000]
[1,1,1,8,"GuV","1. Umsatzerlöse","f) Tankstelle",null,null,null,2018,-370000,-370000,-370000,-370000,-370000,-370000,-370000,-370000,-370000,-370000,-370000,-370000]
[1,1,1,9,"GuV","1. Umsatzerlöse","g) Waschstrasse",null,null,null,2018,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000]
[1,1,1,"1.1","GuV","1. Umsatzerlöse","h) Logistik",null,null,null,2018,-160000,-160000,-160000,-160000,-160000,-160000,-160000,-160000,-160000,-160000,-160000,-160000]
[1,1,1,0,"GuV","2. Erhöhung oder Verminderung des Bestands an fertigen und unfertigen Erzeugnissen",{"$nulls":4},2018,0,0,0,0,0,0,0,0,0,0,0,0]
[1,1,1,0,"GuV","4. Sonstige betriebliche Erträge",{"$nulls":4},2018,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000,-42000]
[1,1,1,1,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","aa) Neuwagen",null,null,2018,9910000,9910000,9910000,9910000,9910000,9910000,9910000,9910000,9910000,9910000,9910000,9910000]
[1,1,1,2,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ab) Gebrauchtwagen",null,null,2018,3410000,3410000,3410000,3410000,3410000,3410000,3410000,3410000,3410000,3410000,3410000,3410000]
[1,1,1,6,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ac) Teile & Zubehör",null,null,2018,480000,480000,480000,480000,480000,480000,480000,480000,480000,480000,480000,480000]
[1,1,1,3,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ad) Service",null,null,2018,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500]
[1,1,1,7,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ae) Mietwagen",null,null,2018,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000]
[1,1,1,8,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","af) Tankstelle",null,null,2018,410000,410000,410000,410000,410000,410000,410000,410000,410000,410000,410000,410000]
[1,1,1,9,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ag) Waschstrasse",null,null,2018,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
[1,1,1,"1.1","GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ah) Logistik",null,null,2018,700,700,700,700,700,700,700,700,700,700,700,700]
[1,1,1,0,"GuV","6. Personalaufwand",{"$nulls":4},2018,900000,900000,900000,900000,900000,900000,900000,900000,900000,900000,900000,900000]
[1,1,1,0,"GuV","7. Abschreibungen",{"$nulls":4},2018,340000,340000,340000,340000,340000,340000,340000,340000,340000,340000,340000,340000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","a) Raumkosten",null,null,null,2018,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000,120000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","b) Versicherungen / Beiträge",null,null,null,2018,63000,63000,63000,63000,63000,63000,63000,63000,63000,63000,63000,63000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","c) KFZ-Kosten",null,null,null,2018,117000,117000,117000,117000,117000,117000,117000,117000,117000,117000,117000,117000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","d) Werbekosten",null,null,null,2018,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","e) Kosten der Warenabgabe",null,null,null,2018,125000,125000,125000,125000,125000,125000,125000,125000,125000,125000,125000,125000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","f) Reparaturen/Instandhaltungen",null,null,null,2018,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","g) Sonstige",null,null,null,2018,150000,150000,150000,150000,150000,150000,150000,150000,150000,150000,150000,150000]
[1,1,1,0,"GuV","8. Sonstige betriebliche Aufwendungen","h) Mieten bew. WG",null,null,null,2018,500,500,500,500,500,500,500,500,500,500,500,500]
[1,1,1,0,"GuV","9. Zinsen und ähnliche Erträge",{"$nulls":4},2018,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500,-12500]
[1,1,1,0,"GuV","10. Zinsen und ähnliche Aufwendungen",{"$nulls":4},2018,55000,55000,55000,55000,55000,55000,55000,55000,55000,55000,55000,55000]
[1,1,1,0,"GuV","12. Außerordentliche Erträge",{"$nulls":4},2018,-40000,-40000,-40000,-40000,-40000,-40000,-40000,-40000,-40000,-40000,-40000,-40000]
[1,1,1,0,"GuV","13. Außerordentliche Aufwendungen",{"$nulls":4},2018,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000]
[1,1,1,0,"GuV","14. Steuern vom Einkommen und vom Ertrag",{"$nulls":4},2018,80528,80528,80528,80528,80528,80528,80528,80528,80528,80528,80528,80528]
[1,1,1,0,"GuV","15. sonstige Steuern",{"$nulls":4},2018,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]