SCM Business Questions

Overview
What are the active contracts by contract type?
What are the contracts with policy deviations?
What is contract cycle time in days for contracts?
What is the count of contracts and contract amounts by suppliers, business units, products?
Which contracts are expiring in next one months by suppliers, business unit?
How many POs are pending accrual 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 much is the PO Receipt Accruals 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?
How many approvers on a average are approving agreements?
How many times are we amending agreements and whether amendment initiation is internal or external?
What are my cycle times for agreement approvals?
What are my negotiation to agreement approval cycle times?
What are my products and services for which we have agreements?
What are the agreements utilization rates?
What are the creation sources for agreements?
Which agreements are under utilized?
Which agreements are utilized before expiry?
How is purchase distributed across suppliers?
How many approvers on a average are approving purchase orders?
How many times are we amending purchase orders and whether amendment initiation is internal or external?
Is a company using strategic suppliers and contracts effectively?
What are cycle times in terms of PR and PO approval, PR to PO conversion?
What are my lead time standard and variances in purchase cycles?
What are my purchase volumes across business units?
What are purchase orders creation sources and corresponding requisition sources?
What commodities and services have been purchased, in what volume and price?
What is my contract versus off contract spend?
Is the Un-invoiced Receipt transactions Manually Cleared?
What are the Receipt Accounting Distributions generated for the current period?
What are the Receipt Accounting Transactions for the current Period?
Which of the POs are accrued where the Accrual is at Receipt?
Which POs are Matched against Invoice?
What are my processing and post-processing lead time standards and variances for an item?
What are return rates for suppliers?
What is accepted and rejected rates for commodities, by suppliers?
What receipts are created manually or through ASNs?
When were products shipped and what is the average delivery times?
Which suppliers deliver consistently on time?
How long does it take for purchase requisitions to get approved?
How many non-catalog purchase requisitions are created by volume, item, and amount?
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 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 items, categories, and suppliers with compliance issues in their purchase agreement?
Identify the key areas for improving process efficiencie?
Top 10 customers with increasing or decreasing gross margin %
Top 10 products 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 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 cost distribution for a cost organization and cost book for a given period?
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 are Order types and order statuses imported from external systems?
What are the Sales Orders and Sales Order lines in Credit Review Pending status?
What are the Sales Orders and Sales Order lines in Draft status?
What is the total count of Sales Order which are in Draft, Credit Review Pending, and Approval Pending order statuses?
What is the count of Sales orders which are on hold and the Order status is Draft?
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 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 are the delivery times from Internal organizations?
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 return rates for Internal organization?
How long do you need to intake inventory from Receiving to storage location?
What is Accepted and Rejected rates for commodities, by suppliers?
What is the Receiving cycle time?
What is the total quantity received per warehouse operator ?
What is the volume of inventory received?
What receipts are created manually or through ASN's?
When were products shipped by Suppliers and internal organizations and what is the average delivery times of Suppliers and Internal Organizations?
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 the trend in inventory movement in and out for items, item category, and plants?
What are the Fast, Slow and Non-Moving Products in the warehouse?
What is the Inventory Turns of my Organization?
What is your Days In Inventory for a given Inventory Organization?
Which products are excess?
Which products are obsolete?
What is an organization's inventory value across supply chain for an item, item category, and organization?
What is the inventory valuations for items or item category for a given period?
What is the trend in inventory valuations for items and organizations?
What is the item unit cost by different cost elements like material, material overhead, and overhead by value and percentage?
What is the item unit cost for a cost organization and different cost books?
What is the trend of item costs over a period of time?
What items are showing most volatile trend over a period of time?
Are our maintenance practices efficient?
How much time does my org spend doing preventive vs. corrective maintenance?
How much work do I have, and how many resources do I need to do the work?
How often is my org doing preventive maintenance as planned?
Is the amount of maintenance work I have increasing or decreasing?
Is the maintenance scheduling effective in my organization?
What are the transaction details of the materials in my organization and work area?
What is the actuals and planned usages of materials for my work order?
What is the number of operation transactions done 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 reosurces for my work order?
What is the output quantity of my process manufacturing work order?
Do I scrap during production?
How can I improve the quality of my products?
How does the time taken to produce compare against plan?
How is my quality of production?
How many work orders are completed on time?
How much time does it take for my product to pass through the production plant?
Is my plant reaching its targeted production output?
What % of items are being reworked?
What is the production yield for my plant?
What is the time taken to produce my products?
Which steps in my production process have the greatest impact on yield, and why?
How effective is outbound warehouse operations for a organization in terms of release to ship cycle times?
How many shipment lines got backordered for a particular period?
What is the shipping cost?
What is the total Shipping cost ?
What products and warehouses are effective in managing pick, pack, and shipping operations?
Which sales orders are due for picking today and/or tomorrow?
Which shipments are due for shipping today and/or tomorrow?
How effective is an organization to schedule and manage fulfillment end-to-end cycle times?
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 are the freight amounts by product, location, and shipping method for a given period on the order lines?
What are the invoices created for a particular period and corresponding sales orders details for the same period?
What are the products fulfilled from different supply sources to meet customer demand?
What are the products shipped directly to customers from supplier warehouse?
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 my unearned revenue and revenue based on business unit, customer, product, etc.? For a selected booking period?
What is the average fulfillment time for the products shipped directly to customers from suppliers?
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 is the sales order booked amount in a particular period and what is the corresponding billing amount?
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?
What is the total booking, returns, shipped , on time shipped, perfect orders, shipped in full, late shipped amounts trends?
What is the total order amount by business unit, customer, product, for a given period?
What, when, and how much materials are being returned?
What is the average hold times for different kinds of holds?
What type of holds are applied to orders?
Which all orders have holds applied currently and in the past?
How effective is an organization to schedule and manage internal material transfers and measure end-to-end cycle time?
How good is your internal material sourcing efficiency?
How good is your visibility on intra- and inter-organization transfers?
What is an organization current period open transfer orders, shipped, received, returned, open returned, past due in terms of quantity and amounts?
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 the shipment status for transfer orders?
What, when, and how much of internal materials are being returned?
What is the costs of finished goods that are produced in shop floor?
What is the costs of unfinished goods currently undergoing production?
What is WIP values by cost element?
What are the work order variances and how it is trending?