astion has been opened in a new tab. In order to continue your assignment, please save your Excel question. 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 soid using LIFO. Navigation: 1. Use the Open Excel in New Tab button to launch this question. When finished in Excel, use the Save and Roturn to Assignment button in the lower right to return to Connect