A queuing approach for inventory planning with batch ordering in multi-echelon supply chains

This paper presents stylized models for conducting performance analysis of the manufacturing supply chain network (SCN) in a stochastic setting for batch ordering. We use queueing models to capture the behavior of SCN. The analysis is clubbed with an inventory optimization model, which can be used for designing inventory policies . In the first case, we model one manufacturer with one warehouse, which supplies to various retailers. We determine the optimal inventory level at the warehouse that minimizes total expected cost of carrying inventory, back order cost associated with serving orders in the backlog queue, and ordering cost. In the second model we impose service level constraint in terms of fill rate (probability an order is filled from stock at warehouse), assuming that customers do not balk from the system. We present several numerical examples to illustrate the model and to illustrate its various features. In the third case, we extend the model to a three-echelon inventory model which explicitly considers the logistics process.

GRDB: A general purpose relational database system

This article discusses the design and development of GRDB (General Purpose Relational Data Base System) which has been implemented on a DEC-1090 system in Pascal. GRDB is a general purpose database system designed to be completely independent of the nature of data to be handled, since it is not tailored to the specific requirements of any particular enterprise. It can handle different types of data such as variable length records and textual data. Apart from the usual database facilities such as data definition and data manipulation, GRDB supports User Definition Language (UDL) and Security definition language. These facilities are provided through a SEQUEL-like General Purpose Query Language (GQL). GRDB provides adequate protection facilities up to the relation level. The concept of “security matrix” has been made use of to provide database protection. The concept of Unique IDentification number (UID) and Password is made use of to ensure user identification and authentication. The concept of static integrity constraints has been used to ensure data integrity. Considerable efforts have been made to improve the response time through indexing on the data files and query optimisation. GRDB is designed for an interactive use but alternate provision has been made for its use through batch mode also. A typical Air Force application (consisting of data about personnel, inventory control, and maintenance planning) has been used to test GRDB and it has been found to perform satisfactorily.

An inventory of the ethnobotanicals used as anti-diabetic by a rural community of Dhemaji district of Assam, Northeast India

Ethnopharmacological relevance: Traditional remedies used for treating diabetic ailments are very important in the primary health care of the people living in rural Dhemaji district of Assam, north-east India. Novel information gathered from the current survey is important in preserving folk indigenous knowledge. Materials and methods: Interviews were conducted amongst 80 households comprising of 240 individuals using semi-structured questionnaires. The focus was on plants used in treating diabetes mellitus. Results: The current survey documented 21 plant species (20 families) which are reportedly used to treat diabetes mellitus by the rural people in the study area. To the best of our knowledge, Amomum linguiforme, Cinnamomum impressinervium, Colocasia esculenta, Dillenia indica, Euphorbia ligularia, Garcinia pedunculata, Solanum indicum, Sterculia villosa and Tabernaemontana divaricata are recorded for the first time based on globally published literature as medicinal plants used for treating diabetes mellitus and related symptoms. Conclusions: The wide variety of plants that are used to treat diabetes mellitus in this area supports the traditional value that medicinal plants have in the primary health care system of the rural people of Dhemaji district of Assam. The finding of new plant uses in the current study reveals the importance of the documentation of such ethnobotanical knowledge. (C) 2011 Elsevier Ireland Ltd. All rights reserved.