91Ó°ÊÓ

Question:Johnny 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.

Units Unit Invoice Gross Invoice

Date Voucher Terms Received Cost 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, 2017, reveals that 100 footballs were in stock. The bookkeeper informs you that all thediscounts were taken. Assume that Johnny Football Shop uses the invoice price less discount for recording purchases.

Instructions

(a) Compute the December 31, 2017, inventory using the FIFO method.

(b) Compute the 2017 cost of goods sold using the LIFO method.

(c) What method would you recommend to the owner to minimize income taxes in 2017, using the inventory informationfor footballs as a guide?

Step by step solution

01

Value of ending inventory using FIFO

Date	Gross Invoice Amount	Discount Value	Net Invoice Amount
1/15	$1000	-	$1,000
3/15	$1,040	$10..4	$1029.6
6/20	$1,350	$13.5	$1336.5
9/12	$1,008	$10.08	$997.92
11/24	$836	$8.36	$827.64
Total		$42.34	$5191.66

$$\begin{gathered} \mathbf{Cost}\mathbf{}\mathbf{of}\mathbf{}\mathbf{ending}\mathbf{}\mathbf{inventory}\mathbf{}\mathbf{(}\mathbf{based}\mathbf{}\mathbf{on}\mathbf{}\mathbf{FIFO}\mathbf{)}\mathbf{=}\mathbf{Net}\mathbf{}\mathbf{value}\mathbf{}\mathbf{of}\mathbf{}\mathbf{Dec}\mathbf{}\mathbf{11}\mathbf{}\mathbf{purchase}\mathbf{+}\mathbf{Net}\mathbf{}\mathbf{value}\mathbf{}\mathbf{of}\mathbf{}\mathbf{Dec}\mathbf{}\mathbf{9}\mathbf{}\mathbf{purchase}\mathbf{}\mathbf{for}\mathbf{}\mathbf{24}\mathbf{}\mathbf{units} \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\left(76×11-1\%\right)\mathbf{+}\left(24×12-1\%\right) \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\mathbf{\$}\mathbf{827}\mathbf{.}\mathbf{64}\mathbf{+}\mathbf{\$}\mathbf{285}\mathbf{.}\mathbf{12} \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\mathbf{\$}\mathbf{1}\mathbf{,}\mathbf{112}\mathbf{.}\mathbf{76} \end{gathered}$$

02

Computation of cost of goods sold using LIFO

Date	Gross Invoice Amount	Discount Value	Net Invoice Amount
1/15	$1000	-	$1,000
3/15	$1,040	$10..4	$1029.6
6/20	$1,350	$13.5	$1336.5
9/12	$1,008	$10.08	$997.92
11/24	$836	$8.36	$827.64
Total		$42.34	$5191.66

$$\begin{gathered} \mathbf{Cost}\mathbf{}\mathbf{of}\mathbf{}\mathbf{ending}\mathbf{}\mathbf{inventory}\mathbf{}\mathbf{(}\mathbf{based}\mathbf{}\mathbf{on}\mathbf{}\mathbf{LIFO}\mathbf{)}\mathbf{=}\mathbf{Net}\mathbf{}\mathbf{value}\mathbf{}\mathbf{of}\mathbf{}\mathbf{Dec}\mathbf{}\mathbf{1}\mathbf{}\mathbf{purchase}\mathbf{+}\mathbf{Net}\mathbf{}\mathbf{value}\mathbf{}\mathbf{of}\mathbf{}\mathbf{Dec}\mathbf{}\mathbf{3}\mathbf{}\mathbf{purchase}\mathbf{}\mathbf{for}\mathbf{}\mathbf{24}\mathbf{}\mathbf{units} \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\mathbf{(}\mathbf{50}\mathbf{×}\mathbf{20}\mathbf{)}\mathbf{+}\mathbf{(}\mathbf{50}\mathbf{×}\mathbf{16}\mathbf{-}\mathbf{1}\mathbf{\%}\mathbf{)} \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\mathbf{\$}\mathbf{1}\mathbf{,}\mathbf{000}\mathbf{+}\mathbf{\$}\mathbf{792} \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\mathbf{\$}\mathbf{1}\mathbf{,}\mathbf{792} \end{gathered}$$

$$\begin{gathered} \mathbf{Cost}\mathbf{}\mathbf{of}\mathbf{}\mathbf{goods}\mathbf{}\mathbf{(}\mathbf{based}\mathbf{}\mathbf{on}\mathbf{}\mathbf{LIFO}\mathbf{)}\mathbf{=}\mathbf{Total}\mathbf{}\mathbf{Net}\mathbf{}\mathbf{value}\mathbf{}\mathbf{purchase}\mathbf{-}\mathbf{cost}\mathbf{}\mathbf{of}\mathbf{}\mathbf{ending}\mathbf{}\mathbf{inventory} \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\mathbf{\$}\mathbf{5}\mathbf{,}\mathbf{234}\mathbf{+}\mathbf{\$}\mathbf{1}\mathbf{,}\mathbf{792} \\ \mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{}\mathbf{=}\mathbf{\$}\mathbf{3}\mathbf{,}\mathbf{442} \end{gathered}$$

03

Inventory valuation method to minimize taxes

Under the FIFO method, the cost of goods sold is valued at the historic cost. Whereas in the LIFO method, the COGS is valued at the current prices. So the COGs would be highest under the LIFO method, and the net profit would be lower.

Thus, the owner should use the LIFO method to minimize the taxes.

Unlock Step-by-Step Solutions & Ace Your Exams!

• Full Textbook Solutions

  Get detailed explanations and key concepts

• Unlimited Al creation

  Al flashcards, explanations, exams and more...

• Ads-free access

  To over 500 millions flashcards

• Money-back guarantee

  We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!