Solution a:
Cost of goods available for sale | |||
Particulars | Nos of units | Unit Cost | Cost of goods available for sale |
Beginning inventory | 330 | $22.00 | $7,260 |
Purchases: | |||
15-Mar | 880 | $25.00 | $22,000 |
20-Jul | 550 | $26.00 | $14,300 |
4-Sep | 770 | $28.00 | $21,560 |
2-Dec | 220 | $31.00 | $6,820 |
Total | 2750 | $71,940 |
Solution b2:
Computation of COGS and ending inventory - Periodic FIFO | |||||||||
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 | 330 | $22.00 | $7,260 | 330 | $22.00 | $7,260.00 | 0 | $22.00 | $0.00 |
Purchases: | |||||||||
15-Mar | 880 | $25.00 | $22,000 | 880 | $25.00 | $22,000.00 | 0 | $25.00 | $0.00 |
20-Jul | 550 | $26.00 | $14,300 | 550 | $26.00 | $14,300.00 | 0 | $26.00 | $0.00 |
4-Sep | 770 | $28.00 | $21,560 | 440 | $28.00 | $12,320.00 | 330 | $28.00 | $9,240.00 |
2-Dec | 220 | $31.00 | $6,820 | 0 | $31.00 | $0.00 | 220 | $31.00 | $6,820.00 |
Total | 2750 | $71,940 | 2200 | $55,880.00 | 550 | $16,060.00 |
Computation of COGS and ending inventory - Periodic LIFO | |||||||||
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 | 330 | $22.00 | $7,260 | 0 | $22.00 | $0.00 | 330 | $22.00 | $7,260.00 |
Purchases: | |||||||||
15-Mar | 880 | $25.00 | $22,000 | 660 | $25.00 | $16,500.00 | 220 | $25.00 | $5,500.00 |
20-Jul | 550 | $26.00 | $14,300 | 550 | $26.00 | $14,300.00 | 0 | $26.00 | $0.00 |
4-Sep | 770 | $28.00 | $21,560 | 770 | $28.00 | $21,560.00 | 0 | $28.00 | $0.00 |
2-Dec | 220 | $31.00 | $6,820 | 220 | $31.00 | $6,820.00 | 0 | $31.00 | $0.00 |
Total | 2750 | $71,940 | 2200 | $59,180.00 | 550 | $12,760.00 |
Computation of COGS and ending inventory - Periodic Weighted Average cost method | |||||||||
Particulars | Cost of goods available for sale | Cost of goods sold - Average cost | Ending Inventory - Average cost | ||||||
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 | 330 | $22.00 | $7,260 | ||||||
Purchases: | |||||||||
15-Mar | 880 | $25.00 | $22,000 | ||||||
20-Jul | 550 | $26.00 | $14,300 | ||||||
4-Sep | 770 | $28.00 | $21,560 | ||||||
2-Dec | 220 | $31.00 | $6,820 | ||||||
Total | 2750 | $26.16 | $71,940 | 2200 | $26.16 | $57,552 | 550 | $26.16 | $14,388 |
Kingbird, Inc. had a beginning inventory on January 1 of 330 units of Product 4-18-15 at a cost of $22 per unit. During the year, the following purchases were made. Mar. 15 880 units at $25 Sept. 4 7...
Kingbird, Inc. had a beginning inventory of 105 units of Product RST at a cost of $7 per unit. During the year, purchases were: Feb. 20 May 5 670 units at $8 505 units at $9 Aug, 12 Dec. 8 490 units at $10 105 units at $11 Kingbird uses a periodic inventory system. Sales totaled 1,500 units. Your answer is correct. Determine the cost of goods available for sale. The cost of goods available for sale $ 16695 Calculate...
Problem 6-03A a, b1-b2, с (Video) Swifty Company had a beginning inventory on January 1 of 200 units of Product 4-18-15 at a cost of $20 per unit. During the year, the following purchases were made. Mar. 15 July 20 430 units 220 units at at $22 $23 Sept. 4 Dec. 2 300 units 100 units at at $24 $29 1,040 units were sold. Swifty Company uses a periodic inventory system. Your answer is correct. Determine the cost of goods...
Problem 6-3A Sekhon Company had a beginning inventory on January 1 of 181 units of Product 4-18-15 at a cost of $20 per unit. During the year, the following purchases were made. Mar. 15 452 units at $23 Sept. 4 373 units at $25 uly 20 283 units at $24Dec. 2 113 units at $26 1,130 units were sold. Sekhon Company uses a periodic inventory system Your answer is correct. Determine the cost of goods available for sale. The cost...
Wildhorse Co. had a beginning inventory on January 1 of 308 units of Product 4-18-15 at a cost of $19 per unit. During the year, the following purchases were made. Mar. 15 July 20 uly 20 513 units 820 units 513 units at at $23 $22 $23 Sept. 4 Dec. 2 Sept, 4 718 units 718 units 205 units at at at $25 $25 $28 2,050 units were sold. Wildhorse Co. uses a periodic inventory system. Determine the cost of...
Sheffield Company had a beginning inventory on January 1 of 190
units of Product 4-18-15 at a cost of $20 per unit. During the
year, the following purchases were made.
Mar. 15
450 units
at
$23
Sept. 4
350 units
at
$25
July 20
230 units
at
$24
Dec. 2
100 units
at
$26
1,100 units were sold. Sheffield Company uses a periodic inventory
system.
(b1)
Calculate average cost per unit. (Round answer to 3
decimal places, e.g. 1.250.)
Average...
Problem 6-3A Sekhon Company had a beginning inventory on January 1 of 197 units of Product 4-18-15 at a cost of $22 per unit. During the year, the following purchases were made. Mar. 15 492 units at $24 Sept. 4 406 units at $29 July 20 308 units at 25 Dc. 2 123 units at $31 1,230 units were sold. Sekhon Company uses a periodic inventory system. Determine the cost of goods available for sale The cost of goods available...
Problem 6-3A Sekhon Company had a beginning inventory on January 1 of 197 units of Product 4-18-15 at a cost of $22 per unit. During the year, the following purchases were made. Mar. 15 492 units at $24 Sept. 4 406 units at $29 July 20 308 units at 25 Dc. 2 123 units at $31 1,230 units were sold. Sekhon Company uses a periodic inventory system. Determine the cost of goods available for sale The cost of goods available...
Problem 6-03A a, b1-b2, с (Video) Ziad Company had a beginning inventory on January 1 of 150 units of Product 4-18-15 at a cost of $20 per unit. During the year, the following purchases were made. Mar. 15 July 20 400 units 250 units at at $23 $24 Sept. 4 Dec. 2 350 units 100 units at at $26 $29 1,000 units were sold. Ziad Company uses a periodic inventory system. Determine the cost of goods available for sale. The...
Problem 6-03A Sunland Company had a beginning inventory of 130 units of Product RST at a cost of $8 per unit. During the year, purchases were: Feb. 20 May 5 670 600 units at units at $9 $10 Aug. 12 Dec. 8 470 130 units at units at $11 $12 dy Sunland uses a periodic inventory system. Sales totaled 1,570 units. Determine the cost of goods available for sale. The cost of goods available for sale Calculate Average Cost. (Round...
Splish Brothers Inc. had a beginning inventory of 135 units of Product RST at a cost of $7 per unit. During the year, purchases were: Feb.20 650 units at $8 May 5 500 units at $9 Aug, 12 420 units at $10 Dec.8 135 units at $11 Splish Brothers uses a periodic inventory system. Sales totaled 1,520 units. Determine the cost of goods available for sale. The cost of goods available for sale $ 16330 Calculate Average Cost. (Round answer...