Rifle Co. had the following inventory information available: Date Transactions Purchases Sales Units Unit Cost Units 1 Sep Beginning inventory 300 $100 3 Sep Purchases 100 $84 5 Sep Sales 250 10 Sep Purchases 250 $80 15 Sep Sales 200 20 Sep Purchases 250 $76 28 Sep Sales 150 Assume that the company uses LIFO method under the periodic inventory system to estimate cost of goods sold, please calculate the amount of ending inventory at the end of September
Question
Rifle Co. had the following inventory information available:
Date
Transactions
Purchases
Sales
Units
Unit Cost
Units
1 Sep
Beginning inventory
300
$100
3 Sep
Purchases
100
$84
5 Sep
Sales
250
10 Sep
Purchases
250
$80
15 Sep
Sales
200
20 Sep
Purchases
250
$76
28 Sep
Sales
150
Assume that the company uses LIFO method under the periodic inventory system to estimate cost of goods sold, please calculate the amount of ending inventory at the end of September
Solution
To calculate the ending inventory using the LIFO (Last-In, First-Out) method, we start by calculating the cost of goods sold (COGS) and then subtract that from the total cost of all goods available for sale.
Here's how to do it:
-
Calculate the total cost of all goods available for sale: This includes the beginning inventory and all purchases made during the month.
Beginning inventory: 300 units * 30,000 Purchases: (100 units * 80/unit) + (250 units * 8,400 + 19,000 = 30,000 + 77,400
-
Calculate the cost of goods sold (COGS) using the LIFO method: This means that we start with the last goods purchased and move backwards until we've accounted for all goods sold.
Sales: 250 units (5 Sep) + 200 units (15 Sep) + 150 units (28 Sep) = 600 units COGS: (250 units * 80/unit) + (150 units * 19,000 + 12,600 = $47,600
-
Subtract the COGS from the total cost of goods available for sale to get the ending inventory.
Ending inventory = Total cost of goods available for sale - COGS = 47,600 = $29,800
So, the ending inventory at the end of September is $29,800.
Similar Questions
Cost of goods sold and inventory (24 marks) Rifle Co. had the following inventory information available: Date Transactions Purchases Sales Units Unit Cost Units 1 Sep Beginning inventory 300 $100 3 Sep Purchases 100 $84 5 Sep Sales 250 10 Sep Purchases 250 $80 15 Sep Sales 200 20 Sep Purchases 250 $76 28 Sep Sales 150 (Q1-A). Assume that the company uses LIFO method under the perpetual inventory system to estimate cost of goods sold, please calculate the cost of sale for the month of September
Rifle Co. had the following inventory information available: Date Transactions Purchases Sales Units Unit Cost Units 1 Sep Beginning inventory 300 $100 3 Sep Purchases 100 $84 5 Sep Sales 250 10 Sep Purchases 250 $80 15 Sep Sales 200 20 Sep Purchases 250 $76 28 Sep Sales 150 Assume that the company uses Average Cost method under the periodic inventory system to estimate cost of goods sold, please calculate the amount of ending inventory at the end of September
A company's inventory records report the following in November of the current year: Date Activities Units Acquired at Cost Units Sold at RetailNovember 1 Beginning inventory 5 units @ $28 = $140 November 2 Purchase 10 units @ $30 = $300 November 8 Sales 12 units @ $62November 12 Purchase 6 units @ $33 = $198 Using the LIFO perpetual inventory method, what was the amount recorded in the cost of goods sold account for the 12 units sold?Multiple Choice$334$356$378$244$282
A company's inventory records indicate the following data for the month of January: Date Activities Units Acquired at Cost Units Sold at RetailJanuary 1 Beginning inventory 530 units @ $18 = $9,540 January 8 Purchase 510 units @ $20 = $10,200 January 12 Sale 940 units @ $70January 17 Purchase 570 units @ $22 = $12,540 January 23 Sale 385 units @ $70January 28 Purchase 630 units @ $24 = $15,120 If the company uses the LIFO perpetual inventory system, what would be the cost of the ending inventory?Multiple Choice$8,470.$20,990.$19,790.$25,300.$26,410.
Suppose this information (in millions) is available for the Automotive and Other Operations Divisions of General Motors Corporation for a recent year. General Motors uses the LIFO inventory method.Beginning inventory$15,860Ending inventory18,300Current assets73,444Current liabilities85,400Cost of goods sold203,252Sales revenue217,160(a)Calculate the inventory turnover and days in inventory. (Round answers to 1 decimal place, e.g. 52.7. Use 365 days for calculation.)Inventory Turnoverenter a number of times rounded to 1 decimal place timesDays in Inventoryenter a number of days rounded to 1 decimal place days
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.