Modifying the Cost of an Item
Cost Audit Log
This chapter discusses the different costs that XpertMart™ uses, the Order Cost and the Inventory Cost, and the Cost Audit Log where all cost information for an item is stored. Subsequent chapters discuss how to change the cost of an item using a Cost Adjustment or how to make massive changes to the costs of multiple items. There are also special considerations to keep mind when you are setting up your inventory for the first time to keep your accounting of costs straight..
The Order Cost of an Item is the cost at which you expect to receive that Item from your Vendor. The Order Cost functions as a reference as it is the cost that XpertMart™ automatically enters into any Purchase Order or Receipt. You are free to change this price at the moment you are making the Purchase Order or Receipt, but if you choose not to then your Order Cost will, in fact, be the Inventory Cost used.
The Order Cost appears in the Items Catalog
and can either be entered directly into the Order Cost field of the Items Catalog or
is automatically filled in from the Styles Catalog
when you check the "Price/Cost
from Style" checkbox. Unlike prices where there can be multiple price lists, the Order
Cost is the same for all stores throughout the company.
Every time you receive merchandise XpertMart™ automatically records the cost that was used in the Receipt into the Cost Audit Log. For every Item, XpertMart™ keeps a running average of the costs from every Receipt. This average is the Invenventory Cost. When you are using XpertMart™ correctly, the Inventory Cost is the most realistic indicator of what your merchandise is costing you. You can always see how XpertMart™ is calculating the Inventory Cost by opening the Cost Audit Log.
The Inventory Cost appears in the Inventory
Cost field of the Items Catalog just below
the Order Cost. The value in this field cannot
be edited as it is written-in automatically and the average is updated every
time you make a new Receipt for that item.
The Inventory Cost is the same for all stores in the chain.
Whenever you make an Invoice, XpertMart™ takes
the prevailing Inventory Cost at that moment for every Item and records it
(though you cannot see this on screen). This is the cost used to calculate
Modifying the Cost of an Item
You cannot directly edit the Inventory Cost of an Item. Keeping with our Philosophy of Control, any change to the cost of an item must be done through a document that creates an audit trail. There are only two documents that can change the Inventory Cost of an Item: a Receipt or a Cost Adjustment. When you employ the Mass Changes to Prices and Costs tool what you are in fact doing is creating a batch of Cost Adjustments.
Cost Audit Log
XpertMart™ stores every instance of an item being received, and the cost it was received at, in the Cost Audit Catalog, also called the Cost Audit Log. You can view the contents of this catalog by going to the Catalogs>Inventory menu and selecting Cost Audit, as shown below.
Every record in the Cost Audit Catalog displays, for a particular Item, the following information:
Cost Audit Date: the date the transaction took place;
Initial Quantity: the quantity in stock before the transaction
Original Cost: the average Inventory Cost
prior to the transaction;
Quantity Received: quantity of items received, if any;
Document Type: the type of transaction (either a Receipt or Cost
Received Cost: this is the Net Cost of the Item on the Receipt;
New Cost: the new average once the Received Cost has been factored
in. This is the prevailing Inventory Cost
until a new Receipt or Cost Adjustment is made for this Item.
The entries in the Cost Audit Catalog appear in chronological order and
as such are of limited use in understanding your costs. To get a clearer
picture, run the Cost Audit Log report by clicking on the Reports button
in the toolbar at the top of the catalog:
The Cost Audit Log for a Certain Item Report looks like this:
The report displays the same information that the Cost Audit Catalog does but allows you to see multiple entries at once and therefore see how the average changes with every transaction. In the example above, the Order Cost for the Black Size 5.0 Zodiacs platform mule is $17.50. However, the first time a Receipt was made, on February 6th, the Net Cost on the Receipt was $18.00. Therefore, the new Inventory Cost was $18.00.
The second time this item was received the Net Cost on the Receipt was
$16.99. When you average 14 pairs at $16.99 with the 6 pairs at $18.00,
you get a new Inventory Cost of $17.29.
The third time the item was received the Net Cost on the Receipt was $17.50,
yielding a new Inventory Cost of $17.33. This
means that each one of the 25 pairs of Black Size 5.0 Zodiacs you have
received so far is costing you $17.33 on average.
NOTE: The "Initial" quantity of an entry in the log does not necessarily
need to be equal to the "New" quantity of the prior entry. If in the intervening
time pieces of merchandise were sold, the "Initial" quantity of the new
entry will of course be lower than the "New" quantity of the prior entry.
Copyright © 2002 XpertMart
* Return to Table of Contents*