# Optimization modeling for spreadsheetsPortland

**Topics:**Operations research, Optimization, Linear programming

**Pages:**36 (6468 words)

**Published:**October 18, 2014

Engineering & Technology Management

ETM 540 – Operations Research in

Engineering and Technology Management

Fall 2013

Portland State University

Dr. Tim Anderson

Team: Logistics

Noppadon Vannaprapa

Philip Bottjen

Rodney Danskin

Srujana Penmetsa

Joseph Lethlean

Optimization Modeling for Inventory Logistics

Contents

Abstract ......................................................................................................................................................... 2 Literature review........................................................................................................................................... 2 Review of Optimization Modeling ............................................................................................................ 3 Logistics Characterization ......................................................................................................................... 4 Methodology............................................................................................................................................. 6 Problem Background..................................................................................................................................... 6 Industry Players......................................................................................................................................... 6 Current Business Process .......................................................................................................................... 8 Problem Statement ................................................................................................................................... 9 The Goal of the Project ................................................................................................................................. 9 Scope ........................................................................................................................................................... 10 Optimization Model .................................................................................................................................... 10 Assumptions and Limitations .................................................................................................................. 12 Formulation................................................................................................................................................. 12 Variables ................................................................................................................................................. 12 Economic Order Quantity (EOQ) Optimization ....................................................................................... 13 Objective ............................................................................................................................................. 13 Constraints .......................................................................................................................................... 14 Inventory Optimization ........................................................................................................................... 14 Objective ............................................................................................................................................. 14 Constraints .......................................................................................................................................... 14 Analysis ....................................................................................................................................................... 15 Applications................................................................................................................................................. 19 Conclusion...

References: Vehicle Manufacturers, 2013. [Online]. Available: http://www.oica.net/category/productionstatistics/2012-statistics/. [Accessed: 09-Nov-2013].

publications, 1998.

334–346, 2007.

4, pp. 366–422, 1960.

[10]

“In Memoriam: Leonid Khachiyan,” Rutgers, The State University of New Jersey, 2003

pp. 217 –240, 2011.

1, pp. 21 – 37, 2006.

Publishers, 2001.

Page Limited, 2010.

[16]

“Opportunities in Thailand’s Automotive Industry,” Thailand Board of Investment, 2013

Please join StudyMode to read the full document