Finance:Newsvendor model

From HandWiki
Short description: Mathematical model to assist inventory levels

The newsvendor (or newsboy or single-period[1] or salvageable) model is a mathematical model in operations management and applied economics used to determine optimal inventory levels. It is (typically) characterized by fixed prices and uncertain demand for a perishable product. If the inventory level is [math]\displaystyle{ q }[/math], each unit of demand above [math]\displaystyle{ q }[/math] is lost in potential sales. This model is also known as the newsvendor problem or newsboy problem by analogy with the situation faced by a newspaper vendor who must decide how many copies of the day's paper to stock in the face of uncertain demand and knowing that unsold copies will be worthless at the end of the day.

History

1902 sketch of a man buying from a newsboy in New York

The mathematical problem appears to date from 1888[2] where Edgeworth used the central limit theorem to determine the optimal cash reserves to satisfy random withdrawals from depositors.[3] According to Chen, Cheng, Choi and Wang (2016), the term "newsboy" was first mentioned in an example of the Morse and Kimball (1951)'s book.[4] The modern formulation relates to a paper in Econometrica by Kenneth Arrow, T. Harris, and Jacob Marshak.[5]

More recent research on the classic newsvendor problem in particular focused on behavioral aspects: when trying to solve the problem in messy real-world contexts, to what extent do decision makers systematically vary from the optimum? Experimental and empirical research has shown that decision makers tend to be biased towards ordering too close to the expected demand (pull-to-center effect[6]) and too close to the realisation from the previous period (demand chasing[7]).

Overview

This model can also be applied to period review systems.[8]

Assumptions

  1. Products are separable
  2. Planning is done for a single period
  3. Demand is random
  4. Deliveries are made in advance of demand
  5. Costs of overage or underage are linear

Profit function and the critical fractile formula

The standard newsvendor profit function is

[math]\displaystyle{ \operatorname{E}[\text{profit}]=\operatorname{E}\left[p\min (q,D)\right]-cq }[/math]

where [math]\displaystyle{ D }[/math] is a random variable with probability distribution [math]\displaystyle{ F }[/math] representing demand, each unit is sold for price [math]\displaystyle{ p }[/math] and purchased for price [math]\displaystyle{ c }[/math], [math]\displaystyle{ q }[/math] is the number of units stocked, and [math]\displaystyle{ E }[/math] is the expectation operator. The solution to the optimal stocking quantity of the newsvendor which maximizes expected profit is:

Critical fractile formula

[math]\displaystyle{ q=F^{-1}\left( \frac{p-c}{p}\right) }[/math]

where [math]\displaystyle{ F^{-1} }[/math] denotes the generalized inverse cumulative distribution function of [math]\displaystyle{ D }[/math].

Intuitively, this ratio, referred to as the critical fractile, balances the cost of being understocked (a lost sale worth [math]\displaystyle{ (p-c) }[/math]) and the total costs of being either overstocked or understocked (where the cost of being overstocked is the inventory cost, or [math]\displaystyle{ c }[/math] so total cost is simply [math]\displaystyle{ p }[/math]).

The critical fractile formula is known as Littlewood's rule in the yield management literature.

Numerical examples

In the following cases, assume that the retail price, [math]\displaystyle{ p }[/math], is $7 per unit and the purchase price is [math]\displaystyle{ c }[/math], is $5 per unit. This gives a critical fractile of [math]\displaystyle{ \frac{p-c}{p} = \frac{7-5}{7} = \frac{2}{7} }[/math]

Uniform distribution

Let demand, [math]\displaystyle{ D }[/math], follow a uniform distribution (continuous) between [math]\displaystyle{ D_\min = 50 }[/math] and [math]\displaystyle{ D_\max = 80 }[/math].

[math]\displaystyle{ q_\text{opt}=F^{-1}\left( \frac{7-5}{7}\right)=F^{-1}\left( 0.285 \right) = D_\min+(D_\max-D_\min) \cdot 0.285 = 58.55\approx59. }[/math]

Therefore, the optimal inventory level is approximately 59 units.

Normal distribution

Let demand, [math]\displaystyle{ D }[/math], follow a normal distribution with a mean, [math]\displaystyle{ \mu }[/math], demand of 50 and a standard deviation, [math]\displaystyle{ \sigma }[/math], of 20.

[math]\displaystyle{ q_\text{opt}=F^{-1}\left( \frac{7-5}{7}\right)=\mu + \sigma Z^{-1}\left( 0.285 \right) = 50 + 20 (-0.56595) = 38.68\approx 39. }[/math]

Therefore, optimal inventory level is approximately 39 units.

Lognormal distribution

Let demand, [math]\displaystyle{ D }[/math], follow a lognormal distribution with a mean demand of 50, [math]\displaystyle{ \mu }[/math], and a standard deviation, [math]\displaystyle{ \sigma }[/math], of 0.2.

[math]\displaystyle{ q_\text{opt}=F^{-1}\left(\frac{7-5}{7}\right)=\mu e^{Z^{-1}\left(0.285\right) \sigma} = 50 e^{\left(0.2 \cdot (-0.56595) \right)} = 44.64\approx 45. }[/math]

Therefore, optimal inventory level is approximately 45 units.

Extreme situation

If [math]\displaystyle{ p\lt c }[/math] (i.e. the retail price is less than the purchase price), the numerator becomes negative. In this situation, the optimal purchase quantity is zero since due to a marginal loss.

Derivation of optimal inventory level

Critical fractile formula

To derive the critical fractile formula, start with [math]\displaystyle{ \operatorname{E}\left[{\min\{q,D\}}\right] }[/math] and condition on the event [math]\displaystyle{ D\leq q }[/math]:

[math]\displaystyle{ \begin{align} & \operatorname{E}[\min\{q,D\}]=\operatorname{E}[\min\{q,D\}\mid D\leq q]\operatorname{P}(D\leq q)+\operatorname{E}[\min\{q,D\}\mid D\gt q]\operatorname{P}(D\gt q) \\[6pt] = {} & \operatorname{E}[D\mid D\leq q]F(q)+\operatorname{E}[q\mid D\gt q][1-F(q)] =\operatorname{E}[D\mid D\leq q]F(q)+q[1-F(q)] \end{align} }[/math]

Now use

[math]\displaystyle{ \operatorname{E}[D\mid D\leq q]=\frac{\int\limits_{x\leq q} xf(x) \, dx}{\int\limits_{x\leq q} f(x) \, dx}, }[/math]

