In: Accounting
Scrappers Supplies tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period, 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 | |||||||
Beginning inventory, January 1 | 200 | $ | 38 | ||||||
Transactions during the year: | |||||||||
a. | Purchase on account, March 2 | 350 | 40 | ||||||
b. | Cash sale, April 1 ($54 each) | (350 | ) | ||||||
c. | Purchase on account, June 30 | 250 | 44 | ||||||
d. | Cash sale, August 1 ($54 each) | (70 | ) | ||||||
TIP: Although the purchases and sales are listed in chronological order, Scrappers determines the cost of goods sold after all of the purchases have occurred. |
Required: | |
1. |
Compute the cost of goods available for sale, cost of ending inventory, and cost of goods sold at December 31 under each of the following inventory costing methods: (Round "Cost per Unit" to 2 decimal places.) |
a. | Last-in, first-out. |
b. | Weighted average cost. |
c. | First-in, first-out. |
d. |
Specific identification, assuming that the April 1 sale was selected one-fifth from the beginning inventory and four-fifths from the purchase of March 2. Assume that the sale of August 1 was selected from the purchase of June 30. |
2-a. |
Of the four methods, which will result in the highest gross profit? |
||||||||
|
2-b. |
Of the four methods, which will result in the lowest income taxes? |
||||||||
|
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||||||
Part 1 | |||||||||
LIFO | Weighted Average | FIFO | Specific Ident | ||||||
Beginning Inventory | 200*$38 | $ 7,600 | 200*$38 | $ 7,600 | 200*$38 | $ 7,600 | 200*$38 | $ 7,600 | |
Add: Purchase | |||||||||
350*$40 | $ 14,000 | 350*$40 | $ 14,000 | 350*$40 | $ 14,000 | 350*$40 | $ 14,000 | ||
250*$44 | $ 11,000 | 250*$44 | $ 11,000 | 250*$44 | $ 11,000 | 250*$44 | $ 11,000 | ||
Cost of Goods Available for Sale | $ 32,600 | $ 32,600 | $ 32,600 | $ 32,600 | |||||
Average Rate (Weighted Average) | $32,600/800 Units) | ||||||||
$ 40.75 | |||||||||
Cost of Goods Sold: | |||||||||
250*$44 | $ 11,000 | 420*$40.75 | $ 17,115 | 200*$38 | $ 7,600 | (70*$38)+(280*$40) | $ 13,860 | ||
170*$40 | $ 6,800 | 220*$40 | $ 8,800 | 70*$44 | $ 3,080 | ||||
Total Cost of Goods Sold | $ 17,800 | $ 17,115 | $ 16,400 | $ 16,940 | |||||
Ending Inventory | |||||||||
200*$38 | $ 7,600 | 380*$40.75 | $ 15,485 | 130*$40 | $ 5,200 | 130*$38 | $ 4,940 | ||
180*$40 | $ 7,200 | 250*$44 | $ 11,000 | 70*$40 | $ 2,800 | ||||
180*$44 | $ 7,920 | ||||||||
Ending Inventory | $ 14,800 | $ 15,485 | $ 16,200 | $ 15,660 | |||||
Part 2a | |||||||||
First-in, First out | |||||||||
(Since COGS is lowest in this case) | |||||||||
Part 2b | |||||||||
Last-in, First out | |||||||||
(Since COGS is highest in this case, and hence lower profit and lower tax) | |||||||||