This dataset is an Analytical Tool (.xlsm format) to model last-mile delivery and different city logistics measures in the context of e-commerce delivery.
The objective here is to build an economic model for a last mile delivery service provider, serving N customers in a service region of size A in n_r periods of time-window of length T_TW from a depot located at a distance of ρ_x and ρ_y from the center of the service region. This depot—an e-commerce fulfillment center—is serviced from a larger regional fulfillment center located at a distance of ρ_x', ρ_y' from the center of the service region. In addition, let there be N_F randomly and uniformly distributed facilities within the service region, of which N_MH operate as micro-hubs (consolidation facilities) and N_CP are collection point pick-up facilities, serving a market share of p_MH and p_CP respectively. The vehicles departing from depot serve the N(1-p_MH-p_CP) customers directly and service the facilities as well, and the vehicles departing from MHs serve the market, while customers drive to the CPs to pick-up their packages.
This work employs Continuous Approximation (CA) techniques to model last-mile parcel delivery operations to better understand the impacts of different city logistics measures and last-mile strategies.