E8.23 (LO3,5) (FIFO and LIFO—Periodic) Tom Brady Shop began operations on January 2, 2019. The following stock record card for footballs was taken from the records at the end of the year.
Date | Voucher | Terms | Units Received | Unit Invoice Cost | Gross Invoice Amount |
1/15 | 10624 | Net 30 | 50 | $20 | $1,000 |
3/15 | 11437 | 1/5, net 30 | 65 | 16 | 1,040 |
6/20 | 21332 | 1/10, net 30 | 90 | 15 | 1,350 |
9/12 | 27644 | 1/10, net 30 | 84 | 12 | 1,008 |
11/24 | 31269 | 1/10, net 30 | 76 | 11 | 836 |
Totals | 365 | $5,234 |
A physical inventory on December 31, 2019, reveals that 110 footballs were in stock. The bookkeeper informs you that all the discounts were taken. Assume that Tom Brady Shop uses the invoice price less discount for recording purchases.
Instructions
a. Compute the December 31, 2019, inventory using the FIFO method. (Round all unit costs to two decimal places.)
b. Compute the 2019 cost of goods sold using the LIFO method.
c. What method would you recommend to the owner to minimize income taxes in 2019, using the inventory information for footballs as a guide?
Solution:
1.) FIFO method
Date | Voucher | Terms | Units Received | Unit Invoice cost | Total cost | Balance |
15 Jan. | 10624 | Net 30 | 50 | $20 | $1,000 | $1,000 |
15 Mar. | 11437 | 1/5, net 30 | 65 | $16 | $1,040 | $2,040 |
20 June | 21332 | 1/10, net 30 | 90 | $15 | $1,350 | $3,390 |
12,Sep. | 27644 | 1/10, net 30 | 84 | $12 | $1008 | $4,398 |
24 Nov. | 31269 | 1/10, net 30 | 76 | $11 | $836 | $5,234 |
Sales | 50 | $20 | $1,000 | $4,234 | ||
Sales | 65 | $16 | $1,040 | $3,194 | ||
Sales | 90 | $15 | $900 | $2,294 | ||
Sales | 50 | $12 | $600 | $1,694 | ||
31 Dec. | Ending inventory | 110 | $1,694 | |||
Cost of goods sold = Beginning inventory + purchases - ending inventory
=0+$5,234 - $1,694 =$3,540
2.) LIFO method
LIFO | Cost of goods sold | Amount | |||||||
Date | Voucher | Terms | Units Received | Unit invoice cost | Total cost | Balance | Beginning inventory | 0 | |
15 Jan | 10624 | Net 30 | 50 | $20 | $1,000 | $1,000 | Add: Purchases | $5,234 | |
15 Mar. | 11437 | 1/5, net 30 | 65 | $16 | $1,040 | $2,040 | Less: ending inventory | $1960 | |
20 June | 21332 | 1/10, net 30 | 90 | $15 | $1,350 | $3,390 | Cost of goods sold | $3,274 | |
12 Sep | 27644 | 1/10 net 30 | 84 | $12 | $1,008 | $4,398 | |||
24, Nov. | 31269 | 1/10 net 30 | 76 | $11 | $836 | $5,234 | |||
Sales | 76 | $11 | $836 | $4,398 | |||||
Sales | 84 | $12 | $1,008 | $3,390 | |||||
Sales | 90 | $15 | $1,350 | $2,040 | |||||
Sales | 5 | $16 | $80 | $1,960 | |||||
Dec. 31 | Ending inventory | 110 | $1,960 |
3.)
We recommend for FIFO method to the owner to minimize income taxes in 2019. Because, the higher expenses you report, the lower your net income, and thus the lower income tax liability.
E8.23 (LO3,5) (FIFO and LIFO—Periodic) Tom Brady Shop began operations on January 2, 2019. The following...
CALCULATOR FULL SCREEN PRINTER VERSION Blossom Football Shop began operations on January 2, 2017. The following stock record card for footballs was taken from the records at the end of the year. BACK Date Voucher Units Received Unit Invoice Cost Gross Invoice Amount 1/15 3/15 6/20 9/12 11/24 Terms Net 30 1/5, net 30 1/10, net 30 1/10, net 30 1/10, net 30 10624 11437 21332 27644 31269 Totals 108 $1,972 1.909 2,376 1,734 102 1.504 $9.495 A physical inventory...
Whispering Sports began operations on January 2, 2020. The following stock record card for footballs was taken from the records at the end of the year Units Received Voucher Date 1/15 61 Unit Invoice Cost $26 21 20 16 Terms Net 30 1/5, net 30 1/10, net 30 1/10, net 30 1/10, net 30 10624 11437 21332 27644 31269 Totals 3/15 6/20 9/12 11/24 76 101 Gross Invoice Amount $1,586 1,596 2,020 1,520 1,218 $7.940 95 87 14 420 A...
how can I solve these two questions? Current Anemprin Progress Crane Sports began operations on January 2, 2020. The following stock record card for footballs was taken from the records at the end of the year. Units Received Unit Invoice Cost $22 Gross Invoice Amount $1,122 1,188 Date 1/15 3/15 6/20 9/12 11/24 Voucher 10624 11437 21332 27644 31269 Totals Terms Net 30 1/5, net 30 1/10, net 30 1/10, net 30 1/10, net 30 1,547 1,105 924 $5.886 77...
* Question 6 Bramble Limited stocks a variety of sports equipment for sale to institutions. The following stock record card for basketballs was taken from the records at the December 31, 2020 year end: Terms Units Received Unit Invoice Cost $20 Net 30 120 Invoice Date Number Jan. 1 balance 1510624 Mar. 15 11437 June 20 21332 Cross Invoice Amount $2,400 1,400 1,280 Net 30 1/5, net 30 1/10, net 110 1,650 Sept. 27644 1/10, net 1,200 30 Nov. 24...
Leven Company began operations on December 1, 2019. The following information is available for the company’s merchandise inventory. A physical inventory taken on March 31, 2020, showed 3,000 units available. Leven uses a periodic inventory system. Date Units Unit Cost January 1, 2020 (beginning inventory) 1,600 $9.00 Purchases: January 5, 2020 3,000 10.00 January 25, 2020 2,400 10.50 February 16, 2020 1,200 12.00 March 26, 2020 1,800 13.00 Required a. Compute ending inventory and cost of goods sold for the...
Blue Corporation began operations on December 1, 2019. The only inventory transaction in 2019 was the purchase of inventory on December 10, 2019, at a cost of $25 per unit. None of this inventory was sold in 2019. Relevant information is as follows. Ending inventory units December 31, 2019 122 December 31, 2020, by purchase date December 2, 2020 122 July 20, 2020 50 172 During the year 2020, the following purchases and sales were made. Purchases Sales March 15...
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 2: Cash $ 19,000 Beginning inventory 15,040 (160 units @ $94) Common stock 15,500 Retained earnings 18,540 The following five transactions occurred in Year 2: First purchase (cash) 115 units @ $96 Second purchase (cash) 200 units @ $104 Sales (all cash) 420 units @ $187 Paid $14,500 cash for salaries expenses. Paid cash for income tax at the rate of 40 percent of...
Cambi Company began operations on January 1, 2016. In the second quarter of 2017, it adopted the FIFO method of inventory valuation. In the past, it used the LIFO method. The company’s interim income statements as originally reported under the LIFO method follow: 2016 2017 1stQ 2ndQ 3rdQ 4thQ 1stQ Sales $ 12,000 $ 14,000 $ 16,000 $ 18,000 $ 20,000 Cost of goods sold (LIFO) 4,200 5,200 6,000 7,200 8,700 Operating expenses 2,200 2,400 2,800 3,200 3,400 Income before...
Company began operations several years ago and has used the average-cost method of inventory valuation since its inception. In 2019, it decides to switch to the FIFO method. You are provided with the following information. Net income under avg cost Excess of average cost over fifo cost goods sold pretax Net income FIFO basis Years prior 2017 $370,000 $72,000 2017 $340,000 60,000 2018 $320,000 44,000 2019 $380,000 Instructions: 1. Prepare the journal entry to record the change from the Average...
The accounting records of Wall's China Shop reflected the following balances as of January 1, Year 3 $19,900 19,530 (210 0 593) 15, 400 24,030 Cash Beginning inventory Common stock Retained earnings The following five transactions occurred in Year 3: 1. First purchase (cash): 115 units o $95 2. Second purchase (cash): 195 units o $103 3. Sales (all cash): 355 units o $190 4. Paid $14,600 cash for salaries expense 5. Paid cash for income tax at the rate...