Exercises

  • 1. Solve in Excel the directed graphs given in Figs. 1 and 2 , finding the shortest path from node   1 to node   9.
  • 2. You are given a route map as represented in Fig. 3 with costs from node to node of the route. Solve it in Excel for the minimum cost route to choose, to reach destination h from current location a. You can only travel one way as indicated by the arrows. Plot in a chart the optimal route.
  • 3. Reconsider the problem of Example 1 reformulated in a continuous framework as follows:
  • y ˙ ( t ) = u ( t )
    image
  •     so that the following performance measure is minimized:
  • Figure 1
  • Figure 2 ...

Get Elements of Numerical Mathematical Economics with Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.