Inventory scoping for understanding the business requiremnt

Inventory Scoping.doc

1. PEPSI
Analysis Questionnaire
Oracle Inventory
inventoryscoping-241017044847-dfeb01ec.doc Page 1 of 5

2. No Question Answer
General
1. What products and services do you provide?
2. Describe/share your Corporate/Organizational Vision Statement.
3. What business areas and/or operations are targeted for
improvement?
4. What is your organizational structure?
5. How many types of services do you provide?
Inventory
1. What is your current warehouse structure?
2. How do you maintain warehouse access security?
3. What are the physical attributes for your warehouses?
4. What are the products and services that will be defined in
inventory?
5. What are the classifications of inventory items in terms of item
types (Trade items, Tracked Expense items, Non Tracked Expense
Items, Fixed Assets), categories...etc?
inventoryscoping-241017044847-dfeb01ec.doc Page 2 of 5

3. No Question Answer
6. Which system will be the owner of the product definition?
7. What are the Costing methods used in your warehouses?
8. Do you have items under Serial number control, Lot Number
Control, Revision Level Control?
9. Clarify the demand sources? (3
rd
party systems, internal orders…
etc)
10. Do you have a safety stock level?
11. How do you maintain your stock level?
12. Can you list your miscellaneous transactions?
13. Are you running your business with reliance on miscellaneous
transactions?
14. How do you measure inventory accuracy?
15. How often do you count all your items in any given inventory
location?
16. How often do you update product costs?
17. How long does it take to close your accounting period?
18. Do you have a special subinventory for Returned Goods?
19. Do you track serial numbers when product is returned or you just
track the quantity?
inventoryscoping-241017044847-dfeb01ec.doc Page 3 of 5

4. No Question Answer
20. Do you use an internal requisition system?
21. What is the average lead-time from requisition to delivery?
22. How many replenishment orders do you request at peak periods?
23. What is the flow for inventory items within your Warehouse
structure (i.e. how the items move between warehouses)?
24. Do you have intransit warehouse (i.e. when you make issue or
return transaction, is the quantity going directly to destination or
will stay at staging area (Logical inventory) then once the actual
receiving is done the issue transaction will be took place from
internist to destination )
25. Do you have a special subinventory for Production (i.e. packaging
and De-packaging)?
26. If we talk about expense items (Did you track expense items i.e.
you receive this items on Subinventories then you make issuing
against the demand, or you don’t track it i.e. your company
expenses it upon PO receipt)?
27. If we talk about fixed asset items (did you track it at in inventory
i.e. you receive it on subinventory and once they start
depreciation you issue it out of stores, or you just receive it and
the cycle will be ended at receiving?
28. According to item definition process, is there is any methodology
you make it before define any new items (i.e. you share with
product and service department or marketing department to agree
about the item attributes and other details?
inventoryscoping-241017044847-dfeb01ec.doc Page 4 of 5

5. No Question Answer
29. When you receive Pos, you receive it on one warehouse or you can
receive the Pos on any warehouse like item code?
30. After receiving the Pos or items how you make distribution for the
items to other warehouse (i.e. from central warehouse to other
warehouses)?
31. Is there is possibility to move the items between the warehouses
or all items it must go through central warehouse?
32. According to rejected items is there is any subinventory you store
those items after inspection or you return it directly to the
supplier?
33. Which planning methods you use (Min max planning, Reorder
Point planning method)?
inventoryscoping-241017044847-dfeb01ec.doc Page 5 of 5