Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Net sales $21,000 $ 29,000 111,600 174,000 2,700 4,000 11,500 10,500 7,500 5,100 161,000 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 provided. (Round ratio calculation to 2 decimal places (i.e., 0.1234 should be entered as 12.34%). Enter amounts to be deducted with a minus sign.) 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 provided. (Round ratio calculation to 2 decimal places (ie., 0.1234 should be entered as 12.34%). Enter amounts to be deducted with a minus sign.) Cost Retail Purchases Purchase returns Net markups Beginning inventory Freight-in $ 21,000 $ 29.000 111,600 174,000 2,700 (4,000) 10.500 213.500 Net markdowns (7,500) Goods available for sale 131,300 206 000 Cost-to-retail percentage Normal spoilage Net sales Estimated anding inventory at retail Estimated ending inventory at cost Estimated cost of goods sold $ Cost-to-Retail Ratio (5.100) (161,000) %6 39,900