please show all work

4) Calculate the average cost per ounce of each ingredient. Fill in the average price in the table below (round to Z ''decimal places). Ingredient Average cost per ounce Almonds Cashews Pecans Sunflower Suds Peanut Butter chips Cranberries Chocolate chips D) Based on the new Winning Supplier's cost per pouch, how much will Healthy Snacks save per year? Assume the same demand and previous casts from Question 4. II) Supplier A's package Size is 20 dnces and Supplier Band D's package size is 10 ounces Calculate the average cost per Ounce for each package tze. Try to use a pivot table). Lets assume that any difference in the average cost per punte is due to a quantity discount. How much of a quantity discount is there between the two package size for each ingredient? Ingredient Axg.cost per (102) X90 ) Quantity Almonds Cashon Recans ugg Chocolate Ships 111) In addition to cost and quality, what are Other issues that may effect what supplier you will choose? 10 B a $ 6.22 Supplier Ingredient Cost Ounces Cost per ounce - Almonds $ 8.40 EA Cashews $ 7.99 Pecans $ 9.00 5 A Sunflower seeds $ 3.33 5 A Dried cranberries $ 2.84 7 Peanut butter chips $ 1.09 8 Chocolate chips $ 1.20 9 Almonds 5.65 Cashews $ 4.45 11 B Pecans 12 B Sunflower seeds $ 2.00 13 B Dried cranberries $ 1.85 Peanut butter chips $ 0.95 15 B Chocolate chips $ 0.40 16 c Almonds $ 4.15 Cashews $ 3.50 18 C Pecans $ 5.10 19 C Sunflower seeds 1.44 20c Dried Cranberries $ 0.98 21c Peanut butter chips $ 0.20 22 C Chocolate chips $ 0.18 23 D Almonds $ 4.89 Cashews 4.77 Pecans 5.00 Sunflower seeds Dried cranberries Peanut butter chips $ 0.80 Chocolate chips $ 0.75 17 C 2.70 1.50 ou are a purchasing andlustat Healthy Snacks, Inc. which is a company that focuses on producing Fusty healthy snacks. The company wants to replace the supplier of its current premium trail mixs and you have been assigned to find a new supplier. Acrer an extensive marketing analysis, the marketing team has given to the list of ingredients that will make up the new trail mix product. almonds, Cashews. pecans sunflower seeds Peanut butter chips Cranberries, and chocolate m&m's. len mallinas, The trail mit Pouches will be ounces each, and there will be an lequal amount of each ingredient including Shipping) is given in the Excel document. You must conduct a procurement analysis of this data and select a supplier. On the excel document, in Column E I calculate the cost per ounce for each ingredient