use Excel solver to find the minimum cost allocation

The Hion Hog Farm Company may purchase and mix one or more of three types of grain/each containing different amounts of four nutritional elements; the data are given in Fig. 2.4. The production manager specifies that any feed mix for his livestock must meet at least minimal nutritional requirements, and he seeks the least costly among all such mixes Suppose his planning horizon is a two-weck period, that is, he purchases enough to fill his needs for two weeks Assuming divisibility and additivity, we write the linear formulation as minimize cost minimize (41x, + 35x +96x,), One Unit Weight of Minimal Total Grain TGrain 2 Grain 3 Over Planning tem Requirements Horizon Nutritional ingredient A23 Nutritional ingredient E Nutritional ingredient C Nutritional ingredient D6251 371250 2 250 2 900 2 232.5 Cost per unit weight | 41 | 35 | 96 Minimize Weight level