Question

In: Accounting

Retail Inventory Method Beginning Inventory At cost $100,000 At retail $125,000 Net purchases At cost $300,000...

Retail Inventory Method

Beginning Inventory
At cost	$100,000
At retail	$125,000
Net purchases
At cost	$300,000
At retail	$360,000
Net markups	$15,000
Net markdowns	$10,000
Net sales at retail	$280,000
Average cost per unit	$8.00
Average selling price per unit	$10.00

Using the gross profit inventory estimation method:

1. Compute gross profit on sales.

2. Compute cost of goods sold.

3. Compute the estimated cost of ending inventory.

Using the conventional (average LCM) inventory estimation method:

1. Compute the ending inventory at retail.

2. Compute cost-to-retail ratio.

3. Compute the estimated cost of ending inventory.

Expert Solution

Solution : Gross profit inventory estimation method

1). Computation of gross profit on sales :

Average selling price per unit = $ 10

Average cost per unit = $ 8

Gross profit = $ 2

Gross profit (%) on sales = $2 / $ 10 X 100 = 20%

Hence it's cost of goods sold would be 80% of sales.

2). Cost of goods sold = Sales X 80%

= $ 2,80,000 X 80%

= $ 2,24,000

3). Estimated Cost of ending inventory = Cost of goods available for sale - Cost of goods sold

= $ 4,00,000 - $ 2,24,000

= $ 1,76,000

Working :

Cost of goods available for sale = Begning inventory at cost + Net purchases at cost

= $ 1,00,000 + $ 3,00,000

= $ 4,00,000

Conventional inventory estimation method :

1). Computation of ending inventory at retail :

Begning inventory at retail = $ 1,25,000

Add : Net purchases at retail = $ 3,60,000

Add: Net markups. = $ 15,000

Less : Net markdowns. = $ 10,000

_________________

$ 4,90,000

Less: Net Sales at retail. $ 2,80,000

_____________________

Estimated ending inventory $ 2,10,000

at retail

2). Computation of cost to retail ratio :-

Begning inventory at cost. = $ 1,00,000

Add: Net purchases at cost = $ 3,00,000

__________________

$ 4,00,000

Cost to retail ratio = $ 4,00,000 / $ 4,90,000 X 100 = 81.63%

3). Computation of estimated cost of ending inventory :

= Estimated ending inventory at retail x cost to retail ratio

= $ 2,10,000 X 81.63%

= $ 1,71,423

ekkarill92 answered 1 year ago

Vaughn Inc. had beginning inventory of $12,411 at cost and $19,700 at retail. Net purchases were...

