Chapter 7, Problem 3AP

Evaluating the UFO and FIFO Choice When Costs Are Rising and Falling (P7-5)

Income is to be evaluated under four different situations as follows:

1. a. Prices are rising:
   1. (1) Situation A: FIFO is used.
   2. (2) Situation B: LIFO is used.
2. b. Prices are falling:
   1. (1) Situation C: FIFO is used.
   2. (2) Situation D: UFO is used.

The basic data common to all four situations are: sales, 510 units for $13,260; beginning inventory, 340 units; purchases, 410 units; ending inventory, 240 units; and operating expenses, $5,000. The following tabulated income statements for each situation have been set up for analytical purposes:

	PRICES RISING		PRICES FALLING
	Situation A	Situation B	Situation C	Situation I)
	FIFO	LIFO	FIFO	LIFO
Sales revenue	$13,260	$13,260	$13,260	$13,260
Cost of goods sold: Beginning inventory'	3,060	?	?	?
Purchases	4,100	?	?	?
Goods available for sale	7,160	?	?	?
Ending inventory	2,400	?	?	?
Cost of goods sold	4,760	?	?	?
Gross profit	8,500	?	?	?
Expenses	5,000	5.000	5,000	5,000
Pretax income	3,500	?	?	?
Income tax expense (30%)	1,050	?	?	?
Net income	$ 2,450

Required:

1. 1. Complete the preceding tabulation for each situation. In Situations A and B (prices rising), assume the following: beginning inventory, 340 units at $9 = $3,060; purchases, 410 units at $10 = $4,100. In Situations C and D (prices falling), assume the opposite; that is. beginning inventory, 340 units at $10 = $3,400; purchases, 410 units at $9 = $3,690. Use periodic inventory procedures.
2. 2. Analyze the relative effects on pretax income and net income as demonstrated by requirement (1) when prices are rising and when prices are falling.
3. 3. Analyze the relative effects on the cash position for each situation.
4. 4. Would you recommend FIFO or LIFO? Explain.

To determine

Complete the preceding tabulation for each situation.

Answer to Problem 3AP

	Prices Rising		Prices Falling
Particulars	A	B	C	D
	FIFO	LIFO	FIFO	LIFO
Sales revenue (a) (1)	$13,260	$13,260	$13,260	$13,260
Beginning inventory	3,060	3,060	3,400	3,400
Add: Purchases	4,100	4,100	3,690	3,690
Goods available for sale Table (2)	7,160	7,160	7,090	7,090
Less: Ending inventory	2,400  Table (3)	2,160  Table (4)	2,160  Table (5)	2,400  Table (6)
Cost of goods sold (b) Table (7)	4,760	5,000	4,930	4,690
Gross profit $\left(\text{a}-\text{b}\right)$	8,500	8,260	8,330	8,570
Less: Expenses	5,000	5,000	5,000	5,000
Pretax income	3,500	3,260	3,330	3,570
Less: Income tax expense	1,050	978 (2)	999 (3)	1,071 (4)
Net income	$2,450	$2,282	$2,331	$2,499

Table (1)

Explanation of Solution

Periodic Inventory System:

Periodic inventory system is a system, in which the inventory is updated in the accounting records on a periodic basis such as at the end of each month, quarter or year. In other words, it is an accounting method which is used to determine the amount of inventory at the end of each accounting period.

First-in-First-Out:

In First-in-First-Out method, the costs of the initially purchased items are considered as cost of goods sold, for the items which are sold first. The value of the ending inventory consists of the recent purchased items.

Last-in-Last-Out:

In Last-in-First-Out method, the costs of last purchased items are considered as the cost of goods sold, for the items which are sold first. The value of the closing stock consists of the initial purchased items.

Cost of goods sold:

Cost of goods sold is the accumulate total of all direct cost incurred in manufacturing the goods or the products which has been sold during a period. Cost of goods sold involves direct material, direct labor, and manufacturing overheads.

Working notes:

Determine the amount of sales revenue:

$\begin{array}{c}\text{Sales}\text{revenue}=\text{Units}\text{sold}\times \text{Sales}\text{per}\text{unit}\\ \$13,260=\text{510Units}\times \text{Sales}\text{per}\text{unit}\\ \frac{\$13,260}{\text{510Units}}=\text{Sales}\text{per}\text{unit}\\ \text{Sales}\text{per}\text{unit}=\text{\$26}\end{array}$ (1)

Determine the goods available for sale for FIFO:

Date	Particulars	Units ($)	Unit cost ($)	Total cost ($)
		(a)	(b)	(c = a × b)
January 1	Beginning inventory	340	9	3,060
January 12	Purchased	410	10	4,100
	Total	750		7,160
	Less: Goods sold	510
	Ending inventory	240

Table (2)

Determine the amount of ending inventory for situation A using FIFO method:

Date	Particulars	Units	Unit cost ($)	Total cost ($)
		(a)	(b)	(c = a × b)
	Purchased	240	10	2,400
	Ending inventory	240		2,400

Table (3)

Determine the amount of ending inventory for situation B using LIFO method:

Date	Particulars	Units	Unit cost ($)	Total cost ($)
		(a)	(b)	(c = a × b)
	Purchased	240	9	2,160
	Ending inventory	240		2,160

Table (4)

Determine the amount of ending inventory for situation C using FIFO method:

Date	Particulars	Units	Unit cost ($)	Total cost ($)
		(a)	(b)	(c = a × b)
	Purchased	240	9	2,160
	Ending inventory	240		2,400

Table (5)

Determine the amount of ending inventory for situation D using LIFO method:

Date	Particulars	Units	Unit cost ($)	Total cost ($)
		(a)	(b)	(c = a × b)
	Purchased	240	10	2,400
	Ending inventory	240		2,400

Table (6)

Determine the amount of cost of goods sold for each method:

Situation	Particulars	Units	Unit cost ($)	Total cost ($)
		(a)	(b)	(c = a × b)
a. FIFO	Beginning	340	9	3,060
	Purchased	170	10	1,700
		510		4,760
b. LIFO	Beginning	410	10	4,100
	Purchased	100	9	900
		510		5,000
c. FIFO	Beginning	340	10	3,400
	Purchased	170	9	1,530
		510		4,930
d. LIFO	Beginning	410	9	3,690
	Purchased	100	10	1,000
		510		4,690

Table (7)

Determine the amount of income tax expense for Situation B:

$\begin{array}{c}\text{Income tax expenses}=\text{30\% of Preatx income}\\ =\text{30\% }\times \$3,260\\ =\$978\end{array}$ (2)

Determine the amount of income tax expense for Situation C:

$\begin{array}{c}\text{Income tax expenses}=\text{30\% of Preatx income}\\ =\text{30\% }\times \$3,330\\ =\$999\end{array}$ (3)

Determine the amount of income tax expense for Situation D:

$\begin{array}{c}\text{Income tax expenses}=\text{30\% of Preatx income}\\ =\text{30\% }\times \$3,570\\ =\$1,071\end{array}$ (4)

To determine

Analyze the relative effects on pretax income and net income, when there is a rise and fall in prices.

Answer to Problem 3AP

The amounts of pretax income when there is rise and fall in prices are compared as below:

Particulars	Situation A FIFO ($)	Situation B LIFO ($)	Difference ($) $\left(\text{A}-\text{B}\right)$
Pretax income when prices are rising	3,500	3,260	240
	Situation C FIFO ($)	Situation D LIFO ($)	Difference ($) $\left(\text{D}-\text{C}\right)$
Pretax income when prices are falling	3,330	3,570	240

Table (8)

Explanation of Solution

• From the above calculation, it is clear that the difference between the pretax tax income between FIFO and LIFO is same. Thus, a difference in inventory has a dollar-for-dollar effect on pretax income.
• When price rises, the FIFO method gives a higher net income than the LIFO method. On the other hand, when there is a fall in price, the LIFO method gives a higher net income than the FIFO method.

To determine

Analyze the relative effects on the cash position for each situation.

Explanation of Solution

• The LIFO method gives most favorable cash position than the FIFO method, when prices are rising. On the other hand, the FIFO method gives most favorable cash position than the LIFO method, when prices are falling. Thus, these cash positions are equal to the difference in income tax.

To determine

Explain the method that is recommended.

Explanation of Solution

• Both the LIFO method and FIFO method are equally reasonable in their aspects. For example, when there is a rise in price, the FIFO method produces most favorable results than LIFO by focusing on current income and EPS.
• On the other hand, when there is a rise in price, the LIFO method also produces most favorable results than FIFO by focusing on income tax expenses and cash position.  Still, these results will reverse when there is a fall in prices.
• On the income statement, FIFO does not match current expense with current revenues. However it provides a better valuation on the balance sheet. On the other hand, LIFO matches expenses with revenues. However, it provides a less related inventory valuation on the balance sheet.