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:

Consistency

An accounting principle that requires accounting methods and principles to be applied in the same manner from period to period unless a change is justified.

Income Tax Expense

The amount of money a company or individual owes to the government based on the taxable income earned during a fiscal year.

Interim Period

A temporary or Middle phase in a fiscal year or financial reporting period, often used for assessing a company's performance partway through the year.

Segment Profit or Loss

The financial performance of a distinct unit within a company, often evaluated to assess its contribution to the overall business.