- 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 prices.
- Identify the key areas for improving process efficiencies.
- Identify the items, categories, and suppliers with compliance issues in their purchase agreements.
- 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 type.
- 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?
Copyright © 2019, 2022, Oracle and/or its affiliates.