Cobber inc.'s Inventory records for the month of November reveal the following: Inventory, November 1 200 units @ $18.00 November 4, purchase 250 units @ $18.50 November 7, sale 300 units @ $42.00 November 13, purchase 220 units @ $18.90 November 18, purchase 150 units @ $19.00 November 22, sale 380 units @ $42.50 November 24, purchase 200 units @ $19.20 November 28, sale 110 units @ $43.00 Selling and administrative expenses for the month were $10,800. Depreciation expense was $4,000. Cobber Inc.'s tax rate is 35%. Required 1. In Excel, create the schedule above in manner that it can be used to calculate the cost of goods sold and ending inventory under each of the following three methods assuming a periodic inventory system: (a) FIFO, (b) LIFO, and (c) weighted average. a. The inventory calculations are required to be calculated using the information above. (Use formulas, do not hard key numbers). 2. Calculate the gross profit and net income under each costing assumption