500 likes | 593 Views
B370 Operations Management. Group 1 Tutorial 8 C.S. Lai November 2012. Agenda. Q & A 15 mins. Inventory Control 75 mins. MRP 15 mins. Q & A 15 mins. Inventory System Defined.
E N D
B370 Operations Management Group 1 Tutorial 8 C.S. Lai November 2012 B370 Operations Management
Agenda Q & A 15 mins. Inventory Control 75 mins. MRP 15 mins. Q & A 15 mins. B370 Operations Management
Inventory SystemDefined • Inventory is the stock of any item or resource used in an organization. These items or resources can include: raw materials, finished products, component parts, supplies, and work-in-process. • An inventory system is the set of policies and controls that monitor levels of inventory and determines what levels should be maintained, when stock should be replenished, and how large orders should be. B370 Operations Management
Purposes of Inventory 1. To maintain independence of operations. 2. To meet variation in product demand. 3. To allow flexibility in production scheduling. 4. To provide a safeguard for variation in raw material delivery time. 5. To take advantage of economic purchase-order size. B370 Operations Management
Inventory Costs • Holding (or carrying) costs. • Costs for storage, handling, insurance, etc. • Setup (or production change) costs. • Costs for arranging specific equipment setups, etc. • Ordering costs. • Costs of someone placing an order, etc. • Shortage costs. • Costs of canceling an order, etc. B370 Operations Management
Independent vs. Dependent Demand Independent Demand (Demand not related to other items or the final end-product) Dependent Demand (Derived demand items for component parts, subassemblies, raw materials, etc.) E(1) B370 Operations Management
Classifying Inventory Models • Fixed-Order Quantity Models (Q-Model) • Event triggered (Example: running out of stock) • Fixed-Time Period Models (P-Model) • Time triggered (Example: Monthly sales call by sales representative) B370 Operations Management
Number of units on hand Q Q Q R L L Time R = Reorder point Q = Economic order quantity L = Lead time Basic Fixed-Order Quantity Model and Reorder Point Behavior B370 Operations Management
Total Cost Cost Minimization Goal By adding the item, holding, and ordering costs together, we determine the total cost curve, which in turn is used to find the Qopt inventory order point that minimizes total costs. C O S T Holding Costs Annual Cost of Items (DC) Ordering Costs QOPT Order Quantity (Q) B370 Operations Management
Fixed-Order Quantity Models:Model Assumptions (Part 1) • Demand for the product is constant and uniform throughout the period. • Lead time (time from ordering to receipt) is constant. • Price per unit of product is constant. B370 Operations Management
Fixed-Order Quantity Models:Model Assumptions (Part 2) • Inventory holding cost is based on average inventory. • Ordering or setup costs are constant. • All demands for the product will be satisfied. (No back orders are allowed.) B370 Operations Management
Annual Purchase Cost Annual Ordering Cost Annual Holding Cost Total Annual Cost = + + Basic Fixed-Order Quantity (EOQ) Model Formula TC = Total annual cost D = Demand C = Cost per unit Q = Order quantity S = Cost of placing an order or setup cost R = Reorder point L = Lead time H = Annual holding and storage cost per unit of inventory B370 Operations Management
Deriving the EOQ Using calculus, we take the first derivative of the total cost function with respect to Q, and set the derivative (slope) equal to zero, solving for the optimized (cost minimized) value of Qopt. We also need a reorder point to tell us when to place an order. B370 Operations Management
EOQ Example (1) Problem Data Given the information below, what are the EOQ and reorder point? Annual Demand = 1,000 units Days per year considered in average daily demand = 365 Cost to place an order = $10 Holding cost per unit per year = $2.50 Lead time = 7 days Cost per unit = $15 B370 Operations Management
EOQ Example (1) Solution In summary, you place an optimal order of 90 units. In the course of using the units to meet demand, when you only have 20 units left, place the next order of 90 units. B370 Operations Management
EOQ Example (2) Problem Data Annual Demand = 10,000 units Days per year considered in average daily demand = 365 Cost to place an order = $10 Holding cost per unit per year = 10% of cost per unit Lead time = 10 days Cost per unit = $15 Determine the economic order quantity and the reorder point. B370 Operations Management
EOQ Example (2) Solution Place an order for 366 units. When in the course of using the inventory you are left with only 274 units, place the next order of 366 units. B370 Operations Management
Fixed-Time Period Model with Safety Stock Formula q = Average demand + Safety stock – Inventory currently on hand B370 Operations Management
Fixed-Time Period Model: Determining the Value of sT+L • The standard deviation of a sequence of random events equals the square root of the sum of the variances. B370 Operations Management
Example of the Fixed-Time Period Model Given the information below, how many units should be ordered? • Average daily demand for a product is 20 units. • The review period is 30 days, • lead time is 10 days. • Management has set a policy of satisfying 96 percent • of demand from items in stock. • At the beginning of the review period there are 200 units • in inventory. • The daily demand standard deviation is 4 units. B370 Operations Management
Example of the Fixed-Time Period Model: Solution (Part 1) The value for “z” is found by using the Excel NORMSINV function, or as we will do here, using Appendix D. By adding 0.5 to all the values in Appendix D and finding the value in the table that comes closest to the service probability, the “z” value can be read by adding the column heading label to the row label. So, by adding 0.5 to the value from Appendix D of 0.4599, we have a probability of 0.9599, which is given by a z = 1.75. B370 Operations Management
Example of the Fixed-Time Period Model: Solution (Part 2) So, to satisfy 96 percent of the demand, you should place an order of 645 units at this review period. B370 Operations Management
Full Empty One-Bin System Periodic Check Miscellaneous Systems:Bin Systems Two-Bin System Order One Bin of Inventory Order Enough to Refill Bin B370 Operations Management
What type of inventory system (P/Q model) would you consider in the following situations:- Buying food- Buying newspaper - Refueling your car B370 Operations Management
ABC Classification System • Items kept in inventory are not of equal importance in terms of: • dollars invested • profit potential • sales or usage volume • stock-out penalties 60 % of $ Value A 30 B 0 C % of Use 30 60 So, identify inventory items based on percentage of total dollar value, where “A” items are roughly top 15 %, “B” items as next 35 %, and the lower 65% are the “C” items. B370 Operations Management
Why it is desirable to classify inventory into groups (e.g. ABC)?Any example you can think of that an organization can be benefited with different inventory policy for different items? How it could be done? B370 Operations Management
Inventory Accuracy and Cycle Counting • Inventory accuracy refers to how well the inventory records agree with physical count. • Cycle Counting is a physical inventory-taking technique in which inventory is counted on a frequent basis rather than once or twice a year. B370 Operations Management
Material Requirements PlanningDefined • Materials requirements planning (MRP) is the logic for determining the number of parts, components, and materials needed to produce a product. • MRP provides time scheduling information specifying when each of the materials, parts, and components should be ordered or produced. • Dependent demand drives MRP. • MRP is a software system. B370 Operations Management
A B(4) C(2) D(2) E(1) D(3) F(2) Example of MRP Logic and Product Structure Tree Given the product structure tree for “A” and the lead time and demand information below, provide a materials requirements plan that defines the number of units of each component and when they will be needed. Lead Times A 1 day B 2 days C 1 day D 3 days E 4 days F 1 day Product Structure Tree for Assembly A Demand Day 10 50 A Day 8 20 B (Spares) Day 6 15 D (Spares) B370 Operations Management
First, the number of units of “A” are scheduled backwards to allow for their lead time. So, in the materials requirement plan below, we have to place an order for 50 units of “A” in the 9th week to receive them in the 10th week. LT = 1 day B370 Operations Management
LT = 2 Spares A 4x50=200 B(4) C(2) D(2) E(1) D(3) F(2) Next, we need to start scheduling the components that make up “A”. In the case of component “B” we need 4 B’s for each A. Since we need 50 A’s, that means 200 B’s. And again, we back the schedule up for the necessary 2 days of lead time. B370 Operations Management
Finally, repeating the process for all components, we have the final materials requirements plan: 32 A Part D: Day 6 B(4) C(2) 40 + 15 spares D(2) E(1) D(3) F(2) • The McGraw-Hill Companies, Inc., 2001
Aggregate Plan (Product Groups) Master Production Schedule (MPS) • Time-phased plan specifying how many and when the firm plans to build each end item. MPS (Specific End Items) B370 Operations Management
Types of Time Fences • Frozen • No schedule changes allowed within this window. • Moderately Firm • Specific changes allowed within product groups as long as parts are available. • Flexible • Significant variation allowed as long as overall capacity requirements remain at the same levels. B370 Operations Management
Moderately Firm Frozen Flexible Capacity Forecast and available capacity Firm Customer Orders 8 15 26 Weeks Example of Time Fences Exhibit 14.5 B370 Operations Management
Material Requirements Planning System • Based on a master production schedule, a material requirements planning system: • Creates schedules identifying the specific parts and materials required to produce end items. • Determines exact unit numbers needed. • Determines the dates when orders for those materials should be released, based on lead times. B370 Operations Management
Firm orders from known customers Forecasts of demand from random customers Aggregate product plan Engineering design changes Inventory transactions Master production schedule (MPS) Bill of material file Inventory record file Reports Material planning (MRP)
Bill of Materials (BOM) FileA Complete Product Description • Materials • Parts • Components • Production sequence • Modular BOM • Subassemblies • Planning BOM • Fractional options B370 Operations Management
Inventory Records File • Each inventory item carried as a separate file • Status according to “time buckets”. • Pegging • Identify each parent item that created demand. B370 Operations Management
Primary MRP Reports • Planned orders to be released at a future time. • Order release notices to execute the planned orders. • Changes in due dates of open orders due to rescheduling. • Cancellations or suspensions of open orders due to cancellation or suspension of orders on the master production schedule. • Inventory status data. B370 Operations Management
Secondary MRP Reports • Planning reports, for example, forecasting inventory requirements over a period of time. • Performance reports used to determine agreement between actual and programmed usage and costs. • Exception reports used to point out serious discrepancies, such as late or overdue orders. B370 Operations Management
Net Change System • Activity driven • Net change schedules • Potential for system nervousness B370 Operations Management
Additional MRP Scheduling Terminology • Gross Requirements • On-hand • Net requirements • Planned order receipt • Planned order release B370 Operations Management
X A(2) B(1) C(2) D(5) C(3) MRP Example Requirements include 95 units (80 firm orders and 15 forecast) of X in week 10 plus the following spares: B370 Operations Management
X A(2) B(1) C(2) D(5) C(3) B370 Operations Management
No Realistic? Feedback Feedback Yes Execute: Capacity Plans Material Plans Closed Loop MRP Production Planning Master Production Scheduling Material Requirements Planning Capacity Requirements Planning B370 Operations Management
Manufacturing Resource Planning (MRP II) • Goal: Plan and monitor all resources of a manufacturing firm (closed loop): • manufacturing • marketing • finance • engineering • Simulate the manufacturing system B370 Operations Management
Lot Sizing in MRP Programs • Lot-for-lot (L4L) • Replenish whatever is needed • Economic order quantity (EOQ) • Least total cost (LTC) • Least unit cost (LUC) B370 Operations Management