Database structure for a class of multi-period mathematical programming models

  • Authors:
  • Goutam Dutta;Robert Fourer

  • Affiliations:
  • Indian Institute of Management, Ahmedabad, Vastrapur, Ahmedabad 380015, India;Department of Industrial Engineering and Management Sciences, Northwestern University, Evanston, IL 60208, USA

  • Venue:
  • Decision Support Systems
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

We describe how a generic multi-period optimization-based decision support system can be used for strategic and operational planning in a company whose processes can be described in terms of five fundamental elements: Materials, Facilities, Activities, Times and Storage-Areas. We discuss the issues of interface design, data reporting and updating, and optimal production and profit planning. We also compare the performances of two different types of database structures with respect to optimization.