Question

In: Accounting

Metlock, Inc. had a beginning inventory on January 1 of 135 units of Product 4-18-15 at...

Metlock, Inc. had a beginning inventory on January 1 of 135 units of Product 4-18-15 at a cost of $21 per unit. During the year, the following purchases were made.
Mar. 15 360 units at $24 Sept. 4 315 units at $27
July 20 225 units at $25 Dec. 2 90 units at $30

900 units were sold. Metlock, Inc. uses a periodic inventory system.
Determine the cost of goods available for sale.
The cost of goods available for sale $
Calculate average cost per unit. (Round answer to 2 decimal places, e.g. 2.23.)
Average cost per unit $
Determine (1) the ending inventory, and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO, and average-cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. (Round answers to 0 decimal places, e.g. 1,250.)

FIFO

LIFO

AVERAGE-COST

The ending inventory $ $ $
The cost of goods sold $ $ $
Which cost flow method results in (1) the highest inventory amount for the balance sheet, and (2) the highest cost of goods sold for the income statement?
(1)

FIFOLIFOAverage-cost

results in the highest inventory amount, $ .
(2)

FIFOLIFOAverage-cost

produces the highest cost of goods sold, $ .

Solutions

Expert Solution

1 The cost of goods available for sale $28,305
2 Average cost per unit $25.16
3 FIFO LIFO Average cost
Ending Inventory $6,345 $4,995 $5,661
Cost of Goods Sold $21,960 $23,310 $22,644
4 The highest inventory amount for the balance sheet FIFO
The highest cost of goods sold for the income statement LIFO
Working
FIFO
Units Unit Cost
                                                                              135 $27 $3,645
                                                                                90 $30 $2,700
Ending Inventory $6,345
COGS = Beginning inventory + purchases - ending inventory
= $2,835 + $25,470 - $6,345
= $21,960
LIFO
Units Unit Cost
                                                                              135 $21 $2,835
                                                                                90 $24 $2,160
Ending Inventory $4,995
COGS = Beginning inventory + purchases - ending inventory
= $2,835 + $25,470 - $4,955
= $23,310
Average cost
Units Unit Cost
                                                                              135 $21 $2,835
                                                                              360 $24 $8,640
                                                                              225 $25 $5,625
                                                                              315 $27 $8,505
                                                                                90 $30 $2,700
                                                                          1,125 $28,305
Average cost per unit ($28,305/1,125) $25.16
Ending Inventory = 225 x $25.16 $5,661
COGS = Beginning inventory + purchases - ending inventory
= $2,835 + $25,470 - $5,661
= $22,644

Related Solutions

Sekhon company had a beginning inventory on January 1 of 200 units of product 4-18-15 at...
Sekhon company had a beginning inventory on January 1 of 200 units of product 4-18-15 at cost of $20 per unit. During the year, the following purchases were made. Mar. 15 500 units at $21, July 20 313 units at $22 Sept. 4 413 units at $27. Dec. 2. 125 units at $31 1250 units were sold. Sekhon Company uses a periodic inventory system. 1. Determine the cost of good available for sale. 2. Calculate average cost per unit. 3....
Lily Company had a beginning inventory on January 1 of 190 units of Product 4-18-15 at...
Lily Company had a beginning inventory on January 1 of 190 units of Product 4-18-15 at a cost of $20 per unit. During the year, the following purchases were made. Mar. 15 450 units at $23 Sept. 4 350 units at $25 July 20 230 units at $24 Dec. 2 100 units at $26 1,120 units were sold. Lily Company uses a periodic inventory system. Determine (1) the ending inventory, and (2) the cost of goods sold under each of...
Ziad Company had a beginning inventory on January 1 of 143 units of Product 4-18-15 at...
Ziad Company had a beginning inventory on January 1 of 143 units of Product 4-18-15 at a cost of $20 per unit. During the year, the following purchases were made. Mar. 15 380 units at $23 Sept. 4 333 units at $26 July 20 238 units at $24 Dec. 2 95 units at $29 950 units were sold. Ziad Company uses a periodic inventory system. a) Determine the cost of goods available for sale. b) Calculate average cost per unit....
Ziad Company had a beginning inventory on January 1 of 285 units of Product 4-18-15 at...
Ziad Company had a beginning inventory on January 1 of 285 units of Product 4-18-15 at a cost of $19 per unit. During the year, the following purchases were made. Mar. 15 760 units at $22 Sept. 4 665 units at $25 July 20 475 units at $23 Dec. 2 190 units at $28 1,900 units were sold. Ziad Company uses a periodic inventory system. A: Determine the cost of good available for sale B: Calculate the average cost per...
Urgent XX Company had a beginning inventory on January 1 of 160 units of Product 4-18-15...
Urgent XX Company had a beginning inventory on January 1 of 160 units of Product 4-18-15 at a cost of $20 per unit. During the year, the following purchases were made. Date Units Price Mar. 15 450 units $22 July 20 200 units $23 Sept. 4 330 units $25 Dec. 2 110 units $30 1,000 units were sold. XX Company uses a periodic inventory system. Instructions (a) Determine the cost of goods available for sale. (b) Determine (1) the ending...
Sprint Shoes Inc. had a beginning inventory of 9,150 units on January 1, 20X1. The costs...
Sprint Shoes Inc. had a beginning inventory of 9,150 units on January 1, 20X1. The costs associated with the inventory were: Material $ 13.00 per unit Labor 8.00 per unit Overhead 6.10 per unit During 20X1, the firm produced 42,800 units with the following costs:    Material $ 15.50 per unit Labor 7.80 per unit Overhead 8.30 per unit Sales for the year were 47,310 units at $42.60 each. Sprint Shoes uses LIFO accounting. a. What was the gross profit?...
Sprint Shoes Inc. had a beginning inventory of 9,350 units on January 1, 20X1. The costs...
Sprint Shoes Inc. had a beginning inventory of 9,350 units on January 1, 20X1. The costs associated with the inventory were: Material $ 12.00 per unit Labor 7.00 per unit Overhead 5.10 per unit During 20X1, the firm produced 43,200 units with the following costs: Material $ 13.50 per unit Labor 5.80 per unit Overhead 6.30 per unit Sales for the year were 47,390 units at $39.60 each. Sprint Shoes uses LIFO accounting. a. What was the gross profit? (Do...
Aiello, Inc. had the following inventory in fiscal 2016. Beginning Inventory, January 1, 2016: 130 units...
Aiello, Inc. had the following inventory in fiscal 2016. Beginning Inventory, January 1, 2016: 130 units @ $15.00 Purchase 200 units @ $18.00 Purchase 50 units @ $13.50 Purchase 110 units @ $15.75 Total units sold during the month is 370. a) Compute the company’s cost of goods sold and ending inventory for fiscal 2016 assuming the company used FIFO b) Compute the company’s cost of goods sold and ending inventory for fiscal 2016 assuming the company used LIFO methods...
Problem 6-3A Wildhorse Co. had a beginning inventory on January 1 of 308 units of Product...
Problem 6-3A Wildhorse Co. had a beginning inventory on January 1 of 308 units of Product 4-18-15 at a cost of $19 per unit. During the year, the following purchases were made. Mar. 15 820 units at $22 Sept. 4 718 units at $25 July 20 513 units at $23 Dec. 2 205 units at $28 2,050 units were sold. Wildhorse Co. uses a periodic inventory system a.Determine the cost of goods available for sale. b. Calculate average cost per...
Groves Company Inc. had a beginning inventory of 300 units of Product MLN at a cost...
Groves Company Inc. had a beginning inventory of 300 units of Product MLN at a cost of $8 per unit. During the year, purchases were: Feb. 20 700 units at $9 Aug. 12 600 units at $11 May 5 500 units at $10 Dec. 8 100 units at $12 Groves Company uses a periodic inventory system. Sales totaled 1,800 units. Instructions: (a) determine the cost of goods available for sale. (b) Determine the ending inventory and the cost of goods...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT