Knowee
Questions
Features
Study Tools

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

...expand
🧐 Not the exact question you are looking for?Go ask a question

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:

  1. 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 * 100/unit=100/unit = 30,000 Purchases: (100 units * 84/unit)+(250units84/unit) + (250 units * 80/unit) + (250 units * 76/unit)=76/unit) = 8,400 + 20,000+20,000 + 19,000 = 47,400Totalcostofgoodsavailableforsale=47,400 Total cost of goods available for sale = 30,000 + 47,400=47,400 = 77,400

  2. 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 * 76/unit)+(200units76/unit) + (200 units * 80/unit) + (150 units * 84/unit)=84/unit) = 19,000 + 16,000+16,000 + 12,600 = $47,600

  3. 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 = 77,40077,400 - 47,600 = $29,800

So, the ending inventory at the end of September is $29,800.

This problem has been solved

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

1/3

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.