Question

In: Accounting

Brief Exercise 8-8 LIFO method [LO8-4] Esquire Inc. uses the LIFO method to value its inventory....

Brief Exercise 8-8 LIFO method [LO8-4]

Esquire Inc. uses the LIFO method to value its inventory. Inventory at January 1, 2018, was $500,000 (25,000 units at $20 each). During 2018, 90,000 units were purchased, all at the same price of $27 per unit. 95,000 units were sold during 2018. Esquire uses a periodic inventory system.

Complete the below table to calculate the December 31, 2018, ending inventory and cost of goods sold for 2018.

Cost of Goods Available for Sale COGS - Periodic LIFO Ending Inventory - Periodic LIFO
# of units Cost per unit Cost of Goods Available # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
Beginning Inventory
Purchases
Total

Solutions

Expert Solution

Cost of Goods Available for Sale COGS - Periodic LIFO Ending Inventory - Periodic LIFO
# of units Cost per unit Cost of Goods Available # of units Cost per unit Cost of Goods Available # of units Cost per unit Cost of Goods Available
Beginning Inventory         25,000 $                  20 $         5,00,000         5,000 $                  20 $         1,00,000             20,000 $                  20 $         4,00,000
Purchases         90,000 $                  27 $      24,30,000      90,000 $                  27 $      24,30,000
Total      1,15,000 $      29,30,000      95,000 $      25,30,000             20,000 $         4,00,000
Working:
Under periodic inventory system, inventory records are updated at the end of period.
LIFO stands for last-in-first-out.It means inventory which is bought in last is sold first.
So, sales of 95,000 units is firstly from purchase made during the year and lastly from beginning inventory.

Related Solutions

Esquire Inc. uses the LIFO method to report its inventory. Inventory at January 1, 2021, was...
Esquire Inc. uses the LIFO method to report its inventory. Inventory at January 1, 2021, was $780,000 (39,000 units at $20 each). During 2021, 118,000 units were purchased, all at the same price of $29 per unit. 121,000 units were sold during 2021. Calculate the December 31, 2021, ending Inventory and cost of goods sold for 2021 based on a periodic inventory system.On December 28, 2021, Videotech Corporation (VTC) purchased 10 units of a new satellite uplink system from Tristar Communications...
A) Whispering, Inc. uses the dollar-value LIFO method of computing its inventory. Data for the past...
A) Whispering, Inc. uses the dollar-value LIFO method of computing its inventory. Data for the past 3 years follow. Year Ended December 31 Inventory at Current-Year Cost Price Index 2019 $21,500 100 2020 23,532 106 2021 27,664 112 Compute the value of the 2020 and 2021 inventories using the dollar-value LIFO method. 2020 2021 Inventory under LIFO $enter a dollar amount $enter a dollar amount B) The following is a record of Sheffield Company’s transactions for Boston Teapots for the...
Cansela Corporation uses a periodic inventory system and the LIFO method to value its inventory. The...
Cansela Corporation uses a periodic inventory system and the LIFO method to value its inventory. The company began 2018 with inventory of 5,600 units of its only product. The beginning inventory balance of $75,600 consisted of the following layers:    2,100 units at $11 per unit = $ 23,100 3,500 units at $15 per unit = 52,500 Beginning inventory $ 75,600    During the three years 2018–2020, the cost of inventory remained constant at $17 per unit. Unit purchases and...
Cansela Corporation uses a periodic inventory system and the LIFO method to value its inventory. The...
Cansela Corporation uses a periodic inventory system and the LIFO method to value its inventory. The company began 2018 with inventory of 6,100 units of its only product. The beginning inventory balance of $87,200 consisted of the following layers: 2,600 units at $12 per unit = $ 31,200 3,500 units at $16 per unit = 56,000 Beginning inventory $ 87,200 During the three years 2018–2020, the cost of inventory remained constant at $18 per unit. Unit purchases and sales during...
Hazelton Corporation uses a periodic inventory system and the LIFO method to value its inventory. The...
Hazelton Corporation uses a periodic inventory system and the LIFO method to value its inventory. The company began 2018 with $84,100 in inventory of its only product. The beginning inventory consisted of the following layers: 4,700 units at $7 per unit $ 32,900 6,400 units at $8 per unit 51,200 Total $ 84,100 During 2018, 6,700 units were purchased at $9 per unit and during 2019, 8,400 units were purchased at $10 per unit. Sales, in units, were 8,400 and...
Kimball International Inc. uses the LIFO method of accounting for inventory. In its 2017 inventory footnote...
Kimball International Inc. uses the LIFO method of accounting for inventory. In its 2017 inventory footnote Kimball reported a LIFO reserve of $19,500 and $21,100 at June 30, 2017 and 2016, respectively. Selected data from the financial statements is below 2017 2016 Total inventory $89,489 $76,146 Net Sales 923,636 895,912 Cost of Sales 664,311 645,591 Gross Profit 259,325 250,321 Earnings per Share $2.15 $1.96 a. Compute the inventory amount at June 30, 2017 for Kimball International Inc. assuming that it...
Faucci Industries, Inc. uses the dollar-value LIFO method of computing its inventory cost with December 31,...
Faucci Industries, Inc. uses the dollar-value LIFO method of computing its inventory cost with December 31, 2015 representing the base cost. Data for the past five years follows: Year Ended December 31, Inventory at FIFO Index 2015 $       85,000 100 2016           92,400 105 2017         102,120 111 2018         102,600 114 2019         110,200 116 Required: Determine the inventory valuation for 2016 through 2019 using the dollar-value LIFO technique.
Exercise 8-13 Inventory cost flow methods; periodic system [LO8-1, 8-4] Altira Corporation uses a periodic inventory...
Exercise 8-13 Inventory cost flow methods; periodic system [LO8-1, 8-4] Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2018 is available: Aug.1 Inventory on hand—10,500 units; cost $8.40 each. 8 Purchased 29,000 units for $7.40 each. 14 Sold 20,500 units for $13.90 each. 18 Purchased 15,500 units for $6.90 each. 25 Sold 19,500 units for $12.90 each. 31 Inventory on hand—15,000 units. Required: Determine the inventory balance Altira...
CA8.11   (LO 3, 4 ) (LIFO Choices) Wilkens Company uses the LIFO method for inventory costing....
CA8.11   (LO 3, 4 ) (LIFO Choices) Wilkens Company uses the LIFO method for inventory costing. In an effort to lower net income, company president Mike Wilkens tells the plant accountant to take the unusual step of recommending to the purchasing department a large purchase of inventory at year-end. The price of the item to be purchased has nearly doubled during the year, and the item represents a major portion of inventory value. Also answer the following:       -what ratios are...
Rose, Inc. uses the dollar-value LIFO retail inventory method. For years ending 2015-2019 they counted the...
Rose, Inc. uses the dollar-value LIFO retail inventory method. For years ending 2015-2019 they counted the following dollar amounts for inventory at retail prices 2015 $124,000 2016 $138,600 2017 $157,500 2018 $149,240 2019 $155,700 As far as prices are concerned, the following year end price indexes were estimated as: 2015 1.00 2016 1.04 2017 1.10 (10 percent higher prices than in 2015) 2018 1.13 2019 1.15 The cost to retail percentage for those items added in each year were as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT