{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Eingabe","Berechnungen","Grafiken"],"not_rendered":{"charts":4,"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":"Eingabe","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,10],[21,1,22,2],[21,3,22,3],[23,1,24,2],[19,1,20,2],[19,3,20,3],[23,3,24,3]]}
[]
[null,"Ermittlung der optimalen Losgröße"]
[]
[null,"Bei einem prognostizierten Auftragsvolumen für eine Periode kann die optimale Losgröße, unter Berücksichtigung von "]
[null,"Lagerkosten und Rüstkosten tabellarisch ermittelt werden."]
[]
[]
[null,null,null,null,null,{"$f":"D22","v":8},0,{"$f":"F8","v":8}]
[null,null,null,null,null,{"$f":"D22","v":8},{"$f":"D20","v":62625},{"$f":"G9","v":62625}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Gesamtkostenminimum",null,{"$f":"MIN(Berechnungen!H9:H28)","v":62625}]
[]
[null,"Anzahl der Lose",null,{"$f":"VLOOKUP(D20,Berechnungen!H9:I28,2,FALSE)","v":8}]
[]
[null,"Stückzahl je Los",null,{"$f":"VLOOKUP(D22,Berechnungen!B9:C28,2)","v":12500}]

{"sheet":"Berechnungen","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,5,7,5],[5,6,7,6],[5,8,7,8],[5,1,7,1],[5,2,7,2],[5,3,7,3],[5,4,7,4]]}
[]
[null,"Auftragsvolumen in Stück",null,null,100000,"Rüstkosten je Umrüstung",null,null,4000]
[null,"Materialstückkosten",null,null,20,"Lagerkostensatz in %",null,null,8]
[null,"Fertigungsstückkosten",null,null,15,"Lagerzinssatz in %",null,null,6]
[]
[null,"Anzahl der Lose","Fertigungs- größe in Stück","Herstellwert","durchschnitt- licher Lager-bestand in €","Lagerkosten","Rüstkosten","Gesamt-","Anzahl der Lose"]
[]
[null,null,null,null,null,null,null,"kosten"]
[null,1,{"$f":"ROUNDUP($E$2/B9,0)","v":100000},{"$f":"($E$3+$E$4)*C9","v":3500000},{"$f":"D9/2","v":1750000},{"$f":"(E9*($I$3+$I$4))/100","v":245000},{"$f":"$I$2*B9","v":4000},{"$f":"F9+G9","v":249000},1]
[null,2,{"$f":"ROUNDUP($E$2/B10,0)","v":50000},{"$f":"($E$3+$E$4)*C10","v":1750000},{"$f":"D10/2","v":875000},{"$f":"(E10*($I$3+$I$4))/100","v":122500},{"$f":"$I$2*B10","v":8000},{"$f":"F10+G10","v":130500},2]
[null,3,33334,1166690,583345,81668.3,12000,{"$f":"F11+G11","v":93668.3},3]
[null,4,25000,875000,437500,61250,16000,77250,4]
[null,5,20000,700000,350000,49000,20000,69000,5]
[null,6,16667,583345,291672.5,40834.15,24000,64834.15,6]
[null,7,14286,500010,250005,35000.699999999997,28000,63000.7,7]
[null,8,12500,437500,218750,30625,32000,62625,8]
[null,9,11112,388920,194460,27224.400000000001,36000,63224.4,9]
[null,10,10000,350000,175000,24500,40000,64500,10]
[null,11,9091,318185,159092.5,22272.95,44000,66272.95,11]
[null,12,8334,291690,145845,20418.3,48000,68418.3,12]
[null,13,7693,269255,134627.5,18847.849999999999,52000,70847.850000000006,13]
[null,14,7143,250005,125002.5,17500.349999999999,56000,73500.350000000006,14]
[null,15,6667,233345,116672.5,16334.15,60000,76334.149999999994,15]
[null,16,6250,218750,109375,15312.5,64000,79312.5,16]
[null,17,5883,205905,102952.5,14413.35,68000,82413.350000000006,17]
[null,18,5556,194460,97230,13612.2,72000,85612.2,18]
[null,19,5264,184240,92120,12896.8,76000,88896.8,19]
[null,20,5000,175000,87500,12250,80000,92250,20]
[]
[]
[]
[null,"Die Fertigungsgröße in Stück ergibt sich aus der Division des Auftgragsvolumens mit den alternativen Losen. Der Herstellwert"]
[null," je Los ergibt sich als Produkt der Material- und Fertigungskosten und Fertigungsgröße. An Lagerkosten fallen ein "]
[null,"prozentualer Anteil am wertmäßigen Lagerbestand und ein Zins für das gebundene Kapital an. Rüstkosten fallen für jede "]
[null,"Umrüstung an. Die optimale Losgröße ergibt sich aus dem Minimum von Lagerkosten und Rüstkosten zusammen."]

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