1 of 28

LOGISTICS DISTRIBUSTION SYSTEMS - KEY ASSIGNMENT

A CASE STUDY ON IDENTIFYING THE OPPORTUNITIES FOR IMPROVING THE PROCESS OF FAIR TRADER FACILITY

IE 5334-001

SHIBA SHIVAPRAKASH 1001869004

LEKHYA SINDURA NADELLA 1001958999

AKACHUKWU UDOKORO MARYCOLLECT 1001891155

SACHIN PATEL KAKABAL GOUDER SHANKARANANDA 1001869057

Submitted to MAYSAA M HAMDAN

2 of 28

EXECUTIVE SUMMARY

Fair Traders is a non-profit organization which is source for various hand-made gifts, décor, textiles etc that bring forward the diverse culture of artisans of different parts of the world. It is also a founding member of the WFTO. From the given description it is evident that various changes such as the layouts, workstations setups and current processes can be advanced for better enhancement of productivity and capacity of the throughput. The focal point of this review discusses the business concept of selling products directly to customers, avoiding any third-party retailers, wholesalers, or other middlemen, is known as direct-to-consumer (DTC). In this facility the DTC channels include festivals, ecommerce, and wholesale.

The current process demonstrates that the principal level of the office has space devoted to items for the retail locations and transfer alongside space for direct-to-client items. There is an additional mezzanine floor where the space is accessible for direct-to-client items. As of now it is utilized for the more modest things (for example adornments and scarves) that are by and large put away in receptacles. Incidentally, direct-to-client things are intermixed with the retail and transfer things.

The current warehouse layout is changed to a U-shape warehouse as it increases the efficiency and utilization of space. The receiving and shipping docks separated to avoid bottlenecks and delay in the process. An inbound sheltered truck dock is added and separated from the outbound shelter truck. The number of dock doors increased for ease movement of inbound and outbound products. E-Com Fulfillment area is moved to the center of the mezzanine floor as the conveyor is used to roll the packages around. Hence for the overall the changed warehouse is a semi-automated warehouse that involves but equipment’s and human for better productivity, avoid bottles, efficient space utilization and minimized costs.

3 of 28

DATA PROFILING AND DATA SUMMARY

  • We start with analyzing the data to identifying opportunities for improvement. This led to the discovery that there was an opportunity to improve the warehouse occupancy to ensure that productivity and safety issues do not get out of hand.

4 of 28

DATA PROFILING AND DATA SUMMARY

5 of 28

DETAILED LABOR PLAN

Number of Employee’s

Positioning

 

Number of working hours per day

Wage per hour

Hours working (Monday to Friday: 40 hours) per week

1

Receiving

8

11

$440

1

Stocking

8

11

$440

1

Picking

8

11

$440

1

Packing

8

11

$440

2

Shipping DTC

8

11

$880

1

Overall Maintenance

8

13

$520

Total = 7

 

40

 

$3160 per week

The Employee Schedule on Regular days

As the new warehouse is semi-automated the Employee schedule on a regular month:

Number of Employee’s

Positioning

 

Number of working hours per day

Wage per hour

Hours working (Monday to Friday: 40 hours) per week

1

Receiving

8

10

$400

1

Stocking

8

10

$400

1

Shipping DTC

8

11

$440

1

Overall Maintenance

8

12

$480

Total = 4

 

40

 

$1720 per week

6 of 28

DETAILED LABOR PLAN

The Employee Schedule from mid- November to December

The Employee Schedule from mid-November to December

Number of Employee’s

Positioning

Number of working hours per day

Wage per hour

Hours working (Monday to Friday: 45 hours & DTC 60 hours)

1

Receiving

8

11

$495

1

Stocking

8

11

$495

1

Picking

8

11

$495

1

Packing

8

11

$675

2

Shipping DTC

12

15

$1800

1

Overall Maintenance

8

13

$585

Total = 7

 

 

 

$4545

Number of Employee’s

Positioning

Number of working hours per day

Wage per hour

Hours working (Monday to Friday: 45 hours & DTC 60 hours)

1

Receiving

8

11

$495

1

Stocking

8

11

$495

2

Shipping DTC

12

15

$1800

1

Overall Maintenance

8

13

$585

Total = 5

 

 

 

$3375

7 of 28

MATERIAL HANDLING EQUIPMENT

The Current Warehouse equipment’s

Resource

Quantity

Cost

Total cost acc to quantity

Narrow Aisle Reach Truck

1

$43000 per unit

$43000

Manual pallet jacks

3

$475 per unit

$1425

Pick carts with 2 shelves

13

$980 per unit

$12740

Platform carts

2

$615 per unit

$1230

Spiral chute

1

$10000 per unit

$10000

Gravity conveyor

1

$50 per linear foot

 

Total

-

-

$70000

The Current Warehouse equipment’s

Type of Resource

Resource

Quantity

Cost per unit

Total cost acc to quantity

Dock Equipment

Dock Boards

 

6

$700

$4200

​

 Conveyors

Spiral chute

1

$10000

$10000

Gravity Conveyor

1

$50 per linear foot

 

 

 

Lifting Equipment’s

Turret Trucks

1

$95000

$95000

Wire Guided Systems

 

$3.60 per foot

 

Pick carts with 2 Shelves

4

$980

$3920

high speed miniload AS/RS system definition

 

$367 per SKU

 

Packing Equipment’s

Automatic pack print & apply bar code label

1

 

$50000

$50000

8 of 28

MATERIAL HANDLING EQUIPMENT

Justification of the change in resources:

  • A dock board is a movable often metal plate for bridging the gap between a motor truck or freight car and a loading platform.
  • We retained the spiral chute for transporting materials to a lower level. And gravity conveyor at the mezzanine floor to roll the packages.
  • If you require high density volume warehouse the turret truck can save up to 50% more space than your standard reach truck and 25% than an articulated forklift. The turret truck is ideal in applications where relocation or land cost is high, such as large cool room warehouses.
  • Wire guidance is a system that guides steering of the turret truck by controlling electric signals. Added to the initial cost of the turret truck itself, you will have to install the wire guidance system in the floors of your facility. The initial cost of a turret truck can be a barrier to entry. Pick carts confined to zones for better picking of smaller
  • Miniload Automated Storage and Retrieval System (Miniload AS/RS) provides fast and efficient storage and retrieval for containers, trays, cases, and other small loads. Its high speeds ensure timely inventory supply for both order-picking and manufacturing operations.
  • Label printing is the process of printing custom labels with accuracy in positioning and reduced errors.
  • Motion scale machine is a device used to measure the mass, force exertion, tension, and resistance of an object without the need of a power supply.

9 of 28

TOTAL SPACE REQUIREMENTS

Row Labels

Sum of BinVol

Sum of MerchVol

Average of PercentFull

Sum of Quantity

Chicken Box

816587.916

344213.313

53%

17231888

Gaylord

852646.644

550386.499

68%

2191877

Half-Chicken Box

108700.982

41986.975

44%

2364963

Producer Box

13364.548

2611.19

42%

63454

Skid

1630650.004

1253799.595

82%

2060109

(blank)

1053685.277

3089.787

0%

140016

Grand Total

4475635.371

2196087.359

43%

24052307

10 of 28

TOTAL SPACE REQUIREMENTS

  • Recall that productivity and safety typically declines rapidly as occupancy exceeds 85%
  • Hence, we set a benchmark range to 65%-75%
  • Percent Full is the ratio of MerchVol to BinVol.

​

5%

within the Range of benchmark

95%

​

Not meeting the Range of benchmark

11 of 28

TOTAL SPACE REQUIREMENTS

0%-64%

68%

65%-75%

5%

76%-above

27%

The out of benchmark range is classified as below

12 of 28

TOTAL SPACE REQUIREMENTS

Approach to Drill Down Analysis

0%

35%

0.1%-64%

33%

65%-75%

5%

76%-above

27%

13 of 28

TOTAL SPACE REQUIREMENTS

Empty Bins by category

14 of 28

TOTAL SPACE REQUIREMENTS

Bins between 0.1% to 64.9% Full by Category

15 of 28

TOTAL SPACE REQUIREMENTS

Bins Grater than 75% Full by Category

16 of 28

TOTAL SPACE REQUIREMENTS

Economic Analysis for Bins

The economic analysis of bin is performed to evaluate the benefits of reorganizing the warehouse. The following step were performed to determine the total benefit verse total cost for the current year. Since we are expecting an 25% increase in volume in the upcoming year and a 35% increase in subsequent years. We also perform the same calculations for the next two years with 25% and 35% increase. This is done to determine what the total benefit verse total cost are. It was discovered find that the reorganization of bins will generate a total benefit of $84,605.64 in the current year which is a credit we will use to support the warehouse in future. The steps for our calculations are given below.  

Steps  

  • Looked that each bin size category (Basket, Chicken Box, ODDSIZE3A, Pallet, Tall Pallet and Half Pallet) for each month in the year 2011) 
  • Used the Merch Volume given to calculate the Bin Volume Required at an occupancy fill rate of 65%. Remember our benchmark start from 65% to 75%. We are using 65% in our calculation to ensure we have enough bin volume required. 
  • The Bin Volume required was then used to calculate number of bins we need. This number is then subtracted from Total bins available to see If we have an excess amount, just the right amount or not enough Bins in every category. 
  • Cost of the total excess which is a credit for future years is calculated to $79,921.26 
  • Cost of New Bins Need is also calculated to be zero 
  • This means that in the current ear we do not have any need to purchase any new bins due to our plan to optimize the warehouse but ensuring all our bin are utilized at least 65% 
  • This calculation was also conducted for the next two years as we expect a 25% volume growth in the upcoming year and 35% in the subsequent year. 
  • Cost of the total excess was calculated to be $2831.05 
  • Cost of New Bins Need is also calculated to be $66,137.08 
  • This means that after utilizing the credit of $79,921.25, we will still need to spend 66,137,08 on 
  • Bins in the next two years due to the expected increase. 

17 of 28

TOTAL SPACE REQUIREMENTS

BASKET= 207.778 Bin Vol

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

171.099

263.2292308

2

3

0

0

$ 602.55

602.55

$ -

$ -

Feb

157.839

242.8292308

2

 

 

 

 

 

​

​

March

277.364

426.7138462

3

 

 

 

 

 

​

​

April

219.827

338.1953846

2

 

 

 

 

 

​

​

May

212.756

327.3169231

2

 

 

 

 

 

​

​

June

194.774

299.6523077

2

 

 

 

 

 

 

 

BASKET= 207.778 Bin Vol

​

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

288.729563

444.1993269

3

3

0

1

$ 602.55

803.4

$ -

$ 200.85

Feb

266.353313

409.7743269

2

 

​

 

 

 

 

 

March

468.05175

720.0796154

4

 

​

 

 

 

 

 

April

370.958063

570.7047115

3

 

​

 

 

 

 

 

May

359.02575

552.3473077

3

 

​

 

 

 

 

 

June

328.681125

505.6632692

3

 

 

 

 

 

 

 

Bin Economic Analysis for Future 2 Years  

BASKET 

Each baskets have a Bin Volume of 207.778 ft3 and our baskets are made up of single deep racks. If one pallet which is 60 Bin Volume cost $58 then one basket will cost $200.85. After applying the steps above, we see that there is no excess bin and we also do not need to purchase new bins because the Max bin required matches the total Bin available  

18 of 28

TOTAL SPACE REQUIREMENTS

Chicken Boxes  

The Chicken boxes in our calculations have a Bin Volume of 2.292 ft3 and our baskets are made up of single deep racks as well. The cost of per Chicken Box is $2.22. The steps above are applied and we see that there are excess bins available which can be used in the future as we expect to increase our volume.  

Chicken Boxes =2.292 Bin Vol

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New bin need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

3,760.41

5,785.25

2,525

5,471.00

2,238.00

0

$ 12,145.62

$ 7,177.26

$ 4,968.36

$ -

Feb

3,852.23

5,926.51

2,586

 

 

 

 

​

​

​

March

4,583.74

7,051.90

3,077

 

 

 

 

​

​

​

April

4,815.10

7,407.85

3,233

 

 

 

 

​

​

​

May

4,727.51

7,273.10

3,174

 

 

 

 

​

​

​

June

4,504.67

6,930.26

3,024

 

 

 

 

 

 

 

Chicken Boxes =2.292 Bin Vol

​

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New bin need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

6,345.69

9,762.60

4,260

5,471.00

16.00

0

$ 12,145.62

$ 12,110.10

$ 35.52

$ -

Feb

6,500.64

10,000.99

4,364

 

 

 

 

​

 

 

March

7,735.06

11,900.09

5,193

 

 

 

 

​

 

 

April

8,125.48

12,500.75

5,455

 

 

 

 

​

 

 

May

7,977.68

12,273.35

5,355

 

 

 

 

​

 

 

June

7,601.63

11,694.81

5,103

 

 

 

 

 

 

 

