4Me-04:Industrial Engineering: DR Alok Khatri Associate Professor, Department of Mechanical Engineering
4Me-04:Industrial Engineering: DR Alok Khatri Associate Professor, Department of Mechanical Engineering
ENGINEERING
Dr Alok Khatri
Associate Professor,
Department of Mechanical Engineering
Contents of Section 3
• Materials Management and Inventory Control: Field and scope of
 material management, Material Requirement Planning and
 programme, Inventory Control: Classification of Costs, Direct and
 Indirect Cost, Labour, Material and Over-Head, Prime Cost, Factory
 Cost, Fixed Cost, Variable Cost, Increment Cost, Allocation of
 Over-Head Costs, Break even Analysis, Types of Inventories,
 Determining Economic Order Quantity (EOQ), Quantity Discounts,
 Lead Time and Re-order Level, ABC, VED, FSN Models, Re-order
 Cycle Systems, Procedure for Purchase and Storage.
                   Material Management
                               Definition
   It is concerned with planning, organizing and controlling the flow of
materials from their initial purchase through internal operations to
the service point through distribution.
                                     OR
 To get
  1. The Right quality
  2. Right quantity of supplies
  3. At the Right time
  4. At the Right place
  5. For the Right cost
PURPOSE OF MATERIAL MANAGEMENT
Primary                              Secondary
•   Right price                      •   Forecasting
•   High turnover                    •   Inter-departmental harmony
•   Low procurement & storage cost   •   Product improvement
•   Continuity of supply             •   Standardization
•   Consistency in quality           •   Make or buy decision
•   Good supplier relations          •   New materials & products
•   Development of personnel         •   Favorable reciprocal relationships
•   Good information system
Four basic needs of Material management
  Cumulative lead time: The sum of the lead times that sequential phases
  of a process require, from ordering of parts or raw materials to
  completion of final assembly.
MRP inputs: Bill of materials (BOM)
 Bill of materials (BOM):
  A listing of all of the raw materials, parts, subassemblies,
  and assemblies needed to produce one unit of a product.
   1     Leg                               Back
         Assembly                          Assembly
                            Seat
   3
Explosion Example
• How many leg assemblies are needed for 1 chair?
• How many Cross bars are needed for 5 chairs?
Periods                  0    1    2   3
Gross requirements            6   11   7   Inputs
Scheduled receipts            2    3   0
Projected on hand        10   6   0    0
Net requirements              0   2    7
                                             Outputs
Planned order receipts            2    7
Planned order releases   2    7
Other Considerations
 • Safety Stock
   • Not much for items with dependent demand
 • Lot sizing
   • Lot-for-lot ordering
   • Economic order quantity
   • Fixed-period ordering
   • Part-period model
 MRP example with Lot size=5 and LT=2
Periods                  0    1     2   3
Gross requirements            6    11   9    Inputs
Scheduled receipts            2     3   0
Projected on hand        10   6    3    4
Net requirements                   5    10
                                               Outputs
Planned order receipts             5    10
Planned order releases   5    10
MRP Steps
Example   According to bill of material, one unit of final
          item ‘ A’ requires two units of item ‘ B’ and
          four units of item ‘ C’ . Again, one unit of item
          ‘ B’ requires two units of item ‘ D’ and one
          unit item ‘ E’ . Items ‘ C’ , ‘ D’ and ‘ E’
          are purchased from different suppliers with
          various lead time. The beginning inventory levels
          of items ‘ A’ , ‘ B’ , ‘ C’ , ‘ D’             and
          ‘ E’ are 100, 0, 100, 50 and 0 respectively.
          The assembly time with items ‘ B’ and ‘ C’
          to produce final item ‘ A’ is 2 weeks. The
          assembly time with items ‘ D’ and ‘ E’ to
          produce item ‘ B’ is 1 week. The time intervals
          between ordering and receiving for items ‘ C’ ,
          ‘ D’     and ‘ E’      are 3, 2 and 1 week
          respectively. The items ‘ C’ and ‘ D’ are
          purchased with lot-for-lot (LFL) ordering policy
          but the item ‘ E’ is purchased with lot-size (LS)
          orderingpolicy. There are total five orders in the
          master production schedule (MPS).
Process of Manual Calculation
• The required quantity of final item ‘ A’      is 250 for the first order.
 The firm already has 100 units of final item in inventory. So the firm
 needs 150 units of ‘ A’ to meet the first order. For 150 units of
 ‘ A’ it requires 300 units of item ‘ B’ and 600 units of item
 ‘ C’ . Again, for 300 units of ‘ B’ the firm needs 600 units of
 item ‘ D’ and 300 units of item ‘ E’ . The inventory level of item
 ‘ D’ is 50. So, the net requirement of item ‘ D’ is 550. If the firm
 orders today for 550 units of ‘ D’ from supplier it can receive the
 order after two weeks. In the meantime the required quantity of item
 ‘ E’ will be available for lower lead time. It will takes another one day
 to produce the required quantity of item ‘ B’ with items ‘ D’ and
 ‘ E’ . In the meantime the required quantity of item ‘ C’ will be
 available. Finally, it will take another two more days to produce the
 required quantity of final item ‘ A’ with items ‘ B’ and ‘ C’ . It
 will take total five weeks to meet the first order. The first order can be
 delivered in the sixth week. So, the order no.1 can’ t be met in third week.
  This order needs another 3 more weeks to meet.
Steps of Software Algorithm (C language)
   Step 1 : Structure has been used to declare the variables of each item (item ID, item name, inventory
   level, lead time, lot size, number of item needed for each upper item, upper item ID, Number of
   lower item etc).
   Step 2 : Input the total number of level and information of each item (Bill of Materials).
   Step 3 : Input the total number of deliveries and timing & required quantity of final item for each
   delivery (Master Production Schedule).
   Step 4 : Temporary inventory level variable is used to hold the inventory level of each item
   temporarily which will be destructed after calculation.
   Step 5 : Finding out the order release date and temporary inventory level of independent item (final
   item) for each delivery
   Step 6 : Finding out the order release date and temporary inventory level of all dependent items
   (sub items) for each delivery. If an item occurs more than once it will update the temporary
   inventory level for all repeated items simultaneously.
   Step 7 : If the order release date of an item is negative it means that the Order Release falls
   before the planning period. So, the delivery can’ t be possible.
   Step 8 : Then searching for the maximum negative value of order release date among all items for
   the deliveries which are not possible. This maximum negative value yields the number of weeks/days
   required to meet the missing deliveries.
   Step 9 : For a missing delivery shift the inventory level of all items to the next delivery.
   Step 10 : Again finding out the order release date and temporary inventory level of all items for
   the remaining deliveries because of missing the delivery
Steps of Software Algorithm (C language)
 Step 11 : Repeat steps 9 and 10 for the remaining missing
 deliveries.
 Step 12 : Holding the missing deliveries in an array.
 Step 13 : Finally calculate the order release date and inventory level
 of all items for which deliveries are possible. Step 14 : Show which
 deliveries can’ t be met and the required weeks/days to meet those
 deliveries.
 Step 15 : Show the output of MRP that is the time-phased
 requirements for assemblies, parts and raw materials.
 Step 16 : Show the final inventory level of all items.
 Step 17 : Finally save the MRP output to a text file
Software Inputs
•   Enter the total number of levels: 2
•   Enter the total number of items in level-1: 2
•   Enter the items ID for levels-1: 127
•   181
•   Enter the total number of items in level-2: 2
•   Enter the items ID for levels-2:
•   148
•   201 Give the information for final item:
•   ------------------------------------------
•   ID: 101 Name: A Inventory level: 100
•   Lead time: 2
•   Give the information for item ID-127:
•   ---------------------------------------------
•   Name: B Upper item ID: 101
•   Number of lower item in the next level: 2
•   Number of item needed for each upper item: 2
•   Inventory level: 0
•   Lead time: 1
•   Give the information for item ID-181:
•   --------------------------------------------
Software Inputs
• Name: C Upper item ID: 101
• Number of lower item in the next level: 0
• Number of item needed for each upper item: 4
• Inventory level: 100
• Lead time: 3
• Lot size [Enter 32000 when ‘ lot for lot’   otherwise enter lot size]: 32000 Give the information for item
    ID-148:
•   --------------------------------------------
•   Name: D Upper item ID: 127
•   Number of lower item in the next level: 0
•   Number of item needed for each upper item: 2
•   Inventory level: 50
•   Lead time: 2
•   Lot size [Enter 32000 when ‘ lot for lot’ otherwise enter lot size]: 32000
•   Give the information for item ID-201:
•   --------------------------------------------
•   Name: E Upper item ID: 127
•   Number of lower item in the next level: 0
•   Number of item needed for each upper item: 1
•   Inventory level: 0
•   Lead time: 1
•   Lot size [Enter 32000 when ‘ lot for lot’ otherwise enter lot size]: 250 C
•   --------------------------------------------
Software Inputs
• Enter the total number of orders: 5
• In which week/day order no.1 has to be released: 3
• Number of final item required for order no.1: 250
• In which week/day order no.2 has to be released: 7
• Number of final item required for order no.1: 200
• In which week/day order no.3 has to be released: 8
• Number of final item required for order no.1: 150
• In which week/day order no.4 has to be released: 10
• Number of final item required for order no.1: 300
• In which week/day order no.5 has to be released: 12 Number of
 final item required for order no.1: 250
Software Inputs
Software Inputs
Software Outputs
Software Outputs
• VARIABLE COST: These costs tend to vary with the volume of output. Any increase
  in the volume of production results in an increase in the variable cost and vice
  versa. change in total as the level of activity changes. There is a definitive
  physical relationship to the activity measure
• Example: cost of material, cost of labour etc.
• Semi-variable Cost: The cost which does not vary proportionately but
  simultaneously can not remain stationery at all times is known as semi variable
  cost. It can also be called as semi-fixed cost.
• Example: Depreciation, repairs etc.
Classification on Variability/ Behavior of cost
Classification by Traceability
• This aspect one of the most important classification of costs, into direct
 costs and indirect costs. This classification is based on the degree of
 traceability to the final product of the firm.
• Direct Costs: So these are the costs which are easily identified with a
 specific cost unit or cost centers. Some of the most basic examples are
 the materials used in the manufacturing of a product or the labor
 involved with the production process.
• Indirect Costs: These costs are incurred for many purposes, i.e. between
 many cost centers or units. So we cannot easily identify them to one
 particular cost center. Take for example the rent of the building or the
 salary of the manager. We will not be able to accurately determine how
 to ascertain such costs to a particular cost unit.
Classification by Normality
• This classification determines the costs as normal costs and
  abnormal costs. The norms of normal costs are the costs that
  usually occur at a given level of output, under the same set of
  conditions in which this level of output happens.
• Normal Costs: This is a part of the cost of production and a part
  of the costing profit and loss. These are the costs that the firm
  incurs at the normal level of output in standard conditions.
• Abnormal Costs: These costs are not normally incurred at a given
  level of output in conditions in which normal levels of output occur.
  These costs are charged to the profit and loss account, they are not
  a part of the cost of production.
By Controllability
• CONTROLLABLE COSTS: These are the costs which can be influenced by
 the action of a specified member of an undertaking. A business
 organization is usually divided into a number of responsibility centres
 and each centre is headed by an executive. The executive can thus control
 the costs incurred in that particular responsibility centre.
Factory Cost = Prime Cost (Direct material + Direct labor + Direct Expenses) +
Factory overhead
                                PRIME COST
Prime Cost
 Direct material cost: A direct material is one which goes into a
  salable product or its use is directly essential for the completion
  of that product e.g. a HSS bit for making a turning tool for lathe,
  alloys for making alloy steels, Cloth, collar, buttons, thread for
  manufacturing an apparel etc.
• It is the point in your business transactions when profit is exactly equal to the
 costs of doing business. It is the point that above it, the business starts making
 profit (revenue exceeds costs).
