Question

In: Accounting

Exercise 8-17 Novak Sports began operations on January 2, 2020. The following stock record card for...

Exercise 8-17

Novak 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.

Date

Voucher

Terms

Units
Received

Unit Invoice
Cost

Gross Invoice
Amount

1/15 10624 Net 30 75 $32 $2,400
3/15 11437 1/5, net 30 90 25 2,250
6/20 21332 1/10, net 30 115 24 2,760
9/12 27644 1/10, net 30 109 19 2,071
11/24 31269 1/10, net 30 101 17 1,717
Totals 490 $11,198

A physical inventory on December 31, 2020, reveals that 119 footballs were in stock. The bookkeeper informs you that all the discounts were taken. Assume that Novak Football Shop uses the invoice price less discount for recording purchases.
Compute the December 31, 2020, inventory using the FIFO method. (Round per unit and final answer to 2 decimal paces, e.g. 35.57.)
Ending Inventory using the FIFO method $
Compute the 2020 cost of goods sold using the LIFO method. (Round per unit and final answer to 2 decimal paces, e.g. 35.57.)
Cost of Goods Sold using the LIFO method $
What method would you recommend to the owner to minimize income taxes in 2020, using the inventory information for footballs as a guide?

FIFOLIFO

Solutions

Expert Solution

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Novak A B C D=(B-B*C) E=D*A
Periodic FIFO No. of Units Invoice Cost Discount Net Cost Total net cost
Purchased on Jan 15            75.00              32.00 0%              32.00        2,400.00
Purchased on Mar 15            90.00              25.00 1%              24.75        2,227.50
Purchased on Jun 20          115.00              24.00 1%              23.76        2,732.40
Purchased on Sep 12          109.00              19.00 1%              18.81        2,050.29
Purchased on Nov 24          101.00              17.00 1%              16.83        1,699.83
Total          490.00      11,110.02
Final Answer- FIFO
Ending Inventory Units Net Cost Total net cost
From Purchases on Sep 12            18.00              18.81            338.58
From Purchases on Nov 24          101.00              16.83        1,699.83
Cost of ending inventory          119.00        2,038.41
Cost of goods sold        9,071.61
Cost of goods sold is total net cost less cost of ending inventory.
Final Answer- LIFO
Ending Inventory Units Net Cost Total net cost
From Purchases on Jan 15            75.00              32.00        2,400.00
From Purchases on Mar 15            44.00              24.75        1,089.00
Cost of ending inventory          119.00        3,489.00
Cost of goods sold        7,621.02
Cost of goods sold is total net cost less cost of ending inventory.
The prices are falling so in order to minimize taxes the owner should use FIFO. Because FIFO gives higher cost of goods sold so the income will be lower and hence income taxes will also be lower.

Related Solutions

