Previous in Forum: How Much Condensate Water for a Given SCFM of Compressed Air Next in Forum: Hardness-Difference Between Weld & HAZ for P91 Weldments?
Participant

Join Date: Sep 2017
Posts: 2

# Optimal Method of Distributing Edible Oil On Tanks

09/23/2017 9:05 AM

I have a task of finding the best way of distributing edible oil quantities on several tanks in the factory, around 28 tanks. The oil comes from harbor to the factory by trucks, and it contains the edible oil shipments, there are several constraints that forces the oil distribution to be distributed in particular way, these constraints includes:

1- Tank capacity constraints (each tank can contain specific oil quantities).

2- scheduled/ planned shipment constraint (the up comming planned shipments).

3- Oil type constraints (chemical characteristics of some oil types cannot be placed next to other oil types).

4- Oil type constraint (some tank are for finished oil while other tanks can be for raw oil).

5- Location constraint (raw oil should be placed near refinery, while finished oil should be placed near filling plant)

Some people suggested Operation Research methods for solving this problem, like nonlinear programming, others told me that it can be solved by simulation, I am thinking of Artificial Intelligence. So, what is the best way of solving this problem? and why? what is the similarities and differences for each type? and is there better optimization solution?

Interested in this topic? By joining CR4 you can "subscribe" to

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, rate them!
Guru

Join Date: Jun 2009
Location: South of Minot North Dakota
Posts: 8378
#1

### Re: Optimal method of distributing edible oil on tanks

09/23/2017 10:23 AM

Back in the old days someone would just sit down and think out the problem for themselves rather than assume some machine can think it out for them.

Draw up a chart of what tanks yo have and figure out what combination of tanks fits the criteria you need to meet and then put the oils in the proper tanks based on what that chart shows.

If such a basic logic puzzle is beyond your ability to handle you are more than likely grossly under qualified for the position you hold with the company and should be replaced.

Off Topic (Score 5)
Participant

Join Date: Sep 2017
Posts: 2
#2

### Re: Optimal method of distributing edible oil on tanks

09/23/2017 1:27 PM

Well, no need to be rude, I am still student and I am trainee.

I will do a flow chart to know what is the solution. I am asking about a way for making this process automated for easier decision making for other people in the future. Management are suggesting nonlinear programming - operation research and simulation due to my engineering background.

so I will ask again, what is the best way to make it automated, after I draw the flowchart of course.

Guru

Join Date: Mar 2007
Location: at the beach in Florida
Posts: 30975
#3

### Re: Optimal method of distributing edible oil on tanks

09/23/2017 2:19 PM

I would have green lights and red lights on the tanks controlled by centrally located computer, the lights would have numbers on them designating type of use....When a truck approaches the driver gives type of oil code, receiving or shipping, and time stamp...The driver then receives map with blinking light on proper tank and tank light of proper tank illuminates blinking....when the fill initiates the light goes steady on, and on completion goes out....completion of fill and quantity is sent to computer which updates inventory....green for receiving, red for dispersal...

__________________
Break a sweat everyday doing something you enjoy
2
Guru

Join Date: Oct 2008
Posts: 42293
#4

### Re: Optimal method of distributing edible oil on tanks

09/23/2017 2:45 PM

An automated process does not require human intervention to operate.

What you are asking for is a scheduling system, not an automated system.

1- Tank capacity constraints (each tank can contain specific oil quantities).

This is not a variable. It is specific to each tank.

2- scheduled/ planned shipment constraint (the up coming planned shipments).

This is dependent on usage and must be determined over time, unless you already know the usage requirements for each specific tank type.

3- Oil type constraints (chemical characteristics of some oil types cannot be placed next to other oil types). This is not a variable. It is specific to each tank.

4- Oil type constraint (some tank are for finished oil while other tanks can be for raw oil).This is not a variable. It is specific to each tank.

5- Location constraint (raw oil should be placed near refinery, while finished oil should be placed near filling plant) This is not a variable. It is specific to each tank.

Sit down with a piece of paper and draw the tank farm. Then add everything you can predict about each tank. Capacity, oil type, usage, etc. It is up to you to define the requirements.

You have to do that to and then it's simply a matter of a scheduling software program.

An intelligent system would have level sensors on each specific tank to indicate their status.

Active Contributor

Join Date: Jul 2017
Posts: 24
#5

### Re: Optimal Method of Distributing Edible Oil On Tanks

09/24/2017 12:40 AM

The obvious solution comes to mind would be Mojo swoptops using the idea that possibly developed the shipping container. Each delivery of oil comes from the harbour offloading the tank; you no longer have to worry about the more complex distribution of the oil itself with the simpler tank distribution. Of course this is merely a wild idea, I think one would need an intimate knowledge of your operations to use a systematic approach to overcome the constraints, you seem to be familiar with the Theory Of Constraints (TOC).

Guru

Join Date: Apr 2010
Location: About 4000 miles from the center of the earth (+/-100 mi)
Posts: 9048
#6

### Re: Optimal Method of Distributing Edible Oil On Tanks

09/24/2017 10:36 AM

It sounds like a typical logic puzzle. You might make a grid with tanks vs oil types and eliminate the incompatible grid squares.

http://logic-puzzles.org/how-to-solve-a-logic-puzzle.php

Guru

Join Date: Jul 2016
Posts: 1050
#7

### Re: Optimal Method of Distributing Edible Oil On Tanks

09/24/2017 10:23 PM

you might find it simple to assign each tank a particular score based on your current operation, such as receiving a truck load of raw oil. The tank with the highest score would win the shipment, then the score is updated and recalculated for all of the tank population. For instance, you would want to make sure the tanks in question suitable for raw oil have enough room for the entire tanker load, and rank them based on distance from the refinery. Not sure how shipment matters to the tank, unless you are only allowed to ship full tanks, but that could be added in. Zero out the scores for the incompatible tanks.

A maintenance screen would allow you to manually adjust the parameters based on leaks, cleanings, and other factors that allow you to reconfigure the basic tank compatibility, factors that cannot be updated by automatic sensors or calculations, or by the previous operation.

Rule based software such as that could be implemented with standard logic software, so your technical staff can understand it and troubleshoot it. If the rules are plain and simple, your operations people know how to modify it and tweak it. It seems that an elegant heuristic solution would perhaps not provide the value desired, if you need specialized skills to configure and maintain it...

Guru

Join Date: Sep 2008
Location: Vancleave, Ms about 30 miles inland from Biloxi and the coast
Posts: 3198
#8

### Re: Optimal Method of Distributing Edible Oil On Tanks

09/25/2017 3:30 PM

It seems to me that the company you work for is asking more than your experience warrants. If you do solve the problem, you should demand a big raise and an office with a window, telephone and secretary; maybe even a company car.

__________________
Mr.Ron from South Ms.
Guru

Join Date: Mar 2011
Location: Lubbock, Texas
Posts: 14331
#9

### Re: Optimal Method of Distributing Edible Oil On Tanks

09/26/2017 12:38 PM

Suppose then you have 28 tanks of which about half are for raw oil, and about half are for finished oil. You may not commingle raw and unfinished oil, and each tank has its own maximum holding capacity (a constant of the system), and each tank has it own present capacity (reported to the control room by instrumentation, hopefully redundant).

1. Get the blueprints for the plant layout, along with P&ID. Which tanks are interconnected (if any). Decide where to draw the boundaries for each product, and decide permanently how to isolate incompatible materials (cannot be next to each other without causing X to happen).

2. Firmly establish the pattern of load receiving/load dispatch so that no truck that is delivering product may approach tanks in the finished product area, and no truck that is taking on product shipment may approach the raw product holding area.

3. Connections to trucks may not be made by the drivers themselves. This is usually where chemical/product rules are broken. Each shipment incoming, and each load outgoing must have a tracking number for the shipment, does it not? Embedded in that tracking number (or maybe another field in the DCS) should be code for the type of material and its targeted quantity.

4. You can use other automated data control systems (DCS) used in warehouses for examples of how this plays out.

5. If tracking number code does not match the color or numeric coding on a tank connection, then it is forbidden to connect.

6. Metering control incoming controls inventory in the raw tanks, such that no tank should be allowed to overflow. In other words, if tank level leaves insufficient room for a T/L of oil, then the connection if forbidden. Some facilities may have rules that allow for "splitting the load" between incoming tanks, with pertinent cautions.

7. Load out inventory control is typically by weight on the truck, but some places still insist on doing this by level change on tank (not recommended).

8. Any plant's inventory control is only as good as the instrumentation within the plant, and the system that takes and applies the information.

__________________
If it ain't broke, don't fix it. Just build a better one.
Interested in this topic? By joining CR4 you can "subscribe" to

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, rate them!

James Stewart (1); lyn (1); Rixter (1); ronseto (1); rwilliams (1); sara.sh (1); SolarEagle (1); tcmtech (1); tonylampard (1)

 Previous in Forum: How Much Condensate Water for a Given SCFM of Compressed Air Next in Forum: Hardness-Difference Between Weld & HAZ for P91 Weldments?