Use the Case Below to Answer the Following Question(s)

question 69

Multiple Choice

Use the case below to answer the following question(s) .
Stoudemire Inc.produces televisions at two plants: Arizona and Arkansas.They ship them to major distribution centers in San Antonio,Washington,Miami,and Dallas.The table shown below provides the unit cost of shipping between any plant and distribution center,plant capacities over the next planning period,and distribution center demands.Stoudemire's supply chain manager faces the problem of determining how much to ship between each plant and distribution center to minimize the total transportation cost,not exceed available capacity,and meet customer demand. Assume X_ij = amount shipped from plant i to distribution center j,where i = 1 represents Arizona,i = 2 represents Arkansas,j = 1 represents San Antonio,j = 2 represents Washington,and so on.
-Determine the equality/inequality that explains the demand constraint for the distribution center in Washington.

• A)X₂₁ + X₂₂ ≥ 300
• B)X₁₁ + X₂₂ ≤ 300
• C)X₁₂ + X₂₂ = 300
• D)X₁₁ + X₁₂ = 300

---

Definitions:

AVERAGEIF

An Excel function that calculates the average of all numbers in a range that meet specified criteria.

Financial Functions

Specific mathematical formulas used in spreadsheets or financial software to perform calculations related to finance, such as interest rates, payments, and investment returns.

FV

Future Value, a finance function that calculates the future value of an investment based on a constant interest rate and fixed payments over time.

PMT

A financial function that calculates the payment for a loan based on constant payments and a constant interest rate.