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. |
Transactions | Units | Unit Cost | ||||
a. Inventory, Beginning | 1,500 | $ | 30 | |||
For the year: | ||||||
b. Purchase, March 5 | 7,500 | 31 | ||||
c. Purchase, September 19 | 3,500 | 33 | ||||
d. Sale, April 15 (sold for $75 per unit) | 2,400 | |||||
e. Sale, October 31 (sold for $78 per unit) | 6,500 | |||||
f. Operating expenses (excluding income tax expense), $406,000 | ||||||
Required: |
1. | Calculate the number and cost of goods available for sale. |
2. | Calculate the number of units in ending inventory. |
3. |
Compute the cost of ending inventory and cost of goods sold under (a) FIFO, (b) LIFO, and (c) weighted average cost. |
4. |
Prepare an income statement that shows the FIFO method, LIFO method and weighted average method. |
1) Calculate the number and cost of goods available for sale
Units | Unit Cost | Total Cost | |
Beginning inventory | 1500 | 30 | 45000 |
Purchase 1 | 7500 | 31 | 232500 |
Purchase 2 | 3500 | 33 | 115500 |
Total | 12500 | 393000 |
Number of goods available for sale = 12500
Cost of goods available for sale = 393000
2) Ending inventory = 12500-8900 = 3600 Units
3) Calculate ending inventory and cost of goods sold
FIFO | LIFO | Weighted average | |
ending inventory | (3500*33+100*31) = 118600 | (1500*30+2100*31) = 110100 | 393000/12500*3600 = 113184 |
Cost of goods sold | 393000-118600 = 274400 | 393000-110100 = 282900 | 393000-113184 = 279816 |
4) Income statement
FIFO | LIFO | Weighted average | |
Sales | 687000 | 687000 | 687000 |
Cost of goods sold | 274400 | 282900 | 279816 |
Gross profit | 412600 | 40410 | 407184 |
Operating expense | 406000 | 406000 | 406000 |
Income from operation | 6600 | -1900 | 1184 |
Scoresby Inc. tracks the number of units purchased and sold throughout each year but applies its...
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...
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)...
Only Question 4. Check my work 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. eBook Units 3,000 Unit Cost $ 8 Hint Print Transactions a. Inventory, Beginning For the year: b. Purchase, March 5 c. Purchase, September...
Please type your answer, not hand writing. 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. Unit Units 3,000 Cost $ 8 Transactions a. Inventory, Beginning For the year: b. Purchase, March 5 C. Purchase, September 19 d....
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 300 $ 10 For the year: b. Purchase, April 11 700 8 c. Purchase, June 1 600 11 d. Sale, May...
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 300 $ 10 For the year: b. Purchase, April 11 700 8 c. Purchase, June 1 600 11 d. Sale, May...
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...
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 Unit Units Cost 200 $12 points 10 Transactions a. Inventory, Beginning For the year: b. Purchase, April 11 c. Purchase, June 1 d. Sale, May 1 (sold for...
value: 20.00 points 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. Transactions Units Unit Cost 4,000 $18 a. Inventory, Beginning For the vear b. Purchase, March 5 c. Purchase, September 19 d. Sale, April 15 (sold for...