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 Average Cost method under the perpetual inventory system to estimate cost of goods sold, please calculate the cost of sale for the month 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 Average Cost method under the perpetual inventory system to estimate cost of goods sold, please calculate the cost of sale for the month of September

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

Solution

To calculate the cost of sale for the month of September using the Average Cost method under the perpetual inventory system, we need to calculate the average cost per unit for each purchase and sale transaction.

Here's how to do it:

  1. Calculate the total cost of inventory at the beginning of the month: 300 units * 100/unit=100/unit = 30,000
  2. Add the cost of the purchases made on September 3: 100 units * 84/unit=84/unit = 8,400
  3. Calculate the new total cost of inventory: 30,000+30,000 + 8,400 = $38,400
  4. Calculate the new average cost per unit: 38,400/400units=38,400 / 400 units = 96/unit
  5. Calculate the cost of the sales made on September 5: 250 units * 96/unit=96/unit = 24,000
  6. Subtract the cost of the sales from the total cost of inventory: 38,40038,400 - 24,000 = $14,400
  7. Add the cost of the purchases made on September 10: 250 units * 80/unit=80/unit = 20,000
  8. Calculate the new total cost of inventory: 14,400+14,400 + 20,000 = $34,400
  9. Calculate the new average cost per unit: 34,400/400units=34,400 / 400 units = 86/unit
  10. Calculate the cost of the sales made on September 15: 200 units * 86/unit=86/unit = 17,200
  11. Subtract the cost of the sales from the total cost of inventory: 34,40034,400 - 17,200 = $17,200
  12. Add the cost of the purchases made on September 20: 250 units * 76/unit=76/unit = 19,000
  13. Calculate the new total cost of inventory: 17,200+17,200 + 19,000 = $36,200
  14. Calculate the new average cost per unit: 36,200/450units=36,200 / 450 units = 80.44/unit
  15. Calculate the cost of the sales made on September 28: 150 units * 80.44/unit=80.44/unit = 12,066
  16. Subtract the cost of the sales from the total cost of inventory: 36,20036,200 - 12,066 = $24,134

So, the cost of sale for the month of September is 24,000(fromthesalesonSeptember5)+24,000 (from the sales on September 5) + 17,200 (from the sales on September 15) + 12,066(fromthesalesonSeptember28)=12,066 (from the sales on September 28) = 53,266.

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

Assuming the periodic inventory method is used for the current year, the following data were taken from the accounting records:Sales                                                   $900,000Sales returns and allowances              $  30,000Purchases                                            $500,000Purchase returns and allowances        $    8,000Discount received                               $    4,000Freight-in                                            $    2,000Beginning inventory                           $  90,000Ending inventory                                $130,000What was the cost of goods available for sale?

Assume that J-Mart uses a perpetual weighted average inventory system. During the period, it had two sales. Calculate the average cost per unit on hand as of June 8 when it made its first sale.  DateItemUnits/CostJun 1Beginning Inventory10 @ $12Jun 5Purchase10 @ $15Jun 8Sale6 unitsJun 28Purchase10 @ $18Jun 30Sale8 unitsMultiple choice question.$15/unit$33/unit$13.50/unit$10/unit

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.