Dollar-Value-LIFO This method shows all the inventory figures at dollar price rather than units. Under this inventory method, the units that are purchased last are sold first. Thus, it starts from the selling of the units recently purchased and ending with the beginning inventory. To Estimate: the ending inventory and cost of goods sold in 2016 using dollar-value LIFO retail method.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 9, Problem 9.9P

To determine

Dollar-Value-LIFO

This method shows all the inventory figures at dollar price rather than units. Under this inventory method, the units that are purchased last are sold first. Thus, it starts from the selling of the units recently purchased and ending with the beginning inventory.

To Estimate: the ending inventory and cost of goods sold in 2016 using dollar-value LIFO retail method.

Expert Solution

Explanation of Solution

Calculate the amount of estimated ending inventory and cost of goods sold at retail.

Details	Cost ($)	Retail ($)
Beginning inventory	28,000	40,000
Add: Net purchase	85,000	108,000
Freight-in	2,000
Net markups		10,000
Less: Net markdowns		(2,000)
Goods available for sale – Excluding beginning inventory	87,000	116,000
Goods available for sale – Including beginning inventory	115,000	156,000
Less: Net sales	0	(102,400)
Employees discounts		(600)
Estimated ending inventory at current year retail prices		53,000
Estimated ending inventory at cost (Refer Table 2)	(35,950)
Estimated Cost of Goods Sold	79,050

Table (1)

Working Notes:

Calculate base layer cost-to retail percentage.

Base layer cost-to retail percentage} = (Beginning inventory at costBeginning inventory at retail×100)=($28,000$40,000×100)= 70%

Calculate current year cost-to retail percentage.

Current year cost-to retail percentage} = (Goods available for sale at costGoods available for sale at retail×100)=($87,000$116,000×100)= 75%

Calculate the amount of estimated ending inventory at cost.

Ending inventory at dollar-value LIFO retail cost
Ending inventory at year-end retail prices ($)	Ending inventory at base year retail prices ($)	Inventory layers at base year retail prices ($)	Inventory layers converted to cost ($)
53,000	50,000	40,000 (Base)	28,000
		10,000 (2016)	7,950

Total ending inventory at dollar-value LIFO retail cost			35,950

Table (2)

Calculate the amount of ending inventory at base year retail prices.

Ending inventory at base year retail prices }= (Estimated ending inventory at retailRetail price index)=($53,0001.06)=$50,000

Calculate the amount of inventory layers at base year retail prices.

Inventory layers at base year retail prices }= Beginning inventory at retail=$40,000

Calculate the amount of inventory layers at current year retail prices.

Inventory layers at current year retail prices (2016) }= (Ending inventory at base year retail prices− Beginning inventory at retail)=$53,000−$40,000=$13,000

Calculate the amount of inventory layers converted to cost (Base).

Inventory layers converted to cost }=(Beginning inventory at retail× Base price index×Base layer cost-to retail percentage)=($40,000×1.00×70%)=$28,000

Calculate the amount of inventory layers converted to cost (2016).

Inventory layers converted to cost }=(Inventory layers at current year retail prices× Retail price index×Current year cost-to retail percentage)=($10,000×1.06×75%)=$7,950

To determine

To Estimate: the ending inventory and cost of goods sold in 2017 using dollar-value LIFO retail method.

Expert Solution

Explanation of Solution

Calculate the amount of estimated ending inventory and cost of goods sold at retail.

Details	Cost ($)	Retail ($)
Beginning inventory	35,950	53,000
Add: Net purchase	90,000	114,000
Freight-in	2,500
Net markups		8,000
Less: Net markdowns		(2,200)
Goods available for sale – Excluding beginning inventory	92,500	119,800
Goods available for sale – Including beginning inventory	128,450	172,800
Less: Net sales	0	(108,000)
Employees discounts		(1,000)
Estimated ending inventory at current year retail prices		63,800
Estimated ending inventory at cost (Refer Table 2)	(42,744)
Estimated Cost of Goods Sold	85,706

Table (3)

Working Notes:

Calculate base layer cost-to retail percentage.

Base layer cost-to retail percentage} = (Beginning inventory at costBeginning inventory at retail×100)=($28,000$40,000×100)= 70%

Calculate 2016 year cost-to retail percentage.

Current year cost-to retail percentage} = (Goods available for sale at costGoods available for sale at retail×100)=($87,000$116,000×100)= 75%

Calculate current year cost-to retail percentage.

Current year cost-to retail percentage} = (Goods available for sale at costGoods available for sale at retail×100)=($92,500$119,800×100)= 77.21%

Calculate the amount of estimated ending inventory at cost.

Ending inventory at dollar-value LIFO retail cost
Ending inventory at year-end retail prices ($)	Ending inventory at base year retail prices ($)	Inventory layers at base year retail prices ($)	Inventory layers converted to cost ($)
63,800	58,000	40,000 (Base)	28,000
		10,000 (2016)	7,950
		8,000 (2017)	6,794

