{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Produkt A","Produkt B","Produkt C","DBR Produktionsbereich X","DBR Produktionsbereich Y","DBR Gesamt"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":31,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",7]
[null,"Thema","Strategisches Prozess-Controlling"]
[]
[null,"Inhalt","Deckungsbeitragsrechnung mehrstufig"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","2.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2023-08-03"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Produkt A","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Produktionsbereich X"]
[null,"Produkt A","Wert","Anteil"]
[null,"Umsatzerlöse",312000,1]
["-","variable Kosten",-9000,{"$f":"variable_Kosten/Umsatzerlöse","v":-2.8846153846153848E-2}]
["=","Nettoumsatz",{"$f":"Umsatzerlöse+variable_Kosten","v":303000},{"$f":"Nettoumsatz/Umsatzerlöse","v":0.97115384615384615}]
["-","direkte Herstellkosten",-120000,{"$f":"direkte_Herstellkosten/Umsatzerlöse","v":-0.38461538461538464}]
["=","Deckungsbeitrag 1",{"$f":"Nettoumsatz+direkte_Herstellkosten","v":183000},{"$f":"Deckungsbeitrag_1/Umsatzerlöse","v":0.58653846153846156}]
["-","direkte Gemeinkosten",-22500,{"$f":"direkte_Gemeinkosten/Umsatzerlöse","v":-7.2115384615384609E-2}]
["=","Deckungsbeitrag 2",{"$f":"Deckungsbeitrag_1+direkte_Gemeinkosten","v":160500},{"$f":"Deckungsbeitrag_2/Umsatzerlöse","v":0.51442307692307687}]

{"sheet":"Produkt B","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[18,1,18,3]]}
[null,"Produktionsbereich X"]
[null,"Produkt B","Wert","Anteil"]
[null,"Umsatzerlöse",322000,1]
["-","variable Kosten",-23600,{"$f":"variable_Kosten/Umsatzerlöse","v":-7.3291925465838514E-2}]
["=","Nettoumsatz",{"$f":"Umsatzerlöse+variable_Kosten","v":298400},{"$f":"Nettoumsatz/Umsatzerlöse","v":0.92670807453416149}]
["-","direkte Herstellkosten",-165000,{"$f":"direkte_Herstellkosten/Umsatzerlöse","v":-0.51242236024844723}]
["=","Deckungsbeitrag 1",{"$f":"Nettoumsatz+direkte_Herstellkosten","v":133400},{"$f":"Deckungsbeitrag_1/Umsatzerlöse","v":0.41428571428571431}]
["-","direkte Gemeinkosten",-21800,{"$f":"direkte_Gemeinkosten/Umsatzerlöse","v":-6.7701863354037273E-2}]
["=","Deckungsbeitrag 2",{"$f":"Deckungsbeitrag_1+direkte_Gemeinkosten","v":111600},{"$f":"Deckungsbeitrag_2/Umsatzerlöse","v":0.34658385093167704}]

{"sheet":"Produkt C","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[18,1,18,3]]}
[null,"Produktionsbereich Y"]
[null,"Produkt C","Wert","Anteil"]
[null,"Umsatzerlöse",265000,1]
["-","variable Kosten",-114000,{"$f":"variable_Kosten/Umsatzerlöse","v":-0.43018867924528303}]
["=","Nettoumsatz",{"$f":"Umsatzerlöse+variable_Kosten","v":151000},{"$f":"Nettoumsatz/Umsatzerlöse","v":0.56981132075471697}]
["-","direkte Herstellkosten",-16800,{"$f":"direkte_Herstellkosten/Umsatzerlöse","v":-6.3396226415094334E-2}]
["=","Deckungsbeitrag 1",{"$f":"Nettoumsatz+direkte_Herstellkosten","v":134200},{"$f":"Deckungsbeitrag_1/Umsatzerlöse","v":0.50641509433962262}]
["-","direkte Gemeinkosten",-20800,{"$f":"direkte_Gemeinkosten/Umsatzerlöse","v":-7.8490566037735854E-2}]
["=","Deckungsbeitrag 2",{"$f":"Deckungsbeitrag_1+direkte_Gemeinkosten","v":113400},{"$f":"Deckungsbeitrag_2/Umsatzerlöse","v":0.42792452830188682}]

{"sheet":"DBR Produktionsbereich X","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Produktionsbereich X","Wert","Anteil"]
[null,"Umsatzerlöse",634000,1]
["-","variable Kosten",-32600,{"$f":"C3/C$2","v":-5.1419558359621448E-2}]
["=","Nettoumsatz",601400,{"$f":"C4/C$2","v":0.94858044164037858}]
["-","direkte Herstellkosten",-285000,-0.44952681388012616]
["=","Deckungsbeitrag 1",316400,0.49905362776025236]
["-","produktfixe Kosten",-44300,-6.9873817034700317E-2]
["=","Deckungsbeitrag 2",272100,0.42917981072555206]
["-","produktgruppenfixe Kosten",-26700,-4.2113564668769719E-2]
["=","Deckungsbeitrag 3",{"$f":"C8+C9","v":245400},0.38706624605678236]
["-","bereichsfixe Kosten",-19000,-2.996845425867508E-2]
["=","Deckungsbeitrag 4",{"$f":"C10+C11","v":226400},0.35709779179810724]

{"sheet":"DBR Produktionsbereich Y","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Produktionsbereich Y","Wert","Anteil"]
[null,"Umsatzerlöse",265000,1]
["-","variable Kosten",-114000,{"$f":"C3/C$2","v":-0.43018867924528303}]
["=","Nettoumsatz",151000,{"$f":"C4/C$2","v":0.56981132075471697}]
["-","direkte Herstellkosten",-16800,-6.3396226415094334E-2]
["=","Deckungsbeitrag 1",134200,0.50641509433962262]
["-","produktfixe Kosten",-20800,-7.8490566037735854E-2]
["=","Deckungsbeitrag 2",113400,0.42792452830188682]
["-","produktgruppenfixe Kosten",-12900,-4.8679245283018868E-2]
["=","Deckungsbeitrag 3",{"$f":"C8+C9","v":100500},0.37924528301886795]
["-","bereichsfixe Kosten",-16800,-6.3396226415094334E-2]
["=","Deckungsbeitrag 4",{"$f":"C10+C11","v":83700},0.3158490566037736]

{"sheet":"DBR Gesamt","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Gesamt","Wert","Anteil"]
[null,"Umsatzerlöse",899000,1]
["-","variable Kosten",-146600,{"$f":"C3/C$2","v":-0.16307007786429367}]
["=","Nettoumsatz",752400,{"$f":"C4/C$2","v":0.83692992213570638}]
["-","direkte Herstellkosten",-301800,-0.33570634037819802]
["=","Deckungsbeitrag 1",450600,0.50122358175750836]
["-","produktfixe Kosten",-65100,-7.2413793103448282E-2]
["=","Deckungsbeitrag 2",385500,0.42880978865406005]
["-","produktgruppenfixe Kosten",-39600,-4.4048943270300331E-2]
["=","Deckungsbeitrag 3",345900,0.38476084538375971]
["-","bereichsfixe Kosten",-35800,-3.9822024471635152E-2]
["=","Deckungsbeitrag 4",310100,0.34493882091212458]
["-","unternehmensfixe Kosten",-61600,-6.8520578420467187E-2]
["=","Betriebserlös",{"$f":"C12+C13","v":248500},0.27641824249165742]