/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Problem 4 Inventory Costing Methods-Period... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Inventory Costing Methods-Periodic Method Spanner Company is a retailer that uses the periodic inventory system. On March 1, it had 100 units of product \(\mathrm{M}\) at a total cost of \(\$ 1,590\). On March 6, Spanner purchased 200 units of \(\mathrm{M}\) for \(\$ 3,600\). On March 10 , it purchased 125 units of \(\mathrm{M}\) for \(\$ 3,000\). On March 15, it sold 200 units of \(\mathrm{M}\) for \(\$ 6,000\). Calculate the March cost of goods sold and the ending inventory at March 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weightedaverage cost method, Round your final answers to the nearest dollar.

Short Answer

Expert verified
(a) FIFO: COGS = $3,390, Ending Inventory = $4,800 (b) LIFO: COGS = $4,350, Ending Inventory = $3,840 (c) Weighted Average: COGS = $3,854, Ending Inventory = $4,336

Step by step solution

01

Determine Unit Costs

**Calculate Unit Costs for Each Purchase**1. Initial Inventory on March 1: 100 units, Total cost = \(1,590 - Unit Cost = \( \frac{1590}{100} = 15.90 \)2. Purchase on March 6: 200 units, Total cost = \)3,600 - Unit Cost = \( \frac{3600}{200} = 18.00 \)3. Purchase on March 10: 125 units, Total cost = \(3,000 - Unit Cost = \( \frac{3000}{125} = 24.00 \)Now, we have unit costs: \)15.90, \(18.00, and \)24.00 respectively for each batch of inventory.
02

First-In, First-Out (FIFO)

**Calculate Cost of Goods Sold (COGS)** - Sold 200 units: - From March 1: 100 units at $15.90 = $1,590 - From March 6: 100 units at $18.00 = $1,800 - Total COGS = $1,590 + $1,800 = $3,390 **Ending Inventory Calculation** - Remaining 225 units: - From March 6: 100 units at $18.00 (not sold) = $1,800 - From March 10: 125 units at $24.00 = $3,000 - Total Ending Inventory = $1,800 + $3,000 = $4,800
03

Last-In, First-Out (LIFO)

**Calculate Cost of Goods Sold (COGS)** - Sold 200 units: - From March 10: 125 units at $24.00 = $3,000 - From March 6: 75 units at $18.00 = $1,350 - Total COGS = $3,000 + $1,350 = $4,350 **Ending Inventory Calculation** - Remaining 225 units: - From March 6: 125 units at $18.00 (unsold part) = $2,250 - From March 1: 100 units at $15.90 = $1,590 - Total Ending Inventory = $2,250 + $1,590 = $3,840
04

Weighted Average Cost Method

**Calculate Weighted Average Cost**- Total Units: 100 + 200 + 125 = 425 units- Total Cost: \(1,590 + \)3,600 + \(3,000 = \)8,190- Average Unit Cost = \( \frac{8190}{425} \approx 19.27 \) (rounded to two decimal places)**Calculate Cost of Goods Sold (COGS)**- Sold 200 units at \(19.27 = \( 200 \times 19.27 = 3,854 \) **Ending Inventory Calculation**- Remaining 225 units at \)19.27 = \( 225 \times 19.27 = 4,336 \) (rounded)

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

Periodic Inventory System
The periodic inventory system is a method used by businesses to measure and manage inventory levels at specific intervals, such as monthly or quarterly. Unlike the perpetual inventory system, the periodic method does not maintain a continuous record of inventory. Instead, it adjusts inventory balances at the end of each accounting period.

Businesses employing the periodic inventory system will physically count their inventory to determine the quantity on hand. This physical count is crucial because it allows companies to calculate the quantity of goods sold during the period. From there, they can calculate the Cost of Goods Sold (COGS) and the remaining inventory, also known as Ending Inventory, for the interval in question.
  • Ensures accurate reporting by aligning physical counts with financial records.
  • Offers simplicity and reduced record-keeping, ideal for smaller businesses.
  • Relies heavily on accurate period-end inventory counts for precision.
Cost of Goods Sold
Cost of Goods Sold (COGS) is a critical financial metric that represents the direct costs attributable to the production or purchase of the goods sold by a company. Calculating the COGS is essential for understanding the profitability of a business, as it directly impacts the gross profit.

To accurately determine the COGS in a periodic inventory system, one must tally the beginning inventory and purchases made during the period, subtracting the ending inventory from this total. This figure reflects the actual cost of items that were sold to customers during the given period.
  • Formula: COGS = Beginning Inventory + Purchases - Ending Inventory
  • Directly influences the net income of a company.
  • A higher COGS implies a lower gross profit unless balanced by increased sales volume or price.
Ending Inventory Calculation
Ending Inventory Calculation is the process of determining the value of the inventory that remains at the end of an accounting period. It is pivotal in inventory management as it influences both the cost of goods sold and the total asset value on a company's balance sheet.

Within a periodic inventory system, the ending inventory is computed after conducting a physical count of the remaining inventory. The value is then calculated based on the remaining units and their respective costs. This residual value represents the unsold goods that will be carried over to the next accounting period.
  • Helps in determining overall asset valuation.
  • Affects business planning and financial analysis.
  • Utilizes different costing methods like FIFO, LIFO, or Weighted Average.
First-In, First-Out (FIFO)
The First-In, First-Out (FIFO) method is an inventory valuation approach where it is assumed that the earliest (oldest) purchased or manufactured goods are sold first. This strategy is often used to ensure that older inventory is sold before it becomes obsolete.

In the context of periodic inventory management, FIFO can significantly affect the cost of goods sold and ending inventory valuation. When prices are rising, FIFO yields a lower COGS because the older, cheaper goods are recorded as being sold first. Consequently, this results in a higher ending inventory valuation.
  • Synchronized with real-world inventory flow for many businesses.
  • Tends to produce higher net income during periods of inflation.
  • Results in higher tax obligations when profits are greater due to lower COGS.
Last-In, First-Out (LIFO)
The Last-In, First-Out (LIFO) method assumes that the most recently acquired or produced inventory items are sold before older stock. This is contrary to the more natural flow of goods, often increasing the complexity of inventory management.

In a rising cost environment, LIFO potentially increases the cost of goods sold by attributing higher, more recent costs to current sales. This can lead to lower taxable income, but at the cost of a lower reported net income on financial statements. This method can also result in reduced ending inventory values as older, cheaper items remain in inventory.
  • Favored for tax reduction during inflationary periods.
  • Can lead to inventory becoming outdated, potentially increasing carrying costs.
  • May not align well with the physical flow of merchandise in most industries.
Weighted Average Cost Method
The Weighted Average Cost Method is an inventory valuation technique that blends the cost of goods available for sale, distributing this cost evenly among all units. This method calculates a single average cost for all units, simplifying the cost allocation process.

Under this approach in a periodic inventory system, the average price per unit is recalculated each time inventory is updated, either through purchase or production. This average cost is then used to determine both the cost of goods sold and the ending inventory. It is particularly useful in scenarios where inventory items are indistinguishable from each other.
  • Simplifies calculation by avoiding price change complexities.
  • Useful for companies with large volumes of similar products.
  • Provides a balanced approach between FIFO and LIFO, not heavily influenced by market price fluctuations.

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Inventory Costing Methods-Periodic Method Tally Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 120 units with a unit cost of \(\$ 330\). Transactions for this item during April were as follows: April 9 Purchased 40 units @ \(\$ 345\) per unit. 14 Sold 80 units @ \$550 per unit. 23 Purchased 20 units @ \(\$ 360\) per unit. 29 Sold 40 units@ \(\$ 550\) per unit. Required a. Calculate the cost of goods sold and the ending inventory cost for the month of April using the weighted-average cost method. Round the cost per unit to 3 decimal places and your final answers to the nearest dollar. b. Calculate the cost of goods sold and the ending inventory cost for the month of April using the first-in, first-out method. c. Calculate the cost of goods sold and the ending inventory cost for the month of April using the last-in, first-out method.

The Molly Company reports ending inventory under the LIFO method of \(\$ 15,000\). Had Molly used FIFO, the ending inventory would have been reported as \(\$ 16,500\). Molly's LIFO inventory reserve is: a. \(\$ 31,500\) b. \(\$ 15,000\) c. \(\$ 1,500\) d. \(91 \%\)

Lower-of-Cost-or-Net Realizable Value Method The McQuenny Company's ending inventory is composed of 100 units that had an acquisition cost of \(\$ 25\) per unit and 50 units that had an acquisition cost of \(\$ 30\) per unit. If 150 units have an NRV of \(\$ 27\) per unit, what value should be assigned to the company's ending inventory assuming that it applies the lower-of-cost-or-net realizable value method on an individual item basis?

Which of the following concepts relates to the elimination or minimization of inventories by a manufacturing firm? a. Quick response b. Just-in-time c. Just-in-case d. Specific identification

Goods in Transit Field Distributors sells merchandise to a variety of retailers. Field uses different freight terms with its various customers and suppliers. All sales are made on account. Required For each of the following transactions, indicate which company has ownership of the goods in transit: a. Field sold merchandise to Clay Boutique, with shipping terms of F.O.B. destination. b. Field purchased merchandise from Campbell Manufacturing Company, with freight terms of F.O.B. shipping point. c. Field sold merchandise to Save-A-Lot Stores, with shipping terms of F.O.B. shipping point. d. Field purchased merchandise from Central Manufacturing Company, with shipping terms of F.O.B. destination. e. Levinson Stores purchased merchandise from Field, with shipping terms of F.O.B. shipping point. f. Connor Manufacturing Company sold merchandise to Field, with shipping terms of F.O.B. shipping point.

See all solutions

Recommended explanations on Math Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.