{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":1,"images":3,"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[]
[null,"Eigenfertigung oder Fremdbezug? (make or buy?)"]
[]
[null,"benötigte Menge in Stück",9600]
[null,"Fremdbezug"]
[null,"   Bezugspreis je Stück",59.9]
[null,"Eigenfertigung",null,"kritische Menge",{"$f":"Tabelle2!I3","v":12453.300124533002}]
[null,"   Kapazitätsgrenze",20000,"Kosten bei Eigenfertigung",{"$f":"Tabelle2!I4","v":689600}]
[null,"   variable Stückkosten",19.75,"Kosten bei Fremdbezug",{"$f":"Tabelle2!I5","v":575040}]
[null,"   fixe Kosten",500000,"Kostenvorteil bei Eigenfertigung",{"$f":"Tabelle2!I6","v":-114560}]
[null,"Empfehlung",{"$f":"IF(E10>0,\"Eigenfertigung\",\"Fremdbezug\")","v":"Fremdbezug"},"Ersparnis",{"$f":"IF(E9<E8,E8-E9,E9-E8)","v":114560}]
[]
[null,{"$f":"E7","v":12453.300124533002},0,{"$f":"B13","v":12453.300124533002}]
[null,{"$f":"B13","v":12453.300124533002},{"$f":"VLOOKUP(E7,Tabelle2!B15:E35,4)","v":737000},{"$f":"C14","v":737000}]

{"sheet":"Tabelle2","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2],[2,5,2,7],[3,5,3,7],[4,5,4,7],[5,5,5,7],[5,1,5,2],[11,6,12,6],[11,7,12,7],[10,6,10,7],[6,1,6,2],[7,1,7,2],[8,1,8,2],[10,8,12,8],[11,3,12,3],[11,4,12,4],[11,5,12,5],[10,2,10,5]]}
[]
[]
[null,"benötigte Menge in Stück",null,{"$f":"Tabelle1!C4","v":9600},null,"kritische Menge",null,null,{"$f":"D9/(D5-D8)","v":12453.300124533002}]
[null,"Fremdbezug",null,null,null,"Kosten der Eigenfertigung",null,null,{"$f":"D9+(D3*D8)","v":689600}]
[null,"   Bezugspreis je Stück",null,{"$f":"Tabelle1!C6","v":59.9},null,"Kosten bei Fremdbezug",null,null,{"$f":"D3*D5","v":575040}]
[null,"Eigenfertigung",null,null,null,"Kostenvorteil bei Eigenfertigung ",null,null,{"$f":"I5-I4","v":-114560}]
[null,"   Kapazitätsgrenze",null,{"$f":"Tabelle1!C8","v":20000}]
[null,"   Variable Stückkosten",null,{"$f":"Tabelle1!C9","v":19.75}]
[null,"   Fixkosten",null,{"$f":"Tabelle1!C10","v":500000}]
[]
[null,null,"Eigenfertigung (make)",null,null,null,"Fremdbezug (buy)",null,"Stückkosten- vorteil bei Eigenfertigung"]
[null,null,null,"variable Kosten","Gesamt- kosten","Stückkosten","Bezugspreis je Stück","Gesamtpreis"]
[null,"Menge","Fixkosten"]
[]
[null,0,{"$f":"$D$9","v":500000},{"$f":"$D$8*B15","v":0},{"$f":"C15+D15","v":500000},null,{"$f":"$D$5","v":59.9},{"$f":"$D$5*B15","v":0}]
[null,{"$f":"$B$35/20","v":1000},{"$f":"$D$9","v":500000},{"$f":"$D$8*B16","v":19750},{"$f":"C16+D16","v":519750},{"$f":"E16/B16","v":519.75},{"$f":"$D$5","v":59.9},{"$f":"$D$5*B16","v":59900},{"$f":"G16-F16","v":-459.85}]
[null,{"$f":"B16+$B$16","v":2000},500000,39500,539500,269.75,59.9,119800,-209.85]
[null,3000,500000,59250,559250,186.41666666666666,59.9,179700,-126.51666666666665]
[null,4000,500000,79000,579000,144.75,59.9,239600,-84.85]
[null,5000,500000,98750,598750,119.75,59.9,299500,-59.85]
[null,6000,500000,118500,618500,103.08333333333333,59.9,359400,-43.18333333333333]
[null,7000,500000,138250,638250,91.178571428571431,59.9,419300,-31.278571428571432]
[null,8000,500000,158000,658000,82.25,59.9,479200,-22.35]
[null,9000,500000,177750,677750,75.305555555555557,59.9,539100,-15.405555555555559]
[null,10000,500000,197500,697500,69.75,59.9,599000,-9.8500000000000014]
[null,11000,500000,217250,717250,65.204545454545453,59.9,658900,-5.3045454545454547]
[null,12000,500000,237000,737000,61.416666666666664,59.9,718800,-1.5166666666666657]
[null,13000,500000,256750,756750,58.21153846153846,59.9,778700,1.6884615384615387]
[null,14000,500000,276500,776500,55.464285714285715,59.9,838600,4.4357142857142833]
[null,15000,500000,296250,796250,53.083333333333336,59.9,898500,6.8166666666666629]
[null,16000,500000,316000,816000,51,59.9,958400,8.8999999999999986]
[null,17000,500000,335750,835750,49.161764705882355,59.9,1018300,10.738235294117644]
[null,18000,500000,355500,855500,47.527777777777779,59.9,1078200,12.37222222222222]
[null,19000,500000,375250,875250,46.065789473684212,59.9,1138100,13.834210526315786]
[null,{"$f":"$D$7","v":20000},500000,395000,895000,44.75,59.9,1198000,15.149999999999999]

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