Question

In: Accounting

In 2018, Rogan LLC had the following information related to sales and inventory. Rogan uses a...

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.

Solutions

Expert Solution

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


Related Solutions

Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available:
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available:Aug. 1 Inventory on hand - 10,500 units; cost $8.80 each8 Purchased 30,000 units for $7.50 each14 Sold 21,000 units for $14.00 each18 Purchased 16,000 units for $7.00 each25 Sold 20,000 units for $13.00 each31 Inventory on hand - 15,500 unitsRequired: Determine the inventory balance Altira would report in it's August 31, 2018, balance sheet and the cost...
Easton Company uses the periodic inventory system and had the following inventory & sales activity for...
Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 130 $10 5/5 Purchase 210 $12 5/15 Purchase 350 $14 5/25 Purchase 310 $16 Sales were 470 units at $20.  Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for...
Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $12.00 5/5 Purchase 200 $10.50 5/10 Sales 300 $25 5/15 Purchase 200 $13.00 5/20 Sales 250 $28 5/25 Purchase 150 $13.50 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent.
Alpha Company uses the periodic inventory system and had the following inventory & sales activity for...
Alpha Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2016: Date Activity Quantity Unit Price 5/1 Beginning Inventory 150 $10 5/5 Purchase 200 $12 5/15 Purchase 300 $14 5/25 Purchase 150 $16 Sales were 525 units at $20.  Using the LIFO method, determine the dollar values following for the month of May: 1. Ending Inventory 2. Cost of Goods Available for Sale 3. Cost of Goods Sold
XYZ Company recorded the following information related to their inventory accounts for 2018: January 1, 2018...
XYZ Company recorded the following information related to their inventory accounts for 2018: January 1, 2018 December 31, 2018 Direct materials 10,000 17,000 Work in process 11,000 ? Finished goods 16,000 9,000 Additional information is as follows: Direct materials purchased .......... $19,000 Direct labor ........................ 15,000 Actual manufacturing overhead ....... 16,000 Applied manufacturing overhead ...... 14,000 Net income .......................... 20,000 S&A expenses ........................ 30,000 Sales revenue ....................... 90,000 Calculate the work in process inventory balance on December 31.
Calvin Company uses a periodic inventory system. They had the following information concerning their inventory for...
Calvin Company uses a periodic inventory system. They had the following information concerning their inventory for the month of March. Units Cost Per Unit Beginning Inventory (March 1) 250 $12 Purchase (March 25th) 130 $13 Purchase (March 28th) 285 $15 Sale (March 30th) 350 1. If the company uses a FIFO inventory method, what will be COST OF GOODS SOLD for the month of March? (please only enter positive numbers) Use the same information as for Question 1 If the...
Happy Company uses the periodic inventory method and had the following inventory information available:                          
Happy Company uses the periodic inventory method and had the following inventory information available:                                                              Units       Unit Cost           Total Cost 1/1       Beginning Inventory               100                  $4                    $400 1/20     Purchase                                  400                  $6                    $2400 7/25     Purchase                                  200                  $7                    $1400 10/20   Purchase                                  300                  $8                    $2400 1,000                                      $6,600 A physical county if inventory on December 31 revealed that there were 400 units on hand Answer questions below and show computations supporting the answer: Assume that the company uses the FIFO...
3. Easton Company uses the periodic inventory system and had the following inventory & sales activity...
3. Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 100 $10 5/5 Purchase 240 $12 5/15 Purchase 270 $14 5/25 Purchase 320 $16 Sales were 430 units at $20. Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8 points) Date Explanation Number of Units Unit Cost Total Cost January 1 Beginning inventory 100 $4 $400 January 20 Purchase 400 $5 $2,000 July 25 Purchase 300 $6 $1,800 October 20 Purchase 200 $7 $1,400 Total 1000 $5,600 A physical count of inventory on December 31 revealed that there were 300 units on hand. Assume that the company uses the FIFO method. The Ending...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8...
Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8 points) Date Explanation Number of Units Unit Cost Total Cost January 1 Beginning inventory 100 $4 $400 January 20 Purchase 400 $5 $2,000 July 25 Purchase 300 $6 $1,800 October 20 Purchase 200 $7 $1,400 Total 1000 $5,600 A physical count of inventory on December 31 revealed that there were 300 units on hand. Assume that the company uses the FIFO method. The Ending...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT