Supplemental LIFO disclosures; LIFO reserve; AEP Industries
• LO8–6
Real World Financials
AEP Industries Inc. is a leading manufacturer of plastic packing films. The company uses the LIFO inventory method for external reporting but maintains its internal records using FIFO. The following disclosure note was included in a recent quarterly report:
4. Inventories (in part)
Inventories are comprised of the following ($ in thousands):
January 31, 2016 | October 31, 2015 | |
Raw materials | $ 42,881 | $ 47,593 |
Finished goods | 71,547 | 66,484 |
Supplies | 5,240 | 5,280 |
119,668 | 119,357 | |
Less: LIFO reserve | (13,655) | (18,093) |
Inventories (under LIFO) | $106,013 | $101,264 |
The company’s income statements reported cost of goods sold of $209,826 thousand for the quarter ended January 31, 2016.
Required:
1. Assume that AEP adjusts the LIFO reserve at the end of its quarter. Prepare the January 31, 2016,
2. If AEP had used FIFO to value its inventories, what would cost of goods sold have been for the quarter ended January 31, 2016?
Trending nowThis is a popular solution!
Chapter 8 Solutions
Intermediate Accounting
- Problem 8-15 (Algo) Dollar-value LIFO [LOB-8] On January 1, 2024, a company adopted the dollar-value LIFO inventory method. The inventory value for its one inventory pool on this date was $270,000. An internally generated cost index is used to convert ending inventory to bese year. Year-end Inventories at year- end costs and cost indexes for its one inventory pool were as follows: Year Ended December 31 2024 2025 2026 Inventory Year- Cost Index (Relative End Costs $354,640 365,040 413,110 141,840 to Base Year) 1.04 1.08 1.09 Required: Calculate inventory amounts at the end of each year Note: Round intermediate calculations and final answers to the nearest whole dollars. Date Inventory Layers Converted to Base Year Cost Inventory at Year-End Inventory Cost Index Layers at Base Year Cost Year-End Cost 01012024 12/31/2024 12012025 12012026 Inventory Layers Converted to Cost Inventory DVL Cost Inventory Layers at Year- Inventory End Cost Layers Converted to Cost Index Cost Base 2024 Base…arrow_forwardQS 13-12 (Algo) Computing inventory turnover and days' sales in inventory LO P3 SCC Company reported the following for the current year: Net sales $ 52,000 Cost of goods sold Beginning balance in inventory Ending balance in inventory 45,900 2,400 8,400 Compute (a) inventory turnover and (b) days' sales in inventory. Hint. Inventory turnover uses average inventory and days' sales in inventory uses the ending balance in inventory. Complete this question by entering your answers in the tabs below. Days Sales In Inventory Inventory Turnover Compute the inventory turnover. Inventory Turnover Numerator: Denominator: Inventory Turnover Inventory turnover %3D times %3Darrow_forwardOMANTEL El GOD O©41% 9:12 18 Muscat Company uses the periodic inventory system to account for inventories. Information related to Muscat Company's inventory for the month of January 2020 is given as follows: Units Per unit price Total Balance, 1/1/20 200 OMR 5.00 Purchase, 1/15/2020 100 5.30 Purchase, 1/28/2020 100 5.50 The physical inventory count on January 31 shows 120 units are on hand. Using the FIFO method, what is the cost of goods sold? IIarrow_forward
- SM1arrow_forwardExercise 8-14 (Algo) Inventory cost flow methods; perpetual system [LO8-1, 8-4] [The following information applies to the questions displayed below.] Altira Corporation provides the following information related to its inventory during the month of August 2024: August 1 Inventory on hand-2,900 units; cost $7.00 each. August 8 Purchased 14,500 units for $6.40 each. Sold 11,600 units for Purchased 8,700 units August 14 $12.90 each. August 18 for $6.00 each. August 25 Sold 10,600 units for $11.90 each. August 28 Purchased 4,900 units for $5.80 each. August 31 Inventory on hand-8,800 units. Exercise 8-14 (Algo) Part 1 Required: 1. Using calculations based on a perpetual inventory system, determine the inventory balance Altira would report in its August 31, 2024, balance sheet and the cost of goods sold it would report in its August 2024 income statement using the FIFO method. Perpetual FIFO: Beginning Inventory Purchases: August 8 August 18 August 28 Total Cost of Goods Available for Sale…arrow_forward7-52 Chapter 7 Inventories: Cost Measurement and Flow Assumptions P7-13 Dollar-Value LIFO Kwestel Company adopted the dollar-value LIFO method for inventory valuation at the be- ginning of 2015. The following information about the inventory at the end of cach year is available from Kwestel's records: LO 7.7 Year Current Cost Index $ 8,000 10,800 11,500 14,000 10,500 2014 100 120 2015 2016 130 145 2017 2018 125 Required: Calculate the dollar-value LIFO inventory at the end of each year. Round to the nearest dollar.arrow_forward
- Exercise 8-26 (Algo) Dollar-value LIFO [LO8-8] On January 1, 2024, a Company adopted the dollar-value LIFO method for its one inventory pool. The pool's value on this date was $670,000. The 2024 and 2025 ending inventory valued at year-end costs were $714,000 and $795,000, respectively. The appropriate cost indexes are 1.05 for 2024 and 1.06 for 2025. Required: Complete the below table to calculate the inventory value at the end of 2024 and 2025 using the dollar-value LIFO method. Note: Round "Year end cost index" to 2 decimal places. Round other final answer values to the nearest whole dollars. Date 01/01/2024 12/31/2024 12/31/2025 Inventory Layers Converted to Base Year Cost Inventory at Year-End Cost Year-End Cost Index = = = Inventory Layers at Base Year Cost Base Base 2024 Base 2024 2025 Inventory Layers Converted to Cost Inventory Layers at Base Year Cost Year-End Cost Index = = = = = Inventory Layers Converted to Cost Inventory DVL Cost S S S 0 0 0arrow_forwardE7-7 Analyzing and Interpreting the Financial Statement Effects of FIFO, LIFO, and Weighted Average Cost [LO 7-3] Scoresby Inc. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year, 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 a. Inventory, Beginning 1,500 $ 28 For the year: b. Purchase, March 5 7,500 29 c. Purchase, September 19 3,500 31 d. Sale, April 15 (sold for $73 per unit) 2,200 e. Sale, October 31 (sold for $76 per unit) 6,500 f. Operating expenses (excluding income tax expense), $398,000 Required: 1. Calculate the number and cost of goods available for sale. 2. Calculate the number of units in ending inventory. 3. Compute the cost of ending inventory and…arrow_forwardP 8-14 Dollar-value LIFO LO8-8 Kingston Company uses the dollar-value LIFO method of computing inventory. An external price index is used to convert ending inventory to base year. The company began operations on January 1, 2018, with an inventory of $150,000. Year-end inventories at year-end costs and cost indexes for its one inventory pool were as follows: Year Ended December 31 2018 2019 2020 2021 Ending Inventory at Year-End Costs $200,000 245,700 235,980 228,800 Cost Index (Relative to Base Year) 1.08 1.17 1.14 1.10 Required: Calculate inventory amounts at the end of each year.arrow_forward
- 11arrow_forwardExercise 8-19 (Static) Perpetual FIFO adjusted to periodic LIFO; LIFO reserve [LO8-1, 8-4, 8-6] To more efficiently manage its inventory, Treynor Corporation maintains its internal inventory records using first-in, first-out (FIFO) under a perpetual inventory system. The following information relates to its merchandise inventory during the year: Jan. 1 Inventory on hand—20,000 units; cost $12.20 each. Feb. 12 Purchased 70,000 units for $12.50 each. Apr. 30 Sold 50,000 units for $20.00 each. Jul. 22 Purchased 50,000 units for $12.80 each. Sep. 9 Sold 70,000 units for $20.00 each. Nov. 17 Purchased 40,000 units for $13.20 each. Dec. 31 Inventory on hand—60,000 units. Required:1. Determine the amount Treynor would calculate internally for ending inventory and cost of goods sold using first-in, first-out (FIFO) under a perpetual inventory system.2. Determine the amount Treynor would report externally for ending inventory and cost of goods…arrow_forwardMcGraw-Hill Connect crcises Saved Exercise 6-4A Calculate inventory amounts when costs are rising (LO6-3) [The following information applies to the questions displayed below.] During the year, TRC Corporation has the following inventory transactions. Number of Unit Cost $ 43 45 48 Transaction Date Jan. 1 Beginning inventory Apr. 7 Purchase Jul. 16 Purchase Units Total Cost $ 2,193 5,895 9,648 5,439 51 131 201 Oct. 6 Purchase 111 49 :16 494 $23,175 For the entire year, the company sells 431 units of inventory for $61 each. ok Exercise 6-4A Part 1 nt Required: 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. rint FIFO Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Cost of Goods Available for Sale # of units Cost per unit Cost per unit Cost of Goods Ending per unit Inventory erences Cost # of units # of units Sold Beginning Inventory Purchases: Apг. 7 Jul.16 Oct.6 Total MacBook Pro C@ #3 & 关 2 4. 5 7 8 W E Y < 6arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning