Global Supply Chain Management

sportation$/$Distribution Problem Assignment

tribution system has $3$ DCs and $5$ stores. Table $1$ provides the transportation$/$distribution costs per for a family of high end computers. The available number of units as well as the requirements and Ities at each store are in Tables $2$ and $3$ respectively.

tup in Excel$/$Solver$.$

erform a sensitivity analysis and consider the following scenarios.

Supply scenarios

Supply case $1.$ Current situation.

Supply case $2.$ Eliminating inveOPry availability in DC$1(0$ units$),$ while DC$2$ will have $134$ and DC$3$ will have $96$ units available respectively. This would represent a cost reduction of $$300$ in overhead.

Supply case $3.$ Eliminating inventory availability in DC$3(0$ units$),$ while DC$1$ will have $90$ and DC$2$ will have $140$ units available respectively. This would represent a cost reduction of $$220$ in overhead.

Demand scenarios

Demand case $1.$ Current situation.

Demand case $2.$ Demand in stores $2$ and $3$ decreases by $15$ units$/$ store and increases in