{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":1,"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":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,8,45,9],[25,1,27,1],[28,1,30,1],[19,1,21,1],[22,1,24,1],[43,8,43,9],[19,5,21,5],[22,5,24,5],[25,5,27,5],[28,5,30,5],[19,2,21,2],[22,2,24,2],[25,2,27,2],[28,2,30,2],[44,8,44,9],[13,7,13,9],[13,1,14,2],[13,3,15,4],[13,5,15,5],[16,5,18,5],[16,1,18,1],[16,2,18,2]]}
[]
[null,"Optimales Produktionsprogramm ",null,null,null,null,null,null,null,null,null,"Portici1!"]
[null,"nach relativen Deckungsbeiträgen ",null,null,null,null,"(bis 5  Produkte)"]
[null,null,"Stück-","variable","absoluter","Arbeitszeit","relativer",null,"mögliche","vertragliche",null,"Hinweise"]
[null,"Produkte","preise","Stückkosten","Deckungsbeitrag","Min/Stück","Deckungsbeitrag","Rang","Absatzmenge","Mindestmenge",null,"Klicken Sie auf \"Eingabe\" und geben Sie die"]
[null,"A",1.4,0.4,{"$f":"C6-D6","v":0.99999999999999989},4,{"$f":"IF(C6>0,E6/F6,0)","v":0.24999999999999997},{"$f":"RANK(G6,$G$6:$G$10,0)","v":5},12000,3000,null,"Daten, für bis zu 5 verschiedene Produkte, zur"]
[null,"B",2.4,0.8,{"$f":"C7-D7","v":1.5999999999999999},6,{"$f":"IF(C7>0,E7/F7,0)","v":0.26666666666666666},{"$f":"RANK(G7,$G$6:$G$10,0)","v":4},2000,0,null,"Ermittlung des optimalen Produktions-"]
[null,"C",3.4,1.2,2.2000000000000002,8,0.27500000000000002,3,8000,0,null,"programms und des daraus resultierenden"]
[null,"D",4.4000000000000004,1.6,2.8000000000000003,10,0.28000000000000003,2,8000,0,null,"Betriesergebnisses ein."]
[null,"E",5.4,2,3.4000000000000004,12,0.28333333333333338,1,4000,0]
[null,null,null,null,null,null,null,null,null,null,null,"Der Wert in der grünen Zelle J32 ist ein Kontrollwert"]
[null,"Gesamtzeit/Stunden:",null,3800,"Auslastung in %:",90,"Nettoarbeitszeit:",{"$f":"(D12*F12)/100","v":3420},"fixe Kosten:",40000,null,"zur Analyse von Abweichungen zwischen "]
[null,null,null,null,null,null,null,null,null,null,null,"Nettoarbeitszeit und Gesamtzeit. Er muss 0 sein."]
[null,"Produkte, sortiert nach Rang",null,"Mengen",null,"Arbeitszeit Minuten/Stück","Arbeitszeit für","Arbeitszeit Restmenge/Stunden",null,null,null,"Die Werte für die Arbeitszeiten sind gerundet, werden"]
[null,null,null,null,null,null,"Mindestmengen","notwendige","Produktions-","Gesamt-",null,"aber als ganze Zahlen ausgewiesen. Daher kann es zu "]
[null,"Rang","Produkt",null,null,null,"in Stunden","Zeit","zeit","zeit",null,"kleineren Abweichungen bei der Zeitaddition kommen."]
[null,1,{"$f":"IF($H$6=1,$B$6,IF($H$7=1,$B$7,IF($H$8=1,$B$8,IF($H$9=1,$B$9,$B$10))))","v":"E"},"Absatzmenge",{"$f":"IF(C17=\"A\",$I$6,IF(C17=\"B\",$I$7,IF(C17=\"C\",$I$8,IF(C17=\"D\",$I$9,$I$10))))","v":4000},{"$f":"IF(C17=\"A\",$F$6,IF(C17=\"B\",$F$7,IF(C17=\"C\",$F$8,IF(C17=\"D\",$F$9,$F$10))))","v":12},null,null,null,null,null,"Wenn die Kapazität zur Produktion der Mindestmengen"]
[null,null,null,"Mindestmenge",{"$f":"IF(C17=\"A\",$J$6,IF(C17=\"B\",$J$7,IF(C17=\"C\",$J$8,IF(C17=\"D\",$J$9,$J$10))))","v":0},null,{"$f":"(E18*F17)/60","v":0},null,null,null,null,"nicht ausreicht, wird dies in den Zellen B33 - J33 angezeigt"]
[null,null,null,"Restmenge",{"$f":"E17-E18","v":4000},null,null,{"$f":"(E19*F17)/60","v":800},{"$f":"IF(I32<0,0,IF(H19<I32,H19,I32))","v":800},{"$f":"G32+I19","v":1000},null,"und eine Kapazitätsausdehnung und/oder Fremdbezug"]
[null,2,{"$f":"IF($H$6=2,$B$6,IF($H$7=2,$B$7,IF($H$8=2,$B$8,IF($H$9=2,$B$9,$B$10))))","v":"D"},"Absatzmenge",{"$f":"IF(C20=\"A\",$I$6,IF(C20=\"B\",$I$7,IF(C20=\"C\",$I$8,IF(C20=\"D\",$I$9,$I$10))))","v":8000},{"$f":"IF(C20=\"A\",$F$6,IF(C20=\"B\",$F$7,IF(C20=\"C\",$F$8,IF(C20=\"D\",$F$9,$F$10))))","v":10},null,null,null,null,null,"empfohlen. "]
[null,null,null,"Mindestmenge",{"$f":"IF(C20=\"A\",$J$6,IF(C20=\"B\",$J$7,IF(C20=\"C\",$J$8,IF(C20=\"D\",$J$9,$J$10))))","v":0},null,{"$f":"(E21*F20)/60","v":0}]
[null,null,null,"Restmenge",{"$f":"E20-E21","v":8000},null,null,{"$f":"(E22*F20)/60","v":1333.3333333333333},{"$f":"IF(I32<0,0,IF(H22<(I32-I19),H22,(I32-I19)))","v":1333.3333333333333},{"$f":"J19+I22","v":2333.333333333333},null,"Nicht ausreichende Kapazitäten und nicht erfüllte"]
[null,3,{"$f":"IF($H$6=3,$B$6,IF($H$7=3,$B$7,IF($H$8=3,$B$8,IF($H$9=3,$B$9,$B$10))))","v":"C"},"Absatzmenge",{"$f":"IF(C23=\"A\",$I$6,IF(C23=\"B\",$I$7,IF(C23=\"C\",$I$8,IF(C23=\"D\",$I$9,$I$10))))","v":8000},{"$f":"IF(C23=\"A\",$F$6,IF(C23=\"B\",$F$7,IF(C23=\"C\",$F$8,IF(C23=\"D\",$F$9,$F$10))))","v":8},null,null,null,null,null,"Aufträge zur Produktion der Restmengen werden"]
[null,null,null,"Mindestmenge",{"$f":"IF(C23=\"A\",$J$6,IF(C23=\"B\",$J$7,IF(C23=\"C\",$J$8,IF(C23=\"D\",$J$9,$J$10))))","v":0},null,{"$f":"(E24*F23)/60","v":0},null,null,null,null,"angezeigtund eine Erhöhung der Kapazität empfohlen."]
[null,null,null,"Restmenge",{"$f":"E23-E24","v":8000},null,null,{"$f":"(E25*F23)/60","v":1066.6666666666667},{"$f":"IF(I32<0,0,IF(H25<(I32-I19-I22),H25,(I32-I19-I22)))","v":1066.6666666666667},{"$f":"J22+I25","v":3400}]
[null,4,{"$f":"IF($H$6=4,$B$6,IF($H$7=4,$B$7,IF($H$8=4,$B$8,IF($H$9=4,$B$9,$B$10))))","v":"B"},"Absatzmenge",{"$f":"IF(C26=\"A\",$I$6,IF(C26=\"B\",$I$7,IF(C26=\"C\",$I$8,IF(C26=\"D\",$I$9,$I$10))))","v":2000},{"$f":"IF(C26=\"A\",$F$6,IF(C26=\"B\",$F$7,IF(C26=\"C\",$F$8,IF(C26=\"D\",$F$9,$F$10))))","v":6},null,null,null,null,null,"Ein positives Betriebsergebnis wird grün hinterlegt."]
[null,null,null,"Mindestmenge",{"$f":"IF(C26=\"A\",$J$6,IF(C26=\"B\",$J$7,IF(C26=\"C\",$J$8,IF(C26=\"D\",$J$9,$J$10))))","v":0},null,{"$f":"(E27*F26)/60","v":0},null,null,null,null,"Ein negative Betriebsergebnis wird rot hinterlegt und"]
[null,null,null,"Restmenge",{"$f":"E26-E27","v":2000},null,null,{"$f":"(E28*F26)/60","v":200},{"$f":"IF(I32<0,0,IF(H28<(I32-I19-I22-I25),H28,(I32-I19-I22-I25)))","v":20},{"$f":"J25+I28","v":3420},null,"der entsprechende Verlust angezeigt."]
[null,5,{"$f":"IF($H$6=5,$B$6,IF($H$7=5,$B$7,IF($H$8=5,$B$8,IF($H$9=5,$B$9,$B$10))))","v":"A"},"Absatzmenge",{"$f":"IF(C29=\"A\",$I$6,IF(C29=\"B\",$I$7,IF(C29=\"C\",$I$8,IF(C29=\"D\",$I$9,$I$10))))","v":12000},{"$f":"IF(C29=\"A\",$F$6,IF(C29=\"B\",$F$7,IF(C29=\"C\",$F$8,IF(C29=\"D\",$F$9,$F$10))))","v":4}]
[null,null,null,"Mindestmenge",{"$f":"IF(C29=\"A\",$J$6,IF(C29=\"B\",$J$7,IF(C29=\"C\",$J$8,IF(C29=\"D\",$J$9,$J$10))))","v":3000},null,{"$f":"(E30*F29)/60","v":200}]
[null,null,null,"Restmenge",{"$f":"E29-E30","v":9000},null,null,{"$f":"(E31*F29)/60","v":600},{"$f":"IF(I32<0,0,IF(H31<(I32-I19-I22-I25-I28),H31,(I32-I19-I22-I25-I28)))","v":0},{"$f":"J28+I31","v":3420}]
[null,null,null,null,null,"Summen",{"$f":"SUM(G17:G31)","v":200},{"$f":"SUM(H17:H31)","v":4000},{"$f":"H12-G32","v":3220},{"$f":"H12-J31","v":0}]
[null,{"$f":"IF(I32<0,\"Produktionszeit für vertragliche Mindestmengen nicht ausreichend! Kapazitätsanpassung erforderlich oder Fremdbezug!\",\"\")","v":""}]
[null,"Der Wert in der grünen Zelle J32 ist ein Kontrollwert zur Analyse von Abweichungen zwischen Nettoarbeitszeit und Gesamtzeit. Er muss 0 sein."]
[null,"Die Werte für die Arbeitszeiten sind gerundet werden aber als ganze Zahlen ausgewiesen. Daher kann es zu kleineren Abweichungen bei der Zeitaddition kommen."]
[]
[null,null,null,null,"produzierte",null,"Stück-","Gesamt-",null,"nicht erfüllte"]
[null,"Rang","Produkt","Mindestmenge","Restmenge","Gesamtmenge","deckungsbeitrag","deckungsbeitrag","Fehlstunden","Aufträge"]
[null,1,{"$f":"IF($H$6=1,$B$6,IF($H$7=1,$B$7,IF($H$8=1,$B$8,IF($H$9=1,$B$9,$B$10))))","v":"E"},{"$f":"E18","v":0},{"$f":"IF(E17>0,(I19*60)/F17,0)","v":4000},{"$f":"D39+E39","v":4000},{"$f":"IF(C39=\"A\",$E$6,IF(C39=\"b\",$E$7,IF(C39=\"C\",$E$8,IF(C39=\"d\",$E$9,$E$10))))","v":3.4000000000000004},{"$f":"F39*G39","v":13600.000000000002},{"$f":"H19-I19","v":0},{"$f":"E17-F39","v":0}]
[null,2,{"$f":"IF($H$6=2,$B$6,IF($H$7=2,$B$7,IF($H$8=2,$B$8,IF($H$9=2,$B$9,$B$10))))","v":"D"},{"$f":"E21","v":0},{"$f":"IF(E20>0,(I22*60)/F20,0)","v":8000},{"$f":"D40+E40","v":8000},{"$f":"IF(C40=\"A\",$E$6,IF(C40=\"b\",$E$7,IF(C40=\"C\",$E$8,IF(C40=\"d\",$E$9,$E$10))))","v":2.8000000000000003},{"$f":"F40*G40","v":22400.000000000004},{"$f":"H22-I22","v":0},{"$f":"E20-F40","v":0}]
[null,3,{"$f":"IF($H$6=3,$B$6,IF($H$7=3,$B$7,IF($H$8=3,$B$8,IF($H$9=3,$B$9,$B$10))))","v":"C"},{"$f":"E24","v":0},{"$f":"IF(E23>0,(I25*60)/F23,0)","v":8000.0000000000009},8000.0000000000009,2.2000000000000002,17600.000000000004,{"$f":"H25-I25","v":0},{"$f":"E23-F41","v":0}]
[null,4,{"$f":"IF($H$6=4,$B$6,IF($H$7=4,$B$7,IF($H$8=4,$B$8,IF($H$9=4,$B$9,$B$10))))","v":"B"},{"$f":"E27","v":0},{"$f":"IF(E26>0,(I28*60)/F26,0)","v":200},200,1.5999999999999999,320,{"$f":"H28-I28","v":180},{"$f":"E26-F42","v":1800}]
[null,5,{"$f":"IF($H$6=5,$B$6,IF($H$7=5,$B$7,IF($H$8=5,$B$8,IF($H$9=5,$B$9,$B$10))))","v":"A"},{"$f":"E30","v":3000},{"$f":"IF(E29>0,(I31*60)/F29,0)","v":0},3000,0.99999999999999989,2999.9999999999995,{"$f":"H31-I31","v":600},{"$f":"E29-F43","v":9000},{"$f":"ROUNDDOWN(SUM(J39:J43),0)","v":10800}]
[null,null,null,null,null,null,null,{"$f":"SUM(H39:H43)","v":56920.000000000015},{"$f":"IF(K43>0,\"Nicht erfüllte Aufträge!\",\"\")","v":"Nicht erfüllte Aufträge!"}]
[null,null,null,null,null,null,"fixe Kosten",{"$f":"J12","v":40000},{"$f":"IF(K43>0,\"Kapazität erhöhen\",\"\")","v":"Kapazität erhöhen"}]
[null,null,null,null,null,null,"Betriebsergebnis",{"$f":"H44-H45","v":16920.000000000015},{"$f":"IF(H46<0,\"Verlust!\",\"\")","v":""}]