Question

In: Accounting

From the following? information, calculate the cost of ending inventory and cost of goods sold using...

From the following? information, calculate the cost of ending inventory and cost of goods sold using the? (a) FIFO,? (b) LIFO, and? (c) weighted-average methods.

Units

Cost

January 1

Beginning Inventory

4

$7

March 6

Purchased

6

2

August 9

Purchased

4

9

December 10

Purchased

5

1

The ending inventory reveals eighteight items unsold

Solutions

Expert Solution

Units in inventory = 8 units

Total Items available for sale = Beginning Inventory + All purc. made = 4 + 6 + 4 + 5 = 19 units

Units sold = 19 units - 8 units = 11 units

Answer (a)

Computation of COGS & cost of ending inventory under FIFO :

Under FIFO, out of 11 units sold , 4 units are from beginning Inventory , 6 units from purchase made on March 6 & 1 unit from purchase made on August 9.

Thus ending inventory consists of 3 units from purchase made on August 9 & 5 units from purchase made on December 10

  • COGS : (4 * $7) + (6 * $2) +(3* $9) = $28 + $12 + $27 = $67
  • Cost of ending inventory : (1* $9) + (5 * $1) = $9 + $5 = $14

Answer (b)

Computation of COGS & cost of ending inventory under LIFO :

Under LIFO, out of 11 units sold , 5 units from purchase made on  December 10, 4 units from purchase made on August 9 & 2 units from purchase made on March 6.

Thus ending inventory consists of 4 units from purchase made on March 6. & 4 units from beginning Inventory

  • COGS : (5 * $1) + (4 * $9) +(2* $2) = $5 + $36 +$4 = $45
  • Cost of ending inventory : (4* $2) + (4 * $7) = $8 +$28 =  $36

Answer (c)

Computation of COGS & cost of ending inventory under weighted-average methods :

Average cost per unit = Total cost of inventory / Total units available for sale = $81 / 19 units = $4.26

  • COGS = 11 units * $4.26316 = $46.86 or $47
  • Cost of ending inventory = 8 units * $4.26 = $34.08 or $34

Related Solutions

Based on the following information, calculate the cost of goods sold and ending inventory using FIFO,...
Based on the following information, calculate the cost of goods sold and ending inventory using FIFO, LIFO, and weighted average assuming a perpetual inventory system is in place. Beginning Balance - 90 units at $11 March 3 - Purchase 300 units for $15 April 4 - Sell 240 units for $28 June 30 - Purchase 250 units for $18 August 16 - Sell 180 units for $30
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the weighted-average method, ending inventory is 56 units. (Round your intermediate calculations and final answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 6 $ 2.70 April 10 9 3.20 May 15 13 3.70 July 22 14 3.95 August 19 19 4.70 September 30 19 4.90 November 10 33 5.10 December 15 15 5.50 cost of ending inventory? Cost of...
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the LIFO method, ending inventory is 54 units. (Round your answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 6 $ 1.00 April 10 9 1.50 May 15 13 2.00 July 22 14 2.25 August 19 19 3.00 September 30 19 3.20 November 10 33 3.40 December 15 15 3.80 Cost of ending inventory $ Cost of goods sold $
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO...
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO periodic cost flow assumption. Sales 97 units at $ 18 per unit Beginning inventory 88 units at $ 6 per unit Purchases 58 units at $ 10 per unit Calculate the cost of goods sold using the LIFO periodic cost flow assumption. Units x Cost per Unit = Total Cost Units from beginning inventory x = Units from purchase x = Cost of Goods...
Use the following information to complete the charts and calculate cost of goods sold, ending inventory,...
Use the following information to complete the charts and calculate cost of goods sold, ending inventory, and gross profit under the FIFO, LIFO, and Weighted Average methods. Units Cost Units Retail Oct. 1 Beginning Inventory 120 $39 Oct. 3 Sales 90 $100 Oct. 5 Purchase 140 $40 Oct. 12 Sales 110 $100 Oct. 18 Sales 45 $100 Oct. 26 Purchase 160 $43
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted...
Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. Description # of units Cost per unit Beginning inventory: 20 20 Jan.15 Purchase: 22 27 Jan. 20 Sale 10 blank Jan.25 Purchase 18 25 Jan.28 Sale   15 blank
Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...
Use the following information to calculate the value of ending inventory and the cost of goods...
Use the following information to calculate the value of ending inventory and the cost of goods sold in March: March 01: beginning inventory: 60 units @ $15 per unit March 05: purchase of 140 units @ $15.50 per unit March 14: sale of 190 units @ $19 per unit March 27: purchase of 70 units @ $16 per unit March 29: sale of 30 units @ $19.50 per unit Under LIFO Periodic Under LIFO Perpetual
Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Exercise 6-4A Calculate inventory amounts when costs are rising (LO6-3)During the year, TRC Corporation has the following inventory transactions.DateTransactionNumber of UnitsUnit CostTotal CostJan.1Beginning inventory52$44$2,288Apr.7Purchase132466,072Jul.16Purchase202499,898Oct.6Purchase112505,600498$23,858For the entire year, the company sells 432 units of inventory for $62 each.Exercise 6-4A Part 22. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT