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
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:
- Calculate the total cost of inventory at the beginning of the month: 300 units * 30,000
- Add the cost of the purchases made on September 3: 100 units * 8,400
- Calculate the new total cost of inventory: 8,400 = $38,400
- Calculate the new average cost per unit: 96/unit
- Calculate the cost of the sales made on September 5: 250 units * 24,000
- Subtract the cost of the sales from the total cost of inventory: 24,000 = $14,400
- Add the cost of the purchases made on September 10: 250 units * 20,000
- Calculate the new total cost of inventory: 20,000 = $34,400
- Calculate the new average cost per unit: 86/unit
- Calculate the cost of the sales made on September 15: 200 units * 17,200
- Subtract the cost of the sales from the total cost of inventory: 17,200 = $17,200
- Add the cost of the purchases made on September 20: 250 units * 19,000
- Calculate the new total cost of inventory: 19,000 = $36,200
- Calculate the new average cost per unit: 80.44/unit
- Calculate the cost of the sales made on September 28: 150 units * 12,066
- Subtract the cost of the sales from the total cost of inventory: 12,066 = $24,134
So, the cost of sale for the month of September is 17,200 (from the sales on September 15) + 53,266.
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
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.