Topic: Bug in Inventory valuation Report or standard cost
Dear Developers of Front Accounting,
I am writing to inquire about the calculation of unit cost in the inventory valuation report of Front Accounting for a particular item in my inventory. The item in question is 105aps, and I have the following information:
Opening stock of 15 pieces purchased at a rate of 1,637.16
Purchase of 65 pieces at a rate of 1,708.85 in the last tax period
Purchase of 25 pieces at a rate of 2,034.51 in the last tax period
Currently, there are 9 pieces left in stock
I have noticed that the inventory valuation report in Front Accounting shows a unit cost of 1,776.15 for this item. However, I would like to understand how this unit cost is being calculated, including the purchasing prices, opening stock price, and inventory price, as well as the final unit value price.
Could you please provide me with a detailed explanation of the calculation method used to determine the unit cost in the inventory valuation report? I would greatly appreciate it if you could also provide a breakdown of the purchasing prices, opening stock price, and inventory price that contribute to the final unit value price.
Thank you for your time and assistance in this matter. I look forward to your response."