ORIE 3120: Industrial Data and Systems Analysis
Spring 2014
Solution for Homework #1
1. Functional Modeling and IDEF0 (25 points)
SOLUTION ATTACHED AT THE END
2. Relational Database Schema (10 points)
SOLUTION ATTACHED AT THE END
3. Structured Query Langu

ORIE 3120: Industrial Data and Systems Analysis
Spring 2012
Homework #5 and #6
Due Date: 3/9/12 (Friday) noon
Rhodes Hall Course Dropbox
1. Discrete Event Simulation Programming (20 points)
Lets modify the simplified cookie model (one cookie type) to clea

ORIE 3120: Industrial Data and Systems Analysis
Spring 2014
Solution to Homework #4
1. Pareto Analysis with SQL (15 points)
Here is Q01. For each Workcenter_id, and each product produced in that workcenter, it has a
column called GreaterProduct for every

SimTemplate: Basic simulation services in a spreadsheet by Peter L. Jackson.
Copyright: Peter L. Jackson 2003
You are free to use or modify this software for any purpose provided this copyright notice is
included in all derivative versions.
Documentation

ORIE 3120
Industrial Data and Systems Analysis
Testimonials
January 23, 2012
If students use any of the techniques or ideas from ORIE 3120 as part of their summer
jobs (or future careers), I ask them to drop me a note describing what they did and give
me

# This is the first query for problem 2, saved as a view called Q01
SELECT t1.ProductID as ProductID, t1.ProductionHours as ProductionHours,
t2.ProductID as GreaterProductID, t2.ProductionHours as GreaterProductionHours
FROM WorkCenterHoursByProduct AS t

Part 1: Linear Regression - Introduction
Regression Analysis
Regression analysis can do lots of things:
investigate how variables are related.
predict future values of variables.
show how output variables will change if we change input
March 27, 2014
v

Forecasting, Planning, and
Scheduling
Material Requirements
Planning
Peter Frazier
School of O.R. and I.E.
Cornell University
Industrial Data and Systems Analysis
Industrial Data and Systems Analysis
Read this section of your
reading packet
2
Objectives o

ORIE 3120 Final Exam
Spring 2012
Professors Peter Jackson and Peter Frazier
This exam is closed book. Time yourself carefully. Do the problems rst that you
nd easiest. You do not need to complete all numerical calculations. For example, an
answer in the f

ORIE 3120 Final Exam
Spring 2013
Professors Peter Jackson and Peter Frazier
This exam is closed book. Time yourself carefully. Do the problems rst that you
nd easiest. You do not need to complete all numerical calculations. For example, an
answer in the f

ORIE 312 Final Exam
Spring 2011
Professors Peter Jackson and Peter Frazier
This exam is closed book. Time yourself carefully. Do the problems rst that you
nd easiest. You do not need to complete all numerical calculations. For example, an
answer in the fo

Homework 9: Logistic Regression solutions
OR&IE 3120, Spring 2014
Problem 1 As can be seen in the boxplots below, the variables RiserDiam, SprueDiamBot
and SprueDiamTop are most related to Feasible. RiserDiam is higher when Feasible is 1
and lower when Fe

Recitation #12 and Homework #11: Forecasting Solutions
OR&IE 3120, Spring 2013
Problem 1
The plot show that there were unusually low sales in at least one April.
2e+05
2000
2001
2002
2003
0e+00
1e+05
Sales_93
3e+05
o
o
o
o
2
4
6
8
10
12
month
150000
2000

Here are some example
geographical questions
Planning for the Hydrogen Economy
How many hydrogen fuel stations need to be
built so that 70% of the U.S. population lives
within 2 miles of one?
Geographical Information
Systems
(Notice the application of

Factors
Design of Experiments, Factor Models, and
Quality Improvement
A factor is a categorical predictor
the values of the factor are called levels
the factor machine might have three levels, machine 1,
machine 2, machine 3
the variable temperature mi

SimTemplate: Basic simulation services in a spreadsheet by Peter L. Jackson.
Copyright: Peter L. Jackson 2003
You are free to use or modify this software for any purpose provided this copyright notice is
included in all derivative versions.
Documentation

ORIE 3120: Industrial Data and Systems Analysis
Spring 2014
Homework #6
Due Date: 3/19/14 (Wednesday) 2:30 p.m.
Rhodes Hall Course Dropbox
Discrete Event Simulation Programming (30 points)
Lets modify the simplified cookie model (one cookie type) to clean

Two Useful Modeling Approaches
Functional Modeling
Behavioral Modeling
Initialize
Discrete Event Simulation
Arrival
InterarrivalTime
OvenIsEmpty
Start
Peter Frazier
Assistant Professor
School of O.R.I.E.
2/26/14
Industrial Data and Systems Analysis
Cook

Introduction to Industrial Data
and Systems Analysis
Peter Frazier
Assistant Professor
School of O.R. and I.E.
1/23/14
Industrial Data and Systems Analysis
1
Overview
Operational Improvement Cycle
Overview of Topics in ORIE3120
Structured Query Languag

Goal
Learn a nice technique for production planning
See it four ways:
Aggregate Production
Planning
Interact with SQL query results using procedural
code
Peter Frazier
Assistant Professor
School of O.R. and I.E.
3/11/14
Industrial Data and Systems Anal

Visual Representation in MS Excel
Each column represents 5 minutes of run duration
Cyclic Scheduling
Peter Frazier
School of Operations Research and
Information Engineering
Cornell University
3/19/14
Industrial Data and Systems Analysis
Color shades indic

Forecasting time series
A time series, x1 , x2 , x3 , . . . is a data sequence observed over time,
for example,
FORECASTING
demand for parts
sales of a product
unemployment rate
March 27, 2014
In this segment of the course we study special methods for

ORIE 3120 Final Exam
Spring 2012
Professors Peter Jackson and Peter Frazier
This exam is closed book. Time yourself carefully. Do the problems rst that you
nd easiest. You do not need to complete all numerical calculations. For example, an
answer in the f

Assignment #13 Quality Improvement Solutions
OR&IE 3120, Spring 2013
Problem 1 The original data are plotted in the top row of the gure below. The alternated
data are in the bottom row. The left column has boxplots, the middle column has normal
plots, and