Online retailers’ promotional pricing, free-shipping threshold, and inventory decisions : a simulation-based analysis

Rafael BECERRIL-ARREOLA, Mingming LENG, Mahmut PARLAR

Research output: Journal PublicationsJournal Article (refereed)

36 Citations (Scopus)

Abstract

We consider a two-stage decision problem, in which an online retailer first makes optimal decisions on his profit margin and free-shipping threshold, and then determines his inventory level. We start by developing the retailer’s expected profit function. Then, we use publicly-available statistics to find the best-fitting distribution for consumers’ purchase amounts and the best-fitting function for conversion rate (i.e., probability that an arriving visitor places an online order with the retailer). We show that: (i) a reduction of the profit margin does not significantly affect the standard deviation of consumers’ order sizes (purchase amounts) but increases the average order size; whereas, (ii) variations in a positive finite free-shipping threshold affect both the average value and the standard deviation of the order sizes. We then use Arena to simulate the online retailing system and OptQuest to find the retailer’s optimal decisions and maximum profit. Next, we perform a sensitivity analysis to examine the impact of the ratio of the unit holding and salvage cost to the unit shipping cost on the retailer’s optimal decisions. We also draw some important managerial insights.
Original languageEnglish
Pages (from-to)272-283
Number of pages12
JournalEuropean Journal of Operational Research
Volume230
Issue number2
Early online date17 Apr 2013
DOIs
Publication statusPublished - 16 Oct 2013

Fingerprint

Freight transportation
Pricing
Profit
Profitability
Margin
Standard deviation
Costs
Simulation
Retailing
Salvaging
Unit
Online systems
Decision problem
Sensitivity analysis
Sensitivity Analysis
Statistics
Shipping
Retailers
Order size
Profit margin

Bibliographical note

Research supported by the Research and Postgraduate Studies Committee of Lingnan University under Research Project No. DR09A3.

Keywords

  • Profit margin
  • Contingent free-shipping
  • Inventory
  • Simulation with Arena
  • Optimization with OptQuest
  • Sensitivity analysis

Cite this

@article{0da64bafc7164061b94e8154b09b9927,
title = "Online retailers’ promotional pricing, free-shipping threshold, and inventory decisions : a simulation-based analysis",
abstract = "We consider a two-stage decision problem, in which an online retailer first makes optimal decisions on his profit margin and free-shipping threshold, and then determines his inventory level. We start by developing the retailer’s expected profit function. Then, we use publicly-available statistics to find the best-fitting distribution for consumers’ purchase amounts and the best-fitting function for conversion rate (i.e., probability that an arriving visitor places an online order with the retailer). We show that: (i) a reduction of the profit margin does not significantly affect the standard deviation of consumers’ order sizes (purchase amounts) but increases the average order size; whereas, (ii) variations in a positive finite free-shipping threshold affect both the average value and the standard deviation of the order sizes. We then use Arena to simulate the online retailing system and OptQuest to find the retailer’s optimal decisions and maximum profit. Next, we perform a sensitivity analysis to examine the impact of the ratio of the unit holding and salvage cost to the unit shipping cost on the retailer’s optimal decisions. We also draw some important managerial insights.",
keywords = "Profit margin, Contingent free-shipping, Inventory, Simulation with Arena, Optimization with OptQuest, Sensitivity analysis",
author = "Rafael BECERRIL-ARREOLA and Mingming LENG and Mahmut PARLAR",
note = "Research supported by the Research and Postgraduate Studies Committee of Lingnan University under Research Project No. DR09A3.",
year = "2013",
month = "10",
day = "16",
doi = "10.1016/j.ejor.2013.04.006",
language = "English",
volume = "230",
pages = "272--283",
journal = "European Journal of Operational Research",
issn = "0377-2217",
publisher = "Elsevier",
number = "2",

}

Online retailers’ promotional pricing, free-shipping threshold, and inventory decisions : a simulation-based analysis. / BECERRIL-ARREOLA, Rafael; LENG, Mingming; PARLAR, Mahmut.

In: European Journal of Operational Research, Vol. 230, No. 2, 16.10.2013, p. 272-283.

Research output: Journal PublicationsJournal Article (refereed)

TY - JOUR

T1 - Online retailers’ promotional pricing, free-shipping threshold, and inventory decisions : a simulation-based analysis

AU - BECERRIL-ARREOLA, Rafael

AU - LENG, Mingming

AU - PARLAR, Mahmut

N1 - Research supported by the Research and Postgraduate Studies Committee of Lingnan University under Research Project No. DR09A3.

PY - 2013/10/16

Y1 - 2013/10/16

N2 - We consider a two-stage decision problem, in which an online retailer first makes optimal decisions on his profit margin and free-shipping threshold, and then determines his inventory level. We start by developing the retailer’s expected profit function. Then, we use publicly-available statistics to find the best-fitting distribution for consumers’ purchase amounts and the best-fitting function for conversion rate (i.e., probability that an arriving visitor places an online order with the retailer). We show that: (i) a reduction of the profit margin does not significantly affect the standard deviation of consumers’ order sizes (purchase amounts) but increases the average order size; whereas, (ii) variations in a positive finite free-shipping threshold affect both the average value and the standard deviation of the order sizes. We then use Arena to simulate the online retailing system and OptQuest to find the retailer’s optimal decisions and maximum profit. Next, we perform a sensitivity analysis to examine the impact of the ratio of the unit holding and salvage cost to the unit shipping cost on the retailer’s optimal decisions. We also draw some important managerial insights.

AB - We consider a two-stage decision problem, in which an online retailer first makes optimal decisions on his profit margin and free-shipping threshold, and then determines his inventory level. We start by developing the retailer’s expected profit function. Then, we use publicly-available statistics to find the best-fitting distribution for consumers’ purchase amounts and the best-fitting function for conversion rate (i.e., probability that an arriving visitor places an online order with the retailer). We show that: (i) a reduction of the profit margin does not significantly affect the standard deviation of consumers’ order sizes (purchase amounts) but increases the average order size; whereas, (ii) variations in a positive finite free-shipping threshold affect both the average value and the standard deviation of the order sizes. We then use Arena to simulate the online retailing system and OptQuest to find the retailer’s optimal decisions and maximum profit. Next, we perform a sensitivity analysis to examine the impact of the ratio of the unit holding and salvage cost to the unit shipping cost on the retailer’s optimal decisions. We also draw some important managerial insights.

KW - Profit margin

KW - Contingent free-shipping

KW - Inventory

KW - Simulation with Arena

KW - Optimization with OptQuest

KW - Sensitivity analysis

UR - http://commons.ln.edu.hk/sw_master/1606

UR - https://www.scopus.com/inward/record.uri?eid=2-s2.0-84878904906&doi=10.1016%2fj.ejor.2013.04.006&partnerID=40&md5=438ffbb9b02c77c6d5a0c42c3980065c

U2 - 10.1016/j.ejor.2013.04.006

DO - 10.1016/j.ejor.2013.04.006

M3 - Journal Article (refereed)

VL - 230

SP - 272

EP - 283

JO - European Journal of Operational Research

JF - European Journal of Operational Research

SN - 0377-2217

IS - 2

ER -