{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Logistik-Kostenanalyse"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Logistik-Kostenanalyse","index":0,"n_rows":70,"n_cols":33,"rows_kept":70,"cut":false,"hidden":false,"merged":[[59,7,59,15],[28,8,28,9],[40,8,40,9],[1,9,1,10],[2,9,2,10],[5,4,5,16],[17,8,17,9],[46,8,46,9],[7,7,7,15],[13,7,13,15]]}
[]
[null,null,null,null,"Firma:",null,null,null,null,"Müller OHG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(J2=\"\",0,1)","v":1},null,null,null,null,{"$f":"+DAY(J4)","v":31},{"$f":"+MONTH(J4)","v":12},{"$f":"+YEAR(J4)","v":2016}]
[null,null,null,null,"Ort:",null,null,null,null,"Müllerdorf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(J3=\"\",0,1)","v":1}]
[null,null,null,null,"Datum der Analyse:",null,null,null,null,"2016-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(ISNUMBER(J4),1,0)","v":1},null,{"$f":"IF(ISERROR(SUM(Z2:Z4)),0,SUM(Z2:Z4))","v":3},3]
[]
[null,null,null,null,{"$f":"+IF(AB4<>AC4,\"Untersuchung der Logistikprozesse\",\"Analyse der Logistikprozesse der \"&J2&\" in \"&J3&\" zum \"&AE2&\".\"&AF2&\".\"&AG2&\" \")","v":"Analyse der Logistikprozesse der Müller OHG in Müllerdorf zum 31.12.2016 "}]
[]
[null,null,null,null,null,null,null,"Allgemeine Eingaben"]
[]
[null,null,null,null,null,null,null,null,"Umsatz:",6275837,null,null,null,"SOLL-Anwesenheitsstunden:",7750]
[null,null,null,null,null,null,null,null,"Gesamtleistung:",6340565,null,null,null,"Budgetierte Gesamtkosten:",250000]
[]
[]
[null,null,null,null,null,null,null,"Eingaben zu Logistikprozessen"]
[]
[null,null,null,null,null,null,null,null,null,null,"Anzahl\nProzesse","Ø Dauer je\nProzess in Std.","Ø Std.-\nSatz","Gesamter\nZeitaufwand","Gesamt-\nkosten"]
[]
[null,null,null,null,null,null,null,null,"Wareneingang"]
[null,null,null,null,null,null,null,null,"Disposition/Abrufe",null,400,0.5,35,{"$f":"IF($Z19=0,\"\",ROUND(K19*L19,2))","v":200},{"$f":"IF($Z19=0,\"\",ROUND(N19*M19,2))","v":7000},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(K19),ISNUMBER(L19),ISNUMBER(M19)),1,0)),0,IF(AND(ISNUMBER(K19),ISNUMBER(L19),ISNUMBER(M19)),1,0))","v":1}]
[null,null,null,null,null,null,null,null,"Warenannahme",null,1600,0.3,32,{"$f":"IF($Z20=0,\"\",ROUND(K20*L20,2))","v":480},{"$f":"IF($Z20=0,\"\",ROUND(N20*M20,2))","v":15360},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(K20),ISNUMBER(L20),ISNUMBER(M20)),1,0)),0,IF(AND(ISNUMBER(K20),ISNUMBER(L20),ISNUMBER(M20)),1,0))","v":1}]
[null,null,null,null,null,null,null,null,"Wareneingangsprüfung",null,800,0.5,35,400,14000,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Reklamationen",null,80,1,32,80,2560,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Nacharbeiten",null,30,1.25,35,37.5,1312.5,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Verpackungsarbeiten",null,60,0.5,32,30,960,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Besprechungen",null,50,1,35,50,1750,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Sonstiges",null,50,1,35,50,1750,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Summe Wareneingang",null,null,null,null,{"$f":"IF(ISERROR(IF(SUM(N19:N26)>0,SUM(N19:N26),\"\")),\"\",IF(SUM(N19:N26)>0,SUM(N19:N26),\"\"))","v":1327.5},{"$f":"IF(ISERROR(IF(SUM(O19:O26)>0,SUM(O19:O26),\"\")),\"\",IF(SUM(O19:O26)>0,SUM(O19:O26),\"\"))","v":44692.5}]
[]
[null,null,null,null,null,null,null,null,"Lagerhaltung"]
[null,null,null,null,null,null,null,null,"Einlagerungen",null,2400,0.25,30,{"$f":"IF($Z30=0,\"\",ROUND(K30*L30,2))","v":600},{"$f":"IF($Z30=0,\"\",ROUND(N30*M30,2))","v":18000},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(K30),ISNUMBER(L30),ISNUMBER(M30)),1,0)),0,IF(AND(ISNUMBER(K30),ISNUMBER(L30),ISNUMBER(M30)),1,0))","v":1}]
[null,null,null,null,null,null,null,null,"Umlagerungen",null,500,0.5,30,250,7500,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Auslagerungen",null,4800,0.25,30,1200,36000,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Bestandsaufnahme RHB, Fremdteile",null,12,2,35,24,840,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Bestandsaufnahme Fertigteile",null,12,4,35,48,1680,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Bestandsaufnahme Außenläger",null,12,8,35,96,3360,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Bestandsaufnahme Leergut-/Pfandsysteme",null,4,2,32,8,256,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Besprechungen",null,30,0.75,30,22.5,675,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Sonstiges",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summe Lagerhaltung",null,null,null,null,{"$f":"IF(ISERROR(IF(SUM(N30:N38)>0,SUM(N30:N38),\"\")),\"\",IF(SUM(N30:N38)>0,SUM(N30:N38),\"\"))","v":2248.5},{"$f":"IF(ISERROR(IF(SUM(O30:O38)>0,SUM(O30:O38),\"\")),\"\",IF(SUM(O30:O38)>0,SUM(O30:O38),\"\"))","v":68311}]
[]
[null,null,null,null,null,null,null,null,"Innerbetrieblicher Transport"]
[null,null,null,null,null,null,null,null,"Transporte vom und zum Lager",null,4200,0.3,28,{"$f":"IF($Z42=0,\"\",ROUND(K42*L42,2))","v":1260},{"$f":"IF($Z42=0,\"\",ROUND(N42*M42,2))","v":35280},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(K42),ISNUMBER(L42),ISNUMBER(M42)),1,0)),0,IF(AND(ISNUMBER(K42),ISNUMBER(L42),ISNUMBER(M42)),1,0))","v":1}]
[null,null,null,null,null,null,null,null,"Sonst. innerbetriebliche Transporte",null,6400,0.25,28,{"$f":"IF($Z43=0,\"\",ROUND(K43*L43,2))","v":1600},{"$f":"IF($Z43=0,\"\",ROUND(N43*M43,2))","v":44800},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(K43),ISNUMBER(L43),ISNUMBER(M43)),1,0)),0,IF(AND(ISNUMBER(K43),ISNUMBER(L43),ISNUMBER(M43)),1,0))","v":1}]
[null,null,null,null,null,null,null,null,"Sonstiges",null,null,null,null,{"$f":"IF($Z44=0,\"\",ROUND(K44*L44,2))","v":""},{"$f":"IF($Z44=0,\"\",ROUND(N44*M44,2))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(K44),ISNUMBER(L44),ISNUMBER(M44)),1,0)),0,IF(AND(ISNUMBER(K44),ISNUMBER(L44),ISNUMBER(M44)),1,0))","v":0}]
[null,null,null,null,null,null,null,null,"Summe innerbetrieblicher Transport",null,null,null,null,{"$f":"IF(ISERROR(IF(SUM(N42:N44)>0,SUM(N42:N44),\"\")),\"\",IF(SUM(N42:N44)>0,SUM(N42:N44),\"\"))","v":2860},{"$f":"IF(ISERROR(IF(SUM(O42:O44)>0,SUM(O42:O44),\"\")),\"\",IF(SUM(O42:O44)>0,SUM(O42:O44),\"\"))","v":80080}]
[]
[null,null,null,null,null,null,null,null,"Warenausgang",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(K47),ISNUMBER(L47),ISNUMBER(M47)),1,0)),0,IF(AND(ISNUMBER(K47),ISNUMBER(L47),ISNUMBER(M47)),1,0))","v":0}]
[null,null,null,null,null,null,null,null,"Auslieferungsdisposition",null,1400,0.3,35,{"$f":"IF($Z48=0,\"\",ROUND(K48*L48,2))","v":420},{"$f":"IF($Z48=0,\"\",ROUND(N48*M48,2))","v":14700},null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Versandaufträge, -dokumente",null,1800,0.5,35,900,31500,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Ausgangsprüfung",null,1800,0.25,35,450,15750,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Verpackung, Leergut, Pfand etc.",null,60,0.5,32,30,960,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Besprechungen",null,30,0.75,35,22.5,787.5,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Sonstiges",null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Summe Warenausgang",null,null,null,null,{"$f":"IF(ISERROR(IF(SUM(N48:N53)>0,SUM(N48:N53),\"\")),\"\",IF(SUM(N48:N53)>0,SUM(N48:N53),\"\"))","v":1822.5},{"$f":"IF(ISERROR(IF(SUM(O48:O53)>0,SUM(O48:O53),\"\")),\"\",IF(SUM(O48:O53)>0,SUM(O48:O53),\"\"))","v":63697.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Summe Std.","Ø Std.-Satz","Ges.-Std.","Kosten"]
[null,null,null,null,null,null,null,null,"Summe (bezahlte) Leerstunden",null,null,750,30,{"$f":"IF(L57=\"\",\"\",L57)","v":750},{"$f":"IF($Z57=0,\"\",ROUND(N57*M57,2))","v":22500},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(AND(ISNUMBER(L57),ISNUMBER(M57)),1,0)),0,IF(AND(ISNUMBER(L57),ISNUMBER(M57)),1,0))","v":1}]
[]
[]
[null,null,null,null,null,null,null,"Auswertung"]
[]
[null,null,null,null,null,null,null,null,"Gesamtwerte Wareneingang:",null,{"$f":"IF(ISERROR(N27),\"\",N27)","v":1327.5},{"$f":"IF(ISERROR(O27),\"\",O27)","v":44692.5},null,"Budgetierte Std.:",{"$f":"+IF(O10=\"\",\"\",O10)","v":7750}]
[null,null,null,null,null,null,null,null,"Gesamtwerte Lagerhaltung:",null,{"$f":"IF(ISERROR(N39),\"\",N39)","v":2248.5},{"$f":"IF(ISERROR(O39),\"\",O39)","v":68311},null,"IST-Std.:",{"$f":"IF(ISERROR(K67),\"\",K67)","v":7647}]
[null,null,null,null,null,null,null,null,"Gesamtwerte innerbetr. Logistik:",null,{"$f":"IF(ISERROR(N45),\"\",N39)","v":2248.5},{"$f":"IF(ISERROR(O45),\"\",O45)","v":80080},null,{"$f":"+IF(O64>1,\"Stundeneinsparung von:\",IF(O64=0,\"Keine Abweichung\",\"Mehr-Stunden von\"))","v":"Stundeneinsparung von:"},{"$f":"IF(ISERROR((O62-O63)),\"\",(O62-O63))","v":103}]
[null,null,null,null,null,null,null,null,"Gesamtwerte Warenausgang:",null,{"$f":"IF(ISERROR(N54),\"\",N54)","v":1822.5},{"$f":"IF(ISERROR(O54),\"\",O54)","v":63697.5},null,"Budgetierte Kosten:",{"$f":"+IF(O11=\"\",\"\",O11)","v":250000}]
[null,null,null,null,null,null,null,null,"Leerstunden:",null,{"$f":"IF(ISERROR(N57),\"\",N57)","v":750},{"$f":"IF(ISERROR(O57),\"\",O57)","v":22500},null,"IST-Kosten:",{"$f":"IF(ISERROR(L67),\"\",L67)","v":256781}]
[null,null,null,null,null,null,null,null,"Summen Logistikwerte:",null,{"$f":"IF(ISERROR(IF(+SUM(K62:K65)>0,+SUM(K62:K65),\"\")),\"\",IF(+SUM(K62:K65)>0,+SUM(K62:K65),\"\"))","v":7647},{"$f":"IF(ISERROR(IF(+SUM(L62:L65)>0,+SUM(L62:L65),\"\")),\"\",IF(+SUM(L62:L65)>0,+SUM(L62:L65),\"\"))","v":256781},null,{"$f":"+IF(O67<1,\"Kosteneinsarum von:\",IF(O67=0,\"Keine Abweichung\",\"Mehrkosten von:\"))","v":"Mehrkosten von:"},{"$f":"IF(ISERROR(-(O65-O66)),\"\",-(O65-O66))","v":6781}]
[]
[null,null,null,null,null,null,null,null,"Logistikkosten in % vom Umsatz:",null,{"$f":"IF(ISERROR(ROUND(L67/J10,4)),\"\",ROUND(L67/J10,4))","v":4.0899999999999999E-2},null,null,"Anzahl Prozesse:",{"$f":"IF(ISERROR(IF(SUM(K48:K54,K42:K44,K30:K38,K19:K26)=0,\"\",SUM(K48:K54,K42:K44,K30:K38,K19:K26))),\"\",IF(SUM(K48:K54,K42:K44,K30:K38,K19:K26)=0,\"\",SUM(K48:K54,K42:K44,K30:K38,K19:K26)))","v":26530}]
[null,null,null,null,null,null,null,null,"Logistikkosten in % von der GL:",null,{"$f":"IF(ISERROR(ROUND(L67/J11,4)),\"\",ROUND(L67/J11,4))","v":4.0500000000000001E-2},null,null,"Ø Kosten je Prozess:",{"$f":"IF(ISERROR(ROUND(L67/O69,2)),\"\",ROUND(L67/O69,2))","v":9.68}]