Question

In: Accounting

The accounting records of Metlock Electronics show the following data. Beginning inventory 2,700 units at $5...

The accounting records of Metlock Electronics show the following data.

Beginning inventory 2,700 units at $5

Purchases 7,000 units at $7

Sales 8,100 units at $10

1a. Determine cost of goods sold during the period under a periodic inventory system using the FIFO method.

1b. Determine cost of goods sold during the period under a periodic inventory system using the LIFO method.

1c. Determine cost of goods sold during the period under a periodic inventory system using the average-cost method.

Solutions

Expert Solution

Answer :

i)Beginning inventory : 2700 units @ $5

(+) Purchases : 7000 units @$7

Goods available for sale : 9700 units

ii)SalesSales 8,100 units @$10

1)COGS under FIFO method :

FIFO is one of the method commonly used to estimate the value of inventory on hand at the end of an accounting period and the cost of goods sold during the period. This method assumes that inventory purchased or manufactured first is sold first and newer inventory remains unsold.

Therefore

COGS for 8,100 units is :

2,700 units × $ 5 + 5,400 units × $7

= $13,500 + $37,800

= $ 51,300

2)COGS under LIFO method :

The last in first out (LIFO) method is used to place an accounting value on inventory. The LIFO method operates under the assumption that the last item of inventory purchased is the first one sold and inventory which purchased first will remain in ending inventory.

Therefore

COGS for 8,100 units is :

7,000 units × $ 7 + 1,100 units × $5

= $49,000 + $5,500

= $ 54,500

3)Weighted average cost per unit under weighted average cost method

In accounting, the Weighted Average Cost (WAC) method of inventory valuation uses a weighted average to determine the amount that goes into COGS and inventory. The weighted average cost method divides the cost of goods available for sale by the number of units available for sale.

The formula for the weighted average cost method is as follows:

Weighted average cost per unit (WAC per unit ) = cost of goods availabe for sale ÷ units available for sale

WAC per unit = 2,700×$5 + 7,000×$7 ÷ 9,700

= $62,500 ÷ 9,700

= 6.44 per unit

COGS under average cost method for 8,100 units

= 8,100 × 6.44 per unit

= $ 52,164.


Related Solutions

The accounting records of Blossom Company show the following data. Beginning inventory 5,000 units at $5...
The accounting records of Blossom Company show the following data. Beginning inventory 5,000 units at $5 Purchases 7,500 units at $7 Sales 9,900 units at $10 Calculate average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Determine cost of goods sold during the period under a periodic inventory system using the FIFO method, the LIFO method, and the average-cost method. (Round answers to 0 decimal places, e.g. 125.)
The accounting records of Blossom Company show the following data. Beginning inventory 5,000 units at $5...
The accounting records of Blossom Company show the following data. Beginning inventory 5,000 units at $5 Purchases 7,500 units at $7 Sales 9,900 units at $10 Calculate average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Average unit cost $enter average unit cost in dollars per unit Determine cost of goods sold during the period under a periodic inventory system using the FIFO method, the LIFO method, and the average-cost method. (Round answers to 0 decimal places, e.g....
The accounting records of Swifty Corporation show the following data. Beginning inventory 4,000 units at $6...
The accounting records of Swifty Corporation show the following data. Beginning inventory 4,000 units at $6 Purchases 8,500 units at $8 Sales 10,700 units at $11 1) Average unit cost. 2) FIFO 3)LIFO 4) Average cost
Question 1 The accounting records of Sunland Company show the following data. Beginning inventory 3,190 units...
Question 1 The accounting records of Sunland Company show the following data. Beginning inventory 3,190 units at $6 Purchases 7,450 units at $8 Sales 9,194 units at $11
DO IT! 6.2 (LO 2) The accounting records of Americo Electronics show the following data. Compute...
DO IT! 6.2 (LO 2) The accounting records of Americo Electronics show the following data. Compute cost of goods sold under different cost flow methods. Beginning inventory    3,000 units at $5 Purchases 8,000 units at $7 Sales 9,400 units at $10 Determine cost of goods sold during the period under a periodic inventory system using (a) the FIFO method, (b) the LIFO method, and (c) the average-cost method. (Round unit cost to nearest tenth of a cent.)
DO IT! 6-2: The accounting records of Old Towne Electronics show the following data. Apply rules...
DO IT! 6-2: The accounting records of Old Towne Electronics show the following data. Apply rules of ownership to determine inventory cost. Beginning inventory: 3,000 units at $5 Purchases: 8,000 units at $7 Sales: 9,400 units at $10 Determine cost of goods sold during the period under a periodic inventory system using (a) the FIFO method, (b) the LIFO method, and (c) the average-cost method. (Round unit cost to nearest tenth of a cent.)
Tess Company's inventory records show the following data for the month of May: Units Unit Cost...
Tess Company's inventory records show the following data for the month of May: Units Unit Cost Inventory, May 1 200 $2.00 Purchases: May 8 200 3.00 May 15 100 4.00 The company uses a periodic inventory system. A physical inventory on May 30 shows 150 units on hand. Assuming FIFO (First-In-First-Out) inventory costing, calculate the cost of goods sold. a. $1,100 b. $850 c. $700 d. $980
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost...
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost Inventory, September 1 100 $3.34 Purchases: September 8 450 3.50 September 18 350 3.70 A physical inventory on September 30 shows 200 units on hand. Calculate the value of the ending inventory and cost of goods sold if the company uses weighted average inventory costing and a periodic inventory system. (Round cost per unit to 2 decimal places and ending inventory and cost of...
1. Eneri Company's inventory records show the following data: Units Unit Cost Inventory, January 1 5,000...
1. Eneri Company's inventory records show the following data: Units Unit Cost Inventory, January 1 5,000 $9.20 Purchases: June 18 4,500 8.00 November 8 3,000 7.00 A physical inventory on December 31 shows 2,000 units on hand. Eneri sells the units for $13 each. The company has an effective tax rate of 20%. Eneri uses the periodic inventory method. Under the FIFO method, the December 31 inventory is valued at A. $16,133. B. $14,000. C. $16,480. D. $18,400. 2. Priscilla...
Do It! Review 6-2 The accounting records of Whispering Winds Corp. show the following data. Beginning...
Do It! Review 6-2 The accounting records of Whispering Winds Corp. show the following data. Beginning inventory 3,010 units at $6 Purchases 8,130 units at $8 Sales 9,090 units at $11 Determine cost of goods sold during the period under a periodic inventory system using the FIFO method, the LIFO method, and the average-cost method. (Round answers to 0 decimal places, e.g. 125.) FIFO LIFO Average-cost Cost of goods sold $enter a dollar amountEntry field with incorrect answer 6. $enter...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT