1ORIE 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 AnnualDollarSales1954695175182731904687283423136534104179146540210576856182771741985782871886357894132934888936212640ProductID AnnualDoll SalesRank93621264011751827321954695385782871468561827554021057619046877365341082834231941791461093488811886357128941321371741914
has intentionally blurred sections.
Sign up to view the full version.