• 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?.

Copyright © 2019, 2022, Oracle and/or its affiliates.