{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Ins","Inf","Instructions","Inventory","Info","Recipe Template (1)","Recipe Template (2)","Recipe Template (3)","Example 1","Example 2","Recipe Template"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"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":"Ins","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":true,"merged":[[2,3,2,7]]}
[]
[]
[null,null,null,"Recipe Costing Tool"]
[]
[]
[]
[null,"1.  When ready to use this tool, please begin by completely filling out the information requested on the \"Info\" tab."]
[]
[null,"2.  Press \"Create Template\" button and the recipe templates will appear at the bottom of the screen."]
[]
[null,"3.  Input your recipe data into the appropriate shaded area on the template.  If you desire a printed copy press \"Print\""]
[]
[null,"4.  Additional templates may be added, simplely go back to the \"Info\" tab and press \"Create Templates\"."]
[]
[null,"Terms used in this tool:"]
[null,null,"AP$/Unit","As purchased cost per ingredient unit listed to the right under"]
[null,null,null,"the unit column."]
[null,null,"Unit","Measurement used in recipe for production."]
[null,null,"Yield %","During production certain items incur a lose (waste) this reflects"]
[null,null,null,"the usable portion that remains. Please refer to the table of common yields."]
[null,null,"EP$/Unit","Edible purchase cost per ingredient unit as reflected after calculations of yields."]
[]
[]
["Contact if you have any question or comments:"]
[]
[null,null,null,null,null,null,"Regional Executive Chef Bill Williams"]
[null,null,null,null,null,null,"Eurest, Pacific Northwest Region and Microsoft"]
[null,null,null,null,null,null,"One Microsoft Way 112/1041 Redmond, WA  98052"]
[null,null,null,null,null,null,"Tel:  (425) 703-3835    Fax:  (425) 936-7329"]

{"sheet":"Inf","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[[3,1,3,2],[1,1,1,9]]}
[]
[null,"Please completely answer all questions below. Place your answers in the shaded boxes. Click on \"Create\" button at the bottom of page."]
[]
[null,"Tax Rate",null,null,9.7699999999999995E-2]
[]
[null,null,null,null,null,null,"(Y or N)"]
[null,"Do your Prices include tax?",null,null,null,null,"y"]
[]
[]
[null,"Budgeted Product Cost",null,null,null,null,0.45]
[]
[]
[null,"# of blank forms in this file? ",null,null,null,null,1]

{"sheet":"Instructions","index":2,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Recipe Costing Tool"]
[]
[null,null,"1.  When ready to use this tool, please begin by completely filling out the information requested on the \"Info\" tab."]
[]
[null,null,"2.  Press \"Create Template\" button and the recipe templates will appear at the bottom of the screen."]
[]
[null,null,"3.  Input your recipe data into the appropriate shaded area on the template.  If you desire a printed copy press \"Print\""]
[]
[null,null,"4.  Additional templates may be added, simplely go back to the \"Info\" tab and press \"Create Templates\"."]
[]
[null,null,"5. Use the \"Inventory\" tab to link all your recipes to your inventory. Simply update pricing on the \"Inventory\" tab to update all recipes."]
[]
[null,null,"Terms used in this tool:"]
[]
[null,"AP$/Unit","As purchased cost per ingredient unit listed to the right under"]
[null,null,"the unit column."]
[]
[null,"Unit","Measurement used in recipe for production."]
[]
[null,"Yield %","During production certain items incur a lose (waste) this reflects the usable portion that remains. Please refer to the table of common yields."]
[]
[null,"EP$/Unit","Edible purchase cost per ingredient unit as reflected after calculations of yields."]
[]
[null,null,"Created by Chef William Williams."]
[null,null," Chef William Williams"]
[null,null,"bwilliams61@frontier.com "]
[]
[null,null,"Modified by Chefs-Resources.com"]
[null,null,"Send Suggestions for improvement or bug fixes to:"]
[null,null,"Chef David Buchanan at Chef's-Resources.com"]
[null,null,"chefs-resources@msn.com"]
[]
[null,null,"This file cannot be used or sold as  a means of generating revenue without prior permission in writing."]

{"sheet":"Inventory","index":3,"n_rows":697,"n_cols":15,"rows_kept":697,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["Restaurant Name"]
["Last Update","Storage\n Area","Item",null,"Unit","Price","Unit","Price","Unit","Price","Unit","Price","Unit","Price","Notes"]
[null,"Beverages","AQUAFINA WATER - 20 OZ - 24/CASE",null,"Case",9.25,"Btl",{"$f":"F3/24","v":0.38541666666666669}]
[null,"Beverages","BAG IN THE BOX COKE",null,"Gal",8.2799999999999994]
[null,"Beverages","COFFEE DECAF 36/CASE",null,"Case",39.700000000000003,"Bag",{"$f":"F5/36","v":1.1027777777777779},"Cup",{"$f":"H5/10","v":0.11027777777777778}]
[null,"Beverages","COFFEE REGULAR 36/CASE",null,"Case",77.28,"Bag",{"$f":"F6/36","v":2.1466666666666665},"Cup",{"$f":"H6/10","v":0.21466666666666664}]
[null,"Beverages","COKE 20 OZ - 24/CASE",null,"Case",10.8,"Btl",{"$f":"F7/24","v":0.45}]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Beverages"]
[null,"Bread","12 Grain",null,"Pkg",1.1000000000000001,"Each",{"$f":"F54/16","v":6.8750000000000006E-2}]
[null,"Bread","3x5's   6 ct",null,"Pkg",1.25,"Each",{"$f":"F55/6","v":0.20833333333333334}]
[null,"Bread","Buns Onion ",null,"Pkg",2,"Each",{"$f":"F56/8","v":0.25}]
[null,"Bread","Buns Sesame 12 ct",null,"Pkg",1.1000000000000001,"Each",{"$f":"F57/12","v":9.1666666666666674E-2}]
[null,"Bread","Ciabatta 6 ct",null,"Pkg",2.81,"Each",{"$f":"F58/6","v":0.46833333333333332}]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Bread"]
[null,"Cooler","BASE CHICKEN 6/CASE",null,"Case",29.94,"Lb",{"$f":"F83/6","v":4.99},"Oz",{"$f":"H83/16","v":0.31187500000000001},"Tbl",{"$f":"J83/2","v":0.15593750000000001},"Tsp",{"$f":"L83/3","v":5.1979166666666667E-2}]
[null,"Cooler","Bratwurst Pauxent 10lb/cs  4/1",null,"Case",24.95,"Lb",{"$f":"F84/10","v":2.4950000000000001},"Each",{"$f":"H84/4","v":0.62375000000000003}]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler"]
[null,"Cooler Dairy","EGGS WHOLE MEDIUM ",null,"Case",11.19,"Each",{"$f":"F188/15/12","v":6.2166666666666669E-2}]
[null,"Cooler Dairy","CHEESE SWISS 4/5 Lb  160 slice",null,"Case",39.07,"Lb",{"$f":"F189/4/5","v":1.9535},"Slice",{"$f":"H189/16/0.75","v":0.16279166666666667}]
[null,"Cooler Dairy","Heavy Cream  6/64z",null,"Case",36.479999999999997,"Each",{"$f":"F190/6","v":6.0799999999999992},"FlOz",{"$f":"H190/64","v":9.4999999999999987E-2}]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Dairy"]
[null,"Cooler Produce","Garlic Chopped 6/48 oz",null,"Case",23.41,"Each",{"$f":"F218/6","v":3.9016666666666668},"Oz",{"$f":"H218/48","v":8.128472222222223E-2}]
[null,"Cooler Produce","Onion Diced 5 lb",null,"Bag",5.27,"Lb",{"$f":"F219/5","v":1.0539999999999998},"Oz",{"$f":"H219/16","v":6.5874999999999989E-2}]
[null,"Cooler Produce","Onion White Peeled  20 lb/Cs",null,"Case",14.25,"Lb",{"$f":"F220/20","v":0.71250000000000002},"Oz",{"$f":"H220/16","v":4.4531250000000001E-2}]
[null,"Cooler Produce","Tomato",null,"Lb",{"$f":"14.5/25","v":0.57999999999999996},"Each",{"$f":"14.5/60","v":0.24166666666666667},"Slice",{"$f":"H221/7","v":3.4523809523809526E-2}]
[null,"Cooler Produce","Spring Mix 3 lb",null,"Case",11.11,"Lb",{"$f":"F222/3","v":3.7033333333333331},"Oz",{"$f":"H222/16","v":0.23145833333333332}]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Cooler Produce"]
[null,"Desserts","Brownie Walnut",null,"Case",42,"Tray",{"$f":"F272/8","v":5.25},"Each",{"$f":"H272/8","v":0.65625}]
[null,"Desserts","COOKIE DOUGH  2.25 oz   120/cs",null,"Case",44.04,"Each",{"$f":"F273/120","v":0.36699999999999999}]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Desserts"]
[null,"Freezer","Bacon Sliced Bulk 18/22 Ct",null,"Case",33.35,"Lb",{"$f":"F304/15","v":2.2233333333333336},"Slice",{"$f":"H304/19","v":0.11701754385964913}]
[null,"Freezer","Corn IQF  6/4 Lb",null,"Case",16.02,"Lb",{"$f":"F305/6/4","v":0.66749999999999998},"Oz",{"$f":"H305/16","v":4.1718749999999999E-2}]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer","Fries Wedge Fries- 30 Lb",null,"Case",21,null,null,"Oz",{"$f":"F340/30/16","v":4.3749999999999997E-2}]
[null,"Freezer","Fries Straight Cut  ",null,"Case",14.19,"Bag",{"$f":"F341/6","v":2.3649999999999998},"Oz",{"$f":"H341/5/16","v":2.9562499999999999E-2}]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer"]
[null,"Freezer Beef","Hamburgers 2/1"]
[null,"Freezer Beef","Veal Bones"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Beef"]
[null,"Freezer Seafood","SHRIMP 26/30 Brd Tail off 8/3Lb/Cs",null,"Case",86.88,"Box",{"$f":"F376/8","v":10.86},"Each",{"$f":"H376/3/27","v":0.13407407407407407}]
[null,"Freezer Seafood","Shrimp 13/15 White 6/3 lb/Cs"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Freezer Seafood"]
[null,"Paper","AU BOB PAN 12 OZ.  20/60 ct",null,"Case",50.54,"Slv",{"$f":"F420/20","v":2.5270000000000001},"Each",{"$f":"H420/60","v":4.211666666666667E-2}]
[null,"Paper","AU BOB PAN 16 OZ.  20/25 ct",null,"Case",29.43,"Slv",{"$f":"F421/20","v":1.4715},"Each",{"$f":"H421/25","v":5.8860000000000003E-2}]
[null,"Paper ","SOUP CUP 12 OZ   500 Ct",null,"Case",13.29,null,null,"Each",{"$f":"F422/500","v":2.6579999999999999E-2}]
[null,"Paper ","SOUP CUP 16 OZ   500 Ct",null,"Case",14.82,null,null,"Each",{"$f":"F423/500","v":2.964E-2}]
[null,"Paper ","SOUP CUP 8 OZ  500 Ct",null,"Case",11.01,null,null,"Each",{"$f":"F424/500","v":2.2019999999999998E-2}]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Paper "]
[null,"Pasta"]
[null,"Pasta"]
[null,"Pasta"]
[null,"Pasta"]
[null,"Pasta"]
[null,"Pasta"]
[null,"Pasta"]
[null,"Pasta"]
[null,"Snack","Mints"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Storeroom","Oil Olive Oil/Canola Blend 6/Cs",null,"Case",51.95,"Gal",{"$f":"F461/6","v":8.6583333333333332},"Oz",{"$f":"H461/128","v":6.7643229166666666E-2}]
[null,"Storeroom","Panco-Bread Crumbs 20 Lb",null,"Bag",17.329999999999998,"Lb",{"$f":"F462/20","v":0.86649999999999994},"Oz",{"$f":"H462/16","v":5.4156249999999996E-2}]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]
[null,"Storeroom"]

{"sheet":"Info","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,1,3,2],[1,1,1,9],[3,11,6,18]]}
[]
[null,"Please completely answer all questions below. Place your answers in the shaded boxes. Click on \"Create\" button at the bottom of page."]
[]
[null,"Tax Rate",null,null,8.7999999999999995E-2,null,null,null,null,null,null,"To unprotect the sheet click on:\nFormat (on the right side of the toolbar above)\nselect \"unprotect sheet\""]
[]
[null,null,null,null,null,null,"(Y or N)"]
[null,"Do your Prices include tax?",null,null,null,null,"n"]
[]
[]
[null,"Budgeted Product Cost",null,null,null,null,0.4]
[]
[]
[null,"# of blank forms in this file? ",null,null,null,null,1]

{"sheet":"Recipe Template (1)","index":5,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,0,0,8],[1,7,1,8],[2,1,2,8],[3,1,3,5],[3,7,3,8],[4,1,4,5],[4,7,4,8],[5,4,5,5],[5,6,5,8],[6,4,6,5],[6,6,6,8],[7,3,7,4],[47,0,47,8],[9,0,9,8],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,7,10,8],[12,1,12,3],[12,4,12,7],[42,0,42,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[59,0,59,8],[48,0,48,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,0,56,8],[57,0,57,8],[58,0,58,8]]}
["Culinary Department Recipe Costing Tool"]
[null,null,null,null,null,null,"Date:"]
["Recipe name:"]
["Concept:",null,null,null,null,null,"Cuisine:"]
["Submitted by:",null,null,null,null,null,"Category:"]
["Number of Portions: 1 or 24",1,null,null,"Operation:"]
["Serving Size Per Person:",null,null,null,"Region:"]
[{"$f":"IF(Gross_or_Not=\"y\",\"Purposed Net Selling Price\",\"Purposed Gross Selling Price\")","v":"Purposed Gross Selling Price"},1,null,{"$f":"IF(Gross_or_Not=\"y\",\"Ideal Net Selling Price\",\"Ideal Gross Selling Price\")","v":"Ideal Gross Selling Price"},{"$f":"IF(Gross_or_Not=\"y\",\"Net Selling Price\",\"Gross Selling Price\")","v":"Gross Selling Price"},null,"Cost per Portion:",null,{"$f":"IF(I9=0, ,I9/B6)","v":0}]
["Projected FC%",{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I9/B6)/(B8/(1+Tax_Rate))),(I9/B6)/(B8))))","v":0},null,{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I8/Info!G10+(('Recipe Template (1)'!I8/Info!G10)*Tax_Rate))),('Recipe Template (1)'!I8/Info!G10))))","v":0},{"$f":"IF(L9=0,,(IF(Gross_or_Not=\"y\",((L9/E6)/(E8/(1+Tax_Rate))),(L9/E6)/(E8))))","v":0},null,"Cost per Recipe:",null,{"$f":"SUM(I15:I41)","v":0}]
["EP = Edible Portion    AP$ = As Purchased cost   EP$ = Edible Portion Cost    Unit = unit of measure for ingredients"]
["For common Yields use these tools:",null,"Produce Yields",null,"Fruit Yields",null,"Fish Yields","Spice Yields"]
[]
[null,"Recipe Quantity (EP)",null,null,"Costing",null,null,null,"Total"]
["Ingredients","Quantity","Weight","Volume","AP$ / Unit","Unit","Yield %","EP$ / Unit","Cost"]
[null,null,null,null,null,{"$f":"IF(B15>0,IF(C15<>\"\",C15,D15),\"\")","v":""},null,{"$f":"IF(G15>0,E15+(E15*(1-G15)),\"\")","v":""},{"$f":"IF(E15>0,(B15*H15),\" \")","v":" "}]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
["Method:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This file cannot be used or sold as  a means of generating revenue without prior permission in writing."]

