The Inventory Item Average Cost Analysis report is used to track variances in items' average cost.  These fluctuations can be caused by operator errors or an increase in a vendor's actual cost.  There are three definitions that must be defined before continuing with this report.

Current Average Cost.  This is the average cost presently on the inventory item.

Last Average Cost.  This is the average cost previously on the inventory item.

Standard Cost.  This is the last average cost calculated during the last physical inventory update.

Report Setup

Program ID.  Enter the program ID of the program to analyze.  If the program ID is not known, enter "?" to display the Active Programs window.  Select the program by entering the sequence number to the left of the program ID.  If the analysis is to include all programs, press Spacebar.

Minimum Variance %.  Enter the minimum average cost variance percentage to print on the report.  If all variances, regardless of the variance percentage, enter the number "0".

Last Average Cost Re-Calc Date.  Enter the earliest date for the variances to print.  Example:  If only the variances for the last two months are to print, enter the date that is two months removed from today's date.  The report will print all variances in average cost from that date to today's date.

Cost Comparison Method.  Enter the comparison method for the system to analyze.  If the last average cost is to be compared to the current average cost, enter "L".  If the last standard average cost from the last physical inventory update is to be compared to the current average cost, enter "S". 

The report will print the following information:

Item Number and Description.

D. Discontinued, yes or no.

S. Status code for the item.

Date of Last PO.  This is the date the last P order was entered for this item.

Last PO.  This is the last P order number entered for this item.

Actual On Hand.  Current inventory quantities.

BQOH.  Billable Quantity On Hand.  Quantity used to calculate the General Ledger Inventory account balance.

Last Average.  Last average cost.

Standard Cost.  Last average cost from a physical inventory update.

Current Average.  Current average cost.

Variance.  This is the variance in the average costs.  The amount of the variance will be determined by the cost comparison method entered.  This variance is a dollar amount.

%.  Percent change in the average cost.