What are the formulas for each problem and specifically the excel formulas?

Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 180 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. 4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. system. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. 4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 180 units from the January 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. 4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. system. 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO. Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. 4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO