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