Ask a question on how to calculate costs?

qtreqytqy

The single purchase price of material A is 5 yuan, the quantity is 100, and the purchase price is 4.5 yuan. The quantity is 30. How to calculate the cost of receiving material A? What method is used? If you entered the wrong amount when you entered the warehouse, you later found that it was difficult to solve

shenmue024

It depends on what method the unit uses to calculate costs.

arbuliyerlu

I consulted my wife who was an accountant. She said that there are several algorithms such as weighted average (calculated once a month), moving weighted average (once each calculation), first-in, first-out, and last-in, first-out. The implementation depends on the actual situation. For example, if the purchase is frequent, the weighted average or moving weighted average algorithm should be used, otherwise the first-in-first-out or last-in-first-out algorithm is better.
I don't understand this, I hope the above can help you.

shenmue024

Last-in, first-out, first-in, first-out requires batch management.

shenmue024

Using a weighted average method is relatively simple.

qtreqytqy

Isn't it different to generate reports for the same period at different times using the weighted average method (average price is changing)
Calculate the average price every month. What if there is no storage in this month?
Last-in, last-out, first-in, first-out method.If you make a mistake and use it again, how can you correct it later?
How to achieve the database and back-end code? Just give an idea

qtreqytqy

I have thought about using a moving weighted average (once for each calculation) to create a field for the average price of materials. This field is updated for each entry, and an average price field (average price of materials at the time of receipt) is added to the receipt. I entered the wrong unit price for storage, how to deal with the error?

wanted

It depends on how the company's finances calculate costs
My land moving weighted average and batch cost

qtreqytqy

What's the implementation idea?
Do I need to choose a batch when I receive it? Or do I choose the batch in the background? But what happens if the quantity and unit price are wrong when I enter the warehouse?

qtreqytqy

Waiting online ...