OU blog

Personal Blogs

Valentin Fadeev

Calculus of Warehouses. Part 4

Visible to anyone in the world
Edited by Valentin Fadeev, Thursday, 17 Jun 2010, 22:02

I am posting it in reply to a question I came across in one social network. There is no original material here. I am just trying to reproduce the argument from one university lecture, as far as I can remember it.

The task is to calculate optimal stock level at a warehouse. Stock is replenished to a certain value (which is to be determined) immediately at fixed equally spaced moments in time. Amount of stock units cnosumed during each period is random.

Let s be the stock level which is maintained. Assume that stock is replenished over a fixed period of time (take it to be unitary to simplyfy calculations). Assume that r units are used during each time period with probability cap p of r .

Let cap c sub one be unitary storage cost, cap c sub two is a “penalty” cost
assigned when stock is theoretically below 0, or below some
minimal admissible level (lost orders, emergency orders, etc).

Assume also that the stock is replenished immediately.

Consider two possible situations.

1eaa1f85b6c049d9e84d4eb8cc732c16.jpg

1) r less than or equals s , i.e there is a positive remainder in the warehouse at
the end of the period. Storage cost is proportional to the area
under the stock graph.

equation sequence cap e sub one super r of s equals cap c sub one times s plus open s minus r close divided by two equals cap c sub one times open s minus r divided by two close

Expectancy of this value is:

cap m of cap e sub one super r of s equals cap c sub one times cap p of r times open s minus r divided by two close

Therefore the average cost is:

cap e sub one of s equals cap c sub one times n ary summation from r equals zero to s over cap p of r times open s minus r divided by two close

2) r greater than s . In this case the cost of both types is incurred. Again using the geometrical approach we find that cost elements are proportional to the areas of the triangles. The same argument as above gives the answer:

cap e sub two of s equals cap c sub one times n ary summation from r equals s plus one to normal infinity over cap p of r times s squared divided by two times r plus cap c sub two times n ary summation from r equals s plus one to normal infinity over cap p of r times open r minus s close squared divided by two times r

Thus the total cost is given by the following expression:

cap e of s equals sum with, 3 , summands cap c sub one times n ary summation from r equals zero to s over cap p of r times open s minus r divided by two close plus cap c sub one times n ary summation from r equals s plus one to normal infinity over cap p of r times s squared divided by two times r plus cap c sub two times n ary summation from r equals s plus one to normal infinity over cap p of r times open r minus s close squared divided by two times r

Marginal analysis is used to determine the optimal stock level. Optimal value of s minimizing cap e satisfies the relation:

cap e of s less than cap c sub one divided by cap c sub one plus cap c sub two less than cap e times open s plus one close

(here my memory is abit vague, so I am giving it without proof and without guarantee)

Practically this means calculating cap e of s for a series of the values of s until the above double inequality holds.

Permalink
Share post
Valentin Fadeev

Calculus of Warehouses. Part 3

Visible to anyone in the world
Edited by Valentin Fadeev, Saturday, 27 Mar 2010, 20:42

Further to the discussion of the cargo traffic through a port started in the previous post, i want to get together some thoughts and results obtained so far. What is missing here is only a leap into probabilistic formulas (i believe Poisson is just inevitable), but i'm still lacking confidence to assemble the whole thing in a working model.

Assume, we have cargo coming in at a daily rate of lamda sub n units, where n is the number of time period concerned (day in our case). Daily gate-out rate shall be mu sub n units. Then daily stock s sub n can be found recursively:

s sub zero equals alpha

equation left hand side s sub n equals right hand side s sub n minus one plus lamda sub n minus one minus mu sub n minus one

inflow

gateout

Mean storage time can be calculated as the total amount of warehouse work (see the previous post) divided by the total amount of cargo put through:

equation left hand side cap t macron equals right hand side n ary summation from i equals one to n over s sub i times open t sub i minus t sub i minus one close divided by n ary summation from i equals zero to n minus one over lamda sub i

In a continuous case it should obviously look like this:

equation left hand side cap t macron equals right hand side integral over zero under cap t open integral over zero under t open lamda of tau minus mu of tau close d tau close d t divided by integral over zero under cap t lamda of t d t

I took this definition form some old textbook and just made it complicated. However, it seems very natural and works perfectly in practice. It looks like formula for the center of gravity of the daily stok graph, but with changed order of summation (integration)

If calculations are made on a daily basis, the formula can be simplified as folows:

equation left hand side cap t macron equals right hand side n ary summation from i equals one to n over s sub i divided by n ary summation from i equals zero to n minus one over lamda sub i

Note, that if at the start of calculations there is some initial stock s sub zero with mean storage time cap t sub zero per unit, the formula needs a small correction:

equation left hand side cap t macron equals right hand side s sub zero times cap t sub zero plus n ary summation from i equals one to n over s sub i divided by n ary summation from i equals zero to n minus one over lamda sub i

It is obvious that on the long run the effect of such correction is negligible (which is also proved by actual observations).

Dwelling time

Applying the Little's formula to the above result we obtain the expression for the required warehouse space at every moment n:

equation left hand side cap e sub n equals right hand side lamda sub n times n ary summation from i equals one to n over s sub i divided by n ary summation from i equals zero to n minus one over lamda sub i

Permalink
Share post
Valentin Fadeev

A Small proof for Little's Formula

Visible to anyone in the world
Edited by Valentin Fadeev, Tuesday, 4 Oct 2011, 22:29

Little's formula is one of the cornerstones of the queueing theory, because it applies to a wide class of systems. It states that the number of customers in the system is the product of the average arrival rate and the mean time a customer spends in the system. Like all fundamental things it allows different proofs and interprerations. Some of them are really convincing, involving Kolmogorov-Chapman equations and related apparatus.

I will present a rather "mechanical" approach which gives the result in just three lines, but requires some preparatory discussion. We shall consider a warehouse where unitized (boxes, pallets, containers) cargo is stored. Cargo unit is a "customer" in the queue,storage time is service time.

Warehouse operator charges for (amount of cargo)X(storage time). It is reasonable to call this magnitude "warehouse work": A, (box)X(day). In a similar way "transport work" is introduced as (cargo)X(distance). Consider a limit case of a warehouse X having 1 storage place, say for 1 box, and another warehouse Y capable of storing 2 boxes at the same time.Then amount of work of 2 box-days can be performed by X in 2 days, while Y can do the same in 1 day. It is therefore natural to develop analogues with mechanics and consider capacity E as "power" of the warehouse meaning the amount of work that can be performed in a unit of time.

Now we move on to the proof. Suppose Q units of cargo are brought to the warehouse every t days. Warehouse has capacity of E units and mean dwelling T time is known based on observations. What is the condition for the system to work in a stable way, i.e. to cope with the incoming flow?

Incoming Q units will "create" warehouse work of QT box-days. The warehouse must "process" them in t days (because then the next lot is coming) having at least capacity E, that is it needs to perform work of Et box-days. The balance equation (or "law of conservation", if you like it) then looks like this:

equation left hand side cap e times t equals right hand side cap q times cap t

cap e equals cap q divided by t times cap t

But cap q divided by t equals lamda is the average daily rate of the incoming flow. Therefore:

cap e equals lamda times cap t

Which is the required result. In this interpretation it gives the minimum required capacity to put the cargo flow through the system.

 

Permalink 2 comments (latest comment by Valentin Fadeev, Saturday, 27 Mar 2010, 19:07)
Share post
Valentin Fadeev

Calculus of Warehouses. Part 2

Visible to anyone in the world
Edited by Valentin Fadeev, Sunday, 14 Mar 2010, 14:43

Another surprising appearance of a fine method in a clumsy problem is offered when calculating optimal parameters for a pile of unitary cargo (bales, cases, crates etc).

Say we have bales of cotton stowed in several layers. According to safety regulations the pile must have a pyramid-like structure with "stairs" after certain amount of layers. Suppose we have 1 layer in the upper tier x bales long and y bales wide:d7609c6675f972b63794bef3b2665403.jpg

The next tier has 3 layers and is 2 bales longer (x+2) and 1 bale wider (y+1). What should be the values of x and y so that area occupied by the pile is minimized? Assume we have a fixed and sufficiently large total amount of bales, say 60.

If we behave negligently enough to give x and y continuous values (which is not so bad when total cargo count is high), the problem yields a nice solution using.. Lagrange multipliers:

x times y plus three times open x plus two close times open y plus one close equals 60

g of x comma y equals sum with, 3 , summands four times x times y plus three times x plus six times y

multirelation f of x comma y equals open x plus two close times open y plus one close right arrow m times i times n

g of x comma y equals zero

normal cap phi of x comma y equals f of x comma y plus lamda times g of x comma y

equation sequence normal partial differential times normal cap phi divided by normal partial differential times x equals sum with, 3 , summands y times open four times lamda plus one close plus three times lamda plus one equals zero

equation sequence normal partial differential times normal cap phi divided by normal partial differential times y equals x times open four times lamda plus one close plus two times open three times lamda plus one close equals zero

equation sequence normal partial differential times normal cap phi divided by normal partial differential times lamda equals x times open four times y plus three close plus six times open y minus nine close equals zero

x almost equals four reverse solidus full stop y almost equals two

Really, if one can use a scalpel as a screwdriver, that's what I am doing, but like in the previous case, it just looks nice

Permalink
Share post
Valentin Fadeev

Calculus of Warehouses

Visible to anyone in the world
Edited by Valentin Fadeev, Saturday, 19 Jun 2010, 09:46

 

This is one of the small problems I formulated for myself during my studies, just for the sake of curiosity. Calculations are pretty simple and straightforward, but the results look nice, also with some unexpected turn in the middle.

In maritime transport one has to deal with the so-called bulk cargoes (iron ore, coal, fertilizers etc) which are often stored in the ports in large piles. I once considered determining some quantitative characteristics that are useful for designing the warehouse to store such type of cargo.

Let’s approximate the pile of cargo with the geometrical body of height H having a rectangle L2 X B at its base and 4 facets inclined towards the centre at equal slope, thus forming the upper horizontal edge of length L1:

figure

Its volume can be calculated as follows:

cap v equals integral over zero under cap h cap s of x d x

Where

equation sequence cap s of x equals a of x times b of x equals open cap l sub one plus cap l sub two minus cap l sub one divided by cap h times x close times cap b times x divided by cap h equals cap b times open cap l sub one times x divided by cap h plus open cap l sub two minus cap l sub one close close left parenthesis x divided by cap h times right parenthesis squared

So that

equation sequence cap v equals cap b times cap h times integral over zero under one left parenthesis cap l sub one times x divided by cap h plus open cap l sub two minus cap l sub one close times open x divided by cap h times right parenthesis squared close times d of x divided by cap h equals cap h times cap b divided by six times open two times cap l sub two plus cap l sub one close

Now let us determine the amount of energy required to form the pile (meaning mechanical work that has to be done against the forces of gravity). Assume that density of the cargo is γ kg/m3. To lift a small layer to height H-x requires:

equation sequence d times cap a equals gamma times g times d times cap v times open cap h minus x close equals gamma times g times cap b times open cap l sub one times x times open cap h minus x close divided by cap h plus open cap l sub two minus cap l sub one close times x squared times open cap h minus x close divided by cap h squared close times d times x

Thus, total work equals:

equation sequence cap a equals gamma times g times cap b times integral over zero under cap h open cap l sub one times x times open cap h minus x close divided by cap h plus open cap l sub two minus cap l sub one close times x squared times open cap h minus x close divided by cap h squared close d x equals gamma times g times cap b times cap h squared divided by 12 times open cap l sub one plus cap l sub two close

No we can ask the following question: if volume is a given value, what should be length and breadth so that the pile occupies minimal warehouse area? To simplify calculations and cancel out some parameters let us introduce the value called “angle of natural slope”. This is the term from soil mechanics which means the angle that the substance makes against horizontal surface. It depends on density, viscosity and inter-particle friction and can be found in special tables.

Let:

two times cap h divided by cap b equals tangent of chi

cap h equals one divided by two times cap b times tangent of chi semicolon equation sequence cap l sub one equals cap l sub two minus two times cap h divided by tangent of chi equals cap l minus cap b

cap v equals cap b squared times tangent of chi divided by 12 times open three times cap l minus cap b close

Assuming that V=const, obtain expression for L and insert it in the formula for the area S=LB:

cap l equals four times cap v divided by cap b squared times tangent of chi plus cap b divided by three

equation sequence cap s equals cap l times cap b equals four times cap v divided by cap b times tangent of chi plus cap b squared divided by three

equation sequence cap s super prime of cap b equals negative four times cap v divided by cap b squared times tangent of chi plus two times cap b divided by three equals zero

cap b equals root of order three over three

cap l equals open four divided by root of order three over three plus two divided by three times root of order three over three close times root of order three over three

cap s equals four times open one divided by root of order three over three plus one close left parenthesis cap v divided by tangent of chi times right parenthesis super two solidus three almost equals 4.4 left parenthesis cap v divided by tangent of chi times right parenthesis super two solidus three

Now, assuming again that V=const, let us determine the values of L, B again which minimize the amount of energy required to form the pile. Again, substituting for L, but now in the expression for A we obtain:

equation sequence cap a equals gamma times g times cap b times cap h squared divided by 12 times open cap l sub one plus cap l sub two close equals gamma times g times cap h squared divided by 48 times open eight times cap v times cap b divided by tangent of chi minus cap b super four divided by three close

equation sequence cap a super prime of cap b equals gamma times g times tangent squared of chi divided by 48 times open eight times cap v divided by tangent of chi minus four times cap b cubed divided by three close equals zero

MathJax failure: TeX parse error: Extra open brace or missing close brace

Remarkably, we get the same values which were obtained to minimize the base area, although the approach is now quite different.

To complete the picture we can use the derived results to determine maximum allowed volume for a single pile if unitary pressure on the ground is limited by some given value q kg/m2:

cap v times gamma divided by cap s less than q

multirelation cap v less than q times cap s divided by gamma equals q divided by gamma times 4.4 left parenthesis cap v divided by tangent of chi times right parenthesis super two solidus three

multirelation cap v less than left parenthesis 4.4 times q times right parenthesis cubed divided by gamma cubed times tangent of chi almost equals 85.3 times q cubed divided by gamma cubed times tangent of chi

Permalink
Share post

This blog might contain posts that are only visible to logged-in users, or where only logged-in users can comment. If you have an account on the system, please log in for full access.

Total visits to this blog: 54153