• At the breakeven point: TOTAL REVENUE = TOTAL COST
Importance of BEP
•   How many units the business must produce              and sell in terms of
    manufacturing business
•   How many units to purchase and sell in the case of the merchandising
    business
•   In the services unit, the breakeven point indicates the number of billable hours
    you must work in order to cover your costs.
•   It helps in examining the effects of on-going business processes or activities
    on the organization’s profitability.
•   It helps in deciding about the substitution of new plants (and products).
•   It is an essential component of a business or marketing plan, and is normally
    incorporated in the feasibility studies.
Break Even Analysis
Income/ Profit
Average selling price per unit × Units of output produced and sold
                                          TR = PX
Total cost
                                        TC = VX + F
 Profit Equation
Profit = PX – (VX + F)
BEP (Units) = F / ( P – V)
                      BEP (Sales) = F / ( P – V) / P
                     BEP (Sales) = F / ( 1 – V/ P )
Break Even Analysis (Turn Over for profit)
  • Target volume (units) = (Fixed costs + Target profit Unit)/
                                      contribution margin
= (F + Target Profit) / ( P – V )
                               = (F + Target Profit) / ( 1 – V/ P )
                     EXAMPLE
Calculate break-even point in sales units and sales
dollars from following information:
    Price per Unit = $15
    Variable Cost per Unit = $7
    Total Fixed Cost = $9,000
                                  SOLUTION
We have,
p = $15
v = $7, and
FC = $9,000
        Substituting the known values into the formula for breakeven point in sales
units, we get:
Reorder
point
                                                                           Time
          Receive        Place    Receive   Place   Receive
          order          order    order     order   order
                             Lead time
Inventory Cycle
Main points of graph
S u p p o s e A n n u al D e m a n d
    = 1200
S u p p o se     u n its are p u rc h as e d
at a tim e , w h e re ,
    = 600
    = 400 e tc .
T h e fig u re s o n th e R H S s h o w
                                               O rd e r S iz e ,    = 400
in v e n to ry v ariatio n s fo r
d iffe re n t v alu e s o f    as su m in g
a c o n stan t a n d c o n tin u o u s
d e m an d o f 100 u n its p e r m o n th .
Average Inventory and Number of Orders
                                              O rd e r S iz e ,   = 400
A v e rag e in v e n to ry =   /2.
N u m b e r o f o rd e rs =      .
If     = 400
A v e rag e I n v e n to ry
= 400/2 = 200
                                     A v e ra g e I n v e n to ry d u rin g th e first fo u r m o n th s
                                     is ( 400+ 0) /2 = 200.
# O rd e rs = 1200/400 = 3           F o r th e n e x t fo u r m o n th s it is ag ain ( 400+ 0) /2
                                     = 200
                                     S im ilarly fo r th e last fo u r m o n th s , th e av e rag e
                                     in v e n to ry is ( 400+ 0) /2 = 200
                                     T h is m e a n s th a t th e a v e r a g e          in v e n t o r y
                                     th r o u g h o u t th e y e a r is 200.
Graphs of Various Costs
                          E O Q is th e        p o in t
                          at w h ic h A       n nu al
                          O rd e rin g          C o st
                          an d            A   n nu al
                          I n v e n to ry       C o st
                          in te rse c t.
TC and TVC Formulae
T o ta l A n n u al C o s t      = A n n u al O rd e rin g C o st           +
A n n u al H o ld in g C o s t        + A n n u a l P u rc h as e C o s t
T o ta l A n n u al V ariab le C o s t         = A n n u al O rd e rin g C o st +
A n n u al H o ld in g C o s t
EOQ Formula
I n th e e q u a tio n s fo r    an d            , th e v alu e s o f           an d     a re k n o w n .
T h e o n ly u n k n o w n v a riab le is       . O u r o b je c tiv e is to m in im iz e     .
    is m in im iz e d a t th a t v a lu e o f , w h e re ,
A n n u a l O r d e r in g C o s t = A n n u a l H o ld in g C o s t
S o lv in g th e a b o v e e q u a tio n fo r    , g iv e s th e v a lu e o f         (    ) a s s h o w n b e lo w .
EOQ Example
S u p p o se    = 1,200 u n its, = $5.00,               = $ 1.20 an d   = $ 12.00.
               fo r th is p ro b le m is g iv e n b e lo w .
Costs for Various Order Quantities
N o te th a t m in im u m c o s t is    O rd e r S iz e (   )
                                                                A n n u al O rd e rin g
                                                                                            A n nual
                                                                                          I n v e n to ry
                                                                                                            T o tal A n n u al
                                                                                                            V a riab le C o s t
                                                                         C o st
fo r      = 100 (             ).
                                                                                              C o s ts           (      )
50 $120 $ 30 $150
O rd e rin g C o st = I n v e n to ry 75 $ 80 $ 45 $125
       c an b e c a lc u late d a s
                                               125                       $ 48                 $ 75                $123
150 $ 40 $ 90 $130
T h e re c o u ld b e se v e ra l p ric e b re a k s.
Example: Quantity (Price) Discounts
T h e an n u a l d e m a n d ( ) fo r a n ite m is 240,000 u n its. T h e o rd e rin g c o st p e r o rd e r ( ) is
$ 30.00. T h e in v e n to ry c arry in g c o st p e r u n it p e r y e a r ( ) is 30% o f th e c o s t ( p ric e ) o f
th e ite m , th a t is ,   = 30% o f .
T h e e c o n o m ic o rd e r q u an tity is 4,140.
T h e o rd e r q u a n tity fo r th is e x a m p le is 4, 140
• The eight lead-time components are added to get the lead time.
Order Point Policies (OPP)
• Order point policies (OPP) define the stock level at which an order will
 be placed. The reorder point (   ), triggers an order for more stock.
• OPP systems specify the number of units to order and when to order.
IP
               Q-D(Q/P)
             P-D                D                                                    time
          TAC(Q) = Item-AC(Q) + Ordering-AC(Q)+Holding-AC(Q)
                      = C($/unit)*D(units/yr) +
                          S($/order) *D(units/yr) / Q(units/order) +
                            H($/unit x yr)*[Q*(1-D/P)*T / 2](units x yr order)*[1/T](orders/yr) =>
          Q* = [ 2*S*D / (H*(1-D/P))]1/2
Application of the EOQ theory under total quantity discounts
   • Suppose that the unit purchasing cost C depends on the ordered quantity, Q. In
   particular, C obtains a certain value, C1, if Q lies in the interval (0,Q1], C2, if Q lies
   in the interval (Q1,Q2], … , Cn, if Q lies in the interval (Qn-1,Qn], and Cn+1, if Q lies in
   the interval (Qn,). Furthermore, C1 > C2 > … > Cn > Cn+1.
   • Then, letting
                       ATC(i)(Q) = Ci*Q+S*D/Q + H(Ci)*Q/2
       where
                       H(Ci) = I*Ci and I is the applying interest rate,
   We obtain the following graphical representation for the curves ATC(i)(Q) and ATC(Q):
   ATC                                       ATC(1)
                                                      ATC(i)
ATC(n+1)
                Q1        Qi-1          Qi              Qn                                        Q
Application of the EOQ theory under total quantity discounts
• The previous plot suggests the following algorithm for computing the EOQ under total
 quantity discounts:
  • For each curve TAC(i) (Q) compute the quantity Q(i) that minimizes TAC over that curve; this can be
    done as follows:
     • Compute Q*(i) according to the standard EOQ formula while using Ci in the evaluation of H(Ci).
     • If Q*(i) belongs in the application interval for TAC(i)(Q), then set
       Q(i) = Q*(i) (since Q*(i) is a feasible point).
     • If Q*(i) lies to the left of the application interval for TAC(i)(Q), then set Q(i) = minimum of the
       application interval for TAC(i)(Q).
     • If Q*(i) lies to the right of the application interval for TAC(i)(Q), then set Q(i) = maximum of the
       application interval for TAC(i)(Q).
  • For each selected Q(i), compute the corresponding TAC(i)(Q(i)), and pick a Q(i), that provides the
    smallest TAC(i)(Q(i)) value.
