Merge Center S - %98- Opboard Font Alignment Conditional Formats Cell Formatting Table Styles Styles Number G19 A D N 103. (15 points) 2 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 4 According to federal requirements, there must be at least 40 units of nutrient A and 60 units of nutrient B in a package of the new mit 5 In addition, the company has decided that there can be no more than 15 liver flavored biscuits in a package. 6 7 C) Type out the objective function and constraints. This will enable me to give you partial credit if Solver does not execute. 8 () Set up the problem as a problem and solve it using Solver. The Answer Report must be downloaded. Also the solver dialog box should be populated when I open your submission 9 (ili) What is the optimal product mix for a package of the biscuits to minimize the firm'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 13 Liver Flavored Chicken Flavored 14 Nutrient A 1 1 15 Nutrient B 2 16 Cost (cents! 2 17 18 1 19 20 21 22 23 24 25 26 27 28 01 Q2 Q3 04 Start a search OBA e Merge Center S - %98- Opboard Font Alignment Conditional Formats Cell Formatting Table Styles Styles Number G19 A D N 103. (15 points) 2 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 4 According to federal requirements, there must be at least 40 units of nutrient A and 60 units of nutrient B in a package of the new mit 5 In addition, the company has decided that there can be no more than 15 liver flavored biscuits in a package. 6 7 C) Type out the objective function and constraints. This will enable me to give you partial credit if Solver does not execute. 8 () Set up the problem as a problem and solve it using Solver. The Answer Report must be downloaded. Also the solver dialog box should be populated when I open your submission 9 (ili) What is the optimal product mix for a package of the biscuits to minimize the firm'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 13 Liver Flavored Chicken Flavored 14 Nutrient A 1 1 15 Nutrient B 2 16 Cost (cents! 2 17 18 1 19 20 21 22 23 24 25 26 27 28 01 Q2 Q3 04 Start a search OBA e