answer how to solve on excel pls

Ed Silver Dog Food Company wishes to introduce a new brand of dog biscuits composed of chicken and liver flavored biscuits that meet certain nutritional requirements 3 The amount of nutrients available in each is indicated in the table below along with the cost of manufacturing it. According to federal requirements, there must be at least 40 units of nutrient A and 60 units of nutrients in a package of the new mix In addition, the company has decided that there can be no more than 15 liver flavored biscuits in a package. 7 Type out the objective function and constraints. This will enable me to give you partial credit if Salver does not execute. 8 (1) Set up the problem as a LP problem and solve it using Solver. The Answer Report must be downloaded. Also the solver dialog box should be populated when lopen your submission 9 () What is the optimal product mix for a package of the biscuits to minimize the flow's cost? (you must write down your answer here after solving the problem) 10 (iv) What is the total cost of a package of dog biscuits using the optimal mix? (you must write down your answer here after solving the problem) 11 12 Liver Flavored Chicken Flavored 14 Nutrient A 15 Nutrient B 16 Cost (cents) 2 13 1 1 4 2 1 Ed Silver Dog Food Company wishes to introduce a new brand of dog biscuits composed of chicken and liver flavored biscuits that meet certain nutritional requirements 3 The amount of nutrients available in each is indicated in the table below along with the cost of manufacturing it. According to federal requirements, there must be at least 40 units of nutrient A and 60 units of nutrients in a package of the new mix In addition, the company has decided that there can be no more than 15 liver flavored biscuits in a package. 7 Type out the objective function and constraints. This will enable me to give you partial credit if Salver does not execute. 8 (1) Set up the problem as a LP problem and solve it using Solver. The Answer Report must be downloaded. Also the solver dialog box should be populated when lopen your submission 9 () What is the optimal product mix for a package of the biscuits to minimize the flow's cost? (you must write down your answer here after solving the problem) 10 (iv) What is the total cost of a package of dog biscuits using the optimal mix? (you must write down your answer here after solving the problem) 11 12 Liver Flavored Chicken Flavored 14 Nutrient A 15 Nutrient B 16 Cost (cents) 2 13 1 1 4 2 1