Use This Information to Answer the Following Questions

question 4

Essay

Use this information to answer the following questions.
Bob Jenkins needs to drive from City 1 to City 7 and would like to find the shortest route between the two.The road system with the distance in miles between cities is shown in the network below.What cities should he travel through to minimize his distance?

Refer to the following Excel spreadsheet model.

-Refer to the network above and its associated spreadsheet.What values would you enter in the Solver Parameter dialog box for the Excel spreadsheet model?
Set Target Cell:
By Changing Cells:
Subject to the Constraints:

---

Definitions:

Bonds at Par

A situation where bonds are issued or traded at their face value or principal amount.

Bond Interest

The periodic payment made to the holders of a bond, representing a fixed income for the bond's duration.

Bonds at Discount

Bonds issued for less than their face value, where the difference between the purchase price and the face value is the interest earned by the investor.

Journal Entries

These are records of financial transactions within a company's accounting system, ensuring all financial transactions are properly documented.