Question

In: Accounting

During the year, Trombley Incorporated has the following inventory transactions.   Date Transaction Number of Units Unit...

During the year, Trombley Incorporated has the following inventory transactions.


  Date Transaction Number
of Units
Unit
Cost
   Total Cost
  Jan. 1      Beginning inventory 11      $ 13       $ 143    
  Mar. 4      Purchase 16      12       192    
  Jun. 9      Purchase 21      11       231    
  Nov. 11      Purchase 21      9       189    
69      $ 755    

For the entire year, the company sells 51 units of inventory for $21 each.

A: Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

B:Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit

C:Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Weighted-Average Cost per unit" to 2 decimal places.)

D: Which method will result in higher profitability when inventory costs are declining?

Solutions

Expert Solution

Part A FIFO
Cost of goods sold
FIFO Units   Unit cost Cost of goods sold
From beginning inventory            11                    13                            143
From first purchase            16                    12                            192
From second purchase            21                    11                            231
From third purchase              3                      9                              27
Total            51                            593
Ending inventory
From third purchase            18                      9                            162
Ending inventory units = (11+16+21+21-51) = 18 units
Sales value = (51*21) = 1,071
Gross profit = (Sales value-Cost of goods sold) = (1,071-593) = 478
Part B LIFO
Cost of goods sold
FIFO Units   Unit cost Cost of goods sold
From third purchase            21                      9                            189
From second purchase            21                    11                            231
From first purchase              9                    12                            108
Total            51                            528
Ending inventory
From first purchase              7                    12                              84
From beginning inventory            11                    13                            143
           18                            227
Sales value = (51*21) = 1,071
Gross profit = (Sales value-Cost of goods sold) = (1,071-528) = 543
Part C Weighted average
Units Average cost Total
Cost of goods sold            51               10.94                            558
Ending inventory            18               10.94                            197
Sales value = (51*21) = 1,071
Gross profit = (Sales value-Cost of goods sold) = (1,071-558) = 513
Average cost
           11                                        13          143
           16                                        12          192
           21                                        11          231
           21                                          9          189
           69          755
Average cost = (755 / 69) = 10.94
Part D LIFO will result in higher profitability of $543 when inventory costs are declining.

Related Solutions

During the year, Trombley Incorporated has the following inventory transactions.   Date Transaction Number of Units Unit...
During the year, Trombley Incorporated has the following inventory transactions.   Date Transaction Number of Units Unit Cost    Total Cost   Jan. 1      Beginning inventory 16      $ 18       $ 288       Mar. 4      Purchase 21      17       357       Jun. 9      Purchase 26      16       416       Nov. 11      Purchase 26      14       364     89      $ 1,425         For the entire year, the company sells 69 units of inventory for $26 each. 1. Using...
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit...
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 54 $ 46 $ 2,484 Apr. 7 Purchase 134 48 6,432 Jul. 16 Purchase 204 51 10,404 Oct. 6 Purchase 114 52 5,928 506 $ 25,248 For the entire year, the company sells 440 units of inventory for $64 each. 3. Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round...
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit...
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 49 $ 41 $ 2,009 Apr. 7 Purchase 129 43 5,547 Jul. 16 Purchase 199 46 9,154 Oct. 6 Purchase 109 47 5,123 486 $ 21,833 For the entire year, the company sells 428 units of inventory for $59 each. Required: 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
The inventory transactions of VTS Corporation are shown below. Date Transaction Number of Units Unit Cost/Price...
The inventory transactions of VTS Corporation are shown below. Date Transaction Number of Units Unit Cost/Price Jan. 1 Beginning inventory 500 $ 10 Feb. 25 Sale 300 20 May 21 Purchase 400 12 Jul. 15 Purchase 500 15 Dec. 10 Sale 800 20 All purchase/sale transactions are made on credit. The company uses the FIFO method and perpetual inventory system to record transactions. What is the amount of LIFO adjustment needed to adjust FIFO inventory records reported for the year...
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr....
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr. 1 Beginning inventory 500 $2.40 Apr. 20 Purchase 400 $2.50 The company sold 700 units of inventory during the month. Cost of goods sold assuming FIFO would be: a. $1,690 b. $1,720. c. $1,700. d. $1,730. e. $1,710. If management can estimate the amount of loss that will occur due to litigation against the company, and the likelihood of the loss is reasonably possible,...
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 960 $7.15 Mar. 10 Purchase 540 7.65 Mar. 16 Purchase 395 8.25 Mar. 23 Purchase 530 8.95 Marvin sold 1,790 units of inventory during the month. Ending inventory assuming FIFO would be (Do not round your intermediate calculations. Round your answer to the nearest dollar amount): $5,610 $1,156 $6,864 $1,541
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 1,000 $ 7.26 Mar. 10 Purchase 540 7.71 Mar. 16 Purchase 760 8.14 Mar. 23 Purchase 590 8.54 Marvin sold 1,910 units of inventory during the month. Cost of goods sold assuming FIFO would be:
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar. 1 Beginning inventory 1,070    $7.29      Mar. 10 Purchase 580    7.79      Mar. 16 Purchase 445    8.39      Mar. 23 Purchase 550    9.09    Marvin sold 1,960 units of inventory during the month. Ending inventory assuming FIFO would be
37. Inventory records for MOM Company revealed the following: Date Transaction Number of Units Unit Cost...
37. Inventory records for MOM Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 200 $66.00 Mar. 6 Purchase 1,000 $66.50 Mar. 16 Purchase 1,000 $66.80 Mar. 23 Purchase 1,000 $66.90 MOM sold 3,190 units of inventory during the month. Ending inventory assuming FIFO would be $______________ 38. Inventory records for STC Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 100 $25.00 Mar. 3 Purchase 500 $25.50...
Garrett Company has the following transactions during the months of April and May: Date Transaction Units...
Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 300       17 Purchase 200 $5.10       25 Sale 150       28 Purchase 100 5.80 May 5 Purchase 250 5.10       18 Sale 300       22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: 1. Compute the inventories at the end of each month and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT