UConn Inc. uses a perpetual inventory system. The following transaction took place during the month of December. As of December 1^st UConn Inc. had 2,000 units of product at a cost of $3 per unit in beginning inventory.

December 3^rd - 3,500 units purchased @ $5 per unit.

December 4^th - 3500 units purchased @ $7 per unit.

December 6^th - Sold 2,000 units @ $12.50 per unit.

December 14^th 4,000 units purchased @ $15 per unit.

December 20^th Sold 3,000 units @ $23 per unit.

December 24^th 8,000 units purchased @ $9 per unit.

Please solve in excel and send me link to download excel file. Need this asap.

1. If UConn Inc. adopts the FIFO costing method then what is the cost of goods sold amount for the month of December?

2. If UConn Inc. adopts the LIFO method, then what is the ending inventory amount for the month of December?

3. If UConn Inc. adopts the Moving Average costing method, then what is the cost of Ending Inventory and the end of December?

4. If UConn Inc. adopts the Moving Average costing method, then what is the cost of goods sold for the month of December?

5. If UConn Inc. adopts the LIFO costing method, then what is the Gross Margin for December?