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 15,000 23,000 105, 600 168,000 Beginning inventory Purchases Freight-in Purchase returns Net markups Net markdowns Normal spoilage Net sales 2,700 5,500 8,500 7,500 4, 500 4,500 155,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 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