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 $ 21,e00 $ 29,000 174,000 Purchases 111,600 2,700 4,000 Freight-in 11,500 10,500 7,500 5,100 161,000 Purchase returns Net markups Net markdowns Normal spoilage Net sales Required: Complete the table below to estimate the ending inventory and cost of goods sold for 2018, applying the conventional retall method. Cost-to-Retail Cost Retail Ratio Beginning inventory Plus: Purchases Freight-in Less: Purchase returns Plus: Net markups Less: Net markdowns Goods available for sale Cost-to-retail percentage Less: Normal spoilage Net sales Estimated ending inventory at retail Estimated ending inventory at cost Estimated cost of goods sold