-Refer to the Shipping Costs for the Terra Cotta Company

question 48

Multiple Choice

-Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=) sign in the Excel Solver dialogue.) At the optimum solution,which of the following statements is true?

• A)The shipping costs from Danbury to Lakeland are $2,418.
• B)The shipping costs from Aberdeen to Lakeland are $1,795.
• C)The shipping costs from Brighton to Madison are $0.
• D)The shipping costs from Fairview to Madison are $18,414.

---

Definitions:

Early Colonists

The first European settlers in what is now the United States, arriving in the 16th and 17th centuries.

Hostile Wilderness

Areas of natural land that are difficult for humans to inhabit or navigate due to harsh conditions.

Finite Reservoir

A resource or space that has limited capacity and can be depleted if not managed sustainably.

Acid Rain

Precipitation that contains a higher concentration of acidic components such as sulfuric or nitric acids, resulting from emissions of sulfur dioxide and nitrogen oxide.