In: Accounting
Determine the ending inventory under the conventional retail
method for the furniture department of Bonita Department Stores
from the following data. (Round ratio of cost to
selling price to 2 decimal places, e.g. 15.25% and final answer to
0 decimal places, e.g. 5,125.)
Cost | Retail | ||||
Inventory, Jan. 1 | $154,200 | $291,700 | |||
Purchases | 1,361,600 | 2,249,100 | |||
Freight-in | 69,200 | ||||
Markups, net | 92,000 | ||||
Markdowns, net | 48,600 | ||||
Sales revenue | 2,251,400 |
Ending inventory | $ |
Computation of the ending inventory at cost | |||
by the conventional retail inventory method. | |||
Cost ($) | Retail ($) | ||
Beginning Inventory | 154,200.00 | 291,700.00 | |
Net Purchases | 1,361,600.00 | 2,249,100.00 | |
Freight | 69,200.00 | - | |
Totals | 1,585,000.00 | 2,540,800.00 | |
Add: Net markups | - | 92,000.00 | |
1,585,000.00 | 2,632,800.00 | ||
Deduct: Net markdowns | - | 48,600.00 | |
Sales price of goods available | 1,585,000.00 | 2,584,200.00 | |
Deduct: Net sales | - | 2,251,400.00 | |
Ending inventory | 1,585,000.00 | 332,800.00 | |
Cost-to-retail ratio = 1,585,000 / 2,632,800 = 60.20% | |||
Ending inventory at cost =332,800 * 60.20% = $200,352 |