Bin Economic Analysis for Future 2 Years  

19 of 28

TOTAL SPACE REQUIREMENTS

Pallets   

60 Bin Vol, Double Deep= $62 

Pallets = 60 Bin Vol, Double Deep= $62

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New bin need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

126538.844

194,675.14

3,245.00

4433

1,188.00

0

$ 274,846.00

201,190.00

$ 73,656.00

$ -

Feb

123854.252

190,545.00

3,176.00

 

 

 

 

​

​

​

March

126185.879

194,132.12

3,236.00

 

 

 

 

​

​

​

April

118401.316

182,155.87

3,036.00

 

 

 

 

​

​

​

May

113260.587

174,247.06

2,905.00

 

 

 

 

​

​

​

June

120199.55

184,922.38

3,083.00

 

 

 

 

 

 

 

Bin Economic Analysis for Future 2 Years  

Pallets = 60 Bin Vol=$62

​

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New bin need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

213534.299

328,514.31

5,476.00

4433

0

1,043.00

$ 274,846.00

339,512.00

$ -

$ 64,666.00

Feb

209004.05

321,544.69

5,360.00

 

 

 

​

​

 

 

March

212938.671

327,597.96

5,460.00

 

 

 

​

​

 

 

April

199802.221

307,388.03

5,124.00

 

 

 

​

​

 

 

May

191127.241

294,041.91

4,901.00

 

 

 

​

​

 

 

June

202836.741

312,056.52

5,201.00

 

 

 

 

 

 

 

20 of 28

TOTAL SPACE REQUIREMENTS

Half Pallet  

26.667 Bin Vol 

Half Pallets =26.667 Bin Vol

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New bin need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

1509.613

2322.481538

88

244

150

0

6290.32

2423.32

$ 3,867.00

$ -

Feb

1570.469

2416.106154

91

 

 

 

 

​

​

​

March

1620.593

2493.22

94

 

 

 

 

​

​

​

April

1398.451

2151.463077

81

 

 

 

 

​

​

​

May

1463.23

2251.123077

85

 

 

 

 

​

​

​

June

1432.204

2203.390769

83

 

 

 

 

 

 

 

Half Pallets =26.667 Bin Vol

​

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New bin need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

2547.47194

3919.187596

147

244

86

0

6290.32

4073.24

$ 2,217.08

$ -

Feb

2650.16644

4077.179135

153

 

 

 

 

​

 

 

March

2734.75069

4207.30875

158

 

 

 

 

​

 

 

April

2359.88606

3630.593942

137

 

 

 

 

​

 

 

May

2469.20063

3798.770192

143

 

 

 

 

​

 

 

June

2416.84425

3718.221923

140

 

 

 

 

 

 

 

Bin Economic Analysis for Future 2 Years  

21 of 28

TOTAL SPACE REQUIREMENTS

Tall Pallect=82.222 Bin Vol

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

3981.104

6124.775385

75

151

19

0

12001.48

10491.36

$ 1,510.12

$ -

Feb

4053.983

6236.896923

76

​

 

 

​

​

​

​

March

6187.01

9518.476923

116

​

 

 

​

​

​

​

April

7020.041

10800.06308

132

​

 

 

​

​

​

​

May

6468.757

9951.933846

122

​

 

 

​

​

​

​

June

6085.613

9362.481538

114

 

 

 

 

 

 

 

Tall Pallect=82.222 Bin Vol

​

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

6718.113

10335.55846

126

151

0

71

12001.48

17644.56

$ -

$ 5,643.08

Feb

6841.09631

10524.76356

129

 

 

 

 

​

 

 

March

10440.5794

16062.42981

196

 

 

 

 

​

 

 

April

11846.3192

18225.10644

222

 

 

 

 

​

 

 

May

10916.0274

16793.88837

205

 

 

 

 

​

 

 

June

10269.4719

15799.1876

193

 

 

 

 

 

 

 

Tall Pallet  

82.222 Bin Vol 

Bin Economic Analysis for Future 2 Years  

22 of 28

ODDSIZE3A 

78.125 Bin Vol 

ODDSIZE3A= 78.125 Bin Vol

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

44.262

68.09538462

0.87162092

14

8.89543877

 

1057.28

385.4964641

$ 671.78

$ -

Feb

47.889

73.67538462

0.94304492

 

 

 

 

​

​

​

March

45.253

69.62