• Remark: A more efficient implementation of the above algorithm is as follows:
  • Start the above computations from TAC(n+1)(Q(n+1)), and carry them on in decreasing order of i, until
    you exhaust all i’ s, or you find an interval for which Q(i) = Q*(i). In the latter case, you can ignore
    all the remaining i’ s.
                            A continuous review model with
                      probabilistic demand and constant lead time
Model Assumptions:
• Stochastic demand rate; in particular, daily demand is a random variable (r.v.)
        dd  N(Dd, d2).
• Infinite Operational Horizon, Continuous Review
• Lead time is deterministic; in particular L days.
Then,
• The             TAC is minimized by Q* = [2*S*Da/H]1/2, where
  Da = Dd * (business days in a year).
• However, setting ROP = L*Dd, will result in 50% probability of experiencing a stock-out
during every cycle!
• To see this, notice that the demand experienced over L days is
  another r.v. dL= dd(1)+dd(2)+… +dd(L), and therefore, dL N(L*Dd, L* d2).
                       A continuous review model with
                 probabilistic demand and constant lead time
• Typically, we want to reduce the probability of stockout during a single replenishment
  cycle to a value equal to 1-a, where a(0.5,1.0) is known as the desired          .
• This effect can be achieved by setting ROP = L*Dd+ss, where ss is known as the required
  safety stock. ss can be computed by solving the following inequality:
                    Prob {dL L*Dd+ss}  a 
                    Prob {(dL-L*Dd) / (d*L)  ss / (d*L)}  a 
                     ss / (d*L)  za
   where za is the a-th percentile of the standardized normal distribution.
• Hence,
                              ROP = L*Dd + za* d*L
Periodic Review Policies
• In the case of periodic review policies, we fix the reorder interval T, and every time
  we place a replenishment order, we check the current inventory position (IP), and
  order enough to bring this position up to a pre-specified level S.
• T is frequently determined by external factors like the supplier delivery schedules. In
  case of choice, an optimized selection of T is
                             T* = round(Q* / Dd)
  where Dd is the expected daily demand, Q* = [2*S*Da/H]1/2, and
  Da = Dd * (business days in a year).
• Furthermore, an analysis similar to that provided in the previous two slides,
  establishes that the minimal re-order level S* that guarantees a service level a, is:
                             S* = T**Dd+za* d*T*,
  where za and d have the meanings defined in the previous slides.
• Remark: Notice that periodic review policies will tend to carry more safety stock
  than continuous review policies, when applied on the same system, since, in general,
  T*>L. This is the price of “ convenience” provided by these policies, compared to
  their continuous review counterparts.
ABC Inventory System
ABC ANALYSIS (ABC = Always Better Control)
• This is based on cost criteria.
• It helps to exercise selective control when confronted with large
  number of items it rationalizes the number of orders, number of
  items & reduce the inventory.
   Must have:
      • Tight control
      • Rigid estimate of requirements
      • Strict & closer watch
      • Low safety stocks
      • Managed by top management
‘ B’     Items
Intermediate
Must have:
       • Moderate control
       • Purchase based on rigid requirements
       • Reasonably strict watch & control
       • Moderate safety stocks
       • Managed by middle level management
‘ C’        Items
Must have:
       • Ordinary control measures
       • Purchase based on usage estimates
       • High safety stocks
       ABC analysis does not stress on items those are less costly but
       may be vital
     VED ANALYSIS
•    Based on critical value & shortage cost of an item
    –It is a subjective analysis.
          •Items are classified into:
     Vital:
          •Shortage cannot be tolerated.
     Essential:
          •Shortage can be tolerated for a short period.
     Desirable:
          ■ Shortage will not adversely affect, but may be using more resources. These must
          be strictly Scrutinized
V E D ITEM COST
A AV AE AD CATEGORY 1 10 70%
B BV BE BD CATEGORY 2 20 20%
C CV CE CD CATEGORY 3 70 10%