1 of 21

Supply Chain Engineering -

Dollar Tree

Network Container Project

Earphones

White Team

Jin Cao, Haosen Xu, Utsav Dedhia,

Jonathan Wang, Ishani Prachchhak

2 of 21

PROJECT TEAM

Utsav Dedhia

Jining Cao

Haosen Xu

Jonathan Wang

Ishani Prachchhak

3 of 21

Background Information

Dollar Tree, Inc. is an American chain of discount variety stores that sells items for $1. It is a Fortune 500 company, headquartered in Chesapeake, Virginia and operates 4,900 stores throughout the 48 contiguous U.S. states and Canada. With Dollar Tree a highly successful concept was created using this single price point to build a national chain of stores. Its stores are supported by a nationwide logistics network of 24 distribution centers. Each Dollar Tree stocks a variety of products in an environment where shopping is fun, a place where our customers can discover new treasures every week. We love to hear from our customers and overwhelmingly the two comments we repeatedly receive are:

​

"I can't believe this cool item I just found at Dollar Tree!" AND...

​

"I can’t believe the low price — what a great value!"

4 of 21

INTRODUCTION

Objective:

​

We will be designing the forward supply chain network container that delivers the 1,000,000 earphones per year for a cost less than $65.7 cents/unit from a factory in China. And to sell through Dollar Tree network chain across United States using its the various distribution centers. It will include detailed explanations of each step that together forms the design of the supply chain network container from the supplier to end products for consumer.

5 of 21

PRODUCT PHOTOS

6 of 21

SUPPLY CHAIN CONSTRUCTION REQUIREMENT SPECIFICATION

ATTRIBUTE

DESCRIPTION

Network Type

Forward Network

Market Segment

Dollar Tree Store Customers

Product Family

Wired Earphones

Project Objective

Design a Forward Supply Chain Network container that profitably delivers 1,000,000 units of Earphones at less than 65.7 cents/unit from a factory located in China to the United States market through Dollar Tree Distribution Centers

Specification

Value

Dimensions

Validation

Throughput

1,000,000

Units/Year

 □Accept

□Reject

Factory

Cash-to-cash cycle

Velocity

Variability

Days +/-

+/- Days

□Accept

□Reject

Distributor

Cash-to-cash cycle

Velocity

Variability

Days +/-

+/- Days

□Accept

□Reject

Factory to distribution

Price/landed cost

<$0.657

Dollars/Unit

□Accept

□Reject

Distribution to store

Price/landed cost

<$1.000

Dollars/Unit

□Accept

□Reject

7 of 21

Echelon Map

Echelon 4

Supplier A

Supplier B

...

Supplier J

Supplier K

Echelon 3

Echelon 2

Echelon 1

DC 1

Customer

DC 2

...

DC 14

DC 15

Factory

Dollar Store

8 of 21

Factory Selection Criteria ( Must & Wants )

9 of 21

Factory Location

Factory

Dongguan Shipai Xin Kaph Electronic Products Factory

Links

https://cn1511147076.en.alibaba.com/company_profile.html

Location

Dongguan, China

Year Established

2013

Factory Size

1,000-3,000 square meters

Total Employees

51 - 100 People

No. of Production Lines

5

Annual Output Value

US$2.5 Million - US$5 Million

Total Annual Revenue

US$1 Million - US$2.5 Million

Patent

xkf-06

Features

Professional earphone assembly

Ideal location & price

Sufficient capacity

10 of 21

BOM

11 of 21

Suppliers Location

Suppliers

Locate

Foshan Quanying Commerce And Trade Co., Limited

Foshan,China

Shenzhen Shenwei Gold Thread Decoration Co., Ltd.

Shenzhen,China

Dongguan Shenghuitai Silicone Rubber Products Co., Ltd.

Dongguan,China

Shenzhen Longgang Yinmei Electronics Co., Ltd

Shenzhen,China

Huizhou Tuojin Electronics Co., Ltd

Huizhou,China

Dongguan hualixin Electronics Co., Ltd

Dongguan,China

Shenzhen Boruitong Electronics Co., Ltd

Shenzhen,China

Dongguan Nanfeng Electronic Co., Ltd

Dongguan,China

Shenzhen Jixing Electric Wire & Cable Co., Ltd.

Shenzhen,China

Jieyang Chengfeng Industrial Co., Ltd.

Jieyang,China

All our suppliers are within the 240 miles established.

The farthest supplier is 202 miles away from the factory.

The nearest port to factory is Humen Port.

12 of 21

Distribution Centers & Worst Case Number of Cross-Dockings

1. Ridgefield, WA

2. Stockton, CA

3. San Bernardino, CA

4. St. George, UT

5. Marietta, OK

6. Rosenberg, TX

7. Warrensburg, MO

8. Olive Branch, MS

9. Joliet, IL

10. Marengo, OH

11. Cherokee County, SC

12. Savannah, GA

13. Briar Creek, PA

14. Chesapeake, VA

15. Windsor, CT

13 of 21

Package and Palletization

​

Product

Carton

Pallet

FEU Container

Size

1.02'' x 5.12’’ x 7.09’’

12'' x 10'' x 10''

48'' x 40'' x 5.25''

FEU Standard

Weight

0.067 lb

3 lb

50 lb

Number of Unit(s)

1

40

2,560

102,400

Total Weight

0.067 lb

5.680 lb

413.520 lb

16,540.800 lb

+ tare weight

Notes

A set of two units = 1.02'' x 5.12’’ x 9.59’’

Sets per Carton = (12''/5.12'') * (10''/1.02'') * (10''/9.59'') = 20

Units per Carton = 2 x 20 = 40

Carton per Pallet = (48''/12'') * (40''/10'') * (40''/10'') = 64

​

14 of 21

Cost Estimation (Factory Price & Mid-bound Logistics)

Factory Price

Material Price

$ 0.1510

Inbound Logistics 5%

$ 0.0076

Factory Landed Cost

$ 0.1586

Labor Hours (minutes/unit)

1.80

Labor Rate ($/Hour)

5.00

Overhead

0.85

COGS

$ 0.4361

Markup

0.20

Factory Price

$ 0.5233

Mid-bound Logistics

FEU Container $/Each

5200

Units Per FEU Container

102,400

Container Cost

$ 0.0508

Duty Rate

0.035

Duty Cost

$ 0.0201

Cross-docking Cost $/Pallet

7

Cross-docking

3

Cross-docking Cost

$ 0.0082

Mid-bound Freight and Duty Cost

$ 0.0791

Distributor Landed Cost: $ 0.6023/unit

15 of 21

Price/Landed Cost

Echelon

Factor

Price/Landed Cost

Budget

2

Distributor Product Cost

Landed Cost

$ 0.6023

 

 

 

 

 

Midbound Logistics (inclu cross-docking and duty)

Price

$ 0.0791

 

 

 

3

Factory Price = COGS x(1+%Markup)

$ 0.5233

 

 

 

 

3

Factory Markup at 20%

 

$ 0.0872

 

 

 

3

Factory Cost Of Goods Sold = M+L+OH

$ 0.4361

 

 

 

 

3

Factory Material Cost

Landed Cost

$ 0.1586

 

 

 

 

 

Inbound Logistics (Including Duty)

Price

$ 0.0076

 

 

 

4

Supply Price of Direct Materials in the BOM

$ 0.1510

16 of 21

Factory Cash-to-Cash Cycle

O= Order Time

LT= Lead Time

C= Time to Cash

ITT= Inbound Transit Time

MTT= Midbound Transit

Time

M= Make Time

Inv= Inventory Holding Time

Cash-To-Cash Cycle velocity = -30+(1+15+47+1+30)= 64 days

Cash-To- Cash Cycle variability= Inventory Holding Time variability = ±7 days

Delivery Lead Time= 1+1+28 = 30 days

17 of 21

Distributor Cash to Cash Cycle

Dollar Tree information taken from Form 10-K

Merchandise Inventories

$1,782 Million

Account Payable

$770 Million

Account Receivable

$0

Net Sales

$13,265 Million

Net Profits

$4,543.8 Million

COGS

$8,721.2 Million

Days of Inventory = ($Inventory x 365 Days) / $Annual COGS = (17821 x 365) / 8721.2 = 74.58 days

Days of Receivable = ($A/R x 365) / $Annual Revenue = 0 days

Days of Payable = ($A/P x 365 Days ) / $Annual COGS = (770 x 365) / 8721.2 = 32.2 days

Days of Cash Conversion = Days of Inventory + Days of Receivables - Days of Payables = 74.58 + 0 - 32.2 = 42.4 days

18 of 21

SUPPLY CHAIN CONSTRUCTION REQUIREMENT SPECIFICATION

ATTRIBUTE

DESCRIPTION

Network Type

Forward Network

Market Segment

Dollar Tree Store Customers

Product Family

Wired Earphones

Project Objective

Design a Forward Supply Chain Network container that profitably delivers 1,000,000 units of Earphones at less than 65.7 cents/unit from a factory located in China to the United States market through Dollar Tree Distribution Centers

Specification

Value

Dimensions

Validation

Throughput

1,000,000

Units/Year

 Accept

□Reject

Factory

Cash-to-cash cycle

Velocity = 64 days

Variability = +/- 7 days

Days +/-

+/- Days

Accept

□Reject

Distributor

Cash-to-cash cycle

Velocity = 42.4 days

Variability = +/- 3 days

Days +/-

+/- Days

Accept

□Reject

Factory to distribution

Price/landed cost

0.6023

Dollars/Unit

Accept

□Reject

Distribution to store

Price/landed cost

<$1

Dollars/Unit

Accept

□Reject

19 of 21

Summary

Objectives

Results

Develop BOM; Competitive Supplier Price on Direct Materials

Total Cost of Direct Material: $0.1510

Supplier Must: Process Capability; Price; Throughput

Select the Factory & Map the Supply Base (Suppliers within 240 miles)

Factory MUST satisfied

Outermost Supplier to Factory: 202 miles

Model Factory & Distributor Cash to Cash Cycle

Factory: Velocity: 64 days;

Distributor: Days of Cash Conversion: 42.4 days

Define Package Carton and Total Products per Container

40 units per Carton (size: 12'' x 10'' x 10’’)

64 Carton per Pallet

102,400 units per Container

Deliver 1 Million Unit/Year for Less Than $0.657/Unit

Factory Capacity: 2.5 Million Units / Highest Ever 5 Million Units

Distributor Landed Cost: $0.6023

20 of 21

Price At $1.00

Variance

Price At $1.25

Variance

Material Price

$ 0.1510

$ 0.1510

$ 0.1510

Inbound Logistics 5%

$ 0.0076

$ 0.0076

$ 0.0076

Factory Landed Cost

$ 0.1586

$ 0.1586

$ 0.1586

Labor Hours (minutes/unit)

1.80

1.80

1.80

Labor Rate ($/Hour)

5.00

6.25

25%

6.25

Overhead

0.85

0.85

0.85

COGS

$ 0.4361

$ 0.5054

16%

$ 0.5054

Markup

0.20

0.20

0.20

Factory Price

$ 0.5233

$ 0.6065

16%

$ 0.6065

FEU Container $/Each

5200

10400

100%

10400

Units Per FEU Container

102400

102400

102400

Container Cost

$ 0.0508

$ 0.1016

100%

$ 0.1016

Duty Rate

0.035

0.035

0.035

Duty Cost

$ 0.0201

$ 0.0248

23%

$ 0.0248

Cross-docking Cost $/Pallet

7

9

25%

9

Cross-docking

3

3

3

Cross-docking Cost

$ 0.0082

$ 0.0103

$ 0.0103

Mid-bound Freight and Duty Cost

$ 0.0791

$ 0.1366

73%

$ 0.1366

Distributor Landed Cost

$ 0.6023

$ 0.7431

23%

$ 0.7431

Profitbility

39.77%

25.69%

-35.40%

40.55%

1.97%

Profit

$ 0.3977

$ 0.2569

$ (0.1408)

$ 0.5069

$ 0.1092

21 of 21

THANK YOU