Problem 7 - Accounting

Question

The following units of a particular item were available for sale during the year: \(\begin{array}{ll}\text { Beginning inventory } & 150 \text { units at } \$ 75 \\\ \text { Sale } & 120 \text { units at } \$ 125 \\ \text { First purchase } & 400 \text { units at } \$ 78 \\ \text { Sale } & 200 \text { units at } \$ 125 \\ \text { Second purchase } & 300 \text { units at } \$ 80 \\ \text { Sale } & 290 \text { units at } \$ 125\end{array}\) The firm uses the perpetual inventory system, and there are 240 units of the item on hand at the end of the year. What is the total cost of the ending inventory according to (a) FIFO, (b) LIFO?

Step-by-Step Solution

Answer

FIFO: $19,200; LIFO: $18,270.

Step 1: Determine Total Available Units

First, we will calculate the total units available for sale throughout the year. Add the beginning inventory and all the purchases:\[ 150 + 400 + 300 = 850 \] So, there are 850 units available.

Step 2: Calculate Total Units Sold

Next, sum up the units sold:\[ 120 + 200 + 290 = 610 \] So, 610 units were sold.

Step 3: Calculate Ending Inventory Units

Subtract the total units sold from the total available units to find the ending inventory units:\[ 850 - 610 = 240 \] Hence, there are 240 units in ending inventory.

Step 4: Apply FIFO for Ending Inventory Cost

For FIFO, we use the newest costs for unsold inventory. Since there are 240 units unsold:- 240 units from the second purchase at \(80 each. Thus, the total cost using FIFO:\[ 240 \times 80 = \\)19,200 \]

Step 5: Apply LIFO for Ending Inventory Cost

For LIFO, we use the oldest costs for unsold inventory. From the beginning inventory and first purchase, we have:- 150 units from beginning inventory at \(75 each.- 90 units from the first purchase at \)78 each.Calculating:- Cost from beginning inventory: \[ 150 \times 75 = \\(11,250 \]- Cost from first purchase: \[ 90 \times 78 = \\)7,020 \]Thus, the total cost using LIFO:\[ 11,250 + 7,020 = \$18,270 \]

Key Concepts

FIFO Method

The FIFO method stands for "First-In, First-Out." It's a way businesses track and report inventory, basing it on the assumption that the oldest inventory items are sold first. When using FIFO, you effectively move the earliest purchased items out of your stock and assign their cost to the cost of goods sold. This is straightforward and often reflects reality in many businesses.

For example, say a company starts with 150 units purchased at $75 each. If they use FIFO, once these are sold, they begin selling the next batch of 400 units at $78 each. The leftover unsold units, during calculations, will reflect these newer costs.

FIFO is beneficial during times of rising prices. Since the older, cheaper inventory is deemed sold first, it often results in lower cost of goods sold, higher income, and therefore better tax scenarios. However, the downside may be that the ending inventory value can sometimes seem inflated, not matching the current market prices.

LIFO Method

LIFO, or "Last-In, First-Out," operates on the principle that the most recently acquired inventory is used to determine the cost of goods sold first. This approach is widely used when companies want to match current costs with current revenues.

Suppose a business acquires 300 units at $80 each later in the year. Under LIFO, when sales occur, these $80 units are considered sold before any older inventory. This can lead to differing financial implications.

In periods of inflation, LIFO could lead to a higher cost of goods sold because you are selling the more expensive, newer inventory first. This means lower reported profits, which could result in lower taxes. However, the ending inventory value might appear outdated, reflecting older prices, which is not always ideal for financial statements.

Perpetual Inventory System

The perpetual inventory system is a method that keeps continuous track of inventory balances. Whenever items are received or sold, the inventory amounts update instantly. This approach is precise and can help businesses monitor their stock levels in real time.

This system uses technologies like barcoding and RFID to ensure every inventory transaction's accuracy. It's advantageous because it allows immediate feedback on inventory changes and supports better decision-making.

However, it does require an investment in technology and maintenance of accurate records, which can be a bit more complex and costly than periodic inventory systems. A reliable perpetual system helps businesses avoid overstocking or stockouts, which could disrupt sales and operations.

Cost of Goods Sold

The cost of goods sold (COGS) is a crucial metric that describes the direct costs associated with producing the goods a company sells. It includes the cost of materials and labor directly tied to production.Calculating COGS is vital for business operations and financial reporting. It helps determine the gross margin and profitability of a company. Companies need to track this accurately to understand their true cost of goods, ultimately giving insights into pricing and sales strategies.

A simple formula to calculate COGS is:\[\text{COGS} = \text{Beginning Inventory} + \text{Purchases} - \text{Ending Inventory}\]Understanding the COGS helps businesses adjust pricing, manage expenses, and forecast future spending effectively.