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

question 8

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.Assume that demand for retail outlet three (R3)increases to 300 units.How will this affect the shipping cost? Use Excel to formulate and solve this problem

---

Definitions:

Spine and Brain

Central components of the nervous system where the brain is the control center and the spine connects it to the rest of the body through nerve fibers.

Germinal Period

The initial two weeks of prenatal development after conception, characterized by rapid cell division and the beginning of cell differentiation.

Fetal Stage

The fetal stage is the last stage of prenatal development, beginning in the ninth week of pregnancy and continuing until birth, characterized by rapid growth and maturation of organs and body systems.

Embryonic

Pertains to the earliest stage of development, typically before birth, often used in biology to describe the early stages of an organism's development.