Unformatted text preview: Space IOE 202: lecture 3 outline ï¿¿ ï¿¿ ï¿¿ ï¿¿ ï¿¿ ï¿¿ Announcements Last time... Optimization problems and optimization models Another example of a Linear Programming model: Monet picture frames Linear Programming (LP) optimization models â brief history Solving small LP models graphically and interpreting solutions IOE 202: Operations Modeling, Fall 2009 Page 1 Space Last time ï¿¿ ï¿¿ Extension of the EOQ model for inventory management: quantity discounts Pet food supplierâs inventory problem
ï¿¿ ï¿¿ Does not ï¬t EOQ framework; diï¬erent model needed Identiï¬ed
ï¿¿ ï¿¿ ï¿¿ ï¿¿ Decisions that need to be made Performance measure used to evaluate solutions Restrictions/constraints on decisions Simplifying assumptions made in the modeling process ï¿¿ Started formulating a model of the problem IOE 202: Operations Modeling, Fall 2009 Page 2 Space Another inventory management problem1
â¢ You are the Michigan distributor of Natureâs Peak, a high-end brand of frozen dog food. You have (pre-paid) contracts with local âboutiqueâ pet stores to deliver, in each of the next 4 months, respectively, 50, 65, 100, and 70 lb of food, and these orders must be ï¬lled on time. â¢ You obtain the food from the manufacturer at wholesale prices which vary month to month. In the next four months, unit prices are $5, $8, $4, and $7 per pound, respectively, and you can buy at most 80 lb each month. â¢ Food needs to be delivered to the stores at the end of each month. You place your order with the manufacturer in the beginning of each month, receive your order at the end of the month, and immediately deliver food to the local stores. â¢ If you have food remaining after the demand has been satisï¬ed, you can keep some of in your wearhouse at a cost of $2 per pound per month until the next delivery, and donate the rest to the Humane Society. â¢ In 4 months, Natureâs Peak is planning to change the recipe and packaging for this food. If you have any food left at that time, you can sell it to discount pet stores in the area for $6 per pound. (Until then, the company wants to maintain the productâs high-end image.) â¢ How should you manage your inventory for the next 4 months?
1 Section 4.12 of Denardo describes a problem in which such inventory management issues are part of the decisions
IOE 202: Operations Modeling, Fall 2009 Page 3 Space Operational decisions in the pet food distributorâs problem ï¿¿ What decisions do you need to make for the coming 4 months?
ï¿¿ ï¿¿ ï¿¿ ï¿¿ How many pounds of food to order in each of the next 4 months How many pounds of food to store in each of the next 3 months, and how much to sell after 4th month How many pounds of food to donate in each of the next 4 months What performance measure would you use to compare diï¬erent decisions?
ï¿¿ ï¿¿ Net cost (Ordering and holding costs, minus the revenue from resale at the end) â to be minimized Ordering capacity of 80 lb each month Demand must be met each month We assumed all parameters given are known with certainty We assumed that there are no setup ordering costs, and no cost or ï¬nancial beneï¬t associated with donations
Page 4 What constraints (restrictions) must your decisions satisfy?
ï¿¿ ï¿¿ ï¿¿ What assumptions are being made?
ï¿¿ ï¿¿ IOE 202: Operations Modeling, Fall 2009 Space Formulation of a mathematical model for the pet food distributorâs problem Decision variables: represent decisions by variables. ï¿¿ x1 , x2 , x3 , x4 : lbs of food ordered in each of the 4 months ï¿¿ s1 , s2 , s3 , s4 : lbs of food stored/sold at the end of each of the 4 months ï¿¿ y1 , y2 , y3 , y4 : lbs of food donated in each of the 4 months Constraints: express all (explicit and implicit) constraints and restrictions on the values of the decision variables. IOE 202: Operations Modeling, Fall 2009 Page 5 Space Formulation of a model for the pet food distributorâs â cont. Objective function: express the performance criterion in terms of the decision variables; should it be minimized of maximized?
ï¿¿ Minimize 5x1 + 8x2 + 4x3 + 7x4 + 2(s1 + s2 + s3 ) â 6s4 IOE 202: Operations Modeling, Fall 2009 Page 6 Space Mathematical model for pet food distributorâs problem Decision variables: ï¿¿ x1 , x2 , x3 , x4 : lbs of food ordered in each of the 4 months ï¿¿ s1 , s2 , s3 , s4 : lbs of food stored/sold at the end of each of the 4 months ï¿¿ y1 , y2 , y3 , y4 : lbs of food donated in each of the 4 months Mathematical model: minimize 5x1 + 8x2 + 4x3 + 7x4 +2(s1 + s2 + s3 ) â 6s4 (Net) cost objective subject to x1 = 50 + s1 + y1 Inventory balance in month 1 constraint x2 + s1 = 65 + s2 + y2 Inventory balance in month 2 constraint x3 + s2 = 100 + s3 + y3 Inventory balance in month 3 constraint x4 + s3 = 70 + s4 + y4 Inventory balance in month 4 constraint x1 , x2 , x3 , x4 â¤ 80 Ordering capacity constraint(s) x1 , x2 , x 3 , x4 , Nonnegativity constraint(s) s1 , s2 , s3 , s4 , y1 , y2 , y 3 , y4 â¥ 0
IOE 202: Operations Modeling, Fall 2009 Page 7 Space Diï¬erent, but equivalent, mathematical model for pet food problem Decision variables: ï¿¿ x1 , x2 , x3 , x4 : lbs of food ordered in each of the 4 months ï¿¿ s1 , s2 , s3 , s4 : lbs of food stored/sold at the end of each of the 4 months Mathematical model: minimize 5x1 + 8x2 + 4x3 + 7x4 +2(s1 + s2 + s3 ) â 6s4 (Net) cost objective subject to x1 â¥ 50 + s1 Inventory balance in month 1 constraint x2 + s1 â¥ 65 + s2 Inventory balance in month 2 constraint x3 + s2 â¥ 100 + s3 Inventory balance in month 3 constraint x4 + s3 â¥ 70 + s4 Inventory balance in month 4 constraint x1 , x2 , x3 , x4 â¤ 80 Ordering capacity constraint(s) x1 , x2 , x3 , x4 â¤ 80 Ordering capacity constraint(s) x1 , x2 , x3 , x4 â¤ 80 Ordering capacity constraint(s) x1 , x2 , x 3 , x4 , Nonnegativity constraint(s) s1 , s2 , s3 , s4 â¥ 0
IOE 202: Operations Modeling, Fall 2009 Page 8 Space Using a spreadsheet and Excel solver
We will use a spreadsheet to obtain the solution of this model. Components of such a spreadsheet:
ï¿¿ ï¿¿ Inputs The data needed to form the objective and constraints Changing cells Use designated cells whose values will play the role of the decision variables. In particular, the component of Excel that ï¬nds the optimal (best) values of variables will change the contents of these cells. Target (objective) cell This cell will contain the formula for computing the value of objective function, referencing the changing cells. Constraints Will be speciï¬ed in the Solver dialog box. Cells with expressions for left and right hand sides need to be prepared in the spreadsheet referencing the changing cells. Nonnegativity constraints Can be speciï¬ed by checking a box in the Solver dialog (Also, check âAssume Linear Modelâ) ï¿¿ ï¿¿ ï¿¿ Suggestion: use references to input cells, rather than numbers, as much as possible in all formulas.
IOE 202: Operations Modeling, Fall 2009 Page 9 Space Optimal solution of pet food distributorâs problem ï¿¿ Optimal solution: ï¿¿ Optimal (net) cost: IOE 202: Operations Modeling, Fall 2009 Page 10 Space Optimization problems
ï¿¿ Optimization problems: problems involving deciding which actions to select among all feasible ones to achieve the best (or optimal) performance, as measured by a speciï¬ed performance criterion.
ï¿¿ ï¿¿ ï¿¿ ï¿¿ ï¿¿ ï¿¿ Pet food distributorâs problem Deciding on the size of a production batch in TV speakers problem Choose the least-cost daily diet among all those that satisfy dietary (and taste!) requirements. Choose the shortest-distance route from home to school. In a production facility, choose the most proï¬table combination of products to manufacture from the available raw materials. Others? ï¿¿ Optimization models: prescriptive mathematical models of optimization problems IOE 202: Operations Modeling, Fall 2009 Page 11 Space Terminology of optimization models â I ï¿¿ Decision variables: the quantities that can vary; we often call them simply variables
ï¿¿ Represent quantitive decisions that need to be made ï¿¿ Objective function: the expression that is being minimized of maximized
ï¿¿ Represents the performance measure ï¿¿ Constraints: equations and inequalities that the decision variables must satisfy
ï¿¿ Represent restrictions on decisions being made IOE 202: Operations Modeling, Fall 2009 Page 12 Space Linear functions and constraints
ï¿¿ Examples of linear functions: 17xA â 57xB + 91xC or A â 3.4B + 2C . The variables of the ï¬rst expression are xA , xB , xC , and of the second â A, B , C . Both functions depend on their respective variables linearly. A linear constraint requires a linear function to be equal, greater-than-or-equal-to, or less-than-or-equal-to, a number: 2A â 3B = 6 and A â 3.4B + 2C â¤ â2 and C â¥ 0. (We do not consider the inequality 17xA â 57xB + 91xC > 12 ï¿¿ ï¿¿ to be a correct form of a constraint!) A linear programming model is an optimization model with a linear objective function and linear constraints
Page 13 IOE 202: Operations Modeling, Fall 2009 Space Terminology of optimization models â II ï¿¿ ï¿¿ Solution: an assignment of values to the decision variables Feasible solution: an assignment of values to the variables that satisï¬es all of the constraints
ï¿¿ ï¿¿ x1 = x2 = x3 = x4 = 80, s1 = s2 = s3 = s4 = 0 is a solution, but it is not feasible x1 = x2 = x3 = x4 = 80, s1 = 30, s2 = 45, s3 = 25, s4 = 35 is a feasible solution; objective value $1,910.00 ï¿¿ Optimal solution: feasible solution with the best objective value among all feasible solutions IOE 202: Operations Modeling, Fall 2009 Page 14 Space Example: problem of optimal resource allocation2 â¢ The Monet company produces four types of picture frames, labeled A, B, C, and D. The table below lists the unit selling price Monet charges for each type of frame. â¢ Each type requires a certain amount of skilled labor, metal, and glass, as shown in the table. For production during the coming week, Monet can purchase up to 4000 hours of skilled labor, 6000 ounces of metal, and 10,000 ounces of glass. The unit costs are also indicated in the table. â¢ Also, market constraints are such that it is impossible to sell more than 1000 type-A frames, 2000 type-B frames, 500 type-C frames, and 1000 type-D frames. â¢ How many frames of each type should Monet produce during the coming week to maximize its proï¬t?
2 Another problem of this type: Recreational Vehicle problem on p. 19 of Denardo.
IOE 202: Operations Modeling, Fall 2009 Page 15 Space Data (inputs) for the Monet production problem Frame type Frame A Frame B Frame C Frame D Max. amount of resource Resource Unit prices Skilled labor 2 1 3 2 4000 hours $8.00 per hour Metal 4 2 1 2 6000 oz $0.50 per 1 oz Glass 6 2 1 2 10,000 oz $0.75 per 1 oz Selling price $28.50 $12.50 $29.25 $21.50 Maximal production 1000 2000 500 1000 IOE 202: Operations Modeling, Fall 2009 Page 16 Space Operational decisions at Monet
ï¿¿ What decisions do managers at Monet need to make for the coming week? ï¿¿ What performance measure is the company using to compare diï¬erent decisions? ï¿¿ What constraints (restrictions) must their decisions satisfy? IOE 202: Operations Modeling, Fall 2009 Page 17 Space Formulation of a mathematical model for Monet Decision variables: represent decisions by variables. Objective function: express the performance criterion in terms of the decision variables; should it be minimized of maximized. IOE 202: Operations Modeling, Fall 2009 Page 18 Space Formulation of a model for Monet â cont. Constraints: express all (explicit and implicit) constraints and restrictions on the values of the decision variables. IOE 202: Operations Modeling, Fall 2009 Page 19 Space Mathematical model for Monet: Decision variables: xA , xB , xC , xD denote the number of frames A, B, C, and D to produce, respectively. Mathematical model: maximize 6xA + 2xB + 4xC + 3xD subject to 2xA + xB + 3xC + 2xD â¤ 4000 4xA + 2xB + xC + 2xD â¤ 6000 6xA + 2xB + xC + 2xD â¤ 10000 xA â¤ 1000 xB â¤ 2000 xC â¤ 500 xD â¤ 1000 xA , x B , xC , x D â¥ 0 Proï¬t objective Labor constraint Metal constraint Glass constraint Frame A sales constraint Frame B sales constraint Frame C sales constraint Frame D sales constraint Nonnegativity constraint This model is also a linear programming model, since all constraints are linear, and the objective function is a linear function.
IOE 202: Operations Modeling, Fall 2009 Page 20 Space Some comments ï¿¿ An alternative (but equivalent) formulation can be constructed by including variables to represent the amount of labor, metal, and glass purchased. Objective function and constraints could be expressed in terms of this variables. Both integer and non-integer levels of production were allowed in our formulation. (Is it a reasonable assumption?) Next week, we will discuss the changes in the models/solution methods when the last assumption is not reasonable; for now, let us allow variables to be non-integer. ï¿¿ ï¿¿ IOE 202: Operations Modeling, Fall 2009 Page 21 Space Linear Programming (LP) history
Linear Programming (LP) models constitute a special class of optimization models. Some history: â¢ Theoretical tools for solving systems of linear equations and inequalities, too calculation-intense â¢ 1930âs - early 1940âs â ï¬rst applications of LP models to speciï¬c problems in production planning (L. Kantorovich, Soviet Union) and transportation planning (T. Koopmans, Netherlands/USA) (âprogrammingâ means âplanningâ) â¢ Mid-1940âs â development of an algorithm (the Simplex Method) capable of ï¬nding an optimal solution of any LP model by G. Dantzig coincides with development of computers, enabling broad practical applications. â¢ Late-1940âs - today: LP models are increasingly used in many applications; simultaneously, new algorithms for solving LPs, and software implementing these algorithms, are developed, as larger models need to be solved.
IOE 202: Operations Modeling, Fall 2009 Page 22 Space LP today Used in all types of organizations, with applications in: eï¬cient resource allocation, military operations planning, production and inventory planning, capacity expansion, manufacturing process design, staï¬ scheduling, location planning, traï¬c routing, supply chain management, economic game theory, airline crew and plane scheduling, telecommunication capacity allocation and network design, medical treatment planning, image reconstruction, publishing (typesetting), ï¬nance (asset allocation), mathematics (as a proof technique and computational method), data analysis, pattern classiï¬cation, optimal control, mechanical structure design, electromagnetic antennae design, etc. IOE 202: Operations Modeling, Fall 2009 Page 23 Space Optimal solution of the Monet problem ï¿¿ ï¿¿ ï¿¿ Optimal solution: Optimal proï¬t: Which inequality constraints are âtightâ (i.e., hold as equalities) at the optimal solution? An alternative way to characterize the optimal solution: âDo not make any frames of type D. Produce as many frames of type A as you can sell. Use up all available labor and metal.â IOE 202: Operations Modeling, Fall 2009 Page 24 ...
View Full Document
This note was uploaded on 03/17/2010 for the course IOE 202 taught by Professor Marinaepelman during the Fall '09 term at University of Michigan-Dearborn.
- Fall '09