Make an LP for Healthy Snacks to minimize total cost of producing one bag of snack while satisfying all constraints. Using Excel Solver solve the formulated LP. find the optimum values of each ingredient that should be included in the snack bag as well as optimum cost of one bag.

Expert 08A Formulate a LP for Healthy Snacks to minimize total cost of producing one bag of Snack while satisfying all constraints. Clearly state your decision variables, objective function and constraints. USING EXCEL. Use Excel Solver to solve the formulated LP and [ind the optimum values of each ingredient that should be included in the snack bag as well as optimum cost oi'one bag. SEE INFO BELOW Healthy Snacks Co. produces snack mixes. Recently, the company has decided to introduce a new snack mix that has peanuts, raisins, pretzels, dries cranberries, sunower seeds and pistachios. Each bag of the nestr snack is designed in order to hold 250 grams of the snack. The company has decided to market the new product with a emphasis on its health benets. After consulting nutritionists, Healthy Snacks decides to mix the ingredients so that the snack has the following specications: 1 - Total calories v= 2 1t} Iron 2'= 15 ll - Calcium 33= 5 Table below shows the amount ot'cach nutrition in each snack's ingredient per 1 gram: I peanutI raisin I pretzel I dried cranberries sunowersced pistachio I Calories 5.61' [3.00 I 1.00 I 3.00 5.04 5.62 Fat(g} 0.49 [W 0.01 0.01 0.51 0.06 Sodiumng) 0.13 [W 3.32 0.03 0.09 0.01 [W 0.05 WWIT 6.45 10.25 I Carl) (g) 0.16 [0.99 I 0.21 I 0.03 0.20 020 Protein (g} 0.26 [W 0.03 0.00 0.21 0.20 I Vitamin A(%) 0.00 I 0.00 I 0.00 I 0.00 0.01 0.00 [m 0.1? [WWIT 0.63 0.05 VitaminC(/o) 0.00 [W 0.00 0.00 0.02 0.09 I 1160(90) 0.25 [0.09 I 0.01' I 0.03 0.29 0.21 Calcium (v.1) 0.09 [W 0.00 0.00 0.07 0.10 Table below shows the cost of each ingredients per 1 gram: I peanut raisin pretzel crailljeefries \"222:\" pistachio $322; $0.005 $0.020 $0.013 I $ 0013 I $ 0.022 [S 0.031 Per marketing department research, each bag of snack should have at least 10 grams of each ingredient