Ehlo Company is a multiproduct firm. Presented below is information concerning one of its products, the Hawkeye.

Date Transaction Quantity Price/Cost

1/1 Beginning inventory 1,000 $12

2/4 Purchase 2,000 18

2/20 Sale 2,500 30

4/2 Purchase 3,000 23

11/4 Sale 2,200 33

Instructions

Compute cost of goods sold, assuming Ehlo uses:

(a) Periodic system, FIFO cost flow. (d) Perpetual system, LIFO cost flow.

(b) Perpetual system, FIFO cost flow. (e) Periodic system, weighted-average

cost flow.

(c) Periodic system, LIFO cost flow. (f) Perpetual system, moving-average

cost flow.

$\begin{array}{rcl}\mathrm{Ending}\mathrm{inventory}\left(\mathrm{Units}\right)& =& \mathrm{Total}\mathrm{goods}\mathrm{available}\mathrm{for}\mathrm{sale}\left(\mathrm{units}\right)-\mathrm{Total}\mathrm{goods}\mathrm{sold}\left(\mathrm{units}\right)\\ & =& \left(1000+2000+3000\right)-\left(2500+2200\right)\\ & =& 6000-4700\\ & =& 1300\\ & & \\ \mathrm{Ending}\mathrm{inventory}\left(\mathrm{value}\right)& =& 1300\mathrm{units}\mathrm{purchased}\mathrm{on}2\mathrm{nd}\mathrm{April}\times \mathrm{Price}\mathrm{cost}\\ & =& 1300\times \$23\\ & =& \$29,900\\ & & \\ \mathrm{Cost}\mathrm{of}\mathrm{goods}\mathrm{sold}\left(\mathrm{value}\right)& =& \mathrm{Total}\mathrm{goods}\mathrm{available}\mathrm{for}\mathrm{sale}\left(\mathrm{value}\right)-\mathrm{Value}\mathrm{of}\mathrm{ending}\mathrm{inventory}\\ & =& \left(1000\times \$12+2000\times \$18+3000\times \$23\right)-\$29,900\\ & =& \$117,000-29,900\\ & =& \$87,100\end{array}$

The cost of goods sold under FIFO is $87,100.

$\begin{array}{rcl}\mathrm{Ending}\mathrm{inventory}\left(\mathrm{units}\right)& =& \mathrm{Total}\mathrm{goods}\mathrm{available}\mathrm{for}\mathrm{sale}\left(\mathrm{units}\right)-\mathrm{Total}\mathrm{goods}\mathrm{sold}\left(\mathrm{units}\right)\\ & =& \left(1000+2000+3000\right)-\left(2500+2200\right)\\ & =& 6000-4700\\ & =& 1300\\ & & \\ \mathrm{Ending}\mathrm{inventory}\left(\mathrm{value}\right)& =& \left(100\mathrm{units}\mathrm{of}\mathrm{beginning}\mathrm{inventory}\times \mathrm{cost}\right)+\left(300\mathrm{units}\mathrm{of}2\mathrm{nd}\mathrm{feb}\mathrm{purchase}\times \mathrm{cost}\right)\\ & =& \left(1000\times \$12\right)+\left(300\times \$18\right)\\ & =& \$17,400\\ & & \\ \mathrm{Cost}\mathrm{of}\mathrm{goods}\mathrm{sold}\left(\mathrm{value}\right)& =& \mathrm{Total}\mathrm{goods}\mathrm{available}\mathrm{for}\mathrm{sale}\left(\mathrm{value}\right)-\mathrm{Value}\mathrm{of}\mathrm{ending}\mathrm{inventory}\\ & =& \left(1000\times \$12+2000\times \$18+3000\times \$23\right)-\$17,400\\ & =& \$117,000-\$17,400\\ & =& \$99,600\end{array}$

The cost of goods sold under FIFO is $92,600.

$\begin{array}{rcl}\mathrm{Ending}\mathrm{inventory}\left(\mathrm{units}\right)& =& \mathrm{Total}\mathrm{goods}\mathrm{available}\mathrm{for}\mathrm{sale}\left(\mathrm{units}\right)-\mathrm{Total}\mathrm{goods}\mathrm{sold}\left(\mathrm{units}\right)\\ & =& \left(1000+2000+3000\right)-\left(2500+2200\right)\\ & =& 6000-4700\\ & =& 1300\\ & & \\ \mathrm{Average}\mathrm{cost}& =& \frac{\mathrm{Value}\mathrm{of}\mathrm{all}\mathrm{inventories}}{\mathrm{Total}\mathrm{inventories}\left(\mathrm{units}\right)}\\ & =& \frac{\left(1000\times \$12+2000\times \$18+3000\times \$23\right)}{1000+2000+3000}\\ & =& \frac{\$117000}{6000}\\ & =& \$19.5\\ & & \\ \mathrm{Cost}\mathrm{of}\mathrm{goods}\mathrm{sold}\left(\mathrm{value}\right)& =& \mathrm{Total}\mathrm{goods}\mathrm{available}\mathrm{for}\mathrm{sale}\left(\mathrm{value}\right)-\mathrm{Value}\mathrm{of}\mathrm{ending}\mathrm{inventory}\\ & =& \$117,000-\left(\$1300\times \$19.5\right)\\ & =& \$117,000-\$25,350\\ & =& \$91,650\end{array}$

The cost of goods sold under FIFO is $87,146.