Question: Please help me this question with excel solver, thank you! 2. Avocado oil is manufactured by pressing ripe avocados and blending them together. Five California

Please help me this question with excel solver, thank you!

Please help me this question with excel solver,
2. Avocado oil is manufactured by pressing ripe avocados and blending them together. Five California avocado types are available to buy next month Haas, Lamb Hass, Zutano, Bacon Gwen. Prices for buying each avocado type are given below {in $tton}: mum The fmal product sells at $180 per tonne. Haas and non-Haas avocados require different production lines for pressing. It is not possible to press more than 210 tonnes of Haas avocados and more than 26d tonnes of non-Haas avocados. There is a technical restriction relating to the average hardness of the final product. In the units in which hardness is measured this average must lie between 3.5 and 6.2 and tire hardness of each type ofavocado is: Haas Imam 8-8 "In Besides, the oil may never be made up of more than three avocado types. Also, if a type of avocado is used, at least 30 tonnes of that specic avocado type must be used. Finally, if either of Haas or Lamb Haas avocados are used then Bacon must also be used. Determine what to buy and hon.r to blend the ripe avocados so that the company maximizes its prot

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!