PLEASE PUT SOLUTION IN THE SAME FORMAT AS THE IMAGE THANK YOU!

San Lorenzo General Store uses a periodic inventory system and the retail inventory method to estimate ending inventory and cost of goods sold. The following data are avallable for the month of October 2021: Retail Cost Beginning inventory Net purchases Net markups $39,000 17,290 $54,000 32,000 1,600 1,000 36,000 Net markdowns Net sales Required: Complete the table below to estimate the average cost of ending inventory and cost of goods sold for October using the information provided. Cost-to-Retail Ratio Retail Cost Beginning inventory Plus: Net purchases Net markups Less: Net markdowns Goods available for sale Cost-to-retail percentage Less: Net sales Estimated ending inventory at retail Estimated ending inventory at cost Estimated cost of goods sold