{"sheet":"Recipe Template (2)","index":6,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,0,0,8],[1,7,1,8],[2,1,2,8],[3,1,3,5],[3,7,3,8],[4,1,4,5],[4,7,4,8],[5,4,5,5],[5,6,5,8],[6,4,6,5],[6,6,6,8],[7,3,7,4],[47,0,47,8],[9,0,9,8],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,7,10,8],[12,1,12,3],[12,4,12,7],[42,0,42,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[59,0,59,8],[48,0,48,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,0,56,8],[57,0,57,8],[58,0,58,8]]}
["Culinary Department Recipe Costing Tool"]
[null,null,null,null,null,null,"Date:"]
["Recipe name:"]
["Concept:",null,null,null,null,null,"Cuisine:"]
["Submitted by:",null,null,null,null,null,"Category:"]
["Number of Portions: 1 or 24",1,null,null,"Operation:"]
["Serving Size Per Person:",null,null,null,"Region:"]
[{"$f":"IF(Gross_or_Not=\"y\",\"Purposed Net Selling Price\",\"Purposed Gross Selling Price\")","v":"Purposed Gross Selling Price"},1,null,{"$f":"IF(Gross_or_Not=\"y\",\"Ideal Net Selling Price\",\"Ideal Gross Selling Price\")","v":"Ideal Gross Selling Price"},{"$f":"IF(Gross_or_Not=\"y\",\"Net Selling Price\",\"Gross Selling Price\")","v":"Gross Selling Price"},null,"Cost per Portion:",null,{"$f":"IF(I9=0, ,I9/B6)","v":0}]
["Projected FC%",{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I9/B6)/(B8/(1+Tax_Rate))),(I9/B6)/(B8))))","v":0},null,{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I8/Info!G10+(('Recipe Template (2)'!I8/Info!G10)*Tax_Rate))),('Recipe Template (2)'!I8/Info!G10))))","v":0},{"$f":"IF(L9=0,,(IF(Gross_or_Not=\"y\",((L9/E6)/(E8/(1+Tax_Rate))),(L9/E6)/(E8))))","v":0},null,"Cost per Recipe:",null,{"$f":"SUM(I15:I41)","v":0}]
["EP = Edible Portion    AP$ = As Purchased cost   EP$ = Edible Portion Cost    Unit = unit of measure for ingredients"]
["For common Yields use these tools:",null,"Produce Yields",null,"Fruit Yields",null,"Fish Yields","Spice Yields"]
[]
[null,"Recipe Quantity (EP)",null,null,"Costing",null,null,null,"Total"]
["Ingredients","Quantity","Weight","Volume","AP$ / Unit","Unit","Yield %","EP$ / Unit","Cost"]
[null,null,null,null,null,{"$f":"IF(B15>0,IF(C15<>\"\",C15,D15),\"\")","v":""},null,{"$f":"IF(G15>0,E15+(E15*(1-G15)),\"\")","v":""},{"$f":"IF(E15>0,(B15*H15),\" \")","v":" "}]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
["Method:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This file cannot be used or sold as  a means of generating revenue without prior permission in writing."]

{"sheet":"Recipe Template (3)","index":7,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,0,0,8],[1,7,1,8],[2,1,2,8],[3,1,3,5],[3,7,3,8],[4,1,4,5],[4,7,4,8],[5,4,5,5],[5,6,5,8],[6,4,6,5],[6,6,6,8],[7,3,7,4],[47,0,47,8],[9,0,9,8],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,7,10,8],[12,1,12,3],[12,4,12,7],[42,0,42,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[59,0,59,8],[48,0,48,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,0,56,8],[57,0,57,8],[58,0,58,8]]}
["Culinary Department Recipe Costing Tool"]
[null,null,null,null,null,null,"Date:"]
["Recipe name:"]
["Concept:",null,null,null,null,null,"Cuisine:"]
["Submitted by:",null,null,null,null,null,"Category:"]
["Number of Portions: 1 or 24",1,null,null,"Operation:"]
["Serving Size Per Person:",null,null,null,"Region:"]
[{"$f":"IF(Gross_or_Not=\"y\",\"Purposed Net Selling Price\",\"Purposed Gross Selling Price\")","v":"Purposed Gross Selling Price"},1,null,{"$f":"IF(Gross_or_Not=\"y\",\"Ideal Net Selling Price\",\"Ideal Gross Selling Price\")","v":"Ideal Gross Selling Price"},{"$f":"IF(Gross_or_Not=\"y\",\"Net Selling Price\",\"Gross Selling Price\")","v":"Gross Selling Price"},null,"Cost per Portion:",null,{"$f":"IF(I9=0, ,I9/B6)","v":0}]
["Projected FC%",{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I9/B6)/(B8/(1+Tax_Rate))),(I9/B6)/(B8))))","v":0},null,{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I8/Info!G10+(('Recipe Template (3)'!I8/Info!G10)*Tax_Rate))),('Recipe Template (3)'!I8/Info!G10))))","v":0},{"$f":"IF(L9=0,,(IF(Gross_or_Not=\"y\",((L9/E6)/(E8/(1+Tax_Rate))),(L9/E6)/(E8))))","v":0},null,"Cost per Recipe:",null,{"$f":"SUM(I15:I41)","v":0}]
["EP = Edible Portion    AP$ = As Purchased cost   EP$ = Edible Portion Cost    Unit = unit of measure for ingredients"]
["For common Yields use these tools:",null,"Produce Yields",null,"Fruit Yields",null,"Fish Yields","Spice Yields"]
[]
[null,"Recipe Quantity (EP)",null,null,"Costing",null,null,null,"Total"]
["Ingredients","Quantity","Weight","Volume","AP$ / Unit","Unit","Yield %","EP$ / Unit","Cost"]
[null,null,null,null,null,{"$f":"IF(B15>0,IF(C15<>\"\",C15,D15),\"\")","v":""},null,{"$f":"IF(G15>0,E15+(E15*(1-G15)),\"\")","v":""},{"$f":"IF(E15>0,(B15*H15),\" \")","v":" "}]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
["Method:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This file cannot be used or sold as  a means of generating revenue without prior permission in writing."]

{"sheet":"Example 1","index":8,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,0,0,8],[1,7,1,8],[2,1,2,8],[3,1,3,5],[3,7,3,8],[4,1,4,5],[4,7,4,8],[5,4,5,5],[5,6,5,8],[6,4,6,5],[6,6,6,8],[7,3,7,4],[47,0,47,8],[9,0,9,8],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,7,10,8],[12,1,12,3],[12,4,12,7],[42,0,42,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[59,0,59,8],[48,0,48,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,0,56,8],[57,0,57,8],[58,0,58,8]]}
["Culinary Department Recipe Costing Tool"]
[null,null,null,null,null,null,"Date:"]
["Recipe name:","Crab Salad"]
["Concept:",null,null,null,null,null,"Cuisine:"]
["Submitted by:",null,null,null,null,null,"Category:"]
["Number of Portions: 1 or 24",10,null,null,"Operation:"]
["Serving Size Per Person:","3 oz",null,null,"Region:"]
[{"$f":"IF(Gross_or_Not=\"y\",\"Purposed Net Selling Price\",\"Purposed Gross Selling Price\")","v":"Purposed Gross Selling Price"},5,null,{"$f":"IF(Gross_or_Not=\"y\",\"Ideal Net Selling Price\",\"Ideal Gross Selling Price\")","v":"Ideal Gross Selling Price"},{"$f":"IF(Gross_or_Not=\"y\",\"Net Selling Price\",\"Gross Selling Price\")","v":"Gross Selling Price"},null,"Cost per Portion:",null,{"$f":"IF(I9=0, ,I9/B6)","v":1.9449565625000005}]
["Projected FC%",{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I9/B6)/(B8/(1+Tax_Rate))),(I9/B6)/(B8))))","v":0.38899131250000007},null,{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I8/Info!G10+(('Example 1'!I8/Info!G10)*Tax_Rate))),('Example 1'!I8/Info!G10))))","v":4.8623914062500013},{"$f":"IF(L9=0,,(IF(Gross_or_Not=\"y\",((L9/E6)/(E8/(1+Tax_Rate))),(L9/E6)/(E8))))","v":0},null,"Cost per Recipe:",null,{"$f":"SUM(I15:I41)","v":19.449565625000005}]
["EP = Edible Portion    AP$ = As Purchased cost   EP$ = Edible Portion Cost    Unit = unit of measure for ingredients"]
["For common Yields use these tools:",null,"Produce Yields",null,"Fruit Yields",null,"Fish Yields","Spice Yields"]
[]
[null,"Recipe Quantity (EP)",null,null,"Costing",null,null,null,"Total"]
["Ingredients","Quantity","Weight","Volume","AP$ / Unit","Unit","Yield %","EP$ / Unit","Cost"]
["Dungeness Crab Meat",1,"Lb",null,16.850000000000001,{"$f":"IF(B15>0,IF(C15<>\"\",C15,D15),\"\")","v":"Lb"},0.99,{"$f":"IF(G15>0,E15+(E15*(1-G15)),\"\")","v":17.018500000000003},{"$f":"IF(E15>0,(B15*H15),\" \")","v":17.018500000000003}]
["Celery, diced",6,"Oz",null,{"$f":"0.18/16","v":1.125E-2},"Oz",0.75,1.4062499999999999E-2,8.4374999999999992E-2]
["Red Bell Pepper, bruniose",3,"Oz",null,{"$f":"3.87/16","v":0.24187500000000001},"Oz",0.65,0.32653125,0.97959375000000004]
["Yellow Bell Pepper, bruniose",3,"Oz",null,{"$f":"4.23/16","v":0.26437500000000003},"Oz",0.83,0.30931875000000003,0.92795625000000004]
["Fresh Tarragon",2,null,"Tbl",{"$f":"3.95/4/16","v":6.1718750000000003E-2},"Tbl",0.75,7.71484375E-2,0.154296875]
["Fresh Dill",1,null,"Tbl",{"$f":"4.08/4/16","v":6.3750000000000001E-2},"Tbl",0.75,7.9687499999999994E-2,7.9687499999999994E-2]
["Mayo",0.25,null,"Cup",{"$f":"39/3/128*8","v":0.8125},"Cup",0.99,0.82062500000000005,0.20515625000000001]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
["Method:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This file cannot be used or sold as  a means of generating revenue without prior permission in writing."]

{"sheet":"Example 2","index":9,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,3,8,4],[0,0,0,8],[1,7,1,8],[2,1,2,8],[3,1,3,5],[3,7,3,8],[4,1,4,5],[4,7,4,8],[5,4,5,5],[5,6,5,8],[6,4,6,5],[6,6,6,8],[7,3,7,4],[47,0,47,8],[9,0,9,8],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,7,10,8],[12,1,12,3],[12,4,12,7],[42,0,42,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[59,0,59,8],[48,0,48,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,0,56,8],[57,0,57,8],[58,0,58,8]]}
["Culinary Department Recipe Costing Tool"]
[null,null,null,null,null,null,"Date:"]
["Recipe name:","Grilled Salmon with Lemon Beurre Blanc"]
["Concept:",null,null,null,null,null,"Cuisine:"]
["Submitted by:",null,null,null,null,null,"Category:"]
["Number of Portions: 1 or 24",1,null,null,"Operation:"]
["Serving Size Per Person:",null,null,null,"Region:"]
[{"$f":"IF(Gross_or_Not=\"y\",\"Purposed Net Selling Price\",\"Purposed Gross Selling Price\")","v":"Purposed Gross Selling Price"},22,null,{"$f":"IF(Gross_or_Not=\"y\",\"Ideal Net Selling Price\",\"Ideal Gross Selling Price\")","v":"Ideal Gross Selling Price"},{"$f":"IF(Gross_or_Not=\"y\",\"Net Selling Price\",\"Gross Selling Price\")","v":"Gross Selling Price"},null,"Cost per Portion:",null,{"$f":"IF(I9=0, ,I9/B6)","v":8.4571375}]
["Projected FC%",{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I9/B6)/(B8/(1+Tax_Rate))),(I9/B6)/(B8))))","v":0.38441534090909091},null,{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I8/Info!G10+(('Example 2'!I8/Info!G10)*Tax_Rate))),('Example 2'!I8/Info!G10))))","v":21.142843749999997},{"$f":"IF(L9=0,,(IF(Gross_or_Not=\"y\",((L9/E6)/(E8/(1+Tax_Rate))),(L9/E6)/(E8))))","v":0},null,"Cost per Recipe:",null,{"$f":"SUM(I15:I41)","v":8.4571375}]
["EP = Edible Portion    AP$ = As Purchased cost   EP$ = Edible Portion Cost    Unit = unit of measure for ingredients"]
["For common Yields use these tools:",null,"Produce Yields",null,"Fruit Yields",null,"Fish Yields","Spice Yields"]
[]
[null,"Recipe Quantity (EP)",null,null,"Costing",null,null,null,"Total"]
["Ingredients","Quantity","Weight","Volume","AP$ / Unit","Unit","Yield %","EP$ / Unit","Cost"]
["Salmon Fillet, Skin/Off",7,"Oz",null,{"$f":"8.95/16","v":0.55937499999999996},{"$f":"IF(B15>0,IF(C15<>\"\",C15,D15),\"\")","v":"Oz"},0.9,{"$f":"IF(G15>0,E15+(E15*(1-G15)),\"\")","v":0.61531249999999993},{"$f":"IF(E15>0,(B15*H15),\" \")","v":4.3071874999999995}]
["Asparagus, trimmed",4,"Oz",null,{"$f":"4.95/16","v":0.30937500000000001},"Oz",0.54,0.45168750000000002,1.8067500000000001]
["Lemon Beurre Blanc",2,null,"Floz",0.61,"Floz",0.99,0.61609999999999998,1.2322]
["Roasted Red Potatoes",6,"Oz",null,0.08,"Oz",0.99,8.0799999999999997E-2,0.48480000000000001]
["Garnish",1,null,"Serv",0.09,"Serv",0.99,9.0899999999999995E-2,9.0899999999999995E-2]
[null,null,null,null,null,"",null,""," "]
["Rolls and Butter",1,null,"Serv",0.53,"Serv",0.99,0.5353,0.5353]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
["Method:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This file cannot be used or sold as  a means of generating revenue without prior permission in writing."]

{"sheet":"Recipe Template","index":10,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":true,"merged":[[59,0,59,8],[58,0,58,8],[5,6,5,8],[6,6,6,8],[54,0,54,8],[55,0,55,8],[49,0,49,8],[56,0,56,8],[57,0,57,8],[50,0,50,8],[53,0,53,8],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,7,10,8],[12,1,12,3],[0,0,0,8],[9,0,9,8],[7,3,7,4],[8,3,8,4],[1,7,1,8],[6,4,6,5],[3,7,3,8],[4,7,4,8],[2,1,2,8],[3,1,3,5],[4,1,4,5],[5,4,5,5],[12,4,12,7],[45,0,45,8],[46,0,46,8],[47,0,47,8],[51,0,51,8],[52,0,52,8],[42,0,42,8],[43,0,43,8],[44,0,44,8],[48,0,48,8]]}
["Culinary Department Recipe Costing Tool"]
[null,null,null,null,null,null,"Date:"]
["Recipe name:"]
["Concept:",null,null,null,null,null,"Cuisine:"]
["Submitted by:",null,null,null,null,null,"Category:"]
["Number of Portions: 1 or 24",1,null,null,"Operation:"]
["Serving Size Per Person:",null,null,null,"Region:"]
[{"$f":"IF(Gross_or_Not=\"y\",\"Purposed Net Selling Price\",\"Purposed Gross Selling Price\")","v":"Purposed Gross Selling Price"},1,null,{"$f":"IF(Gross_or_Not=\"y\",\"Ideal Net Selling Price\",\"Ideal Gross Selling Price\")","v":"Ideal Gross Selling Price"},{"$f":"IF(Gross_or_Not=\"y\",\"Net Selling Price\",\"Gross Selling Price\")","v":"Gross Selling Price"},null,"Cost per Portion:",null,{"$f":"IF(I9=0, ,I9/B6)","v":0}]
["Projected FC%",{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I9/B6)/(B8/(1+Tax_Rate))),(I9/B6)/(B8))))","v":0},null,{"$f":"IF(I9=0,,(IF(Gross_or_Not=\"y\",((I8/Info!G10+(('Recipe Template'!I8/Info!G10)*Tax_Rate))),('Recipe Template'!I8/Info!G10))))","v":0},{"$f":"IF(L9=0,,(IF(Gross_or_Not=\"y\",((L9/E6)/(E8/(1+Tax_Rate))),(L9/E6)/(E8))))","v":0},null,"Cost per Recipe:",null,{"$f":"SUM(I15:I41)","v":0}]
["EP = Edible Portion    AP$ = As Purchased cost   EP$ = Edible Portion Cost    Unit = unit of measure for ingredients"]
["For common Yields use these tools:",null,"Produce Yields",null,"Fruit Yields",null,"Fish Yields","Spice Yields"]
[]
[null,"Recipe Quantity (EP)",null,null,"Costing",null,null,null,"Total"]
["Ingredients","Quantity","Weight","Volume","AP$ / Unit","Unit","Yield %","EP$ / Unit","Cost"]
[null,null,null,null,null,{"$f":"IF(B15>0,IF(C15<>\"\",C15,D15),\"\")","v":""},null,{"$f":"IF(G15>0,E15+(E15*(1-G15)),\"\")","v":""},{"$f":"IF(E15>0,(B15*H15),\" \")","v":" "}]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
[null,null,null,null,null,"",null,""," "]
["Method:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This file cannot be used or sold as  a means of generating revenue without prior permission in writing."]