Total ending inventory at dollar-value LIFO retail cost			42,744

Table (4)

Calculate the amount of ending inventory at base year retail prices.

Ending inventory at base year retail prices }= (Estimated ending inventory at retailRetail price index)=($63,8001.10)=$58,000

Calculate the amount of inventory layers at base year retail prices.

Inventory layers at base year retail prices }= Beginning inventory at retail=$40,000

Calculate the amount of inventory layers at current year retail prices.

Inventory layers at current year retail prices (2016) }= (Ending inventory at base year retail prices− Beginning inventory at retail)=$63,800−$40,000=$23,800

Calculate the amount of inventory layers converted to cost (Base).

Inventory layers converted to cost }=(Beginning inventory at retail× Base price index×Base layer cost-to retail percentage)=($40,000×1.00×70%)=$28,000

Calculate the amount of inventory layers converted to cost (2016).

Inventory layers converted to cost }=(Inventory layers at 2016 year retail prices× Retail price index×2016 year cost-to retail percentage)=($10,000×1.06×75%)=$7,950

Calculate the amount of inventory layers converted to cost (2017).

Inventory layers converted to cost }=(Inventory layers at current year retail prices× Retail price index×Current year cost-to retail percentage)=($8,000×1.10×77.21%)=$6,794

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

PLEASE HELP ME WITH THIS ACCOUNTING PROBLEM

Let's say that Dr. Tim’s Company purchased a heavy-duty truck on July 1, 2021, for $30,000. It was estimated that it would have a useful life of 10 years and then would have a trade-in value of $6,000. The company uses the straight-line method. It was traded on August 1, 2026, for a similar truck costing $42,000; $16,000 was allowed as trade-in value (also fair value) on the old truck and $26,000 was paid in cash. A comparison of expected cash flows for the trucks includes the exchange lacks commercial substance. What is the entry to record the trade-in? Truck (new) $42,000 Accumulated Depreciation $12,200 ($30,000 - $6,000) x (61 months / 120 months) Loss on Disposal of Trucks $1,800 ($30,000 - $12,200 - $16,000 [trade-in] Trucks (old)…

16. Candy Company projects the following sales: BB (Click on the icon to view the projected sales.) Candy collects sales on account in the month after the sale. The Accounts Receivable balance on January 1 is $12,300, which represents December's sales on account. Candy projects the following cash receipts from customers: BEE (Click on the icon to view the cash receipts from customers.) Recalculate cash receipts from customers if total sales remain the same but cash sales are only 5% of the total. Begin by computing the cash sales and sales on account for each month if cash sales are only 5% of the total. January February March Cash sales (5%) Sales on account (95%) Total sales $ 31,000 $ 27,000 $ 33,000 Data table X I Data table - X January February March January February March Cash sales (10%) $ 3,100 $ 27,900 Sales on account (90%) 2,700 $ 24,300 3,300 29,700 Cash receipts from cash sales Cash receipts from sales on account $ 3,100 $ 2,700 $ 12,300 27,900 3,300 24,300 $ 31,000 $…

Answer 2

Question

Chapter 9, Problem 9.9P

To determine

Dollar-Value-LIFO

This method shows all the inventory figures at dollar price rather than units. Under this inventory method, the units that are purchased last are sold first. Thus, it starts from the selling of the units recently purchased and ending with the beginning inventory.

To Estimate: the ending inventory and cost of goods sold in 2016 using dollar-value LIFO retail method.

Expert Solution

Explanation of Solution

Calculate the amount of estimated ending inventory and cost of goods sold at retail.

Details	Cost ($)	Retail ($)
Beginning inventory	28,000	40,000
Add: Net purchase	85,000	108,000
Freight-in	2,000
Net markups		10,000
Less: Net markdowns		(2,000)
Goods available for sale – Excluding beginning inventory	87,000	116,000
Goods available for sale – Including beginning inventory	115,000	156,000
Less: Net sales	0	(102,400)
Employees discounts		(600)
Estimated ending inventory at current year retail prices		53,000
Estimated ending inventory at cost (Refer Table 2)	(35,950)
Estimated Cost of Goods Sold	79,050

Table (1)

Working Notes:

Calculate base layer cost-to retail percentage.

Base layer cost-to retail percentage} = (Beginning inventory at costBeginning inventory at retail×100)=($28,000$40,000×100)= 70%

Calculate current year cost-to retail percentage.

Current year cost-to retail percentage} = (Goods available for sale at costGoods available for sale at retail×100)=($87,000$116,000×100)= 75%

Calculate the amount of estimated ending inventory at cost.

Ending inventory at dollar-value LIFO retail cost
Ending inventory at year-end retail prices ($)	Ending inventory at base year retail prices ($)	Inventory layers at base year retail prices ($)	Inventory layers converted to cost ($)
53,000	50,000	40,000 (Base)	28,000
		10,000 (2016)	7,950

Total ending inventory at dollar-value LIFO retail cost			35,950