Supply Chain Engineering -
Dollar Tree
Network Container Project
Earphones
White Team
Jin Cao, Haosen Xu, Utsav Dedhia,
Jonathan Wang, Ishani Prachchhak
PROJECT TEAM
Utsav Dedhia
Jining Cao
Haosen Xu
Jonathan Wang
Ishani Prachchhak
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!"
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.
PRODUCT PHOTOS
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 |
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
Factory Selection Criteria ( Must & Wants )
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 |
BOM
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.
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
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 | | |
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
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 |
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
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
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 |
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 |
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 |
THANK YOU