Almaden Valley Variety Store uses the retail inventory method to estimate ending inventory and cost of goods sold. The following data are available: Beginning inventory Purchases Freight-in Purchase returns Dok Net markups Net markdowns int Cost $27,000 117,600) 7,270 7,000) Retail $ 35,000 180,000 9,000 13,500 10,500 5,700 167,000 Normal spoilage Net sales Ent ences Required: Complete the table below to estimate the ending inventory and cost of goods sold, applying the conventional retail method using the Information provided. Note: 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. Cost-to-Retail Cost Retail Ratio Beginning inventory $ Purchases 27,000 $ 117,600 35,000 180,000 Freight-in Purchase returns Net markups 7,270 (7,000) (9,000) 13,500 219,500 Net markdowns Goods available for sale. 144,870 Cost-to-retail percentage Normal spoilage (10,500) 209,000 69.32 % (5,700)