Can you solve the problem in excel and upload the answer report and the sensitivity analysis? I am specifically looking for the excel sheet not just typing.

Thanks,

Question 5: The Mill Mountain Coffee Shop blends coffee on the premises for its customers. It sells three basic blends in 1-pound bags, Special, Mountain Dark, and Mill Regular. It uses four different types of coffee to produce the blendsBrazilian, mocha, Colombian, and mild. The shop has the following blend recipe requirements: Blend Mix Requirements Selling Price/Pound Special Dark Regular At least 40% Columbian, at least 30% mocha At least 60% Brazilian, no more than 10% mild No more than 60% mild, at least 30% Brazilian $6.50 5.25 3.75 The cost of Brazilian coffee is $2.00 per pound, the cost of mocha is $2.75 per pound, the cost of Colombian is $2.90 per pound, and the cost of mild is $1.70 per pound. The shop has 110 pounds of Brazilian coffee, 70 pounds of mocha, 80 pounds of Colombian, and 150 pounds of mild coffee available per week. The shop wants to know the amount of each blend it should prepare each week to maximize profit. a. Formulate a linear programming model for this problem. DOT bat 2013 Deccan Education Tae Dabliebio Drentice Hall Xij = lbs. of coffee i used in blend j per week, where i = b (Brazilian), o (Mocha), c (Colombian), m (mild) and j =s (special), d (dark), 1 (regular) maximize Z=4.5.xbs + 3.75Xos + 3.60Xcs + 4.8.xms + 3.25xbd + 2.5xod + 2.35xed + 3.55Xmd + 1.75.xbr + 1.00xor +0.85xc1 + 2.05Xmr subject to .6xes .4.Xbs - 4xos - 4xms > 0 -.3.Xbs + 7xos - .3Xcs .3xms > 0 4.xbd - 6Xod - 6xcd - .6Xmd > 0 -.1 Xbd .lxod - .lxcd + 9xmd 0 Xbs + Xbd + Xbr 0