EXCEL SOLVER. A farmer is deciding on the lowest cost mix of feeds (X, Y, Z) that will still provide adequate nutrition for his cattle. Suppose that the numbers in the table below represents the number of grams of different ingredients (A, B, C &D) per 100 grams of each feed. The cost of Feed X is $7/100grams, Feed Y is $4/100grams, and Feed Z is $9/100 grams. Each cow will need 60 grams of Ingredient A per day, 30 grams of ingredient B, 40 grams of ingredient C, and 20 grams of ingredient D. Also, the farmer cannot provide more than 300 grams per day per cow of any of the feeds. Formulate the problem as a linear program that minimizes the total cost of feeds.

Ingredient	X	Y	Z
A	11	16	7
B	32	12	23
C	43	0	24
D	0	23	33

This problem must be solved using Excel Solver