PLEASE PROVIDE EXCEL STEP-BY-STEP CALCULATIONS. I KNOW THE ANSWER, I JUST DON'T KNOW HOW TO PERFORM IT.

AND PLEASE DON'T COPY THE OTHER, I'LL DOWNVOTE AND REPORT YOU

S14.7. (LO S14:1, S14:2, $14.4) The Black Jack Distillery produces custom-blended whisky. A particular blend consists of rye and bourbon whisky. The company has received an order for a minimum of 400 litres the custom blend. The customer specified that the order must contain at least 40% rye and not more than 250 litres 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 500 litres per week, regardless of the blend. The production manager wants to complete the order in one week. The blend is sold for $12 per litre. The distillery company's cost per litre is $4 for rye and $2 for bourbon. The company wants to determine the blend mix that will meet customer requirements and maximize profits. a. Formulate and solve a linear programming model for this problem. b. Solve the problem using the graphical method