laker company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system. For specific identification, any inventory consists of 180 units from the January 30 purchase, five units from the January 20 purchase, and 15 units from the beginning inventory.

(PLEASE EXPLAIN HOW YOU GOT EACH ANSWER/ SHOW YOUR WORK. NEEDED FOR EXCEL FORMAT, ESPECIALLY FOR #2,3, AND 4)

- thank you

1.) complete the table to determine the cost assigned to any inventory and cost of goods sold using specific identification

2.) determine the cost the same to ending inventory and to cost of goods sold using weighted average

3.) determine the cost to sign to ending inventory and to cost goods sold using FIFO

4.) determine the cost assigned to any inventory and to cost of goods sold using LIFO

Laker Company reported the following lanuary purchases and sales data for its only product. The Company uses a perpetual imventory system. For specific identification, ending irventory consists of 180 units from the lanuary 30 purchase, 5 units from the January 20 purchase, and 15 units from beginning inventory. Required: 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification. (Use cells A2 to 112 from the given information to complete this question.) 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. (Use cells A2 to L12 from the given information to complete this question.) 3. Determine the cont assigned to ending inventory and to cost of goods sold uving FFO (Use cells A2 to 112 from the gives isformation to complete this question.) 4. Determine the cost assigned to ending inventory and to cost of goods sold using tifo. (Use cells A2 to ti2 from the given information to complete this question.) (1) You must use an Excel formula for the following cell(s): 'Graded Worksheet'! J40, 'Graded Worksheet'!L40 Legend Graded cell: Leave blank if no answer is needed. Scratchpad: Use as a non-graded workspace