Conversions Excel Home Work_template_Current-1-1 (1)

Recipe Name: Chimichurri Sauce Serving size: 1 tbsp 8 Ingredients Amount Unit Olive Oil 0.50 cup red wine vinegar 2.00 tbsp parsely 0.50 cup garlic 4.00 cloves red chili 2.00 each dried oregano 0.75 tsp sea salt 1.00 tsp black pepper 0.50 tsp Yield: (# of servings)

Recipe Name: Balsamic Dressing Serving size: 2 tbsp 8 Bulk Cost Honey 2 tbsp 1.48 oz .74oz/tbsp $227.95 60 lb $3.7992 960 $0.2374 1.480 $0.3514 Dijon Mustard 1 tbsp 0.53 oz .53oz/tbsp 1 tbsp = .53oz $48.95 105 oz $0.4662 105 $0.4662 0.530 $0.2471 Salt 0.5 tsp .105 oz .21oz/tsp $19.99 120 oz $0.1666 120 $0.1666 0.105 $0.0175 Pepper 0.5 tsp .04 oz .08oz/tsp $31.99 80 oz $0.3999 80 $0.3999 0.040 $0.0160 Garlic, Fresh 1 clove 1 clove 1 clove = 1 clove $10.59 12 bulbs $0.8825 132 $0.0802 1.000 $0.0802 Olive Oil 0.75 cup 6 fl oz 8 fl oz = 1 cup $18.95 68 fl oz $0.2787 68 $0.2787 6.000 $1.6721 Balsamic Vinegar 0.25 cup 2 fl oz 8 fl oz = 1 cup $29.99 4 Liter $7.4975 135.26 $0.2217 2.000 $0.4434 $2.8277 Recipe Name: Chimichurri Sauce Serving size: 1 tbsp 8 Err:509 Bulk Cost parsley 0.50 cup 1.07oz 1.07oz=cup $ 221.00 10.00 lb $ 22.1000 garlic cloves 4 cloves 4 clove 1 clove = 1tsp 1 clove= 1 clove $ 9.36 5.00 lb $ 1.8720 red chili 2 0.42 oz each = 0.21oz $ 35.00 5.00 lb $ 7.0000 Olive Oil 0.50 cup 4 oz 8fl oz=1cup $ 48.49 3.00 L $ 16.1633 dried oregano 0.75 tsp 2.29oz 3.05=tsp 2.29/0.75=3.05 $ 17.99 1.25 lb $ 14.3920 sea salt 1.00 tsp .21oz 1tsp=0.21oz 0.21oz/1=0.21 $ 30.89 10.00 lb $ 3.0890 black pepper 0.50 tsp 0.04oz 0.50tsp=0.04oz 0.04/0.50=0.08 $ 31.99 80.00 oz $ 0.3999 red wine vinegar 2.00 tsp 0.32oz 2 tsp=0.32 fl oz $ 19.90 128.00 fl oz $ 0.1555 Total $ - Yield: (# of servings) Recipe Ingredient List Recipe Measure (directly from recipe) Recipe Ingredient Weight/Count Conversion Factor Show work: how did you calculate value in C? Bulk Pack Size Bulk Pack Size - Unit Cost per Bulk Unit # of RU in Bulk Purchase Case (Unit used in column C) Cost per R unit Amount needed for recipe (numbers only) Total Product Cost for Full Recipe .74oz/tbsp *2tbsp =1.48 oz .21oz/tsp * .5tsp = 0.0105oz .08oz/tsp * .5tsp = 0.04oz 1 clove = 1tsp 11 cloves = 1 bulb 50 cloves = 1lb 8 fl oz/cup*.75= 6 fl oz 8 fl oz/cup*.25= 2 fl oz Yield: (# of servings) Recipe Measure (directly from recipe) Recipe Ingredient Weight/Count Conversion Factor Show work: how did you calculate value in C? Bulk Pack Size Bulk Pack Size - Unit Cost per Bulk Unit # of RU in Bulk Purchase Case (Unit used in column C) Cost per R unit Amount needed for recipe (numbers only) Total Product Cost for Full Recipe 1.07oz/ 0.50cup=2.14oz per cup 0.21oz * 2 each =0.42oz 4oz/0.50 cups=8oz 0.32 floz/2=0.16 floz