Stock: Profit Calculator cost not the same as my purchase cost (FIFO Item)
Question: I have created an Invoice and when I view the profit calculator, the unit cost of the item AA (FIFO costing method) shown is different from my purchase cost. Previously I purchased with RM 11 and RM 11.50 but now profit calculator shows RM 11.1667. Why?
Version: 1.8 / 1.9 / 2.0
Answer:
The stock out (3 qty) has different cost value each. The system shows the average cost (of 3 qty) in Profit Calculator’s unit cost.
You may refer to the stock card and click on “+” sign to expand the detail of FIFO cost.
From stock card, notice that it is separated into 2 lines. This is because stock out (3 qty) has different cost value: 2 qty with cost RM 11, and 1 qty with cost RM 11.50.
2 * 11 = RM 22
1 * 11.50 = RM 11.50
Total Cost = RM 33.50
Average Cost
= Total Cost / Total Qty
= 33.50 / 3
= 11.1667
By: Tian Neng 230103, Lay Swan 230113, P230126
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|