1.
Sp. ID | Cost of goods available for sale | Cost of Goods Sold | Ending Balance | |||||||
Date | Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Jan-01 | Beginning Inventory | 240 | $ 16.50 | $ 3,960.00 | 240 | $ 16.50 | $ 3,960.00 | |||
Jan-10 | Sales | 190 | $ 16.50 | $ 3,135.00 | 50 | $ 16.50 | $ 825.00 | |||
Jan-20 | Purchase | 170 | $ 15.50 | $ 2,635.00 | 50 | $ 16.50 | $ 825.00 | |||
170 | $ 15.50 | $ 2,635.00 | ||||||||
Jan-25 | Sales | 25 | $ 16.50 | $ 412.50 | 25 | $ 16.50 | $ 412.50 | |||
165 | $ 15.50 | $ 2,557.50 | 5 | $ 15.50 | $ 77.50 | |||||
Jan-30 | Purchase | 380 | $ 15.00 | $ 5,700.00 | 25 | $ 16.50 | $ 412.50 | |||
5 | $ 15.50 | $ 77.50 | ||||||||
380 | $ 15.00 | $ 5,700.00 | ||||||||
Total | 790 | $ 12,295.00 | 380 | $6,105.00 | 410 | $ 6,190.00 |
2
W.Avg | Cost of goods available for sale | Cost of Goods Sold | Ending Balance | |||||||
Date | Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Jan-01 | Beginning Inventory | 240 | $ 16.50 | $ 3,960.00 | 240 | $ 16.50 | $ 3,960 | |||
Jan-10 | Sales | 190 | $ 16.50 | $ 3,135 | 50 | $ 16.50 | $ 825 | |||
Jan-20 | Purchase | 170 | $ 15.50 | $ 2,635.00 | 50 | $ 16.50 | $ 825 | |||
170 | $ 15.50 | $ 2,635 | ||||||||
220 | $ 15.73 | $ 3,460 | ||||||||
Jan-25 | Sales | 190 | $ 15.73 | $ 2,988 | 30 | $ 15.73 | $ 472 | |||
Jan-30 | Purchase | 380 | $ 15.00 | $ 5,700.00 | 30 | $ 15.73 | $ 472 | |||
380 | $ 15.00 | $ 5,700 | ||||||||
Total | 790 | $ 12,295.00 | 380 | $ 6,123 | 410 | $ 15.05 | $ 6,172 |
3
FIFO | Cost of goods available for sale | Cost of Goods Sold | Ending Balance | |||||||
Date | Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Jan-01 | Beginning Inventory | 240 | $ 16.50 | $ 3,960.00 | 240 | $ 16.50 | $ 3,960.00 | |||
Jan-10 | Sales | 190 | $ 16.50 | $ 3,135.00 | 50 | $ 16.50 | $ 825.00 | |||
Jan-20 | Purchase | 170 | $ 15.50 | $ 2,635.00 | 50 | $ 16.50 | $ 825.00 | |||
170 | $ 15.50 | $ 2,635.00 | ||||||||
Jan-25 | Sales | 50 | $ 16.50 | $ 825.00 | ||||||
140 | $ 15.50 | $ 2,170.00 | 30 | $ 15.50 | $ 465.00 | |||||
Jan-30 | Purchase | 380 | $ 15.00 | $ 5,700.00 | 30 | $ 15.50 | $ 465.00 | |||
380 | $ 15.00 | $ 5,700.00 | ||||||||
Total | 790 | $ 12,295.00 | 380 | $6,130.00 | 410 | $ 6,165.00 |
.
4
LIFO | Cost of goods available for sale | Cost of Goods Sold | Ending Balance | |||||||
Date | Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
Jan-01 | Beginning Inventory | 240 | $ 16.50 | $ 3,960.00 | 240 | $ 16.50 | $ 3,960.00 | |||
Jan-10 | Sales | 190 | $ 16.50 | $ 3,135.00 | 50 | $ 16.50 | $ 825.00 | |||
Jan-20 | Purchase | 170 | $ 15.50 | $ 2,635.00 | 50 | $ 16.50 | $ 825.00 | |||
170 | $ 15.50 | $ 2,635.00 | ||||||||
Jan-25 | Sales | 170 | $ 15.50 | $ 2,635.00 | 30 | $ 16.50 | $ 495.00 | |||
20 | $ 16.50 | $ 330.00 | ||||||||
Jan-30 | Purchase | 380 | $ 15.00 | $ 5,700.00 | 30 | $ 16.50 | $ 495.00 | |||
380 | $ 15.00 | $ 5,700.00 | ||||||||
Total | 790 | $ 12,295.00 | 380 | $6,100.00 | 410 | $ 6,195.00 |
Laker Company reported the following January purchases and sales data for its only product Units Required...
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...
[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. Unita boquired at cost 200 units $16.50 - $ 3.960 Units sold at Retail 190 unite $25.50 Activities Jan. 1 Seginning Inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totale 170 units $15.50 - 2,635 190 units $25.50 $15.00 - 380 units 790 units 5,700 $12,295 300 units The Company...
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 190 units @ $ 7.00 = $ 1,330 Jan. 10 Sales 150 units @ $ 16.00 Jan. 20 Purchase 110 units @ $ 6.00 = 660 Jan. 25 Sales 130 units @ $ 16.00 Jan. 30 Purchase 280 units @ $ 5.50 = 1,540 Totals 580 units $ 3,530 280 units The...
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 sakes 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. old at Retail Units Acquired at Cost 165 units@ $9.00 - $1,485 125 units $18.00 - Activities Jan 1 Beginning inventory Jan 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 110 units $8.00 125 units $18.00 $2.50...
Laker Company reported the following January purchases and sales data for its only product. Units sold at Retail Units Acquired at Cost 165 units@ $9.00 = $1,485 125 units @ $18.00 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 110 units@ $8.00 = 880 125 units @ $18.00 230 units@ $7.50 = 505 units 1,725 $4,090 250 units The Company uses a perpetual inventory system. For specific identification, ending...
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...