View the step-by-step solution to:

Avocado oil is manufactured by pressing ripe avocados and blending them together. Five California avocado types are available to buy next month...

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

2019-05-02 (3).png

2019-05-02 (3).png

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 specific 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
profit.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question