Operational Reporting QAD's Enterprise Applications

Posted on: May 10, 2013 | By: Andy Vitullo | QAD Financials

 

Operational Reporting on a timely basis can provide your business with information that can have a positive impact on operations and increased reliability on actual results.  This reporting approach should have the appropriate feedback loops.  Holding leaders and departments accountable for results of operations enables cross departmental communication.   With QAD’s Enterprise Applications, where a company is using a standard costing system and an advanced repetitive manufacturing accounting approach, the following operational reports  should be considered.    Using a combination of power browses, operational metrics and the auto start function in the .Net interface, users/departments should view the following immediately upon logging into QAD. 

Procurement and Purchasing:

Purchase Price Variance.  This browse should display vendor, purchase order, receiver number, item, standard cost, purchase order price and the difference in dollars and percentage.   Use operational metric tools to sort out the large dollar or percentage variances. 

Departmental Expenses:

Departmental Expense Report.  This financial report displays actual expenses to budgeted expenses directly from general ledger postings. 

Methods Variance by order.   In an advanced repetitive manufacturing accounting environment material variances to standard will not be obvious.  Production variances at the order level will be based on alternate routings and will therefore fall out to the ledger as method change variance. 

Cycle Count Charges by Item by Quantity by Cost.  –  Since the advanced repetitive back flush will be used, there, will not be any identification of over issues of component materials to orders.  Cycle counting will provide two results

·         An adjustment of inventory for a location, item , quantity, cost combination and

·         The result of more items consumed in production than predicted by the back flush. 

Labor, burden (variable overhead) and Overhead (fixed Overhead) Absorption. 

·         Compare by department/cost center Actual payroll labor to standard labor absorbed.

·         Compare by department/cost center Actual payroll burden to standard burden absorbed.

·         Compare by department/cost center Actual Overhead expenses to standard overhead absorbed.

For more information regarding this content, please contact Andy Vitullo at avitullo@logan-consulting.com.