Supply Chain Flow Simulator
Created by: Michael Pew and Dr. Daniel Rivera
Design Project No. 1 for the Spring 2003 ECE 100: Introduction to Engineering class featured a comprehensive analysis of engineering-based decision policies for managing inventory in a single node of a supply chain. A series of flow dynamics simulations in Excel were developed during the spring 2003 to help students gain intuition and have a better understanding of the phenomena they were investigating. The simulations created for the project as well as supporting information are described below.
1. Some ECE 100 course presentations describing the project:
2. Interactive Order Simulator: This simulation enabled students to manually make decisions on orders to satisfy demand. A series of scenarios are presented to the student involving both deterministic and stochastic demand changes of varying magnitudes, with and without forecast information.
3. Graphical Policy Simulator: This simulation allows students to graphically visualize animations of the Economic Order Quantity (EOQ) and the Proportional-Integral-Derivative (PID) policies developed in Modeling Assignments 2 and 3. As part of Design Project 1, students used the simulator to evaluate policies presented by two hypothetical vendors (ACME and IMC, Inc.) for a mythical computer company named Sparky Computer.
The links in this page include relevant information and files related to the use of the flow simulators in ECE 100. These files are intended for academic use only. The download and use of these files is subject to the terms of our disclaimer.