resign Layout References Mailings Review View Body AA ELE Aabbccdte Asbecode ale x. x2 A Normal No Spacing pup-to-date with security updates, fixes, and improvements, choose Check for Updates. Kevin's Company produces a sausage mixture in 1000-pound batches. The mixture contains two Ingredients-beef (x1) and lamb (x2). The meat producer wants to know the optimal mixture of ingredients that will minimize cost. As shown in the following linear programming model, the meat producer has some requirements for the quantity of beef and lamb in each batch: Minimize subject to Z=5x1 + 6x2 x1+x2-1000 (batch weight) xl>=500 (minimum amount of beef) X2>=200 (minimum amount of lamb) X1-3x2>=0 x1.x2>=0 a Solve the linear programming model above using Excel (copy/paste your Excel output below- show your Excel work under the Excel worksheet "Problem1") (4 pts) b- What is the optimal cost of a batch of mixture? (2 pts) CH How many pounds of beef should be contained in a batch of mixture? (2 pts) d How many pounds of lamb should be contained in a batch of mixture? (2 pts)