Bean Barn

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 avaliable are Vietnamese, Colombian, Blue Mountain and Brazilian. Any unused beans will be used in other products. The requirements for the three coffee blends are as follows

Mellow contains what beans?

Regular contains what Beans?

Java contains what beans?

what type of beans are left over?

How much money will you make?

if the table is unclear can you try right clicking and opening in new tab its clear for me then its direct screen shot from the computer

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 Ph 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. 200lbs. 150lbs. Selling Price/Lb S10 S15 S20 The Beans Bean VN 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 S9 S12 S8 Use one of Target Cell Z= Columns R&T go in solver constraints Solutions Min or Max: Max = VN BM Bean Coffee VN M CO M BM M BZ M VN R R BM R BZ R CO JJ BZ JJ USED SIGN USED RHS Objective Function Z = Constraints 1 1 Ph M Label 2 Ph R 3 Ph JJ 4 MaxCaf M 5 Min Caf R 6 Max Caf R 7 Min Caf JJ 8 Max sell M 9 9 Max Sell R 10 Max Sell JJ 11 VN Avail 12 CO Avail 13 BM avail 14 BZ avail Ph M Ph R Ph JJ MaxCaf M Min Caf R Max Caf R Min Caf JJ Max sell M Max Sell R Max Sell JJ VN Avail CO Avail - BM avail 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? Page 1 The Blends Blend Mellow Regular Java Jolt Min Ph 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. 200lbs. 150lbs. 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 $8