...back to the Construction Industry Group Page

Stock and Inventory Control

• Select items from perpetual stock for test reconciliation
• Reconcile selected physical counts to computed amounts
• Compare the value of physical counts to general ledger value
• Statistically analyze usage and ordering to improve turnover
• Report on stock and high value balances using any selection
• Test clerical accuracy of totals and extensions
• Summarize and stratify turnover by stock item in any order
• Test for duplicate parts, item numbers, prices, or descriptions
• Segregate variances from standard pricing in dollar amount order
• Identify obsolete inventory by sorted turnover analysis
• Quickly identify items with yearly volume under on-hand quantity
• 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.
• Assess the financial viability of LIFO versus FIFO management
• 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
• Match stock receipts with vendor ledger and report variances
• Check product reordering volume by item, warehouse, or vendor

Accounts Receivable

• Report and automatically age total receivables in any format
• Identify high value credit notes, balances, and invoices
• Extract variances in matching remittances to open receivables
• Generate invoice summaries by customer, invoice, amounts, etc.
• Report gaps in the sequence of invoices generated
• Identify duplicate invoices, credits, or receipts in any order
• Determine carrying costs by comparing days in collection by customer
• Summarize client days to payment by client, sales representative, region, etc.
• Identify credits taken beyond discount terms of payment days
• Show variances between delivery documents and invoices
• Calculate lost revenue from unpaid carrying charges by client, etc.
• Identify accounts with oldest activity for sales follow-up
• Isolate average sales amounts by product, sales representative, region, etc.

Accounts Payable

• Correlate vouchers or invoices posted versus purchase order amounts
• Extract total posted invoices for the year for accurate vendor rebates
• Isolate vendor unit price variances by product over time
• Summarize large invoices w/o purchase orders, by amount, vendor, etc.
• Identify distributions to accounts not in suppliers’ account ledgers
• Reconcile check register to disbursements by vendor invoice
• Reconcile selected vendors’ payables posted against purchase orders
• Review recurring monthly expenses and compare to posted/paid invoices
• Extract invoices posted with duplicate purchase order numbers
• Generate cash requirements by bank, period, product, vendor, etc.
• Create activity summary for suppliers with duplicate products

Sales Analysis

• Generate sales and profitability reports by sales representative, product, or customer
• Recap product sales by region, customer, category, etc.
• Analyze sales trends by comparing current and previous periods
• Identify top dollar volumes by products, customers, sales representative, etc.
• Extract all sales data for audit by customer, product, region, etc.
• Summarize sales performance over time by product, sales representative, etc.
• Select any range of products for current and period-to-date analysis
• Compare current product sales with booked sales for demand analysis/trends
• Report on creditor balances aged in any format required
• Compare ratios of current sales to open receivables (high-low, low­-high)
• Summarize shipments by warehouse for product distribution analyzes

Salaries and Payroll

• Summarize and print payroll by selection criteria for audit review
• Identify changes in exemptions, gross pay, hourly rates, salary amounts, etc.
• Extract all payroll checks where the gross dollar amount exceeds set amount
• Recap distributions to jobs, projects, etc., for audit and reconciliation
• Report entries against authorization records for new or terminated employees
• Compare and summarize costs for special pay, overtime, premium, etc.
• Identify duplicate or missing payroll checks by check, bank, etc.
• Compare time-card rates and pay to payroll and indicate variances

Cash Disbursements

• Extract cash disbursements by vendor/supplier for audit verification
• 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

Sales Order Control

• Report on correlation between items shipped and items ordered
• Compare items ordered to cancelled by product, sales representative, and order
• Identify items still backlogged beyond ship dates due
• Show profit variance between items ordered and picked
• Analyze open orders and invoices by customer for credit control
• Isolate detail and average backlog by item, location, etc.
• Manage delinquent orders by showing days past due, in any order
• Reconcile booked items to inventory reserved (on hold) items
• Control profits by calculating line item margins before shipment
• Analyze product demand by summarizing products ordered by date due

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.

Work in Process

• Monitor the progress of any job or work order by customer, order, etc.
• Sample work orders for accuracy against original sales orders booked
• Flag shortages by extracting allocations and deallocations against work orders
• Identify stalled shop orders by date to improve productivity
• Select material with a pick list by item to improve speed in material issue
• Summarize pending work orders by size, priority, for release to shop floor
• Merge products on work orders and sales orders for net demand analysis
• Use net demand analysis against inventory and purchase orders to generate a quick material requirements planning report
• Identify orders completed with shop floor orders still open
• Randomly select jobs for detailed or manual audit and analysis
• Produce shop floor activity report by any item
• Improve production by comparing item lead time for unstocked items
• Generate material pick list and allocation statistics for faster stock issues
• Selectively examine detailed routing of any item or item group
• Consolidate part requirements from BOM to save purchase time and money
• Calculate costed BOM with substitute vendors/parts for lower costs
• Audit assemblies by item for uniformity, consolidation, and cost savings
• Isolate internal subassembly costs for comparison to outside costs
• Generate comparison of planned versus actual labor, material, and time
• Compare master planning orders to capacity to improve future schedules
• Reconcile job tickets or time cards to workorder line items
• Compare actual costs for a job to standard costs, detail, or variances
• Audit stock requisitions for correlation to current work in process

     
© 2003 Case | Sabatini.