Pls put answers in excel format!!!

Laver Comparty reported the following lanuary purchases and sales data for its only product. The Company uses a perpetual inventory spstem. For spectic identification, ending inventory consists of 180 units from the January 30 purchase, 5 units from the Specific identification Data fanuary 20 purchase, and 15 units from beginning inventory. Pequired: 1. Complete the table to determine the cost assigned to ending imentory and cost of goods sold using spechic identification. (Use cells A2 to L12 from the given infermation to complete this question.) 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 L12 from the given information to complete this question.) 2. Determine the cost assigned to ending imentory and to cost of goods sold using weighted average. (Use cells A2 to L12 from the given information to complete this question.) (Use cells A2 to L12 from the given information to complete this question.) 4 Determine the cost assigned to ending imventory and to cost of gooos sold us figl (Use cells A2 to L12 from the given information to complete this question.)