{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Eingabe","Berechnungen","Grafik"],"not_rendered":{"charts":2,"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":"Eingabe","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ermittlung der optimalen Bestellmenge"]
[]
[null,"Bei einem geggebenen Periodenbedarf kann die optimale Bestellmenge, unter Berücksichtigung von Bestellkosten je "]
[null,"Bestellvorgang und Lagerkosten für die Lagerbereitschaft je Stück, ermittelt werden"]
[]
[null,"Die Anzahl der Bestellvorgänge ergibt sich aus der Division des Periodenbedarfs mit den alternativen Bestellmengen."]
[null,"Die alternativen Bestellmengen werden zur gleichmäßigen Skalierung der X-Achse jeweils um die sechzehntenTeil erhöht."]
[null,"Die Anzahl der Bestellvorgänge bezieht sich jeweils auf ein Perode. Bestellvorgänge in Dezimalzahlen bedeutetn daher, dass Teile"]
[null,"des Lagerbestandes den Bedarf in anderen Perioden decken."]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D29","v":1500},0,{"$f":"D29","v":1500}]
[null,null,null,null,null,null,{"$f":"D29","v":1500},{"$f":"D26","v":708.32999999999993},{"$f":"D26","v":708.32999999999993}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Berechnungen!E2","v":"minimale Gesamtkosten"},null,{"$f":"Berechnungen!G2","v":708.32999999999993}]
[]
[]
[null,{"$f":"Berechnungen!E3","v":"Optimale Bestellmenge"},null,{"$f":"Berechnungen!G3","v":1500}]

{"sheet":"Berechnungen","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Periodenbedarf/Höchstbestellmenge",null,4000,"minimale Gesamtkosten",null,{"$f":"MIN(G9:G24)","v":708.32999999999993}]
[null,"Bestellkosten je Vorgang",null,125,"Optimale Bestellmenge",null,{"$f":"VLOOKUP(G2,G9:H24,2,FALSE)","v":1500}]
[null,"Lagerkosten je Stück",null,0.25,"Anzahl der Bestellungen",null,{"$f":"VLOOKUP(G3,B9:G24,2,FALSE)","v":2.6666666666666665}]
[]
[null,null,"Anzahl der","Lagerkosten",null,null,"Gesamt-"]
[null,"Bestellmenge","Bestellungen","je Stück","Bestellkosten","Lagerkosten","kosten"]
[null,0]
[null,{"$f":"B24/16","v":250},{"$f":"$D$2/B9","v":16},{"$f":"$D$4","v":0.25},{"$f":"ROUND(C9*$D$3,2)","v":2000},{"$f":"ROUND(B9*D9,2)","v":62.5},{"$f":"E9+F9","v":2062.5},{"$f":"H24/16","v":250}]
[null,{"$f":"B9+B$9","v":500},8,0.25,{"$f":"ROUND(C10*$D$3,2)","v":1000},{"$f":"ROUND(B10*D10,2)","v":125},1125,{"$f":"H9+H$9","v":500}]
[null,{"$f":"B10+B$9","v":750},5.333333333333333,0.25,666.67,187.5,854.17,{"$f":"H10+H$9","v":750}]
[null,1000,4,0.25,500,250,750,1000]
[null,1250,3.2,0.25,400,312.5,712.5,1250]
[null,1500,2.6666666666666665,0.25,333.33,375,708.32999999999993,1500]
[null,1750,2.2857142857142856,0.25,285.70999999999998,437.5,723.21,1750]
[null,2000,2,0.25,250,500,750,2000]
[null,2250,1.7777777777777777,0.25,222.22,562.5,784.72,2250]
[null,2500,1.6,0.25,200,625,825,2500]
[null,2750,1.4545454545454546,0.25,181.82,687.5,869.31999999999994,2750]
[null,3000,1.3333333333333333,0.25,166.67,750,916.67,3000]
[null,3250,1.2307692307692308,0.25,153.85,812.5,966.35,3250]
[null,3500,1.1428571428571428,0.25,142.86000000000001,875,1017.86,3500]
[null,3750,1.0666666666666667,0.25,133.33000000000001,937.5,1070.83,3750]
[null,{"$f":"D2","v":4000},1,0.25,125,1000,1125,{"$f":"D2","v":4000}]

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