- Business Questions
- Overview
- How much did the organization spend with suppliers, commodities, buyers, cost center, contracts versus non contracts and leakage?
- Identify the items and categories with cost-saving potential in procurement operations based on price?
- Identify the key areas for improving process efficiencie?
- Identify the items, categories, and suppliers with compliance issues in their purchase agreement?
- What commodities and services have been purchased, in what volume and price?
- How is purchase distributed across suppliers?
- Is a company using strategic suppliers and contracts effectively?
- What are my purchase volumes across business units?
- What is my contract versus off contract spend?
- What are cycle times in terms of PR and PO approval, PR to PO conversion?
- How many times are we amending purchase orders and whether amendment initiation is internal or external?
- How many approvers on a average are approving purchase orders?
- What are my lead time standard and variances in purchase cycles?
- What are purchase orders creation sources and corresponding requisition sources?
- When were products shipped and what is the average delivery times?
- Which suppliers deliver consistently on time?
- What is accepted and rejected rates for commodities, by suppliers?
- What are return rates for suppliers?
- What receipts are created manually or through ASNs?
- What are my processing and post-processing lead time standards and variances for an item?
- What are my products and services for which we have agreements?
- What are the agreements utilization rates?
- Which agreements are under utilized?
- Which agreements are utilized before expiry?
- What are the creation sources for agreements?
- What are my cycle times for agreement approvals?
- What are my negotiation to agreement approval cycle times?
- How many times are we amending agreements and whether amendment initiation is internal or external?
- How many approvers on a average are approving agreements?
- How long does it take for purchase requisitions to get approved?
- What is the centralized view of all procurement requests for purchasing department?
- What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?
- How many non-catalog purchase requisitions are created by volume, item, and amount?
- What is an organization's current period order booking, open, shipped, invoiced, returned, open returned, past due amount in terms of quantity and amounts?
- What is the total booking, returns, shipped , on time shipped, perfect orders, shipped in full, late shipped amounts trends?
- What is the shipment and delivery performance for an organization in terms of perfect order, shipped in full and on time (shipment and delivery) percentages?
- How effective is an organization to schedule and manage fulfillment end-to-end cycle times?
- What, when, and how much materials are being returned?
- What type of holds are applied to orders?
- Which all orders have holds applied currently and in the past?
- What is the average hold times for different kinds of holds?
- What is the trend in inventory movement in and out for items, item category, and plants?
- Top 10 inventory movements by plant or item category?
- Top 10 items issues by transaction typ?
- Top 10 items receipts by transaction type?
- What is an organization's inventory position across supply chain in terms of quantity?
- What is the trend for onhand quantity by product and category?
- Which product, category, organization are high in terms of inventory quantity in the asset subinventory location?
- What is the item unit cost for a cost organization and different cost books?
- What is the item unit cost by different cost elements like material, material overhead, and overhead by value and percentage?
- What is the trend of item costs over a period of time?
- What items are showing most volatile trend over a period of time?
- What is an organization's inventory value across supply chain for an item, item category, and organization?
- What is the trend in inventory valuations for items and organizations?
- What is the inventory valuations for items or item category for a given period?
- What products and warehouses are effective in managing pick, pack, and shipping operations?
- How effective is outbound warehouse operations for a organization in terms of release to ship cycle times?
- Which sales orders are due for picking today and/or tomorrow?
- Which shipments are due for shipping today and/or tomorrow?
- How many shipment lines got backordered for a particular period?
- What are the products fulfilled from different supply sources to meet customer demand?
- What is the average fulfillment time for the products sourced from different supply types?
- What is the inventory cost of the products sourced from different supply types?
- What are the products shipped directly to customers from supplier warehouse?
- What is the average fulfillment time for the products shipped directly to customers from suppliers?
- What is the sales order booked amount in a particular period and what is the corresponding billing amount?
- What are the invoices created for a particular period and corresponding sales orders details for the same period?
- What is my unearned revenue and revenue based on business unit, customer, product, etc.? For a selected booking period?
- What are the freight amounts by product, location, and shipping method for a given period on the order lines?
- How many orders had manual adjustment applied by business unit, customer?
- How much discounts was applied on the order lines by business unit, customer?
- What is the total order amount by business unit, customer, product, for a given period?
- How effective is an organization to schedule and manage internal material transfers and measure end-to-end cycle time?
- What, when, and how much of internal materials are being returned?
- What is the shipment and delivery performance for an organization/warehouse in terms of Orders shipped in full and on time (shipment and delivery) percentages?
- What is an organization current period open transfer orders, shipped, received, returned, open returned, past due in terms of quantity and amounts?
- How good is your internal material sourcing efficiency?
- How good is your visibility on intra- and inter-organization transfers?
- What is the shipment status for transfer orders?
- What are the products and quantity returned by customer over a period of time?
- What are the reasons for product return from customers?
- What are the delivery times from Internal organizations?
- What are the return rates for Internal organization?
- Top 10 products with increasing or decreasing gross margin %
- Top 10 customers with increasing or decreasing gross margin %
- What is my gross margin by business unit, products, locations, product category, and customers for a given period?
- Which of my products revenue or COGS is not recognized?
- Which of my products revenue or COGS is partially recognized?
- What is the cost distribution for a cost organization and cost book for a given period?
- What is the cost distribution by accounting line typefor a cost organization and cost book?
- What is the cost distribution by transaction type, accounting line type, item etcfor a cost organization and cost book?
- What is the transactionamount for a particular accounting line type bycost organization and cost book for a given period? E.g COGS, PPV etc.
- What is the time taken to produce my products?
- How does the time taken to produce compare against plan?
- What is the production yield for my plant?
- Which steps in my production process have the greatest impact on yield, and why?
- How is my quality of production?
- What % of items are being reworked?
- How much time does it take for my product to pass through the production plant?
- Do I scrap during production?
- How can I improve the quality of my products?
- Is my plant reaching its targeted production output?
- How many work orders are completed on time?
- When were products shipped by Suppliers and internal organizations and what is the average delivery times of Suppliers and Internal Organizations?
- What is the volume of inventory received?
- What is the total quantity received per warehouse operator ?
- What is the Receiving cycle time?
- What receipts are created manually or through ASN's?
- What is Accepted and Rejected rates for commodities, by suppliers?
- How long do you need to intake inventory from Receiving to storage location?
- What is the age of inventory?
- What is the average age of inventory?
- What is the on-hand value of inventory in my warehouse?
- What is the Inventory Turns of my Organization?
- What is your Days In Inventory for a given Inventory Organization?
- What are the Fast, Slow and Non-Moving Products in the warehouse?
- Which products are excess?
- Which products are obsolete?
- What is the number of operation transactions done for my work order?
- What is the output quantity of my process manufacturing work order?
- What is the actuals and planned usages of reosurces for my work order?
- What are the reosurce and labour counts in my work area?
- What are the transaction details of the resources in my organization and work area?
- What is the actuals and planned usages of materials for my work order?
- What are the transaction details of the materials in my organization and work area?
- Which contracts are expiring in next one months by suppliers, business unit?
- What is the count of contracts and contract amounts by suppliers, business units, products?
- What are the active contracts by contract type?
- What is contract cycle time in days for contracts?
- What are the contracts with policy deviations?
- What are the Receipt Accounting Transactions for the current Period?
- What are the Receipt Accounting Distributions generated for the current period?
- Which of the POs are accrued where the Accrual is at Receipt?
- Which POs are Matched against Invoice?
- Is the Un-invoiced Receipt transactions Manually Cleared?
- What are Order types and order statuses imported from external systems?
- What is the total count of Sales Order which are in Draft, Credit Review Pending, and Approval Pending order statuses?
- What are the Sales Orders and Sales Order lines in Draft status?
- What are the Sales Orders and Sales Order lines in Credit Review Pending status?
- What is the count of Sales orders which are on hold and the Order status is Draft?
- How much is the PO Receipt Accruals by BU, Inventory Org, Item Category, Supplier for a specific time frame?
- How many Receipts are Accrued by BU, Inventory Org, Item Category, Supplier, PO for a specific time frame?
- How many POs are pending accrual by BU, Inventory Org, Item Category, Supplier for a specific time frame?
- What is the amount of Goods Received and not Invoiced for Accruals at period end by BU, Inventory Org, Item Category, Supplier for a specific time frame?
- What is the shipping cost?
- What is the total Shipping cost ?
Copyright © 2019, 2024, Oracle and/or its affiliates.