Please show step by step in excel and excel solver ti show how you got the answer also post your excel sheet with solver please Solve the following four problems $($total $100$ points$)$

Please show all your work clearly. Numerical answers without a clear method of how they are achieved will not be accepted.

$(30$ points$)$

An agricultural supply company is developing a livestock feed mix that will consist of three ingredients: ingredient $A,$ ingredient $B,$ and ingredient $C.$ The table below displays nutrition and cost information per ounce of each of these ingredients.

$\backslash$table$[[$Ingredient$,$Calories,Fat grams,$\backslash$table$[[\%$RDA$],[$Vitamin A$]],\backslash$table$[[\%$RDA$],[$Vitamin D$]],\backslash$table$[[\%$RDA$],[$Protein$]],$Cost$],[A,830,4,\%35,\%5,\%35,$$$0\mathrm{.}75$