Due 30/3/99 This assignment contributes 10% of the mark for Special Topic 3.
Equal marks for each of the following questions. The solutions should demonstrate core network models and use excel solver software.
- The manager of a courier service is advertising speedy delivery. To reduce delivery time he asks you to construct a table of shortest times between the courier office (node 1) and each of six frequent customers. You have measured the following times (in minutes): c12 = 5, c13 = 1, c24 = 7, c25 = 1, c26 = 6, c32 = 2, c34 = 6, c35 = 7, c43 = 7, c46 = 4, c47 = 6, c54 = 3, c56 = 5, c57 = 9, c67 = 2.
- Warehouses A,B,C,D can supply respectively 8, 14, 18 and 4 units of a product. Customers a,b,c,d,e have ordered respectively16, 6, 14, 4, 4 of these units. No more than 10 units can be transported on any route. The unit delivery costs are given in the following table: