{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Finanzplanung 2020"],"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 2020","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,"01",1,1,"GuV","1. Umsatzerlöse","a) Neuwagen",null,null,null,2020,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000,-9700000]
[1,"01",1,2,"GuV","1. Umsatzerlöse","b) Gebrauchtwagen",null,null,null,2020,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000,-4350000]
[1,"01",1,6,"GuV","1. Umsatzerlöse","c) Teile & Zubehör",null,null,null,2020,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000,-845000]
[1,"01",1,3,"GuV","1. Umsatzerlöse","d) Service",null,null,null,2020,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000,-600000]
[1,"01",1,7,"GuV","1. Umsatzerlöse","e) Mietwagen",null,null,null,2020,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000,-395000]
[1,"01",1,8,"GuV","1. Umsatzerlöse","f) Tankstelle",null,null,null,2020,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000,-355000]
[1,"01",1,9,"GuV","1. Umsatzerlöse","g) Waschstrasse",null,null,null,2020,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000,-41000]
[1,"01",1,"1.1","GuV","1. Umsatzerlöse","h) Logistik",null,null,null,2020,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000,-215000]
[1,"01",1,0,"GuV","2. Erhöhung oder Verminderung des Bestands an fertigen und unfertigen Erzeugnissen",{"$nulls":4},2020]
[1,"01",1,0,"GuV","4. Sonstige betriebliche Erträge",{"$nulls":4},2020,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000,-35000]
[1,"01",1,1,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","aa) Neuwagen",null,null,2020,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000,9050000]
[1,"01",1,2,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ab) Gebrauchtwagen",null,null,2020,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000,4025000]
[1,"01",1,6,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ac) Teile & Zubehör",null,null,2020,610000,610000,610000,610000,610000,610000,610000,610000,610000,610000,610000,610000]
[1,"01",1,3,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ad) Service",null,null,2020,32500,32500,32500,32500,32500,32500,32500,32500,32500,32500,32500,32500]
[1,"01",1,7,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ae) Mietwagen",null,null,2020,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750]
[1,"01",1,8,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","af) Tankstelle",null,null,2020,330000,330000,330000,330000,330000,330000,330000,330000,330000,330000,330000,330000]
[1,"01",1,9,"GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ag) Waschstrasse",null,null,2020,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100,2100]
[1,"01",1,"1.1","GuV","5. Materialaufwand","a) Aufwendungen für Roh-,Hilfs- und Betriebsstoffe und für bezogene Waren","ah) Logistik",null,null,2020,5500,5500,5500,5500,5500,5500,5500,5500,5500,5500,5500,5500]
[1,"01",1,0,"GuV","6. Personalaufwand",{"$nulls":4},2020,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000]
[1,"01",1,0,"GuV","7. Abschreibungen",{"$nulls":4},2020,420000,420000,420000,420000,420000,420000,420000,420000,420000,420000,420000,420000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","a) Raumkosten",null,null,null,2020,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","b) Versicherungen / Beiträge",null,null,null,2020,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","c) KFZ-Kosten",null,null,null,2020,160000,160000,160000,160000,160000,160000,160000,160000,160000,160000,160000,160000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","d) Werbekosten",null,null,null,2020,57500,57500,57500,57500,57500,57500,57500,57500,57500,57500,57500,57500]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","e) Kosten der Warenabgabe",null,null,null,2020,127500,127500,127500,127500,127500,127500,127500,127500,127500,127500,127500,127500]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","f) Reparaturen/Instandhaltungen",null,null,null,2020,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","g) Sonstige",null,null,null,2020,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[1,"01",1,0,"GuV","8. Sonstige betriebliche Aufwendungen","h) Mieten bew. WG",null,null,null,2020,62500,62500,62500,62500,62500,62500,62500,62500,62500,62500,62500,62500]
[1,"01",1,0,"GuV","9. Zinsen und ähnliche Erträge",{"$nulls":4},2020,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000,-6000]
[1,"01",1,0,"GuV","10. Zinsen und ähnliche Aufwendungen",{"$nulls":4},2020,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000]
[1,"01",1,0,"GuV","12. Außerordentliche Erträge",{"$nulls":4},2020,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000,-80000]
[1,"01",1,0,"GuV","13. Außerordentliche Aufwendungen",{"$nulls":4},2020,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000]
[1,"01",1,0,"GuV","14. Steuern vom Einkommen und vom Ertrag",{"$nulls":4},2020,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000,81000]
[1,"01",1,0,"GuV","15. sonstige Steuern",{"$nulls":4},2020,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]