Power Point Quantative Method - 3
Power Point Quantative Method - 3
Power Point Quantative Method - 3
MODEL
The transportation model deals
? with a special class of linear
programming problem in which the objective is to transport a
homogeneous commodity from various origins or factories to
different destinations or markets at a total minimum cost
(Murthy, 2007)
In using transportation model the following major assumptions are
made.
1. The Homogeneity of materials to be transported. The materials or
items to be transported by road, sea, air or land must be the same
regardless of their specific source or specified locations.
2. Equality of transportation cost per unit. The transportation cost per
unit is the same irrespective of which of the materials is to be
transported.
3. Uniqueness of route or mode of transportation between each source
and destination.
continued ...
In using the transportation model it is essential that the following
information are made available
The list of each source and its respective capacity for supplying
the materials
The list of each destination and its respective demand for that
period.
The unit cost of each item from each source to each destination.
Continued ---
Theoretical Consideration
Suppose we have a transportation problem involving movement of
items from m sources (or origins) to n location (destination) at
minimum cost.
Let Cij be the unit cost of transporting an item from source i to
location j;
ai be the quantity of items available at source i and
bj the quantity of item demanded at location j.
Also, let xij be the quantity transported from ith source to j
the location then total supply = ∑aij,
while total demand = ∑ bij This problem can be put in tabular form as
shown below:
continued
1 2 3 …. n supply
.. .. .. .. ..
.. .. .. .. ..
m Cm1 Cmn am
Demand b1 b2 b3 ..bm
Continued ---
when ∑mi=1 aij = when ∑ni=1 bij then we have the balanced case
The linear Programming model can be formulated as follows
∑mi=1 ∑ni=1 Cij subject to the constraints :
∑mi=1 ai = …. i= 1,2,3…m
∑mi=1 bi = …. i= 1,2,3…n
Xij ≥ 0
continued
General Procedure for Setting up a Transportation Model
1) Convert statement of the problem into tabular form showing the total
supply and total demand for each of the sources and destinations.
2) Check that total number of supply equals the total number of demand
to know whether the transportation model is of the balanced or
unbalanced type.
3) Allocate values into the necessary cells using the appropriation
techniques for the method of allocation of quantities that you have
selected.
We expect the number of allocated cells to be m + n-l where m is
the number of rows and n is the number of columns otherwise
degenerating occurs.
4. Compute the total cost of transportation
Continued
Solution of transportation problem comes up in two phases namely:
The initial feasible solution
The optimum solution to the transportation problem
Developing an Initial Solution
When developing an initial basic feasible solution there are different
methods that can be used. We shall discuss three methods used
namely;
1. The North West Corner Method
2. The Least Cost Method
3. Vogel’s Approximation Method
It is assumed that the least cost method is an improvement on the
North West Corner method, while the Vogel’s approximation method
is an improvement of the least cost method.
Continued ---
The North West Corner Method
This is the simplest and most straight forward format of the method of
developing an initial basic feasible solution.
To explain how to use this method, we present an illustrative data of a
transportation problem in the example below:
Continued ---
Table .1 Supply and demand of cows
source X Y Z supply
A 90 85 70 600
source X Y Z supply
A 90 85 70 600
600
B 175 110 95 1400
A 90 85 70 600
600
B 175 110 95 1400
1000 400
C 205 190 130 1000
A 90 85 70 600
600
B 175 110 95 1400
1000 400 400
C 205 190 130 1000
source X Y Z supply
A 90 85 70 600
600
B 175 110 95 1400
1000 400 400
C 205 190 130 1000
650 350
Demand 1600 1050 350
1000 650
Continued ….
e. Allocate 350 cows to cell (3, 3) to satisfy the demand in Z and exhaust
the supply in C. Cross out the 350..
source X Y Z supply
A 90 85 70 600
600
B 175 110 95 1400
1000 400 400
C 205 190 130 1000
650 350 350
Demand 1600 1050 350
1000 650
Continued ---
This completes the allocation.
We observe that out of the 9 cells only 5 cells have been allocated.
If m is the number of rows. n is the number of columns the total
number of allocated cells in this case is m + n — 1 i.e 3+ 3 — 1 = 5.
The transportation cost is found by multiplying unit cost for each
cells by its unit
allocation and summing it up. i.e. C =∑ (unit cost x cell allocation)
= (600 x 90) + (l000x 175) + (110 x 400) + (190 x 650) + (130 x 350)
= 54000 + 175000 x 44000 + 123500 + 45500
= 442000
Continued ---
This can be summarized in tabular form as follows
442,000
Continued ---
2 .The Least Cost Method
This method is also known as the minimum cost method.
Allocation commences with the cell that has the least unit cost and
other subsequent method of allocation is similar to the North West
Corner method .
Example 2 : Solve the above example using the Least Cost method
Solution
We observe that the total demand = 1600 + 1050 + 350 = 3000 and
total supply = 600 + 1400 + 1000 3000. Since demand = supply we
have a balanced transportation problem.
We note that the least cost per unit in this problem is 70 in cell (1, 3).
We do the allocation as follows:
Continued ---
Step 1: Allocate 350 to cell (1, 3) to satisfy the demand at Z and leaving
a supply of 250 cows at A Cross out column3 that has been satisfied.
source X Y Z supply
A 90 85 70 600
350 250
B 175 110 95 1400
source X Y Z supply
A 90 85 70 600
250 350 250
B 175 110 95 1400
A 90 85 70 600
250 350 250
B 175 110 95 1400
800 600
C 205 190 130 1000
A 90 85 70 600
250 350 250
B 175 110 95 1400
600 800 600
C 205 190 130 1000
A 90 85 70 600
250 350 250
B 175 110 95 1400
600 800 600
C 205 190 130 1000
1000
A 29 41 25 46 1250
B 50 27 45 33 2000
C 43 54 49 40 500
D 60 38 48 31 2750
origin 1 2 3 4 suppl d1
y
A 29 41 25 46 1250 4
B 50 27 45 33 2000 6
C 43 54 49 40 500 3
D 60 38 48 31 2750 7
Demand 32 250 1750 1250
50
d1 14 11 20 2
continued ---
(iii) The highest penalty cost is 20; we allocate to the least unit cost in
that column the highest it can take. The least is 25 and is allocated
1250 as shown below.
(iv) The next step is to re-compute the penalty costs, d2! and d2 for the
unbalanced cells in both rows and column. The results obtained are as
follows.
(v) The highest penalty cost is 11. We allocate the maximum allocation for cell
(2,1). which has the least cost of 27 which is 250. Row 2 has a balance of
1750 to be exhausted while column 2 is satisfied.
(vi) Next we compute penalty costs d3! and d3 for the unallocated cells and
obtain the following. The highest penalty cost is 17 and the unit cost is 31.
We give the cell with unit cost of 31 its maximum allocation of 1250 thereby
exhausting the demand in column 3 and leaving a balance of 1500 in row 4.
(vii) We re-compute the penalty cost d4! and d4 and then fill up all the other
cells
Continued ---
The highest penalty costs is 12, we allocate cell (4, 3) having the least
unit cost of 48 maximally with 500 to exhaust row 3. All the
remaining cells in column 3 are given 0 allocations since column 3
has now been exhausted.
(viii) We then allocate the remaining empty cells as follows: cell (2, 1) is
given the balance of 1750 to exhaust the supply of row 2. Cell (3, 1)
is given supply of 500 to exhaust the supply of row 3 while cell (4, 1)
is allocated to the balance of 1000.
(ix) A total of 7 cells have been allocated satisfying m + n — 1 criterion.
We then compute the minimum cost of allocation in the transportation
model and obtain the following;
Continued ---
The Unbalanced Case
Suppose the total number of items supplied is not equal to the total
number of items demanded.
When this happens then we have an unbalanced transportation
problem.
To solve this type of problem we adjust the transportation table by
creating a dummy cell for source or demand column or row to balance
the number.
The dummy cells created are allocated zero transportation unit cost
and the problem is solved using appropriate method as before.
We have two cases, namely
(1)the case when supply is greater than demand (SS>DD)
(2) the case when the demand is greater than the supply (DD >SS).
Continued --
Example 5 : The table below shows us how some items are transported
from five locations A,B,C,D to four location P,Q,R,S with the unit
cost of transportation in them being shown in the box. Determine the
initial feasible solution by finding minimum cost of transportation
using the North West Corner method.
Continued ---
P Q R S supply
A 150 120 135 105 2000
A 10 8 12 150
B 16 14 17 200
C 19 20 13 300
1 2 3 Demand
A 10 8 12 150
B 16 14 17 200
C 19 20 13 300
D 0 0 0 250
I 6 7 9 70,000
J 5 8 7 10,000
K 7 9 6 150,000
A B C Supply
I 6 7 9 70,000
70000
J 5 8 7 10,000
10000
K 7 9 6 150,000
50000 100000
dummy 0 0 0 100000
90000 10000
Demand 130,000 90,000 110,000
--- continued
Cell Quantity Unit Cost Cost
1,420,000
Continued ---
We now find the optimum solution using the result obtained by the
Least Cost Method.
We first identify the empty cells in the table of initial feasible
solution. The cells are Cell (1,2), Cell (1, 3), Cell (2,2), Cell (2,3) and
Cell (4,1)
Next we evaluate empty cells to obtain the stepping stone path as well
as the Cost
Improvement indices (CII) as follows:
---continued
(b) We now find the optimum solution using the result obtained by the
Least Cost Method.
We first identify the empty cells in the table of initial feasible
solution.
The cells are Cell (1,2), Cell (1, 3), Cell (2,2), Cell (2,3),(3,2) and Cell
(4,1)
Next we evaluate empty cells to obtain the stepping stone path as well
as the Cost Improvement indices (CII) as follows:
Cell (1,2): The Stepping Stone Path for this cell is
+ (1,2) - (4,2) + (4,3) - (1,1)+(3,l) - (3,3)= +7 – 0 + 0 – 6 + 7 = +8
Cell (1,3) The Stepping Stone Path for this cell is +(1,3) — (1,1) +
(3,1) — (3.3). = +9 – 6 + 7 – 6 = +4
Continued---
Cell (2,2) the stepping stone path for the cell is
+(2,2) – (4,2) + (4,3) – (3,3) + (3,1) – (2,1)= +8 – 0 + 0 – 6 + 7 – 5 = +4
Cell (2, 3) the stepping stone path is
+ (2, 3) – (3, 3) + (3,1) – (2,1)= +7 - 6 + 7 – 5 = +3
Cell (3, 2) the stepping stone Path is
+(3,2) – (4,2) + (4,3) – (3,3)= +9 – 0 + 0 – 6 = +3
Cell (4, 1) the stepping stone Path is
+(4,1) – (3,1) + (3,3) – (4,3).= +0-7+6-0=-1
Because cell (4,1) its value is negative it requires reallocation. Which
is given by:
--- continued
A B C Supply
I 6 7 9 70,000
70000
J 5 8 7 10,000
10000
K 7 9 6 150,000
40000 110000
dummy 0 0 0 100000
10000 90000
Demand 130,000 90,000 110,000
Continued ---
chuck again the empty cells stepping path is non negative
The empty cells are Cell (1,2); Cell (1,3); Cell (2,2); Cell (2,3); Cell
(3,2) and Cell (4,3)
For Cell (1,2) The Stepping Stone Path is
+(1,2) - (4,1) + (4,2) - (1,1). =+7 – 0 + 0 – 6 =+1
For Cell (1,3)The Stepping Stone Path is
+(1,3)-(1,1)+(3,1) - (3,3) =+9 – 6 + 7 - 6 =+4
For Cell (2,2) The Stepping Stone Path is
+ (2,2) - (4,2) + (4,1) - ( 2,1) =+8 – 0 + 0 - 5= +3
For Cell (2,3) The Stepping Stone Path is
+(2,3) - (3,3) + (3,1) - (2,1) = +7 – 6 +7 – 5 = +3
For Cell (3,2) The Stepping Stone Path is
+(3,2) — (4,2) + (4,1) — (3,1) = 9-0-0-7=2
--- continued
For Cell (4,3) The Stepping Stone Path is
+ (4,3)— (3,3) + (3,1) — (4,1) =+0—6+7-0=1
Since the results are all positive an optimal solution has been found in
the last table
Therefore the result would be
= 70,000 x 6= 420,000
= 10,000 x 5 = 50,000
= 40,000 x 7 = 280,000
= 110,000 x 6= 660,000
= 10,000 x 0 = 0
=90,000 x 0= 0
1,410,000
We observe that the minimum cost of 1, 410, 000 which is found through
feasible is also optimal
Continued ---
The Modified Distribution Method
This method is usually applied to the initial feasible solution obtained by the
North
West Corner method and the Least Cost method since the initial feasible
solution
obtained by the Vogel’s Approximation Method, is deemed to be more accurate
than these two. To use this method we take the following steps:
Step 1: Using the obtained feasible solution, compute the row dispatch unit cost
r1
and the column reception unit cost cij at location j for every cell with
allocation
using
--- continued
2. The Modified Distribution Method
This method is usually applied to the initial feasible solution obtained by the Least Cost method
since the initial feasible solution obtained by the Vogel’s Approximation Method, is deemed to
be more accurate than these two.
To use this method we take the following steps:
Step 1: Using the obtained feasible solution, compute the row dispatch unit cost r 1 and the column
reception unit cost Cij at location j for every cell with allocation using
Cij = r i+ Cj
Conventionally, ri= 0
.
continued ---
Note that ri is the shadow cost of dispatching a unit item from source
to cell kij
while cj is the shadow cost of receiving a unit of the item from
location j to cell kij
and cij is the cost of transporting a unit of the item from source i to
location j in the corresponding cell kij.
If we have a 3 x 3 cell we obtain r1, r2, r3, C 1, C2 and C3 respectively.
Step 2
Compute the unit shadow costs for each of the empty unallocated
cells using the various obtained ci and ri.
Continued ---
Step 3
Obtain the differences in unit costs for the unallocated cells using
C1ij =Cij – (ri + Cj)
Obtain all the values of Cij for unoccupied cells by applying the formula
for unoccupied cell.
If these differences are all positive for the empty cells the minimum
optimum solution has been obtained.
If we have one or more records of any negative difference then it implies
that an improved solution can still be obtained and so we proceed to step
Step4
If Cij values are > 0 then, the basic initial feasible solution is optimal.
If Cij values are =0 then, the multiple basic initial feasible solution exists.
.
.
Continued ---
If Cij values are < 0 then, the basic initial feasible solution is not
optimal.
then select the cell with the highest negative value of Cij.
If more than one of them have the same negative Cij (i.e. the unit
shadow cost is greater than the actual cost), that is a tie occurs we
select any one of them arbitrarily for transfer of units
Continued ---
Procedure for shifting of allocations
Select the cell which has the most negative Cij value and introduce a
positive quantity called ‘q’ in that cell.
To balance that row, allocate a ‘– q’ to that row in occupied cell.
Again, to balance that column put a positive‘q’ in an occupied cell
and similarly a ‘-q’ to that row.
Connecting all the‘q’s and ‘-q’s, a closed loop is formed.
Two cases are represented
If all the q allocations are joined by horizontal and vertical lines, a
closed loop is obtained.
Continued ---
Conditions for forming a loop
(i) The start and end points of a loop must be the same.
(ii) The lines connecting the cells must be horizontal and vertical.
(iii) The turns must be taken at occupied cells only.
(iv) Take a shortest path possible (for easy calculations).
Remarks on forming a loop
(i) Every loop has an even number of cells and at least four cells
(ii) Each row or column should have only one ‘+’ and ‘–’ sign.
(iii) Closed loop may or may not be square in shape. It can also be a
rectangle or a stepped shape.
(iv) It doesn’t matter whether the loop is traced in a clockwise or anti-
clockwise direction.
Continued --
Step 5
Transfer to the empty cells the minimum value possible from an
allocated cell, taking care that the values of the demand and supply
are unaffected by the transfer and that no other empty cell is given
allocation
Step 6
Develop a new solution and test if it is the optimum solution
Step 7
If it is not, repeat the procedures by starting from step 1 until the
optimum solution is obtained.
--- continued
In the transportation table given below:
(a)Find the initial feasible solution using the least cost method
approximation method.
(b)Use the modified Distribution method to find the optimum solution
using the initial feasible solution obtained by the Least Cost Method.
1 2 3 Supply
X 9 11 15 400
Y 15 7 17 500
Z 11 5 7 600
1 2 3 Supply
X 9 11 15 400
400
Y 15 7 17 500
100 400
Z 11 5 7 600
450 150
X 9 11 15 400
400
Y 15 7 17 500
100 400
Z 11 5 7 600
450 150
X 9 11 15 400
400
Y 15 7 17 500
100 400
Z 11 5 7 600
50 550
X 9 11 15 400
400
Y 15 7 17 500
50 450
Z 11 5 7 600
50 550
Queue characteristics
Arrival Characteristics
• Size of the arrival population – either infinite or limited
• Arrival distribution:
– Either fixed or random
– Either measured by time between consecutive arrivals, or arrival
rate
– The Poisson distribution is often used for random arrivals
Poisson Distribution
Average arrival rate is known
Average arrival rate is constant for some number of time
periods
Number of arrivals in each time period is independent
As the time interval approaches 0, the average number of
arrivals approaches 0
λ = the average arrival rate per time unit
P(x) = the probability of exactly x arrivals occurring
during one time period
P(X = k)= tk
e- t
k!
Continued ---
Where
= mean arrival rate per time unit.
t = the length of the interval.
e = 2.7182818 (the base of the natural logarithm).
k! = k (k -1) (k -2) (k -3) … (3) (2) (1).
Continued --
Example1 : Customers arrive at X store is according to a Poisson
distribution. Between 8:00 and 9:00 A.M. an average of 6 customers
arrive at the store. What is the probability that k customers will arrive
between 8:00 and 8:30 in the morning (k = 0, 1, 2,…)?
• Input to the Poisson distribution
= 6 customers per hour.
t = 0.5 hour.
t = (6)(0.5) = 3.
k !(3)
= 0.224042
Continued ---
• Example 2: In a factory, the machines break down and require service
according to a Poisson distribution at the average of four per day.
What is the probability that exactly six machines break down in two
days?
• Solution: Given λ = 4, k = 6, t =2
• P(n, t) = P(6, 4) when λ = 4
• we know, P(K, t) = t k
e- t
k!
p(6,4) = e-
6!
= e
720
= 0.1221
Continued ---
Example 3: On an average, 6 customers arrive in a coffee shop per hour.
Determine the probability that exactly 3 customers will reach in a 30
minute period, assuming that the arrivals follow Poisson distribution.
The Waiting Line Characteristics
• Factors that influence the modeling of queues
…
…
k
k
For
Forkkservers
servers
For
Forone
oneserver
server Each
Eachwith
with
with service rates
with service rates service rate of
service rate of
Steady State Performance Measures
The symbols and notations used in queuing system are as follows:
n= Number of customers in the system (both waiting and in service).
= Average number of customers arriving per unit of time.
μ=Average number of customers being served per unit of time.
/ μ = P, traffic intensity.
C = Number of parallel service channels (i,e., servers).
Ls = Average or expected number of customers in the system (both waiting and
in service).
Lq = Average or expected number of customers in the queue.
Ws = Average waiting time in the system (both waiting and in service).
Wq= Average waiting time of a customer in the queue.
Pn = Time independent probability that there are n customers in the system
(both waiting and in service).
Pn (t) = Probability that there are n customers in the system at any time t(both
Little’s Formulas
Little’s Formulas represent important relationships
between L, Lq, W, and Wq.
These formulas apply to systems that meet the
following conditions:
– Single queue systems,
– Customers arrive at a finite arrival rate and
– The system operates under a steady state condition
– L =W Lq = Wq L = Lq +
9. Traffic intensity,
=
10. Probability that there is at least one customer or queue is busy,
Pb = 1- P0
Continued ---
Example 1: Customers arrive at Shoes center every 12 minutes on the
average, according to a Poisson process. Service time is exponentially
distributed with an average of 8 minutes per customer. Management is
interested in determining the performance measures for this service system.
Solution :Input
= 1/12 customers per minute = 60/12 = 5 per hour.
= 1/ 8 customers per minute = 60/ 8 = 7.5 per hour.
Performance Calculations
– P0 = 1 - () = 1 - (57.5) = 0.3333 Pw = =0.6667
– Pn = [1 - ()]()n = (0.3333)(0.6667)n = =0.6667
– Ls = ( - ) = 2
– Lq = 2[( - )] = 1.3333
– Ws = 1( - ) = 0.4 hours = 24 minutes
– Wq = ( - )] = 0.26667 hours = 16 minutes
Continued ---
Example 2: Consider a situation where the mean arrival rate (l) is one
customer every 4 minutes and the mean service time (m) is 2½ minutes.
Calculate the average number of customers in the system, the average
queue length and the time taken by a customer in the system and the
average time a customer waits before being served
Example 3: Trucks at a single platform weigh-bridge arrive according to
Poisson probability distribution. The time required to weigh the truck
follows an exponential probability distribution. The mean arrival rate is
12 trucks per day, and the mean service rate is 18 trucks per day.
Determine the following:
(a) What is the probability that no trucks are in the system?
(b) What is the average number of trucks waiting for service?
(c) What is the average time a truck waits for weighing service to begin?
(d) What is the probability that an arriving truck will have to wait for
service?
Continued ---
Example 4: A TV repairman finds that the time spent on his jobs has a
exponential distribution with mean 30 minutes. If he repairs TV sets
in the order in which they come in, and if the arrivals follow
approximately Poisson distribution with an average rate of 10 per 8
hour day, what is the repairman's expected idle time each day? How
many jobs are ahead of the average with the set just brought in?
Example 5: Auto car service provides a single channel water wash
service. The incoming arrivals occur at the rate of 4 cars per hour and
the mean service rate is 8 cars per hour. Assume that arrivals follow a
Poisson distribution and the service rate follows an exponential
probability distribution. Determine the following measures of
performance