In: Accounting
Presented below is information related to Sage Hill,
Inc.
|
Cost |
Retail |
|||
|---|---|---|---|---|
| Beginning inventory | $450,500 | $795,000 | ||
| Purchases | 2,014,000 | 3,551,000 | ||
| Freight on purchases | 85,860 | |||
| Markups | 185,500 | |||
| Markup cancellations | 148,400 | |||
| Abnormal shortage | 15,900 | 27,560 | ||
| Markdowns | 93,280 | |||
| Markdown cancellations | 12,720 | |||
| Employee discounts | 5,512 | |||
| Sales revenue | 3,789,500 | |||
| Sales returns | 106,000 | |||
| Normal shortage | 18,550 | |||
| Purchase returns | 23,320 | 43,460 |
Compute ending inventory by the conventional retail inventory
method. (Round percentages for computational purposes
to 1 decimal place, e.g. 0.4158 to 41.6% and final answer to 0
decimal places, e.g. 5,275.)
The ending inventory equals?
Solution:
| Estimated ending inventory at cost [$ 523,958*58.2%] | $ 304,944 |
working:
| Cost $ | Retail $ | Cost-to-Retail Ratio | |
| Beginning inventory | $ 450,500 | $ 795,000 | |
| Gross Purchases | $ 2,014,000 | $ 3,551,000 | |
| freight in | $ 85,860 | ||
| Purchase returns | $ (23,320) | $ (43,460) | |
| Purchase discount | $ - | ||
| Net Markups [185500-148400] | $ 37,100 | ||
| Abnormal Spoilage | $ (15,900) | $ (27,560) | |
| Goods available for sale | $ 2,511,140 | $ 4,312,080 | |
| Cost-to-Retail percentage | 58.2% | ||
| Less: Net sales | |||
| Gross Sales | $ (3,789,500) | ||
| Sales Returns | $ 106,000 | ||
| Normal Spoilage | $ (18,550) | ||
| Empolyee discounts | $ (5,512) | ||
| Net Markdown [12720-93280] | $ (80,560) | ||
| Estimated ending inventory at retail | $ 523,958 | ||
| Estimated ending inventory at cost [$ 523,958*58.2%] | $ 304,944 |