Question

In: Accounting

E7-5 Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2...

E7-5 Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2

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:

Units Unit Cost
  Inventory, December 31, prior year 1,850     $ 4
  For the current year:
      Purchase, March 21 5,040     6
      Purchase, August 1 2,870     7
  Inventory, December 31, current year 4,170    

Required:

Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods. (Round "Average cost per unit" to 2 decimal places and final answers to nearest whole dollar amount.)

Solutions

Expert Solution

Number of units sold in the current year= 1850+5040+2870-4170= 5590 units

FIFO periodic:

Under FIFO method in periodic inventory, the units purchased first (as on the end of the year) are sold first.

Cost of goods sold is computed(as sold in the chronological order as numbered) as follows:

  1. 1850 units of $4 each= $7400
  2. 3740 units(5590-1850) of $6 each= $22440

Total cost of goods sold= 7400+22440= $29840

The closing inventory will now contain 1300 units(5040-3740) of $6 each and 2870 units of $7 each.

Closing inventory= (1300*6)+(2870*7)= $27890

LIFO periodic:

Under LIFO method in periodic inventory, the units purchased last (as on the end of the year) are sold first.

Cost of goods sold is computed as below in the order that they are sold:

  1. 2870 units of $7 each= $20090
  2. 2720 units (5590-2870) of $6 each= $16320

Total cost of goods sold= 20090+ 16320= $36410

Now, the closing inventory will contain 2320 units (5040-2720) of $6 each and 1850 units of $4 each.

Closing inventory= (2320*6)+ (1850*4)= $21320

Average cost periodic:

Under this method, we have to compute the average cost per unit using the following formula for the entire class of inventory. The date of purchase or sale does not matter in periodic inventory method.

Weighted average cost of inventory= total cost of inventory/ total units in inventory

= [(1850*4)+(5040*6)+(2870*7)] / (1850+5040+2870)

= 57730/9760= $5.91 per unit

Now, to compute the cost of goods sold we only need to multiply the weighted average cost by the units sold.

Cost of goods sold= 5.91*5590= $33037

Closing Inventory can be found by multiplying the weighted average cost by the units in closing inventory

Closing Inventory= 5.91*4170= $24645


Related Solutions

E7-6 Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2...
E7-6 Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton 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: Units Unit Cost Inventory, December 31, prior year 1,810 $ 8 For the current year: Purchase, March 21 6,020 7 Purchase, August 1 4,010 5 Inventory, December 31, current year 2,920 Find LIFO...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Madden Company reports the following initial balance and subsequent purchase of inventory. Inventory balance at beginning of year 1,820 units @ $150 each $273,000 Inventory purchased during the year 2,380 units @ $180 each 428,400 Cost of goods available for sale during the year 4,200 units $701,400 Assume that 2,800 units are sold during the year. Compute the cost of goods sold for the...
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.
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...
how do you calculate ending inventory or cost of goods sold under LIFO and FIFO    ...
how do you calculate ending inventory or cost of goods sold under LIFO and FIFO     how do you use the Gross Profit Method to estimate a loss of inventory how do you use the relative sales value method of allocating cost to items purchased What are the common disclosures required for inventory?
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
M7-7 to M7-9 Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost [LO 7-3]
Required informationM7-7 to M7-9 Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost [LO 7-3][The following information applies to the questions displayed below.]The following are the transactions for the month of July.UnitsUnit CostUnit Selling PriceJuly 1Beginning Inventory51$10July 13Purchase25512July 25Sold(100)$16July 31Ending Inventory206M7-7 Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO [LO 7-3]Calculate cost...
Computing Cost of Goods Sold and Ending Inventory UnderFIFO, LIFO, and Average CostAssume that...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average CostAssume that Madden Company reports the following initial balance and subsequent purchase of inventory.Inventory balance at beginning of year 1,560 units @ $150 each $234,000Inventory purchased during the year 2,040 units @ $180 each 367,200Cost of goods available for sale during the year 3,600 units $601,200Assume that 2,400 units are sold during the year. Compute the cost of goods sold for the year and the inventory on...
Study the FIFO and LIFO explanations in Chapter 8. 1) Compute ending FIFO inventory and cost of goods sold.
FIFO & LIFO InventoryStudy the FIFO and LIFO explanations in Chapter 8. 1) Compute ending FIFO inventory and cost of goods sold. Assume $90,000 sales; beginning inventory 500 units @$50; purchases of 400 units @$50; 100 units @$65; 400 units @$80. 2) Compute the cost of goods sold percentage of sales. 3) Compute ending LIFO inventory and cost of goods sold, using same assumptions. 4) Compute the cost of goods sold percentage of sales. 5) Comment on the difference in...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and...
Calculate cost of goods sold and ending inventory for Emergicare’s bandages orders using FIFO, LIFO and average cost. There are 36 units in ending inventory. (Do not round intermediate calculations, such as average cost per unit values. Round your answers to the nearest cent.) Date Units purchased Cost per unit Total cost January 1 43 $ 7.10 $ 305.30 April 1 38 6.35 241.30 June 1 53 6.10 323.30 September 1 48 6.60 316.80 Total 182 $ 1,186.70 Cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT