GEM-CAR FAQ
Configuring the Inventory Calculation Method
Inventory can be calculated in four different ways.
Click on the menu on the left, Configurations > Configurations > Global tab, click on the inventory calculation method and select one of the options.
The methods are as follows:
- Cost in the product file;
- Average cost;
- First in, first out (FIFO);
- Last in, first out (LIFO).
After selecting a method, scroll to the bottom of the page and click on Save.
1. Cost in the product file
On the menu on the left, click on Inventory > Products and Services.
Choose the product you want. In the Purchases tab, you will see the options cost price, next cost and next selling price.
Note: the system will calculate the next cost, but you must enter the cost price.
2 Average cost
The cost is calculated as follows, for example:
- in January, winter tires were purchased for $100 each,
- in February, the product cost 200 dollars,
- in March, the cost reached 300 dollars.
Using the average cost option, these values are added together and divided by three to obtain the average:
100 + 200 + 300 = 600/3 = 200.
The system has calculated that the next cost will be 200 dollars for this product.
Note: the system will calculate the next cost, but you must enter the cost price.
3 First in, first out (FIFO)
In this method of inventory calculation, products purchased first must be sold/used first.
For example: winter tires were purchased in January, February and March. The first to be sold must be those purchased in January. When they are sold, the tires bought in February will be used, and so on.
4 Last in, first out (LIFO)
In this method of calculating inventory, products purchased last must be sold/used first.
For example: winter tires were purchased in January, February and March. The first to be sold should be those purchased in March. When they run out, tires bought in February and then January will be used.
Posted 4 months agoby Olivier Brunel
#53988 viewsEdited 2 months ago