0.891136

 

 

 

 

​

​

​

April

40.65

62.53846154

0.80049231

 

 

 

 

​

​

​

May

55.627

85.58

1.095424

 

 

 

 

​

​

​

June

259.216

398.7938462

5.10456123

 

 

 

 

 

 

 

ODDSIZE3A= 78.125 Bin Vol

​

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

74.692125

114.9109615

2

14

5

0

1057.28

679.68

$ 377.60

$ -

Feb

80.8126875

124.3272115

2

 

 

 

 

​

 

 

March

76.3644375

117.48375

2

 

 

 

 

​

 

 

April

68.596875

105.5336538

2

 

 

 

 

​

 

 

May

93.8705625

144.41625

2

 

 

 

 

​

 

 

June

437.427

672.9646154

9

 

 

 

 

 

 

 

Bin Economic Analysis for Future 2 Years  

TOTAL SPACE REQUIREMENTS

Total Cost of Benefits

Total Cost of New Bin Need

$ 84,673.26

$ -

Total Cost of Benefits

Total Cost of New Bin Need

$ 2,831.05

$ 70,509.93

Benefit Versus Cost  

Bin Economic Analysis for Future 2 Years  

23 of 28

ODDSIZE3A 

78.125 Bin Vol 

ODDSIZE3A= 78.125 Bin Vol

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

44.262

68.09538462

0.87162092

14

8.89543877

 

1057.28

385.4964641

$ 671.78

$ -

Feb

47.889

73.67538462

0.94304492

 

 

 

 

​

​

​

March

45.253

69.62

0.891136

 

 

 

 

​

​

​

April

40.65

62.53846154

0.80049231

 

 

 

 

​

​

​

May

55.627

85.58

1.095424

 

 

 

 

​

​

​

June

259.216

398.7938462

5.10456123

 

 

 

 

 

 

 

ODDSIZE3A= 78.125 Bin Vol

​

​

​

​

​

​

​

​

​

​

Month

Merch Volume

bin volume required

Bins required

Total Bins Available

Excess

New Bin Need

Cost of Total Bin Avilable

Cost of Bins Required

Cost of Excess

Cost of New Bin Need

Jan

74.692125

114.9109615

2

14

5

0

1057.28

679.68

$ 377.60

$ -

Feb

80.8126875

124.3272115

2

 

 

 

 

​

 

 

March

76.3644375

117.48375

2

 

 

 

 

​

 

 

April

68.596875

105.5336538

2

 

 

 

 

​

 

 

May

93.8705625

144.41625

2

 

 

 

 

​

 

 

June

437.427

672.9646154

9

 

 

 

 

 

 

 

Bin Economic Analysis for Future 2 Years  

TOTAL SPACE REQUIREMENTS

Total Cost of Benefits

Total Cost of New Bin Need

$ 84,673.26

$ -

Total Cost of Benefits

Total Cost of New Bin Need

$ 2,831.05

$ 70,509.93

Benefit Versus Cost  

Bin Economic Analysis for Future 2 Years  

24 of 28

PROPOSED TECHNOLOGY SOLUTION

  • Warehouses are getting more intelligent over time by using various technologies such as warehouse management system, Blockchain technology and use of robotic technology.
  • The use of real-time data will give the exact data occurring at that time to the warehouse workers & managers. It also provides for better decision making at that instance.
  • These technologies are used to increase the picking, further developing work designation and reducing the human interference and error.
  • The automated vehicles use sensors, algorithms and various other machine learning software's to operate independently.

​

25 of 28

PROPOSED DESIGN AND DESIGN FLOW

26 of 28

2D AUTOCAD LAYOUT DRAWINGS

Preliminary Layout Condition

27 of 28

2D AUTOCAD LAYOUT DRAWINGS

Finished Layout

28 of 28

INVESTMENT COST ESTIMATE

  • The warehouse costs vary due to various components such as the space, handling, equipment’s, labor etc.
  • Cost helps in improving the productivity by analyzing and changing the current process.
  • The costs can be minimized by:
  • Bench Marking
  • Increasing the number of atomized equipment’s
  • Increase cross docking
  • Manage labor

​

  • The semi-automated warehouse costs about $120000 as it includes automated equipment’s. Which reduces the labor, increases the productivity, ROI received in a year, and 24/7 operation.
  • The total number of labors have been reduced from 7 to 4 which indirectly cuts down the cost.

​

​