Managing Customer Consignment Inventory

1. Managing Customer Consignment Inventory Quovera Confidential

2. Managing Customer Consignment • Agenda • Consignment scenarios • Benefits of consignment programs • Determine products for consignment and agreements • Internal controls for consignment • Managing customer consigned inventory in Oracle – Bill Only, Inventory Interface Workflow • Oracle Set Ups • Manual Consignment Pull Order Process • Processing Errors • Customizations to Improve Process • Questions and Answers Quovera Confidential

3. Managing Customer Consignment Consignment Scenario Quovera Confidential

4. Consignment Scenarios • Consignment Scenarios • Customer consigned inventory at customer warehouse • Customer consigned inventory at 3rd party warehouse Quovera Confidential

5. Consignment Definition Customer Consigned Inventory is a practice where you place and maintain goods belonging to you at your customer locations. Customer does not take ownership of product until used (pulled). Quovera Confidential

6. Managing Customer Consignment Benefits of Consignment Program Quovera Confidential

7. Benefits of Consignment Program • Benefits of Consignment Program • Customer • Customer Satisfaction • Reduced time to Market for new product • Shorter lead times • Competitor edge • Service parts for critical equipment • Save expedite freight costs Quovera Confidential

8. Benefits of Consignment Program • Downside of Consignment • Inventory management ( scraps, cycle counts, replenishment) • Managing of obsolete parts • Timely Pull notifications • Shipment notice (3rd Party Warehouse) • Customer forecast and supplier production schedule conflicts • Invoice and payment Quovera Confidential

9. Managing Customer Consignment Consignment Products Quovera Confidential

10. Consignment Products • Determine products for Consignment • Customer • Products with high-degree of demand uncertainty • Supplier • Products with high-degree of sales potential but demand is not reasonably known or stable • New unproven products • The introduction of existing product lines into new sales channels. • Very expensive products where sales are questionable. Quovera Confidential

11. Consignment Products • Consignment product characteristic • Transparent to the user • Requires no special handling in Shipping and Receiving • Viewable as available in inventory • Non-nettable and not available for planning • Can be cycle counted Quovera Confidential

12. Managing Customer Consignment Consignment Agreements Quovera Confidential

13. Consignment Agreements • Consignment Agreements • Establish min/max inventory levels with a periodic review • Determine criteria for consigned item • Establish point of transfer of ownership • Frequency and means of communication for consumption advice • Consumption policy (eg. FIFO) • Modified payment terms and agreed payment process • Address stolen, lost, damaged, removal or destroyed consigned material • Means to share and review customer forecast and schedule • Determine who’s responsible for consignment material overhead cost (taxes, insurance…) • Consigned item return policy • Determine responsibility for the physical security of the consigned item storage location. • Inspection and cycle counting • Delivery performance measurements (Based on stock outs) Quovera Confidential

14. Managing Customer Consignment Internal controls For Consignment Quovera Confidential

15. Internal Controls for Consignment • Internal control for consignment • Establish procedure to account for consigned goods movement • Establish billing, shipping and receiving procedure with necessary approval • Record adjustment for shrinkage and lost • Segregate consigned and non-consigned goods • Supplier agreement must be approved by company lawyers and does not violate any government regulations • Reconciliation and confirmation of consigned goods by consignee Quovera Confidential

16. Managing Customer Consignment Oracle setups for Customer Consigned Inventory Quovera Confidential

17. Consignment Workflow Billing workflow Send consumption advice to supplier Create consignment sales order for consignment customer Generate invoice for billings Replenishment workflow Run min/max planning for consignment subinventory with restock = ‘Yes’ Import and create internal requisition Create internal sales order via order import Pick release and ship goods to consignment location Customer Supplier Quovera Confidential

18. Inventory and Item Setups Define Location Quovera Confidential

19. Inventory and Item Setups Define Consignment Organization and Assign Location Quovera Confidential

20. Inventory and Item Setups Define Consignment Sub-Inventory Quovera Confidential

21. Inventory and Item Setups Enable Item in Consignment Org Quovera Confidential

22. Inventory and Item Setups Set Min/Max value for consigned Item Quovera Confidential

23. Inventory and Item Setups Move Inventory into Consignment Sub-Inventory Quovera Confidential

24. Price List Setups Define Consign Customer Price List and Assign Items Quovera Confidential

25. Order Management Setups Define Order Type Quovera Confidential

26. Order Management Setups Assign Line Flow - Bill Only with Inventory Interface (Generic) Quovera Confidential

27. Order Management Setups Workflow Diagram (Generic) Quovera Confidential

28. Order Management Setups Assign Document Sequence to Order Type Quovera Confidential

29. Order Management Setups Enable Valid Ship Method to Consignment Org Quovera Confidential

30. Customer Master Setups Assign Order Type, Price List, Consignment Org and Valid Ship Method Quovera Confidential

31. Managing Customer Consignment Order Process Order process for Customer Consigned Inventory Quovera Confidential

32. Order Process Enter Order Header Details Quovera Confidential

33. Order Process Verify Consignment Warehouse Defaults Quovera Confidential

34. Order Process Enter Line Details Quovera Confidential

35. Order Process Enter Consignment Sub-Inventory on Line Quovera Confidential

36. Order Process Schedule Line Quovera Confidential

37. Order Process Book Order Quovera Confidential

38. Order Process Line Status Goes to Fulfilled Quovera Confidential

39. Order Process Workflow Proceeds to Invoice Interface Quovera Confidential

40. Order Process Line Status Goes to Closed Quovera Confidential

41. Managing Customer Consignment Invoice Process Invoice process for Customer Consigned Inventory Quovera Confidential

42. Invoice Process Run Autoinvoice Quovera Confidential

43. Invoice Process View Invoice Quovera Confidential

44. Verify Inventory Decrement View Material Transaction Quovera Confidential

45. Managing Customer Consignment Replenishment process for Customer Consigned Inventory Quovera Confidential

46. Replenishment Process Run Min-Max planning report Quovera Confidential

47. Replenishment Process Create and approve internal requisition Quovera Confidential

48. Replenishment Process Create internal sales orders Quovera Confidential

49. Replenishment Process Order import Quovera Confidential

50. Replenishment Process Pick and Ship Confirm Replenishment Inventory Quovera Confidential