Intermediate Accounting
Intermediate Accounting
9th Edition
ISBN: 9781259722660
Author: J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher: McGraw-Hill Education
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 8, Problem 8.5P

Various inventory costing methods

• LO8–1, LO8–4

Ferris Company began 2018 with 6,000 units of its principal product. The cost of each unit is $8. Merchandise transactions for the month of January 2018 are as follows:

Sales
Date of Sale Units
Jan. 5 3,000
Jan. 12 2,000
Jan. 20 4,000
Total 9,000

8,000 units were on hand at the end of the month.

Required:

Calculate January’s ending inventory and cost of goods sold for the month using each of the following alternatives:

1. FIFO, periodic system

2. LIFO, periodic system

3. LIFO, perpetual system

4. Average cost, periodic system

5. Average cost, perpetual system

1.

Expert Solution
Check Mark
To determine

Periodic Inventory System: It 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.

Perpetual Inventory System refers to the inventory system that maintains the detailed records of every inventory transactions related to purchases and sales on a continuous basis. It shows the exact on-hand-inventory at any point of time.

In First-in-First-Out method, the cost of initial purchased items are sold first. The value of the ending inventory consists the recent purchased items.

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

In Weighted-Average Cost Method the cost of inventory is priced at the average rate of the goods available for sale. Following is the mathematical representation:

Weighted-average Cost=Total Cost of Goods Available For SaleTotal Number of Units Available For Sale

To Compute: The ending inventory and cost of goods sold for the month of January under FIFO.

Explanation of Solution

Calculate the total cost and units of goods available for sales.

Table (1)

Calculate the cost of ending inventory under FIFO, periodic system.

Calculation of Cost of Ending Inventory (FIFO)
Details Number of Units Rate per Unit ($) Total Cost ($)
January 18 6,000 10 60,000
January 10 2,000 9 18,000
Ending Inventory 8,000   78,000

Table (2)

Working note:

Calculate the Cost of Goods Sold.

Cost of goods sold = Goods available for sale  Ending inventory=$153,000 $78,000=$75,000

Therefore, the cost of goods sold in the FIFO method is $78,000.

2.

Expert Solution
Check Mark
To determine

To Compute: The ending inventory and cost of goods sold for the month of January under LIFO.

Explanation of Solution

Calculate the cost of ending inventory under LIFO, periodic system.

Calculation of Cost of Ending Inventory (LIFO)
Details Number of Units Rate per Unit ($) Total Cost ($)
Beginning Balance 6,000 8 48,000
January 10 2,000 9 18,000
Ending Inventory 8,000   66,000

Table (3)

Therefore, the cost of ending inventory in the LIFO method is $66,000.

Calculate the Cost of Goods Sold.

Cost of goods sold = Goods available for sale  Ending inventory=$153,000 $66,000=$87,000

Therefore, the cost of goods sold in the LIFO method is $87,000.

3.

Expert Solution
Check Mark
To determine

To Compute: The ending inventory and cost of goods sold for the month of January under LIFO perpetual system.

Explanation of Solution

Calculate the cost of ending inventory under LIFO, perpetual system.

Table (4)

Therefore, the cost of ending merchandised inventory and cost of goods sold are $71,000 and $82,000 respectively.

4.

Expert Solution
Check Mark
To determine

To Compute: The ending inventory and cost of goods sold for the month of January under average cost periodic system.

Explanation of Solution

Calculate the cost of ending inventory under average cost, periodic system.

Number of units in ending inventory = 8,000

Weighted average cost per unit = $9 (1)

Cost of Ending inventory = (Number of units in Ending inventory × Weighted-average cost per unit)=8,000 units ×$9.00=$72,000

Working Note:

Calculate the Weighted-average cost.

Weighted-average Cost=Total Cost of Goods Available For SaleTotal number of units Available for Sale=$153,00017,000 Units=$9.00 (1)

Therefore, the cost of ending inventory in the Average-cost method is $72,000.

Calculate the Cost of Goods Sold.

Cost of goods sold = Goods available for sale  Ending inventory=$153,000$72,000=$81,000

Therefore, the cost of goods sold in the Average-cost method is $81,000.

5.

Expert Solution
Check Mark
To determine

To Compute: The ending inventory and cost of goods sold for the month of January under average cost perpetual system.

Explanation of Solution

Calculate the cost of ending inventory under average cost, perpetual system.

Table (5)

Working Notes:

Calculate the Weighted-average cost after the January 10th purchase.

Weighted-average Cost=(Total Cost of Goods Available For Sale after the purchase of January 10)Total number of units Available for Sale=$69,0008,000 Units=$8.625 (2)

Calculate the Weighted-average cost after the January 18th purchase.

Weighted-average Cost=(Total Cost of Goods Available For Sale after the purchase of January 18)Total number of units Available for Sale=$111,75012,000 Units=$9.3125 (3)

Therefore, the cost of ending merchandised inventory and cost of goods sold are 74,500 and $78,500 respectively.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
View Policies Current Attempt in Progress Sheffield Limited uses the average cost formula in a perpetual inventory system. Fill in the missing amounts for items [1] to [13]in the following perpetual inventory schedule. (Round per unit cost and total cost to 2 decimal places, e.g. 15.23.) Purchases Date Units Cost Total Units Cost April 1 6 29 [1] $ $5,742 26 [5] $ 14 [10] $201 $2,211 eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answer
Question 9 of 13 > 0/1 Larkspur, Inc. uses a periodic inventory system and reports the following for the month of June. Unit Date Explanation Units Cost Total Cost June 1 Inventory 130 $5 $ 650 12 Purchase 340 6 2,040 23 Purchase 200 1,400 30 Inventory 203 (a) X Your answer is incorrect. Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round per unit cost to 3 decimal places, e.g. 15.647 and final answers to 0 decimal places, e.g. 5,125.) FIFO LIFO Average-cost Cost of the ending inventory 2$ 1640 1310 $ 1464 Cost of goods sold 2$ 2630 2$ 2960 2$ 2806
Му Home eВook Print Item Akira Company had the following transactions for the month. Number Total of Units Cost Beginning inventory 130 $1,300 Purchased Mar. 31 190 2,280 Purchased Oct. 15 160 2,400 Total goods available for sale 480 5,980 Ending inventory 50 Calculate the gross margin for the period for each of the following cost allocation methods, using periodic inventory updating. Assume that all units were sold for $25 each. Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar amount. Gross Margin A. First-in, First-out (FIFO) %24 B. Last-in, First-out (LIFO) %$4 C. Weighted Average (AVG) Feedback Check My Work Calculate the sales amount by applying the appropriate costing method (FIFO, LIFO, Weighted-average cost). Determine the cost of goods sold amount (total inventory available less the ending inventory balance). These two figures are needed to calculate the gross margin. Check My Work Previous Next %24

Chapter 8 Solutions

Intermediate Accounting

Ch. 8 - Prob. 8.11QCh. 8 - Describe the ratios used by financial analysts to...Ch. 8 - Prob. 8.13QCh. 8 - Prob. 8.14QCh. 8 - The Austin Company uses the dollar-value LIFO...Ch. 8 - Identify any differences between U.S. GAAP and...Ch. 8 - Determining ending inventory; periodic system ...Ch. 8 - Prob. 8.2BECh. 8 - Prob. 8.3BECh. 8 - Purchas e discounts; gross method LO83 On...Ch. 8 - Prob. 8.5BECh. 8 - Prob. 8.6BECh. 8 - Inventor y cost flow methods; perpetual system ...Ch. 8 - LIFO method LO84 Esquire Inc. uses the LIFO...Ch. 8 - LIFO method LO84 AAA Hardware uses the LIFO...Ch. 8 - LIFO liquidation LO86 Refer to the situation...Ch. 8 - Prob. 8.11BECh. 8 - Ratio analysis LO87 Selected financial statement...Ch. 8 - Dollar-value LIFO LO88 At the beginning of 2018,...Ch. 8 - Perpetual inventory system; journal entries LO81...Ch. 8 - Prob. 8.2ECh. 8 - Determining cost of goods sold; periodic inventory...Ch. 8 - Perpetual and periodic inventory systems compared ...Ch. 8 - Prob. 8.6ECh. 8 - Goods in transit; consignment LO82 The December...Ch. 8 - Physical quantities and costs included in...Ch. 8 - Prob. 8.9ECh. 8 - Prob. 8.10ECh. 8 - Prob. 8.11ECh. 8 - FASB codification research LO82, LO83 Access the...Ch. 8 - Inventory cost flow methods; periodic system ...Ch. 8 - Inventory cost flow methods; perpetual system ...Ch. 8 - Comparison of FIFO and LIFO; periodic system ...Ch. 8 - Average cost method; periodic and perpetual...Ch. 8 - FIFO, LIFO, and average cost methods LO81, LO84...Ch. 8 - Supplemental LIFO disclosures; LIFO reserve; AEP...Ch. 8 - LIFO liquidation LO81, LO84, LO86 The Reuschel...Ch. 8 - Dollar-value LIFO LO88 On January 1, 2018, the...Ch. 8 - Dollar-value LIFO LO88 Mercury Company has only...Ch. 8 - Dollar-value LIFO LO88 Carswell Electronics...Ch. 8 - Concepts; terminology LO81 through LO85 Listed...Ch. 8 - Various inventory transactions; journal entries ...Ch. 8 - Prob. 8.2PCh. 8 - Prob. 8.4PCh. 8 - Various inventory costing methods LO81, LO84...Ch. 8 - Various inventory costing methods LO81, LO84...Ch. 8 - Supple mental LIFO disclosures; Caterpillar LO84,...Ch. 8 - LIFO liquidation LO84, LO86 Taylor Corporation...Ch. 8 - LIFO liquidation LO84, LO86 Cansela Corporation...Ch. 8 - Prob. 8.11PCh. 8 - Integrating problem; inventories and accounts...Ch. 8 - Dollar-value LIFO LO88 On January 1, 2018, the...Ch. 8 - Dollar-value LIFO LO88 Kingston Company uses the...Ch. 8 - Dollar-value LIFO LO88 On January 1, 2018,...Ch. 8 - Prob. 8.1BYPCh. 8 - Real World Case 82 Physical quantities and costs...Ch. 8 - Judgment Case 83 The specific identification...Ch. 8 - Prob. 8.4BYPCh. 8 - Prob. 8.5BYPCh. 8 - Judgment Case 86 Goods in transit LO82 At the end...Ch. 8 - Ethics Case 87 Profit manipulation LO84 In 2017...Ch. 8 - Real World Case 88 Effects of inventory valuation...Ch. 8 - Real World Case 89 Effects of inventory valuation...Ch. 8 - Communication Case 810 Dollar-value LIFO method ...Ch. 8 - Prob. 8.11BYPCh. 8 - Prob. 8.CCTCCh. 8 - Prob. CCIFRS
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Text book image
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Chapter 6 Merchandise Inventory; Author: Vicki Stewart;https://www.youtube.com/watch?v=DnrcQLD2yKU;License: Standard YouTube License, CC-BY
Accounting for Merchandising Operations Recording Purchases of Merchandise; Author: Socrat Ghadban;https://www.youtube.com/watch?v=iQp5UoYpG20;License: Standard Youtube License