This README.txt file was generated on 20200727 by Raul Poler ------------------- GENERAL INFORMATION ------------------- Title of Dataset: Input Data of a linear programming model for the e-grocery order picking and delivery problem Author Information: Principal Investigator: Mar Vazquez-Noguerol, Universidade de Vigo, c/ Maxwell 36310 Pontevedra (Spain), marfernandezvazquez@uvigo.es, ORCID: 0000-0002-5319-7359. Associate or Co-investigator: Raul Poler, Universitat Politècnica de València, Plaza Ferrándiz y Carboneel 2 Alcoy (Spain), rpoler@cigip.upv.es, ORCID: 0000-0003-4475-6371. Associate or Co-investigator: Jose Comesaña-Benavides, Universidade de Vigo, c/ Maxwell 36310 Pontevedra (Spain), marfernandezvazquez@uvigo.es, ORCID: 0000-0001-9820-4877. Associate or Co-investigator: J.Carlos Prado-Prado, Universidade de Vigo, c/ Maxwell 36310 Pontevedra (Spain), marfernandezvazquez@uvigo.es, ORCID: 0000-0003-2189-2100. Date of data collection: 20200720 Geographic location of data collection: Vigo, Galicia, Spain. 42.16798518392355- -8.689099554883029. Information about funding sources or sponsorship that supported the collection of the data: Universidad de Vigo General description: The dataset contains the input data that has been entered into the mathematical model to develop the case study. The data is provided by the company and the values have been structured according to the indices defined in the model. Input data details have been added to make the model replicable. Keywords: MILP, e-commerce, e-grocery, omni-channel retailing, order fulfilment, optimisation. -------------------------- SHARING/ACCESS INFORMATION -------------------------- Open Access to data: Open. Date end Embargo: -. Licenses/restrictions placed on the data, or limitations of reuse: Creative Commons Attribution (CC-BY) Citation for and links to publications that cite or use the data: -. Links/relationships to previous or related data sets: -. Links to other publicly accessible locations of the data: -. -------------------- DATA & FILE OVERVIEW -------------------- File list: InPut Data Parameters, csv, the dataset contains the input data that has been entered into the mathematical model to develop the case study. Relationship between files: The dataset contains the input data that has been entered into the mathematical model to develop the case study. Additional related data collected that was not included in the current data package: The data is provided by the company and the values have been structured according to the indices defined in the model. The indice "I" represents stores, the indice "J" represents time windows and the indice "K" represents online orders. If data was derived from another source, list source: -. Type of version of the dataset: CSV, raw data. Versions of the files: 20200715 last version. Total size: 170KB. -------------------------- METHODOLOGICAL INFORMATION -------------------------- Description of methods used for collection/generation of data: raw data provided by the company under study. Methods for processing the data: the raw data presented has not been processed. Software- or Instrument-specific information needed to interpret the data, including software and hardware version numbers: Microsoft Excel 2010. Standards and calibration information, if appropriate: -. Environmental/experimental conditions: -. Describe any quality-assurance procedures performed on the data: data defined by the company under study. -------------------------- DATA-SPECIFIC INFORMATION -------------------------- Number of variables: 17. Number of cases/rows: 5572 rows. Variable list, defining any abbreviations, units of measure, codes or symbols used: The indice "I" represents stores, the indice "J" represents time windows and the indice "K" represents online orders. Missing data codes: -. Specialized formats or other abbreviations used: ek: Number of earlier time window selected by the customer to receive or pick up the order k lk: Number of latest time window selected by the customer to receive or pick up the order k Rk: Total quantity of items per order k CSk: Collection store chosen by the customer of the order k Bk: Total quantity of boxes of the order k SCi: Mean value in currency units of the order picking cost per item for each store i KC: Currency units associated with each kilometer traveled MPCij: Maximum picking capacity measured in number of orders for store i at time window j MDCij: Maximum delivery capacity measured in number of boxes for store i at time window j MBDij: Minimum number of boxes needed to make a shipment from store i at time window j MOPij: Minimum number of orders needed to prepare in store i at time window j Dik: Delivery distance measured in kilometres from store i to the customer or pick-up store of the order k OD_ik= {(1if the parameter Dik>0; 0 otherwise) P_k= {(1 if the order k has perishable products; 0 otherwise) SM_k= {(1if the order k is home delivery; 0 otherwise) OS_i= {(1 if the store i is ready to prepare online orders; 0 otherwise) OA_ik= {(1 if the parameter OSi ≥ SMk; 0 otherwise)┤