Math Problem Statement
Scrappers Supplies tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31.
Transactions Units Unit Cost Beginning inventory, January 1 220 $ 26 Transactions during the year: a. Purchase on account, March 2 310 28 b. Cash sale, April 1 ($42 each) (370) c. Purchase on account, June 30 270 32 d. Cash sale, August 1 ($42 each) (90)
TIP: Although the purchases and sales are listed in chronological order, Scrappers determines the cost of goods sold after all of the purchases have occurred. a. Compute the cost of goods available for sale, cost of ending inventory, and cost of goods sold at December 31 using the LIFO method. (Round "Cost per Unit" anwers to 2 decimal places.)
Solution
To solve this problem, we will use the LIFO (Last-In, First-Out) inventory method to compute the following:
- Cost of Goods Available for Sale (COGAS)
- Cost of Ending Inventory
- Cost of Goods Sold (COGS)
Here's the step-by-step approach:
1. Calculate Cost of Goods Available for Sale (COGAS)
First, calculate the total units and cost of all purchases made throughout the year, including the beginning inventory.
Transaction | Units | Unit Cost | Total Cost |
---|---|---|---|
Beginning Inventory | 220 | $26 | 220 × 26 = $5,720 |
Purchase on March 2 | 310 | $28 | 310 × 28 = $8,680 |
Purchase on June 30 | 270 | $32 | 270 × 32 = $8,640 |
2. Cost of Ending Inventory
Using the LIFO method, we assume the most recent purchases are sold first. Therefore, the units remaining in the ending inventory come from the oldest purchases.
Total units sold:
The number of units sold during the year is:
Units in ending inventory:
The ending inventory consists of the oldest units (starting with the beginning inventory and then any remaining units from the earlier purchases).
- 220 units from the Beginning Inventory at $26 each
- The remaining 120 units (340 - 220) from the March 2 purchase at $28 each
3. Cost of Goods Sold (COGS)
Now, we calculate the COGS by subtracting the ending inventory cost from the total cost of goods available for sale.
Summary:
- Cost of Goods Available for Sale (COGAS): $23,040
- Cost of Ending Inventory: $9,080
- Cost of Goods Sold (COGS): $13,960
Would you like a more detailed breakdown of any part? Let me know if you have any questions!
Here are some related questions:
- How would the results differ using the FIFO method?
- What impact does the LIFO method have on taxes during periods of rising prices?
- Can LIFO or FIFO methods affect the company's profitability ratios?
- How would the valuation change if the company sold more units?
- What if the unit costs were to fluctuate more throughout the year?
Tip: In times of inflation, LIFO typically results in higher COGS and lower ending inventory, reducing taxable income.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Inventory Valuation
LIFO (Last In, First Out)
Cost of Goods Sold (COGS)
Ending Inventory
Cost of Goods Available for Sale (COGAS)
Formulas
COGAS = Beginning Inventory + Purchases during the year
COGS = COGAS - Ending Inventory Cost
Ending Inventory Cost = (Oldest units × unit cost) + (Remaining units × unit cost)
Theorems
LIFO Inventory Valuation Method
Suitable Grade Level
College/University (Accounting)
Related Recommendation
Calculating COGS Using Last-In, First-Out Method (LIFO) for June Sales
LIFO Inventory Valuation for Estcoast Purveyors – Calculating Ending Inventory
Ending Inventory Calculation Using Perpetual LIFO Method
Calculating COGS and Ending Inventory using LIFO for Alexandra's Boutique
Calculating Cost of Goods Sold Using LIFO for 100 Units in June