Setup and solve using excel solver

The Jack-Green distillery produces custom-blended whiskey. A particular blend consists of rye and bourbon whiskey. The company has received an order for a minimum of 450 gallons of the custom blend. The customer specified that the order must contain at least 35% rye and not more than 270 gallons of bourbon. The customer also specified that the blend should be mixed in the ratio of two parts rye to one part bourbon. The distillery can produce 550 gallons per week, regardless of the blend. The production manager wants to complete the order in 1 week. The blend is sold for $5.5 per gallon. The distillery company's cost per gallon is $2.50 for rye and $1.25 for bourbon. The company wants to determine the blend mix that will meet customer requirements and maximize profits. Formulate and solve the linear programming model for this problem.