Concept explainers
(a) (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.
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 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 cost of ending inventory and cost of goods sold using FIFO.
(a) (1)
Explanation of Solution
Calculate the ending inventory using FIFO method.
Calculation of ending inventory under FIFO Method | |||
Particulars | Units | Unit Cost ($) | Total Cost ($) |
(a) | (b) | [(c) = (a) × (b)] | |
June 12 | 30 | 6 | 180 |
June 23 | 200 | 7 | 1,400 |
Ending inventory | 230 | 1,580 |
Table (1)
Calculate the cost of goods sold using FIFO method.
FIFO Method | |||
Particulars | Units | Unit Cost ($) | Total Cost ($) |
(a) | (b) | [(c) = (a) × (b)] | |
Beginning inventory | 120 | 5 | 600 |
Add Purchases: | |||
June 12 | 370 | 6 | 2,220 |
June 23 | 200 | 7 | 1,400 |
Cost of goods available for sale | 4,220 | ||
Less: Ending inventory (Table 1) | 1,580 | ||
Cost of goods sold | 2,640 |
Table (2)
Therefore, the cost of ending inventory, and cost of goods sold under FIFO method is $1,580, and $2,640.
(2)
To Compute: The cost of ending inventory and cost of goods sold using, LIFO.
(2)
Explanation of Solution
Calculate the ending inventory using LIFO method.
Calculation of ending inventory under LIFO Method | |||
Particulars | Units | Unit Cost ($) | Total Cost ($) |
(a) | (b) | [(c) = (a) × (b)] | |
June 1 | 120 | 5 | 600 |
June 23 | 110 | 6 | 660 |
Ending inventory | 230 | 1,260 |
Table (3)
Calculate the cost of goods sold using LIFO method
LIFO Method | |||
Particulars | Units | Unit Cost ($) | Total Cost ($) |
(a) | (b) | [(c) = (a) × (b)] | |
Beginning inventory | 120 | 5 | 600 |
Add Purchases: | |||
June 12 | 370 | 6 | 2,220 |
June 23 | 200 | 7 | 1,400 |
Cost of goods available for sale | 4,220 | ||
Less: Ending inventory (Table 3) | 1,260 | ||
Cost of goods sold | 2,960 |
Table (4)
Therefore, the cost of ending inventory, and cost of goods sold under LIFO method is $1,260, and $2,960.
(3)
To Compute: The cost of ending inventory and cost of goods sold using Average-cost method.
(3)
Explanation of Solution
Calculate cost of ending inventory using Average-Cost method.
Ending inventory units = 230
Weighted average unit cost = $6.116 (1)
Calculate cost of goods sold using Average-Cost method.
Total units purchased = 460
Weighted average unit cost = $6.116 (1)
Working Notes:
Calculate weighted average unit cost.
Total cost of goods available for sale = $4,220 (Table 5)
Total number of units available for sale = 690 (Table 6)
Calculate the total cost of goods available for sale.
Particulars | Units | Unit Cost ($) | Total Cost ($) |
(a) | (b) | [(c) = (a) × (b)] | |
Beginning inventory | 120 | 5 | 600 |
Add Purchases: | |||
June 12 | 370 | 6 | 2,220 |
June 23 | 200 | 7 | 1,400 |
Cost of goods available for sale | 4,220 |
Table (5)
Calculate the total number of units available for sale.
Particulars | Units |
Beginning inventory | 120 |
Add Purchases: | |
June 12 | 370 |
June 23 | 200 |
Number of units available for sale | 690 |
Table (6)
Therefore, the cost of ending inventory, and cost of goods sold under average cost method is $1,406.68, and $2,813.36.
(b)
The costing method which gives highest inventory, and highest cost of goods sold.
(b)
Answer to Problem 6.7E
Details | FIFO ($) | LIFO ($) | Average-Cost ($) |
Ending Inventory |
1,580 (Highest) |
1,260 (Lowest) | 1406.68 |
Cost of Goods Sold |
2,640 (Lowest) |
2,960 (Highest) | 2,813.36 |
Table (7)
Explanation of Solution
FIFO method gives lowest cost of goods sold and highest closing inventory since cost of goods are lower in the beginning because purchases are at lower rate. LIFO method gives highest cost of goods sold and lowest closing inventory
Therefore, the FIFO method gives the highest ending inventory, and the LIFO method gives the highest cost of goods sold.
(c)
To Relate: The average-cost values for ending inventory, and cost of goods sold with ending inventory, and cost of goods for FIFO and LIFO.
(c)
Explanation of Solution
Average cost method calculates inventory issues based on average cost. Hence cost of goods sold will be higher than FIFO but lower than LIFO method in case of increasing cost of purchase.
Therefore, the ending inventory will be lower than FIFO and higher than LIFO method.
(d)
To Explain: The reason for the average cost
(d)
Explanation of Solution
The calculated average cost is shown in above computation is $6.116. In general average cost is calculated with the decimal points to get the correct values.
Want to see more full solutions like this?
Chapter 6 Solutions
FINANCIAL ACCOUNTING: TOOLS WP ACCESS
- Trini Company had the following transactions for the month. Calculate the ending inventory dollar value for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forwardBleistine Company had the following transactions for the month. Calculate the ending inventory dollar value for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forwardBleistine Company had the following transactions for the month. 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 $50 each. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forward
- DeForest Company had the following transactions for the month. Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forwardAkira Company had the following transactions for the month. 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_forwardCalculate the cost of goods sold dollar value for A66 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).arrow_forward
- Calculate the cost of goods sold dollar value for B67 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for weighted average (AVG).arrow_forwardCalculate the cost of goods sold dollar value for A65 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).arrow_forwardAlternative Inventory Methods Park Companys perpetual inventory records indicate the following transactions in the month of June: Required: 1. Compute the cost of goods sold for June and the inventory at the end of June using each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost (Round unit costs to 3 decimal places and other amounts to the nearest dollar.) 2. Next Level Why are the cost of goods sold and ending inventory amounts different for each of the three methods? What do these amounts tell us about the purchase price of inventory during the year? 3. Next Level Which method produces the most realistic amount for net income? For inventory? Explain your answer. 4. Next Level If Park uses IFRS, which of the previous alternatives would be acceptable and why?arrow_forward
- Data on the physical inventory of Ashwood Products Company as of December 31 follow: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost as well as at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item, proceed as follows: 1. Draw a line through the quantity and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the Lower of C or M column. The first item on the inventory sheet has been completed as an example.arrow_forwardData on the physical inventory of Katus Products Co. as of December 31 follow: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost as well as at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item: 1. Draw a line through the quantity and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the LCM column. The first item on the inventory sheet has been completed as an example.arrow_forwardAlternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred: Required: 1. Compute the cost of goods sold for November and the inventory at the end of November for each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost 2. Next Level What can you conclude about the effects of the inventory cost flow assumptions on the financial statements?arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,