answer v) calculation of cost of inventory using DVL method :
date | ending inventory at the end of the year | price index | inventory base year prices | change from prior year |
12/31/18 | $580000 | 100% or 1.00 | $580000 x 100/100 = $580000 | $0 |
12/31/19 | $715000 | 110% or 1.10 | $715000 x 100/110 = $650000 | $650000 - $580000 = $70000 |
12/31/20 | $739200 | 112% or 1.12 | $739200 x 100/112 = $660000 | $660000 - $650000 = $10000 |
computation of cost of inventory :
12/31/18 : | |
$580000 @ 1.00 | $580000 |
12/31/19 : | |
$580000 @ 1.00 | $580000 |
add : $70000 @ 1.10 | $77000 |
cost of inventory | $657000 |
12/31/20 : | |
$580000 @ 1.00 | $580000 |
add : $70000 @ 1.10 | $77000 |
add : $10000 @ 1.12 | $11200 |
cost of inventory | $668200 |
cost of inventory at 12/31/20 using DVL method | $668200 |
answer vi) computaion of cost of goods sold and ending inventory using weighted average method :
goods received or purchased | goods sold or cost of goods sold | ending inventory | |||||||
date | particular | no. of units | cost per unit in $ | no. of units | cost per unit in $ | cost of goods sol;d in $ | no. of units | cost per unit in $ | ending inventory in $ |
nov. 1 | beginning inventory | 70 | 50 | 3500 | |||||
nov. 5 | purchase | 30 | 60 | 100 | (3500+1800)/100 = 53 | 5300 | |||
nov. 8 | sale | 40 | 53 | 2120 | 60 | 53 | 3180 | ||
nov. 20 | purchase | 90 | 55 | 150 | (3180+4950)/150 = 54.2 | 8130 | |||
nov. 29 | sale | 120 | 54.2 | 6504 | 30 | 54.2 | 1626 | ||
cost of goods sold and cost of ending inventory | 160 | 8624 | 30 | 1626 |
perpectual weighted average method | |
cost pr goods sold | $8624 |
cost of ending inventory | $1626 |
answer vii) computation of cost of goods sold and ending inventory :
a) perpetual fifo method :
goods received or purchased | goods sold or cost of goods sold | ending inventory | |||||||
date | particular | no. of units | cost per unit in $ | no. of units | cost per unit in $ | cost of goods sol;d in $ | no. of units | cost per unit in $ | ending inventory in $ |
july 1 | beginning inventory | 50 | 120 | 6000 | |||||
july 6 | purchases | 30 | 130 | 50 | 120 | 6000 | |||
30 | 130 | 3900 | |||||||
july 9 | sale | 50 | 120 | 6000 | 10 | 130 | 1300 | ||
20 | 130 | 2600 | |||||||
july 20 | purchase | 90 | 140 | 10 | 130 | 1300 | |||
90 | 140 | 12600 | |||||||
july 31 | sale | 10 | 130 | 1300 | 20 | 140 | 2800 | ||
70 | 140 | 9800 | |||||||
total of cost of goods sold and nding inventory | 150 | 19700 | 20 | 2800 |
b) periodic lifo method :
goods received or purchased | goods sold or cost of goods sold | ending inventory | |||||||
date | particular | no. of units | cost per unit in $ | no. of units | cost per unit in $ | cost of goods sol;d in $ | no. of units | cost per unit in $ | ending inventory in $ |
july 1 | beginning inventory | 50 | 120 | 6000 | |||||
july 6 | purchases | 30 | 130 | 50 | 120 | 6000 | |||
30 | 130 | 3900 | |||||||
july 20 | purchase | 90 | 140 | 50 | 120 | 6000 | |||
30 | 130 | 3900 | |||||||
90 | 140 | 12600 | |||||||
july 31 | sale | 90 | 140 | 12600 | 20 | 120 | 2400 | ||
30 | 130 | 3900 | |||||||
30 | 120 | 3600 | |||||||
total of cost of goods sold and nding inventory | 150 | 20100 | 20 | 2400 |
c) perpetual lifo method :
goods received or purchased | goods sold or cost of goods sold | ending inventory | |||||||
date | particular | no. of units | cost per unit in $ | no. of units | cost per unit in $ | cost of goods sol;d in $ | no. of units | cost per unit in $ | ending inventory in $ |
july 1 | beginning inventory | 50 | 120 | 6000 | |||||
july 6 | purchases | 30 | 130 | 50 | 120 | 6000 | |||
30 | 130 | 3900 | |||||||
july 9 | sale | 30 | 130 | 3900 | 10 | 120 | 1200 | ||
40 | 120 | 4800 | |||||||
july 20 | purchase | 90 | 140 | 10 | 120 | 1200 | |||
ifo | periodic lifo | perpetual | 90 | 140 | 12600 | ||||
july 31 | sale | 80 | 140 | 11200 | 10 | 120 | 1200 | ||
10 | 140 | 1400 | |||||||
total of cost of goods sold and nding inventory | 150 | 19900 | 20 | 2600 |
pepetual fifo | periodic lifo | perpetual lifo | |
cost of goods sold | $19700 | $20100 | $19900 |
cost of ending inventory | $2800 | $2400 | $2600 |
thank you
please give your rating and feed back
Problem V: (6 pts) Linton Corp. adopted the dollar-value LIFO (DVL) method on December 31, 2018...
Problem IV: (4.5 pts) Woodberry Corp. uses the dollar-value LIFO (DVL) inventory costing method. It has the following normal account balances at 12/31/20 before the year-end adjustment to convert the cost of its inventory to LIFO using the DVL method: Inventory (at FIFO costs) LIFO reserve S 200,000 dr 25,000 cr At the end of 2020, Woodberry computes the cost of its ending inventory using the DVL method to be $160,000 Required: In the journal below, prepare the year-end entry...
At the beginning of 2018, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method. On that date the value of its one inventory pool was $94,000. The company uses an internally generated cost index to convert ending inventory to base year. Required: Determine the missing amounts in the inventory data for 2018 through 2021. Ending Ending Year Ended Inventory at Inventory at December 31 Year-End costs Base-Year Costs Cost Index 2018 $ 111,300 $ 106,000 1.05 2019 $...
At the beginning of 2018, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method. On that date the value of its one inventory pool was $94,000. The company uses an internally generated cost index to convert ending inventory to base year. Required: Determine the missing amounts in the inventory data for 2018 through 2021 Ending Inventory at DVL cost Ending Ending Year Ended Inventory at Inventory at December 31 Year-End costs Base-Year Costs Cost Index 2018 S 111,300...
1. Sheffield Corp. adopted the dollar-value LIFO method of inventory valuation on December 31, 2016. Its inventory at that date was $1,120,000 and the relevant price index was 100. Information regarding inventory for subsequent years is as follows: Date Inventory at Current Prices Current Price Index December 31, 2017 $1,293,630 107 December 31, 2018 1,413,350 115 December 31, 2019 1,590,000 125 What is the cost of the ending inventory at December 31, 2019 under dollar-value LIFO? A. $1,209,000 B. $1,293,630...
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Cost Retail Beginning inventory $ 81,400 $ 148,000 Net purchases 101,200 261,000 Net markups 6,000 Net markdowns 14,000 Net sales 233,000 Retail price index, 12/31/18 1.05 Required: Calculate the estimated ending inventory and cost of goods sold for 2018. On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for...
Burton Company uses the LIFO perpetual method for financial reporting and tax purposes. A summary of Burton's inventory for the current year is presented below. '(Click the icon to view the inventory transactions.) 5. Read the requirements2. Requirement a. Compute the ending inventory and cost of goods sold for the current year. Begin by preparing Burton Stores' perpetual inventory record under the last-in, first-out (LIFO) method for the year. (When entering the layers for the units sold, enter the first...
Help Seve On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018 Retail price Index. 12/31/1 Required: Calculate the estimated ending inventory and cost of goods sold for 2018 Ending inventory Ending invertory at cost Cost of goods sold < Prey 4 of 10 Next >
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Cost Retail 73,150 $ 133,000 Beginning inventory Net purchases Net markups 113,400 257,000 8,000 13,000 Net markdowns Net sales 224,000 1.12 Retail price index, 12/31/18 Required: Calculate the estimated ending inventory and cost of goods sold for 2018. Ending inventory at retail Ending inventory at cost Cost of goods sold 161,000 X X
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Beginning inventory Net purchases Net markups Net markdowns Net sales Retail price index, 12/31/18 Cost Retail $ 81,760 $ 146,000 123,360 265,000 4,000 12,000 238,000 1.10 Required: Calculate the estimated ending inventory and cost of goods sold for 2018. Ending inventory at retail Ending inventory at cost Cost of goods sold
On January 1, 2018, the Brunswick Hat Company adopted the dollar-value LIFO retail method. The following data are available for 2018: Cost Retail Beginning inventory $ 73,150 $ 133,000 Net purchases 113,400 257,000 Net markups 8,000 Net markdowns 13,000 Net sales 224,000 Retail price index, 12/31/18 1.12 Required: Calculate the estimated ending inventory and cost of goods sold for 2018. Ending inventory at retail Ending inventory at cost Cost of goods sold