Please show all work. The excel sheet is below.

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 2 Calculate the cost of each suppliers Urail mix Cround to 2 decimal places) and in the table. Remember, each trail mix contains ounce of each ingredent. Supplier al MiX Douch B C. 3) Based purely on cost, which supplier would you award the contract to? 4) Calculate the average cost per ounce of each ingredient. Fill in the average price in the table below (round to 1 decimal places). Ingredient Average cost per ounce Almonds Cashews Pecans Sunflower Suds. Peanut Butter chips Cranberries Chocolate chips 5) What is the difference between average cost per ounce for almonds and the winning Supplier's cost per ounce for almonds 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