Layout Design of Warehouse for an e-retailer

-
In an e-retail setting when a consumer orders products, information are passed to brick and mortar warehouse for delivery of the ordered product.  The brick and mortar warehouse may be owned by same e retailers or may owned by a third party, serving the on-line demands as well as the in-store demands. As most of the in-store retailers have also started selling products on line the layout of the warehouse should be redesigned to reduce the operational cost. So that the replenishment time for the store and delivery time for the on line order can be minimized.  In a traditional warehouse design a separate layout for the delivery of the on line orders has not been studied. Most of the studies focus on the layout of the warehouse designed for the in-store retail type of sales.

In this research we study the impact of the on line sales on the warehouse design. When an online orders are received at the warehouse through the website of the e retailer delivery process is initiated. The process is comprises of several steps.  The Steps are listed below

1. Identifying the product in the order and its location in the warehouse.
2. Placing the product on the delivery line
3. Generating the bill
3. Placing the packing material in the packing line.
4. Packing line meets delivery line
5. Packing of the orders
6. Generating the delivery address and sticking the address.
7. Pick up by and keeping on the relevant zone
8. Delivery boy goes for delivery when certain number of delivery is received or lead time promised is very short. 

Comments

Post a Comment

Popular posts from this blog

Solution for ERROR: Some character data was lost during transcoding in the dataset

-
When I search for the mentioned error I get the link solution provided administration oriented but developers do not have access.     http://support.sas.com/kb/52/716.html Please see my solution below proc options option=config; run; proc options group=languagecontrol; run; /* Show the encoding value for the problematic data set */ %let dsn=item_information_may16; %let dsid=%sysfunc(open(&dsn,i)); %put &dsn ENCODING is: %sysfunc(attrc(&dsid,encoding)); /*Renaming item desc file  (encoding=any) allowed reading****************************/ data tmp.item_info_curr; set hc.item_information_may16 (encoding=any); run; /*gave error*/ data item_info_curr; set item_information_may16; run;
Read more

How to check whether a SAS dataset exist or not and throw an error in the log ?

-
/* if the data set exists, then conditionally execute the step(s). %sysfunc checks the availability of the data in the library location. It means it checks historical sas data. It generates the system error if the not is data available at the defined library  */ %let dsname=&dataval.MKT_DATA;  /**** declaring data set name with library*****/ %macro warning1(name); %if %sysfunc(exist(&name)) %then %do; Proc printto log="&logfile.\WarningLog..txt" new;     /*** printing log in the text file at specifile location &logfile****/ run; %Put WARNING :- &name does not exists; Proc printto  ; Run; %end; %else %do; Proc printto log="&logfile.\WarningLog.txt" ; run; %put &name exists; Proc printto  ; Run; %end; %mend ; %warning1(&dsname); /**** Pros:  If any sas process is dependent on the existence of the data then we can use this macro***/ /**** Cons:  *Even if the SAS data set is available with zero observatio
Read more

2018 plan for getting expertise in Machine Learning and Deep Learning

-
Machine Learning and deep learning are next frontier in the world of innovation. These skill sets are high in demand and demand is going to increase further as we are moving towards a world with connected systems. Although I am experienced professional with SAS having multiple SAS certifications and  using SAS for programming, predictive model building, optimization and data visualization for more than seven years, I will be foolish I do not recognize how important it is to adopt open source platforms for innovation.  2018 plan to acquire expertise in these are are 1. Choose a programming language and I have chose python as my language of preference  2. Do hands on practice to be efficient in Pandas and Numpy. These two libraries are useful and very important for data exploration,wrangling and data cleaning. I find Kernals in Kaggle and below blogs and books to be helpful tutorial for  Pandas  a. https://www.dataquest.io/blog/pandas-tutorial-python-1/  b.https://www.d
Read more