{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tabelle1","Tabelle2","Aufgabenstellung","Kalkulation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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"}

{"sheet":"Tabelle1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Aufgabenstellung","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Kalkulation","index":3,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[7,1,7,2],[8,1,8,2],[13,1,13,2],[14,1,14,2],[16,1,16,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[15,1,15,2],[1,0,2,0],[1,1,2,1],[1,3,2,3],[1,4,2,4],[22,1,22,2],[17,1,17,2],[18,1,18,2],[21,1,21,2],[5,0,5,2],[6,1,6,2]]}
[]
["Preis",25000,null,"Menge",20]
[]
[]
[]
["Monatskalkualation für die Herstellung\n von Motorbooten",null,null,null,"Menge\n (x)","Variable\nKosten (Kv)","Gesamt-\nkosten (K)","Gesamt-\nerlöse (E)","Gewinn (G)"]
["Ausbringungsmenge \n= Absatzmenge",null,null,null,0,{"$f":"$B$15*E7","v":0},{"$f":"F7+$B$11","v":80800},{"$f":"$B$2*E7","v":0},{"$f":"H7-G7","v":-80800}]
["Miete",8000,null,null,{"$f":"IF(OR(E7>=$E$2, E7=\"\"),\"\",E7+1)","v":1},{"$f":"IF(E8=\"\",\"\",$B$15*E8)","v":19500},{"$f":"IF(E8=\"\",\"\",F8+$B$11)","v":100300},{"$f":"IF(E8=\"\",\"\",$B$2*E8)","v":25000},{"$f":"IF(E8=\"\",\"\",H8-G8)","v":-75300}]
["Personalkosten",22800,null,null,2,39000,119800,50000,-69800]
["Bankverbindlichkeiten",50000,null,null,3,58500,139300,75000,-64300]
["Fixkosten",{"$f":"SUM(B8:C10)","v":80800},null,null,4,78000,158800,100000,-58800]
["Materialkosten/Stck.",8000,null,null,5,97500,178300,125000,-53300]
["Fertigungskosten/Stck.",10000,null,null,6,117000,197800,150000,-47800]
["Vertriebskosten/Stck.",1500,null,null,7,136500,217300,175000,-42300]
["Variable Stückkosten",{"$f":"SUM(B12:C14)","v":19500},null,null,8,156000,236800,200000,-36800]
[null,null,null,null,9,156000,236800,225000,-11800]
["Gewinn",{"$f":"B19-B18","v":29200},null,null,10,{"$f":"IF(E17=\"\",\"\",$B$15*E17)","v":195000},275800,250000,-25800]
["dabei Kosten",{"$f":"B15*E2+B11","v":470800},null,null,11,{"$f":"IF(E18=\"\",\"\",$B$15*E18)","v":214500},295300,275000,-20300]
["dabei Umsatz ",{"$f":"E2*B2","v":500000},null,null,{"$f":"IF(OR(E18>=$E$2, E18=\"\"),\"\",E18+1)","v":12},{"$f":"IF(E19=\"\",\"\",$B$15*E19)","v":234000},{"$f":"IF(E19=\"\",\"\",F19+$B$11)","v":314800},{"$f":"IF(E19=\"\",\"\",$B$2*E19)","v":300000},{"$f":"IF(E19=\"\",\"\",H19-G19)","v":-14800}]
[null,null,null,null,13,253500,334300,325000,-9300]
[null,null,null,null,14,273000,353800,350000,-3800]
[null,null,null,null,15,292500,373300,375000,1700]
[null,null,null,null,16,312000,392800,400000,7200]
[null,null,null,null,17,331500,412300,425000,12700]
[null,null,null,null,18,351000,431800,450000,18200]
[null,null,null,null,19,370500,451300,475000,23700]
[null,null,null,null,20,390000,470800,500000,29200]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,{"$f":"IF(OR(E41>=$E$2, E41=\"\"),\"\",E41+1)","v":""},"",{"$f":"IF(E42=\"\",\"\",F42+$B$11)","v":""},{"$f":"IF(E42=\"\",\"\",$B$2*E42)","v":""},{"$f":"IF(E42=\"\",\"\",H42-G42)","v":""}]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"",{"$f":"IF(E83=\"\",\"\",$B$15*E83)","v":""},"","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]