FIFO | LIFO | Average Cost | |||||||
The ending Inventory | $ 6,913 | $ 5,713 | $ 6,416 | ||||||
The cost of goods sold | $ 26,158 | $ 27,358 | $ 26,655 | ||||||
(1) FIFO results in highest inventory amount, $6,913 | |||||||||
(2) LIFO results in highest cost of goods sold, $27,358 | |||||||||
Workings: | |||||||||
Cost of goods available for sale | Cost of goods sold - Periodic FIFO | Ending Inventory - Periodic FIFO | |||||||
FIFO | # of units (A) | Cost per unit | Cost of goods available for sale | # of units sold (B) | Cost per unit | Cost of goods sold | # of units in ending inventory (A) - (B) | Cost per unit | Ending Inventory |
Purchases: | |||||||||
Jan-01 | 181 | $ 20.00 | $ 3,620 | 181 | $ 20.00 | $ 3,620 | - | $ 20.00 | $ - |
Mar-15 | 452 | $ 23.00 | $ 10,396 | 452 | $ 23.00 | $ 10,396 | - | $ 23.00 | $ - |
Jul-20 | 283 | $ 24.00 | $ 6,792 | 283 | $ 24.00 | $ 6,792 | - | $ 24.00 | $ - |
Sep-04 | 373 | $ 25.00 | $ 9,325 | 214 | $ 25.00 | $ 5,350 | 159 | $ 25.00 | $ 3,975 |
Dec-02 | 113 | $ 26.00 | $ 2,938 | 0 | $ 26.00 | $ - | 113 | $ 26.00 | $ 2,938 |
1,402 | $ 33,071 | 1,130 | $ 26,158 | 272 | $ 6,913 | ||||
Cost of goods available for sale | Cost of goods sold - Periodic FIFO | Ending Inventory - Periodic FIFO | |||||||
FIFO | # of units (A) | Cost per unit | Cost of goods available for sale | # of units sold (B) | Cost per unit | Cost of goods sold | # of units in ending inventory (A) - (B) | Cost per unit | Ending Inventory |
Purchases: | |||||||||
Jan-01 | 181 | $ 20.00 | $ 3,620 | 0 | $ 20.00 | $ - | 181 | $ 20.00 | $ 3,620 |
Mar-15 | 452 | $ 23.00 | $ 10,396 | 361 | $ 23.00 | $ 8,303 | 91 | $ 23.00 | $ 2,093 |
Jul-20 | 283 | $ 24.00 | $ 6,792 | 283 | $ 24.00 | $ 6,792 | - | $ 24.00 | $ - |
Sep-04 | 373 | $ 25.00 | $ 9,325 | 373 | $ 25.00 | $ 9,325 | - | $ 25.00 | $ - |
Dec-02 | 113 | $ 26.00 | $ 2,938 | 113 | $ 26.00 | $ 2,938 | - | $ 26.00 | $ - |
1,402 | $ 33,071 | 1,130 | $ 27,358 | 272 | $ 5,713 | ||||
Cost of goods available for sale | Cost of goods sold - Periodic FIFO | Ending Inventory - Periodic FIFO | |||||||
FIFO | # of units (A) | Cost per unit | Cost of goods available for sale | # of units sold (B) | Cost per unit | Cost of goods sold | # of units in ending inventory (A) - (B) | Cost per unit | Ending Inventory |
Purchases: | |||||||||
Jan-01 | 181 | $ 20.00 | $ 3,620 | ||||||
Mar-15 | 452 | $ 23.00 | $ 10,396 | ||||||
Jul-20 | 283 | $ 24.00 | $ 6,792 | ||||||
Sep-04 | 373 | $ 25.00 | $ 9,325 | ||||||
Dec-02 | 113 | $ 26.00 | $ 2,938 | ||||||
1,402 | $ 33,071 | 1,130 | $ 23.588 | $ 26,655 | 272 | $ 23.588 | $ 6,416 | ||
*Average Cost | = | Cost of goods available for sale / No. Of units | |||||||
= | $33,071/1,402 units | ||||||||
= | $23.588 |
Problem 6-3A Sekhon Company had a beginning inventory on January 1 of 181 units of Product...
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) 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...
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...
Problem 6-03A Sheffield Corp. had a beginning inventory of 115 units of Product RST at a cost of $9 per unit. During the year, purchases were: Feb. 20 May 5 660 559 units at units at $10 $11 Aug. 12 Dec. 8 401 115 units at units at $12 $13 Sheffield uses a periodic inventory system. Sales totaled 1,500 units. x Your answer is incorrect. Try again. Determine the cost of goods available for sale. The cost of goods available...
CALCULATOR FULL SCREEN P. Problem 6-03A Sheffield Corp. had a beginning inventory of 115 units of Product RST at a cost of $9 per unit. During the year, purchases were: Feb. 20 660 units at $10 Aug. 12401 units at $12 May 5 559 units at $11 Dec. 8 115 units at $13 Sheffield uses a periodic inventory system. Sales totaled 1,506 units. Your answer is partially correct. Try again. Determine the cost of goods available for sale. The cost...
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...
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...
Monty Corp. had a beginning inventory of 95 units of Product RST at a cost of $8 per unit. During the year, purchases were: Feb. 20 578 units at $9 May 5 510 units at $10 Monty Corp. uses a periodic inventory system. Sales totaled 1,520 units Aug. 12 377 units at $11 Dec. 8 99 units at $12 ▼ (a) Your answer is correct. (a) Determine the cost of goods available for sale The cost of goods available for...
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...