Concept explainers
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.
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:
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.
Therefore, the cost of goods sold in the FIFO method is $78,000.
2.
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.
Therefore, the cost of goods sold in the LIFO method is $87,000.
3.
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.
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)
Working Note:
Calculate the Weighted-average cost.
Therefore, the cost of ending inventory in the Average-cost method is $72,000.
Calculate the Cost of Goods Sold.
Therefore, the cost of goods sold in the Average-cost method is $81,000.
5.
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.
Calculate the Weighted-average cost after the January 18th purchase.
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?
Chapter 8 Solutions
INTERMEDIATE ACCOUNTING RMU 9TH EDITION
- Inventory Costing Methods VanderMeer Inc. reported the following information for the month of February: During February, VanderMeer sold 140 units. The company uses a periodic inventory system. Required What is the value of ending inventory and cost of goods sold for February under the following assumptions: Of the 140 units sold, 55 cost $20, 35 cost $22, 45 cost $23, and 5 cost $24. FIFO LIFO Weighted averagearrow_forwardМу 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 %24arrow_forwardQuestion 5 Opening and closing inventory balances and purchases for the month of May2020for CardiniaHearing Ltd are as follows: Units Per unit 7,000 $4.00 Inventory, 1 May Purchase, 3 May Purchase, 15 May Purchase, 20 May Inventory, 31May 8,000 4.10 11,000 4.20 15,000 4.25 20,000 Required: Determine the cost of goods sold for May under each of the following cost flow assumptions: (a) FIFO (b) Weighted average (c) LIFOarrow_forward
- Beginning inventory, 9/1/2021 7,500 units @ $10.00 Purchases: 9/7 9/25 Sales: 9/10 9/29 14,000 units were on hand at the end of September. 4,500 units @ $10.40 12,000 units @ $11.75 4,000 units 6,000 units Required: 1. Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory. 2. Assuming that CNB uses a perpetual inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Assuming that CNB uses a periodic inventory system and employs the average cost method, determine cost of goods sold for September and September's ending inventory. (Round cost per unit to 2 decimal places.) Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Ending Inventory - Average Cost Cost of Goods Available for Sale Average Cost per…arrow_forwardEA 6. LO 10.2 Akira Company had the following transactions for the month. Cost per Unit $1,500 1,920 1,950 5,370 ? Beginning inventory Purchased Mar. 31 Purchased Oct. 15 Total goods available for sale Ending inventory Number of Units 150 160 130 440 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. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forwardQUESTION 14 Eneri Company's inventory records show the following data: Units Unit Cost Inventory, January 1 10,000 $9.20 Purchases: June 18 9,000 8.00 November 8 6,000 7.00 A physical inventory on December 31 shows 4,000 units on hand. Eneri uses the periodic inventory method. Under the FIFO method, the December 31 ending inventory is valued at $32,267. $32,960. O $28,000. O $36,800.arrow_forward
- Brief Exercise 8-06 Blue Company uses a periodic inventory system. For April, when the company sold 500 units, the following information is available. Units Unit Cost Total Cost April 1 inventory 290 $32 $ 9,280 April 15 purchase 430 38 16,340 April 23 purchase 280 42 11,760 1,000 $37,380 Compute the April 30 inventory and the April cost of goods sold using the LIFO method. Ending inventory $enter a dollar amount Cost of goods sold $enter a dollar amountarrow_forwardJan. 1 Inventory 4,000 units at $20 Apr. 19 Sale 2,500 units June 30 Purchase 6,000 units at $24 Sept. 2 Sale 4,500 units Nov. 15 Purchase 1,000 units at $25 How do you figure out the inventory cost and total cost when doing sale in the weighted average cost flow method under perpetual inventory system? The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of merchandise sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Round unit cost to two decimal places, if necessary. Schedule of Cost of Merchandise SoldWeighted Average Cost Flow Method Purchases Cost of Merchandise Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Jan. 1 $ $ Apr. 19 $ $ June 30 $ $ Sept. 2 Nov. 15 Dec. 31 Balances $ $ $arrow_forwardPeriod Inventory using FIFO & LIFO There are 15 units of the item in the physical inventory at December 31. Determine the inventory cost uniting the First-in, first-out (FIFO) and the last-in first-out(LIFO) method. (Round per unit cost two decimal places and your final answer to the nearest whole dollar.) Trying to create my spreadsheet to have it all setup. Thank you. Jan 1 Inventory 16 units $49 $784 Jul 7 Purchase 15 units $52 $780 Nov 23 Purchase 19 units $54 $1026 50 total units $2590 (Total) A. FIFO___________ B. LIFO __________arrow_forward
- Question 3 Seasons Limited would like to estimate the month end inventory by using the sales revenue earned during the month. It has the following sales and purchases information for the month of September to consider. Inventory, 1 September $500,000 Purchase 1,300,000 Freight-in 50,000 2,100,000 40,000 Sales Sales returns Purchase discounts 90,000 3 Required: (a) Compute the estimated inventory at 30 September, assuming the gross profit on selling price is 30%. (b) Compute the estimated inventory at 30 September, assuming the percentage mark up on cost is 33.33%.arrow_forwardCost Flow Methods The following three identical units of Item JC07 are purchased during April: April 2 April 15 April 20 Total Average cost per unit Item Beta Units Cost Purchase 1 $182 Purchase 1 183 Purchase 1 184 3 $549 $183 ($5493 units) Assume that A method of inventory costing in which the cost of the units sold and in ending Inventory is a weighted average of the purchase costs. (b) last-in, first-out (LIFO); and (c) weighted average cost method. Gross Profit Ending Inventory a. First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost $ $ $arrow_forwardLIFO perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three month period ending June 30 are as follows : date| transaction| #of units| per unit| total Apr 3 inventory 36 $225 $8,100 Apr 8 Purchase 72 $270 $19,440 Apr11 Sale 48 $750 $36,000 Apr30 Sale 30 $750 $22,500 May8 Purchase 60 $300 $18,000 May10 Sale 36 $750 $27,000 May19 Sale 18 $750 $13,500 May28 Purchase 60 $330 $19,800 Jun5 Sale 36 $790 $28,440 Jun16 Sale 48 $790 $37,920 Jun21 Purchase 108 $360 $38,880 Jun28 Sale 54 $790 $42,660 1. Record the inventory purchases and cost of merchandise sold data in a perpetual inventory records similar to the one illustrated an exhibit for using the last in…arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning