you need not answer following questions , just give me a form for calculation of ending inventory at retail

On December 28, 20X4, Cockscomb, Inc. purchased inventory in anticipation of starting business on January 1, 20X5, the first day of its fiscal year. The inventory has a value of $390,000 at retail and $250,000 at cost. The company had the following items affecting sales and inventory for 20X5 COCKSCOMB, INC. RETAIL INVENTORY DATA FOR YEAR ENDING DECEMBER 31, 20X5 Cost Retail 970,000 60,000 Purchases Purchase Returns Gross Sales (after employee discounts) Markups Markup Cancellations Markdowns Markdown Cancellations Employee Discounts Granted Loss From Breakage (Normal) 1,460,000 80,000 1,460,000 20,000 40,000 45,000 20,000 15,000 2,500 In addition, the company had purchase discounts of $18,000, freight in of$79,000, and sales returns of $97,500 The company wants to compare various retail inventory methods to see which best fits their operational plans. You have been asked to prepare schedules showing what ending inventory and cost of goods sold will be under the methods available