Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

We have solved this LP problem using excel solver. This time, please use python Gurobi to solve the following question: A food is manufactured by

We have solved this LP problem using excel solver. This time, please use python Gurobi to solve the following question:

A food is manufactured by refining raw oils and blending them together. The raw oils come in two categories:

Vegetable oils

VEG 1

VEG 2

Non-vegetable oils

OIL 1

OIL 2

OIL 3

Vegetable oils and non-vegetable oils require different production lines for refining. In any month, it is not possible to refine more than 200 tons of vegetable oil and more than 250 tons of non-vegetable oils. There is no loss of weight in the refining process and the cost of refining may be ignored.

There is a technological restriction of hardness in the final product. In the units in which hardness is measured, this must lie between 3 and 6. It is assumed that hardness blends linearly. The costs (per ton) and hardness of the raw oils are

VEG 1

VEG 2

OIL 1

OIL 2

OIL 3

Cost

£110

£120

£130

£110

£115

Hardness

8.8

6.1

2.0

4.2

5.0

The final product sells for £150 per ton.

How should the food manufacturer make their product in order to maximize their net profit?

Step by Step Solution

3.49 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

136115837, 978-0136115830

More Books

Students explore these related Computer Engineering questions