...
...
Aapplication

ARBUTUS ANALYZER

Data Analysis in Manufacturing...

A Few of the Ways You can Put Arbutus Analytics to Work in Manufacturing

  • Stock &
    Inventory Control
  • Work In
    Progress
  • Purchase Order
    Management
  • Cash
    Disbursements

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 Progress

  • 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