HW_03SQLandDecouplingStock

HW_03SQLandDecouplingStock - ORIE 3120: Industrial Data and...

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 2011 Homework #3 Due Date: 2/16/10 (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) Suppose we are given a table of sales by product id’s as follows: In a spreadsheet program it is a simple matter to sort the rows in decreasing order of sales, and assign a sales rank number as follows: Then, you can compute cumulative sales by sales rank as follows: ProductID AnnualDollarSales 195 4695 1751 8273 1904 687 2834 231 3653 410 4179 146 5402 1057 6856 1827 7174 19 8578 2871 8863 57 8941 32 9348 88 9362 12640 ProductID AnnualDoll SalesRank 9362 12640 1 1751 8273 2 195 4695 3 8578 2871 4 6856 1827 5 5402 1057 6 1904 687 7 3653 410 8 2834 231 9 4179 146 10 9348 88 11 8863 57 12 8941 32 13 7174 19 14
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 From here, you can easily plot cumulative sales against sales rank as follows: Observe that the five top selling products (ID #9362, #1751, #195, #8578, and #6856) account for sales of $30,306. That is (30306/33033=) 92% of all sales. That is a useful insight. Graphs such as this are useful in helping you, and your client, to appreciate that a few part numbers account for most of the sales. These are known as “Pareto curves”. Pareto charts are everywhere.
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.

This note was uploaded on 03/18/2012 for the course ORIE 3120 taught by Professor Jackson during the Spring '09 term at Cornell.

Page1 / 4

HW_03SQLandDecouplingStock - ORIE 3120: Industrial Data and...

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