Solution:
| Particulars | At Cost | At Retail |
| April 1, Beginning Inventory | 75360 | 97968 |
| Purchases | 112480 | 146224 |
| Purchase returns and allowances | 4120 | 5356 |
| Freight In | 2580 | 0 |
| Sales | 141600 | 141600 |
| Sales return and allowances | 1260 | 1260 |
| Employees Discount | 1000 | 1000 |
| Normal Shortage | 640 | 640 |
| April 30, Physical Inventory at retail | 66600 |
1) As per retail-Shortage
Total Sales during the period = Sales - Sales returns & allowances-Employee Discount
=141600-1260-1000 = 139340
Retails Goods Available for sale = Opening Inventory +Purchases -Purchase return-Normal Shortage
= 97968+146224-5356-6400= 238196
Closing Inventory = Goods Available for sale - Sales during the period
= 238196-139340= 98856
However, closing inventory as per retail = 66600
Shortage/Loss as per retail = 98856-66600= 32256
2) As per Cost
Beginning Inventory as per cost = 75360
Beginning Inventory as per retail = 97968
Purchases as per cost = Purchase - Purchase returns = 112480-4120=108360
Purchases as per retail = Purchase - Purchase returns = 146224-5356=140868
Cost to Retail Ratio = Cost of beginning inventory+ Cost of purchase inventory/ Retail value of beginning inventory +Retail value of goods purchase during the year
Cost to Retail Ratio = 75360+108360/97968+140868 = 76.92%
Closing Inventory at cost = Retail Closing inventory(Given)* Cost to Retail Ratio
97968*76.92%=75360
Closing Inventory = Opening+ Purchase - Purchase Return +Freight in - Sales +Sales return - Employees discount - Normal Shortage
= 75360+112480-4120+2580-(141600*76.92%)+(1260*76.92%)-1000-640= 76706
Shortage/Loss as per cost method = 76706-75360= 1346
2) Stonier Company operates a large discount store and uses the retail inventory method to estimate...
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...
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...
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...
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...
LeMay Department Store uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to one of its largest departments for the month of March 2021: Cost Retail Beginning inventory $ 46,000 $ 66,000 Purchases 213,000 406,000 Freight-in 15,558 Purchase returns 7,000 9,000 Net markups 6,400 Net markdowns 4,100 Normal breakage 9,000 Net sales 286,000 Employee discounts 2,400 Sales are recorded net of employee discounts. 1. Compute estimated ending inventory and cost of...
Almaden Valley Variety Store uses the retail Inventory method to estimate ending Inventory and cost of goods sold. Data for 2021 are as follows: Cont $ 30.000 120,600 2.230 4.000 Retail $ 30.000 183,000 Beginning inventory Purchases Preight-in Purchase returns Net Darkups Net markdowns Normal spoilage Net sales Bock 10,500 15,000 12.000 6,000 170,000 eferences Required: Complete the table below to estimate the ending inventory and cost of goods sold for 2021, applying the conventional retail method using the information...
Grand Department Store, Inc., uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of October 2021: Inventory, October 1, 2021: At cost $ 20,000 At retail 30,000 Purchases (exclusive of freight and returns): At cost 100,151 At retail 146,495 Freight-in 5,100 (continued) Purchase returns: At cost 2,100 2,800 2,500 265 800 At retail Additional markups Markup cancellations Markdowns (net) Normal spoilage and breakage 4,500...
Alquist Company uses the retail method to estimate its ending inventory. Selected information about its year 2018 operations is as follows: January 1, 2018, beginning inventory had a cost of $220,000 and a retail value of $350,000. Purchases during 2018 cost $2,130,000 with an original retail value of $3,500,000. Freight costs were $30,000 for incoming merchandise. Net additional markups were $400,000 and net markdowns were $300,000. Based on prior experience, shrinkage due to shoplifting was estimated to be $35,000 of...
Grand Department Store, Inc., uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of October 2018 3 Inventory, october 1, 2018: s 11,00e 21,000 At cost At retail Purchases (exclusive of freight and returns): 5 points At cost At retail Freight-in Purchase returns: 96,284 137,500 4,200 1,200 1,900 1,600 200 710 3,600 126,730 At cost At retail Additional markups Markup cancellations Markdowns (net) Normal...
LeMay Department Store uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to one of its largest departments for the month of March 2021: Cost Retail Beginning inventory $ 47,000 $ 67,000 Purchases 214,000 407,000 Freight-in 19,680 Purchase returns 7,500 9,500 Net markups 6,500 Net markdowns 4,200 Normal breakage 9,500 Net sales 287,000 Employee discounts 2,500 Sales are recorded net of employee discounts.