{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Kalkulationstabelle","Blanko-Druckversion sw","Beispiel (nicht bearbeitbar)","Bedienungsanleitung","Impressum"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Kalkulationstabelle","index":0,"n_rows":157,"n_cols":9,"rows_kept":157,"cut":false,"hidden":false,"merged":[[5,0,7,0],[33,0,35,0],[61,0,63,0],[118,0,120,0],[94,0,96,0],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[85,1,85,8],[86,1,86,8],[87,1,87,8],[134,1,134,8],[135,1,135,8],[136,1,136,8],[137,1,137,8],[88,1,88,8],[109,1,109,8],[110,1,110,8],[111,1,111,8],[112,1,112,8],[133,1,133,8]],"flags":["formulas_cached_only"]}
["Szenario Wareneinsatz in Rezepten",{"$nulls":6},"MKQ",0]
[40,"Herzustellende Menge"]
[]
[]
[]
[1,"Suppe"]
[null,null,"Rezeptur für","Einheit","Herzustellende Menge:"]
[null,null,"30 Portionen","kg, l, …",40,"Einzelpreis","Summe",null,"Kommentar"]
[null,null,null,"kg, l, …",0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},0]
[null,"Gewürzzuschlag 3%",{"$nulls":4},0]
[null,"Summe",{"$nulls":4},0]
[null,"Portionspreis",{"$nulls":4},0]
[]
[null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[2,"Salate"]
[null,null,"Rezeptur für","Einheit","Herzustellende Menge:"]
[null,null,"30 Portionen","kg, l, …",40,"Einzelpreis","Summe",null,"Kommentar"]
[null,null,null,"kg, l, …",0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},0]
[null,"Gewürzzuschlag 15%",{"$nulls":4},0]
[null,"Summe",{"$nulls":4},0]
[null,"Portionspreis",{"$nulls":4},0]
[]
[null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[3,"Hauptspeise"]
[null,null,"Rezeptur für","Einheit","Herzustellende Menge:"]
[null,null,"30 Portionen","kg, l, …",40,"Einzelpreis","Summe",null,"Kommentar"]
[null,null,null,"kg, l, …",0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},0]
[null,"zzgl. Gewürzzuschlag 10%",{"$nulls":4},0]
[null,"Summe",{"$nulls":4},0]
[null,"Portionspreis",{"$nulls":4},0]
[]
[null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[4,"Dessert"]
[null,null,"Rezeptur für","Einheit","Herzustellende Menge"]
[null,null,"30 Portionen","kg, l, …",40,"Einzelpreis","Summe",null,"Kommentar"]
[null,null,null,"kg, l, …",0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},0]
[]
[]
[null,"Portionspreis",{"$nulls":4},0]
[]
[null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[5,"Abschluß (z.B. Kaffee, Tee, Gebäck)"]
[null,null,"Rezeptur für","Einheit","Herzustellende Menge"]
[null,null,"30 Portionen","kg, l, …",40,"Einzelpreis","Summe",null,"Kommentar"]
[null,null,null,"kg, l, …",0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},0]
[]
[]
[null,"Portionspreis",{"$nulls":4},0]
[]
[null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":7}
["SUMMEN"]
[]
[]
["Suppe",0]
["Salat",0]
["Hauptspeise",0]
["Dessert"]
["Kaffee",0]
[]
["Gesamt",0]
[]
[{"$nulls":4},"© esscooltur 2022"]
[]
[]
["VK (netto)=",10]
[]
["MKQ",0,"Materialkostenquote = Gesamtmaterialeinsatz (netto) geteilt durch Verkaufspreis (netto)"]

{"sheet":"Blanko-Druckversion sw","index":1,"n_rows":159,"n_cols":11,"rows_kept":159,"cut":false,"hidden":false,"merged":[[6,1,8,1],[34,1,36,1],[62,1,64,1],[95,1,97,1],[119,1,121,1]],"flags":["formulas_cached_only"]}
[]
[null,"Szenario Wareneinsatz in Rezepten",{"$nulls":6},"MKQ"]
[null,null,"<< herzustellende Menge"]
[]
[]
[]
[null,1,"Suppe"]
[null,null,null,"Rezeptur für","Einheit","Herzustellende Menge:"]
[null,null,null,"30 Portionen","kg, l, …",0,"Einzelpreis","Summe",null,"Kommentar"]
[{"$nulls":4},"kg, l, …"]
[]
[]
[{"$nulls":10},"© 2022"]
[]
[]
[]
[]
[]
[]
[null,null,"Summe"]
[null,null,"Gewürzzuschlag 3%"]
[null,null,"Summe"]
[null,null,"Portionspreis"]
[]
[null,null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[null,2,"Salate"]
[null,null,null,"Rezeptur für","Einheit","Herzustellende Menge:"]
[null,null,null,"30 Portionen","kg, l, …",null,"Einzelpreis","Summe",null,"Kommentar"]
{"$rows_empty":10}
[null,null,"Summe"]
[null,null,"Gewürzzuschlag 15%"]
[null,null,"Summe"]
[null,null,"Portionspreis"]
[]
[null,null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[null,3,"Hauptspeise"]
[null,null,null,"Rezeptur für","Einheit","Herzustellende Menge:"]
[null,null,null,"30 Portionen","kg, l, …",null,"Einzelpreis","Summe",null,"Kommentar"]
{"$rows_empty":15}
[null,null,"Summe",0,"kg, l, …"]
[null,null,"zzgl. Gewürzzuschlag 10%"]
[null,null,"Summe"]
[null,null,"Portionspreis"]
[]
[null,null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[null,4,"Dessert"]
[null,null,null,"Rezeptur für","Einheit","Herzustellende Menge"]
[null,null,null,"30 Portionen","kg, l, …",null,"Einzelpreis","Summe",null,"Kommentar"]
[]
[]
[]
[]
[]
[]
[null,null,"Summe"]
[]
[]
[null,null,"Portionspreis"]
[]
[null,null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[null,5,"Kaffee"]
[null,null,null,"Rezeptur für","Einheit","Herzustellende Menge"]
[null,null,null,"30 Portionen","kg, l, …",null,"Einzelpreis","Summe",null,"Kommentar"]
[]
[]
[]
[]
[]
[]
[null,null,"Summe"]
[]
[]
[null,null,"Portionspreis"]
[]
[null,null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":7}
[null,"SUMMEN"]
[]
[]
[null,"Suppe"]
[null,"Salat"]
[null,"Hauptspeise"]
[null,"Dessert"]
[null,"Kaffee"]
[]
[null,"Gesamt"]
[]
[{"$nulls":8},"© esscooltur 2022"]
[]
[]
[null,"VK (netto)="]
[]
[null,"MKQ"]
[null,"Materialkostenquote = Gesamtmaterialeinsatz (netto) geteilt durch Verkaufspreis (netto)"]

{"sheet":"Beispiel (nicht bearbeitbar)","index":2,"n_rows":158,"n_cols":9,"rows_kept":158,"cut":false,"hidden":false,"merged":[[5,0,7,0],[33,0,35,0],[61,0,63,0],[95,0,97,0],[119,0,121,0],[86,1,86,8],[85,1,85,8],[52,1,52,8]],"flags":["formulas_cached_only"]}
["Beispiel-Szenario für 500 Portionen",{"$nulls":6},"MKQ",0.3073078947368421]
[500,"Herzustellende Menge"]
[]
[]
[]
[1,"Suppe"]
[null,"Möhrencreme-Suppe","Rezeptur für","Einheit","Herzustellende Menge:"]
[null,"125 ml - alle Zutaten bio","30 Portionen","kg, l, …",500,"Einzelpreis","Summe",null,"Kommentar"]
[null,"Vollkornweizenmehl",0.1,"kg, l, …",1.666666666666667,1.2,2.0000000000000004,null,"frisch mahlen"]
[null,"Sonnenblumenöl",0.1,"kg, l, …",1.666666666666667,2.2,3.6666666666666674]
[null,"Möhren ",1,"kg, l, …",16.666666666666668,1.5,25,null,"Aue-Hof"]
[null,"Milch, 3,8% frisch",1,"kg, l, …",16.666666666666668,1.25,20.833333333333336,null,"vegan: Kokosmilch"]
[null,"Wasser",1.5,"kg, l, …",25,0,0]
[null,"Blattpetersilie",1,"Bund",16.666666666666668,1.5,25]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},76.5]
[null,"Gewürzzuschlag 3%",{"$nulls":4},2.295]
[null,"Summe",{"$nulls":4},78.795]
[null,"Portionspreis",{"$nulls":4},0.15759]
[]
[null,"Anmerkungen zur Herstellung:"]
[null,"Helle Roux herstellen, mit Gemüsefond ablöschen, abbinden lassen, Möhren weichkochen, pürieren, Milch hinzufügen, bis die Konsistenz stimmt, auf 65°C erhitzen"]
[null,"Gewürze: Salz, Pfeffer, Ingwer, Gemüsebrühe"]
[null,"Topping: Geröstete Ölsaaten"]
[]
[]
[]
[]
[]
[]
[2,"Salate"]
[null,"Chinakohl-Salat","Rezeptur für","Einheit","Herzustellende Menge:"]
[null,"100 g","30 Portionen","kg, l, …",500,"Einzelpreis","Summe",null,"Kommentar"]
[null,"Chinakohl ",2,"kg, l, …",33.333333333333336,2.3,76.66666666666667]
[null,"Äpfel, Elstar",0.8,"kg, l, …",13.333333333333336,1.6,21.33333333333334]
[null,"Rosinen",0.2,"kg, l, …",3.333333333333334,4.5,15.000000000000004]
[null,"Joghurt 3,8%",0.2,"kg, l, …",3.333333333333334,2.1,7.000000000000002,null,"vegan: Orangensaft"]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},120.00000000000001]
[null,"Gewürzzuschlag 15%",{"$nulls":4},18]
[null,"Summe",{"$nulls":4},138]
[null,"Portionspreis",{"$nulls":4},0.276]
[]
[null,"Anmerkungen zur Herstellung:"]
[null,"Rosinen über Nacht in Apfelsaft einweichen"]
{"$rows_empty":8}
[3,"Hauptspeise"]
[null,"Kürbis-Frikadellen (180g), Meerrettichsauce (50g)","Rezeptur für","Einheit","Herzustellende Menge:"]
[null,"Pellkartoffeln (180g)","30 Portionen","kg, l, …",500,"Einzelpreis","Summe",null,"Kommentar"]
[null,"Hokkaido-Kürbis",2,"kg, l, …",33.333333333333336,1.35,45.00000000000001]
[null,"Zwiebeln",1.5,"kg, l, …",25,1.5,37.5]
[null,"Haferflocken",0.5,"kg, l, …",8.333333333333334,1.8,15.000000000000002]
[null,"Wasser",0.5,"kg, l, …",8.333333333333334,0,0]
[{"$nulls":4},0,null,0]
[null,"Vollkornweizenmehl",0.06,"kg, l, …",1,1.2,1.2]
[null,"Sonnenblumenöl",0.06,"kg, l, …",1,2.2,2.2]
[null,"Meerrettich frisch",0.1,"kg, l, …",1.666666666666667,9.5,15.833333333333336]
[null,"Milch 3,8% frisch",0.6,"kg, l, …",10,1.25,12.5,null,"vegan: Sojamilch"]
[null,"Wasser",0.7,"kg, l, …",11.666666666666666,0,0]
[null,"Sahne",0.015,"kg, l, …",0.25,6,1.5,null,"vegan: Hafersahne "]
[{"$nulls":4},0,null,0]
[null,"Kartoffeln Anuschka",6,"kg, l, …",100,1.32,132]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",14.035,"kg, l, …",null,null,262.73333333333335]
[null,"zzgl. Gewürzzuschlag 10%",{"$nulls":4},26.273333333333337]
[null,"Summe",{"$nulls":4},289.00666666666666]
[null,"Portionspreis",{"$nulls":4},0.5780133333333333]
[]
[null,"Anmerkungen zur Herstellung:"]
[null,"1. Kürbis reiben, Zwiebeln würfeln. \nGewürze:Knoblauch, Senf, Petersilie, Salz, Pfeffer"]
[null,"2. Helle Roux herstellen, mit Wasser ablöschen, abbinden lassen, Möhren weichkochen, pürieren, Milch hinzufügen, bis die Konsistenz stimmt, auf 65°C erhitzen. \nMeerettich reiben."]
[null,"3. Kartoffeln mit Schale servieren"]
{"$rows_empty":7}
[4,"Dessert"]
[null,"Mandarinen (100g)","Rezeptur für","Einheit","Herzustellende Menge"]
[null,null,"30 Portionen","kg, l, …",500,"Einzelpreis","Summe",null,"Kommentar"]
[null,"Mandarinen (100g)",3,"kg, l, …",50,2.3,114.99999999999999,null,"Clementinen kaufen"]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},114.99999999999999]
[]
[]
[null,"Portionspreis",{"$nulls":4},0.22999999999999998]
[]
[null,"Anmerkungen zur Herstellung:"]
{"$rows_empty":9}
[5,"Abschluß (z.B. Kaffee, Tee, Gebäck)"]
[null,null,"Rezeptur für","Einheit","Herzustellende Menge"]
[null,"(150 ml/Portion)","30 Portionen","kg, l, …",500,"Einzelpreis","Summe",null,"Kommentar"]
[null,"Kaffeepulver, gemahlen",0.2,"kg, l, …",3.333333333333334,19,63.33333333333334,null,"Lieferant: Utamtsi"]
[null,"Rohrohrzucker Kristallino",0.1,"kg, l, …",1.666666666666667,6,10.000000000000002]
[null,"3,8% Vollmilch",0.3,"kg, l, …",5,0.95,4.75]
[null,"Wasser",5,"kg, l, …",83.33333333333334,0,0]
[{"$nulls":4},0,null,0]
[{"$nulls":4},0,null,0]
[null,"Summe",{"$nulls":4},78.08333333333334]
[]
[]
[null,"Portionspreis",{"$nulls":4},0.15616666666666668]
[]
[null,"Anmerkungen zur Herstellung:"]
[null,"Kaffee von Hand aufbrühen mit 93°C"]
[]
[]
[]
[]
[]
[]
["SUMMEN"]
[]
[]
["Suppe",0.15759]
["Salat",0.276]
["Hauptspeise",0.5780133333333333]
["Dessert"]
["Kaffee",0.15616666666666668]
[]
["Gesamt",1.16777]
[]
[{"$nulls":4},"© esscooltur 2022"]
[]
[]
["VK (netto)=",3.8]
[]
["MKQ",0.3073078947368421,"Materialkostenquote = Gesamtmaterialeinsatz (netto) geteilt durch Verkaufspreis (netto)"]

