Question: I am having trouble with this problem. The Bean Barn needs to grind the beans to make three types of house special coffee blends. There


I am having trouble with this problem.




The Bean Barn needs to grind the beans to make three types of house special coffee blends. There are four types of coffee beans used to make the three blends. The three coffee blends are mellow mocha, regular and java jolt. The four types of beans available are Vietnamese, Columbian, Blue Mountain & Brazilian. Any un- used beans will be used in other products. The requirements for the three coffee blends are as follows: The Blends Blend Mellow Regular Java Jolt Min Pb 4.6 4.6 4.6 Min caffeine % none 1.5% 2.6 % Max caffeine % 1.2 % 2.5% unlimited Max we can sell 100 lbs. 2001bs. 1501bs. Selling Price/Lb $10 $15 $20 The Beans Bean VN CO BM BZ Ph 4.2 4.8 5.0 4.5 Caffeine % 3% 8% 2.7% 3.1% Lbs. available 125 150 150 175 Cost/Lb. $6 $9 $12 $8Use one of Target Cell Columns R & T Z = go in solver constraints Solutions >= I1 Max - - - Min or Max: Bean VN CO BM BZ VN CO BM BZ VN CO BM BZ Coffee M M M M R R R R JJ JJ JJ USED SIGN RHS Objective Function Z = Label Constraints Ph M 1 Ph M Ph R 2 Ph R 3 Ph JJ Ph JJ MaxCaf M 4 MaxCaf M Min Caf R 5 Min Caf R Max Caf R 6 Max Caf R Min Caf JJ 7 Min Caf JJ Max sell M 8 Max sell M Max Sell R 9 Max Sell R Max Sell JJ 10 Max Sell JJ VN Avail 11 VN Avail CO Avail 12 CO Avail BM avail 13 BM avail BZ avail 14 BZ avail Mellow cantains which beans? Regular Contains which beans? JJ Contains which beans? What type of beans are left over? How much $ will you make?Bean Barn To check your answer enter your Z value below Note getting the correct Z value from someone and typing it in the template in the target cell (thus overwriting the formula) will not make everything OK. 2 decimal places, no commas If your Z value is correct most likely everything else is as well
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
