Measuring and Reporting Inventories Practice Problems
Site: | Saylor Academy |
Course: | BUS103: Introduction to Financial Accounting |
Book: | Measuring and Reporting Inventories Practice Problems |
Printed by: | Guest user |
Date: | Thursday, 3 April 2025, 12:35 AM |
Description
Complete the practice problems. Check your answers after you finish.
Demonstration problem
Demonstration problem A
Following are data related to Adler Company's beginning inventory, purchases, and sales:
Beginning Inventory and Purchases |
Sales |
|||
Units |
|
Unit Cost |
|
Units |
Beginning inventory 6,250 |
@ |
$3.00 |
February 3 |
5,250 |
March 15 5,000 |
@ |
3.12 |
May 4 |
4,500 |
May 10 8,750 |
@ |
3.30 |
September 16 |
8,000 |
August 12 6,250 |
@ |
3.48 |
October 9 |
7,250 |
November 20 3,750 |
@ |
3.72 |
|
|
30,000 |
|
|
|
25,000 |
a. Compute the ending inventory under each of the following methods:
Specific identification (assume ending inventory is taken equally from the August 12 and November 20 purchases).
FIFO: (a) Assume use of perpetual inventory procedure.
(b) Assume use of periodic inventory procedure.
LIFO: (a) Assume use of perpetual inventory procedure.
(b) Assume use of periodic inventory procedure.
Weighted-average: (a) Assume use of perpetual inventory procedure.
(b) Assume use of periodic inventory procedure.
(Carry unit cost to four decimal places and round total cost to nearest dollar.)
b. Give the journal entries to record the individual purchases and sales (Cost of Goods Sold entry
only) under the LIFO method and perpetual procedure.
Demonstration problem B
a. Joel Company reported annual net income as follows:
2007.... USD 27,200
2008.... USD 28,400 2009.... USD 24,000
Analysis of the inventories shows that certain clerical errors were made with the following results:
|
Incorrect inventory amount |
Correct inventory amount |
2007 December 31 |
$4,800 |
$5,680 |
2008 December 31 |
5,600 |
4,680 |
What is the corrected net income for 2007, 2008, and 2009?
b. The records of Little Corporation show the following account balances on the day a fire destroyed
the company's inventory:
Merchandise inventory, January 1 USD 40,000
Net cost of purchases (to date) USD 200,000
Sales (to date) USD 300,000
Average rate of gross margin for the past five years 30 per cent of net sales.
Compute an estimated value of the ending inventory using the gross margin method. c. The records of Draper Company show the following account balances at year-end:
|
Cost |
Retail |
Merchandise inventory, January 1 |
$17,600 |
$25,000 |
Purchases |
68,000 |
100,000 |
Transportation-in |
1,900 |
|
Sales |
|
101,000 |
Compute the estimated ending inventory at cost using the retail inventory method.
Source: Textbook Equity, https://learn.saylor.org/pluginfile.php/41219/mod_resource/content/3/AccountingPrinciples.pdf This work is licensed under a Creative Commons Attribution 3.0 License.
Solution to demonstration problems
Solution to demonstration problem A
a. The ending inventory is 5,000 units, calculated as follows:
|
Units |
Beginning inventory |
6,250 |
Purchases |
23,750 |
Goods available |
30,000 |
Sales |
25,000 |
Ending inventory |
5,000 |
Ending inventory under specific identification:
Purchased |
Units |
Unit Cost |
Total Cost |
November 20 |
2,500 |
$3.72 |
$9,300 |
August 12 |
2,500 |
3.48 |
8,700 $18,000 |
- Ending inventory under FIFO:
- Perpetual:
|
Purchased |
Sold |
Balance
|
|||||
Date |
Units |
Unit Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit |
|
Beg. inv. |
|
|
|
|
|
6,250 |
$3.00 |
$18,750 |
Feb. 3 |
|
|
5,250 |
$3.00 |
$15,750 |
1,000 |
3.00 |
3,000 |
Mar. 15 |
5,000 |
$3.12 |
$15,600 |
|
|
1,000 |
3.00 |
3,000 |
|
|
|
|
|
|
5,000 |
3.12 |
15,600 |
May 4 |
|
|
1,000 |
3.00 |
3,000 |
1,500 |
3.12 |
4,680 |
|
|
|
3,500 |
3.12 |
10,920 |
|
|
|
May 10 |
8,750 |
3.30 28,875 |
|
|
|
1,500 |
3.12 |
4,680 |
|
|
|
|
|
|
8,750 |
3.3 |
28,875 |
Aug. 12 |
6,250 |
3.48 21,750 |
|
|
|
1,500 |
3.12 |
4,680 |
|
|
|
|
|
|
8,750 |
3.30 |
28,875 |
|
|
|
|
|
|
6,250 |
3.48 |
21,750 |
Sept. 16 |
|
|
1,500 |
3.12 |
4,680 |
2,250 |
3.30 |
7,425 |
|
|
|
6,500 |
3.30 |
21,450 |
6,250 |
3.48 |
21,750 |
Oct. 9 |
|
|
2,250 |
3.30 |
7,425 |
1,250 |
3.48 |
4,350 |
|
|
|
5,000 |
3.48 |
17,400 |
|
|
|
Nov. 20 |
3,750 |
3.72 |
13,950 |
|
|
1,250 |
3.48 |
4,350 |
|
3,750 |
3.72 |
|
|
|
|
|
13,950 |
Ending inventory = (1,250 X $3.48) + (3,750 X $3.72) = $18,300 |
(b) Periodic:
Purchased |
Units |
Unit Cost |
Total Cost |
November 20 |
3750 |
$3.72 |
$13,950 |
August 12 |
1250 |
3.48 |
4350 |
|
5000 |
|
$18,300 * |
*Note that the cost of ending inventory is the same as under perpetual.
- Ending inventory under LIFO:
(a) Perpetual:
|
Purchased |
Sold |
Balance |
||||||
Date |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Beg. inv. |
|
|
|
|
|
6,250 |
|
$3.00 |
$18,750 |
Feb. 3 |
|
|
|
5,250 |
$3.00 |
$15,750 |
1,000 |
3.00 |
3,000 |
Mar. 15 |
5,000 |
$3.12 |
$15,600 |
|
|
|
1,000 |
3.00 |
3,000 |
|
|
|
|
|
|
|
5,000 |
3.12 |
15,600 |
May 04 |
|
|
|
4,500 |
3.12 |
14,040 |
1,000 |
3.00 |
3,000 |
|
|
|
|
|
|
|
500 |
3.12 |
1,560 |
|
8,750 |
3.3 |
28,875 |
|
|
|
1,000 |
3.00 |
3,000 |
May 10 |
|
|
|
|
|
|
500 |
3.12 |
1,560 |
|
|
|
|
|
|
|
8,750 |
3.30 |
28,875 |
Aug. 12 |
6,250 |
3.48 |
21,750 |
|
|
|
1,000 |
3.00 |
3,000 |
|
|
|
|
|
|
|
500 |
3.12 |
1,560 |
|
|
|
|
|
|
|
8,750 |
3.30 |
28,875 |
|
|
|
|
|
|
|
6,250 |
3.48 |
21,750 |
Sept. 16 |
|
|
|
6,250 |
3.48 |
21,750 |
1,000 |
3.00 |
3,000 |
|
|
|
|
1,750 |
3.3 |
5,775 |
500 |
3.12 |
1,560 |
|
|
|
|
|
|
|
7,000 |
3.30 |
23,100 |
Oct. 9 |
|
|
|
7,000 |
3.3 |
23,100 |
1,000 |
3.00 |
3,000 |
|
|
|
|
250 |
3.12 |
780 |
250 |
3.12 |
780 |
Nov. 20 |
3,750 |
3.72 |
13,950 |
|
|
|
1,000 |
3.00 |
3,000 |
|
|
|
|
|
|
|
250 |
3.12 |
780 |
|
|
|
|
|
|
|
3,750 |
3.72 |
13,950 |
Ending inventory = (1,000 X $3.00) + (250 X $3.12) + (3,750 X $3.72) = $17,730
(b) Periodic:
Units |
Unit Cost |
Cost Cost |
|
Merchandise Inventory, January 1 |
5,000 |
$3.00 |
$15,000 |
- Ending inventory under weighted-average:
(a) Perpetual:
|
Purchased |
Sold |
Balance |
||||||
Date |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit |
Total Cost |
Beg. inv. |
|
|
|
|
|
|
6,250 |
$3.0000 |
$ 18,750 |
Feb. 3 |
|
|
|
5,250 |
$3.00 |
$15,750 |
1,000 |
3.0000 |
3,000 |
Mar. 15 |
5,000 |
$3.12 |
$15,600 |
|
|
|
6,000 |
3.1000 |
18,600 |
38108 |
|
|
|
4,500 |
3.10 |
13950 |
1,500 |
3.1000 |
4,650 |
40299 |
8,750 |
3.30 |
28,875 |
|
|
|
10,250 |
3.2707 |
33,525 |
Aug.12 |
6,250 |
3.48 |
21,750 |
|
|
|
16,500 |
3.3500 |
55,275 |
Sept. 16 |
|
|
|
8,000 |
3.35 |
26,800 |
8,500 |
3.3500 |
28,475 * |
Oct. 9 |
|
|
|
7,250 |
3.35 |
24,288 |
1,250 |
3.3500 |
4,187 * |
Nov. 20 |
3,750 |
3.72 |
13,950 |
|
|
|
5.000 |
3.6274 |
18,137 |
Ending inventory = (5,000 X $3.6274) = $18,137
a $18,600 = $3.100 b $33,525 = $3.2707 c $55,275 = $3.3500 d $18,137 = $3.6274
6,000 10,250 16,500 5,000
* Rounding difference.
Purchased |
Units |
Unit Cost |
Total Cost |
Merchandise Inventory, January 1 |
6,250 |
$3.00 |
$18,750 |
March 15 |
5,000 |
3.12 |
15,600 |
May 10 |
8,750 |
3.3 |
28,875 |
August 12 |
6,250 |
3.48 |
21,750 |
November 20 |
3,750 |
3.72 |
13,950 |
|
30,000 |
|
98,926 |
Weighted-average unit cost = $98,925/30,000 = $3.2975
Ending inventory cost = $3.2975 x 5,000 = $16,488*
*Rounding difference
- Journal entries under LIFO perpetual:
Feb. |
3 Cost of Goods Sold (-SE) |
15,750 |
15,750 |
|
Merchandise Inventory (-A) |
|
|
|
To record cost of $3 on 5,200 units sold |
|
|
Mar. |
15 Merchandise Inventory (+A) |
15,600 |
15,600 |
|
Accounts Payable (+L) |
|
|
|
To record purchase of 5,000 units at $3.12 on Account. |
|
|
May |
4 Cost of Goods Sold (-SE) |
14,040 |
14,040 |
|
Merchandise Inventory (-A) |
|
|
|
To record cost of $3.12 on 4,500 units sold. |
|
|
|
10 Merchandise Inventory (+A) |
28,875 |
28,875 |
|
Accounts Payable (+L) |
|
|
|
To record purchase of 8,750 units at $3.30 on account. |
|
|
Aug. |
12 Merchandise Inventory (+A) |
21,750 |
21,750 |
|
Accounts Payable (+L) |
|
|
|
To record purchase of 6,250 units at $3.48 on account |
|
|
Sept. |
16 Cost of Goods Sold (-SE) |
27,525 |
27,525 |
|
Merchandise Inventory (-A) |
|
|
|
To record costs of $3.48 and $3.30 on 6,250 units at 1,750 units sold, respectively. |
|
|
Oct. |
9 Cost of Goods Sold (-SE) |
23,880 |
23,880 |
|
Merchandise Inventory (-A) |
|
|
|
To record costs of $3.30 and $3.12 on 7,000 units and 250 units sold, respectively. |
|
|
Nov. |
20 Merchandise Inventory (+A) |
13,950 |
13,950 |
|
Accounts Payable (+L) |
|
|
|
To record purchase of 3,750 units at $3.72 on account. |
|
|
Solution to demonstration problem B
a. Corrected net income:
|
2007 |
2008 |
2009 |
Total |
Net income as reported |
$ 27,200 |
28,400 |
24000 |
$ 79,600 |
Adjustments |
|
|
|
|
(1) |
880 |
|
|
|
(2) |
|
(880) |
|
|
(3) |
|
(920) |
920 |
|
Corrected net income |
$ 28,080 |
26600 |
24,920 |
$ 79,600 |
(1) Ending inventory understated ($5,680 - $4,800 = $880)
(2) Beginning inventory understated (5,680 – 4,800 = 880)
Ending inventory overstated (5,600 – 4,680 = 920)
(3) Beginning inventory overstated (5,600 – 4,680 = 920)
(b) Computation of inventory:
Merchandise Inventory, January 1 |
|
$40,000 |
Net cost of purchases |
|
200,000 |
Cost of goods available for sale |
|
$ |
Less estimated cost of goods sold: |
|
240,000 |
Net Sales |
$300,000 |
|
Gross margin ($300,000 X 0.30) |
90,000 |
|
Estimated cost of goods sold |
|
210,000 |
Inventory at cost, estimated by gross margin method. |
|
$30,000 |
|
Cost |
Retail |
Merchandise Inventory, January 1 |
$17,600 |
$25,000 |
Purchases |
68,000 |
100,000 |
Transportation-in |
1,900 |
- |
Goods available for sale |
$87,500 |
$125,000 |
Cost/retail price ratio: |
||
$87,500/$125,000 = 70% |
||
Sales |
|
101,000 |
Ending inventory at retail price |
|
$24,000 |
Times cost/retail price ratio |
|
X 70% |
Ending inventory at cost, December 31. |
$16,800 |
|
Self-test
True-false
Indicate whether each of the following statements is true or false.
1. Overstated ending inventory results in an overstatement of cost of goods sold and an understatement of gross margin and net income.
2. In a period of rising prices, FIFO results in the lowest cost of goods sold.
3. Under LCM, inventory is written down to market value when the market value is less than the cost, and inventory is written up to market value when the market value is greater than the cost.
4. Under the gross margin method, an estimate must be made of gross margin to determine estimated cost of goods sold and estimated ending inventory.
5. To use the retail inventory method, both cost and retail prices must be known for the goods available for sale.
6. Under perpetual procedure, cost of goods sold is determined as a result of the closing entries made at the end of the period.
Multiple-choice
Select the best answer for each of the following questions.
Jack Company began the accounting period with inventory of 3,000 units at USD 30 each. During the period, the company purchased an additional 5,000 units at USD 36 each and sold 4,600 units.
Assume the use of periodic inventory procedure for the following six questions.
1. Cost of ending inventory using FIFO is:
- USD 104,400.
- USD 122,400.
- USD 120,000.
- USD 147,600.
- None of the above.
2. Cost of goods sold using FIFO is:
- USD 165,600.
- USD 150,000.
- USD 147,600.
- USD 122,400.
- None of the above.
3. Cost of ending inventory using LIFO is:
- USD 104,400.
- USD 114,750.
- USD 156,000.
- USD 122,400.
- None of the above.
4. Cost of goods sold using LIFO is:
- USD 155,250.
- USD 114,000.
- USD 147,600.
- USD 165,600.
- None of the above.
5. Cost of ending inventory using weighted-average is:
- USD 114,750.
- USD 157,600.
- USD 122,400.
- USD 109,650.
- None of the above.
6. Cost of goods sold using weighted-average is:
- USD 147,200.
- USD 160,350.
- USD 155,250.
- USD 114,000.
- None of the above.
7. During a period of rising prices, which inventory method might be expected to give the highest net income?
a. Weighted-average.
b. FIFO.
c. LIFO.
d. Specific identification.
e. Cannot determine.
Self-test - Answers
True-false
1. False. Overstated ending inventory results in an understatement of cost of goods sold and an overstatement of gross margin and net income.
2. True. The cost of goods sold consists of the earliest purchases at the lowest costs in a period of rising prices.
3. False. Under LCM, inventory is adjusted to market value only when the market (replacement) value is less than the cost.
4. True. The first step in the gross margin method is to estimate gross margin using the gross margin rate experienced in the past.
5. True. The cost/retail ratio is computed by dividing the cost of goods available for sale by the retail price of the goods available for sale.
6. False. Under perpetual procedure, the Cost of Goods Sold account is updated as sales occur.
Multiple-choice
1. b. The cost of ending inventory using FIFO consists of the most recent purchase:
2. c. The
cost of goods sold using FIFO is:
3. a. The cost of ending inventory using LIFO is:
4. d. The cost of goods sold using LIFO is:
5. a. The cost of ending inventory using weighted-average cost is computed:
6. c. The cost of goods sold using weighted-average cost is:
7. b. During a period of rising prices, FIFO results in the lowest cost of goods sold, thus the highest net income.