need help asap Has to be in the excel format

i posted

Chapter 6 - inventory On-line Homework Glee Distribution markets CDs of the performing artist Unique. At the beginning of Oetober, Glee had in beginning inventory 4,800 of Unique's CDs with a unit cost of \$7. During October, Glee made the following purchases of Unique's CDs. During Oetober, 26.000 units were sold. Glee uses a periodic inventory system. Determine the cost of goods available for sale. Determine (1) the ending inventory and (2) the cost of goods sold under cach of the assumed cost flow methods (FIFO, LIFO, and average-cost). (Round answers to 0 decimat places, e.g. 1,250.) (b)