Concept explainers
Calculate inventory amounts when costs are rising (LO6–3)
During the year, TRC Corporation has the following inventory transactions.
For the entire year, the company sells 440 units of inventory for $60 each.
Required:
1. Using FIFO, calculate (a) ending inventory, (b) cost of goods sold, (c) sales revenue, and (d) gross profit.
2. Using LIFO, calculate (a) ending inventory, (b) cost of goods sold, (c) sales revenue, and (d) gross profit.
3. Using weighted-average cost, calculate (a) ending inventory, (b) cost of goods sold, (c) sales revenue, and (d) gross profit.
4. Determine which method will result in higher profitability when inventors' costs are rising.
1. (a)
To calculate: The cost of ending inventory.
Explanation of Solution
Perpetual Inventory System:
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.
First-in-First-Out:
In First-in-First-Out method, the costs of the initially purchased items are considered as cost of goods sold, for the items which are sold first. The value of the ending inventory consists of the recent purchased items.
Ending Inventory: It represents the quantity and price of the goods unsold and laying at the store at the end of a particular period.
- Calculate the cost of ending inventory:
Calculation of Cost of Ending Inventory | |||
Details | Number of Units | Rate per Unit ($) | Total Cost ($) |
October 6 | 50 | 48 | 2,400 |
Ending Inventory | 50 | 2,400 |
Table 1
Note:
- The ending inventory is 50 units.
- In FIFO method the ending inventory comprises of the inventory purchased last, because the inventory purchased first were sold first.
- Therefore, the ending inventory of 50 units from October 6th purchases.
Working notes:
- Calculate the total Cost and units of Goods Available for Sales:
Particulars | Number of units | Rate per unit ($) | Total cost ($) |
Beginning balance | 50 | 42 | 2,100 |
Add: Purchases | |||
April 7 | 130 | 44 | 5,720 |
July 16 | 200 | 47 | 9,400 |
October 6 | 110 | 48 | 5,280 |
Total Goods available for Sale | 490 | 22,500 |
Table 2
- Calculate the units of ending inventory:
Therefore, the cost of Ending Inventory in the FIFO is $2,400.
1. (b)
To calculate: The cost of goods sold.
Explanation of Solution
Cost of goods sold:
Cost of goods sold is the accumulate total of all direct cost incurred in manufacturing the goods or the products which has been sold during a period. Cost of goods sold involves direct material, direct labor, and manufacturing overheads.
Determine the cost of goods sold:
Particulars | Number of units | Rate per unit ($) | Total cost ($) |
Beginning balance | 50 | 42 | 2,100 |
Add: Purchases | |||
April 7 | 130 | 44 | 5,720 |
July 16 | 200 | 47 | 9,400 |
October6 [440 - (50+130+200)] |
60 |
48 |
2,880 |
Cost of goods sold | 440 | 20,100 |
Table 3
Note:
- units are sold.
- As it is FIFO method the earlier purchased items will sell first.
- Hence, the cost of goods sold will be the earlier purchased items.
Therefore, the cost of goods sold in the FIFO Method is $20,100.
1. (c)
To calculate: the Sales Revenue.
Explanation of Solution
Determine the amount of sales revenue:
Therefore, the sales revenue in FIFO method is $26,400.
1. (d)
To calculate: The gross profit.
Explanation of Solution
Gross profit is the difference between the sales and the cost of goods sold.
Calculate the gross profit:
Calculation of Gross Margin | |
Details | Amount ($) |
Sales | 26,400 (1) |
Less: Cost of Goods Sold (Refer to table 4) | ($20,100) |
Gross Margin | 6,300 |
Table 4
Therefore, the amount of Gross margin in FIFO method is $6,300.
2. (a)
To calculate: The cost of ending inventory.
Explanation of Solution
Perpetual Inventory System:
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.
Last-in-Last-Out:
In Last-in-First-Out method, the costs of last purchased items are considered as the cost of goods sold, for the items which are sold first. The value of the closing stock consists of the initial purchased items.
- Calculate the cost of ending inventory.
Calculation of Cost of Ending Inventory | |||
Details | Number of Units | Rate per Unit ($) | Total Cost ($) |
Beginning Inventory | 50 | 42 | 2,100 |
Ending Inventory | 50 | 42 | 2,100 |
Table 5
Note:
- The ending inventory is 50 units (Refer to Table 2).
- In LIFO method the ending inventory comprises of the inventory purchased first, because the inventory purchased last were sold first.
- Therefore, the ending inventory of 50 units is from the beginning inventory.
Therefore, the cost of Ending Inventory in the LIFO method is $2,100.
2. (b)
To calculate: The cost of goods sold.
Explanation of Solution
Cost of goods sold:
Cost of goods sold is the accumulate total of all direct cost incurred in manufacturing the goods or the products which has been sold during a period. Cost of goods sold involves direct material, direct labor, and manufacturing overheads.
Determine the cost of goods sold:
Particulars | Number of units | Rate per unit ($) | Total cost ($) |
October 6 | 110 | 48 | 5,280 |
July 16 | 200 | 47 | 9,400 |
April 7 | 130 | 44 | 5,720 |
Cost of goods sold | 440 | 20,400 |
Table 6
Note:
- units are sold.
- As it is LIFO method the recent purchased items will sell first.
- Hence, the cost of goods sold will be the recent purchased items.
Therefore, the Cost of Goods Sold in the LIFO Method is $20,400
2. (c)
To calculate: the Sales Revenue.
Explanation of Solution
Determine the amount of sales revenue:
Therefore, the sales revenue in LIFO method is $26,400.
2. (d)
To calculate: The gross profit.
Explanation of Solution
Gross profit is the difference between the sales and the cost of goods sold.
Calculate the gross profit:
Calculation of Gross Margin | |
Details | Amount ($) |
Sales | 26,400 (2) |
Less: Cost of Goods Sold (Refer to table 8) | ($20,400) |
Gross Margin | 6,000 |
Table 7
Therefore, the amount of Gross margin in LIFO method is $6,000.
3. (a)
To calculate: The cost of ending inventory.
Explanation of Solution
Perpetual Inventory System:
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.
Weighted-average cost method:
Under Weighted average cost method, the company calculates a new average cost after every purchase is made. It is determined by dividing the cost of goods available for sale by the units on hand.
- Calculate the cost of ending inventory:
Working note:
- Calculate the Weighted-average cost:
Therefore, the cost of Ending Inventory in the Weighted-average-cost Method is $45.91837.
3. (b)
To calculate: The cost of goods sold.
Explanation of Solution
Cost of goods sold:
Cost of goods sold is the accumulate total of all direct cost incurred in manufacturing the goods or the products which has been sold during a period. Cost of goods sold involves direct material, direct labor, and manufacturing overheads.
Calculate the Cost of Goods Sold.
Therefore, the Cost of goods sold in the Weighted-average-cost Method is $20,204.08
3. (c)
To calculate: the Sales Revenue.
Explanation of Solution
Determine the amount of sales revenue:
Therefore, the sales revenue in Weighted-average-cost Method is $26,400.
3. (d)
To calculate: The gross profit.
Explanation of Solution
Gross profit is the difference between the sales and the cost of goods sold.
Calculate the gross profit:
Calculation of Gross Margin | |
Details | Amount ($) |
Sales | 26,400 (7) |
Less: Cost of Goods Sold | (20,204.08) (5) |
Gross Margin | 6,195.92 |
Table 8
Therefore, the amount of Gross margin in Weighted-average-cost Method is $6,19592.
4.
Explanation of Solution
Compare the profitability in the three methods:
Methods | FIFO | LIFO | WA |
Gross Margin | $6,300 | $6,000 | 6,195.92 |
Table 9
The gross margin computed by using the LIFO method results higher profitability when inventory costs are rising in comparison to the other two methods.
Want to see more full solutions like this?
Chapter 6 Solutions
FIN. ACC. (LL) BARUCH EDITION W/ CONNECT
- LO1 If the ending inventory is overstated by 10,000, indicate what, if anything, is incorrect about the following: Cost of goods sold___________ Gross profit___________ Net income___________ Ending owners capital___________arrow_forwardCompany Elmira reported the following cost of goods sold but later realized that an error had been made in ending inventory for year 2021. The correct inventory amount for 2021 was 32,000. Once the error is corrected, (a) how much is the restated cost of goods sold for 2021? and (b) how much is the restated cost of goods sold for 2022?arrow_forwardKulsrud Company would like to estimate the current inventory level. Using the gross profit method and the following information, estimate the current inventory level for Kulsrud Company. Goods available for sale 100,000 Net sales 150,000 Normal gross profit as a percent of sales 40%arrow_forward
- Black Corporation uses the LIFO cost flow assumption. Each unit of its inventory has a net realizable value of 300, a normal profit margin of 35, and a current replacement cost of 250. Determine the amount per unit that should be used as the market value to apply the lower of cost or market rule to determine Blacks ending inventory.arrow_forwardIf Barcelona Companys ending inventory was actually $122,000, but the cost of consigned goods, with a cost value of $20,000 were accidentally included with the company assets, when making the year-end inventory adjustment, what would be the impact on the presentation of the balance sheet and income statement for the year that the error occurred, if any?arrow_forwardLast year, Nikkola Company had net sales of 2,299,500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average inventory. 2. Calculate the inventory turnover ratio. 3. Calculate the inventory turnover in days. 4. CONCEPTUAL CONNECTION Based on these ratios, does Nikkola appear to be performing well or poorly?arrow_forward
- Refer to the information for Morgan Inc. above. If Morgan uses a perpetual inventory system, what is the cost of ending inventory under FIFO at April 30? a. $32,500 b. $38,400 c. $63,600 d. $69,500arrow_forwardIf a group of inventory items costing $3,200 had been double counted during the year-end inventory count, what impact would the error have on the following inventory calculations? Indicate the effect (and amount) as either (a) none, (b) understated $______, or (c) overstated $______. Table 10.2arrow_forwardIf a group of inventory items costing $15,000 had been omitted from the year-end inventory count, what impact would the error have on the following inventory calculations? Indicate the effect (and amount) as either (a) none, (b) understated $______, or (c) overstated $______. Table 10.1arrow_forward
- Analyzing Inventory The recent financial statements of McLelland Clothing Inc. include the following data: Required: 1. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the FIFO inventory costing method. Be sure to explain what each ratio means. 2. Calculate McLellands gross profit ratio (rounded to two decimal places), inventory turnover ratio (rounded to three decimal places), and the average days to sell inventory (assume a 365-day year and round to two decimal places) using the LIFO inventory costing method. Be sure to explain what each ratio means. 3. CONCEPTUAL CONNECTION Which ratios-the ones computed using FIFO or LIFO inventory values-provide the better indicator of how successful McLelland was at managing and controlling its inventory?arrow_forwardBhushan Company has been using LIFO for inventory purposes because it would prefer to keep gross profits low for tax purposes. In its second year of operation (20-2), the controller pointed out that this strategy did not appear to work and suggested that FIFO cost of goods sold would have been higher than LIFO cost of goods sold for 20-2. Is this possible? REQUIRED Using the information provided, compute the cost of goods sold for 20-1 and 20-2 comparing the LIFO and FIFO methods.arrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIndividual Income TaxesAccountingISBN:9780357109731Author:HoffmanPublisher:CENGAGE LEARNING - CONSIGNMENT
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning