inventory control (1)
inventory control (1)
inventory control (1)
chapter highlights
Material Requirement Planning of gear wheels. But the gear box itself is a component item
when a large equipment assembly is considered.
Material requirement planning (MRP) is the technique of
determining the quantity and timing to acquire the materi-
als demanded by the master schedule. A master schedule is Lot Size
the expression of production plan into specific products and It is the quantity of an item procured as a lot as per an order.
their requirements and it also specifies the time required for Lot size is used in a wider sense. Lot sizing is the process of
their acquisition. specifying the order size.
Similarly, as indicated by the master schedule, it is
required to determine the capacity in terms of man power Time Phasing
and in terms of machine capacity to meet the produc- It is the process of scheduling in such a way that we receive
tion objective. The technique of determining the capacity the required quantity of the material exactly at the time we
required is known as the capacity requirement planning. require it. It can also be the process of scheduling such that
we produce a certain amount of material required exactly
Explanation of Terms in MRP at the time of its requirement – it cannot be before or after.
Dependent Demand Explosion of Requirement
It is the demand of a particular item which stems out from It is the process of breaking down of the parent item to com-
the demand of a complete unit, this item being a part of ponents so that a detailed effective planning of the material
that unit. In MRP, we plan for the acquisition of dependent requirement can be done.
demand items as required by the master schedule.
Bill of Material
Parent Items and Component Items
Bill of material (BOM) is the list of all components going
When the basic parts are assembled together, we get a parent into the assembly. The list specifies the part numbers of the
item. For the parent item, the parts are the component items. components and the number of components required for the
The parent unit can be a component item for a large assem- assembly. Bill of material totally specifies the item.
bly. For example, a gear box is the assembly of a number
Chapter 3 • Material Requirement Planning and Inventory Control | 3.915
Objectives of MRP the end. In this case, there is no queuing up. The work in a
process inventory will be very minimum.
Reduction of Inventory ‘Kanban’ is an integral part of the JIT system. It is an
MRP reduces the excessive build up of an inventory. MRP instruction card designed to produce what exactly is needed
determines how many components are required, and at what at the end. This system initiates the pull. It is a demand
time they are required to meet the master schedule require- feeding process. Each preceding process will produce only
ments. If it is properly planned, then almost a correct quan- that many items as have been withdrawn. The withdrawal
tity of the material is procured and therefore, the inventory of material from the preceding process and the production
built up is reduced. of items to replace it is ordered through a withdrawal and
production Kanban (marker card).
Reduction of Manufacturing and Delivery
Lead Time
Solved Examples
MRP reduces the delay in production, as it identifies the
material required and takes appropriate steps to get it at the Example 1: The process of fixing the sequence of opera-
right time. So, the production is not suffered. It fixes the pri- tion and material flow is
orities in production and delivery. It also fixes the dates for (A) master scheduling (B) routing
the arrival of delivery of materials and products. (C) scheduling (D) expediting.
Consider two work centres A and B. Let ‘A’ be faster Unit Scheduling System
than B. Then, the products and materials queue up, before Job shop scheduling is a unit scheduling system. We may
B. To avoid queuing up, A is decelerated to synchronise with have to process varieties of jobs on different machines.
B. This is the push system. In the pull system, we pull the The plan for production can be done only after receiving
process from the end point. What is demanded at the end the order. Scheduling is to be done in such a way that the
is carried out and accordingly, the process is pulled from
3.916 | Part III • Unit 8 • Industrial Engineering
Job 2 3 5 4 1 84
Example 7: In a machine shop, eight jobs come for pro- Direction for questions 9 and 10:
cessing. The processing time for each job and the weightages
given to them are shown in the table. The minimum flow Job 1 2 3 4 5 6 7 8
time shall be Processing time 12 18 13 9 8 10 14 11
(A) 56.2 (B) 49.2 (C) 42.3 (D) 38.6. Weight 1 2 1 3 1 3 2 2
Arranging the job according to the ascending order of
the processing time.
Chapter 3 • Material Requirement Planning and Inventory Control | 3.917
A job shop has six orders at hand which are to be completed Processing Flow Due
Job Lateness
with one work centre. The processing time and the due dates time time date
are as shown. 2 8 8 10 -
Order 1 2 3 4 5 6 4 7 15 11 4
Processing time (days) 3 2 9 4 2 4 3 8 23 12 11
Due date 17 21 5 12 15 24 1 10 33 15 18
5 12 45 18 27
Example 9: Minimum average flow time is (days) 6 15 60 25 35
(A) 12.5 (B) 11.5 (C) 10.5 (D) 9.5.
7 18 78 30 48
Solution:
The sequence is 2 – 4 – 3 – 1 – 5 – 6 – 7.
Processing Flow Due
Order Lateness Example 12: The maximum lateness in the optimum sequence
time time date
(A) 32 (B) 27 (C) 48 (D) 90.
5 2 2 15 -
2 2 4 21 - Solution:
4 3 7 17 - From the table, it is clear that the maximum delay is 48. It
6 4 11 24 -
occurred in the case of job no. 7.
4 4 15 12 3 Direction for questions 13 and 14: In a work centre, the
3 9 24 5 19 number of jobs arriving in the system and their due dates
63 24 are given.
Job 1 2 3 4 5
(Arranging the orders according to the rule of shortest
processing time first) Processing time (days) 9 7 5 11 6
Due date (days) 16 20 25 15 40
63
Minimum flow time = = 10.5.
6 Example 13: As per the ‘shortest processing time’ crite-
Example 10: Total tardiness (days) rion, the average number of jobs in the system is
(A) 17 days (B) 12 days (C) 5 days (D) 22 days. (A) 3.4 (B) 3.2 (C) 2.6 (D) 1.8.
Arranging according to SPT,
Solution:
Tardiness means lateness. Processing Flow Due Job
Job
Two of the jobs are delayed. time time date lateness
No. of days of delay = 3 + 19 = 22 days. 3 5 5 25 0
Direction for questions 11 and 12: Scheduling of jobs on 5 6 11 40 0
a single machine is to be done. The processing time of each 2 7 18 20 0
job and their due dates are given below. 1 9 27 16 11
4 11 38 15 23
Job 1 2 3 4 5 6 7
38 99 34
Processing time 10 8 8 7 12 15 18
Due date 15 10 12 11 18 25 30
Solution:
Example 11: The optimal sequence which will minimise Total flow time = 99
the maximum lateness is Average no. of jobs in the system is
(A) 2 – 4 – 3 – 1 – 5 – 6 – 7
Total flow time 99
(B) 2 – 3 – 1 – 4 – 6 – 5 – 7 =
(C) 2 – 4 – 1 – 5 – 6 – 7 – 3 Total completion time 38
(D) 3 – 1 – 4 – 5 – 7 – 6 – 2. = 2.6.
Solution: Example 14: Average lateness in the system.
The minimum value of maximum lateness can be obtained by (A) 9.2 days (B) 8.6 days (C) 7.5 days (D) 6.8 days.
arranging the jobs according to the earliest due date (EDD). Solution:
Job 2 4 3 1 5 6 7 Total lateness = 34 days.
Processing time 8 7 8 10 12 15 18 34
Average lateness = = 6.8 days.
Due date 10 11 12 15 18 25 30 5
3.918 | Part III • Unit 8 • Industrial Engineering
Direction for questions 15 and 16: In a job centre, there Direct inventories are those materials that become the
are six jobs at hand. The jobs, their processing time and due integral part of the final product. The raw material, semi–
dates are as shown in the chart: finished goods etc. are direct inventories whereas, fuel,
cleaning agents, lubricants etc. are indirect inventories.
Job 1 2 3 4 5 6
Inventory control is a planned scientific approach by
Processing time 8 6 9 7 4 5 which we decide when to purchase, how much to purchase
Due date 10 12 20 32 36 40 and how much to store so that the cost is minimum. At the
same time, there should be no interruption in the process of
Example 15: As per the ‘earliest due date’ criterion, the production.
average number of jobs in the system is
(A) 4.2 days (B) 3.8 days (C) 3.2 days (D) 2.9 days. Purpose of Inventory Control
Solution: •• During fluctuating demand, the inventory helps in main-
Arranging the jobs as per the earliest due date (EDD), taining economy by absorbing the fluctuations.
•• It helps in smooth and efficient running of an organisation.
•• Service is provided at short notice when an inventory is
Processing Flow Due
Job
time time date
Lateness maintained.
•• When there are shop rejections or delay in the raw materi-
1 8 8 10 -
als, it acts as a buffer stock.
2 6 14 12 2
•• Product cost is reduced because of long, uninterrupted
3 9 23 20 3 production runs and batching.
4 7 30 32 - •• Because of the inventory, bulk purchases can be met and
5 4 34 36 - the clerical cost be reduced.
6 5 39 40 -
In the case of raw material inventory, the basic question
39 148 5 is (a) when should the order be placed for the material?
(b) how much should be procured through the order?
Total flow time = 148
Total completion time = 39 Costs Associated with Inventory
148
Number of jobs at hand = = 3.8 days. There are two costs associated with an inventory. When
39 we are trying to reduce one cost, the other cost increases.
Example 16: Average job lateness is Therefore, we have to strike a balance between these
(A) 0.83 days (B) 1.6 days (C) 3.2 days (D) 4.1 days. costs. Therefore, inventory control becomes an operations
research problem.
Solution: The costs are:
Total lateness Holding Cost or Inventory Carrying Cost
Average lateness=
Number of jobs
This is the cost involved in keeping the goods in the store.
5 When there is an under stock, we have to see that it is main-
= 0.83 days. tained properly, (according to its nature), so that it will be
6
available at a required quality at the time of requirement.
Inventory Control Moreover, the holding cost depends on its size and the
time for which it is to be stored. It indicates the space and
Inventory may be defined as the quantity of economic
time that we should have to maintain it. It involves cost.
resources (goods) stored at any point of time or remaining
Generally, holding cost includes the following:
idle at any point of time. The variables in inventory control
are: 1. Storage cost
2. Handling cost
1. Raw materials
3. Depreciation cost
2. Semi finished goods
4. Rent and capital cost
3. Finished products
5. Administrative cost etc.
4. Machinery
5. Fixtures and furniture etc. Ordering Cost (Set Up Cost)
Inventories are broadly classified in to: This is the sum of the various costs involved in placing the
1. Direct inventory order for a material. All the purchase formalities are cost –
2. Indirect inventory. involved. It includes
Chapter 3 • Material Requirement Planning and Inventory Control | 3.919
Uncontrollable Variables
Total cost (C)
It is difficult to have a single model to evaluate the The minimum average cost per unit time is
inventory costs and quantities which take into account
all the variations. Therefore, inventory models are classi- Co = 2C1C2 r .
fied into two major categories on the basis of demand i.e., The total minimum cost per unit time, where C is the cost
deterministic models and probabilistic models. The other per unit of the item is
categories are models with price breaks and models with
restrictions. = 2C1C2 r + Cr.
Time
Inventory
t1 t2 t3 t4 t5
P T
q = rt
The total time period T is given as the sum of the time
intervals t1, t2, ….. tn.
Time Holding cost for time period T is
O A
t
⎛1 ⎞ ⎛1 ⎞ ⎛1 ⎞ ⎛1 ⎞
⎜⎝ qt1 ⎟⎠ C2 + ⎜⎝ qt 2 ⎟⎠ C2 + ⎜⎝ qt3 ⎟⎠ C2 + …. + ⎜⎝ qt n ⎟⎠ C2
2 2 2 2
C2 = inventory holding cost of one unit per unit time. 1
= qC2 (t1 + t 2 + …t n )
C1 = ordering cost per order. 2
1 1
∴ Inventory holding cost during time t = C2 R t2 = qTC2
ordering cost per order = C 2 2
1
D
1 Ordereing cost = N .C1 = C1 ⋅
∴ Total cost during time t = C Rt2 + C1 q
2 2
∴ Average total cost per unit time 1 D
∴ Total cost = qC2T + C1
1 2 q
C(t) = C2 Rt2 + C1
2 2C1 ( D /T )
The optimum lot size = qo =
∴ The optimum time interval to place an order is C2
2C1
to = Minimum total cost = 2C1C2 ( D /T )
C2 r
Deterministic Model 1(c)
By multiplying with r, we get the optimum quantity to
order during each order. In this model, the demand rate is uniform, lead time is not
zero i.e., the production rate is finite and shortages are not
2C1r allowed. The production rate should be higher than the con-
∴ qo = r to =
C2 sumption rate to provide an inventory.
r = number of units consumed per unit time
where, qo is called the optimum lot size or economic
k = number of units produced per unit time
order quantity.
C1 = ordering cost
Chapter 3 • Material Requirement Planning and Inventory Control | 3.921
C2 = inventory holding cost per item per unit time. procurement of raw materials. Often, the quantity produced
q = rt = number of items produced per run exceeds the quantity which can be sold. Therefore, the opti-
t = interval between runs. mum lot size that is to be produced in one batch is to be
determined. It is known as economic lot size or economic
Inventory batch size.
Economic batch size is also given by the formula
2C1r
Slope r Slope k − r Q=
q C2
Im
where, C1 represents the set up cost. It is the cost of set
Time up to be made for one batch production.
t1 t2 t3 C2 = inventory carrying cost per unit per year and r = the
T annual anticipated demand for the quantity produced.
Example 17: A company manufactures a product which
t1 is the time taken to build up the stock with a constant has a monthly demand of 4000 units. The product requires a
rate k – r and t2 is the time taken to consume the stock dur- component ‘A’ priced H20. Every product requires one unit
ing which there is no production rate and the inventory of ‘A’. The ordering cost for the component is H120/order
decreases at a constant demand rate r. and the holding cost is 10%/annum/unit.
Im is the maximum inventory at the end of time t1. The economic order quantity is
(A) 2400 units (B) 2600 units
∴ Im = (k – r)t1 (C) 3200 units (D) 3600 units.
Total quantity produced during t1 is q and quantity con-
sumed during t1 is rt1. Solution:
Given, demand (r) = 4000 monthly = 4000 × 12 annually
⎛ rI ⎞ Ordering cost = H120.
∴ I m = q − rt = q − ⎜ m ⎟
⎝ k − r⎠ Inventory carrying cost is 10% of 20 = H2.
⎛ k − r⎞ 2 × 120 × 4000 × 12
∴ Im = ⎜ q.
⎝ k ⎟⎠ ∴ EOQ =
2
1
Total cost per unit time C(Im, t) = I .C + ⎛ C1 ⎞ = 144 × 40000
2 m 2 ⎜⎝ t ⎟⎠
= 12 × 200 = 2400 units.
1⎛k −r ⎞ ⎛C ⎞ Direction for questions 18 to 20: A firm has a monthly
∴ C ( q, t ) = ⎜ ⋅ q⎟ C 2 + ⎜ 1 ⎟
2⎝ k ⎠ ⎝ t ⎠ demand for a material equal to 5000 units. The ordering
cost is evaluated to be H225/order. The inventory carrying
1 ⎛ k − r⎞ C1r
= ⎜⎝ ⎟⎠ C2 .q + cost is 5% of the unit price of the material. Unit price of the
2 k t material is H60.
2C1 rk Example 18: The EOQ is
Optimum lot size = qo = .
C2 k − r (A) 2600 units (B) 3000 units
(C) 3200 units (D) 3600 units
k −r
Optimum average cost/unit time = Co = . 2C1 C2 r
k Solution:
NOTE 2C1r
EOQ =
C2
When k = r, Co = 0 ⇒ no holding cost and no set-up cost.
When k = ∞ ⇒ production rate is infinite i.e., model 1(a) r = 5000 × 12 = 60000
C1 = H225/order
Economic Batch Production C2 =
5
× 60 = H3.
Production managers have to decide very often what quan- 100
tity of the product must be produced, against the demand.
2 × 225 × 5000 × 12
If large quantities are produced and they are not sold out ∴ EOQ =
immediately, the task of holding the inventory in the store 3
arises. Therefore, a similar situation arises in the case of = 20000 × 225 × 2
production of goods as well, which is identical to that of the
3.922 | Part III • Unit 8 • Industrial Engineering
Example 21: A company has an annual demand of 400 Direction for examples 23 to 25: A company requires 1500
units of a product. The ordering cost per order is H50. The items/month at a price of H27. The ordering cost is H200 and
cost per item is H10 and the carrying cost is 15% of the unit the inventory carrying cost is 20% of the average inventory.
cost of the item. The total minimum cost is Example 23: The economic order quantity is
(A) H523 (B) H416 (C) H380 (D) H245. (A) 1155 (B) 1276 (C) 1315 (D) 1385.
Solution: Solution:
The total cost can be directly found from the formula Annual demand = 1500 × 12.
= 2rC1C2 Ordering cost C1 = 200.
Ordering cost C1 = 50. Inventory carrying cost is 20% of 27.
Inventory carrying cost = 15% of H10 Average inventory of 20% is the same as 20% of the unit cost.
= H1.5. ∴ Inventory carrying cost = H5.4.
(A) 12 (B) 14 (C) 16 (D) 18. Direction for questions 26 to 28: An inventory problem is
as given below. Annual demand for a product = 36000.
Solution:
Cost/unit = H1
Annual demand is 18000 units.
Ordering cost = H25/order
EOQ = 1155.
Lead time = 15 days
18000 18000 Store charge = 5% of unit cost
∴ Number of orders = ≈ 16 orders. ≈ ≈ 16 orders.
1155 1155 Cost capital = 15%
Safety stock – one month’s consumption.
Example 25: If 1400 numbers are procured at a time the
company can avail a discount of 2% in the price. If the Example 26: The EOQ is (units)
company goes for the option of purchasing 1400 nos./order (A) 2500 (B) 2800 (C) 3000 (D) 3500.
avoiding EOQ, then the saving for the company is
(A) H11000 (B) H9604 (C) H8980 (D) H8430. Solution:
t1 I m t 2 q − 1m
= and = Solved Examples
t q t q
Total cost during time t Direction (29, 30): The demand for an item is 25 numbers/
month. The set up cost for production is H30/batch. The
1 1
= I m t1C2 + ( q − I m ) t 2C p + C1 inventory carrying cost/unit/month is H1/2. The shortage
2 2 cost is evaluated to be H3/unit/month.
2C1r ⎛ C p + C2 ⎞ Example 29: Then EOQ is
Optimum lot size = qo =
C2 ⎜⎝ C p ⎟⎠ (A) 60 units (B) 75 units (C) 85 units (D) 95 units.
Solution:
Deterministic Model 2(b) ECQ =
2C1r
This model has similar conditions as model 2(a), but the ⎛ Cp ⎞
C2 ⎜ ⎟
time period t is variable. ⎝ C2 + C p ⎠
The optimum quantity per order is given by,
C1 = H30, r = 25 × 12 = 300/annum
2rC1 ⎛ C p + C2 ⎞ C2 = 0.5 × 12 = H6, Cp = H3
q=
C2 ⎜⎝ C p ⎟⎠
2 × 30 × 25 × 12
EOQ = = 95 units.
⎡ 3 ⎤
The re-order time t =
(
2C1 C p + C2 ) 6⎢
⎣ 6 + 3 ⎥⎦
rC2C p
Example 30: The time between two consecutive batch pro-
C2 ductions is
The minimum cost Cmin = 2C1C2 r (A) 1.5 months (B) 2 months
C p + C2
(C) 3 months (D) 4 months.
Chapter 3 • Material Requirement Planning and Inventory Control | 3.925
Solution:
1000 × 6000 6000 × 1000
300 = =
Number of batches per annum = ≈ 4 batches. ⎡ 5 ⎤ ⎡ 20 ⎤ 40 20
95 8⎢ ⎥ ⎢ ⎥ ×
⎣ 6 ⎦ ⎣ 28 ⎦ 6 28
1
Time between the batches = × 12 = 3 months.
4 6000
= = 1123.
Example 31: A firm has an annual demand for a product 2857
at the rate of 1000 units. The cost of ordering is H100/order.
The carrying cost is also H100/unit/year. The stock out cost In real situations, the probability distribution of future
is evaluated to be H300. Everytime, the item is out of stock. demand is usually determined rather than the exact demand
The quantity to be stocked (in units) is itself. The expected costs are obtained and minimised
(A) 68 (B) 61 (C) 52 (D) 46. instead of the actual costs.
Solution:
r = 1000 Probabilistic Model
C1 = 100 In this model, the demand is instantaneous, setup costs are
C2 = 100 zero, discrete stock levels and lead time are zero. The two
Penalty cost Cp = 300. types of costs involved are over-stocking cost and under-
The economic stock level is stocking cost.
Let r = discrete demand rate with probability Pr
2C1r Im = discrete stock level for the time interval t
=
⎧ Cp ⎫ t = constant interval between the orders
C2 ⎨ ⎬
⎩ Cp + C2 ⎭ Ch = unit carrying cost, S = selling price of the unit
C = cost price of the unit, V = salvage value
2 × 100 × 1000 2 × 100 × 1000 Co = over-stocking cost = C + Ch – V
= = Cu = under-stocking cost = S – C – Ch / 2 + Cs
⎧ 300 ⎫ 3
100 ⎨ ⎬ 100 × Cs = unit shortage cost.
⎩100 + 300 ⎭ 4
If any of the values is not given, it is taken as zero.
8 × 100 × 1000 8000
= =
300 3 Inventory
= 52 units. r ≤ Im
r
Example 32: In a manufacturing unit, the production rate
Im
of a commodity is 36000/annum; the annual demand is only
6000 units/annum. The set up cost for batch production is Im − r
H500. The inventory carrying cost/unit/year H8. The penal- Time
ty cost, if shortage occurs is H20. Then, the economic batch t
size of production is
(A) 1123 (B) 324 (C) 2510 (D) 937.
Solution: Inventory
As the demand is only 6000 units and the production rate is
36000 units, the carrying cost is applicable to 36000 – 6000
r > Im
units only. The corresponding batch size is, Im
r
2C1r Time
Q= r − Im
⎡ r ⎤ ⎡ Cp ⎤
C2 ⎢1 − ⎥ × ⎢ ⎥
⎣ p ⎦ ⎢⎣ C2 + C p ⎥⎦ t
2 × 500 × 6000
=
⎡ 6000 ⎤ ⎡ 20 ⎤ The two cases where the optimum inventory Im has to be
8 ⎢1 −
⎣ 36000 ⎥⎦ ⎢⎣ 20 + 8 ⎥⎦ determined are r ≤ Im and r > Im.
There are no shortages when r ≤ Im and shortages occur
when r > Im.
3.926 | Part III • Unit 8 • Industrial Engineering
The cumulative values of the probability distribution are Types of Inventory Control
determined and the ratio Cu /(Cu + Co) is determined. The
optimal order quantity Imo is calculated by computing.
Selective Inventory Control
In inventory management, some items are very important
Cu and given special attention on the basis of usage, lead
Pr ≤ I m −1 < < Pr ≤ I m
Cu + Co time, technical problems, costs involved etc. All items
of the inventory need not and cannot be controlled with
Safety Stock equal attention. For this reason, the Management gives
The excess stock maintained during the lead time demand is different items, different priorities for their control and
called as the safety or buffer or cushion stock. management.
1. ABC Analysis (always better control): It is based
Determination of Safety Stock on Pareto’s Law – A few high usage items constitute
•• Safety stock = (maximum lead time – normal lead time) a major part of the capital whereas, bulk of the items
× average demand. in an inventory having low usage value constitute
•• According to the standard deviation of the forecast error, insignificant part of the capital. The inventory items
safety stock = Z × standard deviation. are categorised into A, B and C categorises based on
•• Z is the value given by the service level. the usage value in monetary terms.
•• Mean absolute deviation (MAD) is also used to calculate
safety stock. Usage value Item no.
A 60 – 70% 10 – 20%
SS = safety stock = k.MAD
B 30 – 40% 40 – 50%
∏
where, k = service factor = ⋅Z C 10 – 20% 60 – 70%
2
2. VED (vital essential desirable): Items are categorised
∏
∴ SS = ⋅ Z ⋅ MAD. on the basis of the criticality of the inventory for the
2 production system.
Implications of Safety Stock 3. HML analysis (high medium low): The classification
of items is on the basis of the unit costs involved. It is
1. Safety stocks are used when the lead time of similar to ABC control.
manufacturing is too long and is difficult to meet the 4. SDE analysis (scare difficult easy): Classification of
customer demand. items is done according to the ease or difficulty of the
2. It is used as a buffer to protect the organisation when availability of the item.
there is a rise in the demand during the lead time. 5. S-OS analysis (seasonal-S, off seasonal-OS): Items
3. Increase in safety stock increases the inventory are classified according to the nature of availability of
holding cost. Therefore, it is necessary to have a the inventory items depending on seasonal demand/
minimum safety stock. availability.
4. Lean manufacturing, just in time methods, have the 6. XYZ analysis: Classification is done on the basis of
least amount of safety stocks. Enterprise resource closing inventory values. X items have high closing
planning also reduces the safety stock of an inventory values, Z items have a low value while Y
organisation. items have in-between value. This analysis helps to
reduce the capital investment in X items.
Service Level 7. FNSD analysis: Items are categorised on the basis
The amount of safety stock required is dependent on the of their consumption rate:
service level required by the organisation. A 98% service F – fast moving items (high consumption)
level means that the demand has a 2% of chance to exceed N – normal moving items
the re-order level during the lead time. Safety stock can be S – slow moving items
calculated as D – dead stock
safety stock = z. sx = 2.055 sx
Periodic Review System
z = 2.055 for 98% service level from the normal distribu-
tion tables. Two-bin System or Q-system or Perpetual
sx = Standard deviation of random demand during lead Inventory System
time (x). In this type of inventory control, a fixed size of the order
X = Expected demand during the lead time is placed whenever the depleting stock level of the item
∴ Re-order point = X + 2.055 sx. reaches the re-order level. The time interval between the
Chapter 3 • Material Requirement Planning and Inventory Control | 3.927
orders is not fixed, but the order quantity is fixed. This is The two types of periodic review systems commonly
named two-bin because it is divided into two bins, the first used are – Fixed order cycle system and sS system.
bin is from the receiving of goods to the placement of order
whereas, the second bin contains the stock required to meet Fixed Order Quantity System
the demand during the lead time. This system is based on These are the situations in which the demand is assumed to
three parameters: re-order level, economic order quantity be fixed and known exactly. These are also called economic
and safety stock. lot size models or economic order quantity models.
Exercises
Practice Problems 1 Job 1 2 3 4 5 6
Direction for questions 7 to 9: A job shop has to schedule Direction for questions 12 to 15: Following are the details
six jobs, the details of which are as follows. of six jobs for a workshop which are to be scheduled.
3.928 | Part III • Unit 8 • Industrial Engineering
Jobs 1 2 3 4 5 6 Direction for questions 17 and 18: The annual demand for
Processing time (days) 10 8 7 11 12 9
a product is 2,400 units. The cost of placing the order is
H100/order. The storage cost is 24% of the unit cost. The
Due date (days) 12 24 32 8 15 40
price break as proposed by the supplier is
12. When it is scheduled as per the shortest processing Qty Price/unit
time, the average tardiness is
(A) 20.32 days (B) 18.62 days 0 < 500, H10
(C) 16.83 days (D) 15.65 days. 500 < Q H9
13. The number of jobs, on an average, with the workshop 17. The economic order quantity is
at any point of time is (A) 500 (B) 447
(A) 5.23 (B) 4.87 (C) 4.23 (D) 3.19. (C) 471 (D) 480
14. When the jobs are arranged according to earliest due 18. The number of orders per year is
date and schedule, the average tardiness is (A) 6 (B) 5
(A) 12.86 (B) 13.67 (C) 14.12 (D) 15.22. (C) 3 (D) 2.
15. The average number of jobs in the system when sched- Direction for questions 19 and 20: For a product, the
uled as per the earliest due date criterion is annual consumption rate is 5000 units. Unit cost is H1. The
(A) 5.6 jobs (B) 4.8 jobs set up H cost for a batch is H12/run. Inventory carrying cost
(C) 4.2 jobs (D) 3.7 jobs. is 0.25/units/year.
16. A company requires raw material at the rate of 85000 From the records, the past lead times were founds to be
tonnes/annum. The cost of placing an order is on an 16 days, 14 days, 18 days, 13 days, 14 days.
average H1500/order. When the item reaches the stores 19. The economic batch size is
the holding cost/ton/year is H60. Then the economic (A) 842 units (B) 741 units
order quantity is (C) 693 units (D) 524 units
(A) 3410 t (B) 3075 t
order order 20. The Re–order level shall be
t t (A) 312 units (B) 279 units
(C) 2061 order (D) 1098 order (C) 242 units (D) 212 units
The minimum mean flow time is 6. The sequence of working which will minimise the
(A) 17.32 (B) 16.81 (C) 15.26 (D) 14.67. maximum lateness is
(A) 2 – 4 – 1 – 3 – 6 – 5 – 7
Direction for questions 4 and 5: The population in five (B) 2 – 1 – 4 – 1 – 5 – 6 – 7
towns and the demand of a household product in the towns (C) 2 – 3 – 4 –1 – 5 – 6 – 7
are as follows. (D) 3 – 2 – 5 – 1 – 4 –3 – 7.
Chapter 3 • Material Requirement Planning and Inventory Control | 3.929
25. In an assembly line, there are seven workmen doing 28. The minimum total cost for item x is
the work in series. They take time as 20 min, 25 min, (A) H8618 (B) H8112
17 min, 18 min, 22 min, 19 min, 21 min. The balance (C) H7956 (D) H7350.
delay for the assembly line is 29. The demand for an item is in a uniform rate of 300
(A) 18.8% (B) 17.6% units/year. The cost price of each item is H50. The
(C) 16.8% (D) 15.2%. inventory carrying cost/unit/year is H6. The set up cost
is evaluated to be H30/set up. The number of times in
Direction for questions 26 to 28: A company proposes to
an year the batch production must be made, for least
purchase 2 items ‘x’ and ‘y’ from two vendors. The order-
cost of production is
ing cost for both are H400 each. The unit price of item x is
(A) 4 (B) 5
H60 and that of item y is H80. The inventory carrying cost
(C) 6 (D) 7.
is 15% of the unit price/unit/year. The annual demands for x
and y are 10000 and 20000, respectively. 30. The demand for an item annually is 10000 units. The
ordering cost is H200 and the inventory carrying cost is
26. EOQ of an item x is
20% of the cost price. The unit price of the commodity
(A) 927 nos. (B) 943 nos.
is H100. If there is a penalty cost of H150 for the short-
(C) 1012 nos. (D) 1087 nos.
age, then the economic order quantity is
27. EOQ of an item y is (A) 523 (B) 476
(A) 1155 nos. (B) 1218 nos. (C) 412 (D) 365.
(C) 1326 nos. (D) 1372 nos.
(A) 447 (B) 471 12. A set of 5 jobs is to be processed on a single machine.
(C) 500 (D) ≥ 600. The processing time (in days) is given in the table
7. A stockist wishes to optimise the number of perish- below. The holding cost for each job is HK/day.
able items he needs to stock in any month in his store. [2008]
The demand distribution for this perishable item is: Job Processing time
[2006] P 5
Demand (in units) 2 3 4 5 Q 2
Probability 0.10 0.35 0.35 0.20 R 3
S 2
The stockist pays H70 for each item and sells each at
T 1
H90. If the stock is left unsold in any month, he can
sell the item at H50 each. There is no penalty for the A schedule that minimises the total inventory cost is
unfulfilled demand. To maximise the expected profit, (A) T-S-Q-R-P (B) P-R-S-Q-T
the optimal stock level is: (C) T-R-S-Q-P (D) P-Q-R-S-T.
(A) 5 units (B) 4 units
(C) 3 units (D) 2 units. 13. Six jobs arrived in a sequence as given below:[2009]
8. Capacities of production of an item over three con- Jobs Processing time (days)
secutive months in regular time are 100, 100 and 80 I 4
and in overtime are 20, 20 and 40. The demands over II 9
those 3 months are 90, 130 and 110. The cost of pro- III 5
duction in regular time and overtime are H20/item and
IV 10
H24/item, respectively. Inventory carrying cost is H2/
item per month. The levels of starting and final inven- V 6
tory are nil; backorder is not permitted. For minimum VI 8
cost of the plan, the level of planned production in
overtime in the third month is [2007] Average flow time (in days) for the above jobs using
(A) 40 (B) 30 (C) 20 (D) 0. shortest processing time rule is
(A) 20.83 (B) 23.16
9. The maximum level of inventory of an item is 100 (C) 125.00 (D) 139.00.
and it is achieved with infinite replenishment rate.
The inventory becomes zero over one and half month 14. The Annual demand for certain window frames is
because of the consumption at a uniform rate. This 10000. Each frame costs H200 and the ordering cost
cycle continues throughout the year. The ordering is H300/order. The inventory holding cost is H40/
cost is H100/order and the inventory carrying cost frame/year. The supplier is willing to offer 2% dis-
is H10/item/month. Annual cost (in H) of the plan, count if the order quantity is 1000 or more, and 4% if
neglecting the material cost, is [2007] the order quantity is 2000 or more. If the total cost is
(A) 800 (B) 2800 to be minimised, the retailer should [2010]
(C) 4800 (D) 6800. (A) order 200 frames every time
(B) accept 2% discount
10. In a machine shop, pins of 15 mm diameter are pro- (C) accept 4% discount
duced at a rate of 1000/month and the same is con- (D) order Economic Order Quantity.
sumed at a rate of 500/month. The production and
consumption continue simultaneously till a maximum Direction for questions 15 and 26: Four jobs are to be
inventory is reached. Then, the inventory is allowed to processed on a machine as per the data listed in the table.
reduce to zero becasue of consumption. The lot size
Processing time Due
of the production is 1000. If backlog is not allowed, Job
(days) date
the maximum inventory level is [2007]
1 4 6
(A) 400 (B) 500 (C) 600 (D) 700.
2 7 9
11. The net requirements of an item over five consecutive
3 2 19
weeks are 50-0-15-20-20. The inventory carrying cost
and ordering cost are H1/item/week and H100/order, 4 8 17
respectively. The starting inventory is zero. Use ‘least
unit cost technique’ for developing the plan. The cost 15. If the earliest due date (EDD) rule is used to sequence
of the plan (in H) is [2007] the jobs, the number of jobs delayed is [2010]
(A) 200 (B) 250 (C) 255 (D) 260. (A) 1 (B) 2 (C) 3 (D) 4.
3.932 | Part III • Unit 8 • Industrial Engineering
16. Using the shortest processing time (SPT) rule, total (A) 4.5 days (B) 4.5 months
tardiness is [2010] (C) 6.8 days (D) 6.8 months.
(A) 0 (B) 2 (C) 6 (D) 8. 21. Demand during the lead time with associated prob-
17. The word kanban is most appropriately associated abilities is shown below: [2014]
with [2011]
Demand 50 70 75 80 85
(A) economic order quantity
(B) just-in-time production Probability 0.15 0.14 0.21 0.20 0.30
(C) capacity planning
Expected demand during the lead time is _____.
(D) product design.
22. Annual demand of a product is 50,000 units and the
18. A component can be produced by any of the four pro-
ordering cost is `7000 per order. Considering the basic
cesses I, II, III and IV. The most economical process
economic order quantity model, the economic order
for producing a batch of 100 pieces is [2014]
quantity is 10,000 units. When the annual inventory
Fixed cost Variable cost per cost is minimized, the annual inventory holding cost
Process
(in H) piece (in H) (in `) is ______. [2015]
I 20 3 23. The annual requirement of rivets at a ship manufac-
II 50 1 turing company is 2000 kg. The rivets are supplied in
III 40 2 units of 1 kg costing `25 each. If it costs `100 to place
IV 10 4 an order and the annual cost of carrying one unit is
9% of its purchase cost, the cycle length of the order
(A) I (B) II (C) III (D) IV. (in days) will be ______. [2015]
19. Consider the following data with reference to elemen- 24. The annual demand for an item is 10,000 units. The
tary deterministic economic order quantity model: unit cost is `100 and inventory carrying charges are
[2014] 14.4% of the unit cost per annum. The cost of one
procurement is `2000. The time between two con-
Annual demand of an item 100000 secutive orders to meet the above demand is ______
Unit price of the item (in H) 10 month(s). [2016]
Inventory carrying cost per unit per year (in H) 1.5 25. A food processing company uses 25,000 kg of corn
Unit order cost (in H) 30 flour every year. The quantity-discount price of corn
flour is provided in the table below:
The total number of economic orders per year to meet
Quantity (kg) Unit price (`/kg)
the annual demand is _____.
1–749 70
20. A manufacturer can produce 12000 bearings per
day. The manufacturer received an order of 8000 750–1499 65
bearings/day from a customer. The cost of holding a 1500 and above 60
bearing in stock is H0.20/month. The set-up cost per
production run is H500. Assuming that there are 300 The order processing charges are `500/order. The
working days in a year, the frequency of production handling plus carry-over charge on an annual basis
run should be [2014] is 20% of the purchase price of the corn flour per kg.
The optimal order quantity (in kg) is _______.[2016]
Chapter 3 • Material Requirement Planning and Inventory Control | 3.933
Answer Keys
Exercises
Practice Problems 1
1. C 2. A 3. B 4. B 5. C 6. A 7. B 8. A 9. D 10. B
11. A 12. C 13. D 14. B 15. D 16. C 17. A 18. B 19. C 20. B
Practice Problems 2
1. B 2. C 3. D 4. A 5. B 6. C 7. D 8. D 9. B 10. A
11. C 12. A 13. B 14. C 15. D 16. A 17. B 18. C 19. A 20. C
21. A 22. B 23. C 24. A 25. A 26. B 27. A 28. D 29. C 30. B