In: Accounting
In 2018, Rogan LLC had the following information related to sales and inventory. Rogan uses a perpetual inventory system and the FIFO cost method. All sales and inventory purchases are on account.
On January 1, 2018, Rogan reported:
Inventory $30,000 (3,000 units at a cost of $10/unit)
In 2018, Rogan had the following inventory transactions (in chronological order):
Purchased, on account, 5,000 units at a cost of $12/unit.
Sold, on account, 6,000 units at a selling price of $25/unit; terms included sales discount.
Received $135,000 on account from customers who owed $140,000; $5,000 taken in discounts.
Purchased, on account, 8,000 units at a cost of $15/unit.
Sold, on account, 9,000 units at a selling price of $30/unit; terms included sales discount.
Received $250,000 on account from customers who owed $260,000; $10,000 taken in discounts
Requirement 1: Record the 2018 inventory transactions.
Requirement 2: Determine 2018 net sales.
Requirement 3: Determine 2018 gross profit.
Requirement 4: Determine the 12-31-18 balances for Accounts Receivable and Inventory.
Solution 1:
| Journal Entries - Rogan LLC | |||
| Event | Particulars | Debit | Credit | 
| 1 | Inventory Dr | $60,000.00 | |
| To Accounts Payable (5000*$12) | $60,000.00 | ||
| (To record purchase of inventory on account) | |||
| 2a | Accounts receivables Dr (6000*$25) | $150,000.00 | |
| To Sales revenue | $150,000.00 | ||
| (To record sales) | |||
| 2b | Cost of goods sold Dr (3000*$10 + 3000*$12) | $66,000.00 | |
| To Inventory | $66,000.00 | ||
| (To record COGS) | |||
| 3 | Cash Dr | $135,000.00 | |
| Sales Discount Dr | $5,000.00 | ||
| To Accounts receivables | $140,000.00 | ||
| (To record collection from customer) | |||
| 4 | Inventory Dr | $120,000.00 | |
| To Accounts Payable (8000*$15) | $120,000.00 | ||
| (To record purchase of inventory on account) | |||
| 5a | Accounts receivables Dr (9000*$30) | $270,000.00 | |
| To Sales revenue | $270,000.00 | ||
| (To record sales) | |||
| 5b | Cost of goods sold Dr (2000*$12 + 7000*$15) | $129,000.00 | |
| To Inventory | $129,000.00 | ||
| (To record COGS) | |||
| 6 | Cash Dr | $250,000.00 | |
| Sales Discount Dr | $10,000.00 | ||
| To Accounts receivables | $260,000.00 | ||
| (To record collection from customer) | |||
Solution 2:
2018 net sales = Sales - Sales discounts
= $150,000 + $270,000 - ($5,000 +$10,000) = $405,000
Solution 3:
Cost of goods sold = $66,000 + $129,000 =$195,000
Gross profit = Net sales - COGS = $405,000 - $195,000 = $210,000
Solution 4:
Accounts receivable on 31.12.2018 = $150,000 + $270,000 - $140,000 - $260,000 = $20,000
Inventory balance on 31.12.2018 = Beginning inventory + Purchases - COGS
= $30,000 + $60,000 + $120,000 - $195,000 = $15,000