  |
 |
 |
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: |
| |
-Presentation
11
-Presentation
12
-Presentation
13
-Presentation
14
-Presentation
15
-Presentation
16
|
| |
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. |
| |
-Tutorial for
Interactive Order Simulator
-Interactive
Order Simulator (Excel File, see note below)
|
| |
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. |
| |
-Project
1 Description
-Graphical
Policy Display (Excel
File, see note below)
|
| 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.
Please also check our recommended System
Requirements for these files. |
| |
-When
using the Excel files, please right click on the link and select
the "Save
Target As" option and then download the file to your computer.
The spreadsheet cannot execute the Visual Basic Macros correctly
in a web browser. |
