The Costing tab displays the costing method being used in the current database. Although the costing method may be viewed, it may not be changed. The costing method is set when a new database is created. It may be possible to change the costing method of an existing database by contacting Fishbowl Support. Individual part costs can be viewed on the Costing tab of the Inventory module. Below is an explanation of the costing methods available in Fishbowl.
|Standard cost||Costs are pre-determined for estimating the cost of an order or product. The difference between standard costs and actual costs are recorded as variances and will be reflected in a Cost Variance account. The specified Standard Cost of a part will be used to debit the Cost of Goods Sold account.|
|LIFO cost||Last In, First Out. This method assumes the last inventory purchased will be the first sold. When these goods are sold, the value of the newest inventory will be used to debit the Cost of Goods sold account.|
|FIFO cost||First In, First Out. This method assumes the first inventory purchased will be the first sold. When these goods are sold, the value of the oldest inventory will be used to debit the Cost of Goods sold account.|
|Average cost||The average cost is a simple calculation of total cost divided by inventory quantity. See the table below for an example.
When inventory is purchased, the actual cost of the inventory is added to the total cost, which can result in the average cost changing. When inventory is sold, the current average cost is used, so the total quantity will change, but the average cost will not change as a result of selling an item. LIFO and FIFO use costing layers to store the cost history, so the cost can change each time an item is sold. With average cost, the item's original cost is included in the average and then when the inventory is sold, only the average cost is used and recorded in the cost of goods sold account. If the inventory quantity ever reaches zero, Fishbowl will temporarily store the last average cost, but when new inventory comes in, the calculation starts over using only the cost and quantity of the new inventory. The average cost can also be manually changed.
Below is an example of average costing.
|Quantity||Unit cost||Total cost||Total quantity||Average cost|
|+10 initial inventory||$10||$10 x 10=$100||10||$100 ÷ 10=$10|
|+1 on a purchase order||$21||$100 + $21=$121||10 + 1=11||$121 ÷ 11=$11|
|-1 on a sales order||$11 (average cost)||$121 - $11=$110||11 - 1=10||$110 ÷ 10=$11|
|-10 on a sales order||$11 (average cost)||$121 - $121=$0||11 - 11=0||Average will reset|
|+1 on a purchase order||$18||$18||0 + 1=1||$18 ÷ 1=$18|