Compares Amalgamated Weighted Average Cost, Replacement Cost, and Last Cost of Items.
| Access |
| Grant permission to User Profiles in Access User Profiles > select a User Profile > Menu Security > Reports module > Main Menu > Inventory Cost/Pricing |
| Grant permission to the individual report> Inventory Cost/Pricing > Cost Comparison |
Create Your Report
In Location Selection retain the default of All Locations or remove the checkmark and enter a Site ID or select F12 to search.
Enter a greater than or equal to percentage of Tolerance. This can be left as zero.
In the Category section, select All, one or multiple Item Categories using Windows tagging.
For Manufacturer select All, one or multiple Manufacturer's using Windows tagging.
Only Show Items with On Hand becomes active if one Location is selected. Select to show only the Items with current On Hand Quantity.
Select Preview to view the report onscreen.
Select Print to send the report directly to the default printer.
View a sample report here.
Understanding Your Report
Item ID listed in numerical order including the Item Description.
Amalgamated W. Avg. Cost displays the current amalgamated weighted average cost of the item.
The Replacement Cost of the item per stocking unit of measure for the Primary vendor.
Replacement Variance % is the percentage difference between the AWAC and Replacement Cost. Calculated by subtracting the Replacement Cost from the AWAC, the sum of this calculation is then divided by the AWAC.
| (Replacement Cost - AWAC) / AWAC = Replacement Variance % |
Last Cost indicates the Cost of the Item from the last Purchase Order.
Last Variance % indicates the percentage difference between the AWAC and Last cost. Calculated by subtracting the Last Cost from the AWAC, the sum of this calculation is then divided by the AWAC.
| (Last Cost - AWAC) / AWAC = Last Variance % |