1. Case: Optimizing Supply Chain Costs – TCT Company (35 points)

1. Case: Optimizing Supply Chain Costs – TCT Company (35 points)

After announcing disappointing financials for the 2017 Fiscal year, TCT Company decided that it would be taking a hard look at several business areas to reduce costs and improve customer satisfaction. After some preliminary analysis, one of the key areas that were identified was supply chain costs.

John Lee was tasked with evaluating the 2017 supply chain cost performance and developing methodologies that would improve 2018 performance. His evaluation will include a few important items such as the optimal distribution plan, correct number of distribution centers, individual distribution center (DC) performance, etc.

Company Background

TCT was founded in the early 1990s as a small newspaper covering stories around Shanghai. After years of being in the newspaper business, TCT decided to leverage its strong business acumen and move into the paper

production business. TCT soon became a niche player to serve mass-market paperback book publishers in four markets: Northwest, Northeast, South, and East. TCT prided itself on being able to offer its customers low pricing and exceptional services. TCT’s success was also attributed to its ability to manage cash and inventory effectively. TCT currently operates four distribution centers (DCs) in the following cities: Shanghai; Xian, Shenzhen, and Shenyang. The annual capacity and operational cost of each distribution center is listed in Table 1. The demand for each market is in Table 2. Table 3 is the shipping cost (USD/ton) between DCs and markets.

Table 1: Distribution Center (DC) Annual Output (capacity of DC) and Operational Cost

DC Location

Annual Capacity (Tons)

Annual Operational Cost ($)

Shanghai

350

$100,000

Xian

230

$80,000

Shenzhen

335

$110,000

Shenyang

210

$90,000

Table 2: Annual demand for each market

Market

Annual demand (Tons)

Northwest

175

Northeast

280

South

300

Shanghai

120

Table 3: Shipping Cost between DCs and Markets (US$/Ton)

From/To

Northwest

Northeast

South

East

Shanghai

475

350

100

170

Xian

250

180

220

305

Shenzhen

215

245

300

420

Shenyang

205

160

320

280

Please response the following questions (you need to submit your model and spreadsheet as well):

1. (10 points) Formulate the case in linear programing (LP) model without closing any DC. You need to define the variables clearly and write the objective function and all constraints.

2. (10 points) If the annual total supply chain cost (Total cost from DCs to Markets and the operational cost for DCs) was $600,000 in 2017, did TCT minimize its total supply chain cost? If the total supply chain cost in 2017 was not minimized, what is the minimum total supply chain cost in 2017 and how much savings could have been achieved in 2017?

3. (5 points) What would be the optimal volume allocation from each distribution center to each market under the 2017 scenario?

(10 points) If TCT would like to consider an option of closing one of the DCs, how would you modify the LP model created in question 1? What is the optimal solution for this situation?