NivaarExam PrepOfficial exam papers ↗

23-Ind-A1 Operations Research · December 2017

Question 1 of 9: EOQ — Special-Storage Inventory Item

Nivaar worked solution (AI-drafted; not reviewed by a licensed engineer)

Notes on this paper

National Exams — December 2017 — 98-Ind-A1 Operations Research. Three-hour, open-book exam (any non-communicating calculator permitted); the paper totals 180 marks across 9 questions (each worth 20) and only 100 marks are required, so a candidate would normally answer 5 — all nine are solved below for completeness.

Reference texts: Hillier & Lieberman, Introduction to Operations Research (11th ed., McGraw-Hill) — linear programming formulation & the simplex method (ch. 3–4), duality & sensitivity analysis (ch. 6), network optimization models (ch. 9), deterministic dynamic programming (ch. 11), integer programming (ch. 12), Markov chains (ch. 16), decision analysis (ch. 15), queueing theory (ch. 17); Nahmias, Production and Operations Analysis (7th ed.) — EOQ with and without planned shortages, the newsvendor (single-period) model (ch. 4–5).

Question 1: EOQ — Special-Storage Inventory Item (20 marks)

Question text not reproduced: the examination questions are © Engineers and Geoscientists BC. Open the official past paper (linked at the top of this page) to read the question, then follow the worked solution below.

Given. Annual demand $D=40{,}000$ units/yr; ordering cost $K=\$16.00$ per order; holding (storage) cost $h=\$2.00$ per unit-year. Part (b) additionally allows planned shortages at a backorder cost $p=\$4.00$ per unit-year.

Find. (a) $TC(Q)$ and the optimal order quantity $Q^*$ with no shortages. (b) $TC(Q,s)$ and the optimal $(Q^*,s^*)$ when shortages (backorders) are allowed.

time inv. Q−s = 653.2 (max on-hand) 0 ↓ s = 326.6 (peak backorders) one cycle, length T = Q*/D
Saw-tooth inventory position for the planned-shortage policy of part (b): stock rises to $Q^*-s^*=653.2$ at each delivery, falls linearly to $0$, then continues into a backorder pit down to $-s^*=-326.6$ before the next delivery clears it. Part (a) is the same picture with the pit removed ($s=0$).

Approach. Build the classic EOQ average-annual-cost expression (ordering + holding, and + backorder in part b) as a function of the decision variable(s), then set the partial derivative(s) to zero to find the optimum.

  1. Part (a) — total-cost expression, no shortages. One cycle of length $T=Q/D$ has one order (cost $K$) and average on-hand inventory $Q/2$ (holding cost $hQ/2$ per year). Annualizing the per-cycle order cost by dividing by $T$: $$TC(Q)=\frac{KD}{Q}+\frac{hQ}{2}$$
  2. Part (a) — optimize. $\dfrac{d(TC)}{dQ}=-\dfrac{KD}{Q^2}+\dfrac{h}{2}=0 \Rightarrow Q^{*2}=\dfrac{2KD}{h}$: $$Q^*=\sqrt{\frac{2KD}{h}}=\sqrt{\frac{2(16)(40{,}000)}{2}}=\sqrt{640{,}000}$$ $$\boxed{Q^*_{(a)}=800\text{ units per order}}$$ Substituting back, $TC(Q^*)=\sqrt{2KDh}=\sqrt{2(16)(40{,}000)(2)}=\$1{,}600.00$ per year.
  3. Part (b) — total-cost expression with planned shortages. With a maximum shortage (backorder) level $s$, the on-hand stock peaks at $Q-s$ and averages $(Q-s)^2/(2Q)$ over the cycle, while the backorder level averages $s^2/(2Q)$ (each derived from the two similar triangles of the saw-tooth): $$TC(Q,s)=\frac{KD}{Q}+\frac{h(Q-s)^2}{2Q}+\frac{p\,s^2}{2Q}$$
  4. Part (b) — optimize. Setting $\partial(TC)/\partial Q=0$ and $\partial(TC)/\partial s=0$ and solving the pair simultaneously gives the standard planned-shortage EOQ result: $$Q^*=\sqrt{\frac{2KD}{h}\cdot\frac{h+p}{p}}=\sqrt{\frac{2(16)(40{,}000)}{2}\cdot\frac{2+4}{4}}=\sqrt{640{,}000\times1.5}$$ $$\boxed{Q^*_{(b)}=979.80\text{ units},\qquad s^*=Q^*\frac{h}{h+p}=979.80\times\frac{2}{6}=326.60\text{ units}}$$ The corresponding maximum on-hand stock is $Q^*-s^*=653.20$ units and the minimum annual cost is $TC^*=\sqrt{2KDh\,p/(h+p)}=\$1{,}306.39$, lower than part (a)'s $\$1{,}600.00$ because permitting backorders trades a controlled, cheaper shortage cost for less holding cost.
Final results — Question 1
ItemValue
(a) $TC(Q)$$KD/Q+hQ/2$
(a) $Q^*$800 units
(a) $TC(Q^*)$$1,600.00/yr
(b) $TC(Q,s)$$KD/Q+h(Q-s)^2/(2Q)+ps^2/(2Q)$
(b) $Q^*$979.80 units
(b) $s^*$ (max shortage)326.60 units
(b) $TC(Q^*,s^*)$$1,306.39/yr
← Paper overview