1 / 54

C 11 Inventory Management

C 11 Inventory Management. Pencils, papers, clips, advertisements-flyer, visiting cards, nuts, bolts, trucks, needles, airplanes Raw materials, semi-finished goods, finished goods What is the worth? Let top management see the money withheld . Inventory- a stock or store of goods.

lawson
Download Presentation

C 11 Inventory Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. C 11Inventory Management Pencils, papers, clips, advertisements-flyer, visiting cards, nuts, bolts, trucks, needles, airplanes Raw materials, semi-finished goods, finished goods What is the worth? Let top management see the money withheld 

  2. Inventory- a stock or store of goods Independent Demand A Dependent Demand B(4) C(2) D(2) E(1) D(3) F(2) Independent demand is uncertain. Dependent demand is certain.

  3. Inventory Models

  4. Raw materials & purchased parts Partially completed goods called work in progress Finished-goods inventories manufacturing firms retail stores (merchandise ) Replacement parts, tools, & supplies Goods-in-transit to warehouses or customers Types of Inventories

  5. To meet anticipated demand Anticipation stock To smooth production requirements Seasonal demand (e.g. Potato case!) To decouple operations Buffer for continuous operation To protect against stock-outs Delayed delivery, abrupt demand Safety stocks Functions of Inventory

  6. To take advantage of order cycles Purchasing, Producing in Batches (Lots) Cycle stock for periodic To help hedge against price increases Oil price To permit operations Intermediate Stocks (WIP) Pipeline inventory To take advantage of quantity discounts Functions of Inventory …

  7. To achieve satisfactory levels of customer service while keeping inventory costs within reasonable bounds Level of customer service Costs of ordering and carrying inventory Inventory turnover Ratio of average cost of goods sold to average inventory investment. Days of inventory on hand Objective of Inventory Control

  8. A system to keep track of inventory (and S.O.) A reliable forecast of demand Knowledge of lead times (and variability) Reasonable estimates of Holding costs Ordering costs Shortage costs A classification system Effective Inventory Management

  9. Periodic System Physical count of items made at periodic intervals Small Retailers- checks and orders replenishment Perpetual Inventory System Keeps track of removals from inventory continuously, thus monitoring current levels of each item Reorder point Q Also requires periodic counting Errors, pilferage, spoliage Inventory Counting Systems Cost?

  10. Inventory Counting Systems … • Two-Bin System - Two containers of inventory; reorder when the first is empty • 2nd cart has enough inventory for the lead time • Order card • Universal Bar Code - Bar code printed on a label that has information about the item to which it is attached

  11. Lead time: time interval between ordering and receiving the order Holding (carrying) costs: cost to carry an item in inventory for a length of time, usually a year Ordering costs: costs of ordering and receiving inventory Shortage costs: costs when demand exceeds supply Key Inventory Terms

  12. The Inventory Cycle- Figure 12.2Profile of Inventory Level Over Time Q Usage rate Quantity on hand Reorder point Time Place order Receive order Receive order Receive order Place order Lead time

  13. Classifying inventory according to some measure of importance and allocating control efforts accordingly. A - very important B - mod. important C - least important High A Annual $ value of items B C Low Low High Percentage of Items ABC Classification System Example 1- P 549

  14. A physical count of items in inventory Cycle counting management How much accuracy is needed? When should cycle counting be performed? Who should do it? Cycle Counting

  15. Economic order quantity (EOQ) model The order size that minimizes total annual cost Economic production model Quantity discount model Economic Order Quantity Models

  16. Q D S H + 2 Q Total Cost* Annual carrying cost Annual ordering cost Total cost* = + TC =

  17. Cost Minimization Goal- Figure 12.4C The Total-Cost Curve is U-Shaped Annual Cost Ordering Costs Order Quantity (Q) QO (optimal order quantity) Minimum Total Cost

  18. Using calculus, we take the derivative of the total cost function and set the derivative (slope) equal to zero and solve for Q. Minimum Total Cost The total cost curve reaches its minimum where the carrying and ordering costs are equal. Q D S H = 2 Q Deriving the EOQ

  19. Economic Production Quantity (EPQ) • Production done in batches or lots • Capacity to produce a part exceeds the part’s usage or demand rate • Similar to EOQ • Orders are received incrementally during production

  20. Economic Run Size We do not buy the product. We produce it. Total demand / year is D Demand / day or consumption rate is u Production rate is p / day

  21. Instantaneous Replenishment Incremental Replenishment

  22. EPQ: Incremental Replenishment(Production and Consumption) Demand / day or consumption rate is u Production rate is p / day p-u p u u × ( number of working days ) = D = Total demand per year

  23. EPQ: Ordering Cost and Carrying Cost State Imax in terms of Q!

  24. I max p-u u d2 d1 EPQ : Production & Consumption; rate & time How much do we produce each time? Q How long does it take to produce Q? d1 What is our production rate per day? p How long does it take to consume Q? d1 +d2 What is our consumption rate per day ? u

  25. Example- What is the optimal production size? • A toy manufacturer • Uses 48000 parts for one of its products. • Consumption rate is uniform throughout the year. • Working days are 240 / year. • The firm can produce at a rate of 800 parts / day • Carrying cost is $1 / part / year • Setup cost for production run is $45 / setup

  26. I max p-u u d2 d1 What is Run Time, What is Cycle Time Q0 using formula = 2400 u = 48000 /240 = 200 units/day

  27. What is the Optimal Total Cost

  28. EPQ : Optimal Q

  29. Reorder Point- ROP • Reorder Point • When the quantity on hand of an item drops to this amount, the item is reordered • If setup time takes 2 days, at which level of inventory we should start setup? • 2(200) = 400 • 200 ?

  30. Yet Another Example • A company has a yearly demand of 120,000 boxes of its product. The product can be produced at a rate of 2000 boxes per day. The shop operates 240 days per year. Assume that demand is uniform throughout the year. Setup cost is $8000 for a run, and holding cost is $10 per box per year. • a) What is the demand rate per day • b) What is the Economic Production Quantity (EPQ) • c) What is the run time • d) What is the maximum inventory • e) What is the total cost of the system

  31. Yet Another Example … • What is the demand rate per day • Demand per year is 120,000 there are 240 days per year • Demand per day = 120000/240 = 500 • u = D/240 = 500 • b) What is the Economic Production Quantity (EPQ) =16000

  32. Yet Another Example … • c) What is the run time • We produce 16000 units • Our production rate is 2000 per day • It takes 16000/2000 = 8 days • d1 = EPQ/p = 8 days • d) What is the maximum inventory • We produce for 8 days. Each day we produce 2000 units and we consume 500 units of it. Therefore we add to our inventory at rate of 1500 per day for 8 days. That is • Imax = 8(1500) = 12000 • Imax = pd1 = 8(1500) = 12000

  33. Yet Another Example … • e) What is the total cost of the system

  34. Including the Purchasing Cost Annual carrying cost Annual ordering cost Purchasing cost + TC = + Q D PD S H TC = + + 2 Q

  35. Total Costs with Vs. Quantity Ordered Cost Adding Purchasing costdoesn’t change EOQ TC with PD TC without PD PD 0 Quantity EOQ

  36. Total Cost with Constant Carrying Costs TCa TCb Total Cost Decreasing Price TCc CC a,b,c OC EOQ Quantity

  37. Total Cost with Variable Carrying Costs Do the Math Ex 5, 6

  38. ROP with EOQ Ordering When to Reorder • Safety Stock • Stock that is held in excess of expected demand due to variable demand rate and/or lead time. • Service Level • Probability that demand will not exceed supply during lead time.

  39. The rate of demand The lead time Demand and/or lead time variability Stockout risk (safety stock) Determinants of the Reorder Point

  40. Quantity Maximum probable demand during lead time Expected demand during lead time ROP Safety stock Time LT Safety Stock- Figure 12.12 Safety stock reduces risk of stockout during lead time

  41. Reorder Point- Figure 12.13 See also: Fig 11.14 The ROP based on a normal Distribution of lead time demand Service level Risk of a stockout Probability of no stockout Quantity ROP Expected demand Safety stock 0 z z-scale ROPs = Exp. Demand + z. σdLT

  42. Shortage and Service Level • Service level determines ROP • E(n) = E(z) z σdLT • E(n) = Expected number of short/cycle • E(z) = Standardized number of units-short from table 11.3 • σdLT= Standard deviation of lead time • Example 10 @ Page 568

  43. Orders are placed at fixed time intervals Order quantity for next interval? Suppliers might encourage fixed intervals May require only periodic checks of inventory levels Risk of stockout Fill rate – the percentage of demand filled by the stock on hand Fixed-Order-Interval Model

  44. Calculations Ex 13

  45. Fixed-Interval tradeoffs

  46. Single Period Model • Model for ordering items with limited useful lives • Perishables • Shortage cost is generally the unrealized profits per unit • Excess cost is the difference between purchase cost and salvage value of items left over at the end of a period

  47. Ce Cs Service Level Quantity So Balance point Cs Cs + Ce Service level = Optimal Stocking Level Cs = Shortage cost per unitCe = Excess cost per unit

  48. Ce = $0.20 per unit Cs = $0.60 per unit Service level = Cs/(Cs+Ce) = .6/(.6+.2) Service level = .75 Ce Cs Service Level = 75% Quantity Example 15 Stockout risk = 1.00 – 0.75 = 0.25

More Related