Use This Information to Answer the Following Questions Shipping Cost/unit ($)

question 11

Essay

Use this information to answer the following questions.
A company can ship its product from any of its three factories,F1,F2,and F3,to any of its retail outlets,R1,R2,and R3.The capacity,demand,and shipping cost information is provided as follows:
$\begin{array}{ll}\text { Demand (units) } & \text { Capacity (units) } \\\hline \text { R1:300 } & \text { F1:250 } \\\text { R2: } 500 & F 2: 350 \\\text { R3:200 } & \text { F3:400 }\end{array}$



Shipping Cost/unit ($)
$\begin{array}{lll}&&\mathrm{R} 1 & \mathrm{R} 2 & \mathrm{R} 3\end{array}$
$\begin{array}{llll}\mathrm{F} 1 & 1 & 3 & 2 \\ \text { F2 } & 3 & 4 & 2 \\ \text { F3 } & 2 & 2 & 3\end{array}$


-Refer to the information above.The company wants to come up with an optimal shipping strategy to minimize its total shipping cost.Use Excel to formulate and solve this problem.

---

Definitions:

Same-sex Activities

Interactions or relationships of a romantic or sexual nature between individuals of the same sex.

Functionalist

Pertaining to the theory that all aspects of a society serve a function and are necessary for the survival of that society.

Heteronormativity

The belief system or social bias that presumes heterosexual relationships and norms as the default or only valid option.

Transsexuals

Transsexuals are individuals who have a gender identity that is different from the sex they were assigned at birth and who often seek to live as, or transition to, the gender with which they identify, sometimes involving medical intervention.