Need Help asap Needs to be in excel format

Chapter 6 - Inventory On-line Homework Glee Distribution markets CDs of the performing artist Unique. At the beginning of October, 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 October, 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 each of the assumed cost flow methods (FIFO, LIFO, and average-cost). (Round answers to 0 decimal places, e.g. I,250.)