{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":1,"images":2,"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":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,1,26,10],[3,7,3,9],[2,1,2,10],[5,1,6,2],[8,5,9,5],[6,5,7,5],[9,1,9,2]]}
[]
[]
[null,"Kostenvergleich Reisender - Handelsvertreter"]
[null,"Umsatzmaximum",null,null,40000,null,null,"Reisender",null,null,"Handelsvertreter"]
[null,"Monatsgehalt des Reisenden",null,null,3000,null,"Umsatz","Fixum","Provision","Vergütung","Umsatzprovision"]
[null,"Umsatzprovision in %",null,"Reisender ",5,null,0,{"$f":"$E$5","v":3000},{"$f":"G6*$E$6/100","v":0},{"$f":"H6+I6","v":3000},{"$f":"G6*$E$7/100","v":0}]
[null,null,null,"Handelsvertreter",15,{"$f":"IF(B10>E4,\"Umsatzziel ist unrealistisch\",\"Umsatzziel ist realistisch\")","v":"Umsatzziel ist realistisch"},{"$f":"G26/20","v":2000},3000,{"$f":"G7*$E$6/100","v":100},{"$f":"H7+I7","v":3100},{"$f":"G7*$E$7/100","v":300}]
[null,"kritische Menge (break-even-point)",null,null,{"$f":"E5/((E7-E6)/100)","v":30000},null,{"$f":"$G$7+G7","v":4000},3000,200,3200,600]
[null,"Umsatzziel",null,"Reisender ","Handelsvertreter",{"$f":"IF(D10<E10,\"Reisender ist günstiger\",\"Handelsvertreter ist günstiger\")","v":"Handelsvertreter ist günstiger"},6000,3000,300,3300,900]
[null,18000,null,{"$f":"E5+(B10*E6/100)","v":3900},{"$f":"B10*E7/100","v":2700},null,8000,3000,400,3400,1200]
[null,null,null,null,null,null,10000,3000,500,3500,1500]
[null,null,null,null,null,null,12000,3000,600,3600,1800]
[null,null,null,null,null,null,14000,3000,700,3700,2100]
[null,null,null,null,null,null,16000,3000,800,3800,2400]
[null,null,null,null,null,null,18000,3000,900,3900,2700]
[null,null,null,null,null,null,20000,3000,1000,4000,3000]
[null,null,null,null,null,null,22000,3000,1100,4100,3300]
[null,null,null,null,null,null,24000,3000,1200,4200,3600]
[null,null,null,null,null,null,26000,3000,1300,4300,3900]
[null,null,null,null,null,null,28000,3000,1400,4400,4200]
[null,null,null,null,null,null,30000,3000,1500,4500,4500]
[null,null,null,null,null,null,32000,3000,1600,4600,4800]
[null,null,null,null,null,null,34000,3000,1700,4700,5100]
[null,null,null,null,null,null,36000,3000,1800,4800,5400]
[null,null,null,null,null,null,38000,3000,1900,4900,5700]
[null,null,null,null,null,null,{"$f":"E4","v":40000},3000,2000,5000,6000]
[]
[]
[null,"Arbeitsauftrag:"]
[null,"Ein Reisender erhält von seinem Arbeitgeber ein Monatsgehalt von 2.150,00 €. Zusätzlich erhält er eine Provision von 5% auf den Umsatz."]
[null,"Einem Hanelsvertreter müsste das Unternehmen eine Umsatzprovision von 20% zahlen."]
[null,"Ermitteln Sie mit dieser Anwendung die günstigste Alternative bei einem Umsatzziel von 15.000,00 €. "]
[null,"Die Kapazitäsgrenze (Umsatzmaximum) liegt bei 30.000,00 €. Bei welchem Umsatz liegt der Break-even-point?"]

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