using excel functions

4. Shelleys Dress Shops inventory at cost on January 1 was $32,950. Its retail value is $49,100. During the year, Shelley purchased additional merchandise at a cost of $195,800 with a retail value of $420,000. The net sales at retail for the year were $320,500. Calculate Shelleys inventory at cost by the retail method. Round cost ratio to nearest hundredth percent.

5. The manager of Sals Department Store is having difficulty calculating the inventory turnover at retail. The beginning inventory at retail was $94,100, and the ending inventory at retail was $98,154. The stores net sales were $488,000. The cost of goods were $410,000. Could you assist the manager by computing the turnover to the nearest hundredth?