In: Accounting
Sparrow Company uses the retail inventory method to estimate
ending inventory and cost of goods sold. Data for 2018 are as
follows:
Cost | Retail | |||||
Beginning inventory | $ | 89,000 | $ | 179,000 | ||
Purchases | 352,000 | 579,000 | ||||
Freight-in | 8,900 | |||||
Purchase returns | 6,900 | 10,900 | ||||
Net markups | 15,900 | |||||
Net markdowns | 11,900 | |||||
Normal spoilage | 2,900 | |||||
Abnormal spoilage | 4,512 | 7,900 | ||||
Sales | 539,000 | |||||
Sales returns | 9,900 | |||||
The company records sales net of employee discounts. Discounts for
2018 totaled $3,900.
Required:
1. Estimate Sparrow’s ending inventory and cost of
goods sold for the year using the retail inventory method and the
average cost application.
2. Estimate Sparrow’s ending inventory and cost of
goods sold for the year using the retail inventory method and the
conventional application.
Sparrow Company
Cost |
Retail |
|
Beginning Inventory |
$89,000 |
$179,000 |
Add: Purchases |
$352,000 |
$579,000 |
Add: Freight - in |
$8,900 |
|
Less: Purchase Returns |
-6,900 |
($10,900) |
Add: net markups |
$15,900 |
|
Less: net markdowns |
($11,900) |
|
Less: abnormal spoilage |
($4,512) |
($7,900) |
Goods available for sale |
$438,488 |
$743,200 |
Cost/Retain percentage |
59% |
|
Less: normal spoilage |
($2,900) |
|
Less: Net Sales |
($529,100) |
|
Employee Discounts |
($3,900) |
|
Ending Inventory at Retail |
$207,300 |
|
Ending Inventory at Cost |
($122,307) |
|
Cost of Goods Sold |
$316,181 |
Ending Inventory = $122,307
Cost of goods sold = $316,181
Cost to retail ratio = 438,488/743,200 = 59%
Net sales = sales – sales discounts
= 539,000 – 9,900 = $529,100
Cost |
Retail |
|
Beginning Inventory |
$89,000 |
$179,000 |
Add: Purchases |
$352,000 |
$579,000 |
Add: Freight - in |
$8,900 |
|
Less:Purchase Returns |
-6,900 |
($10,900) |
Add: net markups |
$15,900 |
|
Less: abnormal spoilage |
($4,512) |
($7,900) |
$438,488 |
$755,100 |
|
Cost/Retain percentage |
58.10% |
|
Less: net markdowns |
($11,900) |
|
Goods available for sale |
$743,200 |
|
Less: normal spoilage |
($2,900) |
|
Less: Net Sales |
($529,100) |
|
Employee Discounts |
($3,900) |
|
Ending Inventory at Retail |
$207,300 |
|
Ending Inventory at Cost |
($120,441) |
|
Cost of Goods Sold |
$318,047 |
Ending Inventory = $120,441
Cost of goods sold = $318,047
Cost to retail ratio = 438,488/755,100 = 58.10%
Net sales = sales – sales discount
= 539,000 – 9,900 = $529,100