HW_03SQLandDecouplingStock 2012

HW_03SQLandDecouplingStock 2012 - ORIE 3120 Industrial Data...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 ORIE 3120: Industrial Data and Systems Analysis Spring 2012 Homework #3 Due Date: 2/15/12 (Wednesday) noon. Rhodes Hall Course Dropbox 1. The Distribution Game (5 points) Complete the recitation assignment and print out the resulting spreadsheet. Include a written explanation of which configuration you found was better and why you think it has an advantage. Use the concepts of pipeline stock, cycle stock, and safety stock as part of your explanation. 2. Structured Query Language: Cross Products and Aggregations (10 points) The data for this problem are in the database called ParetoHomework.mdb . Suppose we are given a table of production hours within a workcenter by product id’s as follows: Observe that there is a wide variation in the number of production hours by product. I would like to graph this by ranking the products according to production hours (largest-producing product first) and then plotting the cumulative production hours by production rank. It will look like this:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 1234567891 0 1 1 1 2 1 3 1 4 1 5 CumulativeProductionHoursinWorkcenter Products in Production Rank Order ParetoAnalysis of Production Hours In Workcenter This sort of cumulative plot is called a “Pareto Analysis.” It helps to dramatize the
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

HW_03SQLandDecouplingStock 2012 - ORIE 3120 Industrial Data...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online