Use fifo to create a perpetual inventory, Ex. 6-3
According to the data above, it is reasonable to assume that the stock would be less if the LIFO method was used. LIFO is an inventory valuation method used to measure the cost of goods sold and determine a company’s gross profit margin. The method assumes items are purchased in reverse chronology, with the most recently sold items first. It means that items that have been purchased for a high price are recorded as being sold first, thereby reducing the value of those items over time.
If a business has five units of product A, and one unit is purchased every month over a period of five months for $50, $40, $35, and $30, then the cost to sell this fifth unit would be only 30 dollars, instead 50, as would have happened if procedure was followed using FIFO, or First In, First Out, leading towards achieving monetary values higher than what would otherwise occur. As a result, using the last-in first out approach can help lower costs for businesses during transactions. But it may also cause issues with outdated inventory in stock values because of a lack of rotation during varying market conditions. It is ultimately up to individual businesses as they decide what method works for them based on the unique situations faced by their organization moving into future events that are yet to come.