Concept explainers
Inventory: Inventory refers to the stock or goods which will be sold in the near future and thus is an asset for the company. It comprises of the raw materials which are yet to be processed, the stock which is still going through the process of production and it also includes completed products that are ready for sale. Thus inventory is the biggest and the important source of income and profit for the business.
Periodic inventory system: In periodic inventory system the changes in the stock items are reported periodically unlike recording as and when purchases or sales take place.
Cost of goods available for sale: It basically includes the cost of inventory which is ready for sale within an accounting period. It mainly includes the cost of beginning inventory as well as the stock purchased in that year and the production within that period (if any).
Cost of goods Sold: Cost of goods sold is the total expenses or the cost incurred by the business during the process of manufacturing of goods and is directly related to the production. It generally includes the cost of raw material, labor and other
Gross Profit: The profit made after subtracting or debiting the costs related to the goods sold from the total revenue earned or made through sales in a fiscal year is the gross profit.
Specific identification method: Under this method, there is a continuous tracking of the inventory and the inventory cost at the time of purchase on the basis of unique identity which thus helps in the valuation of the ending inventory as well as the cost of goods sold. This method is used generally when the company is involved in limited expensive goods which are easily identifiable.
Weighted average cost method: In this method the weighted average cost is evaluated after any purchases have been made and transactions are recorded as when purchase or sales take place.
First in first out: In case of First in, first out method, also known as FIFO method, the inventory which was bought first will also be the first one to be taken out.
Last in first out: In case of Last in, first out, also known as LIFO method, the inventory which was bought in the last will be taken out first.
To compute: 1. Cost of goods available for sale and number of units available for sale.
2. Number of units in ending inventory.
3. Cost of ending inventory under the methods mentoned below:
- (a) FIFO
(b) LIFO
(c) Weighted average
(d) Specific identification
4. Gross profit for each of the four methods in part 3.
5. The inventory costing method suitable incase of bonus earned on gross profit.
Explanation of Solution
Given info,
Units available for sale are 1,800 units.
Units of goods sold are 1,400 units.
1.
Cost of goods available for sale
Formula to calculate Cost of goods available for sale is,
Cost and units of goods available for sale:
Particulars | Number of units | Cost per unit($) | Amount($) |
Beginning Inventory | 600 | 45 | 27,000 |
Purchases: | |||
Feb 10 | 400 | 42 | 16,800 |
March 13 | 200 | 27 | 5,400 |
August 21 | 100 | 50 | 5,000 |
September 5 | 500 | 46 | 23,000 |
Total Purchases | 1,200 | 50,200 | |
Available for sale | 1,800 | 77,200 |
The cost of goods available for sale is $77,200 and the number of units available for sale is 1,800 units.
2.
Number of units in ending inventory
Particulars | Number of units |
Number of units available for sale (given) | 1,800 |
Less: units sold (given) | 1,400 |
Number of units in ending inventory | 400 |
The number of units in ending inventory is 400 units.
3.
(a)
First in First out method (FIFO)
Cost of ending inventory
Particulars | Amount($) |
Most recent cost; September 5: | |
400 units @ $46 per unit | 18,400 |
Total cost of the ending inventory | 18,400 |
Cost of goods sold
Formula to calculate cost of goods sold is,
Substitute $77,200 for cost of goods available for sale (calculated in (1) part) and $18,400 for cost of ending inventory (as calculated above in the table) in the above formula.
(b)
Last in First out method (LIFO)
Cost of ending inventory
Particulars | Amount($) |
Earliest cost; Jan 1: | |
400 units @ $45 per unit | 18,000 |
Total cost of the ending inventory | 18,000 |
Cost of goods sold
Formula to calculate cost of goods sold is,
Substitute $77,200 for cost of goods available for sale (calculated in (1) part) and $18,000 for cost of ending inventory (as calculated above in the table) in the above formula.
(c)
Weighted average method
Cost of ending inventory
Formula to calculate cost of ending inventory is,
Substitute 400 units for units in ending inventory (calculated in the (2) part) and $42.89 for weighted average cost per unit (working notes).in the above formula.
Cost of goods sold
Formula to calculate cost of goods sold is,
Substitute $77,200 for cost of goods available for sale (calculated in the (1) part) and $17,156 for cost of ending inventory (as calculated above) in the above formula.
Working Notes:
Calculation of weighted average cost per unit:
(d)
Specific identification method
Given info,
The ending inventory has,
100 units are from Feb 10,
50 units are from August 21 and
250 units are from September 5.
Cost of Ending Inventory
Date of Purchase | Number of units(A) | Cost per unit($)(B) | Amount($) |
Feb 10 | 100 | 42 | 4,200 |
August 21 | 50 | 50 | 2,500 |
September 5 | 250 | 46 | 11,500 |
Cost of Ending Inventory | 18,200 |
Cost of goods sold
Formula to calculate cost of goods sold is,
Substitute $77,200 for cost of goods available for sale (calculated in part (1)) and $18,200 for cost of ending inventory (calculated above in the table) in the above formula.
Under FIFO method, the cost of ending inventory is $18,400 and the cost of goods sold is $58,800.
Under LIFO method, the cost of ending inventory is $18,000 and the cost of goods sold is $59,200.
Under weighted average method, the cost of ending inventory is $17,156 and the cost of goods sold is $60,044.
Under specific identification, the cost of ending inventory is $18,200 and the cost of goods sold is $59,000.
4.
Sales are $50,900 (working notes).
Cost of goods sold in case of FIFO is $31,800. (Calculated in part (3(a))
Cost of goods sold in case LIFO is $33,400. (Calculated in part (3(b))
Cost of goods sold in case of weighted average is $32,960 and (Calculated in part (3(c))
Cost of goods sold in case of specific identification is 32,540. (Calculated in part (3(d))
Gross Profit
Formula to calculate gross profit is,
Particulars | FIFO | LIFO | Weighted average | Specific identification |
Sales(working notes) | $105,000 | $105,000 | $105,000 | $105,000 |
Less: Cost of goods sold | $58,800 | $59,200 | $60,044 | $59,000 |
Gross profit | $46,200 | $45,800 | $44,956 | $46,000 |
Working notes:
Calculation of sales
The gross profit in case of FIFO it is $46,200, of LIFO it is $45,800, of weighted average it is $44,956 and of specific identification it is $46,000.
5.
FIFO inventory method resulted in highest gross profit that is $46,200 as compared to other four methods.
Want to see more full solutions like this?
Chapter 5 Solutions
FINANCIAL ACCOUNTING FUNDAMENTALS W/ CO
- ( Appendix 6B) Inventory Costing Methods: Periodic Average Cost Refer to the information for Filimonov Inc. (p. 337) and assume that the company uses a periodic inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the average cost method. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest dollar.)arrow_forward( Appendix 6B) For each inventory costing method, perpetual and periodic systems yield the same amounts for ending inventory and cost of goods sold. Do you agree or disagree with this statement? Explain.arrow_forward( Appendix 6B) Inventory Costing Methods: Periodic Inventory Systems. Refer to the information for Tyler Company in Brief Exercise 6-35 and assume that the company uses the periodic inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. ( Note: Use four decimal places for per-unit calculations and round all other numbers to the nearest whole dollar.)arrow_forward
- ( Appendix 6B) Inventory Costing Methods: Periodic LIFO Refer to the information for Filimonov Inc. (p. 337) and assume that the company uses a periodic inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the LIFO inventory costing method.arrow_forward( Appendix 6B) Inventory Costing Methods: Periodic FIFO Refer to the information for Filimonov Inc. (p. 337) and assume that the company uses a periodic inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the FIFO inventory costing method.arrow_forwardCalculate a) cost of goods sold, b) ending inventory, and c) gross margin for B76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).arrow_forward
- Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for B76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).arrow_forwardInventory Write-Down Byron Company has five products in its inventory and uses the FIFO cost flow assumption. Specific data for each product are as follows: Required: 1. What is the correct inventory value, assuming the LCNRV rule is applied to each item of inventory? 2. What is the correct inventory value, assuming the LCNRV rule is applied to the total of inventory? 3. Next Level Comment on any differences that result from applying the LCNRV rule to individual items compared to the total of inventory.arrow_forwardCalculate a) cost of goods sold, b) ending inventory, and c) gross margin for B76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).arrow_forward
- Use the last-in, first-out method (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.arrow_forwardUse the first-in, first-out method (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.arrow_forwardEffects of Inventory Costing Methods Refer to your answers for Filimonov Inc. in Cornerstone Exercises 6-22 through 6-24. Required: 1. In a period of rising prices, which inventory costing method produces the highest amount for ending inventory? 2. In a period of rising prices, which inventory costing method produces the highest net income? 3. In a period of rising prices, which inventory costing method produces the lowest payment for income taxes? 4. In a period of rising prices, which inventory method generally produces the most realistic amount for cost of goods sold? For inventory? Would your answer change if inventory prices were decreasing during the period?arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College