伯纳德·W·泰勒-数据、模型与决策（英文版·第10版）taylor_introms10_ppt_10.pptVIP

* * * * * * * * * * * * * * * * * * * * * * * * * * * Exhibit 10.7 Beaver Creek Pottery Company Problem Solution Using Excel (5 of 6) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Exhibit 10.8 Beaver Creek Pottery Company Problem Solution Using Excel (6 of 6) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Maximize Z = (p1 - 12)x1 + (p2 - 9)x2 subject to: 2x1 + 2.7x2 ? 6,000 3.6x1 + 2.9x2 ? 8,500 7.2x1 + 8.5x2 ? 15,000 where: x1 = 1,500 - 24.6p1 x2 = 2,700 - 63.8p2 p1 = price of designer jeans p2 = price of straight jeans Western Clothing Company Problem Solution Using Excel (1 of 4) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Exhibit 10.9 Western Clothing Company Problem Solution Using Excel (2 of 4) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Exhibit 10.10 Western Clothing Company Problem Solution Using Excel (3 of 4) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Exhibit 10.11 Western Clothing Company Problem Solution Using Excel (4 of 4) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Centrally locate a facility that serves several customers or other facilities in order to minimize distance or miles traveled (d) between facility and customers. di = sqrt[(xi - x)2 + (yi - y)2] Where: (x,y) = coordinates of proposed facility (xi,yi) = coordinates of customer or location facility i Minimize total miles d = ? diti Where: di = distance to town i ti =annual trips to town i Facility Location Example Problem Problem Definition and Data (1 of 2) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Facility Location Example Problem Problem Definition and Data (2 of 2) Copyright ? 2010 Pearson Education, Inc. Publishing as Prentice Hall Exhibit 10.12 Facility Location Example Problem Solut