Inventory Management Study: HPPCL vs. NTL
Inventory Management Study: HPPCL vs. NTL
                              By:
                   Ganesh Prasad Timilsina
                      Balkumari College
                 T.U. Regd. No.: 7-2-508-5-202
                     Roll No.: 06 (062-064)
                    Narayangarh, Chitwan
                        December, 2009
                              1
                                         DECLARATION
Date: .........................
                                                        ___________________________
                                                           Ganesh Prasad Timilsina
                                                                      Researcher
                                                       Balkumari College, Narayangarh
                                                 2
                                  ACKNOWLEDGEMENT
I would like to thank the staffs of National Trading Limited and Herbs
Production and Processing Company Limited for providing the data                  and
related information.
Last but not least, I am responsible for any errors and I apologize for any of
them committed that may have remained in this work. Thanks.
                                                    _______________________
                                                      Ganesh Prasad Timilsina
                                                       Narayangarh, Chitwan
Date: .............................
                                        3
                       TABLE OF CONTENTS
                                               Page No.
Recommendation                                         i
Viva-Voce Sheet                                       ii
Declaration                                          iii
Acknowledgements                                     iv
Table of Contents                                  v-vi
List of Tables                                  vii-viii
List of Figures                                      ix
List of Abbreviation                                  x
                                   4
2.8    Inventory valuation method under cost basis                 36
       2.8.1 Benefits of Inventory Control                         36
2.9    Inventory System                                            37
       2.9.1 Inventory control procedure                           38
2.10   Inventory Reports                                           39
2.11   Review of Related Studies                                   41
       2.11.1 Dissertation                                         41
       2.11.2 Review of Article and Institutions Report            54
2.12   Research Gap                                                56
CHAPTER III: RESEARCH METHODOLOGY                                58-61
3.1    Research Design                                             58
3.2    Nature and Source of Data                                   58
3.3    Data Gathering Procedure                                    59
3.4    Presentation and Analysis of Technique and Tools            59
       3.4.1 Statistical Tools                                     60
       3.4.2 Financial Tools                                       61
CHAPTER IV: PRESENTATION AND ANALYSIS OF DATA                   62-100
4.1    ABC Analysis                                                62
       4.1.1 National Trading Limited                              62
       4.1.2 HPPCL                                                 64
4.2    Economic Order Quantity Analysis                            65
       4.2.1 National Trading Limited                              65
       4.2.2 Herbs Production and Processing Company Limited       80
4.3    Correlation between Sales and Net Profit                    97
       4.3.1 National Trading Limited                              97
       4.3.2 Herbs Production and Processing Company Limited       98
4.4    Major Findings                                              98
CHAPTER V: SUMMARY,CONCLUSION AND RECOMMENDATION 101-105
5.1    Summary                                                    101
5.2    Conclusion                                                 103
5.3    Recommendation                                             104
Bibliography                                                   106-109
                                     5
                           LIST OF TABLES
                                      6
4.22   Calculation of Daily Usage, Lead Time, Safety Stock and Re-order Point   88
4.23   Economic Order Quantity and Eucalyptus Oil                               90
4.24   Annual Demand for Eucalyptus Oil                                         91
4.25   Calculation of Daily Usage, Lead Time, Safety Stock and Re-order Point   92
4.26   Economic Order Quantity and Cinnamon Leaf Oil                            94
4.27   Annual Demand for Cinnamon Leaf                                          95
4.28   Calculation of Daily Usage, Lead Time, Safety Stock and Re-order Point   96
4.29   Correlation between Sales and Net Profit of NTL                          97
4.30   Correlation between Sales and Net Profit of HPPCL                        98
                                     7
                       LIST OF FIGURES
                                  8
            LIST OF ABBREVIATION
                           9
                               CHAPTER I
INTRODUCTION
                                      10
the aim of inventory management is to avoid excessive and inadequate
level of inventories and to maintain optimum level of inventory for the
smooth production and sales operation.
                                      11
public sector completely owned by his majesty's Government of Nepal. NTL
was created in order to channels commodity aids from the people's Republic of
China and USSR with a view to meet the local cost of development projects
initiated by these countries through the sales of aid goods in the domestic
market. It has authorized capital of Rs 30 crores, issued capital and paid up
capital of Rs169.335,000 each. NTL has five regional offices in five
development regions of the country. It also maintains six branch offices and
eight sales depots across the business centers of the kingdom. Its head office is
situated in Teku. Kathmandu. Previously, the department of commerce, HMG
handled this function in order to create a better channel to serve growing needs
of the national economy and the people at large through the regular supply of
essential goods at reasonable prices. HMG set up the NTL as a State Trading,
Organization. It was entrusted with the functions of engaging on all kinds of
trading activities including quote goods to be imported from India for the
purpose of establishing domestic prices. regularizes, industrial raw materials.
machinery and equipment and consumer goods.
As NTL began to produce goods from diverse sources and also as it -was
exporting to diverse market. NTL through activities definitely support the
country's policy of trade diversification. As the first leading trading
organization at the national level, NTL was made of deal with both the import
and export aspects of foreign trade for the purpose of rendering support
services to the economic development of the country.
                                      12
Due to the variation of climate and geographical structure of the country,
Different kinds of medicinal and aromatic plants are found in the country.
They are valuable forest resources. It has had a good recognition in the
Indian market since ancient time. The highest peak of the world, Mt.
Everest and a series of Himalayan ranges found in the country are symbolic
of the existence of the valuable medicinal and aromatic plants. During the
past days, the country had significant role in trading of crude herbs till the
date about 700 varieties have been identified. The major thrust of the nation
is to process the natural resources domestically balancing their depletion in
nature with regeneration the inception of herbs production and processing
company limited in 1981AD as an undertaking of the then HMG/Nepal.
After thorough research and dedication of the national core of scientists
under the department of medicinal plants, this company was founded.
HPPCL is the first company in the country to harness the rich treasure of
herbs and aromas for processing production medicinal extracts and
essential oils for drugs and perfumery industries within the country and
abroad. The painstaking research on selected herbs resources and flora of
the country by modern scientific methods results the introduction of the
production of selective medicinal extracts and essential on a commercial
scale. At present, the company is capable of exporting indigenous products
like Sugandha Kokila Oil and Jatamasi oil as well as the exotic varieties
such as Palmorosa oil, Citronella oil, Lemongrass oil and some crude drugs
to neighboring and third countries.
These raw materials for the production of the different kinds of perfumery
oil are either purchased directly or taken from the cultivated area. There are
no specific methods for the collection of different kinds of raw materials.
                                      13
1.2 Statement of Problems
Industrialization plays the vital role for the national development but most
of Nepalese enterprises are operating in losses. The then HMG had
established a number of PEs in different fields. But the financial
performances of such enterprises in Nepal are quite dismal and have not
been able to contribute towards the generation of surplus there could be
many factors for the failure of the PEs i.e. lack of integration of activities,
mismanagement, less utilization of capacity, lack of motivated skilled
employees and mismanagement of inventory. One probable cause for
failure of the enterprises might be related to inventory management and
control. So, to address the problem, the study intents proper inventory
management of the PEs. The study covers the following research questions
                                     14
1.3 Objectives of the study
      The objectives of the study are as follows:
   1. To analyze the inventory level maintained by National Trading Limited
      and Herbs Production and Processing Company Limited.
   2. To study the inventory management and control system followed by
      National Trading Limited and Herbs Production and Processing
      Company Limited.
   3. To examine the techniques being employed to manage the inventory by
      these enterprises.
A firm cannot achieve its goals unless inventories are controlled effectively
and capital is allocated efficiently. Therefore study on inventory
management is inevitable. "Inventory is the most important thing but large
inventory is the evil for the company." (I.M Panday, 1993)
                                     15
Inventory is the current assets playing vital role for the organization. Many
Nepalese public enterprises have poor inventory management systems so
that they can not be run successfully. When market demand is high at that
period, if there is lack of proper inventory there will be few production and
can not supply regularly. Some times due to over stock level inventory hold
unnecessary current assets. So that excessive as well as inadequate
inventories are not desirable. Inadequate inventories cause obstacles in
smooth production as well as in market operation.
Introduction
Review of Literature
                                       16
Research Methodology
The fourth chapter is presentation and analysis of data based on facts and
figures gathered by different methods i.e. EOQ, targeted and actual
production, targeted and annual sales and major findings.
The fifth chapter is last chapter which includes summary, conclusion and
recommendation.
Bibliography and appendixes are also included at the end.
                                       17
                            CHAPTER II
REVIEW OF LITERATURE
                                   18
be defined as the function to plan, organize, direct, co-ordinate and control
of inventory as per the requirement of the organization.
Raw materials are those basic inputs. Which are generally purchased from
outside and converted into finished goods through this production process.
Raw materials are those basic inputs that are converted into finished
product through the manufacturing process. Raw materials inventories are
                                    19
those units have been purchased and stored for future production. And raw
material is very important factor of production in a manufacturing
organization. It is the first and the most important element production
which covers nearly 60% of cost of production.
                                    20
2.2 Objective of Inventory Management
The questions of managing inventories arise only when the company holds
inventories. Maintaining inventories involves tying of the company’s funds
and incur race of storage and handling costs if it expenses to maintain
                                    21
inventories, why do companies hold inventories? There are three general
motives for holding inventories (Starr & Miller, 1962).
                                     22
expensive. The manufacturer must therefore keep extra needed in the
conversion process. Other reason for carrying inventories is summarized
below.
                                     23
   7.   Demand of the product
   8.   Price trend and rigidity
   9.   Credit Policies
   10. Import \Export policies
   11. Available Information
   12. Information about substitute product
   13. Plant utilization
   14. Technology availability
   15. Business cycle
   16. Rejection cycle
   17. State of health of nation economy.
   18. Foreign exchange regulation.
   19. International market condition
   20. Corporate objectives.
   21. Communication system.
   22. Delegation Power
   23. Location of plant and location of suppliers
Cost Incurred for maintaining given levels is called carrying cost. Carrying
cost varies with inventory size. Because of second world war, American
economy as well as world economy plagued by capital utilization, material
shortage, inflation. Balance of cost lie heart of all the production and
inventory control problems (Killen, 1969).
Some of the factors which influencing inventory cost are given below:
   (1) Material costs
   (2) Ordering costs
   (3) Safety stock cost
   (4) Cost of funds tied up in inventory.
   (5) Cost of running out of goods
   (6) Carrying cost
                                      24
1) Material Costs
These are the costs of purchasing of the goods plus transportations and
handling. This may be calculated by adding the purchase price (less any
discount). The delivery charges and the sales tax (if any).
These are variable costs of placing of orders of the goods. Each separate
shipment involves certain expenses connected worth requesting and
receiving materials. Examples of these are the tying of the order and
inspection of goods after they arrive. The fewer the orders the lower the
order cost will before the firm. Ordering cost will be for the firm. Ordering
cost can be calculated by the following formula.
                        A
      Ordering Cost =     O
                        Q
Where,
      A = Annual Requirement
      Q = Order size
      O = ordering cost per order
Whenever the firm commits its resources to inventory, it is using funds that
might be available for other purposes. A portion inventories is financed by
trade credit from supplies and involves on costs. If the firm buys
inventories on terms net 30, the inventories may be sold before the firm
must pay its suppliers the balance of the inventory must be financed from
the firm's general funds and involves a cost. If the firm is considering an
expansion of inventories and plans to borrow to obtain funds, they will
have to pay interest on the additional debt. if the firm finances additional
inventory through the sale of common stock, an opportunity cost is
involved. The firm has lost the use of funds for others, profit making
process. What ever the sources of funds, inventory has a cost in terms of
financial resources, excess inventories represents an unneeded cost.
                                    25
(4) Cost of Running Out of Goods
These are the expenses of storing goods. Once the goods have been
accepted, they become a part of the firm’s inventories. These costs refer to
cost related to holding of inventory over a given time period. Total carrying
costs vary in proportion to the value of inventory; usually they are
computed from the following formula.
      Carrying Cost = Average inventory × Carrying cost per unit
      Symbolically,
                         Q
      Carrying Cost =      × (Carrying cost per unit)
                         2
The following are examples of different kinds of carrying costs.
      (I) Storage Cost
      (II) Insurance
      (III) Obsolescence and Spoilage
      (IV) Damage of Theft
                                     26
(II) Insurance
When firms hold goods, they expose themselves to the possibility that the
goods will not be saleable when the time arrives. Obsolescence is the cost
of being unable to sell goods because of current market factors deriving
from changes in styles, tastes or other factors. If a product is no longer
wanted, the firm must sell it at a fraction of its value or destroy it. Spoilage
occurs when a product is not saleable because of deterioration during
storage, such as foods that rot, plants that die, garments that are attacked by
moths, candles that discolor or the chemical that decompose.
Although a firm makes every effort to protect goods against damage and
safeguard item against pilferage, goods are damaged and stolen. A portion
of these expenses is not covered by insurance and are losses to the firm. In
some business, particularly retail stores and producing luxury products such
as alcoholic beverages, damage and theft may constitute major carrying
cost.
Technical formulation includes the question, which reduce the cost and
increase in profitability. The problem, which is common to all, is how
much to estimate and execute inventory policies. How much should they
buy at a time? How low should they let inventory to fall before they
replenish it? From whom they should buy and how should they ensure for
getting items? but it is not possible to answer the entire questions. It has
                                      27
been possible to answer these varied question or problems faced by the
business units. (Adam, 1993)
We have already discussed about the different forms of costs then lets see
how the production manager attack the problem fixed unit of given items of
lowest price or produced for stock at a given time. The large quantity
purchase enables the management to reduce the order placing cost incurred
in a given period. Buying a bulk of items also makes it possible to take
advantages of quantity discount and lower handling cost. We have that the
procurement cost decreases, the carrying cost will increase. This is the cost
trade off between the two. If we add the cost graphically, we will obtain the
total cost curve. The optimal order quantity is the point at which annual
total cost is at a minimum. The purchase of large increased size of the
average inventory maintained which is shown below. (Magee, 1995)
Total cost
                                            A
                                                                 Carrying
     Cost (Rs.)
cost
                                                               Ordering
                                                                 cost
Size of order
                                       28
Since order placing cost are largely independent of the size of the order.
Ordering cost goes down as the order size is increased because fewer order
are placed to reduce the inventory cost.
To illustrate the relationship between those costs let us consider the case of
printing press that needs 1000 tons of newsprint. Of the process of orders
from the manufacture in quantities of 100 tons at time means that ten orders
must be placed whereas only two orders are needed for an order size of 500
tons. As consequences inventories cost such as storage, insurance and
interest, which very with inventory level will be lower and are economic
that belongs to large orders such as quantity discount. Lower ordering cost
and lower receiving cost, a balance must be stock between the inventory
carrying costs, will reflect a compromise and accommodation between the
two costs, will reflect a compromise and accommodation between the two
cost patterns. This compromise occurs at the lowest point in the total cost
curve “A” shown in figure 2.1.
                                      29
model can be modified to take account for increasing and decreasing
overtime. We shall not get into these types of complexity.
We assume that ordering cost 'O' is constraint regardless of the size of the
order. In the purchase of materials or other items these costs represent the
clerical costs involved in packing an order as well as certain cost of
receiving and checking the goods once they arrive. For finished goods
inventories, ordering cost involve scheduling a production run for in transit
inventories, ordering cost are likely to involve nothing more than record
keeping. The total ordering costs for a period is simply the number of
orders for that period of items multiply by the cost pert order.
Carrying cost per period 'C' represent the cost of inventory storage,
handling insurance, together with the required rate of return on the
investment in inventory. These costs are assumed to be constant per unit of
inventory of a time. Thus the total carrying cost for a period is the average
numbers of unit of inventory multiply by the carrying cost per unit.
                                   AO
      Optimum Quantity (Q) =
                                    C
Where,
      Q = Optimum quantity
      A = Annual requirement
      O = Ordering cost
      C = Carrying cost
                                     30
purpose that can be approximated by a straight line. We see the zero
inventories always indicate that further inventory must be ordered.
                                                                                       Q
                                                                   Average Inventory
                                                                                       2
                                                Time
EOQ can be determined by three approaches
     Formula approach,
     Trail and error approach and
     Graphical approach
Formula Approach
                    This method, we calculate EOQ by following formulas.
                    From Economic Order Quantity Statement, we have
                    Total ordering cost = Total carrying cost
                    Total ordering cost = Number of orders × Ordering cost per order
                                Annual Requirement
                            =                      × Ordering Cost per Order
                                    Order Size
Symbolically,
                                             A      AO
                    Total Ordering Cost =      ×O =
                                             Q       Q
Again, Total carrying cost = Average quantity × Carrying cost per unit
                        Ordering size
                    =                 × carrying cost per unit
                             2
                                                   31
Symbolically,
                                 Q     QC
         Total carrying cost =     ×C=
                                 2      2
Now, we have
           AO QC
              =    Total ordering cost = Total carrying cost
            Q   2
         OR,   Q2C = 2AO
                      2AO
               Q=
                       C
                         AO
               EOQ =
                          C
Where,
         EOQ = Economic Order Quantity
         A = Annual Requirement
         O = Ordering cost per unit
         C = Carrying cost
                                        32
Graphic Approach
Total ordering cost curve is increased with the no of orders increase but it
reduces the carrying and vice-versa. Addition of ordering cost curve and
carrying cost curve represent the total cost. The point where the total cost
curve is minimized represents the EOQ.
Total cost
                                      M
                                                             Carrying
  Cost (Rs.)
cost
                                                           Ordering
                                                             cost
        O                                                       X
                            Order size (Units)
In the above figure, OX shows order size and OY shows the total cost if
order size is increasing no. of order is decreasing, so the ordering cost curve
is decrease and just opposite carrying cost curve is increasing. The total
cost is the summation of carrying and ordering cost. Total cost is
minimized at M.
                                     33
    Purchasing
    Store keeping
    Issuing and Pricing
2.7.2.1 Purchasing
                                     34
    Buying the quantity, which in neither too much that involves
      belonging of capital nor too little that holds up the regular supply for
      production.
    Improvement of product with reference to quality and the
      distribution by means of selection of adequate materials.
    Maintaining continuous supply to insure production schedule at a
      minimum investment.
    Avoidance of duplication of materials, leaving to waste of materials
      and equipment.
    Maintenance of company competitive position is the market by the
      customer having company’s quality standards in accordance with the
      demand of customer.
    Creation of goodwill for the company through dealing with
      suppliers.
    Developing, full-operation and co-ordination and maintenance of
      internal relationship among various department of the company.
Store keeping refers to the safe custody of all materials stocked in stores for
which the store keeper acts as a trustee. It simply means that the materials
are to be stored in stores in such a manner that there is least possibility of
theft, fire, damage and they may be easily located and issued whenever
required for use.
                                     35
Store keeping embraces all the activities right from the receipt of supplies
of raw materials, spare parts, equipment, their proper storage and issue to
used department. This also includes the storage of finished product before
dispatch to dealers. These activities involve maintenance of proper records
of all the transactions.
The importance of store keeping has not been properly recognized by the
manufacturing organizations so far. Many organizations spend lavishly on
machines and wages while store keeping is ignored and stores are not in
proper place and condition. Storekeepers are also not paid attention in
comparison to others in similar status. All these causes are responsible for
wrong or short issue. Loss of stock of raw materials unexpectedly running
out of stock and preparation or correct vouchers all these lead to theft and
pilferage of stock and delay in production.
In the light of the above explanation store keeping can be described as the
keeping of materials in stores in a scientific and systematic way.
Objectives of store-keeping are
To achieve the above objectives, a firm generally used bin card and store
ledger as a store controlling devices.
                                     36
2.7.2.3 Issuing and Pricing
Pricing the inventory is one of the most interesting and it widely matters in
accounting process. Many organizations are interested in the various
methods of pricing inventories because it has a direct effect on the income.
Inventory valuation approach is important in the aspect of income tax
problem. One method of inventory valuation may lead to lower tax liability
than other inventory valuation method. There are many methods of
inventory valuation but most significant method is cost and other method is
the lower of cost or market. Both methods give different results.
If order is placed when the stocks are over, then other is always a chance
that the firm may suffer the situation of shortage. Another alternative is to
place the order before the stock is completely exhausted i.e. to order in
advance is a difficult exercise. If an order is placed too early then it may
result in pilling up of inventory for the longer period and it is placed too
late then this may result in shortage. Both these situations are not in the
interest of the firm. The problem it is known as 'what to order' and is very
important for the organization in other words the choice of appropriate
point at which an order to replenish the inventory is of great significance.
The level of inventory at which re-order should be placed is known as
known as re-order and re-order point. (Goyal, 1992) To determine the re-
order level under certainty, following factors should be taken in to account.
    The time intervening between the date of order of goods and the
      arrival of supplies,
                                    37
                      The average quantity consumed with in stipulated them period and
                      The margin of safety.
200
                      150
Order point (Unit)
100
50
                         O           10             20            30        40            50
                                               Lead Time (days)
In our example, the re-order point is computed under the assumption of
certainty. It is difficult to predict usage and lead-time accurately. The
demand for material may fluctuate for day by day or from week to week.
Similarly, the delivery time may be different form the normal lead-time. If
the actual usage increase of the delivery of inventory is delayed, the firm
                                                   38
can face a problem of stock out. The stock out can prove to be costly for the
firm. Therefore, in order to guard against the stock out, the organization
with a policy of safe guarding their interest. These uncertainties maintain
the level inventory at some desired minimum level. This minimum level of
inventory to cover some unforeseen and uncalled for situation is known as
'safety.' Alternatively a safety stock can also be defined as the average stock
available in inventory when the fresh supply arrives.
Factors affecting choice of safety stocks are :
                      Uncertainty in demand,
                      Degree of insurance of any item,
                      Uncertainty in load time and
                      Size of the batch
200
                       150
Order point (Unit)
O 10 20 30 40
                                                      39
I) Situation, where demand rate various
Safety stock = (lead time) × (maximum demand rate - average demand rate)
II) Incases where both lead time & demand are fluctuating:
Safety stock = (maximum lease time - average lead time) × demand rate
Stock Level
This stock keeps tracks of the goods help by the firms the issuance of goods
and the arrival of orders. It is prepared for recording as well as accounting
of goods in stock. Thus, this stock helps to maintain the record of inventory
at appropriate level.
For simplicity the stock level are divided in following headings.
                                    40
The maximum stock level of fixed by taking in to account the following
factors:
    Amount of capital available for maintaining stocks,
    Go-down space available,
    Rate of consumption of the material during the lead-time,
    The time lag between indenting and receiving of the material,
    Possibility of loss in stores by deterioration and evaporation and
    Cost of maintaining stock.
It is that level below which the inventory of any item should not be allowed to
fall. It is known as safety stock. The main object of fixing this level is to avoid
unnecessary delay or amputation of production due to shortage of materials.
It is computed as
In fixing this level the following factors are making into consideration.
    Lead time, i.e. time lag: between indenting and receiving of material,
    Is the time required replenishing the supply?
    Rate of consumption if material during the lead-time and
    Nature of the material: minimum level is not required in cost of a
       special material, which is required against customer specific order.
Generally this level is fixed below the minimum level and represents the
stage where immediate steps are taken for getting stock replenished. In
some cases, danger level of stock is fixed above the minimum level but
below the re-ordering level. (Sahajahan, 1997)
It is computed as follows:
Danger level = Normal consumption × Maximum energy period
                                       41
Average Stock Level
It is the average level of stock that should be maintained throughout the
year. Average stock is the cost of storage departments. (Sahajahan, 1997)
It is computed as follows:
Average stock level = 1/2 (Maximum × Minimum)
The firm keeps various items in inventory. All items in the inventory
cannot be treated easily. They are differ in value and can follow a selective
control system. A selective control system is the ABC analysis. The group
"A" item consists of highest rupee value item. "B" item consists of middle
rupee value and "C" item consists of lowest rupee value item. (Pandey,
1993)
                                    42
All items in stock are listed in order of descending values showing quantity
held and the corresponding value of the materials (See Table 2).
The percentages given in Table 2 are only guidelines and are subject to
change according to prevailing circumstances and choice of management.
Table 2 shows that only 20% of the items represent 72% of the total costs.
                                Table No. 2.2
                        Stock Analysis Under ABC
 Class                  Items                            Investment
         No. of items   Percent of total items   Total cost Percent of total
  A        20,000               20%              2,88,000          72%
  B        30,000               30%               76,000           19%
  C        50,000               50%               36,000           9%
          1,00,000              100%             4,00,000          100%
The items under Class A are subject to greater continuous control and
planning than are the items under other categories. The Class A item
account for high annual consumption costs and correspondingly high
investment in inventories. Because of high investments in Class A items,
there would be frequent ordering and low safety stocks. This also assumes
that the cost of placing and following up orders is relatively low in
comparison with the cost of carrying excess inventories. A number of
things can be done to reduce inventory of 'A' items. For example, A items
can generally be ordered for specific runs, the economic order quantity
could be applied; local suppliers could be asked to stock supplies so that
delivery time can be shortened. On the other hand, where the total annual
purchase cost is relatively low as in the case of Class C items, there will be
less frequent ordering and higher safety stocks. Items in Class C receive the
least amount of control and should be under simple physical controls such
as the two-bin system with safety stocks.
                                    43
                                           Figure No. 2.6
                       Classification of Items According to ABC Analysis
             100
90
80
                                                             rupee value)
             60      "A"
             50     items        "B" item
                    (high      (Medium rupee
             40    rupees         value)
                   value)
             30
             20
                   0     20      30        40    50    60       70      80    90       100
                                         % of Inventory Item
         Class 'A' items which represents only 20% of amount of quantity for over
         72% of the total value in Rupees. The opposite relation holds for category
         'C' where 50% of total amount in quantity. Category 'B' occupies the middle
         place items. A and B are jointly represent about 50% of the total units and
         91% of the investment. More than half of the total units are item 'C'
         represent merely 9% of the investment. The highest control should be
         exercised on item 'A' in order to maximize the profit on its investment. In
         case of 'C' simple control will be sufficient. High rupees or value is treated
         most carefully at first time.
An example of the treatment that would be given the three dimensions is,
         Item "A": In item "A", the economic order quantities are carefully calculated
         for each time. The uses rate and the procurement costs are reviewed
         continuously with each other. Tight inventory control should be maintained.
         Items "B”: In item "B", the economic order quantities are developed
         periodically. Normal inventory control is exercised.
                                                44
Items "C”: In item "C", the specific order quantities are not made. Roughly
estimate the inventory or the quantities that will be sufficient for long
period are ordered. Inventories are checked physically once in every six
months or every year to determine if new order should be placed.
As the term inventory control has two functions, which are quite different
but related to each other only in that they both required the maintenance of
adequate record of inventories as well as receipt and issues. These functions
are accounting control and operating control.
                                    45
carrying charges (such as storage and deterioration expenses) and possible
losses caused by price declines. Similarly, shortages in inventories interrupt
production, making machines and employee idle and causing sales loss.
Hence, there is need of for inventory control or that is sometimes termed as
‘inventory planning’.
                                    46
real practice, it will be better to be clear about the inventory system
concepts.
a) Multi-stage Inventory
When parts are stocked at more that one point of the sequential production
process, there are multi-stage inventories, these parts must eventually come
together into finished goods.
b) Multi-echelon inventory
2. Two-Bin system
The two bin system an application of the fixed order size approach is one of
the oldest inventory system, where all materials or given type is the second
is put into use and replacement order for a fixed amount is dispatched
immediately.
                                    47
Interval system, periodic reviews of inventories are mode at which time
they are restored to some predetermined optimum level, no running records
of daily inventory activities are kept.
The status of the inventory is known only at the time of the review, which
may take place weekly monthly, quarterly or yearly that are commonly
called periodic inventory system.(Star and Devid, 1977)
                                     48
reports suitable for all organizations. Design inventory reports should be
according to the individual requirements of the organization.
                                       49
2.11 Review of Related Studies
Thapa has made study about inventory management system of Royal Drugs
Limited. Mainly this study focused on the problems of inventory
management and control system of Royal Drugs Limited objectives are as
follows:
                                     50
    To identify the present position of inventory of Royal Drugs Limited.
    To analyze the inventory management of Royal Drugs Limited.
    To provide suggestion based on the analysis.
Recommendations:
    The drugs company should not define its goals and objective clearly
      with regards to minimized inventory costs. Company has store only with
      store keeper and store officer. There is need of separate management
      department.
    Company should not use any kind of scientific tools and techniques so
      that there cost is maximized. Scientific inventory management.
      Techniques are EOQ, reorder level, safety stock and lead time. It should
      not be identified properly and lack of safety stock. Its bad impact from
      one month before company’s production breaks for few days.
    Company has not categorized its raw materials inventory in A, B, & C
      group at present. Its result company is bearing the maximum loss.
      Company categorized A, B & C till 2050 and that time company's
      financial condition was considerable.
                                    51
      In a simple way bin card should be used to manage inventory. This card
        includes the name of items, quantity and unit price, quantity issued and
        balance of stock.
      Material purchase system using EOQ method is best for company to
        make production target oriented.
2.       Dinesh Kumar Pant (1999): Impact of Inventory of Over the profit
        (A case study of Gorkhapatra Corporation)
        Finding in his study and given recommendation is as below:
Findings:
      Gorkhapatra corporation has not been used the optimal inventory level
        i.e. EOQ to procure the required inputs.
      Inventory turnover is flexible over the study period and net profit margin
        is inconstant in various years.
      Return on total assets is more flexible in previous but slightly consistent
        in later year.
      Regression and correlation analysis has shown the positive relationship
        between the inventory, costs and profit as per the analysis done.
              Correlation analysis has shown both the independent variable have
               highly positive relationship with the dependent variable profit as
               indicated by the correlation coefficient 0.87 and 0.827
              Coefficient of regression shows the linear relationship between
               inventory cost and material cost.
Recommendation
      The corporation needs to apply the appropriate tools and techniques of
        inventory management for maintain optimal level of inventory thereby
        reducing ideal lost at minimum possible level as it has the direct impact
        over the profit.
      Gorkhapatra Corporation should adopt the reliable procurement
        procedure important materials with the help of good purchase plan to
        avoid the possible crisis of stock out.
                                          52
    The formality of making decision regarding the tender procedure a
      placing the order should be shortened to increase its competitiveness.
    The corporation should maintain its own warehouse as it has been
      suffering form the higher amount of holding cost for leasing the
      warehouse of outside parties even thought it has adequate land and other
      resources necessary for its arrangement.
    The recruitment and selection procedure of qualified personnel handling
      the inventory should be unbiased on the basis of which the corporation
      will be able to acquire the efficient technician’s regular training on
      inventory and store management should be given.
    The vision of top authority should be clear for solving the problems
      appeared in course on inventory management system (Pant,1999)
3. Indra Shrestha (2000): Inventory management of manufacturing
   industries in Nepal (With special reference to quick foods)
Findings
    The selling price of noodles (Thai Foods) was constant for the fiscal
      year 2051/056 but cost price of Noodles was increasing from year to
      year with different rate. There is no correlation between selling and cost
      price because if cost price increases the selling price should also
      increase.
    The selling price and cost price of cheese ball was increasing from year
      to year. There is highest degree of correlation between cost price and
      selling price. The company has not classified its inventory for the
      purpose of control and equal attention for the entire inventory hold in
      the store but they are using bin card for inventory.
                                     53
    When and how much to order is estimated haphazardly by Thai foods
       and quick Foods P. Limited different from year to year and are not in
       economic order quantity.
    This purchase made by company is increasing from previous year to this
       year. It shows good production of company
    The company has maintained safety stock but company is not using re-
       order level for when to re-order.
    Raw material turnover ratio of some inventories is increasing year to
       year and some are fluctuating year to year but this ratio was satisfactory.
Recommendations
From this study following suggestions have been suggested.
Some raw materials were imported from Japan, New Zealand, Singapore, India,
Korea and China. This should be discouraged and alternative should be
searched within the nation as possible.
In case of Thai foods the cost of price of Noodles for the five,fiscal year
2051/052 to 2055/056 is increasing but selling price is constant i.e. some price
for five fiscal year. If cost price increases then selling price should also
proportionally increase for good profitability.
Thai foods and quick Foods P. Ltd was not conducted the ABC analysis. The
company should follow scientific tools and techniques i.e. economic order
quantity and economic lot size formula which help to reduce the relevant total
cost for manufacturing the product. The output obtained from quantitative
analyzes results the lowest cost and consumer can use with low cost than
company can increase their selling.
                                        54
4. Kashi Joshi's Study (2001)
Krishna Naraya Shrestha has made a study which is concerned that in what
extent the company is applying the inventory management techniques to
minimize the cost of inventory which directly affect the price of Drugs.
                                      55
His major findings and recommendation are as below:
Findings
    Required raw material for the production of different types of Drugs are
      imported by the company from India, China and other third world
      countries on global tender agreement.
    The company has purchased some material from other than listed
      supplier and producers of the company.
    The company has purchased some material at higher price although
      there is the possibility of purchasing at lower price.
    The company has purchased more raw material than requirement.
    The valued of closing inventory of raw material is in increasing from
      year to year.
    The company has not determined the re-order level, maximum stock
      level and minimum stock level
    The company has not following scientific inventory management
      technique i.e. economic order quantity model for purchasing different
      types of raw materials.
    The company has prepared purchase budget of raw material but it is
      highly differ from the actual purchase
    The investment of inventory stock of RDL is large and the value of
      inventory stocks is in increasing from year to year.
    The company has not applied ABC analysis technique to control the
      various types of inventory in the store.
    The company’s purchase position of different types of material is highly
      differing from year to year.
