Data Analytics in Manufacturing
A Few of the Ways You can Put Arbutus Analytics to Work in Manufacturing
-
Stock & Inventory Control
- Statistically analyze usage and ordering to improve turnover
- Report on stock and high value balances using any selection
- Summarize and stratify turnover by stock item in any order
- Test for duplicate parts, item numbers, prices, or descriptions
- Identify obsolete inventory by sorted turnover analysis
- Isolate and analyze high value transactions by value, group, etc.
- Identify starting and ending period balances by class or group
- Report on products in order of profitability (low-high, high-low)
- Automatically summarize products by group, location, type, etc.
- Analyze the difference between standard costs and actual costs
- Isolate stock lines where the cost is greater than retail price
- Extract products with zero quantities or zero prices
- Check product reordering volume by item, warehouse, or vendor
-
Work In Process
- Generate comparison of planned vs. actual labor, material, and time
- Merge products on work orders and sales orders for net demand
analysis - Summarize pending work orders by size and/or priority, for release to
shop floor - Compare actual costs for a job to standard costs, detail, or variances
- Age work orders to identify potential problem areas
-
Purchase Order Management
- Extract pricing and receipt quantity variations by vendor and purchase order
- Track scheduled receipt dates versus actual receipt dates summary and detail
- Isolate purchase order types (blanket, release, drop-ship) for audit tracking
- Identify duplicate purchase orders or receipts without purchase orders
Correlate purchase orders with jobs or projects in process - Reduce inventory by comparing projected receipts to available stock
- Eliminate stale purchase orders by analyzing and reporting on partial receipts
- Reconcile receipts by comparing accrued payables to received items
- Analyze late shipments for impact on jobs, projects, or sales orders due
- Audit receipt and ordering by selective reports by vendor, date, etc.
-
Cash Disbursements
- Summarize cash disbursements by account, bank, group, vendor, etc.
- Identify check requests, by bank, that exceed set or selected dollar
amounts - Reconcile inter-company transfers by extraction or inclusion
- Provide a complete audit trail for all disbursements by purchase
order, vendor, etc. - Generate vendor cash activity summary for support in rebate
negotiations
Work in Progress
Purchase Order Management
Cash Disbursements
Manufacturing Applications
Download Application Sheet
Customer Success Story
SOX Testing
Protecting Against Financial and Reputational Loss
Long standing US energy infrastructure company focused on connecting North America’s significant hydrocarbon resource plays to growing markets for natural gas and natural gas liquids (NGLs) with revenues of 6B+ USD.
The multi-threaded server power and flexibility of Arbutus Server enabled the IA team to execute a broad-based coverage of its vendor risks.
The ability to dynamically execute the suite of 10 analytics on the entire vendor population of 70,000+ records has reduced audit risk inherent in sampling and allowed the IA Team significant time
savings.
Analytics By Business Process
Learn more about various analytics tests to meet business needs.
Analytics By Business Process