6203 Exam 1 Review John H Vande Vate

6203 Exam #1 Review John H. Vande Vate Spring, 2001 1 1

Max the Min set Towns; /* The townships */ param X{Towns}; /* The X coordinate of each town’s location */ param Y{Towns}; /* The Y coordinate of each town’s location */ param Max. X; param Min. X; param Max. Y; param Min. Y; var Xloc >= Min. X, <= Max. X; /* X coordinate of landfill */ var Yloc >= Min. Y, <= Max. Y; /* Y coordinate of landfill */ var Xdist{Towns} >= 0; /* East-West distance to each town */ var Ydist{Towns} >= 0; /* North-South distance to each town */ var Is. East{Towns} binary; /* Whether landfill is east or not */ var Is. North{Towns} binary; /* Whether landfill is north or not */ var Min. Dist >= 0; /* Distance to closest town */ 2 2

Constraints Max Minimum. Distance: Min. Dist; s. t. Define. Min{t in Towns}: Min. Dist <= Xdist[t] + Ydist[t]; s. t. Define. XDist. East{t in Towns}: Xdist[t] <= Xloc - X[t] +(1 -Is. East[t])*(Max. X-Min. X+X[t]) s. t. Define. XDist. West{t in Towns}: Xdist[t] <= X[t] - Xloc +Is. East[t]*(2*Max. X-X[t]) s. t. Define. YDist. North{t in Towns}: Ydist[t] <= Yloc - Y[t] +(1 -Is. North[t])*(Max. YMin. Y+Y[t]) s. t. Define. YDist. South{t in Towns}: Ydist[t] <= Y[t] - Yloc +Is. North[t]*(2*Max. Y-Y[t]) 3 3

Explanation • Is. East[t] = 1 if Landfill is East of Town Xloc >= X[t] • Is. North[t] = 1 if Landfill is North of Town Yloc >= Y[t] 4 4

So…. • We might add the constraints. . . s. t. Define. East{t in Towns}: (Max. X - X[t])*Is. East[t] >= Xloc - X[t] s. t. Define. North{t in Towns}: (Max. Y - Y[t])*Is. North[t] >= Yloc - Y[t] 5 5

Common Mistakes var Is. East binary; s. t. Define. XDist. West{t in Towns}: Xdist[t] <= X[t] - Xloc +Is. East*(2*Max. X-X[t]) What’s wrong? 6 6

Common Mistakes var Xdist >= 0; var Ydist >= 0; max Minimum. Distance: Xdist + Ydist; s. t. Define. XDist. West{t in Towns}: Xdist <= X[t] - Xloc +Is. East[t]*(2*Max. X-X[t]); … s. t. Define. YDist. South{t in Towns}: Ydist <= Y[t] - Yloc +Is. North[t]*(2*Max. Y-Y[t]); What’s wrong? 7 7

Discussion • • • Put aside personal “investment” in answers Clarify issues Do not argue, discuss Be brief. Think, then talk. Imagine this is a business meeting 8 8

BMW ships Z 3’s from Greer, S. C. to meet EMEA demand. BMW delivers the vehicles by truck to the port of Savannah. Each Friday the vehicles are loaded on a vessel The vessel takes all the cars available at the time of departure. Demand is relatively constant at 500/week and 25, 000/year. Each Z 3 represents $35, 000 in revenue when it is sold. BMW uses an inventory carrying charge of 15% per year. Can deliver vehicles up to 12 at a fixed cost of $1, 200 per trip How many vehicles should BMW ship to Savannah on each car hauler to balance the costs of 9 9 transportation and inventory?

Follow-up How would your answer change (specifically) if BMW were to sell the vehicles to a trading company and realize revenue of $30, 000 per car when the cars arrive in Savannah? How many vehicles should BMW ship to Savannah on each car hauler to balance the costs of transportation and inventory? 10 10

EOQ • Annual Transportation Cost ($/year) – $/trip*(vehicles/year)/(vehicles/trip) – 1200*25000/Q • Annual Inventory Cost ($/year) – (%/year)*($/vehicle)*(Avg. vehicles in Inv. ) • Avg. vehicles in Inv. – At Greer: – In Savannah: – In Pipeline: 11 11

Formula for EOQ • 1200*25000/Q + 0. 15*30000*Q/2 • Q* = 2*1200*25000/4, 500 = 2*12*25000/45 = 2*12*5000/9 = 4*3*10000/9 = 200 3/3 Common Misunderstanding: 115 = 9*12 + 7!!! = 200/ 3 Real Meaning: 115 Send 12 12 12

Other Common Mistakes • 1200*500/Q + 0. 15*30000*Q/2 $/Week $/Year 13 13

Fancy Stuff from Project 1 • E. g. P/(P+D) • Is this relevant here? • We are not trying to assess total inventory at the plant. . . 14 14

Mōtiva Petroleum products refiner and marketer. l l Convent Refinery outside Baton Rouge, LA Colonial Pipeline Distribution Center Deliver the products to customers Mansfield and Eagle both charge for full truck load delivery to commercial accounts – – Minimize the maximum distance Minimize the sum of the distances Minimize the total gallon-miles (distance*volume) 15 Maximize the minimum distance 15

Mōtiva Suppose Mōtiva purchased a gas station from a Retail operator. You would expect the average inventory levels at the gas station to go Up? Down? Stay the same? 16 16

Mōtiva The product has an average value of $30/bbl The facility distributes 12, 000 barrels per day Cost of capital of approximately 15%/year What’s the total value of a policy that changed the way product is delivered via the pipeline to reduce the inventory levels at the distribution center to 2 days supply. The proposed policy has no effect on refining operations or on the cost of conveyance through the pipeline. It will simply change the frequency and size of 17 17 extractions from the pipeline.

What’s it Worth? • $180, 000 =. 5 days * 12, 000 bbls/day * $30/bbl • $27, 000 =. 15 * 180, 000 • $81, 000 = 3 years *. 15 * 180, 000/year • $0 18 18

19 19

Re-Grading • Ambiguous issues • Lots of thought and effort • Happy to Re-grade but ONLY if you submit a WRITTEN request – Turn in your exam with a neatly prepared document that • identifies point you feel I graded incorrectly • outlines your thinking on the issue • indicates the grade you believe you should have received on the item • Only one chance. My decision final. • Any oral argument and you lose that chance. 20 20

Opportunity • Global Network Design for a major US Retailer based in Mid-West • 4, 800 stores in US, Canada, Guam, PR, Costa Rica, … • Moving into Latin America • Manufacturing in China, Indonesia, Mexico, Florida, Brazil… 21 21

Questions • • • Where to source products? Which ports to use? Where to locate DC’s? Where to locate “pools” (cross docks)? Objective: Achieve stated service levels at minimum cost 22 22

Project Plan • Clarify data requirements and develop prototype models by early April • Full-scale model running by early May • Report to Executive Committee early June • On-going support through September 23 23

Opportunity • • • 2 Students Complete project as scheduled GRA for Summer (Academic credit as well) Great experience Qualifications: – ISy. E MS Students – Computer Savvy – Good English – Willing to meet deadlines – >= 80 on Mid-Term 24 24

E-mail me your Resume • • No Viruses! Relevant Experience GPA, etc. Career Goals 25 25

Project #2 Comments • • Real Estate will decide final locations Don’t need a single monolithic model AMPL has looping commands Xpress and MPL can be called from VB or Excel, or Access… • Due Date: – March 27 th – April 10 for Video students 26 26