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
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.
DATA PROFILING AND DATA SUMMARY
DATA PROFILING AND DATA SUMMARY
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 |
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 |
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 |
MATERIAL HANDLING EQUIPMENT
Justification of the change in resources:
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 |
TOTAL SPACE REQUIREMENTS
5% | within the Range of benchmark |
95% | Not meeting the Range of benchmark |
TOTAL SPACE REQUIREMENTS
0%-64% | 68% |
65%-75% | 5% |
76%-above | 27% |
The out of benchmark range is classified as below
TOTAL SPACE REQUIREMENTS
Approach to Drill Down Analysis
0% | 35% |
0.1%-64% | 33% |
65%-75% | 5% |
76%-above | 27% |
TOTAL SPACE REQUIREMENTS
Empty Bins by category
TOTAL SPACE REQUIREMENTS
Bins between 0.1% to 64.9% Full by Category
TOTAL SPACE REQUIREMENTS
Bins Grater than 75% Full by Category
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
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
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
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 |
|
|
|
|
|
|
|
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
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
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
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
PROPOSED TECHNOLOGY SOLUTION
PROPOSED DESIGN AND DESIGN FLOW
2D AUTOCAD LAYOUT DRAWINGS
Preliminary Layout Condition
2D AUTOCAD LAYOUT DRAWINGS
Finished Layout
INVESTMENT COST ESTIMATE