Recommendation
    Purchase plan should be prepared of different types of raw material
      with the proper cooperation among the planning, purchasing storing,
      and production, marketing and sales department to avoid the
      excessive investment on inventory.
                                      56
    The popular scientific inventory management techniques should
      apply by the company for purchasing varieties types of raw material
      so as to maintain optimum level of inventory and to minimize the
      total inventory cost i.e. carrying and holding cost.
    The selective inventory model should apply by the company for
      control the inventories in the store. ABC analysis divides the
      inventory into three groups i.e. ABC according to their usage values
      helps to apply proper degree of control for different group of
      inventory minimize the investment on inventory and minimize the
      cost of storage.
    Minimum, maximum and recording level for each type of material
      should be fixed by the company to avoid the over stocking of
      different types of material.
    The recruitment and selection procedures of efficient personnel
      handling the inventory should be unbiased on the basis, which the
      corporation will be able to acquire the efficient and skilled
      technician, and require giving regular training about on inventory
      management.
    For the timely procurement and supply of inventory items, reliable
      supplier should be selected and RDL should impose appropriate
      actions to them if they follow against the term and condition.
    The frequent change in top level management creates the unstable
      environment in the company, which leads the company backwards so
      the post of general manager should be professionalized.
                                     57
Findings
Major finding in her study are tentative solution for the question about how
much to buy and when to order and buy to maintain proper balance of
inventory to fulfill the corporation’s requirement.
Recommendation
Following recommendations are given by Laxmi Pandey on the basis of her
study.
      Corporation should follow the EOQ model for minimizing the
         inventory cost.
      To maintain the inventory smoothly, ABC classification should
         adopt by the corporation.
      Ledger cards can be used by the corporation to manage inventory. It
         contains the column for inserting the data or order and its receipt
         with date and quantity issued and sold. In this card, name of the item
         number, unit price, usage rate, supplier’s name the percentage of
         carrying cost and the ordering cost should be maintained.
      The scarp material (unsold stock or wastage) should be recycled with
         in the corporation, so that, cost of some possible extent can be cut-
         down. Hence, the corporation should setup the recycling sector.
      For getting skilled technicians, the process of recruitment and
         selection should be unbiased.
      Record keeping system should be scientific, so that, the corporation
         can locate the past records which are also helpful for the researcher.
Mr. Liladhar Dhital has conducted the research work on the topic of
inventory management (A case study of Nepal Food Corporation). The
main objectives focused by him were to analyze the various related
variable, like purchase, sales demand and food quota of Nepal Food
                                       58
Corporation and to find out their trends. The nature of data used was both
primary as well as secondary. The primary data were collected through
interview
With personal observation, the secondary data were collected from the
unpublished and published materials such as journals, articles and books
concerned with respective corporation.
Mr. Dhitaxl has pointed out some conclusion based on major findings.
Under food grains purchasing the domestic purchase is more fluctuated one
greater than import. Primary market purchase is made the paddy, maize,
wheat, pulse but rice is purchased only in open market. The relationship
between edible cereal production and requirement is negative etc.
From the analysis and interpretation of available data the following Mr.
Karki has made conclusions as the major findings is derived;
    The purchase quantities made by the organization differ from year to
      year are not in economic order quantity.
                                    59
    In Shaja Swasthya Sewa the economic order quantity model is not
      applied and the organization has maintained the safety stock which is
      highly fluctuated and estimated roughly.
    The organization has not categorized its inventory for the purpose of
      control and paid equal attention for the inventory held in the store.
    The annual target made by the organization differs from year to year
      and highly fluctuated.
                                     60
 Except global tender are procure the fertilizer through negotiation,
   through assistance from donor countries and agencies, through
   agreement of government.
 There are 196 institutional and Pvt. Dealers to chamalie the fertilizer
   to the farmers in Kathmandu valley but they don't get adequate
   fertilizers, as they need to distribute.
 The education level of farmer in Kathmandu valley is poor for right
   mix of fertilizers to be used in farm. They are following urea only,
   which lead the problem of inventory management.
 In AIC targeted supply of fertilizers and actual supply various
   largely every year. So, it the case with Kathmandu valley also? The
   most important aspect of inventory management is to match the
   regular supply, demand and purchase of inventory components. If
   supply targeted supply don't match each other then there would be
   either under stock position or over stock position.
 There is rate problem due to dependence on foreign country, in
   accessible memorable roads for hilly regions of Nepal have created
   inventory management problem. However, there is no such problem
   in Kathmandu valley
 For the efficient management, the AIC has not taken any measure
   regarding the improvement of its inventory management practices.
   AIC don't take any action on supplier who delays supply of ordered
   fertilizers.
 In the conclusion, AIC is applying scientific techniques of inventory
   management, which is the most crucial point in AIC. Despite it there
   are several internal and external causes not to be used scientific
   techniques but AIC is neglecting the inventory management almost
   completely. This is the matter of misfortune to the corporation, to
   farmers, as well as to the nation as a whole.
                                   61
Suggestions:
   AIC should make an effort to match the targeted demand and actual
     supply to overcome to overstocking position or under stocking
     position or out of stocking position of inventory.
   For the timely procurement and supply of the inventory items AIC
     should not depend on the other sources except through global tender
     because this source is more reliable, economic considering of season
     to be required of chemical fertilizers, lead-time, transportation, time
     process to be taken by tender, tender should be called.
   According to provides valuable information to the decision makers
     this can serve the controlling function and important function of
     management if records and classified properly, costing of different
     factors related to inventory of AIC requires sound classification and
     definitions of activities.
   They should attempt to use the scientific models like economic order
     quantity (EOQ), ABC analysis, reorder point etc. So that inventory
     problems whether it is the over stock, under stock, out of stock will
     be solves. As a result AIC can delivery the regular supply of
     chemical fertilizer to farmer at the right time.
Findings
   The major procurement procedures/ ways are through inventing
     global tender negation, through aid/ assistance from donor agencies/
     countries and through negotiation/ agreement of two governments.
   AIC procure of collect seeds from external as well as internal
     sources.
   walls of warehouses are built with bricks of stone as available
     locally, with cement building.
                                   62
    AIC does not have adequate fleet of trucks. So in most cases
      transport companies under contractual agreement carryout this job.
    AIC is not using scientific models of inventory management.
Recommendation
    To avoid the problems of over stocking of chemical fertilizers and
      seeds. AIC should consider these points;
   a) Target should be realistic.
   b) Target should be with the capacity of being fulfilled.
   c) If AIC is able to hold only optimum level of ending stock the locked
      up capital will be reduced.
   d) AIC should develop appropriate standard record keeping system of
      ending stock.
    Before calling global tenders, seeds growers’ season of requirement,
      lead time and means of transportation should be considered.
    Numbers of warehouses should be made according to the area and
      consumption of chemical fertilizers and seeds, which will make the
      distribution of fertilizers easier.
Some articles are revised with related to inventory management and control
These are under
Dr. G.R.     Agrawal has made study relating to the Nepalese public
enterprises stated that inventory management is the weakest aspect of
management in Nepal. The tools and techniques for controlling inventory
has not been applied in Nepalese enterprises for controlling their physical
as well as financial dimensions (Agrawal, 1980)
Rao and N.V.S. Jagmohan Rao also observed that for the efficient
management of inventory. There are the needs of tackling the human
element in the third world country like Nepal. They have suggested to
orienting the attitude of the staffs towards material cost because lack of
                                      63
knowledge and carelessness which were the responsible of this
management of the inventory. (Rao, K. 1981)
                                    64
corporation regarding its inventory managing system could not be found
(Bajracharya, 1983)
Referring the above given facts and figures, it is implied that most of the
Nepalese manufacturing concerns are not that much serious regarding the
inventory and material management. It also shows that there is not
comparative study. Public manufacturing as well as trading companies are
not applied the inventory model effectively. that is why the company has
been success to achieve their targets.
                                     65
covers the data of five years. Nobody of the earlier studies had focused on
role of inventory in overall profit planning of the organization although
inventory and different components of profit planning like production
planning, purchase planning etc are closely related to each other. Similarly
nobody had shown the relationship o Inventory with sales, production and
purchase although they are closely related to each other. Moreover this
study has not been done by pervious researcher as separately. Further no
one had test the correlation of different parts of the inventories using data.
Thus, to fill the gap, this study has been conducted. Thus this study will be
milestone in the field of inventory management and control in National
Trading Ltd. and Herbs Production and Processing Company Ltd. In spite
of above, multiple gaps among the researcher's view as well as there is time
gap regarding the study of inventory management.
                                    66
                               CHAPTER III
RESEARCH METHODOLOGY
The success of a work largely depends upon the way it is performed the
processes involved throughout the whole work need to be systematic for the
achievement of the objectives. Since research is a scientific discipline, it
deserves much more attention on the part of researcher. A systematic study
needs to follow a proper methodology to achieve the predetermined
objectives. “Research methodology is a way to systematically solve the
research problem”. It is the process of aiming at the solution of problem
through the planned and systematic dealing with collection, analysis and
interpretation of fact and figures.
       This chapter deals with research design, sources of data,
            population and sample size, data gathering procedure and data
            analysis tools to fulfill the above mentioned objectives.
Research design is the plan, structure and the strategy of the investigation
conceived so as to obtain answer to research questions and to control
variance.
The nature of data of this study has been primary as well as secondary.
                                       67
   a) Primary Data: - primary data are original data gathered by the
      researcher for the research work at hand. Thus, these data are
      collected for meeting the specify objectives of the study. Primary
      data has been collected through questionnaire, interviews and
      observation.
In order to collect the required data from the official records of both
"National Trading Limited and Herbs Production and Processing Company
Limited" the researcher has visited there personally. Similarly, personal
observation, informal discussion, interview with the officials, collect the
data from journals, magazines published, financial statement and annual
reports has been carried out to collect data at first hand. Regarding the
primary sources, personnel observations and personal discussion methods
are used.
To analyze the collected facts and figures, various accounting tools are used
to effectiveness on inventory management and control wherever necessary.
The techniques included are statistical tools, graphs, Karl person coefficient
and correlation. And the inventory management techniques applied in this
study is EOQ, different stock levels, Inventory turnover ratio and ABC
analysis.
                                    68
To achieve the objectives of the study, various financial as well as
statistical tools have been used in this study. The analysis of data will be
done according to pattern of data available. Because of limited time and
resources, some simple analytical tools such as percentage change,
coefficient of correlation and method of least square are adopted in this
study. Similarly, some strong accounting tools such as ratio analysis and
trend analysis have also been used for financial analysis.
Some important statistical tools are used to achieve the objective of this
study. In this study, statistical tools such as coefficient of correlation
analysis, standard deviation, and coefficient of variance have been used.
A) Coefficient of Correlation
This analysis identifies and interprets the relationship between two or more
variables. In the case of highly correlated variables, the effect on one
variable may have effect on other correlated variable. Under this topic,
Karal people co-efficient has been used to find out the relationship between
the different variables. The formula for computing person's correlation
coefficient (r) using direct method is as follows.
                     N  xy   x  y
            N  x 2   x    N  y 2   y 
                           2                  2
r=
Where
      X      =      Dependent Variable
      Y      =      Independent variable
      r      =      Correlation coefficient
      N      =      No. of time period
                                      69
3.4.2 Financial Tools
A) Percentage Analysis
B) ABC Analysis :
This technique is used to identify various items of inventory for the purpose
of inventory control. In this analysis, we divide the inventory items into
three group A, B and C. According to investment and valuable inventories
are classified A, B and C groups.
C ) EOQ analysis
                                         70
                           CHAPTER IV
                                    71
                                     Table No. 4.2
                               ABC Classification of NTL
  Category           Items (Units)    % of items          Value (Rs.)     % of value
                A         505             2%              164300000            58%
                B         8465           28%              45000000             16%
                C         20990          70%              72950000             26%
           Total          29960          100%             282250000           100%
Source: National Trading Ltd. Teku.
                80
                                                                     70
                70
                              58
                60
   Percentage
                50
                40
                                            28                                26
                30
                20                                   16
                10    2
                 0
                          A                      B                        C
                                           Categories
% of items % of value
                                         72
control cost and less control "item C & B respectively. On its investment
"item A" should be traced first and most carefully, in case of "item B"
simple control will be sufficient.
According to the concept of ABC analysis, the item of good with regarding to
three purchase department of HPPCL are divided ABC on the basis of usage
value and volume as show in table below.
                                        73
                                           Figure No. 4.2
                                       ABC Analysis of HPPCL
               80                                                       72.65
               70
               60
  Percentage
               50
                                                             38.98
               40                  35.34
               30                                                                   25.68
                                                  21.6
               20
               10       5.75
                0
                               A                         B                      C
                                                  Categories
% of item % of value
Ordering Charges
               Transportation Charge         = Rs.70
               Bank charge and commission               = Rs.25
               Telephone, Fax, Interest      = Rs.10
               Total ordering cost           = Rs.105
                                                74
                                                     250
         Carrying Cost per unit                  =       = 1.5625
                                                     160
(i)      By fitting the above mentioned data into Economic Order Quantity
         Formula, we get
                     2AO
         EOQ =
                      C
                     2×160×105
               =
                       1.5625
               = 21504
               = 147 (Approx.)
By the tabulation method, the EOQ for cleaned water pump can be calculated
as follows:
                                            75
Where,
                             Order size
       Average Inventory =
                                 2
       Carrying cost = Average inventory × Carrying cost per unit
       Ordering cost = No. of order × Ordering cost per order
       Total cost = Carrying cost + Ordering cost
From the above calculation, it is clear that by the use of tabulation method, the
minimum cost of cleaned water pump is Rs.230, where the total orders cost
Rs.105 and carrying cost Rs.125 respectively. The number and order is 1 times.
The company should order cleaned water pump once in a year to minimize the
total cost. If it orders twice a year the total cost will increase. From table, we
can conclude that when company order twice a year then the cost is increased
by Rs.42.5. Therefore, when the number of order increases the total cost will
also be increases.
(C) The company's annual demand of the cleaned water pump is given below:
                                 Table No. 4.6
                      Annual Demand for Water Pump
           Fiscal year (B.S.)                         Quantity unit
                2060/61                                    175
                2061/62                                    100
                2062/63                                    135
                2063/64                                    145
                2064/65                                    160
                                      76
                                              Figure No. 4.3
                                      Annual Demand of Water Pump
                      200
                      180
                      160
                      140
   Quantity (Units)
                      120
                      100
                       80
                       60
                       40
                       20
                        0
                            2060/61       2061/62         2062/63      2063/64   2064/65
                                                         Fiscal Year
The analysis shows that annual demand of cleaned water pump is reduced in
fiscal year 2061/62, but it is growing from this year. It would be due to
environmental effect such as increase in construction of building and most
people used cleaned water pump.
                                                    77
                                  Table No. 4.7
         Safety Stock, Lead time, Daily Usage Rate and Reorder Level
 Fiscal      Usage      Lead     Lead         Stock    Safety     Safety     ROP
  year        rate      time     time ×        days     stock     stock
             (Units)             Usage                 (Units)   days lead
                                  rate                             time
   1            2           3      4            5      2×5 = 6   3+5 = 7     4+6=8
2060/61       0.486      15       7.29          4       1.944       19       9.324
2061/62       0.277      15      4.155          4       1.108       19       5.258
2062/63       0.375      15      5.625          4        1.5        19       7.125
2063/64       0.403      15      6.045          4       1.612       19       7.657
2064/65       0.444      15      6.666          4       1.776       19       8.442
                       Annual consumption
Where, Usage rate =
                       No. of days in a year
The company don't consider the good in transit due to lead time is less than
order frequency.
This table includes calculation of ROP with safety stock. NTL need cleaned
water pump with 19 days safety stock all the day. In year 2064/65 NTL has
procure 160 units of cleaned water pump with no. of order 1 time. According to
ROP, the company should placed an order when 19 days consumption remains
balance i.e. 8.442 units.
                                         78
Ordering Charges
       Transportation Charge      = Rs.3000
       Bank charge and commission        = Rs.1500
       Telephone, Fax, Interest   = Rs.200
       Total ordering cost        = Rs.4700
(i)    By fitting the above mentioned data into Economic Order Quantity
       Formula, we get
                     2AO
       EOQ =
                      C
                     2×16000×4700
              =
                         1.375
              = 10458.57 ~ 10459 (approx.)
                         A   16000
       No. of order =      =       = 1.53
                        EOQ 10459
Above calculation indicate that, to obtain the minimum total cost, the company
should order 10459 liters at a time and over the year the company should order
2 times in a year.
                                    79
                                   Table No. 4.8
                Economic Order Quantity of Various Liquor
  No. of         Order          Average        Carrying         Ordering          Total
  orders          size        Inventory        cost (Rs.)       cost (Rs.)      cost (Rs.)
     1             2            2÷2= 3          3×C=4            1×0=5           4+5=6
     1          16000            8000           11000             4700           15700
     2           8000            4000            5500             9400           14900
     3         5333.33          2666.67        3666.07           14100          17766.67
     4           4000            2000            2750            18800           21550
     5           3200            1600            2200            23500           25700
The table shows that, the minimum cost of various liquor is Rs.14900, where
the total ordering cost and carrying cost are Rs.9400 and Rs.5500 respectively,
the number of order is 2 times. If the company orders except two times in a
year, the cost will increase. Therefore, the company should purchase the
various liquor twice a year to minimize its cost.
(B) The trend of annual demand made by the company for the various
     liquor is given below:
                                   Table No. 4.9
                       Annual Demand for Various Liquor
           Fiscal year (B.S.)                               Quantity (liters)
                2060/61                                          14412
                2061/62                                          25000
                2062/63                                          14000
                2063/64                                          18000
                2064/65                                          16000
                                          80
                                           Figure No. 4.4
                                  Annual Demand of Various Liquor
30000
25000
                       20000
   Quantity (Litres)
15000
10000
5000
                           0
                               2060/61   2061/62     2062/63      2063/64   2064/65
                                                    Fiscal Year
From the table and figure, the annual demand is on the basis of roughly
estimate. The demand of various liquor for different year is difference due to
unsystematic purchase plan of company. The company should be make
systematic plan of various liquor.
NTL procure various liquor 16000 liters in a year. The policy of company's is
to maintain 15 days for lead time and 5 days minimum balance of safety stock.
                                               81
                                    Table No. 4.10
           Daily Usage, Lead Time, Safety Stock and Re-order Point
 Fiscal      Usage     Lead Lead time           Stock       Safety    Safety   ROP
  year         rate    time      × Usage        (Stock       stock    stock
             (Units)                rate        days)       (Units)   +Lead
                                                                      time
    1           2         3      4=2×3            5         2×5=6     3+5=7    4+6=8
2060/61       40.00       15     600.00           5         200.00     20      800.0
2061/62       69.44       15     1041.60          5         347.20     20      1338.8
2062/63       38.89       15     583.35           5         194.45     20      777.8
2063/64       50.00       15     750.00           5         250.00     20      1000
2064/65       44.44       15     666.60           5         222.20     20      888.8
This table includes calculation of ROP with safety stock. NTL need various
liquor with 20 days stock all the day. In year 2064/65 NTL has procure 1600
Liters of various liquor with number of order 2 times. According to ROP, the
company should placed an order when 20 days consumption remains balance
i.e. 888.8 units.
(3) Sugar
(A) Optimum Order Level (By Formula Method):
Based on the company records, the following data are available,
         Annual Demand (A)                      = 120 Tons
         Total Amount tied up                   = Rs.4800000
Ordering Charges
         Transportation Charge        = Rs.14000
         Bank charge and commission             = Rs.1800
         Telephone, Fax, Interest     = Rs.700
         Total ordering cost          = Rs.16500
                                           82
            Other                          = Rs.10000
            Total Carrying Cost            = Rs.33000
                                                       33000
            Carrying Cost per ton                  =         = 275
                                                        120
(i)         By fitting the above mentioned data into Economic Order Quantity
            Formula, we get
                          2AO
            EOQ =
                           C
                          2×120×16500
                    =
                              275
                    = 120 tons (approx.)
Above calculation shows that, if the company seeks to minimize the total cost,
the optimal order should be 120 tons. The number of order size for the sugar
can be calculated by using formula.
                                A   120
            No. of order =        =     =1
                               EOQ 120
                                              83
Where,
                              Order size
       Average inventory =
                                  2
       Carrying cost = Average inventory × Carrying cost per ton
       Ordering cost = No. of order × Ordering cost per order
       Total cost = Carrying cost + Ordering cost
From the use of tabulation method, the lowest minimum cost of sugar is
Rs.33000 where the total ordering costs and carrying costs both are equal to
Rs.16500. The number of order is 1 times. This is the best possible number of
order, where the total cost is minimum with minimum equal ordering and
carrying cost.
If the company purchase or order two times in year, ultimately it increase the
total cost. So, it will better to purchase one time over a year.
(c) The trend of annual demand made by the company for the sugar is
       given below:
                                  Table No. 4.12
                           Annual Demand for Sugar
           Fiscal year (B.S.)                      Quantity demand (tons)
                 2060/61                                     180
                 2061/62                                     136
                 2062/63                                     100
                 2063/64                                     105
                 2064/65                                     120
The graphic representation of annual demands of sugar can be shown as below:
                                       84
                                                        Figure 4.5
                                            Annual Demand of Sugar
                     200
                     180
                     160
                     140
   Quantity (tons)
                     120
                     100
                      80
                      60
                      40
                      20
                       0
                             2060/61          2061/62           2062/63         2063/64           2064/65
                                                               Fiscal Year
From above table and figure, the annual demand of sugar is reduced up to the
year 2062/63, due to political conflict in the country. But, now it is growing on
slowly with stopped the conflict in the country. The company should formulae
plans and policy about when and how much to buy the inventory.
                                                          85
Where,
                      Annual consumption
       Usage rate =
                      No. of days in a year
       Re-order point = Usage rate × (Lead time + Safety stock)
       Lead time is assumed 2 days on the basis of replay of respondents.
From the table, in a year 2064/65, NTL has to procure 120 tons of sugar with
the number of order 1 times. Also, NTL need minimum balance at re-order
point 1.32 units for all the days in a year.
                                        86
Above calculation shows that if the company seeks to minimize the total cost,
the optimal order should be 1659 units. The number of order size for the Rice
cooker can be calculated by using formula,
                            A   2000
          No. of order =      =      = 1.21
                           EOQ 1659
By the tabulation method, the EOQ for Rice Cooker can be calculated as
follows:
                                   Table No. 4.14
                    Economic Order Quantity of Rice Cooker
  No. of           Order        Average        Carrying     Ordering       Total
  orders            size        Inventory      cost (Rs.)   cost (Rs.)   cost (Rs.)
      1              2           2÷2= 3         3×C=4        1×0=5        4+5=6
      1            2000           1000           8000         5500        13500
      2            1000           500            4000        11000        15000
      3            666.67        333.33        2666.67       16500       19166.67
      4             500           250            2000        22000        24000
      5             400           200            1600        27500        29100
Where,
                                Order size
          Average inventory =
                                    2
          Carrying cost = Average inventory × Carrying cost per unit
          Ordering cost = No. of order × Ordering cost per order
          Total cost = Carrying cost + Ordering cost
The above table shows that the minimum cost of Rice Cooker is Rs.13500,
where total ordering cost and carrying cost are Rs.5500 and Rs.8000
respectively, the number of order is 1 times. If the company orders except 1
times in a year, the cost will increase. Therefore, the company should purchase
Rice Cooker one time over a year.
                                          87
(C)                   The trend of annual demand made by the company for the sugar is
                      given below:
                                                  Table No. 4.15
                                         Annual Demand for Rice Cooker
                            Fiscal year (B.S.)                       Quantity demand (units)
                                2060/61                                       1300
                                2061/62                                       1400
                                2062/63                                       1600
                                2063/64                                       1750
                                2064/65                                       2000
The graphic representation of annual demands of Rice Cooker can be shown as
below:
                                                  Figure No. 4.6
                                         Annual Demand of Rice Cooker
2500
                     2000
   Quantity (tons)
1500
1000
500
                        0
                               2060/61        2061/62         2062/63        2063/64      2064/65
                                                             Fiscal Year
According to Table and Figure, the annual demand of Rice Cooker is growing
in comparison of previous year. It would be due to environmental effect such as
shortage and increase in price of kerosene oil and L.P. Gas, man become
familiar with rice cooker.
                                                        88
(D) Reorder Level and Safety Stock of Rice Cooker
                                    Table No. 4.16
 Calculation of Daily Usage, Lead Time, Safety Stock and Re-order Point
 Fiscal      Usage       Lead      Lead         Stock       Safety    Safety   ROP
  year         rate      time     time ×        (Stock      stock     stock
             (Units)              Usage         days)       (Units)   +Lead
                                   rate                               time
   1            2          3      4=2×3           5         2×5=6     3+5=7    4+6=8
2060/61       3.61        10       36.1           5         18.05      15      54.15
2061/62       3.89        10       38.9           5         19.45      15      58.35
2062/63       4.44        10       44.4           5          22.2      15      66.6
2063/64       4.86        10       48.6           5          24.3      15      72.9
2064/65       5.56        10       55.6           5          27.8      15      8.34
Where,
                        Annual consumption
         Usage rate =
                        No. of days in a year
         Re-order point = Usage rate × [Lead time + Safety stock]
         Lead time is assumed 10 days on the basis of replay of respondents.
From the table, in a year 2064/65, NTL has to procure 2000 units of Rice
Cooker with the number of order 1 times. Also, NTL need minimum balance at
re-order point 83.4 units for all the days in a year.
                                           89
Ordering Charges
      Transportation Charge        = Rs3250
      Bank charge and commission          = Rs.4200
      Telephone, Fax, Interest            = Rs.950
      Total ordering cost                 = Rs.8400
Carrying /Holding Cost
      Insurance Charges                   = Rs.12000
      Administration                      = Rs.3800
      Other                               = Rs.7000
      Total Carrying Cost                 = Rs.22800
                                              22800
      Carrying Cost per ton               =         = 44.1
                                               517
(i)   By fitting the above mentioned data into Economic Order Quantity
      Formula, we get
                   2AO
      EOQ =
                    C
                   2×517×8400
              =
                      44.1
              = 443.79 ~ 444 kg.
Above calculation shows that if the company seeks to minimize the total cost,
the optimal order should be 444 kgs. The number of order size for the
Wintergreen Oil can be calculated by using formula.
                        A   517
      No. of order =      =     = 1.164
                       EOQ 444
That indicates HPPCL should place its order at once.
                                     90
                                    Table No. 4.17
                 Economic Order Quantity of Wintergreen Oil
  No. of          Order          Average        Carrying     Ordering         Total
  orders           size          Inventory      cost (Rs.)   cost (Rs.)   cost (Rs.)
     1              2             2÷2= 3         3×C=4        1×0=5        4+5=6
     1            517.00          258.50        11399.85       8400       19799.85
     2            258.50          129.25        5699.93       16800       22499.93
     3            172.33          86.17         3800.10       25200       29000.10
     4            129.25          64.63         2850.18       33600       36450.18
     5            103.40          51.70         2279.97       42000       44279.97
Where,
                                 Order size
         Average inventory =
                                     2
         Carrying cost = Average inventory × Carrying cost per unit
         Ordering cost = No. of order × Ordering cost per order
         Total cost = Carrying cost + Ordering cost
From the use of calculation, it is cleared that by the use of tabulation method,
the minimum cost of wintergreen oil is Rs.19799.85, where the total ordering
cost is Rs.8400 and total carrying cost is Rs.11399.85 respectively.
If the company order two times in year, the cost will be increased by (22499.93
- 19799.85) Rs.2700.08. So, company should order the wintergreen oil once a
year to minimize its cost.
(C) The trend of annual demand made by the company for the
     Wintergreen oil is given below:
                                    Table No. 4.18
                        Annual Demand for Wintergreen Oil
            Fiscal year (B.S.)                         Quantity demand (kg)
                 2060/61                                       2100
                 2061/62                                       1752
                 2062/63                                       1545
                 2063/64                                        850
                 2064/65                                        517
                                           91
The graphic representation of annual demands of Wintergreen Oil can be
shown as below:
                                          Figure No. 4.7
                                     Annual Demand of Sugar
2500
                    2000
   Quantity (kg.)
1500
1000
500
                       0
                           2060/61    2061/62         2062/63      2063/64   2064/65
                                                     Fiscal Year
From the table and figure, it is clear that the company has no fixed rule applied.
The purchase made by the company is haphazard. It does not follow according
to the EOQ model. The annual demand of Wintergreen Oil is respectively
decreasing in corresponding latest year. It would be happen because in general,
increase in price of goods forced people to reduce consumption.
HPPCL procure Wintergreen oil 517 liters. in a year. The policy of company's
is to maintain 30 days for lead time and 5 days minimum balance of safety
stock. To analyze the re-order point of wintergreen oil on the basis of lead time,
safety store and daily usage rate, we can used following procedure.
                                                92
                                    Table No. 4.19
 Calculation of Daily Usage, Lead Time, Safety Stock and Re-order Point
 Fiscal      Usage       Lead      Lead         Stock       Safety    Safety   ROP
  year        rate       time      time ×       days        stock     stock
              (kg)      (days)     Usage                    (Units)   +Lead
                                    rate                              time
   1           2           3      4=2×3           5         2×5=6       7      4+6=8
2060/61      5.833        30       175.0          5         29.17      35      204.17
2061/62       4.87        30       146.1          5         24.35      35      170.45
2062/63       4.29        30       128.7          5         21.45      35      150.15
2063/64       2.36        30        70.8          5         11.80      35      82.60
2064/65       1.44        30        43.2          5          7.20      35      50.40
Where,
                        Annual consumption
         Usage rate =
                        No. of days in a year
         No. of days in a year assumed 360 days
The table includes calculation of ROP with safety stock. The company needs
wintergreen oil with 35 days safety stock all the day. In year 2064/65 HPPCL
has procure 517 kg. of wintergreen oil with no. of order 1 times. According to
ROP, the company should placed an order with 35 days consumption remains
balance i.e. 50.40 kg.
                                           93
      Telephone, Fax, Interest   = Rs.150
      Total ordering cost        = Rs.1240
(i)   By fitting the above mentioned data into Economic Order Quantity
      Formula, we get
                   2AO
      EOQ =
                    C
                   2×150×1240
              =
                      19.2
              = 139 kg.
Above calculation shows that if the company seeks to minimize the total cost,
the optimal order should be 139 kgs. The number of order size for the
Xanthoxylum Oil can be calculated by using formula.
                        A   150
      No. of order =      =     = 1.079
                       EOQ 139
      Therefore the number of order for the Xanthoxylum oil is 1.
                                    94
                                  Table No. 4.20
                Economic Order Quantity of Xanthoxylum Oil
  No. of          Order        Average        Carrying     Ordering       Total
  orders           size        Inventory      cost (Rs.)   cost (Rs.)   cost (Rs.)
     1              2           2÷2= 3         3×C=4        1×0=5        4+5=6
     1             150            75            1440         1240         2680
     2              75           37.5            720         2480         3200
     3              50            25             480         3720         4200
     4             37.5         18.75            360         4960         5320
     5              30            15             288         6200         6488
Where,
                               Order size
         Average inventory =
                                   2
         Carrying cost = Average inventory × Carrying cost per unit
         Ordering cost = No. of order × Ordering cost per order
         Total cost = Carrying cost + Ordering cost
In case of Xanthoxylum Oil, the EOQ comes to 150 kg. Per order which gives
the number of order per year is one. The number of order per year is again
justified by the use of tabulation method. This is the best possible number of
order, where the total ordering cost and carrying cost is minimum.
In this case, the carrying cost is Rs.1440 and ordering cost is Rs.1240
respectively gives the total cost of Rs.2680. If the company order two times in
a year the cost will be increased by Rs.(3200-2680) 520. So, the company
should order the Xanthoxylum Oil once a year to minimize its cost.
                                         95
(C)                  The trend of annual demand made by the company for the
                     Xanthoxylum Oil is given below:
                                               Table No. 4.21
                                   Annual Demand for Xanthoxylum Oil
                          Fiscal year (B.S.)                         Quantity demand (kg)
                              2060/61                                        218
                              2061/62                                        276
                              2062/63                                        300
                              2063/64                                        240
                              2064/65                                        150
350
300
                    250
   Quantity (kg.)
200
150
100
50
                      0
                             2060/61       2061/62         2062/63         2063/64     2064/65
                                                          Fiscal Year
From the table and figure, it is clear that the company has no fixed rule applied.
The purchase made by the company is haphazard. It does not follow according
to the EOQ model. The annual demand of Xanthoxylum Oil is increasing up to
2062/63, than it is decreasing in corresponding latest year. It would be
happened due to poor quality and less demand of product.
                                                     96
(D) Reorder Level and Safety Stock of Xanthoxylum Oil
HPPCL procure Xanthoxylum Oil 150 kg. in a year. The policy of company's is
to maintain 15 days for lead time and practice used by the company for the
safety stock its equal to 4 days consumption.
                                    Table No. 4.22
             Calculation of Daily Usage, Lead Time, Safety Stock
                                 and Re-order Point
 Fiscal      Usage      Lead      Lead          Stock    Safety      Safety   ROP
  year        rate      time      time ×        (Stock       stock   stock
                        (days)    Usage         days)        (kg)    +Lead
                                   rate                              time
   1           2          3       4=2×3           5      2×5=6       3+5=7    4+6=8
2060/61      0.61        15        9.15           4          2.44     19      11.59
2061/62      0.77        15       11.55           4          3.08     19      14.63
2062/63      0.83        15       12.45           4          3.32     19      15.77
2063/64      0.67        15       10.05           4          2.68     19      12.73
2064/65      0.42        15        6.30           4          1.68     19      7.98
Where,
                        Annual consumption
         Usage rate =
                        No. of days in a year
         No. of days in a year assumed 360 days
The table includes calculation of ROP with safety stock. The company need
Xanthoxylum Oil with 19 days safety stock all the day. In year 2064/65
HPPCL has procure 150 kg of Xanthoxylum oil with no. of order 1 times.
According to ROP, the company should place an order with 19 days
consumption remains balance i.e. 7.98 kg.
                                           97
Ordering Charges
      Transportation Charge      = Rs.1450
      Bank charge and commission         = Rs.1960
      Telephone, Fax, Interest   = Rs.580
      Total ordering cost        = Rs.3990
(i)   By fitting the above mentioned data into Economic Order Quantity
      Formula, we get
                   2AO
      EOQ =
                    C
                   2×4680×3990
              =
                       3.73
              = 3164.24 kg.
              = 3164 kg.
Above calculation shows that if the company seeks to minimize the total cost,
the optimal order should be 3164 kgs. The number of order size for the
Eucalyptus Oil can be calculated by using formula.
                        A   4680
      No. of order =      =      = 1.48
                       EOQ 3164
                                    98
                                  Table No. 4.23
                 Economic Order Quantity and Eucalyptus Oil
  No. of          Order        Average        Carrying     Ordering       Total
  orders           size        Inventory      cost (Rs.)   cost (Rs.)   cost (Rs.)
     1              2           2÷2= 3         3×C=4        1×0=5        4+5=6
     1            4680           2340          6224.4        1590        7814.4
     2            2340           1170          3112.2        3180        6292.2
     3            1560           780           2074.8        4770        6844.8
     4            1170           585           1556.1        6360        7916.1
     5             936           468          1244.88        7950       9194.88
Where,
                               Order size
         Average inventory =
                                   2
         Carrying cost = Average inventory × Carrying cost per unit
         Ordering cost = No. of order × Ordering cost per order
         Total cost = Carrying cost + Ordering cost
From above calculation, it is clear that by the use of tabulation method, the
minimum cost of Eucalyptus Oil is Rs.6292.20, which lies in the order size of
2340 kg. The number of order per year is again justified by the use of
tabulation method. This it the best possible number of order, where the total
carrying cost and ordering cost is lowest. If the company orders except two
times in a year, the cost will increase. So, company should order the Eucalyptus
Oil twice a year to minimize its cost.
                                         99
(C) The trend of annual demand made by the company for the
                Eucalyptus Oil is given below:
                                              Table No. 4.24
                                 Annual Demand for Eucalyptus Oil
                       Fiscal year (B.S.)                           Quantity demand (kg)
                           2060/61                                         2905
                           2061/62                                         3224
                           2062/63                                         4379
                           2063/64                                         4510
                           2064/65                                         4680
The graphic representation of annual demands of Eucalyptus Oil can be shown
as below:
                                               Figure No. 4.9
                                  Annual Demand of Eucalyptus Oil
                    5000
                    4500
                    4000
                    3500
   Quantity (kg.)
                    3000
                    2500
                    2000
                    1500
                    1000
                     500
                       0
                           2060/61          2061/62          2062/63      2063/64     2064/65
                                                            Fiscal Year
From the table and figure, the annual demand of Eucalyptus Oil is increasing
corresponding latest year. It would be happen due to right demand of product.
                                                      100
(D) Reorder Level and Safety Stock of Eucalyptus Oil
The company procure Eucalyptus Oil is 4680 kg in a year. By the use of EOQ
formula, we have computed the quantity of Eucalyptus Oil to be procured in a
year 3164 kg. With the number of order per year is 2 times. The lead time for
the procurement of this product is 25 days and the practiced used by the
company for the safety stock is equal to 5 days consumption.
Where,
                        Annual consumption
         Usage rate =
                        No. of days in a year
         No. of days in a year assumed 360 days
The table includes calculation of ROP with safety stock. HPPCL need
Eucalyptus Oil with 30 days safety stock all the day. In year 2064/65 HPPCL
has procure 4680 kg of Eucalyptus Oil with no. of order 2 times. According to
ROP, the company should place an order when 30 days consumption remains
balance i.e. 390 kg.
                                           101
(4) Cinnamon Leaf (Tejpat) Oil
(A) Optimum Order Level (By Formula Method):
Based on the company records, the following data are available,
      Annual Demand (A)                     = 137 kg.
      Total Amount tied up                  = Rs.137×5000= Rs.685000
Ordering Charges
      Transportation Charge         = Rs.350
      Bank charge and commission            = Rs.280
      Telephone, Fax, Interest      = Rs.150
      Total ordering cost           = Rs.780
Carrying /Holding Cost
      Insurance Charges             = Rs.800
      Administration                = Rs.360
      Other                         = Rs.700
      Total Carrying Cost           = Rs.1860
                                                1860
      Carrying Cost per ton                 =        = 13.58
                                                137
(i)   By fitting the above mentioned data into Economic Order Quantity
      Formula, we get
                   2AO
      EOQ =
                    C
                   2×137×780
              =
                     13.58
              = 125.45
              = 125 kg. (Approx.)
It means that if the company seeks to minimize the total cost by compromising
the carrying cost and ordering cost, the economic order quantity should be 125
kg. of Cinnaman Lef Oil. Now we are able to calculate the number of order for
cinnamon leaf oil per year by using the formula.
                        A   137
      No. of order =      =     = 1.096
                       EOQ 125
                                      102
(B)         Optimum Order of Inventory (Tabulation Method)
By the tabulation method, the EOQ for Cinnamon Leaf Oil can be calculated as
follows:
                                     Table No. 4.26
                 Economic Order Quantity and Cinnamon Leaf Oil
  No. of             Order        Average         Carrying     Ordering       Total
  orders              size        Inventory       cost (Rs.)   cost (Rs.)   cost (Rs.)
        1              2           2÷2= 3          3×C=4        1×0=5        4+5=6
        1             137           68.5           930.23         780       1710.23
        2             68.5         34.25           465.12        1560       2025.12
        3            45.67         22.835          310.10        2340       2650.10
        4            34.25         17.125          232.56        3120       3352.56
        5            27.40         13.70           186.05        3900       4086.05
Where,
                                  Order size
            Average inventory =
                                      2
            Carrying cost = Average inventory × Carrying cost per unit
            Ordering cost = No. of order × Ordering cost per order
            Total cost = Carrying cost + Ordering cost
The EOQ in case of Cinnamon leaf oil is 125 kg. per order, which gives the
number of order per year is 1. From the tabulation method, the number of order
is also one where the total ordering and carrying cost are low.
In this case, the carrying cost and ordering cost are Rs.930.23 and Rs.780
respectively which gives the total cost of Rs.1710.23. This is the lowest
possible cost. So, the company should order once in a year to reduce the total
cost.
                                            103
(C)                 The trend of annual demand made by the company for the
                    Cinnamon leaf oil is given below:
                                                   Table No. 4.27
                                       Annual Demand for Cinnamon Leaf
                          Fiscal year (B.S.)                                 Quantity demand (kg)
                              2060/61                                                198
                              2061/62                                                261
                              2062/63                                                184
                              2063/64                                                137
                              2064/65                                                137
300
250
                    200
   Quantity (kg.)
150
100
50
                     0
                             2060/61           2061/62          2062/63            2063/64     2064/65
                                                               Fiscal Year
From the table and figure, it is clear that the company has no fixed rule applied.
The purchase made by the company is haphazard. It does not follow according
to the EOQ model. The annual demand of Cinnamon leaf oil is increased and
decreased by great quantity.
                                                         104
(D) Reorder Level and Safety Stock of Cinnamon Leaf Oil
The lead time for the procurement of this product is 10 days and the practiced
used by the company for the safety stock is equal to 4 days consumption.
                                    Table No. 4.28
 Calculation of Daily Usage, Lead Time, Safety Stock and Re-order Point
 Fiscal     Usage       Lead      Lead          Stock    Safety    Safety   ROP
  year        rate      time     time ×         (Stock   stock     stock
                        (days)    Usage         days)    (Units)   +Lead
                                   rate                            time
   1           2          3      4=2×3            5      2×5=6     3+5=7    4+6=8
2060/61      0.55        10        5.5            4       2.20      14      7.70
2061/62      0.73        10        7.3            4       2.92      14      10.22
2062/63      0.51        10        5.1            4       2.04      14      7.05
2063/64      0.38        10        3.8            4       1.52      14      5.32
2064/65      0.38        10        3.8            4       1.52      14      5.32
Where,
                        Annual consumption
         Usage rate =
                        No. of days in a year
         No. of days in a year assumed 360 days
The table includes calculation of ROP with safety stock. The company needs
Cinnamon Leaf Oil with 14 days safety stock all the day. In year 2064/65
HPPCL has procure 137kg of Cinnamon Leaf Oil with no. of order 1 time.
According to ROP, the company should place an order when 14 days
consumption remains balance i.e. 5.32 kg.
                                          105
4.3 Correlation between Sales and Net Profit.
                       N  XY -  X  Y
         r
              N  X 2  ( X ) 2 N  Y 2  ( Y ) 2
= 0.95
                                           106
4.3.2 HPPCL
                                         Table No. 4.30
                  Correlation between Sales and Net Profit of HPPCL
                                                                             Rs. in million
 Fiscal                          Net
                   Sales                            X2             Y2             XY
      year                      Profit
2060/61             341.39        30.16         116547.13           909.63       10296.32
2061/62             348.19        36.91         121236.28         1362.35        12851.69
2062/63             415.39        42.32         172548.85         1790.98        17579.30
2063/64             396.93        35.94         157553.42         1291.68        14265.66
2064/65             333.07        21.93         110935.62           480.92        7304.23
     Total         1834.97       167.26         678821.31         5835.56        62297.21
Source: Annual Report of HPPCL
Correlation between sales (x) and Net Profit (y)
                           N  XY -  X  Y
             r
                  N  X 2  ( X ) 2 N  Y 2  ( Y ) 2
             =      0.45
             Correlation (r) = 0.45
                                              107
iii)    HPPCL and National Trading Limited also has established a separate
        unit for management of inventory although the separate unit is
        unable to manage the inventory effectively.
iv)     Both company have not categorized its inventory for the purpose of
        control and paid equal attention for the entire inventory held in the
        store.
v)      In the both company the annual demand and purchase made by
        company differ from year to year and highly fluctuated.
vi)     Cost related with ordering and holding inventory is not recorded
        separate in both companies which are recorded as a whole.
vii)    The raw materials used by HPPCL are not classified according to
        ABC.
viii)   Purchase of raw material in HPPCL is on the agreement and local
        tender basis some materials are imported and some are taken from
        the market with huge amount at a time.
ix)     In the company, there are different types of inventories, like RM, WIP,
        finished goods and stores and spare parts. For the question is asked to
        reveal the ranking of cost for solution of ABC analysis the company
        could give only the name of inventories but not specified the cost.
x)      For the question asked to HPPC about the cost of ordering and carrying,
        the researcher found that there is no systematic and scientific system to
        determine ordering and carrying cost but in NTL there is limited type of
        ordering and carrying cost management system.
xi)     Purchasing is the first step of inventory management of manufacturing
        companies. As the question was asked about the purchasing system they
        said that procedures are followed by HPPC. The researcher had found
        that the company has been following the centralize purchasing
        procedure and required RM and WIP materials are purchased form
        Nepalese and Indian's brokers.
xii)    As the question is asked to NTL about the valuation of inventories with
        various options, the researcher found that the pricing of issues can be
                                      108
        determined by value as per weighted average cost method but in HPPCL
        there is they were not aware about valuation of pricing the inventory.
xiii)   There are various problems faced by the manufacturing companies
        regarding the management of inventories. As the question asked to
        HPPCL about the problem faced by the HPPCL in managing the
        inventories, the researcher found the following major problems faced by
        the company while operating and managing the inventories.
        Political crisis and especially Nepal Bandh, uncertainty about the future
        supply of materials, operation of factory strikes, fluctuation of material
        prices and lockout organized by different pressure groups directly affect
        the company and its inventory management while geographical barriers
        and transportation problems are other problems faced by both company.
xiv)    The company has not been adopting appropriate inventory policy
        because inventory constitutes the higher proportion than that of other
        items of current assets. The co. has not followed any type of inventory
        policies.
xv)     The fluctuation in stock of RM during the study period is very high.
        Defective purchasing policy and poor planning of raw materials are the
        main responsible factors for such fluctuation. There is no fixed policy of
        purchasing materials.
xvi)    Demand and sales of both company is very fluctuation. The main reason
        of such fluctuation is lack of appropriate inventory policy and
        ineffective demand forecast.
xvii) The correlation between sales and net profit shows that significant
        relationship between sales and net profit.
xviii) The both company have used EOQ model to manage and control of the
        inventory but there is not satisfactory result.
xix)    Both company have not defined its objectives clearly in terms of
        quantity and quality.
                                        109
                             CHAPTER V
5.1 Summary
In present context, public enterprises provide the goods and services which
are provided by private enterprises are more effective. Public enterprises
face two types of challenges, the first one is to meet public responsibility of
providing goods and services cheaply and the second one is to utilize the
scarce resources more effectively. In this context, the study is concerned to
appraise HPPCL and National Trading Limited examine that in what extent
the company is applying inventory management and control system so as to
minimize the cost, that ultimately affect the price of manufacturing goods
and trading goods. Most of the manufacturing and trading company invests
a huge amount of money in inventories. The expenses involve for carrying
on functional associated with inventories such as purchasing, handling
storage and record keeping is large. Thus in recent year, the subject
inventory management has engaged the attention of management and
extensive literature has evolved which encompass statistical tools like
economic order quantity for how much to purchase together with the re-
order point.
There are certain problems of the study. Therefore, the basis problem of
this study is to examine the inventory management system practiced by the
                                    110
company. The order size, carrying cost, ordering cost, safety stock are
determined unscientifically by the company and is not given proper
attention to the lead-time and all these functions lead to increase the total
cost of the company.
All the collected data and facts are analyzed on the basis of inventory
management theory and with the help of ABC analysis, EOQ model, and
Re-order label as well as safety stock. For making certain type of inventory
management decision, many mathematical tools and techniques have been
available for controlling the inventory but these companies have not applied
any sort of techniques for managing their inventories.
Every study has certain findings, so that, the following findings are
extracted from this study about the inventory management and control of
Herbs Production and Processing Company Limited and National Trading
Limited.
   1. Purchase of inventory and goods haphazardly by the national trading
      and HPPCL. In other words, the purchase quantities made by the
      company differ from year to and are not in economic order quantity.
   2. HPPCL and National Trading Limited also has established a separate
      unit for management of inventory although the separate unit is
      unable to manage the inventory effectively.
                                    111
   3. In the National Trading Limited the EOQ model is not applied and
      the company has maintained the safety stock which is highly
      fluctuated and estimated roughly and HPPCL has also same
      condition.
   4. Both company have not categorized its inventory for the purpose of
      control and paid equal attention for the entire inventory held in the
      store.
   5. In the both company the annual demand and purchase made by
      company differ from year to year and highly fluctuated.
   6. Cost related with ordering and holding inventory is not recorded
      separate in both companies which are recorded as a whole.
   7. The raw materials used by HPPCL are not classified according to
      ABC.
   8. Purchase of raw material in HPPCL is on the agreement and local
      tender basis some materials are imported and some are taken from
      the market with huge amount at a time.
5.2 Conclusion
On the basis of analysis of data and information collected from HPPCL and
NTL separately the following conclusion have been drawn.
                                  112
Though, these models, example and formula etc. For managing inventory
are available they could not be used fully for finding out the necessary
operation of the company because of the lack of adequate data. No
techniques for inventory management are possible to apply to calculate one
of the major decisions when to buy because of the lack of planning and
unsystematic methods of recording cost. If no concrete step is taken with
regards to recording and maintaining of proper data on stock out cost,
carrying cost, ordering cost, price of raw material etc. Separately, future
researcher would not be able to predict the re-order period and how much
to maintain the safety stock properly. Thus, in the real situation of the
operation of the company regarding its inventory managing system could
not be found. From study and analysis of data, inventory management and
control system is same.
5.3 Recommendation
                                    113
   and consumer can use with low cost than company can increase their
   selling.
4. Expert technicians are needed for the production of qualitative
   products and effective sales plan. So the process of selection and
   recruitment techniques should be unbiased.
5. To manage inventory, ledger cards can also be used by both
   companies. In this card the name of items, item numbers, unit price,
   usage rate, suppliers name, the percentage of carrying cost and the
   ordering cost, data of order and its receipts with date, quantity used
   and issues of raw materials are maintained.
6. Job evaluation should be launched in certain time interval so that the
   hard-working employees can be reworded and the task avoiding once
   can be taken into action of both companies.
7. In case of HPPCL, the encouragement should be done to the farmers
   to cultivate herbs plants.
8. Record keeping system should be scientific and computerized. So
   that the corporation can locate the past records which are helpful for
   the researcher as well as concern parties of this company.
9. The vision of the top level management should be clear for solving the
   problems appeared in course of inventory management system.
10.The frequently changing of the general manager has also affected the
   management. It should create unstable environment. Therefore, the
   post of the manger should be professionalized and it should be far
   from political interfering.
                                 114
                        BIBLIOGRAPHY
Books
   Adam, Evertte E. & Ronald, Ebert J. (1993), "Production and
            Operation Management", New Delhi : Prentice Hall of India
            Pvt. Ltd.
   Chase, B. Richard and Aquvio, Nicholas J. (1973), "Production and
            Operation Management", Georgetown Ontario : Irwin-
            Dowsay Ltd.
   Chaudhary, Dr. S.R. Roy (1999), "Accounting Theory and
            Management Accounting", New Delhi : S. Chand & Sons
            Company.
   Dangol, Ranta Man (2059), "Accounting for Financial Analysis and
            Planning", Kathmandu : Taleju Prakashan.
   Goal, B.S. (1992), "Production and Operation Management", India :
            Pragati Prakashan.
   Goyal, M.M. & B.S. (1992), "Production Management", India:
            Pragati Prakashan.
   Goyal, M.M. and S.N. (1993), "Principals of Management
            Accounting", Agra : Shahity Bhawan.
   Hampton, J.H. (1990), "Financial Decision Making Practice", New
            Delhi : Prentice Hall of India Pvt. Ltd.
   Horngreen, Charles (2002), "Introduction to Financial Accounting",
            Singapore : Pearson Education Inc.
   Jain, S.P. and Narang, K.L. (1994), "Advanced Accountancy", New
            Delhi : Kalyani Publisher.
   James, C. Van Horne (1979), "Financial Management and Policy",
            New Delhi : Prentice Hall of India Pvt. Ltd.
   Jawahar Lal (1996), "Cost Accounting", 2nd Edition, New Delhi :
            Tata McGarw-Hill Publishing Co. Ltd.
                                 115
   Killeen, Lousis M. (1969), "Techniques of Inventory Management",
             USA : American Management Association.
   Larson, K.D. (1997), "Financial Accounting Principles", New Delhi
             : Tata McGraw Hill Publishing Co.
   Magee, F. John (1985), "Production Planning and Inventory
             Control", Tokyo : McGraw Hill.
   Pandey, I.M. (1993), "Financial Management", New Delhi : Vikash
             Publishing House Pvt. Ltd.
   Ross, H. Jonson and Pool, R. Winn (1979), "Quantitative Methods
             for Management", New York : American Association.
   Sahajanha, S.K. and Datta, Subir (1997), "Theory and Practice of
             Cost Accounting", New Delhi : S. Chand & Company.
   Sharma, R.K. and Gupta, Shashi K. (1995), "Management
             Accounting Principles and Practice",       India : Kalyani
             Publishers.
   Shrestha, M.K. (2037), "Financial Management: Theory and
             Practice", Kathmandu : CDM, T.U.
   Star, Martin K. and Devid, W. Miller (1962), "Inventory Control:
             Theory and Practices", New Delhi : Prentice Hall of India,
             Pvt. Ltd.
   Western, J. Fred and Eugene F. Bringham (1981), "Managerial
             Finance", Tokyo : The Dryden Press.
                                116
 Bajracharya, Samarna (2003), A Study on Financial Position of
          National    Trading    Limited,   Dissertation,   Faculty   of
          Management, T.U.
 Baral, Puspa Raj (1996), "Inventory Management", A Case Study of
          Gandaki Noodles Pvt. Ltd., Dissertation, Faculty of
          Management, T.U.
 Bhandari, Gopi (1993), "Profit Planning in Nepal", Case Study of
          Royal Drug Limited, Dissertation, Faculty of Management,
          T.U.
 CCC (2033), "Study Report of Bansbari Lather and Shoes Factory",
          HMG/Nepal.
 CEDA (1973), "Study of the Transportation Corporation of Nepal",
          T.U., Kirtipur.
 CEDA (1974), "A Study on Agriculture Tools Faculty Ltd.", T.U.,
          Kirtipur.
 I.S.C. (2036), "Performance Report on Biratnagar Jutemill Ltd.",
          HMG/Nepal.
 Karki, N.B. (1999), "Inventory Management and Control: A Case
          Study of Sajha Swasthya Sewa", An Unpublished Master
          Degree Thesis, T.U., Kirtipur.
 National Trading Limited (1986), "National Trading Limited, An
          Introductory Profile", Teku : National Trading Limited.
 Pandey, L. (2000), "Inventory Management: A Case Study of
          Gorkhapatra Corporation", An Unpublished Master Degree
          Dissertation, Faculty of Management, T.U., Kirtipur.
 Pandey, Laxmi (2000), "Inventory Management: A Case Study of
          Gorkhapatra       Corporation",   Dissertation,   Faculty   of
          Management, T.U.
                                117
 Pant, Dinesh Kumar (1999), "Impact of Inventory Over the Profit: A
          Case Study of Gorkhapatra Corporation", Dissertation,
          Faculty of Management, T.U.
 Panta, D.K. (1999), "Inventory Over the Profit: A Case Study of
          Gorkhapatra    Corporation",    Dissertation,   Faculty   of
          Management, T.U., Kirtipur.
 Rawal, Ram Bahadur Chhetri (1999), "Inventory Management: A
          Case Study of Agriculture Input Corporation with Special
          Reference to Chemical Fertilizer in Kathmandu Valley",
          Dissertation, Faculty of Management, T.U.
 Sharma, A.K. (1996), "Inventory Management: A Case Study of
          Royal Drugs Limited", An Unpublished Master Degree
          Dissertation, Faculty of Management, T.U., Kirtipur.
 Shrestha, Indra (2000), "Inventory Management of Manufacturing
          Industries in Nepal with Reference to Quick Foods",
          Dissertation, Faculty of Management, T.U.
 Shrestha, K.N. (2000), "Inventory Management: A Case Study of
          Royal Drugs Limited", An Unpublished Master Degree
          Dissertation, Faculty of Management, T.U., Kirtipur.
118