{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":4,"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":"Tabelle1","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[17,8,18,8],[19,8,21,8],[2,2,2,8]]}
[]
[]
[null,null,"Optimales Produktionsprogramm mit relativen Deckungsbeiträgen"]
[]
[null,null,"Produkt","A","B","C","D","E","Kapazitätsgrenze"]
[null,null,"Stückpreis in €",3.5,3.1,5.2,7.4,9,"in Stunden"]
[null,null,"variable Stückkosten in €",1.9,2.4,3.1,3.8,7,7000]
[null,null,"Stückdeckungsbeitrag in €",{"$f":"D6-D7","v":1.6},{"$f":"E6-E7","v":0.70000000000000018},{"$f":"F6-F7","v":2.1},{"$f":"G6-G7","v":3.6000000000000005},{"$f":"H6-H7","v":2},"Auslastung in %"]
[null,null,"Arbeitszeit (Minuten/Stück)",10,5,12,15,20,90]
[null,null,"relativer Deckungsbeitrag",{"$f":"IF(D8>0,D8/D9,0)","v":0.16},{"$f":"IF(E8>0,E8/E9,0)","v":0.14000000000000004},{"$f":"IF(F8>0,F8/F9,0)","v":0.17500000000000002},{"$f":"IF(G8>0,G8/G9,0)","v":0.24000000000000005},{"$f":"IF(H8>0,H8/H9,0)","v":0.1}]
[null,null,"Rang",{"$f":"RANK(D10,$D$10:$H$10)","v":3},{"$f":"RANK(E10,$D$10:$H$10)","v":4},{"$f":"RANK(F10,$D$10:$H$10)","v":2},{"$f":"RANK(G10,$D$10:$H$10)","v":1},{"$f":"RANK(H10,$D$10:$H$10)","v":5}]
[null,null,"Menge",9000,2000,8000,8000,4000]
[]
[null,null,"Produktionsrangfolge",{"$f":"IF($D$11=1,$D$5,IF($E$11=1,$E$5,IF($F$11=1,$F$5,IF($G$11=1,$G$5,$H$5))))","v":"D"},{"$f":"IF($D$11=2,$D$5,IF($E$11=2,$E$5,IF($F$11=2,$F$5,IF($G$11=2,$G$5,$H$5))))","v":"C"},{"$f":"IF($D$11=3,$D$5,IF($E$11=3,$E$5,IF($F$11=3,$F$5,IF($G$11=3,$G$5,$H$5))))","v":"A"},{"$f":"IF($D$11=4,$D$5,IF($E$11=4,$E$5,IF($F$11=4,$F$5,IF($G$11=4,$G$5,$H$5))))","v":"B"},{"$f":"IF($D$11=5,$D$5,IF($E$11=5,$E$5,IF($F$11=5,$F$5,IF($G$11=5,$G$5,$H$5))))","v":"E"}]
[null,null,"absetzbare Menge",{"$f":"IF($D$11=1,$D$12,IF($E$11=1,$E$12,IF($F$11=1,$F$12,IF($G$11=1,$G$12,$H$12))))","v":8000},{"$f":"IF($D$11=2,$D$12,IF($E$11=2,$E$12,IF($F$11=2,$F$12,IF($G$11=2,$G$12,$H$12))))","v":8000},{"$f":"IF($D$11=3,$D$12,IF($E$11=3,$E$12,IF($F$11=3,$F$12,IF($G$11=3,$G$12,$H$12))))","v":9000},{"$f":"IF($D$11=4,$D$12,IF($E$11=4,$E$12,IF($F$11=4,$F$12,IF($G$11=4,$G$12,$H$12))))","v":2000},{"$f":"IF($D$11=5,$D$12,IF($E$11=5,$E$12,IF($F$11=5,$F$12,IF($G$11=5,$G$12,$H$12))))","v":4000}]
[null,null,"beötigte Produktionsminuten",{"$f":"IF($D$11=1,$D$9*$D$12,IF($E$11=1,$E$9*$E$12,IF($F$11=1,$F$9*$F$12,IF($G$11=1,$G$9*$G$12,$H$9*$H$12))))","v":120000},{"$f":"IF($D$11=2,$D$9*$D$12,IF($E$11=2,$E$9*$E$12,IF($F$11=2,$F$9*$F$12,IF($G$11=2,$G$9*$G$12,$H$9*$H$12))))","v":96000},{"$f":"IF($D$11=3,$D$9*$D$12,IF($E$11=3,$E$9*$E$12,IF($F$11=3,$F$9*$F$12,IF($G$11=3,$G$9*$G$12,$H$9*$H$12))))","v":90000},{"$f":"IF($D$11=4,$D$9*$D$12,IF($E$11=4,$E$9*$E$12,IF($F$11=4,$F$9*$F$12,IF($G$11=4,$G$9*$G$12,$H$9*$H$12))))","v":10000},{"$f":"IF($D$11=5,$D$9*$D$12,IF($E$11=5,$E$9*$E$12,IF($F$11=5,$F$9*$F$12,IF($G$11=5,$G$9*$G$12,$H$9*$H$12))))","v":80000}]
[null,null,"benötigte Produktionsstunden",{"$f":"D16/60","v":2000},{"$f":"E16/60","v":1600},{"$f":"F16/60","v":1500},{"$f":"G16/60","v":166.66666666666666},{"$f":"H16/60","v":1333.3333333333333}]
[null,null,"verfügbare Stunden",{"$f":"I7*I9/100","v":6300},{"$f":"D18-D17","v":4300},{"$f":"IF(E19>0,0,E18-E17)","v":2700},{"$f":"IF(F19>0,0,F18-F17)","v":1200},{"$f":"IF(G19>0,0,G18-G17)","v":1033.3333333333333},{"$f":"IF(I27<0,\"Verlust!\",\"Gewinn\")","v":"Gewinn"}]
[null,null,"Fehlstunden",{"$f":"IF(D18>D17,0,D17-D18)","v":0},{"$f":"IF(E18>E17,0,E17-E18)","v":0},{"$f":"IF(F18>F17,0,F17-F18)","v":0},{"$f":"IF(G18>G17,0,G17-G18)","v":0},{"$f":"IF(H18>H17,0,H17-H18)","v":300}]
[null,null,"verfügbare Minuten",{"$f":"IF(D19=0,D17*60,D18*60)","v":120000},{"$f":"IF(E19=0,E17*60,E18*60)","v":96000},{"$f":"IF(F19=0,F17*60,F18*60)","v":90000},{"$f":"IF(G19=0,G17*60,G18*60)","v":10000},{"$f":"IF(H19=0,H17*60,H18*60)","v":61999.999999999993},{"$f":"IF(SUM(D22:H22)>0,\"nicht erfüllte Aufträge!\",\"Aufträge erfüllt\")","v":"nicht erfüllte Aufträge!"}]
[null,null,"mögliche Produktionsmenge",{"$f":"IF(D15>0,IF($D$11=1,D20/$D$9,IF($E$11=1,D20/$E$9,IF($F$11=1,D20/$F$9,IF($G$11=1,D20/$G$9,D20/$H$9)))),0)","v":8000},{"$f":"IF(E15>0,IF($D$11=2,E20/$D$9,IF($E$11=2,E20/$E$9,IF($F$11=2,E20/$F$9,IF($G$11=2,E20/$G$9,E20/$H$9)))),0)","v":8000},{"$f":"IF(F15>0,IF($D$11=3,F20/$D$9,IF($E$11=3,F20/$E$9,IF($F$11=3,F20/$F$9,IF($G$11=3,F20/$G$9,F20/$H$9)))),0)","v":9000},{"$f":"IF(G15>0,IF($D$11=4,G20/$D$9,IF($E$11=4,G20/$E$9,IF($F$11=4,G20/$F$9,IF($G$11=4,G20/$G$9,G20/$H$9)))),0)","v":2000},{"$f":"IF(H15>0,IF($D$11=5,H20/$D$9,IF($E$11=5,H20/$E$9,IF($F$11=5,H20/$F$9,IF($G$11=5,H20/$G$9,H20/$H$9)))),0)","v":3099.9999999999995}]
[null,null,"nicht erfüllte Aufträge",{"$f":"D15-D21","v":0},{"$f":"E15-E21","v":0},{"$f":"F15-F21","v":0},{"$f":"G15-G21","v":0},{"$f":"H15-H21","v":900.00000000000045}]
[]
[null,null,"Produkte",{"$f":"IF($D$11=1,$D$5,IF($E$11=1,$E$5,IF($F$11=1,$F$5,IF($G$11=1,$G$5,$H$5))))","v":"D"},{"$f":"IF($D$11=2,$D$5,IF($E$11=2,$E$5,IF($F$11=2,$F$5,IF($G$11=2,$G$5,$H$5))))","v":"C"},{"$f":"IF($D$11=3,$D$5,IF($E$11=3,$E$5,IF($F$11=3,$F$5,IF($G$11=3,$G$5,$H$5))))","v":"A"},{"$f":"IF($D$11=4,$D$5,IF($E$11=4,$E$5,IF($F$11=5,$F$5,IF($G$11=4,$G$5,$H$5))))","v":"B"},{"$f":"IF($D$11=5,$D$5,IF($E$11=5,$E$5,IF($F$11=5,$F$5,IF($G$11=5,$G$5,$H$5))))","v":"E"},"Summe"]
[null,null,"Gesamtdeckungsbeitrag",{"$f":"IF($D$11=1,$D$8*D21,IF($E$11=1,$E$8*D21,IF($F$11=1,$F$8*D21,IF($G$11=1,$G$8*D21,$H$8*D21))))","v":28800.000000000004},{"$f":"IF($D$11=2,$D$8*E21,IF($E$11=2,$E$8*E21,IF($F$11=2,$F$8*E21,IF($G$11=2,$G$8*E21,$H$8*E21))))","v":16800},{"$f":"IF($D$11=3,$D$8*F21,IF($E$11=3,$E$8*F21,IF($F$11=3,$F$8*F21,IF($G$11=3,$G$8*F21,$H$8*F21))))","v":14400},{"$f":"IF($D$11=4,$D$8*G21,IF($E$11=4,$E$8*G21,IF($F$11=4,$F$8*G21,IF($G$11=4,$G$8*G21,$H$8*G21))))","v":1400.0000000000005},{"$f":"IF($D$11=5,$D$8*H21,IF($E$11=5,$E$8*H21,IF($F$11=5,$F$8*H21,IF($G$11=5,$G$8*H21,$H$8*H21))))","v":6199.9999999999991},{"$f":"SUM(D25:H25)","v":67600}]
[null,null,"fixe Gesamtkosten",null,null,null,null,null,50000]
[null,null,"Betriebsergebnis",null,null,null,null,null,{"$f":"I25-I26","v":17600}]

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