Modeling and Analysis of Manufacturing and Service Enterprises Why Manage Inventory? n n Inventory Management Introduction and EOQ n n n n Total $ investment in inventories is $1.37 trillion (last quarter of 1999) 34% in Manufacturing 82% of the total 26% in Retail 22% in Wholesale 8% in Farm 10% in Other Sources: plants vendors ports Why Manage Inventory? n n Total investment in inventory is 20-25% of the total annual GNP. What would happen if you control inventories and achieve 1% improvement overall? n You can improve the efficiency of the overall economy Regional Warehouses: stocking points Field Warehouses: stocking points Customers, demand centers sinks Supply Inventory & warehousing costs Production/ purchase costs Transportation costs Inventory & warehousing costs Transportation costs 1 Inventory n Where do we hold inventory? n n n n Types of Inventory n n n n suppliers and manufacturers warehouses and distribution centers retailers WIP and subassemblies raw materials finished goods Why do we hold inventory? (Short answer) n n Economies of scale Uncertainty in supply and demand Decisions to Make n We have to decide n n n How often we review the inventory When we should issue a (replenishment/production) order How large the order should be Why do we hold inventory? n n n n n n n Economies of scale Uncertainty in supply and demand Speculation Transportation Smoothing production/purchasing Logistics Cost of controlling inventory A Classification of Inventory n Functional categories of inventories n n n n n n Cycle stock Congestion stock Safety stock Anticipation inventory Pipeline (or work-in-process) inventory Decoupling stock 2 ABC classification n n Observe that 20% of the stocked parts make up 80% of the total inventory investment Focus on the “important” parts that have significant effect on the bottom line ABC classification Cont. n A items: n n B items n n n Demand n n n n Constant (level) or variable Deterministic (known) or Stochastic (random or uncertain) Lead Time Review Time n Continuous or periodic review n Excess Demand n Changing inventory n Next 50% of the products (around remaining 45-50% of total investment) C items n Characteristics of Inv. Systems Usually First 5 to 10% of the products (around 50% of the total investment) Many, but low value Relevant Costs n Unit value or unit variable cost (v) n Cost of making a part available for usage n n n Purchase + Freight + Mfg. Costs Usually different from “accounting” cost Should include more than just book value Backordered or lost 3 Relevant Costs n Relevant Costs Holding cost (cost of carrying in inv.) n n n n Opportunity costs of the money tied to inv. Warehousing and Handling (cost of providing space to store items, counting and moving items in the WH) Deterioration, damage, obsolescence Insurance and taxes Relevant Costs n Holding cost (cont’d) n n n n h = ic Total annual holding cost = Ih =Iic Relevant Costs n Inv. Ordering or Setup Cost (A) n Avg. inv. level Dec Time, t Fixed cost n n Jan i: total annual interest charge (or carrying charge) h: holding cost, $ per item per year Independent of the size of the replenishment or production order Ordering forms, phone calls, other communication costs, receiving, inspection, cost of interrupted production, opportunity cost of lost time, etc. 4 EOQ Model n Book Store Mug Sales n n n n n EOQ Model: Assumptions D Demand is constant, at 20 units a week Fixed order cost of $12.00, no lead time Holding cost of 25% of inventory value annually A Mugs cost $1.00, sell for $5.00 Question n How many, when to order? Q T? i c EOQ Model Inventory n Production is instantaneous n Delivery is immediate n Demand is deterministic n Demand is constant over time n A production run incurs a fixed setup cost n Products can be analyzed singly n No shortages are allowed n Anything else? EOQ Model Note: • No Stockouts • Order when no inventory • Order size determines policy n n n Time unit: A year Purchase Cost Constant Annual Holding Cost: n Order Quantity Q n Annual Ordering (Setup) Cost: n Goal: n Avg. Inventory (Avg. Inventory) * (Holding Cost) Number of Orders in a year * Order Cost Find the order quantity that minimizes total costs 5 n n n n n Average Inventory: Q/2 Annual holding costs: Qh/2 Time between replenishments: Q/D Number of replenishments per year: D/Q Replenishment costs: n n EOQ Model 160 140 120 Cost EOQ Model Total Cost 100 Holding Cost 80 60 Order Cost 40 (A+Qh)D/Q=AD/Q + Dc 20 Total Relevant Costs: TRC(Q)=AD/Q+Qh/2 0 0 500 Optimal Order Quantity, Q* EOQ Model EOQ Model nTotal n Relevant Costs: TRC(Q)=AD/Q+Qh/2 dTRC (Q ) h A = − =0 dQ 2D Q 2 n n n 2 AD EOQ = Q * = h n n 1000 1500 Order Quantity Optimal Quantity (EOQ) = (2*Setup Cost*Demand)/holding cost = SQRT(2AD/h) What is the EOQ for our problem? The corresponding time between orders? What is the number of months of demand that EOQ will satisfy, T(EOQ)? Annual relevant cost, TRC(EOQ)? The corresponding Inv. Turnover Ratio? 6 EOQ Model n n EOQ Model: Sensitivity Tradeoff between set-up costs and holding costs when determining order quantity. In fact, we order so that these costs are equal per unit time Total Cost is not particularly sensitive to Q=1.10EOQ the optimal order quantity Order Quantity 50% Cost Increase 80% 90% 100% 110% 120% 150% 200% n TRC( Q′) = n n TRC(Q)=1.0045*TRC(EOQ) n n Batching causes inventory (i.e., larger lot sizes translate into more stock). Under specific modeling assumptions the lot size that optimally balances holding and setup costs is given by the square root formula: Q* = n 2 AD h Total cost is relatively insensitive to lot size (so rounding for other reasons, like coordinating shipping, may be attractive). hQ′ AD + 2 Q′ Compare it to EOQ Costs: TRC( Q′ ) h Q′ 2 + AD Q′ 1 Q′ Q* = = *+ TRC(Q *) 2 Q Q′ 2 ADh 125% 103% 101% 100% 101% 102% 108% 125% EOQ Observations Total Relevant Cost for Q’ Example: If Q ' = 2Q*, then the ratio of the actual to optimal cost is (1/2)[2 + (1/2)] = 1.25 EOQ Extensions n Finite Replenishment/Production Rate: n n n n n n Economic Production Lot (EPL) or Economic Production Quantity (EPQ) Nonzero constant lead time Quantity Discounts Considering Inflation Limits on Order Size Exchange Curves 7 Economic Production Lot (EPL) n What happens when there is finite production rate? n n n P: production rate (in units per year) P>D (demand rate per year). Why? What happens if you keep producing? n The inventory will keep growing forever with a rate of P-D. EPL EPL n n n n EPL Slope=P-D Inv n Slope=-D n T1 Stop Prod. T2 Production time = T1 n n H Start Prod. When do we stop production: T1 T1 also determines our production lot size or run size, Q. Until the next production run, we satisfy demand from the inventory that we built during T1. Total cycle: T=T1+T2 Time Q=PxT1 or T1=Q/P Demand during production time that uses up inventory: DxT1 = DxQ/P The inventory we built up (H) is the leftover inventory during production: n H = Q - DxT1 = Q (1-D/P) Start Prod. 8 EPL n Annual Total Relevant Cost for EPL: n n n TRC(EOQ) = AD/Q + hQ/2 Rename h(1-D/P) as adj. holding cost, h’, and find the optimal order quantity (lot size): EPL = Q* = 2 AD = h' 2 AD h(1 − D / P ) Nonzero Order Lead Times n n n n TRC(EPL) = AD/Q + hH/2 or TRC(EPL) = AD/Q + h(1-D/P)Q/2 Compare this to TRC(EOQ): n n EPL Recall EOQ’s assumption: zero lead time What would you do if you have nonzero lead time, i.e., it takes some time for your orders to arrive, shipping and handling, etc? Say, the lead time in our bookstore mug example is 1 month. What would you do differently? H should be enough to cover the demand during T2: n n n n H = DxT2 or T2=H/D Overall production cycle: T=T1+T2 Total demand during cycle, T: DxT Check if production lot is enough to cover this demand: Q=DxT? EOQ with Positive Lead Times Inv Q*=316 LT=1mo Reorder Point=? T=3.8 mo Time Place Order Order arrives 9 Quantity Discounts n EOQ’s assumption: v is constant What would you do if the cost of the part depends on the order quantity? n One easy case to analyze: n n n Quantity Discounts Slope=c0 Ordering Cost Price discounts if you order more all-units discount Qb Breakpoint quantity Quantity Discounts n n n Slope=c0 (1- d) If you order less than Qb, then the unit cost is c0 If you order more, then it is c0(1-d) When you calculate total relevant costs, include variable order cost (or purchase cost), Dc 0 or Dc 0(1-d). Q, Order Quantity Quantity Discounts n n n Calculate EOQ w/o discount: EOQ using c0 for c Calculate EOQ w/ discount: EOQ(d) using c0(1-d) for c Three cases: n n n 1. If EOQ(d)>=Q b, then Q*=EOQ(d) 2. If TRC(EOQ)<TRC(Q b), order EOQ 3. Otherwise [TRC(EOQ)>TRC(Q b)], order Q b. 10 Quantity Discounts Case 2 Case 1 EOQ with Inflation Case 3 n n n Qb Q* Q* Q b Example: n n Q* = Q*=Q b EOQ with Inflation n Inflation rate: r Calculate the present value of costs that are occurring over time EOQ w/ inflation: How many mugs should the bookstore order if the annual inflation rate is 5%? Compare it with EOQ w/o inflation. 2 AD 1 = EOQ v(i − r) 1− r / i Limits on Order Sizes n n n Sometimes EOQ leads to a really large order quantity and in turn long time supply (time between orders). If EOQ is greater than what you can store, order/produce less, Q*=C when EOQ>C If Time Supply (order interval or cycle) is longer than the allowed shelf life (SL), then you may want to order less: n n Q*(SL)=DxSL when T(EOQ)>SL Uncertainty into the future 11 EOQ Trade-off n Two interpretations: n n n Aggregate Considerations n If you order more (larger Q), you incur higher inventory cost, but less setup cost If you order less frequently, you incur larger inventory cost, but less setup cost Instead of determining A and i, n n n The trade-off is not linear! n Aggregate Considerations n Two major assumptions n n n n Assume that fixed setup cost for each item cannot be determined explicitly Assume a common value A holds (approx.) for all items The number of items: n Define Dj, Qj, and c j for item j Average total inventory cannot exceed a certain dollar value or volume Number of replenishments in a year must be less than certain value The maximum allowed backorder delay may not exceed a certain value Trade-off btw avg. inv. and cost (or the number) of replenishments in a year should be at certain prescribed value Aggregate Considerations n Total Avg. Cycle Stock (in $): n TACS = ∑ Q j c j / 2 j =1 n Total number of replenishments: N = ∑ D /Q Use EOQ for each item n j j j =1 n Qj = * 2 AD j c ji 12 Aggregate Considerations Put Qj * into TACS and N: n n ADj c j j =1 2i TACS = ∑ = A n ∑ Djc j 2i j =1 n N =∑ j =1 Resource Constrained Multiple Product Systems n Djc ji i n = ∑ Djc j 2A 2 A j =1 n n n Multiply TACS and N: TACS × N = n 1 n ∑ D j c j 2 j =1 n n Plot TACS versus N n Example: n D_j c_j A_j n n 2 1150 350 150 3 800 85 50 Limit on the maximum inventory investment: $30,000 n So Total Q jc j <= 30000 i=25% Procedure: n 1 1850 50 100 Budget Machines Personnel Space, etc. Resource Constrained Multiple Product Systems n 3 products Even if you have multiple items to worry, you can analyze them separately What happens if the items share capacitated resources? n 2 Resource Constrained Multiple Product Systems n Another EOQ assumption: n n Calculate regular EOQ value for each product If the constraint is satisfied with EOQ values, then use them. If using EOQ values violates the budget constraint, scale them down. n How? 13 Resource Constrained Multiple Product Systems n Example: n n n n n n n n Ratio = 30,000 / 35,835 = 0.8372 New order quantities: n 172x50 + 63x350 + 61x85 = $35,835 How do we reduce the order sizes? Multiply each EOQ value by the ratio (budget limit)/(needed budget) n n Needed budget: n n EOQ1 = 172 EOQ2 = 63 EOQ3 = 61 Resource Constrained Multiple Product Systems Q1* = 172x0.8372 = 144 Q2* = 63x0.8372 = 52 Q3* = 61x0.8372 = 51 Round them down! Resource Constrained Multiple Product Systems n A major assumption for the method to work: n n c1/h1 = c2/h 2 = … =cn /hn If you use same i for all items, this is automatically satisfied n Recall hj=cjij 14
© Copyright 2024