Exercise 6-4A Calculate inventory amounts when costs are rising (LO6-3) [The following information applies to the questions displayed below.] During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 45 $ 37 $ 1,665 Apr. 7 Purchase 125 39 4,875 Jul. 16 Purchase 195 42 8,190 Oct. 6 Purchase 105 43 4,515 470 $ 19,245

1. Ending inventory = $2,408; Cost of goods sold = $16,837; Sales revenue = $22,770; and Gross profit = $5,933.

2. Ending inventory = $2,094; Cost of goods sold = $17,151; Sales revenue = $22,770; and Gross profit = $5,619.

3. Ending inventory = $2,293; Cost of goods sold = $16,952; Sales revenue = $22,770; and Gross profit = $5,818.

Explanation:

Note: This question is not complete. The complete question is therefore presented before answering the question. See the attached pdf file for the complete question.

Explanation to the answer is now presented as follows:

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

Note: See part 1 of the attached excel for the calculation of calculation of Cost of goods available for sale, Cost of goods sold, and Ending inventory using FIFO.

First In, First Out (FIFO) refers to an inventory accounting method in which inventory items purchased first are sold first, while the one that are purchased last are sold last.

In the attached excel file, since the inventory purchased on Oct. 6 is purchased last, the number of unit of inventory purchased on Oct. 6 sold is calculated by deducting the sum of the beginning inventory and inventory purchased before Oct. 6 from the total inventory sold as follows:

Number of unit of inventory purchased on Oct. 6 that are sold = Number of units sold - (Beginning inventory+ Apr. 7 Purchases + Jul. 16 Purchases) = 414 - (45 + 125 + 195) = 49

Therefore, the number of ending inventory is obtained as follows:

Number of unit of ending inventory = Number of inventory purchased on Oct. 6 - Number of inventory purchased on Oct. 6 sold = 105 – 49 = 56

Sales revenue = Number of unit units of inventory sold for the entire year * Selling price per unit = 414 * $55 = $22,770

From the attached excel file, we have:

Cost of goods sold = $16,837

Ending inventory = $2,408

Therefore, we have:

Gross profit = Sales revenue - Cost of goods sold = $22,770 - $16,837 = $5,933

2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.

Note: See part 2 of the attached excel for the calculation of calculation of Cost of goods available for sale, Cost of goods sold, and Ending inventory using LIFO.

Last In, First Out (LIFO) refers to an inventory accounting method in which inventory items purchased last are sold first, while the one that are purchased first are sold last.

In the attached excel file, the number of unit of inventory purchased on April 7 that are sold and the ones remaining that are NOT sold that forms part of ending inventory are calculated as follows:

Number of unit of inventory purchased on April 7 that are sold = 414 – (195 + 105) = 114

Number of unit of inventory purchased on April 7 that are NOT sold = Number of unit of inventory purchased on April 7 - Number of unit of inventory purchased on April 7 that are sold = 125 – 114 = 11

Sales revenue = Number of unit units of inventory sold for the entire year * Selling price per unit = 414 * $55 = $22,770

From the attached excel file, we have:

Cost of goods sold = $17,151

Ending inventory = $2,094

Therefore, we have:

Gross profit = Sales revenue - Cost of goods sold = $22,770 - $17,151 = $5,619

3. Using weighted average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Average Cost per unit" to 4 decimal places and all other answers to the nearest whole number.)

Note: See part 3 of the attached excel for the calculation of calculation of Cost of goods available for sale, Cost of goods sold, and Ending inventory using weighted average cost.

Weighted average cost method refers to a method of costing inventory in which the total cost of the goods available for sale is divided by the total number of units available for sales in order to obtain weighted average cost per unit.

In the attached excel file, weighted average cost per unit is therefore calculated and rounded to 4 decimal places as follows:

Weighted average cost per unit = $19,245 / 470 = $40.9468

Number of unit of ending inventory = Total number of units available for sales – Number of unit sold = 470 – 414 = 56

Sales revenue = Number of unit units of inventory sold for the entire year * Selling price per unit = 414 * $55 = $22,770

From the attached excel file, we have:

Cost of goods sold = $16,952

Ending inventory = $2,293

Therefore, we have:

Gross profit = Sales revenue - Cost of goods sold = $22,770 - $16,952 = $5,818