Ex. 5.7 (contd) – Developing the Solver Model The traditional model is developed with these steps. The traditional model is developed with these steps
{"Image DocumentName": "Ex. 5.7 (cont\u2019d) \u2013 Developing the Solver Model", "Image ImageDescription": "The traditional model is developed with these steps. Input data. Enter the given durations in row 6. The other shaded range an incidence matrix . This is a convenient way to encode precedence relationships in the AON network. Start times. Enter any starting times in row 4. Precedence relationships. The key to this formulation is the information in columns P and R. The left-hand side of the inequality is the difference between starting times of the from and to nodes. Enter the formula =SUMPRODUCT( D 4: O 4,D9:O9) in cell P9 and copy it to P23. The right-hand side of the inequality is the duration of the from nodes. A table lookup can be used. Enter 0\u2019s in R9 and R10 and the enter the formula =HLOOKUP(B11, E 3: N 6,4) in cell R11, and copy it down to cell R23. Project time. Enter the formula =O4 to get the project length.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}