- Created by admin, last modified by AdrianC on Dec 05, 2016
https://help.myob.com/wiki/x/ywic
ANSWER ID:9415
RetailManager allows for two methods of costing for valuing your stock:
- Last Cost will value an item using the cost price (exclusive of tax) that was entered on the last Goods Received transaction entered. Retail Manager will create a "Last Cost Variance" when revaluing stock using this method. See below for more information on "Last Cost Variances".
- Average Cost will value an item based upon a calculation that looks at the current cost, stock on-hand and the new cost and number of item being received at this cost.
- Go to the Setup menu and choose Options.
- Click General then click the Other tab.
- Deselect the Use Average Cost option.
Last Cost Variance
A Last Cost Variance is created in RetailManager when the cost price of an item has changed while using the Last Cost method of stock valuation. RetailManager will revalue all existing stock on-hand of that particular item at the new cost price.
The calculation is: (new cost - original cost) * original quantity
This applies to the following transactions: Goods Received, Goods Received with negative quantity, Cost change in the Information > Stock window and Merging one stock item into another.
Example of a Goods Received committed using Last Cost
- Item A has an In Stock quantity of 10 and Ex Tax Cost of $40. This means that the stock value of Item A is $400.
- Item A is purchased from a supplier and the cost price is now $50. A Goods Received transaction is processed for a further 10 units at $50 each.
- RetailManager changes the Ex Tax Cost of the item to $50 and the stock value is now $1000 (20 * $50).
- Using the calculation above, a Last Cost variance is created for $100. The calculation is ($50 - $40) * 10 = $100
If you use the Accounting Export feature:
Apart from the Goods Received getting exported to MYOB Accounting as a Purchase, the above example will also create a journal entry like the one below.
| Debit | Credit |
Inventory (Asset account) | 100 |
|
Cost of Goods (Expense account) |
| 100 |
If you are unsure of where a Last Cost Variance has come from, you can run the Accounting Export report in RetailManager, found under Tools > Reporting > Misc.
- Go to the Setup menu and choose Options.
- Click General then click the Other tab.
- Select the Use Average Cost option.
How is an Average Cost calculated?
- The Average cost calculation is: ((original quantity * original price) + (new quantity * new price)) / (original quantity + new quantity)
This calculation is applied to the following transactions, Goods Received, Goods Received with negative quantity and Merging one stock item into another.
A Last cost variance will not be created when using Average cost in RetailManager.
Example of Goods Received committed using Average Cost
- Item A has an In Stock quantity of 10 and Ex Tax Cost of $40. This means that the stock value of Item A is $400.
- Item A is purchased from a supplier and the cost price is now $50. A Goods Received transaction is processed for a further 10 units at $50 each.
- RetailManager calculates the new cost of the item to be $45 and the stock value is now $900 (20 * $45).
- The calculation is ((10 * $40) + (10 * $50)) / (10 + 10) $400 + $500 / 20 = $45.
If you use the Accounting Export feature:
The Goods Received will be imported into your MYOB accounting software as a Purchase bill. No journal entry will be created.
The average cost calculation cannot be used under the following conditions:
- Stock item A has a negative In Stock quantity.
- A Goods Received transaction is processed that brings the stock holding of item A back to zero.
- The cost price has changed in the Goods Received.
A Last Cost Variance will be created in the above scenario because a stock holding of zero cannot be divided by zero. The new cost of item will be what was entered on Goods Received.