Case 1)
1) calculate ending inventory and cost of goods sold under( FIFO METHOD)
Cost of goods sold
Date | particular | no of units | unit cost | amount($) |
Jan 1st | beginning inventory | 40 | $68 | 2720 |
May 5th | purchases | 270 | $71 | 19170 |
Nov 3rd | purchases | 180 | $76 | 13680 |
Cost of goods sold | 490 | 35570 |
2) calculate ending inventory(under FIFO METHOD)
Ending inventory = beginning INVENTORY + purchases- unit's sold
=40+(270+220)-490= 40
40 × $76= $3040
Ending inventory =. $3040
Case 2) calculation cost of goods sold and ending inventory (LIFO METHOD)
COST OF GOODS SOLD
Date | particular | unit's | unit cost | amount($) |
Jan 1 | Beginning | 15 | $81 | 1215 |
May 5 | Purchases | 245 | $84 | 20580 |
Nov 3 | Purchases | 190 | $89 | 16910 |
Cost of goods sold | 450 | 38705 |
Ending inventory(LIFO METHOD)
50+(245+190)-450 = 35UNITS
BECAUSE WE USING LIFO METHOD , ENDING INVENTORY WILL BE IN BEGINNING BALANCE (JAN1ST) THEREFORE,.
35UNITS ×$81 =$2835
Ending inventory = $2835
Case 3) calculation of cost of goods sold and ending inventory under specific identification method
Cost of goods sold
Date | particular | UNIT | unit cost | amount ($) |
Jan 1 | beginning inventory | 50 | $64 | 3200 |
May 5 | purchases | 275 | $67 | 18425 |
Nov 3 | purchases | 225 | $72 | 16200 |
Cost of goods sold | 550 | 37825 |
Ending inventory(under specific identification method)
Date | particular | UNIT | unit cost | amount ($) |
Jan 1 | beginning balance | 0 | - | - |
May5 | purchases | 15 | $67 | 1005 |
Nov 3 | purchases | 15 | $72 | 1080 |
Ending inventory | 30 | 2085 |
ALL THE BEST
PLEASE DO SUPPORT US
ANY DOUBT PLEASE COMMENT BELOW
THANK YOU
Brief Exercise 6-5 Calculate ending Inventory and cost of goods sold using FIFO (L06-3) During the...
During the year, Wright Company sells 370 remote-control airplanes for $120 each. The company has the following inventory purchase transactions for the year. Number of Units Unit Cost $74 40 Date Jan 1 May 5 Nov. 3 Transaction Beginning inventory Purchase Purchase Total Cost $ 2.960 16,170 13.120 210 160 82 410 $ 32,250 Calculate ending inventory and cost of goods sold for the year, assuming the company uses FIFO. FIFO Average Ending Cost of Goods Available for Sale Cost...
ainutes During the year, Wright Company sels 465 remote-control airplanes for $100 each. The company has the following inventory purchase transactions for the year. Unit Cost Date Jan 1 May 5 Nov. 3 Transaction Beginning inventory Purchase Purchase Number of Units 50 245 195 Total Cost $ 4,050 20.580 17,355 89 490 $ 41,985 Calculate ending inventory and cost of goods sold for the year, assuming the company uses FIFO, FIFO Cost of Goods Sold Cost of Goods Available for...
During the year, Wright Company sells 415 remote-control airplanes for $100 each. The company has the following inventory purchase transactions for the year. DateTransactionNumber of UnitsUnit CostTotal CostJan. 1Beginning inventory50$75$3,750May. 5Purchase2157816,770Nov. 3Purchase1658313,695430$34,215 Calculate ending inventory and cost of goods sold for the year, assuming the company uses FIFO.
During the year, Wright Company sells 380 remote-control airplanes for $100 each. The company has the following inventory purchase transactions for the year. Date Jan. 1 May. 5 Nov. 3 Transaction Beginning inventory Purchase Purchase Number of Unit Units Cost 50 $ 72 200 75 150 80 400 Total Cost $ 3,600 15,000 12,000 $30,600 Calculate ending inventory and cost of goods sold for the year, assuming the company uses FIFO. FIFO Ending Inventory Cost of Goods Available for Sale...
During the year, Wright Company sells 495 remote control airplanes for $100 each. The company has the following inventory purchase transactions for the year. Date Jan. 1 May 5 Nov. 3 Transaction Beginning inventory Purchase Purchase Number of Units 50 275 225 Unit Cost Total Cost $67 $ 3,350 70 19,250 75 16,875 550 $ 39,475 USA Calculate ending inventory and cost of goods sold for the year, assuming the company uses FIFO. FIFO Cost of Goods Sold Ending Inventory...
During the year, Wright Company sells 380 remote-control airplanes for $100 each. The company has the following inventory purchase transactions for the year. Date Jan. 1 May. 5 Nov. 3 Transaction Beginning inventory Purchase Purchase Number of Unit Units Cost 50 $72 200 75 BO 400 Total Cost $ 3,600 15,000 12.000 $30, 600 150 Calculate ending inventory and cost of goods sold for the year, assuming the company uses FIFO. FIFO Cost of Goods Available for Sale of units...
1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X FILE 5.a. HOME % Calibri INSERT PAGE LAYOUT Inventory costing methods - Excel FORMULAS DATA REVIEW ? x VIEW - 6 Sign In Paste B IU - -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard D66 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units...
During the year, Wright Company sells 515 remote-control airplanes for $110 each. The company has the following inventory purchase transactions for the year. DateTransactionNumber of UnitsUnit CostTotal CostJan. 1Beginning inventory60$63$3,780May. 5Purchase2956619,470Nov. 3Purchase2457117,395600$40,645 Calculate ending inventory and cost of goods sold for the year, assuming the company uses FIFO.
1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system. 2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system. 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system 5. Calculate January's ending inventory and cost of goods sold for...
FIFO: Required information Exercise 6-5A Calculate inventory amounts when costs are declining (LO6-3) [The following information applies to the questions displayed below.] During the year, Trombley Incorporated has the following inventory transactions. Number of Units Unit Cost $ 31 29 Date Transaction Jan. 1 Beginning inventory Mar. 4 Purchase Jun. 9 Purchase Nov. 11 Purchase 39 Total Cost $ 899 1,020 1,131 1,053 $4,103 For the entire year, the company sells 110 units of inventory for $39 each. Exercise 6-5A...