Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2018 are as follows: Cost Retail
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.
Average Cost Application |
Conventional Application |
|
Estimate Ending Inventory at retail | ||
Estimate Ending Inventory at Cost | ||
Estimated Cost of goods sold |
Answer:
1) Average Cost Method :-
Particulars | Cost ($) | Retail ($) |
Beginning Inventory | 89000 | 179000 |
Add : Purchase | 352000 | 579000 |
Less : Purchase Returns | (6900) | (10900) |
Add : Freight in | 8900 | |
Net Markup | 15900 | |
Less : Net Markdowns | (11900) | |
Abnormal Spoilage | (4512) | (7900) |
Goods Available for sale (A) | 438488 | 743200 |
Less : Normal Spoilage | (2900) | |
Less : Sales | ||
Net Sales (539000-9900) | (529100) | |
Employee Disccounts | (3900) | |
Estimated Ending Inventory at Retail (B) | 207300 | |
Less : Estimated Ending Inventory at Cost (See Below) (B) | (122307) | |
Estimated Cost of goods sold (A-B) | 316181 | 535900 |
Cost to Retail % :-
= (Goods Available for sale at cost / Goods Available for sale at retail)*100
= ($438488/ $743200)*100
= 59%
Amount of Estimated Ending Inventory at Cost :-
= Estimated Ending Inventory at Retail * Cost to Retail %
= $207300* 59%
= $122307
2) Conventional Method :-
Particulars | Cost ($) | Retail ($) |
Beginning Inventory | 89000 | 179000 |
Add : Purchase | 352000 | 579000 |
Less : Purchase Returns | (6900) | (10900) |
Add : Freight in | 8900 | |
Net Markup | 15900 | |
Abnormal Spoilage | (4512) | (7900) |
Goods Available for sale (Before Net Markdowns) | 438488 | 755100 |
Less : Net Markdowns | (11900) | |
Goods Available for Sale (After Net Markdowns) | ||
Less : Normal Spoilage | (2900) | |
Less : Sales | ||
Net Sales (539000-9900) | (529100) | |
Employee Disccounts | (3900) | |
Estimated Ending Inventory at Retail | 207300 | |
Less : Estimated Ending Inventory at Cost (See Below) (B) | (120379) | |
Estimated Cost of goods sold (A-B) | 318109 | 547800 |
Cost to Retail % :-
= (Goods Available for sale at cost / Goods Available for sale at retail)*100
= ($438488/ $755100)*100
= 58.07%
Amount of Estimated Ending Inventory at Cost :-
= Estimated Ending Inventory at Retail * Cost to Retail %
= $207300 20* 58.07%
= $120379
Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold....
Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2018 are as follows: 33 Retail Cost $ 93,000 $183,000 583,000 Beginning inventory Purchases 362,000 9,300 7,300 Freight-in Purchase returns 11,300 20 Net markups 16,300 12,300 3,300 8,300 polnts Net markdowns Normal spoilage Abnormal spoilage 4,884 X 0228:31 Sales 543,000 Sales returns 10,300 The company records sales net of employee discounts. Discounts for 2018 totaled $4,300. Required: 1. Estimate Sparrow's ending inventory...
Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Abnormal spoilage Sales Sales returns Cost Retail $ 88,000 $178,000 356,000 578,000 8,800 6,800 10,800 15,800 11,800 2,800 4,867 7,800 538,000 9,800 The company records sales net of employee discounts. Employee discounts for 2021 totaled $3,800. Required: 1. Estimate Sparrow's ending inventory and cost of goods...
Almaden Valley Variety Store uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2018 are as follows: Cost Retail Beginning inventory $ 19,000 $ 27,000 Purchases 109,600 172,000 Freight-in 7,600 Purchase returns 7,500 10,500 Net markups 9,500 Net markdowns 6,500 Normal spoilage 4,900 Net sales 159,000 Required: Complete the table below to estimate the ending inventory and cost of goods sold for 2018, applying the conventional retail method Cost Retail Cost-to-Retail Ratio Beginning...
Required information [The following information applies to the questions displayed below.) Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Cost $ 94,000 364,000 9,400 7,400 Retail $184,000 584,000 Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Abnormal spoilage Sales Sales returns 1,400 16,400 12,400 3,400 8,480 544,000 10,400 4,919 The company records sales net of employee discounts. Employee discounts for 2021 totaled...
Required information [The following information applies to the questions displayed below.) Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Cost $ 87,000 359,000 8,700 6,700 Retail $177,000 577,000 Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Abnormal spoilage Sales Sales returns 10,700 15,700 11,700 2,700 7,700 537,000 9,700 4,240 The company records sales net of employee discounts. Employee discounts for 2021 totaled...
Required information (The following information applies to the questions displayed below. Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Retail Cost 93,000 362,000 9,300 $183,000 583,000 Beginning inventory Purchases Freight-in Purchase returns Net markups 11,300 16,300 12,300 3,300 8,300 543,000 10,300 7,300 Net markdowns Normal spoilage Abnormal spoilage 4,884 Sales Sales returns The company records sales net of employee discounts. Employee discounts for 2021 totaled $4.300....
Required information [The following information applies to the questions displayed below.] Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Cost $ 94,000 364,000 9,400 7,400 Retail $184,000 584,000 Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Abnormal spoilage Sales Sales returns 11,400 16,400 12,400 3,400 8,400 544,000 10,400 4,919 The company records sales net of employee discounts. Employee discounts for 2021 totaled...
Required information [The following information applies to the questions displayed below.) Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Cost $ 88,000 356,000 8,800 6,800 Retail $178,000 578,000 Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Abnormal spoilage Sales Sales returns 10,800 15,800 11,800 2,800 7,800 538,000 9,800 4,867 The company records sales net of employee discounts. Employee discounts for 2021 totaled...
Required information [The following information applies to the questions displayed below.] Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Cost Retail Beginning inventory $ 88,000 $ 178,000 Purchases 356,000 578,000 Freight-in 8,800 Purchase returns 6,800 10,800 Net markups 15,800 Net markdowns 11,800 Normal spoilage 2,800 Abnormal spoilage 4,867 7,800 Sales 538,000 Sales returns 9,800 The company records sales net of employee discounts. Employee discounts for 2021...
Required information [The following information applies to the questions displayed below.] Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold. Data for 2021 are as follows: Cost $ 94,000 364,000 9,400 7,400 Retail $184,000 584,000 Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Abnormal spoilage Sales Sales returns 11,400 16,400 12,400 3,400 8,400 544,000 10,400 4,919 The company records sales net of employee discounts. Employee discounts for 2021 totaled...