Return to Index
Operations Research Models and Methods
 
excel head
Subunit Operations Management/Industrial Engineering
  - Inventory
  We compute the Economic Lot Size with or without backorders or lost sales. We also allow either finite or infinite replenishment rates. Both deterministic and stochastic models are considered. The add-in finds the optimum lot size with cost breaks. Three optimization models that involve more than one item are solved: multi-item systems, inventories with common cycle times and machine scheduling. The add-in includes several models of manufacturing processes that produce Work-in-Process. Total WIP and cycle times are computed for combinations of inventories arranged into systems.
Add-in - Click the add-in name to download a zipped .xla file.
Add-in Name
File
Date
inventory.xla
2/06/2011

 

Demonstration Files - Click the demo name to download a .xls file.
Demo Name
File Name
 
invdem.xls
 
inv_wip_demo.xls
 
inv_system.xls
 
inv_functions.xls
 
gray line
  
Return to Top

tree roots

Operations Research Models and Methods
Internet
by Paul A. Jensen
Copyright 2010 - All rights reserved