Novak Sports began operations on January 2, 2020. The following stock record card for footballs was...
Novak 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. Date Voucher Terms Units Received Unit Invoice Cost Gross Invoice Amount 1/15 10624 Net 30 75 $32 $2,400 3/15 11437 1/5, net 30 90 25 2,250 6/20 21332 1/10, net 30 115 24 2,760 9/12 27644 1/10, net 30 109 19 2,071 11/24 31269 1/10, net 30 101 17 1,717 Totals 490 $11,198 A...
Sunland Sports began operations on January 2, 2020. The following stock record card for footballs was...
Sunland 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. Date Voucher Terms Units Received Unit Invoice Cost Gross Invoice Amount 1/15 10624 Net 30 63 $27 $1,701 3/15 11437 1/5, net 30 78 21 1,638 6/20 21332 1/10, net 30 103 20 2,060 9/12 27644 1/10, net 30 97 16 1,552 11/24 31269 1/10, net 30 89 15 1,335 Totals 430 $8,286 A...
Crane Sports began operations on January 2, 2020. The following stock record card for footballs was...
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. Date Voucher Terms Units Received Unit Invoice Cost Gross Invoice Amount 1/15 10624 Net 30 51 $22 $1,122 3/15 11437 1/5, net 30 66 18 1,188 6/20 21332 1/10, net 30 91 17 1,547 9/12 27644 1/10, net 30 85 13 1,105 11/24 31269 1/10, net 30 77 12 924 Totals 370 $5,886 A...
Nash Football Shop began operations on January 2, 2017. The following stock record card for footballs...
Nash 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. Date Voucher Terms Units Received Unit Invoice Cost Gross Invoice Amount 1/15 10624 Net 30 57 $24 $1,368 3/15 11437 1/5, net 30 72 20 1,440 6/20 21332 1/10, net 30 97 18 1,746 9/12 27644 1/10, net 30 91 15 1,365 11/24 31269 1/10, net 30 83 13 1,079 Totals 400 $6,998...
Oriole Football Shop began operations on January 2, 2017. The following stock record card for footballs...
Oriole 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. Date Voucher Terms Units Received Unit Invoice Cost Gross Invoice Amount 1/15 10624 Net 30 55 $24 $1,320 3/15 11437 1/5, net 30 70 19 1,330 6/20 21332 1/10, net 30 95 18 1,710 9/12 27644 1/10, net 30 89 14 1,246 11/24 31269 1/10, net 30 81 13 1,053 Totals 390 $6,659...
Sunland Co. began operations on January 2, 2020. It employs 17 people who work 8-hour days....
Sunland Co. began operations on January 2, 2020. It employs 17 people who work 8-hour days. Each employee earns 10 paid vacation days annually. Vacation days may be taken after January 10 of the year following the year in which they are earned. The average hourly wage rate was $20 in 2020 and $21.75 in 2021. The average vacation days used by each employee in 2021 was 9. Sunland Co. accrues the cost of compensated absences at rates of pay...
Peru Industries began operations on January 1, 2020.
Problem 8-6A Recording accounts receivable transactions and bad debt adjustments LO1, 2, 3Peru Industries began operations on January 1, 2020. During the next two years, the company completed a number of transactions involving credit sales, accounts receivable collections, and bad debts (assume a perpetual inventory system). These transactions are summarized as follows:2020Sold merchandise on credit for $2,310,000, terms n/30 (COGS = $1,276,000).Wrote off uncollectible accounts receivable in the amount of $35,200.Received cash of $1,378,000 in payment of outstanding accounts receivable.In...
Exercise 9-28 Cullumber Corporation began operations on January 1, 2020, with a beginning inventory of $39,852...
Exercise 9-28 Cullumber Corporation began operations on January 1, 2020, with a beginning inventory of $39,852 at cost and $50,000 at retail. The following information relates to 2020. Retail Net purchases ($110,100 at cost) $151,100 Net markups 10,100 Net markdowns 5,000 Sales revenue 129,000 Assume Cullumber decided to adopt the conventional retail method. Compute the ending inventory to be reported in the balance sheet. (Round ratios for computational purposes to 1 decimal place, e.g. 78.7% and final answer to 0...
Exercise 17-03 On January 1, 2020, Pearl Company purchased 8% bonds having a maturity value of...
Exercise 17-03 On January 1, 2020, Pearl Company purchased 8% bonds having a maturity value of $400,000, for $433,699.52. The bonds provide the bondholders with a 6% yield. They are dated January 1, 2020, and mature January 1, 2025, with interest received on January 1 of each year. Pearl Company uses the effective-interest method to allocate unamortized discount or premium. The bonds are classified in the held-to-maturity category. Your answer is correct. Prepare the journal entry at the date of...
Mercy Sports Shop started operations on 1st January, 2020. The firm sells sports shoes in shopping...
Mercy Sports Shop started operations on 1st January, 2020. The firm sells sports shoes in shopping malls. The company expects a 20 per cent increase in sales per month for November and December 2020. Mercy has budgeted sales as indicated in the following table: Sales October November December Total Cash sales Ksh 300,000/= Sales on account Ksh 900,000/= Total budget sales Ksh 1,200,000/= Required:- Using excel complete the sales budget by filling in the missing amounts.    Determine the amount...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT