Computation Section
Inventory Analysis

Inventories are materials stored, waiting for processing, or experiencing processing. They are ubiquitous in modern business. Observation of almost any company balance sheet reveals that a very significant part of its assets comprise inventories of raw materials, products within the production process, or finished products.

Because of their practical and economic importance, the subject of inventory control is a major consideration in many situations. Questions must be constantly answered as to when and how much raw material should be ordered, when a production order should be released to the plant, what level of safety stock should be maintained at a retail outlet, or how in-process inventory is to be maintained in a production process. These questions are amenable to quantitative analysis through the subject of inventory theory. This add-in embodies some of the mathematical results of inventory theory.

 



The add-in places new items under the OR/IE menu. Choose Add Inventory to create the inventory definition on the worksheet. The Optimize command is used to construct optimization models of multi-item systems. The System command builds systems of inventory components. The New Functions/Buttons command is necessary when a worksheet is opened that contains functions created by the add-in on a different computer. In order to see the results on the demo workbook, you will have to choose this command first. This must be done for each worksheet that contains functions or buttons.

Inventory models all involve some level of abstraction from reality. The first abstraction removes all statistical variability from the situation. Thus we call these models deterministic. The next page considers the single product deterministic models.


  
Return to Top

tree roots

Operations Management / Industrial Engineering
by Paul A. Jensen
Copyright 2004 - All rights reserved

Next Page