Solution 1:
Computation of COGS and ending inventory - Specific identification | |||||||||
Particulars | Cost of goods available for sale | Cost of goods sold | Ending Inventory | ||||||
Nos of units | Unit Cost | Cost of goods available for sale | Nos of units sold | Unit Cost | Cost of goods sold | Nos of units in ending inventory | Unit Cost | Ending inventory | |
Beginning inventory | 240 | $16.50 | $3,960 | 215 | $16.50 | $3,547.50 | 25 | $16.50 | $412.50 |
Purchases: | |||||||||
20-Jan | 170 | $15.50 | $2,635 | 165 | $15.50 | $2,557.50 | 5 | $15.50 | $77.50 |
30-Jan | 380 | $15.00 | $5,700 | 0 | $15.00 | $0.00 | 380 | $15.00 | $5,700.00 |
Total | 790 | $12,295 | 380 | $6,105.00 | 410 | $6,190.00 |
Solution 2:
Computation of ending inventory COGS under Weighted Average Cost - Laker Company | ||||||||||||
Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
1-Jan | 240 | $16.50 | $3,960 | 0 | $0.00 | $0 | 0 | $0.00 | $0 | 240 | $16.50 | $3,960 |
10-Jan | 240 | $16.50 | $3,960 | 0 | $0.00 | $0 | 190 | $16.50 | $3,135 | 50 | $16.50 | $825 |
20-Jan | 50 | $16.50 | $825 | 170 | $15.50 | $2,635 | 0 | $0.00 | $0 | 220 | $15.73 | $3,460 |
25-Jan | 220 | $15.73 | $3,460 | 0 | $0.00 | $0 | 190 | $15.73 | $2,988 | 30 | $15.73 | $472 |
25-Mar | 30 | $15.73 | $472 | 380 | $15.00 | $5,700 | 0 | $0.00 | $0 | 410 | $15.05 | $6,172 |
Total | 380 | $6,123 | 410 | $6,172 |
Solution 3:
Computation of ending inventory COGS under FIFO - Laker Company | ||||||||||||
Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
1-Jan | 240 | $16.50 | $3,960.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 240 | $16.50 | $3,960.00 |
10-Jan | 240 | $16.50 | $3,960.00 | 0 | $0.00 | $0.00 | 190 | $16.50 | $3,135.00 | 50 | $16.50 | $825.00 |
20-Jan | 50 | $16.50 | $825.00 | 170 | $15.50 | $2,635.00 | 0 | $0.00 | $0.00 | 50 | $16.50 | $825.00 |
170 | $15.50 | $2,635.00 | ||||||||||
25-Jan | 50 | $16.50 | $825.00 | 0 | $0.00 | $0.00 | 50 | $16.50 | $825.00 | 30 | $15.50 | $465.00 |
170 | $15.50 | $2,635.00 | 140 | $15.50 | $2,170.00 | |||||||
30-Jan | 30 | $15.50 | $465.00 | 380 | $15.00 | $5,700.00 | 0 | $0.00 | $0.00 | 30 | $15.50 | $465.00 |
380 | $15.00 | $5,700.00 | ||||||||||
Total | 380 | $6,130.00 | 410 | $6,165.00 |
solution 4:
Computation of ending inventory COGS under LIFO - Laker Company | ||||||||||||
Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
1-Jan | 240 | $16.50 | $3,960.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 240 | $16.50 | $3,960.00 |
10-Jan | 240 | $16.50 | $3,960.00 | 0 | $0.00 | $0.00 | 190 | $16.50 | $3,135.00 | 50 | $16.50 | $825.00 |
20-Jan | 50 | $16.50 | $825.00 | 170 | $15.50 | $2,635.00 | 0 | $0.00 | $0.00 | 50 | $16.50 | $825.00 |
170 | $15.50 | $2,635.00 | ||||||||||
25-Jan | 50 | $16.50 | $825.00 | 0 | $0.00 | $0.00 | 170 | $15.50 | $2,635.00 | 30 | $16.50 | $495.00 |
170 | $15.50 | $2,635.00 | 20 | $16.50 | $330.00 | |||||||
30-Jan | 30 | $16.50 | $495.00 | 380 | $15.00 | $5,700.00 | 0 | $0.00 | $0.00 | 30 | $16.50 | $495.00 |
380 | $15.00 | $5,700.00 | ||||||||||
Total | 380 | $6,100.00 | 410 | $6,195.00 |
Required Information (The following information applies to the questions displayed below.) Laker Company reported the following...
[The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. Units Acquired at Cost 240 units @ $16.50 = $ 3,960 Units sold at Retail 190 units @ $25.50 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 170 units @ $15.50 = 2,635 190 units @ $25.50 $15.00 = 380 units @ 790 units 5,700 $12,...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 240 units @ $ 16.50 = $ 3,960 Jan. 10 Sales 190 units @ $ 25.50 Jan. 20 Purchase 170 units @ $ 15.50 = 2,635 Jan. 25 Sales 190 units @ $ 25.50 Jan. 30 Purchase 380 units @ $...
Required information [The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 240 units @ $ 16.50 = $ 3,960 Jan. 10 Sales 190 units @ $ 25.50 Jan. 20 Purchase 170 units @ $ 15.50 = 2,635 Jan. 25 Sales 190 units @ $ 25.50 Jan. 30 Purchase 380 units @ $...
Required information The following information applies to the questions displayed below) Laker Company reported the following January purchases and sales data for its only product. Date Activities Deginning Jenaventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals Units Acquired at Cost Units sold at Retail 240 units $16.50 $ 3.960 190 wita $25.50 170 units $15.50 - 2,635 190 units $25.50 380 units $15.00 - 5.700 790 units $12,295 380 wita Required: The Company uses...
Laker Company reported the following January purchases and sales data for its only product Units Required at Cost 240 unitat $16.50 - $3.960 Units sold at Retail Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Parehase Jan. 25 Sales Jan. 30 Purchase Totale 170 unital $15.50 - 2,635 190 units $25.50 190 units e $25.50 $15.00 - 380 units 790 units 5,700 $12,295 380 units The Company uses a perpetual Inventory system. For specific identification, ending Inventory...
Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 240 units @ $ 16.50 = $ 3,960 Jan. 10 Sales 190 units @ $ 25.50 Jan. 20 Purchase 170 units @ $ 15.50 = 2,635 Jan. 25 Sales 190 units @ $...
Required Information The following information applies to the questions displayed below) Laker Company reported the following January purchases and sales data for its only product. Date Units sold at Activities whits Aequired at copt Beginning 100 units $10.50 =$1,890 Jan. Inventory Jan. 10 Sales 140 units $19.50 Jan. 20 Purchase 110 units$ 9.50 - 1,045 Jan. 25 Sales 130 units $19.50 Jan. 30 Purchase 260 unitats 9.00 - 2,340 Totala 550 units $5,275 270 units The Company uses a perpetual...
Required information [The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Units Acquired at Cost 140 units @ $6.00 = $ 840 Units sold at Retail 100 units @ $ 15 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 60 units @ $5.00 = 300 80 units @ $ 15 180 units @ $4.50 =...
Required information [The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Units sold at Retail Units Acquired at Cost 200 unitse $12.50 - $2,500 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 130 units@ $11.50 - 1,495 160 units @ $21.50 140 units $21.50 Book 300 units@ $11.00 - 630 units 3,300 $7,295 300 units...
Required information (The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Activities Units Aequired at Cost Units sold at Retail Jan. 1 Beginning inventory 155 unitse $8.00 - $1,240 Jan. 10 Sales 115 units $17.00 Jan. 20 Purchase 90 units $7.00 - 630 Jan. 25 Sales 95 units # $17.00 Jan. 30 Purchase 210 unitse $6.50 - 1,365 Totals 455 units $3,235 210 units Date The...