A Company Wants to Locate a New Warehouse to Minimize

question 3

Multiple Choice

A company wants to locate a new warehouse to minimize the distance traveled by its delivery trucks. It has four stores and their coordinates are listed in the accompanying spreadsheet. What formula goes in cell D4 of the spreadsheet?

• A) =(B4-$B$3)^2+(C4-$C$3)^2
• B) =SQRT((B4-$B$3)+(C4-$C$3))
• C) =SQRT((B4-$B$3)^2+(C4-$C$3)^2)
• D) =(B4-$B$3)+(C4-$C$3)

---

Definitions:

Compounded Semi-annually

Calculating and adding interest to the principal twice a year, affecting the overall interest accrued over time.

Compounded Quarterly

The process of calculating interest on both the initial principal and the accumulated interest from previous periods, done four times a year.

Maturity

The date on which the principal amount of a financial instrument is due to be paid back in full.

Non-interest-bearing

Referring to financial instruments or accounts that do not earn interest over time.