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 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 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

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

Solution

To calculate the ending inventory using the Average Cost method under the periodic inventory system, we first need to calculate the total cost of goods available for sale and the total units available for sale.

  1. Calculate the total cost of goods available for sale:

    Beginning inventory: 300 units * 100=100 = 30,000 Purchases on 3 Sep: 100 units * 84=84 = 8,400 Purchases on 10 Sep: 250 units * 80=80 = 20,000 Purchases on 20 Sep: 250 units * 76=76 = 19,000

    Total cost of goods available for sale = 30,000+30,000 + 8,400 + 20,000+20,000 + 19,000 = $77,400

  2. Calculate the total units available for sale:

    Beginning inventory: 300 units Purchases on 3 Sep: 100 units Purchases on 10 Sep: 250 units Purchases on 20 Sep: 250 units

    Total units available for sale = 300 + 100 + 250 + 250 = 900 units

  3. Calculate the average cost per unit:

    Average cost per unit = Total cost of goods available for sale / Total units available for sale = 77,400/900=77,400 / 900 = 86

  4. Calculate the cost of goods sold:

    Total units sold = 250 (on 5 Sep) + 200 (on 15 Sep) + 150 (on 28 Sep) = 600 units Cost of goods sold = Total units sold * Average cost per unit = 600 * 86=86 = 51,600

  5. Calculate the ending inventory:

    Ending inventory = Total cost of goods available for sale - Cost of goods sold = 77,40077,400 - 51,600 = $25,800

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

This problem has been solved

Similar Questions

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

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?

A company's inventory records report the following: Date Activities Units Acquired at Cost Units Sold at RetailAugust 1 Beginning inventory 15 units @ $38 = $570  August 5 Purchase 10 units @ $39 = $390  August 12 Purchase 20 units @ $40 = $800  August 15 Sales   30 units soldUsing the FIFO perpetual inventory method, what is the value of the inventory at August 15 after the sale?Multiple Choice$400$290$600$1,160$1,760

An entity just starting business made the following four inventory purchases in June:            June     1          150 units                     $1,500            June     10        130 units                       1,170            June     15        90 units                         1,260            June     23        110 units                          990                                                                        $4,920A physical count of inventory on June 30 reveals that there are 20 units on hand. Using the weighted average cost method the amount allocated to the ending inventory on June 30 is:Question 5Answera.$205b.$180c.$220d.$200

Periodic inventory using FIFO, LIFO, and weighted average cost methods The units of an item available for sale during the year were as follows: Date Line Item Description Units Cost per Unit Amount Jan. 1 Inventory 16 units at $34 $544 Aug. 13 Purchase 7 units at $36 252 Nov. 30 Purchase 7 units at $37 259 Available for sale 30 units $1,055 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar).

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.