运筹学英文上课录象.ppt

3.1 Prototype example The WKYNDOR GLASS CO. produces high-quality glass products, including windows and glass doors. It has three plants. Aluminum frames and hardware are made in Plant1, wood frames are made in Plant 2, and Plant 3 produces the glass and assembles the products. Because of declining earnings, top management has decided to revamp the company’s product line. Unprofitable products are being discontinued, releasing production capacity to launch two new products having large sales potential: Product1: an 8-foot glass door with aluminum framing Product2: A 4*6 foot double-hung wood-famed window Regional Planning We can now formulate the mathematical model for this general problem of allocating resources to activities.In particular,this model is to select the values for x1,x2, …,xn so as to 3.3 Solving Linear Programming by using EXCEL * 3 Introduction to Linear Programming 3.1 Prototype Example 3.2 The Linear Programming Model 3.3 Assumptions of Linear Programming 3.4 Additional Examples 3.5 Some Case Studies 3.6 Conclusions In this lesson: The teaching objects are : (1) Master the formulation of linear programming model (2) Understand the procedure of solving linear programming by using EXCEL SOLVER The teaching contents are : (1) Prototype Example (2) The basic steps of formulating a model of linear programming (3) Solving a linear programming by use EXCEL SOLVER The development of linear programming has been ranked among the most important scientific advances of the mid-20th century, and we must agree with this assessment. Its impact since just 1950 has been extraordinary. Today it is a standard tool that has saved many thousands or millions of dollars for most companies or businesses of even moderate size in the various industrialized countries of the world; and its use in other sectors of society has been spreading rapidly. Linear programming involves the general problem of alloca