how do i solve this? please show all work. thanks!

Tou are a purchasing and stot Healthy Snacks, Inc. which is a company that focuses on producing fasty 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. After an extensive marketing analysis, the marketing team has ahen you the list of ingredients that will make up the new trail mix product. almonds, Cashens, pecans sunflower seeds Peanut butter chips, Cranberries, and chocolate m&m's. en 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, 1) On the excel document, in Column E Calculate the.cost per ounce for each ingredient. 13) Based purely on cost, which supplier would you award the contract to a (4) Calculate the average cost per ounce of each ingredient. Fill in the average price in the table below Cround to 2 I decimal places)... t Average cost per ounce 1. Ingredient | Almonds who Cashews Pecans Suntlower seeds Peanut Butter Chips I Cranberries Chocolate chips 9 Supplier's cost per Ingredients always lower lot, what are more expenrive 2 Thall mix was $2.10. inning Suppliers uear bu onacel save. De 1.the winning Supplier's ounce of its Ingredients than the average 2 If not, why Ingredients are more expensive Demand for the premium tral me tpoucher IS predicted to be 2.500 pouches 1. per month. The cost per pouch of the previous trail mix was $2.10. Based on the winning Suppliers CO3+ per pouch, how much WL Healthy Snaces save per year by Selecting a new supplier? 8) You just learned that supplier cs__ ingredients are of lower quality and that the supplier recently delivered a shipment of expired nuts to another customer. Would you award your contract to another Supplier given this information 2 If $0Who? What is the difference between laverage cost per ounce for almonds land the new winning supplier's cost per ounce for almonds? a) Is the new winning supplier's cost per ounce of its inare dients lower than average ? If not, what ingredients are more expensive? 10) Based on the new winning supplier's Cost per pouch, how much Will Healthy Snacks sare per year ? Assume the same demand and previous costs from question 4. II) Supplier A's package size is 20 lounces and supplier Band D's package Size is 10 ounces. Calculate the average cost per Ounce for each package size. (Try to use a pivot table). Lets assume that any difference in the average cost per ounce is due to a quantity discount. How much of a quantity discount is there between the two Ipackage sizes for each ingredient? Ingredient Arg.cost per (10.02)| Agarotoz) Quantity Discount Almonds Cashews I Pecans sunflower Dried Cranberries Peanut Butter Chocolate chips 12) 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