Problem 2-3? Constraints Nutrient A needed Nutrient B needed Nutrient C needed Nutrient D needed - LHs ' sign er-rs Cattle are sent to a feedlot to be grainfed before being processed into beef. The owners of a feedlot seek to determine the amounts of cattle feed to buy so that minimum nutritional standards are satised to ensure proper weight gain, while total feed costs are minimized. The feed mix used is made up of three grains that contain the following nutrients per pound of feed: Nutrient {ounces per pound of feed} Feed A B C D Feed mix X 3 2 1 '6 Feed mix tr 2 3 [i 3 Feed mix 2 4 1 2 4 Feed mixes X, Y, and Z cost $3, $4, and $2.25 per pound. respectively. The minimum requirement per cattle per day.r is 4 pounds of nutrient A. 5 pounds of nutrient i3. 1 pound of nutrient C. and 8 pounds of nutrient D. The ranch faces one additional restriction: it can only' obtain 500 pounds of feed mix Z per day from the feed supplier regardless of its need. Because there are usuallyr 10f} cattle attire feed lot at any given time, this means that no more than 5 pounds of stock Z can be counted on for use in the feed of each cattle per day. Fonnuiate this problem as a linear program and solve it by using Excel. Determine the optimal production mix for the valve plant to make the best use of its prot potenti