where [math]\displaystyle{ f(x)=F'(x) }[/math]. The denominator of this expression is [math]\displaystyle{ F(q) }[/math], so now we can write:

[math]\displaystyle{ \operatorname{E}[\min\{q,D\}]=\int\limits_{x \leq q}xf(x)\,dx+q[1-F(q)] }[/math]

So [math]\displaystyle{ \operatorname{E}[\text{profit}]=p\int\limits_{x\leq q} xf(x) \, dx + pq[1-F(q)]-cq }[/math]

Take the derivative with respect to [math]\displaystyle{ q }[/math]:

[math]\displaystyle{ \frac{\partial}{\partial q}\operatorname{E}[\text{profit}]=pqf(q)+pq(-F'(q))+p[1-F(q)]-c=p[1-F(q)]-c }[/math]

Now optimize: [math]\displaystyle{ p\left[1-F(q^*)\right]-c=0\Rightarrow1-F(q^*)=\frac{c}{p}\Rightarrow F(q^*)=\frac{p-c}{p}\Rightarrow q^*=F^{-1}\left(\frac{p-c}{p}\right) }[/math]

Technically, we should also check for convexity: [math]\displaystyle{ \frac{\partial^2}{\partial q^2}\operatorname{E}[\text{profit}]=p[-F'(q)] }[/math]

Since [math]\displaystyle{ F }[/math] is monotone non-decreasing, this second derivative is always non-positive, so the critical point determined above is a global maximum.

Alternative formulation

The problem above is cast as one of maximizing profit, although it can be cast slightly differently, with the same result. If the demand D exceeds the provided quantity q, then an opportunity cost of [math]\displaystyle{ (D-q)(p-c) }[/math] represents lost revenue not realized because of a shortage of inventory. On the other hand, if [math]\displaystyle{ D\le q }[/math], then (because the items being sold are perishable), there is an overage cost of [math]\displaystyle{ (q-D)c }[/math]. This problem can also be posed as one of minimizing the expectation of the sum of the opportunity cost and the overage cost, keeping in mind that only one of these is ever incurred for any particular realization of [math]\displaystyle{ D }[/math]. The derivation of this is as follows:

[math]\displaystyle{ \begin{align} & \operatorname{E}[\text{opportunity cost}+\text{overage cost}] \\[6pt] = {} & \operatorname{E}[\text{overage cost}\mid D\leq q]\operatorname{P}(D\leq q)+\operatorname{E}[\text{opportunity cost}\mid D\gt q] \operatorname{P}(D\gt q) \\[6pt] = {} & \operatorname{E}[(q-D)c\mid D\leq q]F(q)+\operatorname{E}[(D-q)(p-c)\mid D\gt q][1-F(q)] \\[6pt] = {} & c\operatorname{E}[q-D\mid D\leq q]F(q)+(p-c)\operatorname{E}[D-q\mid D\gt q][1-F(q)] \\[6pt] = {} & cqF(q)-c\int\limits_{x\leq q} xf(x)\,dx+(p-c)[\int\limits_{x\gt q}xf(x)\,dx-q(1-F(q))] \\[6pt] = {} & p\int\limits_{x\gt q} xf(x)\,dx-pq(1-F(q))-c\int\limits_{x\gt q}xf(x)\,dx+cq(1-F(q))+cqF(q)-c\int\limits_{x\le q}xf(x)\,dx \\[6pt] = {} & p\int\limits_{x\gt q}xf(x)\,dx-pq+pqF(q)+cq-c\operatorname{E}[D] \end{align} }[/math]

The derivative of this expression, with respect to [math]\displaystyle{ q }[/math], is

[math]\displaystyle{ \frac{\partial}{\partial q}\operatorname{E}[\text{opportunity cost}+\text{overage cost}]=p(-qf(q))-p+pqF'(q)+pF(q)+c=pF(q)+c-p }[/math]

This is obviously the negative of the derivative arrived at above, and this is a minimization instead of a maximization formulation, so the critical point will be the same.

Cost based optimization of inventory level

Assume that the 'newsvendor' is in fact a small company that wants to produce goods to an uncertain market. In this more general situation the cost function of the newsvendor (company) can be formulated in the following manner:

[math]\displaystyle{ K(q) = c_f + c_v (q-x) + p \operatorname E\left[\max(D-q,0)\right] + h \operatorname E\left[\max(q-D,0) \right] }[/math]

where the individual parameters are the following:

  • [math]\displaystyle{ c_f }[/math] – fixed cost. This cost always exists when the production of a series is started. [$/production]
  • [math]\displaystyle{ c_v }[/math] – variable cost. This cost type expresses the production cost of one product. [$/product]
  • [math]\displaystyle{ q }[/math] – the product quantity in the inventory. The decision of the inventory control policy concerns the product quantity in the inventory after the product decision. This parameter includes the initial inventory as well. If nothing is produced, then this quantity is equal to the initial quantity, i.e. concerning the existing inventory.
  • [math]\displaystyle{ x }[/math] – initial inventory level. We assume that the supplier possesses [math]\displaystyle{ x }[/math] products in the inventory at the beginning of the demand of the delivery period.
  • [math]\displaystyle{ p }[/math] – penalty cost (or back order cost). If there is less raw material in the inventory than needed to satisfy the demands, this is the penalty cost of the unsatisfied orders. [$/product]
  • [math]\displaystyle{ D }[/math] – a random variable with cumulative distribution function [math]\displaystyle{ F }[/math] representing uncertain customer demand. [unit]
  • [math]\displaystyle{ E[D] }[/math] – expected value of random variable [math]\displaystyle{ D }[/math].
  • [math]\displaystyle{ h }[/math] – inventory and stock holding cost. [$ / product]

In [math]\displaystyle{ K(q) }[/math], the first order loss function [math]\displaystyle{ E\left[\max(D-q,0)\right] }[/math] captures the expected shortage quantity; its complement, [math]\displaystyle{ E\left[\max(q-D,0)\right] }[/math], denotes the expected product quantity in stock at the end of the period.[9]

On the basis of this cost function the determination of the optimal inventory level is a minimization problem. So in the long run the amount of cost-optimal end-product can be calculated on the basis of the following relation:[1]

[math]\displaystyle{ q_\text{opt} = F^{-1}\left( \frac{p-c_v}{p+h}\right) }[/math]

See also

References

  1. 1.0 1.1 William J. Stevenson, Operations Management. 10th edition, 2009; page 581
  2. F. Y. Edgeworth (1888). "The Mathematical Theory of Banking". Journal of the Royal Statistical Society 51 (1): 113–127. 
  3. Guillermo Gallego (18 Jan 2005). "IEOR 4000 Production Management Lecture 7". Columbia University. http://www.columbia.edu/~gmg2/4000/pdf/lect_07.pdf. 
  4. R. R. Chen; T.C.E. Cheng; T.M. Choi; Y. Wang (2016). "Novel Advances in Applications of the Newsvendor Model". Decision Sciences 47: 8–10. doi:10.1111/deci.12215. 
  5. K. J. Arrow, T. Harris, Jacob Marshak, Optimal Inventory Policy, Econometrica 1951
  6. Schweitzer, M.E.; Cachon, G.P. (2000). "Decision bias in the newsvendor problem with a known demand distribution: Experimental evidence". Management Science 43 (3): 404–420. doi:10.1287/mnsc.46.3.404.12070. 
  7. Lau, N.; Bearden, J.N. (2013). "Newsvendor demand chasing revisited". Management Science 59 (5): 1245–1249. doi:10.1287/mnsc.1120.1617. 
  8. W.H. Hopp, M. L. Spearman, Factory Physics, Waveland Press 2008
  9. Axsäter, Sven (2015). Inventory Control (3rd ed.). Springer International Publishing. ISBN 978-3-319-15729-0. 

Further reading