the number that is covered is
$12.50
Solution:
Total units sold = 19000
Ending inventory = Units available for sale - Units sold = 54000 - 19000 = 35000
Solution 1:
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 | 11000 | $12.50 | $137,500 | 0 | $12.50 | $0.00 | 11000 | $12.50 | $137,500.00 |
Purchases: | |||||||||
2-Mar | 13000 | $13.70 | $178,100 | 0 | $13.70 | $0.00 | 13000 | $13.70 | $178,100.00 |
15-Jul | 20000 | $14.80 | $296,000 | 9000 | $14.80 | $133,200.00 | 11000 | $14.80 | $162,800.00 |
30-Nov | 10000 | $15.35 | $153,500 | 10000 | $15.35 | $153,500.00 | 0 | $15.35 | $0.00 |
Total | 54000 | $765,100 | 19000 | $286,700.00 | 35000 | $478,400.00 |
Solution 2:
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 | 11000 | $12.50 | $137,500 | 0 | $12.50 | $0.00 | 11000 | $12.50 | $137,500.00 |
Purchases: | |||||||||
2-Mar | 13000 | $13.70 | $178,100 | 0 | $13.70 | $0.00 | 13000 | $13.70 | $178,100.00 |
15-Jul | 20000 | $14.80 | $296,000 | 9000 | $14.80 | $133,200.00 | 11000 | $14.80 | $162,800.00 |
30-Nov | 10000 | $15.35 | $153,500 | 10000 | $15.35 | $153,500.00 | 0 | $15.35 | $0.00 |
Total | 54000 | $765,100 | 19000 | $286,700.00 | 35000 | $478,400.00 |
Solution 3:
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 | 11000 | $12.50 | $137,500 | ||||||
Purchases: | |||||||||
2-Mar | 13000 | $13.70 | $178,100 | ||||||
15-Jul | 20000 | $14.80 | $296,000 | ||||||
30-Nov | 10000 | $15.35 | $153,500 | ||||||
Total | 54000 | $14.1685 | $765,100 | 19000 | $14.1685 | $269,202 | 35000 | $14.1685 | $495,898 |
the number that is covered is $12.50 Part 2: During 2018, Kaplan Co. sold 19,000 units...
Orion Iron Corp. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31. Transactions Units Unit Cost a. Inventory, Beginning 400 $ 15 For the year: b. Purchase, April 11 850 14 c. Purchase, June 1 750 18 d. Sale, May...
Scoresby Inc. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31. Units 1,500 Unit Cost $30 31 Transactions a. Inventory, Beginning For the year: b. Purchase, March 5 c. Purchase, September 19 d. Sale, April 15 (sold for $75 per...
Scoresby Inc. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31. Units 4,000 Unit Cost $12 13 Transactions a. Inventory, Beginning For the year: b. Purchase, March 5 c. Purchase, September 19 d. Sale, April 15 (sold for $57 per...
During 2018, a company sells 350 units of inventory for $90 each. The company has the following inventory purchase transactions for 2018 Number of Units Date Transaction Beginning Unit Cost $ 61 62 Jan. 1 inventory 70 Total Cost $ 4270 10,230 12,032 May 5 Purchase Nov. 3 Purchase 165 188 64 423 $26,532 Calculate ending inventory and cost of goods sold for 2018 assuming the company uses FIFO with a periodic inventory system. Ending inventory Cost of goods sold
During 2018, a company sells 330 units of inventory for $88 each. The company has the following inventory purchase transactions for 2018: Date Transaction Number of Units 65 Unit Cost $64 Jan. 1. Beginning inventory May 5 Purchase Nov. 3 Purchase Total Cost $ 4,160 10,985 12,730 65 169 190 67 424 $27,875 Calculate ending inventory and cost of goods sold for 2018 assuming the company uses FIFO with a periodic inventory system. Ending inventory Cost of goods sold
Scoresby Inc. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year, as if it uses a periodic inventory system. Assume its accounting records provided the following information at the end of the annual accounting period, December 31. Units 4,000 Unit Cost $22 Transactions a. Inventory, Beginning For the year: b. Purchase, March 5 c. Purchase, September 19 d. Sale, April 15 (sold for $67 per unit)...
Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totalled 240 units. Unit Cost $ 8 Beginning Inventory Purchase Purchase Date January 1 January 15 January 24 Units 120 380 200 Total Cost $ 960 3,420 2,200 11 Required: 1. Calculate the...
During the year, Trombley Incorporated has the following inventory transactions. Number of Units 27 Date Transaction Jan. 1 Beginning inventory Mar. 4 Purchase Jun. 9 Purchase Nov.11 Purchase Unit Cost $ 29 28 27 32 37 Total Cost $ 783 896 999 925 $3,603 37 25 133 For the entire year, the company sells 100 units of inventory for $37 each. 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. FIFO Cost of Goods...
Ferris Company began 2018 with 5,000 units of its principal
product. The cost of each unit is $9. Merchandise transactions for
the month of January 2018 are as follows:
Purchases
Date of Purchase
Units
Unit Cost*
Total Cost
Jan. 10
6,000
$
10
$
60,000
Jan. 18
5,000
11
55,000
Totals
11,000
115,000
*Includes purchase price and cost of freight.
Sales
Date of Sale
Units
Jan. 5
3,000
Jan. 12
3,000
Jan. 20
4,000
Total
10,000
6,000 units were on...
During 2018, Noval Company sells 252 units of inventory for $100 each. The company has the following inventory purchase transactions for 2018 Date Jan. 1 Beginning inventory Apr. 7 Purchase Oct. 9 Purchase Transaction Number of Units Unit Cost Total Cost $74$4,514 13,756 6,318 61 181 81 76 78 323 $ 24,588 value 1.00 points Required 1. Calculate ending inventory, cost of goods sold, and gross profit for 2018, assuming the company uses LIFO with a periodic inventory system LIFO...