[PLEASE ANSWER IN EXCEL TEMPLATE BELOW AND SHOW FORMULAS/SOLVER INFORMATION]

H.E.B. is creating a new sausage production line. The company mixes Beef and Pork in different proportions to create three types of sausage. The mix grades include a) Beef lovers, which must be no more than 20% Pork; b) Hebsage, which may be any mix of the two meets; c) Pork lovers, which must be at least 40% Beef. The cost for buying Pork is $4 per pound, and for buying beef is $6 per pound. The weekly demand for the three types of sausage is 400 pounds of Beef lovers, 750 pounds of Hebsage, and 600 pounds of Pork lovers. How should H.E.B. blend Beef and Pork to meet the sausage demand most economically?

^^^^ONLY INFORMATION PROVIDED

What

	Pork in Beef lovers	Pork in Hebsage	Pork in Pork lovers	Beef in Beef lovers	Beef in Hebsage	Beef in Pork lovers
Number of pounds
Cost	4	4	4	6	6	6
Constraints:
Beef lovers demand								>=	400
Hebsage demand								>=	750
Pork lovers demand								>=	600
Min Beef in Pork lovers
Max Pork in Beef lovers
							LHS	Sign	RHS
	The optimal objective value is $8120