The construction of a warehouse using data from DuPont Pharmaceutical’s Clinical Pharmacokinetics Group with the SAS/Warehouse Administrator product is described herein. Data sources incorporated into the pharmacokinetic warehouse existed in multiple formats (Oracle, Excel, SAS data sets, etc) and were represented by numerous individual files, rather then few large files. In most cases, the da...

A two-echelon push control system with one central warehouse and m branch warehouses is considered. The system is replenished once every cycle from an outside supplier and each cycle is divided into two different phases. While retaining the safety stock at the central warehouse, the bulk of inventories is directly shipped to the branch warehouses at the bel~inning of the first phase, and at the...

This paper deals with an inventory system with one central warehouse and a number of identical retailers. We consider perishable-on-theshelf items; that is, all items have a fixed shelf life and start to age on their arrival at the retailers. Each retailer faces Poisson demand and employs (1, T) inventory policy. Although demand not met at a retailer is lost, the unsatisfied demand at the centr...

This paper deals with an inventory system with one central warehouse and a number of identical retailers. We consider perishable-on-theshelf items; that is, all items have a fixed shelf life and start to age on their arrival at the retailers. Each retailer faces Poisson demand and employs (1, T) inventory policy. Although demand not met at a retailer is lost, the unsatisfied demand at the centr...

Inventories exist throughout the supply chain in various forms for various reasons. Since carrying these inventories can cost anywhere from 20 to 40% of their value a year, managing them in a scientific manner to maintain minimal levels makes economic sense. This paper presents a near-optimal (s, Q)-type inventory policy for a production/distribution network with multiple suppliers replenishing...

Strong competition in the manufacturing industry makes efficient and effective manufacturing processes a critical success factor. However, existing warehousing and analytics approaches in manufacturing are coined by substantial shortcomings, significantly preventing comprehensive process improvement. Especially, they miss a holistic data base integrating operational and process data, e. g., fro...

This study aims at optimally coordinating inventory among all the partners in a supply chain system with a central warehouse and multiple local retailers so as to minimize the average total costs. After reviewing the literature, we found no study proposes an efficient solution approach that guarantees to secure an optimal solution for the one-warehouse multi-retailer lot-sizing problem. A major...

In this paper, we introduce a dynamic multidimensional model, which is suitable for building text warehouses. The dimensions are atomic semantic categories embedded in a familiar taxonomy. This approach to text warehouses requires a large number of dimensions, some of which may be not known in advance. Central to the dynamic multi-dimensional model is the meta-snow ake schema, which is a snow a...