Chapter 6, Problem 4BP

a.

To determine

Ascertain the cost of goods sold and the ending inventory cost at December 31, 2012 under first-in first out method.

Explanation of Solution

Periodic inventory system: The method or system of recording the transactions related to inventory occasionally or periodically are referred to as periodic inventory system.

First-in-First-Out (FIFO): In this method, items purchased initially are sold first. So, the value of the ending inventory consist the recent cost for the remaining unsold items.

Ascertain the cost of goods sold and the ending inventory cost for the month of April under first-in first out method as follows:

Ending inventory:

Calculation of Cost of Ending Inventory
Details	Number of Units	Rate per Unit ($)	Total Cost ($)
November 23	1,200	55	66,000
September 19	800	50	40,000
March 8	200	44	8,800
Ending Inventory	2,200		114,800

Table (1)

Therefore, the ending inventory of Company G under first-in first out method is $114,800.

Calculate the Cost of Goods Sold:

Here,

Goods available for sale is $342,000 (Refer Table 2)

Ending inventory is $114,800 (Refer Table 1)

$\begin{array}{c}\text{Cost of goods sold = Goods available for sale }-\text{ Ending inventory}\\ \text{=}\text{\$342,000 }-\$114,800\\ =\$227,200\end{array}$

Therefore, the cost of goods sold of Company G under first-in first out under method is $227,200.

Working note:

Calculate the total cost and goods available for sales

Calculation of Goods Available for Sales
Details	Number of Units	Rate per Unit ($)	Total Cost ($)
Beginning balance	2,600	40	104,000
Add: Purchases
March 8	3,000	44	132,000
September 19	800	50	40,000
November 23	1,200	55	66,000
Total Goods available for Sale	7,600		342,000
Less: Sales:
January 3	1,600
June 13	2,000
December 23	1,800
Ending Inventory	2,200

Table (2)

b.

To determine

Ascertain the cost of goods sold and the ending inventory cost at December 31, 2012 under last-in first out method.

Explanation of Solution

Last-in-First-Out (LIFO): In this method, items purchased recently are sold first. So, the value of the ending inventory consist the initial cost for the remaining unsold items.

Ascertain the cost of goods sold and the ending inventory cost for the month of April under last-in first out method as follows:

Ending inventory:

Calculation of Cost of Ending Inventory
Details	Number of Units	Rate per Unit ($)	Total Cost ($)
Beginning Balance	2,200	40	88,000
Ending Inventory	2,200		88,000

Table (3)

Therefore, the ending inventory of Company G under last-in first out method is $88,000.

Calculate the Cost of Goods Sold:

Here,

Goods available for sale is $342,000 (Refer Table 2)

Ending inventory is $88,000 (Refer Table 3)

$\begin{array}{c}\text{Cost of goods sold}=\text{Goods available for sale }-\text{ Ending inventory}\\ =\$342,000-\$88,000\\ =\$254,000\end{array}$

Therefore, the cost of goods sold of Company G under first-in first out under method is $254,000.

c.

To determine

Ascertain the cost of goods sold and the ending inventory cost for the month of April under weighted average cost method.

Explanation of Solution

Weighted-average Cost Method:  In this method, the inventories are priced at the average rate of goods available for sales.

Ascertain the cost of goods sold and the ending inventory cost for the month of April under weighted average cost method as follows:

Ending inventory:

Here,

Weighted- average cost per unit is $45 (1)

Number of units in ending inventory is 2,000 units (Refer Table 2)

$\begin{array}{c}\text{Cost of Ending inventory = }\left(\begin{array}{l}\text{Number of units in Ending inventory }\\ \times \text{ Weighted-average cost per unit}\end{array}\right)\\ =2,200\text{ units }\times \text{ \$45}\text{.00}\\ \text{=}\text{\$99,000}\end{array}$

Therefore, the ending inventory of Company G under weighed average cost method is $99,000.

Calculate the Cost of Goods Sold:

Goods available for sale is $342,000 (Refer Table 1)

Ending inventory is $99,000

$\begin{array}{c}\text{Cost of goods sold = Goods available for sale }-\text{ Ending inventory}\\ \text{=}\text{\$342,000 }-\$99,000\\ =\$243,000\end{array}$

Therefore, the cost of goods sold of Company G under weighed average cost method is $243,000.

Working note:

Calculate weighted average cost per unit

Here,

Total cost of goods available for sale is $342,000 (Refer Table 2)

Total units of goods available for sale is 7,600 units (Refer Table 2)

$\begin{array}{c}\begin{array}{l}\text{Weighted-average}\\ \text{ Cost}\end{array}\}=\frac{\text{Total Cost of Goods Available For Sale}}{\text{Total number of units Available for Sale}}\\ =\frac{\$342,000}{\text{7,600 Units}}\\ =\$45.00\end{array}$ (1)

d.

To determine

Identify the inventory cost method that is more appropriate if Company G sells quickly obsolete items.

Explanation of Solution

Identify the inventory cost method that is more appropriate if Company G sells quickly obsolete items as follows:

1. Reflect the likely goods flow through the business:

If the goods flow is to be reflected through the business, use FIFO method because the perishable goods should be used before they time-out, expire, or become old (editions)

2. Minimize income tax for the period:

If the income tax is to be minimized, use LIFO method because cost of goods sold is higher and eventually lower net income resulting in a lower income tax, hence, tax savings are possible.

3. Report the largest amount of net income for the period:

If the company wants to report higher net income, FIFO method should be used because high price products are used later under the FIFO method. The low price or older price results in the low cost of goods sold. Low cost of goods sold results in high net income.