{"sheet":"Bedienungsanleitung","index":3,"n_rows":80,"n_cols":4,"rows_kept":80,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"0. ","Bei dieser Datei handelt es sich um ein Werkzeug für die professionelle Küche. Sie können hier Ihre Grund-Rezepturen in fünf verschiedenen Gruppen (Suppen, Salate, Hauptspeise, Dessert, Kaffee) eingeben und für eine frei wählbare Gästeanzahl skalieren. Außerdem können Sie die Wareneinstandskosten für einzelne Mahlzeiten ausrechenen."]
[null,"1.","Geben Sie zunächst die Anzahl an Portionen an, für die Sie Ihr Rezept kochen möchten:"]
[]
[]
[]
[]
[]
[null,"2.a","Im nächsten Schritt geben Sie Ihre Rezeptur für 30 Personen und die Netto-Preise aus Ihren Ordersätzen ein. Kleinstmengen für Gewürze können Sie weglassen, da diese am Ende pauschal errechnet werden."]
[]
[null,null,null,"© 2022"]
{"$rows_empty":9}
[null,"2.b","Die herzustellende Menge errechnet Excel automatisch - diese Felder sind gesperrt."]
[null,"2.c","In die Kommentarspalte können Sie eigenen Text eintragen (z.B. Lieferant, Bestellfristen o.ä.)"]
[]
[]
[]
[]
[]
[null,"2.d","Hier können Sie Herstellungsanweisungen hinterlegen:"]
{"$rows_empty":9}
[null,"3.","Die Exceltabelle errechnet laufend die Summen, den Gewürzzuschlag und den Portionspreis"]
[]
[]
[]
[]
[]
[null,"4.","Eine fertig ausgefüllte Gruppe könnte so aussehen:"]
{"$rows_empty":12}
[null,"5.","Am Ende der Tabelle finden Sie die Gesamtkalkulation. Wenn Sie den Netto-Verkaufspreis eintragen, errechnet Ihnen Excel die Materialkostenquote (MKQ)"]
{"$rows_empty":19}
[null,"6.","Sie können diese Kalkulationen abspeichern und sich so eine eigene Datenbank aufbauen."]
[null,"7.","Für handschriftliche Bearbeitung gibt es eine schwarz-weiß-Druckversion in einem gesonderten Tabellenblatt."]

{"sheet":"Impressum","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[null,"© esscooltur 2022 (Michael Thun, Bremen)"]
{"$rows_empty":7}
[null,"Alle Rechte vorbehalten - jede Haftung ausgeschlossen"]
[null,"Nutzung für Unterrichtszwecke unter Angabe des Copyrights gestattet"]