Use excel to solve.

Please attach excel sheets with work/steps and formulas and the excel solver setting used.

Will upvote!

TheWorld HealthOrganization(WHO)has issued newchild nutritionguidelines, which providesthe suggested daily intake range in 4 critical nutrients (shown in Table 1). It now aims to provide diet recommendations for children to implement these guidelines. The available food items with price and nutrients information are shown in Tables 2&3. The WHO aims to minimize the total daily cost of the diet while meeting the nutrient range. Table 1. WHO recommendations for each nutrient Table 2. Price of the food items Table 3. Nutrients of food items (a) Please formulate a linear program for WHO. (b) Develop a spreadsheet model to solve the LP. Make sure to show your work. (c) What is the optimal solution, and what is the optimal cost for the diet? (d) When reaching the optimal solution, which constraint(s) is binding? How do you know that? TheWorld HealthOrganization(WHO)has issued newchild nutritionguidelines, which providesthe suggested daily intake range in 4 critical nutrients (shown in Table 1). It now aims to provide diet recommendations for children to implement these guidelines. The available food items with price and nutrients information are shown in Tables 2&3. The WHO aims to minimize the total daily cost of the diet while meeting the nutrient range. Table 1. WHO recommendations for each nutrient Table 2. Price of the food items Table 3. Nutrients of food items (a) Please formulate a linear program for WHO. (b) Develop a spreadsheet model to solve the LP. Make sure to show your work. (c) What is the optimal solution, and what is the optimal cost for the diet? (d) When reaching the optimal solution, which constraint(s) is binding? How do you know that