Question

In: Accounting

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.

Transactions/ Units/ Unit Cost

a. Inventory, Beginning /3,000/ $ 8

For the year:

b. Purchase, March 5/ 9,500/ 9

c. Purchase, September 19/ 5,000/ 11

d. Sale, April 15 (sold for $29 per unit) /4,000

e. Sale, October 31 (sold for $31 per unit)/ 8,000

f. Operating expenses (excluding income tax expense),/ $250,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. 6. Which inventory costing method minimizes income taxes?

Solutions

Expert Solution

Opening Stock & Purchases
Unit Unit Cost Total Cost Sales Units Sales Price per unit Total Sales Price
Beginning Inventory 3000 $                         8.00 $                   24,000.00
05-Mar 9500 $                         9.00 $                   85,500.00
15-Apr 4000 29 116000
19-Sep 5000 $                      11.00 $                   55,000.00
31-Oct 8000 31 248000
17500 $               1,64,500.00 12000 364000
Inventory 5500
FIFO Ending Inventory
(a) Units Rate Total cost
19-Sep 5000 $                      11.00 $                   55,000.00
05-Mar 500 $                         9.00 $                     4,500.00
Total 5500 $                   59,500.00
FIFO -Cost of goods sold
Cost of goods available for sales $                        1,64,500.00
Less: Ending Inventory $                          -59,500.00
Cost of goods sold $                        1,05,000.00
(b) LIFO Ending Inventory
Units Rate Total cost
Beginning Inventory 3000 $                         8.00 $                   24,000.00
11-Jun 2500 $                         9.00 $                   22,500.00
5500 $                   46,500.00
LIFO-Cost of goods sold
Cost of goods available for sales $                        1,64,500.00
Less: Ending Inventory $                          -46,500.00
Cost of goods sold $                        1,18,000.00
(C ) Unit Price= Total cost/Total Units
Unit Price= ($164500/17500)
Unit Price= $                                      9.40
Weighted Average Inventory
Ending Inventory(Units)=(A) 5500
Price per unit=(B) $                                      9.40
Ending Inventory Price=(A)*(B) $                           51,700.00
Cost of goods available for sales $                        1,64,500.00
Less: Ending Inventory $                           51,700.00
Cost of goods sold $                        1,12,800.00
Cost of Ending Inventory Cost of goods sold
FIFO $                           59,500.00 $          1,05,000.00

Related Solutions

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.    Transactions Units Unit Cost a. Inventory, Beginning 1,500 $ 24 For the year: b. Purchase, March 5 7,500 25 c. Purchase, September 19 3,500 27 d. Sale, April...
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.    Transactions Units Unit Cost a. Inventory, Beginning 4,000 $ 20 For the year: b. Purchase, March 5 10,000 21 c. Purchase, September 19 6,000 23 d. Sale, April...
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.    Transactions Units Unit Cost a. Inventory, Beginning 4,000 $ 14 For the year: b. Purchase, March 5 10,000 15 c. Purchase, September 19 6,000 17 d. Sale, April...
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. 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...
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. Transactions Units Unit Cost   a. Inventory, Beginning 3,000 $13   For the year:   b. Purchase, April 11 9,100 11   c. Purchase, June 1 8,100 14   d. Sale, May 1 (sold...
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.    Transactions Units Unit Cost a. Inventory, Beginning 4,000 $ 22 For the year: b. Purchase, March 5 10,000 23 c. Purchase, September 19 6,000 25 d. Sale, April...
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. 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...
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.    Transactions Units Unit Cost a. Inventory, Beginning 1,500 $ 26 For the year: b. Purchase, March 5 7,500 27 c. Purchase, September 19 3,500 29 d. Sale, April...
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.    Transactions Units Unit Cost a. Inventory, Beginning 3,000 $ 8 For the year: b. Purchase, March 5 9,500 9 c. Purchase, September 19 5,000 11 d. Sale, April...
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.    Transactions Units Unit Cost a. Inventory, Beginning 1,500 $ 28 For the year: b. Purchase, March 5 7,500 29 c. Purchase, September 19 3,500 31 d. Sale, April...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT