1. 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 410 units, where 380 are from the January 30 purchase, 5 are from the January 20 purchase, and 25 are from beginning inventory.
- Complete comparative income statements for the month of January for Laker Company for the four inventory methods. Assume expenses are $2,250, and that the applicable income tax rate is 40%. (Round your Intermediate calculations to 2 decimal places.)
Solution 1:
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 |
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 |
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 |
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 |
Income Statement - Laker Company | ||||
Particulars | Specific identification | Weighted Average | FIFO | LIFO |
Sales | $9,690 | $9,690 | $9,690 | $9,690 |
Cost of goods sold | $6,105 | $6,123 | $6,130 | $6,100 |
Gross Profit (Sales - COGS) | $3,585 | $3,567 | $3,560 | $3,590 |
Expenses | $2,250 | $2,250 | $2,250 | $2,250 |
Income before taxes | $1,335 | $1,317 | $1,310 | $1,340 |
Income tax expense (40%) | $534 | $527 | $524 | $536 |
Net Income | $801 | $790 | $786 | $804 |
1. Laker Company reported the following January purchases and sales data for its only product. -The...
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 @ $ 15.00 = 5,700 Totals 790 units $ 12,295 380 units The...
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...
laker company reported the following January purchases and sales data for its only product 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 160 units @ $8.50 = $1,360 Units sold at Retail 120 units $17.50 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 100 units @ $7.50 =...
Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Exercise 6-3 Perpetual: Inventory costing methods P1 Units Sold at Retail 140 units @ $6.00 = $ 840 100 units @ $15 Jan. 1 Jan. 10 Jan. 20 Jan. 25 Jan. 30 Beginning inventory ... Sales... Purchase .. Sales..... Purchase .. Totals 60 units @ $5.00 = 300 80 units @ $15 180 units @ $4.50 = 810 380 units...
Laker Company reported the following January purchases and sales data for its only product. Units Acquired at Cost 145 unitse $7.00 - $1,015 Units sold at Retail Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 70 unitse $6.00 - 105 units e $16.00 420 $5.50 - 85 units 190 units 405 units $16.00 1.045 $2.480 190 units The Company uses a perpetual inventory system. For specific identification, ending Inventory...
Laker Company reported the following January purchases and sales data for its only product Date Activities Units Sold at Retail Units Acquired at Cost 180 units 56.40 = $ 1,152 Jan. 1 Beginning 120 units @ $15.80 inventory Jan. 10 Sales Jan.20 Purchase Jan. 25 Sales 100 units 20 = 540 100 units @ $15.80 Jan. 30 Purchase 220 unitsga.90 1,078 Totals 500 units $2,770 220 units The Company uses a periodic inventory system. For specific identification, ending inventory consists...
Complete the Income Statement for Laker Company Laker Company reported the following January purchases and sales data for its only product. Units sold at Retail Units Acquired at Cost 190 units@ $7.00 - $1,330 150 units @ $16.00 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase 110 units@ $6.00 = 660 130 units @ $16.00 280 units@ $5.50 - 580 units 1,540 $3,530 Totals 280 units The Company uses a...
Laker Company reported the following January purchases and sales data for its only product. Units sold at Retail Units Acquired at Cost 145 units @ $ 7.00 = $ 1,015 105 units @ $16.00 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 70 units @ $6.00 = 420 85 units @ $16.00 @ $5.50 = 190 units 405 units 1,045 $2,480 190 units The Company uses a perpetual inventory...
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 200 units @ $ 12.50 = $ 2,500 Jan. 10 Sales 160 units @ $ 21.50 Jan. 20 Purchase 130 units @ $ 11.50 = 1,495 Jan. 25 Sales 140 units @ $ 21.50 Jan. 30 Purchase 300 units @ $ 11.00 = 3,300 Totals 630 units $ 7,295 300 units The...
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 150 units @ $ 7.50 = $ 1,125 Jan. 10 Sales 110 units @ $ 16.50 Jan. 20 Purchase 80 units @ $ 6.50 = 520 Jan. 25 Sales 90 units @ $ 16.50 Jan. 30 Purchase 200 units @ $ 6.00 = 1,200 Totals 430 units $ 2,845 200 units The...