Vaughn Inc. had beginning inventory of $12,411 at cost and $19,700 at retail. Net purchases were $99,730 at cost and $153,700 at retail. Net markups were $10,500, net markdowns were $6,400, and sales revenue was $149,700. Assume the price level increased from 100 at the beginning of the year to 105 at year-end. Compute ending inventory at cost using the dollar-value LIFO retail method. (Round ratios for computational purposes to 1 decimal place, e.g. 78.7% and final answer to 0...

Swifty Inc. had beginning inventory of $11,000 at cost and $19,800 at retail. Net purchases were...

Swifty Inc. had beginning inventory of $11,000 at cost and $19,800 at retail. Net purchases were $122,300 at cost and $184,200 at retail. Net markups were $11,000, net markdowns were $7,000, and sales revenue was $140,100. Compute ending inventory at cost using the conventional retail method. (Round ratios for computational purposes to 0 decimal places, e.g. 78% and final answer to 0 decimal places, e.g. 28,987.) Ending inventory using the conventional retail method

Pharoah Inc. had beginning inventory of $12,017 at cost and $19,700 at retail. Net purchases were...

Pharoah Inc. had beginning inventory of $12,017 at cost and $19,700 at retail. Net purchases were $112,000 at cost and $174,400 at retail. Net markups were $9,100, net markdowns were $7,400, and sales revenue was $160,500. Assume the price level increased from 100 at the beginning of the year to 105 at year-end. Compute ending inventory at cost using the dollar-value LIFO retail method. (Round ratios for computational purposes to 1 decimal place, e.g. 78.7% and final answer to 0...

Sheffield Inc. had beginning inventory of $25,200 at cost and $42,000 at retail. Net purchases were...

Sheffield Inc. had beginning inventory of $25,200 at cost and $42,000 at retail. Net purchases were $252,000 at cost and $357,000 at retail. Net markups were $21,000, net markdowns were $14,700, and sales revenue was $308,700. Assume the price level increased from 100 at the beginning of the year to 115 at year-end. Compute ending inventory at cost using the dollar-value LIFO retail method. (Round ratios for computational purposes to 1 decimal place, e.g. 78.7% and final answer to 0...

Cost Retail Beginning inventory 347,900 784,000 Purchases 730,100 980,000 Freight in &nb

Cost Retail Beginning inventory 347,900 784,000 Purchases 730,100 980,000 Freight in 39,200 - Mark ups - 98,000 Mark downs - 116,375 Sales - 686,000 Find Ending Inventory using avg. cost, conventional, LIFO methods

Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods...

Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods Sold Inventory Event Unit Cost Total Cost Unit Cost Total Cost Total Cost QTY Bought Qty sold Qty Unit Cost Beginning Inventory 150 755 First Sale 120 First Purchase 400 785 Second Sale 200 Second Purchase 300 805 Sale 290 The firm uses the perpetual inventory system and there are 240 units of the item on hand at the end of the year A....

Presented below is information related to Flounder Company. Cost Retail Beginning inventory $ 62,430 $90,900 Purchases...

Presented below is information related to Flounder Company. Cost Retail Beginning inventory $ 62,430 $90,900 Purchases (net) 113,840 183,000 Net markups 9,421 Net markdowns 26,181 Sales revenue 182,600 Compute the ending inventory at retail. Ending inventory $ Link to Text Compute a cost-to-retail percentage under the following conditions. (Round ratios to 2 decimal places, e.g. 78.74%) Cost-to-retail percentage (1) Excluding both markups and markdowns. % (2) Excluding markups but including markdowns. % (3) Excluding markdowns but including markups. % (4)...

Presented below is information related to Pronghorn Company. Cost Retail Beginning inventory $ 61,600 $107,300 Purchases...

Presented below is information related to Pronghorn Company. Cost Retail Beginning inventory $ 61,600 $107,300 Purchases (net) 120,170 180,700 Net markups 10,325 Net markdowns 26,679 Sales revenue 187,090 a) Compute ending inventory at lower-of-cost-or-market. b) Compute cost of goods sold based on (a) c) Compute gross margin based on (a)

Presented below is information related to Martinez Company. Cost Retail Beginning inventory $ 53,760 $107,700 Purchases...

Presented below is information related to Martinez Company. Cost Retail Beginning inventory $ 53,760 $107,700 Purchases (net) 119,400 204,800 Net markups 9,605 Net markdowns 26,513 Sales revenue 175,600 Compute the ending inventory at retail. Ending inventory $ Compute a cost-to-retail percentage under the following conditions. (Round ratios to 2 decimal places, e.g. 78.74%) Cost-to-retail percentage (1) Excluding both markups and markdowns. % (2) Excluding markups but including markdowns. % (3) Excluding markdowns but including markups. % (4) Including both markdowns...

Presented below is information related to Skysong Company. Cost Retail Beginning inventory $ 56,640 $99,900 Purchases...

Presented below is information related to Skysong Company. Cost Retail Beginning inventory $ 56,640 $99,900 Purchases (net) 111,250 216,800 Net markups 10,119 Net markdowns 24,768 Sales revenue 173,490 Compute the ending inventory at retail. Ending inventory $ Compute a cost-to-retail percentage under the following conditions. (Round ratios to 2 decimal places, e.g. 78.74%) Cost-to-retail percentage (1) Excluding both markups and markdowns. % (2) Excluding markups but including markdowns. % (3) Excluding markdowns but including markups. % (4) Including both markdowns...