Question

Hemming Co. reported the following current-year purchases and sales for its only product. Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 200 units @ $10 = $ 2,000 Jan. 10 Sales 150 units @ $40 Mar. 14 Purchase 350 units @ $15 = 5,250 Mar. 15 Sales 300 units @ $40 July 30 Purchase 450 units @ $20 = 9,000 Oct. 5 Sales 430 units @ $40 Oct. 26 Purchase 100 units @ $25 = 2,500 Totals 1,100 units $ 18,750 880 units Required: Hemming uses a periodic inventory system. (a) Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. (b) Determine the costs assigned to ending inventory and to cost of goods sold using LIFO. (c) Compute the gross margin for each method.

Answer 1

The total goods available for sale for the period is computed as follows:
Inventory, beg (200 @ $10) ----------------------------------------$2,000
1st Purchase (350 @ $15) ---------------------------------------------5,250
2nd Purchase (450 @ $20) ------------------------------------------9,000
3rd Purchase (100 @ $25) -------------------------------------------2,500
Total Goods Available for Sale -----------------------------------$18,750

(a) In computing the Ending Inventory and Cost of Goods Sold using FIFO method:
Total Goods Available for Sale ---------------------------------- $18,750
Less: Ending Inventory* --------------------------------------------    4,900
Cost of Goods Sold --------------------------------------------------$13,850

*Ending Inventory
Inventory, beg ---------------------------------------------------------- 200
Total Purchases -------------------------------------------------------- 900
Total Available Units ------------------------------------------------- 1,100
Less: Units Sold -------------------------------------------------------   880
Inventory, end ---------------------------------------------------------   220
Cost of Ending Inventory
 100 × $25 = $2,500
 120 × $20 =   2,400
220              $4,900

(b) In computing the Ending Inventory and Cost of Goods Sold using LIFO method:
Total Goods Available for Sale ---------------------------------- $18,750
Less: Ending Inventory* --------------------------------------------   2,300
Cost of Goods Sold --------------------------------------------------$16,450

*Ending Inventory
Inventory, beg ---------------------------------------------------------- 200
Total Purchases -------------------------------------------------------- 900
Total Available Units ------------------------------------------------- 1,100
Less: Units Sold -------------------------------------------------------   880
Inventory, end ---------------------------------------------------------   220
Cost of Ending Inventory
 100 × $20 = $2,000
 120 × $15  =       300
220              $2,300

(c) The Gross Margin for FIFO and LIFO
                                                               FIFO                             LIFO
Sales (880 @ $40) ------------------------$35,200 -------------------$35,200
Cost of Goods Sold ----------------------   13,850 --------------------   16,450
Gross Margin --------------------------------$21,350 -------------------  $18,750

Answer 2

(a) The ending inventory through the FIFO method is 13,850.

(b) The ending inventory through the LIFO method is 16,950.

(c) The gross margin for the FIFO is 21,350 and LIFO is 18,250.

Firstly, it is required to calculate the goods available for selling.

Inventory at the beginning is 200 at $10, that is, $2000.

The first purchase is done 350 at $15, that is, 5250.

The second purchase is made 450 at $20, that is, 9000.

The third purchase is made 100 at $25, that is, 2500.

Hence, the total Goods Available would be:

$2000+5250+9000+2500\\=18,750$

(a) Now, by using the FIFO method, the ending inventory and cost of goods sold would be determined as follows:

First, calculate the ending inventory by:

$(200+900)-880\\220$

Hence, 220 units of inventory would be in the end.

Here, inventory at the beginning would be

$100*25=2500\\120*20=2400$

Hence, inventory at the beginning would be 220, and the ending inventory would be $4900.

Therefore, the cost of goods sold would be subtracting ending inventory from Total Goods Available.

$18,750-4900\\=13,850$

(b) Now, by using the LIFO method, ending inventory and cost of goods sold would be derived as follows:

The units of ending inventory are 220 units (as calculated above)

Cost of ending inventory is:

$100*20=2000\\120*15=1800$

Hence, beginning inventory is 220 and ending inventory is $2300.

Therefore, the cost of goods sold would be computed by:

$18,750-1800\\=16950$

(c) Finally the gross margin between LIFO and FIFO would be computed as follows:

Here, total sales are:

$880*40\\=35,200$

Gross margin in FIFO:

$35,200-13,850\\=21,350$

Gross margin in LIFO:

$35,200-16950\\=18,250$

Learn more about LIFO and FIFO method here:

https://brainly.com/question/14279607?referrer=searchResults