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
GEN COMBO LOOSELEAF INTERMEDIATE ACCOUNTING; CONNECT ACCESS CARD
- 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_forwardQuestion 3The League Company uses the LIFO (Last-in, First-out) costing method for its perpetual inventory system. It had inventory on 1st January 2021 consisting of 400 articles bought at RM4 each. The purchases during the month of January consisted of 800 at RM4.20 each purchased on 8 January, and 2,000 at RM3.80 each on 18 January. It sold 2,400 at RM5.00 each on 28 January. 40 of those sold were returned in perfect condition on 31 January. The returned goods were bought on 18 January. Required:a. i. Calculate, by means of an inventory account the number and cost of the articles held in inventory during January 2021. ii. The unit price and total cost of the inventory. b. Show the trading account for the month ended 31 January 2021.arrow_forwardBeginning 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_forward
- Question 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_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_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
- EA 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_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_forwardBrief 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_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_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_forwardPROBLEM 1 BTS Co. provided the following information relating to inventory for the month of December: Dec 1 7 12 17 22 28 Sale Beginning Purchase Sale Purchase Purchase Units 2. Moving Average - Periodic 3. Weighted Average- Perpetual 10,000 30,000 20,000 60,000 20,000 70,000 Unit Cost 52 50 45 43 REQUIRED: Compute the December 31 inventory and cost of goods sold under: 1. FIFO Unit Selling Price 90 90arrow_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