Make-buy Part 1 Complete_T11

.xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

41299

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

18

Uploaded by MateStingray3945

Report
Menu Item Item Description Purchase Location Bulk Cost Balsamic Dressing made with soy oil Sam's Club $19.84 144 Herb Rub $25.99 5 garlic aioli garlic sauce Webstaurantstore.co $34.49 1 Bulk Pack Size dried garlic, herbs, and spices Webstaurantstore.co m
Notes fl oz 2 tbsp 72 $0.2756 2 tbsp = 1 fl oz lb 1.00 oz 80 $0.3249 Gallon 28 g 126 $0.27 1 gallon ≈ 3,785.41 grams 135.192857143 Bulk Pack Size - Unit Planned Serving Size Servings per Bulk Pack Cost per Serving 0.50 oz = 0.0312 lbs Remem Only nu Use exc Remove
mber: umbers in columns E, G and I cel to calculate ALL formulas e examples
Recipe Name: Chicken Seasoning Blend Serving size: 0.5 tbsp 8 Bulk Cost Sea Salt 1.5 tsp 0.315oz .21oz/tsp $114.99 80.00 oz $1.44 16.0000 $ 7.1869 0.315 $ 2.2639 Black Pepper 0.5 tsp .04oz .08oz/tsp $45.69 80.00 oz $0.57 8.0000 $ 5.7113 0.040 $ 0.2285 Dried Basil 1 tsp .06oz .06oz/tsp $ 22.00 16.00 oz $1.38 16.0000 $ 1.3750 0.060 $ 0.0825 1 tsp .06oz .06oz/tsp $ 15.50 16.00 oz $0.97 16.0000 $ 0.9688 0.060 $ 0.0581 Garlic Powder 0.5 tsp .55oz .11oz/tsp $ 27.99 80.00 oz $0.35 80.0000 $ 0.3499 0.550 $ 0.1924 0.5 tsp .55oz .11oz/tsp $ 10.50 16.00 oz $0.66 16.0000 $ 0.6563 0.550 $ 0.3609 Dried Thyme 0.5 tsp .06oz .06oz/tsp $ 26.00 16.00 oz $1.63 16.0000 $ 1.6250 0.060 $ 0.0975 Celery Seed 0.25 tsp .55oz .11oz/tsp $ 20.69 80.00 oz $0.26 80.0000 $ 0.2586 0.550 $ 0.1422 0.125tsp .04oz .08oz/tsp $ 59.99 400.00 oz $0.15 400.0000 $ 0.1500 0.040 $ 0.0060 Cayenne Pepper 0.125tsp .075oz .6oz/tsp $ 25.95 80.00 oz $0.32 80.0000 $ 0.3244 0.750 $ 0.2433 Dried Parsely 0.25 tsp .06oz .06oz/tsp $ 25.00 16.00 oz $1.56 80.0000 $ 0.3125 0.060 $ 0.0188 Total $ 3.6941 Recipe Name: garlic aioli Serving size: 6 tsp 8 Bulk Cost Garlic 1 clove 1 clove 1 clove=1 tsp $6.66 2.00 pounds $ 3.3300 2.0000 $ 3.3300 1 $ 3.3300 mayo 0.50cup 4oz 8oz=1cups 0.50cups * 8oz $46.99 512.00 oz $ 0.0918 512.0000 $ 0.0918 8 $ 0.7342 lemon juice 1 tbsp 0.53 fl oz 0.53oz=1tbsp $4.59 48.00 oz $ 0.0956 48.0000 $ 0.0956 0.53 $ 0.0507 sea salt 0.25 tsp 0.05oz 1tsp= 0.20oz 0.20oz*0.25tsp $1.49 16.00 oz $ 0.0931 16.0000 $ 0.0931 0.05 $ 0.0047 olive oil 2 tsp 0.334oz 1tsp= 0.167oz 2tsp*0.167 $91.07 102.00 oz $ 0.8928 102.0000 $ 0.8928 0.334 $ 0.2982 black pepper 0.25tsp 0.02oz 1tsp= 0.08oz 0.08oz*0.25tsp $5.49 8 oz $ 0.6863 $ 8.0000 $ 0.6863 0.02 $ 0.0137 Total $ 4.4178 Recipe Name: Serving size: Bulk Cost Total $ - Recipe Name: 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 .21oz/tsp* 1.5tsp = 0.315oz .08oz/tsp* 0.5tsp = .04oz .06oz/tsp* 1 tsp = .06oz Dried Crushed Rosemary .06oz/tsp* 1 tsp = .06oz .11oz/tsp* 0.5tsp = 0.55oz Dried Mustard Powder .11oz/tsp* 0.5tsp = 0.55oz .06oz/tsp* 1 tsp = .06oz .11oz/tsp* 0.5tsp = 0.55oz Chicke Bouillon Granules .08oz/tsp* 0.5tsp = .04oz .6oz/tsp* 0.125tsp = .075oz .06oz/tsp* 1 tsp = .06oz 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 1 clove* 1tsp=1 clove 0.53oz*1 tbsp=0.53 Yield: (# of servings) Recipe Ingredient List 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 Recipe Measure (directly from recipe)
Serving size: Bulk Cost Total $ - Yield: (# of servings) Recipe Ingredient List 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 Recipe Measure (directly from recipe)
Cost per serving $ 0.2830 80oz $ 0.0286 80oz $ 0.0103 16oz $ 0.0073 16oz $ 0.0241 80oz $ 0.0451 16oz $ 0.0122 16oz $ 0.0178 80oz $ 0.0007 400oz $ 0.0304 80oz $ 0.0023 16oz $ 0.4618 Cost per serving $ 0.4163 2lbs*1clove= 2 $ 0.0918 512oz $ 0.0063 48oz $ 0.0006 16oz $ 0.0373 102oz $ 0.0017 8oz $ 0.5522 Cost per serving $ - Show work: how did you calculate the value in K? Show work: how did you calculate the value in K? Show work: how did you calculate the value in K?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help