Question

In: Accounting

Cost of Goods Sold and Ending Inventory for each of the following methods:

Calculate the following:

Cost of Goods Sold and Ending Inventory for each of the following methods:

a.    FIFO

b.    LIFO

c.     Weighted Average

  Units                    Unit Cost

7/1      Beginning Inventory 100 10

7/5      Purchases                                                     500 15

7/15    Sales                                                              400                             

7/20    Purchases                                                     200 20

Solutions

Expert Solution

:: FIFO Method

>> Ending Inventory = ( 200 * $ 20 ) + ( 200 * $ 15 )

>> Ending Inventory = $ 7000.

>> Cost of Goods sold = ( 100 * $ 10 ) + ( 300 * 15 )

>> Cost of Goods sold = $ 5,500.

:: LIFO Method

>> Ending Inventory = ( 200 * $ 20 ) = + ( $ 100 * $ 10 ) + ( 100 * $ 15 )

>> Ending Inventory = $ 6,500.

>> Cost of Goods sold = 400 * $ 15

>> Cost of Goods sold = $ 6,000.

:: Weighted Average Method

>> Average cost on 15th July = ( $ 1000 + $ 7500 ) / 600

>> Average cost on 15th July = $ 14.167.

>> Average cost on 20th July = [ ( 200 * 14.167 ) + $ 2,000 ] / 400

>> Average cost on 20th July = $ 12.0835

>> Ending Inventory = 400 * $ 12.0835

>> Ending Inventory = $ 4,833

>> Cost of Goods sold = 400 * $ 14.167

>> Cost of Goods sold = $ 5,667


Related Solutions

Calculate cost of goods sold and ending inventory under each of the following methods given the...
Calculate cost of goods sold and ending inventory under each of the following methods given the following information about purchases and sales during the year. Jan. 1           Beginning Inventory       300 units @ $3 Jan. 5           Sales                                      100 units Jan. 15        Purchases                           400 units @ $4 Jan. 20        Sales                                      200 units a. FIFO. b. LIFO.
Identify four methods of assigning a cost to ending inventory and cost of goods sold and...
Identify four methods of assigning a cost to ending inventory and cost of goods sold and briefly explain the difference in the methods. It’s common in the electronics industry for unit costs of raw materials inventories to decline over time. In this environment, explain the difference between LIFO and FIFO, in terms of the effect on income and financial position. Assume that inventory quantities remain the same for the period. Explain why proponents of LIFO argue that it provides a...
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 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...
Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.
Penn Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1:Required Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.
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
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...
Periodic inventory by three methods; cost of goods sold
Periodic inventory by three methods; cost of goods soldThe units of an item available for sale during the year were as follows:Jan. 1Inventory180units at $108Mar. 10Purchase224units at $110Aug. 30Purchase200units at $116Dec. 12Purchase196units at $120There are 208 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of goods sold by three methods.Cost of Inventory and Cost of Goods SoldInventory MethodEnding InventoryCost of Goods SoldFirst-in, first-out...
Compute ending inventory, cost of goods sold, and gross profit.
My question: Assume the company uses three inventory pools instead of one. Compute ending inventory, cost of goods sold, and gross profit. (Round price index to 2 decimal places, e.g. 1.45 and final answers to 0 decimal places, e.g. 6,548.)   William’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, William adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category   Quantity  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT