Inventory
Hard Test
Hard Test
Click the “Check Your Answer” box below each problem to reveal the correct answer and explanation.
a. FIFO perpetual
b. LIFO periodic
c. Weighted average
d. each method listed will give the same cost of goods sold
Answer
A. An inflationary environment means that costs are increasing. The lowest cost of goods sold will be from the first items being sold first because they have a lower cost. First items sold first is FIFO. Periodic or perpetual does not impact the answer.
a. the company will have larger income using LIFO than FIFO
b. the company will have lower cost of goods sold using LIFO than FIFO
c. inventory will have a lower value under LIFO than FIFO
d. net income is always the same under FIFO and LIFO
Answer
a. inventory is reported properly
b. cost of goods sold is lower
c. income is lower
d. inventory is understated
Answer
a. higher
b. lower
c. the same as
d. depends on the total purchases of the company
Answer
a. when using the perpetual moving average the total cost of goods sold will not equal total available less ending inventory
b. the gross method of recording inventory transactions uses the purchase discount account.
c. the net method of recording inventory transactions may use the purchase returns account
d. FIFO periodic will give the same ending inventory value as FIFO perpetual
Answer
a. on average inventory is held for 30 days
b. on average inventory is held for one year
c. LIFO is used for tax purposes
d. LIFO is used for financial reporting purposes
Answer
a. understated by $70,000
b. overstated by $70,000
c. understated by $30,000
d. overstated by $30,000
Answer
B. Beginning inventory too low will make cost of goods sold too low. Ending inventory too high will make cost of goods sold too low. Both errors reduce cost of goods sold, so the amounts are added to make cost of goods sold too low by $70,000. (Refer to the formula BI + Purchases – EI = CGS)
a. it allows gross profit to be reported 100% accurately
b. it reports inventory on the balance sheet at approximate replacement cost
c. it always reports the asset on the balance sheet at the lowest amount possible
d. it always maximizes net income
Answer
a. FIFO
b. LIFO
c. Weighted average
d. inventory methods do not affect cash flows
Answer
a. be higher since reported cost of goods sold will be lower
b. be lower since reported cost of goods sold will be higher
c. be the same since lower of cost or market does not affect net income
d. be higher since the adjustment to market will occur when the inventory is sold due to the matching concept
Answer
Compute the value of ending inventory and cost of goods sold for the period using
the periodic method and
A. FIFO
B. LIFO
C. Average cost
Answer
Batch | Total Cost | Quantity | Cost per unit |
1 | $135,000 | 12,000 | $11.25 |
2 | $161,000 | 14,000 | $11.50 |
3 | $ 96,000 | 8,000 | $12.00 |
Shipping costs are a selling cost and are not part of the cost of the product.
Second: Put inventory in order and determine available quantity and cost.
Quantity | Cost per | Total Cost | |
Beginning | 10,000 | $11.00 | $110,000 |
Batch 1 | 12,000 | $11.25 | $135,000 |
Batch 2 | 14,000 | $11.50 | $161,000 |
Batch 3 | 8,000 | $12.00 | $ 96,000 |
Total Available | 44,000 | $502,000 |
Then compute cost of goods sold and ending inventory for each method.
11.A. FIFO
First ones manufactured are the first ones sold.
Go down from the top until the total quantity is 41,000.
Quantity | Cost per | Total Cost | |
Beginning | 10,000 | $11.00 | $110,000 |
Batch 1 | 12,000 | $11.25 | $135,000 |
Batch 2 | 14,000 | $11.50 | $161,000 |
Batch 3 | 5,000 | $12.00 | $ 60,000 |
Total sold | 41,000 | $466,000 = Cost of goods sold |
Use only 5,000 of Batch 3 because that is all that is required to total to 41,000 sold.
Once you have determined the cost of goods sold, ending inventory is always
Available $502,000
– Cost of goods sold ($466,000)
= Ending inventory $ 36,000
Ending inventory: 300 x $12 = $36,000
11.B. LIFO
Last ones purchased are the first ones sold.
Start at the bottom and go up until the total sold is 41,000 units.
Quantity | Cost per | Total Cost | |
Batch 3 | 8,000 | $12.00 | $ 96,000 |
Batch 2 | 14,000 | $11.50 | $161,000 |
Batch 1 | 12,000 | $11.25 | $135,000 |
Beginning | 7,000 | $11.00 | $ 77,000 |
Total sold | 41,000 | $469,000 = Cost of goods sold |
Use only 7,000 of the beginning inventory because that is all that is required to total 41,000 sold.
Ending inventory is always
Available $502,000 see above
– Cost of goods sold ($469,000)
= Ending inventory $ 33,000
11.C. Weighted Average method:
Use “Available” to get the average cost per unit
Total $ Available $502,000 =
Total Quantity Available 44,000
$11.409 average cost per unit
Units sold 41,000
x Average cost per unit $11.409
= Cost of goods sold $467,769
Units ending inventory 3,000
x Average cost per unit $11.409
= Ending inventory $34,227
Ending inventory is always
Available $502,000
– Cost of goods sold ($467,769)
= Ending inventory $ 34,231
$4 difference due to rounding the moving average cost per unit
Compute Cost of Goods Sold.
Answer
Purchase: 80,000 net of 1.2% = 960 = 79,040 net
Freight In: no discount offered from the shipper
Return: 2,000 net of 1.2% = 24 = 1,976 net
Beginning Inventory: 33,000 net of 1.2% = 396 = 32,604 net
Ending Inventory: 77,400 net of 1.2% 929 = 76,471 net
Payment – not used, payment is too late to take the discount
Cost of goods sold is not recorded using the periodic method.
Compute Cost of Goods Sold using net amounts:
Beginning FG Inventory $ 32,604
+ Purchases $ 79,040
+ Freight In $ 850
– Purchase returns $ (1,976)
= Available for sale $ 110,518
– Ending FG Inventory $ (76,471)
= Cost of Goods Sold $ 34,047
a. On December 28th, $8,000 of goods were shipped F.O.B. destination to customers. The goods were received on January 2nd.
b. On December 28th, $6,000 of goods were shipped F.O.B. shipping to customers. The goods were received on January 2nd. The goods were included in the inventory balance.
c. $12,000 of inventory held in the warehouse on consignment was included in the inventory balance.
Gross profit based on the above inventory count was $600,000. Compute the correct gross profit?
Answer
Ending inventory must be increased by $8,000
b. Inventory shipped FOB shipping is owned by the customer on the date it is shipped.
The inventory was included in the count and must be taken out of the ending balance.
Ending inventory must be decreased by $6,000
c. Goods owned on consignment are not owned by the company and should not be
included in the ending inventory balance.
Ending inventory must be decreased by $12,000
Total change is + 8,000 – 6,000 – 12,000 = decrease of 10,000 to inventory
Beginning Inventory
+ Purchases
– Ending inventory (10,000) Ending inventory is less so
= Cost of goods sold + 10,000 cost of goods sold is more
Sales
– cost of goods sold +10,000 Cost of goods sold is more so
= Gross profit (10,000) gross profit will be less
Previous gross profit 600,000
Lower Gross profit (10,000)
Adjusted Gross profit 590,000
Compute cost of goods sold reported on the income statement and ending inventory reported on the balance sheet for the quarter using the perpetual method and
A. FIFO
B. LIFO
C. Moving Average
Answer
Inventory on 1/1 | 200 x $6.50 = | $ 1,300 |
1/5 | 750 x $6.00 = | $ 4,500 |
2/5 | 750 x $5.40 = | $ 4,050 |
3/5 | 750 x $4.86 = | $ 3,645 |
Available | 2,450 | $13,495 |
– Sales during quarter | (1,675) | ?? |
= Ending Inventory 3/31 | 775 | ?? |
First ones purchased are the first ones sold.
Start from the top and go down until total units sold is 1,675.
Inventory on 1/1 | 200 x $6.50 = | $ 1,300 |
Purchase 1/5 | 750 x $6.00 = | $ 4,500 |
Purchase 2/5 | 725 x $5.40 = | $ 3,915 |
Total Sold | 1,675 | $ 9,715 |
Ending inventory is always
Available $13,495
– Cost of goods sold ($ 9,715)
= Ending inventory $ 3,780
14.B) LIFO
1st Set up purchases and sales in date order. Only units on hand before the sale
are included in units sold, starting with the last one purchased.
Purchases Sales
Cost Cost
Units per-unit Sold per unit CGS
January 1 Beginning Balance 200 $6.50
January 5 Purchased 750 $6
January 9 Sold (300) 300 $6 $1,800 from 1/5
February 2 Sold (600) 450 $6 $2,700 from 1/5
150 $6.50 $ 975 from BI
February 5 Purchased 750 $5.40
March 5 Purchased 750 $4.86
March 17 Sold (775) 750 $4.86 $3,645 from 3/5
25 $5.40 $ 135 from 2/5
_______
Total CGS: $9,255
Ending Inventory:
From Beg Inventory 50 x $6.50 = $ 325
From 2/5 Purchase 725 x $5.40 = $3,915
Total Ending Inventory $4,240
Double check your computations.
Available $13,495
– Cost of goods sold ($ 9,255)
= Ending inventory $ 4,240
Ending Inventory:
From Beg Inventory 50 x $6.50 = $ 325
From 2/5 Purchase 725 x $5.40 = $3,915
Total Ending Inventory $4,240
Double check your computations.
Available $13,495
– Cost of goods sold ($ 9,255)
= Ending inventory $ 4,240
14.C) Perpetual Moving Average:
A new moving average is computed after each purchase.
The cost of the sale is recorded at the most recent moving average cost per unit.
Sales do not change the moving average.
Purchases Sales
Cost Moving Cost
Units x per-unit = Total Average Sold x per unit = CGS
January 1 Beginning 200 $6.50 $1,300
January 5 Purchased 750 $6 $4,500
Moving Average 950 $5,800 $6.11
January 9 Sold (300) ($1,833) 300 $6.11 $1,833
February 2 Sold (600) ($3,666) 600 $6.11 $3,666
February 5 Purchased 750 $5.40 $4,050
March 5 Purchased 750 $4.86 $3,645
Moving Average 1,550 $7,996 $5.16
March 17 Sold (775) ($3,999) 775 $5.16 $3,999
_______
Ending Inventory 775 $3,997
Total CGS: $9,498
Double check your computations.
Units ending inventory 775
x Average cost per unit $5.16
= Ending inventory $3,999
Ending inventory is always
Available $13,495
– Cost of goods sold ($ 9,498)
= Ending inventory $ 3,997
$2 difference due to rounding in moving average cost to dollars and cents.